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.IGF_SL_UPLOAD_XML dependencies on FND_LOG

Line 90: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

86: -- Remove data from resp tables because of any of the following reasons
87: -- 1. Destination entity id is not correct.
88: -- 2. It is a receipt document
89: -- 3. Invalid Full_Resp_code value
90: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
91: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.rollback_resp_tables.debug','Removing data from resp tables');
92: END IF;
93:
94: FOR l_temp IN get_cod_temp

Line 91: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.rollback_resp_tables.debug','Removing data from resp tables');

87: -- 1. Destination entity id is not correct.
88: -- 2. It is a receipt document
89: -- 3. Invalid Full_Resp_code value
90: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
91: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.rollback_resp_tables.debug','Removing data from resp tables');
92: END IF;
93:
94: FOR l_temp IN get_cod_temp
95: LOOP

Line 117: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

113: DELETE IGF_SL_DI_RESP_DTLS WHERE DL_INFO_ID = l_temp.REC_ID;
114: END IF;
115: END LOOP;
116:
117: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
118: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.rollback_resp_tables.debug','Removing data from IGF_SL_COD_TEMP');
119: END IF;
120: DELETE IGF_SL_COD_TEMP;
121:

Line 118: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.rollback_resp_tables.debug','Removing data from IGF_SL_COD_TEMP');

114: END IF;
115: END LOOP;
116:
117: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
118: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.rollback_resp_tables.debug','Removing data from IGF_SL_COD_TEMP');
119: END IF;
120: DELETE IGF_SL_COD_TEMP;
121:
122: COMMIT;

Line 218: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

214: lv_filename VARCHAR2(300);
215: ln_file_line_num NUMBER;
216: BEGIN
217: igf_aw_gen.set_org_id(NULL);
218: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
219: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main.debug','main started');
220: END IF;
221:
222: -- Step 1. Print the log parameters

Line 219: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main.debug','main started');

215: ln_file_line_num NUMBER;
216: BEGIN
217: igf_aw_gen.set_org_id(NULL);
218: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
219: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main.debug','main started');
220: END IF;
221:
222: -- Step 1. Print the log parameters
223: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 223: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

219: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main.debug','main started');
220: END IF;
221:
222: -- Step 1. Print the log parameters
223: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
224: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main.debug','file path is: ' || p_file_path);
225: END IF;
226: fnd_file.put_line(fnd_file.log,'File Path : '||p_file_path);
227:

Line 224: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main.debug','file path is: ' || p_file_path);

220: END IF;
221:
222: -- Step 1. Print the log parameters
223: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
224: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main.debug','file path is: ' || p_file_path);
225: END IF;
226: fnd_file.put_line(fnd_file.log,'File Path : '||p_file_path);
227:
228: -- Step 2. Get the XML file from the file path and store it in COD_DOC_DTLS table.

Line 241: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

237: END IF;
238: l_endofdir := l_temp_endofdir;
239: END LOOP;
240:
241: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
242: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main.debug','Final value of l_endofdire is: ' || l_endofdir);
243: END IF;
244:
245: lv_directory := SUBSTR(l_file_path, 1, l_endofdir-1);

Line 242: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main.debug','Final value of l_endofdire is: ' || l_endofdir);

238: l_endofdir := l_temp_endofdir;
239: END LOOP;
240:
241: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
242: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main.debug','Final value of l_endofdire is: ' || l_endofdir);
243: END IF;
244:
245: lv_directory := SUBSTR(l_file_path, 1, l_endofdir-1);
246: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 246: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

242: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main.debug','Final value of l_endofdire is: ' || l_endofdir);
243: END IF;
244:
245: lv_directory := SUBSTR(l_file_path, 1, l_endofdir-1);
246: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
247: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main.debug','lv_directory: ' || lv_directory);
248: END IF;
249: lv_filename := SUBSTR(l_file_path, l_endofdir+1);
250: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 247: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main.debug','lv_directory: ' || lv_directory);

243: END IF;
244:
245: lv_directory := SUBSTR(l_file_path, 1, l_endofdir-1);
246: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
247: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main.debug','lv_directory: ' || lv_directory);
248: END IF;
249: lv_filename := SUBSTR(l_file_path, l_endofdir+1);
250: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
251: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main.debug','lv_filename: ' || lv_filename);

Line 250: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

246: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
247: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main.debug','lv_directory: ' || lv_directory);
248: END IF;
249: lv_filename := SUBSTR(l_file_path, l_endofdir+1);
250: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
251: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main.debug','lv_filename: ' || lv_filename);
252: END IF;
253:
254: -- Open the file

Line 251: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main.debug','lv_filename: ' || lv_filename);

247: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main.debug','lv_directory: ' || lv_directory);
248: END IF;
249: lv_filename := SUBSTR(l_file_path, l_endofdir+1);
250: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
251: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main.debug','lv_filename: ' || lv_filename);
252: END IF;
253:
254: -- Open the file
255: BEGIN

Line 259: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

255: BEGIN
256: lv_file := utl_file.fopen(lv_directory, lv_filename, 'r', 32767);
257: EXCEPTION
258: WHEN UTL_FILE.INVALID_PATH THEN
259: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
260: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main.debug','UTL_FILE.INVALID_PATH Exception occurred');
261: END IF;
262: RAISE;
263: RETURN;

Line 260: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main.debug','UTL_FILE.INVALID_PATH Exception occurred');

256: lv_file := utl_file.fopen(lv_directory, lv_filename, 'r', 32767);
257: EXCEPTION
258: WHEN UTL_FILE.INVALID_PATH THEN
259: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
260: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main.debug','UTL_FILE.INVALID_PATH Exception occurred');
261: END IF;
262: RAISE;
263: RETURN;
264: WHEN UTL_FILE.INVALID_MODE THEN

Line 265: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

261: END IF;
262: RAISE;
263: RETURN;
264: WHEN UTL_FILE.INVALID_MODE THEN
265: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
266: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main.debug','UTL_FILE.INVALID_MODE Exception occurred');
267: END IF;
268: RAISE;
269: RETURN;

Line 266: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main.debug','UTL_FILE.INVALID_MODE Exception occurred');

262: RAISE;
263: RETURN;
264: WHEN UTL_FILE.INVALID_MODE THEN
265: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
266: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main.debug','UTL_FILE.INVALID_MODE Exception occurred');
267: END IF;
268: RAISE;
269: RETURN;
270: WHEN UTL_FILE.INVALID_OPERATION THEN

Line 271: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

267: END IF;
268: RAISE;
269: RETURN;
270: WHEN UTL_FILE.INVALID_OPERATION THEN
271: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
272: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main.debug','UTL_FILE.INVALID_OPERATION Exception occurred');
273: END IF;
274: RAISE;
275: RETURN;

Line 272: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main.debug','UTL_FILE.INVALID_OPERATION Exception occurred');

268: RAISE;
269: RETURN;
270: WHEN UTL_FILE.INVALID_OPERATION THEN
271: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
272: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main.debug','UTL_FILE.INVALID_OPERATION Exception occurred');
273: END IF;
274: RAISE;
275: RETURN;
276: END;

Line 284: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

280: tmpClob1 := EMPTY_CLOB;
281: DBMS_LOB.CREATETEMPORARY(tmpClob1,TRUE,DBMS_LOB.SESSION);
282: DBMS_LOB.OPEN(tmpClob1,DBMS_LOB.LOB_READWRITE);
283: IF DBMS_LOB.ISOPEN(tmpClob1) = 1 THEN
284: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
285: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main.debug','tmpClob1 IS opened successfully');
286: END IF;
287: ELSE
288: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 285: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main.debug','tmpClob1 IS opened successfully');

281: DBMS_LOB.CREATETEMPORARY(tmpClob1,TRUE,DBMS_LOB.SESSION);
282: DBMS_LOB.OPEN(tmpClob1,DBMS_LOB.LOB_READWRITE);
283: IF DBMS_LOB.ISOPEN(tmpClob1) = 1 THEN
284: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
285: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main.debug','tmpClob1 IS opened successfully');
286: END IF;
287: ELSE
288: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
289: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main.debug','tmpClob1 is NOT opened successfully');

Line 288: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

284: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
285: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main.debug','tmpClob1 IS opened successfully');
286: END IF;
287: ELSE
288: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
289: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main.debug','tmpClob1 is NOT opened successfully');
290: END IF;
291: RETURN;
292: END IF;

Line 289: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main.debug','tmpClob1 is NOT opened successfully');

285: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main.debug','tmpClob1 IS opened successfully');
286: END IF;
287: ELSE
288: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
289: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main.debug','tmpClob1 is NOT opened successfully');
290: END IF;
291: RETURN;
292: END IF;
293:

Line 300: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

296: BEGIN
297: LOOP
298: -- When EOF reaches, GET_LINE raises NO DATA FOUND Exception.
299: ln_file_line_num := ln_file_line_num + 1;
300: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
301: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main.debug', 'Before reading line number: ' || ln_file_line_num);
302: END IF;
303:
304: UTL_FILE.GET_LINE(lv_file, myclob_text);

Line 301: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main.debug', 'Before reading line number: ' || ln_file_line_num);

297: LOOP
298: -- When EOF reaches, GET_LINE raises NO DATA FOUND Exception.
299: ln_file_line_num := ln_file_line_num + 1;
300: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
301: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main.debug', 'Before reading line number: ' || ln_file_line_num);
302: END IF;
303:
304: UTL_FILE.GET_LINE(lv_file, myclob_text);
305:

Line 306: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

302: END IF;
303:
304: UTL_FILE.GET_LINE(lv_file, myclob_text);
305:
306: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
307: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main.debug', 'After reading line number: ' || ln_file_line_num || 'Length of the text is: ' || LENGTH(myclob_text) || 'Start of the text is: ' || SUBSTR(myclob_text, 1, 32));
308: END IF;
309:
310: IF myclob_text IS NOT NULL AND LENGTH(myclob_text) <> 0 THEN

Line 307: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main.debug', 'After reading line number: ' || ln_file_line_num || 'Length of the text is: ' || LENGTH(myclob_text) || 'Start of the text is: ' || SUBSTR(myclob_text, 1, 32));

303:
304: UTL_FILE.GET_LINE(lv_file, myclob_text);
305:
306: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
307: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main.debug', 'After reading line number: ' || ln_file_line_num || 'Length of the text is: ' || LENGTH(myclob_text) || 'Start of the text is: ' || SUBSTR(myclob_text, 1, 32));
308: END IF;
309:
310: IF myclob_text IS NOT NULL AND LENGTH(myclob_text) <> 0 THEN
311: DBMS_LOB.WRITEAPPEND(tmpClob1, LENGTH(myclob_text), myclob_text);

Line 320: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

316: WHEN NO_DATA_FOUND THEN
317: -- This will Auto-Close the file when EOF Reaches
318: UTL_FILE.FCLOSE(lv_file);
319: WHEN OTHERS THEN
320: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
321: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main.debug','Exception occurred while creating tmpClob1');
322: END IF;
323: RAISE;
324: RETURN;

Line 321: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main.debug','Exception occurred while creating tmpClob1');

317: -- This will Auto-Close the file when EOF Reaches
318: UTL_FILE.FCLOSE(lv_file);
319: WHEN OTHERS THEN
320: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
321: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main.debug','Exception occurred while creating tmpClob1');
322: END IF;
323: RAISE;
324: RETURN;
325: END;

Line 332: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

328: tmpClob := EMPTY_CLOB;
329: DBMS_LOB.CREATETEMPORARY(tmpClob,TRUE,DBMS_LOB.SESSION);
330: DBMS_LOB.OPEN(tmpClob,DBMS_LOB.LOB_READWRITE);
331: IF DBMS_LOB.ISOPEN(tmpClob1) = 1 THEN
332: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
333: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main.debug','tmpClob IS opened successfully');
334: END IF;
335: ELSE
336: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 333: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main.debug','tmpClob IS opened successfully');

329: DBMS_LOB.CREATETEMPORARY(tmpClob,TRUE,DBMS_LOB.SESSION);
330: DBMS_LOB.OPEN(tmpClob,DBMS_LOB.LOB_READWRITE);
331: IF DBMS_LOB.ISOPEN(tmpClob1) = 1 THEN
332: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
333: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main.debug','tmpClob IS opened successfully');
334: END IF;
335: ELSE
336: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
337: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main.debug','tmpClob is NOT opened successfully');

Line 336: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

332: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
333: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main.debug','tmpClob IS opened successfully');
334: END IF;
335: ELSE
336: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
337: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main.debug','tmpClob is NOT opened successfully');
338: END IF;
339: RETURN;
340: END IF;

Line 337: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main.debug','tmpClob is NOT opened successfully');

333: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main.debug','tmpClob IS opened successfully');
334: END IF;
335: ELSE
336: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
337: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main.debug','tmpClob is NOT opened successfully');
338: END IF;
339: RETURN;
340: END IF;
341:

Line 346: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

342: -- Copy from tmpClob1 to tmpClob
343: ln_start_pos := DBMS_LOB.INSTR(tmpClob1,' 344: ln_end_pos := DBMS_LOB.INSTR(tmpClob1,'',1,1);
345: ln_end_pos := ln_end_pos + LENGTH('');
346: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
347: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main.debug', 'Start of ie ln_end_pos is: ' || ln_end_pos);
348: END IF;
349: DBMS_LOB.COPY(tmpClob, tmpClob1, ln_end_pos-ln_start_pos, 1, ln_start_pos);
350:

Line 347: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main.debug', 'Start of ie ln_end_pos is: ' || ln_end_pos);

343: ln_start_pos := DBMS_LOB.INSTR(tmpClob1,' 344: ln_end_pos := DBMS_LOB.INSTR(tmpClob1,'',1,1);
345: ln_end_pos := ln_end_pos + LENGTH('');
346: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
347: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main.debug', 'Start of ie ln_end_pos is: ' || ln_end_pos);
348: END IF;
349: DBMS_LOB.COPY(tmpClob, tmpClob1, ln_end_pos-ln_start_pos, 1, ln_start_pos);
350:
351: -- Try to find out the document id from the file

Line 353: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

349: DBMS_LOB.COPY(tmpClob, tmpClob1, ln_end_pos-ln_start_pos, 1, ln_start_pos);
350:
351: -- Try to find out the document id from the file
352: MYCLOB_TEXT := TRIM(DBMS_LOB.SUBSTR(tmpClob,10000,1));
353: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
354: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main.debug','MYCLOB_TEXT is read successfully: '||SUBSTR(MYCLOB_TEXT, 1, 1000));
355: END IF;
356:
357: l_start_pos := INSTR(MYCLOB_TEXT,'',1,1);

Line 354: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main.debug','MYCLOB_TEXT is read successfully: '||SUBSTR(MYCLOB_TEXT, 1, 1000));

350:
351: -- Try to find out the document id from the file
352: MYCLOB_TEXT := TRIM(DBMS_LOB.SUBSTR(tmpClob,10000,1));
353: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
354: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main.debug','MYCLOB_TEXT is read successfully: '||SUBSTR(MYCLOB_TEXT, 1, 1000));
355: END IF;
356:
357: l_start_pos := INSTR(MYCLOB_TEXT,'',1,1);
358: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 358: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

354: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main.debug','MYCLOB_TEXT is read successfully: '||SUBSTR(MYCLOB_TEXT, 1, 1000));
355: END IF;
356:
357: l_start_pos := INSTR(MYCLOB_TEXT,'',1,1);
358: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
359: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main.debug','l_start_pos is: ' || l_start_pos);
360: END IF;
361:
362: IF l_start_pos = 0 THEN

Line 359: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main.debug','l_start_pos is: ' || l_start_pos);

355: END IF;
356:
357: l_start_pos := INSTR(MYCLOB_TEXT,'',1,1);
358: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
359: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main.debug','l_start_pos is: ' || l_start_pos);
360: END IF;
361:
362: IF l_start_pos = 0 THEN
363: fnd_message.set_name('IGF','IGF_SL_COD_IB_NO_XML_DOC_ID');

Line 368: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

364: fnd_file.put_line(fnd_file.log, fnd_message.get);
365: RETURN;
366: ELSE
367: l_doc_id := SUBSTR(MYCLOB_TEXT,(l_start_pos+12),30);
368: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
369: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main.debug','Document ID read from XML is: ' || l_doc_id);
370: END IF;
371: END IF;
372:

Line 369: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main.debug','Document ID read from XML is: ' || l_doc_id);

365: RETURN;
366: ELSE
367: l_doc_id := SUBSTR(MYCLOB_TEXT,(l_start_pos+12),30);
368: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
369: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main.debug','Document ID read from XML is: ' || l_doc_id);
370: END IF;
371: END IF;
372:
373: -- Insert/Update the IGF_SL_COD_DOC_DTLS TABLE

Line 396: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

392: x_full_resp_code => l_get_doc.full_resp_code
393: );
394: COMMIT;
395:
396: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
397: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main.debug','Document successfully loaded in table');
398: END IF;
399:
400: -- Step 3. Raise the business event.

Line 397: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main.debug','Document successfully loaded in table');

393: );
394: COMMIT;
395:
396: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
397: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main.debug','Document successfully loaded in table');
398: END IF;
399:
400: -- Step 3. Raise the business event.
401: l_event_name := 'oracle.apps.igf.sl.loadxml';

Line 430: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

426: p_value => l_doc_id,
427: p_parameterlist => l_parameter_list
428: );
429:
430: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
431: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main.debug','Raising business event with key: ' || l_event_key);
432: END IF;
433: -- raise the business event
434: wf_event.RAISE (

Line 431: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main.debug','Raising business event with key: ' || l_event_key);

427: p_parameterlist => l_parameter_list
428: );
429:
430: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
431: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main.debug','Raising business event with key: ' || l_event_key);
432: END IF;
433: -- raise the business event
434: wf_event.RAISE (
435: p_event_name => l_event_name,

Line 450: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

446: ROLLBACK;
447: retcode := 2;
448: errbuf := fnd_message.get_string('IGS','IGS_GE_UNHANDLED_EXCEPTION');
449: fnd_file.put_line(fnd_file.log, SQLERRM);
450: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
451: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main.debug','sqlerrm ' || SQLERRM);
452: END IF;
453: igs_ge_msg_stack.conc_exception_hndl;
454: END main;

Line 451: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main.debug','sqlerrm ' || SQLERRM);

447: retcode := 2;
448: errbuf := fnd_message.get_string('IGS','IGS_GE_UNHANDLED_EXCEPTION');
449: fnd_file.put_line(fnd_file.log, SQLERRM);
450: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
451: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main.debug','sqlerrm ' || SQLERRM);
452: END IF;
453: igs_ge_msg_stack.conc_exception_hndl;
454: END main;
455:

Line 487: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

483: end_tag INTEGER;
484:
485: BEGIN
486: l_doc_id := wf_engine.getitemattrtext ( itemtype, itemkey, 'ECX_PARAMETER1');
487: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
488: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.upload_xml.debug','Document Id from the ECX_PARAMETER1' || l_doc_id);
489: END IF;
490:
491: SELECT INBOUND_DOC INTO xmldoc FROM igf_sl_cod_doc_dtls WHERE DOCUMENT_ID_TXT = l_doc_id;

Line 488: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.upload_xml.debug','Document Id from the ECX_PARAMETER1' || l_doc_id);

484:
485: BEGIN
486: l_doc_id := wf_engine.getitemattrtext ( itemtype, itemkey, 'ECX_PARAMETER1');
487: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
488: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.upload_xml.debug','Document Id from the ECX_PARAMETER1' || l_doc_id);
489: END IF;
490:
491: SELECT INBOUND_DOC INTO xmldoc FROM igf_sl_cod_doc_dtls WHERE DOCUMENT_ID_TXT = l_doc_id;
492: SELECT INBOUND_DOC INTO newxmldoc FROM igf_sl_cod_doc_dtls WHERE DOCUMENT_ID_TXT = l_doc_id FOR UPDATE;

Line 495: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

491: SELECT INBOUND_DOC INTO xmldoc FROM igf_sl_cod_doc_dtls WHERE DOCUMENT_ID_TXT = l_doc_id;
492: SELECT INBOUND_DOC INTO newxmldoc FROM igf_sl_cod_doc_dtls WHERE DOCUMENT_ID_TXT = l_doc_id FOR UPDATE;
493:
494: new_xml_len := DBMS_LOB.GETLENGTH(newxmldoc);
495: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
496: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.upload_xml.debug','Before erasing the newxmldoc. Its length new_xml_len is '||new_xml_len);
497: END IF;
498: DBMS_LOB.ERASE(newxmldoc, new_xml_len, 1);
499:

Line 496: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.upload_xml.debug','Before erasing the newxmldoc. Its length new_xml_len is '||new_xml_len);

492: SELECT INBOUND_DOC INTO newxmldoc FROM igf_sl_cod_doc_dtls WHERE DOCUMENT_ID_TXT = l_doc_id FOR UPDATE;
493:
494: new_xml_len := DBMS_LOB.GETLENGTH(newxmldoc);
495: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
496: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.upload_xml.debug','Before erasing the newxmldoc. Its length new_xml_len is '||new_xml_len);
497: END IF;
498: DBMS_LOB.ERASE(newxmldoc, new_xml_len, 1);
499:
500: buffer := '

Line 503: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

499:
500: buffer := '
501: ';
502: amount := LENGTH(buffer);
503: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
504: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.upload_xml.debug','Writing root tags into newxmldoc');
505: END IF;
506: DBMS_LOB.WRITE(newxmldoc, amount, 1, buffer);
507: --akomurav one off 4873868

Line 504: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.upload_xml.debug','Writing root tags into newxmldoc');

500: buffer := '
501: ';
502: amount := LENGTH(buffer);
503: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
504: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.upload_xml.debug','Writing root tags into newxmldoc');
505: END IF;
506: DBMS_LOB.WRITE(newxmldoc, amount, 1, buffer);
507: --akomurav one off 4873868
508: -- Remove the xsi:nil tags from the inbound file

Line 530: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

526:
527: DBMS_LOB.COPY(newxmldoc,xmldoc,new_l_start_pos_buffer-new_l_start_pos+1,amount+1,new_l_start_pos);
528: buffer := '';
529: amount := LENGTH(buffer);
530: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
531: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.upload_xml.debug','Appending tag');
532: END IF;
533: DBMS_LOB.WRITEAPPEND(newxmldoc, amount, buffer);
534: END;

Line 531: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.upload_xml.debug','Appending tag');

527: DBMS_LOB.COPY(newxmldoc,xmldoc,new_l_start_pos_buffer-new_l_start_pos+1,amount+1,new_l_start_pos);
528: buffer := '';
529: amount := LENGTH(buffer);
530: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
531: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.upload_xml.debug','Appending tag');
532: END IF;
533: DBMS_LOB.WRITEAPPEND(newxmldoc, amount, buffer);
534: END;
535:

Line 537: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

533: DBMS_LOB.WRITEAPPEND(newxmldoc, amount, buffer);
534: END;
535:
536: -- set the workflow attributes
537: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
538: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.upload_xml.debug','Before setting workflow attributes');
539: END IF;
540: wf_event_t.Initialize(l_wf_event);
541: l_wf_event.setEventData(newxmldoc);

Line 538: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.upload_xml.debug','Before setting workflow attributes');

534: END;
535:
536: -- set the workflow attributes
537: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
538: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.upload_xml.debug','Before setting workflow attributes');
539: END IF;
540: wf_event_t.Initialize(l_wf_event);
541: l_wf_event.setEventData(newxmldoc);
542: wf_engine.SetItemAttrEvent(itemtype,itemkey,'ECX_EVENT_MESSAGE',l_wf_event);

Line 551: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

547: resultout := 'F';
548: wf_core.context ('IGF_SL_UPLOAD_XML',
549: 'UPLOAD_XML', itemtype,
550: itemkey,to_char(actid), funcmode);
551: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
552: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.upload_xml.debug','sqlerrm ' || SQLERRM);
553: END IF;
554: END upload_xml;
555:

Line 552: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.upload_xml.debug','sqlerrm ' || SQLERRM);

548: wf_core.context ('IGF_SL_UPLOAD_XML',
549: 'UPLOAD_XML', itemtype,
550: itemkey,to_char(actid), funcmode);
551: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
552: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.upload_xml.debug','sqlerrm ' || SQLERRM);
553: END IF;
554: END upload_xml;
555:
556: PROCEDURE print_edits ( p_id IN VARCHAR2,

Line 1836: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

1832: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','DOC_ID')|| ':'||p_doc_id);
1833: fnd_file.put_line(fnd_file.log,'');
1834:
1835: -- Check if the document is present or not.
1836: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1837: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main_response.debug','Checking document(' || p_doc_id || ') is present or not');
1838: END IF;
1839: l_doc_id := NULL;
1840: OPEN chk_doc(p_doc_id);

Line 1837: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main_response.debug','Checking document(' || p_doc_id || ') is present or not');

1833: fnd_file.put_line(fnd_file.log,'');
1834:
1835: -- Check if the document is present or not.
1836: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1837: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main_response.debug','Checking document(' || p_doc_id || ') is present or not');
1838: END IF;
1839: l_doc_id := NULL;
1840: OPEN chk_doc(p_doc_id);
1841: FETCH chk_doc INTO l_chk_doc;

Line 1853: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

1849: -- set the global doc id
1850: g_doc_id := p_doc_id;
1851:
1852: -- take the data from the temp tables into the response tables
1853: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1854: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main_response.debug','Updating Response details from COD_TEMP table to RESP Tables');
1855: END IF;
1856: FOR l_temp IN get_cod_temp
1857: LOOP

Line 1854: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main_response.debug','Updating Response details from COD_TEMP table to RESP Tables');

1850: g_doc_id := p_doc_id;
1851:
1852: -- take the data from the temp tables into the response tables
1853: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1854: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main_response.debug','Updating Response details from COD_TEMP table to RESP Tables');
1855: END IF;
1856: FOR l_temp IN get_cod_temp
1857: LOOP
1858: IF l_temp.LEVEL_CODE = 'CR' THEN

Line 1954: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

1950: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','PROC_DATE')|| ':'||l_get_cr_resp.PROCESS_DATE);
1951:
1952: -- Check if the document is receipt document or not. If it is, then
1953: -- log message and return. Do not process if it is receipt document.
1954: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1955: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main_response.debug','RECEIPT_DATE is ' || l_get_cr_resp.RECEIPT_DATE);
1956: END IF;
1957: IF l_get_cr_resp.RECEIPT_DATE IS NOT NULL THEN
1958: fnd_file.put_line(fnd_file.log,'receipt date is not null');

Line 1955: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main_response.debug','RECEIPT_DATE is ' || l_get_cr_resp.RECEIPT_DATE);

1951:
1952: -- Check if the document is receipt document or not. If it is, then
1953: -- log message and return. Do not process if it is receipt document.
1954: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1955: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main_response.debug','RECEIPT_DATE is ' || l_get_cr_resp.RECEIPT_DATE);
1956: END IF;
1957: IF l_get_cr_resp.RECEIPT_DATE IS NOT NULL THEN
1958: fnd_file.put_line(fnd_file.log,'receipt date is not null');
1959: fnd_message.set_name('IGF','IGF_SL_NOT_PRC_RECEIPT_DOC');

Line 1967: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

1963: RETURN;
1964: END IF;
1965:
1966: -- Check if destination school in XML file is present in our system or not.
1967: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1968: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main_response.debug','Checking destination entity id(' || l_get_cr_resp.dest_entity_id_txt || ')');
1969: END IF;
1970: IF NOT check_entityid(l_get_cr_resp.DEST_ENTITY_ID_TXT) THEN
1971: fnd_message.set_name('IGF','IGF_SL_COD_INV_DEST_ID');

Line 1968: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main_response.debug','Checking destination entity id(' || l_get_cr_resp.dest_entity_id_txt || ')');

1964: END IF;
1965:
1966: -- Check if destination school in XML file is present in our system or not.
1967: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1968: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main_response.debug','Checking destination entity id(' || l_get_cr_resp.dest_entity_id_txt || ')');
1969: END IF;
1970: IF NOT check_entityid(l_get_cr_resp.DEST_ENTITY_ID_TXT) THEN
1971: fnd_message.set_name('IGF','IGF_SL_COD_INV_DEST_ID');
1972: fnd_message.set_token('DEST_ENTITY_ID',l_get_cr_resp.DEST_ENTITY_ID_TXT);

Line 2430: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2426: ROLLBACK;
2427: retcode := 2;
2428: errbuf := fnd_message.get_string('IGS','IGS_GE_UNHANDLED_EXCEPTION');
2429: fnd_file.put_line(fnd_file.log, SQLERRM);
2430: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2431: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main_response.debug','sqlerrm ' || SQLERRM);
2432: END IF;
2433: igs_ge_msg_stack.conc_exception_hndl;
2434: END main_response;

Line 2431: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main_response.debug','sqlerrm ' || SQLERRM);

2427: retcode := 2;
2428: errbuf := fnd_message.get_string('IGS','IGS_GE_UNHANDLED_EXCEPTION');
2429: fnd_file.put_line(fnd_file.log, SQLERRM);
2430: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2431: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main_response.debug','sqlerrm ' || SQLERRM);
2432: END IF;
2433: igs_ge_msg_stack.conc_exception_hndl;
2434: END main_response;
2435:

Line 2504: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2500: ln_request_id NUMBER;
2501: l_doc_id VARCHAR2(30);
2502: BEGIN
2503: l_doc_id := wf_engine.GetItemAttrText(itemtype, itemkey, 'ECX_PARAMETER1');
2504: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2505: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.launch_request.debug','Document ID from ECX_PARAMETER1 is: ' || l_doc_id);
2506: END IF;
2507:
2508: ln_request_id := fnd_request.submit_request(

Line 2505: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.launch_request.debug','Document ID from ECX_PARAMETER1 is: ' || l_doc_id);

2501: l_doc_id VARCHAR2(30);
2502: BEGIN
2503: l_doc_id := wf_engine.GetItemAttrText(itemtype, itemkey, 'ECX_PARAMETER1');
2504: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2505: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.launch_request.debug','Document ID from ECX_PARAMETER1 is: ' || l_doc_id);
2506: END IF;
2507:
2508: ln_request_id := fnd_request.submit_request(
2509: 'IGF','IGFSLJ18','','', FALSE,

Line 2523: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2519: '','','','','','','','','','',
2520: '','','','','','','','','','');
2521: resultout := 'SUCCESS';
2522: COMMIT;
2523: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2524: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.launch_request.debug','sub process launched with id ' || ln_request_id);
2525: END IF;
2526: EXCEPTION
2527: WHEN OTHERS THEN

Line 2524: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.launch_request.debug','sub process launched with id ' || ln_request_id);

2520: '','','','','','','','','','');
2521: resultout := 'SUCCESS';
2522: COMMIT;
2523: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2524: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.launch_request.debug','sub process launched with id ' || ln_request_id);
2525: END IF;
2526: EXCEPTION
2527: WHEN OTHERS THEN
2528: resultout := 'F';

Line 2532: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2528: resultout := 'F';
2529: wf_core.context ('IGF_SL_UPLOAD_XML',
2530: 'LAUNCH_REQUEST', itemtype,
2531: itemkey,to_char(actid), funcmode);
2532: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2533: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.launch_request.debug','sqlerrm ' || SQLERRM);
2534: END IF;
2535: RETURN;
2536: END launch_request;

Line 2533: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.launch_request.debug','sqlerrm ' || SQLERRM);

2529: wf_core.context ('IGF_SL_UPLOAD_XML',
2530: 'LAUNCH_REQUEST', itemtype,
2531: itemkey,to_char(actid), funcmode);
2532: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2533: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.launch_request.debug','sqlerrm ' || SQLERRM);
2534: END IF;
2535: RETURN;
2536: END launch_request;
2537:

Line 2549: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2545: rec_cod_temp cur_cod_temp%ROWTYPE;
2546: IGFSL26_XMLGW_RS_REC_NOT_FOUND EXCEPTION;
2547: BEGIN
2548: -- write parameters in debug messages
2549: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2550: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.update_rs_respcode.debug', 'p_rec_id = ' || p_rec_id);
2551: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.update_rs_respcode.debug', 'p_resp_code = ' || p_resp_code);
2552: END IF;
2553:

Line 2550: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.update_rs_respcode.debug', 'p_rec_id = ' || p_rec_id);

2546: IGFSL26_XMLGW_RS_REC_NOT_FOUND EXCEPTION;
2547: BEGIN
2548: -- write parameters in debug messages
2549: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2550: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.update_rs_respcode.debug', 'p_rec_id = ' || p_rec_id);
2551: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.update_rs_respcode.debug', 'p_resp_code = ' || p_resp_code);
2552: END IF;
2553:
2554: -- check wether record with p_rec_id and LEVEL_CODE as RS exists or not.

Line 2551: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.update_rs_respcode.debug', 'p_resp_code = ' || p_resp_code);

2547: BEGIN
2548: -- write parameters in debug messages
2549: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2550: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.update_rs_respcode.debug', 'p_rec_id = ' || p_rec_id);
2551: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.update_rs_respcode.debug', 'p_resp_code = ' || p_resp_code);
2552: END IF;
2553:
2554: -- check wether record with p_rec_id and LEVEL_CODE as RS exists or not.
2555: OPEN cur_cod_temp(p_rec_id);

Line 2558: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2554: -- check wether record with p_rec_id and LEVEL_CODE as RS exists or not.
2555: OPEN cur_cod_temp(p_rec_id);
2556: FETCH cur_cod_temp INTO rec_cod_temp;
2557: IF cur_cod_temp%NOTFOUND THEN
2558: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2559: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.update_rs_respcode.debug', 'Record NOT found with p_rec_id ' || p_rec_id || ' and with level_code RS');
2560: END IF;
2561: RAISE IGFSL26_XMLGW_RS_REC_NOT_FOUND;
2562: ELSE

Line 2559: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.update_rs_respcode.debug', 'Record NOT found with p_rec_id ' || p_rec_id || ' and with level_code RS');

2555: OPEN cur_cod_temp(p_rec_id);
2556: FETCH cur_cod_temp INTO rec_cod_temp;
2557: IF cur_cod_temp%NOTFOUND THEN
2558: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2559: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.update_rs_respcode.debug', 'Record NOT found with p_rec_id ' || p_rec_id || ' and with level_code RS');
2560: END IF;
2561: RAISE IGFSL26_XMLGW_RS_REC_NOT_FOUND;
2562: ELSE
2563: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 2563: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2559: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.update_rs_respcode.debug', 'Record NOT found with p_rec_id ' || p_rec_id || ' and with level_code RS');
2560: END IF;
2561: RAISE IGFSL26_XMLGW_RS_REC_NOT_FOUND;
2562: ELSE
2563: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2564: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.update_rs_respcode.debug', 'Record has been found with p_rec_id ' || p_rec_id);
2565: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.update_rs_respcode.debug', 'REC_ID = ' || rec_cod_temp.REC_ID);
2566: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.update_rs_respcode.debug', 'LEVEL_CODE = ' || rec_cod_temp.LEVEL_CODE);
2567: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.update_rs_respcode.debug', 'RESP_CODE = ' || rec_cod_temp.RESP_CODE);

Line 2564: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.update_rs_respcode.debug', 'Record has been found with p_rec_id ' || p_rec_id);

2560: END IF;
2561: RAISE IGFSL26_XMLGW_RS_REC_NOT_FOUND;
2562: ELSE
2563: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2564: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.update_rs_respcode.debug', 'Record has been found with p_rec_id ' || p_rec_id);
2565: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.update_rs_respcode.debug', 'REC_ID = ' || rec_cod_temp.REC_ID);
2566: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.update_rs_respcode.debug', 'LEVEL_CODE = ' || rec_cod_temp.LEVEL_CODE);
2567: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.update_rs_respcode.debug', 'RESP_CODE = ' || rec_cod_temp.RESP_CODE);
2568: END IF;

Line 2565: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.update_rs_respcode.debug', 'REC_ID = ' || rec_cod_temp.REC_ID);

2561: RAISE IGFSL26_XMLGW_RS_REC_NOT_FOUND;
2562: ELSE
2563: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2564: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.update_rs_respcode.debug', 'Record has been found with p_rec_id ' || p_rec_id);
2565: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.update_rs_respcode.debug', 'REC_ID = ' || rec_cod_temp.REC_ID);
2566: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.update_rs_respcode.debug', 'LEVEL_CODE = ' || rec_cod_temp.LEVEL_CODE);
2567: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.update_rs_respcode.debug', 'RESP_CODE = ' || rec_cod_temp.RESP_CODE);
2568: END IF;
2569: END IF;

Line 2566: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.update_rs_respcode.debug', 'LEVEL_CODE = ' || rec_cod_temp.LEVEL_CODE);

2562: ELSE
2563: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2564: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.update_rs_respcode.debug', 'Record has been found with p_rec_id ' || p_rec_id);
2565: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.update_rs_respcode.debug', 'REC_ID = ' || rec_cod_temp.REC_ID);
2566: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.update_rs_respcode.debug', 'LEVEL_CODE = ' || rec_cod_temp.LEVEL_CODE);
2567: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.update_rs_respcode.debug', 'RESP_CODE = ' || rec_cod_temp.RESP_CODE);
2568: END IF;
2569: END IF;
2570: CLOSE cur_cod_temp;

Line 2567: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.update_rs_respcode.debug', 'RESP_CODE = ' || rec_cod_temp.RESP_CODE);

2563: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2564: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.update_rs_respcode.debug', 'Record has been found with p_rec_id ' || p_rec_id);
2565: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.update_rs_respcode.debug', 'REC_ID = ' || rec_cod_temp.REC_ID);
2566: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.update_rs_respcode.debug', 'LEVEL_CODE = ' || rec_cod_temp.LEVEL_CODE);
2567: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.update_rs_respcode.debug', 'RESP_CODE = ' || rec_cod_temp.RESP_CODE);
2568: END IF;
2569: END IF;
2570: CLOSE cur_cod_temp;
2571:

Line 2584: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2580: -- print the record in debug messages.
2581: OPEN cur_cod_temp(p_rec_id);
2582: FETCH cur_cod_temp INTO rec_cod_temp;
2583: IF cur_cod_temp%NOTFOUND THEN
2584: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2585: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.update_rs_respcode.debug', 'After update, Record NOT found with p_rec_id ' || p_rec_id || ' and with level_code RS');
2586: END IF;
2587: RAISE IGFSL26_XMLGW_RS_REC_NOT_FOUND;
2588: ELSE

Line 2585: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.update_rs_respcode.debug', 'After update, Record NOT found with p_rec_id ' || p_rec_id || ' and with level_code RS');

2581: OPEN cur_cod_temp(p_rec_id);
2582: FETCH cur_cod_temp INTO rec_cod_temp;
2583: IF cur_cod_temp%NOTFOUND THEN
2584: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2585: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.update_rs_respcode.debug', 'After update, Record NOT found with p_rec_id ' || p_rec_id || ' and with level_code RS');
2586: END IF;
2587: RAISE IGFSL26_XMLGW_RS_REC_NOT_FOUND;
2588: ELSE
2589: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 2589: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2585: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.update_rs_respcode.debug', 'After update, Record NOT found with p_rec_id ' || p_rec_id || ' and with level_code RS');
2586: END IF;
2587: RAISE IGFSL26_XMLGW_RS_REC_NOT_FOUND;
2588: ELSE
2589: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2590: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.update_rs_respcode.debug', 'After update, Record has been found with p_rec_id ' || p_rec_id);
2591: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.update_rs_respcode.debug', 'After update, REC_ID = ' || rec_cod_temp.REC_ID);
2592: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.update_rs_respcode.debug', 'After update, LEVEL_CODE = ' || rec_cod_temp.LEVEL_CODE);
2593: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.update_rs_respcode.debug', 'After update, RESP_CODE = ' || rec_cod_temp.RESP_CODE);

Line 2590: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.update_rs_respcode.debug', 'After update, Record has been found with p_rec_id ' || p_rec_id);

2586: END IF;
2587: RAISE IGFSL26_XMLGW_RS_REC_NOT_FOUND;
2588: ELSE
2589: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2590: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.update_rs_respcode.debug', 'After update, Record has been found with p_rec_id ' || p_rec_id);
2591: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.update_rs_respcode.debug', 'After update, REC_ID = ' || rec_cod_temp.REC_ID);
2592: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.update_rs_respcode.debug', 'After update, LEVEL_CODE = ' || rec_cod_temp.LEVEL_CODE);
2593: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.update_rs_respcode.debug', 'After update, RESP_CODE = ' || rec_cod_temp.RESP_CODE);
2594: END IF;

Line 2591: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.update_rs_respcode.debug', 'After update, REC_ID = ' || rec_cod_temp.REC_ID);

2587: RAISE IGFSL26_XMLGW_RS_REC_NOT_FOUND;
2588: ELSE
2589: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2590: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.update_rs_respcode.debug', 'After update, Record has been found with p_rec_id ' || p_rec_id);
2591: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.update_rs_respcode.debug', 'After update, REC_ID = ' || rec_cod_temp.REC_ID);
2592: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.update_rs_respcode.debug', 'After update, LEVEL_CODE = ' || rec_cod_temp.LEVEL_CODE);
2593: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.update_rs_respcode.debug', 'After update, RESP_CODE = ' || rec_cod_temp.RESP_CODE);
2594: END IF;
2595: END IF;

Line 2592: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.update_rs_respcode.debug', 'After update, LEVEL_CODE = ' || rec_cod_temp.LEVEL_CODE);

2588: ELSE
2589: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2590: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.update_rs_respcode.debug', 'After update, Record has been found with p_rec_id ' || p_rec_id);
2591: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.update_rs_respcode.debug', 'After update, REC_ID = ' || rec_cod_temp.REC_ID);
2592: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.update_rs_respcode.debug', 'After update, LEVEL_CODE = ' || rec_cod_temp.LEVEL_CODE);
2593: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.update_rs_respcode.debug', 'After update, RESP_CODE = ' || rec_cod_temp.RESP_CODE);
2594: END IF;
2595: END IF;
2596: CLOSE cur_cod_temp;

Line 2593: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.update_rs_respcode.debug', 'After update, RESP_CODE = ' || rec_cod_temp.RESP_CODE);

2589: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2590: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.update_rs_respcode.debug', 'After update, Record has been found with p_rec_id ' || p_rec_id);
2591: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.update_rs_respcode.debug', 'After update, REC_ID = ' || rec_cod_temp.REC_ID);
2592: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.update_rs_respcode.debug', 'After update, LEVEL_CODE = ' || rec_cod_temp.LEVEL_CODE);
2593: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.update_rs_respcode.debug', 'After update, RESP_CODE = ' || rec_cod_temp.RESP_CODE);
2594: END IF;
2595: END IF;
2596: CLOSE cur_cod_temp;
2597: EXCEPTION