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_AD_IMP_OFF_RESP_DATA dependencies on FND_MESSAGE

Line 66: l_meaning := FND_MESSAGE.GET_STRING('IGS',l_err_msg);

62: OPEN c_lkup_meaning(l_err_code);
63: FETCH c_lkup_meaning INTO l_meaning;
64: CLOSE c_lkup_meaning;
65: ELSE
66: l_meaning := FND_MESSAGE.GET_STRING('IGS',l_err_msg);
67: END IF;
68:
69: IF l_first_flag = 'Y' THEN
70: OPEN batch_details(l_id);

Line 77: FND_MESSAGE.SET_NAME('IGS','IGS_AD_BATCH_ID');

73:
74: l_full_string :=' ';
75: FND_FILE.PUT_LINE(FND_FILE.LOG, l_full_string);
76:
77: FND_MESSAGE.SET_NAME('IGS','IGS_AD_BATCH_ID');
78: l_full_string := RPAD(FND_MESSAGE.GET,10,' ')||RPAD(IGS_GE_NUMBER.TO_CANN(l_batch_rec.batch_id),15,' ')||l_batch_rec.batch_desc;
79: FND_FILE.PUT_LINE(FND_FILE.LOG, l_full_string);
80:
81: l_full_string :='----------------------------------------------------------------------------------------------------------------------------------';

Line 78: l_full_string := RPAD(FND_MESSAGE.GET,10,' ')||RPAD(IGS_GE_NUMBER.TO_CANN(l_batch_rec.batch_id),15,' ')||l_batch_rec.batch_desc;

74: l_full_string :=' ';
75: FND_FILE.PUT_LINE(FND_FILE.LOG, l_full_string);
76:
77: FND_MESSAGE.SET_NAME('IGS','IGS_AD_BATCH_ID');
78: l_full_string := RPAD(FND_MESSAGE.GET,10,' ')||RPAD(IGS_GE_NUMBER.TO_CANN(l_batch_rec.batch_id),15,' ')||l_batch_rec.batch_desc;
79: FND_FILE.PUT_LINE(FND_FILE.LOG, l_full_string);
80:
81: l_full_string :='----------------------------------------------------------------------------------------------------------------------------------';
82: FND_FILE.PUT_LINE(FND_FILE.LOG, l_full_string);

Line 84: FND_MESSAGE.SET_NAME('IGS','IGS_AD_IMP_OFR_LOG_HDR');

80:
81: l_full_string :='----------------------------------------------------------------------------------------------------------------------------------';
82: FND_FILE.PUT_LINE(FND_FILE.LOG, l_full_string);
83:
84: FND_MESSAGE.SET_NAME('IGS','IGS_AD_IMP_OFR_LOG_HDR');
85: l_full_string := FND_MESSAGE.GET;
86:
87: FND_FILE.PUT_LINE(FND_FILE.LOG, l_full_string);
88:

Line 85: l_full_string := FND_MESSAGE.GET;

81: l_full_string :='----------------------------------------------------------------------------------------------------------------------------------';
82: FND_FILE.PUT_LINE(FND_FILE.LOG, l_full_string);
83:
84: FND_MESSAGE.SET_NAME('IGS','IGS_AD_IMP_OFR_LOG_HDR');
85: l_full_string := FND_MESSAGE.GET;
86:
87: FND_FILE.PUT_LINE(FND_FILE.LOG, l_full_string);
88:
89: l_full_string :='----------------------------------------------------------------------------------------------------------------------------------';

Line 96: FND_MESSAGE.SET_NAME('IGS','IGS_AD_DEBUG_INFO');

92: ELSIF l_err_code IS NOT NULL OR l_err_msg IS NOT NULL THEN
93: l_text := RPAD(IGS_GE_NUMBER.TO_CANN(l_id),15,' ')||RPAD(NVL(l_err_code,' '),10,' ')||l_meaning;
94: FND_FILE.PUT_LINE(FND_FILE.LOG, l_text);
95:
96: FND_MESSAGE.SET_NAME('IGS','IGS_AD_DEBUG_INFO');
97: l_full_string := FND_MESSAGE.GET;
98: FND_FILE.PUT_LINE(FND_FILE.LOG, l_full_string||' '||l_debug_msg);
99: l_full_string :=' ';
100: FND_FILE.PUT_LINE(FND_FILE.LOG, l_full_string);

Line 97: l_full_string := FND_MESSAGE.GET;

93: l_text := RPAD(IGS_GE_NUMBER.TO_CANN(l_id),15,' ')||RPAD(NVL(l_err_code,' '),10,' ')||l_meaning;
94: FND_FILE.PUT_LINE(FND_FILE.LOG, l_text);
95:
96: FND_MESSAGE.SET_NAME('IGS','IGS_AD_DEBUG_INFO');
97: l_full_string := FND_MESSAGE.GET;
98: FND_FILE.PUT_LINE(FND_FILE.LOG, l_full_string||' '||l_debug_msg);
99: l_full_string :=' ';
100: FND_FILE.PUT_LINE(FND_FILE.LOG, l_full_string);
101:

Line 106: FND_MESSAGE.SET_NAME('IGS','IGS_AD_SUCC_IMP_OFR_RESP_REC');

102: END IF;
103:
104: IF l_id IS NOT NULL AND l_err_code IS NULL AND l_err_msg IS NULL AND l_first_flag IS NULL THEN
105:
106: FND_MESSAGE.SET_NAME('IGS','IGS_AD_SUCC_IMP_OFR_RESP_REC');
107: l_full_string := FND_MESSAGE.GET;
108:
109: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(IGS_GE_NUMBER.TO_CANN(l_id),15,' ')||' '||l_full_string);
110: END IF;

Line 107: l_full_string := FND_MESSAGE.GET;

103:
104: IF l_id IS NOT NULL AND l_err_code IS NULL AND l_err_msg IS NULL AND l_first_flag IS NULL THEN
105:
106: FND_MESSAGE.SET_NAME('IGS','IGS_AD_SUCC_IMP_OFR_RESP_REC');
107: l_full_string := FND_MESSAGE.GET;
108:
109: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(IGS_GE_NUMBER.TO_CANN(l_id),15,' ')||' '||l_full_string);
110: END IF;
111:

Line 120: FND_FILE.PUT_LINE(FND_FILE.LOG,'logdetail: '||FND_MESSAGE.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION')||' '||SQLERRM);

116: END IF;
117: IF batch_details%ISOPEN THEN
118: CLOSE batch_details;
119: END IF;
120: FND_FILE.PUT_LINE(FND_FILE.LOG,'logdetail: '||FND_MESSAGE.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION')||' '||SQLERRM);
121: END logdetail;
122:
123: --Procedure to Update igs_ad_offresp_int with the Error status and insert the corresponding Error record into igs_ad_offresp_err.
124: PROCEDURE insert_int_error( p_offresp_int_id IN igs_ad_offresp_int.offresp_int_id%TYPE,

Line 144: FND_MESSAGE.SET_NAME('IGS',p_message_name);

140: IF p_message_name IS NOT NULL THEN
141: IF length(p_message_name) > 30 THEN
142: l_message_text := p_message_name;
143: ELSE
144: FND_MESSAGE.SET_NAME('IGS',p_message_name);
145: l_message_text := fnd_message.get();
146: END IF;
147: END IF;
148:

Line 145: l_message_text := fnd_message.get();

141: IF length(p_message_name) > 30 THEN
142: l_message_text := p_message_name;
143: ELSE
144: FND_MESSAGE.SET_NAME('IGS',p_message_name);
145: l_message_text := fnd_message.get();
146: END IF;
147: END IF;
148:
149: INSERT INTO igs_ad_offresp_err(

Line 179: FND_FILE.PUT_LINE(FND_FILE.LOG,'insert_int_error: '||FND_MESSAGE.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION')||' '||SQLERRM);

175: SYSDATE,
176: fnd_global.conc_program_id);
177: EXCEPTION
178: WHEN OTHERS THEN
179: FND_FILE.PUT_LINE(FND_FILE.LOG,'insert_int_error: '||FND_MESSAGE.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION')||' '||SQLERRM);
180: END insert_int_error;
181:
182:
183: PROCEDURE validate_off_resp_dtls(

Line 781: FND_MESSAGE.SET_NAME('IGS','IGS_AD_SINGLE_OFFRESP_EXISTS');

777: NVL(v_acaiv_adm_ci_sequence_number,v_aa_adm_ci_sequence_number));
778: FETCH get_alternate_code INTO l_adm_alt_code;
779: CLOSE get_alternate_code;
780:
781: FND_MESSAGE.SET_NAME('IGS','IGS_AD_SINGLE_OFFRESP_EXISTS');
782: FND_MESSAGE.SET_TOKEN ('PROG_CODE',l_nominated_course_cd);
783: FND_MESSAGE.SET_TOKEN ('APPL_ID', TO_CHAR(l_application_id));
784: FND_MESSAGE.SET_TOKEN ('ACAD_ADM_PRD', l_acad_alt_code||'/'||l_adm_alt_code);
785:

Line 782: FND_MESSAGE.SET_TOKEN ('PROG_CODE',l_nominated_course_cd);

778: FETCH get_alternate_code INTO l_adm_alt_code;
779: CLOSE get_alternate_code;
780:
781: FND_MESSAGE.SET_NAME('IGS','IGS_AD_SINGLE_OFFRESP_EXISTS');
782: FND_MESSAGE.SET_TOKEN ('PROG_CODE',l_nominated_course_cd);
783: FND_MESSAGE.SET_TOKEN ('APPL_ID', TO_CHAR(l_application_id));
784: FND_MESSAGE.SET_TOKEN ('ACAD_ADM_PRD', l_acad_alt_code||'/'||l_adm_alt_code);
785:
786: insert_int_error(p_offresp_int_id, 'E693',fnd_message.get());

Line 783: FND_MESSAGE.SET_TOKEN ('APPL_ID', TO_CHAR(l_application_id));

779: CLOSE get_alternate_code;
780:
781: FND_MESSAGE.SET_NAME('IGS','IGS_AD_SINGLE_OFFRESP_EXISTS');
782: FND_MESSAGE.SET_TOKEN ('PROG_CODE',l_nominated_course_cd);
783: FND_MESSAGE.SET_TOKEN ('APPL_ID', TO_CHAR(l_application_id));
784: FND_MESSAGE.SET_TOKEN ('ACAD_ADM_PRD', l_acad_alt_code||'/'||l_adm_alt_code);
785:
786: insert_int_error(p_offresp_int_id, 'E693',fnd_message.get());
787: p_validation_success := 'N';

Line 784: FND_MESSAGE.SET_TOKEN ('ACAD_ADM_PRD', l_acad_alt_code||'/'||l_adm_alt_code);

780:
781: FND_MESSAGE.SET_NAME('IGS','IGS_AD_SINGLE_OFFRESP_EXISTS');
782: FND_MESSAGE.SET_TOKEN ('PROG_CODE',l_nominated_course_cd);
783: FND_MESSAGE.SET_TOKEN ('APPL_ID', TO_CHAR(l_application_id));
784: FND_MESSAGE.SET_TOKEN ('ACAD_ADM_PRD', l_acad_alt_code||'/'||l_adm_alt_code);
785:
786: insert_int_error(p_offresp_int_id, 'E693',fnd_message.get());
787: p_validation_success := 'N';
788: logdetail(p_offresp_int_id, 'E693',NULL, 'validate Single Response' ,NULL);

Line 786: insert_int_error(p_offresp_int_id, 'E693',fnd_message.get());

782: FND_MESSAGE.SET_TOKEN ('PROG_CODE',l_nominated_course_cd);
783: FND_MESSAGE.SET_TOKEN ('APPL_ID', TO_CHAR(l_application_id));
784: FND_MESSAGE.SET_TOKEN ('ACAD_ADM_PRD', l_acad_alt_code||'/'||l_adm_alt_code);
785:
786: insert_int_error(p_offresp_int_id, 'E693',fnd_message.get());
787: p_validation_success := 'N';
788: logdetail(p_offresp_int_id, 'E693',NULL, 'validate Single Response' ,NULL);
789: RETURN;
790: ELSE

Line 856: FND_FILE.PUT_LINE(FND_FILE.LOG,'validate_off_resp_dtls: '||FND_MESSAGE.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION')||' '||SQLERRM);

852: CLOSE c_valid_adm_cals;
853: END IF;
854: p_validation_success := 'N';
855: logdetail(p_offresp_int_id,'E621', NULL, 'validate_off_resp_dtls: EXCEPTION WHEN OTHERS ' ,NULL);
856: FND_FILE.PUT_LINE(FND_FILE.LOG,'validate_off_resp_dtls: '||FND_MESSAGE.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION')||' '||SQLERRM);
857: END validate_off_resp_dtls;
858:
859: PROCEDURE imp_off_resp( errbuf OUT NOCOPY VARCHAR2,
860: retcode OUT NOCOPY NUMBER,

Line 1059: FND_MESSAGE.SET_NAME('IGS','IGS_AD_NO_PEND_INT_REC');

1055:
1056: --This piece of code ensures that Processing is not done when there are no Pending Interface records found for given batch_id.
1057: IF NOT (t_offresp_int_id.COUNT >0) THEN
1058: logdetail(p_batch_id, NULL, NULL, NULL,'Y');
1059: FND_MESSAGE.SET_NAME('IGS','IGS_AD_NO_PEND_INT_REC');
1060: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);
1061: CLOSE int_off_resp_cur;
1062: RETURN;
1063: END IF;

Line 1060: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);

1056: --This piece of code ensures that Processing is not done when there are no Pending Interface records found for given batch_id.
1057: IF NOT (t_offresp_int_id.COUNT >0) THEN
1058: logdetail(p_batch_id, NULL, NULL, NULL,'Y');
1059: FND_MESSAGE.SET_NAME('IGS','IGS_AD_NO_PEND_INT_REC');
1060: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);
1061: CLOSE int_off_resp_cur;
1062: RETURN;
1063: END IF;
1064:

Line 1155: x_dummy := FND_MESSAGE.GET;

1151: ROLLBACK TO current_rec_savepoint;
1152: l_completed_flag := 'N';
1153: UPDATE igs_ad_offresp_int SET status = '3' WHERE offresp_int_id = t_offresp_int_id(t_idx);
1154:
1155: x_dummy := FND_MESSAGE.GET;
1156: insert_int_error(t_offresp_int_id (t_idx),NULL,x_dummy);
1157:
1158: logdetail(t_offresp_int_id(t_idx), NULL, x_dummy,'imp_off_resp: IF IGS_EN_VAL_SCA.handle_rederive_prog_att: '||x_dummy,NULL);
1159: END ;

Line 1314: fnd_message.parse_encoded(l_sc_encoded_text, l_sc_app_short_name, l_sc_message_name);

1310: --Loop through all messages in stack to check if there is Security Policy exception already set or not. Ref: Bug 3919112
1311: l_sc_msg_count := IGS_GE_MSG_STACK.COUNT_MSG;
1312: WHILE l_sc_msg_count <> 0 loop
1313: igs_ge_msg_stack.get(l_sc_msg_count, 'T', l_sc_encoded_text, l_sc_msg_index);
1314: fnd_message.parse_encoded(l_sc_encoded_text, l_sc_app_short_name, l_sc_message_name);
1315: IF l_sc_message_name = 'IGS_SC_POLICY_EXCEPTION' OR l_sc_message_name = 'IGS_SC_POLICY_UPD_DEL_EXCEP' THEN
1316: --print the the security exception in log file.
1317: fnd_message.set_encoded(l_sc_encoded_text);
1318: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());

Line 1317: fnd_message.set_encoded(l_sc_encoded_text);

1313: igs_ge_msg_stack.get(l_sc_msg_count, 'T', l_sc_encoded_text, l_sc_msg_index);
1314: fnd_message.parse_encoded(l_sc_encoded_text, l_sc_app_short_name, l_sc_message_name);
1315: IF l_sc_message_name = 'IGS_SC_POLICY_EXCEPTION' OR l_sc_message_name = 'IGS_SC_POLICY_UPD_DEL_EXCEP' THEN
1316: --print the the security exception in log file.
1317: fnd_message.set_encoded(l_sc_encoded_text);
1318: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
1319: EXIT;
1320: END IF;
1321: l_sc_msg_count := l_sc_msg_count - 1;

Line 1318: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());

1314: fnd_message.parse_encoded(l_sc_encoded_text, l_sc_app_short_name, l_sc_message_name);
1315: IF l_sc_message_name = 'IGS_SC_POLICY_EXCEPTION' OR l_sc_message_name = 'IGS_SC_POLICY_UPD_DEL_EXCEP' THEN
1316: --print the the security exception in log file.
1317: fnd_message.set_encoded(l_sc_encoded_text);
1318: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
1319: EXIT;
1320: END IF;
1321: l_sc_msg_count := l_sc_msg_count - 1;
1322: END LOOP;

Line 1507: FND_MESSAGE.SET_NAME('FND','CONC-SUBMITTED REQUEST');

1503:
1504: l_space_string :=' ';
1505: FND_FILE.PUT_LINE(FND_FILE.LOG, l_space_string);
1506:
1507: FND_MESSAGE.SET_NAME('FND','CONC-SUBMITTED REQUEST');
1508: FND_MESSAGE.SET_TOKEN('REQUEST_ID',IGS_GE_NUMBER.TO_CANN(l_request_id), FALSE);
1509: FND_FILE.PUT_LINE(FND_FILE.LOG,l_conc_Description||' '||FND_MESSAGE.GET);
1510:
1511: EXCEPTION --raised in the Concurrent job - Import Offer Response error report

Line 1508: FND_MESSAGE.SET_TOKEN('REQUEST_ID',IGS_GE_NUMBER.TO_CANN(l_request_id), FALSE);

1504: l_space_string :=' ';
1505: FND_FILE.PUT_LINE(FND_FILE.LOG, l_space_string);
1506:
1507: FND_MESSAGE.SET_NAME('FND','CONC-SUBMITTED REQUEST');
1508: FND_MESSAGE.SET_TOKEN('REQUEST_ID',IGS_GE_NUMBER.TO_CANN(l_request_id), FALSE);
1509: FND_FILE.PUT_LINE(FND_FILE.LOG,l_conc_Description||' '||FND_MESSAGE.GET);
1510:
1511: EXCEPTION --raised in the Concurrent job - Import Offer Response error report
1512: WHEN OTHERS THEN

Line 1509: FND_FILE.PUT_LINE(FND_FILE.LOG,l_conc_Description||' '||FND_MESSAGE.GET);

1505: FND_FILE.PUT_LINE(FND_FILE.LOG, l_space_string);
1506:
1507: FND_MESSAGE.SET_NAME('FND','CONC-SUBMITTED REQUEST');
1508: FND_MESSAGE.SET_TOKEN('REQUEST_ID',IGS_GE_NUMBER.TO_CANN(l_request_id), FALSE);
1509: FND_FILE.PUT_LINE(FND_FILE.LOG,l_conc_Description||' '||FND_MESSAGE.GET);
1510:
1511: EXCEPTION --raised in the Concurrent job - Import Offer Response error report
1512: WHEN OTHERS THEN
1513: IF int_off_resp_cur%ISOPEN THEN

Line 1529: errbuf := FND_MESSAGE.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION')||' '||SQLERRM;

1525: IF get_conc_desctiption%ISOPEN THEN
1526: CLOSE get_conc_desctiption;
1527: END IF;
1528: retcode:=2;
1529: errbuf := FND_MESSAGE.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION')||' '||SQLERRM;
1530: FND_FILE.PUT_LINE(FND_FILE.LOG,'igs_ad_imp_off_resp_data.imp_off_resp: '||errbuf);
1531: Igs_Ge_Msg_Stack.CONC_EXCEPTION_HNDL;
1532:
1533: END imp_off_resp; -- End of the main procedure