[Home] [Help]
92: END IF;
93: */
94: -- Debug Message
95: IF (PV_DEBUG_HIGH_ON) THEN
96: PVX_UTILITY_PVT.debug_message( p_module_name ||' : '|| p_text);
97: END IF;
98:
99: END debug_message;
100:
822: x_pgp_notif_rec.notif_type_code := p_notif_type_code;
823:
824: -- Debug Message
825: IF (PV_DEBUG_HIGH_ON) THEN
826: PVX_UTILITY_PVT.debug_message('Set_Pgp_Notif');
827: END IF;
828:
829: EXCEPTION
830: WHEN OTHERS THEN
1008: -- l_newline VARCHAR2(5) := '
';
1009: l_newline VARCHAR2(5) := wf_core.newline;
1010:
1011: l_notif_rule_active VARCHAR2(1):='N';
1012: l_log_params_tbl PVX_UTILITY_PVT.log_params_tbl_type;
1013:
1014: BEGIN
1015: /* Standard Start of API savepoint */
1016: SAVEPOINT send_thnkyou_notif_PVT;
1037: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
1038: THEN
1039: /* Debug message */
1040: IF (PV_DEBUG_HIGH_ON) THEN
1041: PVX_UTILITY_PVT.debug_message('Validate_Enrl_Requests_Id');
1042: END IF;
1043: /* Invoke validation procedures */
1044: Validate_Enrl_Requests
1045: ( p_enrl_request_id
1310: l_log_params_tbl(3).param_name := 'ITEM_ID';
1311: l_log_params_tbl(3).param_value := p_enrl_request_id;
1312:
1313: /* call transaction history log to record this log. */
1314: PVX_Utility_PVT.create_history_log(
1315: p_arc_history_for_entity_code => 'GENERAL', --'ENRQ',
1316: p_history_for_entity_id => l_prtnr_vndr_relship_id, --p_enrl_request_id,
1317: p_history_category_code => 'ENROLLMENT',
1318: p_message_code => 'PV_NOTIF_HISTORY_MSG',
1472: l_newline VARCHAR2(5) := '
'; -- not using wf_core as we are using pl/sql document
1473: -- l_newline VARCHAR2(5) := wf_core.newline;
1474:
1475: l_notif_rule_active VARCHAR2(1):='N';
1476: l_log_params_tbl PVX_UTILITY_PVT.log_params_tbl_type;
1477: l_prtner_portal_url VARCHAR2(4000);
1478: l_login_url VARCHAR2(4000);
1479:
1480: BEGIN
1504: THEN
1505: /* Debug message */
1506: IF (PV_DEBUG_HIGH_ON) THEN
1507:
1508: PVX_UTILITY_PVT.debug_message('Validate_membership_Id');
1509: END IF;
1510:
1511: /* Invoke validation procedures */
1512: Validate_Enrl_Requests
1809: l_log_params_tbl(3).param_name := 'ITEM_ID';
1810: l_log_params_tbl(3).param_value := p_membership_id;
1811:
1812: /* call transaction history log to record this log. */
1813: PVX_Utility_PVT.create_history_log(
1814: p_arc_history_for_entity_code=> 'MBRSHIP',
1815: p_history_for_entity_id => p_membership_id,
1816: p_history_category_code => 'APPROVAL',
1817: p_message_code => 'PV_NOTIF_HISTORY_MSG',
1973: -- l_newline VARCHAR2(5) := '
';
1974: l_newline VARCHAR2(5) := wf_core.newline;
1975:
1976: l_notif_rule_active VARCHAR2(1):='N';
1977: l_log_params_tbl PVX_UTILITY_PVT.log_params_tbl_type;
1978:
1979: BEGIN
1980: -- Standard Start of API savepoint
1981: SAVEPOINT send_rejection_notif_PVT;
2003: THEN
2004: -- Debug message
2005: IF (PV_DEBUG_HIGH_ON) THEN
2006:
2007: PVX_UTILITY_PVT.debug_message('Validate_Enrl_Requests_Id');
2008: END IF;
2009:
2010: -- Invoke validation procedures
2011: Validate_Enrl_Requests
2080: THEN
2081: -- Debug message
2082: IF (PV_DEBUG_HIGH_ON) THEN
2083:
2084: PVX_UTILITY_PVT.debug_message('Validate_Enrl_Requestor_Resource_Id');
2085: END IF;
2086:
2087: -- Invoke validation procedures
2088: Validate_Enrl_Requests
2291: l_log_params_tbl(3).param_name := 'ITEM_ID';
2292: l_log_params_tbl(3).param_value := p_enrl_request_id;
2293:
2294: /* call transaction history log to record this log. */
2295: PVX_Utility_PVT.create_history_log(
2296: p_arc_history_for_entity_code=> 'GENERAL', --'ENRQ',
2297: p_history_for_entity_id => l_prtnr_vndr_relship_id, --p_enrl_request_id,
2298: p_history_category_code => 'APPROVAL',
2299: p_message_code => 'PV_NOTIF_HISTORY_MSG',
2455: -- l_newline VARCHAR2(5) := '
';
2456: l_newline VARCHAR2(5) := wf_core.newline;
2457:
2458: l_notif_rule_active VARCHAR2(1):='N';
2459: l_log_params_tbl PVX_UTILITY_PVT.log_params_tbl_type;
2460:
2461: BEGIN
2462: -- Standard Start of API savepoint
2463: SAVEPOINT send_cntrct_notrcvd_notif_PVT;
2485: THEN
2486: -- Debug message
2487: IF (PV_DEBUG_HIGH_ON) THEN
2488:
2489: PVX_UTILITY_PVT.debug_message('Validate_Enrl_Requests_Id');
2490: END IF;
2491:
2492: -- Invoke validation procedures
2493: Validate_Enrl_Requests
2753: l_log_params_tbl(3).param_name := 'ITEM_ID';
2754: l_log_params_tbl(3).param_value := p_enrl_request_id;
2755:
2756: /* call transaction history log to record this log. */
2757: PVX_Utility_PVT.create_history_log(
2758: p_arc_history_for_entity_code => 'GENERAL', --'ENRQ',
2759: p_history_for_entity_id => l_prtnr_vndr_relship_id, --p_enrl_request_id,
2760: p_history_category_code => 'CONTRACT',
2761: p_message_code => 'PV_NOTIF_HISTORY_MSG',
2919: l_newline VARCHAR2(5) := '
'; -- not using wf_core as we are using pl/sql document
2920: -- l_newline VARCHAR2(5) := wf_core.newline;
2921:
2922: l_notif_rule_active VARCHAR2(1);
2923: l_log_params_tbl PVX_UTILITY_PVT.log_params_tbl_type;
2924: l_prtner_portal_url VARCHAR2(2000);
2925: l_login_url VARCHAR2(4000);
2926:
2927: BEGIN
2951: THEN
2952: -- Debug message
2953: IF (PV_DEBUG_HIGH_ON) THEN
2954:
2955: PVX_UTILITY_PVT.debug_message('Validate_Membership_Id');
2956: END IF;
2957:
2958: -- Invoke validation procedures
2959: Validate_Enrl_Requests
3031: THEN
3032: -- Debug message
3033: IF (PV_DEBUG_HIGH_ON) THEN
3034:
3035: PVX_UTILITY_PVT.debug_message('Validate_Enrl_Requestor_Resource_Id');
3036: END IF;
3037:
3038: -- Invoke validation procedures
3039: Validate_Enrl_Requests
3265: l_log_params_tbl(3).param_name := 'ITEM_ID';
3266: l_log_params_tbl(3).param_value := p_membership_id;
3267:
3268: /* call transaction history log to record this log. */
3269: PVX_Utility_PVT.create_history_log(
3270: p_arc_history_for_entity_code => 'MBRSHIP',
3271: p_history_for_entity_id => p_membership_id,
3272: p_history_category_code => 'PAYMENT',
3273: p_message_code => 'PV_NOTIF_HISTORY_MSG',
3414: l_pgp_notif_rec PV_GE_PARTY_NOTIF_PVT.pgp_notif_rec_type ;
3415: l_arc_notif_for_entity_code VARCHAR2(30) := 'ENRQ';
3416: l_notif_type_code VARCHAR2(30) ;
3417: l_history_category_code VARCHAR2(30) ;
3418: l_log_params_tbl PVX_UTILITY_PVT.log_params_tbl_type;
3419:
3420: BEGIN
3421:
3422: /* Standard Start of API savepoint */
3445: THEN
3446: /* Debug message */
3447: IF (PV_DEBUG_HIGH_ON) THEN
3448:
3449: PVX_UTILITY_PVT.debug_message('Validate_partner_contact_resource_Id');
3450: END IF;
3451:
3452: /* Invoke validation procedures */
3453:
3466:
3467: /* Debug message */
3468: IF (PV_DEBUG_HIGH_ON) THEN
3469:
3470: PVX_UTILITY_PVT.debug_message('Validate_partner_vendor_relship_Id');
3471: END IF;
3472:
3473: /* Invoke validation procedures */
3474: Validate_Enrl_Requests
3642: END IF;
3643:
3644: /* call transaction history log to record this log. */
3645:
3646: PVX_Utility_PVT.create_history_log(
3647: p_arc_history_for_entity_code => 'GENERAL', --ENRQ',
3648: p_history_for_entity_id => p_mbrship_chng_rec.partner_id, --p_mbrship_chng_rec.id,
3649: p_history_category_code => l_history_category_code,
3650: p_message_code => 'PV_NOTIF_HISTORY_MSG',
3778: p_membership_id => l_mbrship_id );
3779:
3780: IF (X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS ) THEN
3781: FND_MESSAGE.SET_NAME('PV','PV_API_ERROR_MESSAGE');
3782: FND_MESSAGE.SET_TOKEN('PROC_NAME','PVX_Utility_PVT.send_ini_rmdr_notif');
3783: FND_MESSAGE.SET_TOKEN('ITEM_NAME','MEMBERSHIP_ID');
3784: FND_MESSAGE.SET_TOKEN('ITEM_ID',l_mbrship_id);
3785: FND_MSG_PUB.Add;
3786: END IF;
3805: p_enrl_request_id => l_enrl_req_id );
3806:
3807: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
3808: FND_MESSAGE.SET_NAME('PV','PV_API_ERROR_MESSAGE');
3809: FND_MESSAGE.SET_TOKEN('PROC_NAME','PVX_Utility_PVT.send_ini_rmdr_notif');
3810: FND_MESSAGE.SET_TOKEN('ITEM_NAME','ENRL_REQUEST_ID');
3811: FND_MESSAGE.SET_TOKEN('ITEM_ID',l_enrl_req_id);
3812: FND_MSG_PUB.Add;
3813: END IF;
4241:
4242: /* Declaration of local variables. */
4243: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
4244: l_status BOOLEAN;
4245: l_log_params_tbl PVX_UTILITY_PVT.log_params_tbl_type;
4246: l_membership_id NUMBER;
4247: l_obj_version_no NUMBER;
4248: l_current_mbrship_id NUMBER;
4249: l_future_mbrship_id NUMBER;
4440: l_log_params_tbl(3).param_value := l_get_renew_memberships_rec.future_membership_id;
4441:
4442: /* call transaction history log to record this log. */
4443: Write_log (1,'Before Creating History Log for '|| l_get_renew_memberships_rec.current_membership_id );
4444: PVX_UTILITY_PVT.create_history_log
4445: (
4446: p_arc_history_for_entity_code => 'MEMBERSHIP'
4447: , p_history_for_entity_id => l_get_renew_memberships_rec.current_membership_id
4448: , p_history_category_code => 'ENROLLMENT'
4449: , p_message_code => 'PV_MEMBERSHIP_RENEWED'
4450: , p_comments => null
4451: , p_partner_id => l_get_renew_memberships_rec.partner_id
4452: , p_access_level_flag => 'P'
4453: , p_interaction_level => PVX_Utility_PVT.G_INTERACTION_LEVEL_50
4454: , p_log_params_tbl => l_log_params_tbl
4455: , p_init_msg_list => FND_API.g_false
4456: , p_commit => FND_API.G_FALSE
4457: , x_return_status => x_return_status
4613: );
4614:
4615:
4616:
4617: PVX_UTILITY_PVT.debug_message (L_API_NAME || ' - FUNCMODE: ' || funcmode);
4618: -- RUN mode - Normal Process Execution
4619: IF (funcmode = 'RUN') THEN
4620: resultout := 'COMPLETE:' ||l_event_code ;
4621: RETURN;
4627: resultout := 'COMPLETE:' ;
4628: RETURN;
4629: END IF;
4630:
4631: PVX_UTILITY_PVT.debug_message (L_API_NAME || ' - RESULT: ' || resultout);
4632:
4633: -- write to log
4634: EXCEPTION
4635: WHEN OTHERS THEN
4705:
4706: l_notification_id := wf_engine.context_nid;
4707:
4708: IF (PV_DEBUG_HIGH_ON) THEN
4709: PVX_UTILITY_PVT.debug_message (L_API_NAME || ' - FUNCMODE: ' || funcmode);
4710: END IF;
4711:
4712:
4713:
4806: RETURN;
4807: END IF;
4808: resultout := 'COMPLETE:';
4809: IF (PV_DEBUG_HIGH_ON) THEN
4810: PVX_UTILITY_PVT.debug_message(L_API_NAME || ' - RESULT: ' || resultout);
4811:
4812: END IF;
4813:
4814:
4950: END IF;
4951:
4952:
4953: IF (PV_DEBUG_HIGH_ON) THEN
4954: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
4955: END IF;
4956:
4957: x_return_status := FND_API.G_RET_STS_SUCCESS ;
4958:
4988: END IF;
4989:
4990: */
4991: --validate the lookupcode for target category
4992: l_lookup_exists := PVX_UTILITY_PVT.check_lookup_exists
4993: ( p_lookup_table_name => 'PV_LOOKUPS'
4994: ,p_lookup_type => 'PV_ENTITY_NOTIF_CATEGORY'
4995: ,p_lookup_code => p_target_ctgry
4996: );
5003: RAISE FND_API.G_EXC_ERROR;
5004: END IF;
5005:
5006: --validate the lookupcode for event
5007: l_lookup_exists := PVX_UTILITY_PVT.check_lookup_exists
5008: ( p_lookup_table_name => 'PV_LOOKUPS'
5009: ,p_lookup_type => 'PV_NOTIFICATION_EVENT_TYPE'
5010: ,p_lookup_code => p_notif_event_code
5011: );
5017: RAISE FND_API.G_EXC_ERROR;
5018: END IF;
5019:
5020: --validate the lookupcodfe for entity code
5021: l_lookup_exists := PVX_UTILITY_PVT.check_lookup_exists
5022: ( p_lookup_table_name => 'PV_LOOKUPS'
5023: ,p_lookup_type => 'PV_ENTITY_TYPE'
5024: ,p_lookup_code => p_entity_code
5025: );
5032: END IF;
5033:
5034: --validate the lookup for context code
5035: /**
5036: l_lookup_exists := PVX_UTILITY_PVT.check_lookup_exists
5037: ( p_lookup_table_name => 'PV_LOOKUPS'
5038: ,p_lookup_type => 'PV_ENTITY_TYPE'
5039: ,p_lookup_code => p_context_code
5040: );
5231: l_pt_adhoc_role := 'PV_' || l_itemKey ;
5232: l_role_disp_name :='Primary Users';
5233: -- Debug Message
5234: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
5235: PVX_UTILITY_PVT.debug_message( 'Creating role PT: '|| l_pt_adhoc_role);
5236: END IF;
5237: wf_directory.CreateAdHocRole2
5238: (
5239: role_name => l_pt_adhoc_role
5453: );
5454:
5455: -- set the event meaning when Subsidiary Partner's enrollment has been approved/rejected/terminated by the Vendor
5456: IF p_notif_event_code = 'PG_TERMINATE' THEN
5457: PVX_UTILITY_PVT.get_lookup_meaning
5458: (
5459: p_lookup_type => 'PV_MEMBERSHIP_STATUS'
5460: , p_lookup_code => p_context_code
5461: , x_return_status => x_return_status
5472: END IF;
5473:
5474: IF p_notif_event_code = 'SUBSIDIARY_PTNR_ENROLL' THEN
5475: IF p_context_code IN ( 'APPROVED' , 'REJECTED' ) THEN
5476: PVX_UTILITY_PVT.get_lookup_meaning
5477: (
5478: p_lookup_type => 'PV_ENROLLMENT_REQUEST_STATUS'
5479: , p_lookup_code => p_context_code
5480: , x_return_status => x_return_status
5480: , x_return_status => x_return_status
5481: , x_meaning => l_event_meaning
5482: );
5483: ELSE
5484: PVX_UTILITY_PVT.get_lookup_meaning
5485: (
5486: p_lookup_type => 'PV_NOTIFICATION_EVENT_TYPE'
5487: , p_lookup_code => p_notif_event_code
5488: , x_return_status => x_return_status
5639: p_count => x_msg_count,
5640: p_data => x_msg_data);
5641:
5642: IF (PV_DEBUG_HIGH_ON) THEN
5643: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
5644: END IF;
5645:
5646: IF FND_API.To_Boolean ( p_commit ) THEN
5647: COMMIT WORK;
5772: END IF;
5773:
5774:
5775: IF (PV_DEBUG_HIGH_ON) THEN
5776: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
5777: END IF;
5778:
5779: x_return_status := FND_API.G_RET_STS_SUCCESS ;
5780:
5814: l_pt_adhoc_role := 'PV_' || l_itemKey ;
5815: l_role_disp_name :='Primary Users';
5816: -- Debug Message
5817: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
5818: PVX_UTILITY_PVT.debug_message( 'Creating role PT: '|| l_pt_adhoc_role);
5819: END IF;
5820: wf_directory.CreateAdHocRole2
5821: (
5822: role_name => l_pt_adhoc_role
5859: FETCH c_currency_csr INTO l_currency;
5860: CLOSE c_currency_csr;
5861: l_discount_str:= p_discount_value || ' ' || l_currency ;
5862: ELSE
5863: PVX_UTILITY_PVT.get_lookup_meaning
5864: (
5865: p_lookup_type => 'PV_OFFER_DISCOUNT_TYPE'
5866: , p_lookup_code => p_discount_unit
5867: , x_return_status => x_return_status
6045: p_count => x_msg_count,
6046: p_data => x_msg_data);
6047:
6048: IF (PV_DEBUG_HIGH_ON) THEN
6049: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
6050: END IF;
6051:
6052: IF FND_API.To_Boolean ( p_commit ) THEN
6053: COMMIT WORK;