DBA Data[Home] [Help]

APPS.WSH_DELIVERIES_PUB dependencies on WSH_DELIVERIES_PUB

Line 1: PACKAGE BODY WSH_DELIVERIES_PUB as

1: PACKAGE BODY WSH_DELIVERIES_PUB as
2: /* $Header: WSHDEPBB.pls 120.1 2007/01/05 00:27:45 anxsharm noship $ */
3:
4: --===================
5: -- CONSTANTS

Line 7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'WSH_DELIVERIES_PUB';

3:
4: --===================
5: -- CONSTANTS
6: --===================
7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'WSH_DELIVERIES_PUB';
8: -- add your constants here if any
9:
10: --===================
11: -- PROCEDURES

Line 15: p_in_rec IN WSH_DELIVERIES_PUB.Delivery_Pub_Rec_Type,

11: -- PROCEDURES
12: --===================
13:
14: PROCEDURE Rtrim_delivery (
15: p_in_rec IN WSH_DELIVERIES_PUB.Delivery_Pub_Rec_Type,
16: p_out_rec OUT NOCOPY WSH_DELIVERIES_PUB.Delivery_Pub_Rec_Type)
17: IS
18: l_debug_on BOOLEAN;
19: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' ||

Line 16: p_out_rec OUT NOCOPY WSH_DELIVERIES_PUB.Delivery_Pub_Rec_Type)

12: --===================
13:
14: PROCEDURE Rtrim_delivery (
15: p_in_rec IN WSH_DELIVERIES_PUB.Delivery_Pub_Rec_Type,
16: p_out_rec OUT NOCOPY WSH_DELIVERIES_PUB.Delivery_Pub_Rec_Type)
17: IS
18: l_debug_on BOOLEAN;
19: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' ||
20: G_PKG_NAME || '.' || 'Rtrim_delivery';

Line 474: wsh_util_core.default_handler('WSH_DELIVERIES_PUB.Validate_Delivery');

470:
471:
472: EXCEPTION
473: WHEN others THEN
474: wsh_util_core.default_handler('WSH_DELIVERIES_PUB.Validate_Delivery');
475: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
476:
477: END Validate_Delivery;
478:

Line 661: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_DELIVERIES_PUB.map_pub_to_pvt',l_module_name);

657: WSH_DEBUG_SV.pop(l_module_name);
658: END IF;
659: EXCEPTION
660: WHEN OTHERS THEN
661: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_DELIVERIES_PUB.map_pub_to_pvt',l_module_name);
662: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
663: --
664: IF l_debug_on THEN
665: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 1267: -- WSH_DELIVERIES_PUB.Delivery_Actions called for generating and printing reports.

1263: ELSE
1264: RAISE WSH_INVALID_DELIVERY;
1265: END IF;
1266:
1267: -- WSH_DELIVERIES_PUB.Delivery_Actions called for generating and printing reports.
1268: IF (l_count > 0) THEN
1269: FOR i IN 1..l_count LOOP -- { l_Count For Loop
1270:
1271: l_delivery_id := l_delivery_ids(i);

Line 1272: WSH_DELIVERIES_PUB.Delivery_Action(

1268: IF (l_count > 0) THEN
1269: FOR i IN 1..l_count LOOP -- { l_Count For Loop
1270:
1271: l_delivery_id := l_delivery_ids(i);
1272: WSH_DELIVERIES_PUB.Delivery_Action(
1273: p_api_version_number => 1.0,
1274: p_init_msg_list => 'F',
1275: p_action_code => 'PRINT-DOC-SETS',
1276: p_sc_report_set_name => p_report_set_name,

Line 1366: WSH_UTIL_CORE.Default_Handler('WSH_DELIVERIES_PUB.GENEREATE_DOCUMENTS');

1362: p_count => x_msg_count,
1363: p_data => x_msg_data );
1364:
1365: WHEN OTHERS THEN
1366: WSH_UTIL_CORE.Default_Handler('WSH_DELIVERIES_PUB.GENEREATE_DOCUMENTS');
1367: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1368: IF l_debug_on THEN
1369: WSH_DEBUG_SV.Logmsg(l_module_name, 'Unexpected Error : ' || x_return_status);
1370: WSH_DEBUG_SV.Logmsg(l_module_name, 'Error Message : ' || SQLERRM);

Line 1379: END WSH_DELIVERIES_PUB;

1375: END Generate_Documents;
1376:
1377:
1378:
1379: END WSH_DELIVERIES_PUB;