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_WORKFLOW_PVT dependencies on ASO_DEBUG_PUB

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

125: l_event_type := 'ORDERROR';
126: l_notifName := 'ORDERROR';
127:
128: l_errmsg_count := p_errmsg_count;
129: IF aso_debug_pub.g_debug_flag = 'Y' THEN
130: ASO_DEBUG_PUB.add('Notify Order Status - Error Message Count - '||to_char(l_errmsg_count),1,'Y');
131: END IF;
132:
133: IF ( l_errmsg_count = 1 ) THEN

Line 130: ASO_DEBUG_PUB.add('Notify Order Status - Error Message Count - '||to_char(l_errmsg_count),1,'Y');

126: l_notifName := 'ORDERROR';
127:
128: l_errmsg_count := p_errmsg_count;
129: IF aso_debug_pub.g_debug_flag = 'Y' THEN
130: ASO_DEBUG_PUB.add('Notify Order Status - Error Message Count - '||to_char(l_errmsg_count),1,'Y');
131: END IF;
132:
133: IF ( l_errmsg_count = 1 ) THEN
134: l_errmsg_data := p_errmsg_data;

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

142: l_this := l_this + 1;
143: END LOOP;
144: END IF;
145:
146: IF aso_debug_pub.g_debug_flag = 'Y' THEN
147: ASO_DEBUG_PUB.add('NotifyOrderStatus - Error Message Data After LOOP - '||l_errmsg_data,1,'Y');
148: END IF;
149:
150:

Line 147: ASO_DEBUG_PUB.add('NotifyOrderStatus - Error Message Data After LOOP - '||l_errmsg_data,1,'Y');

143: END LOOP;
144: END IF;
145:
146: IF aso_debug_pub.g_debug_flag = 'Y' THEN
147: ASO_DEBUG_PUB.add('NotifyOrderStatus - Error Message Data After LOOP - '||l_errmsg_data,1,'Y');
148: END IF;
149:
150:
151: l_adhoc_user := FND_PROFILE.VALUE('ASO_ADMIN_EMAIL');

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

174: expiration_date => sysdate+10 );
175:
176: End If;
177:
178: IF aso_debug_pub.g_debug_flag = 'Y' THEN
179: ASO_DEBUG_PUB.add('NotifyOrderStatus - p_quote_id - '||to_char(p_quote_id)||','||p_status,1,'Y');
180: END IF;
181:
182: l_item_key := l_event_type||'-'||to_char(sysdate,'MMDDYYHH24MISS')||'-'||p_quote_id;

Line 179: ASO_DEBUG_PUB.add('NotifyOrderStatus - p_quote_id - '||to_char(p_quote_id)||','||p_status,1,'Y');

175:
176: End If;
177:
178: IF aso_debug_pub.g_debug_flag = 'Y' THEN
179: ASO_DEBUG_PUB.add('NotifyOrderStatus - p_quote_id - '||to_char(p_quote_id)||','||p_status,1,'Y');
180: END IF;
181:
182: l_item_key := l_event_type||'-'||to_char(sysdate,'MMDDYYHH24MISS')||'-'||p_quote_id;
183:

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

182: l_item_key := l_event_type||'-'||to_char(sysdate,'MMDDYYHH24MISS')||'-'||p_quote_id;
183:
184: /* Item Key should be Unique as it represent a process instance with ITEM TYPE*/
185:
186: IF aso_debug_pub.g_debug_flag = 'Y' THEN
187: ASO_DEBUG_PUB.add('Create and Start Process with Item Key: '||l_item_key,1,'Y');
188: END IF;
189:
190: wf_engine.CreateProcess(

Line 187: ASO_DEBUG_PUB.add('Create and Start Process with Item Key: '||l_item_key,1,'Y');

183:
184: /* Item Key should be Unique as it represent a process instance with ITEM TYPE*/
185:
186: IF aso_debug_pub.g_debug_flag = 'Y' THEN
187: ASO_DEBUG_PUB.add('Create and Start Process with Item Key: '||l_item_key,1,'Y');
188: END IF;
189:
190: wf_engine.CreateProcess(
191: itemtype => g_ItemType,

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

236: wf_engine.StartProcess(
237: itemtype => g_ItemType,
238: itemkey => l_item_key);
239:
240: IF aso_debug_pub.g_debug_flag = 'Y' THEN
241: ASO_DEBUG_PUB.add('Process Started',1,'Y');
242: END IF;
243:
244: Exception

Line 241: ASO_DEBUG_PUB.add('Process Started',1,'Y');

237: itemtype => g_ItemType,
238: itemkey => l_item_key);
239:
240: IF aso_debug_pub.g_debug_flag = 'Y' THEN
241: ASO_DEBUG_PUB.add('Process Started',1,'Y');
242: END IF;
243:
244: Exception
245: When OTHERS Then

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

329: BEGIN
330:
331: l_item_key := document_id;
332:
333: IF aso_debug_pub.g_debug_flag = 'Y' THEN
334: ASO_DEBUG_PUB.add('GenerateQuoteHeader - l_item_key - '||l_item_key,1,'Y');
335: END IF;
336:
337: l_quote_id := wf_engine.GetItemAttrText (

Line 334: ASO_DEBUG_PUB.add('GenerateQuoteHeader - l_item_key - '||l_item_key,1,'Y');

330:
331: l_item_key := document_id;
332:
333: IF aso_debug_pub.g_debug_flag = 'Y' THEN
334: ASO_DEBUG_PUB.add('GenerateQuoteHeader - l_item_key - '||l_item_key,1,'Y');
335: END IF;
336:
337: l_quote_id := wf_engine.GetItemAttrText (
338: itemtype => g_ItemType,

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

339: itemkey => l_item_key,
340: aname => 'QUOTE_ID'
341: );
342:
343: IF aso_debug_pub.g_debug_flag = 'Y' THEN
344: ASO_DEBUG_PUB.add('GenerateQuoteHeader - l_quote_id - '||l_quote_id,1,'Y');
345: END IF;
346:
347: l_event_type := wf_engine.GetItemAttrText (

Line 344: ASO_DEBUG_PUB.add('GenerateQuoteHeader - l_quote_id - '||l_quote_id,1,'Y');

340: aname => 'QUOTE_ID'
341: );
342:
343: IF aso_debug_pub.g_debug_flag = 'Y' THEN
344: ASO_DEBUG_PUB.add('GenerateQuoteHeader - l_quote_id - '||l_quote_id,1,'Y');
345: END IF;
346:
347: l_event_type := wf_engine.GetItemAttrText (
348: itemtype => g_ItemType,

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

349: itemkey => l_item_key,
350: aname => 'EVENTTYPE'
351: );
352:
353: IF aso_debug_pub.g_debug_flag = 'Y' THEN
354: aso_debug_pub.add('GenerateQuoteHeader - l_event_type - '|| l_event_type,1,'Y');
355: END IF;
356:
357: OPEN c_quote_header(l_quote_id);

Line 354: aso_debug_pub.add('GenerateQuoteHeader - l_event_type - '|| l_event_type,1,'Y');

350: aname => 'EVENTTYPE'
351: );
352:
353: IF aso_debug_pub.g_debug_flag = 'Y' THEN
354: aso_debug_pub.add('GenerateQuoteHeader - l_event_type - '|| l_event_type,1,'Y');
355: END IF;
356:
357: OPEN c_quote_header(l_quote_id);
358: LOOP

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

379: l_sold_contact_party_id := c_hz_cust_acct_rec.party_id;
380: End Loop;
381: End If;
382:
383: IF aso_debug_pub.g_debug_flag = 'Y' THEN
384: ASO_DEBUG_PUB.add('GenerateQuoteHeader - l_contact_name '|| l_contact_name,1,'Y');
385: END IF;
386:
387: l_contact_number := null;

Line 384: ASO_DEBUG_PUB.add('GenerateQuoteHeader - l_contact_name '|| l_contact_name,1,'Y');

380: End Loop;
381: End If;
382:
383: IF aso_debug_pub.g_debug_flag = 'Y' THEN
384: ASO_DEBUG_PUB.add('GenerateQuoteHeader - l_contact_name '|| l_contact_name,1,'Y');
385: END IF;
386:
387: l_contact_number := null;
388: l_contact_email := null;

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

400:
401: End If;
402: END LOOP;
403:
404: IF aso_debug_pub.g_debug_flag = 'Y' THEN
405: ASO_DEBUG_PUB.add('GenerateQuoteHeader - l_contact_number - '|| l_contact_number,1,'Y');
406: ASO_DEBUG_PUB.add('GenerateQuoteHeader - l_contact_email - '|| l_contact_email,1,'Y');
407: END IF;
408:

Line 405: ASO_DEBUG_PUB.add('GenerateQuoteHeader - l_contact_number - '|| l_contact_number,1,'Y');

401: End If;
402: END LOOP;
403:
404: IF aso_debug_pub.g_debug_flag = 'Y' THEN
405: ASO_DEBUG_PUB.add('GenerateQuoteHeader - l_contact_number - '|| l_contact_number,1,'Y');
406: ASO_DEBUG_PUB.add('GenerateQuoteHeader - l_contact_email - '|| l_contact_email,1,'Y');
407: END IF;
408:
409:

Line 406: ASO_DEBUG_PUB.add('GenerateQuoteHeader - l_contact_email - '|| l_contact_email,1,'Y');

402: END LOOP;
403:
404: IF aso_debug_pub.g_debug_flag = 'Y' THEN
405: ASO_DEBUG_PUB.add('GenerateQuoteHeader - l_contact_number - '|| l_contact_number,1,'Y');
406: ASO_DEBUG_PUB.add('GenerateQuoteHeader - l_contact_email - '|| l_contact_email,1,'Y');
407: END IF;
408:
409:
410: /* Get all billing information */

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

420: l_bill_to_name := upper(rtrim(c_hz_cust_acct_rec.person_first_name))||' '||upper(rtrim(c_hz_cust_acct_rec.person_last_name));
421: l_bill_contact_party_id := c_hz_cust_acct_rec.party_id;
422: End Loop;
423:
424: IF aso_debug_pub.g_debug_flag = 'Y' THEN
425: ASO_DEBUG_PUB.add('GenerateQuoteHeader - bill_party_name - '||l_bill_to_party_name,1,'Y');
426: ASO_DEBUG_PUB.add('GenerateQuoteHeader - bill_name - '||l_bill_to_name,1,'Y');
427: END IF;
428:

Line 425: ASO_DEBUG_PUB.add('GenerateQuoteHeader - bill_party_name - '||l_bill_to_party_name,1,'Y');

421: l_bill_contact_party_id := c_hz_cust_acct_rec.party_id;
422: End Loop;
423:
424: IF aso_debug_pub.g_debug_flag = 'Y' THEN
425: ASO_DEBUG_PUB.add('GenerateQuoteHeader - bill_party_name - '||l_bill_to_party_name,1,'Y');
426: ASO_DEBUG_PUB.add('GenerateQuoteHeader - bill_name - '||l_bill_to_name,1,'Y');
427: END IF;
428:
429:

Line 426: ASO_DEBUG_PUB.add('GenerateQuoteHeader - bill_name - '||l_bill_to_name,1,'Y');

422: End Loop;
423:
424: IF aso_debug_pub.g_debug_flag = 'Y' THEN
425: ASO_DEBUG_PUB.add('GenerateQuoteHeader - bill_party_name - '||l_bill_to_party_name,1,'Y');
426: ASO_DEBUG_PUB.add('GenerateQuoteHeader - bill_name - '||l_bill_to_name,1,'Y');
427: END IF;
428:
429:
430: l_bill_to_number := null;

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

452:
453: End If;
454: END LOOP;
455:
456: IF aso_debug_pub.g_debug_flag = 'Y' THEN
457: ASO_DEBUG_PUB.add('GenerateQuoteHeader - bill_party_number - '||l_bill_to_number,1,'Y');
458: ASO_DEBUG_PUB.add('GenerateQuoteHeader - bill_fax - '||l_bill_to_fax,1,'Y');
459: END IF;
460: l_bill_to_address := null;

Line 457: ASO_DEBUG_PUB.add('GenerateQuoteHeader - bill_party_number - '||l_bill_to_number,1,'Y');

453: End If;
454: END LOOP;
455:
456: IF aso_debug_pub.g_debug_flag = 'Y' THEN
457: ASO_DEBUG_PUB.add('GenerateQuoteHeader - bill_party_number - '||l_bill_to_number,1,'Y');
458: ASO_DEBUG_PUB.add('GenerateQuoteHeader - bill_fax - '||l_bill_to_fax,1,'Y');
459: END IF;
460: l_bill_to_address := null;
461: l_bill_to_city := null;

Line 458: ASO_DEBUG_PUB.add('GenerateQuoteHeader - bill_fax - '||l_bill_to_fax,1,'Y');

454: END LOOP;
455:
456: IF aso_debug_pub.g_debug_flag = 'Y' THEN
457: ASO_DEBUG_PUB.add('GenerateQuoteHeader - bill_party_number - '||l_bill_to_number,1,'Y');
458: ASO_DEBUG_PUB.add('GenerateQuoteHeader - bill_fax - '||l_bill_to_fax,1,'Y');
459: END IF;
460: l_bill_to_address := null;
461: l_bill_to_city := null;
462: l_bill_to_state := null;

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

474: l_bill_to_country := c_hz_locations_rec.loc_country;
475:
476: END LOOP;
477:
478: IF aso_debug_pub.g_debug_flag = 'Y' THEN
479: ASO_DEBUG_PUB.add('GenerateQuoteHeader - bill_address - '||l_bill_to_address,1,'Y');
480: ASO_DEBUG_PUB.add('GenerateQuoteHeader - bill_city - '||l_bill_to_city,1,'Y');
481: ASO_DEBUG_PUB.add('GenerateQuoteHeader - bill_state - '||l_bill_to_state,1,'Y');
482: ASO_DEBUG_PUB.add('GenerateQuoteHeader - bill_zip - '||l_bill_to_zip,1,'Y');

Line 479: ASO_DEBUG_PUB.add('GenerateQuoteHeader - bill_address - '||l_bill_to_address,1,'Y');

475:
476: END LOOP;
477:
478: IF aso_debug_pub.g_debug_flag = 'Y' THEN
479: ASO_DEBUG_PUB.add('GenerateQuoteHeader - bill_address - '||l_bill_to_address,1,'Y');
480: ASO_DEBUG_PUB.add('GenerateQuoteHeader - bill_city - '||l_bill_to_city,1,'Y');
481: ASO_DEBUG_PUB.add('GenerateQuoteHeader - bill_state - '||l_bill_to_state,1,'Y');
482: ASO_DEBUG_PUB.add('GenerateQuoteHeader - bill_zip - '||l_bill_to_zip,1,'Y');
483: ASO_DEBUG_PUB.add('GenerateQuoteHeader - bill_country - '||l_bill_to_country,1,'Y');

Line 480: ASO_DEBUG_PUB.add('GenerateQuoteHeader - bill_city - '||l_bill_to_city,1,'Y');

476: END LOOP;
477:
478: IF aso_debug_pub.g_debug_flag = 'Y' THEN
479: ASO_DEBUG_PUB.add('GenerateQuoteHeader - bill_address - '||l_bill_to_address,1,'Y');
480: ASO_DEBUG_PUB.add('GenerateQuoteHeader - bill_city - '||l_bill_to_city,1,'Y');
481: ASO_DEBUG_PUB.add('GenerateQuoteHeader - bill_state - '||l_bill_to_state,1,'Y');
482: ASO_DEBUG_PUB.add('GenerateQuoteHeader - bill_zip - '||l_bill_to_zip,1,'Y');
483: ASO_DEBUG_PUB.add('GenerateQuoteHeader - bill_country - '||l_bill_to_country,1,'Y');
484: END IF;

Line 481: ASO_DEBUG_PUB.add('GenerateQuoteHeader - bill_state - '||l_bill_to_state,1,'Y');

477:
478: IF aso_debug_pub.g_debug_flag = 'Y' THEN
479: ASO_DEBUG_PUB.add('GenerateQuoteHeader - bill_address - '||l_bill_to_address,1,'Y');
480: ASO_DEBUG_PUB.add('GenerateQuoteHeader - bill_city - '||l_bill_to_city,1,'Y');
481: ASO_DEBUG_PUB.add('GenerateQuoteHeader - bill_state - '||l_bill_to_state,1,'Y');
482: ASO_DEBUG_PUB.add('GenerateQuoteHeader - bill_zip - '||l_bill_to_zip,1,'Y');
483: ASO_DEBUG_PUB.add('GenerateQuoteHeader - bill_country - '||l_bill_to_country,1,'Y');
484: END IF;
485:

Line 482: ASO_DEBUG_PUB.add('GenerateQuoteHeader - bill_zip - '||l_bill_to_zip,1,'Y');

478: IF aso_debug_pub.g_debug_flag = 'Y' THEN
479: ASO_DEBUG_PUB.add('GenerateQuoteHeader - bill_address - '||l_bill_to_address,1,'Y');
480: ASO_DEBUG_PUB.add('GenerateQuoteHeader - bill_city - '||l_bill_to_city,1,'Y');
481: ASO_DEBUG_PUB.add('GenerateQuoteHeader - bill_state - '||l_bill_to_state,1,'Y');
482: ASO_DEBUG_PUB.add('GenerateQuoteHeader - bill_zip - '||l_bill_to_zip,1,'Y');
483: ASO_DEBUG_PUB.add('GenerateQuoteHeader - bill_country - '||l_bill_to_country,1,'Y');
484: END IF;
485:
486: /* Get all shipping information */

Line 483: ASO_DEBUG_PUB.add('GenerateQuoteHeader - bill_country - '||l_bill_to_country,1,'Y');

479: ASO_DEBUG_PUB.add('GenerateQuoteHeader - bill_address - '||l_bill_to_address,1,'Y');
480: ASO_DEBUG_PUB.add('GenerateQuoteHeader - bill_city - '||l_bill_to_city,1,'Y');
481: ASO_DEBUG_PUB.add('GenerateQuoteHeader - bill_state - '||l_bill_to_state,1,'Y');
482: ASO_DEBUG_PUB.add('GenerateQuoteHeader - bill_zip - '||l_bill_to_zip,1,'Y');
483: ASO_DEBUG_PUB.add('GenerateQuoteHeader - bill_country - '||l_bill_to_country,1,'Y');
484: END IF;
485:
486: /* Get all shipping information */
487:

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

499: For c_ship_method_rec in c_ship_methods(l_ship_method_code) LOOP
500: l_Ship_Method := c_ship_method_rec.Meaning;
501: End Loop;
502:
503: IF aso_debug_pub.g_debug_flag = 'Y' THEN
504: ASO_DEBUG_PUB.add('GenerateQuoteHeader - ship_to_site_id - '||l_ship_to_site_id,1,'Y');
505: ASO_DEBUG_PUB.add('GenerateQuoteHeader - ship_to_party_id - '||l_ship_to_party_id,1,'Y');
506: ASO_DEBUG_PUB.add('GenerateQuoteHeader - ship_to_method - '||l_ship_method_code,1,'Y');
507: END IF;

Line 504: ASO_DEBUG_PUB.add('GenerateQuoteHeader - ship_to_site_id - '||l_ship_to_site_id,1,'Y');

500: l_Ship_Method := c_ship_method_rec.Meaning;
501: End Loop;
502:
503: IF aso_debug_pub.g_debug_flag = 'Y' THEN
504: ASO_DEBUG_PUB.add('GenerateQuoteHeader - ship_to_site_id - '||l_ship_to_site_id,1,'Y');
505: ASO_DEBUG_PUB.add('GenerateQuoteHeader - ship_to_party_id - '||l_ship_to_party_id,1,'Y');
506: ASO_DEBUG_PUB.add('GenerateQuoteHeader - ship_to_method - '||l_ship_method_code,1,'Y');
507: END IF;
508:

Line 505: ASO_DEBUG_PUB.add('GenerateQuoteHeader - ship_to_party_id - '||l_ship_to_party_id,1,'Y');

501: End Loop;
502:
503: IF aso_debug_pub.g_debug_flag = 'Y' THEN
504: ASO_DEBUG_PUB.add('GenerateQuoteHeader - ship_to_site_id - '||l_ship_to_site_id,1,'Y');
505: ASO_DEBUG_PUB.add('GenerateQuoteHeader - ship_to_party_id - '||l_ship_to_party_id,1,'Y');
506: ASO_DEBUG_PUB.add('GenerateQuoteHeader - ship_to_method - '||l_ship_method_code,1,'Y');
507: END IF;
508:
509: /* Shipping Customer Information - ship_to_cust_account_id */

Line 506: ASO_DEBUG_PUB.add('GenerateQuoteHeader - ship_to_method - '||l_ship_method_code,1,'Y');

502:
503: IF aso_debug_pub.g_debug_flag = 'Y' THEN
504: ASO_DEBUG_PUB.add('GenerateQuoteHeader - ship_to_site_id - '||l_ship_to_site_id,1,'Y');
505: ASO_DEBUG_PUB.add('GenerateQuoteHeader - ship_to_party_id - '||l_ship_to_party_id,1,'Y');
506: ASO_DEBUG_PUB.add('GenerateQuoteHeader - ship_to_method - '||l_ship_method_code,1,'Y');
507: END IF;
508:
509: /* Shipping Customer Information - ship_to_cust_account_id */
510:

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

514: l_ship_contact_party_id := c_hz_cust_acct_rec.party_id;
515: End Loop;
516:
517:
518: IF aso_debug_pub.g_debug_flag = 'Y' THEN
519: ASO_DEBUG_PUB.add('GenerateQuoteHeader - ship_to_party_name - '||l_ship_to_party_name,1,'Y');
520: ASO_DEBUG_PUB.add('GenerateQuoteHeader - ship_to_name - '||l_ship_to_name,1,'Y');
521: END IF;
522:

Line 519: ASO_DEBUG_PUB.add('GenerateQuoteHeader - ship_to_party_name - '||l_ship_to_party_name,1,'Y');

515: End Loop;
516:
517:
518: IF aso_debug_pub.g_debug_flag = 'Y' THEN
519: ASO_DEBUG_PUB.add('GenerateQuoteHeader - ship_to_party_name - '||l_ship_to_party_name,1,'Y');
520: ASO_DEBUG_PUB.add('GenerateQuoteHeader - ship_to_name - '||l_ship_to_name,1,'Y');
521: END IF;
522:
523: /* Shipping Contact ship_to_party_id(PARTY_REALTIONSHIP) OR Ship Customer's Party Id */

Line 520: ASO_DEBUG_PUB.add('GenerateQuoteHeader - ship_to_name - '||l_ship_to_name,1,'Y');

516:
517:
518: IF aso_debug_pub.g_debug_flag = 'Y' THEN
519: ASO_DEBUG_PUB.add('GenerateQuoteHeader - ship_to_party_name - '||l_ship_to_party_name,1,'Y');
520: ASO_DEBUG_PUB.add('GenerateQuoteHeader - ship_to_name - '||l_ship_to_name,1,'Y');
521: END IF;
522:
523: /* Shipping Contact ship_to_party_id(PARTY_REALTIONSHIP) OR Ship Customer's Party Id */
524: If l_ship_to_party_id is not null Then

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

541:
542: End If;
543: END LOOP;
544:
545: IF aso_debug_pub.g_debug_flag = 'Y' THEN
546: ASO_DEBUG_PUB.add('GenerateQuoteHeader - ship_to_number - '||l_ship_to_number,1,'Y');
547: ASO_DEBUG_PUB.add('GenerateQuoteHeader - ship_to_fax - '||l_ship_to_fax,1,'Y');
548: END IF;
549:

Line 546: ASO_DEBUG_PUB.add('GenerateQuoteHeader - ship_to_number - '||l_ship_to_number,1,'Y');

542: End If;
543: END LOOP;
544:
545: IF aso_debug_pub.g_debug_flag = 'Y' THEN
546: ASO_DEBUG_PUB.add('GenerateQuoteHeader - ship_to_number - '||l_ship_to_number,1,'Y');
547: ASO_DEBUG_PUB.add('GenerateQuoteHeader - ship_to_fax - '||l_ship_to_fax,1,'Y');
548: END IF;
549:
550: l_ship_to_address := null;

Line 547: ASO_DEBUG_PUB.add('GenerateQuoteHeader - ship_to_fax - '||l_ship_to_fax,1,'Y');

543: END LOOP;
544:
545: IF aso_debug_pub.g_debug_flag = 'Y' THEN
546: ASO_DEBUG_PUB.add('GenerateQuoteHeader - ship_to_number - '||l_ship_to_number,1,'Y');
547: ASO_DEBUG_PUB.add('GenerateQuoteHeader - ship_to_fax - '||l_ship_to_fax,1,'Y');
548: END IF;
549:
550: l_ship_to_address := null;
551: l_ship_to_city := null;

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

563:
564: END LOOP;
565:
566:
567: IF aso_debug_pub.g_debug_flag = 'Y' THEN
568: ASO_DEBUG_PUB.add('GenerateQuoteHeader - ship_address - '||l_ship_to_address,1,'Y');
569: ASO_DEBUG_PUB.add('GenerateQuoteHeader - ship_city - '||l_ship_to_city,1,'Y');
570: ASO_DEBUG_PUB.add('GenerateQuoteHeader - ship_state - '||l_ship_to_state,1,'Y');
571: ASO_DEBUG_PUB.add('GenerateQuoteHeader - ship_zip - '||l_ship_to_zip,1,'Y');

Line 568: ASO_DEBUG_PUB.add('GenerateQuoteHeader - ship_address - '||l_ship_to_address,1,'Y');

564: END LOOP;
565:
566:
567: IF aso_debug_pub.g_debug_flag = 'Y' THEN
568: ASO_DEBUG_PUB.add('GenerateQuoteHeader - ship_address - '||l_ship_to_address,1,'Y');
569: ASO_DEBUG_PUB.add('GenerateQuoteHeader - ship_city - '||l_ship_to_city,1,'Y');
570: ASO_DEBUG_PUB.add('GenerateQuoteHeader - ship_state - '||l_ship_to_state,1,'Y');
571: ASO_DEBUG_PUB.add('GenerateQuoteHeader - ship_zip - '||l_ship_to_zip,1,'Y');
572: ASO_DEBUG_PUB.add('GenerateQuoteHeader - ship_country - '||l_ship_to_country,1,'Y');

Line 569: ASO_DEBUG_PUB.add('GenerateQuoteHeader - ship_city - '||l_ship_to_city,1,'Y');

565:
566:
567: IF aso_debug_pub.g_debug_flag = 'Y' THEN
568: ASO_DEBUG_PUB.add('GenerateQuoteHeader - ship_address - '||l_ship_to_address,1,'Y');
569: ASO_DEBUG_PUB.add('GenerateQuoteHeader - ship_city - '||l_ship_to_city,1,'Y');
570: ASO_DEBUG_PUB.add('GenerateQuoteHeader - ship_state - '||l_ship_to_state,1,'Y');
571: ASO_DEBUG_PUB.add('GenerateQuoteHeader - ship_zip - '||l_ship_to_zip,1,'Y');
572: ASO_DEBUG_PUB.add('GenerateQuoteHeader - ship_country - '||l_ship_to_country,1,'Y');
573: ASO_DEBUG_PUB.add('GenerateQuoteHeader - quote_header_id - '||g_quote_header_rec.quote_header_id,1,'Y');

Line 570: ASO_DEBUG_PUB.add('GenerateQuoteHeader - ship_state - '||l_ship_to_state,1,'Y');

566:
567: IF aso_debug_pub.g_debug_flag = 'Y' THEN
568: ASO_DEBUG_PUB.add('GenerateQuoteHeader - ship_address - '||l_ship_to_address,1,'Y');
569: ASO_DEBUG_PUB.add('GenerateQuoteHeader - ship_city - '||l_ship_to_city,1,'Y');
570: ASO_DEBUG_PUB.add('GenerateQuoteHeader - ship_state - '||l_ship_to_state,1,'Y');
571: ASO_DEBUG_PUB.add('GenerateQuoteHeader - ship_zip - '||l_ship_to_zip,1,'Y');
572: ASO_DEBUG_PUB.add('GenerateQuoteHeader - ship_country - '||l_ship_to_country,1,'Y');
573: ASO_DEBUG_PUB.add('GenerateQuoteHeader - quote_header_id - '||g_quote_header_rec.quote_header_id,1,'Y');
574: END IF;

Line 571: ASO_DEBUG_PUB.add('GenerateQuoteHeader - ship_zip - '||l_ship_to_zip,1,'Y');

567: IF aso_debug_pub.g_debug_flag = 'Y' THEN
568: ASO_DEBUG_PUB.add('GenerateQuoteHeader - ship_address - '||l_ship_to_address,1,'Y');
569: ASO_DEBUG_PUB.add('GenerateQuoteHeader - ship_city - '||l_ship_to_city,1,'Y');
570: ASO_DEBUG_PUB.add('GenerateQuoteHeader - ship_state - '||l_ship_to_state,1,'Y');
571: ASO_DEBUG_PUB.add('GenerateQuoteHeader - ship_zip - '||l_ship_to_zip,1,'Y');
572: ASO_DEBUG_PUB.add('GenerateQuoteHeader - ship_country - '||l_ship_to_country,1,'Y');
573: ASO_DEBUG_PUB.add('GenerateQuoteHeader - quote_header_id - '||g_quote_header_rec.quote_header_id,1,'Y');
574: END IF;
575:

Line 572: ASO_DEBUG_PUB.add('GenerateQuoteHeader - ship_country - '||l_ship_to_country,1,'Y');

568: ASO_DEBUG_PUB.add('GenerateQuoteHeader - ship_address - '||l_ship_to_address,1,'Y');
569: ASO_DEBUG_PUB.add('GenerateQuoteHeader - ship_city - '||l_ship_to_city,1,'Y');
570: ASO_DEBUG_PUB.add('GenerateQuoteHeader - ship_state - '||l_ship_to_state,1,'Y');
571: ASO_DEBUG_PUB.add('GenerateQuoteHeader - ship_zip - '||l_ship_to_zip,1,'Y');
572: ASO_DEBUG_PUB.add('GenerateQuoteHeader - ship_country - '||l_ship_to_country,1,'Y');
573: ASO_DEBUG_PUB.add('GenerateQuoteHeader - quote_header_id - '||g_quote_header_rec.quote_header_id,1,'Y');
574: END IF;
575:
576: IF (display_type = 'text/plain' ) THEN

Line 573: ASO_DEBUG_PUB.add('GenerateQuoteHeader - quote_header_id - '||g_quote_header_rec.quote_header_id,1,'Y');

569: ASO_DEBUG_PUB.add('GenerateQuoteHeader - ship_city - '||l_ship_to_city,1,'Y');
570: ASO_DEBUG_PUB.add('GenerateQuoteHeader - ship_state - '||l_ship_to_state,1,'Y');
571: ASO_DEBUG_PUB.add('GenerateQuoteHeader - ship_zip - '||l_ship_to_zip,1,'Y');
572: ASO_DEBUG_PUB.add('GenerateQuoteHeader - ship_country - '||l_ship_to_country,1,'Y');
573: ASO_DEBUG_PUB.add('GenerateQuoteHeader - quote_header_id - '||g_quote_header_rec.quote_header_id,1,'Y');
574: END IF;
575:
576: IF (display_type = 'text/plain' ) THEN
577: fnd_message.set_name('ASO','ASO_PRMT_QUOTE_NUMBER_COLON');

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

710:
711: END LOOP;
712: CLOSE c_quote_header;
713:
714: IF aso_debug_pub.g_debug_flag = 'Y' THEN
715: ASO_DEBUG_PUB.add('GenerateQuoteHeader - l_document'||NEWLINE|| l_document,1,'Y');
716: END IF;
717:
718: document := l_document;

Line 715: ASO_DEBUG_PUB.add('GenerateQuoteHeader - l_document'||NEWLINE|| l_document,1,'Y');

711: END LOOP;
712: CLOSE c_quote_header;
713:
714: IF aso_debug_pub.g_debug_flag = 'Y' THEN
715: ASO_DEBUG_PUB.add('GenerateQuoteHeader - l_document'||NEWLINE|| l_document,1,'Y');
716: END IF;
717:
718: document := l_document;
719: document_type := 'text/plain';

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

743: itemkey => itemkey,
744: aname => 'EVENTTYPE'
745: );
746:
747: IF aso_debug_pub.g_debug_flag = 'Y' THEN
748: ASO_DEBUG_PUB.add('Selector - Inside RUN- '||l_event_type,1,'Y');
749: END IF;
750:
751: IF l_event_type = 'ORDERROR' THEN

Line 748: ASO_DEBUG_PUB.add('Selector - Inside RUN- '||l_event_type,1,'Y');

744: aname => 'EVENTTYPE'
745: );
746:
747: IF aso_debug_pub.g_debug_flag = 'Y' THEN
748: ASO_DEBUG_PUB.add('Selector - Inside RUN- '||l_event_type,1,'Y');
749: END IF;
750:
751: IF l_event_type = 'ORDERROR' THEN
752: IF aso_debug_pub.g_debug_flag = 'Y' THEN

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

748: ASO_DEBUG_PUB.add('Selector - Inside RUN- '||l_event_type,1,'Y');
749: END IF;
750:
751: IF l_event_type = 'ORDERROR' THEN
752: IF aso_debug_pub.g_debug_flag = 'Y' THEN
753: ASO_DEBUG_PUB.add('Selector - Inside order confirmation selection ',1,'Y');
754: END IF;
755: result := 'COMPLETE:ORDERROR';
756: END IF;

Line 753: ASO_DEBUG_PUB.add('Selector - Inside order confirmation selection ',1,'Y');

749: END IF;
750:
751: IF l_event_type = 'ORDERROR' THEN
752: IF aso_debug_pub.g_debug_flag = 'Y' THEN
753: ASO_DEBUG_PUB.add('Selector - Inside order confirmation selection ',1,'Y');
754: END IF;
755: result := 'COMPLETE:ORDERROR';
756: END IF;
757: END IF;