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

Line 146: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

142: l_notifName := 'ASOCONTRACTREJECTED';
143:
144: END IF;
145:
146: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
147: aso_debug_pub.add('NotifyForASOContractChange: Check if this notification is enabled.', 1, 'Y');
148: END IF;
149:
150: l_notifEnabled := IBE_WF_NOTIF_SETUP_PVT.Check_Notif_Enabled(l_notifName);

Line 147: aso_debug_pub.add('NotifyForASOContractChange: Check if this notification is enabled.', 1, 'Y');

143:
144: END IF;
145:
146: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
147: aso_debug_pub.add('NotifyForASOContractChange: Check if this notification is enabled.', 1, 'Y');
148: END IF;
149:
150: l_notifEnabled := IBE_WF_NOTIF_SETUP_PVT.Check_Notif_Enabled(l_notifName);
151:

Line 152: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

148: END IF;
149:
150: l_notifEnabled := IBE_WF_NOTIF_SETUP_PVT.Check_Notif_Enabled(l_notifName);
151:
152: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
153: aso_debug_pub.add('NotifyForASOContractChange: Notification Name: '||l_notifName||' Enabled: '||l_notifEnabled, 1, 'Y');
154: END IF;
155:
156: IF l_notifEnabled = 'Y'

Line 153: aso_debug_pub.add('NotifyForASOContractChange: Notification Name: '||l_notifName||' Enabled: '||l_notifEnabled, 1, 'Y');

149:
150: l_notifEnabled := IBE_WF_NOTIF_SETUP_PVT.Check_Notif_Enabled(l_notifName);
151:
152: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
153: aso_debug_pub.add('NotifyForASOContractChange: Notification Name: '||l_notifName||' Enabled: '||l_notifEnabled, 1, 'Y');
154: END IF;
155:
156: IF l_notifEnabled = 'Y'
157: THEN

Line 176: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

172: l_msite_id := null;
173:
174: getUserType(l_partyId,l_UserType);
175:
176: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
177: aso_debug_pub.add('NotifyForASOContractChange: Get Message - MsiteId: '||to_Char(l_msite_id)||' Org_id: '||to_char(l_quote_org_id)||' User Type: '||l_userType, 1, 'Y');
178: END IF;
179:
180: IBE_WF_MSG_MAPPING_PVT.Retrieve_Msg_Mapping

Line 177: aso_debug_pub.add('NotifyForASOContractChange: Get Message - MsiteId: '||to_Char(l_msite_id)||' Org_id: '||to_char(l_quote_org_id)||' User Type: '||l_userType, 1, 'Y');

173:
174: getUserType(l_partyId,l_UserType);
175:
176: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
177: aso_debug_pub.add('NotifyForASOContractChange: Get Message - MsiteId: '||to_Char(l_msite_id)||' Org_id: '||to_char(l_quote_org_id)||' User Type: '||l_userType, 1, 'Y');
178: END IF;
179:
180: IBE_WF_MSG_MAPPING_PVT.Retrieve_Msg_Mapping
181: (

Line 194: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

190: x_msg_count => x_msg_data
191: );
192:
193:
194: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
195: aso_debug_pub.add('NotifyForASOContractChange: Message Name: '||l_MessageName||' Enabled: '||l_msgEnabled, 1, 'Y');
196: END IF;
197:
198: IF x_msg_count > 0

Line 195: aso_debug_pub.add('NotifyForASOContractChange: Message Name: '||l_MessageName||' Enabled: '||l_msgEnabled, 1, 'Y');

191: );
192:
193:
194: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
195: aso_debug_pub.add('NotifyForASOContractChange: Message Name: '||l_MessageName||' Enabled: '||l_msgEnabled, 1, 'Y');
196: END IF;
197:
198: IF x_msg_count > 0
199: THEN

Line 206: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

202:
203: IF l_msgEnabled = 'Y'
204: THEN
205:
206: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
207: aso_debug_pub.add('NotifyForASOContractChange: NotifyForASOContractChange - eventtype - '||l_event_type, 1, 'Y');
208: END IF;
209:
210: l_item_key := l_event_type||'-'||to_char(sysdate,'MMDDYYHH24MISS')||'-C'||p_quote_id;

Line 207: aso_debug_pub.add('NotifyForASOContractChange: NotifyForASOContractChange - eventtype - '||l_event_type, 1, 'Y');

203: IF l_msgEnabled = 'Y'
204: THEN
205:
206: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
207: aso_debug_pub.add('NotifyForASOContractChange: NotifyForASOContractChange - eventtype - '||l_event_type, 1, 'Y');
208: END IF;
209:
210: l_item_key := l_event_type||'-'||to_char(sysdate,'MMDDYYHH24MISS')||'-C'||p_quote_id;
211:

Line 212: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

208: END IF;
209:
210: l_item_key := l_event_type||'-'||to_char(sysdate,'MMDDYYHH24MISS')||'-C'||p_quote_id;
211:
212: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
213: aso_debug_pub.add('NotifyForASOContractChange: Create and Start Process with Item Key: '||l_item_key, 1, 'Y');
214: END IF;
215:
216: wf_engine.CreateProcess(

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

209:
210: l_item_key := l_event_type||'-'||to_char(sysdate,'MMDDYYHH24MISS')||'-C'||p_quote_id;
211:
212: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
213: aso_debug_pub.add('NotifyForASOContractChange: Create and Start Process with Item Key: '||l_item_key, 1, 'Y');
214: END IF;
215:
216: wf_engine.CreateProcess(
217: itemtype => g_ItemType,

Line 284: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

280: itemtype => g_ItemType,
281: itemkey => l_item_key);
282:
283:
284: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
285: aso_debug_pub.add('NotifyForASOContractChange: Process Started', 1, 'Y');
286: END IF;
287: END IF; -- msgEnabled
288: END IF; -- NotiftEnabled

Line 285: aso_debug_pub.add('NotifyForASOContractChange: Process Started', 1, 'Y');

281: itemkey => l_item_key);
282:
283:
284: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
285: aso_debug_pub.add('NotifyForASOContractChange: Process Started', 1, 'Y');
286: END IF;
287: END IF; -- msgEnabled
288: END IF; -- NotiftEnabled
289:

Line 356: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

352: p_string_out := rpad(p_string_out,35,' ');
353: END IF;
354: p_string_left := substr(p_string_in,l_pos+1,length(p_string_in)-l_pos);
355: END IF;
356: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
357: aso_debug_pub.add('ParseThisString - p_string_out - '||p_string_out, 1, 'Y');
358: aso_debug_pub.add('ParseThisString - p_string_left - '||p_string_left, 1, 'Y');
359: END IF;
360: END ParseThisString;

Line 357: aso_debug_pub.add('ParseThisString - p_string_out - '||p_string_out, 1, 'Y');

353: END IF;
354: p_string_left := substr(p_string_in,l_pos+1,length(p_string_in)-l_pos);
355: END IF;
356: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
357: aso_debug_pub.add('ParseThisString - p_string_out - '||p_string_out, 1, 'Y');
358: aso_debug_pub.add('ParseThisString - p_string_left - '||p_string_left, 1, 'Y');
359: END IF;
360: END ParseThisString;
361:

Line 358: aso_debug_pub.add('ParseThisString - p_string_left - '||p_string_left, 1, 'Y');

354: p_string_left := substr(p_string_in,l_pos+1,length(p_string_in)-l_pos);
355: END IF;
356: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
357: aso_debug_pub.add('ParseThisString - p_string_out - '||p_string_out, 1, 'Y');
358: aso_debug_pub.add('ParseThisString - p_string_left - '||p_string_left, 1, 'Y');
359: END IF;
360: END ParseThisString;
361:
362: FUNCTION AddSpaces (

Line 473: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

469: BEGIN
470:
471: l_item_key := document_id;
472:
473: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
474: aso_debug_pub.add('GenerateQuoteHeader - l_item_key - '||l_item_key, 1, 'Y');
475: END IF;
476:
477: l_quote_id := wf_engine.GetItemAttrText (

Line 474: aso_debug_pub.add('GenerateQuoteHeader - l_item_key - '||l_item_key, 1, 'Y');

470:
471: l_item_key := document_id;
472:
473: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
474: aso_debug_pub.add('GenerateQuoteHeader - l_item_key - '||l_item_key, 1, 'Y');
475: END IF;
476:
477: l_quote_id := wf_engine.GetItemAttrText (
478: itemtype => g_ItemType,

Line 482: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

478: itemtype => g_ItemType,
479: itemkey => l_item_key,
480: aname => 'QUOTEID'
481: );
482: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
483: aso_debug_pub.add('GenerateQuoteHeader - l_quote_id - '||l_quote_id, 1, 'Y');
484: END IF;
485:
486: l_event_type := wf_engine.GetItemAttrText (

Line 483: aso_debug_pub.add('GenerateQuoteHeader - l_quote_id - '||l_quote_id, 1, 'Y');

479: itemkey => l_item_key,
480: aname => 'QUOTEID'
481: );
482: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
483: aso_debug_pub.add('GenerateQuoteHeader - l_quote_id - '||l_quote_id, 1, 'Y');
484: END IF;
485:
486: l_event_type := wf_engine.GetItemAttrText (
487: itemtype => g_ItemType,

Line 499: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

495: aname => 'CONTRACTNO'
496: );
497:
498:
499: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
500: aso_debug_pub.add('GenerateQuoteHeader - l_event_type - '|| l_event_type, 1, 'Y');
501: END IF;
502:
503: FOR c_contract_rec In c_contract_header(l_contract_id)

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

496: );
497:
498:
499: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
500: aso_debug_pub.add('GenerateQuoteHeader - l_event_type - '|| l_event_type, 1, 'Y');
501: END IF;
502:
503: FOR c_contract_rec In c_contract_header(l_contract_id)
504: LOOP

Line 539: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

535: l_sold_contact_party_id := c_hz_cust_acct_rec.party_id;
536: END LOOP;
537: END IF;
538:
539: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
540: aso_debug_pub.add('GenerateQuoteHeader - l_contact_name '|| l_contact_name, 1, 'Y');
541: END IF;
542:
543: l_contact_number := null;

Line 540: aso_debug_pub.add('GenerateQuoteHeader - l_contact_name '|| l_contact_name, 1, 'Y');

536: END LOOP;
537: END IF;
538:
539: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
540: aso_debug_pub.add('GenerateQuoteHeader - l_contact_name '|| l_contact_name, 1, 'Y');
541: END IF;
542:
543: l_contact_number := null;
544: l_contact_email := null;

Line 560: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

556: l_contact_email := c_hz_contact_rec.email_address;
557: END IF;
558: END LOOP;
559:
560: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
561: aso_debug_pub.add('GenerateQuoteHeader - l_contact_number - '|| l_contact_number, 1, 'Y');
562: aso_debug_pub.add('GenerateQuoteHeader - l_contact_email - '|| l_contact_email, 1, 'Y');
563: END IF;
564:

Line 561: aso_debug_pub.add('GenerateQuoteHeader - l_contact_number - '|| l_contact_number, 1, 'Y');

557: END IF;
558: END LOOP;
559:
560: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
561: aso_debug_pub.add('GenerateQuoteHeader - l_contact_number - '|| l_contact_number, 1, 'Y');
562: aso_debug_pub.add('GenerateQuoteHeader - l_contact_email - '|| l_contact_email, 1, 'Y');
563: END IF;
564:
565: /* Get all billing information */

Line 562: aso_debug_pub.add('GenerateQuoteHeader - l_contact_email - '|| l_contact_email, 1, 'Y');

558: END LOOP;
559:
560: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
561: aso_debug_pub.add('GenerateQuoteHeader - l_contact_number - '|| l_contact_number, 1, 'Y');
562: aso_debug_pub.add('GenerateQuoteHeader - l_contact_email - '|| l_contact_email, 1, 'Y');
563: END IF;
564:
565: /* Get all billing information */
566:

Line 580: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

576: l_bill_to_name := upper(rtrim(c_hz_cust_acct_rec.person_first_name))||' '||upper(rtrim(c_hz_cust_acct_rec.person_last_name));
577: l_bill_contact_party_id := c_hz_cust_acct_rec.party_id;
578: END LOOP;
579:
580: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
581: aso_debug_pub.add('GenerateQuoteHeader - bill_party_name - '||l_bill_to_party_name, 1, 'Y');
582: aso_debug_pub.add('GenerateQuoteHeader - bill_name - '||l_bill_to_name, 1, 'Y');
583: END IF;
584:

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

577: l_bill_contact_party_id := c_hz_cust_acct_rec.party_id;
578: END LOOP;
579:
580: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
581: aso_debug_pub.add('GenerateQuoteHeader - bill_party_name - '||l_bill_to_party_name, 1, 'Y');
582: aso_debug_pub.add('GenerateQuoteHeader - bill_name - '||l_bill_to_name, 1, 'Y');
583: END IF;
584:
585:

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

578: END LOOP;
579:
580: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
581: aso_debug_pub.add('GenerateQuoteHeader - bill_party_name - '||l_bill_to_party_name, 1, 'Y');
582: aso_debug_pub.add('GenerateQuoteHeader - bill_name - '||l_bill_to_name, 1, 'Y');
583: END IF;
584:
585:
586: l_bill_to_number := null;

Line 612: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

608: l_bill_to_fax := trim(c_hz_contact_rec.Phone_Country_code||' '||c_hz_contact_rec.Phone_area_code||' '||c_hz_contact_rec.Phone_number);
609: END IF;
610: END LOOP;
611:
612: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
613: aso_debug_pub.add('GenerateQuoteHeader - bill_party_number - '||l_bill_to_number, 1, 'Y');
614: aso_debug_pub.add('GenerateQuoteHeader - bill_fax - '||l_bill_to_fax, 1, 'Y');
615: END IF;
616:

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

609: END IF;
610: END LOOP;
611:
612: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
613: aso_debug_pub.add('GenerateQuoteHeader - bill_party_number - '||l_bill_to_number, 1, 'Y');
614: aso_debug_pub.add('GenerateQuoteHeader - bill_fax - '||l_bill_to_fax, 1, 'Y');
615: END IF;
616:
617: l_bill_to_address := null;

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

610: END LOOP;
611:
612: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
613: aso_debug_pub.add('GenerateQuoteHeader - bill_party_number - '||l_bill_to_number, 1, 'Y');
614: aso_debug_pub.add('GenerateQuoteHeader - bill_fax - '||l_bill_to_fax, 1, 'Y');
615: END IF;
616:
617: l_bill_to_address := null;
618: l_bill_to_city := null;

Line 636: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

632: l_bill_to_country := c_hz_locations_rec.loc_country;
633:
634: END LOOP;
635:
636: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
637: aso_debug_pub.add('GenerateQuoteHeader - bill_address - '||l_bill_to_address, 1, 'Y');
638: aso_debug_pub.add('GenerateQuoteHeader - bill_city - '||l_bill_to_city, 1, 'Y');
639: aso_debug_pub.add('GenerateQuoteHeader - bill_state - '||l_bill_to_state, 1, 'Y');
640: aso_debug_pub.add('GenerateQuoteHeader - bill_zip - '||l_bill_to_zip, 1, 'Y');

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

633:
634: END LOOP;
635:
636: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
637: aso_debug_pub.add('GenerateQuoteHeader - bill_address - '||l_bill_to_address, 1, 'Y');
638: aso_debug_pub.add('GenerateQuoteHeader - bill_city - '||l_bill_to_city, 1, 'Y');
639: aso_debug_pub.add('GenerateQuoteHeader - bill_state - '||l_bill_to_state, 1, 'Y');
640: aso_debug_pub.add('GenerateQuoteHeader - bill_zip - '||l_bill_to_zip, 1, 'Y');
641: aso_debug_pub.add('GenerateQuoteHeader - bill_country - '||l_bill_to_country, 1, 'Y');

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

634: END LOOP;
635:
636: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
637: aso_debug_pub.add('GenerateQuoteHeader - bill_address - '||l_bill_to_address, 1, 'Y');
638: aso_debug_pub.add('GenerateQuoteHeader - bill_city - '||l_bill_to_city, 1, 'Y');
639: aso_debug_pub.add('GenerateQuoteHeader - bill_state - '||l_bill_to_state, 1, 'Y');
640: aso_debug_pub.add('GenerateQuoteHeader - bill_zip - '||l_bill_to_zip, 1, 'Y');
641: aso_debug_pub.add('GenerateQuoteHeader - bill_country - '||l_bill_to_country, 1, 'Y');
642: END IF;

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

635:
636: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
637: aso_debug_pub.add('GenerateQuoteHeader - bill_address - '||l_bill_to_address, 1, 'Y');
638: aso_debug_pub.add('GenerateQuoteHeader - bill_city - '||l_bill_to_city, 1, 'Y');
639: aso_debug_pub.add('GenerateQuoteHeader - bill_state - '||l_bill_to_state, 1, 'Y');
640: aso_debug_pub.add('GenerateQuoteHeader - bill_zip - '||l_bill_to_zip, 1, 'Y');
641: aso_debug_pub.add('GenerateQuoteHeader - bill_country - '||l_bill_to_country, 1, 'Y');
642: END IF;
643:

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

636: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
637: aso_debug_pub.add('GenerateQuoteHeader - bill_address - '||l_bill_to_address, 1, 'Y');
638: aso_debug_pub.add('GenerateQuoteHeader - bill_city - '||l_bill_to_city, 1, 'Y');
639: aso_debug_pub.add('GenerateQuoteHeader - bill_state - '||l_bill_to_state, 1, 'Y');
640: aso_debug_pub.add('GenerateQuoteHeader - bill_zip - '||l_bill_to_zip, 1, 'Y');
641: aso_debug_pub.add('GenerateQuoteHeader - bill_country - '||l_bill_to_country, 1, 'Y');
642: END IF;
643:
644: /* Get all shipping information */

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

637: aso_debug_pub.add('GenerateQuoteHeader - bill_address - '||l_bill_to_address, 1, 'Y');
638: aso_debug_pub.add('GenerateQuoteHeader - bill_city - '||l_bill_to_city, 1, 'Y');
639: aso_debug_pub.add('GenerateQuoteHeader - bill_state - '||l_bill_to_state, 1, 'Y');
640: aso_debug_pub.add('GenerateQuoteHeader - bill_zip - '||l_bill_to_zip, 1, 'Y');
641: aso_debug_pub.add('GenerateQuoteHeader - bill_country - '||l_bill_to_country, 1, 'Y');
642: END IF;
643:
644: /* Get all shipping information */
645:

Line 663: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

659: LOOP
660: l_Ship_Method := c_ship_method_rec.Meaning;
661: END LOOP;
662:
663: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
664: aso_debug_pub.add('GenerateQuoteHeader - ship_to_site_id - '||l_ship_to_site_id, 1, 'Y');
665: aso_debug_pub.add('GenerateQuoteHeader - ship_to_party_id - '||l_ship_to_party_id, 1, 'Y');
666: aso_debug_pub.add('GenerateQuoteHeader - ship_to_method - '||l_ship_method_code, 1, 'Y');
667: END IF;

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

660: l_Ship_Method := c_ship_method_rec.Meaning;
661: END LOOP;
662:
663: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
664: aso_debug_pub.add('GenerateQuoteHeader - ship_to_site_id - '||l_ship_to_site_id, 1, 'Y');
665: aso_debug_pub.add('GenerateQuoteHeader - ship_to_party_id - '||l_ship_to_party_id, 1, 'Y');
666: aso_debug_pub.add('GenerateQuoteHeader - ship_to_method - '||l_ship_method_code, 1, 'Y');
667: END IF;
668:

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

661: END LOOP;
662:
663: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
664: aso_debug_pub.add('GenerateQuoteHeader - ship_to_site_id - '||l_ship_to_site_id, 1, 'Y');
665: aso_debug_pub.add('GenerateQuoteHeader - ship_to_party_id - '||l_ship_to_party_id, 1, 'Y');
666: aso_debug_pub.add('GenerateQuoteHeader - ship_to_method - '||l_ship_method_code, 1, 'Y');
667: END IF;
668:
669: /* Shipping Customer Information - ship_to_cust_account_id */

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

662:
663: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
664: aso_debug_pub.add('GenerateQuoteHeader - ship_to_site_id - '||l_ship_to_site_id, 1, 'Y');
665: aso_debug_pub.add('GenerateQuoteHeader - ship_to_party_id - '||l_ship_to_party_id, 1, 'Y');
666: aso_debug_pub.add('GenerateQuoteHeader - ship_to_method - '||l_ship_method_code, 1, 'Y');
667: END IF;
668:
669: /* Shipping Customer Information - ship_to_cust_account_id */
670:

Line 678: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

674: l_ship_to_name := upper(rtrim(c_hz_cust_acct_rec.person_first_name))||' '||upper(rtrim(c_hz_cust_acct_rec.person_last_name));
675: l_ship_contact_party_id := c_hz_cust_acct_rec.party_id;
676: END LOOP;
677:
678: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
679: aso_debug_pub.add('GenerateQuoteHeader - ship_to_party_name - '||l_ship_to_party_name, 1, 'Y');
680: aso_debug_pub.add('GenerateQuoteHeader - ship_to_name - '||l_ship_to_name, 1, 'Y');
681: END IF;
682:

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

675: l_ship_contact_party_id := c_hz_cust_acct_rec.party_id;
676: END LOOP;
677:
678: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
679: aso_debug_pub.add('GenerateQuoteHeader - ship_to_party_name - '||l_ship_to_party_name, 1, 'Y');
680: aso_debug_pub.add('GenerateQuoteHeader - ship_to_name - '||l_ship_to_name, 1, 'Y');
681: END IF;
682:
683: /* Shipping Contact ship_to_party_id(PARTY_REALTIONSHIP) OR Ship Customer's Party Id */

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

676: END LOOP;
677:
678: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
679: aso_debug_pub.add('GenerateQuoteHeader - ship_to_party_name - '||l_ship_to_party_name, 1, 'Y');
680: aso_debug_pub.add('GenerateQuoteHeader - ship_to_name - '||l_ship_to_name, 1, 'Y');
681: END IF;
682:
683: /* Shipping Contact ship_to_party_id(PARTY_REALTIONSHIP) OR Ship Customer's Party Id */
684: IF l_ship_to_party_id IS NOT NULL

Line 708: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

704: l_ship_to_fax := trim(c_hz_contact_rec.Phone_Country_code||' '||c_hz_contact_rec.Phone_area_code||' '||c_hz_contact_rec.Phone_number);
705: END IF;
706: END LOOP;
707:
708: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
709: aso_debug_pub.add('GenerateQuoteHeader - ship_to_number - '||l_ship_to_number, 1, 'Y');
710: aso_debug_pub.add('GenerateQuoteHeader - ship_to_fax - '||l_ship_to_fax, 1, 'Y');
711: END IF;
712:

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

705: END IF;
706: END LOOP;
707:
708: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
709: aso_debug_pub.add('GenerateQuoteHeader - ship_to_number - '||l_ship_to_number, 1, 'Y');
710: aso_debug_pub.add('GenerateQuoteHeader - ship_to_fax - '||l_ship_to_fax, 1, 'Y');
711: END IF;
712:
713: l_ship_to_address := null;

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

706: END LOOP;
707:
708: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
709: aso_debug_pub.add('GenerateQuoteHeader - ship_to_number - '||l_ship_to_number, 1, 'Y');
710: aso_debug_pub.add('GenerateQuoteHeader - ship_to_fax - '||l_ship_to_fax, 1, 'Y');
711: END IF;
712:
713: l_ship_to_address := null;
714: l_ship_to_city := null;

Line 731: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

727:
728: END LOOP;
729:
730:
731: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
732: aso_debug_pub.add('GenerateQuoteHeader - ship_address - '||l_ship_to_address, 1, 'Y');
733: aso_debug_pub.add('GenerateQuoteHeader - ship_city - '||l_ship_to_city, 1, 'Y');
734: aso_debug_pub.add('GenerateQuoteHeader - ship_state - '||l_ship_to_state, 1, 'Y');
735: aso_debug_pub.add('GenerateQuoteHeader - ship_zip - '||l_ship_to_zip, 1, 'Y');

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

728: END LOOP;
729:
730:
731: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
732: aso_debug_pub.add('GenerateQuoteHeader - ship_address - '||l_ship_to_address, 1, 'Y');
733: aso_debug_pub.add('GenerateQuoteHeader - ship_city - '||l_ship_to_city, 1, 'Y');
734: aso_debug_pub.add('GenerateQuoteHeader - ship_state - '||l_ship_to_state, 1, 'Y');
735: aso_debug_pub.add('GenerateQuoteHeader - ship_zip - '||l_ship_to_zip, 1, 'Y');
736: aso_debug_pub.add('GenerateQuoteHeader - ship_country - '||l_ship_to_country, 1, 'Y');

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

729:
730:
731: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
732: aso_debug_pub.add('GenerateQuoteHeader - ship_address - '||l_ship_to_address, 1, 'Y');
733: aso_debug_pub.add('GenerateQuoteHeader - ship_city - '||l_ship_to_city, 1, 'Y');
734: aso_debug_pub.add('GenerateQuoteHeader - ship_state - '||l_ship_to_state, 1, 'Y');
735: aso_debug_pub.add('GenerateQuoteHeader - ship_zip - '||l_ship_to_zip, 1, 'Y');
736: aso_debug_pub.add('GenerateQuoteHeader - ship_country - '||l_ship_to_country, 1, 'Y');
737: aso_debug_pub.add('GenerateQuoteHeader - quote_header_id - '||g_quote_header_rec.quote_header_id, 1, 'Y');

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

730:
731: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
732: aso_debug_pub.add('GenerateQuoteHeader - ship_address - '||l_ship_to_address, 1, 'Y');
733: aso_debug_pub.add('GenerateQuoteHeader - ship_city - '||l_ship_to_city, 1, 'Y');
734: aso_debug_pub.add('GenerateQuoteHeader - ship_state - '||l_ship_to_state, 1, 'Y');
735: aso_debug_pub.add('GenerateQuoteHeader - ship_zip - '||l_ship_to_zip, 1, 'Y');
736: aso_debug_pub.add('GenerateQuoteHeader - ship_country - '||l_ship_to_country, 1, 'Y');
737: aso_debug_pub.add('GenerateQuoteHeader - quote_header_id - '||g_quote_header_rec.quote_header_id, 1, 'Y');
738: END IF;

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

731: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
732: aso_debug_pub.add('GenerateQuoteHeader - ship_address - '||l_ship_to_address, 1, 'Y');
733: aso_debug_pub.add('GenerateQuoteHeader - ship_city - '||l_ship_to_city, 1, 'Y');
734: aso_debug_pub.add('GenerateQuoteHeader - ship_state - '||l_ship_to_state, 1, 'Y');
735: aso_debug_pub.add('GenerateQuoteHeader - ship_zip - '||l_ship_to_zip, 1, 'Y');
736: aso_debug_pub.add('GenerateQuoteHeader - ship_country - '||l_ship_to_country, 1, 'Y');
737: aso_debug_pub.add('GenerateQuoteHeader - quote_header_id - '||g_quote_header_rec.quote_header_id, 1, 'Y');
738: END IF;
739:

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

732: aso_debug_pub.add('GenerateQuoteHeader - ship_address - '||l_ship_to_address, 1, 'Y');
733: aso_debug_pub.add('GenerateQuoteHeader - ship_city - '||l_ship_to_city, 1, 'Y');
734: aso_debug_pub.add('GenerateQuoteHeader - ship_state - '||l_ship_to_state, 1, 'Y');
735: aso_debug_pub.add('GenerateQuoteHeader - ship_zip - '||l_ship_to_zip, 1, 'Y');
736: aso_debug_pub.add('GenerateQuoteHeader - ship_country - '||l_ship_to_country, 1, 'Y');
737: aso_debug_pub.add('GenerateQuoteHeader - quote_header_id - '||g_quote_header_rec.quote_header_id, 1, 'Y');
738: END IF;
739:
740: IF (display_type = 'text/plain' )

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

733: aso_debug_pub.add('GenerateQuoteHeader - ship_city - '||l_ship_to_city, 1, 'Y');
734: aso_debug_pub.add('GenerateQuoteHeader - ship_state - '||l_ship_to_state, 1, 'Y');
735: aso_debug_pub.add('GenerateQuoteHeader - ship_zip - '||l_ship_to_zip, 1, 'Y');
736: aso_debug_pub.add('GenerateQuoteHeader - ship_country - '||l_ship_to_country, 1, 'Y');
737: aso_debug_pub.add('GenerateQuoteHeader - quote_header_id - '||g_quote_header_rec.quote_header_id, 1, 'Y');
738: END IF;
739:
740: IF (display_type = 'text/plain' )
741: THEN

Line 879: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

875:
876: END LOOP;
877: CLOSE c_quote_header;
878:
879: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
880: aso_debug_pub.add('GenerateQuoteHeader - l_document'||NEWLINE|| l_document, 1, 'Y');
881: END IF;
882:
883: document := l_document;

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

876: END LOOP;
877: CLOSE c_quote_header;
878:
879: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
880: aso_debug_pub.add('GenerateQuoteHeader - l_document'||NEWLINE|| l_document, 1, 'Y');
881: END IF;
882:
883: document := l_document;
884: document_type := 'text/plain';

Line 937: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

933:
934:
935: l_item_key := document_id;
936:
937: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
938: aso_debug_pub.add('GenerateQuoteDetail - l_item_key - '||l_item_key, 1, 'Y');
939: END IF;
940:
941: l_quote_id := wf_engine.GetItemAttrText (

Line 938: aso_debug_pub.add('GenerateQuoteDetail - l_item_key - '||l_item_key, 1, 'Y');

934:
935: l_item_key := document_id;
936:
937: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
938: aso_debug_pub.add('GenerateQuoteDetail - l_item_key - '||l_item_key, 1, 'Y');
939: END IF;
940:
941: l_quote_id := wf_engine.GetItemAttrText (
942: itemtype => g_ItemType,

Line 946: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

942: itemtype => g_ItemType,
943: itemkey => l_item_key,
944: aname => 'QUOTEID'
945: );
946: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
947: aso_debug_pub.add('GenerateQuoteDetail - l_quote_id - '||l_quote_id, 1, 'Y');
948: END IF;
949:
950: l_event_type := wf_engine.GetItemAttrText (

Line 947: aso_debug_pub.add('GenerateQuoteDetail - l_quote_id - '||l_quote_id, 1, 'Y');

943: itemkey => l_item_key,
944: aname => 'QUOTEID'
945: );
946: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
947: aso_debug_pub.add('GenerateQuoteDetail - l_quote_id - '||l_quote_id, 1, 'Y');
948: END IF;
949:
950: l_event_type := wf_engine.GetItemAttrText (
951: itemtype => g_ItemType,

Line 955: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

951: itemtype => g_ItemType,
952: itemkey => l_item_key,
953: aname => 'EVENTTYPE'
954: );
955: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
956: aso_debug_pub.add('GenerateQuoteDetail - l_event_type - '|| l_event_type, 1, 'Y');
957: END IF;
958:
959:

Line 956: aso_debug_pub.add('GenerateQuoteDetail - l_event_type - '|| l_event_type, 1, 'Y');

952: itemkey => l_item_key,
953: aname => 'EVENTTYPE'
954: );
955: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
956: aso_debug_pub.add('GenerateQuoteDetail - l_event_type - '|| l_event_type, 1, 'Y');
957: END IF;
958:
959:
960: FOR qte_hd_rec In c_quote_header(l_quote_id)

Line 984: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

980: l_description := c_ship_rec.description;
981:
982: END LOOP;
983:
984: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
985: aso_debug_pub.add('GenerateQuoteDetail - l_ship_flag - '|| l_ship_flag, 1, 'Y');
986: aso_debug_pub.add('GenerateQuoteDetail - l_description - '|| l_description, 1, 'Y');
987: aso_debug_pub.add('GenerateQuoteDetail - quantity - '||l_quote_line_rec.quantity, 1, 'Y');
988: aso_debug_pub.add('GenerateQuoteDetail - price '||l_quote_line_rec.line_quote_price, 1, 'Y');

Line 985: aso_debug_pub.add('GenerateQuoteDetail - l_ship_flag - '|| l_ship_flag, 1, 'Y');

981:
982: END LOOP;
983:
984: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
985: aso_debug_pub.add('GenerateQuoteDetail - l_ship_flag - '|| l_ship_flag, 1, 'Y');
986: aso_debug_pub.add('GenerateQuoteDetail - l_description - '|| l_description, 1, 'Y');
987: aso_debug_pub.add('GenerateQuoteDetail - quantity - '||l_quote_line_rec.quantity, 1, 'Y');
988: aso_debug_pub.add('GenerateQuoteDetail - price '||l_quote_line_rec.line_quote_price, 1, 'Y');
989: END IF;

Line 986: aso_debug_pub.add('GenerateQuoteDetail - l_description - '|| l_description, 1, 'Y');

982: END LOOP;
983:
984: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
985: aso_debug_pub.add('GenerateQuoteDetail - l_ship_flag - '|| l_ship_flag, 1, 'Y');
986: aso_debug_pub.add('GenerateQuoteDetail - l_description - '|| l_description, 1, 'Y');
987: aso_debug_pub.add('GenerateQuoteDetail - quantity - '||l_quote_line_rec.quantity, 1, 'Y');
988: aso_debug_pub.add('GenerateQuoteDetail - price '||l_quote_line_rec.line_quote_price, 1, 'Y');
989: END IF;
990:

Line 987: aso_debug_pub.add('GenerateQuoteDetail - quantity - '||l_quote_line_rec.quantity, 1, 'Y');

983:
984: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
985: aso_debug_pub.add('GenerateQuoteDetail - l_ship_flag - '|| l_ship_flag, 1, 'Y');
986: aso_debug_pub.add('GenerateQuoteDetail - l_description - '|| l_description, 1, 'Y');
987: aso_debug_pub.add('GenerateQuoteDetail - quantity - '||l_quote_line_rec.quantity, 1, 'Y');
988: aso_debug_pub.add('GenerateQuoteDetail - price '||l_quote_line_rec.line_quote_price, 1, 'Y');
989: END IF;
990:
991: l_string_in := l_description;

Line 988: aso_debug_pub.add('GenerateQuoteDetail - price '||l_quote_line_rec.line_quote_price, 1, 'Y');

984: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
985: aso_debug_pub.add('GenerateQuoteDetail - l_ship_flag - '|| l_ship_flag, 1, 'Y');
986: aso_debug_pub.add('GenerateQuoteDetail - l_description - '|| l_description, 1, 'Y');
987: aso_debug_pub.add('GenerateQuoteDetail - quantity - '||l_quote_line_rec.quantity, 1, 'Y');
988: aso_debug_pub.add('GenerateQuoteDetail - price '||l_quote_line_rec.line_quote_price, 1, 'Y');
989: END IF;
990:
991: l_string_in := l_description;
992: l_string_out := '';

Line 1016: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

1012: CLOSE c_quote_detail;
1013:
1014: document := l_document;
1015: document_type := 'text/plain';
1016: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1017: aso_debug_pub.add('GenerateQuoteDetail - l_document - '||NEWLINE|| l_document, 1, 'Y');
1018: END IF;
1019:
1020: EXCEPTION

Line 1017: aso_debug_pub.add('GenerateQuoteDetail - l_document - '||NEWLINE|| l_document, 1, 'Y');

1013:
1014: document := l_document;
1015: document_type := 'text/plain';
1016: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1017: aso_debug_pub.add('GenerateQuoteDetail - l_document - '||NEWLINE|| l_document, 1, 'Y');
1018: END IF;
1019:
1020: EXCEPTION
1021: WHEN OTHERS THEN

Line 1053: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

1049: BEGIN
1050:
1051: l_item_key := document_id;
1052:
1053: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1054: aso_debug_pub.add('GenerateQuoteFooter - l_item_key - '||l_item_key, 1, 'Y');
1055: END IF;
1056:
1057: l_quote_id := wf_engine.GetItemAttrText (

Line 1054: aso_debug_pub.add('GenerateQuoteFooter - l_item_key - '||l_item_key, 1, 'Y');

1050:
1051: l_item_key := document_id;
1052:
1053: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1054: aso_debug_pub.add('GenerateQuoteFooter - l_item_key - '||l_item_key, 1, 'Y');
1055: END IF;
1056:
1057: l_quote_id := wf_engine.GetItemAttrText (
1058: itemtype => g_ItemType,

Line 1062: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

1058: itemtype => g_ItemType,
1059: itemkey => l_item_key,
1060: aname => 'QUOTEID'
1061: );
1062: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1063: aso_debug_pub.add('GenerateQuoteFooter - l_quote_id - '||l_quote_id, 1, 'Y');
1064: END IF;
1065:
1066: l_event_type := wf_engine.GetItemAttrText (

Line 1063: aso_debug_pub.add('GenerateQuoteFooter - l_quote_id - '||l_quote_id, 1, 'Y');

1059: itemkey => l_item_key,
1060: aname => 'QUOTEID'
1061: );
1062: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1063: aso_debug_pub.add('GenerateQuoteFooter - l_quote_id - '||l_quote_id, 1, 'Y');
1064: END IF;
1065:
1066: l_event_type := wf_engine.GetItemAttrText (
1067: itemtype => g_ItemType,

Line 1071: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

1067: itemtype => g_ItemType,
1068: itemkey => l_item_key,
1069: aname => 'EVENTTYPE'
1070: );
1071: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1072: aso_debug_pub.add('GenerateQuoteFooter - l_event_type - '|| l_event_type, 1, 'Y');
1073: END IF;
1074:
1075: OPEN c_quote_header(l_quote_id);

Line 1072: aso_debug_pub.add('GenerateQuoteFooter - l_event_type - '|| l_event_type, 1, 'Y');

1068: itemkey => l_item_key,
1069: aname => 'EVENTTYPE'
1070: );
1071: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1072: aso_debug_pub.add('GenerateQuoteFooter - l_event_type - '|| l_event_type, 1, 'Y');
1073: END IF;
1074:
1075: OPEN c_quote_header(l_quote_id);
1076: LOOP

Line 1087: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

1083: LOOP
1084: l_curr_sym := trim(curr_sym_rec.symbol);
1085: END LOOP;
1086:
1087: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1088: aso_debug_pub.add('GenerateQuoteFooter - shipping - '||to_char(g_quote_header_rec.total_shipping_charge), 1, 'Y');
1089: aso_debug_pub.add('GenerateQuoteFooter - tax - '||to_char(g_quote_header_rec.total_tax), 1, 'Y');
1090: aso_debug_pub.add('GenerateQuoteFooter - total quote price - '||to_char(g_quote_header_rec.total_quote_price), 1, 'Y');
1091: END IF;

Line 1088: aso_debug_pub.add('GenerateQuoteFooter - shipping - '||to_char(g_quote_header_rec.total_shipping_charge), 1, 'Y');

1084: l_curr_sym := trim(curr_sym_rec.symbol);
1085: END LOOP;
1086:
1087: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1088: aso_debug_pub.add('GenerateQuoteFooter - shipping - '||to_char(g_quote_header_rec.total_shipping_charge), 1, 'Y');
1089: aso_debug_pub.add('GenerateQuoteFooter - tax - '||to_char(g_quote_header_rec.total_tax), 1, 'Y');
1090: aso_debug_pub.add('GenerateQuoteFooter - total quote price - '||to_char(g_quote_header_rec.total_quote_price), 1, 'Y');
1091: END IF;
1092:

Line 1089: aso_debug_pub.add('GenerateQuoteFooter - tax - '||to_char(g_quote_header_rec.total_tax), 1, 'Y');

1085: END LOOP;
1086:
1087: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1088: aso_debug_pub.add('GenerateQuoteFooter - shipping - '||to_char(g_quote_header_rec.total_shipping_charge), 1, 'Y');
1089: aso_debug_pub.add('GenerateQuoteFooter - tax - '||to_char(g_quote_header_rec.total_tax), 1, 'Y');
1090: aso_debug_pub.add('GenerateQuoteFooter - total quote price - '||to_char(g_quote_header_rec.total_quote_price), 1, 'Y');
1091: END IF;
1092:
1093: IF (display_type = 'text/plain' ) THEN

Line 1090: aso_debug_pub.add('GenerateQuoteFooter - total quote price - '||to_char(g_quote_header_rec.total_quote_price), 1, 'Y');

1086:
1087: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1088: aso_debug_pub.add('GenerateQuoteFooter - shipping - '||to_char(g_quote_header_rec.total_shipping_charge), 1, 'Y');
1089: aso_debug_pub.add('GenerateQuoteFooter - tax - '||to_char(g_quote_header_rec.total_tax), 1, 'Y');
1090: aso_debug_pub.add('GenerateQuoteFooter - total quote price - '||to_char(g_quote_header_rec.total_quote_price), 1, 'Y');
1091: END IF;
1092:
1093: IF (display_type = 'text/plain' ) THEN
1094:

Line 1123: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

1119: CLOSE c_quote_header;
1120:
1121: document := l_document;
1122: document_type := 'text/plain';
1123: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1124: aso_debug_pub.add('GenerateQuoteFooter - l_document - '||NEWLINE|| l_document, 1, 'Y');
1125: END IF;
1126:
1127: EXCEPTION

Line 1124: aso_debug_pub.add('GenerateQuoteFooter - l_document - '||NEWLINE|| l_document, 1, 'Y');

1120:
1121: document := l_document;
1122: document_type := 'text/plain';
1123: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1124: aso_debug_pub.add('GenerateQuoteFooter - l_document - '||NEWLINE|| l_document, 1, 'Y');
1125: END IF;
1126:
1127: EXCEPTION
1128: When Others Then