DBA Data[Home] [Help]

APPS.PA_CONTROL_API_PUB dependencies on PA_CONTROL_API_PVT

Line 124: pa_debug.g_err_stage:= 'Before Calling the Private API PA_CONTROL_API_PVT.update_impacts';

120: /*Calling the private API
121: This update_impacts will do all the necessary validations and call
122: other procedure to insert the details*/
123: if l_debug_mode = 'Y' then
124: pa_debug.g_err_stage:= 'Before Calling the Private API PA_CONTROL_API_PVT.update_impacts';
125: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
126: end if;
127:
128:

Line 129: PA_CONTROL_API_PVT.update_impacts(

125: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
126: end if;
127:
128:
129: PA_CONTROL_API_PVT.update_impacts(
130: p_ci_id => p_ci_id,
131: x_ci_impact_id => x_impact_id,
132: p_impact_type_code => l_impact_type_code,
133: p_impact_description => p_impact_description,

Line 255: pa_debug.g_err_stage:= 'Before Calling the Private API PA_CONTROL_API_PVT.update_impacts';

251: /*Calling the private API
252: This update_impacts will do all the necessary validations and call
253: other procedure to insert the details*/
254: if l_debug_mode = 'Y' then
255: pa_debug.g_err_stage:= 'Before Calling the Private API PA_CONTROL_API_PVT.update_impacts';
256: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
257: end if;
258: PA_CONTROL_API_PVT.update_impacts(
259: p_ci_id => p_ci_id,

Line 258: PA_CONTROL_API_PVT.update_impacts(

254: if l_debug_mode = 'Y' then
255: pa_debug.g_err_stage:= 'Before Calling the Private API PA_CONTROL_API_PVT.update_impacts';
256: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
257: end if;
258: PA_CONTROL_API_PVT.update_impacts(
259: p_ci_id => p_ci_id,
260: x_ci_impact_id => x_impact_id,
261: p_impact_type_code => l_impact_type_code,
262: p_impact_description => p_impact_description,

Line 383: pa_debug.g_err_stage:= 'Before Calling the Private API PA_CONTROL_API_PVT.update_impacts';

379: /*Calling the private API
380: This update_impacts will do all the necessary validations and call
381: other procedure to insert the details*/
382: if l_debug_mode = 'Y' then
383: pa_debug.g_err_stage:= 'Before Calling the Private API PA_CONTROL_API_PVT.update_impacts';
384: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
385: end if;
386:
387: PA_CONTROL_API_PVT.update_impacts(

Line 387: PA_CONTROL_API_PVT.update_impacts(

383: pa_debug.g_err_stage:= 'Before Calling the Private API PA_CONTROL_API_PVT.update_impacts';
384: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
385: end if;
386:
387: PA_CONTROL_API_PVT.update_impacts(
388: p_ci_id => p_ci_id,
389: x_ci_impact_id => x_impact_id,
390: p_impact_type_code => l_impact_type_code,
391: p_impact_description => p_impact_description,

Line 508: pa_debug.g_err_stage:= 'Before Calling the Private API PA_CONTROL_API_PVT.update_impacts';

504: /*Calling the private API
505: This update_impacts will do all the necessary validations and call
506: other procedure to insert the details*/
507: if l_debug_mode = 'Y' then
508: pa_debug.g_err_stage:= 'Before Calling the Private API PA_CONTROL_API_PVT.update_impacts';
509: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
510: end if;
511:
512: PA_CONTROL_API_PVT.update_impacts(

Line 512: PA_CONTROL_API_PVT.update_impacts(

508: pa_debug.g_err_stage:= 'Before Calling the Private API PA_CONTROL_API_PVT.update_impacts';
509: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
510: end if;
511:
512: PA_CONTROL_API_PVT.update_impacts(
513: p_ci_id => p_ci_id,
514: x_ci_impact_id => x_impact_id,
515: p_impact_type_code => l_impact_type_code,
516: p_impact_description => p_impact_description,

Line 645: pa_debug.g_err_stage:= 'Before Calling the Private API PA_CONTROL_API_PVT.update_impacts';

641: end if;
642: raise FND_API.G_EXC_ERROR;
643: end if;
644: if l_debug_mode = 'Y' then
645: pa_debug.g_err_stage:= 'Before Calling the Private API PA_CONTROL_API_PVT.update_impacts';
646: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
647: end if;
648: /*Calling the private API
649: This update_impacts will do all the necessary validations and call

Line 651: PA_CONTROL_API_PVT.update_impacts(

647: end if;
648: /*Calling the private API
649: This update_impacts will do all the necessary validations and call
650: other procedure to insert the details*/
651: PA_CONTROL_API_PVT.update_impacts(
652: p_ci_id => p_ci_id,
653: x_ci_impact_id => x_impact_id,
654: p_impact_type_code => l_impact_type_code,
655: p_impact_description => p_impact_description,

Line 673: PA_CONTROL_API_PVT.Add_supplier_details(

669: If any of the details did not get inserted successfully then roll back
670: them including the impact.*/
671: if x_return_status = FND_API.G_RET_STS_SUCCESS and x_impact_id is not null and p_supplier_det_tbl is not null then
672:
673: PA_CONTROL_API_PVT.Add_supplier_details(
674: p_ci_id => p_ci_id,
675: p_ci_impact_id => x_impact_id,
676: p_supplier_det_tbl => p_supplier_det_tbl,
677: x_return_status => x_return_status,

Line 801: pa_debug.g_err_stage:= 'Before Calling the Private API PA_CONTROL_API_PVT.update_impacts';

797: /*Calling the private API
798: This update_impacts will do all the necessary validations and call
799: other procedure to insert the details*/
800: if l_debug_mode = 'Y' then
801: pa_debug.g_err_stage:= 'Before Calling the Private API PA_CONTROL_API_PVT.update_impacts';
802: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
803: end if;
804:
805: PA_CONTROL_API_PVT.update_impacts(

Line 805: PA_CONTROL_API_PVT.update_impacts(

801: pa_debug.g_err_stage:= 'Before Calling the Private API PA_CONTROL_API_PVT.update_impacts';
802: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
803: end if;
804:
805: PA_CONTROL_API_PVT.update_impacts(
806: p_ci_id => p_ci_id ,
807: p_impact_type_code => l_impact_type_code,
808: p_impact_description => p_impact_description,
809: p_api_version_number => p_api_version_number ,

Line 934: pa_debug.g_err_stage:= 'Before Calling the Private API PA_CONTROL_API_PVT.update_impacts';

930: /*Calling the private API
931: This update_impacts will do all the necessary validations and call
932: other procedure to insert the details*/
933: if l_debug_mode = 'Y' then
934: pa_debug.g_err_stage:= 'Before Calling the Private API PA_CONTROL_API_PVT.update_impacts';
935: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
936: end if;
937:
938: PA_CONTROL_API_PVT.update_impacts(

Line 938: PA_CONTROL_API_PVT.update_impacts(

934: pa_debug.g_err_stage:= 'Before Calling the Private API PA_CONTROL_API_PVT.update_impacts';
935: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
936: end if;
937:
938: PA_CONTROL_API_PVT.update_impacts(
939: p_ci_id => p_ci_id ,
940: p_impact_type_code => l_impact_type_code,
941: p_impact_description => p_impact_description,
942: p_api_version_number => p_api_version_number ,

Line 1067: pa_debug.g_err_stage:= 'Before Calling the Private API PA_CONTROL_API_PVT.update_impacts';

1063: /*Calling the private API
1064: This update_impacts will do all the necessary validations and call
1065: other procedure to insert the details*/
1066: if l_debug_mode = 'Y' then
1067: pa_debug.g_err_stage:= 'Before Calling the Private API PA_CONTROL_API_PVT.update_impacts';
1068: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
1069: end if;
1070:
1071: PA_CONTROL_API_PVT.update_impacts(

Line 1071: PA_CONTROL_API_PVT.update_impacts(

1067: pa_debug.g_err_stage:= 'Before Calling the Private API PA_CONTROL_API_PVT.update_impacts';
1068: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
1069: end if;
1070:
1071: PA_CONTROL_API_PVT.update_impacts(
1072: p_ci_id => p_ci_id ,
1073: p_impact_type_code => l_impact_type_code,
1074: p_impact_description => p_impact_description,
1075: p_api_version_number => p_api_version_number ,

Line 1200: pa_debug.g_err_stage:= 'Before Calling the Private API PA_CONTROL_API_PVT.update_impacts';

1196: /*Calling the private API
1197: This update_impacts will do all the necessary validations and call
1198: other procedure to insert the details*/
1199: if l_debug_mode = 'Y' then
1200: pa_debug.g_err_stage:= 'Before Calling the Private API PA_CONTROL_API_PVT.update_impacts';
1201: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
1202: end if;
1203:
1204: PA_CONTROL_API_PVT.update_impacts(

Line 1204: PA_CONTROL_API_PVT.update_impacts(

1200: pa_debug.g_err_stage:= 'Before Calling the Private API PA_CONTROL_API_PVT.update_impacts';
1201: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
1202: end if;
1203:
1204: PA_CONTROL_API_PVT.update_impacts(
1205: p_ci_id => p_ci_id ,
1206: p_impact_type_code => l_impact_type_code,
1207: p_impact_description => p_impact_description,
1208: p_api_version_number => p_api_version_number ,

Line 1330: pa_debug.g_err_stage:= 'Before Calling the Private API PA_CONTROL_API_PVT.update_impacts';

1326: /*Calling the private API
1327: This update_impacts will do all the necessary validations and call
1328: other procedure to insert the details*/
1329: if l_debug_mode = 'Y' then
1330: pa_debug.g_err_stage:= 'Before Calling the Private API PA_CONTROL_API_PVT.update_impacts';
1331: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
1332: end if;
1333: PA_CONTROL_API_PVT.update_impacts(
1334: p_ci_id => p_ci_id ,

Line 1333: PA_CONTROL_API_PVT.update_impacts(

1329: if l_debug_mode = 'Y' then
1330: pa_debug.g_err_stage:= 'Before Calling the Private API PA_CONTROL_API_PVT.update_impacts';
1331: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
1332: end if;
1333: PA_CONTROL_API_PVT.update_impacts(
1334: p_ci_id => p_ci_id ,
1335: p_impact_type_code => l_impact_type_code,
1336: p_impact_description => p_impact_description,
1337: p_api_version_number => p_api_version_number ,

Line 2798: PA_CONTROL_API_PVT.check_create_ci_allowed(

2794: pa_debug.g_err_stage:= 'calling check_create_ci_allowed';
2795: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
2796: end if;
2797:
2798: PA_CONTROL_API_PVT.check_create_ci_allowed(
2799: p_project_id => l_project_id
2800: ,p_project_name => l_project_name
2801: ,p_project_number => l_project_number
2802: ,p_ci_type_class_code => l_class_code

Line 2824: PA_CONTROL_API_PVT.validate_param_and_create(

2820: pa_debug.g_err_stage:= 'about to call validate_param_and_create';
2821: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
2822: end if;
2823:
2824: PA_CONTROL_API_PVT.validate_param_and_create(
2825: p_orig_system_code => p_orig_system_code
2826: ,p_orig_system_reference => p_orig_system_reference
2827: ,p_project_id => l_project_id
2828: ,p_ci_type_id => l_ci_type_id

Line 3433: PA_CONTROL_API_PVT.check_create_ci_allowed(

3429: pa_debug.g_err_stage:= 'calling check_create_ci_allowed';
3430: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
3431: end if;
3432:
3433: PA_CONTROL_API_PVT.check_create_ci_allowed(
3434: p_project_id => l_project_id
3435: ,p_project_name => l_project_name
3436: ,p_project_number => l_project_number
3437: ,p_ci_type_class_code => l_class_code

Line 3459: PA_CONTROL_API_PVT.validate_param_and_create(

3455: pa_debug.g_err_stage:= 'about to call validate_param_and_create';
3456: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
3457: end if;
3458:
3459: PA_CONTROL_API_PVT.validate_param_and_create(
3460: p_orig_system_code => p_orig_system_code
3461: ,p_orig_system_reference => p_orig_system_reference
3462: ,p_project_id => l_project_id
3463: ,p_ci_type_id => l_ci_type_id

Line 4068: PA_CONTROL_API_PVT.check_create_ci_allowed(

4064: pa_debug.g_err_stage:= 'calling check_create_ci_allowed';
4065: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
4066: end if;
4067:
4068: PA_CONTROL_API_PVT.check_create_ci_allowed(
4069: p_project_id => l_project_id
4070: ,p_project_name => l_project_name
4071: ,p_project_number => l_project_number
4072: ,p_ci_type_class_code => l_class_code

Line 4094: PA_CONTROL_API_PVT.validate_param_and_create(

4090: pa_debug.g_err_stage:= 'about to call validate_param_and_create';
4091: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
4092: end if;
4093:
4094: PA_CONTROL_API_PVT.validate_param_and_create(
4095: p_orig_system_code => p_orig_system_code
4096: ,p_orig_system_reference => p_orig_system_reference
4097: ,p_project_id => l_project_id
4098: ,p_ci_type_id => l_ci_type_id

Line 4311: PA_CONTROL_API_PVT.check_create_action_allow(

4307: pa_debug.g_err_stage:= 'Calling check_create_action_allow';
4308: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
4309: end if;
4310:
4311: PA_CONTROL_API_PVT.check_create_action_allow(
4312: p_ci_id => l_ci_id
4313: ,x_project_id => l_project_id
4314: ,x_return_status => x_return_status
4315: ,x_msg_count => x_msg_count

Line 4325: PA_CONTROL_API_PVT.validate_action_attributes(

4321: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
4322: end if;
4323:
4324: /*Passing the l_ci_id here which was validated in check_create_action_allow*/
4325: PA_CONTROL_API_PVT.validate_action_attributes(
4326: p_ci_id => l_ci_id
4327: ,p_project_id => l_project_id
4328: ,p_action_tbl => p_action_tbl
4329: ,x_action_tbl => l_action_tbl

Line 4336: pa_debug.g_err_stage:= 'Calling PA_CONTROL_API_PVT.create_action';

4332: ,x_msg_data => x_msg_data
4333: );
4334:
4335: if l_debug_mode = 'Y' then
4336: pa_debug.g_err_stage:= 'Calling PA_CONTROL_API_PVT.create_action';
4337: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
4338: end if;
4339:
4340: /*Passing the l_ci_id here which was validated in check_create_action_allow*/

Line 4341: PA_CONTROL_API_PVT.create_action(

4337: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
4338: end if;
4339:
4340: /*Passing the l_ci_id here which was validated in check_create_action_allow*/
4341: PA_CONTROL_API_PVT.create_action(
4342: p_action_tbl => l_action_tbl
4343: ,p_ci_id => l_ci_id
4344: ,x_action_tbl => x_action_tbl
4345: ,x_return_status => x_return_status

Line 4527: PA_CONTROL_API_PVT.validate_priv_and_action(

4523: l_party_id := pa_control_items_utils.getpartyid(l_user_id);
4524:
4525: /*Check whether the user has privilige to update this action or not and whether the passed action is valid or not*/
4526: /*for checking the privilege check the party id of the logged in user with party id of person to whom the action is assigned*/
4527: PA_CONTROL_API_PVT.validate_priv_and_action(
4528: p_ci_id => p_ci_id
4529: ,p_action_id => p_action_id
4530: ,p_action_number => p_action_number
4531: ,x_action_id => l_action_id

Line 4766: pa_control_api_pvt.validate_assignee_id(

4762: l_required_by_date := l_required_by_date;
4763: end if;
4764:
4765: /*Validate the reassignee for the action*/
4766: pa_control_api_pvt.validate_assignee_id(
4767: p_assignee_id => p_reassign_to_id
4768: ,p_project_id => l_project_id
4769: ,p_msg_token_num => null --Need to pass this parameter null here for non tokenized messages.
4770: ,x_assignee_id => l_reassign_to_id

Line 5067: /*Calling the procedure in PA_CONTROL_API_PVT.validate_priv_and_action to validate the

5063: --Get the user_id for the logged in user
5064: l_user_id := fnd_global.user_id;
5065:
5066:
5067: /*Calling the procedure in PA_CONTROL_API_PVT.validate_priv_and_action to validate the
5068: P_ci_id and action_id and action number. and it returns the action_id*/
5069: if (l_debug_mode = 'Y') then
5070: pa_debug.g_err_stage := 'Before calling the PA_CONTROL_API_PVT.validate_priv_and_action';
5071: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);

Line 5070: pa_debug.g_err_stage := 'Before calling the PA_CONTROL_API_PVT.validate_priv_and_action';

5066:
5067: /*Calling the procedure in PA_CONTROL_API_PVT.validate_priv_and_action to validate the
5068: P_ci_id and action_id and action number. and it returns the action_id*/
5069: if (l_debug_mode = 'Y') then
5070: pa_debug.g_err_stage := 'Before calling the PA_CONTROL_API_PVT.validate_priv_and_action';
5071: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
5072: end if;
5073: PA_CONTROL_API_PVT.validate_priv_and_action(
5074: p_ci_id => p_ci_id

Line 5073: PA_CONTROL_API_PVT.validate_priv_and_action(

5069: if (l_debug_mode = 'Y') then
5070: pa_debug.g_err_stage := 'Before calling the PA_CONTROL_API_PVT.validate_priv_and_action';
5071: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
5072: end if;
5073: PA_CONTROL_API_PVT.validate_priv_and_action(
5074: p_ci_id => p_ci_id
5075: ,p_action_id => p_action_id
5076: ,p_action_number => p_action_number
5077: ,x_action_id => l_action_id

Line 5229: Internally calls the procedure PA_CONTROL_API_PVT.Delete_CI

5225:
5226:
5227: /*
5228: Procedure Delete_Issue.
5229: Internally calls the procedure PA_CONTROL_API_PVT.Delete_CI
5230: to delete the Issue. The internal procedure is responsible
5231: for all validations.
5232: */
5233: Procedure Delete_Issue (

Line 5302: PA_CONTROL_API_PVT.Delete_CI (

5298: END IF;
5299: CLOSE Get_CI_Type_Class_Code;
5300:
5301: -- Call the procedure Delete_CI to delete the Control Item.
5302: PA_CONTROL_API_PVT.Delete_CI (
5303: p_Commit => p_Commit
5304: , p_Init_Msg_List => 'F'
5305: , p_Api_Version_Number => p_Api_Version_Number
5306: , p_Ci_Id => p_Ci_Id

Line 5382: Internally calls the procedure PA_CONTROL_API_PVT.Delete_CI

5378: END Delete_Issue;
5379:
5380: /*
5381: Procedure Delete_Change_Request.
5382: Internally calls the procedure PA_CONTROL_API_PVT.Delete_CI
5383: to delete the Issue. The internal procedure is responsible
5384: for all validations.
5385: */
5386: Procedure Delete_Change_Request (

Line 5455: PA_CONTROL_API_PVT.Delete_CI (

5451: END IF;
5452: CLOSE Get_CI_Type_Class_Code;
5453:
5454: -- Call the procedure Delete_CI to delete the Control Item.
5455: PA_CONTROL_API_PVT.Delete_CI (
5456: p_Commit => p_Commit
5457: , p_Init_Msg_List => 'F'
5458: , p_Api_Version_Number => p_Api_Version_Number
5459: , p_Ci_Id => p_Ci_Id

Line 5539: Internally calls the procedure PA_CONTROL_API_PVT.Delete_CI

5535: END Delete_Change_Request;
5536:
5537: /*
5538: Procedure Delete_Change_Order.
5539: Internally calls the procedure PA_CONTROL_API_PVT.Delete_CI
5540: to delete the Issue. The internal procedure is responsible
5541: for all validations.
5542: */
5543: Procedure Delete_Change_Order (

Line 5610: PA_CONTROL_API_PVT.Delete_CI (

5606: END IF;
5607: CLOSE Get_CI_Type_Class_Code;
5608:
5609: -- Call the procedure Delete_CI to delete the Control Item.
5610: PA_CONTROL_API_PVT.Delete_CI (
5611: p_Commit => p_Commit
5612: , p_Init_Msg_List => 'F'
5613: , p_Api_Version_Number => p_Api_Version_Number
5614: , p_Ci_Id => p_Ci_Id