DBA Data[Home] [Help]

APPS.IGS_FI_PARTY_VENDRS_PKG dependencies on APP_EXCEPTION

Line 47: app_exception.raise_exception;

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

Line 112: APP_EXCEPTION.RAISE_EXCEPTION;

108: CLOSE cur_party;
109: FND_MESSAGE.SET_NAME('FND',
110: 'FORM_RECORD_DELETED');
111: IGS_GE_MSG_STACK.Add;
112: APP_EXCEPTION.RAISE_EXCEPTION;
113: END IF;
114: END IF;
115:
116: IF ((old_references.vendor_id = new_references.vendor_id) OR

Line 129: APP_EXCEPTION.RAISE_EXCEPTION;

125: CLOSE cur_vendor;
126: FND_MESSAGE.SET_NAME('FND',
127: 'FORM_RECORD_DELETED');
128: IGS_GE_MSG_STACK.Add;
129: APP_EXCEPTION.RAISE_EXCEPTION;
130: END IF;
131: END IF;
132:
133: IF ((old_references.vendor_site_id = new_references.vendor_site_id) OR

Line 146: APP_EXCEPTION.RAISE_EXCEPTION;

142: CLOSE cur_vendor_site;
143: FND_MESSAGE.SET_NAME('FND',
144: 'FORM_RECORD_DELETED');
145: IGS_GE_MSG_STACK.Add;
146: APP_EXCEPTION.RAISE_EXCEPTION;
147: END IF;
148: END IF;
149: END check_parent_existence;
150:

Line 232: app_exception.raise_exception;

228: )
229: ) THEN
230: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
231: igs_ge_msg_stack.add;
232: app_exception.raise_exception;
233: END IF;
234: check_parent_existence;
235: ELSIF (p_action = 'VALIDATE_INSERT') THEN
236: -- Call all the procedures related to Before Insert.

Line 243: app_exception.raise_exception;

239: )
240: ) THEN
241: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
242: igs_ge_msg_stack.add;
243: app_exception.raise_exception;
244: END IF;
245: check_parent_existence;
246: ELSIF (p_action = 'UPDATE') THEN
247: Check_Parent_Existence;

Line 311: app_exception.raise_exception;

307: ELSE
308: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
309: fnd_message.set_token ('ROUTINE', 'IGS_FI_PARTY_VENDRS_PKG.INSERT_ROW');
310: igs_ge_msg_stack.add;
311: app_exception.raise_exception;
312: END IF;
313:
314: before_dml(
315: p_action => 'INSERT',

Line 391: app_exception.raise_exception;

387: IF (c1%notfound) THEN
388: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
389: igs_ge_msg_stack.add;
390: CLOSE c1;
391: app_exception.raise_exception;
392: RETURN;
393: END IF;
394: CLOSE c1;
395:

Line 404: app_exception.raise_exception;

400: NULL;
401: ELSE
402: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
403: igs_ge_msg_stack.add;
404: app_exception.raise_exception;
405: END IF;
406:
407: RETURN;
408:

Line 455: app_exception.raise_exception;

451: ELSE
452: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
453: fnd_message.set_token ('ROUTINE', 'IGS_FI_PARTY_VENDRS_PKG.UPDATE_ROW');
454: igs_ge_msg_stack.add;
455: app_exception.raise_exception;
456: END IF;
457:
458: before_dml(
459: p_action => 'UPDATE',