eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_USER_ATTR_PUB dependencies on PA_USER_ATTR_PUB

Line 1: PACKAGE BODY PA_USER_ATTR_PUB AS

1: PACKAGE BODY PA_USER_ATTR_PUB AS
2: /* $Header: PAUATTPB.pls 120.1.12010000.2 2009/06/12 06:00:39 snizam ship $ */
3:
4: -- Global constant
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'PA_USER_ATTR_PUB';

Line 5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'PA_USER_ATTR_PUB';

1: PACKAGE BODY PA_USER_ATTR_PUB AS
2: /* $Header: PAUATTPB.pls 120.1.12010000.2 2009/06/12 06:00:39 snizam ship $ */
3:
4: -- Global constant
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'PA_USER_ATTR_PUB';
6: G_ATTR_GROUP_TYPE CONSTANT VARCHAR2(30) := 'PA_PROJ_ATTR_GROUP_TYPE';
7:
8: -- API name : COPY_USER_ATTRS_DATA
9: -- Type : Public

Line 117: pa_debug.init_err_stack('PA_USER_ATTR_PUB.Copy_User_Attrs_Data');

113: l_msg_index_out NUMBER;
114: l_errorcode NUMBER;
115:
116: BEGIN
117: pa_debug.init_err_stack('PA_USER_ATTR_PUB.Copy_User_Attrs_Data');
118:
119: if (p_debug_mode = 'Y') then
120: pa_debug.debug('PA_USER_ATTR_PUB.Copy_User_Attrs_Data BEGIN');
121: end if;

Line 120: pa_debug.debug('PA_USER_ATTR_PUB.Copy_User_Attrs_Data BEGIN');

116: BEGIN
117: pa_debug.init_err_stack('PA_USER_ATTR_PUB.Copy_User_Attrs_Data');
118:
119: if (p_debug_mode = 'Y') then
120: pa_debug.debug('PA_USER_ATTR_PUB.Copy_User_Attrs_Data BEGIN');
121: end if;
122:
123: if not FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then
124: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 233: PA_USER_ATTR_PUB.DELETE_USER_ATTRS_DATA (

229: OPEN get_category_id(l_category);
230: FETCH get_category_id INTO l_category_id;
231: CLOSE get_category_id;
232:
233: PA_USER_ATTR_PUB.DELETE_USER_ATTRS_DATA (
234: p_validate_only => FND_API.G_FALSE
235: ,p_project_id => p_object_id_to
236: ,p_old_classification_id => l_category_id
237: ,p_classification_type => 'CLASS_CATEGORY'

Line 268: PA_USER_ATTR_PUB.DELETE_USER_ATTRS_DATA (

264: OPEN get_code_id(l_category, l_code);
265: FETCH get_code_id INTO l_code_id;
266: CLOSE get_code_id;
267:
268: PA_USER_ATTR_PUB.DELETE_USER_ATTRS_DATA (
269: p_validate_only => FND_API.G_FALSE
270: ,p_project_id => p_object_id_to
271: ,p_old_classification_id => l_code_id
272: ,p_classification_type => 'CLASS_CODE'

Line 307: pa_debug.debug('PA_USER_ATTR_PUB.Copy_User_Attrs_Data END');

303: commit work;
304: end if;
305:
306: if (p_debug_mode = 'Y') then
307: pa_debug.debug('PA_USER_ATTR_PUB.Copy_User_Attrs_Data END');
308: end if;
309:
310: EXCEPTION
311: when FND_API.G_EXC_ERROR then

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 372: pa_debug.init_err_stack('PA_USER_ATTR_PUB.Delete_User_Attrs_Data');

368: l_data VARCHAR2(250);
369: l_msg_index_out NUMBER;
370:
371: BEGIN
372: pa_debug.init_err_stack('PA_USER_ATTR_PUB.Delete_User_Attrs_Data');
373:
374: if (p_debug_mode = 'Y') then
375: pa_debug.debug('PA_USER_ATTR_PUB.Delete_User_Attrs_Data BEGIN');
376: end if;

Line 375: pa_debug.debug('PA_USER_ATTR_PUB.Delete_User_Attrs_Data BEGIN');

371: BEGIN
372: pa_debug.init_err_stack('PA_USER_ATTR_PUB.Delete_User_Attrs_Data');
373:
374: if (p_debug_mode = 'Y') then
375: pa_debug.debug('PA_USER_ATTR_PUB.Delete_User_Attrs_Data BEGIN');
376: end if;
377:
378: if not FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then
379: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 427: pa_debug.debug('PA_USER_ATTR_PUB.Delete_User_Attrs_Data END');

423: commit work;
424: end if;
425:
426: if (p_debug_mode = 'Y') then
427: pa_debug.debug('PA_USER_ATTR_PUB.Delete_User_Attrs_Data END');
428: end if;
429:
430: EXCEPTION
431: when FND_API.G_EXC_ERROR then

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 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 601: pa_debug.init_err_stack('PA_USER_ATTR_PUB.Delete_All_User_Attrs_Data');

597: l_data VARCHAR2(250);
598: l_msg_index_out NUMBER;
599:
600: BEGIN
601: pa_debug.init_err_stack('PA_USER_ATTR_PUB.Delete_All_User_Attrs_Data');
602:
603: if (p_debug_mode = 'Y') then
604: pa_debug.debug('PA_USER_ATTR_PUB.Delete_All_User_Attrs_Data BEGIN');
605: end if;

Line 604: pa_debug.debug('PA_USER_ATTR_PUB.Delete_All_User_Attrs_Data BEGIN');

600: BEGIN
601: pa_debug.init_err_stack('PA_USER_ATTR_PUB.Delete_All_User_Attrs_Data');
602:
603: if (p_debug_mode = 'Y') then
604: pa_debug.debug('PA_USER_ATTR_PUB.Delete_All_User_Attrs_Data BEGIN');
605: end if;
606:
607: if not FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then
608: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 653: pa_debug.debug('PA_USER_ATTR_PUB.Delete_All_User_Attrs_Data END');

649:
650: x_return_status := FND_API.G_RET_STS_SUCCESS;
651:
652: if (p_debug_mode = 'Y') then
653: pa_debug.debug('PA_USER_ATTR_PUB.Delete_All_User_Attrs_Data END');
654: end if;
655:
656: EXCEPTION
657: when FND_API.G_EXC_ERROR then

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 735: pa_debug.init_err_stack('PA_USER_ATTR_PUB.Process_User_Attrs_Data');

731: l_msg_index_out NUMBER;
732: l_proj_elem_id NUMBER;
733:
734: BEGIN
735: pa_debug.init_err_stack('PA_USER_ATTR_PUB.Process_User_Attrs_Data');
736:
737: SAVEPOINT PROCESS_USER_ATTRS_DATA_PUB;
738:
739: if (p_debug_mode = 'Y') then

Line 740: pa_debug.debug('PA_USER_ATTR_PUB.Process_User_Attrs_Data BEGIN');

736:
737: SAVEPOINT PROCESS_USER_ATTRS_DATA_PUB;
738:
739: if (p_debug_mode = 'Y') then
740: pa_debug.debug('PA_USER_ATTR_PUB.Process_User_Attrs_Data BEGIN');
741: end if;
742:
743: if not FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then
744: raise FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

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

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

Line 1207: END PA_USER_ATTR_PUB;

1203:
1204: END CHECK_PT_ASSOC_EXISTS;
1205:
1206:
1207: END PA_USER_ATTR_PUB;