67: fnd_msg_pub.initialize;
68: END IF;
69:
70: -- 2102281
71: if not (jtf_task_utl.check_duplicate_reference(p_task_id, p_object_id, p_object_type_code))
72: then
73: if (jtf_task_utl.g_show_error_for_dup_reference)
74: then
75: fnd_message.set_name('JTF','JTF_TASK_DUPLICATE_REF');
69:
70: -- 2102281
71: if not (jtf_task_utl.check_duplicate_reference(p_task_id, p_object_id, p_object_type_code))
72: then
73: if (jtf_task_utl.g_show_error_for_dup_reference)
74: then
75: fnd_message.set_name('JTF','JTF_TASK_DUPLICATE_REF');
76: fnd_message.set_token('P_OBJECT_NAME',p_object_name);
77: fnd_message.set_token('P_OBJECT_TYPE',p_object_type_code);
77: fnd_message.set_token('P_OBJECT_TYPE',p_object_type_code);
78: fnd_msg_pub.add;
79: RAISE fnd_api.g_exc_unexpected_error;
80: else
81: jtf_task_utl.g_show_error_for_dup_reference := True;
82: return;
83: end if;
84: end if;
85:
88: SELECT jtf_task_references_s.nextval
89: INTO l_task_reference_id
90: FROM dual;
91:
92: /* Made a call to the function jtf_task_utl.check_truncation, since it was inserting Party Name
93: which was greater than 80 characters */
94: jtf_task_references_pkg.insert_row (
95: x_rowid => l_rowid,
96: x_task_reference_id => l_task_reference_id,
95: x_rowid => l_rowid,
96: x_task_reference_id => l_task_reference_id,
97: x_task_id => p_task_id,
98: x_object_type_code => p_object_type_code,
99: x_object_name => jtf_task_utl.check_truncation(p_object_name),
100: x_object_id => p_object_id,
101: x_object_details => NVL(p_object_details, -- For fixing bug 2896532
102: jtf_task_utl_ext.get_object_details(
103: p_object_type_code
98: x_object_type_code => p_object_type_code,
99: x_object_name => jtf_task_utl.check_truncation(p_object_name),
100: x_object_id => p_object_id,
101: x_object_details => NVL(p_object_details, -- For fixing bug 2896532
102: jtf_task_utl_ext.get_object_details(
103: p_object_type_code
104: ,p_object_id)),
105: x_reference_code => p_reference_code,
106: x_usage => p_usage,
104: ,p_object_id)),
105: x_reference_code => p_reference_code,
106: x_usage => p_usage,
107: x_creation_date => SYSDATE,
108: x_created_by => jtf_task_utl.created_by,
109: x_last_update_date => SYSDATE,
110: x_last_updated_by => jtf_task_utl.updated_by,
111: x_last_update_login => jtf_task_utl.login_id,
112: x_attribute1 => p_attribute1 ,
106: x_usage => p_usage,
107: x_creation_date => SYSDATE,
108: x_created_by => jtf_task_utl.created_by,
109: x_last_update_date => SYSDATE,
110: x_last_updated_by => jtf_task_utl.updated_by,
111: x_last_update_login => jtf_task_utl.login_id,
112: x_attribute1 => p_attribute1 ,
113: x_attribute2 => p_attribute2 ,
114: x_attribute3 => p_attribute3 ,
107: x_creation_date => SYSDATE,
108: x_created_by => jtf_task_utl.created_by,
109: x_last_update_date => SYSDATE,
110: x_last_updated_by => jtf_task_utl.updated_by,
111: x_last_update_login => jtf_task_utl.login_id,
112: x_attribute1 => p_attribute1 ,
113: x_attribute2 => p_attribute2 ,
114: x_attribute3 => p_attribute3 ,
115: x_attribute4 => p_attribute4 ,
178: p_usage IN VARCHAR2 DEFAULT NULL,
179: x_return_status OUT NOCOPY VARCHAR2,
180: x_msg_count OUT NOCOPY NUMBER,
181: x_msg_data OUT NOCOPY VARCHAR2,
182: p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
183: p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
184: p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
185: p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
186: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
179: x_return_status OUT NOCOPY VARCHAR2,
180: x_msg_count OUT NOCOPY NUMBER,
181: x_msg_data OUT NOCOPY VARCHAR2,
182: p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
183: p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
184: p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
185: p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
186: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
187: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
180: x_msg_count OUT NOCOPY NUMBER,
181: x_msg_data OUT NOCOPY VARCHAR2,
182: p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
183: p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
184: p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
185: p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
186: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
187: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
188: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
181: x_msg_data OUT NOCOPY VARCHAR2,
182: p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
183: p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
184: p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
185: p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
186: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
187: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
188: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
189: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
182: p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
183: p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
184: p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
185: p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
186: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
187: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
188: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
189: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
190: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
183: p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
184: p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
185: p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
186: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
187: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
188: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
189: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
190: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
191: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
184: p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
185: p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
186: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
187: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
188: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
189: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
190: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
191: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
192: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
185: p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
186: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
187: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
188: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
189: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
190: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
191: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
192: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
193: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
186: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
187: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
188: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
189: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
190: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
191: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
192: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
193: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
194: p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
187: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
188: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
189: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
190: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
191: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
192: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
193: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
194: p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
195: p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
188: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
189: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
190: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
191: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
192: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
193: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
194: p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
195: p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
196: p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
189: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
190: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
191: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
192: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
193: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
194: p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
195: p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
196: p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
197: p_attribute_category IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
190: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
191: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
192: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
193: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
194: p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
195: p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
196: p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
197: p_attribute_category IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
198: )
191: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
192: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
193: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
194: p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
195: p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
196: p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
197: p_attribute_category IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
198: )
199: IS
192: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
193: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
194: p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
195: p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
196: p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
197: p_attribute_category IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
198: )
199: IS
200: l_api_name VARCHAR2(30) := 'UPDATE_REFERENCES';
193: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
194: p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
195: p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
196: p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
197: p_attribute_category IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
198: )
199: IS
200: l_api_name VARCHAR2(30) := 'UPDATE_REFERENCES';
201: l_api_version CONSTANT NUMBER := 1.0;
282: l_reference_code := task_references.reference_code;
283: l_object_type_code := task_references.object_type_code;
284: l_object_id := task_references.object_id;
285:
286: /* Made a call to the function jtf_task_utl.check_truncation, since it was inserting Party Name
287: which was greater than 80 characters */
288:
289: l_object_name := jtf_task_utl.check_truncation(task_references.object_name);
290: l_object_details := task_references.object_details;
285:
286: /* Made a call to the function jtf_task_utl.check_truncation, since it was inserting Party Name
287: which was greater than 80 characters */
288:
289: l_object_name := jtf_task_utl.check_truncation(task_references.object_name);
290: l_object_details := task_references.object_details;
291: l_reference_code := task_references.reference_code;
292: l_usage := task_references.usage;
293:
293:
294: -- 2102281
295: /*
296: Bug 3360228
297: For update, calling jtf_task_utl_ext.check_dup_reference_for_update for
298: checking duplicates instead of.
299: */
300: if not (jtf_task_utl_ext.check_dup_reference_for_update(l_task_reference_id, l_task_id, l_object_id, l_object_type_code))
301: then
296: Bug 3360228
297: For update, calling jtf_task_utl_ext.check_dup_reference_for_update for
298: checking duplicates instead of.
299: */
300: if not (jtf_task_utl_ext.check_dup_reference_for_update(l_task_reference_id, l_task_id, l_object_id, l_object_type_code))
301: then
302: if (jtf_task_utl.g_show_error_for_dup_reference)
303: then
304: fnd_message.set_name('JTF','JTF_TASK_DUPLICATE_REF');
298: checking duplicates instead of.
299: */
300: if not (jtf_task_utl_ext.check_dup_reference_for_update(l_task_reference_id, l_task_id, l_object_id, l_object_type_code))
301: then
302: if (jtf_task_utl.g_show_error_for_dup_reference)
303: then
304: fnd_message.set_name('JTF','JTF_TASK_DUPLICATE_REF');
305: fnd_message.set_token('P_OBJECT_NAME',l_object_name);
306: fnd_message.set_token('P_OBJECT_TYPE',l_object_type_code);
306: fnd_message.set_token('P_OBJECT_TYPE',l_object_type_code);
307: fnd_msg_pub.add;
308: RAISE fnd_api.g_exc_unexpected_error;
309: else
310: jtf_task_utl.g_show_error_for_dup_reference := True;
311: return;
312: end if;
313: end if;
314:
355: x_attribute15 => task_references.attribute15 ,
356: x_attribute_category => task_references.attribute_category,
357: x_usage => l_usage,
358: x_last_update_date => SYSDATE,
359: x_last_updated_by => jtf_task_utl.updated_by,
360: x_last_update_login => jtf_task_utl.login_id,
361: x_object_version_number => p_object_version_number
362: );
363:
356: x_attribute_category => task_references.attribute_category,
357: x_usage => l_usage,
358: x_last_update_date => SYSDATE,
359: x_last_updated_by => jtf_task_utl.updated_by,
360: x_last_update_login => jtf_task_utl.login_id,
361: x_object_version_number => p_object_version_number
362: );
363:
364: EXCEPTION
433: --JTF_TASKS_PVT calls this API with p_from_task_api ='Y'. Bug number 3995359
434:
435: IF (p_from_task_api ='N') THEN
436:
437: if not (jtf_task_utl.check_reference_delete(l_task_id, l_object_id))
438: THEN
439: if not (jtf_task_utl.g_show_error_for_dup_reference) then
440: jtf_task_utl.g_show_error_for_dup_reference := True;
441: end if;
435: IF (p_from_task_api ='N') THEN
436:
437: if not (jtf_task_utl.check_reference_delete(l_task_id, l_object_id))
438: THEN
439: if not (jtf_task_utl.g_show_error_for_dup_reference) then
440: jtf_task_utl.g_show_error_for_dup_reference := True;
441: end if;
442:
443: --The API returns the message JTF_TASK_ERROR_NO_REFERENCES when you try to
436:
437: if not (jtf_task_utl.check_reference_delete(l_task_id, l_object_id))
438: THEN
439: if not (jtf_task_utl.g_show_error_for_dup_reference) then
440: jtf_task_utl.g_show_error_for_dup_reference := True;
441: end if;
442:
443: --The API returns the message JTF_TASK_ERROR_NO_REFERENCES when you try to
444: --delete references which are created automically for the customer when the