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 694: IF (nvl(l_wh_type, FND_API.G_MISS_CHAR) IN ('TPW','CMS')) THEN

690: p_delivery_id => p_in_ids(i),
691: p_msg_display => 'N');
692:
693:
694: IF (nvl(l_wh_type, FND_API.G_MISS_CHAR) IN ('TPW','CMS')) THEN
695: IF l_debug_on THEN
696: 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);
697: END IF;
698:

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

1207: p_delivery_detail_id => p_in_ids(i),
1208: p_msg_display => 'N');
1209:
1210: -- 5746444: disable this condition when OTM is installed
1211: IF (nvl(l_wh_type, FND_API.G_MISS_CHAR) IN ('TPW','CMS'))
1212: OR (cur.source_code='WSH' and cur.container_flag='N'
1213: and l_gc3_is_installed = 'N' )
1214: THEN
1215: IF l_debug_on THEN

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

2230: l_request_date_type := 'SHIP';
2231: ELSE
2232: l_request_date_type := p_request_date_type;
2233: END IF;
2234: IF (p_organization_id IS NULL OR p_organization_id = FND_API.G_MISS_NUM)
2235: OR (p_inventory_item_id IS NULL OR p_inventory_item_id = FND_API.G_MISS_NUM) THEN
2236:
2237: OPEN c_dd_item_id(p_source_line_id,p_source_code);
2238: FETCH c_dd_item_id INTO l_organization_id,l_inventory_item_id,

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

2231: ELSE
2232: l_request_date_type := p_request_date_type;
2233: END IF;
2234: IF (p_organization_id IS NULL OR p_organization_id = FND_API.G_MISS_NUM)
2235: OR (p_inventory_item_id IS NULL OR p_inventory_item_id = FND_API.G_MISS_NUM) THEN
2236:
2237: OPEN c_dd_item_id(p_source_line_id,p_source_code);
2238: FETCH c_dd_item_id INTO l_organization_id,l_inventory_item_id,
2239: l_delivery_detail_id,l_split_delivery_detail_id,l_creation_date;

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

3093:
3094: --checking the value differences for the relevant critical fields
3095: --if any of the earliest/latest dates are changed and delivery is include for planning, then
3096: --update is needed
3097: IF (nvl(l_delivery_info.EARLIEST_PICKUP_DATE, fnd_api.g_miss_date) <> nvl(l_earliest_mpickup_date, fnd_api.g_miss_date) OR
3098: nvl(l_delivery_info.LATEST_PICKUP_DATE, fnd_api.g_miss_date) <> nvl(l_latest_mpickup_date, fnd_api.g_miss_date) OR
3099: nvl(l_delivery_info.EARLIEST_DROPOFF_DATE, fnd_api.g_miss_date) <> nvl(l_earliest_mdropoff_date, fnd_api.g_miss_date) OR
3100: nvl(l_delivery_info.LATEST_DROPOFF_DATE, fnd_api.g_miss_date) <> nvl(l_latest_mdropoff_date, fnd_api.g_miss_date)
3101: ) THEN--{

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

3094: --checking the value differences for the relevant critical fields
3095: --if any of the earliest/latest dates are changed and delivery is include for planning, then
3096: --update is needed
3097: IF (nvl(l_delivery_info.EARLIEST_PICKUP_DATE, fnd_api.g_miss_date) <> nvl(l_earliest_mpickup_date, fnd_api.g_miss_date) OR
3098: nvl(l_delivery_info.LATEST_PICKUP_DATE, fnd_api.g_miss_date) <> nvl(l_latest_mpickup_date, fnd_api.g_miss_date) OR
3099: nvl(l_delivery_info.EARLIEST_DROPOFF_DATE, fnd_api.g_miss_date) <> nvl(l_earliest_mdropoff_date, fnd_api.g_miss_date) OR
3100: nvl(l_delivery_info.LATEST_DROPOFF_DATE, fnd_api.g_miss_date) <> nvl(l_latest_mdropoff_date, fnd_api.g_miss_date)
3101: ) THEN--{
3102:

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

3095: --if any of the earliest/latest dates are changed and delivery is include for planning, then
3096: --update is needed
3097: IF (nvl(l_delivery_info.EARLIEST_PICKUP_DATE, fnd_api.g_miss_date) <> nvl(l_earliest_mpickup_date, fnd_api.g_miss_date) OR
3098: nvl(l_delivery_info.LATEST_PICKUP_DATE, fnd_api.g_miss_date) <> nvl(l_latest_mpickup_date, fnd_api.g_miss_date) OR
3099: nvl(l_delivery_info.EARLIEST_DROPOFF_DATE, fnd_api.g_miss_date) <> nvl(l_earliest_mdropoff_date, fnd_api.g_miss_date) OR
3100: nvl(l_delivery_info.LATEST_DROPOFF_DATE, fnd_api.g_miss_date) <> nvl(l_latest_mdropoff_date, fnd_api.g_miss_date)
3101: ) THEN--{
3102:
3103: IF (NVL(l_delivery_info.tms_interface_flag, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT) IN

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

3096: --update is needed
3097: IF (nvl(l_delivery_info.EARLIEST_PICKUP_DATE, fnd_api.g_miss_date) <> nvl(l_earliest_mpickup_date, fnd_api.g_miss_date) OR
3098: nvl(l_delivery_info.LATEST_PICKUP_DATE, fnd_api.g_miss_date) <> nvl(l_latest_mpickup_date, fnd_api.g_miss_date) OR
3099: nvl(l_delivery_info.EARLIEST_DROPOFF_DATE, fnd_api.g_miss_date) <> nvl(l_earliest_mdropoff_date, fnd_api.g_miss_date) OR
3100: nvl(l_delivery_info.LATEST_DROPOFF_DATE, fnd_api.g_miss_date) <> nvl(l_latest_mdropoff_date, fnd_api.g_miss_date)
3101: ) THEN--{
3102:
3103: IF (NVL(l_delivery_info.tms_interface_flag, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT) IN
3104: (WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT,

Line 3587: l_validation_level NUMBER default FND_API.G_VALID_LEVEL_FULL;

3583: l_msg_count NUMBER;
3584: l_msg_data VARCHAR2(6000);
3585: l_exception_id NUMBER;
3586:
3587: l_validation_level NUMBER default FND_API.G_VALID_LEVEL_FULL;
3588:
3589:
3590: l_exception_message1 varchar2(2000);
3591: l_exception_message2 varchar2(2000);

Line 3624: p_init_msg_list => FND_API.G_FALSE,

3620: CLOSE c_del_location_id;
3621: IF l_location_id IS NOT NULL THEN
3622: WSH_XC_UTIL.log_exception(
3623: p_api_version => l_api_version,
3624: p_init_msg_list => FND_API.G_FALSE,
3625: p_commit => FND_API.G_FALSE,
3626: p_validation_level => l_validation_level,
3627: x_return_status => l_return_status,
3628: x_msg_count => l_msg_count,

Line 3625: p_commit => FND_API.G_FALSE,

3621: IF l_location_id IS NOT NULL THEN
3622: WSH_XC_UTIL.log_exception(
3623: p_api_version => l_api_version,
3624: p_init_msg_list => FND_API.G_FALSE,
3625: p_commit => FND_API.G_FALSE,
3626: p_validation_level => l_validation_level,
3627: x_return_status => l_return_status,
3628: x_msg_count => l_msg_count,
3629: x_msg_data => l_msg_data,

Line 3648: p_init_msg_list => FND_API.G_FALSE,

3644: CLOSE c_det_location_id;
3645: IF l_location_id IS NOT NULL THEN
3646: WSH_XC_UTIL.log_exception(
3647: p_api_version => l_api_version,
3648: p_init_msg_list => FND_API.G_FALSE,
3649: p_commit => FND_API.G_FALSE,
3650: p_validation_level => l_validation_level,
3651: x_return_status => l_return_status,
3652: x_msg_count => l_msg_count,

Line 3649: p_commit => FND_API.G_FALSE,

3645: IF l_location_id IS NOT NULL THEN
3646: WSH_XC_UTIL.log_exception(
3647: p_api_version => l_api_version,
3648: p_init_msg_list => FND_API.G_FALSE,
3649: p_commit => FND_API.G_FALSE,
3650: p_validation_level => l_validation_level,
3651: x_return_status => l_return_status,
3652: x_msg_count => l_msg_count,
3653: x_msg_data => l_msg_data,

Line 3704: l_validation_level NUMBER default FND_API.G_VALID_LEVEL_FULL;

3700: l_exception_name varchar2(30);
3701: l_exception_id NUMBER;
3702: l_location_id NUMBER;
3703: l_logging_entity VARCHAR2(50);
3704: l_validation_level NUMBER default FND_API.G_VALID_LEVEL_FULL;
3705: l_msg_count NUMBER;
3706: l_msg_data VARCHAR2(200);
3707: l_ignore_for_planning VARCHAR2 (1);
3708: l_return_status VARCHAR2(1);

Line 3751: p_init_msg_list => FND_API.G_FALSE,

3747: FND_MESSAGE.SET_TOKEN('ENTITY',l_delivery_detail_id);
3748: l_exception_message := FND_MESSAGE.GET;
3749: WSH_XC_UTIL.log_exception(
3750: p_api_version => l_api_version,
3751: p_init_msg_list => FND_API.G_FALSE,
3752: p_commit => FND_API.G_FALSE,
3753: p_validation_level => l_validation_level,
3754: x_return_status => l_return_status,
3755: x_msg_count => l_msg_count,

Line 3752: p_commit => FND_API.G_FALSE,

3748: l_exception_message := FND_MESSAGE.GET;
3749: WSH_XC_UTIL.log_exception(
3750: p_api_version => l_api_version,
3751: p_init_msg_list => FND_API.G_FALSE,
3752: p_commit => FND_API.G_FALSE,
3753: p_validation_level => l_validation_level,
3754: x_return_status => l_return_status,
3755: x_msg_count => l_msg_count,
3756: x_msg_data => l_msg_data,