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_GLOBAL

Line 42: l_log_request_id := fnd_global.conc_request_id;

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';
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));

Line 67: fnd_global.resp_appl_id,

63: -- Get the URL
64: l_url :=
65: fnd_run_function.get_run_function_url (
66: l_function_id,
67: fnd_global.resp_appl_id,
68: fnd_global.resp_id,
69: fnd_global.security_group_id,
70: 'pRequestId=' || TO_CHAR (p_requestid)
71: );

Line 68: fnd_global.resp_id,

64: l_url :=
65: fnd_run_function.get_run_function_url (
66: l_function_id,
67: fnd_global.resp_appl_id,
68: fnd_global.resp_id,
69: fnd_global.security_group_id,
70: 'pRequestId=' || TO_CHAR (p_requestid)
71: );
72: --

Line 69: fnd_global.security_group_id,

65: fnd_run_function.get_run_function_url (
66: l_function_id,
67: fnd_global.resp_appl_id,
68: fnd_global.resp_id,
69: fnd_global.security_group_id,
70: 'pRequestId=' || TO_CHAR (p_requestid)
71: );
72: --
73: -- Display the user function name when mousing over the generated link.

Line 112: l_log_request_id := fnd_global.conc_request_id;

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';
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));

Line 270: l_login_user_id := fnd_global.user_id;

266: igs_ge_gen_003.set_org_id;
267:
268: l_fulfillment_req := fnd_profile.VALUE ('IGS_CO_FUL_SERVER_ID');
269: l_crm_user_id := fnd_profile.VALUE ('IGS_CO_CRM_USER_ID');
270: l_login_user_id := fnd_global.user_id;
271: l_prog_label := 'igs.plsql.igs_co_submit';
272: --l_enable_log := igs_ad_imp_001.g_enable_log;
273:
274: l_address_found := 'N';

Line 343: l_log_request_id := fnd_global.conc_request_id;

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:
346: l_label :=
347: 'igs.plsql.igs_co_submit.submit_correspondence_request.deliverycheck';

Line 413: l_log_request_id := fnd_global.conc_request_id;

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:
416: l_label :=
417: 'igs.plsql.igs_co_submit.submit_correspondence_request.signonaudit';

Line 446: l_log_request_id := fnd_global.conc_request_id;

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:
449: l_label :=
450: 'igs.plsql.igs_co_submit.submit_correspondence_request.paramdetails';

Line 600: l_log_request_id := fnd_global.conc_request_id;

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:
603: l_label :=
604: 'igs.plsql.igs_co_submit.submit_correspondence_request.FACaldetails';

Line 668: l_log_request_id := fnd_global.conc_request_id;

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:
671: l_label :=
672: 'igs.plsql.igs_co_submit.submit_correspondence_request.buildsql';

Line 960: VALUES (fnd_global.conc_request_id,

956: object_version_number, created_by,
957: creation_date, last_updated_by,
958: last_update_login,
959: last_update_date)
960: VALUES (fnd_global.conc_request_id,
961: l_document_id,
962: l_letter_type,
963: l_version_id,
964: USERENV ('LANG'),

Line 968: 1, fnd_global.user_id,

964: USERENV ('LANG'),
965: l_delivery_type,
966: 'N',
967: 'N',
968: 1, fnd_global.user_id,
969: SYSDATE, fnd_global.user_id,
970: NULL,
971: SYSDATE);
972:

Line 969: SYSDATE, fnd_global.user_id,

965: l_delivery_type,
966: 'N',
967: 'N',
968: 1, fnd_global.user_id,
969: SYSDATE, fnd_global.user_id,
970: NULL,
971: SYSDATE);
972:
973: l_preview_batch_stored := TRUE ;

Line 978: l_log_request_id := fnd_global.conc_request_id;

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:
981: l_label :=
982: 'igs.plsql.igs_co_submit.submit_correspondence_request.exception';

Line 1072: VALUES (fnd_global.conc_request_id,

1068: object_version_number, created_by,
1069: creation_date, last_updated_by,
1070: last_update_login,
1071: last_update_date)
1072: VALUES (fnd_global.conc_request_id,
1073: l_document_id,
1074: l_letter_type,
1075: l_version_id,
1076: USERENV ('LANG'),

Line 1080: 1, fnd_global.user_id,

1076: USERENV ('LANG'),
1077: l_delivery_type,
1078: 'N',
1079: 'N',
1080: 1, fnd_global.user_id,
1081: SYSDATE, fnd_global.user_id,
1082: NULL,
1083: SYSDATE);
1084:

Line 1081: SYSDATE, fnd_global.user_id,

1077: l_delivery_type,
1078: 'N',
1079: 'N',
1080: 1, fnd_global.user_id,
1081: SYSDATE, fnd_global.user_id,
1082: NULL,
1083: SYSDATE);
1084:
1085: l_preview_batch_stored := TRUE ;

Line 1090: l_log_request_id := fnd_global.conc_request_id;

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:
1093: l_label :=
1094: 'igs.plsql.igs_co_submit.submit_correspondence_request.exception';

Line 1143: l_log_request_id := fnd_global.conc_request_id;

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:
1146: l_label :=
1147: 'igs.plsql.igs_co_submit.submit_correspondence_request.calling_build_preview_1';

Line 1163: build_preview_html (fnd_global.conc_request_id);

1159: );
1160: END IF;
1161:
1162: --**
1163: build_preview_html (fnd_global.conc_request_id);
1164: END IF;
1165: ELSE
1166: fnd_message.set_name ('IGS', 'IGS_CO_NO_REC');
1167: fnd_file.put_line (fnd_file.LOG, fnd_message.get ());

Line 1182: l_log_request_id := fnd_global.conc_request_id;

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:
1185: l_label :=
1186: 'igs.plsql.igs_co_submit.submit_correspondence_request.sqlnodata.Y';

Line 1542: VALUES (fnd_global.conc_request_id,

1538: created_by, creation_date,
1539: last_updated_by,
1540: last_update_login,
1541: last_update_date)
1542: VALUES (fnd_global.conc_request_id,
1543: l_document_id,
1544: l_letter_type,
1545: l_version_id,
1546: USERENV ('LANG'),

Line 1551: fnd_global.user_id, SYSDATE,

1547: l_delivery_type,
1548: 'N',
1549: 'N',
1550: 1,
1551: fnd_global.user_id, SYSDATE,
1552: fnd_global.user_id,
1553: NULL,
1554: SYSDATE);
1555:

Line 1552: fnd_global.user_id,

1548: 'N',
1549: 'N',
1550: 1,
1551: fnd_global.user_id, SYSDATE,
1552: fnd_global.user_id,
1553: NULL,
1554: SYSDATE);
1555:
1556: l_preview_batch_stored := TRUE ;

Line 1561: l_log_request_id := fnd_global.conc_request_id;

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:
1564: l_label :=
1565: 'igs.plsql.igs_co_submit.submit_correspondence_request.exception';

Line 1658: VALUES (fnd_global.conc_request_id,

1654: created_by, creation_date,
1655: last_updated_by,
1656: last_update_login,
1657: last_update_date)
1658: VALUES (fnd_global.conc_request_id,
1659: l_document_id,
1660: l_letter_type,
1661: l_version_id,
1662: USERENV ('LANG'),

Line 1667: fnd_global.user_id, SYSDATE,

1663: l_delivery_type,
1664: 'N',
1665: 'N',
1666: 1,
1667: fnd_global.user_id, SYSDATE,
1668: fnd_global.user_id,
1669: NULL,
1670: SYSDATE);
1671:

Line 1668: fnd_global.user_id,

1664: 'N',
1665: 'N',
1666: 1,
1667: fnd_global.user_id, SYSDATE,
1668: fnd_global.user_id,
1669: NULL,
1670: SYSDATE);
1671:
1672: l_preview_batch_stored := TRUE ;

Line 1677: l_log_request_id := fnd_global.conc_request_id;

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:
1680: l_label :=
1681: 'igs.plsql.igs_co_submit.submit_correspondence_request.exception';

Line 1736: l_log_request_id := fnd_global.conc_request_id;

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:
1739: l_label :=
1740: 'igs.plsql.igs_co_submit.submit_correspondence_request.calling_build_preview_2';

Line 1756: build_preview_html (fnd_global.conc_request_id);

1752: );
1753: END IF;
1754:
1755: --**
1756: build_preview_html (fnd_global.conc_request_id);
1757: END IF;
1758:
1759: --** exec level logging.
1760:

Line 1778: l_log_request_id := fnd_global.conc_request_id;

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:
1781: l_label :=
1782: 'igs.plsql.igs_co_submit.submit_correspondence_request.sqlnodata.N';

Line 2032: l_tmp_request_id := fnd_global.conc_request_id;

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:
2035: l_label :=
2036: 'igs.plsql.igs_co_process.corp_submit_fulfil_request.aftersubmitrequest';