eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGF_AP_TODO_GRPS_PRC_PKG dependencies on FND_LOG

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

529: ELSIF lc_item_details.system_todo_type_code IN ('OTHERS','INSTAPP') AND p_status IS NOT NULL THEN
530: l_status := p_status;
531: END IF;
532:
533: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
534: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.add_to_do.debug','l_status:'||l_status);
535: END IF;
536:
537: -- To check whether the SYSTEM_TODO_TYPE_CODE = 'PREFLEND' and if so check whether a active pref lender exists for the person

Line 534: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.add_to_do.debug','l_status:'||l_status);

530: l_status := p_status;
531: END IF;
532:
533: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
534: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.add_to_do.debug','l_status:'||l_status);
535: END IF;
536:
537: -- To check whether the SYSTEM_TODO_TYPE_CODE = 'PREFLEND' and if so check whether a active pref lender exists for the person
538: IF lc_item_details.system_todo_type_code = 'PREFLEND' THEN

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

549: CLOSE c_check_preflender;
550: END IF;
551:
552: -- Check whether the TO DO items was already added or not.
553: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
554: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.add_to_do.debug','opening c_to_do_item with base_id/item_seq_number:'||l_base_id||'/'||p_todo_number);
555: END IF;
556: OPEN c_to_do_item(cp_base_id => l_base_id,
557: cp_item_sequence_number => p_todo_number);

Line 554: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.add_to_do.debug','opening c_to_do_item with base_id/item_seq_number:'||l_base_id||'/'||p_todo_number);

550: END IF;
551:
552: -- Check whether the TO DO items was already added or not.
553: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
554: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.add_to_do.debug','opening c_to_do_item with base_id/item_seq_number:'||l_base_id||'/'||p_todo_number);
555: END IF;
556: OPEN c_to_do_item(cp_base_id => l_base_id,
557: cp_item_sequence_number => p_todo_number);
558: FETCH c_to_do_item INTO lc_to_do_item;

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

557: cp_item_sequence_number => p_todo_number);
558: FETCH c_to_do_item INTO lc_to_do_item;
559: IF c_to_do_item%FOUND THEN
560: lb_item_present := TRUE;
561: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
562: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.add_to_do.debug','p_todo_number:'||p_todo_number||' already present for base_id:'||p_base_id);
563: END IF;
564: ELSE
565: lb_item_present := FALSE;

Line 562: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.add_to_do.debug','p_todo_number:'||p_todo_number||' already present for base_id:'||p_base_id);

558: FETCH c_to_do_item INTO lc_to_do_item;
559: IF c_to_do_item%FOUND THEN
560: lb_item_present := TRUE;
561: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
562: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.add_to_do.debug','p_todo_number:'||p_todo_number||' already present for base_id:'||p_base_id);
563: END IF;
564: ELSE
565: lb_item_present := FALSE;
566: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

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

562: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.add_to_do.debug','p_todo_number:'||p_todo_number||' already present for base_id:'||p_base_id);
563: END IF;
564: ELSE
565: lb_item_present := FALSE;
566: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
567: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.add_to_do.debug','p_todo_number:'||p_todo_number||' not present for base_id:'||p_base_id);
568: END IF;
569: END IF;
570: CLOSE c_to_do_item;

Line 567: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.add_to_do.debug','p_todo_number:'||p_todo_number||' not present for base_id:'||p_base_id);

563: END IF;
564: ELSE
565: lb_item_present := FALSE;
566: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
567: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.add_to_do.debug','p_todo_number:'||p_todo_number||' not present for base_id:'||p_base_id);
568: END IF;
569: END IF;
570: CLOSE c_to_do_item;
571:

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

569: END IF;
570: CLOSE c_to_do_item;
571:
572: IF lb_item_present = TRUE THEN
573: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
574: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.add_to_do.debug','opening c_to_do_item for p_todo_number:'||p_todo_number||' and base_id:'||l_base_id);
575: END IF;
576: OPEN c_to_do_item(cp_base_id => l_base_id,
577: cp_item_sequence_number => p_todo_number);

Line 574: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.add_to_do.debug','opening c_to_do_item for p_todo_number:'||p_todo_number||' and base_id:'||l_base_id);

570: CLOSE c_to_do_item;
571:
572: IF lb_item_present = TRUE THEN
573: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
574: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.add_to_do.debug','opening c_to_do_item for p_todo_number:'||p_todo_number||' and base_id:'||l_base_id);
575: END IF;
576: OPEN c_to_do_item(cp_base_id => l_base_id,
577: cp_item_sequence_number => p_todo_number);
578: FETCH c_to_do_item INTO lc_to_do_item;

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

581: fnd_message.set_name('IGF','IGF_AP_INAC_TD_SKIP');
582: fnd_message.set_token('ITEMCODE',lc_item_details.description);
583: FND_FILE.PUT_LINE(FND_FILE.LOG ,FND_MESSAGE.GET);
584: ln_skip_items := ln_skip_items + 1;
585: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
586: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.add_to_do.debug','p_todo_number:'||p_todo_number||' skipped as it is inactive');
587: END IF;
588: RETURN;
589: END IF;

Line 586: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.add_to_do.debug','p_todo_number:'||p_todo_number||' skipped as it is inactive');

582: fnd_message.set_token('ITEMCODE',lc_item_details.description);
583: FND_FILE.PUT_LINE(FND_FILE.LOG ,FND_MESSAGE.GET);
584: ln_skip_items := ln_skip_items + 1;
585: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
586: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.add_to_do.debug','p_todo_number:'||p_todo_number||' skipped as it is inactive');
587: END IF;
588: RETURN;
589: END IF;
590: /*

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

592: If p_upd_mode = UPD, then update the item at all times
593: If p_upd_mode = NO_UPD_IF_COMP, then update is the status is NOT COM
594:
595: */
596: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
597: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.add_to_do.debug','p_upd_mode:'||p_todo_number||' and lc_to_do_item.status:'||lc_to_do_item.status);
598: END IF;
599: IF p_upd_mode = 'UPD' OR (p_upd_mode = 'NO_UPD_IF_COMP' AND lc_to_do_item.status <> 'COM') THEN
600: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 597: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.add_to_do.debug','p_upd_mode:'||p_todo_number||' and lc_to_do_item.status:'||lc_to_do_item.status);

593: If p_upd_mode = NO_UPD_IF_COMP, then update is the status is NOT COM
594:
595: */
596: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
597: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.add_to_do.debug','p_upd_mode:'||p_todo_number||' and lc_to_do_item.status:'||lc_to_do_item.status);
598: END IF;
599: IF p_upd_mode = 'UPD' OR (p_upd_mode = 'NO_UPD_IF_COMP' AND lc_to_do_item.status <> 'COM') THEN
600: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
601: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.add_to_do.debug','calling igf_ap_td_item_inst_pkg.update_row with base_id/item_seq_number:'||lc_to_do_item.base_id||'/'||lc_to_do_item.item_sequence_number);

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

596: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
597: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.add_to_do.debug','p_upd_mode:'||p_todo_number||' and lc_to_do_item.status:'||lc_to_do_item.status);
598: END IF;
599: IF p_upd_mode = 'UPD' OR (p_upd_mode = 'NO_UPD_IF_COMP' AND lc_to_do_item.status <> 'COM') THEN
600: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
601: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.add_to_do.debug','calling igf_ap_td_item_inst_pkg.update_row with base_id/item_seq_number:'||lc_to_do_item.base_id||'/'||lc_to_do_item.item_sequence_number);
602: END IF;
603: igf_ap_td_item_inst_pkg.update_row (
604: x_mode => 'R',

Line 601: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.add_to_do.debug','calling igf_ap_td_item_inst_pkg.update_row with base_id/item_seq_number:'||lc_to_do_item.base_id||'/'||lc_to_do_item.item_sequence_number);

597: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.add_to_do.debug','p_upd_mode:'||p_todo_number||' and lc_to_do_item.status:'||lc_to_do_item.status);
598: END IF;
599: IF p_upd_mode = 'UPD' OR (p_upd_mode = 'NO_UPD_IF_COMP' AND lc_to_do_item.status <> 'COM') THEN
600: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
601: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.add_to_do.debug','calling igf_ap_td_item_inst_pkg.update_row with base_id/item_seq_number:'||lc_to_do_item.base_id||'/'||lc_to_do_item.item_sequence_number);
602: END IF;
603: igf_ap_td_item_inst_pkg.update_row (
604: x_mode => 'R',
605: x_rowid => lc_to_do_item.row_id,

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

624: fnd_message.set_token('STATUS',igf_aw_gen.lookup_desc('IGF_TD_ITEM_STATUS',l_status));
625: FND_FILE.PUT_LINE(FND_FILE.LOG ,FND_MESSAGE.GET);
626: END IF;
627: ELSIF lb_item_present = FALSE THEN
628: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
629: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.add_to_do.debug','calling igf_ap_td_item_inst_pkg.insert_row with base_id/item_seq_number:'||l_base_id||'/'||p_todo_number);
630: END IF;
631: igf_ap_td_item_inst_pkg.insert_row (
632: x_mode => 'R',

Line 629: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.add_to_do.debug','calling igf_ap_td_item_inst_pkg.insert_row with base_id/item_seq_number:'||l_base_id||'/'||p_todo_number);

625: FND_FILE.PUT_LINE(FND_FILE.LOG ,FND_MESSAGE.GET);
626: END IF;
627: ELSIF lb_item_present = FALSE THEN
628: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
629: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.add_to_do.debug','calling igf_ap_td_item_inst_pkg.insert_row with base_id/item_seq_number:'||l_base_id||'/'||p_todo_number);
630: END IF;
631: igf_ap_td_item_inst_pkg.insert_row (
632: x_mode => 'R',
633: x_rowid => lv_rowid,

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

841: l_has_isir := 'N';
842: END IF;
843: CLOSE c_has_isir;
844:
845: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
846: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','l_has_isir:'||l_has_isir);
847: END IF;
848:
849: OPEN c_has_profile(p_base_id);

Line 846: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','l_has_isir:'||l_has_isir);

842: END IF;
843: CLOSE c_has_isir;
844:
845: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
846: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','l_has_isir:'||l_has_isir);
847: END IF;
848:
849: OPEN c_has_profile(p_base_id);
850: FETCH c_has_profile INTO lc_has_profile;

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

862: l_has_profile := 'N';
863: END IF;
864: CLOSE c_has_profile;
865:
866: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
867: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','l_has_profile:'||l_has_profile);
868: END IF;
869:
870: -- Process for each To Do Items, if items are not null

Line 867: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','l_has_profile:'||l_has_profile);

863: END IF;
864: CLOSE c_has_profile;
865:
866: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
867: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','l_has_profile:'||l_has_profile);
868: END IF;
869:
870: -- Process for each To Do Items, if items are not null
871: IF p_item_number_1 IS NOT NULL THEN

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

869:
870: -- Process for each To Do Items, if items are not null
871: IF p_item_number_1 IS NOT NULL THEN
872: ln_item_cnt := ln_item_cnt + 1;
873: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
874: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','ln_item_cnt:'||ln_item_cnt);
875: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','calling add_to_do with base_id/p_item_number_1/status/p_upd_mode:'||p_base_id||'/'||p_item_number_1||'/'||p_status_1||'/'||p_upd_mode);
876: END IF;
877: add_to_do( p_base_id, p_item_number_1, ln_item_cnt, p_person_id, p_status_1,p_upd_mode);

Line 874: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','ln_item_cnt:'||ln_item_cnt);

870: -- Process for each To Do Items, if items are not null
871: IF p_item_number_1 IS NOT NULL THEN
872: ln_item_cnt := ln_item_cnt + 1;
873: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
874: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','ln_item_cnt:'||ln_item_cnt);
875: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','calling add_to_do with base_id/p_item_number_1/status/p_upd_mode:'||p_base_id||'/'||p_item_number_1||'/'||p_status_1||'/'||p_upd_mode);
876: END IF;
877: add_to_do( p_base_id, p_item_number_1, ln_item_cnt, p_person_id, p_status_1,p_upd_mode);
878: END IF;

Line 875: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','calling add_to_do with base_id/p_item_number_1/status/p_upd_mode:'||p_base_id||'/'||p_item_number_1||'/'||p_status_1||'/'||p_upd_mode);

871: IF p_item_number_1 IS NOT NULL THEN
872: ln_item_cnt := ln_item_cnt + 1;
873: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
874: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','ln_item_cnt:'||ln_item_cnt);
875: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','calling add_to_do with base_id/p_item_number_1/status/p_upd_mode:'||p_base_id||'/'||p_item_number_1||'/'||p_status_1||'/'||p_upd_mode);
876: END IF;
877: add_to_do( p_base_id, p_item_number_1, ln_item_cnt, p_person_id, p_status_1,p_upd_mode);
878: END IF;
879:

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

878: END IF;
879:
880: IF p_item_number_2 IS NOT NULL THEN
881: ln_item_cnt := ln_item_cnt + 1;
882: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
883: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','ln_item_cnt:'||ln_item_cnt);
884: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','calling add_to_do with base_id/p_item_number/status/p_upd_mode:'||p_base_id||'/'||p_item_number_2||'/'||p_status_1||'/'||p_upd_mode);
885: END IF;
886: add_to_do( p_base_id, p_item_number_2, ln_item_cnt, p_person_id, p_status_2,p_upd_mode);

Line 883: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','ln_item_cnt:'||ln_item_cnt);

879:
880: IF p_item_number_2 IS NOT NULL THEN
881: ln_item_cnt := ln_item_cnt + 1;
882: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
883: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','ln_item_cnt:'||ln_item_cnt);
884: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','calling add_to_do with base_id/p_item_number/status/p_upd_mode:'||p_base_id||'/'||p_item_number_2||'/'||p_status_1||'/'||p_upd_mode);
885: END IF;
886: add_to_do( p_base_id, p_item_number_2, ln_item_cnt, p_person_id, p_status_2,p_upd_mode);
887: END IF;

Line 884: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','calling add_to_do with base_id/p_item_number/status/p_upd_mode:'||p_base_id||'/'||p_item_number_2||'/'||p_status_1||'/'||p_upd_mode);

880: IF p_item_number_2 IS NOT NULL THEN
881: ln_item_cnt := ln_item_cnt + 1;
882: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
883: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','ln_item_cnt:'||ln_item_cnt);
884: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','calling add_to_do with base_id/p_item_number/status/p_upd_mode:'||p_base_id||'/'||p_item_number_2||'/'||p_status_1||'/'||p_upd_mode);
885: END IF;
886: add_to_do( p_base_id, p_item_number_2, ln_item_cnt, p_person_id, p_status_2,p_upd_mode);
887: END IF;
888:

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

887: END IF;
888:
889: IF p_item_number_3 IS NOT NULL THEN
890: ln_item_cnt := ln_item_cnt + 1;
891: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
892: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','ln_item_cnt:'||ln_item_cnt);
893: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','calling add_to_do with base_id/p_item_number/status/p_upd_mode:'||p_base_id||'/'||p_item_number_3||'/'||p_status_1||'/'||p_upd_mode);
894: END IF;
895: add_to_do( p_base_id, p_item_number_3, ln_item_cnt, p_person_id, p_status_3,p_upd_mode);

Line 892: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','ln_item_cnt:'||ln_item_cnt);

888:
889: IF p_item_number_3 IS NOT NULL THEN
890: ln_item_cnt := ln_item_cnt + 1;
891: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
892: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','ln_item_cnt:'||ln_item_cnt);
893: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','calling add_to_do with base_id/p_item_number/status/p_upd_mode:'||p_base_id||'/'||p_item_number_3||'/'||p_status_1||'/'||p_upd_mode);
894: END IF;
895: add_to_do( p_base_id, p_item_number_3, ln_item_cnt, p_person_id, p_status_3,p_upd_mode);
896: END IF;

Line 893: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','calling add_to_do with base_id/p_item_number/status/p_upd_mode:'||p_base_id||'/'||p_item_number_3||'/'||p_status_1||'/'||p_upd_mode);

889: IF p_item_number_3 IS NOT NULL THEN
890: ln_item_cnt := ln_item_cnt + 1;
891: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
892: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','ln_item_cnt:'||ln_item_cnt);
893: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','calling add_to_do with base_id/p_item_number/status/p_upd_mode:'||p_base_id||'/'||p_item_number_3||'/'||p_status_1||'/'||p_upd_mode);
894: END IF;
895: add_to_do( p_base_id, p_item_number_3, ln_item_cnt, p_person_id, p_status_3,p_upd_mode);
896: END IF;
897:

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

896: END IF;
897:
898: IF p_item_number_4 IS NOT NULL THEN
899: ln_item_cnt := ln_item_cnt + 1;
900: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
901: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','ln_item_cnt:'||ln_item_cnt);
902: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','calling add_to_do with base_id/p_item_number/status/p_upd_mode:'||p_base_id||'/'||p_item_number_4||'/'||p_status_1||'/'||p_upd_mode);
903: END IF;
904: add_to_do( p_base_id, p_item_number_4, ln_item_cnt, p_person_id, p_status_4,p_upd_mode);

Line 901: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','ln_item_cnt:'||ln_item_cnt);

897:
898: IF p_item_number_4 IS NOT NULL THEN
899: ln_item_cnt := ln_item_cnt + 1;
900: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
901: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','ln_item_cnt:'||ln_item_cnt);
902: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','calling add_to_do with base_id/p_item_number/status/p_upd_mode:'||p_base_id||'/'||p_item_number_4||'/'||p_status_1||'/'||p_upd_mode);
903: END IF;
904: add_to_do( p_base_id, p_item_number_4, ln_item_cnt, p_person_id, p_status_4,p_upd_mode);
905: END IF;

Line 902: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','calling add_to_do with base_id/p_item_number/status/p_upd_mode:'||p_base_id||'/'||p_item_number_4||'/'||p_status_1||'/'||p_upd_mode);

898: IF p_item_number_4 IS NOT NULL THEN
899: ln_item_cnt := ln_item_cnt + 1;
900: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
901: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','ln_item_cnt:'||ln_item_cnt);
902: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','calling add_to_do with base_id/p_item_number/status/p_upd_mode:'||p_base_id||'/'||p_item_number_4||'/'||p_status_1||'/'||p_upd_mode);
903: END IF;
904: add_to_do( p_base_id, p_item_number_4, ln_item_cnt, p_person_id, p_status_4,p_upd_mode);
905: END IF;
906:

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

905: END IF;
906:
907: IF p_item_number_5 IS NOT NULL THEN
908: ln_item_cnt := ln_item_cnt + 1;
909: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
910: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','ln_item_cnt:'||ln_item_cnt);
911: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','calling add_to_do with base_id/p_item_number/status/p_upd_mode:'||p_base_id||'/'||p_item_number_5||'/'||p_status_1||'/'||p_upd_mode);
912: END IF;
913: add_to_do( p_base_id, p_item_number_5, ln_item_cnt, p_person_id, p_status_5,p_upd_mode);

Line 910: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','ln_item_cnt:'||ln_item_cnt);

906:
907: IF p_item_number_5 IS NOT NULL THEN
908: ln_item_cnt := ln_item_cnt + 1;
909: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
910: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','ln_item_cnt:'||ln_item_cnt);
911: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','calling add_to_do with base_id/p_item_number/status/p_upd_mode:'||p_base_id||'/'||p_item_number_5||'/'||p_status_1||'/'||p_upd_mode);
912: END IF;
913: add_to_do( p_base_id, p_item_number_5, ln_item_cnt, p_person_id, p_status_5,p_upd_mode);
914: END IF;

Line 911: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','calling add_to_do with base_id/p_item_number/status/p_upd_mode:'||p_base_id||'/'||p_item_number_5||'/'||p_status_1||'/'||p_upd_mode);

907: IF p_item_number_5 IS NOT NULL THEN
908: ln_item_cnt := ln_item_cnt + 1;
909: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
910: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','ln_item_cnt:'||ln_item_cnt);
911: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','calling add_to_do with base_id/p_item_number/status/p_upd_mode:'||p_base_id||'/'||p_item_number_5||'/'||p_status_1||'/'||p_upd_mode);
912: END IF;
913: add_to_do( p_base_id, p_item_number_5, ln_item_cnt, p_person_id, p_status_5,p_upd_mode);
914: END IF;
915:

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

914: END IF;
915:
916: IF p_item_number_6 IS NOT NULL THEN
917: ln_item_cnt := ln_item_cnt + 1;
918: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
919: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','ln_item_cnt:'||ln_item_cnt);
920: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','calling add_to_do with base_id/p_item_number/status/p_upd_mode:'||p_base_id||'/'||p_item_number_6||'/'||p_status_1||'/'||p_upd_mode);
921: END IF;
922: add_to_do( p_base_id, p_item_number_6, ln_item_cnt, p_person_id, p_status_6,p_upd_mode);

Line 919: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','ln_item_cnt:'||ln_item_cnt);

915:
916: IF p_item_number_6 IS NOT NULL THEN
917: ln_item_cnt := ln_item_cnt + 1;
918: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
919: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','ln_item_cnt:'||ln_item_cnt);
920: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','calling add_to_do with base_id/p_item_number/status/p_upd_mode:'||p_base_id||'/'||p_item_number_6||'/'||p_status_1||'/'||p_upd_mode);
921: END IF;
922: add_to_do( p_base_id, p_item_number_6, ln_item_cnt, p_person_id, p_status_6,p_upd_mode);
923: END IF;

Line 920: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','calling add_to_do with base_id/p_item_number/status/p_upd_mode:'||p_base_id||'/'||p_item_number_6||'/'||p_status_1||'/'||p_upd_mode);

916: IF p_item_number_6 IS NOT NULL THEN
917: ln_item_cnt := ln_item_cnt + 1;
918: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
919: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','ln_item_cnt:'||ln_item_cnt);
920: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','calling add_to_do with base_id/p_item_number/status/p_upd_mode:'||p_base_id||'/'||p_item_number_6||'/'||p_status_1||'/'||p_upd_mode);
921: END IF;
922: add_to_do( p_base_id, p_item_number_6, ln_item_cnt, p_person_id, p_status_6,p_upd_mode);
923: END IF;
924:

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

923: END IF;
924:
925: IF p_item_number_7 IS NOT NULL THEN
926: ln_item_cnt := ln_item_cnt + 1;
927: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
928: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','ln_item_cnt:'||ln_item_cnt);
929: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','calling add_to_do with base_id/p_item_number/status/p_upd_mode:'||p_base_id||'/'||p_item_number_7||'/'||p_status_1||'/'||p_upd_mode);
930: END IF;
931: add_to_do( p_base_id, p_item_number_7, ln_item_cnt, p_person_id, p_status_7,p_upd_mode);

Line 928: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','ln_item_cnt:'||ln_item_cnt);

924:
925: IF p_item_number_7 IS NOT NULL THEN
926: ln_item_cnt := ln_item_cnt + 1;
927: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
928: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','ln_item_cnt:'||ln_item_cnt);
929: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','calling add_to_do with base_id/p_item_number/status/p_upd_mode:'||p_base_id||'/'||p_item_number_7||'/'||p_status_1||'/'||p_upd_mode);
930: END IF;
931: add_to_do( p_base_id, p_item_number_7, ln_item_cnt, p_person_id, p_status_7,p_upd_mode);
932: END IF;

Line 929: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','calling add_to_do with base_id/p_item_number/status/p_upd_mode:'||p_base_id||'/'||p_item_number_7||'/'||p_status_1||'/'||p_upd_mode);

925: IF p_item_number_7 IS NOT NULL THEN
926: ln_item_cnt := ln_item_cnt + 1;
927: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
928: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','ln_item_cnt:'||ln_item_cnt);
929: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','calling add_to_do with base_id/p_item_number/status/p_upd_mode:'||p_base_id||'/'||p_item_number_7||'/'||p_status_1||'/'||p_upd_mode);
930: END IF;
931: add_to_do( p_base_id, p_item_number_7, ln_item_cnt, p_person_id, p_status_7,p_upd_mode);
932: END IF;
933:

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

932: END IF;
933:
934: IF p_item_number_8 IS NOT NULL THEN
935: ln_item_cnt := ln_item_cnt + 1;
936: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
937: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','ln_item_cnt:'||ln_item_cnt);
938: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','calling add_to_do with base_id/p_item_number/status/p_upd_mode:'||p_base_id||'/'||p_item_number_8||'/'||p_status_1||'/'||p_upd_mode);
939: END IF;
940: add_to_do( p_base_id, p_item_number_8, ln_item_cnt, p_person_id, p_status_8,p_upd_mode);

Line 937: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','ln_item_cnt:'||ln_item_cnt);

933:
934: IF p_item_number_8 IS NOT NULL THEN
935: ln_item_cnt := ln_item_cnt + 1;
936: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
937: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','ln_item_cnt:'||ln_item_cnt);
938: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','calling add_to_do with base_id/p_item_number/status/p_upd_mode:'||p_base_id||'/'||p_item_number_8||'/'||p_status_1||'/'||p_upd_mode);
939: END IF;
940: add_to_do( p_base_id, p_item_number_8, ln_item_cnt, p_person_id, p_status_8,p_upd_mode);
941: END IF;

Line 938: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','calling add_to_do with base_id/p_item_number/status/p_upd_mode:'||p_base_id||'/'||p_item_number_8||'/'||p_status_1||'/'||p_upd_mode);

934: IF p_item_number_8 IS NOT NULL THEN
935: ln_item_cnt := ln_item_cnt + 1;
936: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
937: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','ln_item_cnt:'||ln_item_cnt);
938: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','calling add_to_do with base_id/p_item_number/status/p_upd_mode:'||p_base_id||'/'||p_item_number_8||'/'||p_status_1||'/'||p_upd_mode);
939: END IF;
940: add_to_do( p_base_id, p_item_number_8, ln_item_cnt, p_person_id, p_status_8,p_upd_mode);
941: END IF;
942:

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

941: END IF;
942:
943: IF p_item_number_9 IS NOT NULL THEN
944: ln_item_cnt := ln_item_cnt + 1;
945: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
946: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','ln_item_cnt:'||ln_item_cnt);
947: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','calling add_to_do with base_id/p_item_number/status/p_upd_mode:'||p_base_id||'/'||p_item_number_9||'/'||p_status_1||'/'||p_upd_mode);
948: END IF;
949: add_to_do( p_base_id, p_item_number_9, ln_item_cnt, p_person_id, p_status_9,p_upd_mode);

Line 946: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','ln_item_cnt:'||ln_item_cnt);

942:
943: IF p_item_number_9 IS NOT NULL THEN
944: ln_item_cnt := ln_item_cnt + 1;
945: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
946: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','ln_item_cnt:'||ln_item_cnt);
947: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','calling add_to_do with base_id/p_item_number/status/p_upd_mode:'||p_base_id||'/'||p_item_number_9||'/'||p_status_1||'/'||p_upd_mode);
948: END IF;
949: add_to_do( p_base_id, p_item_number_9, ln_item_cnt, p_person_id, p_status_9,p_upd_mode);
950: END IF;

Line 947: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','calling add_to_do with base_id/p_item_number/status/p_upd_mode:'||p_base_id||'/'||p_item_number_9||'/'||p_status_1||'/'||p_upd_mode);

943: IF p_item_number_9 IS NOT NULL THEN
944: ln_item_cnt := ln_item_cnt + 1;
945: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
946: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','ln_item_cnt:'||ln_item_cnt);
947: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','calling add_to_do with base_id/p_item_number/status/p_upd_mode:'||p_base_id||'/'||p_item_number_9||'/'||p_status_1||'/'||p_upd_mode);
948: END IF;
949: add_to_do( p_base_id, p_item_number_9, ln_item_cnt, p_person_id, p_status_9,p_upd_mode);
950: END IF;
951:

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

950: END IF;
951:
952: IF p_item_number_10 IS NOT NULL THEN
953: ln_item_cnt := ln_item_cnt + 1;
954: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
955: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','ln_item_cnt:'||ln_item_cnt);
956: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','calling add_to_do with base_id/p_item_number/status/p_upd_mode:'||p_base_id||'/'||p_item_number_10||'/'||p_status_1||'/'||p_upd_mode);
957: END IF;
958: add_to_do( p_base_id, p_item_number_10, ln_item_cnt, p_person_id, p_status_10,p_upd_mode);

Line 955: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','ln_item_cnt:'||ln_item_cnt);

951:
952: IF p_item_number_10 IS NOT NULL THEN
953: ln_item_cnt := ln_item_cnt + 1;
954: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
955: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','ln_item_cnt:'||ln_item_cnt);
956: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','calling add_to_do with base_id/p_item_number/status/p_upd_mode:'||p_base_id||'/'||p_item_number_10||'/'||p_status_1||'/'||p_upd_mode);
957: END IF;
958: add_to_do( p_base_id, p_item_number_10, ln_item_cnt, p_person_id, p_status_10,p_upd_mode);
959: END IF;

Line 956: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','calling add_to_do with base_id/p_item_number/status/p_upd_mode:'||p_base_id||'/'||p_item_number_10||'/'||p_status_1||'/'||p_upd_mode);

952: IF p_item_number_10 IS NOT NULL THEN
953: ln_item_cnt := ln_item_cnt + 1;
954: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
955: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','ln_item_cnt:'||ln_item_cnt);
956: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','calling add_to_do with base_id/p_item_number/status/p_upd_mode:'||p_base_id||'/'||p_item_number_10||'/'||p_status_1||'/'||p_upd_mode);
957: END IF;
958: add_to_do( p_base_id, p_item_number_10, ln_item_cnt, p_person_id, p_status_10,p_upd_mode);
959: END IF;
960:

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

959: END IF;
960:
961: IF p_item_number_11 IS NOT NULL THEN
962: ln_item_cnt := ln_item_cnt + 1;
963: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
964: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','ln_item_cnt:'||ln_item_cnt);
965: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','calling add_to_do with base_id/p_item_number/status/p_upd_mode:'||p_base_id||'/'||p_item_number_11||'/'||p_status_1||'/'||p_upd_mode);
966: END IF;
967: add_to_do( p_base_id, p_item_number_11, ln_item_cnt, p_person_id, p_status_11,p_upd_mode);

Line 964: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','ln_item_cnt:'||ln_item_cnt);

960:
961: IF p_item_number_11 IS NOT NULL THEN
962: ln_item_cnt := ln_item_cnt + 1;
963: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
964: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','ln_item_cnt:'||ln_item_cnt);
965: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','calling add_to_do with base_id/p_item_number/status/p_upd_mode:'||p_base_id||'/'||p_item_number_11||'/'||p_status_1||'/'||p_upd_mode);
966: END IF;
967: add_to_do( p_base_id, p_item_number_11, ln_item_cnt, p_person_id, p_status_11,p_upd_mode);
968: END IF;

Line 965: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','calling add_to_do with base_id/p_item_number/status/p_upd_mode:'||p_base_id||'/'||p_item_number_11||'/'||p_status_1||'/'||p_upd_mode);

961: IF p_item_number_11 IS NOT NULL THEN
962: ln_item_cnt := ln_item_cnt + 1;
963: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
964: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','ln_item_cnt:'||ln_item_cnt);
965: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','calling add_to_do with base_id/p_item_number/status/p_upd_mode:'||p_base_id||'/'||p_item_number_11||'/'||p_status_1||'/'||p_upd_mode);
966: END IF;
967: add_to_do( p_base_id, p_item_number_11, ln_item_cnt, p_person_id, p_status_11,p_upd_mode);
968: END IF;
969:

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

968: END IF;
969:
970: IF p_item_number_12 IS NOT NULL THEN
971: ln_item_cnt := ln_item_cnt + 1;
972: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
973: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','ln_item_cnt:'||ln_item_cnt);
974: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','calling add_to_do with base_id/p_item_number/status/p_upd_mode:'||p_base_id||'/'||p_item_number_12||'/'||p_status_1||'/'||p_upd_mode);
975: END IF;
976: add_to_do( p_base_id, p_item_number_12, ln_item_cnt, p_person_id, p_status_12,p_upd_mode);

Line 973: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','ln_item_cnt:'||ln_item_cnt);

969:
970: IF p_item_number_12 IS NOT NULL THEN
971: ln_item_cnt := ln_item_cnt + 1;
972: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
973: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','ln_item_cnt:'||ln_item_cnt);
974: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','calling add_to_do with base_id/p_item_number/status/p_upd_mode:'||p_base_id||'/'||p_item_number_12||'/'||p_status_1||'/'||p_upd_mode);
975: END IF;
976: add_to_do( p_base_id, p_item_number_12, ln_item_cnt, p_person_id, p_status_12,p_upd_mode);
977: END IF;

Line 974: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','calling add_to_do with base_id/p_item_number/status/p_upd_mode:'||p_base_id||'/'||p_item_number_12||'/'||p_status_1||'/'||p_upd_mode);

970: IF p_item_number_12 IS NOT NULL THEN
971: ln_item_cnt := ln_item_cnt + 1;
972: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
973: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','ln_item_cnt:'||ln_item_cnt);
974: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','calling add_to_do with base_id/p_item_number/status/p_upd_mode:'||p_base_id||'/'||p_item_number_12||'/'||p_status_1||'/'||p_upd_mode);
975: END IF;
976: add_to_do( p_base_id, p_item_number_12, ln_item_cnt, p_person_id, p_status_12,p_upd_mode);
977: END IF;
978:

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

977: END IF;
978:
979: IF p_item_number_13 IS NOT NULL THEN
980: ln_item_cnt := ln_item_cnt + 1;
981: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
982: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','ln_item_cnt:'||ln_item_cnt);
983: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','calling add_to_do with base_id/p_item_number/status/p_upd_mode:'||p_base_id||'/'||p_item_number_13||'/'||p_status_1||'/'||p_upd_mode);
984: END IF;
985: add_to_do( p_base_id, p_item_number_13, ln_item_cnt, p_person_id, p_status_13,p_upd_mode);

Line 982: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','ln_item_cnt:'||ln_item_cnt);

978:
979: IF p_item_number_13 IS NOT NULL THEN
980: ln_item_cnt := ln_item_cnt + 1;
981: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
982: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','ln_item_cnt:'||ln_item_cnt);
983: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','calling add_to_do with base_id/p_item_number/status/p_upd_mode:'||p_base_id||'/'||p_item_number_13||'/'||p_status_1||'/'||p_upd_mode);
984: END IF;
985: add_to_do( p_base_id, p_item_number_13, ln_item_cnt, p_person_id, p_status_13,p_upd_mode);
986: END IF;

Line 983: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','calling add_to_do with base_id/p_item_number/status/p_upd_mode:'||p_base_id||'/'||p_item_number_13||'/'||p_status_1||'/'||p_upd_mode);

979: IF p_item_number_13 IS NOT NULL THEN
980: ln_item_cnt := ln_item_cnt + 1;
981: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
982: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','ln_item_cnt:'||ln_item_cnt);
983: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','calling add_to_do with base_id/p_item_number/status/p_upd_mode:'||p_base_id||'/'||p_item_number_13||'/'||p_status_1||'/'||p_upd_mode);
984: END IF;
985: add_to_do( p_base_id, p_item_number_13, ln_item_cnt, p_person_id, p_status_13,p_upd_mode);
986: END IF;
987:

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

986: END IF;
987:
988: IF p_item_number_14 IS NOT NULL THEN
989: ln_item_cnt := ln_item_cnt + 1;
990: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
991: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','ln_item_cnt:'||ln_item_cnt);
992: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','calling add_to_do with base_id/p_item_number/status/p_upd_mode:'||p_base_id||'/'||p_item_number_14||'/'||p_status_1||'/'||p_upd_mode);
993: END IF;
994: add_to_do( p_base_id, p_item_number_14, ln_item_cnt, p_person_id, p_status_14,p_upd_mode);

Line 991: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','ln_item_cnt:'||ln_item_cnt);

987:
988: IF p_item_number_14 IS NOT NULL THEN
989: ln_item_cnt := ln_item_cnt + 1;
990: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
991: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','ln_item_cnt:'||ln_item_cnt);
992: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','calling add_to_do with base_id/p_item_number/status/p_upd_mode:'||p_base_id||'/'||p_item_number_14||'/'||p_status_1||'/'||p_upd_mode);
993: END IF;
994: add_to_do( p_base_id, p_item_number_14, ln_item_cnt, p_person_id, p_status_14,p_upd_mode);
995: END IF;

Line 992: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','calling add_to_do with base_id/p_item_number/status/p_upd_mode:'||p_base_id||'/'||p_item_number_14||'/'||p_status_1||'/'||p_upd_mode);

988: IF p_item_number_14 IS NOT NULL THEN
989: ln_item_cnt := ln_item_cnt + 1;
990: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
991: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','ln_item_cnt:'||ln_item_cnt);
992: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','calling add_to_do with base_id/p_item_number/status/p_upd_mode:'||p_base_id||'/'||p_item_number_14||'/'||p_status_1||'/'||p_upd_mode);
993: END IF;
994: add_to_do( p_base_id, p_item_number_14, ln_item_cnt, p_person_id, p_status_14,p_upd_mode);
995: END IF;
996:

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

995: END IF;
996:
997: IF p_item_number_15 IS NOT NULL THEN
998: ln_item_cnt := ln_item_cnt + 1;
999: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1000: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','ln_item_cnt:'||ln_item_cnt);
1001: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','calling add_to_do with base_id/p_item_number/status/p_upd_mode:'||p_base_id||'/'||p_item_number_15||'/'||p_status_1||'/'||p_upd_mode);
1002: END IF;
1003: add_to_do( p_base_id, p_item_number_15, ln_item_cnt, p_person_id, p_status_15,p_upd_mode);

Line 1000: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','ln_item_cnt:'||ln_item_cnt);

996:
997: IF p_item_number_15 IS NOT NULL THEN
998: ln_item_cnt := ln_item_cnt + 1;
999: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1000: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','ln_item_cnt:'||ln_item_cnt);
1001: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','calling add_to_do with base_id/p_item_number/status/p_upd_mode:'||p_base_id||'/'||p_item_number_15||'/'||p_status_1||'/'||p_upd_mode);
1002: END IF;
1003: add_to_do( p_base_id, p_item_number_15, ln_item_cnt, p_person_id, p_status_15,p_upd_mode);
1004: END IF;

Line 1001: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','calling add_to_do with base_id/p_item_number/status/p_upd_mode:'||p_base_id||'/'||p_item_number_15||'/'||p_status_1||'/'||p_upd_mode);

997: IF p_item_number_15 IS NOT NULL THEN
998: ln_item_cnt := ln_item_cnt + 1;
999: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1000: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','ln_item_cnt:'||ln_item_cnt);
1001: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','calling add_to_do with base_id/p_item_number/status/p_upd_mode:'||p_base_id||'/'||p_item_number_15||'/'||p_status_1||'/'||p_upd_mode);
1002: END IF;
1003: add_to_do( p_base_id, p_item_number_15, ln_item_cnt, p_person_id, p_status_15,p_upd_mode);
1004: END IF;
1005:

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

1009: FND_FILE.PUT_LINE(FND_FILE.LOG ,' ');
1010: FND_FILE.PUT_LINE(FND_FILE.LOG ,' ');
1011:
1012: -- Update the FA Process Stauses with the TO DO Details
1013: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1014: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','calling igf_ap_batch_ver_prc_pkg.update_process_status');
1015: END IF;
1016: igf_ap_batch_ver_prc_pkg.update_process_status(p_base_id, NULL);
1017:

Line 1014: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','calling igf_ap_batch_ver_prc_pkg.update_process_status');

1010: FND_FILE.PUT_LINE(FND_FILE.LOG ,' ');
1011:
1012: -- Update the FA Process Stauses with the TO DO Details
1013: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1014: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','calling igf_ap_batch_ver_prc_pkg.update_process_status');
1015: END IF;
1016: igf_ap_batch_ver_prc_pkg.update_process_status(p_base_id, NULL);
1017:
1018: EXCEPTION

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

1025: END each_student_todo; -- End of each_student_todo
1026:
1027: BEGIN -- Begin of assign_todo
1028:
1029: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1030: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.assign_todo.debug','entering assign_todo');
1031: END IF;
1032: -- If both Person and Person ID Group are present then return back false
1033: IF p_base_id IS NOT NULL AND p_person_id_grp IS NOT NULL THEN

Line 1030: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.assign_todo.debug','entering assign_todo');

1026:
1027: BEGIN -- Begin of assign_todo
1028:
1029: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1030: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.assign_todo.debug','entering assign_todo');
1031: END IF;
1032: -- If both Person and Person ID Group are present then return back false
1033: IF p_base_id IS NOT NULL AND p_person_id_grp IS NOT NULL THEN
1034: FND_MESSAGE.SET_NAME('IGS','IGS_FI_NO_PERS_PGRP');

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

1056: FND_MESSAGE.SET_TOKEN('PERSON_NUMBER',lc_person_details_rec.person_number);
1057: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
1058: END IF;
1059:
1060: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1061: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.assign_todo.debug','calling each_student_todo for base_id:'||p_base_id);
1062: END IF;
1063: -- Process the student, add TO DO to the students
1064: each_student_todo(p_base_id, lc_person_details_rec.person_id );

Line 1061: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.assign_todo.debug','calling each_student_todo for base_id:'||p_base_id);

1057: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
1058: END IF;
1059:
1060: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1061: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.assign_todo.debug','calling each_student_todo for base_id:'||p_base_id);
1062: END IF;
1063: -- Process the student, add TO DO to the students
1064: each_student_todo(p_base_id, lc_person_details_rec.person_id );
1065:

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

1107: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
1108: END IF;
1109:
1110: -- Process the student, add TO DO to the students
1111: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1112: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.assign_todo.debug','calling each_student_todo for base_id:'||p_base_id);
1113: END IF;
1114: each_student_todo(ln_base_id, c_person_id_grp_rec.person_id);
1115: END IF;

Line 1112: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.assign_todo.debug','calling each_student_todo for base_id:'||p_base_id);

1108: END IF;
1109:
1110: -- Process the student, add TO DO to the students
1111: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1112: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.assign_todo.debug','calling each_student_todo for base_id:'||p_base_id);
1113: END IF;
1114: each_student_todo(ln_base_id, c_person_id_grp_rec.person_id);
1115: END IF;
1116: CLOSE c_fa_base;

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

1256: END IF;
1257: END IF;
1258:
1259: -- Assign TODO for all the students
1260: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1261: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.main.debug','calling assgin_todo');
1262: END IF;
1263: lb_return_value := assign_todo(
1264: p_base_id, p_person_id_grp, lv_ci_cal_type, lv_ci_sequence_number,p_upd_mode,

Line 1261: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.main.debug','calling assgin_todo');

1257: END IF;
1258:
1259: -- Assign TODO for all the students
1260: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1261: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.main.debug','calling assgin_todo');
1262: END IF;
1263: lb_return_value := assign_todo(
1264: p_base_id, p_person_id_grp, lv_ci_cal_type, lv_ci_sequence_number,p_upd_mode,
1265: p_item_1, p_status_1, p_item_2, p_status_2,