eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PSA_BC_XML_REPORT_PUB dependencies on PSA_UTILS

Line 48: psa_utils.debug_other_string(g_state_level,l_api_name, 'BEGIN of procedure 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 );
52: psa_utils.debug_other_string(g_state_level,l_api_name,'p_chart_of_accts_id' || ' = ' || p_chart_of_accts_id );

Line 49: psa_utils.debug_other_string(g_state_level,l_api_name,'p_ledger_id' || ' = ' || p_ledger_id );

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 );
52: psa_utils.debug_other_string(g_state_level,l_api_name,'p_chart_of_accts_id' || ' = ' || p_chart_of_accts_id );
53: psa_utils.debug_other_string(g_state_level,l_api_name,'p_ccid_low' || ' = ' || p_ccid_low );

Line 50: psa_utils.debug_other_string(g_state_level,l_api_name,'p_period_from' || ' = ' || p_period_from );

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 );
52: psa_utils.debug_other_string(g_state_level,l_api_name,'p_chart_of_accts_id' || ' = ' || p_chart_of_accts_id );
53: psa_utils.debug_other_string(g_state_level,l_api_name,'p_ccid_low' || ' = ' || p_ccid_low );
54: psa_utils.debug_other_string(g_state_level,l_api_name,'p_ccid_high' || ' = ' || p_ccid_high );

Line 51: psa_utils.debug_other_string(g_state_level,l_api_name,'p_period_to' || ' = ' || p_period_to );

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 );
52: psa_utils.debug_other_string(g_state_level,l_api_name,'p_chart_of_accts_id' || ' = ' || p_chart_of_accts_id );
53: psa_utils.debug_other_string(g_state_level,l_api_name,'p_ccid_low' || ' = ' || p_ccid_low );
54: psa_utils.debug_other_string(g_state_level,l_api_name,'p_ccid_high' || ' = ' || p_ccid_high );
55: psa_utils.debug_other_string(g_state_level,l_api_name,'p_application_short_name' || ' = ' || p_application_short_name );

Line 52: psa_utils.debug_other_string(g_state_level,l_api_name,'p_chart_of_accts_id' || ' = ' || p_chart_of_accts_id );

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 );
52: psa_utils.debug_other_string(g_state_level,l_api_name,'p_chart_of_accts_id' || ' = ' || p_chart_of_accts_id );
53: psa_utils.debug_other_string(g_state_level,l_api_name,'p_ccid_low' || ' = ' || p_ccid_low );
54: psa_utils.debug_other_string(g_state_level,l_api_name,'p_ccid_high' || ' = ' || p_ccid_high );
55: psa_utils.debug_other_string(g_state_level,l_api_name,'p_application_short_name' || ' = ' || p_application_short_name );
56: psa_utils.debug_other_string(g_state_level,l_api_name,'p_funds_check_status' || ' = ' || p_funds_check_status );

Line 53: psa_utils.debug_other_string(g_state_level,l_api_name,'p_ccid_low' || ' = ' || p_ccid_low );

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 );
52: psa_utils.debug_other_string(g_state_level,l_api_name,'p_chart_of_accts_id' || ' = ' || p_chart_of_accts_id );
53: psa_utils.debug_other_string(g_state_level,l_api_name,'p_ccid_low' || ' = ' || p_ccid_low );
54: psa_utils.debug_other_string(g_state_level,l_api_name,'p_ccid_high' || ' = ' || p_ccid_high );
55: psa_utils.debug_other_string(g_state_level,l_api_name,'p_application_short_name' || ' = ' || p_application_short_name );
56: psa_utils.debug_other_string(g_state_level,l_api_name,'p_funds_check_status' || ' = ' || p_funds_check_status );
57: psa_utils.debug_other_string(g_state_level,l_api_name,'p_order_by' || ' = ' || p_order_by );

Line 54: psa_utils.debug_other_string(g_state_level,l_api_name,'p_ccid_high' || ' = ' || p_ccid_high );

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 );
52: psa_utils.debug_other_string(g_state_level,l_api_name,'p_chart_of_accts_id' || ' = ' || p_chart_of_accts_id );
53: psa_utils.debug_other_string(g_state_level,l_api_name,'p_ccid_low' || ' = ' || p_ccid_low );
54: psa_utils.debug_other_string(g_state_level,l_api_name,'p_ccid_high' || ' = ' || p_ccid_high );
55: psa_utils.debug_other_string(g_state_level,l_api_name,'p_application_short_name' || ' = ' || p_application_short_name );
56: psa_utils.debug_other_string(g_state_level,l_api_name,'p_funds_check_status' || ' = ' || p_funds_check_status );
57: psa_utils.debug_other_string(g_state_level,l_api_name,'p_order_by' || ' = ' || p_order_by );
58:

Line 55: psa_utils.debug_other_string(g_state_level,l_api_name,'p_application_short_name' || ' = ' || p_application_short_name );

51: psa_utils.debug_other_string(g_state_level,l_api_name,'p_period_to' || ' = ' || p_period_to );
52: psa_utils.debug_other_string(g_state_level,l_api_name,'p_chart_of_accts_id' || ' = ' || p_chart_of_accts_id );
53: psa_utils.debug_other_string(g_state_level,l_api_name,'p_ccid_low' || ' = ' || p_ccid_low );
54: psa_utils.debug_other_string(g_state_level,l_api_name,'p_ccid_high' || ' = ' || p_ccid_high );
55: psa_utils.debug_other_string(g_state_level,l_api_name,'p_application_short_name' || ' = ' || p_application_short_name );
56: psa_utils.debug_other_string(g_state_level,l_api_name,'p_funds_check_status' || ' = ' || p_funds_check_status );
57: psa_utils.debug_other_string(g_state_level,l_api_name,'p_order_by' || ' = ' || p_order_by );
58:
59:

Line 56: psa_utils.debug_other_string(g_state_level,l_api_name,'p_funds_check_status' || ' = ' || p_funds_check_status );

52: psa_utils.debug_other_string(g_state_level,l_api_name,'p_chart_of_accts_id' || ' = ' || p_chart_of_accts_id );
53: psa_utils.debug_other_string(g_state_level,l_api_name,'p_ccid_low' || ' = ' || p_ccid_low );
54: psa_utils.debug_other_string(g_state_level,l_api_name,'p_ccid_high' || ' = ' || p_ccid_high );
55: psa_utils.debug_other_string(g_state_level,l_api_name,'p_application_short_name' || ' = ' || p_application_short_name );
56: psa_utils.debug_other_string(g_state_level,l_api_name,'p_funds_check_status' || ' = ' || p_funds_check_status );
57: psa_utils.debug_other_string(g_state_level,l_api_name,'p_order_by' || ' = ' || p_order_by );
58:
59:
60: -- Get the Application Id for the Application Short Name paramater

Line 57: psa_utils.debug_other_string(g_state_level,l_api_name,'p_order_by' || ' = ' || p_order_by );

53: psa_utils.debug_other_string(g_state_level,l_api_name,'p_ccid_low' || ' = ' || p_ccid_low );
54: psa_utils.debug_other_string(g_state_level,l_api_name,'p_ccid_high' || ' = ' || p_ccid_high );
55: psa_utils.debug_other_string(g_state_level,l_api_name,'p_application_short_name' || ' = ' || p_application_short_name );
56: psa_utils.debug_other_string(g_state_level,l_api_name,'p_funds_check_status' || ' = ' || p_funds_check_status );
57: psa_utils.debug_other_string(g_state_level,l_api_name,'p_order_by' || ' = ' || p_order_by );
58:
59:
60: -- Get the Application Id for the Application Short Name paramater
61: IF p_application_short_name <> 'ALL' THEN

Line 71: psa_utils.debug_other_string(g_state_level,l_api_name,'Initialize funds_check_report_rec_type record' );

67: END IF;
68:
69:
70: -- Initialize funds_check_report_rec_type record
71: psa_utils.debug_other_string(g_state_level,l_api_name,'Initialize funds_check_report_rec_type record' );
72:
73: l_para_rec.ledger_id := p_ledger_id;
74: l_para_rec.period_from := p_period_from;
75: l_para_rec.period_to := p_period_to;

Line 86: psa_utils.debug_other_string(g_state_level,l_api_name,'Call build_report_query Procedure' );

82: l_para_rec.application_id := l_application_id;
83:
84:
85: -- Build the query to get the data from PSA_BC_REPORT_V
86: psa_utils.debug_other_string(g_state_level,l_api_name,'Call build_report_query Procedure' );
87: psa_utils.debug_other_string(g_state_level,l_api_name,'l_return_status: ' || l_return_status );
88:
89: build_report_query(x_return_status => l_return_status,
90: x_source => 'CP',

Line 87: psa_utils.debug_other_string(g_state_level,l_api_name,'l_return_status: ' || l_return_status );

83:
84:
85: -- Build the query to get the data from PSA_BC_REPORT_V
86: psa_utils.debug_other_string(g_state_level,l_api_name,'Call build_report_query Procedure' );
87: psa_utils.debug_other_string(g_state_level,l_api_name,'l_return_status: ' || l_return_status );
88:
89: build_report_query(x_return_status => l_return_status,
90: x_source => 'CP',
91: p_para_rec => l_para_rec,

Line 97: psa_utils.debug_other_string(g_state_level,l_api_name,'Call Get_XML Procedure' );

93: x_report_query => l_query);
94:
95:
96: -- Get the XML data source --
97: psa_utils.debug_other_string(g_state_level,l_api_name,'Call Get_XML Procedure' );
98:
99: get_xml(x_return_status => l_return_status,
100: p_query => l_query,
101: p_rowset_tag => 'TRANSACTIONS',

Line 106: psa_utils.debug_other_string(g_state_level,l_api_name,'Call construct_bc_report_output' );

102: p_row_tag => 'ACCOUNTING_LINE',
103: x_xml => l_trxs);
104:
105: -- Manipulate XML data source to XML Publisher compatiable format and save it to output file --
106: psa_utils.debug_other_string(g_state_level,l_api_name,'Call construct_bc_report_output' );
107:
108: construct_bc_report_output(x_return_status => l_return_status,
109: x_source => 'CP',
110: p_para_rec => l_para_rec,

Line 117: psa_utils.debug_other_string(g_state_level,l_api_name,'end of procedure create_bc_report' );

113:
114: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
115: RAISE FND_API.G_EXC_ERROR;
116: END IF;
117: psa_utils.debug_other_string(g_state_level,l_api_name,'end of procedure create_bc_report' );
118:
119: EXCEPTION
120: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
121: retcode := 2;

Line 122: psa_utils.debug_other_string(g_unexp_level,l_api_name,'ERROR: Unexpected Error in create_bc_report Procedure' );

118:
119: EXCEPTION
120: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
121: retcode := 2;
122: psa_utils.debug_other_string(g_unexp_level,l_api_name,'ERROR: Unexpected Error in create_bc_report Procedure' );
123:
124: WHEN FND_API.G_EXC_ERROR THEN
125: retcode := 2;
126: psa_utils.debug_other_string(g_error_level,l_api_name,'EXCEPTION: '|| SQLERRM(sqlcode));

Line 126: psa_utils.debug_other_string(g_error_level,l_api_name,'EXCEPTION: '|| SQLERRM(sqlcode));

122: psa_utils.debug_other_string(g_unexp_level,l_api_name,'ERROR: Unexpected Error in create_bc_report Procedure' );
123:
124: WHEN FND_API.G_EXC_ERROR THEN
125: retcode := 2;
126: psa_utils.debug_other_string(g_error_level,l_api_name,'EXCEPTION: '|| SQLERRM(sqlcode));
127: psa_utils.debug_other_string(g_error_level,l_api_name,'Error in create_bc_report Procedure' );
128:
129: WHEN OTHERS THEN
130: retcode := 2;

Line 127: psa_utils.debug_other_string(g_error_level,l_api_name,'Error in create_bc_report Procedure' );

123:
124: WHEN FND_API.G_EXC_ERROR THEN
125: retcode := 2;
126: psa_utils.debug_other_string(g_error_level,l_api_name,'EXCEPTION: '|| SQLERRM(sqlcode));
127: psa_utils.debug_other_string(g_error_level,l_api_name,'Error in create_bc_report Procedure' );
128:
129: WHEN OTHERS THEN
130: retcode := 2;
131: psa_utils.debug_other_string(g_excep_level,l_api_name,'Error in create_bc_report Procedure' );

Line 131: psa_utils.debug_other_string(g_excep_level,l_api_name,'Error in create_bc_report Procedure' );

127: psa_utils.debug_other_string(g_error_level,l_api_name,'Error in create_bc_report Procedure' );
128:
129: WHEN OTHERS THEN
130: retcode := 2;
131: psa_utils.debug_other_string(g_excep_level,l_api_name,'Error in create_bc_report Procedure' );
132:
133: END create_bc_report;
134:
135: ------------------------------------------------------------------------------

Line 182: psa_utils.debug_other_string(g_state_level,l_api_name,'BEGIN of procedure 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);
186: psa_utils.debug_other_string(g_state_level,l_api_name,'p_sequence_id' || ' = ' || p_sequence_id);

Line 183: psa_utils.debug_other_string(g_state_level,l_api_name,'p_ledger_id' || ' = ' || p_ledger_id);

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);
186: psa_utils.debug_other_string(g_state_level,l_api_name,'p_sequence_id' || ' = ' || p_sequence_id);
187:

Line 184: psa_utils.debug_other_string(g_state_level,l_api_name,'p_application_id' || ' = ' || p_application_id);

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);
186: psa_utils.debug_other_string(g_state_level,l_api_name,'p_sequence_id' || ' = ' || p_sequence_id);
187:
188: psa_utils.debug_other_string(g_state_level,l_api_name, 'PSA_BC_REPORT_EVENTS_GT');

Line 185: psa_utils.debug_other_string(g_state_level,l_api_name,'p_packet_event_flag' || ' = ' || p_packet_event_flag);

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);
186: psa_utils.debug_other_string(g_state_level,l_api_name,'p_sequence_id' || ' = ' || p_sequence_id);
187:
188: psa_utils.debug_other_string(g_state_level,l_api_name, 'PSA_BC_REPORT_EVENTS_GT');
189: psa_utils.debug_other_string(g_state_level,l_api_name, '========================');

Line 186: psa_utils.debug_other_string(g_state_level,l_api_name,'p_sequence_id' || ' = ' || p_sequence_id);

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);
186: psa_utils.debug_other_string(g_state_level,l_api_name,'p_sequence_id' || ' = ' || p_sequence_id);
187:
188: psa_utils.debug_other_string(g_state_level,l_api_name, 'PSA_BC_REPORT_EVENTS_GT');
189: psa_utils.debug_other_string(g_state_level,l_api_name, '========================');
190:

Line 188: psa_utils.debug_other_string(g_state_level,l_api_name, 'PSA_BC_REPORT_EVENTS_GT');

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);
186: psa_utils.debug_other_string(g_state_level,l_api_name,'p_sequence_id' || ' = ' || p_sequence_id);
187:
188: psa_utils.debug_other_string(g_state_level,l_api_name, 'PSA_BC_REPORT_EVENTS_GT');
189: psa_utils.debug_other_string(g_state_level,l_api_name, '========================');
190:
191: FOR x in get_report_events_gt
192: LOOP

Line 189: psa_utils.debug_other_string(g_state_level,l_api_name, '========================');

185: psa_utils.debug_other_string(g_state_level,l_api_name,'p_packet_event_flag' || ' = ' || p_packet_event_flag);
186: psa_utils.debug_other_string(g_state_level,l_api_name,'p_sequence_id' || ' = ' || p_sequence_id);
187:
188: psa_utils.debug_other_string(g_state_level,l_api_name, 'PSA_BC_REPORT_EVENTS_GT');
189: psa_utils.debug_other_string(g_state_level,l_api_name, '========================');
190:
191: FOR x in get_report_events_gt
192: LOOP
193: psa_utils.debug_other_string(g_state_level,l_api_name, 'EVENT_ID = '||x.event_id);

Line 193: psa_utils.debug_other_string(g_state_level,l_api_name, 'EVENT_ID = '||x.event_id);

189: psa_utils.debug_other_string(g_state_level,l_api_name, '========================');
190:
191: FOR x in get_report_events_gt
192: LOOP
193: psa_utils.debug_other_string(g_state_level,l_api_name, 'EVENT_ID = '||x.event_id);
194: psa_utils.debug_other_string(g_state_level,l_api_name, 'PACKET_ID = '||x.packet_id);
195: psa_utils.debug_other_string(g_state_level,l_api_name, 'SOURCE_DISTRIBUTION_TYPE = '||x.source_distribution_type);
196: psa_utils.debug_other_string(g_state_level,l_api_name, 'SOURCE_DISTRIBUTION_ID_NUM_1 = '||x.source_distribution_id_num_1);
197: psa_utils.debug_other_string(g_state_level,l_api_name, 'SOURCE_DISTRIBUTION_ID_NUM_2 = '||x.source_distribution_id_num_2);

Line 194: psa_utils.debug_other_string(g_state_level,l_api_name, 'PACKET_ID = '||x.packet_id);

190:
191: FOR x in get_report_events_gt
192: LOOP
193: psa_utils.debug_other_string(g_state_level,l_api_name, 'EVENT_ID = '||x.event_id);
194: psa_utils.debug_other_string(g_state_level,l_api_name, 'PACKET_ID = '||x.packet_id);
195: psa_utils.debug_other_string(g_state_level,l_api_name, 'SOURCE_DISTRIBUTION_TYPE = '||x.source_distribution_type);
196: psa_utils.debug_other_string(g_state_level,l_api_name, 'SOURCE_DISTRIBUTION_ID_NUM_1 = '||x.source_distribution_id_num_1);
197: psa_utils.debug_other_string(g_state_level,l_api_name, 'SOURCE_DISTRIBUTION_ID_NUM_2 = '||x.source_distribution_id_num_2);
198: psa_utils.debug_other_string(g_state_level,l_api_name, 'SOURCE_DISTRIBUTION_ID_NUM_3 = '||x.source_distribution_id_num_3);

Line 195: psa_utils.debug_other_string(g_state_level,l_api_name, 'SOURCE_DISTRIBUTION_TYPE = '||x.source_distribution_type);

191: FOR x in get_report_events_gt
192: LOOP
193: psa_utils.debug_other_string(g_state_level,l_api_name, 'EVENT_ID = '||x.event_id);
194: psa_utils.debug_other_string(g_state_level,l_api_name, 'PACKET_ID = '||x.packet_id);
195: psa_utils.debug_other_string(g_state_level,l_api_name, 'SOURCE_DISTRIBUTION_TYPE = '||x.source_distribution_type);
196: psa_utils.debug_other_string(g_state_level,l_api_name, 'SOURCE_DISTRIBUTION_ID_NUM_1 = '||x.source_distribution_id_num_1);
197: psa_utils.debug_other_string(g_state_level,l_api_name, 'SOURCE_DISTRIBUTION_ID_NUM_2 = '||x.source_distribution_id_num_2);
198: psa_utils.debug_other_string(g_state_level,l_api_name, 'SOURCE_DISTRIBUTION_ID_NUM_3 = '||x.source_distribution_id_num_3);
199: psa_utils.debug_other_string(g_state_level,l_api_name, 'SOURCE_DISTRIBUTION_ID_NUM_4 = '||x.source_distribution_id_num_4);

Line 196: psa_utils.debug_other_string(g_state_level,l_api_name, 'SOURCE_DISTRIBUTION_ID_NUM_1 = '||x.source_distribution_id_num_1);

192: LOOP
193: psa_utils.debug_other_string(g_state_level,l_api_name, 'EVENT_ID = '||x.event_id);
194: psa_utils.debug_other_string(g_state_level,l_api_name, 'PACKET_ID = '||x.packet_id);
195: psa_utils.debug_other_string(g_state_level,l_api_name, 'SOURCE_DISTRIBUTION_TYPE = '||x.source_distribution_type);
196: psa_utils.debug_other_string(g_state_level,l_api_name, 'SOURCE_DISTRIBUTION_ID_NUM_1 = '||x.source_distribution_id_num_1);
197: psa_utils.debug_other_string(g_state_level,l_api_name, 'SOURCE_DISTRIBUTION_ID_NUM_2 = '||x.source_distribution_id_num_2);
198: psa_utils.debug_other_string(g_state_level,l_api_name, 'SOURCE_DISTRIBUTION_ID_NUM_3 = '||x.source_distribution_id_num_3);
199: psa_utils.debug_other_string(g_state_level,l_api_name, 'SOURCE_DISTRIBUTION_ID_NUM_4 = '||x.source_distribution_id_num_4);
200: psa_utils.debug_other_string(g_state_level,l_api_name, 'SOURCE_DISTRIBUTION_ID_NUM_5 = '||x.source_distribution_id_num_5);

Line 197: psa_utils.debug_other_string(g_state_level,l_api_name, 'SOURCE_DISTRIBUTION_ID_NUM_2 = '||x.source_distribution_id_num_2);

193: psa_utils.debug_other_string(g_state_level,l_api_name, 'EVENT_ID = '||x.event_id);
194: psa_utils.debug_other_string(g_state_level,l_api_name, 'PACKET_ID = '||x.packet_id);
195: psa_utils.debug_other_string(g_state_level,l_api_name, 'SOURCE_DISTRIBUTION_TYPE = '||x.source_distribution_type);
196: psa_utils.debug_other_string(g_state_level,l_api_name, 'SOURCE_DISTRIBUTION_ID_NUM_1 = '||x.source_distribution_id_num_1);
197: psa_utils.debug_other_string(g_state_level,l_api_name, 'SOURCE_DISTRIBUTION_ID_NUM_2 = '||x.source_distribution_id_num_2);
198: psa_utils.debug_other_string(g_state_level,l_api_name, 'SOURCE_DISTRIBUTION_ID_NUM_3 = '||x.source_distribution_id_num_3);
199: psa_utils.debug_other_string(g_state_level,l_api_name, 'SOURCE_DISTRIBUTION_ID_NUM_4 = '||x.source_distribution_id_num_4);
200: psa_utils.debug_other_string(g_state_level,l_api_name, 'SOURCE_DISTRIBUTION_ID_NUM_5 = '||x.source_distribution_id_num_5);
201: END LOOP;

Line 198: psa_utils.debug_other_string(g_state_level,l_api_name, 'SOURCE_DISTRIBUTION_ID_NUM_3 = '||x.source_distribution_id_num_3);

194: psa_utils.debug_other_string(g_state_level,l_api_name, 'PACKET_ID = '||x.packet_id);
195: psa_utils.debug_other_string(g_state_level,l_api_name, 'SOURCE_DISTRIBUTION_TYPE = '||x.source_distribution_type);
196: psa_utils.debug_other_string(g_state_level,l_api_name, 'SOURCE_DISTRIBUTION_ID_NUM_1 = '||x.source_distribution_id_num_1);
197: psa_utils.debug_other_string(g_state_level,l_api_name, 'SOURCE_DISTRIBUTION_ID_NUM_2 = '||x.source_distribution_id_num_2);
198: psa_utils.debug_other_string(g_state_level,l_api_name, 'SOURCE_DISTRIBUTION_ID_NUM_3 = '||x.source_distribution_id_num_3);
199: psa_utils.debug_other_string(g_state_level,l_api_name, 'SOURCE_DISTRIBUTION_ID_NUM_4 = '||x.source_distribution_id_num_4);
200: psa_utils.debug_other_string(g_state_level,l_api_name, 'SOURCE_DISTRIBUTION_ID_NUM_5 = '||x.source_distribution_id_num_5);
201: END LOOP;
202:

Line 199: psa_utils.debug_other_string(g_state_level,l_api_name, 'SOURCE_DISTRIBUTION_ID_NUM_4 = '||x.source_distribution_id_num_4);

195: psa_utils.debug_other_string(g_state_level,l_api_name, 'SOURCE_DISTRIBUTION_TYPE = '||x.source_distribution_type);
196: psa_utils.debug_other_string(g_state_level,l_api_name, 'SOURCE_DISTRIBUTION_ID_NUM_1 = '||x.source_distribution_id_num_1);
197: psa_utils.debug_other_string(g_state_level,l_api_name, 'SOURCE_DISTRIBUTION_ID_NUM_2 = '||x.source_distribution_id_num_2);
198: psa_utils.debug_other_string(g_state_level,l_api_name, 'SOURCE_DISTRIBUTION_ID_NUM_3 = '||x.source_distribution_id_num_3);
199: psa_utils.debug_other_string(g_state_level,l_api_name, 'SOURCE_DISTRIBUTION_ID_NUM_4 = '||x.source_distribution_id_num_4);
200: psa_utils.debug_other_string(g_state_level,l_api_name, 'SOURCE_DISTRIBUTION_ID_NUM_5 = '||x.source_distribution_id_num_5);
201: END LOOP;
202:
203: -- Get the Application Id for the Application Short Name paramater

Line 200: psa_utils.debug_other_string(g_state_level,l_api_name, 'SOURCE_DISTRIBUTION_ID_NUM_5 = '||x.source_distribution_id_num_5);

196: psa_utils.debug_other_string(g_state_level,l_api_name, 'SOURCE_DISTRIBUTION_ID_NUM_1 = '||x.source_distribution_id_num_1);
197: psa_utils.debug_other_string(g_state_level,l_api_name, 'SOURCE_DISTRIBUTION_ID_NUM_2 = '||x.source_distribution_id_num_2);
198: psa_utils.debug_other_string(g_state_level,l_api_name, 'SOURCE_DISTRIBUTION_ID_NUM_3 = '||x.source_distribution_id_num_3);
199: psa_utils.debug_other_string(g_state_level,l_api_name, 'SOURCE_DISTRIBUTION_ID_NUM_4 = '||x.source_distribution_id_num_4);
200: psa_utils.debug_other_string(g_state_level,l_api_name, 'SOURCE_DISTRIBUTION_ID_NUM_5 = '||x.source_distribution_id_num_5);
201: END LOOP;
202:
203: -- Get the Application Id for the Application Short Name paramater
204: l_application_id := p_application_id;

Line 207: psa_utils.debug_other_string(g_state_level,l_api_name, 'Initialize funds_check_report_rec_type record');

203: -- Get the Application Id for the Application Short Name paramater
204: l_application_id := p_application_id;
205:
206: -- initialize funds_check_report_rec_type record
207: psa_utils.debug_other_string(g_state_level,l_api_name, 'Initialize funds_check_report_rec_type record');
208:
209: l_para_rec.ledger_id := p_ledger_id;
210: l_para_rec.application_id := l_application_id;
211: l_para_rec.packet_event_flag := p_packet_event_flag;

Line 215: psa_utils.debug_other_string(g_state_level,l_api_name,'Call build_report_query Procedure');

211: l_para_rec.packet_event_flag := p_packet_event_flag;
212: l_para_rec.sequence_id := p_sequence_id;
213:
214: -- Build the query to get the data from PSA_BC_REPORT_V
215: psa_utils.debug_other_string(g_state_level,l_api_name,'Call build_report_query Procedure');
216:
217: build_report_query(x_return_status => l_return_status,
218: x_source => 'FORM',
219: p_para_rec => l_para_rec,

Line 223: psa_utils.debug_other_string(g_state_level,l_api_name,'l_return_status: ' || l_return_status);

219: p_para_rec => l_para_rec,
220: p_application_short_name => l_para_rec.application_short_name,
221: x_report_query => l_query);
222:
223: psa_utils.debug_other_string(g_state_level,l_api_name,'l_return_status: ' || l_return_status);
224:
225: -- Get the XML data source
226: psa_utils.debug_other_string(g_state_level,l_api_name,'Call Get_XML Procedure');
227:

Line 226: psa_utils.debug_other_string(g_state_level,l_api_name,'Call Get_XML Procedure');

222:
223: psa_utils.debug_other_string(g_state_level,l_api_name,'l_return_status: ' || l_return_status);
224:
225: -- Get the XML data source
226: psa_utils.debug_other_string(g_state_level,l_api_name,'Call Get_XML Procedure');
227:
228: -- Call to GET_XML procedure
229: get_xml(x_return_status => l_return_status,
230: p_query => l_query,

Line 237: psa_utils.debug_other_string(g_state_level,l_api_name,'Call construct_bc_report_output');

233: x_xml => l_trxs);
234:
235: -- Call to construct_bc_report_output procedure
236: -- Manipulate XML data source to XML Publisher compatiable format and save it to output file
237: psa_utils.debug_other_string(g_state_level,l_api_name,'Call construct_bc_report_output');
238:
239: construct_bc_report_output(x_return_status => l_return_status,
240: x_source => 'FORM',
241: p_para_rec => l_para_rec,

Line 248: psa_utils.debug_other_string(g_state_level,l_api_name,'end of procedure create_bc_transaction_report');

244: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
245: RAISE FND_API.G_EXC_ERROR;
246: END IF;
247:
248: psa_utils.debug_other_string(g_state_level,l_api_name,'end of procedure create_bc_transaction_report');
249:
250: EXCEPTION
251: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
252: retcode := 2;

Line 253: psa_utils.debug_other_string(g_unexp_level,l_api_name, 'ERROR: Unexpected Error in create_bc_report Procedure');

249:
250: EXCEPTION
251: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
252: retcode := 2;
253: psa_utils.debug_other_string(g_unexp_level,l_api_name, 'ERROR: Unexpected Error in create_bc_report Procedure');
254:
255: WHEN FND_API.G_EXC_ERROR THEN
256: retcode := 2;
257: psa_utils.debug_other_string(g_error_level,l_api_name,'ERROR: ' || SQLERRM(sqlcode));

Line 257: psa_utils.debug_other_string(g_error_level,l_api_name,'ERROR: ' || SQLERRM(sqlcode));

253: psa_utils.debug_other_string(g_unexp_level,l_api_name, 'ERROR: Unexpected Error in create_bc_report Procedure');
254:
255: WHEN FND_API.G_EXC_ERROR THEN
256: retcode := 2;
257: psa_utils.debug_other_string(g_error_level,l_api_name,'ERROR: ' || SQLERRM(sqlcode));
258: psa_utils.debug_other_string(g_error_level,l_api_name,'Error in create_bc_report Procedure');
259:
260: WHEN OTHERS THEN
261: retcode := 2;

Line 258: psa_utils.debug_other_string(g_error_level,l_api_name,'Error in create_bc_report Procedure');

254:
255: WHEN FND_API.G_EXC_ERROR THEN
256: retcode := 2;
257: psa_utils.debug_other_string(g_error_level,l_api_name,'ERROR: ' || SQLERRM(sqlcode));
258: psa_utils.debug_other_string(g_error_level,l_api_name,'Error in create_bc_report Procedure');
259:
260: WHEN OTHERS THEN
261: retcode := 2;
262: psa_utils.debug_other_string(g_excep_level,l_api_name,'EXCEPTION: Unknown Error in create_bc_report Procedure');

Line 262: psa_utils.debug_other_string(g_excep_level,l_api_name,'EXCEPTION: Unknown Error in create_bc_report Procedure');

258: psa_utils.debug_other_string(g_error_level,l_api_name,'Error in create_bc_report Procedure');
259:
260: WHEN OTHERS THEN
261: retcode := 2;
262: psa_utils.debug_other_string(g_excep_level,l_api_name,'EXCEPTION: Unknown Error in create_bc_report Procedure');
263: END create_bc_transaction_report;
264:
265:
266: -------------------------------------------------------------------------------

Line 537: psa_utils.debug_other_string(g_state_level,l_api_name,'p_ccid ='||p_ccid);

533: l_fund_value VARCHAR2(30);
534: l_treasury_symbol VARCHAR2(100);
535: begin
536: l_api_name := g_full_path||'get_treasury_symbol';
537: psa_utils.debug_other_string(g_state_level,l_api_name,'p_ccid ='||p_ccid);
538:
539: IF p_ccid IS NULL THEN
540: psa_utils.debug_other_string(g_state_level,l_api_name,'p_ccid IS NULL. Return NULL.');
541: return NULL;

Line 540: psa_utils.debug_other_string(g_state_level,l_api_name,'p_ccid IS NULL. Return NULL.');

536: l_api_name := g_full_path||'get_treasury_symbol';
537: psa_utils.debug_other_string(g_state_level,l_api_name,'p_ccid ='||p_ccid);
538:
539: IF p_ccid IS NULL THEN
540: psa_utils.debug_other_string(g_state_level,l_api_name,'p_ccid IS NULL. Return NULL.');
541: return NULL;
542: END IF;
543:
544: l_result := FND_FLEX_KEYVAL.validate_ccid (

Line 566: psa_utils.debug_other_string(g_state_level,l_api_name,'When Other Exception raised while retreiving Treasury Symbol');

562: AND set_of_books_id = p_para_rec.ledger_id;
563:
564: EXCEPTION
565: WHEN others THEN
566: psa_utils.debug_other_string(g_state_level,l_api_name,'When Other Exception raised while retreiving Treasury Symbol');
567: l_treasury_symbol := null;
568:
569: END;
570: END IF;

Line 624: psa_utils.debug_other_string(g_state_level,l_api_name,'BEGIN of procedure build_report_query');

620: BEGIN
621:
622: l_api_name := g_full_path||'build_report_query';
623:
624: psa_utils.debug_other_string(g_state_level,l_api_name,'BEGIN of procedure build_report_query');
625:
626:
627: -- Get the current chart of accounts id
628: OPEN get_coaid(p_para_rec.ledger_id);

Line 631: psa_utils.debug_other_string(g_state_level,l_api_name,'l_coaid' || ' = ' || l_coaid);

627: -- Get the current chart of accounts id
628: OPEN get_coaid(p_para_rec.ledger_id);
629: FETCH get_coaid INTO l_coaid;
630: CLOSE get_coaid;
631: psa_utils.debug_other_string(g_state_level,l_api_name,'l_coaid' || ' = ' || l_coaid);
632:
633: -- Fetch and store the period_num value for period_from and period_to
634: OPEN get_period_num(p_para_rec.period_from);
635: FETCH get_period_num INTO l_period_start_num;

Line 637: psa_utils.debug_other_string(g_state_level,l_api_name,'L_Period_Start_Num' || ' = ' || l_period_start_num);

633: -- Fetch and store the period_num value for period_from and period_to
634: OPEN get_period_num(p_para_rec.period_from);
635: FETCH get_period_num INTO l_period_start_num;
636: CLOSE get_period_num;
637: psa_utils.debug_other_string(g_state_level,l_api_name,'L_Period_Start_Num' || ' = ' || l_period_start_num);
638:
639: OPEN get_period_num(p_para_rec.period_to);
640: FETCH get_period_num INTO l_period_end_num;
641: CLOSE get_period_num;

Line 642: psa_utils.debug_other_string(g_state_level,l_api_name,'L_Period_End_Num' || ' = ' || l_period_end_num);

638:
639: OPEN get_period_num(p_para_rec.period_to);
640: FETCH get_period_num INTO l_period_end_num;
641: CLOSE get_period_num;
642: psa_utils.debug_other_string(g_state_level,l_api_name,'L_Period_End_Num' || ' = ' || l_period_end_num);
643:
644: IF (p_para_rec.application_id IN (200, 201)) AND (x_source = 'FORM') THEN
645: OPEN get_event_class_codes(p_para_rec.application_id);
646: FETCH get_event_class_codes into l_event_class_codes;

Line 649: psa_utils.debug_other_string(g_state_level,l_api_name,'Event Class Codes:');

645: OPEN get_event_class_codes(p_para_rec.application_id);
646: FETCH get_event_class_codes into l_event_class_codes;
647: CLOSE get_event_class_codes;
648:
649: psa_utils.debug_other_string(g_state_level,l_api_name,'Event Class Codes:');
650: psa_utils.debug_other_string(g_state_level,l_api_name,'Invoices' || ' = ' || l_event_class_codes.invoices);
651: psa_utils.debug_other_string(g_state_level,l_api_name,'Debit Memos' || ' = ' || l_event_class_codes.debit_memos);
652: psa_utils.debug_other_string(g_state_level,l_api_name,'Credit Memos' || ' = ' || l_event_class_codes.credit_memos);
653: psa_utils.debug_other_string(g_state_level,l_api_name,'Prepayments' || ' = ' || l_event_class_codes.prepayments);

Line 650: psa_utils.debug_other_string(g_state_level,l_api_name,'Invoices' || ' = ' || l_event_class_codes.invoices);

646: FETCH get_event_class_codes into l_event_class_codes;
647: CLOSE get_event_class_codes;
648:
649: psa_utils.debug_other_string(g_state_level,l_api_name,'Event Class Codes:');
650: psa_utils.debug_other_string(g_state_level,l_api_name,'Invoices' || ' = ' || l_event_class_codes.invoices);
651: psa_utils.debug_other_string(g_state_level,l_api_name,'Debit Memos' || ' = ' || l_event_class_codes.debit_memos);
652: psa_utils.debug_other_string(g_state_level,l_api_name,'Credit Memos' || ' = ' || l_event_class_codes.credit_memos);
653: psa_utils.debug_other_string(g_state_level,l_api_name,'Prepayments' || ' = ' || l_event_class_codes.prepayments);
654: psa_utils.debug_other_string(g_state_level,l_api_name,'Prepay Apps' || ' = ' || l_event_class_codes.prepayment_apps);

Line 651: psa_utils.debug_other_string(g_state_level,l_api_name,'Debit Memos' || ' = ' || l_event_class_codes.debit_memos);

647: CLOSE get_event_class_codes;
648:
649: psa_utils.debug_other_string(g_state_level,l_api_name,'Event Class Codes:');
650: psa_utils.debug_other_string(g_state_level,l_api_name,'Invoices' || ' = ' || l_event_class_codes.invoices);
651: psa_utils.debug_other_string(g_state_level,l_api_name,'Debit Memos' || ' = ' || l_event_class_codes.debit_memos);
652: psa_utils.debug_other_string(g_state_level,l_api_name,'Credit Memos' || ' = ' || l_event_class_codes.credit_memos);
653: psa_utils.debug_other_string(g_state_level,l_api_name,'Prepayments' || ' = ' || l_event_class_codes.prepayments);
654: psa_utils.debug_other_string(g_state_level,l_api_name,'Prepay Apps' || ' = ' || l_event_class_codes.prepayment_apps);
655: psa_utils.debug_other_string(g_state_level,l_api_name,'PO_PA' || ' = ' || l_event_class_codes.po_pa);

Line 652: psa_utils.debug_other_string(g_state_level,l_api_name,'Credit Memos' || ' = ' || l_event_class_codes.credit_memos);

648:
649: psa_utils.debug_other_string(g_state_level,l_api_name,'Event Class Codes:');
650: psa_utils.debug_other_string(g_state_level,l_api_name,'Invoices' || ' = ' || l_event_class_codes.invoices);
651: psa_utils.debug_other_string(g_state_level,l_api_name,'Debit Memos' || ' = ' || l_event_class_codes.debit_memos);
652: psa_utils.debug_other_string(g_state_level,l_api_name,'Credit Memos' || ' = ' || l_event_class_codes.credit_memos);
653: psa_utils.debug_other_string(g_state_level,l_api_name,'Prepayments' || ' = ' || l_event_class_codes.prepayments);
654: psa_utils.debug_other_string(g_state_level,l_api_name,'Prepay Apps' || ' = ' || l_event_class_codes.prepayment_apps);
655: psa_utils.debug_other_string(g_state_level,l_api_name,'PO_PA' || ' = ' || l_event_class_codes.po_pa);
656: psa_utils.debug_other_string(g_state_level,l_api_name,'Requisition' || ' = ' || l_event_class_codes.req);

Line 653: psa_utils.debug_other_string(g_state_level,l_api_name,'Prepayments' || ' = ' || l_event_class_codes.prepayments);

649: psa_utils.debug_other_string(g_state_level,l_api_name,'Event Class Codes:');
650: psa_utils.debug_other_string(g_state_level,l_api_name,'Invoices' || ' = ' || l_event_class_codes.invoices);
651: psa_utils.debug_other_string(g_state_level,l_api_name,'Debit Memos' || ' = ' || l_event_class_codes.debit_memos);
652: psa_utils.debug_other_string(g_state_level,l_api_name,'Credit Memos' || ' = ' || l_event_class_codes.credit_memos);
653: psa_utils.debug_other_string(g_state_level,l_api_name,'Prepayments' || ' = ' || l_event_class_codes.prepayments);
654: psa_utils.debug_other_string(g_state_level,l_api_name,'Prepay Apps' || ' = ' || l_event_class_codes.prepayment_apps);
655: psa_utils.debug_other_string(g_state_level,l_api_name,'PO_PA' || ' = ' || l_event_class_codes.po_pa);
656: psa_utils.debug_other_string(g_state_level,l_api_name,'Requisition' || ' = ' || l_event_class_codes.req);
657: psa_utils.debug_other_string(g_state_level,l_api_name,'Release' || ' = ' || l_event_class_codes.release);

Line 654: psa_utils.debug_other_string(g_state_level,l_api_name,'Prepay Apps' || ' = ' || l_event_class_codes.prepayment_apps);

650: psa_utils.debug_other_string(g_state_level,l_api_name,'Invoices' || ' = ' || l_event_class_codes.invoices);
651: psa_utils.debug_other_string(g_state_level,l_api_name,'Debit Memos' || ' = ' || l_event_class_codes.debit_memos);
652: psa_utils.debug_other_string(g_state_level,l_api_name,'Credit Memos' || ' = ' || l_event_class_codes.credit_memos);
653: psa_utils.debug_other_string(g_state_level,l_api_name,'Prepayments' || ' = ' || l_event_class_codes.prepayments);
654: psa_utils.debug_other_string(g_state_level,l_api_name,'Prepay Apps' || ' = ' || l_event_class_codes.prepayment_apps);
655: psa_utils.debug_other_string(g_state_level,l_api_name,'PO_PA' || ' = ' || l_event_class_codes.po_pa);
656: psa_utils.debug_other_string(g_state_level,l_api_name,'Requisition' || ' = ' || l_event_class_codes.req);
657: psa_utils.debug_other_string(g_state_level,l_api_name,'Release' || ' = ' || l_event_class_codes.release);
658: END IF;

Line 655: psa_utils.debug_other_string(g_state_level,l_api_name,'PO_PA' || ' = ' || l_event_class_codes.po_pa);

651: psa_utils.debug_other_string(g_state_level,l_api_name,'Debit Memos' || ' = ' || l_event_class_codes.debit_memos);
652: psa_utils.debug_other_string(g_state_level,l_api_name,'Credit Memos' || ' = ' || l_event_class_codes.credit_memos);
653: psa_utils.debug_other_string(g_state_level,l_api_name,'Prepayments' || ' = ' || l_event_class_codes.prepayments);
654: psa_utils.debug_other_string(g_state_level,l_api_name,'Prepay Apps' || ' = ' || l_event_class_codes.prepayment_apps);
655: psa_utils.debug_other_string(g_state_level,l_api_name,'PO_PA' || ' = ' || l_event_class_codes.po_pa);
656: psa_utils.debug_other_string(g_state_level,l_api_name,'Requisition' || ' = ' || l_event_class_codes.req);
657: psa_utils.debug_other_string(g_state_level,l_api_name,'Release' || ' = ' || l_event_class_codes.release);
658: END IF;
659:

Line 656: psa_utils.debug_other_string(g_state_level,l_api_name,'Requisition' || ' = ' || l_event_class_codes.req);

652: psa_utils.debug_other_string(g_state_level,l_api_name,'Credit Memos' || ' = ' || l_event_class_codes.credit_memos);
653: psa_utils.debug_other_string(g_state_level,l_api_name,'Prepayments' || ' = ' || l_event_class_codes.prepayments);
654: psa_utils.debug_other_string(g_state_level,l_api_name,'Prepay Apps' || ' = ' || l_event_class_codes.prepayment_apps);
655: psa_utils.debug_other_string(g_state_level,l_api_name,'PO_PA' || ' = ' || l_event_class_codes.po_pa);
656: psa_utils.debug_other_string(g_state_level,l_api_name,'Requisition' || ' = ' || l_event_class_codes.req);
657: psa_utils.debug_other_string(g_state_level,l_api_name,'Release' || ' = ' || l_event_class_codes.release);
658: END IF;
659:
660: -- Has the product uptaken SLA?

Line 657: psa_utils.debug_other_string(g_state_level,l_api_name,'Release' || ' = ' || l_event_class_codes.release);

653: psa_utils.debug_other_string(g_state_level,l_api_name,'Prepayments' || ' = ' || l_event_class_codes.prepayments);
654: psa_utils.debug_other_string(g_state_level,l_api_name,'Prepay Apps' || ' = ' || l_event_class_codes.prepayment_apps);
655: psa_utils.debug_other_string(g_state_level,l_api_name,'PO_PA' || ' = ' || l_event_class_codes.po_pa);
656: psa_utils.debug_other_string(g_state_level,l_api_name,'Requisition' || ' = ' || l_event_class_codes.req);
657: psa_utils.debug_other_string(g_state_level,l_api_name,'Release' || ' = ' || l_event_class_codes.release);
658: END IF;
659:
660: -- Has the product uptaken SLA?
661: IF p_para_rec.application_id IN (101, 8401) THEN

Line 667: psa_utils.debug_other_string(g_state_level,l_api_name,'Product Uptaken SLA: '||l_sla_uptake_prod);

663: ELSE
664: l_sla_uptake_prod := 'Y';
665: END IF;
666:
667: psa_utils.debug_other_string(g_state_level,l_api_name,'Product Uptaken SLA: '||l_sla_uptake_prod);
668:
669: -- Initialize API return status to success
670: x_return_status := FND_API.G_RET_STS_SUCCESS;
671:

Line 673: psa_utils.debug_other_string(g_state_level,l_api_name,'Begin SQL Query String');

669: -- Initialize API return status to success
670: x_return_status := FND_API.G_RET_STS_SUCCESS;
671:
672: -- Build query string for all products
673: psa_utils.debug_other_string(g_state_level,l_api_name,'Begin SQL Query String');
674: psa_utils.debug_other_string(g_state_level,l_api_name,'x_return_status: ' || x_return_status);
675: psa_utils.debug_other_string(g_state_level,l_api_name,'Source' || ' = ' || x_source);
676:
677:

Line 674: psa_utils.debug_other_string(g_state_level,l_api_name,'x_return_status: ' || x_return_status);

670: x_return_status := FND_API.G_RET_STS_SUCCESS;
671:
672: -- Build query string for all products
673: psa_utils.debug_other_string(g_state_level,l_api_name,'Begin SQL Query String');
674: psa_utils.debug_other_string(g_state_level,l_api_name,'x_return_status: ' || x_return_status);
675: psa_utils.debug_other_string(g_state_level,l_api_name,'Source' || ' = ' || x_source);
676:
677:
678: IF (NOT FND_FLEX_APIS.GET_QUALIFIER_SEGNUM(APPL_ID => 101,

Line 675: psa_utils.debug_other_string(g_state_level,l_api_name,'Source' || ' = ' || x_source);

671:
672: -- Build query string for all products
673: psa_utils.debug_other_string(g_state_level,l_api_name,'Begin SQL Query String');
674: psa_utils.debug_other_string(g_state_level,l_api_name,'x_return_status: ' || x_return_status);
675: psa_utils.debug_other_string(g_state_level,l_api_name,'Source' || ' = ' || x_source);
676:
677:
678: IF (NOT FND_FLEX_APIS.GET_QUALIFIER_SEGNUM(APPL_ID => 101,
679: KEY_FLEX_CODE => 'GL#',

Line 814: psa_utils.debug_other_string(g_state_level,l_api_name,'GL Query returned '||sql%rowcount||' rows.');

810: )
811: OR
812: ((x_source = 'CP') AND (PBRV.period_num BETWEEN l_period_start_num AND l_period_end_num)));
813:
814: psa_utils.debug_other_string(g_state_level,l_api_name,'GL Query returned '||sql%rowcount||' rows.');
815:
816: populate_tab;
817:
818: psa_utils.debug_other_string(g_state_level,l_api_name,'Populate_Tab Executed');

Line 818: psa_utils.debug_other_string(g_state_level,l_api_name,'Populate_Tab Executed');

814: psa_utils.debug_other_string(g_state_level,l_api_name,'GL Query returned '||sql%rowcount||' rows.');
815:
816: populate_tab;
817:
818: psa_utils.debug_other_string(g_state_level,l_api_name,'Populate_Tab Executed');
819:
820: -- Process for AP
821: ELSIF p_para_rec.application_id = 200 THEN
822:

Line 983: psa_utils.debug_other_string(g_state_level,l_api_name,'AP Query 1 returned '||sql%rowcount||' rows.');

979: OR
980: ((x_source = 'CP') AND (PBRV.period_num BETWEEN l_period_start_num AND l_period_end_num)));
981:
982:
983: psa_utils.debug_other_string(g_state_level,l_api_name,'AP Query 1 returned '||sql%rowcount||' rows.');
984:
985: populate_tab;
986:
987: psa_utils.debug_other_string(g_state_level,l_api_name,'Populate_Tab Executed');

Line 987: psa_utils.debug_other_string(g_state_level,l_api_name,'Populate_Tab Executed');

983: psa_utils.debug_other_string(g_state_level,l_api_name,'AP Query 1 returned '||sql%rowcount||' rows.');
984:
985: populate_tab;
986:
987: psa_utils.debug_other_string(g_state_level,l_api_name,'Populate_Tab Executed');
988: END IF;
989:
990: IF (l_event_class_codes.prepayment_apps = 1) OR (x_source = 'CP') THEN
991:

Line 1145: psa_utils.debug_other_string(g_state_level,l_api_name,'AP Query 2 returned '||sql%rowcount||' rows.');

1141: )
1142: OR
1143: ((x_source = 'CP') AND (PBRV.period_num BETWEEN l_period_start_num AND l_period_end_num)));
1144:
1145: psa_utils.debug_other_string(g_state_level,l_api_name,'AP Query 2 returned '||sql%rowcount||' rows.');
1146:
1147: populate_tab;
1148:
1149: psa_utils.debug_other_string(g_state_level,l_api_name,'Populate_Tab Executed');

Line 1149: psa_utils.debug_other_string(g_state_level,l_api_name,'Populate_Tab Executed');

1145: psa_utils.debug_other_string(g_state_level,l_api_name,'AP Query 2 returned '||sql%rowcount||' rows.');
1146:
1147: populate_tab;
1148:
1149: psa_utils.debug_other_string(g_state_level,l_api_name,'Populate_Tab Executed');
1150: END IF;
1151:
1152: -- Process for PO
1153: ELSIF p_para_rec.application_id = 201 THEN

Line 1319: psa_utils.debug_other_string(g_state_level,l_api_name,'PO Query 1 returned '||sql%rowcount||' rows.');

1315: )
1316: OR
1317: ((x_source = 'CP') AND (PBRV.period_num BETWEEN l_period_start_num AND l_period_end_num)));
1318:
1319: psa_utils.debug_other_string(g_state_level,l_api_name,'PO Query 1 returned '||sql%rowcount||' rows.');
1320:
1321: populate_tab;
1322:
1323: psa_utils.debug_other_string(g_state_level,l_api_name,'Populate_Tab Executed');

Line 1323: psa_utils.debug_other_string(g_state_level,l_api_name,'Populate_Tab Executed');

1319: psa_utils.debug_other_string(g_state_level,l_api_name,'PO Query 1 returned '||sql%rowcount||' rows.');
1320:
1321: populate_tab;
1322:
1323: psa_utils.debug_other_string(g_state_level,l_api_name,'Populate_Tab Executed');
1324: END IF;
1325:
1326: IF (l_event_class_codes.po_pa = 1) OR (l_event_class_codes.req = 1) OR (x_source = 'CP') THEN
1327:

Line 1480: psa_utils.debug_other_string(g_state_level,l_api_name,'PO Query 2 returned '||sql%rowcount||' rows.');

1476: )
1477: OR
1478: ((x_source = 'CP') AND (PBRV.period_num BETWEEN l_period_start_num AND l_period_end_num)));
1479:
1480: psa_utils.debug_other_string(g_state_level,l_api_name,'PO Query 2 returned '||sql%rowcount||' rows.');
1481:
1482: populate_tab;
1483:
1484: psa_utils.debug_other_string(g_state_level,l_api_name,'Populate_Tab Executed');

Line 1484: psa_utils.debug_other_string(g_state_level,l_api_name,'Populate_Tab Executed');

1480: psa_utils.debug_other_string(g_state_level,l_api_name,'PO Query 2 returned '||sql%rowcount||' rows.');
1481:
1482: populate_tab;
1483:
1484: psa_utils.debug_other_string(g_state_level,l_api_name,'Populate_Tab Executed');
1485: END IF;
1486:
1487: IF (l_event_class_codes.release = 1) OR (x_source = 'CP') THEN
1488:

Line 1658: psa_utils.debug_other_string(g_state_level,l_api_name,'PO Query 3 returned '||sql%rowcount||' rows.');

1654: OR
1655: ((x_source = 'CP') AND (PBRV.period_num BETWEEN l_period_start_num AND l_period_end_num)));
1656:
1657:
1658: psa_utils.debug_other_string(g_state_level,l_api_name,'PO Query 3 returned '||sql%rowcount||' rows.');
1659:
1660: populate_tab;
1661:
1662: psa_utils.debug_other_string(g_state_level,l_api_name,'Populate_Tab Executed');

Line 1662: psa_utils.debug_other_string(g_state_level,l_api_name,'Populate_Tab Executed');

1658: psa_utils.debug_other_string(g_state_level,l_api_name,'PO Query 3 returned '||sql%rowcount||' rows.');
1659:
1660: populate_tab;
1661:
1662: psa_utils.debug_other_string(g_state_level,l_api_name,'Populate_Tab Executed');
1663: END IF;
1664:
1665: -- Following query has been added as requested by PO Team in Bug 5253878
1666:

Line 1784: psa_utils.debug_other_string(g_state_level,l_api_name,'PO Query 4 returned '||sql%rowcount||' rows.');

1780: FROM po_online_report_text
1781: WHERE online_report_id = PO_DOCUMENT_FUNDS_GRP.get_online_report_id
1782: AND nvl(show_in_psa_flag, 'N') = 'Y';
1783:
1784: psa_utils.debug_other_string(g_state_level,l_api_name,'PO Query 4 returned '||sql%rowcount||' rows.');
1785:
1786: populate_tab;
1787:
1788: psa_utils.debug_other_string(g_state_level,l_api_name,'Populate_Tab Executed');

Line 1788: psa_utils.debug_other_string(g_state_level,l_api_name,'Populate_Tab Executed');

1784: psa_utils.debug_other_string(g_state_level,l_api_name,'PO Query 4 returned '||sql%rowcount||' rows.');
1785:
1786: populate_tab;
1787:
1788: psa_utils.debug_other_string(g_state_level,l_api_name,'Populate_Tab Executed');
1789:
1790: -- Process for FV
1791: ELSIF p_para_rec.application_id = 8901 THEN
1792:

Line 1940: psa_utils.debug_other_string(g_state_level,l_api_name,'FV Query returned '||sql%rowcount||' rows.');

1936: )
1937: OR
1938: ((x_source = 'CP') AND (PBRV.period_num BETWEEN l_period_start_num AND l_period_end_num)));
1939:
1940: psa_utils.debug_other_string(g_state_level,l_api_name,'FV Query returned '||sql%rowcount||' rows.');
1941:
1942: populate_tab;
1943:
1944: psa_utils.debug_other_string(g_state_level,l_api_name,'Populate_Tab Executed');

Line 1944: psa_utils.debug_other_string(g_state_level,l_api_name,'Populate_Tab Executed');

1940: psa_utils.debug_other_string(g_state_level,l_api_name,'FV Query returned '||sql%rowcount||' rows.');
1941:
1942: populate_tab;
1943:
1944: psa_utils.debug_other_string(g_state_level,l_api_name,'Populate_Tab Executed');
1945:
1946: -- Process for PSB
1947: ELSIF (p_para_rec.application_id = 8401) THEN
1948:

Line 2069: psa_utils.debug_other_string(g_state_level,l_api_name,'PSB Query returned '||sql%rowcount||' rows.');

2065: )
2066: OR
2067: ((x_source = 'CP') AND (PBRV.period_num BETWEEN l_period_start_num AND l_period_end_num)));
2068:
2069: psa_utils.debug_other_string(g_state_level,l_api_name,'PSB Query returned '||sql%rowcount||' rows.');
2070:
2071: populate_tab;
2072:
2073: psa_utils.debug_other_string(g_state_level,l_api_name,'Populate_Tab Executed');

Line 2073: psa_utils.debug_other_string(g_state_level,l_api_name,'Populate_Tab Executed');

2069: psa_utils.debug_other_string(g_state_level,l_api_name,'PSB Query returned '||sql%rowcount||' rows.');
2070:
2071: populate_tab;
2072:
2073: psa_utils.debug_other_string(g_state_level,l_api_name,'Populate_Tab Executed');
2074:
2075: -- For all other products
2076: ELSE
2077: SELECT PBRV.APPLICATION_ID,

Line 2210: psa_utils.debug_other_string(g_state_level,l_api_name,'Other Query returned '||sql%rowcount||' rows.');

2206: )
2207: OR
2208: ((x_source = 'CP') AND (PBRV.period_num BETWEEN l_period_start_num AND l_period_end_num)));
2209:
2210: psa_utils.debug_other_string(g_state_level,l_api_name,'Other Query returned '||sql%rowcount||' rows.');
2211:
2212: populate_tab;
2213:
2214: psa_utils.debug_other_string(g_state_level,l_api_name,'Populate_Tab Executed');

Line 2214: psa_utils.debug_other_string(g_state_level,l_api_name,'Populate_Tab Executed');

2210: psa_utils.debug_other_string(g_state_level,l_api_name,'Other Query returned '||sql%rowcount||' rows.');
2211:
2212: populate_tab;
2213:
2214: psa_utils.debug_other_string(g_state_level,l_api_name,'Populate_Tab Executed');
2215: END IF;
2216:
2217: -- If product has uptaken SLA then insert errors from PSA_BC_ACCOUNTING_ERRORS
2218: -- in the plsql table which will be inserted in psa_bc_results_rpt_gt

Line 2223: psa_utils.debug_other_string(g_state_level,l_api_name,'SLA Accounting Errors Query returned '||sql%rowcount||' rows.');

2219:
2220: IF l_sla_uptake_prod = 'Y' AND p_para_rec.packet_event_flag = 'E' THEN
2221: OPEN c_xla_accounting_errors;
2222: FETCH c_xla_accounting_errors BULK COLLECT INTO l_dump;
2223: psa_utils.debug_other_string(g_state_level,l_api_name,'SLA Accounting Errors Query returned '||sql%rowcount||' rows.');
2224: populate_tab;
2225: CLOSE c_xla_accounting_errors;
2226: END IF;
2227:

Line 2240: psa_utils.debug_other_string(g_state_level,l_api_name,'l_event_id = ' || l_event_id);

2236: where packet_id in (select packet_id from psa_bc_report_events_gt)
2237: and template_id is NULL
2238: and rownum = 1;
2239: END IF;
2240: psa_utils.debug_other_string(g_state_level,l_api_name,'l_event_id = ' || l_event_id);
2241: END IF;
2242:
2243: IF l_sla_uptake_prod = 'Y' THEN
2244: IF l_event_id = -1 THEN

Line 2360: psa_utils.debug_other_string(g_state_level,l_api_name,'XLA Manual journals Query1 returned '||sql%rowcount||' rows.');

2356: FROM PSA_BC_REPORT_V PBRV
2357: WHERE PBRV.packet_id IN (SELECT packet_id FROM PSA_BC_REPORT_EVENTS_GT)
2358: and template_id is NULL;
2359:
2360: psa_utils.debug_other_string(g_state_level,l_api_name,'XLA Manual journals Query1 returned '||sql%rowcount||' rows.');
2361:
2362: populate_tab;
2363:
2364: psa_utils.debug_other_string(g_state_level,l_api_name,'Populate_Tab Executed');

Line 2364: psa_utils.debug_other_string(g_state_level,l_api_name,'Populate_Tab Executed');

2360: psa_utils.debug_other_string(g_state_level,l_api_name,'XLA Manual journals Query1 returned '||sql%rowcount||' rows.');
2361:
2362: populate_tab;
2363:
2364: psa_utils.debug_other_string(g_state_level,l_api_name,'Populate_Tab Executed');
2365:
2366: ELSE
2367: SELECT PBRV.APPLICATION_ID,
2368: PBRV.APPLICATION_SHORT_NAME,

Line 2496: psa_utils.debug_other_string(g_state_level,l_api_name,'XLA Manual journals Query2 returned '||sql%rowcount||' rows.');

2492: )
2493: OR
2494: ((x_source = 'CP') AND (PBRV.period_num BETWEEN l_period_start_num AND l_period_end_num)));
2495:
2496: psa_utils.debug_other_string(g_state_level,l_api_name,'XLA Manual journals Query2 returned '||sql%rowcount||' rows.');
2497:
2498: populate_tab;
2499:
2500: psa_utils.debug_other_string(g_state_level,l_api_name,'Populate_Tab Executed');

Line 2500: psa_utils.debug_other_string(g_state_level,l_api_name,'Populate_Tab Executed');

2496: psa_utils.debug_other_string(g_state_level,l_api_name,'XLA Manual journals Query2 returned '||sql%rowcount||' rows.');
2497:
2498: populate_tab;
2499:
2500: psa_utils.debug_other_string(g_state_level,l_api_name,'Populate_Tab Executed');
2501:
2502: END IF; -- if l_event_id = -1
2503: END IF;
2504:

Line 2518: psa_utils.debug_other_string(g_state_level,l_api_name,'Deleting unwanted rows from PSA_BC_RESULTS_GT to retain the latest Budgetary Control Transaction only');

2514: VALUES l_bc_results_rpt(i);
2515:
2516: --delete
2517: IF x_source = 'CP' THEN
2518: psa_utils.debug_other_string(g_state_level,l_api_name,'Deleting unwanted rows from PSA_BC_RESULTS_GT to retain the latest Budgetary Control Transaction only');
2519:
2520: DELETE PSA_BC_RESULTS_GT GT1
2521: WHERE (GT1.batch_reference, GT1.document_reference , GT1.line_reference, GT1.packet_id) NOT IN
2522: (SELECT GT2.batch_reference, GT2.document_reference, GT2.line_reference, max(GT2.packet_id)

Line 2525: psa_utils.debug_other_string(g_state_level,l_api_name,'Deleted '||sql%rowcount||' rows from psa_bc_results_gt.');

2521: WHERE (GT1.batch_reference, GT1.document_reference , GT1.line_reference, GT1.packet_id) NOT IN
2522: (SELECT GT2.batch_reference, GT2.document_reference, GT2.line_reference, max(GT2.packet_id)
2523: FROM PSA_BC_RESULTS_GT GT2
2524: GROUP BY GT2.batch_reference, GT2.document_reference, GT2.line_reference);
2525: psa_utils.debug_other_string(g_state_level,l_api_name,'Deleted '||sql%rowcount||' rows from psa_bc_results_gt.');
2526: END IF;
2527:
2528:
2529: IF p_para_rec.application_id IN (200, 201, 8901, 101) THEN

Line 2533: psa_utils.debug_other_string(g_state_level,l_api_name,'l_summary_used' || ' = ' || l_summary_used);

2529: IF p_para_rec.application_id IN (200, 201, 8901, 101) THEN
2530: OPEN c_is_summary_used;
2531: FETCH c_is_summary_used INTO l_summary_used;
2532: CLOSE c_is_summary_used;
2533: psa_utils.debug_other_string(g_state_level,l_api_name,'l_summary_used' || ' = ' || l_summary_used);
2534: END IF;
2535:
2536: -- Insert Summary Records seperately if product is AP, PO, FV
2537: -- Since the queries for these products have joins with respective

Line 2699: psa_utils.debug_other_string(g_state_level,l_api_name,'Summary Query returned '||sql%rowcount||' rows.');

2695: VALUES l_bc_summary_rpt(i);
2696:
2697: END IF;
2698:
2699: psa_utils.debug_other_string(g_state_level,l_api_name,'Summary Query returned '||sql%rowcount||' rows.');
2700:
2701: -- Bug 5512107 : Section added to compute overall document budgetary status
2702:
2703: for x in c_document_status

Line 2794: psa_utils.debug_other_string(g_state_level,l_api_name,'Before Dynamic WHERE clause');

2790: x_report_query := 'SELECT PBRG.* FROM psa_bc_results_gt PBRG, GL_CODE_COMBINATIONS GLCC
2791: WHERE PBRG.ccid = GLCC.code_combination_id(+) ';
2792:
2793: -- Dynamic WHERE clause
2794: psa_utils.debug_other_string(g_state_level,l_api_name,'Before Dynamic WHERE clause');
2795: psa_utils.debug_other_string(g_state_level,l_api_name,'x_return_status: ' || x_return_status);
2796:
2797: IF x_source = 'CP' THEN
2798:

Line 2795: psa_utils.debug_other_string(g_state_level,l_api_name,'x_return_status: ' || x_return_status);

2791: WHERE PBRG.ccid = GLCC.code_combination_id(+) ';
2792:
2793: -- Dynamic WHERE clause
2794: psa_utils.debug_other_string(g_state_level,l_api_name,'Before Dynamic WHERE clause');
2795: psa_utils.debug_other_string(g_state_level,l_api_name,'x_return_status: ' || x_return_status);
2796:
2797: IF x_source = 'CP' THEN
2798:
2799: IF p_para_rec.BC_funds_check_status = 'P' THEN

Line 2837: psa_utils.debug_other_string(g_state_level,l_api_name,'CCID Segment Delimiter: ' || l_delimiter);

2833: END LOOP;
2834:
2835: SELECT FND_FLEX_APIS.get_segment_delimiter(101, 'GL#', p_para_rec.chart_of_accts_id) INTO l_delimiter
2836: FROM DUAL;
2837: psa_utils.debug_other_string(g_state_level,l_api_name,'CCID Segment Delimiter: ' || l_delimiter);
2838:
2839: -- select ccid low segments
2840: l_length := LENGTH(p_para_rec.ccid_low);
2841: l_compt := 1;

Line 2885: psa_utils.debug_other_string(g_state_level,l_api_name,' After Dynamic WHERE clause');

2881:
2882: END IF;
2883:
2884:
2885: psa_utils.debug_other_string(g_state_level,l_api_name,' After Dynamic WHERE clause');
2886: psa_utils.debug_other_string(g_state_level,l_api_name,' ' || x_return_status);
2887:
2888: -- Dynamic ORDER BY clause
2889: psa_utils.debug_other_string(g_state_level,l_api_name,' Before Dynamic ORDER BY clause');

Line 2886: psa_utils.debug_other_string(g_state_level,l_api_name,' ' || x_return_status);

2882: END IF;
2883:
2884:
2885: psa_utils.debug_other_string(g_state_level,l_api_name,' After Dynamic WHERE clause');
2886: psa_utils.debug_other_string(g_state_level,l_api_name,' ' || x_return_status);
2887:
2888: -- Dynamic ORDER BY clause
2889: psa_utils.debug_other_string(g_state_level,l_api_name,' Before Dynamic ORDER BY clause');
2890: psa_utils.debug_other_string(g_state_level,l_api_name,' '|| x_return_status);

Line 2889: psa_utils.debug_other_string(g_state_level,l_api_name,' Before Dynamic ORDER BY clause');

2885: psa_utils.debug_other_string(g_state_level,l_api_name,' After Dynamic WHERE clause');
2886: psa_utils.debug_other_string(g_state_level,l_api_name,' ' || x_return_status);
2887:
2888: -- Dynamic ORDER BY clause
2889: psa_utils.debug_other_string(g_state_level,l_api_name,' Before Dynamic ORDER BY clause');
2890: psa_utils.debug_other_string(g_state_level,l_api_name,' '|| x_return_status);
2891:
2892: IF p_para_rec.bc_funds_check_order_by is null or p_para_rec.bc_funds_check_order_by = 'A' THEN
2893: x_report_query := x_report_query||' ORDER BY PBRG.accounting_flexfield';

Line 2890: psa_utils.debug_other_string(g_state_level,l_api_name,' '|| x_return_status);

2886: psa_utils.debug_other_string(g_state_level,l_api_name,' ' || x_return_status);
2887:
2888: -- Dynamic ORDER BY clause
2889: psa_utils.debug_other_string(g_state_level,l_api_name,' Before Dynamic ORDER BY clause');
2890: psa_utils.debug_other_string(g_state_level,l_api_name,' '|| x_return_status);
2891:
2892: IF p_para_rec.bc_funds_check_order_by is null or p_para_rec.bc_funds_check_order_by = 'A' THEN
2893: x_report_query := x_report_query||' ORDER BY PBRG.accounting_flexfield';
2894: END IF;

Line 2919: psa_utils.debug_other_string(g_state_level,l_api_name,'x_report_query = ' || x_report_query);

2915: -- Adding ORDER BY clause
2916: x_report_query := x_report_query||' ORDER BY PBRG.ACCOUNTING_FLEXFIELD';
2917: END IF; -- End IF x_source='FORM'
2918:
2919: psa_utils.debug_other_string(g_state_level,l_api_name,'x_report_query = ' || x_report_query);
2920: psa_utils.debug_other_string(g_state_level,l_api_name,'end of procedure build_report_query');
2921:
2922: EXCEPTION
2923: WHEN OTHERS THEN

Line 2920: psa_utils.debug_other_string(g_state_level,l_api_name,'end of procedure build_report_query');

2916: x_report_query := x_report_query||' ORDER BY PBRG.ACCOUNTING_FLEXFIELD';
2917: END IF; -- End IF x_source='FORM'
2918:
2919: psa_utils.debug_other_string(g_state_level,l_api_name,'x_report_query = ' || x_report_query);
2920: psa_utils.debug_other_string(g_state_level,l_api_name,'end of procedure build_report_query');
2921:
2922: EXCEPTION
2923: WHEN OTHERS THEN
2924: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2925: psa_utils.debug_other_string(g_excep_level,l_api_name,'EXCEPTION: ' || SQLERRM(sqlcode));

2921:
2922: EXCEPTION
2923: WHEN OTHERS THEN
2924: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2925: psa_utils.debug_other_string(g_excep_level,l_api_name,'EXCEPTION: ' || SQLERRM(sqlcode));
2926: RAISE;
2927: psa_utils.debug_other_string(g_excep_level,l_api_name,' ' || x_return_status);
2928: psa_utils.debug_other_string(g_excep_level,l_api_name,'x_report_query' || ' = ' ||x_report_query);
2929:

Line 2927: psa_utils.debug_other_string(g_excep_level,l_api_name,' ' || x_return_status);

2923: WHEN OTHERS THEN
2924: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2925: psa_utils.debug_other_string(g_excep_level,l_api_name,'EXCEPTION: ' || SQLERRM(sqlcode));
2926: RAISE;
2927: psa_utils.debug_other_string(g_excep_level,l_api_name,' ' || x_return_status);
2928: psa_utils.debug_other_string(g_excep_level,l_api_name,'x_report_query' || ' = ' ||x_report_query);
2929:
2930: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2931: psa_utils.debug_other_string(g_error_level,l_api_name,' ' || x_return_status);

Line 2928: psa_utils.debug_other_string(g_excep_level,l_api_name,'x_report_query' || ' = ' ||x_report_query);

2924: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2925: psa_utils.debug_other_string(g_excep_level,l_api_name,'EXCEPTION: ' || SQLERRM(sqlcode));
2926: RAISE;
2927: psa_utils.debug_other_string(g_excep_level,l_api_name,' ' || x_return_status);
2928: psa_utils.debug_other_string(g_excep_level,l_api_name,'x_report_query' || ' = ' ||x_report_query);
2929:
2930: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2931: psa_utils.debug_other_string(g_error_level,l_api_name,' ' || x_return_status);
2932: psa_utils.debug_other_string(g_error_level,l_api_name,' ERROR IN QUERY STRING');

Line 2931: psa_utils.debug_other_string(g_error_level,l_api_name,' ' || x_return_status);

2927: psa_utils.debug_other_string(g_excep_level,l_api_name,' ' || x_return_status);
2928: psa_utils.debug_other_string(g_excep_level,l_api_name,'x_report_query' || ' = ' ||x_report_query);
2929:
2930: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2931: psa_utils.debug_other_string(g_error_level,l_api_name,' ' || x_return_status);
2932: psa_utils.debug_other_string(g_error_level,l_api_name,' ERROR IN QUERY STRING');
2933: RAISE FND_API.G_EXC_ERROR;
2934:
2935: ELSE

Line 2932: psa_utils.debug_other_string(g_error_level,l_api_name,' ERROR IN QUERY STRING');

2928: psa_utils.debug_other_string(g_excep_level,l_api_name,'x_report_query' || ' = ' ||x_report_query);
2929:
2930: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2931: psa_utils.debug_other_string(g_error_level,l_api_name,' ' || x_return_status);
2932: psa_utils.debug_other_string(g_error_level,l_api_name,' ERROR IN QUERY STRING');
2933: RAISE FND_API.G_EXC_ERROR;
2934:
2935: ELSE
2936: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2937: psa_utils.debug_other_string(g_unexp_level,l_api_name,' ' || x_return_status);

2933: RAISE FND_API.G_EXC_ERROR;
2934:
2935: ELSE
2936: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2937: psa_utils.debug_other_string(g_unexp_level,l_api_name,' ' || x_return_status);
2938: psa_utils.debug_other_string(g_unexp_level,l_api_name,'UNEXPECTED ERROR IN QUERY STRING');
2939: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2940: END IF;
2941:

Line 2938: psa_utils.debug_other_string(g_unexp_level,l_api_name,'UNEXPECTED ERROR IN QUERY STRING');

2934:
2935: ELSE
2936: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2937: psa_utils.debug_other_string(g_unexp_level,l_api_name,' ' || x_return_status);
2938: psa_utils.debug_other_string(g_unexp_level,l_api_name,'UNEXPECTED ERROR IN QUERY STRING');
2939: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2940: END IF;
2941:
2942: END build_report_query;

Line 2969: psa_utils.debug_other_string(g_state_level,l_api_name,'BEGIN of procedure get_xml');

2965:
2966:
2967: BEGIN
2968: l_api_name := g_full_path||'get_xml';
2969: psa_utils.debug_other_string(g_state_level,l_api_name,'BEGIN of procedure get_xml');
2970:
2971: -- Initialize API return status to success
2972: x_return_status := FND_API.G_RET_STS_SUCCESS;
2973:

Line 2978: psa_utils.debug_other_string(g_state_level,l_api_name,'l_ctx type fetched successfully');

2974: -- The value below is currently hard coded as a workaround. Hard coding should be removed later.
2975: -- l_char_set := 'UTF-8'; Removed for bug 6445210
2976:
2977: l_ctx := DBMS_XMLQUERY.newcontext(p_query);
2978: psa_utils.debug_other_string(g_state_level,l_api_name,'l_ctx type fetched successfully');
2979:
2980: -- DBMS_XMLQUERY.SetEncodingTag(l_ctx, l_char_set);
2981: -- psa_utils.debug_other_string(g_state_level,l_api_name,'Encoding set to '||l_char_set);
2982:

Line 2981: -- psa_utils.debug_other_string(g_state_level,l_api_name,'Encoding set to '||l_char_set);

2977: l_ctx := DBMS_XMLQUERY.newcontext(p_query);
2978: psa_utils.debug_other_string(g_state_level,l_api_name,'l_ctx type fetched successfully');
2979:
2980: -- DBMS_XMLQUERY.SetEncodingTag(l_ctx, l_char_set);
2981: -- psa_utils.debug_other_string(g_state_level,l_api_name,'Encoding set to '||l_char_set);
2982:
2983: -- change rowset tag
2984: IF p_rowset_tag IS NOT NULL THEN
2985: DBMS_XMLQUERY.setRowSetTag(l_ctx, p_rowset_tag);

Line 2993: psa_utils.debug_other_string(g_state_level,l_api_name,'p_rowset_tag' || ' = ' || p_rowset_tag);

2989: IF p_row_tag IS NOT NULL THEN
2990: DBMS_XMLQUERY.setRowTag(l_ctx, p_row_tag);
2991: END IF;
2992:
2993: psa_utils.debug_other_string(g_state_level,l_api_name,'p_rowset_tag' || ' = ' || p_rowset_tag);
2994: psa_utils.debug_other_string(g_state_level,l_api_name,'p_row_tag' || ' = ' || p_row_tag);
2995:
2996: l_len := length(p_query);
2997: while (l_start <= l_len)

Line 2994: psa_utils.debug_other_string(g_state_level,l_api_name,'p_row_tag' || ' = ' || p_row_tag);

2990: DBMS_XMLQUERY.setRowTag(l_ctx, p_row_tag);
2991: END IF;
2992:
2993: psa_utils.debug_other_string(g_state_level,l_api_name,'p_rowset_tag' || ' = ' || p_rowset_tag);
2994: psa_utils.debug_other_string(g_state_level,l_api_name,'p_row_tag' || ' = ' || p_row_tag);
2995:
2996: l_len := length(p_query);
2997: while (l_start <= l_len)
2998: loop

Line 2999: psa_utils.debug_other_string(g_state_level,l_api_name,'p_query' || ' = ' || substr(p_query,l_start,3500));

2995:
2996: l_len := length(p_query);
2997: while (l_start <= l_len)
2998: loop
2999: psa_utils.debug_other_string(g_state_level,l_api_name,'p_query' || ' = ' || substr(p_query,l_start,3500));
3000: l_start := l_start + 3500;
3001: end loop;
3002:
3003: DBMS_XMLQUERY.UseNullAttributeIndicator(l_ctx, TRUE);

Line 3008: psa_utils.debug_other_string(g_state_level,l_api_name,'end of procedure get_xml');

3004:
3005: x_xml := DBMS_XMLQUERY.getXML(l_ctx);
3006:
3007: DBMS_XMLQUERY.closecontext(l_ctx);
3008: psa_utils.debug_other_string(g_state_level,l_api_name,'end of procedure get_xml');
3009:
3010:
3011: EXCEPTION
3012: WHEN OTHERS THEN

Line 3015: psa_utils.debug_other_string(g_unexp_level,l_api_name,'EXCEPTION: '|| SQLERRM(sqlcode));

3011: EXCEPTION
3012: WHEN OTHERS THEN
3013: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3014: DBMS_XMLGEN.closecontext(l_ctx);
3015: psa_utils.debug_other_string(g_unexp_level,l_api_name,'EXCEPTION: '|| SQLERRM(sqlcode));
3016: RAISE;
3017:
3018: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3019: psa_utils.debug_other_string(g_error_level,l_api_name,' ' || x_return_status);

Line 3019: psa_utils.debug_other_string(g_error_level,l_api_name,' ' || x_return_status);

3015: psa_utils.debug_other_string(g_unexp_level,l_api_name,'EXCEPTION: '|| SQLERRM(sqlcode));
3016: RAISE;
3017:
3018: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3019: psa_utils.debug_other_string(g_error_level,l_api_name,' ' || x_return_status);
3020: psa_utils.debug_other_string(g_error_level,l_api_name,'ERROR IN GET_XML');
3021: RAISE FND_API.G_EXC_ERROR;
3022: ELSE x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3023: psa_utils.debug_other_string(g_unexp_level,l_api_name,' ' || x_return_status);

Line 3020: psa_utils.debug_other_string(g_error_level,l_api_name,'ERROR IN GET_XML');

3016: RAISE;
3017:
3018: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3019: psa_utils.debug_other_string(g_error_level,l_api_name,' ' || x_return_status);
3020: psa_utils.debug_other_string(g_error_level,l_api_name,'ERROR IN GET_XML');
3021: RAISE FND_API.G_EXC_ERROR;
3022: ELSE x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3023: psa_utils.debug_other_string(g_unexp_level,l_api_name,' ' || x_return_status);
3024: psa_utils.debug_other_string(g_unexp_level,l_api_name,' UNEXPECTED ERROR IN GET_XML');

Line 3023: psa_utils.debug_other_string(g_unexp_level,l_api_name,' ' || x_return_status);

3019: psa_utils.debug_other_string(g_error_level,l_api_name,' ' || x_return_status);
3020: psa_utils.debug_other_string(g_error_level,l_api_name,'ERROR IN GET_XML');
3021: RAISE FND_API.G_EXC_ERROR;
3022: ELSE x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3023: psa_utils.debug_other_string(g_unexp_level,l_api_name,' ' || x_return_status);
3024: psa_utils.debug_other_string(g_unexp_level,l_api_name,' UNEXPECTED ERROR IN GET_XML');
3025: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3026: END IF;
3027:

Line 3024: psa_utils.debug_other_string(g_unexp_level,l_api_name,' UNEXPECTED ERROR IN GET_XML');

3020: psa_utils.debug_other_string(g_error_level,l_api_name,'ERROR IN GET_XML');
3021: RAISE FND_API.G_EXC_ERROR;
3022: ELSE x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3023: psa_utils.debug_other_string(g_unexp_level,l_api_name,' ' || x_return_status);
3024: psa_utils.debug_other_string(g_unexp_level,l_api_name,' UNEXPECTED ERROR IN GET_XML');
3025: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3026: END IF;
3027:
3028: END get_xml;

Line 3056: psa_utils.debug_other_string(g_state_level,l_api_name,'BEGIN of procedure construct_bc_report_output');

3052:
3053: BEGIN
3054: l_api_name := g_full_path||'construct_bc_report_output';
3055:
3056: psa_utils.debug_other_string(g_state_level,l_api_name,'BEGIN of procedure construct_bc_report_output');
3057:
3058: -- Initialize API return status to success
3059: x_return_status := FND_API.G_RET_STS_SUCCESS;
3060:

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

3058: -- Initialize API return status to success
3059: x_return_status := FND_API.G_RET_STS_SUCCESS;
3060:
3061: -- Construct the parameter list section
3062: psa_utils.debug_other_string(g_state_level, l_api_name, 'Save the IN parameters in fnd log file');
3063:
3064: BEGIN
3065: -- Construct the output for the paramaters list of report
3066: IF x_source = 'CP' THEN

Line 3124: psa_utils.debug_other_string(g_excep_level,l_api_name,'EXCEPTION: ' || SQLERRM(sqlcode));

3120: '';
3121: END IF;
3122: EXCEPTION
3123: WHEN OTHERS THEN
3124: psa_utils.debug_other_string(g_excep_level,l_api_name,'EXCEPTION: ' || SQLERRM(sqlcode));
3125: END;
3126:
3127:
3128: -- Save the parameter list to output file

Line 3132: psa_utils.debug_other_string(g_state_level,l_api_name,'xml_parameters' || ' = ' || l_para_meaning_list);

3128: -- Save the parameter list to output file
3129:
3130: FND_FILE.put_line(FND_FILE.output, l_para_meaning_list);
3131:
3132: psa_utils.debug_other_string(g_state_level,l_api_name,'xml_parameters' || ' = ' || l_para_meaning_list);
3133:
3134: -- Process the XML data source and save to output file
3135: psa_utils.debug_other_string(g_state_level,l_api_name,'construct both');
3136:

Line 3135: psa_utils.debug_other_string(g_state_level,l_api_name,'construct both');

3131:
3132: psa_utils.debug_other_string(g_state_level,l_api_name,'xml_parameters' || ' = ' || l_para_meaning_list);
3133:
3134: -- Process the XML data source and save to output file
3135: psa_utils.debug_other_string(g_state_level,l_api_name,'construct both');
3136:
3137: IF DBMS_LOB.getlength(p_trxs) IS NULL THEN
3138: psa_utils.debug_other_string(g_state_level,l_api_name,' NO DATA FOUND - No XML Output Generated');
3139: ELSE

Line 3138: psa_utils.debug_other_string(g_state_level,l_api_name,' NO DATA FOUND - No XML Output Generated');

3134: -- Process the XML data source and save to output file
3135: psa_utils.debug_other_string(g_state_level,l_api_name,'construct both');
3136:
3137: IF DBMS_LOB.getlength(p_trxs) IS NULL THEN
3138: psa_utils.debug_other_string(g_state_level,l_api_name,' NO DATA FOUND - No XML Output Generated');
3139: ELSE
3140: -- trim header of trxs
3141: -- save trxs
3142: l_offset := DBMS_LOB.instr (lob_loc => p_trxs,

Line 3146: psa_utils.debug_other_string(g_state_level,l_api_name,'l_offset' || ' = ' || l_offset);

3142: l_offset := DBMS_LOB.instr (lob_loc => p_trxs,
3143: pattern => '?>',
3144: offset => 1,
3145: nth => 1);
3146: psa_utils.debug_other_string(g_state_level,l_api_name,'l_offset' || ' = ' || l_offset);
3147: -- Call to save_xml -
3148: psa_utils.debug_other_string(g_state_level,l_api_name,'Call to save_xml procedure');
3149:
3150: save_xml(x_return_status => x_return_status,

Line 3148: psa_utils.debug_other_string(g_state_level,l_api_name,'Call to save_xml procedure');

3144: offset => 1,
3145: nth => 1);
3146: psa_utils.debug_other_string(g_state_level,l_api_name,'l_offset' || ' = ' || l_offset);
3147: -- Call to save_xml -
3148: psa_utils.debug_other_string(g_state_level,l_api_name,'Call to save_xml procedure');
3149:
3150: save_xml(x_return_status => x_return_status,
3151: x_source => x_source,
3152: p_application_id => p_para_rec.application_id,

Line 3164: psa_utils.debug_other_string(g_state_level,l_api_name,'end of procedure construct_bc_report_output');

3160: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3161: END IF;
3162:
3163: FND_FILE.put_line(FND_FILE.output, '');
3164: psa_utils.debug_other_string(g_state_level,l_api_name,'end of procedure construct_bc_report_output');
3165:
3166: EXCEPTION
3167: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3168: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3169: psa_utils.debug_other_string(g_unexp_level,l_api_name,'ERROR: ' || 'Unexpected Error in construct_bc_report_output Procedure');

3165:
3166: EXCEPTION
3167: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3168: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3169: psa_utils.debug_other_string(g_unexp_level,l_api_name,'ERROR: ' || 'Unexpected Error in construct_bc_report_output Procedure');
3170: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3171:
3172: WHEN FND_API.G_EXC_ERROR THEN
3173: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3174: psa_utils.debug_other_string(g_error_level,l_api_name,'ERROR: ' || 'Error in construct_bc_report_output Procedure');

3170: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3171:
3172: WHEN FND_API.G_EXC_ERROR THEN
3173: x_return_status := FND_API.G_RET_STS_ERROR;
3174: psa_utils.debug_other_string(g_error_level,l_api_name,'ERROR: ' || 'Error in construct_bc_report_output Procedure');
3175: RAISE FND_API.G_EXC_ERROR;
3176: WHEN OTHERS THEN
3177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3178: psa_utils.debug_other_string(g_excep_level,l_api_name,'EXCEPTION:' || SQLERRM(sqlcode));

Line 3178: psa_utils.debug_other_string(g_excep_level,l_api_name,'EXCEPTION:' || SQLERRM(sqlcode));

3174: psa_utils.debug_other_string(g_error_level,l_api_name,'ERROR: ' || 'Error in construct_bc_report_output Procedure');
3175: RAISE FND_API.G_EXC_ERROR;
3176: WHEN OTHERS THEN
3177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3178: psa_utils.debug_other_string(g_excep_level,l_api_name,'EXCEPTION:' || SQLERRM(sqlcode));
3179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3180: END construct_bc_report_output;
3181:
3182: -------------------------------------------------------------------------------

Line 3213: psa_utils.debug_other_string(g_state_level,l_api_name,'BEGIN of procedure save_xml');

3209: -- added for bug #5996038 by ks
3210: select decode(userenv('LANG') ,'US', 32766 , 16332)
3211: into l_amount from dual;
3212:
3213: psa_utils.debug_other_string(g_state_level,l_api_name,'BEGIN of procedure save_xml');
3214:
3215: -- Initialize API return status to success
3216: x_return_status := FND_API.G_RET_STS_SUCCESS;
3217:

Line 3220: psa_utils.debug_other_string(g_state_level,l_api_name,'l_amount' || ' = ' || l_amount);

3216: x_return_status := FND_API.G_RET_STS_SUCCESS;
3217:
3218: l_length := DBMS_LOB.getlength(p_trxs);
3219:
3220: psa_utils.debug_other_string(g_state_level,l_api_name,'l_amount' || ' = ' || l_amount);
3221: psa_utils.debug_other_string(g_state_level,l_api_name,'l_length' || ' = ' || l_length);
3222: psa_utils.debug_other_string(g_state_level,l_api_name,'l_pos' || ' = ' || l_pos);
3223:
3224: -- Inserting the XML CLOB value into PSA_BC_XML_CLOB table

Line 3221: psa_utils.debug_other_string(g_state_level,l_api_name,'l_length' || ' = ' || l_length);

3217:
3218: l_length := DBMS_LOB.getlength(p_trxs);
3219:
3220: psa_utils.debug_other_string(g_state_level,l_api_name,'l_amount' || ' = ' || l_amount);
3221: psa_utils.debug_other_string(g_state_level,l_api_name,'l_length' || ' = ' || l_length);
3222: psa_utils.debug_other_string(g_state_level,l_api_name,'l_pos' || ' = ' || l_pos);
3223:
3224: -- Inserting the XML CLOB value into PSA_BC_XML_CLOB table
3225:

Line 3222: psa_utils.debug_other_string(g_state_level,l_api_name,'l_pos' || ' = ' || l_pos);

3218: l_length := DBMS_LOB.getlength(p_trxs);
3219:
3220: psa_utils.debug_other_string(g_state_level,l_api_name,'l_amount' || ' = ' || l_amount);
3221: psa_utils.debug_other_string(g_state_level,l_api_name,'l_length' || ' = ' || l_length);
3222: psa_utils.debug_other_string(g_state_level,l_api_name,'l_pos' || ' = ' || l_pos);
3223:
3224: -- Inserting the XML CLOB value into PSA_BC_XML_CLOB table
3225:
3226: IF x_source = 'FORM' THEN

Line 3245: psa_utils.debug_other_string(g_state_level,l_api_name ,'"SUCCESSFUL" creation of XML Data Output');

3241:
3242: END IF;
3243:
3244: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
3245: psa_utils.debug_other_string(g_state_level,l_api_name ,'"SUCCESSFUL" creation of XML Data Output');
3246: END IF;
3247:
3248: psa_utils.debug_other_string(g_state_level,l_api_name,'end of procedure save_xml');
3249:

Line 3248: psa_utils.debug_other_string(g_state_level,l_api_name,'end of procedure save_xml');

3244: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
3245: psa_utils.debug_other_string(g_state_level,l_api_name ,'"SUCCESSFUL" creation of XML Data Output');
3246: END IF;
3247:
3248: psa_utils.debug_other_string(g_state_level,l_api_name,'end of procedure save_xml');
3249:
3250: EXCEPTION
3251: WHEN OTHERS THEN
3252: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3253: psa_utils.debug_other_string(g_excep_level,l_api_name,'EXCEPTION: '|| SQLERRM(sqlcode));

3249:
3250: EXCEPTION
3251: WHEN OTHERS THEN
3252: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3253: psa_utils.debug_other_string(g_excep_level,l_api_name,'EXCEPTION: '|| SQLERRM(sqlcode));
3254: RAISE;
3255: END save_xml;
3256:
3257: ----------------------------------------------------------------------------------------------

Line 3273: psa_utils.debug_other_string(g_state_level,l_api_name,'BEGIN of procedure save_xml_to_db');

3269: l_serial_id NUMBER;
3270:
3271: BEGIN
3272: l_api_name := g_full_path||'save_xml_to_db';
3273: psa_utils.debug_other_string(g_state_level,l_api_name,'BEGIN of procedure save_xml_to_db');
3274:
3275: -- Initialize API return status to success
3276: x_return_status := FND_API.G_RET_STS_SUCCESS;
3277:

Line 3287: psa_utils.debug_other_string(g_state_level,l_api_name,

3283: FROM v$session
3284: WHERE audsid = pbxc.session_id
3285: AND Serial# = pbxc.serial_id)));
3286:
3287: psa_utils.debug_other_string(g_state_level,l_api_name,
3288: 'No of rows deleted from psa_bc_xml_clob: '||SQL%ROWCOUNT);
3289:
3290:
3291: SELECT s.audsid, s.serial#

Line 3301: psa_utils.debug_other_string(g_state_level,l_api_name,

3297: -- Inserting the XML CLOB value into PSA_BC_XML_CLOB table
3298: INSERT INTO psa_bc_xml_clob(sequence_id, application_id, session_id, serial_id, creation_date, xml)
3299: VALUES (p_sequence_id, p_application_id, l_session_id, l_serial_id, sysdate, p_trxs);
3300:
3301: psa_utils.debug_other_string(g_state_level,l_api_name,
3302: 'No of rows inserted into psa_bc_xml_clob: '||SQL%ROWCOUNT);
3303:
3304: COMMIT;
3305:

Line 3306: psa_utils.debug_other_string(g_state_level,l_api_name,'end of procedure save_xml_to_db');

3302: 'No of rows inserted into psa_bc_xml_clob: '||SQL%ROWCOUNT);
3303:
3304: COMMIT;
3305:
3306: psa_utils.debug_other_string(g_state_level,l_api_name,'end of procedure save_xml_to_db');
3307:
3308: EXCEPTION
3309: WHEN OTHERS THEN
3310: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3311: psa_utils.debug_other_string(g_excep_level,l_api_name,'EXCEPTION: '|| SQLERRM(sqlcode));

3307:
3308: EXCEPTION
3309: WHEN OTHERS THEN
3310: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3311: psa_utils.debug_other_string(g_excep_level,l_api_name,'EXCEPTION: '|| SQLERRM(sqlcode));
3312: RAISE;
3313: END save_xml_to_db;
3314: END PSA_BC_XML_REPORT_PUB;