eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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.13.12020000.5 2013/04/09 17:55:19 rboyalap 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 550: -- Procedure pa_acc_gen_wf_pkg.SetPa_Item_Attr

546:
547: ------------------- End of procedure wf_acc_Derive_pa_params -------------------
548:
549: ----------------------------------------------------------------------
550: -- Procedure pa_acc_gen_wf_pkg.SetPa_Item_Attr
551: -- Definition of package body and procedure in package specifications
552: ----------------------------------------------------------------------
553: PROCEDURE Set_Pa_Item_Attr
554: (

Line 735: ------------------- End pa_acc_gen_wf_pkg.Set_pa_item_attr --------------------

731: /* Bug 5233487 - End */
732: g_error_message := SQLERRM;
733: RAISE;
734: END set_pa_item_attr;
735: ------------------- End pa_acc_gen_wf_pkg.Set_pa_item_attr --------------------
736:
737: ----------------------------------------------------------------------
738: -- Procedure pa_acc_gen_wf_pkg.ap_er_generate_account
739: -- Definition of package body and function in package specifications

Line 738: -- Procedure pa_acc_gen_wf_pkg.ap_er_generate_account

734: END set_pa_item_attr;
735: ------------------- End pa_acc_gen_wf_pkg.Set_pa_item_attr --------------------
736:
737: ----------------------------------------------------------------------
738: -- Procedure pa_acc_gen_wf_pkg.ap_er_generate_account
739: -- Definition of package body and function in package specifications
740: ----------------------------------------------------------------------
741:
742: FUNCTION ap_er_generate_account

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

849: ---------------------------------------------------------------
850: -- Derive Organization id if employee id is present and
851: -- organization id is null
852: ---------------------------------------------------------------
853: set_error_stack('-->pa_acc_gen_wf_pkg.ap_er_generate_account'); /* Bug 5233487 */
854: g_encoded_error_message := NULL; /* Bug 5233487 */
855: g_error_stage := '10';
856: g_error_message := '';
857:

Line 895: pa_acc_gen_wf_pkg.wf_acc_derive_er_params

891: ---------------------------------------------------------------------
892: g_error_stage := '20';
893: l_employee_ccid := p_employee_ccid;
894:
895: pa_acc_gen_wf_pkg.wf_acc_derive_er_params
896: (
897: p_project_id => p_project_id,
898: p_task_id => l_task_id, -- Modified for bug 16613999
899: p_expenditure_type => p_expenditure_type,

Line 944: pa_acc_gen_wf_pkg.Set_Pa_Item_Attr(

940: -- Initialize the workflow item attributes
941: ---------------------------------------------
942: g_error_stage := '40';
943:
944: pa_acc_gen_wf_pkg.Set_Pa_Item_Attr(
945: p_itemtype => l_itemtype,
946: p_itemkey => l_itemkey,
947: p_project_id => p_project_id,
948: p_task_id => l_task_id, -- Modified for bug 16613999

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

1518: x_error_message := g_encoded_error_message;
1519: reset_error_stack;
1520: /* Bug 5233487 - End */
1521:
1522: wf_core.context( pkg_name => 'pa_acc_gen_wf_pkg',
1523: proc_name => 'ap_er_generate_account',
1524: arg1 => 'Project id: '||p_project_id,
1525: arg2 => 'Task id: '||l_task_id, -- Modified for bug 16613999
1526: arg3 => 'Vendor id: '||p_vendor_id,

Line 1535: -- Procedure pa_acc_gen_wf_pkg.ap_inv_generate_account

1531:
1532: END ap_er_generate_account;
1533:
1534: ----------------------------------------------------------------------
1535: -- Procedure pa_acc_gen_wf_pkg.ap_inv_generate_account
1536: -- Definition of package body and function in package specifications
1537: ----------------------------------------------------------------------
1538:
1539: FUNCTION ap_inv_generate_account

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

1643: ---------------------------------------------------------------------
1644: -- Call the procedure to obtain the derived parameters from the raw
1645: -- parameters
1646: ---------------------------------------------------------------------
1647: set_error_stack('-->pa_acc_gen_wf_pkg.ap_inv_generate_account'); /* Bug 5233487 */
1648: g_encoded_error_message := NULL; /* Bug 5233487 */
1649: g_error_stage := '10';
1650: g_error_message := '';
1651:

Line 1672: pa_acc_gen_wf_pkg.wf_acc_derive_params

1668: END;
1669: END IF;
1670: -- End: Added for bug 16613999
1671:
1672: pa_acc_gen_wf_pkg.wf_acc_derive_params
1673: (
1674: p_project_id => p_project_id,
1675: p_task_id => l_task_id, -- Modified for bug 16613999
1676: p_expenditure_type => p_expenditure_type,

Line 1716: pa_acc_gen_wf_pkg.Set_Pa_Item_Attr(

1712: -- Initialize the workflow item attributes
1713: ---------------------------------------------
1714: g_error_stage := '30';
1715:
1716: pa_acc_gen_wf_pkg.Set_Pa_Item_Attr(
1717: p_itemtype => l_itemtype,
1718: p_itemkey => l_itemkey,
1719: p_project_id => p_project_id,
1720: p_task_id => l_task_id, -- Modified for bug 16613999

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

2302: reset_error_stack;
2303: /* Bug 5233487 - End */
2304:
2305:
2306: wf_core.context( pkg_name => 'pa_acc_gen_wf_pkg',
2307: proc_name => 'ap_inv_generate_account',
2308: arg1 => 'Project id: '||p_project_id,
2309: arg2 => 'Task id: '||l_task_id, -- Modified for bug 16613999
2310: arg3 => 'Vendor id: '||p_vendor_id,

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

2463: -- Record error using generic error message routine for debugging and
2464: -- raise it
2465: -----------------------------------------------------------------------
2466:
2467: wf_core.context( pkg_name => 'pa_acc_gen_wf_pkg',
2468: proc_name => 'ap_inv_upgrade_flex_account',
2469: arg1 => 'Project Id: ' ||l_project_id,
2470: arg2 => 'Task Id: ' ||l_task_id,
2471: arg3 => 'Vendor Id: ' ||l_vendor_id,

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

2526: -- Record error using generic error message routine for debugging and
2527: -- raise it
2528: -----------------------------------------------------------------------
2529:
2530: wf_core.context( pkg_name => 'pa_acc_gen_wf_pkg ',
2531: proc_name => 'ap_inv_acc_undefined_rules',
2532: arg1 => 'Error: Default workflow not defined',
2533: arg2 => null,
2534: arg3 => null,

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

2667: WHEN no_lookup_type
2668: THEN
2669: reset_error_stack; /* Bug 5233487 */
2670: -- Record standard workflow debugging message
2671: wf_core.context( pkg_name => 'PA_ACC_GEN_WF_PKG ',
2672: proc_name => 'PA_SEG_LOOKUP_SET_VALUE',
2673: arg1 => 'Lookup Set:' || l_seg_value_lookup_set_name,
2674: arg2 => 'Intermediate Value: ' || l_intermediate_value,
2675: arg3 => 'Lookup type null',

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

2701: WHEN no_lookup_code
2702: THEN
2703: reset_error_stack; /* Bug 5233487 */
2704: -- Record standard workflow debugging message
2705: wf_core.context( pkg_name => 'PA_ACC_GEN_WF_PKG ',
2706: proc_name => 'PA_SEG_LOOKUP_SET_VALUE',
2707: arg1 => 'Lookup Set:' || l_seg_value_lookup_set_name,
2708: arg2 => 'Intermediate Value: ' || l_intermediate_value,
2709: arg3 => 'Lookup code null',

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

2742: WHEN no_data_found
2743: THEN
2744: reset_error_stack; /* Bug 5233487 */
2745: -- Record standard workflow debugging message
2746: wf_core.context( pkg_name => 'PA_ACC_GEN_WF_PKG ',
2747: proc_name => 'PA_SEG_LOOKUP_SET_VALUE',
2748: arg1 => 'Lookup Set:' || l_seg_value_lookup_set_name,
2749: arg2 => 'Intermediate Value: ' || l_intermediate_value,
2750: arg3 => 'Lookup code null',

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

2788: -- more specific debugging, we have used these 2 arguments to identify the
2789: -- record in error( i.e. lookup_set_name and intermediate_value).
2790: --
2791:
2792: l_error_message := pa_acc_gen_wf_pkg.show_error(p_error_stack => g_error_stack,
2793: p_error_stage => g_error_stage,
2794: p_error_message => g_error_message,
2795: p_arg1 => 'Lookup Set:'||l_seg_value_lookup_set_name,
2796: p_arg2 => 'Intermediate Value: ' || l_intermediate_value);

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

2808:
2809: x_result := 'COMPLETE:FAILURE';
2810:
2811: -- Record standard workflow debugging message
2812: wf_core.context( pkg_name => 'PA_ACC_GEN_WF_PKG ',
2813: proc_name => 'PA_SEG_LOOKUP_SET_VALUE',
2814: arg1 => 'Lookup Set:' || l_seg_value_lookup_set_name,
2815: arg2 => 'Intermediate Value: ' || l_intermediate_value,
2816: arg3 => null,

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

3043: -- more specific debugging, we have used these 2 arguments to identify the
3044: -- record in error( i.e. l_function_transaction_c and l_ptype_class_code).
3045: --
3046:
3047: l_error_message := pa_acc_gen_wf_pkg.show_error(p_error_stack => g_error_stack,
3048: p_error_stage => g_error_stage,
3049: p_error_message => g_error_message,
3050: p_arg1 => 'Function Transaction code:'||l_ft_code,
3051: p_arg2 => 'Project Type Class Code: ' || l_ptype_class_code);

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

3062:
3063: x_result := 'COMPLETE:FAILURE';
3064:
3065: -- Record standard workflow debugging message
3066: wf_core.context( pkg_name => 'PA_ACC_GEN_WF_PKG ',
3067: proc_name => 'PA_AA_FUNCTION_TRANSACTION',
3068: arg1 => 'Function Transaction Code' || l_ft_code,
3069: arg2 => 'Project Type Class Code: ' || l_ptype_class_code,
3070: arg3 => null,

Line 3132: END pa_acc_gen_wf_pkg ;

3128: END IF;
3129: END reset_error_stack;
3130: /* Bug 5233487 - End */
3131:
3132: END pa_acc_gen_wf_pkg ;