86: END IF;
87:
88:
89:
90: jtf_task_utl.validate_task (
91: x_return_status => x_return_status,
92: p_task_id => l_task_id,
93: p_task_number => l_task_number,
94: x_task_id => l_task_id
109: x_return_status := fnd_api.g_ret_sts_unexp_error;
110: RAISE fnd_api.g_exc_unexpected_error;
111: END IF;
112: ----
113: ---- Commenting to use the common code from jtf_task_utl.
114: ---- Also, the validation was incorrect since it was validating the id from the name. rather than vide versa.
115: ----
116: ----
117:
117:
118: -------
119: ------- Validate source object details
120: -------
121: jtf_task_utl.validate_source_object (
122: p_object_code => p_object_type_code,
123: p_object_id => p_object_id ,
124: p_object_name => p_object_name,
125: x_return_status => x_return_status
132: END IF;
133:
134:
135:
136: /* jtf_task_utl.validate_object_type (
137: p_object_code => l_object_type_code,
138: p_object_type_name => NULL,
139: x_return_status => x_return_status,
140: x_object_code => l_object_type_code
239: END IF;
240: END IF;
241:
242: -- Parameter initialized to false to ignore error messages - Enh # 2102281
243: jtf_task_utl.g_show_error_for_dup_reference := False;
244: jtf_task_references_pvt.create_references (
245: p_api_version => 1.0,
246: p_init_msg_list => fnd_api.g_false,
247: p_commit => fnd_api.g_false,
506: p_usage IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
507: x_return_status OUT NOCOPY VARCHAR2,
508: x_msg_data OUT NOCOPY VARCHAR2,
509: x_msg_count OUT NOCOPY NUMBER,
510: p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
511: p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
512: p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
513: p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
514: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
507: x_return_status OUT NOCOPY VARCHAR2,
508: x_msg_data OUT NOCOPY VARCHAR2,
509: x_msg_count OUT NOCOPY NUMBER,
510: p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
511: p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
512: p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
513: p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
514: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
515: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
508: x_msg_data OUT NOCOPY VARCHAR2,
509: x_msg_count OUT NOCOPY NUMBER,
510: p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
511: p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
512: p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
513: p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
514: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
515: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
516: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
509: x_msg_count OUT NOCOPY NUMBER,
510: p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
511: p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
512: p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
513: p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
514: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
515: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
516: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
517: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
510: p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
511: p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
512: p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
513: p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
514: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
515: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
516: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
517: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
518: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
511: p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
512: p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
513: p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
514: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
515: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
516: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
517: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
518: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
519: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
512: p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
513: p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
514: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
515: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
516: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
517: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
518: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
519: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
520: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
513: p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
514: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
515: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
516: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
517: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
518: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
519: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
520: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
521: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
514: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
515: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
516: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
517: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
518: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
519: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
520: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
521: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
522: p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
515: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
516: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
517: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
518: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
519: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
520: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
521: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
522: p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
523: p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
516: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
517: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
518: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
519: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
520: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
521: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
522: p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
523: p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
524: p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
517: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
518: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
519: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
520: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
521: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
522: p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
523: p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
524: p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
525: p_attribute_category IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
518: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
519: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
520: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
521: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
522: p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
523: p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
524: p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
525: p_attribute_category IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
526: )
519: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
520: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
521: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
522: p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
523: p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
524: p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
525: p_attribute_category IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
526: )
527: IS
520: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
521: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
522: p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
523: p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
524: p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
525: p_attribute_category IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
526: )
527: IS
528: l_api_version CONSTANT NUMBER := 1.0;
521: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
522: p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
523: p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
524: p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
525: p_attribute_category IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
526: )
527: IS
528: l_api_version CONSTANT NUMBER := 1.0;
529: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_REFERENCES';
610: -------- Validate Object Type
611: --------
612: l_object_type_code := task_references.object_type_code;
613:
614: jtf_task_utl.validate_object_type (
615: p_object_code => l_object_type_code,
616: p_object_type_name => NULL,
617: x_return_status => x_return_status,
618: x_object_code => l_object_type_code
654: ------- Validate source object details
655: -------
656:
657:
658: jtf_task_utl.validate_source_object (
659: p_object_code => task_references.object_type_code,
660: p_object_id => task_references.object_id ,
661: p_object_name => task_references.object_name,
662: x_return_status => x_return_status
678:
679: IF ( l_reference_code IS NOT NULL
680: AND l_reference_code <> task_references.reference_code)
681: THEN
682: jtf_task_utl.validate_reference_codes (p_reference_code => l_reference_code, x_return_status => x_return_status);
683:
684: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
685: THEN
686: x_return_status := fnd_api.g_ret_sts_unexp_error;
692:
693: --- Call the private ;
694:
695: -- Parameter initialized to false to ignore error messages - Enh # 2102281
696: jtf_task_utl.g_show_error_for_dup_reference := False;
697: jtf_task_references_pvt.update_references (
698: p_api_version => 1.0,
699: p_init_msg_list => fnd_api.g_false,
700: p_commit => fnd_api.g_false,