DBA Data[Home] [Help]

APPS.IGS_EN_CPD_EXT_PKG dependencies on APP_EXCEPTION

Line 54: app_exception.raise_exception;

50: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
51: CLOSE cur_old_ref_values;
52: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
53: igs_ge_msg_stack.add;
54: app_exception.raise_exception;
55: RETURN;
56: END IF;
57: CLOSE cur_old_ref_values;
58:

Line 108: app_exception.raise_exception;

104: )
105: ) THEN
106: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
107: igs_ge_msg_stack.add;
108: app_exception.raise_exception;
109: END IF;
110:
111: END check_uniqueness;
112:

Line 134: app_exception.raise_exception;

130: new_references.enrolment_cat
131: ) THEN
132: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
133: igs_ge_msg_stack.add;
134: app_exception.raise_exception;
135: END IF;
136:
137: IF (((old_references.enr_method_type = new_references.enr_method_type)) OR
138: ((new_references.enr_method_type IS NULL))) THEN

Line 145: app_exception.raise_exception;

141: new_references.enr_method_type
142: ) THEN
143: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
144: igs_ge_msg_stack.add;
145: app_exception.raise_exception;
146: END IF;
147:
148: IF (((old_references.s_rule_call_cd = new_references.s_rule_call_cd)) OR
149: ((new_references.s_rule_call_cd IS NULL))) THEN

Line 156: app_exception.raise_exception;

152: new_references.s_rule_call_cd
153: ) THEN
154: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
155: igs_ge_msg_stack.add;
156: app_exception.raise_exception;
157: END IF;
158:
159: IF (((old_references.rul_sequence_number = new_references.rul_sequence_number)) OR
160: ((new_references.rul_sequence_number IS NULL))) THEN

Line 167: app_exception.raise_exception;

163: new_references.rul_sequence_number
164: ) THEN
165: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
166: igs_ge_msg_stack.add;
167: app_exception.raise_exception;
168: END IF;
169:
170: --*****
171: IF (((old_references.s_student_comm_type =

Line 180: App_Exception.Raise_Exception;

176: IF NOT IGS_LOOKUPS_VIEW_Pkg.Get_PK_For_Validation ('VS_EN_COMMENCE',
177: new_references.s_student_comm_type) THEN
178: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
179: Igs_Ge_Msg_Stack.Add;
180: App_Exception.Raise_Exception;
181: END IF;
182: END IF;
183:
184:

Line 194: App_Exception.Raise_Exception;

190: IF NOT IGS_LOOKUPS_VIEW_Pkg.Get_PK_For_Validation ('ENROLMENT_STEP_TYPE_EXT',
191: new_references.s_enrolment_step_type) THEN
192: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
193: Igs_Ge_Msg_Stack.Add;
194: App_Exception.Raise_Exception;
195: END IF;
196: END IF;
197: --*****
198:

Line 306: app_exception.raise_exception;

302: IF (cur_rowid%FOUND) THEN
303: CLOSE cur_rowid;
304: fnd_message.set_name ('IGS', 'IGS_EN_CPDE_EC_FK');
305: igs_ge_msg_stack.add;
306: app_exception.raise_exception;
307: RETURN;
308: END IF;
309: CLOSE cur_rowid;
310:

Line 341: app_exception.raise_exception;

337: IF (cur_rowid%FOUND) THEN
338: CLOSE cur_rowid;
339: fnd_message.set_name ('IGS', 'IGS_EN_CPDE_EMT_FK');
340: igs_ge_msg_stack.add;
341: app_exception.raise_exception;
342: RETURN;
343: END IF;
344: CLOSE cur_rowid;
345:

Line 376: app_exception.raise_exception;

372: IF (cur_rowid%FOUND) THEN
373: CLOSE cur_rowid;
374: fnd_message.set_name ('IGS', 'IGS_EN_CPDE_SRC_FK');
375: igs_ge_msg_stack.add;
376: app_exception.raise_exception;
377: RETURN;
378: END IF;
379: CLOSE cur_rowid;
380:

Line 411: app_exception.raise_exception;

407: IF (cur_rowid%FOUND) THEN
408: CLOSE cur_rowid;
409: fnd_message.set_name ('IGS', 'IGS_EN_CPDE_RUL_FK');
410: igs_ge_msg_stack.add;
411: app_exception.raise_exception;
412: RETURN;
413: END IF;
414: CLOSE cur_rowid;
415:

Line 446: App_Exception.Raise_Exception;

442: IF (cur_rowid%FOUND) THEN
443: Fnd_Message.Set_Name ('IGS', 'IGS_EN_CPDE_LVAL_FK');
444: Igs_Ge_Msg_Stack.Add;
445: Close cur_rowid;
446: App_Exception.Raise_Exception;
447: Return;
448: END IF;
449: Close cur_rowid;
450: END get_fk_igs_lookups_view_1;

Line 478: App_Exception.Raise_Exception;

474: IF (cur_rowid%FOUND) THEN
475: Fnd_Message.Set_Name ('IGS', 'IGS_EN_CPDE_LVAL_FK');
476: Igs_Ge_Msg_Stack.Add;
477: Close cur_rowid;
478: App_Exception.Raise_Exception;
479: Return;
480: END IF;
481: Close cur_rowid;
482:

Line 546: app_exception.raise_exception;

542: )
543: ) THEN
544: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
545: igs_ge_msg_stack.add;
546: app_exception.raise_exception;
547: END IF;
548: check_uniqueness;
549: check_parent_existance;
550: ELSIF (p_action = 'UPDATE') THEN

Line 562: app_exception.raise_exception;

558: )
559: ) THEN
560: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
561: igs_ge_msg_stack.add;
562: app_exception.raise_exception;
563: END IF;
564: check_uniqueness;
565: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
566: check_uniqueness;

Line 716: app_exception.raise_exception;

712: END IF;
713: ELSE
714: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
715: igs_ge_msg_stack.add;
716: app_exception.raise_exception;
717: END IF;
718:
719: SELECT igs_en_cpd_ext_s.NEXTVAL
720: INTO x_igs_en_cpd_ext_id

Line 844: app_exception.raise_exception;

840: IF (c1%notfound) THEN
841: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
842: igs_ge_msg_stack.add;
843: CLOSE c1;
844: app_exception.raise_exception;
845: RETURN;
846: END IF;
847: CLOSE c1;
848:

Line 864: app_exception.raise_exception;

860: NULL;
861: ELSE
862: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
863: igs_ge_msg_stack.add;
864: app_exception.raise_exception;
865: END IF;
866:
867: RETURN;
868:

Line 917: app_exception.raise_exception;

913: END IF;
914: ELSE
915: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
916: igs_ge_msg_stack.add;
917: app_exception.raise_exception;
918: END IF;
919:
920: before_dml(
921: p_action => 'UPDATE',