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.INV_SHIPPING_TRANSACTION_PUB dependencies on WSH_DELIVERY_DETAILS_PUB

Line 846: l_detail_attributes WSH_DELIVERY_DETAILS_PUB.ChangedAttributeTabType;

842: x_return_status OUT NOCOPY VARCHAR2,
843: x_msg_data OUT NOCOPY VARCHAR2,
844: x_msg_count OUT NOCOPY NUMBER) IS
845: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
846: l_detail_attributes WSH_DELIVERY_DETAILS_PUB.ChangedAttributeTabType;
847: l_details VARCHAR2(2000);
848: BEGIN
849:
850: --null;

Line 861: 'wsh_delivery_details_pub.update_shipping_attributes', 'INV_DELAY_SHIPMENT');

857: l_detail_attributes(1).delivery_detail_id := p_delivery_line_id;
858:
859: IF l_debug = 1 THEN
860: debug('About to call Shipping ' ||
861: 'wsh_delivery_details_pub.update_shipping_attributes', 'INV_DELAY_SHIPMENT');
862: END IF;
863:
864: wsh_delivery_details_pub.update_shipping_attributes
865: (p_api_version_number => 1.0,

Line 864: wsh_delivery_details_pub.update_shipping_attributes

860: debug('About to call Shipping ' ||
861: 'wsh_delivery_details_pub.update_shipping_attributes', 'INV_DELAY_SHIPMENT');
862: END IF;
863:
864: wsh_delivery_details_pub.update_shipping_attributes
865: (p_api_version_number => 1.0,
866: p_init_msg_list => G_TRUE,
867: p_commit => G_FALSE,
868: x_return_status => x_return_status,

Line 876: debug('wsh_delivery_details_pub.update_shipping_attributes failed'

872: p_source_code => 'OE');
873:
874: IF x_return_status <> G_RET_STS_SUCCESS THEN
875: IF l_debug = 1 THEN
876: debug('wsh_delivery_details_pub.update_shipping_attributes failed'
877: || ' with status: ' || x_return_status, 'INV_DELAY_SHIPMENT');
878: END IF;
879: RAISE fnd_api.g_exc_unexpected_error;
880: END IF;

Line 930: l_detail_attributes wsh_delivery_details_pub.ChangedAttributeTabType;

926: l_requested_quantities_table WSH_UTIL_CORE.ID_TAB_TYPE;
927: l_overpicked_quantities_table WSH_UTIL_CORE.ID_TAB_TYPE;
928: l_dummy_table wsh_util_core.id_tab_type;
929: l_out_rows wsh_util_core.id_tab_type;
930: l_detail_attributes wsh_delivery_details_pub.ChangedAttributeTabType;
931: l_dummy_num_var NUMBER := NULL;
932: l_table_index NUMBER := 1;
933:
934: l_picked_quantity NUMBER;

Line 1090: WSH_DELIVERY_DETAILS_PUB.split_line

1086: || ' requested : ' || l_requested_quantities_table(1)
1087: , 'INV_LINE_RETURN_TO_STOCK');
1088: END IF;
1089:
1090: WSH_DELIVERY_DETAILS_PUB.split_line
1091: (p_api_version => 1.0,
1092: p_init_msg_list => fnd_api.g_false,
1093: p_commit => p_commit_flag,
1094: x_return_status => l_return_status,

Line 1104: debug('WSH_DELIVERY_DETAILS_PUB.split_line failed',

1100: x_split_quantity2 => l_dummy_num_var);
1101:
1102: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1103: IF l_debug = 1 THEN
1104: debug('WSH_DELIVERY_DETAILS_PUB.split_line failed',
1105: 'INV_LINE_RETURN_TO_STOCK');
1106: END IF;
1107:
1108: RAISE fnd_api.g_exc_unexpected_error;

Line 1115: wsh_delivery_details_pub.update_shipping_attributes

1111: l_detail_attributes(1).delivery_detail_id :=
1112: l_delivery_details_id_table(1);
1113: l_detail_attributes(1).shipped_quantity := p_shipped_quantity;
1114:
1115: wsh_delivery_details_pub.update_shipping_attributes
1116: (p_api_version_number => 1.0,
1117: p_init_msg_list => fnd_api.g_false,
1118: p_commit => p_commit_flag,
1119: x_return_status => l_return_status,

Line 1127: debug('wsh_delivery_details_pub.update_shipping_attributesfailed',

1123: p_source_code => 'OE');
1124:
1125: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1126: IF l_debug = 1 THEN
1127: debug('wsh_delivery_details_pub.update_shipping_attributesfailed',
1128: 'INV_LINE_RETURN_TO_STOCK');
1129: END IF;
1130:
1131: RAISE fnd_api.g_exc_unexpected_error;

Line 1252: l_detail_attributes wsh_delivery_details_pub.ChangedAttributeTabType;

1248: l_sec_req_qtys_table WSH_UTIL_CORE.ID_TAB_TYPE;
1249: l_sec_ovpk_qtys_table WSH_UTIL_CORE.ID_TAB_TYPE;
1250: l_dummy_table wsh_util_core.id_tab_type;
1251: l_out_rows wsh_util_core.id_tab_type;
1252: l_detail_attributes wsh_delivery_details_pub.ChangedAttributeTabType;
1253: l_dummy_num_var NUMBER := NULL;
1254: l_table_index NUMBER := 1;
1255:
1256: l_picked_quantity NUMBER;

Line 1365: WSH_DELIVERY_DETAILS_PUB.split_line

1361: || ' requested : ' || l_requested_quantities_table(1)
1362: , 'INV_LINE_RETURN_TO_STOCK');
1363: END IF;
1364:
1365: WSH_DELIVERY_DETAILS_PUB.split_line
1366: (p_api_version => 1.0,
1367: p_init_msg_list => fnd_api.g_false,
1368: p_commit => p_commit_flag,
1369: x_return_status => l_return_status,

Line 1379: debug('WSH_DELIVERY_DETAILS_PUB.split_line failed',

1375: x_split_quantity2 => l_sec_bck_qtys_table(1));
1376:
1377: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1378: IF l_debug = 1 THEN
1379: debug('WSH_DELIVERY_DETAILS_PUB.split_line failed',
1380: 'INV_LINE_RETURN_TO_STOCK');
1381: END IF;
1382:
1383: RAISE fnd_api.g_exc_unexpected_error;

Line 1393: wsh_delivery_details_pub.update_shipping_attributes

1389:
1390: /* set secondary shipped quantity into the delivery details attribute set */
1391: l_detail_attributes(1).shipped_quantity2 := p_sec_shipped_quantity;
1392:
1393: wsh_delivery_details_pub.update_shipping_attributes
1394: (p_api_version_number => 1.0,
1395: p_init_msg_list => fnd_api.g_false,
1396: p_commit => p_commit_flag,
1397: x_return_status => l_return_status,

Line 1405: debug('wsh_delivery_details_pub.update_shipping_attributesfailed',

1401: p_source_code => 'OE');
1402:
1403: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1404: IF l_debug = 1 THEN
1405: debug('wsh_delivery_details_pub.update_shipping_attributesfailed',
1406: 'INV_LINE_RETURN_TO_STOCK');
1407: END IF;
1408:
1409: RAISE fnd_api.g_exc_unexpected_error;

Line 1480: l_detail_attributes WSH_DELIVERY_DETAILS_PUB.ChangedAttributeTabType;

1476: x_return_status OUT NOCOPY VARCHAR2,
1477: x_msg_data OUT NOCOPY VARCHAR2,
1478: x_msg_count OUT NOCOPY NUMBER) IS
1479: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1480: l_detail_attributes WSH_DELIVERY_DETAILS_PUB.ChangedAttributeTabType;
1481: l_details VARCHAR2(2000);
1482: BEGIN
1483: l_detail_attributes(1).cycle_count_quantity := p_missing_quantity;
1484: l_detail_attributes(1).delivery_detail_id := p_delivery_line_id;

Line 1487: debug('About to call wsh_delivery_details_pub.update_shipping_attributes',

1483: l_detail_attributes(1).cycle_count_quantity := p_missing_quantity;
1484: l_detail_attributes(1).delivery_detail_id := p_delivery_line_id;
1485:
1486: IF l_debug = 1 THEN
1487: debug('About to call wsh_delivery_details_pub.update_shipping_attributes',
1488: 'INV_REPORT_MISSING_QTY');
1489: END IF;
1490: wsh_delivery_details_pub.update_shipping_attributes
1491: (p_api_version_number => 1.0,

Line 1490: wsh_delivery_details_pub.update_shipping_attributes

1486: IF l_debug = 1 THEN
1487: debug('About to call wsh_delivery_details_pub.update_shipping_attributes',
1488: 'INV_REPORT_MISSING_QTY');
1489: END IF;
1490: wsh_delivery_details_pub.update_shipping_attributes
1491: (p_api_version_number => 1.0,
1492: p_init_msg_list => G_TRUE,
1493: p_commit => G_FALSE,
1494: x_return_status => x_return_status,

Line 1502: debug('wsh_delivery_details_pub.update_shipping_attributes failed'

1498: p_source_code => 'OE');
1499:
1500: IF x_return_status <> G_RET_STS_SUCCESS THEN
1501: IF l_debug = 1 THEN
1502: debug('wsh_delivery_details_pub.update_shipping_attributes failed'
1503: || ' with status: ' || x_return_status, 'INV_REPORT_MISSING_QTY');
1504: END IF;
1505: RAISE fnd_api.g_exc_unexpected_error;
1506: END IF;

Line 1534: l_detail_attributes WSH_DELIVERY_DETAILS_PUB.ChangedAttributeTabType;

1530: x_return_status OUT NOCOPY VARCHAR2,
1531: x_msg_data OUT NOCOPY VARCHAR2,
1532: x_msg_count OUT NOCOPY NUMBER) IS
1533: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1534: l_detail_attributes WSH_DELIVERY_DETAILS_PUB.ChangedAttributeTabType;
1535: l_details VARCHAR2(2000);
1536: BEGIN
1537: l_detail_attributes(1).cycle_count_quantity := p_missing_quantity;
1538:

Line 1550: debug('About to call wsh_delivery_details_pub.update_shipping_attributes',

1546: 'INV_REPORT_MISSING_QTY');
1547: END IF;
1548:
1549: IF l_debug = 1 THEN
1550: debug('About to call wsh_delivery_details_pub.update_shipping_attributes',
1551: 'INV_REPORT_MISSING_QTY');
1552: END IF;
1553: wsh_delivery_details_pub.update_shipping_attributes
1554: (p_api_version_number => 1.0,

Line 1553: wsh_delivery_details_pub.update_shipping_attributes

1549: IF l_debug = 1 THEN
1550: debug('About to call wsh_delivery_details_pub.update_shipping_attributes',
1551: 'INV_REPORT_MISSING_QTY');
1552: END IF;
1553: wsh_delivery_details_pub.update_shipping_attributes
1554: (p_api_version_number => 1.0,
1555: p_init_msg_list => G_TRUE,
1556: p_commit => G_FALSE,
1557: x_return_status => x_return_status,

Line 1565: debug('wsh_delivery_details_pub.update_shipping_attributes failed'

1561: p_source_code => 'OE');
1562:
1563: IF x_return_status <> G_RET_STS_SUCCESS THEN
1564: IF l_debug = 1 THEN
1565: debug('wsh_delivery_details_pub.update_shipping_attributes failed'
1566: || ' with status: ' || x_return_status, 'INV_REPORT_MISSING_QTY');
1567: END IF;
1568: RAISE fnd_api.g_exc_unexpected_error;
1569: END IF;

Line 1591: l_detail_attributes WSH_DELIVERY_DETAILS_PUB.ChangedAttributeTabType;

1587: x_return_status OUT NOCOPY VARCHAR2,
1588: x_msg_data OUT NOCOPY VARCHAR2,
1589: x_msg_count OUT NOCOPY NUMBER ) IS
1590: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1591: l_detail_attributes WSH_DELIVERY_DETAILS_PUB.ChangedAttributeTabType;
1592:
1593:
1594: l_details VARCHAR2(2000);
1595:

Line 1663: debug('About to call wsh_delivery_details_pub.update_shipping_attributes',

1659:
1660: l_detail_attributes(1).delivery_detail_id := p_delivery_line_id;
1661:
1662: IF l_debug = 1 THEN
1663: debug('About to call wsh_delivery_details_pub.update_shipping_attributes',
1664: 'SUBMIT_DELIVERY_LINE');
1665: END IF;
1666:
1667: wsh_delivery_details_pub.update_shipping_attributes

Line 1667: wsh_delivery_details_pub.update_shipping_attributes

1663: debug('About to call wsh_delivery_details_pub.update_shipping_attributes',
1664: 'SUBMIT_DELIVERY_LINE');
1665: END IF;
1666:
1667: wsh_delivery_details_pub.update_shipping_attributes
1668: (p_api_version_number => 1.0,
1669: p_init_msg_list => G_TRUE,
1670: p_commit => G_TRUE,
1671: x_return_status => x_return_status,

Line 1683: debug('wsh_delivery_details_pub.update_shipping_attributes failed'

1679: END IF;
1680:
1681: IF x_return_status <> G_RET_STS_SUCCESS THEN
1682: IF l_debug = 1 THEN
1683: debug('wsh_delivery_details_pub.update_shipping_attributes failed'
1684: || ' with status: ' || x_return_status, 'SUBMIT_DELIVERY_LINE');
1685: END IF;
1686: RAISE fnd_api.g_exc_unexpected_error;
1687: END IF;

Line 1716: l_detail_attributes WSH_DELIVERY_DETAILS_PUB.ChangedAttributeTabType;

1712: x_return_status OUT NOCOPY VARCHAR2,
1713: x_msg_data OUT NOCOPY VARCHAR2,
1714: x_msg_count OUT NOCOPY NUMBER ) IS
1715: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1716: l_detail_attributes WSH_DELIVERY_DETAILS_PUB.ChangedAttributeTabType;
1717:
1718:
1719: l_details VARCHAR2(2000);
1720:

Line 1797: debug('About to call wsh_delivery_details_pub.update_shipping_attributes',

1793:
1794: l_detail_attributes(1).delivery_detail_id := p_delivery_line_id;
1795:
1796: IF l_debug = 1 THEN
1797: debug('About to call wsh_delivery_details_pub.update_shipping_attributes',
1798: 'SUBMIT_DELIVERY_LINE');
1799: END IF;
1800:
1801: wsh_delivery_details_pub.update_shipping_attributes

Line 1801: wsh_delivery_details_pub.update_shipping_attributes

1797: debug('About to call wsh_delivery_details_pub.update_shipping_attributes',
1798: 'SUBMIT_DELIVERY_LINE');
1799: END IF;
1800:
1801: wsh_delivery_details_pub.update_shipping_attributes
1802: (p_api_version_number => 1.0,
1803: p_init_msg_list => G_TRUE,
1804: p_commit => G_TRUE,
1805: x_return_status => x_return_status,

Line 1817: debug('wsh_delivery_details_pub.update_shipping_attributes failed'

1813: END IF;
1814:
1815: IF x_return_status <> G_RET_STS_SUCCESS THEN
1816: IF l_debug = 1 THEN
1817: debug('wsh_delivery_details_pub.update_shipping_attributes failed'
1818: || ' with status: ' || x_return_status, 'SUBMIT_DELIVERY_LINE');
1819: END IF;
1820: RAISE fnd_api.g_exc_unexpected_error;
1821: END IF;