DBA Data[Home] [Help]

APPS.PO_REQAPPROVAL_INIT1 dependencies on PO_MESSAGE_S

Line 305: po_message_s.sql_error('In Exception of get_diff_in_user_list ()', l_progress, SQLCODE);

301: EXCEPTION
302: WHEN OTHERS THEN
303: x_name_list := NULL;
304: l_progress := 'PO_REQAPPROVAL_INIT1.get_diff_in_user_list : Failed to get the list of users';
305: po_message_s.sql_error('In Exception of get_diff_in_user_list ()', l_progress, SQLCODE);
306: END;
307: /*******************************************************************
308: < Added this function as part of Bug #: 2810150 >
309: PROCEDURE NAME: get_wf_role_for_users

Line 401: po_message_s.sql_error('In Exception of get_wf_role_for_users()', l_progress, SQLCODE);

397: EXCEPTION
398: WHEN OTHERS THEN
399: l_role_name := NULL;
400: l_progress := 'PO_REQAPPROVAL_INIT1.get_wf_role_for_users: Failed to get the list of users';
401: po_message_s.sql_error('In Exception of get_wf_role_for_users()', l_progress, SQLCODE);
402: END get_wf_role_for_users;
403: /**
404: < Added this function as part of Bug #: 2810150 >
405: FUNCTION NAME: get_function_id

Line 535: po_message_s.sql_error('In Exception of get_user_list_with_resp()', l_progress, SQLCODE);

531: EXCEPTION
532: WHEN OTHERS THEN
533: x_new_list := ' null ';
534: l_progress := 'PO_REQAPPROVAL_INIT1.get_user_list_with_resp: Failed to get the list of users';
535: po_message_s.sql_error('In Exception of get_user_list_with_resp()', l_progress, SQLCODE);
536: END get_user_list_with_resp;
537: -------------------------------------------------------------------------------
538: --Start of Comments
539: --Name: start_wf_process

Line 825: po_message_s.sql_error('In Exception of Start_WF_Process()', x_progress, SQLCODE);

821: AND item_key = l_itemkey;
822: EXCEPTION
823: WHEN OTHERS THEN
824: x_progress := 'PO_REQAPPROVAL_INIT1.Start_WF_Process: check process existance';
825: po_message_s.sql_error('In Exception of Start_WF_Process()', x_progress, SQLCODE);
826: raise;
827: END;
828: -- Bug 5218538 START
829: -- Update the XML/EDI flags in the database based on p_xml_flag.

Line 1654: po_message_s.sql_error('In Exception of Start_WF_Process()', x_progress, SQLCODE);

1650: IF (g_po_wf_debug = 'Y') THEN
1651: /* DEBUG */
1652: PO_WF_DEBUG_PKG.insert_debug(itemtype,l_itemkey,x_progress);
1653: END IF;
1654: po_message_s.sql_error('In Exception of Start_WF_Process()', x_progress, SQLCODE);
1655: RAISE;
1656: END Start_WF_Process;
1657: -- SetStartupValues
1658: -- Iinitialize/assigns startup values to workflow attributes.