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

Line 60: App_Exception.Raise_Exception;

56: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT')) THEN
57: Close cur_old_ref_values;
58: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
59: IGS_GE_MSG_STACK.ADD;
60: App_Exception.Raise_Exception;
61: Return;
62: END IF;
63: Close cur_old_ref_values;
64:

Line 118: App_Exception.Raise_Exception;

114: new_references.s_reference_cd_type,
115: v_message_name) = FALSE THEN
116: Fnd_Message.Set_Name('IGS' , v_message_name);
117: IGS_GE_MSG_STACK.ADD;
118: App_Exception.Raise_Exception;
119: END IF;
120: END IF;
121: END BeforeRowInsertUpdate1;
122:

Line 151: App_Exception.Raise_Exception;

147: IF new_references.closed_ind <> UPPER(new_references.closed_ind ) OR
148: new_references.closed_ind NOT IN ( 'Y' , 'N' ) then
149: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
150: IGS_GE_MSG_STACK.ADD;
151: App_Exception.Raise_Exception;
152: END IF;
153: END IF;
154: IF upper(Column_name) = 'REFERENCE_CD_TYPE' OR column_name is null then
155: IF new_references.reference_cd_type <> UPPER(new_references.reference_cd_type ) then

Line 158: App_Exception.Raise_Exception;

154: IF upper(Column_name) = 'REFERENCE_CD_TYPE' OR column_name is null then
155: IF new_references.reference_cd_type <> UPPER(new_references.reference_cd_type ) then
156: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
157: IGS_GE_MSG_STACK.ADD;
158: App_Exception.Raise_Exception;
159: END IF;
160: END IF;
161: IF upper(Column_name) = 'S_REFERENCE_CD_TYPE' OR column_name is null then
162: IF new_references.s_reference_cd_type <> UPPER(new_references.s_reference_cd_type ) then

Line 165: App_Exception.Raise_Exception;

161: IF upper(Column_name) = 'S_REFERENCE_CD_TYPE' OR column_name is null then
162: IF new_references.s_reference_cd_type <> UPPER(new_references.s_reference_cd_type ) then
163: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
164: IGS_GE_MSG_STACK.ADD;
165: App_Exception.Raise_Exception;
166: END IF;
167: END IF;
168:
169:

Line 196: App_Exception.Raise_Exception;

192: Column_Name IS NULL THEN
193: IF NOT (new_references.self_service_flag IN ('Y', 'N')) THEN
194: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
195: IGS_GE_MSG_STACK.ADD;
196: App_Exception.Raise_Exception;
197: END IF;
198: END IF;
199:
200: -- The following code checks for check constraints on the Columns.

Line 206: App_Exception.Raise_Exception;

202: Column_Name IS NULL THEN
203: IF NOT (new_references.program_flag IN ('Y', 'N')) THEN
204: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
205: IGS_GE_MSG_STACK.ADD;
206: App_Exception.Raise_Exception;
207: END IF;
208: END IF;
209:
210: -- The following code checks for check constraints on the Columns.

Line 216: App_Exception.Raise_Exception;

212: Column_Name IS NULL THEN
213: IF NOT (new_references.program_offering_option_flag IN ('Y', 'N')) THEN
214: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
215: IGS_GE_MSG_STACK.ADD;
216: App_Exception.Raise_Exception;
217: END IF;
218: END IF;
219:
220: -- The following code checks for check constraints on the Columns.

Line 226: App_Exception.Raise_Exception;

222: Column_Name IS NULL THEN
223: IF NOT (new_references.unit_flag IN ('Y', 'N')) THEN
224: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
225: IGS_GE_MSG_STACK.ADD;
226: App_Exception.Raise_Exception;
227: END IF;
228: END IF;
229:
230: -- The following code checks for check constraints on the Columns.

Line 236: App_Exception.Raise_Exception;

232: Column_Name IS NULL THEN
233: IF NOT (new_references.unit_section_flag IN ('Y', 'N')) THEN
234: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
235: IGS_GE_MSG_STACK.ADD;
236: App_Exception.Raise_Exception;
237: END IF;
238: END IF;
239:
240: -- The following code checks for check constraints on the Columns.

Line 246: App_Exception.Raise_Exception;

242: Column_Name IS NULL THEN
243: IF NOT (new_references.unit_section_occurrence_flag IN ('Y', 'N')) THEN
244: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
245: IGS_GE_MSG_STACK.ADD;
246: App_Exception.Raise_Exception;
247: END IF;
248: END IF;
249:
250: --Added as a part of Enh#2858431

Line 254: App_Exception.Raise_Exception;

250: --Added as a part of Enh#2858431
251: IF NOT (new_references.restricted_flag IN ('Y', 'N')) THEN
252: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
253: IGS_GE_MSG_STACK.ADD;
254: App_Exception.Raise_Exception;
255: END IF;
256:
257: END Check_Constraints;
258:

Line 283: App_Exception.Raise_Exception;

279: new_references.s_reference_cd_type
280: ) THEN
281: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
282: IGS_GE_MSG_STACK.ADD;
283: App_Exception.Raise_Exception;
284: END IF;
285:
286: END IF;
287:

Line 461: App_Exception.Raise_Exception;

457: BeforeRowInsertUpdate1 ( p_inserting => TRUE );
458: IF GET_PK_FOR_VALIDATION ( new_references.reference_cd_type) THEN
459: Fnd_Message.Set_Name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
460: IGS_GE_MSG_STACK.ADD;
461: App_Exception.Raise_Exception;
462: END IF;
463: Check_Constraints;
464: Check_Parent_Existance;
465: ELSIF (p_action = 'UPDATE') THEN

Line 477: App_Exception.Raise_Exception;

473: ELSIF (p_action = 'VALIDATE_INSERT') THEN
474: IF GET_PK_FOR_VALIDATION ( new_references.reference_cd_type ) THEN
475: Fnd_Message.Set_Name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
476: IGS_GE_MSG_STACK.ADD;
477: App_Exception.Raise_Exception;
478: END IF;
479: Check_Constraints;
480: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
481: Check_Constraints;

Line 572: app_exception.raise_exception;

568: end if;
569: else
570: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
571: IGS_GE_MSG_STACK.ADD;
572: app_exception.raise_exception;
573: end if;
574:
575: Before_DML (
576: p_action => 'INSERT',

Line 702: app_exception.raise_exception;

698: if (c1%notfound) then
699: close c1;
700: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
701: IGS_GE_MSG_STACK.ADD;
702: app_exception.raise_exception;
703: return;
704: end if;
705: close c1;
706:

Line 727: app_exception.raise_exception;

723: null;
724: else
725: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
726: IGS_GE_MSG_STACK.ADD;
727: app_exception.raise_exception;
728: end if;
729: return;
730: end LOCK_ROW;
731:

Line 779: app_exception.raise_exception;

775: end if;
776: else
777: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
778: IGS_GE_MSG_STACK.ADD;
779: app_exception.raise_exception;
780: end if;
781:
782: Before_DML (
783: p_action => 'UPDATE',