APPS.ZPB_DC_OBJECTS_PVT dependencies on ZPB_LOG

Line 2467: ZPB_LOG.WRITE(G_PKG_NAME||'.'||l_api_name, 'BEGIN');

2463: FROM zpb_dc_distribution_list_items
2464: WHERE distribution_list_id = p_dist_list_id;
2465:
2466: BEGIN
2467: ZPB_LOG.WRITE(G_PKG_NAME||'.'||l_api_name, 'BEGIN');
2468: ZPB_LOG.WRITE(G_PKG_NAME||'.'||l_api_name, 'IN Parameter:'
2469: || ' p_init_msg_list=' || p_init_msg_list
2470: || ' p_commit=' || p_commit
2471: || ' p_task_id=' || p_task_id

Line 2468: ZPB_LOG.WRITE(G_PKG_NAME||'.'||l_api_name, 'IN Parameter:'

2464: WHERE distribution_list_id = p_dist_list_id;
2465:
2466: BEGIN
2467: ZPB_LOG.WRITE(G_PKG_NAME||'.'||l_api_name, 'BEGIN');
2468: ZPB_LOG.WRITE(G_PKG_NAME||'.'||l_api_name, 'IN Parameter:'
2469: || ' p_init_msg_list=' || p_init_msg_list
2470: || ' p_commit=' || p_commit
2471: || ' p_task_id=' || p_task_id
2472: || ' p_template_id=' || p_template_id

Line 2490: ZPB_LOG.WRITE(G_PKG_NAME||'.'||l_api_name, 'Auto Distribution');

2486: -- API Body
2487:
2488: IF (p_task_id is not null) THEN -- Auto distribution
2489:
2490: ZPB_LOG.WRITE(G_PKG_NAME||'.'||l_api_name, 'Auto Distribution');
2491: -- Set the resp key
2492: l_resp_key := 'ZPB_CONTROLLER_RESP';
2493:
2494: -- Get the recipient type

Line 2588: ZPB_LOG.WRITE(G_PKG_NAME||'.'||l_api_name, 'Manual Distribution');

2584: END IF; --recipients types
2585:
2586: ELSE -- Manual distribution
2587:
2588: ZPB_LOG.WRITE(G_PKG_NAME||'.'||l_api_name, 'Manual Distribution');
2589:
2590: -- Populate resp key based on object type and object id/user id
2591: SELECT object_type, object_id, object_user_id
2592: INTO l_object_type, l_object_id, l_object_user_id

Line 2605: ZPB_LOG.WRITE(G_PKG_NAME||'.'||l_api_name, ' l_rolename='||l_rolename);

2601:
2602: -- Create the role
2603: l_charDate := to_char(sysdate, 'J-SSSSS');
2604: l_rolename := 'ZPB_DC_MAN'|| to_char(p_dist_list_id) || '-' || l_charDate;
2605: ZPB_LOG.WRITE(G_PKG_NAME||'.'||l_api_name, ' l_rolename='||l_rolename);
2606:
2607: zpb_wf_ntf.SetRole(l_rolename, l_exp_days);
2608:
2609: l_role_has_users := 'N';

Line 2613: ZPB_LOG.WRITE(G_PKG_NAME||'.'||l_api_name, 'SPECIFIC_USERS');

2609: l_role_has_users := 'N';
2610:
2611: IF (p_recipient_type ='SPECIFIC_USERS') THEN
2612:
2613: ZPB_LOG.WRITE(G_PKG_NAME||'.'||l_api_name, 'SPECIFIC_USERS');
2614:
2615: OPEN dist_list_csr;
2616: LOOP
2617: FETCH dist_list_csr INTO l_user;

Line 2626: ZPB_LOG.WRITE(G_PKG_NAME||'.'||l_api_name, 'ALL DATA OWNERS');

2622: CLOSE dist_list_csr;
2623:
2624: ELSE -- Other than specific users -manual
2625:
2626: ZPB_LOG.WRITE(G_PKG_NAME||'.'||l_api_name, 'ALL DATA OWNERS');
2627:
2628: -- Get the clob of user ids
2629: get_user_id_clob(
2630: p_api_version => p_api_version,

Line 2699: ZPB_LOG.WRITE(G_PKG_NAME||'.'||l_api_name, 'END. Out Parameters:'

2695: ELSE
2696: x_resultout := 'COMPLETE:N';
2697: END IF;
2698:
2699: ZPB_LOG.WRITE(G_PKG_NAME||'.'||l_api_name, 'END. Out Parameters:'
2700: || ' x_resultout='||x_resultout
2701: || ' x_role_name='||x_role_name);
2702:
2703: EXCEPTION

Line 2705: ZPB_LOG.WRITE(G_PKG_NAME||'.'||l_api_name, 'EXCEPTION');

2701: || ' x_role_name='||x_role_name);
2702:
2703: EXCEPTION
2704: WHEN OTHERS THEN
2705: ZPB_LOG.WRITE(G_PKG_NAME||'.'||l_api_name, 'EXCEPTION');
2706: raise;
2707:
2708: END Set_Ws_Recipient;
2709: