DBA Data[Home] [Help]

APPS.JTF_EC_PVT dependencies on FND_MSG_PUB

Line 83: fnd_msg_pub.initialize;

79: END IF;
80:
81: IF fnd_api.to_boolean (p_init_msg_list)
82: THEN
83: fnd_msg_pub.initialize;
84: END IF;
85:
86: IF p_escalation_name IS NULL
87: THEN

Line 89: fnd_msg_pub.add;

85:
86: IF p_escalation_name IS NULL
87: THEN
88: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_NAME');
89: fnd_msg_pub.add;
90: x_return_status := fnd_api.g_ret_sts_unexp_error;
91: RAISE fnd_api.g_exc_unexpected_error;
92: END IF;
93:

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

217: THEN
218: COMMIT WORK;
219: END IF;
220:
221: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
222:
223: --Created for BES enh 2660883
224: begin
225:

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

238: WHEN fnd_api.g_exc_unexpected_error
239: THEN
240: ROLLBACK TO create_escalation_pvt;
241: x_return_status := fnd_api.g_ret_sts_unexp_error;
242: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
243: WHEN NO_DATA_FOUND
244: THEN
245: ROLLBACK TO create_escalation_pvt;
246: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

243: WHEN NO_DATA_FOUND
244: THEN
245: ROLLBACK TO create_escalation_pvt;
246: x_return_status := fnd_api.g_ret_sts_unexp_error;
247: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
248: WHEN OTHERS
249: THEN
250: ROLLBACK TO create_escalation_pvt;
251: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 253: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

249: THEN
250: ROLLBACK TO create_escalation_pvt;
251: x_return_status := fnd_api.g_ret_sts_unexp_error;
252:
253: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
254: THEN
255: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
256: END IF;
257:

Line 255: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

251: x_return_status := fnd_api.g_ret_sts_unexp_error;
252:
253: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
254: THEN
255: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
256: END IF;
257:
258: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
259: END;

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

254: THEN
255: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
256: END IF;
257:
258: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
259: END;
260:
261: PROCEDURE update_escalation (
262: p_api_version IN NUMBER,

Line 503: fnd_msg_pub.initialize;

499: END IF;
500:
501: IF fnd_api.to_boolean (p_init_msg_list)
502: THEN
503: fnd_msg_pub.initialize;
504: END IF;
505:
506:
507: -----

Line 514: fnd_msg_pub.add;

510: IF ( l_escalation_id = fnd_api.g_miss_num
511: AND l_escalation_number = fnd_api.g_miss_char)
512: THEN
513: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_TASK');
514: fnd_msg_pub.add;
515: x_return_status := fnd_api.g_ret_sts_unexp_error;
516: RAISE fnd_api.g_exc_unexpected_error;
517: ELSE
518: SELECT DECODE (l_escalation_id, fnd_api.g_miss_num, NULL, l_escalation_id)

Line 547: fnd_msg_pub.add;

543: IF l_escalation_id IS NULL
544: THEN
545: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_TASK_NUMBER');
546: fnd_message.set_token('P_TASK_NUMBER',l_escalation_number);
547: fnd_msg_pub.add;
548: x_return_status := fnd_api.g_ret_sts_unexp_error;
549: RAISE fnd_api.g_exc_unexpected_error;
550: END IF;
551: END IF;

Line 560: fnd_msg_pub.add;

556: -----
557: IF l_escalation_name IS NULL
558: THEN
559: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_NAME');
560: fnd_msg_pub.add;
561: x_return_status := fnd_api.g_ret_sts_unexp_error;
562: RAISE fnd_api.g_exc_unexpected_error;
563: END IF;
564:

Line 580: fnd_msg_pub.add;

576: IF c_escalation_update%NOTFOUND
577: THEN
578: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_TASK_ID');
579: fnd_message.set_token('P_TASK_ID', to_char(l_escalation_id));
580: fnd_msg_pub.add;
581: x_return_status := fnd_api.g_ret_sts_unexp_error;
582: RAISE fnd_api.g_exc_unexpected_error;
583: END IF;
584: CLOSE c_escalation_update;

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

685: p_attribute15 => p_attribute15,
686: p_attribute_category => p_attribute_category
687: );
688:
689: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
690:
691: --Created for BES enh 2660883
692: begin
693:

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

710: WHEN fnd_api.g_exc_unexpected_error
711: THEN
712: ROLLBACK TO update_escalation_pvt;
713: x_return_status := fnd_api.g_ret_sts_unexp_error;
714: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
715: WHEN NO_DATA_FOUND
716: THEN
717: ROLLBACK TO update_escalation_pvt;
718: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

715: WHEN NO_DATA_FOUND
716: THEN
717: ROLLBACK TO update_escalation_pvt;
718: x_return_status := fnd_api.g_ret_sts_unexp_error;
719: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
720: WHEN OTHERS
721: THEN
722: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
723: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);

Line 724: fnd_msg_pub.add;

720: WHEN OTHERS
721: THEN
722: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
723: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
724: fnd_msg_pub.add;
725: ROLLBACK TO update_escalation_pvt;
726: x_return_status := fnd_api.g_ret_sts_unexp_error;
727: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
728: END;

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

723: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
724: fnd_msg_pub.add;
725: ROLLBACK TO update_escalation_pvt;
726: x_return_status := fnd_api.g_ret_sts_unexp_error;
727: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
728: END;
729: /* PROCEDURE lock_escalation (
730: p_api_version IN NUMBER,
731: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

Line 798: fnd_msg_pub.initialize;

794: END IF;
795:
796: IF fnd_api.to_boolean (p_init_msg_list)
797: THEN
798: fnd_msg_pub.initialize;
799: END IF;
800:
801: IF ( l_escalation_id IS NULL
802: AND l_escalation_number IS NULL)

Line 805: fnd_msg_pub.add;

801: IF ( l_escalation_id IS NULL
802: AND l_escalation_number IS NULL)
803: THEN
804: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_TASK');
805: fnd_msg_pub.add;
806: x_return_status := fnd_api.g_ret_sts_unexp_error;
807: RAISE fnd_api.g_exc_unexpected_error;
808: ELSE
809: jtf_task_utl.validate_task (

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

912: THEN
913: COMMIT WORK;
914: END IF;
915:
916: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
917:
918: --Created for BES enh 2660883
919: begin
920:

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

933: WHEN fnd_api.g_exc_unexpected_error
934: THEN
935: ROLLBACK TO delete_escalation_pvt;
936: x_return_status := fnd_api.g_ret_sts_unexp_error;
937: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
938: WHEN OTHERS
939: THEN
940: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
941: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);

Line 942: fnd_msg_pub.add ;

938: WHEN OTHERS
939: THEN
940: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
941: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
942: fnd_msg_pub.add ;
943: ROLLBACK TO delete_escalation_pvt;
944: x_return_status := fnd_api.g_ret_sts_unexp_error;
945: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
946: END;

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

941: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
942: fnd_msg_pub.add ;
943: ROLLBACK TO delete_escalation_pvt;
944: x_return_status := fnd_api.g_ret_sts_unexp_error;
945: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
946: END;
947:
948: END;