APPS.POR_UTIL_PKG dependencies on FND_LOG_MESSAGES

Line 288: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

284: l_progress PLS_INTEGER;
285:
286: -- Logging Infra
287: l_procedure_name CONSTANT VARCHAR2(30) := 'get_cost_center';
288: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
289:
290: BEGIN
291:
292: -- Logging Infra: Setting up runtime level

Line 498: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

494: l_counter INTEGER := 1;
495: l_cannotread BOOLEAN := TRUE;
496: l_options_value VARCHAR2(100) := 'N';
497: l_procedure_name CONSTANT VARCHAR2(30) := 'get_document_number';
498: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
499: l_inc_val NUMBER := 1;
500: BEGIN
501:
502: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 1012: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

1008: l_is_ame_approval varchar2(30);
1009:
1010: l_progress VARCHAR2(100);
1011: l_procedure_name CONSTANT VARCHAR2(30) := 'update_notif_header_attr';
1012: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
1013:
1014:
1015: cursor ame_child_wf (l_wf_itemtype varchar2,l_wf_itemkey varchar2) is
1016: select item_type, item_key

Line 2393: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

2389: l_pending_emp_id PO_ACTION_HISTORY.EMPLOYEE_ID%TYPE;
2390:
2391: -- Logging Infra
2392: l_procedure_name CONSTANT VARCHAR2(30) := 'withdraw_req';
2393: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
2394:
2395: CURSOR action_cursor IS
2396: SELECT action_code, employee_id
2397: FROM PO_ACTION_HISTORY

Line 3251: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

3247: ikey varchar2(240);
3248:
3249: -- Logging Infra
3250: l_procedure_name CONSTANT VARCHAR2(30) := 'cancel_workflow';
3251: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
3252:
3253: BEGIN
3254:
3255: -- Logging Infra: Setting up runtime level

Line 3345: l_msg_data FND_LOG_MESSAGES.message_text%TYPE;

3341:
3342: l_progress VARCHAR2(4) := '000';
3343: l_api_name CONSTANT VARCHAR2(100) := 'create_info_template';
3344: l_api_version CONSTANT NUMBER := 1.0;
3345: l_msg_data FND_LOG_MESSAGES.message_text%TYPE;
3346: xDBVersion NUMBER := ICX_POR_EXT_UTL.getDatabaseVersion;
3347: l_commit_size NUMBER := 50;
3348: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
3349:

Line 3348: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

3344: l_api_version CONSTANT NUMBER := 1.0;
3345: l_msg_data FND_LOG_MESSAGES.message_text%TYPE;
3346: xDBVersion NUMBER := ICX_POR_EXT_UTL.getDatabaseVersion;
3347: l_commit_size NUMBER := 50;
3348: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
3349:
3350: counter NUMBER;
3351: l_info_templ_count NUMBER;
3352:

Line 3578: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

3574: -- Parameters : p_req_header_id IN NUMBER : Corresponds to the existing requisition line id
3575:
3576: PROCEDURE update_attachment_to_standard(p_req_header_id in NUMBER) IS
3577: l_progress VARCHAR2(4) := '000';
3578: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
3579: l_api_name CONSTANT VARCHAR2(100) := 'update_attachment_to_standard';
3580: l_procedure_name CONSTANT VARCHAR2(30) := 'update_attachment_to_standard';
3581: TYPE fnd_doc_id_tb IS TABLE OF fnd_attached_documents.document_id%TYPE INDEX BY PLS_INTEGER;
3582: doc_id_v fnd_doc_id_tb;

Line 3783: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

3779: ,x_msg_data OUT NOCOPY VARCHAR2
3780: )IS
3781:
3782: l_progress VARCHAR2(4) := '000';
3783: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
3784: l_api_name CONSTANT VARCHAR2(100) := 'create_req_line_from_po_line';
3785: l_procedure_name CONSTANT VARCHAR2(30) := 'create_req_line_from_po_line';
3786:
3787: l_from_template_id NUMBER;

Line 4270: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

4266: -- p_req_line_id IN NUMBER
4267:
4268: PROCEDURE delete_supply (p_req_header_id in NUMBER,p_req_line_id IN NUMBER) IS
4269: l_progress VARCHAR2(4) := '000';
4270: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
4271: l_api_name CONSTANT VARCHAR2(100) := 'delete_supply';
4272:
4273: BEGIN
4274: l_progress := '010';

Line 4883: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

4879: ;
4880: l_rowid ROWID;
4881: coaWhereClause VARCHAR2(1000);
4882: l_procedure_name CONSTANT VARCHAR2(30) := 'req_imp_act_up_frm_wf';
4883: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
4884:
4885: CURSOR coawhereclause_csr(v_id_flex_num NUMBER)
4886: IS
4887: SELECT APPLICATION_COLUMN_NAME

Line 5332: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

5328: ;
5329: l_rowid ROWID;
5330: coaWhereClause VARCHAR2(1000);
5331: l_procedure_name CONSTANT VARCHAR2(30) := 'req_imp_mul_dst_act_up_frm_wf';
5332: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
5333:
5334: CURSOR coawhereclause_csr(v_id_flex_num NUMBER)
5335: IS
5336: SELECT APPLICATION_COLUMN_NAME