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_DEBUG_PUB

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

306:
307: -- Standard Start of API savepoint
308: SAVEPOINT Create_Qte_Opportunity_pub;
309:
310: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
311:
312: IF aso_debug_pub.g_debug_flag = 'Y' THEN
313: aso_debug_pub.add('****** Start of Create_Qte_Opportunity API ******', 1, 'Y');
314: END IF;

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

308: SAVEPOINT Create_Qte_Opportunity_pub;
309:
310: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
311:
312: IF aso_debug_pub.g_debug_flag = 'Y' THEN
313: aso_debug_pub.add('****** Start of Create_Qte_Opportunity API ******', 1, 'Y');
314: END IF;
315:
316: -- Standard call to check for call compatibility.

Line 313: aso_debug_pub.add(' Start of Create_Qte_Opportunity API ', 1, 'Y');

309:
310: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
311:
312: IF aso_debug_pub.g_debug_flag = 'Y' THEN
313: aso_debug_pub.add('****** Start of Create_Qte_Opportunity API ******', 1, 'Y');
314: END IF;
315:
316: -- Standard call to check for call compatibility.
317: IF NOT FND_API.Compatible_API_Call(

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

328: FND_Msg_Pub.initialize;
329: END IF;
330:
331: --Procedure added by Anoop Rajan on 30/09/2005 to print login details
332: IF aso_debug_pub.g_debug_flag = 'Y' THEN
333: aso_debug_pub.add('Before call to printing login info details', 1, 'Y');
334: ASO_UTILITY_PVT.print_login_info;
335: aso_debug_pub.add('After call to printing login info details', 1, 'Y');
336: END IF;

Line 333: aso_debug_pub.add('Before call to printing login info details', 1, 'Y');

329: END IF;
330:
331: --Procedure added by Anoop Rajan on 30/09/2005 to print login details
332: IF aso_debug_pub.g_debug_flag = 'Y' THEN
333: aso_debug_pub.add('Before call to printing login info details', 1, 'Y');
334: ASO_UTILITY_PVT.print_login_info;
335: aso_debug_pub.add('After call to printing login info details', 1, 'Y');
336: END IF;
337:

Line 335: aso_debug_pub.add('After call to printing login info details', 1, 'Y');

331: --Procedure added by Anoop Rajan on 30/09/2005 to print login details
332: IF aso_debug_pub.g_debug_flag = 'Y' THEN
333: aso_debug_pub.add('Before call to printing login info details', 1, 'Y');
334: ASO_UTILITY_PVT.print_login_info;
335: aso_debug_pub.add('After call to printing login info details', 1, 'Y');
336: END IF;
337:
338: -- Change Done By Girish
339: -- Procedure added to validate the operating unit

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

347:
348: l_qte_header_rec := P_Quote_Header_Rec;
349: l_control_rec := p_control_rec;
350:
351: IF aso_debug_pub.g_debug_flag = 'Y' THEN
352: aso_debug_pub.add('Create_Qte_Opportunity - before defaulting framework', 1, 'Y');
353: aso_debug_pub.add('Create_Qte_Opportunity - populate defaulting control record from header control record',
354: 1, 'Y');
355: END IF ;

Line 352: aso_debug_pub.add('Create_Qte_Opportunity - before defaulting framework', 1, 'Y');

348: l_qte_header_rec := P_Quote_Header_Rec;
349: l_control_rec := p_control_rec;
350:
351: IF aso_debug_pub.g_debug_flag = 'Y' THEN
352: aso_debug_pub.add('Create_Qte_Opportunity - before defaulting framework', 1, 'Y');
353: aso_debug_pub.add('Create_Qte_Opportunity - populate defaulting control record from header control record',
354: 1, 'Y');
355: END IF ;
356:

Line 353: aso_debug_pub.add('Create_Qte_Opportunity - populate defaulting control record from header control record',

349: l_control_rec := p_control_rec;
350:
351: IF aso_debug_pub.g_debug_flag = 'Y' THEN
352: aso_debug_pub.add('Create_Qte_Opportunity - before defaulting framework', 1, 'Y');
353: aso_debug_pub.add('Create_Qte_Opportunity - populate defaulting control record from header control record',
354: 1, 'Y');
355: END IF ;
356:
357: --Yogeshwar(MOAC)

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

365: l_def_control_rec.Defaulting_Flag := l_control_rec.Defaulting_Flag;
366: l_def_control_rec.Application_Type_Code := l_control_rec.Application_Type_Code;
367: l_def_control_rec.Defaulting_Flow_Code := 'CREATE';
368:
369: IF aso_debug_pub.g_debug_flag = 'Y' THEN
370: aso_debug_pub.add('Defaulting_Fwk_Flag - '||l_control_rec.Defaulting_Fwk_Flag, 1, 'Y');
371: aso_debug_pub.add('Dependency_Flag - '||l_def_control_rec.Dependency_Flag, 1, 'Y');
372: aso_debug_pub.add('Defaulting_Flag - '||l_def_control_rec.Defaulting_Flag, 1, 'Y');
373: aso_debug_pub.add('Application_Type_Code - '||l_def_control_rec.Application_Type_Code, 1, 'Y');

Line 370: aso_debug_pub.add('Defaulting_Fwk_Flag - '||l_control_rec.Defaulting_Fwk_Flag, 1, 'Y');

366: l_def_control_rec.Application_Type_Code := l_control_rec.Application_Type_Code;
367: l_def_control_rec.Defaulting_Flow_Code := 'CREATE';
368:
369: IF aso_debug_pub.g_debug_flag = 'Y' THEN
370: aso_debug_pub.add('Defaulting_Fwk_Flag - '||l_control_rec.Defaulting_Fwk_Flag, 1, 'Y');
371: aso_debug_pub.add('Dependency_Flag - '||l_def_control_rec.Dependency_Flag, 1, 'Y');
372: aso_debug_pub.add('Defaulting_Flag - '||l_def_control_rec.Defaulting_Flag, 1, 'Y');
373: aso_debug_pub.add('Application_Type_Code - '||l_def_control_rec.Application_Type_Code, 1, 'Y');
374: aso_debug_pub.add('Defaulting_Flow_Code - '||l_def_control_rec.Defaulting_Flow_Code, 1, 'Y');

Line 371: aso_debug_pub.add('Dependency_Flag - '||l_def_control_rec.Dependency_Flag, 1, 'Y');

367: l_def_control_rec.Defaulting_Flow_Code := 'CREATE';
368:
369: IF aso_debug_pub.g_debug_flag = 'Y' THEN
370: aso_debug_pub.add('Defaulting_Fwk_Flag - '||l_control_rec.Defaulting_Fwk_Flag, 1, 'Y');
371: aso_debug_pub.add('Dependency_Flag - '||l_def_control_rec.Dependency_Flag, 1, 'Y');
372: aso_debug_pub.add('Defaulting_Flag - '||l_def_control_rec.Defaulting_Flag, 1, 'Y');
373: aso_debug_pub.add('Application_Type_Code - '||l_def_control_rec.Application_Type_Code, 1, 'Y');
374: aso_debug_pub.add('Defaulting_Flow_Code - '||l_def_control_rec.Defaulting_Flow_Code, 1, 'Y');
375: END IF ;

Line 372: aso_debug_pub.add('Defaulting_Flag - '||l_def_control_rec.Defaulting_Flag, 1, 'Y');

368:
369: IF aso_debug_pub.g_debug_flag = 'Y' THEN
370: aso_debug_pub.add('Defaulting_Fwk_Flag - '||l_control_rec.Defaulting_Fwk_Flag, 1, 'Y');
371: aso_debug_pub.add('Dependency_Flag - '||l_def_control_rec.Dependency_Flag, 1, 'Y');
372: aso_debug_pub.add('Defaulting_Flag - '||l_def_control_rec.Defaulting_Flag, 1, 'Y');
373: aso_debug_pub.add('Application_Type_Code - '||l_def_control_rec.Application_Type_Code, 1, 'Y');
374: aso_debug_pub.add('Defaulting_Flow_Code - '||l_def_control_rec.Defaulting_Flow_Code, 1, 'Y');
375: END IF ;
376:

Line 373: aso_debug_pub.add('Application_Type_Code - '||l_def_control_rec.Application_Type_Code, 1, 'Y');

369: IF aso_debug_pub.g_debug_flag = 'Y' THEN
370: aso_debug_pub.add('Defaulting_Fwk_Flag - '||l_control_rec.Defaulting_Fwk_Flag, 1, 'Y');
371: aso_debug_pub.add('Dependency_Flag - '||l_def_control_rec.Dependency_Flag, 1, 'Y');
372: aso_debug_pub.add('Defaulting_Flag - '||l_def_control_rec.Defaulting_Flag, 1, 'Y');
373: aso_debug_pub.add('Application_Type_Code - '||l_def_control_rec.Application_Type_Code, 1, 'Y');
374: aso_debug_pub.add('Defaulting_Flow_Code - '||l_def_control_rec.Defaulting_Flow_Code, 1, 'Y');
375: END IF ;
376:
377: IF l_def_control_rec.application_type_code = 'QUOTING HTML'

Line 374: aso_debug_pub.add('Defaulting_Flow_Code - '||l_def_control_rec.Defaulting_Flow_Code, 1, 'Y');

370: aso_debug_pub.add('Defaulting_Fwk_Flag - '||l_control_rec.Defaulting_Fwk_Flag, 1, 'Y');
371: aso_debug_pub.add('Dependency_Flag - '||l_def_control_rec.Dependency_Flag, 1, 'Y');
372: aso_debug_pub.add('Defaulting_Flag - '||l_def_control_rec.Defaulting_Flag, 1, 'Y');
373: aso_debug_pub.add('Application_Type_Code - '||l_def_control_rec.Application_Type_Code, 1, 'Y');
374: aso_debug_pub.add('Defaulting_Flow_Code - '||l_def_control_rec.Defaulting_Flow_Code, 1, 'Y');
375: END IF ;
376:
377: IF l_def_control_rec.application_type_code = 'QUOTING HTML'
378: OR l_def_control_rec.application_type_code = 'QUOTING FORM' THEN

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

380: ELSE
381: l_control_rec.Defaulting_Fwk_Flag := 'N';
382: END IF;
383:
384: IF aso_debug_pub.g_debug_flag = 'Y' THEN
385: aso_debug_pub.add('Create_Qte_Opportunity - Pick '||l_db_object_name
386: ||' based on calling application '||l_def_control_rec.application_type_code, 1, 'Y');
387: END IF ;
388:

Line 385: aso_debug_pub.add('Create_Qte_Opportunity - Pick '||l_db_object_name

381: l_control_rec.Defaulting_Fwk_Flag := 'N';
382: END IF;
383:
384: IF aso_debug_pub.g_debug_flag = 'Y' THEN
385: aso_debug_pub.add('Create_Qte_Opportunity - Pick '||l_db_object_name
386: ||' based on calling application '||l_def_control_rec.application_type_code, 1, 'Y');
387: END IF ;
388:
389: /*

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

389: /*
390: -- In create quote, it never deaults any line level records.
391: IF l_control_rec.defaulting_fwk_flag = 'Y' THEN
392:
393: IF aso_debug_pub.g_debug_flag = 'Y' THEN
394: aso_debug_pub.add('Create_Qte_Opportunity - Calling default_entity', 1, 'Y');
395: END IF ;
396:
397: ASO_DEFAULTING_INT.Default_Entity (

Line 394: aso_debug_pub.add('Create_Qte_Opportunity - Calling default_entity', 1, 'Y');

390: -- In create quote, it never deaults any line level records.
391: IF l_control_rec.defaulting_fwk_flag = 'Y' THEN
392:
393: IF aso_debug_pub.g_debug_flag = 'Y' THEN
394: aso_debug_pub.add('Create_Qte_Opportunity - Calling default_entity', 1, 'Y');
395: END IF ;
396:
397: ASO_DEFAULTING_INT.Default_Entity (
398: p_api_version => 1.0

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

458:
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;

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 471: IF aso_debug_pub.g_debug_flag = 'Y' THEN

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

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 561: IF aso_debug_pub.g_debug_flag = 'Y' THEN

557: X_RETURN_STATUS => X_RETURN_STATUS,
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;

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 605: IF aso_debug_pub.g_debug_flag = 'Y' THEN

601: l_qte_header_rec.TAX_UPDATED_DATE := P_OPP_QTE_IN_REC.TAX_UPDATED_DATE;
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');

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 666: IF aso_debug_pub.g_debug_flag = 'Y' THEN

662: close c_pay_term_acct;
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

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 675: IF aso_debug_pub.g_debug_flag = 'Y' THEN

671: l_hd_Payment_Tbl(1).operation_code := 'CREATE';
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:

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 705: IF aso_debug_pub.g_debug_flag = 'Y' THEN

701: X_RETURN_STATUS => X_RETURN_STATUS,
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:

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 745: IF aso_debug_pub.g_debug_flag = 'Y' THEN

741: X_MSG_COUNT => X_MSG_COUNT,
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:

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 757: IF aso_debug_pub.g_debug_flag = 'Y' THEN

753: l_hd_Shipment_Rec.ship_to_party_site_id := FND_API.G_MISS_NUM;
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

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 778: IF aso_debug_pub.g_debug_flag = 'Y' THEN

774: l_hd_price_attributes_tbl(1).pricing_context := 'MODLIST';
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;

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 795: IF aso_debug_pub.g_debug_flag = 'Y' THEN

791: X_RETURN_STATUS => X_RETURN_STATUS,
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;

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 819: IF aso_debug_pub.g_debug_flag = 'Y' THEN

815: X_RETURN_STATUS => X_RETURN_STATUS,
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;

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 845: IF aso_debug_pub.g_debug_flag = 'Y' THEN

841: X_MSG_COUNT => X_MSG_COUNT,
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;

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 869: IF aso_debug_pub.g_debug_flag = 'Y' THEN

865: l_related_obj_rec.OBJECT_ID := P_OPP_QTE_IN_REC.OPPORTUNITY_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');

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 926: IF aso_debug_pub.g_debug_flag = 'Y' THEN

922: X_Msg_Count => x_msg_count,
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

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 939: IF aso_debug_pub.g_debug_flag = 'Y' THEN

935:
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);

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 946: IF aso_debug_pub.g_debug_flag = 'Y' THEN

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;
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;

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 975: IF aso_debug_pub.g_debug_flag = 'Y' THEN

971: l_qte_line_tbl(l_line_count).quantity := l_lead_line_rec.quantity;
972: l_qte_line_tbl(l_line_count).uom_code := l_lead_line_rec.uom_code;
973:
974: -- Recurring charges Change
975: IF aso_debug_pub.g_debug_flag = 'Y' THEN
976: aso_debug_pub.add('lx_qte_header_rec.org_id: ' || lx_qte_header_rec.org_id);
977: END IF;
978:
979: l_master_organization_id := oe_sys_parameters.value(param_name => 'MASTER_ORGANIZATION_ID',

Line 976: aso_debug_pub.add('lx_qte_header_rec.org_id: ' || lx_qte_header_rec.org_id);

972: l_qte_line_tbl(l_line_count).uom_code := l_lead_line_rec.uom_code;
973:
974: -- Recurring charges Change
975: IF aso_debug_pub.g_debug_flag = 'Y' THEN
976: aso_debug_pub.add('lx_qte_header_rec.org_id: ' || lx_qte_header_rec.org_id);
977: END IF;
978:
979: l_master_organization_id := oe_sys_parameters.value(param_name => 'MASTER_ORGANIZATION_ID',
980: p_org_id => lx_qte_header_rec.org_id);

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

978:
979: l_master_organization_id := oe_sys_parameters.value(param_name => 'MASTER_ORGANIZATION_ID',
980: p_org_id => lx_qte_header_rec.org_id);
981:
982: IF aso_debug_pub.g_debug_flag = 'Y' THEN
983: aso_debug_pub.add('l_master_organization_id: ' || l_master_organization_id);
984: END IF;
985:
986: OPEN c_periodicity(l_lead_line_rec.inventory_item_id, l_master_organization_id);

Line 983: aso_debug_pub.add('l_master_organization_id: ' || l_master_organization_id);

979: l_master_organization_id := oe_sys_parameters.value(param_name => 'MASTER_ORGANIZATION_ID',
980: p_org_id => lx_qte_header_rec.org_id);
981:
982: IF aso_debug_pub.g_debug_flag = 'Y' THEN
983: aso_debug_pub.add('l_master_organization_id: ' || l_master_organization_id);
984: END IF;
985:
986: OPEN c_periodicity(l_lead_line_rec.inventory_item_id, l_master_organization_id);
987: FETCH c_periodicity INTO l_charge_periodicity_code;

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

988:
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;

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 999: IF aso_debug_pub.g_debug_flag = 'Y' THEN

995: END IF;
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');

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 1061: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1057:
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(

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 1085: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1081: x_msg_count => x_msg_count,
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

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 1109: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1105: IF lpx_qte_line_tbl(i).pricing_status_code <> FND_API.G_RET_STS_SUCCESS THEN
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:

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 1205: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1201: END IF;
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');

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 1252: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1248: l_qte_access_tbl(l_qte_access_tbl.count+1) := l_qte_access_rec;
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:

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 1263: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1259:
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:

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 1333: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1329: lx_qte_header_rec := lx_out_qte_header_rec;
1330: --existing code -- Not sure if this is necessary
1331: l_qte_access_tbl := lx_qte_access_tbl;
1332:
1333: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1334: aso_debug_pub.add('update_quote:X_Return_Status:'||X_Return_Status,1,'N');
1335: aso_debug_pub.add('update_quote:X_Msg_Count:'||X_Msg_Count,1,'N');
1336: END IF;
1337:

Line 1334: aso_debug_pub.add('update_quote:X_Return_Status:'||X_Return_Status,1,'N');

1330: --existing code -- Not sure if this is necessary
1331: l_qte_access_tbl := lx_qte_access_tbl;
1332:
1333: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1334: aso_debug_pub.add('update_quote:X_Return_Status:'||X_Return_Status,1,'N');
1335: aso_debug_pub.add('update_quote:X_Msg_Count:'||X_Msg_Count,1,'N');
1336: END IF;
1337:
1338: IF x_return_status = FND_API.G_RET_STS_ERROR then

Line 1335: aso_debug_pub.add('update_quote:X_Msg_Count:'||X_Msg_Count,1,'N');

1331: l_qte_access_tbl := lx_qte_access_tbl;
1332:
1333: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1334: aso_debug_pub.add('update_quote:X_Return_Status:'||X_Return_Status,1,'N');
1335: aso_debug_pub.add('update_quote:X_Msg_Count:'||X_Msg_Count,1,'N');
1336: END IF;
1337:
1338: IF x_return_status = FND_API.G_RET_STS_ERROR then
1339: raise FND_API.G_EXC_ERROR;

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

1345: -- security changes
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:

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 1355: IF aso_debug_pub.g_debug_flag = 'Y' THEN

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
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:

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 1420: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1416: x_copy_task_flag => l_copy_task_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:'

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 1505: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1501: X_OPP_QTE_OUT_REC.currency_code := lx_qte_header_rec.currency_code;
1502:
1503: -- End of API body.
1504:
1505: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1506: aso_debug_pub.add('****** End of Create_Qte_Opportunity API ******', 1, 'Y');
1507: END IF;
1508:
1509: -- Standard check of p_commit.

Line 1506: aso_debug_pub.add(' End of Create_Qte_Opportunity API ', 1, 'Y');

1502:
1503: -- End of API body.
1504:
1505: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1506: aso_debug_pub.add('****** End of Create_Qte_Opportunity API ******', 1, 'Y');
1507: END IF;
1508:
1509: -- Standard check of p_commit.
1510: IF FND_API.To_Boolean(p_commit) THEN

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

1609: l_master_organization_id NUMBER;
1610: l_segment1 VARCHAR2(240);
1611: BEGIN
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');

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

1611: BEGIN
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');

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 1632: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1628: -- bug 4932359
1629: l_master_organization_id := oe_sys_parameters.value(param_name => 'MASTER_ORGANIZATION_ID',
1630: p_org_id => p_qte_header_rec.org_id);
1631:
1632: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1633: aso_debug_pub.add('l_master_organization_id: ' || l_master_organization_id);
1634: aso_debug_pub.add(' p_qte_header_rec.org_id: ' || p_qte_header_rec.org_id);
1635: END IF;
1636:

Line 1633: aso_debug_pub.add('l_master_organization_id: ' || l_master_organization_id);

1629: l_master_organization_id := oe_sys_parameters.value(param_name => 'MASTER_ORGANIZATION_ID',
1630: p_org_id => p_qte_header_rec.org_id);
1631:
1632: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1633: aso_debug_pub.add('l_master_organization_id: ' || l_master_organization_id);
1634: aso_debug_pub.add(' p_qte_header_rec.org_id: ' || p_qte_header_rec.org_id);
1635: END IF;
1636:
1637: open c_in_org_in_master_org(p_inventory_item_id,l_master_organization_id);

Line 1634: aso_debug_pub.add(' p_qte_header_rec.org_id: ' || p_qte_header_rec.org_id);

1630: p_org_id => p_qte_header_rec.org_id);
1631:
1632: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1633: aso_debug_pub.add('l_master_organization_id: ' || l_master_organization_id);
1634: aso_debug_pub.add(' p_qte_header_rec.org_id: ' || p_qte_header_rec.org_id);
1635: END IF;
1636:
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;

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

1636:
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);

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 1666: IF aso_debug_pub.g_debug_flag = 'Y' THEN

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

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 1692: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1688: FND_PROFILE.Value('RESP_APPL_ID')
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:

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 1713: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1709: l_output_qty,
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');

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 1722: IF aso_debug_pub.g_debug_flag = 'Y' THEN

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
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:

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 1736: IF aso_debug_pub.g_debug_flag = 'Y' THEN

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

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 1747: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1743: RETURN FALSE;
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:

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 1786: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');

1782: AND entity_name = 'AS_OPPORTUNITY_ATTCH';
1783:
1784: BEGIN
1785:
1786: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
1787:
1788: x_copy_notes_flag := 'N';
1789: x_copy_task_flag := 'N';
1790: x_copy_att_flag := 'N';

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

1835: OPEN c_location(p_party_site_id);
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);

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 1846: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1842:
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

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 1863: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1859: X_MSG_DATA => X_MSG_DATA,
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:

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';