[Home] [Help]
52: OPEN cur_old_ref_values;
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;
127: END IF;
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;
135: END IF;
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;
143: END IF;
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;
151: END IF;
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;
159: END IF;
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;
220: IF (p_action = 'INSERT') THEN
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;
233: check_constraints;
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;
327: IF x_last_update_login IS NULL THEN
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:
424: OPEN c1;
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;
437: AND (tlinfo.s_tracking_status = x_s_tracking_status)
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;
495: IF x_last_update_login IS NULL THEN
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: