[Home] [Help]
125: );
126:
127: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
128: /*** exception occurred in API -> return errmsg ***/
129: p_error_msg := CSL_SERVICEL_WRAPPER_PKG.GET_ERROR_MESSAGE_TEXT
130: (
131: p_api_error => TRUE
132: );
133: ELSE
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
199: (
200: p_api_error => TRUE
201: );
202:
233: x_return_status := FND_API.G_RET_STS_SUCCESS;
234:
235: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
236: /*** exception occurred in API -> return errmsg ***/
237: p_error_msg := CSL_SERVICEL_WRAPPER_PKG.GET_ERROR_MESSAGE_TEXT
238: (
239: p_api_error => TRUE
240: );
241: END IF;
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
262: (
263: p_api_error => TRUE
264: );
265:
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: (
336: p_message => 'CSL_DML_OPERATION'
337: , p_token_name1 => 'DML'
338: , p_token_value1 => p_record.dmltype$$
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: (
354: p_message => 'CSL_DML_OPERATION'
355: , p_token_name1 => 'DML'
356: , p_token_value1 => p_record.dmltype$$
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
381: (
382: p_api_error => TRUE
383: );
384:
393: x_return_status := FND_API.G_RET_STS_ERROR;
394: END APPLY_RECORD;
395:
396: /***
397: This procedure is called by CSL_SERVICEL_WRAPPER_PKG when publication item MTL_MAT_TRANSACTIONS
398: is dirty. This happens when a mobile field service device executed DML on an updatable table and did
399: a fast sync. This procedure will insert the data that came from mobile into the backend tables using
400: public APIs.
401: ***/
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: (
449: p_user_name,
450: p_tranid,
451: r_material_transaction.seqno$$,
468:
469: FOR r_lot_number IN c_lot_number( p_user_name,
470: p_tranid,
471: r_material_transaction.transaction_id ) LOOP
472: CSL_SERVICEL_WRAPPER_PKG.REJECT_RECORD
473: (
474: p_user_name,
475: r_lot_number.tranid$$,
476: r_lot_number.seqno$$,
484:
485: FOR r_unit_transaction IN c_unit_transaction( p_user_name,
486: p_tranid,
487: r_material_transaction.transaction_id ) LOOP
488: CSL_SERVICEL_WRAPPER_PKG.REJECT_RECORD
489: (
490: p_user_name,
491: r_unit_transaction.tranid$$,
492: r_unit_transaction.seqno$$,
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: (
515: p_user_name,
516: p_tranid,
517: r_material_transaction.seqno$$,
536: END IF;
537:
538: FOR r_lot_number IN c_lot_number( p_user_name, p_tranid, r_material_transaction.transaction_id ) LOOP
539: /* Delete matching contact record(s) */
540: CSL_SERVICEL_WRAPPER_PKG.DELETE_RECORD
541: (
542: p_user_name,
543: p_tranid,
544: r_lot_number.seqno$$,
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
563: , p_tranid
564: , r_lot_number.seqno$$
574: FOR r_unit_transaction IN c_unit_transaction( p_user_name,
575: p_tranid,
576: r_material_transaction.transaction_id ) LOOP
577: /* Delete matching contact record(s) */
578: CSL_SERVICEL_WRAPPER_PKG.DELETE_RECORD
579: (
580: p_user_name,
581: p_tranid,
582: r_unit_transaction.seqno$$,
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
601: , p_tranid
602: , r_unit_transaction.seqno$$
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: (
626: p_user_name
627: , p_tranid
628: , r_material_transaction.seqno$$
647: END IF;
648:
649: FOR r_lot_number IN c_lot_number( p_user_name, p_tranid, r_material_transaction.transaction_id ) LOOP
650: /* Defering matching contact record(s) */
651: CSL_SERVICEL_WRAPPER_PKG.DEFER_RECORD
652: (
653: p_user_name
654: , p_tranid
655: , r_lot_number.seqno$$
664: FOR r_unit_transaction IN c_unit_transaction( p_user_name,
665: p_tranid,
666: r_material_transaction.transaction_id ) LOOP
667: /* Defering matching contact record(s) */
668: CSL_SERVICEL_WRAPPER_PKG.DEFER_RECORD
669: (
670: p_user_name
671: , p_tranid
672: , r_unit_transaction.seqno$$