APPS.PA_CREATE_RESOURCE dependencies on PA_CREATE_RESOURCE

Line 1: PACKAGE BODY PA_CREATE_RESOURCE AS

1: PACKAGE BODY PA_CREATE_RESOURCE AS
2: /* $Header: PACRRESB.pls 120.20 2012/02/03 14:06:38 djambhek ship $*/
3:
4: FUNCTION chk_plan_rl_unique (p_resource_list_name IN VARCHAR2,
5: p_resource_list_id IN NUMBER) return BOOLEAN;

Line 157: p_err_stack := p_err_stack ||'->PA_CREATE_RESOURCE.create_resource_group';

153:
154: BEGIN
155: l_old_stack := p_err_stack;
156: p_err_code := 0;
157: p_err_stack := p_err_stack ||'->PA_CREATE_RESOURCE.create_resource_group';
158: p_err_stage := ' Select group_resource_type_id from pa_resource_lists';
159:
160: -- Get Resource List Id ,Group_resource_type_id from
161: -- PA_RESOURCE_LISTS with the

Line 647: p_err_stack := p_err_stack ||'->PA_CREATE_RESOURCE.create_resource_list';

643: BEGIN
644:
645: l_old_stack := p_err_stack;
646: p_err_code := 0;
647: p_err_stack := p_err_stack ||'->PA_CREATE_RESOURCE.create_resource_list';
648: p_err_stage := 'Select x from pa_resource_lists ';
649:
650: -- First clear the message stack if called from html.
651: IF p_migration_code IS NOT NULL THEN

Line 1837: p_err_stack ||'->PA_CREATE_RESOURCE.Create_Resource_txn_Attribute';

1833: BEGIN
1834: l_old_stack := p_err_stack;
1835: p_err_code := 0;
1836: p_err_stack :=
1837: p_err_stack ||'->PA_CREATE_RESOURCE.Create_Resource_txn_Attribute';
1838:
1839:
1840: p_err_stage := 'Select resource_class_code from pa_resource_types_active_v';
1841:

Line 2098: p_err_stack ||'->PA_CREATE_RESOURCE.Create_Resource_list_member';

2094: BEGIN
2095: l_old_stack := p_err_stack;
2096: p_err_code := 0;
2097: p_err_stack :=
2098: p_err_stack ||'->PA_CREATE_RESOURCE.Create_Resource_list_member';
2099:
2100: -- Based on the Resource_type_code Ensure that the corresponding
2101: -- attribute has a valid value.
2102:

Line 2647: p_err_stack := p_err_stack ||'->PA_CREATE_RESOURCE.Create_Resource';

2643: BEGIN
2644:
2645: l_old_stack := p_err_stack;
2646: p_err_code := 0;
2647: p_err_stack := p_err_stack ||'->PA_CREATE_RESOURCE.Create_Resource';
2648:
2649: IF p_resource_type_code IS NULL THEN
2650: p_err_code := 10;
2651: p_err_stage := 'PA_RL_RES_TYPE_CODE_REQD';

Line 3034: p_err_stack := p_err_stack||'->PA_CREATE_RESOURCE.add_resource_list_member';

3030:
3031: BEGIN
3032: l_old_stack := p_err_stack;
3033: p_err_code := 0;
3034: p_err_stack := p_err_stack||'->PA_CREATE_RESOURCE.add_resource_list_member';
3035: p_err_stage := ' Select group_resource_type_id from pa_resource_lists';
3036:
3037: -- Get Resource List Id ,Group_resource_type_id from
3038: -- PA_RESOURCE_LISTS with the

Line 3706: X_err_stack ||'->PA_CREATE_RESOURCE.Create_Default_Res_List';

3702:
3703: V_old_stack := X_err_stack;
3704: X_err_code := 0;
3705: X_err_stack :=
3706: X_err_stack ||'->PA_CREATE_RESOURCE.Create_Default_Res_List';
3707:
3708: X_err_stage := 'Select seeded_resource_list From PA_RESOURCE_LISTS';
3709:
3710: FOR eachRL IN Seeded_RLs LOOP

Line 4112: P_Pkg_Name => 'PA_CREATE_RESOURCE',

4108: X_Return_Status := Fnd_Api.G_Ret_Sts_UnExp_Error;
4109: x_msg_count := x_msg_count + 1;
4110: x_error_msg_data := Null;
4111: Fnd_Msg_Pub.Add_Exc_Msg(
4112: P_Pkg_Name => 'PA_CREATE_RESOURCE',
4113: P_Procedure_Name => 'Create_Proj_Resource_List');
4114:
4115: Return;
4116:

Line 4130: P_Pkg_Name => 'PA_CREATE_RESOURCE',

4126: X_Return_Status := Fnd_Api.G_Ret_Sts_UnExp_Error;
4127: x_msg_count := x_msg_count + 1;
4128: x_error_msg_data := Null;
4129: Fnd_Msg_Pub.Add_Exc_Msg(
4130: P_Pkg_Name => 'PA_CREATE_RESOURCE',
4131: P_Procedure_Name => 'Create_Proj_Resource_List');
4132:
4133: Return;
4134: END;

Line 4353: P_Pkg_Name => 'PA_CREATE_RESOURCE',

4349: X_Return_Status := Fnd_Api.G_Ret_Sts_UnExp_Error;
4350: x_msg_count := x_msg_count + 1;
4351: x_error_msg_data := Null;
4352: Fnd_Msg_Pub.Add_Exc_Msg(
4353: P_Pkg_Name => 'PA_CREATE_RESOURCE',
4354: P_Procedure_Name => 'Create_Proj_Resource_List');
4355:
4356: Return;
4357: END Create_Proj_Resource_List;

Line 4447: 'PA_CREATE_RESOURCE') Then

4443: If Not Fnd_Api.Compatible_API_Call (
4444: l_Api_Version,
4445: P_Api_Version_Number,
4446: l_Api_Name,
4447: 'PA_CREATE_RESOURCE') Then
4448:
4449: Raise Fnd_Api.G_Exc_Unexpected_Error;
4450:
4451: End If;

Line 5478: END PA_CREATE_RESOURCE;

5474: X_LAST_UPDATE_LOGIN => 0 );*/
5475:
5476: END LOAD_ROW;
5477:
5478: END PA_CREATE_RESOURCE;