DBA Data[Home] [Help]

APPS.IGS_AD_CAL_CONF_PKG dependencies on IGS_AD_VAL_SACCO

Line 97: IF IGS_AD_VAL_SACCO.admp_val_sacco_da (

93: IF p_inserting OR
94: ((NVL(old_references.adm_appl_offer_resp_dt_alias, 'NULL') <>
95: NVL(new_references.adm_appl_offer_resp_dt_alias, 'NULL')) AND
96: new_references.adm_appl_offer_resp_dt_alias IS NOT NULL) THEN
97: IF IGS_AD_VAL_SACCO.admp_val_sacco_da (
98: new_references.adm_appl_offer_resp_dt_alias,
99: 'ADM_APPL_OFFER_RESP_DT_ALIAS',
100: v_message_name) = FALSE THEN
101: Fnd_Message.Set_Name('IGS',v_message_name);

Line 112: IF IGS_AD_VAL_SACCO.admp_val_sacco_da (

108: IF p_inserting OR
109: ((NVL(old_references.adm_appl_chng_of_pref_dt_alias, 'NULL') <>
110: NVL(new_references.adm_appl_chng_of_pref_dt_alias, 'NULL')) AND
111: new_references.adm_appl_chng_of_pref_dt_alias IS NOT NULL) THEN
112: IF IGS_AD_VAL_SACCO.admp_val_sacco_da (
113: new_references.adm_appl_chng_of_pref_dt_alias,
114: 'ADM_APPL_CHNG_OF_PREF_DT_ALIAS',
115: v_message_name) = FALSE THEN
116: Fnd_Message.Set_Name('IGS',v_message_name);

Line 126: IF IGS_AD_VAL_SACCO.admp_val_sacco_da (

122: IF p_inserting OR
123: ((NVL(old_references.adm_appl_due_dt_alias, 'NULL') <>
124: NVL(new_references.adm_appl_due_dt_alias, 'NULL')) AND
125: new_references.adm_appl_due_dt_alias IS NOT NULL) THEN
126: IF IGS_AD_VAL_SACCO.admp_val_sacco_da (
127: new_references.adm_appl_due_dt_alias,
128: 'ADM_APPL_DUE_DT_ALIAS',
129: v_message_name) = FALSE THEN
130: Fnd_Message.Set_Name('IGS',v_message_name);

Line 140: IF IGS_AD_VAL_SACCO.admp_val_sacco_da (

136: IF p_inserting OR
137: ((NVL(old_references.adm_appl_final_dt_alias, 'NULL') <>
138: NVL(new_references.adm_appl_final_dt_alias, 'NULL')) AND
139: new_references.adm_appl_final_dt_alias IS NOT NULL) THEN
140: IF IGS_AD_VAL_SACCO.admp_val_sacco_da (
141: new_references.adm_appl_final_dt_alias,
142: 'ADM_APPL_FINAL_DT_ALIAS',
143: v_message_name) = FALSE THEN
144: Fnd_Message.Set_Name('IGS',v_message_name);

Line 154: IF IGS_AD_VAL_SACCO.admp_val_sacco_da (

150: IF p_inserting OR
151: ((NVL(old_references.initialise_adm_perd_dt_alias, 'NULL') <>
152: NVL(new_references.initialise_adm_perd_dt_alias, 'NULL')) AND
153: new_references.initialise_adm_perd_dt_alias IS NOT NULL) THEN
154: IF IGS_AD_VAL_SACCO.admp_val_sacco_da (
155: new_references.initialise_adm_perd_dt_alias,
156: 'INITIALISE_ADM_PERD_DT_ALIAS',
157: v_message_name) = FALSE THEN
158: Fnd_Message.Set_Name('IGS',v_message_name);

Line 168: IF IGS_AD_VAL_SACCO.admp_val_sacco_da (

164: IF p_inserting OR
165: ((NVL(old_references.adm_appl_encmb_chk_dt_alias, 'NULL') <>
166: NVL(new_references.adm_appl_encmb_chk_dt_alias, 'NULL')) AND
167: new_references.adm_appl_encmb_chk_dt_alias IS NOT NULL) THEN
168: IF IGS_AD_VAL_SACCO.admp_val_sacco_da (
169: new_references.adm_appl_encmb_chk_dt_alias,
170: 'ADM_APPL_ENCMB_CHK_DT_ALIAS',
171: v_message_name) = FALSE THEN
172: Fnd_Message.Set_Name('IGS',v_message_name);

Line 182: IF IGS_AD_VAL_SACCO.admp_val_sacco_da (

178: IF p_inserting OR
179: ((NVL(old_references.adm_appl_course_strt_dt_alias, 'NULL') <>
180: NVL(new_references.adm_appl_course_strt_dt_alias, 'NULL')) AND
181: new_references.adm_appl_course_strt_dt_alias IS NOT NULL) THEN
182: IF IGS_AD_VAL_SACCO.admp_val_sacco_da (
183: new_references.adm_appl_course_strt_dt_alias,
184: 'ADM_APPL_COURSE_STRT_DT_ALIAS',
185: v_message_name) = FALSE THEN
186: Fnd_Message.Set_Name('IGS',v_message_name);

Line 197: IF IGS_AD_VAL_SACCO.admp_val_sacco_da (

193: IF p_inserting OR
194: ((NVL(old_references.adm_appl_short_strt_dt_alias, 'NULL') <>
195: NVL(new_references.adm_appl_short_strt_dt_alias, 'NULL')) AND
196: new_references.adm_appl_short_strt_dt_alias IS NOT NULL) THEN
197: IF IGS_AD_VAL_SACCO.admp_val_sacco_da (
198: new_references.adm_appl_short_strt_dt_alias,
199: 'ADM_APPL_SHORT_STRT_DT_ALIAS',
200: v_message_name) = FALSE THEN
201: Fnd_Message.Set_Name('IGS',v_message_name);

Line 211: IF IGS_AD_VAL_SACCO.admp_val_sacco_da (

207: IF p_inserting OR
208: ((NVL(old_references.adm_appl_e_comp_perd_dt_alias, 'NULL') <>
209: NVL(new_references.adm_appl_e_comp_perd_dt_alias, 'NULL')) AND
210: new_references.adm_appl_e_comp_perd_dt_alias IS NOT NULL) THEN
211: IF IGS_AD_VAL_SACCO.admp_val_sacco_da (
212: new_references.adm_appl_e_comp_perd_dt_alias,
213: 'ADM_APPL_E_COMP_PERD_DT_ALIAS',
214: v_message_name) = FALSE THEN
215: Fnd_Message.Set_Name('IGS',v_message_name);

Line 225: IF IGS_AD_VAL_SACCO.admp_val_sacco_da (

221: IF p_inserting OR
222: ((NVL(old_references.adm_appl_m_comp_perd_dt_alias, 'NULL') <>
223: NVL(new_references.adm_appl_m_comp_perd_dt_alias, 'NULL')) AND
224: new_references.adm_appl_m_comp_perd_dt_alias IS NOT NULL) THEN
225: IF IGS_AD_VAL_SACCO.admp_val_sacco_da (
226: new_references.adm_appl_m_comp_perd_dt_alias,
227: 'ADM_APPL_M_COMP_PERD_DT_ALIAS',
228: v_message_name) = FALSE THEN
229: Fnd_Message.Set_Name('IGS',v_message_name);

Line 239: IF IGS_AD_VAL_SACCO.admp_val_sacco_da (

235: IF p_inserting OR
236: ((NVL(old_references.adm_appl_s_comp_perd_dt_alias, 'NULL') <>
237: NVL(new_references.adm_appl_s_comp_perd_dt_alias, 'NULL')) AND
238: new_references.adm_appl_s_comp_perd_dt_alias IS NOT NULL) THEN
239: IF IGS_AD_VAL_SACCO.admp_val_sacco_da (
240: new_references.adm_appl_s_comp_perd_dt_alias,
241: 'ADM_APPL_S_COMP_PERD_DT_ALIAS',
242: v_message_name) = FALSE THEN
243: Fnd_Message.Set_Name('IGS',v_message_name);