APPS.PA_CI_ACTIONS_UTIL dependencies on PA_CI_ACTIONS

Line 1: PACKAGE BODY PA_CI_ACTIONS_UTIL AS

1: PACKAGE BODY PA_CI_ACTIONS_UTIL AS
2: /* $Header: PACIACUB.pls 120.1 2005/08/01 03:09:56 raluthra noship $ */
3:
4: Function action_with_reply(p_ci_action_id in number)
5: return varchar2

Line 133: PA_DEBUG.init_err_stack('PA_CI_ACTIONS_UTIL.CHECKHZPARTYNAME_OR_ID');

129: --where orig_system_reference = 'PER:'||TO_CHAR(l_resource_id);
130:
131: BEGIN
132: -- Initialize the Error Stack
133: PA_DEBUG.init_err_stack('PA_CI_ACTIONS_UTIL.CHECKHZPARTYNAME_OR_ID');
134:
135: -- Initialize the return status to success
136: x_return_status := FND_API.G_RET_STS_SUCCESS;
137:

Line 178: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_CI_ACTIONS_UTILS.CheckHzPartyName_Or_Id'

174: EXCEPTION
175:
176: WHEN OTHERS THEN
177: -- Set the exception Message and the stack
178: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_CI_ACTIONS_UTILS.CheckHzPartyName_Or_Id'
179: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
180: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
181: RAISE;
182:

Line 193: from pa_ci_actions

189: total_act NUMBER:=0;
190: BEGIN
191: select count(*)
192: into total_act
193: from pa_ci_actions
194: where ci_id = p_ci_id and
195: status_code = 'CI_ACTION_OPEN';
196: return total_act;
197:

Line 243: from pa_ci_actions

239: l_ci_action_id number;
240:
241: Cursor action_source is
242: select ci_action_id
243: from pa_ci_actions
244: where source_ci_action_id is null
245: start with ci_action_id = p_ci_action_id
246: connect by prior source_ci_action_id = ci_action_id;
247:

Line 261: END; -- Package Body PA_CI_ACTIONS_UTIL

257: CLOSE action_source;
258: return l_parent_ci_action_id;
259: END GET_TOP_PARENT_ACTION;
260:
261: END; -- Package Body PA_CI_ACTIONS_UTIL