[Home] [Help]
43: OPEN cur_old_ref_values;
44: FETCH cur_old_ref_values INTO old_references;
45: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
46: CLOSE cur_old_ref_values;
47: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
48: igs_ge_msg_stack.add;
49: app_exception.raise_exception;
50: RETURN;
51: END IF;
92:
93: -- Validate the tracking status.
94: IF p_inserting OR (old_references.tracking_status <> new_references.tracking_status) THEN
95: IF igs_tr_val_tri.trkp_val_tri_status (new_references.tracking_status,p_inserting,v_message_name) = FALSE THEN
96: fnd_message.set_name('IGS',v_message_name);
97: igs_ge_msg_stack.add;
98: app_exception.raise_exception;
99: END IF;
100: END IF;
101:
102: -- Validate the tracking type.
103: IF p_inserting OR (old_references.tracking_type <> new_references.tracking_type) THEN
104: IF igs_tr_val_tri.trkp_val_tri_type (new_references.tracking_type, 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: -- Validate the start date.
112: IF p_inserting OR (old_references.start_dt <> new_references.start_dt) THEN
113: IF igs_tr_val_tri.trkp_val_tri_strt_dt ( new_references.start_dt, v_message_name) = FALSE THEN
114: fnd_message.set_name('IGS',v_message_name);
115: igs_ge_msg_stack.add;
116: app_exception.raise_exception;
117: END IF;
118: END IF;
134:
135: IF p_inserting THEN
136: igs_tr_gen_002.trkp_ins_dflt_trst ( new_references.tracking_id, v_message_name);
137: IF v_message_name <> NULL THEN
138: fnd_message.set_name('IGS',v_message_name);
139: igs_ge_msg_stack.add;
140: app_exception.raise_exception;
141: END IF;
142: END IF;
186: END IF ;
187:
188: IF UPPER(column_name) = 'TRACKING_STATUS' OR column_name IS NULL THEN
189: IF new_references.tracking_status<> UPPER(new_references.tracking_status) THEN
190: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
191: igs_ge_msg_stack.add;
192: app_exception.raise_exception ;
193: END IF;
194: END IF ;
194: END IF ;
195:
196: IF UPPER(column_name) = 'TRACKING_TYPE' OR column_name IS NULL THEN
197: IF new_references.tracking_type<> UPPER(new_references.tracking_type) THEN
198: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
199: igs_ge_msg_stack.add;
200: app_exception.raise_exception ;
201: END IF;
202: END IF ;
202: END IF ;
203:
204: IF UPPER(column_name) = 'SEQUENCE_IND' OR column_name IS NULL THEN
205: IF new_references.sequence_ind NOT IN ('Y','N') THEN
206: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
207: igs_ge_msg_stack.add;
208: app_exception.raise_exception ;
209: END IF;
210:
211: END IF ;
212: --kumma, 2702342, Increased the value of constant from 999 to 9999
213: IF UPPER(column_name) = 'TARGET_DAYS' OR column_name IS NULL THEN
214: IF new_references.target_days < 0 OR new_references.target_days > 9999 THEN
215: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
216: igs_ge_msg_stack.add;
217: app_exception.raise_exception ;
218: END IF;
219: END IF ;
219: END IF ;
220:
221: IF UPPER(column_name) = 'TRACKING_ID' OR column_name IS NULL THEN
222: IF new_references.tracking_id < 1 OR new_references.tracking_id > 999999999 THEN
223: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
224: igs_ge_msg_stack.add;
225: app_exception.raise_exception ;
226: END IF;
227: END IF ;
227: END IF ;
228:
229: IF UPPER(column_name) = 'BUSINESS_DAYS_IND' OR column_name IS NULL THEN
230: IF new_references.business_days_ind NOT IN ('Y','N') THEN
231: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
232: igs_ge_msg_stack.add;
233: app_exception.raise_exception ;
234: END IF;
235: END IF ;
235: END IF ;
236:
237: IF UPPER(column_name) = 'S_CREATED_IND' OR column_name IS NULL THEN
238: IF new_references.s_created_ind NOT IN ('Y','N') THEN
239: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
240: igs_ge_msg_stack.add;
241: app_exception.raise_exception ;
242: END IF;
243: END IF ;
243: END IF ;
244:
245: IF UPPER(column_name) = 'OVERRIDE_OFFSET_CLC_IND' OR column_name IS NULL THEN
246: IF new_references.override_offset_clc_ind NOT IN ('Y','N') THEN
247: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
248: igs_ge_msg_stack.add;
249: app_exception.raise_exception;
250: END IF;
251: END IF;
251: END IF;
252:
253: IF UPPER(column_name) = 'PUBLISH_IND' OR column_name IS NULL THEN
254: IF new_references.publish_ind NOT IN ('Y','N') THEN
255: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
256: igs_ge_msg_stack.add;
257: app_exception.raise_exception;
258: END IF;
259: END IF;
260:
261: IF column_name IS NULL THEN
262: IF (new_references.sequence_ind = 'Y' OR new_references.business_days_ind = 'Y') AND
263: new_references.override_offset_clc_ind = 'Y' THEN
264: fnd_message.set_name('IGS','IGS_TR_CANNOT_CHK_SEQ_OR_BD');
265: igs_ge_msg_stack.add;
266: app_exception.raise_exception;
267: END IF;
268: END IF;
276: ((new_references.source_person_id IS NULL))) THEN
277: NULL;
278: ELSE
279: IF NOT igs_pe_person_pkg.get_pk_for_validation ( new_references.source_person_id ) THEN
280: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
281: igs_ge_msg_stack.add;
282: app_exception.raise_exception;
283: END IF;
284: END IF;
287: ((new_references.originator_person_id IS NULL))) THEN
288: NULL;
289: ELSE
290: IF NOT igs_pe_person_pkg.get_pk_for_validation ( new_references.originator_person_id ) THEN
291: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
292: igs_ge_msg_stack.add;
293: app_exception.raise_exception;
294: END IF;
295: END IF;
298: ((new_references.tracking_status IS NULL))) THEN
299: NULL;
300: ELSE
301: IF NOT igs_tr_status_pkg.get_pk_for_validation ( new_references.tracking_status ) THEN
302: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
303: igs_ge_msg_stack.add;
304: app_exception.raise_exception;
305: END IF;
306: END IF;
309: ((new_references.tracking_type IS NULL))) THEN
310: NULL;
311: ELSE
312: IF NOT igs_tr_type_pkg.get_pk_for_validation ( new_references.tracking_type ) THEN
313: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
314: igs_ge_msg_stack.add;
315: app_exception.raise_exception;
316: END IF;
317: END IF;
399: OPEN cur_rowid;
400: FETCH cur_rowid INTO lv_rowid;
401: IF (cur_rowid%FOUND) THEN
402: CLOSE cur_rowid;
403: fnd_message.set_name ('IGS', 'IGS_TR_TRI_PE_FK');
404: igs_ge_msg_stack.add;
405: app_exception.raise_exception;
406: RETURN;
407: END IF;
460:
461: IF (p_action = 'INSERT') THEN
462: beforerowinsertupdate1 ( p_inserting => TRUE );
463: IF get_pk_for_validation ( new_references.tracking_id ) THEN
464: fnd_message.set_name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
465: igs_ge_msg_stack.add;
466: app_exception.raise_exception;
467: END IF;
468: check_constraints;
478:
479: ELSIF (p_action = 'VALIDATE_INSERT') THEN
480: beforerowinsertupdate1 ( p_inserting => TRUE );
481: IF get_pk_for_validation ( new_references.tracking_id ) THEN
482: fnd_message.set_name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
483: igs_ge_msg_stack.add;
484: app_exception.raise_exception;
485: END IF;
486: check_constraints;
579: x_program_update_date := SYSDATE;
580: END IF;
581:
582: ELSE
583: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
584: igs_ge_msg_stack.add;
585: app_exception.raise_exception;
586: END IF;
587:
705: OPEN c1;
706: FETCH c1 INTO tlinfo;
707: IF (c1%NOTFOUND) THEN
708: CLOSE c1;
709: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
710: igs_ge_msg_stack.add;
711: app_exception.raise_exception;
712: RETURN;
713: END IF;
735: AND (x_completion_due_dt IS NULL)))
736: ) THEN
737: NULL;
738: ELSE
739: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
740: igs_ge_msg_stack.add;
741: app_exception.raise_exception;
742: END IF;
743: RETURN;
789: x_last_update_login := -1;
790: END IF;
791:
792: ELSE
793: fnd_message.set_name('FND', 'SYSTEM-INVALID ARGS');
794: igs_ge_msg_stack.add;
795: app_exception.raise_exception;
796: END IF;
797: