eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBY_PAYGROUP_PUB dependencies on IBY_BUILD_UTILS_PKG

Line 10471: IBY_BUILD_UTILS_PKG.createPmtErrorRecord(

10467: * Once we fail a payment, we need to create
10468: * an error record and insert this record
10469: * into the errors table.
10470: */
10471: IBY_BUILD_UTILS_PKG.createPmtErrorRecord(
10472: IBY_PAYGROUP_PUB.pmtTable.payment_id(p_trx_pmt_line_index),
10473: IBY_PAYGROUP_PUB.pmtTable.payment_status(p_trx_pmt_line_index),
10474: l_error_code,
10475: FND_MESSAGE.get,

Line 10549: IBY_BUILD_UTILS_PKG.createPmtErrorRecord(

10545: * Once we fail a payment, we need to create
10546: * an error record and insert this record
10547: * into the errors table.
10548: */
10549: IBY_BUILD_UTILS_PKG.createPmtErrorRecord(
10550: IBY_PAYGROUP_PUB.pmtTable.payment_id(p_trx_pmt_line_index),
10551: IBY_PAYGROUP_PUB.pmtTable.payment_status(p_trx_pmt_line_index),
10552: l_error_code,
10553: FND_MESSAGE.get,

Line 10628: IBY_BUILD_UTILS_PKG.createPmtErrorRecord(

10624: * Once we fail a payment, we need to create
10625: * an error record and insert this record
10626: * into the errors table.
10627: */
10628: IBY_BUILD_UTILS_PKG.createPmtErrorRecord(
10629: IBY_PAYGROUP_PUB.pmtTable.payment_id(p_trx_pmt_line_index),
10630: IBY_PAYGROUP_PUB.pmtTable.payment_status(p_trx_pmt_line_index),
10631: l_error_code,
10632: FND_MESSAGE.get,

Line 10691: IBY_BUILD_UTILS_PKG.createPmtErrorRecord(

10687: * Once we fail a payment, we need to create
10688: * an error record and insert this record
10689: * into the errors table.
10690: */
10691: IBY_BUILD_UTILS_PKG.createPmtErrorRecord(
10692: IBY_PAYGROUP_PUB.pmtTable.payment_id(p_trx_pmt_line_index),
10693: IBY_PAYGROUP_PUB.pmtTable.payment_status(p_trx_pmt_line_index),
10694: l_error_code,
10695: FND_MESSAGE.get,

Line 10815: IBY_BUILD_UTILS_PKG.createPmtErrorRecord(

10811: * Once we fail a payment, we need to create
10812: * an error record and insert this record
10813: * into the errors table.
10814: */
10815: IBY_BUILD_UTILS_PKG.createPmtErrorRecord(
10816: IBY_PAYGROUP_PUB.pmtTable.payment_id(p_trx_pmt_line_index),
10817: IBY_PAYGROUP_PUB.pmtTable.payment_status(p_trx_pmt_line_index),
10818: l_error_code,
10819: FND_MESSAGE.get,

Line 10899: IBY_BUILD_UTILS_PKG.createPmtErrorRecord(

10895: * Once we fail a payment, we need to create
10896: * an error record and insert this record
10897: * into the errors table.
10898: */
10899: IBY_BUILD_UTILS_PKG.createPmtErrorRecord(
10900: IBY_PAYGROUP_PUB.pmtTable.payment_id(p_trx_pmt_line_index),
10901: IBY_PAYGROUP_PUB.pmtTable.payment_status(p_trx_pmt_line_index),
10902: l_error_code,
10903: FND_MESSAGE.get,

Line 11112: IBY_BUILD_UTILS_PKG.createErrorRecord(

11108: * to create an error record and
11109: * insert this record into
11110: * the errors table.
11111: */
11112: IBY_BUILD_UTILS_PKG.createErrorRecord(
11113: TRXN_TYPE_PMT,
11114: x_paymentTab(k).payment_id,
11115: x_paymentTab(k).payment_status,
11116: NULL,

Line 11150: IBY_BUILD_UTILS_PKG.createErrorRecord(

11146: * to create an error record and
11147: * insert this record into
11148: * the errors table.
11149: */
11150: IBY_BUILD_UTILS_PKG.createErrorRecord(
11151: TRXN_TYPE_PMT,
11152: x_paymentTab(i).payment_id,
11153: x_paymentTab(i).payment_status,
11154: NULL,

Line 12789: IBY_BUILD_UTILS_PKG.createErrorRecord(

12785: * Once we fail a payment, we need to create
12786: * an error record and insert this record
12787: * into the errors table.
12788: */
12789: IBY_BUILD_UTILS_PKG.createErrorRecord(
12790: TRXN_TYPE_PMT,
12791: x_paymentTab(j).payment_id,
12792: x_paymentTab(j).payment_status,
12793: NULL,

Line 12891: IBY_BUILD_UTILS_PKG.createErrorRecord(

12887: /*
12888: * Once we fail a doc, we must add a corresponding
12889: * error message to the error table.
12890: */
12891: IBY_BUILD_UTILS_PKG.createErrorRecord(
12892: TRXN_TYPE_DOC,
12893: x_docsInPmtTab(j).document_id,
12894: x_docsInPmtTab(j).document_status,
12895: x_docsInPmtTab(j).calling_app_id,

Line 13491: IBY_BUILD_UTILS_PKG.createErrorRecord(

13487: * Once we fail a payment, we need to create
13488: * an error record and insert this record
13489: * into the errors table.
13490: */
13491: IBY_BUILD_UTILS_PKG.createErrorRecord(
13492: TRXN_TYPE_PMT,
13493: hookPmtsTab(j).payment_id,
13494: PAY_STATUS_CA_FAILED,
13495: NULL,

Line 13554: IBY_BUILD_UTILS_PKG.createErrorRecord(

13550: /*
13551: * Once we fail a doc, we must add a corresponding
13552: * error message to the error table.
13553: */
13554: IBY_BUILD_UTILS_PKG.createErrorRecord(
13555: TRXN_TYPE_DOC,
13556: l_fail_dop_tbl(j).document_payable_id,
13557: l_fail_dop_tbl(j).document_status,
13558: l_fail_dop_tbl(j).calling_app_id,

Line 13716: IBY_BUILD_UTILS_PKG.createErrorRecord(

13712: /*
13713: * Once we fail a doc, we must add a corresponding
13714: * error message to the error table.
13715: */
13716: IBY_BUILD_UTILS_PKG.createErrorRecord(
13717: TRXN_TYPE_DOC,
13718: x_docsInPmtTab(j).document_id,
13719: x_docsInPmtTab(j).document_status,
13720: x_docsInPmtTab(j).calling_app_id,

Line 13936: IBY_BUILD_UTILS_PKG.createErrorRecord(

13932: /*
13933: * Once we fail a doc, we must add a corresponding
13934: * error message to the error table.
13935: */
13936: IBY_BUILD_UTILS_PKG.createErrorRecord(
13937: TRXN_TYPE_DOC,
13938: l_fail_dop_tbl(j).document_payable_id,
13939: l_fail_dop_tbl(j).document_status,
13940: l_fail_dop_tbl(j).calling_app_id,

Line 14145: IBY_BUILD_UTILS_PKG.createErrorRecord(

14141: /*
14142: * Once we fail a doc, we must add a corresponding
14143: * error message to the error table.
14144: */
14145: IBY_BUILD_UTILS_PKG.createErrorRecord(
14146: TRXN_TYPE_DOC,
14147: l_fail_dop_tbl(j).document_payable_id,
14148: l_fail_dop_tbl(j).document_status,
14149: l_fail_dop_tbl(j).calling_app_id,

Line 15637: IBY_BUILD_UTILS_PKG.createErrorRecord(

15633: /*
15634: * Once we fail a doc, we must add a corresponding
15635: * error message to the error table.
15636: */
15637: IBY_BUILD_UTILS_PKG.createErrorRecord(
15638: TRXN_TYPE_DOC,
15639: x_docsInPmtTab(j).document_id,
15640: p_docStatus,
15641: x_docsInPmtTab(j).calling_app_id,

Line 15765: IBY_BUILD_UTILS_PKG.createErrorRecord(

15761: /*
15762: * Once we fail a doc, we must add a corresponding
15763: * error message to the error table.
15764: */
15765: IBY_BUILD_UTILS_PKG.createErrorRecord(
15766: TRXN_TYPE_DOC,
15767: l_fail_dop_tbl(j).document_payable_id,
15768: p_docStatus,
15769: l_fail_dop_tbl(j).calling_app_id,

Line 15843: l_profile_map IBY_BUILD_UTILS_PKG.profileIdToCodeMapTabType;

15839: l_remitAdvicesSetupTab remitAdviceRecTab;
15840: l_successDocCountTab successDocsCountPerPmtTab;
15841:
15842: /* maps profile ids to system profile codes */
15843: l_profile_map IBY_BUILD_UTILS_PKG.profileIdToCodeMapTabType;
15844: l_profile_code IBY_PAYMENT_PROFILES.system_profile_code%TYPE;
15845:
15846: /*
15847: * Remittance advices cursor -- Only pick those

Line 15918: IBY_BUILD_UTILS_PKG.getProfileMap(l_profile_map);

15914: *
15915: * Therefore, we need this mapping for operations that
15916: * take place below.
15917: */
15918: IBY_BUILD_UTILS_PKG.getProfileMap(l_profile_map);
15919:
15920: /*
15921: * Loop through all the created payments, flagging any payments
15922: * that require a separate remittance advice.

Line 15928: l_profile_code := IBY_BUILD_UTILS_PKG.getProfileCodeFromId(

15924: FOR i in x_paymentTab.FIRST .. x_paymentTab.LAST LOOP
15925:
15926: IF (x_paymentTab(i).payment_status = PAY_STATUS_CREATED) THEN
15927:
15928: l_profile_code := IBY_BUILD_UTILS_PKG.getProfileCodeFromId(
15929: x_paymentTab(i).payment_profile_id,
15930: l_profile_map
15931: );
15932:

Line 16104: l_profile_map IBY_BUILD_UTILS_PKG.profileIdToCodeMapTabType;

16100: l_remitAdvicesSetupTab remitAdviceRecTab;
16101: l_successDocCountTab successDocsCountPerPmtTab;
16102:
16103: /* maps profile ids to system profile codes */
16104: l_profile_map IBY_BUILD_UTILS_PKG.profileIdToCodeMapTabType;
16105: l_profile_code IBY_PAYMENT_PROFILES.system_profile_code%TYPE;
16106:
16107: /*
16108: * Remittance advices cursor -- Only pick those

Line 16205: -- IBY_BUILD_UTILS_PKG.getProfileMap(l_profile_map);

16201: *
16202: * Therefore, we need this mapping for operations that
16203: * take place below.
16204: */
16205: -- IBY_BUILD_UTILS_PKG.getProfileMap(l_profile_map);
16206:
16207: /*
16208: * Loop through all the created payments, flagging any payments
16209: * that require a separate remittance advice.

Line 16217: l_profile_code := IBY_BUILD_UTILS_PKG.getProfileCodeFromId(

16213:
16214:
16215:
16216: /*
16217: l_profile_code := IBY_BUILD_UTILS_PKG.getProfileCodeFromId(
16218: x_paymentTab(i).payment_profile_id,
16219: l_profile_map
16220: );
16221: */

Line 16689: IBY_BUILD_UTILS_PKG.createErrorRecord(

16685: * Once we fail a payment, we need to create
16686: * an error record and insert this record
16687: * into the errors table.
16688: */
16689: IBY_BUILD_UTILS_PKG.createErrorRecord(
16690: TRXN_TYPE_PMT,
16691: x_paymentTab(i).payment_id,
16692: x_paymentTab(i).payment_status,
16693: NULL,

Line 16896: IBY_BUILD_UTILS_PKG.createErrorRecord(

16892: * Once we fail a payment, we need to create
16893: * an error record and insert this record
16894: * into the errors table.
16895: */
16896: IBY_BUILD_UTILS_PKG.createErrorRecord(
16897: TRXN_TYPE_PMT,
16898: x_paymentTab(i).payment_id,
16899: x_paymentTab(i).payment_status,
16900: NULL,

Line 17394: IBY_BUILD_UTILS_PKG.createErrorRecord(

17390: * Once we fail a payment, we need to create
17391: * an error record and insert this record
17392: * into the errors table.
17393: */
17394: IBY_BUILD_UTILS_PKG.createErrorRecord(
17395: TRXN_TYPE_PMT,
17396: IBY_PAYGROUP_PUB.pmtTable.payment_id(i),
17397: IBY_PAYGROUP_PUB.pmtTable.payment_status(i),
17398: NULL,

Line 17532: IBY_BUILD_UTILS_PKG.createPmtErrorRecord(

17528: * an error record and insert this record
17529: * into the errors table.
17530: */
17531:
17532: IBY_BUILD_UTILS_PKG.createPmtErrorRecord(
17533: IBY_PAYGROUP_PUB.pmtTable.payment_id(i),
17534: IBY_PAYGROUP_PUB.pmtTable.payment_status(i),
17535: l_error_code,
17536: FND_MESSAGE.get,

Line 17664: IBY_BUILD_UTILS_PKG.createErrorRecord(

17660: * Once we fail a payment, we need to create
17661: * an error record and insert this record
17662: * into the errors table.
17663: */
17664: IBY_BUILD_UTILS_PKG.createErrorRecord(
17665: TRXN_TYPE_PMT,
17666: IBY_PAYGROUP_PUB.pmtTable.payment_id(i),
17667: IBY_PAYGROUP_PUB.pmtTable.payment_status(i),
17668: NULL,

Line 18186: * Instead of calling IBY_BUILD_UTILS_PKG.inactivateOldErrors(..)

18182:
18183: /*
18184: * Performance Fix:
18185: *
18186: * Instead of calling IBY_BUILD_UTILS_PKG.inactivateOldErrors(..)
18187: * once per payment, delete all the error messages linked
18188: * to the payments of this PPR, and reset the payment status
18189: * of the failed payments in one shot.
18190: */

Line 18199: IBY_BUILD_UTILS_PKG.resetPaymentErrors(p_payment_request_id);

18195: END IF;
18196:
18197: ELSE
18198:
18199: IBY_BUILD_UTILS_PKG.resetPaymentErrors(p_payment_request_id);
18200:
18201: /* cache the call */
18202: resetErrtbl(p_payment_request_id) := p_payment_request_id;
18203:

Line 18313: IBY_BUILD_UTILS_PKG.createPmtErrorRecord(

18309: * Once we fail a payment, we need to create
18310: * an error record and insert this record
18311: * into the errors table.
18312: */
18313: IBY_BUILD_UTILS_PKG.createPmtErrorRecord(
18314: IBY_PAYGROUP_PUB.pmtTable.payment_id(l_trx_valid_index),
18315: IBY_PAYGROUP_PUB.pmtTable.payment_status(l_trx_valid_index),
18316: l_error_code,
18317: FND_MESSAGE.get,

Line 18427: --IBY_BUILD_UTILS_PKG.inactivateOldErrors(

18423: * correctly shows that there are no active
18424: * validation errors against this payment
18425: * at this time.
18426: */
18427: --IBY_BUILD_UTILS_PKG.inactivateOldErrors(
18428: -- x_paymentTab(i).payment_id,
18429: -- TRXN_TYPE_PMT
18430: -- );
18431:

Line 18459: --IBY_BUILD_UTILS_PKG.inactivateOldErrors(

18455: * continue to show up against this payment
18456: * in the IBY UI even if the payment is validated
18457: * successfully this time round.
18458: */
18459: --IBY_BUILD_UTILS_PKG.inactivateOldErrors(
18460: -- x_paymentTab(i).payment_id,
18461: -- TRXN_TYPE_PMT
18462: -- );
18463:

Line 19584: IBY_BUILD_UTILS_PKG.printXMLClob(l_clob);

19580: IF (l_clob IS NOT NULL) THEN
19581: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
19582: print_debuginfo(l_module_name, 'Clob is not null');
19583: END IF;
19584: IBY_BUILD_UTILS_PKG.printXMLClob(l_clob);
19585: END IF;
19586:
19587: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
19588: print_debuginfo(l_module_name, 'EXIT');

Line 26737: IBY_BUILD_UTILS_PKG.createPmtErrorRecord(

26733: * Once we fail a payment, we need to create
26734: * an error record and insert this record
26735: * into the errors table.
26736: */
26737: IBY_BUILD_UTILS_PKG.createPmtErrorRecord(
26738: IBY_PAYGROUP_PUB.pmtTable.payment_id(p_trx_pmt_line_index),
26739: IBY_PAYGROUP_PUB.pmtTable.payment_status(p_trx_pmt_line_index),
26740: l_error_code,
26741: FND_MESSAGE.get,