APPS.IGS_TR_STATUS_PKG dependencies on IGS_GE_MSG_STACK

Line 57: igs_ge_msg_stack.add;

53:
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;

Line 132: igs_ge_msg_stack.add;

128:
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:

Line 140: igs_ge_msg_stack.add;

136:
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:

Line 148: igs_ge_msg_stack.add;

144:
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:

Line 156: igs_ge_msg_stack.add;

152:
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:

Line 164: igs_ge_msg_stack.add;

160:
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:

Line 225: igs_ge_msg_stack.add;

221: -- Call all the procedures related to Before Insert.
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:

Line 238: igs_ge_msg_stack.add;

234: ELSIF (p_action = 'VALIDATE_INSERT') THEN
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

Line 332: igs_ge_msg_stack.add;

328: x_last_update_login := -1;
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',

Line 429: igs_ge_msg_stack.add;

425: FETCH c1 INTO tlinfo;
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;

Line 442: igs_ge_msg_stack.add;

438: AND (tlinfo.closed_ind = x_closed_ind)) THEN
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:

Line 500: igs_ge_msg_stack.add;

496: x_last_update_login := -1;
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',