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.EAM_WO_COMP_UTILITY_PVT dependencies on EAM_PROCESS_WO_PVT

Line 36: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Work Order Completeion processing Perform Writes'); END IF;

32: l_Mesg_Token_tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
33: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
34: BEGIN
35:
36: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Work Order Completeion processing Perform Writes'); END IF;
37:
38:
39: IF p_eam_wo_comp_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_COMPLETE OR
40: p_eam_wo_comp_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_UNCOMPLETE

Line 39: IF p_eam_wo_comp_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_COMPLETE OR

35:
36: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Work Order Completeion processing Perform Writes'); END IF;
37:
38:
39: IF p_eam_wo_comp_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_COMPLETE OR
40: p_eam_wo_comp_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_UNCOMPLETE
41: THEN
42: Insert_Row
43: ( p_eam_wo_comp_rec => p_eam_wo_comp_rec

Line 40: p_eam_wo_comp_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_UNCOMPLETE

36: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Work Order Completeion processing Perform Writes'); END IF;
37:
38:
39: IF p_eam_wo_comp_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_COMPLETE OR
40: p_eam_wo_comp_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_UNCOMPLETE
41: THEN
42: Insert_Row
43: ( p_eam_wo_comp_rec => p_eam_wo_comp_rec
44: , x_mesg_token_Tbl => l_mesg_token_tbl

Line 52: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN

48:
49: x_return_status := l_return_status;
50: x_mesg_token_tbl := l_mesg_token_tbl;
51:
52: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
53: EAM_ERROR_MESSAGE_PVT.Write_Debug('Work Order Completeion completed Perform Writes');
54: END IF;
55:
56: END Perform_Writes;

Line 69: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Work Order Completeion processing insert row'); END IF;

65: l_Mesg_Token_tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
66: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
67: BEGIN
68:
69: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Work Order Completeion processing insert row'); END IF;
70:
71: begin
72: INSERT INTO EAM_JOB_COMPLETION_TXNS (
73: transaction_id,

Line 118: decode(p_eam_wo_comp_rec.transaction_type,EAM_PROCESS_WO_PVT.G_OPR_COMPLETE,1,EAM_PROCESS_WO_PVT.G_OPR_UNCOMPLETE,2),

114: )
115: VALUES (
116: p_eam_wo_comp_rec.transaction_id,
117: p_eam_wo_comp_rec.transaction_date,
118: decode(p_eam_wo_comp_rec.transaction_type,EAM_PROCESS_WO_PVT.G_OPR_COMPLETE,1,EAM_PROCESS_WO_PVT.G_OPR_UNCOMPLETE,2),
119: p_eam_wo_comp_rec.wip_entity_id,
120: p_eam_wo_comp_rec.organization_id,
121: p_eam_wo_comp_rec.parent_wip_entity_id,
122: p_eam_wo_comp_rec.reference,

Line 158: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN

154: p_eam_wo_comp_rec.attribute13,
155: p_eam_wo_comp_rec.attribute14,
156: p_eam_wo_comp_rec.attribute15
157: );
158: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
159: EAM_ERROR_MESSAGE_PVT.Write_Debug('Work Order Completeion completed insert row');
160: END IF;
161:
162: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 168: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN

164:
165: EXCEPTION
166: WHEN OTHERS THEN
167:
168: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
169: EAM_ERROR_MESSAGE_PVT.Write_Debug('Work Order Completeion : insert row : inside exception : ' || SQLERRM);
170: END IF;
171:
172: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

Line 194: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN

190:
191: i_asset_status_id NUMBER;
192: BEGIN
193:
194: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
195: EAM_ERROR_MESSAGE_PVT.Write_Debug('Work Order Completeion processing Shutdown info ');
196: END IF;
197:
198: -- get the asset_status_id from eam_asset_status_history_s sequence

Line 246: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN

242: s_user_id,
243: sysdate,
244: 'Y'); -- Enhancement Bug 3852846
245:
246: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
247: EAM_ERROR_MESSAGE_PVT.Write_Debug('Work Order Completeion completed Shutdown info processing');
248: END IF;
249:
250: END process_shutdown;

Line 289: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN

285: l_initial_msg_count NUMBER := 0;
286:
287: BEGIN
288:
289: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
290: EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_WO_COMP_UTILITY_PVT.process_lot_serial : Start ');
291: END IF;
292:
293: -- prepare the data to insert into MTL_MATERIAL_TRANSACTIONS_TEMP,

Line 322: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN

318: end;
319:
320: if (l_revision_control_code = 2) then
321:
322: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
323: EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_WO_COMP_UTILITY_PVT.process_lot_serial : before bom_revisions.get_revision ');
324: END IF;
325:
326: -- get bom_revision

Line 333: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN

329: item_id => s_rebuild_item_id,
330: rev_date => sysdate,
331: itm_rev => i_revision);
332:
333: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
334: EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_WO_COMP_UTILITY_PVT.process_lot_serial : after bom_revisions.get_revision ');
335: END IF;
336: end if;
337:

Line 376: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN

372: errMsg := fnd_message.get;
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:

Line 403: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN

399: x_trx_tmp_id => i_transaction_temp_id,
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:

Line 408: 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
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

Line 424: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN

420: -- Check whether the item is under lot or serial control or not
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

Line 445: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN

441: if (errCode <> 0) then
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

Line 467: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN

463: else
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

Line 483: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN

479: if (errCode <> 0) then
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

Line 495: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN

491: end LOOP;
492:
493: l_initial_msg_count := FND_MSG_PUB.count_msg;
494:
495: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
496: EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_WO_COMP_UTILITY_PVT.process_lot_serial : before inv_lpn_trx_pub.process_lpn_trx');
497: END IF;
498: -- Call Inventory API to process to item
499: -- the spec file is INVTRXWS.pls

Line 520: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN

516: 'EAM_RET_MAT_PROCESS_MESSAGE',p_token1=> 'ERRMESSAGE',
517: p_value1 => errMsg);
518: end if;
519: */
520: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
521: EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_WO_COMP_UTILITY_PVT.process_lot_serial : End');
522: END IF;
523: END process_lot_serial;
524:

Line 546: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN

542: l_lot_serial_rec Lot_Serial_Rec_Type;
543: l_lot_serial_tbl Lot_Serial_Tbl_Type;
544: BEGIN
545:
546: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
547: EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_WO_COMP_UTILITY_PVT.process_item : Start ');
548: END IF;
549:
550: IF s_inventory_item_tbl.COUNT = 0 THEN

Line 596: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN

592: l_lot_serial_tbl(l_lot_serial_tbl.COUNT+1) := l_lot_serial_rec;
593: END IF;
594: END LOOP;
595:
596: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
597: EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_WO_COMP_UTILITY_PVT.process_item : End ');
598: END IF;
599:
600: END process_item;

Line 647: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Work Order Completeion processing update_row'); END IF;

643: l_cmpl_sub VARCHAR2(10);
644: l_locator NUMBER;
645: l_lot VARCHAR2(80);
646: BEGIN
647: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Work Order Completeion processing update_row'); END IF;
648:
649: -- get some value from wip_discrete_jobs table
650: select parent_wip_entity_id,
651: asset_group_id,

Line 698: IF p_eam_wo_comp_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_COMPLETE THEN

694: x_inventory_item_rec.serial_number := i_rebuild_serial_number;
695: x_inventory_item_rec.quantity := 1;
696: x_inventory_item_tbl(1) := x_inventory_item_rec;
697:
698: IF p_eam_wo_comp_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_COMPLETE THEN
699: -- if (p_eam_wo_comp_rec.rebuild_job = 'Y') then -- Rebuild Work Order
700:
701: -- Check whether there is material issue or not
702:

Line 833: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN

829: );
830:
831: x_return_status := EAM_ERROR_MESSAGE_PVT.G_STATUS_UNEXPECTED;
832:
833: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
834: EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_WO_COMP_UTILITY_PVT.update_row : Exception1 : '|| errMsg);
835: END IF;
836: return;
837: end if;

Line 847: IF p_eam_wo_comp_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_COMPLETE THEN

843: from eam_wo_statuses_V
844: where status_id = p_eam_wo_comp_rec.user_status_id
845: and enabled_flag = 'Y';
846:
847: IF p_eam_wo_comp_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_COMPLETE THEN
848: i_work_request_status := 6; -- Work request complete
849: i_completion_date := p_eam_wo_comp_rec.actual_end_date;
850: ELSE
851: i_work_request_status := 4; -- Work request in process

Line 868: IF p_eam_wo_comp_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_COMPLETE THEN

864: FROM WIP_DISCRETE_JOBS
865: WHERE wip_entity_id = p_eam_wo_comp_rec.wip_entity_id;
866:
867:
868: IF p_eam_wo_comp_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_COMPLETE THEN
869: eam_meters_util.update_last_service_dates_wo(
870: p_wip_entity_id => p_eam_wo_comp_rec.wip_entity_id,
871: p_start_date => p_eam_wo_comp_rec.actual_start_date,
872: p_end_date => p_eam_wo_comp_rec.actual_end_date,

Line 884: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN

880: , p_message_text => l_msg_data
881: , x_mesg_token_Tbl => x_mesg_token_tbl
882: );
883: x_return_status := EAM_ERROR_MESSAGE_PVT.G_STATUS_UNEXPECTED;
884: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
885: EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_WO_COMP_UTILITY_PVT.update_row : Exception2 : '|| l_msg_data);
886: END IF;
887: return;
888: end if;

Line 950: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN

946: , x_mesg_token_Tbl => x_mesg_token_tbl
947: );
948:
949: x_return_status := EAM_ERROR_MESSAGE_PVT.G_STATUS_UNEXPECTED;
950: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
951: EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_WO_COMP_UTILITY_PVT.update_row : Exception3 : '|| SQLERRM);
952: END IF;
953:
954: END update_row;