[Home] [Help]
40: -- Populate Old Values.
41: OPEN cur_old_ref_values;
42: FETCH cur_old_ref_values INTO old_references;
43: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
44: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
45: igs_ge_msg_stack.add;
46: app_exception.raise_exception;
47: CLOSE cur_old_ref_values;
48: RETURN;
87: BEGIN
88: IF (p_inserting OR (p_updating AND (old_references.step_catalog_cd <> new_references.step_catalog_cd))) THEN
89: IF NOT IGS_TR_VAL_TRI.val_tr_step_ctlg (new_references.step_catalog_cd,
90: v_message_name) THEN
91: Fnd_Message.Set_Name('IGS', v_message_name);
92: IGS_GE_MSG_STACK.ADD;
93: App_Exception.Raise_Exception;
94: END IF;
95: END IF;
125: new_references.completion_dt,
126: new_references.by_pass_ind,
127: v_message_name) = FALSE THEN
128:
129: fnd_message.set_name('IGS',v_message_name);
130: igs_ge_msg_stack.add;
131: app_exception.raise_exception;
132: END IF;
133: END IF;
147: new_references.s_tracking_step_type,
148: v_tracking_type,
149: v_message_name) = FALSE THEN
150:
151: fnd_message.set_name('IGS',v_message_name);
152: igs_ge_msg_stack.add;
153: app_exception.raise_exception;
154: END IF;
155: END IF;
164: ((new_references.recipient_id IS NULL))) THEN
165: NULL;
166: ELSE
167: IF NOT igs_pe_person_pkg.get_pk_for_validation ( new_references.recipient_id )THEN
168: fnd_message.set_name('FND','FORM_RECORD_DELETED');
169: igs_ge_msg_stack.add;
170: app_exception.raise_exception;
171: END IF;
172: END IF;
175: ((new_references.s_tracking_step_type IS NULL))) THEN
176: NULL;
177: ELSE
178: IF NOT igs_lookups_view_pkg.get_pk_for_validation('TRACKING_STEP_TYPE',new_references.s_tracking_step_type)THEN
179: fnd_message.set_name('FND','FORM_RECORD_DELETED');
180: igs_ge_msg_stack.add;
181: app_exception.raise_exception;
182: END IF;
183: END IF;
185: IF (((old_references.tracking_id = new_references.tracking_id)) OR ((new_references.tracking_id IS NULL))) THEN
186: NULL;
187: ELSE
188: IF NOT igs_tr_item_pkg.get_pk_for_validation ( new_references.tracking_id )THEN
189: fnd_message.set_name('FND','FORM_RECORD_DELETED');
190: igs_ge_msg_stack.add;
191: app_exception.raise_exception;
192: END IF;
193: END IF;
195: IF (((old_references.step_catalog_cd = new_references.step_catalog_cd)) OR ((new_references.step_catalog_cd IS NULL))) THEN
196: NULL;
197: ELSE
198: IF NOT igs_tr_step_ctlg_pkg.get_uk_for_validation ( new_references.step_catalog_cd )THEN
199: fnd_message.set_name('FND','FORM_RECORD_DELETED');
200: igs_ge_msg_stack.add;
201: app_exception.raise_exception;
202: END IF;
203: END IF;
257: OPEN cur_rowid;
258: FETCH cur_rowid INTO lv_rowid;
259: IF (cur_rowid%FOUND) THEN
260: CLOSE cur_rowid;
261: fnd_message.set_name ('IGS', 'IGS_TR_TRST_PE_RECIPIENT_FK');
262: igs_ge_msg_stack.add;
263: app_exception.raise_exception;
264: RETURN;
265: END IF;
283: OPEN cur_rowid;
284: FETCH cur_rowid INTO lv_rowid;
285: IF (cur_rowid%FOUND) THEN
286: CLOSE cur_rowid;
287: fnd_message.set_name ('IGS', 'IGS_TR_TRST_TRI_FK');
288: igs_ge_msg_stack.add;
289: app_exception.raise_exception;
290: RETURN;
291: END IF;
310: OPEN cur_rowid;
311: FETCH cur_rowid INTO lv_rowid;
312: IF (cur_rowid%FOUND) THEN
313: CLOSE cur_rowid;
314: fnd_message.set_name ('IGS', 'IGS_TR_TRST_STST_FK');
315: igs_ge_msg_stack.add;
316: app_exception.raise_exception;
317: RETURN;
318: END IF;
346: END IF;
347:
348: IF UPPER(column_name) = 'TRACKING_STEP_NUMBER' OR column_name IS NULL THEN
349: IF (new_references.tracking_step_number < 1 OR new_references.tracking_step_number > 99 )THEN
350: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
351: igs_ge_msg_stack.add;
352: app_exception.raise_exception;
353: END IF;
354: END IF;
355:
356: --kumma, 2702342, increased the constant value from 999 to 9999
357: IF UPPER(column_name) = 'ACTION_DAYS' OR column_name IS NULL THEN
358: IF (new_references.action_days < 0 OR new_references.action_days > 9999 )THEN
359: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
360: igs_ge_msg_stack.add;
361: app_exception.raise_exception;
362: END IF;
363: END IF;
363: END IF;
364:
365: IF UPPER(column_name) = 'STEP_COMPLETION_IND' OR column_name IS NULL THEN
366: IF new_references.step_completion_ind NOT IN ('Y','N') THEN
367: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
368: igs_ge_msg_stack.add;
369: app_exception.raise_exception;
370: END IF;
371: END IF;
371: END IF;
372:
373: IF UPPER(column_name) = 'BY_PASS_IND' OR column_name IS NULL THEN
374: IF new_references.by_pass_ind NOT IN ('Y','N') THEN
375: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
376: igs_ge_msg_stack.add;
377: app_exception.raise_exception;
378: END IF;
379: END IF;
379: END IF;
380:
381: IF UPPER(column_name) = 'BY_PASS_IND' OR column_name IS NULL THEN
382: IF new_references.by_pass_ind <> UPPER(new_references.by_pass_ind) THEN
383: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
384: igs_ge_msg_stack.add;
385: app_exception.raise_exception;
386: END IF;
387: END IF;
387: END IF;
388:
389: IF UPPER(column_name) = 'STEP_COMPLETION_IND' OR column_name IS NULL THEN
390: IF new_references.step_completion_ind <> UPPER(new_references.step_completion_ind) THEN
391: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
392: igs_ge_msg_stack.add;
393: app_exception.raise_exception;
394: END IF;
395: END IF;
395: END IF;
396:
397: IF UPPER(column_name) = 'S_TRACKING_STEP_TYPE' OR column_name IS NULL THEN
398: IF new_references.s_tracking_step_type <> UPPER(new_references.s_tracking_step_type) THEN
399: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
400: igs_ge_msg_stack.add;
401: app_exception.raise_exception;
402: END IF;
403: END IF;
403: END IF;
404:
405: IF UPPER(column_name) = 'PUBLISH_IND' OR column_name IS NULL THEN
406: IF new_references.publish_ind <> UPPER(new_references.publish_ind) THEN
407: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
408: igs_ge_msg_stack.add;
409: app_exception.raise_exception;
410: END IF;
411: END IF;
411: END IF;
412:
413: IF UPPER(column_name) = 'PUBLISH_IND' OR column_name IS NULL THEN
414: IF new_references.publish_ind NOT IN ('Y','N') THEN
415: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
416: igs_ge_msg_stack.add;
417: app_exception.raise_exception;
418: END IF;
419: END IF;
475: IF get_pk_for_validation(
476: new_references.tracking_id,
477: new_references.tracking_step_id
478: )THEN
479: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
480: igs_ge_msg_stack.add;
481: app_exception.raise_exception;
482: END IF;
483: check_constraints;
500: IF get_pk_for_validation(
501: new_references.tracking_id,
502: new_references.tracking_step_id
503: )THEN
504: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
505: igs_ge_msg_stack.add;
506: app_exception.raise_exception;
507: END IF;
508: check_constraints;
582: x_program_update_date := SYSDATE;
583: END IF;
584:
585: ELSE
586: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
587: igs_ge_msg_stack.add;
588: app_exception.raise_exception;
589: END IF;
590:
699:
700: OPEN c1;
701: FETCH c1 INTO tlinfo;
702: IF (c1%NOTFOUND) THEN
703: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
704: igs_ge_msg_stack.add;
705: app_exception.raise_exception;
706: CLOSE c1;
707: RETURN;
734: ) THEN
735: NULL;
736:
737: ELSE
738: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
739: igs_ge_msg_stack.add;
740: app_exception.raise_exception;
741: END IF;
742: RETURN;
781: IF x_last_update_login IS NULL THEN
782: x_last_update_login := -1;
783: END IF;
784: ELSE
785: fnd_message.set_name('FND', 'SYSTEM-INVALID ARGS');
786: igs_ge_msg_stack.add;
787: app_exception.raise_exception;
788: END IF;
789: