DBA Data[Home] [Help]

APPS.EAM_OP_NETWORK_UTILITY_PVT dependencies on EAM_PROCESS_WO_PVT

Line 100: x_return_status := EAM_PROCESS_WO_PVT.G_RECORD_FOUND;

96: AND won.organization_id = p_organization_id
97: AND won.prior_operation = p_prior_operation
98: AND won.next_operation = p_next_operation;
99:
100: x_return_status := EAM_PROCESS_WO_PVT.G_RECORD_FOUND;
101: x_eam_op_network_rec := l_eam_op_network_rec;
102:
103: EXCEPTION
104: WHEN NO_DATA_FOUND THEN

Line 105: x_return_status := EAM_PROCESS_WO_PVT.G_RECORD_NOT_FOUND;

101: x_eam_op_network_rec := l_eam_op_network_rec;
102:
103: EXCEPTION
104: WHEN NO_DATA_FOUND THEN
105: x_return_status := EAM_PROCESS_WO_PVT.G_RECORD_NOT_FOUND;
106: x_eam_op_network_rec := l_eam_op_network_rec;
107:
108: WHEN OTHERS THEN
109: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 132: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Writing Operation Networks rec for ' || p_eam_op_network_rec.prior_operation); END IF;

128: )
129: IS
130: BEGIN
131:
132: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Writing Operation Networks rec for ' || p_eam_op_network_rec.prior_operation); END IF;
133:
134: INSERT INTO WIP_OPERATION_NETWORKS
135: ( wip_entity_id
136: , organization_id

Line 190: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug ('Creating new Operation Networks') ; END IF;

186: , FND_GLOBAL.login_id
187: );
188:
189:
190: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug ('Creating new Operation Networks') ; END IF;
191:
192: x_return_status := FND_API.G_RET_STS_SUCCESS;
193:
194: EXCEPTION

Line 223: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Updating Operation Networks '|| p_eam_op_network_rec.prior_operation); END IF;

219: )
220: IS
221: BEGIN
222:
223: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Updating Operation Networks '|| p_eam_op_network_rec.prior_operation); END IF;
224:
225: UPDATE WIP_OPERATION_NETWORKS
226: SET prior_operation = p_eam_op_network_rec.prior_operation
227: , next_operation = p_eam_op_network_rec.next_operation

Line 274: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Deleting Operation Networks '|| p_eam_op_network_rec.prior_operation); END IF;

270: )
271: IS
272: BEGIN
273:
274: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Deleting Operation Networks '|| p_eam_op_network_rec.prior_operation); END IF;
275:
276: DELETE FROM WIP_OPERATION_NETWORKS
277: WHERE organization_id = p_eam_op_network_rec.organization_id
278: AND wip_entity_id = p_eam_op_network_rec.wip_entity_id

Line 307: IF p_eam_op_network_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_op_network_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE
308: THEN
309: Insert_Row
310: ( p_eam_op_network_rec => p_eam_op_network_rec
311: , x_mesg_token_Tbl => l_mesg_token_tbl

Line 314: ELSIF p_eam_op_network_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_UPDATE

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

Line 322: ELSIF p_eam_op_network_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_DELETE

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