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_OPP_QTE_PUB dependencies on ASO_OPP_QTE_PUB

Line 1: PACKAGE BODY ASO_OPP_QTE_PUB AS

1: PACKAGE BODY ASO_OPP_QTE_PUB AS
2: /* $Header: asopopqb.pls 120.16.12000000.3 2007/07/09 16:47:52 ajosephg ship $ */
3:
4: -- Start of Comments
5: -- Package name : ASO_OPP_QTE_PUB

Line 5: -- Package name : ASO_OPP_QTE_PUB

1: PACKAGE BODY ASO_OPP_QTE_PUB AS
2: /* $Header: asopopqb.pls 120.16.12000000.3 2007/07/09 16:47:52 ajosephg ship $ */
3:
4: -- Start of Comments
5: -- Package name : ASO_OPP_QTE_PUB
6: -- Purpose : API to create quote from opportunity
7: -- End of Comments
8:
9:

Line 10: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ASO_OPP_QTE_PUB';

6: -- Purpose : API to create quote from opportunity
7: -- End of Comments
8:
9:
10: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ASO_OPP_QTE_PUB';
11: G_FILE_NAME CONSTANT VARCHAR2(12) := 'asopopqb.pls';
12:
13:
14: PROCEDURE Create_Qte_Opportunity(

Line 463: aso_debug_pub.add('ASO_OPP_QTE_PUB: Assigning the header tax record',1,'N');

459: IF aso_utility_pvt.tax_rec_exists(P_header_tax_detail_rec) then
460: l_hd_tax_detail_tbl(1) := P_header_tax_detail_rec;
461:
462: IF aso_debug_pub.g_debug_flag = 'Y' THEN
463: aso_debug_pub.add('ASO_OPP_QTE_PUB: Assigning the header tax record',1,'N');
464: aso_debug_pub.add('ASO_OPP_QTE_PUB: Header tax_exempt_flag: '||P_header_tax_detail_rec.tax_exempt_flag,1,'N');
465: END IF ;
466: end if;
467:

Line 464: aso_debug_pub.add('ASO_OPP_QTE_PUB: Header tax_exempt_flag: '||P_header_tax_detail_rec.tax_exempt_flag,1,'N');

460: l_hd_tax_detail_tbl(1) := P_header_tax_detail_rec;
461:
462: IF aso_debug_pub.g_debug_flag = 'Y' THEN
463: aso_debug_pub.add('ASO_OPP_QTE_PUB: Assigning the header tax record',1,'N');
464: aso_debug_pub.add('ASO_OPP_QTE_PUB: Header tax_exempt_flag: '||P_header_tax_detail_rec.tax_exempt_flag,1,'N');
465: END IF ;
466: end if;
467:
468: -- API body

Line 472: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_OPP_QTE_IN_REC.OPPORTUNITY_ID:'

468: -- API body
469: FOR l_lead_rec IN c_lead(P_OPP_QTE_IN_REC.OPPORTUNITY_ID) LOOP
470:
471: IF aso_debug_pub.g_debug_flag = 'Y' THEN
472: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_OPP_QTE_IN_REC.OPPORTUNITY_ID:'
473: ||P_OPP_QTE_IN_REC.OPPORTUNITY_ID, 1, 'N');
474: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_OPP_QTE_IN_REC.QUOTE_NUMBER:'
475: ||P_OPP_QTE_IN_REC.QUOTE_NUMBER, 1, 'N');
476: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_OPP_QTE_IN_REC.QUOTE_NAME:'

Line 474: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_OPP_QTE_IN_REC.QUOTE_NUMBER:'

470:
471: IF aso_debug_pub.g_debug_flag = 'Y' THEN
472: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_OPP_QTE_IN_REC.OPPORTUNITY_ID:'
473: ||P_OPP_QTE_IN_REC.OPPORTUNITY_ID, 1, 'N');
474: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_OPP_QTE_IN_REC.QUOTE_NUMBER:'
475: ||P_OPP_QTE_IN_REC.QUOTE_NUMBER, 1, 'N');
476: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_OPP_QTE_IN_REC.QUOTE_NAME:'
477: ||P_OPP_QTE_IN_REC.QUOTE_NAME, 1, 'N');
478: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_OPP_QTE_IN_REC.CUST_ACCOUNT_ID:'

Line 476: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_OPP_QTE_IN_REC.QUOTE_NAME:'

472: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_OPP_QTE_IN_REC.OPPORTUNITY_ID:'
473: ||P_OPP_QTE_IN_REC.OPPORTUNITY_ID, 1, 'N');
474: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_OPP_QTE_IN_REC.QUOTE_NUMBER:'
475: ||P_OPP_QTE_IN_REC.QUOTE_NUMBER, 1, 'N');
476: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_OPP_QTE_IN_REC.QUOTE_NAME:'
477: ||P_OPP_QTE_IN_REC.QUOTE_NAME, 1, 'N');
478: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_OPP_QTE_IN_REC.CUST_ACCOUNT_ID:'
479: ||P_OPP_QTE_IN_REC.CUST_ACCOUNT_ID, 1, 'N');
480: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_OPP_QTE_IN_REC.RESOURCE_ID:'

Line 478: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_OPP_QTE_IN_REC.CUST_ACCOUNT_ID:'

474: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_OPP_QTE_IN_REC.QUOTE_NUMBER:'
475: ||P_OPP_QTE_IN_REC.QUOTE_NUMBER, 1, 'N');
476: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_OPP_QTE_IN_REC.QUOTE_NAME:'
477: ||P_OPP_QTE_IN_REC.QUOTE_NAME, 1, 'N');
478: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_OPP_QTE_IN_REC.CUST_ACCOUNT_ID:'
479: ||P_OPP_QTE_IN_REC.CUST_ACCOUNT_ID, 1, 'N');
480: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_OPP_QTE_IN_REC.RESOURCE_ID:'
481: ||P_OPP_QTE_IN_REC.RESOURCE_ID, 1, 'N');
482: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_OPP_QTE_IN_REC.SOLD_TO_CONTACT_ID:'

Line 480: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_OPP_QTE_IN_REC.RESOURCE_ID:'

476: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_OPP_QTE_IN_REC.QUOTE_NAME:'
477: ||P_OPP_QTE_IN_REC.QUOTE_NAME, 1, 'N');
478: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_OPP_QTE_IN_REC.CUST_ACCOUNT_ID:'
479: ||P_OPP_QTE_IN_REC.CUST_ACCOUNT_ID, 1, 'N');
480: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_OPP_QTE_IN_REC.RESOURCE_ID:'
481: ||P_OPP_QTE_IN_REC.RESOURCE_ID, 1, 'N');
482: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_OPP_QTE_IN_REC.SOLD_TO_CONTACT_ID:'
483: ||P_OPP_QTE_IN_REC.SOLD_TO_CONTACT_ID, 1, 'N');
484: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_OPP_QTE_IN_REC.SOLD_TO_PARTY_SITE_ID:'

Line 482: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_OPP_QTE_IN_REC.SOLD_TO_CONTACT_ID:'

478: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_OPP_QTE_IN_REC.CUST_ACCOUNT_ID:'
479: ||P_OPP_QTE_IN_REC.CUST_ACCOUNT_ID, 1, 'N');
480: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_OPP_QTE_IN_REC.RESOURCE_ID:'
481: ||P_OPP_QTE_IN_REC.RESOURCE_ID, 1, 'N');
482: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_OPP_QTE_IN_REC.SOLD_TO_CONTACT_ID:'
483: ||P_OPP_QTE_IN_REC.SOLD_TO_CONTACT_ID, 1, 'N');
484: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_OPP_QTE_IN_REC.SOLD_TO_PARTY_SITE_ID:'
485: ||P_OPP_QTE_IN_REC.SOLD_TO_PARTY_SITE_ID, 1, 'N');
486: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_OPP_QTE_IN_REC.PRICE_LIST_ID:'

Line 484: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_OPP_QTE_IN_REC.SOLD_TO_PARTY_SITE_ID:'

480: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_OPP_QTE_IN_REC.RESOURCE_ID:'
481: ||P_OPP_QTE_IN_REC.RESOURCE_ID, 1, 'N');
482: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_OPP_QTE_IN_REC.SOLD_TO_CONTACT_ID:'
483: ||P_OPP_QTE_IN_REC.SOLD_TO_CONTACT_ID, 1, 'N');
484: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_OPP_QTE_IN_REC.SOLD_TO_PARTY_SITE_ID:'
485: ||P_OPP_QTE_IN_REC.SOLD_TO_PARTY_SITE_ID, 1, 'N');
486: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_OPP_QTE_IN_REC.PRICE_LIST_ID:'
487: ||P_OPP_QTE_IN_REC.PRICE_LIST_ID, 1, 'N');
488: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_OPP_QTE_IN_REC.RESOURCE_GRP_ID:'

Line 486: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_OPP_QTE_IN_REC.PRICE_LIST_ID:'

482: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_OPP_QTE_IN_REC.SOLD_TO_CONTACT_ID:'
483: ||P_OPP_QTE_IN_REC.SOLD_TO_CONTACT_ID, 1, 'N');
484: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_OPP_QTE_IN_REC.SOLD_TO_PARTY_SITE_ID:'
485: ||P_OPP_QTE_IN_REC.SOLD_TO_PARTY_SITE_ID, 1, 'N');
486: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_OPP_QTE_IN_REC.PRICE_LIST_ID:'
487: ||P_OPP_QTE_IN_REC.PRICE_LIST_ID, 1, 'N');
488: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_OPP_QTE_IN_REC.RESOURCE_GRP_ID:'
489: ||P_OPP_QTE_IN_REC.RESOURCE_GRP_ID, 1, 'N');
490: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_OPP_QTE_IN_REC.CHANNEL_CODE:'

Line 488: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_OPP_QTE_IN_REC.RESOURCE_GRP_ID:'

484: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_OPP_QTE_IN_REC.SOLD_TO_PARTY_SITE_ID:'
485: ||P_OPP_QTE_IN_REC.SOLD_TO_PARTY_SITE_ID, 1, 'N');
486: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_OPP_QTE_IN_REC.PRICE_LIST_ID:'
487: ||P_OPP_QTE_IN_REC.PRICE_LIST_ID, 1, 'N');
488: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_OPP_QTE_IN_REC.RESOURCE_GRP_ID:'
489: ||P_OPP_QTE_IN_REC.RESOURCE_GRP_ID, 1, 'N');
490: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_OPP_QTE_IN_REC.CHANNEL_CODE:'
491: ||P_OPP_QTE_IN_REC.CHANNEL_CODE, 1, 'N');
492: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_OPP_QTE_IN_REC.ORDER_TYPE_ID:'

Line 490: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_OPP_QTE_IN_REC.CHANNEL_CODE:'

486: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_OPP_QTE_IN_REC.PRICE_LIST_ID:'
487: ||P_OPP_QTE_IN_REC.PRICE_LIST_ID, 1, 'N');
488: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_OPP_QTE_IN_REC.RESOURCE_GRP_ID:'
489: ||P_OPP_QTE_IN_REC.RESOURCE_GRP_ID, 1, 'N');
490: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_OPP_QTE_IN_REC.CHANNEL_CODE:'
491: ||P_OPP_QTE_IN_REC.CHANNEL_CODE, 1, 'N');
492: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_OPP_QTE_IN_REC.ORDER_TYPE_ID:'
493: ||P_OPP_QTE_IN_REC.ORDER_TYPE_ID, 1, 'N');
494: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_OPP_QTE_IN_REC.AGREEMENT_ID:'

Line 492: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_OPP_QTE_IN_REC.ORDER_TYPE_ID:'

488: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_OPP_QTE_IN_REC.RESOURCE_GRP_ID:'
489: ||P_OPP_QTE_IN_REC.RESOURCE_GRP_ID, 1, 'N');
490: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_OPP_QTE_IN_REC.CHANNEL_CODE:'
491: ||P_OPP_QTE_IN_REC.CHANNEL_CODE, 1, 'N');
492: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_OPP_QTE_IN_REC.ORDER_TYPE_ID:'
493: ||P_OPP_QTE_IN_REC.ORDER_TYPE_ID, 1, 'N');
494: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_OPP_QTE_IN_REC.AGREEMENT_ID:'
495: ||P_OPP_QTE_IN_REC.AGREEMENT_ID, 1, 'N');
496: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_OPP_QTE_IN_REC.CONTRACT_TEMPLATE_ID:'

Line 494: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_OPP_QTE_IN_REC.AGREEMENT_ID:'

490: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_OPP_QTE_IN_REC.CHANNEL_CODE:'
491: ||P_OPP_QTE_IN_REC.CHANNEL_CODE, 1, 'N');
492: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_OPP_QTE_IN_REC.ORDER_TYPE_ID:'
493: ||P_OPP_QTE_IN_REC.ORDER_TYPE_ID, 1, 'N');
494: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_OPP_QTE_IN_REC.AGREEMENT_ID:'
495: ||P_OPP_QTE_IN_REC.AGREEMENT_ID, 1, 'N');
496: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_OPP_QTE_IN_REC.CONTRACT_TEMPLATE_ID:'
497: ||P_OPP_QTE_IN_REC.CONTRACT_TEMPLATE_ID, 1, 'N');
498: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_OPP_QTE_IN_REC.CONTRACT_TEMPLATE_MAJOR_VER:'

Line 496: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_OPP_QTE_IN_REC.CONTRACT_TEMPLATE_ID:'

492: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_OPP_QTE_IN_REC.ORDER_TYPE_ID:'
493: ||P_OPP_QTE_IN_REC.ORDER_TYPE_ID, 1, 'N');
494: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_OPP_QTE_IN_REC.AGREEMENT_ID:'
495: ||P_OPP_QTE_IN_REC.AGREEMENT_ID, 1, 'N');
496: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_OPP_QTE_IN_REC.CONTRACT_TEMPLATE_ID:'
497: ||P_OPP_QTE_IN_REC.CONTRACT_TEMPLATE_ID, 1, 'N');
498: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_OPP_QTE_IN_REC.CONTRACT_TEMPLATE_MAJOR_VER:'
499: ||P_OPP_QTE_IN_REC.CONTRACT_TEMPLATE_MAJOR_VER, 1, 'N');
500: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_OPP_QTE_IN_REC.CURRENCY_CODE:'

Line 498: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_OPP_QTE_IN_REC.CONTRACT_TEMPLATE_MAJOR_VER:'

494: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_OPP_QTE_IN_REC.AGREEMENT_ID:'
495: ||P_OPP_QTE_IN_REC.AGREEMENT_ID, 1, 'N');
496: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_OPP_QTE_IN_REC.CONTRACT_TEMPLATE_ID:'
497: ||P_OPP_QTE_IN_REC.CONTRACT_TEMPLATE_ID, 1, 'N');
498: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_OPP_QTE_IN_REC.CONTRACT_TEMPLATE_MAJOR_VER:'
499: ||P_OPP_QTE_IN_REC.CONTRACT_TEMPLATE_MAJOR_VER, 1, 'N');
500: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_OPP_QTE_IN_REC.CURRENCY_CODE:'
501: ||P_OPP_QTE_IN_REC.CURRENCY_CODE, 1, 'N');
502: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_OPP_QTE_IN_REC.MARKETING_SOURCE_CODE_ID:'

Line 500: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_OPP_QTE_IN_REC.CURRENCY_CODE:'

496: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_OPP_QTE_IN_REC.CONTRACT_TEMPLATE_ID:'
497: ||P_OPP_QTE_IN_REC.CONTRACT_TEMPLATE_ID, 1, 'N');
498: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_OPP_QTE_IN_REC.CONTRACT_TEMPLATE_MAJOR_VER:'
499: ||P_OPP_QTE_IN_REC.CONTRACT_TEMPLATE_MAJOR_VER, 1, 'N');
500: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_OPP_QTE_IN_REC.CURRENCY_CODE:'
501: ||P_OPP_QTE_IN_REC.CURRENCY_CODE, 1, 'N');
502: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_OPP_QTE_IN_REC.MARKETING_SOURCE_CODE_ID:'
503: ||P_OPP_QTE_IN_REC.MARKETING_SOURCE_CODE_ID, 1, 'N');
504: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_lead_rec.offer_id:'||l_lead_rec.offer_id, 1, 'N');

Line 502: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_OPP_QTE_IN_REC.MARKETING_SOURCE_CODE_ID:'

498: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_OPP_QTE_IN_REC.CONTRACT_TEMPLATE_MAJOR_VER:'
499: ||P_OPP_QTE_IN_REC.CONTRACT_TEMPLATE_MAJOR_VER, 1, 'N');
500: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_OPP_QTE_IN_REC.CURRENCY_CODE:'
501: ||P_OPP_QTE_IN_REC.CURRENCY_CODE, 1, 'N');
502: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_OPP_QTE_IN_REC.MARKETING_SOURCE_CODE_ID:'
503: ||P_OPP_QTE_IN_REC.MARKETING_SOURCE_CODE_ID, 1, 'N');
504: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_lead_rec.offer_id:'||l_lead_rec.offer_id, 1, 'N');
505: END IF;
506:

Line 504: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_lead_rec.offer_id:'||l_lead_rec.offer_id, 1, 'N');

500: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_OPP_QTE_IN_REC.CURRENCY_CODE:'
501: ||P_OPP_QTE_IN_REC.CURRENCY_CODE, 1, 'N');
502: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_OPP_QTE_IN_REC.MARKETING_SOURCE_CODE_ID:'
503: ||P_OPP_QTE_IN_REC.MARKETING_SOURCE_CODE_ID, 1, 'N');
504: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_lead_rec.offer_id:'||l_lead_rec.offer_id, 1, 'N');
505: END IF;
506:
507:
508: -- Set Control Record

Line 562: aso_debug_pub.add('ASO_OPP_QTE_PUB: sold_to_party_site_id:'

558: X_MSG_COUNT => X_MSG_COUNT,
559: X_MSG_DATA => X_MSG_DATA) ;
560:
561: IF aso_debug_pub.g_debug_flag = 'Y' THEN
562: aso_debug_pub.add('ASO_OPP_QTE_PUB: sold_to_party_site_id:'
563: ||P_OPP_QTE_IN_REC.sold_to_party_site_id, 1, 'N');
564: aso_debug_pub.add('ASO_OPP_QTE_PUB: valid flag:Sold_To:'||x_valid, 1, 'N');
565: END IF;
566:

Line 564: aso_debug_pub.add('ASO_OPP_QTE_PUB: valid flag:Sold_To:'||x_valid, 1, 'N');

560:
561: IF aso_debug_pub.g_debug_flag = 'Y' THEN
562: aso_debug_pub.add('ASO_OPP_QTE_PUB: sold_to_party_site_id:'
563: ||P_OPP_QTE_IN_REC.sold_to_party_site_id, 1, 'N');
564: aso_debug_pub.add('ASO_OPP_QTE_PUB: valid flag:Sold_To:'||x_valid, 1, 'N');
565: END IF;
566:
567:
568: IF x_valid = 'Y' THEN

Line 606: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_header_rec.quote_header_id:'

602: END IF;
603:
604:
605: IF aso_debug_pub.g_debug_flag = 'Y' THEN
606: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_header_rec.quote_header_id:'
607: || l_qte_header_rec.quote_header_id, 1, 'N');
608: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_header_rec.quote_source_code:'
609: || l_qte_header_rec.quote_source_code, 1, 'N');
610: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_header_rec.quote_number:'

Line 608: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_header_rec.quote_source_code:'

604:
605: IF aso_debug_pub.g_debug_flag = 'Y' THEN
606: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_header_rec.quote_header_id:'
607: || l_qte_header_rec.quote_header_id, 1, 'N');
608: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_header_rec.quote_source_code:'
609: || l_qte_header_rec.quote_source_code, 1, 'N');
610: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_header_rec.quote_number:'
611: || l_qte_header_rec.quote_number, 1, 'N');
612: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_header_rec.resource_id:'

Line 610: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_header_rec.quote_number:'

606: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_header_rec.quote_header_id:'
607: || l_qte_header_rec.quote_header_id, 1, 'N');
608: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_header_rec.quote_source_code:'
609: || l_qte_header_rec.quote_source_code, 1, 'N');
610: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_header_rec.quote_number:'
611: || l_qte_header_rec.quote_number, 1, 'N');
612: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_header_rec.resource_id:'
613: || l_qte_header_rec.resource_id, 1, 'N');
614: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_header_rec.price_list_id:'

Line 612: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_header_rec.resource_id:'

608: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_header_rec.quote_source_code:'
609: || l_qte_header_rec.quote_source_code, 1, 'N');
610: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_header_rec.quote_number:'
611: || l_qte_header_rec.quote_number, 1, 'N');
612: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_header_rec.resource_id:'
613: || l_qte_header_rec.resource_id, 1, 'N');
614: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_header_rec.price_list_id:'
615: || l_qte_header_rec.price_list_id, 1, 'N');
616: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_header_rec.resource_grp_id:'

Line 614: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_header_rec.price_list_id:'

610: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_header_rec.quote_number:'
611: || l_qte_header_rec.quote_number, 1, 'N');
612: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_header_rec.resource_id:'
613: || l_qte_header_rec.resource_id, 1, 'N');
614: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_header_rec.price_list_id:'
615: || l_qte_header_rec.price_list_id, 1, 'N');
616: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_header_rec.resource_grp_id:'
617: || l_qte_header_rec.resource_grp_id, 1, 'N');
618: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_header_rec.order_type_id:'

Line 616: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_header_rec.resource_grp_id:'

612: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_header_rec.resource_id:'
613: || l_qte_header_rec.resource_id, 1, 'N');
614: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_header_rec.price_list_id:'
615: || l_qte_header_rec.price_list_id, 1, 'N');
616: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_header_rec.resource_grp_id:'
617: || l_qte_header_rec.resource_grp_id, 1, 'N');
618: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_header_rec.order_type_id:'
619: || l_qte_header_rec.order_type_id, 1, 'N');
620: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_header_rec.contract_id:'

Line 618: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_header_rec.order_type_id:'

614: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_header_rec.price_list_id:'
615: || l_qte_header_rec.price_list_id, 1, 'N');
616: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_header_rec.resource_grp_id:'
617: || l_qte_header_rec.resource_grp_id, 1, 'N');
618: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_header_rec.order_type_id:'
619: || l_qte_header_rec.order_type_id, 1, 'N');
620: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_header_rec.contract_id:'
621: || l_qte_header_rec.contract_id, 1, 'N');
622: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_header_rec.contract_template_id:'

Line 620: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_header_rec.contract_id:'

616: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_header_rec.resource_grp_id:'
617: || l_qte_header_rec.resource_grp_id, 1, 'N');
618: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_header_rec.order_type_id:'
619: || l_qte_header_rec.order_type_id, 1, 'N');
620: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_header_rec.contract_id:'
621: || l_qte_header_rec.contract_id, 1, 'N');
622: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_header_rec.contract_template_id:'
623: || l_qte_header_rec.contract_template_id, 1, 'N');
624: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_header_rec.contract_template_major_ver: '

Line 622: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_header_rec.contract_template_id:'

618: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_header_rec.order_type_id:'
619: || l_qte_header_rec.order_type_id, 1, 'N');
620: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_header_rec.contract_id:'
621: || l_qte_header_rec.contract_id, 1, 'N');
622: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_header_rec.contract_template_id:'
623: || l_qte_header_rec.contract_template_id, 1, 'N');
624: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_header_rec.contract_template_major_ver: '
625: || l_qte_header_rec.contract_template_major_ver, 1, 'N');
626: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_header_rec.quote_name:'

Line 624: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_header_rec.contract_template_major_ver: '

620: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_header_rec.contract_id:'
621: || l_qte_header_rec.contract_id, 1, 'N');
622: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_header_rec.contract_template_id:'
623: || l_qte_header_rec.contract_template_id, 1, 'N');
624: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_header_rec.contract_template_major_ver: '
625: || l_qte_header_rec.contract_template_major_ver, 1, 'N');
626: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_header_rec.quote_name:'
627: || l_qte_header_rec.quote_name, 1, 'N');
628: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_header_rec.party_id:'

Line 626: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_header_rec.quote_name:'

622: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_header_rec.contract_template_id:'
623: || l_qte_header_rec.contract_template_id, 1, 'N');
624: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_header_rec.contract_template_major_ver: '
625: || l_qte_header_rec.contract_template_major_ver, 1, 'N');
626: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_header_rec.quote_name:'
627: || l_qte_header_rec.quote_name, 1, 'N');
628: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_header_rec.party_id:'
629: || l_qte_header_rec.party_id, 1, 'N');
630: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_header_rec.phone_id:'

Line 628: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_header_rec.party_id:'

624: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_header_rec.contract_template_major_ver: '
625: || l_qte_header_rec.contract_template_major_ver, 1, 'N');
626: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_header_rec.quote_name:'
627: || l_qte_header_rec.quote_name, 1, 'N');
628: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_header_rec.party_id:'
629: || l_qte_header_rec.party_id, 1, 'N');
630: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_header_rec.phone_id:'
631: || l_qte_header_rec.phone_id, 1, 'N');
632: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_header_rec.cust_account_id:'

Line 630: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_header_rec.phone_id:'

626: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_header_rec.quote_name:'
627: || l_qte_header_rec.quote_name, 1, 'N');
628: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_header_rec.party_id:'
629: || l_qte_header_rec.party_id, 1, 'N');
630: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_header_rec.phone_id:'
631: || l_qte_header_rec.phone_id, 1, 'N');
632: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_header_rec.cust_account_id:'
633: || l_qte_header_rec.cust_account_id, 1, 'N');
634: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_header_rec.sold_to_party_site_id:'

Line 632: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_header_rec.cust_account_id:'

628: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_header_rec.party_id:'
629: || l_qte_header_rec.party_id, 1, 'N');
630: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_header_rec.phone_id:'
631: || l_qte_header_rec.phone_id, 1, 'N');
632: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_header_rec.cust_account_id:'
633: || l_qte_header_rec.cust_account_id, 1, 'N');
634: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_header_rec.sold_to_party_site_id:'
635: || l_qte_header_rec.sold_to_party_site_id, 1, 'N');
636: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_header_rec.sales_channel_code:'

Line 634: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_header_rec.sold_to_party_site_id:'

630: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_header_rec.phone_id:'
631: || l_qte_header_rec.phone_id, 1, 'N');
632: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_header_rec.cust_account_id:'
633: || l_qte_header_rec.cust_account_id, 1, 'N');
634: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_header_rec.sold_to_party_site_id:'
635: || l_qte_header_rec.sold_to_party_site_id, 1, 'N');
636: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_header_rec.sales_channel_code:'
637: || l_qte_header_rec.sales_channel_code, 1, 'N');
638: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_header_rec.currency_code:'

Line 636: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_header_rec.sales_channel_code:'

632: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_header_rec.cust_account_id:'
633: || l_qte_header_rec.cust_account_id, 1, 'N');
634: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_header_rec.sold_to_party_site_id:'
635: || l_qte_header_rec.sold_to_party_site_id, 1, 'N');
636: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_header_rec.sales_channel_code:'
637: || l_qte_header_rec.sales_channel_code, 1, 'N');
638: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_header_rec.currency_code:'
639: || l_qte_header_rec.currency_code, 1, 'N');
640: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_header_rec.marketing_source_code_id:'

Line 638: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_header_rec.currency_code:'

634: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_header_rec.sold_to_party_site_id:'
635: || l_qte_header_rec.sold_to_party_site_id, 1, 'N');
636: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_header_rec.sales_channel_code:'
637: || l_qte_header_rec.sales_channel_code, 1, 'N');
638: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_header_rec.currency_code:'
639: || l_qte_header_rec.currency_code, 1, 'N');
640: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_header_rec.marketing_source_code_id:'
641: || l_qte_header_rec.marketing_source_code_id, 1, 'N');
642: END IF;

Line 640: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_header_rec.marketing_source_code_id:'

636: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_header_rec.sales_channel_code:'
637: || l_qte_header_rec.sales_channel_code, 1, 'N');
638: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_header_rec.currency_code:'
639: || l_qte_header_rec.currency_code, 1, 'N');
640: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_header_rec.marketing_source_code_id:'
641: || l_qte_header_rec.marketing_source_code_id, 1, 'N');
642: END IF;
643:
644: l_qte_header_rec.cust_party_id := P_OPP_QTE_IN_REC.cust_party_id ;

Line 667: aso_debug_pub.add('ASO_OPP_QTE_PUB: payment_term_id:'||l_payment_term_id, 1, 'N');

663: END IF;
664: close c_pay_term_aggrement;
665:
666: IF aso_debug_pub.g_debug_flag = 'Y' THEN
667: aso_debug_pub.add('ASO_OPP_QTE_PUB: payment_term_id:'||l_payment_term_id, 1, 'N');
668: END IF;
669:
670: IF l_payment_term_id <> FND_API.G_MISS_NUM and l_payment_term_id IS NOT NULL THEN
671: l_hd_Payment_Tbl(1).operation_code := 'CREATE';

Line 676: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_OPP_QTE_IN_REC.cust_party_id:'

672: l_hd_Payment_Tbl(1).payment_term_id := l_payment_term_id;
673: END IF;
674:
675: IF aso_debug_pub.g_debug_flag = 'Y' THEN
676: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_OPP_QTE_IN_REC.cust_party_id:'
677: ||P_OPP_QTE_IN_REC.cust_party_id, 1, 'N');
678: END IF;
679:
680: IF P_OPP_QTE_IN_REC.cust_party_id <> FND_API.G_MISS_NUM

Line 706: aso_debug_pub.add('ASO_OPP_QTE_PUB: invoice_to_party_site_id:'||l_party_site_id, 1, 'N');

702: X_MSG_COUNT => X_MSG_COUNT,
703: X_MSG_DATA => X_MSG_DATA) ;
704:
705: IF aso_debug_pub.g_debug_flag = 'Y' THEN
706: aso_debug_pub.add('ASO_OPP_QTE_PUB: invoice_to_party_site_id:'||l_party_site_id, 1, 'N');
707: aso_debug_pub.add('ASO_OPP_QTE_PUB: valid flag:Invoice_To:'||x_valid, 1, 'N');
708: END IF;
709:
710: IF x_valid = 'Y' THEN

Line 707: aso_debug_pub.add('ASO_OPP_QTE_PUB: valid flag:Invoice_To:'||x_valid, 1, 'N');

703: X_MSG_DATA => X_MSG_DATA) ;
704:
705: IF aso_debug_pub.g_debug_flag = 'Y' THEN
706: aso_debug_pub.add('ASO_OPP_QTE_PUB: invoice_to_party_site_id:'||l_party_site_id, 1, 'N');
707: aso_debug_pub.add('ASO_OPP_QTE_PUB: valid flag:Invoice_To:'||x_valid, 1, 'N');
708: END IF;
709:
710: IF x_valid = 'Y' THEN
711: l_qte_header_rec.invoice_to_party_site_id := l_party_site_id;

Line 746: aso_debug_pub.add('ASO_OPP_QTE_PUB: ship_to_party_site_id :'||l_party_site_id, 1, 'N');

742: X_MSG_DATA => X_MSG_DATA);
743:
744:
745: IF aso_debug_pub.g_debug_flag = 'Y' THEN
746: aso_debug_pub.add('ASO_OPP_QTE_PUB: ship_to_party_site_id :'||l_party_site_id, 1, 'N');
747: aso_debug_pub.add('ASO_OPP_QTE_PUB: valid flag:Ship_To:'||x_valid, 1, 'N');
748: END IF;
749:
750: IF x_valid = 'Y' THEN

Line 747: aso_debug_pub.add('ASO_OPP_QTE_PUB: valid flag:Ship_To:'||x_valid, 1, 'N');

743:
744:
745: IF aso_debug_pub.g_debug_flag = 'Y' THEN
746: aso_debug_pub.add('ASO_OPP_QTE_PUB: ship_to_party_site_id :'||l_party_site_id, 1, 'N');
747: aso_debug_pub.add('ASO_OPP_QTE_PUB: valid flag:Ship_To:'||x_valid, 1, 'N');
748: END IF;
749:
750: IF x_valid = 'Y' THEN
751: l_hd_Shipment_Rec.ship_to_party_site_id := l_party_site_id;

Line 758: aso_debug_pub.add('ASO_OPP_QTE_PUB: ship_to_party_site_id:'||l_party_site_id, 1, 'N');

754: end if;
755: END IF;
756:
757: IF aso_debug_pub.g_debug_flag = 'Y' THEN
758: aso_debug_pub.add('ASO_OPP_QTE_PUB: ship_to_party_site_id:'||l_party_site_id, 1, 'N');
759: END IF;
760:
761: IF P_OPP_QTE_IN_REC.CUST_ACCOUNT_ID <> FND_API.G_MISS_NUM THEN
762: l_qte_header_rec.cust_account_id := P_OPP_QTE_IN_REC.CUST_ACCOUNT_ID;

Line 779: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_hd_price_attributes_tbl(1).pricing_attribute1: '

775: l_hd_price_attributes_tbl(1).flex_title := 'QP_ATTR_DEFNS_QUALIFIER';
776: l_hd_price_attributes_tbl(1).pricing_attribute1 := l_campaign_rec.source_code_for_id;
777:
778: IF aso_debug_pub.g_debug_flag = 'Y' THEN
779: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_hd_price_attributes_tbl(1).pricing_attribute1: '
780: || l_hd_price_attributes_tbl(1).pricing_attribute1, 1, 'N');
781: END IF;
782: END LOOP;
783: END IF;

Line 796: aso_debug_pub.add('ASO_OPP_QTE_PUB: sold_to_party_site_id:'

792: X_MSG_COUNT => X_MSG_COUNT,
793: X_MSG_DATA => X_MSG_DATA);
794:
795: IF aso_debug_pub.g_debug_flag = 'Y' THEN
796: aso_debug_pub.add('ASO_OPP_QTE_PUB: sold_to_party_site_id:'
797: ||l_qte_header_rec.sold_to_party_site_id, 1, 'N');
798: aso_debug_pub.add('ASO_OPP_QTE_PUB: valid flag:Sold_To:'||x_valid, 1, 'N');
799: END IF;
800:

Line 798: aso_debug_pub.add('ASO_OPP_QTE_PUB: valid flag:Sold_To:'||x_valid, 1, 'N');

794:
795: IF aso_debug_pub.g_debug_flag = 'Y' THEN
796: aso_debug_pub.add('ASO_OPP_QTE_PUB: sold_to_party_site_id:'
797: ||l_qte_header_rec.sold_to_party_site_id, 1, 'N');
798: aso_debug_pub.add('ASO_OPP_QTE_PUB: valid flag:Sold_To:'||x_valid, 1, 'N');
799: END IF;
800:
801: IF x_valid = 'Y' THEN
802: l_qte_header_rec.sold_to_party_site_id := l_qte_header_rec.sold_to_party_site_id;

Line 820: aso_debug_pub.add('ASO_OPP_QTE_PUB: invoice_to_party_site_id:'

816: X_MSG_COUNT => X_MSG_COUNT,
817: X_MSG_DATA => X_MSG_DATA);
818:
819: IF aso_debug_pub.g_debug_flag = 'Y' THEN
820: aso_debug_pub.add('ASO_OPP_QTE_PUB: invoice_to_party_site_id:'
821: ||l_qte_header_rec.invoice_to_party_site_id, 1, 'N');
822: aso_debug_pub.add('ASO_OPP_QTE_PUB: valid flag:Invoice_To:'||x_valid, 1, 'N');
823: END IF;
824:

Line 822: aso_debug_pub.add('ASO_OPP_QTE_PUB: valid flag:Invoice_To:'||x_valid, 1, 'N');

818:
819: IF aso_debug_pub.g_debug_flag = 'Y' THEN
820: aso_debug_pub.add('ASO_OPP_QTE_PUB: invoice_to_party_site_id:'
821: ||l_qte_header_rec.invoice_to_party_site_id, 1, 'N');
822: aso_debug_pub.add('ASO_OPP_QTE_PUB: valid flag:Invoice_To:'||x_valid, 1, 'N');
823: END IF;
824:
825: IF x_valid = 'Y' THEN
826: l_qte_header_rec.invoice_to_party_site_id := l_qte_header_rec.invoice_to_party_site_id;

Line 846: aso_debug_pub.add('ASO_OPP_QTE_PUB: ship_to_party_site_id :'

842: X_MSG_DATA => X_MSG_DATA);
843:
844:
845: IF aso_debug_pub.g_debug_flag = 'Y' THEN
846: aso_debug_pub.add('ASO_OPP_QTE_PUB: ship_to_party_site_id :'
847: ||l_hd_Shipment_Rec.ship_to_party_site_id, 1, 'N');
848: aso_debug_pub.add('ASO_OPP_QTE_PUB: valid flag:Ship_To:'||x_valid, 1, 'N');
849: END IF;
850:

Line 848: aso_debug_pub.add('ASO_OPP_QTE_PUB: valid flag:Ship_To:'||x_valid, 1, 'N');

844:
845: IF aso_debug_pub.g_debug_flag = 'Y' THEN
846: aso_debug_pub.add('ASO_OPP_QTE_PUB: ship_to_party_site_id :'
847: ||l_hd_Shipment_Rec.ship_to_party_site_id, 1, 'N');
848: aso_debug_pub.add('ASO_OPP_QTE_PUB: valid flag:Ship_To:'||x_valid, 1, 'N');
849: END IF;
850:
851: IF x_valid = 'Y' THEN
852: l_hd_Shipment_Rec.ship_to_party_site_id := l_hd_Shipment_Rec.ship_to_party_site_id;

Line 870: aso_debug_pub.add('ASO_OPP_QTE_PUB: before Create_Object_Relationship: quote_header_id:'

866: l_related_obj_rec.RELATIONSHIP_TYPE_CODE := 'OPP_QUOTE';
867:
868:
869: IF aso_debug_pub.g_debug_flag = 'Y' THEN
870: aso_debug_pub.add('ASO_OPP_QTE_PUB: before Create_Object_Relationship: quote_header_id:'
871: || l_related_obj_rec.QUOTE_OBJECT_ID, 1, 'Y');
872: aso_debug_pub.add('ASO_OPP_QTE_PUB: before Create_Object_Relationship: opportunity_id:'
873: || l_related_obj_rec.OBJECT_ID, 1, 'Y');
874: END IF;

Line 872: aso_debug_pub.add('ASO_OPP_QTE_PUB: before Create_Object_Relationship: opportunity_id:'

868:
869: IF aso_debug_pub.g_debug_flag = 'Y' THEN
870: aso_debug_pub.add('ASO_OPP_QTE_PUB: before Create_Object_Relationship: quote_header_id:'
871: || l_related_obj_rec.QUOTE_OBJECT_ID, 1, 'Y');
872: aso_debug_pub.add('ASO_OPP_QTE_PUB: before Create_Object_Relationship: opportunity_id:'
873: || l_related_obj_rec.OBJECT_ID, 1, 'Y');
874: END IF;
875:
876: l_Related_Obj_Tbl(l_Related_Obj_Tbl.count+1) := l_related_obj_rec;

Line 927: aso_debug_pub.add('ASO_OPP_QTE_PUB: after Create_Quote: x_return_status: '|| x_return_status, 1, 'Y');

923: X_Msg_Data => x_msg_data
924: );
925:
926: IF aso_debug_pub.g_debug_flag = 'Y' THEN
927: aso_debug_pub.add('ASO_OPP_QTE_PUB: after Create_Quote: x_return_status: '|| x_return_status, 1, 'Y');
928: END IF;
929:
930: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
931: RAISE FND_API.G_EXC_ERROR;

Line 940: aso_debug_pub.add('ASO_OPP_QTE_PUB: NO UOM Passed from Opportunity', 1, 'N');

936: FOR l_lead_line_rec IN c_lead_line(P_OPP_QTE_IN_REC.OPPORTUNITY_ID) LOOP
937:
938: IF (l_lead_line_rec.uom_code IS NULL) OR (l_lead_line_rec.uom_code = FND_API.G_MISS_CHAR) THEN
939: IF aso_debug_pub.g_debug_flag = 'Y' THEN
940: aso_debug_pub.add('ASO_OPP_QTE_PUB: NO UOM Passed from Opportunity', 1, 'N');
941: END IF;
942:
943: OPEN c_base_valid(l_lead_line_rec.inventory_item_id,l_lead_line_rec.organization_id);
944: FETCH c_base_valid INTO l_primary_uom_code;

Line 947: aso_debug_pub.add('ASO_OPP_QTE_PUB:IF c_base_valid%NOTFOUND invitem'

943: OPEN c_base_valid(l_lead_line_rec.inventory_item_id,l_lead_line_rec.organization_id);
944: FETCH c_base_valid INTO l_primary_uom_code;
945: IF c_base_valid%NOTFOUND THEN
946: IF aso_debug_pub.g_debug_flag = 'Y' THEN
947: aso_debug_pub.add('ASO_OPP_QTE_PUB:IF c_base_valid%NOTFOUND invitem'
948: ||l_lead_line_rec.inventory_item_id, 1, 'N');
949: aso_debug_pub.add('ASO_OPP_QTE_PUB: UOM from MTL_SYSTEMS passed to pricing', 1, 'N');
950: END IF;
951:

Line 949: aso_debug_pub.add('ASO_OPP_QTE_PUB: UOM from MTL_SYSTEMS passed to pricing', 1, 'N');

945: IF c_base_valid%NOTFOUND THEN
946: IF aso_debug_pub.g_debug_flag = 'Y' THEN
947: aso_debug_pub.add('ASO_OPP_QTE_PUB:IF c_base_valid%NOTFOUND invitem'
948: ||l_lead_line_rec.inventory_item_id, 1, 'N');
949: aso_debug_pub.add('ASO_OPP_QTE_PUB: UOM from MTL_SYSTEMS passed to pricing', 1, 'N');
950: END IF;
951:
952: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');
953: FND_MESSAGE.Set_Token('COLUMN', 'UOM_CODE', FALSE);

Line 993: aso_debug_pub.add('ASO_OPP_QTE_PUB:IF c_periodicity%NOTFOUND invitem'

989: l_qte_line_tbl(l_line_count).charge_periodicity_code := l_charge_periodicity_code;
990:
991: IF c_periodicity%NOTFOUND THEN
992: IF aso_debug_pub.g_debug_flag = 'Y' THEN
993: aso_debug_pub.add('ASO_OPP_QTE_PUB:IF c_periodicity%NOTFOUND invitem'
994: ||l_lead_line_rec.inventory_item_id, 1, 'N');
995: END IF;
996: END IF;
997: close c_periodicity;

Line 1000: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_line_tbl('||l_line_count||').operation_code:'

996: END IF;
997: close c_periodicity;
998:
999: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1000: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_line_tbl('||l_line_count||').operation_code:'
1001: ||l_qte_line_tbl(l_line_count).operation_code, 1, 'N');
1002: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_line_tbl('||l_line_count||').inventory_item_id:'
1003: ||l_qte_line_tbl(l_line_count).inventory_item_id, 1, 'N');
1004: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_line_tbl('||l_line_count||').organization_id:'

Line 1002: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_line_tbl('||l_line_count||').inventory_item_id:'

998:
999: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1000: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_line_tbl('||l_line_count||').operation_code:'
1001: ||l_qte_line_tbl(l_line_count).operation_code, 1, 'N');
1002: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_line_tbl('||l_line_count||').inventory_item_id:'
1003: ||l_qte_line_tbl(l_line_count).inventory_item_id, 1, 'N');
1004: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_line_tbl('||l_line_count||').organization_id:'
1005: ||l_qte_line_tbl(l_line_count).organization_id, 1, 'N');
1006: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_line_tbl('||l_line_count||').quantity:'

Line 1004: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_line_tbl('||l_line_count||').organization_id:'

1000: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_line_tbl('||l_line_count||').operation_code:'
1001: ||l_qte_line_tbl(l_line_count).operation_code, 1, 'N');
1002: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_line_tbl('||l_line_count||').inventory_item_id:'
1003: ||l_qte_line_tbl(l_line_count).inventory_item_id, 1, 'N');
1004: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_line_tbl('||l_line_count||').organization_id:'
1005: ||l_qte_line_tbl(l_line_count).organization_id, 1, 'N');
1006: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_line_tbl('||l_line_count||').quantity:'
1007: ||l_qte_line_tbl(l_line_count).quantity, 1, 'N');
1008: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_line_tbl('||l_line_count||').uom_code:'

Line 1006: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_line_tbl('||l_line_count||').quantity:'

1002: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_line_tbl('||l_line_count||').inventory_item_id:'
1003: ||l_qte_line_tbl(l_line_count).inventory_item_id, 1, 'N');
1004: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_line_tbl('||l_line_count||').organization_id:'
1005: ||l_qte_line_tbl(l_line_count).organization_id, 1, 'N');
1006: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_line_tbl('||l_line_count||').quantity:'
1007: ||l_qte_line_tbl(l_line_count).quantity, 1, 'N');
1008: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_line_tbl('||l_line_count||').uom_code:'
1009: ||l_qte_line_tbl(l_line_count).uom_code, 1, 'N');
1010: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_line_tbl('||l_line_count||').price_list_id:'

Line 1008: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_line_tbl('||l_line_count||').uom_code:'

1004: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_line_tbl('||l_line_count||').organization_id:'
1005: ||l_qte_line_tbl(l_line_count).organization_id, 1, 'N');
1006: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_line_tbl('||l_line_count||').quantity:'
1007: ||l_qte_line_tbl(l_line_count).quantity, 1, 'N');
1008: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_line_tbl('||l_line_count||').uom_code:'
1009: ||l_qte_line_tbl(l_line_count).uom_code, 1, 'N');
1010: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_line_tbl('||l_line_count||').price_list_id:'
1011: ||l_qte_line_tbl(l_line_count).price_list_id, 1, 'N');
1012: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_line_tbl('||l_line_count||').charge_periodicity_code:'

Line 1010: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_line_tbl('||l_line_count||').price_list_id:'

1006: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_line_tbl('||l_line_count||').quantity:'
1007: ||l_qte_line_tbl(l_line_count).quantity, 1, 'N');
1008: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_line_tbl('||l_line_count||').uom_code:'
1009: ||l_qte_line_tbl(l_line_count).uom_code, 1, 'N');
1010: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_line_tbl('||l_line_count||').price_list_id:'
1011: ||l_qte_line_tbl(l_line_count).price_list_id, 1, 'N');
1012: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_line_tbl('||l_line_count||').charge_periodicity_code:'
1013: ||l_qte_line_tbl(l_line_count).charge_periodicity_code, 1, 'N');
1014: END IF;

Line 1012: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_line_tbl('||l_line_count||').charge_periodicity_code:'

1008: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_line_tbl('||l_line_count||').uom_code:'
1009: ||l_qte_line_tbl(l_line_count).uom_code, 1, 'N');
1010: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_line_tbl('||l_line_count||').price_list_id:'
1011: ||l_qte_line_tbl(l_line_count).price_list_id, 1, 'N');
1012: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_qte_line_tbl('||l_line_count||').charge_periodicity_code:'
1013: ||l_qte_line_tbl(l_line_count).charge_periodicity_code, 1, 'N');
1014: END IF;
1015:
1016:

Line 1062: aso_debug_pub.add('ASO_OPP_QTE_PUB: before Validate_Pricing_Order', 1, 'Y');

1058: l_pricing_control_rec.request_type := l_control_rec.pricing_request_type;
1059: l_pricing_control_rec.pricing_event := l_control_rec.header_pricing_event;
1060:
1061: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1062: aso_debug_pub.add('ASO_OPP_QTE_PUB: before Validate_Pricing_Order', 1, 'Y');
1063: END IF;
1064:
1065: ASO_VALIDATE_PRICING_PVT.Validate_Pricing_Order(
1066: p_api_version_number => 1.0,

Line 1086: aso_debug_pub.add('ASO_OPP_QTE_PUB: after Validate_Pricing_Order', 1, 'Y');

1082: x_msg_data => x_msg_data
1083: );
1084:
1085: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1086: aso_debug_pub.add('ASO_OPP_QTE_PUB: after Validate_Pricing_Order', 1, 'Y');
1087: END IF;
1088:
1089: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1090: RAISE FND_API.G_EXC_ERROR;

Line 1110: aso_debug_pub.add('ASO_OPP_QTE_PUB: item has pricing error: '

1106: FOR conc_segments_rec IN c_conc_segments(lpx_qte_line_tbl(i).inventory_item_id) LOOP
1107: l_conc_segments := conc_segments_rec.concatenated_segments;
1108: END LOOP;
1109: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1110: aso_debug_pub.add('ASO_OPP_QTE_PUB: item has pricing error: '
1111: || lpx_qte_line_tbl(i).pricing_status_text, 1, 'N');
1112: END IF;
1113:
1114: FND_MESSAGE.Set_Name('ASO', 'ASO_OTQ_INVALID_PRICELIST');

Line 1206: aso_debug_pub.add('ASO_OPP_QTE_PUB: value of ASO_API_ENABLE_SECURITY:'

1202:
1203: END LOOP;
1204:
1205: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1206: aso_debug_pub.add('ASO_OPP_QTE_PUB: value of ASO_API_ENABLE_SECURITY:'
1207: || FND_PROFILE.value('ASO_API_ENABLE_SECURITY'), 1, 'N');
1208: aso_debug_pub.add('ASO_OPP_QTE_PUB: before copy sales team loop: lx_qte_header_rec.resource_id:'
1209: || lx_qte_header_rec.resource_id, 1, 'Y');
1210: END IF;

Line 1208: aso_debug_pub.add('ASO_OPP_QTE_PUB: before copy sales team loop: lx_qte_header_rec.resource_id:'

1204:
1205: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1206: aso_debug_pub.add('ASO_OPP_QTE_PUB: value of ASO_API_ENABLE_SECURITY:'
1207: || FND_PROFILE.value('ASO_API_ENABLE_SECURITY'), 1, 'N');
1208: aso_debug_pub.add('ASO_OPP_QTE_PUB: before copy sales team loop: lx_qte_header_rec.resource_id:'
1209: || lx_qte_header_rec.resource_id, 1, 'Y');
1210: END IF;
1211:
1212: IF NVL(FND_PROFILE.value('ASO_API_ENABLE_SECURITY'),'N') = 'Y' THEN

Line 1253: aso_debug_pub.add('ASO_OPP_QTE_PUB: after copy sales team loop: l_qte_access_tbl.count:'

1249: END IF;
1250: END LOOP;
1251:
1252: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1253: aso_debug_pub.add('ASO_OPP_QTE_PUB: after copy sales team loop: l_qte_access_tbl.count:'
1254: || l_qte_access_tbl.count, 1, 'N');
1255: END IF;
1256:
1257: END IF; --NVL(FND_PROFILE.value('ASO_API_ENABLE_SECURITY'),'N') = 'Y'

Line 1264: aso_debug_pub.add('ASO_OPP_QTE_PUB: before Update_Quote', 1, 'Y');

1260:
1261:
1262:
1263: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1264: aso_debug_pub.add('ASO_OPP_QTE_PUB: before Update_Quote', 1, 'Y');
1265: END IF;
1266:
1267:
1268: BEGIN

Line 1350: aso_debug_pub.add('ASO_OPP_QTE_PUB: value of ASO_API_ENABLE_SECURITY:'

1346: -- copying the sales team from opportunity to quote
1347:
1348:
1349: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1350: aso_debug_pub.add('ASO_OPP_QTE_PUB: value of ASO_API_ENABLE_SECURITY:'
1351: || FND_PROFILE.value('ASO_API_ENABLE_SECURITY'), 1, 'N');
1352: END IF;
1353:
1354: IF NVL(FND_PROFILE.value('ASO_API_ENABLE_SECURITY'),'N') = 'Y' THEN

Line 1356: aso_debug_pub.add('ASO_OPP_QTE_PUB: before copy sales team loop: lx_qte_header_rec.resource_id:'

1352: END IF;
1353:
1354: IF NVL(FND_PROFILE.value('ASO_API_ENABLE_SECURITY'),'N') = 'Y' THEN
1355: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1356: aso_debug_pub.add('ASO_OPP_QTE_PUB: before copy sales team loop: lx_qte_header_rec.resource_id:'
1357: || lx_qte_header_rec.resource_id, 1, 'Y');
1358: END IF;
1359:
1360: FOR l_opp_rec IN C_opp_owner(P_OPP_QTE_IN_REC.OPPORTUNITY_ID,lx_qte_header_rec.quote_number) LOOP

Line 1421: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_CONTROL_REC.COPY_NOTES_FLAG:'

1417: x_copy_att_flag => l_copy_att_flag
1418: );
1419:
1420: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1421: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_CONTROL_REC.COPY_NOTES_FLAG:'
1422: ||P_CONTROL_REC.COPY_NOTES_FLAG, 1, 'N');
1423: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_copy_notes_flag:'||l_copy_notes_flag, 1, 'N');
1424: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_CONTROL_REC.COPY_TASK_FLAG:'
1425: ||P_CONTROL_REC.COPY_TASK_FLAG, 1, 'N');

Line 1423: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_copy_notes_flag:'||l_copy_notes_flag, 1, 'N');

1419:
1420: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1421: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_CONTROL_REC.COPY_NOTES_FLAG:'
1422: ||P_CONTROL_REC.COPY_NOTES_FLAG, 1, 'N');
1423: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_copy_notes_flag:'||l_copy_notes_flag, 1, 'N');
1424: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_CONTROL_REC.COPY_TASK_FLAG:'
1425: ||P_CONTROL_REC.COPY_TASK_FLAG, 1, 'N');
1426: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_copy_task_flag:'||l_copy_task_flag, 1, 'N');
1427: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_CONTROL_REC.COPY_ATT_FLAG:'

Line 1424: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_CONTROL_REC.COPY_TASK_FLAG:'

1420: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1421: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_CONTROL_REC.COPY_NOTES_FLAG:'
1422: ||P_CONTROL_REC.COPY_NOTES_FLAG, 1, 'N');
1423: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_copy_notes_flag:'||l_copy_notes_flag, 1, 'N');
1424: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_CONTROL_REC.COPY_TASK_FLAG:'
1425: ||P_CONTROL_REC.COPY_TASK_FLAG, 1, 'N');
1426: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_copy_task_flag:'||l_copy_task_flag, 1, 'N');
1427: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_CONTROL_REC.COPY_ATT_FLAG:'
1428: ||P_CONTROL_REC.COPY_ATT_FLAG, 1, 'N');

Line 1426: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_copy_task_flag:'||l_copy_task_flag, 1, 'N');

1422: ||P_CONTROL_REC.COPY_NOTES_FLAG, 1, 'N');
1423: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_copy_notes_flag:'||l_copy_notes_flag, 1, 'N');
1424: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_CONTROL_REC.COPY_TASK_FLAG:'
1425: ||P_CONTROL_REC.COPY_TASK_FLAG, 1, 'N');
1426: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_copy_task_flag:'||l_copy_task_flag, 1, 'N');
1427: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_CONTROL_REC.COPY_ATT_FLAG:'
1428: ||P_CONTROL_REC.COPY_ATT_FLAG, 1, 'N');
1429: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_copy_att_flag:'||l_copy_att_flag, 1, 'N');
1430: END IF;

Line 1427: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_CONTROL_REC.COPY_ATT_FLAG:'

1423: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_copy_notes_flag:'||l_copy_notes_flag, 1, 'N');
1424: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_CONTROL_REC.COPY_TASK_FLAG:'
1425: ||P_CONTROL_REC.COPY_TASK_FLAG, 1, 'N');
1426: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_copy_task_flag:'||l_copy_task_flag, 1, 'N');
1427: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_CONTROL_REC.COPY_ATT_FLAG:'
1428: ||P_CONTROL_REC.COPY_ATT_FLAG, 1, 'N');
1429: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_copy_att_flag:'||l_copy_att_flag, 1, 'N');
1430: END IF;
1431:

Line 1429: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_copy_att_flag:'||l_copy_att_flag, 1, 'N');

1425: ||P_CONTROL_REC.COPY_TASK_FLAG, 1, 'N');
1426: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_copy_task_flag:'||l_copy_task_flag, 1, 'N');
1427: aso_debug_pub.add('ASO_OPP_QTE_PUB: P_CONTROL_REC.COPY_ATT_FLAG:'
1428: ||P_CONTROL_REC.COPY_ATT_FLAG, 1, 'N');
1429: aso_debug_pub.add('ASO_OPP_QTE_PUB: l_copy_att_flag:'||l_copy_att_flag, 1, 'N');
1430: END IF;
1431:
1432: IF (p_control_rec.COPY_NOTES_FLAG = 'Y') AND (l_copy_notes_flag = 'Y') THEN
1433: ASO_NOTES_INT.Copy_Opp_Notes_To_Qte(

Line 1616: aso_debug_pub.add('ASO_OPP_QTE_PUB: Validate_Item: * Start of API body *', 1, 'Y');

1612:
1613: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
1614:
1615: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1616: aso_debug_pub.add('ASO_OPP_QTE_PUB: Validate_Item: *** Start of API body ***', 1, 'Y');
1617: aso_debug_pub.add('ASO_OPP_QTE_PUB: Validate_Item: p_inventory_item_id: '|| p_inventory_item_id, 1, 'N');
1618: aso_debug_pub.add('ASO_OPP_QTE_PUB: Validate_Item: p_organization_id: '|| p_organization_id, 1, 'N');
1619: aso_debug_pub.add('ASO_OPP_QTE_PUB: Validate_Item: p_quantity: '|| p_quantity, 1, 'N');
1620: aso_debug_pub.add('ASO_OPP_QTE_PUB: Validate_Item: p_uom_code: '|| p_uom_code, 1, 'N');

Line 1617: aso_debug_pub.add('ASO_OPP_QTE_PUB: Validate_Item: p_inventory_item_id: '|| p_inventory_item_id, 1, 'N');

1613: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
1614:
1615: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1616: aso_debug_pub.add('ASO_OPP_QTE_PUB: Validate_Item: *** Start of API body ***', 1, 'Y');
1617: aso_debug_pub.add('ASO_OPP_QTE_PUB: Validate_Item: p_inventory_item_id: '|| p_inventory_item_id, 1, 'N');
1618: aso_debug_pub.add('ASO_OPP_QTE_PUB: Validate_Item: p_organization_id: '|| p_organization_id, 1, 'N');
1619: aso_debug_pub.add('ASO_OPP_QTE_PUB: Validate_Item: p_quantity: '|| p_quantity, 1, 'N');
1620: aso_debug_pub.add('ASO_OPP_QTE_PUB: Validate_Item: p_uom_code: '|| p_uom_code, 1, 'N');
1621: END IF;

Line 1618: aso_debug_pub.add('ASO_OPP_QTE_PUB: Validate_Item: p_organization_id: '|| p_organization_id, 1, 'N');

1614:
1615: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1616: aso_debug_pub.add('ASO_OPP_QTE_PUB: Validate_Item: *** Start of API body ***', 1, 'Y');
1617: aso_debug_pub.add('ASO_OPP_QTE_PUB: Validate_Item: p_inventory_item_id: '|| p_inventory_item_id, 1, 'N');
1618: aso_debug_pub.add('ASO_OPP_QTE_PUB: Validate_Item: p_organization_id: '|| p_organization_id, 1, 'N');
1619: aso_debug_pub.add('ASO_OPP_QTE_PUB: Validate_Item: p_quantity: '|| p_quantity, 1, 'N');
1620: aso_debug_pub.add('ASO_OPP_QTE_PUB: Validate_Item: p_uom_code: '|| p_uom_code, 1, 'N');
1621: END IF;
1622:

Line 1619: aso_debug_pub.add('ASO_OPP_QTE_PUB: Validate_Item: p_quantity: '|| p_quantity, 1, 'N');

1615: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1616: aso_debug_pub.add('ASO_OPP_QTE_PUB: Validate_Item: *** Start of API body ***', 1, 'Y');
1617: aso_debug_pub.add('ASO_OPP_QTE_PUB: Validate_Item: p_inventory_item_id: '|| p_inventory_item_id, 1, 'N');
1618: aso_debug_pub.add('ASO_OPP_QTE_PUB: Validate_Item: p_organization_id: '|| p_organization_id, 1, 'N');
1619: aso_debug_pub.add('ASO_OPP_QTE_PUB: Validate_Item: p_quantity: '|| p_quantity, 1, 'N');
1620: aso_debug_pub.add('ASO_OPP_QTE_PUB: Validate_Item: p_uom_code: '|| p_uom_code, 1, 'N');
1621: END IF;
1622:
1623:

Line 1620: aso_debug_pub.add('ASO_OPP_QTE_PUB: Validate_Item: p_uom_code: '|| p_uom_code, 1, 'N');

1616: aso_debug_pub.add('ASO_OPP_QTE_PUB: Validate_Item: *** Start of API body ***', 1, 'Y');
1617: aso_debug_pub.add('ASO_OPP_QTE_PUB: Validate_Item: p_inventory_item_id: '|| p_inventory_item_id, 1, 'N');
1618: aso_debug_pub.add('ASO_OPP_QTE_PUB: Validate_Item: p_organization_id: '|| p_organization_id, 1, 'N');
1619: aso_debug_pub.add('ASO_OPP_QTE_PUB: Validate_Item: p_quantity: '|| p_quantity, 1, 'N');
1620: aso_debug_pub.add('ASO_OPP_QTE_PUB: Validate_Item: p_uom_code: '|| p_uom_code, 1, 'N');
1621: END IF;
1622:
1623:
1624: FOR conc_segments_rec IN c_conc_segments(p_inventory_item_id) LOOP

Line 1641: aso_debug_pub.add('ASO_OPP_QTE_PUB: Item does not exist in the master org',1,'N');

1637: open c_in_org_in_master_org(p_inventory_item_id,l_master_organization_id);
1638: fetch c_in_org_in_master_org into l_segment1;
1639: if c_in_org_in_master_org%NOTFOUND THEN
1640: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1641: aso_debug_pub.add('ASO_OPP_QTE_PUB: Item does not exist in the master org',1,'N');
1642: END IF;
1643: FND_MESSAGE.Set_Name('ASO', 'ASO_INV_NOT_IN_OP_UNIT');
1644: FND_MESSAGE.Set_Token('INVITEM', l_conc_segments, FALSE);
1645: FND_MESSAGE.Set_Token('OPUNIT', l_master_organization_id, FALSE);

Line 1667: aso_debug_pub.add('ASO_OPP_QTE_PUB: Validate_Item: item is of type service:'

1663: IF orderable_items_rec.service_item_flag = 'Y' THEN
1664: IF (fnd_profile.value('ASO_REQUIRE_SERVICE_REFERENCE') <> 'N')
1665: OR (fnd_profile.value('ASO_REQUIRE_SERVICE_REFERENCE') is null) THEN
1666: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1667: aso_debug_pub.add('ASO_OPP_QTE_PUB: Validate_Item: item is of type service:'
1668: || p_inventory_item_id, 1, 'N');
1669: END IF;
1670: FND_MESSAGE.Set_Name('ASO', 'ASO_OTQ_SERVICE_ITEM');
1671: FND_MESSAGE.Set_Token('INVITEM', l_conc_segments, FALSE);

Line 1693: aso_debug_pub.add('ASO_OPP_QTE_PUB: Validate_Item: item does not have a configurable ui:'

1689: );
1690:
1691: IF l_ui_def_id IS NULL THEN
1692: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1693: aso_debug_pub.add('ASO_OPP_QTE_PUB: Validate_Item: item does not have a configurable ui:'
1694: || p_inventory_item_id, 1, 'N');
1695: END IF;
1696:
1697: FND_MESSAGE.Set_Name('ASO', 'ASO_OTQ_NO_CFG_UI_FOR_ITEM');

Line 1714: aso_debug_pub.add('ASO_OPP_QTE_PUB: Validate_Item:p_quantity'|| p_quantity, 1, 'N');

1710: l_primary_qty,
1711: l_return_status
1712: );
1713: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1714: aso_debug_pub.add('ASO_OPP_QTE_PUB: Validate_Item:p_quantity'|| p_quantity, 1, 'N');
1715: aso_debug_pub.add('ASO_OPP_QTE_PUB: Validate_Item:l_return_status'|| l_return_status, 1, 'N');
1716: aso_debug_pub.add('ASO_OPP_QTE_PUB: Validate_Item:l_uom_code'|| l_uom_code, 1, 'N');
1717: aso_debug_pub.add('ASO_OPP_QTE_PUB: Validate_Item:l_output_qty'|| l_output_qty, 1, 'N');
1718: aso_debug_pub.add('ASO_OPP_QTE_PUB: Validate_Item:l_primary_qty'|| l_primary_qty, 1, 'N');

Line 1715: aso_debug_pub.add('ASO_OPP_QTE_PUB: Validate_Item:l_return_status'|| l_return_status, 1, 'N');

1711: l_return_status
1712: );
1713: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1714: aso_debug_pub.add('ASO_OPP_QTE_PUB: Validate_Item:p_quantity'|| p_quantity, 1, 'N');
1715: aso_debug_pub.add('ASO_OPP_QTE_PUB: Validate_Item:l_return_status'|| l_return_status, 1, 'N');
1716: aso_debug_pub.add('ASO_OPP_QTE_PUB: Validate_Item:l_uom_code'|| l_uom_code, 1, 'N');
1717: aso_debug_pub.add('ASO_OPP_QTE_PUB: Validate_Item:l_output_qty'|| l_output_qty, 1, 'N');
1718: aso_debug_pub.add('ASO_OPP_QTE_PUB: Validate_Item:l_primary_qty'|| l_primary_qty, 1, 'N');
1719: END IF;

Line 1716: aso_debug_pub.add('ASO_OPP_QTE_PUB: Validate_Item:l_uom_code'|| l_uom_code, 1, 'N');

1712: );
1713: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1714: aso_debug_pub.add('ASO_OPP_QTE_PUB: Validate_Item:p_quantity'|| p_quantity, 1, 'N');
1715: aso_debug_pub.add('ASO_OPP_QTE_PUB: Validate_Item:l_return_status'|| l_return_status, 1, 'N');
1716: aso_debug_pub.add('ASO_OPP_QTE_PUB: Validate_Item:l_uom_code'|| l_uom_code, 1, 'N');
1717: aso_debug_pub.add('ASO_OPP_QTE_PUB: Validate_Item:l_output_qty'|| l_output_qty, 1, 'N');
1718: aso_debug_pub.add('ASO_OPP_QTE_PUB: Validate_Item:l_primary_qty'|| l_primary_qty, 1, 'N');
1719: END IF;
1720:

Line 1717: aso_debug_pub.add('ASO_OPP_QTE_PUB: Validate_Item:l_output_qty'|| l_output_qty, 1, 'N');

1713: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1714: aso_debug_pub.add('ASO_OPP_QTE_PUB: Validate_Item:p_quantity'|| p_quantity, 1, 'N');
1715: aso_debug_pub.add('ASO_OPP_QTE_PUB: Validate_Item:l_return_status'|| l_return_status, 1, 'N');
1716: aso_debug_pub.add('ASO_OPP_QTE_PUB: Validate_Item:l_uom_code'|| l_uom_code, 1, 'N');
1717: aso_debug_pub.add('ASO_OPP_QTE_PUB: Validate_Item:l_output_qty'|| l_output_qty, 1, 'N');
1718: aso_debug_pub.add('ASO_OPP_QTE_PUB: Validate_Item:l_primary_qty'|| l_primary_qty, 1, 'N');
1719: END IF;
1720:
1721: IF l_return_status <> FND_API.G_RET_STS_SUCCESS OR p_quantity <= 0 THEN

Line 1718: aso_debug_pub.add('ASO_OPP_QTE_PUB: Validate_Item:l_primary_qty'|| l_primary_qty, 1, 'N');

1714: aso_debug_pub.add('ASO_OPP_QTE_PUB: Validate_Item:p_quantity'|| p_quantity, 1, 'N');
1715: aso_debug_pub.add('ASO_OPP_QTE_PUB: Validate_Item:l_return_status'|| l_return_status, 1, 'N');
1716: aso_debug_pub.add('ASO_OPP_QTE_PUB: Validate_Item:l_uom_code'|| l_uom_code, 1, 'N');
1717: aso_debug_pub.add('ASO_OPP_QTE_PUB: Validate_Item:l_output_qty'|| l_output_qty, 1, 'N');
1718: aso_debug_pub.add('ASO_OPP_QTE_PUB: Validate_Item:l_primary_qty'|| l_primary_qty, 1, 'N');
1719: END IF;
1720:
1721: IF l_return_status <> FND_API.G_RET_STS_SUCCESS OR p_quantity <= 0 THEN
1722: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 1723: aso_debug_pub.add('ASO_OPP_QTE_PUB: Validate_Item: item has invalid quantity:'

1719: END IF;
1720:
1721: IF l_return_status <> FND_API.G_RET_STS_SUCCESS OR p_quantity <= 0 THEN
1722: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1723: aso_debug_pub.add('ASO_OPP_QTE_PUB: Validate_Item: item has invalid quantity:'
1724: || p_inventory_item_id, 1, 'N');
1725: END IF;
1726:
1727: FND_MESSAGE.Set_Name('ASO', 'ASO_OTQ_INVALID_QTY');

Line 1737: aso_debug_pub.add('ASO_OPP_QTE_PUB: Validate_Item: item not orderable:'|| p_inventory_item_id, 1, 'N');

1733: END LOOP;
1734:
1735: IF l_orderable_flag = 'N' THEN
1736: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1737: aso_debug_pub.add('ASO_OPP_QTE_PUB: Validate_Item: item not orderable:'|| p_inventory_item_id, 1, 'N');
1738: END IF;
1739:
1740: FND_MESSAGE.Set_Name('ASO', 'ASO_OTQ_NOT_ORDERABLE');
1741: FND_MESSAGE.Set_Token('INVITEM', l_conc_segments, FALSE);

Line 1748: aso_debug_pub.add('ASO_OPP_QTE_PUB: Validate_Item: * End of API body *', 1, 'Y');

1744: END IF;
1745:
1746:
1747: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1748: aso_debug_pub.add('ASO_OPP_QTE_PUB: Validate_Item: *** End of API body ***', 1, 'Y');
1749: END IF;
1750:
1751:
1752: RETURN TRUE;

Line 1840: aso_debug_pub.add('ASO_OPP_QTE_PUB:Address_Validation:location_id'||l_location_id, 1, 'N');

1836: FETCH c_location INTO l_location_id;
1837: close c_location;
1838:
1839: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1840: aso_debug_pub.add('ASO_OPP_QTE_PUB:Address_Validation:location_id'||l_location_id, 1, 'N');
1841: END IF;
1842:
1843: OPEN c_loc_assign(l_location_id);
1844: FETCH c_loc_assign INTO l_loc_id;

Line 1847: aso_debug_pub.add('ASO_OPP_QTE_PUB:Address_Validation:loc_assignment_id:'||l_loc_id, 1, 'N');

1843: OPEN c_loc_assign(l_location_id);
1844: FETCH c_loc_assign INTO l_loc_id;
1845:
1846: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1847: aso_debug_pub.add('ASO_OPP_QTE_PUB:Address_Validation:loc_assignment_id:'||l_loc_id, 1, 'N');
1848: END IF;
1849:
1850: IF c_loc_assign%NOTFOUND THEN
1851: HZ_TAX_ASSIGNMENT_V2PUB.create_loc_assignment(

Line 1864: aso_debug_pub.add('ASO_OPP_QTE_PUB:Address_Validation:X_RETURN_STATUS:'||X_RETURN_STATUS, 1, 'N');

1860: x_loc_id => lx_loc_id
1861: );
1862:
1863: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1864: aso_debug_pub.add('ASO_OPP_QTE_PUB:Address_Validation:X_RETURN_STATUS:'||X_RETURN_STATUS, 1, 'N');
1865: aso_debug_pub.add('ASO_OPP_QTE_PUB:Address_Validation:lx_loc_id:'||lx_loc_id, 1, 'N');
1866: END IF;
1867:
1868: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 1865: aso_debug_pub.add('ASO_OPP_QTE_PUB:Address_Validation:lx_loc_id:'||lx_loc_id, 1, 'N');

1861: );
1862:
1863: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1864: aso_debug_pub.add('ASO_OPP_QTE_PUB:Address_Validation:X_RETURN_STATUS:'||X_RETURN_STATUS, 1, 'N');
1865: aso_debug_pub.add('ASO_OPP_QTE_PUB:Address_Validation:lx_loc_id:'||lx_loc_id, 1, 'N');
1866: END IF;
1867:
1868: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1869: x_valid := 'N';