APPS.EAM_WO_COMP_UTILITY_PVT dependencies on INV_TRX_UTIL_PUB

Line 377: EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_WO_COMP_UTILITY_PVT.process_lot_serial : before inv_trx_util_pub.insert_line_trx');

373: return;
374: end if; -- end prepare data
375:
376: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
377: EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_WO_COMP_UTILITY_PVT.process_lot_serial : before inv_trx_util_pub.insert_line_trx');
378: END IF;
379:
380:
381: -- call inventory API to insert data to mtl_material_transactions_temp

Line 383: errCode := inv_trx_util_pub.insert_line_trx(

379:
380:
381: -- call inventory API to insert data to mtl_material_transactions_temp
382: -- the spec file is INVTRXUS.pls
383: errCode := inv_trx_util_pub.insert_line_trx(
384: p_trx_hdr_id => i_transaction_header_id,
385: p_item_id => s_rebuild_item_id,
386: p_revision => i_revision,
387: p_org_id => s_org_id,

Line 404: EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_WO_COMP_UTILITY_PVT.process_lot_serial : inv_trx_util_pub.insert_line_trx : ' || errMsg);

400: x_proc_msg => errMsg);
401: if (errCode <> 0) then
402: return;
403: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
404: EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_WO_COMP_UTILITY_PVT.process_lot_serial : inv_trx_util_pub.insert_line_trx : ' || errMsg);
405: END IF;
406: end if;
407:
408: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN

Line 409: EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_WO_COMP_UTILITY_PVT.process_lot_serial : after inv_trx_util_pub.insert_line_trx');

405: END IF;
406: end if;
407:
408: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
409: EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_WO_COMP_UTILITY_PVT.process_lot_serial : after inv_trx_util_pub.insert_line_trx');
410: END IF;
411:
412: FOR i IN 1..s_lot_serial_tbl.COUNT LOOP
413:

Line 425: EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_WO_COMP_UTILITY_PVT.process_lot_serial : before inv_trx_util_pub.insert_lot_trx');

421: -- If it is, insert the data to coresponding tables
422: if(item.lotControlCode = WIP_CONSTANTS.LOT) then
423:
424: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
425: EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_WO_COMP_UTILITY_PVT.process_lot_serial : before inv_trx_util_pub.insert_lot_trx');
426: END IF;
427:
428: -- the item is under lot control
429:

Line 432: errCode := inv_trx_util_pub.insert_lot_trx(

428: -- the item is under lot control
429:
430: -- call inventory API to insert data to mtl_transaction_lots_temp
431: -- the spec file is INVTRXUS.pls
432: errCode := inv_trx_util_pub.insert_lot_trx(
433: p_trx_tmp_id => i_transaction_temp_id,
434: p_user_id => s_user_id,
435: p_lot_number => s_lot_serial_tbl(i).lot_number,
436: p_trx_qty => l_transaction_quantity,

Line 446: EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_WO_COMP_UTILITY_PVT.process_lot_serial : after inv_trx_util_pub.insert_lot_trx');

442: return;
443: end if;
444:
445: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
446: EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_WO_COMP_UTILITY_PVT.process_lot_serial : after inv_trx_util_pub.insert_lot_trx');
447: END IF;
448:
449: else
450: null;

Line 468: EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_WO_COMP_UTILITY_PVT.process_lot_serial : before inv_trx_util_pub.insert_ser_trx');

464: i_transaction_temp_id_s := i_transaction_temp_id;
465: end if; -- end lot control check
466:
467: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
468: EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_WO_COMP_UTILITY_PVT.process_lot_serial : before inv_trx_util_pub.insert_ser_trx');
469: END IF;
470:
471: -- call inventory API to insert data to mtl_serial_numbers_temp
472: -- the spec file is INVTRXUS.pls

Line 473: errCode := inv_trx_util_pub.insert_ser_trx(

469: END IF;
470:
471: -- call inventory API to insert data to mtl_serial_numbers_temp
472: -- the spec file is INVTRXUS.pls
473: errCode := inv_trx_util_pub.insert_ser_trx(
474: p_trx_tmp_id => i_transaction_temp_id_s,
475: p_user_id => s_user_id,
476: p_fm_ser_num => s_lot_serial_tbl(i).serial_number,
477: p_to_ser_num => s_lot_serial_tbl(i).serial_number,

Line 484: EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_WO_COMP_UTILITY_PVT.process_lot_serial : after inv_trx_util_pub.insert_ser_trx');

480: return;
481: end if;
482:
483: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
484: EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_WO_COMP_UTILITY_PVT.process_lot_serial : after inv_trx_util_pub.insert_ser_trx');
485: END IF;
486:
487: else
488: null;