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_SEQ_UTIL dependencies on FND_API

Line 204: AND NVL(OPERATION_TYPE, 1) = DECODE(p_operation_type, FND_API.G_MISS_NUM, 1

200: -- /** time **/ TRUNC(EFFECTIVITY_DATE) = TRUNC(p_effectivity_date)
201: )
202: OR p_operation_type IN (2,3)
203: )
204: AND NVL(OPERATION_TYPE, 1) = DECODE(p_operation_type, FND_API.G_MISS_NUM, 1
205: , NVL(p_operation_type, 1))
206: AND OPERATION_SEQ_NUM = p_operation_sequence_number
207: AND routing_sequence_id = p_routing_sequence_id
208: ;

Line 347: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR ;

343: , p_mesg_token_tbl => p_mesg_token_tbl
344: , x_mesg_token_tbl => x_mesg_token_tbl
345: );
346:
347: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR ;
348:
349: END Query_Row;
350:
351:

Line 487: AND NVL(alternate_routing_designator, FND_API.G_MISS_CHAR) =

483: WHERE NOT EXISTS ( SELECT routing_sequence_id
484: FROM bom_operational_routings
485: WHERE assembly_item_id = p_revised_item_id
486: AND organization_id = p_organization_id
487: AND NVL(alternate_routing_designator, FND_API.G_MISS_CHAR) =
488: NVL(p_alternate_rtg_code,FND_API.G_MISS_CHAR)
489: );
490:
491: -- Get Eng_Item_Flag for Routing Type value

Line 488: NVL(p_alternate_rtg_code,FND_API.G_MISS_CHAR)

484: FROM bom_operational_routings
485: WHERE assembly_item_id = p_revised_item_id
486: AND organization_id = p_organization_id
487: AND NVL(alternate_routing_designator, FND_API.G_MISS_CHAR) =
488: NVL(p_alternate_rtg_code,FND_API.G_MISS_CHAR)
489: );
490:
491: -- Get Eng_Item_Flag for Routing Type value
492: CURSOR l_routing_type_csr ( p_revised_item_id NUMBER

Line 512: l_return_status := FND_API.G_RET_STS_SUCCESS ;

508: -- Initialize Common Record and Status
509: --
510: l_com_operation_rec := p_com_operation_rec ;
511: l_com_op_unexp_rec := p_com_op_unexp_rec ;
512: l_return_status := FND_API.G_RET_STS_SUCCESS ;
513: x_return_status := FND_API.G_RET_STS_SUCCESS ;
514:
515: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug
516: ('Performing Database Writes . . .') ;

Line 513: x_return_status := FND_API.G_RET_STS_SUCCESS ;

509: --
510: l_com_operation_rec := p_com_operation_rec ;
511: l_com_op_unexp_rec := p_com_op_unexp_rec ;
512: l_return_status := FND_API.G_RET_STS_SUCCESS ;
513: x_return_status := FND_API.G_RET_STS_SUCCESS ;
514:
515: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug
516: ('Performing Database Writes . . .') ;
517: END IF ;

Line 621: IF l_temp_return_status <> FND_API.G_RET_STS_SUCCESS

617: , x_return_status => l_temp_return_status
618: ) ;
619:
620:
621: IF l_temp_return_status <> FND_API.G_RET_STS_SUCCESS
622: THEN
623: l_return_status := l_temp_return_status ;
624: l_mesg_token_Tbl := l_temp_Mesg_Token_Tbl ;
625:

Line 685: IF l_temp_return_status <> FND_API.G_RET_STS_SUCCESS

681: , x_return_status => l_temp_return_status
682: , x_mesg_token_tbl => l_temp_mesg_token_tbl
683: ) ;
684:
685: IF l_temp_return_status <> FND_API.G_RET_STS_SUCCESS
686: THEN
687: l_return_status := l_temp_return_status ;
688: l_mesg_token_Tbl := l_temp_Mesg_Token_Tbl ;
689: END IF ;

Line 787: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

783: , x_mesg_token_tbl => l_mesg_token_tbl
784: ) ;
785:
786: -- Return the status and message table.
787: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
788: x_mesg_token_tbl := l_mesg_token_tbl ;
789:
790: END Perform_Writes;
791:

Line 841: x_return_status := FND_API.G_RET_STS_SUCCESS ;

837: -- on the eng odf.This is because the RTG and ECO objects should be
838: -- independant of each other. But commenting out because we will reuse it
839: -- in release 12 when these all files alongwith the odf will be base
840:
841: x_return_status := FND_API.G_RET_STS_SUCCESS ;
842:
843: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug
844: ('Create New Routing for ECO . . .') ;
845: END IF ;

Line 932: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

928: , x_mesg_token_tbl => l_mesg_token_tbl
929: ) ;
930:
931: -- Return the status and message table.
932: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
933: x_mesg_token_tbl := l_mesg_token_tbl ;
934: */
935:
936:

Line 1454: l_return_status := FND_API.G_RET_STS_SUCCESS ;

1450:
1451:
1452: BEGIN
1453:
1454: l_return_status := FND_API.G_RET_STS_SUCCESS ;
1455: x_return_status := FND_API.G_RET_STS_SUCCESS ;
1456:
1457: l_Bo_Id := BOM_Rtg_Globals.Get_Bo_Identifier ;
1458:

Line 1455: x_return_status := FND_API.G_RET_STS_SUCCESS ;

1451:
1452: BEGIN
1453:
1454: l_return_status := FND_API.G_RET_STS_SUCCESS ;
1455: x_return_status := FND_API.G_RET_STS_SUCCESS ;
1456:
1457: l_Bo_Id := BOM_Rtg_Globals.Get_Bo_Identifier ;
1458:
1459:

Line 1706: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1702: ) ;
1703: END IF ;
1704:
1705: -- Return the status and message table.
1706: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1707: x_mesg_token_tbl := l_mesg_token_tbl ;
1708:
1709: END Insert_Row ;
1710:

Line 1738: l_return_status := FND_API.G_RET_STS_SUCCESS ;

1734: l_Token_Tbl Error_Handler.Token_Tbl_Type;
1735:
1736: BEGIN
1737:
1738: l_return_status := FND_API.G_RET_STS_SUCCESS ;
1739: x_return_status := FND_API.G_RET_STS_SUCCESS ;
1740:
1741:
1742: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Performing update operation . . .') ;

Line 1739: x_return_status := FND_API.G_RET_STS_SUCCESS ;

1735:
1736: BEGIN
1737:
1738: l_return_status := FND_API.G_RET_STS_SUCCESS ;
1739: x_return_status := FND_API.G_RET_STS_SUCCESS ;
1740:
1741:
1742: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Performing update operation . . .') ;
1743: END IF ;

Line 1872: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1868: ) ;
1869: END IF ;
1870:
1871: -- Return the status and message table.
1872: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1873: x_mesg_token_tbl := l_mesg_token_tbl ;
1874:
1875: END Update_Row ;
1876:

Line 1930: l_return_status := FND_API.G_RET_STS_SUCCESS ;

1926: -- Exception
1927: DUPLICATE_DEL_GROUP EXCEPTION ;
1928:
1929: BEGIN
1930: l_return_status := FND_API.G_RET_STS_SUCCESS ;
1931: x_return_status := FND_API.G_RET_STS_SUCCESS ;
1932:
1933: --
1934: -- Initialize Common Record and Status

Line 1931: x_return_status := FND_API.G_RET_STS_SUCCESS ;

1927: DUPLICATE_DEL_GROUP EXCEPTION ;
1928:
1929: BEGIN
1930: l_return_status := FND_API.G_RET_STS_SUCCESS ;
1931: x_return_status := FND_API.G_RET_STS_SUCCESS ;
1932:
1933: --
1934: -- Initialize Common Record and Status
1935: --

Line 2003: IF l_com_op_unexp_rec.DG_Sequence_Id <> FND_API.G_MISS_NUM

1999: l_com_op_unexp_rec.DG_Description := l_del_grp_rec.description ;
2000:
2001: END LOOP;
2002:
2003: IF l_com_op_unexp_rec.DG_Sequence_Id <> FND_API.G_MISS_NUM
2004: THEN
2005: l_dg_sequence_id := l_com_op_unexp_rec.DG_Sequence_Id;
2006: ELSE
2007: --

Line 2023: IF l_com_operation_rec.alternate_routing_code = FND_API.G_MISS_CHAR THEN

2019:
2020: END IF;
2021:
2022:
2023: IF l_com_operation_rec.alternate_routing_code = FND_API.G_MISS_CHAR THEN
2024: l_com_operation_rec.alternate_routing_code := NULL ;
2025: END IF ;
2026:
2027: -- bug 5199643

Line 2087: x_return_status := FND_API.G_RET_STS_ERROR;

2083: x_com_operation_rec := l_com_operation_rec ;
2084: x_com_op_unexp_rec := l_com_op_unexp_rec ;
2085:
2086: -- Return the status and message table.
2087: x_return_status := FND_API.G_RET_STS_ERROR;
2088: x_mesg_token_tbl := l_mesg_token_tbl;
2089:
2090: WHEN OTHERS THEN
2091: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug

Line 2114: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2110: x_com_operation_rec := l_com_operation_rec ;
2111: x_com_op_unexp_rec := l_com_op_unexp_rec ;
2112:
2113: -- Return the status and message table.
2114: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2115: x_mesg_token_tbl := l_mesg_token_tbl ;
2116:
2117: END Delete_Row ;
2118:

Line 2161: l_return_status := FND_API.G_RET_STS_SUCCESS ;

2157: on the eng odf.This is because the RTG and ECO objects should be
2158: independant of each other. But commenting out because we will reuse it
2159: in release 12 when these all files alongwith the odf will be base
2160:
2161: l_return_status := FND_API.G_RET_STS_SUCCESS ;
2162: x_return_status := FND_API.G_RET_STS_SUCCESS ;
2163:
2164: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN
2165: Error_Handler.Write_Debug('Performing cancel revised operation : '

Line 2162: x_return_status := FND_API.G_RET_STS_SUCCESS ;

2158: independant of each other. But commenting out because we will reuse it
2159: in release 12 when these all files alongwith the odf will be base
2160:
2161: l_return_status := FND_API.G_RET_STS_SUCCESS ;
2162: x_return_status := FND_API.G_RET_STS_SUCCESS ;
2163:
2164: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN
2165: Error_Handler.Write_Debug('Performing cancel revised operation : '
2166: || to_char(p_operation_sequence_id) || ' . . .') ;

Line 2372: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2368: ) ;
2369: END IF ;
2370:
2371: -- Return the status and message table.
2372: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2373: x_mesg_token_tbl := l_mesg_token_tbl ;
2374: */
2375: END Cancel_Operation ;
2376: