APPS.OE_SERVICE_UTIL dependencies on FND_API

Line 4: G_ASO_STATUS VARCHAR2(1) := FND_API.G_MISS_CHAR;

1: Package body OE_SERVICE_UTIL As
2: /* $Header: OEXUSVCB.pls 120.9.12010000.2 2008/11/14 11:28:28 smanian ship $ */
3:
4: G_ASO_STATUS VARCHAR2(1) := FND_API.G_MISS_CHAR;
5: G_OKC_STATUS VARCHAR2(1) := FND_API.G_MISS_CHAR;
6:
7: g_customer_id number := NULL; -- 2225343
8:

Line 5: G_OKC_STATUS VARCHAR2(1) := FND_API.G_MISS_CHAR;

1: Package body OE_SERVICE_UTIL As
2: /* $Header: OEXUSVCB.pls 120.9.12010000.2 2008/11/14 11:28:28 smanian ship $ */
3:
4: G_ASO_STATUS VARCHAR2(1) := FND_API.G_MISS_CHAR;
5: G_OKC_STATUS VARCHAR2(1) := FND_API.G_MISS_CHAR;
6:
7: g_customer_id number := NULL; -- 2225343
8:
9: Function Get_Product_Status(p_application_id NUMBER)

Line 20: AND G_ASO_STATUS = FND_API.G_MISS_CHAR)

16: --
17: BEGIN
18:
19: if (p_application_id = 697
20: AND G_ASO_STATUS = FND_API.G_MISS_CHAR)
21: or ( p_application_id = 515
22: AND G_OKC_STATUS = FND_API.G_MISS_CHAR)
23: then
24: IF l_debug_level > 0 THEN

Line 22: AND G_OKC_STATUS = FND_API.G_MISS_CHAR)

18:
19: if (p_application_id = 697
20: AND G_ASO_STATUS = FND_API.G_MISS_CHAR)
21: or ( p_application_id = 515
22: AND G_OKC_STATUS = FND_API.G_MISS_CHAR)
23: then
24: IF l_debug_level > 0 THEN
25: oe_debug_pub.add( 'GET PROD. STATUS' ) ;
26: END IF;

Line 54: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

50: END Get_Product_Status;
51:
52: Procedure Notify_OC
53: ( p_api_version_number IN NUMBER
54: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
55: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
56: , p_control_rec IN OE_GLOBALS.Control_Rec_Type :=
57: OE_GLOBALS.G_MISS_CONTROL_REC
58: , x_return_status OUT NOCOPY VARCHAR2

Line 55: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

51:
52: Procedure Notify_OC
53: ( p_api_version_number IN NUMBER
54: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
55: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
56: , p_control_rec IN OE_GLOBALS.Control_Rec_Type :=
57: OE_GLOBALS.G_MISS_CONTROL_REC
58: , x_return_status OUT NOCOPY VARCHAR2
59:

Line 152: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

148:
149: -- Commenting out the call to check proc for performance improvement
150: /*
151: OE_SERVICE_UTIL.CHECK_PROC('ASO_ORDER_FEEDBACK_PUB.UPDATE_NOTICE', l_return_status);
152: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
153: */
154:
155: /* The application id for Order Capture is 697 */
156:

Line 315: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

311: IF l_debug_level > 0 THEN
312: oe_debug_pub.add( 'CSS: OC RETURN STATUS IS: ' || L_RETURN_STATUS ) ;
313: END IF;
314:
315: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
316: IF l_debug_level > 0 THEN
317: oe_debug_pub.add( 'NOTIFY_OC API - UNEXPECTED ERROR' ) ;
318: END IF;
319: IF l_debug_level > 0 THEN

Line 326: RAISE FND_API.G_EXC_ERROR;

322: Retrieve_OC_Messages;
323: /* OE_DEBUG_PUB.ADD('Notify OC error msg is: ' || substr(x_msg_data, 1,200)); */
324: -- For bug 3574480. Modified unepected error to expected error to
325: -- support orders of this kind to be rebooked.
326: RAISE FND_API.G_EXC_ERROR;
327: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
328: IF l_debug_level > 0 THEN
329: oe_debug_pub.add( 'NOTIFY_OC API - ERROR' ) ;
330: END IF;

Line 327: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

323: /* OE_DEBUG_PUB.ADD('Notify OC error msg is: ' || substr(x_msg_data, 1,200)); */
324: -- For bug 3574480. Modified unepected error to expected error to
325: -- support orders of this kind to be rebooked.
326: RAISE FND_API.G_EXC_ERROR;
327: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
328: IF l_debug_level > 0 THEN
329: oe_debug_pub.add( 'NOTIFY_OC API - ERROR' ) ;
330: END IF;
331: IF l_debug_level > 0 THEN

Line 342: --RAISE FND_API.G_EXC_ERROR;

338: IF l_debug_level > 0 THEN
339: oe_debug_pub.add( L_BUFFER , 1 ) ;
340: END IF;*/
341: Retrieve_OC_Messages;
342: --RAISE FND_API.G_EXC_ERROR;
343: END IF;
344:
345: END IF;
346:

Line 353: WHEN FND_API.G_EXC_ERROR THEN

349:
350: EXCEPTION
351:
352:
353: WHEN FND_API.G_EXC_ERROR THEN
354:
355: x_return_status := FND_API.G_RET_STS_ERROR;
356: -- For bug 3574480. Modified unexpected errors also to return normal error
357: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 355: x_return_status := FND_API.G_RET_STS_ERROR;

351:
352:
353: WHEN FND_API.G_EXC_ERROR THEN
354:
355: x_return_status := FND_API.G_RET_STS_ERROR;
356: -- For bug 3574480. Modified unexpected errors also to return normal error
357: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
358:
359: x_return_status := FND_API.G_RET_STS_ERROR;

Line 357: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

353: WHEN FND_API.G_EXC_ERROR THEN
354:
355: x_return_status := FND_API.G_RET_STS_ERROR;
356: -- For bug 3574480. Modified unexpected errors also to return normal error
357: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
358:
359: x_return_status := FND_API.G_RET_STS_ERROR;
360:
361: WHEN OTHERS THEN

Line 359: x_return_status := FND_API.G_RET_STS_ERROR;

355: x_return_status := FND_API.G_RET_STS_ERROR;
356: -- For bug 3574480. Modified unexpected errors also to return normal error
357: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
358:
359: x_return_status := FND_API.G_RET_STS_ERROR;
360:
361: WHEN OTHERS THEN
362:
363: x_return_status := FND_API.G_RET_STS_ERROR;

Line 363: x_return_status := FND_API.G_RET_STS_ERROR;

359: x_return_status := FND_API.G_RET_STS_ERROR;
360:
361: WHEN OTHERS THEN
362:
363: x_return_status := FND_API.G_RET_STS_ERROR;
364:
365: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
366: THEN
367: OE_MSG_PUB.Add_Exc_Msg

Line 372: RAISE FND_API.G_EXC_ERROR;

368: ( G_PKG_NAME
369: , 'NOTIFY_OC'
370: );
371: END IF;
372: RAISE FND_API.G_EXC_ERROR;
373:
374: END NOTIFY_OC;
375:
376: -- Procedure to Check for the availability of the CRM APIS

Line 426: x_return_status := FND_API.G_RET_STS_SUCCESS;

422: l_scale,
423: l_radix,
424: l_spare
425: );
426: x_return_status := FND_API.G_RET_STS_SUCCESS;
427: EXCEPTION
428: WHEN OTHERS THEN
429: x_return_status := FND_API.G_RET_STS_ERROR;
430: END;

Line 429: x_return_status := FND_API.G_RET_STS_ERROR;

425: );
426: x_return_status := FND_API.G_RET_STS_SUCCESS;
427: EXCEPTION
428: WHEN OTHERS THEN
429: x_return_status := FND_API.G_RET_STS_ERROR;
430: END;
431: IF l_debug_level > 0 THEN
432: oe_debug_pub.add( 'EXITING CHECK_PROC API' ) ;
433: END IF;

Line 492: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

488: , OUT l_msg_data
489: , OUT l_return_status
490: , OUT l_start_date
491: , OUT l_end_date;
492: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
493: IF l_debug_level > 0 THEN
494: oe_debug_pub.add( 'OKS_OMINT_PUB.GET_SVC_SDATE SUCCESSFUL' ) ;
495: END IF;
496: IF l_debug_level > 0 THEN

Line 521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

517: WHEN OTHERS THEN
518: IF l_debug_level > 0 THEN
519: oe_debug_pub.add('Unexpected error calling OKS_OMINT_PUB.GET_SVC_SDATE:');
520: oe_debug_pub.add(sqlerrm);
521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
522: RETURN;
523: END IF;
524: END; -- to recover from any unexpected errors
525:

Line 589: /* IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN */

585: END IF;
586: IF l_debug_level > 0 THEN
587: oe_debug_pub.add( 'JPN: SERVICE PERIOD PASSED IS ' || P_X_LINE_REC.SERVICE_PERIOD ) ;
588: END IF;
589: /* IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN */
590:
591: -- IF Get_Product_Status(515) IN ('I','S') THEN
592:
593: -- lkxu, for bug 1701377

Line 655: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

651: END IF;
652: IF l_debug_level > 0 THEN
653: oe_debug_pub.add( 'SERVICE_PERIOD ==> ' || L_SERVICE_PERIOD ) ;
654: END IF;
655: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
656: IF l_debug_level > 0 THEN
657: oe_debug_pub.add( 'OKS_OMINT_PUB.GET_DURATION RETURN SUCCESS' ) ;
658: END IF;
659: IF l_debug_level > 0 THEN

Line 680: --x_return_status := FND_API.G_RET_STS_ERROR;

676: IF l_return_status is NULL THEN
677: IF l_debug_level > 0 THEN
678: oe_debug_pub.add( 'OKS_OMINT_PUB.GET_DURATION NOT RETURNED VALUE' ) ;
679: END IF;
680: --x_return_status := FND_API.G_RET_STS_ERROR;
681: END IF;
682: IF l_debug_level > 0 THEN
683: oe_debug_pub.add( 'EXITING GET_SERVICE_DURATION' ) ;
684: END IF;

Line 689: --x_return_status := FND_API.G_RET_STS_ERROR;

685: ELSE
686: IF l_debug_level > 0 THEN
687: oe_debug_pub.add( 'OKS_OMINT_PUB.GET_DURATION NOT EXISTS' ) ;
688: END IF;
689: --x_return_status := FND_API.G_RET_STS_ERROR;
690: END IF;
691: END Get_Service_Duration;
692:
693:

Line 769: -- x_return_status := FND_API.G_RET_STS_ERROR;

765: OE_Order_Util.Get_Attribute_Name('service_reference_type_code'));
766: OE_MSG_PUB.Add;
767: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
768: END IF;
769: -- x_return_status := FND_API.G_RET_STS_ERROR;
770: ELSIF (p_x_line_rec.service_reference_type_code = 'ORDER') THEN
771:
772: -- put code for the checking of valid service item
773: -- first use IS_SERVICE_AVAILABLE API to confirm that the enter

Line 961: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN */

957:
958: -- IF OKS_OMINT_PUB.IS_SERVICE_AVAILABLE exists in DB
959: -- Then Call it Else Not
960: /* OE_SERVICE_UTIL.CHECK_PROC('OKS_OMINT_PUB.IS_SERVICE_AVAILABLE', l_return_status);
961: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN */
962:
963: -- IF Get_Product_Status(515) IN ('I','S') THEN
964:
965: -- lkxu, for bug 1701377

Line 1047: IF l_available_yn = 'N' OR l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1043: oe_debug_pub.add( 'AFTER CALL TO SERVICE AVAILABLE API' ) ;
1044: END IF;
1045:
1046: /* OR added for 2282076 */
1047: IF l_available_yn = 'N' OR l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1048: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
1049: OE_MSG_PUB.Update_Msg_Context(p_attribute_code =>'ORDERED_ITEM');
1050: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SERV_ITEM');
1051: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

Line 1056: x_return_status := FND_API.G_RET_STS_ERROR;

1052: OE_Order_Util.Get_Attribute_Name('ordered_item'));
1053: OE_MSG_PUB.Add;
1054: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1055: END IF;
1056: x_return_status := FND_API.G_RET_STS_ERROR;
1057: return; /* comment on the return statement removed as part of 2271749, though not required to fix that bug */
1058: END IF; -- Should be a valid service item
1059:
1060: END IF;

Line 1075: x_return_status := FND_API.G_RET_STS_ERROR;

1071: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SERV_ITEM_QTY');
1072: OE_MSG_PUB.Add;
1073: /* Fix for the bug 2431953 / 2749740
1074: ELSIF OE_LINE_UTIL.G_ORDERED_QTY_CHANGE = TRUE THEN
1075: x_return_status := FND_API.G_RET_STS_ERROR;
1076: Fix ends */
1077: END IF;
1078: --x_return_status := FND_API.G_RET_STS_ERROR;
1079: -- Make the service quantity same as product quantity

Line 1078: --x_return_status := FND_API.G_RET_STS_ERROR;

1074: ELSIF OE_LINE_UTIL.G_ORDERED_QTY_CHANGE = TRUE THEN
1075: x_return_status := FND_API.G_RET_STS_ERROR;
1076: Fix ends */
1077: END IF;
1078: --x_return_status := FND_API.G_RET_STS_ERROR;
1079: -- Make the service quantity same as product quantity
1080: p_x_line_rec.ordered_quantity := Nvl (l_fulfilled_quantity,l_service_qty); --5699215
1081: /* for bug 2068001 */
1082: -- return;

Line 1223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1219: ( 'G_PKG_NAME' ,
1220: 'Get_Service_Attribute'
1221: );
1222: END IF;
1223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1224:
1225: END;
1226:
1227: ELSIF (p_x_line_rec.service_reference_type_code = 'CUSTOMER_PRODUCT') THEN

Line 1314: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN */

1310:
1311: -- IF OKS_OMINT_PUB.IS_SERVICE_AVAILABLE exists in DB
1312: -- Then Call it Else Not
1313: /* OE_SERVICE_UTIL.CHECK_PROC('OKS_OMINT_PUB.IS_SERVICE_AVAILABLE', l_return_status);
1314: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN */
1315:
1316: -- IF Get_Product_Status(515) IN ('I','S') THEN
1317:
1318: -- lkxu, for bug 1701377

Line 1396: IF l_available_yn = 'N' OR l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1392: oe_debug_pub.add( 'AFTER EXECUTE IMMEDIATE FOR CUST-IS_SERVICE_AVAIL' ) ;
1393: END IF;
1394:
1395: /* OR added for 2282076 */
1396: IF l_available_yn = 'N' OR l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1397: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
1398: OE_MSG_PUB.Update_Msg_Context(p_attribute_code =>'ORDERED_ITEM');
1399: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SERV_ITEM');
1400: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

Line 1405: x_return_status := FND_API.G_RET_STS_ERROR; /* status set to ERROR for 2271749 */

1401: OE_Order_Util.Get_Attribute_Name('ordered_item'));
1402: OE_MSG_PUB.Add;
1403: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1404: END IF;
1405: x_return_status := FND_API.G_RET_STS_ERROR; /* status set to ERROR for 2271749 */
1406: return;
1407: END IF; -- Should be a valid service item
1408:
1409: END IF;

Line 1427: -- x_return_status := FND_API.G_RET_STS_ERROR;

1423: OE_Order_Util.Get_Attribute_Name('ordered_quantity'));
1424: OE_MSG_PUB.Add;
1425: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1426: END IF;
1427: -- x_return_status := FND_API.G_RET_STS_ERROR;
1428: --p_x_line_rec.ordered_quantity := l_service_qty; -- moved in front of RETURN with, but unrelated to, 1720185
1429: p_x_line_rec.ordered_quantity := Nvl (l_fulfilled_quantity,l_service_qty); --5699215
1430: return;
1431: END IF; -- Invalid Service Quantity => Should be equal to Order QTY

Line 1435: -- x_return_status := FND_API.G_RET_STS_SUCCESS;

1431: END IF; -- Invalid Service Quantity => Should be equal to Order QTY
1432:
1433: p_x_line_rec.service_number := 1;
1434: p_x_line_rec.ordered_quantity := Nvl (l_fulfilled_quantity,l_service_qty); --5699215
1435: -- x_return_status := FND_API.G_RET_STS_SUCCESS;
1436: IF l_debug_level > 0 THEN
1437: oe_debug_pub.add( 'EXITING GET_SERVICE_ATTRIBUTE' ) ;
1438: END IF;
1439: /* ELSIF (p_x_line_rec.service_reference_type_code is NULL) OR

Line 1440: (p_x_line_rec.service_reference_type_code = FND_API.G_MISS_CHAR) THEN

1436: IF l_debug_level > 0 THEN
1437: oe_debug_pub.add( 'EXITING GET_SERVICE_ATTRIBUTE' ) ;
1438: END IF;
1439: /* ELSIF (p_x_line_rec.service_reference_type_code is NULL) OR
1440: (p_x_line_rec.service_reference_type_code = FND_API.G_MISS_CHAR) THEN
1441: OE_DEBUG_PUB.ADD('IN Get_Service_Attribute - where code is NULL');
1442: NULL; */
1443: ELSE
1444: OE_MSG_PUB.Add_Exc_Msg( 'G_PKG_NAME',

Line 1446: -- x_return_status := FND_API.G_RET_STS_ERROR;

1442: NULL; */
1443: ELSE
1444: OE_MSG_PUB.Add_Exc_Msg( 'G_PKG_NAME',
1445: 'Get_Service_Attribute - Invalid Context');
1446: -- x_return_status := FND_API.G_RET_STS_ERROR;
1447: IF l_debug_level > 0 THEN
1448: oe_debug_pub.add( 'EXITING GET_SERVICE_ATTRIBUTE' ) ;
1449: END IF;
1450: END IF;

Line 1489: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN */

1485: END IF;
1486:
1487: x_line_rec := p_line_rec;
1488: /* OE_SERVICE_UTIL.CHECK_PROC('OKS_OMINT_PUB.GET_DURATION', l_return_status);
1489: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN */
1490:
1491: -- IF Get_Product_Status(515) IN ('I','S') THEN
1492:
1493: -- lkxu, for bug 1701377

Line 1543: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

1539:
1540: , OUT l_new_end_date;
1541:
1542:
1543: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1544: x_line_rec.service_end_date := l_new_end_date;
1545: x_line_rec.service_duration := l_service_duration;
1546: x_line_rec.service_period := l_service_period;
1547: END IF;

Line 1553: --x_return_status := FND_API.G_RET_STS_ERROR;

1549: IF l_return_status is NULL THEN
1550: IF l_debug_level > 0 THEN
1551: oe_debug_pub.add( 'OKS_OMINT_PUB.GET_DURATION NOT RETURNED VALUE' ) ;
1552: END IF;
1553: --x_return_status := FND_API.G_RET_STS_ERROR;
1554: END IF;
1555: IF l_debug_level > 0 THEN
1556: oe_debug_pub.add( 'EXITING GET_SERVICE_DURATION' ) ;
1557: END IF;

Line 1562: --x_return_status := FND_API.G_RET_STS_ERROR;

1558: ELSE
1559: IF l_debug_level > 0 THEN
1560: oe_debug_pub.add( 'OKS_OMINT_PUB.GET_DURATION NOT EXISTS' ) ;
1561: END IF;
1562: --x_return_status := FND_API.G_RET_STS_ERROR;
1563: END IF;
1564: END Get_Service_Duration;
1565:
1566:

Line 1619: x_return_status := FND_API.G_RET_STS_ERROR;

1615: OE_Order_Util.Get_Attribute_Name('service_reference_type_code'));
1616: OE_MSG_PUB.Add;
1617: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1618: END IF;
1619: x_return_status := FND_API.G_RET_STS_ERROR;
1620: ELSIF (p_line_rec.service_reference_type_code = 'ORDER') THEN
1621:
1622: -- put code for the checking of valid service item
1623: -- first use IS_SERVICE_AVAILABLE API to confirm that the enter

Line 1661: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN */

1657:
1658: -- IF OKS_OMINT_PUB.IS_SERVICE_AVAILABLE exists in DB
1659: -- Then Call it Else Not
1660: /* OE_SERVICE_UTIL.CHECK_PROC('OKS_OMINT_PUB.IS_SERVICE_AVAILABLE', l_return_status);
1661: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN */
1662:
1663: -- IF Get_Product_Status(515) IN ('I','S') THEN
1664:
1665: -- lkxu, for bug 1701377

Line 1735: IF l_available_yn = 'N' OR l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1731: oe_debug_pub.add( 'AVAILABLE/RET.STATUS:' || L_AVAILABLE_YN||'/'||L_RETURN_STATUS , 5 ) ;
1732: END IF;
1733:
1734: /* OR added for 2282076 */
1735: IF l_available_yn = 'N' OR l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1736: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
1737: OE_MSG_PUB.Update_Msg_Context(p_attribute_code =>'ORDERED_ITEM');
1738: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SERV_ITEM');
1739: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

Line 1744: x_return_status := FND_API.G_RET_STS_ERROR;

1740: OE_Order_Util.Get_Attribute_Name('ordered_item'));
1741: OE_MSG_PUB.Add;
1742: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1743: END IF;
1744: x_return_status := FND_API.G_RET_STS_ERROR;
1745: return;
1746: END IF; -- Should be a valid service item
1747:
1748: END IF;

Line 1760: x_return_status := FND_API.G_RET_STS_ERROR;

1756: OE_Order_Util.Get_Attribute_Name('ordered_quantity'));
1757: OE_MSG_PUB.Add;
1758: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1759: END IF;
1760: x_return_status := FND_API.G_RET_STS_ERROR;
1761: return;
1762: END IF; -- Invalid Service Quantity => Should be equal to Order QTY
1763:
1764: IF l_header_id = p_line_rec.header_id THEN

Line 1824: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1820: 'Get_Service_Attribute'
1821: );
1822: END IF;
1823:
1824: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1825:
1826: END;
1827:
1828: ELSIF (p_line_rec.service_reference_type_code = 'CUSTOMER_PRODUCT') THEN

Line 1856: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN */

1852:
1853: -- IF OKS_OMINT_PUB.IS_SERVICE_AVAILABLE exists in DB
1854: -- Then Call it Else Not
1855: /* OE_SERVICE_UTIL.CHECK_PROC('OKS_OMINT_PUB.IS_SERVICE_AVAILABLE', l_return_status);
1856: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN */
1857:
1858: -- IF Get_Product_Status(515) IN ('I','S') THEN
1859:
1860: -- lkxu, for bug 1701377

Line 1928: IF l_available_yn = 'N' OR l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1924: oe_debug_pub.add( 'AVAILABLE/RET.STATUS:' || L_AVAILABLE_YN||'/'||L_RETURN_STATUS , 5 ) ;
1925: END IF;
1926:
1927: /* OR added for 2282076 */
1928: IF l_available_yn = 'N' OR l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1929: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
1930: OE_MSG_PUB.Update_Msg_Context(p_attribute_code =>'ORDERED_ITEM');
1931: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SERV_ITEM');
1932: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

Line 1937: x_return_status := FND_API.G_RET_STS_ERROR;

1933: OE_Order_Util.Get_Attribute_Name('ordered_item'));
1934: OE_MSG_PUB.Add;
1935: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1936: END IF;
1937: x_return_status := FND_API.G_RET_STS_ERROR;
1938: return;
1939: END IF; -- Should be a valid service item
1940:
1941: END IF;

Line 1953: x_return_status := FND_API.G_RET_STS_ERROR;

1949: OE_Order_Util.Get_Attribute_Name('ordered_quantity'));
1950: OE_MSG_PUB.Add;
1951: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1952: END IF;
1953: x_return_status := FND_API.G_RET_STS_ERROR;
1954: return;
1955: END IF; -- Invalid Service Quantity => Should be equal to Order QTY
1956:
1957: x_line_rec.service_number := 1;

Line 1960: x_return_status := FND_API.G_RET_STS_SUCCESS;

1956:
1957: x_line_rec.service_number := 1;
1958: -- x_line_rec.ordered_quantity := l_service_qty;
1959: x_line_rec.ordered_quantity := Nvl(l_fulfilled_quantity,l_service_qty);--5699215
1960: x_return_status := FND_API.G_RET_STS_SUCCESS;
1961: IF l_debug_level > 0 THEN
1962: oe_debug_pub.add( 'EXITING GET_SERVICE_ATTRIBUTE' ) ;
1963: END IF;
1964: ELSIF (p_line_rec.service_reference_type_code is NULL) OR

Line 1965: (p_line_rec.service_reference_type_code = FND_API.G_MISS_CHAR) THEN

1961: IF l_debug_level > 0 THEN
1962: oe_debug_pub.add( 'EXITING GET_SERVICE_ATTRIBUTE' ) ;
1963: END IF;
1964: ELSIF (p_line_rec.service_reference_type_code is NULL) OR
1965: (p_line_rec.service_reference_type_code = FND_API.G_MISS_CHAR) THEN
1966: IF l_debug_level > 0 THEN
1967: oe_debug_pub.add( 'IN GET_SERVICE_ATTRIBUTE - WHERE CODE IS NULL' ) ;
1968: END IF;
1969: NULL;

Line 1973: x_return_status := FND_API.G_RET_STS_ERROR;

1969: NULL;
1970: ELSE
1971: OE_MSG_PUB.Add_Exc_Msg( 'G_PKG_NAME',
1972: 'Get_Service_Attribute - Invalid Context');
1973: x_return_status := FND_API.G_RET_STS_ERROR;
1974: IF l_debug_level > 0 THEN
1975: oe_debug_pub.add( 'EXITING GET_SERVICE_ATTRIBUTE' ) ;
1976: END IF;
1977: END IF;

Line 2015: x_return_status := FND_API.G_RET_STS_SUCCESS;

2011: AND l.shipment_number = p_shipment_number
2012: AND nvl(l.option_number, 0) = nvl(p_option_number, 0)
2013: AND l.item_type_code <> 'SERVICE';
2014: End If;
2015: x_return_status := FND_API.G_RET_STS_SUCCESS;
2016: IF l_debug_level > 0 THEN
2017: oe_debug_pub.add( 'EXITING GET_SERVICE_REF_LINE_ID' ) ;
2018: END IF;
2019: EXCEPTION

Line 2024: x_return_status := FND_API.G_RET_STS_ERROR;

2020: WHEN OTHERS THEN
2021: OE_MSG_PUB.Add_Exc_Msg( 'G_PKG_NAME',
2022: 'Get_Service_Ref_Line_Id -Invalid Order/Line No.');
2023: /* uncomment later
2024: x_return_status := FND_API.G_RET_STS_ERROR;
2025: OE_DEBUG_PUB.ADD('Exiting Get_Service_Ref_Line_Id');
2026: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2027: */
2028: END Get_Service_Ref_Line_Id;

Line 2026: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2022: 'Get_Service_Ref_Line_Id -Invalid Order/Line No.');
2023: /* uncomment later
2024: x_return_status := FND_API.G_RET_STS_ERROR;
2025: OE_DEBUG_PUB.ADD('Exiting Get_Service_Ref_Line_Id');
2026: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2027: */
2028: END Get_Service_Ref_Line_Id;
2029:
2030:

Line 2094: x_return_status := FND_API.G_RET_STS_SUCCESS;

2090:
2091: x_reference_system_id := l_reference_system_id;
2092: END IF;
2093:
2094: x_return_status := FND_API.G_RET_STS_SUCCESS;
2095: IF l_debug_level > 0 THEN
2096: oe_debug_pub.add( 'EXITING GET_SERVICE_REF_SYSTEM_ID' ) ;
2097: END IF;
2098: EXCEPTION

Line 2102: x_return_status := FND_API.G_RET_STS_ERROR;

2098: EXCEPTION
2099: WHEN OTHERS THEN
2100: OE_MSG_PUB.Add_Exc_Msg( 'G_PKG_NAME',
2101: 'Get_Service_Ref_System_Id - Invalid System No.');
2102: x_return_status := FND_API.G_RET_STS_ERROR;
2103: IF l_debug_level > 0 THEN
2104: oe_debug_pub.add( 'EXITING GET_SERVICE_REF_SYSTEM_ID' ) ;
2105: END IF;
2106: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2106: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2102: x_return_status := FND_API.G_RET_STS_ERROR;
2103: IF l_debug_level > 0 THEN
2104: oe_debug_pub.add( 'EXITING GET_SERVICE_REF_SYSTEM_ID' ) ;
2105: END IF;
2106: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2107: END Get_Service_Ref_System_Id;
2108:
2109: PROCEDURE Get_Service_Ref_System_Name
2110: ( x_return_status OUT NOCOPY VARCHAR2

Line 2168: x_return_status := FND_API.G_RET_STS_SUCCESS;

2164: Using p_reference_system_id; /* commented for 4731582, p_customer_id;*/
2165: x_system_name := l_system_name;
2166: END IF;
2167:
2168: x_return_status := FND_API.G_RET_STS_SUCCESS;
2169: IF l_debug_level > 0 THEN
2170: oe_debug_pub.add( 'EXITING SUCCESS GET_SERVICE_REF_SYSTEM_NAME' ) ;
2171: END IF;
2172:

Line 2175: x_return_status := FND_API.G_RET_STS_SUCCESS;

2171: END IF;
2172:
2173: Exception
2174: When others then
2175: x_return_status := FND_API.G_RET_STS_SUCCESS;
2176: IF l_debug_level > 0 THEN
2177: oe_debug_pub.add( 'EXITING ERROR GET_SERVICE_REF_SYSTEM_NAME' ) ;
2178: END IF;
2179: END Get_Service_Ref_System_Name;

Line 2261: x_return_status := FND_API.G_RET_STS_SUCCESS;

2257: oe_debug_pub.add( 'AFTER EXECUTE IMMEDIATE' ) ;
2258: END IF;
2259: END IF;
2260:
2261: x_return_status := FND_API.G_RET_STS_SUCCESS;
2262: IF l_debug_level > 0 THEN
2263: oe_debug_pub.add( 'EXITING SUCCESS GET_SERVICE_REF_CUST_PRODUCT' ) ;
2264: END IF;
2265:

Line 2268: x_return_status := FND_API.G_RET_STS_SUCCESS;

2264: END IF;
2265:
2266: Exception
2267: When others then
2268: x_return_status := FND_API.G_RET_STS_SUCCESS;
2269: IF l_debug_level > 0 THEN
2270: oe_debug_pub.add( 'EXITING ERROR GET_SERVICE_REF_CUST_PRODUCT' ) ;
2271: END IF;
2272: END Get_Service_Ref_Cust_Product;

Line 2378: x_return_status := FND_API.G_RET_STS_SUCCESS;

2374: oe_debug_pub.add( 'AFTER EXECUTE IMMEDIATE' ) ;
2375: END IF;
2376: -- END IF;
2377:
2378: x_return_status := FND_API.G_RET_STS_SUCCESS;
2379: IF l_debug_level > 0 THEN
2380: oe_debug_pub.add( 'EXITING SUCCESS GET_CUST_PRODUCT_LINE_ID' ) ;
2381: END IF;
2382:

Line 2394: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2390:
2391: IF l_debug_level > 0 THEN
2392: oe_debug_pub.add( 'GET_CUST_PRODUCT_LINE_ID: NO DATA FOUND' ) ;
2393: END IF;
2394: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2395:
2396: WHEN FND_API.G_EXC_ERROR THEN
2397: RAISE FND_API.G_EXC_ERROR;
2398:

Line 2396: WHEN FND_API.G_EXC_ERROR THEN

2392: oe_debug_pub.add( 'GET_CUST_PRODUCT_LINE_ID: NO DATA FOUND' ) ;
2393: END IF;
2394: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2395:
2396: WHEN FND_API.G_EXC_ERROR THEN
2397: RAISE FND_API.G_EXC_ERROR;
2398:
2399: WHEN OTHERS THEN
2400: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2397: RAISE FND_API.G_EXC_ERROR;

2393: END IF;
2394: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2395:
2396: WHEN FND_API.G_EXC_ERROR THEN
2397: RAISE FND_API.G_EXC_ERROR;
2398:
2399: WHEN OTHERS THEN
2400: x_return_status := FND_API.G_RET_STS_ERROR;
2401: IF l_debug_level > 0 THEN

Line 2400: x_return_status := FND_API.G_RET_STS_ERROR;

2396: WHEN FND_API.G_EXC_ERROR THEN
2397: RAISE FND_API.G_EXC_ERROR;
2398:
2399: WHEN OTHERS THEN
2400: x_return_status := FND_API.G_RET_STS_ERROR;
2401: IF l_debug_level > 0 THEN
2402: oe_debug_pub.add( 'EXITING ERROR GET_CUST_PRODUCT_LINE_ID' ) ;
2403: END IF;
2404: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2404: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2400: x_return_status := FND_API.G_RET_STS_ERROR;
2401: IF l_debug_level > 0 THEN
2402: oe_debug_pub.add( 'EXITING ERROR GET_CUST_PRODUCT_LINE_ID' ) ;
2403: END IF;
2404: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2405: END Get_Cust_Product_Line_Id;
2406:
2407:
2408: PROCEDURE Get_Cust_Prod_RG

Line 2487: x_return_status := FND_API.G_RET_STS_SUCCESS;

2483: EXIT WHEN cust_cv%NOTFOUND;
2484: END LOOP;
2485: END IF;
2486: x_srv_cust_prod_tbl := OE_SERVICE_UTIL.l_srv_cust_prod_tbl;
2487: x_return_status := FND_API.G_RET_STS_SUCCESS;
2488: IF l_debug_level > 0 THEN
2489: oe_debug_pub.add( 'EXITING SUCCESS GET_CUST_PROD_RG' ) ;
2490: END IF;
2491:

Line 2494: x_return_status := FND_API.G_RET_STS_SUCCESS;

2490: END IF;
2491:
2492: Exception
2493: When others then
2494: x_return_status := FND_API.G_RET_STS_SUCCESS;
2495: IF l_debug_level > 0 THEN
2496: oe_debug_pub.add( 'EXITING ERROR GET_CUST_PROD_RG' ) ;
2497: END IF;
2498:

Line 2525: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN */

2521: -- Call Describe_Proc to check for the existance of the CRM's
2522: -- AVAILABLE_SERVICES API. If exists Then Call it else No Problem.
2523:
2524: /* OE_SERVICE_UTIL.CHECK_PROC('OKS_OMINT_PUB.OKS_AVAILABLE_SERVICES', l_return_status);
2525: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN */
2526:
2527: -- IF Get_Product_Status(515) IN ('I','S') THEN
2528:
2529: -- lkxu, for bug 1701377

Line 2576: x_return_status := FND_API.G_RET_STS_SUCCESS;

2572: IF l_debug_level > 0 THEN
2573: oe_debug_pub.add( ' CUSTOMER ID : ' || TO_CHAR ( P_SERVICE_REC.CUSTOMER_ID ) ) ;
2574: END IF;
2575:
2576: x_return_status := FND_API.G_RET_STS_SUCCESS;
2577: IF l_debug_level > 0 THEN
2578: oe_debug_pub.add( 'EXITING ERROR GET_AVAIL_SERVICE_RG' ) ;
2579: END IF;
2580: END IF;

Line 2584: x_return_status := FND_API.G_RET_STS_SUCCESS;

2580: END IF;
2581:
2582: Exception
2583: When others then
2584: x_return_status := FND_API.G_RET_STS_SUCCESS;
2585: IF l_debug_level > 0 THEN
2586: oe_debug_pub.add( 'EXITING ERROR GET_AVAIL_SERVICE_RG' ) ;
2587: END IF;
2588:

Line 2701: p_x_line_tbl(i).service_reference_line_id <> FND_API.G_MISS_NUM AND

2697: IF p_x_line_tbl(i).item_type_code = 'SERVICE' AND
2698: p_x_line_tbl(i).service_reference_type_code = 'ORDER' AND
2699: p_x_line_tbl(i).service_reference_line_id is NOT NULL AND
2700: --lchen fix for bug 2017271
2701: p_x_line_tbl(i).service_reference_line_id <> FND_API.G_MISS_NUM AND
2702: ( p_x_line_tbl(i).operation = OE_GLOBALS.G_OPR_CREATE or
2703: p_x_line_tbl(i).operation= OE_GLOBALS.G_OPR_UPDATE) THEN
2704:
2705: IF l_debug_level > 0 THEN

Line 2779: WHEN FND_API.G_EXC_ERROR THEN

2775:
2776:
2777: EXCEPTION
2778:
2779: WHEN FND_API.G_EXC_ERROR THEN
2780:
2781: x_return_status := FND_API.G_RET_STS_ERROR;
2782:
2783: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2781: x_return_status := FND_API.G_RET_STS_ERROR;

2777: EXCEPTION
2778:
2779: WHEN FND_API.G_EXC_ERROR THEN
2780:
2781: x_return_status := FND_API.G_RET_STS_ERROR;
2782:
2783: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2784:
2785: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2783: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2779: WHEN FND_API.G_EXC_ERROR THEN
2780:
2781: x_return_status := FND_API.G_RET_STS_ERROR;
2782:
2783: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2784:
2785: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2786:
2787: WHEN OTHERS THEN

Line 2785: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2781: x_return_status := FND_API.G_RET_STS_ERROR;
2782:
2783: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2784:
2785: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2786:
2787: WHEN OTHERS THEN
2788:
2789: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2789: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2785: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2786:
2787: WHEN OTHERS THEN
2788:
2789: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2790: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2791: THEN
2792: OE_MSG_PUB.Add_Exc_Msg
2793: ( G_PKG_NAME

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

2816: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type
2817: := OE_ORDER_PUB.G_MISS_LINE_TBL;
2818: l_line_tbl OE_Order_PUB.Line_Tbl_Type
2819: := OE_ORDER_PUB.G_MISS_LINE_TBL;
2820: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2821: l_line_count NUMBER;
2822:
2823:
2824: l_inventory_item_id NUMBER;

Line 2859: x_return_status := FND_API.G_RET_STS_SUCCESS;

2855: /* 3128684 */
2856: IF l_debug_level > 0 THEN
2857: oe_debug_pub.add( 'DO NOT CASCADE SERVICES' , 2 ) ;
2858: END IF;
2859: x_return_status := FND_API.G_RET_STS_SUCCESS;
2860: RETURN;
2861: END IF;
2862: IF l_debug_level > 0 THEN
2863: oe_debug_pub.add( 'DO CASCADE SERVICES' , 2 ) ;

Line 2870: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2866: OE_Line_Util.Lock_Row( p_line_id => p_parent_line_id
2867: ,p_x_line_rec => l_parent_line_rec
2868: ,x_return_status => l_return_status);
2869:
2870: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2871: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2872: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2873: RAISE FND_API.G_EXC_ERROR;
2874: END IF;

Line 2871: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2867: ,p_x_line_rec => l_parent_line_rec
2868: ,x_return_status => l_return_status);
2869:
2870: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2871: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2872: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2873: RAISE FND_API.G_EXC_ERROR;
2874: END IF;
2875:

Line 2872: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2868: ,x_return_status => l_return_status);
2869:
2870: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2871: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2872: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2873: RAISE FND_API.G_EXC_ERROR;
2874: END IF;
2875:
2876: l_service_reference_line_id := l_parent_line_rec.service_reference_line_id;

Line 2873: RAISE FND_API.G_EXC_ERROR;

2869:
2870: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2871: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2872: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2873: RAISE FND_API.G_EXC_ERROR;
2874: END IF;
2875:
2876: l_service_reference_line_id := l_parent_line_rec.service_reference_line_id;
2877: l_inventory_item_id := l_parent_line_rec.inventory_item_id;

Line 2999: (P_validation_level => FND_API.G_VALID_LEVEL_NONE

2995:
2996: -- Call OE_Order_PVT.Process_order
2997:
2998: OE_ORDER_PVT.Lines
2999: (P_validation_level => FND_API.G_VALID_LEVEL_NONE
3000: ,p_control_rec => l_control_rec
3001: ,p_x_line_tbl => l_line_tbl
3002: ,p_x_old_line_tbl => l_old_line_tbl
3003: ,x_return_status => l_return_status);

Line 3005: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3001: ,p_x_line_tbl => l_line_tbl
3002: ,p_x_old_line_tbl => l_old_line_tbl
3003: ,x_return_status => l_return_status);
3004:
3005: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3006: IF l_debug_level > 0 THEN
3007: oe_debug_pub.add( 'INSIDE UNEXPECTED ERROR ' , 2 ) ;
3008: END IF;
3009: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3009: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3005: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3006: IF l_debug_level > 0 THEN
3007: oe_debug_pub.add( 'INSIDE UNEXPECTED ERROR ' , 2 ) ;
3008: END IF;
3009: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3010: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3011: IF l_debug_level > 0 THEN
3012: oe_debug_pub.add( 'INSIDE ERROR ' , 2 ) ;
3013: END IF;

Line 3010: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3006: IF l_debug_level > 0 THEN
3007: oe_debug_pub.add( 'INSIDE UNEXPECTED ERROR ' , 2 ) ;
3008: END IF;
3009: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3010: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3011: IF l_debug_level > 0 THEN
3012: oe_debug_pub.add( 'INSIDE ERROR ' , 2 ) ;
3013: END IF;
3014: RAISE FND_API.G_EXC_ERROR;

Line 3014: RAISE FND_API.G_EXC_ERROR;

3010: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3011: IF l_debug_level > 0 THEN
3012: oe_debug_pub.add( 'INSIDE ERROR ' , 2 ) ;
3013: END IF;
3014: RAISE FND_API.G_EXC_ERROR;
3015: END IF;
3016:
3017: /* jolin start: comment out nocopy for notification project
3018:

Line 3026: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3022: ,x_return_status => l_return_status
3023: ,p_line_tbl => l_line_tbl
3024: ,p_old_line_tbl => l_old_line_tbl);
3025:
3026: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3027: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3028: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3029: RAISE FND_API.G_EXC_ERROR;
3030: END IF;

Line 3027: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3023: ,p_line_tbl => l_line_tbl
3024: ,p_old_line_tbl => l_old_line_tbl);
3025:
3026: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3027: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3028: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3029: RAISE FND_API.G_EXC_ERROR;
3030: END IF;
3031: jolin end */

Line 3028: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3024: ,p_old_line_tbl => l_old_line_tbl);
3025:
3026: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3027: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3028: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3029: RAISE FND_API.G_EXC_ERROR;
3030: END IF;
3031: jolin end */
3032:

Line 3029: RAISE FND_API.G_EXC_ERROR;

3025:
3026: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3027: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3028: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3029: RAISE FND_API.G_EXC_ERROR;
3030: END IF;
3031: jolin end */
3032:
3033: -- Clear Table

Line 3042: WHEN FND_API.G_EXC_ERROR THEN

3038: END IF;
3039:
3040: EXCEPTION
3041:
3042: WHEN FND_API.G_EXC_ERROR THEN
3043: IF l_debug_level > 0 THEN
3044: oe_debug_pub.add( 'INSIDE EXCEPTION EXE ERROR ' , 1 ) ;
3045: END IF;
3046: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3046: x_return_status := FND_API.G_RET_STS_ERROR;

3042: WHEN FND_API.G_EXC_ERROR THEN
3043: IF l_debug_level > 0 THEN
3044: oe_debug_pub.add( 'INSIDE EXCEPTION EXE ERROR ' , 1 ) ;
3045: END IF;
3046: x_return_status := FND_API.G_RET_STS_ERROR;
3047:
3048: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3049: IF l_debug_level > 0 THEN
3050: oe_debug_pub.add( 'INSIDE EXCEPTION UNEXP ERROR ' , 1 ) ;

Line 3048: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3044: oe_debug_pub.add( 'INSIDE EXCEPTION EXE ERROR ' , 1 ) ;
3045: END IF;
3046: x_return_status := FND_API.G_RET_STS_ERROR;
3047:
3048: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3049: IF l_debug_level > 0 THEN
3050: oe_debug_pub.add( 'INSIDE EXCEPTION UNEXP ERROR ' , 1 ) ;
3051: END IF;
3052: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3052: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3048: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3049: IF l_debug_level > 0 THEN
3050: oe_debug_pub.add( 'INSIDE EXCEPTION UNEXP ERROR ' , 1 ) ;
3051: END IF;
3052: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3053:
3054: WHEN OTHERS THEN
3055:
3056: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3056: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3052: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3053:
3054: WHEN OTHERS THEN
3055:
3056: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3057: IF l_debug_level > 0 THEN
3058: oe_debug_pub.add( 'INSIDE EXCEPTION OTHER ERROR ' , 1 ) ;
3059: END IF;
3060: