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.WSH_TP_RELEASE dependencies on FND_API

Line 305: IF (nvl(l_wh_type, FND_API.G_MISS_CHAR) IN ('TPW','CMS')) THEN

301: p_delivery_id => l_del_cur.delivery_id,
302: p_msg_display => 'N');
303:
304:
305: IF (nvl(l_wh_type, FND_API.G_MISS_CHAR) IN ('TPW','CMS')) THEN
306: IF l_debug_on THEN
307: WSH_DEBUG_SV.log(l_module_name,'Get_Warehouse_Type cur.organization_id,l_wh_type,l_return_status',cur.organization_id||l_wh_type||l_return_status);
308: END IF;
309:

Line 621: IF (nvl(l_wh_type, FND_API.G_MISS_CHAR) IN ('TPW','CMS')) THEN

617: p_delivery_id => p_in_ids(i),
618: p_msg_display => 'N');
619:
620:
621: IF (nvl(l_wh_type, FND_API.G_MISS_CHAR) IN ('TPW','CMS')) THEN
622: IF l_debug_on THEN
623: WSH_DEBUG_SV.log(l_module_name,'Get_Warehouse_Type cur.organization_id,l_wh_type,l_return_status',cur.organization_id||l_wh_type||l_return_status);
624: END IF;
625:

Line 1066: IF (nvl(l_wh_type, FND_API.G_MISS_CHAR) IN ('TPW','CMS'))

1062: p_delivery_detail_id => p_in_ids(i),
1063: p_msg_display => 'N');
1064:
1065: -- 5746444: disable this condition when OTM is installed
1066: IF (nvl(l_wh_type, FND_API.G_MISS_CHAR) IN ('TPW','CMS'))
1067: OR (cur.source_code='WSH' and cur.container_flag='N'
1068: and l_gc3_is_installed = 'N' )
1069: THEN
1070: IF l_debug_on THEN

Line 2090: IF (p_organization_id IS NULL OR p_organization_id = FND_API.G_MISS_NUM)

2086: l_request_date_type := 'SHIP';
2087: ELSE
2088: l_request_date_type := p_request_date_type;
2089: END IF;
2090: IF (p_organization_id IS NULL OR p_organization_id = FND_API.G_MISS_NUM)
2091: OR (p_inventory_item_id IS NULL OR p_inventory_item_id = FND_API.G_MISS_NUM) THEN
2092:
2093: OPEN c_dd_item_id(p_source_line_id,p_source_code);
2094: FETCH c_dd_item_id INTO l_organization_id,l_inventory_item_id,

Line 2091: OR (p_inventory_item_id IS NULL OR p_inventory_item_id = FND_API.G_MISS_NUM) THEN

2087: ELSE
2088: l_request_date_type := p_request_date_type;
2089: END IF;
2090: IF (p_organization_id IS NULL OR p_organization_id = FND_API.G_MISS_NUM)
2091: OR (p_inventory_item_id IS NULL OR p_inventory_item_id = FND_API.G_MISS_NUM) THEN
2092:
2093: OPEN c_dd_item_id(p_source_line_id,p_source_code);
2094: FETCH c_dd_item_id INTO l_organization_id,l_inventory_item_id,
2095: l_delivery_detail_id,l_split_delivery_detail_id,l_creation_date;

Line 2950: IF (nvl(l_delivery_info.EARLIEST_PICKUP_DATE, fnd_api.g_miss_date) <> nvl(l_earliest_mpickup_date, fnd_api.g_miss_date) OR

2946:
2947: --checking the value differences for the relevant critical fields
2948: --if any of the earliest/latest dates are changed and delivery is include for planning, then
2949: --update is needed
2950: IF (nvl(l_delivery_info.EARLIEST_PICKUP_DATE, fnd_api.g_miss_date) <> nvl(l_earliest_mpickup_date, fnd_api.g_miss_date) OR
2951: nvl(l_delivery_info.LATEST_PICKUP_DATE, fnd_api.g_miss_date) <> nvl(l_latest_mpickup_date, fnd_api.g_miss_date) OR
2952: nvl(l_delivery_info.EARLIEST_DROPOFF_DATE, fnd_api.g_miss_date) <> nvl(l_earliest_mdropoff_date, fnd_api.g_miss_date) OR
2953: nvl(l_delivery_info.LATEST_DROPOFF_DATE, fnd_api.g_miss_date) <> nvl(l_latest_mdropoff_date, fnd_api.g_miss_date)
2954: ) THEN--{

Line 2951: nvl(l_delivery_info.LATEST_PICKUP_DATE, fnd_api.g_miss_date) <> nvl(l_latest_mpickup_date, fnd_api.g_miss_date) OR

2947: --checking the value differences for the relevant critical fields
2948: --if any of the earliest/latest dates are changed and delivery is include for planning, then
2949: --update is needed
2950: IF (nvl(l_delivery_info.EARLIEST_PICKUP_DATE, fnd_api.g_miss_date) <> nvl(l_earliest_mpickup_date, fnd_api.g_miss_date) OR
2951: nvl(l_delivery_info.LATEST_PICKUP_DATE, fnd_api.g_miss_date) <> nvl(l_latest_mpickup_date, fnd_api.g_miss_date) OR
2952: nvl(l_delivery_info.EARLIEST_DROPOFF_DATE, fnd_api.g_miss_date) <> nvl(l_earliest_mdropoff_date, fnd_api.g_miss_date) OR
2953: nvl(l_delivery_info.LATEST_DROPOFF_DATE, fnd_api.g_miss_date) <> nvl(l_latest_mdropoff_date, fnd_api.g_miss_date)
2954: ) THEN--{
2955:

Line 2952: nvl(l_delivery_info.EARLIEST_DROPOFF_DATE, fnd_api.g_miss_date) <> nvl(l_earliest_mdropoff_date, fnd_api.g_miss_date) OR

2948: --if any of the earliest/latest dates are changed and delivery is include for planning, then
2949: --update is needed
2950: IF (nvl(l_delivery_info.EARLIEST_PICKUP_DATE, fnd_api.g_miss_date) <> nvl(l_earliest_mpickup_date, fnd_api.g_miss_date) OR
2951: nvl(l_delivery_info.LATEST_PICKUP_DATE, fnd_api.g_miss_date) <> nvl(l_latest_mpickup_date, fnd_api.g_miss_date) OR
2952: nvl(l_delivery_info.EARLIEST_DROPOFF_DATE, fnd_api.g_miss_date) <> nvl(l_earliest_mdropoff_date, fnd_api.g_miss_date) OR
2953: nvl(l_delivery_info.LATEST_DROPOFF_DATE, fnd_api.g_miss_date) <> nvl(l_latest_mdropoff_date, fnd_api.g_miss_date)
2954: ) THEN--{
2955:
2956: IF (NVL(l_delivery_info.tms_interface_flag, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT) IN

Line 2953: nvl(l_delivery_info.LATEST_DROPOFF_DATE, fnd_api.g_miss_date) <> nvl(l_latest_mdropoff_date, fnd_api.g_miss_date)

2949: --update is needed
2950: IF (nvl(l_delivery_info.EARLIEST_PICKUP_DATE, fnd_api.g_miss_date) <> nvl(l_earliest_mpickup_date, fnd_api.g_miss_date) OR
2951: nvl(l_delivery_info.LATEST_PICKUP_DATE, fnd_api.g_miss_date) <> nvl(l_latest_mpickup_date, fnd_api.g_miss_date) OR
2952: nvl(l_delivery_info.EARLIEST_DROPOFF_DATE, fnd_api.g_miss_date) <> nvl(l_earliest_mdropoff_date, fnd_api.g_miss_date) OR
2953: nvl(l_delivery_info.LATEST_DROPOFF_DATE, fnd_api.g_miss_date) <> nvl(l_latest_mdropoff_date, fnd_api.g_miss_date)
2954: ) THEN--{
2955:
2956: IF (NVL(l_delivery_info.tms_interface_flag, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT) IN
2957: (WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT,

Line 3440: l_validation_level NUMBER default FND_API.G_VALID_LEVEL_FULL;

3436: l_msg_count NUMBER;
3437: l_msg_data VARCHAR2(6000);
3438: l_exception_id NUMBER;
3439:
3440: l_validation_level NUMBER default FND_API.G_VALID_LEVEL_FULL;
3441:
3442:
3443: l_exception_message1 varchar2(2000);
3444: l_exception_message2 varchar2(2000);

Line 3477: p_init_msg_list => FND_API.G_FALSE,

3473: CLOSE c_del_location_id;
3474: IF l_location_id IS NOT NULL THEN
3475: WSH_XC_UTIL.log_exception(
3476: p_api_version => l_api_version,
3477: p_init_msg_list => FND_API.G_FALSE,
3478: p_commit => FND_API.G_FALSE,
3479: p_validation_level => l_validation_level,
3480: x_return_status => l_return_status,
3481: x_msg_count => l_msg_count,

Line 3478: p_commit => FND_API.G_FALSE,

3474: IF l_location_id IS NOT NULL THEN
3475: WSH_XC_UTIL.log_exception(
3476: p_api_version => l_api_version,
3477: p_init_msg_list => FND_API.G_FALSE,
3478: p_commit => FND_API.G_FALSE,
3479: p_validation_level => l_validation_level,
3480: x_return_status => l_return_status,
3481: x_msg_count => l_msg_count,
3482: x_msg_data => l_msg_data,

Line 3501: p_init_msg_list => FND_API.G_FALSE,

3497: CLOSE c_det_location_id;
3498: IF l_location_id IS NOT NULL THEN
3499: WSH_XC_UTIL.log_exception(
3500: p_api_version => l_api_version,
3501: p_init_msg_list => FND_API.G_FALSE,
3502: p_commit => FND_API.G_FALSE,
3503: p_validation_level => l_validation_level,
3504: x_return_status => l_return_status,
3505: x_msg_count => l_msg_count,

Line 3502: p_commit => FND_API.G_FALSE,

3498: IF l_location_id IS NOT NULL THEN
3499: WSH_XC_UTIL.log_exception(
3500: p_api_version => l_api_version,
3501: p_init_msg_list => FND_API.G_FALSE,
3502: p_commit => FND_API.G_FALSE,
3503: p_validation_level => l_validation_level,
3504: x_return_status => l_return_status,
3505: x_msg_count => l_msg_count,
3506: x_msg_data => l_msg_data,

Line 3557: l_validation_level NUMBER default FND_API.G_VALID_LEVEL_FULL;

3553: l_exception_name varchar2(30);
3554: l_exception_id NUMBER;
3555: l_location_id NUMBER;
3556: l_logging_entity VARCHAR2(50);
3557: l_validation_level NUMBER default FND_API.G_VALID_LEVEL_FULL;
3558: l_msg_count NUMBER;
3559: l_msg_data VARCHAR2(200);
3560: l_ignore_for_planning VARCHAR2 (1);
3561: l_return_status VARCHAR2(1);

Line 3604: p_init_msg_list => FND_API.G_FALSE,

3600: FND_MESSAGE.SET_TOKEN('ENTITY',l_delivery_detail_id);
3601: l_exception_message := FND_MESSAGE.GET;
3602: WSH_XC_UTIL.log_exception(
3603: p_api_version => l_api_version,
3604: p_init_msg_list => FND_API.G_FALSE,
3605: p_commit => FND_API.G_FALSE,
3606: p_validation_level => l_validation_level,
3607: x_return_status => l_return_status,
3608: x_msg_count => l_msg_count,

Line 3605: p_commit => FND_API.G_FALSE,

3601: l_exception_message := FND_MESSAGE.GET;
3602: WSH_XC_UTIL.log_exception(
3603: p_api_version => l_api_version,
3604: p_init_msg_list => FND_API.G_FALSE,
3605: p_commit => FND_API.G_FALSE,
3606: p_validation_level => l_validation_level,
3607: x_return_status => l_return_status,
3608: x_msg_count => l_msg_count,
3609: x_msg_data => l_msg_data,