APPS.PA_OBJECT_DIST_LISTS_PVT dependencies on FND_MSG_PUB

Line 31: fnd_msg_pub.initialize;

27: SAVEPOINT CREATE_OBJECT_DIST_LIST;
28: END IF;
29:
30: IF p_init_msg_list = FND_API.G_TRUE THEN
31: fnd_msg_pub.initialize;
32: END IF;
33:
34: x_return_status := 'S';
35: x_msg_count := 0;

Line 75: fnd_msg_pub.count_and_get(p_count => x_msg_count,

71: AND x_return_status = fnd_api.g_ret_sts_success) then
72: commit;
73: end if;
74:
75: fnd_msg_pub.count_and_get(p_count => x_msg_count,
76: p_data => x_msg_data);
77:
78:
79: EXCEPTION

Line 93: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_OBJECT_DIST_LISTS_PVT',

89: THEN
90: ROLLBACK TO CREATE_OBJECT_DIST_LIST;
91: END IF;
92: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
93: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_OBJECT_DIST_LISTS_PVT',
94: p_procedure_name => 'CREATE_OBJECT_DIST_LIST',
95: p_error_text => SUBSTRB(SQLERRM,1,240));
96: RAISE;
97:

Line 137: fnd_msg_pub.initialize;

133: SAVEPOINT UPDATE_OBJECT_DIST_LIST;
134: END IF;
135:
136: IF p_init_msg_list = FND_API.G_TRUE THEN
137: fnd_msg_pub.initialize;
138: END IF;
139:
140: x_return_status := fnd_api.g_ret_sts_success;
141: x_msg_count := 0;

Line 189: fnd_msg_pub.count_and_get(p_count => x_msg_count,

185: AND x_return_status = fnd_api.g_ret_sts_success) then
186: commit;
187: end if;
188:
189: fnd_msg_pub.count_and_get(p_count => x_msg_count,
190: p_data => x_msg_data);
191:
192: EXCEPTION
193: WHEN FND_API.G_EXC_ERROR THEN

Line 206: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_OBJECT_DIST_LISTS_PVT',

202: THEN
203: ROLLBACK TO UPDATE_OBJECT_DIST_LIST;
204: END IF;
205: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
206: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_OBJECT_DIST_LISTS_PVT',
207: p_procedure_name => 'UPDATE_OBJECT_DIST_LIST',
208: p_error_text => SUBSTRB(SQLERRM,1,240));
209: RAISE;
210:

Line 236: fnd_msg_pub.initialize;

232: SAVEPOINT DELETE_OBJECT_DIST_LIST;
233: END IF;
234:
235: IF p_init_msg_list = FND_API.G_TRUE THEN
236: fnd_msg_pub.initialize;
237: END IF;
238: x_return_status := fnd_api.g_ret_sts_success;
239: x_msg_count := 0;
240:

Line 255: fnd_msg_pub.count_and_get(p_count => x_msg_count,

251: AND x_return_status = fnd_api.g_ret_sts_success) then
252: commit;
253: end if;
254:
255: fnd_msg_pub.count_and_get(p_count => x_msg_count,
256: p_data => x_msg_data);
257:
258: EXCEPTION
259: WHEN FND_API.G_EXC_ERROR THEN

Line 272: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_OBJECT_DIST_LISTS_PVT',

268: THEN
269: ROLLBACK TO DELETE_OBJECT_DIST_LIST;
270: END IF;
271: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
272: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_OBJECT_DIST_LISTS_PVT',
273: p_procedure_name => 'DELETE_OBJECT_DIST_LIST',
274: p_error_text => SUBSTRB(SQLERRM,1,240));
275: RAISE;
276: End DELETE_OBJECT_DIST_LIST;

Line 314: fnd_msg_pub.initialize;

310: SAVEPOINT DELETE_ASSOC_DIST_LISTS;
311: END IF;
312:
313: IF p_init_msg_list = FND_API.G_TRUE THEN
314: fnd_msg_pub.initialize;
315: END IF;
316:
317: x_return_status := fnd_api.g_ret_sts_success;
318: x_msg_count := 0;

Line 350: fnd_msg_pub.count_and_get(p_count => x_msg_count,

346: AND x_return_status = fnd_api.g_ret_sts_success) then
347: commit;
348: end if;
349:
350: fnd_msg_pub.count_and_get(p_count => x_msg_count,
351: p_data => x_msg_data);
352:
353: EXCEPTION
354: WHEN FND_API.G_EXC_ERROR THEN

Line 367: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_OBJECT_DIST_LISTS_PVT',

363: THEN
364: ROLLBACK TO DELETE_ASSOC_DIST_LISTS;
365: END IF;
366: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
367: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_OBJECT_DIST_LISTS_PVT',
368: p_procedure_name => 'DELETE_ASSOC_DIST_LISTS',
369: p_error_text => SUBSTRB(SQLERRM,1,240));
370: RAISE;
371: End DELETE_ASSOC_DIST_LISTS;