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.AP_INVOICE_DISTRIBUTIONS_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_PKG

Line 1: PACKAGE BODY AP_INVOICE_DISTRIBUTIONS_PKG AS

1: PACKAGE BODY AP_INVOICE_DISTRIBUTIONS_PKG AS
2: /* $Header: apiindib.pls 120.112.12020000.11 2013/03/12 06:26:25 cmaredup ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AP_INVOICE_DISTRIBUTIONS_PKG';
5: G_MSG_UERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR;

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AP_INVOICE_DISTRIBUTIONS_PKG';

1: PACKAGE BODY AP_INVOICE_DISTRIBUTIONS_PKG AS
2: /* $Header: apiindib.pls 120.112.12020000.11 2013/03/12 06:26:25 cmaredup ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AP_INVOICE_DISTRIBUTIONS_PKG';
5: G_MSG_UERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR;
6: G_MSG_ERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR;
7: G_MSG_SUCCESS CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_SUCCESS;
8: G_MSG_HIGH CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH;

Line 20: G_MODULE_NAME CONSTANT VARCHAR2(100) := 'AP.PLSQL.AP_INVOICE_DISTRIBUTIONS_PKG.';

16: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
17: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
18: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
19: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
20: G_MODULE_NAME CONSTANT VARCHAR2(100) := 'AP.PLSQL.AP_INVOICE_DISTRIBUTIONS_PKG.';
21:
22:
23: --Invoice Lines: Distributions. Added the parameter X_INVOICE_LINE_NUMBER
24: -----------------------------------------------------------------------

Line 42: 'AP_INVOICE_DISTRIBUTIONS_PKG.CHECK_UNIQUE<-'||X_Calling_Sequence;

38:
39: -- Update the calling sequence
40: --
41: current_calling_sequence :=
42: 'AP_INVOICE_DISTRIBUTIONS_PKG.CHECK_UNIQUE<-'||X_Calling_Sequence;
43:
44: debug_info := 'Select from ap_invoice_distributions';
45:
46: select count(1)

Line 243: 'AP_INVOICE_DISTRIBUTIONS_PKG.Select_Summary<-'||X_Calling_Sequence;

239:
240: -- Update the calling sequence
241: --
242: current_calling_sequence :=
243: 'AP_INVOICE_DISTRIBUTIONS_PKG.Select_Summary<-'||X_Calling_Sequence;
244:
245: debug_info := 'Select from ap_invoice_distributions';
246:
247: -- eTax Uptake.

Line 369: 'AP_INVOICE_DISTRIBUTIONS_PKG.Query_New_Packet_Id<-'||X_Calling_Sequence;

365:
366: -- Update the calling sequence
367: --
368: current_calling_sequence :=
369: 'AP_INVOICE_DISTRIBUTIONS_PKG.Query_New_Packet_Id<-'||X_Calling_Sequence;
370:
371: debug_info := 'Select from ap_invoice_distributions';
372:
373: select 'TRUE'

Line 415: 'AP_INVOICE_DISTRIBUTIONS_PKG.All_Encumbered<-'||X_Calling_Sequence;

411:
412: -- Update the calling sequence
413: --
414: current_calling_sequence :=
415: 'AP_INVOICE_DISTRIBUTIONS_PKG.All_Encumbered<-'||X_Calling_Sequence;
416:
417: debug_info := 'Select from sys.dual';
418:
419: select 'There are encumbered dists'

Line 487: 'AP_INVOICE_DISTRIBUTIONS_PKG.Check_Cash_Basis_Paid<-'||X_Calling_Sequence;

483:
484: -- Update the calling sequence
485: --
486: current_calling_sequence :=
487: 'AP_INVOICE_DISTRIBUTIONS_PKG.Check_Cash_Basis_Paid<-'||X_Calling_Sequence;
488:
489: debug_info := 'Select accounting method from SOB';
490:
491: SELECT NVL(sla_ledger_cash_basis_flag, 'N')

Line 573: current_calling_sequence := 'AP_INVOICE_DISTRIBUTIONS_PKG.Adjust_PO<-'||X_Calling_Sequence;

569:
570: BEGIN
571:
572: l_api_name := 'Adjust_Po';
573: current_calling_sequence := 'AP_INVOICE_DISTRIBUTIONS_PKG.Adjust_PO<-'||X_Calling_Sequence;
574:
575: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
576: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_INVOICE_DISTRIBUTIONS_PKG.Adjust_Po(-)');
577: END IF;

Line 576: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_INVOICE_DISTRIBUTIONS_PKG.Adjust_Po(-)');

572: l_api_name := 'Adjust_Po';
573: current_calling_sequence := 'AP_INVOICE_DISTRIBUTIONS_PKG.Adjust_PO<-'||X_Calling_Sequence;
574:
575: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
576: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_INVOICE_DISTRIBUTIONS_PKG.Adjust_Po(-)');
577: END IF;
578:
579: l_debug_info := 'Create l_po_ap_dist_rec object';
580: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 631: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_INVOICE_DISTRIBUTIONS_PKG.Adjust_Po(-)');

627: X_Msg_Data => l_msg_data);
628:
629:
630: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
631: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_INVOICE_DISTRIBUTIONS_PKG.Adjust_Po(-)');
632: END IF;
633:
634: EXCEPTION
635: WHEN OTHERS THEN

Line 746: 'AP_INVOICE_DISTRIBUTIONS_PKG.insert_from_dist_set<-'||

742: --------------------------------------------------------------------------
743: -- Step 1 - Update the calling sequence
744: --------------------------------------------------------------------------
745: current_calling_sequence :=
746: 'AP_INVOICE_DISTRIBUTIONS_PKG.insert_from_dist_set<-'||
747: X_calling_sequence;
748:
749: --Bug16324208: Start
750: -------------------------------------------------------------------------

Line 1466: 'AP_INVOICE_DISTRIBUTIONS_PKG.update_distributions<-'||

1462: --record changes before reaching the PA code.
1463: BEGIN
1464: -- Update the calling sequence
1465: current_calling_sequence :=
1466: 'AP_INVOICE_DISTRIBUTIONS_PKG.update_distributions<-'||
1467: X_calling_sequence;
1468:
1469: /*-----------------------------------------------------------------+
1470: | First, assume that an update to AP_INVOICE_DISTRIBUTIONS |

Line 2201: 'AP_INVOICE_DISTRIBUTIONS_PKG.Insert_Row<-'||X_Calling_Sequence;

2197: BEGIN
2198: -- Update the calling sequence
2199: --
2200: current_calling_sequence :=
2201: 'AP_INVOICE_DISTRIBUTIONS_PKG.Insert_Row<-'||X_Calling_Sequence;
2202:
2203: debug_info := 'Calling invoice distribution handler';
2204:
2205: AP_AID_TABLE_HANDLER_PKG.Insert_Row

Line 2667: 'AP_INVOICE_DISTRIBUTIONS_PKG.Lock_Row<-'||X_Calling_Sequence;

2663:
2664: -- Update the calling sequence
2665: --
2666: current_calling_sequence :=
2667: 'AP_INVOICE_DISTRIBUTIONS_PKG.Lock_Row<-'||X_Calling_Sequence;
2668:
2669: debug_info := 'Select from ap_invoice_distributions';
2670:
2671: OPEN C;

Line 3192: 'AP_INVOICE_DISTRIBUTIONS_PKG.Update_Row<-'||X_Calling_Sequence;

3188:
3189: -- Update the calling sequence
3190: --
3191: current_calling_sequence :=
3192: 'AP_INVOICE_DISTRIBUTIONS_PKG.Update_Row<-'||X_Calling_Sequence;
3193:
3194: AP_AID_TABLE_HANDLER_PKG.Update_Row
3195: (X_Rowid,
3196: X_Invoice_Id,

Line 3376: 'AP_INVOICE_DISTRIBUTIONS_PKG.Delete_Row<-'||X_Calling_Sequence;

3372:
3373: -- Update the calling sequence
3374: --
3375: current_calling_sequence :=
3376: 'AP_INVOICE_DISTRIBUTIONS_PKG.Delete_Row<-'||X_Calling_Sequence;
3377:
3378: AP_AID_TABLE_HANDLER_PKG.Delete_Row(
3379: X_Rowid,
3380: current_calling_sequence);

Line 3489: AND AP_INVOICE_DISTRIBUTIONS_PKG.get_balancing_segment_value(

3485: FROM ap_invoice_distributions
3486: WHERE invoice_id = X_Invoice_Id
3487: AND line_type_lookup_code IN ('ITEM','PREPAY')
3488: AND nvl(reversal_flag,'N') <> 'Y'
3489: AND AP_INVOICE_DISTRIBUTIONS_PKG.get_balancing_segment_value(
3490: dist_code_combination_id, X_Sob_Id) =
3491: AP_INVOICE_DISTRIBUTIONS_PKG.get_balancing_segment_value(
3492: X_Prepay_Dist_CCID, X_Sob_Id);
3493:

Line 3491: AP_INVOICE_DISTRIBUTIONS_PKG.get_balancing_segment_value(

3487: AND line_type_lookup_code IN ('ITEM','PREPAY')
3488: AND nvl(reversal_flag,'N') <> 'Y'
3489: AND AP_INVOICE_DISTRIBUTIONS_PKG.get_balancing_segment_value(
3490: dist_code_combination_id, X_Sob_Id) =
3491: AP_INVOICE_DISTRIBUTIONS_PKG.get_balancing_segment_value(
3492: X_Prepay_Dist_CCID, X_Sob_Id);
3493:
3494: RETURN (l_dist_amount);
3495:

Line 3517: AP_INVOICE_DISTRIBUTIONS_PKG.get_balancing_segment_value(

3513:
3514: -- Bug 2404982. Added package qualifier to procedure call.
3515: CURSOR c_prepay_dist IS
3516: SELECT sum(nvl(prepay_amount_remaining,amount)),
3517: AP_INVOICE_DISTRIBUTIONS_PKG.get_balancing_segment_value(
3518: aip.dist_code_combination_id, X_Sob_Id)
3519: FROM ap_invoice_distributions aip
3520: WHERE aip.invoice_id = X_Prepay_Id
3521: --bugfix:3881673

Line 3525: AND AP_INVOICE_DISTRIBUTIONS_PKG.get_balancing_segment_value(

3521: --bugfix:3881673
3522: AND aip.line_type_lookup_code in ('ITEM','ACCRUAL')
3523: AND nvl(aip.reversal_flag,'N') <> 'Y'
3524: AND nvl(aip.prepay_amount_remaining,amount) > 0
3525: AND AP_INVOICE_DISTRIBUTIONS_PKG.get_balancing_segment_value(
3526: aip.dist_code_combination_id, X_Sob_Id) IN
3527: (SELECT AP_INVOICE_DISTRIBUTIONS_PKG.get_balancing_segment_value(
3528: aid.dist_code_combination_id, X_Sob_Id)
3529: FROM ap_invoice_distributions aid

Line 3527: (SELECT AP_INVOICE_DISTRIBUTIONS_PKG.get_balancing_segment_value(

3523: AND nvl(aip.reversal_flag,'N') <> 'Y'
3524: AND nvl(aip.prepay_amount_remaining,amount) > 0
3525: AND AP_INVOICE_DISTRIBUTIONS_PKG.get_balancing_segment_value(
3526: aip.dist_code_combination_id, X_Sob_Id) IN
3527: (SELECT AP_INVOICE_DISTRIBUTIONS_PKG.get_balancing_segment_value(
3528: aid.dist_code_combination_id, X_Sob_Id)
3529: FROM ap_invoice_distributions aid
3530: WHERE aid.invoice_id = X_Invoice_ID)
3531: GROUP BY AP_INVOICE_DISTRIBUTIONS_PKG.get_balancing_segment_value(

Line 3531: GROUP BY AP_INVOICE_DISTRIBUTIONS_PKG.get_balancing_segment_value(

3527: (SELECT AP_INVOICE_DISTRIBUTIONS_PKG.get_balancing_segment_value(
3528: aid.dist_code_combination_id, X_Sob_Id)
3529: FROM ap_invoice_distributions aid
3530: WHERE aid.invoice_id = X_Invoice_ID)
3531: GROUP BY AP_INVOICE_DISTRIBUTIONS_PKG.get_balancing_segment_value(
3532: aip.dist_code_combination_id, X_Sob_Id)
3533: ORDER BY AP_INVOICE_DISTRIBUTIONS_PKG.get_balancing_segment_value(
3534: aip.dist_code_combination_id, X_Sob_Id);
3535:

Line 3533: ORDER BY AP_INVOICE_DISTRIBUTIONS_PKG.get_balancing_segment_value(

3529: FROM ap_invoice_distributions aid
3530: WHERE aid.invoice_id = X_Invoice_ID)
3531: GROUP BY AP_INVOICE_DISTRIBUTIONS_PKG.get_balancing_segment_value(
3532: aip.dist_code_combination_id, X_Sob_Id)
3533: ORDER BY AP_INVOICE_DISTRIBUTIONS_PKG.get_balancing_segment_value(
3534: aip.dist_code_combination_id, X_Sob_Id);
3535:
3536: BEGIN
3537:

Line 3550: AND AP_INVOICE_DISTRIBUTIONS_PKG.get_balancing_segment_value(

3546: FROM ap_invoice_distributions
3547: WHERE invoice_id = X_Invoice_ID
3548: AND line_type_lookup_code IN ('ITEM','PREPAY')
3549: AND nvl(reversal_flag,'N') <> 'Y'
3550: AND AP_INVOICE_DISTRIBUTIONS_PKG.get_balancing_segment_value(
3551: dist_code_combination_id, X_Sob_Id)
3552: = l_bal_segment;
3553:
3554: IF l_invoice_amount <> 0 THEN

Line 3581: AP_INVOICE_DISTRIBUTIONS_PKG.get_balancing_segment_value(

3577: BEGIN
3578:
3579: --Bug 2404982. Added package qualifier to procedure call.
3580: SELECT count(distinct(
3581: AP_INVOICE_DISTRIBUTIONS_PKG.get_balancing_segment_value(
3582: dist_code_combination_id, X_Sob_Id)) )
3583: INTO l_dist_count
3584: FROM ap_invoice_distributions
3585: WHERE invoice_id = X_Invoice_Id;

Line 3712: 'AP_INVOICE_DISTRIBUTIONS_PKG.Round_Biggest_Distribution<-'

3708:
3709: -- Update current calling sequence
3710: --
3711: current_calling_sequence :=
3712: 'AP_INVOICE_DISTRIBUTIONS_PKG.Round_Biggest_Distribution<-'
3713: ||X_Calling_Sequence;
3714:
3715: debug_info := 'Adjusting distribution amount in biggest distribution';
3716:

Line 4034: 'AP_INVOICE_DISTRIBUTIONS_PKG.insert_single_dist_from_line <-'||

4030: --------------------------------------------------------------------------
4031: -- Step 1 - Update the calling sequence
4032: --------------------------------------------------------------------------
4033: current_calling_sequence :=
4034: 'AP_INVOICE_DISTRIBUTIONS_PKG.insert_single_dist_from_line <-'||
4035: X_calling_sequence;
4036:
4037: --------------------------------------------------------------------------
4038: -- Step 2 - If calling module provided X_invoice_id / X_line_number, then

Line 5290: 'AP_INVOICE_DISTRIBUTIONS_PKG.insert_single_dist_from_line <-'||

5286: --------------------------------------------------------------------------
5287: -- Step 1 - Update the calling sequence
5288: --------------------------------------------------------------------------
5289: current_calling_sequence :=
5290: 'AP_INVOICE_DISTRIBUTIONS_PKG.insert_single_dist_from_line <-'||
5291: X_calling_sequence;
5292:
5293: --------------------------------------------------------------------------
5294: -- Step 2 - If calling module provided X_invoice_id / X_line_number, then

Line 6681: AP_INVOICE_DISTRIBUTIONS_PKG.GET_TOTAL_DIST_AMOUNT(

6677: AID.pa_quantity, -- bug6699834
6678: AID.expenditure_type,
6679: AID.expenditure_organization_id,
6680: AID.award_id,
6681: AP_INVOICE_DISTRIBUTIONS_PKG.GET_TOTAL_DIST_AMOUNT(
6682: aid.invoice_distribution_id),
6683: AID.dist_code_combination_id,
6684: AID.assets_tracking_flag,
6685: AID.asset_book_type_code,

Line 6836: 'AP_INVOICE_DISTRIBUTIONS_PKG.insert_charge_from_alloc <-'

6832: ---------------------------------------------------------------------------
6833: -- Step 1 - Update the calling sequence
6834: ---------------------------------------------------------------------------
6835: current_calling_sequence :=
6836: 'AP_INVOICE_DISTRIBUTIONS_PKG.insert_charge_from_alloc <-'
6837: ||X_calling_sequence;
6838:
6839: --------------------------------------------------------------------------
6840: -- Step 2 - Validate the line exists and get line level information

Line 8889: 'AP_INVOICE_DISTRIBUTIONS_PKG.DIST_REFER_ACTIVE_CORR<-'

8885:
8886: -- Update the calling sequence
8887: --
8888: current_calling_sequence :=
8889: 'AP_INVOICE_DISTRIBUTIONS_PKG.DIST_REFER_ACTIVE_CORR<-'
8890: ||p_Calling_Sequence;
8891:
8892: debug_info := 'Select from ap_invoice_distributions_all';
8893:

Line 8952: 'AP_INVOICE_DISTRIBUTIONS_PKG.CHRG_REFER_ACTIVE_DIST<-'

8948:
8949: -- Update the calling sequence
8950: --
8951: current_calling_sequence :=
8952: 'AP_INVOICE_DISTRIBUTIONS_PKG.CHRG_REFER_ACTIVE_DIST<-'
8953: ||p_Calling_Sequence;
8954:
8955: debug_info := 'Select from ap_invoice_distributions_all';
8956:

Line 9020: 'AP_INVOICE_DISTRIBUTIONS_PKG.DIST_REFER_ACTIVE_CORR<-'

9016:
9017: -- Update the calling sequence
9018: --
9019: current_calling_sequence :=
9020: 'AP_INVOICE_DISTRIBUTIONS_PKG.DIST_REFER_ACTIVE_CORR<-'
9021: ||p_Calling_Sequence;
9022:
9023: debug_info := 'Inside wapper API Dist_Refer_Active_Corr_Wrap, ' ||
9024: 'invoked from NegotiationAMImpl.handleDistributionDeleteAction';

Line 9084: 'AP_INVOICE_DISTRIBUTIONS_PKG.CHRG_REFER_ACTIVE_DIST<-'

9080:
9081: -- Update the calling sequence
9082: --
9083: current_calling_sequence :=
9084: 'AP_INVOICE_DISTRIBUTIONS_PKG.CHRG_REFER_ACTIVE_DIST<-'
9085: ||p_Calling_Sequence;
9086:
9087: debug_info := 'Inside wapper API Chrg_Refer_Active_Dist_Wrap, ' ||
9088: 'invoked from NegotiationAMImpl.handleDistributionDeleteAction';

Line 9127: current_calling_sequence := 'Ap_Invoice_Distributions_Pkg.Make_Distributions_Permanent<- '

9123: global_exception EXCEPTION;
9124:
9125: BEGIN
9126:
9127: current_calling_sequence := 'Ap_Invoice_Distributions_Pkg.Make_Distributions_Permanent<- '
9128: ||p_calling_sequence;
9129:
9130: l_debug_info := 'Updating ap_invoice_distributions';
9131:

Line 9295: END AP_INVOICE_DISTRIBUTIONS_PKG;

9291: RETURN L_AWT_COMPUTED;
9292: END;
9293:
9294:
9295: END AP_INVOICE_DISTRIBUTIONS_PKG;