DBA Data[Home] [Help]

APPS.IGF_AW_COA_UPDATE dependencies on FND_FILE

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

333: IF l_rate_order.org_unit_cd IS NOT NULL AND p_base_details.org_unit_cd IS NULL THEN
334: fnd_message.set_name('IGF','IGF_AW_STD_ATTRIB');
335: fnd_message.set_token('ATTRIBUTE',igf_aw_gen.lookup_desc('IGF_AW_COA_GEN','ORG_UNIT_CD'));
336: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(p_ld_cal_type, p_ld_sequence_number));
337: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
338:
339: l_counter := 2;
340: END IF;
341:

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

342: IF l_rate_order.program_type IS NOT NULL AND p_base_details.program_type IS NULL THEN
343: fnd_message.set_name('IGF','IGF_AW_STD_ATTRIB');
344: fnd_message.set_token('ATTRIBUTE',igf_aw_gen.lookup_desc('IGF_AW_COA_GEN','PROGRAM_TYPE'));
345: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(p_ld_cal_type, p_ld_sequence_number));
346: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
347:
348: l_counter := 2;
349: END IF;
350:

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

351: IF l_rate_order.program_location_cd IS NOT NULL AND p_base_details.program_location_cd IS NULL THEN
352: fnd_message.set_name('IGF','IGF_AW_STD_ATTRIB');
353: fnd_message.set_token('ATTRIBUTE',igf_aw_gen.lookup_desc('IGF_AW_COA_GEN','PROGRAM_LOCATION_CD'));
354: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(p_ld_cal_type, p_ld_sequence_number));
355: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
356:
357: l_counter := 2;
358: END IF;
359:

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

360: IF l_rate_order.program_cd IS NOT NULL AND p_base_details.program_cd IS NULL THEN
361: fnd_message.set_name('IGF','IGF_AW_STD_ATTRIB');
362: fnd_message.set_token('ATTRIBUTE',igf_aw_gen.lookup_desc('IGF_AW_COA_GEN','PROGRAM_CD'));
363: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(p_ld_cal_type, p_ld_sequence_number));
364: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
365:
366: l_counter := 2;
367: END IF;
368:

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

369: IF l_rate_order.class_standing IS NOT NULL AND p_base_details.class_standing IS NULL THEN
370: fnd_message.set_name('IGF','IGF_AW_STD_ATTRIB');
371: fnd_message.set_token('ATTRIBUTE',igf_aw_gen.lookup_desc('IGF_AW_COA_GEN','CLASS_STANDING'));
372: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(p_ld_cal_type, p_ld_sequence_number));
373: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
374:
375: l_counter := 2;
376: END IF;
377:

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

378: IF l_rate_order.residency_status_code IS NOT NULL AND p_base_details.residency_status_code IS NULL THEN
379: fnd_message.set_name('IGF','IGF_AW_STD_ATTRIB');
380: fnd_message.set_token('ATTRIBUTE',igf_aw_gen.lookup_desc('IGF_AW_COA_GEN','RESIDENCY_STATUS_CODE'));
381: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(p_ld_cal_type, p_ld_sequence_number));
382: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
383:
384: l_counter := 2;
385: END IF;
386:

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

387: IF l_rate_order.housing_status_code IS NOT NULL AND p_base_details.housing_status_code IS NULL THEN
388: fnd_message.set_name('IGF','IGF_AW_STD_ATTRIB');
389: fnd_message.set_token('ATTRIBUTE',igf_aw_gen.lookup_desc('IGF_AW_COA_GEN','HOUSING_STATUS_CODE'));
390: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(p_ld_cal_type, p_ld_sequence_number));
391: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
392:
393: l_counter := 2;
394: END IF;
395:

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

396: IF l_rate_order.attendance_type IS NOT NULL AND p_base_details.attendance_type IS NULL THEN
397: fnd_message.set_name('IGF','IGF_AW_STD_ATTRIB');
398: fnd_message.set_token('ATTRIBUTE',igf_aw_gen.lookup_desc('IGF_AW_COA_GEN','ATTENDANCE_TYPE'));
399: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(p_ld_cal_type, p_ld_sequence_number));
400: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
401:
402: l_counter := 2;
403: END IF;
404:

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

405: IF l_rate_order.attendance_mode IS NOT NULL AND p_base_details.attendance_mode IS NULL THEN
406: fnd_message.set_name('IGF','IGF_AW_STD_ATTRIB');
407: fnd_message.set_token('ATTRIBUTE',igf_aw_gen.lookup_desc('IGF_AW_COA_GEN','ATTENDANCE_MODE'));
408: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(p_ld_cal_type, p_ld_sequence_number));
409: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
410:
411: l_counter := 2;
412: END IF;
413:

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

552: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.evaluate.debug','base_id:'||p_base_id||' is locked');
553: END IF;
554:
555: fnd_message.set_name('IGF','IGF_AW_STUD_SKIP');
556: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
557: ELSE
558: FOR l_items IN c_items(p_base_id)
559: LOOP
560: IF l_items.lock_flag = 'Y' THEN

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

564: END IF;
565:
566: fnd_message.set_name('IGF','IGF_AW_SKP_LK_ITM');
567: fnd_message.set_token('ITEM_CODE',l_items.item_code);
568: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
569:
570: ELSE
571: --cursor to check whether the COA item exists in the rate based setup table or not
572: OPEN c_rate_ord_exists(p_ci_cal_type, p_ci_sequence_number, l_items.item_code);

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

575: CLOSE c_rate_ord_exists;
576:
577: fnd_message.set_name('IGF','IGF_AW_SKIP_NON_RATE');
578: fnd_message.set_token('ITEM',l_items.item_code);
579: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
580:
581: ELSIF c_rate_ord_exists%FOUND THEN
582: CLOSE c_rate_ord_exists;
583:

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

590: END IF;
591:
592: fnd_message.set_name('IGF','IGF_AW_SKP_LK_TRM');
593: fnd_message.set_token('TERM_CODE',igf_gr_gen.get_alt_code(l_terms.ld_cal_type,l_terms.ld_sequence_number));
594: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
595: ELSE
596: --Execute the COA re-calculation logic
597: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
598: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.evaluate.debug','Fetching student attributes for base_id:'||p_base_id);

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

616: fnd_message.set_name('IGF','IGF_AW_UPD_ITM');
617: fnd_message.set_token('ITEM_CODE',l_items.item_code);
618: fnd_message.set_token('TERM_CODE',igf_gr_gen.get_alt_code(l_terms.ld_cal_type,l_terms.ld_sequence_number));
619: fnd_message.set_token('RATE_ORDER',ln_rate_order);
620: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
621:
622: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
623: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.evaluate.debug','ln_amount <> l_terms.amount for base_id:'||p_base_id);
624: END IF;

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

639: IF NVL(ln_rate_order,0) <> -1 THEN
640: fnd_message.set_name('IGF','IGF_AW_ITEM_SKIP');
641: fnd_message.set_token('ITEM_CODE',l_items.item_code);
642: fnd_message.set_token('TERM_CODE',igf_gr_gen.get_alt_code(l_terms.ld_cal_type,l_terms.ld_sequence_number));
643: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
644: END IF;
645:
646: RAISE E_SKIP_STUDENT;
647: END IF; -- End of IF is_attrib_matching()

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

687: EXCEPTION
688: WHEN E_SKIP_STUDENT THEN
689: ROLLBACK TO start_evaluate;
690: fnd_message.set_name('IGF','IGF_AW_RATE_NOT_AVAIL');
691: fnd_file.put_line(fnd_file.log,RPAD(' ',5)|| fnd_message.get());
692:
693: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
694: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_coa_update.evaluate.exception','sql error message:'||SQLERRM);
695: END IF;

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

872: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.main.debug','p_pid_group:'||p_pid_group);
873: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.main.debug','p_base_id:'||p_base_id);
874: END IF;
875:
876: fnd_file.new_line(fnd_file.log,1);
877:
878: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PARAMETER_PASS'));
879: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWARD_YEAR'),60) || igf_gr_gen.get_alt_code(lv_ci_cal_type,ln_ci_sequence_number));
880:

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

874: END IF;
875:
876: fnd_file.new_line(fnd_file.log,1);
877:
878: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PARAMETER_PASS'));
879: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWARD_YEAR'),60) || igf_gr_gen.get_alt_code(lv_ci_cal_type,ln_ci_sequence_number));
880:
881: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','RUN_TYPE'),60) ||p_run_type );
882:

Line 879: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWARD_YEAR'),60) || igf_gr_gen.get_alt_code(lv_ci_cal_type,ln_ci_sequence_number));

875:
876: fnd_file.new_line(fnd_file.log,1);
877:
878: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PARAMETER_PASS'));
879: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWARD_YEAR'),60) || igf_gr_gen.get_alt_code(lv_ci_cal_type,ln_ci_sequence_number));
880:
881: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','RUN_TYPE'),60) ||p_run_type );
882:
883: OPEN c_group_code(p_pid_group);

Line 881: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','RUN_TYPE'),60) ||p_run_type );

877:
878: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PARAMETER_PASS'));
879: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWARD_YEAR'),60) || igf_gr_gen.get_alt_code(lv_ci_cal_type,ln_ci_sequence_number));
880:
881: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','RUN_TYPE'),60) ||p_run_type );
882:
883: OPEN c_group_code(p_pid_group);
884: FETCH c_group_code INTO l_grp_cd;
885: CLOSE c_group_code;

Line 887: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_ID_GROUP'),60) || l_grp_cd.group_cd);

883: OPEN c_group_code(p_pid_group);
884: FETCH c_group_code INTO l_grp_cd;
885: CLOSE c_group_code;
886:
887: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_ID_GROUP'),60) || l_grp_cd.group_cd);
888: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_NUMBER'),60) || igf_gr_gen.get_per_num(p_base_id));
889:
890: fnd_file.new_line(fnd_file.log,2);
891:

Line 888: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_NUMBER'),60) || igf_gr_gen.get_per_num(p_base_id));

884: FETCH c_group_code INTO l_grp_cd;
885: CLOSE c_group_code;
886:
887: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_ID_GROUP'),60) || l_grp_cd.group_cd);
888: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_NUMBER'),60) || igf_gr_gen.get_per_num(p_base_id));
889:
890: fnd_file.new_line(fnd_file.log,2);
891:
892: IF (p_award_year IS NULL) OR (p_run_type IS NULL) THEN

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

886:
887: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_ID_GROUP'),60) || l_grp_cd.group_cd);
888: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_NUMBER'),60) || igf_gr_gen.get_per_num(p_base_id));
889:
890: fnd_file.new_line(fnd_file.log,2);
891:
892: IF (p_award_year IS NULL) OR (p_run_type IS NULL) THEN
893: RAISE param_exception;
894:

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

901: --If person selection is for all persons in the Person ID Group and
902: --Person ID Group is NULL then log error with exception
903: ELSIF p_run_type = 'P' AND p_pid_group IS NULL THEN
904: fnd_message.set_name('IGF','IGF_AW_COA_PARAM_EX_P');
905: fnd_file.put_line(fnd_file.log,fnd_message.get);
906: RAISE param_exception;
907:
908: --If person selection is for a single person and
909: --Base ID is NULL then log error with exception

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

908: --If person selection is for a single person and
909: --Base ID is NULL then log error with exception
910: ELSIF p_run_type = 'S' AND p_base_id IS NULL THEN
911: fnd_message.set_name('IGF','IGF_AW_COA_PARAM_EX_S');
912: fnd_file.put_line(fnd_file.log,fnd_message.get);
913: RAISE param_exception;
914:
915: END IF;
916:

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

914:
915: END IF;
916:
917:
918: fnd_file.put_line(fnd_file.log,'-------------------------------------------------------');
919:
920: --COMPUTATION ONLY IF PERSON NUMBER IS PRESENT
921: IF p_run_type = 'S' AND (p_pid_group IS NULL) AND (p_base_id IS NOT NULL) THEN
922:

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

919:
920: --COMPUTATION ONLY IF PERSON NUMBER IS PRESENT
921: IF p_run_type = 'S' AND (p_pid_group IS NULL) AND (p_base_id IS NOT NULL) THEN
922:
923: fnd_file.new_line(fnd_file.log,1);
924: fnd_message.set_name('IGF','IGF_AW_PROC_STUD');
925: fnd_message.set_token('STDNT',igf_gr_gen.get_per_num(p_base_id));
926: fnd_file.put_line(fnd_file.log,fnd_message.get);
927:

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

922:
923: fnd_file.new_line(fnd_file.log,1);
924: fnd_message.set_name('IGF','IGF_AW_PROC_STUD');
925: fnd_message.set_token('STDNT',igf_gr_gen.get_per_num(p_base_id));
926: fnd_file.put_line(fnd_file.log,fnd_message.get);
927:
928: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
929: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.main.debug','Starting Run_Type=S with base_id:'||p_base_id);
930: END IF;

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

942: --COMPUTATION FOR AWARD YEAR ONLY
943: ELSIF p_run_type = 'Y' AND (p_pid_group IS NULL) AND (p_base_id IS NULL) THEN
944: FOR l_per_awd_rec IN c_per_awd_yr(lv_ci_cal_type,ln_ci_sequence_number)
945: LOOP
946: fnd_file.new_line(fnd_file.log,1);
947: fnd_message.set_name('IGF','IGF_AW_PROC_STUD');
948: fnd_message.set_token('STDNT',igf_gr_gen.get_per_num(l_per_awd_rec.base_id));
949: fnd_file.put_line(fnd_file.log,fnd_message.get);
950:

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

945: LOOP
946: fnd_file.new_line(fnd_file.log,1);
947: fnd_message.set_name('IGF','IGF_AW_PROC_STUD');
948: fnd_message.set_token('STDNT',igf_gr_gen.get_per_num(l_per_awd_rec.base_id));
949: fnd_file.put_line(fnd_file.log,fnd_message.get);
950:
951: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
952: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.main.debug','Starting Run_Type=Y with base_id:'||l_per_awd_rec.base_id);
953: END IF;

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

987: FETCH cur_per_grp INTO per_grp_rec;
988:
989: IF (cur_per_grp%NOTFOUND) THEN
990: fnd_message.set_name('IGF','IGF_DB_NO_PER_GRP');
991: fnd_file.put_line(fnd_file.log,fnd_message.get);
992: ELSE
993: LOOP
994: -- check if person has a fa base record
995: ln_base_id := NULL;

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

1003: lv_err_msg
1004: );
1005:
1006: IF lv_err_msg = 'NULL' THEN
1007: fnd_file.new_line(fnd_file.log,1);
1008: fnd_message.set_name('IGF','IGF_AW_PROC_STUD');
1009: fnd_message.set_token('STDNT',igf_gr_gen.get_per_num(ln_base_id));
1010: fnd_file.put_line(fnd_file.log,fnd_message.get);
1011:

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

1006: IF lv_err_msg = 'NULL' THEN
1007: fnd_file.new_line(fnd_file.log,1);
1008: fnd_message.set_name('IGF','IGF_AW_PROC_STUD');
1009: fnd_message.set_token('STDNT',igf_gr_gen.get_per_num(ln_base_id));
1010: fnd_file.put_line(fnd_file.log,fnd_message.get);
1011:
1012: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1013: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.main.debug','Starting Run_Type=P with base_id:'||ln_base_id);
1014: END IF;

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

1029: CLOSE c_person_no;
1030:
1031: fnd_message.set_name('IGF','IGF_AP_NO_BASEREC');
1032: fnd_message.set_token('STUD',l_person_no.party_number);
1033: fnd_file.new_line(fnd_file.log,1);
1034: fnd_file.put_line(fnd_file.log,fnd_message.get);
1035: END IF;
1036:
1037: FETCH cur_per_grp INTO per_grp_rec;

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

1030:
1031: fnd_message.set_name('IGF','IGF_AP_NO_BASEREC');
1032: fnd_message.set_token('STUD',l_person_no.party_number);
1033: fnd_file.new_line(fnd_file.log,1);
1034: fnd_file.put_line(fnd_file.log,fnd_message.get);
1035: END IF;
1036:
1037: FETCH cur_per_grp INTO per_grp_rec;
1038: EXIT WHEN cur_per_grp%NOTFOUND;

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

1059: lv_err_msg
1060: );
1061:
1062: IF lv_err_msg = 'NULL' THEN
1063: fnd_file.new_line(fnd_file.log,1);
1064: fnd_message.set_name('IGF','IGF_AW_PROC_STUD');
1065: fnd_message.set_token('STDNT',igf_gr_gen.get_per_num(ln_base_id));
1066: fnd_file.put_line(fnd_file.log,fnd_message.get);
1067:

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

1062: IF lv_err_msg = 'NULL' THEN
1063: fnd_file.new_line(fnd_file.log,1);
1064: fnd_message.set_name('IGF','IGF_AW_PROC_STUD');
1065: fnd_message.set_token('STDNT',igf_gr_gen.get_per_num(ln_base_id));
1066: fnd_file.put_line(fnd_file.log,fnd_message.get);
1067:
1068: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1069: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.main.debug','Starting Run_Type=A with base_id:'||ln_base_id);
1070: END IF;

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

1126: CLOSE c_person_no;
1127:
1128: fnd_message.set_name('IGF','IGF_AP_NO_BASEREC');
1129: fnd_message.set_token('STUD',l_person_no.party_number);
1130: fnd_file.new_line(fnd_file.log,1);
1131: fnd_file.put_line(fnd_file.log,fnd_message.get);
1132: END IF;
1133:
1134: END LOOP;

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

1127:
1128: fnd_message.set_name('IGF','IGF_AP_NO_BASEREC');
1129: fnd_message.set_token('STUD',l_person_no.party_number);
1130: fnd_file.new_line(fnd_file.log,1);
1131: fnd_file.put_line(fnd_file.log,fnd_message.get);
1132: END IF;
1133:
1134: END LOOP;
1135:

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

1134: END LOOP;
1135:
1136: END IF;
1137:
1138: fnd_file.new_line(fnd_file.log,1);
1139: fnd_file.put_line(fnd_file.log,'-------------------------------------------------------');
1140:
1141:
1142: COMMIT;

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

1135:
1136: END IF;
1137:
1138: fnd_file.new_line(fnd_file.log,1);
1139: fnd_file.put_line(fnd_file.log,'-------------------------------------------------------');
1140:
1141:
1142: COMMIT;
1143: