Can I map this problem

Home Page Forums BizTalk 2004 – BizTalk 2010 Can I map this problem

Viewing 1 reply thread
  • Author
    Posts
    • #22981

      this orchestration Calls an RFC to record time for several employees at one time. the return schema has error/warning information. Some information is a more generic warning (see BAPIRET2 ) when row = 0 I don’t want to do anything with the message. When row <> 0, I want to get some information out of the corresponding BAPICATS2 node. For instance, I would like to send employee id, Work order #, Date, Along with the message from BAPIRET2 to help users identify potential problems with time reporting.

      Can I accomplish that task?
      EXAMPLE XML Below

      Thanks in advance for any guidance.

      <BAPI_CATIMESHEETMGR_INSERTResponse xmlns=”http://Microsoft.LobServices.Sap/2007/03/Rfc/>
      <CATSRECORDS_IN>
        <WORKDATE>20090807</WORKDATE>
        <EMPLOYEENUMBER>39659</EMPLOYEENUMBER>
        <SEND_CCTR />
        <SENBUSPROC />
        <ACTTYPE />
        <PO_NUMBER />
        <PO_ITEM>0</PO_ITEM>
        <SERVICE />
        <REC_CCTR />
        <REC_ORDER>000003312282</REC_ORDER>
        <NETWORK />
        <ACTIVITY>0020</ACTIVITY>
        <SUB_ACTIVITY />
        <CAPA_CATEGORY />
        <SPLIT>0</SPLIT>
        <WORK_CNTR />
        <WBS_ELEMENT />
        <RECSALEORD />
        <RECITEM>0</RECITEM>
        <RECCOSTOBJ />
        <RECBUSPROC />
        <ABS_ATT_TYPE>REG</ABS_ATT_TYPE>
        <WAGETYPE />
        <TRIPNO>0</TRIPNO>
        <OT_COMP_TYPE />
        <WORKTAXAREA />
        <VALUATION_BASIS>0.0000</VALUATION_BASIS>
        <CURRENCY />
        <CURRENCY_ISO />
        <EXTRA_PAY_INDIC />
        <PAYSCALEGROUP />
        <PAYSCALELEVEL />
        <BONUSTYPE />
        <BONUSVALUE>0</BONUSVALUE>
        <POSITION>0</POSITION>
        <CO_AREA />
        <TRANS_CURR />
        <TRANS_CURR_ISO />
        <PRICE>0.0000</PRICE>
        <PLANT />
        <CALC_MOTIVE />
        <CATSHOURS>12.00</CATSHOURS>
        <UNIT />
        <ISOCODE_UNIT />
        <STARTTIME>000000</STARTTIME>
        <ENDTIME>000000</ENDTIME>
        <PREVIOUS_DAY />
        <ALL_DAY_FLAG />
        <REM_WORK>0.0</REM_WORK>
        <FCST_FIN_DATE>00000000</FCST_FIN_DATE>
        <FIN_CONF />
        <SHORTTEXT />
        <PART_CONF />
        <EXTSYSTEM />
        <EXTAPPLICATION />
        <EXTDOCUMENTNO />
        <STATKEYFIG />
        <QUANTITY>0.000</QUANTITY>
        <UNITQ />
        <ISO_UNITQ />
        <AMOUNT>0.0000</AMOUNT>
        <LONGTEXT />
        <FUND />
        <FUNC_AREA />
        <GRANT_NBR />
        <SEND_FUND />
        <SEND_FUNCTION />
        <SEND_GRANT />
        <CPR_GUID />
        <CPR_EXTID />
        <CPR_OBJGUID />
        <CPR_OBJGEXTID />
        <CPR_OBJTYPE />
        </BAPICATS1>
        <WORKDATE>20090807</WORKDATE>
        <EMPLOYEENUMBER>63630</EMPLOYEENUMBER>
        <SEND_CCTR />
        <SENBUSPROC />
        <ACTTYPE />
        <PO_NUMBER />
        <PO_ITEM>0</PO_ITEM>
        <SERVICE />
        <REC_CCTR />
        <REC_ORDER>000003312282</REC_ORDER>
        <NETWORK />
        <ACTIVITY>0020</ACTIVITY>
        <SUB_ACTIVITY />
        <CAPA_CATEGORY />
        <SPLIT>0</SPLIT>
        <WORK_CNTR />
        <WBS_ELEMENT />
        <RECSALEORD />
        <RECITEM>0</RECITEM>
        <RECCOSTOBJ />
        <RECBUSPROC />
        <ABS_ATT_TYPE>REG</ABS_ATT_TYPE>
        <WAGETYPE />
        <TRIPNO>0</TRIPNO>
        <OT_COMP_TYPE />
        <WORKTAXAREA />
        <VALUATION_BASIS>0.0000</VALUATION_BASIS>
        <CURRENCY />
        <CURRENCY_ISO />
        <EXTRA_PAY_INDIC />
        <PAYSCALEGROUP />
        <PAYSCALELEVEL />
        <BONUSTYPE />
        <BONUSVALUE>0</BONUSVALUE>
        <POSITION>0</POSITION>
        <CO_AREA />
        <TRANS_CURR />
        <TRANS_CURR_ISO />
        <PRICE>0.0000</PRICE>
        <PLANT />
        <CALC_MOTIVE />
        <CATSHOURS>6.00</CATSHOURS>
        <UNIT />
        <ISOCODE_UNIT />
        <STARTTIME>000000</STARTTIME>
        <ENDTIME>000000</ENDTIME>
        <PREVIOUS_DAY />
        <ALL_DAY_FLAG />
        <REM_WORK>0.0</REM_WORK>
        <FCST_FIN_DATE>00000000</FCST_FIN_DATE>
        <FIN_CONF />
        <SHORTTEXT />
        <PART_CONF />
        <EXTSYSTEM />
        <EXTAPPLICATION />
        <EXTDOCUMENTNO />
        <STATKEYFIG />
        <QUANTITY>0.000</QUANTITY>
        <UNITQ />
        <ISO_UNITQ />
        <AMOUNT>0.0000</AMOUNT>
        <LONGTEXT />
        <FUND />
        <FUNC_AREA />
        <GRANT_NBR />
        <SEND_FUND />
        <SEND_FUNCTION />
        <SEND_GRANT />
        <CPR_GUID />
        <CPR_EXTID />
        <CPR_OBJGUID />
        <CPR_OBJGEXTID />
        <CPR_OBJTYPE />
        </BAPICATS1>
        <WORKDATE>20090807</WORKDATE>
        <EMPLOYEENUMBER>24587</EMPLOYEENUMBER>
        <SEND_CCTR />
        <SENBUSPROC />
        <ACTTYPE />
        <PO_NUMBER />
        <PO_ITEM>0</PO_ITEM>
        <SERVICE />
        <REC_CCTR />
        <REC_ORDER>000003312282</REC_ORDER>
        <NETWORK />
        <ACTIVITY>0020</ACTIVITY>
        <SUB_ACTIVITY />
        <CAPA_CATEGORY />
        <SPLIT>0</SPLIT>
        <WORK_CNTR />
        <WBS_ELEMENT />
        <RECSALEORD />
        <RECITEM>0</RECITEM>
        <RECCOSTOBJ />
        <RECBUSPROC />
        <ABS_ATT_TYPE>REG</ABS_ATT_TYPE>
        <WAGETYPE />
        <TRIPNO>0</TRIPNO>
        <OT_COMP_TYPE />
        <WORKTAXAREA />
        <VALUATION_BASIS>0.0000</VALUATION_BASIS>
        <CURRENCY />
        <CURRENCY_ISO />
        <EXTRA_PAY_INDIC />
        <PAYSCALEGROUP />
        <PAYSCALELEVEL />
        <BONUSTYPE />
        <BONUSVALUE>0</BONUSVALUE>
        <POSITION>0</POSITION>
        <CO_AREA />
        <TRANS_CURR />
        <TRANS_CURR_ISO />
        <PRICE>0.0000</PRICE>
        <PLANT />
        <CALC_MOTIVE />
        <CATSHOURS>3.00</CATSHOURS>
        <UNIT />
        <ISOCODE_UNIT />
        <STARTTIME>000000</STARTTIME>
        <ENDTIME>000000</ENDTIME>
        <PREVIOUS_DAY />
        <ALL_DAY_FLAG />
        <REM_WORK>0.0</REM_WORK>
        <FCST_FIN_DATE>00000000</FCST_FIN_DATE>
        <FIN_CONF />
        <SHORTTEXT />
        <PART_CONF />
        <EXTSYSTEM />
        <EXTAPPLICATION />
        <EXTDOCUMENTNO />
        <STATKEYFIG />
        <QUANTITY>0.000</QUANTITY>
        <UNITQ />
        <ISO_UNITQ />
        <AMOUNT>0.0000</AMOUNT>
        <LONGTEXT />
        <FUND />
        <FUNC_AREA />
        <GRANT_NBR />
        <SEND_FUND />
        <SEND_FUNCTION />
        <SEND_GRANT />
        <CPR_GUID />
        <CPR_EXTID />
        <CPR_OBJGUID />
        <CPR_OBJGEXTID />
        <CPR_OBJTYPE />
        </BAPICATS1>
        </CATSRECORDS_IN>
      <CATSRECORDS_OUT>
        <COUNTER>000000000000</COUNTER>
        <WORKDATE>20090807</WORKDATE>
        <EMPLOYEENUMBER>0</EMPLOYEENUMBER>
        <SEND_CCTR />
        <SENBUSPROC />
        <ACTTYPE />
        <PO_NUMBER />
        <PO_ITEM>0</PO_ITEM>
        <SERVICE />
        <REC_CCTR />
        <REC_ORDER />
        <NETWORK />
        <AVTIVITY />
        <SUB_ACTIVITY />
        <WORK_CNTR />
        <CAPA_CATEGORY />
        <SPLIT>0</SPLIT>
        <WBS_ELEMENT />
        <RECSALEORD />
        <RECITEM>0</RECITEM>
        <RECCOSTOBJ />
        <RECBUSPROC />
        <ABS_ATT_TYPE />
        <WAGETYPE />
        <TRIPNO>0</TRIPNO>
        <OT_COMP_TYPE />
        <WORKTAXAREA />
        <VALUATION_BASIS>0.0000</VALUATION_BASIS>
        <CURRENCY />
        <CURRENCY_ISO />
        <EXTRA_PAY_INDIC />
        <PAYSCALEGROUP />
        <PAYSCALELEVEL />
        <BONUSTYPE />
        <BONUSVALUE>0</BONUSVALUE>
        <POSITION>0</POSITION>
        <CO_AREA />
        <TRANS_CURR />
        <TRANS_CURR_ISO />
        <PRICE>0.0000</PRICE>
        <PLANT />
        <CALC_MOTIVE />
        <CATSHOURS>0.00</CATSHOURS>
        <UNIT />
        <ISOCODE_UNIT />
        <STARTTIME>000000</STARTTIME>
        <ENDTIME>000000</ENDTIME>
        <PREVIOUS_DAY />
        <ALL_DAY_FLAG />
        <REM_WORK>0.0</REM_WORK>
        <FCST_FIN_DATE>00000000</FCST_FIN_DATE>
        <FIN_CONF />
        <SHORTTEXT />
        <PART_CONF />
        <EXTSYSTEM />
        <EXTAPPLICATION />
        <EXTDOCUMENTNO />
        <CREATIONDATE>00000000</CREATIONDATE>
        <ENTRYTIME>000000</ENTRYTIME>
        <CREATING_ADMIN />
        <LASTCHANGED_ON>00000000</LASTCHANGED_ON>
        <LASTCHANGED_AT>000000</LASTCHANGED_AT>
        <CHANGED_BY />
        <APPROVING_ADMIN />
        <DATE_OF_APPROVAL>00000000</DATE_OF_APPROVAL>
        <WORKITEMID>0</WORKITEMID>
        <LOG_SYSTEM />
        <STATUS />
        <REFCOUNTER />
        <REASON />
        <CATS_DOC_NO />
        <STATKEYFIG />
        <QUANTITY>0.000</QUANTITY>
        <UNITQ />
        <ISO_UNITQ />
        <AMOUNT>0.0000</AMOUNT>
        <LONGTEXT />
        <FUND />
        <FUNC_AREA />
        <GRANT_NBR />
        <SEND_FUND />
        <SEND_FUNCTION />
        <SEND_GRANT />
        <CPR_GUID />
        <CPR_EXTID />
        <CPR_OBJGUID />
        <CPR_OBJGEXTID />
        <CPR_OBJTYPE />
        </BAPICATS2>
        <COUNTER>000000000000</COUNTER>
        <WORKDATE>20090807</WORKDATE>
        <EMPLOYEENUMBER>0</EMPLOYEENUMBER>
        <SEND_CCTR />
        <SENBUSPROC />
        <ACTTYPE />
        <PO_NUMBER />
        <PO_ITEM>0</PO_ITEM>
        <SERVICE />
        <REC_CCTR />
        <REC_ORDER />
        <NETWORK />
        <AVTIVITY />
        <SUB_ACTIVITY />
        <WORK_CNTR />
        <CAPA_CATEGORY />
        <SPLIT>0</SPLIT>
        <WBS_ELEMENT />
        <RECSALEORD />
        <RECITEM>0</RECITEM>
        <RECCOSTOBJ />
        <RECBUSPROC />
        <ABS_ATT_TYPE />
        <WAGETYPE />
        <TRIPNO>0</TRIPNO>
        <OT_COMP_TYPE />
        <WORKTAXAREA />
        <VALUATION_BASIS>0.0000</VALUATION_BASIS>
        <CURRENCY />
        <CURRENCY_ISO />
        <EXTRA_PAY_INDIC />
        <PAYSCALEGROUP />
        <PAYSCALELEVEL />
        <BONUSTYPE />
        <BONUSVALUE>0</BONUSVALUE>
        <POSITION>0</POSITION>
        <CO_AREA />
        <TRANS_CURR />
        <TRANS_CURR_ISO />
        <PRICE>0.0000</PRICE>
        <PLANT />
        <CALC_MOTIVE />
        <CATSHOURS>0.00</CATSHOURS>
        <UNIT />
        <ISOCODE_UNIT />
        <STARTTIME>000000</STARTTIME>
        <ENDTIME>000000</ENDTIME>
        <PREVIOUS_DAY />
        <ALL_DAY_FLAG />
        <REM_WORK>0.0</REM_WORK>
        <FCST_FIN_DATE>00000000</FCST_FIN_DATE>
        <FIN_CONF />
        <SHORTTEXT />
        <PART_CONF />
        <EXTSYSTEM />
        <EXTAPPLICATION />
        <EXTDOCUMENTNO />
        <CREATIONDATE>00000000</CREATIONDATE>
        <ENTRYTIME>000000</ENTRYTIME>
        <CREATING_ADMIN />
        <LASTCHANGED_ON>00000000</LASTCHANGED_ON>
        <LASTCHANGED_AT>000000</LASTCHANGED_AT>
        <CHANGED_BY />
        <APPROVING_ADMIN />
        <DATE_OF_APPROVAL>00000000</DATE_OF_APPROVAL>
        <WORKITEMID>0</WORKITEMID>
        <LOG_SYSTEM />
        <STATUS />
        <REFCOUNTER />
        <REASON />
        <CATS_DOC_NO />
        <STATKEYFIG />
        <QUANTITY>0.000</QUANTITY>
        <UNITQ />
        <ISO_UNITQ />
        <AMOUNT>0.0000</AMOUNT>
        <LONGTEXT />
        <FUND />
        <FUNC_AREA />
        <GRANT_NBR />
        <SEND_FUND />
        <SEND_FUNCTION />
        <SEND_GRANT />
        <CPR_GUID />
        <CPR_EXTID />
        <CPR_OBJGUID />
        <CPR_OBJGEXTID />
        <CPR_OBJTYPE />
        </BAPICATS2>
        <COUNTER>000000000000</COUNTER>
        <WORKDATE>20090807</WORKDATE>
        <EMPLOYEENUMBER>0</EMPLOYEENUMBER>
        <SEND_CCTR />
        <SENBUSPROC />
        <ACTTYPE />
        <PO_NUMBER />
        <PO_ITEM>0</PO_ITEM>
        <SERVICE />
        <REC_CCTR />
        <REC_ORDER />
        <NETWORK />
        <AVTIVITY />
        <SUB_ACTIVITY />
        <WORK_CNTR />
        <CAPA_CATEGORY />
        <SPLIT>0</SPLIT>
        <WBS_ELEMENT />
        <RECSALEORD />
        <RECITEM>0</RECITEM>
        <RECCOSTOBJ />
        <RECBUSPROC />
        <ABS_ATT_TYPE />
        <WAGETYPE />
        <TRIPNO>0</TRIPNO>
        <OT_COMP_TYPE />
        <WORKTAXAREA />
        <VALUATION_BASIS>0.0000</VALUATION_BASIS>
        <CURRENCY />
        <CURRENCY_ISO />
        <EXTRA_PAY_INDIC />
        <PAYSCALEGROUP />
        <PAYSCALELEVEL />
        <BONUSTYPE />
        <BONUSVALUE>0</BONUSVALUE>
        <POSITION>0</POSITION>
        <CO_AREA />
        <TRANS_CURR />
        <TRANS_CURR_ISO />
        <PRICE>0.0000</PRICE>
        <PLANT />
        <CALC_MOTIVE />
        <CATSHOURS>0.00</CATSHOURS>
        <UNIT />
        <ISOCODE_UNIT />
        <STARTTIME>000000</STARTTIME>
        <ENDTIME>000000</ENDTIME>
        <PREVIOUS_DAY />
        <ALL_DAY_FLAG />
        <REM_WORK>0.0</REM_WORK>
        <FCST_FIN_DATE>00000000</FCST_FIN_DATE>
        <FIN_CONF />
        <SHORTTEXT />
        <PART_CONF />
        <EXTSYSTEM />
        <EXTAPPLICATION />
        <EXTDOCUMENTNO />
        <CREATIONDATE>00000000</CREATIONDATE>
        <ENTRYTIME>000000</ENTRYTIME>
        <CREATING_ADMIN />
        <LASTCHANGED_ON>00000000</LASTCHANGED_ON>
        <LASTCHANGED_AT>000000</LASTCHANGED_AT>
        <CHANGED_BY />
        <APPROVING_ADMIN />
        <DATE_OF_APPROVAL>00000000</DATE_OF_APPROVAL>
        <WORKITEMID>0</WORKITEMID>
        <LOG_SYSTEM />
        <STATUS />
        <REFCOUNTER />
        <REASON />
        <CATS_DOC_NO />
        <STATKEYFIG />
        <QUANTITY>0.000</QUANTITY>
        <UNITQ />
        <ISO_UNITQ />
        <AMOUNT>0.0000</AMOUNT>
        <LONGTEXT />
        <FUND />
        <FUNC_AREA />
        <GRANT_NBR />
        <SEND_FUND />
        <SEND_FUNCTION />
        <SEND_GRANT />
        <CPR_GUID />
        <CPR_EXTID />
        <CPR_OBJGUID />
        <CPR_OBJGEXTID />
        <CPR_OBJTYPE />
        </BAPICATS2>
        <COUNTER>000000092076</COUNTER>
        <WORKDATE>20090807</WORKDATE>
        <EMPLOYEENUMBER>39659</EMPLOYEENUMBER>
        <SEND_CCTR>0000014100</SEND_CCTR>
        <SENBUSPROC />
        <ACTTYPE>REGAF</ACTTYPE>
        <PO_NUMBER />
        <PO_ITEM>0</PO_ITEM>
        <SERVICE />
        <REC_CCTR />
        <REC_ORDER>000003312282</REC_ORDER>
        <NETWORK />
        <AVTIVITY>0020</AVTIVITY>
        <SUB_ACTIVITY />
        <WORK_CNTR>LCDB</WORK_CNTR>
        <CAPA_CATEGORY />
        <SPLIT>0</SPLIT>
        <WBS_ELEMENT />
        <RECSALEORD />
        <RECITEM>0</RECITEM>
        <RECCOSTOBJ />
        <RECBUSPROC />
        <ABS_ATT_TYPE>REG</ABS_ATT_TYPE>
        <WAGETYPE />
        <TRIPNO>0</TRIPNO>
        <OT_COMP_TYPE />
        <WORKTAXAREA />
        <VALUATION_BASIS>0.0000</VALUATION_BASIS>
        <CURRENCY />
        <CURRENCY_ISO />
        <EXTRA_PAY_INDIC />
        <PAYSCALEGROUP />
        <PAYSCALELEVEL />
        <BONUSTYPE />
        <BONUSVALUE>0</BONUSVALUE>
        <POSITION>0</POSITION>
        <CO_AREA>1000</CO_AREA>
        <TRANS_CURR />
        <TRANS_CURR_ISO />
        <PRICE>0.0000</PRICE>
        <PLANT>1000</PLANT>
        <CALC_MOTIVE />
        <CATSHOURS>12.00</CATSHOURS>
        <UNIT>H</UNIT>
        <ISOCODE_UNIT>HUR</ISOCODE_UNIT>
        <STARTTIME>000000</STARTTIME>
        <ENDTIME>000000</ENDTIME>
        <PREVIOUS_DAY />
        <ALL_DAY_FLAG />
        <REM_WORK>0.0</REM_WORK>
        <FCST_FIN_DATE>20090807</FCST_FIN_DATE>
        <FIN_CONF />
        <SHORTTEXT />
        <PART_CONF />
        <EXTSYSTEM />
        <EXTAPPLICATION />
        <EXTDOCUMENTNO />
        <CREATIONDATE>20090807</CREATIONDATE>
        <ENTRYTIME>062603</ENTRYTIME>
        <CREATING_ADMIN>BIZTALK</CREATING_ADMIN>
        <LASTCHANGED_ON>20090807</LASTCHANGED_ON>
        <LASTCHANGED_AT>062603</LASTCHANGED_AT>
        <CHANGED_BY>BIZTALK</CHANGED_BY>
        <APPROVING_ADMIN />
        <DATE_OF_APPROVAL>00000000</DATE_OF_APPROVAL>
        <WORKITEMID>831277</WORKITEMID>
        <LOG_SYSTEM>ECQCLNT100</LOG_SYSTEM>
        <STATUS>20</STATUS>
        <REFCOUNTER />
        <REASON />
        <CATS_DOC_NO />
        <STATKEYFIG />
        <QUANTITY>12.000</QUANTITY>
        <UNITQ>H</UNITQ>
        <ISO_UNITQ>HUR</ISO_UNITQ>
        <AMOUNT>0.0000</AMOUNT>
        <LONGTEXT />
        <FUND />
        <FUNC_AREA />
        <GRANT_NBR />
        <SEND_FUND />
        <SEND_FUNCTION />
        <SEND_GRANT />
        <CPR_GUID />
        <CPR_EXTID />
        <CPR_OBJGUID />
        <CPR_OBJGEXTID />
        <CPR_OBJTYPE />
        </BAPICATS2>
        <COUNTER>000000092077</COUNTER>
        <WORKDATE>20090807</WORKDATE>
        <EMPLOYEENUMBER>63630</EMPLOYEENUMBER>
        <SEND_CCTR>0000014100</SEND_CCTR>
        <SENBUSPROC />
        <ACTTYPE>REGBF</ACTTYPE>
        <PO_NUMBER />
        <PO_ITEM>0</PO_ITEM>
        <SERVICE />
        <REC_CCTR />
        <REC_ORDER>000003312282</REC_ORDER>
        <NETWORK />
        <AVTIVITY>0020</AVTIVITY>
        <SUB_ACTIVITY />
        <WORK_CNTR>LCDB</WORK_CNTR>
        <CAPA_CATEGORY />
        <SPLIT>0</SPLIT>
        <WBS_ELEMENT />
        <RECSALEORD />
        <RECITEM>0</RECITEM>
        <RECCOSTOBJ />
        <RECBUSPROC />
        <ABS_ATT_TYPE>REG</ABS_ATT_TYPE>
        <WAGETYPE />
        <TRIPNO>0</TRIPNO>
        <OT_COMP_TYPE />
        <WORKTAXAREA />
        <VALUATION_BASIS>0.0000</VALUATION_BASIS>
        <CURRENCY />
        <CURRENCY_ISO />
        <EXTRA_PAY_INDIC />
        <PAYSCALEGROUP />
        <PAYSCALELEVEL />
        <BONUSTYPE />
        <BONUSVALUE>0</BONUSVALUE>
        <POSITION>0</POSITION>
        <CO_AREA>1000</CO_AREA>
        <TRANS_CURR />
        <TRANS_CURR_ISO />
        <PRICE>0.0000</PRICE>
        <PLANT>1000</PLANT>
        <CALC_MOTIVE />
        <CATSHOURS>6.00</CATSHOURS>
        <UNIT>H</UNIT>
        <ISOCODE_UNIT>HUR</ISOCODE_UNIT>
        <STARTTIME>000000</STARTTIME>
        <ENDTIME>000000</ENDTIME>
        <PREVIOUS_DAY />
        <ALL_DAY_FLAG />
        <REM_WORK>0.0</REM_WORK>
        <FCST_FIN_DATE>20090807</FCST_FIN_DATE>
        <FIN_CONF />
        <SHORTTEXT />
        <PART_CONF />
        <EXTSYSTEM />
        <EXTAPPLICATION />
        <EXTDOCUMENTNO />
        <CREATIONDATE>20090807</CREATIONDATE>
        <ENTRYTIME>062603</ENTRYTIME>
        <CREATING_ADMIN>BIZTALK</CREATING_ADMIN>
        <LASTCHANGED_ON>20090807</LASTCHANGED_ON>
        <LASTCHANGED_AT>062603</LASTCHANGED_AT>
        <CHANGED_BY>BIZTALK</CHANGED_BY>
        <APPROVING_ADMIN />
        <DATE_OF_APPROVAL>00000000</DATE_OF_APPROVAL>
        <WORKITEMID>832141</WORKITEMID>
        <LOG_SYSTEM>ECQCLNT100</LOG_SYSTEM>
        <STATUS>20</STATUS>
        <REFCOUNTER />
        <REASON />
        <CATS_DOC_NO />
        <STATKEYFIG />
        <QUANTITY>6.000</QUANTITY>
        <UNITQ>H</UNITQ>
        <ISO_UNITQ>HUR</ISO_UNITQ>
        <AMOUNT>0.0000</AMOUNT>
        <LONGTEXT />
        <FUND />
        <FUNC_AREA />
        <GRANT_NBR />
        <SEND_FUND />
        <SEND_FUNCTION />
        <SEND_GRANT />
        <CPR_GUID />
        <CPR_EXTID />
        <CPR_OBJGUID />
        <CPR_OBJGEXTID />
        <CPR_OBJTYPE />
        </BAPICATS2>
        <COUNTER>000000092078</COUNTER>
        <WORKDATE>20090807</WORKDATE>
        <EMPLOYEENUMBER>24587</EMPLOYEENUMBER>
        <SEND_CCTR>0000015506</SEND_CCTR>
        <SENBUSPROC />
        <ACTTYPE>REGBF</ACTTYPE>
        <PO_NUMBER />
        <PO_ITEM>0</PO_ITEM>
        <SERVICE />
        <REC_CCTR />
        <REC_ORDER>000003312282</REC_ORDER>
        <NETWORK />
        <AVTIVITY>0020</AVTIVITY>
        <SUB_ACTIVITY />
        <WORK_CNTR>LCDB</WORK_CNTR>
        <CAPA_CATEGORY />
        <SPLIT>0</SPLIT>
        <WBS_ELEMENT />
        <RECSALEORD />
        <RECITEM>0</RECITEM>
        <RECCOSTOBJ />
        <RECBUSPROC />
        <ABS_ATT_TYPE>REG</ABS_ATT_TYPE>
        <WAGETYPE />
        <TRIPNO>0</TRIPNO>
        <OT_COMP_TYPE />
        <WORKTAXAREA />
        <VALUATION_BASIS>0.0000</VALUATION_BASIS>
        <CURRENCY />
        <CURRENCY_ISO />
        <EXTRA_PAY_INDIC />
        <PAYSCALEGROUP />
        <PAYSCALELEVEL />
        <BONUSTYPE />
        <BONUSVALUE>0</BONUSVALUE>
        <POSITION>0</POSITION>
        <CO_AREA>1000</CO_AREA>
        <TRANS_CURR />
        <TRANS_CURR_ISO />
        <PRICE>0.0000</PRICE>
        <PLANT>1000</PLANT>
        <CALC_MOTIVE />
        <CATSHOURS>3.00</CATSHOURS>
        <UNIT>H</UNIT>
        <ISOCODE_UNIT>HUR</ISOCODE_UNIT>
        <STARTTIME>000000</STARTTIME>
        <ENDTIME>000000</ENDTIME>
        <PREVIOUS_DAY />
        <ALL_DAY_FLAG />
        <REM_WORK>0.0</REM_WORK>
        <FCST_FIN_DATE>20090807</FCST_FIN_DATE>
        <FIN_CONF />
        <SHORTTEXT />
        <PART_CONF />
        <EXTSYSTEM />
        <EXTAPPLICATION />
        <EXTDOCUMENTNO />
        <CREATIONDATE>20090807</CREATIONDATE>
        <ENTRYTIME>062603</ENTRYTIME>
        <CREATING_ADMIN>BIZTALK</CREATING_ADMIN>
        <LASTCHANGED_ON>20090807</LASTCHANGED_ON>
        <LASTCHANGED_AT>062603</LASTCHANGED_AT>
        <CHANGED_BY>BIZTALK</CHANGED_BY>
        <APPROVING_ADMIN />
        <DATE_OF_APPROVAL>00000000</DATE_OF_APPROVAL>
        <WORKITEMID>829878</WORKITEMID>
        <LOG_SYSTEM>ECQCLNT100</LOG_SYSTEM>
        <STATUS>20</STATUS>
        <REFCOUNTER />
        <REASON />
        <CATS_DOC_NO />
        <STATKEYFIG />
        <QUANTITY>3.000</QUANTITY>
        <UNITQ>H</UNITQ>
        <ISO_UNITQ>HUR</ISO_UNITQ>
        <AMOUNT>0.0000</AMOUNT>
        <LONGTEXT />
        <FUND />
        <FUNC_AREA />
        <GRANT_NBR />
        <SEND_FUND />
        <SEND_FUNCTION />
        <SEND_GRANT />
        <CPR_GUID />
        <CPR_EXTID />
        <CPR_OBJGUID />
        <CPR_OBJGEXTID />
        <CPR_OBJTYPE />
        </BAPICATS2>
        </CATSRECORDS_OUT>
      <RETURN>
        <TYPE>W</TYPE>
        <ID>LR</ID>
        <NUMBER>51</NUMBER>
        <MESSAGE>More than 24 hours entered for personnel number 00024587 on 08/06/2009</MESSAGE>
        <LOG_NO />
        <LOG_MSG_NO>0</LOG_MSG_NO>
        <MESSAGE_V1>00024587</MESSAGE_V1>
        <MESSAGE_V2>08/06/2009</MESSAGE_V2>
        <MESSAGE_V3 />
        <MESSAGE_V4 />
        <PARAMETER>CATSRECORDS_IN</PARAMETER>
        <ROW>0</ROW>
        <FIELD />
        <SYSTEM>ECQCLNT100</SYSTEM>
        </BAPIRET2>
        <TYPE>W</TYPE>
        <ID>LR</ID>
        <NUMBER>51</NUMBER>
        <MESSAGE>More than 24 hours entered for personnel number 00039659 on 08/06/2009</MESSAGE>
        <LOG_NO />
        <LOG_MSG_NO>0</LOG_MSG_NO>
        <MESSAGE_V1>00039659</MESSAGE_V1>
        <MESSAGE_V2>08/06/2009</MESSAGE_V2>
        <MESSAGE_V3 />
        <MESSAGE_V4 />
        <PARAMETER>CATSRECORDS_IN</PARAMETER>
        <ROW>0</ROW>
        <FIELD />
        <SYSTEM>ECQCLNT100</SYSTEM>
        </BAPIRET2>
        <TYPE>W</TYPE>
        <ID>LR</ID>
        <NUMBER>51</NUMBER>
        <MESSAGE>More than 24 hours entered for personnel number 00063630 on 08/06/2009</MESSAGE>
        <LOG_NO />
        <LOG_MSG_NO>0</LOG_MSG_NO>
        <MESSAGE_V1>00063630</MESSAGE_V1>
        <MESSAGE_V2>08/06/2009</MESSAGE_V2>
        <MESSAGE_V3 />
        <MESSAGE_V4 />
        <PARAMETER>CATSRECORDS_IN</PARAMETER>
        <ROW>0</ROW>
        <FIELD />
        <SYSTEM>ECQCLNT100</SYSTEM>
        </BAPIRET2>
        <TYPE>W</TYPE>
        <ID>LR</ID>
        <NUMBER>206</NUMBER>
        <MESSAGE>Number of hours recorded 24.00 exceeds target hours 8.00</MESSAGE>
        <LOG_NO />
        <LOG_MSG_NO>0</LOG_MSG_NO>
        <MESSAGE_V1>24.00</MESSAGE_V1>
        <MESSAGE_V2>8.00</MESSAGE_V2>
        <MESSAGE_V3 />
        <MESSAGE_V4 />
        <PARAMETER>CATSRECORDS_IN</PARAMETER>
        <ROW>1</ROW>
        <FIELD />
        <SYSTEM>ECQCLNT100</SYSTEM>
        </BAPIRET2>
        <TYPE>W</TYPE>
        <ID>LR</ID>
        <NUMBER>206</NUMBER>
        <MESSAGE>Number of hours recorded 12.00 exceeds target hours 8.00</MESSAGE>
        <LOG_NO />
        <LOG_MSG_NO>0</LOG_MSG_NO>
        <MESSAGE_V1>12.00</MESSAGE_V1>
        <MESSAGE_V2>8.00</MESSAGE_V2>
        <MESSAGE_V3 />
        <MESSAGE_V4 />
        <PARAMETER>CATSRECORDS_IN</PARAMETER>
        <ROW>2</ROW>
        <FIELD />
        <SYSTEM>ECQCLNT100</SYSTEM>
        </BAPIRET2>
        </RETURN>
        </BAPI_CATIMESHEETMGR_INSERTResponse>

    • #23012

      I would probably use some Xpath queries inside the Orchestration.  First one would determine if you had rows of data or not.  Next would xpath out the data you are looking for.  You could use this data to build a custom, more friendly response / error message. 

      Hope this helps.

      Stephen W. Thomas

Viewing 1 reply thread
  • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.