DBA Data[Home] [Help]

APPS.PA_USER_ATTR_PUB dependencies on FND_MSG_PUB

Line 132: FND_MSG_PUB.initialize;

128: savepoint copy_user_attrs_data;
129: end if;
130:
131: if FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) then
132: FND_MSG_PUB.initialize;
133: end if;
134:
135: if p_object_type = 'PA_PROJECTS' then
136:

Line 158: x_msg_count := FND_MSG_PUB.count_msg;

154: ,x_msg_count => l_msg_count
155: ,x_msg_data => l_msg_data );
156:
157: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
158: x_msg_count := FND_MSG_PUB.count_msg;
159: if x_msg_count = 1 then
160: pa_interface_utils_pub.get_messages
161: (p_encoded => FND_API.G_TRUE,
162: p_msg_index => 1,

Line 198: x_msg_count := FND_MSG_PUB.count_msg;

194: ,x_msg_count => l_msg_count
195: ,x_msg_data => l_msg_data );
196:
197: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
198: x_msg_count := FND_MSG_PUB.count_msg;
199: if x_msg_count = 1 then
200: pa_interface_utils_pub.get_messages
201: (p_encoded => FND_API.G_TRUE,
202: p_msg_index => 1,

Line 243: x_msg_count := FND_MSG_PUB.count_msg;

239: ,x_msg_count => l_msg_count
240: ,x_msg_data => l_msg_data );
241:
242: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
243: x_msg_count := FND_MSG_PUB.count_msg;
244: if x_msg_count = 1 then
245: pa_interface_utils_pub.get_messages
246: (p_encoded => FND_API.G_TRUE,
247: p_msg_index => 1,

Line 278: x_msg_count := FND_MSG_PUB.count_msg;

274: ,x_msg_count => l_msg_count
275: ,x_msg_data => l_msg_data );
276:
277: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
278: x_msg_count := FND_MSG_PUB.count_msg;
279: if x_msg_count = 1 then
280: pa_interface_utils_pub.get_messages
281: (p_encoded => FND_API.G_TRUE,
282: p_msg_index => 1,

Line 323: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_USER_ATTR_PUB',

319: rollback to copy_user_attrs_data;
320: end if;
321: x_errorcode := l_errorcode;
322: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
323: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_USER_ATTR_PUB',
324: p_procedure_name => 'Copy_User_Attrs_Data',
325: p_error_text => SUBSTRB(SQLERRM,1,240));
326: when OTHERS then
327: if p_commit = FND_API.G_TRUE then

Line 332: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_USER_ATTR_PUB',

328: rollback to copy_user_attrs_data;
329: end if;
330: x_errorcode := l_errorcode;
331: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
332: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_USER_ATTR_PUB',
333: p_procedure_name => 'Copy_User_Attrs_Data',
334: p_error_text => SUBSTRB(SQLERRM,1,240));
335: raise;
336: END COPY_USER_ATTRS_DATA;

Line 387: FND_MSG_PUB.initialize;

383: savepoint delete_user_attrs_data;
384: end if;
385:
386: if FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) then
387: FND_MSG_PUB.initialize;
388: end if;
389:
390: PA_USER_ATTR_PVT.DELETE_USER_ATTRS_DATA (
391: p_commit => FND_API.G_FALSE

Line 406: x_msg_count := FND_MSG_PUB.count_msg;

402: ,x_msg_count => l_msg_count
403: ,x_msg_data => l_msg_data );
404:
405: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
406: x_msg_count := FND_MSG_PUB.count_msg;
407: if x_msg_count = 1 then
408: pa_interface_utils_pub.get_messages
409: (p_encoded => FND_API.G_TRUE,
410: p_msg_index => 1,

Line 441: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_USER_ATTR_PUB',

437: if p_commit = FND_API.G_TRUE then
438: rollback to delete_user_attrs_data;
439: end if;
440: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
441: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_USER_ATTR_PUB',
442: p_procedure_name => 'Delete_User_Attrs_Data',
443: p_error_text => SUBSTRB(SQLERRM,1,240));
444: when OTHERS then
445: if p_commit = FND_API.G_TRUE then

Line 449: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_USER_ATTR_PUB',

445: if p_commit = FND_API.G_TRUE then
446: rollback to delete_user_attrs_data;
447: end if;
448: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
449: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_USER_ATTR_PUB',
450: p_procedure_name => 'Delete_User_Attrs_Data',
451: p_error_text => SUBSTRB(SQLERRM,1,240));
452: raise;
453: END DELETE_USER_ATTRS_DATA;

Line 541: l_msg_count := FND_MSG_PUB.count_msg;

537:
538: end if;
539: end if;
540:
541: l_msg_count := FND_MSG_PUB.count_msg;
542: if l_msg_count > 0 then
543: x_msg_count := l_msg_count;
544: if x_msg_count = 1 then
545: pa_interface_utils_pub.get_messages

Line 562: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_USER_ATTR_PUB',

558:
559: EXCEPTION
560: when OTHERS then
561: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
562: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_USER_ATTR_PUB',
563: p_procedure_name => 'Check_Delete_Assoc_Ok',
564: p_error_text => SUBSTRB(SQLERRM,1,240));
565: x_ok_to_delete := FND_API.G_FALSE;
566: raise;

Line 616: FND_MSG_PUB.initialize;

612: savepoint delete_all_user_attrs_data;
613: end if;
614:
615: if FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) then
616: FND_MSG_PUB.initialize;
617: end if;
618:
619: PA_USER_ATTR_PVT.DELETE_ALL_USER_ATTRS_DATA (
620: p_commit => FND_API.G_FALSE

Line 632: x_msg_count := FND_MSG_PUB.count_msg;

628: ,x_msg_count => l_msg_count
629: ,x_msg_data => l_msg_data );
630:
631: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
632: x_msg_count := FND_MSG_PUB.count_msg;
633: if x_msg_count = 1 then
634: pa_interface_utils_pub.get_messages
635: (p_encoded => FND_API.G_TRUE,
636: p_msg_index => 1,

Line 667: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_USER_ATTR_PUB',

663: if p_commit = FND_API.G_TRUE then
664: rollback to delete_all_user_attrs_data;
665: end if;
666: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
667: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_USER_ATTR_PUB',
668: p_procedure_name => 'Delete_All_User_Attrs_Data',
669: p_error_text => SUBSTRB(SQLERRM,1,240));
670: when OTHERS then
671: if p_commit = FND_API.G_TRUE then

Line 675: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_USER_ATTR_PUB',

671: if p_commit = FND_API.G_TRUE then
672: rollback to delete_all_user_attrs_data;
673: end if;
674: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
675: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_USER_ATTR_PUB',
676: p_procedure_name => 'Delete_All_User_Attrs_Data',
677: p_error_text => SUBSTRB(SQLERRM,1,240));
678: raise;
679: END DELETE_ALL_USER_ATTRS_DATA;

Line 907: x_msg_count := FND_MSG_PUB.count_msg;

903: x_return_status := l_return_status;
904: x_errorcode := l_errorcode;
905:
906: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
907: x_msg_count := FND_MSG_PUB.count_msg;
908: if x_msg_count = 1 then
909: pa_interface_utils_pub.get_messages
910: (p_encoded => FND_API.G_TRUE,
911: p_msg_index => 1,

Line 938: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_USER_ATTR_PUB',

934: if p_commit = FND_API.G_TRUE then
935: rollback to PROCESS_USER_ATTRS_DATA_PUB;
936: end if;
937: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
938: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_USER_ATTR_PUB',
939: p_procedure_name => 'PROCESS_USER_ATTRS_DATA',
940: p_error_text => SUBSTRB(SQLERRM,1,240));
941: when OTHERS then
942: if p_commit = FND_API.G_TRUE then

Line 946: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_USER_ATTR_PUB',

942: if p_commit = FND_API.G_TRUE then
943: rollback to PROCESS_USER_ATTRS_DATA_PUB;
944: end if;
945: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
946: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_USER_ATTR_PUB',
947: p_procedure_name => 'PROCESS_USER_ATTRS_DATA',
948: p_error_text => SUBSTRB(SQLERRM,1,240));
949: raise;
950: