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_DL_GEN_XML dependencies on IGF_SL_DL_GEN_XML_S

Line 1033: CURSOR cur_sequence IS SELECT IGF_SL_DL_GEN_XML_S.NEXTVAL FROM DUAL;

1029: l_map_code VARCHAR2(255);
1030: l_param_1 VARCHAR2(255);
1031: lv_role fnd_user.user_name%TYPE;
1032:
1033: CURSOR cur_sequence IS SELECT IGF_SL_DL_GEN_XML_S.NEXTVAL FROM DUAL;
1034:
1035: BEGIN
1036:
1037: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 1038: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.submit_xml_event','p_document id: '||p_document_id_txt);

1034:
1035: BEGIN
1036:
1037: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1038: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.submit_xml_event','p_document id: '||p_document_id_txt);
1039: END IF;
1040:
1041: l_parameter_list := wf_parameter_list_t();
1042: l_event_name := 'oracle.apps.igf.sl.genxml';

Line 1052: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.submit_xml_event','l_event_key : '||l_event_key);

1048: FETCH cur_sequence INTO l_event_key;
1049: CLOSE cur_sequence;
1050:
1051: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1052: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.submit_xml_event','l_event_key : '||l_event_key);
1053: END IF;
1054:
1055: -- Now add the parameters to the list to be passed to the workflow
1056:

Line 1099: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.submit_xml_event','raised event ');

1095: fnd_file.put_line(fnd_file.log,fnd_message.get);
1096: fnd_file.new_line(fnd_file.log,1);
1097:
1098: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1099: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.submit_xml_event','raised event ');
1100: END IF;
1101:
1102: EXCEPTION
1103: WHEN OTHERS THEN

Line 1105: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_dl_gen_xml.submit_xml_event.exception','Exception:'||SQLERRM);

1101:
1102: EXCEPTION
1103: WHEN OTHERS THEN
1104: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1105: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_dl_gen_xml.submit_xml_event.exception','Exception:'||SQLERRM);
1106: END IF;
1107: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1108: fnd_message.set_token('NAME','IGF_SL_DL_GEN_XML.SUBMIT_XML_EVENT');
1109: igs_ge_msg_stack.add;

Line 1108: fnd_message.set_token('NAME','IGF_SL_DL_GEN_XML.SUBMIT_XML_EVENT');

1104: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1105: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_dl_gen_xml.submit_xml_event.exception','Exception:'||SQLERRM);
1106: END IF;
1107: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1108: fnd_message.set_token('NAME','IGF_SL_DL_GEN_XML.SUBMIT_XML_EVENT');
1109: igs_ge_msg_stack.add;
1110: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1111: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.submit_xml_event.debug','sqlerrm ' || SQLERRM);
1112: END IF;

Line 1111: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.submit_xml_event.debug','sqlerrm ' || SQLERRM);

1107: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1108: fnd_message.set_token('NAME','IGF_SL_DL_GEN_XML.SUBMIT_XML_EVENT');
1109: igs_ge_msg_stack.add;
1110: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1111: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.submit_xml_event.debug','sqlerrm ' || SQLERRM);
1112: END IF;
1113: app_exception.raise_exception;
1114: END submit_xml_event;
1115:

Line 2045: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.store_xml.debug',' before reading lob ');

2041: -- 2. Push xml into table
2042: -- 3. Launch Concurrent Request
2043: --
2044: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2045: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.store_xml.debug',' before reading lob ');
2046: END IF;
2047: l_event := wf_engine.getitemattrevent(
2048: itemtype,
2049: itemkey,

Line 2053: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.store_xml.debug',' after reading lob ');

2049: itemkey,
2050: 'ECX_EVENT_MESSAGE');
2051:
2052: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2053: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.store_xml.debug',' after reading lob ');
2054: END IF;
2055: l_clob := l_event.geteventdata;
2056:
2057: IF DBMS_LOB.GETLENGTH(l_clob) = 0 THEN

Line 2062: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.store_xml.debug',' get doc id ');

2058: resultout := 'EMPTY_CLOB';
2059: ELSE
2060:
2061: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2062: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.store_xml.debug',' get doc id ');
2063: END IF;
2064: lv_document_id_txt := NULL;
2065: lv_document_id_txt := wf_engine.getitemattrtext(
2066: itemtype,

Line 2070: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.store_xml.debug',' get doc id = ' || lv_document_id_txt);

2066: itemtype,
2067: itemkey,
2068: 'ECX_PARAMETER1');
2069: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2070: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.store_xml.debug',' get doc id = ' || lv_document_id_txt);
2071: END IF;
2072:
2073: IF lv_document_id_txt IS NULL THEN
2074: resultout := 'DOCUMENT_ID_NOT_FOUND';

Line 2078: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.store_xml.debug',' insert into doc dtls ');

2074: resultout := 'DOCUMENT_ID_NOT_FOUND';
2075: ELSE
2076: lv_rowid := NULL;
2077: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2078: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.store_xml.debug',' insert into doc dtls ');
2079: END IF;
2080:
2081: igf_sl_cod_doc_dtls_pkg.insert_row(
2082: x_rowid => lv_rowid,

Line 2094: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.store_xml.debug',' before submitting req ');

2090: x_full_resp_code => NULL,
2091: x_mode => 'R');
2092:
2093: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2094: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.store_xml.debug',' before submitting req ');
2095: END IF;
2096:
2097: ln_request_id := apps.fnd_request.submit_request(
2098: 'IGF','IGFSLJ19','','',FALSE,

Line 2113: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.store_xml.debug',' request id ' || ln_request_id);

2109: '','','','','','','','','','');
2110:
2111:
2112: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2113: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.store_xml.debug',' request id ' || ln_request_id);
2114: END IF;
2115:
2116: IF ln_request_id = 0 THEN
2117: resultout := 'CONCURRENT_REQUEST_FAILED';

Line 2131: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.store_xml.debug','sqlerrm ' || SQLERRM);

2127: wf_core.context ('IGF_SL_DL_GEN_XML',
2128: 'STORE_XML', itemtype,
2129: itemkey,to_char(actid), funcmode);
2130: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2131: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.store_xml.debug','sqlerrm ' || SQLERRM);
2132: END IF;
2133: END store_xml;
2134:
2135: END igf_sl_dl_gen_xml;