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_OP_COMP_UTILITY_PVT dependencies on EAM_PROCESS_WO_PVT

Line 34: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Entered Package EAM_OP_COMP_UTILITY_PVT.Perform_Writes procedure..'); END IF;

30: IS
31: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
32: BEGIN
33:
34: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Entered Package EAM_OP_COMP_UTILITY_PVT.Perform_Writes procedure..'); END IF;
35:
36: IF p_eam_op_comp_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_COMPLETE OR
37: p_eam_op_comp_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_UNCOMPLETE
38: THEN

Line 36: IF p_eam_op_comp_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_COMPLETE OR

32: BEGIN
33:
34: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Entered Package EAM_OP_COMP_UTILITY_PVT.Perform_Writes procedure..'); END IF;
35:
36: IF p_eam_op_comp_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_COMPLETE OR
37: p_eam_op_comp_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_UNCOMPLETE
38: THEN
39: Insert_Row
40: ( p_eam_op_comp_rec => p_eam_op_comp_rec

Line 37: p_eam_op_comp_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_UNCOMPLETE

33:
34: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Entered Package EAM_OP_COMP_UTILITY_PVT.Perform_Writes procedure..'); END IF;
35:
36: IF p_eam_op_comp_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_COMPLETE OR
37: p_eam_op_comp_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_UNCOMPLETE
38: THEN
39: Insert_Row
40: ( p_eam_op_comp_rec => p_eam_op_comp_rec
41: , x_mesg_token_Tbl => x_mesg_token_tbl

Line 47: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Exiting Package EAM_OP_COMP_UTILITY_PVT.Perform_Writes procedure ...'); END IF;

43: );
44: END IF;
45:
46: x_return_status := l_return_status;
47: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Exiting Package EAM_OP_COMP_UTILITY_PVT.Perform_Writes procedure ...'); END IF;
48:
49: END Perform_Writes;
50:
51: PROCEDURE insert_row

Line 68: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Entered Package EAM_OP_COMP_UTILITY_PVT.insert_row procedure..'); END IF;

64: l_asset_number VARCHAR2(30);
65:
66: BEGIN
67:
68: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Entered Package EAM_OP_COMP_UTILITY_PVT.insert_row procedure..'); END IF;
69:
70: INSERT INTO EAM_OP_COMPLETION_TXNS( /* Insert statement from EAMOCMPB.pls */
71: transaction_id,
72: transaction_date,

Line 115: decode(p_eam_op_comp_rec.transaction_type,EAM_PROCESS_WO_PVT.G_OPR_COMPLETE,1,EAM_PROCESS_WO_PVT.G_OPR_UNCOMPLETE,2),

111:
112: ) VALUES (
113: p_eam_op_comp_rec.transaction_id,
114: p_eam_op_comp_rec.transaction_date,
115: decode(p_eam_op_comp_rec.transaction_type,EAM_PROCESS_WO_PVT.G_OPR_COMPLETE,1,EAM_PROCESS_WO_PVT.G_OPR_UNCOMPLETE,2),
116: p_eam_op_comp_rec.wip_entity_id,
117: p_eam_op_comp_rec.organization_id,
118: p_eam_op_comp_rec.operation_seq_num,
119: NULL, -- acct_period_id

Line 254: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Calling EAM_OP_COMP_UTILITY_PVT.update_row from EAM_OP_COMP_UTILITY_PVT.insert_row procedure'); END IF;

250: ,'Y' -- Enhancemnet Bug 3852846
251: );
252:
253: END IF; -- history insert
254: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Calling EAM_OP_COMP_UTILITY_PVT.update_row from EAM_OP_COMP_UTILITY_PVT.insert_row procedure'); END IF;
255:
256: update_row
257: ( p_eam_op_comp_rec => p_eam_op_comp_rec
258: , x_mesg_token_Tbl => l_mesg_token_tbl

Line 261: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Returned from EAM_OP_COMP_UTILITY_PVT.update_row to EAM_OP_COMP_UTILITY_PVT.insert_row procedure'); END IF;

257: ( p_eam_op_comp_rec => p_eam_op_comp_rec
258: , x_mesg_token_Tbl => l_mesg_token_tbl
259: , x_return_Status => l_return_status
260: );
261: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Returned from EAM_OP_COMP_UTILITY_PVT.update_row to EAM_OP_COMP_UTILITY_PVT.insert_row procedure'); END IF;
262:
263: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Exiting Package EAM_OP_COMP_UTILITY_PVT.insert_row procedure with status:'||l_return_status); END IF;
264:
265: EXCEPTION

Line 263: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Exiting Package EAM_OP_COMP_UTILITY_PVT.insert_row procedure with status:'||l_return_status); END IF;

259: , x_return_Status => l_return_status
260: );
261: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Returned from EAM_OP_COMP_UTILITY_PVT.update_row to EAM_OP_COMP_UTILITY_PVT.insert_row procedure'); END IF;
262:
263: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Exiting Package EAM_OP_COMP_UTILITY_PVT.insert_row procedure with status:'||l_return_status); END IF;
264:
265: EXCEPTION
266: WHEN OTHERS THEN
267: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Exception happened Package EAM_OP_COMP_UTILITY_PVT.insert_row procedure..' || SQLERRM); END IF;

Line 267: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Exception happened Package EAM_OP_COMP_UTILITY_PVT.insert_row procedure..' || SQLERRM); END IF;

263: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Exiting Package EAM_OP_COMP_UTILITY_PVT.insert_row procedure with status:'||l_return_status); END IF;
264:
265: EXCEPTION
266: WHEN OTHERS THEN
267: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Exception happened Package EAM_OP_COMP_UTILITY_PVT.insert_row procedure..' || SQLERRM); END IF;
268: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
269: ( p_message_name => NULL
270: , p_message_text => G_PKG_NAME ||' :Inserting Record ' || SQLERRM
271: , x_mesg_token_Tbl => l_Mesg_Token_tbl

Line 288: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Entered Package EAM_OP_COMP_UTILITY_PVT.update_row procedure..'); END IF;

284: IS
285: l_shutdown_type VARCHAR2(30) :=NULL;
286: BEGIN
287:
288: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Entered Package EAM_OP_COMP_UTILITY_PVT.update_row procedure..'); END IF;
289:
290: SELECT wo.shutdown_type INTO l_shutdown_type
291: FROM wip_operations wo
292: WHERE wo.wip_entity_id = p_eam_op_comp_rec.wip_entity_id

Line 310: operation_completed = decode(p_eam_op_comp_rec.transaction_type,EAM_PROCESS_WO_PVT.G_OPR_COMPLETE,'Y',EAM_PROCESS_WO_PVT.G_OPR_UNCOMPLETE,'N'),

306: END IF;
307:
308: UPDATE wip_operations
309: SET
310: operation_completed = decode(p_eam_op_comp_rec.transaction_type,EAM_PROCESS_WO_PVT.G_OPR_COMPLETE,'Y',EAM_PROCESS_WO_PVT.G_OPR_UNCOMPLETE,'N'),
311: quantity_completed = 1,
312: last_updated_by = FND_GLOBAL.user_id,
313: last_update_date = sysdate,
314: last_update_login = FND_GLOBAL.login_id

Line 318: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Exiting Package EAM_OP_COMP_UTILITY_PVT.update_row procedure'); END IF;

314: last_update_login = FND_GLOBAL.login_id
315: WHERE
316: wip_entity_id = p_eam_op_comp_rec.wip_entity_id
317: AND operation_seq_num = p_eam_op_comp_rec.operation_seq_num;
318: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Exiting Package EAM_OP_COMP_UTILITY_PVT.update_row procedure'); END IF;
319:
320: END update_row;
321:
322: