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

Line 41: App_Exception.Raise_Exception;

37: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
38: Close cur_old_ref_values;
39: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
40: IGS_GE_MSG_STACK.ADD;
41: App_Exception.Raise_Exception;
42: Return;
43: END IF;
44: Close cur_old_ref_values;
45:

Line 82: App_Exception.Raise_Exception;

78: new_references.s_intake_target_type,
79: v_message_name) = FALSE THEN
80: Fnd_Message.Set_Name('IGS',v_message_name);
81: IGS_GE_MSG_STACK.ADD;
82: App_Exception.Raise_Exception;
83: END IF;
84: END IF;
85:
86:

Line 107: App_Exception.Raise_Exception;

103: new_references.s_amount_type,
104: v_message_name) = FALSE THEN
105: Fnd_Message.Set_Name('IGS',v_message_name);
106: IGS_GE_MSG_STACK.ADD;
107: App_Exception.Raise_Exception;
108: END IF;
109: END IF;
110:
111:

Line 134: App_Exception.Raise_Exception;

130: IF upper(Column_Name) = 'CLOSED_IND' OR Column_Name IS NULL THEN
131: IF new_references.closed_ind NOT IN ('Y','N') THEN
132: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
133: IGS_GE_MSG_STACK.ADD;
134: App_Exception.Raise_Exception;
135: END IF;
136: END IF;
137: IF upper(Column_Name) = 'INTAKE_TARGET_TYPE' OR Column_Name IS NULL THEN
138: IF new_references.intake_target_type <> UPPER(new_references.intake_target_type) THEN

Line 141: App_Exception.Raise_Exception;

137: IF upper(Column_Name) = 'INTAKE_TARGET_TYPE' OR Column_Name IS NULL THEN
138: IF new_references.intake_target_type <> UPPER(new_references.intake_target_type) THEN
139: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
140: IGS_GE_MSG_STACK.ADD;
141: App_Exception.Raise_Exception;
142: END IF;
143: END IF;
144: IF upper(Column_Name) = 'S_INTAKE_TARGET_TYPE' OR Column_Name IS NULL THEN
145: IF new_references.s_intake_target_type <> UPPER(new_references.s_intake_target_type) THEN

Line 148: App_Exception.Raise_Exception;

144: IF upper(Column_Name) = 'S_INTAKE_TARGET_TYPE' OR Column_Name IS NULL THEN
145: IF new_references.s_intake_target_type <> UPPER(new_references.s_intake_target_type) THEN
146: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
147: IGS_GE_MSG_STACK.ADD;
148: App_Exception.Raise_Exception;
149: END IF;
150: END IF;
151:
152: END Check_Constraints;

Line 167: App_Exception.Raise_Exception;

163: new_references.s_intake_target_type
164: ) THEN
165: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
166: IGS_GE_MSG_STACK.ADD;
167: App_Exception.Raise_Exception;
168: END IF;
169: END IF;
170:
171: IF (((old_references.s_amount_type = new_references.s_amount_type)) OR

Line 181: App_Exception.Raise_Exception;

177: new_references.s_amount_type
178: ) THEN
179: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
180: IGS_GE_MSG_STACK.ADD;
181: App_Exception.Raise_Exception;
182: END IF;
183: END IF;
184:
185: END Check_Parent_Existance;

Line 263: App_Exception.Raise_Exception;

259: IF (cur_rowid%FOUND) THEN
260: Close cur_rowid;
261: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ITT_SLV_FK');
262: IGS_GE_MSG_STACK.ADD;
263: App_Exception.Raise_Exception;
264: Return;
265: END IF;
266: Close cur_rowid;
267:

Line 289: App_Exception.Raise_Exception;

285: IF (cur_rowid%FOUND) THEN
286: Close cur_rowid;
287: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ITT_SLV2_FK');
288: IGS_GE_MSG_STACK.ADD;
289: App_Exception.Raise_Exception;
290: Return;
291: END IF;
292: Close cur_rowid;
293:

Line 336: App_Exception.Raise_Exception;

332: new_references.intake_target_type
333: ) THEN
334: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
335: IGS_GE_MSG_STACK.ADD;
336: App_Exception.Raise_Exception;
337: END IF;
338: Check_Constraints;
339: Check_Parent_Existance;
340: ELSIF (p_action = 'UPDATE') THEN

Line 352: App_Exception.Raise_Exception;

348: new_references.intake_target_type
349: ) THEN
350: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
351: IGS_GE_MSG_STACK.ADD;
352: App_Exception.Raise_Exception;
353: END IF;
354: Check_Constraints;
355: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
356: Check_Constraints;

Line 405: app_exception.raise_exception;

401: end if;
402: else
403: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
404: IGS_GE_MSG_STACK.ADD;
405: app_exception.raise_exception;
406: end if;
407:
408: Before_DML(
409: p_action=>'INSERT' ,

Line 492: app_exception.raise_exception;

488: if (c1%notfound) then
489: close c1;
490: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
491: IGS_GE_MSG_STACK.ADD;
492: app_exception.raise_exception;
493: return;
494: end if;
495: close c1;
496:

Line 509: app_exception.raise_exception;

505: null;
506: else
507: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
508: IGS_GE_MSG_STACK.ADD;
509: app_exception.raise_exception;
510: end if;
511: return;
512: end LOCK_ROW;
513:

Line 543: app_exception.raise_exception;

539: end if;
540: else
541: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
542: IGS_GE_MSG_STACK.ADD;
543: app_exception.raise_exception;
544: end if;
545:
546:
547: Before_DML(