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_RU_CA_TYPE_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_GE_MSG_STACK.ADD;
42: Close cur_old_ref_values;
43: App_Exception.Raise_Exception;
44:
45: Return;
46: END IF;
47: Close cur_old_ref_values;

Line 92: App_Exception.Raise_Exception;

88: new_references.prg_cal_type,
89: v_message_name) = FALSE THEN
90: Fnd_Message.Set_Name('IGS',v_message_name);
91: IGS_GE_MSG_STACK.ADD;
92: App_Exception.Raise_Exception;
93: END IF;
94: END IF;
95: -- Validate the start and end sequence number
96: IF p_inserting OR (p_updating AND

Line 106: App_Exception.Raise_Exception;

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

Line 125: App_Exception.Raise_Exception;

121: new_references.prg_cal_type
122: ) THEN
123: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
124: IGS_GE_MSG_STACK.ADD;
125: App_Exception.Raise_Exception;
126:
127: END IF;
128:
129: END IF;

Line 143: App_Exception.Raise_Exception;

139: new_references.end_sequence_number
140: ) THEN
141: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
142: IGS_GE_MSG_STACK.ADD;
143: App_Exception.Raise_Exception;
144:
145: END IF;
146:
147: END IF;

Line 162: App_Exception.Raise_Exception;

158: ) THEN
159:
160: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
161: IGS_GE_MSG_STACK.ADD;
162: App_Exception.Raise_Exception;
163:
164: END IF;
165:
166: END IF;

Line 181: App_Exception.Raise_Exception;

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

Line 238: App_Exception.Raise_Exception;

234: IF (cur_rowid%FOUND) THEN
235: Fnd_Message.Set_Name ('IGS', 'IGS_PR_PRCT_CAT_FK');
236: IGS_GE_MSG_STACK.ADD;
237: Close cur_rowid;
238: App_Exception.Raise_Exception;
239:
240: Return;
241: END IF;
242: Close cur_rowid;

Line 269: App_Exception.Raise_Exception;

265: IF (cur_rowid%FOUND) THEN
266: Fnd_Message.Set_Name ('IGS', 'IGS_PR_PRCT_CI_END_FK');
267: IGS_GE_MSG_STACK.ADD;
268: Close cur_rowid;
269: App_Exception.Raise_Exception;
270:
271: Return;
272: END IF;
273: Close cur_rowid;

Line 298: App_Exception.Raise_Exception;

294: IF (cur_rowid%FOUND) THEN
295: Fnd_Message.Set_Name ('IGS', 'IGS_PR_PRCT_PRA_FK');
296: IGS_GE_MSG_STACK.ADD;
297: Close cur_rowid;
298: App_Exception.Raise_Exception;
299:
300: Return;
301: END IF;
302: Close cur_rowid;

Line 353: App_Exception.Raise_Exception;

349: new_references.pra_sequence_number,
350: new_references.prg_cal_type ) THEN
351: Fnd_Message.Set_Name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
352: IGS_GE_MSG_STACK.ADD;
353: App_Exception.Raise_Exception;
354:
355: END IF;
356: CHECK_CONSTRAINTS;
357:

Line 371: App_Exception.Raise_Exception;

367: new_references.pra_sequence_number,
368: new_references.prg_cal_type ) THEN
369: Fnd_Message.Set_Name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
370: IGS_GE_MSG_STACK.ADD;
371: App_Exception.Raise_Exception;
372:
373: END IF;
374: CHECK_CONSTRAINTS;
375: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 417: app_exception.raise_exception;

413: end if;
414: else
415: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
416: IGS_GE_MSG_STACK.ADD;
417: app_exception.raise_exception;
418: end if;
419: Before_DML (
420: p_action => 'INSERT',
421: x_rowid => x_rowid ,

Line 501: app_exception.raise_exception;

497: if (c1%notfound) then
498: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
499: IGS_GE_MSG_STACK.ADD;
500: close c1;
501: app_exception.raise_exception;
502:
503: return;
504: end if;
505: close c1;

Line 524: app_exception.raise_exception;

520: null;
521: else
522: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
523: IGS_GE_MSG_STACK.ADD;
524: app_exception.raise_exception;
525: end if;
526: return;
527: end LOCK_ROW;
528:

Line 560: app_exception.raise_exception;

556: end if;
557: else
558: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
559: IGS_GE_MSG_STACK.ADD;
560: app_exception.raise_exception;
561: end if;
562: Before_DML (
563: p_action => 'UPDATE',
564: x_rowid => x_rowid ,

Line 687: App_Exception.Raise_Exception;

683: IF new_references.pra_sequence_number < 1 OR
684: new_references.pra_sequence_number > 999999 THEN
685: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
686: IGS_GE_MSG_STACK.ADD;
687: App_Exception.Raise_Exception;
688: END IF;
689: END IF;
690:
691: IF UPPER(column_name) = 'END_SEQUENCE_NUMBER' OR column_name IS NULL THEN

Line 696: App_Exception.Raise_Exception;

692: IF new_references.end_sequence_number < 1 OR
693: new_references.end_sequence_number > 999999 THEN
694: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
695: IGS_GE_MSG_STACK.ADD;
696: App_Exception.Raise_Exception;
697: END IF;
698: END IF;
699: IF UPPER(column_name) = 'START_SEQUENCE_NUMBER' OR column_name IS NULL THEN
700: IF new_references.start_sequence_number < 1 OR

Line 704: App_Exception.Raise_Exception;

700: IF new_references.start_sequence_number < 1 OR
701: new_references.start_sequence_number > 999999 THEN
702: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
703: IGS_GE_MSG_STACK.ADD;
704: App_Exception.Raise_Exception;
705: END IF;
706: END IF;
707: IF UPPER(column_name) = 'START_EFFECTIVE_PERIOD' OR column_name IS NULL THEN
708: IF new_references.start_effective_period < 1 OR

Line 712: App_Exception.Raise_Exception;

708: IF new_references.start_effective_period < 1 OR
709: new_references.start_effective_period > 99 THEN
710: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
711: IGS_GE_MSG_STACK.ADD;
712: App_Exception.Raise_Exception;
713: END IF;
714: END IF;
715:
716: IF UPPER(column_name) = 'NUM_OF_APPLICATIONS' OR column_name IS NULL THEN

Line 721: App_Exception.Raise_Exception;

717: IF new_references.num_of_applications < 1 OR
718: new_references.num_of_applications > 99 THEN
719: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
720: IGS_GE_MSG_STACK.ADD;
721: App_Exception.Raise_Exception;
722: END IF;
723: END IF;
724:
725: IF UPPER(column_name) = 'PRG_CAL_TYPE' OR column_name IS NULL THEN

Line 729: App_Exception.Raise_Exception;

725: IF UPPER(column_name) = 'PRG_CAL_TYPE' OR column_name IS NULL THEN
726: IF new_references.prg_cal_type <> UPPER(new_references.prg_cal_type) THEN
727: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
728: IGS_GE_MSG_STACK.ADD;
729: App_Exception.Raise_Exception;
730: END IF;
731: END IF;
732:
733: IF UPPER(column_name) = 'PROGRESSION_RULE_CAT' OR column_name IS NULL THEN

Line 737: App_Exception.Raise_Exception;

733: IF UPPER(column_name) = 'PROGRESSION_RULE_CAT' OR column_name IS NULL THEN
734: IF new_references.progression_rule_cat<> UPPER(new_references.progression_rule_cat) THEN
735: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
736: IGS_GE_MSG_STACK.ADD;
737: App_Exception.Raise_Exception;
738: END IF;
739: END IF;
740:
741: END Check_Constraints;