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_AW_ROLLOVER dependencies on FND_FILE

Line 146: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);

142:
143: fnd_message.set_name('IGF','IGF_AP_INST_ATTCH_TODO_ERR');
144: fnd_message.set_token('APPLICATION',l_get_fund_todo.application_code);
145: fnd_message.set_token('ITEM',l_todo_item);
146: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
147:
148: RETURN FALSE;
149: END IF;
150: END IF;

Line 780: fnd_file.new_line(fnd_file.log,1);

776: l_discontinued_flg VARCHAR2(1) := 'N';
777:
778: BEGIN
779:
780: fnd_file.new_line(fnd_file.log,1);
781: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','FUND_ATTRIBUTE')||':' );
782:
783: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
784: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_fund_attributes.debug','Processing Fund Attributes');

Line 781: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','FUND_ATTRIBUTE')||':' );

777:
778: BEGIN
779:
780: fnd_file.new_line(fnd_file.log,1);
781: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','FUND_ATTRIBUTE')||':' );
782:
783: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
784: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_fund_attributes.debug','Processing Fund Attributes');
785: END IF;

Line 792: fnd_file.put_line(fnd_file.log, RPAD(' ',5)|| fnd_message.get);

788: LOOP
789: BEGIN
790: fnd_message.set_name('IGF','IGF_AW_PROC_FUND');
791: fnd_message.set_token('FUND',l_fund.fund_code);
792: fnd_file.put_line(fnd_file.log, RPAD(' ',5)|| fnd_message.get);
793:
794: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
795: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_fund_attributes.debug','Fund :'||l_fund.fund_code);
796: END IF;

Line 802: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);

798: --Check whether the fund already got rolled over
799: IF fund_exists(l_fund.fund_code, p_to_cal_type, p_to_sequence_number) THEN
800: fnd_message.set_name('IGF','IGF_AW_FND_ALRDY_PRSNT');
801: fnd_message.set_token('FUND',l_fund.fund_code);
802: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
803:
804: RAISE E_SKIP_FUND;
805: END IF;
806:

Line 811: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);

807: --Check for discontinued fund
808: IF l_fund.discontinue_fund = 'Y' THEN
809: fnd_message.set_name('IGF','IGF_AW_FND_RLOVR_DISCONT');
810: fnd_message.set_token('FUND',l_fund.fund_code);
811: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
812:
813: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
814: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_fund_attributes.debug','Discontinued Fund');
815: END IF;

Line 832: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);

828:
829: IF l_new_fund_id IS NULL THEN
830: fnd_message.set_name('IGF','IGF_AW_INSERT_FUND_ERR');
831: fnd_message.set_token('FUND',l_fund.fund_code);
832: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
833:
834: ROLLBACK TO rollover_fund_attributes;
835: RAISE E_SKIP_FUND;
836:

Line 843: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);

839: --Skip the fund if creation of inclusive fund is not successful
840: IF NOT create_inclusive_fund(l_fund.fund_id, l_new_fund_id, p_frm_cal_type, p_frm_sequence_number, l_inclusive_fund) THEN
841: fnd_message.set_name('IGF','IGF_AW_FND_RLOVR_INCL_FLD');
842: fnd_message.set_token('FUND',l_inclusive_fund);
843: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
844:
845: ROLLBACK TO rollover_fund_attributes;
846: RAISE E_SKIP_FUND;
847: END IF;

Line 854: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);

850: --Skip the fund if creation of exclusive fund is not successful
851: IF NOT create_exclusive_fund(l_fund.fund_id, l_new_fund_id, p_frm_cal_type, p_frm_sequence_number, l_exclusive_fund) THEN
852: fnd_message.set_name('IGF','IGF_AW_FND_RLOVR_EXCL_FLD');
853: fnd_message.set_token('FUND',l_exclusive_fund);
854: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
855:
856: ROLLBACK TO rollover_fund_attributes;
857: RAISE E_SKIP_FUND;
858: END IF;

Line 865: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);

861: --Skip the fund if creation of pay program is not successful
862: IF NOT create_pay_program(l_fund.fund_id, l_new_fund_id, l_pay_program) THEN
863: fnd_message.set_name('IGF','IGF_AW_FND_PRG_ROLL');
864: fnd_message.set_token('PROGRAM',l_pay_program);
865: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
866:
867: ROLLBACK TO rollover_fund_attributes;
868: RAISE E_SKIP_FUND;
869: END IF;

Line 876: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);

872: --Skip the fund if creation of pay unit is not successful
873: IF NOT create_pay_unit(l_fund.fund_id, l_new_fund_id, l_pay_unit) THEN
874: fnd_message.set_name('IGF','IGF_AW_FND_UNIT_ROLL');
875: fnd_message.set_token('UNIT',l_pay_unit);
876: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
877:
878: ROLLBACK TO rollover_fund_attributes;
879: RAISE E_SKIP_FUND;
880: END IF;

Line 887: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);

883: --Skip the fund if creation of pay feeclass is not successful
884: IF NOT create_pay_feeclass(l_fund.fund_id, l_new_fund_id, l_fee_class) THEN
885: fnd_message.set_name('IGF','IGF_AW_FND_FEECLS_ROLL');
886: fnd_message.set_token('FEE_CLASS',l_fee_class);
887: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
888:
889: ROLLBACK TO rollover_fund_attributes;
890: RAISE E_SKIP_FUND;
891: END IF;

Line 898: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);

894: --Skip the fund if creation of fund todo is not successful
895: IF NOT create_fund_todo(l_fund.fund_id,l_new_fund_id,p_frm_cal_type,p_frm_sequence_number,p_to_cal_type,p_to_sequence_number,l_todo_item) THEN
896: fnd_message.set_name('IGF','IGF_AW_FND_TODO_ROLL');
897: fnd_message.set_token('TODO_ITEM',l_todo_item);
898: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
899:
900: ROLLBACK TO rollover_fund_attributes;
901: RAISE E_SKIP_FUND;
902: END IF;

Line 909: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);

905:
906: COMMIT;
907: fnd_message.set_name('IGF','IGF_AW_FND_RLOVR_FND_SUCCFL');
908: fnd_message.set_token('FUND',l_fund.fund_code);
909: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
910:
911: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
912: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_fund_attributes.debug','Successfully rolled over fund :'||l_fund.fund_code);
913: END IF;

Line 919: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);

915: WHEN E_SKIP_FUND THEN
916: IF l_discontinued_flg = 'N' THEN
917: fnd_message.set_name('IGF','IGF_AW_SKIPPING_FUND');
918: fnd_message.set_token('FUND_CODE',l_fund.fund_code);
919: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
920: END IF;
921:
922: l_discontinued_flg := 'N';
923:

Line 1082: fnd_file.new_line(fnd_file.log,1);

1078: l_error_occurred VARCHAR2(1) := 'N';
1079:
1080: BEGIN
1081:
1082: fnd_file.new_line(fnd_file.log,1);
1083: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','COA_RATE_TABLE')||':' );
1084:
1085: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1086: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_rate_setups.debug','Processing Rate Based Setups');

Line 1083: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','COA_RATE_TABLE')||':' );

1079:
1080: BEGIN
1081:
1082: fnd_file.new_line(fnd_file.log,1);
1083: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','COA_RATE_TABLE')||':' );
1084:
1085: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1086: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_rate_setups.debug','Processing Rate Based Setups');
1087: END IF;

Line 1096: fnd_file.put_line(fnd_file.log, RPAD(' ',5)|| fnd_message.get);

1092: SAVEPOINT rollover_rate_setups;
1093:
1094: fnd_message.set_name('IGF','IGF_AW_PROC_COA_ITEM');
1095: fnd_message.set_token('ITEM',l_get_itm_code.item_code);
1096: fnd_file.put_line(fnd_file.log, RPAD(' ',5)|| fnd_message.get);
1097:
1098: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1099: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_rate_setups.debug','COA Item :'||l_get_itm_code.item_code);
1100: END IF;

Line 1106: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);

1102: --Check whether the item already got rolled over
1103: IF rate_setup_exists(l_get_itm_code.item_code, p_to_cal_type, p_to_sequence_number) THEN
1104: fnd_message.set_name('IGF','IGF_AW_ITM_ALRDY_EXISTS');
1105: fnd_message.set_token('ITEM',l_get_itm_code.item_code);
1106: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
1107:
1108: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1109: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_rate_setups.debug','COA Item already ecists :'||l_get_itm_code.item_code);
1110: END IF;

Line 1126: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);

1122: fnd_message.set_name('IGF','IGF_AW_TRM_NT_EXISTS');
1123: fnd_message.set_token('ITEM',l_rate_setup.item_code);
1124: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(l_rate_setup.ld_cal_type,l_rate_setup.ld_sequence_number));
1125:
1126: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
1127: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1128: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_rate_setups.debug','Calendar Mapping does not exist');
1129: END IF;
1130:

Line 1168: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);

1164: COMMIT;
1165:
1166: fnd_message.set_name('IGF','IGF_AW_RT_RLOVR_SUCCFL');
1167: fnd_message.set_token('ITEM',l_get_itm_code.item_code);
1168: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
1169:
1170: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1171: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_rate_setups.debug','Successfully rolled over coa item :'||l_get_itm_code.item_code);
1172: END IF;

Line 1182: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);

1178: WHEN E_SKIP_ITEM THEN
1179: ROLLBACK TO rollover_rate_setups;
1180: fnd_message.set_name('IGF','IGF_AW_SKIPPING_ITEM');
1181: fnd_message.set_token('ITEM',l_get_itm_code.item_code);
1182: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
1183:
1184: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1185: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_rollover.rollover_rate_setups.exception','Skipping the item :'||l_get_itm_code.item_code);
1186: END IF;

Line 1266: fnd_file.new_line(fnd_file.log,1);

1262: l_to_ld_cal_type igs_ca_inst_all.cal_type%TYPE;
1263: l_to_ld_sequence_number igs_ca_inst_all.sequence_number%TYPE;
1264:
1265: BEGIN
1266: fnd_file.new_line(fnd_file.log,1);
1267: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','INST_APPLICATION')||':' );
1268:
1269: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1270: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_inst_applications.debug','Processing Institutional Applications');

Line 1267: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','INST_APPLICATION')||':' );

1263: l_to_ld_sequence_number igs_ca_inst_all.sequence_number%TYPE;
1264:
1265: BEGIN
1266: fnd_file.new_line(fnd_file.log,1);
1267: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','INST_APPLICATION')||':' );
1268:
1269: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1270: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_inst_applications.debug','Processing Institutional Applications');
1271: END IF;

Line 1280: fnd_file.put_line(fnd_file.log, RPAD(' ',5)|| fnd_message.get);

1276: SAVEPOINT rollover_inst_applications;
1277:
1278: fnd_message.set_name('IGF','IGF_AP_PROC_INST_APLN');
1279: fnd_message.set_token('APPLICATION',l_get_appln_code.application_code);
1280: fnd_file.put_line(fnd_file.log, RPAD(' ',5)|| fnd_message.get);
1281:
1282: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1283: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_inst_applications.debug','Application :'||l_get_appln_code.application_code);
1284: END IF;

Line 1293: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);

1289: IF c_appln_exists%FOUND THEN
1290: CLOSE c_appln_exists;
1291: fnd_message.set_name('IGF','IGF_AP_INST_APLN_ALRDY_EXT');
1292: fnd_message.set_token('APPLICATION',l_get_appln_code.application_code);
1293: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
1294:
1295: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1296: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_inst_applications.debug','Application already exists');
1297: END IF;

Line 1316: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);

1312: fnd_message.set_name('IGF','IGF_AP_QUES_TRM_NT_EXISTS');
1313: fnd_message.set_token('QUESTION',l_inst_appln_setup.question);
1314: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(l_inst_appln_setup.ld_cal_type,l_inst_appln_setup.ld_sequence_number));
1315:
1316: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
1317: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1318: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_inst_applications.debug','Calendar Mapping does not exist');
1319: END IF;
1320:

Line 1365: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);

1361: l_error_occurred := 'Y';
1362:
1363: fnd_message.set_name('IGF','IGF_AP_APLN_QUES_ROLL');
1364: fnd_message.set_token('QUESTION',l_inst_appln_setup.question);
1365: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
1366:
1367: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1368: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_rollover.rollover_inst_applications.exception','Skipping Question ID :'||l_inst_appln_setup.question_id);
1369: END IF;

Line 1378: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);

1374: COMMIT;
1375:
1376: fnd_message.set_name('IGF','IGF_AP_APLN_RLOVR_SUCCFL');
1377: fnd_message.set_token('APPLICATION',l_get_appln_code.application_code);
1378: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
1379:
1380: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1381: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_inst_applications.debug','Successfully rolled over Application :'||l_get_appln_code.application_code);
1382: END IF;

Line 1393: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);

1389: ROLLBACK TO rollover_inst_applications;
1390:
1391: fnd_message.set_name('IGF','IGF_AP_SKIPPING_INST_APLN');
1392: fnd_message.set_token('APPLICATION',l_get_appln_code.application_code);
1393: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
1394:
1395: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1396: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_rollover.rollover_inst_applications.exception','Skipping the application :'||l_get_appln_code.application_code);
1397: END IF;

Line 1606: fnd_file.new_line(fnd_file.log,1);

1602: l_error_occurred VARCHAR2(1) := 'N';
1603:
1604: BEGIN
1605:
1606: fnd_file.new_line(fnd_file.log,1);
1607: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWD_DISTRIBUTION_PLAN')||':' );
1608:
1609: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1610: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_distribution_plans.debug','Processing Award Distribution Plans');

Line 1607: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWD_DISTRIBUTION_PLAN')||':' );

1603:
1604: BEGIN
1605:
1606: fnd_file.new_line(fnd_file.log,1);
1607: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWD_DISTRIBUTION_PLAN')||':' );
1608:
1609: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1610: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_distribution_plans.debug','Processing Award Distribution Plans');
1611: END IF;

Line 1621: fnd_file.put_line(fnd_file.log, RPAD(' ',5)|| fnd_message.get);

1617: SAVEPOINT rollover_distribution_plans;
1618:
1619: fnd_message.set_name('IGF','IGF_AW_PROC_DIST_PLAN');
1620: fnd_message.set_token('PLAN',l_distb_plan_setup.awd_dist_plan_cd);
1621: fnd_file.put_line(fnd_file.log, RPAD(' ',5)|| fnd_message.get);
1622:
1623: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1624: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_distribution_plans.debug','Distribution Plan :'||l_distb_plan_setup.awd_dist_plan_cd);
1625: END IF;

Line 1634: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);

1630: IF c_plan_exists%FOUND THEN
1631: CLOSE c_plan_exists;
1632: fnd_message.set_name('IGF','IGF_AW_PLN_ALRDY_EXISTS');
1633: fnd_message.set_token('PLAN',l_distb_plan_setup.awd_dist_plan_cd);
1634: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
1635:
1636: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1637: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_distribution_plans.debug','Distribution Plan already exists');
1638: END IF;

Line 1664: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);

1660: --chech whether term mapping exists or not
1661: IF NOT chk_calendar_mapping(l_distb_plan_term.ld_cal_type,l_distb_plan_term.ld_sequence_number,l_to_ld_cal_type,l_to_ld_sequence_number) THEN
1662: fnd_message.set_name('IGF','IGF_AW_TRM_MAP_NT_FND');
1663: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(l_distb_plan_term.ld_cal_type,l_distb_plan_term.ld_sequence_number));
1664: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
1665:
1666: l_error_occurred := 'Y';
1667: END IF;
1668:

Line 1693: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);

1689: --chech whether teaching period mapping exists or not
1690: IF NOT chk_calendar_mapping(l_distb_plan_tp.tp_cal_type,l_distb_plan_tp.tp_sequence_number,l_to_tp_cal_type,l_to_tp_sequence_number) THEN
1691: fnd_message.set_name('IGF','IGF_AW_TP_MAP_NT_FND');
1692: fnd_message.set_token('PERIOD',igf_gr_gen.get_alt_code(l_distb_plan_tp.tp_cal_type,l_distb_plan_tp.tp_sequence_number));
1693: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
1694:
1695: l_error_occurred := 'Y';
1696: END IF;
1697:

Line 1723: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);

1719: COMMIT;
1720:
1721: fnd_message.set_name('IGF','IGF_AW_PLN_RLOVR_SUCCFL');
1722: fnd_message.set_token('PLAN',l_distb_plan_setup.awd_dist_plan_cd);
1723: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
1724:
1725: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1726: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_distribution_plans.debug','Successfully rolled over distribution plan :'||l_distb_plan_setup.awd_dist_plan_cd);
1727: END IF;

Line 1737: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);

1733: WHEN E_SKIP_PLAN THEN
1734: ROLLBACK TO rollover_distribution_plans;
1735: fnd_message.set_name('IGF','IGF_AW_SKIPPING_PLAN');
1736: fnd_message.set_token('PLAN',l_distb_plan_setup.awd_dist_plan_cd);
1737: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
1738:
1739: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1740: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_rollover.rollover_distribution_plans.exception','Skipping the distribution plan :'||l_distb_plan_setup.awd_dist_plan_cd);
1741: END IF;

Line 1861: fnd_file.new_line(fnd_file.log,1);

1857: l_error_occurred VARCHAR2(1) := 'N';
1858:
1859: BEGIN
1860:
1861: fnd_file.new_line(fnd_file.log,1);
1862: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','COA_GROUP')||':' );
1863:
1864: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1865: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_coa_groups.debug','Processing COA Groups');

Line 1862: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','COA_GROUP')||':' );

1858:
1859: BEGIN
1860:
1861: fnd_file.new_line(fnd_file.log,1);
1862: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','COA_GROUP')||':' );
1863:
1864: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1865: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_coa_groups.debug','Processing COA Groups');
1866: END IF;

Line 1876: fnd_file.put_line(fnd_file.log, RPAD(' ',5)|| fnd_message.get);

1872: SAVEPOINT rollover_coa_groups;
1873:
1874: fnd_message.set_name('IGF','IGF_AW_PROC_COA_GROUP');
1875: fnd_message.set_token('COA_GROUP',l_coa_grp_setup.coa_code);
1876: fnd_file.put_line(fnd_file.log, RPAD(' ',5)|| fnd_message.get);
1877:
1878: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1879: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_coa_groups.debug','COA Group :'||l_coa_grp_setup.coa_code);
1880: END IF;

Line 1890: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);

1886: IF c_coa_grp_exists%FOUND THEN
1887: CLOSE c_coa_grp_exists;
1888: fnd_message.set_name('IGF','IGF_AW_COA_GRP_ALRDY_EXISTS');
1889: fnd_message.set_token('COA_GROUP',l_coa_grp_setup.coa_code);
1890: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
1891:
1892: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1893: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_coa_groups.debug','COA Group already exists');
1894: END IF;

Line 1939: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);

1935: IF c_coa_itm_exists%NOTFOUND THEN
1936: fnd_message.set_name('IGF','IGF_AW_RT_SETUP_NT_EXISTS');
1937: fnd_message.set_token('ITEM',l_coa_item.item_code);
1938: fnd_message.set_token('AWARD_YEAR',igf_gr_gen.get_alt_code(p_to_cal_type,p_to_sequence_number));
1939: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
1940:
1941: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1942: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_coa_groups.debug','Rate Setup does not exist in the target award year');
1943: END IF;

Line 1989: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);

1985: --chech whether term mapping exists or not
1986: IF NOT chk_calendar_mapping(l_ld_coa.ld_cal_type,l_ld_coa.ld_sequence_number,l_to_ld_cal_type,l_to_ld_sequence_number) THEN
1987: fnd_message.set_name('IGF','IGF_AW_TRM_MAP_NT_FND');
1988: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(l_ld_coa.ld_cal_type,l_ld_coa.ld_sequence_number));
1989: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
1990:
1991: l_error_occurred := 'Y';
1992: END IF;
1993:

Line 2025: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);

2021: --fnd_message.set_name('IGF','IGF_AW_TRM_MAP_NT_FND');
2022: fnd_message.set_name('IGF','IGF_AW_TRM_NT_EXISTS');
2023: fnd_message.set_token('ITEM',l_overridden_item.item_code);
2024: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(l_overridden_item.ld_cal_type,l_overridden_item.ld_sequence_number));
2025: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
2026:
2027: l_error_occurred := 'Y';
2028: END IF;
2029:

Line 2052: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);

2048: IF l_error_occurred = 'N' THEN
2049: COMMIT;
2050: fnd_message.set_name('IGF','IGF_AW_COA_GRP_RLOVR_SUCCFL');
2051: fnd_message.set_token('COA_GROUP',l_coa_grp_setup.coa_code);
2052: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
2053:
2054: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2055: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_coa_groups.debug','Successfully rolled over coa group :'||l_coa_grp_setup.coa_code);
2056: END IF;

Line 2066: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);

2062: WHEN E_SKIP_COA_GRP THEN
2063: ROLLBACK TO rollover_coa_groups;
2064: fnd_message.set_name('IGF','IGF_AW_SKIPPING_COA_GRP');
2065: fnd_message.set_token('COA_GROUP',l_coa_grp_setup.coa_code);
2066: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
2067:
2068: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
2069: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_rollover.rollover_coa_groups.exception','Skipping the COA group :'||l_coa_grp_setup.coa_code);
2070: END IF;

Line 2133: fnd_file.new_line(fnd_file.log,1);

2129: lv_return_flg VARCHAR2(1);
2130:
2131: BEGIN
2132:
2133: fnd_file.new_line(fnd_file.log,1);
2134: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','TODO_ITEM')||':' );
2135:
2136: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2137: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_todo_items.debug','Processing To Do Items');

Line 2134: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','TODO_ITEM')||':' );

2130:
2131: BEGIN
2132:
2133: fnd_file.new_line(fnd_file.log,1);
2134: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','TODO_ITEM')||':' );
2135:
2136: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2137: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_todo_items.debug','Processing To Do Items');
2138: END IF;

Line 2148: fnd_file.put_line(fnd_file.log, RPAD(' ',5)|| fnd_message.get);

2144: SAVEPOINT rollover_todo_items;
2145:
2146: fnd_message.set_name('IGF','IGF_AP_PROC_TODO_ITEM');
2147: fnd_message.set_token('ITEM',l_todo_item_setup.item_code);
2148: fnd_file.put_line(fnd_file.log, RPAD(' ',5)|| fnd_message.get);
2149:
2150: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2151: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_todo_items.debug','To Do Item :'||l_todo_item_setup.item_code);
2152: END IF;

Line 2161: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);

2157: IF c_todo_exists%FOUND THEN
2158: CLOSE c_todo_exists;
2159: fnd_message.set_name('IGF','IGF_AP_TODO_ALRDY_EXISTS');
2160: fnd_message.set_token('ITEM',l_todo_item_setup.item_code);
2161: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
2162:
2163: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2164: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_todo_items.debug','To Do Item already exists');
2165: END IF;

Line 2207: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);

2203: IF lv_return_flg = 'Y' THEN
2204: fnd_message.set_name('IGF','IGF_AP_INST_ATTCH_TODO_ERR');
2205: fnd_message.set_token('APPLICATION',l_todo_item_setup.application_code);
2206: fnd_message.set_token('ITEM',l_todo_item_setup.item_code);
2207: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
2208:
2209: RAISE E_SKIP_TODO;
2210: END IF;
2211: END IF;

Line 2217: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);

2213: COMMIT;
2214:
2215: fnd_message.set_name('IGF','IGF_AP_TODO_RLOVR_SUCCFL');
2216: fnd_message.set_token('ITEM',l_todo_item_setup.item_code);
2217: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
2218:
2219: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2220: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_todo_items.debug','Successfully rolled over To Do Item :'||l_todo_item_setup.item_code);
2221: END IF;

Line 2227: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);

2223: EXCEPTION
2224: WHEN E_SKIP_TODO THEN
2225: fnd_message.set_name('IGF','IGF_AP_SKIPPING_TODO');
2226: fnd_message.set_token('ITEM',l_todo_item_setup.item_code);
2227: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
2228:
2229: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
2230: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_rollover.rollover_todo_items.exception','Skipping the To Do Item :'||l_todo_item_setup.item_code);
2231: END IF;

Line 2440: fnd_file.new_line(fnd_file.log,1);

2436: l_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE := NULL;
2437:
2438: BEGIN
2439:
2440: fnd_file.new_line(fnd_file.log,1);
2441: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWD_GROUP')||':' );
2442:
2443: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2444: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_award_groups.debug','Processing Award Groups');

Line 2441: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWD_GROUP')||':' );

2437:
2438: BEGIN
2439:
2440: fnd_file.new_line(fnd_file.log,1);
2441: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWD_GROUP')||':' );
2442:
2443: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2444: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_award_groups.debug','Processing Award Groups');
2445: END IF;

Line 2455: fnd_file.put_line(fnd_file.log, RPAD(' ',5)|| fnd_message.get);

2451: l_error_occurred := 'N';
2452:
2453: fnd_message.set_name('IGF','IGF_AW_PROC_AWD_GROUP');
2454: fnd_message.set_token('AWD_GROUP',l_award_grp_setup.group_cd);
2455: fnd_file.put_line(fnd_file.log, RPAD(' ',5)|| fnd_message.get);
2456:
2457: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2458: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_award_groups.debug','Award Group :'||l_award_grp_setup.group_cd);
2459: END IF;

Line 2469: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);

2465: IF c_grp_exists%FOUND THEN
2466: CLOSE c_grp_exists;
2467: fnd_message.set_name('IGF','IGF_AW_AWD_GRP_ALRDY_EXISTS');
2468: fnd_message.set_token('AWD_GROUP',l_award_grp_setup.group_cd);
2469: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
2470:
2471: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2472: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_award_groups.debug','Award Group already exists');
2473: END IF;

Line 2489: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);

2485: IF c_plan_exists%NOTFOUND THEN
2486: fnd_message.set_name('IGF','IGF_AW_DIST_PLN_NT_EXISTS');
2487: fnd_message.set_token('PLAN',get_plan_cd(l_award_grp_setup.adplans_id, p_frm_cal_type, p_frm_sequence_number));
2488: fnd_message.set_token('AWARD_YEAR',igf_gr_gen.get_alt_code(p_to_cal_type,p_to_sequence_number));
2489: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
2490:
2491: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2492: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_award_groups.debug','Distribution Plan does not exist');
2493: END IF;

Line 2560: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);

2556: IF c_fund_exists%NOTFOUND THEN
2557: fnd_message.set_name('IGF','IGF_AW_FUND_NT_EXISTS');
2558: fnd_message.set_token('FUND',get_fund_cd(l_formula_setup.fund_id, p_frm_cal_type, p_frm_sequence_number));
2559: fnd_message.set_token('AWARD_YEAR',igf_gr_gen.get_alt_code(p_to_cal_type,p_to_sequence_number));
2560: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
2561:
2562: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2563: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_award_groups.debug','Fund does not exist');
2564: END IF;

Line 2580: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);

2576: IF c_plan_exists%NOTFOUND THEN
2577: fnd_message.set_name('IGF','IGF_AW_DIST_PLN_OVR_NT_EXISTS');
2578: fnd_message.set_token('PLAN',get_plan_cd(l_formula_setup.adplans_id, p_frm_cal_type, p_frm_sequence_number));
2579: fnd_message.set_token('AWARD_YEAR',igf_gr_gen.get_alt_code(p_to_cal_type,p_to_sequence_number));
2580: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
2581:
2582: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2583: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_award_groups.debug','Award Distribution Plan does not exist');
2584: END IF;

Line 2621: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);

2617: COMMIT;
2618:
2619: fnd_message.set_name('IGF','IGF_AW_AWD_GRP_RLOVR_SUCCFL');
2620: fnd_message.set_token('AWD_GROUP',l_award_grp_setup.group_cd);
2621: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
2622:
2623: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2624: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_award_groups.debug','Successfully rolled over award group :'||l_award_grp_setup.group_cd);
2625: END IF;

Line 2635: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);

2631: WHEN E_SKIP_AWARD_GRP THEN
2632: ROLLBACK TO rollover_award_groups;
2633: fnd_message.set_name('IGF','IGF_AW_SKIPPING_AWD_GRP');
2634: fnd_message.set_token('AWD_GROUP',l_award_grp_setup.group_cd);
2635: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
2636:
2637: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
2638: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_rollover.rollover_award_groups.exception','Skipping the Award Group :'||l_award_grp_setup.group_cd);
2639: END IF;

Line 2904: fnd_file.new_line(fnd_file.log,1);

2900: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.main.debug','p_todo:'||p_todo);
2901: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.main.debug','p_award_grp:'||p_award_grp);
2902: END IF;
2903:
2904: fnd_file.new_line(fnd_file.log,1);
2905:
2906: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PARAMETER_PASS'));
2907: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','FROM_AWD_YEAR'),60) || igf_gr_gen.get_alt_code(lv_frm_cal_type,ln_frm_sequence_number));
2908: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','TO_AWD_YEAR'),60) || igf_gr_gen.get_alt_code(lv_to_cal_type,ln_to_sequence_number));

Line 2906: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PARAMETER_PASS'));

2902: END IF;
2903:
2904: fnd_file.new_line(fnd_file.log,1);
2905:
2906: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PARAMETER_PASS'));
2907: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','FROM_AWD_YEAR'),60) || igf_gr_gen.get_alt_code(lv_frm_cal_type,ln_frm_sequence_number));
2908: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','TO_AWD_YEAR'),60) || igf_gr_gen.get_alt_code(lv_to_cal_type,ln_to_sequence_number));
2909:
2910: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','FUND_ATTRIBUTE'),60) ||p_fund_attribute );

Line 2907: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','FROM_AWD_YEAR'),60) || igf_gr_gen.get_alt_code(lv_frm_cal_type,ln_frm_sequence_number));

2903:
2904: fnd_file.new_line(fnd_file.log,1);
2905:
2906: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PARAMETER_PASS'));
2907: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','FROM_AWD_YEAR'),60) || igf_gr_gen.get_alt_code(lv_frm_cal_type,ln_frm_sequence_number));
2908: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','TO_AWD_YEAR'),60) || igf_gr_gen.get_alt_code(lv_to_cal_type,ln_to_sequence_number));
2909:
2910: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','FUND_ATTRIBUTE'),60) ||p_fund_attribute );
2911: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','COA_RATE_TABLE'),60) ||p_rate_table );

Line 2908: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','TO_AWD_YEAR'),60) || igf_gr_gen.get_alt_code(lv_to_cal_type,ln_to_sequence_number));

2904: fnd_file.new_line(fnd_file.log,1);
2905:
2906: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PARAMETER_PASS'));
2907: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','FROM_AWD_YEAR'),60) || igf_gr_gen.get_alt_code(lv_frm_cal_type,ln_frm_sequence_number));
2908: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','TO_AWD_YEAR'),60) || igf_gr_gen.get_alt_code(lv_to_cal_type,ln_to_sequence_number));
2909:
2910: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','FUND_ATTRIBUTE'),60) ||p_fund_attribute );
2911: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','COA_RATE_TABLE'),60) ||p_rate_table );
2912: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','INST_APPLICATION'),60) ||p_inst_application );

Line 2910: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','FUND_ATTRIBUTE'),60) ||p_fund_attribute );

2906: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PARAMETER_PASS'));
2907: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','FROM_AWD_YEAR'),60) || igf_gr_gen.get_alt_code(lv_frm_cal_type,ln_frm_sequence_number));
2908: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','TO_AWD_YEAR'),60) || igf_gr_gen.get_alt_code(lv_to_cal_type,ln_to_sequence_number));
2909:
2910: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','FUND_ATTRIBUTE'),60) ||p_fund_attribute );
2911: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','COA_RATE_TABLE'),60) ||p_rate_table );
2912: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','INST_APPLICATION'),60) ||p_inst_application );
2913: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWD_DISTRIBUTION_PLAN'),60) ||p_distribution_plan );
2914: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','COA_GROUP'),60) ||p_coa_group );

Line 2911: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','COA_RATE_TABLE'),60) ||p_rate_table );

2907: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','FROM_AWD_YEAR'),60) || igf_gr_gen.get_alt_code(lv_frm_cal_type,ln_frm_sequence_number));
2908: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','TO_AWD_YEAR'),60) || igf_gr_gen.get_alt_code(lv_to_cal_type,ln_to_sequence_number));
2909:
2910: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','FUND_ATTRIBUTE'),60) ||p_fund_attribute );
2911: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','COA_RATE_TABLE'),60) ||p_rate_table );
2912: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','INST_APPLICATION'),60) ||p_inst_application );
2913: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWD_DISTRIBUTION_PLAN'),60) ||p_distribution_plan );
2914: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','COA_GROUP'),60) ||p_coa_group );
2915: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','TODO_ITEM'),60) ||p_todo );

Line 2912: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','INST_APPLICATION'),60) ||p_inst_application );

2908: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','TO_AWD_YEAR'),60) || igf_gr_gen.get_alt_code(lv_to_cal_type,ln_to_sequence_number));
2909:
2910: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','FUND_ATTRIBUTE'),60) ||p_fund_attribute );
2911: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','COA_RATE_TABLE'),60) ||p_rate_table );
2912: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','INST_APPLICATION'),60) ||p_inst_application );
2913: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWD_DISTRIBUTION_PLAN'),60) ||p_distribution_plan );
2914: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','COA_GROUP'),60) ||p_coa_group );
2915: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','TODO_ITEM'),60) ||p_todo );
2916: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWD_GROUP'),60) ||p_award_grp );

Line 2913: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWD_DISTRIBUTION_PLAN'),60) ||p_distribution_plan );

2909:
2910: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','FUND_ATTRIBUTE'),60) ||p_fund_attribute );
2911: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','COA_RATE_TABLE'),60) ||p_rate_table );
2912: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','INST_APPLICATION'),60) ||p_inst_application );
2913: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWD_DISTRIBUTION_PLAN'),60) ||p_distribution_plan );
2914: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','COA_GROUP'),60) ||p_coa_group );
2915: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','TODO_ITEM'),60) ||p_todo );
2916: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWD_GROUP'),60) ||p_award_grp );
2917:

Line 2914: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','COA_GROUP'),60) ||p_coa_group );

2910: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','FUND_ATTRIBUTE'),60) ||p_fund_attribute );
2911: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','COA_RATE_TABLE'),60) ||p_rate_table );
2912: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','INST_APPLICATION'),60) ||p_inst_application );
2913: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWD_DISTRIBUTION_PLAN'),60) ||p_distribution_plan );
2914: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','COA_GROUP'),60) ||p_coa_group );
2915: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','TODO_ITEM'),60) ||p_todo );
2916: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWD_GROUP'),60) ||p_award_grp );
2917:
2918: fnd_file.new_line(fnd_file.log,2);

Line 2915: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','TODO_ITEM'),60) ||p_todo );

2911: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','COA_RATE_TABLE'),60) ||p_rate_table );
2912: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','INST_APPLICATION'),60) ||p_inst_application );
2913: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWD_DISTRIBUTION_PLAN'),60) ||p_distribution_plan );
2914: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','COA_GROUP'),60) ||p_coa_group );
2915: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','TODO_ITEM'),60) ||p_todo );
2916: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWD_GROUP'),60) ||p_award_grp );
2917:
2918: fnd_file.new_line(fnd_file.log,2);
2919:

Line 2916: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWD_GROUP'),60) ||p_award_grp );

2912: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','INST_APPLICATION'),60) ||p_inst_application );
2913: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWD_DISTRIBUTION_PLAN'),60) ||p_distribution_plan );
2914: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','COA_GROUP'),60) ||p_coa_group );
2915: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','TODO_ITEM'),60) ||p_todo );
2916: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWD_GROUP'),60) ||p_award_grp );
2917:
2918: fnd_file.new_line(fnd_file.log,2);
2919:
2920: fnd_file.put_line(fnd_file.log,'-------------------------------------------------------');

Line 2918: fnd_file.new_line(fnd_file.log,2);

2914: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','COA_GROUP'),60) ||p_coa_group );
2915: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','TODO_ITEM'),60) ||p_todo );
2916: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWD_GROUP'),60) ||p_award_grp );
2917:
2918: fnd_file.new_line(fnd_file.log,2);
2919:
2920: fnd_file.put_line(fnd_file.log,'-------------------------------------------------------');
2921:
2922:

Line 2920: fnd_file.put_line(fnd_file.log,'-------------------------------------------------------');

2916: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWD_GROUP'),60) ||p_award_grp );
2917:
2918: fnd_file.new_line(fnd_file.log,2);
2919:
2920: fnd_file.put_line(fnd_file.log,'-------------------------------------------------------');
2921:
2922:
2923: -- Rollover Fund Attribute Setup
2924: IF NVL(p_fund_attribute,'N') = 'Y' THEN

Line 3018: fnd_file.new_line(fnd_file.log,1);

3014: );
3015: END IF;
3016:
3017:
3018: fnd_file.new_line(fnd_file.log,1);
3019: fnd_file.put_line(fnd_file.log,'-------------------------------------------------------');
3020:
3021: COMMIT;
3022:

Line 3019: fnd_file.put_line(fnd_file.log,'-------------------------------------------------------');

3015: END IF;
3016:
3017:
3018: fnd_file.new_line(fnd_file.log,1);
3019: fnd_file.put_line(fnd_file.log,'-------------------------------------------------------');
3020:
3021: COMMIT;
3022:
3023: EXCEPTION