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.PV_PRGM_APPROVAL_PVT dependencies on PVX_UTILITY_PVT

Line 2647: l_param_tbl_var PVX_UTILITY_PVT.log_params_tbl_type;

2643: l_program_id NUMBER;
2644: l_previous_end_date DATE;
2645: l_message_code VARCHAR2(30);
2646: L_ORDER_HEADER_ID NUMBER;
2647: l_param_tbl_var PVX_UTILITY_PVT.log_params_tbl_type;
2648: l_attr_id_exists varchar2(1):=null;
2649: l_program_name VARCHAR2(60);
2650:
2651: BEGIN

Line 2773: PVX_UTILITY_PVT.create_history_log

2769:
2770: l_param_tbl_var(1).param_name := 'PROGRAM_NAME';
2771: l_param_tbl_var(1).param_value := l_program_name;
2772:
2773: PVX_UTILITY_PVT.create_history_log
2774: ( p_arc_history_for_entity_code => 'ENRQ'
2775: ,p_history_for_entity_id => enrl_request_id
2776: ,p_history_category_code => 'APPROVAL'
2777: ,p_message_code => 'PV_ENR_REQ_APPROVED'

Line 2781: ,p_interaction_level => PVX_Utility_PVT.G_INTERACTION_LEVEL_50

2777: ,p_message_code => 'PV_ENR_REQ_APPROVED'
2778: ,p_comments => null
2779: ,p_partner_id => l_partner_id
2780: ,p_access_level_flag => 'P'
2781: ,p_interaction_level => PVX_Utility_PVT.G_INTERACTION_LEVEL_50
2782: ,p_log_params_tbl => l_param_tbl_var
2783: ,p_init_msg_list => FND_API.g_false
2784: ,p_commit => FND_API.G_FALSE
2785: ,x_return_status => x_return_status

Line 2797: PVX_UTILITY_PVT.create_history_log

2793: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
2794: RAISE FND_API.g_exc_unexpected_error;
2795: END IF;
2796:
2797: PVX_UTILITY_PVT.create_history_log
2798: ( p_arc_history_for_entity_code => 'MEMBERSHIP'
2799: ,p_history_for_entity_id => enrl_request_id
2800: ,p_history_category_code => 'APPROVAL'
2801: ,p_message_code => 'PV_PRGM_MEMB_CREATED'

Line 2805: ,p_interaction_level => PVX_Utility_PVT.G_INTERACTION_LEVEL_50

2801: ,p_message_code => 'PV_PRGM_MEMB_CREATED'
2802: ,p_comments => null
2803: ,p_partner_id => l_partner_id
2804: ,p_access_level_flag => 'P'
2805: ,p_interaction_level => PVX_Utility_PVT.G_INTERACTION_LEVEL_50
2806: ,p_log_params_tbl => l_param_tbl_var
2807: ,p_init_msg_list => FND_API.g_false
2808: ,p_commit => FND_API.G_FALSE
2809: ,x_return_status => x_return_status

Line 3285: l_param_tbl_var PVX_UTILITY_PVT.log_params_tbl_type;

3281: l_itemkey VARCHAR2(30);
3282: l_object_version_number NUMBER(9);
3283: l_resource_name VARCHAR2(360);
3284: l_resource_id NUMBER;
3285: l_param_tbl_var PVX_UTILITY_PVT.log_params_tbl_type;
3286: l_partner_id NUMBER;
3287: l_display_name VARCHAR2(240);
3288: l_personid NUMBER;
3289: x_role_name VARCHAR2(320);

Line 3330: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

3326: END IF;
3327:
3328: -- Debug Message
3329: IF (PV_DEBUG_HIGH_ON) THEN
3330: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
3331: END IF;
3332: -- Initialize API return status to SUCCESS
3333: x_return_status := FND_API.G_RET_STS_SUCCESS;
3334:

Line 3702: PVX_UTILITY_PVT.create_history_log

3698: -- also log into enrollment history that its beem send to default approver.
3699:
3700: l_param_tbl_var(1).param_name := 'APPROVER_NAME';
3701: l_param_tbl_var(1).param_value := l_display_name;
3702: PVX_UTILITY_PVT.create_history_log
3703: ( p_arc_history_for_entity_code => 'ENRQ'
3704: , p_history_for_entity_id => enrl_request_id
3705: , p_history_category_code => 'APPROVAL'
3706: , p_message_code => 'PV_ENR_REQ_TO_DEFAULT_APPR'

Line 3710: , p_interaction_level => PVX_Utility_PVT.G_INTERACTION_LEVEL_10

3706: , p_message_code => 'PV_ENR_REQ_TO_DEFAULT_APPR'
3707: , p_comments => null
3708: , p_partner_id => l_partner_id
3709: , p_access_level_flag => 'P'
3710: , p_interaction_level => PVX_Utility_PVT.G_INTERACTION_LEVEL_10
3711: , p_log_params_tbl => l_param_tbl_var
3712: , p_init_msg_list => FND_API.g_false
3713: , p_commit => FND_API.G_FALSE
3714: , x_return_status => x_return_status

Line 3799: PVX_UTILITY_PVT.create_history_log

3795: ELSE
3796: l_param_tbl_var(1).param_value := adminApprRec.display_name;
3797: END If;
3798: ----DBMS_OUTPUT.PUT_LINE('exception');
3799: PVX_UTILITY_PVT.create_history_log
3800: ( p_arc_history_for_entity_code => 'ENRQ'
3801: , p_history_for_entity_id => enrl_request_id
3802: , p_history_category_code => 'APPROVAL'
3803: , p_message_code => 'PV_ERROR_ENR_APPROVAL'

Line 3807: , p_interaction_level => PVX_Utility_PVT.G_INTERACTION_LEVEL_10

3803: , p_message_code => 'PV_ERROR_ENR_APPROVAL'
3804: , p_comments => null
3805: , p_partner_id => l_partner_id
3806: , p_access_level_flag => 'P'
3807: , p_interaction_level => PVX_Utility_PVT.G_INTERACTION_LEVEL_10
3808: , p_log_params_tbl => l_param_tbl_var
3809: , p_init_msg_list => FND_API.g_false
3810: , p_commit => FND_API.G_FALSE
3811: , x_return_status => x_return_status

Line 3965: PVX_UTILITY_PVT.create_history_log

3961: l_param_tbl_var(1).param_value := currApprRec.display_name;
3962: END If;
3963:
3964:
3965: PVX_UTILITY_PVT.create_history_log
3966: ( p_arc_history_for_entity_code => 'ENRQ'
3967: , p_history_for_entity_id => enrl_request_id
3968: , p_history_category_code => 'APPROVAL'
3969: , p_message_code => 'PV_ENR_REQ_SUBMITTED_TO_APPR'

Line 3973: , p_interaction_level => PVX_Utility_PVT.G_INTERACTION_LEVEL_10

3969: , p_message_code => 'PV_ENR_REQ_SUBMITTED_TO_APPR'
3970: , p_comments => null
3971: , p_partner_id => l_partner_id
3972: , p_access_level_flag => 'P'
3973: , p_interaction_level => PVX_Utility_PVT.G_INTERACTION_LEVEL_10
3974: , p_log_params_tbl => l_param_tbl_var
3975: , p_init_msg_list => FND_API.g_false
3976: , p_commit => FND_API.G_FALSE
3977: , x_return_status => x_return_status

Line 4089: l_param_tbl_var PVX_UTILITY_PVT.log_params_tbl_type;

4085: l_message_code varchar2(30);
4086: l_contract_signed boolean:=false;
4087: l_checklistStatus boolean:=false;
4088: l_allow_appr_wo_contract varchar2(5);
4089: l_param_tbl_var PVX_UTILITY_PVT.log_params_tbl_type;
4090: l_param_tbl_default PVX_UTILITY_PVT.log_params_tbl_type;
4091: l_resource_name VARCHAR2(360);
4092: l_resource_id NUMBER;
4093: l_default_approver_id NUMBER;

Line 4090: l_param_tbl_default PVX_UTILITY_PVT.log_params_tbl_type;

4086: l_contract_signed boolean:=false;
4087: l_checklistStatus boolean:=false;
4088: l_allow_appr_wo_contract varchar2(5);
4089: l_param_tbl_var PVX_UTILITY_PVT.log_params_tbl_type;
4090: l_param_tbl_default PVX_UTILITY_PVT.log_params_tbl_type;
4091: l_resource_name VARCHAR2(360);
4092: l_resource_id NUMBER;
4093: l_default_approver_id NUMBER;
4094: l_default_person_id NUMBER;

Line 4149: PVX_UTILITY_PVT.debug_message('FND Global user id is'|| FND_GLOBAL.USER_ID );

4145: -- Initialize message list if p_init_msg_list is set to TRUE.
4146: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4147: FND_MSG_PUB.initialize;
4148: END IF;
4149: PVX_UTILITY_PVT.debug_message('FND Global user id is'|| FND_GLOBAL.USER_ID );
4150: PVX_UTILITY_PVT.debug_message('FND Employee user id is'|| FND_GLOBAL.EMPLOYEE_ID );
4151: -- Debug Message
4152: IF (PV_DEBUG_HIGH_ON) THEN
4153: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

Line 4150: PVX_UTILITY_PVT.debug_message('FND Employee user id is'|| FND_GLOBAL.EMPLOYEE_ID );

4146: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4147: FND_MSG_PUB.initialize;
4148: END IF;
4149: PVX_UTILITY_PVT.debug_message('FND Global user id is'|| FND_GLOBAL.USER_ID );
4150: PVX_UTILITY_PVT.debug_message('FND Employee user id is'|| FND_GLOBAL.EMPLOYEE_ID );
4151: -- Debug Message
4152: IF (PV_DEBUG_HIGH_ON) THEN
4153: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
4154: PVX_UTILITY_PVT.debug_message('FND Global user id is'|| FND_GLOBAL.USER_ID );

Line 4153: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

4149: PVX_UTILITY_PVT.debug_message('FND Global user id is'|| FND_GLOBAL.USER_ID );
4150: PVX_UTILITY_PVT.debug_message('FND Employee user id is'|| FND_GLOBAL.EMPLOYEE_ID );
4151: -- Debug Message
4152: IF (PV_DEBUG_HIGH_ON) THEN
4153: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
4154: PVX_UTILITY_PVT.debug_message('FND Global user id is'|| FND_GLOBAL.USER_ID );
4155: PVX_UTILITY_PVT.debug_message('FND Employee user id is'|| FND_GLOBAL.EMPLOYEE_ID );
4156: END IF;
4157: -- Initialize API return status to SUCCESS

Line 4154: PVX_UTILITY_PVT.debug_message('FND Global user id is'|| FND_GLOBAL.USER_ID );

4150: PVX_UTILITY_PVT.debug_message('FND Employee user id is'|| FND_GLOBAL.EMPLOYEE_ID );
4151: -- Debug Message
4152: IF (PV_DEBUG_HIGH_ON) THEN
4153: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
4154: PVX_UTILITY_PVT.debug_message('FND Global user id is'|| FND_GLOBAL.USER_ID );
4155: PVX_UTILITY_PVT.debug_message('FND Employee user id is'|| FND_GLOBAL.EMPLOYEE_ID );
4156: END IF;
4157: -- Initialize API return status to SUCCESS
4158: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4155: PVX_UTILITY_PVT.debug_message('FND Employee user id is'|| FND_GLOBAL.EMPLOYEE_ID );

4151: -- Debug Message
4152: IF (PV_DEBUG_HIGH_ON) THEN
4153: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
4154: PVX_UTILITY_PVT.debug_message('FND Global user id is'|| FND_GLOBAL.USER_ID );
4155: PVX_UTILITY_PVT.debug_message('FND Employee user id is'|| FND_GLOBAL.EMPLOYEE_ID );
4156: END IF;
4157: -- Initialize API return status to SUCCESS
4158: x_return_status := FND_API.G_RET_STS_SUCCESS;
4159: --RAISE FND_API.g_exc_error;

Line 4246: PVX_UTILITY_PVT.create_history_log

4242: l_param_tbl_var(1).param_name := 'APPROVER_NAME';
4243: l_param_tbl_var(1).param_value := x_role_display_name;
4244:
4245: --write to enrollments log that xyz approver approved it or rejected it
4246: PVX_UTILITY_PVT.create_history_log
4247: ( p_arc_history_for_entity_code => 'ENRQ'
4248: , p_history_for_entity_id => enrl_request_id
4249: , p_history_category_code => 'APPROVAL'
4250: , p_message_code => l_message_code

Line 4254: , p_interaction_level => PVX_Utility_PVT.G_INTERACTION_LEVEL_50

4250: , p_message_code => l_message_code
4251: , p_comments => null
4252: , p_partner_id => l_partner_id
4253: , p_access_level_flag => 'P'
4254: , p_interaction_level => PVX_Utility_PVT.G_INTERACTION_LEVEL_50
4255: , p_log_params_tbl => l_param_tbl_var
4256: , p_init_msg_list => FND_API.g_false
4257: , p_commit => FND_API.G_FALSE
4258: , x_return_status => x_return_status

Line 4350: PVX_UTILITY_PVT.create_history_log

4346: END IF;
4347: END IF;
4348: ELSE
4349: -- means current approver is not in the list of approvers anymore
4350: PVX_UTILITY_PVT.create_history_log
4351: ( p_arc_history_for_entity_code => 'ENRQ'
4352: , p_history_for_entity_id => enrl_request_id
4353: , p_history_category_code => 'APPROVAL'
4354: , p_message_code => 'PV_APPROVER_CHANGED'

Line 4358: , p_interaction_level => PVX_Utility_PVT.G_INTERACTION_LEVEL_10

4354: , p_message_code => 'PV_APPROVER_CHANGED'
4355: , p_comments => null
4356: , p_partner_id => l_partner_id
4357: , p_access_level_flag => 'P'
4358: , p_interaction_level => PVX_Utility_PVT.G_INTERACTION_LEVEL_10
4359: , p_log_params_tbl => l_param_tbl_var
4360: , p_init_msg_list => FND_API.g_false
4361: , p_commit => FND_API.G_FALSE
4362: , x_return_status => x_return_status

Line 4400: PVX_UTILITY_PVT.debug_message('FND l_default_person_id is'|| l_default_person_id );

4396: END IF;
4397: OPEN person_id_csr (l_default_approver_id);
4398: FETCH person_id_csr INTO l_default_person_id,l_display_name;
4399: CLOSE person_id_csr;
4400: PVX_UTILITY_PVT.debug_message('FND l_default_person_id is'|| l_default_person_id );
4401: IF l_default_person_id=l_approverPersonId THEN
4402: --there is no need to call OAM if the request has gone to default approver
4403: /*PVX_UTILITY_PVT.create_history_log
4404: ( p_arc_history_for_entity_code => 'ENRQ'

Line 4403: /*PVX_UTILITY_PVT.create_history_log

4399: CLOSE person_id_csr;
4400: PVX_UTILITY_PVT.debug_message('FND l_default_person_id is'|| l_default_person_id );
4401: IF l_default_person_id=l_approverPersonId THEN
4402: --there is no need to call OAM if the request has gone to default approver
4403: /*PVX_UTILITY_PVT.create_history_log
4404: ( p_arc_history_for_entity_code => 'ENRQ'
4405: , p_history_for_entity_id => enrl_request_id
4406: , p_history_category_code => 'APPROVAL'
4407: , p_message_code => l_message_code

Line 4411: , p_interaction_level => PVX_Utility_PVT.G_INTERACTION_LEVEL_10

4407: , p_message_code => l_message_code
4408: , p_comments => null
4409: , p_partner_id => l_partner_id
4410: , p_access_level_flag => 'P'
4411: , p_interaction_level => PVX_Utility_PVT.G_INTERACTION_LEVEL_10
4412: , p_log_params_tbl => l_param_tbl_var
4413: , p_init_msg_list => FND_API.g_false
4414: , p_commit => FND_API.G_FALSE
4415: , x_return_status => x_return_status

Line 4456: PVX_UTILITY_PVT.create_history_log

4452: RAISE FND_API.g_exc_unexpected_error;
4453: END IF;
4454: ELSE
4455: --write to the logs that the current approver for this enrollment request has changed
4456: PVX_UTILITY_PVT.create_history_log
4457: ( p_arc_history_for_entity_code => 'ENRQ'
4458: , p_history_for_entity_id => enrl_request_id
4459: , p_history_category_code => 'APPROVAL'
4460: , p_message_code => 'PV_APPROVER_CHANGED'

Line 4464: , p_interaction_level => PVX_Utility_PVT.G_INTERACTION_LEVEL_10

4460: , p_message_code => 'PV_APPROVER_CHANGED'
4461: , p_comments => null
4462: , p_partner_id => l_partner_id
4463: , p_access_level_flag => 'P'
4464: , p_interaction_level => PVX_Utility_PVT.G_INTERACTION_LEVEL_10
4465: , p_log_params_tbl => l_param_tbl_var
4466: , p_init_msg_list => FND_API.g_false
4467: , p_commit => FND_API.G_FALSE
4468: , x_return_status => x_return_status

Line 4658: l_param_tbl_var PVX_UTILITY_PVT.log_params_tbl_type;

4654: l_membership_id NUMBER;
4655: l_original_end_date DATE;
4656: l_mmbr_transition_id NUMBER;
4657: l_message_code VARCHAR2(30);
4658: l_param_tbl_var PVX_UTILITY_PVT.log_params_tbl_type;
4659: l_api_name CONSTANT VARCHAR2(30) := 'terminate_downgrade_memb';
4660: l_api_version_number CONSTANT NUMBER := 1.0;
4661: l_memb_active BOOLEAN:=false;
4662: l_program_name VARCHAR2(60);

Line 4699: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

4695:
4696: -- Debug Message
4697: IF (PV_DEBUG_HIGH_ON) THEN
4698:
4699: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
4700: END IF;
4701:
4702: -- Initialize API return status to SUCCESS
4703: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4710: PVX_UTILITY_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

4706: -- Validate Environment
4707: -- =========================================================================
4708:
4709: IF FND_GLOBAL.USER_ID IS NULL THEN
4710: PVX_UTILITY_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
4711: RAISE FND_API.G_EXC_ERROR;
4712: END IF;
4713:
4714:

Line 4874: PVX_UTILITY_PVT.create_history_log

4870: l_message_code:='PV_MEMBERSHIP_TERMINATED';
4871: END IF;
4872:
4873: --call the history log api to capture any comments from the user
4874: PVX_UTILITY_PVT.create_history_log
4875: ( p_arc_history_for_entity_code => 'ENRQ'
4876: ,p_history_for_entity_id => l_enrl_request_id
4877: ,p_history_category_code => 'APPROVAL'
4878: ,p_message_code => l_message_code

Line 4882: ,p_interaction_level => PVX_Utility_PVT.G_INTERACTION_LEVEL_10

4878: ,p_message_code => l_message_code
4879: ,p_comments => null
4880: ,p_partner_id => l_partner_id
4881: ,p_access_level_flag => 'P'
4882: ,p_interaction_level => PVX_Utility_PVT.G_INTERACTION_LEVEL_10
4883: ,p_log_params_tbl => l_param_tbl_var
4884: ,p_init_msg_list => FND_API.g_false
4885: ,p_commit => FND_API.G_FALSE
4886: ,x_return_status => x_return_status

Line 4905: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

4901:
4902: -- Debug Message
4903: IF (PV_DEBUG_HIGH_ON) THEN
4904:
4905: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
4906: END IF;
4907:
4908:
4909: -- Standard call to get message count and if count is 1, get message info.

Line 4917: WHEN PVX_UTILITY_PVT.resource_locked THEN

4913: );
4914:
4915: EXCEPTION
4916:
4917: WHEN PVX_UTILITY_PVT.resource_locked THEN
4918: x_return_status := FND_API.g_ret_sts_error;
4919: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
4920:
4921: WHEN FND_API.G_EXC_ERROR THEN

Line 4919: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');

4915: EXCEPTION
4916:
4917: WHEN PVX_UTILITY_PVT.resource_locked THEN
4918: x_return_status := FND_API.g_ret_sts_error;
4919: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
4920:
4921: WHEN FND_API.G_EXC_ERROR THEN
4922: ROLLBACK TO terminate_downgrade_memb;
4923: x_return_status := FND_API.G_RET_STS_ERROR;

Line 4992: l_param_tbl_var PVX_UTILITY_PVT.log_params_tbl_type;

4988: l_membership_id NUMBER;
4989: l_entity_approver_id NUMBER;
4990: l_enrl_request_id NUMBER;
4991: l_default_program_id NUMBER:=null;
4992: l_param_tbl_var PVX_UTILITY_PVT.log_params_tbl_type;
4993: --This value for l_default_approver_id needs to be retrieved from profile
4994: l_isPrimaryFlag VARCHAR2(1);
4995: l_program_name VARCHAR2(60);
4996:

Line 5034: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

5030:
5031: -- Debug Message
5032: IF (PV_DEBUG_HIGH_ON) THEN
5033:
5034: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
5035: END IF;
5036:
5037: -- Initialize API return status to SUCCESS
5038: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 5045: PVX_UTILITY_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

5041: -- Validate Environment
5042: -- =========================================================================
5043:
5044: IF FND_GLOBAL.USER_ID IS NULL THEN
5045: PVX_UTILITY_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
5046: RAISE FND_API.G_EXC_ERROR;
5047: END IF;
5048: --create an enrollment request with approved status
5049:

Line 5136: PVX_UTILITY_PVT.create_history_log

5132: --call the history log api to capture any comments from the user
5133: l_param_tbl_var(1).param_name := 'PROGRAM_NAME';
5134: l_param_tbl_var(1).param_value := l_program_name;
5135:
5136: PVX_UTILITY_PVT.create_history_log
5137: ( p_arc_history_for_entity_code => 'MEMBERSHIP'
5138: ,p_history_for_entity_id => l_enrl_request_id
5139: ,p_history_category_code => 'APPROVAL'
5140: ,p_message_code => 'PV_DEFAULT_MEMBERSHIP'

Line 5144: ,p_interaction_level => PVX_Utility_PVT.G_INTERACTION_LEVEL_50

5140: ,p_message_code => 'PV_DEFAULT_MEMBERSHIP'
5141: ,p_comments => null
5142: ,p_partner_id => p_partner_id
5143: ,p_access_level_flag => 'P'
5144: ,p_interaction_level => PVX_Utility_PVT.G_INTERACTION_LEVEL_50
5145: ,p_log_params_tbl => l_param_tbl_var
5146: ,p_init_msg_list => FND_API.g_false
5147: ,p_commit => FND_API.G_FALSE
5148: ,x_return_status => x_return_status

Line 5312: PVX_UTILITY_PVT.debug_message( 'Private API: ' || l_api_name || 'start' );

5308: IF FND_API.to_Boolean( p_init_msg_list ) THEN
5309: FND_MSG_PUB.initialize;
5310: END IF;
5311: -- Debug Message
5312: PVX_UTILITY_PVT.debug_message( 'Private API: ' || l_api_name || 'start' );
5313: -- Initialize API return status to SUCCESS
5314: x_return_status := FND_API.G_RET_STS_SUCCESS;
5315: -- Validate Environment
5316: IF FND_GLOBAL.USER_ID IS NULL THEN

Line 5317: PVX_UTILITY_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

5313: -- Initialize API return status to SUCCESS
5314: x_return_status := FND_API.G_RET_STS_SUCCESS;
5315: -- Validate Environment
5316: IF FND_GLOBAL.USER_ID IS NULL THEN
5317: PVX_UTILITY_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
5318: RAISE FND_API.G_EXC_ERROR;
5319: END IF;
5320:
5321: --validate the lookupcode for target category

Line 5322: l_lookup_exists := PVX_UTILITY_PVT.check_lookup_exists

5318: RAISE FND_API.G_EXC_ERROR;
5319: END IF;
5320:
5321: --validate the lookupcode for target category
5322: l_lookup_exists := PVX_UTILITY_PVT.check_lookup_exists
5323: ( p_lookup_table_name => 'PV_LOOKUPS'
5324: ,p_lookup_type => 'PV_ENRQ_REQUEST_STATUS_CODE'
5325: ,p_lookup_code => p_enrq_status
5326: );

Line 5445: PVX_UTILITY_PVT.debug_message( 'Private API: ' || l_api_name || 'end' );

5441: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5442: END IF;
5443: END IF;
5444: -- Debug Message
5445: PVX_UTILITY_PVT.debug_message( 'Private API: ' || l_api_name || 'end' );
5446: -- Standard call to get message count and if count is 1, get message info.
5447: FND_MSG_PUB.Count_And_Get
5448: (
5449: p_count => x_msg_count