DBA Data[Home] [Help]

APPS.IGS_PE_OFFICE_HRS_PKG dependencies on FND_MESSAGE

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

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

Line 119: FND_MESSAGE.SET_NAME('IGS','IGS_GE_TIME_OVERLAP');

115:
116: FETCH c_overlap INTO l_count;
117:
118: IF l_count > 0 THEN
119: FND_MESSAGE.SET_NAME('IGS','IGS_GE_TIME_OVERLAP');
120: IGS_GE_MSG_STACK.ADD;
121: APP_EXCEPTION.RAISE_EXCEPTION;
122: END IF;
123:

Line 156: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_ST_TIME_LT_END_TIME');

152: IF (new_references.start_tm_date <> NVL(old_references.start_tm_date,IGS_GE_DATE.IGSDATE('1900/01/01'))) OR
153: (new_references.end_tm_date <> NVL(old_references.end_tm_date,IGS_GE_DATE.IGSDATE('1900/01/01'))) THEN
154:
155: IF to_char(new_references.start_tm_date,'HH24:MI') >= to_char(new_references.end_tm_date,'HH24:MI') THEN
156: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_ST_TIME_LT_END_TIME');
157: IGS_GE_MSG_STACK.ADD;
158: APP_EXCEPTION.RAISE_EXCEPTION;
159: END IF;
160:

Line 225: FND_MESSAGE.SET_NAME ('FND', 'FORM_RECORD_DELETED');

221: OPEN check_cont_pref_cur;
222: FETCH check_cont_pref_cur into l_var;
223: IF check_cont_pref_cur%NOTFOUND THEN
224: CLOSE check_cont_pref_cur;
225: FND_MESSAGE.SET_NAME ('FND', 'FORM_RECORD_DELETED');
226: IGS_GE_MSG_STACK.ADD;
227: APP_EXCEPTION.RAISE_EXCEPTION;
228: END IF;
229: CLOSE check_cont_pref_cur;

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

288: validate_overlap(x_contact_preference_id,x_day_of_week_code, x_start_tm_date, x_end_tm_date,X_OFFICE_HRS_ID);
289:
290: IF ( get_pk_for_validation( new_references.office_hrs_id )
291: ) THEN
292: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
293: igs_ge_msg_stack.add;
294: app_exception.raise_exception;
295: END IF;
296: -- check valid cont pref

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

306:
307: -- Call all the procedures related to Before Insert.
308: IF ( get_pk_for_validation( new_references.office_hrs_id )
309: ) THEN
310: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
311: igs_ge_msg_stack.add;
312: app_exception.raise_exception;
313: END IF;
314:

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

382: IF (x_last_update_login IS NULL) THEN
383: x_last_update_login := -1;
384: END IF;
385: ELSE
386: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
387: fnd_message.set_token ('ROUTINE', 'IGS_PE_OFFICE_HRS_PKG.INSERT_ROW');
388: igs_ge_msg_stack.add;
389: app_exception.raise_exception;
390: END IF;

Line 387: fnd_message.set_token ('ROUTINE', 'IGS_PE_OFFICE_HRS_PKG.INSERT_ROW');

383: x_last_update_login := -1;
384: END IF;
385: ELSE
386: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
387: fnd_message.set_token ('ROUTINE', 'IGS_PE_OFFICE_HRS_PKG.INSERT_ROW');
388: igs_ge_msg_stack.add;
389: app_exception.raise_exception;
390: END IF;
391:

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

443:
444: EXCEPTION
445: WHEN OTHERS THEN
446: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
447: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
448: fnd_message.set_token ('ERR_CD', SQLCODE);
449: igs_ge_msg_stack.add;
450: igs_sc_gen_001.unset_ctx('R');
451: app_exception.raise_exception;

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

444: EXCEPTION
445: WHEN OTHERS THEN
446: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
447: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
448: fnd_message.set_token ('ERR_CD', SQLCODE);
449: igs_ge_msg_stack.add;
450: igs_sc_gen_001.unset_ctx('R');
451: app_exception.raise_exception;
452: ELSE

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

490:
491: OPEN c1;
492: FETCH c1 INTO tlinfo;
493: IF (c1%notfound) THEN
494: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
495: igs_ge_msg_stack.add;
496: CLOSE c1;
497: app_exception.raise_exception;
498: RETURN;

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

507: AND (tlinfo.end_tm_date = x_end_tm_date)
508: ) THEN
509: NULL;
510: ELSE
511: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
512: igs_ge_msg_stack.add;
513: app_exception.raise_exception;
514: END IF;
515:

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

555: IF (x_last_update_login IS NULL) THEN
556: x_last_update_login := -1;
557: END IF;
558: ELSE
559: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
560: fnd_message.set_token ('ROUTINE', 'IGS_PE_OFFICE_HRS_PKG.UPDATE_ROW');
561: igs_ge_msg_stack.add;
562: app_exception.raise_exception;
563: END IF;

Line 560: fnd_message.set_token ('ROUTINE', 'IGS_PE_OFFICE_HRS_PKG.UPDATE_ROW');

556: x_last_update_login := -1;
557: END IF;
558: ELSE
559: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
560: fnd_message.set_token ('ROUTINE', 'IGS_PE_OFFICE_HRS_PKG.UPDATE_ROW');
561: igs_ge_msg_stack.add;
562: app_exception.raise_exception;
563: END IF;
564:

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

594: last_update_login = x_last_update_login
595: WHERE rowid = x_rowid;
596:
597: IF (SQL%NOTFOUND) THEN
598: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
599: igs_ge_msg_stack.add;
600: igs_sc_gen_001.unset_ctx('R');
601: app_exception.raise_exception;
602: END IF;

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

609:
610: EXCEPTION
611: WHEN OTHERS THEN
612: IF (SQLCODE = (-28115)) THEN
613: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
614: fnd_message.set_token ('ERR_CD', SQLCODE);
615: igs_ge_msg_stack.add;
616: igs_sc_gen_001.unset_ctx('R');
617: app_exception.raise_exception;

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

610: EXCEPTION
611: WHEN OTHERS THEN
612: IF (SQLCODE = (-28115)) THEN
613: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
614: fnd_message.set_token ('ERR_CD', SQLCODE);
615: igs_ge_msg_stack.add;
616: igs_sc_gen_001.unset_ctx('R');
617: app_exception.raise_exception;
618: ELSE

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

704: DELETE FROM igs_pe_office_hrs
705: WHERE rowid = x_rowid;
706:
707: IF (SQL%NOTFOUND) THEN
708: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
709: igs_ge_msg_stack.add;
710: igs_sc_gen_001.unset_ctx('R');
711: app_exception.raise_exception;
712: END IF;

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

836:
837: OPEN c1;
838: FETCH c1 INTO tlinfo;
839: IF (c1%notfound) THEN
840: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
841: igs_ge_msg_stack.add;
842: CLOSE c1;
843: app_exception.raise_exception;
844: RETURN;

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

853: --AND (tlinfo.end_tm_date = x_end_tm_date)
854: ) THEN
855: NULL;
856: ELSE
857: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
858: igs_ge_msg_stack.add;
859: app_exception.raise_exception;
860: END IF;
861: