DBA Data[Home] [Help]

APPS.PA_ACC_GEN_WF_PKG dependencies on PA_ACC_GEN_WF_PKG

Line 1: PACKAGE BODY pa_acc_gen_wf_pkg AS

1: PACKAGE BODY pa_acc_gen_wf_pkg AS
2: /* $Header: PAXWFACB.pls 120.11.12010000.2 2008/08/22 16:20:06 mumohan ship $ */
3:
4: /***Bug 3182416 :Moved the declaration of g_ variables to spec .
5: g_error_message VARCHAR2(1000) :='';

Line 15: -- Procedure pa_acc_gen_wf_pkg.wf_acc_derive_params

11: TYPE ErrorStack IS TABLE OF VARCHAR2(500) INDEX BY BINARY_INTEGER;
12: g_error_stack_history ErrorStack;
13:
14: ----------------------------------------------------------------------
15: -- Procedure pa_acc_gen_wf_pkg.wf_acc_derive_params
16: -- Definition of procedure in package specifications
17: ----------------------------------------------------------------------
18:
19: PROCEDURE wf_acc_derive_params (

Line 135: pa_acc_gen_wf_pkg.wf_acc_derive_pa_params(

131: -- Derive project information
132: ---------------------------------------------------------------
133: g_error_stage := '30';
134:
135: pa_acc_gen_wf_pkg.wf_acc_derive_pa_params(
136: p_project_id ,
137: p_task_id ,
138: p_expenditure_type ,
139: p_expenditure_organization_id ,

Line 174: -- Procedure pa_acc_gen_wf_pkg.wf_acc_derive_er_params

170:
171: ------------------- End of procedure wf_acc_Derive_params ---------------------
172:
173: ----------------------------------------------------------------------
174: -- Procedure pa_acc_gen_wf_pkg.wf_acc_derive_er_params
175: -- Definition of procedure in package specifications
176: ----------------------------------------------------------------------
177:
178: PROCEDURE wf_acc_derive_er_params (

Line 305: pa_acc_gen_wf_pkg.wf_acc_derive_pa_params(

301: -- Derive project information
302: ---------------------------------------------------------------
303: g_error_stage := '40';
304:
305: pa_acc_gen_wf_pkg.wf_acc_derive_pa_params(
306: p_project_id ,
307: p_task_id ,
308: p_expenditure_type ,
309: p_expenditure_organization_id ,

Line 345: -- Procedure pa_acc_gen_wf_pkg.wf_acc_derive_pa_params

341:
342: ------------------- End of procedure wf_acc_Derive_er_params ------------------
343:
344: ----------------------------------------------------------------------
345: -- Procedure pa_acc_gen_wf_pkg.wf_acc_derive_pa_params
346: -- Definition of package body and function in package specifications
347: ----------------------------------------------------------------------
348:
349:

Line 515: -- Procedure pa_acc_gen_wf_pkg.SetPa_Item_Attr

511:
512: ------------------- End of procedure wf_acc_Derive_pa_params -------------------
513:
514: ----------------------------------------------------------------------
515: -- Procedure pa_acc_gen_wf_pkg.SetPa_Item_Attr
516: -- Definition of package body and procedure in package specifications
517: ----------------------------------------------------------------------
518: PROCEDURE Set_Pa_Item_Attr
519: (

Line 700: ------------------- End pa_acc_gen_wf_pkg.Set_pa_item_attr --------------------

696: /* Bug 5233487 - End */
697: g_error_message := SQLERRM;
698: RAISE;
699: END set_pa_item_attr;
700: ------------------- End pa_acc_gen_wf_pkg.Set_pa_item_attr --------------------
701:
702: ----------------------------------------------------------------------
703: -- Procedure pa_acc_gen_wf_pkg.ap_er_generate_account
704: -- Definition of package body and function in package specifications

Line 703: -- Procedure pa_acc_gen_wf_pkg.ap_er_generate_account

699: END set_pa_item_attr;
700: ------------------- End pa_acc_gen_wf_pkg.Set_pa_item_attr --------------------
701:
702: ----------------------------------------------------------------------
703: -- Procedure pa_acc_gen_wf_pkg.ap_er_generate_account
704: -- Definition of package body and function in package specifications
705: ----------------------------------------------------------------------
706:
707: FUNCTION ap_er_generate_account

Line 813: set_error_stack('-->pa_acc_gen_wf_pkg.ap_er_generate_account'); /* Bug 5233487 */

809: ---------------------------------------------------------------
810: -- Derive Organization id if employee id is present and
811: -- organization id is null
812: ---------------------------------------------------------------
813: set_error_stack('-->pa_acc_gen_wf_pkg.ap_er_generate_account'); /* Bug 5233487 */
814: g_encoded_error_message := NULL; /* Bug 5233487 */
815: g_error_stage := '10';
816: g_error_message := '';
817:

Line 835: pa_acc_gen_wf_pkg.wf_acc_derive_er_params

831: ---------------------------------------------------------------------
832: g_error_stage := '20';
833: l_employee_ccid := p_employee_ccid;
834:
835: pa_acc_gen_wf_pkg.wf_acc_derive_er_params
836: (
837: p_project_id => p_project_id,
838: p_task_id => p_task_id,
839: p_expenditure_type => p_expenditure_type,

Line 884: pa_acc_gen_wf_pkg.Set_Pa_Item_Attr(

880: -- Initialize the workflow item attributes
881: ---------------------------------------------
882: g_error_stage := '40';
883:
884: pa_acc_gen_wf_pkg.Set_Pa_Item_Attr(
885: p_itemtype => l_itemtype,
886: p_itemkey => l_itemkey,
887: p_project_id => p_project_id,
888: p_task_id => p_task_id,

Line 1455: wf_core.context( pkg_name => 'pa_acc_gen_wf_pkg',

1451: x_error_message := g_encoded_error_message;
1452: reset_error_stack;
1453: /* Bug 5233487 - End */
1454:
1455: wf_core.context( pkg_name => 'pa_acc_gen_wf_pkg',
1456: proc_name => 'ap_er_generate_account',
1457: arg1 => 'Project id: '||p_project_id,
1458: arg2 => 'Task id: '||p_task_id,
1459: arg3 => 'Vendor id: '||p_vendor_id,

Line 1468: -- Procedure pa_acc_gen_wf_pkg.ap_inv_generate_account

1464:
1465: END ap_er_generate_account;
1466:
1467: ----------------------------------------------------------------------
1468: -- Procedure pa_acc_gen_wf_pkg.ap_inv_generate_account
1469: -- Definition of package body and function in package specifications
1470: ----------------------------------------------------------------------
1471:
1472: FUNCTION ap_inv_generate_account

Line 1575: set_error_stack('-->pa_acc_gen_wf_pkg.ap_inv_generate_account'); /* Bug 5233487 */

1571: ---------------------------------------------------------------------
1572: -- Call the procedure to obtain the derived parameters from the raw
1573: -- parameters
1574: ---------------------------------------------------------------------
1575: set_error_stack('-->pa_acc_gen_wf_pkg.ap_inv_generate_account'); /* Bug 5233487 */
1576: g_encoded_error_message := NULL; /* Bug 5233487 */
1577: g_error_stage := '10';
1578: g_error_message := '';
1579:

Line 1580: pa_acc_gen_wf_pkg.wf_acc_derive_params

1576: g_encoded_error_message := NULL; /* Bug 5233487 */
1577: g_error_stage := '10';
1578: g_error_message := '';
1579:
1580: pa_acc_gen_wf_pkg.wf_acc_derive_params
1581: (
1582: p_project_id => p_project_id,
1583: p_task_id => p_task_id,
1584: p_expenditure_type => p_expenditure_type,

Line 1624: pa_acc_gen_wf_pkg.Set_Pa_Item_Attr(

1620: -- Initialize the workflow item attributes
1621: ---------------------------------------------
1622: g_error_stage := '30';
1623:
1624: pa_acc_gen_wf_pkg.Set_Pa_Item_Attr(
1625: p_itemtype => l_itemtype,
1626: p_itemkey => l_itemkey,
1627: p_project_id => p_project_id,
1628: p_task_id => p_task_id,

Line 2207: wf_core.context( pkg_name => 'pa_acc_gen_wf_pkg',

2203: reset_error_stack;
2204: /* Bug 5233487 - End */
2205:
2206:
2207: wf_core.context( pkg_name => 'pa_acc_gen_wf_pkg',
2208: proc_name => 'ap_inv_generate_account',
2209: arg1 => 'Project id: '||p_project_id,
2210: arg2 => 'Task id: '||p_task_id,
2211: arg3 => 'Vendor id: '||p_vendor_id,

Line 2368: wf_core.context( pkg_name => 'pa_acc_gen_wf_pkg',

2364: -- Record error using generic error message routine for debugging and
2365: -- raise it
2366: -----------------------------------------------------------------------
2367:
2368: wf_core.context( pkg_name => 'pa_acc_gen_wf_pkg',
2369: proc_name => 'ap_inv_upgrade_flex_account',
2370: arg1 => 'Project Id: ' ||l_project_id,
2371: arg2 => 'Task Id: ' ||l_task_id,
2372: arg3 => 'Vendor Id: ' ||l_vendor_id,

Line 2431: wf_core.context( pkg_name => 'pa_acc_gen_wf_pkg ',

2427: -- Record error using generic error message routine for debugging and
2428: -- raise it
2429: -----------------------------------------------------------------------
2430:
2431: wf_core.context( pkg_name => 'pa_acc_gen_wf_pkg ',
2432: proc_name => 'ap_inv_acc_undefined_rules',
2433: arg1 => 'Error: Default workflow not defined',
2434: arg2 => null,
2435: arg3 => null,

Line 2572: wf_core.context( pkg_name => 'PA_ACC_GEN_WF_PKG ',

2568: WHEN no_lookup_type
2569: THEN
2570: reset_error_stack; /* Bug 5233487 */
2571: -- Record standard workflow debugging message
2572: wf_core.context( pkg_name => 'PA_ACC_GEN_WF_PKG ',
2573: proc_name => 'PA_SEG_LOOKUP_SET_VALUE',
2574: arg1 => 'Lookup Set:' || l_seg_value_lookup_set_name,
2575: arg2 => 'Intermediate Value: ' || l_intermediate_value,
2576: arg3 => 'Lookup type null',

Line 2606: wf_core.context( pkg_name => 'PA_ACC_GEN_WF_PKG ',

2602: WHEN no_lookup_code
2603: THEN
2604: reset_error_stack; /* Bug 5233487 */
2605: -- Record standard workflow debugging message
2606: wf_core.context( pkg_name => 'PA_ACC_GEN_WF_PKG ',
2607: proc_name => 'PA_SEG_LOOKUP_SET_VALUE',
2608: arg1 => 'Lookup Set:' || l_seg_value_lookup_set_name,
2609: arg2 => 'Intermediate Value: ' || l_intermediate_value,
2610: arg3 => 'Lookup code null',

Line 2647: wf_core.context( pkg_name => 'PA_ACC_GEN_WF_PKG ',

2643: WHEN no_data_found
2644: THEN
2645: reset_error_stack; /* Bug 5233487 */
2646: -- Record standard workflow debugging message
2647: wf_core.context( pkg_name => 'PA_ACC_GEN_WF_PKG ',
2648: proc_name => 'PA_SEG_LOOKUP_SET_VALUE',
2649: arg1 => 'Lookup Set:' || l_seg_value_lookup_set_name,
2650: arg2 => 'Intermediate Value: ' || l_intermediate_value,
2651: arg3 => 'Lookup code null',

Line 2693: l_error_message := pa_acc_gen_wf_pkg.show_error(p_error_stack => g_error_stack,

2689: -- more specific debugging, we have used these 2 arguments to identify the
2690: -- record in error( i.e. lookup_set_name and intermediate_value).
2691: --
2692:
2693: l_error_message := pa_acc_gen_wf_pkg.show_error(p_error_stack => g_error_stack,
2694: p_error_stage => g_error_stage,
2695: p_error_message => g_error_message,
2696: p_arg1 => 'Lookup Set:'||l_seg_value_lookup_set_name,
2697: p_arg2 => 'Intermediate Value: ' || l_intermediate_value);

Line 2713: wf_core.context( pkg_name => 'PA_ACC_GEN_WF_PKG ',

2709:
2710: x_result := 'COMPLETE:FAILURE';
2711:
2712: -- Record standard workflow debugging message
2713: wf_core.context( pkg_name => 'PA_ACC_GEN_WF_PKG ',
2714: proc_name => 'PA_SEG_LOOKUP_SET_VALUE',
2715: arg1 => 'Lookup Set:' || l_seg_value_lookup_set_name,
2716: arg2 => 'Intermediate Value: ' || l_intermediate_value,
2717: arg3 => null,

Line 2948: l_error_message := pa_acc_gen_wf_pkg.show_error(p_error_stack => g_error_stack,

2944: -- more specific debugging, we have used these 2 arguments to identify the
2945: -- record in error( i.e. l_function_transaction_c and l_ptype_class_code).
2946: --
2947:
2948: l_error_message := pa_acc_gen_wf_pkg.show_error(p_error_stack => g_error_stack,
2949: p_error_stage => g_error_stage,
2950: p_error_message => g_error_message,
2951: p_arg1 => 'Function Transaction code:'||l_ft_code,
2952: p_arg2 => 'Project Type Class Code: ' || l_ptype_class_code);

Line 2967: wf_core.context( pkg_name => 'PA_ACC_GEN_WF_PKG ',

2963:
2964: x_result := 'COMPLETE:FAILURE';
2965:
2966: -- Record standard workflow debugging message
2967: wf_core.context( pkg_name => 'PA_ACC_GEN_WF_PKG ',
2968: proc_name => 'PA_AA_FUNCTION_TRANSACTION',
2969: arg1 => 'Function Transaction Code' || l_ft_code,
2970: arg2 => 'Project Type Class Code: ' || l_ptype_class_code,
2971: arg3 => null,

Line 3033: END pa_acc_gen_wf_pkg ;

3029: END IF;
3030: END reset_error_stack;
3031: /* Bug 5233487 - End */
3032:
3033: END pa_acc_gen_wf_pkg ;