APPS.IGS_PR_RULE_PKG dependencies on APP_EXCEPTION

Line 42: App_Exception.Raise_Exception;

38: IF (cur_old_ref_values%NOTFOUND) AND (p_action not in ('INSERT','VALIDATE_INSERT')) THEN
39: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
40: IGS_GE_MSG_STACK.ADD;
41: Close cur_old_ref_values;
42: App_Exception.Raise_Exception;
43: Return;
44: END IF;
45: Close cur_old_ref_values;
46:

Line 91: App_Exception.Raise_Exception;

87: new_references.progression_rule_cat,
88: v_message_name) = FALSE THEN
89: Fnd_Message.Set_Name('IGS',v_message_name);
90: IGS_GE_MSG_STACK.ADD;
91: App_Exception.Raise_Exception;
92: END IF;
93: END IF;
94:
95:

Line 110: App_Exception.Raise_Exception;

106: ) THEN
107:
108: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
109: IGS_GE_MSG_STACK.ADD;
110: App_Exception.Raise_Exception;
111:
112: END IF;
113: END IF;
114:

Line 124: App_Exception.Raise_Exception;

120: new_references.rul_sequence_number
121: ) THEN
122: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
123: IGS_GE_MSG_STACK.ADD;
124: App_Exception.Raise_Exception;
125:
126: END IF;
127: END IF;
128:

Line 188: App_Exception.Raise_Exception;

184: IF (cur_rowid%FOUND) THEN
185: Fnd_Message.Set_Name ('IGS', 'IGS_PR_PRR_PRGC_FK');
186: IGS_GE_MSG_STACK.ADD;
187: Close cur_rowid;
188: App_Exception.Raise_Exception;
189: Return;
190: END IF;
191: Close cur_rowid;
192:

Line 214: App_Exception.Raise_Exception;

210: IF (cur_rowid%FOUND) THEN
211: Fnd_Message.Set_Name ('IGS', 'IGS_PR_PRR_RUL_FK');
212: IGS_GE_MSG_STACK.ADD;
213: Close cur_rowid;
214: App_Exception.Raise_Exception;
215: Return;
216: END IF;
217: Close cur_rowid;
218:

Line 267: App_Exception.Raise_Exception;

263: new_references.progression_rule_cd
264: ) THEN
265: Fnd_Message.Set_Name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
266: IGS_GE_MSG_STACK.ADD;
267: App_Exception.Raise_Exception;
268:
269: END IF;
270: CHECK_CONSTRAINTS;
271: ELSIF (p_action = 'UPDATE') THEN

Line 286: App_Exception.Raise_Exception;

282: new_references.progression_rule_cd
283: ) THEN
284: Fnd_Message.Set_Name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
285: IGS_GE_MSG_STACK.ADD;
286: App_Exception.Raise_Exception;
287:
288: END IF;
289: CHECK_CONSTRAINTS;
290: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 336: app_exception.raise_exception;

332: end if;
333: else
334: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
335: IGS_GE_MSG_STACK.ADD;
336: app_exception.raise_exception;
337: end if;
338: Before_DML (
339: p_action => 'INSERT',
340: x_rowid => x_rowid,

Line 416: app_exception.raise_exception;

412: if (c1%notfound) then
413: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
414: IGS_GE_MSG_STACK.ADD;
415: close c1;
416: app_exception.raise_exception;
417: return;
418: end if;
419: close c1;
420:

Line 432: app_exception.raise_exception;

428: null;
429: else
430: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
431: IGS_GE_MSG_STACK.ADD;
432: app_exception.raise_exception;
433: end if;
434: return;
435: end LOCK_ROW;
436:

Line 467: app_exception.raise_exception;

463: end if;
464: else
465: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
466: IGS_GE_MSG_STACK.ADD;
467: app_exception.raise_exception;
468: end if;
469: Before_DML (
470: p_action => 'UPDATE',
471: x_rowid => x_rowid,

Line 585: App_Exception.Raise_Exception ;

581: IF upper(Column_name) = 'CLOSED_IND' OR COLUMN_NAME IS NULL THEN
582: IF new_references.CLOSED_IND not in ('Y','N') 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: END IF ;
588:
589: IF upper(Column_name) = 'PROGRESSION_RULE_CAT' OR COLUMN_NAME IS NULL THEN

Line 593: App_Exception.Raise_Exception ;

589: IF upper(Column_name) = 'PROGRESSION_RULE_CAT' OR COLUMN_NAME IS NULL THEN
590: IF new_references.PROGRESSION_RULE_CAT<> upper(new_references.PROGRESSION_RULE_CAT) then
591: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
592: IGS_GE_MSG_STACK.ADD;
593: App_Exception.Raise_Exception ;
594: END IF;
595:
596: END IF ;
597:

Line 602: App_Exception.Raise_Exception ;

598: IF (Column_name) = 'PROGRESSION_RULE_CD' OR COLUMN_NAME IS NULL THEN
599: IF new_references.PROGRESSION_RULE_CD<> (new_references.PROGRESSION_RULE_CD) then
600: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
601: IGS_GE_MSG_STACK.ADD;
602: App_Exception.Raise_Exception ;
603: END IF;
604:
605: END IF ;
606: