DBA Data[Home] [Help]

APPS.IGF_AP_GEN_001 dependencies on FND_LOG

Line 133: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN -- Log Level Check

129: -- If there is no enrollment rec for the student use Admissions data to get the start date.
130: IF lv_course_start_dt IS NULL THEN -- Enrollment Start Date Check
131: lv_course_start_dt := igs_ad_gen_005.admp_get_crv_strt_dt(l_adm_appl.adm_cal_type, l_adm_appl.adm_ci_sequence_number);
132: END IF; -- End Enrollment Start Date Check
133: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN -- Log Level Check
134: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_ap_gen_001.get_anticip_compl_date.debug',
135: '| start date ' || to_char(lv_course_start_dt, 'mm/dd/yyyy')||
136: '| l_person_id ' || l_person_id ||
137: '| x_course_cd ' || x_course_cd ||

Line 134: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_ap_gen_001.get_anticip_compl_date.debug',

130: IF lv_course_start_dt IS NULL THEN -- Enrollment Start Date Check
131: lv_course_start_dt := igs_ad_gen_005.admp_get_crv_strt_dt(l_adm_appl.adm_cal_type, l_adm_appl.adm_ci_sequence_number);
132: END IF; -- End Enrollment Start Date Check
133: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN -- Log Level Check
134: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_ap_gen_001.get_anticip_compl_date.debug',
135: '| start date ' || to_char(lv_course_start_dt, 'mm/dd/yyyy')||
136: '| l_person_id ' || l_person_id ||
137: '| x_course_cd ' || x_course_cd ||
138: '| l_key_program.course_cd ' || l_key_program.course_cd ||

Line 382: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

378: BEGIN
379: -- For the person in the award year loop. is this loop required ?
380: FOR l_base_rec IN C_FA_BASE_REC(cp_fa_base_id) LOOP
381: IF TRUNC(SYSDATE) BETWEEN TRUNC(l_base_rec.start_dt) AND TRUNC(l_base_rec.End_dt) THEN
382: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
383: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_ap_gen_001.get_term_dtl.debug',
384: 'sysdate between base record start date '||l_base_rec.start_dt||' and base record end date '|| l_base_rec.End_dt);
385: END IF;
386: -- the award year is current award year. get the current term based on sysdate and look into the term details

Line 383: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_ap_gen_001.get_term_dtl.debug',

379: -- For the person in the award year loop. is this loop required ?
380: FOR l_base_rec IN C_FA_BASE_REC(cp_fa_base_id) LOOP
381: IF TRUNC(SYSDATE) BETWEEN TRUNC(l_base_rec.start_dt) AND TRUNC(l_base_rec.End_dt) THEN
382: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
383: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_ap_gen_001.get_term_dtl.debug',
384: 'sysdate between base record start date '||l_base_rec.start_dt||' and base record end date '|| l_base_rec.End_dt);
385: END IF;
386: -- the award year is current award year. get the current term based on sysdate and look into the term details
387: FOR l_term_rec in c_ld_calendars_start(l_base_rec.ci_cal_type, l_base_rec.ci_sequence_number) LOOP

Line 389: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

385: END IF;
386: -- the award year is current award year. get the current term based on sysdate and look into the term details
387: FOR l_term_rec in c_ld_calendars_start(l_base_rec.ci_cal_type, l_base_rec.ci_sequence_number) LOOP
388: IF TRUNC(SYSDATE) BETWEEN l_term_rec.enrolled_start_dt AND l_term_rec.enrolled_end_dt THEN
389: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
390: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_ap_gen_001.get_term_dtl.debug',
391: 'sysdate between term start date '||l_term_rec.enrolled_start_dt||' and term end date '|| l_term_rec.enrolled_end_dt);
392: END IF;
393: FOR x_term_enr_dtl_rec IN c_spa_terms(l_base_rec.person_id,l_term_rec.enrl_load_cal_type,l_term_rec.enrl_load_seq_num)LOOP

Line 390: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_ap_gen_001.get_term_dtl.debug',

386: -- the award year is current award year. get the current term based on sysdate and look into the term details
387: FOR l_term_rec in c_ld_calendars_start(l_base_rec.ci_cal_type, l_base_rec.ci_sequence_number) LOOP
388: IF TRUNC(SYSDATE) BETWEEN l_term_rec.enrolled_start_dt AND l_term_rec.enrolled_end_dt THEN
389: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
390: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_ap_gen_001.get_term_dtl.debug',
391: 'sysdate between term start date '||l_term_rec.enrolled_start_dt||' and term end date '|| l_term_rec.enrolled_end_dt);
392: END IF;
393: FOR x_term_enr_dtl_rec IN c_spa_terms(l_base_rec.person_id,l_term_rec.enrl_load_cal_type,l_term_rec.enrl_load_seq_num)LOOP
394: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 394: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

390: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_ap_gen_001.get_term_dtl.debug',
391: 'sysdate between term start date '||l_term_rec.enrolled_start_dt||' and term end date '|| l_term_rec.enrolled_end_dt);
392: END IF;
393: FOR x_term_enr_dtl_rec IN c_spa_terms(l_base_rec.person_id,l_term_rec.enrl_load_cal_type,l_term_rec.enrl_load_seq_num)LOOP
394: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
395: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_ap_gen_001.get_term_dtl.debug',
396: 'term record for person id '||l_base_rec.person_id||' enr load cal type '|| l_term_rec.enrl_load_cal_type || 'load seq number '||l_term_rec.enrl_load_seq_num);
397: END IF;
398: cp_term_enr_dtl_rec := x_term_enr_dtl_rec;

Line 395: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_ap_gen_001.get_term_dtl.debug',

391: 'sysdate between term start date '||l_term_rec.enrolled_start_dt||' and term end date '|| l_term_rec.enrolled_end_dt);
392: END IF;
393: FOR x_term_enr_dtl_rec IN c_spa_terms(l_base_rec.person_id,l_term_rec.enrl_load_cal_type,l_term_rec.enrl_load_seq_num)LOOP
394: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
395: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_ap_gen_001.get_term_dtl.debug',
396: 'term record for person id '||l_base_rec.person_id||' enr load cal type '|| l_term_rec.enrl_load_cal_type || 'load seq number '||l_term_rec.enrl_load_seq_num);
397: END IF;
398: cp_term_enr_dtl_rec := x_term_enr_dtl_rec;
399: RETURN;

Line 406: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

402: END LOOP;
403:
404: -- if the end date of the award year is past. i.e. < sysdate then process the term cals desc
405: ELSIF TRUNC(l_base_rec.End_dt) < TRUNC(sysdate) THEN
406: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
407: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_ap_gen_001.get_term_dtl.debug',
408: 'sysdate past base record end date '||l_base_rec.start_dt||' and base record end date '|| l_base_rec.End_dt);
409: END IF;
410:

Line 407: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_ap_gen_001.get_term_dtl.debug',

403:
404: -- if the end date of the award year is past. i.e. < sysdate then process the term cals desc
405: ELSIF TRUNC(l_base_rec.End_dt) < TRUNC(sysdate) THEN
406: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
407: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_ap_gen_001.get_term_dtl.debug',
408: 'sysdate past base record end date '||l_base_rec.start_dt||' and base record end date '|| l_base_rec.End_dt);
409: END IF;
410:
411: FOR l_term_rec in c_ld_calendars_end(l_base_rec.ci_cal_type, l_base_rec.ci_sequence_number) LOOP

Line 412: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

408: 'sysdate past base record end date '||l_base_rec.start_dt||' and base record end date '|| l_base_rec.End_dt);
409: END IF;
410:
411: FOR l_term_rec in c_ld_calendars_end(l_base_rec.ci_cal_type, l_base_rec.ci_sequence_number) LOOP
412: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
413: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_ap_gen_001.get_term_dtl.debug',
414: ' term start date for past awd year'||l_term_rec.enrolled_start_dt||' and term end date for past awd year'|| l_term_rec.enrolled_end_dt);
415: END IF;
416:

Line 413: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_ap_gen_001.get_term_dtl.debug',

409: END IF;
410:
411: FOR l_term_rec in c_ld_calendars_end(l_base_rec.ci_cal_type, l_base_rec.ci_sequence_number) LOOP
412: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
413: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_ap_gen_001.get_term_dtl.debug',
414: ' term start date for past awd year'||l_term_rec.enrolled_start_dt||' and term end date for past awd year'|| l_term_rec.enrolled_end_dt);
415: END IF;
416:
417: FOR x_term_enr_dtl_rec IN c_spa_terms(l_base_rec.person_id,l_term_rec.enrl_load_cal_type,l_term_rec.enrl_load_seq_num) LOOP

Line 418: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

414: ' term start date for past awd year'||l_term_rec.enrolled_start_dt||' and term end date for past awd year'|| l_term_rec.enrolled_end_dt);
415: END IF;
416:
417: FOR x_term_enr_dtl_rec IN c_spa_terms(l_base_rec.person_id,l_term_rec.enrl_load_cal_type,l_term_rec.enrl_load_seq_num) LOOP
418: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
419: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_ap_gen_001.get_term_dtl.debug',
420: 'past term record for person id '||l_base_rec.person_id||' enr load cal type '|| l_term_rec.enrl_load_cal_type || 'load seq number '||l_term_rec.enrl_load_seq_num);
421: END IF;
422: cp_term_enr_dtl_rec := x_term_enr_dtl_rec;

Line 419: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_ap_gen_001.get_term_dtl.debug',

415: END IF;
416:
417: FOR x_term_enr_dtl_rec IN c_spa_terms(l_base_rec.person_id,l_term_rec.enrl_load_cal_type,l_term_rec.enrl_load_seq_num) LOOP
418: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
419: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_ap_gen_001.get_term_dtl.debug',
420: 'past term record for person id '||l_base_rec.person_id||' enr load cal type '|| l_term_rec.enrl_load_cal_type || 'load seq number '||l_term_rec.enrl_load_seq_num);
421: END IF;
422: cp_term_enr_dtl_rec := x_term_enr_dtl_rec;
423: RETURN;

Line 428: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

424: END LOOP;
425: END LOOP;
426: -- if the award year is a future award year then process the term cals asc
427: ELSIF TRUNC(l_base_rec.start_dt) > TRUNC(sysdate) THEN
428: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
429: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_ap_gen_001.get_term_dtl.debug',
430: 'sysdate before base record end date '||l_base_rec.start_dt||' and base record end date '|| l_base_rec.End_dt);
431: END IF;
432: FOR l_term_rec in c_ld_calendars_start(l_base_rec.ci_cal_type, l_base_rec.ci_sequence_number) LOOP

Line 429: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_ap_gen_001.get_term_dtl.debug',

425: END LOOP;
426: -- if the award year is a future award year then process the term cals asc
427: ELSIF TRUNC(l_base_rec.start_dt) > TRUNC(sysdate) THEN
428: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
429: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_ap_gen_001.get_term_dtl.debug',
430: 'sysdate before base record end date '||l_base_rec.start_dt||' and base record end date '|| l_base_rec.End_dt);
431: END IF;
432: FOR l_term_rec in c_ld_calendars_start(l_base_rec.ci_cal_type, l_base_rec.ci_sequence_number) LOOP
433: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 433: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

429: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_ap_gen_001.get_term_dtl.debug',
430: 'sysdate before base record end date '||l_base_rec.start_dt||' and base record end date '|| l_base_rec.End_dt);
431: END IF;
432: FOR l_term_rec in c_ld_calendars_start(l_base_rec.ci_cal_type, l_base_rec.ci_sequence_number) LOOP
433: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
434: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_ap_gen_001.get_term_dtl.debug',
435: 'future term record for person id '||l_base_rec.person_id||' enr load cal type '|| l_term_rec.enrl_load_cal_type || 'load seq number '||l_term_rec.enrl_load_seq_num);
436: END IF;
437: FOR x_term_enr_dtl_rec IN c_spa_terms(l_base_rec.person_id,l_term_rec.enrl_load_cal_type,l_term_rec.enrl_load_seq_num) LOOP

Line 434: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_ap_gen_001.get_term_dtl.debug',

430: 'sysdate before base record end date '||l_base_rec.start_dt||' and base record end date '|| l_base_rec.End_dt);
431: END IF;
432: FOR l_term_rec in c_ld_calendars_start(l_base_rec.ci_cal_type, l_base_rec.ci_sequence_number) LOOP
433: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
434: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_ap_gen_001.get_term_dtl.debug',
435: 'future term record for person id '||l_base_rec.person_id||' enr load cal type '|| l_term_rec.enrl_load_cal_type || 'load seq number '||l_term_rec.enrl_load_seq_num);
436: END IF;
437: FOR x_term_enr_dtl_rec IN c_spa_terms(l_base_rec.person_id,l_term_rec.enrl_load_cal_type,l_term_rec.enrl_load_seq_num) LOOP
438: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 438: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

434: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_ap_gen_001.get_term_dtl.debug',
435: 'future term record for person id '||l_base_rec.person_id||' enr load cal type '|| l_term_rec.enrl_load_cal_type || 'load seq number '||l_term_rec.enrl_load_seq_num);
436: END IF;
437: FOR x_term_enr_dtl_rec IN c_spa_terms(l_base_rec.person_id,l_term_rec.enrl_load_cal_type,l_term_rec.enrl_load_seq_num) LOOP
438: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
439: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_ap_gen_001.get_term_dtl.debug',
440: 'future term record for person id '||l_base_rec.person_id||' enr load cal type '|| l_term_rec.enrl_load_cal_type || 'load seq number '||l_term_rec.enrl_load_seq_num);
441: END IF;
442: cp_term_enr_dtl_rec := x_term_enr_dtl_rec;

Line 439: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_ap_gen_001.get_term_dtl.debug',

435: 'future term record for person id '||l_base_rec.person_id||' enr load cal type '|| l_term_rec.enrl_load_cal_type || 'load seq number '||l_term_rec.enrl_load_seq_num);
436: END IF;
437: FOR x_term_enr_dtl_rec IN c_spa_terms(l_base_rec.person_id,l_term_rec.enrl_load_cal_type,l_term_rec.enrl_load_seq_num) LOOP
438: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
439: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_ap_gen_001.get_term_dtl.debug',
440: 'future term record for person id '||l_base_rec.person_id||' enr load cal type '|| l_term_rec.enrl_load_cal_type || 'load seq number '||l_term_rec.enrl_load_seq_num);
441: END IF;
442: cp_term_enr_dtl_rec := x_term_enr_dtl_rec;
443: RETURN;

Line 449: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

445: END LOOP;
446: END IF;
447: -- the control reached here. so no term records for the load calendars. peep into the prog att table directly and return the values
448: l_person_id := igf_gr_Gen.get_person_id(cp_fa_base_id);
449: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
450: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_ap_gen_001.get_term_dtl.debug',
451: 'no term record details available for '||cp_fa_base_id);
452: END IF;
453: OPEN c_spa (l_person_id);

Line 450: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_ap_gen_001.get_term_dtl.debug',

446: END IF;
447: -- the control reached here. so no term records for the load calendars. peep into the prog att table directly and return the values
448: l_person_id := igf_gr_Gen.get_person_id(cp_fa_base_id);
449: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
450: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_ap_gen_001.get_term_dtl.debug',
451: 'no term record details available for '||cp_fa_base_id);
452: END IF;
453: OPEN c_spa (l_person_id);
454: FETCH c_spa INTO l_spa_rec;

Line 668: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

664: lc_program_type,
665: lc_org_unit
666: );
667:
668: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
669: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_gen_001.get_term_dates.debug','get_context_data_for_term -> p_ld_cal_type/p_ld_sequence_number/lc_org_unit/lc_program_type/lc_program_cd/lc_version_num ->'
670: || '<>' || p_ld_cal_type || '<>' || p_ld_sequence_number || '<>' || lc_org_unit || '<>'
671: || lc_program_type || '<>' || lc_program_cd || '<>' || lc_version_num);
672: END IF;

Line 669: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_gen_001.get_term_dates.debug','get_context_data_for_term -> p_ld_cal_type/p_ld_sequence_number/lc_org_unit/lc_program_type/lc_program_cd/lc_version_num ->'

665: lc_org_unit
666: );
667:
668: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
669: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_gen_001.get_term_dates.debug','get_context_data_for_term -> p_ld_cal_type/p_ld_sequence_number/lc_org_unit/lc_program_type/lc_program_cd/lc_version_num ->'
670: || '<>' || p_ld_cal_type || '<>' || p_ld_sequence_number || '<>' || lc_org_unit || '<>'
671: || lc_program_type || '<>' || lc_program_cd || '<>' || lc_version_num);
672: END IF;
673:

Line 692: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

688: lc_org_unit,
689: lc_program_cd || '/' || lc_version_num
690: );
691:
692: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
693: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_gen_001.get_term_dates.debug','prms to igs_ca_compute_da_val_pkg.cal_da_elt_val() -> FIRST_DAY_TERM<>'
694: || '<>' || p_ld_cal_type || '<>' || p_ld_sequence_number || '<>' || lc_org_unit || '<>' || lc_program_type || '<>'
695: || lc_program_cd || '/' || lc_version_num);
696: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_gen_001.get_term_dates.debug','ret val of igs_ca_compute_da_val_pkg.cal_da_elt_val() - p_ld_start_date -> '

Line 693: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_gen_001.get_term_dates.debug','prms to igs_ca_compute_da_val_pkg.cal_da_elt_val() -> FIRST_DAY_TERM<>'

689: lc_program_cd || '/' || lc_version_num
690: );
691:
692: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
693: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_gen_001.get_term_dates.debug','prms to igs_ca_compute_da_val_pkg.cal_da_elt_val() -> FIRST_DAY_TERM<>'
694: || '<>' || p_ld_cal_type || '<>' || p_ld_sequence_number || '<>' || lc_org_unit || '<>' || lc_program_type || '<>'
695: || lc_program_cd || '/' || lc_version_num);
696: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_gen_001.get_term_dates.debug','ret val of igs_ca_compute_da_val_pkg.cal_da_elt_val() - p_ld_start_date -> '
697: || TO_CHAR(p_ld_start_date));

Line 696: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_gen_001.get_term_dates.debug','ret val of igs_ca_compute_da_val_pkg.cal_da_elt_val() - p_ld_start_date -> '

692: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
693: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_gen_001.get_term_dates.debug','prms to igs_ca_compute_da_val_pkg.cal_da_elt_val() -> FIRST_DAY_TERM<>'
694: || '<>' || p_ld_cal_type || '<>' || p_ld_sequence_number || '<>' || lc_org_unit || '<>' || lc_program_type || '<>'
695: || lc_program_cd || '/' || lc_version_num);
696: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_gen_001.get_term_dates.debug','ret val of igs_ca_compute_da_val_pkg.cal_da_elt_val() - p_ld_start_date -> '
697: || TO_CHAR(p_ld_start_date));
698: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_gen_001.get_term_dates.debug','prms to igs_ca_compute_da_val_pkg.cal_da_elt_val() -> LAST_DAY_TERM<>'
699: || '<>' || p_ld_cal_type || '<>' || p_ld_sequence_number || '<>' || lc_org_unit || '<>' || lc_program_type || '<>'
700: || lc_program_cd || '/' || lc_version_num);

Line 698: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_gen_001.get_term_dates.debug','prms to igs_ca_compute_da_val_pkg.cal_da_elt_val() -> LAST_DAY_TERM<>'

694: || '<>' || p_ld_cal_type || '<>' || p_ld_sequence_number || '<>' || lc_org_unit || '<>' || lc_program_type || '<>'
695: || lc_program_cd || '/' || lc_version_num);
696: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_gen_001.get_term_dates.debug','ret val of igs_ca_compute_da_val_pkg.cal_da_elt_val() - p_ld_start_date -> '
697: || TO_CHAR(p_ld_start_date));
698: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_gen_001.get_term_dates.debug','prms to igs_ca_compute_da_val_pkg.cal_da_elt_val() -> LAST_DAY_TERM<>'
699: || '<>' || p_ld_cal_type || '<>' || p_ld_sequence_number || '<>' || lc_org_unit || '<>' || lc_program_type || '<>'
700: || lc_program_cd || '/' || lc_version_num);
701: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_gen_001.get_term_dates.debug','ret val of igs_ca_compute_da_val_pkg.cal_da_elt_val() - p_ld_end_date ->'
702: || TO_CHAR(p_ld_end_date));

Line 701: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_gen_001.get_term_dates.debug','ret val of igs_ca_compute_da_val_pkg.cal_da_elt_val() - p_ld_end_date ->'

697: || TO_CHAR(p_ld_start_date));
698: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_gen_001.get_term_dates.debug','prms to igs_ca_compute_da_val_pkg.cal_da_elt_val() -> LAST_DAY_TERM<>'
699: || '<>' || p_ld_cal_type || '<>' || p_ld_sequence_number || '<>' || lc_org_unit || '<>' || lc_program_type || '<>'
700: || lc_program_cd || '/' || lc_version_num);
701: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_gen_001.get_term_dates.debug','ret val of igs_ca_compute_da_val_pkg.cal_da_elt_val() - p_ld_end_date ->'
702: || TO_CHAR(p_ld_end_date));
703: END IF;
704:
705: END get_term_dates;