DBA Data[Home] [Help]

APPS.IGS_EN_CPD_EXT_PKG dependencies on IGS_GE_MSG_STACK

Line 53: igs_ge_msg_stack.add;

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

Line 107: igs_ge_msg_stack.add;

103: new_references.s_student_comm_type
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;

Line 133: igs_ge_msg_stack.add;

129: ELSIF NOT igs_en_enrolment_cat_pkg.get_pk_for_validation (
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

Line 144: igs_ge_msg_stack.add;

140: ELSIF NOT igs_en_method_type_pkg.get_pk_for_validation (
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

Line 155: igs_ge_msg_stack.add;

151: ELSIF NOT igs_ru_call_pkg.get_pk_for_validation (
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

Line 166: igs_ge_msg_stack.add;

162: ELSIF NOT igs_ru_rule_pkg.get_pk_for_validation (
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: --*****

Line 179: Igs_Ge_Msg_Stack.Add;

175: ELSE
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:

Line 193: Igs_Ge_Msg_Stack.Add;

189: ELSE
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: --*****

Line 305: igs_ge_msg_stack.add;

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

Line 340: igs_ge_msg_stack.add;

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

Line 375: igs_ge_msg_stack.add;

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

Line 410: igs_ge_msg_stack.add;

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

Line 444: Igs_Ge_Msg_Stack.Add;

440: Open cur_rowid;
441: Fetch cur_rowid INTO lv_rowid;
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;

Line 476: Igs_Ge_Msg_Stack.Add;

472: Open cur_rowid;
473: Fetch cur_rowid INTO lv_rowid;
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;

Line 545: igs_ge_msg_stack.add;

541: new_references.igs_en_cpd_ext_id
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;

Line 561: igs_ge_msg_stack.add;

557: new_references.igs_en_cpd_ext_id
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

Line 715: igs_ge_msg_stack.add;

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

Line 842: igs_ge_msg_stack.add;

838: OPEN c1;
839: FETCH c1 INTO tlinfo;
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;

Line 863: igs_ge_msg_stack.add;

859: ) THEN
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;

Line 916: igs_ge_msg_stack.add;

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