DBA Data[Home] [Help]

APPS.WSH_ITM_EXPORT_SCREENING dependencies on WSH_ITM_EXPORT_SCREENING

Line 1: PACKAGE BODY WSH_ITM_EXPORT_SCREENING AS

1: PACKAGE BODY WSH_ITM_EXPORT_SCREENING AS
2: /* $Header: WSHITESB.pls 120.3 2007/12/26 10:41:27 sankarun ship $ */
3:
4:
5:

Line 6: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_ITM_EXPORT_SCREENING';

2: /* $Header: WSHITESB.pls 120.3 2007/12/26 10:41:27 sankarun ship $ */
3:
4:
5:
6: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_ITM_EXPORT_SCREENING';
7: G_REQ_PICK_RELEASE_EXCEPTION CONSTANT VARCHAR2(30) := 'WSH_PR_REQ_EXPORT_COMPL';
8: G_REQ_SHIP_CONFIRM_EXCEPTION CONSTANT VARCHAR2(30) := 'WSH_SC_REQ_EXPORT_COMPL';
9: G_SUB_PICK_RELEASE_EXCEPTION CONSTANT VARCHAR2(30) := 'WSH_PR_SUB_EXPORT_COMPL';
10: G_SUB_SHIP_CONFIRM_EXCEPTION CONSTANT VARCHAR2(30) := 'WSH_SC_SUB_EXPORT_COMPL';

Line 860: WSH_ITM_EXPORT_SCREENING.POPULATE_SERIAL_NUMBERS(l_request_control_id_s

856: p_event_name,
857: l_num_organization_id_tab(k),
858: l_num_master_org_id_tab(k)
859: );
860: WSH_ITM_EXPORT_SCREENING.POPULATE_SERIAL_NUMBERS(l_request_control_id_s
861: ,l_num_delivery_id_tab(k)
862: , x_return_status);
863:
864: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

Line 1045: WSH_ITM_EXPORT_SCREENING.SCREEN_EVENT_DELIVERIES(l_return_status,p_organization_id,p_delivery_from_id,p_delivery_to_id,G_PICK_RELEASE_EVENT,p_ship_method_code,p_pickup_date_from,p_pickup_date_to);

1041: -- Performs Export Screening For Deliveries on Pick Release Event
1042: ------------------------------------------------------------------------------------------
1043: l_return_status := NULL;
1044:
1045: WSH_ITM_EXPORT_SCREENING.SCREEN_EVENT_DELIVERIES(l_return_status,p_organization_id,p_delivery_from_id,p_delivery_to_id,G_PICK_RELEASE_EVENT,p_ship_method_code,p_pickup_date_from,p_pickup_date_to);
1046:
1047:
1048: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1049: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','Error in procedure WSH_ITM_EXPORT_SCREENING.SCREEN_DELIVERIES for Pick Release event ');

Line 1049: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','Error in procedure WSH_ITM_EXPORT_SCREENING.SCREEN_DELIVERIES for Pick Release event ');

1045: WSH_ITM_EXPORT_SCREENING.SCREEN_EVENT_DELIVERIES(l_return_status,p_organization_id,p_delivery_from_id,p_delivery_to_id,G_PICK_RELEASE_EVENT,p_ship_method_code,p_pickup_date_from,p_pickup_date_to);
1046:
1047:
1048: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1049: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','Error in procedure WSH_ITM_EXPORT_SCREENING.SCREEN_DELIVERIES for Pick Release event ');
1050: retcode := 2;
1051: IF l_debug_on THEN
1052: WSH_DEBUG_SV.pop(l_module_name);
1053: END IF;

Line 1062: WSH_ITM_EXPORT_SCREENING.SCREEN_EVENT_DELIVERIES(l_return_status,p_organization_id,p_delivery_from_id,p_delivery_to_id,G_SHIP_CONFIRM_EVENT,p_ship_method_code,p_pickup_date_from,p_pickup_date_to);

1058: -- Performs Export Screening For Deliveries on Ship Confirm Event
1059: ------------------------------------------------------------------------------------------
1060: l_return_status := NULL;
1061:
1062: WSH_ITM_EXPORT_SCREENING.SCREEN_EVENT_DELIVERIES(l_return_status,p_organization_id,p_delivery_from_id,p_delivery_to_id,G_SHIP_CONFIRM_EVENT,p_ship_method_code,p_pickup_date_from,p_pickup_date_to);
1063:
1064: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1065: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','Error in procedure WSH_ITM_EXPORT_SCREENING.SCREEN_DELIVERIES for Ship Confirm event ');
1066: retcode := 2;

Line 1065: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','Error in procedure WSH_ITM_EXPORT_SCREENING.SCREEN_DELIVERIES for Ship Confirm event ');

1061:
1062: WSH_ITM_EXPORT_SCREENING.SCREEN_EVENT_DELIVERIES(l_return_status,p_organization_id,p_delivery_from_id,p_delivery_to_id,G_SHIP_CONFIRM_EVENT,p_ship_method_code,p_pickup_date_from,p_pickup_date_to);
1063:
1064: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1065: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','Error in procedure WSH_ITM_EXPORT_SCREENING.SCREEN_DELIVERIES for Ship Confirm event ');
1066: retcode := 2;
1067: IF l_debug_on THEN
1068: WSH_DEBUG_SV.pop(l_module_name);
1069: END IF;

Line 1093: END WSH_ITM_EXPORT_SCREENING;

1089:
1090: END SCREEN_DELIVERIES;
1091:
1092:
1093: END WSH_ITM_EXPORT_SCREENING;