DBA Data[Home] [Help]

APPS.WSH_PO_CMG_PVT dependencies on WSH_PO_CMG_PVT

Line 1: PACKAGE BODY WSH_PO_CMG_PVT as

1: PACKAGE BODY WSH_PO_CMG_PVT as
2: /* $Header: WSHPPCMB.pls 120.0.12000000.2 2007/01/24 18:22:51 bsadri ship $ */
3:
4:
5: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_PO_CMG_PVT';

Line 5: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_PO_CMG_PVT';

1: PACKAGE BODY WSH_PO_CMG_PVT as
2: /* $Header: WSHPPCMB.pls 120.0.12000000.2 2007/01/24 18:22:51 bsadri ship $ */
3:
4:
5: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_PO_CMG_PVT';
6: LIMITED_PRECISION NUMBER := 5;
7:
8: /*========================================================================
9: -- PROCEDURE : Reapprove_PO

Line 284: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_PO_CMG_PVT.Reapprove_PO',l_module_name);

280: --
281: WHEN OTHERS THEN
282: ROLLBACK TO Reapprove_PO_PVT;
283: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
284: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_PO_CMG_PVT.Reapprove_PO',l_module_name);
285:
286: --
287: -- Debug Statements
288: --

Line 524: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_PO_CMG_PVT.Update_Attributes',l_module_name);

520: --
521: WHEN OTHERS THEN
522: ROLLBACK TO Update_Attributes_PVT;
523: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
524: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_PO_CMG_PVT.Update_Attributes',l_module_name);
525:
526: --
527: -- Debug Statements
528: --

Line 1683: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_PO_CMG_PVT.Update_dd_Attributes',l_module_name);

1679: --
1680: WHEN OTHERS THEN
1681: ROLLBACK TO Update_dd_Attributes_PVT;
1682: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1683: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_PO_CMG_PVT.Update_dd_Attributes',l_module_name);
1684:
1685: --
1686: -- Debug Statements
1687: --

Line 3344: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_PO_CMG_PVT.Update_quantity',l_module_name);

3340: -- End of Code Added for DBI Project to handle Unexpected error
3341: WHEN OTHERS THEN
3342: ROLLBACK TO Update_quantity_PVT;
3343: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
3344: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_PO_CMG_PVT.Update_quantity',l_module_name);
3345:
3346: --
3347: -- Debug Statements
3348: --

Line 3478: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PO_CMG_PVT.CHECK_PENDING_TXNS',WSH_DEBUG_SV.C_PROC_LEVEL);

3474: --
3475: -- Debug Statements
3476: --
3477: IF l_debug_on THEN
3478: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PO_CMG_PVT.CHECK_PENDING_TXNS',WSH_DEBUG_SV.C_PROC_LEVEL);
3479: END IF;
3480: --
3481:
3482: --Call to check whether the line has any pending transactions

Line 3487: l_chk_pend:= WSH_PO_CMG_PVT.check_pending_txns(

3483: --against it.
3484: --If l_chk_pend = 0,there are no pending(unmatched)transactions agaisnt the line.
3485: --IF l_chk_pend = 1, there are pending(unmatched) transactions against the line.
3486:
3487: l_chk_pend:= WSH_PO_CMG_PVT.check_pending_txns(
3488: p_line_rec.header_id(l_index),
3489: p_line_rec.line_id(l_index),
3490: p_line_rec.po_shipment_line_id(l_index),
3491: p_line_rec.source_blanket_reference_id(l_index));

Line 3657: WSH_UTIL_CORE.Default_Handler('WSH_PO_CMG_PVT.CANCEL_CLOSE_PO',l_module_name);

3653: --
3654: WHEN OTHERS THEN
3655: ROLLBACK TO cancel_close_PO_PVT;
3656: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
3657: WSH_UTIL_CORE.Default_Handler('WSH_PO_CMG_PVT.CANCEL_CLOSE_PO',l_module_name);
3658:
3659: --
3660: -- Debug Statements
3661: --

Line 3793: WSH_UTIL_CORE.Default_Handler('WSH_PO_CMG_PVT.Reopen_po',l_module_name);

3789: EXCEPTION
3790: WHEN OTHERS THEN
3791: ROLLBACK TO REOPEN_PO_PVT;
3792: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
3793: WSH_UTIL_CORE.Default_Handler('WSH_PO_CMG_PVT.Reopen_po',l_module_name);
3794:
3795: --
3796: -- Debug Statements
3797: --

Line 4096: WSH_UTIL_CORE.Default_Handler('WSH_PO_CMG_PVT.LOG_EXCEPTION',l_module_name);

4092: END IF;
4093: --
4094: WHEN OTHERS THEN
4095: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
4096: WSH_UTIL_CORE.Default_Handler('WSH_PO_CMG_PVT.LOG_EXCEPTION',l_module_name);
4097:
4098: --
4099: -- Debug Statements
4100: --

Line 4233: WSH_UTIL_CORE.Default_Handler('WSH_PO_CMG_PVT.check_pending_txns',l_module_name);

4229:
4230:
4231: EXCEPTION
4232: WHEN OTHERS THEN
4233: WSH_UTIL_CORE.Default_Handler('WSH_PO_CMG_PVT.check_pending_txns',l_module_name);
4234: --
4235: -- Debug Statements
4236: --
4237: IF l_debug_on THEN

Line 4579: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_PO_CMG_PVT.populate_additional_line_info',l_module_name);

4575: END IF;
4576: --
4577: WHEN OTHERS THEN
4578: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
4579: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_PO_CMG_PVT.populate_additional_line_info',l_module_name);
4580:
4581: --
4582: -- Debug Statements
4583: --

Line 4707: WSH_UTIL_CORE.Default_Handler('WSH_PO_CMG_PVT.Calculate_Wt_Vol');

4703: END IF;
4704: --
4705: WHEN OTHERS THEN
4706: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
4707: WSH_UTIL_CORE.Default_Handler('WSH_PO_CMG_PVT.Calculate_Wt_Vol');
4708:
4709: --
4710: -- Debug Statements
4711: --

Line 4719: END WSH_PO_CMG_PVT;

4715: END IF;
4716: --
4717: END Calculate_Wt_Vol;
4718:
4719: END WSH_PO_CMG_PVT;