DBA Data[Home] [Help]

APPS.ARI_SELF_REGISTRATION_PKG dependencies on WF_EVENT

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

1037: | PARAMETERS
1038: |
1039: * ======================================================================*/
1040: ---------------------------------------------------------------------------
1041: Procedure CreatePersonPartyInternal(p_event in out NOCOPY WF_EVENT_T,
1042: p_person_party_id out NOCOPY varchar2)
1043: ---------------------------------------------------------------------------
1044: IS
1045:

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

1279: | PARAMETERS
1280: |
1281: * ======================================================================*/
1282: ---------------------------------------------------------------------------
1283: Procedure CreateOrgContactInternal(p_event in out NOCOPY WF_EVENT_T,
1284: p_person_party_id in varchar2,
1285: p_party_id out NOCOPY number)
1286: ---------------------------------------------------------------------------
1287: IS

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

1434: | PARAMETERS
1435: |
1436: * ======================================================================*/
1437: ---------------------------------------------------------------------------
1438: Procedure CreateContactPointInternal(p_event in out NOCOPY WF_EVENT_T,
1439: p_contact_party_id in varchar2)
1440: ---------------------------------------------------------------------------
1441: IS
1442:

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

1714: | PARAMETERS
1715: |
1716: * ======================================================================*/
1717: --------------------------------------------------------------------------
1718: PROCEDURE CreateCustAcctRoleFor(p_event in out NOCOPY WF_EVENT_T,
1719: p_party_id IN NUMBER,
1720: p_cust_acct_role_id OUT NOCOPY NUMBER)
1721: --------------------------------------------------------------------------
1722: IS

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

2013: | PARAMETERS
2014: |
2015: * ======================================================================*/
2016: ---------------------------------------------------------------------------
2017: PROCEDURE RegisterB2BUser( p_event IN OUT NOCOPY WF_EVENT_T,
2018: p_person_party_id IN OUT NOCOPY VARCHAR2)
2019: ---------------------------------------------------------------------------
2020: IS
2021: l_party_id NUMBER;

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

2064: | PARAMETERS
2065: |
2066: * ======================================================================*/
2067: ---------------------------------------------------------------------------
2068: PROCEDURE RegisterB2CUser( p_event IN OUT NOCOPY WF_EVENT_T,
2069: p_person_party_id IN OUT NOCOPY varchar2 )
2070: ---------------------------------------------------------------------------
2071: IS
2072: l_contact_preference_rec HZ_CONTACT_PREFERENCE_V2PUB.CONTACT_PREFERENCE_REC_TYPE;

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

2159: | PARAMETERS
2160: |
2161: * ======================================================================*/
2162: ---------------------------------------------------------------------------
2163: PROCEDURE RegisterUser( p_event IN OUT NOCOPY WF_EVENT_T,
2164: p_person_party_id IN OUT NOCOPY varchar2 )
2165: ---------------------------------------------------------------------------
2166: IS
2167: l_cust_acct_type VARCHAR2(20);

Line 2214: p_event in out NOCOPY WF_EVENT_T)

2210: |
2211: * ======================================================================*/
2212: ---------------------------------------------------------------------------
2213: FUNCTION AddCustomerAccess(p_subscription_guid in raw,
2214: p_event in out NOCOPY WF_EVENT_T)
2215: RETURN VARCHAR2
2216: ---------------------------------------------------------------------------
2217: IS
2218: l_success VARCHAR2(10);

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

2270: WHEN OTHERS THEN
2271: WF_CORE.CONTEXT('ARI_SELF_REGISTRATION_PKG', 'AddCustomerAccess',
2272: p_event.getEventName( ),p_subscription_guid,
2273: sqlerrm,sqlcode);
2274: WF_EVENT.SetErrorInfo(p_event,'ERROR');
2275: raise;
2276: return 'ERROR';
2277:
2278: END AddCustomerAccess;

Line 2291: p_event in out NOCOPY WF_EVENT_T)

2287: |
2288: * ======================================================================*/
2289: ---------------------------------------------------------------------------
2290: FUNCTION CreatePersonParty(p_subscription_guid in raw,
2291: p_event in out NOCOPY WF_EVENT_T)
2292: RETURN VARCHAR2
2293: ---------------------------------------------------------------------------
2294: IS
2295:

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

2352:
2353: IF l_success <> 'success' THEN
2354: WF_CORE.CONTEXT('ARI_SELF_REGISTRATION_PKG', 'CREATE_PERSON_PARTY',
2355: p_event.getEventName( ),p_subscription_guid,sqlerrm,sqlcode);
2356: WF_EVENT.SetErrorInfo(p_event,'ERROR');
2357: END IF;
2358:
2359: return l_success;
2360:

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

2362: WHEN OTHERS THEN
2363: WF_CORE.CONTEXT('ARI_SELF_REGISTRATION_PKG', 'CREATE_PERSON_PARTY',
2364: p_event.getEventName( ),p_subscription_guid,
2365: sqlerrm,sqlcode);
2366: WF_EVENT.SetErrorInfo(p_event,'ERROR');
2367: raise;
2368: return 'ERROR';
2369:
2370: END CreatePersonParty;

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

2395: l_item_key VARCHAR2(2000);
2396: l_user_name VARCHAR2(100);
2397: BEGIN
2398:
2399: wf_event.addParametertoList('PERSON_PARTY_ID', p_person_party_id, l_parameter_list);
2400: wf_event.addParametertoList('CUSTOMER_ID', p_customer_id, l_parameter_list);
2401: wf_event.addParametertoList('CUSTOMER_SITE_USE_ID', p_cust_site_use_id, l_parameter_list);
2402: wf_event.addParametertoList('REG_SERVICE_TYPE', 'ARI_ADD_CUST_ACCESS', l_parameter_list);
2403: wf_event.addParametertoList('CUST_ACCT_TYPE', p_cust_acct_type, l_parameter_list);

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

2396: l_user_name VARCHAR2(100);
2397: BEGIN
2398:
2399: wf_event.addParametertoList('PERSON_PARTY_ID', p_person_party_id, l_parameter_list);
2400: wf_event.addParametertoList('CUSTOMER_ID', p_customer_id, l_parameter_list);
2401: wf_event.addParametertoList('CUSTOMER_SITE_USE_ID', p_cust_site_use_id, l_parameter_list);
2402: wf_event.addParametertoList('REG_SERVICE_TYPE', 'ARI_ADD_CUST_ACCESS', l_parameter_list);
2403: wf_event.addParametertoList('CUST_ACCT_TYPE', p_cust_acct_type, l_parameter_list);
2404: wf_event.addParametertoList('FIRST_NAME', p_first_name, l_parameter_list);

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

2397: BEGIN
2398:
2399: wf_event.addParametertoList('PERSON_PARTY_ID', p_person_party_id, l_parameter_list);
2400: wf_event.addParametertoList('CUSTOMER_ID', p_customer_id, l_parameter_list);
2401: wf_event.addParametertoList('CUSTOMER_SITE_USE_ID', p_cust_site_use_id, l_parameter_list);
2402: wf_event.addParametertoList('REG_SERVICE_TYPE', 'ARI_ADD_CUST_ACCESS', l_parameter_list);
2403: wf_event.addParametertoList('CUST_ACCT_TYPE', p_cust_acct_type, l_parameter_list);
2404: wf_event.addParametertoList('FIRST_NAME', p_first_name, l_parameter_list);
2405: wf_event.addParametertoList('LAST_NAME', p_last_name, l_parameter_list);

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

2398:
2399: wf_event.addParametertoList('PERSON_PARTY_ID', p_person_party_id, l_parameter_list);
2400: wf_event.addParametertoList('CUSTOMER_ID', p_customer_id, l_parameter_list);
2401: wf_event.addParametertoList('CUSTOMER_SITE_USE_ID', p_cust_site_use_id, l_parameter_list);
2402: wf_event.addParametertoList('REG_SERVICE_TYPE', 'ARI_ADD_CUST_ACCESS', l_parameter_list);
2403: wf_event.addParametertoList('CUST_ACCT_TYPE', p_cust_acct_type, l_parameter_list);
2404: wf_event.addParametertoList('FIRST_NAME', p_first_name, l_parameter_list);
2405: wf_event.addParametertoList('LAST_NAME', p_last_name, l_parameter_list);
2406: wf_event.addParametertoList('MIDDLE_NAME', p_middle_name, l_parameter_list);

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

2399: wf_event.addParametertoList('PERSON_PARTY_ID', p_person_party_id, l_parameter_list);
2400: wf_event.addParametertoList('CUSTOMER_ID', p_customer_id, l_parameter_list);
2401: wf_event.addParametertoList('CUSTOMER_SITE_USE_ID', p_cust_site_use_id, l_parameter_list);
2402: wf_event.addParametertoList('REG_SERVICE_TYPE', 'ARI_ADD_CUST_ACCESS', l_parameter_list);
2403: wf_event.addParametertoList('CUST_ACCT_TYPE', p_cust_acct_type, l_parameter_list);
2404: wf_event.addParametertoList('FIRST_NAME', p_first_name, l_parameter_list);
2405: wf_event.addParametertoList('LAST_NAME', p_last_name, l_parameter_list);
2406: wf_event.addParametertoList('MIDDLE_NAME', p_middle_name, l_parameter_list);
2407: wf_event.addParametertoList('PRE_NAME_ADJUNCT', p_pre_name_adjunct, l_parameter_list);

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

2400: wf_event.addParametertoList('CUSTOMER_ID', p_customer_id, l_parameter_list);
2401: wf_event.addParametertoList('CUSTOMER_SITE_USE_ID', p_cust_site_use_id, l_parameter_list);
2402: wf_event.addParametertoList('REG_SERVICE_TYPE', 'ARI_ADD_CUST_ACCESS', l_parameter_list);
2403: wf_event.addParametertoList('CUST_ACCT_TYPE', p_cust_acct_type, l_parameter_list);
2404: wf_event.addParametertoList('FIRST_NAME', p_first_name, l_parameter_list);
2405: wf_event.addParametertoList('LAST_NAME', p_last_name, l_parameter_list);
2406: wf_event.addParametertoList('MIDDLE_NAME', p_middle_name, l_parameter_list);
2407: wf_event.addParametertoList('PRE_NAME_ADJUNCT', p_pre_name_adjunct, l_parameter_list);
2408: wf_event.addParametertoList('PERSON_SUFFIX', p_person_suffix, l_parameter_list);

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

2401: wf_event.addParametertoList('CUSTOMER_SITE_USE_ID', p_cust_site_use_id, l_parameter_list);
2402: wf_event.addParametertoList('REG_SERVICE_TYPE', 'ARI_ADD_CUST_ACCESS', l_parameter_list);
2403: wf_event.addParametertoList('CUST_ACCT_TYPE', p_cust_acct_type, l_parameter_list);
2404: wf_event.addParametertoList('FIRST_NAME', p_first_name, l_parameter_list);
2405: wf_event.addParametertoList('LAST_NAME', p_last_name, l_parameter_list);
2406: wf_event.addParametertoList('MIDDLE_NAME', p_middle_name, l_parameter_list);
2407: wf_event.addParametertoList('PRE_NAME_ADJUNCT', p_pre_name_adjunct, l_parameter_list);
2408: wf_event.addParametertoList('PERSON_SUFFIX', p_person_suffix, l_parameter_list);
2409: IF p_person_party_id IS NULL THEN

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

2402: wf_event.addParametertoList('REG_SERVICE_TYPE', 'ARI_ADD_CUST_ACCESS', l_parameter_list);
2403: wf_event.addParametertoList('CUST_ACCT_TYPE', p_cust_acct_type, l_parameter_list);
2404: wf_event.addParametertoList('FIRST_NAME', p_first_name, l_parameter_list);
2405: wf_event.addParametertoList('LAST_NAME', p_last_name, l_parameter_list);
2406: wf_event.addParametertoList('MIDDLE_NAME', p_middle_name, l_parameter_list);
2407: wf_event.addParametertoList('PRE_NAME_ADJUNCT', p_pre_name_adjunct, l_parameter_list);
2408: wf_event.addParametertoList('PERSON_SUFFIX', p_person_suffix, l_parameter_list);
2409: IF p_person_party_id IS NULL THEN
2410: SELECT usr.user_name into l_user_name

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

2403: wf_event.addParametertoList('CUST_ACCT_TYPE', p_cust_acct_type, l_parameter_list);
2404: wf_event.addParametertoList('FIRST_NAME', p_first_name, l_parameter_list);
2405: wf_event.addParametertoList('LAST_NAME', p_last_name, l_parameter_list);
2406: wf_event.addParametertoList('MIDDLE_NAME', p_middle_name, l_parameter_list);
2407: wf_event.addParametertoList('PRE_NAME_ADJUNCT', p_pre_name_adjunct, l_parameter_list);
2408: wf_event.addParametertoList('PERSON_SUFFIX', p_person_suffix, l_parameter_list);
2409: IF p_person_party_id IS NULL THEN
2410: SELECT usr.user_name into l_user_name
2411: FROM fnd_user usr

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

2404: wf_event.addParametertoList('FIRST_NAME', p_first_name, l_parameter_list);
2405: wf_event.addParametertoList('LAST_NAME', p_last_name, l_parameter_list);
2406: wf_event.addParametertoList('MIDDLE_NAME', p_middle_name, l_parameter_list);
2407: wf_event.addParametertoList('PRE_NAME_ADJUNCT', p_pre_name_adjunct, l_parameter_list);
2408: wf_event.addParametertoList('PERSON_SUFFIX', p_person_suffix, l_parameter_list);
2409: IF p_person_party_id IS NULL THEN
2410: SELECT usr.user_name into l_user_name
2411: FROM fnd_user usr
2412: WHERE Usr.user_id = fnd_global.user_id;

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

2409: IF p_person_party_id IS NULL THEN
2410: SELECT usr.user_name into l_user_name
2411: FROM fnd_user usr
2412: WHERE Usr.user_id = fnd_global.user_id;
2413: wf_event.addParametertoList('REQUESTED_USERNAME', l_user_name, l_parameter_list);
2414: END IF;
2415: l_event_name := 'oracle.apps.ar.irec.addcustaccess';
2416: SELECT UMX_REG_REQUESTS_S.nextval INTO l_item_key FROM dual;
2417: wf_event.raise(l_event_name,l_item_key,null,l_parameter_list,sysdate);

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

2413: wf_event.addParametertoList('REQUESTED_USERNAME', l_user_name, l_parameter_list);
2414: END IF;
2415: l_event_name := 'oracle.apps.ar.irec.addcustaccess';
2416: SELECT UMX_REG_REQUESTS_S.nextval INTO l_item_key FROM dual;
2417: wf_event.raise(l_event_name,l_item_key,null,l_parameter_list,sysdate);
2418:
2419: END RaiseAddCustAccessEvent;
2420:
2421: /*=======================================================================