DBA Data[Home] [Help]

APPS.AP_WITHHOLDING_PKG dependencies on AP_WITHHOLDING_PKG

Line 1: PACKAGE BODY AP_WITHHOLDING_PKG AS

1: PACKAGE BODY AP_WITHHOLDING_PKG AS
2: /* $Header: apdoawtb.pls 120.87.12020000.12 2013/01/30 18:36:37 tjbhatt ship $ */
3:
4: -- =====================================================================
5: -- P U B L I C O B J E C T S

Line 15: G_MODULE_NAME CONSTANT VARCHAR2(30) := 'AP.PLSQL.AP_WITHHOLDING_PKG.';

11: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
12: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
13: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
14: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
15: G_MODULE_NAME CONSTANT VARCHAR2(30) := 'AP.PLSQL.AP_WITHHOLDING_PKG.';
16:
17: /*
18: bug13606808, Forward declaration for
19: private api Ap_Undo_Orphan_Distributions

Line 254: current_calling_sequence := 'AP_WITHHOLDING_PKG.Create_AWT_distributions<-' ||

250: l_exclude_freight_from_disc VARCHAR2(2) := 'N'; -- 10183587
251:
252:
253: BEGIN
254: current_calling_sequence := 'AP_WITHHOLDING_PKG.Create_AWT_distributions<-' ||
255: P_Calling_Sequence;
256:
257:
258: debug_info := 'Get 1099 Info From ASP';

Line 1573: current_calling_sequence := 'AP_WITHHOLDING_PKG.Create_AWT_Invoices<-' ||

1569: l_automatic_offsets VARCHAR2(1); -- bug9913164
1570:
1571: BEGIN
1572:
1573: current_calling_sequence := 'AP_WITHHOLDING_PKG.Create_AWT_Invoices<-' ||
1574: P_Calling_Sequence;
1575:
1576: -- Get base invoice description to insert in every new generated invoice
1577:

Line 1914: ,DECODE( p_calling_sequence, 'AP_WITHHOLDING_PKG.AP_Undo_Withholding',

1910: (new_invoice_id
1911: ,SYSDATE
1912: ,5
1913: ,tax_authority_id
1914: ,DECODE( p_calling_sequence, 'AP_WITHHOLDING_PKG.AP_Undo_Withholding',
1915: substrb(Ap_Utilities_Pkg.Ap_Get_DISplayed_Field('NLS TRANSLATION', 'AWT'),1,25)
1916: ||' - '||to_char(P_invoice_id)||' - ' || to_char(rec_awt_invs.invoice_line_number)
1917: || ' - ' || Ap_Utilities_Pkg.Ap_Get_DISplayed_Field('NLS TRANSLATION','CANCELLED'),
1918: substrb(Ap_Utilities_Pkg.Ap_Get_DISplayed_Field('NLS TRANSLATION', 'AWT'),1,25)||

Line 2715: current_calling_sequence := 'AP_WITHHOLDING_PKG.AP_Do_Withholding';

2711:
2712: */
2713:
2714: BEGIN
2715: current_calling_sequence := 'AP_WITHHOLDING_PKG.AP_Do_Withholding';
2716:
2717: -- Execute the ExtENDed Withholding Calculation (IF active)
2718: IF (Ap_ExtENDed_Withholding_Pkg.Ap_ExtENDed_Withholding_Active) THEN
2719: Ap_ExtENDed_Withholding_Pkg.Ap_Do_ExtENDed_Withholding

Line 2933: current_calling_sequence := 'AP_WITHHOLDING_PKG.AP_Withhold_AutoSelect';

2929: BEGIN
2930: /* Start - BUG 14364091 - Logging */
2931: l_api_name := 'Ap_Undo_Temp_Withholding';
2932: /* End - BUG 14364091 - Logging */
2933: current_calling_sequence := 'AP_WITHHOLDING_PKG.AP_Withhold_AutoSelect';
2934:
2935: debug_info := 'AP_WITHHOLDING_PKG.AP_Withhold_AutoSelect';
2936: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2937: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||DBG_Loc,debug_info);

Line 2935: debug_info := 'AP_WITHHOLDING_PKG.AP_Withhold_AutoSelect';

2931: l_api_name := 'Ap_Undo_Temp_Withholding';
2932: /* End - BUG 14364091 - Logging */
2933: current_calling_sequence := 'AP_WITHHOLDING_PKG.AP_Withhold_AutoSelect';
2934:
2935: debug_info := 'AP_WITHHOLDING_PKG.AP_Withhold_AutoSelect';
2936: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2937: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||DBG_Loc,debug_info);
2938: END IF;
2939:

Line 3443: current_calling_sequence := 'AP_WITHHOLDING_PKG.AP_Withhold_Confirm';

3439: DBG_Loc VARCHAR2(30) := 'Ap_Withhold_Confirm';
3440: current_calling_sequence VARCHAR2(2000);
3441: debug_info VARCHAR2(100);
3442: BEGIN
3443: current_calling_sequence := 'AP_WITHHOLDING_PKG.AP_Withhold_Confirm';
3444:
3445: -- Execute Core Withholding Routine for each invoice within
3446: -- the payment batch
3447:

Line 3581: current_calling_sequence := 'AP_WITHHOLDING_PKG.AP_Withhold_Cancel';

3577: DBG_Loc VARCHAR2(30) := 'Ap_Withhold_Cancel';
3578: current_calling_sequence VARCHAR2(2000);
3579: debug_info VARCHAR2(1000);
3580: BEGIN
3581: current_calling_sequence := 'AP_WITHHOLDING_PKG.AP_Withhold_Cancel';
3582: debug_info := 'Open Cursor for all selected invoices';
3583: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3584: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||DBG_Loc,debug_info);
3585: END IF;

Line 3691: current_calling_sequence := 'AP_WITHHOLDING_PKG.AP_Undo_Temp_Withholding';

3687: /* Start - BUG 14364091 - Logging */
3688: l_api_name := 'Ap_Undo_Temp_Withholding';
3689: /* End - BUG 14364091 - Logging */
3690:
3691: current_calling_sequence := 'AP_WITHHOLDING_PKG.AP_Undo_Temp_Withholding';
3692:
3693: P_AWT_Success := 'SUCCESS';
3694:
3695: --bug13606808

Line 3816: current_calling_sequence := 'AP_WITHHOLDING_PKG.Period_Limit_ExISt_For_Tax<-' ||

3812: dummy CHAR(12);
3813: current_calling_sequence VARCHAR2(2000);
3814: debug_info VARCHAR2(100);
3815: BEGIN
3816: current_calling_sequence := 'AP_WITHHOLDING_PKG.Period_Limit_ExISt_For_Tax<-' ||
3817: P_Calling_Sequence;
3818: debug_info := 'OPEN CURSOR c_get_limit';
3819: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3820: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||DBG_Loc,debug_info);

Line 4177: ThIS PROCEDURE IS part of the AP_WITHHOLDING_PKG PL/SQL package

4173: DESCRIPTION
4174: Reverses AWT distribution lines, buckets, tax authority invoices
4175: for a full invoice or for a payment depENDing upon the calling module
4176: NOTES
4177: ThIS PROCEDURE IS part of the AP_WITHHOLDING_PKG PL/SQL package
4178: HISTORY (YY/MM/DD)
4179: atassoni.it 95/07/14 Creation
4180: mhtaylor 95/08/21 Adapted for Adjust distributions
4181:

Line 4623: current_calling_sequence := 'AP_WITHHOLDING_PKG.AP_Undo_Withholding';

4619: -- \ /
4620: -- v
4621:
4622: BEGIN
4623: current_calling_sequence := 'AP_WITHHOLDING_PKG.AP_Undo_Withholding';
4624: P_Awt_Success := 'SUCCESS'; -- Assumes successfully completion
4625:
4626: IF ( (P_Calling_Module NOT IN
4627: ('VOID PAYMENT', 'CANCEL INVOICE', 'REVERSE DIST'))

Line 5765: current_calling_sequence := 'AP_WITHHOLDING_PKG.Ap_Undo_Orphan_Distributions';

5761: rec_orphan_awt_buckets_g c_orphan_awt_buckets_g%ROWTYPE;
5762: awt_period ap_other_periods.period_name%TYPE;
5763:
5764: BEGIN
5765: current_calling_sequence := 'AP_WITHHOLDING_PKG.Ap_Undo_Orphan_Distributions';
5766:
5767: P_AWT_Success := 'SUCCESS';
5768:
5769: BEGIN

Line 5953: END AP_WITHHOLDING_PKG;

5949: APP_EXCEPTION.RAISE_EXCEPTION;
5950: END;
5951: END Ap_Undo_Orphan_Distributions;
5952:
5953: END AP_WITHHOLDING_PKG;