DBA Data[Home] [Help]

APPS.ENG_GLOBALS dependencies on FND_API

Line 52: NVL(p_transaction_type, FND_API.G_MISS_CHAR)

48:
49: IF ((p_entity IN ('ECO_Header', 'ECO_Rev', 'Rev_Items', 'Ref_Desgs',
50: 'Sub_Comps','Sub_Res', 'Op_Res',
51: 'Change_Lines', 'People') AND
52: NVL(p_transaction_type, FND_API.G_MISS_CHAR)
53: NOT IN ('CREATE', 'UPDATE', 'DELETE')))
54: OR
55: ((p_entity IN ('Rev_Comps','Op_Seq') AND -- L1
56: NVL(p_transaction_type, FND_API.G_MISS_CHAR)

Line 56: NVL(p_transaction_type, FND_API.G_MISS_CHAR)

52: NVL(p_transaction_type, FND_API.G_MISS_CHAR)
53: NOT IN ('CREATE', 'UPDATE', 'DELETE')))
54: OR
55: ((p_entity IN ('Rev_Comps','Op_Seq') AND -- L1
56: NVL(p_transaction_type, FND_API.G_MISS_CHAR)
57: NOT IN ('CREATE', 'UPDATE', 'DELETE', 'CANCEL')))
58: THEN
59: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
60: THEN

Line 504: RAISE FND_API.G_EXC_ERROR;

500: THEN
501: x_err_text := G_PKG_NAME || '(Check_Approved_For_Process) - ECO Header' || substrb(SQLERRM,1,60);
502: END IF;
503:
504: RAISE FND_API.G_EXC_ERROR;
505:
506: END Check_Approved_For_Process;
507:
508: -- Sets ECO to 'Not Submitted For Approval' and any

Line 563: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

559: x_err_text := G_PKG_NAME || '(Set_Request_For_Approval) -
560: ECO Header and Revised Items' || substrb(SQLERRM,1,60);
561: END IF;
562:
563: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
564:
565: END Set_Request_For_Approval;
566:
567: -- Function Get_ECO_Assembly_Type

Line 717: RAISE FND_API.G_EXC_ERROR;

713: , x_err_text => x_err_text );
714:
715: END IF;
716:
717: RAISE FND_API.G_EXC_ERROR;
718:
719: WHEN OTHER THEN
720: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
721: THEN

Line 730: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

726: , p_err_text => l_err_text
727: , x_err_text => x_err_text );
728: END IF;
729:
730: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
731:
732: END Validate_Change_Order_Access;
733: */
734:

Line 1694: x_return_status := FND_API.G_RET_STS_SUCCESS ;

1690: l_err_text VARCHAR2(2000) ;
1691: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type ;
1692:
1693: BEGIN
1694: x_return_status := FND_API.G_RET_STS_SUCCESS ;
1695:
1696: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug
1697: ('Create New Routing for ECO . . .') ;
1698: END IF ;

Line 1787: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1783: , x_mesg_token_tbl => l_mesg_token_tbl
1784: ) ;
1785:
1786: -- Return the status and message table.
1787: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1788: x_mesg_token_tbl := l_mesg_token_tbl ;
1789: END Create_New_Routing ;
1790:
1791:

Line 1826: l_return_status := FND_API.G_RET_STS_SUCCESS ;

1822: l_Token_Tbl Error_Handler.Token_Tbl_Type;
1823:
1824:
1825: BEGIN
1826: l_return_status := FND_API.G_RET_STS_SUCCESS ;
1827: x_return_status := FND_API.G_RET_STS_SUCCESS ;
1828:
1829: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN
1830: Error_Handler.Write_Debug('Performing cancel revised operation : '

Line 1827: x_return_status := FND_API.G_RET_STS_SUCCESS ;

1823:
1824:
1825: BEGIN
1826: l_return_status := FND_API.G_RET_STS_SUCCESS ;
1827: x_return_status := FND_API.G_RET_STS_SUCCESS ;
1828:
1829: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN
1830: Error_Handler.Write_Debug('Performing cancel revised operation : '
1831: || to_char(p_operation_sequence_id) || ' . . .') ;

Line 2036: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2032: ) ;
2033: END IF ;
2034:
2035: -- Return the status and message table.
2036: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2037: x_mesg_token_tbl := l_mesg_token_tbl ;
2038:
2039: END Cancel_Operation ;
2040:

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

2087: WHERE NOT EXISTS ( SELECT routing_sequence_id
2088: FROM BOM_OPERATIONAL_ROUTINGS
2089: WHERE assembly_item_id = p_revised_item_id
2090: AND organization_id = p_organization_id
2091: AND NVL(alternate_routing_designator, FND_API.G_MISS_CHAR) =
2092: NVL(p_alternate_rtg_code,FND_API.G_MISS_CHAR)
2093: );
2094:
2095: -- Get Eng_Item_Flag for Routing Type value

Line 2092: NVL(p_alternate_rtg_code,FND_API.G_MISS_CHAR)

2088: FROM BOM_OPERATIONAL_ROUTINGS
2089: WHERE assembly_item_id = p_revised_item_id
2090: AND organization_id = p_organization_id
2091: AND NVL(alternate_routing_designator, FND_API.G_MISS_CHAR) =
2092: NVL(p_alternate_rtg_code,FND_API.G_MISS_CHAR)
2093: );
2094:
2095: -- Get Eng_Item_Flag for Routing Type value
2096: CURSOR l_routing_type_csr ( p_revised_item_id NUMBER

Line 2118: l_return_status := FND_API.G_RET_STS_SUCCESS ;

2114: -- Initialize Rev Op Record and Status
2115: --
2116: l_rev_operation_rec := p_rev_operation_rec ;
2117: l_rev_op_unexp_rec := p_rev_op_unexp_rec ;
2118: l_return_status := FND_API.G_RET_STS_SUCCESS ;
2119: x_return_status := FND_API.G_RET_STS_SUCCESS ;
2120:
2121:
2122: IF l_rev_operation_rec.transaction_type = BOM_Rtg_Globals.G_OPR_CREATE THEN

Line 2119: x_return_status := FND_API.G_RET_STS_SUCCESS ;

2115: --
2116: l_rev_operation_rec := p_rev_operation_rec ;
2117: l_rev_op_unexp_rec := p_rev_op_unexp_rec ;
2118: l_return_status := FND_API.G_RET_STS_SUCCESS ;
2119: x_return_status := FND_API.G_RET_STS_SUCCESS ;
2120:
2121:
2122: IF l_rev_operation_rec.transaction_type = BOM_Rtg_Globals.G_OPR_CREATE THEN
2123:

Line 2231: IF l_temp_return_status <> FND_API.G_RET_STS_SUCCESS

2227: , x_return_status => l_temp_return_status
2228: ) ;
2229:
2230:
2231: IF l_temp_return_status <> FND_API.G_RET_STS_SUCCESS
2232: THEN
2233: l_return_status := l_temp_return_status ;
2234: l_mesg_token_Tbl := l_temp_Mesg_Token_Tbl ;
2235:

Line 2311: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2307: , x_mesg_token_tbl => l_mesg_token_tbl
2308: ) ;
2309:
2310: -- Return the status and message table.
2311: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2312: x_mesg_token_tbl := l_mesg_token_tbl ;
2313:
2314:
2315: END Perform_Writes_for_Primary_RTG ;

Line 2432: l_return_status := FND_API.G_RET_STS_SUCCESS ;

2428: -- Initialize Rev Op Record and Status
2429: --
2430: l_rev_operation_rec := p_rev_operation_rec ;
2431: l_rev_op_unexp_rec := p_rev_op_unexp_rec ;
2432: l_return_status := FND_API.G_RET_STS_SUCCESS ;
2433: x_return_status := FND_API.G_RET_STS_SUCCESS ;
2434:
2435:
2436: IF l_rev_operation_rec.transaction_type = BOM_Rtg_Globals.G_OPR_CREATE THEN

Line 2433: x_return_status := FND_API.G_RET_STS_SUCCESS ;

2429: --
2430: l_rev_operation_rec := p_rev_operation_rec ;
2431: l_rev_op_unexp_rec := p_rev_op_unexp_rec ;
2432: l_return_status := FND_API.G_RET_STS_SUCCESS ;
2433: x_return_status := FND_API.G_RET_STS_SUCCESS ;
2434:
2435:
2436: IF l_rev_operation_rec.transaction_type = BOM_Rtg_Globals.G_OPR_CREATE THEN
2437:

Line 2547: IF l_temp_return_status <> FND_API.G_RET_STS_SUCCESS

2543: ) ;
2544:
2545:
2546:
2547: IF l_temp_return_status <> FND_API.G_RET_STS_SUCCESS
2548: THEN
2549: l_return_status := l_temp_return_status ;
2550: l_mesg_token_Tbl := l_temp_Mesg_Token_Tbl ;
2551:

Line 2628: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2624: , x_mesg_token_tbl => l_mesg_token_tbl
2625: ) ;
2626:
2627: -- Return the status and message table.
2628: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2629: x_mesg_token_tbl := l_mesg_token_tbl ;
2630:
2631:
2632: END Perform_Writes_for_Alt_RTG ;