DBA Data[Home] [Help]

APPS.BOM_SUB_OP_RES_UTIL dependencies on FND_API

Line 259: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

255: , x_mesg_token_tbl => l_mesg_token_tbl
256: ) ;
257:
258: -- Return the status and message table.
259: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
260: x_mesg_token_tbl := l_mesg_token_tbl ;
261:
262:
263: END Query_Row;

Line 346: l_return_status := FND_API.G_RET_STS_SUCCESS ;

342: -- Initialize Record and Status
343: --
344: l_rev_sub_resource_rec := p_rev_sub_resource_rec ;
345: l_rev_sub_res_unexp_rec := p_rev_sub_res_unexp_rec ;
346: l_return_status := FND_API.G_RET_STS_SUCCESS ;
347: x_return_status := FND_API.G_RET_STS_SUCCESS ;
348:
349: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug
350: ('Performing Database Writes . . .') ;

Line 347: x_return_status := FND_API.G_RET_STS_SUCCESS ;

343: --
344: l_rev_sub_resource_rec := p_rev_sub_resource_rec ;
345: l_rev_sub_res_unexp_rec := p_rev_sub_res_unexp_rec ;
346: l_return_status := FND_API.G_RET_STS_SUCCESS ;
347: x_return_status := FND_API.G_RET_STS_SUCCESS ;
348:
349: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug
350: ('Performing Database Writes . . .') ;
351: END IF ;

Line 421: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

417: , x_mesg_token_tbl => l_mesg_token_tbl
418: ) ;
419:
420: -- Return the status and message table.
421: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
422: x_mesg_token_tbl := l_mesg_token_tbl ;
423:
424: END Perform_Writes;
425:

Line 451: x_return_status := FND_API.G_RET_STS_SUCCESS ;

447: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type ;
448:
449: BEGIN
450:
451: x_return_status := FND_API.G_RET_STS_SUCCESS ;
452:
453: --bug:3254815 Update request id.
454: INSERT INTO BOM_SUB_OPERATION_RESOURCES
455: (

Line 570: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

566: ) ;
567: END IF ;
568:
569: -- Return the status and message table.
570: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
571: x_mesg_token_tbl := l_mesg_token_tbl ;
572:
573: END Insert_Row ;
574:

Line 600: x_return_status := FND_API.G_RET_STS_SUCCESS ;

596: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type ;
597:
598: BEGIN
599:
600: x_return_status := FND_API.G_RET_STS_SUCCESS ;
601:
602: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Performing update operation . . .') ;
603: END IF ;
604:

Line 674: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

670: ) ;
671: END IF ;
672:
673: -- Return the status and message table.
674: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
675: x_mesg_token_tbl := l_mesg_token_tbl ;
676:
677: END Update_Row ;
678:

Line 707: x_return_status := FND_API.G_RET_STS_SUCCESS ;

703:
704:
705: BEGIN
706:
707: x_return_status := FND_API.G_RET_STS_SUCCESS ;
708:
709: DELETE FROM BOM_SUB_OPERATION_RESOURCES
710: WHERE NVL(acd_type, 0) = NVL(p_rev_sub_resource_rec.acd_type,0)
711: AND basis_type = p_rev_sub_resource_rec.basis_type

Line 745: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

741: ) ;
742: END IF ;
743:
744: -- Return the status and message table.
745: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
746: x_mesg_token_tbl := l_mesg_token_tbl ;
747:
748: END Delete_Row ;
749: