DBA Data[Home] [Help]

APPS.IGS_FI_FEE_TYPE_CI_H_PKG dependencies on IGS_GE_MSG_STACK

Line 113: IGS_GE_MSG_STACK.ADD;

109: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT')) THEN
110:
111: Close cur_old_ref_values;
112: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
113: IGS_GE_MSG_STACK.ADD;
114: App_Exception.Raise_Exception;
115:
116:
117: Return;

Line 242: IGS_GE_MSG_STACK.ADD;

238: column_name is NULL THEN
239: IF new_references.fee_ci_sequence_number < 1 OR
240: new_references.fee_ci_sequence_number > 999999 THEN
241: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
242: IGS_GE_MSG_STACK.ADD;
243: App_Exception.Raise_Exception;
244: END IF;
245: END IF;
246: IF upper(Column_Name) = 'START_DAI_SEQUENCE_NUMBER' OR

Line 251: IGS_GE_MSG_STACK.ADD;

247: column_name is NULL THEN
248: IF new_references.start_dai_sequence_number < 1 OR
249: new_references.start_dai_sequence_number > 999999 THEN
250: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
251: IGS_GE_MSG_STACK.ADD;
252: App_Exception.Raise_Exception;
253: END IF;
254: END IF;
255: IF upper(Column_Name) = 'END_DAI_SEQUENCE_NUMBER' OR

Line 260: IGS_GE_MSG_STACK.ADD;

256: column_name is NULL THEN
257: IF new_references.end_dai_sequence_number < 1 OR
258: new_references.end_dai_sequence_number > 999999 THEN
259: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
260: IGS_GE_MSG_STACK.ADD;
261: App_Exception.Raise_Exception;
262: END IF;
263: END IF;
264: IF upper(Column_Name) = 'RETRO_DAI_SEQUENCE_NUMBER' OR

Line 269: IGS_GE_MSG_STACK.ADD;

265: column_name is NULL THEN
266: IF new_references.retro_dai_sequence_number < 1 OR
267: new_references.retro_dai_sequence_number > 999999 THEN
268: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
269: IGS_GE_MSG_STACK.ADD;
270: App_Exception.Raise_Exception;
271: END IF;
272: END IF;
273: IF upper(Column_Name) = 'RUL_SEQUENCE_NUMBER' OR

Line 278: IGS_GE_MSG_STACK.ADD;

274: column_name is NULL THEN
275: IF new_references.rul_sequence_number < 1 OR
276: new_references.rul_sequence_number > 999999 THEN
277: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
278: IGS_GE_MSG_STACK.ADD;
279: App_Exception.Raise_Exception;
280: END IF;
281: END IF;
282: IF upper(Column_Name) = 'FEE_CAL_TYPE' OR

Line 286: IGS_GE_MSG_STACK.ADD;

282: IF upper(Column_Name) = 'FEE_CAL_TYPE' OR
283: column_name is NULL THEN
284: IF new_references.fee_cal_type <> UPPER(new_references.fee_cal_type) THEN
285: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
286: IGS_GE_MSG_STACK.ADD;
287: App_Exception.Raise_Exception;
288: END IF;
289: END IF;
290: IF upper(Column_Name) = 'END_DT_ALIAS' OR

Line 294: IGS_GE_MSG_STACK.ADD;

290: IF upper(Column_Name) = 'END_DT_ALIAS' OR
291: column_name is NULL THEN
292: IF new_references.end_dt_alias <> UPPER(new_references.end_dt_alias) THEN
293: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
294: IGS_GE_MSG_STACK.ADD;
295: App_Exception.Raise_Exception;
296: END IF;
297: END IF;
298: IF upper(Column_Name) = 'START_DT_ALIAS' OR

Line 302: IGS_GE_MSG_STACK.ADD;

298: IF upper(Column_Name) = 'START_DT_ALIAS' OR
299: column_name is NULL THEN
300: IF new_references.start_dt_alias <> UPPER(new_references.start_dt_alias) THEN
301: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
302: IGS_GE_MSG_STACK.ADD;
303: App_Exception.Raise_Exception;
304: END IF;
305: END IF;
306: IF upper(Column_Name) = 'RETRO_DT_ALIAS' OR

Line 310: IGS_GE_MSG_STACK.ADD;

306: IF upper(Column_Name) = 'RETRO_DT_ALIAS' OR
307: column_name is NULL THEN
308: IF new_references.retro_dt_alias <> UPPER(new_references.retro_dt_alias) THEN
309: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
310: IGS_GE_MSG_STACK.ADD;
311: App_Exception.Raise_Exception;
312: END IF;
313: END IF;
314:

Line 319: IGS_GE_MSG_STACK.ADD;

315: IF upper(Column_Name) = 'S_CHG_METHOD_TYPE' OR
316: column_name is NULL THEN
317: IF new_references.s_chg_method_type <> UPPER(new_references.s_chg_method_type) THEN
318: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
319: IGS_GE_MSG_STACK.ADD;
320: App_Exception.Raise_Exception;
321: END IF;
322: END IF;
323: IF upper(Column_Name) = 'INITIAL_DEFAULT_AMOUNT' OR

Line 328: IGS_GE_MSG_STACK.ADD;

324: column_name is NULL THEN
325: IF new_references.initial_default_amount < 1 OR
326: new_references.initial_default_amount > 999999.99 THEN
327: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
328: IGS_GE_MSG_STACK.ADD;
329: App_Exception.Raise_Exception;
330: END IF;
331: END IF;
332: IF upper(Column_Name) = 'NONZERO_BILLABLE_CP_FLAG' OR

Line 336: IGS_GE_MSG_STACK.ADD;

332: IF upper(Column_Name) = 'NONZERO_BILLABLE_CP_FLAG' OR
333: column_name is NULL THEN
334: IF new_references.nonzero_billable_cp_flag <> UPPER(new_references.nonzero_billable_cp_flag) THEN
335: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
336: IGS_GE_MSG_STACK.ADD;
337: App_Exception.Raise_Exception;
338: END IF;
339: END IF;
340:

Line 344: IGS_GE_MSG_STACK.ADD;

340:
341: IF ((UPPER (column_name) = 'SCOPE_RUL_SEQUENCE_NUM') OR (column_name IS NULL)) THEN
342: IF ((new_references.scope_rul_sequence_num < 1) OR (new_references.scope_rul_sequence_num > 999999)) THEN
343: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
344: IGS_GE_MSG_STACK.ADD;
345: App_Exception.Raise_Exception;
346: END IF;
347: END IF;
348:

Line 352: IGS_GE_MSG_STACK.ADD;

348:
349: IF ((UPPER (column_name) = 'ELM_RNG_ORDER_NAME') OR (column_name IS NULL)) THEN
350: IF (new_references.elm_rng_order_name <> UPPER (new_references.elm_rng_order_name)) THEN
351: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
352: IGS_GE_MSG_STACK.ADD;
353: App_Exception.Raise_Exception;
354: END IF;
355: END IF;
356:

Line 528: IGS_GE_MSG_STACK.ADD;

524: new_references.fee_ci_sequence_number ,
525: new_references.hist_start_dt )
526: THEN
527: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
528: IGS_GE_MSG_STACK.ADD;
529: App_Exception.Raise_Exception;
530: END IF;
531: Check_Constraints;
532: ELSIF (p_action = 'UPDATE') THEN

Line 543: IGS_GE_MSG_STACK.ADD;

539: new_references.fee_ci_sequence_number ,
540: new_references.hist_start_dt )
541: THEN
542: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
543: IGS_GE_MSG_STACK.ADD;
544: App_Exception.Raise_Exception;
545: END IF;
546: Check_Constraints;
547: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 615: IGS_GE_MSG_STACK.ADD;

611: X_LAST_UPDATE_LOGIN := -1;
612: end if;
613: else
614: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
615: IGS_GE_MSG_STACK.ADD;
616: app_exception.raise_exception;
617: end if;
618:
619:

Line 799: IGS_GE_MSG_STACK.ADD;

795: fetch c1 into tlinfo;
796: if (c1%notfound) then
797: close c1;
798: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
799: IGS_GE_MSG_STACK.ADD;
800: app_exception.raise_exception;
801: return;
802: end if;
803: close c1;

Line 848: IGS_GE_MSG_STACK.ADD;

844: ) then
845: null;
846: else
847: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
848: IGS_GE_MSG_STACK.ADD;
849: app_exception.raise_exception;
850: end if;
851: return;
852: end LOCK_ROW;

Line 908: IGS_GE_MSG_STACK.ADD;

904: X_LAST_UPDATE_LOGIN := -1;
905: end if;
906: else
907: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
908: IGS_GE_MSG_STACK.ADD;
909: app_exception.raise_exception;
910: end if;
911:
912: