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.CSL_MATERIAL_TRANSACTION_PKG dependencies on JTM_HOOK_UTIL_PKG

Line 64: l_pub_item_name_mat CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=

60: FROM ASG_USER
61: WHERE USER_NAME = b_client_name;
62: r_resource c_resource%ROWTYPE;
63:
64: l_pub_item_name_mat CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
65: JTM_HOOK_UTIL_PKG.t_publication_item_list('MTL_MAT_TRANSACTIONS');
66: BEGIN
67: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
68: jtm_message_log_pkg.Log_Msg

Line 65: JTM_HOOK_UTIL_PKG.t_publication_item_list('MTL_MAT_TRANSACTIONS');

61: WHERE USER_NAME = b_client_name;
62: r_resource c_resource%ROWTYPE;
63:
64: l_pub_item_name_mat CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
65: JTM_HOOK_UTIL_PKG.t_publication_item_list('MTL_MAT_TRANSACTIONS');
66: BEGIN
67: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
68: jtm_message_log_pkg.Log_Msg
69: ( v_object_id => p_record.TRANSACTION_ID

Line 67: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

63:
64: l_pub_item_name_mat CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
65: JTM_HOOK_UTIL_PKG.t_publication_item_list('MTL_MAT_TRANSACTIONS');
66: BEGIN
67: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
68: jtm_message_log_pkg.Log_Msg
69: ( v_object_id => p_record.TRANSACTION_ID
70: , v_object_name => g_object_name
71: , v_message => 'Entering ' || g_object_name || '.APPLY_INSERT'

Line 72: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

68: jtm_message_log_pkg.Log_Msg
69: ( v_object_id => p_record.TRANSACTION_ID
70: , v_object_name => g_object_name
71: , v_message => 'Entering ' || g_object_name || '.APPLY_INSERT'
72: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
73: END IF;
74:
75: -- Initialization
76: l_transaction_id := p_record.transaction_id;

Line 138: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

134: /*** Record was succesfull applied now push records with new PK to client ***/
135: /*** Use the transaction_set_id (px_transaction_header_id) because the
136: transaction_id is not returned by the INV API ***/
137: FOR r_transaction IN c_transactions( l_mat_txn_transfer_id ) LOOP
138: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
139: jtm_message_log_pkg.Log_Msg
140: ( v_object_id => p_record.TRANSACTION_ID -- put PK column here
141: , v_object_name => g_object_name
142: , v_message => 'Found new transaction_id ' || r_transaction.transaction_id||

Line 144: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

140: ( v_object_id => p_record.TRANSACTION_ID -- put PK column here
141: , v_object_name => g_object_name
142: , v_message => 'Found new transaction_id ' || r_transaction.transaction_id||
143: ', Pushing these to the client'
144: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
145: END IF;
146:
147: /*** Get the resource ***/
148: OPEN c_resource( p_record.CLID$$CS );

Line 153: JTM_HOOK_UTIL_PKG.Insert_Acc

149: FETCH c_resource INTO r_resource;
150: IF c_resource%FOUND THEN
151:
152: /*** Pushing record ***/
153: JTM_HOOK_UTIL_PKG.Insert_Acc
154: ( p_publication_item_names => l_pub_item_name_mat
155: ,p_acc_table_name => 'JTM_MTL_MAT_TRANS_ACC'
156: ,p_resource_id => r_resource.resource_id
157: ,p_pk1_name => 'TRANSACTION_ID'

Line 180: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

176:
177: END LOOP;
178: END IF;
179:
180: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
181: jtm_message_log_pkg.Log_Msg
182: ( v_object_id => p_record.TRANSACTION_ID -- put PK column here
183: , v_object_name => g_object_name
184: , v_message => 'Leaving ' || g_object_name || '.APPLY_INSERT'

Line 185: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

181: jtm_message_log_pkg.Log_Msg
182: ( v_object_id => p_record.TRANSACTION_ID -- put PK column here
183: , v_object_name => g_object_name
184: , v_message => 'Leaving ' || g_object_name || '.APPLY_INSERT'
185: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
186: END IF;
187:
188: EXCEPTION WHEN OTHERS THEN
189: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

Line 189: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

185: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
186: END IF;
187:
188: EXCEPTION WHEN OTHERS THEN
189: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
190: jtm_message_log_pkg.Log_Msg
191: ( v_object_id => p_record.TRANSACTION_ID -- put PK column here
192: , v_object_name => g_object_name
193: , v_message => 'Exception occurred in APPLY_INSERT:' || fnd_global.local_chr(10) || sqlerrm

Line 194: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

190: jtm_message_log_pkg.Log_Msg
191: ( v_object_id => p_record.TRANSACTION_ID -- put PK column here
192: , v_object_name => g_object_name
193: , v_message => 'Exception occurred in APPLY_INSERT:' || fnd_global.local_chr(10) || sqlerrm
194: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
195: END IF;
196:
197: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_INSERT', sqlerrm);
198: p_error_msg := CSL_SERVICEL_WRAPPER_PKG.GET_ERROR_MESSAGE_TEXT

Line 203: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

199: (
200: p_api_error => TRUE
201: );
202:
203: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
204: jtm_message_log_pkg.Log_Msg
205: ( v_object_id => p_record.TRANSACTION_ID -- put PK column here
206: , v_object_name => g_object_name
207: , v_message => 'Leaving ' || g_object_name || '.APPLY_INSERT'

Line 208: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

204: jtm_message_log_pkg.Log_Msg
205: ( v_object_id => p_record.TRANSACTION_ID -- put PK column here
206: , v_object_name => g_object_name
207: , v_message => 'Leaving ' || g_object_name || '.APPLY_INSERT'
208: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
209: END IF;
210:
211: x_return_status := FND_API.G_RET_STS_ERROR;
212: END APPLY_INSERT;

Line 224: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

220: p_error_msg OUT NOCOPY VARCHAR2,
221: x_return_status IN OUT NOCOPY VARCHAR2
222: ) IS
223: BEGIN
224: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
225: jtm_message_log_pkg.Log_Msg
226: ( v_object_id => p_record.TRANSACTION_ID -- put PK column here
227: , v_object_name => g_object_name
228: , v_message => 'Entering ' || g_object_name || '.APPLY_UPDATE'

Line 229: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

225: jtm_message_log_pkg.Log_Msg
226: ( v_object_id => p_record.TRANSACTION_ID -- put PK column here
227: , v_object_name => g_object_name
228: , v_message => 'Entering ' || g_object_name || '.APPLY_UPDATE'
229: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
230: END IF;
231:
232: -- There is no update possible so returning SUCCESS
233: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 243: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

239: p_api_error => TRUE
240: );
241: END IF;
242:
243: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
244: jtm_message_log_pkg.Log_Msg
245: ( v_object_id => p_record.TRANSACTION_ID -- put PK column here
246: , v_object_name => g_object_name
247: , v_message => 'Leaving ' || g_object_name || '.APPLY_UPDATE'

Line 248: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

244: jtm_message_log_pkg.Log_Msg
245: ( v_object_id => p_record.TRANSACTION_ID -- put PK column here
246: , v_object_name => g_object_name
247: , v_message => 'Leaving ' || g_object_name || '.APPLY_UPDATE'
248: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
249: END IF;
250:
251: EXCEPTION WHEN OTHERS THEN
252: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

Line 252: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

248: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
249: END IF;
250:
251: EXCEPTION WHEN OTHERS THEN
252: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
253: jtm_message_log_pkg.Log_Msg
254: ( v_object_id => p_record.TRANSACTION_ID -- put PK column here
255: , v_object_name => g_object_name
256: , v_message => 'Exception occurred in APPLY_UPDATE:' || fnd_global.local_chr(10) || sqlerrm

Line 257: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

253: jtm_message_log_pkg.Log_Msg
254: ( v_object_id => p_record.TRANSACTION_ID -- put PK column here
255: , v_object_name => g_object_name
256: , v_message => 'Exception occurred in APPLY_UPDATE:' || fnd_global.local_chr(10) || sqlerrm
257: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
258: END IF;
259:
260: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_UPDATE', sqlerrm);
261: p_error_msg := CSL_SERVICEL_WRAPPER_PKG.GET_ERROR_MESSAGE_TEXT

Line 266: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

262: (
263: p_api_error => TRUE
264: );
265:
266: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
267: jtm_message_log_pkg.Log_Msg
268: ( v_object_id => p_record.TRANSACTION_ID -- put PK column here
269: , v_object_name => g_object_name
270: , v_message => 'Leaving ' || g_object_name || '.APPLY_UPDATE'

Line 271: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

267: jtm_message_log_pkg.Log_Msg
268: ( v_object_id => p_record.TRANSACTION_ID -- put PK column here
269: , v_object_name => g_object_name
270: , v_message => 'Leaving ' || g_object_name || '.APPLY_UPDATE'
271: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
272: END IF;
273:
274: x_return_status := FND_API.G_RET_STS_ERROR;
275: END APPLY_UPDATE;

Line 291: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

287: /*** initialize return status and message list ***/
288: x_return_status := FND_API.G_RET_STS_SUCCESS;
289: FND_MSG_PUB.INITIALIZE;
290:
291: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
292: jtm_message_log_pkg.Log_Msg
293: ( v_object_id => p_record.TRANSACTION_ID -- put PK column here
294: , v_object_name => g_object_name
295: , v_message => 'Entering ' || g_object_name || '.APPLY_RECORD'

Line 296: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

292: jtm_message_log_pkg.Log_Msg
293: ( v_object_id => p_record.TRANSACTION_ID -- put PK column here
294: , v_object_name => g_object_name
295: , v_message => 'Entering ' || g_object_name || '.APPLY_RECORD'
296: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
297: END IF;
298:
299: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
300: jtm_message_log_pkg.Log_Msg

Line 299: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

295: , v_message => 'Entering ' || g_object_name || '.APPLY_RECORD'
296: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
297: END IF;
298:
299: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
300: jtm_message_log_pkg.Log_Msg
301: ( v_object_id => p_record.TRANSACTION_ID -- put PK column here
302: , v_object_name => g_object_name
303: , v_message => 'Processing TRANSACTION_ID = ' || p_record.TRANSACTION_ID || fnd_global.local_chr(10) ||

Line 305: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

301: ( v_object_id => p_record.TRANSACTION_ID -- put PK column here
302: , v_object_name => g_object_name
303: , v_message => 'Processing TRANSACTION_ID = ' || p_record.TRANSACTION_ID || fnd_global.local_chr(10) ||
304: 'DMLTYPE = ' || p_record.dmltype$$
305: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
306: END IF;
307:
308: IF p_record.dmltype$$='I' THEN
309: -- Process insert

Line 326: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

322: x_return_status
323: );
324: ELSIF p_record.dmltype$$='D' THEN
325: -- Process delete; not supported for this entity
326: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
327: jtm_message_log_pkg.Log_Msg
328: ( v_object_id => p_record.TRANSACTION_ID -- put PK column here
329: , v_object_name => g_object_name
330: , v_message => 'Delete is not supported for this entity'

Line 331: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

327: jtm_message_log_pkg.Log_Msg
328: ( v_object_id => p_record.TRANSACTION_ID -- put PK column here
329: , v_object_name => g_object_name
330: , v_message => 'Delete is not supported for this entity'
331: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
332: END IF;
333:
334: p_error_msg := CSL_SERVICEL_WRAPPER_PKG.GET_ERROR_MESSAGE_TEXT
335: (

Line 344: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

340:
341: x_return_status := FND_API.G_RET_STS_ERROR;
342: ELSE
343: -- invalid dml type
344: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
345: jtm_message_log_pkg.Log_Msg
346: ( v_object_id => p_record.TRANSACTION_ID -- put PK column here
347: , v_object_name => g_object_name
348: , v_message => 'Invalid DML type: ' || p_record.dmltype$$

Line 349: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

345: jtm_message_log_pkg.Log_Msg
346: ( v_object_id => p_record.TRANSACTION_ID -- put PK column here
347: , v_object_name => g_object_name
348: , v_message => 'Invalid DML type: ' || p_record.dmltype$$
349: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
350: END IF;
351:
352: p_error_msg := CSL_SERVICEL_WRAPPER_PKG.GET_ERROR_MESSAGE_TEXT
353: (

Line 362: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

358:
359: x_return_status := FND_API.G_RET_STS_ERROR;
360: END IF;
361:
362: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
363: jtm_message_log_pkg.Log_Msg
364: ( v_object_id => p_record.TRANSACTION_ID -- put PK column here
365: , v_object_name => g_object_name
366: , v_message => 'Leaving ' || g_object_name || '.APPLY_RECORD'

Line 367: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

363: jtm_message_log_pkg.Log_Msg
364: ( v_object_id => p_record.TRANSACTION_ID -- put PK column here
365: , v_object_name => g_object_name
366: , v_message => 'Leaving ' || g_object_name || '.APPLY_RECORD'
367: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
368: END IF;
369: EXCEPTION WHEN OTHERS THEN
370: /*** defer record when any process exception occurs ***/
371: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

Line 371: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

367: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
368: END IF;
369: EXCEPTION WHEN OTHERS THEN
370: /*** defer record when any process exception occurs ***/
371: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
372: jtm_message_log_pkg.Log_Msg
373: ( v_object_id => p_record.TRANSACTION_ID -- put PK column here
374: , v_object_name => g_object_name
375: , v_message => 'Exception occurred in APPLY_RECORD:' || fnd_global.local_chr(10) || sqlerrm

Line 376: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

372: jtm_message_log_pkg.Log_Msg
373: ( v_object_id => p_record.TRANSACTION_ID -- put PK column here
374: , v_object_name => g_object_name
375: , v_message => 'Exception occurred in APPLY_RECORD:' || fnd_global.local_chr(10) || sqlerrm
376: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
377: END IF;
378:
379: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_RECORD', sqlerrm);
380: p_error_msg := CSL_SERVICEL_WRAPPER_PKG.GET_ERROR_MESSAGE_TEXT

Line 385: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

381: (
382: p_api_error => TRUE
383: );
384:
385: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
386: jtm_message_log_pkg.Log_Msg
387: ( v_object_id => p_record.TRANSACTION_ID -- put PK column here
388: , v_object_name => g_object_name
389: , v_message => 'Leaving ' || g_object_name || '.APPLY_RECORD'

Line 390: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

386: jtm_message_log_pkg.Log_Msg
387: ( v_object_id => p_record.TRANSACTION_ID -- put PK column here
388: , v_object_name => g_object_name
389: , v_message => 'Leaving ' || g_object_name || '.APPLY_RECORD'
390: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
391: END IF;
392:
393: x_return_status := FND_API.G_RET_STS_ERROR;
394: END APPLY_RECORD;

Line 416: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

412: BEGIN
413: g_debug_level := p_debug_level;
414: x_return_status := FND_API.G_RET_STS_SUCCESS;
415:
416: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
417: jtm_message_log_pkg.Log_Msg
418: ( v_object_id => null
419: , v_object_name => g_object_name
420: , v_message => 'Entering ' || g_object_name || '.Apply_Client_Changes'

Line 421: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

417: jtm_message_log_pkg.Log_Msg
418: ( v_object_id => null
419: , v_object_name => g_object_name
420: , v_message => 'Entering ' || g_object_name || '.Apply_Client_Changes'
421: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
422: END IF;
423:
424: /*** loop through MTL_MAT_TRANSACTIONS records in inqueue ***/
425: FOR r_material_transaction IN c_material_transaction( p_user_name, p_tranid) LOOP

Line 439: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

435: );
436:
437: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN
438: /*** Yes -> reject record because of changed pk ***/
439: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
440: jtm_message_log_pkg.Log_Msg
441: ( v_object_id => r_material_transaction.transaction_id
442: , v_object_name => g_object_name
443: , v_message => 'Record successfully processed, rejecting record because pk is changed'

Line 444: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

440: jtm_message_log_pkg.Log_Msg
441: ( v_object_id => r_material_transaction.transaction_id
442: , v_object_name => g_object_name
443: , v_message => 'Record successfully processed, rejecting record because pk is changed'
444: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
445: END IF;
446:
447: CSL_SERVICEL_WRAPPER_PKG.REJECT_RECORD
448: (

Line 461: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

457: );
458:
459: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN
460: /*** Reject successfull now rejecting matching serial/lotnumber records ***/
461: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
462: jtm_message_log_pkg.Log_Msg
463: ( v_object_id => r_material_transaction.transaction_id
464: , v_object_name => g_object_name
465: , v_message => 'Record rejected, now rejecting available matching lot-/serialnumber records'

Line 466: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

462: jtm_message_log_pkg.Log_Msg
463: ( v_object_id => r_material_transaction.transaction_id
464: , v_object_name => g_object_name
465: , v_message => 'Record rejected, now rejecting available matching lot-/serialnumber records'
466: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
467: END IF;
468:
469: FOR r_lot_number IN c_lot_number( p_user_name,
470: p_tranid,

Line 505: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

501:
502: /*** was record processed successfully? ***/
503: /*IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN*/
504: /*** Yes -> delete record from inqueue ***/
505: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
506: jtm_message_log_pkg.Log_Msg
507: ( v_object_id => r_material_transaction.TRANSACTION_ID
508: , v_object_name => g_object_name
509: , v_message => 'Record successfully processed, deleting from inqueue'

Line 510: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

506: jtm_message_log_pkg.Log_Msg
507: ( v_object_id => r_material_transaction.TRANSACTION_ID
508: , v_object_name => g_object_name
509: , v_message => 'Record successfully processed, deleting from inqueue'
510: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
511: END IF;
512:
513: CSL_SERVICEL_WRAPPER_PKG.DELETE_RECORD
514: (

Line 528: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

524:
525: /*** was delete successful? ***/
526: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
527: /*** no -> rollback ***/
528: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
529: jtm_message_log_pkg.Log_Msg
530: ( v_object_id => r_material_transaction.TRANSACTION_ID
531: , v_object_name => g_object_name
532: , v_message => 'Deleting from inqueue failed, rolling back to savepoint'

Line 533: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

529: jtm_message_log_pkg.Log_Msg
530: ( v_object_id => r_material_transaction.TRANSACTION_ID
531: , v_object_name => g_object_name
532: , v_message => 'Deleting from inqueue failed, rolling back to savepoint'
533: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
534: END IF;
535: ROLLBACK TO save_rec;
536: END IF;
537:

Line 553: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

549: l_process_status
550: );
551: /*** was delete successful? ***/
552: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
553: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
554: jtm_message_log_pkg.Log_Msg
555: ( v_object_id => r_lot_number.tranid$$
556: , v_object_name => g_object_name || 'MTL_TRANS_LOT_NUMBERS'
557: , v_message => 'Deleting from inqueue failed, Defer and reject record'

Line 558: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

554: jtm_message_log_pkg.Log_Msg
555: ( v_object_id => r_lot_number.tranid$$
556: , v_object_name => g_object_name || 'MTL_TRANS_LOT_NUMBERS'
557: , v_message => 'Deleting from inqueue failed, Defer and reject record'
558: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
559: END IF;
560: CSL_SERVICEL_WRAPPER_PKG.DEFER_RECORD
561: (
562: p_user_name

Line 591: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

587: l_process_status
588: );
589: /*** was delete successful? ***/
590: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
591: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
592: jtm_message_log_pkg.Log_Msg
593: ( v_object_id => r_unit_transaction.tranid$$
594: , v_object_name => g_object_name || 'MTL_UNIT_TRANSACTIONS'
595: , v_message => 'Deleting from inqueue failed, Defer and reject record'

Line 596: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

592: jtm_message_log_pkg.Log_Msg
593: ( v_object_id => r_unit_transaction.tranid$$
594: , v_object_name => g_object_name || 'MTL_UNIT_TRANSACTIONS'
595: , v_message => 'Deleting from inqueue failed, Defer and reject record'
596: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
597: END IF;
598: CSL_SERVICEL_WRAPPER_PKG.DEFER_RECORD
599: (
600: p_user_name

Line 616: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

612: END IF;
613:
614: IF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN
615: /*** Record was not processed successfully or delete failed -> defer and reject record ***/
616: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
617: jtm_message_log_pkg.Log_Msg
618: ( v_object_id => r_material_transaction.TRANSACTION_ID
619: , v_object_name => g_object_name
620: , v_message => 'Record not processed successfully, deferring and rejecting record'

Line 621: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

617: jtm_message_log_pkg.Log_Msg
618: ( v_object_id => r_material_transaction.TRANSACTION_ID
619: , v_object_name => g_object_name
620: , v_message => 'Record not processed successfully, deferring and rejecting record'
621: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
622: END IF;
623:
624: CSL_SERVICEL_WRAPPER_PKG.DEFER_RECORD
625: (

Line 639: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

635:
636: /*** Was defer successful? ***/
637: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
638: /*** no -> rollback ***/
639: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
640: jtm_message_log_pkg.Log_Msg
641: ( v_object_id => r_material_transaction.TRANSACTION_ID
642: , v_object_name => g_object_name
643: , v_message => 'Defer record failed, rolling back to savepoint'

Line 644: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

640: jtm_message_log_pkg.Log_Msg
641: ( v_object_id => r_material_transaction.TRANSACTION_ID
642: , v_object_name => g_object_name
643: , v_message => 'Defer record failed, rolling back to savepoint'
644: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
645: END IF;
646: ROLLBACK TO save_rec;
647: END IF;
648:

Line 683: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

679: END LOOP;
680: END IF;
681: END LOOP;
682:
683: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
684: jtm_message_log_pkg.Log_Msg
685: ( v_object_id => null
686: , v_object_name => g_object_name
687: , v_message => 'Leaving ' || g_object_name || '.Apply_Client_Changes'

Line 688: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

684: jtm_message_log_pkg.Log_Msg
685: ( v_object_id => null
686: , v_object_name => g_object_name
687: , v_message => 'Leaving ' || g_object_name || '.Apply_Client_Changes'
688: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
689: END IF;
690:
691: EXCEPTION WHEN OTHERS THEN
692: /*** catch and log exceptions ***/

Line 693: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

689: END IF;
690:
691: EXCEPTION WHEN OTHERS THEN
692: /*** catch and log exceptions ***/
693: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
694: jtm_message_log_pkg.Log_Msg
695: ( v_object_id => null
696: , v_object_name => g_object_name
697: , v_message => 'Exception occurred in APPLY_CLIENT_CHANGES:' || fnd_global.local_chr(10) || sqlerrm

Line 698: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

694: jtm_message_log_pkg.Log_Msg
695: ( v_object_id => null
696: , v_object_name => g_object_name
697: , v_message => 'Exception occurred in APPLY_CLIENT_CHANGES:' || fnd_global.local_chr(10) || sqlerrm
698: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
699: END IF;
700: x_return_status := FND_API.G_RET_STS_ERROR;
701: END APPLY_CLIENT_CHANGES;
702: