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 IGF_SL_UPLOAD_XML

Line 1: PACKAGE BODY igf_sl_upload_xml AS

1: PACKAGE BODY igf_sl_upload_xml AS
2: /* $Header: IGFSL26B.pls 120.13 2006/04/20 00:57:44 ugummall noship $ */
3:
4: /*----------PROCESS FLOW--------------------------------------
5:

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 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 165: fnd_message.set_token('NAME','igf_sl_upload_xml.check_entityid');

161:
162: EXCEPTION
163: WHEN others THEN
164: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
165: fnd_message.set_token('NAME','igf_sl_upload_xml.check_entityid');
166: igs_ge_msg_stack.add;
167: app_exception.raise_exception;
168: END check_entityid;
169: /* -----------------------------------------------------------------------------------

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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 548: wf_core.context ('IGF_SL_UPLOAD_XML',

544:
545: EXCEPTION
546: WHEN OTHERS 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);

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 594: fnd_message.set_token('NAME','igf_sl_upload_xml.print_edits');

590:
591: EXCEPTION
592: WHEN OTHERS THEN
593: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
594: fnd_message.set_token('NAME','igf_sl_upload_xml.print_edits');
595: igs_ge_msg_stack.add;
596: app_exception.raise_exception;
597: END print_edits;
598:

Line 1360: fnd_message.set_token('NAME','igf_sl_upload_xml.process_dl_records');

1356:
1357: EXCEPTION
1358: WHEN OTHERS THEN
1359: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1360: fnd_message.set_token('NAME','igf_sl_upload_xml.process_dl_records');
1361: igs_ge_msg_stack.add;
1362: app_exception.raise_exception;
1363: END process_dl_records;
1364:

Line 1733: fnd_message.set_token('NAME','igf_sl_upload_xml.process_pell_records');

1729:
1730: EXCEPTION
1731: WHEN OTHERS THEN
1732: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1733: fnd_message.set_token('NAME','igf_sl_upload_xml.process_pell_records');
1734: igs_ge_msg_stack.add;
1735: app_exception.raise_exception;
1736: END process_pell_records;
1737:

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 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 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 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 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 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 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 2529: wf_core.context ('IGF_SL_UPLOAD_XML',

2525: END IF;
2526: EXCEPTION
2527: WHEN OTHERS 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);

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

Line 2600: fnd_message.set_token('NAME','igf_sl_upload_xml.update_rs_respcode');

2596: CLOSE cur_cod_temp;
2597: EXCEPTION
2598: WHEN IGFSL26_XMLGW_RS_REC_NOT_FOUND THEN
2599: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2600: fnd_message.set_token('NAME','igf_sl_upload_xml.update_rs_respcode');
2601: igs_ge_msg_stack.add;
2602: app_exception.raise_exception;
2603: WHEN OTHERS THEN
2604: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

Line 2605: fnd_message.set_token('NAME','igf_sl_upload_xml.update_rs_respcode');

2601: igs_ge_msg_stack.add;
2602: app_exception.raise_exception;
2603: WHEN OTHERS THEN
2604: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2605: fnd_message.set_token('NAME','igf_sl_upload_xml.update_rs_respcode');
2606: igs_ge_msg_stack.add;
2607: app_exception.raise_exception;
2608: END update_rs_respcode;
2609:

Line 2624: END igf_sl_upload_xml;

2620: WHERE DOCUMENT_ID_TXT = p_doc_id;
2621:
2622: END;
2623:
2624: END igf_sl_upload_xml;