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_AP_ISIR_IMPORT_PKG dependencies on IGF_AP_ISIR_IMPORT_PKG

Line 1: PACKAGE BODY IGF_AP_ISIR_IMPORT_PKG AS

1: PACKAGE BODY IGF_AP_ISIR_IMPORT_PKG AS
2: /* $Header: IGFAP01B.pls 120.2 2006/02/10 02:47:08 bvisvana noship $ */
3:
4: g_ISIR_rec igf_ap_ISIR_matched%ROWTYPE;
5: g_base_rec igf_ap_fa_base_rec%ROWTYPE;

Line 146: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'igf.plsql.igf_ap_isir_import_pkg.l_is_cor_from_same_school.debug','x_msg_data : ' || x_msg_data);

142: -- Derive Federal School Code.
143: igf_sl_gen.get_stu_fao_code(l_get_base_id_rec.base_id, 'FED_SCH_CD', x_fed_sch_cd, x_return_status, x_msg_data);
144: IF (x_return_status = 'E') THEN
145: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
146: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'igf.plsql.igf_ap_isir_import_pkg.l_is_cor_from_same_school.debug','x_msg_data : ' || x_msg_data);
147: END IF;
148: RETURN FALSE;
149: ELSE
150: -- write debug message with federal school code.

Line 152: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'igf.plsql.igf_ap_isir_import_pkg.l_is_cor_from_same_school.debug','x_fed_sch_cd : ' || x_fed_sch_cd);

148: RETURN FALSE;
149: ELSE
150: -- write debug message with federal school code.
151: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
152: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'igf.plsql.igf_ap_isir_import_pkg.l_is_cor_from_same_school.debug','x_fed_sch_cd : ' || x_fed_sch_cd);
153: END IF;
154: -- check wether federal school code matches with any of 6 codes
155: IF ( x_fed_sch_cd = l_get_base_id_rec.first_college OR
156: x_fed_sch_cd = l_get_base_id_rec.second_college OR

Line 171: fnd_message.set_token('NAME','IGF_AP_ISIR_IMPORT_PKG.L_IS_COR_FROM_SAME_SCHOOL');

167:
168: EXCEPTION
169: WHEN others THEN
170: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
171: fnd_message.set_token('NAME','IGF_AP_ISIR_IMPORT_PKG.L_IS_COR_FROM_SAME_SCHOOL');
172: fnd_file.put_line(fnd_file.log,SQLERRM);
173: igs_ge_msg_stack.add;
174: app_exception.raise_exception;
175:

Line 293: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_isir_import_pkg.spawn_processes.debug','Launched spawned request ' || p_sub_req_number || ' Request ID : ' || l_request_id);

289: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
290: END IF;
291:
292: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
293: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_isir_import_pkg.spawn_processes.debug','Launched spawned request ' || p_sub_req_number || ' Request ID : ' || l_request_id);
294: END IF;
295:
296: EXCEPTION
297: WHEN OTHERS THEN

Line 299: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_isir_import_pkg.launch_sub_request.exception','The exception is : ' || SQLERRM );

295:
296: EXCEPTION
297: WHEN OTHERS THEN
298: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
299: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_isir_import_pkg.launch_sub_request.exception','The exception is : ' || SQLERRM );
300: END IF;
301:
302: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
303: fnd_message.set_token('NAME','IGF_AP_ISIR_IMPORT_PKG.LAUNCH_SUB_REQUEST');

Line 303: fnd_message.set_token('NAME','IGF_AP_ISIR_IMPORT_PKG.LAUNCH_SUB_REQUEST');

299: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_isir_import_pkg.launch_sub_request.exception','The exception is : ' || SQLERRM );
300: END IF;
301:
302: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
303: fnd_message.set_token('NAME','IGF_AP_ISIR_IMPORT_PKG.LAUNCH_SUB_REQUEST');
304: fnd_file.put_line(fnd_file.log,fnd_message.get);
305: igs_ge_msg_stack.add;
306: RETURN; -- continue processing for the next sub request.
307: END launch_sub_request;

Line 475: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_isir_import_pkg.validate_parameters.debug', 'Successfully Completed validate_parameters procedure.');

471:
472: log_debug_message(' All validations successful... ');
473:
474: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
475: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_isir_import_pkg.validate_parameters.debug', 'Successfully Completed validate_parameters procedure.');
476: END IF;
477:
478: EXCEPTION
479: WHEN OTHERS THEN

Line 481: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_isir_import_pkg.validate_parameters.exception','The exception is : ' || SQLERRM );

477:
478: EXCEPTION
479: WHEN OTHERS THEN
480: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
481: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_isir_import_pkg.validate_parameters.exception','The exception is : ' || SQLERRM );
482: END IF;
483:
484: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
485: fnd_message.set_token('NAME','IGF_AP_ISIR_IMPORT_PKG.VALIDATE_PARAMETERS');

Line 485: fnd_message.set_token('NAME','IGF_AP_ISIR_IMPORT_PKG.VALIDATE_PARAMETERS');

481: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_isir_import_pkg.validate_parameters.exception','The exception is : ' || SQLERRM );
482: END IF;
483:
484: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
485: fnd_message.set_token('NAME','IGF_AP_ISIR_IMPORT_PKG.VALIDATE_PARAMETERS');
486: fnd_file.put_line(fnd_file.log,fnd_message.get);
487: fnd_file.put_line(fnd_file.log, SQLERRM);
488: igs_ge_msg_stack.add;
489: app_exception.raise_exception;

Line 567: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_isir_import_pkg.build_selection_criteria.debug', 'Successfully Completed build_selection_criteria procedure.');

563: END IF;
564:
565: -- fnd_file.put_line(fnd_file.LOG, ' Dynamic Where Clause : ' || g_where);
566: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
567: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_isir_import_pkg.build_selection_criteria.debug', 'Successfully Completed build_selection_criteria procedure.');
568: END IF;
569:
570: EXCEPTION
571: WHEN OTHERS THEN

Line 573: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_isir_import_pkg.build_selection_criteria.exception','The exception is : ' || SQLERRM );

569:
570: EXCEPTION
571: WHEN OTHERS THEN
572: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
573: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_isir_import_pkg.build_selection_criteria.exception','The exception is : ' || SQLERRM );
574: END IF;
575:
576: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
577: fnd_message.set_token('NAME','IGF_AP_ISIR_IMPORT_PKG.BUILD_SELECTION_CRITERIA');

Line 577: fnd_message.set_token('NAME','IGF_AP_ISIR_IMPORT_PKG.BUILD_SELECTION_CRITERIA');

573: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_isir_import_pkg.build_selection_criteria.exception','The exception is : ' || SQLERRM );
574: END IF;
575:
576: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
577: fnd_message.set_token('NAME','IGF_AP_ISIR_IMPORT_PKG.BUILD_SELECTION_CRITERIA');
578: fnd_file.put_line(fnd_file.log,fnd_message.get);
579: fnd_file.put_line(fnd_file.log, SQLERRM);
580: igs_ge_msg_stack.add;
581: app_exception.raise_exception;

Line 606: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_isir_import_pkg.query_isir_records.debug', 'Beginning procedure query_isir_records');

602:
603: BEGIN
604:
605: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
606: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_isir_import_pkg.query_isir_records.debug', 'Beginning procedure query_isir_records');
607: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_isir_import_pkg.query_isir_records.debug', 'Querying SQL Query : ' || g_where);
608: END IF;
609:
610: i := 1;

Line 607: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_isir_import_pkg.query_isir_records.debug', 'Querying SQL Query : ' || g_where);

603: BEGIN
604:
605: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
606: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_isir_import_pkg.query_isir_records.debug', 'Beginning procedure query_isir_records');
607: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_isir_import_pkg.query_isir_records.debug', 'Querying SQL Query : ' || g_where);
608: END IF;
609:
610: i := 1;
611: -- Execute the query and get the records into temp table.

Line 642: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_isir_import_pkg.query_isir_records.debug', 'No. of records fetched for processing : ' || g_total_recs_fetched);

638: g_total_recs_fetched := g_si_id_tab.COUNT;
639: log_debug_message('Populated temporary PL/SQL table. Records : ' || g_total_recs_fetched || '. Time : ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
640:
641: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
642: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_isir_import_pkg.query_isir_records.debug', 'No. of records fetched for processing : ' || g_total_recs_fetched);
643: END IF;
644:
645: EXCEPTION
646: WHEN OTHERS THEN

Line 648: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_isir_import_pkg.query_isir_records.exception','The exception is : ' || SQLERRM );

644:
645: EXCEPTION
646: WHEN OTHERS THEN
647: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
648: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_isir_import_pkg.query_isir_records.exception','The exception is : ' || SQLERRM );
649: END IF;
650: log_debug_message('EXCEPTION : ' || SQLERRM);
651:
652: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

Line 653: fnd_message.set_token('NAME','IGF_AP_ISIR_IMPORT_PKG.QUERY_ISIR_RECORDS');

649: END IF;
650: log_debug_message('EXCEPTION : ' || SQLERRM);
651:
652: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
653: fnd_message.set_token('NAME','IGF_AP_ISIR_IMPORT_PKG.QUERY_ISIR_RECORDS');
654: fnd_file.put_line(fnd_file.log,fnd_message.get);
655: fnd_file.put_line(fnd_file.log, SQLERRM);
656: igs_ge_msg_stack.add;
657: app_exception.raise_exception;

Line 683: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_isir_import_pkg.spawn_processes.debug', 'No. of processes to spawn : ' || p_spawn_process);

679: BEGIN
680:
681: log_debug_message(' Beginning process spawning....');
682: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
683: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_isir_import_pkg.spawn_processes.debug', 'No. of processes to spawn : ' || p_spawn_process);
684: END IF;
685:
686: -- get the No. of records per process
687: l_recs_per_process := CEIL(g_total_recs_fetched/p_spawn_process);

Line 729: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_isir_import_pkg.spawn_processes.debug', 'Adding SI_ID ' || g_si_id_tab(l_to_rec) || ' to Sub Request No. ' || i);

725: l_to_rec := l_to_rec + 1;
726: l_current_sub_req_recs := l_current_sub_req_recs + 1;
727:
728: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
729: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_isir_import_pkg.spawn_processes.debug', 'Adding SI_ID ' || g_si_id_tab(l_to_rec) || ' to Sub Request No. ' || i);
730: END IF;
731: log_debug_message(' Next record belongs to same person!!!!. Including in the current sub reqeust itself. SI_ID ' || g_si_id_tab(l_to_rec));
732: END LOOP;
733: END IF; -- g_proc_recs_tab

Line 737: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_isir_import_pkg.spawn_processes.debug', 'Total records for Sub Request No. ' || i || ' is ' || l_current_sub_req_recs);

733: END IF; -- g_proc_recs_tab
734:
735: log_debug_message('TOTAL RECORDS for Sub Request No. ' || i || ' is ' || l_current_sub_req_recs);
736: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
737: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_isir_import_pkg.spawn_processes.debug', 'Total records for Sub Request No. ' || i || ' is ' || l_current_sub_req_recs);
738: END IF;
739:
740: ----------------------------------------------------------------------------
741: -- At this point Final Recs to be processed for the current sub request have been included.

Line 769: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_isir_import_pkg.spawn_processes.debug', 'Completed updating Spawning Processes details.... ');

765:
766: END LOOP; -- i
767:
768: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
769: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_isir_import_pkg.spawn_processes.debug', 'Completed updating Spawning Processes details.... ');
770: END IF;
771: log_debug_message(' Spawning Process completed successfully. Exitting.....at.. ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
772:
773: EXCEPTION

Line 776: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_isir_import_pkg.spawn_processes.exception','The exception is : ' || SQLERRM );

772:
773: EXCEPTION
774: WHEN OTHERS THEN
775: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
776: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_isir_import_pkg.spawn_processes.exception','The exception is : ' || SQLERRM );
777: END IF;
778: log_debug_message(' EXCEPTION in spawn_processes : ' || SQLERRM);
779:
780: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

Line 781: fnd_message.set_token('NAME','IGF_AP_ISIR_IMPORT_PKG.SPAWN_PROCESSES');

777: END IF;
778: log_debug_message(' EXCEPTION in spawn_processes : ' || SQLERRM);
779:
780: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
781: fnd_message.set_token('NAME','IGF_AP_ISIR_IMPORT_PKG.SPAWN_PROCESSES');
782: fnd_file.put_line(fnd_file.log,fnd_message.get);
783: igs_ge_msg_stack.add;
784: app_exception.raise_exception;
785: END spawn_processes;

Line 856: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_isir_import_pkg.main_import_process.debug','Beginning Main process. Before gathering Statistics: ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));

852: l_cal_type := LTRIM(RTRIM(SUBSTR(p_award_year,1,10)));
853: l_seq_number := TO_NUMBER(SUBSTR(p_award_year,11));
854:
855: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
856: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_isir_import_pkg.main_import_process.debug','Beginning Main process. Before gathering Statistics: ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
857: END IF;
858:
859: -- gather Statistics RAMMOHAN commented for testing
860: log_debug_message(' Starting to gather statistics. ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));

Line 866: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_isir_import_pkg.main_import_process.debug','After gathering Statistics: ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));

862: fnd_stats.gather_table_stats(ownname => 'IGF', tabname => 'IGF_AP_ISIR_MATCHED_ALL' , cascade => TRUE);
863: log_debug_message(' End of Statistics gathering. ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
864:
865: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
866: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_isir_import_pkg.main_import_process.debug','After gathering Statistics: ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
867: END IF;
868:
869:
870: -- Copying the parameter values to the gobal variable.

Line 958: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_isir_import_pkg.main_import_process.debug','Successfully Completed the process at: ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));

954: END IF;
955:
956: log_debug_message('Successfully completed the Request at : ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS')) ;
957: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
958: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_isir_import_pkg.main_import_process.debug','Successfully Completed the process at: ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
959: END IF;
960:
961: EXCEPTION
962: WHEN others THEN

Line 966: fnd_message.set_token('NAME','IGF_AP_ISIR_IMPORT_PKG.MAIN_IMPORT_PROCESS');

962: WHEN others THEN
963: ROLLBACK;
964: retcode := 2;
965: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
966: fnd_message.set_token('NAME','IGF_AP_ISIR_IMPORT_PKG.MAIN_IMPORT_PROCESS');
967: fnd_file.put_line(fnd_file.log,SQLERRM);
968: errbuf := fnd_message.get;
969: igs_ge_msg_stack.conc_exception_hndl;
970: END main_import_process;

Line 1325: fnd_message.set_token('NAME','IGF_AP_ISIR_IMPORT_PKG.UPDATE_MATCHED_ISIR');

1321:
1322: EXCEPTION
1323: WHEN others THEN
1324: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1325: fnd_message.set_token('NAME','IGF_AP_ISIR_IMPORT_PKG.UPDATE_MATCHED_ISIR');
1326: fnd_file.put_line(fnd_file.log,SQLERRM);
1327: igs_ge_msg_stack.add;
1328: app_exception.raise_exception;
1329: END update_matched_ISIR;

Line 1498: fnd_message.set_token('NAME','IGF_AP_ISIR_IMPORT_PKG.UPDATE_FABASE');

1494: EXCEPTION
1495:
1496: WHEN others THEN
1497: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1498: fnd_message.set_token('NAME','IGF_AP_ISIR_IMPORT_PKG.UPDATE_FABASE');
1499: fnd_file.put_line(fnd_file.log,SQLERRM);
1500: igs_ge_msg_stack.add;
1501: app_exception.raise_exception;
1502:

Line 1547: fnd_message.set_token('NAME','IGF_AP_ISIR_IMPORT_PKG.UPDATE_ISIR_CORR');

1543:
1544: EXCEPTION
1545: WHEN others THEN
1546: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1547: fnd_message.set_token('NAME','IGF_AP_ISIR_IMPORT_PKG.UPDATE_ISIR_CORR');
1548: fnd_file.put_line(fnd_file.log,SQLERRM);
1549: igs_ge_msg_stack.add;
1550: app_exception.raise_exception;
1551: END update_ISIR_corr;

Line 1668: fnd_message.set_token('NAME','IGF_AP_ISIR_IMPORT_PKG.VALIDATE_CORRECTIONS');

1664:
1665: EXCEPTION
1666: WHEN others THEN
1667: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1668: fnd_message.set_token('NAME','IGF_AP_ISIR_IMPORT_PKG.VALIDATE_CORRECTIONS');
1669: fnd_file.put_line(fnd_file.log,SQLERRM);
1670: igs_ge_msg_stack.add;
1671: app_exception.raise_exception;
1672: END validate_corrections;

Line 1715: fnd_message.set_token('NAME','IGF_AP_ISIR_IMPORT_PKG.PREPARE_MESSAGE');

1711:
1712: EXCEPTION
1713: WHEN others THEN
1714: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1715: fnd_message.set_token('NAME','IGF_AP_ISIR_IMPORT_PKG.PREPARE_MESSAGE');
1716: fnd_file.put_line(fnd_file.log,SQLERRM);
1717: igs_ge_msg_stack.add;
1718: app_exception.raise_exception;
1719: END prepare_message;

Line 1830: fnd_message.set_token('NAME','IGF_AP_ISIR_IMPORT_PKG.CREATE_MESSAGE');

1826:
1827: EXCEPTION
1828: WHEN others THEN
1829: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1830: fnd_message.set_token('NAME','IGF_AP_ISIR_IMPORT_PKG.CREATE_MESSAGE');
1831: fnd_file.put_line(fnd_file.log,SQLERRM);
1832: igs_ge_msg_stack.add;
1833: app_exception.raise_exception;
1834: END create_message;

Line 1874: 'MSGDOC','PLSQL:IGF_AP_ISIR_IMPORT_PKG.CREATE_MESSAGE/'||itemtype||':'||itemkey);

1870: g_msg_body);
1871:
1872: wf_engine.setitemattrtext(itemtype,
1873: itemkey,
1874: 'MSGDOC','PLSQL:IGF_AP_ISIR_IMPORT_PKG.CREATE_MESSAGE/'||itemtype||':'||itemkey);
1875: resultout := 'COMPLETE';
1876: END IF;
1877:
1878: EXCEPTION

Line 1911: fnd_message.set_token('NAME','IGF_AP_ISIR_IMPORT_PKG.SEND_MESSAGE');

1907: wf_engine.startprocess('OUTCORR',l_item_key);
1908: EXCEPTION
1909: WHEN others THEN
1910: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1911: fnd_message.set_token('NAME','IGF_AP_ISIR_IMPORT_PKG.SEND_MESSAGE');
1912: fnd_file.put_line(fnd_file.log,SQLERRM);
1913: igs_ge_msg_stack.add;
1914: app_exception.raise_exception;
1915: END send_message;

Line 1917: END IGF_AP_ISIR_IMPORT_PKG;

1913: igs_ge_msg_stack.add;
1914: app_exception.raise_exception;
1915: END send_message;
1916:
1917: END IGF_AP_ISIR_IMPORT_PKG;