DBA Data[Home] [Help]

APPS.PA_PAGE_TYPE_REGION_PUB dependencies on PA_PAGE_TYPE_REGION_PUB

Line 1: package body PA_PAGE_TYPE_REGION_PUB as

1: package body PA_PAGE_TYPE_REGION_PUB as
2: /* $Header: PAPLPTPB.pls 120.1 2005/08/19 16:41:35 mwasowic noship $ */
3:
4: PROCEDURE Create_Page_Type_Region
5: (

Line 56: PA_DEBUG.init_err_stack('PA_PAGE_TYPE_REGION_PUB.Create_Page_Type_Region');

52:
53: BEGIN
54:
55: -- Initialize the Error Stack
56: PA_DEBUG.init_err_stack('PA_PAGE_TYPE_REGION_PUB.Create_Page_Type_Region');
57:
58: -- Initialize the return status to success
59: x_return_status := FND_API.G_RET_STS_SUCCESS;
60:

Line 202: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PAGE_TYPE_REGION_PUB.Create_Page_Type_Region'

198: WHEN OTHERS THEN
199: rollback;
200:
201: -- Set the excetption Message and the stack
202: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PAGE_TYPE_REGION_PUB.Create_Page_Type_Region'
203: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
204: --
205: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
206: RAISE; -- This is optional depending on the needs

Line 253: PA_DEBUG.init_err_stack('PA_PAGE_TYPE_REGION_PUB.Update_Page_Type_Region');

249: l_edit_region_code VARCHAR2(250);
250: BEGIN
251:
252: -- Initialize the Error Stack
253: PA_DEBUG.init_err_stack('PA_PAGE_TYPE_REGION_PUB.Update_Page_Type_Region');
254:
255: -- Initialize the return status to success
256: x_return_status := FND_API.G_RET_STS_SUCCESS;
257:

Line 366: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PAGE_TYPE_REGION_PUB.Update_Page_Type_Region'

362: EXCEPTION
363: WHEN OTHERS THEN
364:
365: -- Set the exception Message and the stack
366: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PAGE_TYPE_REGION_PUB.Update_Page_Type_Region'
367: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
368: --
369: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
370: RAISE; -- This is optional depending on the needs

Line 400: PA_DEBUG.init_err_stack('PA_PAGE_TYPE_REGION_PUB.Delete_Page_Type_Region');

396:
397: BEGIN
398:
399: -- Initialize the Error Stack
400: PA_DEBUG.init_err_stack('PA_PAGE_TYPE_REGION_PUB.Delete_Page_Type_Region');
401:
402: x_return_status := FND_API.G_RET_STS_SUCCESS;
403:
404: --Clear the global PL/SQL message table

Line 452: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_PAGE_TYPE_REGION_PUB.Delete_Page_Type_Region'

448:
449: rollback;
450:
451: -- Set the excetption Message and the stack
452: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_PAGE_TYPE_REGION_PUB.Delete_Page_Type_Region'
453: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
454: --
455: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
456: RAISE; -- This is optional depending on the needs

Line 460: END PA_PAGE_TYPE_REGION_PUB;

456: RAISE; -- This is optional depending on the needs
457:
458: END delete_page_type_region;
459:
460: END PA_PAGE_TYPE_REGION_PUB;