DBA Data[Home] [Help]

APPS.IGS_CO_OU_CO_PKG dependencies on APP_EXCEPTION

Line 61: app_exception.raise_exception;

57: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
58: CLOSE cur_old_ref_values;
59: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
60: igs_ge_msg_stack.add;
61: app_exception.raise_exception;
62: RETURN;
63: END IF;
64: CLOSE cur_old_ref_values;
65:

Line 121: app_exception.raise_exception;

117: IF NOT (new_references.reference_number BETWEEN 1
118: AND 999999) THEN
119: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
120: igs_ge_msg_stack.add;
121: app_exception.raise_exception;
122: END IF;
123: END IF;
124:
125: END check_constraints;

Line 156: app_exception.raise_exception;

152: IF (cur_rowid%FOUND) THEN
153: CLOSE cur_rowid;
154: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
155: igs_ge_msg_stack.add;
156: app_exception.raise_exception;
157: RETURN;
158: END IF;
159: CLOSE cur_rowid;
160:

Line 212: App_Exception.Raise_Exception;

208: new_references.unknown_return_dt,
209: v_message_name) = FALSE THEN
210: Fnd_Message.Set_Name('IGS',v_message_name);
211: IGS_GE_MSG_STACK.ADD;
212: App_Exception.Raise_Exception;
213: END IF;
214: END IF;
215:
216:

Line 329: app_exception.raise_exception;

325: )
326: ) THEN
327: fnd_message.set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
328: igs_ge_msg_stack.add;
329: app_exception.raise_exception;
330: END IF;
331: check_constraints;
332: ELSIF (p_action = 'UPDATE') THEN
333: -- Call all the procedures related to Before Update.

Line 350: app_exception.raise_exception;

346: )
347: ) THEN
348: fnd_message.set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
349: igs_ge_msg_stack.add;
350: app_exception.raise_exception;
351: END IF;
352: check_constraints;
353: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
354: check_constraints;

Line 433: app_exception.raise_exception;

429: END IF;
430: ELSE
431: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
432: igs_ge_msg_stack.add;
433: app_exception.raise_exception;
434: END IF;
435:
436: before_dml(
437: p_action => 'INSERT',

Line 562: app_exception.raise_exception;

558: IF (c1%notfound) THEN
559: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
560: igs_ge_msg_stack.add;
561: CLOSE c1;
562: app_exception.raise_exception;
563: RETURN;
564: END IF;
565: CLOSE c1;
566:

Line 581: app_exception.raise_exception;

577: NULL;
578: ELSE
579: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
580: igs_ge_msg_stack.add;
581: app_exception.raise_exception;
582: END IF;
583:
584: RETURN;
585:

Line 639: app_exception.raise_exception;

635: END IF;
636: ELSE
637: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
638: igs_ge_msg_stack.add;
639: app_exception.raise_exception;
640: END IF;
641:
642: before_dml(
643: p_action => 'UPDATE',

Line 800: App_Exception.Raise_Exception;

796: IF (cur_rowid%FOUND) THEN
797: Close cur_rowid;
798: Fnd_Message.Set_Name ('IGS', 'IGS_CO_OC_ADT_FK');
799: IGS_GE_MSG_STACK.ADD;
800: App_Exception.Raise_Exception;
801: Return;
802: END IF;
803: Close cur_rowid;
804:

Line 828: App_Exception.Raise_Exception;

824: IF (cur_rowid%FOUND) THEN
825: Close cur_rowid;
826: Fnd_Message.Set_Name ('IGS', 'IGS_CO_OC_CORI_FK');
827: IGS_GE_MSG_STACK.ADD;
828: App_Exception.Raise_Exception;
829: Return;
830: END IF;
831: Close cur_rowid;
832:

Line 854: App_Exception.Raise_Exception;

850: IF (cur_rowid%FOUND) THEN
851: Close cur_rowid;
852: Fnd_Message.Set_Name ('IGS', 'IGS_CO_OC_PE_FK');
853: IGS_GE_MSG_STACK.ADD;
854: App_Exception.Raise_Exception;
855: Return;
856: END IF;
857: Close cur_rowid;
858:

Line 880: App_Exception.Raise_Exception;

876: IF (cur_rowid%FOUND) THEN
877: Close cur_rowid;
878: Fnd_Message.Set_Name ('IGS', 'IGS_CO_OC_TRI_FK');
879: IGS_GE_MSG_STACK.ADD;
880: App_Exception.Raise_Exception;
881: Return;
882: END IF;
883: Close cur_rowid;
884: