2312: --
2313: -- Paramaeters :
2314: -- IN :
2315: -- p_subscription_guid IN raw
2316: -- p_event IN out NOCOPY wf_event_t
2317: -- OUT :
2318: --
2319: -- Version :
2320: -- Initial version 1.0
2325: --
2326: -- End of Comments
2327: FUNCTION organization_update_post
2328: ( p_subscription_guid in raw,
2329: p_event in out NOCOPY wf_event_t)
2330: RETURN VARCHAR2
2331: IS
2332: -- Declaration of local variables
2333: l_party_id NUMBER;
2377:
2378: EXCEPTION
2379: WHEN EXC THEN
2380: WF_CORE.CONTEXT('PV_TAP_BES_PKG', 'Organization_Update_Post', p_event.getEventName(), p_subscription_guid);
2381: WF_EVENT.setErrorInfo(p_event, 'ERROR');
2382: RETURN 'ERROR';
2383: WHEN OTHERS THEN
2384: WF_CORE.CONTEXT('PV_TAP_BES_PKG', 'Organization_Update_Post', p_event.getEventName(), p_subscription_guid);
2385: WF_EVENT.setErrorInfo(p_event, 'ERROR');
2381: WF_EVENT.setErrorInfo(p_event, 'ERROR');
2382: RETURN 'ERROR';
2383: WHEN OTHERS THEN
2384: WF_CORE.CONTEXT('PV_TAP_BES_PKG', 'Organization_Update_Post', p_event.getEventName(), p_subscription_guid);
2385: WF_EVENT.setErrorInfo(p_event, 'ERROR');
2386: RETURN 'ERROR';
2387: END Organization_Update_Post;
2388:
2389:
2399: --
2400: -- Paramaeters :
2401: -- IN :
2402: -- p_subscription_guid IN raw
2403: -- p_event IN out NOCOPY wf_event_t
2404: -- OUT :
2405: --
2406: -- Version :
2407: -- Initial version 1.0
2412: --
2413: -- End of Comments
2414: FUNCTION partysite_update_post
2415: ( p_subscription_guid in raw,
2416: p_event in out NOCOPY wf_event_t)
2417: RETURN VARCHAR2
2418: IS
2419:
2420: -- Declaration of local variables
2457:
2458: EXCEPTION
2459: WHEN EXC THEN
2460: WF_CORE.CONTEXT('PV_TAP_BES_PKG', 'partysite_Update_Post', p_event.getEventName(), p_subscription_guid);
2461: WF_EVENT.setErrorInfo(p_event, 'ERROR');
2462: RETURN 'ERROR';
2463: WHEN OTHERS THEN
2464: WF_CORE.CONTEXT('PV_TAP_BES_PKG', 'partysite_Update_Post', p_event.getEventName(), p_subscription_guid);
2465: WF_EVENT.setErrorInfo(p_event, 'ERROR');
2461: WF_EVENT.setErrorInfo(p_event, 'ERROR');
2462: RETURN 'ERROR';
2463: WHEN OTHERS THEN
2464: WF_CORE.CONTEXT('PV_TAP_BES_PKG', 'partysite_Update_Post', p_event.getEventName(), p_subscription_guid);
2465: WF_EVENT.setErrorInfo(p_event, 'ERROR');
2466: RETURN 'ERROR';
2467: END partysite_Update_Post;
2468:
2469: -- Start of Comments
2478: --
2479: -- Paramaeters :
2480: -- IN :
2481: -- p_subscription_guid IN raw
2482: -- p_event IN out NOCOPY wf_event_t
2483: -- OUT :
2484: --
2485: -- Version :
2486: -- Initial version 1.0
2491: --
2492: -- End of Comments
2493: FUNCTION location_update_post
2494: ( p_subscription_guid in raw,
2495: p_event in out NOCOPY wf_event_t)
2496: RETURN VARCHAR2
2497: IS
2498:
2499:
2535:
2536: EXCEPTION
2537: WHEN EXC THEN
2538: WF_CORE.CONTEXT('PV_TAP_BES_PKG', 'location_Update_Post', p_event.getEventName(), p_subscription_guid);
2539: WF_EVENT.setErrorInfo(p_event, 'ERROR');
2540: RETURN 'ERROR';
2541: WHEN OTHERS THEN
2542: WF_CORE.CONTEXT('PV_TAP_BES_PKG', 'location_Update_Post', p_event.getEventName(), p_subscription_guid);
2543: WF_EVENT.setErrorInfo(p_event, 'ERROR');
2539: WF_EVENT.setErrorInfo(p_event, 'ERROR');
2540: RETURN 'ERROR';
2541: WHEN OTHERS THEN
2542: WF_CORE.CONTEXT('PV_TAP_BES_PKG', 'location_Update_Post', p_event.getEventName(), p_subscription_guid);
2543: WF_EVENT.setErrorInfo(p_event, 'ERROR');
2544: RETURN 'ERROR';
2545: END location_Update_Post;
2546:
2547: --
2555: --
2556: -- Paramaeters :
2557: -- IN :
2558: -- p_subscription_guid IN raw
2559: -- p_event IN out NOCOPY wf_event_t
2560: -- OUT :
2561: --
2562: -- Version :
2563: -- Initial version 1.0
2568: --
2569: -- End of Comments
2570: FUNCTION contactpoint_update_post
2571: ( p_subscription_guid in raw,
2572: p_event in out NOCOPY wf_event_t)
2573: RETURN VARCHAR2
2574: IS
2575:
2576: l_contact_point_id NUMBER;
2602:
2603: EXCEPTION
2604: WHEN EXC THEN
2605: WF_CORE.CONTEXT('PV_TAP_BES_PKG', 'contactpoint_Update_Post', p_event.getEventName(), p_subscription_guid);
2606: WF_EVENT.setErrorInfo(p_event, 'ERROR');
2607: RETURN 'ERROR';
2608: WHEN OTHERS THEN
2609: WF_CORE.CONTEXT('PV_TAP_BES_PKG', 'contactpoint_Update_Post', p_event.getEventName(), p_subscription_guid);
2610: WF_EVENT.setErrorInfo(p_event, 'ERROR');
2606: WF_EVENT.setErrorInfo(p_event, 'ERROR');
2607: RETURN 'ERROR';
2608: WHEN OTHERS THEN
2609: WF_CORE.CONTEXT('PV_TAP_BES_PKG', 'contactpoint_Update_Post', p_event.getEventName(), p_subscription_guid);
2610: WF_EVENT.setErrorInfo(p_event, 'ERROR');
2611: RETURN 'ERROR';
2612: END contactpoint_Update_Post;
2613:
2614: END PV_TAP_BES_PKG;