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_PROCESS dependencies on IGS_CO_PROCESS

Line 1: PACKAGE BODY igs_co_process AS

1: PACKAGE BODY igs_co_process AS
2: /* $Header: IGSCO22B.pls 120.12 2006/05/31 10:25:46 vskumar ship $ */
3: /*************************************************************
4: Created By :Nalin Kumar
5: Date Created on : 05-Feb-2002

Line 39: l_prog_label CONSTANT VARCHAR2(500) :='igs.plsql.igs_co_process';

35: vskumar 30-May-2006 Xbuild3 performance fix. break cursor's select queries in procedure corp_check_interaction_history. e.g cur_c1 to cur_c1_part1 and cur_c1_part2.
36: ***************************************************************/
37: -- package variable declarations
38:
39: l_prog_label CONSTANT VARCHAR2(500) :='igs.plsql.igs_co_process';
40: l_request_id NUMBER;
41: l_label VARCHAR2(32000);
42: l_debug_str VARCHAR2(32000);
43:

Line 87: FND_MESSAGE.SET_TOKEN('NAME','IGS_CO_PROCESS.corp_get_letter_type');

83: CLOSE cur_c1;
84: EXCEPTION
85: WHEN OTHERS THEN
86: Fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');
87: FND_MESSAGE.SET_TOKEN('NAME','IGS_CO_PROCESS.corp_get_letter_type');
88: IGS_GE_MSG_STACK.ADD;
89: App_Exception.Raise_Exception;
90: END corp_get_letter_type;
91:

Line 201: l_label := 'igs.plsql.igs_co_process.corp_build_sql_stmt.whereclause';

197: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
198: IF (l_request_id IS NULL) THEN
199: l_request_id := fnd_global.conc_request_id;
200: END IF;
201: l_label := 'igs.plsql.igs_co_process.corp_build_sql_stmt.whereclause';
202: l_debug_str := 'View :'||l_view_name || 'Where Clause :'|| l_where_clause;
203: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
204: END IF;
205: --**

Line 259: l_label := 'igs.plsql.igs_co_process.corp_build_sql_stmt.listquery';

255: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
256: IF (l_request_id IS NULL) THEN
257: l_request_id := fnd_global.conc_request_id;
258: END IF;
259: l_label := 'igs.plsql.igs_co_process.corp_build_sql_stmt.listquery';
260: l_debug_str := 'List Query Text :'||l_query_text;
261: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
262: END IF;
263: --**

Line 423: l_label := 'igs.plsql.igs_co_process.corp_build_sql_stmt';

419:
420: --** proc level logging.
421: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
422:
423: l_label := 'igs.plsql.igs_co_process.corp_build_sql_stmt';
424: l_debug_str := 'p_sql_stmt: '||p_sql_stmt;
425:
426: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
427: END IF;

Line 432: FND_MESSAGE.SET_TOKEN('NAME','IGS_CO_PROCESS.corp_build_sql_stmt'||'-'||SQLERRM);

428: --**
429: EXCEPTION
430: WHEN OTHERS THEN
431: Fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');
432: FND_MESSAGE.SET_TOKEN('NAME','IGS_CO_PROCESS.corp_build_sql_stmt'||'-'||SQLERRM);
433: IGS_GE_MSG_STACK.ADD;
434: APP_EXCEPTION.RAISE_EXCEPTION;
435: END corp_build_sql_stmt;
436:

Line 471: FND_MESSAGE.SET_TOKEN('NAME','IGS_CO_PROCESS.corp_check_document_attributes');

467: CLOSE cur_c1;
468: EXCEPTION
469: WHEN OTHERS THEN
470: Fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');
471: FND_MESSAGE.SET_TOKEN('NAME','IGS_CO_PROCESS.corp_check_document_attributes');
472: IGS_GE_MSG_STACK.ADD;
473: App_Exception.Raise_Exception;
474: END corp_check_document_attributes;
475:

Line 720: FND_MESSAGE.SET_TOKEN('NAME','IGS_CO_PROCESS.corp_check_interaction_history');

716: END IF;
717: EXCEPTION
718: WHEN OTHERS THEN
719: Fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');
720: FND_MESSAGE.SET_TOKEN('NAME','IGS_CO_PROCESS.corp_check_interaction_history');
721: IGS_GE_MSG_STACK.ADD;
722: App_Exception.Raise_Exception;
723: END corp_check_interaction_history;
724:

Line 987: l_label := 'igs.plsql.igs_co_process.corp_submit_fulfil_request.JUST_ENTERED_INSIDE_corp_submit_fulfil_request';

983: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
984: IF (l_request_id IS NULL) THEN
985: l_request_id := fnd_global.conc_request_id;
986: END IF;
987: l_label := 'igs.plsql.igs_co_process.corp_submit_fulfil_request.JUST_ENTERED_INSIDE_corp_submit_fulfil_request';
988: l_debug_str := 'values';
989: l_debug_str := l_debug_str || 'p_letter_type=' || p_letter_type;
990: l_debug_str := l_debug_str || ',p_person_id=' || p_person_id ;
991: l_debug_str := l_debug_str || ',p_email_address=' || p_email_address ;

Line 1040: l_label := 'igs.plsql.igs_co_process.corp_submit_fulfil_request.gotthevalues';

1036: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
1037: IF (l_request_id IS NULL) THEN
1038: l_request_id := fnd_global.conc_request_id;
1039: END IF;
1040: l_label := 'igs.plsql.igs_co_process.corp_submit_fulfil_request.gotthevalues';
1041: l_debug_str := 'hurrreeeeeeee got the values';
1042: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1043: END IF;
1044: --**

Line 1081: l_label := 'igs.plsql.igs_co_process.corp_submit_fulfil_request.startrequest';

1077: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
1078: IF (l_request_id IS NULL) THEN
1079: l_request_id := fnd_global.conc_request_id;
1080: END IF;
1081: l_label := 'igs.plsql.igs_co_process.corp_submit_fulfil_request.startrequest';
1082: l_debug_str := 'Person ID :' ||p_person_id ||
1083: 'FA Calendar :'||l_awd_cal_type||'-'||l_awd_seq_number||
1084: 'Appl Details :' ||p_adm_appl_number||'-'||p_appl_sequence_number||
1085: '-' ||p_nominated_course_cd||'-'||l_reply_date ||

Line 1168: l_label := 'igs.plsql.igs_co_process.corp_submit_fulfil_request.beforecontentxml';

1164: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
1165: IF (l_request_id IS NULL) THEN
1166: l_request_id := fnd_global.conc_request_id;
1167: END IF;
1168: l_label := 'igs.plsql.igs_co_process.corp_submit_fulfil_request.beforecontentxml';
1169: l_debug_str := 'p_org_phone :' ||l_phone_val ||
1170: ' p_org_fax :'||l_fax_val ||' p_org_address1 :'||l_org_unit_addr.ADDRESS1||' p_org_address2 :'||l_org_unit_addr.ADDRESS2||
1171: ' p_org_address3 :'||l_org_unit_addr.ADDRESS3||' p_org_address4 :'||l_org_unit_addr.ADDRESS4||
1172: ' p_org_party_name :'||l_org_unit_addr.PARTY_NAME||' p_org_postal_code :'||l_org_unit_addr.POSTAL_CODE||

Line 1331: l_label := 'igs.plsql.igs_co_process.corp_submit_fulfil_request.CALLING_GET_CONTENT_XML WITH PARAMS';

1327: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
1328: IF (l_request_id IS NULL) THEN
1329: l_request_id := fnd_global.conc_request_id;
1330: END IF;
1331: l_label := 'igs.plsql.igs_co_process.corp_submit_fulfil_request.CALLING_GET_CONTENT_XML WITH PARAMS';
1332: l_debug_str := 'values ;';
1333: l_debug_str := l_debug_str || 'p_content_id=' || p_content_id;
1334: l_debug_str := l_debug_str || 'p_media_type,=' || p_media_type;
1335: l_debug_str := l_debug_str || 'p_email_address,=' || p_email_address;

Line 1373: l_label := 'igs.plsql.igs_co_process.corp_submit_fulfil_request.aftercontentxml';

1369: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
1370: IF (l_request_id IS NULL) THEN
1371: l_request_id := fnd_global.conc_request_id;
1372: END IF;
1373: l_label := 'igs.plsql.igs_co_process.corp_submit_fulfil_request.aftercontentxml';
1374: l_debug_str := 'Content Type :' ||l_content_type ||
1375: 'Return Status :'||l_return_status ||'-' ||l_msg_data;
1376: l_debug_str := l_debug_str || l_content_xml;
1377: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));

Line 1440: l_label := 'igs.plsql.igs_co_process.corp_submit_fulfil_request.before_inserting_into_IGS_CO_PREV_REQS';

1436: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
1437: IF (l_request_id IS NULL) THEN
1438: l_request_id := fnd_global.conc_request_id;
1439: END IF;
1440: l_label := 'igs.plsql.igs_co_process.corp_submit_fulfil_request.before_inserting_into_IGS_CO_PREV_REQS';
1441: l_debug_str := 'just going to insert into IGS_CO_PREV_REQS';
1442: l_debug_str := l_debug_str || 'conc_request_id='||fnd_global.conc_request_id;
1443: l_debug_str := l_debug_str || ',p_letter_type='||p_letter_type;
1444: l_debug_str := l_debug_str || ',p_person_id=' || p_person_id;

Line 1511: l_label := 'igs.plsql.igs_co_process.corp_submit_fulfil_request.excep_when_insert';

1507: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
1508: IF (l_request_id IS NULL) THEN
1509: l_request_id := fnd_global.conc_request_id;
1510: END IF;
1511: l_label := 'igs.plsql.igs_co_process.corp_submit_fulfil_request.excep_when_insert';
1512: l_debug_str := 'inside exception section when inserting record in IGS_CO_PREV_REQS and exception is ' || sqlerrm;
1513: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1514: END IF;
1515: --**

Line 1517: FND_MESSAGE.SET_TOKEN('NAME','IGS_CO_PROCESS.corp_submit_fulfil_request');

1513: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1514: END IF;
1515: --**
1516: Fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');
1517: FND_MESSAGE.SET_TOKEN('NAME','IGS_CO_PROCESS.corp_submit_fulfil_request');
1518: IGS_GE_MSG_STACK.ADD;
1519: App_Exception.Raise_Exception;
1520:
1521: END;

Line 1527: l_label := 'igs.plsql.igs_co_process.corp_submit_fulfil_request.after_inserting_into_IGS_CO_PREV_REQS';

1523: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
1524: IF (l_request_id IS NULL) THEN
1525: l_request_id := fnd_global.conc_request_id;
1526: END IF;
1527: l_label := 'igs.plsql.igs_co_process.corp_submit_fulfil_request.after_inserting_into_IGS_CO_PREV_REQS';
1528: l_debug_str := 'just after insert into IGS_CO_PREV_REQS';
1529: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1530: END IF;
1531: --**

Line 1539: l_label := 'igs.plsql.igs_co_process.corp_submit_fulfil_request.going_to_call_send_request';

1535: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
1536: IF (l_request_id IS NULL) THEN
1537: l_request_id := fnd_global.conc_request_id;
1538: END IF;
1539: l_label := 'igs.plsql.igs_co_process.corp_submit_fulfil_request.going_to_call_send_request';
1540: l_debug_str := 'calling send_request with parameters l_doc_desc='||l_doc_desc;
1541: l_debug_str := l_debug_str || ',p_crm_user_id=' || p_crm_user_id;
1542: l_debug_str := l_debug_str || ',l_content_xml=' || l_content_xml;
1543: l_debug_str := l_debug_str || ',p_request_id=' || p_request_id;

Line 1573: l_label := 'igs.plsql.igs_co_process.corp_submit_fulfil_request.after_call_to_send_request';

1569: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
1570: IF (l_request_id IS NULL) THEN
1571: l_request_id := fnd_global.conc_request_id;
1572: END IF;
1573: l_label := 'igs.plsql.igs_co_process.corp_submit_fulfil_request.after_call_to_send_request';
1574: l_debug_str := 'just after call to send_request with status ' || l_return_status || ' and l_msg_data ' || l_msg_data;
1575: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1576: END IF;
1577: --**

Line 1612: IF igs_co_process.l_message_logged THEN

1608: Fnd_Message.Set_name('IGS','IGS_CO_REQ_INFO');
1609: FND_MESSAGE.SET_TOKEN('REQUEST_ID',p_request_id);
1610: fnd_file.put_line(fnd_file.log,fnd_message.get);
1611:
1612: IF igs_co_process.l_message_logged THEN
1613: igs_co_process.l_message_logged := FALSE;
1614: END IF;
1615: CLOSE c_per_processed;
1616: ELSE

Line 1613: igs_co_process.l_message_logged := FALSE;

1609: FND_MESSAGE.SET_TOKEN('REQUEST_ID',p_request_id);
1610: fnd_file.put_line(fnd_file.log,fnd_message.get);
1611:
1612: IF igs_co_process.l_message_logged THEN
1613: igs_co_process.l_message_logged := FALSE;
1614: END IF;
1615: CLOSE c_per_processed;
1616: ELSE
1617: p_request_status := 'FAILURE';

Line 1639: l_label := 'igs.plsql.igs_co_process.corp_submit_fulfil_request.aftersubmitrequest';

1635: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
1636: IF (l_request_id IS NULL) THEN
1637: l_request_id := fnd_global.conc_request_id;
1638: END IF;
1639: l_label := 'igs.plsql.igs_co_process.corp_submit_fulfil_request.aftersubmitrequest';
1640: l_debug_str := 'Request ID :' ||p_request_id ||
1641: 'Return Status :' ||l_return_status ||'-' ||l_msg_data;
1642: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1643: END IF;

Line 1650: IF NOT igs_co_process.l_message_logged THEN

1646: l_corp_submit_fulfil_request := FALSE;
1647: COMMIT;
1648: ELSE
1649: l_corp_submit_fulfil_request := TRUE;
1650: IF NOT igs_co_process.l_message_logged THEN
1651: fnd_message.set_name('IGS','IGS_CO_HOLD_EXISTS');
1652: fnd_file.put_line(fnd_file.log,fnd_message.get);
1653: igs_co_process.l_message_logged := TRUE;
1654: END IF;

Line 1653: igs_co_process.l_message_logged := TRUE;

1649: l_corp_submit_fulfil_request := TRUE;
1650: IF NOT igs_co_process.l_message_logged THEN
1651: fnd_message.set_name('IGS','IGS_CO_HOLD_EXISTS');
1652: fnd_file.put_line(fnd_file.log,fnd_message.get);
1653: igs_co_process.l_message_logged := TRUE;
1654: END IF;
1655: OPEN log_details; LOOP
1656: FETCH log_details INTO l_full_name,l_person_number,l_encumbrance_desc;
1657: EXIT WHEN log_details%NOTFOUND;

Line 1670: l_label := 'igs.plsql.igs_co_process.corp_submit_fulfil_request.inside_excep_section';

1666: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
1667: IF (l_request_id IS NULL) THEN
1668: l_request_id := fnd_global.conc_request_id;
1669: END IF;
1670: l_label := 'igs.plsql.igs_co_process.corp_submit_fulfil_request.inside_excep_section';
1671: l_debug_str := 'inside exception section and exception is ' || sqlerrm;
1672: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1673: END IF;
1674: --**

Line 1676: FND_MESSAGE.SET_TOKEN('NAME','IGS_CO_PROCESS.corp_submit_fulfil_request');

1672: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1673: END IF;
1674: --**
1675: Fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');
1676: FND_MESSAGE.SET_TOKEN('NAME','IGS_CO_PROCESS.corp_submit_fulfil_request');
1677: IGS_GE_MSG_STACK.ADD;
1678: App_Exception.Raise_Exception;
1679: END corp_submit_fulfil_request;
1680:

Line 1755: l_label := 'igs.plsql.igs_co_process.corp_post_process.afterinteractioninsert';

1751: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
1752: IF (l_request_id IS NULL) THEN
1753: l_request_id := fnd_global.conc_request_id;
1754: END IF;
1755: l_label := 'igs.plsql.igs_co_process.corp_post_process.afterinteractioninsert';
1756: l_debug_str := 'Doc id :' ||p_document_id || 'Version Id :' ||p_version_id ||
1757: 'Person Id :'||p_person_id;
1758: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1759: END IF;

Line 1765: FND_MESSAGE.SET_TOKEN('NAME','IGS_CO_PROCESS.corp_post_process');

1761:
1762: EXCEPTION
1763: WHEN OTHERS THEN
1764: Fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');
1765: FND_MESSAGE.SET_TOKEN('NAME','IGS_CO_PROCESS.corp_post_process');
1766: IGS_GE_MSG_STACK.ADD;
1767: App_Exception.Raise_Exception;
1768: END corp_post_process;
1769:

Line 1845: FND_MESSAGE.SET_TOKEN('NAME','IGS_CO_PROCESS.corp_get_system_letter_view');

1841:
1842: EXCEPTION
1843: WHEN OTHERS THEN
1844: Fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');
1845: FND_MESSAGE.SET_TOKEN('NAME','IGS_CO_PROCESS.corp_get_system_letter_view');
1846: IGS_GE_MSG_STACK.ADD;
1847: App_Exception.Raise_Exception;
1848: END corp_get_system_letter_view;
1849:

Line 1897: l_label := 'igs.plsql.igs_co_process.corp_get_parameter_value';

1893: BEGIN
1894: --** proc level logging.
1895: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
1896:
1897: l_label := 'igs.plsql.igs_co_process.corp_get_parameter_value';
1898: l_debug_str := 'p_sys_ltr_code:'||p_sys_ltr_code;
1899: l_debug_str := l_debug_str ||' p_parameter_1 :'||p_parameter_1;
1900: l_debug_str := l_debug_str ||' p_parameter_2 :'||p_parameter_2;
1901: l_debug_str := l_debug_str ||' p_parameter_3 :'||p_parameter_3;

Line 2181: l_label := 'igs.plsql.igs_co_process.corp_get_parameter_value';

2177: ELSE
2178: --** proc level logging.
2179: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
2180:
2181: l_label := 'igs.plsql.igs_co_process.corp_get_parameter_value';
2182: l_debug_str := 'p_parameter_1 is NULL ';
2183: l_debug_str := l_debug_str ||' p_parameter_7 :'||p_parameter_7;
2184: l_debug_str := l_debug_str ||' p_parameter_8 :'||p_parameter_8;
2185: l_debug_str := l_debug_str ||' p_parameter_9 :'||p_parameter_9;

Line 2239: FND_MESSAGE.SET_TOKEN('NAME','IGS_CO_PROCESS.corp_get_parameter_value');

2235: END IF;
2236: EXCEPTION
2237: WHEN OTHERS THEN
2238: Fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');
2239: FND_MESSAGE.SET_TOKEN('NAME','IGS_CO_PROCESS.corp_get_parameter_value');
2240: IGS_GE_MSG_STACK.ADD;
2241: App_Exception.Raise_Exception;
2242: END corp_get_parameter_value;
2243:

Line 2350: FND_MESSAGE.SET_TOKEN('NAME','IGS_CO_PROCESS.corp_check_request_status');

2346: ERRBUF:= Fnd_Message.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION');
2347: Igs_Ge_Msg_Stack.CONC_EXCEPTION_HNDL;
2348: ELSE
2349: Fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');
2350: FND_MESSAGE.SET_TOKEN('NAME','IGS_CO_PROCESS.corp_check_request_status');
2351: IGS_GE_MSG_STACK.ADD;
2352: App_Exception.Raise_Exception;
2353: END IF;
2354: END corp_check_request_status;

Line 2392: l_label := 'igs.plsql.igs_co_process.corp_validate_parameters';

2388: BEGIN
2389:
2390: --** proc level logging.
2391: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
2392: l_label := 'igs.plsql.igs_co_process.corp_validate_parameters';
2393: l_debug_str := 'Entering corp_validate_parameters. values are:';
2394: l_debug_str := l_debug_str || 'p_sys_ltr_code=' || p_sys_ltr_code;
2395: l_debug_str := l_debug_str || ',p_document_id=' || p_document_id ;
2396: l_debug_str := l_debug_str || ',p_select_type=' || p_select_type ;

Line 2430: l_label := 'igs.plsql.igs_co_process.corp_validate_parameters';

2426: fnd_file.put_line(fnd_file.log,fnd_message.get());
2427: fnd_file.put_line(FND_FILE.LOG,' ');
2428: --** proc level logging.
2429: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
2430: l_label := 'igs.plsql.igs_co_process.corp_validate_parameters';
2431: l_debug_str := 'Exiting corp_validate_parameters. values are: ';
2432: l_debug_str := l_debug_str || 'p_select_type is L and p_sys_ltr_code is ADINTRW';
2433: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
2434: END IF;

Line 2451: l_label := 'igs.plsql.igs_co_process.corp_validate_parameters';

2447: fnd_file.put_line(fnd_file.log,fnd_message.get());
2448: fnd_file.put_line(FND_FILE.LOG,' ');
2449: --** proc level logging.
2450: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
2451: l_label := 'igs.plsql.igs_co_process.corp_validate_parameters';
2452: l_debug_str := 'Exiting corp_validate_parameters. values are: ';
2453: l_debug_str := l_debug_str || 'p_select_type is L and p_sys_ltr_code is ADNORSP';
2454: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
2455: END IF;

Line 2474: l_label := 'igs.plsql.igs_co_process.corp_validate_parameters';

2470: fnd_file.put_line(fnd_file.log,fnd_message.get());
2471: fnd_file.put_line(FND_FILE.LOG,' ');
2472: --** proc level logging.
2473: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
2474: l_label := 'igs.plsql.igs_co_process.corp_validate_parameters';
2475: l_debug_str := 'Exiting corp_validate_parameters as p_select_type is L, none of the nested if condition is satisfied and ';
2476: l_debug_str := l_debug_str || 'p_list_id is NULL or one of the parameters 1 to 7 is NOT NULL or person id is NOT null';
2477: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
2478: END IF;

Line 2497: l_label := 'igs.plsql.igs_co_process.corp_validate_parameters';

2493: fnd_file.put_line(fnd_file.log,fnd_message.get());
2494: fnd_file.put_line(FND_FILE.LOG,' ');
2495: --** proc level logging.
2496: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
2497: l_label := 'igs.plsql.igs_co_process.corp_validate_parameters';
2498: l_debug_str := 'Exiting corp_validate_parameters. values: ';
2499: l_debug_str := l_debug_str || 'p_select_type is S and p_sys_ltr_code is ADINTRW';
2500: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
2501: END IF;

Line 2518: l_label := 'igs.plsql.igs_co_process.corp_validate_parameters';

2514: fnd_file.put_line(fnd_file.log,fnd_message.get());
2515: fnd_file.put_line(FND_FILE.LOG,' ');
2516: --** proc level logging.
2517: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
2518: l_label := 'igs.plsql.igs_co_process.corp_validate_parameters';
2519: l_debug_str := 'Exiting corp_validate_parameters. values: ';
2520: l_debug_str := l_debug_str || 'p_select_type is S and p_sys_ltr_code is ADNORSP';
2521: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
2522: END IF;

Line 2541: l_label := 'igs.plsql.igs_co_process.corp_validate_parameters';

2537: fnd_file.put_line(fnd_file.log,fnd_message.get());
2538: fnd_file.put_line(FND_FILE.LOG,' ');
2539: --** proc level logging.
2540: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
2541: l_label := 'igs.plsql.igs_co_process.corp_validate_parameters';
2542: l_debug_str := 'Exiting corp_validate_parameters as p_select_type is S, none of the nested if condition is satisfied and ';
2543: l_debug_str := l_debug_str || 'p_list_id is NOT NULL or one of the parameters 1 to 7 is NOT NULL or person id is null';
2544: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
2545: END IF;

Line 2569: l_label := 'igs.plsql.igs_co_process.corp_validate_parameters';

2565: fnd_file.put_line(fnd_file.log,fnd_message.get());
2566: fnd_file.put_line(FND_FILE.LOG,' ');
2567: --** proc level logging.
2568: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
2569: l_label := 'igs.plsql.igs_co_process.corp_validate_parameters';
2570: l_debug_str := 'Exiting corp_validate_parameters. values: ';
2571: l_debug_str := l_debug_str || 'p_select_type is P';
2572: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
2573: END IF;

Line 2596: l_label := 'igs.plsql.igs_co_process.corp_validate_parameters';

2592: fnd_file.put_line(fnd_file.log,fnd_message.get());
2593: fnd_file.put_line(FND_FILE.LOG,' ');
2594: --** proc level logging.
2595: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
2596: l_label := 'igs.plsql.igs_co_process.corp_validate_parameters';
2597: l_debug_str := 'Exiting corp_validate_parameters for p_select_type P and all other values as none of the if conditions are satisfied.';
2598: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
2599: END IF;
2600: --**

Line 2680: l_label := 'igs.plsql.igs_co_process.corp_validate_parameters';

2676: fnd_file.put_line(fnd_file.log,fnd_message.get());
2677: fnd_file.put_line(FND_FILE.LOG,' ');
2678: --** proc level logging.
2679: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
2680: l_label := 'igs.plsql.igs_co_process.corp_validate_parameters';
2681: l_debug_str := 'Exiting corp_validate_parameters. values: ';
2682: l_debug_str := l_debug_str || 'p_select_type is G and p_sys_ltr_code is ADINTRW';
2683: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
2684: END IF;

Line 2701: l_label := 'igs.plsql.igs_co_process.corp_validate_parameters';

2697: fnd_file.put_line(fnd_file.log,fnd_message.get());
2698: fnd_file.put_line(FND_FILE.LOG,' ');
2699: --** proc level logging.
2700: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
2701: l_label := 'igs.plsql.igs_co_process.corp_validate_parameters';
2702: l_debug_str := 'Exiting corp_validate_parameters. values: ';
2703: l_debug_str := l_debug_str || 'p_select_type is G and p_sys_ltr_code is ADNORSP';
2704: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
2705: END IF;

Line 2724: l_label := 'igs.plsql.igs_co_process.corp_validate_parameters';

2720: fnd_file.put_line(fnd_file.log,fnd_message.get());
2721: fnd_file.put_line(FND_FILE.LOG,' ');
2722: --** proc level logging.
2723: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
2724: l_label := 'igs.plsql.igs_co_process.corp_validate_parameters';
2725: l_debug_str := 'Exiting corp_validate_parameters. values: ';
2726: l_debug_str := l_debug_str || 'p_select_type is G and all other letters';
2727: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
2728: END IF;

Line 2748: l_label := 'igs.plsql.igs_co_process.corp_validate_parameters';

2744: fnd_file.put_line(fnd_file.log,fnd_message.get());
2745: fnd_file.put_line(FND_FILE.LOG,' ');
2746: --** proc level logging.
2747: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
2748: l_label := 'igs.plsql.igs_co_process.corp_validate_parameters';
2749: l_debug_str := 'Exiting corp_validate_parameters as ';
2750: l_debug_str := l_debug_str || 'p_parameter_1 IS NOT NULL AND (p_person_id IS NOT NULL OR p_list_id IS NOT NULL';
2751: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
2752: END IF;

Line 2776: l_label := 'igs.plsql.igs_co_process.corp_validate_parameters';

2772: fnd_file.put_line(fnd_file.log,fnd_message.get());
2773: fnd_file.put_line(FND_FILE.LOG,' ');
2774: --** proc level logging.
2775: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
2776: l_label := 'igs.plsql.igs_co_process.corp_validate_parameters';
2777: l_debug_str := 'Exiting corp_validate_parameters as l_error_flag is TRUE';
2778: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
2779: END IF;
2780: --**

Line 2787: l_label := 'igs.plsql.igs_co_process.corp_validate_parameters';

2783: EXCEPTION
2784: WHEN OTHERS THEN
2785: --** proc level logging.
2786: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
2787: l_label := 'igs.plsql.igs_co_process.corp_validate_parameters';
2788: l_debug_str := 'Exception in corp_validate_parameters.';
2789: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
2790: END IF;
2791: --**

Line 2793: FND_MESSAGE.SET_TOKEN('NAME','IGS_CO_PROCESS.corp_validate_parameters');

2789: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
2790: END IF;
2791: --**
2792: Fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');
2793: FND_MESSAGE.SET_TOKEN('NAME','IGS_CO_PROCESS.corp_validate_parameters');
2794: IGS_GE_MSG_STACK.ADD;
2795: App_Exception.Raise_Exception;
2796: END corp_validate_parameters;
2797:

Line 2798: END igs_co_process;

2794: IGS_GE_MSG_STACK.ADD;
2795: App_Exception.Raise_Exception;
2796: END corp_validate_parameters;
2797:
2798: END igs_co_process;