APPS.PSA_AP_BC_PVT dependencies on FND_FILE

Line 87: fnd_file.put_line(fnd_file.log ,'>> PSA_AP_BC_PVT.Delete_EVENTS');

83: l_valuation_method VARCHAR2(30);
84: l_security_context xla_events_pub_pkg.t_security;
85:
86: BEGIN
87: fnd_file.put_line(fnd_file.log ,'>> PSA_AP_BC_PVT.Delete_EVENTS');
88: l_api_name := g_full_path||'.Delete_Events';
89: -- Update the calling sequence --
90: l_curr_calling_sequence := 'PSA_AP_BC_PVT.'||l_debug_loc||'<-'||p_calling_sequence;
91: x_return_status := Fnd_Api.G_Ret_Sts_Success;

Line 132: fnd_file.put_line(fnd_file.log ,'The following BC unprocessed/Error events have been deleted');

128:
129: XLA_EVENTS_PUB_PKG.DELETE_BULK_EVENTS(p_application_id => 200);
130:
131: psa_utils.debug_other_string(g_state_level,l_api_name,'After Deletion of Unprocessed Events');
132: fnd_file.put_line(fnd_file.log ,'The following BC unprocessed/Error events have been deleted');
133: fnd_file.put_line(fnd_file.log ,'Event_id Event_status_code Process_status_code');
134: fnd_file.put_line(fnd_file.log ,'--------- ----------------- -------------------');
135:
136: FOR i IN 1..l_event_count

Line 133: fnd_file.put_line(fnd_file.log ,'Event_id Event_status_code Process_status_code');

129: XLA_EVENTS_PUB_PKG.DELETE_BULK_EVENTS(p_application_id => 200);
130:
131: psa_utils.debug_other_string(g_state_level,l_api_name,'After Deletion of Unprocessed Events');
132: fnd_file.put_line(fnd_file.log ,'The following BC unprocessed/Error events have been deleted');
133: fnd_file.put_line(fnd_file.log ,'Event_id Event_status_code Process_status_code');
134: fnd_file.put_line(fnd_file.log ,'--------- ----------------- -------------------');
135:
136: FOR i IN 1..l_event_count
137: LOOP

Line 134: fnd_file.put_line(fnd_file.log ,'--------- ----------------- -------------------');

130:
131: psa_utils.debug_other_string(g_state_level,l_api_name,'After Deletion of Unprocessed Events');
132: fnd_file.put_line(fnd_file.log ,'The following BC unprocessed/Error events have been deleted');
133: fnd_file.put_line(fnd_file.log ,'Event_id Event_status_code Process_status_code');
134: fnd_file.put_line(fnd_file.log ,'--------- ----------------- -------------------');
135:
136: FOR i IN 1..l_event_count
137: LOOP
138: fnd_file.put_line(fnd_file.log ,l_events_tab(i).event_id||' '||

Line 138: fnd_file.put_line(fnd_file.log ,l_events_tab(i).event_id||' '||

134: fnd_file.put_line(fnd_file.log ,'--------- ----------------- -------------------');
135:
136: FOR i IN 1..l_event_count
137: LOOP
138: fnd_file.put_line(fnd_file.log ,l_events_tab(i).event_id||' '||
139: l_events_tab(i).event_status_code ||' '||
140: l_events_tab(i).process_status_code);
141:
142: psa_utils.debug_other_string(g_state_level,l_api_name,'Updating bc_event_id '||l_events_tab(i).event_id ||'to NULL for related distributions.');

Line 160: fnd_file.put_line(fnd_file.log ,'Count of BC events deleted:' || l_event_count);

156: psa_utils.debug_other_string(g_state_level,l_api_name,'# distributions in ap_prepay_app_dists has been updated to NULL:'||SQL%ROWCOUNT);
157:
158: END LOOP;
159: END IF;
160: fnd_file.put_line(fnd_file.log ,'Count of BC events deleted:' || l_event_count);
161: fnd_file.put_line(fnd_file.log ,'<< PSA_AP_BC_PVT.Delete_EVENTS');
162: psa_utils.debug_other_string(g_state_level,l_api_name,'End of Procedure Delete_Events' );
163: EXCEPTION
164: WHEN OTHERS THEN

Line 161: fnd_file.put_line(fnd_file.log ,'<< PSA_AP_BC_PVT.Delete_EVENTS');

157:
158: END LOOP;
159: END IF;
160: fnd_file.put_line(fnd_file.log ,'Count of BC events deleted:' || l_event_count);
161: fnd_file.put_line(fnd_file.log ,'<< PSA_AP_BC_PVT.Delete_EVENTS');
162: psa_utils.debug_other_string(g_state_level,l_api_name,'End of Procedure Delete_Events' );
163: EXCEPTION
164: WHEN OTHERS THEN
165: x_return_status := Fnd_Api.G_Ret_Sts_Error;