DBA Data[Home] [Help]

APPS.PSA_BC_XML_REPORT_PUB dependencies on FND_LOG

Line 4: --===========================FND_LOG.START=====================================

1: PACKAGE BODY PSA_BC_XML_REPORT_PUB AS
2: /* $Header: PSAXMLRB.pls 120.80.12020000.4 2013/04/04 19:00:24 sasukuma ship $ */
3:
4: --===========================FND_LOG.START=====================================
5: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;
6: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
7: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
8: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;

Line 5: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;

1: PACKAGE BODY PSA_BC_XML_REPORT_PUB AS
2: /* $Header: PSAXMLRB.pls 120.80.12020000.4 2013/04/04 19:00:24 sasukuma ship $ */
3:
4: --===========================FND_LOG.START=====================================
5: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;
6: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
7: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
8: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: g_error_level NUMBER := FND_LOG.LEVEL_ERROR;

Line 6: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

2: /* $Header: PSAXMLRB.pls 120.80.12020000.4 2013/04/04 19:00:24 sasukuma ship $ */
3:
4: --===========================FND_LOG.START=====================================
5: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;
6: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
7: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
8: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: g_error_level NUMBER := FND_LOG.LEVEL_ERROR;
10: g_unexp_level NUMBER := FND_LOG.LEVEL_UNEXPECTED;

Line 7: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;

3:
4: --===========================FND_LOG.START=====================================
5: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;
6: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
7: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
8: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: g_error_level NUMBER := FND_LOG.LEVEL_ERROR;
10: g_unexp_level NUMBER := FND_LOG.LEVEL_UNEXPECTED;
11: g_full_path VARCHAR2(50) := 'psa.plsql.psaxmlrb.psa_bc_xml_report_pub.';

Line 8: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;

4: --===========================FND_LOG.START=====================================
5: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;
6: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
7: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
8: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: g_error_level NUMBER := FND_LOG.LEVEL_ERROR;
10: g_unexp_level NUMBER := FND_LOG.LEVEL_UNEXPECTED;
11: g_full_path VARCHAR2(50) := 'psa.plsql.psaxmlrb.psa_bc_xml_report_pub.';
12: --===========================FND_LOG.END=======================================

Line 9: g_error_level NUMBER := FND_LOG.LEVEL_ERROR;

5: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;
6: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
7: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
8: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: g_error_level NUMBER := FND_LOG.LEVEL_ERROR;
10: g_unexp_level NUMBER := FND_LOG.LEVEL_UNEXPECTED;
11: g_full_path VARCHAR2(50) := 'psa.plsql.psaxmlrb.psa_bc_xml_report_pub.';
12: --===========================FND_LOG.END=======================================
13: ------------------------------------------------------------------------------

Line 10: g_unexp_level NUMBER := FND_LOG.LEVEL_UNEXPECTED;

6: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
7: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
8: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: g_error_level NUMBER := FND_LOG.LEVEL_ERROR;
10: g_unexp_level NUMBER := FND_LOG.LEVEL_UNEXPECTED;
11: g_full_path VARCHAR2(50) := 'psa.plsql.psaxmlrb.psa_bc_xml_report_pub.';
12: --===========================FND_LOG.END=======================================
13: ------------------------------------------------------------------------------
14: -- PROCEDURE create_bc_report

Line 12: --===========================FND_LOG.END=======================================

8: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: g_error_level NUMBER := FND_LOG.LEVEL_ERROR;
10: g_unexp_level NUMBER := FND_LOG.LEVEL_UNEXPECTED;
11: g_full_path VARCHAR2(50) := 'psa.plsql.psaxmlrb.psa_bc_xml_report_pub.';
12: --===========================FND_LOG.END=======================================
13: ------------------------------------------------------------------------------
14: -- PROCEDURE create_bc_report
15: -- Start of Comments
16: -- Purpose:

Line 47: -- Save the IN parameters in fnd log file

43: l_api_name := g_full_path||'create_bc_report';
44: errbuf := NULL;
45: retcode := 0;
46:
47: -- Save the IN parameters in fnd log file
48: psa_utils.debug_other_string(g_state_level,l_api_name, 'BEGIN of procedure create_bc_report' );
49: psa_utils.debug_other_string(g_state_level,l_api_name,'p_ledger_id' || ' = ' || p_ledger_id );
50: psa_utils.debug_other_string(g_state_level,l_api_name,'p_period_from' || ' = ' || p_period_from );
51: psa_utils.debug_other_string(g_state_level,l_api_name,'p_period_to' || ' = ' || p_period_to );

Line 181: -- Save the IN parameters in fnd log file

177: l_api_name := g_full_path||'create_bc_transaction_report';
178: errbuf := NULL;
179: retcode := 0;
180:
181: -- Save the IN parameters in fnd log file
182: psa_utils.debug_other_string(g_state_level,l_api_name,'BEGIN of procedure create_bc_transaction_report');
183: psa_utils.debug_other_string(g_state_level,l_api_name,'p_ledger_id' || ' = ' || p_ledger_id);
184: psa_utils.debug_other_string(g_state_level,l_api_name,'p_application_id' || ' = ' || p_application_id);
185: psa_utils.debug_other_string(g_state_level,l_api_name,'p_packet_event_flag' || ' = ' || p_packet_event_flag);

Line 732: -- The following should ideally return no records in the fnd_logs

728:
729: -- Bug 9200360 : Populating PSA_BC_REPORT_EVENTS_GT when the x_source is CP
730: IF x_source = 'CP' THEN
731:
732: -- The following should ideally return no records in the fnd_logs
733: FOR x_rep_eve in get_report_events_gt
734: LOOP
735: psa_utils.debug_other_string(g_state_level,l_api_name, 'EVENT_ID = '||x_rep_eve.event_id);
736: psa_utils.debug_other_string(g_state_level,l_api_name, 'PACKET_ID = '||x_rep_eve.packet_id);

Line 3149: psa_utils.debug_other_string(g_state_level, l_api_name, 'Save the IN parameters in fnd log file');

3145: -- Initialize API return status to success
3146: x_return_status := FND_API.G_RET_STS_SUCCESS;
3147:
3148: -- Construct the parameter list section
3149: psa_utils.debug_other_string(g_state_level, l_api_name, 'Save the IN parameters in fnd log file');
3150:
3151: BEGIN
3152: -- Construct the output for the paramaters list of report
3153: IF x_source = 'CP' THEN