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_FILE

Line 75: FND_FILE.PUT_LINE(FND_FILE.LOG, l_full_string);

71: FETCH batch_details INTO l_batch_rec;
72: CLOSE batch_Details;
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);

Line 79: FND_FILE.PUT_LINE(FND_FILE.LOG, 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);
83:

Line 82: FND_FILE.PUT_LINE(FND_FILE.LOG, l_full_string);

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);
83:
84: FND_MESSAGE.SET_NAME('IGS','IGS_AD_IMP_OFR_LOG_HDR');
85: l_full_string := FND_MESSAGE.GET;
86:

Line 87: 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 :='----------------------------------------------------------------------------------------------------------------------------------';
90: FND_FILE.PUT_LINE(FND_FILE.LOG, l_full_string);
91:

Line 90: FND_FILE.PUT_LINE(FND_FILE.LOG, l_full_string);

86:
87: FND_FILE.PUT_LINE(FND_FILE.LOG, l_full_string);
88:
89: l_full_string :='----------------------------------------------------------------------------------------------------------------------------------';
90: FND_FILE.PUT_LINE(FND_FILE.LOG, l_full_string);
91:
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);

Line 94: FND_FILE.PUT_LINE(FND_FILE.LOG, l_text);

90: FND_FILE.PUT_LINE(FND_FILE.LOG, l_full_string);
91:
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);

Line 98: FND_FILE.PUT_LINE(FND_FILE.LOG, l_full_string||' '||l_debug_msg);

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

Line 100: FND_FILE.PUT_LINE(FND_FILE.LOG, l_full_string);

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

Line 109: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(IGS_GE_NUMBER.TO_CANN(l_id),15,' ')||' '||l_full_string);

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:
112: EXCEPTION
113: WHEN OTHERS THEN

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 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 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 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 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 1505: FND_FILE.PUT_LINE(FND_FILE.LOG, l_space_string);

1501: FETCH get_conc_desctiption INTO l_conc_Description;
1502: CLOSE get_conc_desctiption;
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);

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 1530: FND_FILE.PUT_LINE(FND_FILE.LOG,'igs_ad_imp_off_resp_data.imp_off_resp: '||errbuf);

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
1534: