APPS.PO_PRICE_ADJUSTMENTS_PKG dependencies on PO_PRICE_ADJUSTMENTS_PKG

Line 1: PACKAGE BODY PO_PRICE_ADJUSTMENTS_PKG AS

1: PACKAGE BODY PO_PRICE_ADJUSTMENTS_PKG AS
2: -- $Header: PO_PRICE_ADJUSTMENTS_PKG.plb 120.0.12010000.4 2009/07/01 01:34:47 ababujan noship $
3:
4: ---------------------------------------------------------------------------
5: -- Modules for debugging.

Line 2: -- $Header: PO_PRICE_ADJUSTMENTS_PKG.plb 120.0.12010000.4 2009/07/01 01:34:47 ababujan noship $

1: PACKAGE BODY PO_PRICE_ADJUSTMENTS_PKG AS
2: -- $Header: PO_PRICE_ADJUSTMENTS_PKG.plb 120.0.12010000.4 2009/07/01 01:34:47 ababujan noship $
3:
4: ---------------------------------------------------------------------------
5: -- Modules for debugging.
6: ---------------------------------------------------------------------------

Line 10: PO_LOG.get_package_base('PO_PRICE_ADJUSTMENTS_PKG');

6: ---------------------------------------------------------------------------
7:
8: -- The module base for this package.
9: D_PACKAGE_BASE CONSTANT VARCHAR2(50) :=
10: PO_LOG.get_package_base('PO_PRICE_ADJUSTMENTS_PKG');
11:
12: -- The module base for the subprogram.
13: D_popl_manual_overridden_adj CONSTANT VARCHAR2(100) :=
14: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'popl_manual_overridden_adj');

Line 45: g_pkg_name CONSTANT varchar2(30) := 'PO_PRICE_ADJUSTMENTS_PKG';

41: -- Global Constants.
42: ---------------------------------------------------------------------------
43:
44: -- Private package constants
45: g_pkg_name CONSTANT varchar2(30) := 'PO_PRICE_ADJUSTMENTS_PKG';
46: g_log_head CONSTANT VARCHAR2(50) := 'po.plsql.' || g_pkg_name || '.';
47:
48: -- Debugging
49: g_debug_stmt BOOLEAN := PO_DEBUG.is_debug_stmt_on;

Line 1353: PO_DEBUG.debug_stmt(l_log_head,l_progress,'EXITING PO_PRICE_ADJUSTMENTS_PKG.POPL_MANUAL_OVERRIDDEN_ADJ with rollback');

1349: PO_DEBUG.debug_stmt(l_log_head,l_progress,'UnExpected ERROR IN POPL_MANUAL_OVERRIDDEN_ADJ. SQLERRM at '||l_progress||': '||SQLERRM);
1350: END IF;
1351:
1352: IF g_debug_unexp THEN
1353: PO_DEBUG.debug_stmt(l_log_head,l_progress,'EXITING PO_PRICE_ADJUSTMENTS_PKG.POPL_MANUAL_OVERRIDDEN_ADJ with rollback');
1354: END IF;
1355: ROLLBACK TO SAVEPOINT POPULATE_QP_TABLES;
1356: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1357: END popl_manual_overridden_adj;

Line 1559: PO_DEBUG.debug_stmt(l_log_head,l_progress,'EXITING PO_PRICE_ADJUSTMENTS_PKG.EXTRACT_PRICE_ADJUSTMENTS with rollback');

1555: PO_DEBUG.debug_stmt(l_log_head,l_progress,'UnExpected ERROR IN EXTRACT_PRICE_ADJUSTMENTS. SQLERRM at '||l_progress||': '||SQLERRM);
1556: END IF;
1557:
1558: IF g_debug_unexp THEN
1559: PO_DEBUG.debug_stmt(l_log_head,l_progress,'EXITING PO_PRICE_ADJUSTMENTS_PKG.EXTRACT_PRICE_ADJUSTMENTS with rollback');
1560: END IF;
1561: ROLLBACK TO SAVEPOINT EXTRACT_PRICE_ADJUSTMENTS;
1562: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1563: END extract_price_adjustments;

Line 3714: PO_MESSAGE_S.sql_error('PO_PRICE_ADJUSTMENTS_PKG.delete_price_adjustments','000',sqlcode);

3710: */
3711:
3712: EXCEPTION
3713: WHEN OTHERS THEN
3714: PO_MESSAGE_S.sql_error('PO_PRICE_ADJUSTMENTS_PKG.delete_price_adjustments','000',sqlcode);
3715: RAISE;
3716: END delete_price_adjustments;
3717:
3718:

Line 3763: PO_MESSAGE_S.sql_error('PO_PRICE_ADJUSTMENTS_PKG.delete_adjustment','000',sqlcode);

3759: DELETE FROM PO_PRICE_ADJUSTMENTS ADJ
3760: WHERE ADJ.price_adjustment_id = p_price_adjustment_id;
3761: EXCEPTION
3762: WHEN OTHERS THEN
3763: PO_MESSAGE_S.sql_error('PO_PRICE_ADJUSTMENTS_PKG.delete_adjustment','000',sqlcode);
3764: RAISE;
3765: END delete_adjustment;
3766:
3767: /*

Line 3822: PO_MESSAGE_S.sql_error('PO_PRICE_ADJUSTMENTS_PKG.delete_adjustment_dependants','000',sqlcode);

3818: AND ASOC.rltd_price_adj_id = p_price_adjustment_id;
3819:
3820: EXCEPTION
3821: WHEN OTHERS THEN
3822: PO_MESSAGE_S.sql_error('PO_PRICE_ADJUSTMENTS_PKG.delete_adjustment_dependants','000',sqlcode);
3823: RAISE;
3824: END delete_adjustment_dependants;
3825: */
3826:

Line 3827: END PO_PRICE_ADJUSTMENTS_PKG;

3823: RAISE;
3824: END delete_adjustment_dependants;
3825: */
3826:
3827: END PO_PRICE_ADJUSTMENTS_PKG;