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

Line 40: /* IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

36: BEGIN
37: -- look up the function id for the correspondence workbench
38:
39: --** proc level logging.
40: /* IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
41: IF (l_log_request_id IS NULL) THEN
42: l_log_request_id := fnd_global.conc_request_id;
43: END IF;
44: l_label := 'igs.plsql.igs_co_submit.build_preview_html';

Line 46: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,TO_CHAR(l_log_request_id));

42: l_log_request_id := fnd_global.conc_request_id;
43: END IF;
44: l_label := 'igs.plsql.igs_co_submit.build_preview_html';
45: l_debug_str := 'JUST entered inside build_preview_html';
46: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,TO_CHAR(l_log_request_id));
47: END IF;
48: --** */
49: l_count := 0;
50: OPEN c_preview_exists (p_requestid);

Line 110: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

106: fnd_file.put_line (fnd_file.output, ' ');
107: fnd_file.put_line (fnd_file.output, '');
108: END IF;
109: /* --** proc level logging.
110: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
111: IF (l_log_request_id IS NULL) THEN
112: l_log_request_id := fnd_global.conc_request_id;
113: END IF;
114: l_label := 'igs.plsql.igs_co_submit.build_preview_html.exit';

Line 116: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,TO_CHAR(l_log_request_id));

112: l_log_request_id := fnd_global.conc_request_id;
113: END IF;
114: l_label := 'igs.plsql.igs_co_submit.build_preview_html.exit';
115: l_debug_str := 'JUST exiting from build_preview_html';
116: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,TO_CHAR(l_log_request_id));
117: END IF;
118: --** */
119: END build_preview_html;
120:

Line 341: IF fnd_log.test (fnd_log.level_procedure, l_prog_label) THEN

337: END IF;
338: END IF;
339:
340: --** proc level logging.
341: IF fnd_log.test (fnd_log.level_procedure, l_prog_label) THEN
342: IF (l_log_request_id IS NULL) THEN
343: l_log_request_id := fnd_global.conc_request_id;
344: END IF;
345:

Line 354: fnd_log.string_with_context (

350: || ' Printer :'
351: || l_printer_name
352: || ' Fax :'
353: || l_fax_number;
354: fnd_log.string_with_context (
355: fnd_log.level_procedure,
356: l_label,
357: l_debug_str,
358: NULL,

Line 355: fnd_log.level_procedure,

351: || l_printer_name
352: || ' Fax :'
353: || l_fax_number;
354: fnd_log.string_with_context (
355: fnd_log.level_procedure,
356: l_label,
357: l_debug_str,
358: NULL,
359: NULL,

Line 411: IF fnd_log.test (fnd_log.level_procedure, l_prog_label) THEN

407: RETURN;
408: END IF;
409:
410: --** proc level logging.
411: IF fnd_log.test (fnd_log.level_procedure, l_prog_label) THEN
412: IF (l_log_request_id IS NULL) THEN
413: l_log_request_id := fnd_global.conc_request_id;
414: END IF;
415:

Line 419: fnd_log.string_with_context (

415:
416: l_label :=
417: 'igs.plsql.igs_co_submit.submit_correspondence_request.signonaudit';
418: l_debug_str := 'CRM User :' || l_crm_user_id;
419: fnd_log.string_with_context (
420: fnd_log.level_procedure,
421: l_label,
422: l_debug_str,
423: NULL,

Line 420: fnd_log.level_procedure,

416: l_label :=
417: 'igs.plsql.igs_co_submit.submit_correspondence_request.signonaudit';
418: l_debug_str := 'CRM User :' || l_crm_user_id;
419: fnd_log.string_with_context (
420: fnd_log.level_procedure,
421: l_label,
422: l_debug_str,
423: NULL,
424: NULL,

Line 444: IF fnd_log.test (fnd_log.level_procedure, l_prog_label) THEN

440: p_version_id => l_version_id --ssawhney
441: );
442:
443: --** proc level logging.
444: IF fnd_log.test (fnd_log.level_procedure, l_prog_label) THEN
445: IF (l_log_request_id IS NULL) THEN
446: l_log_request_id := fnd_global.conc_request_id;
447: END IF;
448:

Line 457: fnd_log.string_with_context (

453: || 'Doc id :'
454: || l_document_id
455: || ' Version :'
456: || l_version_id;
457: fnd_log.string_with_context (
458: fnd_log.level_procedure,
459: l_label,
460: l_debug_str,
461: NULL,

Line 458: fnd_log.level_procedure,

454: || l_document_id
455: || ' Version :'
456: || l_version_id;
457: fnd_log.string_with_context (
458: fnd_log.level_procedure,
459: l_label,
460: l_debug_str,
461: NULL,
462: NULL,

Line 598: IF fnd_log.test (fnd_log.level_procedure, l_prog_label) THEN

594: l_awd_ci_seq_number := TO_NUMBER (RTRIM (SUBSTR (p_parameter_1, 11)));
595: END IF;
596:
597: --** proc level logging.
598: IF fnd_log.test (fnd_log.level_procedure, l_prog_label) THEN
599: IF (l_log_request_id IS NULL) THEN
600: l_log_request_id := fnd_global.conc_request_id;
601: END IF;
602:

Line 609: fnd_log.string_with_context (

605: l_debug_str := 'FA Calendar :'
606: || l_awd_cal_type
607: || '-'
608: || l_awd_ci_seq_number;
609: fnd_log.string_with_context (
610: fnd_log.level_procedure,
611: l_label,
612: l_debug_str,
613: NULL,

Line 610: fnd_log.level_procedure,

606: || l_awd_cal_type
607: || '-'
608: || l_awd_ci_seq_number;
609: fnd_log.string_with_context (
610: fnd_log.level_procedure,
611: l_label,
612: l_debug_str,
613: NULL,
614: NULL,

Line 666: IF fnd_log.test (fnd_log.level_procedure, l_prog_label) THEN

662: /* This will print the Dynamic SQL statement prepared. Can be uncommented when testing.
663: Igs_Ad_Imp_001.logDetail('l_sql_stmt :'||l_sql_stmt);
664: */
665: --** proc level logging.
666: IF fnd_log.test (fnd_log.level_procedure, l_prog_label) THEN
667: IF (l_log_request_id IS NULL) THEN
668: l_log_request_id := fnd_global.conc_request_id;
669: END IF;
670:

Line 674: fnd_log.string_with_context (

670:
671: l_label :=
672: 'igs.plsql.igs_co_submit.submit_correspondence_request.buildsql';
673: l_debug_str := 'Build Sql :' || l_sql_stmt;
674: fnd_log.string_with_context (
675: fnd_log.level_procedure,
676: l_label,
677: l_debug_str,
678: NULL,

Line 675: fnd_log.level_procedure,

671: l_label :=
672: 'igs.plsql.igs_co_submit.submit_correspondence_request.buildsql';
673: l_debug_str := 'Build Sql :' || l_sql_stmt;
674: fnd_log.string_with_context (
675: fnd_log.level_procedure,
676: l_label,
677: l_debug_str,
678: NULL,
679: NULL,

Line 976: IF fnd_log.test (fnd_log.level_procedure, l_prog_label) THEN

972:
973: l_preview_batch_stored := TRUE ;
974: EXCEPTION --added by svadde on 10/31/2005
975: WHEN OTHERS THEN
976: IF fnd_log.test (fnd_log.level_procedure, l_prog_label) THEN
977: IF (l_log_request_id IS NULL) THEN
978: l_log_request_id := fnd_global.conc_request_id;
979: END IF;
980:

Line 984: fnd_log.string_with_context (

980:
981: l_label :=
982: 'igs.plsql.igs_co_submit.submit_correspondence_request.exception';
983: l_debug_str := 'Insert into igs_co_prv_bch_reqs failed with :' || SQLERRM;
984: fnd_log.string_with_context (
985: fnd_log.level_procedure,
986: l_label,
987: l_debug_str,
988: NULL,

Line 985: fnd_log.level_procedure,

981: l_label :=
982: 'igs.plsql.igs_co_submit.submit_correspondence_request.exception';
983: l_debug_str := 'Insert into igs_co_prv_bch_reqs failed with :' || SQLERRM;
984: fnd_log.string_with_context (
985: fnd_log.level_procedure,
986: l_label,
987: l_debug_str,
988: NULL,
989: NULL,

Line 1088: IF fnd_log.test (fnd_log.level_procedure, l_prog_label) THEN

1084:
1085: l_preview_batch_stored := TRUE ;
1086: EXCEPTION --added by svadde on 10/31/2005
1087: WHEN OTHERS THEN
1088: IF fnd_log.test (fnd_log.level_procedure, l_prog_label) THEN
1089: IF (l_log_request_id IS NULL) THEN
1090: l_log_request_id := fnd_global.conc_request_id;
1091: END IF;
1092:

Line 1096: fnd_log.string_with_context (

1092:
1093: l_label :=
1094: 'igs.plsql.igs_co_submit.submit_correspondence_request.exception';
1095: l_debug_str := 'Insert into igs_co_prv_bch_reqs failed with :' || SQLERRM;
1096: fnd_log.string_with_context (
1097: fnd_log.level_procedure,
1098: l_label,
1099: l_debug_str,
1100: NULL,

Line 1097: fnd_log.level_procedure,

1093: l_label :=
1094: 'igs.plsql.igs_co_submit.submit_correspondence_request.exception';
1095: l_debug_str := 'Insert into igs_co_prv_bch_reqs failed with :' || SQLERRM;
1096: fnd_log.string_with_context (
1097: fnd_log.level_procedure,
1098: l_label,
1099: l_debug_str,
1100: NULL,
1101: NULL,

Line 1141: IF fnd_log.test (fnd_log.level_procedure, l_prog_label) THEN

1137: IF p_preview = 'Y' THEN
1138: -- If in preview mode then build the HTML in the concurrent request to take the user to the workbench.
1139: -- PACROSS - 11-SEP-2005
1140: --** proc level logging.
1141: IF fnd_log.test (fnd_log.level_procedure, l_prog_label) THEN
1142: IF (l_log_request_id IS NULL) THEN
1143: l_log_request_id := fnd_global.conc_request_id;
1144: END IF;
1145:

Line 1149: fnd_log.string_with_context (

1145:
1146: l_label :=
1147: 'igs.plsql.igs_co_submit.submit_correspondence_request.calling_build_preview_1';
1148: l_debug_str := 'calling build_preview_html_1';
1149: fnd_log.string_with_context (
1150: fnd_log.level_procedure,
1151: l_label,
1152: l_debug_str,
1153: NULL,

Line 1150: fnd_log.level_procedure,

1146: l_label :=
1147: 'igs.plsql.igs_co_submit.submit_correspondence_request.calling_build_preview_1';
1148: l_debug_str := 'calling build_preview_html_1';
1149: fnd_log.string_with_context (
1150: fnd_log.level_procedure,
1151: l_label,
1152: l_debug_str,
1153: NULL,
1154: NULL,

Line 1180: IF fnd_log.test (fnd_log.level_exception, l_prog_label) THEN

1176:
1177: --fnd_file.put_line(FND_FILE.LOG,l_sql_stmt);
1178:
1179: --** exec level logging.
1180: IF fnd_log.test (fnd_log.level_exception, l_prog_label) THEN
1181: IF (l_log_request_id IS NULL) THEN
1182: l_log_request_id := fnd_global.conc_request_id;
1183: END IF;
1184:

Line 1188: fnd_log.string_with_context (

1184:
1185: l_label :=
1186: 'igs.plsql.igs_co_submit.submit_correspondence_request.sqlnodata.Y';
1187: l_debug_str := 'Sql Statement :' || l_sql_stmt;
1188: fnd_log.string_with_context (
1189: fnd_log.level_exception,
1190: l_label,
1191: l_debug_str,
1192: NULL,

Line 1189: fnd_log.level_exception,

1185: l_label :=
1186: 'igs.plsql.igs_co_submit.submit_correspondence_request.sqlnodata.Y';
1187: l_debug_str := 'Sql Statement :' || l_sql_stmt;
1188: fnd_log.string_with_context (
1189: fnd_log.level_exception,
1190: l_label,
1191: l_debug_str,
1192: NULL,
1193: NULL,

Line 1559: IF fnd_log.test (fnd_log.level_procedure, l_prog_label) THEN

1555:
1556: l_preview_batch_stored := TRUE ;
1557: EXCEPTION --added by svadde on 10/31/2005
1558: WHEN OTHERS THEN
1559: IF fnd_log.test (fnd_log.level_procedure, l_prog_label) THEN
1560: IF (l_log_request_id IS NULL) THEN
1561: l_log_request_id := fnd_global.conc_request_id;
1562: END IF;
1563:

Line 1567: fnd_log.string_with_context (

1563:
1564: l_label :=
1565: 'igs.plsql.igs_co_submit.submit_correspondence_request.exception';
1566: l_debug_str := 'Insert into igs_co_prv_bch_reqs failed with :' || SQLERRM;
1567: fnd_log.string_with_context (
1568: fnd_log.level_procedure,
1569: l_label,
1570: l_debug_str,
1571: NULL,

Line 1568: fnd_log.level_procedure,

1564: l_label :=
1565: 'igs.plsql.igs_co_submit.submit_correspondence_request.exception';
1566: l_debug_str := 'Insert into igs_co_prv_bch_reqs failed with :' || SQLERRM;
1567: fnd_log.string_with_context (
1568: fnd_log.level_procedure,
1569: l_label,
1570: l_debug_str,
1571: NULL,
1572: NULL,

Line 1675: IF fnd_log.test (fnd_log.level_procedure, l_prog_label) THEN

1671:
1672: l_preview_batch_stored := TRUE ;
1673: EXCEPTION --added by svadde on 10/31/2005
1674: WHEN OTHERS THEN
1675: IF fnd_log.test (fnd_log.level_procedure, l_prog_label) THEN
1676: IF (l_log_request_id IS NULL) THEN
1677: l_log_request_id := fnd_global.conc_request_id;
1678: END IF;
1679:

Line 1683: fnd_log.string_with_context (

1679:
1680: l_label :=
1681: 'igs.plsql.igs_co_submit.submit_correspondence_request.exception';
1682: l_debug_str := 'Insert into igs_co_prv_bch_reqs failed with :' || SQLERRM;
1683: fnd_log.string_with_context (
1684: fnd_log.level_procedure,
1685: l_label,
1686: l_debug_str,
1687: NULL,

Line 1684: fnd_log.level_procedure,

1680: l_label :=
1681: 'igs.plsql.igs_co_submit.submit_correspondence_request.exception';
1682: l_debug_str := 'Insert into igs_co_prv_bch_reqs failed with :' || SQLERRM;
1683: fnd_log.string_with_context (
1684: fnd_log.level_procedure,
1685: l_label,
1686: l_debug_str,
1687: NULL,
1688: NULL,

Line 1734: IF fnd_log.test (fnd_log.level_procedure, l_prog_label) THEN

1730: IF p_preview = 'Y' THEN
1731: -- If in preview mode then build the HTML in the concurrent request to take the user to the workbench.
1732: -- PACROSS - 11-SEP-2005
1733: --** proc level logging.
1734: IF fnd_log.test (fnd_log.level_procedure, l_prog_label) THEN
1735: IF (l_log_request_id IS NULL) THEN
1736: l_log_request_id := fnd_global.conc_request_id;
1737: END IF;
1738:

Line 1742: fnd_log.string_with_context (

1738:
1739: l_label :=
1740: 'igs.plsql.igs_co_submit.submit_correspondence_request.calling_build_preview_2';
1741: l_debug_str := 'calling build_preview_html_2';
1742: fnd_log.string_with_context (
1743: fnd_log.level_procedure,
1744: l_label,
1745: l_debug_str,
1746: NULL,

Line 1743: fnd_log.level_procedure,

1739: l_label :=
1740: 'igs.plsql.igs_co_submit.submit_correspondence_request.calling_build_preview_2';
1741: l_debug_str := 'calling build_preview_html_2';
1742: fnd_log.string_with_context (
1743: fnd_log.level_procedure,
1744: l_label,
1745: l_debug_str,
1746: NULL,
1747: NULL,

Line 1776: IF fnd_log.test (fnd_log.level_exception, l_prog_label) THEN

1772: fnd_file.put_line (fnd_file.LOG, ' ');
1773:
1774: --fnd_file.put_line(FND_FILE.LOG,l_sql_stmt);
1775: --** exec level logging.
1776: IF fnd_log.test (fnd_log.level_exception, l_prog_label) THEN
1777: IF (l_log_request_id IS NULL) THEN
1778: l_log_request_id := fnd_global.conc_request_id;
1779: END IF;
1780:

Line 1784: fnd_log.string_with_context (

1780:
1781: l_label :=
1782: 'igs.plsql.igs_co_submit.submit_correspondence_request.sqlnodata.N';
1783: l_debug_str := 'Sql Statement :' || l_sql_stmt;
1784: fnd_log.string_with_context (
1785: fnd_log.level_exception,
1786: l_label,
1787: l_debug_str,
1788: NULL,

Line 1785: fnd_log.level_exception,

1781: l_label :=
1782: 'igs.plsql.igs_co_submit.submit_correspondence_request.sqlnodata.N';
1783: l_debug_str := 'Sql Statement :' || l_sql_stmt;
1784: fnd_log.string_with_context (
1785: fnd_log.level_exception,
1786: l_label,
1787: l_debug_str,
1788: NULL,
1789: NULL,

Line 2030: IF fnd_log.test (fnd_log.level_procedure, l_prog_label) THEN

2026: END IF;
2027: END IF;
2028:
2029: --** proc level logging.
2030: IF fnd_log.test (fnd_log.level_procedure, l_prog_label) THEN
2031: IF (l_tmp_request_id IS NULL) THEN
2032: l_tmp_request_id := fnd_global.conc_request_id;
2033: END IF;
2034:

Line 2043: fnd_log.string_with_context (

2039: || 'Return Status :'
2040: || l_return_status
2041: || '-'
2042: || l_msg_data;
2043: fnd_log.string_with_context (
2044: fnd_log.level_procedure,
2045: l_label,
2046: l_debug_str,
2047: NULL,

Line 2044: fnd_log.level_procedure,

2040: || l_return_status
2041: || '-'
2042: || l_msg_data;
2043: fnd_log.string_with_context (
2044: fnd_log.level_procedure,
2045: l_label,
2046: l_debug_str,
2047: NULL,
2048: NULL,