DBA Data[Home] [Help]

APPS.IGS_RU_DESCRIPTION_PKG dependencies on APP_EXCEPTION

Line 42: App_Exception.Raise_Exception;

38: Close cur_old_ref_values;
39: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
40: IGS_RU_GEN_006.SET_TOKEN('IGS_RU_DESCRIPTION : P_ACTION INSERT, VALIDATE_INSERT : IGSUI03B.PLS');
41: IGS_GE_MSG_STACK.ADD;
42: App_Exception.Raise_Exception;
43: Return;
44: END IF;
45: Close cur_old_ref_values;
46:

Line 94: App_Exception.Raise_Exception;

90: v_message_name) = FALSE
91: THEN
92: Fnd_Message.Set_Name('IGS',v_message_name);
93: IGS_GE_MSG_STACK.ADD;
94: App_Exception.Raise_Exception;
95: END IF;
96: END IF;
97:
98:

Line 201: App_Exception.Raise_Exception ;

197: IF upper(Column_name) = 'S_RETURN_TYPE' OR COLUMN_NAME IS NULL THEN
198: IF new_references.S_RETURN_TYPE<> upper(new_references.S_RETURN_TYPE) then
199: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
200: IGS_GE_MSG_STACK.ADD;
201: App_Exception.Raise_Exception ;
202: END IF;
203:
204: END IF ;
205:

Line 210: App_Exception.Raise_Exception ;

206: IF upper(Column_name) = 'SEQUENCE_NUMBER' OR COLUMN_NAME IS NULL THEN
207: IF new_references.SEQUENCE_NUMBER < 0 or new_references.SEQUENCE_NUMBER > 999999 then
208: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
209: IGS_GE_MSG_STACK.ADD;
210: App_Exception.Raise_Exception ;
211: END IF;
212:
213: END IF ;
214:

Line 219: App_Exception.Raise_Exception ;

215: IF upper(Column_name) = 'PARENTHESIS_IND' OR COLUMN_NAME IS NULL THEN
216: IF new_references.PARENTHESIS_IND not in ('Y','N') then
217: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
218: IGS_GE_MSG_STACK.ADD;
219: App_Exception.Raise_Exception ;
220: END IF;
221:
222: END IF ;
223:

Line 240: App_Exception.Raise_Exception;

236: ) THEN
237: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
238: IGS_RU_GEN_006.SET_TOKEN('IGS_RU_RET_TYPE : P_ACTION Check_Parent_Existance new_references.s_return_type : IGSUI03B.PLS');
239: IGS_GE_MSG_STACK.ADD;
240: App_Exception.Raise_Exception;
241: END IF;
242: END IF;
243: IF (((old_references.s_turin_function = new_references.s_turin_function)) OR
244: ((new_references.s_turin_function IS NULL))) THEN

Line 253: App_Exception.Raise_Exception;

249: ) THEN
250: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
251: IGS_RU_GEN_006.SET_TOKEN('IGS_RU_TURIN_FNC : P_ACTION Check_Parent_Existance new_references.s_turin_function : IGSUI03B.PLS');
252: IGS_GE_MSG_STACK.ADD;
253: App_Exception.Raise_Exception;
254: END IF;
255: END IF;
256: END Check_Parent_Existance;
257:

Line 286: App_Exception.Raise_Exception;

282: new_references.rule_description
283: ) THEN
284: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
285: IGS_GE_MSG_STACK.ADD;
286: App_Exception.Raise_Exception;
287: END IF;
288:
289: END CHECK_UNIQUENESS ;
290:

Line 369: App_Exception.Raise_Exception;

365: IF (cur_rowid%FOUND) THEN
366: Close cur_rowid;
367: Fnd_Message.Set_Name ('IGS', 'IGS_RU_RUD_SRRT_FK');
368: IGS_GE_MSG_STACK.ADD;
369: App_Exception.Raise_Exception;
370: Return;
371: END IF;
372: Close cur_rowid;
373:

Line 395: App_Exception.Raise_Exception;

391: IF (cur_rowid%FOUND) THEN
392: Close cur_rowid;
393: Fnd_Message.Set_Name ('IGS', 'IGS_RU_RUD_STF_FK');
394: IGS_GE_MSG_STACK.ADD;
395: App_Exception.Raise_Exception;
396: Return;
397: END IF;
398: Close cur_rowid;
399:

Line 442: App_Exception.Raise_Exception;

438: new_references.sequence_number
439: ) THEN
440: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
441: IGS_GE_MSG_STACK.ADD;
442: App_Exception.Raise_Exception;
443: END IF;
444: Check_Uniqueness;
445: Check_Constraints;
446: Check_Parent_Existance;

Line 462: App_Exception.Raise_Exception;

458: new_references.sequence_number
459: ) THEN
460: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
461: IGS_GE_MSG_STACK.ADD;
462: App_Exception.Raise_Exception;
463: END IF;
464: check_uniqueness;
465: Check_Constraints;
466: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 545: app_exception.raise_exception;

541: end if;
542: else
543: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
544: IGS_GE_MSG_STACK.ADD;
545: app_exception.raise_exception;
546: end if;
547:
548: Before_DML(
549: p_action=>'INSERT',

Line 585: App_Exception.Raise_Exception ;

581: --
582: IF (l_sequence_number > 499999) THEN
583: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
584: IGS_GE_MSG_STACK.ADD;
585: App_Exception.Raise_Exception ;
586: END IF;
587: ELSE
588: l_sequence_number := NEW_REFERENCES.SEQUENCE_NUMBER;
589: END IF;

Line 657: app_exception.raise_exception;

653: close c1;
654: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
655: IGS_RU_GEN_006.SET_TOKEN('IGS_RU_DESCRIPTION : P_ACTION LOCK_ROW : IGSUI03B.PLS');
656: IGS_GE_MSG_STACK.ADD;
657: app_exception.raise_exception;
658: return;
659: end if;
660: close c1;
661:

Line 679: app_exception.raise_exception;

675: else
676: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
677: IGS_RU_GEN_006.SET_TOKEN('IGS_RU_DESCRIPTION : P_ACTION LOCK_ROW FORM_RECORD_CHANGED : IGSUI03B.PLS');
678: IGS_GE_MSG_STACK.ADD;
679: app_exception.raise_exception;
680: end if;
681: return;
682: end LOCK_ROW;
683:

Line 714: app_exception.raise_exception;

710: end if;
711: else
712: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
713: IGS_GE_MSG_STACK.ADD;
714: app_exception.raise_exception;
715: end if;
716:
717: Before_DML(
718: p_action=>'UPDATE',