eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_EN_UNIT_SET_PKG dependencies on FND_MESSAGE

Line 40: fnd_message.set_name('IGS','IGS_PS_UNIT_SET_NO_DEL_ALLOWED');

36: OPEN cur_delete (old_references.unit_set_cd,old_references.version_number);
37: FETCH cur_delete INTO l_check;
38: IF cur_delete%NOTFOUND THEN
39: CLOSE cur_delete;
40: fnd_message.set_name('IGS','IGS_PS_UNIT_SET_NO_DEL_ALLOWED');
41: igs_ge_msg_stack.add;
42: app_exception.raise_exception;
43: END IF;
44: CLOSE cur_delete;

Line 91: fnd_message.set_name('IGS','IGS_PS_UNIT_SET_STATUS_NOTALT');

87: OPEN cur_check_update(old_references.unit_set_cd,old_references.version_number);
88: FETCH cur_check_update INTO l_check;
89: IF cur_check_update%FOUND THEN
90: CLOSE cur_check_update;
91: fnd_message.set_name('IGS','IGS_PS_UNIT_SET_STATUS_NOTALT');
92: igs_ge_msg_stack.add;
93: app_exception.raise_exception;
94: END IF;
95: CLOSE cur_check_update;

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

96: END IF;
97: ELSE
98: -- If the unit set status is not found then the record might have been deleted
99: CLOSE cur_get_status;
100: fnd_message.set_name('FND','FORM_RECORD_DELETED');
101: igs_ge_msg_stack.add;
102: app_exception.raise_exception;
103: END IF;
104: END beforerowupdate;

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

163: -- Populate Old Values.
164: Open cur_old_ref_values;
165: Fetch cur_old_ref_values INTO old_references;
166: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT')) THEN
167: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
168: IGS_GE_MSG_STACK.ADD;
169: Close cur_old_ref_values;
170: App_Exception.Raise_Exception;
171: Return;

Line 250: Fnd_Message.Set_Name('IGS', v_message_name);

246: IF IGS_PS_VAL_CRV.crsp_val_ou_sys_sts (
247: new_references.responsible_org_unit_cd,
248: new_references.responsible_ou_start_dt,
249: v_message_name) = FALSE THEN
250: Fnd_Message.Set_Name('IGS', v_message_name);
251: IGS_GE_MSG_STACK.ADD;
252: App_Exception.Raise_Exception;
253: END IF;
254: --

Line 259: Fnd_Message.Set_Name('IGS', v_message_name);

255: -- UNIT set status closed validation
256: IF IGS_PS_VAL_US.crsp_val_uss_closed (
257: new_references.unit_set_status,
258: v_message_name) = FALSE THEN
259: Fnd_Message.Set_Name('IGS', v_message_name);
260: IGS_GE_MSG_STACK.ADD;
261: App_Exception.Raise_Exception;
262: END IF;
263: --

Line 268: Fnd_Message.Set_Name('IGS', v_message_name);

264: -- UNIT set category closed validation
265: IF IGS_PS_VAL_US.crsp_val_usc_closed (
266: new_references.UNIT_SET_CAT,
267: v_message_name) = FALSE THEN
268: Fnd_Message.Set_Name('IGS', v_message_name);
269: IGS_GE_MSG_STACK.ADD;
270: App_Exception.Raise_Exception;
271: END IF;
272: END IF;

Line 282: Fnd_Message.Set_Name('IGS', v_message_name);

278: new_references.start_dt,
279: new_references.end_dt,
280: new_references.expiry_dt,
281: v_message_name,FALSE) = FALSE THEN
282: Fnd_Message.Set_Name('IGS', v_message_name);
283: IGS_GE_MSG_STACK.ADD;
284: App_Exception.Raise_Exception;
285: END IF;
286: --

Line 292: Fnd_Message.Set_Name('IGS', v_message_name);

288: IF IGS_PS_VAL_US.crsp_val_us_end_sts (
289: new_references.end_dt,
290: new_references.unit_set_status,
291: v_message_name) = FALSE THEN
292: Fnd_Message.Set_Name('IGS', v_message_name);
293: IGS_GE_MSG_STACK.ADD;
294: App_Exception.Raise_Exception;
295: END IF;
296: --

Line 304: Fnd_Message.Set_Name('IGS', v_message_name);

300: IF IGS_PS_VAL_US.crsp_val_us_enr (
301: new_references.unit_set_cd,
302: new_references.version_number,
303: v_message_name) = FALSE THEN
304: Fnd_Message.Set_Name('IGS', v_message_name);
305: IGS_GE_MSG_STACK.ADD;
306: App_Exception.Raise_Exception;
307: END IF;
308: END IF;

Line 315: Fnd_Message.Set_Name('IGS', v_message_name);

311: IF IGS_PS_VAL_US.crsp_val_us_status (
312: old_references.unit_set_status,
313: new_references.unit_set_status,
314: v_message_name) = FALSE THEN
315: Fnd_Message.Set_Name('IGS', v_message_name);
316: IGS_GE_MSG_STACK.ADD;
317: App_Exception.Raise_Exception;
318: END IF;
319: --

Line 328: Fnd_Message.Set_Name('IGS', v_message_name);

324: IF IGS_PS_VAL_COUSR.crsp_val_iud_us_dtl (
325: new_references.unit_set_cd,
326: new_references.version_number,
327: v_message_name) = FALSE THEN
328: Fnd_Message.Set_Name('IGS', v_message_name);
329: IGS_GE_MSG_STACK.ADD;
330: App_Exception.Raise_Exception;
331: END IF;
332: END IF;

Line 356: Fnd_Message.Set_Name('IGS', v_message_name);

352: New_References.version_number,
353: New_References.unit_set_status,
354: New_References.expiry_dt,
355: v_message_name) = FALSE THEN
356: Fnd_Message.Set_Name('IGS', v_message_name);
357: IGS_GE_MSG_STACK.ADD;
358: App_Exception.Raise_Exception;
359: END IF;
360:

Line 448: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');

444:
445:
446: IF ((UPPER (column_name) = 'ADMINISTRATIVE_IND') OR (column_name IS NULL)) THEN
447: IF new_references.administrative_ind NOT IN ('Y' , 'N' ) THEN
448: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
449: IGS_GE_MSG_STACK.ADD;
450: App_Exception.Raise_Exception;
451: END IF;
452: END IF;

Line 458: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');

454:
455: IF ((UPPER (column_name) = 'VERSION_NUMBER') OR (column_name IS NULL)) THEN
456: IF new_references.version_number < 1 OR
457: new_references.version_number > 999 THEN
458: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
459: IGS_GE_MSG_STACK.ADD;
460: App_Exception.Raise_Exception;
461: END IF;
462: END IF;

Line 467: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');

463:
464:
465: IF ((UPPER (column_name) = 'AUTHORISATION_RQRD_IND') OR (column_name IS NULL)) THEN
466: IF (new_references.authorisation_rqrd_ind <> UPPER (new_references.authorisation_rqrd_ind)) THEN
467: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
468: IGS_GE_MSG_STACK.ADD;
469: App_Exception.Raise_Exception;
470: END IF;
471: END IF;

Line 476: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');

472:
473:
474: IF ((UPPER (column_name) = 'ABBREVIATION') OR (column_name IS NULL)) THEN
475: IF (new_references.abbreviation <> UPPER (new_references.abbreviation)) THEN
476: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
477: IGS_GE_MSG_STACK.ADD;
478: App_Exception.Raise_Exception;
479: END IF;
480: END IF;

Line 484: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');

480: END IF;
481:
482: IF ((UPPER (column_name) = 'UNIT_SET_CAT') OR (column_name IS NULL)) THEN
483: IF (new_references.UNIT_SET_CAT <> UPPER (new_references.UNIT_SET_CAT)) THEN
484: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
485: IGS_GE_MSG_STACK.ADD;
486: App_Exception.Raise_Exception;
487: END IF;
488: END IF;

Line 493: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');

489:
490:
491: IF ((UPPER (column_name) = 'UNIT_SET_CD') OR (column_name IS NULL)) THEN
492: IF (new_references.unit_set_cd <> UPPER (new_references.unit_set_cd)) THEN
493: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
494: IGS_GE_MSG_STACK.ADD;
495: App_Exception.Raise_Exception;
496: END IF;
497: END IF;

Line 501: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');

497: END IF;
498:
499: IF ((UPPER (column_name) = 'UNIT_SET_STATUS') OR (column_name IS NULL)) THEN
500: IF (new_references.UNIT_SET_STATUS <> UPPER (new_references.UNIT_SET_STATUS)) THEN
501: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
502: IGS_GE_MSG_STACK.ADD;
503: App_Exception.Raise_Exception;
504: END IF;
505: END IF;

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

521: new_references.responsible_org_unit_cd,
522: new_references.responsible_ou_start_dt
523: ) THEN
524:
525: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
526: IGS_GE_MSG_STACK.ADD;
527: App_Exception.Raise_Exception;
528:
529: END IF;

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

538: IF NOT IGS_EN_UNIT_SET_CAT_PKG.Get_PK_For_Validation (
539: new_references.UNIT_SET_CAT
540: ) THEN
541:
542: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
543: IGS_GE_MSG_STACK.ADD;
544: App_Exception.Raise_Exception;
545:
546: END IF;

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

554: IF NOT IGS_EN_UNIT_SET_STAT_PKG.Get_PK_For_Validation (
555: new_references.UNIT_SET_STATUS
556: ) THEN
557:
558: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
559: IGS_GE_MSG_STACK.ADD;
560: App_Exception.Raise_Exception;
561:
562: END IF;

Line 778: Fnd_Message.Set_Name ('IGS', 'IGS_EN_US_OU_FK');

774:
775: Open cur_rowid;
776: Fetch cur_rowid INTO lv_rowid;
777: IF (cur_rowid%FOUND) THEN
778: Fnd_Message.Set_Name ('IGS', 'IGS_EN_US_OU_FK');
779: IGS_GE_MSG_STACK.ADD;
780: Close cur_rowid;
781: App_Exception.Raise_Exception;
782: Return;

Line 804: Fnd_Message.Set_Name ('IGS', 'IGS_EN_US_USC_FK');

800:
801: Open cur_rowid;
802: Fetch cur_rowid INTO lv_rowid;
803: IF (cur_rowid%FOUND) THEN
804: Fnd_Message.Set_Name ('IGS', 'IGS_EN_US_USC_FK');
805: IGS_GE_MSG_STACK.ADD;
806: Close cur_rowid;
807: App_Exception.Raise_Exception;
808: Return;

Line 830: Fnd_Message.Set_Name ('IGS', 'IGS_EN_US_USS_FK');

826:
827: Open cur_rowid;
828: Fetch cur_rowid INTO lv_rowid;
829: IF (cur_rowid%FOUND) THEN
830: Fnd_Message.Set_Name ('IGS', 'IGS_EN_US_USS_FK');
831: IGS_GE_MSG_STACK.ADD;
832: Close cur_rowid;
833: App_Exception.Raise_Exception;
834: Return;

Line 943: Fnd_message.Set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');

939: new_references.unit_set_cd,
940: new_references.version_number
941: ) THEN
942:
943: Fnd_message.Set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
944: IGS_GE_MSG_STACK.ADD;
945: App_Exception.Raise_Exception;
946:
947: END IF;

Line 968: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');

964: IF Get_PK_For_Validation (
965: new_references.unit_set_cd,
966: new_references.version_number
967: ) THEN
968: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
969: IGS_GE_MSG_STACK.ADD;
970: App_Exception.Raise_Exception;
971: END IF;
972: Check_Constraints;

Line 1070: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');

1066: if X_LAST_UPDATE_LOGIN is NULL then
1067: X_LAST_UPDATE_LOGIN := -1;
1068: end if;
1069: else
1070: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
1071: IGS_GE_MSG_STACK.ADD;
1072: app_exception.raise_exception;
1073: end if;
1074:

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

1304: begin
1305: open c1;
1306: fetch c1 into tlinfo;
1307: if (c1%notfound) then
1308: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
1309: IGS_GE_MSG_STACK.ADD;
1310: close c1;
1311: app_exception.raise_exception;
1312: return;

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

1380: ((tlinfo.attribute20 IS NULL) AND (X_ATTRIBUTE20 IS NULL)))
1381: ) then
1382: null;
1383: else
1384: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
1385: IGS_GE_MSG_STACK.ADD;
1386: app_exception.raise_exception;
1387: end if;
1388: return;

Line 1449: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');

1445: if X_LAST_UPDATE_LOGIN is NULL then
1446: X_LAST_UPDATE_LOGIN := -1;
1447: end if;
1448: else
1449: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
1450: IGS_GE_MSG_STACK.ADD;
1451: app_exception.raise_exception;
1452: end if;
1453: