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_LI_IMPORT dependencies on IGF_GR_LI_IMPORT

Line 1: PACKAGE BODY igf_gr_li_import AS

1: PACKAGE BODY igf_gr_li_import AS
2: /* $Header: IGFGR10B.pls 120.3 2006/01/17 02:45:55 tsailaja ship $ */
3: /*=======================================================================+
4: | Copyright (c) 1994, 1996 Oracle Corp. Redwood Shores, California, USA|
5: | All rights reserved. |

Line 9: | PL/SQL spec for package: IGF_GR_LI_IMPORT |

5: | All rights reserved. |
6: +=======================================================================+
7: | |
8: | DESCRIPTION |
9: | PL/SQL spec for package: IGF_GR_LI_IMPORT |
10: | |
11: | NOTES |
12: | Legacy Pell Origiantion and Disbursement Import Process. Imports the|
13: | Pell Originaton records and its disbursement records from the legacy|

Line 255: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'igf.plsql.igf_gr_li_import.log_parameters.exception', SQLERRM );

251:
252: EXCEPTION
253: WHEN OTHERS THEN
254: IF(FND_LOG.LEVEL_EXCEPTION >= g_debug_runtime_level)THEN
255: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'igf.plsql.igf_gr_li_import.log_parameters.exception', SQLERRM );
256: END IF;
257: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
258: fnd_message.set_token('NAME','IGF_GR_LI_IMPORT.LOG_PARAMETERS');
259: igs_ge_msg_stack.add;

Line 258: fnd_message.set_token('NAME','IGF_GR_LI_IMPORT.LOG_PARAMETERS');

254: IF(FND_LOG.LEVEL_EXCEPTION >= g_debug_runtime_level)THEN
255: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'igf.plsql.igf_gr_li_import.log_parameters.exception', SQLERRM );
256: END IF;
257: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
258: fnd_message.set_token('NAME','IGF_GR_LI_IMPORT.LOG_PARAMETERS');
259: igs_ge_msg_stack.add;
260:
261: END log_parameters;
262:

Line 545: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_gr_li_import.update_fa_base_data.debug', l_debug_str || ' Sucssfully updated ');

541:
542: );
543:
544: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_runtime_level) THEN
545: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_gr_li_import.update_fa_base_data.debug', l_debug_str || ' Sucssfully updated ');
546: l_debug_str := NULL;
547: END IF;
548:
549: RETURN 'S';

Line 555: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'igf.plsql.igf_gr_li_import.update_fa_base_data.exception', l_debug_str || SQLERRM );

551: EXCEPTION
552: WHEN OTHERS THEN
553:
554: IF(FND_LOG.LEVEL_EXCEPTION >= g_debug_runtime_level)THEN
555: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'igf.plsql.igf_gr_li_import.update_fa_base_data.exception', l_debug_str || SQLERRM );
556: END IF;
557: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
558: fnd_message.set_token('NAME','IGF_GR_LI_IMPORT.UPDATE_FA_BASE_DATA');
559: igs_ge_msg_stack.add;

Line 558: fnd_message.set_token('NAME','IGF_GR_LI_IMPORT.UPDATE_FA_BASE_DATA');

554: IF(FND_LOG.LEVEL_EXCEPTION >= g_debug_runtime_level)THEN
555: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'igf.plsql.igf_gr_li_import.update_fa_base_data.exception', l_debug_str || SQLERRM );
556: END IF;
557: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
558: fnd_message.set_token('NAME','IGF_GR_LI_IMPORT.UPDATE_FA_BASE_DATA');
559: igs_ge_msg_stack.add;
560: RETURN 'E';
561:
562: END update_fa_base_data;

Line 619: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_gr_li_import.delete_existing_pell_rec.debug', l_debug_str);

615: IF (lc_chk_pell_orig.row_id IS NOT NULL) THEN
616:
617: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_runtime_level) THEN
618: l_debug_str := l_debug_str || ' Pell Orig : ' || p_origination_id || ', Looping Pell disb ';
619: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_gr_li_import.delete_existing_pell_rec.debug', l_debug_str);
620: l_debug_str := NULL;
621: END IF;
622:
623: BEGIN

Line 629: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_gr_li_import.delete_existing_pell_rec.debug', ' Deleting Pell Disb : ' || lc_get_pell_disb.rfmd_id);

625: -- Loop for all Pell Disbursement records for the given Pell record
626: FOR lc_get_pell_disb IN c_get_pell_disb(p_origination_id) LOOP
627:
628: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_runtime_level) THEN
629: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_gr_li_import.delete_existing_pell_rec.debug', ' Deleting Pell Disb : ' || lc_get_pell_disb.rfmd_id);
630: END IF;
631:
632: igf_gr_rfms_disb_pkg.delete_row(lc_get_pell_disb.row_id);
633: END LOOP;

Line 654: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'igf.plsql.igf_gr_li_import.delete_existing_pell_rec.exception', l_debug_str || SQLERRM );

650: EXCEPTION
651: WHEN OTHERS THEN
652:
653: IF(FND_LOG.LEVEL_EXCEPTION >= g_debug_runtime_level)THEN
654: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'igf.plsql.igf_gr_li_import.delete_existing_pell_rec.exception', l_debug_str || SQLERRM );
655: END IF;
656: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
657: fnd_message.set_token('NAME','IGF_GR_LI_IMPORT.DELETE_EXISTING_PELL_REC');
658: igs_ge_msg_stack.add;

Line 657: fnd_message.set_token('NAME','IGF_GR_LI_IMPORT.DELETE_EXISTING_PELL_REC');

653: IF(FND_LOG.LEVEL_EXCEPTION >= g_debug_runtime_level)THEN
654: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'igf.plsql.igf_gr_li_import.delete_existing_pell_rec.exception', l_debug_str || SQLERRM );
655: END IF;
656: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
657: fnd_message.set_token('NAME','IGF_GR_LI_IMPORT.DELETE_EXISTING_PELL_REC');
658: igs_ge_msg_stack.add;
659: RETURN 'E';
660:
661: END delete_existing_pell_rec;

Line 736: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'igf.plsql.igf_gr_li_import.create_pell_disb_batch.exception', SQLERRM );

732:
733: EXCEPTION
734: WHEN OTHERS THEN
735: IF(FND_LOG.LEVEL_EXCEPTION >= g_debug_runtime_level)THEN
736: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'igf.plsql.igf_gr_li_import.create_pell_disb_batch.exception', SQLERRM );
737: END IF;
738: fnd_message.set_name('IGF','IGF_GR_LI_BDINSRT_FAIL');
739: fnd_message.set_token('BATCH_NUM',p_pell_disb_int.disburse_batch_id_txt);
740: fnd_message.set_token('ORIG_ID',p_pell_disb_int.origination_id_txt);

Line 818: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'igf.plsql.igf_gr_li_import.create_pell_disb.exception', SQLERRM );

814:
815: EXCEPTION
816: WHEN OTHERS THEN
817: IF(FND_LOG.LEVEL_EXCEPTION >= g_debug_runtime_level)THEN
818: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'igf.plsql.igf_gr_li_import.create_pell_disb.exception', SQLERRM );
819: END IF;
820: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
821: fnd_message.set_token('NAME','IGF_GR_LI_IMPORT.CREATE_PELL_DISB');
822: igs_ge_msg_stack.add;

Line 821: fnd_message.set_token('NAME','IGF_GR_LI_IMPORT.CREATE_PELL_DISB');

817: IF(FND_LOG.LEVEL_EXCEPTION >= g_debug_runtime_level)THEN
818: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'igf.plsql.igf_gr_li_import.create_pell_disb.exception', SQLERRM );
819: END IF;
820: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
821: fnd_message.set_token('NAME','IGF_GR_LI_IMPORT.CREATE_PELL_DISB');
822: igs_ge_msg_stack.add;
823: RETURN FALSE;
824:
825: END create_pell_disb;

Line 874: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_gr_li_import.import_pell_disb.debug', l_debug_str);

870: fnd_message.set_name('IGF','IGF_GR_LI_DNUM_INVALID');
871: fnd_file.put_line(fnd_file.log, g_disb_pad_str || fnd_message.get);
872: CLOSE c_awd_disb;
873: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_runtime_level) THEN
874: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_gr_li_import.import_pell_disb.debug', l_debug_str);
875: l_debug_str := NULL;
876: END IF;
877: l_disb_import_status := 'E';
878: RETURN l_disb_import_status;

Line 1173: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_gr_li_import.import_pell_disb.debug', l_debug_str );

1169:
1170: l_disb_import_status := 'E';
1171: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_runtime_level) THEN
1172: l_debug_str := l_debug_str || ' :: Pell Disbursement not created Ret status : '|| l_disb_import_status;
1173: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_gr_li_import.import_pell_disb.debug', l_debug_str );
1174: l_debug_str := NULL;
1175: END IF;
1176: RETURN l_disb_import_status;
1177: END IF;

Line 1182: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_gr_li_import.import_pell_disb.debug', l_debug_str );

1178: END IF;
1179:
1180: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_runtime_level) THEN
1181: l_debug_str := l_debug_str || ' :: IMPORT_PELL_DISB Successful :: Ret status : '|| l_disb_import_status;
1182: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_gr_li_import.import_pell_disb.debug', l_debug_str );
1183: l_debug_str := NULL;
1184: END IF;
1185: RETURN l_disb_import_status;
1186:

Line 1190: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'igf.plsql.igf_gr_li_import.import_pell_disb.exception', l_debug_str || SQLERRM );

1186:
1187: EXCEPTION
1188: WHEN OTHERS THEN
1189: IF(FND_LOG.LEVEL_EXCEPTION >= g_debug_runtime_level)THEN
1190: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'igf.plsql.igf_gr_li_import.import_pell_disb.exception', l_debug_str || SQLERRM );
1191: END IF;
1192: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1193: fnd_message.set_token('NAME','IGF_GR_LI_IMPORT.IMPORT_PELL_DISB');
1194: igs_ge_msg_stack.add;

Line 1193: fnd_message.set_token('NAME','IGF_GR_LI_IMPORT.IMPORT_PELL_DISB');

1189: IF(FND_LOG.LEVEL_EXCEPTION >= g_debug_runtime_level)THEN
1190: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'igf.plsql.igf_gr_li_import.import_pell_disb.exception', l_debug_str || SQLERRM );
1191: END IF;
1192: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1193: fnd_message.set_token('NAME','IGF_GR_LI_IMPORT.IMPORT_PELL_DISB');
1194: igs_ge_msg_stack.add;
1195: RETURN 'E';
1196:
1197: END import_pell_disb;

Line 1271: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'igf.plsql.igf_gr_li_import.create_pell_orig_batch.exception', SQLERRM );

1267:
1268: EXCEPTION
1269: WHEN OTHERS THEN
1270: IF(FND_LOG.LEVEL_EXCEPTION >= g_debug_runtime_level)THEN
1271: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'igf.plsql.igf_gr_li_import.create_pell_orig_batch.exception', SQLERRM );
1272: END IF;
1273: fnd_message.set_name('IGF','IGF_GR_LI_BINSERT_FAIL');
1274: fnd_message.set_token('BATCH_NUM',p_pell_orig_int.orig_send_batch_id_txt);
1275: igs_ge_msg_stack.add;

Line 1394: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_gr_li_import.create_pell_orig.debug', l_debug_str || ', Created Pell Origination record Orig ID :' || p_pell_orig_int.origination_id_txt);

1390: x_document_id_txt => NULL
1391: );
1392:
1393: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_runtime_level) THEN
1394: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_gr_li_import.create_pell_orig.debug', l_debug_str || ', Created Pell Origination record Orig ID :' || p_pell_orig_int.origination_id_txt);
1395: l_debug_str := NULL;
1396: END IF;
1397:
1398: RETURN TRUE;

Line 1403: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'igf.plsql.igf_gr_li_import.create_pell_orig.exception', SQLERRM );

1399:
1400: EXCEPTION
1401: WHEN OTHERS THEN
1402: IF(FND_LOG.LEVEL_EXCEPTION >= g_debug_runtime_level)THEN
1403: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'igf.plsql.igf_gr_li_import.create_pell_orig.exception', SQLERRM );
1404: END IF;
1405: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1406: fnd_message.set_token('NAME','IGF_GR_LI_IMPORT.CREATE_PELL_ORIG');
1407: igs_ge_msg_stack.add;

Line 1406: fnd_message.set_token('NAME','IGF_GR_LI_IMPORT.CREATE_PELL_ORIG');

1402: IF(FND_LOG.LEVEL_EXCEPTION >= g_debug_runtime_level)THEN
1403: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'igf.plsql.igf_gr_li_import.create_pell_orig.exception', SQLERRM );
1404: END IF;
1405: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1406: fnd_message.set_token('NAME','IGF_GR_LI_IMPORT.CREATE_PELL_ORIG');
1407: igs_ge_msg_stack.add;
1408: RETURN FALSE;
1409:
1410: END create_pell_orig;

Line 1529: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_gr_li_import.import_pell_orig.debug',

1525: CLOSE c_awd_details;
1526: ROLLBACK TO SP_PELL;
1527: l_pell_import_status := 'E';
1528: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_runtime_level) THEN
1529: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_gr_li_import.import_pell_orig.debug',
1530: l_debug_str || 'Award ref not present in production table :'|| l_pell_import_status);
1531: END IF;
1532: RETURN l_pell_import_status;
1533:

Line 1584: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_gr_li_import.import_pell_orig.debug', l_debug_str);

1580: IF c_isir_details%NOTFOUND THEN
1581:
1582: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_runtime_level) THEN
1583: l_debug_str := l_debug_str || ', ISIR Details not found : ';
1584: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_gr_li_import.import_pell_orig.debug', l_debug_str);
1585: l_debug_str := NULL;
1586: END IF;
1587: -- Bug# 3089841 Changed the message
1588: fnd_message.set_name('IGF','IGF_GR_ISIR_NOT_FOUND');

Line 2021: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_gr_li_import.import_pell_orig.debug', l_debug_str);

2017: l_pell_import_status := 'E';
2018: END IF;
2019:
2020: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_runtime_level) THEN
2021: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_gr_li_import.import_pell_orig.debug', l_debug_str);
2022: l_debug_str := 'IGFGR10B.pls Procedure import_pell_orig (2) :: ';
2023: END IF;
2024:
2025:

Line 2213: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_gr_li_import.import_pell_orig.debug', l_debug_str);

2209: END IF;
2210:
2211: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_runtime_level) THEN
2212: l_debug_str := l_debug_str || ' Pell Orig Batch ID : '|| l_rfmb_id || ' :: Creating Pell Orig rec : ';
2213: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_gr_li_import.import_pell_orig.debug', l_debug_str);
2214: l_debug_str := NULL;
2215: END IF;
2216:
2217: -- Create Pell Record

Line 2223: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_gr_li_import.import_pell_orig.debug', ' : Pell Orig rec not created');

2219: fnd_message.set_name('IGF','IGF_GR_LI_OINSERT_FAIL');
2220: fnd_message.set_token('ORIG_ID',p_pell_orig_int.origination_id_txt);
2221: fnd_file.put_line(fnd_file.log, fnd_message.get);
2222: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_runtime_level) THEN
2223: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_gr_li_import.import_pell_orig.debug', ' : Pell Orig rec not created');
2224: END IF;
2225: l_pell_import_status := 'E';
2226: ROLLBACK TO SP_PELL;
2227: RETURN l_pell_import_status;

Line 2275: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_gr_li_import.import_pell_orig.debug', l_debug_str);

2271:
2272: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_runtime_level) THEN
2273: l_debug_str := l_debug_str || ', Disb Status : ' || l_pell_disb_indv_status;
2274: l_debug_str := l_debug_str || ', l_pell_disb_full_status : '|| l_pell_disb_full_status ||', l_pell_disb_indv_status : '|| l_pell_disb_indv_status;
2275: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_gr_li_import.import_pell_orig.debug', l_debug_str);
2276: l_debug_str := NULL;
2277: END IF;
2278:
2279: END LOOP; -- End of creation of Disbursments

Line 2297: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_gr_li_import.import_pell_orig.debug', l_debug_str || ' End of Pell Orig Import, return status : '|| l_pell_import_status);

2293: IF l_pell_import_status = 'E' THEN
2294:
2295: ROLLBACK TO SP_PELL;
2296: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_runtime_level) THEN
2297: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_gr_li_import.import_pell_orig.debug', l_debug_str || ' End of Pell Orig Import, return status : '|| l_pell_import_status);
2298: l_debug_str := NULL;
2299: END IF;
2300:
2301: RETURN l_pell_import_status;

Line 2311: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_gr_li_import.import_pell_orig.debug','Processing Remaining disb present in the Production Awd Disb : ');

2307: IF l_pell_import_status <> 'E' THEN
2308:
2309: -- Create the remaining disbursements which are present in the Awd Disb table and not present in the Pell Disb table
2310: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_runtime_level) THEN
2311: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_gr_li_import.import_pell_orig.debug','Processing Remaining disb present in the Production Awd Disb : ');
2312: END IF;
2313:
2314: ln_rem_disb_cnt := 0;
2315: FOR lc_get_remain_disb IN c_get_remain_disb(g_award_id) LOOP

Line 2381: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_gr_li_import.import_pell_orig.debug', l_debug_str);

2377: fnd_file.put_line(fnd_file.log, g_disb_pad_str || fnd_message.get);
2378: END;
2379:
2380: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_runtime_level) THEN
2381: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_gr_li_import.import_pell_orig.debug', l_debug_str);
2382: l_debug_str := NULL;
2383: END IF;
2384:
2385: END LOOP; -- End of remaining disbs

Line 2393: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_gr_li_import.import_pell_orig.debug', l_debug_str || ' End of Pell Orig Import, return status : '|| l_pell_import_status);

2389: END IF; -- End of Error status <> 'E' to Import Pell Disb
2390:
2391: -- Return to the main routine
2392: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_runtime_level) THEN
2393: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_gr_li_import.import_pell_orig.debug', l_debug_str || ' End of Pell Orig Import, return status : '|| l_pell_import_status);
2394: l_debug_str := NULL;
2395: END IF;
2396:
2397: RETURN l_pell_import_status;

Line 2403: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'igf.plsql.igf_gr_li_import.import_pell_orig.exception', l_debug_str || SQLERRM );

2399: EXCEPTION
2400:
2401: WHEN OTHERS THEN
2402: IF(FND_LOG.LEVEL_EXCEPTION >= g_debug_runtime_level)THEN
2403: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'igf.plsql.igf_gr_li_import.import_pell_orig.exception', l_debug_str || SQLERRM );
2404: END IF;
2405: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2406: fnd_message.set_token('NAME','IGF_GR_LI_IMPORT.IMPORT_PELL_ORIG');
2407: igs_ge_msg_stack.add;

Line 2406: fnd_message.set_token('NAME','IGF_GR_LI_IMPORT.IMPORT_PELL_ORIG');

2402: IF(FND_LOG.LEVEL_EXCEPTION >= g_debug_runtime_level)THEN
2403: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'igf.plsql.igf_gr_li_import.import_pell_orig.exception', l_debug_str || SQLERRM );
2404: END IF;
2405: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2406: fnd_message.set_token('NAME','IGF_GR_LI_IMPORT.IMPORT_PELL_ORIG');
2407: igs_ge_msg_stack.add;
2408:
2409: END import_pell_orig;
2410:

Line 2575: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_gr_li_import.main.debug', ' ---- Request ID : '||fnd_global.conc_request_id

2571: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_runtime_level) THEN
2572: l_debug_str := l_debug_str || ', Cal Type : ' || g_cal_type;
2573: l_debug_str := l_debug_str || ', Sequence Num : ' || g_seq_number;
2574:
2575: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_gr_li_import.main.debug', ' ---- Request ID : '||fnd_global.conc_request_id
2576: ||' Conc Prgm Id : '||fnd_global.conc_program_id
2577: ||' Pgm appl Id : '||fnd_global.prog_appl_id
2578: ||' ----');
2579: END IF;

Line 2688: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_gr_li_import.main.debug', l_debug_str);

2684: CLOSE c_pell_orig_int;
2685:
2686: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_runtime_level) THEN
2687: l_debug_str := l_debug_str || ', Pell int records not found :: ';
2688: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_gr_li_import.main.debug', l_debug_str);
2689: l_debug_str := NULL;
2690: END IF;
2691: fnd_message.set_name('IGF','IGF_GR_LI_NO_RECORDS');
2692: fnd_file.put_line(fnd_file.log, fnd_message.get);

Line 2700: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_gr_li_import.main.debug', l_debug_str);

2696:
2697: -- Cache the temporary variables
2698: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_runtime_level) THEN
2699: l_debug_str := l_debug_str || ', Pell int records are present :: ';
2700: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_gr_li_import.main.debug', l_debug_str);
2701: l_debug_str := NULL;
2702: END IF;
2703:
2704: l_processing := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PROCESSING');

Line 3023: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'igf.plsql.igf_gr_li_import.main.internal Begin', l_debug_str || SQLERRM );

3019: NULL;
3020:
3021: WHEN OTHERS THEN
3022: IF(FND_LOG.LEVEL_EXCEPTION >= g_debug_runtime_level)THEN
3023: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'igf.plsql.igf_gr_li_import.main.internal Begin', l_debug_str || SQLERRM );
3024: END IF;
3025: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
3026: fnd_message.set_token('NAME','IGF_GR_LI_IMPORT.MAIN_SUB_BEGIN');
3027: igs_ge_msg_stack.add;

Line 3026: fnd_message.set_token('NAME','IGF_GR_LI_IMPORT.MAIN_SUB_BEGIN');

3022: IF(FND_LOG.LEVEL_EXCEPTION >= g_debug_runtime_level)THEN
3023: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'igf.plsql.igf_gr_li_import.main.internal Begin', l_debug_str || SQLERRM );
3024: END IF;
3025: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
3026: fnd_message.set_token('NAME','IGF_GR_LI_IMPORT.MAIN_SUB_BEGIN');
3027: igs_ge_msg_stack.add;
3028: app_exception.raise_exception;
3029: END; -- End of local begin
3030:

Line 3043: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_gr_li_import.main.debug', l_debug_str);

3039: FETCH c_pell_orig_int INTO lc_pell_orig_int;
3040: EXIT WHEN c_pell_orig_int%NOTFOUND;
3041:
3042: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_runtime_level) THEN
3043: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_gr_li_import.main.debug', l_debug_str);
3044: l_debug_str := NULL;
3045: END IF;
3046: l_debug_str := NULL;
3047:

Line 3086: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'igf.plsql.igf_gr_li_import.main.exception', l_debug_str || SQLERRM );

3082:
3083: EXCEPTION
3084: WHEN others THEN
3085: IF(FND_LOG.LEVEL_EXCEPTION >= g_debug_runtime_level)THEN
3086: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'igf.plsql.igf_gr_li_import.main.exception', l_debug_str || SQLERRM );
3087: END IF;
3088: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
3089: fnd_message.set_token('NAME','IGF_GR_LI_IMPORT.MAIN');
3090: errbuf := fnd_message.get;

Line 3089: fnd_message.set_token('NAME','IGF_GR_LI_IMPORT.MAIN');

3085: IF(FND_LOG.LEVEL_EXCEPTION >= g_debug_runtime_level)THEN
3086: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'igf.plsql.igf_gr_li_import.main.exception', l_debug_str || SQLERRM );
3087: END IF;
3088: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
3089: fnd_message.set_token('NAME','IGF_GR_LI_IMPORT.MAIN');
3090: errbuf := fnd_message.get;
3091: igs_ge_msg_stack.conc_exception_hndl;
3092:
3093: END main;

Line 3097: END igf_gr_li_import;

3093: END main;
3094:
3095:
3096:
3097: END igf_gr_li_import;