APPS.IGS_PR_OU_AWD_PKG dependencies on APP_EXCEPTION

Line 48: app_exception.raise_exception;

44: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
45: CLOSE cur_old_ref_values;
46: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
47: igs_ge_msg_stack.add;
48: app_exception.raise_exception;
49: RETURN;
50: END IF;
51: CLOSE cur_old_ref_values;
52:

Line 94: app_exception.raise_exception;

90: new_references.award_cd
91: ) THEN
92: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
93: igs_ge_msg_stack.add;
94: app_exception.raise_exception;
95: END IF;
96:
97: IF (((old_references.progression_rule_cat = new_references.progression_rule_cat) AND
98: (old_references.pra_sequence_number = new_references.pra_sequence_number) AND

Line 111: app_exception.raise_exception;

107: new_references.pro_sequence_number
108: ) THEN
109: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
110: igs_ge_msg_stack.add;
111: app_exception.raise_exception;
112: END IF;
113:
114: END check_parent_existance;
115:

Line 189: app_exception.raise_exception;

185: IF (cur_rowid%FOUND) THEN
186: CLOSE cur_rowid;
187: fnd_message.set_name ('IGS', 'IGS_PR_POA_PRO_FK');
188: igs_ge_msg_stack.add;
189: app_exception.raise_exception;
190: RETURN;
191: END IF;
192: CLOSE cur_rowid;
193:

Line 227: APP_EXCEPTION.RAISE_EXCEPTION;

223: IF c_parent%NOTFOUND THEN
224: CLOSE c_parent;
225: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
226: IGS_GE_MSG_STACK.ADD;
227: APP_EXCEPTION.RAISE_EXCEPTION;
228: END IF;
229: CLOSE c_parent;
230: ELSIF(p_action = 'UPDATE') THEN
231: IF new_references.progression_rule_cat <> old_references.progression_rule_cat OR

Line 240: APP_EXCEPTION.RAISE_EXCEPTION;

236: IF c_parent%NOTFOUND THEN
237: CLOSE c_parent;
238: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
239: IGS_GE_MSG_STACK.ADD;
240: APP_EXCEPTION.RAISE_EXCEPTION;
241: END IF;
242: CLOSE c_parent;
243: END IF;
244: END IF;

Line 298: app_exception.raise_exception;

294: )
295: ) THEN
296: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
297: igs_ge_msg_stack.add;
298: app_exception.raise_exception;
299: END IF;
300: check_parent_existance;
301: ELSIF (p_action = 'UPDATE') THEN
302: -- Call all the procedures related to Before Update.

Line 315: app_exception.raise_exception;

311: )
312: ) THEN
313: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
314: igs_ge_msg_stack.add;
315: app_exception.raise_exception;
316: END IF;
317: END IF;
318:
319: -- anilk, bug#2784198

Line 372: app_exception.raise_exception;

368: END IF;
369: ELSE
370: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
371: igs_ge_msg_stack.add;
372: app_exception.raise_exception;
373: END IF;
374:
375: before_dml(
376: p_action => 'INSERT',

Line 460: app_exception.raise_exception;

456: END IF;
457: ELSE
458: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
459: igs_ge_msg_stack.add;
460: app_exception.raise_exception;
461: END IF;
462:
463: before_dml(
464: p_action => 'INSERT',

Line 585: app_exception.raise_exception;

581: IF (c1%notfound) THEN
582: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
583: igs_ge_msg_stack.add;
584: CLOSE c1;
585: app_exception.raise_exception;
586: RETURN;
587: END IF;
588: CLOSE c1;
589: