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.BOM_OP_RES_UTIL dependencies on FND_API

Line 126: AND NVL(ACD_TYPE, FND_API.G_MISS_NUM)

122: IS
123:
124: SELECT * FROM BOM_OPERATION_RESOURCES
125: WHERE (( l_bo_id = BOM_Rtg_Globals.G_ECO_BO
126: AND NVL(ACD_TYPE, FND_API.G_MISS_NUM)
127: = NVL(p_acd_type,FND_API.G_MISS_NUM))
128: OR
129: ( l_bo_id = BOM_Rtg_Globals.G_RTG_BO
130: /* AND ACD_TYPE IS NULL

Line 127: = NVL(p_acd_type,FND_API.G_MISS_NUM))

123:
124: SELECT * FROM BOM_OPERATION_RESOURCES
125: WHERE (( l_bo_id = BOM_Rtg_Globals.G_ECO_BO
126: AND NVL(ACD_TYPE, FND_API.G_MISS_NUM)
127: = NVL(p_acd_type,FND_API.G_MISS_NUM))
128: OR
129: ( l_bo_id = BOM_Rtg_Globals.G_RTG_BO
130: /* AND ACD_TYPE IS NULL
131: Bug 6378493 Commenting out the condition on the parameter ACD_type */

Line 154: p_acd_type = FND_API.G_MISS_NUM

150: -- Calling from revised operation resource with
151: -- transaction type : Create, Acd_Type: Change or Disable
152: -- to get the original value and defaulting
153: IF l_bo_id = BOM_Rtg_Globals.G_ECO_BO AND
154: p_acd_type = FND_API.G_MISS_NUM
155: THEN
156: l_bo_id := BOM_Rtg_Globals.G_RTG_BO ;
157:
158: begin

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_op_resource_rec := p_rev_op_resource_rec ;
345: l_rev_op_res_unexp_rec := p_rev_op_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_op_resource_rec := p_rev_op_resource_rec ;
345: l_rev_op_res_unexp_rec := p_rev_op_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, prog id, prog appl id and prog update date.
454: INSERT INTO BOM_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 670: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

666: ) ;
667: END IF ;
668:
669: -- Return the status and message table.
670: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
671: x_mesg_token_tbl := l_mesg_token_tbl ;
672:
673: END Update_Row ;
674:

Line 703: x_return_status := FND_API.G_RET_STS_SUCCESS ;

699: l_token_tbl Error_Handler.Token_Tbl_Type;
700:
701: BEGIN
702:
703: x_return_status := FND_API.G_RET_STS_SUCCESS ;
704:
705:
706: DELETE FROM BOM_OPERATION_RESOURCES
707: WHERE operation_sequence_id = p_rev_op_res_unexp_rec.operation_sequence_id

Line 773: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

769: ) ;
770: END IF ;
771:
772: -- Return the status and message table.
773: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
774: x_mesg_token_tbl := l_mesg_token_tbl ;
775:
776: END Delete_Row ;
777: