DBA Data[Home] [Help]

APPS.CSF_TASK_ADDRESS_PVT dependencies on CSF_TASK_ADDRESS_PVT

Line 1: PACKAGE BODY CSF_TASK_ADDRESS_PVT AS

1: PACKAGE BODY CSF_TASK_ADDRESS_PVT AS
2: /* $Header: CSFVTADB.pls 120.39.12020000.8 2013/04/18 11:55:47 kramini ship $ */
3: g_debug_enabled varchar2(1);
4: g_debug_level NUMBER;
5: TYPE REF_CURSOR IS REF CURSOR;

Line 39: fnd_log.string(p_level, 'csf.plsql.CSF_TASK_ADDRESS_PVT.' || p_module, p_message);

35: ELSE
36: fnd_file.put_line(fnd_file.log, rpad(p_module, 20) || ': ' || p_message);
37: END IF;
38: ELSE
39: fnd_log.string(p_level, 'csf.plsql.CSF_TASK_ADDRESS_PVT.' || p_module, p_message);
40: END IF;
41: END IF;
42: --dbms_output.put_line(rpad(p_module, 20) || ': ' || p_message);
43: END debug;

Line 918: debug('CSF_TASK_ADDRESS_PVT.form_task_address_query: Error = ' || SQLERRM, l_api_name, fnd_log.level_error);

914: CLOSE p_task_address_cursor;
915: EXCEPTION
916: WHEN OTHERS
917: THEN
918: debug('CSF_TASK_ADDRESS_PVT.form_task_address_query: Error = ' || SQLERRM, l_api_name, fnd_log.level_error);
919: END form_task_address_query;
920:
921: PROCEDURE retrieve_data (
922: p_api_version IN NUMBER,

Line 1010: debug('CSF_TASK_ADDRESS_PVT.retrieve_data: Unexpected Error = ' || x_msg_data, l_api_name, fnd_log.level_error);

1006: x_return_status := fnd_api.g_ret_sts_unexp_error;
1007: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1008: p_data => x_msg_data
1009: );
1010: debug('CSF_TASK_ADDRESS_PVT.retrieve_data: Unexpected Error = ' || x_msg_data, l_api_name, fnd_log.level_error);
1011: WHEN OTHERS
1012: THEN
1013: x_return_status := fnd_api.g_ret_sts_unexp_error;
1014:

Line 1022: debug('CSF_TASK_ADDRESS_PVT.retrieve_data: Unexpected Error = ' || x_msg_data, l_api_name, fnd_log.level_error);

1018: END IF;
1019:
1020: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1021: p_data => x_msg_data);
1022: debug('CSF_TASK_ADDRESS_PVT.retrieve_data: Unexpected Error = ' || x_msg_data, l_api_name, fnd_log.level_error);
1023: END retrieve_data;
1024:
1025: /*
1026: Utility procedure to fetch the locus for a location id.

Line 3186: end csf_task_address_pvt;

3182: END;
3183:
3184: begin
3185: init_package;
3186: end csf_task_address_pvt;
3187: