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

Line 21: P_init_msg_list IN Varchar2 := FND_API.G_FALSE,

17:
18: Procedure Get_service_attributes
19: (
20: P_Api_Version_Number IN Number,
21: P_init_msg_list IN Varchar2 := FND_API.G_FALSE,
22: P_Qte_Line_Rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
23: P_Qte_Line_Dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_tbl_Type,
24: X_msg_Count OUT NOCOPY /* file.sql.39 change */ Number,
25: X_msg_Data OUT NOCOPY /* file.sql.39 change */ Varchar2,

Line 87: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

83:
84: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
85:
86: -- Standard call to check for call compatibility.
87: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
88: p_api_version_number,
89: l_api_name,
90: G_PKG_NAME)
91: THEN

Line 92: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

88: p_api_version_number,
89: l_api_name,
90: G_PKG_NAME)
91: THEN
92: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
93: END IF;
94:
95:
96: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 97: IF FND_API.to_Boolean( p_init_msg_list )

93: END IF;
94:
95:
96: -- Initialize message list if p_init_msg_list is set to TRUE.
97: IF FND_API.to_Boolean( p_init_msg_list )
98: THEN
99: FND_MSG_PUB.initialize;
100: END IF;
101:

Line 105: x_return_status := FND_API.G_RET_STS_SUCCESS;

101:
102: -- Debug Message
103:
104: -- Initialize API return status to SUCCESS
105: x_return_status := FND_API.G_RET_STS_SUCCESS;
106:
107: --
108: -- API body
109: --

Line 122: RAISE FND_API.G_EXC_ERROR;

118: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
119: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
120: FND_MSG_PUB.ADD;
121: END IF;
122: RAISE FND_API.G_EXC_ERROR;
123: END IF;
124: OPEN C_cust_id(P_Qte_Line_rec.quote_header_id);
125: FETCH C_cust_id INTO l_cust_account_id;
126:

Line 151: x_return_status := FND_API.G_RET_STS_ERROR;

147: END IF;
148:
149: IF C_qln%NOTFOUND THEN
150: CLOSE C_qln;
151: x_return_status := FND_API.G_RET_STS_ERROR;
152: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
153: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_INFO');
154: FND_MESSAGE.Set_Token('COLUMN','SERVICE_REF_LINE_ID', FALSE);
155: FND_MSG_PUB.Add;

Line 157: raise FND_API.G_EXC_ERROR;

153: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_INFO');
154: FND_MESSAGE.Set_Token('COLUMN','SERVICE_REF_LINE_ID', FALSE);
155: FND_MSG_PUB.Add;
156: END IF;
157: raise FND_API.G_EXC_ERROR;
158: ELSE
159: CLOSE C_qln;
160: OPEN C_item1( l_inventory_item_id,l_organization_id);
161: FETCH C_item1 INTO l_serviceable_flag;

Line 169: x_return_status := FND_API.G_RET_STS_ERROR;

165: END IF;
166:
167: IF C_item1%NOTFOUND OR l_serviceable_flag <> 'Y' THEN
168: CLOSE C_item1;
169: x_return_status := FND_API.G_RET_STS_ERROR;
170: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
171: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_SRV_INFO1');
172: --FND_MESSAGE.Set_Token('COLUMN','SERVICE_REF_LINE_ID', FALSE);
173: FND_MSG_PUB.Add;

Line 175: raise FND_API.G_EXC_ERROR;

171: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_SRV_INFO1');
172: --FND_MESSAGE.Set_Token('COLUMN','SERVICE_REF_LINE_ID', FALSE);
173: FND_MSG_PUB.Add;
174: END IF;
175: raise FND_API.G_EXC_ERROR;
176:
177: END IF;
178: CLOSE C_item1;
179:

Line 211: x_return_status := FND_API.G_RET_STS_ERROR;

207: aso_debug_pub.add('Get Service Attr:ref code QUOTE after Is Service '||l_Available_YN);
208: END IF;
209:
210: IF l_Available_YN = 'N' THEN
211: x_return_status := FND_API.G_RET_STS_ERROR;
212: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
213: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_SRV_INFO2');
214: --FND_MESSAGE.Set_Token('COLUMN','SERVICE_REF_LINE_ID', FALSE);
215: FND_MSG_PUB.Add;

Line 217: raise FND_API.G_EXC_ERROR;

213: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_SRV_INFO2');
214: --FND_MESSAGE.Set_Token('COLUMN','SERVICE_REF_LINE_ID', FALSE);
215: FND_MSG_PUB.Add;
216: END IF;
217: raise FND_API.G_EXC_ERROR;
218: END IF;
219: END IF;
220: ELSIF P_Qte_Line_Dtl_tbl(i).SERVICE_REF_TYPE_CODE = 'CUSTOMER_PRODUCT' THEN
221:

Line 237: x_return_status := FND_API.G_RET_STS_ERROR;

233: OPEN C_cs_item( P_Qte_Line_Dtl_tbl(i).SERVICE_REF_LINE_ID, l_cs_org_id);
234: FETCH C_cs_item INTO l_inventory_item_id;
235: IF C_cs_item%NOTFOUND THEN
236: CLOSE C_cs_item;
237: x_return_status := FND_API.G_RET_STS_ERROR;
238: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
239: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_SRV_INFO3');
240: --FND_MESSAGE.Set_Token('COLUMN','INSTALLBASE', FALSE);
241: FND_MSG_PUB.Add;

Line 243: raise FND_API.G_EXC_ERROR;

239: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_SRV_INFO3');
240: --FND_MESSAGE.Set_Token('COLUMN','INSTALLBASE', FALSE);
241: FND_MSG_PUB.Add;
242: END IF;
243: raise FND_API.G_EXC_ERROR;
244: END IF;
245: CLOSE C_cs_item;
246: l_check_service_rec.product_item_id := l_inventory_item_id;
247: l_check_service_rec.service_item_id := P_Qte_Line_rec.inventory_item_id;

Line 259: x_return_status := FND_API.G_RET_STS_ERROR;

255: p_check_service_rec => l_check_service_rec,
256: X_Available_YN => l_Available_YN
257: );
258: IF l_Available_YN = 'N' THEN
259: x_return_status := FND_API.G_RET_STS_ERROR;
260: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
261: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_SRV_INFO2');
262: --FND_MESSAGE.Set_Token('COLUMN','SERVICE_REF_LINE_ID', FALSE);
263: FND_MSG_PUB.Add;

Line 265: raise FND_API.G_EXC_ERROR;

261: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_SRV_INFO2');
262: --FND_MESSAGE.Set_Token('COLUMN','SERVICE_REF_LINE_ID', FALSE);
263: FND_MSG_PUB.Add;
264: END IF;
265: raise FND_API.G_EXC_ERROR;
266: END IF;
267: -- END IF;
268: ELSIF P_Qte_Line_Dtl_tbl(i).SERVICE_REF_TYPE_CODE = 'ORDER' THEN
269:

Line 284: x_return_status := FND_API.G_RET_STS_ERROR;

280: OPEN C_ord_item( P_Qte_Line_Dtl_tbl(i).SERVICE_REF_LINE_ID);
281: FETCH C_ord_item INTO l_inventory_item_id;
282: IF C_ord_item%NOTFOUND THEN
283: CLOSE C_ord_item;
284: x_return_status := FND_API.G_RET_STS_ERROR;
285: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
286: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_SRV_INFO3');
287: --FND_MESSAGE.Set_Token('COLUMN','ORDER_LINE_ID', FALSE);
288: FND_MSG_PUB.Add;

Line 290: raise FND_API.G_EXC_ERROR;

286: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_SRV_INFO3');
287: --FND_MESSAGE.Set_Token('COLUMN','ORDER_LINE_ID', FALSE);
288: FND_MSG_PUB.Add;
289: END IF;
290: raise FND_API.G_EXC_ERROR;
291: END IF;
292: CLOSE C_ord_item;
293: l_check_service_rec.product_item_id := l_inventory_item_id;
294: l_check_service_rec.service_item_id := P_Qte_Line_rec.inventory_item_id;

Line 306: x_return_status := FND_API.G_RET_STS_ERROR;

302: p_check_service_rec => l_check_service_rec,
303: X_Available_YN => l_Available_YN
304: );
305: IF l_Available_YN = 'N' THEN
306: x_return_status := FND_API.G_RET_STS_ERROR;
307: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
308: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_SRV_INFO2');
309: --FND_MESSAGE.Set_Token('COLUMN','SERVICE_REF_LINE_ID', FALSE);
310: FND_MSG_PUB.Add;

Line 312: raise FND_API.G_EXC_ERROR;

308: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_SRV_INFO2');
309: --FND_MESSAGE.Set_Token('COLUMN','SERVICE_REF_LINE_ID', FALSE);
310: FND_MSG_PUB.Add;
311: END IF;
312: raise FND_API.G_EXC_ERROR;
313: END IF;
314: --END IF;
315: END IF;-- If Service_ref_type_code
316:

Line 324: IF x_return_status = FND_API.G_RET_STS_ERROR then

320:
321:
322:
323: -- Check return status from the above procedure call
324: IF x_return_status = FND_API.G_RET_STS_ERROR then
325: raise FND_API.G_EXC_ERROR;
326: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
327: raise FND_API.G_EXC_UNEXPECTED_ERROR;
328: END IF;

Line 325: raise FND_API.G_EXC_ERROR;

321:
322:
323: -- Check return status from the above procedure call
324: IF x_return_status = FND_API.G_RET_STS_ERROR then
325: raise FND_API.G_EXC_ERROR;
326: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
327: raise FND_API.G_EXC_UNEXPECTED_ERROR;
328: END IF;
329:

Line 326: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

322:
323: -- Check return status from the above procedure call
324: IF x_return_status = FND_API.G_RET_STS_ERROR then
325: raise FND_API.G_EXC_ERROR;
326: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
327: raise FND_API.G_EXC_UNEXPECTED_ERROR;
328: END IF;
329:
330: --

Line 327: raise FND_API.G_EXC_UNEXPECTED_ERROR;

323: -- Check return status from the above procedure call
324: IF x_return_status = FND_API.G_RET_STS_ERROR then
325: raise FND_API.G_EXC_ERROR;
326: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
327: raise FND_API.G_EXC_UNEXPECTED_ERROR;
328: END IF;
329:
330: --
331: -- End of API body.

Line 335: IF FND_API.to_Boolean( p_commit )

331: -- End of API body.
332: --
333:
334: /* -- Standard check for p_commit
335: IF FND_API.to_Boolean( p_commit )
336: THEN
337: COMMIT WORK;
338: END IF;
339: */

Line 350: WHEN FND_API.G_EXC_ERROR THEN

346: p_data => x_msg_data
347: );
348:
349: EXCEPTION
350: WHEN FND_API.G_EXC_ERROR THEN
351: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
352: P_API_NAME => L_API_NAME
353: ,P_PKG_NAME => G_PKG_NAME
354: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 362: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

358: ,X_MSG_COUNT => X_MSG_COUNT
359: ,X_MSG_DATA => X_MSG_DATA
360: ,X_RETURN_STATUS => X_RETURN_STATUS);
361:
362: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
363: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
364: P_API_NAME => L_API_NAME
365: ,P_PKG_NAME => G_PKG_NAME
366: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 394: P_init_msg_list IN Varchar2 := FND_API.G_FALSE,

390:
391: Procedure Get_Duration
392: (
393: P_Api_Version_Number IN Number,
394: P_init_msg_list IN Varchar2 := FND_API.G_FALSE,
395: X_msg_Count OUT NOCOPY /* file.sql.39 change */ Number,
396: X_msg_Data OUT NOCOPY /* file.sql.39 change */ Varchar2,
397: X_Return_Status OUT NOCOPY /* file.sql.39 change */ Varchar2,
398: P_customer_id IN Number,

Line 402: P_coterm_checked_yn IN Varchar2 := FND_API.G_FALSE,

398: P_customer_id IN Number,
399: P_system_id IN Number,
400: P_Service_Duration IN Number,
401: P_service_period IN Varchar2,
402: P_coterm_checked_yn IN Varchar2 := FND_API.G_FALSE,
403: P_start_date IN Date,
404: P_end_date IN Date,
405: X_service_duration OUT NOCOPY /* file.sql.39 change */ Number,
406: X_service_period OUT NOCOPY /* file.sql.39 change */ Varchar2,

Line 421: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

417:
418: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
419:
420: -- Standard call to check for call compatibility.
421: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
422: p_api_version_number,
423: l_api_name,
424: G_PKG_NAME)
425: THEN

Line 426: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

422: p_api_version_number,
423: l_api_name,
424: G_PKG_NAME)
425: THEN
426: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
427: END IF;
428:
429:
430: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 431: IF FND_API.to_Boolean( p_init_msg_list )

427: END IF;
428:
429:
430: -- Initialize message list if p_init_msg_list is set to TRUE.
431: IF FND_API.to_Boolean( p_init_msg_list )
432: THEN
433: FND_MSG_PUB.initialize;
434: END IF;
435:

Line 438: x_return_status := FND_API.G_RET_STS_SUCCESS;

434: END IF;
435:
436:
437: -- Initialize API return status to SUCCESS
438: x_return_status := FND_API.G_RET_STS_SUCCESS;
439:
440: --
441: -- API body
442: --

Line 455: RAISE FND_API.G_EXC_ERROR;

451: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
452: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
453: FND_MSG_PUB.ADD;
454: END IF;
455: RAISE FND_API.G_EXC_ERROR;
456: END IF;
457:
458: IF aso_debug_pub.g_debug_flag = 'Y' THEN
459:

Line 503: IF x_return_status = FND_API.G_RET_STS_ERROR then

499: END IF;
500:
501:
502: -- Check return status from the above procedure call
503: IF x_return_status = FND_API.G_RET_STS_ERROR then
504: raise FND_API.G_EXC_ERROR;
505: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
506: raise FND_API.G_EXC_UNEXPECTED_ERROR;
507: END IF;

Line 504: raise FND_API.G_EXC_ERROR;

500:
501:
502: -- Check return status from the above procedure call
503: IF x_return_status = FND_API.G_RET_STS_ERROR then
504: raise FND_API.G_EXC_ERROR;
505: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
506: raise FND_API.G_EXC_UNEXPECTED_ERROR;
507: END IF;
508:

Line 505: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

501:
502: -- Check return status from the above procedure call
503: IF x_return_status = FND_API.G_RET_STS_ERROR then
504: raise FND_API.G_EXC_ERROR;
505: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
506: raise FND_API.G_EXC_UNEXPECTED_ERROR;
507: END IF;
508:
509: --

Line 506: raise FND_API.G_EXC_UNEXPECTED_ERROR;

502: -- Check return status from the above procedure call
503: IF x_return_status = FND_API.G_RET_STS_ERROR then
504: raise FND_API.G_EXC_ERROR;
505: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
506: raise FND_API.G_EXC_UNEXPECTED_ERROR;
507: END IF;
508:
509: --
510: -- End of API body.

Line 514: IF FND_API.to_Boolean( p_commit )

510: -- End of API body.
511: --
512:
513: /* -- Standard check for p_commit
514: IF FND_API.to_Boolean( p_commit )
515: THEN
516: COMMIT WORK;
517: END IF;
518: */

Line 529: WHEN FND_API.G_EXC_ERROR THEN

525: p_data => x_msg_data
526: );
527:
528: EXCEPTION
529: WHEN FND_API.G_EXC_ERROR THEN
530: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
531: P_API_NAME => L_API_NAME
532: ,P_PKG_NAME => G_PKG_NAME
533: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 539: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

535: ,X_MSG_COUNT => X_MSG_COUNT
536: ,X_MSG_DATA => X_MSG_DATA
537: ,X_RETURN_STATUS => X_RETURN_STATUS);
538:
539: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
540: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
541: P_API_NAME => L_API_NAME
542: ,P_PKG_NAME => G_PKG_NAME
543: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 566: P_init_msg_list IN Varchar2 := FND_API.G_FALSE,

562:
563: Procedure Is_Service_Available
564: (
565: P_Api_Version_Number IN Number,
566: P_init_msg_list IN Varchar2 := FND_API.G_FALSE,
567: X_msg_Count OUT NOCOPY /* file.sql.39 change */ Number,
568: X_msg_Data OUT NOCOPY /* file.sql.39 change */ Varchar2,
569: X_Return_Status OUT NOCOPY /* file.sql.39 change */ Varchar2,
570: p_check_service_rec IN CHECK_SERVICE_REC_TYPE,

Line 585: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

581:
582: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
583:
584: -- Standard call to check for call compatibility.
585: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
586: p_api_version_number,
587: l_api_name,
588: G_PKG_NAME)
589: THEN

Line 590: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

586: p_api_version_number,
587: l_api_name,
588: G_PKG_NAME)
589: THEN
590: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
591: END IF;
592:
593:
594: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 595: IF FND_API.to_Boolean( p_init_msg_list )

591: END IF;
592:
593:
594: -- Initialize message list if p_init_msg_list is set to TRUE.
595: IF FND_API.to_Boolean( p_init_msg_list )
596: THEN
597: FND_MSG_PUB.initialize;
598: END IF;
599:

Line 602: x_return_status := FND_API.G_RET_STS_SUCCESS;

598: END IF;
599:
600:
601: -- Initialize API return status to SUCCESS
602: x_return_status := FND_API.G_RET_STS_SUCCESS;
603:
604: --
605: -- API body
606: --

Line 619: RAISE FND_API.G_EXC_ERROR;

615: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
616: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
617: FND_MSG_PUB.ADD;
618: END IF;
619: RAISE FND_API.G_EXC_ERROR;
620: END IF;
621:
622: IF aso_debug_pub.g_debug_flag = 'Y' THEN
623:

Line 634: IF p_check_service_rec.product_item_id = FND_API.G_MISS_NUM THEN

630: END IF;
631:
632:
633: -- map quote rec to oks record type
634: IF p_check_service_rec.product_item_id = FND_API.G_MISS_NUM THEN
635: l_check_service_rec.product_item_id := NULL;
636: ELSE
637: l_check_service_rec.product_item_id := p_check_service_rec.product_item_id;
638: END IF;

Line 639: IF p_check_service_rec.customer_id = FND_API.G_MISS_NUM THEN

635: l_check_service_rec.product_item_id := NULL;
636: ELSE
637: l_check_service_rec.product_item_id := p_check_service_rec.product_item_id;
638: END IF;
639: IF p_check_service_rec.customer_id = FND_API.G_MISS_NUM THEN
640: l_check_service_rec.customer_id := NULL;
641: ELSE
642: l_check_service_rec.customer_id := p_check_service_rec.customer_id;
643: END IF;

Line 644: IF p_check_service_rec.service_item_id = FND_API.G_MISS_NUM THEN

640: l_check_service_rec.customer_id := NULL;
641: ELSE
642: l_check_service_rec.customer_id := p_check_service_rec.customer_id;
643: END IF;
644: IF p_check_service_rec.service_item_id = FND_API.G_MISS_NUM THEN
645: l_check_service_rec.service_item_id := NULL;
646: ELSE
647: l_check_service_rec.service_item_id := p_check_service_rec.service_item_id;
648: END IF;

Line 649: IF p_check_service_rec.product_revision = FND_API.G_MISS_CHAR THEN

645: l_check_service_rec.service_item_id := NULL;
646: ELSE
647: l_check_service_rec.service_item_id := p_check_service_rec.service_item_id;
648: END IF;
649: IF p_check_service_rec.product_revision = FND_API.G_MISS_CHAR THEN
650: l_check_service_rec.product_revision := NULL;
651: ELSE
652: l_check_service_rec.product_revision := p_check_service_rec.product_revision;
653: END IF;

Line 654: IF p_check_service_rec.request_date = FND_API.G_MISS_DATE THEN

650: l_check_service_rec.product_revision := NULL;
651: ELSE
652: l_check_service_rec.product_revision := p_check_service_rec.product_revision;
653: END IF;
654: IF p_check_service_rec.request_date = FND_API.G_MISS_DATE THEN
655: l_check_service_rec.request_date := NULL;
656: ELSE
657: l_check_service_rec.request_date := p_check_service_rec.request_date;
658: END IF;

Line 689: IF x_return_status = FND_API.G_RET_STS_ERROR then

685: END IF;
686:
687:
688: -- Check return status from the above procedure call
689: IF x_return_status = FND_API.G_RET_STS_ERROR then
690: raise FND_API.G_EXC_ERROR;
691: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
692: raise FND_API.G_EXC_UNEXPECTED_ERROR;
693: END IF;

Line 690: raise FND_API.G_EXC_ERROR;

686:
687:
688: -- Check return status from the above procedure call
689: IF x_return_status = FND_API.G_RET_STS_ERROR then
690: raise FND_API.G_EXC_ERROR;
691: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
692: raise FND_API.G_EXC_UNEXPECTED_ERROR;
693: END IF;
694:

Line 691: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

687:
688: -- Check return status from the above procedure call
689: IF x_return_status = FND_API.G_RET_STS_ERROR then
690: raise FND_API.G_EXC_ERROR;
691: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
692: raise FND_API.G_EXC_UNEXPECTED_ERROR;
693: END IF;
694:
695: --

Line 692: raise FND_API.G_EXC_UNEXPECTED_ERROR;

688: -- Check return status from the above procedure call
689: IF x_return_status = FND_API.G_RET_STS_ERROR then
690: raise FND_API.G_EXC_ERROR;
691: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
692: raise FND_API.G_EXC_UNEXPECTED_ERROR;
693: END IF;
694:
695: --
696: -- End of API body.

Line 700: IF FND_API.to_Boolean( p_commit )

696: -- End of API body.
697: --
698:
699: /* -- Standard check for p_commit
700: IF FND_API.to_Boolean( p_commit )
701: THEN
702: COMMIT WORK;
703: END IF;
704: */

Line 714: WHEN FND_API.G_EXC_ERROR THEN

710: p_data => x_msg_data
711: );
712:
713: EXCEPTION
714: WHEN FND_API.G_EXC_ERROR THEN
715: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
716: P_API_NAME => L_API_NAME
717: ,P_PKG_NAME => G_PKG_NAME
718: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 724: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

720: ,X_MSG_COUNT => X_MSG_COUNT
721: ,X_MSG_DATA => X_MSG_DATA
722: ,X_RETURN_STATUS => X_RETURN_STATUS);
723:
724: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
725: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
726: P_API_NAME => L_API_NAME
727: ,P_PKG_NAME => G_PKG_NAME
728: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 749: P_init_msg_list IN Varchar2 := FND_API.G_FALSE,

745:
746:
747: PROCEDURE Available_Services(
748: P_Api_Version_number IN Number,
749: P_init_msg_list IN Varchar2 := FND_API.G_FALSE,
750: X_msg_Count OUT NOCOPY /* file.sql.39 change */ Number,
751: X_msg_Data OUT NOCOPY /* file.sql.39 change */ Varchar2,
752: X_Return_Status OUT NOCOPY /* file.sql.39 change */ Varchar2,
753: p_avail_service_rec IN AVAIL_SERVICE_REC_TYPE,

Line 771: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

767:
768: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
769:
770: -- Standard call to check for call compatibility.
771: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
772: p_api_version_number,
773: l_api_name,
774: G_PKG_NAME)
775: THEN

Line 776: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

772: p_api_version_number,
773: l_api_name,
774: G_PKG_NAME)
775: THEN
776: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
777: END IF;
778:
779:
780: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 781: IF FND_API.to_Boolean( p_init_msg_list )

777: END IF;
778:
779:
780: -- Initialize message list if p_init_msg_list is set to TRUE.
781: IF FND_API.to_Boolean( p_init_msg_list )
782: THEN
783: FND_MSG_PUB.initialize;
784: END IF;
785:

Line 788: x_return_status := FND_API.G_RET_STS_SUCCESS;

784: END IF;
785:
786:
787: -- Initialize API return status to SUCCESS
788: x_return_status := FND_API.G_RET_STS_SUCCESS;
789:
790: --
791: -- API body
792: --

Line 805: RAISE FND_API.G_EXC_ERROR;

801: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
802: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
803: FND_MSG_PUB.ADD;
804: END IF;
805: RAISE FND_API.G_EXC_ERROR;
806: END IF;
807:
808: -- map service rec type
809: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 818: IF p_avail_service_rec.PRODUCT_ITEM_ID = FND_API.G_MISS_NUM THEN

814: aso_debug_pub.add('ASO_SER_INT:available_service: p_avail_service_rec.REQUEST_DATE '|| p_avail_service_rec.REQUEST_DATE, 1, 'N');
815:
816: END IF;
817:
818: IF p_avail_service_rec.PRODUCT_ITEM_ID = FND_API.G_MISS_NUM THEN
819: l_avail_service_rec.PRODUCT_ITEM_ID := NULL;
820: ELSE
821: l_avail_service_rec.PRODUCT_ITEM_ID := p_avail_service_rec.PRODUCT_ITEM_ID;
822: END IF;

Line 823: IF p_avail_service_rec.CUSTOMER_ID = FND_API.G_MISS_NUM THEN

819: l_avail_service_rec.PRODUCT_ITEM_ID := NULL;
820: ELSE
821: l_avail_service_rec.PRODUCT_ITEM_ID := p_avail_service_rec.PRODUCT_ITEM_ID;
822: END IF;
823: IF p_avail_service_rec.CUSTOMER_ID = FND_API.G_MISS_NUM THEN
824: l_avail_service_rec.CUSTOMER_ID := NULL;
825: ELSE
826: l_avail_service_rec.CUSTOMER_ID := p_avail_service_rec.CUSTOMER_ID;
827: END IF;

Line 828: IF p_avail_service_rec.PRODUCT_REVISION = FND_API.G_MISS_CHAR THEN

824: l_avail_service_rec.CUSTOMER_ID := NULL;
825: ELSE
826: l_avail_service_rec.CUSTOMER_ID := p_avail_service_rec.CUSTOMER_ID;
827: END IF;
828: IF p_avail_service_rec.PRODUCT_REVISION = FND_API.G_MISS_CHAR THEN
829: l_avail_service_rec.PRODUCT_REVISION := NULL;
830: ELSE
831: l_avail_service_rec.PRODUCT_REVISION := p_avail_service_rec.PRODUCT_REVISION;
832: END IF;

Line 833: IF p_avail_service_rec.request_date = FND_API.G_MISS_DATE THEN

829: l_avail_service_rec.PRODUCT_REVISION := NULL;
830: ELSE
831: l_avail_service_rec.PRODUCT_REVISION := p_avail_service_rec.PRODUCT_REVISION;
832: END IF;
833: IF p_avail_service_rec.request_date = FND_API.G_MISS_DATE THEN
834: l_avail_service_rec.request_date := NULL;
835: ELSE
836: l_avail_service_rec.request_date := p_avail_service_rec.request_date;
837: END IF;

Line 865: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

861: aso_debug_pub.add('ASO_SER_INT:After Call to OKS available_service: x_return_status '|| X_return_status, 1, 'Y');
862: aso_utility_pvt.print_login_info();
863: END IF;
864:
865: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
866: FOR i in 1..l_Orderable_Service_tbl.count LOOP
867: x_orderable_service_tbl(i).service_item_id := l_Orderable_Service_tbl(i).service_item_id;
868: END LOOP;
869: END IF;

Line 873: IF x_return_status = FND_API.G_RET_STS_ERROR then

869: END IF;
870:
871:
872: -- Check return status from the above procedure call
873: IF x_return_status = FND_API.G_RET_STS_ERROR then
874: raise FND_API.G_EXC_ERROR;
875: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
876: raise FND_API.G_EXC_UNEXPECTED_ERROR;
877: END IF;

Line 874: raise FND_API.G_EXC_ERROR;

870:
871:
872: -- Check return status from the above procedure call
873: IF x_return_status = FND_API.G_RET_STS_ERROR then
874: raise FND_API.G_EXC_ERROR;
875: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
876: raise FND_API.G_EXC_UNEXPECTED_ERROR;
877: END IF;
878:

Line 875: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

871:
872: -- Check return status from the above procedure call
873: IF x_return_status = FND_API.G_RET_STS_ERROR then
874: raise FND_API.G_EXC_ERROR;
875: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
876: raise FND_API.G_EXC_UNEXPECTED_ERROR;
877: END IF;
878:
879: --

Line 876: raise FND_API.G_EXC_UNEXPECTED_ERROR;

872: -- Check return status from the above procedure call
873: IF x_return_status = FND_API.G_RET_STS_ERROR then
874: raise FND_API.G_EXC_ERROR;
875: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
876: raise FND_API.G_EXC_UNEXPECTED_ERROR;
877: END IF;
878:
879: --
880: -- End of API body.

Line 884: IF FND_API.to_Boolean( p_commit )

880: -- End of API body.
881: --
882:
883: /* -- Standard check for p_commit
884: IF FND_API.to_Boolean( p_commit )
885: THEN
886: COMMIT WORK;
887: END IF;
888: */

Line 899: WHEN FND_API.G_EXC_ERROR THEN

895: p_data => x_msg_data
896: );
897:
898: EXCEPTION
899: WHEN FND_API.G_EXC_ERROR THEN
900: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
901: P_API_NAME => L_API_NAME
902: ,P_PKG_NAME => G_PKG_NAME
903: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 909: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

905: ,X_MSG_COUNT => X_MSG_COUNT
906: ,X_MSG_DATA => X_MSG_DATA
907: ,X_RETURN_STATUS => X_RETURN_STATUS);
908:
909: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
910: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
911: P_API_NAME => L_API_NAME
912: ,P_PKG_NAME => G_PKG_NAME
913: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 934: P_init_msg_list IN Varchar2 := FND_API.G_FALSE,

930:
931:
932: Procedure Get_Warranty (
933: P_Api_Version_Number IN Number,
934: P_init_msg_list IN Varchar2 := FND_API.G_FALSE,
935: X_msg_Count OUT NOCOPY /* file.sql.39 change */ Number,
936: X_msg_Data OUT NOCOPY /* file.sql.39 change */ Varchar2,
937: P_Org_id IN Number,
938: P_Organization_id IN NUMBER := null,

Line 969: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

965:
966: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
967:
968: -- Standard call to check for call compatibility.
969: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
970: p_api_version_number,
971: l_api_name,
972: G_PKG_NAME)
973: THEN

Line 974: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

970: p_api_version_number,
971: l_api_name,
972: G_PKG_NAME)
973: THEN
974: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
975: END IF;
976:
977:
978: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 979: IF FND_API.to_Boolean( p_init_msg_list )

975: END IF;
976:
977:
978: -- Initialize message list if p_init_msg_list is set to TRUE.
979: IF FND_API.to_Boolean( p_init_msg_list )
980: THEN
981: FND_MSG_PUB.initialize;
982: END IF;
983:

Line 986: x_return_status := FND_API.G_RET_STS_SUCCESS;

982: END IF;
983:
984:
985: -- Initialize API return status to SUCCESS
986: x_return_status := FND_API.G_RET_STS_SUCCESS;
987:
988: --
989: -- API body
990: --

Line 1003: RAISE FND_API.G_EXC_ERROR;

999: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
1000: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
1001: FND_MSG_PUB.ADD;
1002: END IF;
1003: RAISE FND_API.G_EXC_ERROR;
1004: END IF;
1005:
1006: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1007: aso_debug_pub.add('Before Call to OKS_EXTWAR_UTIL_PUB.Get_Warranty_info', 1, 'Y');

Line 1013: P_init_msg_list => FND_API.G_FALSE,

1009: END IF;
1010:
1011: OKS_EXTWAR_UTIL_PUB.Get_Warranty_info(
1012: P_Api_Version => 1.0 ,
1013: P_init_msg_list => FND_API.G_FALSE,
1014: P_Org_id => P_Org_id ,
1015: P_prod_item_id => P_product_item_id ,
1016: X_Return_Status => X_return_status ,
1017: X_msg_Count => X_msg_count ,

Line 1046: -- raise FND_API.G_EXC_ERROR;

1042: X_Warranty_tbl(i).Warranty_End_Date := l_Warranty_tbl(i).Warranty_End_Date;
1043: X_Warranty_tbl(i).service_description := l_description;
1044: X_Warranty_tbl(i).service_name := l_concatenated_segments;
1045: ELSE
1046: -- raise FND_API.G_EXC_ERROR;
1047: CLOSE C_warranty;
1048: END IF;
1049: END IF;
1050: END LOOP;

Line 1054: IF x_return_status = FND_API.G_RET_STS_ERROR then

1050: END LOOP;
1051:
1052:
1053: -- Check return status from the above procedure call
1054: IF x_return_status = FND_API.G_RET_STS_ERROR then
1055: raise FND_API.G_EXC_ERROR;
1056: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1057: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1058: END IF;

Line 1055: raise FND_API.G_EXC_ERROR;

1051:
1052:
1053: -- Check return status from the above procedure call
1054: IF x_return_status = FND_API.G_RET_STS_ERROR then
1055: raise FND_API.G_EXC_ERROR;
1056: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1057: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1058: END IF;
1059:

Line 1056: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

1052:
1053: -- Check return status from the above procedure call
1054: IF x_return_status = FND_API.G_RET_STS_ERROR then
1055: raise FND_API.G_EXC_ERROR;
1056: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1057: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1058: END IF;
1059:
1060: --

Line 1057: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1053: -- Check return status from the above procedure call
1054: IF x_return_status = FND_API.G_RET_STS_ERROR then
1055: raise FND_API.G_EXC_ERROR;
1056: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1057: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1058: END IF;
1059:
1060: --
1061: -- End of API body.

Line 1072: WHEN FND_API.G_EXC_ERROR THEN

1068: p_data => x_msg_data
1069: );
1070:
1071: EXCEPTION
1072: WHEN FND_API.G_EXC_ERROR THEN
1073: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1074: P_API_NAME => L_API_NAME
1075: ,P_PKG_NAME => G_PKG_NAME
1076: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 1082: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1078: ,X_MSG_COUNT => X_MSG_COUNT
1079: ,X_MSG_DATA => X_MSG_DATA
1080: ,X_RETURN_STATUS => X_RETURN_STATUS);
1081:
1082: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1083: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1084: P_API_NAME => L_API_NAME
1085: ,P_PKG_NAME => G_PKG_NAME
1086: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR