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_GR_GEN_XML dependencies on IGF_GR_GEN

Line 1: PACKAGE BODY IGF_GR_GEN_XML AS

1: PACKAGE BODY IGF_GR_GEN_XML AS
2: /* $Header: IGFGR12B.pls 120.13 2006/04/24 00:22:15 rajagupt noship $ */
3: /*************************************************************
4: Process Flow
5: main()

Line 110: fnd_message.set_token('NAME','IGF_GR_GEN_XML.GET_GRP_NAME');

106: RETURN get_grp_name_rec.group_cd;
107: EXCEPTION
108: WHEN OTHERS THEN
109: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
110: fnd_message.set_token('NAME','IGF_GR_GEN_XML.GET_GRP_NAME');
111: igs_ge_msg_stack.add;
112: app_exception.raise_exception;
113: END get_grp_name;
114:

Line 152: fnd_message.set_token('NAME','IGF_GR_GEN_XML.CHECK_FA_REC');

148: END IF;
149: EXCEPTION
150: WHEN OTHERS THEN
151: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
152: fnd_message.set_token('NAME','IGF_GR_GEN_XML.CHECK_FA_REC');
153: igs_ge_msg_stack.add;
154: app_exception.raise_exception;
155: END check_fa_rec;
156:

Line 209: fnd_message.set_token('NAME','IGF_GR_GEN_XML.PER_IN_FA');

205:
206: EXCEPTION
207: WHEN OTHERS THEN
208: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
209: fnd_message.set_token('NAME','IGF_GR_GEN_XML.PER_IN_FA');
210: igs_ge_msg_stack.add;
211: app_exception.raise_exception;
212: END per_in_fa;
213:

Line 257: RPAD(igf_gr_gen.get_alt_code(l_ci_cal_type,l_ci_sequence_number),20);

253: l_ci_sequence_number := NVL(TO_NUMBER(SUBSTR(p_award_year,11)),0);
254:
255: -- show award year
256: l_msg_str_1 := RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','AWARD_YEAR'),30) ||
257: RPAD(igf_gr_gen.get_alt_code(l_ci_cal_type,l_ci_sequence_number),20);
258: fnd_file.put_line(fnd_file.log,l_msg_str_1);
259:
260: -- show source entity id
261: l_msg_str_2 := RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS', 'SOURCE_ENTITY_ID'),30) || p_source_entity_id;

Line 279: RPAD(igf_gr_gen.get_per_num(p_base_id),20);

275:
276: -- show person number
277: IF (p_base_id IS NOT NULL) THEN
278: l_msg_str_5 := RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','BASE_ID'),30) ||
279: RPAD(igf_gr_gen.get_per_num(p_base_id),20);
280: fnd_file.put_line(fnd_file.log,l_msg_str_5);
281: END IF;
282:
283: -- show persond id group

Line 295: fnd_message.set_token('NAME','IGF_GR_GEN_XML.LOG_INPUT_PARAMETERS');

291:
292: EXCEPTION
293: WHEN OTHERS THEN
294: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
295: fnd_message.set_token('NAME','IGF_GR_GEN_XML.LOG_INPUT_PARAMETERS');
296: igs_ge_msg_stack.add;
297: app_exception.raise_exception;
298: END log_input_parameters;
299:

Line 548: fnd_message.set_token('PERSON_NUMBER', igf_gr_gen.get_per_num(p_base_id));

544: IF cur_person_number%NOTFOUND THEN
545: -- no pell origination records for this person.
546: l_params_status := FALSE;
547: fnd_message.set_name('IGF', 'IGF_GR_COD_NO_ORIG_REC');
548: fnd_message.set_token('PERSON_NUMBER', igf_gr_gen.get_per_num(p_base_id));
549: fnd_file.put_line(fnd_file.log, fnd_message.get);
550: fnd_file.new_line(fnd_file.log, 1);
551: END IF;
552: CLOSE cur_person_number;

Line 575: fnd_message.set_token('NAME','IGF_GR_GEN_XML.VALIDATE_INPUT_PARAMETERS');

571:
572: EXCEPTION
573: WHEN OTHERS THEN
574: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
575: fnd_message.set_token('NAME','IGF_GR_GEN_XML.VALIDATE_INPUT_PARAMETERS');
576: igs_ge_msg_stack.add;
577: app_exception.raise_exception;
578: END validate_input_parameters;
579:

Line 626: igf_sl_gen.get_person_details(igf_gr_gen.get_person_id(p_rfms_rec.base_id),student_dtl_cur);

622:
623: BEGIN
624:
625: -- Use the igf_sl_gen.get_person_details for getting the student
626: igf_sl_gen.get_person_details(igf_gr_gen.get_person_id(p_rfms_rec.base_id),student_dtl_cur);
627: FETCH student_dtl_cur INTO student_dtl_rec;
628:
629: CLOSE student_dtl_cur;
630:

Line 902: fnd_message.set_token('NAME','IGF_GR_GEN_XML.XML_BOUNDARY_VALIDATE');

898:
899: EXCEPTION
900: WHEN OTHERS THEN
901: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
902: fnd_message.set_token('NAME','IGF_GR_GEN_XML.XML_BOUNDARY_VALIDATE');
903: igs_ge_msg_stack.add;
904: app_exception.raise_exception;
905: END xml_boundary_validate;
906:

Line 974: igf_sl_gen.get_person_details(igf_gr_gen.get_person_id(p_rfms_rec.base_id),student_dtl_cur);

970:
971: BEGIN
972:
973: -- Use the igf_sl_gen.get_person_details for getting the student
974: igf_sl_gen.get_person_details(igf_gr_gen.get_person_id(p_rfms_rec.base_id),student_dtl_cur);
975: FETCH student_dtl_cur INTO student_dtl_rec;
976: CLOSE student_dtl_cur;
977:
978: --akomurav

Line 1023: l_s_phone := igf_sl_gen.get_person_phone(igf_gr_gen.get_person_id(p_rfms_rec.base_id));

1019: CLOSE cur_get_chg_data;
1020: END IF;
1021: --akomurav
1022:
1023: l_s_phone := igf_sl_gen.get_person_phone(igf_gr_gen.get_person_id(p_rfms_rec.base_id));
1024:
1025: IF l_s_phone = 'N/A' then
1026: l_s_phone := NULL;
1027: END IF;

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 1120: fnd_message.set_token('NAME','IGF_GR_GEN_XML.INSERT_INTO_COD_TABLES');

1116: END LOOP;
1117: EXCEPTION
1118: WHEN OTHERS THEN
1119: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1120: fnd_message.set_token('NAME','IGF_GR_GEN_XML.INSERT_INTO_COD_TABLES');
1121: igs_ge_msg_stack.add;
1122: app_exception.raise_exception;
1123: END insert_into_cod_tables;
1124:

Line 1196: fnd_message.set_token('PER_NUM',igf_gr_gen.get_per_num(p_rfms_rec.base_id));

1192: -- 2. validate xml boundary validations
1193: -- 3. insert data into IGF_GR_COD_DTLS and IGF_AW_DB_COD_DTLS tables.
1194:
1195: fnd_message.set_name('IGF','IGF_GR_PROCESS_STUD');
1196: fnd_message.set_token('PER_NUM',igf_gr_gen.get_per_num(p_rfms_rec.base_id));
1197: fnd_message.set_token('ORIG_ID',p_rfms_rec.origination_id);
1198: fnd_file.put_line(fnd_file.log,fnd_message.get);
1199:
1200: -- validate general validations

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 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 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 1359: l_event_name := 'oracle.apps.igf.gr.genxml';

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';
1360: l_map_code := 'IGF_GR_PELL_OUT';
1361: l_param_1 := p_document_id;
1362:
1363: OPEN cur_sequence;

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 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 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 1415: fnd_message.set_token('NAME','IGF_GR_GEN_XML.SUBMIT_XML_EVENT');

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;
1417: END submit_xml_event;
1418:
1419: PROCEDURE main (

Line 1518: fnd_message.set_token('STDNT',igf_gr_gen.get_per_num(p_base_id));

1514: -- Start of Step 3. Find all PELL records to be processed and process them.
1515: -- Processing when base_id is given.
1516: IF p_base_id IS NOT NULL THEN
1517: fnd_message.set_name('IGF','IGF_AW_PROC_STUD');
1518: fnd_message.set_token('STDNT',igf_gr_gen.get_per_num(p_base_id));
1519: fnd_file.put_line(fnd_file.log, fnd_message.get);
1520:
1521: lb_record_exist := FALSE;
1522: 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 1532: fnd_message.set_token('PER_NUM',igf_gr_gen.get_per_num(p_base_id));

1528: END LOOP;
1529:
1530: IF NOT lb_record_exist THEN
1531: fnd_message.set_name('IGF','IGF_GR_COD_NO_STDNT_RFMS_REC');
1532: fnd_message.set_token('PER_NUM',igf_gr_gen.get_per_num(p_base_id));
1533: fnd_file.put_line(fnd_file.log, fnd_message.get);
1534: fnd_file.new_line(fnd_file.log, 1);
1535: RETURN;
1536: END IF;

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 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 1596: fnd_message.set_token('PER_NUM',igf_gr_gen.get_per_num(p_base_id));

1592: END LOOP;
1593:
1594: IF NOT lb_record_exist_stdnt THEN
1595: fnd_message.set_name('IGF','IGF_GR_COD_NO_STDNT_RFMS_REC');
1596: fnd_message.set_token('PER_NUM',igf_gr_gen.get_per_num(p_base_id));
1597: fnd_file.put_line(fnd_file.log, fnd_message.get);
1598: fnd_file.new_line(fnd_file.log, 1);
1599: END IF;
1600: ELSE -- log a message and skip this person, base id not found

Line 1603: fnd_message.set_token('AWD_YR',igf_gr_gen.get_alt_code(l_ci_cal_type,l_ci_sequence_number));

1599: END IF;
1600: ELSE -- log a message and skip this person, base id not found
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;

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 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 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 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 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 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 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 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 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 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 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 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 1795: wf_core.context ( 'IGF_GR_GEN_XML',

1791:
1792: EXCEPTION
1793: WHEN OTHERS THEN
1794: resultout := 'E';
1795: wf_core.context ( 'IGF_GR_GEN_XML',
1796: 'STORE_XML',
1797: itemtype,
1798: itemkey,
1799: to_char(actid),

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 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 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 1958: fnd_message.set_token('NAME','IGF_GR_GEN_XML.UPDATE_STATUS');

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;
1960: app_exception.raise_exception;
1961: END update_status;
1962:

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

Line 2069: END IGF_GR_GEN_XML;

2065: END IF;
2066: igs_ge_msg_stack.conc_exception_hndl;
2067: END print_xml;
2068:
2069: END IGF_GR_GEN_XML;