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_PROCESS

Line 279: igs_co_process.corp_check_request_status (

275: l_exception := 'N';
276: -- Keep a record that preview batch request row has been stored.
277: -- PACROSS - 29-SEP-2005
278: l_preview_batch_stored := FALSE ;
279: igs_co_process.corp_check_request_status (
280: errbuf => l_errbuf,
281: retcode => l_retcode,
282: p_person_id => NULL,
283: p_document_id => NULL,

Line 435: igs_co_process.corp_get_letter_type (

431:
432: --**
433:
434: -- get the Doc Id , sys ltr code, letter type as out NOCOPY parameters from a call.
435: igs_co_process.corp_get_letter_type (
436: p_map_id => p_map_id,
437: p_document_id => l_document_id,
438: p_sys_ltr_code => l_sys_ltr_code,
439: p_letter_type => l_letter_type,

Line 533: igs_co_process.corp_validate_parameters (

529: END IF; --end if l_document_id;
530: -- validate all the parameters and their combinations
531: IF l_sys_ltr_code NOT IN ('FAAWARD', 'FAMISTM', 'FADISBT') THEN
532: l_exception := 'N';
533: igs_co_process.corp_validate_parameters (
534: p_sys_ltr_code => l_sys_ltr_code,
535: p_document_id => l_document_id,
536: p_select_type => p_select_type,
537: p_list_id => p_list_id,

Line 627: -- if letter code is NOT FAM related then, we need to call the 'build sql stmt' from igs_co_process_pkg

623:
624: --
625: IF p_override_flag = 'Y'
626: OR (l_sys_ltr_code IN ('FAAWARD', 'FAMISTM', 'FADISBT')) THEN
627: -- if letter code is NOT FAM related then, we need to call the 'build sql stmt' from igs_co_process_pkg
628: -- otherwise if it FAM related, we need to directly execute the SQL stmt received in pre_process proc.
629: IF (l_sys_ltr_code NOT IN ('FAAWARD', 'FAMISTM', 'FADISBT')) THEN
630: -- call needed only for NON FAM letters and Adhoc Letters
631: l_exception := 'N';

Line 632: igs_co_process.corp_build_sql_stmt (

628: -- otherwise if it FAM related, we need to directly execute the SQL stmt received in pre_process proc.
629: IF (l_sys_ltr_code NOT IN ('FAAWARD', 'FAMISTM', 'FADISBT')) THEN
630: -- call needed only for NON FAM letters and Adhoc Letters
631: l_exception := 'N';
632: igs_co_process.corp_build_sql_stmt (
633: p_document_id => l_document_id,
634: p_select_type => p_select_type,
635: p_sys_ltr_code => l_sys_ltr_code,
636: p_list_id => p_list_id,

Line 914: igs_co_process.corp_submit_fulfil_request (

910: AND (l_letter_type = 'SYSTEM') THEN
911: --** exec level logging.
912:
913: --**
914: igs_co_process.corp_submit_fulfil_request (
915: p_letter_type => l_letter_type,
916: p_person_id => l_person_id_dy,
917: p_sys_ltr_code => l_sys_ltr_code,
918: p_email_address => l_email_address_dy,

Line 941: IF NOT igs_co_process.l_corp_submit_fulfil_request THEN

937: p_awd_ci_seq_number => l_awd_ci_seq_number,
938: p_awd_prd_cd => p_parameter_2
939: );
940:
941: IF NOT igs_co_process.l_corp_submit_fulfil_request THEN
942: IF p_preview = 'Y' THEN
943: IF NOT l_preview_batch_stored THEN
944: -- Store away request values so they can be used later to fulfill the request after preview.
945: -- PACROSS - 11-SEP-2005

Line 1002: igs_co_process.corp_post_process (

998: END IF;
999: ELSE
1000: -- post-process the request as per pre-preview and edit
1001:
1002: igs_co_process.corp_post_process (
1003: p_person_id => l_person_id_dy,
1004: p_request_id => l_request_id,
1005: p_document_id => l_document_id,
1006: p_sys_ltr_code => l_sys_ltr_code,

Line 1024: igs_co_process.corp_submit_fulfil_request (

1020: ELSE
1021: --** exec level logging.
1022:
1023: --**
1024: igs_co_process.corp_submit_fulfil_request (
1025: p_letter_type => l_letter_type,
1026: p_person_id => l_person_id_dy,
1027: p_sys_ltr_code => l_sys_ltr_code,
1028: p_email_address => l_email_address_dy,

Line 1053: IF NOT igs_co_process.l_corp_submit_fulfil_request THEN

1049: p_awd_ci_seq_number => l_awd_ci_seq_number,
1050: p_awd_prd_cd => p_parameter_2
1051: );
1052:
1053: IF NOT igs_co_process.l_corp_submit_fulfil_request THEN
1054: IF p_preview = 'Y' THEN
1055: IF NOT l_preview_batch_stored THEN
1056: -- Store away request values so they can be used later to fulfill the request after preview.
1057: -- PACROSS - 11-SEP-2005

Line 1113: igs_co_process.corp_post_process (

1109: END;
1110: END IF;
1111: ELSE
1112: -- post-process the request as per pre-preview and edit
1113: igs_co_process.corp_post_process (
1114: p_person_id => l_person_id_dy,
1115: p_request_id => l_request_id,
1116: p_document_id => l_document_id,
1117: p_sys_ltr_code => l_sys_ltr_code,

Line 1207: igs_co_process.corp_check_document_attributes (

1203: END IF;
1204: ELSIF p_override_flag = 'N' THEN
1205: -- if FAM letter then Document attribute checking is not required.
1206: IF l_sys_ltr_code NOT IN ('FAAWARD', 'FAMISTM', 'FADISTM') THEN
1207: igs_co_process.corp_check_document_attributes (
1208: p_map_id => p_map_id,
1209: p_elapsed_days => l_elapsed_days,
1210: p_no_of_repeats => l_no_of_repeats
1211: );

Line 1216: igs_co_process.corp_build_sql_stmt (

1212: -- If NOT FAM letter and if the Elapsed days and No of repeats is not Null then only we need to call the build SQL stmt procedure
1213: -- If it is FAM letter, then the Pre Process procedure call itself gets the Dynamic SQL query and hence we need to bypass the call corp_build_sql_Stmt
1214: -- IF (l_elapsed_days IS NOT NULL OR l_no_of_repeats is NOT NULL) THEN
1215: l_exception := 'N';
1216: igs_co_process.corp_build_sql_stmt (
1217: p_document_id => l_document_id,
1218: p_select_type => p_select_type,
1219: p_sys_ltr_code => l_sys_ltr_code,
1220: p_list_id => p_list_id,

Line 1473: igs_co_process.corp_check_interaction_history (

1469: );
1470: fnd_file.put_line (fnd_file.LOG, fnd_message.get);
1471: ELSE
1472: IF l_sys_ltr_code NOT IN ('FAAWARD', 'FAMISTM', 'FADISTM') THEN
1473: igs_co_process.corp_check_interaction_history (
1474: p_person_id => l_person_id_dy,
1475: p_sys_ltr_code => l_sys_ltr_code,
1476: p_document_id => l_document_id,
1477: p_application_id => l_adm_appl_number_dy,

Line 1494: igs_co_process.corp_submit_fulfil_request (

1490: ('FAAWARD', 'FAMISTM', 'FADISTBT')
1491: AND (l_letter_type = 'SYSTEM') THEN
1492: --** exec level logging.
1493: --**
1494: igs_co_process.corp_submit_fulfil_request (
1495: p_letter_type => l_letter_type,
1496: p_person_id => l_person_id_dy,
1497: p_sys_ltr_code => l_sys_ltr_code,
1498: p_email_address => l_email_address_dy,

Line 1521: IF NOT igs_co_process.l_corp_submit_fulfil_request THEN

1517: p_awd_ci_seq_number => l_awd_ci_seq_number,
1518: p_awd_prd_cd => p_parameter_2
1519: );
1520:
1521: IF NOT igs_co_process.l_corp_submit_fulfil_request THEN
1522: IF p_preview = 'Y' THEN
1523: -- Store away request values so they can be used later to fulfill the request after preview.
1524: -- PACROSS - 11-SEP-2005
1525:

Line 1586: igs_co_process.corp_post_process (

1582: END IF;
1583: ELSE
1584: -- post-process the request as per pre-preview and edit
1585:
1586: igs_co_process.corp_post_process (
1587: p_person_id => l_person_id_dy,
1588: p_request_id => l_request_id,
1589: p_document_id => l_document_id,
1590: p_sys_ltr_code => l_sys_ltr_code,

Line 1605: igs_co_process.corp_submit_fulfil_request (

1601: );
1602: END IF;
1603: END IF;
1604: ELSE
1605: igs_co_process.corp_submit_fulfil_request (
1606: p_letter_type => l_letter_type,
1607: p_person_id => l_person_id_dy,
1608: p_sys_ltr_code => l_sys_ltr_code,
1609: p_email_address => l_email_address_dy,

Line 1634: IF NOT igs_co_process.l_corp_submit_fulfil_request THEN

1630: p_awd_ci_seq_number => l_awd_ci_seq_number,
1631: p_awd_prd_cd => p_parameter_2
1632: );
1633:
1634: IF NOT igs_co_process.l_corp_submit_fulfil_request THEN
1635: IF p_preview = 'Y' THEN
1636: -- Store away request values so they can be used later to fulfill the request after preview.
1637: -- PACROSS - 11-SEP-2005
1638: --** exec level logging.

Line 1702: igs_co_process.corp_post_process (

1698:
1699: ELSE
1700: -- post-process the request as per pre-preview and edit
1701:
1702: igs_co_process.corp_post_process (
1703: p_person_id => l_person_id_dy,
1704: p_request_id => l_request_id,
1705: p_document_id => l_document_id,
1706: p_sys_ltr_code => l_sys_ltr_code,

Line 1992: igs_co_process.corp_post_process (

1988: SET request_status_code = 'DISTRIBUTED'
1989: WHERE distribution_id = p_distribution_id;
1990:
1991: -- Call the post processing procedure (this will log the IGS Interaction History details)...
1992: igs_co_process.corp_post_process (
1993: p_person_id => l_person_id,
1994: p_request_id => l_ff_request_hist_id,
1995: p_document_id => l_current_content_id,
1996: p_sys_ltr_code => l_sys_ltr_code,

Line 2036: 'igs.plsql.igs_co_process.corp_submit_fulfil_request.aftersubmitrequest';

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';
2037: l_debug_str := 'Request ID :'
2038: || l_ff_request_hist_id
2039: || 'Return Status :'
2040: || l_return_status