APPS.IGS_TR_STATUS_PKG dependencies on APP_EXCEPTION

Line 58: app_exception.raise_exception;

54: FETCH cur_old_ref_values INTO old_references;
55: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
56: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
57: igs_ge_msg_stack.add;
58: app_exception.raise_exception;
59: CLOSE cur_old_ref_values;
60: RETURN;
61: END IF;
62: CLOSE cur_old_ref_values;

Line 133: app_exception.raise_exception;

129: IF UPPER(column_name) = 'S_TRACKING_STATUS' OR column_name IS NULL THEN
130: IF new_references.s_tracking_status NOT IN ('ACTIVE','CANCELLED','COMPLETE')THEN
131: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
132: igs_ge_msg_stack.add;
133: app_exception.raise_exception;
134: END IF;
135: END IF;
136:
137: IF UPPER(column_name) = 'CLOSED_IND' OR column_name IS NULL THEN

Line 141: app_exception.raise_exception;

137: IF UPPER(column_name) = 'CLOSED_IND' OR column_name IS NULL THEN
138: IF new_references.closed_ind NOT IN ('Y','N') 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:
145: IF UPPER(column_name) = 'DEFAULT_IND' OR column_name IS NULL THEN

Line 149: app_exception.raise_exception;

145: IF UPPER(column_name) = 'DEFAULT_IND' OR column_name IS NULL THEN
146: IF new_references.default_ind NOT IN ('Y','N') THEN
147: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
148: igs_ge_msg_stack.add;
149: app_exception.raise_exception;
150: END IF;
151: END IF;
152:
153: IF UPPER(column_name) = 'S_TRACKING_STATUS' OR column_name IS NULL THEN

Line 157: app_exception.raise_exception;

153: IF UPPER(column_name) = 'S_TRACKING_STATUS' OR column_name IS NULL THEN
154: IF new_references.s_tracking_status <> UPPER(new_references.s_tracking_status) THEN
155: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
156: igs_ge_msg_stack.add;
157: app_exception.raise_exception;
158: END IF;
159: END IF;
160:
161: IF UPPER(column_name) = 'TRACKING_STATUS' OR column_name IS NULL THEN

Line 165: app_exception.raise_exception;

161: IF UPPER(column_name) = 'TRACKING_STATUS' OR column_name IS NULL THEN
162: IF new_references.tracking_status <> UPPER(new_references.tracking_status) 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: END check_constraints;

Line 226: app_exception.raise_exception;

222: NULL;
223: IF get_pk_for_validation( new_references.tracking_status )THEN
224: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
225: igs_ge_msg_stack.add;
226: app_exception.raise_exception;
227: END IF;
228: check_constraints;
229:
230: ELSIF (p_action = 'UPDATE') THEN

Line 239: app_exception.raise_exception;

235: -- Call all the procedures related to Before Delete.
236: IF get_pk_for_validation( new_references.tracking_status )THEN
237: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
238: igs_ge_msg_stack.add;
239: app_exception.raise_exception;
240: END IF;
241: check_constraints;
242: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
243: -- Call all the procedures related to Before Delete.

Line 333: app_exception.raise_exception;

329: END IF;
330: ELSE
331: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
332: igs_ge_msg_stack.add;
333: app_exception.raise_exception;
334: END IF;
335:
336: before_dml(p_action =>'INSERT',
337: x_rowid =>x_rowid,

Line 430: app_exception.raise_exception;

426:
427: IF (c1%NOTFOUND) THEN
428: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
429: igs_ge_msg_stack.add;
430: app_exception.raise_exception;
431: CLOSE c1;
432: RETURN;
433: END IF;
434: CLOSE c1;

Line 443: app_exception.raise_exception;

439: NULL;
440: ELSE
441: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
442: igs_ge_msg_stack.add;
443: app_exception.raise_exception;
444: END IF;
445: RETURN;
446:
447: END lock_row;

Line 501: app_exception.raise_exception;

497: END IF;
498: ELSE
499: fnd_message.set_name('FND', 'SYSTEM-INVALID ARGS');
500: igs_ge_msg_stack.add;
501: app_exception.raise_exception;
502: END IF;
503:
504: before_dml(p_action =>'UPDATE',
505: x_rowid =>x_rowid,