DBA Data[Home] [Help]

APPS.ARI_SELF_REGISTRATION_PKG dependencies on WF_EVENT

Line 1075: Procedure CreatePersonPartyInternal(p_event in out NOCOPY WF_EVENT_T,

1071: | PARAMETERS
1072: |
1073: * ======================================================================*/
1074: ---------------------------------------------------------------------------
1075: Procedure CreatePersonPartyInternal(p_event in out NOCOPY WF_EVENT_T,
1076: p_person_party_id out NOCOPY varchar2)
1077: ---------------------------------------------------------------------------
1078: IS
1079:

Line 1368: Procedure CreateOrgContactInternal(p_event in out NOCOPY WF_EVENT_T,

1364: | PARAMETERS
1365: |
1366: * ======================================================================*/
1367: ---------------------------------------------------------------------------
1368: Procedure CreateOrgContactInternal(p_event in out NOCOPY WF_EVENT_T,
1369: p_person_party_id in varchar2,
1370: p_party_id out NOCOPY number)
1371: ---------------------------------------------------------------------------
1372: IS

Line 1538: Procedure CreateContactPointInternal(p_event in out NOCOPY WF_EVENT_T,

1534: | PARAMETERS
1535: |
1536: * ======================================================================*/
1537: ---------------------------------------------------------------------------
1538: Procedure CreateContactPointInternal(p_event in out NOCOPY WF_EVENT_T,
1539: p_contact_party_id in varchar2)
1540: ---------------------------------------------------------------------------
1541: IS
1542:

Line 1853: PROCEDURE CreateCustAcctRoleFor(p_event in out NOCOPY WF_EVENT_T,

1849: | PARAMETERS
1850: |
1851: * ======================================================================*/
1852: --------------------------------------------------------------------------
1853: PROCEDURE CreateCustAcctRoleFor(p_event in out NOCOPY WF_EVENT_T,
1854: p_party_id IN NUMBER,
1855: p_cust_acct_role_id OUT NOCOPY NUMBER)
1856: --------------------------------------------------------------------------
1857: IS

Line 2206: PROCEDURE RegisterB2BUser( p_event IN OUT NOCOPY WF_EVENT_T,

2202: | PARAMETERS
2203: |
2204: * ======================================================================*/
2205: ---------------------------------------------------------------------------
2206: PROCEDURE RegisterB2BUser( p_event IN OUT NOCOPY WF_EVENT_T,
2207: p_person_party_id IN OUT NOCOPY VARCHAR2)
2208: ---------------------------------------------------------------------------
2209: IS
2210: l_party_id NUMBER;

Line 2257: PROCEDURE RegisterB2CUser( p_event IN OUT NOCOPY WF_EVENT_T,

2253: | PARAMETERS
2254: |
2255: * ======================================================================*/
2256: ---------------------------------------------------------------------------
2257: PROCEDURE RegisterB2CUser( p_event IN OUT NOCOPY WF_EVENT_T,
2258: p_person_party_id IN OUT NOCOPY varchar2 )
2259: ---------------------------------------------------------------------------
2260: IS
2261: l_contact_preference_rec HZ_CONTACT_PREFERENCE_V2PUB.CONTACT_PREFERENCE_REC_TYPE;

Line 2352: PROCEDURE RegisterUser( p_event IN OUT NOCOPY WF_EVENT_T,

2348: | PARAMETERS
2349: |
2350: * ======================================================================*/
2351: ---------------------------------------------------------------------------
2352: PROCEDURE RegisterUser( p_event IN OUT NOCOPY WF_EVENT_T,
2353: p_person_party_id IN OUT NOCOPY varchar2 )
2354: ---------------------------------------------------------------------------
2355: IS
2356: l_cust_acct_type VARCHAR2(20);

Line 2462: p_event in out NOCOPY WF_EVENT_T)

2458: |
2459: * ======================================================================*/
2460: ---------------------------------------------------------------------------
2461: FUNCTION AddCustomerAccess(p_subscription_guid in raw,
2462: p_event in out NOCOPY WF_EVENT_T)
2463: RETURN VARCHAR2
2464: ---------------------------------------------------------------------------
2465: IS
2466: l_success VARCHAR2(10);

Line 2537: WF_EVENT.SetErrorInfo(p_event,'ERROR');

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;
2539: return 'ERROR';
2540:
2541: END AddCustomerAccess;

Line 2554: p_event in out NOCOPY WF_EVENT_T)

2550: |
2551: * ======================================================================*/
2552: ---------------------------------------------------------------------------
2553: FUNCTION CreatePersonParty(p_subscription_guid in raw,
2554: p_event in out NOCOPY WF_EVENT_T)
2555: RETURN VARCHAR2
2556: ---------------------------------------------------------------------------
2557: IS
2558:

Line 2633: WF_EVENT.SetErrorInfo(p_event,'ERROR');

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
2636: l_success := 'SUCCESS';
2637: END IF;

Line 2650: WF_EVENT.SetErrorInfo(p_event,'ERROR');

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;
2652: return 'ERROR';
2653:
2654: END CreatePersonParty;

Line 2690: l_event wf_event_t;

2686: l_user_name VARCHAR2(100);
2687: l_debug_info VARCHAR2(300);
2688: l_event_key VARCHAR2(2000);
2689: l_approval_profile VARCHAR2(100);
2690: l_event wf_event_t;
2691:
2692: BEGIN
2693:
2694: wf_event.addParametertoList('PERSON_PARTY_ID', p_person_party_id, l_parameter_list);

Line 2694: wf_event.addParametertoList('PERSON_PARTY_ID', p_person_party_id, l_parameter_list);

2690: l_event wf_event_t;
2691:
2692: BEGIN
2693:
2694: wf_event.addParametertoList('PERSON_PARTY_ID', p_person_party_id, l_parameter_list);
2695: wf_event.addParametertoList('CUSTOMER_ID', p_customer_id, l_parameter_list);
2696: wf_event.addParametertoList('CUSTOMER_SITE_USE_ID', p_cust_site_use_id, l_parameter_list);
2697: wf_event.addParametertoList('REG_SERVICE_TYPE', 'ARI_ADD_CUST_ACCESS', l_parameter_list);
2698: wf_event.addParametertoList('CUST_ACCT_TYPE', p_cust_acct_type, l_parameter_list);

Line 2695: wf_event.addParametertoList('CUSTOMER_ID', p_customer_id, l_parameter_list);

2691:
2692: BEGIN
2693:
2694: wf_event.addParametertoList('PERSON_PARTY_ID', p_person_party_id, l_parameter_list);
2695: wf_event.addParametertoList('CUSTOMER_ID', p_customer_id, l_parameter_list);
2696: wf_event.addParametertoList('CUSTOMER_SITE_USE_ID', p_cust_site_use_id, l_parameter_list);
2697: wf_event.addParametertoList('REG_SERVICE_TYPE', 'ARI_ADD_CUST_ACCESS', l_parameter_list);
2698: wf_event.addParametertoList('CUST_ACCT_TYPE', p_cust_acct_type, l_parameter_list);
2699: wf_event.addParametertoList('FIRST_NAME', p_first_name, l_parameter_list);

Line 2696: wf_event.addParametertoList('CUSTOMER_SITE_USE_ID', p_cust_site_use_id, l_parameter_list);

2692: BEGIN
2693:
2694: wf_event.addParametertoList('PERSON_PARTY_ID', p_person_party_id, l_parameter_list);
2695: wf_event.addParametertoList('CUSTOMER_ID', p_customer_id, l_parameter_list);
2696: wf_event.addParametertoList('CUSTOMER_SITE_USE_ID', p_cust_site_use_id, l_parameter_list);
2697: wf_event.addParametertoList('REG_SERVICE_TYPE', 'ARI_ADD_CUST_ACCESS', l_parameter_list);
2698: wf_event.addParametertoList('CUST_ACCT_TYPE', p_cust_acct_type, l_parameter_list);
2699: wf_event.addParametertoList('FIRST_NAME', p_first_name, l_parameter_list);
2700: wf_event.addParametertoList('LAST_NAME', p_last_name, l_parameter_list);

Line 2697: wf_event.addParametertoList('REG_SERVICE_TYPE', 'ARI_ADD_CUST_ACCESS', l_parameter_list);

2693:
2694: wf_event.addParametertoList('PERSON_PARTY_ID', p_person_party_id, l_parameter_list);
2695: wf_event.addParametertoList('CUSTOMER_ID', p_customer_id, l_parameter_list);
2696: wf_event.addParametertoList('CUSTOMER_SITE_USE_ID', p_cust_site_use_id, l_parameter_list);
2697: wf_event.addParametertoList('REG_SERVICE_TYPE', 'ARI_ADD_CUST_ACCESS', l_parameter_list);
2698: wf_event.addParametertoList('CUST_ACCT_TYPE', p_cust_acct_type, l_parameter_list);
2699: wf_event.addParametertoList('FIRST_NAME', p_first_name, l_parameter_list);
2700: wf_event.addParametertoList('LAST_NAME', p_last_name, l_parameter_list);
2701: wf_event.addParametertoList('MIDDLE_NAME', p_middle_name, l_parameter_list);

Line 2698: wf_event.addParametertoList('CUST_ACCT_TYPE', p_cust_acct_type, l_parameter_list);

2694: wf_event.addParametertoList('PERSON_PARTY_ID', p_person_party_id, l_parameter_list);
2695: wf_event.addParametertoList('CUSTOMER_ID', p_customer_id, l_parameter_list);
2696: wf_event.addParametertoList('CUSTOMER_SITE_USE_ID', p_cust_site_use_id, l_parameter_list);
2697: wf_event.addParametertoList('REG_SERVICE_TYPE', 'ARI_ADD_CUST_ACCESS', l_parameter_list);
2698: wf_event.addParametertoList('CUST_ACCT_TYPE', p_cust_acct_type, l_parameter_list);
2699: wf_event.addParametertoList('FIRST_NAME', p_first_name, l_parameter_list);
2700: wf_event.addParametertoList('LAST_NAME', p_last_name, l_parameter_list);
2701: wf_event.addParametertoList('MIDDLE_NAME', p_middle_name, l_parameter_list);
2702: wf_event.addParametertoList('PRE_NAME_ADJUNCT', p_pre_name_adjunct, l_parameter_list);

Line 2699: wf_event.addParametertoList('FIRST_NAME', p_first_name, l_parameter_list);

2695: wf_event.addParametertoList('CUSTOMER_ID', p_customer_id, l_parameter_list);
2696: wf_event.addParametertoList('CUSTOMER_SITE_USE_ID', p_cust_site_use_id, l_parameter_list);
2697: wf_event.addParametertoList('REG_SERVICE_TYPE', 'ARI_ADD_CUST_ACCESS', l_parameter_list);
2698: wf_event.addParametertoList('CUST_ACCT_TYPE', p_cust_acct_type, l_parameter_list);
2699: wf_event.addParametertoList('FIRST_NAME', p_first_name, l_parameter_list);
2700: wf_event.addParametertoList('LAST_NAME', p_last_name, l_parameter_list);
2701: wf_event.addParametertoList('MIDDLE_NAME', p_middle_name, l_parameter_list);
2702: wf_event.addParametertoList('PRE_NAME_ADJUNCT', p_pre_name_adjunct, l_parameter_list);
2703: wf_event.addParametertoList('PERSON_SUFFIX', p_person_suffix, l_parameter_list);

Line 2700: wf_event.addParametertoList('LAST_NAME', p_last_name, l_parameter_list);

2696: wf_event.addParametertoList('CUSTOMER_SITE_USE_ID', p_cust_site_use_id, l_parameter_list);
2697: wf_event.addParametertoList('REG_SERVICE_TYPE', 'ARI_ADD_CUST_ACCESS', l_parameter_list);
2698: wf_event.addParametertoList('CUST_ACCT_TYPE', p_cust_acct_type, l_parameter_list);
2699: wf_event.addParametertoList('FIRST_NAME', p_first_name, l_parameter_list);
2700: wf_event.addParametertoList('LAST_NAME', p_last_name, l_parameter_list);
2701: wf_event.addParametertoList('MIDDLE_NAME', p_middle_name, l_parameter_list);
2702: wf_event.addParametertoList('PRE_NAME_ADJUNCT', p_pre_name_adjunct, l_parameter_list);
2703: wf_event.addParametertoList('PERSON_SUFFIX', p_person_suffix, l_parameter_list);
2704: wf_event.addParametertoList('ACCOUNT_NUMBER', p_req_acc_no, l_parameter_list);

Line 2701: wf_event.addParametertoList('MIDDLE_NAME', p_middle_name, l_parameter_list);

2697: wf_event.addParametertoList('REG_SERVICE_TYPE', 'ARI_ADD_CUST_ACCESS', l_parameter_list);
2698: wf_event.addParametertoList('CUST_ACCT_TYPE', p_cust_acct_type, l_parameter_list);
2699: wf_event.addParametertoList('FIRST_NAME', p_first_name, l_parameter_list);
2700: wf_event.addParametertoList('LAST_NAME', p_last_name, l_parameter_list);
2701: wf_event.addParametertoList('MIDDLE_NAME', p_middle_name, l_parameter_list);
2702: wf_event.addParametertoList('PRE_NAME_ADJUNCT', p_pre_name_adjunct, l_parameter_list);
2703: wf_event.addParametertoList('PERSON_SUFFIX', p_person_suffix, l_parameter_list);
2704: wf_event.addParametertoList('ACCOUNT_NUMBER', p_req_acc_no, l_parameter_list);
2705: wf_event.addParametertoList('CUSTOMER_LOCATION', p_req_location, l_parameter_list);

Line 2702: wf_event.addParametertoList('PRE_NAME_ADJUNCT', p_pre_name_adjunct, l_parameter_list);

2698: wf_event.addParametertoList('CUST_ACCT_TYPE', p_cust_acct_type, l_parameter_list);
2699: wf_event.addParametertoList('FIRST_NAME', p_first_name, l_parameter_list);
2700: wf_event.addParametertoList('LAST_NAME', p_last_name, l_parameter_list);
2701: wf_event.addParametertoList('MIDDLE_NAME', p_middle_name, l_parameter_list);
2702: wf_event.addParametertoList('PRE_NAME_ADJUNCT', p_pre_name_adjunct, l_parameter_list);
2703: wf_event.addParametertoList('PERSON_SUFFIX', p_person_suffix, l_parameter_list);
2704: wf_event.addParametertoList('ACCOUNT_NUMBER', p_req_acc_no, l_parameter_list);
2705: wf_event.addParametertoList('CUSTOMER_LOCATION', p_req_location, l_parameter_list);
2706: wf_event.addParametertoList('CUSTOMER_NAME', p_req_cust_name, l_parameter_list);

Line 2703: wf_event.addParametertoList('PERSON_SUFFIX', p_person_suffix, l_parameter_list);

2699: wf_event.addParametertoList('FIRST_NAME', p_first_name, l_parameter_list);
2700: wf_event.addParametertoList('LAST_NAME', p_last_name, l_parameter_list);
2701: wf_event.addParametertoList('MIDDLE_NAME', p_middle_name, l_parameter_list);
2702: wf_event.addParametertoList('PRE_NAME_ADJUNCT', p_pre_name_adjunct, l_parameter_list);
2703: wf_event.addParametertoList('PERSON_SUFFIX', p_person_suffix, l_parameter_list);
2704: wf_event.addParametertoList('ACCOUNT_NUMBER', p_req_acc_no, l_parameter_list);
2705: wf_event.addParametertoList('CUSTOMER_LOCATION', p_req_location, l_parameter_list);
2706: wf_event.addParametertoList('CUSTOMER_NAME', p_req_cust_name, l_parameter_list);
2707: wf_event.addParametertoList('REGISTRATION_ID',p_registration_id , l_parameter_list);

Line 2704: wf_event.addParametertoList('ACCOUNT_NUMBER', p_req_acc_no, l_parameter_list);

2700: wf_event.addParametertoList('LAST_NAME', p_last_name, l_parameter_list);
2701: wf_event.addParametertoList('MIDDLE_NAME', p_middle_name, l_parameter_list);
2702: wf_event.addParametertoList('PRE_NAME_ADJUNCT', p_pre_name_adjunct, l_parameter_list);
2703: wf_event.addParametertoList('PERSON_SUFFIX', p_person_suffix, l_parameter_list);
2704: wf_event.addParametertoList('ACCOUNT_NUMBER', p_req_acc_no, l_parameter_list);
2705: wf_event.addParametertoList('CUSTOMER_LOCATION', p_req_location, l_parameter_list);
2706: wf_event.addParametertoList('CUSTOMER_NAME', p_req_cust_name, l_parameter_list);
2707: wf_event.addParametertoList('REGISTRATION_ID',p_registration_id , l_parameter_list);
2708: wf_event.addParametertoList('RESPONSIBILITY_ID',p_responsibility_id, l_parameter_list);

Line 2705: wf_event.addParametertoList('CUSTOMER_LOCATION', p_req_location, l_parameter_list);

2701: wf_event.addParametertoList('MIDDLE_NAME', p_middle_name, l_parameter_list);
2702: wf_event.addParametertoList('PRE_NAME_ADJUNCT', p_pre_name_adjunct, l_parameter_list);
2703: wf_event.addParametertoList('PERSON_SUFFIX', p_person_suffix, l_parameter_list);
2704: wf_event.addParametertoList('ACCOUNT_NUMBER', p_req_acc_no, l_parameter_list);
2705: wf_event.addParametertoList('CUSTOMER_LOCATION', p_req_location, l_parameter_list);
2706: wf_event.addParametertoList('CUSTOMER_NAME', p_req_cust_name, l_parameter_list);
2707: wf_event.addParametertoList('REGISTRATION_ID',p_registration_id , l_parameter_list);
2708: wf_event.addParametertoList('RESPONSIBILITY_ID',p_responsibility_id, l_parameter_list);
2709: IF p_person_party_id IS NULL THEN

Line 2706: wf_event.addParametertoList('CUSTOMER_NAME', p_req_cust_name, l_parameter_list);

2702: wf_event.addParametertoList('PRE_NAME_ADJUNCT', p_pre_name_adjunct, l_parameter_list);
2703: wf_event.addParametertoList('PERSON_SUFFIX', p_person_suffix, l_parameter_list);
2704: wf_event.addParametertoList('ACCOUNT_NUMBER', p_req_acc_no, l_parameter_list);
2705: wf_event.addParametertoList('CUSTOMER_LOCATION', p_req_location, l_parameter_list);
2706: wf_event.addParametertoList('CUSTOMER_NAME', p_req_cust_name, l_parameter_list);
2707: wf_event.addParametertoList('REGISTRATION_ID',p_registration_id , l_parameter_list);
2708: wf_event.addParametertoList('RESPONSIBILITY_ID',p_responsibility_id, l_parameter_list);
2709: IF p_person_party_id IS NULL THEN
2710: SELECT usr.user_name into l_user_name

Line 2707: wf_event.addParametertoList('REGISTRATION_ID',p_registration_id , l_parameter_list);

2703: wf_event.addParametertoList('PERSON_SUFFIX', p_person_suffix, l_parameter_list);
2704: wf_event.addParametertoList('ACCOUNT_NUMBER', p_req_acc_no, l_parameter_list);
2705: wf_event.addParametertoList('CUSTOMER_LOCATION', p_req_location, l_parameter_list);
2706: wf_event.addParametertoList('CUSTOMER_NAME', p_req_cust_name, l_parameter_list);
2707: wf_event.addParametertoList('REGISTRATION_ID',p_registration_id , l_parameter_list);
2708: wf_event.addParametertoList('RESPONSIBILITY_ID',p_responsibility_id, l_parameter_list);
2709: IF p_person_party_id IS NULL THEN
2710: SELECT usr.user_name into l_user_name
2711: FROM fnd_user usr

Line 2708: wf_event.addParametertoList('RESPONSIBILITY_ID',p_responsibility_id, l_parameter_list);

2704: wf_event.addParametertoList('ACCOUNT_NUMBER', p_req_acc_no, l_parameter_list);
2705: wf_event.addParametertoList('CUSTOMER_LOCATION', p_req_location, l_parameter_list);
2706: wf_event.addParametertoList('CUSTOMER_NAME', p_req_cust_name, l_parameter_list);
2707: wf_event.addParametertoList('REGISTRATION_ID',p_registration_id , l_parameter_list);
2708: wf_event.addParametertoList('RESPONSIBILITY_ID',p_responsibility_id, l_parameter_list);
2709: IF p_person_party_id IS NULL THEN
2710: SELECT usr.user_name into l_user_name
2711: FROM fnd_user usr
2712: WHERE Usr.user_id = fnd_global.user_id;

Line 2713: wf_event.addParametertoList('REQUESTED_USERNAME', l_user_name, l_parameter_list);

2709: IF p_person_party_id IS NULL THEN
2710: SELECT usr.user_name into l_user_name
2711: FROM fnd_user usr
2712: WHERE Usr.user_id = fnd_global.user_id;
2713: wf_event.addParametertoList('REQUESTED_USERNAME', l_user_name, l_parameter_list);
2714:
2715: ELSE
2716: SELECT usr.user_name into l_user_name
2717: FROM fnd_user usr

Line 2720: wf_event_t.initialize(l_event);

2716: SELECT usr.user_name into l_user_name
2717: FROM fnd_user usr
2718: WHERE Usr.person_party_id = p_person_party_id;
2719: END IF;
2720: wf_event_t.initialize(l_event);
2721: l_event.setParameterList(l_parameter_list);
2722:
2723: FND_PROFILE.Get('OIR_APPROVAL_FOR_ACCOUNT_ACCESS', l_approval_profile);
2724: l_event_name := 'oracle.apps.ar.irec.addcustaccess';

Line 2871: wf_event.raise(l_event_name,l_item_key,null,l_parameter_list,sysdate);

2867: WF_ENGINE.STARTPROCESS('ARIADDAC',
2868: l_item_key);
2869:
2870: ELSE
2871: wf_event.raise(l_event_name,l_item_key,null,l_parameter_list,sysdate);
2872: END IF;
2873:
2874: END RaiseAddCustAccessEvent;
2875:

Line 2957: p_event in out NOCOPY WF_EVENT_T)

2953: |
2954: * ======================================================================*/
2955: ---------------------------------------------------------------------------
2956: FUNCTION UpdateRegistrationTable(p_subscription_guid in raw,
2957: p_event in out NOCOPY WF_EVENT_T)
2958: RETURN VARCHAR2
2959: ---------------------------------------------------------------------------
2960: IS
2961: l_registration_id VARCHAR2(500);

Line 2996: WF_EVENT.SetErrorInfo(p_event,'ERROR');

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';
2998:
2999: END UpdateRegistrationTable;
3000: /*=======================================================================

Line 3011: p_event in out NOCOPY WF_EVENT_T)

3007: |
3008: * ======================================================================*/
3009: --------------------------------------------------------------------------
3010: FUNCTION UpdateRejectedStatus(p_subscription_guid in raw,
3011: p_event in out NOCOPY WF_EVENT_T)
3012: RETURN VARCHAR2
3013: --------------------------------------------------------------------------
3014: IS
3015: l_item_key VARCHAR2(500);

Line 3068: WF_EVENT.SetErrorInfo(p_event,'ERROR');

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';
3070: END UpdateRejectedStatus;
3071:
3072: /*=======================================================================