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_3PL_LOC_PVT dependencies on INV_TRX_UTIL_PUB

Line 39: inv_trx_util_pub.TRACE('In update locator capcity ', 'update_current_capacity', 4);

35: BEGIN
36: x_return_status := FND_API.G_RET_STS_SUCCESS;
37:
38: IF (g_debug = 1) THEN
39: inv_trx_util_pub.TRACE('In update locator capcity ', 'update_current_capacity', 4);
40: inv_trx_util_pub.TRACE('Locator ID' || p_inventory_location_id , 'update_current_capacity',4);
41: inv_trx_util_pub.TRACE('Client Code ' || p_client_code, 'update_current_capacity', 4);
42: END IF;
43:

Line 40: inv_trx_util_pub.TRACE('Locator ID' || p_inventory_location_id , 'update_current_capacity',4);

36: x_return_status := FND_API.G_RET_STS_SUCCESS;
37:
38: IF (g_debug = 1) THEN
39: inv_trx_util_pub.TRACE('In update locator capcity ', 'update_current_capacity', 4);
40: inv_trx_util_pub.TRACE('Locator ID' || p_inventory_location_id , 'update_current_capacity',4);
41: inv_trx_util_pub.TRACE('Client Code ' || p_client_code, 'update_current_capacity', 4);
42: END IF;
43:
44: BEGIN

Line 41: inv_trx_util_pub.TRACE('Client Code ' || p_client_code, 'update_current_capacity', 4);

37:
38: IF (g_debug = 1) THEN
39: inv_trx_util_pub.TRACE('In update locator capcity ', 'update_current_capacity', 4);
40: inv_trx_util_pub.TRACE('Locator ID' || p_inventory_location_id , 'update_current_capacity',4);
41: inv_trx_util_pub.TRACE('Client Code ' || p_client_code, 'update_current_capacity', 4);
42: END IF;
43:
44: BEGIN
45: Select *

Line 53: inv_trx_util_pub.TRACE('Locator Record Exists in Occupancy table', 'update_current_capacity', 4);

49: and organization_id = p_organization_id
50: AND client_code = p_client_code;
51:
52: IF (g_debug = 1) THEN
53: inv_trx_util_pub.TRACE('Locator Record Exists in Occupancy table', 'update_current_capacity', 4);
54: END IF;
55:
56: EXCEPTION
57: WHEN NO_DATA_FOUND THEN

Line 59: inv_trx_util_pub.TRACE('Locator Record Does not exist , creating a new record in Occupancy table', 'update_current_capacity', 4);

55:
56: EXCEPTION
57: WHEN NO_DATA_FOUND THEN
58: IF (g_debug = 1) THEN
59: inv_trx_util_pub.TRACE('Locator Record Does not exist , creating a new record in Occupancy table', 'update_current_capacity', 4);
60: END IF;
61:
62: inv_trx_util_pub.TRACE('p_transaction_date => ' ||p_transaction_date, 'update_current_capacity', 4);
63: inv_trx_util_pub.TRACE('p_quantity => ' || p_quantity, 'update_current_capacity', 4);

Line 62: inv_trx_util_pub.TRACE('p_transaction_date => ' ||p_transaction_date, 'update_current_capacity', 4);

58: IF (g_debug = 1) THEN
59: inv_trx_util_pub.TRACE('Locator Record Does not exist , creating a new record in Occupancy table', 'update_current_capacity', 4);
60: END IF;
61:
62: inv_trx_util_pub.TRACE('p_transaction_date => ' ||p_transaction_date, 'update_current_capacity', 4);
63: inv_trx_util_pub.TRACE('p_quantity => ' || p_quantity, 'update_current_capacity', 4);
64: inv_trx_util_pub.TRACE('p_inventory_location_id => ' ||p_inventory_location_id, 'update_current_capacity', 4);
65: inv_trx_util_pub.TRACE('p_transaction_date => ' ||p_transaction_date, 'update_current_capacity', 4);
66: inv_trx_util_pub.TRACE('p_transaction_action_id => ' ||p_transaction_action_id, 'update_current_capacity', 4);

Line 63: inv_trx_util_pub.TRACE('p_quantity => ' || p_quantity, 'update_current_capacity', 4);

59: inv_trx_util_pub.TRACE('Locator Record Does not exist , creating a new record in Occupancy table', 'update_current_capacity', 4);
60: END IF;
61:
62: inv_trx_util_pub.TRACE('p_transaction_date => ' ||p_transaction_date, 'update_current_capacity', 4);
63: inv_trx_util_pub.TRACE('p_quantity => ' || p_quantity, 'update_current_capacity', 4);
64: inv_trx_util_pub.TRACE('p_inventory_location_id => ' ||p_inventory_location_id, 'update_current_capacity', 4);
65: inv_trx_util_pub.TRACE('p_transaction_date => ' ||p_transaction_date, 'update_current_capacity', 4);
66: inv_trx_util_pub.TRACE('p_transaction_action_id => ' ||p_transaction_action_id, 'update_current_capacity', 4);
67: inv_trx_util_pub.TRACE('p_organization_id => ' ||p_organization_id, 'update_current_capacity', 4);

Line 64: inv_trx_util_pub.TRACE('p_inventory_location_id => ' ||p_inventory_location_id, 'update_current_capacity', 4);

60: END IF;
61:
62: inv_trx_util_pub.TRACE('p_transaction_date => ' ||p_transaction_date, 'update_current_capacity', 4);
63: inv_trx_util_pub.TRACE('p_quantity => ' || p_quantity, 'update_current_capacity', 4);
64: inv_trx_util_pub.TRACE('p_inventory_location_id => ' ||p_inventory_location_id, 'update_current_capacity', 4);
65: inv_trx_util_pub.TRACE('p_transaction_date => ' ||p_transaction_date, 'update_current_capacity', 4);
66: inv_trx_util_pub.TRACE('p_transaction_action_id => ' ||p_transaction_action_id, 'update_current_capacity', 4);
67: inv_trx_util_pub.TRACE('p_organization_id => ' ||p_organization_id, 'update_current_capacity', 4);
68: inv_trx_util_pub.TRACE('l_client_code => ' ||p_client_code, 'update_current_capacity', 4);

Line 65: inv_trx_util_pub.TRACE('p_transaction_date => ' ||p_transaction_date, 'update_current_capacity', 4);

61:
62: inv_trx_util_pub.TRACE('p_transaction_date => ' ||p_transaction_date, 'update_current_capacity', 4);
63: inv_trx_util_pub.TRACE('p_quantity => ' || p_quantity, 'update_current_capacity', 4);
64: inv_trx_util_pub.TRACE('p_inventory_location_id => ' ||p_inventory_location_id, 'update_current_capacity', 4);
65: inv_trx_util_pub.TRACE('p_transaction_date => ' ||p_transaction_date, 'update_current_capacity', 4);
66: inv_trx_util_pub.TRACE('p_transaction_action_id => ' ||p_transaction_action_id, 'update_current_capacity', 4);
67: inv_trx_util_pub.TRACE('p_organization_id => ' ||p_organization_id, 'update_current_capacity', 4);
68: inv_trx_util_pub.TRACE('l_client_code => ' ||p_client_code, 'update_current_capacity', 4);
69:

Line 66: inv_trx_util_pub.TRACE('p_transaction_action_id => ' ||p_transaction_action_id, 'update_current_capacity', 4);

62: inv_trx_util_pub.TRACE('p_transaction_date => ' ||p_transaction_date, 'update_current_capacity', 4);
63: inv_trx_util_pub.TRACE('p_quantity => ' || p_quantity, 'update_current_capacity', 4);
64: inv_trx_util_pub.TRACE('p_inventory_location_id => ' ||p_inventory_location_id, 'update_current_capacity', 4);
65: inv_trx_util_pub.TRACE('p_transaction_date => ' ||p_transaction_date, 'update_current_capacity', 4);
66: inv_trx_util_pub.TRACE('p_transaction_action_id => ' ||p_transaction_action_id, 'update_current_capacity', 4);
67: inv_trx_util_pub.TRACE('p_organization_id => ' ||p_organization_id, 'update_current_capacity', 4);
68: inv_trx_util_pub.TRACE('l_client_code => ' ||p_client_code, 'update_current_capacity', 4);
69:
70: l_success := insert_3pl_loc_occupancy(

Line 67: inv_trx_util_pub.TRACE('p_organization_id => ' ||p_organization_id, 'update_current_capacity', 4);

63: inv_trx_util_pub.TRACE('p_quantity => ' || p_quantity, 'update_current_capacity', 4);
64: inv_trx_util_pub.TRACE('p_inventory_location_id => ' ||p_inventory_location_id, 'update_current_capacity', 4);
65: inv_trx_util_pub.TRACE('p_transaction_date => ' ||p_transaction_date, 'update_current_capacity', 4);
66: inv_trx_util_pub.TRACE('p_transaction_action_id => ' ||p_transaction_action_id, 'update_current_capacity', 4);
67: inv_trx_util_pub.TRACE('p_organization_id => ' ||p_organization_id, 'update_current_capacity', 4);
68: inv_trx_util_pub.TRACE('l_client_code => ' ||p_client_code, 'update_current_capacity', 4);
69:
70: l_success := insert_3pl_loc_occupancy(
71: p_transaction_date ,

Line 68: inv_trx_util_pub.TRACE('l_client_code => ' ||p_client_code, 'update_current_capacity', 4);

64: inv_trx_util_pub.TRACE('p_inventory_location_id => ' ||p_inventory_location_id, 'update_current_capacity', 4);
65: inv_trx_util_pub.TRACE('p_transaction_date => ' ||p_transaction_date, 'update_current_capacity', 4);
66: inv_trx_util_pub.TRACE('p_transaction_action_id => ' ||p_transaction_action_id, 'update_current_capacity', 4);
67: inv_trx_util_pub.TRACE('p_organization_id => ' ||p_organization_id, 'update_current_capacity', 4);
68: inv_trx_util_pub.TRACE('l_client_code => ' ||p_client_code, 'update_current_capacity', 4);
69:
70: l_success := insert_3pl_loc_occupancy(
71: p_transaction_date ,
72: p_quantity ,

Line 91: inv_trx_util_pub.TRACE('Updating The current record ', 'update_current_capacity', 4);

87: RETURN;
88: END;
89:
90: IF (g_debug = 1) THEN
91: inv_trx_util_pub.TRACE('Updating The current record ', 'update_current_capacity', 4);
92: inv_trx_util_pub.TRACE('Transaction action ID' || p_transaction_action_id, 'update_current_capacity', 4);
93: end if;
94:
95: IF ( p_quantity > 0 and l_old_Record.locator_id is not null ) --AND NOT(l_old_Record.Current_Onhand + p_quantity < 0) )

Line 92: inv_trx_util_pub.TRACE('Transaction action ID' || p_transaction_action_id, 'update_current_capacity', 4);

88: END;
89:
90: IF (g_debug = 1) THEN
91: inv_trx_util_pub.TRACE('Updating The current record ', 'update_current_capacity', 4);
92: inv_trx_util_pub.TRACE('Transaction action ID' || p_transaction_action_id, 'update_current_capacity', 4);
93: end if;
94:
95: IF ( p_quantity > 0 and l_old_Record.locator_id is not null ) --AND NOT(l_old_Record.Current_Onhand + p_quantity < 0) )
96: THEN

Line 98: inv_trx_util_pub.TRACE('Just before adding days .... :', 'update_current_capacity', 4);

94:
95: IF ( p_quantity > 0 and l_old_Record.locator_id is not null ) --AND NOT(l_old_Record.Current_Onhand + p_quantity < 0) )
96: THEN
97: IF (g_debug = 1) THEN
98: inv_trx_util_pub.TRACE('Just before adding days .... :', 'update_current_capacity', 4);
99: inv_trx_util_pub.TRACE('Transaction_date :' || p_transaction_date , 'update_current_capacity', 4);
100: inv_trx_util_pub.TRACE('l_old_Record.Last_Receipt_Date :' || l_old_Record.Last_Receipt_Date , 'update_current_capacity', 4);
101: inv_trx_util_pub.TRACE('l_number_of_days :' || l_number_of_days , 'update_current_capacity', 4);
102: end if;

Line 99: inv_trx_util_pub.TRACE('Transaction_date :' || p_transaction_date , 'update_current_capacity', 4);

95: IF ( p_quantity > 0 and l_old_Record.locator_id is not null ) --AND NOT(l_old_Record.Current_Onhand + p_quantity < 0) )
96: THEN
97: IF (g_debug = 1) THEN
98: inv_trx_util_pub.TRACE('Just before adding days .... :', 'update_current_capacity', 4);
99: inv_trx_util_pub.TRACE('Transaction_date :' || p_transaction_date , 'update_current_capacity', 4);
100: inv_trx_util_pub.TRACE('l_old_Record.Last_Receipt_Date :' || l_old_Record.Last_Receipt_Date , 'update_current_capacity', 4);
101: inv_trx_util_pub.TRACE('l_number_of_days :' || l_number_of_days , 'update_current_capacity', 4);
102: end if;
103:

Line 100: inv_trx_util_pub.TRACE('l_old_Record.Last_Receipt_Date :' || l_old_Record.Last_Receipt_Date , 'update_current_capacity', 4);

96: THEN
97: IF (g_debug = 1) THEN
98: inv_trx_util_pub.TRACE('Just before adding days .... :', 'update_current_capacity', 4);
99: inv_trx_util_pub.TRACE('Transaction_date :' || p_transaction_date , 'update_current_capacity', 4);
100: inv_trx_util_pub.TRACE('l_old_Record.Last_Receipt_Date :' || l_old_Record.Last_Receipt_Date , 'update_current_capacity', 4);
101: inv_trx_util_pub.TRACE('l_number_of_days :' || l_number_of_days , 'update_current_capacity', 4);
102: end if;
103:
104: IF ( to_date(l_old_Record.last_invoiced_date,'dd/mm/yyyy') <> to_date(p_transaction_date,'dd/mm/yyyy') ) -- Here the transaction date is same as the creation date

Line 101: inv_trx_util_pub.TRACE('l_number_of_days :' || l_number_of_days , 'update_current_capacity', 4);

97: IF (g_debug = 1) THEN
98: inv_trx_util_pub.TRACE('Just before adding days .... :', 'update_current_capacity', 4);
99: inv_trx_util_pub.TRACE('Transaction_date :' || p_transaction_date , 'update_current_capacity', 4);
100: inv_trx_util_pub.TRACE('l_old_Record.Last_Receipt_Date :' || l_old_Record.Last_Receipt_Date , 'update_current_capacity', 4);
101: inv_trx_util_pub.TRACE('l_number_of_days :' || l_number_of_days , 'update_current_capacity', 4);
102: end if;
103:
104: IF ( to_date(l_old_Record.last_invoiced_date,'dd/mm/yyyy') <> to_date(p_transaction_date,'dd/mm/yyyy') ) -- Here the transaction date is same as the creation date
105: THEN

Line 112: inv_trx_util_pub.TRACE('Inside 2nd if' || l_number_of_days , 'update_current_capacity', 4);

108:
109: ELSIF ( p_transaction_date >= l_old_Record.Last_Receipt_Date AND l_old_Record.Current_Onhand > 0 )
110: THEN
111: IF (g_debug = 1) THEN
112: inv_trx_util_pub.TRACE('Inside 2nd if' || l_number_of_days , 'update_current_capacity', 4);
113: end if;
114: l_number_of_days := l_old_Record.number_of_days + to_number(to_date(p_transaction_date,'dd/mm/yyyy') - to_date(l_old_Record.Last_Receipt_Date,'dd/mm/yyyy'));
115: END IF;
116: ELSE

Line 121: inv_trx_util_pub.TRACE('New number of days' || l_number_of_days , 'update_current_capacity', 4);

117: l_number_of_days := l_old_record.number_of_days;
118: END IF;
119:
120: IF (g_debug = 1) THEN
121: inv_trx_util_pub.TRACE('New number of days' || l_number_of_days , 'update_current_capacity', 4);
122: END IF;
123:
124: l_Last_Receipt_Date := p_transaction_date ;
125: l_current_onhand := NVL(l_old_record.current_onhand,0) + p_quantity;

Line 135: inv_trx_util_pub.TRACE(' Calling update_3pl_loc_occupancy ', 'update_current_capacity', 4);

131: l_client_code := p_client_code;
132: -- l_-- last_invoiced_date := NULL;
133:
134: IF (g_debug = 1) THEN
135: inv_trx_util_pub.TRACE(' Calling update_3pl_loc_occupancy ', 'update_current_capacity', 4);
136: END IF;
137:
138: l_success := update_3pl_loc_occupancy(
139: l_Last_Receipt_Date ,

Line 153: inv_trx_util_pub.TRACE('For issue transactions', 'update_current_capacity', 4);

149:
150: ELSIF ( p_quantity < 0 and l_old_Record.locator_id is not null )
151: THEN
152: IF (g_debug = 1) THEN
153: inv_trx_util_pub.TRACE('For issue transactions', 'update_current_capacity', 4);
154: inv_trx_util_pub.TRACE('Just before adding days .... :', 'update_current_capacity', 4);
155: inv_trx_util_pub.TRACE('p_transaction_date :' || p_transaction_date , 'update_current_capacity', 4);
156: inv_trx_util_pub.TRACE('l_old_Record.Last_Receipt_Date :' || l_old_Record.Last_Receipt_Date , 'update_current_capacity', 4);
157: inv_trx_util_pub.TRACE('l_number_of_days :' || l_number_of_days , 'update_current_capacity', 4);

Line 154: inv_trx_util_pub.TRACE('Just before adding days .... :', 'update_current_capacity', 4);

150: ELSIF ( p_quantity < 0 and l_old_Record.locator_id is not null )
151: THEN
152: IF (g_debug = 1) THEN
153: inv_trx_util_pub.TRACE('For issue transactions', 'update_current_capacity', 4);
154: inv_trx_util_pub.TRACE('Just before adding days .... :', 'update_current_capacity', 4);
155: inv_trx_util_pub.TRACE('p_transaction_date :' || p_transaction_date , 'update_current_capacity', 4);
156: inv_trx_util_pub.TRACE('l_old_Record.Last_Receipt_Date :' || l_old_Record.Last_Receipt_Date , 'update_current_capacity', 4);
157: inv_trx_util_pub.TRACE('l_number_of_days :' || l_number_of_days , 'update_current_capacity', 4);
158: inv_trx_util_pub.TRACE('p_quantity :' || p_quantity , 'update_current_capacity', 4);

Line 155: inv_trx_util_pub.TRACE('p_transaction_date :' || p_transaction_date , 'update_current_capacity', 4);

151: THEN
152: IF (g_debug = 1) THEN
153: inv_trx_util_pub.TRACE('For issue transactions', 'update_current_capacity', 4);
154: inv_trx_util_pub.TRACE('Just before adding days .... :', 'update_current_capacity', 4);
155: inv_trx_util_pub.TRACE('p_transaction_date :' || p_transaction_date , 'update_current_capacity', 4);
156: inv_trx_util_pub.TRACE('l_old_Record.Last_Receipt_Date :' || l_old_Record.Last_Receipt_Date , 'update_current_capacity', 4);
157: inv_trx_util_pub.TRACE('l_number_of_days :' || l_number_of_days , 'update_current_capacity', 4);
158: inv_trx_util_pub.TRACE('p_quantity :' || p_quantity , 'update_current_capacity', 4);
159: END IF;

Line 156: inv_trx_util_pub.TRACE('l_old_Record.Last_Receipt_Date :' || l_old_Record.Last_Receipt_Date , 'update_current_capacity', 4);

152: IF (g_debug = 1) THEN
153: inv_trx_util_pub.TRACE('For issue transactions', 'update_current_capacity', 4);
154: inv_trx_util_pub.TRACE('Just before adding days .... :', 'update_current_capacity', 4);
155: inv_trx_util_pub.TRACE('p_transaction_date :' || p_transaction_date , 'update_current_capacity', 4);
156: inv_trx_util_pub.TRACE('l_old_Record.Last_Receipt_Date :' || l_old_Record.Last_Receipt_Date , 'update_current_capacity', 4);
157: inv_trx_util_pub.TRACE('l_number_of_days :' || l_number_of_days , 'update_current_capacity', 4);
158: inv_trx_util_pub.TRACE('p_quantity :' || p_quantity , 'update_current_capacity', 4);
159: END IF;
160:

Line 157: inv_trx_util_pub.TRACE('l_number_of_days :' || l_number_of_days , 'update_current_capacity', 4);

153: inv_trx_util_pub.TRACE('For issue transactions', 'update_current_capacity', 4);
154: inv_trx_util_pub.TRACE('Just before adding days .... :', 'update_current_capacity', 4);
155: inv_trx_util_pub.TRACE('p_transaction_date :' || p_transaction_date , 'update_current_capacity', 4);
156: inv_trx_util_pub.TRACE('l_old_Record.Last_Receipt_Date :' || l_old_Record.Last_Receipt_Date , 'update_current_capacity', 4);
157: inv_trx_util_pub.TRACE('l_number_of_days :' || l_number_of_days , 'update_current_capacity', 4);
158: inv_trx_util_pub.TRACE('p_quantity :' || p_quantity , 'update_current_capacity', 4);
159: END IF;
160:
161: IF ( to_date(l_old_Record.last_invoiced_date,'dd/mm/yyyy') <> to_date(p_transaction_date,'dd/mm/yyyy') ) -- Here the transaction date is same as the creation date

Line 158: inv_trx_util_pub.TRACE('p_quantity :' || p_quantity , 'update_current_capacity', 4);

154: inv_trx_util_pub.TRACE('Just before adding days .... :', 'update_current_capacity', 4);
155: inv_trx_util_pub.TRACE('p_transaction_date :' || p_transaction_date , 'update_current_capacity', 4);
156: inv_trx_util_pub.TRACE('l_old_Record.Last_Receipt_Date :' || l_old_Record.Last_Receipt_Date , 'update_current_capacity', 4);
157: inv_trx_util_pub.TRACE('l_number_of_days :' || l_number_of_days , 'update_current_capacity', 4);
158: inv_trx_util_pub.TRACE('p_quantity :' || p_quantity , 'update_current_capacity', 4);
159: END IF;
160:
161: IF ( to_date(l_old_Record.last_invoiced_date,'dd/mm/yyyy') <> to_date(p_transaction_date,'dd/mm/yyyy') ) -- Here the transaction date is same as the creation date
162: THEN

Line 182: inv_trx_util_pub.TRACE('Before calling update_3pl_loc_occupancy ', 'update_current_capacity', 4);

178: l_organization_id := p_organization_id;
179: l_client_code := p_client_code;
180:
181: IF (g_debug = 1) THEN
182: inv_trx_util_pub.TRACE('Before calling update_3pl_loc_occupancy ', 'update_current_capacity', 4);
183: END IF;
184:
185: l_success := update_3pl_loc_occupancy(
186: l_Last_Receipt_Date ,

Line 208: inv_trx_util_pub.TRACE(' Exception in update_locator_capacity => '||sqlerrm, 'update_current_capacity', 4);

204:
205: EXCEPTION
206: WHEN OTHERS THEN
207: IF (g_debug = 1) THEN
208: inv_trx_util_pub.TRACE(' Exception in update_locator_capacity => '||sqlerrm, 'update_current_capacity', 4);
209: END IF;
210: x_return_status := fnd_api.g_ret_sts_unexp_error;
211: END update_locator_capacity;
212:

Line 236: inv_trx_util_pub.TRACE('In update_3pl_loc_occupancy ', 'update_current_capacity', 4);

232:
233: BEGIN
234:
235: IF (g_debug = 1) THEN
236: inv_trx_util_pub.TRACE('In update_3pl_loc_occupancy ', 'update_current_capacity', 4);
237: END IF;
238:
239: FOR recinfo IN c
240: LOOP

Line 242: inv_trx_util_pub.TRACE('recinfo.locator_id ' || recinfo.locator_id , 'update_current_capacity', 4);

238:
239: FOR recinfo IN c
240: LOOP
241: IF (g_debug = 1) THEN
242: inv_trx_util_pub.TRACE('recinfo.locator_id ' || recinfo.locator_id , 'update_current_capacity', 4);
243: inv_trx_util_pub.TRACE('recinfo.client_code ' || recinfo.client_code , 'update_current_capacity', 4);
244: END IF;
245:
246: Update mtl_3pl_locator_occupancy

Line 243: inv_trx_util_pub.TRACE('recinfo.client_code ' || recinfo.client_code , 'update_current_capacity', 4);

239: FOR recinfo IN c
240: LOOP
241: IF (g_debug = 1) THEN
242: inv_trx_util_pub.TRACE('recinfo.locator_id ' || recinfo.locator_id , 'update_current_capacity', 4);
243: inv_trx_util_pub.TRACE('recinfo.client_code ' || recinfo.client_code , 'update_current_capacity', 4);
244: END IF;
245:
246: Update mtl_3pl_locator_occupancy
247: set Last_Receipt_Date = l_Last_Receipt_Date,

Line 263: inv_trx_util_pub.TRACE(' Exception in update_3pl_loc_occupancy => '||sqlerrm, 'update_current_capacity', 4);

259:
260: EXCEPTION
261: WHEN OTHERS THEN
262: IF (g_debug = 1) THEN
263: inv_trx_util_pub.TRACE(' Exception in update_3pl_loc_occupancy => '||sqlerrm, 'update_current_capacity', 4);
264: END IF;
265:
266: RETURN FND_API.G_RET_STS_ERROR;
267: END update_3pl_loc_occupancy;

Line 284: inv_trx_util_pub.TRACE('IN insert_3pl_loc_occupancy ','update_current_capacity', 4);

280: IS
281: BEGIN
282:
283: IF (g_debug = 1) THEN
284: inv_trx_util_pub.TRACE('IN insert_3pl_loc_occupancy ','update_current_capacity', 4);
285: inv_trx_util_pub.TRACE('l_locator_id ' || l_locator_id,'update_current_capacity', 4);
286: inv_trx_util_pub.TRACE('IN l_client_code ' || l_client_code ,'update_current_capacity', 4);
287: END IF;
288:

Line 285: inv_trx_util_pub.TRACE('l_locator_id ' || l_locator_id,'update_current_capacity', 4);

281: BEGIN
282:
283: IF (g_debug = 1) THEN
284: inv_trx_util_pub.TRACE('IN insert_3pl_loc_occupancy ','update_current_capacity', 4);
285: inv_trx_util_pub.TRACE('l_locator_id ' || l_locator_id,'update_current_capacity', 4);
286: inv_trx_util_pub.TRACE('IN l_client_code ' || l_client_code ,'update_current_capacity', 4);
287: END IF;
288:
289: INSERT INTO mtl_3pl_locator_occupancy

Line 286: inv_trx_util_pub.TRACE('IN l_client_code ' || l_client_code ,'update_current_capacity', 4);

282:
283: IF (g_debug = 1) THEN
284: inv_trx_util_pub.TRACE('IN insert_3pl_loc_occupancy ','update_current_capacity', 4);
285: inv_trx_util_pub.TRACE('l_locator_id ' || l_locator_id,'update_current_capacity', 4);
286: inv_trx_util_pub.TRACE('IN l_client_code ' || l_client_code ,'update_current_capacity', 4);
287: END IF;
288:
289: INSERT INTO mtl_3pl_locator_occupancy
290: ( Last_Receipt_Date,

Line 319: inv_trx_util_pub.TRACE(' Exception in insert_3pl_loc_occupancy => '||sqlerrm, 'update_current_capacity', 4);

315:
316: EXCEPTION
317: WHEN OTHERS THEN
318: IF (g_debug = 1) THEN
319: inv_trx_util_pub.TRACE(' Exception in insert_3pl_loc_occupancy => '||sqlerrm, 'update_current_capacity', 4);
320: END IF;
321: RETURN FND_API.G_RET_STS_ERROR;
322: END insert_3pl_loc_occupancy;
323: