APPS.IGS_AD_PNMEMBR_DTLS_PKG dependencies on IGS_AD_GEN_013

Line 628: l_final_decision := igs_ad_gen_013.get_sys_code_status(rec_chk_final_decision.final_decision_code,

624: -- Check final decision associated to panel code.
625: OPEN c_chk_final_decision(new_references.panel_dtls_id);
626: FETCH c_chk_final_decision INTO rec_chk_final_decision;
627: CLOSE c_chk_final_decision;
628: l_final_decision := igs_ad_gen_013.get_sys_code_status(rec_chk_final_decision.final_decision_code,
629: rec_chk_final_decision.final_decision_type);
630:
631: IF NVL(l_final_decision,'PENDING') <> 'PENDING' THEN
632: fnd_message.set_name('IGS','IGS_AD_PNL_FNL_DECISION_EXITS'); -- Message: Cannot update/insert panel member's information when the panel final decision is already recorded.

Line 672: l_member_decision := igs_ad_gen_013.get_sys_code_status(new_references.member_decision_code,

668:
669: -- If a screening decision entered, is mapped to the system screening decision of 'VOIDED' then the screening decision may not be updated for the reviewer.
670: -- Throw an error message if the screening decision is attempted to be updated from 'VOIDED' to any other status.
671: -- Check the member's decision associated with panel member.
672: l_member_decision := igs_ad_gen_013.get_sys_code_status(new_references.member_decision_code,
673: new_references.member_decision_type);
674: -- Check the old member's decision associated with panel member.
675: l_old_member_decision := igs_ad_gen_013.get_sys_code_status(old_references.member_decision_code,
676: old_references.member_decision_type);

Line 675: l_old_member_decision := igs_ad_gen_013.get_sys_code_status(old_references.member_decision_code,

671: -- Check the member's decision associated with panel member.
672: l_member_decision := igs_ad_gen_013.get_sys_code_status(new_references.member_decision_code,
673: new_references.member_decision_type);
674: -- Check the old member's decision associated with panel member.
675: l_old_member_decision := igs_ad_gen_013.get_sys_code_status(old_references.member_decision_code,
676: old_references.member_decision_type);
677: IF l_old_member_decision = 'VOIDED' AND l_member_decision <> 'VOIDED' THEN
678: fnd_message.set_name('IGS','IGS_AD_NO_UPD_VOID_DECISION'); -- Message: Cannot update the reviewer's decision as it is mapped to a status of Voided.
679: igs_ge_msg_stack.add;

Line 693: l_final_decision := igs_ad_gen_013.get_sys_code_status(rec_chk_final_decision.final_decision_code,

689: -- Check final decision associated to panel code.
690: OPEN c_chk_final_decision(old_references.panel_dtls_id);
691: FETCH c_chk_final_decision INTO rec_chk_final_decision;
692: CLOSE c_chk_final_decision;
693: l_final_decision := igs_ad_gen_013.get_sys_code_status(rec_chk_final_decision.final_decision_code,
694: rec_chk_final_decision.final_decision_type);
695:
696: -- Check member decision associated with panel member.
697: l_member_decision := igs_ad_gen_013.get_sys_code_status(old_references.member_decision_code,

Line 697: l_member_decision := igs_ad_gen_013.get_sys_code_status(old_references.member_decision_code,

693: l_final_decision := igs_ad_gen_013.get_sys_code_status(rec_chk_final_decision.final_decision_code,
694: rec_chk_final_decision.final_decision_type);
695:
696: -- Check member decision associated with panel member.
697: l_member_decision := igs_ad_gen_013.get_sys_code_status(old_references.member_decision_code,
698: old_references.member_decision_type);
699:
700: IF NVL(l_final_decision,'*') <> 'PENDING' OR NVL(l_member_decision,'*') <> 'PENDING' THEN
701: fnd_message.set_name('IGS','IGS_AD_PNL_DECISION_EXITS'); -- Message: Cannot delete the panel member when the decision is already recorded.