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

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

4: --
5: -- Declare global variables
6: --
7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'IBY_CHECKNUMBER_PUB';
8: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
9: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
10:
11: --
12: -- List of instruction statuses that are used / set in this

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

5: -- Declare global variables
6: --
7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'IBY_CHECKNUMBER_PUB';
8: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
9: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
10:
11: --
12: -- List of instruction statuses that are used / set in this
13: -- module (payment instruction creation flow).

Line 69: p_debug_level IN VARCHAR2 DEFAULT FND_LOG.LEVEL_STATEMENT

65: --
66: PROCEDURE print_debuginfo(
67: p_module IN VARCHAR2,
68: p_debug_text IN VARCHAR2,
69: p_debug_level IN VARCHAR2 DEFAULT FND_LOG.LEVEL_STATEMENT
70: );
71:
72: /*--------------------------------------------------------------------
73: | NAME:

Line 513: FND_LOG.LEVEL_UNEXPECTED

509: print_debuginfo(l_module_name, 'Exception occured when '
510: || 'getting details of payment document id '
511: || p_pmt_document_id
512: || ' from CE_PAYMENT_DOCUMENTS table.',
513: FND_LOG.LEVEL_UNEXPECTED
514: );
515:
516: print_debuginfo(l_module_name, 'SQL code: '
517: || SQLCODE, FND_LOG.LEVEL_UNEXPECTED);

Line 517: || SQLCODE, FND_LOG.LEVEL_UNEXPECTED);

513: FND_LOG.LEVEL_UNEXPECTED
514: );
515:
516: print_debuginfo(l_module_name, 'SQL code: '
517: || SQLCODE, FND_LOG.LEVEL_UNEXPECTED);
518: print_debuginfo(l_module_name, 'SQL err msg: '
519: || SQLERRM, FND_LOG.LEVEL_UNEXPECTED);
520:
521:

Line 519: || SQLERRM, FND_LOG.LEVEL_UNEXPECTED);

515:
516: print_debuginfo(l_module_name, 'SQL code: '
517: || SQLCODE, FND_LOG.LEVEL_UNEXPECTED);
518: print_debuginfo(l_module_name, 'SQL err msg: '
519: || SQLERRM, FND_LOG.LEVEL_UNEXPECTED);
520:
521:
522: /*
523: * Propogate exception to caller.

Line 610: FND_LOG.LEVEL_UNEXPECTED

606:
607:
608: print_debuginfo(l_module_name, 'Check numbering process '
609: || 'did not succeed. Raising exception ..',
610: FND_LOG.LEVEL_UNEXPECTED
611: );
612:
613:
614: /*

Line 669: FND_LOG.LEVEL_UNEXPECTED

665: || l_callout_name
666: || ''', returned failure status - '
667: || x_return_status
668: || '. Raising exception.',
669: FND_LOG.LEVEL_UNEXPECTED
670: );
671:
672:
673: l_error_code := 'IBY_INS_AWT_CERT_HOOK_FAILED';

Line 698: FND_LOG.LEVEL_UNEXPECTED

694:
695: print_debuginfo(l_module_name, 'Fatal: External app callout '''
696: || l_callout_name
697: || ''', generated exception.',
698: FND_LOG.LEVEL_UNEXPECTED
699: );
700:
701: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
702: FND_LOG.LEVEL_UNEXPECTED);

Line 702: FND_LOG.LEVEL_UNEXPECTED);

698: FND_LOG.LEVEL_UNEXPECTED
699: );
700:
701: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
702: FND_LOG.LEVEL_UNEXPECTED);
703: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
704: FND_LOG.LEVEL_UNEXPECTED);
705:
706:

Line 704: FND_LOG.LEVEL_UNEXPECTED);

700:
701: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
702: FND_LOG.LEVEL_UNEXPECTED);
703: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
704: FND_LOG.LEVEL_UNEXPECTED);
705:
706:
707: /*
708: * Propogate exception to caller.

Line 801: FND_LOG.LEVEL_UNEXPECTED

797: print_debuginfo(l_module_name, 'No documents payable '
798: || 'were found in ''payments created'' status '
799: || 'though created payments exist. '
800: || 'Possible data corruption. Aborting ..',
801: FND_LOG.LEVEL_UNEXPECTED
802: );
803:
804:
805: APP_EXCEPTION.RAISE_EXCEPTION;

Line 1336: FND_LOG.LEVEL_UNEXPECTED

1332:
1333: print_debuginfo(l_module_name, 'Fatal: Exception when updating '
1334: || 'payment instruction/payment status after payment '
1335: || 'instruction creation. All changes will be rolled back.',
1336: FND_LOG.LEVEL_UNEXPECTED
1337: );
1338: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
1339: FND_LOG.LEVEL_UNEXPECTED);
1340: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,

Line 1339: FND_LOG.LEVEL_UNEXPECTED);

1335: || 'instruction creation. All changes will be rolled back.',
1336: FND_LOG.LEVEL_UNEXPECTED
1337: );
1338: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
1339: FND_LOG.LEVEL_UNEXPECTED);
1340: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
1341: FND_LOG.LEVEL_UNEXPECTED);
1342:
1343:

Line 1341: FND_LOG.LEVEL_UNEXPECTED);

1337: );
1338: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
1339: FND_LOG.LEVEL_UNEXPECTED);
1340: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
1341: FND_LOG.LEVEL_UNEXPECTED);
1342:
1343:
1344: /*
1345: * Propogate exception to caller.

Line 2581: FND_LOG.LEVEL_UNEXPECTED

2577: || ''''
2578: || ' with payment doc id '
2579: || p_payment_doc_id
2580: || ' has been locked from payments workbench ',
2581: FND_LOG.LEVEL_UNEXPECTED
2582: );
2583:
2584: print_debuginfo(l_module_name, 'Processing cannot continue '
2585: || 'because payment document is unavailable (locked).',

Line 2586: FND_LOG.LEVEL_UNEXPECTED

2582: );
2583:
2584: print_debuginfo(l_module_name, 'Processing cannot continue '
2585: || 'because payment document is unavailable (locked).',
2586: FND_LOG.LEVEL_UNEXPECTED
2587: );
2588:
2589: print_debuginfo(l_module_name, 'Changing the status of the '
2590: || 'payment instruction to '

Line 2649: FND_LOG.LEVEL_UNEXPECTED

2645: || ' with payment doc id '
2646: || p_payment_doc_id
2647: || ' has been locked by payment instruction '
2648: || l_pmt_instr_id,
2649: FND_LOG.LEVEL_UNEXPECTED
2650: );
2651:
2652: print_debuginfo(l_module_name, 'Processing cannot continue '
2653: || 'because payment document is unavailable (locked).',

Line 2654: FND_LOG.LEVEL_UNEXPECTED

2650: );
2651:
2652: print_debuginfo(l_module_name, 'Processing cannot continue '
2653: || 'because payment document is unavailable (locked).',
2654: FND_LOG.LEVEL_UNEXPECTED
2655: );
2656:
2657: print_debuginfo(l_module_name, 'Changing the status of the '
2658: || 'payment instruction to '

Line 2827: FND_LOG.LEVEL_UNEXPECTED

2823: print_debuginfo(l_module_name, 'Deferring payment '
2824: || 'instruction print '
2825: || x_pmtInstrRec.payment_instruction_id
2826: || ' because of insufficient paper stock.',
2827: FND_LOG.LEVEL_UNEXPECTED
2828: );
2829:
2830:
2831: x_pmtInstrRec.payment_instruction_status := l_instr_status;

Line 3221: FND_LOG.LEVEL_UNEXPECTED

3217: || '. Actual last used check number: '
3218: || l_last_used_check_num
3219: || '. Deferring print for payment instruction '
3220: || x_pmtInstrRec.payment_instruction_id,
3221: FND_LOG.LEVEL_UNEXPECTED
3222: );
3223:
3224:
3225: x_pmtInstrRec.payment_instruction_status := l_instr_status;

Line 4488: FND_LOG.LEVEL_UNEXPECTED

4484:
4485: print_debuginfo(l_module_name, 'Fatal: Exception when attempting '
4486: || 'to get processing type for payment '
4487: || l_pmt_rec.payment_id,
4488: FND_LOG.LEVEL_UNEXPECTED
4489: );
4490:
4491: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
4492: FND_LOG.LEVEL_UNEXPECTED);

Line 4492: FND_LOG.LEVEL_UNEXPECTED);

4488: FND_LOG.LEVEL_UNEXPECTED
4489: );
4490:
4491: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
4492: FND_LOG.LEVEL_UNEXPECTED);
4493: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
4494: FND_LOG.LEVEL_UNEXPECTED);
4495:
4496:

Line 4494: FND_LOG.LEVEL_UNEXPECTED);

4490:
4491: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
4492: FND_LOG.LEVEL_UNEXPECTED);
4493: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
4494: FND_LOG.LEVEL_UNEXPECTED);
4495:
4496:
4497: /*
4498: * Propogate exception to caller.

Line 5001: p_debug_level IN VARCHAR2 DEFAULT FND_LOG.LEVEL_STATEMENT

4997: *---------------------------------------------------------------------*/
4998: PROCEDURE print_debuginfo(
4999: p_module IN VARCHAR2,
5000: p_debug_text IN VARCHAR2,
5001: p_debug_level IN VARCHAR2 DEFAULT FND_LOG.LEVEL_STATEMENT
5002: )
5003: IS
5004: l_default_debug_level VARCHAR2(200) := FND_LOG.LEVEL_STATEMENT;
5005: BEGIN

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

5000: p_debug_text IN VARCHAR2,
5001: p_debug_level IN VARCHAR2 DEFAULT FND_LOG.LEVEL_STATEMENT
5002: )
5003: IS
5004: l_default_debug_level VARCHAR2(200) := FND_LOG.LEVEL_STATEMENT;
5005: BEGIN
5006:
5007: /*
5008: * Set the debug level to the value passed in

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

5014:
5015: /*
5016: * Write the debug message to the concurrent manager log file.
5017: */
5018: --IF (l_default_debug_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5019:
5020: iby_debug_pub.log(debug_msg => p_module||':'||p_debug_text,debug_level => p_debug_level, module => p_module);
5021:
5022: --END IF;

Line 5088: IF (G_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

5084: l_module_name VARCHAR2(200) := G_PKG_NAME || '.assignCheckNumbers';
5085:
5086: BEGIN
5087:
5088: IF (G_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5089: print_debuginfo(l_module_name, 'ENTER');
5090: END IF;
5091:
5092: l_paper_pmts_count := x_paperPmtsTab.COUNT;

Line 5105: --IF (G_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

5101: * payment instruction with processing type 'PAPER'.
5102: *
5103: * If no such payment exists, about the program.
5104: */
5105: --IF (G_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5106: print_debuginfo(l_module_name, 'Total # of Electronic payments '
5107: || 'is 0. Possible data corruption. Aborting ..'
5108: );
5109:

Line 5110: IF (G_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

5106: print_debuginfo(l_module_name, 'Total # of Electronic payments '
5107: || 'is 0. Possible data corruption. Aborting ..'
5108: );
5109:
5110: IF (G_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5111: print_debuginfo(l_module_name, 'EXIT');
5112: END IF;
5113: x_return_status := -1;
5114:

Line 5133: IF (G_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

5129: x_return_message := FND_MESSAGE.get;
5130:
5131: RETURN;
5132: ELSE
5133: IF (G_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5134: print_debuginfo(l_module_name, 'Total # of Electronic payments: '
5135: || l_paper_pmts_count
5136: );
5137: END IF;

Line 5165: IF (G_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

5161: * this is because 'CREATED' is a transient status.
5162: */
5163: COMMIT;
5164:
5165: IF (G_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5166: print_debuginfo(l_module_name, 'Payment instruction '
5167: || x_pmtInstrRec.payment_instruction_id
5168: || ' status committed to '
5169: || l_instr_status

Line 5198: IF (G_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

5194: payment_document_id = p_payment_doc_id
5195: ;
5196:
5197:
5198: IF (G_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5199: print_debuginfo(l_module_name, 'Got the payment document name');
5200: END IF;
5201:
5202: /*

Line 5242: FND_LOG.LEVEL_UNEXPECTED

5238: || ''''
5239: || ' with payment doc id '
5240: || p_payment_doc_id
5241: || ' has been locked from payments workbench ',
5242: FND_LOG.LEVEL_UNEXPECTED
5243: );
5244:
5245: --IF (G_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5246: print_debuginfo(l_module_name, 'Processing cannot continue '

Line 5245: --IF (G_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

5241: || ' has been locked from payments workbench ',
5242: FND_LOG.LEVEL_UNEXPECTED
5243: );
5244:
5245: --IF (G_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5246: print_debuginfo(l_module_name, 'Processing cannot continue '
5247: || 'because payment document is unavailable (locked).',
5248: FND_LOG.LEVEL_UNEXPECTED
5249: );

Line 5248: FND_LOG.LEVEL_UNEXPECTED

5244:
5245: --IF (G_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5246: print_debuginfo(l_module_name, 'Processing cannot continue '
5247: || 'because payment document is unavailable (locked).',
5248: FND_LOG.LEVEL_UNEXPECTED
5249: );
5250:
5251:
5252: print_debuginfo(l_module_name, 'Changing the status of the '

Line 5294: IF (G_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

5290: );
5291:
5292: x_return_message := FND_MESSAGE.get;
5293:
5294: IF (G_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5295: print_debuginfo(l_module_name, 'EXIT');
5296: END IF;
5297: RETURN;
5298:

Line 5302: --IF (G_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

5298:
5299:
5300: END;
5301: IF (l_pmt_instr_id IS NOT NULL) THEN
5302: --IF (G_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5303: print_debuginfo(l_module_name, 'Payment document '
5304: || ''''
5305: || l_pmt_doc_name
5306: || ''''

Line 5311: FND_LOG.LEVEL_UNEXPECTED

5307: || ' with payment doc id '
5308: || p_payment_doc_id
5309: || ' has been locked by payment instruction '
5310: || l_pmt_instr_id,
5311: FND_LOG.LEVEL_UNEXPECTED
5312: );
5313:
5314:
5315: print_debuginfo(l_module_name, 'Processing cannot continue '

Line 5317: FND_LOG.LEVEL_UNEXPECTED

5313:
5314:
5315: print_debuginfo(l_module_name, 'Processing cannot continue '
5316: || 'because payment document is unavailable (locked).',
5317: FND_LOG.LEVEL_UNEXPECTED
5318: );
5319:
5320: print_debuginfo(l_module_name, 'Changing the status of the '
5321: || 'payment instruction to '

Line 5371: IF (G_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

5367: );
5368:
5369: x_return_message := FND_MESSAGE.get;
5370:
5371: IF (G_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5372: print_debuginfo(l_module_name, 'EXIT');
5373: END IF;
5374: RETURN;
5375:

Line 5383: IF (G_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

5379: * Log warnings if there is any missing/incomplete information.
5380: */
5381: IF (l_last_avail_check_num = -1) THEN
5382:
5383: IF (G_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5384: print_debuginfo(l_module_name, 'Warning: payment document id '
5385: || p_payment_doc_id
5386: || ' has no last available document number set. '
5387: || 'Assuming that infinite number of paper documents '

Line 5396: IF (G_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

5392: END IF;
5393:
5394: IF (l_last_used_check_num = 0) THEN
5395:
5396: IF (G_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5397: print_debuginfo(l_module_name, 'Warning: payment document id '
5398: || p_payment_doc_id
5399: || ' has last used document number set to zero. '
5400: || 'Assuming that no paper documents have yet '

Line 5418: IF (G_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

5414: * from the last issued check number on the payment document + 1.
5415: */
5416: IF (p_user_assgn_num IS NULL) THEN
5417:
5418: IF (G_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5419: print_debuginfo(l_module_name, 'User has not explicitly '
5420: || 'provided a check number to start numbering from. '
5421: || 'Numbering will start from last issued check number '
5422: || 'on check stock.'

Line 5428: IF (G_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

5424: END IF;
5425:
5426: ELSE
5427:
5428: IF (G_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5429: print_debuginfo(l_module_name, 'User has explicitly '
5430: || 'provided start number for numbering: '
5431: || p_user_assgn_num
5432: );

Line 5466: IF (G_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

5462: */
5463: l_physical_stock_count := l_last_avail_check_num
5464: - l_last_used_check_num;
5465:
5466: IF (G_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5467: print_debuginfo(l_module_name, 'Available paper stock = '
5468: || l_physical_stock_count
5469: || ' for payment document name '
5470: || ''''

Line 5490: FND_LOG.LEVEL_UNEXPECTED

5486: print_debuginfo(l_module_name, 'Deferring payment '
5487: || 'instruction print '
5488: || x_pmtInstrRec.payment_instruction_id
5489: || ' because of insufficient paper stock.',
5490: FND_LOG.LEVEL_UNEXPECTED
5491: );
5492:
5493:
5494: x_pmtInstrRec.payment_instruction_status := l_instr_status;

Line 5556: IF (G_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

5552: APP_EXCEPTION.RAISE_EXCEPTION;
5553:
5554: ELSE
5555:
5556: IF (G_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5557: print_debuginfo(l_module_name, 'Sufficient paper stock '
5558: || 'is available to print this instruction.'
5559: );
5560: END IF;

Line 5599: --IF (G_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

5595: );
5596:
5597: IF (l_nos_avlbl_flag = FALSE) THEN
5598:
5599: --IF (G_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5600: print_debuginfo(l_module_name, 'Contiguous paper stock '
5601: || 'is not available for printing payment instruction '
5602: || x_pmtInstrRec.payment_instruction_id
5603: );

Line 5627: IF (G_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

5623: );
5624:
5625: x_return_message := FND_MESSAGE.get;
5626:
5627: IF (G_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5628: print_debuginfo(l_module_name, 'EXIT');
5629: END IF;
5630: RETURN;
5631:

Line 5668: -- IF (G_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

5664: l_anticipated_last_check_num);
5665:
5666: IF (l_used_flag = TRUE) THEN
5667:
5668: -- IF (G_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5669: print_debuginfo(l_module_name, 'Paper document number(s) '
5670: || 'generated after numbering are invalid (already used). '
5671: || 'User needs to provide a new start number or use '
5672: || 'the defaulted start number.'

Line 5693: IF (G_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

5689: );
5690:
5691: x_return_message := FND_MESSAGE.get;
5692:
5693: IF (G_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5694: print_debuginfo(l_module_name, 'EXIT');
5695: END IF;
5696: RETURN;
5697:

Line 5700: IF (G_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

5696: RETURN;
5697:
5698: ELSE
5699:
5700: IF (G_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5701: print_debuginfo(l_module_name, 'Paper document number(s) '
5702: || 'generated after numbering are unused. '
5703: );
5704: END IF;

Line 5716: IF (G_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

5712: * not be locked (see bug 4597718).
5713: */
5714: IF (l_single_pmt_flag = TRUE) THEN
5715:
5716: IF (G_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5717: print_debuginfo(l_module_name, 'This is a single payment. '
5718: || 'Payment document will not be locked ..'
5719: );
5720: END IF;

Line 5738: IF (G_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

5734: ;
5735:
5736: ELSE
5737:
5738: IF (G_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5739: print_debuginfo(l_module_name, 'This is not a single payment. '
5740: || 'Payment document will be locked ..'
5741: );
5742: END IF;

Line 5759: IF (G_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

5755: ;
5756:
5757: END IF;
5758:
5759: IF (G_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5760: print_debuginfo(l_module_name, 'Finished updating the last '
5761: || 'available check number in CE_PAYMENT_DOCUMENTS. '
5762: || 'Current last check number: '
5763: || l_anticipated_last_check_num

Line 5831: FND_LOG.LEVEL_UNEXPECTED

5827: || '. Actual last used check number: '
5828: || l_last_used_check_num
5829: || '. Deferring print for payment instruction '
5830: || x_pmtInstrRec.payment_instruction_id,
5831: FND_LOG.LEVEL_UNEXPECTED
5832: );
5833:
5834:
5835: x_pmtInstrRec.payment_instruction_status := l_instr_status;

Line 5897: IF (G_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

5893: */
5894: x_return_message := 'SUCCESS';
5895: x_return_status := 0;
5896:
5897: IF (G_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5898: print_debuginfo(l_module_name, 'EXIT');
5899: END IF;
5900:
5901: EXCEPTION

Line 5904: IF (G_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

5900:
5901: EXCEPTION
5902: WHEN OTHERS THEN
5903:
5904: IF (G_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5905: print_debuginfo(l_module_name, 'Exception occured when '
5906: || 'performing document numbering. '
5907: );
5908: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE);

Line 5922: IF (G_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

5918: * The error message would have already been set.
5919: */
5920: x_return_status := -1;
5921:
5922: IF (G_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5923: print_debuginfo(l_module_name, 'EXIT');
5924: END IF;
5925:
5926: END assignElectronicCheckNumbers;