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

Line 40: App_Exception.Raise_Exception;

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

Line 85: App_Exception.Raise_Exception;

81: new_references.prg_cal_type,
82: v_message_name) = FALSE THEN
83: Fnd_Message.Set_Name('IGS',v_message_name);
84: IGS_GE_MSG_STACK.ADD;
85: App_Exception.Raise_Exception;
86: END IF;
87: END IF;
88: -- Validate the show cause length
89: IF p_inserting OR (p_updating AND

Line 96: App_Exception.Raise_Exception;

92: new_references.show_cause_length,
93: v_message_name) = FALSE THEN
94: Fnd_Message.Set_Name('IGS',v_message_name);
95: IGS_GE_MSG_STACK.ADD;
96: App_Exception.Raise_Exception;
97: END IF;
98: END IF;
99: -- Validate the appeal length
100: IF p_inserting OR (p_updating AND

Line 107: App_Exception.Raise_Exception;

103: new_references.appeal_length,
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 127: App_Exception.Raise_Exception;

123: new_references.prg_cal_type
124: ) THEN
125: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
126: IGS_GE_MSG_STACK.ADD;
127: App_Exception.Raise_Exception;
128: END IF;
129: END IF;
130:
131: IF (((old_references.s_control_num = new_references.s_control_num)) OR

Line 140: App_Exception.Raise_Exception;

136: new_references.s_control_num
137: ) THEN
138: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
139: IGS_GE_MSG_STACK.ADD;
140: App_Exception.Raise_Exception;
141: END IF;
142: END IF;
143:
144: END Check_Parent_Existance;

Line 193: App_Exception.Raise_Exception;

189: IF (cur_rowid%FOUND) THEN
190: Fnd_Message.Set_Name ('IGS', 'IGS_PR_SPCA_CAT_FK');
191: IGS_GE_MSG_STACK.ADD;
192: Close cur_rowid;
193: App_Exception.Raise_Exception;
194:
195: Return;
196: END IF;
197: Close cur_rowid;

Line 220: App_Exception.Raise_Exception;

216: IF (cur_rowid%FOUND) THEN
217: Fnd_Message.Set_Name ('IGS', 'IGS_PR_SPCA_SPGCC_FK');
218: IGS_GE_MSG_STACK.ADD;
219: Close cur_rowid;
220: App_Exception.Raise_Exception;
221:
222: Return;
223: END IF;
224: Close cur_rowid;

Line 268: App_Exception.Raise_Exception;

264: new_references.prg_cal_type
265: ) THEN
266: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
267: IGS_GE_MSG_STACK.ADD;
268: App_Exception.Raise_Exception;
269: END IF;
270: Check_Constraints;
271: Check_Parent_Existance;
272: ELSIF (p_action = 'UPDATE') THEN

Line 285: App_Exception.Raise_Exception;

281: new_references.prg_cal_type
282: ) THEN
283: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
284: IGS_GE_MSG_STACK.ADD;
285: App_Exception.Raise_Exception;
286: END IF;
287: Check_Constraints;
288: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
289: -- Call all the procedures related to Before Update.

Line 328: app_exception.raise_exception;

324: end if;
325: else
326: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
327: IGS_GE_MSG_STACK.ADD;
328: app_exception.raise_exception;
329: end if;
330:
331: Before_DML(
332: p_action=>'INSERT',

Line 404: app_exception.raise_exception;

400: if (c1%notfound) then
401: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
402: IGS_GE_MSG_STACK.ADD;
403: close c1;
404: app_exception.raise_exception;
405:
406: return;
407: end if;
408: close c1;

Line 422: app_exception.raise_exception;

418: null;
419: else
420: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
421: IGS_GE_MSG_STACK.ADD;
422: app_exception.raise_exception;
423: end if;
424: return;
425: end LOCK_ROW;
426:

Line 456: app_exception.raise_exception;

452: end if;
453: else
454: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
455: IGS_GE_MSG_STACK.ADD;
456: app_exception.raise_exception;
457: end if;
458:
459: Before_DML(
460: p_action=>'UPDATE',

Line 577: App_Exception.Raise_Exception ;

573: IF upper(Column_name) = 'S_CONTROL_NUM' OR COLUMN_NAME IS NULL THEN
574: IF new_references.S_CONTROL_NUM < 1 or new_references.S_CONTROL_NUM > 1 then
575: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
576: IGS_GE_MSG_STACK.ADD;
577: App_Exception.Raise_Exception ;
578: END IF;
579:
580: END IF ;
581:

Line 586: App_Exception.Raise_Exception ;

582: IF upper(Column_name) = 'STREAM_NUM' OR COLUMN_NAME IS NULL THEN
583: IF new_references.STREAM_NUM < 0 or new_references.STREAM_NUM > 99 then
584: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
585: IGS_GE_MSG_STACK.ADD;
586: App_Exception.Raise_Exception ;
587: END IF;
588:
589: END IF ;
590:

Line 595: App_Exception.Raise_Exception ;

591: IF upper(Column_name) = 'SHOW_CAUSE_LENGTH' OR COLUMN_NAME IS NULL THEN
592: IF new_references.SHOW_CAUSE_LENGTH < 0 or new_references.SHOW_CAUSE_LENGTH > 999 then
593: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
594: IGS_GE_MSG_STACK.ADD;
595: App_Exception.Raise_Exception ;
596: END IF;
597:
598: END IF ;
599:

Line 604: App_Exception.Raise_Exception ;

600: IF upper(Column_name) = 'APPEAL_LENGTH' OR COLUMN_NAME IS NULL THEN
601: IF new_references.APPEAL_LENGTH < 0 or new_references.APPEAL_LENGTH > 999 then
602: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
603: IGS_GE_MSG_STACK.ADD;
604: App_Exception.Raise_Exception ;
605: END IF;
606:
607: END IF ;
608:

Line 613: App_Exception.Raise_Exception ;

609: IF upper(Column_name) = 'PRG_CAL_TYPE' OR COLUMN_NAME IS NULL THEN
610: IF new_references.PRG_CAL_TYPE<> upper(new_references.PRG_CAL_TYPE) then
611: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
612: IGS_GE_MSG_STACK.ADD;
613: App_Exception.Raise_Exception ;
614: END IF;
615:
616: END IF ;
617: