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_ERROR_MESSAGE_PVT

Line 28: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type

24: PROCEDURE Perform_Writes
25: (
26: p_eam_op_comp_rec IN EAM_PROCESS_WO_PUB.eam_op_comp_rec_type
27: , x_return_status OUT NOCOPY VARCHAR2
28: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
29: )
30: IS
31: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
32: BEGIN

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 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 55: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type

51: PROCEDURE insert_row
52: (
53: p_eam_op_comp_rec IN EAM_PROCESS_WO_PUB.eam_op_comp_rec_type
54: , x_return_status OUT NOCOPY VARCHAR2
55: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
56: )
57: IS
58: l_Mesg_Token_tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
59: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;

Line 58: l_Mesg_Token_tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

54: , x_return_status OUT NOCOPY VARCHAR2
55: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
56: )
57: IS
58: l_Mesg_Token_tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
59: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
60: l_status_id NUMBER;
61: l_maintenance_object_id NUMBER := NULL ;
62: l_maintenance_object_type NUMBER := NULL ;

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 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 268: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

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
272: );

Line 273: x_return_status := EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR;

269: ( p_message_name => NULL
270: , p_message_text => G_PKG_NAME ||' :Inserting Record ' || SQLERRM
271: , x_mesg_token_Tbl => l_Mesg_Token_tbl
272: );
273: x_return_status := EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR;
274: x_mesg_token_Tbl := l_Mesg_Token_tbl;
275:
276: END insert_row;
277:

Line 282: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type

278: PROCEDURE update_row
279: (
280: p_eam_op_comp_rec IN EAM_PROCESS_WO_PUB.eam_op_comp_rec_type
281: , x_return_status OUT NOCOPY VARCHAR2
282: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
283: )
284: IS
285: l_shutdown_type VARCHAR2(30) :=NULL;
286: BEGIN

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 351: 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;

347: last_update_login = FND_GLOBAL.login_id
348: WHERE
349: wip_entity_id = p_eam_op_comp_rec.wip_entity_id
350: AND operation_seq_num = p_eam_op_comp_rec.operation_seq_num;
351: 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;
352:
353: END update_row;
354:
355: