[Home] [Help]
1337: lx_Related_Obj_Tbl ASO_Quote_Pub.RELATED_OBJ_Tbl_Type;
1338: l_debug VARCHAR2(1);
1339: BEGIN
1340:
1341: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;
1342: IF l_debug = 'Y' THEN
1343: ASO_QUOTE_UTIL_PVT.Enable_Debug_Pvt;
1344: END IF;
1345: ASO_QUOTE_UTIL_PVT.Set_Control_Rec_W(
1339: BEGIN
1340:
1341: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;
1342: IF l_debug = 'Y' THEN
1343: ASO_QUOTE_UTIL_PVT.Enable_Debug_Pvt;
1344: END IF;
1345: ASO_QUOTE_UTIL_PVT.Set_Control_Rec_W(
1346: p_last_update_date => p_c_last_update_date,
1347: p_auto_version_flag => p_c_auto_version_flag,
1341: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;
1342: IF l_debug = 'Y' THEN
1343: ASO_QUOTE_UTIL_PVT.Enable_Debug_Pvt;
1344: END IF;
1345: ASO_QUOTE_UTIL_PVT.Set_Control_Rec_W(
1346: p_last_update_date => p_c_last_update_date,
1347: p_auto_version_flag => p_c_auto_version_flag,
1348: p_pricing_request_type => p_c_pricing_request_type,
1349: p_header_pricing_event => p_c_header_pricing_event,
1361: p_defaulting_fwk_flag => p_c_defaulting_fwk_flag,
1362: p_application_type_code => p_c_application_type_code,
1363: x_control_rec => l_control_rec);
1364:
1365: l_qte_header_rec := ASO_QUOTE_UTIL_PVT.Construct_Qte_Header_Rec(
1366: p_quote_header_id => p_q_quote_header_id ,
1367: p_creation_date => p_q_creation_date ,
1368: p_created_by => p_q_created_by ,
1369: p_last_updated_by => p_q_last_updated_by ,
1502: p_object_version_number => p_q_object_version_number,
1503: p_header_paynow_charges => p_q_header_paynow_charges
1504: );
1505:
1506: l_qte_line_tbl := ASO_QUOTE_UTIL_PVT.Construct_Qte_Line_Tbl(
1507: p_creation_date => p_ql_creation_date ,
1508: p_created_by => p_ql_created_by ,
1509: p_last_updated_by => p_ql_last_updated_by ,
1510: p_last_update_date => p_ql_last_update_date ,
1593: p_line_paynow_subtotal => p_ql_line_paynow_subtotal,
1594: p_config_model_type => p_ql_config_model_type
1595: );
1596:
1597: l_qte_line_dtl_tbl := ASO_QUOTE_UTIL_PVT.Construct_Qte_Line_Dtl_Tbl(
1598: p_quote_line_detail_id => p_qdl_quote_line_detail_id ,
1599: p_creation_date => p_qdl_creation_date ,
1600: p_created_by => p_qdl_created_by ,
1601: p_last_update_date => p_qdl_last_update_date ,
1679: p_object_version_number => p_qdl_object_version_number
1680:
1681: );
1682:
1683: l_line_rltship_tbl := ASO_QUOTE_UTIL_PVT.Construct_Line_Rltship_Tbl(
1684: p_line_relationship_id => p_qrl_line_relationship_id ,
1685: p_creation_date => p_qrl_creation_date ,
1686: p_created_by => p_qrl_created_by ,
1687: p_last_updated_by => p_qrl_last_updated_by ,
1701: p_object_version_number => p_qrl_object_version_number
1702: );
1703:
1704: -- set header price attribute
1705: l_hd_price_attributes_tbl := ASO_QUOTE_UTIL_PVT.Construct_Price_Attributes_Tbl(
1706: p_operation_code => p_qpa_operation_code ,
1707: p_qte_line_index => p_qpa_qte_line_index ,
1708: p_price_attribute_id => p_qpa_price_attribute_id ,
1709: p_creation_date => p_qpa_creation_date ,
1842: p_attribute20 => p_qpa_attribute20 ,
1843: p_object_version_number => p_qpa_object_version_number);
1844:
1845: -- set header payment tbl
1846: l_hd_payment_tbl := ASO_QUOTE_UTIL_PVT.Construct_Payment_Tbl(
1847: p_operation_code => p_qp_operation_code ,
1848: p_qte_line_index => p_qp_qte_line_index ,
1849: p_payment_id => p_qp_payment_id ,
1850: p_creation_date => p_qp_creation_date ,
1900: p_object_version_number => p_qp_object_version_number);
1901:
1902:
1903: -- set header shipment
1904: l_hd_shipment_rec := ASO_QUOTE_UTIL_PVT.Construct_Shipment_rec(
1905: p_operation_code => p_qs_operation_code ,
1906: p_qte_line_index => p_qs_qte_line_index ,
1907: p_shipment_id => p_qs_shipment_id ,
1908: p_creation_date => p_qs_creation_date ,
1981: );
1982:
1983:
1984: -- set header tax detail
1985: l_hd_tax_detail_tbl := ASO_QUOTE_UTIL_PVT.Construct_Tax_Detail_Tbl(
1986: p_operation_code => p_qt_operation_code ,
1987: p_qte_line_index => p_qt_qte_line_index ,
1988: p_shipment_index => p_qt_shipment_index ,
1989: p_tax_detail_id => p_qt_tax_detail_id ,
2031: p_object_version_number => p_qt_object_version_number ,
2032: p_tax_rate_id => p_qt_tax_rate_id);
2033:
2034: -- set header sales credit
2035: l_hd_sales_credit_tbl := ASO_QUOTE_UTIL_PVT.Construct_Sales_Credit_Tbl(
2036: p_operation_code => p_qsc_operation_code ,
2037: p_qte_line_index => p_qsc_qte_line_index ,
2038: p_sales_credit_id => p_qsc_sales_credit_id ,
2039: p_creation_date => p_qsc_creation_date ,
2081: p_object_version_number => p_qsc_object_version_number);
2082:
2083:
2084: -- set line price attribute
2085: l_ln_price_attributes_tbl := ASO_QUOTE_UTIL_PVT.Construct_Price_Attributes_Tbl(
2086: p_operation_code => p_qlpa_operation_code ,
2087: p_qte_line_index => p_qlpa_qte_line_index ,
2088: p_price_attribute_id => p_qlpa_price_attribute_id ,
2089: p_creation_date => p_qlpa_creation_date ,
2221: p_attribute19 => p_qlpa_attribute19 ,
2222: p_attribute20 => p_qlpa_attribute20 ,
2223: p_object_version_number => p_qlpa_object_version_number);
2224: -- set line payment tbl
2225: l_ln_payment_tbl := ASO_QUOTE_UTIL_PVT.Construct_Payment_Tbl(
2226: p_operation_code => p_qlp_operation_code ,
2227: p_qte_line_index => p_qlp_qte_line_index ,
2228: p_payment_id => p_qlp_payment_id ,
2229: p_creation_date => p_qlp_creation_date ,
2280:
2281:
2282:
2283: -- set line shipment
2284: l_ln_shipment_tbl := ASO_QUOTE_UTIL_PVT.Construct_Shipment_Tbl(
2285: p_operation_code => p_qls_operation_code ,
2286: p_qte_line_index => p_qls_qte_line_index ,
2287: p_shipment_id => p_qls_shipment_id ,
2288: p_creation_date => p_qls_creation_date ,
2360: p_object_version_number => p_qls_object_version_number);
2361:
2362:
2363: -- set line tax detail
2364: l_ln_tax_detail_tbl := ASO_QUOTE_UTIL_PVT.Construct_Tax_Detail_Tbl(
2365: p_operation_code => p_qlt_operation_code ,
2366: p_qte_line_index => p_qlt_qte_line_index ,
2367: p_shipment_index => p_qlt_shipment_index ,
2368: p_tax_detail_id => p_qlt_tax_detail_id ,
2411: p_tax_rate_id => p_qlt_tax_rate_id
2412: );
2413:
2414: -- set price adjustment tbl
2415: l_price_adjustment_tbl := ASO_QUOTE_UTIL_PVT.Construct_Price_Adj_Tbl(
2416: p_operation_code => p_qlpaj_operation_code ,
2417: p_qte_line_index => p_qlpaj_qte_line_index ,
2418: p_price_adjustment_id => p_qlpaj_price_adjustment_id ,
2419: p_creation_date => p_qlpaj_creation_date ,
2506: p_object_version_number => p_qlpaj_object_version_number);
2507:
2508:
2509: -- set line sales credit
2510: l_ln_sales_credit_tbl := ASO_QUOTE_UTIL_PVT.Construct_Sales_Credit_Tbl(
2511: p_operation_code => p_qlsc_operation_code ,
2512: p_qte_line_index => p_qlsc_qte_line_index ,
2513: p_sales_credit_id => p_qlsc_sales_credit_id ,
2514: p_creation_date => p_qlsc_creation_date ,
2556: p_object_version_number => p_qsc_object_version_number);
2557:
2558: --set quote access tbl
2559:
2560: l_qte_access_tbl := ASO_QUOTE_UTIL_PVT.CONSTRUCT_Qte_Access_Tbl(
2561: p_access_id => p_qac_access_id,
2562: p_quote_number => p_qac_quote_number,
2563: p_resource_id => p_qac_resource_id,
2564: p_resource_grp_id => p_qac_resource_grp_id,
2601: p_batch_price_flag => p_qac_batch_price_flag ,
2602: p_object_version_number => p_qac_object_version_number ,
2603: p_operation_code => p_qac_operation_code);
2604:
2605: l_template_tbl := ASO_QUOTE_UTIL_PVT.Construct_Template_Tbl (
2606: p_template_id => p_qtmpl_template_id);
2607:
2608:
2609: l_related_obj_tbl :=
2606: p_template_id => p_qtmpl_template_id);
2607:
2608:
2609: l_related_obj_tbl :=
2610: ASO_QUOTE_UTIL_PVT.Construct_Related_Obj_Tbl(
2611: p_operation_code => p_qrobj_operation_code,
2612: p_RELATED_OBJECT_ID => p_qrobj_RELATED_OBJECT_ID ,
2613: p_CREATION_DATE => p_qrobj_CREATION_DATE ,
2614: p_CREATED_BY => p_qrobj_CREATED_BY ,
2631:
2632:
2633: -- Call ASO API
2634: IF l_debug = 'Y' THEN
2635: ASO_QUOTE_UTIL_PVT.Debug('Begin calling ASO_QUOTE_PUB.Create_Quote');
2636: END IF;
2637: ASO_QUOTE_PUB.Create_Quote(
2638: P_Api_Version_Number => p_api_version_number ,
2639: P_Init_Msg_List => p_init_msg_list ,
2688: X_Msg_Count => x_msg_count ,
2689: X_Msg_Data => x_msg_data);
2690:
2691: IF l_debug = 'Y' THEN
2692: ASO_QUOTE_UTIL_PVT.Debug('Returning from ASO_QUOTE_PUB.Create_Quote');
2693: END IF;
2694:
2695: x_q_quote_header_id := rosetta_g_miss_num_map(lx_qte_header_rec.quote_header_id);
2696: x_q_last_update_date := lx_qte_header_rec.last_update_date;
2800: x_q_invoice_to_county := lx_qte_header_rec.invoice_to_county;
2801: x_q_resource_id := rosetta_g_miss_num_map(lx_qte_header_rec.resource_id);
2802: */
2803:
2804: ASO_QUOTE_UTIL_PVT.Set_Qte_Line_Tbl_Out(
2805: p_qte_line_tbl => lx_qte_line_tbl ,
2806: x_quote_line_id => x_ql_quote_line_id
2807:
2808: /*-- The following output parameters are ignored
2879: x_section_id => x_ql_section_id
2880: --*/
2881: );
2882:
2883: ASO_QUOTE_UTIL_PVT.Set_Line_Rltship_Tbl_Out(
2884: p_qte_line_rltship_tbl => lx_line_rltship_tbl ,
2885: x_line_relationship_id => x_qrl_line_relationship_id
2886:
2887: /*-- The following output parameters are ignored
2903: x_operation_code => x_qrl_operation_code
2904: --*/
2905: );
2906:
2907: ASO_QUOTE_UTIL_PVT.Set_Qte_Line_Dtl_Tbl_Out(
2908: p_qte_line_dtl_tbl => lx_qte_line_dtl_tbl ,
2909: x_quote_line_detail_id => x_qdl_quote_line_detail_id
2910:
2911: /*-- The following output parameters are ignored
2986: x_change_reason_code => x_qdl_change_reason_code
2987: --*/
2988: );
2989:
2990: ASO_QUOTE_UTIL_PVT.Set_Price_Attributes_Tbl_Out(
2991: p_qte_price_attributes_tbl => lx_hd_price_attributes_tbl,
2992: x_price_attribute_id => x_qpa_price_attribute_id
2993:
2994: /*-- The following output parameters are ignored
3130: x_attribute20 => x_qpa_attribute20
3131: --*/
3132: );
3133:
3134: ASO_QUOTE_UTIL_PVT.Set_Payment_Tbl_Out(
3135: p_qte_payment_tbl => lx_hd_payment_tbl ,
3136: x_payment_id => x_qp_payment_id
3137:
3138: /*-- The following output parameters are ignored
3261: x_qs_shipment_priority_code := lx_hd_shipment_rec.shipment_priority_code;
3262: x_qs_ship_from_org_id := rosetta_g_miss_num_map(lx_hd_shipment_rec.ship_from_org_id);
3263: --*/
3264:
3265: ASO_QUOTE_UTIL_PVT.Set_Tax_Detail_Tbl_Out(
3266: p_qte_tax_detail_tbl => lx_hd_tax_detail_tbl ,
3267: x_tax_detail_id => x_qt_tax_detail_id
3268:
3269: /*-- The following output parameters are ignored
3308: x_attribute15 => x_qt_attribute15
3309: --*/
3310: );
3311:
3312: ASO_QUOTE_UTIL_PVT.Set_Sales_Credit_Tbl_Out(
3313: p_qte_sales_credit_tbl => lx_hd_sales_credit_tbl ,
3314: x_sales_credit_id => x_qsc_sales_credit_id
3315:
3316: /*-- The following output parameters are ignored
3353: x_attribute15 => x_qsc_attribute15
3354: --*/
3355: );
3356:
3357: ASO_QUOTE_UTIL_PVT.Set_Price_Attributes_Tbl_Out(
3358: p_qte_price_attributes_tbl => lx_ln_price_attributes_tbl ,
3359: x_price_attribute_id => x_qlpa_price_attribute_id
3360:
3361: /*-- The following output parameters are ignored
3492: x_attribute15 => x_qlpa_attribute15
3493: --*/
3494: );
3495:
3496: ASO_QUOTE_UTIL_PVT.Set_Payment_Tbl_Out(
3497: p_qte_payment_tbl => lx_ln_payment_tbl ,
3498: x_payment_id => x_qlp_payment_id
3499:
3500: /*-- The following output parameters are ignored
3542: x_cust_po_number => x_qlp_cust_po_number
3543: --*/
3544: );
3545:
3546: ASO_QUOTE_UTIL_PVT.Set_Shipment_Tbl_Out(
3547: p_qte_shipment_tbl => lx_ln_shipment_tbl ,
3548: x_shipment_id => x_qls_shipment_id
3549:
3550: /*-- The following output parameters are ignored
3616: x_ship_from_org_id => x_qls_ship_from_org_id
3617: --*/
3618: );
3619:
3620: ASO_QUOTE_UTIL_PVT.Set_Tax_Detail_Tbl_Out(
3621: p_qte_tax_detail_tbl => lx_ln_tax_detail_tbl ,
3622: x_tax_detail_id => x_qlt_tax_detail_id
3623:
3624: /*-- The following output parameters are ignored
3663: x_attribute15 => x_qlt_attribute15
3664: --*/
3665: );
3666:
3667: ASO_QUOTE_UTIL_PVT.Set_Price_Adj_Tbl_Out(
3668: p_qte_price_adj_tbl => lx_price_adjustment_tbl ,
3669: x_price_adjustment_id => x_qlpaj_price_adjustment_id
3670:
3671: /*-- The following output parameters are ignored
3755: x_quote_shipment_id => x_qlpaj_quote_shipment_id
3756: --*/
3757: );
3758:
3759: ASO_QUOTE_UTIL_PVT.Set_Sales_Credit_Tbl_Out(
3760: p_qte_sales_credit_tbl => lx_ln_sales_credit_tbl ,
3761: x_sales_credit_id => x_qlsc_sales_credit_id
3762:
3763: /*-- The following output parameters are ignored
3800: x_attribute15 => x_qlsc_attribute15
3801: --*/
3802: );
3803:
3804: ASO_QUOTE_UTIL_PVT.Set_Qte_Access_Tbl_Out(
3805: p_qte_access_tbl => lx_qte_access_tbl,
3806: x_access_id => x_qac_access_id );
3807:
3808:
3805: p_qte_access_tbl => lx_qte_access_tbl,
3806: x_access_id => x_qac_access_id );
3807:
3808:
3809: ASO_QUOTE_UTIL_PVT.Set_Template_Tbl_Out(
3810: p_template_tbl => lx_template_tbl,
3811: x_template_id => x_qtmpl_template_id );
3812:
3813: ASO_QUOTE_UTIL_PVT.Set_Related_Obj_Tbl_Out(
3809: ASO_QUOTE_UTIL_PVT.Set_Template_Tbl_Out(
3810: p_template_tbl => lx_template_tbl,
3811: x_template_id => x_qtmpl_template_id );
3812:
3813: ASO_QUOTE_UTIL_PVT.Set_Related_Obj_Tbl_Out(
3814: p_rel_obj_tbl => l_related_obj_tbl,
3815: x_related_object_id => x_qrobj_related_object_id
3816: );
3817:
3816: );
3817:
3818:
3819: IF l_debug = 'Y' THEN
3820: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
3821: END IF;
3822:
3823: END Create_Quote;
3824:
3984: lx_order_header_rec ASO_Quote_Pub.Order_Header_Rec_Type;
3985: l_debug VARCHAR2(1);
3986: BEGIN
3987:
3988: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;
3989: IF l_debug = 'Y' THEN
3990: ASO_QUOTE_UTIL_PVT.Enable_Debug_Pvt;
3991: END IF;
3992: ASO_QUOTE_UTIL_PVT.Set_Submit_Control_Rec_w(
3986: BEGIN
3987:
3988: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;
3989: IF l_debug = 'Y' THEN
3990: ASO_QUOTE_UTIL_PVT.Enable_Debug_Pvt;
3991: END IF;
3992: ASO_QUOTE_UTIL_PVT.Set_Submit_Control_Rec_w(
3993: p_book_flag => p_sc_book_flag ,
3994: p_reserve_flag => p_sc_reserve_flag ,
3988: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;
3989: IF l_debug = 'Y' THEN
3990: ASO_QUOTE_UTIL_PVT.Enable_Debug_Pvt;
3991: END IF;
3992: ASO_QUOTE_UTIL_PVT.Set_Submit_Control_Rec_w(
3993: p_book_flag => p_sc_book_flag ,
3994: p_reserve_flag => p_sc_reserve_flag ,
3995: p_calculate_price => p_sc_calculate_price,
3996: p_server_id => p_sc_server_id ,
3995: p_calculate_price => p_sc_calculate_price,
3996: p_server_id => p_sc_server_id ,
3997: x_submit_control_rec => lp_submit_control_rec);
3998:
3999: l_qte_header_rec := ASO_QUOTE_UTIL_PVT.Construct_Qte_Header_Rec(
4000: p_quote_header_id => p_q_quote_header_id ,
4001: p_creation_date => p_q_creation_date ,
4002: p_created_by => p_q_created_by ,
4003: p_last_updated_by => p_q_last_updated_by ,
4138:
4139:
4140: -- Call ASO API
4141: IF l_debug = 'Y'
4142: THEN ASO_QUOTE_UTIL_PVT.Debug('Begin calling ASO_Quote_Pub.Submit_Quote');
4143: END IF;
4144: ASO_Quote_Pub.Submit_Quote(
4145: p_api_version_number => p_api_version_number,
4146: p_init_msg_list => p_init_msg_list,
4150: x_return_status => x_return_status,
4151: x_msg_count => x_msg_count,
4152: x_msg_data => x_msg_data);
4153: IF l_debug = 'Y'
4154: THEN ASO_QUOTE_UTIL_PVT.Debug('Returning from ASO_Quote_Pub.Submit_Quote');
4155: END IF;
4156:
4157: ASO_QUOTE_UTIL_PVT.Set_Order_Header_Rec_Out(
4158: p_order_header_rec => lx_order_header_rec,
4153: IF l_debug = 'Y'
4154: THEN ASO_QUOTE_UTIL_PVT.Debug('Returning from ASO_Quote_Pub.Submit_Quote');
4155: END IF;
4156:
4157: ASO_QUOTE_UTIL_PVT.Set_Order_Header_Rec_Out(
4158: p_order_header_rec => lx_order_header_rec,
4159: x_order_number => x_order_number ,
4160: x_order_header_id => x_order_header_id ,
4161: x_order_request_id => x_order_request_id ,
4162: x_contract_id => x_contract_id ,
4163: x_status => x_status);
4164:
4165: IF l_debug = 'Y' THEN
4166: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
4167: END IF;
4168: END Submit_Quote;
4169:
4170: PROCEDURE Update_Quote(
5483: lx_Related_Obj_Tbl ASO_Quote_Pub.RELATED_OBJ_Tbl_Type;
5484: l_debug VARCHAR2(1);
5485: BEGIN
5486:
5487: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;
5488: IF l_debug = 'Y' THEN
5489: ASO_QUOTE_UTIL_PVT.Enable_Debug_Pvt;
5490: END IF;
5491: ASO_QUOTE_UTIL_PVT.Set_Control_Rec_W(
5485: BEGIN
5486:
5487: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;
5488: IF l_debug = 'Y' THEN
5489: ASO_QUOTE_UTIL_PVT.Enable_Debug_Pvt;
5490: END IF;
5491: ASO_QUOTE_UTIL_PVT.Set_Control_Rec_W(
5492: p_last_update_date => p_c_last_update_date,
5493: p_auto_version_flag => p_c_auto_version_flag,
5487: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;
5488: IF l_debug = 'Y' THEN
5489: ASO_QUOTE_UTIL_PVT.Enable_Debug_Pvt;
5490: END IF;
5491: ASO_QUOTE_UTIL_PVT.Set_Control_Rec_W(
5492: p_last_update_date => p_c_last_update_date,
5493: p_auto_version_flag => p_c_auto_version_flag,
5494: p_pricing_request_type => p_c_pricing_request_type,
5495: p_header_pricing_event => p_c_header_pricing_event,
5507: p_defaulting_fwk_flag => p_c_defaulting_fwk_flag,
5508: p_application_type_code => p_c_application_type_code,
5509: x_control_rec => l_control_rec);
5510:
5511: l_qte_header_rec := ASO_QUOTE_UTIL_PVT.Construct_Qte_Header_Rec(
5512: p_quote_header_id => p_q_quote_header_id ,
5513: p_creation_date => p_q_creation_date ,
5514: p_created_by => p_q_created_by ,
5515: p_last_updated_by => p_q_last_updated_by ,
5648: p_object_version_number => p_q_object_version_number,
5649: p_header_paynow_charges => p_q_header_paynow_charges
5650: );
5651:
5652: l_qte_line_tbl := ASO_QUOTE_UTIL_PVT.Construct_Qte_Line_Tbl(
5653: p_creation_date => p_ql_creation_date ,
5654: p_created_by => p_ql_created_by ,
5655: p_last_updated_by => p_ql_last_updated_by ,
5656: p_last_update_date => p_ql_last_update_date ,
5739: p_line_paynow_subtotal => p_ql_line_paynow_subtotal,
5740: p_config_model_type => p_ql_config_model_type
5741: );
5742:
5743: l_qte_line_dtl_tbl := ASO_QUOTE_UTIL_PVT.Construct_Qte_Line_Dtl_Tbl(
5744: p_quote_line_detail_id => p_qdl_quote_line_detail_id ,
5745: p_creation_date => p_qdl_creation_date ,
5746: p_created_by => p_qdl_created_by ,
5747: p_last_update_date => p_qdl_last_update_date ,
5824: p_component_sequence_id => p_qdl_component_sequence_id ,
5825: p_object_version_number => p_qdl_object_version_number
5826: );
5827:
5828: l_line_rltship_tbl := ASO_QUOTE_UTIL_PVT.Construct_Line_Rltship_Tbl(
5829: p_line_relationship_id => p_qrl_line_relationship_id ,
5830: p_creation_date => p_qrl_creation_date ,
5831: p_created_by => p_qrl_created_by ,
5832: p_last_updated_by => p_qrl_last_updated_by ,
5845: p_operation_code => p_qrl_operation_code ,
5846: p_object_version_number => p_qrl_object_version_number);
5847:
5848: -- set header price attribute
5849: l_hd_price_attributes_tbl := ASO_QUOTE_UTIL_PVT.Construct_Price_Attributes_Tbl(
5850: p_operation_code => p_qpa_operation_code ,
5851: p_qte_line_index => p_qpa_qte_line_index ,
5852: p_price_attribute_id => p_qpa_price_attribute_id ,
5853: p_creation_date => p_qpa_creation_date ,
5986: p_attribute20 => p_qpa_attribute20 ,
5987: p_object_version_number => p_qpa_object_version_number);
5988:
5989: -- set header payment tbl
5990: l_hd_payment_tbl := ASO_QUOTE_UTIL_PVT.Construct_Payment_Tbl(
5991: p_operation_code => p_qp_operation_code ,
5992: p_qte_line_index => p_qp_qte_line_index ,
5993: p_payment_id => p_qp_payment_id ,
5994: p_creation_date => p_qp_creation_date ,
6044: p_object_version_number => p_qp_object_version_number);
6045:
6046:
6047: -- set header shipment
6048: l_hd_shipment_tbl := ASO_QUOTE_UTIL_PVT.Construct_Shipment_Tbl(
6049: p_operation_code => p_qs_operation_code ,
6050: p_qte_line_index => p_qs_qte_line_index ,
6051: p_shipment_id => p_qs_shipment_id ,
6052: p_creation_date => p_qs_creation_date ,
6124: p_object_version_number => p_qs_object_version_number);
6125:
6126:
6127: -- set header tax detail
6128: l_hd_tax_detail_tbl := ASO_QUOTE_UTIL_PVT.Construct_Tax_Detail_Tbl(
6129: p_operation_code => p_qt_operation_code ,
6130: p_qte_line_index => p_qt_qte_line_index ,
6131: p_shipment_index => p_qt_shipment_index ,
6132: p_tax_detail_id => p_qt_tax_detail_id ,
6175: p_tax_rate_id => p_qt_tax_rate_id);
6176:
6177:
6178: -- set header sales credit
6179: l_hd_sales_credit_tbl := ASO_QUOTE_UTIL_PVT.Construct_Sales_Credit_Tbl(
6180: p_operation_code => p_qsc_operation_code ,
6181: p_qte_line_index => p_qsc_qte_line_index ,
6182: p_sales_credit_id => p_qsc_sales_credit_id ,
6183: p_creation_date => p_qsc_creation_date ,
6225: p_object_version_number => p_qsc_object_version_number);
6226:
6227:
6228: -- set line price attribute
6229: l_ln_price_attributes_tbl := ASO_QUOTE_UTIL_PVT.Construct_Price_Attributes_Tbl(
6230: p_operation_code => p_qlpa_operation_code ,
6231: p_qte_line_index => p_qlpa_qte_line_index ,
6232: p_price_attribute_id => p_qlpa_price_attribute_id ,
6233: p_creation_date => p_qlpa_creation_date ,
6367: p_object_version_number => p_qlpa_object_version_number);
6368:
6369:
6370: -- set line payment tbl
6371: l_ln_payment_tbl := ASO_QUOTE_UTIL_PVT.Construct_Payment_Tbl(
6372: p_operation_code => p_qlp_operation_code ,
6373: p_qte_line_index => p_qlp_qte_line_index ,
6374: p_payment_id => p_qlp_payment_id ,
6375: p_creation_date => p_qlp_creation_date ,
6425: p_object_version_number => p_qlp_object_version_number);
6426:
6427:
6428: -- set line shipment
6429: l_ln_shipment_tbl := ASO_QUOTE_UTIL_PVT.Construct_Shipment_Tbl(
6430: p_operation_code => p_qls_operation_code ,
6431: p_qte_line_index => p_qls_qte_line_index ,
6432: p_shipment_id => p_qls_shipment_id ,
6433: p_creation_date => p_qls_creation_date ,
6505: p_object_version_number => p_qls_object_version_number);
6506:
6507:
6508: -- set line tax detail
6509: l_ln_tax_detail_tbl := ASO_QUOTE_UTIL_PVT.Construct_Tax_Detail_Tbl(
6510: p_operation_code => p_qlt_operation_code ,
6511: p_qte_line_index => p_qlt_qte_line_index ,
6512: p_shipment_index => p_qlt_shipment_index ,
6513: p_tax_detail_id => p_qlt_tax_detail_id ,
6556: p_tax_rate_id => p_qlt_tax_rate_id);
6557:
6558:
6559: -- set price adjustment tbl
6560: l_price_adjustment_tbl := ASO_QUOTE_UTIL_PVT.CONSTRUCT_Price_Adj_Tbl(
6561: p_operation_code => p_qlpaj_operation_code ,
6562: p_qte_line_index => p_qlpaj_qte_line_index ,
6563: p_price_adjustment_id => p_qlpaj_price_adjustment_id ,
6564: p_creation_date => p_qlpaj_creation_date ,
6651: p_object_version_number => p_qlpaj_object_version_number);
6652:
6653:
6654: -- set line sales credit
6655: l_ln_sales_credit_tbl := ASO_QUOTE_UTIL_PVT.CONSTRUCT_Sales_Credit_Tbl(
6656: p_operation_code => p_qlsc_operation_code ,
6657: p_qte_line_index => p_qlsc_qte_line_index ,
6658: p_sales_credit_id => p_qlsc_sales_credit_id ,
6659: p_creation_date => p_qlsc_creation_date ,
6701: p_object_version_number => p_qsc_object_version_number);
6702:
6703: --set quote access tbl
6704:
6705: l_qte_access_tbl := ASO_QUOTE_UTIL_PVT.CONSTRUCT_Qte_Access_Tbl(
6706: p_access_id => p_qac_access_id,
6707: p_quote_number => p_qac_quote_number,
6708: p_resource_id => p_qac_resource_id,
6709: p_resource_grp_id => p_qac_resource_grp_id,
6746: p_batch_price_flag => p_qac_batch_price_flag ,
6747: p_object_version_number => p_qac_object_version_number ,
6748: p_operation_code => p_qac_operation_code);
6749:
6750: l_template_tbl := ASO_QUOTE_UTIL_PVT.Construct_Template_Tbl (
6751: p_template_id => p_qtmpl_template_id);
6752:
6753: l_Related_Obj_Tbl :=
6754: ASO_QUOTE_UTIL_PVT.Construct_Related_Obj_Tbl(
6750: l_template_tbl := ASO_QUOTE_UTIL_PVT.Construct_Template_Tbl (
6751: p_template_id => p_qtmpl_template_id);
6752:
6753: l_Related_Obj_Tbl :=
6754: ASO_QUOTE_UTIL_PVT.Construct_Related_Obj_Tbl(
6755: p_operation_code => p_qrobj_operation_code,
6756: p_RELATED_OBJECT_ID => p_qrobj_RELATED_OBJECT_ID ,
6757: p_CREATION_DATE => p_qrobj_CREATION_DATE ,
6758: p_CREATED_BY => p_qrobj_CREATED_BY ,
6774: );
6775:
6776: -- Call ASO API
6777: IF l_debug = 'Y' THEN
6778: ASO_QUOTE_UTIL_PVT.Debug('Begin calling ASO_QUOTE_PUB.Update_Quote');
6779: END IF;
6780: ASO_QUOTE_PUB.Update_Quote(
6781: P_Api_Version_Number => p_api_version_number ,
6782: P_Init_Msg_List => p_init_msg_list ,
6830: X_Return_Status => x_return_status ,
6831: X_Msg_Count => x_msg_count ,
6832: X_Msg_Data => x_msg_data);
6833: IF l_debug = 'Y' THEN
6834: ASO_QUOTE_UTIL_PVT.Debug('Returning from ASO_QUOTE_PUB.Update_Quote');
6835: END IF;
6836:
6837: x_q_quote_header_id := rosetta_g_miss_num_map(lx_qte_header_rec.quote_header_id);
6838: x_q_last_update_date := lx_qte_header_rec.last_update_date;
6937: x_q_invoice_to_county := lx_qte_header_rec.invoice_to_county;
6938: x_q_resource_id := rosetta_g_miss_num_map(lx_qte_header_rec.resource_id);
6939: --*/
6940:
6941: ASO_QUOTE_UTIL_PVT.Set_Qte_Line_Tbl_Out(
6942: p_qte_line_tbl => lx_qte_line_tbl ,
6943: x_quote_line_id => x_ql_quote_line_id
6944:
6945: /*-- The following output parameters are ignored
7011: x_section_id => x_ql_section_id
7012: --*/
7013: );
7014:
7015: ASO_QUOTE_UTIL_PVT.Set_Line_Rltship_Tbl_Out(
7016: p_qte_line_rltship_tbl => lx_line_rltship_tbl ,
7017: x_line_relationship_id => x_qrl_line_relationship_id
7018:
7019: /*-- The following output parameters are ignored
7035: x_operation_code => x_qrl_operation_code
7036: --*/
7037: );
7038:
7039: ASO_QUOTE_UTIL_PVT.Set_Qte_Line_Dtl_Tbl_Out(
7040: p_qte_line_dtl_tbl => lx_qte_line_dtl_tbl ,
7041: x_quote_line_detail_id => x_qdl_quote_line_detail_id
7042:
7043: /*-- The following output parameters are ignored
7113: x_change_reason_code => x_qdl_change_reason_code
7114: --*/
7115: );
7116:
7117: ASO_QUOTE_UTIL_PVT.Set_Price_Attributes_Tbl_Out(
7118: p_qte_price_attributes_tbl => lx_hd_price_attributes_tbl,
7119: x_price_attribute_id => x_qpa_price_attribute_id
7120:
7121: /*-- The following output parameters are ignored
7252: x_attribute15 => x_qpa_attribute15
7253: --*/
7254: );
7255:
7256: ASO_QUOTE_UTIL_PVT.Set_Payment_Tbl_Out(
7257: p_qte_payment_tbl => lx_hd_payment_tbl ,
7258: x_payment_id => x_qp_payment_id
7259:
7260: /*-- The following output parameters are ignored
7302: x_cust_po_number => x_qp_cust_po_number
7303: --*/
7304: );
7305:
7306: ASO_QUOTE_UTIL_PVT.Set_Shipment_Tbl_Out(
7307: p_qte_shipment_tbl => lx_hd_shipment_tbl ,
7308: x_shipment_id => x_qs_shipment_id
7309:
7310: /*-- The following output parameters are ignored
7377: --*/
7378: );
7379:
7380:
7381: ASO_QUOTE_UTIL_PVT.Set_Tax_Detail_Tbl_Out(
7382: p_qte_tax_detail_tbl => lx_hd_tax_detail_tbl ,
7383: x_tax_detail_id => x_qt_tax_detail_id
7384:
7385: /*-- The following output parameters are ignored
7424: x_attribute15 => x_qt_attribute15
7425: --*/
7426: );
7427:
7428: ASO_QUOTE_UTIL_PVT.Set_Sales_Credit_Tbl_Out(
7429: p_qte_sales_credit_tbl => lx_hd_sales_credit_tbl ,
7430: x_sales_credit_id => x_qsc_sales_credit_id
7431:
7432: /*-- The following output parameters are ignored
7469: x_attribute15 => x_qsc_attribute15
7470: --*/
7471: );
7472:
7473: ASO_QUOTE_UTIL_PVT.Set_Price_Attributes_Tbl_Out(
7474: p_qte_price_attributes_tbl => lx_ln_price_attributes_tbl ,
7475: x_price_attribute_id => x_qlpa_price_attribute_id
7476:
7477: /*-- The following output parameters are ignored
7608: x_attribute15 => x_qlpa_attribute15
7609: --*/
7610: );
7611:
7612: ASO_QUOTE_UTIL_PVT.Set_Payment_Tbl_Out(
7613: p_qte_payment_tbl => lx_ln_payment_tbl ,
7614: x_payment_id => x_qlp_payment_id
7615:
7616: /*-- The following output parameters are ignored
7658: x_cust_po_number => x_qlp_cust_po_number
7659: --*/
7660: );
7661:
7662: ASO_QUOTE_UTIL_PVT.Set_Shipment_Tbl_Out(
7663: p_qte_shipment_tbl => lx_ln_shipment_tbl ,
7664: x_shipment_id => x_qls_shipment_id
7665:
7666: /*-- The following output parameters are ignored
7732: x_ship_from_org_id => x_qls_ship_from_org_id
7733: --*/
7734: );
7735:
7736: ASO_QUOTE_UTIL_PVT.Set_Tax_Detail_Tbl_Out(
7737: p_qte_tax_detail_tbl => lx_ln_tax_detail_tbl ,
7738: x_tax_detail_id => x_qlt_tax_detail_id
7739:
7740: /*-- The following output parameters are ignored
7779: x_attribute15 => x_qlt_attribute15
7780: --*/
7781: );
7782:
7783: ASO_QUOTE_UTIL_PVT.Set_Price_Adj_Tbl_Out(
7784: p_qte_price_adj_tbl => lx_price_adjustment_tbl ,
7785: x_price_adjustment_id => x_qlpaj_price_adjustment_id
7786:
7787: /*-- The following output parameters are ignored
7871: x_quote_shipment_id => x_qlpaj_quote_shipment_id
7872: --*/
7873: );
7874:
7875: ASO_QUOTE_UTIL_PVT.Set_Sales_Credit_Tbl_Out(
7876: p_qte_sales_credit_tbl => lx_ln_sales_credit_tbl ,
7877: x_sales_credit_id => x_qlsc_sales_credit_id
7878:
7879: /*-- The following output parameters are ignored
7916: x_attribute15 => x_qlsc_attribute15
7917: --*/
7918: );
7919:
7920: ASO_QUOTE_UTIL_PVT.Set_Qte_Access_Tbl_Out(
7921: p_qte_access_tbl => lx_qte_access_tbl,
7922: x_access_id => x_qac_access_id );
7923:
7924:
7921: p_qte_access_tbl => lx_qte_access_tbl,
7922: x_access_id => x_qac_access_id );
7923:
7924:
7925: ASO_QUOTE_UTIL_PVT.Set_Template_Tbl_Out(
7926: p_template_tbl => lx_template_tbl,
7927: x_template_id => x_qtmpl_template_id );
7928:
7929:
7926: p_template_tbl => lx_template_tbl,
7927: x_template_id => x_qtmpl_template_id );
7928:
7929:
7930: ASO_QUOTE_UTIL_PVT.Set_Related_Obj_Tbl_Out(
7931: p_rel_obj_tbl => l_related_obj_tbl,
7932: x_related_object_id => x_qrobj_related_object_id
7933: );
7934:
7933: );
7934:
7935:
7936: IF l_debug = 'Y' THEN
7937: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
7938: END IF;
7939: END Update_Quote;
7940:
7941:
8331: l_debug VARCHAR2(1);
8332:
8333: BEGIN
8334:
8335: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;
8336: IF l_debug = 'Y' THEN
8337: ASO_QUOTE_UTIL_PVT.Enable_Debug_Pvt;
8338: END IF;
8339: ASO_QUOTE_UTIL_PVT.Set_Control_Rec_W(
8333: BEGIN
8334:
8335: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;
8336: IF l_debug = 'Y' THEN
8337: ASO_QUOTE_UTIL_PVT.Enable_Debug_Pvt;
8338: END IF;
8339: ASO_QUOTE_UTIL_PVT.Set_Control_Rec_W(
8340: p_last_update_date => p_c_last_update_date,
8341: p_auto_version_flag => p_c_auto_version_flag,
8335: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;
8336: IF l_debug = 'Y' THEN
8337: ASO_QUOTE_UTIL_PVT.Enable_Debug_Pvt;
8338: END IF;
8339: ASO_QUOTE_UTIL_PVT.Set_Control_Rec_W(
8340: p_last_update_date => p_c_last_update_date,
8341: p_auto_version_flag => p_c_auto_version_flag,
8342: p_pricing_request_type => p_c_pricing_request_type,
8343: p_header_pricing_event => p_c_header_pricing_event,
8355: p_defaulting_fwk_flag => p_c_defaulting_fwk_flag,
8356: p_application_type_code => p_c_application_type_code,
8357: x_control_rec => l_control_rec);
8358:
8359: l_opp_qte_in_rec := ASO_QUOTE_UTIL_PVT.CONSTRUCT_Opp_Qte_In_Rec(
8360: p_opportunity_id => p_op_opportunity_id,
8361: p_quote_number => p_op_quote_number,
8362: p_quote_name => p_op_quote_name,
8363: p_cust_account_id => p_op_cust_account_id,
8381: p_tax_updated_date => p_op_tax_updated_date,
8382: p_org_id => p_op_org_id
8383: );
8384:
8385: l_quote_header_rec := ASO_QUOTE_UTIL_PVT.Construct_Qte_Header_Rec(
8386: p_quote_header_id => p_q_quote_header_id ,
8387: p_creation_date => p_q_creation_date ,
8388: p_created_by => p_q_created_by ,
8389: p_last_updated_by => p_q_last_updated_by ,
8521: p_end_customer_cust_party_id => p_q_end_cust_cust_party_id,
8522: p_object_version_number => p_q_object_version_number
8523: );
8524:
8525: l_hd_payment_rec := ASO_QUOTE_UTIL_PVT.Construct_Payment_rec(
8526: p_operation_code => p_qp_operation_code ,
8527: p_qte_line_index => p_qp_qte_line_index ,
8528: p_payment_id => p_qp_payment_id ,
8529: p_creation_date => p_qp_creation_date ,
8577: p_instr_assignment_id => p_qp_instr_assignment_id ,
8578: p_cvv2 => p_qp_cvv2 ,
8579: p_object_version_number => p_qp_object_version_number);
8580:
8581: l_hd_shipment_rec := ASO_QUOTE_UTIL_PVT.Construct_Shipment_rec(
8582: p_operation_code => p_qs_operation_code ,
8583: p_qte_line_index => p_qs_qte_line_index ,
8584: p_shipment_id => p_qs_shipment_id ,
8585: p_creation_date => p_qs_creation_date ,
8656: p_demand_class_code => p_qs_demand_class_code ,
8657: p_object_version_number => p_qs_object_version_number
8658: );
8659:
8660: l_hd_tax_rec := ASO_QUOTE_UTIL_PVT.Construct_Tax_Detail_rec(
8661: p_operation_code => p_qt_operation_code ,
8662: p_qte_line_index => p_qt_qte_line_index ,
8663: p_shipment_index => p_qt_shipment_index ,
8664: p_tax_detail_id => p_qt_tax_detail_id ,
8707: p_tax_rate_id => p_qt_tax_rate_id
8708: );
8709:
8710: -- bug 4918140
8711: l_template_tbl := ASO_QUOTE_UTIL_PVT.Construct_Template_Tbl (
8712: p_template_id => p_qtmpl_template_id);
8713:
8714: -- Call ASO API
8715: IF l_debug = 'Y' THEN
8712: p_template_id => p_qtmpl_template_id);
8713:
8714: -- Call ASO API
8715: IF l_debug = 'Y' THEN
8716: ASO_QUOTE_UTIL_PVT.Debug('Begin calling ASO_Opp_Qte_Pub.Create_Qte_Opportunity');
8717: END IF;
8718:
8719: ASO_Opp_Qte_Pub.Create_Qte_Opportunity(
8720: P_API_VERSION_NUMBER => p_api_version_number,
8736: );
8737:
8738:
8739: IF l_debug = 'Y' THEN
8740: ASO_QUOTE_UTIL_PVT.Debug('Returning from ASO_Opp_Qte_Pub.Create_Qte_Opportunity');
8741: END IF;
8742:
8743: ASO_QUOTE_UTIL_PVT.Set_Opp_Qte_Out_Rec_Out(
8744: p_opp_qte_out_rec => lx_opp_qte_out_rec,
8739: IF l_debug = 'Y' THEN
8740: ASO_QUOTE_UTIL_PVT.Debug('Returning from ASO_Opp_Qte_Pub.Create_Qte_Opportunity');
8741: END IF;
8742:
8743: ASO_QUOTE_UTIL_PVT.Set_Opp_Qte_Out_Rec_Out(
8744: p_opp_qte_out_rec => lx_opp_qte_out_rec,
8745: x_quote_header_id => x_op_quote_header_id,
8746: x_quote_number => x_op_quote_number,
8747: x_related_object_id => x_op_related_object_id,
8748: x_cust_account_id => x_op_cust_account_id,
8749: x_party_id => x_op_party_id,
8750: x_currency_code => x_op_currency_code);
8751: IF l_debug = 'Y' THEN
8752: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
8753: END IF;
8754:
8755: END Create_Qte_Opportunity;
8756:
8809: lx_qte_access_tbl ASO_Security_Int.Qte_Access_Tbl_Type;
8810: l_debug VARCHAR2(1);
8811: BEGIN
8812:
8813: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;
8814: IF l_debug = 'Y' THEN
8815: ASO_QUOTE_UTIL_PVT.Enable_Debug_Pvt;
8816: END IF;
8817: l_qte_access_tbl := ASO_QUOTE_UTIL_PVT.CONSTRUCT_Qte_Access_Tbl(
8811: BEGIN
8812:
8813: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;
8814: IF l_debug = 'Y' THEN
8815: ASO_QUOTE_UTIL_PVT.Enable_Debug_Pvt;
8816: END IF;
8817: l_qte_access_tbl := ASO_QUOTE_UTIL_PVT.CONSTRUCT_Qte_Access_Tbl(
8818: p_access_id => p_qac_access_id,
8819: p_quote_number => p_qac_quote_number,
8813: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;
8814: IF l_debug = 'Y' THEN
8815: ASO_QUOTE_UTIL_PVT.Enable_Debug_Pvt;
8816: END IF;
8817: l_qte_access_tbl := ASO_QUOTE_UTIL_PVT.CONSTRUCT_Qte_Access_Tbl(
8818: p_access_id => p_qac_access_id,
8819: p_quote_number => p_qac_quote_number,
8820: p_resource_id => p_qac_resource_id,
8821: p_resource_grp_id => p_qac_resource_grp_id,
8857: p_attribute20 => p_qac_attribute20);
8858:
8859: -- Call ASO API
8860: IF l_debug = 'Y' THEN
8861: ASO_QUOTE_UTIL_PVT.Debug('Begin calling Aso_Security_Int.Add_Resource');
8862: END IF;
8863: Aso_Security_Int.Add_Resource(
8864: p_init_msg_list => p_init_msg_list,
8865: p_commit => p_commit,
8868: x_return_status => x_return_status,
8869: x_msg_count => x_msg_count,
8870: x_msg_data => x_msg_data);
8871: IF l_debug = 'Y' THEN
8872: ASO_QUOTE_UTIL_PVT.Debug('Returning from Aso_Security_Int.Add_Resource');
8873: END IF;
8874:
8875: ASO_QUOTE_UTIL_PVT.Set_Qte_Access_Tbl_Out(
8876: p_qte_access_tbl => lx_qte_access_tbl,
8871: IF l_debug = 'Y' THEN
8872: ASO_QUOTE_UTIL_PVT.Debug('Returning from Aso_Security_Int.Add_Resource');
8873: END IF;
8874:
8875: ASO_QUOTE_UTIL_PVT.Set_Qte_Access_Tbl_Out(
8876: p_qte_access_tbl => lx_qte_access_tbl,
8877: x_access_id => x_qac_access_id
8878: );
8879:
8877: x_access_id => x_qac_access_id
8878: );
8879:
8880: IF l_debug = 'Y' THEN
8881: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
8882: END IF;
8883:
8884: END Add_Resource;
8885:
8934: l_qte_access_tbl ASO_Security_Int.Qte_Access_Tbl_Type
8935: := ASO_Security_Int.G_Miss_Qte_Access_Tbl;
8936: l_debug VARCHAR2(1);
8937: BEGIN
8938: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;
8939: IF l_debug = 'Y' THEN
8940: ASO_QUOTE_UTIL_PVT.Enable_Debug_Pvt;
8941: END IF;
8942: l_qte_access_tbl := ASO_QUOTE_UTIL_PVT.CONSTRUCT_Qte_Access_Tbl(
8936: l_debug VARCHAR2(1);
8937: BEGIN
8938: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;
8939: IF l_debug = 'Y' THEN
8940: ASO_QUOTE_UTIL_PVT.Enable_Debug_Pvt;
8941: END IF;
8942: l_qte_access_tbl := ASO_QUOTE_UTIL_PVT.CONSTRUCT_Qte_Access_Tbl(
8943: p_access_id => p_qac_access_id,
8944: p_quote_number => p_qac_quote_number,
8938: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;
8939: IF l_debug = 'Y' THEN
8940: ASO_QUOTE_UTIL_PVT.Enable_Debug_Pvt;
8941: END IF;
8942: l_qte_access_tbl := ASO_QUOTE_UTIL_PVT.CONSTRUCT_Qte_Access_Tbl(
8943: p_access_id => p_qac_access_id,
8944: p_quote_number => p_qac_quote_number,
8945: p_resource_id => p_qac_resource_id,
8946: p_resource_grp_id => p_qac_resource_grp_id,
8982: p_attribute20 => p_qac_attribute20);
8983:
8984: -- Call ASO API
8985: IF l_debug = 'Y' THEN
8986: ASO_QUOTE_UTIL_PVT.Debug('Begin calling Aso_Security_Int.Delete_Resource');
8987: END IF;
8988: Aso_Security_Int.Delete_Resource(
8989: p_init_msg_list => p_init_msg_list,
8990: p_commit => p_commit,
8992: x_return_status => x_return_status,
8993: x_msg_count => x_msg_count,
8994: x_msg_data => x_msg_data);
8995: IF l_debug = 'Y' THEN
8996: ASO_QUOTE_UTIL_PVT.Debug('Returning from Aso_Security_Int.Delete_Resource');
8997: END IF;
8998:
8999: IF l_debug = 'Y' THEN
9000: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
8996: ASO_QUOTE_UTIL_PVT.Debug('Returning from Aso_Security_Int.Delete_Resource');
8997: END IF;
8998:
8999: IF l_debug = 'Y' THEN
9000: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
9001: END IF;
9002: END Delete_Resource;
9003:
9004:
9046: l_debug VARCHAR2(1);
9047: BEGIN
9048:
9049: SAVEPOINT Copy_Quote_Pvt;
9050: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;
9051: IF l_debug = 'Y' THEN
9052: ASO_QUOTE_UTIL_PVT.Enable_Debug_Pvt;
9053: END IF;
9054: -- standard call to check for call compatibility
9048:
9049: SAVEPOINT Copy_Quote_Pvt;
9050: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;
9051: IF l_debug = 'Y' THEN
9052: ASO_QUOTE_UTIL_PVT.Enable_Debug_Pvt;
9053: END IF;
9054: -- standard call to check for call compatibility
9055: IF NOT FND_API.Compatible_API_Call (l_api_version,
9056: p_api_version_number,
9068: -- initialize API return status to success
9069: x_return_status := FND_API.G_RET_STS_SUCCESS;
9070:
9071: IF l_debug = 'Y' THEN
9072: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.copy_quote(+)');
9073: END IF;
9074:
9075: -- begin API body
9076:
9073: END IF;
9074:
9075: -- begin API body
9076:
9077: l_copy_qte_hdr_rec := ASO_QUOTE_UTIL_PVT.CONSTRUCT_Copy_Qte_Hdr_Rec(
9078: p_quote_header_id => p_cq_quote_header_id,
9079: p_quote_name => p_cq_quote_name,
9080: p_quote_number => p_cq_quote_number,
9081: p_quote_source_code => p_cq_quote_source_code,
9086: p_tax_status_indicator => p_cq_tax_status_indicator,
9087: p_price_updated_date => p_cq_price_updated_date,
9088: p_tax_updated_date => p_cq_tax_updated_date);
9089:
9090: ASO_QUOTE_UTIL_PVT.Set_Copy_Quote_Control_Rec_W(
9091: p_copy_header_only => p_cc_copy_header_only,
9092: p_new_version => p_cc_new_version,
9093: p_copy_note => p_cc_copy_note,
9094: p_copy_task => p_cc_copy_task,
9101: x_copy_quote_control_rec => l_copy_qte_control_rec);
9102:
9103: -- Call ASO API
9104: IF l_debug = 'Y' THEN
9105: ASO_QUOTE_UTIL_PVT.Debug('Begin calling ASO_Copy_Quote_Pub.Copy_Quote');
9106: END IF;
9107: ASO_Copy_Quote_Pub.Copy_Quote(
9108: p_api_Version_Number => 1.0,
9109: p_init_msg_list => FND_API.G_FALSE,
9115: x_return_status => x_return_status,
9116: x_msg_count => x_msg_count,
9117: x_msg_data => x_msg_data);
9118: IF l_debug = 'Y' THEN
9119: ASO_QUOTE_UTIL_PVT.Debug('Returning from ASO_Copy_Quote_Pub.Copy_Quote');
9120: END IF;
9121:
9122: IF FND_API.To_Boolean( p_commit ) THEN
9123: COMMIT WORK;
9123: COMMIT WORK;
9124: END IF;
9125:
9126: IF l_debug = 'Y' THEN
9127: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.copy_quote(+)');
9128: END IF;
9129: -- standard call to get message count and if count is 1, get message info.
9130: FND_MSG_PUB.Count_And_Get
9131: ( p_encoded => FND_API.G_FALSE,
9133: p_data => x_msg_data
9134: );
9135:
9136: IF l_debug = 'Y' THEN
9137: ASO_QUOTE_UTIL_PVT.disable_debug_pvt;
9138: END IF;
9139:
9140: EXCEPTION
9141: WHEN FND_API.G_EXC_ERROR THEN
9146: p_count => x_msg_count,
9147: p_data => x_msg_data
9148: );
9149: IF l_debug = 'Y' THEN
9150: ASO_QUOTE_UTIL_PVT.disable_debug_pvt;
9151: END IF;
9152: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9153: ROLLBACK TO Copy_Quote_Pvt;
9154: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9157: p_count => x_msg_count,
9158: p_data => x_msg_data
9159: );
9160: IF l_debug = 'Y' THEN
9161: ASO_QUOTE_UTIL_PVT.disable_debug_pvt;
9162: END IF;
9163: WHEN OTHERS THEN
9164: ROLLBACK TO Copy_Quote_Pvt;
9165: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9180: p_count => x_msg_count,
9181: p_data => x_msg_data
9182: );
9183: IF l_debug = 'Y' THEN
9184: ASO_QUOTE_UTIL_PVT.disable_debug_pvt;
9185: END IF;
9186: END Copy_Quote;
9187:
9188: PROCEDURE Copy_Line (
9376: BEGIN
9377:
9378: SAVEPOINT Copy_Quote_Line_Pvt;
9379:
9380: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;
9381: IF l_debug = 'Y' THEN
9382: ASO_QUOTE_UTIL_PVT.Enable_Debug_Pvt;
9383: END IF;
9384: -- standard call to check for call compatibility
9378: SAVEPOINT Copy_Quote_Line_Pvt;
9379:
9380: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;
9381: IF l_debug = 'Y' THEN
9382: ASO_QUOTE_UTIL_PVT.Enable_Debug_Pvt;
9383: END IF;
9384: -- standard call to check for call compatibility
9385: IF NOT FND_API.Compatible_Api_Call(l_api_version,
9386: p_api_version_number,
9397: END IF;
9398:
9399: -- begin API body
9400: IF l_debug = 'Y' THEN
9401: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Copy_Quote_Line Begins');
9402: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Copy_Quote_Line PARAM: p_quote_header_id = '||TO_CHAR(p_quote_header_id));
9403: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Copy_Quote_Line PARAM: p_quote_line_id = '||TO_CHAR(p_quote_line_id));
9404: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Copy_Quote_Line PARAM: p_cc_copy_attachment = '||p_cc_copy_attachment);
9405: END IF;
9398:
9399: -- begin API body
9400: IF l_debug = 'Y' THEN
9401: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Copy_Quote_Line Begins');
9402: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Copy_Quote_Line PARAM: p_quote_header_id = '||TO_CHAR(p_quote_header_id));
9403: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Copy_Quote_Line PARAM: p_quote_line_id = '||TO_CHAR(p_quote_line_id));
9404: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Copy_Quote_Line PARAM: p_cc_copy_attachment = '||p_cc_copy_attachment);
9405: END IF;
9406: -- set l_control_rec
9399: -- begin API body
9400: IF l_debug = 'Y' THEN
9401: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Copy_Quote_Line Begins');
9402: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Copy_Quote_Line PARAM: p_quote_header_id = '||TO_CHAR(p_quote_header_id));
9403: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Copy_Quote_Line PARAM: p_quote_line_id = '||TO_CHAR(p_quote_line_id));
9404: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Copy_Quote_Line PARAM: p_cc_copy_attachment = '||p_cc_copy_attachment);
9405: END IF;
9406: -- set l_control_rec
9407: ASO_QUOTE_UTIL_PVT.Set_Control_Rec_W(
9400: IF l_debug = 'Y' THEN
9401: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Copy_Quote_Line Begins');
9402: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Copy_Quote_Line PARAM: p_quote_header_id = '||TO_CHAR(p_quote_header_id));
9403: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Copy_Quote_Line PARAM: p_quote_line_id = '||TO_CHAR(p_quote_line_id));
9404: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Copy_Quote_Line PARAM: p_cc_copy_attachment = '||p_cc_copy_attachment);
9405: END IF;
9406: -- set l_control_rec
9407: ASO_QUOTE_UTIL_PVT.Set_Control_Rec_W(
9408: p_last_update_date => p_c_last_update_date,
9403: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Copy_Quote_Line PARAM: p_quote_line_id = '||TO_CHAR(p_quote_line_id));
9404: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Copy_Quote_Line PARAM: p_cc_copy_attachment = '||p_cc_copy_attachment);
9405: END IF;
9406: -- set l_control_rec
9407: ASO_QUOTE_UTIL_PVT.Set_Control_Rec_W(
9408: p_last_update_date => p_c_last_update_date,
9409: p_auto_version_flag => p_c_auto_version_flag,
9410: p_pricing_request_type => p_c_pricing_request_type,
9411: p_header_pricing_event => p_c_header_pricing_event,
9424: p_application_type_code => p_c_application_type_code,
9425: x_control_rec => l_control_rec);
9426:
9427: -- set l_quote_header_rec
9428: l_quote_header_rec := ASO_QUOTE_UTIL_PVT.CONSTRUCT_Qte_Header_Rec(
9429: p_quote_header_id => p_q_quote_header_id ,
9430: p_creation_date => p_q_creation_date ,
9431: p_created_by => p_q_created_by ,
9432: p_last_updated_by => p_q_last_updated_by ,
9556: p_supplier_signature_date => p_q_supplier_signature_date,
9557: p_credit_update_date => p_q_credit_update_date);
9558:
9559: -- set l_copy_quote_control_rec
9560: ASO_QUOTE_UTIL_PVT.Set_Copy_Quote_Control_Rec_W(
9561: p_copy_note => p_cc_copy_note,
9562: p_copy_task => p_cc_copy_task,
9563: p_copy_attachment => p_cc_copy_attachment,
9564: p_pricing_request_type => p_cc_pricing_request_type,
9569: x_copy_quote_control_rec => l_copy_quote_control_rec);
9570:
9571: -- Call ASO API
9572: IF l_debug = 'Y' THEN
9573: ASO_QUOTE_UTIL_PVT.Debug('Begin calling ASO_COPY_QUOTE_PUB.Copy_Line');
9574: END IF;
9575: ASO_COPY_QUOTE_PUB.Copy_Line(
9576: p_api_version_number => p_api_version_number,
9577: p_init_msg_list => p_init_msg_list,
9586: x_return_status => x_return_status,
9587: x_msg_count => x_msg_count,
9588: x_msg_data => x_msg_data);
9589: IF l_debug = 'Y' THEN
9590: ASO_QUOTE_UTIL_PVT.Debug('Returning from ASO_COPY_QUOTE_PUB.Copy_Line');
9591: END IF;
9592:
9593: x_q_quote_header_id := x_q_quote_header_rec.quote_header_id;
9594: x_q_quote_obj_version_number := x_q_quote_header_rec.object_version_number;
9606: p_count => x_msg_count,
9607: p_data => x_msg_data);
9608:
9609: IF l_debug = 'Y' THEN
9610: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Copy_Quote_Line OUTPUT: x_copy_quote_line_id = '||TO_CHAR(x_ql_quote_line_id));
9611: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Copy_Quote_Line OUTPUT: x_return_status = '||x_return_status);
9612: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Copy_Quote_Line OUTPUT: x_msg_count = '||TO_CHAR(x_msg_count));
9613: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Copy_Quote_Line OUTPUT: x_msg_data = '||x_msg_data);
9614: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Copy_Quote_Line Ends');
9607: p_data => x_msg_data);
9608:
9609: IF l_debug = 'Y' THEN
9610: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Copy_Quote_Line OUTPUT: x_copy_quote_line_id = '||TO_CHAR(x_ql_quote_line_id));
9611: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Copy_Quote_Line OUTPUT: x_return_status = '||x_return_status);
9612: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Copy_Quote_Line OUTPUT: x_msg_count = '||TO_CHAR(x_msg_count));
9613: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Copy_Quote_Line OUTPUT: x_msg_data = '||x_msg_data);
9614: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Copy_Quote_Line Ends');
9615: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
9608:
9609: IF l_debug = 'Y' THEN
9610: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Copy_Quote_Line OUTPUT: x_copy_quote_line_id = '||TO_CHAR(x_ql_quote_line_id));
9611: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Copy_Quote_Line OUTPUT: x_return_status = '||x_return_status);
9612: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Copy_Quote_Line OUTPUT: x_msg_count = '||TO_CHAR(x_msg_count));
9613: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Copy_Quote_Line OUTPUT: x_msg_data = '||x_msg_data);
9614: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Copy_Quote_Line Ends');
9615: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
9616: END IF;
9609: IF l_debug = 'Y' THEN
9610: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Copy_Quote_Line OUTPUT: x_copy_quote_line_id = '||TO_CHAR(x_ql_quote_line_id));
9611: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Copy_Quote_Line OUTPUT: x_return_status = '||x_return_status);
9612: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Copy_Quote_Line OUTPUT: x_msg_count = '||TO_CHAR(x_msg_count));
9613: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Copy_Quote_Line OUTPUT: x_msg_data = '||x_msg_data);
9614: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Copy_Quote_Line Ends');
9615: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
9616: END IF;
9617:
9610: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Copy_Quote_Line OUTPUT: x_copy_quote_line_id = '||TO_CHAR(x_ql_quote_line_id));
9611: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Copy_Quote_Line OUTPUT: x_return_status = '||x_return_status);
9612: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Copy_Quote_Line OUTPUT: x_msg_count = '||TO_CHAR(x_msg_count));
9613: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Copy_Quote_Line OUTPUT: x_msg_data = '||x_msg_data);
9614: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Copy_Quote_Line Ends');
9615: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
9616: END IF;
9617:
9618: EXCEPTION
9611: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Copy_Quote_Line OUTPUT: x_return_status = '||x_return_status);
9612: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Copy_Quote_Line OUTPUT: x_msg_count = '||TO_CHAR(x_msg_count));
9613: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Copy_Quote_Line OUTPUT: x_msg_data = '||x_msg_data);
9614: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Copy_Quote_Line Ends');
9615: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
9616: END IF;
9617:
9618: EXCEPTION
9619:
9625: p_encoded => FND_API.G_FALSE,
9626: p_count => x_msg_count,
9627: p_data => x_msg_data);
9628: IF l_debug = 'Y' THEN
9629: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
9630: END IF;
9631:
9632: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
9633: THEN
9637: p_encoded => FND_API.G_FALSE,
9638: p_count => x_msg_count,
9639: p_data => x_msg_data);
9640: IF l_debug = 'Y' THEN
9641: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
9642: END IF;
9643:
9644: WHEN OTHERS
9645: THEN
9658: p_encoded => FND_API.G_FALSE,
9659: p_count => x_msg_count,
9660: p_data => x_msg_data);
9661: IF l_debug = 'Y' THEN
9662: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
9663: END IF;
9664: END Copy_Line;
9665:
9666: PROCEDURE Get_Config_Details (
9993: from aso_quote_line_details
9994: where quote_line_id = p_c_quote_line_id;
9995:
9996: BEGIN
9997: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;
9998: IF l_debug = 'Y' THEN
9999: ASO_QUOTE_UTIL_PVT.Enable_Debug_Pvt;
10000: END IF;
10001: ASO_QUOTE_UTIL_PVT.Set_Control_Rec_W(
9995:
9996: BEGIN
9997: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;
9998: IF l_debug = 'Y' THEN
9999: ASO_QUOTE_UTIL_PVT.Enable_Debug_Pvt;
10000: END IF;
10001: ASO_QUOTE_UTIL_PVT.Set_Control_Rec_W(
10002: p_last_update_date => p_c_last_update_date,
10003: p_auto_version_flag => p_c_auto_version_flag,
9997: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;
9998: IF l_debug = 'Y' THEN
9999: ASO_QUOTE_UTIL_PVT.Enable_Debug_Pvt;
10000: END IF;
10001: ASO_QUOTE_UTIL_PVT.Set_Control_Rec_W(
10002: p_last_update_date => p_c_last_update_date,
10003: p_auto_version_flag => p_c_auto_version_flag,
10004: p_pricing_request_type => p_c_pricing_request_type,
10005: p_header_pricing_event => p_c_header_pricing_event,
10017: p_defaulting_fwk_flag => p_c_defaulting_fwk_flag,
10018: p_application_type_code => p_c_application_type_code,
10019: x_control_rec => l_control_rec);
10020:
10021: l_qte_header_rec := ASO_QUOTE_UTIL_PVT.CONSTRUCT_Qte_Header_Rec(
10022: p_quote_header_id => p_q_quote_header_id ,
10023: p_creation_date => p_q_creation_date ,
10024: p_created_by => p_q_created_by ,
10025: p_last_updated_by => p_q_last_updated_by ,
10148: p_supplier_name_and_title => p_q_supplier_name_and_title,
10149: p_supplier_signature_date => p_q_supplier_signature_date,
10150: p_credit_update_date => p_q_credit_update_date);
10151:
10152: l_config_rec := ASO_QUOTE_UTIL_PVT.CONSTRUCT_Qte_Line_Dtl_Rec(
10153: p_quote_line_detail_id => p_qdl_quote_line_detail_id,
10154: p_creation_date => p_qdl_creation_date,
10155: p_created_by => p_qdl_created_by,
10156: p_last_update_date => p_qdl_last_update_date,
10227: p_return_reason_code => p_qdl_return_reason_code,
10228: p_change_reason_code => p_qdl_change_reason_code
10229: );
10230:
10231: l_model_line_rec := ASO_QUOTE_UTIL_PVT.CONSTRUCT_Qte_Line_Rec(
10232: p_creation_date => p_ql_creation_date,
10233: p_created_by => p_ql_created_by,
10234: p_last_updated_by => p_ql_last_updated_by,
10235: p_last_update_date => p_ql_last_update_date,
10313: CLOSE l_old_cfg_csr;
10314:
10315: -- Call ASO API
10316: IF l_debug = 'Y'
10317: THEN ASO_QUOTE_UTIL_PVT.Debug('Begin calling ASO_CFG_PUB.Get_Config_Details');
10318: END IF;
10319: ASO_CFG_PUB.Get_Config_Details(
10320: p_api_version_number => p_api_version_number,
10321: p_init_msg_list => p_init_msg_list,
10331: x_msg_data => x_msg_data
10332: );
10333: IF l_debug = 'Y'
10334: THEN
10335: ASO_QUOTE_UTIL_PVT.Debug('Returning from ASO_CFG_PUB.Get_Config_Details');
10336: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
10337: END IF;
10338:
10339: END Get_Config_Details;
10332: );
10333: IF l_debug = 'Y'
10334: THEN
10335: ASO_QUOTE_UTIL_PVT.Debug('Returning from ASO_CFG_PUB.Get_Config_Details');
10336: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
10337: END IF;
10338:
10339: END Get_Config_Details;
10340:
10350: IS
10351: l_quote_header_id NUMBER;
10352: l_debug VARCHAR2(1);
10353: BEGIN
10354: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;
10355: IF l_debug = 'Y' THEN
10356: ASO_QUOTE_UTIL_PVT.Enable_Debug_Pvt;
10357: END IF;
10358:
10352: l_debug VARCHAR2(1);
10353: BEGIN
10354: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;
10355: IF l_debug = 'Y' THEN
10356: ASO_QUOTE_UTIL_PVT.Enable_Debug_Pvt;
10357: END IF;
10358:
10359: FOR i in 1..p_quote_header_ids.COUNT LOOP
10360: l_quote_header_id := p_quote_header_ids(i);
10359: FOR i in 1..p_quote_header_ids.COUNT LOOP
10360: l_quote_header_id := p_quote_header_ids(i);
10361: -- Call ASO API
10362: IF l_debug = 'Y'
10363: THEN ASO_QUOTE_UTIL_PVT.Debug('Begin calling ASO_QUOTE_PUB.Delete_Quote');
10364: END IF;
10365: ASO_QUOTE_PUB.Delete_Quote (
10366: p_api_version,
10367: p_init_msg_list,
10370: x_return_status,
10371: x_msg_count,
10372: x_msg_data);
10373: IF l_debug = 'Y'
10374: THEN ASO_QUOTE_UTIL_PVT.Debug('Returning from ASO_QUOTE_PUB.Delete_Quote');
10375: END IF;
10376: END LOOP;
10377:
10378: IF l_debug = 'Y' THEN
10375: END IF;
10376: END LOOP;
10377:
10378: IF l_debug = 'Y' THEN
10379: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
10380: END IF;
10381:
10382: END Delete_Quotes;
10383:
10547: l_debug VARCHAR2(1);
10548:
10549: BEGIN
10550:
10551: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;
10552: IF l_debug = 'Y' THEN
10553: ASO_QUOTE_UTIL_PVT.Enable_Debug_Pvt;
10554: END IF;
10555:
10549: BEGIN
10550:
10551: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;
10552: IF l_debug = 'Y' THEN
10553: ASO_QUOTE_UTIL_PVT.Enable_Debug_Pvt;
10554: END IF;
10555:
10556: ASO_QUOTE_UTIL_PVT.Set_Control_Rec_W (
10557: p_last_update_date => p_c_last_update_date,
10552: IF l_debug = 'Y' THEN
10553: ASO_QUOTE_UTIL_PVT.Enable_Debug_Pvt;
10554: END IF;
10555:
10556: ASO_QUOTE_UTIL_PVT.Set_Control_Rec_W (
10557: p_last_update_date => p_c_last_update_date,
10558: p_auto_version_flag => p_c_auto_version_flag,
10559: p_pricing_request_type => p_c_pricing_request_type,
10560: p_header_pricing_event => p_c_header_pricing_event,
10572: p_defaulting_fwk_flag => p_c_defaulting_fwk_flag,
10573: p_application_type_code => p_c_application_type_code,
10574: x_control_rec => l_control_rec);
10575:
10576: l_qte_header_rec := ASO_QUOTE_UTIL_PVT.CONSTRUCT_Qte_Header_Rec(
10577: p_quote_header_id => p_q_quote_header_id ,
10578: p_creation_date => p_q_creation_date ,
10579: p_created_by => p_q_created_by ,
10580: p_last_updated_by => p_q_last_updated_by ,
10708: END LOOP;
10709:
10710: -- Call ASO API
10711: IF l_debug = 'Y'
10712: THEN ASO_QUOTE_UTIL_PVT.Debug('Begin calling ASO_QUOTE_TMPL_INT.Add_Template_To_Quote');
10713: END IF;
10714: ASO_QUOTE_TMPL_INT.Add_Template_To_Quote (
10715: P_API_VERSION_NUMBER => P_API_VERSION_NUMBER,
10716: P_INIT_MSG_LIST => P_INIT_MSG_LIST,
10723: x_msg_count => x_msg_count,
10724: x_msg_data => x_msg_data );
10725: IF l_debug = 'Y'
10726: THEN
10727: ASO_QUOTE_UTIL_PVT.Debug('Returning from ASO_QUOTE_TMPL_INT.Add_Template_To_Quote');
10728: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
10729: END IF;
10730: END Add_Templates_To_Quote;
10731:
10724: x_msg_data => x_msg_data );
10725: IF l_debug = 'Y'
10726: THEN
10727: ASO_QUOTE_UTIL_PVT.Debug('Returning from ASO_QUOTE_TMPL_INT.Add_Template_To_Quote');
10728: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
10729: END IF;
10730: END Add_Templates_To_Quote;
10731:
10732: PROCEDURE Get_Config_Launch_Info(
10756: BEGIN
10757:
10758: SAVEPOINT Get_Config_Launch_Info_Pvt;
10759:
10760: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;
10761: IF l_debug = 'Y' THEN
10762: ASO_QUOTE_UTIL_PVT.Enable_Debug_Pvt;
10763: END IF;
10764:
10758: SAVEPOINT Get_Config_Launch_Info_Pvt;
10759:
10760: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;
10761: IF l_debug = 'Y' THEN
10762: ASO_QUOTE_UTIL_PVT.Enable_Debug_Pvt;
10763: END IF;
10764:
10765: -- Standard call to check for call compatibility.
10766: IF NOT FND_API.Compatible_API_Call (l_api_version,
10784: l_resp_appl_id := fnd_profile.value('RESP_APPL_ID');
10785:
10786: -- Call CZ API
10787: IF l_debug = 'Y'
10788: THEN ASO_QUOTE_UTIL_PVT.Debug('Begin calling CZ_CF_API.UI_FOR_ITEM');
10789: END IF;
10790: l_ui_def_id := CZ_CF_API.UI_FOR_ITEM (p_item_id, p_organization_id, SYSDATE,
10791: 'DHTML', FND_API.G_MISS_NUM, l_resp_id, l_resp_appl_id);
10792: IF l_debug = 'Y'
10789: END IF;
10790: l_ui_def_id := CZ_CF_API.UI_FOR_ITEM (p_item_id, p_organization_id, SYSDATE,
10791: 'DHTML', FND_API.G_MISS_NUM, l_resp_id, l_resp_appl_id);
10792: IF l_debug = 'Y'
10793: THEN ASO_QUOTE_UTIL_PVT.Debug('Returning from CZ_CF_API.UI_FOR_ITEM');
10794: END IF;
10795:
10796: IF l_ui_def_id IS NULL THEN
10797: x_configurable := FND_API.G_FALSE;
10818: (p_encoded => FND_API.G_FALSE,
10819: p_count => x_msg_count,
10820: p_data => x_msg_data);
10821: IF l_debug = 'Y' THEN
10822: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
10823: END IF;
10824: EXCEPTION
10825: WHEN FND_API.G_EXC_ERROR THEN
10826: ROLLBACK TO Get_Config_Launch_Info_Pvt;
10829: (p_encoded => FND_API.G_FALSE,
10830: p_count => x_msg_count,
10831: p_data => x_msg_data);
10832: IF l_debug = 'Y' THEN
10833: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
10834: END IF;
10835: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10836: ROLLBACK TO Get_Config_Launch_Info_Pvt;
10837: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
10839: (p_encoded => FND_API.G_FALSE,
10840: p_count => x_msg_count,
10841: p_data => x_msg_data);
10842: IF l_debug = 'Y' THEN
10843: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
10844: END IF;
10845: WHEN OTHERS THEN
10846: ROLLBACK TO Get_Config_Launch_Info_Pvt;
10847: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
10854: (p_encoded => FND_API.G_FALSE,
10855: p_count => x_msg_count,
10856: p_data => x_msg_data);
10857: IF l_debug = 'Y' THEN
10858: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
10859: END IF;
10860: end Get_Config_Launch_Info;
10861:
10862: PROCEDURE Get_Quote_Exp_Date(
10872: l_api_version CONSTANT NUMBER := 1.0;
10873: l_debug VARCHAR2(1);
10874: BEGIN
10875:
10876: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;
10877: IF l_debug = 'Y' THEN
10878: ASO_QUOTE_UTIL_PVT.Enable_Debug_Pvt;
10879: END IF;
10880: -- Standard call to check for call compatibility.
10874: BEGIN
10875:
10876: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;
10877: IF l_debug = 'Y' THEN
10878: ASO_QUOTE_UTIL_PVT.Enable_Debug_Pvt;
10879: END IF;
10880: -- Standard call to check for call compatibility.
10881: IF NOT FND_API.Compatible_API_Call(l_api_version,
10882: p_api_version,
10895: x_return_status := FND_API.g_ret_sts_success;
10896:
10897: -- Call ASO API
10898: IF l_debug = 'Y'
10899: THEN ASO_QUOTE_UTIL_PVT.Debug('Begin calling ASO_COPY_QUOTE_PVT.Get_Quote_Exp_Date');
10900: END IF;
10901: ASO_COPY_QUOTE_PVT.Get_Quote_Exp_Date(
10902: X_Quote_Exp_Date => x_quote_exp_date,
10903: X_Return_Status => x_return_status,
10903: X_Return_Status => x_return_status,
10904: X_Msg_Count => x_msg_count,
10905: X_Msg_Data => x_msg_data);
10906: IF l_debug = 'Y'
10907: THEN ASO_QUOTE_UTIL_PVT.Debug('Returning from ASO_COPY_QUOTE_PVT.Get_Quote_Exp_Date');
10908: END IF;
10909:
10910: FND_MSG_PUB.Count_And_Get
10911: (p_encoded => FND_API.G_FALSE,
10911: (p_encoded => FND_API.G_FALSE,
10912: p_count => x_msg_count,
10913: p_data => x_msg_data);
10914: IF l_debug = 'Y' THEN
10915: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
10916: END IF;
10917: EXCEPTION
10918: WHEN FND_API.G_EXC_ERROR THEN
10919: x_return_status := FND_API.G_RET_STS_ERROR ;
10921: (p_encoded => FND_API.G_FALSE,
10922: p_count => x_msg_count,
10923: p_data => x_msg_data);
10924: IF l_debug = 'Y' THEN
10925: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
10926: END IF;
10927: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10928: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
10929: FND_MSG_PUB.Count_And_Get
10930: (p_encoded => FND_API.G_FALSE,
10931: p_count => x_msg_count,
10932: p_data => x_msg_data);
10933: IF l_debug = 'Y' THEN
10934: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
10935: END IF;
10936: WHEN OTHERS THEN
10937: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
10938: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
10944: (p_encoded => FND_API.G_FALSE,
10945: p_count => x_msg_count,
10946: p_data => x_msg_data);
10947: IF l_debug = 'Y' THEN
10948: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
10949: END IF;
10950: END Get_Quote_Exp_Date;
10951:
10952: PROCEDURE validate_quantity (
10970: l_primary_qty NUMBER;
10971: l_debug VARCHAR2(1);
10972: begin
10973:
10974: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;
10975: IF l_debug = 'Y' THEN
10976: ASO_QUOTE_UTIL_PVT.Enable_Debug_Pvt;
10977: END IF;
10978: -- standard call to check for call compatibility
10972: begin
10973:
10974: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;
10975: IF l_debug = 'Y' THEN
10976: ASO_QUOTE_UTIL_PVT.Enable_Debug_Pvt;
10977: END IF;
10978: -- standard call to check for call compatibility
10979: IF NOT FND_API.Compatible_API_Call (l_api_version,
10980: p_api_version,
10992: -- initialize API return status to success
10993: x_return_status := FND_API.G_RET_STS_SUCCESS;
10994:
10995: IF l_debug = 'Y' THEN
10996: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.validate_quantity(+)');
10997: END IF;
10998:
10999: -- begin API body
11000:
11002: x_valid_qty_tbl.extend(p_item_id_tbl.count);
11003:
11004: for i in 1..p_item_id_tbl.count loop
11005: IF l_debug = 'Y' THEN
11006: ASO_QUOTE_UTIL_PVT.debug('Begin calling INV_DECIMALS_PUB.validate_quantity ' || TO_CHAR(SYSDATE,'DD-MON-YYYY:HH24:MI:SS'));
11007: END IF;
11008: inv_decimals_pub.validate_quantity(p_item_id_tbl(i), p_organization_id_tbl(i), p_qty_tbl(i),
11009: p_uom_code_tbl(i), l_output_qty, l_primary_qty, x_valid_qty_tbl(i));
11010: IF l_debug = 'Y' THEN
11007: END IF;
11008: inv_decimals_pub.validate_quantity(p_item_id_tbl(i), p_organization_id_tbl(i), p_qty_tbl(i),
11009: p_uom_code_tbl(i), l_output_qty, l_primary_qty, x_valid_qty_tbl(i));
11010: IF l_debug = 'Y' THEN
11011: ASO_QUOTE_UTIL_PVT.debug('Returning from INV_DECIMALS_PUB.validate_quantity ' || TO_CHAR(SYSDATE,'DD-MON-YYYY:HH24:MI:SS'));
11012: END IF;
11013: end loop;
11014:
11015: -- end API body
11013: end loop;
11014:
11015: -- end API body
11016: IF l_debug = 'Y' THEN
11017: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.validate_quantity(-)');
11018: END IF;
11019:
11020: -- standard call to get message count and if count is 1, get message info.
11021: FND_MSG_PUB.Count_And_Get
11023: p_count => x_msg_count,
11024: p_data => x_msg_data
11025: );
11026: If l_debug = 'Y' THEN
11027: ASO_QUOTE_UTIL_PVT.disable_debug_pvt;
11028: END IF;
11029:
11030: EXCEPTION
11031: WHEN FND_API.G_EXC_ERROR THEN
11035: p_count => x_msg_count,
11036: p_data => x_msg_data
11037: );
11038: IF l_debug = 'Y' THEN
11039: ASO_QUOTE_UTIL_PVT.disable_debug_pvt;
11040: END IF;
11041: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
11042: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11043: FND_MSG_PUB.Count_And_Get
11045: p_count => x_msg_count,
11046: p_data => x_msg_data
11047: );
11048: IF l_debug = 'Y' THEN
11049: ASO_QUOTE_UTIL_PVT.disable_debug_pvt;
11050: END IF;
11051: WHEN OTHERS THEN
11052: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11053: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
11067: p_count => x_msg_count,
11068: p_data => x_msg_data
11069: );
11070: IF l_debug = 'Y' THEN
11071: ASO_QUOTE_UTIL_PVT.disable_debug_pvt;
11072: END IF;
11073: end validate_quantity;
11074:
11075: PROCEDURE Credit_Check (
11221: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type
11222: := ASO_QUOTE_PUB.G_MISS_QTE_HEADER_REC;
11223: l_debug VARCHAR2(1);
11224: BEGIN
11225: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;
11226: IF l_debug = 'Y' THEN
11227: ASO_QUOTE_UTIL_PVT.Enable_Debug_Pvt;
11228: END IF;
11229: l_qte_header_rec := ASO_QUOTE_UTIL_PVT.CONSTRUCT_Qte_Header_Rec(
11223: l_debug VARCHAR2(1);
11224: BEGIN
11225: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;
11226: IF l_debug = 'Y' THEN
11227: ASO_QUOTE_UTIL_PVT.Enable_Debug_Pvt;
11228: END IF;
11229: l_qte_header_rec := ASO_QUOTE_UTIL_PVT.CONSTRUCT_Qte_Header_Rec(
11230: p_quote_header_id => p_q_quote_header_id ,
11231: p_creation_date => p_q_creation_date ,
11225: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;
11226: IF l_debug = 'Y' THEN
11227: ASO_QUOTE_UTIL_PVT.Enable_Debug_Pvt;
11228: END IF;
11229: l_qte_header_rec := ASO_QUOTE_UTIL_PVT.CONSTRUCT_Qte_Header_Rec(
11230: p_quote_header_id => p_q_quote_header_id ,
11231: p_creation_date => p_q_creation_date ,
11232: p_created_by => p_q_created_by ,
11233: p_last_updated_by => p_q_last_updated_by ,
11357: p_credit_update_date => p_q_credit_update_date);
11358:
11359: -- Call ASO API
11360: IF l_debug = 'Y'
11361: THEN ASO_QUOTE_UTIL_PVT.Debug('Begin calling ASO_CREDIT_CHECK_PUB.Credit_Check');
11362: END IF;
11363: ASO_CREDIT_CHECK_PUB.Credit_Check(
11364: p_api_version => p_api_version,
11365: p_init_msg_list => p_init_msg_list,
11371: x_msg_count => x_msg_count,
11372: x_msg_data => x_msg_data );
11373: IF l_debug = 'Y'
11374: THEN
11375: ASO_QUOTE_UTIL_PVT.Debug('Returning from ASO_CREDIT_CHECK_PUB.Credit_Check');
11376: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
11377: END IF;
11378:
11379: END Credit_Check;
11372: x_msg_data => x_msg_data );
11373: IF l_debug = 'Y'
11374: THEN
11375: ASO_QUOTE_UTIL_PVT.Debug('Returning from ASO_CREDIT_CHECK_PUB.Credit_Check');
11376: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
11377: END IF;
11378:
11379: END Credit_Check;
11380:
11420:
11421: l_debug VARCHAR2(1);
11422: BEGIN
11423:
11424: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;
11425: IF l_debug = 'Y' THEN
11426: ASO_QUOTE_UTIL_PVT.Enable_Debug_Pvt;
11427: END IF;
11428:
11422: BEGIN
11423:
11424: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;
11425: IF l_debug = 'Y' THEN
11426: ASO_QUOTE_UTIL_PVT.Enable_Debug_Pvt;
11427: END IF;
11428:
11429: -- Standard call to check for call compatibility
11430: IF NOT FND_API.Compatible_Api_Call(
11469: IF p_operation_code = 'CREATE'
11470: THEN
11471: -- Call ASO API
11472: IF l_debug = 'Y'
11473: THEN ASO_QUOTE_UTIL_PVT.Debug('Begin calling ASO_RLTSHIP_PUB.Create_Object_Relationship');
11474: END IF;
11475: ASO_RLTSHIP_PUB.Create_Object_Relationship(
11476: P_Api_Version_Number => p_api_version,
11477: P_Init_Msg_List => p_init_msg_list,
11483: X_Msg_Count => x_msg_count,
11484: X_Msg_Data => x_msg_data
11485: );
11486: IF l_debug = 'Y'
11487: THEN ASO_QUOTE_UTIL_PVT.Debug('Returning from ASO_RLTSHIP_PUB.Create_Object_Relationship');
11488: END IF;
11489:
11490: ELSIF p_operation_code = 'UPDATE'
11491: THEN
11500: END IF;
11501:
11502: -- Call ASO API
11503: IF l_debug = 'Y'
11504: THEN ASO_QUOTE_UTIL_PVT.Debug('Begin calling ASO_RLTSHIP_PUB.Update_Object_Relationship');
11505: END IF;
11506: ASO_RLTSHIP_PUB.Update_Object_Relationship(
11507: P_Api_Version_Number => p_api_version,
11508: P_Init_Msg_List => p_init_msg_list,
11513: X_Msg_Count => x_msg_count,
11514: X_Msg_Data => x_msg_data
11515: );
11516: IF l_debug = 'Y'
11517: THEN ASO_QUOTE_UTIL_PVT.Debug('Returning from ASO_RLTSHIP_PUB.Update_Object_Relationship');
11518: END IF;
11519:
11520: ELSIF p_operation_code = 'DELETE'
11521: THEN
11520: ELSIF p_operation_code = 'DELETE'
11521: THEN
11522: -- Call ASO API
11523: IF l_debug = 'Y'
11524: THEN ASO_QUOTE_UTIL_PVT.Debug('Begin calling ASO_RLTSHIP_PUB.Delete_Object_Relationship');
11525: END IF;
11526: ASO_RLTSHIP_PUB.Delete_Object_Relationship(
11527: P_Api_Version_Number => p_api_version,
11528: P_Init_Msg_List => p_init_msg_list,
11533: X_Msg_Count => x_msg_count,
11534: X_Msg_Data => x_msg_data
11535: );
11536: IF l_debug = 'Y'
11537: THEN ASO_QUOTE_UTIL_PVT.Debug('Returning from ASO_RLTSHIP_PUB.Delete_Object_Relationship');
11538: END IF;
11539:
11540: ELSE
11541: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11541: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11542:
11543: END IF;
11544: IF l_debug = 'Y' THEN
11545: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
11546: END IF;
11547:
11548: EXCEPTION
11549:
11555: p_count => x_msg_count,
11556: p_data => x_msg_data
11557: );
11558: IF l_debug = 'Y' THEN
11559: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
11560: END IF;
11561:
11562: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
11563: THEN
11567: p_count => x_msg_count,
11568: p_data => x_msg_data
11569: );
11570: IF l_debug = 'Y' THEN
11571: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
11572: END IF;
11573:
11574: WHEN OTHERS THEN
11575: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11584: p_encoded => FND_API.G_FALSE,
11585: p_count => x_msg_count,
11586: p_data => x_msg_data);
11587: IF l_debug = 'Y' THEN
11588: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
11589: END IF;
11590:
11591: END Update_Object_Relationship;
11592:
11767: lx_Ln_Shipment_Tbl Aso_Quote_Pub.Shipment_Tbl_Type;
11768: l_debug VARCHAR2(1);
11769: BEGIN
11770:
11771: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;
11772: IF l_debug = 'Y' THEN
11773: ASO_QUOTE_UTIL_PVT.Enable_Debug_Pvt;
11774: ASO_QUOTE_UTIL_PVT.debug('Aso_Quote_Pub_W.Tradein_Lines_from_InstallBase BEGIN');
11775: ASO_QUOTE_UTIL_PVT.debug('To Set_Control_Rec_W');
11769: BEGIN
11770:
11771: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;
11772: IF l_debug = 'Y' THEN
11773: ASO_QUOTE_UTIL_PVT.Enable_Debug_Pvt;
11774: ASO_QUOTE_UTIL_PVT.debug('Aso_Quote_Pub_W.Tradein_Lines_from_InstallBase BEGIN');
11775: ASO_QUOTE_UTIL_PVT.debug('To Set_Control_Rec_W');
11776: END IF;
11777:
11770:
11771: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;
11772: IF l_debug = 'Y' THEN
11773: ASO_QUOTE_UTIL_PVT.Enable_Debug_Pvt;
11774: ASO_QUOTE_UTIL_PVT.debug('Aso_Quote_Pub_W.Tradein_Lines_from_InstallBase BEGIN');
11775: ASO_QUOTE_UTIL_PVT.debug('To Set_Control_Rec_W');
11776: END IF;
11777:
11778: ASO_QUOTE_UTIL_PVT.Set_Control_Rec_W(
11771: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;
11772: IF l_debug = 'Y' THEN
11773: ASO_QUOTE_UTIL_PVT.Enable_Debug_Pvt;
11774: ASO_QUOTE_UTIL_PVT.debug('Aso_Quote_Pub_W.Tradein_Lines_from_InstallBase BEGIN');
11775: ASO_QUOTE_UTIL_PVT.debug('To Set_Control_Rec_W');
11776: END IF;
11777:
11778: ASO_QUOTE_UTIL_PVT.Set_Control_Rec_W(
11779: p_last_update_date => p_c_last_update_date,
11774: ASO_QUOTE_UTIL_PVT.debug('Aso_Quote_Pub_W.Tradein_Lines_from_InstallBase BEGIN');
11775: ASO_QUOTE_UTIL_PVT.debug('To Set_Control_Rec_W');
11776: END IF;
11777:
11778: ASO_QUOTE_UTIL_PVT.Set_Control_Rec_W(
11779: p_last_update_date => p_c_last_update_date,
11780: p_auto_version_flag => p_c_auto_version_flag,
11781: p_pricing_request_type => p_c_pricing_request_type,
11782: p_header_pricing_event => p_c_header_pricing_event,
11795: p_application_type_code => p_c_application_type_code,
11796: x_control_rec => l_control_rec);
11797:
11798: IF l_debug = 'Y' THEN
11799: ASO_QUOTE_UTIL_PVT.debug('To Construct_Qte_Header_Rec');
11800: END IF;
11801:
11802: l_qte_header_rec := ASO_QUOTE_UTIL_PVT.CONSTRUCT_Qte_Header_Rec(
11803: p_quote_header_id => p_q_quote_header_id ,
11798: IF l_debug = 'Y' THEN
11799: ASO_QUOTE_UTIL_PVT.debug('To Construct_Qte_Header_Rec');
11800: END IF;
11801:
11802: l_qte_header_rec := ASO_QUOTE_UTIL_PVT.CONSTRUCT_Qte_Header_Rec(
11803: p_quote_header_id => p_q_quote_header_id ,
11804: p_creation_date => p_q_creation_date ,
11805: p_created_by => p_q_created_by ,
11806: p_last_updated_by => p_q_last_updated_by ,
11930: p_supplier_signature_date => p_q_supplier_signature_date,
11931: p_credit_update_date => p_q_credit_update_date);
11932:
11933:
11934: l_instance_tbl := ASO_QUOTE_UTIL_PVT.CONSTRUCT_Instance_Tbl(
11935: p_instance_id => p_i_instance_id,
11936: p_price_list_id => p_i_price_list_id);
11937:
11938: IF l_debug = 'Y' THEN
11935: p_instance_id => p_i_instance_id,
11936: p_price_list_id => p_i_price_list_id);
11937:
11938: IF l_debug = 'Y' THEN
11939: ASO_QUOTE_UTIL_PVT.debug('p_q_quote_header_id '||p_q_quote_header_id);
11940: ASO_QUOTE_UTIL_PVT.debug('Aso_Tradein_Pvt.Add_Lines_from_InstallBase');
11941: END IF;
11942:
11943: -- Call ASO API
11936: p_price_list_id => p_i_price_list_id);
11937:
11938: IF l_debug = 'Y' THEN
11939: ASO_QUOTE_UTIL_PVT.debug('p_q_quote_header_id '||p_q_quote_header_id);
11940: ASO_QUOTE_UTIL_PVT.debug('Aso_Tradein_Pvt.Add_Lines_from_InstallBase');
11941: END IF;
11942:
11943: -- Call ASO API
11944: IF l_debug = 'Y'
11941: END IF;
11942:
11943: -- Call ASO API
11944: IF l_debug = 'Y'
11945: THEN ASO_QUOTE_UTIL_PVT.Debug('Begin calling Aso_Tradein_Pvt.Add_Lines_from_InstallBase');
11946: END IF;
11947: Aso_Tradein_Pvt.Add_Lines_from_InstallBase(
11948: P_Api_Version_Number => p_api_version_number ,
11949: P_Init_Msg_List => p_init_msg_list ,
11959: X_Return_Status => x_return_status ,
11960: X_Msg_Count => x_msg_count ,
11961: X_Msg_Data => x_msg_data);
11962: IF l_debug = 'Y'
11963: THEN ASO_QUOTE_UTIL_PVT.Debug('Returning from Aso_Tradein_Pvt.Add_Lines_from_InstallBase');
11964: END IF;
11965:
11966: x_q_quote_header_id := rosetta_g_miss_num_map(lx_qte_header_rec.quote_header_id);
11967: x_q_last_update_date := lx_qte_header_rec.last_update_date;
11966: x_q_quote_header_id := rosetta_g_miss_num_map(lx_qte_header_rec.quote_header_id);
11967: x_q_last_update_date := lx_qte_header_rec.last_update_date;
11968:
11969: IF l_debug = 'Y' THEN
11970: ASO_QUOTE_UTIL_PVT.debug('Quote Hdr Id '|| x_q_quote_header_id);
11971: ASO_QUOTE_UTIL_PVT.debug('Quote last updt DATE '|| x_q_last_update_date);
11972: END IF;
11973:
11974:
11967: x_q_last_update_date := lx_qte_header_rec.last_update_date;
11968:
11969: IF l_debug = 'Y' THEN
11970: ASO_QUOTE_UTIL_PVT.debug('Quote Hdr Id '|| x_q_quote_header_id);
11971: ASO_QUOTE_UTIL_PVT.debug('Quote last updt DATE '|| x_q_last_update_date);
11972: END IF;
11973:
11974:
11975: /*-- The following output parameters are ignored
12071: x_q_resource_id := rosetta_g_miss_num_map(lx_qte_header_rec.resource_id);
12072: */
12073:
12074: IF l_debug = 'Y' THEN
12075: ASO_QUOTE_UTIL_PVT.debug('TO Set_Qte_Line_Tbl_Out ');
12076: END IF;
12077:
12078: ASO_QUOTE_UTIL_PVT.Set_Qte_Line_Tbl_Out(
12079: p_qte_line_tbl => lx_qte_line_tbl ,
12074: IF l_debug = 'Y' THEN
12075: ASO_QUOTE_UTIL_PVT.debug('TO Set_Qte_Line_Tbl_Out ');
12076: END IF;
12077:
12078: ASO_QUOTE_UTIL_PVT.Set_Qte_Line_Tbl_Out(
12079: p_qte_line_tbl => lx_qte_line_tbl ,
12080: x_quote_line_id => x_ql_quote_line_id
12081:
12082: /*-- The following output parameters are ignored
12149: --*/
12150: );
12151:
12152: IF l_debug = 'Y' THEN
12153: ASO_QUOTE_UTIL_PVT.debug('TO Set_Qte_Line_Dtl_Tbl_Out ');
12154: END IF;
12155: ASO_QUOTE_UTIL_PVT.Set_Qte_Line_Dtl_Tbl_Out(
12156: p_qte_line_dtl_tbl => lx_qte_line_dtl_tbl ,
12157: x_quote_line_detail_id => x_qdl_quote_line_detail_id
12151:
12152: IF l_debug = 'Y' THEN
12153: ASO_QUOTE_UTIL_PVT.debug('TO Set_Qte_Line_Dtl_Tbl_Out ');
12154: END IF;
12155: ASO_QUOTE_UTIL_PVT.Set_Qte_Line_Dtl_Tbl_Out(
12156: p_qte_line_dtl_tbl => lx_qte_line_dtl_tbl ,
12157: x_quote_line_detail_id => x_qdl_quote_line_detail_id
12158:
12159: /*-- The following output parameters are ignored
12230: --*/
12231: );
12232:
12233: IF l_debug = 'Y' THEN
12234: ASO_QUOTE_UTIL_PVT.debug('TO Set_Shipment_Tbl_Out ');
12235: END IF;
12236: ASO_QUOTE_UTIL_PVT.Set_Shipment_Tbl_Out(
12237: p_qte_shipment_tbl => lx_ln_shipment_tbl ,
12238: x_shipment_id => x_qls_shipment_id
12232:
12233: IF l_debug = 'Y' THEN
12234: ASO_QUOTE_UTIL_PVT.debug('TO Set_Shipment_Tbl_Out ');
12235: END IF;
12236: ASO_QUOTE_UTIL_PVT.Set_Shipment_Tbl_Out(
12237: p_qte_shipment_tbl => lx_ln_shipment_tbl ,
12238: x_shipment_id => x_qls_shipment_id
12239:
12240: /*-- The following output parameters are ignored
12306: x_ship_from_org_id => x_qls_ship_from_org_id
12307: --*/
12308: );
12309: IF l_debug = 'Y' THEN
12310: ASO_QUOTE_UTIL_PVT.debug('X_Return_Status '||X_Return_Status);
12311: ASO_QUOTE_UTIL_PVT.debug('Aso_Quote_Pub_W.Tradein_Lines_from_InstallBase END');
12312: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
12313: END IF;
12314:
12307: --*/
12308: );
12309: IF l_debug = 'Y' THEN
12310: ASO_QUOTE_UTIL_PVT.debug('X_Return_Status '||X_Return_Status);
12311: ASO_QUOTE_UTIL_PVT.debug('Aso_Quote_Pub_W.Tradein_Lines_from_InstallBase END');
12312: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
12313: END IF;
12314:
12315: EXCEPTION
12308: );
12309: IF l_debug = 'Y' THEN
12310: ASO_QUOTE_UTIL_PVT.debug('X_Return_Status '||X_Return_Status);
12311: ASO_QUOTE_UTIL_PVT.debug('Aso_Quote_Pub_W.Tradein_Lines_from_InstallBase END');
12312: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
12313: END IF;
12314:
12315: EXCEPTION
12316: WHEN FND_API.G_EXC_ERROR
12321: p_count => x_msg_count,
12322: p_data => x_msg_data
12323: );
12324: IF l_debug = 'Y' THEN
12325: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
12326: END IF;
12327:
12328: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
12329: THEN
12333: p_count => x_msg_count,
12334: p_data => x_msg_data
12335: );
12336: IF l_debug = 'Y' THEN
12337: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
12338: END IF;
12339:
12340: WHEN OTHERS THEN
12341: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12351: p_count => x_msg_count,
12352: p_data => x_msg_data
12353: );
12354: IF l_debug = 'Y' THEN
12355: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
12356: END IF;
12357: END Tradein_Lines_from_InstallBase;
12358:
12359: PROCEDURE GET_DEFAULT_PARTY_SITES (
12403: l_api_name VARCHAR2(50) := 'GET_DEFAULT_PARTY_SITES';
12404: l_debug VARCHAR2(1);
12405: BEGIN
12406: -- Enable debug message
12407: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;
12408: IF l_debug = 'Y' THEN
12409: ASO_QUOTE_UTIL_PVT.Enable_Debug_Pvt;
12410: END IF;
12411:
12405: BEGIN
12406: -- Enable debug message
12407: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;
12408: IF l_debug = 'Y' THEN
12409: ASO_QUOTE_UTIL_PVT.Enable_Debug_Pvt;
12410: END IF;
12411:
12412: -- Standard Start of API savepoint
12413: SAVEPOINT GET_DEFAULT_PARY_SITES;
12486: p_data => x_msg_data
12487: );
12488: --disable the debug message
12489: IF l_debug = 'Y' THEN
12490: ASO_QUOTE_UTIL_PVT.disable_debug_pvt;
12491: END IF;
12492: EXCEPTION
12493: WHEN FND_API.G_EXC_ERROR THEN
12494: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
12499: ,X_MSG_COUNT => X_MSG_COUNT
12500: ,X_MSG_DATA => X_MSG_DATA
12501: ,X_RETURN_STATUS => X_RETURN_STATUS);
12502: IF l_debug = 'Y' THEN
12503: ASO_QUOTE_UTIL_PVT.disable_debug_pvt;
12504: END IF;
12505: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
12506: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
12507: P_API_NAME => L_API_NAME
12511: ,X_MSG_COUNT => X_MSG_COUNT
12512: ,X_MSG_DATA => X_MSG_DATA
12513: ,X_RETURN_STATUS => X_RETURN_STATUS);
12514: IF l_debug = 'Y' THEN
12515: ASO_QUOTE_UTIL_PVT.disable_debug_pvt;
12516: END IF;
12517: WHEN OTHERS THEN
12518: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
12519: P_API_NAME => L_API_NAME
12523: ,X_MSG_COUNT => X_MSG_COUNT
12524: ,X_MSG_DATA => X_MSG_DATA
12525: ,X_RETURN_STATUS => X_RETURN_STATUS);
12526: IF l_debug = 'Y' THEN
12527: ASO_QUOTE_UTIL_PVT.disable_debug_pvt;
12528: END IF;
12529: END GET_DEFAULT_PARTY_SITES;
12530:
12531: PROCEDURE Submit_Price_Tax_Req (
12695: BEGIN
12696:
12697: SAVEPOINT Submit_Price_Tax_Req;
12698:
12699: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;
12700: IF l_debug = 'Y'
12701: THEN
12702: ASO_QUOTE_UTIL_PVT.Enable_Debug_Pvt;
12703: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Submit_Price_Tax_Req Begins');
12698:
12699: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;
12700: IF l_debug = 'Y'
12701: THEN
12702: ASO_QUOTE_UTIL_PVT.Enable_Debug_Pvt;
12703: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Submit_Price_Tax_Req Begins');
12704: END IF;
12705:
12706: -- set l_control_rec
12699: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;
12700: IF l_debug = 'Y'
12701: THEN
12702: ASO_QUOTE_UTIL_PVT.Enable_Debug_Pvt;
12703: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Submit_Price_Tax_Req Begins');
12704: END IF;
12705:
12706: -- set l_control_rec
12707: ASO_QUOTE_UTIL_PVT.Set_Control_Rec_W(
12703: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Submit_Price_Tax_Req Begins');
12704: END IF;
12705:
12706: -- set l_control_rec
12707: ASO_QUOTE_UTIL_PVT.Set_Control_Rec_W(
12708: p_last_update_date => p_c_last_update_date,
12709: p_auto_version_flag => p_c_auto_version_flag,
12710: p_pricing_request_type => p_c_pricing_request_type,
12711: p_header_pricing_event => p_c_header_pricing_event,
12724: p_application_type_code => p_c_application_type_code,
12725: x_control_rec => l_control_rec);
12726:
12727: -- set l_quote_header_rec
12728: l_quote_header_rec := ASO_QUOTE_UTIL_PVT.CONSTRUCT_Qte_Header_Rec(
12729: p_quote_header_id => p_q_quote_header_id ,
12730: p_creation_date => p_q_creation_date ,
12731: p_created_by => p_q_created_by ,
12732: p_last_updated_by => p_q_last_updated_by ,
12857: p_object_version_number => p_q_object_version_number);
12858:
12859: -- Call ASO API
12860: IF l_debug = 'Y'
12861: THEN ASO_QUOTE_UTIL_PVT.Debug('Begin calling ASO_CONC_REQ_INT.Submit_Price_Tax_Req');
12862: END IF;
12863: ASO_CONC_REQ_INT.Submit_Price_Tax_Req(
12864: p_api_version_number => 1.0,
12865: p_init_msg_list => FND_API.G_TRUE,
12869: x_return_status => x_return_status,
12870: x_msg_count => x_msg_count,
12871: x_msg_data => x_msg_data);
12872: IF l_debug = 'Y'
12873: THEN ASO_QUOTE_UTIL_PVT.Debug('Returning from ASO_CONC_REQ_INT.Submit_Price_Tax_Req');
12874: END IF;
12875:
12876: -- standard call to get message count and if count is 1, get the message info
12877: FND_MSG_PUB.Count_And_Get(
12879: p_count => x_msg_count,
12880: p_data => x_msg_data);
12881:
12882: IF l_debug = 'Y' THEN
12883: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Submit_Price_Tax_Req: x_request_id = '||TO_CHAR(x_request_id));
12884: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Submit_Price_Tax_Req: x_return_status = '||x_return_status);
12885: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Submit_Price_Tax_Req: x_msg_count = '||TO_CHAR(x_msg_count));
12886: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Submit_Price_Tax_Req: x_msg_data = '||x_msg_data);
12887: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Submit_Price_Tax_Req Ends');
12880: p_data => x_msg_data);
12881:
12882: IF l_debug = 'Y' THEN
12883: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Submit_Price_Tax_Req: x_request_id = '||TO_CHAR(x_request_id));
12884: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Submit_Price_Tax_Req: x_return_status = '||x_return_status);
12885: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Submit_Price_Tax_Req: x_msg_count = '||TO_CHAR(x_msg_count));
12886: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Submit_Price_Tax_Req: x_msg_data = '||x_msg_data);
12887: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Submit_Price_Tax_Req Ends');
12888: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
12881:
12882: IF l_debug = 'Y' THEN
12883: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Submit_Price_Tax_Req: x_request_id = '||TO_CHAR(x_request_id));
12884: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Submit_Price_Tax_Req: x_return_status = '||x_return_status);
12885: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Submit_Price_Tax_Req: x_msg_count = '||TO_CHAR(x_msg_count));
12886: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Submit_Price_Tax_Req: x_msg_data = '||x_msg_data);
12887: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Submit_Price_Tax_Req Ends');
12888: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
12889: END IF;
12882: IF l_debug = 'Y' THEN
12883: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Submit_Price_Tax_Req: x_request_id = '||TO_CHAR(x_request_id));
12884: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Submit_Price_Tax_Req: x_return_status = '||x_return_status);
12885: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Submit_Price_Tax_Req: x_msg_count = '||TO_CHAR(x_msg_count));
12886: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Submit_Price_Tax_Req: x_msg_data = '||x_msg_data);
12887: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Submit_Price_Tax_Req Ends');
12888: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
12889: END IF;
12890:
12883: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Submit_Price_Tax_Req: x_request_id = '||TO_CHAR(x_request_id));
12884: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Submit_Price_Tax_Req: x_return_status = '||x_return_status);
12885: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Submit_Price_Tax_Req: x_msg_count = '||TO_CHAR(x_msg_count));
12886: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Submit_Price_Tax_Req: x_msg_data = '||x_msg_data);
12887: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Submit_Price_Tax_Req Ends');
12888: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
12889: END IF;
12890:
12891: EXCEPTION
12884: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Submit_Price_Tax_Req: x_return_status = '||x_return_status);
12885: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Submit_Price_Tax_Req: x_msg_count = '||TO_CHAR(x_msg_count));
12886: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Submit_Price_Tax_Req: x_msg_data = '||x_msg_data);
12887: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Submit_Price_Tax_Req Ends');
12888: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
12889: END IF;
12890:
12891: EXCEPTION
12892:
12897: FND_MSG_PUB.Count_And_Get(
12898: p_encoded => FND_API.G_FALSE,
12899: p_count => x_msg_count,
12900: p_data => x_msg_data);
12901: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
12902:
12903: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
12904: THEN
12905: ROLLBACK TO Submit_Price_Tax_Pvt;
12907: FND_MSG_PUB.Count_And_Get(
12908: p_encoded => FND_API.G_FALSE,
12909: p_count => x_msg_count,
12910: p_data => x_msg_data);
12911: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
12912:
12913: WHEN OTHERS
12914: THEN
12915: ROLLBACK TO Submit_Price_Tax_Pvt;
12926: FND_MSG_PUB.Count_And_Get(
12927: p_encoded => FND_API.G_FALSE,
12928: p_count => x_msg_count,
12929: p_data => x_msg_data);
12930: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
12931:
12932: END Submit_Price_Tax_Req;
12933:
12934: PROCEDURE Cancel_Price_Tax_Req (
13075: BEGIN
13076:
13077: SAVEPOINT Cancel_Price_Tax_Pvt;
13078:
13079: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;
13080: IF l_debug = 'Y' THEN
13081: ASO_QUOTE_UTIL_PVT.Enable_Debug_Pvt;
13082: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Cancel_Price_Tax_Req Begins');
13083: END IF;
13077: SAVEPOINT Cancel_Price_Tax_Pvt;
13078:
13079: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;
13080: IF l_debug = 'Y' THEN
13081: ASO_QUOTE_UTIL_PVT.Enable_Debug_Pvt;
13082: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Cancel_Price_Tax_Req Begins');
13083: END IF;
13084:
13085: -- set l_quote_header_rec
13078:
13079: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;
13080: IF l_debug = 'Y' THEN
13081: ASO_QUOTE_UTIL_PVT.Enable_Debug_Pvt;
13082: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Cancel_Price_Tax_Req Begins');
13083: END IF;
13084:
13085: -- set l_quote_header_rec
13086: l_quote_header_rec := ASO_QUOTE_UTIL_PVT.CONSTRUCT_Qte_Header_Rec(
13082: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Cancel_Price_Tax_Req Begins');
13083: END IF;
13084:
13085: -- set l_quote_header_rec
13086: l_quote_header_rec := ASO_QUOTE_UTIL_PVT.CONSTRUCT_Qte_Header_Rec(
13087: p_quote_header_id => p_q_quote_header_id ,
13088: p_creation_date => p_q_creation_date ,
13089: p_created_by => p_q_created_by ,
13090: p_last_updated_by => p_q_last_updated_by ,
13216: );
13217:
13218: -- Call ASO API
13219: IF l_debug = 'Y' THEN
13220: ASO_QUOTE_UTIL_PVT.Debug('Begin calling ASO_CONC_REQ_INT.Cancel_Price_Tax_Req');
13221: END IF;
13222: ASO_CONC_REQ_INT.Cancel_Price_Tax_Req(
13223: p_api_version_number => 1.0,
13224: p_init_msg_list => FND_API.G_TRUE,
13226: x_return_status => x_return_status,
13227: x_msg_count => x_msg_count,
13228: x_msg_data => x_msg_data);
13229: IF l_debug = 'Y' THEN
13230: ASO_QUOTE_UTIL_PVT.Debug('Returning from ASO_CONC_REQ_INT.Cancel_Price_Tax_Req');
13231: END IF;
13232:
13233: -- standard call to get message count and if count is 1, get the message info
13234: FND_MSG_PUB.Count_And_Get(
13236: p_count => x_msg_count,
13237: p_data => x_msg_data);
13238:
13239: IF l_debug = 'Y' THEN
13240: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Cancel_Price_Tax_Req: x_return_status = '||x_return_status);
13241: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Cancel_Price_Tax_Req: x_msg_count = '||TO_CHAR(x_msg_count));
13242: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Cancel_Price_Tax_Req: x_msg_data = '||x_msg_data);
13243: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Cancel_Price_Tax_Req Ends');
13244: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
13237: p_data => x_msg_data);
13238:
13239: IF l_debug = 'Y' THEN
13240: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Cancel_Price_Tax_Req: x_return_status = '||x_return_status);
13241: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Cancel_Price_Tax_Req: x_msg_count = '||TO_CHAR(x_msg_count));
13242: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Cancel_Price_Tax_Req: x_msg_data = '||x_msg_data);
13243: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Cancel_Price_Tax_Req Ends');
13244: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
13245: END IF;
13238:
13239: IF l_debug = 'Y' THEN
13240: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Cancel_Price_Tax_Req: x_return_status = '||x_return_status);
13241: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Cancel_Price_Tax_Req: x_msg_count = '||TO_CHAR(x_msg_count));
13242: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Cancel_Price_Tax_Req: x_msg_data = '||x_msg_data);
13243: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Cancel_Price_Tax_Req Ends');
13244: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
13245: END IF;
13246:
13239: IF l_debug = 'Y' THEN
13240: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Cancel_Price_Tax_Req: x_return_status = '||x_return_status);
13241: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Cancel_Price_Tax_Req: x_msg_count = '||TO_CHAR(x_msg_count));
13242: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Cancel_Price_Tax_Req: x_msg_data = '||x_msg_data);
13243: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Cancel_Price_Tax_Req Ends');
13244: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
13245: END IF;
13246:
13247: EXCEPTION
13240: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Cancel_Price_Tax_Req: x_return_status = '||x_return_status);
13241: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Cancel_Price_Tax_Req: x_msg_count = '||TO_CHAR(x_msg_count));
13242: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Cancel_Price_Tax_Req: x_msg_data = '||x_msg_data);
13243: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Cancel_Price_Tax_Req Ends');
13244: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
13245: END IF;
13246:
13247: EXCEPTION
13248:
13253: FND_MSG_PUB.Count_And_Get(
13254: p_encoded => FND_API.G_FALSE,
13255: p_count => x_msg_count,
13256: p_data => x_msg_data);
13257: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
13258:
13259: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
13260: THEN
13261: ROLLBACK TO Cancel_Price_Tax_Pvt;
13263: FND_MSG_PUB.Count_And_Get(
13264: p_encoded => FND_API.G_FALSE,
13265: p_count => x_msg_count,
13266: p_data => x_msg_data);
13267: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
13268:
13269: WHEN OTHERS
13270: THEN
13271: ROLLBACK TO Cancel_Price_Tax_Pvt;
13282: FND_MSG_PUB.Count_And_Get(
13283: p_encoded => FND_API.G_FALSE,
13284: p_count => x_msg_count,
13285: p_data => x_msg_data);
13286: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
13287:
13288: END Cancel_Price_Tax_Req;
13289:
13290: PROCEDURE Split_Quote_Line (
13692: l_debug VARCHAR2(1);
13693:
13694: BEGIN
13695:
13696: l_debug := ASO_QUOTE_UTIL_PVT.Is_Debug_Enabled;
13697: IF l_debug = 'Y' THEN
13698: ASO_QUOTE_UTIL_PVT.Enable_Debug_Pvt;
13699: END IF;
13700:
13694: BEGIN
13695:
13696: l_debug := ASO_QUOTE_UTIL_PVT.Is_Debug_Enabled;
13697: IF l_debug = 'Y' THEN
13698: ASO_QUOTE_UTIL_PVT.Enable_Debug_Pvt;
13699: END IF;
13700:
13701: -- set l_control_rec
13702: ASO_QUOTE_UTIL_PVT.Set_Control_Rec_W(
13698: ASO_QUOTE_UTIL_PVT.Enable_Debug_Pvt;
13699: END IF;
13700:
13701: -- set l_control_rec
13702: ASO_QUOTE_UTIL_PVT.Set_Control_Rec_W(
13703: p_last_update_date => p_c_last_update_date,
13704: p_auto_version_flag => p_c_auto_version_flag,
13705: p_pricing_request_type => p_c_pricing_request_type,
13706: p_header_pricing_event => p_c_header_pricing_event,
13719: p_application_type_code => p_c_application_type_code,
13720: x_control_rec => l_control_rec);
13721:
13722: -- set l_quote_header_rec
13723: l_quote_header_rec := ASO_QUOTE_UTIL_PVT.CONSTRUCT_Qte_Header_Rec(
13724: p_quote_header_id => p_q_quote_header_id ,
13725: p_creation_date => p_q_creation_date ,
13726: p_created_by => p_q_created_by ,
13727: p_last_updated_by => p_q_last_updated_by ,
13851: p_supplier_signature_date => p_q_supplier_signature_date,
13852: p_credit_update_date => p_q_credit_update_date);
13853:
13854: -- set original quote line record
13855: l_original_qte_line_rec := ASO_QUOTE_UTIL_PVT.CONSTRUCT_Qte_Line_Rec(
13856: p_creation_date => p_qlo_creation_date ,
13857: p_created_by => p_qlo_created_by ,
13858: p_last_updated_by => p_qlo_last_updated_by ,
13859: p_last_update_date => p_qlo_last_update_date ,
13931: p_display_arithmetic_operator => p_qlo_display_arithmetic_op,
13932: p_invoice_to_cust_party_id => p_qlo_invoice_to_cust_party_id);
13933:
13934: -- set quote line table
13935: l_qte_line_tbl := ASO_QUOTE_UTIL_PVT.CONSTRUCT_Qte_Line_Tbl(
13936: p_creation_date => p_ql_creation_date ,
13937: p_created_by => p_ql_created_by ,
13938: p_last_updated_by => p_ql_last_updated_by ,
13939: p_last_update_date => p_ql_last_update_date ,
14011: p_display_arithmetic_operator => p_ql_display_arithmetic_op,
14012: p_invoice_to_cust_party_id => p_ql_invoice_to_cust_party_id);
14013:
14014: -- set line shipment table
14015: l_ln_shipment_tbl := ASO_QUOTE_UTIL_PVT.CONSTRUCT_Shipment_Tbl(
14016: p_operation_code => p_qls_operation_code ,
14017: p_qte_line_index => p_qls_qte_line_index ,
14018: p_shipment_id => p_qls_shipment_id ,
14019: p_creation_date => p_qls_creation_date ,
14088: p_ship_to_cust_party_id => p_qls_ship_to_cust_party_id);
14089:
14090: -- Call ASO API
14091: IF l_debug = 'Y' THEN
14092: ASO_QUOTE_UTIL_PVT.Debug('Begin calling ASO_SPLIT_LINE_INT.Split_Quote_Line');
14093: END IF;
14094: ASO_SPLIT_LINE_INT.Split_Quote_Line(
14095: p_api_version_number => p_api_version_number,
14096: p_init_msg_list => p_init_msg_list,
14104: x_return_status => x_return_status,
14105: x_msg_count => x_msg_count,
14106: x_msg_data => x_msg_data);
14107: IF l_debug = 'Y' THEN
14108: ASO_QUOTE_UTIL_PVT.Debug('Returning from ASO_SPLIT_LINE_INT.Split_Quote_Line');
14109: END IF;
14110:
14111: ASO_Quote_Util_Pvt.Set_Qte_Line_Tbl_Out(
14112: p_qte_line_tbl => lx_qte_line_tbl,
14107: IF l_debug = 'Y' THEN
14108: ASO_QUOTE_UTIL_PVT.Debug('Returning from ASO_SPLIT_LINE_INT.Split_Quote_Line');
14109: END IF;
14110:
14111: ASO_Quote_Util_Pvt.Set_Qte_Line_Tbl_Out(
14112: p_qte_line_tbl => lx_qte_line_tbl,
14113: x_quote_line_id => x_ql_quote_line_id);
14114:
14115: ASO_Quote_Util_Pvt.Disable_Debug_Pvt;
14111: ASO_Quote_Util_Pvt.Set_Qte_Line_Tbl_Out(
14112: p_qte_line_tbl => lx_qte_line_tbl,
14113: x_quote_line_id => x_ql_quote_line_id);
14114:
14115: ASO_Quote_Util_Pvt.Disable_Debug_Pvt;
14116: END Split_Quote_Line;
14117:
14118: /* Calculates the rollup quote price for a configured model item */
14119: FUNCTION Get_Model_Rollup_Quote_Price (p_quote_line_id NUMBER)
14401: IS
14402: l_index NUMBER := px_line_tbl.COUNT + 1;
14403: l_debug VARCHAR2(1);
14404: BEGIN
14405: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;
14406: IF l_debug = 'Y' THEN
14407: ASO_QUOTE_UTIL_PVT.Enable_Debug_Pvt;
14408: END IF;
14409:
14403: l_debug VARCHAR2(1);
14404: BEGIN
14405: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;
14406: IF l_debug = 'Y' THEN
14407: ASO_QUOTE_UTIL_PVT.Enable_Debug_Pvt;
14408: END IF;
14409:
14410: px_line_tbl.EXTEND(1);
14411: px_line_tbl(l_index) := p_line_rec;
14410: px_line_tbl.EXTEND(1);
14411: px_line_tbl(l_index) := p_line_rec;
14412:
14413: IF l_debug = 'Y' THEN
14414: ASO_QUOTE_UTIL_PVT.Debug('Added quote line '||TO_CHAR(p_line_rec.quote_line_id));
14415: END IF;
14416: END; -- END OF Add_Line
14417:
14418:
14476: END;
14477:
14478: BEGIN
14479:
14480: l_debug := ASO_QUOTE_UTIL_PVT.Is_Debug_Enabled;
14481: IF l_debug = 'Y' THEN
14482: ASO_QUOTE_UTIL_PVT.Enable_Debug_Pvt;
14483: ASO_QUOTE_UTIL_PVT.Debug('ASO_QUOTE_PUB_W.Load_Lines_For_Display Begins');
14484: END IF;
14478: BEGIN
14479:
14480: l_debug := ASO_QUOTE_UTIL_PVT.Is_Debug_Enabled;
14481: IF l_debug = 'Y' THEN
14482: ASO_QUOTE_UTIL_PVT.Enable_Debug_Pvt;
14483: ASO_QUOTE_UTIL_PVT.Debug('ASO_QUOTE_PUB_W.Load_Lines_For_Display Begins');
14484: END IF;
14485:
14486: SAVEPOINT Load_Lines_For_Display_Pvt;
14479:
14480: l_debug := ASO_QUOTE_UTIL_PVT.Is_Debug_Enabled;
14481: IF l_debug = 'Y' THEN
14482: ASO_QUOTE_UTIL_PVT.Enable_Debug_Pvt;
14483: ASO_QUOTE_UTIL_PVT.Debug('ASO_QUOTE_PUB_W.Load_Lines_For_Display Begins');
14484: END IF;
14485:
14486: SAVEPOINT Load_Lines_For_Display_Pvt;
14487:
14508:
14509: /* retrieve all line information for all lines in a quote, and populate data
14510: into l_line_tbl */
14511: IF l_debug = 'Y' THEN
14512: ASO_QUOTE_UTIL_PVT.Debug('MAJOR LOOP: all line records in quote '||TO_CHAR(p_quote_header_id));
14513: END IF;
14514:
14515: FOR all_lines_info_rec IN C_All_Lines_Info(p_quote_header_id)
14516: LOOP
14515: FOR all_lines_info_rec IN C_All_Lines_Info(p_quote_header_id)
14516: LOOP
14517:
14518: IF l_debug = 'Y' THEN
14519: ASO_QUOTE_UTIL_PVT.Debug('quote_line_id = '||TO_CHAR(all_lines_info_rec.quote_line_id));
14520: END IF;
14521:
14522: /**
14523: now we are to add the following quote lines into l_line_tbl:
14615: END IF;
14616: END LOOP; -- END OF LOOP all line records in a quote
14617:
14618: IF l_debug = 'Y' THEN
14619: ASO_QUOTE_UTIL_PVT.Debug('END OF Major Loop...');
14620: END IF;
14621:
14622: /*
14623: now we have filtered out unwanted quote line records. loop through l_line_tbl,
14761: LOOP
14762: IF p_load_ln_man_prc_adj_flag = 'Y'
14763: THEN
14764: IF l_debug = 'Y' THEN
14765: ASO_QUOTE_UTIL_PVT.Debug('Calculating total line-level manual price adjusted amount for line ' || l_line_tbl(j).quote_line_id);
14766: END IF;
14767: OPEN C_Ttl_Line_Manu_Prc_Adj_Amt(l_line_tbl(j).quote_line_id);
14768: FETCH C_Ttl_Line_Manu_Prc_Adj_Amt INTO x_qlp_total_man_prc_adj_amt(j);
14769: CLOSE C_Ttl_Line_Manu_Prc_Adj_Amt;
14771:
14772: IF p_load_ln_tax_flag = 'Y'
14773: THEN
14774: IF l_debug = 'Y' THEN
14775: ASO_QUOTE_UTIL_PVT.Debug('Retrieving line-level tax details for line ' || l_line_tbl(j).quote_line_id);
14776: END IF;
14777: IF x_qlt_tax_quote_line_id IS NULL
14778: THEN x_qlt_tax_quote_line_id := JTF_NUMBER_TABLE();
14779: END IF;
14820:
14821: IF p_load_hdr_tax_flag = 'Y'
14822: THEN
14823: IF l_debug = 'Y' THEN
14824: ASO_QUOTE_UTIL_PVT.Debug('Retrieving total header-level tax details...');
14825: END IF;
14826: x_qt_tax_code := JTF_VARCHAR2_TABLE_100();
14827: x_qt_tax_amount := JTF_NUMBER_TABLE();
14828: x_qt_tax_inclusive_flag := JTF_VARCHAR2_TABLE_100();
14841:
14842: IF p_load_hdr_man_prc_adj_flag = 'Y'
14843: THEN
14844: IF l_debug = 'Y' THEN
14845: ASO_QUOTE_UTIL_PVT.Debug('Calculating total header-level manual price adjusted operand...');
14846: END IF;
14847: OPEN C_Ttl_Hdr_Manu_Prc_Adj_Op(p_quote_header_id);
14848: FETCH C_Ttl_Hdr_Manu_Prc_Adj_Op INTO x_qp_total_man_prc_adj_op;
14849: CLOSE C_Ttl_Hdr_Manu_Prc_Adj_Op;
14855: p_count => x_msg_count,
14856: p_data => x_msg_data);
14857:
14858: IF l_debug = 'Y' THEN
14859: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Load_Lines_For_Display Ends');
14860: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
14861: END IF;
14862:
14863: EXCEPTION
14856: p_data => x_msg_data);
14857:
14858: IF l_debug = 'Y' THEN
14859: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Load_Lines_For_Display Ends');
14860: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
14861: END IF;
14862:
14863: EXCEPTION
14864:
14871: ,X_MSG_COUNT => X_MSG_COUNT
14872: ,X_MSG_DATA => X_MSG_DATA
14873: ,X_RETURN_STATUS => X_RETURN_STATUS);
14874:
14875: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
14876: ROLLBACK TO Load_Lines_For_Display_Pvt;
14877:
14878: END;
14879:
15024: l_qte_header_rec ASO_Quote_Pub.qte_header_rec_type
15025: := ASO_Quote_Pub.G_MISS_Qte_Header_Rec;
15026: lx_qte_header_rec ASO_Quote_Pub.qte_header_rec_type;
15027: BEGIN
15028: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;
15029: --build ASO_QUOTE_PUB.Qte_Header_Rec_Type by calling ASO_QUOTE_UTIL_PVT.Construct_Qte_Header_Rec
15030:
15031: l_qte_header_rec := ASO_QUOTE_UTIL_PVT.Construct_Qte_Header_Rec(
15032: p_quote_header_id => p_q_quote_header_id ,
15025: := ASO_Quote_Pub.G_MISS_Qte_Header_Rec;
15026: lx_qte_header_rec ASO_Quote_Pub.qte_header_rec_type;
15027: BEGIN
15028: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;
15029: --build ASO_QUOTE_PUB.Qte_Header_Rec_Type by calling ASO_QUOTE_UTIL_PVT.Construct_Qte_Header_Rec
15030:
15031: l_qte_header_rec := ASO_QUOTE_UTIL_PVT.Construct_Qte_Header_Rec(
15032: p_quote_header_id => p_q_quote_header_id ,
15033: p_creation_date => p_q_creation_date ,
15027: BEGIN
15028: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;
15029: --build ASO_QUOTE_PUB.Qte_Header_Rec_Type by calling ASO_QUOTE_UTIL_PVT.Construct_Qte_Header_Rec
15030:
15031: l_qte_header_rec := ASO_QUOTE_UTIL_PVT.Construct_Qte_Header_Rec(
15032: p_quote_header_id => p_q_quote_header_id ,
15033: p_creation_date => p_q_creation_date ,
15034: p_created_by => p_q_created_by ,
15035: p_last_updated_by => p_q_last_updated_by ,
15160: p_credit_update_date => p_q_credit_update_date);
15161:
15162: -- Call ASO API
15163: IF l_debug = 'Y' THEN
15164: ASO_QUOTE_UTIL_PVT.Debug('Begin calling Aso_Security_Int.Assign_Sales_Team');
15165: END IF;
15166:
15167: ASO_SALES_TEAM_INT.Assign_Sales_Team(
15168: P_Init_Msg_List => P_Init_Msg_List,
15185: x_q_object_version_number := lx_qte_header_rec.object_version_number;
15186:
15187:
15188: IF l_debug = 'Y' THEN
15189: ASO_QUOTE_UTIL_PVT.Debug('Returning from Aso_Security_Int.Assign_Sales_Team');
15190: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
15191: END IF;
15192:
15193: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
15186:
15187:
15188: IF l_debug = 'Y' THEN
15189: ASO_QUOTE_UTIL_PVT.Debug('Returning from Aso_Security_Int.Assign_Sales_Team');
15190: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
15191: END IF;
15192:
15193: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
15194: RAISE FND_API.G_EXC_ERROR;
15206: p_count => x_msg_count,
15207: p_data => x_msg_data
15208: );
15209: IF l_debug = 'Y' THEN
15210: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
15211: END IF;
15212:
15213: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
15214: THEN
15218: p_count => x_msg_count,
15219: p_data => x_msg_data
15220: );
15221: IF l_debug = 'Y' THEN
15222: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
15223: END IF;
15224:
15225: WHEN OTHERS THEN
15226: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
15236: p_count => x_msg_count,
15237: p_data => x_msg_data
15238: );
15239: IF l_debug = 'Y' THEN
15240: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
15241: END IF;
15242: END Assign_sales_Team;
15243:
15244: PROCEDURE Allocate_Sales_Credits (
15391: l_qte_header_rec ASO_Quote_Pub.qte_header_rec_type
15392: := ASO_Quote_Pub.G_MISS_Qte_Header_Rec;
15393: lx_qte_header_rec ASO_Quote_Pub.qte_header_rec_type;
15394: BEGIN
15395: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;
15396: --build ASO_QUOTE_PUB.Qte_Header_Rec_Type by calling ASO_QUOTE_UTIL_PVT.Construct_Qte_Header_Rec
15397:
15398: l_qte_header_rec := ASO_QUOTE_UTIL_PVT.Construct_Qte_Header_Rec(
15399: p_quote_header_id => p_q_quote_header_id ,
15392: := ASO_Quote_Pub.G_MISS_Qte_Header_Rec;
15393: lx_qte_header_rec ASO_Quote_Pub.qte_header_rec_type;
15394: BEGIN
15395: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;
15396: --build ASO_QUOTE_PUB.Qte_Header_Rec_Type by calling ASO_QUOTE_UTIL_PVT.Construct_Qte_Header_Rec
15397:
15398: l_qte_header_rec := ASO_QUOTE_UTIL_PVT.Construct_Qte_Header_Rec(
15399: p_quote_header_id => p_q_quote_header_id ,
15400: p_creation_date => p_q_creation_date ,
15394: BEGIN
15395: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;
15396: --build ASO_QUOTE_PUB.Qte_Header_Rec_Type by calling ASO_QUOTE_UTIL_PVT.Construct_Qte_Header_Rec
15397:
15398: l_qte_header_rec := ASO_QUOTE_UTIL_PVT.Construct_Qte_Header_Rec(
15399: p_quote_header_id => p_q_quote_header_id ,
15400: p_creation_date => p_q_creation_date ,
15401: p_created_by => p_q_created_by ,
15402: p_last_updated_by => p_q_last_updated_by ,
15527: p_credit_update_date => p_q_credit_update_date);
15528:
15529: -- Call ASO API
15530: IF l_debug = 'Y' THEN
15531: ASO_QUOTE_UTIL_PVT.Debug('Begin calling ASO_QUOTE_PUB.Allocate_Sales_Credits');
15532: END IF;
15533:
15534: ASO_QUOTE_PUB.Allocate_Sales_Credits (
15535: P_Api_Version_Number => p_api_version_number ,
15555: x_q_object_version_number := lx_qte_header_rec.object_version_number;
15556:
15557:
15558: IF l_debug = 'Y' THEN
15559: ASO_QUOTE_UTIL_PVT.Debug('Returning from ASO_QUOTE_PUB.Allocate_Sales_Credits');
15560: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
15561: END IF;
15562:
15563: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
15556:
15557:
15558: IF l_debug = 'Y' THEN
15559: ASO_QUOTE_UTIL_PVT.Debug('Returning from ASO_QUOTE_PUB.Allocate_Sales_Credits');
15560: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
15561: END IF;
15562:
15563: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
15564: RAISE FND_API.G_EXC_ERROR;
15576: p_count => x_msg_count,
15577: p_data => x_msg_data
15578: );
15579: IF l_debug = 'Y' THEN
15580: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
15581: END IF;
15582:
15583: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
15584: THEN
15588: p_count => x_msg_count,
15589: p_data => x_msg_data
15590: );
15591: IF l_debug = 'Y' THEN
15592: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
15593: END IF;
15594:
15595: WHEN OTHERS THEN
15596: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
15606: p_count => x_msg_count,
15607: p_data => x_msg_data
15608: );
15609: IF l_debug = 'Y' THEN
15610: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
15611: END IF;
15612: END Allocate_Sales_Credits;
15613:
15614: PROCEDURE Calculate_Proj_Commission (
15757: l_debug VARCHAR2(1);
15758: l_qte_header_rec ASO_Quote_Pub.qte_header_rec_type
15759: := ASO_Quote_Pub.G_MISS_Qte_Header_Rec;
15760: BEGIN
15761: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;
15762: --build ASO_QUOTE_PUB.Qte_Header_Rec_Type by calling ASO_QUOTE_UTIL_PVT.Construct_Qte_Header_Rec
15763:
15764: l_qte_header_rec := ASO_QUOTE_UTIL_PVT.Construct_Qte_Header_Rec(
15765: p_quote_header_id => p_q_quote_header_id ,
15758: l_qte_header_rec ASO_Quote_Pub.qte_header_rec_type
15759: := ASO_Quote_Pub.G_MISS_Qte_Header_Rec;
15760: BEGIN
15761: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;
15762: --build ASO_QUOTE_PUB.Qte_Header_Rec_Type by calling ASO_QUOTE_UTIL_PVT.Construct_Qte_Header_Rec
15763:
15764: l_qte_header_rec := ASO_QUOTE_UTIL_PVT.Construct_Qte_Header_Rec(
15765: p_quote_header_id => p_q_quote_header_id ,
15766: p_creation_date => p_q_creation_date ,
15760: BEGIN
15761: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;
15762: --build ASO_QUOTE_PUB.Qte_Header_Rec_Type by calling ASO_QUOTE_UTIL_PVT.Construct_Qte_Header_Rec
15763:
15764: l_qte_header_rec := ASO_QUOTE_UTIL_PVT.Construct_Qte_Header_Rec(
15765: p_quote_header_id => p_q_quote_header_id ,
15766: p_creation_date => p_q_creation_date ,
15767: p_created_by => p_q_created_by ,
15768: p_last_updated_by => p_q_last_updated_by ,
15893: p_credit_update_date => p_q_credit_update_date);
15894:
15895: -- Call ASO API
15896: IF l_debug = 'Y' THEN
15897: ASO_QUOTE_UTIL_PVT.Debug('Begin calling ASO_Proj_Comm_Int.calculate_proj_commission ');
15898: END IF;
15899:
15900: ASO_Proj_Comm_Int.Calculate_Proj_Commission (
15901: P_Init_Msg_List => P_Init_Msg_List,
15917: );
15918:
15919:
15920: IF l_debug = 'Y' THEN
15921: ASO_QUOTE_UTIL_PVT.Debug('Returning from ASO_Proj_Comm_Int.calculate_proj_commission');
15922: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
15923: END IF;
15924:
15925: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
15918:
15919:
15920: IF l_debug = 'Y' THEN
15921: ASO_QUOTE_UTIL_PVT.Debug('Returning from ASO_Proj_Comm_Int.calculate_proj_commission');
15922: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
15923: END IF;
15924:
15925: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
15926: RAISE FND_API.G_EXC_ERROR;
15938: p_count => x_msg_count,
15939: p_data => x_msg_data
15940: );
15941: IF l_debug = 'Y' THEN
15942: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
15943: END IF;
15944:
15945: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
15946: THEN
15950: p_count => x_msg_count,
15951: p_data => x_msg_data
15952: );
15953: IF l_debug = 'Y' THEN
15954: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
15955: END IF;
15956:
15957: WHEN OTHERS THEN
15958: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
15968: p_count => x_msg_count,
15969: p_data => x_msg_data
15970: );
15971: IF l_debug = 'Y' THEN
15972: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
15973: END IF;
15974: END Calculate_Proj_Commission;
15975:
15976: PROCEDURE QA_check_for_contract (
16008: i NUMBER ;
16009: lx_qa_result_tbl OKC_TERMS_QA_GRP.qa_result_tbl_type;
16010: BEGIN
16011:
16012: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;
16013:
16014: IF l_debug = 'Y' THEN
16015: ASO_QUOTE_UTIL_PVT.Debug('Begin calling OKC_TERMS_QA_GRP.QA_doc');
16016: END IF;
16011:
16012: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;
16013:
16014: IF l_debug = 'Y' THEN
16015: ASO_QUOTE_UTIL_PVT.Debug('Begin calling OKC_TERMS_QA_GRP.QA_doc');
16016: END IF;
16017:
16018: OKC_TERMS_QA_GRP.QA_doc
16019: (
16037: p_data => x_msg_data
16038: );
16039:
16040: IF l_debug = 'Y' THEN
16041: ASO_QUOTE_UTIL_PVT.Debug('Returning from OKC_TERMS_QA_GRP.QA_doc');
16042: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
16043: END IF;
16044:
16045: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
16038: );
16039:
16040: IF l_debug = 'Y' THEN
16041: ASO_QUOTE_UTIL_PVT.Debug('Returning from OKC_TERMS_QA_GRP.QA_doc');
16042: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
16043: END IF;
16044:
16045: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
16046: RAISE FND_API.G_EXC_ERROR;
16127: p_count => x_msg_count,
16128: p_data => x_msg_data
16129: );
16130: IF l_debug = 'Y' THEN
16131: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
16132: END IF;
16133:
16134: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
16135: THEN
16139: p_count => x_msg_count,
16140: p_data => x_msg_data
16141: );
16142: IF l_debug = 'Y' THEN
16143: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
16144: END IF;
16145:
16146: WHEN OTHERS THEN
16147: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
16157: p_count => x_msg_count,
16158: p_data => x_msg_data
16159: );
16160: IF l_debug = 'Y' THEN
16161: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
16162: END IF;
16163: END QA_check_for_contract;
16164:
16165: PROCEDURE Get_UI_Line_Number (
16171: lx_Out_Line_Number_Tbl ASO_LINE_NUM_INT.Out_Line_Number_Tbl_Type;
16172:
16173: l_debug VARCHAR2(1);
16174: BEGIN
16175: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;
16176: IF l_debug = 'Y' THEN
16177: ASO_QUOTE_UTIL_PVT.Enable_Debug_Pvt;
16178: END IF;
16179:
16173: l_debug VARCHAR2(1);
16174: BEGIN
16175: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;
16176: IF l_debug = 'Y' THEN
16177: ASO_QUOTE_UTIL_PVT.Enable_Debug_Pvt;
16178: END IF;
16179:
16180: IF l_debug = 'Y' THEN
16181: ASO_QUOTE_UTIL_PVT.Debug('Begin calling ASO_LINE_NUM_INT.RESET_LINE_NUM');
16177: ASO_QUOTE_UTIL_PVT.Enable_Debug_Pvt;
16178: END IF;
16179:
16180: IF l_debug = 'Y' THEN
16181: ASO_QUOTE_UTIL_PVT.Debug('Begin calling ASO_LINE_NUM_INT.RESET_LINE_NUM');
16182: END IF;
16183:
16184: ASO_LINE_NUM_INT.RESET_LINE_NUM;
16185:
16183:
16184: ASO_LINE_NUM_INT.RESET_LINE_NUM;
16185:
16186: IF l_debug = 'Y' THEN
16187: ASO_QUOTE_UTIL_PVT.Debug('End calling ASO_LINE_NUM_INT.RESET_LINE_NUM');
16188: END IF;
16189:
16190: l_In_Line_Number_Tbl(1).quote_line_id := P_quote_line_id;
16191:
16189:
16190: l_In_Line_Number_Tbl(1).quote_line_id := P_quote_line_id;
16191:
16192: IF l_debug = 'Y' THEN
16193: ASO_QUOTE_UTIL_PVT.Debug('Begin calling ASO_LINE_NUM_INT.ASO_UI_LINE_NUMBER');
16194: END IF;
16195:
16196: ASO_LINE_NUM_INT.ASO_UI_LINE_NUMBER (
16197: P_In_Line_Number_Tbl => l_In_Line_Number_Tbl,
16198: X_Out_Line_Number_Tbl => lx_Out_Line_Number_Tbl
16199: );
16200:
16201: IF l_debug = 'Y' THEN
16202: ASO_QUOTE_UTIL_PVT.Debug('End calling ASO_LINE_NUM_INT.ASO_UI_LINE_NUMBER');
16203: END IF;
16204:
16205: X_UI_Line_Number := ASO_LINE_NUM_INT.Get_UI_Line_Number(P_quote_line_id);
16206:
16204:
16205: X_UI_Line_Number := ASO_LINE_NUM_INT.Get_UI_Line_Number(P_quote_line_id);
16206:
16207: IF l_debug = 'Y' THEN
16208: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
16209: END IF;
16210:
16211: END Get_UI_Line_Number;
16212:
16218: )
16219: AS
16220: l_debug VARCHAR2(1);
16221: BEGIN
16222: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;
16223: IF l_debug = 'Y' THEN
16224: ASO_QUOTE_UTIL_PVT.Enable_Debug_Pvt;
16225: END IF;
16226:
16220: l_debug VARCHAR2(1);
16221: BEGIN
16222: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;
16223: IF l_debug = 'Y' THEN
16224: ASO_QUOTE_UTIL_PVT.Enable_Debug_Pvt;
16225: END IF;
16226:
16227:
16228: IF l_debug = 'Y' THEN
16225: END IF;
16226:
16227:
16228: IF l_debug = 'Y' THEN
16229: ASO_QUOTE_UTIL_PVT.DEBUG('Begin calling ASO_UTILITY_PVT.GET_OU_ATTRIBUTE_VALUE');
16230: END IF;
16231:
16232: X_Attribute_Value :=
16233: ASO_UTILITY_PVT.GET_OU_ATTRIBUTE_VALUE (
16235: p_organization_id => P_Org_Id
16236: );
16237:
16238: IF l_debug = 'Y' THEN
16239: ASO_QUOTE_UTIL_PVT.DEBUG('End calling ASO_UTILITY_PVT.GET_OU_ATTRIBUTE_VALUE');
16240: END IF;
16241:
16242: IF l_debug = 'Y' THEN
16243: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
16239: ASO_QUOTE_UTIL_PVT.DEBUG('End calling ASO_UTILITY_PVT.GET_OU_ATTRIBUTE_VALUE');
16240: END IF;
16241:
16242: IF l_debug = 'Y' THEN
16243: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
16244: END IF;
16245:
16246: END get_ou_attribute_value;
16247: