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_AP_BC_PVT dependencies on FND_FILE

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

96: l_security_context xla_events_pub_pkg.t_security;
97: l_return_status VARCHAR2(1);
98:
99: BEGIN
100: fnd_file.put_line(fnd_file.log ,'>> PSA_AP_BC_PVT.Delete_EVENTS');
101: l_api_name := g_full_path||'.Delete_Events';
102: -- Update the calling sequence --
103: l_curr_calling_sequence := 'PSA_AP_BC_PVT.'||l_debug_loc||'<-'||p_calling_sequence;
104: x_return_status := Fnd_Api.G_Ret_Sts_Success;

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

143:
144: XLA_EVENTS_PUB_PKG.DELETE_BULK_EVENTS(p_application_id => 200);
145:
146: psa_utils.debug_other_string(g_state_level,l_api_name,'After Deletion of Unprocessed Events');
147: fnd_file.put_line(fnd_file.log ,'The following BC unprocessed/Error events have been deleted');
148: fnd_file.put_line(fnd_file.log ,'Event_id Event_status_code Process_status_code');
149: fnd_file.put_line(fnd_file.log ,'--------- ----------------- -------------------');
150:
151: FOR i IN 1..l_event_count LOOP

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

144: XLA_EVENTS_PUB_PKG.DELETE_BULK_EVENTS(p_application_id => 200);
145:
146: psa_utils.debug_other_string(g_state_level,l_api_name,'After Deletion of Unprocessed Events');
147: fnd_file.put_line(fnd_file.log ,'The following BC unprocessed/Error events have been deleted');
148: fnd_file.put_line(fnd_file.log ,'Event_id Event_status_code Process_status_code');
149: fnd_file.put_line(fnd_file.log ,'--------- ----------------- -------------------');
150:
151: FOR i IN 1..l_event_count LOOP
152: fnd_file.put_line(fnd_file.log ,l_events_tab(i).event_id||' '||

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

145:
146: psa_utils.debug_other_string(g_state_level,l_api_name,'After Deletion of Unprocessed Events');
147: fnd_file.put_line(fnd_file.log ,'The following BC unprocessed/Error events have been deleted');
148: fnd_file.put_line(fnd_file.log ,'Event_id Event_status_code Process_status_code');
149: fnd_file.put_line(fnd_file.log ,'--------- ----------------- -------------------');
150:
151: FOR i IN 1..l_event_count LOOP
152: fnd_file.put_line(fnd_file.log ,l_events_tab(i).event_id||' '||
153: l_events_tab(i).event_status_code ||' '||

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

148: fnd_file.put_line(fnd_file.log ,'Event_id Event_status_code Process_status_code');
149: fnd_file.put_line(fnd_file.log ,'--------- ----------------- -------------------');
150:
151: FOR i IN 1..l_event_count LOOP
152: fnd_file.put_line(fnd_file.log ,l_events_tab(i).event_id||' '||
153: l_events_tab(i).event_status_code ||' '||
154: l_events_tab(i).process_status_code);
155:
156: 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 174: fnd_file.put_line(fnd_file.log ,'Count of BC events deleted:' || l_event_count);

170: psa_utils.debug_other_string(g_state_level,l_api_name,'# distributions in ap_prepay_app_dists has been updated to NULL:'||SQL%ROWCOUNT);
171:
172: END LOOP;
173: END IF;
174: fnd_file.put_line(fnd_file.log ,'Count of BC events deleted:' || l_event_count);
175: fnd_file.put_line(fnd_file.log ,'<< PSA_AP_BC_PVT.Delete_EVENTS');
176: /*
177: --IF Federal is installed, call to fv_utility to
178: --delete Federal orphan events, if any

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

171:
172: END LOOP;
173: END IF;
174: fnd_file.put_line(fnd_file.log ,'Count of BC events deleted:' || l_event_count);
175: fnd_file.put_line(fnd_file.log ,'<< PSA_AP_BC_PVT.Delete_EVENTS');
176: /*
177: --IF Federal is installed, call to fv_utility to
178: --delete Federal orphan events, if any
179: IF fv_install.enabled THEN

Line 461: fnd_file.put_line(fnd_file.log ,'>> PSA_AP_BC_PVT.Delete_Processed_Orphan_Events');

457: FROM ap_self_assessed_tax_dist_all aps
458: WHERE aps.bc_event_id = xe.event_id)
459: ORDER BY xe.event_id;
460: BEGIN
461: fnd_file.put_line(fnd_file.log ,'>> PSA_AP_BC_PVT.Delete_Processed_Orphan_Events');
462: p_return_status := Fnd_Api.G_Ret_Sts_Success;
463: IF Fnd_Api.To_Boolean(p_init_msg_list) THEN
464: Fnd_Msg_Pub.Initialize;
465: END IF;

Line 469: fnd_file.put_line(fnd_file.log ,' ');

465: END IF;
466:
467: l_path_name := g_full_path|| '.delete_processed_orphan_events';
468: psa_utils.debug_other_string(g_state_level,l_path_name, 'BEGIN of procedure delete_processed_orphan_events ' );
469: fnd_file.put_line(fnd_file.log ,' ');
470: fnd_file.put_line(fnd_file.log ,'The following BC Processed orphan events have been deleted');
471: fnd_file.put_line(fnd_file.log ,'Event_Id Event_Status_Code Process_Status_Code GL_Transfer_Status_Code Delete_Status');
472: fnd_file.put_line(fnd_file.log ,'--------- ----------------- ------------------- ----------------------- -------------');
473: l_success_count :=0;

Line 470: fnd_file.put_line(fnd_file.log ,'The following BC Processed orphan events have been deleted');

466:
467: l_path_name := g_full_path|| '.delete_processed_orphan_events';
468: psa_utils.debug_other_string(g_state_level,l_path_name, 'BEGIN of procedure delete_processed_orphan_events ' );
469: fnd_file.put_line(fnd_file.log ,' ');
470: fnd_file.put_line(fnd_file.log ,'The following BC Processed orphan events have been deleted');
471: fnd_file.put_line(fnd_file.log ,'Event_Id Event_Status_Code Process_Status_Code GL_Transfer_Status_Code Delete_Status');
472: fnd_file.put_line(fnd_file.log ,'--------- ----------------- ------------------- ----------------------- -------------');
473: l_success_count :=0;
474: l_fail_count :=0;

Line 471: fnd_file.put_line(fnd_file.log ,'Event_Id Event_Status_Code Process_Status_Code GL_Transfer_Status_Code Delete_Status');

467: l_path_name := g_full_path|| '.delete_processed_orphan_events';
468: psa_utils.debug_other_string(g_state_level,l_path_name, 'BEGIN of procedure delete_processed_orphan_events ' );
469: fnd_file.put_line(fnd_file.log ,' ');
470: fnd_file.put_line(fnd_file.log ,'The following BC Processed orphan events have been deleted');
471: fnd_file.put_line(fnd_file.log ,'Event_Id Event_Status_Code Process_Status_Code GL_Transfer_Status_Code Delete_Status');
472: fnd_file.put_line(fnd_file.log ,'--------- ----------------- ------------------- ----------------------- -------------');
473: l_success_count :=0;
474: l_fail_count :=0;
475:

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

468: psa_utils.debug_other_string(g_state_level,l_path_name, 'BEGIN of procedure delete_processed_orphan_events ' );
469: fnd_file.put_line(fnd_file.log ,' ');
470: fnd_file.put_line(fnd_file.log ,'The following BC Processed orphan events have been deleted');
471: fnd_file.put_line(fnd_file.log ,'Event_Id Event_Status_Code Process_Status_Code GL_Transfer_Status_Code Delete_Status');
472: fnd_file.put_line(fnd_file.log ,'--------- ----------------- ------------------- ----------------------- -------------');
473: l_success_count :=0;
474: l_fail_count :=0;
475:
476: xla_security_pkg.set_security_context(602);

Line 552: fnd_file.put_line(fnd_file.log ,orphan_event_rec.event_id||' '||

548:
549: psa_utils.debug_other_string(g_state_level,l_path_name, 'x_return_status = '||x_return_status);
550: IF x_return_status = 'S' THEN
551: l_success_count := l_success_count+1;
552: fnd_file.put_line(fnd_file.log ,orphan_event_rec.event_id||' '||
553: orphan_event_rec.event_status_code||' '||
554: orphan_event_rec.process_status_code||' '||
555: orphan_event_rec.gl_transfer_status_code||' '||
556: 'Success' );

Line 572: fnd_file.put_line(fnd_file.log ,orphan_event_rec.event_id||' '||

568: psa_utils.debug_other_string(g_state_level,l_path_name, 'Deleting the xla_trial_balance'|| sql%rowcount);
569:
570: ELSE
571: l_fail_count := l_fail_count+1;
572: fnd_file.put_line(fnd_file.log ,orphan_event_rec.event_id||' '||
573: orphan_event_rec.event_status_code||' '||
574: orphan_event_rec.process_status_code||' '||
575: orphan_event_rec.gl_transfer_status_code||' '||
576: 'Failed' );

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

581: END IF;
582:
583: END LOOP;
584:
585: fnd_file.put_line(fnd_file.log ,'--------- ----------------- ------------------- ----------------------- -------------');
586: fnd_file.put_line(fnd_file.log ,'Events deleted successfully: ' || l_success_count);
587: fnd_file.put_line(fnd_file.log ,'Events could not be deleted: ' || l_fail_count);
588: psa_utils.debug_other_string(g_state_level,l_path_name, 'END of procedure delete_processed_orphan_events ' );
589: fnd_file.put_line(fnd_file.log ,'<< PSA_AP_BC_PVT.delete_processed_orphan_events');

Line 586: fnd_file.put_line(fnd_file.log ,'Events deleted successfully: ' || l_success_count);

582:
583: END LOOP;
584:
585: fnd_file.put_line(fnd_file.log ,'--------- ----------------- ------------------- ----------------------- -------------');
586: fnd_file.put_line(fnd_file.log ,'Events deleted successfully: ' || l_success_count);
587: fnd_file.put_line(fnd_file.log ,'Events could not be deleted: ' || l_fail_count);
588: psa_utils.debug_other_string(g_state_level,l_path_name, 'END of procedure delete_processed_orphan_events ' );
589: fnd_file.put_line(fnd_file.log ,'<< PSA_AP_BC_PVT.delete_processed_orphan_events');
590:

Line 587: fnd_file.put_line(fnd_file.log ,'Events could not be deleted: ' || l_fail_count);

583: END LOOP;
584:
585: fnd_file.put_line(fnd_file.log ,'--------- ----------------- ------------------- ----------------------- -------------');
586: fnd_file.put_line(fnd_file.log ,'Events deleted successfully: ' || l_success_count);
587: fnd_file.put_line(fnd_file.log ,'Events could not be deleted: ' || l_fail_count);
588: psa_utils.debug_other_string(g_state_level,l_path_name, 'END of procedure delete_processed_orphan_events ' );
589: fnd_file.put_line(fnd_file.log ,'<< PSA_AP_BC_PVT.delete_processed_orphan_events');
590:
591: EXCEPTION

Line 589: fnd_file.put_line(fnd_file.log ,'<< PSA_AP_BC_PVT.delete_processed_orphan_events');

585: fnd_file.put_line(fnd_file.log ,'--------- ----------------- ------------------- ----------------------- -------------');
586: fnd_file.put_line(fnd_file.log ,'Events deleted successfully: ' || l_success_count);
587: fnd_file.put_line(fnd_file.log ,'Events could not be deleted: ' || l_fail_count);
588: psa_utils.debug_other_string(g_state_level,l_path_name, 'END of procedure delete_processed_orphan_events ' );
589: fnd_file.put_line(fnd_file.log ,'<< PSA_AP_BC_PVT.delete_processed_orphan_events');
590:
591: EXCEPTION
592: WHEN OTHERS THEN
593: p_return_status := Fnd_Api.G_Ret_Sts_Error;