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_PREV_REQS

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 1441: l_debug_str := 'just going to insert into IGS_CO_PREV_REQS';

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;
1445: l_debug_str := l_debug_str || ',p_email_address=' || p_email_address;

Line 1483: INSERT INTO IGS_CO_PREV_REQS

1479: --**
1480:
1481: BEGIN
1482:
1483: INSERT INTO IGS_CO_PREV_REQS
1484: (CONCURRENT_REQUEST_ID, LETTER_TYPE_CODE, PERSON_ID,
1485: EMAIL_ADDRESS, ORIGINAL_CONTENT_ID, CURRENT_CONTENT_ID, AWARD_YEAR,
1486: SYS_LTR_CODE, ADM_APPL_NUMBER, NOMINATED_COURSE_CD, APPL_SEQUENCE_NUMBER,
1487: FULFILLMENT_REQ, CRM_USER_ID, MEDIA_TYPE_CODE, DESTINATION, FAX_NUMBER, REPLY_DAYS,

Line 1512: l_debug_str := 'inside exception section when inserting record in IGS_CO_PREV_REQS and exception is ' || sqlerrm;

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: --**
1516: Fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');

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 1528: l_debug_str := 'just after insert into IGS_CO_PREV_REQS';

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