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 FND_LOG

Line 293: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

289: IBY_HOOK_PAYMENTS_T
290: ;
291:
292:
293: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
294: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
295: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
296: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
297: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

Line 294: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

290: ;
291:
292:
293: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
294: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
295: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
296: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
297: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
298: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

Line 295: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;

291:
292:
293: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
294: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
295: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
296: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
297: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
298: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
299: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

Line 296: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;

292:
293: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
294: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
295: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
296: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
297: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
298: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
299: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
300:

Line 297: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

293: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
294: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
295: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
296: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
297: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
298: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
299: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
300:
301: --

Line 298: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

294: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
295: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
296: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
297: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
298: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
299: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
300:
301: --
302: -- Forward declarations

Line 299: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

295: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
296: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
297: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
298: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
299: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
300:
301: --
302: -- Forward declarations
303: --

Line 307: p_debug_level IN VARCHAR2 DEFAULT FND_LOG.LEVEL_STATEMENT

303: --
304: PROCEDURE print_debuginfo(
305: p_module IN VARCHAR2,
306: p_debug_text IN VARCHAR2,
307: p_debug_level IN VARCHAR2 DEFAULT FND_LOG.LEVEL_STATEMENT
308: );
309:
310: -- Get Employee Full Name from HR tables
311:

Line 1291: FND_LOG.LEVEL_UNEXPECTED);

1287: END IF;
1288: EXCEPTION
1289: WHEN OTHERS THEN
1290: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
1291: FND_LOG.LEVEL_UNEXPECTED);
1292: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
1293: FND_LOG.LEVEL_UNEXPECTED);
1294: print_debuginfo(l_module_name, l_module_name||':Exception while creating payments');
1295: RAISE;

Line 1293: FND_LOG.LEVEL_UNEXPECTED);

1289: WHEN OTHERS THEN
1290: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
1291: FND_LOG.LEVEL_UNEXPECTED);
1292: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
1293: FND_LOG.LEVEL_UNEXPECTED);
1294: print_debuginfo(l_module_name, l_module_name||':Exception while creating payments');
1295: RAISE;
1296: END createPayments;
1297:

Line 3416: l_default_debug_level VARCHAR2(200) := FND_LOG.LEVEL_STATEMENT;

3412: )
3413: IS
3414: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME ||
3415: '.performDocumentGrouping';
3416: l_default_debug_level VARCHAR2(200) := FND_LOG.LEVEL_STATEMENT;
3417: l_first_record VARCHAR2(1) := 'Y';
3418: l_payment_id NUMBER(15) := 0;
3419: l_payment_total NUMBER(15) := 0;
3420: l_payment_docs_cnt NUMBER(10) := 0;

Line 5545: FND_LOG.LEVEL_UNEXPECTED);

5541: END IF;
5542: EXCEPTION
5543: WHEN OTHERS THEN
5544: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
5545: FND_LOG.LEVEL_UNEXPECTED);
5546: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
5547: FND_LOG.LEVEL_UNEXPECTED);
5548: print_debuginfo(l_module_name, l_module_name||':Exception when Performing'
5549: || 'Document Grpuping.');

Line 5547: FND_LOG.LEVEL_UNEXPECTED);

5543: WHEN OTHERS THEN
5544: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
5545: FND_LOG.LEVEL_UNEXPECTED);
5546: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
5547: FND_LOG.LEVEL_UNEXPECTED);
5548: print_debuginfo(l_module_name, l_module_name||':Exception when Performing'
5549: || 'Document Grpuping.');
5550: RAISE;
5551: END performDocumentGrouping;

Line 6858: FND_LOG.LEVEL_UNEXPECTED);

6854: END IF;
6855: EXCEPTION
6856: WHEN OTHERS THEN
6857: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
6858: FND_LOG.LEVEL_UNEXPECTED);
6859: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
6860: FND_LOG.LEVEL_UNEXPECTED);
6861: print_debuginfo(l_module_name, l_module_name||':Exception while inserting Doc into Payment');
6862: RAISE;

Line 6860: FND_LOG.LEVEL_UNEXPECTED);

6856: WHEN OTHERS THEN
6857: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
6858: FND_LOG.LEVEL_UNEXPECTED);
6859: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
6860: FND_LOG.LEVEL_UNEXPECTED);
6861: print_debuginfo(l_module_name, l_module_name||':Exception while inserting Doc into Payment');
6862: RAISE;
6863: END insertDocIntoPayment;
6864:

Line 8419: print_debuginfo(l_module_name, l_module_name||':'||'SQLCODE: ' || SQLCODE, FND_LOG.LEVEL_UNEXPECTED);

8415: errors := SQL%BULK_EXCEPTIONS.COUNT;
8416: FOR i IN 1..errors LOOP
8417: ERR_IND:= SQL%BULK_EXCEPTIONS(i).ERROR_INDEX;
8418: ERR_CODE:= SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE);
8419: print_debuginfo(l_module_name, l_module_name||':'||'SQLCODE: ' || SQLCODE, FND_LOG.LEVEL_UNEXPECTED);
8420: print_debuginfo(l_module_name, l_module_name||':'||'SQLERRM: ' || SQLERRM, FND_LOG.LEVEL_UNEXPECTED);
8421: print_debuginfo(l_module_name, l_module_name||':'|| ' While inserting payment with following context : ',FND_LOG.LEVEL_UNEXPECTED );
8422: print_debuginfo(l_module_name, ' Payee Name : ' || IBY_PAYGROUP_PUB.pmtTable.payee_name(ERR_IND) ||
8423: ' Payee Party Id : ' || IBY_PAYGROUP_PUB.pmtTable.payee_party_id(ERR_IND),FND_LOG.LEVEL_UNEXPECTED);

Line 8420: print_debuginfo(l_module_name, l_module_name||':'||'SQLERRM: ' || SQLERRM, FND_LOG.LEVEL_UNEXPECTED);

8416: FOR i IN 1..errors LOOP
8417: ERR_IND:= SQL%BULK_EXCEPTIONS(i).ERROR_INDEX;
8418: ERR_CODE:= SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE);
8419: print_debuginfo(l_module_name, l_module_name||':'||'SQLCODE: ' || SQLCODE, FND_LOG.LEVEL_UNEXPECTED);
8420: print_debuginfo(l_module_name, l_module_name||':'||'SQLERRM: ' || SQLERRM, FND_LOG.LEVEL_UNEXPECTED);
8421: print_debuginfo(l_module_name, l_module_name||':'|| ' While inserting payment with following context : ',FND_LOG.LEVEL_UNEXPECTED );
8422: print_debuginfo(l_module_name, ' Payee Name : ' || IBY_PAYGROUP_PUB.pmtTable.payee_name(ERR_IND) ||
8423: ' Payee Party Id : ' || IBY_PAYGROUP_PUB.pmtTable.payee_party_id(ERR_IND),FND_LOG.LEVEL_UNEXPECTED);
8424: print_debuginfo(l_module_name, ' Party Site Id : ' || IBY_PAYGROUP_PUB.pmtTable.party_site_id (ERR_IND) ||

Line 8421: print_debuginfo(l_module_name, l_module_name||':'|| ' While inserting payment with following context : ',FND_LOG.LEVEL_UNEXPECTED );

8417: ERR_IND:= SQL%BULK_EXCEPTIONS(i).ERROR_INDEX;
8418: ERR_CODE:= SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE);
8419: print_debuginfo(l_module_name, l_module_name||':'||'SQLCODE: ' || SQLCODE, FND_LOG.LEVEL_UNEXPECTED);
8420: print_debuginfo(l_module_name, l_module_name||':'||'SQLERRM: ' || SQLERRM, FND_LOG.LEVEL_UNEXPECTED);
8421: print_debuginfo(l_module_name, l_module_name||':'|| ' While inserting payment with following context : ',FND_LOG.LEVEL_UNEXPECTED );
8422: print_debuginfo(l_module_name, ' Payee Name : ' || IBY_PAYGROUP_PUB.pmtTable.payee_name(ERR_IND) ||
8423: ' Payee Party Id : ' || IBY_PAYGROUP_PUB.pmtTable.payee_party_id(ERR_IND),FND_LOG.LEVEL_UNEXPECTED);
8424: print_debuginfo(l_module_name, ' Party Site Id : ' || IBY_PAYGROUP_PUB.pmtTable.party_site_id (ERR_IND) ||
8425: ' Supplier Site Id : ' || IBY_PAYGROUP_PUB.pmtTable.supplier_site_id(ERR_IND),FND_LOG.LEVEL_UNEXPECTED);

Line 8423: ' Payee Party Id : ' || IBY_PAYGROUP_PUB.pmtTable.payee_party_id(ERR_IND),FND_LOG.LEVEL_UNEXPECTED);

8419: print_debuginfo(l_module_name, l_module_name||':'||'SQLCODE: ' || SQLCODE, FND_LOG.LEVEL_UNEXPECTED);
8420: print_debuginfo(l_module_name, l_module_name||':'||'SQLERRM: ' || SQLERRM, FND_LOG.LEVEL_UNEXPECTED);
8421: print_debuginfo(l_module_name, l_module_name||':'|| ' While inserting payment with following context : ',FND_LOG.LEVEL_UNEXPECTED );
8422: print_debuginfo(l_module_name, ' Payee Name : ' || IBY_PAYGROUP_PUB.pmtTable.payee_name(ERR_IND) ||
8423: ' Payee Party Id : ' || IBY_PAYGROUP_PUB.pmtTable.payee_party_id(ERR_IND),FND_LOG.LEVEL_UNEXPECTED);
8424: print_debuginfo(l_module_name, ' Party Site Id : ' || IBY_PAYGROUP_PUB.pmtTable.party_site_id (ERR_IND) ||
8425: ' Supplier Site Id : ' || IBY_PAYGROUP_PUB.pmtTable.supplier_site_id(ERR_IND),FND_LOG.LEVEL_UNEXPECTED);
8426: print_debuginfo(l_module_name, ' Org ID : ' || IBY_PAYGROUP_PUB.pmtTable.org_id (ERR_IND) ||
8427: ' Org Type : ' || IBY_PAYGROUP_PUB.pmtTable.org_type (ERR_IND),FND_LOG.LEVEL_UNEXPECTED);

Line 8425: ' Supplier Site Id : ' || IBY_PAYGROUP_PUB.pmtTable.supplier_site_id(ERR_IND),FND_LOG.LEVEL_UNEXPECTED);

8421: print_debuginfo(l_module_name, l_module_name||':'|| ' While inserting payment with following context : ',FND_LOG.LEVEL_UNEXPECTED );
8422: print_debuginfo(l_module_name, ' Payee Name : ' || IBY_PAYGROUP_PUB.pmtTable.payee_name(ERR_IND) ||
8423: ' Payee Party Id : ' || IBY_PAYGROUP_PUB.pmtTable.payee_party_id(ERR_IND),FND_LOG.LEVEL_UNEXPECTED);
8424: print_debuginfo(l_module_name, ' Party Site Id : ' || IBY_PAYGROUP_PUB.pmtTable.party_site_id (ERR_IND) ||
8425: ' Supplier Site Id : ' || IBY_PAYGROUP_PUB.pmtTable.supplier_site_id(ERR_IND),FND_LOG.LEVEL_UNEXPECTED);
8426: print_debuginfo(l_module_name, ' Org ID : ' || IBY_PAYGROUP_PUB.pmtTable.org_id (ERR_IND) ||
8427: ' Org Type : ' || IBY_PAYGROUP_PUB.pmtTable.org_type (ERR_IND),FND_LOG.LEVEL_UNEXPECTED);
8428: print_debuginfo(l_module_name, ' Payment Function : ' || IBY_PAYGROUP_PUB.pmtTable.payment_function (ERR_IND) ||
8429: ' External Bank Account ID : ' || IBY_PAYGROUP_PUB.pmtTable.external_bank_account_id (ERR_IND),FND_LOG.LEVEL_UNEXPECTED);

Line 8427: ' Org Type : ' || IBY_PAYGROUP_PUB.pmtTable.org_type (ERR_IND),FND_LOG.LEVEL_UNEXPECTED);

8423: ' Payee Party Id : ' || IBY_PAYGROUP_PUB.pmtTable.payee_party_id(ERR_IND),FND_LOG.LEVEL_UNEXPECTED);
8424: print_debuginfo(l_module_name, ' Party Site Id : ' || IBY_PAYGROUP_PUB.pmtTable.party_site_id (ERR_IND) ||
8425: ' Supplier Site Id : ' || IBY_PAYGROUP_PUB.pmtTable.supplier_site_id(ERR_IND),FND_LOG.LEVEL_UNEXPECTED);
8426: print_debuginfo(l_module_name, ' Org ID : ' || IBY_PAYGROUP_PUB.pmtTable.org_id (ERR_IND) ||
8427: ' Org Type : ' || IBY_PAYGROUP_PUB.pmtTable.org_type (ERR_IND),FND_LOG.LEVEL_UNEXPECTED);
8428: print_debuginfo(l_module_name, ' Payment Function : ' || IBY_PAYGROUP_PUB.pmtTable.payment_function (ERR_IND) ||
8429: ' External Bank Account ID : ' || IBY_PAYGROUP_PUB.pmtTable.external_bank_account_id (ERR_IND),FND_LOG.LEVEL_UNEXPECTED);
8430:
8431: END LOOP;

Line 8429: ' External Bank Account ID : ' || IBY_PAYGROUP_PUB.pmtTable.external_bank_account_id (ERR_IND),FND_LOG.LEVEL_UNEXPECTED);

8425: ' Supplier Site Id : ' || IBY_PAYGROUP_PUB.pmtTable.supplier_site_id(ERR_IND),FND_LOG.LEVEL_UNEXPECTED);
8426: print_debuginfo(l_module_name, ' Org ID : ' || IBY_PAYGROUP_PUB.pmtTable.org_id (ERR_IND) ||
8427: ' Org Type : ' || IBY_PAYGROUP_PUB.pmtTable.org_type (ERR_IND),FND_LOG.LEVEL_UNEXPECTED);
8428: print_debuginfo(l_module_name, ' Payment Function : ' || IBY_PAYGROUP_PUB.pmtTable.payment_function (ERR_IND) ||
8429: ' External Bank Account ID : ' || IBY_PAYGROUP_PUB.pmtTable.external_bank_account_id (ERR_IND),FND_LOG.LEVEL_UNEXPECTED);
8430:
8431: END LOOP;
8432:
8433: /*

Line 8440: FND_LOG.LEVEL_UNEXPECTED);

8436: RAISE;
8437: /* CHANGE FOR BUG : 14348326 - END */
8438: WHEN OTHERS THEN
8439: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
8440: FND_LOG.LEVEL_UNEXPECTED);
8441: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
8442: FND_LOG.LEVEL_UNEXPECTED);
8443: print_debuginfo(l_module_name, l_module_name||':Exception while inserting Payments');
8444: RAISE;

Line 8442: FND_LOG.LEVEL_UNEXPECTED);

8438: WHEN OTHERS THEN
8439: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
8440: FND_LOG.LEVEL_UNEXPECTED);
8441: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
8442: FND_LOG.LEVEL_UNEXPECTED);
8443: print_debuginfo(l_module_name, l_module_name||':Exception while inserting Payments');
8444: RAISE;
8445: END insertPayments;
8446:

Line 9293: print_debuginfo(l_module_name, l_module_name||':'||'SQLCODE: ' || SQLCODE, FND_LOG.LEVEL_UNEXPECTED);

9289: errors := SQL%BULK_EXCEPTIONS.COUNT;
9290: FOR i IN 1..errors LOOP
9291: ERR_IND:= SQL%BULK_EXCEPTIONS(i).ERROR_INDEX;
9292: ERR_CODE:= SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE);
9293: print_debuginfo(l_module_name, l_module_name||':'||'SQLCODE: ' || SQLCODE, FND_LOG.LEVEL_UNEXPECTED);
9294: print_debuginfo(l_module_name, l_module_name||':'||'SQLERRM: ' || SQLERRM, FND_LOG.LEVEL_UNEXPECTED);
9295: print_debuginfo(l_module_name, l_module_name||':'|| ' While updating payments with following context : ',FND_LOG.LEVEL_UNEXPECTED );
9296: print_debuginfo(l_module_name, ' Payee Name : ' || IBY_PAYGROUP_PUB.pmtTable.payee_name(ERR_IND) ||
9297: ' Payee Party Id : ' || IBY_PAYGROUP_PUB.pmtTable.payee_party_id(ERR_IND),FND_LOG.LEVEL_UNEXPECTED);

Line 9294: print_debuginfo(l_module_name, l_module_name||':'||'SQLERRM: ' || SQLERRM, FND_LOG.LEVEL_UNEXPECTED);

9290: FOR i IN 1..errors LOOP
9291: ERR_IND:= SQL%BULK_EXCEPTIONS(i).ERROR_INDEX;
9292: ERR_CODE:= SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE);
9293: print_debuginfo(l_module_name, l_module_name||':'||'SQLCODE: ' || SQLCODE, FND_LOG.LEVEL_UNEXPECTED);
9294: print_debuginfo(l_module_name, l_module_name||':'||'SQLERRM: ' || SQLERRM, FND_LOG.LEVEL_UNEXPECTED);
9295: print_debuginfo(l_module_name, l_module_name||':'|| ' While updating payments with following context : ',FND_LOG.LEVEL_UNEXPECTED );
9296: print_debuginfo(l_module_name, ' Payee Name : ' || IBY_PAYGROUP_PUB.pmtTable.payee_name(ERR_IND) ||
9297: ' Payee Party Id : ' || IBY_PAYGROUP_PUB.pmtTable.payee_party_id(ERR_IND),FND_LOG.LEVEL_UNEXPECTED);
9298: print_debuginfo(l_module_name, ' Party Site Id : ' || IBY_PAYGROUP_PUB.pmtTable.party_site_id (ERR_IND) ||

Line 9295: print_debuginfo(l_module_name, l_module_name||':'|| ' While updating payments with following context : ',FND_LOG.LEVEL_UNEXPECTED );

9291: ERR_IND:= SQL%BULK_EXCEPTIONS(i).ERROR_INDEX;
9292: ERR_CODE:= SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE);
9293: print_debuginfo(l_module_name, l_module_name||':'||'SQLCODE: ' || SQLCODE, FND_LOG.LEVEL_UNEXPECTED);
9294: print_debuginfo(l_module_name, l_module_name||':'||'SQLERRM: ' || SQLERRM, FND_LOG.LEVEL_UNEXPECTED);
9295: print_debuginfo(l_module_name, l_module_name||':'|| ' While updating payments with following context : ',FND_LOG.LEVEL_UNEXPECTED );
9296: print_debuginfo(l_module_name, ' Payee Name : ' || IBY_PAYGROUP_PUB.pmtTable.payee_name(ERR_IND) ||
9297: ' Payee Party Id : ' || IBY_PAYGROUP_PUB.pmtTable.payee_party_id(ERR_IND),FND_LOG.LEVEL_UNEXPECTED);
9298: print_debuginfo(l_module_name, ' Party Site Id : ' || IBY_PAYGROUP_PUB.pmtTable.party_site_id (ERR_IND) ||
9299: ' Supplier Site Id : ' || IBY_PAYGROUP_PUB.pmtTable.supplier_site_id(ERR_IND),FND_LOG.LEVEL_UNEXPECTED);

Line 9297: ' Payee Party Id : ' || IBY_PAYGROUP_PUB.pmtTable.payee_party_id(ERR_IND),FND_LOG.LEVEL_UNEXPECTED);

9293: print_debuginfo(l_module_name, l_module_name||':'||'SQLCODE: ' || SQLCODE, FND_LOG.LEVEL_UNEXPECTED);
9294: print_debuginfo(l_module_name, l_module_name||':'||'SQLERRM: ' || SQLERRM, FND_LOG.LEVEL_UNEXPECTED);
9295: print_debuginfo(l_module_name, l_module_name||':'|| ' While updating payments with following context : ',FND_LOG.LEVEL_UNEXPECTED );
9296: print_debuginfo(l_module_name, ' Payee Name : ' || IBY_PAYGROUP_PUB.pmtTable.payee_name(ERR_IND) ||
9297: ' Payee Party Id : ' || IBY_PAYGROUP_PUB.pmtTable.payee_party_id(ERR_IND),FND_LOG.LEVEL_UNEXPECTED);
9298: print_debuginfo(l_module_name, ' Party Site Id : ' || IBY_PAYGROUP_PUB.pmtTable.party_site_id (ERR_IND) ||
9299: ' Supplier Site Id : ' || IBY_PAYGROUP_PUB.pmtTable.supplier_site_id(ERR_IND),FND_LOG.LEVEL_UNEXPECTED);
9300: print_debuginfo(l_module_name, ' Org ID : ' || IBY_PAYGROUP_PUB.pmtTable.org_id (ERR_IND) ||
9301: ' Org Type : ' || IBY_PAYGROUP_PUB.pmtTable.org_type (ERR_IND),FND_LOG.LEVEL_UNEXPECTED);

Line 9299: ' Supplier Site Id : ' || IBY_PAYGROUP_PUB.pmtTable.supplier_site_id(ERR_IND),FND_LOG.LEVEL_UNEXPECTED);

9295: print_debuginfo(l_module_name, l_module_name||':'|| ' While updating payments with following context : ',FND_LOG.LEVEL_UNEXPECTED );
9296: print_debuginfo(l_module_name, ' Payee Name : ' || IBY_PAYGROUP_PUB.pmtTable.payee_name(ERR_IND) ||
9297: ' Payee Party Id : ' || IBY_PAYGROUP_PUB.pmtTable.payee_party_id(ERR_IND),FND_LOG.LEVEL_UNEXPECTED);
9298: print_debuginfo(l_module_name, ' Party Site Id : ' || IBY_PAYGROUP_PUB.pmtTable.party_site_id (ERR_IND) ||
9299: ' Supplier Site Id : ' || IBY_PAYGROUP_PUB.pmtTable.supplier_site_id(ERR_IND),FND_LOG.LEVEL_UNEXPECTED);
9300: print_debuginfo(l_module_name, ' Org ID : ' || IBY_PAYGROUP_PUB.pmtTable.org_id (ERR_IND) ||
9301: ' Org Type : ' || IBY_PAYGROUP_PUB.pmtTable.org_type (ERR_IND),FND_LOG.LEVEL_UNEXPECTED);
9302: print_debuginfo(l_module_name, ' Payment Function : ' || IBY_PAYGROUP_PUB.pmtTable.payment_function (ERR_IND) ||
9303: ' External Bank Account ID : ' || IBY_PAYGROUP_PUB.pmtTable.external_bank_account_id (ERR_IND),FND_LOG.LEVEL_UNEXPECTED);

Line 9301: ' Org Type : ' || IBY_PAYGROUP_PUB.pmtTable.org_type (ERR_IND),FND_LOG.LEVEL_UNEXPECTED);

9297: ' Payee Party Id : ' || IBY_PAYGROUP_PUB.pmtTable.payee_party_id(ERR_IND),FND_LOG.LEVEL_UNEXPECTED);
9298: print_debuginfo(l_module_name, ' Party Site Id : ' || IBY_PAYGROUP_PUB.pmtTable.party_site_id (ERR_IND) ||
9299: ' Supplier Site Id : ' || IBY_PAYGROUP_PUB.pmtTable.supplier_site_id(ERR_IND),FND_LOG.LEVEL_UNEXPECTED);
9300: print_debuginfo(l_module_name, ' Org ID : ' || IBY_PAYGROUP_PUB.pmtTable.org_id (ERR_IND) ||
9301: ' Org Type : ' || IBY_PAYGROUP_PUB.pmtTable.org_type (ERR_IND),FND_LOG.LEVEL_UNEXPECTED);
9302: print_debuginfo(l_module_name, ' Payment Function : ' || IBY_PAYGROUP_PUB.pmtTable.payment_function (ERR_IND) ||
9303: ' External Bank Account ID : ' || IBY_PAYGROUP_PUB.pmtTable.external_bank_account_id (ERR_IND),FND_LOG.LEVEL_UNEXPECTED);
9304:
9305: END LOOP;

Line 9303: ' External Bank Account ID : ' || IBY_PAYGROUP_PUB.pmtTable.external_bank_account_id (ERR_IND),FND_LOG.LEVEL_UNEXPECTED);

9299: ' Supplier Site Id : ' || IBY_PAYGROUP_PUB.pmtTable.supplier_site_id(ERR_IND),FND_LOG.LEVEL_UNEXPECTED);
9300: print_debuginfo(l_module_name, ' Org ID : ' || IBY_PAYGROUP_PUB.pmtTable.org_id (ERR_IND) ||
9301: ' Org Type : ' || IBY_PAYGROUP_PUB.pmtTable.org_type (ERR_IND),FND_LOG.LEVEL_UNEXPECTED);
9302: print_debuginfo(l_module_name, ' Payment Function : ' || IBY_PAYGROUP_PUB.pmtTable.payment_function (ERR_IND) ||
9303: ' External Bank Account ID : ' || IBY_PAYGROUP_PUB.pmtTable.external_bank_account_id (ERR_IND),FND_LOG.LEVEL_UNEXPECTED);
9304:
9305: END LOOP;
9306:
9307: /*

Line 9315: FND_LOG.LEVEL_UNEXPECTED);

9311:
9312: /* CHANGE FOR BUG : 14348326 - END */
9313: WHEN OTHERS THEN
9314: print_debuginfo(l_module_name, l_module_name||':'|| 'SQL code: ' || SQLCODE,
9315: FND_LOG.LEVEL_UNEXPECTED);
9316: print_debuginfo(l_module_name, l_module_name||':'|| 'SQL err msg: '|| SQLERRM,
9317: FND_LOG.LEVEL_UNEXPECTED);
9318: print_debuginfo(l_module_name, l_module_name||' : Exception while updating payments');
9319: RAISE;

Line 9317: FND_LOG.LEVEL_UNEXPECTED);

9313: WHEN OTHERS THEN
9314: print_debuginfo(l_module_name, l_module_name||':'|| 'SQL code: ' || SQLCODE,
9315: FND_LOG.LEVEL_UNEXPECTED);
9316: print_debuginfo(l_module_name, l_module_name||':'|| 'SQL err msg: '|| SQLERRM,
9317: FND_LOG.LEVEL_UNEXPECTED);
9318: print_debuginfo(l_module_name, l_module_name||' : Exception while updating payments');
9319: RAISE;
9320: END updatePayments;
9321:

Line 9537: FND_LOG.LEVEL_UNEXPECTED);

9533: END IF;
9534: EXCEPTION
9535: WHEN OTHERS THEN
9536: print_debuginfo(l_module_name, l_module_name||':'||'SQL code: ' || SQLCODE,
9537: FND_LOG.LEVEL_UNEXPECTED);
9538: print_debuginfo(l_module_name, l_module_name||':'||'SQL err msg: '|| SQLERRM,
9539: FND_LOG.LEVEL_UNEXPECTED);
9540: print_debuginfo(l_module_name, l_module_name||':Exception while updating Docs with Payment Id');
9541: RAISE;

Line 9539: FND_LOG.LEVEL_UNEXPECTED);

9535: WHEN OTHERS THEN
9536: print_debuginfo(l_module_name, l_module_name||':'||'SQL code: ' || SQLCODE,
9537: FND_LOG.LEVEL_UNEXPECTED);
9538: print_debuginfo(l_module_name, l_module_name||':'||'SQL err msg: '|| SQLERRM,
9539: FND_LOG.LEVEL_UNEXPECTED);
9540: print_debuginfo(l_module_name, l_module_name||':Exception while updating Docs with Payment Id');
9541: RAISE;
9542: END updateDocsWithPaymentID;
9543:

Line 9648: FND_LOG.LEVEL_UNEXPECTED

9644: || x_paymentTab(i).payment_id
9645: || 'returned: '
9646: || l_return_status
9647: || '. Raising exception ..',
9648: FND_LOG.LEVEL_UNEXPECTED
9649: );
9650:
9651:
9652: /*

Line 9793: FND_LOG.LEVEL_UNEXPECTED

9789:
9790: print_debuginfo(l_module_name, 'Reporting '
9791: || 'amount is -1. '
9792: || 'Raising exception.',
9793: FND_LOG.LEVEL_UNEXPECTED
9794: );
9795:
9796:
9797: APP_EXCEPTION.RAISE_EXCEPTION;

Line 9858: FND_LOG.LEVEL_UNEXPECTED

9854: WHEN OTHERS THEN
9855:
9856: print_debuginfo(l_module_name, 'Fatal: Exception when attempting '
9857: || 'to call GL API ''gl_currency_api.convert_amount()''.',
9858: FND_LOG.LEVEL_UNEXPECTED
9859: );
9860:
9861: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
9862: FND_LOG.LEVEL_UNEXPECTED);

Line 9862: FND_LOG.LEVEL_UNEXPECTED);

9858: FND_LOG.LEVEL_UNEXPECTED
9859: );
9860:
9861: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
9862: FND_LOG.LEVEL_UNEXPECTED);
9863: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
9864: FND_LOG.LEVEL_UNEXPECTED);
9865:
9866:

Line 9864: FND_LOG.LEVEL_UNEXPECTED);

9860:
9861: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
9862: FND_LOG.LEVEL_UNEXPECTED);
9863: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
9864: FND_LOG.LEVEL_UNEXPECTED);
9865:
9866:
9867:
9868: /*

Line 9981: FND_LOG.LEVEL_UNEXPECTED

9977: ||IBY_PAYGROUP_PUB.pmtTable.payment_id(l_trx_cbr_index)
9978: || 'returned: '
9979: || l_return_status
9980: || '. Raising exception ..',
9981: FND_LOG.LEVEL_UNEXPECTED
9982: );
9983:
9984:
9985: /*

Line 10126: FND_LOG.LEVEL_UNEXPECTED

10122:
10123: print_debuginfo(l_module_name, 'Reporting '
10124: || 'amount is -1. '
10125: || 'Raising exception.',
10126: FND_LOG.LEVEL_UNEXPECTED
10127: );
10128:
10129:
10130: APP_EXCEPTION.RAISE_EXCEPTION;

Line 10195: FND_LOG.LEVEL_UNEXPECTED

10191: WHEN OTHERS THEN
10192:
10193: print_debuginfo(l_module_name, 'Fatal: Exception when attempting '
10194: || 'to call GL API ''gl_currency_api.convert_amount()''.',
10195: FND_LOG.LEVEL_UNEXPECTED
10196: );
10197:
10198: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
10199: FND_LOG.LEVEL_UNEXPECTED);

Line 10199: FND_LOG.LEVEL_UNEXPECTED);

10195: FND_LOG.LEVEL_UNEXPECTED
10196: );
10197:
10198: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
10199: FND_LOG.LEVEL_UNEXPECTED);
10200: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
10201: FND_LOG.LEVEL_UNEXPECTED);
10202:
10203:

Line 10201: FND_LOG.LEVEL_UNEXPECTED);

10197:
10198: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
10199: FND_LOG.LEVEL_UNEXPECTED);
10200: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
10201: FND_LOG.LEVEL_UNEXPECTED);
10202:
10203:
10204:
10205: /*

Line 10329: FND_LOG.LEVEL_UNEXPECTED);

10325:
10326: EXCEPTION
10327: WHEN OTHERS THEN
10328: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
10329: FND_LOG.LEVEL_UNEXPECTED);
10330: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
10331: FND_LOG.LEVEL_UNEXPECTED);
10332: print_debuginfo(l_module_name, l_module_name||':Exception while Performing Payment Validations');
10333: RAISE;

Line 10331: FND_LOG.LEVEL_UNEXPECTED);

10327: WHEN OTHERS THEN
10328: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
10329: FND_LOG.LEVEL_UNEXPECTED);
10330: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
10331: FND_LOG.LEVEL_UNEXPECTED);
10332: print_debuginfo(l_module_name, l_module_name||':Exception while Performing Payment Validations');
10333: RAISE;
10334: END performPaymentValidations;
10335:

Line 10931: FND_LOG.LEVEL_UNEXPECTED);

10927: END IF;
10928: EXCEPTION
10929: WHEN OTHERS THEN
10930: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
10931: FND_LOG.LEVEL_UNEXPECTED);
10932: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
10933: FND_LOG.LEVEL_UNEXPECTED);
10934: print_debuginfo(l_module_name, l_module_name||':Exception while performing pay Req based Valdiations');
10935: RAISE;

Line 10933: FND_LOG.LEVEL_UNEXPECTED);

10929: WHEN OTHERS THEN
10930: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
10931: FND_LOG.LEVEL_UNEXPECTED);
10932: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
10933: FND_LOG.LEVEL_UNEXPECTED);
10934: print_debuginfo(l_module_name, l_module_name||':Exception while performing pay Req based Valdiations');
10935: RAISE;
10936: END performPayReqBasedValidations;
10937:

Line 12340: --,FND_LOG.LEVEL_UNEXPECTED

12336:
12337: print_debuginfo(l_module_name, 'Fatal error - Payment '
12338: || 'count has come in the Payments GT Table as: '
12339: || l_prehook_cnt
12340: --,FND_LOG.LEVEL_UNEXPECTED
12341: );
12342:
12343: /* print_debuginfo(l_module_name, 'Aborting program ..',
12344: FND_LOG.LEVEL_UNEXPECTED);

Line 12344: FND_LOG.LEVEL_UNEXPECTED);

12340: --,FND_LOG.LEVEL_UNEXPECTED
12341: );
12342:
12343: /* print_debuginfo(l_module_name, 'Aborting program ..',
12344: FND_LOG.LEVEL_UNEXPECTED);
12345:
12346: APP_EXCEPTION.RAISE_EXCEPTION; */
12347:
12348: END IF;

Line 12355: FND_LOG.LEVEL_UNEXPECTED);

12351: END IF;
12352: EXCEPTION
12353: WHEN OTHERS THEN
12354: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
12355: FND_LOG.LEVEL_UNEXPECTED);
12356: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
12357: FND_LOG.LEVEL_UNEXPECTED);
12358: print_debuginfo(l_module_name, l_module_name||':Exception while performing performPreHookProcess');
12359: RAISE;

Line 12357: FND_LOG.LEVEL_UNEXPECTED);

12353: WHEN OTHERS THEN
12354: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
12355: FND_LOG.LEVEL_UNEXPECTED);
12356: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
12357: FND_LOG.LEVEL_UNEXPECTED);
12358: print_debuginfo(l_module_name, l_module_name||':Exception while performing performPreHookProcess');
12359: RAISE;
12360: END performPreHookProcess;
12361:

Line 12539: FND_LOG.LEVEL_UNEXPECTED

12535: || '# payments passed to hook: '
12536: || l_preHookPaymentTab.COUNT
12537: || ', # payments returning from hook: '
12538: || x_hookPaymentTab.COUNT,
12539: FND_LOG.LEVEL_UNEXPECTED
12540: );
12541:
12542: print_debuginfo(l_module_name, 'Aborting program ..',
12543: FND_LOG.LEVEL_UNEXPECTED);

Line 12543: FND_LOG.LEVEL_UNEXPECTED);

12539: FND_LOG.LEVEL_UNEXPECTED
12540: );
12541:
12542: print_debuginfo(l_module_name, 'Aborting program ..',
12543: FND_LOG.LEVEL_UNEXPECTED);
12544:
12545:
12546:
12547:

Line 12561: FND_LOG.LEVEL_UNEXPECTED

12557: || '# documents passed to hook: '
12558: || l_preHookDocsInPmtTab.COUNT
12559: || ', # documents returning from hook: '
12560: || x_hookDocsInPmtTab.COUNT,
12561: FND_LOG.LEVEL_UNEXPECTED
12562: );
12563:
12564: print_debuginfo(l_module_name, 'Aborting program ..',
12565: FND_LOG.LEVEL_UNEXPECTED);

Line 12565: FND_LOG.LEVEL_UNEXPECTED);

12561: FND_LOG.LEVEL_UNEXPECTED
12562: );
12563:
12564: print_debuginfo(l_module_name, 'Aborting program ..',
12565: FND_LOG.LEVEL_UNEXPECTED);
12566:
12567:
12568:
12569: APP_EXCEPTION.RAISE_EXCEPTION;

Line 13264: FND_LOG.LEVEL_UNEXPECTED

13260: || '# payments passed to hook: '
13261: || l_prehook_count
13262: || ', # payments returning from hook: '
13263: || l_posthook_count,
13264: FND_LOG.LEVEL_UNEXPECTED
13265: );
13266:
13267: print_debuginfo(l_module_name, 'Aborting program ..',
13268: FND_LOG.LEVEL_UNEXPECTED);

Line 13268: FND_LOG.LEVEL_UNEXPECTED);

13264: FND_LOG.LEVEL_UNEXPECTED
13265: );
13266:
13267: print_debuginfo(l_module_name, 'Aborting program ..',
13268: FND_LOG.LEVEL_UNEXPECTED);
13269:
13270:
13271:
13272:

Line 13291: FND_LOG.LEVEL_UNEXPECTED

13287: || '# documents passed to hook: '
13288: || l_DocsInPmtCount
13289: || ', # documents returning from hook: '
13290: || l_docsingt_count,
13291: FND_LOG.LEVEL_UNEXPECTED
13292: );
13293:
13294: print_debuginfo(l_module_name, 'Aborting program ..',
13295: FND_LOG.LEVEL_UNEXPECTED);

Line 13295: FND_LOG.LEVEL_UNEXPECTED);

13291: FND_LOG.LEVEL_UNEXPECTED
13292: );
13293:
13294: print_debuginfo(l_module_name, 'Aborting program ..',
13295: FND_LOG.LEVEL_UNEXPECTED);
13296:
13297:
13298:
13299: APP_EXCEPTION.RAISE_EXCEPTION;

Line 13593: FND_LOG.LEVEL_UNEXPECTED);

13589: END IF;
13590: EXCEPTION
13591: WHEN OTHERS THEN
13592: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
13593: FND_LOG.LEVEL_UNEXPECTED);
13594: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
13595: FND_LOG.LEVEL_UNEXPECTED);
13596: print_debuginfo(l_module_name, l_module_name||':Exception while performing performPostHookProcess');
13597: RAISE;

Line 13595: FND_LOG.LEVEL_UNEXPECTED);

13591: WHEN OTHERS THEN
13592: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
13593: FND_LOG.LEVEL_UNEXPECTED);
13594: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
13595: FND_LOG.LEVEL_UNEXPECTED);
13596: print_debuginfo(l_module_name, l_module_name||':Exception while performing performPostHookProcess');
13597: RAISE;
13598: END performPostHookProcess;
13599:

Line 14396: || 'request id: ' || p_payreq_id, FND_LOG.LEVEL_UNEXPECTED);

14392: WHEN OTHERS THEN
14393:
14394: print_debuginfo(l_module_name, 'Fatal: Exception when attempting '
14395: || 'to get calling application short name. Provided payment '
14396: || 'request id: ' || p_payreq_id, FND_LOG.LEVEL_UNEXPECTED);
14397: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
14398: FND_LOG.LEVEL_UNEXPECTED);
14399: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
14400: FND_LOG.LEVEL_UNEXPECTED);

Line 14398: FND_LOG.LEVEL_UNEXPECTED);

14394: print_debuginfo(l_module_name, 'Fatal: Exception when attempting '
14395: || 'to get calling application short name. Provided payment '
14396: || 'request id: ' || p_payreq_id, FND_LOG.LEVEL_UNEXPECTED);
14397: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
14398: FND_LOG.LEVEL_UNEXPECTED);
14399: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
14400: FND_LOG.LEVEL_UNEXPECTED);
14401:
14402:

Line 14400: FND_LOG.LEVEL_UNEXPECTED);

14396: || 'request id: ' || p_payreq_id, FND_LOG.LEVEL_UNEXPECTED);
14397: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
14398: FND_LOG.LEVEL_UNEXPECTED);
14399: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
14400: FND_LOG.LEVEL_UNEXPECTED);
14401:
14402:
14403: /*
14404: * Propogate exception to caller.

Line 14477: FND_LOG.LEVEL_UNEXPECTED);

14473: print_debuginfo(l_module_name, 'Fatal: External app hook '''
14474: || l_hook_name || ''', generated exception. Please '
14475: || ' contact implementor of hook in product '
14476: || l_app_short_name || ' for fix.',
14477: FND_LOG.LEVEL_UNEXPECTED);
14478:
14479: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
14480: FND_LOG.LEVEL_UNEXPECTED);
14481: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,

Line 14480: FND_LOG.LEVEL_UNEXPECTED);

14476: || l_app_short_name || ' for fix.',
14477: FND_LOG.LEVEL_UNEXPECTED);
14478:
14479: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
14480: FND_LOG.LEVEL_UNEXPECTED);
14481: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
14482: FND_LOG.LEVEL_UNEXPECTED);
14483:
14484:

Line 14482: FND_LOG.LEVEL_UNEXPECTED);

14478:
14479: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
14480: FND_LOG.LEVEL_UNEXPECTED);
14481: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
14482: FND_LOG.LEVEL_UNEXPECTED);
14483:
14484:
14485: /*
14486: * Propogate exception to caller.

Line 15802: FND_LOG.LEVEL_UNEXPECTED);

15798: END IF;
15799: EXCEPTION
15800: WHEN OTHERS THEN
15801: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
15802: FND_LOG.LEVEL_UNEXPECTED);
15803: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
15804: FND_LOG.LEVEL_UNEXPECTED);
15805: print_debuginfo(l_module_name, l_module_name||':Exception while performing failDocsOfPayment');
15806: RAISE;

Line 15804: FND_LOG.LEVEL_UNEXPECTED);

15800: WHEN OTHERS THEN
15801: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
15802: FND_LOG.LEVEL_UNEXPECTED);
15803: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
15804: FND_LOG.LEVEL_UNEXPECTED);
15805: print_debuginfo(l_module_name, l_module_name||':Exception while performing failDocsOfPayment');
15806: RAISE;
15807: END failDocsOfPayment;
15808:

Line 17104: FND_LOG.LEVEL_UNEXPECTED

17100:
17101: print_debuginfo(l_module_name, 'Unknown rejection level: '
17102: || p_rej_level
17103: || '. Aborting payment creation ..',
17104: FND_LOG.LEVEL_UNEXPECTED
17105: );
17106:
17107:
17108: APP_EXCEPTION.RAISE_EXCEPTION;

Line 17173: || 'id is ' || p_payreq_id, FND_LOG.LEVEL_UNEXPECTED);

17169:
17170: print_debuginfo(l_module_name, 'Fatal: Exception when updating '
17171: || 'payment request/payment/document status after payment '
17172: || 'creation. All changes will be rolled back. Payment request '
17173: || 'id is ' || p_payreq_id, FND_LOG.LEVEL_UNEXPECTED);
17174: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
17175: FND_LOG.LEVEL_UNEXPECTED);
17176: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
17177: FND_LOG.LEVEL_UNEXPECTED);

Line 17175: FND_LOG.LEVEL_UNEXPECTED);

17171: || 'payment request/payment/document status after payment '
17172: || 'creation. All changes will be rolled back. Payment request '
17173: || 'id is ' || p_payreq_id, FND_LOG.LEVEL_UNEXPECTED);
17174: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
17175: FND_LOG.LEVEL_UNEXPECTED);
17176: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
17177: FND_LOG.LEVEL_UNEXPECTED);
17178:
17179:

Line 17177: FND_LOG.LEVEL_UNEXPECTED);

17173: || 'id is ' || p_payreq_id, FND_LOG.LEVEL_UNEXPECTED);
17174: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
17175: FND_LOG.LEVEL_UNEXPECTED);
17176: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
17177: FND_LOG.LEVEL_UNEXPECTED);
17178:
17179:
17180: /*
17181: * Propogate exception to caller.

Line 17959: FND_LOG.LEVEL_UNEXPECTED

17955:
17956: print_debuginfo(l_module_name, 'Unknown rejection level: '
17957: || p_rej_level
17958: || '. Aborting payment creation ..',
17959: FND_LOG.LEVEL_UNEXPECTED
17960: );
17961:
17962:
17963: APP_EXCEPTION.RAISE_EXCEPTION;

Line 18043: || 'id is ' || p_payreq_id, FND_LOG.LEVEL_UNEXPECTED);

18039:
18040: print_debuginfo(l_module_name, 'Fatal: Exception when updating '
18041: || 'payment request/payment/document status after payment '
18042: || 'creation. All changes will be rolled back. Payment request '
18043: || 'id is ' || p_payreq_id, FND_LOG.LEVEL_UNEXPECTED);
18044: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
18045: FND_LOG.LEVEL_UNEXPECTED);
18046: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
18047: FND_LOG.LEVEL_UNEXPECTED);

Line 18045: FND_LOG.LEVEL_UNEXPECTED);

18041: || 'payment request/payment/document status after payment '
18042: || 'creation. All changes will be rolled back. Payment request '
18043: || 'id is ' || p_payreq_id, FND_LOG.LEVEL_UNEXPECTED);
18044: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
18045: FND_LOG.LEVEL_UNEXPECTED);
18046: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
18047: FND_LOG.LEVEL_UNEXPECTED);
18048:
18049:

Line 18047: FND_LOG.LEVEL_UNEXPECTED);

18043: || 'id is ' || p_payreq_id, FND_LOG.LEVEL_UNEXPECTED);
18044: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
18045: FND_LOG.LEVEL_UNEXPECTED);
18046: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
18047: FND_LOG.LEVEL_UNEXPECTED);
18048:
18049:
18050: /*
18051: * Propogate exception to caller.

Line 18599: FND_LOG.LEVEL_UNEXPECTED);

18595: END IF;
18596: EXCEPTION
18597: WHEN OTHERS THEN
18598: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
18599: FND_LOG.LEVEL_UNEXPECTED);
18600: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
18601: FND_LOG.LEVEL_UNEXPECTED);
18602: print_debuginfo(l_module_name, l_module_name||':Exception while performing applyPaymentValidationSets');
18603: RAISE;

Line 18601: FND_LOG.LEVEL_UNEXPECTED);

18597: WHEN OTHERS THEN
18598: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
18599: FND_LOG.LEVEL_UNEXPECTED);
18600: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
18601: FND_LOG.LEVEL_UNEXPECTED);
18602: print_debuginfo(l_module_name, l_module_name||':Exception while performing applyPaymentValidationSets');
18603: RAISE;
18604: END applyPaymentValidationSets;
18605:

Line 18721: FND_LOG.LEVEL_UNEXPECTED

18717:
18718:
18719: print_debuginfo(l_module_name, 'API call did not succeed. '
18720: || 'Aborting build program .. ',
18721: FND_LOG.LEVEL_UNEXPECTED
18722: );
18723:
18724: APP_EXCEPTION.RAISE_EXCEPTION;
18725:

Line 18833: FND_LOG.LEVEL_UNEXPECTED

18829:
18830:
18831: print_debuginfo(l_module_name, 'API call did not succeed. '
18832: || 'Aborting build program .. ',
18833: FND_LOG.LEVEL_UNEXPECTED
18834: );
18835:
18836: APP_EXCEPTION.RAISE_EXCEPTION;
18837:

Line 18970: FND_LOG.LEVEL_UNEXPECTED

18966:
18967:
18968: print_debuginfo(l_module_name, 'API call did not '
18969: || 'succeed. Aborting build program .. ',
18970: FND_LOG.LEVEL_UNEXPECTED
18971: );
18972:
18973:
18974: APP_EXCEPTION.RAISE_EXCEPTION;

Line 19077: FND_LOG.LEVEL_UNEXPECTED

19073:
19074: print_debuginfo(l_module_name, 'Unknown rejection level: '
19075: || p_rej_level
19076: || '. Aborting payment creation ..',
19077: FND_LOG.LEVEL_UNEXPECTED
19078: );
19079:
19080: APP_EXCEPTION.RAISE_EXCEPTION;
19081:

Line 19092: || 'to raise business event.', FND_LOG.LEVEL_UNEXPECTED);

19088: EXCEPTION
19089: WHEN OTHERS THEN
19090:
19091: print_debuginfo(l_module_name, 'Fatal: Exception when attempting '
19092: || 'to raise business event.', FND_LOG.LEVEL_UNEXPECTED);
19093: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
19094: FND_LOG.LEVEL_UNEXPECTED);
19095: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
19096: FND_LOG.LEVEL_UNEXPECTED);

Line 19094: FND_LOG.LEVEL_UNEXPECTED);

19090:
19091: print_debuginfo(l_module_name, 'Fatal: Exception when attempting '
19092: || 'to raise business event.', FND_LOG.LEVEL_UNEXPECTED);
19093: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
19094: FND_LOG.LEVEL_UNEXPECTED);
19095: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
19096: FND_LOG.LEVEL_UNEXPECTED);
19097:
19098: /*

Line 19096: FND_LOG.LEVEL_UNEXPECTED);

19092: || 'to raise business event.', FND_LOG.LEVEL_UNEXPECTED);
19093: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
19094: FND_LOG.LEVEL_UNEXPECTED);
19095: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
19096: FND_LOG.LEVEL_UNEXPECTED);
19097:
19098: /*
19099: * Propogate exception to caller.
19100: */

Line 19338: || 'to raise business event.', FND_LOG.LEVEL_UNEXPECTED);

19334: END IF;
19335:
19336:
19337: print_debuginfo(l_module_name, 'Fatal: Exception when attempting '
19338: || 'to raise business event.', FND_LOG.LEVEL_UNEXPECTED);
19339: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
19340: FND_LOG.LEVEL_UNEXPECTED);
19341: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
19342: FND_LOG.LEVEL_UNEXPECTED);

Line 19340: FND_LOG.LEVEL_UNEXPECTED);

19336:
19337: print_debuginfo(l_module_name, 'Fatal: Exception when attempting '
19338: || 'to raise business event.', FND_LOG.LEVEL_UNEXPECTED);
19339: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
19340: FND_LOG.LEVEL_UNEXPECTED);
19341: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
19342: FND_LOG.LEVEL_UNEXPECTED);
19343:
19344: /*

Line 19342: FND_LOG.LEVEL_UNEXPECTED);

19338: || 'to raise business event.', FND_LOG.LEVEL_UNEXPECTED);
19339: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
19340: FND_LOG.LEVEL_UNEXPECTED);
19341: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
19342: FND_LOG.LEVEL_UNEXPECTED);
19343:
19344: /*
19345: * Propogate exception to caller.
19346: */

Line 19669: FND_LOG.LEVEL_UNEXPECTED

19665: || 'system option is not set at enterprise level. '
19666: || 'It is mandatory to '
19667: || 'setup review pmts flag at enterprise level '
19668: || 'Raising exception.. ',
19669: FND_LOG.LEVEL_UNEXPECTED
19670: );
19671:
19672: APP_EXCEPTION.RAISE_EXCEPTION;
19673:

Line 19690: FND_LOG.LEVEL_UNEXPECTED

19686: || 'enterprise level. It is mandatory to '
19687: || 'setup only one review payment flag sys option '
19688: || 'at enterprise level. '
19689: || 'Raising exception.. ',
19690: FND_LOG.LEVEL_UNEXPECTED
19691: );
19692:
19693: APP_EXCEPTION.RAISE_EXCEPTION;
19694:

Line 19818: FND_LOG.LEVEL_UNEXPECTED

19814: || 'system option is not set at enterprise level. '
19815: || 'It is mandatory to '
19816: || 'setup rejection levels at enterprise level '
19817: || 'Raising exception.. ',
19818: FND_LOG.LEVEL_UNEXPECTED
19819: );
19820:
19821:
19822: APP_EXCEPTION.RAISE_EXCEPTION;

Line 19840: FND_LOG.LEVEL_UNEXPECTED

19836: || 'enterprise level. It is mandatory to '
19837: || 'setup only one payment rejection level '
19838: || 'at enterprise level. '
19839: || 'Raising exception.. ',
19840: FND_LOG.LEVEL_UNEXPECTED
19841: );
19842:
19843: APP_EXCEPTION.RAISE_EXCEPTION;
19844:

Line 19968: FND_LOG.LEVEL_UNEXPECTED);

19964: END IF;
19965: EXCEPTION
19966: WHEN OTHERS THEN
19967: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
19968: FND_LOG.LEVEL_UNEXPECTED);
19969: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
19970: FND_LOG.LEVEL_UNEXPECTED);
19971: print_debuginfo(l_module_name, l_module_name||':Exception while performing performCreditMemoHandling');
19972: RAISE;

Line 19970: FND_LOG.LEVEL_UNEXPECTED);

19966: WHEN OTHERS THEN
19967: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
19968: FND_LOG.LEVEL_UNEXPECTED);
19969: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
19970: FND_LOG.LEVEL_UNEXPECTED);
19971: print_debuginfo(l_module_name, l_module_name||':Exception while performing performCreditMemoHandling');
19972: RAISE;
19973: END performCreditMemoHandling;
19974:

Line 20635: FND_LOG.LEVEL_UNEXPECTED

20631: */
20632:
20633: print_debuginfo(l_module_name, 'Maturity date is a must '
20634: || 'for a bill payable. Aborting ..',
20635: FND_LOG.LEVEL_UNEXPECTED
20636: );
20637:
20638: APP_EXCEPTION.RAISE_EXCEPTION;
20639:

Line 20660: FND_LOG.LEVEL_UNEXPECTED);

20656: END IF;
20657: EXCEPTION
20658: WHEN OTHERS THEN
20659: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
20660: FND_LOG.LEVEL_UNEXPECTED);
20661: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
20662: FND_LOG.LEVEL_UNEXPECTED);
20663: print_debuginfo(l_module_name, l_module_name||':Exception while performing performMaturityDateCalculation');
20664: RAISE;

Line 20662: FND_LOG.LEVEL_UNEXPECTED);

20658: WHEN OTHERS THEN
20659: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
20660: FND_LOG.LEVEL_UNEXPECTED);
20661: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
20662: FND_LOG.LEVEL_UNEXPECTED);
20663: print_debuginfo(l_module_name, l_module_name||':Exception while performing performMaturityDateCalculation');
20664: RAISE;
20665: END performMaturityDateCalculation;
20666:

Line 21059: FND_LOG.LEVEL_UNEXPECTED

21055: */
21056:
21057: print_debuginfo(l_module_name, 'Maturity date is a must '
21058: || 'for a bill payable. Aborting ..',
21059: FND_LOG.LEVEL_UNEXPECTED
21060: );
21061:
21062: APP_EXCEPTION.RAISE_EXCEPTION;
21063:

Line 21084: FND_LOG.LEVEL_UNEXPECTED);

21080: END IF;
21081: EXCEPTION
21082: WHEN OTHERS THEN
21083: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
21084: FND_LOG.LEVEL_UNEXPECTED);
21085: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
21086: FND_LOG.LEVEL_UNEXPECTED);
21087: print_debuginfo(l_module_name, l_module_name||':Exception while performing performMaturityDateCalculation');
21088: RAISE;

Line 21086: FND_LOG.LEVEL_UNEXPECTED);

21082: WHEN OTHERS THEN
21083: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
21084: FND_LOG.LEVEL_UNEXPECTED);
21085: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
21086: FND_LOG.LEVEL_UNEXPECTED);
21087: print_debuginfo(l_module_name, l_module_name||':Exception while performing performMaturityDateCalculation');
21088: RAISE;
21089: END performMaturityDateCalculation;
21090:

Line 21684: FND_LOG.LEVEL_UNEXPECTED

21680:
21681: print_debuginfo(l_module_name, 'Fatal: Japanese bank charge '
21682: || 'hook ''' || l_hook_name
21683: || ''', generated exception.',
21684: FND_LOG.LEVEL_UNEXPECTED
21685: );
21686:
21687: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
21688: FND_LOG.LEVEL_UNEXPECTED);

Line 21688: FND_LOG.LEVEL_UNEXPECTED);

21684: FND_LOG.LEVEL_UNEXPECTED
21685: );
21686:
21687: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
21688: FND_LOG.LEVEL_UNEXPECTED);
21689: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
21690: FND_LOG.LEVEL_UNEXPECTED);
21691:
21692: /*

Line 21690: FND_LOG.LEVEL_UNEXPECTED);

21686:
21687: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
21688: FND_LOG.LEVEL_UNEXPECTED);
21689: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
21690: FND_LOG.LEVEL_UNEXPECTED);
21691:
21692: /*
21693: * Propogate exception to caller.
21694: */

Line 21708: FND_LOG.LEVEL_UNEXPECTED

21704:
21705: print_debuginfo(l_module_name, 'Fatal: Japanese bank charge hook '''
21706: || l_hook_name || ''' returned error status code: '
21707: || l_return_status,
21708: FND_LOG.LEVEL_UNEXPECTED
21709: );
21710:
21711: print_debuginfo(l_module_name, 'Raising exception .. ',
21712: FND_LOG.LEVEL_UNEXPECTED);

Line 21712: FND_LOG.LEVEL_UNEXPECTED);

21708: FND_LOG.LEVEL_UNEXPECTED
21709: );
21710:
21711: print_debuginfo(l_module_name, 'Raising exception .. ',
21712: FND_LOG.LEVEL_UNEXPECTED);
21713:
21714: APP_EXCEPTION.RAISE_EXCEPTION;
21715:
21716: END IF;

Line 21864: FND_LOG.LEVEL_UNEXPECTED

21860:
21861: print_debuginfo(l_module_name, 'Fatal: Japanese bank charge '
21862: || 'hook ''' || l_hook_name
21863: || ''', generated exception.',
21864: FND_LOG.LEVEL_UNEXPECTED
21865: );
21866:
21867: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
21868: FND_LOG.LEVEL_UNEXPECTED);

Line 21868: FND_LOG.LEVEL_UNEXPECTED);

21864: FND_LOG.LEVEL_UNEXPECTED
21865: );
21866:
21867: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
21868: FND_LOG.LEVEL_UNEXPECTED);
21869: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
21870: FND_LOG.LEVEL_UNEXPECTED);
21871:
21872: /*

Line 21870: FND_LOG.LEVEL_UNEXPECTED);

21866:
21867: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
21868: FND_LOG.LEVEL_UNEXPECTED);
21869: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
21870: FND_LOG.LEVEL_UNEXPECTED);
21871:
21872: /*
21873: * Propogate exception to caller.
21874: */

Line 21888: FND_LOG.LEVEL_UNEXPECTED

21884:
21885: print_debuginfo(l_module_name, 'Fatal: Japanese bank charge hook '''
21886: || l_hook_name || ''' returned error status code: '
21887: || l_return_status,
21888: FND_LOG.LEVEL_UNEXPECTED
21889: );
21890:
21891: print_debuginfo(l_module_name, 'Raising exception .. ',
21892: FND_LOG.LEVEL_UNEXPECTED);

Line 21892: FND_LOG.LEVEL_UNEXPECTED);

21888: FND_LOG.LEVEL_UNEXPECTED
21889: );
21890:
21891: print_debuginfo(l_module_name, 'Raising exception .. ',
21892: FND_LOG.LEVEL_UNEXPECTED);
21893:
21894: APP_EXCEPTION.RAISE_EXCEPTION;
21895:
21896: END IF;

Line 22040: FND_LOG.LEVEL_UNEXPECTED

22036: WHEN OTHERS THEN
22037:
22038: print_debuginfo(l_module_name, 'Fatal: Extended witholding hook '''
22039: || l_hook_name || ''', generated exception. ',
22040: FND_LOG.LEVEL_UNEXPECTED
22041: );
22042:
22043: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
22044: FND_LOG.LEVEL_UNEXPECTED);

Line 22044: FND_LOG.LEVEL_UNEXPECTED);

22040: FND_LOG.LEVEL_UNEXPECTED
22041: );
22042:
22043: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
22044: FND_LOG.LEVEL_UNEXPECTED);
22045: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
22046: FND_LOG.LEVEL_UNEXPECTED);
22047:
22048: /*

Line 22046: FND_LOG.LEVEL_UNEXPECTED);

22042:
22043: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
22044: FND_LOG.LEVEL_UNEXPECTED);
22045: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
22046: FND_LOG.LEVEL_UNEXPECTED);
22047:
22048: /*
22049: * Propogate exception to caller.
22050: */

Line 22064: FND_LOG.LEVEL_UNEXPECTED

22060:
22061: print_debuginfo(l_module_name, 'Fatal: Extended witholding hook '''
22062: || l_hook_name || ''' returned error status code: '
22063: || l_return_status,
22064: FND_LOG.LEVEL_UNEXPECTED
22065: );
22066:
22067: print_debuginfo(l_module_name, 'Raising exception .. ',
22068: FND_LOG.LEVEL_UNEXPECTED);

Line 22068: FND_LOG.LEVEL_UNEXPECTED);

22064: FND_LOG.LEVEL_UNEXPECTED
22065: );
22066:
22067: print_debuginfo(l_module_name, 'Raising exception .. ',
22068: FND_LOG.LEVEL_UNEXPECTED);
22069:
22070: APP_EXCEPTION.RAISE_EXCEPTION;
22071:
22072: END IF;

Line 22217: FND_LOG.LEVEL_UNEXPECTED

22213: WHEN OTHERS THEN
22214:
22215: print_debuginfo(l_module_name, 'Fatal: Extended witholding hook '''
22216: || l_hook_name || ''', generated exception. ',
22217: FND_LOG.LEVEL_UNEXPECTED
22218: );
22219:
22220: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
22221: FND_LOG.LEVEL_UNEXPECTED);

Line 22221: FND_LOG.LEVEL_UNEXPECTED);

22217: FND_LOG.LEVEL_UNEXPECTED
22218: );
22219:
22220: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
22221: FND_LOG.LEVEL_UNEXPECTED);
22222: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
22223: FND_LOG.LEVEL_UNEXPECTED);
22224:
22225: /*

Line 22223: FND_LOG.LEVEL_UNEXPECTED);

22219:
22220: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
22221: FND_LOG.LEVEL_UNEXPECTED);
22222: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
22223: FND_LOG.LEVEL_UNEXPECTED);
22224:
22225: /*
22226: * Propogate exception to caller.
22227: */

Line 22241: FND_LOG.LEVEL_UNEXPECTED

22237:
22238: print_debuginfo(l_module_name, 'Fatal: Extended witholding hook '''
22239: || l_hook_name || ''' returned error status code: '
22240: || l_return_status,
22241: FND_LOG.LEVEL_UNEXPECTED
22242: );
22243:
22244: print_debuginfo(l_module_name, 'Raising exception .. ',
22245: FND_LOG.LEVEL_UNEXPECTED);

Line 22245: FND_LOG.LEVEL_UNEXPECTED);

22241: FND_LOG.LEVEL_UNEXPECTED
22242: );
22243:
22244: print_debuginfo(l_module_name, 'Raising exception .. ',
22245: FND_LOG.LEVEL_UNEXPECTED);
22246:
22247: APP_EXCEPTION.RAISE_EXCEPTION;
22248:
22249: END IF;

Line 23108: FND_LOG.LEVEL_UNEXPECTED);

23104:
23105: EXCEPTION
23106: WHEN OTHERS THEN
23107: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
23108: FND_LOG.LEVEL_UNEXPECTED);
23109: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
23110: FND_LOG.LEVEL_UNEXPECTED);
23111: print_debuginfo(l_module_name, l_module_name||':Exception while performing rebuildPayments');
23112: RAISE;

Line 23110: FND_LOG.LEVEL_UNEXPECTED);

23106: WHEN OTHERS THEN
23107: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
23108: FND_LOG.LEVEL_UNEXPECTED);
23109: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
23110: FND_LOG.LEVEL_UNEXPECTED);
23111: print_debuginfo(l_module_name, l_module_name||':Exception while performing rebuildPayments');
23112: RAISE;
23113: END rebuildPayments;
23114:

Line 26783: p_debug_level IN VARCHAR2 DEFAULT FND_LOG.LEVEL_STATEMENT

26779: *---------------------------------------------------------------------*/
26780: PROCEDURE print_debuginfo(
26781: p_module IN VARCHAR2,
26782: p_debug_text IN VARCHAR2,
26783: p_debug_level IN VARCHAR2 DEFAULT FND_LOG.LEVEL_STATEMENT
26784: )
26785: IS
26786: l_default_debug_level VARCHAR2(200) := FND_LOG.LEVEL_STATEMENT;
26787: BEGIN

Line 26786: l_default_debug_level VARCHAR2(200) := FND_LOG.LEVEL_STATEMENT;

26782: p_debug_text IN VARCHAR2,
26783: p_debug_level IN VARCHAR2 DEFAULT FND_LOG.LEVEL_STATEMENT
26784: )
26785: IS
26786: l_default_debug_level VARCHAR2(200) := FND_LOG.LEVEL_STATEMENT;
26787: BEGIN
26788:
26789: /*
26790: * Set the debug level to the value passed in

Line 26800: --IF (l_default_debug_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

26796:
26797: /*
26798: * Write the debug message to the concurrent manager log file.
26799: */
26800: --IF (l_default_debug_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
26801: iby_debug_pub.log(debug_msg => p_module||':'||p_debug_text,debug_level => p_debug_level, module => p_module);
26802: --END IF;
26803:
26804: END print_debuginfo;

Line 26831: l_default_debug_level VARCHAR2(200) := FND_LOG.LEVEL_STATEMENT;

26827: IS
26828:
26829: l_module_name VARCHAR2(200) := G_PKG_NAME ||
26830: '.initialize_pmt_table';
26831: l_default_debug_level VARCHAR2(200) := FND_LOG.LEVEL_STATEMENT;
26832:
26833: BEGIN
26834:
26835: IF (l_default_debug_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 26835: IF (l_default_debug_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

26831: l_default_debug_level VARCHAR2(200) := FND_LOG.LEVEL_STATEMENT;
26832:
26833: BEGIN
26834:
26835: IF (l_default_debug_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
26836: print_debuginfo(l_module_name, 'ENTER');
26837: END IF;
26838:
26839: /*IBY_PAYGROUP_PUB.pmtTable.payment_profile_id(l_trx_pmt_index) := NULL;

Line 27204: IF (l_default_debug_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

27200: IBY_PAYGROUP_PUB.pmtTable.payment_process_request_name(l_trx_pmt_index) := NULL;
27201: IBY_PAYGROUP_PUB.pmtTable.source_product(l_trx_pmt_index) := NULL;
27202: IBY_PAYGROUP_PUB.pmtTable.affects_rejection_level(l_trx_pmt_index) := NULL; -- AWT Enh 16296267
27203:
27204: IF (l_default_debug_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
27205: print_debuginfo(l_module_name, 'EXIT');
27206: END IF;
27207:
27208: END initialize_pmt_table;