1: PACKAGE BODY ARI_SELF_REGISTRATION_PKG AS
2: /* $Header: ARISREGB.pls 120.34.12020000.3 2013/03/13 09:20:16 melapaku ship $ */
3:
4:
5: /*=======================================================================+
5: /*=======================================================================+
6: | Global Constants
7: +=======================================================================*/
8:
9: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ARI_SELF_REGISTRATION_PKG';
10: G_CREATED_BY_MODULE CONSTANT VARCHAR2(5) := 'ARI';
11:
12: ------------------------------------------------------------------------
13: -- Procedure Result Codes
2530: RETURN l_success;
2531:
2532: EXCEPTION
2533: WHEN OTHERS THEN
2534: WF_CORE.CONTEXT('ARI_SELF_REGISTRATION_PKG', 'AddCustomerAccess',
2535: p_event.getEventName( ),p_subscription_guid,
2536: sqlerrm,sqlcode);
2537: WF_EVENT.SetErrorInfo(p_event,'ERROR');
2538: raise;
2627: END IF;
2628:
2629: -- To match with UMX patch 10133712
2630: IF upper(l_success) <> 'SUCCESS' THEN
2631: WF_CORE.CONTEXT('ARI_SELF_REGISTRATION_PKG', 'CREATE_PERSON_PARTY',
2632: p_event.getEventName( ),p_subscription_guid,sqlerrm,sqlcode);
2633: WF_EVENT.SetErrorInfo(p_event,'ERROR');
2634: --BUG 9976852 - Should return success even during AFTER_ACT_ACTIVATION context
2635: ELSIF(p_event.getValueForParameter('UMX_CUSTOM_EVENT_CONTEXT') = UMX_PUB.AFTER_ACT_ACTIVATION) then
2643: return upper(l_success);
2644:
2645: EXCEPTION
2646: WHEN OTHERS THEN
2647: WF_CORE.CONTEXT('ARI_SELF_REGISTRATION_PKG', 'CREATE_PERSON_PARTY',
2648: p_event.getEventName( ),p_subscription_guid,
2649: sqlerrm,sqlcode);
2650: WF_EVENT.SetErrorInfo(p_event,'ERROR');
2651: raise;
2989: return 'SUCCESS';
2990:
2991: EXCEPTION
2992: WHEN OTHERS THEN
2993: WF_CORE.CONTEXT('ARI_SELF_REGISTRATION_PKG', 'UpdateRegistrationTable',
2994: p_event.getEventName( ),p_subscription_guid,
2995: sqlerrm,sqlcode);
2996: WF_EVENT.SetErrorInfo(p_event,'ERROR');
2997: return 'ERROR';
3061: return upper('SUCCESS');
3062:
3063: EXCEPTION
3064: WHEN OTHERS THEN
3065: WF_CORE.CONTEXT('ARI_SELF_REGISTRATION_PKG', 'UpdateRejectedStatus',
3066: p_event.getEventName( ),p_subscription_guid,
3067: sqlerrm,sqlcode);
3068: WF_EVENT.SetErrorInfo(p_event,'ERROR');
3069: return 'ERROR';
4190: END IF;
4191: APP_EXCEPTION.RAISE_EXCEPTION;
4192: END UpdateRejectStatus;
4193:
4194: END ARI_SELF_REGISTRATION_PKG;