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

Line 144: l_return_status_del VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

140: IS
141:
142: -- general, column_changes and and cz's delete api stuff
143: l_direct_save BOOLEAN;
144: l_return_status_del VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
145: l_model_line_rec OE_ORDER_PUB.Line_Rec_Type;
146: l_profile_value VARCHAR2(1) :=
147: upper(FND_PROFILE.VALUE('ONT_CONFIG_QUICK_SAVE'));
148:

Line 327: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

323: IF p_config_hdr_id = l_model_line_rec.config_header_id AND
324: p_config_rev_nbr = l_model_line_rec.config_rev_nbr THEN
325: oe_debug_pub.add('do not delete, special', 1);
326: ELSE
327: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
328: -- since we could not save the config successfully,
329: -- delete current rev. in SPC
330:
331: Delete_Config( p_config_hdr_id => p_config_hdr_id

Line 335: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

331: Delete_Config( p_config_hdr_id => p_config_hdr_id
332: ,p_config_rev_nbr => p_config_rev_nbr
333: ,x_return_status => l_return_status_del);
334:
335: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
336: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
337: ELSE
338: RAISE FND_API.G_EXC_ERROR;
339: END IF;

Line 336: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

332: ,p_config_rev_nbr => p_config_rev_nbr
333: ,x_return_status => l_return_status_del);
334:
335: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
336: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
337: ELSE
338: RAISE FND_API.G_EXC_ERROR;
339: END IF;
340: ELSE

Line 338: RAISE FND_API.G_EXC_ERROR;

334:
335: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
336: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
337: ELSE
338: RAISE FND_API.G_EXC_ERROR;
339: END IF;
340: ELSE
341: -- If we successfully save the configuration in oe_order_lines then
342: -- Time to delete previous revisions from spc

Line 363: x_return_status := FND_API.G_RET_STS_SUCCESS;

359: oe_debug_pub.add( 'CHANGED CONFIG INTERACTIVELY' , 1 ) ;
360: END IF;
361: END IF;
362:
363: x_return_status := FND_API.G_RET_STS_SUCCESS;
364:
365: Print_Time('Leaving Process Config');
366:
367: EXCEPTION

Line 368: WHEN FND_API.G_EXC_ERROR THEN

364:
365: Print_Time('Leaving Process Config');
366:
367: EXCEPTION
368: WHEN FND_API.G_EXC_ERROR THEN
369:
370: x_return_status := FND_API.G_RET_STS_ERROR;
371: -- Get message count and data
372: oe_msg_pub.count_and_get

Line 370: x_return_status := FND_API.G_RET_STS_ERROR;

366:
367: EXCEPTION
368: WHEN FND_API.G_EXC_ERROR THEN
369:
370: x_return_status := FND_API.G_RET_STS_ERROR;
371: -- Get message count and data
372: oe_msg_pub.count_and_get
373: ( p_count => x_msg_count
374: , p_data => x_msg_data

Line 377: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

373: ( p_count => x_msg_count
374: , p_data => x_msg_data
375: );
376:
377: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
378:
379: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
380: -- Get message count and data
381: oe_msg_pub.count_and_get

Line 379: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

375: );
376:
377: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
378:
379: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
380: -- Get message count and data
381: oe_msg_pub.count_and_get
382: ( p_count => x_msg_count
383: , p_data => x_msg_data

Line 404: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

400: oe_msg_pub.count_and_get
401: ( p_count => x_msg_count
402: , p_data => x_msg_data
403: );
404: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
405:
406: END Process_Config;
407:
408:

Line 671: RAISE FND_API.G_EXC_ERROR;

667: WHERE inventory_item_id = config_rec.inventory_item_id
668: AND organization_id = OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID');
669: EXCEPTION
670: WHEN NO_DATA_FOUND THEN
671: RAISE FND_API.G_EXC_ERROR;
672: END;
673:
674: IF l_debug_level > 0 THEN
675: oe_debug_pub.add('CONCAT SEGMENT IS: ' || L_CONCATENATED_SEGMENTS,3);

Line 697: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

693: ,p_x_child_line_rec => l_class_line_rec
694: ,p_direct_save => p_direct_save
695: ,x_return_status => l_return_status);
696:
697: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
698: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
699: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
700: RAISE FND_API.G_EXC_ERROR;
701: END IF;

Line 698: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

694: ,p_direct_save => p_direct_save
695: ,x_return_status => l_return_status);
696:
697: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
698: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
699: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
700: RAISE FND_API.G_EXC_ERROR;
701: END IF;
702:

Line 699: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

695: ,x_return_status => l_return_status);
696:
697: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
698: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
699: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
700: RAISE FND_API.G_EXC_ERROR;
701: END IF;
702:
703: l_default_child_line := FALSE;

Line 700: RAISE FND_API.G_EXC_ERROR;

696:
697: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
698: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
699: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
700: RAISE FND_API.G_EXC_ERROR;
701: END IF;
702:
703: l_default_child_line := FALSE;
704: l_default_line_type_id := l_class_line_rec.line_type_id; --Added for bug 5107271

Line 709: config_rec.line_type <> FND_API.G_MISS_NUM THEN

705:
706: END IF;
707:
708: IF config_rec.line_type IS NOT NULL AND
709: config_rec.line_type <> FND_API.G_MISS_NUM THEN
710:
711: IF l_debug_level > 0 THEN
712: OE_DEBUG_PUB.Add('Line Type from cz:'||config_rec.line_type,3);
713: END IF;

Line 717: l_default_line_type_id instead of FND_API.G_MISS_NUM */

713: END IF;
714: l_class_line_rec.line_type_id := config_rec.line_type;
715: ELSE
716: /* Modified the below statement for bug 5107271 to assign the value of
717: l_default_line_type_id instead of FND_API.G_MISS_NUM */
718: -- l_class_line_rec.line_type_id := FND_API.G_MISS_NUM;
719: l_class_line_rec.line_type_id := l_default_line_type_id;
720: END IF;
721:

Line 718: -- l_class_line_rec.line_type_id := FND_API.G_MISS_NUM;

714: l_class_line_rec.line_type_id := config_rec.line_type;
715: ELSE
716: /* Modified the below statement for bug 5107271 to assign the value of
717: l_default_line_type_id instead of FND_API.G_MISS_NUM */
718: -- l_class_line_rec.line_type_id := FND_API.G_MISS_NUM;
719: l_class_line_rec.line_type_id := l_default_line_type_id;
720: END IF;
721:
722: l_class_line_rec.ordered_quantity := config_rec.quantity;

Line 747: config_rec.line_type <> FND_API.G_MISS_NUM THEN

743:
744: ELSE
745:
746: IF config_rec.line_type IS NOT NULL AND
747: config_rec.line_type <> FND_API.G_MISS_NUM THEN
748:
749: IF l_debug_level > 0 THEN
750: OE_DEBUG_PUB.Add('cz LineType:'||config_rec.line_type,3);
751: END IF;

Line 754: l_line_rec.line_type_id := FND_API.G_MISS_NUM;

750: OE_DEBUG_PUB.Add('cz LineType:'||config_rec.line_type,3);
751: END IF;
752: l_line_rec.line_type_id := config_rec.line_type;
753: ELSE
754: l_line_rec.line_type_id := FND_API.G_MISS_NUM;
755: END IF;
756:
757:
758: l_line_rec.ordered_quantity := config_rec.quantity;

Line 872: RAISE FND_API.G_EXC_ERROR;

868: WHERE inventory_item_id = config_rec.inventory_item_id
869: AND organization_id = OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID');
870: EXCEPTION
871: WHEN NO_DATA_FOUND THEN
872: RAISE FND_API.G_EXC_ERROR;
873: END;
874:
875: IF l_debug_level > 0 THEN
876: oe_debug_pub.add('CONCAT SEGMENT IS: ' || L_CONCATENATED_SEGMENTS ,3);

Line 894: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

890: ,p_x_child_line_rec => l_class_line_rec
891: ,p_direct_save => p_direct_save
892: ,x_return_status => l_return_status);
893:
894: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
895: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
896: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
897: RAISE FND_API.G_EXC_ERROR;
898: END IF;

Line 895: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

891: ,p_direct_save => p_direct_save
892: ,x_return_status => l_return_status);
893:
894: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
895: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
896: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
897: RAISE FND_API.G_EXC_ERROR;
898: END IF;
899:

Line 896: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

892: ,x_return_status => l_return_status);
893:
894: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
895: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
896: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
897: RAISE FND_API.G_EXC_ERROR;
898: END IF;
899:
900: l_default_child_line := FALSE;

Line 897: RAISE FND_API.G_EXC_ERROR;

893:
894: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
895: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
896: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
897: RAISE FND_API.G_EXC_ERROR;
898: END IF;
899:
900: l_default_child_line := FALSE;
901:

Line 1058: config_rec.line_type <> FND_API.G_MISS_NUM THEN

1054: l_line_rec.ordered_quantity := config_rec.quantity;
1055: l_line_rec.sort_order := config_rec.bom_sort_order;
1056:
1057: IF config_rec.line_type IS NOT NULL AND
1058: config_rec.line_type <> FND_API.G_MISS_NUM THEN
1059:
1060: IF l_debug_level > 0 THEN
1061: OE_DEBUG_PUB.Add('MACD Logic,cz Line_type:'||config_rec.line_type,3);
1062: END IF;

Line 1065: l_line_rec.line_type_id := FND_API.G_MISS_NUM;

1061: OE_DEBUG_PUB.Add('MACD Logic,cz Line_type:'||config_rec.line_type,3);
1062: END IF;
1063: l_line_rec.line_type_id := config_rec.line_type;
1064: ELSE
1065: l_line_rec.line_type_id := FND_API.G_MISS_NUM;
1066: END IF;
1067:
1068:
1069: IF p_ui_flag = 'N' THEN

Line 1568: l_ordered_quantity NUMBER := FND_API.G_MISS_NUM;

1564: IS
1565: l_open_flag VARCHAR2(1);
1566: l_line_id NUMBER;
1567: l_parent_line_id NUMBER;
1568: l_ordered_quantity NUMBER := FND_API.G_MISS_NUM;
1569: l_component_code VARCHAR2(1000);
1570: --
1571: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1572: --

Line 1828: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

1824: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
1825: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
1826: l_msg_count NUMBER;
1827: l_msg_data VARCHAR2(2000);
1828: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1829: l_index NUMBER;
1830: l_return_code NUMBER; --Bug 4165102
1831: l_error_buffer VARCHAR2(240); --Bug 4165102
1832:

Line 1880: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE

1876: fnd_profile.put('OE_CALCULATE_TAX_IN_OM', 'N');
1877:
1878: Print_Time('call to lines start time');
1879: OE_Order_Pvt.Lines
1880: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE
1881: , p_control_rec => p_control_rec
1882: , p_x_line_tbl => p_line_tbl
1883: , p_x_old_line_tbl => l_old_line_tbl
1884: , x_return_status => l_return_status);

Line 1895: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1891: OE_CONFIG_UTIL.G_CONFIG_UI_USED := 'N';
1892:
1893: fnd_profile.put('OE_CALCULATE_TAX_IN_OM', 'Y');
1894:
1895: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1896: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1897: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1898: RAISE FND_API.G_EXC_ERROR;
1899: END IF;

Line 1896: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1892:
1893: fnd_profile.put('OE_CALCULATE_TAX_IN_OM', 'Y');
1894:
1895: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1896: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1897: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1898: RAISE FND_API.G_EXC_ERROR;
1899: END IF;
1900: END IF; -- count > 0

Line 1897: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1893: fnd_profile.put('OE_CALCULATE_TAX_IN_OM', 'Y');
1894:
1895: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1896: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1897: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1898: RAISE FND_API.G_EXC_ERROR;
1899: END IF;
1900: END IF; -- count > 0
1901:

Line 1898: RAISE FND_API.G_EXC_ERROR;

1894:
1895: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1896: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1897: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1898: RAISE FND_API.G_EXC_ERROR;
1899: END IF;
1900: END IF; -- count > 0
1901:
1902:

Line 1981: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1977: (p_line_id => l_line_rec.top_model_line_id,
1978: p_child_line_id => l_line_rec.line_id,
1979: x_return_status => l_return_status);
1980:
1981: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1982: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1983: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1984: RAISE FND_API.G_EXC_ERROR;
1985: END IF;

Line 1982: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1978: p_child_line_id => l_line_rec.line_id,
1979: x_return_status => l_return_status);
1980:
1981: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1982: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1983: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1984: RAISE FND_API.G_EXC_ERROR;
1985: END IF;
1986: -- Bug 5912216: Start the line level workflows for config child

Line 1983: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1979: x_return_status => l_return_status);
1980:
1981: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1982: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1983: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1984: RAISE FND_API.G_EXC_ERROR;
1985: END IF;
1986: -- Bug 5912216: Start the line level workflows for config child
1987: -- lines only in case of normal sales order lines, NOT

Line 1984: RAISE FND_API.G_EXC_ERROR;

1980:
1981: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1982: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1983: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1984: RAISE FND_API.G_EXC_ERROR;
1985: END IF;
1986: -- Bug 5912216: Start the line level workflows for config child
1987: -- lines only in case of normal sales order lines, NOT
1988: -- when processing negotiation lines.

Line 2059: ,p_delete => FND_API.G_TRUE

2055:
2056: IF (p_line_tbl(1).booked_flag = 'Y') THEN
2057: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
2058: (p_request_type =>OE_GLOBALS.G_PRICE_ORDER
2059: ,p_delete => FND_API.G_TRUE
2060: ,x_return_status => l_return_status
2061: );
2062: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2063: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2062: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2058: (p_request_type =>OE_GLOBALS.G_PRICE_ORDER
2059: ,p_delete => FND_API.G_TRUE
2060: ,x_return_status => l_return_status
2061: );
2062: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2063: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2064: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2065: RAISE FND_API.G_EXC_ERROR;
2066: END IF;

Line 2063: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2059: ,p_delete => FND_API.G_TRUE
2060: ,x_return_status => l_return_status
2061: );
2062: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2063: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2064: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2065: RAISE FND_API.G_EXC_ERROR;
2066: END IF;
2067: END IF;

Line 2064: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2060: ,x_return_status => l_return_status
2061: );
2062: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2063: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2064: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2065: RAISE FND_API.G_EXC_ERROR;
2066: END IF;
2067: END IF;
2068:

Line 2065: RAISE FND_API.G_EXC_ERROR;

2061: );
2062: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2063: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2064: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2065: RAISE FND_API.G_EXC_ERROR;
2066: END IF;
2067: END IF;
2068:
2069: OE_ORDER_PVT.Process_Requests_And_notify

Line 2359: RAISE FND_API.G_EXC_ERROR ;

2355: FND_MESSAGE.Set_TOKEN
2356: ('MODEL', nvl(l_parent_ordered_item,l_parent_inv_item_id));
2357: FND_MESSAGE.Set_TOKEN('PTYPECODE', l_parent_item_type_code);
2358: OE_MSG_PUB.Add;
2359: RAISE FND_API.G_EXC_ERROR ;
2360: END IF;
2361:
2362: END IF; -- ratio check
2363: END IF; -- options window

Line 2431: WHEN FND_API.G_EXC_ERROR THEN

2427: oe_debug_pub.add('LEAVING CHANGE_COLUMNS IN OE_CONFIG_PVT' , 1 ) ;
2428: END IF;
2429:
2430: EXCEPTION
2431: WHEN FND_API.G_EXC_ERROR THEN
2432: IF l_debug_level > 0 THEN
2433: oe_debug_pub.add('EXC ERROR IN CHANGE_COLUMNS IN OE_CONFIG_PVT' , 1 ) ;
2434: END IF;
2435: RAISE FND_API.G_EXC_ERROR;

Line 2435: RAISE FND_API.G_EXC_ERROR;

2431: WHEN FND_API.G_EXC_ERROR THEN
2432: IF l_debug_level > 0 THEN
2433: oe_debug_pub.add('EXC ERROR IN CHANGE_COLUMNS IN OE_CONFIG_PVT' , 1 ) ;
2434: END IF;
2435: RAISE FND_API.G_EXC_ERROR;
2436:
2437: WHEN OTHERS THEN
2438: IF l_debug_level > 0 THEN
2439: oe_debug_pub.add('ERROR IN CHANGE_COLUMNS IN OE_CONFIG_PVT' , 1 ) ;

Line 2441: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2437: WHEN OTHERS THEN
2438: IF l_debug_level > 0 THEN
2439: oe_debug_pub.add('ERROR IN CHANGE_COLUMNS IN OE_CONFIG_PVT' , 1 ) ;
2440: END IF;
2441: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2442: END Change_Columns;
2443:
2444:
2445: /*----------------------------------------------------------------

Line 2861: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2857: WHEN OTHERS THEN
2858: IF l_debug_level > 0 THEN
2859: oe_debug_pub.add('UNEXPECTED ERROR IN UPDATE ATO_LINE_ID' , 1 ) ;
2860: END IF;
2861: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2862: END;
2863:
2864: ------------------------------------------------------------------
2865:

Line 2963: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2959: oe_debug_pub.add
2960: ('IN UPDATE_ATO_ATTIRBS , AFTER PO: ' || L_RETURN_STATUS , 1 ) ;
2961: END IF;
2962:
2963: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2964: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2965: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2966: RAISE FND_API.G_EXC_ERROR;
2967: END IF;

Line 2964: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2960: ('IN UPDATE_ATO_ATTIRBS , AFTER PO: ' || L_RETURN_STATUS , 1 ) ;
2961: END IF;
2962:
2963: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2964: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2965: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2966: RAISE FND_API.G_EXC_ERROR;
2967: END IF;
2968:

Line 2965: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2961: END IF;
2962:
2963: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2964: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2965: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2966: RAISE FND_API.G_EXC_ERROR;
2967: END IF;
2968:
2969: EXCEPTION

Line 2966: RAISE FND_API.G_EXC_ERROR;

2962:
2963: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2964: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2965: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2966: RAISE FND_API.G_EXC_ERROR;
2967: END IF;
2968:
2969: EXCEPTION
2970: WHEN OTHERS THEN

Line 3023: x_return_status := FND_API.G_RET_STS_ERROR;

3019: OE_Msg_Pub.Add_Text(l_error_message);
3020: IF l_debug_level > 0 THEN
3021: oe_debug_pub.add('ERROR IN DELETE_CONFIG IN OE_CONFIG_PVT' , 1 ) ;
3022: END IF;
3023: x_return_status := FND_API.G_RET_STS_ERROR;
3024: ELSE
3025: x_return_status := FND_API.G_RET_STS_SUCCESS;
3026: END IF;
3027: ELSE

Line 3025: x_return_status := FND_API.G_RET_STS_SUCCESS;

3021: oe_debug_pub.add('ERROR IN DELETE_CONFIG IN OE_CONFIG_PVT' , 1 ) ;
3022: END IF;
3023: x_return_status := FND_API.G_RET_STS_ERROR;
3024: ELSE
3025: x_return_status := FND_API.G_RET_STS_SUCCESS;
3026: END IF;
3027: ELSE
3028: IF l_debug_level > 0 THEN
3029: oe_debug_pub.add('NOTE : NULL CONFIG_HEADER_ID/CONFIG_REV_NBR PASSED');

Line 3117: x_return_status := FND_API.G_RET_STS_ERROR;

3113: OE_Msg_Pub.Add_Text(l_error_message);
3114: IF l_debug_level > 0 THEN
3115: oe_debug_pub.add('ERROR FROM SPC COPY: ' || L_ERROR_MESSAGE , 1 ) ;
3116: END IF;
3117: x_return_status := FND_API.G_RET_STS_ERROR;
3118: RETURN;
3119: END IF;
3120:
3121: ELSE

Line 3136: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3132: ,x_return_status => x_return_status
3133: ,x_msg_count => l_msg_count
3134: ,x_msg_data => l_msg_data);
3135:
3136: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3137: OE_Msg_Pub.Add_Text(l_msg_data);
3138: IF l_debug_level > 0 THEN
3139: oe_debug_pub.add('ERROR FROM SPC NEW COPY: ' || L_MSG_DATA , 1 ) ;
3140: END IF;

Line 3273: x_return_status := FND_API.G_RET_STS_SUCCESS;

3269: IF l_debug_level > 0 THEN
3270: oe_debug_pub.add('NEW CONFIG_HEADER_ID: '|| L_CONFIG_HDR_ID , 5 ) ;
3271: oe_debug_pub.add('NEW CONFIG_REV_NBR: '|| L_CONFIG_REV_NBR , 5 ) ;
3272: END IF;
3273: x_return_status := FND_API.G_RET_STS_SUCCESS;
3274:
3275: IF l_debug_level > 0 THEN
3276: oe_debug_pub.add('LEAVING COPY_CONFIG IN OE_CONFIG_PVT' , 1 ) ;
3277: END IF;

Line 3348: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

3344: x_return_status => x_return_status,
3345: x_msg_count => x_msg_count,
3346: x_msg_data => x_msg_data);
3347:
3348: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
3349:
3350: IF l_hold_result_out = FND_API.G_FALSE AND
3351: (LOWER(p_valid_config) = 'false' OR
3352: LOWER(p_complete_config) = 'false' ) THEN

Line 3350: IF l_hold_result_out = FND_API.G_FALSE AND

3346: x_msg_data => x_msg_data);
3347:
3348: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
3349:
3350: IF l_hold_result_out = FND_API.G_FALSE AND
3351: (LOWER(p_valid_config) = 'false' OR
3352: LOWER(p_complete_config) = 'false' ) THEN
3353:
3354: IF l_debug_level > 0 THEN

Line 3374: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3370: x_return_status => x_return_status,
3371: x_msg_count => x_msg_count,
3372: x_msg_data => x_msg_data );
3373:
3374: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3375: IF l_debug_level > 0 THEN
3376: oe_debug_pub.add('OE_CONFIG_PVT , ERROR IN PUT HOLD' , 1 ) ;
3377: END IF;
3378: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3378: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3374: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3375: IF l_debug_level > 0 THEN
3376: oe_debug_pub.add('OE_CONFIG_PVT , ERROR IN PUT HOLD' , 1 ) ;
3377: END IF;
3378: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3379: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3380: IF l_debug_level > 0 THEN
3381: oe_debug_pub.add('OE_CONFIG_PVT , ERROR IN PUT HOLD' , 1 ) ;
3382: END IF;

Line 3379: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

3375: IF l_debug_level > 0 THEN
3376: oe_debug_pub.add('OE_CONFIG_PVT , ERROR IN PUT HOLD' , 1 ) ;
3377: END IF;
3378: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3379: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3380: IF l_debug_level > 0 THEN
3381: oe_debug_pub.add('OE_CONFIG_PVT , ERROR IN PUT HOLD' , 1 ) ;
3382: END IF;
3383: RAISE FND_API.G_EXC_ERROR;

Line 3383: RAISE FND_API.G_EXC_ERROR;

3379: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3380: IF l_debug_level > 0 THEN
3381: oe_debug_pub.add('OE_CONFIG_PVT , ERROR IN PUT HOLD' , 1 ) ;
3382: END IF;
3383: RAISE FND_API.G_EXC_ERROR;
3384: END IF;
3385:
3386: FND_MESSAGE.Set_Name('ONT', 'OE_VAL_CONFIG_HOLD_INSERT');
3387: FND_MESSAGE.Set_Token('LINE_NUMBER', l_line_number);

Line 3395: IF l_hold_result_out = FND_API.G_TRUE AND

3391: oe_debug_pub.add('AFTER SUCCESSFUL APPLY_HOLDS ON MODEL' , 1 ) ;
3392: END IF;
3393: END IF;
3394:
3395: IF l_hold_result_out = FND_API.G_TRUE AND
3396: (LOWER(p_valid_config) = 'true' AND
3397: LOWER(p_complete_config) = 'true' ) THEN
3398:
3399: IF l_debug_level > 0 THEN

Line 3419: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3415: x_return_status => x_return_status,
3416: x_msg_count => x_msg_count,
3417: x_msg_data => x_msg_data );
3418:
3419: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3420: IF l_debug_level > 0 THEN
3421: oe_debug_pub.add('OE_CONFIG_PVT , ERROR IN RELEASING HOLD',1);
3422: END IF;
3423: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3423: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3419: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3420: IF l_debug_level > 0 THEN
3421: oe_debug_pub.add('OE_CONFIG_PVT , ERROR IN RELEASING HOLD',1);
3422: END IF;
3423: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3424: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3425: IF l_debug_level > 0 THEN
3426: oe_debug_pub.add('OE_CONFIG_PVT ,ERROR IN RELEASING HOLD' ,1);
3427: END IF;

Line 3424: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

3420: IF l_debug_level > 0 THEN
3421: oe_debug_pub.add('OE_CONFIG_PVT , ERROR IN RELEASING HOLD',1);
3422: END IF;
3423: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3424: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3425: IF l_debug_level > 0 THEN
3426: oe_debug_pub.add('OE_CONFIG_PVT ,ERROR IN RELEASING HOLD' ,1);
3427: END IF;
3428: RAISE FND_API.G_EXC_ERROR;

Line 3428: RAISE FND_API.G_EXC_ERROR;

3424: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3425: IF l_debug_level > 0 THEN
3426: oe_debug_pub.add('OE_CONFIG_PVT ,ERROR IN RELEASING HOLD' ,1);
3427: END IF;
3428: RAISE FND_API.G_EXC_ERROR;
3429: END IF;
3430:
3431: FND_MESSAGE.Set_Name('ONT', 'OE_VAL_CONFIG_HOLD_REMOVE');
3432: FND_MESSAGE.Set_Token('LINE_NUMBER', l_line_number);

Line 3441: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3437: END IF;
3438: END IF;
3439:
3440: ELSE -- ret status error
3441: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3442: IF l_debug_level > 0 THEN
3443: oe_debug_pub.add('OE_CONFIG_PVT , ERROR IN CHECK HOLD' , 1 ) ;
3444: END IF;
3445: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3445: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3441: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3442: IF l_debug_level > 0 THEN
3443: oe_debug_pub.add('OE_CONFIG_PVT , ERROR IN CHECK HOLD' , 1 ) ;
3444: END IF;
3445: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3446:
3447: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3448: IF l_debug_level > 0 THEN
3449: oe_debug_pub.add('OE_CONFIG_PVT , ERROR IN CHECK HOLD' , 1 ) ;

Line 3447: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

3443: oe_debug_pub.add('OE_CONFIG_PVT , ERROR IN CHECK HOLD' , 1 ) ;
3444: END IF;
3445: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3446:
3447: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3448: IF l_debug_level > 0 THEN
3449: oe_debug_pub.add('OE_CONFIG_PVT , ERROR IN CHECK HOLD' , 1 ) ;
3450: END IF;
3451: RAISE FND_API.G_EXC_ERROR;

Line 3451: RAISE FND_API.G_EXC_ERROR;

3447: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3448: IF l_debug_level > 0 THEN
3449: oe_debug_pub.add('OE_CONFIG_PVT , ERROR IN CHECK HOLD' , 1 ) ;
3450: END IF;
3451: RAISE FND_API.G_EXC_ERROR;
3452: END IF;
3453: END IF; -- check holds ret status check.
3454:
3455: Print_Time('leaving put_hold_and_release_hold');

Line 3504: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;

3500: l_old_behavior VARCHAR2(1);
3501: l_error_code NUMBER;
3502: l_msg_count NUMBER;
3503: l_msg_data VARCHAR2(2000);
3504: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
3505: --
3506: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3507: --
3508: BEGIN

Line 3524: RAISE FND_API.G_EXC_ERROR;

3520: ,x_config_effective_date => l_rev_date
3521: ,x_frozen_model_bill => l_frozen_model_bill);
3522:
3523: IF l_rev_date is NULL THEN
3524: RAISE FND_API.G_EXC_ERROR;
3525: END IF;
3526:
3527: x_config_effective_date := l_rev_date;
3528: x_frozen_model_bill := l_frozen_model_bill;

Line 3539: l_rev_date = FND_API.G_MISS_DATE THEN

3535:
3536: l_rev_date := p_model_line_rec.creation_date;
3537:
3538: IF l_rev_date is NULL OR
3539: l_rev_date = FND_API.G_MISS_DATE THEN
3540: l_rev_date := sysdate;
3541: END IF;
3542:
3543: END IF;

Line 3573: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3569: oe_debug_pub.add('AFTER CALL TO EXPLOSION , RETURN STATUS: '
3570: || L_RETURN_STATUS , 1 ) ;
3571: END IF;
3572:
3573: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3574: x_return_status := l_return_status;
3575: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3576: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3577: x_return_status := l_return_status;

Line 3575: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3571: END IF;
3572:
3573: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3574: x_return_status := l_return_status;
3575: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3576: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3577: x_return_status := l_return_status;
3578: RAISE FND_API.G_EXC_ERROR;
3579: END IF;

Line 3576: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3572:
3573: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3574: x_return_status := l_return_status;
3575: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3576: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3577: x_return_status := l_return_status;
3578: RAISE FND_API.G_EXC_ERROR;
3579: END IF;
3580:

Line 3578: RAISE FND_API.G_EXC_ERROR;

3574: x_return_status := l_return_status;
3575: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3576: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3577: x_return_status := l_return_status;
3578: RAISE FND_API.G_EXC_ERROR;
3579: END IF;
3580:
3581: IF p_model_line_rec.component_sequence_id is null OR
3582: p_model_line_rec.component_sequence_id = FND_API.G_MISS_NUM

Line 3582: p_model_line_rec.component_sequence_id = FND_API.G_MISS_NUM

3578: RAISE FND_API.G_EXC_ERROR;
3579: END IF;
3580:
3581: IF p_model_line_rec.component_sequence_id is null OR
3582: p_model_line_rec.component_sequence_id = FND_API.G_MISS_NUM
3583: THEN
3584:
3585: BEGIN
3586: SELECT bill_sequence_id

Line 3605: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3601: WHEN NO_DATA_FOUND THEN
3602: IF l_debug_level > 0 THEN
3603: oe_debug_pub.add('EXPLODE_BILL , BILL_SEQ QUERY FAILED' , 1 ) ;
3604: END IF;
3605: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3606: END;
3607:
3608: IF l_debug_level > 0 THEN
3609: oe_debug_pub.add('TOP_BILL_SEQ_ID SELECTED FROM BOM_bill_of_mat' ) ;

Line 3684: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

3680: l_line_rec OE_Order_Pub.Line_Rec_Type
3681: := OE_Order_Pub.G_Miss_Line_Rec;
3682: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
3683: l_control_rec OE_GLOBALS.Control_Rec_Type;
3684: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3685:
3686:
3687: CURSOR inc_items(p_link_to_line_id NUMBER,
3688: p_top_model_line_id NUMBER)

Line 3727: IF OE_MODIFY_INC_ITEMS_TBL(I).param2 <> FND_API.G_MISS_NUM THEN

3723: l_line_rec.operation := OE_MODIFY_INC_ITEMS_TBL(I).param10;
3724:
3725: -- 1. ordered_quantity.
3726:
3727: IF OE_MODIFY_INC_ITEMS_TBL(I).param2 <> FND_API.G_MISS_NUM THEN
3728:
3729: -- old ordered qty of parent can not be 0, so no divide by 0.
3730: --bug3993709
3731: l_line_rec.ordered_quantity :=

Line 3742: IF nvl(OE_MODIFY_INC_ITEMS_TBL(I).param5, -1) <> FND_API.G_MISS_NUM THEN

3738:
3739:
3740: -- 2. project and task.
3741:
3742: IF nvl(OE_MODIFY_INC_ITEMS_TBL(I).param5, -1) <> FND_API.G_MISS_NUM THEN
3743: l_line_rec.project_id := OE_MODIFY_INC_ITEMS_TBL(I).param5;
3744: END IF; -- project.
3745:
3746: IF nvl(OE_MODIFY_INC_ITEMS_TBL(I).param6, -1) <> FND_API.G_MISS_NUM THEN

Line 3746: IF nvl(OE_MODIFY_INC_ITEMS_TBL(I).param6, -1) <> FND_API.G_MISS_NUM THEN

3742: IF nvl(OE_MODIFY_INC_ITEMS_TBL(I).param5, -1) <> FND_API.G_MISS_NUM THEN
3743: l_line_rec.project_id := OE_MODIFY_INC_ITEMS_TBL(I).param5;
3744: END IF; -- project.
3745:
3746: IF nvl(OE_MODIFY_INC_ITEMS_TBL(I).param6, -1) <> FND_API.G_MISS_NUM THEN
3747: l_line_rec.task_id := OE_MODIFY_INC_ITEMS_TBL(I).param6;
3748: END IF; -- task.
3749:
3750:

Line 3753: IF nvl(OE_MODIFY_INC_ITEMS_TBL(I).param7, -1) <> FND_API.G_MISS_NUM THEN

3749:
3750:
3751: -- 3. ship_tolerance_above and below
3752:
3753: IF nvl(OE_MODIFY_INC_ITEMS_TBL(I).param7, -1) <> FND_API.G_MISS_NUM THEN
3754: l_line_rec.ship_tolerance_above := OE_MODIFY_INC_ITEMS_TBL(I).param7;
3755: END IF; -- ship_tolerance_above.
3756:
3757: IF nvl(OE_MODIFY_INC_ITEMS_TBL(I).param8, -1) <> FND_API.G_MISS_NUM THEN

Line 3757: IF nvl(OE_MODIFY_INC_ITEMS_TBL(I).param8, -1) <> FND_API.G_MISS_NUM THEN

3753: IF nvl(OE_MODIFY_INC_ITEMS_TBL(I).param7, -1) <> FND_API.G_MISS_NUM THEN
3754: l_line_rec.ship_tolerance_above := OE_MODIFY_INC_ITEMS_TBL(I).param7;
3755: END IF; -- ship_tolerance_above.
3756:
3757: IF nvl(OE_MODIFY_INC_ITEMS_TBL(I).param8, -1) <> FND_API.G_MISS_NUM THEN
3758: l_line_rec.ship_tolerance_below := OE_MODIFY_INC_ITEMS_TBL(I).param8;
3759: END IF; -- ship_tolerance_below.
3760:
3761:

Line 3764: IF nvl(OE_MODIFY_INC_ITEMS_TBL(I).param9, -1) <> FND_API.G_MISS_NUM THEN

3760:
3761:
3762: -- 4. ship_to and request_date
3763:
3764: IF nvl(OE_MODIFY_INC_ITEMS_TBL(I).param9, -1) <> FND_API.G_MISS_NUM THEN
3765: l_line_rec.ship_to_org_id := OE_MODIFY_INC_ITEMS_TBL(I).param9;
3766: END IF; -- ship_to_org_id.
3767:
3768: IF nvl(OE_MODIFY_INC_ITEMS_TBL(I).date_param1, sysdate)

Line 3769: <> FND_API.G_MISS_DATE THEN

3765: l_line_rec.ship_to_org_id := OE_MODIFY_INC_ITEMS_TBL(I).param9;
3766: END IF; -- ship_to_org_id.
3767:
3768: IF nvl(OE_MODIFY_INC_ITEMS_TBL(I).date_param1, sysdate)
3769: <> FND_API.G_MISS_DATE THEN
3770: l_line_rec.request_date := OE_MODIFY_INC_ITEMS_TBL(I).date_param1;
3771: END IF; -- request_date.
3772:
3773:

Line 3817: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3813: WHEN OTHERS THEN
3814: IF l_debug_level > 0 THEN
3815: oe_debug_pub.add('EXCEPTION IN MODIFY_INCLUDED_ITEMS'|| SQLERRM , 1 ) ;
3816: END IF;
3817: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3818: RAISE;
3819: END;
3820:
3821:

Line 3846: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

3842: l_code VARCHAR2(1000);
3843: l_index NUMBER;
3844: l_current_qty NUMBER;
3845: l_inventory_item_id NUMBER;
3846: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3847:
3848: CURSOR included_items IS
3849: SELECT line_id, component_code, link_to_line_id, ordered_quantity
3850: FROM oe_order_lines

Line 3973: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3969: IF l_debug_level > 0 THEN
3970: oe_debug_pub.add('EXCEPTION IN INCLUDED_ITEMS_DML'|| SQLERRM , 1 ) ;
3971: END IF;
3972:
3973: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3974: RAISE;
3975: END Included_Items_DML;
3976:
3977:

Line 4023: x_return_status :=FND_API.G_RET_STS_ERROR;

4019: OE_Msg_Pub.Add_Text(l_error_message);
4020: IF l_debug_level > 0 THEN
4021: oe_debug_pub.add('ERROR FROM SPC COPY: ' || L_ERROR_MESSAGE , 1 ) ;
4022: END IF;
4023: x_return_status :=FND_API.G_RET_STS_ERROR;
4024:
4025: ELSE
4026: IF l_debug_level > 0 THEN
4027: oe_debug_pub.add('NEW CONFIG_HEADER_ID: '|| L_CONFIG_HDR_ID , 1 ) ;

Line 4034: x_return_status := FND_API.G_RET_STS_SUCCESS;

4030: oe_debug_pub.add('NEW CONFIG_REV_NBR: '|| L_CONFIG_REV_NBR , 1 ) ;
4031: END IF;
4032: x_config_hdr_id := l_config_hdr_id;
4033: x_config_rev_nbr := l_config_rev_nbr;
4034: x_return_status := FND_API.G_RET_STS_SUCCESS;
4035: END IF;
4036:
4037: ELSE
4038: IF l_debug_level > 0 THEN

Line 4093: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4089: ( p_line_rec => x_line_rec
4090: ,x_result => l_sec_result
4091: ,x_return_status => l_return_status);
4092:
4093: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4094: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4095: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4096: RAISE FND_API.G_EXC_ERROR;
4097: END IF;

Line 4094: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4090: ,x_result => l_sec_result
4091: ,x_return_status => l_return_status);
4092:
4093: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4094: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4095: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4096: RAISE FND_API.G_EXC_ERROR;
4097: END IF;
4098:

Line 4095: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

4091: ,x_return_status => l_return_status);
4092:
4093: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4094: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4095: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4096: RAISE FND_API.G_EXC_ERROR;
4097: END IF;
4098:
4099: l_msg_count2 := OE_Msg_Pub.Count_Msg;

Line 4096: RAISE FND_API.G_EXC_ERROR;

4092:
4093: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4094: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4095: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4096: RAISE FND_API.G_EXC_ERROR;
4097: END IF;
4098:
4099: l_msg_count2 := OE_Msg_Pub.Count_Msg;
4100: