[Home] [Help]
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';
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));
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';
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));
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';
988: l_debug_str := 'values';
989: l_debug_str := l_debug_str || 'p_letter_type=' || p_letter_type;
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';
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));
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';
1082: l_debug_str := 'Person ID :' ||p_person_id ||
1083: 'FA Calendar :'||l_awd_cal_type||'-'||l_awd_seq_number||
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';
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||
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';
1332: l_debug_str := 'values ;';
1333: l_debug_str := l_debug_str || 'p_content_id=' || p_content_id;
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';
1374: l_debug_str := 'Content Type :' ||l_content_type ||
1375: 'Return Status :'||l_return_status ||'-' ||l_msg_data;
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';
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;
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;
1445: l_debug_str := l_debug_str || ',p_email_address=' || p_email_address;
1446: l_debug_str := l_debug_str || ',p_content_id=' || p_content_id;
1490: CURRENT_CONTENT_XML, FF_REQUEST_HIST_ID, EXTENDED_HEADER, DISTRIBUTION_ID, REQUEST_STATUS_CODE,
1491: OBJECT_VERSION_NUMBER, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN,
1492: LAST_UPDATE_DATE, AWARD_PRD_CD)
1493: VALUES
1494: (fnd_global.conc_request_id, p_letter_type, p_person_id,
1495: p_email_address, p_content_id, p_content_id, p_award_year,
1496: p_sys_ltr_code, p_adm_appl_number, p_nominated_course_cd, p_appl_sequence_number,
1497: p_fulfillment_req, p_crm_user_id, p_media_type, p_destination, p_fax_number, l_reply_days,
1498: p_panel_code, p_reply_email, p_sender_email, p_cc_email, p_org_unit_id, p_awd_cal_type,
1497: p_fulfillment_req, p_crm_user_id, p_media_type, p_destination, p_fax_number, l_reply_days,
1498: p_panel_code, p_reply_email, p_sender_email, p_cc_email, p_org_unit_id, p_awd_cal_type,
1499: p_awd_ci_seq_number, l_citem_ver_id, l_citem_ver_id, l_doc_desc, l_content_xml,
1500: l_content_xml, p_request_id, l_extended_header, NULL, 'CREATED', 1,
1501: FND_GLOBAL.USER_ID, SYSDATE, FND_GLOBAL.USER_ID, NULL, SYSDATE, p_awd_prd_cd);
1502:
1503: EXCEPTION
1504: WHEN OTHERS THEN
1505:
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';
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));
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';
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));
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';
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;
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';
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));
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';
1640: l_debug_str := 'Request ID :' ||p_request_id ||
1641: 'Return Status :' ||l_return_status ||'-' ||l_msg_data;
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';
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));
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';
1756: l_debug_str := 'Doc id :' ||p_document_id || 'Version Id :' ||p_version_id ||
1757: 'Person Id :'||p_person_id;