APPS.IGF_GR_GEN_XML dependencies on FND_LOG

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

1109: x_rep_entity_id_txt => p_rfms_rec.rep_entity_id_txt,
1110: x_atd_entity_id_txt => p_rfms_rec.atd_entity_id_txt,
1111: x_mode => 'R');
1112:
1113: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1114: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_gen_xml.insert_into_cod_tables.debug','after inserting cod db dtls seq num, disb num, award id' || rec.disb_seq_num || ' , ' || rec.disb_num || ' , ' || rec.award_id);
1115: END IF;
1116: END LOOP;
1117: EXCEPTION

Line 1114: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_gen_xml.insert_into_cod_tables.debug','after inserting cod db dtls seq num, disb num, award id' || rec.disb_seq_num || ' , ' || rec.disb_num || ' , ' || rec.award_id);

1110: x_atd_entity_id_txt => p_rfms_rec.atd_entity_id_txt,
1111: x_mode => 'R');
1112:
1113: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1114: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_gen_xml.insert_into_cod_tables.debug','after inserting cod db dtls seq num, disb num, award id' || rec.disb_seq_num || ' , ' || rec.disb_num || ' , ' || rec.award_id);
1115: END IF;
1116: END LOOP;
1117: EXCEPTION
1118: WHEN OTHERS THEN

Line 1284: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

1280: IF (l_return_status = 'E') THEN
1281: fnd_file.put_line(fnd_file.log, l_return_mesg_text);
1282: RETURN;
1283: ELSE
1284: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1285: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_gr_gen_xml.process_rfms_record.debug','l_pell_amt = ' || l_pell_amt || 'and l_ft_pell_amt = ' || l_ft_pell_amt);
1286: END IF;
1287: IF p_rfms_rec.pell_amount > l_ft_pell_amt THEN
1288: fnd_message.set_name('IGF','IGF_GR_LIMIT_EXC');

Line 1285: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_gr_gen_xml.process_rfms_record.debug','l_pell_amt = ' || l_pell_amt || 'and l_ft_pell_amt = ' || l_ft_pell_amt);

1281: fnd_file.put_line(fnd_file.log, l_return_mesg_text);
1282: RETURN;
1283: ELSE
1284: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1285: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_gr_gen_xml.process_rfms_record.debug','l_pell_amt = ' || l_pell_amt || 'and l_ft_pell_amt = ' || l_ft_pell_amt);
1286: END IF;
1287: IF p_rfms_rec.pell_amount > l_ft_pell_amt THEN
1288: fnd_message.set_name('IGF','IGF_GR_LIMIT_EXC');
1289: fnd_message.set_token('PEL_AMT',l_ft_pell_amt);

Line 1318: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

1314: insert_into_cod_tables(p_rfms_rec, p_source_entity_id);
1315:
1316: EXCEPTION
1317: WHEN OTHERS THEN
1318: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1319: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_gr_gen_xml.process_rfms_record.exception','Exception:'||SQLERRM);
1320: END IF;
1321: fnd_message.set_name('IGF','IGF_GR_XML_INSERT_EXC');
1322: fnd_message.set_token('ORIGINATION_ID',p_rfms_rec.origination_id);

Line 1319: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_gr_gen_xml.process_rfms_record.exception','Exception:'||SQLERRM);

1315:
1316: EXCEPTION
1317: WHEN OTHERS THEN
1318: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1319: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_gr_gen_xml.process_rfms_record.exception','Exception:'||SQLERRM);
1320: END IF;
1321: fnd_message.set_name('IGF','IGF_GR_XML_INSERT_EXC');
1322: fnd_message.set_token('ORIGINATION_ID',p_rfms_rec.origination_id);
1323: fnd_file.put_line(fnd_file.log,fnd_message.get);

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

1350: CURSOR cur_sequence IS SELECT IGF_GR_PELL_GEN_XML_S.NEXTVAL FROM DUAL;
1351:
1352: BEGIN
1353:
1354: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1355: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_gen_xml.submit_xml_event','p_document id: '||p_document_id);
1356: END IF;
1357:
1358: l_parameter_list := wf_parameter_list_t();

Line 1355: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_gen_xml.submit_xml_event','p_document id: '||p_document_id);

1351:
1352: BEGIN
1353:
1354: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1355: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_gen_xml.submit_xml_event','p_document id: '||p_document_id);
1356: END IF;
1357:
1358: l_parameter_list := wf_parameter_list_t();
1359: l_event_name := 'oracle.apps.igf.gr.genxml';

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

1363: OPEN cur_sequence;
1364: FETCH cur_sequence INTO l_event_key;
1365: CLOSE cur_sequence;
1366:
1367: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1368: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_gen_xml.submit_xml_event','l_event_key : '||l_event_key);
1369: END IF;
1370:
1371: -- Now add the parameters to the list to be passed to the workflow

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

1364: FETCH cur_sequence INTO l_event_key;
1365: CLOSE cur_sequence;
1366:
1367: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1368: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_gen_xml.submit_xml_event','l_event_key : '||l_event_key);
1369: END IF;
1370:
1371: -- Now add the parameters to the list to be passed to the workflow
1372:

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

1401: fnd_message.set_token('EVENT_KEY_VALUE',l_event_key);
1402: fnd_file.put_line(fnd_file.log,fnd_message.get);
1403: fnd_file.new_line(fnd_file.log,1);
1404:
1405: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1406: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_gen_xml.submit_xml_event','raised event ');
1407: END IF;
1408:
1409: EXCEPTION

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

1402: fnd_file.put_line(fnd_file.log,fnd_message.get);
1403: fnd_file.new_line(fnd_file.log,1);
1404:
1405: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1406: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_gen_xml.submit_xml_event','raised event ');
1407: END IF;
1408:
1409: EXCEPTION
1410: WHEN OTHERS THEN

Line 1411: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

1407: END IF;
1408:
1409: EXCEPTION
1410: WHEN OTHERS THEN
1411: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1412: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_gr_gen_xml.submit_xml_event.exception','Exception:'||SQLERRM);
1413: END IF;
1414: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1415: fnd_message.set_token('NAME','IGF_GR_GEN_XML.SUBMIT_XML_EVENT');

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

1408:
1409: EXCEPTION
1410: WHEN OTHERS THEN
1411: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1412: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_gr_gen_xml.submit_xml_event.exception','Exception:'||SQLERRM);
1413: END IF;
1414: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1415: fnd_message.set_token('NAME','IGF_GR_GEN_XML.SUBMIT_XML_EVENT');
1416: igs_ge_msg_stack.add;

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

1554: END IF;
1555:
1556: FETCH cur_per_grp INTO l_person_id;
1557:
1558: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1559: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_gen_xml.main.debug','Starting to process person group '||p_persid_grp);
1560: END IF;
1561:
1562: IF cur_per_grp%NOTFOUND THEN

Line 1559: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_gen_xml.main.debug','Starting to process person group '||p_persid_grp);

1555:
1556: FETCH cur_per_grp INTO l_person_id;
1557:
1558: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1559: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_gen_xml.main.debug','Starting to process person group '||p_persid_grp);
1560: END IF;
1561:
1562: IF cur_per_grp%NOTFOUND THEN
1563: CLOSE cur_per_grp;

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

1562: IF cur_per_grp%NOTFOUND THEN
1563: CLOSE cur_per_grp;
1564: fnd_message.set_name('IGF','IGF_DB_NO_PER_GRP');
1565: fnd_file.put_line(fnd_file.log,fnd_message.get);
1566: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1567: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_gen_xml.main.debug','No persons in group '||p_persid_grp);
1568: END IF;
1569: ELSE
1570: IF cur_per_grp%FOUND THEN -- Check if the person exists in FA.

Line 1567: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_gen_xml.main.debug','No persons in group '||p_persid_grp);

1563: CLOSE cur_per_grp;
1564: fnd_message.set_name('IGF','IGF_DB_NO_PER_GRP');
1565: fnd_file.put_line(fnd_file.log,fnd_message.get);
1566: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1567: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_gen_xml.main.debug','No persons in group '||p_persid_grp);
1568: END IF;
1569: ELSE
1570: IF cur_per_grp%FOUND THEN -- Check if the person exists in FA.
1571: lb_record_exist := FALSE;

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

1601: fnd_message.set_name('IGF','IGF_GR_LI_PER_INVALID');
1602: fnd_message.set_token('PERSON_NUMBER',lv_person_number);
1603: fnd_message.set_token('AWD_YR',igf_gr_gen.get_alt_code(l_ci_cal_type,l_ci_sequence_number));
1604: fnd_file.put_line(fnd_file.log,fnd_message.get);
1605: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1606: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_gen_xml.main.debug',igf_gr_gen.get_per_num_oss(l_person_id) || ' not in FA');
1607: END IF;
1608: END IF; -- base id not found
1609: ELSE

Line 1606: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_gen_xml.main.debug',igf_gr_gen.get_per_num_oss(l_person_id) || ' not in FA');

1602: fnd_message.set_token('PERSON_NUMBER',lv_person_number);
1603: fnd_message.set_token('AWD_YR',igf_gr_gen.get_alt_code(l_ci_cal_type,l_ci_sequence_number));
1604: fnd_file.put_line(fnd_file.log,fnd_message.get);
1605: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1606: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_gen_xml.main.debug',igf_gr_gen.get_per_num_oss(l_person_id) || ' not in FA');
1607: END IF;
1608: END IF; -- base id not found
1609: ELSE
1610: fnd_message.set_name('IGF','IGF_AP_PE_NOT_EXIST');

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

1625: END IF;
1626:
1627: -- Processing when base_id and persond id groups are not given.
1628: IF p_base_id IS NULL AND p_persid_grp IS NULL THEN
1629: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1630: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_gen_xml.main.debug',' processing when base_id and person id groups are null');
1631: END IF;
1632:
1633: lb_record_exist := FALSE;

Line 1630: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_gen_xml.main.debug',' processing when base_id and person id groups are null');

1626:
1627: -- Processing when base_id and persond id groups are not given.
1628: IF p_base_id IS NULL AND p_persid_grp IS NULL THEN
1629: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1630: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_gen_xml.main.debug',' processing when base_id and person id groups are null');
1631: END IF;
1632:
1633: lb_record_exist := FALSE;
1634: FOR rec IN cur_rfms (l_ci_cal_type, l_ci_sequence_number, p_report_entity_id, p_attend_entity_id, p_base_id)

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

1650: OPEN cur_cod_dtls(gv_document_id_txt);
1651: FETCH cur_cod_dtls INTO cod_dtls_rec;
1652: CLOSE cur_cod_dtls;
1653:
1654: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1655: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_gen_xml.main.debug',' gv_document_id_txt ' || gv_document_id_txt);
1656: END IF;
1657:
1658: IF cod_dtls_rec.document_id_txt IS NULL THEN

Line 1655: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_gen_xml.main.debug',' gv_document_id_txt ' || gv_document_id_txt);

1651: FETCH cur_cod_dtls INTO cod_dtls_rec;
1652: CLOSE cur_cod_dtls;
1653:
1654: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1655: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_gen_xml.main.debug',' gv_document_id_txt ' || gv_document_id_txt);
1656: END IF;
1657:
1658: IF cod_dtls_rec.document_id_txt IS NULL THEN
1659: fnd_message.set_name('IGF','IGF_GR_COD_NO_REC');

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

1659: fnd_message.set_name('IGF','IGF_GR_COD_NO_REC');
1660: fnd_file.put_line(fnd_file.log,fnd_message.get);
1661: RETURN;
1662: ELSE
1663: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1664: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_gen_xml.main.debug',' before submit event ');
1665: END IF;
1666: submit_xml_event (gv_document_id_txt);
1667: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 1664: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_gen_xml.main.debug',' before submit event ');

1660: fnd_file.put_line(fnd_file.log,fnd_message.get);
1661: RETURN;
1662: ELSE
1663: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1664: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_gen_xml.main.debug',' before submit event ');
1665: END IF;
1666: submit_xml_event (gv_document_id_txt);
1667: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1668: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_gen_xml.main.debug',' after submit event ');

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

1663: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1664: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_gen_xml.main.debug',' before submit event ');
1665: END IF;
1666: submit_xml_event (gv_document_id_txt);
1667: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1668: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_gen_xml.main.debug',' after submit event ');
1669: END IF;
1670: END IF;
1671: -- End of Step 6.

Line 1668: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_gen_xml.main.debug',' after submit event ');

1664: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_gen_xml.main.debug',' before submit event ');
1665: END IF;
1666: submit_xml_event (gv_document_id_txt);
1667: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1668: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_gen_xml.main.debug',' after submit event ');
1669: END IF;
1670: END IF;
1671: -- End of Step 6.
1672:

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

1710: -- 2. Push xml into table
1711: -- 3. Launch Concurrent Request
1712: --
1713:
1714: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1715: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_gen_xml.store_xml.debug',' before reading lob ');
1716: END IF;
1717:
1718: l_event := wf_engine.getitemattrevent ( itemtype,

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

1711: -- 3. Launch Concurrent Request
1712: --
1713:
1714: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1715: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_gen_xml.store_xml.debug',' before reading lob ');
1716: END IF;
1717:
1718: l_event := wf_engine.getitemattrevent ( itemtype,
1719: itemkey,

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

1718: l_event := wf_engine.getitemattrevent ( itemtype,
1719: itemkey,
1720: 'ECX_EVENT_MESSAGE'
1721: );
1722: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1723: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_gen_xml.store_xml.debug',' after reading lob ');
1724: END IF;
1725:
1726: l_clob := l_event.geteventdata;

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

1719: itemkey,
1720: 'ECX_EVENT_MESSAGE'
1721: );
1722: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1723: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_gen_xml.store_xml.debug',' after reading lob ');
1724: END IF;
1725:
1726: l_clob := l_event.geteventdata;
1727:

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

1727:
1728: IF DBMS_LOB.GETLENGTH(l_clob) = 0 THEN
1729: resultout := 'EMPTY_CLOB';
1730: ELSE
1731: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1732: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_gen_xml.store_xml.debug',' get doc id ');
1733: END IF;
1734: lv_document_id := NULL;
1735: lv_document_id := wf_engine.getitemattrtext ( itemtype,

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

1728: IF DBMS_LOB.GETLENGTH(l_clob) = 0 THEN
1729: resultout := 'EMPTY_CLOB';
1730: ELSE
1731: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1732: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_gen_xml.store_xml.debug',' get doc id ');
1733: END IF;
1734: lv_document_id := NULL;
1735: lv_document_id := wf_engine.getitemattrtext ( itemtype,
1736: itemkey,

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

1735: lv_document_id := wf_engine.getitemattrtext ( itemtype,
1736: itemkey,
1737: 'ECX_PARAMETER1'
1738: );
1739: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1740: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_gen_xml.store_xml.debug',' get doc id = ' || lv_document_id);
1741: END IF;
1742:
1743: IF lv_document_id IS NULL THEN

Line 1740: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_gen_xml.store_xml.debug',' get doc id = ' || lv_document_id);

1736: itemkey,
1737: 'ECX_PARAMETER1'
1738: );
1739: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1740: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_gen_xml.store_xml.debug',' get doc id = ' || lv_document_id);
1741: END IF;
1742:
1743: IF lv_document_id IS NULL THEN
1744: resultout := 'DOCUMENT_ID_NOT_FOUND';

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

1743: IF lv_document_id IS NULL THEN
1744: resultout := 'DOCUMENT_ID_NOT_FOUND';
1745: ELSE
1746: lv_rowid := NULL;
1747: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1748: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_gen_xml.store_xml.debug',' insert into doc dtls ');
1749: END IF;
1750:
1751: igf_sl_cod_doc_dtls_pkg.insert_row(

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

1744: resultout := 'DOCUMENT_ID_NOT_FOUND';
1745: ELSE
1746: lv_rowid := NULL;
1747: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1748: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_gen_xml.store_xml.debug',' insert into doc dtls ');
1749: END IF;
1750:
1751: igf_sl_cod_doc_dtls_pkg.insert_row(
1752: x_rowid => lv_rowid,

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

1758: x_doc_status => 'R',
1759: x_doc_type => 'PELL',
1760: x_full_resp_code => NULL,
1761: x_mode => 'R');
1762: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1763: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_gen_xml.store_xml.debug',' before submitting req ');
1764: END IF;
1765:
1766: ln_request_id := apps.fnd_request.submit_request(

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

1759: x_doc_type => 'PELL',
1760: x_full_resp_code => NULL,
1761: x_mode => 'R');
1762: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1763: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_gen_xml.store_xml.debug',' before submitting req ');
1764: END IF;
1765:
1766: ln_request_id := apps.fnd_request.submit_request(
1767: 'IGF','IGFGRJ14','','',FALSE,

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

1776: '','','','','','','','','','',
1777: '','','','','','','','','','',
1778: '','','','','','','','','','');
1779:
1780: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1781: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_gen_xml.store_xml.debug',' request id ' || ln_request_id);
1782: END IF;
1783:
1784: IF ln_request_id = 0 THEN

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

1777: '','','','','','','','','','',
1778: '','','','','','','','','','');
1779:
1780: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1781: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_gen_xml.store_xml.debug',' request id ' || ln_request_id);
1782: END IF;
1783:
1784: IF ln_request_id = 0 THEN
1785: resultout := 'CONCURRENT_REQUEST_FAILED';

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

1798: itemkey,
1799: to_char(actid),
1800: funcmode
1801: );
1802: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1803: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_gen_xml.store_xml.debug','sqlerrm ' || SQLERRM);
1804: END IF;
1805: END store_xml;
1806:

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

1799: to_char(actid),
1800: funcmode
1801: );
1802: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1803: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_gen_xml.store_xml.debug','sqlerrm ' || SQLERRM);
1804: END IF;
1805: END store_xml;
1806:
1807: PROCEDURE update_status(p_document_id_txt VARCHAR2)

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

1844: l_return_mesg_text VARCHAR2(2000);
1845:
1846: BEGIN
1847:
1848: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1849: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_gen_xml.update_status.debug','First doc id ' || p_document_id_txt);
1850: END IF;
1851:
1852: FOR cod_rec IN cur_cod_orig(p_document_id_txt)

Line 1849: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_gen_xml.update_status.debug','First doc id ' || p_document_id_txt);

1845:
1846: BEGIN
1847:
1848: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1849: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_gen_xml.update_status.debug','First doc id ' || p_document_id_txt);
1850: END IF;
1851:
1852: FOR cod_rec IN cur_cod_orig(p_document_id_txt)
1853: LOOP

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

1950: END LOOP;
1951:
1952: EXCEPTION
1953: WHEN OTHERS THEN
1954: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1955: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_gr_gen_xml.update_status.exception','Exception:'||SQLERRM);
1956: END IF;
1957: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1958: fnd_message.set_token('NAME','IGF_GR_GEN_XML.UPDATE_STATUS');

Line 1955: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_gr_gen_xml.update_status.exception','Exception:'||SQLERRM);

1951:
1952: EXCEPTION
1953: WHEN OTHERS THEN
1954: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1955: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_gr_gen_xml.update_status.exception','Exception:'||SQLERRM);
1956: END IF;
1957: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1958: fnd_message.set_token('NAME','IGF_GR_GEN_XML.UPDATE_STATUS');
1959: igs_ge_msg_stack.add;

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

1998: -- 5. Update LOR_LOC table, DISB table for Status
1999: -- 5. Print CLOB on the output file
2000: --
2001: igf_aw_gen.set_org_id(NULL);
2002: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2003: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_gen_xml.print_xml.debug','p doc id ' || p_document_id);
2004: END IF;
2005:
2006: OPEN c_get_parameters;

Line 2003: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_gen_xml.print_xml.debug','p doc id ' || p_document_id);

1999: -- 5. Print CLOB on the output file
2000: --
2001: igf_aw_gen.set_org_id(NULL);
2002: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2003: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_gen_xml.print_xml.debug','p doc id ' || p_document_id);
2004: END IF;
2005:
2006: OPEN c_get_parameters;
2007: LOOP

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

2028:
2029: igf_sl_dl_gen_xml.edit_clob(p_document_id,lc_newxmldoc,lv_rowid);
2030:
2031: -- update the modified clob in DOC_DTLS table
2032: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2033: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_gen_xml.print_xml.debug','before updating status');
2034: END IF;
2035: igf_sl_cod_doc_dtls_pkg.update_row ( x_rowid => lv_rowid,
2036: x_document_id_txt => p_document_id,

Line 2033: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_gen_xml.print_xml.debug','before updating status');

2029: igf_sl_dl_gen_xml.edit_clob(p_document_id,lc_newxmldoc,lv_rowid);
2030:
2031: -- update the modified clob in DOC_DTLS table
2032: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2033: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_gen_xml.print_xml.debug','before updating status');
2034: END IF;
2035: igf_sl_cod_doc_dtls_pkg.update_row ( x_rowid => lv_rowid,
2036: x_document_id_txt => p_document_id,
2037: x_outbound_doc => lc_newxmldoc,

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

2047: -- update IGF_AW_DB_CHG_DTLS.DISB_STATUS to sent
2048: update_status(p_document_id);
2049:
2050: -- print out xml outfile
2051: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2052: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_gen_xml.print_xml.debug','before calling print_out_xml method');
2053: END IF;
2054: igf_sl_dl_gen_xml.print_out_xml(lc_newxmldoc);
2055:

Line 2052: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_gen_xml.print_xml.debug','before calling print_out_xml method');

2048: update_status(p_document_id);
2049:
2050: -- print out xml outfile
2051: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2052: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_gen_xml.print_xml.debug','before calling print_out_xml method');
2053: END IF;
2054: igf_sl_dl_gen_xml.print_out_xml(lc_newxmldoc);
2055:
2056: COMMIT;

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

2059: ROLLBACK;
2060: retcode := 2;
2061: errbuf := fnd_message.get_string('IGS','IGS_GE_UNHANDLED_EXCEPTION');
2062: fnd_file.put_line(fnd_file.log,SQLERRM);
2063: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2064: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_gen_xml.print_xml.debug','OTHERS exception raised in print_xml: ' || SQLERRM);
2065: END IF;
2066: igs_ge_msg_stack.conc_exception_hndl;
2067: END print_xml;

Line 2064: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_gen_xml.print_xml.debug','OTHERS exception raised in print_xml: ' || SQLERRM);

2060: retcode := 2;
2061: errbuf := fnd_message.get_string('IGS','IGS_GE_UNHANDLED_EXCEPTION');
2062: fnd_file.put_line(fnd_file.log,SQLERRM);
2063: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2064: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_gen_xml.print_xml.debug','OTHERS exception raised in print_xml: ' || SQLERRM);
2065: END IF;
2066: igs_ge_msg_stack.conc_exception_hndl;
2067: END print_xml;
2068: