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

Line 24: inv_trx_util_pub.TRACE('Entering Update_Txn_Hist_Err_WF', 'INV_TRANSACTIONS_UTIL2', 9);

20:
21: BEGIN
22:
23: if (g_debug = 1) then
24: inv_trx_util_pub.TRACE('Entering Update_Txn_Hist_Err_WF', 'INV_TRANSACTIONS_UTIL2', 9);
25: inv_trx_util_pub.TRACE('item_type is '||item_type, 'INV_TRANSACTIONS_UTIL2', 9);
26: inv_trx_util_pub.TRACE('item_key is '||item_key, 'INV_TRANSACTIONS_UTIL2', 9);
27: inv_trx_util_pub.TRACE('actid is '||actid, 'INV_TRANSACTIONS_UTIL2', 9);
28: inv_trx_util_pub.TRACE('funcmode is '||funcmode, 'INV_TRANSACTIONS_UTIL2', 9);

Line 25: inv_trx_util_pub.TRACE('item_type is '||item_type, 'INV_TRANSACTIONS_UTIL2', 9);

21: BEGIN
22:
23: if (g_debug = 1) then
24: inv_trx_util_pub.TRACE('Entering Update_Txn_Hist_Err_WF', 'INV_TRANSACTIONS_UTIL2', 9);
25: inv_trx_util_pub.TRACE('item_type is '||item_type, 'INV_TRANSACTIONS_UTIL2', 9);
26: inv_trx_util_pub.TRACE('item_key is '||item_key, 'INV_TRANSACTIONS_UTIL2', 9);
27: inv_trx_util_pub.TRACE('actid is '||actid, 'INV_TRANSACTIONS_UTIL2', 9);
28: inv_trx_util_pub.TRACE('funcmode is '||funcmode, 'INV_TRANSACTIONS_UTIL2', 9);
29: end if;

Line 26: inv_trx_util_pub.TRACE('item_key is '||item_key, 'INV_TRANSACTIONS_UTIL2', 9);

22:
23: if (g_debug = 1) then
24: inv_trx_util_pub.TRACE('Entering Update_Txn_Hist_Err_WF', 'INV_TRANSACTIONS_UTIL2', 9);
25: inv_trx_util_pub.TRACE('item_type is '||item_type, 'INV_TRANSACTIONS_UTIL2', 9);
26: inv_trx_util_pub.TRACE('item_key is '||item_key, 'INV_TRANSACTIONS_UTIL2', 9);
27: inv_trx_util_pub.TRACE('actid is '||actid, 'INV_TRANSACTIONS_UTIL2', 9);
28: inv_trx_util_pub.TRACE('funcmode is '||funcmode, 'INV_TRANSACTIONS_UTIL2', 9);
29: end if;
30:

Line 27: inv_trx_util_pub.TRACE('actid is '||actid, 'INV_TRANSACTIONS_UTIL2', 9);

23: if (g_debug = 1) then
24: inv_trx_util_pub.TRACE('Entering Update_Txn_Hist_Err_WF', 'INV_TRANSACTIONS_UTIL2', 9);
25: inv_trx_util_pub.TRACE('item_type is '||item_type, 'INV_TRANSACTIONS_UTIL2', 9);
26: inv_trx_util_pub.TRACE('item_key is '||item_key, 'INV_TRANSACTIONS_UTIL2', 9);
27: inv_trx_util_pub.TRACE('actid is '||actid, 'INV_TRANSACTIONS_UTIL2', 9);
28: inv_trx_util_pub.TRACE('funcmode is '||funcmode, 'INV_TRANSACTIONS_UTIL2', 9);
29: end if;
30:
31: IF ( funcmode = 'RUN' ) THEN

Line 28: inv_trx_util_pub.TRACE('funcmode is '||funcmode, 'INV_TRANSACTIONS_UTIL2', 9);

24: inv_trx_util_pub.TRACE('Entering Update_Txn_Hist_Err_WF', 'INV_TRANSACTIONS_UTIL2', 9);
25: inv_trx_util_pub.TRACE('item_type is '||item_type, 'INV_TRANSACTIONS_UTIL2', 9);
26: inv_trx_util_pub.TRACE('item_key is '||item_key, 'INV_TRANSACTIONS_UTIL2', 9);
27: inv_trx_util_pub.TRACE('actid is '||actid, 'INV_TRANSACTIONS_UTIL2', 9);
28: inv_trx_util_pub.TRACE('funcmode is '||funcmode, 'INV_TRANSACTIONS_UTIL2', 9);
29: end if;
30:
31: IF ( funcmode = 'RUN' ) THEN
32: Update_Txn_History ( Item_type,

Line 39: inv_trx_util_pub.TRACE('l_return_status is '||l_return_status, 'INV_TRANSACTIONS_UTIL2', 9);

35: l_return_status
36: );
37:
38: if (g_debug = 1) then
39: inv_trx_util_pub.TRACE('l_return_status is '||l_return_status, 'INV_TRANSACTIONS_UTIL2', 9);
40: end if;
41:
42: IF ( l_return_status <> rcv_error_pkg.g_ret_sts_success ) THEN
43: raise update_history;

Line 47: inv_trx_util_pub.TRACE('resultout is '||resultout, 'INV_TRANSACTIONS_UTIL2', 9);

43: raise update_history;
44: ELSE
45: resultout := 'COMPLETE:SUCCESS';
46: if (g_debug = 1) then
47: inv_trx_util_pub.TRACE('resultout is '||resultout, 'INV_TRANSACTIONS_UTIL2', 9);
48: end if;
49: RETURN;
50: END IF;
51:

Line 58: inv_trx_util_pub.TRACE('update_history exception has occured', 'INV_TRANSACTIONS_UTIL2', 9);

54: EXCEPTION
55: WHEN update_history THEN
56: resultout := 'COMPLETE:FAILURE';
57: if (g_debug = 1) then
58: inv_trx_util_pub.TRACE('update_history exception has occured', 'INV_TRANSACTIONS_UTIL2', 9);
59: end if;
60: raise;
61: WHEN OTHERS THEN
62: resultout := 'COMPLETE:FAILURE';

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

60: raise;
61: WHEN OTHERS THEN
62: resultout := 'COMPLETE:FAILURE';
63: if (g_debug = 1) then
64: inv_trx_util_pub.TRACE('Unexpected error has occured. Oracle error message is '|| SQLERRM, 'INV_TRANSACTIONS_UTIL2', 9);
65: end if;
66: raise;
67: END Update_Txn_Hist_Err_WF;
68:

Line 85: inv_trx_util_pub.TRACE('Entering Update_Txn_Hist_Success_WF', 'INV_TRANSACTIONS_UTIL2', 9);

81:
82: BEGIN
83:
84: if (g_debug = 1) then
85: inv_trx_util_pub.TRACE('Entering Update_Txn_Hist_Success_WF', 'INV_TRANSACTIONS_UTIL2', 9);
86: inv_trx_util_pub.TRACE('item_type is '||item_type, 'INV_TRANSACTIONS_UTIL2', 9);
87: inv_trx_util_pub.TRACE('item_key is '||item_key, 'INV_TRANSACTIONS_UTIL2', 9);
88: inv_trx_util_pub.TRACE('actid is '||actid, 'INV_TRANSACTIONS_UTIL2', 9);
89: inv_trx_util_pub.TRACE('funcmode is '||funcmode, 'INV_TRANSACTIONS_UTIL2', 9);

Line 86: inv_trx_util_pub.TRACE('item_type is '||item_type, 'INV_TRANSACTIONS_UTIL2', 9);

82: BEGIN
83:
84: if (g_debug = 1) then
85: inv_trx_util_pub.TRACE('Entering Update_Txn_Hist_Success_WF', 'INV_TRANSACTIONS_UTIL2', 9);
86: inv_trx_util_pub.TRACE('item_type is '||item_type, 'INV_TRANSACTIONS_UTIL2', 9);
87: inv_trx_util_pub.TRACE('item_key is '||item_key, 'INV_TRANSACTIONS_UTIL2', 9);
88: inv_trx_util_pub.TRACE('actid is '||actid, 'INV_TRANSACTIONS_UTIL2', 9);
89: inv_trx_util_pub.TRACE('funcmode is '||funcmode, 'INV_TRANSACTIONS_UTIL2', 9);
90: end if;

Line 87: inv_trx_util_pub.TRACE('item_key is '||item_key, 'INV_TRANSACTIONS_UTIL2', 9);

83:
84: if (g_debug = 1) then
85: inv_trx_util_pub.TRACE('Entering Update_Txn_Hist_Success_WF', 'INV_TRANSACTIONS_UTIL2', 9);
86: inv_trx_util_pub.TRACE('item_type is '||item_type, 'INV_TRANSACTIONS_UTIL2', 9);
87: inv_trx_util_pub.TRACE('item_key is '||item_key, 'INV_TRANSACTIONS_UTIL2', 9);
88: inv_trx_util_pub.TRACE('actid is '||actid, 'INV_TRANSACTIONS_UTIL2', 9);
89: inv_trx_util_pub.TRACE('funcmode is '||funcmode, 'INV_TRANSACTIONS_UTIL2', 9);
90: end if;
91:

Line 88: inv_trx_util_pub.TRACE('actid is '||actid, 'INV_TRANSACTIONS_UTIL2', 9);

84: if (g_debug = 1) then
85: inv_trx_util_pub.TRACE('Entering Update_Txn_Hist_Success_WF', 'INV_TRANSACTIONS_UTIL2', 9);
86: inv_trx_util_pub.TRACE('item_type is '||item_type, 'INV_TRANSACTIONS_UTIL2', 9);
87: inv_trx_util_pub.TRACE('item_key is '||item_key, 'INV_TRANSACTIONS_UTIL2', 9);
88: inv_trx_util_pub.TRACE('actid is '||actid, 'INV_TRANSACTIONS_UTIL2', 9);
89: inv_trx_util_pub.TRACE('funcmode is '||funcmode, 'INV_TRANSACTIONS_UTIL2', 9);
90: end if;
91:
92: IF ( funcmode = 'RUN' ) THEN

Line 89: inv_trx_util_pub.TRACE('funcmode is '||funcmode, 'INV_TRANSACTIONS_UTIL2', 9);

85: inv_trx_util_pub.TRACE('Entering Update_Txn_Hist_Success_WF', 'INV_TRANSACTIONS_UTIL2', 9);
86: inv_trx_util_pub.TRACE('item_type is '||item_type, 'INV_TRANSACTIONS_UTIL2', 9);
87: inv_trx_util_pub.TRACE('item_key is '||item_key, 'INV_TRANSACTIONS_UTIL2', 9);
88: inv_trx_util_pub.TRACE('actid is '||actid, 'INV_TRANSACTIONS_UTIL2', 9);
89: inv_trx_util_pub.TRACE('funcmode is '||funcmode, 'INV_TRANSACTIONS_UTIL2', 9);
90: end if;
91:
92: IF ( funcmode = 'RUN' ) THEN
93:

Line 102: inv_trx_util_pub.TRACE('Update_Txn_Hist_Success_WF.l_return_status is '||l_return_status, 'INV_TRANSACTIONS_UTIL2', 9);

98: l_return_status
99: );
100:
101: if (g_debug = 1) then
102: inv_trx_util_pub.TRACE('Update_Txn_Hist_Success_WF.l_return_status is '||l_return_status, 'INV_TRANSACTIONS_UTIL2', 9);
103: end if;
104:
105: IF ( l_return_status <> rcv_error_pkg.g_ret_sts_success ) THEN
106: raise update_history;

Line 110: inv_trx_util_pub.TRACE('Update_Txn_Hist_Success_WF.resultout is '||resultout, 'INV_TRANSACTIONS_UTIL2', 9);

106: raise update_history;
107: ELSE
108: resultout := 'COMPLETE:SUCCESS';
109: if (g_debug = 1) then
110: inv_trx_util_pub.TRACE('Update_Txn_Hist_Success_WF.resultout is '||resultout, 'INV_TRANSACTIONS_UTIL2', 9);
111: end if;
112: RETURN;
113: END IF;
114: END IF;

Line 117: inv_trx_util_pub.TRACE('Exiting Update_Txn_Hist_Success_WF', 'INV_TRANSACTIONS_UTIL2', 9);

113: END IF;
114: END IF;
115:
116: if (g_debug = 1) then
117: inv_trx_util_pub.TRACE('Exiting Update_Txn_Hist_Success_WF', 'INV_TRANSACTIONS_UTIL2', 9);
118: end if;
119:
120: resultout := 'COMPLETE:SUCCESS';
121:

Line 134: inv_trx_util_pub.TRACE('update_history exception has occured.', 'INV_TRANSACTIONS_UTIL2', 9);

130:
131:
132: resultout := 'COMPLETE:FAILURE';
133: if (g_debug = 1) then
134: inv_trx_util_pub.TRACE('update_history exception has occured.', 'INV_TRANSACTIONS_UTIL2', 9);
135: end if;
136: raise;
137: WHEN OTHERS THEN
138:

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

144:
145:
146: resultout := 'COMPLETE:FAILURE';
147: if (g_debug = 1) then
148: inv_trx_util_pub.TRACE('Unexpected error has occured. Oracle error message is '|| SQLERRM, 'INV_TRANSACTIONS_UTIL2', 9);
149: end if;
150: raise;
151: END Update_Txn_Hist_Success_WF;
152:

Line 178: inv_trx_util_pub.TRACE('Entering Update_Txn_History', 'INV_TRANSACTIONS_UTIL2', 9);

174:
175: BEGIN
176:
177: if (g_debug = 1) then
178: inv_trx_util_pub.TRACE('Entering Update_Txn_History', 'INV_TRANSACTIONS_UTIL2', 9);
179: inv_trx_util_pub.TRACE('p_transaction_status is '||p_transaction_status, 'INV_TRANSACTIONS_UTIL2', 9);
180: end if;
181:
182: IF ( p_item_type = 'INVADJTO' ) THEN

Line 179: inv_trx_util_pub.TRACE('p_transaction_status is '||p_transaction_status, 'INV_TRANSACTIONS_UTIL2', 9);

175: BEGIN
176:
177: if (g_debug = 1) then
178: inv_trx_util_pub.TRACE('Entering Update_Txn_History', 'INV_TRANSACTIONS_UTIL2', 9);
179: inv_trx_util_pub.TRACE('p_transaction_status is '||p_transaction_status, 'INV_TRANSACTIONS_UTIL2', 9);
180: end if;
181:
182: IF ( p_item_type = 'INVADJTO' ) THEN
183: l_document_type := 'ADJ';

Line 191: inv_trx_util_pub.TRACE('entity number: '||l_txns_history_rec.entity_number, 'INV_TRANSACTIONS_HISTORY_PKG', 9);

187: l_txn_direction := 'O';
188: END IF;
189:
190: if (g_debug = 1) then
191: inv_trx_util_pub.TRACE('entity number: '||l_txns_history_rec.entity_number, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
192: end if;
193:
194: inv_transactions_history_pkg.Get_Txns_History( p_item_type,
195: p_item_key,

Line 204: inv_trx_util_pub.TRACE('Update_Txn_History.x_return_status is '||x_return_status, 'INV_TRANSACTIONS_UTIL2', 9);

200:
201:
202:
203: if (g_debug = 1) then
204: inv_trx_util_pub.TRACE('Update_Txn_History.x_return_status is '||x_return_status, 'INV_TRANSACTIONS_UTIL2', 9);
205: end if;
206:
207: l_txns_history_rec.transaction_status := p_transaction_status;
208:

Line 220: inv_trx_util_pub.TRACE('Update_Txn_History.x_return_status is '||x_return_status, 'INV_TRANSACTIONS_UTIL2', 9);

216: x_return_status );
217:
218:
219: if (g_debug = 1) then
220: inv_trx_util_pub.TRACE('Update_Txn_History.x_return_status is '||x_return_status, 'INV_TRANSACTIONS_UTIL2', 9);
221: end if;
222:
223: IF ( x_return_status <> rcv_error_pkg.g_ret_sts_success ) THEN
224: raise update_history;

Line 230: inv_trx_util_pub.TRACE('Exiting Update_Txn_History', 'INV_TRANSACTIONS_UTIL2', 9);

226: COMMIT;
227: END IF;
228:
229: if (g_debug = 1) then
230: inv_trx_util_pub.TRACE('Exiting Update_Txn_History', 'INV_TRANSACTIONS_UTIL2', 9);
231: end if;
232:
233: EXCEPTION
234: WHEN update_history THEN

Line 244: inv_trx_util_pub.TRACE('update_history exception has occured.', 'INV_TRANSACTIONS_UTIL2', 9);

240: and transaction_status = 'IP';
241:
242: x_return_status := rcv_error_pkg.g_ret_sts_error;
243: if (g_debug = 1) then
244: inv_trx_util_pub.TRACE('update_history exception has occured.', 'INV_TRANSACTIONS_UTIL2', 9);
245: end if;
246: ROLLBACK;
247: WHEN OTHERS THEN
248:

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

253: and transaction_status = 'IP';
254:
255: x_return_status := rcv_error_pkg.g_ret_sts_error;
256: if (g_debug = 1) then
257: inv_trx_util_pub.TRACE('Unexpected error has occured. Oracle error message is '|| SQLERRM, 'INV_TRANSACTIONS_UTIL2', 9);
258: end if;
259: ROLLBACK;
260: END Update_Txn_History;
261:

Line 289: inv_trx_util_pub.TRACE('Entering send_inventory_adjustment', 'INV_TRANSACTIONS_UTIL2', 9);

285:
286: BEGIN
287:
288: if (g_debug = 1) then
289: inv_trx_util_pub.TRACE('Entering send_inventory_adjustment', 'INV_TRANSACTIONS_UTIL2', 9);
290: inv_trx_util_pub.TRACE('Entity_ID is ' || P_Entity_ID, 'INV_TRANSACTIONS_UTIL2', 9);
291: inv_trx_util_pub.TRACE('Entity Type is ' || P_Entity_Type, 'INV_TRANSACTIONS_UTIL2', 9);
292: inv_trx_util_pub.TRACE('Action Type is ' || P_Action_Type, 'INV_TRANSACTIONS_UTIL2', 9);
293: inv_trx_util_pub.TRACE('Dcument Type is ' || p_document_type, 'INV_TRANSACTIONS_UTIL2', 9);

Line 290: inv_trx_util_pub.TRACE('Entity_ID is ' || P_Entity_ID, 'INV_TRANSACTIONS_UTIL2', 9);

286: BEGIN
287:
288: if (g_debug = 1) then
289: inv_trx_util_pub.TRACE('Entering send_inventory_adjustment', 'INV_TRANSACTIONS_UTIL2', 9);
290: inv_trx_util_pub.TRACE('Entity_ID is ' || P_Entity_ID, 'INV_TRANSACTIONS_UTIL2', 9);
291: inv_trx_util_pub.TRACE('Entity Type is ' || P_Entity_Type, 'INV_TRANSACTIONS_UTIL2', 9);
292: inv_trx_util_pub.TRACE('Action Type is ' || P_Action_Type, 'INV_TRANSACTIONS_UTIL2', 9);
293: inv_trx_util_pub.TRACE('Dcument Type is ' || p_document_type, 'INV_TRANSACTIONS_UTIL2', 9);
294: inv_trx_util_pub.TRACE('Org ID is ' || to_char(P_Org_ID), 'INV_TRANSACTIONS_UTIL2', 9);

Line 291: inv_trx_util_pub.TRACE('Entity Type is ' || P_Entity_Type, 'INV_TRANSACTIONS_UTIL2', 9);

287:
288: if (g_debug = 1) then
289: inv_trx_util_pub.TRACE('Entering send_inventory_adjustment', 'INV_TRANSACTIONS_UTIL2', 9);
290: inv_trx_util_pub.TRACE('Entity_ID is ' || P_Entity_ID, 'INV_TRANSACTIONS_UTIL2', 9);
291: inv_trx_util_pub.TRACE('Entity Type is ' || P_Entity_Type, 'INV_TRANSACTIONS_UTIL2', 9);
292: inv_trx_util_pub.TRACE('Action Type is ' || P_Action_Type, 'INV_TRANSACTIONS_UTIL2', 9);
293: inv_trx_util_pub.TRACE('Dcument Type is ' || p_document_type, 'INV_TRANSACTIONS_UTIL2', 9);
294: inv_trx_util_pub.TRACE('Org ID is ' || to_char(P_Org_ID), 'INV_TRANSACTIONS_UTIL2', 9);
295: inv_trx_util_pub.TRACE('Client Code is '|| P_client_code, 'INV_TRANSACTIONS_UTIL2', 9);

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

288: if (g_debug = 1) then
289: inv_trx_util_pub.TRACE('Entering send_inventory_adjustment', 'INV_TRANSACTIONS_UTIL2', 9);
290: inv_trx_util_pub.TRACE('Entity_ID is ' || P_Entity_ID, 'INV_TRANSACTIONS_UTIL2', 9);
291: inv_trx_util_pub.TRACE('Entity Type is ' || P_Entity_Type, 'INV_TRANSACTIONS_UTIL2', 9);
292: inv_trx_util_pub.TRACE('Action Type is ' || P_Action_Type, 'INV_TRANSACTIONS_UTIL2', 9);
293: inv_trx_util_pub.TRACE('Dcument Type is ' || p_document_type, 'INV_TRANSACTIONS_UTIL2', 9);
294: inv_trx_util_pub.TRACE('Org ID is ' || to_char(P_Org_ID), 'INV_TRANSACTIONS_UTIL2', 9);
295: inv_trx_util_pub.TRACE('Client Code is '|| P_client_code, 'INV_TRANSACTIONS_UTIL2', 9);
296: inv_trx_util_pub.TRACE('XML Document ID is '|| to_char(p_xml_document_id), 'INV_TRANSACTIONS_UTIL2', 9);

Line 293: inv_trx_util_pub.TRACE('Dcument Type is ' || p_document_type, 'INV_TRANSACTIONS_UTIL2', 9);

289: inv_trx_util_pub.TRACE('Entering send_inventory_adjustment', 'INV_TRANSACTIONS_UTIL2', 9);
290: inv_trx_util_pub.TRACE('Entity_ID is ' || P_Entity_ID, 'INV_TRANSACTIONS_UTIL2', 9);
291: inv_trx_util_pub.TRACE('Entity Type is ' || P_Entity_Type, 'INV_TRANSACTIONS_UTIL2', 9);
292: inv_trx_util_pub.TRACE('Action Type is ' || P_Action_Type, 'INV_TRANSACTIONS_UTIL2', 9);
293: inv_trx_util_pub.TRACE('Dcument Type is ' || p_document_type, 'INV_TRANSACTIONS_UTIL2', 9);
294: inv_trx_util_pub.TRACE('Org ID is ' || to_char(P_Org_ID), 'INV_TRANSACTIONS_UTIL2', 9);
295: inv_trx_util_pub.TRACE('Client Code is '|| P_client_code, 'INV_TRANSACTIONS_UTIL2', 9);
296: inv_trx_util_pub.TRACE('XML Document ID is '|| to_char(p_xml_document_id), 'INV_TRANSACTIONS_UTIL2', 9);
297: end if;

Line 294: inv_trx_util_pub.TRACE('Org ID is ' || to_char(P_Org_ID), 'INV_TRANSACTIONS_UTIL2', 9);

290: inv_trx_util_pub.TRACE('Entity_ID is ' || P_Entity_ID, 'INV_TRANSACTIONS_UTIL2', 9);
291: inv_trx_util_pub.TRACE('Entity Type is ' || P_Entity_Type, 'INV_TRANSACTIONS_UTIL2', 9);
292: inv_trx_util_pub.TRACE('Action Type is ' || P_Action_Type, 'INV_TRANSACTIONS_UTIL2', 9);
293: inv_trx_util_pub.TRACE('Dcument Type is ' || p_document_type, 'INV_TRANSACTIONS_UTIL2', 9);
294: inv_trx_util_pub.TRACE('Org ID is ' || to_char(P_Org_ID), 'INV_TRANSACTIONS_UTIL2', 9);
295: inv_trx_util_pub.TRACE('Client Code is '|| P_client_code, 'INV_TRANSACTIONS_UTIL2', 9);
296: inv_trx_util_pub.TRACE('XML Document ID is '|| to_char(p_xml_document_id), 'INV_TRANSACTIONS_UTIL2', 9);
297: end if;
298:

Line 295: inv_trx_util_pub.TRACE('Client Code is '|| P_client_code, 'INV_TRANSACTIONS_UTIL2', 9);

291: inv_trx_util_pub.TRACE('Entity Type is ' || P_Entity_Type, 'INV_TRANSACTIONS_UTIL2', 9);
292: inv_trx_util_pub.TRACE('Action Type is ' || P_Action_Type, 'INV_TRANSACTIONS_UTIL2', 9);
293: inv_trx_util_pub.TRACE('Dcument Type is ' || p_document_type, 'INV_TRANSACTIONS_UTIL2', 9);
294: inv_trx_util_pub.TRACE('Org ID is ' || to_char(P_Org_ID), 'INV_TRANSACTIONS_UTIL2', 9);
295: inv_trx_util_pub.TRACE('Client Code is '|| P_client_code, 'INV_TRANSACTIONS_UTIL2', 9);
296: inv_trx_util_pub.TRACE('XML Document ID is '|| to_char(p_xml_document_id), 'INV_TRANSACTIONS_UTIL2', 9);
297: end if;
298:
299: X_Return_Status := rcv_error_pkg.g_ret_sts_success;

Line 296: inv_trx_util_pub.TRACE('XML Document ID is '|| to_char(p_xml_document_id), 'INV_TRANSACTIONS_UTIL2', 9);

292: inv_trx_util_pub.TRACE('Action Type is ' || P_Action_Type, 'INV_TRANSACTIONS_UTIL2', 9);
293: inv_trx_util_pub.TRACE('Dcument Type is ' || p_document_type, 'INV_TRANSACTIONS_UTIL2', 9);
294: inv_trx_util_pub.TRACE('Org ID is ' || to_char(P_Org_ID), 'INV_TRANSACTIONS_UTIL2', 9);
295: inv_trx_util_pub.TRACE('Client Code is '|| P_client_code, 'INV_TRANSACTIONS_UTIL2', 9);
296: inv_trx_util_pub.TRACE('XML Document ID is '|| to_char(p_xml_document_id), 'INV_TRANSACTIONS_UTIL2', 9);
297: end if;
298:
299: X_Return_Status := rcv_error_pkg.g_ret_sts_success;
300:

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

349:
350: l_curr_txn_hist_record.Trading_Partner_ID := l_party_id;
351:
352: if (g_debug = 1) then
353: inv_trx_util_pub.TRACE('Item Type is ' || l_curr_txn_hist_record.Item_Type, 'INV_TRANSACTIONS_UTIL2', 9);
354: inv_trx_util_pub.TRACE('Event Name is ' || l_curr_txn_hist_record.Event_Name, 'INV_TRANSACTIONS_UTIL2', 9);
355: inv_trx_util_pub.TRACE('Event Key is ' || l_curr_txn_hist_record.Event_Key, 'INV_TRANSACTIONS_UTIL2', 9);
356: inv_trx_util_pub.TRACE('Trading Partner ID is ' || To_Char(l_curr_txn_hist_record.Trading_Partner_ID), 'INV_TRANSACTIONS_UTIL2', 9);
357: inv_trx_util_pub.TRACE('Document Type is ' || l_curr_txn_hist_record.Document_Type, 'INV_TRANSACTIONS_UTIL2', 9);

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

350: l_curr_txn_hist_record.Trading_Partner_ID := l_party_id;
351:
352: if (g_debug = 1) then
353: inv_trx_util_pub.TRACE('Item Type is ' || l_curr_txn_hist_record.Item_Type, 'INV_TRANSACTIONS_UTIL2', 9);
354: inv_trx_util_pub.TRACE('Event Name is ' || l_curr_txn_hist_record.Event_Name, 'INV_TRANSACTIONS_UTIL2', 9);
355: inv_trx_util_pub.TRACE('Event Key is ' || l_curr_txn_hist_record.Event_Key, 'INV_TRANSACTIONS_UTIL2', 9);
356: inv_trx_util_pub.TRACE('Trading Partner ID is ' || To_Char(l_curr_txn_hist_record.Trading_Partner_ID), 'INV_TRANSACTIONS_UTIL2', 9);
357: inv_trx_util_pub.TRACE('Document Type is ' || l_curr_txn_hist_record.Document_Type, 'INV_TRANSACTIONS_UTIL2', 9);
358: inv_trx_util_pub.TRACE('Document Direction is ' || l_curr_txn_hist_record.Document_Direction, 'INV_TRANSACTIONS_UTIL2', 9);

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

351:
352: if (g_debug = 1) then
353: inv_trx_util_pub.TRACE('Item Type is ' || l_curr_txn_hist_record.Item_Type, 'INV_TRANSACTIONS_UTIL2', 9);
354: inv_trx_util_pub.TRACE('Event Name is ' || l_curr_txn_hist_record.Event_Name, 'INV_TRANSACTIONS_UTIL2', 9);
355: inv_trx_util_pub.TRACE('Event Key is ' || l_curr_txn_hist_record.Event_Key, 'INV_TRANSACTIONS_UTIL2', 9);
356: inv_trx_util_pub.TRACE('Trading Partner ID is ' || To_Char(l_curr_txn_hist_record.Trading_Partner_ID), 'INV_TRANSACTIONS_UTIL2', 9);
357: inv_trx_util_pub.TRACE('Document Type is ' || l_curr_txn_hist_record.Document_Type, 'INV_TRANSACTIONS_UTIL2', 9);
358: inv_trx_util_pub.TRACE('Document Direction is ' || l_curr_txn_hist_record.Document_Direction, 'INV_TRANSACTIONS_UTIL2', 9);
359: inv_trx_util_pub.TRACE('Document Number is ' || to_char(l_curr_txn_hist_record.Document_Number), 'INV_TRANSACTIONS_UTIL2', 9);

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

352: if (g_debug = 1) then
353: inv_trx_util_pub.TRACE('Item Type is ' || l_curr_txn_hist_record.Item_Type, 'INV_TRANSACTIONS_UTIL2', 9);
354: inv_trx_util_pub.TRACE('Event Name is ' || l_curr_txn_hist_record.Event_Name, 'INV_TRANSACTIONS_UTIL2', 9);
355: inv_trx_util_pub.TRACE('Event Key is ' || l_curr_txn_hist_record.Event_Key, 'INV_TRANSACTIONS_UTIL2', 9);
356: inv_trx_util_pub.TRACE('Trading Partner ID is ' || To_Char(l_curr_txn_hist_record.Trading_Partner_ID), 'INV_TRANSACTIONS_UTIL2', 9);
357: inv_trx_util_pub.TRACE('Document Type is ' || l_curr_txn_hist_record.Document_Type, 'INV_TRANSACTIONS_UTIL2', 9);
358: inv_trx_util_pub.TRACE('Document Direction is ' || l_curr_txn_hist_record.Document_Direction, 'INV_TRANSACTIONS_UTIL2', 9);
359: inv_trx_util_pub.TRACE('Document Number is ' || to_char(l_curr_txn_hist_record.Document_Number), 'INV_TRANSACTIONS_UTIL2', 9);
360: end if;

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

353: inv_trx_util_pub.TRACE('Item Type is ' || l_curr_txn_hist_record.Item_Type, 'INV_TRANSACTIONS_UTIL2', 9);
354: inv_trx_util_pub.TRACE('Event Name is ' || l_curr_txn_hist_record.Event_Name, 'INV_TRANSACTIONS_UTIL2', 9);
355: inv_trx_util_pub.TRACE('Event Key is ' || l_curr_txn_hist_record.Event_Key, 'INV_TRANSACTIONS_UTIL2', 9);
356: inv_trx_util_pub.TRACE('Trading Partner ID is ' || To_Char(l_curr_txn_hist_record.Trading_Partner_ID), 'INV_TRANSACTIONS_UTIL2', 9);
357: inv_trx_util_pub.TRACE('Document Type is ' || l_curr_txn_hist_record.Document_Type, 'INV_TRANSACTIONS_UTIL2', 9);
358: inv_trx_util_pub.TRACE('Document Direction is ' || l_curr_txn_hist_record.Document_Direction, 'INV_TRANSACTIONS_UTIL2', 9);
359: inv_trx_util_pub.TRACE('Document Number is ' || to_char(l_curr_txn_hist_record.Document_Number), 'INV_TRANSACTIONS_UTIL2', 9);
360: end if;
361:

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

354: inv_trx_util_pub.TRACE('Event Name is ' || l_curr_txn_hist_record.Event_Name, 'INV_TRANSACTIONS_UTIL2', 9);
355: inv_trx_util_pub.TRACE('Event Key is ' || l_curr_txn_hist_record.Event_Key, 'INV_TRANSACTIONS_UTIL2', 9);
356: inv_trx_util_pub.TRACE('Trading Partner ID is ' || To_Char(l_curr_txn_hist_record.Trading_Partner_ID), 'INV_TRANSACTIONS_UTIL2', 9);
357: inv_trx_util_pub.TRACE('Document Type is ' || l_curr_txn_hist_record.Document_Type, 'INV_TRANSACTIONS_UTIL2', 9);
358: inv_trx_util_pub.TRACE('Document Direction is ' || l_curr_txn_hist_record.Document_Direction, 'INV_TRANSACTIONS_UTIL2', 9);
359: inv_trx_util_pub.TRACE('Document Number is ' || to_char(l_curr_txn_hist_record.Document_Number), 'INV_TRANSACTIONS_UTIL2', 9);
360: end if;
361:
362:

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

355: inv_trx_util_pub.TRACE('Event Key is ' || l_curr_txn_hist_record.Event_Key, 'INV_TRANSACTIONS_UTIL2', 9);
356: inv_trx_util_pub.TRACE('Trading Partner ID is ' || To_Char(l_curr_txn_hist_record.Trading_Partner_ID), 'INV_TRANSACTIONS_UTIL2', 9);
357: inv_trx_util_pub.TRACE('Document Type is ' || l_curr_txn_hist_record.Document_Type, 'INV_TRANSACTIONS_UTIL2', 9);
358: inv_trx_util_pub.TRACE('Document Direction is ' || l_curr_txn_hist_record.Document_Direction, 'INV_TRANSACTIONS_UTIL2', 9);
359: inv_trx_util_pub.TRACE('Document Number is ' || to_char(l_curr_txn_hist_record.Document_Number), 'INV_TRANSACTIONS_UTIL2', 9);
360: end if;
361:
362:
363: /* Raise event will insert the record into the transaction history table

Line 372: inv_trx_util_pub.TRACE('send_inventory_adjustment.l_Return_Status is '||l_Return_Status, 'INV_TRANSACTIONS_UTIL2', 9);

368: l_xml_document_id,
369: l_Return_Status );
370:
371: if (g_debug = 1) then
372: inv_trx_util_pub.TRACE('send_inventory_adjustment.l_Return_Status is '||l_Return_Status, 'INV_TRANSACTIONS_UTIL2', 9);
373: inv_trx_util_pub.TRACE('Exiting send_inventory_adjustment', 'INV_TRANSACTIONS_UTIL2', 9);
374: end if;
375:
376: IF (l_Return_Status <> rcv_error_pkg.g_ret_sts_success ) THEN

Line 373: inv_trx_util_pub.TRACE('Exiting send_inventory_adjustment', 'INV_TRANSACTIONS_UTIL2', 9);

369: l_Return_Status );
370:
371: if (g_debug = 1) then
372: inv_trx_util_pub.TRACE('send_inventory_adjustment.l_Return_Status is '||l_Return_Status, 'INV_TRANSACTIONS_UTIL2', 9);
373: inv_trx_util_pub.TRACE('Exiting send_inventory_adjustment', 'INV_TRANSACTIONS_UTIL2', 9);
374: end if;
375:
376: IF (l_Return_Status <> rcv_error_pkg.g_ret_sts_success ) THEN
377: RAISE raise_event_error;

Line 385: inv_trx_util_pub.TRACE('invalid_entity_type exception has occured', 'INV_TRANSACTIONS_UTIL2', 9);

381:
382: WHEN invalid_entity_type THEN
383: X_Return_Status := rcv_error_pkg.g_ret_sts_error;
384: if (g_debug = 1) then
385: inv_trx_util_pub.TRACE('invalid_entity_type exception has occured', 'INV_TRANSACTIONS_UTIL2', 9);
386: end if;
387:
388: WHEN invalid_action_type THEN
389: X_Return_Status := rcv_error_pkg.g_ret_sts_error;

Line 391: inv_trx_util_pub.TRACE('invalid_action_type exception has occured', 'INV_TRANSACTIONS_UTIL2', 9);

387:
388: WHEN invalid_action_type THEN
389: X_Return_Status := rcv_error_pkg.g_ret_sts_error;
390: if (g_debug = 1) then
391: inv_trx_util_pub.TRACE('invalid_action_type exception has occured', 'INV_TRANSACTIONS_UTIL2', 9);
392: end if;
393:
394: WHEN invalid_doc_type THEN
395: X_Return_Status := rcv_error_pkg.g_ret_sts_error;

Line 397: inv_trx_util_pub.TRACE('invalid_doc_type exception has occured', 'INV_TRANSACTIONS_UTIL2', 9);

393:
394: WHEN invalid_doc_type THEN
395: X_Return_Status := rcv_error_pkg.g_ret_sts_error;
396: if (g_debug = 1) then
397: inv_trx_util_pub.TRACE('invalid_doc_type exception has occured', 'INV_TRANSACTIONS_UTIL2', 9);
398: end if;
399:
400: WHEN raise_event_error THEN
401: X_Return_Status := rcv_error_pkg.g_ret_sts_error;

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

399:
400: WHEN raise_event_error THEN
401: X_Return_Status := rcv_error_pkg.g_ret_sts_error;
402: if (g_debug = 1) then
403: inv_trx_util_pub.TRACE('raise_event_error exception has occured, error message is '|| SQLERRM, 'INV_TRANSACTIONS_UTIL2', 9);
404: end if;
405:
406: WHEN OTHERS THEN
407: X_Return_Status := rcv_error_pkg.g_ret_sts_error;

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

405:
406: WHEN OTHERS THEN
407: X_Return_Status := rcv_error_pkg.g_ret_sts_error;
408: if (g_debug = 1) then
409: inv_trx_util_pub.TRACE('Unexpected error has occured. Oracle error message is '|| SQLERRM, 'INV_TRANSACTIONS_UTIL2', 9);
410: end if;
411:
412: END send_inventory_adjustment;
413:

Line 431: inv_trx_util_pub.TRACE('Entering Send_Document', 'INV_TRANSACTIONS_UTIL2', 9);

427:
428: BEGIN
429:
430: if (g_debug = 1) then
431: inv_trx_util_pub.TRACE('Entering Send_Document', 'INV_TRANSACTIONS_UTIL2', 9);
432: end if;
433:
434: IF ( p_document_type = 'ADJ' ) THEN
435:

Line 446: inv_trx_util_pub.TRACE('Exiting Send_Document', 'INV_TRANSACTIONS_UTIL2', 9);

442: p_xml_document_id,
443: x_return_status);
444:
445: if (g_debug = 1) then
446: inv_trx_util_pub.TRACE('Exiting Send_Document', 'INV_TRANSACTIONS_UTIL2', 9);
447: inv_trx_util_pub.TRACE('Send_Document.x_return_status is '|| x_return_status, 'INV_TRANSACTIONS_UTIL2', 9);
448: end if;
449:
450: ELSE

Line 447: inv_trx_util_pub.TRACE('Send_Document.x_return_status is '|| x_return_status, 'INV_TRANSACTIONS_UTIL2', 9);

443: x_return_status);
444:
445: if (g_debug = 1) then
446: inv_trx_util_pub.TRACE('Exiting Send_Document', 'INV_TRANSACTIONS_UTIL2', 9);
447: inv_trx_util_pub.TRACE('Send_Document.x_return_status is '|| x_return_status, 'INV_TRANSACTIONS_UTIL2', 9);
448: end if;
449:
450: ELSE
451: raise invalid_doc_type;

Line 460: inv_trx_util_pub.TRACE('invalid_doc_type exception has occured.', 'INV_TRANSACTIONS_UTIL2', 9);

456: WHEN invalid_doc_type THEN
457: x_return_status := rcv_error_pkg.g_ret_sts_error;
458:
459: if (g_debug = 1) then
460: inv_trx_util_pub.TRACE('invalid_doc_type exception has occured.', 'INV_TRANSACTIONS_UTIL2', 9);
461: end if;
462:
463: WHEN OTHERS THEN
464: x_return_status := rcv_error_pkg.g_ret_sts_error;

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

463: WHEN OTHERS THEN
464: x_return_status := rcv_error_pkg.g_ret_sts_error;
465:
466: if (g_debug = 1) then
467: inv_trx_util_pub.TRACE('Unexpected error has occured. Oracle error message is '|| SQLERRM, 'INV_TRANSACTIONS_UTIL2', 9);
468: end if;
469:
470: END Send_Document;
471: