DBA Data[Home] [Help]

APPS.EAM_OP_NETWORK_UTILITY_PVT dependencies on EAM_ERROR_MESSAGE_PVT

Line 126: , x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type

122: *********************************************************************/
123:
124: PROCEDURE Insert_Row
125: ( p_eam_op_network_rec IN EAM_PROCESS_WO_PUB.eam_op_network_rec_type
126: , x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
127: , x_return_Status OUT NOCOPY VARCHAR2
128: )
129: IS
130: BEGIN

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

192: x_return_status := FND_API.G_RET_STS_SUCCESS;
193:
194: EXCEPTION
195: WHEN OTHERS THEN
196: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
197: ( p_message_name => NULL
198: , p_message_text => G_PKG_NAME ||' :Inserting Record ' || SQLERRM
199: , x_mesg_token_Tbl => x_mesg_token_tbl
200: );

Line 217: , x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type

213: *********************************************************************/
214:
215: PROCEDURE Update_Row
216: ( p_eam_op_network_rec IN EAM_PROCESS_WO_PUB.eam_op_network_rec_type
217: , x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
218: , x_return_Status OUT NOCOPY VARCHAR2
219: )
220: IS
221: BEGIN

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 268: , x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type

264: *********************************************************************/
265:
266: PROCEDURE Delete_Row
267: ( p_eam_op_network_rec IN EAM_PROCESS_WO_PUB.eam_op_network_rec_type
268: , x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
269: , x_return_Status OUT NOCOPY VARCHAR2
270: )
271: IS
272: BEGIN

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

295: *********************************************************************/
296:
297: PROCEDURE Perform_Writes
298: ( p_eam_op_network_rec IN EAM_PROCESS_WO_PUB.eam_op_network_rec_type
299: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
300: , x_return_status OUT NOCOPY VARCHAR2
301: )
302: IS
303: l_Mesg_Token_tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

Line 303: l_Mesg_Token_tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

299: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
300: , x_return_status OUT NOCOPY VARCHAR2
301: )
302: IS
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