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.IBU_ORDER_CAPTURE dependencies on ASO_DEBUG_PUB

Line 94: aso_debug_pub.SetDebugLevel(10);

90:
91: BEGIN
92:
93: -- Turn on ASO debugging
94: aso_debug_pub.SetDebugLevel(10);
95: aso_debug_pub.Initialize;
96: l_aso_debug_file := ASO_DEBUG_PUB.Set_Debug_Mode('FILE');
97: aso_debug_pub.debug_on;
98: l_aso_debug_file := 'debug=' || l_aso_debug_file;

Line 95: aso_debug_pub.Initialize;

91: BEGIN
92:
93: -- Turn on ASO debugging
94: aso_debug_pub.SetDebugLevel(10);
95: aso_debug_pub.Initialize;
96: l_aso_debug_file := ASO_DEBUG_PUB.Set_Debug_Mode('FILE');
97: aso_debug_pub.debug_on;
98: l_aso_debug_file := 'debug=' || l_aso_debug_file;
99:

Line 96: l_aso_debug_file := ASO_DEBUG_PUB.Set_Debug_Mode('FILE');

92:
93: -- Turn on ASO debugging
94: aso_debug_pub.SetDebugLevel(10);
95: aso_debug_pub.Initialize;
96: l_aso_debug_file := ASO_DEBUG_PUB.Set_Debug_Mode('FILE');
97: aso_debug_pub.debug_on;
98: l_aso_debug_file := 'debug=' || l_aso_debug_file;
99:
100: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 97: aso_debug_pub.debug_on;

93: -- Turn on ASO debugging
94: aso_debug_pub.SetDebugLevel(10);
95: aso_debug_pub.Initialize;
96: l_aso_debug_file := ASO_DEBUG_PUB.Set_Debug_Mode('FILE');
97: aso_debug_pub.debug_on;
98: l_aso_debug_file := 'debug=' || l_aso_debug_file;
99:
100: -- Initialize message list if p_init_msg_list is set to TRUE.
101: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 198: aso_debug_pub.add('IBU: l_qte_header_rec::', 1, 'Y');

194: l_header_shipment_tbl(1).ship_to_party_site_id := HEADER_SHIPMENT_REC.SHIP_TO_PARTY_SITE_ID;
195: l_header_shipment_tbl(1).freight_carrier_code := HEADER_SHIPMENT_REC.FREIGHT_CARRIER_CODE;
196:
197: l_ibu_ret_header_prpt_info := 'l_qte_header_rec::';
198: aso_debug_pub.add('IBU: l_qte_header_rec::', 1, 'Y');
199:
200: if (l_qte_header_rec.quote_header_id <> FND_API.G_MISS_NUM) then
201: l_ibu_ret_header_info := 'quote_header_id = ' || l_qte_header_rec.quote_header_id || ' , ';
202: else

Line 205: aso_debug_pub.add ('IBU: quote_header_id = ' || l_qte_header_rec.quote_header_id , 1, 'Y');

201: l_ibu_ret_header_info := 'quote_header_id = ' || l_qte_header_rec.quote_header_id || ' , ';
202: else
203: l_ibu_ret_header_info := 'quote_header_id = ';
204: end if;
205: aso_debug_pub.add ('IBU: quote_header_id = ' || l_qte_header_rec.quote_header_id , 1, 'Y');
206:
207: if (l_qte_header_rec.org_id <> FND_API.G_MISS_NUM) then
208: l_ibu_ret_header_info := 'org_id = ' || l_qte_header_rec.org_id || ' , ';
209: else

Line 213: aso_debug_pub.add ('IBU: org_id = ' || l_qte_header_rec.org_id , 1, 'Y');

209: else
210: l_ibu_ret_header_info := 'org_id = ';
211: end if;
212:
213: aso_debug_pub.add ('IBU: org_id = ' || l_qte_header_rec.org_id , 1, 'Y');
214:
215: if ( l_qte_header_rec.quote_source_code <> FND_API.G_MISS_CHAR) then
216: l_ibu_ret_header_info := 'quote_source_code = ' || l_qte_header_rec.quote_source_code || ' , ';
217: else

Line 220: aso_debug_pub.add ('IBU: quote_source_code = ' || l_qte_header_rec.quote_source_code , 1, 'Y');

216: l_ibu_ret_header_info := 'quote_source_code = ' || l_qte_header_rec.quote_source_code || ' , ';
217: else
218: l_ibu_ret_header_info := 'quote_source_code = ';
219: end if;
220: aso_debug_pub.add ('IBU: quote_source_code = ' || l_qte_header_rec.quote_source_code , 1, 'Y');
221:
222: if ( l_qte_header_rec.party_id <> FND_API.G_MISS_NUM ) then
223: l_ibu_ret_header_info := 'party_id = ' || l_qte_header_rec.party_id || ' , ';
224: else

Line 227: aso_debug_pub.add ('IBU: party_id = ' || l_qte_header_rec.party_id , 1, 'Y');

223: l_ibu_ret_header_info := 'party_id = ' || l_qte_header_rec.party_id || ' , ';
224: else
225: l_ibu_ret_header_info := 'party_id = ';
226: end if;
227: aso_debug_pub.add ('IBU: party_id = ' || l_qte_header_rec.party_id , 1, 'Y');
228:
229: if ( l_qte_header_rec.cust_account_id <> FND_API.G_MISS_NUM ) then
230: l_ibu_ret_header_info := 'cust_account_id = ' || l_qte_header_rec.cust_account_id || ' , ';
231: else

Line 234: aso_debug_pub.add ('IBU: cust_account_id = ' || l_qte_header_rec.cust_account_id , 1, 'Y');

230: l_ibu_ret_header_info := 'cust_account_id = ' || l_qte_header_rec.cust_account_id || ' , ';
231: else
232: l_ibu_ret_header_info := 'cust_account_id = ';
233: end if;
234: aso_debug_pub.add ('IBU: cust_account_id = ' || l_qte_header_rec.cust_account_id , 1, 'Y');
235:
236:
237: if ( l_qte_header_rec.org_contact_id <> FND_API.G_MISS_NUM ) then
238: l_ibu_ret_header_info := 'org_contact_id = ' || l_qte_header_rec.org_contact_id || ' , ';

Line 242: aso_debug_pub.add ('IBU: org_contact_id = ' || l_qte_header_rec.org_contact_id , 1, 'Y');

238: l_ibu_ret_header_info := 'org_contact_id = ' || l_qte_header_rec.org_contact_id || ' , ';
239: else
240: l_ibu_ret_header_info := 'org_contact_id = ';
241: end if;
242: aso_debug_pub.add ('IBU: org_contact_id = ' || l_qte_header_rec.org_contact_id , 1, 'Y');
243:
244: if ( l_qte_header_rec.invoice_to_party_site_id <> FND_API.G_MISS_NUM ) then
245: l_ibu_ret_header_info := 'inv_to_py_site_id= ' || l_qte_header_rec.invoice_to_party_site_id || ' , ';
246: else

Line 249: aso_debug_pub.add ('IBU: inv_to_py_site_id= ' || l_qte_header_rec.invoice_to_party_site_id , 1, 'Y');

245: l_ibu_ret_header_info := 'inv_to_py_site_id= ' || l_qte_header_rec.invoice_to_party_site_id || ' , ';
246: else
247: l_ibu_ret_header_info := 'inv_to_py_site_id= ';
248: end if;
249: aso_debug_pub.add ('IBU: inv_to_py_site_id= ' || l_qte_header_rec.invoice_to_party_site_id , 1, 'Y');
250:
251: if ( l_qte_header_rec.order_type_id <> FND_API.G_MISS_NUM ) then
252: l_ibu_ret_header_info := 'order_type_id = ' || l_qte_header_rec.order_type_id || ' , ';
253: else

Line 256: aso_debug_pub.add ('IBU: order_type_id = ' || l_qte_header_rec.order_type_id , 1, 'Y');

252: l_ibu_ret_header_info := 'order_type_id = ' || l_qte_header_rec.order_type_id || ' , ';
253: else
254: l_ibu_ret_header_info := 'order_type_id = ';
255: end if;
256: aso_debug_pub.add ('IBU: order_type_id = ' || l_qte_header_rec.order_type_id , 1, 'Y');
257:
258: if ( l_qte_header_rec.quote_category_code <> FND_API.G_MISS_CHAR ) then
259: l_ibu_ret_header_info := 'quote_ca_code = ' || l_qte_header_rec.quote_category_code || ' , ';
260: else

Line 264: aso_debug_pub.add ('IBU: quote_ca_code = ' || l_qte_header_rec.quote_category_code , 1, 'Y');

260: else
261: l_ibu_ret_header_info := 'quote_ca_code = ';
262: end if;
263:
264: aso_debug_pub.add ('IBU: quote_ca_code = ' || l_qte_header_rec.quote_category_code , 1, 'Y');
265:
266: if ( l_qte_header_rec.ordered_date <> FND_API.G_MISS_DATE ) then
267: l_ibu_ret_header_info := 'ordered_date = ' || l_qte_header_rec.ordered_date || ' , ';
268: else

Line 272: aso_debug_pub.add ('IBU:ordered_date = ' || l_qte_header_rec.ordered_date , 1, 'Y');

268: else
269: l_ibu_ret_header_info := 'ordered_date = ';
270: end if;
271:
272: aso_debug_pub.add ('IBU:ordered_date = ' || l_qte_header_rec.ordered_date , 1, 'Y');
273:
274:
275:
276: if ( l_qte_header_rec.employee_person_id <> FND_API.G_MISS_NUM ) then

Line 281: aso_debug_pub.add ('IBU: emp_person_id = ' || l_qte_header_rec.employee_person_id , 1, 'Y');

277: l_ibu_ret_header_info := 'emp_person_id = ' || l_qte_header_rec.employee_person_id || ' , ';
278: else
279: l_ibu_ret_header_info := 'emp_person_id = ';
280: end if;
281: aso_debug_pub.add ('IBU: emp_person_id = ' || l_qte_header_rec.employee_person_id , 1, 'Y');
282:
283: if ( l_qte_header_rec.price_list_id <> FND_API.G_MISS_NUM ) then
284: l_ibu_ret_header_info := 'price_list_id = ' || l_qte_header_rec.price_list_id || ' , ';
285: else

Line 288: aso_debug_pub.add ('IBU: price_list_id = ' || l_qte_header_rec.price_list_id , 1, 'Y');

284: l_ibu_ret_header_info := 'price_list_id = ' || l_qte_header_rec.price_list_id || ' , ';
285: else
286: l_ibu_ret_header_info := 'price_list_id = ';
287: end if;
288: aso_debug_pub.add ('IBU: price_list_id = ' || l_qte_header_rec.price_list_id , 1, 'Y');
289:
290: if ( l_qte_header_rec.currency_code <> FND_API.G_MISS_CHAR) then
291: l_ibu_ret_header_info := 'currency_code = ' || l_qte_header_rec.currency_code || ' , ';
292: else

Line 295: aso_debug_pub.add ('IBU: currency_code = ' || l_qte_header_rec.currency_code , 1, 'Y');

291: l_ibu_ret_header_info := 'currency_code = ' || l_qte_header_rec.currency_code || ' , ';
292: else
293: l_ibu_ret_header_info := 'currency_code = ';
294: end if;
295: aso_debug_pub.add ('IBU: currency_code = ' || l_qte_header_rec.currency_code , 1, 'Y');
296:
297: l_ibu_ret_head_ship_prpt_info := 'l_header_shipment_tbl(1)::';
298: aso_debug_pub.add ('IBU:l_header_shipment_tbl(1)::' , 1, 'Y');
299:

Line 298: aso_debug_pub.add ('IBU:l_header_shipment_tbl(1)::' , 1, 'Y');

294: end if;
295: aso_debug_pub.add ('IBU: currency_code = ' || l_qte_header_rec.currency_code , 1, 'Y');
296:
297: l_ibu_ret_head_ship_prpt_info := 'l_header_shipment_tbl(1)::';
298: aso_debug_pub.add ('IBU:l_header_shipment_tbl(1)::' , 1, 'Y');
299:
300: if ( l_header_shipment_tbl(1).request_date <> FND_API.G_MISS_DATE) then
301: l_ibu_ret_head_ship_info := 'request_date = ' || l_header_shipment_tbl(1).request_date || ' , ';
302: else

Line 305: aso_debug_pub.add ('IBU: request_date = ' || l_header_shipment_tbl(1).request_date , 1, 'Y');

301: l_ibu_ret_head_ship_info := 'request_date = ' || l_header_shipment_tbl(1).request_date || ' , ';
302: else
303: l_ibu_ret_head_ship_info := 'request_date = ';
304: end if;
305: aso_debug_pub.add ('IBU: request_date = ' || l_header_shipment_tbl(1).request_date , 1, 'Y');
306:
307: if ( l_header_shipment_tbl(1).schedule_ship_date <> FND_API.G_MISS_DATE ) then
308: l_ibu_ret_head_ship_info := 'sch_ship_date = ' || l_header_shipment_tbl(1).schedule_ship_date || ' , ';
309: else

Line 312: aso_debug_pub.add ('IBU: sch_ship_date = ' || l_header_shipment_tbl(1).schedule_ship_date , 1, 'Y');

308: l_ibu_ret_head_ship_info := 'sch_ship_date = ' || l_header_shipment_tbl(1).schedule_ship_date || ' , ';
309: else
310: l_ibu_ret_head_ship_info := 'sch_ship_date = ';
311: end if;
312: aso_debug_pub.add ('IBU: sch_ship_date = ' || l_header_shipment_tbl(1).schedule_ship_date , 1, 'Y');
313:
314: if ( l_header_shipment_tbl(1).ship_to_party_site_id <> FND_API.G_MISS_NUM) then
315: l_ibu_ret_head_ship_info := 'ship_to_py_site_id = ' || l_header_shipment_tbl(1).ship_to_party_site_id || ' , ';
316: else

Line 319: aso_debug_pub.add ('IBU: ship_to_py_site_id = ' || l_header_shipment_tbl(1).ship_to_party_site_id , 1, 'Y');

315: l_ibu_ret_head_ship_info := 'ship_to_py_site_id = ' || l_header_shipment_tbl(1).ship_to_party_site_id || ' , ';
316: else
317: l_ibu_ret_head_ship_info := 'ship_to_py_site_id = ';
318: end if;
319: aso_debug_pub.add ('IBU: ship_to_py_site_id = ' || l_header_shipment_tbl(1).ship_to_party_site_id , 1, 'Y');
320:
321: if ( l_header_shipment_tbl(1).freight_carrier_code <> FND_API.G_MISS_CHAR) then
322: l_ibu_ret_head_ship_info := 'freigt_carr_code = ' || l_header_shipment_tbl(1).freight_carrier_code || ' , ';
323: else

Line 326: aso_debug_pub.add ('IBU: freigt_carr_code = ' || l_header_shipment_tbl(1).freight_carrier_code , 1, 'Y');

322: l_ibu_ret_head_ship_info := 'freigt_carr_code = ' || l_header_shipment_tbl(1).freight_carrier_code || ' , ';
323: else
324: l_ibu_ret_head_ship_info := 'freigt_carr_code = ';
325: end if;
326: aso_debug_pub.add ('IBU: freigt_carr_code = ' || l_header_shipment_tbl(1).freight_carrier_code , 1, 'Y');
327:
328: if (LINE_TBL.count > 0) then
329: for i in LINE_TBL.FIRST..LINE_TBL.LAST loop
330:

Line 422: aso_debug_pub.add ('IBU: l_qte_line_tbl(' || i || '): ' , 1, 'Y');

418: l_line_shipment_tbl (i).request_date := sysdate;
419: l_line_shipment_tbl (i).ship_to_party_site_id := LINE_SHIPMENT_TBL (i).SHIP_TO_PARTY_SITE_ID;
420:
421: l_ibu_ret_line_prpt_info := 'l_qte_line_tbl(' || i || '): ';
422: aso_debug_pub.add ('IBU: l_qte_line_tbl(' || i || '): ' , 1, 'Y');
423:
424:
425: l_ibu_ret_line_prpt_info := '';
426:

Line 432: aso_debug_pub.add ('IBU: operation_code = ' || l_qte_line_tbl (i).operation_code , 1, 'Y');

428: l_ibu_ret_line_info := l_ibu_ret_line_prpt_info || 'operation_code = ' || l_qte_line_tbl (i).operation_code || ' , ';
429: else
430: l_ibu_ret_line_info := l_ibu_ret_line_prpt_info || 'operation_code = ';
431: end if;
432: aso_debug_pub.add ('IBU: operation_code = ' || l_qte_line_tbl (i).operation_code , 1, 'Y');
433:
434: if ( l_qte_line_tbl (i).org_id <> FND_API.G_MISS_NUM ) then
435: l_ibu_ret_line_info := l_ibu_ret_line_prpt_info || 'org_id = ' || l_qte_line_tbl (i).org_id || ' , ';
436: else

Line 439: aso_debug_pub.add ('IBU: org_id = ' || l_qte_line_tbl (i).org_id , 1, 'Y');

435: l_ibu_ret_line_info := l_ibu_ret_line_prpt_info || 'org_id = ' || l_qte_line_tbl (i).org_id || ' , ';
436: else
437: l_ibu_ret_line_info := l_ibu_ret_line_prpt_info || 'org_id = ' ;
438: end if;
439: aso_debug_pub.add ('IBU: org_id = ' || l_qte_line_tbl (i).org_id , 1, 'Y');
440:
441: if ( l_qte_line_tbl (i).line_category_code <> FND_API.G_MISS_CHAR ) then
442: l_ibu_ret_line_info := l_ibu_ret_line_prpt_info || 'line_category_code = ' || l_qte_line_tbl (i).line_category_code || ' , ';
443: else

Line 446: aso_debug_pub.add ('IBU: line_category_code = ' || l_qte_line_tbl (i).line_category_code , 1, 'Y');

442: l_ibu_ret_line_info := l_ibu_ret_line_prpt_info || 'line_category_code = ' || l_qte_line_tbl (i).line_category_code || ' , ';
443: else
444: l_ibu_ret_line_info := l_ibu_ret_line_prpt_info || 'line_category_code = ';
445: end if;
446: aso_debug_pub.add ('IBU: line_category_code = ' || l_qte_line_tbl (i).line_category_code , 1, 'Y');
447:
448: if ( l_qte_line_tbl (i).order_line_type_id <> FND_API.G_MISS_NUM) then
449: l_ibu_ret_line_info := l_ibu_ret_line_prpt_info || 'ord_li_tp_id = ' || l_qte_line_tbl (i).order_line_type_id || ',';
450: else

Line 453: aso_debug_pub.add ('IBU: ord_li_tp_id = ' || l_qte_line_tbl (i).order_line_type_id , 1, 'Y');

449: l_ibu_ret_line_info := l_ibu_ret_line_prpt_info || 'ord_li_tp_id = ' || l_qte_line_tbl (i).order_line_type_id || ',';
450: else
451: l_ibu_ret_line_info := l_ibu_ret_line_prpt_info || 'ord_li_tp_id = ';
452: end if;
453: aso_debug_pub.add ('IBU: ord_li_tp_id = ' || l_qte_line_tbl (i).order_line_type_id , 1, 'Y');
454:
455: if ( l_qte_line_tbl (i).invoice_to_party_site_id <> FND_API.G_MISS_NUM) then
456: l_ibu_ret_line_info := l_ibu_ret_line_prpt_info || 'inv_to_pty_site_id = ' || l_qte_line_tbl (i).invoice_to_party_site_id || ' , ';
457: else

Line 460: aso_debug_pub.add ('IBU: inv_to_pty_site_id = ' || l_qte_line_tbl (i).invoice_to_party_site_id , 1, 'Y');

456: l_ibu_ret_line_info := l_ibu_ret_line_prpt_info || 'inv_to_pty_site_id = ' || l_qte_line_tbl (i).invoice_to_party_site_id || ' , ';
457: else
458: l_ibu_ret_line_info := l_ibu_ret_line_prpt_info || 'inv_to_pty_site_id = ';
459: end if;
460: aso_debug_pub.add ('IBU: inv_to_pty_site_id = ' || l_qte_line_tbl (i).invoice_to_party_site_id , 1, 'Y');
461:
462: if ( l_qte_line_tbl (i).inventory_item_id <> FND_API.G_MISS_NUM) then
463: l_ibu_ret_line_info := l_ibu_ret_line_prpt_info || 'inv_item_id = ' || l_qte_line_tbl (i).inventory_item_id || ' , ';
464: else

Line 467: aso_debug_pub.add ('IBU: inv_item_id = ' || l_qte_line_tbl (i).inventory_item_id , 1, 'Y');

463: l_ibu_ret_line_info := l_ibu_ret_line_prpt_info || 'inv_item_id = ' || l_qte_line_tbl (i).inventory_item_id || ' , ';
464: else
465: l_ibu_ret_line_info := l_ibu_ret_line_prpt_info || 'inv_item_id = ';
466: end if;
467: aso_debug_pub.add ('IBU: inv_item_id = ' || l_qte_line_tbl (i).inventory_item_id , 1, 'Y');
468:
469: if ( l_qte_line_tbl (i).quantity <> FND_API.G_MISS_NUM) then
470: l_ibu_ret_line_info := l_ibu_ret_line_prpt_info || 'quantity = ' || l_qte_line_tbl (i).quantity || ' , ';
471: else

Line 474: aso_debug_pub.add ('IBU: quantity = ' || l_qte_line_tbl (i).quantity , 1, 'Y');

470: l_ibu_ret_line_info := l_ibu_ret_line_prpt_info || 'quantity = ' || l_qte_line_tbl (i).quantity || ' , ';
471: else
472: l_ibu_ret_line_info := l_ibu_ret_line_prpt_info || 'quantity = ';
473: end if;
474: aso_debug_pub.add ('IBU: quantity = ' || l_qte_line_tbl (i).quantity , 1, 'Y');
475:
476: if ( l_qte_line_tbl (i).uom_code <> FND_API.G_MISS_CHAR ) then
477: l_ibu_ret_line_info := l_ibu_ret_line_prpt_info || 'uom_code = ' || l_qte_line_tbl (i).uom_code || ' , ';
478: else

Line 481: aso_debug_pub.add ('IBU: uom_code = ' || l_qte_line_tbl (i).uom_code , 1, 'Y');

477: l_ibu_ret_line_info := l_ibu_ret_line_prpt_info || 'uom_code = ' || l_qte_line_tbl (i).uom_code || ' , ';
478: else
479: l_ibu_ret_line_info := l_ibu_ret_line_prpt_info || 'uom_code = ';
480: end if;
481: aso_debug_pub.add ('IBU: uom_code = ' || l_qte_line_tbl (i).uom_code , 1, 'Y');
482:
483: if ( l_qte_line_tbl (i).price_list_id <> FND_API.G_MISS_NUM ) then
484: l_ibu_ret_line_info := l_ibu_ret_line_prpt_info || 'price_list_id = ' || l_qte_line_tbl (i).price_list_id || ' , ';
485: else

Line 488: aso_debug_pub.add ('IBU: price_list_id = ' || l_qte_line_tbl (i).price_list_id , 1, 'Y');

484: l_ibu_ret_line_info := l_ibu_ret_line_prpt_info || 'price_list_id = ' || l_qte_line_tbl (i).price_list_id || ' , ';
485: else
486: l_ibu_ret_line_info := l_ibu_ret_line_prpt_info || 'price_list_id = ';
487: end if;
488: aso_debug_pub.add ('IBU: price_list_id = ' || l_qte_line_tbl (i).price_list_id , 1, 'Y');
489:
490: if ( l_qte_line_tbl (i).line_list_price <> FND_API.G_MISS_NUM ) then
491: l_ibu_ret_line_info := l_ibu_ret_line_prpt_info || 'line_list_price = ' || l_qte_line_tbl (i).line_list_price || ' , ';
492: else

Line 495: aso_debug_pub.add ('IBU: line_list_price = ' || l_qte_line_tbl (i).line_list_price , 1, 'Y');

491: l_ibu_ret_line_info := l_ibu_ret_line_prpt_info || 'line_list_price = ' || l_qte_line_tbl (i).line_list_price || ' , ';
492: else
493: l_ibu_ret_line_info := l_ibu_ret_line_prpt_info || 'line_list_price = ' ;
494: end if;
495: aso_debug_pub.add ('IBU: line_list_price = ' || l_qte_line_tbl (i).line_list_price , 1, 'Y');
496:
497: if ( l_qte_line_tbl (i).line_quote_price <> FND_API.G_MISS_NUM ) then
498: l_ibu_ret_line_info := l_ibu_ret_line_prpt_info || 'line_quote_price = ' || l_qte_line_tbl (i).line_quote_price || ' , ';
499: else

Line 502: aso_debug_pub.add ('IBU: line_quote_price = ' || l_qte_line_tbl (i).line_quote_price , 1, 'Y');

498: l_ibu_ret_line_info := l_ibu_ret_line_prpt_info || 'line_quote_price = ' || l_qte_line_tbl (i).line_quote_price || ' , ';
499: else
500: l_ibu_ret_line_info := l_ibu_ret_line_prpt_info || 'line_quote_price = ';
501: end if;
502: aso_debug_pub.add ('IBU: line_quote_price = ' || l_qte_line_tbl (i).line_quote_price , 1, 'Y');
503:
504: l_ibu_ret_line_dtl_prpt_info := 'l_qte_line_dtl_tbl(' || i || '): ';
505: aso_debug_pub.add ('IBU: l_qte_line_dtl_tbl(' || i || '): ' , 1, 'Y');
506:

Line 505: aso_debug_pub.add ('IBU: l_qte_line_dtl_tbl(' || i || '): ' , 1, 'Y');

501: end if;
502: aso_debug_pub.add ('IBU: line_quote_price = ' || l_qte_line_tbl (i).line_quote_price , 1, 'Y');
503:
504: l_ibu_ret_line_dtl_prpt_info := 'l_qte_line_dtl_tbl(' || i || '): ';
505: aso_debug_pub.add ('IBU: l_qte_line_dtl_tbl(' || i || '): ' , 1, 'Y');
506:
507: l_ibu_ret_line_dtl_prpt_info := '';
508: if ( l_qte_line_dtl_tbl (i).operation_code <> FND_API.G_MISS_CHAR ) then
509: l_ibu_ret_line_dtl_info := l_ibu_ret_line_dtl_prpt_info || 'operation_code = ' || l_qte_line_dtl_tbl (i).operation_code || ' , ';

Line 513: aso_debug_pub.add ('IBU: operation_code = ' || l_qte_line_dtl_tbl (i).operation_code , 1, 'Y');

509: l_ibu_ret_line_dtl_info := l_ibu_ret_line_dtl_prpt_info || 'operation_code = ' || l_qte_line_dtl_tbl (i).operation_code || ' , ';
510: else
511: l_ibu_ret_line_dtl_info := l_ibu_ret_line_dtl_prpt_info || 'operation_code = ';
512: end if;
513: aso_debug_pub.add ('IBU: operation_code = ' || l_qte_line_dtl_tbl (i).operation_code , 1, 'Y');
514:
515: if ( l_qte_line_dtl_tbl (i).qte_line_index <> FND_API.G_MISS_NUM) then
516: l_ibu_ret_line_dtl_info := l_ibu_ret_line_dtl_prpt_info || 'qte_line_index = ' || l_qte_line_dtl_tbl (i).qte_line_index || ' , ';
517: else

Line 520: aso_debug_pub.add ('IBU: qte_line_index = ' || l_qte_line_dtl_tbl (i).qte_line_index , 1, 'Y');

516: l_ibu_ret_line_dtl_info := l_ibu_ret_line_dtl_prpt_info || 'qte_line_index = ' || l_qte_line_dtl_tbl (i).qte_line_index || ' , ';
517: else
518: l_ibu_ret_line_dtl_info := l_ibu_ret_line_dtl_prpt_info || 'qte_line_index = ' ;
519: end if;
520: aso_debug_pub.add ('IBU: qte_line_index = ' || l_qte_line_dtl_tbl (i).qte_line_index , 1, 'Y');
521:
522: if ( l_qte_line_dtl_tbl (i).return_ref_type <> FND_API.G_MISS_CHAR ) then
523: l_ibu_ret_line_dtl_info := l_ibu_ret_line_dtl_prpt_info || 'ret_ref_type = ' || l_qte_line_dtl_tbl (i).return_ref_type || ' , ';
524: else

Line 527: aso_debug_pub.add ('IBU: ret_ref_type = ' || l_qte_line_dtl_tbl (i).return_ref_type , 1, 'Y');

523: l_ibu_ret_line_dtl_info := l_ibu_ret_line_dtl_prpt_info || 'ret_ref_type = ' || l_qte_line_dtl_tbl (i).return_ref_type || ' , ';
524: else
525: l_ibu_ret_line_dtl_info := l_ibu_ret_line_dtl_prpt_info || 'ret_ref_type = ';
526: end if;
527: aso_debug_pub.add ('IBU: ret_ref_type = ' || l_qte_line_dtl_tbl (i).return_ref_type , 1, 'Y');
528:
529: if ( l_qte_line_dtl_tbl (i).return_attribute1 <> FND_API.G_MISS_CHAR) then
530: l_ibu_ret_line_dtl_info := l_ibu_ret_line_dtl_prpt_info || 'return_att1 = ' || l_qte_line_dtl_tbl (i).return_attribute1 || ' , ';
531: else

Line 534: aso_debug_pub.add ('IBU: return_att1 = ' || l_qte_line_dtl_tbl (i).return_attribute1 , 1, 'Y');

530: l_ibu_ret_line_dtl_info := l_ibu_ret_line_dtl_prpt_info || 'return_att1 = ' || l_qte_line_dtl_tbl (i).return_attribute1 || ' , ';
531: else
532: l_ibu_ret_line_dtl_info := l_ibu_ret_line_dtl_prpt_info || 'return_att1 = ';
533: end if;
534: aso_debug_pub.add ('IBU: return_att1 = ' || l_qte_line_dtl_tbl (i).return_attribute1 , 1, 'Y');
535:
536: if ( l_qte_line_dtl_tbl (i).return_attribute2 <> FND_API.G_MISS_CHAR) then
537: l_ibu_ret_line_dtl_info := l_ibu_ret_line_dtl_prpt_info || 'return_att2 = ' || l_qte_line_dtl_tbl (i).return_attribute2 || ' , ';
538: else

Line 541: aso_debug_pub.add ('IBU: return_att2 = ' || l_qte_line_dtl_tbl (i).return_attribute2 , 1, 'Y');

537: l_ibu_ret_line_dtl_info := l_ibu_ret_line_dtl_prpt_info || 'return_att2 = ' || l_qte_line_dtl_tbl (i).return_attribute2 || ' , ';
538: else
539: l_ibu_ret_line_dtl_info := l_ibu_ret_line_dtl_prpt_info || 'return_att2 = ';
540: end if;
541: aso_debug_pub.add ('IBU: return_att2 = ' || l_qte_line_dtl_tbl (i).return_attribute2 , 1, 'Y');
542:
543: if ( l_qte_line_dtl_tbl (i).return_ref_header_id <> FND_API.G_MISS_NUM) then
544: l_ibu_ret_line_dtl_info := l_ibu_ret_line_dtl_prpt_info || 'ret_head_id_ = ' || l_qte_line_dtl_tbl (i).return_ref_header_id || ' , ';
545: else

Line 548: aso_debug_pub.add ('IBU: ret_head_id_ = ' || l_qte_line_dtl_tbl (i).return_ref_header_id , 1, 'Y');

544: l_ibu_ret_line_dtl_info := l_ibu_ret_line_dtl_prpt_info || 'ret_head_id_ = ' || l_qte_line_dtl_tbl (i).return_ref_header_id || ' , ';
545: else
546: l_ibu_ret_line_dtl_info := l_ibu_ret_line_dtl_prpt_info || 'ret_head_id_ = ' ;
547: end if;
548: aso_debug_pub.add ('IBU: ret_head_id_ = ' || l_qte_line_dtl_tbl (i).return_ref_header_id , 1, 'Y');
549:
550: if ( l_qte_line_dtl_tbl (i).return_ref_line_id <> FND_API.G_MISS_NUM) then
551: l_ibu_ret_line_dtl_info := l_ibu_ret_line_dtl_prpt_info || 'ret_line_id = ' || l_qte_line_dtl_tbl (i).return_ref_line_id || ' , ';
552: else

Line 555: aso_debug_pub.add ('IBU: ret_line_id = ' || l_qte_line_dtl_tbl (i).return_ref_line_id , 1, 'Y');

551: l_ibu_ret_line_dtl_info := l_ibu_ret_line_dtl_prpt_info || 'ret_line_id = ' || l_qte_line_dtl_tbl (i).return_ref_line_id || ' , ';
552: else
553: l_ibu_ret_line_dtl_info := l_ibu_ret_line_dtl_prpt_info || 'ret_line_id = ';
554: end if;
555: aso_debug_pub.add ('IBU: ret_line_id = ' || l_qte_line_dtl_tbl (i).return_ref_line_id , 1, 'Y');
556:
557:
558: if ( l_qte_line_dtl_tbl (i).return_reason_code <> FND_API.G_MISS_CHAR) then
559: l_ibu_ret_line_dtl_info := l_ibu_ret_line_dtl_prpt_info || 're_reas_code = ' || l_qte_line_dtl_tbl (i).return_reason_code || ' , ';

Line 563: aso_debug_pub.add ('IBU: re_reas_code = ' || l_qte_line_dtl_tbl (i).return_reason_code , 1, 'Y');

559: l_ibu_ret_line_dtl_info := l_ibu_ret_line_dtl_prpt_info || 're_reas_code = ' || l_qte_line_dtl_tbl (i).return_reason_code || ' , ';
560: else
561: l_ibu_ret_line_dtl_info := l_ibu_ret_line_dtl_prpt_info || 're_reas_code = ';
562: end if;
563: aso_debug_pub.add ('IBU: re_reas_code = ' || l_qte_line_dtl_tbl (i).return_reason_code , 1, 'Y');
564:
565:
566:
567: l_ibu_ret_line_dtl_prpt_info := 'l_line_shipment_tbl(' || i || '): ';

Line 568: aso_debug_pub.add ('IBU: l_line_shipment_tbl(' || i || '): ' , 1, 'Y');

564:
565:
566:
567: l_ibu_ret_line_dtl_prpt_info := 'l_line_shipment_tbl(' || i || '): ';
568: aso_debug_pub.add ('IBU: l_line_shipment_tbl(' || i || '): ' , 1, 'Y');
569:
570:
571: l_ibu_ret_line_dtl_prpt_info :='';
572:

Line 579: aso_debug_pub.add ('IBU: op_code = ' || l_line_shipment_tbl (i).operation_code , 1, 'Y');

575: l_ibu_ret_line_dtl_info := l_ibu_ret_line_dtl_prpt_info || 'op_code = ' || l_line_shipment_tbl (i).operation_code || ' , ';
576: else
577: l_ibu_ret_line_dtl_info := l_ibu_ret_line_dtl_prpt_info || 'op_code = ';
578: end if;
579: aso_debug_pub.add ('IBU: op_code = ' || l_line_shipment_tbl (i).operation_code , 1, 'Y');
580:
581: if ( l_line_shipment_tbl (i).qte_line_index <> FND_API.G_MISS_NUM ) then
582: l_ibu_ret_line_dtl_info := l_ibu_ret_line_dtl_prpt_info || 'qte_line_index = ' || l_line_shipment_tbl (i).qte_line_index || ' , ';
583: else

Line 586: aso_debug_pub.add ('IBU: qte_line_index = ' || l_line_shipment_tbl (i).qte_line_index , 1, 'Y');

582: l_ibu_ret_line_dtl_info := l_ibu_ret_line_dtl_prpt_info || 'qte_line_index = ' || l_line_shipment_tbl (i).qte_line_index || ' , ';
583: else
584: l_ibu_ret_line_dtl_info := l_ibu_ret_line_dtl_prpt_info || 'qte_line_index = ';
585: end if;
586: aso_debug_pub.add ('IBU: qte_line_index = ' || l_line_shipment_tbl (i).qte_line_index , 1, 'Y');
587:
588: if ( l_line_shipment_tbl (i).quantity <> FND_API.G_MISS_NUM ) then
589: l_ibu_ret_line_dtl_info := l_ibu_ret_line_dtl_prpt_info || 'quantity = ' || l_line_shipment_tbl (i).quantity || ' , ';
590: else

Line 593: aso_debug_pub.add ('IBU: quantity = ' || l_line_shipment_tbl (i).quantity , 1, 'Y');

589: l_ibu_ret_line_dtl_info := l_ibu_ret_line_dtl_prpt_info || 'quantity = ' || l_line_shipment_tbl (i).quantity || ' , ';
590: else
591: l_ibu_ret_line_dtl_info := l_ibu_ret_line_dtl_prpt_info || 'quantity = ';
592: end if;
593: aso_debug_pub.add ('IBU: quantity = ' || l_line_shipment_tbl (i).quantity , 1, 'Y');
594:
595: if ( l_line_shipment_tbl (i).freight_carrier_code <> FND_API.G_MISS_CHAR) then
596: l_ibu_ret_line_dtl_info := l_ibu_ret_line_dtl_prpt_info || 'freight_car_code = ' || l_line_shipment_tbl (i).freight_carrier_code || ' , ';
597: else

Line 600: aso_debug_pub.add ('IBU: freight_car_code = ' || l_line_shipment_tbl (i).freight_carrier_code , 1, 'Y');

596: l_ibu_ret_line_dtl_info := l_ibu_ret_line_dtl_prpt_info || 'freight_car_code = ' || l_line_shipment_tbl (i).freight_carrier_code || ' , ';
597: else
598: l_ibu_ret_line_dtl_info := l_ibu_ret_line_dtl_prpt_info || 'freight_car_code = ';
599: end if;
600: aso_debug_pub.add ('IBU: freight_car_code = ' || l_line_shipment_tbl (i).freight_carrier_code , 1, 'Y');
601:
602:
603: if ( l_line_shipment_tbl (i).schedule_ship_date <> FND_API.G_MISS_DATE) then
604: l_ibu_ret_line_dtl_info := l_ibu_ret_line_dtl_prpt_info || 'sche_ship_date = ' || l_line_shipment_tbl (i).schedule_ship_date || ' , ';

Line 608: aso_debug_pub.add ('IBU: sche_ship_date = ' || l_line_shipment_tbl (i).schedule_ship_date , 1, 'Y');

604: l_ibu_ret_line_dtl_info := l_ibu_ret_line_dtl_prpt_info || 'sche_ship_date = ' || l_line_shipment_tbl (i).schedule_ship_date || ' , ';
605: else
606: l_ibu_ret_line_dtl_info := l_ibu_ret_line_dtl_prpt_info || 'sche_ship_date = ' ;
607: end if;
608: aso_debug_pub.add ('IBU: sche_ship_date = ' || l_line_shipment_tbl (i).schedule_ship_date , 1, 'Y');
609:
610: if ( l_line_shipment_tbl (i).request_date <> FND_API.G_MISS_DATE) then
611: l_ibu_ret_line_dtl_info := l_ibu_ret_line_dtl_prpt_info || 'request_date = ' || l_line_shipment_tbl (i).request_date || ' , ';
612: else

Line 615: aso_debug_pub.add ('IBU: request_date = ' || l_line_shipment_tbl (i).request_date , 1, 'Y');

611: l_ibu_ret_line_dtl_info := l_ibu_ret_line_dtl_prpt_info || 'request_date = ' || l_line_shipment_tbl (i).request_date || ' , ';
612: else
613: l_ibu_ret_line_dtl_info := l_ibu_ret_line_dtl_prpt_info || 'request_date = ' ;
614: end if;
615: aso_debug_pub.add ('IBU: request_date = ' || l_line_shipment_tbl (i).request_date , 1, 'Y');
616:
617: if ( l_line_shipment_tbl (i).ship_to_party_site_id <> FND_API.G_MISS_NUM) then
618: l_ibu_ret_line_dtl_info := l_ibu_ret_line_dtl_prpt_info || 'ship_to_pty_site_id = ' || l_line_shipment_tbl (i).ship_to_party_site_id || ' , ';
619: else

Line 622: aso_debug_pub.add ('IBU: ship_to_pty_site_id = ' || l_line_shipment_tbl (i).ship_to_party_site_id , 1, 'Y');

618: l_ibu_ret_line_dtl_info := l_ibu_ret_line_dtl_prpt_info || 'ship_to_pty_site_id = ' || l_line_shipment_tbl (i).ship_to_party_site_id || ' , ';
619: else
620: l_ibu_ret_line_dtl_info := l_ibu_ret_line_dtl_prpt_info || 'ship_to_pty_site_id = ';
621: end if;
622: aso_debug_pub.add ('IBU: ship_to_pty_site_id = ' || l_line_shipment_tbl (i).ship_to_party_site_id , 1, 'Y');
623:
624: end loop;
625: end if;
626: l_booked_profile_value := FND_PROFILE.VALUE_WNPS('ASO_DEFAULT_ORDER_STATE');

Line 635: aso_debug_pub.add ('IBU: ' || l_ibu_ret_header_prpt_info , 1, 'Y');

631: end if;
632:
633: l_ibu_ret_header_prpt_info := 'bk_flg='|| l_control_rec.book_flag ;
634:
635: aso_debug_pub.add ('IBU: ' || l_ibu_ret_header_prpt_info , 1, 'Y');
636:
637: aso_order_int.create_order (
638: p_api_version_number => 1.0,
639: p_init_msg_list => FND_API.G_FALSE,