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 845: l_detail_attributes WSH_DELIVERY_DETAILS_PUB.ChangedAttributeTabType;

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

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

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

Line 863: wsh_delivery_details_pub.update_shipping_attributes

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

Line 875: debug('wsh_delivery_details_pub.update_shipping_attributes failed'

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

Line 929: l_detail_attributes wsh_delivery_details_pub.ChangedAttributeTabType;

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

Line 1071: WSH_DELIVERY_DETAILS_PUB.split_line

1067: || ' requested : ' || l_requested_quantities_table(1)
1068: , 'INV_LINE_RETURN_TO_STOCK');
1069: END IF;
1070:
1071: WSH_DELIVERY_DETAILS_PUB.split_line
1072: (p_api_version => 1.0,
1073: p_init_msg_list => fnd_api.g_false,
1074: p_commit => p_commit_flag,
1075: x_return_status => l_return_status,

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

1081: x_split_quantity2 => l_dummy_num_var);
1082:
1083: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1084: IF l_debug = 1 THEN
1085: debug('WSH_DELIVERY_DETAILS_PUB.split_line failed',
1086: 'INV_LINE_RETURN_TO_STOCK');
1087: END IF;
1088:
1089: RAISE fnd_api.g_exc_unexpected_error;

Line 1096: wsh_delivery_details_pub.update_shipping_attributes

1092: l_detail_attributes(1).delivery_detail_id :=
1093: l_delivery_details_id_table(1);
1094: l_detail_attributes(1).shipped_quantity := p_shipped_quantity;
1095:
1096: wsh_delivery_details_pub.update_shipping_attributes
1097: (p_api_version_number => 1.0,
1098: p_init_msg_list => fnd_api.g_false,
1099: p_commit => p_commit_flag,
1100: x_return_status => l_return_status,

Line 1108: debug('wsh_delivery_details_pub.update_shipping_attributesfailed',

1104: p_source_code => 'OE');
1105:
1106: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1107: IF l_debug = 1 THEN
1108: debug('wsh_delivery_details_pub.update_shipping_attributesfailed',
1109: 'INV_LINE_RETURN_TO_STOCK');
1110: END IF;
1111:
1112: RAISE fnd_api.g_exc_unexpected_error;

Line 1233: l_detail_attributes wsh_delivery_details_pub.ChangedAttributeTabType;

1229: l_sec_req_qtys_table WSH_UTIL_CORE.ID_TAB_TYPE;
1230: l_sec_ovpk_qtys_table WSH_UTIL_CORE.ID_TAB_TYPE;
1231: l_dummy_table wsh_util_core.id_tab_type;
1232: l_out_rows wsh_util_core.id_tab_type;
1233: l_detail_attributes wsh_delivery_details_pub.ChangedAttributeTabType;
1234: l_dummy_num_var NUMBER := NULL;
1235: l_table_index NUMBER := 1;
1236:
1237: l_picked_quantity NUMBER;

Line 1346: WSH_DELIVERY_DETAILS_PUB.split_line

1342: || ' requested : ' || l_requested_quantities_table(1)
1343: , 'INV_LINE_RETURN_TO_STOCK');
1344: END IF;
1345:
1346: WSH_DELIVERY_DETAILS_PUB.split_line
1347: (p_api_version => 1.0,
1348: p_init_msg_list => fnd_api.g_false,
1349: p_commit => p_commit_flag,
1350: x_return_status => l_return_status,

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

1356: x_split_quantity2 => l_sec_bck_qtys_table(1));
1357:
1358: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1359: IF l_debug = 1 THEN
1360: debug('WSH_DELIVERY_DETAILS_PUB.split_line failed',
1361: 'INV_LINE_RETURN_TO_STOCK');
1362: END IF;
1363:
1364: RAISE fnd_api.g_exc_unexpected_error;

Line 1374: wsh_delivery_details_pub.update_shipping_attributes

1370:
1371: /* set secondary shipped quantity into the delivery details attribute set */
1372: l_detail_attributes(1).shipped_quantity2 := p_sec_shipped_quantity;
1373:
1374: wsh_delivery_details_pub.update_shipping_attributes
1375: (p_api_version_number => 1.0,
1376: p_init_msg_list => fnd_api.g_false,
1377: p_commit => p_commit_flag,
1378: x_return_status => l_return_status,

Line 1386: debug('wsh_delivery_details_pub.update_shipping_attributesfailed',

1382: p_source_code => 'OE');
1383:
1384: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1385: IF l_debug = 1 THEN
1386: debug('wsh_delivery_details_pub.update_shipping_attributesfailed',
1387: 'INV_LINE_RETURN_TO_STOCK');
1388: END IF;
1389:
1390: RAISE fnd_api.g_exc_unexpected_error;

Line 1461: l_detail_attributes WSH_DELIVERY_DETAILS_PUB.ChangedAttributeTabType;

1457: x_return_status OUT NOCOPY VARCHAR2,
1458: x_msg_data OUT NOCOPY VARCHAR2,
1459: x_msg_count OUT NOCOPY NUMBER) IS
1460: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1461: l_detail_attributes WSH_DELIVERY_DETAILS_PUB.ChangedAttributeTabType;
1462: l_details VARCHAR2(2000);
1463: BEGIN
1464: l_detail_attributes(1).cycle_count_quantity := p_missing_quantity;
1465: l_detail_attributes(1).delivery_detail_id := p_delivery_line_id;

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

1464: l_detail_attributes(1).cycle_count_quantity := p_missing_quantity;
1465: l_detail_attributes(1).delivery_detail_id := p_delivery_line_id;
1466:
1467: IF l_debug = 1 THEN
1468: debug('About to call wsh_delivery_details_pub.update_shipping_attributes',
1469: 'INV_REPORT_MISSING_QTY');
1470: END IF;
1471: wsh_delivery_details_pub.update_shipping_attributes
1472: (p_api_version_number => 1.0,

Line 1471: wsh_delivery_details_pub.update_shipping_attributes

1467: IF l_debug = 1 THEN
1468: debug('About to call wsh_delivery_details_pub.update_shipping_attributes',
1469: 'INV_REPORT_MISSING_QTY');
1470: END IF;
1471: wsh_delivery_details_pub.update_shipping_attributes
1472: (p_api_version_number => 1.0,
1473: p_init_msg_list => G_TRUE,
1474: p_commit => G_FALSE,
1475: x_return_status => x_return_status,

Line 1483: debug('wsh_delivery_details_pub.update_shipping_attributes failed'

1479: p_source_code => 'OE');
1480:
1481: IF x_return_status <> G_RET_STS_SUCCESS THEN
1482: IF l_debug = 1 THEN
1483: debug('wsh_delivery_details_pub.update_shipping_attributes failed'
1484: || ' with status: ' || x_return_status, 'INV_REPORT_MISSING_QTY');
1485: END IF;
1486: RAISE fnd_api.g_exc_unexpected_error;
1487: END IF;

Line 1515: l_detail_attributes WSH_DELIVERY_DETAILS_PUB.ChangedAttributeTabType;

1511: x_return_status OUT NOCOPY VARCHAR2,
1512: x_msg_data OUT NOCOPY VARCHAR2,
1513: x_msg_count OUT NOCOPY NUMBER) IS
1514: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1515: l_detail_attributes WSH_DELIVERY_DETAILS_PUB.ChangedAttributeTabType;
1516: l_details VARCHAR2(2000);
1517: BEGIN
1518: l_detail_attributes(1).cycle_count_quantity := p_missing_quantity;
1519:

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

1527: 'INV_REPORT_MISSING_QTY');
1528: END IF;
1529:
1530: IF l_debug = 1 THEN
1531: debug('About to call wsh_delivery_details_pub.update_shipping_attributes',
1532: 'INV_REPORT_MISSING_QTY');
1533: END IF;
1534: wsh_delivery_details_pub.update_shipping_attributes
1535: (p_api_version_number => 1.0,

Line 1534: wsh_delivery_details_pub.update_shipping_attributes

1530: IF l_debug = 1 THEN
1531: debug('About to call wsh_delivery_details_pub.update_shipping_attributes',
1532: 'INV_REPORT_MISSING_QTY');
1533: END IF;
1534: wsh_delivery_details_pub.update_shipping_attributes
1535: (p_api_version_number => 1.0,
1536: p_init_msg_list => G_TRUE,
1537: p_commit => G_FALSE,
1538: x_return_status => x_return_status,

Line 1546: debug('wsh_delivery_details_pub.update_shipping_attributes failed'

1542: p_source_code => 'OE');
1543:
1544: IF x_return_status <> G_RET_STS_SUCCESS THEN
1545: IF l_debug = 1 THEN
1546: debug('wsh_delivery_details_pub.update_shipping_attributes failed'
1547: || ' with status: ' || x_return_status, 'INV_REPORT_MISSING_QTY');
1548: END IF;
1549: RAISE fnd_api.g_exc_unexpected_error;
1550: END IF;

Line 1572: l_detail_attributes WSH_DELIVERY_DETAILS_PUB.ChangedAttributeTabType;

1568: x_return_status OUT NOCOPY VARCHAR2,
1569: x_msg_data OUT NOCOPY VARCHAR2,
1570: x_msg_count OUT NOCOPY NUMBER ) IS
1571: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1572: l_detail_attributes WSH_DELIVERY_DETAILS_PUB.ChangedAttributeTabType;
1573:
1574:
1575: l_details VARCHAR2(2000);
1576:

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

1640:
1641: l_detail_attributes(1).delivery_detail_id := p_delivery_line_id;
1642:
1643: IF l_debug = 1 THEN
1644: debug('About to call wsh_delivery_details_pub.update_shipping_attributes',
1645: 'SUBMIT_DELIVERY_LINE');
1646: END IF;
1647:
1648: wsh_delivery_details_pub.update_shipping_attributes

Line 1648: wsh_delivery_details_pub.update_shipping_attributes

1644: debug('About to call wsh_delivery_details_pub.update_shipping_attributes',
1645: 'SUBMIT_DELIVERY_LINE');
1646: END IF;
1647:
1648: wsh_delivery_details_pub.update_shipping_attributes
1649: (p_api_version_number => 1.0,
1650: p_init_msg_list => G_TRUE,
1651: p_commit => G_TRUE,
1652: x_return_status => x_return_status,

Line 1664: debug('wsh_delivery_details_pub.update_shipping_attributes failed'

1660: END IF;
1661:
1662: IF x_return_status <> G_RET_STS_SUCCESS THEN
1663: IF l_debug = 1 THEN
1664: debug('wsh_delivery_details_pub.update_shipping_attributes failed'
1665: || ' with status: ' || x_return_status, 'SUBMIT_DELIVERY_LINE');
1666: END IF;
1667: RAISE fnd_api.g_exc_unexpected_error;
1668: END IF;

Line 1697: l_detail_attributes WSH_DELIVERY_DETAILS_PUB.ChangedAttributeTabType;

1693: x_return_status OUT NOCOPY VARCHAR2,
1694: x_msg_data OUT NOCOPY VARCHAR2,
1695: x_msg_count OUT NOCOPY NUMBER ) IS
1696: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1697: l_detail_attributes WSH_DELIVERY_DETAILS_PUB.ChangedAttributeTabType;
1698:
1699:
1700: l_details VARCHAR2(2000);
1701:

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

1774:
1775: l_detail_attributes(1).delivery_detail_id := p_delivery_line_id;
1776:
1777: IF l_debug = 1 THEN
1778: debug('About to call wsh_delivery_details_pub.update_shipping_attributes',
1779: 'SUBMIT_DELIVERY_LINE');
1780: END IF;
1781:
1782: wsh_delivery_details_pub.update_shipping_attributes

Line 1782: wsh_delivery_details_pub.update_shipping_attributes

1778: debug('About to call wsh_delivery_details_pub.update_shipping_attributes',
1779: 'SUBMIT_DELIVERY_LINE');
1780: END IF;
1781:
1782: wsh_delivery_details_pub.update_shipping_attributes
1783: (p_api_version_number => 1.0,
1784: p_init_msg_list => G_TRUE,
1785: p_commit => G_TRUE,
1786: x_return_status => x_return_status,

Line 1798: debug('wsh_delivery_details_pub.update_shipping_attributes failed'

1794: END IF;
1795:
1796: IF x_return_status <> G_RET_STS_SUCCESS THEN
1797: IF l_debug = 1 THEN
1798: debug('wsh_delivery_details_pub.update_shipping_attributes failed'
1799: || ' with status: ' || x_return_status, 'SUBMIT_DELIVERY_LINE');
1800: END IF;
1801: RAISE fnd_api.g_exc_unexpected_error;
1802: END IF;