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 IGS_PS_VALIDATE_LGCY_PKG

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 1428: log_messages(igs_ps_validate_lgcy_pkg.get_lkup_meaning('UNIT_CD','LEGACY_TOKENS'),l_pattern_prod_rec.unit_cd,10);

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:
1431:
1432: OPEN cur_prod_pattern(l_pattern_prod_rec.unit_cd,l_pattern_prod_rec.version_number,l_pattern_prod_rec.calendar_type,l_pattern_prod_rec.sequence_number);

Line 1429: log_messages(igs_ps_validate_lgcy_pkg.get_lkup_meaning('VERSION_NUMBER','IGS_PS_LOG_PARAMETERS'),l_pattern_prod_rec.version_number,10);

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:
1431:
1432: OPEN cur_prod_pattern(l_pattern_prod_rec.unit_cd,l_pattern_prod_rec.version_number,l_pattern_prod_rec.calendar_type,l_pattern_prod_rec.sequence_number);
1433: FETCH cur_prod_pattern INTO l_prod_pattern;

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 1461: log_messages(igs_ps_validate_lgcy_pkg.get_lkup_meaning('UNIT_CD','LEGACY_TOKENS'),l_section_prod_rec.unit_cd,10);

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);
1464: log_messages(igs_ps_validate_lgcy_pkg.get_lkup_meaning('UNIT_CLASS','LEGACY_TOKENS'),l_section_prod_rec.unit_class,10);
1465:

Line 1462: log_messages(igs_ps_validate_lgcy_pkg.get_lkup_meaning('VERSION_NUMBER','IGS_PS_LOG_PARAMETERS'),l_section_prod_rec.version_number,10);

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);
1464: log_messages(igs_ps_validate_lgcy_pkg.get_lkup_meaning('UNIT_CLASS','LEGACY_TOKENS'),l_section_prod_rec.unit_class,10);
1465:
1466:

Line 1463: log_messages(igs_ps_validate_lgcy_pkg.get_lkup_meaning('LOC','IGS_FI_ACCT_ENTITIES'),l_section_prod_rec.location_cd,10);

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);
1464: log_messages(igs_ps_validate_lgcy_pkg.get_lkup_meaning('UNIT_CLASS','LEGACY_TOKENS'),l_section_prod_rec.unit_class,10);
1465:
1466:
1467:

Line 1464: log_messages(igs_ps_validate_lgcy_pkg.get_lkup_meaning('UNIT_CLASS','LEGACY_TOKENS'),l_section_prod_rec.unit_class,10);

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);
1464: log_messages(igs_ps_validate_lgcy_pkg.get_lkup_meaning('UNIT_CLASS','LEGACY_TOKENS'),l_section_prod_rec.unit_class,10);
1465:
1466:
1467:
1468:

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 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);

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:
1537:
1538: OPEN cur_prod_uoo_occur(l_occurrence_prod_rec.unit_section_occurrence_id);
1539: FETCH cur_prod_uoo_occur INTO l_usec_occurs_rec;

Line 3654: fnd_message.set_token('PARAMETER_NAME',igs_ps_validate_lgcy_pkg.get_lkup_meaning('TEACHING_PERIOD','IGS_PS_LOG_PARAMETERS'));

3650: igs_ge_gen_003.set_org_id (NULL);
3651: retcode:=0;
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' )

Line 3668: fnd_message.set_token('PARAMETER_NAME',igs_ps_validate_lgcy_pkg.get_lkup_meaning('CANCEL_OCCUR_ONLY','IGS_PS_LOG_PARAMETERS'));

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'));
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,' ');

Line 3685: fnd_message.set_token('TABLENAME',igs_ps_validate_lgcy_pkg.get_lkup_meaning('OCCURRENCES','IGS_PS_TABLE_NAME'));

3681: l_abort_count := 0;
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

Line 3700: fnd_message.set_token('PARAMETER_NAME',igs_ps_validate_lgcy_pkg.get_lkup_meaning('USEC_OCCRS_ID','IGS_PS_LOG_PARAMETERS'));

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);
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,' ');

Line 3774: fnd_message.set_token('TABLE',igs_ps_validate_lgcy_pkg.get_lkup_meaning('OCCURRENCES','IGS_PS_TABLE_NAME'));

3770: l_abort_count := l_abort_count +1;
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 );

Line 3777: fnd_message.set_token('TABLE',igs_ps_validate_lgcy_pkg.get_lkup_meaning('OCCURRENCES','IGS_PS_TABLE_NAME'));

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:
3780: l_abort_count:= 0;
3781: l_proc_count := 0;

Line 3785: fnd_message.set_token('TABLENAME',igs_ps_validate_lgcy_pkg.get_lkup_meaning('SECTIONS','IGS_PS_TABLE_NAME'));

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, ' ' );
3788:
3789: FOR c_int_usec_ss_rec IN c_int_usec_ss(l_ci_sequence_number,l_cal_type) LOOP

Line 3879: fnd_message.set_token('TABLE',igs_ps_validate_lgcy_pkg.get_lkup_meaning('SECTIONS','IGS_PS_TABLE_NAME'));

3875: l_proc_count := l_proc_count +1;
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 );

Line 3882: fnd_message.set_token('TABLE',igs_ps_validate_lgcy_pkg.get_lkup_meaning('SECTIONS','IGS_PS_TABLE_NAME'));

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:
3885: l_abort_count := 0;
3886: l_proc_count := 0;

Line 3890: fnd_message.set_token('TABLENAME',igs_ps_validate_lgcy_pkg.get_lkup_meaning('PATTERNS','IGS_PS_TABLE_NAME'));

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, ' ' );
3893:
3894: FOR c_int_pat_ss_rec IN c_int_pat_ss(l_ci_sequence_number,l_cal_type) LOOP

Line 3910: fnd_message.set_token('PARAMETER_NAME',igs_ps_validate_lgcy_pkg.get_lkup_meaning('TEACHING_PERIOD','IGS_PS_LOG_PARAMETERS'));

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);
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, ' ' );

Line 3947: fnd_message.set_token('TABLE',igs_ps_validate_lgcy_pkg.get_lkup_meaning('PATTERNS','IGS_PS_TABLE_NAME'));

3943: l_proc_count := l_proc_count +1;
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 );

Line 3950: fnd_message.set_token('TABLE',igs_ps_validate_lgcy_pkg.get_lkup_meaning('PATTERNS','IGS_PS_TABLE_NAME'));

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:
3953: EXCEPTION
3954: WHEN OTHERS THEN

Line 4082: fnd_message.set_token('PARAMETER_NAME',igs_ps_validate_lgcy_pkg.get_lkup_meaning('CAL_TYPE','LEGACY_TOKENS'));

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);
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'));

Line 4086: fnd_message.set_token('PARAMETER_NAME',igs_ps_validate_lgcy_pkg.get_lkup_meaning('START_DT','IGS_FI_LOCKBOX'));

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);
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'));

Line 4090: fnd_message.set_token('PARAMETER_NAME',igs_ps_validate_lgcy_pkg.get_lkup_meaning('END_DT','IGS_FI_LOCKBOX'));

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);
4093: fnd_file.put_line(fnd_file.log,'--------------------------------------------------------');
4094: fnd_file.put_line(fnd_file.log,' ');

Line 4331: log_messages(igs_ps_validate_lgcy_pkg.get_lkup_meaning('TEACHING','CAL_CAT'),l_alt_code,3);

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:
4335: PROCEDURE log_usec_details (p_c_unit_cd IN VARCHAR2,

Line 4357: log_messages(igs_ps_validate_lgcy_pkg.get_lkup_meaning('UNIT_CD','LEGACY_TOKENS'),p_c_unit_cd,10);

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);
4361: log_messages(igs_ps_validate_lgcy_pkg.get_lkup_meaning('ENROLLMENT_MAXIMUM','LEGACY_TOKENS'),p_n_enrollment_maximum,10);

Line 4358: log_messages(igs_ps_validate_lgcy_pkg.get_lkup_meaning('VERSION_NUMBER','IGS_PS_LOG_PARAMETERS'),p_n_version_number,10);

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);
4361: log_messages(igs_ps_validate_lgcy_pkg.get_lkup_meaning('ENROLLMENT_MAXIMUM','LEGACY_TOKENS'),p_n_enrollment_maximum,10);
4362:

Line 4359: log_messages(igs_ps_validate_lgcy_pkg.get_lkup_meaning('LOC','IGS_FI_ACCT_ENTITIES'),p_c_location_description,10);

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);
4361: log_messages(igs_ps_validate_lgcy_pkg.get_lkup_meaning('ENROLLMENT_MAXIMUM','LEGACY_TOKENS'),p_n_enrollment_maximum,10);
4362:
4363:

Line 4360: log_messages(igs_ps_validate_lgcy_pkg.get_lkup_meaning('UNIT_CLASS','LEGACY_TOKENS'),p_c_unit_class,10);

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);
4361: log_messages(igs_ps_validate_lgcy_pkg.get_lkup_meaning('ENROLLMENT_MAXIMUM','LEGACY_TOKENS'),p_n_enrollment_maximum,10);
4362:
4363:
4364: END log_usec_details;

Line 4361: log_messages(igs_ps_validate_lgcy_pkg.get_lkup_meaning('ENROLLMENT_MAXIMUM','LEGACY_TOKENS'),p_n_enrollment_maximum,10);

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);
4361: log_messages(igs_ps_validate_lgcy_pkg.get_lkup_meaning('ENROLLMENT_MAXIMUM','LEGACY_TOKENS'),p_n_enrollment_maximum,10);
4362:
4363:
4364: END log_usec_details;
4365:

Line 4425: l_str := igs_ps_validate_lgcy_pkg.get_lkup_meaning('MONDAY','DT_OFFSET_CONSTRAINT_TYPE')||' ';

4421: FETCH c_ins_name INTO rec_ins_name;
4422: CLOSE c_ins_name;
4423:
4424: IF p_usec_occur_rec.monday = 'Y' THEN
4425: l_str := igs_ps_validate_lgcy_pkg.get_lkup_meaning('MONDAY','DT_OFFSET_CONSTRAINT_TYPE')||' ';
4426: END IF;
4427:
4428: IF p_usec_occur_rec.tuesday = 'Y' THEN
4429: l_str := l_str || igs_ps_validate_lgcy_pkg.get_lkup_meaning('TUESDAY','DT_OFFSET_CONSTRAINT_TYPE')||' ';

Line 4429: l_str := l_str || igs_ps_validate_lgcy_pkg.get_lkup_meaning('TUESDAY','DT_OFFSET_CONSTRAINT_TYPE')||' ';

4425: l_str := igs_ps_validate_lgcy_pkg.get_lkup_meaning('MONDAY','DT_OFFSET_CONSTRAINT_TYPE')||' ';
4426: END IF;
4427:
4428: IF p_usec_occur_rec.tuesday = 'Y' THEN
4429: l_str := l_str || igs_ps_validate_lgcy_pkg.get_lkup_meaning('TUESDAY','DT_OFFSET_CONSTRAINT_TYPE')||' ';
4430: END IF;
4431:
4432: IF p_usec_occur_rec.wednesday = 'Y' THEN
4433: l_str := l_str || igs_ps_validate_lgcy_pkg.get_lkup_meaning('WEDNESDAY','DT_OFFSET_CONSTRAINT_TYPE')||' ';

Line 4433: l_str := l_str || igs_ps_validate_lgcy_pkg.get_lkup_meaning('WEDNESDAY','DT_OFFSET_CONSTRAINT_TYPE')||' ';

4429: l_str := l_str || igs_ps_validate_lgcy_pkg.get_lkup_meaning('TUESDAY','DT_OFFSET_CONSTRAINT_TYPE')||' ';
4430: END IF;
4431:
4432: IF p_usec_occur_rec.wednesday = 'Y' THEN
4433: l_str := l_str || igs_ps_validate_lgcy_pkg.get_lkup_meaning('WEDNESDAY','DT_OFFSET_CONSTRAINT_TYPE')||' ';
4434: END IF;
4435:
4436: IF p_usec_occur_rec.thursday = 'Y' THEN
4437: l_str := l_str || igs_ps_validate_lgcy_pkg.get_lkup_meaning('THURSDAY','DT_OFFSET_CONSTRAINT_TYPE')||' ';

Line 4437: l_str := l_str || igs_ps_validate_lgcy_pkg.get_lkup_meaning('THURSDAY','DT_OFFSET_CONSTRAINT_TYPE')||' ';

4433: l_str := l_str || igs_ps_validate_lgcy_pkg.get_lkup_meaning('WEDNESDAY','DT_OFFSET_CONSTRAINT_TYPE')||' ';
4434: END IF;
4435:
4436: IF p_usec_occur_rec.thursday = 'Y' THEN
4437: l_str := l_str || igs_ps_validate_lgcy_pkg.get_lkup_meaning('THURSDAY','DT_OFFSET_CONSTRAINT_TYPE')||' ';
4438: END IF;
4439:
4440: IF p_usec_occur_rec.friday = 'Y' THEN
4441: l_str := l_str || igs_ps_validate_lgcy_pkg.get_lkup_meaning('FRIDAY','DT_OFFSET_CONSTRAINT_TYPE')||' ';

Line 4441: l_str := l_str || igs_ps_validate_lgcy_pkg.get_lkup_meaning('FRIDAY','DT_OFFSET_CONSTRAINT_TYPE')||' ';

4437: l_str := l_str || igs_ps_validate_lgcy_pkg.get_lkup_meaning('THURSDAY','DT_OFFSET_CONSTRAINT_TYPE')||' ';
4438: END IF;
4439:
4440: IF p_usec_occur_rec.friday = 'Y' THEN
4441: l_str := l_str || igs_ps_validate_lgcy_pkg.get_lkup_meaning('FRIDAY','DT_OFFSET_CONSTRAINT_TYPE')||' ';
4442: END IF;
4443:
4444: IF p_usec_occur_rec.saturday = 'Y' THEN
4445: l_str := l_str || igs_ps_validate_lgcy_pkg.get_lkup_meaning('SATURDAY','DT_OFFSET_CONSTRAINT_TYPE')||' ';

Line 4445: l_str := l_str || igs_ps_validate_lgcy_pkg.get_lkup_meaning('SATURDAY','DT_OFFSET_CONSTRAINT_TYPE')||' ';

4441: l_str := l_str || igs_ps_validate_lgcy_pkg.get_lkup_meaning('FRIDAY','DT_OFFSET_CONSTRAINT_TYPE')||' ';
4442: END IF;
4443:
4444: IF p_usec_occur_rec.saturday = 'Y' THEN
4445: l_str := l_str || igs_ps_validate_lgcy_pkg.get_lkup_meaning('SATURDAY','DT_OFFSET_CONSTRAINT_TYPE')||' ';
4446: END IF;
4447:
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')||' ';

Line 4449: l_str := l_str || igs_ps_validate_lgcy_pkg.get_lkup_meaning('SUNDAY','DT_OFFSET_CONSTRAINT_TYPE')||' ';

4445: l_str := l_str || igs_ps_validate_lgcy_pkg.get_lkup_meaning('SATURDAY','DT_OFFSET_CONSTRAINT_TYPE')||' ';
4446: END IF;
4447:
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);

Line 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);

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);
4457: FETCH cur_lookup_meaning INTO l_sch_status_desc;

Line 4454: log_messages(igs_ps_validate_lgcy_pkg.get_lkup_meaning('TRANSACTION_TYPE','IGS_PS_LOG_PARAMETERS'),p_c_trans_type,20);

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);
4457: FETCH cur_lookup_meaning INTO l_sch_status_desc;
4458: CLOSE cur_lookup_meaning;

Line 4459: log_messages(igs_ps_validate_lgcy_pkg.get_lkup_meaning('SCHEDULE_STATUS','IGS_PS_LOG_PARAMETERS'),l_sch_status_desc,20);

4455:
4456: OPEN cur_lookup_meaning('SCHEDULE_TYPE',p_usec_occur_rec.schedule_status);
4457: FETCH cur_lookup_meaning INTO l_sch_status_desc;
4458: CLOSE cur_lookup_meaning;
4459: log_messages(igs_ps_validate_lgcy_pkg.get_lkup_meaning('SCHEDULE_STATUS','IGS_PS_LOG_PARAMETERS'),l_sch_status_desc,20);
4460:
4461: log_messages(igs_ps_validate_lgcy_pkg.get_lkup_meaning('USEC_OCCUR_DATES','IGS_PS_LOG_PARAMETERS'),
4462: TO_CHAR(p_usec_occur_rec.start_date,'DD MON YYYY')||' - '||TO_CHAR(p_usec_occur_rec.end_date,'DD MON YYYY'),20);
4463: log_messages(igs_ps_validate_lgcy_pkg.get_lkup_meaning('TBA_IND','IGS_PS_LOG_PARAMETERS'),NVL(p_usec_occur_rec.to_be_announced,'N'),20);

Line 4461: log_messages(igs_ps_validate_lgcy_pkg.get_lkup_meaning('USEC_OCCUR_DATES','IGS_PS_LOG_PARAMETERS'),

4457: FETCH cur_lookup_meaning INTO l_sch_status_desc;
4458: CLOSE cur_lookup_meaning;
4459: log_messages(igs_ps_validate_lgcy_pkg.get_lkup_meaning('SCHEDULE_STATUS','IGS_PS_LOG_PARAMETERS'),l_sch_status_desc,20);
4460:
4461: log_messages(igs_ps_validate_lgcy_pkg.get_lkup_meaning('USEC_OCCUR_DATES','IGS_PS_LOG_PARAMETERS'),
4462: TO_CHAR(p_usec_occur_rec.start_date,'DD MON YYYY')||' - '||TO_CHAR(p_usec_occur_rec.end_date,'DD MON YYYY'),20);
4463: log_messages(igs_ps_validate_lgcy_pkg.get_lkup_meaning('TBA_IND','IGS_PS_LOG_PARAMETERS'),NVL(p_usec_occur_rec.to_be_announced,'N'),20);
4464: log_messages(igs_ps_validate_lgcy_pkg.get_lkup_meaning('DAYS','IGS_PS_PROGRAM_LENGTH_MESR'),l_str,20);
4465: log_messages(igs_ps_validate_lgcy_pkg.get_lkup_meaning('TIME','IGS_PS_LOG_PARAMETERS'),

Line 4463: log_messages(igs_ps_validate_lgcy_pkg.get_lkup_meaning('TBA_IND','IGS_PS_LOG_PARAMETERS'),NVL(p_usec_occur_rec.to_be_announced,'N'),20);

4459: log_messages(igs_ps_validate_lgcy_pkg.get_lkup_meaning('SCHEDULE_STATUS','IGS_PS_LOG_PARAMETERS'),l_sch_status_desc,20);
4460:
4461: log_messages(igs_ps_validate_lgcy_pkg.get_lkup_meaning('USEC_OCCUR_DATES','IGS_PS_LOG_PARAMETERS'),
4462: TO_CHAR(p_usec_occur_rec.start_date,'DD MON YYYY')||' - '||TO_CHAR(p_usec_occur_rec.end_date,'DD MON YYYY'),20);
4463: log_messages(igs_ps_validate_lgcy_pkg.get_lkup_meaning('TBA_IND','IGS_PS_LOG_PARAMETERS'),NVL(p_usec_occur_rec.to_be_announced,'N'),20);
4464: log_messages(igs_ps_validate_lgcy_pkg.get_lkup_meaning('DAYS','IGS_PS_PROGRAM_LENGTH_MESR'),l_str,20);
4465: log_messages(igs_ps_validate_lgcy_pkg.get_lkup_meaning('TIME','IGS_PS_LOG_PARAMETERS'),
4466: TO_CHAR(p_usec_occur_rec.start_time,'HH24:MIam')||' - '||TO_CHAR(p_usec_occur_rec.end_time,'HH24:MIam'),20);
4467: log_messages(igs_ps_validate_lgcy_pkg.get_lkup_meaning('INSTRUCTOR_NAME','IGS_AS_ADV_SEARCH'),rec_ins_name.first_name||' '||rec_ins_name.last_name,20);

Line 4464: log_messages(igs_ps_validate_lgcy_pkg.get_lkup_meaning('DAYS','IGS_PS_PROGRAM_LENGTH_MESR'),l_str,20);

4460:
4461: log_messages(igs_ps_validate_lgcy_pkg.get_lkup_meaning('USEC_OCCUR_DATES','IGS_PS_LOG_PARAMETERS'),
4462: TO_CHAR(p_usec_occur_rec.start_date,'DD MON YYYY')||' - '||TO_CHAR(p_usec_occur_rec.end_date,'DD MON YYYY'),20);
4463: log_messages(igs_ps_validate_lgcy_pkg.get_lkup_meaning('TBA_IND','IGS_PS_LOG_PARAMETERS'),NVL(p_usec_occur_rec.to_be_announced,'N'),20);
4464: log_messages(igs_ps_validate_lgcy_pkg.get_lkup_meaning('DAYS','IGS_PS_PROGRAM_LENGTH_MESR'),l_str,20);
4465: log_messages(igs_ps_validate_lgcy_pkg.get_lkup_meaning('TIME','IGS_PS_LOG_PARAMETERS'),
4466: TO_CHAR(p_usec_occur_rec.start_time,'HH24:MIam')||' - '||TO_CHAR(p_usec_occur_rec.end_time,'HH24:MIam'),20);
4467: log_messages(igs_ps_validate_lgcy_pkg.get_lkup_meaning('INSTRUCTOR_NAME','IGS_AS_ADV_SEARCH'),rec_ins_name.first_name||' '||rec_ins_name.last_name,20);
4468:

Line 4465: log_messages(igs_ps_validate_lgcy_pkg.get_lkup_meaning('TIME','IGS_PS_LOG_PARAMETERS'),

4461: log_messages(igs_ps_validate_lgcy_pkg.get_lkup_meaning('USEC_OCCUR_DATES','IGS_PS_LOG_PARAMETERS'),
4462: TO_CHAR(p_usec_occur_rec.start_date,'DD MON YYYY')||' - '||TO_CHAR(p_usec_occur_rec.end_date,'DD MON YYYY'),20);
4463: log_messages(igs_ps_validate_lgcy_pkg.get_lkup_meaning('TBA_IND','IGS_PS_LOG_PARAMETERS'),NVL(p_usec_occur_rec.to_be_announced,'N'),20);
4464: log_messages(igs_ps_validate_lgcy_pkg.get_lkup_meaning('DAYS','IGS_PS_PROGRAM_LENGTH_MESR'),l_str,20);
4465: log_messages(igs_ps_validate_lgcy_pkg.get_lkup_meaning('TIME','IGS_PS_LOG_PARAMETERS'),
4466: TO_CHAR(p_usec_occur_rec.start_time,'HH24:MIam')||' - '||TO_CHAR(p_usec_occur_rec.end_time,'HH24:MIam'),20);
4467: log_messages(igs_ps_validate_lgcy_pkg.get_lkup_meaning('INSTRUCTOR_NAME','IGS_AS_ADV_SEARCH'),rec_ins_name.first_name||' '||rec_ins_name.last_name,20);
4468:
4469: -- Following transferred information is printed in log file if procedure log_usec_occurs is called from

Line 4467: log_messages(igs_ps_validate_lgcy_pkg.get_lkup_meaning('INSTRUCTOR_NAME','IGS_AS_ADV_SEARCH'),rec_ins_name.first_name||' '||rec_ins_name.last_name,20);

4463: log_messages(igs_ps_validate_lgcy_pkg.get_lkup_meaning('TBA_IND','IGS_PS_LOG_PARAMETERS'),NVL(p_usec_occur_rec.to_be_announced,'N'),20);
4464: log_messages(igs_ps_validate_lgcy_pkg.get_lkup_meaning('DAYS','IGS_PS_PROGRAM_LENGTH_MESR'),l_str,20);
4465: log_messages(igs_ps_validate_lgcy_pkg.get_lkup_meaning('TIME','IGS_PS_LOG_PARAMETERS'),
4466: TO_CHAR(p_usec_occur_rec.start_time,'HH24:MIam')||' - '||TO_CHAR(p_usec_occur_rec.end_time,'HH24:MIam'),20);
4467: log_messages(igs_ps_validate_lgcy_pkg.get_lkup_meaning('INSTRUCTOR_NAME','IGS_AS_ADV_SEARCH'),rec_ins_name.first_name||' '||rec_ins_name.last_name,20);
4468:
4469: -- Following transferred information is printed in log file if procedure log_usec_occurs is called from
4470: -- Initiate Scheduling Unit Section Occurrence process
4471: IF p_c_call = 'I' THEN

Line 4475: log_messages(igs_ps_validate_lgcy_pkg.get_lkup_meaning('IGSPS130-CG$TABPAGE_2','GE_CFG_TAB'),l_prf_reg_desc,20);

4471: IF p_c_call = 'I' THEN
4472: OPEN cur_lookup_meaning('IGS_OR_LOC_REGION',p_usec_occur_rec.preferred_region_code);
4473: FETCH cur_lookup_meaning INTO l_prf_reg_desc;
4474: CLOSE cur_lookup_meaning;
4475: log_messages(igs_ps_validate_lgcy_pkg.get_lkup_meaning('IGSPS130-CG$TABPAGE_2','GE_CFG_TAB'),l_prf_reg_desc,20);
4476: END IF;
4477:
4478: OPEN bld_desc(p_usec_occur_rec.building_code);
4479: FETCH bld_desc INTO l_sch_bld_desc;

Line 4487: log_messages(igs_ps_validate_lgcy_pkg.get_lkup_meaning('SCHEDULED_BLD','IGS_PS_LOG_PARAMETERS'),l_sch_bld_desc,20);

4483: FETCH rom_desc INTO l_sch_rom_desc;
4484: CLOSE rom_desc;
4485:
4486:
4487: log_messages(igs_ps_validate_lgcy_pkg.get_lkup_meaning('SCHEDULED_BLD','IGS_PS_LOG_PARAMETERS'),l_sch_bld_desc,20);
4488: log_messages(igs_ps_validate_lgcy_pkg.get_lkup_meaning('SCHEDULED_ROOM','IGS_PS_LOG_PARAMETERS'),l_sch_rom_desc,20);
4489:
4490: -- Following transferred information is printed in log file if procedure log_usec_occurs is called from
4491: -- Initiate Scheduling Unit Section Occurrence process

Line 4488: log_messages(igs_ps_validate_lgcy_pkg.get_lkup_meaning('SCHEDULED_ROOM','IGS_PS_LOG_PARAMETERS'),l_sch_rom_desc,20);

4484: CLOSE rom_desc;
4485:
4486:
4487: log_messages(igs_ps_validate_lgcy_pkg.get_lkup_meaning('SCHEDULED_BLD','IGS_PS_LOG_PARAMETERS'),l_sch_bld_desc,20);
4488: log_messages(igs_ps_validate_lgcy_pkg.get_lkup_meaning('SCHEDULED_ROOM','IGS_PS_LOG_PARAMETERS'),l_sch_rom_desc,20);
4489:
4490: -- Following transferred information is printed in log file if procedure log_usec_occurs is called from
4491: -- Initiate Scheduling Unit Section Occurrence process
4492: IF p_c_call = 'I' THEN

Line 4500: log_messages(igs_ps_validate_lgcy_pkg.get_lkup_meaning('DEDICATED_BLD','IGS_PS_LOG_PARAMETERS'),l_ded_bld_desc,20);

4496:
4497: OPEN rom_desc(p_usec_occur_rec.dedicated_room_code);
4498: FETCH rom_desc INTO l_ded_rom_desc;
4499: CLOSE rom_desc;
4500: log_messages(igs_ps_validate_lgcy_pkg.get_lkup_meaning('DEDICATED_BLD','IGS_PS_LOG_PARAMETERS'),l_ded_bld_desc,20);
4501: log_messages(igs_ps_validate_lgcy_pkg.get_lkup_meaning('DEDICATED_ROOM','IGS_PS_LOG_PARAMETERS'),l_ded_rom_desc,20);
4502:
4503: OPEN bld_desc(p_usec_occur_rec.preferred_building_code);
4504: FETCH bld_desc INTO l_prf_bld_desc;

Line 4501: log_messages(igs_ps_validate_lgcy_pkg.get_lkup_meaning('DEDICATED_ROOM','IGS_PS_LOG_PARAMETERS'),l_ded_rom_desc,20);

4497: OPEN rom_desc(p_usec_occur_rec.dedicated_room_code);
4498: FETCH rom_desc INTO l_ded_rom_desc;
4499: CLOSE rom_desc;
4500: log_messages(igs_ps_validate_lgcy_pkg.get_lkup_meaning('DEDICATED_BLD','IGS_PS_LOG_PARAMETERS'),l_ded_bld_desc,20);
4501: log_messages(igs_ps_validate_lgcy_pkg.get_lkup_meaning('DEDICATED_ROOM','IGS_PS_LOG_PARAMETERS'),l_ded_rom_desc,20);
4502:
4503: OPEN bld_desc(p_usec_occur_rec.preferred_building_code);
4504: FETCH bld_desc INTO l_prf_bld_desc;
4505: CLOSE bld_desc;

Line 4510: log_messages(igs_ps_validate_lgcy_pkg.get_lkup_meaning('PREFERRED_BLD','IGS_PS_LOG_PARAMETERS'),l_prf_bld_desc,20);

4506:
4507: OPEN rom_desc(p_usec_occur_rec.preferred_room_code);
4508: FETCH rom_desc INTO l_prf_rom_desc;
4509: CLOSE rom_desc;
4510: log_messages(igs_ps_validate_lgcy_pkg.get_lkup_meaning('PREFERRED_BLD','IGS_PS_LOG_PARAMETERS'),l_prf_bld_desc,20);
4511: log_messages(igs_ps_validate_lgcy_pkg.get_lkup_meaning('PREFERRED_ROOM','IGS_PS_LOG_PARAMETERS'),l_prf_rom_desc,20);
4512: END IF;
4513:
4514: -- Following transferred information is printed in log file if procedure log_usec_occurs is called from

Line 4511: log_messages(igs_ps_validate_lgcy_pkg.get_lkup_meaning('PREFERRED_ROOM','IGS_PS_LOG_PARAMETERS'),l_prf_rom_desc,20);

4507: OPEN rom_desc(p_usec_occur_rec.preferred_room_code);
4508: FETCH rom_desc INTO l_prf_rom_desc;
4509: CLOSE rom_desc;
4510: log_messages(igs_ps_validate_lgcy_pkg.get_lkup_meaning('PREFERRED_BLD','IGS_PS_LOG_PARAMETERS'),l_prf_bld_desc,20);
4511: log_messages(igs_ps_validate_lgcy_pkg.get_lkup_meaning('PREFERRED_ROOM','IGS_PS_LOG_PARAMETERS'),l_prf_rom_desc,20);
4512: END IF;
4513:
4514: -- Following transferred information is printed in log file if procedure log_usec_occurs is called from
4515: -- Get Interface Scheduled data process

Line 4517: log_messages(igs_ps_validate_lgcy_pkg.get_lkup_meaning('ERROR_TEXT','IGS_PS_LOG_PARAMETERS'),p_usec_occur_rec.error_text,20);

4513:
4514: -- Following transferred information is printed in log file if procedure log_usec_occurs is called from
4515: -- Get Interface Scheduled data process
4516: IF p_c_call = 'G' THEN
4517: log_messages(igs_ps_validate_lgcy_pkg.get_lkup_meaning('ERROR_TEXT','IGS_PS_LOG_PARAMETERS'),p_usec_occur_rec.error_text,20);
4518: END IF;
4519:
4520: END log_usec_occurs;
4521: