DBA Data[Home] [Help]

APPS.JTF_RS_SALESREPS_PUB dependencies on FND_MSG_PUB

Line 79: fnd_msg_pub.initialize;

75: RAISE fnd_api.g_exc_unexpected_error;
76: END IF;
77:
78: IF fnd_api.to_boolean(p_init_msg_list) THEN
79: fnd_msg_pub.initialize;
80: END IF;
81:
82:
83: /* Validate Resource */

Line 248: FND_MSG_PUB.Count_And_Get

244: COMMIT WORK;
245: END IF;
246:
247: /* Standard call to get message count and if count is 1, get message info. */
248: FND_MSG_PUB.Count_And_Get
249: (p_count => x_msg_count,
250: p_data => x_msg_data
251: );
252:

Line 258: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

254:
255: WHEN fnd_api.g_exc_error THEN
256: ROLLBACK TO create_salesreps_pub;
257: x_return_status := fnd_api.g_ret_sts_error;
258: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
259: p_data => x_msg_data);
260: WHEN fnd_api.g_exc_unexpected_error THEN
261: ROLLBACK TO create_salesreps_pub;
262: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 263: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

259: p_data => x_msg_data);
260: WHEN fnd_api.g_exc_unexpected_error THEN
261: ROLLBACK TO create_salesreps_pub;
262: x_return_status := fnd_api.g_ret_sts_unexp_error;
263: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
264: p_data => x_msg_data);
265: WHEN OTHERS THEN
266: ROLLBACK TO create_salesreps_pub;
267: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');

Line 271: FND_MSG_PUB.add;

267: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
268: fnd_message.set_token('P_SQLCODE',SQLCODE);
269: fnd_message.set_token('P_SQLERRM',SQLERRM);
270: fnd_message.set_token('P_API_NAME', l_api_name);
271: FND_MSG_PUB.add;
272: x_return_status := fnd_api.g_ret_sts_unexp_error;
273: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
274: p_data => x_msg_data);
275:

Line 273: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

269: fnd_message.set_token('P_SQLERRM',SQLERRM);
270: fnd_message.set_token('P_API_NAME', l_api_name);
271: FND_MSG_PUB.add;
272: x_return_status := fnd_api.g_ret_sts_unexp_error;
273: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
274: p_data => x_msg_data);
275:
276: END create_salesrep;
277:

Line 436: fnd_msg_pub.initialize;

432: RAISE fnd_api.g_exc_unexpected_error;
433: END IF;
434:
435: IF fnd_api.to_boolean(p_init_msg_list) THEN
436: fnd_msg_pub.initialize;
437: END IF;
438:
439:
440: /* Validate Salesrep */

Line 536: FND_MSG_PUB.Count_And_Get

532: COMMIT WORK;
533: END IF;
534:
535: /* Standard call to get message count and if count is 1, get message info. */
536: FND_MSG_PUB.Count_And_Get
537: (p_count => x_msg_count,
538: p_data => x_msg_data
539: );
540:

Line 546: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

542:
543: WHEN fnd_api.g_exc_error THEN
544: ROLLBACK TO update_salesreps_pub;
545: x_return_status := fnd_api.g_ret_sts_error;
546: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
547: p_data => x_msg_data);
548: WHEN fnd_api.g_exc_unexpected_error THEN
549: ROLLBACK TO update_salesreps_pub;
550: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 551: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

547: p_data => x_msg_data);
548: WHEN fnd_api.g_exc_unexpected_error THEN
549: ROLLBACK TO update_salesreps_pub;
550: x_return_status := fnd_api.g_ret_sts_unexp_error;
551: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
552: p_data => x_msg_data);
553: WHEN OTHERS THEN
554: ROLLBACK TO update_salesreps_pub;
555: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');

Line 559: FND_MSG_PUB.add;

555: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
556: fnd_message.set_token('P_SQLCODE',SQLCODE);
557: fnd_message.set_token('P_SQLERRM',SQLERRM);
558: fnd_message.set_token('P_API_NAME', l_api_name);
559: FND_MSG_PUB.add;
560: x_return_status := fnd_api.g_ret_sts_unexp_error;
561: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
562: p_data => x_msg_data);
563:

Line 561: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

557: fnd_message.set_token('P_SQLERRM',SQLERRM);
558: fnd_message.set_token('P_API_NAME', l_api_name);
559: FND_MSG_PUB.add;
560: x_return_status := fnd_api.g_ret_sts_unexp_error;
561: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
562: p_data => x_msg_data);
563:
564: END update_salesrep;
565: