DBA Data[Home] [Help]

APPS.PSA_AP_BC_PVT dependencies on PSA_AP_BC_PVT

Line 1: PACKAGE BODY PSA_AP_BC_PVT AS

1: PACKAGE BODY PSA_AP_BC_PVT AS
2: --$Header: psavapbb.pls 120.49.12010000.5 2008/12/15 13:19:10 gnrajago ship $
3:
4: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;
5: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

Line 10: g_full_path CONSTANT VARCHAR2(50) :='psa.plsql.psavapbb.psa_ap_bc_pvt';

6: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
7: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
8: g_error_level NUMBER := FND_LOG.LEVEL_ERROR;
9: g_unexp_level NUMBER := FND_LOG.LEVEL_UNEXPECTED;
10: g_full_path CONSTANT VARCHAR2(50) :='psa.plsql.psavapbb.psa_ap_bc_pvt';
11: /*=============================================================================
12: |Private Procedure Specifications
13: *===========================================================================*/
14: FUNCTION get_event_security_context

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 90: l_curr_calling_sequence := 'PSA_AP_BC_PVT.'||l_debug_loc||'<-'||p_calling_sequence;

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;
92: IF Fnd_Api.To_Boolean(p_init_msg_list) THEN
93: Fnd_Msg_Pub.Initialize;
94: END IF;

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;

Line 292: l_curr_calling_sequence := 'PSA_AP_BC_PVT.'||l_debug_loc||

288:
289: BEGIN
290: l_api_name := g_full_path||'.Create_events';
291: -- Update the calling sequence --
292: l_curr_calling_sequence := 'PSA_AP_BC_PVT.'||l_debug_loc||
293: '<-'||p_calling_sequence;
294:
295: x_return_status := Fnd_Api.G_Ret_Sts_Success;
296: IF Fnd_Api.To_Boolean(p_init_msg_list) THEN

Line 698: psa_utils.debug_other_string(g_error_level,l_api_name, ' PSA_AP_BC_PVT.CREATE_EVENT Failed ');

694: ,aid2.invoice_id
695: ,aid2.line_type_lookup_code)='N');
696:
697: x_return_status := Fnd_Api.G_Ret_Sts_Error;
698: psa_utils.debug_other_string(g_error_level,l_api_name, ' PSA_AP_BC_PVT.CREATE_EVENT Failed ');
699: psa_utils.debug_other_string(g_error_level,l_api_name,
700: 'ERROR: Wrong BC event stamped on distributions for invoice id: '
701: || p_tab_fc_dist(1).invoice_id );
702: RETURN;

Line 761: l_curr_calling_sequence := 'PSA_AP_BC_PVT.'||l_debug_loc||

757:
758: END IF;
759:
760: -- Update the calling sequence --
761: l_curr_calling_sequence := 'PSA_AP_BC_PVT.'||l_debug_loc||
762: '<-'||p_calling_sequence;
763:
764: FOR i IN p_tab_fc_dist.FIRST..p_tab_fc_dist.LAST
765: LOOP

Line 1008: l_curr_calling_sequence := 'PSA_AP_BC_PVT.'||l_debug_loc||

1004: BEGIN
1005:
1006: l_api_name := g_full_path || '.Process_Fundschk_Failure_Code';
1007: -- Update the calling sequence --
1008: l_curr_calling_sequence := 'PSA_AP_BC_PVT.'||l_debug_loc||
1009: '<-'||p_calling_sequence;
1010:
1011: -----------------------------------------------------------
1012: -- Retrieve the failure result_code from gl fundschecker --

Line 1710: l_calling_sequence := 'PSA_AP_BC_PVT.Get_PO_Reversed_Encumb_Amount -> '

1706: BEGIN
1707: l_api_name := g_full_path || '.Get_PO_Reversed_Encumb_Amount';
1708: l_unencumbered_amount := 0;
1709:
1710: l_calling_sequence := 'PSA_AP_BC_PVT.Get_PO_Reversed_Encumb_Amount -> '
1711: ||substr(p_calling_sequence,1,100);
1712:
1713: psa_utils.debug_other_string(g_state_level,l_api_name,'Calling Sequence : ' || l_calling_sequence );
1714: psa_utils.debug_other_string(g_state_level,l_api_name,'PO Distribution Id : ' || P_Po_Distribution_Id );

Line 1845: END PSA_AP_BC_PVT;

1841: psa_utils.debug_other_string(g_state_level,l_api_name,'End of procedure isprepaydist');
1842: RETURN 'Y';
1843: END isprepaydist;
1844: -------------------------------------------------------------
1845: END PSA_AP_BC_PVT;