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

Line 56: App_Exception.Raise_Exception;

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

Line 128: App_Exception.Raise_Exception;

124: IF upper(column_name) = 'ADM_UNIT_OUTCOME_STATUS' OR column_name is null Then
125: IF new_references.adm_unit_outcome_status <> UPPER(new_references.adm_unit_outcome_status) Then
126: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
127: IGS_GE_MSG_STACK.ADD;
128: App_Exception.Raise_Exception;
129: END IF;
130: END IF;
131:
132: IF upper(column_name) = 'CAL_TYPE' OR column_name is null Then

Line 136: App_Exception.Raise_Exception;

132: IF upper(column_name) = 'CAL_TYPE' OR column_name is null Then
133: IF new_references.cal_type <> UPPER(new_references.cal_type) Then
134: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
135: IGS_GE_MSG_STACK.ADD;
136: App_Exception.Raise_Exception;
137: END IF;
138: END IF;
139:
140: IF upper(column_name) = 'LOCATION_CD' OR column_name is null Then

Line 144: App_Exception.Raise_Exception;

140: IF upper(column_name) = 'LOCATION_CD' OR column_name is null Then
141: IF new_references.location_cd <> UPPER(new_references.location_cd) Then
142: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
143: IGS_GE_MSG_STACK.ADD;
144: App_Exception.Raise_Exception;
145: END IF;
146: END IF;
147:
148: IF upper(column_name) = 'SUP_UNIT_CD' OR column_name is null Then

Line 152: App_Exception.Raise_Exception;

148: IF upper(column_name) = 'SUP_UNIT_CD' OR column_name is null Then
149: IF new_references.sup_unit_cd <> UPPER(new_references.sup_unit_cd) Then
150: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
151: IGS_GE_MSG_STACK.ADD;
152: App_Exception.Raise_Exception;
153: END IF;
154: END IF;
155:
156: IF upper(column_name) = 'UNIT_CD' OR column_name is null Then

Line 160: App_Exception.Raise_Exception;

156: IF upper(column_name) = 'UNIT_CD' OR column_name is null Then
157: IF new_references.unit_cd <> UPPER(new_references.unit_cd) Then
158: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
159: IGS_GE_MSG_STACK.ADD;
160: App_Exception.Raise_Exception;
161: END IF;
162: END IF;
163:
164: IF upper(column_name) = 'UNIT_CLASS' OR column_name is null Then

Line 168: App_Exception.Raise_Exception;

164: IF upper(column_name) = 'UNIT_CLASS' OR column_name is null Then
165: IF new_references.unit_class <> UPPER(new_references.unit_class) Then
166: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
167: IGS_GE_MSG_STACK.ADD;
168: App_Exception.Raise_Exception;
169: END IF;
170: END IF;
171:
172: IF upper(column_name) = 'UNIT_MODE' OR column_name is null Then

Line 176: App_Exception.Raise_Exception;

172: IF upper(column_name) = 'UNIT_MODE' OR column_name is null Then
173: IF new_references.unit_mode <> UPPER(new_references.unit_mode) Then
174: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
175: IGS_GE_MSG_STACK.ADD;
176: App_Exception.Raise_Exception;
177: END IF;
178: END IF;
179:
180: IF upper(column_name) = 'CI_SEQUENCE_NUMBER' OR column_name is null Then

Line 184: App_Exception.Raise_Exception;

180: IF upper(column_name) = 'CI_SEQUENCE_NUMBER' OR column_name is null Then
181: IF new_references.ci_sequence_number < 1 OR new_references.ci_sequence_number > 999999 Then
182: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
183: IGS_GE_MSG_STACK.ADD;
184: App_Exception.Raise_Exception;
185: END IF;
186: END IF;
187: END Check_Constraints;
188:

Line 321: App_Exception.Raise_Exception;

317: new_references.hist_start_dt
318: ) THEN
319: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
320: IGS_GE_MSG_STACK.ADD;
321: App_Exception.Raise_Exception;
322: END IF;
323: Check_Constraints;
324: ELSIF (p_action = 'UPDATE') THEN
325: new_references.adm_ps_appl_inst_unit_hist_id := old_references.adm_ps_appl_inst_unit_hist_id;

Line 332: App_Exception.Raise_Exception;

328: new_references.hist_start_dt
329: ) THEN
330: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
331: IGS_GE_MSG_STACK.ADD;
332: App_Exception.Raise_Exception;
333: END IF;
334: Check_Constraints;
335: ELSIF (p_action = 'VALIDATE_INSERT') THEN
336: IF Get_PK_For_Validation (new_references.adm_ps_appl_inst_unit_hist_id) OR

Line 343: App_Exception.Raise_Exception;

339: new_references.hist_start_dt
340: ) THEN
341: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
342: IGS_GE_MSG_STACK.ADD;
343: App_Exception.Raise_Exception;
344: END IF;
345: Check_Constraints;
346: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
347: new_references.adm_ps_appl_inst_unit_hist_id := old_references.adm_ps_appl_inst_unit_hist_id;

Line 354: App_Exception.Raise_Exception;

350: new_references.hist_start_dt
351: ) THEN
352: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
353: IGS_GE_MSG_STACK.ADD;
354: App_Exception.Raise_Exception;
355: END IF;
356: Check_Constraints;
357: END IF;
358: END Before_DML;

Line 420: app_exception.raise_exception;

416: end if;
417: else
418: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
419: IGS_GE_MSG_STACK.ADD;
420: app_exception.raise_exception;
421: end if;
422: Before_DML(p_action =>'INSERT',
423: x_rowid =>X_ROWID,
424: x_org_id => igs_ge_gen_003.get_org_id,

Line 536: app_exception.raise_exception;

532: -- that the ownerof policy function does not have privilege to access.
533: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_EXCEPTION');
534: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
535: IGS_GE_MSG_STACK.ADD;
536: app_exception.raise_exception;
537: ELSE
538: RAISE;
539: END IF;
540: end INSERT_ROW;

Line 593: app_exception.raise_exception;

589: if (c1%notfound) then
590: close c1;
591: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
592: IGS_GE_MSG_STACK.ADD;
593: app_exception.raise_exception;
594: return;
595: end if;
596: close c1;
597:

Line 641: app_exception.raise_exception;

637: null;
638: else
639: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
640: IGS_GE_MSG_STACK.ADD;
641: app_exception.raise_exception;
642: end if;
643: return;
644: end LOCK_ROW;
645:

Line 692: app_exception.raise_exception;

688: end if;
689: else
690: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
691: IGS_GE_MSG_STACK.ADD;
692: app_exception.raise_exception;
693: end if;
694: Before_DML(p_action =>'UPDATE',
695: x_rowid =>X_ROWID,
696: x_person_id=>X_PERSON_ID ,

Line 748: app_exception.raise_exception;

744: ;
745: if (sql%notfound) then
746: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
747: IGS_GE_MSG_STACK.ADD;
748: app_exception.raise_exception;
749: end if;
750: After_DML(
751: p_action =>'UPDATE',
752: x_rowid => X_ROWID

Line 766: app_exception.raise_exception;

762: -- that the ownerof policy function does not have privilege to access.
763: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_EXCEPTION');
764: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
765: IGS_GE_MSG_STACK.ADD;
766: app_exception.raise_exception;
767: ELSE
768: RAISE;
769: END IF;
770: end UPDATE_ROW;

Line 885: app_exception.raise_exception;

881: where ROWID = X_ROWID;
882: if (sql%notfound) then
883: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
884: IGS_GE_MSG_STACK.ADD;
885: app_exception.raise_exception;
886: end if;
887: After_DML(
888: p_action =>'DELETE',
889: x_rowid => X_ROWID

Line 897: App_Exception.Raise_Exception;

893: -- Set error message number
894: v_message_name := 'IGS_AD_UNABLE_TO_DELETE';
895: Fnd_Message.Set_Name('IGS',v_message_name);
896: IGS_GE_MSG_STACK.ADD;
897: App_Exception.Raise_Exception;
898: WHEN OTHERS THEN
899: IF SQLCODE = '-28115' OR SQLCODE = '-28113' OR SQLCODE = '-28111' THEN
900: -- Code to handle Security Policy error raised
901: -- 1) ORA-28115 (policy with check option violation) which is raised when Policy predicate was evaluated to FALSE with the updated values.

Line 908: app_exception.raise_exception;

904: -- that the ownerof policy function does not have privilege to access.
905: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_EXCEPTION');
906: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
907: IGS_GE_MSG_STACK.ADD;
908: app_exception.raise_exception;
909: ELSE
910: RAISE;
911: END IF;
912: end DELETE_ROW;