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 IGS_CO_SUBMIT

Line 1: PACKAGE BODY igs_co_submit AS

1: PACKAGE BODY igs_co_submit AS
2: /* $Header: IGSCO21B.pls 120.7 2006/01/06 04:12:34 gmaheswa ship $ */
3: /*************************************************************
4: Created By : Paul Cross
5: Date Created on : 11-Sep-2005

Line 44: l_label := 'igs.plsql.igs_co_submit.build_preview_html';

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));
47: END IF;
48: --** */

Line 114: l_label := 'igs.plsql.igs_co_submit.build_preview_html.exit';

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));
117: END IF;
118: --** */

Line 271: l_prog_label := 'igs.plsql.igs_co_submit';

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';
275: l_exception := 'N';

Line 347: 'igs.plsql.igs_co_submit.submit_correspondence_request.deliverycheck';

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';
348: l_debug_str := 'Delivery Type :'
349: || l_delivery_type
350: || ' Printer :'
351: || l_printer_name

Line 417: 'igs.plsql.igs_co_submit.submit_correspondence_request.signonaudit';

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';
418: l_debug_str := 'CRM User :' || l_crm_user_id;
419: fnd_log.string_with_context (
420: fnd_log.level_procedure,
421: l_label,

Line 450: 'igs.plsql.igs_co_submit.submit_correspondence_request.paramdetails';

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';
451: l_debug_str := 'Map ID :'
452: || p_map_id
453: || 'Doc id :'
454: || l_document_id

Line 604: 'igs.plsql.igs_co_submit.submit_correspondence_request.FACaldetails';

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';
605: l_debug_str := 'FA Calendar :'
606: || l_awd_cal_type
607: || '-'
608: || l_awd_ci_seq_number;

Line 672: 'igs.plsql.igs_co_submit.submit_correspondence_request.buildsql';

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';
673: l_debug_str := 'Build Sql :' || l_sql_stmt;
674: fnd_log.string_with_context (
675: fnd_log.level_procedure,
676: l_label,

Line 982: 'igs.plsql.igs_co_submit.submit_correspondence_request.exception';

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

Line 1094: 'igs.plsql.igs_co_submit.submit_correspondence_request.exception';

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

Line 1147: 'igs.plsql.igs_co_submit.submit_correspondence_request.calling_build_preview_1';

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';
1148: l_debug_str := 'calling build_preview_html_1';
1149: fnd_log.string_with_context (
1150: fnd_log.level_procedure,
1151: l_label,

Line 1186: 'igs.plsql.igs_co_submit.submit_correspondence_request.sqlnodata.Y';

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';
1187: l_debug_str := 'Sql Statement :' || l_sql_stmt;
1188: fnd_log.string_with_context (
1189: fnd_log.level_exception,
1190: l_label,

Line 1565: 'igs.plsql.igs_co_submit.submit_correspondence_request.exception';

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

Line 1681: 'igs.plsql.igs_co_submit.submit_correspondence_request.exception';

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

Line 1740: 'igs.plsql.igs_co_submit.submit_correspondence_request.calling_build_preview_2';

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';
1741: l_debug_str := 'calling build_preview_html_2';
1742: fnd_log.string_with_context (
1743: fnd_log.level_procedure,
1744: l_label,

Line 1782: 'igs.plsql.igs_co_submit.submit_correspondence_request.sqlnodata.N';

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';
1783: l_debug_str := 'Sql Statement :' || l_sql_stmt;
1784: fnd_log.string_with_context (
1785: fnd_log.level_exception,
1786: l_label,

Line 1808: 'igs_co_submit.submit_correspondence_request' || '-' || SQLERRM

1804: retcode := 2;
1805: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXP');
1806: fnd_message.set_token (
1807: 'NAME',
1808: 'igs_co_submit.submit_correspondence_request' || '-' || SQLERRM
1809: );
1810: igs_ge_msg_stack.conc_exception_hndl;
1811: END submit_correspondence_request;
1812:

Line 1825: IGS_CO_SUBMIT.submit_correspondence_request concurrent

1821: Date Created on : 11-Sep-2005
1822: Purpose : This procedure is the main concurrent program procedure
1823: for distributing previewed correspondence requests. Its
1824: logic is based on the existing functionality inside the
1825: IGS_CO_SUBMIT.submit_correspondence_request concurrent
1826: program procedure. More specifically the segments
1827: responsible performing the actual distribution and post
1828: processing to update the IGS Interaction History.
1829: Know limitations, enhancements or remarks

Line 1913: l_prog_label CONSTANT VARCHAR2 (500) := 'igs.plsql.igs_co_submit';

1909: l_msg_count NUMBER;
1910: l_msg_data VARCHAR2 (2000);
1911: l_tmp_var VARCHAR2 (4000);
1912: l_tmp_var1 VARCHAR2 (4000);
1913: l_prog_label CONSTANT VARCHAR2 (500) := 'igs.plsql.igs_co_submit';
1914: l_tmp_request_id NUMBER;
1915: l_label VARCHAR2 (4000);
1916: l_debug_str VARCHAR2 (4000);
1917: BEGIN

Line 2079: END igs_co_submit;

2075: l_prog_label || '.distribute_preview_request' || '-' || SQLERRM
2076: );
2077: igs_ge_msg_stack.conc_exception_hndl;
2078: END distribute_preview_request;
2079: END igs_co_submit;