172: OPEN gc_lkups ('E',g_cst_lgcy_status);
173: FETCH gc_lkups INTO l_meaning;
174: CLOSE gc_lkups;
175:
176: FND_FILE.PUT_LINE(FND_FILE.LOG,l_meaning || ' ' || l_table_meaning || ' ' || l_msg_text);
177:
178: END log_resource_busy;
179:
180: -------------------------------------------------------------------------------
183: BEGIN
184: IF p_log THEN
185: FND_MESSAGE.SET_NAME('FND','FND_DEF_ALTERNATE_TEXT');
186: l_msg_text := FND_MESSAGE.GET;
187: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ' || l_msg_text);
188: END IF;
189: END log_no_data_exists;
190:
191: -------------------------------------------------------------------------------
228: OPEN gc_lkups (p_int_table_code,g_cst_tbl_lkup_type);
229: FETCH gc_lkups INTO l_table_meaning;
230: CLOSE gc_lkups;
231:
232: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
233: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
234: FND_FILE.PUT_LINE(FND_FILE.LOG,'--------------------------------------------------------------------------------');
235: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_text5 || ' ' || l_table_meaning);
236: FND_FILE.PUT_LINE(FND_FILE.LOG,'--------------------------------------------------------------------------------');
229: FETCH gc_lkups INTO l_table_meaning;
230: CLOSE gc_lkups;
231:
232: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
233: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
234: FND_FILE.PUT_LINE(FND_FILE.LOG,'--------------------------------------------------------------------------------');
235: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_text5 || ' ' || l_table_meaning);
236: FND_FILE.PUT_LINE(FND_FILE.LOG,'--------------------------------------------------------------------------------');
237: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_text1 || ' ' || l_msg_text2 || ' ' || l_msg_text3 || ' ' || l_msg_text4 );
230: CLOSE gc_lkups;
231:
232: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
233: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
234: FND_FILE.PUT_LINE(FND_FILE.LOG,'--------------------------------------------------------------------------------');
235: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_text5 || ' ' || l_table_meaning);
236: FND_FILE.PUT_LINE(FND_FILE.LOG,'--------------------------------------------------------------------------------');
237: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_text1 || ' ' || l_msg_text2 || ' ' || l_msg_text3 || ' ' || l_msg_text4 );
238: FND_FILE.PUT_LINE(FND_FILE.LOG,'--------------------------------------------------------------------------------');
231:
232: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
233: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
234: FND_FILE.PUT_LINE(FND_FILE.LOG,'--------------------------------------------------------------------------------');
235: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_text5 || ' ' || l_table_meaning);
236: FND_FILE.PUT_LINE(FND_FILE.LOG,'--------------------------------------------------------------------------------');
237: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_text1 || ' ' || l_msg_text2 || ' ' || l_msg_text3 || ' ' || l_msg_text4 );
238: FND_FILE.PUT_LINE(FND_FILE.LOG,'--------------------------------------------------------------------------------');
239:
232: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
233: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
234: FND_FILE.PUT_LINE(FND_FILE.LOG,'--------------------------------------------------------------------------------');
235: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_text5 || ' ' || l_table_meaning);
236: FND_FILE.PUT_LINE(FND_FILE.LOG,'--------------------------------------------------------------------------------');
237: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_text1 || ' ' || l_msg_text2 || ' ' || l_msg_text3 || ' ' || l_msg_text4 );
238: FND_FILE.PUT_LINE(FND_FILE.LOG,'--------------------------------------------------------------------------------');
239:
240: END log_headers;
233: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
234: FND_FILE.PUT_LINE(FND_FILE.LOG,'--------------------------------------------------------------------------------');
235: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_text5 || ' ' || l_table_meaning);
236: FND_FILE.PUT_LINE(FND_FILE.LOG,'--------------------------------------------------------------------------------');
237: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_text1 || ' ' || l_msg_text2 || ' ' || l_msg_text3 || ' ' || l_msg_text4 );
238: FND_FILE.PUT_LINE(FND_FILE.LOG,'--------------------------------------------------------------------------------');
239:
240: END log_headers;
241:
234: FND_FILE.PUT_LINE(FND_FILE.LOG,'--------------------------------------------------------------------------------');
235: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_text5 || ' ' || l_table_meaning);
236: FND_FILE.PUT_LINE(FND_FILE.LOG,'--------------------------------------------------------------------------------');
237: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_text1 || ' ' || l_msg_text2 || ' ' || l_msg_text3 || ' ' || l_msg_text4 );
238: FND_FILE.PUT_LINE(FND_FILE.LOG,'--------------------------------------------------------------------------------');
239:
240: END log_headers;
241:
242: -------------------------------------------------------------------------------
254: FETCH gc_lkups INTO l_meaning;
255: CLOSE gc_lkups;
256:
257: -- log the error message in the concurrent log
258: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(p_int_table_id,15,' ')
259: || ' '
260: || ' ' || RPAD(l_meaning,22,' ')
261: || ' ' || l_msg_text);
262:
352: ..
353: --------------------------------------------------------------------------------
354: */
355: -- log the error message in the concurrent log
356: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(p_int_table_id,15,' ')
357: || ' ' || RPAD(NVL(TO_CHAR(p_msg_number),' '),9,' ')
358: || ' ' || RPAD(l_status_mean,22,' ')
359: || ' ' || p_msg_text);
360:
3751:
3752: FND_MESSAGE.SET_NAME('IGS','IGS_EN_REG_LOG_DESC');
3753: l_msg_text0 := FND_MESSAGE.GET;
3754:
3755: FND_FILE.PUT_LINE(FND_FILE.LOG,'================================================================================');
3756: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
3757: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_text || ': ' || p_batch_id || ' ' || l_msg_text0 || ': ' || l_description);
3758: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
3759: FND_FILE.PUT_LINE(FND_FILE.LOG,'================================================================================');
3752: FND_MESSAGE.SET_NAME('IGS','IGS_EN_REG_LOG_DESC');
3753: l_msg_text0 := FND_MESSAGE.GET;
3754:
3755: FND_FILE.PUT_LINE(FND_FILE.LOG,'================================================================================');
3756: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
3757: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_text || ': ' || p_batch_id || ' ' || l_msg_text0 || ': ' || l_description);
3758: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
3759: FND_FILE.PUT_LINE(FND_FILE.LOG,'================================================================================');
3760:
3753: l_msg_text0 := FND_MESSAGE.GET;
3754:
3755: FND_FILE.PUT_LINE(FND_FILE.LOG,'================================================================================');
3756: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
3757: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_text || ': ' || p_batch_id || ' ' || l_msg_text0 || ': ' || l_description);
3758: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
3759: FND_FILE.PUT_LINE(FND_FILE.LOG,'================================================================================');
3760:
3761: -- Call the procedure to process Student Program Attempt interface records
3754:
3755: FND_FILE.PUT_LINE(FND_FILE.LOG,'================================================================================');
3756: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
3757: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_text || ': ' || p_batch_id || ' ' || l_msg_text0 || ': ' || l_description);
3758: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
3759: FND_FILE.PUT_LINE(FND_FILE.LOG,'================================================================================');
3760:
3761: -- Call the procedure to process Student Program Attempt interface records
3762: IF p_table_code = g_cst_all OR p_table_code = g_cst_en_spa THEN
3755: FND_FILE.PUT_LINE(FND_FILE.LOG,'================================================================================');
3756: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
3757: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_text || ': ' || p_batch_id || ' ' || l_msg_text0 || ': ' || l_description);
3758: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
3759: FND_FILE.PUT_LINE(FND_FILE.LOG,'================================================================================');
3760:
3761: -- Call the procedure to process Student Program Attempt interface records
3762: IF p_table_code = g_cst_all OR p_table_code = g_cst_en_spa THEN
3763: process_en_spa(
3914:
3915: EXCEPTION
3916: WHEN OTHERS THEN
3917: retcode:=2;
3918: Fnd_File.PUT_LINE(Fnd_File.LOG,SQLERRM);
3919: ERRBUF := Fnd_Message.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION');
3920: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
3921: END legacy_batch_process;
3922: