DBA Data[Home] [Help]

APPS.IGS_PR_OU_AWD_PKG dependencies on IGS_GE_MSG_STACK

Line 47: igs_ge_msg_stack.add;

43: FETCH cur_old_ref_values INTO old_references;
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;

Line 93: igs_ge_msg_stack.add;

89: ELSIF NOT igs_ps_awd_pkg.get_pk_for_validation (
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

Line 110: igs_ge_msg_stack.add;

106: new_references.pra_sequence_number,
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;

Line 188: igs_ge_msg_stack.add;

184: FETCH cur_rowid INTO lv_rowid;
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;

Line 226: IGS_GE_MSG_STACK.ADD;

222: FETCH c_parent INTO l_dummy;
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

Line 239: IGS_GE_MSG_STACK.ADD;

235: FETCH c_parent INTO l_dummy;
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;

Line 297: igs_ge_msg_stack.add;

293: new_references.award_cd
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

Line 314: igs_ge_msg_stack.add;

310: new_references.award_cd
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:

Line 371: igs_ge_msg_stack.add;

367: x_last_update_login := -1;
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(

Line 459: igs_ge_msg_stack.add;

455: x_last_update_login := -1;
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(

Line 583: igs_ge_msg_stack.add;

579: OPEN c1;
580: FETCH c1 INTO tlinfo;
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;