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.

[Home] [Help]

APPS.INV_SHIPPING_TRANSACTION_PUB dependencies on FND_PROFILE

Line 20: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

16:
17:
18: PROCEDURE DEBUG(p_message IN VARCHAR2,
19: p_module IN VARCHAR2) IS
20: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
21: BEGIN
22: if( G_Debug = TRUE ) then
23: -- inv_debug.message('wshtxn', p_message);
24: IF (l_debug = 1) THEN

Line 43: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

39: x_return_status OUT nocopy VARCHAR2,
40: x_msg_count OUT nocopy NUMBER,
41: x_msg_data OUT nocopy varchar2) IS
42:
43: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
44:
45: l_entity_table WSH_FTE_COMP_CONSTRAINT_GRP.wshfte_ccin_tab_type;
46: l_return_status VARCHAR2(1);
47: l_msg_count NUMBER;

Line 638: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

634: CONNECT BY lpn_id = PRIOR parent_lpn_id;
635:
636: l_return_status VARCHAR2(1);
637: l_delivery_id NUMBER := p_delivery_id;
638: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
639:
640: l_requested_quantity NUMBER;
641: l_requested_quantity2 NUMBER;
642: l_picked_quantity NUMBER;

Line 845: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

841: p_shipped_quantity IN NUMBER,
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:

Line 949: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

945: l_msg_data VARCHAR2(2000);
946:
947: l_bo_mode VARCHAR2(10);
948:
949: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
950: l_global_param_rec WSH_SHIPPING_PARAMS_PVT.Global_Parameters_Rec_Typ; --6607967 --FP6922321
951: l_return_shipping_status VARCHAR2(30); --6607967--FP6922321
952: BEGIN
953: x_return_status := fnd_api.g_ret_sts_success;

Line 1270: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

1266: l_return_status VARCHAR2(1);
1267: l_msg_count NUMBER;
1268: l_msg_data VARCHAR2(2000);
1269:
1270: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1271: BEGIN
1272: x_return_status := fnd_api.g_ret_sts_success;
1273:
1274: --this cursor only returns 1 record because delivery_line_id is an

Line 1479: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

1475: p_missing_quantity IN NUMBER,
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;

Line 1533: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

1529: p_sec_missing_quantity IN NUMBER,
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;

Line 1590: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

1586: p_trackingNumber IN VARCHAR2,
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);

Line 1715: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

1711: p_trackingNumber IN VARCHAR2,
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);

Line 1876: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

1872: l_trx_src_type NUMBER;
1873: l_trx_act_id NUMBER;
1874: l_intransit_type NUMBER;
1875:
1876: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1877: BEGIN
1878: x_return_status := 'C';
1879: l_trx_type_code := -1;
1880:

Line 2017: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

2013: l_trx_act_id NUMBER;
2014: l_status_applicable VARCHAR2(1);
2015: l_lpn_id NUMBER; --16482236
2016:
2017: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2018: BEGIN
2019: FOR l_detail_rec IN c_delivery_details LOOP
2020: l_trx_type_code := GET_DELIVERY_TRANSACTION_TYPE(l_detail_rec.delivery_detail_id,
2021: l_trx_src_type_id,

Line 2558: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

2554:
2555: unspec_ship_set_exists EXCEPTION;
2556: incomplete_delivery EXCEPTION;
2557:
2558: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2559: BEGIN
2560: x_return_status := FND_API.G_RET_STS_SUCCESS;
2561: x_ret_code := 0;
2562: fnd_msg_pub.initialize;

Line 2680: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

2676: x_msg_data OUT NOCOPY VARCHAR2,
2677: x_msg_count OUT NOCOPY NUMBER) IS
2678: l_error_msg VARCHAR2(2000) := NULL;
2679: unassign_lines_exc EXCEPTION;
2680: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2681: BEGIN
2682: fnd_msg_pub.initialize;
2683:
2684: INV_SHIPPING_TRANSACTION_PUB.UNASSIGN_DELIVERY_LINES(

Line 2756: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

2752:
2753:
2754: l_detail_attributes wsh_interface.ChangedAttributeTabType;
2755: l_InvPCInRecType wsh_integration.InvPCInRecType;
2756: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2757: BEGIN
2758: IF l_debug = 1 THEN
2759: debug('Entered procedure','INV_SPLIT_DELIVERY_LINE');
2760: debug('p_delivery_detail_id: ' || p_delivery_detail_id,'INV_SPLIT_DELIVERY_LINE');

Line 2897: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

2893:
2894:
2895: l_detail_attributes wsh_interface.ChangedAttributeTabType;
2896: l_InvPCInRecType wsh_integration.InvPCInRecType;
2897: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2898:
2899: --Bug No 3952081
2900: --New field to hol sec delay qty
2901: l_sec_delay_quantity NUMBER;

Line 3074: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

3070: x_enforce_ship OUT NOCOPY VARCHAR2,
3071: x_return_status OUT nocopy VARCHAR2,
3072: x_msg_data OUT nocopy VARCHAR,
3073: x_msg_count OUT nocopy NUMBER) IS
3074: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3075: l_shipping_params WSH_SHIPPING_PARAMS_GRP.Global_Params_Rec;
3076: BEGIN
3077: x_return_status := FND_API.G_RET_STS_SUCCESS;
3078:

Line 3114: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

3110: x_trip_shipmethod_meaning OUT NOCOPY VARCHAR2,
3111: x_return_status OUT NOCOPY VARCHAR2,
3112: x_msg_data OUT NOCOPY VARCHAR,
3113: x_msg_count OUT NOCOPY NUMBER) IS
3114: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3115: BEGIN
3116: IF (l_debug = 1) THEN
3117: debug('inside get_shipmethod_details ' , 'get_shipmethod_details');
3118: debug('p_org_id : ' || p_org_id, 'get_shipmethod_details');