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

Line 73: x_return_status := EAM_PROCESS_WO_PVT.G_RECORD_FOUND;

69: AND resource_seq_num = p_resource_seq_num
70: AND instance_id = p_instance_id
71: AND serial_number IS null;
72:
73: x_return_status := EAM_PROCESS_WO_PVT.G_RECORD_FOUND;
74: x_eam_res_inst_rec := l_eam_res_inst_rec;
75:
76: ELSE
77:

Line 96: x_return_status := EAM_PROCESS_WO_PVT.G_RECORD_FOUND;

92: AND resource_seq_num = p_resource_seq_num
93: AND instance_id = p_instance_id
94: AND serial_number = p_serial_number;
95:
96: x_return_status := EAM_PROCESS_WO_PVT.G_RECORD_FOUND;
97: x_eam_res_inst_rec := l_eam_res_inst_rec;
98:
99: END IF;
100:

Line 103: x_return_status := EAM_PROCESS_WO_PVT.G_RECORD_NOT_FOUND;

99: END IF;
100:
101: EXCEPTION
102: WHEN NO_DATA_FOUND THEN
103: x_return_status := EAM_PROCESS_WO_PVT.G_RECORD_NOT_FOUND;
104: x_eam_res_inst_rec := l_eam_res_inst_rec;
105:
106: WHEN OTHERS THEN
107: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 130: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Writing Resource Instance rec for ' || p_eam_res_inst_rec.instance_id); END IF;

126: )
127: IS
128: BEGIN
129:
130: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Writing Resource Instance rec for ' || p_eam_res_inst_rec.instance_id); END IF;
131:
132: -- bug no 3444091
133: if p_eam_res_inst_rec.start_date > p_eam_res_inst_rec.completion_date then
134: x_return_status := fnd_api.g_ret_sts_error;

Line 173: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug ('Creating new Resource Instances') ; END IF;

169: , FND_GLOBAL.login_id
170: );
171:
172:
173: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug ('Creating new Resource Instances') ; END IF;
174:
175: x_return_status := FND_API.G_RET_STS_SUCCESS;
176:
177: EXCEPTION

Line 206: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Updating Resource Instance: '|| p_eam_res_inst_rec.instance_id); END IF;

202: )
203: IS
204: BEGIN
205:
206: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Updating Resource Instance: '|| p_eam_res_inst_rec.instance_id); END IF;
207:
208: -- bug no 3444091
209: if p_eam_res_inst_rec.start_date > p_eam_res_inst_rec.completion_date then
210: x_return_status := fnd_api.g_ret_sts_error;

Line 252: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Deleting Resource Instance: '|| p_eam_res_inst_rec.instance_id); END IF;

248: )
249: IS
250: BEGIN
251:
252: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Deleting Resource Instance: '|| p_eam_res_inst_rec.instance_id); END IF;
253:
254: DELETE FROM WIP_OP_RESOURCE_INSTANCES
255: WHERE wip_entity_id = p_eam_res_inst_rec.wip_entity_id
256: AND organization_id = p_eam_res_inst_rec.organization_id

Line 262: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Deleting Resource Instance Usages: '|| p_eam_res_inst_rec.instance_id); END IF;

258: AND resource_seq_num = p_eam_res_inst_rec.resource_seq_num
259: AND instance_id = p_eam_res_inst_rec.instance_id
260: AND (serial_number IS NULL OR (serial_number=p_eam_res_inst_rec.serial_number));
261:
262: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Deleting Resource Instance Usages: '|| p_eam_res_inst_rec.instance_id); END IF;
263:
264: IF p_eam_res_inst_rec.serial_number is NULL THEN
265: DELETE FROM WIP_OPERATION_RESOURCE_USAGE
266: WHERE wip_entity_id = p_eam_res_inst_rec.wip_entity_id

Line 307: IF p_eam_res_inst_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE

303: l_Mesg_Token_tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
304: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
305: BEGIN
306:
307: IF p_eam_res_inst_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE
308: THEN
309: Insert_Row
310: ( p_eam_res_inst_rec => p_eam_res_inst_rec
311: , x_mesg_token_Tbl => l_mesg_token_tbl

Line 314: ELSIF p_eam_res_inst_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_UPDATE

310: ( p_eam_res_inst_rec => p_eam_res_inst_rec
311: , x_mesg_token_Tbl => l_mesg_token_tbl
312: , x_return_Status => l_return_status
313: );
314: ELSIF p_eam_res_inst_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_UPDATE
315: THEN
316: Update_Row
317: ( p_eam_res_inst_rec => p_eam_res_inst_rec
318: , x_mesg_token_Tbl => l_mesg_token_tbl

Line 321: ELSIF p_eam_res_inst_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_DELETE

317: ( p_eam_res_inst_rec => p_eam_res_inst_rec
318: , x_mesg_token_Tbl => l_mesg_token_tbl
319: , x_return_Status => l_return_status
320: );
321: ELSIF p_eam_res_inst_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_DELETE
322: THEN
323: Delete_Row
324: ( p_eam_res_inst_rec => p_eam_res_inst_rec
325: , x_mesg_token_Tbl => l_mesg_token_tbl