DBA Data[Home] [Help]

APPS.IGS_AD_HZ_EXTRACURR_ACT_PKG dependencies on FND_MESSAGE

Line 48: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');

44: OPEN cur_old_ref_values;
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;

Line 102: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');

98: ELSE
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;

Line 117: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');

113: ELSIF NOT IGS_LOOKUPS_VIEW_PKG.Get_PK_For_Validation(
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:

Line 183: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');

179: OPEN cur_rowid;
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;

Line 242: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');

238: IF ( get_pk_for_validation(
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;

Line 262: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');

258: IF ( get_pk_for_validation (
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;

Line 331: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');

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

Line 406: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');

402:
403: EXCEPTION
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;

Line 407: fnd_message.set_token ('ERR_CD', SQLCODE);

403: EXCEPTION
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

Line 455: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

451:
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;

Line 473: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');

469: AND ((tlinfo.activity_source_cd = x_activity_source_cd) OR ((tlinfo.activity_source_cd IS NULL) AND (x_activity_source_cd IS NULL)))
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:

Line 541: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');

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

Line 583: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');

579: program_id = x_program_id
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;

Line 597: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');

593:
594: EXCEPTION
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;

Line 598: fnd_message.set_token ('ERR_CD', SQLCODE);

594: EXCEPTION
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

Line 695: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');

691: DELETE FROM igs_ad_hz_extracurr_act
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;

Line 744: Fnd_Message.Set_Name('IGS','IGS_AD_HRS_PER_WEEK');

740: IF UPPER(Column_Name) = 'HOURS_PER_WEEK' OR
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;

Line 755: Fnd_Message.Set_Name('IGS','IGS_AD_WKS_PER_YEAR');

751: IF UPPER(Column_Name) = 'WEEKS_PER_YEAR' OR
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;