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

Line 7: a number := fnd_api.g_miss_num;

3: rosetta_g_mistake_date date := to_date('01/01/+4713', 'MM/DD/SYYYY');
4: rosetta_g_miss_date date := to_date('01/01/-4712', 'MM/DD/SYYYY');
5:
6: function rosetta_g_miss_num_map(n number) return number as
7: a number := fnd_api.g_miss_num;
8: b number := 0-1962.0724;
9: begin
10: if n=a then return b; end if;
11: if n=b then return a; end if;

Line 18: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;

14:
15: -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
16: function rosetta_g_miss_date_in_map(d date) return date as
17: begin
18: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
19: return d;
20: end;
21:
22: procedure rosetta_table_copy_in_p2(t OUT NOCOPY aso_service_contracts_int.order_service_tbl_type, a0 JTF_NUMBER_TABLE

Line 165: , p5_a2 VARCHAR2 := fnd_api.g_miss_char

161: , x_return_status OUT NOCOPY VARCHAR2
162: , p6_a0 OUT NOCOPY JTF_NUMBER_TABLE
163: , p5_a0 NUMBER := 0-1962.0724
164: , p5_a1 NUMBER := 0-1962.0724
165: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
166: , p5_a3 DATE := fnd_api.g_miss_date
167: )
168: as
169: ddp_avail_service_rec aso_service_contracts_int.avail_service_rec_type;

Line 166: , p5_a3 DATE := fnd_api.g_miss_date

162: , p6_a0 OUT NOCOPY JTF_NUMBER_TABLE
163: , p5_a0 NUMBER := 0-1962.0724
164: , p5_a1 NUMBER := 0-1962.0724
165: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
166: , p5_a3 DATE := fnd_api.g_miss_date
167: )
168: as
169: ddp_avail_service_rec aso_service_contracts_int.avail_service_rec_type;
170: ddx_orderable_service_tbl aso_service_contracts_int.order_service_tbl_type;

Line 346: IF NOT FND_API.Compatible_API_Call ( l_api_version,

342: SAVEPOINT GET_SERVICES_PUB;
343:
344: aso_debug_pub.g_debug_flag := Aso_Quote_Util_Pvt.is_debug_enabled;
345: -- Standard call to check for call compatibility.
346: IF NOT FND_API.Compatible_API_Call ( l_api_version,
347: p_api_version_number,
348: l_api_name,
349: G_PKG_NAME)
350: THEN

Line 351: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

347: p_api_version_number,
348: l_api_name,
349: G_PKG_NAME)
350: THEN
351: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
352: END IF;
353:
354:
355: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 356: IF FND_API.to_Boolean( p_init_msg_list ) THEN

352: END IF;
353:
354:
355: -- Initialize message list if p_init_msg_list is set to TRUE.
356: IF FND_API.to_Boolean( p_init_msg_list ) THEN
357: FND_MSG_PUB.initialize;
358: END IF;
359:
360: -- Debug Message

Line 365: x_return_status := FND_API.G_RET_STS_SUCCESS;

361: ASO_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
362: 'Private API: ' || l_api_name || 'start');
363:
364: -- Initialize API return status to SUCCESS
365: x_return_status := FND_API.G_RET_STS_SUCCESS;
366:
367: --
368: -- API body
369: --

Line 381: RAISE FND_API.G_EXC_ERROR;

377: 'UT_CANNOT_GET_PROFILE_VALUE');
378: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
379: FND_MSG_PUB.ADD;
380: END IF;
381: RAISE FND_API.G_EXC_ERROR;
382: END IF;
383:
384:
385: x_item_number_tbl := JTF_VARCHAR2_TABLE_2000();

Line 407: p_init_msg_list => FND_API.G_TRUE,

403: aso_utility_pvt.print_login_info();
404:
405: oks_entitlements_pub.get_contracts(
406: p_api_version =>l_api_version,
407: p_init_msg_list => FND_API.G_TRUE,
408: p_inp_rec => l_inp_rec,
409: x_ent_contracts => l_contracts_tbl,
410: x_return_status => x_return_status,
411: x_msg_count => x_msg_count,

Line 420: IF x_return_status = FND_API.G_RET_STS_ERROR then

416: aso_debug_pub.add('ASO_Service_contracts_int_w: After Call to OKS entitlements get contracts: x_return_status '|| x_return_status, 1, 'N');
417: END IF;
418:
419: -- Check return status from the above procedure call
420: IF x_return_status = FND_API.G_RET_STS_ERROR then
421: raise FND_API.G_EXC_ERROR;
422: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
423: raise FND_API.G_EXC_UNEXPECTED_ERROR;
424: END IF;

Line 421: raise FND_API.G_EXC_ERROR;

417: END IF;
418:
419: -- Check return status from the above procedure call
420: IF x_return_status = FND_API.G_RET_STS_ERROR then
421: raise FND_API.G_EXC_ERROR;
422: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
423: raise FND_API.G_EXC_UNEXPECTED_ERROR;
424: END IF;
425:

Line 422: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

418:
419: -- Check return status from the above procedure call
420: IF x_return_status = FND_API.G_RET_STS_ERROR then
421: raise FND_API.G_EXC_ERROR;
422: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
423: raise FND_API.G_EXC_UNEXPECTED_ERROR;
424: END IF;
425:
426: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

Line 423: raise FND_API.G_EXC_UNEXPECTED_ERROR;

419: -- Check return status from the above procedure call
420: IF x_return_status = FND_API.G_RET_STS_ERROR then
421: raise FND_API.G_EXC_ERROR;
422: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
423: raise FND_API.G_EXC_UNEXPECTED_ERROR;
424: END IF;
425:
426: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
427: IF l_contracts_tbl IS NOT NULL THEN

Line 426: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

422: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
423: raise FND_API.G_EXC_UNEXPECTED_ERROR;
424: END IF;
425:
426: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
427: IF l_contracts_tbl IS NOT NULL THEN
428: IF l_contracts_tbl.count >0 THEN
429: x_item_number_tbl.extend(l_contracts_tbl.count);
430: x_item_desc_tbl.extend(l_contracts_tbl.count);

Line 448: IF l_return_status = FND_API.G_RET_STS_ERROR then

444: x_duration => x_duration_tbl(i),
445: x_timeunit => x_period_code_tbl(i),
446: x_return_status => l_return_status);
447: ASO_QUOTE_UTIL_PVT.Debug('Calling okc_time_util_pub.get_duration InstallBase');
448: IF l_return_status = FND_API.G_RET_STS_ERROR then
449: RAISE FND_API.G_EXC_ERROR;
450: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
451: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
452: END IF;

Line 449: RAISE FND_API.G_EXC_ERROR;

445: x_timeunit => x_period_code_tbl(i),
446: x_return_status => l_return_status);
447: ASO_QUOTE_UTIL_PVT.Debug('Calling okc_time_util_pub.get_duration InstallBase');
448: IF l_return_status = FND_API.G_RET_STS_ERROR then
449: RAISE FND_API.G_EXC_ERROR;
450: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
451: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
452: END IF;
453: END LOOP;

Line 450: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

446: x_return_status => l_return_status);
447: ASO_QUOTE_UTIL_PVT.Debug('Calling okc_time_util_pub.get_duration InstallBase');
448: IF l_return_status = FND_API.G_RET_STS_ERROR then
449: RAISE FND_API.G_EXC_ERROR;
450: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
451: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
452: END IF;
453: END LOOP;
454: END IF;

Line 451: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

447: ASO_QUOTE_UTIL_PVT.Debug('Calling okc_time_util_pub.get_duration InstallBase');
448: IF l_return_status = FND_API.G_RET_STS_ERROR then
449: RAISE FND_API.G_EXC_ERROR;
450: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
451: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
452: END IF;
453: END LOOP;
454: END IF;
455: END IF;

Line 532: p_init_msg_list => FND_API.G_FALSE,

528: ASO_QUOTE_UTIL_PVT.Debug('Current Org ID :' || l_current_org_id);
529:
530: Aso_Service_Contracts_Int.Get_Warranty(
531: p_api_version_number => l_api_version,
532: p_init_msg_list => FND_API.G_FALSE,
533: x_return_status => x_return_status,
534: x_msg_count => x_msg_count,
535: x_msg_data => x_msg_data,
536: --p_org_id => Fnd_Profile.value('ORG_ID'),

Line 549: IF x_return_status = FND_API.G_RET_STS_ERROR then

545: aso_debug_pub.add('ASO_Service_contracts_int_w: After Call to get_warranty: x_return_status '|| x_return_status, 1, 'N');
546: END IF;
547:
548: -- Check return status from the above procedure call
549: IF x_return_status = FND_API.G_RET_STS_ERROR then
550: raise FND_API.G_EXC_ERROR;
551: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
552: raise FND_API.G_EXC_UNEXPECTED_ERROR;
553: END IF;

Line 550: raise FND_API.G_EXC_ERROR;

546: END IF;
547:
548: -- Check return status from the above procedure call
549: IF x_return_status = FND_API.G_RET_STS_ERROR then
550: raise FND_API.G_EXC_ERROR;
551: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
552: raise FND_API.G_EXC_UNEXPECTED_ERROR;
553: END IF;
554:

Line 551: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

547:
548: -- Check return status from the above procedure call
549: IF x_return_status = FND_API.G_RET_STS_ERROR then
550: raise FND_API.G_EXC_ERROR;
551: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
552: raise FND_API.G_EXC_UNEXPECTED_ERROR;
553: END IF;
554:
555: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

Line 552: raise FND_API.G_EXC_UNEXPECTED_ERROR;

548: -- Check return status from the above procedure call
549: IF x_return_status = FND_API.G_RET_STS_ERROR then
550: raise FND_API.G_EXC_ERROR;
551: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
552: raise FND_API.G_EXC_UNEXPECTED_ERROR;
553: END IF;
554:
555: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
556: IF l_warranty_tbl IS NOT NULL THEN

Line 555: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

551: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
552: raise FND_API.G_EXC_UNEXPECTED_ERROR;
553: END IF;
554:
555: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
556: IF l_warranty_tbl IS NOT NULL THEN
557: IF l_warranty_tbl.count >0 THEN
558: x_item_number_tbl.extend(l_warranty_tbl.count);
559: x_item_desc_tbl.extend(l_warranty_tbl.count);

Line 588: WHEN FND_API.G_EXC_ERROR THEN

584: --disable the debug message
585: ASO_QUOTE_UTIL_PVT.Debug('aso_service_contracts_int_w.getServices END....');
586: ASO_Quote_Util_Pvt.disable_debug_pvt;
587: EXCEPTION
588: WHEN FND_API.G_EXC_ERROR THEN
589: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
590: P_API_NAME => L_API_NAME
591: ,P_PKG_NAME => G_PKG_NAME
592: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 598: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

594: ,X_MSG_COUNT => X_MSG_COUNT
595: ,X_MSG_DATA => X_MSG_DATA
596: ,X_RETURN_STATUS => X_RETURN_STATUS);
597: ASO_Quote_Util_Pvt.disable_debug_pvt;
598: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
599: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
600: P_API_NAME => L_API_NAME
601: ,P_PKG_NAME => G_PKG_NAME
602: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 648: IF NOT FND_API.Compatible_API_Call ( l_api_version,

644: ASO_QUOTE_UTIL_PVT.Debug('aso_service_contracts_int_w.is_service_available BEGIN....');
645:
646: aso_debug_pub.g_debug_flag := Aso_Quote_Util_Pvt.is_debug_enabled;
647: -- Standard call to check for call compatibility.
648: IF NOT FND_API.Compatible_API_Call ( l_api_version,
649: p_api_version_number,
650: l_api_name,
651: G_PKG_NAME)
652: THEN

Line 653: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

649: p_api_version_number,
650: l_api_name,
651: G_PKG_NAME)
652: THEN
653: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
654: END IF;
655:
656:
657: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 658: IF FND_API.to_Boolean( p_init_msg_list ) THEN

654: END IF;
655:
656:
657: -- Initialize message list if p_init_msg_list is set to TRUE.
658: IF FND_API.to_Boolean( p_init_msg_list ) THEN
659: FND_MSG_PUB.initialize;
660: END IF;
661:
662: -- Initialize API return status to SUCCESS

Line 663: x_return_status := FND_API.G_RET_STS_SUCCESS;

659: FND_MSG_PUB.initialize;
660: END IF;
661:
662: -- Initialize API return status to SUCCESS
663: x_return_status := FND_API.G_RET_STS_SUCCESS;
664:
665: --
666: -- API body
667: --

Line 696: WHEN FND_API.G_EXC_ERROR THEN

692: ASO_Quote_Util_Pvt.disable_debug_pvt;
693:
694:
695: EXCEPTION
696: WHEN FND_API.G_EXC_ERROR THEN
697: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
698: P_API_NAME => L_API_NAME
699: ,P_PKG_NAME => G_PKG_NAME
700: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 706: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

702: ,X_MSG_COUNT => X_MSG_COUNT
703: ,X_MSG_DATA => X_MSG_DATA
704: ,X_RETURN_STATUS => X_RETURN_STATUS);
705: ASO_Quote_Util_Pvt.disable_debug_pvt;
706: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
707: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
708: P_API_NAME => L_API_NAME
709: ,P_PKG_NAME => G_PKG_NAME
710: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 744: , p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR

740: , x_Service_duration_period_code OUT NOCOPY JTF_VARCHAR2_TABLE_1000
741: , x_Shippable_item_flag OUT NOCOPY JTF_VARCHAR2_TABLE_100
742: , x_Returnable_flag OUT NOCOPY JTF_VARCHAR2_TABLE_100
743: , p_api_version_number IN NUMBER
744: , p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR
745: , p_commit IN VARCHAR2:= FND_API.g_false
746: , p_search_input IN VARCHAR2 := FND_API.G_MISS_CHAR
747: , p_product_item_id IN Number := FND_API.G_MISS_NUM
748: , p_customer_id IN Number := FND_API.G_MISS_NUM

Line 745: , p_commit IN VARCHAR2:= FND_API.g_false

741: , x_Shippable_item_flag OUT NOCOPY JTF_VARCHAR2_TABLE_100
742: , x_Returnable_flag OUT NOCOPY JTF_VARCHAR2_TABLE_100
743: , p_api_version_number IN NUMBER
744: , p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR
745: , p_commit IN VARCHAR2:= FND_API.g_false
746: , p_search_input IN VARCHAR2 := FND_API.G_MISS_CHAR
747: , p_product_item_id IN Number := FND_API.G_MISS_NUM
748: , p_customer_id IN Number := FND_API.G_MISS_NUM
749: , p_product_revision IN Varchar2 := FND_API.G_MISS_CHAR

Line 746: , p_search_input IN VARCHAR2 := FND_API.G_MISS_CHAR

742: , x_Returnable_flag OUT NOCOPY JTF_VARCHAR2_TABLE_100
743: , p_api_version_number IN NUMBER
744: , p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR
745: , p_commit IN VARCHAR2:= FND_API.g_false
746: , p_search_input IN VARCHAR2 := FND_API.G_MISS_CHAR
747: , p_product_item_id IN Number := FND_API.G_MISS_NUM
748: , p_customer_id IN Number := FND_API.G_MISS_NUM
749: , p_product_revision IN Varchar2 := FND_API.G_MISS_CHAR
750: , p_request_date IN Date := FND_API.G_MISS_DATE

Line 747: , p_product_item_id IN Number := FND_API.G_MISS_NUM

743: , p_api_version_number IN NUMBER
744: , p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR
745: , p_commit IN VARCHAR2:= FND_API.g_false
746: , p_search_input IN VARCHAR2 := FND_API.G_MISS_CHAR
747: , p_product_item_id IN Number := FND_API.G_MISS_NUM
748: , p_customer_id IN Number := FND_API.G_MISS_NUM
749: , p_product_revision IN Varchar2 := FND_API.G_MISS_CHAR
750: , p_request_date IN Date := FND_API.G_MISS_DATE
751: , x_return_status OUT NOCOPY VARCHAR2

Line 748: , p_customer_id IN Number := FND_API.G_MISS_NUM

744: , p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR
745: , p_commit IN VARCHAR2:= FND_API.g_false
746: , p_search_input IN VARCHAR2 := FND_API.G_MISS_CHAR
747: , p_product_item_id IN Number := FND_API.G_MISS_NUM
748: , p_customer_id IN Number := FND_API.G_MISS_NUM
749: , p_product_revision IN Varchar2 := FND_API.G_MISS_CHAR
750: , p_request_date IN Date := FND_API.G_MISS_DATE
751: , x_return_status OUT NOCOPY VARCHAR2
752: , x_msg_count OUT NOCOPY NUMBER

Line 749: , p_product_revision IN Varchar2 := FND_API.G_MISS_CHAR

745: , p_commit IN VARCHAR2:= FND_API.g_false
746: , p_search_input IN VARCHAR2 := FND_API.G_MISS_CHAR
747: , p_product_item_id IN Number := FND_API.G_MISS_NUM
748: , p_customer_id IN Number := FND_API.G_MISS_NUM
749: , p_product_revision IN Varchar2 := FND_API.G_MISS_CHAR
750: , p_request_date IN Date := FND_API.G_MISS_DATE
751: , x_return_status OUT NOCOPY VARCHAR2
752: , x_msg_count OUT NOCOPY NUMBER
753: , x_msg_data OUT NOCOPY VARCHAR2)

Line 750: , p_request_date IN Date := FND_API.G_MISS_DATE

746: , p_search_input IN VARCHAR2 := FND_API.G_MISS_CHAR
747: , p_product_item_id IN Number := FND_API.G_MISS_NUM
748: , p_customer_id IN Number := FND_API.G_MISS_NUM
749: , p_product_revision IN Varchar2 := FND_API.G_MISS_CHAR
750: , p_request_date IN Date := FND_API.G_MISS_DATE
751: , x_return_status OUT NOCOPY VARCHAR2
752: , x_msg_count OUT NOCOPY NUMBER
753: , x_msg_data OUT NOCOPY VARCHAR2)
754:

Line 777: IF NOT FND_API.Compatible_API_Call ( l_api_version,

773:
774:
775: aso_debug_pub.g_debug_flag := Aso_Quote_Util_Pvt.is_debug_enabled;
776: -- Standard call to check for call compatibility.
777: IF NOT FND_API.Compatible_API_Call ( l_api_version,
778: p_api_version_number,
779: l_api_name,
780: G_PKG_NAME)
781: THEN

Line 782: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

778: p_api_version_number,
779: l_api_name,
780: G_PKG_NAME)
781: THEN
782: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
783: END IF;
784:
785:
786: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 787: IF FND_API.to_Boolean( p_init_msg_list ) THEN

783: END IF;
784:
785:
786: -- Initialize message list if p_init_msg_list is set to TRUE.
787: IF FND_API.to_Boolean( p_init_msg_list ) THEN
788: FND_MSG_PUB.initialize;
789: END IF;
790:
791: -- Initialize API return status to SUCCESS

Line 792: x_return_status := FND_API.G_RET_STS_SUCCESS;

788: FND_MSG_PUB.initialize;
789: END IF;
790:
791: -- Initialize API return status to SUCCESS
792: x_return_status := FND_API.G_RET_STS_SUCCESS;
793:
794: SAVEPOINT AVAILABLE_SERVICES_PUB;
795:
796:

Line 839: IF x_return_status = FND_API.G_RET_STS_ERROR then

835: END IF;
836:
837:
838: -- Check return status from the above procedure call
839: IF x_return_status = FND_API.G_RET_STS_ERROR then
840: raise FND_API.G_EXC_ERROR;
841: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
842: raise FND_API.G_EXC_UNEXPECTED_ERROR;
843: END IF;

Line 840: raise FND_API.G_EXC_ERROR;

836:
837:
838: -- Check return status from the above procedure call
839: IF x_return_status = FND_API.G_RET_STS_ERROR then
840: raise FND_API.G_EXC_ERROR;
841: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
842: raise FND_API.G_EXC_UNEXPECTED_ERROR;
843: END IF;
844:

Line 841: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

837:
838: -- Check return status from the above procedure call
839: IF x_return_status = FND_API.G_RET_STS_ERROR then
840: raise FND_API.G_EXC_ERROR;
841: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
842: raise FND_API.G_EXC_UNEXPECTED_ERROR;
843: END IF;
844:
845: -- initialize the record structures

Line 842: raise FND_API.G_EXC_UNEXPECTED_ERROR;

838: -- Check return status from the above procedure call
839: IF x_return_status = FND_API.G_RET_STS_ERROR then
840: raise FND_API.G_EXC_ERROR;
841: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
842: raise FND_API.G_EXC_UNEXPECTED_ERROR;
843: END IF;
844:
845: -- initialize the record structures
846: x_Inventory_organization_id := JTF_NUMBER_TABLE();

Line 865: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

861: aso_debug_pub.ADD ( 'Number of Records Returned from OKC API : '|| to_char(l_orderable_service_tbl.count) , 1 , 'Y' );
862: END IF;
863:
864:
865: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
866: IF l_orderable_service_tbl IS NOT NULL THEN
867: IF l_orderable_service_tbl.count >0 THEN
868:
869: ASO_QUOTE_UTIL_PVT.Debug('Extending the jtf tables ');

Line 925: WHEN FND_API.G_EXC_ERROR THEN

921: ASO_Quote_Util_Pvt.disable_debug_pvt;
922:
923:
924: EXCEPTION
925: WHEN FND_API.G_EXC_ERROR THEN
926: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
927: P_API_NAME => L_API_NAME
928: ,P_PKG_NAME => G_PKG_NAME
929: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 935: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

931: ,X_MSG_COUNT => X_MSG_COUNT
932: ,X_MSG_DATA => X_MSG_DATA
933: ,X_RETURN_STATUS => X_RETURN_STATUS);
934: ASO_Quote_Util_Pvt.disable_debug_pvt;
935: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
936: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
937: P_API_NAME => L_API_NAME
938: ,P_PKG_NAME => G_PKG_NAME
939: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR