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_PR_SDT_PR_RU_CK_PKG dependencies on IGS_GE_MSG_STACK

Line 42: IGS_GE_MSG_STACK.ADD;

38: Open cur_old_ref_values;
39: Fetch cur_old_ref_values INTO old_references;
40: IF (cur_old_ref_values%NOTFOUND) AND (p_action not in ('INSERT','VALIDATE_INSERT')) THEN
41: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
42: IGS_GE_MSG_STACK.ADD;
43: Close cur_old_ref_values;
44: App_Exception.Raise_Exception;
45:
46: Return;

Line 87: IGS_GE_MSG_STACK.ADD;

83: new_references.progression_rule_cat,
84: new_references.pra_sequence_number
85: )THEN
86: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
87: IGS_GE_MSG_STACK.ADD;
88: App_Exception.Raise_Exception;
89:
90: END IF;
91:

Line 114: IGS_GE_MSG_STACK.ADD;

110: new_references.prg_ci_sequence_number,
111: new_references.rule_check_dt
112: )THEN
113: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
114: IGS_GE_MSG_STACK.ADD;
115: App_Exception.Raise_Exception;
116:
117: END IF;
118:

Line 195: IGS_GE_MSG_STACK.ADD;

191: Open cur_rowid;
192: Fetch cur_rowid INTO lv_rowid;
193: IF (cur_rowid%FOUND) THEN
194: Fnd_Message.Set_Name ('IGS', 'IGS_PR_SPRC_PRA_FK');
195: IGS_GE_MSG_STACK.ADD;
196: Close cur_rowid;
197: App_Exception.Raise_Exception;
198:
199: Return;

Line 230: IGS_GE_MSG_STACK.ADD;

226: Open cur_rowid;
227: Fetch cur_rowid INTO lv_rowid;
228: IF (cur_rowid%FOUND) THEN
229: Fnd_Message.Set_Name ('IGS', 'IGS_PR_SPRC_SPCHK_FK');
230: IGS_GE_MSG_STACK.ADD;
231: Close cur_rowid;
232: App_Exception.Raise_Exception;
233:
234: Return;

Line 294: IGS_GE_MSG_STACK.ADD;

290: new_references.progression_rule_cat,
291: new_references.pra_sequence_number,
292: new_references.rule_check_dt) THEN
293: Fnd_Message.Set_Name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
294: IGS_GE_MSG_STACK.ADD;
295: App_Exception.Raise_Exception;
296: END IF;
297: CHECK_CONSTRAINTS;
298:

Line 318: IGS_GE_MSG_STACK.ADD;

314: new_references.progression_rule_cat,
315: new_references.pra_sequence_number,
316: new_references.rule_check_dt) THEN
317: Fnd_Message.Set_Name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
318: IGS_GE_MSG_STACK.ADD;
319: App_Exception.Raise_Exception;
320: END IF;
321: CHECK_CONSTRAINTS;
322:

Line 373: IGS_GE_MSG_STACK.ADD;

369: X_LAST_UPDATE_LOGIN := -1;
370: end if;
371: else
372: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
373: IGS_GE_MSG_STACK.ADD;
374: app_exception.raise_exception;
375: end if;
376: Before_DML (
377: p_action => 'INSERT',

Line 469: IGS_GE_MSG_STACK.ADD;

465: open c1;
466: fetch c1 into tlinfo;
467: if (c1%notfound) then
468: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
469: IGS_GE_MSG_STACK.ADD;
470: close c1;
471: app_exception.raise_exception;
472:
473: return;

Line 494: IGS_GE_MSG_STACK.ADD;

490: ) then
491: null;
492: else
493: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
494: IGS_GE_MSG_STACK.ADD;
495: app_exception.raise_exception;
496: end if;
497: return;
498: end LOCK_ROW;

Line 532: IGS_GE_MSG_STACK.ADD;

528: X_LAST_UPDATE_LOGIN := -1;
529: end if;
530: else
531: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
532: IGS_GE_MSG_STACK.ADD;
533: app_exception.raise_exception;
534: end if;
535: Before_DML (
536: p_action => 'UPDATE',

Line 669: IGS_GE_MSG_STACK.ADD;

665:
666: IF upper(Column_name) = 'COURSE_CD' OR COLUMN_NAME IS NULL THEN
667: IF new_references.COURSE_CD<> upper(new_references.COURSE_CD) then
668: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
669: IGS_GE_MSG_STACK.ADD;
670: App_Exception.Raise_Exception ;
671: END IF;
672:
673: END IF ;

Line 678: IGS_GE_MSG_STACK.ADD;

674:
675: IF upper(Column_name) = 'PASSED_IND' OR COLUMN_NAME IS NULL THEN
676: IF new_references.PASSED_IND<> upper(new_references.PASSED_IND) then
677: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
678: IGS_GE_MSG_STACK.ADD;
679: App_Exception.Raise_Exception ;
680: END IF;
681:
682: IF new_references.PASSED_IND not in ('Y','N') then

Line 684: IGS_GE_MSG_STACK.ADD;

680: END IF;
681:
682: IF new_references.PASSED_IND not in ('Y','N') then
683: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
684: IGS_GE_MSG_STACK.ADD;
685: App_Exception.Raise_Exception ;
686: END IF;
687:
688: END IF ;

Line 693: IGS_GE_MSG_STACK.ADD;

689:
690: IF upper(Column_name) = 'PRG_CAL_TYPE' OR COLUMN_NAME IS NULL THEN
691: IF new_references.PRG_CAL_TYPE<> upper(new_references.PRG_CAL_TYPE) then
692: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
693: IGS_GE_MSG_STACK.ADD;
694: App_Exception.Raise_Exception ;
695: END IF;
696:
697: END IF ;

Line 702: IGS_GE_MSG_STACK.ADD;

698:
699: IF upper(Column_name) = 'PROGRESSION_RULE_CAT' OR COLUMN_NAME IS NULL THEN
700: IF new_references.PROGRESSION_RULE_CAT<> upper(new_references.PROGRESSION_RULE_CAT) then
701: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
702: IGS_GE_MSG_STACK.ADD;
703: App_Exception.Raise_Exception ;
704: END IF;
705:
706: END IF ;

Line 711: IGS_GE_MSG_STACK.ADD;

707:
708: IF upper(Column_name) = 'PRA_SEQUENCE_NUMBER' OR COLUMN_NAME IS NULL THEN
709: IF new_references.PRA_SEQUENCE_NUMBER < 1 or new_references.PRA_SEQUENCE_NUMBER > 999999 then
710: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
711: IGS_GE_MSG_STACK.ADD;
712: App_Exception.Raise_Exception ;
713: END IF;
714:
715: END IF ;

Line 720: IGS_GE_MSG_STACK.ADD;

716:
717: IF upper(Column_name) = 'PRG_CI_SEQUENCE_NUMBER' OR COLUMN_NAME IS NULL THEN
718: IF new_references.PRG_CI_SEQUENCE_NUMBER < 1 or new_references.PRG_CI_SEQUENCE_NUMBER > 999999 then
719: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
720: IGS_GE_MSG_STACK.ADD;
721: App_Exception.Raise_Exception ;
722: END IF;
723:
724: END IF ;