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

Line 43: inv_trx_util_pub.TRACE('Entering Raise_Event', 'INV_ONHAND_BALANCE', 9);

39:
40: BEGIN
41:
42: if (g_debug = 1) then
43: inv_trx_util_pub.TRACE('Entering Raise_Event', 'INV_ONHAND_BALANCE', 9);
44: inv_trx_util_pub.TRACE('transaction_id is ' || P_txn_hist_record.transaction_id, 'INV_ONHAND_BALANCE', 9);
45: inv_trx_util_pub.TRACE('transaction_status is ' || P_txn_hist_record.transaction_status, 'INV_ONHAND_BALANCE', 9);
46: end if;
47:

Line 44: inv_trx_util_pub.TRACE('transaction_id is ' || P_txn_hist_record.transaction_id, 'INV_ONHAND_BALANCE', 9);

40: BEGIN
41:
42: if (g_debug = 1) then
43: inv_trx_util_pub.TRACE('Entering Raise_Event', 'INV_ONHAND_BALANCE', 9);
44: inv_trx_util_pub.TRACE('transaction_id is ' || P_txn_hist_record.transaction_id, 'INV_ONHAND_BALANCE', 9);
45: inv_trx_util_pub.TRACE('transaction_status is ' || P_txn_hist_record.transaction_status, 'INV_ONHAND_BALANCE', 9);
46: end if;
47:
48: x_return_status := rcv_error_pkg.g_ret_sts_success;

Line 45: inv_trx_util_pub.TRACE('transaction_status is ' || P_txn_hist_record.transaction_status, 'INV_ONHAND_BALANCE', 9);

41:
42: if (g_debug = 1) then
43: inv_trx_util_pub.TRACE('Entering Raise_Event', 'INV_ONHAND_BALANCE', 9);
44: inv_trx_util_pub.TRACE('transaction_id is ' || P_txn_hist_record.transaction_id, 'INV_ONHAND_BALANCE', 9);
45: inv_trx_util_pub.TRACE('transaction_status is ' || P_txn_hist_record.transaction_status, 'INV_ONHAND_BALANCE', 9);
46: end if;
47:
48: x_return_status := rcv_error_pkg.g_ret_sts_success;
49:

Line 65: inv_trx_util_pub.TRACE('l_transaction_code is '||l_transaction_code, 'INV_ONHAND_BALANCE', 9);

61:
62: l_Transaction_Code := UPPER (SUBSTRB (l_event_name, INSTRB(l_Event_Name, '.', -1) + 1));
63:
64: if (g_debug = 1) then
65: inv_trx_util_pub.TRACE('l_transaction_code is '||l_transaction_code, 'INV_ONHAND_BALANCE', 9);
66: end if;
67:
68: l_Event_Key := l_txn_hist_record.Event_Key;
69: l_wms_deployment_mode := WMS_DEPLOY.WMS_DEPLOYMENT_MODE;

Line 77: inv_trx_util_pub.TRACE('trading_partner_id is '||P_txn_hist_record.trading_partner_id, 'INV_ONHAND_BALANCE', 9);

73: -- Generate the document number for outgoing documents.
74:
75:
76: if (g_debug = 1) then
77: inv_trx_util_pub.TRACE('trading_partner_id is '||P_txn_hist_record.trading_partner_id, 'INV_ONHAND_BALANCE', 9);
78: end if;
79:
80: IF (l_wms_deployment_mode = 'L') THEN
81:

Line 98: inv_trx_util_pub.TRACE('trading_partner_site_id is '||l_Party_Site_ID, 'INV_ONHAND_BALANCE', 9);

94: END IF;
95:
96:
97: if (g_debug = 1) then
98: inv_trx_util_pub.TRACE('trading_partner_site_id is '||l_Party_Site_ID, 'INV_ONHAND_BALANCE', 9);
99: end if;
100:
101: END IF; --}
102:

Line 120: inv_trx_util_pub.TRACE('Party Type is C', 'INV_ONHAND_BALANCE', 9);

116: p_value => 'C',
117: p_parameterlist => l_msg_parameter_list);
118:
119: if (g_debug = 1) then
120: inv_trx_util_pub.TRACE('Party Type is C', 'INV_ONHAND_BALANCE', 9);
121: end if;
122:
123: ELSE
124:

Line 130: inv_trx_util_pub.TRACE('Party Type is I', 'INV_ONHAND_BALANCE', 9);

126: p_value => 'I',
127: p_parameterlist => l_msg_parameter_list);
128:
129: if (g_debug = 1) then
130: inv_trx_util_pub.TRACE('Party Type is I', 'INV_ONHAND_BALANCE', 9);
131: end if;
132:
133: END IF;
134:

Line 139: inv_trx_util_pub.TRACE('Document ID is '|| l_txn_hist_record.Entity_Number, 'INV_ONHAND_BALANCE', 9);

135: WF_EVENT.AddParameterToList (p_name => 'ECX_DOCUMENT_ID',
136: p_value => l_xml_document_id, --l_txn_hist_record.Entity_Number, -- entity_id
137: p_parameterlist => l_msg_parameter_list);
138: if (g_debug = 1) then
139: inv_trx_util_pub.TRACE('Document ID is '|| l_txn_hist_record.Entity_Number, 'INV_ONHAND_BALANCE', 9);
140: end if;
141:
142:
143: WF_EVENT.AddParameterToList (p_name => 'USER_ID',

Line 148: inv_trx_util_pub.TRACE('User ID is '|| FND_GLOBAL.USER_ID, 'INV_ONHAND_BALANCE', 9);

144: p_value => FND_GLOBAL.USER_ID,
145: p_parameterlist => l_msg_parameter_list);
146:
147: if (g_debug = 1) then
148: inv_trx_util_pub.TRACE('User ID is '|| FND_GLOBAL.USER_ID, 'INV_ONHAND_BALANCE', 9);
149: end if;
150:
151:
152: WF_EVENT.AddParameterToList (p_name => 'APPLICATION_ID',

Line 157: inv_trx_util_pub.TRACE('Responsibility Application ID is '|| FND_GLOBAL.RESP_APPL_ID, 'INV_ONHAND_BALANCE', 9);

153: p_value => FND_GLOBAL.RESP_APPL_ID,
154: p_parameterlist => l_msg_parameter_list);
155:
156: if (g_debug = 1) then
157: inv_trx_util_pub.TRACE('Responsibility Application ID is '|| FND_GLOBAL.RESP_APPL_ID, 'INV_ONHAND_BALANCE', 9);
158: end if;
159:
160:
161: WF_EVENT.AddParameterToList (p_name => 'RESPONSIBILITY_ID',

Line 165: inv_trx_util_pub.TRACE('Responsibility ID is '|| FND_GLOBAL.RESP_ID, 'INV_ONHAND_BALANCE', 9);

161: WF_EVENT.AddParameterToList (p_name => 'RESPONSIBILITY_ID',
162: p_value => FND_GLOBAL.RESP_ID,
163: p_parameterlist => l_msg_parameter_list);
164: if (g_debug = 1) then
165: inv_trx_util_pub.TRACE('Responsibility ID is '|| FND_GLOBAL.RESP_ID, 'INV_ONHAND_BALANCE', 9);
166: end if;
167:
168:
169: WF_EVENT.AddParameterToList (p_name => 'ECX_TRANSACTION_TYPE',

Line 173: inv_trx_util_pub.TRACE('Transaction Type is '|| 'INV', 'INV_ONHAND_BALANCE', 9);

169: WF_EVENT.AddParameterToList (p_name => 'ECX_TRANSACTION_TYPE',
170: p_value => 'INV',
171: p_parameterlist => l_msg_parameter_list);
172: if (g_debug = 1) then
173: inv_trx_util_pub.TRACE('Transaction Type is '|| 'INV', 'INV_ONHAND_BALANCE', 9);
174: end if;
175:
176:
177: IF ( l_wms_deployment_mode = 'L') then

Line 183: inv_trx_util_pub.TRACE('Transaction SubType is '|| 'ONHAND', 'INV_ONHAND_BALANCE', 9);

179: WF_EVENT.AddParameterToList (p_name => 'ECX_TRANSACTION_SUBTYPE',
180: p_value => 'ONHAND',
181: p_parameterlist => l_msg_parameter_list);
182: if (g_debug = 1) then
183: inv_trx_util_pub.TRACE('Transaction SubType is '|| 'ONHAND', 'INV_ONHAND_BALANCE', 9);
184: end if;
185:
186: ELSE
187:

Line 192: inv_trx_util_pub.TRACE('Transaction SubType is '|| 'ONHAND', 'INV_ONHAND_BALANCE', 9);

188: WF_EVENT.AddParameterToList (p_name => 'ECX_TRANSACTION_SUBTYPE',
189: p_value => 'ONHAND-IN',
190: p_parameterlist => l_msg_parameter_list);
191: if (g_debug = 1) then
192: inv_trx_util_pub.TRACE('Transaction SubType is '|| 'ONHAND', 'INV_ONHAND_BALANCE', 9);
193: end if;
194:
195: END IF;
196:

Line 202: inv_trx_util_pub.TRACE('User_Name is '||FND_GLOBAL.user_name, 'INV_ONHAND_BALANCE', 9);

198: WF_EVENT.AddParameterToList (p_name => 'USER',
199: p_value => FND_GLOBAL.user_name,
200: p_parameterlist => l_msg_parameter_list);
201: if (g_debug = 1) then
202: inv_trx_util_pub.TRACE('User_Name is '||FND_GLOBAL.user_name, 'INV_ONHAND_BALANCE', 9);
203: end if;
204:
205:
206: WF_EVENT.AddParameterToList (p_name => 'ECX_PARAMETER1',

Line 210: inv_trx_util_pub.TRACE('ECX Parameter1 is '||l_txn_hist_record.Action_Type, 'INV_ONHAND_BALANCE', 9);

206: WF_EVENT.AddParameterToList (p_name => 'ECX_PARAMETER1',
207: p_value => l_txn_hist_record.Entity_Number, --l_txn_hist_record.Action_Type,
208: p_parameterlist => l_msg_parameter_list);
209: if (g_debug = 1) then
210: inv_trx_util_pub.TRACE('ECX Parameter1 is '||l_txn_hist_record.Action_Type, 'INV_ONHAND_BALANCE', 9);
211: end if;
212:
213:
214: WF_EVENT.AddParameterToList (p_name => 'ECX_PARAMETER2',

Line 218: inv_trx_util_pub.TRACE('ECX Parameter2 is '||l_txn_hist_record.Client_Code, 'INV_ONHAND_BALANCE', 9);

214: WF_EVENT.AddParameterToList (p_name => 'ECX_PARAMETER2',
215: p_value => l_txn_hist_record.Client_Code,
216: p_parameterlist => l_msg_parameter_list);
217: if (g_debug = 1) then
218: inv_trx_util_pub.TRACE('ECX Parameter2 is '||l_txn_hist_record.Client_Code, 'INV_ONHAND_BALANCE', 9);
219: end if;
220:
221: INV_TRANSACTIONS_HISTORY_PKG.Create_Update_Txns_History ( l_txn_hist_record,
222: l_xml_document_id,

Line 228: inv_trx_util_pub.TRACE('l_txns_id is '||l_txns_id, 'INV_ONHAND_BALANCE', 9);

224: l_return_status );
225:
226:
227: if (g_debug = 1) then
228: inv_trx_util_pub.TRACE('l_txns_id is '||l_txns_id, 'INV_ONHAND_BALANCE', 9);
229: inv_trx_util_pub.TRACE('l_return_status is '||To_Char(l_Return_Status), 'INV_ONHAND_BALANCE', 9);
230: end if;
231:
232: IF ( l_Return_Status <> rcv_error_pkg.g_ret_sts_success ) THEN

Line 229: inv_trx_util_pub.TRACE('l_return_status is '||To_Char(l_Return_Status), 'INV_ONHAND_BALANCE', 9);

225:
226:
227: if (g_debug = 1) then
228: inv_trx_util_pub.TRACE('l_txns_id is '||l_txns_id, 'INV_ONHAND_BALANCE', 9);
229: inv_trx_util_pub.TRACE('l_return_status is '||To_Char(l_Return_Status), 'INV_ONHAND_BALANCE', 9);
230: end if;
231:
232: IF ( l_Return_Status <> rcv_error_pkg.g_ret_sts_success ) THEN
233: if (g_debug = 1) then

Line 234: inv_trx_util_pub.TRACE('Raise_Event.l_Return_Status is '|| l_Return_Status, 'INV_ONHAND_BALANCE', 9);

230: end if;
231:
232: IF ( l_Return_Status <> rcv_error_pkg.g_ret_sts_success ) THEN
233: if (g_debug = 1) then
234: inv_trx_util_pub.TRACE('Raise_Event.l_Return_Status is '|| l_Return_Status, 'INV_ONHAND_BALANCE', 9);
235: end if;
236: RAISE update_history;
237: END IF;
238:

Line 246: inv_trx_util_pub.TRACE('Raising Business Event', 'INV_ONHAND_BALANCE', 9);

242:
243: IF ( l_Transaction_Code IN ('ADJO', 'SHLO','ONHAND') ) THEN
244:
245: if (g_debug = 1) then
246: inv_trx_util_pub.TRACE('Raising Business Event', 'INV_ONHAND_BALANCE', 9);
247: end if;
248:
249: WF_EVENT.raise ( p_event_name => l_event_name,
250: p_event_key => l_Event_Key,

Line 254: inv_trx_util_pub.TRACE('Completed the Business Event execution', 'INV_ONHAND_BALANCE', 9);

250: p_event_key => l_Event_Key,
251: p_parameters => l_msg_parameter_list );
252:
253: if (g_debug = 1) then
254: inv_trx_util_pub.TRACE('Completed the Business Event execution', 'INV_ONHAND_BALANCE', 9);
255: end if;
256:
257: END IF;
258:

Line 260: inv_trx_util_pub.TRACE('Exiting Raise_Event', 'INV_ONHAND_BALANCE', 9);

256:
257: END IF;
258:
259: if (g_debug = 1) then
260: inv_trx_util_pub.TRACE('Exiting Raise_Event', 'INV_ONHAND_BALANCE', 9);
261: end if;
262:
263: EXCEPTION
264: WHEN invalid_event_name THEN

Line 267: inv_trx_util_pub.TRACE('invalid_event_name exception has occured.', 'INV_ONHAND_BALANCE', 9);

263: EXCEPTION
264: WHEN invalid_event_name THEN
265: x_return_status := rcv_error_pkg.g_ret_sts_error;
266: if (g_debug = 1) then
267: inv_trx_util_pub.TRACE('invalid_event_name exception has occured.', 'INV_ONHAND_BALANCE', 9);
268: end if;
269:
270: WHEN update_history THEN
271: x_return_status := rcv_error_pkg.g_ret_sts_error;

Line 273: inv_trx_util_pub.TRACE('update_history exception has occured.', 'INV_ONHAND_BALANCE', 9);

269:
270: WHEN update_history THEN
271: x_return_status := rcv_error_pkg.g_ret_sts_error;
272: if (g_debug = 1) then
273: inv_trx_util_pub.TRACE('update_history exception has occured.', 'INV_ONHAND_BALANCE', 9);
274: end if;
275:
276: WHEN OTHERS THEN
277: x_return_status := rcv_error_pkg.g_ret_sts_unexp_error;

Line 280: inv_trx_util_pub.TRACE('Unexpected error has occured. Oracle error message is '|| SQLERRM, 'INV_ONHAND_BALANCE', 9);

276: WHEN OTHERS THEN
277: x_return_status := rcv_error_pkg.g_ret_sts_unexp_error;
278:
279: if (g_debug = 1) then
280: inv_trx_util_pub.TRACE('Unexpected error has occured. Oracle error message is '|| SQLERRM, 'INV_ONHAND_BALANCE', 9);
281: end if;
282:
283: END Raise_Event;
284:

Line 311: inv_trx_util_pub.TRACE('Entering Send_Onhand_Document', 'INV_ONHAND_BALANCE', 9);

307: BEGIN
308:
309:
310: IF (g_debug = 1) THEN
311: inv_trx_util_pub.TRACE('Entering Send_Onhand_Document', 'INV_ONHAND_BALANCE', 9);
312: inv_trx_util_pub.TRACE('Entity_ID is ' || P_Entity_ID, 'INV_ONHAND_BALANCE', 9);
313: inv_trx_util_pub.TRACE('Action Type is ' || P_Action_Type, 'INV_ONHAND_BALANCE', 9);
314: inv_trx_util_pub.TRACE('Doc Type is ' || P_Document_Type, 'INV_ONHAND_BALANCE', 9);
315: inv_trx_util_pub.TRACE('p_org_id is ' || P_Org_ID, 'INV_ONHAND_BALANCE', 9);

Line 312: inv_trx_util_pub.TRACE('Entity_ID is ' || P_Entity_ID, 'INV_ONHAND_BALANCE', 9);

308:
309:
310: IF (g_debug = 1) THEN
311: inv_trx_util_pub.TRACE('Entering Send_Onhand_Document', 'INV_ONHAND_BALANCE', 9);
312: inv_trx_util_pub.TRACE('Entity_ID is ' || P_Entity_ID, 'INV_ONHAND_BALANCE', 9);
313: inv_trx_util_pub.TRACE('Action Type is ' || P_Action_Type, 'INV_ONHAND_BALANCE', 9);
314: inv_trx_util_pub.TRACE('Doc Type is ' || P_Document_Type, 'INV_ONHAND_BALANCE', 9);
315: inv_trx_util_pub.TRACE('p_org_id is ' || P_Org_ID, 'INV_ONHAND_BALANCE', 9);
316: inv_trx_util_pub.TRACE('P_client_code is ' || P_client_code, 'INV_ONHAND_BALANCE', 9);

Line 313: inv_trx_util_pub.TRACE('Action Type is ' || P_Action_Type, 'INV_ONHAND_BALANCE', 9);

309:
310: IF (g_debug = 1) THEN
311: inv_trx_util_pub.TRACE('Entering Send_Onhand_Document', 'INV_ONHAND_BALANCE', 9);
312: inv_trx_util_pub.TRACE('Entity_ID is ' || P_Entity_ID, 'INV_ONHAND_BALANCE', 9);
313: inv_trx_util_pub.TRACE('Action Type is ' || P_Action_Type, 'INV_ONHAND_BALANCE', 9);
314: inv_trx_util_pub.TRACE('Doc Type is ' || P_Document_Type, 'INV_ONHAND_BALANCE', 9);
315: inv_trx_util_pub.TRACE('p_org_id is ' || P_Org_ID, 'INV_ONHAND_BALANCE', 9);
316: inv_trx_util_pub.TRACE('P_client_code is ' || P_client_code, 'INV_ONHAND_BALANCE', 9);
317: inv_trx_util_pub.TRACE('p_xml_document_id is ' || p_xml_document_id, 'INV_ONHAND_BALANCE', 9);

Line 314: inv_trx_util_pub.TRACE('Doc Type is ' || P_Document_Type, 'INV_ONHAND_BALANCE', 9);

310: IF (g_debug = 1) THEN
311: inv_trx_util_pub.TRACE('Entering Send_Onhand_Document', 'INV_ONHAND_BALANCE', 9);
312: inv_trx_util_pub.TRACE('Entity_ID is ' || P_Entity_ID, 'INV_ONHAND_BALANCE', 9);
313: inv_trx_util_pub.TRACE('Action Type is ' || P_Action_Type, 'INV_ONHAND_BALANCE', 9);
314: inv_trx_util_pub.TRACE('Doc Type is ' || P_Document_Type, 'INV_ONHAND_BALANCE', 9);
315: inv_trx_util_pub.TRACE('p_org_id is ' || P_Org_ID, 'INV_ONHAND_BALANCE', 9);
316: inv_trx_util_pub.TRACE('P_client_code is ' || P_client_code, 'INV_ONHAND_BALANCE', 9);
317: inv_trx_util_pub.TRACE('p_xml_document_id is ' || p_xml_document_id, 'INV_ONHAND_BALANCE', 9);
318:

Line 315: inv_trx_util_pub.TRACE('p_org_id is ' || P_Org_ID, 'INV_ONHAND_BALANCE', 9);

311: inv_trx_util_pub.TRACE('Entering Send_Onhand_Document', 'INV_ONHAND_BALANCE', 9);
312: inv_trx_util_pub.TRACE('Entity_ID is ' || P_Entity_ID, 'INV_ONHAND_BALANCE', 9);
313: inv_trx_util_pub.TRACE('Action Type is ' || P_Action_Type, 'INV_ONHAND_BALANCE', 9);
314: inv_trx_util_pub.TRACE('Doc Type is ' || P_Document_Type, 'INV_ONHAND_BALANCE', 9);
315: inv_trx_util_pub.TRACE('p_org_id is ' || P_Org_ID, 'INV_ONHAND_BALANCE', 9);
316: inv_trx_util_pub.TRACE('P_client_code is ' || P_client_code, 'INV_ONHAND_BALANCE', 9);
317: inv_trx_util_pub.TRACE('p_xml_document_id is ' || p_xml_document_id, 'INV_ONHAND_BALANCE', 9);
318:
319: END IF;

Line 316: inv_trx_util_pub.TRACE('P_client_code is ' || P_client_code, 'INV_ONHAND_BALANCE', 9);

312: inv_trx_util_pub.TRACE('Entity_ID is ' || P_Entity_ID, 'INV_ONHAND_BALANCE', 9);
313: inv_trx_util_pub.TRACE('Action Type is ' || P_Action_Type, 'INV_ONHAND_BALANCE', 9);
314: inv_trx_util_pub.TRACE('Doc Type is ' || P_Document_Type, 'INV_ONHAND_BALANCE', 9);
315: inv_trx_util_pub.TRACE('p_org_id is ' || P_Org_ID, 'INV_ONHAND_BALANCE', 9);
316: inv_trx_util_pub.TRACE('P_client_code is ' || P_client_code, 'INV_ONHAND_BALANCE', 9);
317: inv_trx_util_pub.TRACE('p_xml_document_id is ' || p_xml_document_id, 'INV_ONHAND_BALANCE', 9);
318:
319: END IF;
320:

Line 317: inv_trx_util_pub.TRACE('p_xml_document_id is ' || p_xml_document_id, 'INV_ONHAND_BALANCE', 9);

313: inv_trx_util_pub.TRACE('Action Type is ' || P_Action_Type, 'INV_ONHAND_BALANCE', 9);
314: inv_trx_util_pub.TRACE('Doc Type is ' || P_Document_Type, 'INV_ONHAND_BALANCE', 9);
315: inv_trx_util_pub.TRACE('p_org_id is ' || P_Org_ID, 'INV_ONHAND_BALANCE', 9);
316: inv_trx_util_pub.TRACE('P_client_code is ' || P_client_code, 'INV_ONHAND_BALANCE', 9);
317: inv_trx_util_pub.TRACE('p_xml_document_id is ' || p_xml_document_id, 'INV_ONHAND_BALANCE', 9);
318:
319: END IF;
320:
321: X_Return_Status := rcv_error_pkg.g_ret_sts_success;

Line 350: inv_trx_util_pub.TRACE('l_wms_deployment_mode ' || l_wms_deployment_mode, 'INV_ONHAND_BALANCE', 9);

346: l_curr_txn_hist_record.Document_Number := l_xml_document_id; --P_Entity_ID;
347:
348: l_wms_deployment_mode := wms_deploy.wms_deployment_mode;
349:
350: inv_trx_util_pub.TRACE('l_wms_deployment_mode ' || l_wms_deployment_mode, 'INV_ONHAND_BALANCE', 9);
351:
352: If (l_wms_deployment_mode = 'L') then
353:
354: l_curr_txn_hist_record.Client_Code := P_client_code;

Line 376: inv_trx_util_pub.TRACE('Item Type is ' || l_curr_txn_hist_record.Item_Type, 'INV_ONHAND_BALANCE', 9);

372: l_curr_txn_hist_record.Trading_Partner_ID := l_party_id;
373:
374:
375: IF (g_debug = 1) THEN
376: inv_trx_util_pub.TRACE('Item Type is ' || l_curr_txn_hist_record.Item_Type, 'INV_ONHAND_BALANCE', 9);
377: inv_trx_util_pub.TRACE('Event Name is ' || l_curr_txn_hist_record.Event_Name, 'INV_ONHAND_BALANCE', 9);
378: inv_trx_util_pub.TRACE('Event Key is ' || l_curr_txn_hist_record.Event_Key, 'INV_ONHAND_BALANCE', 9);
379: inv_trx_util_pub.TRACE('Trading Partner ID is ' || To_Char(l_curr_txn_hist_record.Trading_Partner_ID), 'INV_ONHAND_BALANCE', 9);
380: inv_trx_util_pub.TRACE('Document Type is ' || l_curr_txn_hist_record.Document_Type, 'INV_ONHAND_BALANCE', 9);

Line 377: inv_trx_util_pub.TRACE('Event Name is ' || l_curr_txn_hist_record.Event_Name, 'INV_ONHAND_BALANCE', 9);

373:
374:
375: IF (g_debug = 1) THEN
376: inv_trx_util_pub.TRACE('Item Type is ' || l_curr_txn_hist_record.Item_Type, 'INV_ONHAND_BALANCE', 9);
377: inv_trx_util_pub.TRACE('Event Name is ' || l_curr_txn_hist_record.Event_Name, 'INV_ONHAND_BALANCE', 9);
378: inv_trx_util_pub.TRACE('Event Key is ' || l_curr_txn_hist_record.Event_Key, 'INV_ONHAND_BALANCE', 9);
379: inv_trx_util_pub.TRACE('Trading Partner ID is ' || To_Char(l_curr_txn_hist_record.Trading_Partner_ID), 'INV_ONHAND_BALANCE', 9);
380: inv_trx_util_pub.TRACE('Document Type is ' || l_curr_txn_hist_record.Document_Type, 'INV_ONHAND_BALANCE', 9);
381: inv_trx_util_pub.TRACE('Document Direction is ' || l_curr_txn_hist_record.Document_Direction, 'INV_ONHAND_BALANCE', 9);

Line 378: inv_trx_util_pub.TRACE('Event Key is ' || l_curr_txn_hist_record.Event_Key, 'INV_ONHAND_BALANCE', 9);

374:
375: IF (g_debug = 1) THEN
376: inv_trx_util_pub.TRACE('Item Type is ' || l_curr_txn_hist_record.Item_Type, 'INV_ONHAND_BALANCE', 9);
377: inv_trx_util_pub.TRACE('Event Name is ' || l_curr_txn_hist_record.Event_Name, 'INV_ONHAND_BALANCE', 9);
378: inv_trx_util_pub.TRACE('Event Key is ' || l_curr_txn_hist_record.Event_Key, 'INV_ONHAND_BALANCE', 9);
379: inv_trx_util_pub.TRACE('Trading Partner ID is ' || To_Char(l_curr_txn_hist_record.Trading_Partner_ID), 'INV_ONHAND_BALANCE', 9);
380: inv_trx_util_pub.TRACE('Document Type is ' || l_curr_txn_hist_record.Document_Type, 'INV_ONHAND_BALANCE', 9);
381: inv_trx_util_pub.TRACE('Document Direction is ' || l_curr_txn_hist_record.Document_Direction, 'INV_ONHAND_BALANCE', 9);
382: inv_trx_util_pub.TRACE('Document Number is ' || to_char(l_curr_txn_hist_record.Document_Number), 'INV_ONHAND_BALANCE', 9);

Line 379: inv_trx_util_pub.TRACE('Trading Partner ID is ' || To_Char(l_curr_txn_hist_record.Trading_Partner_ID), 'INV_ONHAND_BALANCE', 9);

375: IF (g_debug = 1) THEN
376: inv_trx_util_pub.TRACE('Item Type is ' || l_curr_txn_hist_record.Item_Type, 'INV_ONHAND_BALANCE', 9);
377: inv_trx_util_pub.TRACE('Event Name is ' || l_curr_txn_hist_record.Event_Name, 'INV_ONHAND_BALANCE', 9);
378: inv_trx_util_pub.TRACE('Event Key is ' || l_curr_txn_hist_record.Event_Key, 'INV_ONHAND_BALANCE', 9);
379: inv_trx_util_pub.TRACE('Trading Partner ID is ' || To_Char(l_curr_txn_hist_record.Trading_Partner_ID), 'INV_ONHAND_BALANCE', 9);
380: inv_trx_util_pub.TRACE('Document Type is ' || l_curr_txn_hist_record.Document_Type, 'INV_ONHAND_BALANCE', 9);
381: inv_trx_util_pub.TRACE('Document Direction is ' || l_curr_txn_hist_record.Document_Direction, 'INV_ONHAND_BALANCE', 9);
382: inv_trx_util_pub.TRACE('Document Number is ' || to_char(l_curr_txn_hist_record.Document_Number), 'INV_ONHAND_BALANCE', 9);
383: END IF;

Line 380: inv_trx_util_pub.TRACE('Document Type is ' || l_curr_txn_hist_record.Document_Type, 'INV_ONHAND_BALANCE', 9);

376: inv_trx_util_pub.TRACE('Item Type is ' || l_curr_txn_hist_record.Item_Type, 'INV_ONHAND_BALANCE', 9);
377: inv_trx_util_pub.TRACE('Event Name is ' || l_curr_txn_hist_record.Event_Name, 'INV_ONHAND_BALANCE', 9);
378: inv_trx_util_pub.TRACE('Event Key is ' || l_curr_txn_hist_record.Event_Key, 'INV_ONHAND_BALANCE', 9);
379: inv_trx_util_pub.TRACE('Trading Partner ID is ' || To_Char(l_curr_txn_hist_record.Trading_Partner_ID), 'INV_ONHAND_BALANCE', 9);
380: inv_trx_util_pub.TRACE('Document Type is ' || l_curr_txn_hist_record.Document_Type, 'INV_ONHAND_BALANCE', 9);
381: inv_trx_util_pub.TRACE('Document Direction is ' || l_curr_txn_hist_record.Document_Direction, 'INV_ONHAND_BALANCE', 9);
382: inv_trx_util_pub.TRACE('Document Number is ' || to_char(l_curr_txn_hist_record.Document_Number), 'INV_ONHAND_BALANCE', 9);
383: END IF;
384:

Line 381: inv_trx_util_pub.TRACE('Document Direction is ' || l_curr_txn_hist_record.Document_Direction, 'INV_ONHAND_BALANCE', 9);

377: inv_trx_util_pub.TRACE('Event Name is ' || l_curr_txn_hist_record.Event_Name, 'INV_ONHAND_BALANCE', 9);
378: inv_trx_util_pub.TRACE('Event Key is ' || l_curr_txn_hist_record.Event_Key, 'INV_ONHAND_BALANCE', 9);
379: inv_trx_util_pub.TRACE('Trading Partner ID is ' || To_Char(l_curr_txn_hist_record.Trading_Partner_ID), 'INV_ONHAND_BALANCE', 9);
380: inv_trx_util_pub.TRACE('Document Type is ' || l_curr_txn_hist_record.Document_Type, 'INV_ONHAND_BALANCE', 9);
381: inv_trx_util_pub.TRACE('Document Direction is ' || l_curr_txn_hist_record.Document_Direction, 'INV_ONHAND_BALANCE', 9);
382: inv_trx_util_pub.TRACE('Document Number is ' || to_char(l_curr_txn_hist_record.Document_Number), 'INV_ONHAND_BALANCE', 9);
383: END IF;
384:
385:

Line 382: inv_trx_util_pub.TRACE('Document Number is ' || to_char(l_curr_txn_hist_record.Document_Number), 'INV_ONHAND_BALANCE', 9);

378: inv_trx_util_pub.TRACE('Event Key is ' || l_curr_txn_hist_record.Event_Key, 'INV_ONHAND_BALANCE', 9);
379: inv_trx_util_pub.TRACE('Trading Partner ID is ' || To_Char(l_curr_txn_hist_record.Trading_Partner_ID), 'INV_ONHAND_BALANCE', 9);
380: inv_trx_util_pub.TRACE('Document Type is ' || l_curr_txn_hist_record.Document_Type, 'INV_ONHAND_BALANCE', 9);
381: inv_trx_util_pub.TRACE('Document Direction is ' || l_curr_txn_hist_record.Document_Direction, 'INV_ONHAND_BALANCE', 9);
382: inv_trx_util_pub.TRACE('Document Number is ' || to_char(l_curr_txn_hist_record.Document_Number), 'INV_ONHAND_BALANCE', 9);
383: END IF;
384:
385:
386: /* Raise event will insert the record into the transaction history table

Line 396: inv_trx_util_pub.TRACE('Send_Receipt_Confirmation.l_Return_Status is '||l_Return_Status, 'INV_ONHAND_BALANCE', 9);

392: l_Return_Status );
393:
394:
395: IF (g_debug = 1) THEN
396: inv_trx_util_pub.TRACE('Send_Receipt_Confirmation.l_Return_Status is '||l_Return_Status, 'INV_ONHAND_BALANCE', 9);
397: inv_trx_util_pub.TRACE('Exiting Send_Onhand_Document', 'INV_ONHAND_BALANCE', 9);
398:
399: END IF;
400:

Line 397: inv_trx_util_pub.TRACE('Exiting Send_Onhand_Document', 'INV_ONHAND_BALANCE', 9);

393:
394:
395: IF (g_debug = 1) THEN
396: inv_trx_util_pub.TRACE('Send_Receipt_Confirmation.l_Return_Status is '||l_Return_Status, 'INV_ONHAND_BALANCE', 9);
397: inv_trx_util_pub.TRACE('Exiting Send_Onhand_Document', 'INV_ONHAND_BALANCE', 9);
398:
399: END IF;
400:
401: IF (l_Return_Status <> rcv_error_pkg.g_ret_sts_success ) THEN

Line 410: inv_trx_util_pub.TRACE('invalid_entity_type exception has occured', 'INV_ONHAND_BALANCE', 9);

406:
407: WHEN invalid_entity_type THEN
408: X_Return_Status := rcv_error_pkg.g_ret_sts_error;
409: IF (g_debug = 1) THEN
410: inv_trx_util_pub.TRACE('invalid_entity_type exception has occured', 'INV_ONHAND_BALANCE', 9);
411: END IF;
412:
413: WHEN invalid_action_type THEN
414: X_Return_Status := rcv_error_pkg.g_ret_sts_error;

Line 416: inv_trx_util_pub.TRACE('invalid_action_type exception has occured', 'INV_ONHAND_BALANCE', 9);

412:
413: WHEN invalid_action_type THEN
414: X_Return_Status := rcv_error_pkg.g_ret_sts_error;
415: IF (g_debug = 1) THEN
416: inv_trx_util_pub.TRACE('invalid_action_type exception has occured', 'INV_ONHAND_BALANCE', 9);
417: END IF;
418:
419: WHEN invalid_doc_type THEN
420: X_Return_Status := rcv_error_pkg.g_ret_sts_error;

Line 422: inv_trx_util_pub.TRACE('invalid_doc_type exception has occured', 'INV_ONHAND_BALANCE', 9);

418:
419: WHEN invalid_doc_type THEN
420: X_Return_Status := rcv_error_pkg.g_ret_sts_error;
421: IF (g_debug = 1) THEN
422: inv_trx_util_pub.TRACE('invalid_doc_type exception has occured', 'INV_ONHAND_BALANCE', 9);
423: END IF;
424:
425: WHEN raise_event_error THEN
426: X_Return_Status := rcv_error_pkg.g_ret_sts_error;

Line 428: inv_trx_util_pub.TRACE('raise_event_error exception has occured, error message is '|| SQLERRM, 'INV_ONHAND_BALANCE', 9);

424:
425: WHEN raise_event_error THEN
426: X_Return_Status := rcv_error_pkg.g_ret_sts_error;
427: IF (g_debug = 1) THEN
428: inv_trx_util_pub.TRACE('raise_event_error exception has occured, error message is '|| SQLERRM, 'INV_ONHAND_BALANCE', 9);
429: END IF;
430:
431: WHEN OTHERS THEN
432: X_Return_Status := rcv_error_pkg.g_ret_sts_error;

Line 434: inv_trx_util_pub.TRACE('Unexpected error has occured. Oracle error message is '|| SQLERRM, 'INV_ONHAND_BALANCE', 9);

430:
431: WHEN OTHERS THEN
432: X_Return_Status := rcv_error_pkg.g_ret_sts_error;
433: IF (g_debug = 1) THEN
434: inv_trx_util_pub.TRACE('Unexpected error has occured. Oracle error message is '|| SQLERRM, 'INV_ONHAND_BALANCE', 9);
435: END IF;
436:
437: END Send_Onhand_Document;
438:

Line 468: inv_trx_util_pub.TRACE('Entering send_onhand', 'INV_ONHAND_BALANCE', 9);

464: l_ret BOOLEAN;
465: BEGIN
466:
467: if (g_debug = 1) then
468: inv_trx_util_pub.TRACE('Entering send_onhand', 'INV_ONHAND_BALANCE', 9);
469: inv_trx_util_pub.TRACE('p_org_id is '||p_org_id, 'INV_ONHAND_BALANCE', 9);
470: inv_trx_util_pub.TRACE('p_warehouse_id is '||p_warehouse_id, 'INV_ONHAND_BALANCE', 9);
471: inv_trx_util_pub.TRACE('p_deploy_mode is '||p_deploy_mode, 'INV_ONHAND_BALANCE', 9);
472: inv_trx_util_pub.TRACE('p_client_code is '||p_client_code, 'INV_ONHAND_BALANCE', 9);

Line 469: inv_trx_util_pub.TRACE('p_org_id is '||p_org_id, 'INV_ONHAND_BALANCE', 9);

465: BEGIN
466:
467: if (g_debug = 1) then
468: inv_trx_util_pub.TRACE('Entering send_onhand', 'INV_ONHAND_BALANCE', 9);
469: inv_trx_util_pub.TRACE('p_org_id is '||p_org_id, 'INV_ONHAND_BALANCE', 9);
470: inv_trx_util_pub.TRACE('p_warehouse_id is '||p_warehouse_id, 'INV_ONHAND_BALANCE', 9);
471: inv_trx_util_pub.TRACE('p_deploy_mode is '||p_deploy_mode, 'INV_ONHAND_BALANCE', 9);
472: inv_trx_util_pub.TRACE('p_client_code is '||p_client_code, 'INV_ONHAND_BALANCE', 9);
473: inv_trx_util_pub.TRACE('p_item_id is ' ||p_item_id, 'INV_ONHAND_BALANCE', 9);

Line 470: inv_trx_util_pub.TRACE('p_warehouse_id is '||p_warehouse_id, 'INV_ONHAND_BALANCE', 9);

466:
467: if (g_debug = 1) then
468: inv_trx_util_pub.TRACE('Entering send_onhand', 'INV_ONHAND_BALANCE', 9);
469: inv_trx_util_pub.TRACE('p_org_id is '||p_org_id, 'INV_ONHAND_BALANCE', 9);
470: inv_trx_util_pub.TRACE('p_warehouse_id is '||p_warehouse_id, 'INV_ONHAND_BALANCE', 9);
471: inv_trx_util_pub.TRACE('p_deploy_mode is '||p_deploy_mode, 'INV_ONHAND_BALANCE', 9);
472: inv_trx_util_pub.TRACE('p_client_code is '||p_client_code, 'INV_ONHAND_BALANCE', 9);
473: inv_trx_util_pub.TRACE('p_item_id is ' ||p_item_id, 'INV_ONHAND_BALANCE', 9);
474: inv_trx_util_pub.TRACE('p_subinventory is ' ||p_subinventory, 'INV_ONHAND_BALANCE', 9);

Line 471: inv_trx_util_pub.TRACE('p_deploy_mode is '||p_deploy_mode, 'INV_ONHAND_BALANCE', 9);

467: if (g_debug = 1) then
468: inv_trx_util_pub.TRACE('Entering send_onhand', 'INV_ONHAND_BALANCE', 9);
469: inv_trx_util_pub.TRACE('p_org_id is '||p_org_id, 'INV_ONHAND_BALANCE', 9);
470: inv_trx_util_pub.TRACE('p_warehouse_id is '||p_warehouse_id, 'INV_ONHAND_BALANCE', 9);
471: inv_trx_util_pub.TRACE('p_deploy_mode is '||p_deploy_mode, 'INV_ONHAND_BALANCE', 9);
472: inv_trx_util_pub.TRACE('p_client_code is '||p_client_code, 'INV_ONHAND_BALANCE', 9);
473: inv_trx_util_pub.TRACE('p_item_id is ' ||p_item_id, 'INV_ONHAND_BALANCE', 9);
474: inv_trx_util_pub.TRACE('p_subinventory is ' ||p_subinventory, 'INV_ONHAND_BALANCE', 9);
475: inv_trx_util_pub.TRACE('p_locator is ' ||p_locator, 'INV_ONHAND_BALANCE', 9);

Line 472: inv_trx_util_pub.TRACE('p_client_code is '||p_client_code, 'INV_ONHAND_BALANCE', 9);

468: inv_trx_util_pub.TRACE('Entering send_onhand', 'INV_ONHAND_BALANCE', 9);
469: inv_trx_util_pub.TRACE('p_org_id is '||p_org_id, 'INV_ONHAND_BALANCE', 9);
470: inv_trx_util_pub.TRACE('p_warehouse_id is '||p_warehouse_id, 'INV_ONHAND_BALANCE', 9);
471: inv_trx_util_pub.TRACE('p_deploy_mode is '||p_deploy_mode, 'INV_ONHAND_BALANCE', 9);
472: inv_trx_util_pub.TRACE('p_client_code is '||p_client_code, 'INV_ONHAND_BALANCE', 9);
473: inv_trx_util_pub.TRACE('p_item_id is ' ||p_item_id, 'INV_ONHAND_BALANCE', 9);
474: inv_trx_util_pub.TRACE('p_subinventory is ' ||p_subinventory, 'INV_ONHAND_BALANCE', 9);
475: inv_trx_util_pub.TRACE('p_locator is ' ||p_locator, 'INV_ONHAND_BALANCE', 9);
476: inv_trx_util_pub.TRACE('p_lot is ' ||p_lot, 'INV_ONHAND_BALANCE', 9);

Line 473: inv_trx_util_pub.TRACE('p_item_id is ' ||p_item_id, 'INV_ONHAND_BALANCE', 9);

469: inv_trx_util_pub.TRACE('p_org_id is '||p_org_id, 'INV_ONHAND_BALANCE', 9);
470: inv_trx_util_pub.TRACE('p_warehouse_id is '||p_warehouse_id, 'INV_ONHAND_BALANCE', 9);
471: inv_trx_util_pub.TRACE('p_deploy_mode is '||p_deploy_mode, 'INV_ONHAND_BALANCE', 9);
472: inv_trx_util_pub.TRACE('p_client_code is '||p_client_code, 'INV_ONHAND_BALANCE', 9);
473: inv_trx_util_pub.TRACE('p_item_id is ' ||p_item_id, 'INV_ONHAND_BALANCE', 9);
474: inv_trx_util_pub.TRACE('p_subinventory is ' ||p_subinventory, 'INV_ONHAND_BALANCE', 9);
475: inv_trx_util_pub.TRACE('p_locator is ' ||p_locator, 'INV_ONHAND_BALANCE', 9);
476: inv_trx_util_pub.TRACE('p_lot is ' ||p_lot, 'INV_ONHAND_BALANCE', 9);
477: inv_trx_util_pub.TRACE('p_grp is ' ||p_grp, 'INV_ONHAND_BALANCE', 9);

Line 474: inv_trx_util_pub.TRACE('p_subinventory is ' ||p_subinventory, 'INV_ONHAND_BALANCE', 9);

470: inv_trx_util_pub.TRACE('p_warehouse_id is '||p_warehouse_id, 'INV_ONHAND_BALANCE', 9);
471: inv_trx_util_pub.TRACE('p_deploy_mode is '||p_deploy_mode, 'INV_ONHAND_BALANCE', 9);
472: inv_trx_util_pub.TRACE('p_client_code is '||p_client_code, 'INV_ONHAND_BALANCE', 9);
473: inv_trx_util_pub.TRACE('p_item_id is ' ||p_item_id, 'INV_ONHAND_BALANCE', 9);
474: inv_trx_util_pub.TRACE('p_subinventory is ' ||p_subinventory, 'INV_ONHAND_BALANCE', 9);
475: inv_trx_util_pub.TRACE('p_locator is ' ||p_locator, 'INV_ONHAND_BALANCE', 9);
476: inv_trx_util_pub.TRACE('p_lot is ' ||p_lot, 'INV_ONHAND_BALANCE', 9);
477: inv_trx_util_pub.TRACE('p_grp is ' ||p_grp, 'INV_ONHAND_BALANCE', 9);
478: inv_trx_util_pub.TRACE('p_display_lot is ' ||p_display_lot, 'INV_ONHAND_BALANCE', 9);

Line 475: inv_trx_util_pub.TRACE('p_locator is ' ||p_locator, 'INV_ONHAND_BALANCE', 9);

471: inv_trx_util_pub.TRACE('p_deploy_mode is '||p_deploy_mode, 'INV_ONHAND_BALANCE', 9);
472: inv_trx_util_pub.TRACE('p_client_code is '||p_client_code, 'INV_ONHAND_BALANCE', 9);
473: inv_trx_util_pub.TRACE('p_item_id is ' ||p_item_id, 'INV_ONHAND_BALANCE', 9);
474: inv_trx_util_pub.TRACE('p_subinventory is ' ||p_subinventory, 'INV_ONHAND_BALANCE', 9);
475: inv_trx_util_pub.TRACE('p_locator is ' ||p_locator, 'INV_ONHAND_BALANCE', 9);
476: inv_trx_util_pub.TRACE('p_lot is ' ||p_lot, 'INV_ONHAND_BALANCE', 9);
477: inv_trx_util_pub.TRACE('p_grp is ' ||p_grp, 'INV_ONHAND_BALANCE', 9);
478: inv_trx_util_pub.TRACE('p_display_lot is ' ||p_display_lot, 'INV_ONHAND_BALANCE', 9);
479: end if;

Line 476: inv_trx_util_pub.TRACE('p_lot is ' ||p_lot, 'INV_ONHAND_BALANCE', 9);

472: inv_trx_util_pub.TRACE('p_client_code is '||p_client_code, 'INV_ONHAND_BALANCE', 9);
473: inv_trx_util_pub.TRACE('p_item_id is ' ||p_item_id, 'INV_ONHAND_BALANCE', 9);
474: inv_trx_util_pub.TRACE('p_subinventory is ' ||p_subinventory, 'INV_ONHAND_BALANCE', 9);
475: inv_trx_util_pub.TRACE('p_locator is ' ||p_locator, 'INV_ONHAND_BALANCE', 9);
476: inv_trx_util_pub.TRACE('p_lot is ' ||p_lot, 'INV_ONHAND_BALANCE', 9);
477: inv_trx_util_pub.TRACE('p_grp is ' ||p_grp, 'INV_ONHAND_BALANCE', 9);
478: inv_trx_util_pub.TRACE('p_display_lot is ' ||p_display_lot, 'INV_ONHAND_BALANCE', 9);
479: end if;
480:

Line 477: inv_trx_util_pub.TRACE('p_grp is ' ||p_grp, 'INV_ONHAND_BALANCE', 9);

473: inv_trx_util_pub.TRACE('p_item_id is ' ||p_item_id, 'INV_ONHAND_BALANCE', 9);
474: inv_trx_util_pub.TRACE('p_subinventory is ' ||p_subinventory, 'INV_ONHAND_BALANCE', 9);
475: inv_trx_util_pub.TRACE('p_locator is ' ||p_locator, 'INV_ONHAND_BALANCE', 9);
476: inv_trx_util_pub.TRACE('p_lot is ' ||p_lot, 'INV_ONHAND_BALANCE', 9);
477: inv_trx_util_pub.TRACE('p_grp is ' ||p_grp, 'INV_ONHAND_BALANCE', 9);
478: inv_trx_util_pub.TRACE('p_display_lot is ' ||p_display_lot, 'INV_ONHAND_BALANCE', 9);
479: end if;
480:
481:

Line 478: inv_trx_util_pub.TRACE('p_display_lot is ' ||p_display_lot, 'INV_ONHAND_BALANCE', 9);

474: inv_trx_util_pub.TRACE('p_subinventory is ' ||p_subinventory, 'INV_ONHAND_BALANCE', 9);
475: inv_trx_util_pub.TRACE('p_locator is ' ||p_locator, 'INV_ONHAND_BALANCE', 9);
476: inv_trx_util_pub.TRACE('p_lot is ' ||p_lot, 'INV_ONHAND_BALANCE', 9);
477: inv_trx_util_pub.TRACE('p_grp is ' ||p_grp, 'INV_ONHAND_BALANCE', 9);
478: inv_trx_util_pub.TRACE('p_display_lot is ' ||p_display_lot, 'INV_ONHAND_BALANCE', 9);
479: end if;
480:
481:
482: x_errbuf := 'Success';

Line 489: inv_trx_util_pub.TRACE('Initialize, rows deleted : '||sql%rowcount, 'INV_ONHAND_BALANCE', 9);

485: --initialize
486: begin
487: delete from MTL_LSP_ONHAND_BALANCE_TMP;
488: if (g_debug = 1) then
489: inv_trx_util_pub.TRACE('Initialize, rows deleted : '||sql%rowcount, 'INV_ONHAND_BALANCE', 9);
490: end if;
491:
492: exception
493: when others then

Line 495: inv_trx_util_pub.TRACE('Exception : '||sqlerrm||' occurred in delete_temp_table', 'INV_ONHAND_BALANCE', 9);

491:
492: exception
493: when others then
494: if (g_debug = 1) then
495: inv_trx_util_pub.TRACE('Exception : '||sqlerrm||' occurred in delete_temp_table', 'INV_ONHAND_BALANCE', 9);
496: end if;
497: ROLLBACK;
498:
499: end;

Line 521: inv_trx_util_pub.TRACE('l_entity_id is ' || l_entity_id, 'INV_ONHAND_BALANCE', 9);

517:
518: l_xml_doc_id :=l_entity_id;
519:
520: if (g_debug = 1) then
521: inv_trx_util_pub.TRACE('l_entity_id is ' || l_entity_id, 'INV_ONHAND_BALANCE', 9);
522: end if;
523:
524: l_insert_stmt :='insert into MTL_LSP_ONHAND_BALANCE_TMP(ITEM_ID, ITEM, ITEM_DESCRIPTION, PRIMARY_UOM, PRIMARY_QUANTITY, SECONDARY_UOM, SECONDARY_QUANTITY, CATEGORY, CONTAINERIZED_FLAG, ONHAND_STATUS, SNAPSHOT_DATE, XML_DOCUMENT_ID ';
525: l_select_stmt :='select item_id, item, ITEM_DESCRIPTION, PRIMARY_UOM, sum(PRIMARY_QUANTITY), SECONDARY_UOM, sum(SECONDARY_QUANTITY), CATEGORY, CONTAINERIZED_FLAG, ONHAND_STATUS, SNAPSHOT_DATE, '||l_xml_doc_id;

Line 575: inv_trx_util_pub.TRACE('l_insert_stmt : '||l_insert_stmt, 'INV_ONHAND_BALANCE', 9);

571: end if;
572:
573: l_stmt := l_insert_stmt||') '||l_select_stmt||' from mtl_onhand_sync_v '||l_where_stmt||l_group_by;
574:
575: inv_trx_util_pub.TRACE('l_insert_stmt : '||l_insert_stmt, 'INV_ONHAND_BALANCE', 9);
576: inv_trx_util_pub.TRACE('l_select_stmt : '||l_select_stmt, 'INV_ONHAND_BALANCE', 9);
577: inv_trx_util_pub.TRACE('l_where_stmt : '||l_where_stmt, 'INV_ONHAND_BALANCE', 9);
578: inv_trx_util_pub.TRACE('l_group_by : '||l_group_by, 'INV_ONHAND_BALANCE', 9);
579:

Line 576: inv_trx_util_pub.TRACE('l_select_stmt : '||l_select_stmt, 'INV_ONHAND_BALANCE', 9);

572:
573: l_stmt := l_insert_stmt||') '||l_select_stmt||' from mtl_onhand_sync_v '||l_where_stmt||l_group_by;
574:
575: inv_trx_util_pub.TRACE('l_insert_stmt : '||l_insert_stmt, 'INV_ONHAND_BALANCE', 9);
576: inv_trx_util_pub.TRACE('l_select_stmt : '||l_select_stmt, 'INV_ONHAND_BALANCE', 9);
577: inv_trx_util_pub.TRACE('l_where_stmt : '||l_where_stmt, 'INV_ONHAND_BALANCE', 9);
578: inv_trx_util_pub.TRACE('l_group_by : '||l_group_by, 'INV_ONHAND_BALANCE', 9);
579:
580: EXECUTE IMMEDIATE l_stmt ;

Line 577: inv_trx_util_pub.TRACE('l_where_stmt : '||l_where_stmt, 'INV_ONHAND_BALANCE', 9);

573: l_stmt := l_insert_stmt||') '||l_select_stmt||' from mtl_onhand_sync_v '||l_where_stmt||l_group_by;
574:
575: inv_trx_util_pub.TRACE('l_insert_stmt : '||l_insert_stmt, 'INV_ONHAND_BALANCE', 9);
576: inv_trx_util_pub.TRACE('l_select_stmt : '||l_select_stmt, 'INV_ONHAND_BALANCE', 9);
577: inv_trx_util_pub.TRACE('l_where_stmt : '||l_where_stmt, 'INV_ONHAND_BALANCE', 9);
578: inv_trx_util_pub.TRACE('l_group_by : '||l_group_by, 'INV_ONHAND_BALANCE', 9);
579:
580: EXECUTE IMMEDIATE l_stmt ;
581:

Line 578: inv_trx_util_pub.TRACE('l_group_by : '||l_group_by, 'INV_ONHAND_BALANCE', 9);

574:
575: inv_trx_util_pub.TRACE('l_insert_stmt : '||l_insert_stmt, 'INV_ONHAND_BALANCE', 9);
576: inv_trx_util_pub.TRACE('l_select_stmt : '||l_select_stmt, 'INV_ONHAND_BALANCE', 9);
577: inv_trx_util_pub.TRACE('l_where_stmt : '||l_where_stmt, 'INV_ONHAND_BALANCE', 9);
578: inv_trx_util_pub.TRACE('l_group_by : '||l_group_by, 'INV_ONHAND_BALANCE', 9);
579:
580: EXECUTE IMMEDIATE l_stmt ;
581:
582:

Line 584: inv_trx_util_pub.TRACE('Rows inserted : '||sql%rowcount, 'INV_ONHAND_BALANCE', 9);

580: EXECUTE IMMEDIATE l_stmt ;
581:
582:
583: if (g_debug = 1) then
584: inv_trx_util_pub.TRACE('Rows inserted : '||sql%rowcount, 'INV_ONHAND_BALANCE', 9);
585: end if;
586:
587: Send_Onhand_Document (P_Entity_ID => l_entity_id,
588: P_Entity_Type => 'INVMOQD',

Line 597: inv_trx_util_pub.TRACE('Send_Onhand_Document.l_return_status is ' || l_return_status, 'INV_ONHAND_BALANCE', 9);

593: p_xml_document_id => l_xml_doc_id,
594: X_Return_Status => l_return_status );
595:
596: if (g_debug = 1) then
597: inv_trx_util_pub.TRACE('Send_Onhand_Document.l_return_status is ' || l_return_status, 'INV_ONHAND_BALANCE', 9);
598: inv_trx_util_pub.TRACE('Exiting Send_Document call', 'INV_ONHAND_BALANCE', 9);
599: end if;
600:
601: if l_return_status <> rcv_error_pkg.g_ret_sts_success then

Line 598: inv_trx_util_pub.TRACE('Exiting Send_Document call', 'INV_ONHAND_BALANCE', 9);

594: X_Return_Status => l_return_status );
595:
596: if (g_debug = 1) then
597: inv_trx_util_pub.TRACE('Send_Onhand_Document.l_return_status is ' || l_return_status, 'INV_ONHAND_BALANCE', 9);
598: inv_trx_util_pub.TRACE('Exiting Send_Document call', 'INV_ONHAND_BALANCE', 9);
599: end if;
600:
601: if l_return_status <> rcv_error_pkg.g_ret_sts_success then
602: l_ret :=fnd_concurrent.set_completion_status('ERROR', 'Error');

Line 611: inv_trx_util_pub.TRACE('Exception : '||sqlerrm||' occurred in Send_Onhand_Document', 'INV_ONHAND_BALANCE', 9);

607: EXCEPTION
608: WHEN OTHERS THEN
609:
610: if (g_debug = 1) then
611: inv_trx_util_pub.TRACE('Exception : '||sqlerrm||' occurred in Send_Onhand_Document', 'INV_ONHAND_BALANCE', 9);
612: end if;
613: ROLLBACK;
614:
615: l_ret :=fnd_concurrent.set_completion_status('ERROR', 'Error');