DBA Data[Home] [Help]

APPS.JTF_EC_REFERENCES_PVT dependencies on FND_MSG_PUB

Line 65: fnd_msg_pub.initialize;

61: END IF;
62:
63: IF fnd_api.to_boolean (p_init_msg_list)
64: THEN
65: fnd_msg_pub.initialize;
66: END IF;
67:
68: -----
69: ----- Validate escaltion

Line 87: fnd_msg_pub.add;

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;
91:

Line 155: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

151: THEN
152: COMMIT WORK;
153: END IF;
154:
155: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
156:
157: --Created for BES enh 2660883
158: begin
159:

Line 180: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

176: WHEN fnd_api.g_exc_unexpected_error
177: THEN
178: ROLLBACK TO create_references_pub;
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);

Line 186: fnd_msg_pub.add;

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
190: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');

Line 193: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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:
196: /* PROCEDURE lock_references (
197: p_api_version IN NUMBER,

Line 286: fnd_msg_pub.initialize;

282: END IF;
283:
284: IF fnd_api.to_boolean (p_init_msg_list)
285: THEN
286: fnd_msg_pub.initialize;
287: END IF;
288:
289: IF p_escalation_reference_id IS NULL
290: THEN

Line 292: fnd_msg_pub.add;

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;
296:

Line 305: fnd_msg_pub.add;

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;
309:

Line 329: fnd_msg_pub.add;

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
333: WHEN NO_DATA_FOUND

Line 339: fnd_msg_pub.add;

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;
343:

Line 411: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

407: THEN
408: COMMIT WORK;
409: END IF;
410:
411: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
412:
413:
414: jtf_esc_wf_events_pvt.publish_update_escRef
415: (P_ESC_REF_REC_OLD => l_esc_ref_rec_old,

Line 428: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

424: WHEN fnd_api.g_exc_unexpected_error
425: THEN
426: ROLLBACK TO update_references_pub;
427: x_return_status := fnd_api.g_ret_sts_unexp_error;
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');

Line 435: fnd_msg_pub.add;

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
439: ROLLBACK TO update_references_pub;

Line 442: fnd_msg_pub.add;

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;
446:

Line 444: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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;
446:
447: ---------
448: ---------

Line 493: fnd_msg_pub.initialize;

489: END IF;
490:
491: IF fnd_api.to_boolean (p_init_msg_list)
492: THEN
493: fnd_msg_pub.initialize;
494: END IF;
495:
496: --Created for BES enh 2660883
497: OPEN c_ref_orig (p_escalation_reference_id);

Line 523: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

519: THEN
520: COMMIT WORK;
521: END IF;
522:
523: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
524:
525: --Created for BES enh 2660883
526: begin
527:

Line 547: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

543: WHEN fnd_api.g_exc_unexpected_error
544: THEN
545: ROLLBACK TO delete_task_reference_pub;
546: x_return_status := fnd_api.g_ret_sts_unexp_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');

Line 554: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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:
557: END;