DBA Data[Home] [Help]

APPS.IGS_FI_FEE_TYPE_CI_H_PKG dependencies on APP_EXCEPTION

Line 114: App_Exception.Raise_Exception;

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;
118:

Line 243: App_Exception.Raise_Exception;

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
247: column_name is NULL THEN

Line 252: App_Exception.Raise_Exception;

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
256: column_name is NULL THEN

Line 261: App_Exception.Raise_Exception;

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
265: column_name is NULL THEN

Line 270: App_Exception.Raise_Exception;

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
274: column_name is NULL THEN

Line 279: App_Exception.Raise_Exception;

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
283: column_name is NULL THEN

Line 287: App_Exception.Raise_Exception;

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
291: column_name is NULL THEN

Line 295: App_Exception.Raise_Exception;

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
299: column_name is NULL THEN

Line 303: App_Exception.Raise_Exception;

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
307: column_name is NULL THEN

Line 311: App_Exception.Raise_Exception;

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:
315: IF upper(Column_Name) = 'S_CHG_METHOD_TYPE' OR

Line 320: App_Exception.Raise_Exception;

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
324: column_name is NULL THEN

Line 329: App_Exception.Raise_Exception;

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
333: column_name is NULL THEN

Line 337: App_Exception.Raise_Exception;

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:
341: IF ((UPPER (column_name) = 'SCOPE_RUL_SEQUENCE_NUM') OR (column_name IS NULL)) THEN

Line 345: App_Exception.Raise_Exception;

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:
349: IF ((UPPER (column_name) = 'ELM_RNG_ORDER_NAME') OR (column_name IS NULL)) THEN

Line 353: App_Exception.Raise_Exception;

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:
357: END Check_Constraints;

Line 529: App_Exception.Raise_Exception;

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
533: -- Call all the procedures related to Before Update.

Line 544: App_Exception.Raise_Exception;

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
548: Check_Constraints;

Line 616: app_exception.raise_exception;

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:
620: Before_DML(

Line 800: app_exception.raise_exception;

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;
804:

Line 849: app_exception.raise_exception;

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;
853:

Line 909: app_exception.raise_exception;

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:
913: