DBA Data[Home] [Help]

APPS.JTF_EC_REFERENCES_PVT dependencies on FND_MESSAGE

Line 86: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_TASK');

82: END IF;
83:
84: IF l_escalation_id IS NULL
85: THEN
86: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_TASK');
87: fnd_msg_pub.add;
88: x_return_status := fnd_api.g_ret_sts_unexp_error;
89: RAISE fnd_api.g_exc_unexpected_error;
90: END IF;

Line 183: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_OBJECT_NAME');

179: x_return_status := fnd_api.g_ret_sts_unexp_error;
180: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
181: WHEN NO_DATA_FOUND
182: THEN
183: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_OBJECT_NAME');
184: fnd_message.set_token ('P_OBJECT_TYPE_CODE', p_object_type_code);
185: fnd_message.set_token ('P_OBJECT_NAME', p_object_name);
186: fnd_msg_pub.add;
187: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 184: fnd_message.set_token ('P_OBJECT_TYPE_CODE', p_object_type_code);

180: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
181: WHEN NO_DATA_FOUND
182: THEN
183: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_OBJECT_NAME');
184: fnd_message.set_token ('P_OBJECT_TYPE_CODE', p_object_type_code);
185: fnd_message.set_token ('P_OBJECT_NAME', p_object_name);
186: fnd_msg_pub.add;
187: x_return_status := fnd_api.g_ret_sts_unexp_error;
188: WHEN OTHERS

Line 185: fnd_message.set_token ('P_OBJECT_NAME', p_object_name);

181: WHEN NO_DATA_FOUND
182: THEN
183: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_OBJECT_NAME');
184: fnd_message.set_token ('P_OBJECT_TYPE_CODE', p_object_type_code);
185: fnd_message.set_token ('P_OBJECT_NAME', p_object_name);
186: fnd_msg_pub.add;
187: x_return_status := fnd_api.g_ret_sts_unexp_error;
188: WHEN OTHERS
189: THEN

Line 190: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');

186: fnd_msg_pub.add;
187: x_return_status := fnd_api.g_ret_sts_unexp_error;
188: WHEN OTHERS
189: THEN
190: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
191: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
192: x_return_status := fnd_api.g_ret_sts_unexp_error;
193: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
194: END;

Line 191: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);

187: x_return_status := fnd_api.g_ret_sts_unexp_error;
188: WHEN OTHERS
189: THEN
190: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
191: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
192: x_return_status := fnd_api.g_ret_sts_unexp_error;
193: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
194: END;
195:

Line 291: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_REFER');

287: END IF;
288:
289: IF p_escalation_reference_id IS NULL
290: THEN
291: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_REFER');
292: fnd_msg_pub.add;
293: x_return_status := fnd_api.g_ret_sts_unexp_error;
294: RAISE fnd_api.g_exc_unexpected_error;
295: END IF;

Line 303: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_REFER');

299:
300:
301: IF c_escalation_reference%NOTFOUND
302: THEN
303: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_REFER');
304: fnd_message.set_token ('P_TASK_REFERENCE_ID', p_escalation_reference_id);
305: fnd_msg_pub.add;
306: x_return_status := fnd_api.g_ret_sts_unexp_error;
307: RAISE fnd_api.g_exc_unexpected_error;

Line 304: fnd_message.set_token ('P_TASK_REFERENCE_ID', p_escalation_reference_id);

300:
301: IF c_escalation_reference%NOTFOUND
302: THEN
303: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_REFER');
304: fnd_message.set_token ('P_TASK_REFERENCE_ID', p_escalation_reference_id);
305: fnd_msg_pub.add;
306: x_return_status := fnd_api.g_ret_sts_unexp_error;
307: RAISE fnd_api.g_exc_unexpected_error;
308: END IF;

Line 328: fnd_message.set_name ('JTF', 'JTF_EC_DUPLICATE_ESCALATION');

324: AND reference.object_id = p_object_id
325: AND tasks.task_status_id = status.task_status_id
326: AND status.closed_flag = 'Y';
327:
328: fnd_message.set_name ('JTF', 'JTF_EC_DUPLICATE_ESCALATION');
329: fnd_msg_pub.add;
330: x_return_status := fnd_api.g_ret_sts_unexp_error;
331: RAISE fnd_api.g_exc_unexpected_error;
332: EXCEPTION

Line 338: fnd_message.set_name ('JTF', 'JTF_EC_DUPLICATE_ESCALATION');

334: THEN
335: NULL;
336: WHEN TOO_MANY_ROWS
337: THEN
338: fnd_message.set_name ('JTF', 'JTF_EC_DUPLICATE_ESCALATION');
339: fnd_msg_pub.add;
340: x_return_status := fnd_api.g_ret_sts_unexp_error;
341: RAISE fnd_api.g_exc_unexpected_error;
342: END;

Line 432: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_OBJECT_NAME');

428: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
429: WHEN NO_DATA_FOUND
430: THEN
431: ROLLBACK TO update_references_pub;
432: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_OBJECT_NAME');
433: fnd_message.set_token ('P_OBJECT_TYPE_CODE', p_object_type_code);
434: fnd_message.set_token ('P_OBJECT_NAME', p_object_name);
435: fnd_msg_pub.add;
436: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 433: fnd_message.set_token ('P_OBJECT_TYPE_CODE', p_object_type_code);

429: WHEN NO_DATA_FOUND
430: THEN
431: ROLLBACK TO update_references_pub;
432: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_OBJECT_NAME');
433: fnd_message.set_token ('P_OBJECT_TYPE_CODE', p_object_type_code);
434: fnd_message.set_token ('P_OBJECT_NAME', p_object_name);
435: fnd_msg_pub.add;
436: x_return_status := fnd_api.g_ret_sts_unexp_error;
437: WHEN OTHERS

Line 434: fnd_message.set_token ('P_OBJECT_NAME', p_object_name);

430: THEN
431: ROLLBACK TO update_references_pub;
432: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_OBJECT_NAME');
433: fnd_message.set_token ('P_OBJECT_TYPE_CODE', p_object_type_code);
434: fnd_message.set_token ('P_OBJECT_NAME', p_object_name);
435: fnd_msg_pub.add;
436: x_return_status := fnd_api.g_ret_sts_unexp_error;
437: WHEN OTHERS
438: THEN

Line 440: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');

436: x_return_status := fnd_api.g_ret_sts_unexp_error;
437: WHEN OTHERS
438: THEN
439: ROLLBACK TO update_references_pub;
440: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
441: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
442: fnd_msg_pub.add;
443: x_return_status := fnd_api.g_ret_sts_unexp_error;
444: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 441: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);

437: WHEN OTHERS
438: THEN
439: ROLLBACK TO update_references_pub;
440: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
441: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
442: fnd_msg_pub.add;
443: x_return_status := fnd_api.g_ret_sts_unexp_error;
444: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
445: END;

Line 551: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');

547: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
548: WHEN OTHERS
549: THEN
550: ROLLBACK TO delete_task_reference_pub;
551: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
552: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
553: x_return_status := fnd_api.g_ret_sts_unexp_error;
554: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
555: END;

Line 552: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);

548: WHEN OTHERS
549: THEN
550: ROLLBACK TO delete_task_reference_pub;
551: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
552: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
553: x_return_status := fnd_api.g_ret_sts_unexp_error;
554: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
555: END;
556: