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.FUN_SEQ_BATCH dependencies on FND_LOG

Line 64: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

60: BEGIN
61: --
62: -- Debug Info Begin
63: --
64: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
65: fnd_log.string(
66: log_level => fnd_log.level_procedure,
67: module => l_module || '.' || 'begin',
68: message =>

Line 65: fnd_log.string(

61: --
62: -- Debug Info Begin
63: --
64: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
65: fnd_log.string(
66: log_level => fnd_log.level_procedure,
67: module => l_module || '.' || 'begin',
68: message =>
69: 'p_application_id => ' || p_application_id || ', ' ||

Line 66: log_level => fnd_log.level_procedure,

62: -- Debug Info Begin
63: --
64: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
65: fnd_log.string(
66: log_level => fnd_log.level_procedure,
67: module => l_module || '.' || 'begin',
68: message =>
69: 'p_application_id => ' || p_application_id || ', ' ||
70: 'p_table_name => ' || p_table_name || ', ' ||

Line 133: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

129: COMMIT;
130: --
131: -- Debug Info End
132: --
133: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
134: fnd_log.string(
135: log_level => fnd_log.level_procedure,
136: module => l_module || '.' || 'end',
137: message => 'x_status => ' || x_status || ', ' ||

Line 134: fnd_log.string(

130: --
131: -- Debug Info End
132: --
133: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
134: fnd_log.string(
135: log_level => fnd_log.level_procedure,
136: module => l_module || '.' || 'end',
137: message => 'x_status => ' || x_status || ', ' ||
138: 'x_seq_context_id => ' || x_seq_context_id);

Line 135: log_level => fnd_log.level_procedure,

131: -- Debug Info End
132: --
133: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
134: fnd_log.string(
135: log_level => fnd_log.level_procedure,
136: module => l_module || '.' || 'end',
137: message => 'x_status => ' || x_status || ', ' ||
138: 'x_seq_context_id => ' || x_seq_context_id);
139: END IF;

Line 145: IF fnd_log.level_error >= fnd_log.g_current_runtime_level THEN

141: WHEN OTHERS THEN
142: --
143: -- Logging
144: --
145: IF fnd_log.level_error >= fnd_log.g_current_runtime_level THEN
146: fnd_log.string (
147: log_level => fnd_log.level_error,
148: module => l_module,
149: message => 'SQLERRM: ' || SQLERRM);

Line 146: fnd_log.string (

142: --
143: -- Logging
144: --
145: IF fnd_log.level_error >= fnd_log.g_current_runtime_level THEN
146: fnd_log.string (
147: log_level => fnd_log.level_error,
148: module => l_module,
149: message => 'SQLERRM: ' || SQLERRM);
150: END IF;

Line 147: log_level => fnd_log.level_error,

143: -- Logging
144: --
145: IF fnd_log.level_error >= fnd_log.g_current_runtime_level THEN
146: fnd_log.string (
147: log_level => fnd_log.level_error,
148: module => l_module,
149: message => 'SQLERRM: ' || SQLERRM);
150: END IF;
151: --

Line 183: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

179: BEGIN
180: --
181: -- Debug Info
182: --
183: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
184: fnd_log.string(
185: log_level => fnd_log.level_procedure,
186: module => l_module || '.' || 'begin',
187: message => 'p_request_id => ' || p_request_id);

Line 184: fnd_log.string(

180: --
181: -- Debug Info
182: --
183: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
184: fnd_log.string(
185: log_level => fnd_log.level_procedure,
186: module => l_module || '.' || 'begin',
187: message => 'p_request_id => ' || p_request_id);
188: END IF;

Line 185: log_level => fnd_log.level_procedure,

181: -- Debug Info
182: --
183: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
184: fnd_log.string(
185: log_level => fnd_log.level_procedure,
186: module => l_module || '.' || 'begin',
187: message => 'p_request_id => ' || p_request_id);
188: END IF;
189: --

Line 239: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

235: COMMIT;
236: --
237: -- Debug Info
238: --
239: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
240: fnd_log.string(
241: log_level => fnd_log.level_procedure,
242: module => l_module || '.' || 'end',
243: message => 'x_ledgers_locked_cnt => ' || x_ledgers_locked_cnt);

Line 240: fnd_log.string(

236: --
237: -- Debug Info
238: --
239: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
240: fnd_log.string(
241: log_level => fnd_log.level_procedure,
242: module => l_module || '.' || 'end',
243: message => 'x_ledgers_locked_cnt => ' || x_ledgers_locked_cnt);
244: END IF;

Line 241: log_level => fnd_log.level_procedure,

237: -- Debug Info
238: --
239: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
240: fnd_log.string(
241: log_level => fnd_log.level_procedure,
242: module => l_module || '.' || 'end',
243: message => 'x_ledgers_locked_cnt => ' || x_ledgers_locked_cnt);
244: END IF;
245: EXCEPTION

Line 250: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

246: WHEN OTHERS THEN
247: --
248: -- Logging
249: --
250: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
251: fnd_log.string(
252: log_level => fnd_log.level_exception,
253: module => l_module,
254: message => 'p_request_id: ' || p_request_id || ', ' ||

Line 251: fnd_log.string(

247: --
248: -- Logging
249: --
250: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
251: fnd_log.string(
252: log_level => fnd_log.level_exception,
253: module => l_module,
254: message => 'p_request_id: ' || p_request_id || ', ' ||
255: 'SQLERRM: ' || SQLERRM);

Line 252: log_level => fnd_log.level_exception,

248: -- Logging
249: --
250: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
251: fnd_log.string(
252: log_level => fnd_log.level_exception,
253: module => l_module,
254: message => 'p_request_id: ' || p_request_id || ', ' ||
255: 'SQLERRM: ' || SQLERRM);
256: END IF;

Line 295: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

291: BEGIN
292: --
293: -- Debug Info - Begin
294: --
295: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
296: fnd_log.string(
297: log_level => fnd_log.level_procedure,
298: module => l_module || '.' || 'begin',
299: message => 'p_request_id => ' || p_request_id);

Line 296: fnd_log.string(

292: --
293: -- Debug Info - Begin
294: --
295: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
296: fnd_log.string(
297: log_level => fnd_log.level_procedure,
298: module => l_module || '.' || 'begin',
299: message => 'p_request_id => ' || p_request_id);
300: END IF;

Line 297: log_level => fnd_log.level_procedure,

293: -- Debug Info - Begin
294: --
295: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
296: fnd_log.string(
297: log_level => fnd_log.level_procedure,
298: module => l_module || '.' || 'begin',
299: message => 'p_request_id => ' || p_request_id);
300: END IF;
301: --

Line 317: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

313: COMMIT;
314:
315: -- Debug Info - End
316: --
317: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
318: fnd_log.string(
319: log_level => fnd_log.level_procedure,
320: module => l_module || '.'|| 'end',
321: message => 'x_status => ' || x_status);

Line 318: fnd_log.string(

314:
315: -- Debug Info - End
316: --
317: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
318: fnd_log.string(
319: log_level => fnd_log.level_procedure,
320: module => l_module || '.'|| 'end',
321: message => 'x_status => ' || x_status);
322: END IF;

Line 319: log_level => fnd_log.level_procedure,

315: -- Debug Info - End
316: --
317: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
318: fnd_log.string(
319: log_level => fnd_log.level_procedure,
320: module => l_module || '.'|| 'end',
321: message => 'x_status => ' || x_status);
322: END IF;
323: EXCEPTION

Line 328: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

324: WHEN OTHERS THEN
325: --
326: -- Logging
327: --
328: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
329: fnd_log.string(
330: log_level => fnd_log.level_exception,
331: module => l_module,
332: message => 'p_request_id: ' || p_request_id || ', ' ||

Line 329: fnd_log.string(

325: --
326: -- Logging
327: --
328: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
329: fnd_log.string(
330: log_level => fnd_log.level_exception,
331: module => l_module,
332: message => 'p_request_id: ' || p_request_id || ', ' ||
333: 'SQLERRM: ' || SQLERRM);

Line 330: log_level => fnd_log.level_exception,

326: -- Logging
327: --
328: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
329: fnd_log.string(
330: log_level => fnd_log.level_exception,
331: module => l_module,
332: message => 'p_request_id: ' || p_request_id || ', ' ||
333: 'SQLERRM: ' || SQLERRM);
334: END IF;

Line 385: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

381: BEGIN
382: --
383: -- Debug Information
384: --
385: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
386: FND_LOG.STRING(
387: FND_LOG.LEVEL_PROCEDURE,
388: 'fun.plsql.fun_seq_batch.generate_bulk_numbers.begin',
389: 'Beginning of generate_bulk_numbers');

Line 386: FND_LOG.STRING(

382: --
383: -- Debug Information
384: --
385: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
386: FND_LOG.STRING(
387: FND_LOG.LEVEL_PROCEDURE,
388: 'fun.plsql.fun_seq_batch.generate_bulk_numbers.begin',
389: 'Beginning of generate_bulk_numbers');
390: END IF;

Line 387: FND_LOG.LEVEL_PROCEDURE,

383: -- Debug Information
384: --
385: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
386: FND_LOG.STRING(
387: FND_LOG.LEVEL_PROCEDURE,
388: 'fun.plsql.fun_seq_batch.generate_bulk_numbers.begin',
389: 'Beginning of generate_bulk_numbers');
390: END IF;
391: --

Line 457: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

453: END IF;
454: --
455: -- Debug Information
456: --
457: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
458: FND_LOG.STRING(
459: FND_LOG.LEVEL_PROCEDURE,
460: 'fun.plsql.fun_seq_batch.generate_bulk_numbers.end',
461: 'Generate_bulk_numbers completes successfully.');

Line 458: FND_LOG.STRING(

454: --
455: -- Debug Information
456: --
457: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
458: FND_LOG.STRING(
459: FND_LOG.LEVEL_PROCEDURE,
460: 'fun.plsql.fun_seq_batch.generate_bulk_numbers.end',
461: 'Generate_bulk_numbers completes successfully.');
462: END IF;

Line 459: FND_LOG.LEVEL_PROCEDURE,

455: -- Debug Information
456: --
457: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
458: FND_LOG.STRING(
459: FND_LOG.LEVEL_PROCEDURE,
460: 'fun.plsql.fun_seq_batch.generate_bulk_numbers.end',
461: 'Generate_bulk_numbers completes successfully.');
462: END IF;
463: EXCEPTION

Line 468: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

464: WHEN OTHERS THEN
465: --
466: -- Logging
467: --
468: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
469: fnd_log.string(
470: log_level => fnd_log.level_exception,
471: module => l_module,
472: message => 'p_request_id: ' || p_request_id ||', ' ||

Line 469: fnd_log.string(

465: --
466: -- Logging
467: --
468: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
469: fnd_log.string(
470: log_level => fnd_log.level_exception,
471: module => l_module,
472: message => 'p_request_id: ' || p_request_id ||', ' ||
473: 'SQLERRM: ' || SQLERRM);

Line 470: log_level => fnd_log.level_exception,

466: -- Logging
467: --
468: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
469: fnd_log.string(
470: log_level => fnd_log.level_exception,
471: module => l_module,
472: message => 'p_request_id: ' || p_request_id ||', ' ||
473: 'SQLERRM: ' || SQLERRM);
474: END IF;

Line 496: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

492: BEGIN
493: --
494: -- Debug Information
495: --
496: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
497: FND_LOG.STRING(
498: FND_LOG.LEVEL_PROCEDURE,
499: 'fun.plsql.fun_seq_batch.populate_acct_seq_info.begin',
500: 'Calling fun_seq_batch.populate_acct_seq_info:'||

Line 497: FND_LOG.STRING(

493: --
494: -- Debug Information
495: --
496: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
497: FND_LOG.STRING(
498: FND_LOG.LEVEL_PROCEDURE,
499: 'fun.plsql.fun_seq_batch.populate_acct_seq_info.begin',
500: 'Calling fun_seq_batch.populate_acct_seq_info:'||
501: 'p_calling_program => ' || p_calling_program ||', ' ||

Line 498: FND_LOG.LEVEL_PROCEDURE,

494: -- Debug Information
495: --
496: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
497: FND_LOG.STRING(
498: FND_LOG.LEVEL_PROCEDURE,
499: 'fun.plsql.fun_seq_batch.populate_acct_seq_info.begin',
500: 'Calling fun_seq_batch.populate_acct_seq_info:'||
501: 'p_calling_program => ' || p_calling_program ||', ' ||
502: 'p_request_id => ' || p_request_id );

Line 518: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

514:
515: --
516: -- Debug Information
517: --
518: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
519: FND_LOG.STRING(
520: FND_LOG.LEVEL_PROCEDURE,
521: 'fun.plsql.fun_seq_batch.populate_acct_seq_info.end',
522: 'Calling fun_seq_batch.populate_acct_seq_info:'||

Line 519: FND_LOG.STRING(

515: --
516: -- Debug Information
517: --
518: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
519: FND_LOG.STRING(
520: FND_LOG.LEVEL_PROCEDURE,
521: 'fun.plsql.fun_seq_batch.populate_acct_seq_info.end',
522: 'Calling fun_seq_batch.populate_acct_seq_info:'||
523: 'p_calling_program => ' || p_calling_program ||', ' ||

Line 520: FND_LOG.LEVEL_PROCEDURE,

516: -- Debug Information
517: --
518: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
519: FND_LOG.STRING(
520: FND_LOG.LEVEL_PROCEDURE,
521: 'fun.plsql.fun_seq_batch.populate_acct_seq_info.end',
522: 'Calling fun_seq_batch.populate_acct_seq_info:'||
523: 'p_calling_program => ' || p_calling_program ||', ' ||
524: 'p_request_id => ' || p_request_id );

Line 531: IF fnd_log.level_error >= fnd_log.g_current_runtime_level THEN

527: WHEN no_assigned_seq_info THEN
528: --
529: -- Logging
530: --
531: IF fnd_log.level_error >= fnd_log.g_current_runtime_level THEN
532: fnd_log.string(
533: log_level => fnd_log.level_error,
534: module
535: => 'fun.plsql.fun_seq_batch.populate_acct_seq_info.error',

Line 532: fnd_log.string(

528: --
529: -- Logging
530: --
531: IF fnd_log.level_error >= fnd_log.g_current_runtime_level THEN
532: fnd_log.string(
533: log_level => fnd_log.level_error,
534: module
535: => 'fun.plsql.fun_seq_batch.populate_acct_seq_info.error',
536: message => 'p_request_id: ' || p_request_id ||', ' ||

Line 533: log_level => fnd_log.level_error,

529: -- Logging
530: --
531: IF fnd_log.level_error >= fnd_log.g_current_runtime_level THEN
532: fnd_log.string(
533: log_level => fnd_log.level_error,
534: module
535: => 'fun.plsql.fun_seq_batch.populate_acct_seq_info.error',
536: message => 'p_request_id: ' || p_request_id ||', ' ||
537: 'SQLERRM: ' || SQLERRM);

Line 550: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

546: WHEN OTHERS THEN
547: --
548: -- Logging
549: --
550: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
551: fnd_log.string(
552: log_level => fnd_log.level_exception,
553: module
554: => 'fun.plsql.fun_seq_batch.populate_acct_seq_info.exception',

Line 551: fnd_log.string(

547: --
548: -- Logging
549: --
550: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
551: fnd_log.string(
552: log_level => fnd_log.level_exception,
553: module
554: => 'fun.plsql.fun_seq_batch.populate_acct_seq_info.exception',
555: message => 'p_request_id: ' || p_request_id ||', ' ||

Line 552: log_level => fnd_log.level_exception,

548: -- Logging
549: --
550: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
551: fnd_log.string(
552: log_level => fnd_log.level_exception,
553: module
554: => 'fun.plsql.fun_seq_batch.populate_acct_seq_info.exception',
555: message => 'p_request_id: ' || p_request_id ||', ' ||
556: 'SQLERRM: ' || SQLERRM);

Line 596: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

592: BEGIN
593: --
594: -- Debug Information
595: --
596: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
597: FND_LOG.STRING(
598: FND_LOG.LEVEL_PROCEDURE,
599: 'fun.plsql.fun_seq_batch.populate_seq_info.begin',
600: 'Beginning of Populate_Seq_Info');

Line 597: FND_LOG.STRING(

593: --
594: -- Debug Information
595: --
596: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
597: FND_LOG.STRING(
598: FND_LOG.LEVEL_PROCEDURE,
599: 'fun.plsql.fun_seq_batch.populate_seq_info.begin',
600: 'Beginning of Populate_Seq_Info');
601: END IF;

Line 598: FND_LOG.LEVEL_PROCEDURE,

594: -- Debug Information
595: --
596: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
597: FND_LOG.STRING(
598: FND_LOG.LEVEL_PROCEDURE,
599: 'fun.plsql.fun_seq_batch.populate_seq_info.begin',
600: 'Beginning of Populate_Seq_Info');
601: END IF;
602: --

Line 644: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

640: l_ctrl_date_tbl(1).date_value := l_gl_date_tbl(i);
641: --
642: -- Debug Information
643: --
644: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
645: FND_LOG.STRING(
646: FND_LOG.LEVEL_PROCEDURE,
647: 'fun.plsql.fun_seq_batch.populate_seq_info.config',
648: 'Calling fun_seq.get_assigned_sequence_info... '

Line 645: FND_LOG.STRING(

641: --
642: -- Debug Information
643: --
644: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
645: FND_LOG.STRING(
646: FND_LOG.LEVEL_PROCEDURE,
647: 'fun.plsql.fun_seq_batch.populate_seq_info.config',
648: 'Calling fun_seq.get_assigned_sequence_info... '
649: ||', '||

Line 646: FND_LOG.LEVEL_PROCEDURE,

642: -- Debug Information
643: --
644: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
645: FND_LOG.STRING(
646: FND_LOG.LEVEL_PROCEDURE,
647: 'fun.plsql.fun_seq_batch.populate_seq_info.config',
648: 'Calling fun_seq.get_assigned_sequence_info... '
649: ||', '||
650: 'l_debug_je_header_id: '

Line 686: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

682:
683: --
684: -- Debug Information
685: --
686: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
687: FND_LOG.STRING(
688: FND_LOG.LEVEL_PROCEDURE,
689: 'fun.plsql.fun_seq_batch.populate_seq_info.config',
690: 'Returning from fun_seq.get_assigned_sequence_info... '

Line 687: FND_LOG.STRING(

683: --
684: -- Debug Information
685: --
686: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
687: FND_LOG.STRING(
688: FND_LOG.LEVEL_PROCEDURE,
689: 'fun.plsql.fun_seq_batch.populate_seq_info.config',
690: 'Returning from fun_seq.get_assigned_sequence_info... '
691: ||', '||

Line 688: FND_LOG.LEVEL_PROCEDURE,

684: -- Debug Information
685: --
686: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
687: FND_LOG.STRING(
688: FND_LOG.LEVEL_PROCEDURE,
689: 'fun.plsql.fun_seq_batch.populate_seq_info.config',
690: 'Returning from fun_seq.get_assigned_sequence_info... '
691: ||', '||
692: 'l_seq_ver_id_tbl(i): ' || l_seq_ver_id_tbl(i) ||', '||

Line 730: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

726: END IF;
727: --
728: -- Debug Information
729: --
730: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
731: FND_LOG.STRING(
732: FND_LOG.LEVEL_PROCEDURE,
733: 'fun.plsql.fun_seq_batch.populate_seq_info.end',
734: 'Populate_Seq_Info completes successfully.');

Line 731: FND_LOG.STRING(

727: --
728: -- Debug Information
729: --
730: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
731: FND_LOG.STRING(
732: FND_LOG.LEVEL_PROCEDURE,
733: 'fun.plsql.fun_seq_batch.populate_seq_info.end',
734: 'Populate_Seq_Info completes successfully.');
735: END IF;

Line 732: FND_LOG.LEVEL_PROCEDURE,

728: -- Debug Information
729: --
730: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
731: FND_LOG.STRING(
732: FND_LOG.LEVEL_PROCEDURE,
733: 'fun.plsql.fun_seq_batch.populate_seq_info.end',
734: 'Populate_Seq_Info completes successfully.');
735: END IF;
736: EXCEPTION

Line 741: IF fnd_log.level_error >= fnd_log.g_current_runtime_level THEN

737: WHEN no_assigned_seq_info THEN
738: --
739: -- Logging
740: --
741: IF fnd_log.level_error >= fnd_log.g_current_runtime_level THEN
742: -- Retrieve FUN_SEQ_NO_ACTIVE_ASSGN_FOUND from the message stack
743: -- and clear the message from the message stack.
744: -- See fun_seq.get_assigned_seq_info.
745: -- This is necessary to use the shorter version of the message

Line 748: -- The longer version is stored in the database via FND logging.

744: -- See fun_seq.get_assigned_seq_info.
745: -- This is necessary to use the shorter version of the message
746: -- for concurrent program logs of posting program. Message text
747: -- longer than 70 chars is not allowed in Pro*C code.
748: -- The longer version is stored in the database via FND logging.
749: fnd_log.string (
750: log_level => fnd_log.level_error,
751: module
752: => 'fun.plsql.fun_seq_batch.populate_seq_info.exception',

Line 749: fnd_log.string (

745: -- This is necessary to use the shorter version of the message
746: -- for concurrent program logs of posting program. Message text
747: -- longer than 70 chars is not allowed in Pro*C code.
748: -- The longer version is stored in the database via FND logging.
749: fnd_log.string (
750: log_level => fnd_log.level_error,
751: module
752: => 'fun.plsql.fun_seq_batch.populate_seq_info.exception',
753: message

Line 750: log_level => fnd_log.level_error,

746: -- for concurrent program logs of posting program. Message text
747: -- longer than 70 chars is not allowed in Pro*C code.
748: -- The longer version is stored in the database via FND logging.
749: fnd_log.string (
750: log_level => fnd_log.level_error,
751: module
752: => 'fun.plsql.fun_seq_batch.populate_seq_info.exception',
753: message
754: => 'EXCEPTION: no_assigned_seq_info' || ', ' ||

Line 769: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

765: WHEN OTHERS THEN
766: --
767: -- Logging
768: --
769: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
770: fnd_log.string(
771: log_level => fnd_log.level_exception,
772: module => 'fun.plsql.fun_seq_batch.populate_seq_info',
773: message => 'SQLERRM: ' || SQLERRM);

Line 770: fnd_log.string(

766: --
767: -- Logging
768: --
769: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
770: fnd_log.string(
771: log_level => fnd_log.level_exception,
772: module => 'fun.plsql.fun_seq_batch.populate_seq_info',
773: message => 'SQLERRM: ' || SQLERRM);
774: END IF;

Line 771: log_level => fnd_log.level_exception,

767: -- Logging
768: --
769: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
770: fnd_log.string(
771: log_level => fnd_log.level_exception,
772: module => 'fun.plsql.fun_seq_batch.populate_seq_info',
773: message => 'SQLERRM: ' || SQLERRM);
774: END IF;
775: --

Line 800: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

796: BEGIN
797: --
798: -- Debug Information
799: --
800: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
801: FND_LOG.STRING(
802: FND_LOG.LEVEL_PROCEDURE,
803: 'fun.plsql.fun_seq_batch.populate_numbers.begin',
804: 'Beginning of populate_numbers');

Line 801: FND_LOG.STRING(

797: --
798: -- Debug Information
799: --
800: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
801: FND_LOG.STRING(
802: FND_LOG.LEVEL_PROCEDURE,
803: 'fun.plsql.fun_seq_batch.populate_numbers.begin',
804: 'Beginning of populate_numbers');
805: END IF;

Line 802: FND_LOG.LEVEL_PROCEDURE,

798: -- Debug Information
799: --
800: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
801: FND_LOG.STRING(
802: FND_LOG.LEVEL_PROCEDURE,
803: 'fun.plsql.fun_seq_batch.populate_numbers.begin',
804: 'Beginning of populate_numbers');
805: END IF;
806: --

Line 864: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

860: END IF;
861: --
862: -- Debug Information
863: --
864: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
865: FND_LOG.STRING(
866: FND_LOG.LEVEL_PROCEDURE,
867: 'fun.plsql.fun_seq_batch.populate_numbers.end',
868: 'Populate_numbers completes successfully.');

Line 865: FND_LOG.STRING(

861: --
862: -- Debug Information
863: --
864: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
865: FND_LOG.STRING(
866: FND_LOG.LEVEL_PROCEDURE,
867: 'fun.plsql.fun_seq_batch.populate_numbers.end',
868: 'Populate_numbers completes successfully.');
869: END IF;

Line 866: FND_LOG.LEVEL_PROCEDURE,

862: -- Debug Information
863: --
864: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
865: FND_LOG.STRING(
866: FND_LOG.LEVEL_PROCEDURE,
867: 'fun.plsql.fun_seq_batch.populate_numbers.end',
868: 'Populate_numbers completes successfully.');
869: END IF;
870: --

Line 879: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

875: WHEN OTHERS THEN
876: --
877: -- Logging
878: --
879: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
880: fnd_log.string (
881: log_level => fnd_log.level_exception,
882: module => 'fun.plsql.fun_seq_batch.populate_numbers.exception',
883: message => 'SQLERRM: ' || SQLERRM);

Line 880: fnd_log.string (

876: --
877: -- Logging
878: --
879: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
880: fnd_log.string (
881: log_level => fnd_log.level_exception,
882: module => 'fun.plsql.fun_seq_batch.populate_numbers.exception',
883: message => 'SQLERRM: ' || SQLERRM);
884: END IF;

Line 881: log_level => fnd_log.level_exception,

877: -- Logging
878: --
879: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
880: fnd_log.string (
881: log_level => fnd_log.level_exception,
882: module => 'fun.plsql.fun_seq_batch.populate_numbers.exception',
883: message => 'SQLERRM: ' || SQLERRM);
884: END IF;
885: --

Line 929: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

925: WHEN OTHERS THEN
926: --
927: -- Logging
928: --
929: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
930: fnd_log.string(
931: log_level => fnd_log.level_exception,
932: module => l_module,
933: message => 'p_request_id: ' || p_request_id || ', ' ||

Line 930: fnd_log.string(

926: --
927: -- Logging
928: --
929: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
930: fnd_log.string(
931: log_level => fnd_log.level_exception,
932: module => l_module,
933: message => 'p_request_id: ' || p_request_id || ', ' ||
934: 'SQLERRM: ' || SQLERRM);

Line 931: log_level => fnd_log.level_exception,

927: -- Logging
928: --
929: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
930: fnd_log.string(
931: log_level => fnd_log.level_exception,
932: module => l_module,
933: message => 'p_request_id: ' || p_request_id || ', ' ||
934: 'SQLERRM: ' || SQLERRM);
935: END IF;

Line 971: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

967: WHEN OTHERS THEN
968: --
969: -- Logging
970: --
971: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
972: fnd_log.string(
973: log_level => fnd_log.level_exception,
974: module => l_module,
975: message => 'p_request_id: ' || p_request_id || ', ' ||

Line 972: fnd_log.string(

968: --
969: -- Logging
970: --
971: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
972: fnd_log.string(
973: log_level => fnd_log.level_exception,
974: module => l_module,
975: message => 'p_request_id: ' || p_request_id || ', ' ||
976: 'p_seq_context_id: ' || p_seq_context_id || ', ' ||

Line 973: log_level => fnd_log.level_exception,

969: -- Logging
970: --
971: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
972: fnd_log.string(
973: log_level => fnd_log.level_exception,
974: module => l_module,
975: message => 'p_request_id: ' || p_request_id || ', ' ||
976: 'p_seq_context_id: ' || p_seq_context_id || ', ' ||
977: 'SQLERRM: ' || SQLERRM);

Line 1021: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

1017: WHEN OTHERS THEN
1018: --
1019: -- Logging
1020: --
1021: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1022: fnd_log.string(
1023: log_level => fnd_log.level_exception,
1024: module => l_module,
1025: message => 'p_request_id: ' || p_request_id || ', ' ||

Line 1022: fnd_log.string(

1018: --
1019: -- Logging
1020: --
1021: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1022: fnd_log.string(
1023: log_level => fnd_log.level_exception,
1024: module => l_module,
1025: message => 'p_request_id: ' || p_request_id || ', ' ||
1026: 'p_seq_context_id: ' || p_seq_context_id || ', ' ||

Line 1023: log_level => fnd_log.level_exception,

1019: -- Logging
1020: --
1021: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1022: fnd_log.string(
1023: log_level => fnd_log.level_exception,
1024: module => l_module,
1025: message => 'p_request_id: ' || p_request_id || ', ' ||
1026: 'p_seq_context_id: ' || p_seq_context_id || ', ' ||
1027: 'SQLERRM: ' || SQLERRM);

Line 1082: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

1078: WHEN OTHERS THEN
1079: --
1080: -- Logging
1081: --
1082: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1083: fnd_log.string(
1084: log_level => fnd_log.level_exception,
1085: module => l_module,
1086: message => 'p_request_id: ' || p_request_id || ', ' ||

Line 1083: fnd_log.string(

1079: --
1080: -- Logging
1081: --
1082: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1083: fnd_log.string(
1084: log_level => fnd_log.level_exception,
1085: module => l_module,
1086: message => 'p_request_id: ' || p_request_id || ', ' ||
1087: 'p_seq_context_id: ' || p_seq_context_id || ', ' ||

Line 1084: log_level => fnd_log.level_exception,

1080: -- Logging
1081: --
1082: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1083: fnd_log.string(
1084: log_level => fnd_log.level_exception,
1085: module => l_module,
1086: message => 'p_request_id: ' || p_request_id || ', ' ||
1087: 'p_seq_context_id: ' || p_seq_context_id || ', ' ||
1088: 'SQLERRM: ' || SQLERRM);

Line 1192: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

1188: WHEN OTHERS THEN
1189: --
1190: -- Logging
1191: --
1192: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1193: fnd_log.string(
1194: log_level => fnd_log.level_exception,
1195: module => l_module,
1196: message => 'p_request_id: ' || p_request_id || ', ' ||

Line 1193: fnd_log.string(

1189: --
1190: -- Logging
1191: --
1192: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1193: fnd_log.string(
1194: log_level => fnd_log.level_exception,
1195: module => l_module,
1196: message => 'p_request_id: ' || p_request_id || ', ' ||
1197: 'SQLERRM: ' || SQLERRM);

Line 1194: log_level => fnd_log.level_exception,

1190: -- Logging
1191: --
1192: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1193: fnd_log.string(
1194: log_level => fnd_log.level_exception,
1195: module => l_module,
1196: message => 'p_request_id: ' || p_request_id || ', ' ||
1197: 'SQLERRM: ' || SQLERRM);
1198: END IF;

Line 1257: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1253: BEGIN
1254: --
1255: -- Debug Information
1256: --
1257: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1258: FND_LOG.STRING(
1259: FND_LOG.LEVEL_PROCEDURE,
1260: 'fun.plsql.fun_seq_batch.populate_acct_seq_prog_view.begin',
1261: 'p_request_id => ' || p_request_id );

Line 1258: FND_LOG.STRING(

1254: --
1255: -- Debug Information
1256: --
1257: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1258: FND_LOG.STRING(
1259: FND_LOG.LEVEL_PROCEDURE,
1260: 'fun.plsql.fun_seq_batch.populate_acct_seq_prog_view.begin',
1261: 'p_request_id => ' || p_request_id );
1262: END IF;

Line 1259: FND_LOG.LEVEL_PROCEDURE,

1255: -- Debug Information
1256: --
1257: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1258: FND_LOG.STRING(
1259: FND_LOG.LEVEL_PROCEDURE,
1260: 'fun.plsql.fun_seq_batch.populate_acct_seq_prog_view.begin',
1261: 'p_request_id => ' || p_request_id );
1262: END IF;
1263:

Line 1321: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1317:
1318: --
1319: -- Debug Information
1320: --
1321: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1322: FND_LOG.STRING(
1323: FND_LOG.LEVEL_PROCEDURE,
1324: 'fun.plsql.fun_seq_batch.populate_acct_seq_prog_view.config',
1325: 'Before calling fun_seq.get_assigned_sequence_info... '

Line 1322: FND_LOG.STRING(

1318: --
1319: -- Debug Information
1320: --
1321: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1322: FND_LOG.STRING(
1323: FND_LOG.LEVEL_PROCEDURE,
1324: 'fun.plsql.fun_seq_batch.populate_acct_seq_prog_view.config',
1325: 'Before calling fun_seq.get_assigned_sequence_info... '
1326: ||', '||

Line 1323: FND_LOG.LEVEL_PROCEDURE,

1319: -- Debug Information
1320: --
1321: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1322: FND_LOG.STRING(
1323: FND_LOG.LEVEL_PROCEDURE,
1324: 'fun.plsql.fun_seq_batch.populate_acct_seq_prog_view.config',
1325: 'Before calling fun_seq.get_assigned_sequence_info... '
1326: ||', '||
1327: 'l_debug_ae_header_id: '

Line 1368: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1364: x_error_code => l_error_code_tbl(i));
1365: --
1366: -- Debug Information
1367: --
1368: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1369: FND_LOG.STRING(
1370: FND_LOG.LEVEL_PROCEDURE,
1371: 'fun.plsql.fun_seq_batch.populate_acct_seq_prog_view.config',
1372: 'After calling fun_seq.get_assigned_sequence_info... '

Line 1369: FND_LOG.STRING(

1365: --
1366: -- Debug Information
1367: --
1368: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1369: FND_LOG.STRING(
1370: FND_LOG.LEVEL_PROCEDURE,
1371: 'fun.plsql.fun_seq_batch.populate_acct_seq_prog_view.config',
1372: 'After calling fun_seq.get_assigned_sequence_info... '
1373: ||', '||

Line 1370: FND_LOG.LEVEL_PROCEDURE,

1366: -- Debug Information
1367: --
1368: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1369: FND_LOG.STRING(
1370: FND_LOG.LEVEL_PROCEDURE,
1371: 'fun.plsql.fun_seq_batch.populate_acct_seq_prog_view.config',
1372: 'After calling fun_seq.get_assigned_sequence_info... '
1373: ||', '||
1374: 'l_seq_ver_id_tbl(i): ' || l_seq_ver_id_tbl(i) ||', '||

Line 1459: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1455:
1456: --
1457: -- Debug Information
1458: --
1459: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1460: FND_LOG.STRING(
1461: FND_LOG.LEVEL_PROCEDURE,
1462: 'fun.plsql.fun_seq_batchpopulate_acct_seq_prog_view.end',
1463: 'p_request_id: ' || p_request_id );

Line 1460: FND_LOG.STRING(

1456: --
1457: -- Debug Information
1458: --
1459: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1460: FND_LOG.STRING(
1461: FND_LOG.LEVEL_PROCEDURE,
1462: 'fun.plsql.fun_seq_batchpopulate_acct_seq_prog_view.end',
1463: 'p_request_id: ' || p_request_id );
1464: END IF;

Line 1461: FND_LOG.LEVEL_PROCEDURE,

1457: -- Debug Information
1458: --
1459: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1460: FND_LOG.STRING(
1461: FND_LOG.LEVEL_PROCEDURE,
1462: 'fun.plsql.fun_seq_batchpopulate_acct_seq_prog_view.end',
1463: 'p_request_id: ' || p_request_id );
1464: END IF;
1465:

Line 1471: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

1467: WHEN no_assigned_seq_info THEN
1468: --
1469: -- Logging
1470: --
1471: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1472: fnd_log.string(
1473: fnd_log.level_exception,
1474: 'fun.plsql.fun_seq_batch.populate_acct_seq_prog_view',
1475: 'p_request_id: ' || p_request_id ||', ' ||

Line 1472: fnd_log.string(

1468: --
1469: -- Logging
1470: --
1471: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1472: fnd_log.string(
1473: fnd_log.level_exception,
1474: 'fun.plsql.fun_seq_batch.populate_acct_seq_prog_view',
1475: 'p_request_id: ' || p_request_id ||', ' ||
1476: 'ae_header_id: ' || l_debug_ae_header_id|| ', ' ||

Line 1473: fnd_log.level_exception,

1469: -- Logging
1470: --
1471: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1472: fnd_log.string(
1473: fnd_log.level_exception,
1474: 'fun.plsql.fun_seq_batch.populate_acct_seq_prog_view',
1475: 'p_request_id: ' || p_request_id ||', ' ||
1476: 'ae_header_id: ' || l_debug_ae_header_id|| ', ' ||
1477: 'SQLERRM: ' || SQLERRM);

Line 1490: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

1486: WHEN OTHERS THEN
1487: --
1488: -- Logging
1489: --
1490: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1491: fnd_log.string(
1492: fnd_log.level_exception,
1493: 'fun.plsql.fun_seq_batch.populate_acct_seq_prog_view',
1494: 'Unexpected exception in Populate_Acct_Seq_Prog_View' || ', ' ||

Line 1491: fnd_log.string(

1487: --
1488: -- Logging
1489: --
1490: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1491: fnd_log.string(
1492: fnd_log.level_exception,
1493: 'fun.plsql.fun_seq_batch.populate_acct_seq_prog_view',
1494: 'Unexpected exception in Populate_Acct_Seq_Prog_View' || ', ' ||
1495: 'p_request_id: ' || p_request_id ||', ' ||

Line 1492: fnd_log.level_exception,

1488: -- Logging
1489: --
1490: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1491: fnd_log.string(
1492: fnd_log.level_exception,
1493: 'fun.plsql.fun_seq_batch.populate_acct_seq_prog_view',
1494: 'Unexpected exception in Populate_Acct_Seq_Prog_View' || ', ' ||
1495: 'p_request_id: ' || p_request_id ||', ' ||
1496: 'ae_header_id: ' || l_debug_ae_header_id|| ', ' ||

Line 1570: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1566: BEGIN
1567: --
1568: -- Debug Information
1569: --
1570: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1571: FND_LOG.STRING(
1572: FND_LOG.LEVEL_PROCEDURE,
1573: 'fun.plsql.fun_seq_batch.populate_rep_seq_prog_gt.begin',
1574: 'p_request_id => ' || p_request_id );

Line 1571: FND_LOG.STRING(

1567: --
1568: -- Debug Information
1569: --
1570: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1571: FND_LOG.STRING(
1572: FND_LOG.LEVEL_PROCEDURE,
1573: 'fun.plsql.fun_seq_batch.populate_rep_seq_prog_gt.begin',
1574: 'p_request_id => ' || p_request_id );
1575: END IF;

Line 1572: FND_LOG.LEVEL_PROCEDURE,

1568: -- Debug Information
1569: --
1570: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1571: FND_LOG.STRING(
1572: FND_LOG.LEVEL_PROCEDURE,
1573: 'fun.plsql.fun_seq_batch.populate_rep_seq_prog_gt.begin',
1574: 'p_request_id => ' || p_request_id );
1575: END IF;
1576:

Line 1642: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1638: l_ctrl_attr_rec.journal_category := l_je_category_name_tbl(i);
1639: --
1640: -- Debug Information
1641: --
1642: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1643: FND_LOG.STRING(
1644: FND_LOG.LEVEL_EVENT,
1645: 'fun.plsql.fun_seq_batch.populate_rep_seq_prog_gt.config',
1646: 'Before calling fun_seq.get_assigned_sequence_info... '

Line 1643: FND_LOG.STRING(

1639: --
1640: -- Debug Information
1641: --
1642: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1643: FND_LOG.STRING(
1644: FND_LOG.LEVEL_EVENT,
1645: 'fun.plsql.fun_seq_batch.populate_rep_seq_prog_gt.config',
1646: 'Before calling fun_seq.get_assigned_sequence_info... '
1647: ||', '||

Line 1644: FND_LOG.LEVEL_EVENT,

1640: -- Debug Information
1641: --
1642: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1643: FND_LOG.STRING(
1644: FND_LOG.LEVEL_EVENT,
1645: 'fun.plsql.fun_seq_batch.populate_rep_seq_prog_gt.config',
1646: 'Before calling fun_seq.get_assigned_sequence_info... '
1647: ||', '||
1648: 'l_debug_ae_header_id: '

Line 1686: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1682:
1683: --
1684: -- Debug Information
1685: --
1686: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1687: FND_LOG.STRING(
1688: FND_LOG.LEVEL_EVENT,
1689: 'fun.plsql.fun_seq_batch.populate_rep_seq_prog_gt.config',
1690: 'After calling fun_seq.get_assigned_sequence_info... '

Line 1687: FND_LOG.STRING(

1683: --
1684: -- Debug Information
1685: --
1686: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1687: FND_LOG.STRING(
1688: FND_LOG.LEVEL_EVENT,
1689: 'fun.plsql.fun_seq_batch.populate_rep_seq_prog_gt.config',
1690: 'After calling fun_seq.get_assigned_sequence_info... '
1691: ||', '||

Line 1688: FND_LOG.LEVEL_EVENT,

1684: -- Debug Information
1685: --
1686: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1687: FND_LOG.STRING(
1688: FND_LOG.LEVEL_EVENT,
1689: 'fun.plsql.fun_seq_batch.populate_rep_seq_prog_gt.config',
1690: 'After calling fun_seq.get_assigned_sequence_info... '
1691: ||', '||
1692: 'l_seq_ver_id_tbl(i): ' || l_seq_ver_id_tbl(i) ||', '||

Line 1738: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1734: IF l_xla_ae_header_id_tbl.COUNT > 0 THEN
1735: --
1736: -- Debug Information
1737: --
1738: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1739: FND_LOG.STRING(
1740: FND_LOG.LEVEL_STATEMENT,
1741: 'fun.plsql.fun_seq_batch.populate_rep_seq_prog_gt.config',
1742: 'Before calling Sort_Acct_Entires: Sort Option - ' ||

Line 1739: FND_LOG.STRING(

1735: --
1736: -- Debug Information
1737: --
1738: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1739: FND_LOG.STRING(
1740: FND_LOG.LEVEL_STATEMENT,
1741: 'fun.plsql.fun_seq_batch.populate_rep_seq_prog_gt.config',
1742: 'Before calling Sort_Acct_Entires: Sort Option - ' ||
1743: l_sort_option_code);

Line 1740: FND_LOG.LEVEL_STATEMENT,

1736: -- Debug Information
1737: --
1738: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1739: FND_LOG.STRING(
1740: FND_LOG.LEVEL_STATEMENT,
1741: 'fun.plsql.fun_seq_batch.populate_rep_seq_prog_gt.config',
1742: 'Before calling Sort_Acct_Entires: Sort Option - ' ||
1743: l_sort_option_code);
1744: END IF;

Line 1774: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1770:
1771: --
1772: -- Debug Information
1773: --
1774: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1775: FND_LOG.STRING(
1776: FND_LOG.LEVEL_STATEMENT,
1777: 'fun.plsql.fun_seq_batch.populate_rep_seq_prog_gt.config',
1778: 'After calling Sort_Acct_Entires');

Line 1775: FND_LOG.STRING(

1771: --
1772: -- Debug Information
1773: --
1774: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1775: FND_LOG.STRING(
1776: FND_LOG.LEVEL_STATEMENT,
1777: 'fun.plsql.fun_seq_batch.populate_rep_seq_prog_gt.config',
1778: 'After calling Sort_Acct_Entires');
1779: END IF;

Line 1776: FND_LOG.LEVEL_STATEMENT,

1772: -- Debug Information
1773: --
1774: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1775: FND_LOG.STRING(
1776: FND_LOG.LEVEL_STATEMENT,
1777: 'fun.plsql.fun_seq_batch.populate_rep_seq_prog_gt.config',
1778: 'After calling Sort_Acct_Entires');
1779: END IF;
1780:

Line 1809: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1805:
1806: --
1807: -- Debug Information
1808: --
1809: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1810: FND_LOG.STRING(
1811: FND_LOG.LEVEL_PROCEDURE,
1812: 'fun.plsql.fun_seq_batch.populate_rep_seq_prog_gt.end',
1813: 'p_request_id: ' || p_request_id );

Line 1810: FND_LOG.STRING(

1806: --
1807: -- Debug Information
1808: --
1809: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1810: FND_LOG.STRING(
1811: FND_LOG.LEVEL_PROCEDURE,
1812: 'fun.plsql.fun_seq_batch.populate_rep_seq_prog_gt.end',
1813: 'p_request_id: ' || p_request_id );
1814: END IF;

Line 1811: FND_LOG.LEVEL_PROCEDURE,

1807: -- Debug Information
1808: --
1809: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1810: FND_LOG.STRING(
1811: FND_LOG.LEVEL_PROCEDURE,
1812: 'fun.plsql.fun_seq_batch.populate_rep_seq_prog_gt.end',
1813: 'p_request_id: ' || p_request_id );
1814: END IF;
1815: EXCEPTION

Line 1820: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

1816: WHEN no_assigned_seq_info THEN
1817: --
1818: -- Logging
1819: --
1820: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1821: fnd_log.string(
1822: fnd_log.level_exception,
1823: 'fun.plsql.fun_seq_batch.populate_rep_seq_prog_gt',
1824: 'p_request_id: ' || p_request_id ||', ' ||

Line 1821: fnd_log.string(

1817: --
1818: -- Logging
1819: --
1820: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1821: fnd_log.string(
1822: fnd_log.level_exception,
1823: 'fun.plsql.fun_seq_batch.populate_rep_seq_prog_gt',
1824: 'p_request_id: ' || p_request_id ||', ' ||
1825: 'ae_header_id: ' || l_debug_ae_header_id|| ', ' ||

Line 1822: fnd_log.level_exception,

1818: -- Logging
1819: --
1820: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1821: fnd_log.string(
1822: fnd_log.level_exception,
1823: 'fun.plsql.fun_seq_batch.populate_rep_seq_prog_gt',
1824: 'p_request_id: ' || p_request_id ||', ' ||
1825: 'ae_header_id: ' || l_debug_ae_header_id|| ', ' ||
1826: 'SQLERRM: ' || SQLERRM);

Line 1850: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

1846: WHEN invalid_sort_option THEN
1847: --
1848: -- Logging
1849: --
1850: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1851: fnd_log.string(
1852: fnd_log.level_exception,
1853: 'fun.plsql.fun_seq_batch.populate_rep_seq_prog_gt',
1854: 'p_request_id: ' || p_request_id || ', ' ||

Line 1851: fnd_log.string(

1847: --
1848: -- Logging
1849: --
1850: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1851: fnd_log.string(
1852: fnd_log.level_exception,
1853: 'fun.plsql.fun_seq_batch.populate_rep_seq_prog_gt',
1854: 'p_request_id: ' || p_request_id || ', ' ||
1855: 'ae_header_id: ' || l_debug_ae_header_id|| ', ' ||

Line 1852: fnd_log.level_exception,

1848: -- Logging
1849: --
1850: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1851: fnd_log.string(
1852: fnd_log.level_exception,
1853: 'fun.plsql.fun_seq_batch.populate_rep_seq_prog_gt',
1854: 'p_request_id: ' || p_request_id || ', ' ||
1855: 'ae_header_id: ' || l_debug_ae_header_id|| ', ' ||
1856: 'sort_option_code: ' || l_sort_option_code || ', ' ||

Line 1868: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

1864: WHEN OTHERS THEN
1865: --
1866: -- Logging
1867: --
1868: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1869: fnd_log.string(
1870: fnd_log.level_exception,
1871: 'fun.plsql.fun_seq_batch.populate_rep_seq_prog_gt',
1872: 'Unexpected exception in populate_rep_seq_prog_gt' || ', ' ||

Line 1869: fnd_log.string(

1865: --
1866: -- Logging
1867: --
1868: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1869: fnd_log.string(
1870: fnd_log.level_exception,
1871: 'fun.plsql.fun_seq_batch.populate_rep_seq_prog_gt',
1872: 'Unexpected exception in populate_rep_seq_prog_gt' || ', ' ||
1873: 'p_request_id: ' || p_request_id ||', ' ||

Line 1870: fnd_log.level_exception,

1866: -- Logging
1867: --
1868: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1869: fnd_log.string(
1870: fnd_log.level_exception,
1871: 'fun.plsql.fun_seq_batch.populate_rep_seq_prog_gt',
1872: 'Unexpected exception in populate_rep_seq_prog_gt' || ', ' ||
1873: 'p_request_id: ' || p_request_id ||', ' ||
1874: 'ae_header_id: ' || l_debug_ae_header_id|| ', ' ||

Line 1901: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1897: l_temp_tab := fun_seq_bt_tbl_type();
1898: --
1899: -- Debug Information
1900: --
1901: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1902: FND_LOG.STRING(
1903: FND_LOG.LEVEL_PROCEDURE,
1904: 'fun.plsql.fun_seq_batch.Sort_Acct_Entries.begin',
1905: 'p_ae_header_id_tbl.count => ' || p_ae_header_id_tbl.COUNT);

Line 1902: FND_LOG.STRING(

1898: --
1899: -- Debug Information
1900: --
1901: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1902: FND_LOG.STRING(
1903: FND_LOG.LEVEL_PROCEDURE,
1904: 'fun.plsql.fun_seq_batch.Sort_Acct_Entries.begin',
1905: 'p_ae_header_id_tbl.count => ' || p_ae_header_id_tbl.COUNT);
1906: END IF;

Line 1903: FND_LOG.LEVEL_PROCEDURE,

1899: -- Debug Information
1900: --
1901: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1902: FND_LOG.STRING(
1903: FND_LOG.LEVEL_PROCEDURE,
1904: 'fun.plsql.fun_seq_batch.Sort_Acct_Entries.begin',
1905: 'p_ae_header_id_tbl.count => ' || p_ae_header_id_tbl.COUNT);
1906: END IF;
1907: --

Line 1946: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1942:
1943: --
1944: -- Debug Information
1945: --
1946: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1947: FND_LOG.STRING(
1948: FND_LOG.LEVEL_STATEMENT,
1949: 'fun.plsql.fun_seq_batch.Sort_Acct_Entries.config',
1950: 'Local temp table has been populated: ' || p_calling_program);

Line 1947: FND_LOG.STRING(

1943: --
1944: -- Debug Information
1945: --
1946: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1947: FND_LOG.STRING(
1948: FND_LOG.LEVEL_STATEMENT,
1949: 'fun.plsql.fun_seq_batch.Sort_Acct_Entries.config',
1950: 'Local temp table has been populated: ' || p_calling_program);
1951: END IF;

Line 1948: FND_LOG.LEVEL_STATEMENT,

1944: -- Debug Information
1945: --
1946: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1947: FND_LOG.STRING(
1948: FND_LOG.LEVEL_STATEMENT,
1949: 'fun.plsql.fun_seq_batch.Sort_Acct_Entries.config',
1950: 'Local temp table has been populated: ' || p_calling_program);
1951: END IF;
1952:

Line 1988: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1984:
1985: --
1986: -- Debug Information
1987: --
1988: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1989: FND_LOG.STRING(
1990: FND_LOG.LEVEL_STATEMENT,
1991: 'fun.plsql.fun_seq_batch.Sort_Acct_Entries.config',
1992: 'Local temp table has been populated: ' || p_calling_program);

Line 1989: FND_LOG.STRING(

1985: --
1986: -- Debug Information
1987: --
1988: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1989: FND_LOG.STRING(
1990: FND_LOG.LEVEL_STATEMENT,
1991: 'fun.plsql.fun_seq_batch.Sort_Acct_Entries.config',
1992: 'Local temp table has been populated: ' || p_calling_program);
1993: END IF;

Line 1990: FND_LOG.LEVEL_STATEMENT,

1986: -- Debug Information
1987: --
1988: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1989: FND_LOG.STRING(
1990: FND_LOG.LEVEL_STATEMENT,
1991: 'fun.plsql.fun_seq_batch.Sort_Acct_Entries.config',
1992: 'Local temp table has been populated: ' || p_calling_program);
1993: END IF;
1994:

Line 2052: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2048:
2049: --
2050: -- Debug Information
2051: --
2052: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2053: FND_LOG.STRING(
2054: FND_LOG.LEVEL_PROCEDURE,
2055: 'fun.plsql.fun_seq_batch.Sort_Acct_Entries.end',
2056: 'p_ae_header_id_tbl.count => ' || p_ae_header_id_tbl.COUNT);

Line 2053: FND_LOG.STRING(

2049: --
2050: -- Debug Information
2051: --
2052: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2053: FND_LOG.STRING(
2054: FND_LOG.LEVEL_PROCEDURE,
2055: 'fun.plsql.fun_seq_batch.Sort_Acct_Entries.end',
2056: 'p_ae_header_id_tbl.count => ' || p_ae_header_id_tbl.COUNT);
2057: END IF;

Line 2054: FND_LOG.LEVEL_PROCEDURE,

2050: -- Debug Information
2051: --
2052: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2053: FND_LOG.STRING(
2054: FND_LOG.LEVEL_PROCEDURE,
2055: 'fun.plsql.fun_seq_batch.Sort_Acct_Entries.end',
2056: 'p_ae_header_id_tbl.count => ' || p_ae_header_id_tbl.COUNT);
2057: END IF;
2058: EXCEPTION

Line 2063: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

2059: WHEN OTHERS THEN
2060: --
2061: -- Logging
2062: --
2063: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
2064: fnd_log.string(
2065: log_level => fnd_log.level_exception,
2066: module => 'fun.plsql.fun_seq_batch.Sort_Acct_Entries.Exception',
2067: message => 'SQLERRM: ' || SQLERRM);

Line 2064: fnd_log.string(

2060: --
2061: -- Logging
2062: --
2063: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
2064: fnd_log.string(
2065: log_level => fnd_log.level_exception,
2066: module => 'fun.plsql.fun_seq_batch.Sort_Acct_Entries.Exception',
2067: message => 'SQLERRM: ' || SQLERRM);
2068: END IF;

Line 2065: log_level => fnd_log.level_exception,

2061: -- Logging
2062: --
2063: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
2064: fnd_log.string(
2065: log_level => fnd_log.level_exception,
2066: module => 'fun.plsql.fun_seq_batch.Sort_Acct_Entries.Exception',
2067: message => 'SQLERRM: ' || SQLERRM);
2068: END IF;
2069: app_exception.raise_exception;