DBA Data[Home] [Help]

APPS.JTF_EC_CONTACTS_PVT dependencies on FND_MSG_PUB

Line 58: fnd_msg_pub.initialize;

54: END IF;
55:
56: IF fnd_api.to_boolean (p_init_msg_list)
57: THEN
58: fnd_msg_pub.initialize;
59: END IF;
60:
61: --bug 2252635
62: if jtf_ec_util.Contact_Duplicated(p_contact_id,

Line 69: fnd_msg_pub.add;

65:
66: fnd_message.set_name('JTF', 'JTF_API_ALL_DUPLICATE_VALUE');
67: fnd_message.set_token('API_NAME', l_api_name);
68: fnd_message.set_token('DUPLICATE_VAL_PARAM', 'Contact ID: ' || to_char(p_contact_id));
69: fnd_msg_pub.add;
70: RAISE fnd_api.g_exc_unexpected_error;
71: end if;
72: --end
73:

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

113: THEN
114: COMMIT WORK;
115: END IF;
116:
117: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
118:
119: EXCEPTION
120: WHEN fnd_api.g_exc_unexpected_error
121: THEN

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

120: WHEN fnd_api.g_exc_unexpected_error
121: THEN
122: ROLLBACK TO create_escalation_contacts_pub;
123: x_return_status := fnd_api.g_ret_sts_unexp_error;
124: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
125: WHEN OTHERS
126: THEN
127: ROLLBACK TO create_escalation_contacts_pub;
128: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');

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

127: ROLLBACK TO create_escalation_contacts_pub;
128: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
129: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
130: x_return_status := fnd_api.g_ret_sts_unexp_error;
131: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
132: END;
133:
134: PROCEDURE update_escalation_contacts (
135: p_api_version IN NUMBER,

Line 184: fnd_msg_pub.initialize;

180: END IF;
181:
182: IF fnd_api.to_boolean (p_init_msg_list)
183: THEN
184: fnd_msg_pub.initialize;
185: END IF;
186:
187: x_return_status := fnd_api.g_ret_sts_success;
188: l_object_version_number := p_object_version_number;

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

223: THEN
224: COMMIT WORK;
225: END IF;
226:
227: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
228: EXCEPTION
229: WHEN fnd_api.g_exc_unexpected_error
230: THEN
231: ROLLBACK TO update_escalation_contacts_pub;

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

229: WHEN fnd_api.g_exc_unexpected_error
230: THEN
231: ROLLBACK TO update_escalation_contacts_pub;
232: x_return_status := fnd_api.g_ret_sts_unexp_error;
233: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
234: WHEN OTHERS
235: THEN
236: ROLLBACK TO update_escalation_contacts_pub;
237: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');

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

236: ROLLBACK TO update_escalation_contacts_pub;
237: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
238: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
239: x_return_status := fnd_api.g_ret_sts_unexp_error;
240: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
241: END;
242:
243: PROCEDURE delete_escalation_contacts (
244: p_api_version IN NUMBER,

Line 273: fnd_msg_pub.initialize;

269: END IF;
270:
271: IF fnd_api.to_boolean (p_init_msg_list)
272: THEN
273: fnd_msg_pub.initialize;
274: END IF;
275:
276: x_return_status := fnd_api.g_ret_sts_success;
277: jtf_task_contacts_pub.delete_task_contacts (

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

295: THEN
296: COMMIT WORK;
297: END IF;
298:
299: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
300: EXCEPTION
301: WHEN fnd_api.g_exc_unexpected_error
302: THEN
303: ROLLBACK TO delete_task_contacts_pvt;

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

301: WHEN fnd_api.g_exc_unexpected_error
302: THEN
303: ROLLBACK TO delete_task_contacts_pvt;
304: x_return_status := fnd_api.g_ret_sts_unexp_error;
305: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
306: WHEN OTHERS
307: THEN
308: ROLLBACK TO delete_task_contacts_pvt;
309: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');

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

308: ROLLBACK TO delete_task_contacts_pvt;
309: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
310: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
311: x_return_status := fnd_api.g_ret_sts_unexp_error;
312: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
313: END;
314: END;