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

Line 39: IGS_GE_MSG_STACK.ADD;

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

Line 83: IGS_GE_MSG_STACK.ADD;

79: new_references.pra_sequence_number,
80: new_references.pro_sequence_number
81: ) THEN
82: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
83: IGS_GE_MSG_STACK.ADD;
84: App_Exception.Raise_Exception;
85:
86: END IF;
87: END IF;

Line 100: IGS_GE_MSG_STACK.ADD;

96: new_references.unit_set_cd,
97: new_references.us_version_number
98: ) THEN
99: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
100: IGS_GE_MSG_STACK.ADD;
101: App_Exception.Raise_Exception;
102: END IF;
103:
104: END IF;

Line 163: IGS_GE_MSG_STACK.ADD;

159: Open cur_rowid;
160: Fetch cur_rowid INTO lv_rowid;
161: IF (cur_rowid%FOUND) THEN
162: Fnd_Message.Set_Name ('IGS', 'IGS_PR_POUS_PRO_FK');
163: IGS_GE_MSG_STACK.ADD;
164: Close cur_rowid;
165: App_Exception.Raise_Exception;
166: Return;
167: END IF;

Line 191: IGS_GE_MSG_STACK.ADD;

187: Open cur_rowid;
188: Fetch cur_rowid INTO lv_rowid;
189: IF (cur_rowid%FOUND) THEN
190: Fnd_Message.Set_Name ('IGS', 'IGS_PR_POUS_US_FK');
191: IGS_GE_MSG_STACK.ADD;
192: Close cur_rowid;
193: App_Exception.Raise_Exception;
194: Return;
195: END IF;

Line 230: IGS_GE_MSG_STACK.ADD;

226: FETCH c_parent INTO l_dummy;
227: IF c_parent%NOTFOUND THEN
228: CLOSE c_parent;
229: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
230: IGS_GE_MSG_STACK.ADD;
231: APP_EXCEPTION.RAISE_EXCEPTION;
232: END IF;
233: CLOSE c_parent;
234: ELSIF(p_action = 'UPDATE') THEN

Line 243: IGS_GE_MSG_STACK.ADD;

239: FETCH c_parent INTO l_dummy;
240: IF c_parent%NOTFOUND THEN
241: CLOSE c_parent;
242: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
243: IGS_GE_MSG_STACK.ADD;
244: APP_EXCEPTION.RAISE_EXCEPTION;
245: END IF;
246: CLOSE c_parent;
247: END IF;

Line 295: IGS_GE_MSG_STACK.ADD;

291: new_references.pro_sequence_number,
292: new_references.unit_set_cd,
293: new_references.us_version_number) THEN
294: Fnd_Message.Set_Name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
295: IGS_GE_MSG_STACK.ADD;
296: App_Exception.Raise_Exception;
297: END IF;
298: CHECK_CONSTRAINTS;
299:

Line 312: IGS_GE_MSG_STACK.ADD;

308: new_references.pro_sequence_number,
309: new_references.unit_set_cd,
310: new_references.us_version_number) THEN
311: Fnd_Message.Set_Name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
312: IGS_GE_MSG_STACK.ADD;
313: App_Exception.Raise_Exception;
314: END IF;
315:
316: CHECK_CONSTRAINTS;

Line 361: IGS_GE_MSG_STACK.ADD;

357: X_LAST_UPDATE_LOGIN := -1;
358: end if;
359: else
360: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
361: IGS_GE_MSG_STACK.ADD;
362: app_exception.raise_exception;
363: end if;
364: Before_DML (
365: p_action => 'INSERT',

Line 433: IGS_GE_MSG_STACK.ADD;

429: open c1;
430: fetch c1 into tlinfo;
431: if (c1%notfound) then
432: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
433: IGS_GE_MSG_STACK.ADD;
434: close c1;
435: app_exception.raise_exception;
436: return;
437: end if;

Line 484: IGS_GE_MSG_STACK.ADD;

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

Line 493: IGS_GE_MSG_STACK.ADD;

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

Line 502: IGS_GE_MSG_STACK.ADD;

498:
499: IF upper(Column_name) = 'PRA_SEQUENCE_NUMBER' OR COLUMN_NAME IS NULL THEN
500: IF new_references.PRA_SEQUENCE_NUMBER < 1 or new_references.PRA_SEQUENCE_NUMBER > 999999 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:
506: END IF ;

Line 511: IGS_GE_MSG_STACK.ADD;

507:
508: IF upper(Column_name) = 'PRO_SEQUENCE_NUMBER' OR COLUMN_NAME IS NULL THEN
509: IF new_references.PRO_SEQUENCE_NUMBER < 1 or new_references.PRO_SEQUENCE_NUMBER > 999999 then
510: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
511: IGS_GE_MSG_STACK.ADD;
512: App_Exception.Raise_Exception ;
513: END IF;
514:
515: END IF ;