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_RU_ITEM_PKG dependencies on APP_EXCEPTION

Line 43: App_Exception.Raise_Exception;

39: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT')) THEN
40: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
41: IGS_RU_GEN_006.SET_TOKEN(' IGS_RU_ITEM : P_ACTION INSERT VALIDATE_INSERT : IGSUI07B.PLS');
42: IGS_GE_MSG_STACK.ADD;
43: App_Exception.Raise_Exception;
44: Close cur_old_ref_values;
45: Return;
46: END IF;
47: Close cur_old_ref_values;

Line 93: App_Exception.Raise_Exception ;

89: IF upper(Column_name) = 'RUL_SEQUENCE_NUMBER' OR COLUMN_NAME IS NULL THEN
90: IF new_references.RUL_SEQUENCE_NUMBER < 0 or new_references.RUL_SEQUENCE_NUMBER > 999999 then
91: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
92: IGS_GE_MSG_STACK.ADD;
93: App_Exception.Raise_Exception ;
94: END IF;
95:
96: END IF ;
97:

Line 102: App_Exception.Raise_Exception ;

98: IF upper(Column_name) = 'SET_NUMBER' OR COLUMN_NAME IS NULL THEN
99: IF new_references.SET_NUMBER < 0 or new_references.SET_NUMBER > 999999 then
100: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
101: IGS_GE_MSG_STACK.ADD;
102: App_Exception.Raise_Exception ;
103: END IF;
104:
105: END IF ;
106:

Line 111: App_Exception.Raise_Exception ;

107: IF upper(Column_name) = 'ITEM' OR COLUMN_NAME IS NULL THEN
108: IF new_references.ITEM < 0 or new_references.ITEM > 999999 then
109: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
110: IGS_GE_MSG_STACK.ADD;
111: App_Exception.Raise_Exception ;
112: END IF;
113:
114: END IF ;
115: END Check_Constraints;

Line 130: App_Exception.Raise_Exception;

126: ) THEN
127: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
128: IGS_RU_GEN_006.SET_TOKEN(' IGS_RU_NAMED_RULE : P_ACTION Check_Parent_Existance named_rule : IGSUI07B.PLS');
129: IGS_GE_MSG_STACK.ADD;
130: App_Exception.Raise_Exception;
131: END IF;
132: END IF;
133:
134: IF (((old_references.rul_sequence_number = new_references.rul_sequence_number)) OR

Line 144: App_Exception.Raise_Exception;

140: ) THEN
141: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
142: IGS_RU_GEN_006.SET_TOKEN(' IGS_RU_RULE : P_ACTION Check_Parent_Existance rul_sequence_number : IGSUI07B.PLS');
143: IGS_GE_MSG_STACK.ADD;
144: App_Exception.Raise_Exception;
145: END IF;
146: END IF;
147:
148: IF (((old_references.rule_number = new_references.rule_number)) OR

Line 158: App_Exception.Raise_Exception;

154: ) THEN
155: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
156: IGS_RU_GEN_006.SET_TOKEN(' IGS_RU_RULE : P_ACTION Check_Parent_Existance rule_number : IGSUI07B.PLS');
157: IGS_GE_MSG_STACK.ADD;
158: App_Exception.Raise_Exception;
159: END IF;
160: END IF;
161:
162: IF (((old_references.set_number = new_references.set_number)) OR

Line 172: App_Exception.Raise_Exception;

168: ) THEN
169: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
170: IGS_RU_GEN_006.SET_TOKEN(' IGS_RU_SET : P_ACTION Check_Parent_Existance set_number : IGSUI07B.PLS');
171: IGS_GE_MSG_STACK.ADD;
172: App_Exception.Raise_Exception;
173: END IF;
174: END IF;
175:
176: IF (((old_references.derived_rule = new_references.derived_rule)) OR

Line 186: App_Exception.Raise_Exception;

182: ) THEN
183: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
184: IGS_RU_GEN_006.SET_TOKEN(' IGS_RU_CALL : P_ACTION Check_Parent_Existance derived_rule : IGSUI07B.PLS');
185: IGS_GE_MSG_STACK.ADD;
186: App_Exception.Raise_Exception;
187: END IF;
188: END IF;
189:
190: IF (((old_references.turin_function = new_references.turin_function)) OR

Line 200: App_Exception.Raise_Exception;

196: ) THEN
197: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
198: IGS_RU_GEN_006.SET_TOKEN(' IGS_RU_TURIN_FNC : P_ACTION Check_Parent_Existance turin_function : IGSUI07B.PLS');
199: IGS_GE_MSG_STACK.ADD;
200: App_Exception.Raise_Exception;
201: END IF;
202: END IF;
203:
204: END Check_Parent_Existance;

Line 252: App_Exception.Raise_Exception;

248: IF (cur_rowid%FOUND) THEN
249: Close cur_rowid;
250: Fnd_Message.Set_Name ('IGS', 'IGS_RU_RUI_NR_FK');
251: IGS_GE_MSG_STACK.ADD;
252: App_Exception.Raise_Exception;
253: Return;
254: END IF;
255: Close cur_rowid;
256:

Line 279: App_Exception.Raise_Exception;

275: IF (cur_rowid%FOUND) THEN
276: Close cur_rowid;
277: Fnd_Message.Set_Name ('IGS', 'IGS_RU_RUI_RUL_FK');
278: IGS_GE_MSG_STACK.ADD;
279: App_Exception.Raise_Exception;
280: Return;
281: END IF;
282: Close cur_rowid;
283:

Line 305: App_Exception.Raise_Exception;

301: IF (cur_rowid%FOUND) THEN
302: Close cur_rowid;
303: Fnd_Message.Set_Name ('IGS', 'IGS_RU_RUI_RUL_FK');
304: IGS_GE_MSG_STACK.ADD;
305: App_Exception.Raise_Exception;
306: Return;
307: END IF;
308: Close cur_rowid;
309:

Line 331: App_Exception.Raise_Exception;

327: IF (cur_rowid%FOUND) THEN
328: Close cur_rowid;
329: Fnd_Message.Set_Name ('IGS', 'IGS_RU_RUI_SRC_FK');
330: IGS_GE_MSG_STACK.ADD;
331: App_Exception.Raise_Exception;
332: Return;
333: END IF;
334: Close cur_rowid;
335:

Line 357: App_Exception.Raise_Exception;

353: IF (cur_rowid%FOUND) THEN
354: Close cur_rowid;
355: Fnd_Message.Set_Name ('IGS', 'IGS_RU_RUI_STF_FK');
356: IGS_GE_MSG_STACK.ADD;
357: App_Exception.Raise_Exception;
358: Return;
359: END IF;
360: Close cur_rowid;
361:

Line 409: App_Exception.Raise_Exception;

405: new_references.item
406: ) THEN
407: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
408: IGS_GE_MSG_STACK.ADD;
409: App_Exception.Raise_Exception;
410: END IF;
411: Check_Constraints;
412: Check_Parent_Existance;
413: ELSIF (p_action = 'UPDATE') THEN

Line 424: App_Exception.Raise_Exception;

420: new_references.item
421: ) THEN
422: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
423: IGS_GE_MSG_STACK.ADD;
424: App_Exception.Raise_Exception;
425: END IF;
426: Check_Constraints;
427: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
428: Check_Constraints;

Line 477: app_exception.raise_exception;

473: end if;
474: else
475: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
476: IGS_GE_MSG_STACK.ADD;
477: app_exception.raise_exception;
478: end if;
479:
480: Before_DML(
481: p_action=>'INSERT',

Line 571: app_exception.raise_exception;

567: if (c1%notfound) then
568: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
569: IGS_RU_GEN_006.SET_TOKEN(' IGS_RU_ITEM : P_ACTION LOCK_ROW : IGSUI07B.PLS');
570: IGS_GE_MSG_STACK.ADD;
571: app_exception.raise_exception;
572: close c1;
573: return;
574: end if;
575: close c1;

Line 601: app_exception.raise_exception;

597: else
598: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
599: IGS_RU_GEN_006.SET_TOKEN(' IGS_RU_ITEM : P_ACTION LOCK_ROW FORM_RECORD_CHANGED : IGSUI07B.PLS');
600: IGS_GE_MSG_STACK.ADD;
601: app_exception.raise_exception;
602: end if;
603: return;
604: end LOCK_ROW;
605:

Line 638: app_exception.raise_exception;

634: end if;
635: else
636: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
637: IGS_GE_MSG_STACK.ADD;
638: app_exception.raise_exception;
639: end if;
640:
641: Before_DML(
642: p_action=>'UPDATE',