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.IGS_PS_USEC_SCHEDULE dependencies on FND_FILE

Line 739: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

735: OPEN usec_x_grp_name(p_uoo_cur_rec.uoo_id);
736: FETCH usec_x_grp_name INTO l_usec_x_grp_name;
737: IF usec_x_grp_name%NOTFOUND THEN
738: FND_MESSAGE.SET_NAME('IGS','IGS_PS_NO_GRP_EXISTS');
739: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
740: l_usec_x_grp_name := NULL;
741: ROLLBACK;
742: retcode := 2;
743: RETURN;

Line 751: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

747: OPEN max_enr_x_grp(p_uoo_cur_rec.uoo_id);
748: FETCH max_enr_x_grp INTO l_max_enr_x_grp;
749: IF max_enr_x_grp%NOTFOUND THEN
750: FND_MESSAGE.SET_NAME('IGS','IGS_PS_NO_GRP_MAX_EXISTS');
751: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
752: l_max_enr_x_grp := NULL;
753: ROLLBACK;
754: retcode := 2;
755: RETURN;

Line 833: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

829: OPEN meet_with_grp_name(p_uoo_cur_rec.uoo_id);
830: FETCH meet_with_grp_name INTO l_meet_with_grp_name;
831: IF meet_with_grp_name%NOTFOUND THEN
832: FND_MESSAGE.SET_NAME('IGS','IGS_PS_NO_MEET_GRP_EXISTS');
833: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
834: ROLLBACK;
835: RETCODE := 2;
836: RETURN;
837: END IF;

Line 844: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

840: OPEN max_enr_meet_grp(p_uoo_cur_rec.uoo_id);
841: FETCH max_enr_meet_grp INTO l_max_enr_meet_grp;
842: IF max_enr_meet_grp%NOTFOUND THEN
843: FND_MESSAGE.SET_NAME('IGS','IGS_PS_NO_MEET_GRP_MAX_EXISTS');
844: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
845: ROLLBACK;
846: RETCODE := 2;
847: RETURN;
848: END IF;

Line 1344: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

1340: --and last name in the local variables l_lead_instructor_id, l_given_names ,l_middle_name and l_surname respectively.
1341: -- returns false only when lead instructor is set at unit section and could not fetch instructor details.
1342: IF NOT get_instructor_info(uoo_cur_rec.uoo_id) THEN
1343: FND_MESSAGE.SET_NAME('IGS','IGS_PS_NO_NAMES_EXISTS');
1344: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
1345: ROLLBACK;
1346: RETCODE := 2;
1347: RETURN;
1348: END IF;

Line 1424: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

1420: --Update all the production records for the abort_flag='N'
1421: FOR l_pattern_prod_rec IN c_pattern_prod(l_trans_id) LOOP
1422:
1423: --Log the pattern in the log file
1424: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1425: fnd_file.put_line(fnd_file.log, igs_ps_validate_lgcy_pkg.get_lkup_meaning('PATTERNS','IGS_PS_TABLE_NAME')||':');
1426: fnd_file.put_line(fnd_file.log, '**********');
1427: log_teach_cal(l_pattern_prod_rec.calendar_type,l_pattern_prod_rec.sequence_number);
1428: log_messages(igs_ps_validate_lgcy_pkg.get_lkup_meaning('UNIT_CD','LEGACY_TOKENS'),l_pattern_prod_rec.unit_cd,10);

Line 1425: fnd_file.put_line(fnd_file.log, igs_ps_validate_lgcy_pkg.get_lkup_meaning('PATTERNS','IGS_PS_TABLE_NAME')||':');

1421: FOR l_pattern_prod_rec IN c_pattern_prod(l_trans_id) LOOP
1422:
1423: --Log the pattern in the log file
1424: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1425: fnd_file.put_line(fnd_file.log, igs_ps_validate_lgcy_pkg.get_lkup_meaning('PATTERNS','IGS_PS_TABLE_NAME')||':');
1426: fnd_file.put_line(fnd_file.log, '**********');
1427: log_teach_cal(l_pattern_prod_rec.calendar_type,l_pattern_prod_rec.sequence_number);
1428: log_messages(igs_ps_validate_lgcy_pkg.get_lkup_meaning('UNIT_CD','LEGACY_TOKENS'),l_pattern_prod_rec.unit_cd,10);
1429: log_messages(igs_ps_validate_lgcy_pkg.get_lkup_meaning('VERSION_NUMBER','IGS_PS_LOG_PARAMETERS'),l_pattern_prod_rec.version_number,10);

Line 1426: fnd_file.put_line(fnd_file.log, '**********');

1422:
1423: --Log the pattern in the log file
1424: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1425: fnd_file.put_line(fnd_file.log, igs_ps_validate_lgcy_pkg.get_lkup_meaning('PATTERNS','IGS_PS_TABLE_NAME')||':');
1426: fnd_file.put_line(fnd_file.log, '**********');
1427: log_teach_cal(l_pattern_prod_rec.calendar_type,l_pattern_prod_rec.sequence_number);
1428: log_messages(igs_ps_validate_lgcy_pkg.get_lkup_meaning('UNIT_CD','LEGACY_TOKENS'),l_pattern_prod_rec.unit_cd,10);
1429: log_messages(igs_ps_validate_lgcy_pkg.get_lkup_meaning('VERSION_NUMBER','IGS_PS_LOG_PARAMETERS'),l_pattern_prod_rec.version_number,10);
1430:

Line 1456: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

1452: l_o_count:=1;
1453: FOR l_section_prod_rec IN c_section(l_pattern_prod_rec.int_pat_id) LOOP
1454:
1455: --Log the section in the log file
1456: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1457: IF l_o_count=1 THEN
1458: fnd_file.put_line(fnd_file.log, igs_ps_validate_lgcy_pkg.get_lkup_meaning('SECTIONS','IGS_PS_TABLE_NAME')||':');
1459: fnd_file.put_line(fnd_file.log, '----------');
1460: END IF;

Line 1458: fnd_file.put_line(fnd_file.log, igs_ps_validate_lgcy_pkg.get_lkup_meaning('SECTIONS','IGS_PS_TABLE_NAME')||':');

1454:
1455: --Log the section in the log file
1456: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1457: IF l_o_count=1 THEN
1458: fnd_file.put_line(fnd_file.log, igs_ps_validate_lgcy_pkg.get_lkup_meaning('SECTIONS','IGS_PS_TABLE_NAME')||':');
1459: fnd_file.put_line(fnd_file.log, '----------');
1460: END IF;
1461: log_messages(igs_ps_validate_lgcy_pkg.get_lkup_meaning('UNIT_CD','LEGACY_TOKENS'),l_section_prod_rec.unit_cd,10);
1462: log_messages(igs_ps_validate_lgcy_pkg.get_lkup_meaning('VERSION_NUMBER','IGS_PS_LOG_PARAMETERS'),l_section_prod_rec.version_number,10);

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

1455: --Log the section in the log file
1456: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1457: IF l_o_count=1 THEN
1458: fnd_file.put_line(fnd_file.log, igs_ps_validate_lgcy_pkg.get_lkup_meaning('SECTIONS','IGS_PS_TABLE_NAME')||':');
1459: fnd_file.put_line(fnd_file.log, '----------');
1460: END IF;
1461: log_messages(igs_ps_validate_lgcy_pkg.get_lkup_meaning('UNIT_CD','LEGACY_TOKENS'),l_section_prod_rec.unit_cd,10);
1462: log_messages(igs_ps_validate_lgcy_pkg.get_lkup_meaning('VERSION_NUMBER','IGS_PS_LOG_PARAMETERS'),l_section_prod_rec.version_number,10);
1463: log_messages(igs_ps_validate_lgcy_pkg.get_lkup_meaning('LOC','IGS_FI_ACCT_ENTITIES'),l_section_prod_rec.location_cd,10);

Line 1529: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

1525: l_o_count := 0;
1526: FOR l_occurrence_prod_rec IN c_occurrence(l_section_prod_rec.int_usec_id) LOOP
1527:
1528: --Log the occurrences in the log file
1529: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1530: IF l_o_count = 0 THEN
1531: fnd_file.put_line(fnd_file.log, igs_ps_validate_lgcy_pkg.get_lkup_meaning('OCCURRENCES','IGS_PS_TABLE_NAME')||':');
1532: fnd_file.put_line(fnd_file.log, '-------------');
1533: l_o_count:=1;

Line 1531: fnd_file.put_line(fnd_file.log, igs_ps_validate_lgcy_pkg.get_lkup_meaning('OCCURRENCES','IGS_PS_TABLE_NAME')||':');

1527:
1528: --Log the occurrences in the log file
1529: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1530: IF l_o_count = 0 THEN
1531: fnd_file.put_line(fnd_file.log, igs_ps_validate_lgcy_pkg.get_lkup_meaning('OCCURRENCES','IGS_PS_TABLE_NAME')||':');
1532: fnd_file.put_line(fnd_file.log, '-------------');
1533: l_o_count:=1;
1534: END IF;
1535: log_messages(igs_ps_validate_lgcy_pkg.get_lkup_meaning('USEC_OCCRS_ID','IGS_PS_LOG_PARAMETERS'),l_occurrence_prod_rec.occurrence_identifier,10);

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

1528: --Log the occurrences in the log file
1529: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1530: IF l_o_count = 0 THEN
1531: fnd_file.put_line(fnd_file.log, igs_ps_validate_lgcy_pkg.get_lkup_meaning('OCCURRENCES','IGS_PS_TABLE_NAME')||':');
1532: fnd_file.put_line(fnd_file.log, '-------------');
1533: l_o_count:=1;
1534: END IF;
1535: log_messages(igs_ps_validate_lgcy_pkg.get_lkup_meaning('USEC_OCCRS_ID','IGS_PS_LOG_PARAMETERS'),l_occurrence_prod_rec.occurrence_identifier,10);
1536:

Line 1635: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

1631: -- Give a message to user if the software is not installed and
1632: -- stop the further processing
1633: IF (NVL(FND_PROFILE.VALUE('IGS_PS_SCH_SOFT_NOT_INSTLD'),'N')) = 'N' THEN
1634: FND_MESSAGE.SET_NAME('IGS','IGS_PS_SCH_SOFT_NOT_INSTLD');
1635: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
1636: retcode := 2;
1637: RETURN;
1638: END IF;
1639:

Line 1644: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

1640:
1641: -- Not enough parameters condition
1642: IF ( (p_teach_prd IS NULL) AND (p_uoo_id IS NULL) AND (p_usec_id IS NULL ) AND (p_sch_type IS NULL) ) THEN
1643: FND_MESSAGE.SET_NAME('IGS','IGS_GE_NOT_ENGH_PARAM');
1644: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
1645: retcode := 2;
1646: RETURN;
1647: END IF;
1648:

Line 1658: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

1654: FETCH c_end_dt INTO rec_end_dt;
1655: CLOSE c_end_dt;
1656: IF TRUNC(rec_end_dt.cal_end_dt) < TRUNC(sysdate) THEN
1657: FND_MESSAGE.SET_NAME('IGS','IGS_PS_CANT_SCH_PAST_TP');
1658: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
1659: ROLLBACK;
1660: retcode := 2;
1661: RETURN;
1662: END IF;

Line 1670: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

1666: -- check the valid values for the sch_type
1667: IF p_sch_type IS NOT NULL AND p_sch_type NOT IN ('REQUEST', 'UPDATE', 'CANCEL' ) THEN
1668:
1669: FND_MESSAGE.SET_NAME('IGS','IGS_PS_INVALID_SCHTYPE');
1670: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
1671: retcode := 2;
1672: RETURN;
1673: END IF;
1674:

Line 1690: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

1686: -- Check for End date is <= sysdate
1687: -- Thus avoiding scheduling of past teaching periods.
1688: IF TRUNC(l_end_date) < TRUNC(sysdate) THEN
1689: FND_MESSAGE.SET_NAME('IGS','IGS_PS_CANT_SCH_PAST_TP');
1690: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
1691: ROLLBACK;
1692: retcode := 2;
1693: RETURN;
1694: END IF;

Line 1739: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

1735:
1736: -- if there exist no valid USO then transfer of data should not take place and rollback should take place for the earlier inserted records
1737: IF l_data_found = FALSE THEN
1738: FND_MESSAGE.SET_NAME('IGS','IGS_PS_NO_DATA_TRANSFER');
1739: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
1740: ROLLBACK;
1741: RETURN;
1742: END IF;
1743:

Line 1751: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

1747:
1748: -- End of Procedure
1749: retcode := 0;
1750: FND_MESSAGE.SET_NAME('IGS','IGS_PS_SCH_PRS_INIT_SUCCESS');
1751: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1752: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
1753:
1754: EXCEPTION
1755: WHEN OTHERS THEN

Line 1752: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

1748: -- End of Procedure
1749: retcode := 0;
1750: FND_MESSAGE.SET_NAME('IGS','IGS_PS_SCH_PRS_INIT_SUCCESS');
1751: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1752: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
1753:
1754: EXCEPTION
1755: WHEN OTHERS THEN
1756: ROLLBACK;

Line 1758: FND_FILE.PUT_LINE(FND_FILE.LOG,sqlerrm);

1754: EXCEPTION
1755: WHEN OTHERS THEN
1756: ROLLBACK;
1757: retcode:=2;
1758: FND_FILE.PUT_LINE(FND_FILE.LOG,sqlerrm);
1759: ERRBUF := FND_MESSAGE.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION') ;
1760: Igs_Ge_Msg_Stack.CONC_EXCEPTION_HNDL;
1761:
1762: END prgp_init_prs_sched;

Line 2981: fnd_file.put_line(fnd_file.LOG,' ' ||fnd_message.get);

2977: OPEN c_nstd_us(p_n_prd_uso_id);
2978: FETCH c_nstd_us INTO l_c_exists;
2979: IF c_nstd_us%FOUND THEN
2980: fnd_message.set_name('IGS','IGS_PS_SCH_TBA_USO_NSD_USEC');
2981: fnd_file.put_line(fnd_file.LOG,' ' ||fnd_message.get);
2982: END IF;
2983: CLOSE c_nstd_us;
2984: END IF;
2985:

Line 3135: fnd_file.put_line(fnd_file.log,fnd_message.get);

3131: IF (c_get_originator%NOTFOUND) THEN
3132: CLOSE c_get_originator;
3133: retcode:=2;
3134: fnd_message.set_name('IGS','IGS_GE_VAL_DOES_NOT_XS');
3135: fnd_file.put_line(fnd_file.log,fnd_message.get);
3136: app_exception.raise_exception;
3137: END IF;
3138: CLOSE c_get_originator; -- closing cursor for originator id
3139:

Line 3174: fnd_file.put_line(fnd_file.log,fnd_message.get);

3170: IF (c_ipsuo%NOTFOUND) THEN
3171: CLOSE c_ipsuo;
3172: retcode:=2;
3173: fnd_message.set_name('IGS','IGS_GE_VAL_DOES_NOT_XS');
3174: fnd_file.put_line(fnd_file.log,fnd_message.get);
3175: app_exception.raise_exception;
3176: END IF;
3177: -- This is added as part of bug#4287940
3178: l_tba_status := l_ipsuo.to_be_announced;

Line 3514: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

3510: -- interface table to production table, otherwise log the message ' NO valid record exists
3511: -- to import into the production table', added as a part of Bug # 2427725
3512: IF l_valid_rec_for_prod THEN
3513: FND_MESSAGE.SET_NAME('IGS','IGS_PS_SCH_GET_SCHD_SUCCESS');
3514: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
3515: ELSE
3516: -- Message is logged when there exists no scheduled records in interface table that needs to be
3517: -- transfer from Interface tables
3518: FND_MESSAGE.SET_NAME('IGS','IGS_PS_NO_SHD_REC_FRM_INT');

Line 3519: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

3515: ELSE
3516: -- Message is logged when there exists no scheduled records in interface table that needs to be
3517: -- transfer from Interface tables
3518: FND_MESSAGE.SET_NAME('IGS','IGS_PS_NO_SHD_REC_FRM_INT');
3519: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
3520: END IF;
3521:
3522: EXCEPTION
3523: WHEN OTHERS THEN

Line 3525: fnd_file.put_line(fnd_file.log, SQLERRM);

3521:
3522: EXCEPTION
3523: WHEN OTHERS THEN
3524: RETCODE:=2;
3525: fnd_file.put_line(fnd_file.log, SQLERRM);
3526: ERRBUF:=FND_MESSAGE.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION') || ' : ' || SQLERRM;
3527: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
3528: ROLLBACK;
3529: END prgp_get_schd_records ;

Line 3656: fnd_file.put_line(fnd_file.log,fnd_message.get);

3652:
3653: fnd_message.set_name('IGS','IGS_FI_CAL_BALANCES_LOG');
3654: fnd_message.set_token('PARAMETER_NAME',igs_ps_validate_lgcy_pkg.get_lkup_meaning('TEACHING_PERIOD','IGS_PS_LOG_PARAMETERS'));
3655: fnd_message.set_token('PARAMETER_VAL' ,p_teach_calendar);
3656: fnd_file.put_line(fnd_file.log,fnd_message.get);
3657:
3658: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_CD' )
3659: || ' : ' || p_unit_cd );
3660: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_VER_NUM' )

Line 3658: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_CD' )

3654: fnd_message.set_token('PARAMETER_NAME',igs_ps_validate_lgcy_pkg.get_lkup_meaning('TEACHING_PERIOD','IGS_PS_LOG_PARAMETERS'));
3655: fnd_message.set_token('PARAMETER_VAL' ,p_teach_calendar);
3656: fnd_file.put_line(fnd_file.log,fnd_message.get);
3657:
3658: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_CD' )
3659: || ' : ' || p_unit_cd );
3660: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_VER_NUM' )
3661: || ' : ' || TO_CHAR (p_version_number) );
3662: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'LOCATION_CD' )

Line 3660: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_VER_NUM' )

3656: fnd_file.put_line(fnd_file.log,fnd_message.get);
3657:
3658: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_CD' )
3659: || ' : ' || p_unit_cd );
3660: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_VER_NUM' )
3661: || ' : ' || TO_CHAR (p_version_number) );
3662: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'LOCATION_CD' )
3663: || ' : ' || p_location );
3664: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_CLASS' )

Line 3662: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'LOCATION_CD' )

3658: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_CD' )
3659: || ' : ' || p_unit_cd );
3660: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_VER_NUM' )
3661: || ' : ' || TO_CHAR (p_version_number) );
3662: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'LOCATION_CD' )
3663: || ' : ' || p_location );
3664: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_CLASS' )
3665: || ' : ' || p_unit_class );
3666:

Line 3664: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_CLASS' )

3660: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_VER_NUM' )
3661: || ' : ' || TO_CHAR (p_version_number) );
3662: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'LOCATION_CD' )
3663: || ' : ' || p_location );
3664: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_CLASS' )
3665: || ' : ' || p_unit_class );
3666:
3667: fnd_message.set_name('IGS','IGS_FI_CAL_BALANCES_LOG');
3668: fnd_message.set_token('PARAMETER_NAME',igs_ps_validate_lgcy_pkg.get_lkup_meaning('CANCEL_OCCUR_ONLY','IGS_PS_LOG_PARAMETERS'));

Line 3670: fnd_file.put_line(fnd_file.log,fnd_message.get);

3666:
3667: fnd_message.set_name('IGS','IGS_FI_CAL_BALANCES_LOG');
3668: fnd_message.set_token('PARAMETER_NAME',igs_ps_validate_lgcy_pkg.get_lkup_meaning('CANCEL_OCCUR_ONLY','IGS_PS_LOG_PARAMETERS'));
3669: fnd_message.set_token('PARAMETER_VAL' ,p_cancel_only);
3670: fnd_file.put_line(fnd_file.log,fnd_message.get);
3671: fnd_file.put_line(fnd_file.log,' ');
3672: fnd_file.put_line(fnd_file.log,' ');
3673:
3674:

Line 3671: fnd_file.put_line(fnd_file.log,' ');

3667: fnd_message.set_name('IGS','IGS_FI_CAL_BALANCES_LOG');
3668: fnd_message.set_token('PARAMETER_NAME',igs_ps_validate_lgcy_pkg.get_lkup_meaning('CANCEL_OCCUR_ONLY','IGS_PS_LOG_PARAMETERS'));
3669: fnd_message.set_token('PARAMETER_VAL' ,p_cancel_only);
3670: fnd_file.put_line(fnd_file.log,fnd_message.get);
3671: fnd_file.put_line(fnd_file.log,' ');
3672: fnd_file.put_line(fnd_file.log,' ');
3673:
3674:
3675: -- Get the cal_tpe,sequence_number and start date and End date

Line 3672: fnd_file.put_line(fnd_file.log,' ');

3668: fnd_message.set_token('PARAMETER_NAME',igs_ps_validate_lgcy_pkg.get_lkup_meaning('CANCEL_OCCUR_ONLY','IGS_PS_LOG_PARAMETERS'));
3669: fnd_message.set_token('PARAMETER_VAL' ,p_cancel_only);
3670: fnd_file.put_line(fnd_file.log,fnd_message.get);
3671: fnd_file.put_line(fnd_file.log,' ');
3672: fnd_file.put_line(fnd_file.log,' ');
3673:
3674:
3675: -- Get the cal_tpe,sequence_number and start date and End date
3676: l_cal_type := RTRIM(SUBSTR(p_teach_calendar,101,10));

Line 3686: fnd_file.put_line ( fnd_file.LOG,fnd_message.get );

3682: l_proc_count := 0;
3683:
3684: fnd_message.set_name('IGS','IGS_PS_ABORT_OCCURS_SEC_PAT');
3685: fnd_message.set_token('TABLENAME',igs_ps_validate_lgcy_pkg.get_lkup_meaning('OCCURRENCES','IGS_PS_TABLE_NAME'));
3686: fnd_file.put_line ( fnd_file.LOG,fnd_message.get );
3687: fnd_file.put_line(fnd_file.log,' ');
3688:
3689: FOR c_int_uso_ss_rec IN c_int_uso_ss(l_ci_sequence_number,l_cal_type) LOOP
3690:

Line 3687: fnd_file.put_line(fnd_file.log,' ');

3683:
3684: fnd_message.set_name('IGS','IGS_PS_ABORT_OCCURS_SEC_PAT');
3685: fnd_message.set_token('TABLENAME',igs_ps_validate_lgcy_pkg.get_lkup_meaning('OCCURRENCES','IGS_PS_TABLE_NAME'));
3686: fnd_file.put_line ( fnd_file.LOG,fnd_message.get );
3687: fnd_file.put_line(fnd_file.log,' ');
3688:
3689: FOR c_int_uso_ss_rec IN c_int_uso_ss(l_ci_sequence_number,l_cal_type) LOOP
3690:
3691: fnd_file.put_line ( fnd_file.LOG,igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_CD' )

Line 3691: fnd_file.put_line ( fnd_file.LOG,igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_CD' )

3687: fnd_file.put_line(fnd_file.log,' ');
3688:
3689: FOR c_int_uso_ss_rec IN c_int_uso_ss(l_ci_sequence_number,l_cal_type) LOOP
3690:
3691: fnd_file.put_line ( fnd_file.LOG,igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_CD' )
3692: || ' : ' || c_int_uso_ss_rec.unit_code );
3693: fnd_file.put_line ( fnd_file.LOG,igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_VER_NUM' )
3694: || ' : ' || TO_CHAR (c_int_uso_ss_rec.unit_version_number) );
3695: fnd_file.put_line ( fnd_file.LOG,igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'LOCATION_CD' )

Line 3693: fnd_file.put_line ( fnd_file.LOG,igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_VER_NUM' )

3689: FOR c_int_uso_ss_rec IN c_int_uso_ss(l_ci_sequence_number,l_cal_type) LOOP
3690:
3691: fnd_file.put_line ( fnd_file.LOG,igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_CD' )
3692: || ' : ' || c_int_uso_ss_rec.unit_code );
3693: fnd_file.put_line ( fnd_file.LOG,igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_VER_NUM' )
3694: || ' : ' || TO_CHAR (c_int_uso_ss_rec.unit_version_number) );
3695: fnd_file.put_line ( fnd_file.LOG,igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'LOCATION_CD' )
3696: || ' : ' || c_int_uso_ss_rec.location_code );
3697: fnd_file.put_line ( fnd_file.LOG,igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_CLASS' )

Line 3695: fnd_file.put_line ( fnd_file.LOG,igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'LOCATION_CD' )

3691: fnd_file.put_line ( fnd_file.LOG,igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_CD' )
3692: || ' : ' || c_int_uso_ss_rec.unit_code );
3693: fnd_file.put_line ( fnd_file.LOG,igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_VER_NUM' )
3694: || ' : ' || TO_CHAR (c_int_uso_ss_rec.unit_version_number) );
3695: fnd_file.put_line ( fnd_file.LOG,igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'LOCATION_CD' )
3696: || ' : ' || c_int_uso_ss_rec.location_code );
3697: fnd_file.put_line ( fnd_file.LOG,igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_CLASS' )
3698: || ' : ' || c_int_uso_ss_rec.unit_cls );
3699: fnd_message.set_name('IGS','IGS_FI_CAL_BALANCES_LOG');

Line 3697: fnd_file.put_line ( fnd_file.LOG,igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_CLASS' )

3693: fnd_file.put_line ( fnd_file.LOG,igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_VER_NUM' )
3694: || ' : ' || TO_CHAR (c_int_uso_ss_rec.unit_version_number) );
3695: fnd_file.put_line ( fnd_file.LOG,igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'LOCATION_CD' )
3696: || ' : ' || c_int_uso_ss_rec.location_code );
3697: fnd_file.put_line ( fnd_file.LOG,igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_CLASS' )
3698: || ' : ' || c_int_uso_ss_rec.unit_cls );
3699: fnd_message.set_name('IGS','IGS_FI_CAL_BALANCES_LOG');
3700: fnd_message.set_token('PARAMETER_NAME',igs_ps_validate_lgcy_pkg.get_lkup_meaning('USEC_OCCRS_ID','IGS_PS_LOG_PARAMETERS'));
3701: fnd_message.set_token('PARAMETER_VAL' ,c_int_uso_ss_rec.occurrence_identifier);

Line 3702: fnd_file.put_line(fnd_file.log,fnd_message.get);

3698: || ' : ' || c_int_uso_ss_rec.unit_cls );
3699: fnd_message.set_name('IGS','IGS_FI_CAL_BALANCES_LOG');
3700: fnd_message.set_token('PARAMETER_NAME',igs_ps_validate_lgcy_pkg.get_lkup_meaning('USEC_OCCRS_ID','IGS_PS_LOG_PARAMETERS'));
3701: fnd_message.set_token('PARAMETER_VAL' ,c_int_uso_ss_rec.occurrence_identifier);
3702: fnd_file.put_line(fnd_file.log,fnd_message.get);
3703: fnd_file.put_line ( fnd_file.LOG, 'Int Occurs Id'|| ' : ' || c_int_uso_ss_rec.int_occurs_id );
3704: fnd_file.put_line(fnd_file.log,' ');
3705:
3706: UPDATE igs_ps_sch_int_all SET abort_flag = 'Y'

Line 3703: fnd_file.put_line ( fnd_file.LOG, 'Int Occurs Id'|| ' : ' || c_int_uso_ss_rec.int_occurs_id );

3699: fnd_message.set_name('IGS','IGS_FI_CAL_BALANCES_LOG');
3700: fnd_message.set_token('PARAMETER_NAME',igs_ps_validate_lgcy_pkg.get_lkup_meaning('USEC_OCCRS_ID','IGS_PS_LOG_PARAMETERS'));
3701: fnd_message.set_token('PARAMETER_VAL' ,c_int_uso_ss_rec.occurrence_identifier);
3702: fnd_file.put_line(fnd_file.log,fnd_message.get);
3703: fnd_file.put_line ( fnd_file.LOG, 'Int Occurs Id'|| ' : ' || c_int_uso_ss_rec.int_occurs_id );
3704: fnd_file.put_line(fnd_file.log,' ');
3705:
3706: UPDATE igs_ps_sch_int_all SET abort_flag = 'Y'
3707: WHERE ROWID = c_int_uso_ss_rec.intrid;

Line 3704: fnd_file.put_line(fnd_file.log,' ');

3700: fnd_message.set_token('PARAMETER_NAME',igs_ps_validate_lgcy_pkg.get_lkup_meaning('USEC_OCCRS_ID','IGS_PS_LOG_PARAMETERS'));
3701: fnd_message.set_token('PARAMETER_VAL' ,c_int_uso_ss_rec.occurrence_identifier);
3702: fnd_file.put_line(fnd_file.log,fnd_message.get);
3703: fnd_file.put_line ( fnd_file.LOG, 'Int Occurs Id'|| ' : ' || c_int_uso_ss_rec.int_occurs_id );
3704: fnd_file.put_line(fnd_file.log,' ');
3705:
3706: UPDATE igs_ps_sch_int_all SET abort_flag = 'Y'
3707: WHERE ROWID = c_int_uso_ss_rec.intrid;
3708:

Line 3775: fnd_file.put_line ( fnd_file.LOG, ' ' || fnd_message.get||l_abort_count );

3771: END LOOP;
3772:
3773: fnd_message.set_name('IGS','IGS_PS_TOT_RECORDS_PROCESS');
3774: fnd_message.set_token('TABLE',igs_ps_validate_lgcy_pkg.get_lkup_meaning('OCCURRENCES','IGS_PS_TABLE_NAME'));
3775: fnd_file.put_line ( fnd_file.LOG, ' ' || fnd_message.get||l_abort_count );
3776: fnd_message.set_name('IGS','IGS_PS_TOT_RECORDS_ABORTED');
3777: fnd_message.set_token('TABLE',igs_ps_validate_lgcy_pkg.get_lkup_meaning('OCCURRENCES','IGS_PS_TABLE_NAME'));
3778: fnd_file.put_line ( fnd_file.LOG, ' ' || fnd_message.get||l_abort_count );
3779:

Line 3778: fnd_file.put_line ( fnd_file.LOG, ' ' || fnd_message.get||l_abort_count );

3774: fnd_message.set_token('TABLE',igs_ps_validate_lgcy_pkg.get_lkup_meaning('OCCURRENCES','IGS_PS_TABLE_NAME'));
3775: fnd_file.put_line ( fnd_file.LOG, ' ' || fnd_message.get||l_abort_count );
3776: fnd_message.set_name('IGS','IGS_PS_TOT_RECORDS_ABORTED');
3777: fnd_message.set_token('TABLE',igs_ps_validate_lgcy_pkg.get_lkup_meaning('OCCURRENCES','IGS_PS_TABLE_NAME'));
3778: fnd_file.put_line ( fnd_file.LOG, ' ' || fnd_message.get||l_abort_count );
3779:
3780: l_abort_count:= 0;
3781: l_proc_count := 0;
3782:

Line 3783: fnd_file.put_line ( fnd_file.LOG, ' ' );

3779:
3780: l_abort_count:= 0;
3781: l_proc_count := 0;
3782:
3783: fnd_file.put_line ( fnd_file.LOG, ' ' );
3784: fnd_message.set_name('IGS','IGS_PS_ABORT_OCCURS_SEC_PAT');
3785: fnd_message.set_token('TABLENAME',igs_ps_validate_lgcy_pkg.get_lkup_meaning('SECTIONS','IGS_PS_TABLE_NAME'));
3786: fnd_file.put_line ( fnd_file.LOG,fnd_message.get );
3787: fnd_file.put_line ( fnd_file.LOG, ' ' );

Line 3786: fnd_file.put_line ( fnd_file.LOG,fnd_message.get );

3782:
3783: fnd_file.put_line ( fnd_file.LOG, ' ' );
3784: fnd_message.set_name('IGS','IGS_PS_ABORT_OCCURS_SEC_PAT');
3785: fnd_message.set_token('TABLENAME',igs_ps_validate_lgcy_pkg.get_lkup_meaning('SECTIONS','IGS_PS_TABLE_NAME'));
3786: fnd_file.put_line ( fnd_file.LOG,fnd_message.get );
3787: fnd_file.put_line ( fnd_file.LOG, ' ' );
3788:
3789: FOR c_int_usec_ss_rec IN c_int_usec_ss(l_ci_sequence_number,l_cal_type) LOOP
3790: l_uso_count := NULL;

Line 3787: fnd_file.put_line ( fnd_file.LOG, ' ' );

3783: fnd_file.put_line ( fnd_file.LOG, ' ' );
3784: fnd_message.set_name('IGS','IGS_PS_ABORT_OCCURS_SEC_PAT');
3785: fnd_message.set_token('TABLENAME',igs_ps_validate_lgcy_pkg.get_lkup_meaning('SECTIONS','IGS_PS_TABLE_NAME'));
3786: fnd_file.put_line ( fnd_file.LOG,fnd_message.get );
3787: fnd_file.put_line ( fnd_file.LOG, ' ' );
3788:
3789: FOR c_int_usec_ss_rec IN c_int_usec_ss(l_ci_sequence_number,l_cal_type) LOOP
3790: l_uso_count := NULL;
3791: OPEN c_int_uso(c_int_usec_ss_rec.int_usec_id);

Line 3800: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_CD' )

3796: l_abort_flag := 'Y';
3797: l_abort_count := l_abort_count +1;
3798:
3799: --aborting the following section
3800: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_CD' )
3801: || ' : ' || c_int_usec_ss_rec.unit_cd );
3802: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_VER_NUM' )
3803: || ' : ' || TO_CHAR (c_int_usec_ss_rec.version_number) );
3804: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'LOCATION_CD' )

Line 3802: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_VER_NUM' )

3798:
3799: --aborting the following section
3800: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_CD' )
3801: || ' : ' || c_int_usec_ss_rec.unit_cd );
3802: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_VER_NUM' )
3803: || ' : ' || TO_CHAR (c_int_usec_ss_rec.version_number) );
3804: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'LOCATION_CD' )
3805: || ' : ' || c_int_usec_ss_rec.location_cd );
3806: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_CLASS' )

Line 3804: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'LOCATION_CD' )

3800: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_CD' )
3801: || ' : ' || c_int_usec_ss_rec.unit_cd );
3802: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_VER_NUM' )
3803: || ' : ' || TO_CHAR (c_int_usec_ss_rec.version_number) );
3804: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'LOCATION_CD' )
3805: || ' : ' || c_int_usec_ss_rec.location_cd );
3806: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_CLASS' )
3807: || ' : ' || c_int_usec_ss_rec.unit_class );
3808: fnd_file.put_line ( fnd_file.LOG, 'Int Usec Id'|| ' : ' || c_int_usec_ss_rec.int_usec_id );

Line 3806: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_CLASS' )

3802: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_VER_NUM' )
3803: || ' : ' || TO_CHAR (c_int_usec_ss_rec.version_number) );
3804: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'LOCATION_CD' )
3805: || ' : ' || c_int_usec_ss_rec.location_cd );
3806: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_CLASS' )
3807: || ' : ' || c_int_usec_ss_rec.unit_class );
3808: fnd_file.put_line ( fnd_file.LOG, 'Int Usec Id'|| ' : ' || c_int_usec_ss_rec.int_usec_id );
3809: fnd_file.put_line ( fnd_file.LOG,' ' );
3810:

Line 3808: fnd_file.put_line ( fnd_file.LOG, 'Int Usec Id'|| ' : ' || c_int_usec_ss_rec.int_usec_id );

3804: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'LOCATION_CD' )
3805: || ' : ' || c_int_usec_ss_rec.location_cd );
3806: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_CLASS' )
3807: || ' : ' || c_int_usec_ss_rec.unit_class );
3808: fnd_file.put_line ( fnd_file.LOG, 'Int Usec Id'|| ' : ' || c_int_usec_ss_rec.int_usec_id );
3809: fnd_file.put_line ( fnd_file.LOG,' ' );
3810:
3811:
3812: ELSE

Line 3809: fnd_file.put_line ( fnd_file.LOG,' ' );

3805: || ' : ' || c_int_usec_ss_rec.location_cd );
3806: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_CLASS' )
3807: || ' : ' || c_int_usec_ss_rec.unit_class );
3808: fnd_file.put_line ( fnd_file.LOG, 'Int Usec Id'|| ' : ' || c_int_usec_ss_rec.int_usec_id );
3809: fnd_file.put_line ( fnd_file.LOG,' ' );
3810:
3811:
3812: ELSE
3813: l_abort_flag := 'N';

Line 3880: fnd_file.put_line ( fnd_file.LOG, ' ' || fnd_message.get||l_proc_count );

3876: END LOOP;
3877:
3878: fnd_message.set_name('IGS','IGS_PS_TOT_RECORDS_PROCESS');
3879: fnd_message.set_token('TABLE',igs_ps_validate_lgcy_pkg.get_lkup_meaning('SECTIONS','IGS_PS_TABLE_NAME'));
3880: fnd_file.put_line ( fnd_file.LOG, ' ' || fnd_message.get||l_proc_count );
3881: fnd_message.set_name('IGS','IGS_PS_TOT_RECORDS_ABORTED');
3882: fnd_message.set_token('TABLE',igs_ps_validate_lgcy_pkg.get_lkup_meaning('SECTIONS','IGS_PS_TABLE_NAME'));
3883: fnd_file.put_line ( fnd_file.LOG, ' ' || fnd_message.get||l_abort_count );
3884:

Line 3883: fnd_file.put_line ( fnd_file.LOG, ' ' || fnd_message.get||l_abort_count );

3879: fnd_message.set_token('TABLE',igs_ps_validate_lgcy_pkg.get_lkup_meaning('SECTIONS','IGS_PS_TABLE_NAME'));
3880: fnd_file.put_line ( fnd_file.LOG, ' ' || fnd_message.get||l_proc_count );
3881: fnd_message.set_name('IGS','IGS_PS_TOT_RECORDS_ABORTED');
3882: fnd_message.set_token('TABLE',igs_ps_validate_lgcy_pkg.get_lkup_meaning('SECTIONS','IGS_PS_TABLE_NAME'));
3883: fnd_file.put_line ( fnd_file.LOG, ' ' || fnd_message.get||l_abort_count );
3884:
3885: l_abort_count := 0;
3886: l_proc_count := 0;
3887:

Line 3888: fnd_file.put_line ( fnd_file.LOG, ' ' );

3884:
3885: l_abort_count := 0;
3886: l_proc_count := 0;
3887:
3888: fnd_file.put_line ( fnd_file.LOG, ' ' );
3889: fnd_message.set_name('IGS','IGS_PS_ABORT_OCCURS_SEC_PAT');
3890: fnd_message.set_token('TABLENAME',igs_ps_validate_lgcy_pkg.get_lkup_meaning('PATTERNS','IGS_PS_TABLE_NAME'));
3891: fnd_file.put_line ( fnd_file.LOG, fnd_message.get );
3892: fnd_file.put_line ( fnd_file.LOG, ' ' );

Line 3891: fnd_file.put_line ( fnd_file.LOG, fnd_message.get );

3887:
3888: fnd_file.put_line ( fnd_file.LOG, ' ' );
3889: fnd_message.set_name('IGS','IGS_PS_ABORT_OCCURS_SEC_PAT');
3890: fnd_message.set_token('TABLENAME',igs_ps_validate_lgcy_pkg.get_lkup_meaning('PATTERNS','IGS_PS_TABLE_NAME'));
3891: fnd_file.put_line ( fnd_file.LOG, fnd_message.get );
3892: fnd_file.put_line ( fnd_file.LOG, ' ' );
3893:
3894: FOR c_int_pat_ss_rec IN c_int_pat_ss(l_ci_sequence_number,l_cal_type) LOOP
3895: l_uso_count:=null;

Line 3892: fnd_file.put_line ( fnd_file.LOG, ' ' );

3888: fnd_file.put_line ( fnd_file.LOG, ' ' );
3889: fnd_message.set_name('IGS','IGS_PS_ABORT_OCCURS_SEC_PAT');
3890: fnd_message.set_token('TABLENAME',igs_ps_validate_lgcy_pkg.get_lkup_meaning('PATTERNS','IGS_PS_TABLE_NAME'));
3891: fnd_file.put_line ( fnd_file.LOG, fnd_message.get );
3892: fnd_file.put_line ( fnd_file.LOG, ' ' );
3893:
3894: FOR c_int_pat_ss_rec IN c_int_pat_ss(l_ci_sequence_number,l_cal_type) LOOP
3895: l_uso_count:=null;
3896: OPEN c_int_usec(c_int_pat_ss_rec.int_pat_id);

Line 3905: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_CD' )

3901: l_abort_flag := 'Y';
3902: l_abort_count := l_abort_count +1;
3903:
3904: --aborting the following patterns
3905: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_CD' )
3906: || ' : ' || c_int_pat_ss_rec.unit_cd );
3907: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_VER_NUM' )
3908: || ' : ' || TO_CHAR (c_int_pat_ss_rec.version_number) );
3909: fnd_message.set_name('IGS','IGS_FI_CAL_BALANCES_LOG');

Line 3907: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_VER_NUM' )

3903:
3904: --aborting the following patterns
3905: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_CD' )
3906: || ' : ' || c_int_pat_ss_rec.unit_cd );
3907: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_VER_NUM' )
3908: || ' : ' || TO_CHAR (c_int_pat_ss_rec.version_number) );
3909: fnd_message.set_name('IGS','IGS_FI_CAL_BALANCES_LOG');
3910: fnd_message.set_token('PARAMETER_NAME',igs_ps_validate_lgcy_pkg.get_lkup_meaning('TEACHING_PERIOD','IGS_PS_LOG_PARAMETERS'));
3911: fnd_message.set_token('PARAMETER_VAL' ,p_teach_calendar);

Line 3912: fnd_file.put_line(fnd_file.log, fnd_message.get);

3908: || ' : ' || TO_CHAR (c_int_pat_ss_rec.version_number) );
3909: fnd_message.set_name('IGS','IGS_FI_CAL_BALANCES_LOG');
3910: fnd_message.set_token('PARAMETER_NAME',igs_ps_validate_lgcy_pkg.get_lkup_meaning('TEACHING_PERIOD','IGS_PS_LOG_PARAMETERS'));
3911: fnd_message.set_token('PARAMETER_VAL' ,p_teach_calendar);
3912: fnd_file.put_line(fnd_file.log, fnd_message.get);
3913: fnd_file.put_line ( fnd_file.LOG, 'Int Pat Id'|| ' : ' || c_int_pat_ss_rec.int_pat_id );
3914: fnd_file.put_line ( fnd_file.LOG, ' ' );
3915:
3916: ELSE

Line 3913: fnd_file.put_line ( fnd_file.LOG, 'Int Pat Id'|| ' : ' || c_int_pat_ss_rec.int_pat_id );

3909: fnd_message.set_name('IGS','IGS_FI_CAL_BALANCES_LOG');
3910: fnd_message.set_token('PARAMETER_NAME',igs_ps_validate_lgcy_pkg.get_lkup_meaning('TEACHING_PERIOD','IGS_PS_LOG_PARAMETERS'));
3911: fnd_message.set_token('PARAMETER_VAL' ,p_teach_calendar);
3912: fnd_file.put_line(fnd_file.log, fnd_message.get);
3913: fnd_file.put_line ( fnd_file.LOG, 'Int Pat Id'|| ' : ' || c_int_pat_ss_rec.int_pat_id );
3914: fnd_file.put_line ( fnd_file.LOG, ' ' );
3915:
3916: ELSE
3917: l_abort_flag := 'N';

Line 3914: fnd_file.put_line ( fnd_file.LOG, ' ' );

3910: fnd_message.set_token('PARAMETER_NAME',igs_ps_validate_lgcy_pkg.get_lkup_meaning('TEACHING_PERIOD','IGS_PS_LOG_PARAMETERS'));
3911: fnd_message.set_token('PARAMETER_VAL' ,p_teach_calendar);
3912: fnd_file.put_line(fnd_file.log, fnd_message.get);
3913: fnd_file.put_line ( fnd_file.LOG, 'Int Pat Id'|| ' : ' || c_int_pat_ss_rec.int_pat_id );
3914: fnd_file.put_line ( fnd_file.LOG, ' ' );
3915:
3916: ELSE
3917: l_abort_flag := 'N';
3918: END IF;

Line 3948: fnd_file.put_line ( fnd_file.LOG, ' ' || fnd_message.get||l_proc_count );

3944: END LOOP;
3945:
3946: fnd_message.set_name('IGS','IGS_PS_TOT_RECORDS_PROCESS');
3947: fnd_message.set_token('TABLE',igs_ps_validate_lgcy_pkg.get_lkup_meaning('PATTERNS','IGS_PS_TABLE_NAME'));
3948: fnd_file.put_line ( fnd_file.LOG, ' ' || fnd_message.get||l_proc_count );
3949: fnd_message.set_name('IGS','IGS_PS_TOT_RECORDS_ABORTED');
3950: fnd_message.set_token('TABLE',igs_ps_validate_lgcy_pkg.get_lkup_meaning('PATTERNS','IGS_PS_TABLE_NAME'));
3951: fnd_file.put_line ( fnd_file.LOG, ' ' || fnd_message.get||l_abort_count );
3952:

Line 3951: fnd_file.put_line ( fnd_file.LOG, ' ' || fnd_message.get||l_abort_count );

3947: fnd_message.set_token('TABLE',igs_ps_validate_lgcy_pkg.get_lkup_meaning('PATTERNS','IGS_PS_TABLE_NAME'));
3948: fnd_file.put_line ( fnd_file.LOG, ' ' || fnd_message.get||l_proc_count );
3949: fnd_message.set_name('IGS','IGS_PS_TOT_RECORDS_ABORTED');
3950: fnd_message.set_token('TABLE',igs_ps_validate_lgcy_pkg.get_lkup_meaning('PATTERNS','IGS_PS_TABLE_NAME'));
3951: fnd_file.put_line ( fnd_file.LOG, ' ' || fnd_message.get||l_abort_count );
3952:
3953: EXCEPTION
3954: WHEN OTHERS THEN
3955: RETCODE:=2;

Line 3956: fnd_file.put_line ( fnd_file.LOG, ' ');

3952:
3953: EXCEPTION
3954: WHEN OTHERS THEN
3955: RETCODE:=2;
3956: fnd_file.put_line ( fnd_file.LOG, ' ');
3957: ERRBUF:=FND_MESSAGE.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION') || ' : ' || SQLERRM;
3958: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
3959: ROLLBACK;
3960: END abort_sched;

Line 4079: fnd_file.put_line(fnd_file.log,' ');

4075: END IF;
4076: END LOOP;
4077:
4078: /*Log the Teaching Calendar information */
4079: fnd_file.put_line(fnd_file.log,' ');
4080: fnd_file.put_line(fnd_file.log,' ');
4081: fnd_message.set_name('IGS','IGS_FI_CAL_BALANCES_LOG');
4082: fnd_message.set_token('PARAMETER_NAME',igs_ps_validate_lgcy_pkg.get_lkup_meaning('CAL_TYPE','LEGACY_TOKENS'));
4083: fnd_message.set_token('PARAMETER_VAL' ,p_c_cal_type);

Line 4080: fnd_file.put_line(fnd_file.log,' ');

4076: END LOOP;
4077:
4078: /*Log the Teaching Calendar information */
4079: fnd_file.put_line(fnd_file.log,' ');
4080: fnd_file.put_line(fnd_file.log,' ');
4081: fnd_message.set_name('IGS','IGS_FI_CAL_BALANCES_LOG');
4082: fnd_message.set_token('PARAMETER_NAME',igs_ps_validate_lgcy_pkg.get_lkup_meaning('CAL_TYPE','LEGACY_TOKENS'));
4083: fnd_message.set_token('PARAMETER_VAL' ,p_c_cal_type);
4084: fnd_file.put_line(fnd_file.log,fnd_message.get);

Line 4084: fnd_file.put_line(fnd_file.log,fnd_message.get);

4080: fnd_file.put_line(fnd_file.log,' ');
4081: fnd_message.set_name('IGS','IGS_FI_CAL_BALANCES_LOG');
4082: fnd_message.set_token('PARAMETER_NAME',igs_ps_validate_lgcy_pkg.get_lkup_meaning('CAL_TYPE','LEGACY_TOKENS'));
4083: fnd_message.set_token('PARAMETER_VAL' ,p_c_cal_type);
4084: fnd_file.put_line(fnd_file.log,fnd_message.get);
4085: fnd_message.set_name('IGS','IGS_FI_CAL_BALANCES_LOG');
4086: fnd_message.set_token('PARAMETER_NAME',igs_ps_validate_lgcy_pkg.get_lkup_meaning('START_DT','IGS_FI_LOCKBOX'));
4087: fnd_message.set_token('PARAMETER_VAL' ,TO_CHAR(TRUNC(l_start_date)));
4088: fnd_file.put_line(fnd_file.log,fnd_message.get);

Line 4088: fnd_file.put_line(fnd_file.log,fnd_message.get);

4084: fnd_file.put_line(fnd_file.log,fnd_message.get);
4085: fnd_message.set_name('IGS','IGS_FI_CAL_BALANCES_LOG');
4086: fnd_message.set_token('PARAMETER_NAME',igs_ps_validate_lgcy_pkg.get_lkup_meaning('START_DT','IGS_FI_LOCKBOX'));
4087: fnd_message.set_token('PARAMETER_VAL' ,TO_CHAR(TRUNC(l_start_date)));
4088: fnd_file.put_line(fnd_file.log,fnd_message.get);
4089: fnd_message.set_name('IGS','IGS_FI_CAL_BALANCES_LOG');
4090: fnd_message.set_token('PARAMETER_NAME',igs_ps_validate_lgcy_pkg.get_lkup_meaning('END_DT','IGS_FI_LOCKBOX'));
4091: fnd_message.set_token('PARAMETER_VAL' ,TO_CHAR(TRUNC(l_end_date)));
4092: fnd_file.put_line(fnd_file.log,fnd_message.get);

Line 4092: fnd_file.put_line(fnd_file.log,fnd_message.get);

4088: fnd_file.put_line(fnd_file.log,fnd_message.get);
4089: fnd_message.set_name('IGS','IGS_FI_CAL_BALANCES_LOG');
4090: fnd_message.set_token('PARAMETER_NAME',igs_ps_validate_lgcy_pkg.get_lkup_meaning('END_DT','IGS_FI_LOCKBOX'));
4091: fnd_message.set_token('PARAMETER_VAL' ,TO_CHAR(TRUNC(l_end_date)));
4092: fnd_file.put_line(fnd_file.log,fnd_message.get);
4093: fnd_file.put_line(fnd_file.log,'--------------------------------------------------------');
4094: fnd_file.put_line(fnd_file.log,' ');
4095: fnd_file.put_line(fnd_file.log,' ');
4096:

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

4089: fnd_message.set_name('IGS','IGS_FI_CAL_BALANCES_LOG');
4090: fnd_message.set_token('PARAMETER_NAME',igs_ps_validate_lgcy_pkg.get_lkup_meaning('END_DT','IGS_FI_LOCKBOX'));
4091: fnd_message.set_token('PARAMETER_VAL' ,TO_CHAR(TRUNC(l_end_date)));
4092: fnd_file.put_line(fnd_file.log,fnd_message.get);
4093: fnd_file.put_line(fnd_file.log,'--------------------------------------------------------');
4094: fnd_file.put_line(fnd_file.log,' ');
4095: fnd_file.put_line(fnd_file.log,' ');
4096:
4097:

Line 4094: fnd_file.put_line(fnd_file.log,' ');

4090: fnd_message.set_token('PARAMETER_NAME',igs_ps_validate_lgcy_pkg.get_lkup_meaning('END_DT','IGS_FI_LOCKBOX'));
4091: fnd_message.set_token('PARAMETER_VAL' ,TO_CHAR(TRUNC(l_end_date)));
4092: fnd_file.put_line(fnd_file.log,fnd_message.get);
4093: fnd_file.put_line(fnd_file.log,'--------------------------------------------------------');
4094: fnd_file.put_line(fnd_file.log,' ');
4095: fnd_file.put_line(fnd_file.log,' ');
4096:
4097:
4098: --If purge type setup is there then only process else return

Line 4095: fnd_file.put_line(fnd_file.log,' ');

4091: fnd_message.set_token('PARAMETER_VAL' ,TO_CHAR(TRUNC(l_end_date)));
4092: fnd_file.put_line(fnd_file.log,fnd_message.get);
4093: fnd_file.put_line(fnd_file.log,'--------------------------------------------------------');
4094: fnd_file.put_line(fnd_file.log,' ');
4095: fnd_file.put_line(fnd_file.log,' ');
4096:
4097:
4098: --If purge type setup is there then only process else return
4099: IF l_completed = 'Y' OR l_cancelled = 'Y' OR l_aborted = 'Y' THEN

Line 4106: fnd_file.put_line ( fnd_file.LOG,'Purging The Following Occurrences:' );

4102: l_c_occurrence_exists:=FALSE;
4103: FOR rec_uso IN c_uso(p_c_cal_type,p_n_seq_num,l_completed,l_cancelled,l_aborted) LOOP
4104:
4105: IF NOT l_c_occurrence_exists THEN
4106: fnd_file.put_line ( fnd_file.LOG,'Purging The Following Occurrences:' );
4107: fnd_file.put_line(fnd_file.log,' ');
4108: l_c_occurrence_exists:=TRUE;
4109: END IF;
4110:

Line 4107: fnd_file.put_line(fnd_file.log,' ');

4103: FOR rec_uso IN c_uso(p_c_cal_type,p_n_seq_num,l_completed,l_cancelled,l_aborted) LOOP
4104:
4105: IF NOT l_c_occurrence_exists THEN
4106: fnd_file.put_line ( fnd_file.LOG,'Purging The Following Occurrences:' );
4107: fnd_file.put_line(fnd_file.log,' ');
4108: l_c_occurrence_exists:=TRUE;
4109: END IF;
4110:
4111: -- Deleting the child of the occurrence

Line 4119: fnd_file.put_line ( fnd_file.LOG,igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_CD' )

4115:
4116: --Deleting the occurrence record
4117: DELETE FROM igs_ps_sch_int_all WHERE int_occurs_id=rec_uso.int_occurs_id;
4118:
4119: fnd_file.put_line ( fnd_file.LOG,igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_CD' )
4120: || ' : ' || rec_uso.unit_cd );
4121: fnd_file.put_line ( fnd_file.LOG,igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_VER_NUM' )
4122: || ' : ' || TO_CHAR (rec_uso.version_number) );
4123: fnd_file.put_line ( fnd_file.LOG,igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'LOCATION_CD' )

Line 4121: fnd_file.put_line ( fnd_file.LOG,igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_VER_NUM' )

4117: DELETE FROM igs_ps_sch_int_all WHERE int_occurs_id=rec_uso.int_occurs_id;
4118:
4119: fnd_file.put_line ( fnd_file.LOG,igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_CD' )
4120: || ' : ' || rec_uso.unit_cd );
4121: fnd_file.put_line ( fnd_file.LOG,igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_VER_NUM' )
4122: || ' : ' || TO_CHAR (rec_uso.version_number) );
4123: fnd_file.put_line ( fnd_file.LOG,igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'LOCATION_CD' )
4124: || ' : ' || rec_uso.location_cd );
4125: fnd_file.put_line ( fnd_file.LOG,igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_CLASS' )

Line 4123: fnd_file.put_line ( fnd_file.LOG,igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'LOCATION_CD' )

4119: fnd_file.put_line ( fnd_file.LOG,igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_CD' )
4120: || ' : ' || rec_uso.unit_cd );
4121: fnd_file.put_line ( fnd_file.LOG,igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_VER_NUM' )
4122: || ' : ' || TO_CHAR (rec_uso.version_number) );
4123: fnd_file.put_line ( fnd_file.LOG,igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'LOCATION_CD' )
4124: || ' : ' || rec_uso.location_cd );
4125: fnd_file.put_line ( fnd_file.LOG,igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_CLASS' )
4126: || ' : ' || rec_uso.unit_class );
4127:

Line 4125: fnd_file.put_line ( fnd_file.LOG,igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_CLASS' )

4121: fnd_file.put_line ( fnd_file.LOG,igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_VER_NUM' )
4122: || ' : ' || TO_CHAR (rec_uso.version_number) );
4123: fnd_file.put_line ( fnd_file.LOG,igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'LOCATION_CD' )
4124: || ' : ' || rec_uso.location_cd );
4125: fnd_file.put_line ( fnd_file.LOG,igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_CLASS' )
4126: || ' : ' || rec_uso.unit_class );
4127:
4128: fnd_file.put_line ( fnd_file.LOG,igs_ge_gen_004.genp_get_lookup ( 'IGS_PS_LOG_PARAMETERS', 'USEC_OCCRS_ID' )
4129: || ' : ' || rec_uso.occurrence_identifier );

Line 4128: fnd_file.put_line ( fnd_file.LOG,igs_ge_gen_004.genp_get_lookup ( 'IGS_PS_LOG_PARAMETERS', 'USEC_OCCRS_ID' )

4124: || ' : ' || rec_uso.location_cd );
4125: fnd_file.put_line ( fnd_file.LOG,igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_CLASS' )
4126: || ' : ' || rec_uso.unit_class );
4127:
4128: fnd_file.put_line ( fnd_file.LOG,igs_ge_gen_004.genp_get_lookup ( 'IGS_PS_LOG_PARAMETERS', 'USEC_OCCRS_ID' )
4129: || ' : ' || rec_uso.occurrence_identifier );
4130: fnd_file.put_line(fnd_file.log,' ');
4131:
4132:

Line 4130: fnd_file.put_line(fnd_file.log,' ');

4126: || ' : ' || rec_uso.unit_class );
4127:
4128: fnd_file.put_line ( fnd_file.LOG,igs_ge_gen_004.genp_get_lookup ( 'IGS_PS_LOG_PARAMETERS', 'USEC_OCCRS_ID' )
4129: || ' : ' || rec_uso.occurrence_identifier );
4130: fnd_file.put_line(fnd_file.log,' ');
4131:
4132:
4133: END LOOP;
4134:

Line 4136: fnd_file.put_line ( fnd_file.LOG,'No Occurrence record to be purged' );

4132:
4133: END LOOP;
4134:
4135: IF NOT l_c_occurrence_exists THEN
4136: fnd_file.put_line ( fnd_file.LOG,'No Occurrence record to be purged' );
4137: fnd_file.put_line(fnd_file.log,' ');
4138: END IF;
4139:
4140: /********************** Purging the Section Records***************************/

Line 4137: fnd_file.put_line(fnd_file.log,' ');

4133: END LOOP;
4134:
4135: IF NOT l_c_occurrence_exists THEN
4136: fnd_file.put_line ( fnd_file.LOG,'No Occurrence record to be purged' );
4137: fnd_file.put_line(fnd_file.log,' ');
4138: END IF;
4139:
4140: /********************** Purging the Section Records***************************/
4141: l_c_section_exists:=FALSE;

Line 4145: fnd_file.put_line ( fnd_file.LOG,'Purging The Following Sections:' );

4141: l_c_section_exists:=FALSE;
4142: FOR rec_usec IN c_usec(p_c_cal_type,p_n_seq_num,l_aborted) LOOP
4143:
4144: IF NOT l_c_section_exists THEN
4145: fnd_file.put_line ( fnd_file.LOG,'Purging The Following Sections:' );
4146: fnd_file.put_line(fnd_file.log,' ');
4147: l_c_section_exists:=TRUE;
4148: END IF;
4149:

Line 4146: fnd_file.put_line(fnd_file.log,' ');

4142: FOR rec_usec IN c_usec(p_c_cal_type,p_n_seq_num,l_aborted) LOOP
4143:
4144: IF NOT l_c_section_exists THEN
4145: fnd_file.put_line ( fnd_file.LOG,'Purging The Following Sections:' );
4146: fnd_file.put_line(fnd_file.log,' ');
4147: l_c_section_exists:=TRUE;
4148: END IF;
4149:
4150:

Line 4159: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_CD' )

4155: -- Deleting unit section record
4156: DELETE FROM igs_ps_sch_usec_int_all WHERE int_usec_id=rec_usec.int_usec_id;
4157:
4158:
4159: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_CD' )
4160: || ' : ' || rec_usec.unit_cd );
4161: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_VER_NUM' )
4162: || ' : ' || TO_CHAR (rec_usec.version_number) );
4163: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'LOCATION_CD' )

Line 4161: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_VER_NUM' )

4157:
4158:
4159: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_CD' )
4160: || ' : ' || rec_usec.unit_cd );
4161: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_VER_NUM' )
4162: || ' : ' || TO_CHAR (rec_usec.version_number) );
4163: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'LOCATION_CD' )
4164: || ' : ' || rec_usec.location_cd );
4165: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_CLASS' )

Line 4163: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'LOCATION_CD' )

4159: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_CD' )
4160: || ' : ' || rec_usec.unit_cd );
4161: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_VER_NUM' )
4162: || ' : ' || TO_CHAR (rec_usec.version_number) );
4163: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'LOCATION_CD' )
4164: || ' : ' || rec_usec.location_cd );
4165: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_CLASS' )
4166: || ' : ' || rec_usec.unit_class );
4167: fnd_file.put_line ( fnd_file.LOG,' ' );

Line 4165: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_CLASS' )

4161: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_VER_NUM' )
4162: || ' : ' || TO_CHAR (rec_usec.version_number) );
4163: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'LOCATION_CD' )
4164: || ' : ' || rec_usec.location_cd );
4165: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_CLASS' )
4166: || ' : ' || rec_usec.unit_class );
4167: fnd_file.put_line ( fnd_file.LOG,' ' );
4168:
4169:

Line 4167: fnd_file.put_line ( fnd_file.LOG,' ' );

4163: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'LOCATION_CD' )
4164: || ' : ' || rec_usec.location_cd );
4165: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_CLASS' )
4166: || ' : ' || rec_usec.unit_class );
4167: fnd_file.put_line ( fnd_file.LOG,' ' );
4168:
4169:
4170: END LOOP;
4171:

Line 4173: fnd_file.put_line ( fnd_file.LOG,'No Section record to be purged' );

4169:
4170: END LOOP;
4171:
4172: IF NOT l_c_section_exists THEN
4173: fnd_file.put_line ( fnd_file.LOG,'No Section record to be purged' );
4174: fnd_file.put_line(fnd_file.log,' ');
4175: END IF;
4176:
4177:

Line 4174: fnd_file.put_line(fnd_file.log,' ');

4170: END LOOP;
4171:
4172: IF NOT l_c_section_exists THEN
4173: fnd_file.put_line ( fnd_file.LOG,'No Section record to be purged' );
4174: fnd_file.put_line(fnd_file.log,' ');
4175: END IF;
4176:
4177:
4178: /********************** Purging the pattern Records***************************/

Line 4183: fnd_file.put_line ( fnd_file.LOG,'Purging The Following Patterns:' );

4179: l_c_pat_exists:=FALSE;
4180: FOR rec_pat IN c_pat(p_c_cal_type,p_n_seq_num,l_aborted) LOOP
4181:
4182: IF NOT l_c_pat_exists THEN
4183: fnd_file.put_line ( fnd_file.LOG,'Purging The Following Patterns:' );
4184: fnd_file.put_line(fnd_file.log,' ');
4185: l_c_pat_exists:=TRUE;
4186: END IF;
4187:

Line 4184: fnd_file.put_line(fnd_file.log,' ');

4180: FOR rec_pat IN c_pat(p_c_cal_type,p_n_seq_num,l_aborted) LOOP
4181:
4182: IF NOT l_c_pat_exists THEN
4183: fnd_file.put_line ( fnd_file.LOG,'Purging The Following Patterns:' );
4184: fnd_file.put_line(fnd_file.log,' ');
4185: l_c_pat_exists:=TRUE;
4186: END IF;
4187:
4188:

Line 4196: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_CD' )

4192:
4193: -- Deleting pattern record
4194: DELETE FROM igs_ps_sch_pat_int WHERE int_pat_id=rec_pat.int_pat_id;
4195:
4196: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_CD' )
4197: || ' : ' || rec_pat.unit_cd );
4198: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_VER_NUM' )
4199: || ' : ' || TO_CHAR (rec_pat.version_number) );
4200: fnd_file.put_line ( fnd_file.LOG, ' ' );

Line 4198: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_VER_NUM' )

4194: DELETE FROM igs_ps_sch_pat_int WHERE int_pat_id=rec_pat.int_pat_id;
4195:
4196: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_CD' )
4197: || ' : ' || rec_pat.unit_cd );
4198: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_VER_NUM' )
4199: || ' : ' || TO_CHAR (rec_pat.version_number) );
4200: fnd_file.put_line ( fnd_file.LOG, ' ' );
4201:
4202: END LOOP;

Line 4200: fnd_file.put_line ( fnd_file.LOG, ' ' );

4196: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_CD' )
4197: || ' : ' || rec_pat.unit_cd );
4198: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_VER_NUM' )
4199: || ' : ' || TO_CHAR (rec_pat.version_number) );
4200: fnd_file.put_line ( fnd_file.LOG, ' ' );
4201:
4202: END LOOP;
4203:
4204: IF NOT l_c_pat_exists THEN

Line 4205: fnd_file.put_line ( fnd_file.LOG,'No pattern record to be purged' );

4201:
4202: END LOOP;
4203:
4204: IF NOT l_c_pat_exists THEN
4205: fnd_file.put_line ( fnd_file.LOG,'No pattern record to be purged' );
4206: fnd_file.put_line(fnd_file.log,' ');
4207: END IF;
4208:
4209:

Line 4206: fnd_file.put_line(fnd_file.log,' ');

4202: END LOOP;
4203:
4204: IF NOT l_c_pat_exists THEN
4205: fnd_file.put_line ( fnd_file.LOG,'No pattern record to be purged' );
4206: fnd_file.put_line(fnd_file.log,' ');
4207: END IF;
4208:
4209:
4210: /********************** Purging the header Records***************************/

Line 4222: fnd_file.put_line ( fnd_file.LOG,'No records to be purged for this teaching calendar' );

4218:
4219: END IF;
4220:
4221: IF l_c_occurrence_exists=FALSE AND l_c_section_exists=FALSE AND l_c_pat_exists=FALSE THEN
4222: fnd_file.put_line ( fnd_file.LOG,'No records to be purged for this teaching calendar' );
4223: fnd_file.put_line(fnd_file.log,' ');
4224: END IF;
4225:
4226:

Line 4223: fnd_file.put_line(fnd_file.log,' ');

4219: END IF;
4220:
4221: IF l_c_occurrence_exists=FALSE AND l_c_section_exists=FALSE AND l_c_pat_exists=FALSE THEN
4222: fnd_file.put_line ( fnd_file.LOG,'No records to be purged for this teaching calendar' );
4223: fnd_file.put_line(fnd_file.log,' ');
4224: END IF;
4225:
4226:
4227: END purge_schd_record;

Line 4296: FND_FILE.PUT_LINE(FND_FILE.LOG,l_c_str||FND_MESSAGE.GET);

4292: FND_MESSAGE.SET_TOKEN('PARAMETER_VAL' ,p_msg_val);
4293: FOR i IN 1..p_val LOOP
4294: l_c_str := l_c_str || ' ';
4295: END LOOP;
4296: FND_FILE.PUT_LINE(FND_FILE.LOG,l_c_str||FND_MESSAGE.GET);
4297:
4298: END log_messages;
4299:
4300: PROCEDURE log_teach_cal (p_c_cal_type IN VARCHAR2,

Line 4330: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

4326: OPEN c_alt_cd(p_c_cal_type,p_n_ci_sequence_number);
4327: FETCH c_alt_cd INTO l_alt_code;
4328: CLOSE c_alt_cd;
4329:
4330: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
4331: log_messages(igs_ps_validate_lgcy_pkg.get_lkup_meaning('TEACHING','CAL_CAT'),l_alt_code,3);
4332:
4333: END log_teach_cal;
4334:

Line 4356: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

4352: ************************************************************************/
4353:
4354: BEGIN
4355:
4356: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
4357: log_messages(igs_ps_validate_lgcy_pkg.get_lkup_meaning('UNIT_CD','LEGACY_TOKENS'),p_c_unit_cd,10);
4358: log_messages(igs_ps_validate_lgcy_pkg.get_lkup_meaning('VERSION_NUMBER','IGS_PS_LOG_PARAMETERS'),p_n_version_number,10);
4359: log_messages(igs_ps_validate_lgcy_pkg.get_lkup_meaning('LOC','IGS_FI_ACCT_ENTITIES'),p_c_location_description,10);
4360: log_messages(igs_ps_validate_lgcy_pkg.get_lkup_meaning('UNIT_CLASS','LEGACY_TOKENS'),p_c_unit_class,10);

Line 4452: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

4448: IF p_usec_occur_rec.sunday = 'Y' THEN
4449: l_str := l_str || igs_ps_validate_lgcy_pkg.get_lkup_meaning('SUNDAY','DT_OFFSET_CONSTRAINT_TYPE')||' ';
4450: END IF;
4451:
4452: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
4453: log_messages(igs_ps_validate_lgcy_pkg.get_lkup_meaning('USEC_OCCUR_ID','IGS_PS_LOG_PARAMETERS'),p_usec_occur_rec.unit_section_occurrence_id,20);
4454: log_messages(igs_ps_validate_lgcy_pkg.get_lkup_meaning('TRANSACTION_TYPE','IGS_PS_LOG_PARAMETERS'),p_c_trans_type,20);
4455:
4456: OPEN cur_lookup_meaning('SCHEDULE_TYPE',p_usec_occur_rec.schedule_status);