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_COD_DOC_DTLS

Line 15: It will also insert the document in the igf_sl_cod_doc_dtls table.

11: upload_xml()
12: This process is called from the workflow to convert the file passed to a CLOB
13: parameter and will set the ECX_EVENT_MESSAGE attribute of the workflow.
14: It will also find the and set it as the parameter ECX_PARAMETER2.
15: It will also insert the document in the igf_sl_cod_doc_dtls table.
16:
17: set_nls_fmt()
18: This process is called from the IGF_SL_INBOUND.xgm for setting the NLS Format
19:

Line 43: FROM IGF_SL_COD_DOC_DTLS a

39: -----------------------------------------------------------*/
40:
41: CURSOR chk_doc ( cp_doc_id VARCHAR2) IS
42: SELECT ROWID row_id, a.*
43: FROM IGF_SL_COD_DOC_DTLS a
44: WHERE document_id_txt = cp_doc_id;
45:
46: g_doc_id VARCHAR2(30);
47: g_process_date DATE;

Line 53: igf_sl_cod_doc_dtls_pkg.update_row (

49: PROCEDURE update_xml_document(l_chk_doc chk_doc%ROWTYPE, p_doc_status VARCHAR2)
50: IS
51: PRAGMA AUTONOMOUS_TRANSACTION;
52: BEGIN
53: igf_sl_cod_doc_dtls_pkg.update_row (
54: x_rowid => l_chk_doc.row_id,
55: x_document_id_txt => l_chk_doc.document_id_txt,
56: x_outbound_doc => l_chk_doc.outbound_doc ,
57: x_inbound_doc => l_chk_doc.inbound_doc ,

Line 184: FROM IGF_SL_COD_DOC_DTLS docdtls

180: )
181: AS
182: CURSOR get_doc ( cp_doc_id VARCHAR2) IS
183: SELECT ROWID ROW_ID, docdtls.*
184: FROM IGF_SL_COD_DOC_DTLS docdtls
185: WHERE DOCUMENT_ID_TXT = cp_doc_id;
186: l_get_doc get_doc%ROWTYPE;
187:
188: CURSOR get_event_key IS

Line 373: -- Insert/Update the IGF_SL_COD_DOC_DTLS TABLE

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
374: l_get_doc := NULL;
375: OPEN get_doc(l_doc_id);
376: FETCH get_doc INTO l_get_doc;
377: CLOSE get_doc;

Line 382: igf_sl_cod_doc_dtls_pkg.add_row (

378:
379: IF l_get_doc.ROW_ID IS NULL THEN
380: l_get_doc.doc_type := 'COD';
381: END IF;
382: igf_sl_cod_doc_dtls_pkg.add_row (
383: x_mode => 'R',
384: x_rowid => l_get_doc.ROW_ID,
385: x_document_id_txt => l_doc_id,
386: x_outbound_doc => l_get_doc.outbound_doc,

Line 491: SELECT INBOUND_DOC INTO xmldoc FROM igf_sl_cod_doc_dtls WHERE DOCUMENT_ID_TXT = l_doc_id;

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;
493:
494: new_xml_len := DBMS_LOB.GETLENGTH(newxmldoc);
495: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 492: SELECT INBOUND_DOC INTO newxmldoc FROM igf_sl_cod_doc_dtls WHERE DOCUMENT_ID_TXT = l_doc_id FOR UPDATE;

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

Line 1975: -- update the IGF_SL_COD_DOC_DTLS table with the status = 'E'

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);
1973: fnd_file.put_line(fnd_file.log,fnd_message.get);
1974:
1975: -- update the IGF_SL_COD_DOC_DTLS table with the status = 'E'
1976: update_xml_document(l_chk_doc, 'E');
1977: -- delete data from resp tables as well as from temp table(IGF_SL_COD_TEMP)
1978: rollback_resp_tables();
1979: RETURN;

Line 1988: -- update the IGF_SL_COD_DOC_DTLS table with the status = 'F';

1984: IF l_get_cr_resp.FULL_RESP_CODE NOT IN ('F','S','M','N') THEN
1985: fnd_message.set_name('IGF','IGF_SL_COD_INV_RES_CODE');
1986: fnd_file.put_line(fnd_file.log,fnd_message.get);
1987:
1988: -- update the IGF_SL_COD_DOC_DTLS table with the status = 'F';
1989: update_xml_document(l_chk_doc, 'F');
1990: -- delete data from resp tables as well as from temp table(IGF_SL_COD_TEMP)
1991: rollback_resp_tables();
1992: RETURN;

Line 2007: -- update the IGF_SL_COD_DOC_DTLS table with the status = 'J';

2003: l_doc_rej_flg := FALSE;
2004: IF l_get_cr_resp.DOC_STATUS_CODE = 'R' THEN
2005: l_doc_rej_flg := TRUE;
2006:
2007: -- update the IGF_SL_COD_DOC_DTLS table with the status = 'J';
2008: -- do not return from here as there would be child level rejects
2009: igf_sl_cod_doc_dtls_pkg.update_row (
2010: x_rowid => l_chk_doc.row_id,
2011: x_document_id_txt => l_chk_doc.document_id_txt,

Line 2009: igf_sl_cod_doc_dtls_pkg.update_row (

2005: l_doc_rej_flg := TRUE;
2006:
2007: -- update the IGF_SL_COD_DOC_DTLS table with the status = 'J';
2008: -- do not return from here as there would be child level rejects
2009: igf_sl_cod_doc_dtls_pkg.update_row (
2010: x_rowid => l_chk_doc.row_id,
2011: x_document_id_txt => l_chk_doc.document_id_txt,
2012: x_outbound_doc => l_chk_doc.outbound_doc ,
2013: x_inbound_doc => l_chk_doc.inbound_doc ,