DBA Data[Home] [Help]

APPS.IGS_PS_CREATE_GENERIC_PKG dependencies on IGS_PS_VAL_UNIT

Line 6685: IF igs_ps_val_unit.crsp_val_iud_uv_dtl(p_tab_uso_ins(I).unit_cd, p_tab_uso_ins(I).version_number,l_message_name)=FALSE THEN

6681:
6682: --Business validations
6683: IF p_tab_uso_ins(I).status = 'S' THEN
6684: --Check if the unit is INACTIVE, then do not allow to import
6685: IF igs_ps_val_unit.crsp_val_iud_uv_dtl(p_tab_uso_ins(I).unit_cd, p_tab_uso_ins(I).version_number,l_message_name)=FALSE THEN
6686: fnd_message.set_name ( 'IGS', 'IGS_PS_NOCHG_UNITVER_DETAILS' );
6687: fnd_msg_pub.add;
6688: p_tab_uso_ins(I).status := 'E';
6689: END IF;

Line 7064: IF igs_ps_val_unit.crsp_val_iud_uv_dtl(p_usec_teach_resp_rec.unit_cd, p_usec_teach_resp_rec.version_number,l_message_name)=FALSE THEN

7060: l_n_no_of_instructor NUMBER;
7061: l_n_count NUMBER;
7062: BEGIN
7063: --Check if the unit is INACTIVE, then do not allow to import
7064: IF igs_ps_val_unit.crsp_val_iud_uv_dtl(p_usec_teach_resp_rec.unit_cd, p_usec_teach_resp_rec.version_number,l_message_name)=FALSE THEN
7065: fnd_message.set_name ( 'IGS', 'IGS_PS_NOCHG_UNITVER_DETAILS' );
7066: fnd_msg_pub.add;
7067: p_usec_teach_resp_rec.status := 'E';
7068: END IF;

Line 7770: IF igs_ps_val_unit.crsp_val_iud_uv_dtl(p_usec_sp_fee_rec.unit_cd, p_usec_sp_fee_rec.version_number,l_message_name)=FALSE THEN

7766:
7767: --Store the superior calendars in a pl-sql tables for the input teaching calendars
7768: createCalendar;
7769: --Check if the unit is INACTIVE, then do not allow to import
7770: IF igs_ps_val_unit.crsp_val_iud_uv_dtl(p_usec_sp_fee_rec.unit_cd, p_usec_sp_fee_rec.version_number,l_message_name)=FALSE THEN
7771: fnd_message.set_name ( 'IGS', 'IGS_PS_NOCHG_UNITVER_DETAILS' );
7772: fnd_msg_pub.add;
7773: p_usec_sp_fee_rec.status := 'E';
7774: END IF;

Line 8339: IF igs_ps_val_unit.crsp_val_iud_uv_dtl(p_usec_plus_hr_rec.unit_cd, p_usec_plus_hr_rec.version_number,l_message_name)=FALSE THEN

8335: l_message_name VARCHAR2(30);
8336: l_preferred_name igs_pe_person.preferred_name%TYPE;
8337: BEGIN
8338: --Check if the unit is INACTIVE, then do not allow to import
8339: IF igs_ps_val_unit.crsp_val_iud_uv_dtl(p_usec_plus_hr_rec.unit_cd, p_usec_plus_hr_rec.version_number,l_message_name)=FALSE THEN
8340: fnd_message.set_name ( 'IGS', 'IGS_PS_NOCHG_UNITVER_DETAILS' );
8341: fnd_msg_pub.add;
8342: p_usec_plus_hr_rec.status := 'E';
8343: END IF;

Line 8750: IF igs_ps_val_unit.crsp_val_iud_uv_dtl(p_usec_rule_rec.unit_cd, p_usec_rule_rec.version_number,l_message_name)=FALSE THEN

8746: l_c_var VARCHAR2(1);
8747:
8748: BEGIN
8749: --Check if the unit is INACTIVE, then do not allow to import
8750: IF igs_ps_val_unit.crsp_val_iud_uv_dtl(p_usec_rule_rec.unit_cd, p_usec_rule_rec.version_number,l_message_name)=FALSE THEN
8751: fnd_message.set_name ( 'IGS', 'IGS_PS_NOCHG_UNITVER_DETAILS' );
8752: fnd_msg_pub.add;
8753: p_usec_rule_rec.status := 'E';
8754: END IF;

Line 9277: IF igs_ps_val_unit.crsp_val_iud_uv_dtl(p_usec_enr_dead_rec.unit_cd, p_usec_enr_dead_rec.version_number,l_message_name)=FALSE THEN

9273: l_message_name VARCHAR2(30);
9274:
9275: BEGIN
9276: --Check if the unit is INACTIVE, then do not allow to import
9277: IF igs_ps_val_unit.crsp_val_iud_uv_dtl(p_usec_enr_dead_rec.unit_cd, p_usec_enr_dead_rec.version_number,l_message_name)=FALSE THEN
9278: fnd_message.set_name ( 'IGS', 'IGS_PS_NOCHG_UNITVER_DETAILS' );
9279: fnd_msg_pub.add;
9280: p_usec_enr_dead_rec.status := 'E';
9281: END IF;

Line 9858: IF igs_ps_val_unit.crsp_val_iud_uv_dtl(p_usec_enr_dis_rec.unit_cd, p_usec_enr_dis_rec.version_number,l_message_name)=FALSE THEN

9854: l_message_name VARCHAR2(30);
9855:
9856: BEGIN
9857: --Check if the unit is INACTIVE, then do not allow to import
9858: IF igs_ps_val_unit.crsp_val_iud_uv_dtl(p_usec_enr_dis_rec.unit_cd, p_usec_enr_dis_rec.version_number,l_message_name)=FALSE THEN
9859: fnd_message.set_name ( 'IGS', 'IGS_PS_NOCHG_UNITVER_DETAILS' );
9860: fnd_msg_pub.add;
9861: p_usec_enr_dis_rec.status := 'E';
9862: END IF;

Line 10438: IF igs_ps_val_unit.crsp_val_iud_uv_dtl(p_usec_ret_rec.unit_cd, p_usec_ret_rec.version_number,l_message_name)=FALSE THEN

10434: BEGIN
10435: --Store the superior calendars in a pl-sql tables for the input teaching calendars
10436: createCalendar;
10437: --Check if the unit is INACTIVE, then do not allow to import
10438: IF igs_ps_val_unit.crsp_val_iud_uv_dtl(p_usec_ret_rec.unit_cd, p_usec_ret_rec.version_number,l_message_name)=FALSE THEN
10439: fnd_message.set_name ( 'IGS', 'IGS_PS_NOCHG_UNITVER_DETAILS' );
10440: fnd_msg_pub.add;
10441: p_usec_ret_rec.status := 'E';
10442: END IF;

Line 11044: IF igs_ps_val_unit.crsp_val_iud_uv_dtl(p_usec_ret_dtl_rec.unit_cd, p_usec_ret_dtl_rec.version_number,l_message_name)=FALSE THEN

11040:
11041:
11042: BEGIN
11043: --Check if the unit is INACTIVE, then do not allow to import
11044: IF igs_ps_val_unit.crsp_val_iud_uv_dtl(p_usec_ret_dtl_rec.unit_cd, p_usec_ret_dtl_rec.version_number,l_message_name)=FALSE THEN
11045: fnd_message.set_name ( 'IGS', 'IGS_PS_NOCHG_UNITVER_DETAILS' );
11046: fnd_msg_pub.add;
11047: p_usec_ret_dtl_rec.status := 'E';
11048: END IF;