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 FND_API

Line 16: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,

12:
13:
14: PROCEDURE Create_Qte_Opportunity(
15: P_API_VERSION_NUMBER IN NUMBER,
16: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
17: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
18: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
19: P_SOURCE_CODE IN VARCHAR2,
20: P_QUOTE_HEADER_REC IN ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_MISS_Qte_Header_Rec,

Line 17: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,

13:
14: PROCEDURE Create_Qte_Opportunity(
15: P_API_VERSION_NUMBER IN NUMBER,
16: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
17: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
18: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
19: P_SOURCE_CODE IN VARCHAR2,
20: P_QUOTE_HEADER_REC IN ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_MISS_Qte_Header_Rec,
21: P_HEADER_PAYMENT_REC IN ASO_QUOTE_PUB.Payment_Rec_Type := ASO_QUOTE_PUB.G_MISS_Payment_REC,

Line 18: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

14: PROCEDURE Create_Qte_Opportunity(
15: P_API_VERSION_NUMBER IN NUMBER,
16: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
17: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
18: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
19: P_SOURCE_CODE IN VARCHAR2,
20: P_QUOTE_HEADER_REC IN ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_MISS_Qte_Header_Rec,
21: P_HEADER_PAYMENT_REC IN ASO_QUOTE_PUB.Payment_Rec_Type := ASO_QUOTE_PUB.G_MISS_Payment_REC,
22: P_HEADER_SHIPMENT_REC IN ASO_QUOTE_PUB.Shipment_Rec_Type := ASO_QUOTE_PUB.G_MISS_Shipment_REC,

Line 317: IF NOT FND_API.Compatible_API_Call(

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(
318: L_API_VERSION,
319: P_API_VERSION_NUMBER,
320: L_API_NAME,
321: G_PKG_NAME

Line 323: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

319: P_API_VERSION_NUMBER,
320: L_API_NAME,
321: G_PKG_NAME
322: ) THEN
323: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
324: END IF;
325:
326: -- Initialize message list if p_init_msg_list is set to TRUE.
327: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 327: IF FND_API.To_Boolean(p_init_msg_list) THEN

323: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
324: END IF;
325:
326: -- Initialize message list if p_init_msg_list is set to TRUE.
327: IF FND_API.To_Boolean(p_init_msg_list) THEN
328: FND_Msg_Pub.initialize;
329: END IF;
330:
331: --Procedure added by Anoop Rajan on 30/09/2005 to print login details

Line 344: x_return_status := FND_API.G_RET_STS_SUCCESS;

340: ASO_VALIDATE_PVT.VALIDATE_OU(P_Quote_Header_Rec);
341:
342:
343: -- Initialize API return status to success
344: x_return_status := FND_API.G_RET_STS_SUCCESS;
345:
346: --defaulting framework begin
347:
348: l_qte_header_rec := P_Quote_Header_Rec;

Line 358: if (l_qte_header_rec.CUST_PARTY_ID IS NULL OR l_qte_header_rec.CUST_PARTY_ID = FND_API.G_MISS_NUM ) THEN

354: 1, 'Y');
355: END IF ;
356:
357: --Yogeshwar(MOAC)
358: if (l_qte_header_rec.CUST_PARTY_ID IS NULL OR l_qte_header_rec.CUST_PARTY_ID = FND_API.G_MISS_NUM ) THEN
359: l_qte_header_rec.ORG_ID := P_OPP_QTE_IN_REC.ORG_ID;
360: End if;
361: --Yogeshwar(MOAC)
362:

Line 364: l_def_control_rec.Dependency_Flag := FND_API.G_FALSE;

360: End if;
361: --Yogeshwar(MOAC)
362:
363:
364: l_def_control_rec.Dependency_Flag := FND_API.G_FALSE;
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:

Line 422: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

418: , x_msg_count => x_msg_count
419: , x_msg_data => x_msg_data
420: );
421:
422: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
423: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
424: FND_MESSAGE.Set_Name('ASO', 'ASO_API_ERROR_DEFAULTING');
425: FND_MSG_PUB.ADD;
426: END IF;

Line 428: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

424: FND_MESSAGE.Set_Name('ASO', 'ASO_API_ERROR_DEFAULTING');
425: FND_MSG_PUB.ADD;
426: END IF;
427:
428: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
429: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
430: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
431: RAISE FND_API.G_EXC_ERROR;
432: END IF;

Line 429: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

425: FND_MSG_PUB.ADD;
426: END IF;
427:
428: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
429: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
430: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
431: RAISE FND_API.G_EXC_ERROR;
432: END IF;
433: END IF;

Line 430: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

426: END IF;
427:
428: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
429: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
430: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
431: RAISE FND_API.G_EXC_ERROR;
432: END IF;
433: END IF;
434:

Line 431: RAISE FND_API.G_EXC_ERROR;

427:
428: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
429: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
430: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
431: RAISE FND_API.G_EXC_ERROR;
432: END IF;
433: END IF;
434:
435: l_qte_header_rec := lx_qte_header_rec;

Line 532: IF P_OPP_QTE_IN_REC.quote_name <> FND_API.G_MISS_CHAR THEN

528: l_qte_header_rec.contract_template_id := P_OPP_QTE_IN_REC.contract_template_id;
529: l_qte_header_rec.contract_template_major_ver := P_OPP_QTE_IN_REC.contract_template_major_ver;
530: l_qte_header_rec.QUOTE_EXPIRATION_DATE := P_OPP_QTE_IN_REC.QUOTE_EXPIRATION_DATE;
531:
532: IF P_OPP_QTE_IN_REC.quote_name <> FND_API.G_MISS_CHAR THEN
533: l_qte_header_rec.quote_name := P_OPP_QTE_IN_REC.quote_name;
534: END IF;
535:
536: IF P_OPP_QTE_IN_REC.sold_to_contact_id <> FND_API.G_MISS_NUM THEN

Line 536: IF P_OPP_QTE_IN_REC.sold_to_contact_id <> FND_API.G_MISS_NUM THEN

532: IF P_OPP_QTE_IN_REC.quote_name <> FND_API.G_MISS_CHAR THEN
533: l_qte_header_rec.quote_name := P_OPP_QTE_IN_REC.quote_name;
534: END IF;
535:
536: IF P_OPP_QTE_IN_REC.sold_to_contact_id <> FND_API.G_MISS_NUM THEN
537: l_qte_header_rec.party_id := P_OPP_QTE_IN_REC.sold_to_contact_id;
538: Else
539: l_qte_header_rec.party_id := P_OPP_QTE_IN_REC.cust_party_id;
540: END IF;

Line 546: IF l_qte_header_rec.party_id <> FND_API.G_MISS_NUM THEN

542: END IF;
543:
544: -- Phone # population
545: IF l_control_rec.defaulting_fwk_flag <> 'Y' THEN
546: IF l_qte_header_rec.party_id <> FND_API.G_MISS_NUM THEN
547: FOR l_phone_rec IN C_phone(l_qte_header_rec.party_id) LOOP
548: l_qte_header_rec.phone_id := l_phone_rec.contact_point_id;
549: END LOOP;
550: END IF;

Line 552: IF P_OPP_QTE_IN_REC.sold_to_party_site_id <> FND_API.G_MISS_NUM THEN

548: l_qte_header_rec.phone_id := l_phone_rec.contact_point_id;
549: END LOOP;
550: END IF;
551:
552: IF P_OPP_QTE_IN_REC.sold_to_party_site_id <> FND_API.G_MISS_NUM THEN
553: Address_Validation(
554: p_party_site_id => P_OPP_QTE_IN_REC.sold_to_party_site_id ,
555: p_use_type => 'SOLD_TO',
556: x_valid => x_valid,

Line 571: l_qte_header_rec.sold_to_party_site_id := FND_API.G_MISS_NUM;

567:
568: IF x_valid = 'Y' THEN
569: l_qte_header_rec.sold_to_party_site_id := P_OPP_QTE_IN_REC.sold_to_party_site_id;
570: ELSE
571: l_qte_header_rec.sold_to_party_site_id := FND_API.G_MISS_NUM;
572: END IF;
573:
574: END IF;
575:

Line 576: IF P_OPP_QTE_IN_REC.channel_code <> FND_API.G_MISS_CHAR THEN

572: END IF;
573:
574: END IF;
575:
576: IF P_OPP_QTE_IN_REC.channel_code <> FND_API.G_MISS_CHAR THEN
577: l_qte_header_rec.sales_channel_code := P_OPP_QTE_IN_REC.channel_code;
578: END IF;
579:
580: IF P_OPP_QTE_IN_REC.currency_code <> FND_API.G_MISS_CHAR THEN

Line 580: IF P_OPP_QTE_IN_REC.currency_code <> FND_API.G_MISS_CHAR THEN

576: IF P_OPP_QTE_IN_REC.channel_code <> FND_API.G_MISS_CHAR THEN
577: l_qte_header_rec.sales_channel_code := P_OPP_QTE_IN_REC.channel_code;
578: END IF;
579:
580: IF P_OPP_QTE_IN_REC.currency_code <> FND_API.G_MISS_CHAR THEN
581: l_qte_header_rec.currency_code := P_OPP_QTE_IN_REC.currency_code;
582: END IF;
583:
584: IF P_OPP_QTE_IN_REC.marketing_source_code_id <> FND_API.G_MISS_NUM THEN

Line 584: IF P_OPP_QTE_IN_REC.marketing_source_code_id <> FND_API.G_MISS_NUM THEN

580: IF P_OPP_QTE_IN_REC.currency_code <> FND_API.G_MISS_CHAR THEN
581: l_qte_header_rec.currency_code := P_OPP_QTE_IN_REC.currency_code;
582: END IF;
583:
584: IF P_OPP_QTE_IN_REC.marketing_source_code_id <> FND_API.G_MISS_NUM THEN
585: l_qte_header_rec.marketing_source_code_id := P_OPP_QTE_IN_REC.marketing_source_code_id;
586: END IF;
587:
588: IF P_OPP_QTE_IN_REC.PRICING_STATUS_INDICATOR <> FND_API.G_MISS_CHAR THEN

Line 588: IF P_OPP_QTE_IN_REC.PRICING_STATUS_INDICATOR <> FND_API.G_MISS_CHAR THEN

584: IF P_OPP_QTE_IN_REC.marketing_source_code_id <> FND_API.G_MISS_NUM THEN
585: l_qte_header_rec.marketing_source_code_id := P_OPP_QTE_IN_REC.marketing_source_code_id;
586: END IF;
587:
588: IF P_OPP_QTE_IN_REC.PRICING_STATUS_INDICATOR <> FND_API.G_MISS_CHAR THEN
589: l_qte_header_rec.PRICING_STATUS_INDICATOR := P_OPP_QTE_IN_REC.PRICING_STATUS_INDICATOR;
590: END IF;
591:
592: IF P_OPP_QTE_IN_REC.TAX_STATUS_INDICATOR <> FND_API.G_MISS_CHAR THEN

Line 592: IF P_OPP_QTE_IN_REC.TAX_STATUS_INDICATOR <> FND_API.G_MISS_CHAR THEN

588: IF P_OPP_QTE_IN_REC.PRICING_STATUS_INDICATOR <> FND_API.G_MISS_CHAR THEN
589: l_qte_header_rec.PRICING_STATUS_INDICATOR := P_OPP_QTE_IN_REC.PRICING_STATUS_INDICATOR;
590: END IF;
591:
592: IF P_OPP_QTE_IN_REC.TAX_STATUS_INDICATOR <> FND_API.G_MISS_CHAR THEN
593: l_qte_header_rec.TAX_STATUS_INDICATOR := P_OPP_QTE_IN_REC.TAX_STATUS_INDICATOR;
594: END IF;
595:
596: IF P_OPP_QTE_IN_REC.PRICE_UPDATED_DATE <> FND_API.G_MISS_DATE THEN

Line 596: IF P_OPP_QTE_IN_REC.PRICE_UPDATED_DATE <> FND_API.G_MISS_DATE THEN

592: IF P_OPP_QTE_IN_REC.TAX_STATUS_INDICATOR <> FND_API.G_MISS_CHAR THEN
593: l_qte_header_rec.TAX_STATUS_INDICATOR := P_OPP_QTE_IN_REC.TAX_STATUS_INDICATOR;
594: END IF;
595:
596: IF P_OPP_QTE_IN_REC.PRICE_UPDATED_DATE <> FND_API.G_MISS_DATE THEN
597: l_qte_header_rec.PRICE_UPDATED_DATE := P_OPP_QTE_IN_REC.PRICE_UPDATED_DATE;
598: END IF;
599:
600: IF P_OPP_QTE_IN_REC.TAX_UPDATED_DATE <> FND_API.G_MISS_DATE THEN

Line 600: IF P_OPP_QTE_IN_REC.TAX_UPDATED_DATE <> FND_API.G_MISS_DATE THEN

596: IF P_OPP_QTE_IN_REC.PRICE_UPDATED_DATE <> FND_API.G_MISS_DATE THEN
597: l_qte_header_rec.PRICE_UPDATED_DATE := P_OPP_QTE_IN_REC.PRICE_UPDATED_DATE;
598: END IF;
599:
600: IF P_OPP_QTE_IN_REC.TAX_UPDATED_DATE <> FND_API.G_MISS_DATE THEN
601: l_qte_header_rec.TAX_UPDATED_DATE := P_OPP_QTE_IN_REC.TAX_UPDATED_DATE;
602: END IF;
603:
604:

Line 647: IF P_OPP_QTE_IN_REC.cust_party_id <> FND_API.G_MISS_NUM

643:
644: l_qte_header_rec.cust_party_id := P_OPP_QTE_IN_REC.cust_party_id ;
645: l_qte_header_rec.invoice_to_cust_party_id := P_OPP_QTE_IN_REC.cust_party_id ;
646:
647: IF P_OPP_QTE_IN_REC.cust_party_id <> FND_API.G_MISS_NUM
648: AND P_OPP_QTE_IN_REC.cust_party_id IS NOT NULL THEN
649: l_hd_Shipment_Rec.operation_code := 'CREATE' ;
650: l_hd_Shipment_Rec.ship_to_cust_party_id := P_OPP_QTE_IN_REC.cust_party_id ;
651: END IF;

Line 670: IF l_payment_term_id <> FND_API.G_MISS_NUM and l_payment_term_id IS NOT NULL THEN

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';
672: l_hd_Payment_Tbl(1).payment_term_id := l_payment_term_id;
673: END IF;
674:

Line 680: IF P_OPP_QTE_IN_REC.cust_party_id <> FND_API.G_MISS_NUM

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
681: AND P_OPP_QTE_IN_REC.cust_party_id IS NOT NULL THEN
682: OPEN c_primary_address(P_OPP_QTE_IN_REC.cust_party_id,'BILL_TO');
683: FETCH c_primary_address INTO l_party_site_id;
684:

Line 696: IF l_party_site_id <> FND_API.G_MISS_NUM and l_party_site_id IS NOT NULL THEN

692: END IF;
693: close c_primary_address;
694: END IF;
695:
696: IF l_party_site_id <> FND_API.G_MISS_NUM and l_party_site_id IS NOT NULL THEN
697: Address_Validation(
698: p_party_site_id => l_party_site_id ,
699: p_use_type => 'BILL_TO',
700: x_valid => x_valid,

Line 713: l_qte_header_rec.invoice_to_party_site_id := FND_API.G_MISS_NUM;

709:
710: IF x_valid = 'Y' THEN
711: l_qte_header_rec.invoice_to_party_site_id := l_party_site_id;
712: else
713: l_qte_header_rec.invoice_to_party_site_id := FND_API.G_MISS_NUM;
714: end if;
715:
716: END IF;
717:

Line 718: IF P_OPP_QTE_IN_REC.cust_party_id <> FND_API.G_MISS_NUM

714: end if;
715:
716: END IF;
717:
718: IF P_OPP_QTE_IN_REC.cust_party_id <> FND_API.G_MISS_NUM
719: AND P_OPP_QTE_IN_REC.cust_party_id IS NOT NULL THEN
720: OPEN c_primary_address(P_OPP_QTE_IN_REC.cust_party_id,'SHIP_TO');
721: FETCH c_primary_address INTO l_party_site_id;
722:

Line 734: IF l_party_site_id <> FND_API.G_MISS_NUM and l_party_site_id IS NOT NULL THEN

730: end if;
731: close c_primary_address;
732: END IF;
733:
734: IF l_party_site_id <> FND_API.G_MISS_NUM and l_party_site_id IS NOT NULL THEN
735: l_hd_Shipment_Rec.operation_code := 'CREATE';
736: Address_Validation(
737: p_party_site_id => l_party_site_id,
738: p_use_type => 'SHIP_TO',

Line 753: l_hd_Shipment_Rec.ship_to_party_site_id := FND_API.G_MISS_NUM;

749:
750: IF x_valid = 'Y' THEN
751: l_hd_Shipment_Rec.ship_to_party_site_id := l_party_site_id;
752: else
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

Line 761: IF P_OPP_QTE_IN_REC.CUST_ACCOUNT_ID <> FND_API.G_MISS_NUM THEN

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;
763: l_qte_header_rec.invoice_to_cust_account_id := P_OPP_QTE_IN_REC.CUST_ACCOUNT_ID;
764: l_hd_Shipment_Rec.operation_code := 'CREATE' ;
765: l_hd_Shipment_Rec.ship_to_cust_account_id := P_OPP_QTE_IN_REC.CUST_ACCOUNT_ID;

Line 771: IF l_lead_rec.offer_id IS NOT NULL AND l_lead_rec.offer_id <> FND_API.G_MISS_NUM THEN

767:
768: END IF;
769:
770:
771: IF l_lead_rec.offer_id IS NOT NULL AND l_lead_rec.offer_id <> FND_API.G_MISS_NUM THEN
772: FOR l_campaign_rec IN C_campaign_id(l_lead_rec.offer_id) LOOP
773: l_hd_price_attributes_tbl(1).operation_code := 'CREATE';
774: l_hd_price_attributes_tbl(1).pricing_context := 'MODLIST';
775: l_hd_price_attributes_tbl(1).flex_title := 'QP_ATTR_DEFNS_QUALIFIER';

Line 786: IF l_qte_header_rec.sold_to_party_site_id <> FND_API.G_MISS_NUM THEN

782: END LOOP;
783: END IF;
784:
785: If l_control_rec.defaulting_fwk_flag = 'Y' then
786: IF l_qte_header_rec.sold_to_party_site_id <> FND_API.G_MISS_NUM THEN
787: Address_Validation(
788: p_party_site_id => l_qte_header_rec.sold_to_party_site_id ,
789: p_use_type => 'SOLD_TO',
790: x_valid => x_valid,

Line 804: l_qte_header_rec.sold_to_party_site_id := FND_API.G_MISS_NUM;

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;
803: else
804: l_qte_header_rec.sold_to_party_site_id := FND_API.G_MISS_NUM;
805: END IF;
806:
807: end if;
808:

Line 809: IF l_qte_header_rec.invoice_to_party_site_id <> FND_API.G_MISS_NUM

805: END IF;
806:
807: end if;
808:
809: IF l_qte_header_rec.invoice_to_party_site_id <> FND_API.G_MISS_NUM
810: AND l_qte_header_rec.invoice_to_party_site_id IS NOT NULL THEN
811: Address_Validation(
812: p_party_site_id => l_qte_header_rec.invoice_to_party_site_id ,
813: p_use_type => 'BILL_TO',

Line 828: l_qte_header_rec.invoice_to_party_site_id := FND_API.G_MISS_NUM;

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;
827: else
828: l_qte_header_rec.invoice_to_party_site_id := FND_API.G_MISS_NUM;
829: end if;
830:
831: END IF;
832:

Line 833: IF l_hd_Shipment_Rec.ship_to_party_site_id <> FND_API.G_MISS_NUM

829: end if;
830:
831: END IF;
832:
833: IF l_hd_Shipment_Rec.ship_to_party_site_id <> FND_API.G_MISS_NUM
834: AND l_hd_Shipment_Rec.ship_to_party_site_id IS NOT NULL THEN
835: l_hd_Shipment_Rec.operation_code := 'CREATE' ;
836: Address_Validation(
837: p_party_site_id => l_hd_Shipment_Rec.ship_to_party_site_id,

Line 854: l_hd_Shipment_Rec.ship_to_party_site_id := FND_API.G_MISS_NUM;

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;
853: else
854: l_hd_Shipment_Rec.ship_to_party_site_id := FND_API.G_MISS_NUM;
855: end if;
856:
857: END IF;
858:

Line 886: P_Init_Msg_List => FND_API.G_FALSE,

882: l_ln_price_attr_count := 0;
883:
884: ASO_QUOTE_PUB.Create_Quote(
885: P_Api_Version_Number => 1.0,
886: P_Init_Msg_List => FND_API.G_FALSE,
887: P_Commit => FND_API.G_FALSE,
888: p_control_rec => l_control_rec,
889: p_qte_header_rec => l_qte_header_rec,
890: P_hd_Price_Attributes_Tbl => l_hd_price_attributes_tbl,

Line 887: P_Commit => FND_API.G_FALSE,

883:
884: ASO_QUOTE_PUB.Create_Quote(
885: P_Api_Version_Number => 1.0,
886: P_Init_Msg_List => FND_API.G_FALSE,
887: P_Commit => FND_API.G_FALSE,
888: p_control_rec => l_control_rec,
889: p_qte_header_rec => l_qte_header_rec,
890: P_hd_Price_Attributes_Tbl => l_hd_price_attributes_tbl,
891: P_hd_Payment_Tbl => l_hd_Payment_Tbl,

Line 930: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

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;
932: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
933: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
934: END IF;

Line 931: RAISE FND_API.G_EXC_ERROR;

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;
932: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
933: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
934: END IF;
935:

Line 932: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

928: END IF;
929:
930: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
931: RAISE FND_API.G_EXC_ERROR;
932: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
933: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
934: END IF;
935:
936: FOR l_lead_line_rec IN c_lead_line(P_OPP_QTE_IN_REC.OPPORTUNITY_ID) LOOP

Line 933: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

929:
930: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
931: RAISE FND_API.G_EXC_ERROR;
932: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
933: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
934: END IF;
935:
936: FOR l_lead_line_rec IN c_lead_line(P_OPP_QTE_IN_REC.OPPORTUNITY_ID) LOOP
937:

Line 938: IF (l_lead_line_rec.uom_code IS NULL) OR (l_lead_line_rec.uom_code = FND_API.G_MISS_CHAR) THEN

934: END IF;
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:

Line 1019: AND l_lead_line_rec.forecast_date <> FND_API.G_MISS_DATE THEN

1015:
1016:
1017: /* Line level forecast date should not be mapped to the Request Date Bug (3115703*/
1018: /* IF l_lead_line_rec.forecast_date IS NOT NULL
1019: AND l_lead_line_rec.forecast_date <> FND_API.G_MISS_DATE THEN
1020: IF l_lead_line_rec.forecast_date >= SYSDATE THEN
1021: l_ln_shipment_count := l_ln_shipment_count + 1;
1022: lp_ln_shipment_tbl(l_ln_shipment_count).qte_line_index := l_line_count;
1023: lp_ln_shipment_tbl(l_ln_shipment_count).operation_code := 'CREATE';

Line 1067: p_init_msg_list => FND_API.G_FALSE,

1063: END IF;
1064:
1065: ASO_VALIDATE_PRICING_PVT.Validate_Pricing_Order(
1066: p_api_version_number => 1.0,
1067: p_init_msg_list => FND_API.G_FALSE,
1068: p_commit => FND_API.G_FALSE,
1069: p_control_rec => l_pricing_control_rec,
1070: p_qte_header_rec => lx_qte_header_rec,
1071: p_qte_line_tbl => l_qte_line_tbl,

Line 1068: p_commit => FND_API.G_FALSE,

1064:
1065: ASO_VALIDATE_PRICING_PVT.Validate_Pricing_Order(
1066: p_api_version_number => 1.0,
1067: p_init_msg_list => FND_API.G_FALSE,
1068: p_commit => FND_API.G_FALSE,
1069: p_control_rec => l_pricing_control_rec,
1070: p_qte_header_rec => lx_qte_header_rec,
1071: p_qte_line_tbl => l_qte_line_tbl,
1072: p_ln_shipment_tbl => lp_ln_shipment_tbl,

Line 1089: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

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;
1091: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1092: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1093: END IF;

Line 1090: RAISE FND_API.G_EXC_ERROR;

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;
1091: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1092: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1093: END IF;
1094:

Line 1091: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1087: END IF;
1088:
1089: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1090: RAISE FND_API.G_EXC_ERROR;
1091: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1092: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1093: END IF;
1094:
1095: l_dtl_line_count := 0;

Line 1092: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1088:
1089: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1090: RAISE FND_API.G_EXC_ERROR;
1091: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1092: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1093: END IF;
1094:
1095: l_dtl_line_count := 0;
1096: l_line_count := 0;

Line 1105: IF lpx_qte_line_tbl(i).pricing_status_code <> FND_API.G_RET_STS_SUCCESS THEN

1101: l_profile_val := fnd_profile.value('ASO_REQUIRE_SERVICE_REFERENCE');
1102:
1103: FOR i IN 1..lpx_qte_line_tbl.count LOOP
1104:
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

Line 1123: l_add_line := fnd_api.g_true;

1119:
1120: l_serv_item_flag := null;
1121: l_serv_duraion := null;
1122: l_serv_period := null;
1123: l_add_line := fnd_api.g_true;
1124: l_add_service := fnd_api.g_false;
1125:
1126: open c_serv_item(lpx_qte_line_tbl(i).inventory_item_id,lpx_qte_line_tbl(i).organization_id);
1127: fetch c_serv_item INTO l_serv_item_flag,l_serv_duraion,l_serv_period;

Line 1124: l_add_service := fnd_api.g_false;

1120: l_serv_item_flag := null;
1121: l_serv_duraion := null;
1122: l_serv_period := null;
1123: l_add_line := fnd_api.g_true;
1124: l_add_service := fnd_api.g_false;
1125:
1126: open c_serv_item(lpx_qte_line_tbl(i).inventory_item_id,lpx_qte_line_tbl(i).organization_id);
1127: fetch c_serv_item INTO l_serv_item_flag,l_serv_duraion,l_serv_period;
1128: close c_serv_item;

Line 1147: l_add_service := fnd_api.g_true;

1143: l_qte_line_dtl_tbl(l_dtl_line_count).operation_code := 'CREATE';
1144: l_qte_line_dtl_tbl(l_dtl_line_count).service_duration := l_serv_duraion;
1145: l_qte_line_dtl_tbl(l_dtl_line_count).service_period := l_serv_period;
1146:
1147: l_add_service := fnd_api.g_true;
1148:
1149: else
1150: l_add_line := fnd_api.g_false;
1151:

Line 1150: l_add_line := fnd_api.g_false;

1146:
1147: l_add_service := fnd_api.g_true;
1148:
1149: else
1150: l_add_line := fnd_api.g_false;
1151:
1152: end if;
1153:
1154: end if;

Line 1157: if l_add_line = fnd_api.g_true then

1153:
1154: end if;
1155:
1156:
1157: if l_add_line = fnd_api.g_true then
1158:
1159: if l_add_service = fnd_api.g_false then
1160:
1161: l_line_count := l_line_count + 1;

Line 1159: if l_add_service = fnd_api.g_false then

1155:
1156:
1157: if l_add_line = fnd_api.g_true then
1158:
1159: if l_add_service = fnd_api.g_false then
1160:
1161: l_line_count := l_line_count + 1;
1162: l_qte_line_tbl(l_line_count) := lpx_qte_line_tbl(i);
1163:

Line 1199: end if; --l_add_line = fnd_api.g_true then

1195: END IF;
1196:
1197: END LOOP;
1198:
1199: end if; --l_add_line = fnd_api.g_true then
1200:
1201: END IF;
1202:
1203: END LOOP;

Line 1276: x_return_status := FND_API.G_RET_STS_ERROR;

1272:
1273: lx_QTE_HEADER_REC.last_update_date := l_last_update_date;
1274:
1275: EXCEPTION WHEN NO_DATA_FOUND THEN
1276: x_return_status := FND_API.G_RET_STS_ERROR;
1277: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1278: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_COLUMN');
1279: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
1280: FND_MSG_PUB.ADD;

Line 1282: RAISE FND_API.G_EXC_ERROR;

1278: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_COLUMN');
1279: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
1280: FND_MSG_PUB.ADD;
1281: END IF;
1282: RAISE FND_API.G_EXC_ERROR;
1283: END;
1284:
1285:
1286: ASO_QUOTE_PUB.Update_Quote(

Line 1288: p_init_msg_list => fnd_api.g_false,

1284:
1285:
1286: ASO_QUOTE_PUB.Update_Quote(
1287: p_api_version_number => 1.0,
1288: p_init_msg_list => fnd_api.g_false,
1289: p_commit => fnd_api.g_false,
1290: p_control_rec => p_control_rec,
1291: p_qte_header_rec => lx_qte_header_rec,
1292: p_qte_line_tbl => l_qte_line_tbl,

Line 1289: p_commit => fnd_api.g_false,

1285:
1286: ASO_QUOTE_PUB.Update_Quote(
1287: p_api_version_number => 1.0,
1288: p_init_msg_list => fnd_api.g_false,
1289: p_commit => fnd_api.g_false,
1290: p_control_rec => p_control_rec,
1291: p_qte_header_rec => lx_qte_header_rec,
1292: p_qte_line_tbl => l_qte_line_tbl,
1293: p_qte_line_dtl_tbl => l_qte_line_dtl_tbl,

Line 1338: IF x_return_status = FND_API.G_RET_STS_ERROR 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;
1340: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1341: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1342: END IF;

Line 1339: raise FND_API.G_EXC_ERROR;

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;
1340: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1341: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1342: END IF;
1343:

Line 1340: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

1336: END IF;
1337:
1338: IF x_return_status = FND_API.G_RET_STS_ERROR then
1339: raise FND_API.G_EXC_ERROR;
1340: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1341: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1342: END IF;
1343:
1344:

Line 1341: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1337:
1338: IF x_return_status = FND_API.G_RET_STS_ERROR then
1339: raise FND_API.G_EXC_ERROR;
1340: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1341: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1342: END IF;
1343:
1344:
1345: -- security changes

Line 1363: P_QUOTE_NUMBER => FND_API.G_MISS_NUM,

1359:
1360: FOR l_opp_rec IN C_opp_owner(P_OPP_QTE_IN_REC.OPPORTUNITY_ID,lx_qte_header_rec.quote_number) LOOP
1361: ASO_QUOTE_ACCESSES_PKG.UPDATE_ROW(
1362: P_ACCESS_ID => l_opp_rec.access_id,
1363: P_QUOTE_NUMBER => FND_API.G_MISS_NUM,
1364: P_RESOURCE_ID => FND_API.G_MISS_NUM,
1365: P_RESOURCE_GRP_ID => FND_API.G_MISS_NUM,
1366: P_CREATED_BY => FND_API.G_MISS_NUM,
1367: P_CREATION_DATE => FND_API.G_MISS_DATE,

Line 1364: P_RESOURCE_ID => FND_API.G_MISS_NUM,

1360: FOR l_opp_rec IN C_opp_owner(P_OPP_QTE_IN_REC.OPPORTUNITY_ID,lx_qte_header_rec.quote_number) LOOP
1361: ASO_QUOTE_ACCESSES_PKG.UPDATE_ROW(
1362: P_ACCESS_ID => l_opp_rec.access_id,
1363: P_QUOTE_NUMBER => FND_API.G_MISS_NUM,
1364: P_RESOURCE_ID => FND_API.G_MISS_NUM,
1365: P_RESOURCE_GRP_ID => FND_API.G_MISS_NUM,
1366: P_CREATED_BY => FND_API.G_MISS_NUM,
1367: P_CREATION_DATE => FND_API.G_MISS_DATE,
1368: P_LAST_UPDATED_BY => G_USER_ID,

Line 1365: P_RESOURCE_GRP_ID => FND_API.G_MISS_NUM,

1361: ASO_QUOTE_ACCESSES_PKG.UPDATE_ROW(
1362: P_ACCESS_ID => l_opp_rec.access_id,
1363: P_QUOTE_NUMBER => FND_API.G_MISS_NUM,
1364: P_RESOURCE_ID => FND_API.G_MISS_NUM,
1365: P_RESOURCE_GRP_ID => FND_API.G_MISS_NUM,
1366: P_CREATED_BY => FND_API.G_MISS_NUM,
1367: P_CREATION_DATE => FND_API.G_MISS_DATE,
1368: P_LAST_UPDATED_BY => G_USER_ID,
1369: P_LAST_UPDATE_LOGIN => G_LOGIN_ID,

Line 1366: P_CREATED_BY => FND_API.G_MISS_NUM,

1362: P_ACCESS_ID => l_opp_rec.access_id,
1363: P_QUOTE_NUMBER => FND_API.G_MISS_NUM,
1364: P_RESOURCE_ID => FND_API.G_MISS_NUM,
1365: P_RESOURCE_GRP_ID => FND_API.G_MISS_NUM,
1366: P_CREATED_BY => FND_API.G_MISS_NUM,
1367: P_CREATION_DATE => FND_API.G_MISS_DATE,
1368: P_LAST_UPDATED_BY => G_USER_ID,
1369: P_LAST_UPDATE_LOGIN => G_LOGIN_ID,
1370: P_LAST_UPDATE_DATE => SYSDATE,

Line 1367: P_CREATION_DATE => FND_API.G_MISS_DATE,

1363: P_QUOTE_NUMBER => FND_API.G_MISS_NUM,
1364: P_RESOURCE_ID => FND_API.G_MISS_NUM,
1365: P_RESOURCE_GRP_ID => FND_API.G_MISS_NUM,
1366: P_CREATED_BY => FND_API.G_MISS_NUM,
1367: P_CREATION_DATE => FND_API.G_MISS_DATE,
1368: P_LAST_UPDATED_BY => G_USER_ID,
1369: P_LAST_UPDATE_LOGIN => G_LOGIN_ID,
1370: P_LAST_UPDATE_DATE => SYSDATE,
1371: P_REQUEST_ID => FND_API.G_MISS_NUM,

Line 1371: P_REQUEST_ID => FND_API.G_MISS_NUM,

1367: P_CREATION_DATE => FND_API.G_MISS_DATE,
1368: P_LAST_UPDATED_BY => G_USER_ID,
1369: P_LAST_UPDATE_LOGIN => G_LOGIN_ID,
1370: P_LAST_UPDATE_DATE => SYSDATE,
1371: P_REQUEST_ID => FND_API.G_MISS_NUM,
1372: P_PROGRAM_APPLICATION_ID => FND_API.G_MISS_NUM,
1373: P_PROGRAM_ID => FND_API.G_MISS_NUM,
1374: P_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,
1375: P_KEEP_FLAG => l_opp_rec.freeze_flag,

Line 1372: P_PROGRAM_APPLICATION_ID => FND_API.G_MISS_NUM,

1368: P_LAST_UPDATED_BY => G_USER_ID,
1369: P_LAST_UPDATE_LOGIN => G_LOGIN_ID,
1370: P_LAST_UPDATE_DATE => SYSDATE,
1371: P_REQUEST_ID => FND_API.G_MISS_NUM,
1372: P_PROGRAM_APPLICATION_ID => FND_API.G_MISS_NUM,
1373: P_PROGRAM_ID => FND_API.G_MISS_NUM,
1374: P_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,
1375: P_KEEP_FLAG => l_opp_rec.freeze_flag,
1376: P_UPDATE_ACCESS_FLAG => FND_API.G_MISS_CHAR,

Line 1373: P_PROGRAM_ID => FND_API.G_MISS_NUM,

1369: P_LAST_UPDATE_LOGIN => G_LOGIN_ID,
1370: P_LAST_UPDATE_DATE => SYSDATE,
1371: P_REQUEST_ID => FND_API.G_MISS_NUM,
1372: P_PROGRAM_APPLICATION_ID => FND_API.G_MISS_NUM,
1373: P_PROGRAM_ID => FND_API.G_MISS_NUM,
1374: P_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,
1375: P_KEEP_FLAG => l_opp_rec.freeze_flag,
1376: P_UPDATE_ACCESS_FLAG => FND_API.G_MISS_CHAR,
1377: P_CREATED_BY_TAP_FLAG => FND_API.G_MISS_CHAR,

Line 1374: P_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,

1370: P_LAST_UPDATE_DATE => SYSDATE,
1371: P_REQUEST_ID => FND_API.G_MISS_NUM,
1372: P_PROGRAM_APPLICATION_ID => FND_API.G_MISS_NUM,
1373: P_PROGRAM_ID => FND_API.G_MISS_NUM,
1374: P_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,
1375: P_KEEP_FLAG => l_opp_rec.freeze_flag,
1376: P_UPDATE_ACCESS_FLAG => FND_API.G_MISS_CHAR,
1377: P_CREATED_BY_TAP_FLAG => FND_API.G_MISS_CHAR,
1378: p_TERRITORY_ID => FND_API.G_MISS_NUM,

Line 1376: P_UPDATE_ACCESS_FLAG => FND_API.G_MISS_CHAR,

1372: P_PROGRAM_APPLICATION_ID => FND_API.G_MISS_NUM,
1373: P_PROGRAM_ID => FND_API.G_MISS_NUM,
1374: P_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,
1375: P_KEEP_FLAG => l_opp_rec.freeze_flag,
1376: P_UPDATE_ACCESS_FLAG => FND_API.G_MISS_CHAR,
1377: P_CREATED_BY_TAP_FLAG => FND_API.G_MISS_CHAR,
1378: p_TERRITORY_ID => FND_API.G_MISS_NUM,
1379: p_TERRITORY_SOURCE_FLAG => FND_API.G_MISS_CHAR,
1380: p_ROLE_ID => FND_API.G_MISS_NUM,

Line 1377: P_CREATED_BY_TAP_FLAG => FND_API.G_MISS_CHAR,

1373: P_PROGRAM_ID => FND_API.G_MISS_NUM,
1374: P_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,
1375: P_KEEP_FLAG => l_opp_rec.freeze_flag,
1376: P_UPDATE_ACCESS_FLAG => FND_API.G_MISS_CHAR,
1377: P_CREATED_BY_TAP_FLAG => FND_API.G_MISS_CHAR,
1378: p_TERRITORY_ID => FND_API.G_MISS_NUM,
1379: p_TERRITORY_SOURCE_FLAG => FND_API.G_MISS_CHAR,
1380: p_ROLE_ID => FND_API.G_MISS_NUM,
1381: P_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,

Line 1378: p_TERRITORY_ID => FND_API.G_MISS_NUM,

1374: P_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,
1375: P_KEEP_FLAG => l_opp_rec.freeze_flag,
1376: P_UPDATE_ACCESS_FLAG => FND_API.G_MISS_CHAR,
1377: P_CREATED_BY_TAP_FLAG => FND_API.G_MISS_CHAR,
1378: p_TERRITORY_ID => FND_API.G_MISS_NUM,
1379: p_TERRITORY_SOURCE_FLAG => FND_API.G_MISS_CHAR,
1380: p_ROLE_ID => FND_API.G_MISS_NUM,
1381: P_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
1382: P_ATTRIBUTE1 => FND_API.G_MISS_CHAR,

Line 1379: p_TERRITORY_SOURCE_FLAG => FND_API.G_MISS_CHAR,

1375: P_KEEP_FLAG => l_opp_rec.freeze_flag,
1376: P_UPDATE_ACCESS_FLAG => FND_API.G_MISS_CHAR,
1377: P_CREATED_BY_TAP_FLAG => FND_API.G_MISS_CHAR,
1378: p_TERRITORY_ID => FND_API.G_MISS_NUM,
1379: p_TERRITORY_SOURCE_FLAG => FND_API.G_MISS_CHAR,
1380: p_ROLE_ID => FND_API.G_MISS_NUM,
1381: P_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
1382: P_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
1383: P_ATTRIBUTE2 => FND_API.G_MISS_CHAR,

Line 1380: p_ROLE_ID => FND_API.G_MISS_NUM,

1376: P_UPDATE_ACCESS_FLAG => FND_API.G_MISS_CHAR,
1377: P_CREATED_BY_TAP_FLAG => FND_API.G_MISS_CHAR,
1378: p_TERRITORY_ID => FND_API.G_MISS_NUM,
1379: p_TERRITORY_SOURCE_FLAG => FND_API.G_MISS_CHAR,
1380: p_ROLE_ID => FND_API.G_MISS_NUM,
1381: P_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
1382: P_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
1383: P_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
1384: P_ATTRIBUTE3 => FND_API.G_MISS_CHAR,

Line 1381: P_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,

1377: P_CREATED_BY_TAP_FLAG => FND_API.G_MISS_CHAR,
1378: p_TERRITORY_ID => FND_API.G_MISS_NUM,
1379: p_TERRITORY_SOURCE_FLAG => FND_API.G_MISS_CHAR,
1380: p_ROLE_ID => FND_API.G_MISS_NUM,
1381: P_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
1382: P_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
1383: P_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
1384: P_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
1385: P_ATTRIBUTE4 => FND_API.G_MISS_CHAR,

Line 1382: P_ATTRIBUTE1 => FND_API.G_MISS_CHAR,

1378: p_TERRITORY_ID => FND_API.G_MISS_NUM,
1379: p_TERRITORY_SOURCE_FLAG => FND_API.G_MISS_CHAR,
1380: p_ROLE_ID => FND_API.G_MISS_NUM,
1381: P_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
1382: P_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
1383: P_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
1384: P_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
1385: P_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
1386: P_ATTRIBUTE5 => FND_API.G_MISS_CHAR,

Line 1383: P_ATTRIBUTE2 => FND_API.G_MISS_CHAR,

1379: p_TERRITORY_SOURCE_FLAG => FND_API.G_MISS_CHAR,
1380: p_ROLE_ID => FND_API.G_MISS_NUM,
1381: P_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
1382: P_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
1383: P_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
1384: P_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
1385: P_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
1386: P_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
1387: P_ATTRIBUTE6 => FND_API.G_MISS_CHAR,

Line 1384: P_ATTRIBUTE3 => FND_API.G_MISS_CHAR,

1380: p_ROLE_ID => FND_API.G_MISS_NUM,
1381: P_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
1382: P_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
1383: P_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
1384: P_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
1385: P_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
1386: P_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
1387: P_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
1388: P_ATTRIBUTE7 => FND_API.G_MISS_CHAR,

Line 1385: P_ATTRIBUTE4 => FND_API.G_MISS_CHAR,

1381: P_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
1382: P_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
1383: P_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
1384: P_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
1385: P_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
1386: P_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
1387: P_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
1388: P_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
1389: P_ATTRIBUTE8 => FND_API.G_MISS_CHAR,

Line 1386: P_ATTRIBUTE5 => FND_API.G_MISS_CHAR,

1382: P_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
1383: P_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
1384: P_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
1385: P_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
1386: P_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
1387: P_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
1388: P_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
1389: P_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
1390: P_ATTRIBUTE9 => FND_API.G_MISS_CHAR,

Line 1387: P_ATTRIBUTE6 => FND_API.G_MISS_CHAR,

1383: P_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
1384: P_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
1385: P_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
1386: P_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
1387: P_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
1388: P_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
1389: P_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
1390: P_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
1391: P_ATTRIBUTE10 => FND_API.G_MISS_CHAR,

Line 1388: P_ATTRIBUTE7 => FND_API.G_MISS_CHAR,

1384: P_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
1385: P_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
1386: P_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
1387: P_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
1388: P_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
1389: P_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
1390: P_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
1391: P_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
1392: P_ATTRIBUTE11 => FND_API.G_MISS_CHAR,

Line 1389: P_ATTRIBUTE8 => FND_API.G_MISS_CHAR,

1385: P_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
1386: P_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
1387: P_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
1388: P_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
1389: P_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
1390: P_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
1391: P_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
1392: P_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
1393: P_ATTRIBUTE12 => FND_API.G_MISS_CHAR,

Line 1390: P_ATTRIBUTE9 => FND_API.G_MISS_CHAR,

1386: P_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
1387: P_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
1388: P_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
1389: P_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
1390: P_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
1391: P_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
1392: P_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
1393: P_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
1394: P_ATTRIBUTE13 => FND_API.G_MISS_CHAR,

Line 1391: P_ATTRIBUTE10 => FND_API.G_MISS_CHAR,

1387: P_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
1388: P_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
1389: P_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
1390: P_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
1391: P_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
1392: P_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
1393: P_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
1394: P_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
1395: P_ATTRIBUTE14 => FND_API.G_MISS_CHAR,

Line 1392: P_ATTRIBUTE11 => FND_API.G_MISS_CHAR,

1388: P_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
1389: P_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
1390: P_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
1391: P_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
1392: P_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
1393: P_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
1394: P_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
1395: P_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
1396: P_ATTRIBUTE15 => FND_API.G_MISS_CHAR,

Line 1393: P_ATTRIBUTE12 => FND_API.G_MISS_CHAR,

1389: P_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
1390: P_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
1391: P_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
1392: P_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
1393: P_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
1394: P_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
1395: P_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
1396: P_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
1397: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,

Line 1394: P_ATTRIBUTE13 => FND_API.G_MISS_CHAR,

1390: P_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
1391: P_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
1392: P_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
1393: P_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
1394: P_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
1395: P_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
1396: P_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
1397: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,
1398: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,

Line 1395: P_ATTRIBUTE14 => FND_API.G_MISS_CHAR,

1391: P_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
1392: P_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
1393: P_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
1394: P_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
1395: P_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
1396: P_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
1397: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,
1398: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,
1399: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,

Line 1396: P_ATTRIBUTE15 => FND_API.G_MISS_CHAR,

1392: P_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
1393: P_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
1394: P_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
1395: P_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
1396: P_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
1397: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,
1398: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,
1399: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,
1400: p_ATTRIBUTE19 => FND_API.G_MISS_CHAR,

Line 1397: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,

1393: P_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
1394: P_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
1395: P_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
1396: P_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
1397: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,
1398: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,
1399: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,
1400: p_ATTRIBUTE19 => FND_API.G_MISS_CHAR,
1401: p_ATTRIBUTE20 => FND_API.G_MISS_CHAR,

Line 1398: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,

1394: P_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
1395: P_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
1396: P_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
1397: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,
1398: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,
1399: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,
1400: p_ATTRIBUTE19 => FND_API.G_MISS_CHAR,
1401: p_ATTRIBUTE20 => FND_API.G_MISS_CHAR,
1402: P_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM

Line 1399: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,

1395: P_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
1396: P_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
1397: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,
1398: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,
1399: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,
1400: p_ATTRIBUTE19 => FND_API.G_MISS_CHAR,
1401: p_ATTRIBUTE20 => FND_API.G_MISS_CHAR,
1402: P_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM
1403: );

Line 1400: p_ATTRIBUTE19 => FND_API.G_MISS_CHAR,

1396: P_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
1397: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,
1398: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,
1399: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,
1400: p_ATTRIBUTE19 => FND_API.G_MISS_CHAR,
1401: p_ATTRIBUTE20 => FND_API.G_MISS_CHAR,
1402: P_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM
1403: );
1404:

Line 1401: p_ATTRIBUTE20 => FND_API.G_MISS_CHAR,

1397: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,
1398: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,
1399: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,
1400: p_ATTRIBUTE19 => FND_API.G_MISS_CHAR,
1401: p_ATTRIBUTE20 => FND_API.G_MISS_CHAR,
1402: P_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM
1403: );
1404:
1405: END LOOP;

Line 1402: P_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM

1398: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,
1399: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,
1400: p_ATTRIBUTE19 => FND_API.G_MISS_CHAR,
1401: p_ATTRIBUTE20 => FND_API.G_MISS_CHAR,
1402: P_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM
1403: );
1404:
1405: END LOOP;
1406:

Line 1435: p_init_msg_list => FND_API.G_FALSE,

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(
1434: p_api_version => 1.0,
1435: p_init_msg_list => FND_API.G_FALSE,
1436: p_commit => FND_API.G_FALSE,
1437: p_old_object_id => P_OPP_QTE_IN_REC.OPPORTUNITY_ID,
1438: p_new_object_id => lx_qte_header_rec.quote_header_id,
1439: p_old_object_type_code => 'OPPORTUNITY',

Line 1436: p_commit => FND_API.G_FALSE,

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(
1434: p_api_version => 1.0,
1435: p_init_msg_list => FND_API.G_FALSE,
1436: p_commit => FND_API.G_FALSE,
1437: p_old_object_id => P_OPP_QTE_IN_REC.OPPORTUNITY_ID,
1438: p_new_object_id => lx_qte_header_rec.quote_header_id,
1439: p_old_object_type_code => 'OPPORTUNITY',
1440: p_new_object_type_code => 'ASO_QUOTE',

Line 1445: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1441: x_return_status => x_return_status,
1442: x_msg_count => x_msg_count,
1443: x_msg_data => x_msg_data
1444: );
1445: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1446: RAISE FND_API.G_EXC_ERROR;
1447: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1448: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1449: END IF;

Line 1446: RAISE FND_API.G_EXC_ERROR;

1442: x_msg_count => x_msg_count,
1443: x_msg_data => x_msg_data
1444: );
1445: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1446: RAISE FND_API.G_EXC_ERROR;
1447: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1448: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1449: END IF;
1450: END IF;

Line 1447: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1443: x_msg_data => x_msg_data
1444: );
1445: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1446: RAISE FND_API.G_EXC_ERROR;
1447: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1448: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1449: END IF;
1450: END IF;
1451:

Line 1448: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1444: );
1445: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1446: RAISE FND_API.G_EXC_ERROR;
1447: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1448: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1449: END IF;
1450: END IF;
1451:
1452: IF (p_control_rec.COPY_TASK_FLAG = 'Y') AND (l_copy_task_flag = 'Y') THEN

Line 1455: p_init_msg_list => FND_API.G_FALSE,

1451:
1452: IF (p_control_rec.COPY_TASK_FLAG = 'Y') AND (l_copy_task_flag = 'Y') THEN
1453: ASO_TASK_INT.Copy_Opp_Tasks_To_Qte(
1454: p_api_version => 1.0,
1455: p_init_msg_list => FND_API.G_FALSE,
1456: p_commit => FND_API.G_FALSE,
1457: p_old_object_id => P_OPP_QTE_IN_REC.OPPORTUNITY_ID,
1458: p_new_object_id => lx_qte_header_rec.quote_header_id,
1459: p_old_object_type_code => 'OPPORTUNITY',

Line 1456: p_commit => FND_API.G_FALSE,

1452: IF (p_control_rec.COPY_TASK_FLAG = 'Y') AND (l_copy_task_flag = 'Y') THEN
1453: ASO_TASK_INT.Copy_Opp_Tasks_To_Qte(
1454: p_api_version => 1.0,
1455: p_init_msg_list => FND_API.G_FALSE,
1456: p_commit => FND_API.G_FALSE,
1457: p_old_object_id => P_OPP_QTE_IN_REC.OPPORTUNITY_ID,
1458: p_new_object_id => lx_qte_header_rec.quote_header_id,
1459: p_old_object_type_code => 'OPPORTUNITY',
1460: p_new_object_type_code => 'ASO_QUOTE',

Line 1466: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1462: x_return_status => x_return_status,
1463: x_msg_count => x_msg_count,
1464: x_msg_data => x_msg_data
1465: );
1466: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1467: RAISE FND_API.G_EXC_ERROR;
1468: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1469: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1470: END IF;

Line 1467: RAISE FND_API.G_EXC_ERROR;

1463: x_msg_count => x_msg_count,
1464: x_msg_data => x_msg_data
1465: );
1466: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1467: RAISE FND_API.G_EXC_ERROR;
1468: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1469: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1470: END IF;
1471: END IF;

Line 1468: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1464: x_msg_data => x_msg_data
1465: );
1466: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1467: RAISE FND_API.G_EXC_ERROR;
1468: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1469: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1470: END IF;
1471: END IF;
1472:

Line 1469: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1465: );
1466: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1467: RAISE FND_API.G_EXC_ERROR;
1468: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1469: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1470: END IF;
1471: END IF;
1472:
1473: IF (p_control_rec.COPY_ATT_FLAG = 'Y') AND (l_copy_att_flag = 'Y') THEN

Line 1476: p_init_msg_list => FND_API.G_FALSE,

1472:
1473: IF (p_control_rec.COPY_ATT_FLAG = 'Y') AND (l_copy_att_flag = 'Y') THEN
1474: ASO_ATTACHMENT_INT.Copy_Attachments(
1475: p_api_version => l_api_version,
1476: p_init_msg_list => FND_API.G_FALSE,
1477: p_commit => FND_API.G_FALSE,
1478: p_old_object_code => 'AS_OPPORTUNITY_ATTCH',
1479: p_new_object_code => 'ASO_QUOTE_HEADERS_ALL',
1480: p_old_object_id => P_OPP_QTE_IN_REC.OPPORTUNITY_ID,

Line 1477: p_commit => FND_API.G_FALSE,

1473: IF (p_control_rec.COPY_ATT_FLAG = 'Y') AND (l_copy_att_flag = 'Y') THEN
1474: ASO_ATTACHMENT_INT.Copy_Attachments(
1475: p_api_version => l_api_version,
1476: p_init_msg_list => FND_API.G_FALSE,
1477: p_commit => FND_API.G_FALSE,
1478: p_old_object_code => 'AS_OPPORTUNITY_ATTCH',
1479: p_new_object_code => 'ASO_QUOTE_HEADERS_ALL',
1480: p_old_object_id => P_OPP_QTE_IN_REC.OPPORTUNITY_ID,
1481: p_new_object_id => lx_qte_header_rec.quote_header_id,

Line 1486: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1482: x_return_status => x_return_status,
1483: x_msg_count => x_msg_count,
1484: x_msg_data => x_msg_data
1485: );
1486: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1487: RAISE FND_API.G_EXC_ERROR;
1488: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1489: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1490: END IF;

Line 1487: RAISE FND_API.G_EXC_ERROR;

1483: x_msg_count => x_msg_count,
1484: x_msg_data => x_msg_data
1485: );
1486: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1487: RAISE FND_API.G_EXC_ERROR;
1488: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1489: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1490: END IF;
1491: END IF;

Line 1488: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1484: x_msg_data => x_msg_data
1485: );
1486: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1487: RAISE FND_API.G_EXC_ERROR;
1488: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1489: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1490: END IF;
1491: END IF;
1492:

Line 1489: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1485: );
1486: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1487: RAISE FND_API.G_EXC_ERROR;
1488: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1489: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1490: END IF;
1491: END IF;
1492:
1493: END LOOP;

Line 1510: IF FND_API.To_Boolean(p_commit) 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
1511: COMMIT WORK;
1512: END IF;
1513:
1514: -- Standard call to get message count and if count is 1, get message info.

Line 1516: p_encoded => FND_API.G_FALSE,

1512: END IF;
1513:
1514: -- Standard call to get message count and if count is 1, get message info.
1515: FND_Msg_Pub.Count_And_Get(
1516: p_encoded => FND_API.G_FALSE,
1517: p_count => x_msg_count ,
1518: p_data => x_msg_data
1519: );
1520:

Line 1522: WHEN FND_API.G_EXC_ERROR THEN

1518: p_data => x_msg_data
1519: );
1520:
1521: EXCEPTION
1522: WHEN FND_API.G_EXC_ERROR THEN
1523: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1524: P_API_NAME => L_API_NAME,
1525: P_PKG_NAME => G_PKG_NAME,
1526: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,

Line 1535: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1531: X_MSG_DATA => X_MSG_DATA,
1532: X_RETURN_STATUS => X_RETURN_STATUS
1533: );
1534:
1535: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1536: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1537: P_API_NAME => L_API_NAME,
1538: P_PKG_NAME => G_PKG_NAME,
1539: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,

Line 1658: ELSIF p_uom_code IS NOT NULL AND p_uom_code <> FND_API.G_MISS_CHAR THEN

1654: l_orderable_flag := 'Y';
1655: IF p_uom_code IS NULL THEN
1656: l_uom_code := orderable_items_rec.primary_uom_code;
1657:
1658: ELSIF p_uom_code IS NOT NULL AND p_uom_code <> FND_API.G_MISS_CHAR THEN
1659: l_uom_code := p_uom_code;
1660:
1661: END IF;
1662:

Line 1686: FND_API.G_MISS_NUM,

1682: p_inventory_item_id,
1683: p_organization_id,
1684: SYSDATE,
1685: 'APPLET',
1686: FND_API.G_MISS_NUM,
1687: FND_PROFILE.Value('RESP_ID'),
1688: FND_PROFILE.Value('RESP_APPL_ID')
1689: );
1690:

Line 1721: IF l_return_status <> FND_API.G_RET_STS_SUCCESS OR p_quantity <= 0 THEN

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

Line 1852: p_init_msg_list => FND_API.G_FALSE,

1848: END IF;
1849:
1850: IF c_loc_assign%NOTFOUND THEN
1851: HZ_TAX_ASSIGNMENT_V2PUB.create_loc_assignment(
1852: p_init_msg_list => FND_API.G_FALSE,
1853: p_location_id => l_location_id,
1854: p_lock_flag => FND_API.G_FALSE,
1855: p_created_by_module => 'ASO_CUSTOMER_DATA',
1856: p_application_id => FND_API.G_MISS_NUM,

Line 1854: p_lock_flag => FND_API.G_FALSE,

1850: IF c_loc_assign%NOTFOUND THEN
1851: HZ_TAX_ASSIGNMENT_V2PUB.create_loc_assignment(
1852: p_init_msg_list => FND_API.G_FALSE,
1853: p_location_id => l_location_id,
1854: p_lock_flag => FND_API.G_FALSE,
1855: p_created_by_module => 'ASO_CUSTOMER_DATA',
1856: p_application_id => FND_API.G_MISS_NUM,
1857: X_RETURN_STATUS => X_RETURN_STATUS,
1858: X_MSG_COUNT => X_MSG_COUNT,

Line 1856: p_application_id => FND_API.G_MISS_NUM,

1852: p_init_msg_list => FND_API.G_FALSE,
1853: p_location_id => l_location_id,
1854: p_lock_flag => FND_API.G_FALSE,
1855: p_created_by_module => 'ASO_CUSTOMER_DATA',
1856: p_application_id => FND_API.G_MISS_NUM,
1857: X_RETURN_STATUS => X_RETURN_STATUS,
1858: X_MSG_COUNT => X_MSG_COUNT,
1859: X_MSG_DATA => X_MSG_DATA,
1860: x_loc_id => lx_loc_id

Line 1868: IF x_return_status <> FND_API.G_RET_STS_SUCCESS 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';
1870: FND_Msg_Pub.initialize;
1871: END IF;
1872: END IF;