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.6.12000000.6 2007/07/05 06:49:22 sugupta 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 635: p_err_stack := p_err_stack ||'->PA_CREATE_RESOURCE.create_resource_list';

631: BEGIN
632:
633: l_old_stack := p_err_stack;
634: p_err_code := 0;
635: p_err_stack := p_err_stack ||'->PA_CREATE_RESOURCE.create_resource_list';
636: p_err_stage := 'Select x from pa_resource_lists ';
637:
638: -- First clear the message stack if called from html.
639: IF p_migration_code IS NOT NULL THEN

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

1485: BEGIN
1486: l_old_stack := p_err_stack;
1487: p_err_code := 0;
1488: p_err_stack :=
1489: p_err_stack ||'->PA_CREATE_RESOURCE.Create_Resource_txn_Attribute';
1490:
1491:
1492: p_err_stage := 'Select resource_class_code from pa_resource_types_active_v';
1493:

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

1746: BEGIN
1747: l_old_stack := p_err_stack;
1748: p_err_code := 0;
1749: p_err_stack :=
1750: p_err_stack ||'->PA_CREATE_RESOURCE.Create_Resource_list_member';
1751:
1752: -- Based on the Resource_type_code Ensure that the corresponding
1753: -- attribute has a valid value.
1754:

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

2295: BEGIN
2296:
2297: l_old_stack := p_err_stack;
2298: p_err_code := 0;
2299: p_err_stack := p_err_stack ||'->PA_CREATE_RESOURCE.Create_Resource';
2300:
2301: IF p_resource_type_code IS NULL THEN
2302: p_err_code := 10;
2303: p_err_stage := 'PA_RL_RES_TYPE_CODE_REQD';

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

2682:
2683: BEGIN
2684: l_old_stack := p_err_stack;
2685: p_err_code := 0;
2686: p_err_stack := p_err_stack||'->PA_CREATE_RESOURCE.add_resource_list_member';
2687: p_err_stage := ' Select group_resource_type_id from pa_resource_lists';
2688:
2689: -- Get Resource List Id ,Group_resource_type_id from
2690: -- PA_RESOURCE_LISTS with the

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

3353:
3354: V_old_stack := X_err_stack;
3355: X_err_code := 0;
3356: X_err_stack :=
3357: X_err_stack ||'->PA_CREATE_RESOURCE.Create_Default_Res_List';
3358:
3359: X_err_stage := 'Select seeded_resource_list From PA_RESOURCE_LISTS';
3360:
3361: FOR eachRL IN Seeded_RLs LOOP

Line 3763: P_Pkg_Name => 'PA_CREATE_RESOURCE',

3759: X_Return_Status := Fnd_Api.G_Ret_Sts_UnExp_Error;
3760: x_msg_count := x_msg_count + 1;
3761: x_error_msg_data := Null;
3762: Fnd_Msg_Pub.Add_Exc_Msg(
3763: P_Pkg_Name => 'PA_CREATE_RESOURCE',
3764: P_Procedure_Name => 'Create_Proj_Resource_List');
3765:
3766: Return;
3767:

Line 3781: P_Pkg_Name => 'PA_CREATE_RESOURCE',

3777: X_Return_Status := Fnd_Api.G_Ret_Sts_UnExp_Error;
3778: x_msg_count := x_msg_count + 1;
3779: x_error_msg_data := Null;
3780: Fnd_Msg_Pub.Add_Exc_Msg(
3781: P_Pkg_Name => 'PA_CREATE_RESOURCE',
3782: P_Procedure_Name => 'Create_Proj_Resource_List');
3783:
3784: Return;
3785: END;

Line 4002: P_Pkg_Name => 'PA_CREATE_RESOURCE',

3998: X_Return_Status := Fnd_Api.G_Ret_Sts_UnExp_Error;
3999: x_msg_count := x_msg_count + 1;
4000: x_error_msg_data := Null;
4001: Fnd_Msg_Pub.Add_Exc_Msg(
4002: P_Pkg_Name => 'PA_CREATE_RESOURCE',
4003: P_Procedure_Name => 'Create_Proj_Resource_List');
4004:
4005: Return;
4006: END Create_Proj_Resource_List;

Line 4095: 'PA_CREATE_RESOURCE') Then

4091: If Not Fnd_Api.Compatible_API_Call (
4092: l_Api_Version,
4093: P_Api_Version_Number,
4094: l_Api_Name,
4095: 'PA_CREATE_RESOURCE') Then
4096:
4097: Raise Fnd_Api.G_Exc_Unexpected_Error;
4098:
4099: End If;

Line 5123: END PA_CREATE_RESOURCE;

5119: X_LAST_UPDATE_LOGIN => 0 );*/
5120:
5121: END LOAD_ROW;
5122:
5123: END PA_CREATE_RESOURCE;