DBA Data[Home] [Help]

APPS.PA_CLIENT_EXTN_ASGMT_APPRVL dependencies on PA_CLIENT_EXTN_ASGMT_APPRVL

Line 1: PACKAGE BODY PA_CLIENT_EXTN_ASGMT_APPRVL AS

1: PACKAGE BODY PA_CLIENT_EXTN_ASGMT_APPRVL AS
2: /*$Header: PARAAPCB.pls 120.1 2005/10/28 11:34:55 ssong noship $*/
3:
4: --
5: -- Determine if the specified assignment's approval required items have been changed or not.

Line 49: PA_DEBUG.init_err_stack('PA_CLIENT_EXTN_ASGMT_APPRVL.Is_Asgmt_Appr_Items_Changed');

45: l_is_changed VARCHAR2(1);
46:
47: BEGIN
48: -- Initialize the Error Stack
49: PA_DEBUG.init_err_stack('PA_CLIENT_EXTN_ASGMT_APPRVL.Is_Asgmt_Appr_Items_Changed');
50:
51: OPEN items_not_changed;
52: FETCH items_not_changed INTO l_is_changed;
53:

Line 65: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_CLIENT_EXTN_ASGMT_APPRVL.Is_Asgmt_Appr_Items_Changed'

61:
62: EXCEPTION
63: WHEN OTHERS THEN
64: -- Set the excetption Message and the stack
65: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_CLIENT_EXTN_ASGMT_APPRVL.Is_Asgmt_Appr_Items_Changed'
66: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
67: --
68: RAISE; -- This is optional depending on the needs
69:

Line 73: END PA_CLIENT_EXTN_ASGMT_APPRVL;

69:
70: END Is_Asgmt_Appr_Items_Changed;
71:
72:
73: END PA_CLIENT_EXTN_ASGMT_APPRVL;