DBA Data[Home] [Help]

APPS.PA_CONTROL_ITEMS_WORKFLOW dependencies on PA_CONTROL_ITEMS_WORKFLOW

Line 1: package body pa_control_items_workflow as

1: package body pa_control_items_workflow as
2: /* $Header: PACIWFPB.pls 120.7.12000000.5 2007/07/12 10:07:48 rballamu ship $ */
3: /*============================================================================+
4: | Copyright (c) 1993 Oracle Corporation Belmont, California, USA |
5: | All rights reserved. |

Line 1136: pa_control_items_workflow.set_workflow_attributes(

1132:
1133:
1134: -- The following API will set all the required attributes for the workflow to function.
1135:
1136: pa_control_items_workflow.set_workflow_attributes(
1137: p_item_type => p_item_type
1138: ,p_process_name => p_process_name
1139: ,p_ci_id => p_ci_id
1140: ,p_action_id => p_action_id

Line 1160: pa_debug.g_err_stage:= 'returned from pa_control_items_workflow.set_workflow_attributes';

1156: RAISE Invalid_Arg_Exc_CI;
1157: END IF;
1158:
1159: IF l_debug_mode = 'Y' THEN
1160: pa_debug.g_err_stage:= 'returned from pa_control_items_workflow.set_workflow_attributes';
1161: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
1162: END IF;
1163:
1164:

Line 1238: ( p_pkg_name => 'PA_CONTROL_ITEMS_WORKFLOW'

1234: CLOSE get_project_id;
1235: END IF;
1236:
1237: FND_MSG_PUB.add_exc_msg
1238: ( p_pkg_name => 'PA_CONTROL_ITEMS_WORKFLOW'
1239: ,p_procedure_name => 'START_NOTIFICATION_WF'
1240: ,p_error_text => x_msg_data);
1241:
1242: IF l_debug_mode = 'Y' THEN

Line 2002: ( p_pkg_name => 'PA_CONTROL_ITEMS_WORKFLOW'

1998: CLOSE get_comment_text;
1999: END IF;
2000:
2001: FND_MSG_PUB.add_exc_msg
2002: ( p_pkg_name => 'PA_CONTROL_ITEMS_WORKFLOW'
2003: ,p_procedure_name => 'set_workflow_attributes'
2004: ,p_error_text => x_msg_data);
2005:
2006: IF l_debug_mode = 'Y' THEN

Line 2080: PA_DEBUG.init_err_stack('PA_CONTROL_ITEMS_WORKFLOW.CLOSE_CI_ACTION');

2076: and rownum = 1;
2077:
2078: BEGIN
2079: -- Initialize the Error Stack
2080: PA_DEBUG.init_err_stack('PA_CONTROL_ITEMS_WORKFLOW.CLOSE_CI_ACTION');
2081:
2082:
2083: l_ci_id := wf_engine.GetItemAttrNumber
2084: ( itemtype => itemtype,

Line 2237: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CONTROL_ITEMS_WORKFLOW',

2233: resultout := wf_engine.eng_completed||':'||'F';
2234: WHEN OTHERS THEN
2235: ROLLBACK TO CLOSE_CI_ACTION;
2236: resultout := wf_engine.eng_completed||':'||'F';
2237: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CONTROL_ITEMS_WORKFLOW',
2238: p_procedure_name => 'CLOSE_CI_ACTIONS',
2239: p_error_text => SUBSTRB(SQLERRM,1,240));
2240: RAISE;
2241: END CLOSE_CI_ACTION;

Line 2307: PA_DEBUG.init_err_stack('PA_CONTROL_ITEMS_WORKFLOW.KEEP_OPEN');

2303: from pa_control_items
2304: where ci_id = l_ci_id;
2305: BEGIN
2306: -- Initialize the Error Stack
2307: PA_DEBUG.init_err_stack('PA_CONTROL_ITEMS_WORKFLOW.KEEP_OPEN');
2308:
2309:
2310:
2311: l_ci_id := wf_engine.GetItemAttrNumber

Line 2411: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CONTROL_ITEMS_WORKFLOW',

2407: resultout := wf_engine.eng_completed||':'||'F';
2408: WHEN OTHERS THEN
2409: ROLLBACK TO KEEP_OPEN;
2410: resultout := wf_engine.eng_completed||':'||'F';
2411: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CONTROL_ITEMS_WORKFLOW',
2412: p_procedure_name => 'KEEP_OPEN',
2413: p_error_text => SUBSTRB(SQLERRM,1,240));
2414: RAISE;
2415: END KEEP_OPEN;

Line 2538: END pa_control_items_workflow;

2534:
2535: END close_notification;
2536:
2537:
2538: END pa_control_items_workflow;
2539: