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 FND_LOG

Line 12: pkpatel 6-Feb-2006 Bug 4937960 (MOdified the Person ID group logic to use get_dynamic_sql function to solve literal issue. Uncommented all the FND loggings)

8: Know limitations, enhancements or remarks
9: Change History
10: Who When What
11: svadde 28-Apr-2006 Bug 5126451 removed the dubuging of sql statement
12: pkpatel 6-Feb-2006 Bug 4937960 (MOdified the Person ID group logic to use get_dynamic_sql function to solve literal issue. Uncommented all the FND loggings)
13: pacross 11-APR-2005 Implemented code for Correspondance preview and edit fucntionality
14: mnade 6/1/2005 FA 157 Added p_award_prd_cd parameter to corp_post_process
15: ssaleem 09-SEP-2004 3630073. Added p_org_unit_id as a new parameter
16: ssawhney 3-may-04 IBC.C patchset changes bug 3565861 + 3442719 + signature of corp_get_letter_type changed + interaction history signature changes

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

193: l_view_name,
194: l_where_clause);
195:
196: --** proc level logging.
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';

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

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: --**
206:
207:

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

251: CLOSE c_att_id;
252: IGS_CO_GEN_004.get_list_query(l_attach_fid,l_query_text);
253:
254: --** proc level logging.
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';

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

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: --**
264:
265: IF l_query_text IS NULL THEN

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

417:
418: p_sql_stmt := fnd_dsql.get_text(FALSE);
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:

Line 426: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

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;
428: --**
429: EXCEPTION
430: WHEN OTHERS THEN

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

979: l_reply_days := null;
980: END IF;
981:
982: --** proc level logging.
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';

Line 1015: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));

1011: l_debug_str := l_debug_str || ',p_awd_cal_type=' || p_awd_cal_type ;
1012: l_debug_str := l_debug_str || ',p_awd_ci_seq_number=' || p_awd_ci_seq_number ;
1013: l_debug_str := l_debug_str || ',p_awd_prd_cd=' || p_awd_prd_cd ;
1014:
1015: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1016: END IF;
1017: --**
1018:
1019: l_doc_desc := NULL;

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

1032: l_citem_ver_id := p_preview_version_id;
1033: END IF;
1034:
1035: --** proc level logging.
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';

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

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: --**
1045:
1046: IF l_doc_desc IS NULL THEN

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

1073: -- To populate the bind parameters.
1074: --
1075:
1076: --** proc level logging.
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';

Line 1091: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));

1087: --'Content Type :'||l_content_type ||
1088: 'Version :' ||l_version_id ||
1089: 'Citem Ver Id :'||l_citem_ver_id ||
1090: 'Return Status :' || l_return_status || '-' || l_msg_data;
1091: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1092: END IF;
1093: --**
1094:
1095:

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

1160: END IF;
1161: END IF;
1162: END IF;
1163:
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';

Line 1176: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));

1172: ' p_org_party_name :'||l_org_unit_addr.PARTY_NAME||' p_org_postal_code :'||l_org_unit_addr.POSTAL_CODE||
1173: ' p_org_country :'||l_org_unit_addr.COUNTRY||' p_org_county :'||l_org_unit_addr.COUNTY||
1174: ' p_org_city :'||l_org_unit_addr.CITY||' p_org_province :'||l_org_unit_addr.PROVINCE||
1175: ' p_org_state :'||l_org_unit_addr.STATE||' p_org_email_address :'||l_org_unit_email.EMAIL_ADDRESS;
1176: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1177:
1178: END IF;
1179:
1180: l_varchar_tbl_bind_var(2) := 'p_org_phone';

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

1323: -- To Submit fulfilment request by invoking CRM API
1324: --
1325:
1326: --** proc level logging.
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';

Line 1342: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));

1338: l_debug_str := l_debug_str || 'p_request_id,=' || p_request_id;
1339: --l_debug_str := l_debug_str || 'l_content_xml,=' || l_content_xml;
1340: l_debug_str := l_debug_str || 'l_citem_ver_id,=' || l_citem_ver_id;
1341: l_debug_str := l_debug_str || 'p_fax_number,=' || p_fax_number;
1342: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1343: END IF;
1344: --**
1345:
1346: jtf_fm_request_grp.get_content_xml (

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

1365: );
1366:
1367: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_version_id ||' /'||l_content_xml);
1368: --** proc level logging.
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';

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

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));
1378: END IF;
1379: --**
1380:
1381:

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

1432: -- Store away all of the parameters required for a preview so they can be used later to fulfill the request.
1433: -- PACROSS - 11-SEP-2005
1434:
1435: --** proc level logging.
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';

Line 1477: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));

1473: --l_debug_str := l_debug_str || ',l_extended_header=' || l_extended_header;
1474: l_debug_str := l_debug_str || ',p_awd_prd_cd=' || p_awd_prd_cd;
1475:
1476:
1477: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1478: END IF;
1479: --**
1480:
1481: BEGIN

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

1503: EXCEPTION
1504: WHEN OTHERS THEN
1505:
1506: --** proc level logging.
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';

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

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: --**
1516: Fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');
1517: FND_MESSAGE.SET_TOKEN('NAME','IGS_CO_PROCESS.corp_submit_fulfil_request');

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

1519: App_Exception.Raise_Exception;
1520:
1521: END;
1522: --** proc level logging.
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';

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

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: --**
1532:
1533:

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

1531: --**
1532:
1533:
1534: --** proc level logging.
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';

Line 1547: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));

1543: l_debug_str := l_debug_str || ',p_request_id=' || p_request_id;
1544: l_debug_str := l_debug_str || ',p_person_id=' || p_person_id;
1545: l_debug_str := l_debug_str || ',l_extended_header=' || l_extended_header;
1546: l_debug_str := l_debug_str || ',p_content_id=' || p_content_id;
1547: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1548: END IF;
1549: --**
1550:
1551: jtf_fm_request_grp.send_request (

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

1565: p_preview => FND_API.G_TRUE
1566: );
1567:
1568: --** proc level logging.
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';

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

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: --**
1578:
1579: ELSE

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

1631:
1632: END IF;
1633:
1634: --** proc level logging.
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';

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

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;
1644: --**
1645:
1646: l_corp_submit_fulfil_request := FALSE;

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

1662: EXCEPTION
1663: WHEN OTHERS THEN
1664:
1665: --** proc level logging.
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';

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

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: --**
1675: Fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');
1676: FND_MESSAGE.SET_TOKEN('NAME','IGS_CO_PROCESS.corp_submit_fulfil_request');

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

1747: x_version_id => p_version_id
1748: );
1749:
1750: --** proc level logging.
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';

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

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;
1760: --**
1761:
1762: EXCEPTION

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

1891: l_parameter_10 igs_co_interac_hist.ci_sequence_number%TYPE;
1892:
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;

Line 1909: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

1905: l_debug_str := l_debug_str ||' p_parameter_7 :'||p_parameter_7;
1906: l_debug_str := l_debug_str ||' p_parameter_8 :'||p_parameter_8;
1907: l_debug_str := l_debug_str ||' p_parameter_9 :'||p_parameter_9;
1908:
1909: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
1910: END IF;
1911: --**
1912:
1913: fnd_dsql.add_text(' AND ');

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

2175: -- all persons in the group already resolved in the build_sql
2176: fnd_dsql.add_text(' 1=1');
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;

Line 2187: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,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;
2186:
2187: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
2188: END IF;
2189: --**
2190: fnd_dsql.add_text(' acad_cal_type = ');
2191: fnd_dsql.add_bind(l_acad_cal_type);

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

2387: l_all_null VARCHAR2(20);
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 ;

Line 2410: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

2406: l_debug_str := l_debug_str || ',p_parameter_8=' || p_parameter_8 ;
2407: l_debug_str := l_debug_str || ',p_parameter_9=' || p_parameter_9 ;
2408: l_debug_str := l_debug_str || ',p_override_flag=' || p_override_flag ;
2409: l_debug_str := l_debug_str || ',p_delivery_type=' || p_delivery_type ;
2410: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
2411: END IF;
2412: --**
2413:
2414: l_error_flag := 'FALSE';

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

2425: fnd_message.set_name('IGS','IGS_CO_LIST_PRAM');
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);

Line 2433: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

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;
2435: --**
2436: RETURN;
2437: END IF;

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

2446: fnd_message.set_name('IGS','IGS_CO_LIST_PRAM');
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);

Line 2454: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

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;
2456: --**
2457: RETURN;
2458: END IF;

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

2469: fnd_message.set_name('IGS','IGS_CO_LIST_PRAM');
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);

Line 2477: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

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;
2479: --**
2480: RETURN;
2481: END IF;

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

2492: fnd_message.set_name('IGS','IGS_CO_STUD_PRAM');
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);

Line 2500: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

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;
2502: --**
2503: RETURN;
2504: END IF; -- p_person_id

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

2513: fnd_message.set_name('IGS','IGS_CO_STUD_PRAM');
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);

Line 2521: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

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;
2523: --**
2524: RETURN;
2525: END IF; -- p_person_id

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

2536: fnd_message.set_name('IGS','IGS_CO_STUD_PRAM');
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);

Line 2544: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

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;
2546: --**
2547: RETURN;
2548: END IF; -- p_person_id IS NULL

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

2564: fnd_message.set_name('IGS','IGS_AD_INVALID_PARAM_COMB');
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);

Line 2572: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

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;
2574: --**
2575: RETURN;
2576: END IF;

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

2591: fnd_message.set_name('IGS','IGS_AD_INVALID_PARAM_COMB');
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;

Line 2598: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

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: --**
2601: RETURN;
2602: END IF;

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

2675: fnd_message.set_name('IGS','IGS_CO_PER_LIS_PRAM');
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);

Line 2683: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

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;
2685: --**
2686: RETURN;
2687: END IF;

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

2696: fnd_message.set_name('IGS','IGS_CO_PER_LIS_PRAM');
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);

Line 2704: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

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;
2706: --**
2707: RETURN;
2708: END IF;

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

2719: fnd_message.set_name('IGS','IGS_CO_PER_LIS_PRAM');
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);

Line 2727: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

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;
2729: --**
2730: RETURN;
2731: END IF;

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

2743: fnd_message.set_name('IGS','IGS_CO_PER_LIS_PRAM');
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);

Line 2751: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

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;
2753: --**
2754: RETURN;
2755:

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

2771: fnd_message.set_name('IGS','IGS_AD_INVALID_PARAM_COMB');
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;

Line 2778: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

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: --**
2781: RETURN;
2782: END IF;

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

2782: END IF;
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;

Line 2789: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

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: --**
2792: Fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');
2793: FND_MESSAGE.SET_TOKEN('NAME','IGS_CO_PROCESS.corp_validate_parameters');