APPS.CSP_TO_FORM_MOLINES dependencies on JTF_TASK_ASSIGNMENTS

Line 207: FROM jtf_task_assignments

203: IF nvl(p_task_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
204: -- validate the task_assignment_id against the task_id.
205: BEGIN
206: SELECT task_assignment_id INTO l_check_existence
207: FROM jtf_task_assignments
208: WHERE task_assignment_id = p_task_assignment_id
209: AND task_id = p_task_id;
210: EXCEPTION
211: WHEN NO_DATA_FOUND THEN

Line 221: fnd_message.set_token('TABLE', 'JTF_TASK_ASSIGNMENTS', FALSE);

217: WHEN OTHERS THEN
218: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
219: fnd_message.set_token('ERR_FIELD', 'p_task_assignment_id', FALSE);
220: fnd_message.set_token('ROUTINE', l_pkg_api_name, FALSE);
221: fnd_message.set_token('TABLE', 'JTF_TASK_ASSIGNMENTS', FALSE);
222: FND_MSG_PUB.ADD;
223: RAISE EXCP_USER_DEFINED;
224: END;
225: ELSE

Line 228: FROM jtf_task_assignments

224: END;
225: ELSE
226: BEGIN
227: SELECT task_assignment_id INTO l_check_existence
228: FROM jtf_task_assignments
229: WHERE task_assignment_id = p_task_assignment_id;
230: EXCEPTION
231: WHEN NO_DATA_FOUND THEN
232: FND_MESSAGE.SET_NAME('JTF', 'JTF_TASK_INV_TK_ASS');

Line 240: fnd_message.set_token('TABLE', 'JTF_TASK_ASSIGNMENTS', FALSE);

236: WHEN OTHERS THEN
237: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
238: fnd_message.set_token('ERR_FIELD', 'p_task_assignment_id', FALSE);
239: fnd_message.set_token('ROUTINE', l_pkg_api_name, FALSE);
240: fnd_message.set_token('TABLE', 'JTF_TASK_ASSIGNMENTS', FALSE);
241: FND_MSG_PUB.ADD;
242: RAISE EXCP_USER_DEFINED;
243: END;
244: END IF;

Line 369: FROM jtf_task_assignments

365:
366: IF nvl(l_task_assignment_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
367: BEGIN
368: SELECT task_assignment_id INTO l_check_existence
369: FROM jtf_task_assignments
370: WHERE task_assignment_id = l_task_assignment_id
371: AND task_id = l_task_id;
372: EXCEPTION
373: WHEN NO_DATA_FOUND THEN

Line 383: fnd_message.set_token('TABLE', 'JTF_TASK_ASSIGNMENTS', FALSE);

379: WHEN OTHERS THEN
380: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
381: fnd_message.set_token('ERR_FIELD', 'p_task_assignment_id', FALSE);
382: fnd_message.set_token('ROUTINE', l_pkg_api_name, FALSE);
383: fnd_message.set_token('TABLE', 'JTF_TASK_ASSIGNMENTS', FALSE);
384: FND_MSG_PUB.ADD;
385: RAISE EXCP_USER_DEFINED;
386: END;
387: END IF;

Line 403: FROM jtf_task_assignments

399: IF nvl(l_task_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
400: -- validate the task_assignment_id against the task_id.
401: BEGIN
402: SELECT task_assignment_id INTO l_check_existence
403: FROM jtf_task_assignments
404: WHERE task_assignment_id = p_task_assignment_id
405: AND task_id = l_task_id;
406: EXCEPTION
407: WHEN NO_DATA_FOUND THEN

Line 417: fnd_message.set_token('TABLE', 'JTF_TASK_ASSIGNMENTS', FALSE);

413: WHEN OTHERS THEN
414: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
415: fnd_message.set_token('ERR_FIELD', 'p_task_assignment_id', FALSE);
416: fnd_message.set_token('ROUTINE', l_pkg_api_name, FALSE);
417: fnd_message.set_token('TABLE', 'JTF_TASK_ASSIGNMENTS', FALSE);
418: FND_MSG_PUB.ADD;
419: RAISE EXCP_USER_DEFINED;
420: END;
421: ELSE

Line 424: FROM jtf_task_assignments

420: END;
421: ELSE
422: BEGIN
423: SELECT task_assignment_id INTO l_check_existence
424: FROM jtf_task_assignments
425: WHERE task_assignment_id = p_task_assignment_id;
426: EXCEPTION
427: WHEN NO_DATA_FOUND THEN
428: FND_MESSAGE.SET_NAME('JTF', 'JTF_TASK_INV_TK_ASS');

Line 436: fnd_message.set_token('TABLE', 'JTF_TASK_ASSIGNMENTS', FALSE);

432: WHEN OTHERS THEN
433: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
434: fnd_message.set_token('ERR_FIELD', 'p_task_assignment_id', FALSE);
435: fnd_message.set_token('ROUTINE', l_pkg_api_name, FALSE);
436: fnd_message.set_token('TABLE', 'JTF_TASK_ASSIGNMENTS', FALSE);
437: FND_MSG_PUB.ADD;
438: RAISE EXCP_USER_DEFINED;
439: END;
440: END IF;