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_MESSAGE

Line 407: FND_MESSAGE.SET_NAME('IGF','IGF_GE_UNHANDLED_EXP');

403: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
404:
405: EXCEPTION
406: WHEN others THEN
407: FND_MESSAGE.SET_NAME('IGF','IGF_GE_UNHANDLED_EXP');
408: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_TODO_GRPS_PRC_PKG.LOG_INPUT_PARAMS');
409: IGS_GE_MSG_STACK.ADD;
410: APP_EXCEPTION.RAISE_EXCEPTION;
411:

Line 408: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_TODO_GRPS_PRC_PKG.LOG_INPUT_PARAMS');

404:
405: EXCEPTION
406: WHEN others THEN
407: FND_MESSAGE.SET_NAME('IGF','IGF_GE_UNHANDLED_EXP');
408: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_TODO_GRPS_PRC_PKG.LOG_INPUT_PARAMS');
409: IGS_GE_MSG_STACK.ADD;
410: APP_EXCEPTION.RAISE_EXCEPTION;
411:
412: END log_input_params;

Line 543: fnd_message.set_name('IGF','IGF_AP_LEND_TD_NO_ASSGN');

539: OPEN c_check_preflender(cp_person_id => p_person_id);
540: FETCH c_check_preflender INTO lc_check_preflender;
541: IF c_check_preflender%FOUND THEN
542: -- If already an active preflender present - then Skip that item for processing and log a message
543: fnd_message.set_name('IGF','IGF_AP_LEND_TD_NO_ASSGN');
544: fnd_message.set_token('ITEM',lc_item_details.description);
545: FND_FILE.PUT_LINE(FND_FILE.LOG ,FND_MESSAGE.GET);
546: ln_skip_items := ln_skip_items + 1;
547: RETURN;

Line 544: fnd_message.set_token('ITEM',lc_item_details.description);

540: FETCH c_check_preflender INTO lc_check_preflender;
541: IF c_check_preflender%FOUND THEN
542: -- If already an active preflender present - then Skip that item for processing and log a message
543: fnd_message.set_name('IGF','IGF_AP_LEND_TD_NO_ASSGN');
544: fnd_message.set_token('ITEM',lc_item_details.description);
545: FND_FILE.PUT_LINE(FND_FILE.LOG ,FND_MESSAGE.GET);
546: ln_skip_items := ln_skip_items + 1;
547: RETURN;
548: END IF;

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

541: IF c_check_preflender%FOUND THEN
542: -- If already an active preflender present - then Skip that item for processing and log a message
543: fnd_message.set_name('IGF','IGF_AP_LEND_TD_NO_ASSGN');
544: fnd_message.set_token('ITEM',lc_item_details.description);
545: FND_FILE.PUT_LINE(FND_FILE.LOG ,FND_MESSAGE.GET);
546: ln_skip_items := ln_skip_items + 1;
547: RETURN;
548: END IF;
549: CLOSE c_check_preflender;

Line 581: fnd_message.set_name('IGF','IGF_AP_INAC_TD_SKIP');

577: cp_item_sequence_number => p_todo_number);
578: FETCH c_to_do_item INTO lc_to_do_item;
579: CLOSE c_to_do_item;
580: IF lc_to_do_item.inactive_flag = 'Y' 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

Line 582: fnd_message.set_token('ITEMCODE',lc_item_details.description);

578: FETCH c_to_do_item INTO lc_to_do_item;
579: CLOSE c_to_do_item;
580: IF lc_to_do_item.inactive_flag = 'Y' 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');

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

579: CLOSE c_to_do_item;
580: IF lc_to_do_item.inactive_flag = 'Y' 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;

Line 622: fnd_message.set_name('IGF','IGF_AP_TODO_UPD');

618: x_clprl_id => lc_to_do_item.clprl_id
619: );
620:
621: -- Log message with the Updated To Do Item.
622: fnd_message.set_name('IGF','IGF_AP_TODO_UPD');
623: fnd_message.set_token('ITEM',lc_item_details.description);
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;

Line 623: fnd_message.set_token('ITEM',lc_item_details.description);

619: );
620:
621: -- Log message with the Updated To Do Item.
622: fnd_message.set_name('IGF','IGF_AP_TODO_UPD');
623: fnd_message.set_token('ITEM',lc_item_details.description);
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

Line 624: fnd_message.set_token('STATUS',igf_aw_gen.lookup_desc('IGF_TD_ITEM_STATUS',l_status));

620:
621: -- Log message with the Updated To Do Item.
622: fnd_message.set_name('IGF','IGF_AP_TODO_UPD');
623: fnd_message.set_token('ITEM',lc_item_details.description);
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

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

621: -- Log message with the Updated To Do Item.
622: fnd_message.set_name('IGF','IGF_AP_TODO_UPD');
623: fnd_message.set_token('ITEM',lc_item_details.description);
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);

Line 650: fnd_message.set_name('IGF','IGF_AP_TODO_ASSIGN');

646: x_clprl_id => NULL
647: );
648:
649: -- Log message with the added To Do Item added to the student.
650: fnd_message.set_name('IGF','IGF_AP_TODO_ASSIGN');
651: fnd_message.set_token('ITEM',lc_item_details.description);
652: fnd_message.set_token('STATUS',igf_aw_gen.lookup_desc('IGF_TD_ITEM_STATUS',l_status));
653: FND_FILE.PUT_LINE(FND_FILE.LOG ,FND_MESSAGE.GET);
654: END IF;

Line 651: fnd_message.set_token('ITEM',lc_item_details.description);

647: );
648:
649: -- Log message with the added To Do Item added to the student.
650: fnd_message.set_name('IGF','IGF_AP_TODO_ASSIGN');
651: fnd_message.set_token('ITEM',lc_item_details.description);
652: fnd_message.set_token('STATUS',igf_aw_gen.lookup_desc('IGF_TD_ITEM_STATUS',l_status));
653: FND_FILE.PUT_LINE(FND_FILE.LOG ,FND_MESSAGE.GET);
654: END IF;
655:

Line 652: fnd_message.set_token('STATUS',igf_aw_gen.lookup_desc('IGF_TD_ITEM_STATUS',l_status));

648:
649: -- Log message with the added To Do Item added to the student.
650: fnd_message.set_name('IGF','IGF_AP_TODO_ASSIGN');
651: fnd_message.set_token('ITEM',lc_item_details.description);
652: fnd_message.set_token('STATUS',igf_aw_gen.lookup_desc('IGF_TD_ITEM_STATUS',l_status));
653: FND_FILE.PUT_LINE(FND_FILE.LOG ,FND_MESSAGE.GET);
654: END IF;
655:
656: EXCEPTION

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

649: -- Log message with the added To Do Item added to the student.
650: fnd_message.set_name('IGF','IGF_AP_TODO_ASSIGN');
651: fnd_message.set_token('ITEM',lc_item_details.description);
652: fnd_message.set_token('STATUS',igf_aw_gen.lookup_desc('IGF_TD_ITEM_STATUS',l_status));
653: FND_FILE.PUT_LINE(FND_FILE.LOG ,FND_MESSAGE.GET);
654: END IF;
655:
656: EXCEPTION
657: WHEN others THEN

Line 658: FND_MESSAGE.SET_NAME('IGF','IGF_GE_UNHANDLED_EXP');

654: END IF;
655:
656: EXCEPTION
657: WHEN others THEN
658: FND_MESSAGE.SET_NAME('IGF','IGF_GE_UNHANDLED_EXP');
659: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_TODO_GRPS_PRC_PKG.ADD_TO_DO');
660: IGS_GE_MSG_STACK.ADD;
661: APP_EXCEPTION.RAISE_EXCEPTION;
662:

Line 659: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_TODO_GRPS_PRC_PKG.ADD_TO_DO');

655:
656: EXCEPTION
657: WHEN others THEN
658: FND_MESSAGE.SET_NAME('IGF','IGF_GE_UNHANDLED_EXP');
659: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_TODO_GRPS_PRC_PKG.ADD_TO_DO');
660: IGS_GE_MSG_STACK.ADD;
661: APP_EXCEPTION.RAISE_EXCEPTION;
662:
663: END add_to_do;

Line 1006: FND_MESSAGE.SET_NAME('IGF', 'IGF_AP_TODO_ADDED');

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:
1006: FND_MESSAGE.SET_NAME('IGF', 'IGF_AP_TODO_ADDED');
1007: FND_MESSAGE.SET_TOKEN('COUNT', TO_CHAR(ln_item_cnt-ln_skip_items));
1008: FND_FILE.PUT_LINE(FND_FILE.LOG ,FND_MESSAGE.GET);
1009: FND_FILE.PUT_LINE(FND_FILE.LOG ,' ');
1010: FND_FILE.PUT_LINE(FND_FILE.LOG ,' ');

Line 1007: FND_MESSAGE.SET_TOKEN('COUNT', TO_CHAR(ln_item_cnt-ln_skip_items));

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:
1006: FND_MESSAGE.SET_NAME('IGF', 'IGF_AP_TODO_ADDED');
1007: FND_MESSAGE.SET_TOKEN('COUNT', TO_CHAR(ln_item_cnt-ln_skip_items));
1008: FND_FILE.PUT_LINE(FND_FILE.LOG ,FND_MESSAGE.GET);
1009: FND_FILE.PUT_LINE(FND_FILE.LOG ,' ');
1010: FND_FILE.PUT_LINE(FND_FILE.LOG ,' ');
1011:

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

1004: END IF;
1005:
1006: FND_MESSAGE.SET_NAME('IGF', 'IGF_AP_TODO_ADDED');
1007: FND_MESSAGE.SET_TOKEN('COUNT', TO_CHAR(ln_item_cnt-ln_skip_items));
1008: FND_FILE.PUT_LINE(FND_FILE.LOG ,FND_MESSAGE.GET);
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

Line 1020: FND_MESSAGE.SET_NAME('IGF','IGF_GE_UNHANDLED_EXP');

1016: igf_ap_batch_ver_prc_pkg.update_process_status(p_base_id, NULL);
1017:
1018: EXCEPTION
1019: WHEN others THEN
1020: FND_MESSAGE.SET_NAME('IGF','IGF_GE_UNHANDLED_EXP');
1021: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_TODO_GRPS_PRC_PKG.EACH_STUDENT_TODO');
1022: IGS_GE_MSG_STACK.ADD;
1023: APP_EXCEPTION.RAISE_EXCEPTION;
1024:

Line 1021: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_TODO_GRPS_PRC_PKG.EACH_STUDENT_TODO');

1017:
1018: EXCEPTION
1019: WHEN others THEN
1020: FND_MESSAGE.SET_NAME('IGF','IGF_GE_UNHANDLED_EXP');
1021: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_TODO_GRPS_PRC_PKG.EACH_STUDENT_TODO');
1022: IGS_GE_MSG_STACK.ADD;
1023: APP_EXCEPTION.RAISE_EXCEPTION;
1024:
1025: END each_student_todo; -- End of each_student_todo

Line 1034: FND_MESSAGE.SET_NAME('IGS','IGS_FI_NO_PERS_PGRP');

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');
1035: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
1036: RETURN FALSE;
1037:
1038: ELSIF p_base_id IS NULL AND p_person_id_grp IS NULL THEN

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

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');
1035: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
1036: RETURN FALSE;
1037:
1038: ELSIF p_base_id IS NULL AND p_person_id_grp IS NULL THEN
1039: FND_MESSAGE.SET_NAME('IGS','IGS_FI_PRS_PRSIDGRP_NULL');

Line 1039: FND_MESSAGE.SET_NAME('IGS','IGS_FI_PRS_PRSIDGRP_NULL');

1035: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
1036: RETURN FALSE;
1037:
1038: ELSIF p_base_id IS NULL AND p_person_id_grp IS NULL THEN
1039: FND_MESSAGE.SET_NAME('IGS','IGS_FI_PRS_PRSIDGRP_NULL');
1040: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
1041: RETURN FALSE;
1042:
1043: ELSE

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

1036: RETURN FALSE;
1037:
1038: ELSIF p_base_id IS NULL AND p_person_id_grp IS NULL THEN
1039: FND_MESSAGE.SET_NAME('IGS','IGS_FI_PRS_PRSIDGRP_NULL');
1040: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
1041: RETURN FALSE;
1042:
1043: ELSE
1044:

Line 1054: FND_MESSAGE.SET_NAME('IGF','IGF_AP_PROCESSING_STUDENT');

1050: OPEN c_person_details(p_base_id);
1051: FETCH c_person_details INTO lc_person_details_rec;
1052: CLOSE c_person_details;
1053: IF p_calling_from = 'TODO' THEN
1054: FND_MESSAGE.SET_NAME('IGF','IGF_AP_PROCESSING_STUDENT');
1055: FND_MESSAGE.SET_TOKEN('PERSON_NAME',lc_person_details_rec.person_name);
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;

Line 1055: FND_MESSAGE.SET_TOKEN('PERSON_NAME',lc_person_details_rec.person_name);

1051: FETCH c_person_details INTO lc_person_details_rec;
1052: CLOSE c_person_details;
1053: IF p_calling_from = 'TODO' THEN
1054: FND_MESSAGE.SET_NAME('IGF','IGF_AP_PROCESSING_STUDENT');
1055: FND_MESSAGE.SET_TOKEN('PERSON_NAME',lc_person_details_rec.person_name);
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:

Line 1056: FND_MESSAGE.SET_TOKEN('PERSON_NUMBER',lc_person_details_rec.person_number);

1052: CLOSE c_person_details;
1053: IF p_calling_from = 'TODO' THEN
1054: FND_MESSAGE.SET_NAME('IGF','IGF_AP_PROCESSING_STUDENT');
1055: FND_MESSAGE.SET_TOKEN('PERSON_NAME',lc_person_details_rec.person_name);
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

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

1053: IF p_calling_from = 'TODO' THEN
1054: FND_MESSAGE.SET_NAME('IGF','IGF_AP_PROCESSING_STUDENT');
1055: FND_MESSAGE.SET_TOKEN('PERSON_NAME',lc_person_details_rec.person_name);
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);

Line 1098: FND_MESSAGE.SET_NAME('IGF','IGF_AP_NO_BASEID');

1094: CLOSE c_get_parameters;
1095: FND_FILE.PUT_LINE(FND_FILE.LOG,l_person_number|| ' : '|| c_person_id_grp_rec.person_number);
1096:
1097: -- Log a message and skip the student
1098: FND_MESSAGE.SET_NAME('IGF','IGF_AP_NO_BASEID');
1099: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
1100: ELSE
1101:
1102: -- log a message for the processing student.

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

1095: FND_FILE.PUT_LINE(FND_FILE.LOG,l_person_number|| ' : '|| c_person_id_grp_rec.person_number);
1096:
1097: -- Log a message and skip the student
1098: FND_MESSAGE.SET_NAME('IGF','IGF_AP_NO_BASEID');
1099: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
1100: ELSE
1101:
1102: -- log a message for the processing student.
1103: IF p_calling_from = 'TODO' THEN

Line 1104: FND_MESSAGE.SET_NAME('IGF','IGF_AP_PROCESSING_STUDENT');

1100: ELSE
1101:
1102: -- log a message for the processing student.
1103: IF p_calling_from = 'TODO' THEN
1104: FND_MESSAGE.SET_NAME('IGF','IGF_AP_PROCESSING_STUDENT');
1105: FND_MESSAGE.SET_TOKEN('PERSON_NAME',c_person_id_grp_rec.full_name);
1106: FND_MESSAGE.SET_TOKEN('PERSON_NUMBER',c_person_id_grp_rec.person_number);
1107: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
1108: END IF;

Line 1105: FND_MESSAGE.SET_TOKEN('PERSON_NAME',c_person_id_grp_rec.full_name);

1101:
1102: -- log a message for the processing student.
1103: IF p_calling_from = 'TODO' THEN
1104: FND_MESSAGE.SET_NAME('IGF','IGF_AP_PROCESSING_STUDENT');
1105: FND_MESSAGE.SET_TOKEN('PERSON_NAME',c_person_id_grp_rec.full_name);
1106: FND_MESSAGE.SET_TOKEN('PERSON_NUMBER',c_person_id_grp_rec.person_number);
1107: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
1108: END IF;
1109:

Line 1106: FND_MESSAGE.SET_TOKEN('PERSON_NUMBER',c_person_id_grp_rec.person_number);

1102: -- log a message for the processing student.
1103: IF p_calling_from = 'TODO' THEN
1104: FND_MESSAGE.SET_NAME('IGF','IGF_AP_PROCESSING_STUDENT');
1105: FND_MESSAGE.SET_TOKEN('PERSON_NAME',c_person_id_grp_rec.full_name);
1106: FND_MESSAGE.SET_TOKEN('PERSON_NUMBER',c_person_id_grp_rec.person_number);
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

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

1103: IF p_calling_from = 'TODO' THEN
1104: FND_MESSAGE.SET_NAME('IGF','IGF_AP_PROCESSING_STUDENT');
1105: FND_MESSAGE.SET_TOKEN('PERSON_NAME',c_person_id_grp_rec.full_name);
1106: FND_MESSAGE.SET_TOKEN('PERSON_NUMBER',c_person_id_grp_rec.person_number);
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

Line 1126: FND_MESSAGE.SET_NAME('IGF','IGF_GE_UNHANDLED_EXP');

1122: END IF; -- End of check for both Person and Person ID Group
1123:
1124: EXCEPTION
1125: WHEN others THEN
1126: FND_MESSAGE.SET_NAME('IGF','IGF_GE_UNHANDLED_EXP');
1127: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_TODO_GRPS_PRC_PKG.ASSIGN_TODO');
1128: IGS_GE_MSG_STACK.ADD;
1129: APP_EXCEPTION.RAISE_EXCEPTION;
1130:

Line 1127: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_TODO_GRPS_PRC_PKG.ASSIGN_TODO');

1123:
1124: EXCEPTION
1125: WHEN others THEN
1126: FND_MESSAGE.SET_NAME('IGF','IGF_GE_UNHANDLED_EXP');
1127: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_TODO_GRPS_PRC_PKG.ASSIGN_TODO');
1128: IGS_GE_MSG_STACK.ADD;
1129: APP_EXCEPTION.RAISE_EXCEPTION;
1130:
1131: END assign_todo;

Line 1219: errbuf:= FND_MESSAGE.GET_STRING('IGS','IGS_FI_NO_PERS_PGRP');

1215: );
1216:
1217: -- If Person ID Group and Person ID both are present then, exit the process stating that either of the one should be present.
1218: IF p_base_id IS NOT NULL AND p_person_id_grp IS NOT NULL THEN
1219: errbuf:= FND_MESSAGE.GET_STRING('IGS','IGS_FI_NO_PERS_PGRP');
1220: retcode := 2;
1221: RETURN;
1222: ELSIF p_base_id IS NULL AND p_person_id_grp IS NULL THEN
1223: errbuf:= FND_MESSAGE.GET_STRING('IGS','IGS_FI_PRS_PRSIDGRP_NULL');

Line 1223: errbuf:= FND_MESSAGE.GET_STRING('IGS','IGS_FI_PRS_PRSIDGRP_NULL');

1219: errbuf:= FND_MESSAGE.GET_STRING('IGS','IGS_FI_NO_PERS_PGRP');
1220: retcode := 2;
1221: RETURN;
1222: ELSIF p_base_id IS NULL AND p_person_id_grp IS NULL THEN
1223: errbuf:= FND_MESSAGE.GET_STRING('IGS','IGS_FI_PRS_PRSIDGRP_NULL');
1224: retcode := 2;
1225: RETURN;
1226: END IF;
1227:

Line 1246: FND_MESSAGE.SET_NAME ('IGF','IGF_AP_INVALID_QUERY');

1242: END IF;
1243:
1244: EXCEPTION
1245: WHEN OTHERS THEN
1246: FND_MESSAGE.SET_NAME ('IGF','IGF_AP_INVALID_QUERY');
1247: FND_FILE.PUT_LINE (FND_FILE.LOG,FND_MESSAGE.GET);
1248: RETURN;
1249: END;
1250:

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

1243:
1244: EXCEPTION
1245: WHEN OTHERS THEN
1246: FND_MESSAGE.SET_NAME ('IGF','IGF_AP_INVALID_QUERY');
1247: FND_FILE.PUT_LINE (FND_FILE.LOG,FND_MESSAGE.GET);
1248: RETURN;
1249: END;
1250:
1251: IF ln_stdnt_count = 0 THEN

Line 1252: FND_MESSAGE.SET_NAME('IGF','IGF_DB_NO_PER_GRP');

1248: RETURN;
1249: END;
1250:
1251: IF ln_stdnt_count = 0 THEN
1252: FND_MESSAGE.SET_NAME('IGF','IGF_DB_NO_PER_GRP');
1253: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
1254: retcode := 0;
1255: RETURN;
1256: END IF;

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

1249: END;
1250:
1251: IF ln_stdnt_count = 0 THEN
1252: FND_MESSAGE.SET_NAME('IGF','IGF_DB_NO_PER_GRP');
1253: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
1254: retcode := 0;
1255: RETURN;
1256: END IF;
1257: END IF;

Line 1277: errbuf:= FND_MESSAGE.GET_STRING('IGS','IGS_FI_NO_PERS_PGRP');

1273:
1274: -- If Person ID Group and Person ID both are present then, exit the process stating that either of the one should be present.
1275: IF lb_return_value = FALSE THEN
1276: IF p_base_id IS NOT NULL AND p_person_id_grp IS NOT NULL THEN
1277: errbuf:= FND_MESSAGE.GET_STRING('IGS','IGS_FI_NO_PERS_PGRP');
1278: retcode := 2;
1279: RETURN;
1280: ELSIF p_base_id IS NULL AND p_person_id_grp IS NULL THEN
1281: errbuf:= FND_MESSAGE.GET_STRING('IGS','IGS_FI_PRS_PRSIDGRP_NULL');

Line 1281: errbuf:= FND_MESSAGE.GET_STRING('IGS','IGS_FI_PRS_PRSIDGRP_NULL');

1277: errbuf:= FND_MESSAGE.GET_STRING('IGS','IGS_FI_NO_PERS_PGRP');
1278: retcode := 2;
1279: RETURN;
1280: ELSIF p_base_id IS NULL AND p_person_id_grp IS NULL THEN
1281: errbuf:= FND_MESSAGE.GET_STRING('IGS','IGS_FI_PRS_PRSIDGRP_NULL');
1282: retcode := 2;
1283: RETURN;
1284: END IF;
1285: END IF;

Line 1291: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

1287: WHEN others THEN
1288: ROLLBACK;
1289: FND_FILE.PUT_LINE(FND_FILE.LOG,SQLERRM);
1290: RETCODE := 2 ;
1291: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1292: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_TODO_GRPS_PRC_PKG.MAIN');
1293: errbuf := FND_MESSAGE.GET ;
1294: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL ;
1295: END main;

Line 1292: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_TODO_GRPS_PRC_PKG.MAIN');

1288: ROLLBACK;
1289: FND_FILE.PUT_LINE(FND_FILE.LOG,SQLERRM);
1290: RETCODE := 2 ;
1291: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1292: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_TODO_GRPS_PRC_PKG.MAIN');
1293: errbuf := FND_MESSAGE.GET ;
1294: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL ;
1295: END main;
1296:

Line 1293: errbuf := FND_MESSAGE.GET ;

1289: FND_FILE.PUT_LINE(FND_FILE.LOG,SQLERRM);
1290: RETCODE := 2 ;
1291: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1292: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_TODO_GRPS_PRC_PKG.MAIN');
1293: errbuf := FND_MESSAGE.GET ;
1294: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL ;
1295: END main;
1296:
1297: