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 ASO_DEBUG_PUB

Line 107: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');

103: BEGIN
104: -- Standard Start of API savepoint
105: SAVEPOINT GET_SERVICE_ATTRIBUTES_PVT;
106:
107: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
108:
109: -- Standard call to check for call compatibility.
110: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
111: p_api_version_number,

Line 150: IF aso_debug_pub.g_debug_flag = 'Y' THEN

146: END IF;
147: OPEN C_cust_id(P_Qte_Line_rec.quote_header_id);
148: FETCH C_cust_id INTO l_cust_account_id,lh_end_cust_account_id; -- ER 8647883
149:
150: IF aso_debug_pub.g_debug_flag = 'Y' THEN
151: aso_debug_pub.add('Get Service Attr: cust Acct id'||l_cust_account_id);
152: aso_debug_pub.add('Get Service Attr: header cust Acct id'||lh_end_cust_account_id);
153: END IF;
154:

Line 151: aso_debug_pub.add('Get Service Attr: cust Acct id'||l_cust_account_id);

147: OPEN C_cust_id(P_Qte_Line_rec.quote_header_id);
148: FETCH C_cust_id INTO l_cust_account_id,lh_end_cust_account_id; -- ER 8647883
149:
150: IF aso_debug_pub.g_debug_flag = 'Y' THEN
151: aso_debug_pub.add('Get Service Attr: cust Acct id'||l_cust_account_id);
152: aso_debug_pub.add('Get Service Attr: header cust Acct id'||lh_end_cust_account_id);
153: END IF;
154:
155: IF C_cust_id%NOTFOUND THEN

Line 152: aso_debug_pub.add('Get Service Attr: header cust Acct id'||lh_end_cust_account_id);

148: FETCH C_cust_id INTO l_cust_account_id,lh_end_cust_account_id; -- ER 8647883
149:
150: IF aso_debug_pub.g_debug_flag = 'Y' THEN
151: aso_debug_pub.add('Get Service Attr: cust Acct id'||l_cust_account_id);
152: aso_debug_pub.add('Get Service Attr: header cust Acct id'||lh_end_cust_account_id);
153: END IF;
154:
155: IF C_cust_id%NOTFOUND THEN
156: l_cust_account_id := NULL;

Line 166: IF aso_debug_pub.g_debug_flag = 'Y' THEN

162: IF P_Qte_Line_Dtl_tbl(i).SERVICE_REF_TYPE_CODE = 'QUOTE' THEN
163: OPEN C_qln( P_Qte_Line_Dtl_tbl(i).service_ref_line_id);
164: FETCH C_qln INTO l_inventory_item_id,l_organization_id,l_cust_account_id;
165:
166: IF aso_debug_pub.g_debug_flag = 'Y' THEN
167:
168: aso_debug_pub.add('Get Service Attr:ref code QUOTE inv id '||l_inventory_item_id, 1, 'Y');
169: aso_debug_pub.add('Get Service Attr:ref code QUOTE orgnization id '||l_organization_id , 1, 'Y');
170: aso_debug_pub.add('Get Service Attr:ref code QUOTE cust id '||l_cust_account_id, 1, 'Y');

Line 168: aso_debug_pub.add('Get Service Attr:ref code QUOTE inv id '||l_inventory_item_id, 1, 'Y');

164: FETCH C_qln INTO l_inventory_item_id,l_organization_id,l_cust_account_id;
165:
166: IF aso_debug_pub.g_debug_flag = 'Y' THEN
167:
168: aso_debug_pub.add('Get Service Attr:ref code QUOTE inv id '||l_inventory_item_id, 1, 'Y');
169: aso_debug_pub.add('Get Service Attr:ref code QUOTE orgnization id '||l_organization_id , 1, 'Y');
170: aso_debug_pub.add('Get Service Attr:ref code QUOTE cust id '||l_cust_account_id, 1, 'Y');
171:
172: END IF;

Line 169: aso_debug_pub.add('Get Service Attr:ref code QUOTE orgnization id '||l_organization_id , 1, 'Y');

165:
166: IF aso_debug_pub.g_debug_flag = 'Y' THEN
167:
168: aso_debug_pub.add('Get Service Attr:ref code QUOTE inv id '||l_inventory_item_id, 1, 'Y');
169: aso_debug_pub.add('Get Service Attr:ref code QUOTE orgnization id '||l_organization_id , 1, 'Y');
170: aso_debug_pub.add('Get Service Attr:ref code QUOTE cust id '||l_cust_account_id, 1, 'Y');
171:
172: END IF;
173:

Line 170: aso_debug_pub.add('Get Service Attr:ref code QUOTE cust id '||l_cust_account_id, 1, 'Y');

166: IF aso_debug_pub.g_debug_flag = 'Y' THEN
167:
168: aso_debug_pub.add('Get Service Attr:ref code QUOTE inv id '||l_inventory_item_id, 1, 'Y');
169: aso_debug_pub.add('Get Service Attr:ref code QUOTE orgnization id '||l_organization_id , 1, 'Y');
170: aso_debug_pub.add('Get Service Attr:ref code QUOTE cust id '||l_cust_account_id, 1, 'Y');
171:
172: END IF;
173:
174: IF C_qln%NOTFOUND THEN

Line 188: IF aso_debug_pub.g_debug_flag = 'Y' THEN

184: CLOSE C_qln;
185: OPEN C_item1( l_inventory_item_id,l_organization_id);
186: FETCH C_item1 INTO l_serviceable_flag;
187:
188: IF aso_debug_pub.g_debug_flag = 'Y' THEN
189: aso_debug_pub.add('Get Service Attr:ref code QUOTE serviceable flag '||l_serviceable_flag, 1, 'Y');
190: END IF;
191:
192: IF C_item1%NOTFOUND OR l_serviceable_flag <> 'Y' THEN

Line 189: aso_debug_pub.add('Get Service Attr:ref code QUOTE serviceable flag '||l_serviceable_flag, 1, 'Y');

185: OPEN C_item1( l_inventory_item_id,l_organization_id);
186: FETCH C_item1 INTO l_serviceable_flag;
187:
188: IF aso_debug_pub.g_debug_flag = 'Y' THEN
189: aso_debug_pub.add('Get Service Attr:ref code QUOTE serviceable flag '||l_serviceable_flag, 1, 'Y');
190: END IF;
191:
192: IF C_item1%NOTFOUND OR l_serviceable_flag <> 'Y' THEN
193: CLOSE C_item1;

Line 205: IF aso_debug_pub.g_debug_flag = 'Y' THEN

201:
202: END IF;
203: CLOSE C_item1;
204:
205: IF aso_debug_pub.g_debug_flag = 'Y' THEN
206:
207: aso_debug_pub.add('Get Service Attr:product_item_id '||l_inventory_item_id, 1, 'Y');
208: aso_debug_pub.add('Get Service Attr:service_item_id '||P_Qte_Line_rec.inventory_item_id, 1, 'Y');
209: aso_debug_pub.add('Get Service Attr:customer_id '||l_cust_account_id, 1, 'Y');

Line 207: aso_debug_pub.add('Get Service Attr:product_item_id '||l_inventory_item_id, 1, 'Y');

203: CLOSE C_item1;
204:
205: IF aso_debug_pub.g_debug_flag = 'Y' THEN
206:
207: aso_debug_pub.add('Get Service Attr:product_item_id '||l_inventory_item_id, 1, 'Y');
208: aso_debug_pub.add('Get Service Attr:service_item_id '||P_Qte_Line_rec.inventory_item_id, 1, 'Y');
209: aso_debug_pub.add('Get Service Attr:customer_id '||l_cust_account_id, 1, 'Y');
210:
211: END IF;

Line 208: aso_debug_pub.add('Get Service Attr:service_item_id '||P_Qte_Line_rec.inventory_item_id, 1, 'Y');

204:
205: IF aso_debug_pub.g_debug_flag = 'Y' THEN
206:
207: aso_debug_pub.add('Get Service Attr:product_item_id '||l_inventory_item_id, 1, 'Y');
208: aso_debug_pub.add('Get Service Attr:service_item_id '||P_Qte_Line_rec.inventory_item_id, 1, 'Y');
209: aso_debug_pub.add('Get Service Attr:customer_id '||l_cust_account_id, 1, 'Y');
210:
211: END IF;
212:

Line 209: aso_debug_pub.add('Get Service Attr:customer_id '||l_cust_account_id, 1, 'Y');

205: IF aso_debug_pub.g_debug_flag = 'Y' THEN
206:
207: aso_debug_pub.add('Get Service Attr:product_item_id '||l_inventory_item_id, 1, 'Y');
208: aso_debug_pub.add('Get Service Attr:service_item_id '||P_Qte_Line_rec.inventory_item_id, 1, 'Y');
209: aso_debug_pub.add('Get Service Attr:customer_id '||l_cust_account_id, 1, 'Y');
210:
211: END IF;
212:
213: l_check_service_rec.product_item_id := l_inventory_item_id;

Line 217: IF aso_debug_pub.g_debug_flag = 'Y' THEN

213: l_check_service_rec.product_item_id := l_inventory_item_id;
214: l_check_service_rec.service_item_id := P_Qte_Line_rec.inventory_item_id;
215: l_check_service_rec.customer_id := l_cust_account_id;
216:
217: IF aso_debug_pub.g_debug_flag = 'Y' THEN
218: aso_debug_pub.add('Get Service Attr:ref code QUOTE before Is Service '||l_serviceable_flag, 1, 'Y');
219: END IF;
220:
221: ASO_SERVICE_CONTRACTS_INT.Is_Service_Available(

Line 218: aso_debug_pub.add('Get Service Attr:ref code QUOTE before Is Service '||l_serviceable_flag, 1, 'Y');

214: l_check_service_rec.service_item_id := P_Qte_Line_rec.inventory_item_id;
215: l_check_service_rec.customer_id := l_cust_account_id;
216:
217: IF aso_debug_pub.g_debug_flag = 'Y' THEN
218: aso_debug_pub.add('Get Service Attr:ref code QUOTE before Is Service '||l_serviceable_flag, 1, 'Y');
219: END IF;
220:
221: ASO_SERVICE_CONTRACTS_INT.Is_Service_Available(
222: P_Api_Version_Number => P_Api_Version_Number ,

Line 231: IF aso_debug_pub.g_debug_flag = 'Y' THEN

227: p_check_service_rec => l_check_service_rec,
228: X_Available_YN => l_Available_YN
229: );
230:
231: IF aso_debug_pub.g_debug_flag = 'Y' THEN
232: aso_debug_pub.add('Get Service Attr:ref code QUOTE after Is Service '||l_Available_YN);
233: END IF;
234:
235: IF l_Available_YN = 'N' THEN

Line 232: aso_debug_pub.add('Get Service Attr:ref code QUOTE after Is Service '||l_Available_YN);

228: X_Available_YN => l_Available_YN
229: );
230:
231: IF aso_debug_pub.g_debug_flag = 'Y' THEN
232: aso_debug_pub.add('Get Service Attr:ref code QUOTE after Is Service '||l_Available_YN);
233: END IF;
234:
235: IF l_Available_YN = 'N' THEN
236: x_return_status := FND_API.G_RET_STS_ERROR;

Line 247: IF aso_debug_pub.g_debug_flag = 'Y' THEN

243: END IF;
244: END IF;
245: ELSIF P_Qte_Line_Dtl_tbl(i).SERVICE_REF_TYPE_CODE = 'CUSTOMER_PRODUCT' THEN
246:
247: IF aso_debug_pub.g_debug_flag = 'Y' THEN
248:
249: aso_debug_pub.add('Get Service Attr:SERVICE_REF_TYPE_CODE CUSTOMER_PRODUCT');
250: aso_debug_pub.add('Get Service Attr: CUSTOMER_PRODUCT inv id'||P_Qte_Line_rec.inventory_item_id);
251: aso_debug_pub.add('Get Service Attr: CUSTOMER_PRODUCT organization id'||P_Qte_Line_rec.organization_id);

Line 249: aso_debug_pub.add('Get Service Attr:SERVICE_REF_TYPE_CODE CUSTOMER_PRODUCT');

245: ELSIF P_Qte_Line_Dtl_tbl(i).SERVICE_REF_TYPE_CODE = 'CUSTOMER_PRODUCT' THEN
246:
247: IF aso_debug_pub.g_debug_flag = 'Y' THEN
248:
249: aso_debug_pub.add('Get Service Attr:SERVICE_REF_TYPE_CODE CUSTOMER_PRODUCT');
250: aso_debug_pub.add('Get Service Attr: CUSTOMER_PRODUCT inv id'||P_Qte_Line_rec.inventory_item_id);
251: aso_debug_pub.add('Get Service Attr: CUSTOMER_PRODUCT organization id'||P_Qte_Line_rec.organization_id);
252: 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');
253:

Line 250: aso_debug_pub.add('Get Service Attr: CUSTOMER_PRODUCT inv id'||P_Qte_Line_rec.inventory_item_id);

246:
247: IF aso_debug_pub.g_debug_flag = 'Y' THEN
248:
249: aso_debug_pub.add('Get Service Attr:SERVICE_REF_TYPE_CODE CUSTOMER_PRODUCT');
250: aso_debug_pub.add('Get Service Attr: CUSTOMER_PRODUCT inv id'||P_Qte_Line_rec.inventory_item_id);
251: aso_debug_pub.add('Get Service Attr: CUSTOMER_PRODUCT organization id'||P_Qte_Line_rec.organization_id);
252: 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');
253:
254: END IF;

Line 251: aso_debug_pub.add('Get Service Attr: CUSTOMER_PRODUCT organization id'||P_Qte_Line_rec.organization_id);

247: IF aso_debug_pub.g_debug_flag = 'Y' THEN
248:
249: aso_debug_pub.add('Get Service Attr:SERVICE_REF_TYPE_CODE CUSTOMER_PRODUCT');
250: aso_debug_pub.add('Get Service Attr: CUSTOMER_PRODUCT inv id'||P_Qte_Line_rec.inventory_item_id);
251: aso_debug_pub.add('Get Service Attr: CUSTOMER_PRODUCT organization id'||P_Qte_Line_rec.organization_id);
252: 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');
253:
254: END IF;
255:

Line 252: 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');

248:
249: aso_debug_pub.add('Get Service Attr:SERVICE_REF_TYPE_CODE CUSTOMER_PRODUCT');
250: aso_debug_pub.add('Get Service Attr: CUSTOMER_PRODUCT inv id'||P_Qte_Line_rec.inventory_item_id);
251: aso_debug_pub.add('Get Service Attr: CUSTOMER_PRODUCT organization id'||P_Qte_Line_rec.organization_id);
252: 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');
253:
254: END IF;
255:
256: l_cs_org_id := cs_std.get_item_valdn_orgzn_id;

Line 278: IF aso_debug_pub.g_debug_flag = 'Y' THEN

274:
275: OPEN C_get_cust_line (P_Qte_Line_rec.quote_line_id);
276: FETCH C_get_cust_line INTO ln_end_cust_account_id;
277:
278: IF aso_debug_pub.g_debug_flag = 'Y' THEN
279: aso_debug_pub.add('Get Service Attr: line level cust Acct id'||ln_end_cust_account_id);
280: END IF;
281: IF C_get_cust_line%NOTFOUND THEN
282: ln_end_cust_account_id := NULL;

Line 279: aso_debug_pub.add('Get Service Attr: line level cust Acct id'||ln_end_cust_account_id);

275: OPEN C_get_cust_line (P_Qte_Line_rec.quote_line_id);
276: FETCH C_get_cust_line INTO ln_end_cust_account_id;
277:
278: IF aso_debug_pub.g_debug_flag = 'Y' THEN
279: aso_debug_pub.add('Get Service Attr: line level cust Acct id'||ln_end_cust_account_id);
280: END IF;
281: IF C_get_cust_line%NOTFOUND THEN
282: ln_end_cust_account_id := NULL;
283: end if;

Line 294: IF aso_debug_pub.g_debug_flag = 'Y' THEN

290:
291: END IF; -- profile check
292:
293:
294: IF aso_debug_pub.g_debug_flag = 'Y' THEN
295: aso_debug_pub.add('Get Service Attr: cust Acct id'||l_cust_account_id);
296: END IF;
297:
298: /*** End: BugNo 8647883: R12.1.2 Service reference SUN ER ***/

Line 295: aso_debug_pub.add('Get Service Attr: cust Acct id'||l_cust_account_id);

291: END IF; -- profile check
292:
293:
294: IF aso_debug_pub.g_debug_flag = 'Y' THEN
295: aso_debug_pub.add('Get Service Attr: cust Acct id'||l_cust_account_id);
296: END IF;
297:
298: /*** End: BugNo 8647883: R12.1.2 Service reference SUN ER ***/
299: l_check_service_rec.product_item_id := l_inventory_item_id;

Line 323: IF aso_debug_pub.g_debug_flag = 'Y' THEN

319: END IF;
320: -- END IF;
321: ELSIF P_Qte_Line_Dtl_tbl(i).SERVICE_REF_TYPE_CODE = 'ORDER' THEN
322:
323: IF aso_debug_pub.g_debug_flag = 'Y' THEN
324:
325: aso_debug_pub.add('Get Service Attr:SERVICE_REF_TYPE_CODE ORDER', 1, 'Y');
326: aso_debug_pub.add('Get Service Attr: ORDER inv id'||P_Qte_Line_rec.inventory_item_id, 1, 'Y');
327: aso_debug_pub.add('Get Service Attr: ORDER organization id'||P_Qte_Line_rec.organization_id, 1, 'Y');

Line 325: aso_debug_pub.add('Get Service Attr:SERVICE_REF_TYPE_CODE ORDER', 1, 'Y');

321: ELSIF P_Qte_Line_Dtl_tbl(i).SERVICE_REF_TYPE_CODE = 'ORDER' THEN
322:
323: IF aso_debug_pub.g_debug_flag = 'Y' THEN
324:
325: aso_debug_pub.add('Get Service Attr:SERVICE_REF_TYPE_CODE ORDER', 1, 'Y');
326: aso_debug_pub.add('Get Service Attr: ORDER inv id'||P_Qte_Line_rec.inventory_item_id, 1, 'Y');
327: aso_debug_pub.add('Get Service Attr: ORDER organization id'||P_Qte_Line_rec.organization_id, 1, 'Y');
328: aso_debug_pub.add('Get Service Attr: ORDER service ref line id'||P_Qte_Line_Dtl_tbl(i).SERVICE_REF_LINE_ID, 1, 'Y');
329:

Line 326: aso_debug_pub.add('Get Service Attr: ORDER inv id'||P_Qte_Line_rec.inventory_item_id, 1, 'Y');

322:
323: IF aso_debug_pub.g_debug_flag = 'Y' THEN
324:
325: aso_debug_pub.add('Get Service Attr:SERVICE_REF_TYPE_CODE ORDER', 1, 'Y');
326: aso_debug_pub.add('Get Service Attr: ORDER inv id'||P_Qte_Line_rec.inventory_item_id, 1, 'Y');
327: aso_debug_pub.add('Get Service Attr: ORDER organization id'||P_Qte_Line_rec.organization_id, 1, 'Y');
328: aso_debug_pub.add('Get Service Attr: ORDER service ref line id'||P_Qte_Line_Dtl_tbl(i).SERVICE_REF_LINE_ID, 1, 'Y');
329:
330: END IF;

Line 327: aso_debug_pub.add('Get Service Attr: ORDER organization id'||P_Qte_Line_rec.organization_id, 1, 'Y');

323: IF aso_debug_pub.g_debug_flag = 'Y' THEN
324:
325: aso_debug_pub.add('Get Service Attr:SERVICE_REF_TYPE_CODE ORDER', 1, 'Y');
326: aso_debug_pub.add('Get Service Attr: ORDER inv id'||P_Qte_Line_rec.inventory_item_id, 1, 'Y');
327: aso_debug_pub.add('Get Service Attr: ORDER organization id'||P_Qte_Line_rec.organization_id, 1, 'Y');
328: aso_debug_pub.add('Get Service Attr: ORDER service ref line id'||P_Qte_Line_Dtl_tbl(i).SERVICE_REF_LINE_ID, 1, 'Y');
329:
330: END IF;
331:

Line 328: aso_debug_pub.add('Get Service Attr: ORDER service ref line id'||P_Qte_Line_Dtl_tbl(i).SERVICE_REF_LINE_ID, 1, 'Y');

324:
325: aso_debug_pub.add('Get Service Attr:SERVICE_REF_TYPE_CODE ORDER', 1, 'Y');
326: aso_debug_pub.add('Get Service Attr: ORDER inv id'||P_Qte_Line_rec.inventory_item_id, 1, 'Y');
327: aso_debug_pub.add('Get Service Attr: ORDER organization id'||P_Qte_Line_rec.organization_id, 1, 'Y');
328: aso_debug_pub.add('Get Service Attr: ORDER service ref line id'||P_Qte_Line_Dtl_tbl(i).SERVICE_REF_LINE_ID, 1, 'Y');
329:
330: END IF;
331:
332:

Line 371: IF aso_debug_pub.g_debug_flag = 'Y' THEN

367: --END IF;
368: /*** Start: BugNo 8647883: R12.1.2 Service reference SUN ER ***/
369: ELSIF P_Qte_Line_Dtl_tbl(i).SERVICE_REF_TYPE_CODE = 'PRODUCT_CATALOG' THEN
370:
371: IF aso_debug_pub.g_debug_flag = 'Y' THEN
372:
373: aso_debug_pub.add('SUN ER Get Service Attr: PRODUCT_CATALOG');
374: aso_debug_pub.add('SUN ER Get Service Attr: PRODUCT_CATALOG SERVICE_REF_LINE_ID inv id'||P_Qte_Line_Dtl_tbl(i).SERVICE_REF_LINE_ID);
375: aso_debug_pub.add('SUN ER Get Service Attr: PRODUCT_CATALOG inv id'||P_Qte_Line_rec.inventory_item_id);

Line 373: aso_debug_pub.add('SUN ER Get Service Attr: PRODUCT_CATALOG');

369: ELSIF P_Qte_Line_Dtl_tbl(i).SERVICE_REF_TYPE_CODE = 'PRODUCT_CATALOG' THEN
370:
371: IF aso_debug_pub.g_debug_flag = 'Y' THEN
372:
373: aso_debug_pub.add('SUN ER Get Service Attr: PRODUCT_CATALOG');
374: aso_debug_pub.add('SUN ER Get Service Attr: PRODUCT_CATALOG SERVICE_REF_LINE_ID inv id'||P_Qte_Line_Dtl_tbl(i).SERVICE_REF_LINE_ID);
375: aso_debug_pub.add('SUN ER Get Service Attr: PRODUCT_CATALOG inv id'||P_Qte_Line_rec.inventory_item_id);
376: aso_debug_pub.add('SUN ER Get Service Attr: PRODUCT_CATALOG organization id'||P_Qte_Line_rec.organization_id);
377: aso_debug_pub.add('SUN ER Get Service Attr: PRODUCT_CATALOG service ref line id'||P_Qte_Line_rec.quote_LINE_ID, 1, 'Y');

Line 374: aso_debug_pub.add('SUN ER Get Service Attr: PRODUCT_CATALOG SERVICE_REF_LINE_ID inv id'||P_Qte_Line_Dtl_tbl(i).SERVICE_REF_LINE_ID);

370:
371: IF aso_debug_pub.g_debug_flag = 'Y' THEN
372:
373: aso_debug_pub.add('SUN ER Get Service Attr: PRODUCT_CATALOG');
374: aso_debug_pub.add('SUN ER Get Service Attr: PRODUCT_CATALOG SERVICE_REF_LINE_ID inv id'||P_Qte_Line_Dtl_tbl(i).SERVICE_REF_LINE_ID);
375: aso_debug_pub.add('SUN ER Get Service Attr: PRODUCT_CATALOG inv id'||P_Qte_Line_rec.inventory_item_id);
376: aso_debug_pub.add('SUN ER Get Service Attr: PRODUCT_CATALOG organization id'||P_Qte_Line_rec.organization_id);
377: aso_debug_pub.add('SUN ER Get Service Attr: PRODUCT_CATALOG service ref line id'||P_Qte_Line_rec.quote_LINE_ID, 1, 'Y');
378:

Line 375: aso_debug_pub.add('SUN ER Get Service Attr: PRODUCT_CATALOG inv id'||P_Qte_Line_rec.inventory_item_id);

371: IF aso_debug_pub.g_debug_flag = 'Y' THEN
372:
373: aso_debug_pub.add('SUN ER Get Service Attr: PRODUCT_CATALOG');
374: aso_debug_pub.add('SUN ER Get Service Attr: PRODUCT_CATALOG SERVICE_REF_LINE_ID inv id'||P_Qte_Line_Dtl_tbl(i).SERVICE_REF_LINE_ID);
375: aso_debug_pub.add('SUN ER Get Service Attr: PRODUCT_CATALOG inv id'||P_Qte_Line_rec.inventory_item_id);
376: aso_debug_pub.add('SUN ER Get Service Attr: PRODUCT_CATALOG organization id'||P_Qte_Line_rec.organization_id);
377: aso_debug_pub.add('SUN ER Get Service Attr: PRODUCT_CATALOG service ref line id'||P_Qte_Line_rec.quote_LINE_ID, 1, 'Y');
378:
379: END IF;

Line 376: aso_debug_pub.add('SUN ER Get Service Attr: PRODUCT_CATALOG organization id'||P_Qte_Line_rec.organization_id);

372:
373: aso_debug_pub.add('SUN ER Get Service Attr: PRODUCT_CATALOG');
374: aso_debug_pub.add('SUN ER Get Service Attr: PRODUCT_CATALOG SERVICE_REF_LINE_ID inv id'||P_Qte_Line_Dtl_tbl(i).SERVICE_REF_LINE_ID);
375: aso_debug_pub.add('SUN ER Get Service Attr: PRODUCT_CATALOG inv id'||P_Qte_Line_rec.inventory_item_id);
376: aso_debug_pub.add('SUN ER Get Service Attr: PRODUCT_CATALOG organization id'||P_Qte_Line_rec.organization_id);
377: aso_debug_pub.add('SUN ER Get Service Attr: PRODUCT_CATALOG service ref line id'||P_Qte_Line_rec.quote_LINE_ID, 1, 'Y');
378:
379: END IF;
380: -- Checking for end customer depending on profile 8647883

Line 377: aso_debug_pub.add('SUN ER Get Service Attr: PRODUCT_CATALOG service ref line id'||P_Qte_Line_rec.quote_LINE_ID, 1, 'Y');

373: aso_debug_pub.add('SUN ER Get Service Attr: PRODUCT_CATALOG');
374: aso_debug_pub.add('SUN ER Get Service Attr: PRODUCT_CATALOG SERVICE_REF_LINE_ID inv id'||P_Qte_Line_Dtl_tbl(i).SERVICE_REF_LINE_ID);
375: aso_debug_pub.add('SUN ER Get Service Attr: PRODUCT_CATALOG inv id'||P_Qte_Line_rec.inventory_item_id);
376: aso_debug_pub.add('SUN ER Get Service Attr: PRODUCT_CATALOG organization id'||P_Qte_Line_rec.organization_id);
377: aso_debug_pub.add('SUN ER Get Service Attr: PRODUCT_CATALOG service ref line id'||P_Qte_Line_rec.quote_LINE_ID, 1, 'Y');
378:
379: END IF;
380: -- Checking for end customer depending on profile 8647883
381: if fnd_profile.value('ASO_FILTER_SERVICE_RF_END_CUST') ='Y' then

Line 386: IF aso_debug_pub.g_debug_flag = 'Y' THEN

382:
383: OPEN C_get_cust_line (P_Qte_Line_rec.quote_line_id);
384: FETCH C_get_cust_line INTO ln_end_cust_account_id;
385:
386: IF aso_debug_pub.g_debug_flag = 'Y' THEN
387: aso_debug_pub.add('Get Service Attr: line level cust Acct id'||ln_end_cust_account_id);
388: END IF;
389: IF C_get_cust_line%NOTFOUND THEN
390: ln_end_cust_account_id := NULL;

Line 387: aso_debug_pub.add('Get Service Attr: line level cust Acct id'||ln_end_cust_account_id);

383: OPEN C_get_cust_line (P_Qte_Line_rec.quote_line_id);
384: FETCH C_get_cust_line INTO ln_end_cust_account_id;
385:
386: IF aso_debug_pub.g_debug_flag = 'Y' THEN
387: aso_debug_pub.add('Get Service Attr: line level cust Acct id'||ln_end_cust_account_id);
388: END IF;
389: IF C_get_cust_line%NOTFOUND THEN
390: ln_end_cust_account_id := NULL;
391: end if;

Line 526: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');

522: BEGIN
523: -- Standard Start of API savepoint
524: SAVEPOINT GET_DURATION_PUB;
525:
526: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
527:
528: -- Standard call to check for call compatibility.
529: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
530: p_api_version_number,

Line 566: IF aso_debug_pub.g_debug_flag = 'Y' THEN

562: END IF;
563: RAISE FND_API.G_EXC_ERROR;
564: END IF;
565:
566: IF aso_debug_pub.g_debug_flag = 'Y' THEN
567:
568: aso_utility_pvt.print_login_info();
569: aso_debug_pub.add('ASO_service_contracts_INT.Get_Duration: Before call OKS_OMINT_PUB.Get Duration.',1,'Y');
570: aso_debug_pub.add('Get Duration: p_customer_id: '||p_customer_id, 1, 'Y');

Line 569: aso_debug_pub.add('ASO_service_contracts_INT.Get_Duration: Before call OKS_OMINT_PUB.Get Duration.',1,'Y');

565:
566: IF aso_debug_pub.g_debug_flag = 'Y' THEN
567:
568: aso_utility_pvt.print_login_info();
569: aso_debug_pub.add('ASO_service_contracts_INT.Get_Duration: Before call OKS_OMINT_PUB.Get Duration.',1,'Y');
570: aso_debug_pub.add('Get Duration: p_customer_id: '||p_customer_id, 1, 'Y');
571: aso_debug_pub.add('Get Duration: p_system_id: '||p_system_id, 1, 'Y');
572: aso_debug_pub.add('Get Duration: p_service_duration: '||p_service_duration, 1, 'Y');
573: aso_debug_pub.add('Get Duration: p_service_period: '||p_service_period, 1, 'Y');

Line 570: aso_debug_pub.add('Get Duration: p_customer_id: '||p_customer_id, 1, 'Y');

566: IF aso_debug_pub.g_debug_flag = 'Y' THEN
567:
568: aso_utility_pvt.print_login_info();
569: aso_debug_pub.add('ASO_service_contracts_INT.Get_Duration: Before call OKS_OMINT_PUB.Get Duration.',1,'Y');
570: aso_debug_pub.add('Get Duration: p_customer_id: '||p_customer_id, 1, 'Y');
571: aso_debug_pub.add('Get Duration: p_system_id: '||p_system_id, 1, 'Y');
572: aso_debug_pub.add('Get Duration: p_service_duration: '||p_service_duration, 1, 'Y');
573: aso_debug_pub.add('Get Duration: p_service_period: '||p_service_period, 1, 'Y');
574: aso_debug_pub.add('Get Duration: p_coterm_checked_yn: '||p_coterm_checked_yn, 1, 'Y');

Line 571: aso_debug_pub.add('Get Duration: p_system_id: '||p_system_id, 1, 'Y');

567:
568: aso_utility_pvt.print_login_info();
569: aso_debug_pub.add('ASO_service_contracts_INT.Get_Duration: Before call OKS_OMINT_PUB.Get Duration.',1,'Y');
570: aso_debug_pub.add('Get Duration: p_customer_id: '||p_customer_id, 1, 'Y');
571: aso_debug_pub.add('Get Duration: p_system_id: '||p_system_id, 1, 'Y');
572: aso_debug_pub.add('Get Duration: p_service_duration: '||p_service_duration, 1, 'Y');
573: aso_debug_pub.add('Get Duration: p_service_period: '||p_service_period, 1, 'Y');
574: aso_debug_pub.add('Get Duration: p_coterm_checked_yn: '||p_coterm_checked_yn, 1, 'Y');
575: aso_debug_pub.add('Get Duration: p_start_date: '||p_start_date, 1, 'Y');

Line 572: aso_debug_pub.add('Get Duration: p_service_duration: '||p_service_duration, 1, 'Y');

568: aso_utility_pvt.print_login_info();
569: aso_debug_pub.add('ASO_service_contracts_INT.Get_Duration: Before call OKS_OMINT_PUB.Get Duration.',1,'Y');
570: aso_debug_pub.add('Get Duration: p_customer_id: '||p_customer_id, 1, 'Y');
571: aso_debug_pub.add('Get Duration: p_system_id: '||p_system_id, 1, 'Y');
572: aso_debug_pub.add('Get Duration: p_service_duration: '||p_service_duration, 1, 'Y');
573: aso_debug_pub.add('Get Duration: p_service_period: '||p_service_period, 1, 'Y');
574: aso_debug_pub.add('Get Duration: p_coterm_checked_yn: '||p_coterm_checked_yn, 1, 'Y');
575: aso_debug_pub.add('Get Duration: p_start_date: '||p_start_date, 1, 'Y');
576: aso_debug_pub.add('Get Duration: p_end_date: '||p_end_date, 1, 'Y');

Line 573: aso_debug_pub.add('Get Duration: p_service_period: '||p_service_period, 1, 'Y');

569: aso_debug_pub.add('ASO_service_contracts_INT.Get_Duration: Before call OKS_OMINT_PUB.Get Duration.',1,'Y');
570: aso_debug_pub.add('Get Duration: p_customer_id: '||p_customer_id, 1, 'Y');
571: aso_debug_pub.add('Get Duration: p_system_id: '||p_system_id, 1, 'Y');
572: aso_debug_pub.add('Get Duration: p_service_duration: '||p_service_duration, 1, 'Y');
573: aso_debug_pub.add('Get Duration: p_service_period: '||p_service_period, 1, 'Y');
574: aso_debug_pub.add('Get Duration: p_coterm_checked_yn: '||p_coterm_checked_yn, 1, 'Y');
575: aso_debug_pub.add('Get Duration: p_start_date: '||p_start_date, 1, 'Y');
576: aso_debug_pub.add('Get Duration: p_end_date: '||p_end_date, 1, 'Y');
577:

Line 574: aso_debug_pub.add('Get Duration: p_coterm_checked_yn: '||p_coterm_checked_yn, 1, 'Y');

570: aso_debug_pub.add('Get Duration: p_customer_id: '||p_customer_id, 1, 'Y');
571: aso_debug_pub.add('Get Duration: p_system_id: '||p_system_id, 1, 'Y');
572: aso_debug_pub.add('Get Duration: p_service_duration: '||p_service_duration, 1, 'Y');
573: aso_debug_pub.add('Get Duration: p_service_period: '||p_service_period, 1, 'Y');
574: aso_debug_pub.add('Get Duration: p_coterm_checked_yn: '||p_coterm_checked_yn, 1, 'Y');
575: aso_debug_pub.add('Get Duration: p_start_date: '||p_start_date, 1, 'Y');
576: aso_debug_pub.add('Get Duration: p_end_date: '||p_end_date, 1, 'Y');
577:
578: END IF;

Line 575: aso_debug_pub.add('Get Duration: p_start_date: '||p_start_date, 1, 'Y');

571: aso_debug_pub.add('Get Duration: p_system_id: '||p_system_id, 1, 'Y');
572: aso_debug_pub.add('Get Duration: p_service_duration: '||p_service_duration, 1, 'Y');
573: aso_debug_pub.add('Get Duration: p_service_period: '||p_service_period, 1, 'Y');
574: aso_debug_pub.add('Get Duration: p_coterm_checked_yn: '||p_coterm_checked_yn, 1, 'Y');
575: aso_debug_pub.add('Get Duration: p_start_date: '||p_start_date, 1, 'Y');
576: aso_debug_pub.add('Get Duration: p_end_date: '||p_end_date, 1, 'Y');
577:
578: END IF;
579:

Line 576: aso_debug_pub.add('Get Duration: p_end_date: '||p_end_date, 1, 'Y');

572: aso_debug_pub.add('Get Duration: p_service_duration: '||p_service_duration, 1, 'Y');
573: aso_debug_pub.add('Get Duration: p_service_period: '||p_service_period, 1, 'Y');
574: aso_debug_pub.add('Get Duration: p_coterm_checked_yn: '||p_coterm_checked_yn, 1, 'Y');
575: aso_debug_pub.add('Get Duration: p_start_date: '||p_start_date, 1, 'Y');
576: aso_debug_pub.add('Get Duration: p_end_date: '||p_end_date, 1, 'Y');
577:
578: END IF;
579:
580:

Line 599: IF aso_debug_pub.g_debug_flag = 'Y' THEN

595: X_service_period => x_service_period ,
596: X_new_end_date => x_new_end_date) ;
597:
598:
599: IF aso_debug_pub.g_debug_flag = 'Y' THEN
600:
601: aso_debug_pub.add('Get Duration: After Call to OKS_OMINT_PUB.Get_Duration: X_return_status: '||X_return_status, 1, 'Y');
602: aso_debug_pub.add('Get Duration: x_service_duration: '||x_service_duration, 1, 'Y');
603: aso_debug_pub.add('Get Duration: x_service_period: '||x_service_period, 1, 'Y');

Line 601: aso_debug_pub.add('Get Duration: After Call to OKS_OMINT_PUB.Get_Duration: X_return_status: '||X_return_status, 1, 'Y');

597:
598:
599: IF aso_debug_pub.g_debug_flag = 'Y' THEN
600:
601: aso_debug_pub.add('Get Duration: After Call to OKS_OMINT_PUB.Get_Duration: X_return_status: '||X_return_status, 1, 'Y');
602: aso_debug_pub.add('Get Duration: x_service_duration: '||x_service_duration, 1, 'Y');
603: aso_debug_pub.add('Get Duration: x_service_period: '||x_service_period, 1, 'Y');
604: aso_debug_pub.add('Get Duration: x_new_end_date: '||x_new_end_date, 1, 'Y');
605: aso_utility_pvt.print_login_info();

Line 602: aso_debug_pub.add('Get Duration: x_service_duration: '||x_service_duration, 1, 'Y');

598:
599: IF aso_debug_pub.g_debug_flag = 'Y' THEN
600:
601: aso_debug_pub.add('Get Duration: After Call to OKS_OMINT_PUB.Get_Duration: X_return_status: '||X_return_status, 1, 'Y');
602: aso_debug_pub.add('Get Duration: x_service_duration: '||x_service_duration, 1, 'Y');
603: aso_debug_pub.add('Get Duration: x_service_period: '||x_service_period, 1, 'Y');
604: aso_debug_pub.add('Get Duration: x_new_end_date: '||x_new_end_date, 1, 'Y');
605: aso_utility_pvt.print_login_info();
606:

Line 603: aso_debug_pub.add('Get Duration: x_service_period: '||x_service_period, 1, 'Y');

599: IF aso_debug_pub.g_debug_flag = 'Y' THEN
600:
601: aso_debug_pub.add('Get Duration: After Call to OKS_OMINT_PUB.Get_Duration: X_return_status: '||X_return_status, 1, 'Y');
602: aso_debug_pub.add('Get Duration: x_service_duration: '||x_service_duration, 1, 'Y');
603: aso_debug_pub.add('Get Duration: x_service_period: '||x_service_period, 1, 'Y');
604: aso_debug_pub.add('Get Duration: x_new_end_date: '||x_new_end_date, 1, 'Y');
605: aso_utility_pvt.print_login_info();
606:
607: END IF;

Line 604: aso_debug_pub.add('Get Duration: x_new_end_date: '||x_new_end_date, 1, 'Y');

600:
601: aso_debug_pub.add('Get Duration: After Call to OKS_OMINT_PUB.Get_Duration: X_return_status: '||X_return_status, 1, 'Y');
602: aso_debug_pub.add('Get Duration: x_service_duration: '||x_service_duration, 1, 'Y');
603: aso_debug_pub.add('Get Duration: x_service_period: '||x_service_period, 1, 'Y');
604: aso_debug_pub.add('Get Duration: x_new_end_date: '||x_new_end_date, 1, 'Y');
605: aso_utility_pvt.print_login_info();
606:
607: END IF;
608:

Line 690: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');

686: BEGIN
687: -- Standard Start of API savepoint
688: SAVEPOINT IS_SERVICE_AVAILABLE_PUB;
689:
690: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
691:
692: -- Standard call to check for call compatibility.
693: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
694: p_api_version_number,

Line 730: IF aso_debug_pub.g_debug_flag = 'Y' THEN

726: END IF;
727: RAISE FND_API.G_EXC_ERROR;
728: END IF;
729:
730: IF aso_debug_pub.g_debug_flag = 'Y' THEN
731:
732: 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');
733: aso_debug_pub.add('ASO_SER_INT:IS_service_available: p_check_service_rec.customer_id '|| p_check_service_rec.customer_id, 1, 'N');
734: aso_debug_pub.add('ASO_SER_INT:IS_service_available: p_check_service_rec.request_date '|| p_check_service_rec.request_date, 1, 'N');

Line 732: 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');

728: END IF;
729:
730: IF aso_debug_pub.g_debug_flag = 'Y' THEN
731:
732: 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');
733: aso_debug_pub.add('ASO_SER_INT:IS_service_available: p_check_service_rec.customer_id '|| p_check_service_rec.customer_id, 1, 'N');
734: aso_debug_pub.add('ASO_SER_INT:IS_service_available: p_check_service_rec.request_date '|| p_check_service_rec.request_date, 1, 'N');
735: 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');
736: aso_debug_pub.add('ASO_SER_INT:IS_service_available: p_check_service_rec.product_revision '|| p_check_service_rec.product_revision, 1, 'N');

Line 733: aso_debug_pub.add('ASO_SER_INT:IS_service_available: p_check_service_rec.customer_id '|| p_check_service_rec.customer_id, 1, 'N');

729:
730: IF aso_debug_pub.g_debug_flag = 'Y' THEN
731:
732: 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');
733: aso_debug_pub.add('ASO_SER_INT:IS_service_available: p_check_service_rec.customer_id '|| p_check_service_rec.customer_id, 1, 'N');
734: aso_debug_pub.add('ASO_SER_INT:IS_service_available: p_check_service_rec.request_date '|| p_check_service_rec.request_date, 1, 'N');
735: 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');
736: aso_debug_pub.add('ASO_SER_INT:IS_service_available: p_check_service_rec.product_revision '|| p_check_service_rec.product_revision, 1, 'N');
737:

Line 734: aso_debug_pub.add('ASO_SER_INT:IS_service_available: p_check_service_rec.request_date '|| p_check_service_rec.request_date, 1, 'N');

730: IF aso_debug_pub.g_debug_flag = 'Y' THEN
731:
732: 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');
733: aso_debug_pub.add('ASO_SER_INT:IS_service_available: p_check_service_rec.customer_id '|| p_check_service_rec.customer_id, 1, 'N');
734: aso_debug_pub.add('ASO_SER_INT:IS_service_available: p_check_service_rec.request_date '|| p_check_service_rec.request_date, 1, 'N');
735: 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');
736: aso_debug_pub.add('ASO_SER_INT:IS_service_available: p_check_service_rec.product_revision '|| p_check_service_rec.product_revision, 1, 'N');
737:
738: END IF;

Line 735: 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');

731:
732: 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');
733: aso_debug_pub.add('ASO_SER_INT:IS_service_available: p_check_service_rec.customer_id '|| p_check_service_rec.customer_id, 1, 'N');
734: aso_debug_pub.add('ASO_SER_INT:IS_service_available: p_check_service_rec.request_date '|| p_check_service_rec.request_date, 1, 'N');
735: 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');
736: aso_debug_pub.add('ASO_SER_INT:IS_service_available: p_check_service_rec.product_revision '|| p_check_service_rec.product_revision, 1, 'N');
737:
738: END IF;
739:

Line 736: aso_debug_pub.add('ASO_SER_INT:IS_service_available: p_check_service_rec.product_revision '|| p_check_service_rec.product_revision, 1, 'N');

732: 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');
733: aso_debug_pub.add('ASO_SER_INT:IS_service_available: p_check_service_rec.customer_id '|| p_check_service_rec.customer_id, 1, 'N');
734: aso_debug_pub.add('ASO_SER_INT:IS_service_available: p_check_service_rec.request_date '|| p_check_service_rec.request_date, 1, 'N');
735: 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');
736: aso_debug_pub.add('ASO_SER_INT:IS_service_available: p_check_service_rec.product_revision '|| p_check_service_rec.product_revision, 1, 'N');
737:
738: END IF;
739:
740:

Line 776: IF aso_debug_pub.g_debug_flag = 'Y' THEN

772: l_check_service_rec.product_revision:=p_check_service_rec.product_revision;
773: l_check_service_rec.request_date := p_check_service_rec.request_date;
774: */
775:
776: IF aso_debug_pub.g_debug_flag = 'Y' THEN
777: aso_debug_pub.add('Before Calling OKS_OMINT_PUB.Is_Service_Available ',1,'Y');
778: aso_utility_pvt.print_login_info();
779: END IF;
780:

Line 777: aso_debug_pub.add('Before Calling OKS_OMINT_PUB.Is_Service_Available ',1,'Y');

773: l_check_service_rec.request_date := p_check_service_rec.request_date;
774: */
775:
776: IF aso_debug_pub.g_debug_flag = 'Y' THEN
777: aso_debug_pub.add('Before Calling OKS_OMINT_PUB.Is_Service_Available ',1,'Y');
778: aso_utility_pvt.print_login_info();
779: END IF;
780:
781: OKS_OMINT_PUB.Is_Service_Available(

Line 790: IF aso_debug_pub.g_debug_flag = 'Y' THEN

786: X_Return_Status => X_return_status ,
787: p_check_service_rec => l_check_service_rec,
788: X_Available_YN => X_Available_YN );
789:
790: IF aso_debug_pub.g_debug_flag = 'Y' THEN
791: aso_debug_pub.add('After Calling OKS_OMINT_PUB.Is_Service_Available ',1,'Y');
792: aso_utility_pvt.print_login_info();
793: END IF;
794:

Line 791: aso_debug_pub.add('After Calling OKS_OMINT_PUB.Is_Service_Available ',1,'Y');

787: p_check_service_rec => l_check_service_rec,
788: X_Available_YN => X_Available_YN );
789:
790: IF aso_debug_pub.g_debug_flag = 'Y' THEN
791: aso_debug_pub.add('After Calling OKS_OMINT_PUB.Is_Service_Available ',1,'Y');
792: aso_utility_pvt.print_login_info();
793: END IF;
794:
795:

Line 876: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');

872: BEGIN
873: -- Standard Start of API savepoint
874: SAVEPOINT AVAILABLE_SERVICES_PUB;
875:
876: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
877:
878: -- Standard call to check for call compatibility.
879: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
880: p_api_version_number,

Line 917: IF aso_debug_pub.g_debug_flag = 'Y' THEN

913: RAISE FND_API.G_EXC_ERROR;
914: END IF;
915:
916: -- map service rec type
917: IF aso_debug_pub.g_debug_flag = 'Y' THEN
918:
919: 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');
920: aso_debug_pub.add('ASO_SER_INT:available_service: p_avail_service_rec.CUSTOMER_ID '|| p_avail_service_rec.CUSTOMER_ID, 1, 'N');
921: aso_debug_pub.add('ASO_SER_INT:available_service: p_avail_service_rec.PRODUCT_REVISION '|| p_avail_service_rec.PRODUCT_REVISION, 1, 'N');

Line 919: 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');

915:
916: -- map service rec type
917: IF aso_debug_pub.g_debug_flag = 'Y' THEN
918:
919: 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');
920: aso_debug_pub.add('ASO_SER_INT:available_service: p_avail_service_rec.CUSTOMER_ID '|| p_avail_service_rec.CUSTOMER_ID, 1, 'N');
921: aso_debug_pub.add('ASO_SER_INT:available_service: p_avail_service_rec.PRODUCT_REVISION '|| p_avail_service_rec.PRODUCT_REVISION, 1, 'N');
922: aso_debug_pub.add('ASO_SER_INT:available_service: p_avail_service_rec.REQUEST_DATE '|| p_avail_service_rec.REQUEST_DATE, 1, 'N');
923:

Line 920: aso_debug_pub.add('ASO_SER_INT:available_service: p_avail_service_rec.CUSTOMER_ID '|| p_avail_service_rec.CUSTOMER_ID, 1, 'N');

916: -- map service rec type
917: IF aso_debug_pub.g_debug_flag = 'Y' THEN
918:
919: 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');
920: aso_debug_pub.add('ASO_SER_INT:available_service: p_avail_service_rec.CUSTOMER_ID '|| p_avail_service_rec.CUSTOMER_ID, 1, 'N');
921: aso_debug_pub.add('ASO_SER_INT:available_service: p_avail_service_rec.PRODUCT_REVISION '|| p_avail_service_rec.PRODUCT_REVISION, 1, 'N');
922: aso_debug_pub.add('ASO_SER_INT:available_service: p_avail_service_rec.REQUEST_DATE '|| p_avail_service_rec.REQUEST_DATE, 1, 'N');
923:
924: END IF;

Line 921: aso_debug_pub.add('ASO_SER_INT:available_service: p_avail_service_rec.PRODUCT_REVISION '|| p_avail_service_rec.PRODUCT_REVISION, 1, 'N');

917: IF aso_debug_pub.g_debug_flag = 'Y' THEN
918:
919: 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');
920: aso_debug_pub.add('ASO_SER_INT:available_service: p_avail_service_rec.CUSTOMER_ID '|| p_avail_service_rec.CUSTOMER_ID, 1, 'N');
921: aso_debug_pub.add('ASO_SER_INT:available_service: p_avail_service_rec.PRODUCT_REVISION '|| p_avail_service_rec.PRODUCT_REVISION, 1, 'N');
922: aso_debug_pub.add('ASO_SER_INT:available_service: p_avail_service_rec.REQUEST_DATE '|| p_avail_service_rec.REQUEST_DATE, 1, 'N');
923:
924: END IF;
925:

Line 922: aso_debug_pub.add('ASO_SER_INT:available_service: p_avail_service_rec.REQUEST_DATE '|| p_avail_service_rec.REQUEST_DATE, 1, 'N');

918:
919: 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');
920: aso_debug_pub.add('ASO_SER_INT:available_service: p_avail_service_rec.CUSTOMER_ID '|| p_avail_service_rec.CUSTOMER_ID, 1, 'N');
921: aso_debug_pub.add('ASO_SER_INT:available_service: p_avail_service_rec.PRODUCT_REVISION '|| p_avail_service_rec.PRODUCT_REVISION, 1, 'N');
922: aso_debug_pub.add('ASO_SER_INT:available_service: p_avail_service_rec.REQUEST_DATE '|| p_avail_service_rec.REQUEST_DATE, 1, 'N');
923:
924: END IF;
925:
926: IF p_avail_service_rec.PRODUCT_ITEM_ID = FND_API.G_MISS_NUM THEN

Line 953: IF aso_debug_pub.g_debug_flag = 'Y' THEN

949: l_avail_service_rec.PRODUCT_REVISION := p_avail_service_rec.PRODUCT_REVISION;
950: l_avail_service_rec.REQUEST_DATE := p_avail_service_rec.REQUEST_DATE;
951: */
952:
953: IF aso_debug_pub.g_debug_flag = 'Y' THEN
954: aso_debug_pub.add('Before Calling OKS_OMINT_PUB.Available_Services ',1,'Y');
955: aso_utility_pvt.print_login_info();
956: END IF;
957:

Line 954: aso_debug_pub.add('Before Calling OKS_OMINT_PUB.Available_Services ',1,'Y');

950: l_avail_service_rec.REQUEST_DATE := p_avail_service_rec.REQUEST_DATE;
951: */
952:
953: IF aso_debug_pub.g_debug_flag = 'Y' THEN
954: aso_debug_pub.add('Before Calling OKS_OMINT_PUB.Available_Services ',1,'Y');
955: aso_utility_pvt.print_login_info();
956: END IF;
957:
958: OKS_OMINT_PUB.Available_Services(

Line 968: IF aso_debug_pub.g_debug_flag = 'Y' THEN

964: p_avail_service_rec => l_avail_service_rec,
965: X_Orderable_Service_tbl => l_Orderable_Service_tbl
966: );
967:
968: IF aso_debug_pub.g_debug_flag = 'Y' THEN
969: aso_debug_pub.add('ASO_SER_INT:After Call to OKS available_service: x_return_status '|| X_return_status, 1, 'Y');
970: aso_utility_pvt.print_login_info();
971: END IF;
972:

Line 969: aso_debug_pub.add('ASO_SER_INT:After Call to OKS available_service: x_return_status '|| X_return_status, 1, 'Y');

965: X_Orderable_Service_tbl => l_Orderable_Service_tbl
966: );
967:
968: IF aso_debug_pub.g_debug_flag = 'Y' THEN
969: aso_debug_pub.add('ASO_SER_INT:After Call to OKS available_service: x_return_status '|| X_return_status, 1, 'Y');
970: aso_utility_pvt.print_login_info();
971: END IF;
972:
973: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

Line 1074: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');

1070: BEGIN
1071: -- Standard Start of API savepoint
1072: SAVEPOINT GET_WARRANTY_PUB;
1073:
1074: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
1075:
1076: -- Standard call to check for call compatibility.
1077: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1078: p_api_version_number,

Line 1114: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1110: END IF;
1111: RAISE FND_API.G_EXC_ERROR;
1112: END IF;
1113:
1114: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1115: aso_debug_pub.add('Before Call to OKS_EXTWAR_UTIL_PUB.Get_Warranty_info', 1, 'Y');
1116: aso_utility_pvt.print_login_info();
1117: END IF;
1118:

Line 1115: aso_debug_pub.add('Before Call to OKS_EXTWAR_UTIL_PUB.Get_Warranty_info', 1, 'Y');

1111: RAISE FND_API.G_EXC_ERROR;
1112: END IF;
1113:
1114: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1115: aso_debug_pub.add('Before Call to OKS_EXTWAR_UTIL_PUB.Get_Warranty_info', 1, 'Y');
1116: aso_utility_pvt.print_login_info();
1117: END IF;
1118:
1119: OKS_EXTWAR_UTIL_PUB.Get_Warranty_info(

Line 1130: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1126: X_msg_Data => X_msg_data ,
1127: X_Warranty_tbl => l_Warranty_tbl );
1128: -- map the output
1129:
1130: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1131: aso_debug_pub.add('After Call to OKS_EXTWAR_UTIL_PUB.Get_Warranty_info', 1, 'Y');
1132: aso_utility_pvt.print_login_info();
1133: END IF;
1134:

Line 1131: aso_debug_pub.add('After Call to OKS_EXTWAR_UTIL_PUB.Get_Warranty_info', 1, 'Y');

1127: X_Warranty_tbl => l_Warranty_tbl );
1128: -- map the output
1129:
1130: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1131: aso_debug_pub.add('After Call to OKS_EXTWAR_UTIL_PUB.Get_Warranty_info', 1, 'Y');
1132: aso_utility_pvt.print_login_info();
1133: END IF;
1134:
1135: