DBA Data[Home] [Help]

APPS.IGS_AD_HZ_EXTRACURR_ACT_PKG dependencies on IGS_GE_MSG_STACK

Line 49: igs_ge_msg_stack.ADD;

45: FETCH cur_old_ref_values INTO old_references;
46: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
47: CLOSE cur_old_ref_values;
48: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
49: igs_ge_msg_stack.ADD;
50: app_exception.raise_exception;
51: RETURN;
52: END IF;
53: CLOSE cur_old_ref_values;

Line 103: IGS_GE_MSG_STACK.ADD;

99: OPEN cur_rowid;
100: FETCH cur_rowid INTO lv_rowid;
101: IF (cur_rowid%NOTFOUND) THEN
102: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
103: IGS_GE_MSG_STACK.ADD;
104: App_Exception.Raise_Exception;
105: END IF;
106: CLOSE cur_rowid;
107:

Line 118: IGS_GE_MSG_STACK.ADD;

114: 'ACTIVITY_SOURCE',
115: new_references.activity_source_cd
116: )THEN
117: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
118: IGS_GE_MSG_STACK.ADD;
119: App_Exception.Raise_Exception;
120: END IF;
121:
122: END check_parent_existance;

Line 184: igs_ge_msg_stack.ADD;

180: FETCH cur_rowid INTO lv_rowid;
181: IF (cur_rowid%FOUND) THEN
182: CLOSE cur_rowid;
183: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
184: igs_ge_msg_stack.ADD;
185: app_exception.raise_exception;
186: RETURN;
187: END IF;
188: CLOSE cur_rowid;

Line 243: igs_ge_msg_stack.ADD;

239: new_references.hz_extracurr_act_id
240: )
241: ) THEN
242: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
243: igs_ge_msg_stack.ADD;
244: app_exception.raise_exception;
245: END IF;
246: check_constraints;
247: check_parent_existance;

Line 263: igs_ge_msg_stack.ADD;

259: new_references.hz_extracurr_act_id
260: )
261: ) THEN
262: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
263: igs_ge_msg_stack.ADD;
264: app_exception.raise_exception;
265: END IF;
266: check_constraints;
267: END IF;

Line 332: igs_ge_msg_stack.ADD;

328: x_program_update_date:=SYSDATE;
329: END IF;
330: ELSE
331: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
332: igs_ge_msg_stack.ADD;
333: app_exception.raise_exception;
334: END IF;
335:
336: X_HZ_EXTRACURR_ACT_ID := -1;

Line 408: igs_ge_msg_stack.add;

404: WHEN OTHERS THEN
405: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
406: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
407: fnd_message.set_token ('ERR_CD', SQLCODE);
408: igs_ge_msg_stack.add;
409: igs_sc_gen_001.unset_ctx('R');
410: app_exception.raise_exception;
411: ELSE
412: igs_sc_gen_001.unset_ctx('R');

Line 456: igs_ge_msg_stack.ADD;

452: OPEN c1;
453: FETCH c1 INTO tlinfo;
454: IF (c1%NOTFOUND) THEN
455: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
456: igs_ge_msg_stack.ADD;
457: CLOSE c1;
458: app_exception.raise_exception;
459: RETURN;
460: END IF;

Line 474: igs_ge_msg_stack.ADD;

470: ) THEN
471: NULL;
472: ELSE
473: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
474: igs_ge_msg_stack.ADD;
475: app_exception.raise_exception;
476: END IF;
477:
478: RETURN;

Line 542: igs_ge_msg_stack.ADD;

538: x_program_update_date:=SYSDATE;
539: END IF;
540: ELSE
541: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
542: igs_ge_msg_stack.ADD;
543: app_exception.raise_exception;
544: END IF;
545:
546: before_dml(

Line 584: igs_ge_msg_stack.add;

580: WHERE ROWID = x_rowid;
581:
582: IF (SQL%NOTFOUND) THEN
583: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
584: igs_ge_msg_stack.add;
585: igs_sc_gen_001.unset_ctx('R');
586: app_exception.raise_exception;
587: END IF;
588: IF (x_mode = 'S') THEN

Line 599: igs_ge_msg_stack.add;

595: WHEN OTHERS THEN
596: IF (SQLCODE = (-28115)) THEN
597: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
598: fnd_message.set_token ('ERR_CD', SQLCODE);
599: igs_ge_msg_stack.add;
600: igs_sc_gen_001.unset_ctx('R');
601: app_exception.raise_exception;
602: ELSE
603: igs_sc_gen_001.unset_ctx('R');

Line 696: igs_ge_msg_stack.add;

692: WHERE ROWID = x_rowid;
693:
694: IF (SQL%NOTFOUND) THEN
695: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
696: igs_ge_msg_stack.add;
697: igs_sc_gen_001.unset_ctx('R');
698: app_exception.raise_exception;
699: END IF;
700: IF (x_mode = 'S') THEN

Line 745: IGS_GE_MSG_STACK.ADD;

741: Column_Name IS NULL THEN
742: IF NOT (new_references.hours_per_week >= 0
743: AND new_references.hours_per_week <= 168 ) THEN
744: Fnd_Message.Set_Name('IGS','IGS_AD_HRS_PER_WEEK');
745: IGS_GE_MSG_STACK.ADD;
746: App_Exception.Raise_Exception;
747: END IF;
748: END IF;
749:

Line 756: IGS_GE_MSG_STACK.ADD;

752: Column_Name IS NULL THEN
753: IF NOT (new_references.weeks_per_year >= 0
754: AND new_references.weeks_per_year <= 52 ) THEN
755: Fnd_Message.Set_Name('IGS','IGS_AD_WKS_PER_YEAR');
756: IGS_GE_MSG_STACK.ADD;
757: App_Exception.Raise_Exception;
758: END IF;
759: END IF;
760: