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 1191: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

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

Line 1192: fnd_log.string(

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

Line 1193: log_level => fnd_log.level_exception,

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

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

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

Line 1257: FND_LOG.STRING(

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

Line 1258: FND_LOG.LEVEL_PROCEDURE,

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

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

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

Line 1321: FND_LOG.STRING(

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

Line 1322: FND_LOG.LEVEL_PROCEDURE,

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

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

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

Line 1368: FND_LOG.STRING(

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

Line 1369: FND_LOG.LEVEL_PROCEDURE,

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

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

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

Line 1459: FND_LOG.STRING(

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

Line 1460: FND_LOG.LEVEL_PROCEDURE,

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

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

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

Line 1471: fnd_log.string(

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

Line 1472: fnd_log.level_exception,

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

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

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

Line 1490: fnd_log.string(

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

Line 1491: fnd_log.level_exception,

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

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

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

Line 1570: FND_LOG.STRING(

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

Line 1571: FND_LOG.LEVEL_PROCEDURE,

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

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

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

Line 1642: FND_LOG.STRING(

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

Line 1643: FND_LOG.LEVEL_EVENT,

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

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

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

Line 1686: FND_LOG.STRING(

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

Line 1687: FND_LOG.LEVEL_EVENT,

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

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

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

Line 1738: FND_LOG.STRING(

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

Line 1739: FND_LOG.LEVEL_STATEMENT,

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

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

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

Line 1774: FND_LOG.STRING(

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

Line 1775: FND_LOG.LEVEL_STATEMENT,

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

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

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

Line 1809: FND_LOG.STRING(

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

Line 1810: FND_LOG.LEVEL_PROCEDURE,

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

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

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

Line 1820: fnd_log.string(

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

Line 1821: fnd_log.level_exception,

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

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

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

Line 1850: fnd_log.string(

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

Line 1851: fnd_log.level_exception,

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

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

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

Line 1868: fnd_log.string(

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

Line 1869: fnd_log.level_exception,

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

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

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

Line 1901: FND_LOG.STRING(

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

Line 1902: FND_LOG.LEVEL_PROCEDURE,

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

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

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

Line 1946: FND_LOG.STRING(

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

Line 1947: FND_LOG.LEVEL_STATEMENT,

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

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

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

Line 1988: FND_LOG.STRING(

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

Line 1989: FND_LOG.LEVEL_STATEMENT,

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

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

2014:
2015: --
2016: -- Debug Information
2017: --
2018: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2019: FND_LOG.STRING(
2020: FND_LOG.LEVEL_PROCEDURE,
2021: 'fun.plsql.fun_seq_batch.Sort_Acct_Entries.end',
2022: 'p_ae_header_id_tbl.count => ' || p_ae_header_id_tbl.COUNT);

Line 2019: FND_LOG.STRING(

2015: --
2016: -- Debug Information
2017: --
2018: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2019: FND_LOG.STRING(
2020: FND_LOG.LEVEL_PROCEDURE,
2021: 'fun.plsql.fun_seq_batch.Sort_Acct_Entries.end',
2022: 'p_ae_header_id_tbl.count => ' || p_ae_header_id_tbl.COUNT);
2023: END IF;

Line 2020: FND_LOG.LEVEL_PROCEDURE,

2016: -- Debug Information
2017: --
2018: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2019: FND_LOG.STRING(
2020: FND_LOG.LEVEL_PROCEDURE,
2021: 'fun.plsql.fun_seq_batch.Sort_Acct_Entries.end',
2022: 'p_ae_header_id_tbl.count => ' || p_ae_header_id_tbl.COUNT);
2023: END IF;
2024: EXCEPTION

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

2025: WHEN OTHERS THEN
2026: --
2027: -- Logging
2028: --
2029: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
2030: fnd_log.string(
2031: log_level => fnd_log.level_exception,
2032: module => 'fun.plsql.fun_seq_batch.Sort_Acct_Entries.Exception',
2033: message => 'SQLERRM: ' || SQLERRM);

Line 2030: fnd_log.string(

2026: --
2027: -- Logging
2028: --
2029: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
2030: fnd_log.string(
2031: log_level => fnd_log.level_exception,
2032: module => 'fun.plsql.fun_seq_batch.Sort_Acct_Entries.Exception',
2033: message => 'SQLERRM: ' || SQLERRM);
2034: END IF;

Line 2031: log_level => fnd_log.level_exception,

2027: -- Logging
2028: --
2029: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
2030: fnd_log.string(
2031: log_level => fnd_log.level_exception,
2032: module => 'fun.plsql.fun_seq_batch.Sort_Acct_Entries.Exception',
2033: message => 'SQLERRM: ' || SQLERRM);
2034: END IF;
2035: app_exception.raise_exception;