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.16.12020000.3 2013/03/27 11:06:32 sahvivek 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.16.12020000.3 2013/03/27 11:06:32 sahvivek 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,0.5 ) ; -- debug level 0.5 added for bug 13435459
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 358: WHEN FND_API.G_EXC_ERROR THEN

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

Line 360: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 362: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 364: x_return_status := FND_API.G_RET_STS_ERROR;

360: x_return_status := FND_API.G_RET_STS_ERROR;
361: -- For bug 3574480. Modified unexpected errors also to return normal error
362: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
363:
364: x_return_status := FND_API.G_RET_STS_ERROR;
365:
366: WHEN OTHERS THEN
367:
368: x_return_status := FND_API.G_RET_STS_ERROR;

Line 368: x_return_status := FND_API.G_RET_STS_ERROR;

364: x_return_status := FND_API.G_RET_STS_ERROR;
365:
366: WHEN OTHERS THEN
367:
368: x_return_status := FND_API.G_RET_STS_ERROR;
369:
370: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
371: THEN
372: OE_MSG_PUB.Add_Exc_Msg

Line 377: RAISE FND_API.G_EXC_ERROR;

373: ( G_PKG_NAME
374: , 'NOTIFY_OC'
375: );
376: END IF;
377: RAISE FND_API.G_EXC_ERROR;
378:
379: END NOTIFY_OC;
380:
381: -- Procedure to Check for the availability of the CRM APIS

Line 431: x_return_status := FND_API.G_RET_STS_SUCCESS;

427: l_scale,
428: l_radix,
429: l_spare
430: );
431: x_return_status := FND_API.G_RET_STS_SUCCESS;
432: EXCEPTION
433: WHEN OTHERS THEN
434: x_return_status := FND_API.G_RET_STS_ERROR;
435: END;

Line 434: x_return_status := FND_API.G_RET_STS_ERROR;

430: );
431: x_return_status := FND_API.G_RET_STS_SUCCESS;
432: EXCEPTION
433: WHEN OTHERS THEN
434: x_return_status := FND_API.G_RET_STS_ERROR;
435: END;
436: IF l_debug_level > 0 THEN
437: oe_debug_pub.add( 'EXITING CHECK_PROC API' ) ;
438: END IF;

Line 497: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

493: , OUT l_msg_data
494: , OUT l_return_status
495: , OUT l_start_date
496: , OUT l_end_date;
497: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
498: IF l_debug_level > 0 THEN
499: oe_debug_pub.add( 'OKS_OMINT_PUB.GET_SVC_SDATE SUCCESSFUL' ) ;
500: END IF;
501: IF l_debug_level > 0 THEN

Line 526: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

522: WHEN OTHERS THEN
523: IF l_debug_level > 0 THEN
524: oe_debug_pub.add('Unexpected error calling OKS_OMINT_PUB.GET_SVC_SDATE:' ,0.5); -- debug level 0.5 added for bug 13435459
525: oe_debug_pub.add(sqlerrm);
526: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
527: RETURN;
528: END IF;
529: END; -- to recover from any unexpected errors
530:

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

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

Line 660: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

656: END IF;
657: IF l_debug_level > 0 THEN
658: oe_debug_pub.add( 'SERVICE_PERIOD ==> ' || L_SERVICE_PERIOD ) ;
659: END IF;
660: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
661: IF l_debug_level > 0 THEN
662: oe_debug_pub.add( 'OKS_OMINT_PUB.GET_DURATION RETURN SUCCESS' ) ;
663: END IF;
664: IF l_debug_level > 0 THEN

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

681: IF l_return_status is NULL THEN
682: IF l_debug_level > 0 THEN
683: oe_debug_pub.add( 'OKS_OMINT_PUB.GET_DURATION NOT RETURNED VALUE' ) ;
684: END IF;
685: --x_return_status := FND_API.G_RET_STS_ERROR;
686: END IF;
687: IF l_debug_level > 0 THEN
688: oe_debug_pub.add( 'EXITING GET_SERVICE_DURATION' ,0.5 ) ; -- debug level 0.5 added for bug 13435459
689: END IF;

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

690: ELSE
691: IF l_debug_level > 0 THEN
692: oe_debug_pub.add( 'OKS_OMINT_PUB.GET_DURATION NOT EXISTS',0.5 ) ; -- debug level 0.5 added for bug 13435459
693: END IF;
694: --x_return_status := FND_API.G_RET_STS_ERROR;
695: END IF;
696: END Get_Service_Duration;
697:
698:

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

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

Line 912: RAISE FND_API.G_EXC_ERROR;

908: EXCEPTION
909: WHEN No_Data_Found THEN
910: FND_MESSAGE.SET_NAME('ONT','ONT_INVALID_SERV_REF');
911: OE_MSG_PUB.Add;
912: RAISE FND_API.G_EXC_ERROR;
913: END;
914:
915: --Added for Bug # 4770432 Try to get blanket No from Top Model
916: --if unable to get from currently referenced option item

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

971:
972: -- IF OKS_OMINT_PUB.IS_SERVICE_AVAILABLE exists in DB
973: -- Then Call it Else Not
974: /* OE_SERVICE_UTIL.CHECK_PROC('OKS_OMINT_PUB.IS_SERVICE_AVAILABLE', l_return_status);
975: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN */
976:
977: -- IF Get_Product_Status(515) IN ('I','S') THEN
978:
979: -- lkxu, for bug 1701377

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

1057: oe_debug_pub.add( 'AFTER CALL TO SERVICE AVAILABLE API' ) ;
1058: END IF;
1059:
1060: /* OR added for 2282076 */
1061: IF l_available_yn = 'N' OR l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1062: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
1063: OE_MSG_PUB.Update_Msg_Context(p_attribute_code =>'ORDERED_ITEM');
1064: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SERV_ITEM');
1065: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

Line 1070: x_return_status := FND_API.G_RET_STS_ERROR;

1066: OE_Order_Util.Get_Attribute_Name('ordered_item'));
1067: OE_MSG_PUB.Add;
1068: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1069: END IF;
1070: x_return_status := FND_API.G_RET_STS_ERROR;
1071: return; /* comment on the return statement removed as part of 2271749, though not required to fix that bug */
1072: END IF; -- Should be a valid service item
1073:
1074: END IF;

Line 1089: x_return_status := FND_API.G_RET_STS_ERROR;

1085: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SERV_ITEM_QTY');
1086: OE_MSG_PUB.Add;
1087: /* Fix for the bug 2431953 / 2749740
1088: ELSIF OE_LINE_UTIL.G_ORDERED_QTY_CHANGE = TRUE THEN
1089: x_return_status := FND_API.G_RET_STS_ERROR;
1090: Fix ends */
1091: END IF;
1092: --x_return_status := FND_API.G_RET_STS_ERROR;
1093: -- Make the service quantity same as product quantity

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

1088: ELSIF OE_LINE_UTIL.G_ORDERED_QTY_CHANGE = TRUE THEN
1089: x_return_status := FND_API.G_RET_STS_ERROR;
1090: Fix ends */
1091: END IF;
1092: --x_return_status := FND_API.G_RET_STS_ERROR;
1093: -- Make the service quantity same as product quantity
1094: p_x_line_rec.ordered_quantity := Nvl (l_fulfilled_quantity,l_service_qty); --5699215
1095: /* for bug 2068001 */
1096: -- return;

Line 1231: WHEN FND_API.G_EXC_ERROR THEN

1227: );
1228: END IF;
1229:
1230: -- Bug 9001060
1231: WHEN FND_API.G_EXC_ERROR THEN
1232: x_return_status := FND_API.G_RET_STS_ERROR;
1233:
1234: WHEN OTHERS THEN
1235: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 1232: x_return_status := FND_API.G_RET_STS_ERROR;

1228: END IF;
1229:
1230: -- Bug 9001060
1231: WHEN FND_API.G_EXC_ERROR THEN
1232: x_return_status := FND_API.G_RET_STS_ERROR;
1233:
1234: WHEN OTHERS THEN
1235: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1236: OE_MSG_PUB.Add_Exc_Msg

Line 1241: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1237: ( 'G_PKG_NAME' ,
1238: 'Get_Service_Attribute'
1239: );
1240: END IF;
1241: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1242:
1243: END;
1244:
1245: ELSIF (p_x_line_rec.service_reference_type_code = 'CUSTOMER_PRODUCT') THEN

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

1328:
1329: -- IF OKS_OMINT_PUB.IS_SERVICE_AVAILABLE exists in DB
1330: -- Then Call it Else Not
1331: /* OE_SERVICE_UTIL.CHECK_PROC('OKS_OMINT_PUB.IS_SERVICE_AVAILABLE', l_return_status);
1332: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN */
1333:
1334: -- IF Get_Product_Status(515) IN ('I','S') THEN
1335:
1336: -- lkxu, for bug 1701377

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

1410: oe_debug_pub.add( 'AFTER EXECUTE IMMEDIATE FOR CUST-IS_SERVICE_AVAIL' ) ;
1411: END IF;
1412:
1413: /* OR added for 2282076 */
1414: IF l_available_yn = 'N' OR l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1415: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
1416: OE_MSG_PUB.Update_Msg_Context(p_attribute_code =>'ORDERED_ITEM');
1417: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SERV_ITEM');
1418: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

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

1419: OE_Order_Util.Get_Attribute_Name('ordered_item'));
1420: OE_MSG_PUB.Add;
1421: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1422: END IF;
1423: x_return_status := FND_API.G_RET_STS_ERROR; /* status set to ERROR for 2271749 */
1424: return;
1425: END IF; -- Should be a valid service item
1426:
1427: END IF;

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

1441: OE_Order_Util.Get_Attribute_Name('ordered_quantity'));
1442: OE_MSG_PUB.Add;
1443: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1444: END IF;
1445: -- x_return_status := FND_API.G_RET_STS_ERROR;
1446: --p_x_line_rec.ordered_quantity := l_service_qty; -- moved in front of RETURN with, but unrelated to, 1720185
1447: p_x_line_rec.ordered_quantity := Nvl (l_fulfilled_quantity,l_service_qty); --5699215
1448: --return; --Bug 16531475
1449: END IF; -- Invalid Service Quantity => Should be equal to Order QTY

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

1449: END IF; -- Invalid Service Quantity => Should be equal to Order QTY
1450:
1451: p_x_line_rec.service_number := 1;
1452: p_x_line_rec.ordered_quantity := Nvl (l_fulfilled_quantity,l_service_qty); --5699215
1453: -- x_return_status := FND_API.G_RET_STS_SUCCESS;
1454: IF l_debug_level > 0 THEN
1455: oe_debug_pub.add( 'EXITING GET_SERVICE_ATTRIBUTE' ) ;
1456: END IF;
1457: /* ELSIF (p_x_line_rec.service_reference_type_code is NULL) OR

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

1454: IF l_debug_level > 0 THEN
1455: oe_debug_pub.add( 'EXITING GET_SERVICE_ATTRIBUTE' ) ;
1456: END IF;
1457: /* ELSIF (p_x_line_rec.service_reference_type_code is NULL) OR
1458: (p_x_line_rec.service_reference_type_code = FND_API.G_MISS_CHAR) THEN
1459: OE_DEBUG_PUB.ADD('IN Get_Service_Attribute - where code is NULL');
1460: NULL; */
1461: ELSE
1462: OE_MSG_PUB.Add_Exc_Msg( 'G_PKG_NAME',

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

1460: NULL; */
1461: ELSE
1462: OE_MSG_PUB.Add_Exc_Msg( 'G_PKG_NAME',
1463: 'Get_Service_Attribute - Invalid Context');
1464: -- x_return_status := FND_API.G_RET_STS_ERROR;
1465: IF l_debug_level > 0 THEN
1466: oe_debug_pub.add( 'EXITING GET_SERVICE_ATTRIBUTE' ) ;
1467: END IF;
1468: END IF;

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

1503: END IF;
1504:
1505: x_line_rec := p_line_rec;
1506: /* OE_SERVICE_UTIL.CHECK_PROC('OKS_OMINT_PUB.GET_DURATION', l_return_status);
1507: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN */
1508:
1509: -- IF Get_Product_Status(515) IN ('I','S') THEN
1510:
1511: -- lkxu, for bug 1701377

Line 1570: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

1566: IF l_debug_level > 0 THEN
1567: oe_debug_pub.add( 'AFTER EXECUTE IMMEDIATE', 0.5 ) ;
1568: END IF;
1569:
1570: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1571: x_line_rec.service_end_date := l_new_end_date;
1572: x_line_rec.service_duration := l_service_duration;
1573: x_line_rec.service_period := l_service_period;
1574: END IF;

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

1576: IF l_return_status is NULL THEN
1577: IF l_debug_level > 0 THEN
1578: oe_debug_pub.add( 'OKS_OMINT_PUB.GET_DURATION NOT RETURNED VALUE' ) ;
1579: END IF;
1580: --x_return_status := FND_API.G_RET_STS_ERROR;
1581: END IF;
1582: IF l_debug_level > 0 THEN
1583: oe_debug_pub.add( 'EXITING GET_SERVICE_DURATION' ) ;
1584: END IF;

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

1585: ELSE
1586: IF l_debug_level > 0 THEN
1587: oe_debug_pub.add( 'OKS_OMINT_PUB.GET_DURATION NOT EXISTS' ) ;
1588: END IF;
1589: --x_return_status := FND_API.G_RET_STS_ERROR;
1590: END IF;
1591: -- Added debug for bug 13435459
1592: IF l_debug_level > 0 THEN
1593: oe_debug_pub.add( 'EXITING GET_SERVICE_DURATION', 0.5 ) ;

Line 1650: x_return_status := FND_API.G_RET_STS_ERROR;

1646: OE_Order_Util.Get_Attribute_Name('service_reference_type_code'));
1647: OE_MSG_PUB.Add;
1648: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1649: END IF;
1650: x_return_status := FND_API.G_RET_STS_ERROR;
1651: ELSIF (p_line_rec.service_reference_type_code = 'ORDER') THEN
1652:
1653: -- put code for the checking of valid service item
1654: -- first use IS_SERVICE_AVAILABLE API to confirm that the enter

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

1688:
1689: -- IF OKS_OMINT_PUB.IS_SERVICE_AVAILABLE exists in DB
1690: -- Then Call it Else Not
1691: /* OE_SERVICE_UTIL.CHECK_PROC('OKS_OMINT_PUB.IS_SERVICE_AVAILABLE', l_return_status);
1692: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN */
1693:
1694: -- IF Get_Product_Status(515) IN ('I','S') THEN
1695:
1696: -- lkxu, for bug 1701377

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

1766: oe_debug_pub.add( 'AVAILABLE/RET.STATUS:' || L_AVAILABLE_YN||'/'||L_RETURN_STATUS , 0.5 ) ; -- debug level changed to 0.5 for bug 13435459
1767: END IF;
1768:
1769: /* OR added for 2282076 */
1770: IF l_available_yn = 'N' OR l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1771: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
1772: OE_MSG_PUB.Update_Msg_Context(p_attribute_code =>'ORDERED_ITEM');
1773: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SERV_ITEM');
1774: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

Line 1779: x_return_status := FND_API.G_RET_STS_ERROR;

1775: OE_Order_Util.Get_Attribute_Name('ordered_item'));
1776: OE_MSG_PUB.Add;
1777: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1778: END IF;
1779: x_return_status := FND_API.G_RET_STS_ERROR;
1780: return;
1781: END IF; -- Should be a valid service item
1782:
1783: END IF;

Line 1795: x_return_status := FND_API.G_RET_STS_ERROR;

1791: OE_Order_Util.Get_Attribute_Name('ordered_quantity'));
1792: OE_MSG_PUB.Add;
1793: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1794: END IF;
1795: x_return_status := FND_API.G_RET_STS_ERROR;
1796: return;
1797: END IF; -- Invalid Service Quantity => Should be equal to Order QTY
1798:
1799: IF l_header_id = p_line_rec.header_id THEN

Line 1859: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1855: 'Get_Service_Attribute'
1856: );
1857: END IF;
1858:
1859: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1860:
1861: END;
1862:
1863: ELSIF (p_line_rec.service_reference_type_code = 'CUSTOMER_PRODUCT') THEN

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

1887:
1888: -- IF OKS_OMINT_PUB.IS_SERVICE_AVAILABLE exists in DB
1889: -- Then Call it Else Not
1890: /* OE_SERVICE_UTIL.CHECK_PROC('OKS_OMINT_PUB.IS_SERVICE_AVAILABLE', l_return_status);
1891: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN */
1892:
1893: -- IF Get_Product_Status(515) IN ('I','S') THEN
1894:
1895: -- lkxu, for bug 1701377

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

1964: oe_debug_pub.add( 'AVAILABLE/RET.STATUS:' || L_AVAILABLE_YN||'/'||L_RETURN_STATUS , 0.5 ) ; -- debug level changed to 0.5 for bug 13435459
1965: END IF;
1966:
1967: /* OR added for 2282076 */
1968: IF l_available_yn = 'N' OR l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1969: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
1970: OE_MSG_PUB.Update_Msg_Context(p_attribute_code =>'ORDERED_ITEM');
1971: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SERV_ITEM');
1972: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

Line 1977: x_return_status := FND_API.G_RET_STS_ERROR;

1973: OE_Order_Util.Get_Attribute_Name('ordered_item'));
1974: OE_MSG_PUB.Add;
1975: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1976: END IF;
1977: x_return_status := FND_API.G_RET_STS_ERROR;
1978: return;
1979: END IF; -- Should be a valid service item
1980:
1981: END IF;

Line 1993: x_return_status := FND_API.G_RET_STS_ERROR;

1989: OE_Order_Util.Get_Attribute_Name('ordered_quantity'));
1990: OE_MSG_PUB.Add;
1991: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1992: END IF;
1993: x_return_status := FND_API.G_RET_STS_ERROR;
1994: return;
1995: END IF; -- Invalid Service Quantity => Should be equal to Order QTY
1996:
1997: x_line_rec.service_number := 1;

Line 2000: x_return_status := FND_API.G_RET_STS_SUCCESS;

1996:
1997: x_line_rec.service_number := 1;
1998: -- x_line_rec.ordered_quantity := l_service_qty;
1999: x_line_rec.ordered_quantity := Nvl(l_fulfilled_quantity,l_service_qty);--5699215
2000: x_return_status := FND_API.G_RET_STS_SUCCESS;
2001: IF l_debug_level > 0 THEN
2002: oe_debug_pub.add( 'EXITING GET_SERVICE_ATTRIBUTE' ) ;
2003: END IF;
2004: ELSIF (p_line_rec.service_reference_type_code is NULL) OR

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

2001: IF l_debug_level > 0 THEN
2002: oe_debug_pub.add( 'EXITING GET_SERVICE_ATTRIBUTE' ) ;
2003: END IF;
2004: ELSIF (p_line_rec.service_reference_type_code is NULL) OR
2005: (p_line_rec.service_reference_type_code = FND_API.G_MISS_CHAR) THEN
2006: IF l_debug_level > 0 THEN
2007: oe_debug_pub.add( 'IN GET_SERVICE_ATTRIBUTE - WHERE CODE IS NULL' ) ;
2008: END IF;
2009: NULL;

Line 2013: x_return_status := FND_API.G_RET_STS_ERROR;

2009: NULL;
2010: ELSE
2011: OE_MSG_PUB.Add_Exc_Msg( 'G_PKG_NAME',
2012: 'Get_Service_Attribute - Invalid Context');
2013: x_return_status := FND_API.G_RET_STS_ERROR;
2014: IF l_debug_level > 0 THEN
2015: oe_debug_pub.add( 'EXITING GET_SERVICE_ATTRIBUTE' ) ;
2016: END IF;
2017: END IF;

Line 2055: x_return_status := FND_API.G_RET_STS_SUCCESS;

2051: AND l.shipment_number = p_shipment_number
2052: AND nvl(l.option_number, 0) = nvl(p_option_number, 0)
2053: AND l.item_type_code <> 'SERVICE';
2054: End If;
2055: x_return_status := FND_API.G_RET_STS_SUCCESS;
2056: IF l_debug_level > 0 THEN
2057: oe_debug_pub.add( 'EXITING GET_SERVICE_REF_LINE_ID' ) ;
2058: END IF;
2059: EXCEPTION

Line 2064: x_return_status := FND_API.G_RET_STS_ERROR;

2060: WHEN OTHERS THEN
2061: OE_MSG_PUB.Add_Exc_Msg( 'G_PKG_NAME',
2062: 'Get_Service_Ref_Line_Id -Invalid Order/Line No.');
2063: /* uncomment later
2064: x_return_status := FND_API.G_RET_STS_ERROR;
2065: OE_DEBUG_PUB.ADD('Exiting Get_Service_Ref_Line_Id');
2066: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2067: */
2068: END Get_Service_Ref_Line_Id;

Line 2066: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2062: 'Get_Service_Ref_Line_Id -Invalid Order/Line No.');
2063: /* uncomment later
2064: x_return_status := FND_API.G_RET_STS_ERROR;
2065: OE_DEBUG_PUB.ADD('Exiting Get_Service_Ref_Line_Id');
2066: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2067: */
2068: END Get_Service_Ref_Line_Id;
2069:
2070:

Line 2134: x_return_status := FND_API.G_RET_STS_SUCCESS;

2130:
2131: x_reference_system_id := l_reference_system_id;
2132: END IF;
2133:
2134: x_return_status := FND_API.G_RET_STS_SUCCESS;
2135: IF l_debug_level > 0 THEN
2136: oe_debug_pub.add( 'EXITING GET_SERVICE_REF_SYSTEM_ID' ) ;
2137: END IF;
2138: EXCEPTION

Line 2142: x_return_status := FND_API.G_RET_STS_ERROR;

2138: EXCEPTION
2139: WHEN OTHERS THEN
2140: OE_MSG_PUB.Add_Exc_Msg( 'G_PKG_NAME',
2141: 'Get_Service_Ref_System_Id - Invalid System No.');
2142: x_return_status := FND_API.G_RET_STS_ERROR;
2143: IF l_debug_level > 0 THEN
2144: oe_debug_pub.add( 'EXITING GET_SERVICE_REF_SYSTEM_ID' ) ;
2145: END IF;
2146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2142: x_return_status := FND_API.G_RET_STS_ERROR;
2143: IF l_debug_level > 0 THEN
2144: oe_debug_pub.add( 'EXITING GET_SERVICE_REF_SYSTEM_ID' ) ;
2145: END IF;
2146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2147: END Get_Service_Ref_System_Id;
2148:
2149: PROCEDURE Get_Service_Ref_System_Name
2150: ( x_return_status OUT NOCOPY VARCHAR2

Line 2208: x_return_status := FND_API.G_RET_STS_SUCCESS;

2204: Using p_reference_system_id; /* commented for 4731582, p_customer_id;*/
2205: x_system_name := l_system_name;
2206: END IF;
2207:
2208: x_return_status := FND_API.G_RET_STS_SUCCESS;
2209: IF l_debug_level > 0 THEN
2210: oe_debug_pub.add( 'EXITING SUCCESS GET_SERVICE_REF_SYSTEM_NAME' ) ;
2211: END IF;
2212:

Line 2215: x_return_status := FND_API.G_RET_STS_SUCCESS;

2211: END IF;
2212:
2213: Exception
2214: When others then
2215: x_return_status := FND_API.G_RET_STS_SUCCESS;
2216: IF l_debug_level > 0 THEN
2217: oe_debug_pub.add( 'EXITING ERROR GET_SERVICE_REF_SYSTEM_NAME' ) ;
2218: END IF;
2219: END Get_Service_Ref_System_Name;

Line 2301: x_return_status := FND_API.G_RET_STS_SUCCESS;

2297: oe_debug_pub.add( 'AFTER EXECUTE IMMEDIATE' ) ;
2298: END IF;
2299: END IF;
2300:
2301: x_return_status := FND_API.G_RET_STS_SUCCESS;
2302: IF l_debug_level > 0 THEN
2303: oe_debug_pub.add( 'EXITING SUCCESS GET_SERVICE_REF_CUST_PRODUCT' ) ;
2304: END IF;
2305:

Line 2308: x_return_status := FND_API.G_RET_STS_SUCCESS;

2304: END IF;
2305:
2306: Exception
2307: When others then
2308: x_return_status := FND_API.G_RET_STS_SUCCESS;
2309: IF l_debug_level > 0 THEN
2310: oe_debug_pub.add( 'EXITING ERROR GET_SERVICE_REF_CUST_PRODUCT' ) ;
2311: END IF;
2312: END Get_Service_Ref_Cust_Product;

Line 2419: x_return_status := FND_API.G_RET_STS_SUCCESS;

2415: oe_debug_pub.add( 'AFTER EXECUTE IMMEDIATE' ) ;
2416: END IF;
2417: -- END IF;
2418:
2419: x_return_status := FND_API.G_RET_STS_SUCCESS;
2420: IF l_debug_level > 0 THEN
2421: oe_debug_pub.add( 'EXITING SUCCESS GET_CUST_PRODUCT_LINE_ID' ) ;
2422: END IF;
2423:

Line 2435: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2431:
2432: IF l_debug_level > 0 THEN
2433: oe_debug_pub.add( 'GET_CUST_PRODUCT_LINE_ID: NO DATA FOUND' ) ;
2434: END IF;
2435: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2436:
2437: WHEN FND_API.G_EXC_ERROR THEN
2438: RAISE FND_API.G_EXC_ERROR;
2439:

Line 2437: WHEN FND_API.G_EXC_ERROR THEN

2433: oe_debug_pub.add( 'GET_CUST_PRODUCT_LINE_ID: NO DATA FOUND' ) ;
2434: END IF;
2435: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2436:
2437: WHEN FND_API.G_EXC_ERROR THEN
2438: RAISE FND_API.G_EXC_ERROR;
2439:
2440: WHEN OTHERS THEN
2441: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2438: RAISE FND_API.G_EXC_ERROR;

2434: END IF;
2435: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2436:
2437: WHEN FND_API.G_EXC_ERROR THEN
2438: RAISE FND_API.G_EXC_ERROR;
2439:
2440: WHEN OTHERS THEN
2441: x_return_status := FND_API.G_RET_STS_ERROR;
2442: IF l_debug_level > 0 THEN

Line 2441: x_return_status := FND_API.G_RET_STS_ERROR;

2437: WHEN FND_API.G_EXC_ERROR THEN
2438: RAISE FND_API.G_EXC_ERROR;
2439:
2440: WHEN OTHERS THEN
2441: x_return_status := FND_API.G_RET_STS_ERROR;
2442: IF l_debug_level > 0 THEN
2443: oe_debug_pub.add( 'EXITING ERROR GET_CUST_PRODUCT_LINE_ID' ) ;
2444: END IF;
2445: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2445: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2441: x_return_status := FND_API.G_RET_STS_ERROR;
2442: IF l_debug_level > 0 THEN
2443: oe_debug_pub.add( 'EXITING ERROR GET_CUST_PRODUCT_LINE_ID' ) ;
2444: END IF;
2445: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2446: END Get_Cust_Product_Line_Id;
2447:
2448:
2449: PROCEDURE Get_Cust_Prod_RG

Line 2528: x_return_status := FND_API.G_RET_STS_SUCCESS;

2524: EXIT WHEN cust_cv%NOTFOUND;
2525: END LOOP;
2526: END IF;
2527: x_srv_cust_prod_tbl := OE_SERVICE_UTIL.l_srv_cust_prod_tbl;
2528: x_return_status := FND_API.G_RET_STS_SUCCESS;
2529: IF l_debug_level > 0 THEN
2530: oe_debug_pub.add( 'EXITING SUCCESS GET_CUST_PROD_RG' ) ;
2531: END IF;
2532:

Line 2535: x_return_status := FND_API.G_RET_STS_SUCCESS;

2531: END IF;
2532:
2533: Exception
2534: When others then
2535: x_return_status := FND_API.G_RET_STS_SUCCESS;
2536: IF l_debug_level > 0 THEN
2537: oe_debug_pub.add( 'EXITING ERROR GET_CUST_PROD_RG' ) ;
2538: END IF;
2539:

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

2562: -- Call Describe_Proc to check for the existance of the CRM's
2563: -- AVAILABLE_SERVICES API. If exists Then Call it else No Problem.
2564:
2565: /* OE_SERVICE_UTIL.CHECK_PROC('OKS_OMINT_PUB.OKS_AVAILABLE_SERVICES', l_return_status);
2566: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN */
2567:
2568: -- IF Get_Product_Status(515) IN ('I','S') THEN
2569:
2570: -- lkxu, for bug 1701377

Line 2618: x_return_status := FND_API.G_RET_STS_SUCCESS;

2614: IF l_debug_level > 0 THEN
2615: oe_debug_pub.add( ' CUSTOMER ID : ' || TO_CHAR ( P_SERVICE_REC.CUSTOMER_ID ) ) ;
2616: END IF;
2617:
2618: x_return_status := FND_API.G_RET_STS_SUCCESS;
2619: IF l_debug_level > 0 THEN
2620: oe_debug_pub.add( 'EXITING ERROR GET_AVAIL_SERVICE_RG' ) ;
2621: END IF;
2622: END IF;

Line 2626: x_return_status := FND_API.G_RET_STS_SUCCESS;

2622: END IF;
2623:
2624: Exception
2625: When others then
2626: x_return_status := FND_API.G_RET_STS_SUCCESS;
2627: IF l_debug_level > 0 THEN
2628: oe_debug_pub.add( 'EXITING ERROR GET_AVAIL_SERVICE_RG' ) ;
2629: END IF;
2630:

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

2743: IF p_x_line_tbl(i).item_type_code = 'SERVICE' AND
2744: p_x_line_tbl(i).service_reference_type_code = 'ORDER' AND
2745: p_x_line_tbl(i).service_reference_line_id is NOT NULL AND
2746: --lchen fix for bug 2017271
2747: p_x_line_tbl(i).service_reference_line_id <> FND_API.G_MISS_NUM AND
2748: ( p_x_line_tbl(i).operation = OE_GLOBALS.G_OPR_CREATE or
2749: p_x_line_tbl(i).operation= OE_GLOBALS.G_OPR_UPDATE) THEN
2750:
2751: IF l_debug_level > 0 THEN

Line 2825: WHEN FND_API.G_EXC_ERROR THEN

2821:
2822:
2823: EXCEPTION
2824:
2825: WHEN FND_API.G_EXC_ERROR THEN
2826:
2827: x_return_status := FND_API.G_RET_STS_ERROR;
2828:
2829: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2827: x_return_status := FND_API.G_RET_STS_ERROR;

2823: EXCEPTION
2824:
2825: WHEN FND_API.G_EXC_ERROR THEN
2826:
2827: x_return_status := FND_API.G_RET_STS_ERROR;
2828:
2829: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2830:
2831: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2829: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2825: WHEN FND_API.G_EXC_ERROR THEN
2826:
2827: x_return_status := FND_API.G_RET_STS_ERROR;
2828:
2829: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2830:
2831: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2832:
2833: WHEN OTHERS THEN

Line 2831: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2827: x_return_status := FND_API.G_RET_STS_ERROR;
2828:
2829: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2830:
2831: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2832:
2833: WHEN OTHERS THEN
2834:
2835: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2835: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2831: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2832:
2833: WHEN OTHERS THEN
2834:
2835: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2836: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2837: THEN
2838: OE_MSG_PUB.Add_Exc_Msg
2839: ( G_PKG_NAME

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

2862: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type
2863: := OE_ORDER_PUB.G_MISS_LINE_TBL;
2864: l_line_tbl OE_Order_PUB.Line_Tbl_Type
2865: := OE_ORDER_PUB.G_MISS_LINE_TBL;
2866: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2867: l_line_count NUMBER;
2868:
2869:
2870: l_inventory_item_id NUMBER;

Line 2905: x_return_status := FND_API.G_RET_STS_SUCCESS;

2901: /* 3128684 */
2902: IF l_debug_level > 0 THEN
2903: oe_debug_pub.add( 'DO NOT CASCADE SERVICES' , 2 ) ;
2904: END IF;
2905: x_return_status := FND_API.G_RET_STS_SUCCESS;
2906: RETURN;
2907: END IF;
2908: IF l_debug_level > 0 THEN
2909: oe_debug_pub.add( 'DO CASCADE SERVICES' , 2 ) ;

Line 2916: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2912: OE_Line_Util.Lock_Row( p_line_id => p_parent_line_id
2913: ,p_x_line_rec => l_parent_line_rec
2914: ,x_return_status => l_return_status);
2915:
2916: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2917: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2918: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2919: RAISE FND_API.G_EXC_ERROR;
2920: END IF;

Line 2917: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2913: ,p_x_line_rec => l_parent_line_rec
2914: ,x_return_status => l_return_status);
2915:
2916: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2917: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2918: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2919: RAISE FND_API.G_EXC_ERROR;
2920: END IF;
2921:

Line 2918: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2914: ,x_return_status => l_return_status);
2915:
2916: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2917: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2918: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2919: RAISE FND_API.G_EXC_ERROR;
2920: END IF;
2921:
2922: l_service_reference_line_id := l_parent_line_rec.service_reference_line_id;

Line 2919: RAISE FND_API.G_EXC_ERROR;

2915:
2916: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2917: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2918: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2919: RAISE FND_API.G_EXC_ERROR;
2920: END IF;
2921:
2922: l_service_reference_line_id := l_parent_line_rec.service_reference_line_id;
2923: l_inventory_item_id := l_parent_line_rec.inventory_item_id;

Line 3045: (P_validation_level => FND_API.G_VALID_LEVEL_NONE

3041:
3042: -- Call OE_Order_PVT.Process_order
3043:
3044: OE_ORDER_PVT.Lines
3045: (P_validation_level => FND_API.G_VALID_LEVEL_NONE
3046: ,p_control_rec => l_control_rec
3047: ,p_x_line_tbl => l_line_tbl
3048: ,p_x_old_line_tbl => l_old_line_tbl
3049: ,x_return_status => l_return_status);

Line 3051: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3047: ,p_x_line_tbl => l_line_tbl
3048: ,p_x_old_line_tbl => l_old_line_tbl
3049: ,x_return_status => l_return_status);
3050:
3051: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3052: IF l_debug_level > 0 THEN
3053: oe_debug_pub.add( 'INSIDE UNEXPECTED ERROR ' , 2 ) ;
3054: END IF;
3055: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3055: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3051: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3052: IF l_debug_level > 0 THEN
3053: oe_debug_pub.add( 'INSIDE UNEXPECTED ERROR ' , 2 ) ;
3054: END IF;
3055: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3056: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3057: IF l_debug_level > 0 THEN
3058: oe_debug_pub.add( 'INSIDE ERROR ' , 2 ) ;
3059: END IF;

Line 3056: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3052: IF l_debug_level > 0 THEN
3053: oe_debug_pub.add( 'INSIDE UNEXPECTED ERROR ' , 2 ) ;
3054: END IF;
3055: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3056: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3057: IF l_debug_level > 0 THEN
3058: oe_debug_pub.add( 'INSIDE ERROR ' , 2 ) ;
3059: END IF;
3060: RAISE FND_API.G_EXC_ERROR;

Line 3060: RAISE FND_API.G_EXC_ERROR;

3056: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3057: IF l_debug_level > 0 THEN
3058: oe_debug_pub.add( 'INSIDE ERROR ' , 2 ) ;
3059: END IF;
3060: RAISE FND_API.G_EXC_ERROR;
3061: END IF;
3062:
3063: /* jolin start: comment out nocopy for notification project
3064:

Line 3072: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3068: ,x_return_status => l_return_status
3069: ,p_line_tbl => l_line_tbl
3070: ,p_old_line_tbl => l_old_line_tbl);
3071:
3072: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3073: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3074: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3075: RAISE FND_API.G_EXC_ERROR;
3076: END IF;

Line 3073: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3069: ,p_line_tbl => l_line_tbl
3070: ,p_old_line_tbl => l_old_line_tbl);
3071:
3072: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3073: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3074: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3075: RAISE FND_API.G_EXC_ERROR;
3076: END IF;
3077: jolin end */

Line 3074: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3070: ,p_old_line_tbl => l_old_line_tbl);
3071:
3072: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3073: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3074: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3075: RAISE FND_API.G_EXC_ERROR;
3076: END IF;
3077: jolin end */
3078:

Line 3075: RAISE FND_API.G_EXC_ERROR;

3071:
3072: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3073: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3074: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3075: RAISE FND_API.G_EXC_ERROR;
3076: END IF;
3077: jolin end */
3078:
3079: -- Clear Table

Line 3088: WHEN FND_API.G_EXC_ERROR THEN

3084: END IF;
3085:
3086: EXCEPTION
3087:
3088: WHEN FND_API.G_EXC_ERROR THEN
3089: IF l_debug_level > 0 THEN
3090: oe_debug_pub.add( 'INSIDE EXCEPTION EXE ERROR ' , 1 ) ;
3091: END IF;
3092: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3092: x_return_status := FND_API.G_RET_STS_ERROR;

3088: WHEN FND_API.G_EXC_ERROR THEN
3089: IF l_debug_level > 0 THEN
3090: oe_debug_pub.add( 'INSIDE EXCEPTION EXE ERROR ' , 1 ) ;
3091: END IF;
3092: x_return_status := FND_API.G_RET_STS_ERROR;
3093:
3094: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3095: IF l_debug_level > 0 THEN
3096: oe_debug_pub.add( 'INSIDE EXCEPTION UNEXP ERROR ' , 1 ) ;

Line 3094: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3090: oe_debug_pub.add( 'INSIDE EXCEPTION EXE ERROR ' , 1 ) ;
3091: END IF;
3092: x_return_status := FND_API.G_RET_STS_ERROR;
3093:
3094: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3095: IF l_debug_level > 0 THEN
3096: oe_debug_pub.add( 'INSIDE EXCEPTION UNEXP ERROR ' , 1 ) ;
3097: END IF;
3098: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3098: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3094: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3095: IF l_debug_level > 0 THEN
3096: oe_debug_pub.add( 'INSIDE EXCEPTION UNEXP ERROR ' , 1 ) ;
3097: END IF;
3098: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3099:
3100: WHEN OTHERS THEN
3101:
3102: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3102: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3098: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3099:
3100: WHEN OTHERS THEN
3101:
3102: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3103: IF l_debug_level > 0 THEN
3104: oe_debug_pub.add( 'INSIDE EXCEPTION OTHER ERROR ' , 1 ) ;
3105: END IF;
3106: