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_PAYINSTR_PUB dependencies on FND_LOG

Line 54: p_debug_level IN VARCHAR2 DEFAULT FND_LOG.LEVEL_STATEMENT

50: --
51: PROCEDURE print_debuginfo(
52: p_module IN VARCHAR2,
53: p_debug_text IN VARCHAR2,
54: p_debug_level IN VARCHAR2 DEFAULT FND_LOG.LEVEL_STATEMENT
55: );
56:
57: /*--------------------------------------------------------------------
58: | NAME:

Line 290: FND_LOG.LEVEL_UNEXPECTED

286:
287: print_debuginfo(l_module_name, 'Provided processing type: '
288: || p_processing_type
289: || ' is invalid. Aborting program ..',
290: FND_LOG.LEVEL_UNEXPECTED
291: );
292:
293: FND_MESSAGE.SET_NAME('IBY', 'IBY_INS_MISSING_PROCESS_TYPE');
294: FND_MSG_PUB.ADD;

Line 312: FND_LOG.LEVEL_UNEXPECTED

308:
309: print_debuginfo(l_module_name, 'Invalid selection '
310: || 'criteria provided; org id has been provided '
311: || 'but org type has not been provided.',
312: FND_LOG.LEVEL_UNEXPECTED
313: );
314:
315: print_debuginfo(l_module_name, 'Payment instruction '
316: || 'creation will not proceed.',

Line 317: FND_LOG.LEVEL_UNEXPECTED

313: );
314:
315: print_debuginfo(l_module_name, 'Payment instruction '
316: || 'creation will not proceed.',
317: FND_LOG.LEVEL_UNEXPECTED
318: );
319:
320: FND_MESSAGE.SET_NAME('IBY', 'IBY_INS_MISSING_ORG_TYPE');
321: FND_MSG_PUB.ADD;

Line 347: FND_LOG.LEVEL_UNEXPECTED

343:
344: print_debuginfo(l_module_name, 'Payment document id is '
345: || 'mandatory for printed processing type. '
346: || 'Insufficient data. Aborting program ..',
347: FND_LOG.LEVEL_UNEXPECTED
348: );
349:
350: FND_MESSAGE.SET_NAME('IBY', 'IBY_INS_MISSING_PMT_DOCUMENT');
351: FND_MSG_PUB.ADD;

Line 368: FND_LOG.LEVEL_UNEXPECTED

364:
365: print_debuginfo(l_module_name, 'Print immediate flag is '
366: || 'mandatory for printed processing type. '
367: || 'Insufficient data. Aborting program ..',
368: FND_LOG.LEVEL_UNEXPECTED
369: );
370:
371: FND_MESSAGE.SET_NAME('IBY', 'IBY_INS_MISSING_PRINT_NOW_FLAG');
372: FND_MSG_PUB.ADD;

Line 389: FND_LOG.LEVEL_UNEXPECTED

385:
386: print_debuginfo(l_module_name, 'Printer name is '
387: || 'mandatory if print immediate flag is '
388: || 'set to "Y". Aborting program ..',
389: FND_LOG.LEVEL_UNEXPECTED
390: );
391:
392: FND_MESSAGE.SET_NAME('IBY', 'IBY_INS_MISSING_PRINTER');
393: FND_MSG_PUB.ADD;

Line 461: FND_LOG.LEVEL_UNEXPECTED

457:
458: print_debuginfo(l_module_name, 'Transmit now flag is '
459: || 'mandatory for electronic processing type. '
460: || 'Insufficient data. Aborting program ..',
461: FND_LOG.LEVEL_UNEXPECTED
462: );
463:
464: FND_MESSAGE.SET_NAME('IBY', 'IBY_INS_MISSING_TRANSMIT_NOW_FLAG');
465: FND_MSG_PUB.ADD;

Line 958: FND_LOG.LEVEL_UNEXPECTED

954: || ' and exchange rate type '
955: || l_exchg_rate_type
956: || ' failed. '
957: || 'Raising exception.',
958: FND_LOG.LEVEL_UNEXPECTED
959: );
960:
961: APP_EXCEPTION.RAISE_EXCEPTION;
962:

Line 1727: FND_LOG.LEVEL_UNEXPECTED

1723: || 'picked up for payment instruction '
1724: || l_instruction_id
1725: || '. Possible data corruption. Aborting '
1726: || 'program.',
1727: FND_LOG.LEVEL_UNEXPECTED
1728: );
1729:
1730: APP_EXCEPTION.RAISE_EXCEPTION;
1731:

Line 1785: FND_LOG.LEVEL_UNEXPECTED

1781:
1782: print_debuginfo(l_module_name, 'Exception occured when '
1783: || 're-creating payment instruction id '
1784: || l_instruction_id,
1785: FND_LOG.LEVEL_UNEXPECTED
1786: );
1787:
1788: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
1789: FND_LOG.LEVEL_UNEXPECTED);

Line 1789: FND_LOG.LEVEL_UNEXPECTED);

1785: FND_LOG.LEVEL_UNEXPECTED
1786: );
1787:
1788: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
1789: FND_LOG.LEVEL_UNEXPECTED);
1790: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
1791: FND_LOG.LEVEL_UNEXPECTED);
1792:
1793: print_debuginfo(l_module_name, 'EXIT');

Line 1791: FND_LOG.LEVEL_UNEXPECTED);

1787:
1788: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
1789: FND_LOG.LEVEL_UNEXPECTED);
1790: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
1791: FND_LOG.LEVEL_UNEXPECTED);
1792:
1793: print_debuginfo(l_module_name, 'EXIT');
1794:
1795: /*

Line 3185: FND_LOG.LEVEL_UNEXPECTED

3181: WHEN OTHERS THEN
3182: print_debuginfo(l_module_name, 'Fatal: Exception when updating '
3183: || 'payment instruction/payment status after payment '
3184: || 'instruction creation. All changes will be rolled back.',
3185: FND_LOG.LEVEL_UNEXPECTED
3186: );
3187: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
3188: FND_LOG.LEVEL_UNEXPECTED);
3189: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,

Line 3188: FND_LOG.LEVEL_UNEXPECTED);

3184: || 'instruction creation. All changes will be rolled back.',
3185: FND_LOG.LEVEL_UNEXPECTED
3186: );
3187: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
3188: FND_LOG.LEVEL_UNEXPECTED);
3189: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
3190: FND_LOG.LEVEL_UNEXPECTED);
3191:
3192: /*

Line 3190: FND_LOG.LEVEL_UNEXPECTED);

3186: );
3187: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
3188: FND_LOG.LEVEL_UNEXPECTED);
3189: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
3190: FND_LOG.LEVEL_UNEXPECTED);
3191:
3192: /*
3193: * Propogate exception to caller.
3194: */

Line 3834: FND_LOG.LEVEL_UNEXPECTED

3830: print_debuginfo(l_module_name, 'Data inconsistency: '
3831: || 'Failed payment instruction exists in PLSQL '
3832: || 'table, but not database table (though database '
3833: || 'insert has occured). Aborting program ..',
3834: FND_LOG.LEVEL_UNEXPECTED
3835: );
3836:
3837: APP_EXCEPTION.RAISE_EXCEPTION;
3838:

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

3871:
3872: EXCEPTION
3873: WHEN OTHERS THEN
3874: print_debuginfo(l_module_name, 'Fatal: Exception when attempting '
3875: || 'to raise business event.', FND_LOG.LEVEL_UNEXPECTED);
3876: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
3877: FND_LOG.LEVEL_UNEXPECTED);
3878: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
3879: FND_LOG.LEVEL_UNEXPECTED);

Line 3877: FND_LOG.LEVEL_UNEXPECTED);

3873: WHEN OTHERS THEN
3874: print_debuginfo(l_module_name, 'Fatal: Exception when attempting '
3875: || 'to raise business event.', FND_LOG.LEVEL_UNEXPECTED);
3876: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
3877: FND_LOG.LEVEL_UNEXPECTED);
3878: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
3879: FND_LOG.LEVEL_UNEXPECTED);
3880:
3881: /*

Line 3879: FND_LOG.LEVEL_UNEXPECTED);

3875: || 'to raise business event.', FND_LOG.LEVEL_UNEXPECTED);
3876: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
3877: FND_LOG.LEVEL_UNEXPECTED);
3878: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
3879: FND_LOG.LEVEL_UNEXPECTED);
3880:
3881: /*
3882: * Propogate exception to caller.
3883: */

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

4001: RETURN NULL;
4002: END IF;
4003:
4004: print_debuginfo(l_module_name, 'Fatal: Exception when attempting '
4005: || 'to raise business event.', FND_LOG.LEVEL_UNEXPECTED);
4006: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
4007: FND_LOG.LEVEL_UNEXPECTED);
4008: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
4009: FND_LOG.LEVEL_UNEXPECTED);

Line 4007: FND_LOG.LEVEL_UNEXPECTED);

4003:
4004: print_debuginfo(l_module_name, 'Fatal: Exception when attempting '
4005: || 'to raise business event.', FND_LOG.LEVEL_UNEXPECTED);
4006: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
4007: FND_LOG.LEVEL_UNEXPECTED);
4008: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
4009: FND_LOG.LEVEL_UNEXPECTED);
4010:
4011: /*

Line 4009: FND_LOG.LEVEL_UNEXPECTED);

4005: || 'to raise business event.', FND_LOG.LEVEL_UNEXPECTED);
4006: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
4007: FND_LOG.LEVEL_UNEXPECTED);
4008: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
4009: FND_LOG.LEVEL_UNEXPECTED);
4010:
4011: /*
4012: * Propogate exception to caller.
4013: */

Line 4133: FND_LOG.LEVEL_UNEXPECTED

4129: || 'picked up for payment instruction '
4130: || x_pmtInstrTab(i).payment_instruction_id
4131: || '. Possible data corruption. Aborting '
4132: || 'program.',
4133: FND_LOG.LEVEL_UNEXPECTED
4134: );
4135:
4136: APP_EXCEPTION.RAISE_EXCEPTION;
4137:

Line 4214: FND_LOG.LEVEL_UNEXPECTED

4210:
4211: print_debuginfo(l_module_name, 'Exception occured when '
4212: || 'performing sorted payment numbering for '
4213: || 'payment instructions.',
4214: FND_LOG.LEVEL_UNEXPECTED
4215: );
4216:
4217: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
4218: FND_LOG.LEVEL_UNEXPECTED);

Line 4218: FND_LOG.LEVEL_UNEXPECTED);

4214: FND_LOG.LEVEL_UNEXPECTED
4215: );
4216:
4217: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
4218: FND_LOG.LEVEL_UNEXPECTED);
4219: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
4220: FND_LOG.LEVEL_UNEXPECTED);
4221:
4222: print_debuginfo(l_module_name, 'EXIT');

Line 4220: FND_LOG.LEVEL_UNEXPECTED);

4216:
4217: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
4218: FND_LOG.LEVEL_UNEXPECTED);
4219: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
4220: FND_LOG.LEVEL_UNEXPECTED);
4221:
4222: print_debuginfo(l_module_name, 'EXIT');
4223:
4224: /*

Line 4695: FND_LOG.LEVEL_UNEXPECTED

4691: print_debuginfo(l_module_name, 'Primary ledger '
4692: || 'linked to legal entity id '
4693: || l_le_id
4694: || ' was not found. Raising exception ..',
4695: FND_LOG.LEVEL_UNEXPECTED
4696: );
4697:
4698: APP_EXCEPTION.RAISE_EXCEPTION;
4699:

Line 4713: FND_LOG.LEVEL_UNEXPECTED

4709:
4710: print_debuginfo(l_module_name, 'Exception occured when '
4711: || 'attempting to get primary ledger for payment id '
4712: || x_sortedPmtTab(i).payment_id,
4713: FND_LOG.LEVEL_UNEXPECTED
4714: );
4715:
4716: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
4717: FND_LOG.LEVEL_UNEXPECTED);

Line 4717: FND_LOG.LEVEL_UNEXPECTED);

4713: FND_LOG.LEVEL_UNEXPECTED
4714: );
4715:
4716: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
4717: FND_LOG.LEVEL_UNEXPECTED);
4718: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
4719: FND_LOG.LEVEL_UNEXPECTED);
4720:
4721: /*

Line 4719: FND_LOG.LEVEL_UNEXPECTED);

4715:
4716: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
4717: FND_LOG.LEVEL_UNEXPECTED);
4718: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
4719: FND_LOG.LEVEL_UNEXPECTED);
4720:
4721: /*
4722: * If we could not get the ledger id, then payment
4723: * document sequencing will fail. There is no point

Line 4892: FND_LOG.LEVEL_UNEXPECTED

4888: || ', method code: '
4889: || 'A'
4890: || ', payment date: '
4891: || x_sortedPmtTab(i).payment_date,
4892: FND_LOG.LEVEL_UNEXPECTED
4893: );
4894:
4895: /*
4896: * Propogate the exception.

Line 4919: FND_LOG.LEVEL_UNEXPECTED

4915: WHEN OTHERS THEN
4916:
4917: print_debuginfo(l_module_name, 'Exception occured when attempting '
4918: || 'to perform document sequencing for payment instructions.',
4919: FND_LOG.LEVEL_UNEXPECTED
4920: );
4921:
4922: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
4923: FND_LOG.LEVEL_UNEXPECTED);

Line 4923: FND_LOG.LEVEL_UNEXPECTED);

4919: FND_LOG.LEVEL_UNEXPECTED
4920: );
4921:
4922: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
4923: FND_LOG.LEVEL_UNEXPECTED);
4924: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
4925: FND_LOG.LEVEL_UNEXPECTED);
4926:
4927: /*

Line 4925: FND_LOG.LEVEL_UNEXPECTED);

4921:
4922: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
4923: FND_LOG.LEVEL_UNEXPECTED);
4924: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
4925: FND_LOG.LEVEL_UNEXPECTED);
4926:
4927: /*
4928: * Propogate exception to caller.
4929: */

Line 5185: FND_LOG.LEVEL_UNEXPECTED

5181: print_debuginfo(l_module_name, 'Payment reference information '
5182: || 'not setup. Last used ref number: '
5183: || l_last_used_ref_num
5184: || '. Cannot continue. Aborting ..',
5185: FND_LOG.LEVEL_UNEXPECTED
5186: );
5187:
5188: APP_EXCEPTION.RAISE_EXCEPTION;
5189:

Line 5332: FND_LOG.LEVEL_UNEXPECTED

5328: print_debuginfo(l_module_name, 'No documents payable '
5329: || 'were found in ''payments created'' status '
5330: || 'though created payments exist. '
5331: || 'Possible data corruption. Aborting ..',
5332: FND_LOG.LEVEL_UNEXPECTED
5333: );
5334:
5335: APP_EXCEPTION.RAISE_EXCEPTION;
5336:

Line 6160: FND_LOG.LEVEL_UNEXPECTED

6156: print_debuginfo(l_module_name, 'Exception occured when '
6157: || 'checking whether document sequencing has been '
6158: || 'already completed for payment instruction '
6159: || p_instr_id,
6160: FND_LOG.LEVEL_UNEXPECTED
6161: );
6162:
6163: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
6164: FND_LOG.LEVEL_UNEXPECTED);

Line 6164: FND_LOG.LEVEL_UNEXPECTED);

6160: FND_LOG.LEVEL_UNEXPECTED
6161: );
6162:
6163: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
6164: FND_LOG.LEVEL_UNEXPECTED);
6165: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
6166: FND_LOG.LEVEL_UNEXPECTED);
6167:
6168: print_debuginfo(l_module_name, 'EXIT');

Line 6166: FND_LOG.LEVEL_UNEXPECTED);

6162:
6163: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
6164: FND_LOG.LEVEL_UNEXPECTED);
6165: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
6166: FND_LOG.LEVEL_UNEXPECTED);
6167:
6168: print_debuginfo(l_module_name, 'EXIT');
6169:
6170: /*

Line 6453: FND_LOG.LEVEL_UNEXPECTED

6449:
6450: print_debuginfo(l_module_name, 'Exception occured when attempting '
6451: || 'to get payments in sorted order for payment instruction '
6452: || p_instr_id,
6453: FND_LOG.LEVEL_UNEXPECTED
6454: );
6455:
6456: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
6457: FND_LOG.LEVEL_UNEXPECTED);

Line 6457: FND_LOG.LEVEL_UNEXPECTED);

6453: FND_LOG.LEVEL_UNEXPECTED
6454: );
6455:
6456: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
6457: FND_LOG.LEVEL_UNEXPECTED);
6458: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
6459: FND_LOG.LEVEL_UNEXPECTED);
6460:
6461: /*

Line 6459: FND_LOG.LEVEL_UNEXPECTED);

6455:
6456: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
6457: FND_LOG.LEVEL_UNEXPECTED);
6458: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
6459: FND_LOG.LEVEL_UNEXPECTED);
6460:
6461: /*
6462: * Propagate exception to caller.
6463: */

Line 6622: FND_LOG.LEVEL_UNEXPECTED

6618: print_debuginfo(l_module_name, 'Exception occured when '
6619: || 'retrieving profile for '
6620: || 'payment instruction '
6621: || l_pmt_instr_id,
6622: FND_LOG.LEVEL_UNEXPECTED
6623: );
6624: print_debuginfo(l_module_name, 'SQLCODE: ' || SQLCODE,
6625: FND_LOG.LEVEL_UNEXPECTED);
6626: print_debuginfo(l_module_name, 'SQLERRM: ' || SQLERRM,

Line 6625: FND_LOG.LEVEL_UNEXPECTED);

6621: || l_pmt_instr_id,
6622: FND_LOG.LEVEL_UNEXPECTED
6623: );
6624: print_debuginfo(l_module_name, 'SQLCODE: ' || SQLCODE,
6625: FND_LOG.LEVEL_UNEXPECTED);
6626: print_debuginfo(l_module_name, 'SQLERRM: ' || SQLERRM,
6627: FND_LOG.LEVEL_UNEXPECTED);
6628:
6629: /*

Line 6627: FND_LOG.LEVEL_UNEXPECTED);

6623: );
6624: print_debuginfo(l_module_name, 'SQLCODE: ' || SQLCODE,
6625: FND_LOG.LEVEL_UNEXPECTED);
6626: print_debuginfo(l_module_name, 'SQLERRM: ' || SQLERRM,
6627: FND_LOG.LEVEL_UNEXPECTED);
6628:
6629: /*
6630: * Propogate exception to caller.
6631: */

Line 6909: p_debug_level IN VARCHAR2 DEFAULT FND_LOG.LEVEL_STATEMENT

6905: *---------------------------------------------------------------------*/
6906: PROCEDURE print_debuginfo(
6907: p_module IN VARCHAR2,
6908: p_debug_text IN VARCHAR2,
6909: p_debug_level IN VARCHAR2 DEFAULT FND_LOG.LEVEL_STATEMENT
6910: )
6911: IS
6912: l_default_debug_level VARCHAR2(200) := FND_LOG.LEVEL_STATEMENT;
6913: BEGIN

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

6908: p_debug_text IN VARCHAR2,
6909: p_debug_level IN VARCHAR2 DEFAULT FND_LOG.LEVEL_STATEMENT
6910: )
6911: IS
6912: l_default_debug_level VARCHAR2(200) := FND_LOG.LEVEL_STATEMENT;
6913: BEGIN
6914:
6915: /*
6916: * Set the debug level to the value passed in

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

6922:
6923: /*
6924: * Write the debug message to the concurrent manager log file.
6925: */
6926: IF (l_default_debug_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6927: iby_build_utils_pkg.print_debuginfo(p_module, p_debug_text,
6928: p_debug_level);
6929: END IF;
6930: