APPS.POR_UTIL_PKG dependencies on FND_LOG_MESSAGES

Line 278: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

274: l_progress PLS_INTEGER;
275:
276: -- Logging Infra
277: l_procedure_name CONSTANT VARCHAR2(30) := 'get_cost_center';
278: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
279:
280: BEGIN
281:
282: -- Logging Infra: Setting up runtime level

Line 466: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

462: l_counter INTEGER := 1;
463: l_cannotread BOOLEAN := TRUE;
464: l_options_value VARCHAR2(100) := 'N';
465: l_procedure_name CONSTANT VARCHAR2(30) := 'get_document_number';
466: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
467: l_inc_val NUMBER := 1;
468: BEGIN
469:
470: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 985: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

981: l_is_ame_approval varchar2(30);
982:
983: l_progress VARCHAR2(100);
984: l_procedure_name CONSTANT VARCHAR2(30) := 'update_notif_header_attr';
985: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
986:
987:
988: cursor ame_child_wf (l_wf_itemtype varchar2,l_wf_itemkey varchar2) is
989: select item_type, item_key

Line 2061: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

2057: l_pending_emp_id PO_ACTION_HISTORY.EMPLOYEE_ID%TYPE;
2058:
2059: -- Logging Infra
2060: l_procedure_name CONSTANT VARCHAR2(30) := 'withdraw_req';
2061: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
2062:
2063: CURSOR action_cursor IS
2064: SELECT action_code, employee_id
2065: FROM PO_ACTION_HISTORY

Line 2882: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

2878: ikey varchar2(240);
2879:
2880: -- Logging Infra
2881: l_procedure_name CONSTANT VARCHAR2(30) := 'cancel_workflow';
2882: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
2883:
2884: BEGIN
2885:
2886: -- Logging Infra: Setting up runtime level

Line 2976: l_msg_data FND_LOG_MESSAGES.message_text%TYPE;

2972:
2973: l_progress VARCHAR2(4) := '000';
2974: l_api_name CONSTANT VARCHAR2(100) := 'create_info_template';
2975: l_api_version CONSTANT NUMBER := 1.0;
2976: l_msg_data FND_LOG_MESSAGES.message_text%TYPE;
2977: xDBVersion NUMBER := ICX_POR_EXT_UTL.getDatabaseVersion;
2978: l_commit_size NUMBER := 50;
2979: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
2980:

Line 2979: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

2975: l_api_version CONSTANT NUMBER := 1.0;
2976: l_msg_data FND_LOG_MESSAGES.message_text%TYPE;
2977: xDBVersion NUMBER := ICX_POR_EXT_UTL.getDatabaseVersion;
2978: l_commit_size NUMBER := 50;
2979: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
2980:
2981: counter NUMBER;
2982: l_info_templ_count NUMBER;
2983:

Line 3209: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

3205: -- Parameters : p_req_header_id IN NUMBER : Corresponds to the existing requisition line id
3206:
3207: PROCEDURE update_attachment_to_standard(p_req_header_id in NUMBER) IS
3208: l_progress VARCHAR2(4) := '000';
3209: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
3210: l_api_name CONSTANT VARCHAR2(100) := 'update_attachment_to_standard';
3211:
3212: BEGIN
3213: l_progress := '010';