80: BEGIN
81: -- Standard Start of API savepoint
82: SAVEPOINT GET_SERVICE_ATTRIBUTES_PVT;
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,
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:
127: IF aso_debug_pub.g_debug_flag = 'Y' THEN
128: aso_debug_pub.add('Get Service Attr: cust Acct id'||l_cust_account_id);
129: END IF;
130:
131: IF C_cust_id%NOTFOUND THEN
124: OPEN C_cust_id(P_Qte_Line_rec.quote_header_id);
125: FETCH C_cust_id INTO l_cust_account_id;
126:
127: IF aso_debug_pub.g_debug_flag = 'Y' THEN
128: aso_debug_pub.add('Get Service Attr: cust Acct id'||l_cust_account_id);
129: END IF;
130:
131: IF C_cust_id%NOTFOUND THEN
132: l_cust_account_id := NULL;
137: IF P_Qte_Line_Dtl_tbl(i).SERVICE_REF_TYPE_CODE = 'QUOTE' THEN
138: OPEN C_qln( P_Qte_Line_Dtl_tbl(i).service_ref_line_id);
139: FETCH C_qln INTO l_inventory_item_id,l_organization_id,l_cust_account_id;
140:
141: IF aso_debug_pub.g_debug_flag = 'Y' THEN
142:
143: aso_debug_pub.add('Get Service Attr:ref code QUOTE inv id '||l_inventory_item_id, 1, 'Y');
144: aso_debug_pub.add('Get Service Attr:ref code QUOTE orgnization id '||l_organization_id , 1, 'Y');
145: aso_debug_pub.add('Get Service Attr:ref code QUOTE cust id '||l_cust_account_id, 1, 'Y');
139: FETCH C_qln INTO l_inventory_item_id,l_organization_id,l_cust_account_id;
140:
141: IF aso_debug_pub.g_debug_flag = 'Y' THEN
142:
143: aso_debug_pub.add('Get Service Attr:ref code QUOTE inv id '||l_inventory_item_id, 1, 'Y');
144: aso_debug_pub.add('Get Service Attr:ref code QUOTE orgnization id '||l_organization_id , 1, 'Y');
145: aso_debug_pub.add('Get Service Attr:ref code QUOTE cust id '||l_cust_account_id, 1, 'Y');
146:
147: END IF;
140:
141: IF aso_debug_pub.g_debug_flag = 'Y' THEN
142:
143: aso_debug_pub.add('Get Service Attr:ref code QUOTE inv id '||l_inventory_item_id, 1, 'Y');
144: aso_debug_pub.add('Get Service Attr:ref code QUOTE orgnization id '||l_organization_id , 1, 'Y');
145: aso_debug_pub.add('Get Service Attr:ref code QUOTE cust id '||l_cust_account_id, 1, 'Y');
146:
147: END IF;
148:
141: IF aso_debug_pub.g_debug_flag = 'Y' THEN
142:
143: aso_debug_pub.add('Get Service Attr:ref code QUOTE inv id '||l_inventory_item_id, 1, 'Y');
144: aso_debug_pub.add('Get Service Attr:ref code QUOTE orgnization id '||l_organization_id , 1, 'Y');
145: aso_debug_pub.add('Get Service Attr:ref code QUOTE cust id '||l_cust_account_id, 1, 'Y');
146:
147: END IF;
148:
149: IF C_qln%NOTFOUND THEN
159: CLOSE C_qln;
160: OPEN C_item1( l_inventory_item_id,l_organization_id);
161: FETCH C_item1 INTO l_serviceable_flag;
162:
163: IF aso_debug_pub.g_debug_flag = 'Y' THEN
164: aso_debug_pub.add('Get Service Attr:ref code QUOTE serviceable flag '||l_serviceable_flag, 1, 'Y');
165: END IF;
166:
167: IF C_item1%NOTFOUND OR l_serviceable_flag <> 'Y' THEN
160: OPEN C_item1( l_inventory_item_id,l_organization_id);
161: FETCH C_item1 INTO l_serviceable_flag;
162:
163: IF aso_debug_pub.g_debug_flag = 'Y' THEN
164: aso_debug_pub.add('Get Service Attr:ref code QUOTE serviceable flag '||l_serviceable_flag, 1, 'Y');
165: END IF;
166:
167: IF C_item1%NOTFOUND OR l_serviceable_flag <> 'Y' THEN
168: CLOSE C_item1;
176:
177: END IF;
178: CLOSE C_item1;
179:
180: IF aso_debug_pub.g_debug_flag = 'Y' THEN
181:
182: aso_debug_pub.add('Get Service Attr:product_item_id '||l_inventory_item_id, 1, 'Y');
183: aso_debug_pub.add('Get Service Attr:service_item_id '||P_Qte_Line_rec.inventory_item_id, 1, 'Y');
184: aso_debug_pub.add('Get Service Attr:customer_id '||l_cust_account_id, 1, 'Y');
178: CLOSE C_item1;
179:
180: IF aso_debug_pub.g_debug_flag = 'Y' THEN
181:
182: aso_debug_pub.add('Get Service Attr:product_item_id '||l_inventory_item_id, 1, 'Y');
183: aso_debug_pub.add('Get Service Attr:service_item_id '||P_Qte_Line_rec.inventory_item_id, 1, 'Y');
184: aso_debug_pub.add('Get Service Attr:customer_id '||l_cust_account_id, 1, 'Y');
185:
186: END IF;
179:
180: IF aso_debug_pub.g_debug_flag = 'Y' THEN
181:
182: aso_debug_pub.add('Get Service Attr:product_item_id '||l_inventory_item_id, 1, 'Y');
183: aso_debug_pub.add('Get Service Attr:service_item_id '||P_Qte_Line_rec.inventory_item_id, 1, 'Y');
184: aso_debug_pub.add('Get Service Attr:customer_id '||l_cust_account_id, 1, 'Y');
185:
186: END IF;
187:
180: IF aso_debug_pub.g_debug_flag = 'Y' THEN
181:
182: aso_debug_pub.add('Get Service Attr:product_item_id '||l_inventory_item_id, 1, 'Y');
183: aso_debug_pub.add('Get Service Attr:service_item_id '||P_Qte_Line_rec.inventory_item_id, 1, 'Y');
184: aso_debug_pub.add('Get Service Attr:customer_id '||l_cust_account_id, 1, 'Y');
185:
186: END IF;
187:
188: l_check_service_rec.product_item_id := l_inventory_item_id;
188: l_check_service_rec.product_item_id := l_inventory_item_id;
189: l_check_service_rec.service_item_id := P_Qte_Line_rec.inventory_item_id;
190: l_check_service_rec.customer_id := l_cust_account_id;
191:
192: IF aso_debug_pub.g_debug_flag = 'Y' THEN
193: aso_debug_pub.add('Get Service Attr:ref code QUOTE before Is Service '||l_serviceable_flag, 1, 'Y');
194: END IF;
195:
196: ASO_SERVICE_CONTRACTS_INT.Is_Service_Available(
189: l_check_service_rec.service_item_id := P_Qte_Line_rec.inventory_item_id;
190: l_check_service_rec.customer_id := l_cust_account_id;
191:
192: IF aso_debug_pub.g_debug_flag = 'Y' THEN
193: aso_debug_pub.add('Get Service Attr:ref code QUOTE before Is Service '||l_serviceable_flag, 1, 'Y');
194: END IF;
195:
196: ASO_SERVICE_CONTRACTS_INT.Is_Service_Available(
197: P_Api_Version_Number => P_Api_Version_Number ,
202: p_check_service_rec => l_check_service_rec,
203: X_Available_YN => l_Available_YN
204: );
205:
206: IF aso_debug_pub.g_debug_flag = 'Y' THEN
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
203: X_Available_YN => l_Available_YN
204: );
205:
206: IF aso_debug_pub.g_debug_flag = 'Y' THEN
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;
218: END IF;
219: END IF;
220: ELSIF P_Qte_Line_Dtl_tbl(i).SERVICE_REF_TYPE_CODE = 'CUSTOMER_PRODUCT' THEN
221:
222: IF aso_debug_pub.g_debug_flag = 'Y' THEN
223:
224: aso_debug_pub.add('Get Service Attr:SERVICE_REF_TYPE_CODE CUSTOMER_PRODUCT');
225: aso_debug_pub.add('Get Service Attr: CUSTOMER_PRODUCT inv id'||P_Qte_Line_rec.inventory_item_id);
226: aso_debug_pub.add('Get Service Attr: CUSTOMER_PRODUCT organization id'||P_Qte_Line_rec.organization_id);
220: ELSIF P_Qte_Line_Dtl_tbl(i).SERVICE_REF_TYPE_CODE = 'CUSTOMER_PRODUCT' THEN
221:
222: IF aso_debug_pub.g_debug_flag = 'Y' THEN
223:
224: aso_debug_pub.add('Get Service Attr:SERVICE_REF_TYPE_CODE CUSTOMER_PRODUCT');
225: aso_debug_pub.add('Get Service Attr: CUSTOMER_PRODUCT inv id'||P_Qte_Line_rec.inventory_item_id);
226: aso_debug_pub.add('Get Service Attr: CUSTOMER_PRODUCT organization id'||P_Qte_Line_rec.organization_id);
227: aso_debug_pub.add('Get Service Attr: CUSTOMER_PRODUCT service ref line id'||P_Qte_Line_Dtl_tbl(i).SERVICE_REF_LINE_ID, 1, 'Y');
228:
221:
222: IF aso_debug_pub.g_debug_flag = 'Y' THEN
223:
224: aso_debug_pub.add('Get Service Attr:SERVICE_REF_TYPE_CODE CUSTOMER_PRODUCT');
225: aso_debug_pub.add('Get Service Attr: CUSTOMER_PRODUCT inv id'||P_Qte_Line_rec.inventory_item_id);
226: aso_debug_pub.add('Get Service Attr: CUSTOMER_PRODUCT organization id'||P_Qte_Line_rec.organization_id);
227: aso_debug_pub.add('Get Service Attr: CUSTOMER_PRODUCT service ref line id'||P_Qte_Line_Dtl_tbl(i).SERVICE_REF_LINE_ID, 1, 'Y');
228:
229: END IF;
222: IF aso_debug_pub.g_debug_flag = 'Y' THEN
223:
224: aso_debug_pub.add('Get Service Attr:SERVICE_REF_TYPE_CODE CUSTOMER_PRODUCT');
225: aso_debug_pub.add('Get Service Attr: CUSTOMER_PRODUCT inv id'||P_Qte_Line_rec.inventory_item_id);
226: aso_debug_pub.add('Get Service Attr: CUSTOMER_PRODUCT organization id'||P_Qte_Line_rec.organization_id);
227: aso_debug_pub.add('Get Service Attr: CUSTOMER_PRODUCT service ref line id'||P_Qte_Line_Dtl_tbl(i).SERVICE_REF_LINE_ID, 1, 'Y');
228:
229: END IF;
230:
223:
224: aso_debug_pub.add('Get Service Attr:SERVICE_REF_TYPE_CODE CUSTOMER_PRODUCT');
225: aso_debug_pub.add('Get Service Attr: CUSTOMER_PRODUCT inv id'||P_Qte_Line_rec.inventory_item_id);
226: aso_debug_pub.add('Get Service Attr: CUSTOMER_PRODUCT organization id'||P_Qte_Line_rec.organization_id);
227: aso_debug_pub.add('Get Service Attr: CUSTOMER_PRODUCT service ref line id'||P_Qte_Line_Dtl_tbl(i).SERVICE_REF_LINE_ID, 1, 'Y');
228:
229: END IF;
230:
231: l_cs_org_id := cs_std.get_item_valdn_orgzn_id;
266: END IF;
267: -- END IF;
268: ELSIF P_Qte_Line_Dtl_tbl(i).SERVICE_REF_TYPE_CODE = 'ORDER' THEN
269:
270: IF aso_debug_pub.g_debug_flag = 'Y' THEN
271:
272: aso_debug_pub.add('Get Service Attr:SERVICE_REF_TYPE_CODE ORDER', 1, 'Y');
273: aso_debug_pub.add('Get Service Attr: ORDER inv id'||P_Qte_Line_rec.inventory_item_id, 1, 'Y');
274: aso_debug_pub.add('Get Service Attr: ORDER organization id'||P_Qte_Line_rec.organization_id, 1, 'Y');
268: ELSIF P_Qte_Line_Dtl_tbl(i).SERVICE_REF_TYPE_CODE = 'ORDER' THEN
269:
270: IF aso_debug_pub.g_debug_flag = 'Y' THEN
271:
272: aso_debug_pub.add('Get Service Attr:SERVICE_REF_TYPE_CODE ORDER', 1, 'Y');
273: aso_debug_pub.add('Get Service Attr: ORDER inv id'||P_Qte_Line_rec.inventory_item_id, 1, 'Y');
274: aso_debug_pub.add('Get Service Attr: ORDER organization id'||P_Qte_Line_rec.organization_id, 1, 'Y');
275: aso_debug_pub.add('Get Service Attr: ORDER service ref line id'||P_Qte_Line_Dtl_tbl(i).SERVICE_REF_LINE_ID, 1, 'Y');
276:
269:
270: IF aso_debug_pub.g_debug_flag = 'Y' THEN
271:
272: aso_debug_pub.add('Get Service Attr:SERVICE_REF_TYPE_CODE ORDER', 1, 'Y');
273: aso_debug_pub.add('Get Service Attr: ORDER inv id'||P_Qte_Line_rec.inventory_item_id, 1, 'Y');
274: aso_debug_pub.add('Get Service Attr: ORDER organization id'||P_Qte_Line_rec.organization_id, 1, 'Y');
275: aso_debug_pub.add('Get Service Attr: ORDER service ref line id'||P_Qte_Line_Dtl_tbl(i).SERVICE_REF_LINE_ID, 1, 'Y');
276:
277: END IF;
270: IF aso_debug_pub.g_debug_flag = 'Y' THEN
271:
272: aso_debug_pub.add('Get Service Attr:SERVICE_REF_TYPE_CODE ORDER', 1, 'Y');
273: aso_debug_pub.add('Get Service Attr: ORDER inv id'||P_Qte_Line_rec.inventory_item_id, 1, 'Y');
274: aso_debug_pub.add('Get Service Attr: ORDER organization id'||P_Qte_Line_rec.organization_id, 1, 'Y');
275: aso_debug_pub.add('Get Service Attr: ORDER service ref line id'||P_Qte_Line_Dtl_tbl(i).SERVICE_REF_LINE_ID, 1, 'Y');
276:
277: END IF;
278:
271:
272: aso_debug_pub.add('Get Service Attr:SERVICE_REF_TYPE_CODE ORDER', 1, 'Y');
273: aso_debug_pub.add('Get Service Attr: ORDER inv id'||P_Qte_Line_rec.inventory_item_id, 1, 'Y');
274: aso_debug_pub.add('Get Service Attr: ORDER organization id'||P_Qte_Line_rec.organization_id, 1, 'Y');
275: aso_debug_pub.add('Get Service Attr: ORDER service ref line id'||P_Qte_Line_Dtl_tbl(i).SERVICE_REF_LINE_ID, 1, 'Y');
276:
277: END IF;
278:
279:
414: BEGIN
415: -- Standard Start of API savepoint
416: SAVEPOINT GET_DURATION_PUB;
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,
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:
460: aso_utility_pvt.print_login_info();
461: aso_debug_pub.add('ASO_service_contracts_INT.Get_Duration: Before call OKS_OMINT_PUB.Get Duration.',1,'Y');
462: aso_debug_pub.add('Get Duration: p_customer_id: '||p_customer_id, 1, 'Y');
457:
458: IF aso_debug_pub.g_debug_flag = 'Y' THEN
459:
460: aso_utility_pvt.print_login_info();
461: aso_debug_pub.add('ASO_service_contracts_INT.Get_Duration: Before call OKS_OMINT_PUB.Get Duration.',1,'Y');
462: aso_debug_pub.add('Get Duration: p_customer_id: '||p_customer_id, 1, 'Y');
463: aso_debug_pub.add('Get Duration: p_system_id: '||p_system_id, 1, 'Y');
464: aso_debug_pub.add('Get Duration: p_service_duration: '||p_service_duration, 1, 'Y');
465: aso_debug_pub.add('Get Duration: p_service_period: '||p_service_period, 1, 'Y');
458: IF aso_debug_pub.g_debug_flag = 'Y' THEN
459:
460: aso_utility_pvt.print_login_info();
461: aso_debug_pub.add('ASO_service_contracts_INT.Get_Duration: Before call OKS_OMINT_PUB.Get Duration.',1,'Y');
462: aso_debug_pub.add('Get Duration: p_customer_id: '||p_customer_id, 1, 'Y');
463: aso_debug_pub.add('Get Duration: p_system_id: '||p_system_id, 1, 'Y');
464: aso_debug_pub.add('Get Duration: p_service_duration: '||p_service_duration, 1, 'Y');
465: aso_debug_pub.add('Get Duration: p_service_period: '||p_service_period, 1, 'Y');
466: aso_debug_pub.add('Get Duration: p_coterm_checked_yn: '||p_coterm_checked_yn, 1, 'Y');
459:
460: aso_utility_pvt.print_login_info();
461: aso_debug_pub.add('ASO_service_contracts_INT.Get_Duration: Before call OKS_OMINT_PUB.Get Duration.',1,'Y');
462: aso_debug_pub.add('Get Duration: p_customer_id: '||p_customer_id, 1, 'Y');
463: aso_debug_pub.add('Get Duration: p_system_id: '||p_system_id, 1, 'Y');
464: aso_debug_pub.add('Get Duration: p_service_duration: '||p_service_duration, 1, 'Y');
465: aso_debug_pub.add('Get Duration: p_service_period: '||p_service_period, 1, 'Y');
466: aso_debug_pub.add('Get Duration: p_coterm_checked_yn: '||p_coterm_checked_yn, 1, 'Y');
467: aso_debug_pub.add('Get Duration: p_start_date: '||p_start_date, 1, 'Y');
460: aso_utility_pvt.print_login_info();
461: aso_debug_pub.add('ASO_service_contracts_INT.Get_Duration: Before call OKS_OMINT_PUB.Get Duration.',1,'Y');
462: aso_debug_pub.add('Get Duration: p_customer_id: '||p_customer_id, 1, 'Y');
463: aso_debug_pub.add('Get Duration: p_system_id: '||p_system_id, 1, 'Y');
464: aso_debug_pub.add('Get Duration: p_service_duration: '||p_service_duration, 1, 'Y');
465: aso_debug_pub.add('Get Duration: p_service_period: '||p_service_period, 1, 'Y');
466: aso_debug_pub.add('Get Duration: p_coterm_checked_yn: '||p_coterm_checked_yn, 1, 'Y');
467: aso_debug_pub.add('Get Duration: p_start_date: '||p_start_date, 1, 'Y');
468: aso_debug_pub.add('Get Duration: p_end_date: '||p_end_date, 1, 'Y');
461: aso_debug_pub.add('ASO_service_contracts_INT.Get_Duration: Before call OKS_OMINT_PUB.Get Duration.',1,'Y');
462: aso_debug_pub.add('Get Duration: p_customer_id: '||p_customer_id, 1, 'Y');
463: aso_debug_pub.add('Get Duration: p_system_id: '||p_system_id, 1, 'Y');
464: aso_debug_pub.add('Get Duration: p_service_duration: '||p_service_duration, 1, 'Y');
465: aso_debug_pub.add('Get Duration: p_service_period: '||p_service_period, 1, 'Y');
466: aso_debug_pub.add('Get Duration: p_coterm_checked_yn: '||p_coterm_checked_yn, 1, 'Y');
467: aso_debug_pub.add('Get Duration: p_start_date: '||p_start_date, 1, 'Y');
468: aso_debug_pub.add('Get Duration: p_end_date: '||p_end_date, 1, 'Y');
469:
462: aso_debug_pub.add('Get Duration: p_customer_id: '||p_customer_id, 1, 'Y');
463: aso_debug_pub.add('Get Duration: p_system_id: '||p_system_id, 1, 'Y');
464: aso_debug_pub.add('Get Duration: p_service_duration: '||p_service_duration, 1, 'Y');
465: aso_debug_pub.add('Get Duration: p_service_period: '||p_service_period, 1, 'Y');
466: aso_debug_pub.add('Get Duration: p_coterm_checked_yn: '||p_coterm_checked_yn, 1, 'Y');
467: aso_debug_pub.add('Get Duration: p_start_date: '||p_start_date, 1, 'Y');
468: aso_debug_pub.add('Get Duration: p_end_date: '||p_end_date, 1, 'Y');
469:
470: END IF;
463: aso_debug_pub.add('Get Duration: p_system_id: '||p_system_id, 1, 'Y');
464: aso_debug_pub.add('Get Duration: p_service_duration: '||p_service_duration, 1, 'Y');
465: aso_debug_pub.add('Get Duration: p_service_period: '||p_service_period, 1, 'Y');
466: aso_debug_pub.add('Get Duration: p_coterm_checked_yn: '||p_coterm_checked_yn, 1, 'Y');
467: aso_debug_pub.add('Get Duration: p_start_date: '||p_start_date, 1, 'Y');
468: aso_debug_pub.add('Get Duration: p_end_date: '||p_end_date, 1, 'Y');
469:
470: END IF;
471:
464: aso_debug_pub.add('Get Duration: p_service_duration: '||p_service_duration, 1, 'Y');
465: aso_debug_pub.add('Get Duration: p_service_period: '||p_service_period, 1, 'Y');
466: aso_debug_pub.add('Get Duration: p_coterm_checked_yn: '||p_coterm_checked_yn, 1, 'Y');
467: aso_debug_pub.add('Get Duration: p_start_date: '||p_start_date, 1, 'Y');
468: aso_debug_pub.add('Get Duration: p_end_date: '||p_end_date, 1, 'Y');
469:
470: END IF;
471:
472:
487: X_service_period => x_service_period ,
488: X_new_end_date => x_new_end_date) ;
489:
490:
491: IF aso_debug_pub.g_debug_flag = 'Y' THEN
492:
493: aso_debug_pub.add('Get Duration: After Call to OKS_OMINT_PUB.Get_Duration: X_return_status: '||X_return_status, 1, 'Y');
494: aso_debug_pub.add('Get Duration: x_service_duration: '||x_service_duration, 1, 'Y');
495: aso_debug_pub.add('Get Duration: x_service_period: '||x_service_period, 1, 'Y');
489:
490:
491: IF aso_debug_pub.g_debug_flag = 'Y' THEN
492:
493: aso_debug_pub.add('Get Duration: After Call to OKS_OMINT_PUB.Get_Duration: X_return_status: '||X_return_status, 1, 'Y');
494: aso_debug_pub.add('Get Duration: x_service_duration: '||x_service_duration, 1, 'Y');
495: aso_debug_pub.add('Get Duration: x_service_period: '||x_service_period, 1, 'Y');
496: aso_debug_pub.add('Get Duration: x_new_end_date: '||x_new_end_date, 1, 'Y');
497: aso_utility_pvt.print_login_info();
490:
491: IF aso_debug_pub.g_debug_flag = 'Y' THEN
492:
493: aso_debug_pub.add('Get Duration: After Call to OKS_OMINT_PUB.Get_Duration: X_return_status: '||X_return_status, 1, 'Y');
494: aso_debug_pub.add('Get Duration: x_service_duration: '||x_service_duration, 1, 'Y');
495: aso_debug_pub.add('Get Duration: x_service_period: '||x_service_period, 1, 'Y');
496: aso_debug_pub.add('Get Duration: x_new_end_date: '||x_new_end_date, 1, 'Y');
497: aso_utility_pvt.print_login_info();
498:
491: IF aso_debug_pub.g_debug_flag = 'Y' THEN
492:
493: aso_debug_pub.add('Get Duration: After Call to OKS_OMINT_PUB.Get_Duration: X_return_status: '||X_return_status, 1, 'Y');
494: aso_debug_pub.add('Get Duration: x_service_duration: '||x_service_duration, 1, 'Y');
495: aso_debug_pub.add('Get Duration: x_service_period: '||x_service_period, 1, 'Y');
496: aso_debug_pub.add('Get Duration: x_new_end_date: '||x_new_end_date, 1, 'Y');
497: aso_utility_pvt.print_login_info();
498:
499: END IF;
492:
493: aso_debug_pub.add('Get Duration: After Call to OKS_OMINT_PUB.Get_Duration: X_return_status: '||X_return_status, 1, 'Y');
494: aso_debug_pub.add('Get Duration: x_service_duration: '||x_service_duration, 1, 'Y');
495: aso_debug_pub.add('Get Duration: x_service_period: '||x_service_period, 1, 'Y');
496: aso_debug_pub.add('Get Duration: x_new_end_date: '||x_new_end_date, 1, 'Y');
497: aso_utility_pvt.print_login_info();
498:
499: END IF;
500:
578: BEGIN
579: -- Standard Start of API savepoint
580: SAVEPOINT IS_SERVICE_AVAILABLE_PUB;
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,
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:
624: aso_debug_pub.add('ASO_SER_INT:IS_service_available: p_check_service_rec.product_item_id '|| p_check_service_rec.product_item_id, 1, 'N');
625: aso_debug_pub.add('ASO_SER_INT:IS_service_available: p_check_service_rec.customer_id '|| p_check_service_rec.customer_id, 1, 'N');
626: aso_debug_pub.add('ASO_SER_INT:IS_service_available: p_check_service_rec.request_date '|| p_check_service_rec.request_date, 1, 'N');
620: END IF;
621:
622: IF aso_debug_pub.g_debug_flag = 'Y' THEN
623:
624: aso_debug_pub.add('ASO_SER_INT:IS_service_available: p_check_service_rec.product_item_id '|| p_check_service_rec.product_item_id, 1, 'N');
625: aso_debug_pub.add('ASO_SER_INT:IS_service_available: p_check_service_rec.customer_id '|| p_check_service_rec.customer_id, 1, 'N');
626: aso_debug_pub.add('ASO_SER_INT:IS_service_available: p_check_service_rec.request_date '|| p_check_service_rec.request_date, 1, 'N');
627: aso_debug_pub.add('ASO_SER_INT:IS_service_available: p_check_service_rec.service_item_id '|| p_check_service_rec.service_item_id, 1, 'N');
628: aso_debug_pub.add('ASO_SER_INT:IS_service_available: p_check_service_rec.product_revision '|| p_check_service_rec.product_revision, 1, 'N');
621:
622: IF aso_debug_pub.g_debug_flag = 'Y' THEN
623:
624: aso_debug_pub.add('ASO_SER_INT:IS_service_available: p_check_service_rec.product_item_id '|| p_check_service_rec.product_item_id, 1, 'N');
625: aso_debug_pub.add('ASO_SER_INT:IS_service_available: p_check_service_rec.customer_id '|| p_check_service_rec.customer_id, 1, 'N');
626: aso_debug_pub.add('ASO_SER_INT:IS_service_available: p_check_service_rec.request_date '|| p_check_service_rec.request_date, 1, 'N');
627: aso_debug_pub.add('ASO_SER_INT:IS_service_available: p_check_service_rec.service_item_id '|| p_check_service_rec.service_item_id, 1, 'N');
628: aso_debug_pub.add('ASO_SER_INT:IS_service_available: p_check_service_rec.product_revision '|| p_check_service_rec.product_revision, 1, 'N');
629:
622: IF aso_debug_pub.g_debug_flag = 'Y' THEN
623:
624: aso_debug_pub.add('ASO_SER_INT:IS_service_available: p_check_service_rec.product_item_id '|| p_check_service_rec.product_item_id, 1, 'N');
625: aso_debug_pub.add('ASO_SER_INT:IS_service_available: p_check_service_rec.customer_id '|| p_check_service_rec.customer_id, 1, 'N');
626: aso_debug_pub.add('ASO_SER_INT:IS_service_available: p_check_service_rec.request_date '|| p_check_service_rec.request_date, 1, 'N');
627: aso_debug_pub.add('ASO_SER_INT:IS_service_available: p_check_service_rec.service_item_id '|| p_check_service_rec.service_item_id, 1, 'N');
628: aso_debug_pub.add('ASO_SER_INT:IS_service_available: p_check_service_rec.product_revision '|| p_check_service_rec.product_revision, 1, 'N');
629:
630: END IF;
623:
624: aso_debug_pub.add('ASO_SER_INT:IS_service_available: p_check_service_rec.product_item_id '|| p_check_service_rec.product_item_id, 1, 'N');
625: aso_debug_pub.add('ASO_SER_INT:IS_service_available: p_check_service_rec.customer_id '|| p_check_service_rec.customer_id, 1, 'N');
626: aso_debug_pub.add('ASO_SER_INT:IS_service_available: p_check_service_rec.request_date '|| p_check_service_rec.request_date, 1, 'N');
627: aso_debug_pub.add('ASO_SER_INT:IS_service_available: p_check_service_rec.service_item_id '|| p_check_service_rec.service_item_id, 1, 'N');
628: aso_debug_pub.add('ASO_SER_INT:IS_service_available: p_check_service_rec.product_revision '|| p_check_service_rec.product_revision, 1, 'N');
629:
630: END IF;
631:
624: aso_debug_pub.add('ASO_SER_INT:IS_service_available: p_check_service_rec.product_item_id '|| p_check_service_rec.product_item_id, 1, 'N');
625: aso_debug_pub.add('ASO_SER_INT:IS_service_available: p_check_service_rec.customer_id '|| p_check_service_rec.customer_id, 1, 'N');
626: aso_debug_pub.add('ASO_SER_INT:IS_service_available: p_check_service_rec.request_date '|| p_check_service_rec.request_date, 1, 'N');
627: aso_debug_pub.add('ASO_SER_INT:IS_service_available: p_check_service_rec.service_item_id '|| p_check_service_rec.service_item_id, 1, 'N');
628: aso_debug_pub.add('ASO_SER_INT:IS_service_available: p_check_service_rec.product_revision '|| p_check_service_rec.product_revision, 1, 'N');
629:
630: END IF;
631:
632:
664: l_check_service_rec.product_revision:=p_check_service_rec.product_revision;
665: l_check_service_rec.request_date := p_check_service_rec.request_date;
666: */
667:
668: IF aso_debug_pub.g_debug_flag = 'Y' THEN
669: aso_debug_pub.add('Before Calling OKS_OMINT_PUB.Is_Service_Available ',1,'Y');
670: aso_utility_pvt.print_login_info();
671: END IF;
672:
665: l_check_service_rec.request_date := p_check_service_rec.request_date;
666: */
667:
668: IF aso_debug_pub.g_debug_flag = 'Y' THEN
669: aso_debug_pub.add('Before Calling OKS_OMINT_PUB.Is_Service_Available ',1,'Y');
670: aso_utility_pvt.print_login_info();
671: END IF;
672:
673: OKS_OMINT_PUB.Is_Service_Available(
678: X_Return_Status => X_return_status ,
679: p_check_service_rec => l_check_service_rec,
680: X_Available_YN => X_Available_YN );
681:
682: IF aso_debug_pub.g_debug_flag = 'Y' THEN
683: aso_debug_pub.add('After Calling OKS_OMINT_PUB.Is_Service_Available ',1,'Y');
684: aso_utility_pvt.print_login_info();
685: END IF;
686:
679: p_check_service_rec => l_check_service_rec,
680: X_Available_YN => X_Available_YN );
681:
682: IF aso_debug_pub.g_debug_flag = 'Y' THEN
683: aso_debug_pub.add('After Calling OKS_OMINT_PUB.Is_Service_Available ',1,'Y');
684: aso_utility_pvt.print_login_info();
685: END IF;
686:
687:
764: BEGIN
765: -- Standard Start of API savepoint
766: SAVEPOINT AVAILABLE_SERVICES_PUB;
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,
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
810:
811: aso_debug_pub.add('ASO_SER_INT:available_service: p_avail_service_rec.PRODUCT_ITEM_ID '|| p_avail_service_rec.PRODUCT_ITEM_ID, 1, 'N');
812: aso_debug_pub.add('ASO_SER_INT:available_service: p_avail_service_rec.CUSTOMER_ID '|| p_avail_service_rec.CUSTOMER_ID, 1, 'N');
813: aso_debug_pub.add('ASO_SER_INT:available_service: p_avail_service_rec.PRODUCT_REVISION '|| p_avail_service_rec.PRODUCT_REVISION, 1, 'N');
807:
808: -- map service rec type
809: IF aso_debug_pub.g_debug_flag = 'Y' THEN
810:
811: aso_debug_pub.add('ASO_SER_INT:available_service: p_avail_service_rec.PRODUCT_ITEM_ID '|| p_avail_service_rec.PRODUCT_ITEM_ID, 1, 'N');
812: aso_debug_pub.add('ASO_SER_INT:available_service: p_avail_service_rec.CUSTOMER_ID '|| p_avail_service_rec.CUSTOMER_ID, 1, 'N');
813: aso_debug_pub.add('ASO_SER_INT:available_service: p_avail_service_rec.PRODUCT_REVISION '|| p_avail_service_rec.PRODUCT_REVISION, 1, 'N');
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:
808: -- map service rec type
809: IF aso_debug_pub.g_debug_flag = 'Y' THEN
810:
811: aso_debug_pub.add('ASO_SER_INT:available_service: p_avail_service_rec.PRODUCT_ITEM_ID '|| p_avail_service_rec.PRODUCT_ITEM_ID, 1, 'N');
812: aso_debug_pub.add('ASO_SER_INT:available_service: p_avail_service_rec.CUSTOMER_ID '|| p_avail_service_rec.CUSTOMER_ID, 1, 'N');
813: aso_debug_pub.add('ASO_SER_INT:available_service: p_avail_service_rec.PRODUCT_REVISION '|| p_avail_service_rec.PRODUCT_REVISION, 1, 'N');
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;
809: IF aso_debug_pub.g_debug_flag = 'Y' THEN
810:
811: aso_debug_pub.add('ASO_SER_INT:available_service: p_avail_service_rec.PRODUCT_ITEM_ID '|| p_avail_service_rec.PRODUCT_ITEM_ID, 1, 'N');
812: aso_debug_pub.add('ASO_SER_INT:available_service: p_avail_service_rec.CUSTOMER_ID '|| p_avail_service_rec.CUSTOMER_ID, 1, 'N');
813: aso_debug_pub.add('ASO_SER_INT:available_service: p_avail_service_rec.PRODUCT_REVISION '|| p_avail_service_rec.PRODUCT_REVISION, 1, 'N');
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:
810:
811: aso_debug_pub.add('ASO_SER_INT:available_service: p_avail_service_rec.PRODUCT_ITEM_ID '|| p_avail_service_rec.PRODUCT_ITEM_ID, 1, 'N');
812: aso_debug_pub.add('ASO_SER_INT:available_service: p_avail_service_rec.CUSTOMER_ID '|| p_avail_service_rec.CUSTOMER_ID, 1, 'N');
813: aso_debug_pub.add('ASO_SER_INT:available_service: p_avail_service_rec.PRODUCT_REVISION '|| p_avail_service_rec.PRODUCT_REVISION, 1, 'N');
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
841: l_avail_service_rec.PRODUCT_REVISION := p_avail_service_rec.PRODUCT_REVISION;
842: l_avail_service_rec.REQUEST_DATE := p_avail_service_rec.REQUEST_DATE;
843: */
844:
845: IF aso_debug_pub.g_debug_flag = 'Y' THEN
846: aso_debug_pub.add('Before Calling OKS_OMINT_PUB.Available_Services ',1,'Y');
847: aso_utility_pvt.print_login_info();
848: END IF;
849:
842: l_avail_service_rec.REQUEST_DATE := p_avail_service_rec.REQUEST_DATE;
843: */
844:
845: IF aso_debug_pub.g_debug_flag = 'Y' THEN
846: aso_debug_pub.add('Before Calling OKS_OMINT_PUB.Available_Services ',1,'Y');
847: aso_utility_pvt.print_login_info();
848: END IF;
849:
850: OKS_OMINT_PUB.Available_Services(
856: p_avail_service_rec => l_avail_service_rec,
857: X_Orderable_Service_tbl => l_Orderable_Service_tbl
858: );
859:
860: IF aso_debug_pub.g_debug_flag = 'Y' 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:
857: X_Orderable_Service_tbl => l_Orderable_Service_tbl
858: );
859:
860: IF aso_debug_pub.g_debug_flag = 'Y' 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
962: BEGIN
963: -- Standard Start of API savepoint
964: SAVEPOINT GET_WARRANTY_PUB;
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,
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');
1008: aso_utility_pvt.print_login_info();
1009: END IF;
1010:
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');
1008: aso_utility_pvt.print_login_info();
1009: END IF;
1010:
1011: OKS_EXTWAR_UTIL_PUB.Get_Warranty_info(
1018: X_msg_Data => X_msg_data ,
1019: X_Warranty_tbl => l_Warranty_tbl );
1020: -- map the output
1021:
1022: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1023: aso_debug_pub.add('After Call to OKS_EXTWAR_UTIL_PUB.Get_Warranty_info', 1, 'Y');
1024: aso_utility_pvt.print_login_info();
1025: END IF;
1026:
1019: X_Warranty_tbl => l_Warranty_tbl );
1020: -- map the output
1021:
1022: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1023: aso_debug_pub.add('After Call to OKS_EXTWAR_UTIL_PUB.Get_Warranty_info', 1, 'Y');
1024: aso_utility_pvt.print_login_info();
1025: END IF;
1026:
1027: