eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ASO_QUOTE_LINES_PVT dependencies on ASO_VALIDATE_PVT

Line 370: ASO_VALIDATE_PVT.Validate_Promotion (

366: IF aso_debug_pub.g_debug_flag = 'Y' THEN
367: aso_debug_pub.add('Before calling Validate_Promotion price_attr_tbl.count: '|| p_price_attributes_tbl.count, 1, 'Y');
368: END IF;
369:
370: ASO_VALIDATE_PVT.Validate_Promotion (
371: P_Api_Version_Number => 1.0,
372: P_Init_Msg_List => FND_API.G_FALSE,
373: P_Commit => FND_API.G_FALSE,
374: p_price_attr_tbl => p_price_attributes_tbl,

Line 3102: ASO_VALIDATE_PVT.Validate_item_type_code(

3098:
3099: -- item type code must exist in aso_lookups and the item, item type
3100: -- should exist in mtl_system_items
3101:
3102: ASO_VALIDATE_PVT.Validate_item_type_code(
3103: p_init_msg_list => FND_API.G_FALSE,
3104: p_item_type_code => lx_qte_line_rec.item_type_code,
3105: x_return_status => x_return_status,
3106: x_msg_count => x_msg_count,

Line 3116: ASO_VALIDATE_PVT.Validate_Party (

3112:
3113: -- invoice_to_party_id must exist and be active in HZ_PARTIES,
3114: -- and have the usage INVOICE.
3115:
3116: ASO_VALIDATE_PVT.Validate_Party (
3117: p_init_msg_list => FND_API.G_FALSE,
3118: p_party_id => lx_qte_line_rec.invoice_to_party_id,
3119: p_party_usage => 'INVOICE',
3120: x_return_status => x_return_status,

Line 3132: ASO_VALIDATE_PVT.Validate_PriceList (

3128: aso_debug_pub.add('Create_Quote_lines - after validate_party ', 1, 'N');
3129: end if;
3130:
3131: -- price list must exist and be active in OE_PRICE_LISTS
3132: ASO_VALIDATE_PVT.Validate_PriceList (
3133: p_init_msg_list => FND_API.G_FALSE,
3134: p_price_list_id => lx_qte_line_rec.price_list_id,
3135: x_return_status => x_return_status,
3136: x_msg_count => x_msg_count,

Line 3144: ASO_VALIDATE_PVT.Validate_Quote_Price_Exp(

3140: RAISE FND_API.G_EXC_ERROR;
3141: END IF;
3142:
3143:
3144: ASO_VALIDATE_PVT.Validate_Quote_Price_Exp(
3145: p_init_msg_list => FND_API.G_FALSE,
3146: p_price_list_id => lx_qte_line_rec.price_list_id,
3147: p_quote_expiration_date => l_quote_exp_date,
3148: x_return_status => x_return_status,

Line 3159: ASO_VALIDATE_PVT.Validate_Party (

3155:
3156: -- shp_to_party_id must exist and be active in HZ_PARTIES and have the usage SHIP.
3157: For i in 1..lx_ln_shipment_tbl.count LOOP
3158:
3159: ASO_VALIDATE_PVT.Validate_Party (
3160: p_init_msg_list => FND_API.G_FALSE,
3161: p_party_id => lx_ln_shipment_tbl(i).ship_to_party_id,
3162: p_party_usage => 'SHIP',
3163: x_return_status => x_return_status,

Line 3173: ASO_VALIDATE_PVT.Validate_Marketing_Source_Code(

3169: END IF;
3170:
3171: END LOOP;
3172:
3173: ASO_VALIDATE_PVT.Validate_Marketing_Source_Code(
3174: p_init_msg_list => FND_API.G_FALSE,
3175: p_mkting_source_code_id => lx_qte_line_rec.marketing_source_code_id,
3176: x_return_status => x_return_status,
3177: x_msg_count => x_msg_count,

Line 3186: ASO_VALIDATE_PVT.Validate_Service_Duration(

3182: END IF;
3183:
3184: FOR i in 1..p_qte_line_dtl_tbl.count LOOP
3185:
3186: ASO_VALIDATE_PVT.Validate_Service_Duration(
3187: p_init_msg_list => FND_API.G_FALSE,
3188: p_service_duration => p_qte_line_dtl_tbl(i).service_duration,
3189: x_return_status => x_return_status,
3190: x_msg_count => x_msg_count,

Line 3208: ASO_VALIDATE_PVT.Validate_Resource_id(

3204: end if;
3205:
3206: if (p_sales_credit_tbl(i).operation_code = 'CREATE' or p_sales_credit_tbl(i).operation_code = 'UPDATE') then
3207:
3208: ASO_VALIDATE_PVT.Validate_Resource_id(
3209: p_init_msg_list => FND_API.G_FALSE,
3210: p_resource_id => p_sales_credit_tbl(i).resource_id,
3211: x_return_status => x_return_status,
3212: x_msg_count => x_msg_count,

Line 3225: ASO_VALIDATE_PVT.Validate_Resource_group_id(

3221: RAISE FND_API.G_EXC_ERROR;
3222:
3223: END IF;
3224:
3225: ASO_VALIDATE_PVT.Validate_Resource_group_id(
3226: p_init_msg_list => FND_API.G_FALSE,
3227: p_resource_group_id => p_sales_credit_tbl(i).resource_group_id,
3228: x_return_status => x_return_status,
3229: x_msg_count => x_msg_count,

Line 3236: ASO_VALIDATE_PVT.Validate_Salescredit_Type(

3232: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
3233: RAISE FND_API.G_EXC_ERROR;
3234: END IF;
3235:
3236: ASO_VALIDATE_PVT.Validate_Salescredit_Type(
3237: p_init_msg_list => FND_API.G_FALSE,
3238: p_salescredit_type_id => p_sales_credit_tbl(i).sales_credit_type_id,
3239: x_return_status => x_return_status,
3240: x_msg_count => x_msg_count,

Line 3247: ASO_VALIDATE_PVT.Validate_EmployPerson(

3243: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
3244: RAISE FND_API.G_EXC_ERROR;
3245: END IF;
3246:
3247: ASO_VALIDATE_PVT.Validate_EmployPerson(
3248: p_init_msg_list => FND_API.G_FALSE,
3249: p_employee_id => p_sales_credit_tbl(i).employee_person_id,
3250: x_return_status => x_return_status,
3251: x_msg_count => x_msg_count,

Line 3264: ASO_VALIDATE_PVT.Validate_Party_Type(

3260: END LOOP;
3261:
3262: FOR i in 1..p_quote_party_tbl.count LOOP
3263:
3264: ASO_VALIDATE_PVT.Validate_Party_Type(
3265: p_init_msg_list => FND_API.G_FALSE,
3266: p_party_type => p_quote_party_tbl(i).party_type,
3267: x_return_status => x_return_status,
3268: x_msg_count => x_msg_count,

Line 3275: ASO_VALIDATE_PVT.Validate_Party(

3271: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
3272: RAISE FND_API.G_EXC_ERROR;
3273: END IF;
3274:
3275: ASO_VALIDATE_PVT.Validate_Party(
3276: p_init_msg_list => FND_API.G_FALSE,
3277: p_party_id => p_quote_party_tbl(i).party_id,
3278: p_party_usage => null,
3279: x_return_status => x_return_status,

Line 3287: ASO_VALIDATE_PVT.Validate_Party_Object_Type(

3283: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
3284: RAISE FND_API.G_EXC_ERROR;
3285: END IF;
3286:
3287: ASO_VALIDATE_PVT.Validate_Party_Object_Type(
3288: p_init_msg_list => FND_API.G_FALSE,
3289: p_party_object_type => p_quote_party_tbl(i).party_object_type,
3290: x_return_status => x_return_status,
3291: x_msg_count => x_msg_count,

Line 3301: ASO_VALIDATE_PVT.Validate_MiniSite(

3297:
3298: END LOOP;
3299:
3300:
3301: ASO_VALIDATE_PVT.Validate_MiniSite(
3302: p_init_msg_list => FND_API.G_FALSE,
3303: p_minisite_id => lx_qte_line_rec.minisite_id,
3304: x_return_status => x_return_status,
3305: x_msg_count => x_msg_count,

Line 3311: ASO_VALIDATE_PVT.Validate_Section(

3307: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
3308: RAISE FND_API.G_EXC_ERROR;
3309: END IF;
3310:
3311: ASO_VALIDATE_PVT.Validate_Section(
3312: p_init_msg_list => FND_API.G_FALSE,
3313: p_section_id => lx_qte_line_rec.section_id,
3314: x_return_status => x_return_status,
3315: x_msg_count => x_msg_count,

Line 3360: ASO_VALIDATE_PVT.Validate_UOM_code(

3356:
3357:
3358: -- UOM must exist and should be in ASO_I_UNITS_OF_MEASURE
3359:
3360: ASO_VALIDATE_PVT.Validate_UOM_code(
3361: p_init_msg_list => FND_API.G_FALSE,
3362: p_uom_code => lx_qte_line_rec.uom_code,
3363: p_organization_id => l_organization_id,
3364: p_inventory_item_id => lx_qte_line_rec.inventory_item_id,

Line 3377: ASO_VALIDATE_PVT.Validate_For_GreaterEndDate (

3373: if aso_debug_pub.g_debug_flag = 'Y' THEN
3374: aso_debug_pub.add('Create_Quote_lines - After validate_UOM_code ', 1, 'N');
3375: end if;
3376:
3377: ASO_VALIDATE_PVT.Validate_For_GreaterEndDate (
3378: p_init_msg_list => FND_API.G_FALSE,
3379: p_start_date => lx_qte_line_rec.start_date_active,
3380: p_end_date => lx_qte_line_rec.end_date_active,
3381: x_return_status => x_return_status,

Line 3395: ASO_VALIDATE_PVT.Validate_Returns(

3391: RAISE FND_API.G_EXC_ERROR;
3392: END IF;
3393:
3394: FOR i in 1..p_qte_line_dtl_tbl.count LOOP
3395: ASO_VALIDATE_PVT.Validate_Returns(
3396: p_init_msg_list => FND_API.G_FALSE,
3397: p_return_ref_type_code => p_qte_line_dtl_tbl(i).return_ref_type,
3398: p_return_ref_header_id => p_qte_line_dtl_tbl(i).return_ref_header_id,
3399: p_return_ref_line_id => p_qte_line_dtl_tbl(i).return_ref_line_id,

Line 3417: ASO_VALIDATE_PVT.Validate_Tax_Exemption (

3413:
3414: -- tax_exempt_flag must be in 'E', 'R' and 'S'
3415: -- and tax_exempt_reason_code must exist if tax_exempt_flag is 'E'.
3416: FOR i in 1..p_tax_detail_tbl.count LOOP
3417: ASO_VALIDATE_PVT.Validate_Tax_Exemption (
3418: p_init_msg_list => FND_API.G_FALSE,
3419: p_tax_exempt_flag => p_tax_detail_tbl(i).tax_exempt_flag,
3420: p_tax_exempt_reason_code=> p_tax_detail_tbl(i).tax_exempt_reason_code,
3421: x_return_status => x_return_status,

Line 3450: ASO_VALIDATE_PVT.Validate_Configuration(

3446: p_qte_line_dtl_tbl(i).config_revision_num <> FND_API.G_MISS_NUM) AND
3447: (p_qte_line_dtl_tbl(i).config_item_id IS NOT NULL AND
3448: p_qte_line_dtl_tbl(i).config_item_id <> FND_API.G_MISS_NUM)) THEN
3449:
3450: ASO_VALIDATE_PVT.Validate_Configuration(
3451: p_init_msg_list => FND_API.G_FALSE,
3452: p_config_header_id => p_qte_line_dtl_tbl(i).config_header_id,
3453: p_config_revision_num => p_qte_line_dtl_tbl(i).config_revision_num,
3454: p_config_item_id => p_qte_line_dtl_tbl(i).config_item_id,

Line 3470: ASO_VALIDATE_PVT.Validate_Delayed_Service(

3466: END LOOP;
3467:
3468:
3469: FOR i in 1..p_qte_line_dtl_tbl.count LOOP
3470: ASO_VALIDATE_PVT.Validate_Delayed_Service(
3471: p_init_msg_list => FND_API.G_FALSE,
3472: p_service_ref_type_code
3473: => p_qte_line_dtl_tbl(i).service_ref_type_code,
3474: p_service_ref_line_id

Line 3494: ASO_VALIDATE_PVT.Validate_Party_Object_Id(

3490:
3491:
3492:
3493: FOR i in 1..p_quote_party_tbl.count LOOP
3494: ASO_VALIDATE_PVT.Validate_Party_Object_Id(
3495: p_init_msg_list => FND_API.G_FALSE,
3496: p_party_id => p_quote_party_tbl(i).party_id,
3497: p_party_object_type => p_quote_party_tbl(i).party_object_type,
3498: p_party_object_id => p_quote_party_tbl(i).party_object_id,

Line 3531: ASO_VALIDATE_PVT.Validate_ship_from_org_ID(

3527: IF lx_ln_shipment_tbl(1).ship_from_org_id IS NOT NULL AND lx_ln_shipment_tbl(1).ship_from_org_id <> FND_API.G_MISS_NUM THEN
3528: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3529: aso_debug_pub.add('ASO_QUOTE_LINES_PVT: Create_Quote_Lines: before Validate_ship_from_org_ID', 1, 'Y');
3530: end if;
3531: ASO_VALIDATE_PVT.Validate_ship_from_org_ID(
3532: P_qte_line_rec => lx_qte_line_rec,
3533: P_Shipment_rec => lx_ln_shipment_tbl(1),
3534: x_return_status => x_return_status);
3535:

Line 3578: ASO_VALIDATE_PVT.Validate_ship_from_org_ID(

3574: IF l_hd_shipment_rec.ship_from_org_id IS NOT NULL AND l_hd_shipment_rec.ship_from_org_id <> FND_API.G_MISS_NUM THEN
3575: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3576: aso_debug_pub.add('ASO_QUOTE_LINES_PVT: Create_Quote_Lines: before Validate_ship_from_org_ID (no ln_shipment_tbl)', 1, 'Y');
3577: end if;
3578: ASO_VALIDATE_PVT.Validate_ship_from_org_ID(
3579: P_Qte_Line_rec => lx_qte_line_rec,
3580: P_Shipment_rec => l_hd_shipment_rec,
3581: x_return_status => x_return_status
3582: );

Line 3718: ASO_VALIDATE_PVT.Validate_Inventory_Item(

3714: ASO_DEBUG_PUB.add('cq Inventory_item_id = '||l_qte_line_rec.inventory_item_id, 1, 'Y');
3715: END IF;
3716:
3717: -- validate inventory item id. item should be active
3718: ASO_VALIDATE_PVT.Validate_Inventory_Item(
3719: p_init_msg_list => FND_API.G_FALSE,
3720: p_inventory_item_id => l_qte_line_rec.inventory_item_id,
3721: p_organization_id => l_Qte_Line_Rec.organization_id,
3722: x_return_status => x_return_status,

Line 3737: ASO_VALIDATE_PVT.validate_ship_method_code

3733:
3734: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3735: aso_debug_pub.add('Create_Quote_lines - before validate ship_method_code ', 1, 'N');
3736: end if;
3737: ASO_VALIDATE_PVT.validate_ship_method_code
3738: (
3739: p_init_msg_list => fnd_api.g_false,
3740: p_qte_header_id => fnd_api.g_miss_num,
3741: p_qte_line_id => fnd_api.g_miss_num,

Line 3762: ASO_VALIDATE_PVT.Validate_Service(

3758:
3759:
3760: FOR i in 1..p_qte_line_dtl_tbl.count LOOP
3761:
3762: ASO_VALIDATE_PVT.Validate_Service(
3763: p_init_msg_list => FND_API.G_FALSE,
3764: p_inventory_item_id => l_qte_line_rec.inventory_item_id,
3765: p_start_date_active => l_qte_line_rec.start_date_active,
3766: p_end_date_active => l_qte_line_rec.end_date_active,

Line 3790: ASO_VALIDATE_PVT.Validate_UOM_code(

3786:
3787:
3788: --validate service period
3789:
3790: ASO_VALIDATE_PVT.Validate_UOM_code(
3791: p_init_msg_list => FND_API.G_FALSE,
3792: p_uom_code => p_qte_line_dtl_tbl(i).service_period,
3793: p_organization_id => l_qte_line_rec.organization_id,
3794: p_inventory_item_id => l_qte_line_rec.inventory_item_id,

Line 3853: aso_debug_pub.add('CREATE_QUOTE_LINES: Before calling aso_validate_pvt.validate_service_ref_line_id');

3849:
3850: else
3851:
3852: if aso_debug_pub.g_debug_flag = 'Y' then
3853: aso_debug_pub.add('CREATE_QUOTE_LINES: Before calling aso_validate_pvt.validate_service_ref_line_id');
3854: end if;
3855:
3856: aso_validate_pvt.validate_service_ref_line_id (
3857: p_init_msg_list => fnd_api.g_false,

Line 3856: aso_validate_pvt.validate_service_ref_line_id (

3852: if aso_debug_pub.g_debug_flag = 'Y' then
3853: aso_debug_pub.add('CREATE_QUOTE_LINES: Before calling aso_validate_pvt.validate_service_ref_line_id');
3854: end if;
3855:
3856: aso_validate_pvt.validate_service_ref_line_id (
3857: p_init_msg_list => fnd_api.g_false,
3858: p_service_ref_type_code => p_qte_line_dtl_tbl(i).service_ref_type_code,
3859: p_service_ref_line_id => p_qte_line_dtl_tbl(i).service_ref_line_id,
3860: p_qte_header_id => l_qte_line_rec.quote_header_id,

Line 3866: aso_debug_pub.add('CREATE_QUOTE_LINES: After calling aso_validate_pvt.validate_service_ref_line_id');

3862: x_msg_count => x_msg_count,
3863: x_msg_data => x_msg_data);
3864:
3865: if aso_debug_pub.g_debug_flag = 'Y' then
3866: aso_debug_pub.add('CREATE_QUOTE_LINES: After calling aso_validate_pvt.validate_service_ref_line_id');
3867: aso_debug_pub.add('CREATE_QUOTE_LINES: x_return_status: '|| x_return_status);
3868: end if;
3869:
3870: if x_return_status <> fnd_api.g_ret_sts_success then

Line 3947: ASO_validate_PVT.Validate_ln_type_for_ord_type(

3943: l_db_order_type_id := p_qte_header_rec.order_type_id;
3944: end if;
3945:
3946: If (l_db_order_type_id = l_qte_header_rec.order_type_id) and (l_qte_line_rec.order_line_type_id <> FND_API.G_MISS_NUM) then
3947: ASO_validate_PVT.Validate_ln_type_for_ord_type(
3948: p_init_msg_list => FND_API.G_FALSE,
3949: p_qte_header_rec => l_qte_header_rec,
3950: P_Qte_Line_rec => l_qte_line_rec,
3951: x_return_status => x_return_status,

Line 3964: aso_validate_pvt.Validate_po_line_number

3960: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
3961: aso_debug_pub.add('x_return_status for Validate_ln_type_for_ord_type'|| x_return_status, 1, 'Y');
3962: END IF;
3963:
3964: aso_validate_pvt.Validate_po_line_number
3965: (
3966: p_init_msg_list => fnd_api.g_false,
3967: p_qte_header_rec => l_qte_header_rec,
3968: P_Qte_Line_rec => l_qte_line_rec,

Line 4014: ASO_VALIDATE_PVT.Validate_Sales_Credit_Return(

4010: aso_debug_pub.add('ASO_QUOTE_LINES Create_Quote_lines - after validate_IB_Return_Qty '||x_return_status, 1, 'Y');
4011: end if;
4012:
4013: IF ( P_validation_level >= ASO_UTILITY_PVT.G_VALID_LEVEL_ITEM) THEN
4014: ASO_VALIDATE_PVT.Validate_Sales_Credit_Return(
4015: p_init_msg_list => FND_API.G_FALSE,
4016: p_sales_credit_tbl => p_sales_credit_tbl,
4017: p_qte_line_rec => l_qte_line_rec,
4018: x_return_status => x_return_status,

Line 4033: ASO_VALIDATE_PVT.Validate_Agreement(

4029: end if;
4030:
4031: IF (l_qte_line_rec.Agreement_Id IS NOT NULL AND
4032: l_qte_line_rec.Agreement_Id <> FND_API.G_MISS_NUM) THEN
4033: ASO_VALIDATE_PVT.Validate_Agreement(
4034: p_init_msg_list => FND_API.G_FALSE,
4035: P_Agreement_Id => l_qte_line_rec.Agreement_Id,
4036: x_return_status => x_return_status,
4037: x_msg_count => x_msg_count,

Line 4079: aso_validate_pvt.Validate_cc_info

4075: aso_debug_pub.add('Before calling Validate_cc_info ', 1, 'Y');
4076: END IF;
4077: l_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row (p_qte_line_rec.Quote_Header_Id );
4078:
4079: aso_validate_pvt.Validate_cc_info
4080: (
4081: p_init_msg_list => fnd_api.g_false,
4082: p_payment_rec => l_payment_rec,
4083: p_qte_header_rec => l_qte_header_rec,

Line 4212: ASO_VALIDATE_PVT.Validate_Quote_Percent(

4208: IF x_sales_credit_tbl(1).quote_line_id IS NULL OR x_sales_credit_tbl(1).quote_line_id = FND_API.G_MISS_NUM THEN
4209: x_sales_credit_tbl(1).quote_line_id := X_Qte_Line_Rec.quote_line_id;
4210: END IF;
4211:
4212: ASO_VALIDATE_PVT.Validate_Quote_Percent(
4213: p_init_msg_list => FND_API.G_FALSE,
4214: p_sales_credit_tbl => x_sales_credit_tbl,
4215: x_return_status => x_return_status,
4216: x_msg_count => x_msg_count,

Line 5256: ASO_VALIDATE_PVT.Validate_Item_Type_Code(

5252: end if;
5253:
5254: IF ( P_validation_level >= ASO_UTILITY_PVT.G_VALID_LEVEL_ITEM) THEN
5255:
5256: ASO_VALIDATE_PVT.Validate_Item_Type_Code(
5257: p_init_msg_list => FND_API.G_FALSE,
5258: p_item_type_code => lx_qte_line_rec.item_type_code,
5259: x_return_status => x_return_status,
5260: x_msg_count => x_msg_count,

Line 5269: ASO_VALIDATE_PVT.Validate_Party (

5265: END IF;
5266:
5267: -- invoice_to_party_id must exist and be active in HZ_PARTIES and have the usage INVOICE.
5268:
5269: ASO_VALIDATE_PVT.Validate_Party (
5270: p_init_msg_list => FND_API.G_FALSE,
5271: p_party_id => lx_qte_line_rec.invoice_to_party_id,
5272: p_party_usage => 'INVOICE',
5273: x_return_status => x_return_status,

Line 5285: ASO_VALIDATE_PVT.Validate_PartySite (

5281: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5282: RAISE FND_API.G_EXC_ERROR;
5283: END IF;
5284:
5285: ASO_VALIDATE_PVT.Validate_PartySite (
5286: p_init_msg_list => FND_API.G_FALSE,
5287: p_party_id => lx_qte_line_rec.invoice_to_party_id,
5288: p_party_site_id => lx_qte_line_rec.invoice_to_party_site_id,
5289: p_site_usage => 'INVOICE',

Line 5303: ASO_VALIDATE_PVT.Validate_PriceList (

5299: RAISE FND_API.G_EXC_ERROR;
5300: END IF;
5301:
5302: -- price list must exist and be active in OE_PRICE_LISTS
5303: ASO_VALIDATE_PVT.Validate_PriceList (
5304: p_init_msg_list => FND_API.G_FALSE,
5305: p_price_list_id => lx_qte_line_rec.price_list_id,
5306: x_return_status => x_return_status,
5307: x_msg_count => x_msg_count,

Line 5314: ASO_VALIDATE_PVT.Validate_Quote_Price_Exp(

5310: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5311: RAISE FND_API.G_EXC_ERROR;
5312: END IF;
5313:
5314: ASO_VALIDATE_PVT.Validate_Quote_Price_Exp(
5315: p_init_msg_list => FND_API.G_FALSE,
5316: p_price_list_id => lx_qte_line_rec.price_list_id,
5317: p_quote_expiration_date => l_quote_exp_date,
5318: x_return_status => x_return_status,

Line 5345: ASO_VALIDATE_PVT.Validate_Party (

5341: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5342: aso_debug_pub.add('before validating ship_to party: '||nvl(to_char(lx_ln_shipment_tbl(i).ship_to_party_id), 'null'),1,'N');
5343: end if;
5344:
5345: ASO_VALIDATE_PVT.Validate_Party (
5346: p_init_msg_list => FND_API.G_FALSE,
5347: p_party_id => lx_ln_shipment_tbl(i).ship_to_party_id,
5348: p_party_usage => 'SHIP',
5349: x_return_status => x_return_status,

Line 5365: ASO_VALIDATE_PVT.Validate_PartySite (

5361: if aso_debug_pub.g_debug_flag = 'Y' THEN
5362: aso_debug_pub.add('before validating ship_to party site: '||nvl(to_char(lx_ln_shipment_tbl(i).ship_to_party_site_id),'null'),1,'N');
5363: end if;
5364:
5365: ASO_VALIDATE_PVT.Validate_PartySite (
5366: p_init_msg_list => FND_API.G_FALSE,
5367: p_party_id => lx_ln_shipment_tbl(i).ship_to_party_id,
5368: p_party_site_id => lx_ln_shipment_tbl(i).ship_to_party_site_id,
5369: p_site_usage => 'SHIP',

Line 5385: ASO_VALIDATE_PVT.Validate_Marketing_Source_Code(

5381:
5382: End LOOP;
5383:
5384:
5385: ASO_VALIDATE_PVT.Validate_Marketing_Source_Code(
5386: p_init_msg_list => FND_API.G_FALSE,
5387: p_mkting_source_code_id => lx_qte_line_rec.marketing_source_code_id,
5388: x_return_status => x_return_status,
5389: x_msg_count => x_msg_count,

Line 5403: ASO_VALIDATE_PVT.Validate_Service_Duration(

5399:
5400:
5401: FOR i in 1..p_qte_line_dtl_tbl.count LOOP
5402:
5403: ASO_VALIDATE_PVT.Validate_Service_Duration(
5404: p_init_msg_list => FND_API.G_FALSE,
5405: p_service_duration => p_qte_line_dtl_tbl(i).service_duration,
5406: x_return_status => x_return_status,
5407: x_msg_count => x_msg_count,

Line 5429: ASO_VALIDATE_PVT.Validate_Resource_id(

5425: end if;
5426:
5427: if (p_sales_credit_tbl(i).operation_code = 'CREATE' or p_sales_credit_tbl(i).operation_code = 'UPDATE') then
5428:
5429: ASO_VALIDATE_PVT.Validate_Resource_id(
5430: p_init_msg_list => FND_API.G_FALSE,
5431: p_resource_id => p_sales_credit_tbl(i).resource_id ,
5432: x_return_status => x_return_status,
5433: x_msg_count => x_msg_count,

Line 5445: ASO_VALIDATE_PVT.Validate_Resource_group_id(

5441: END IF;
5442: RAISE FND_API.G_EXC_ERROR;
5443: END IF;
5444:
5445: ASO_VALIDATE_PVT.Validate_Resource_group_id(
5446: p_init_msg_list => FND_API.G_FALSE,
5447: p_resource_group_id => p_sales_credit_tbl(i).resource_group_id,
5448: x_return_status => x_return_status,
5449: x_msg_count => x_msg_count,

Line 5456: ASO_VALIDATE_PVT.Validate_Salescredit_Type(

5452: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
5453: RAISE FND_API.G_EXC_ERROR;
5454: END IF;
5455:
5456: ASO_VALIDATE_PVT.Validate_Salescredit_Type(
5457: p_init_msg_list => FND_API.G_FALSE,
5458: p_salescredit_type_id => p_sales_credit_tbl(i).sales_credit_type_id,
5459: x_return_status => x_return_status,
5460: x_msg_count => x_msg_count,

Line 5467: ASO_VALIDATE_PVT.Validate_EmployPerson(

5463: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
5464: RAISE FND_API.G_EXC_ERROR;
5465: END IF;
5466:
5467: ASO_VALIDATE_PVT.Validate_EmployPerson(
5468: p_init_msg_list => FND_API.G_FALSE,
5469: p_employee_id => p_sales_credit_tbl(i).employee_person_id,
5470: x_return_status => x_return_status,
5471: x_msg_count => x_msg_count,

Line 5486: ASO_VALIDATE_PVT.Validate_Party_Type(

5482:
5483: /* commented by bmishra on 12/15/2004 as we are not using quote_party_tbl
5484: FOR i in 1..p_quote_party_tbl.count LOOP
5485:
5486: ASO_VALIDATE_PVT.Validate_Party_Type(
5487: p_init_msg_list => FND_API.G_FALSE,
5488: p_party_type => p_quote_party_tbl(i).party_type,
5489: x_return_status => x_return_status,
5490: x_msg_count => x_msg_count,

Line 5497: ASO_VALIDATE_PVT.Validate_Party(

5493: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
5494: RAISE FND_API.G_EXC_ERROR;
5495: END IF;
5496:
5497: ASO_VALIDATE_PVT.Validate_Party(
5498: p_init_msg_list => FND_API.G_FALSE,
5499: p_party_id => p_quote_party_tbl(i).party_id,
5500: p_party_usage => null,
5501: x_return_status => x_return_status,

Line 5509: ASO_VALIDATE_PVT.Validate_Party_Object_Type(

5505: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
5506: RAISE FND_API.G_EXC_ERROR;
5507: END IF;
5508:
5509: ASO_VALIDATE_PVT.Validate_Party_Object_Type(
5510: p_init_msg_list => FND_API.G_FALSE,
5511: p_party_object_type => p_quote_party_tbl(i).party_object_type,
5512: x_return_status => x_return_status,
5513: x_msg_count => x_msg_count,

Line 5523: ASO_VALIDATE_PVT.Validate_MiniSite(

5519: END LOOP;
5520: */
5521:
5522:
5523: ASO_VALIDATE_PVT.Validate_MiniSite(
5524: p_init_msg_list => FND_API.G_FALSE,
5525: p_minisite_id => lx_qte_line_rec.minisite_id,
5526: x_return_status => x_return_status,
5527: x_msg_count => x_msg_count,

Line 5534: ASO_VALIDATE_PVT.Validate_Section(

5530: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
5531: RAISE FND_API.G_EXC_ERROR;
5532: END IF;
5533:
5534: ASO_VALIDATE_PVT.Validate_Section(
5535: p_init_msg_list => FND_API.G_FALSE,
5536: p_section_id => lx_qte_line_rec.section_id,
5537: x_return_status => x_return_status,
5538: x_msg_count => x_msg_count,

Line 5604: ASO_VALIDATE_PVT.Validate_UOM_code(

5600:
5601:
5602: -- UOM must exist and should be in ASO_I_UNITS_OF_MEASURE
5603:
5604: ASO_VALIDATE_PVT.Validate_UOM_code(
5605: p_init_msg_list => FND_API.G_FALSE,
5606: p_uom_code => lx_qte_line_rec.uom_code,
5607: p_organization_id => l_organization_id,
5608: p_inventory_item_id => l_inventory_item_id,

Line 5618: ASO_VALIDATE_PVT.Validate_For_GreaterEndDate (

5614: RAISE FND_API.G_EXC_ERROR;
5615: END IF;
5616:
5617:
5618: ASO_VALIDATE_PVT.Validate_For_GreaterEndDate (
5619: p_init_msg_list => FND_API.G_FALSE,
5620: p_start_date => lx_qte_line_rec.start_date_active,
5621: p_end_date => lx_qte_line_rec.end_date_active,
5622: x_return_status => x_return_status,

Line 5642: ASO_VALIDATE_PVT.Validate_Returns(

5638: end if;
5639:
5640: FOR i in 1..p_qte_line_dtl_tbl.count LOOP
5641:
5642: ASO_VALIDATE_PVT.Validate_Returns(
5643: p_init_msg_list => FND_API.G_FALSE,
5644: p_return_ref_type_code => p_qte_line_dtl_tbl(i).return_ref_type,
5645: p_return_ref_header_id => p_qte_line_dtl_tbl(i).return_ref_header_id,
5646: p_return_ref_line_id => p_qte_line_dtl_tbl(i).return_ref_line_id,

Line 5672: ASO_VALIDATE_PVT.Validate_Tax_Exemption (

5668: -- and tax_exempt_reason_code must exist if tax_exempt_flag is 'E'.
5669:
5670: FOR i in 1..p_tax_detail_tbl.count LOOP
5671:
5672: ASO_VALIDATE_PVT.Validate_Tax_Exemption (
5673: p_init_msg_list => FND_API.G_FALSE,
5674: p_tax_exempt_flag => p_tax_detail_tbl(i).tax_exempt_flag,
5675: p_tax_exempt_reason_code => p_tax_detail_tbl(i).tax_exempt_reason_code,
5676: x_return_status => x_return_status,

Line 5712: ASO_VALIDATE_PVT.Validate_Configuration(

5708: p_qte_line_dtl_tbl(i).config_revision_num <> FND_API.G_MISS_NUM) AND
5709: (p_qte_line_dtl_tbl(i).config_item_id IS NOT NULL AND
5710: p_qte_line_dtl_tbl(i).config_item_id <> FND_API.G_MISS_NUM)) THEN
5711:
5712: ASO_VALIDATE_PVT.Validate_Configuration(
5713: p_init_msg_list => FND_API.G_FALSE,
5714: p_config_header_id => p_qte_line_dtl_tbl(i).config_header_id,
5715: p_config_revision_num => p_qte_line_dtl_tbl(i).config_revision_num,
5716: p_config_item_id => p_qte_line_dtl_tbl(i).config_item_id,

Line 5745: ASO_VALIDATE_PVT.Validate_Delayed_Service(

5741: end if;
5742:
5743: FOR i in 1..p_qte_line_dtl_tbl.count LOOP
5744:
5745: ASO_VALIDATE_PVT.Validate_Delayed_Service(
5746: p_init_msg_list => FND_API.G_FALSE,
5747: p_service_ref_type_code => p_qte_line_dtl_tbl(i).service_ref_type_code,
5748: p_service_ref_line_id => p_qte_line_dtl_tbl(i).service_ref_line_id,
5749: p_service_ref_system_id => p_qte_line_dtl_tbl(i).service_ref_system_id,

Line 5774: ASO_VALIDATE_PVT.Validate_Party_Object_Id(

5770: /* commented by bmishra on 12/15/2004 as quote_party_tbl is obsoleted
5771:
5772: FOR i in 1..p_quote_party_tbl.count LOOP
5773:
5774: ASO_VALIDATE_PVT.Validate_Party_Object_Id(
5775: p_init_msg_list => FND_API.G_FALSE,
5776: p_party_id => p_quote_party_tbl(i).party_id,
5777: p_party_object_type => p_quote_party_tbl(i).party_object_type,
5778: p_party_object_id => p_quote_party_tbl(i).party_object_id,

Line 5826: ASO_VALIDATE_PVT.Validate_ship_from_org_ID(

5822: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5823: aso_debug_pub.add('ASO_QUOTE_LINES_PVT: Update_Quote_Line: before Validate_ship_from_org_ID', 1, 'Y');
5824: end if;
5825:
5826: ASO_VALIDATE_PVT.Validate_ship_from_org_ID(
5827: P_Qte_Line_rec => lx_qte_line_rec,
5828: P_Shipment_rec => lx_ln_shipment_tbl(1),
5829: x_return_status => x_return_status);
5830:

Line 5873: ASO_VALIDATE_PVT.Validate_ship_from_org_ID(

5869: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5870: aso_debug_pub.add('Update_Quote_Line: before Validate_ship_from_org_ID (no lx_ln_shipment_tbl)', 1, 'Y');
5871: end if;
5872:
5873: ASO_VALIDATE_PVT.Validate_ship_from_org_ID(
5874: P_Qte_Line_rec => lx_qte_line_rec,
5875: P_Shipment_rec => l_db_shipment_rec,
5876: x_return_status => x_return_status);
5877:

Line 5921: ASO_VALIDATE_PVT.Validate_ship_from_org_ID(

5917: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5918: aso_debug_pub.add('Update_Quote_Line: before Validate_ship_from_org_ID (no db_shipment_tbl)', 1, 'Y');
5919: end if;
5920:
5921: ASO_VALIDATE_PVT.Validate_ship_from_org_ID(
5922: P_Qte_Line_rec => lx_qte_line_rec,
5923: P_Shipment_rec => l_hd_shipment_rec,
5924: x_return_status => x_return_status);
5925:

Line 6111: ASO_VALIDATE_PVT.Validate_Inventory_Item(

6107: END IF;
6108:
6109: IF l_Qte_Line_Rec.inventory_item_id <> FND_API.G_MISS_NUM THEN
6110:
6111: ASO_VALIDATE_PVT.Validate_Inventory_Item(
6112: p_init_msg_list => FND_API.G_FALSE,
6113: p_inventory_item_id => l_Qte_Line_Rec.inventory_item_id,
6114: p_organization_id => l_Qte_Line_Rec.organization_id,
6115: x_return_status => x_return_status,

Line 6137: ASO_VALIDATE_PVT.validate_ship_method_code

6133: IF aso_debug_pub.g_debug_flag = 'Y' THEN
6134: aso_debug_pub.add('Update_Quote_line - ship method codeof quote line is being updated ', 1, 'N');
6135: aso_debug_pub.add('Update_Quote_line - before validate ship_method_code ', 1, 'N');
6136: end if;
6137: ASO_VALIDATE_PVT.validate_ship_method_code
6138: (
6139: p_init_msg_list => fnd_api.g_false,
6140: p_qte_header_id => lx_qte_line_rec.quote_header_id,
6141: p_qte_line_id => lx_qte_line_rec.quote_line_id,

Line 6163: ASO_VALIDATE_PVT.validate_ship_method_code

6159: IF aso_debug_pub.g_debug_flag = 'Y' THEN
6160: aso_debug_pub.add('Update_Quote_line - Organization id of quote line is being updated ', 1, 'N');
6161: aso_debug_pub.add('Update_Quote_line - before validate ship_method_code ', 1, 'N');
6162: end if;
6163: ASO_VALIDATE_PVT.validate_ship_method_code
6164: (
6165: p_init_msg_list => fnd_api.g_false,
6166: p_qte_header_id => lx_qte_line_rec.quote_header_id,
6167: p_qte_line_id => lx_qte_line_rec.quote_line_id,

Line 6216: ASO_VALIDATE_PVT.Validate_Service(

6212: END IF;
6213:
6214: END IF;
6215:
6216: ASO_VALIDATE_PVT.Validate_Service(
6217: p_init_msg_list => FND_API.G_FALSE,
6218: p_inventory_item_id => l_Qte_Line_Rec.inventory_item_id,
6219: p_start_date_active => l_Qte_Line_Rec.start_date_active,
6220: p_end_date_active => l_Qte_Line_Rec.end_date_active,

Line 6247: ASO_VALIDATE_PVT.Validate_UOM_code(

6243: END IF;
6244:
6245: --validate service period
6246:
6247: ASO_VALIDATE_PVT.Validate_UOM_code(
6248: p_init_msg_list => FND_API.G_FALSE,
6249: p_uom_code => l_qte_line_dtl_tbl(i).service_period,
6250: p_organization_id => l_Qte_Line_Rec.organization_id,
6251: p_inventory_item_id => l_Qte_Line_Rec.inventory_item_id,

Line 6338: aso_debug_pub.add('UPDATE_QUOTE_LINE: Before calling aso_validate_pvt.validate_service_ref_line_id');

6334:
6335: if aso_debug_pub.g_debug_flag = 'Y' then
6336: aso_debug_pub.add('l_service_ref_type_code: ' || l_service_ref_type_code);
6337: aso_debug_pub.add('l_qte_line_dtl_tbl('||i||').service_ref_line_id: ' || l_qte_line_dtl_tbl(i).service_ref_line_id);
6338: aso_debug_pub.add('UPDATE_QUOTE_LINE: Before calling aso_validate_pvt.validate_service_ref_line_id');
6339: end if;
6340:
6341: aso_validate_pvt.validate_service_ref_line_id (
6342: p_init_msg_list => fnd_api.g_false,

Line 6341: aso_validate_pvt.validate_service_ref_line_id (

6337: aso_debug_pub.add('l_qte_line_dtl_tbl('||i||').service_ref_line_id: ' || l_qte_line_dtl_tbl(i).service_ref_line_id);
6338: aso_debug_pub.add('UPDATE_QUOTE_LINE: Before calling aso_validate_pvt.validate_service_ref_line_id');
6339: end if;
6340:
6341: aso_validate_pvt.validate_service_ref_line_id (
6342: p_init_msg_list => fnd_api.g_false,
6343: p_service_ref_type_code => l_service_ref_type_code,
6344: p_service_ref_line_id => l_qte_line_dtl_tbl(i).service_ref_line_id,
6345: p_qte_header_id => l_Qte_Line_Rec.quote_header_id,

Line 6351: aso_debug_pub.add('UPDATE_QUOTE_LINE: After calling aso_validate_pvt.validate_service_ref_line_id');

6347: x_msg_count => x_msg_count,
6348: x_msg_data => x_msg_data);
6349:
6350: if aso_debug_pub.g_debug_flag = 'Y' then
6351: aso_debug_pub.add('UPDATE_QUOTE_LINE: After calling aso_validate_pvt.validate_service_ref_line_id');
6352: aso_debug_pub.add('UPDATE_QUOTE_LINE: x_return_status: '|| x_return_status);
6353: end if;
6354:
6355: if x_return_status <> fnd_api.g_ret_sts_success then

Line 6446: ASO_validate_PVT.Validate_ln_type_for_ord_type(

6442: end if;
6443:
6444: If (l_db_order_type_id = l_qte_header_rec.order_type_id) and (l_Qte_Line_Rec.order_line_type_id <> FND_API.G_MISS_NUM) Then
6445:
6446: ASO_validate_PVT.Validate_ln_type_for_ord_type(
6447: p_init_msg_list => FND_API.G_FALSE,
6448: p_qte_header_rec => l_qte_header_rec,
6449: P_Qte_Line_rec => l_Qte_Line_Rec,
6450: x_return_status => x_return_status,

Line 6498: ASO_VALIDATE_PVT.Validate_Sales_Credit_Return(

6494: end if;
6495:
6496: IF ( P_validation_level >= ASO_UTILITY_PVT.G_VALID_LEVEL_ITEM) THEN
6497:
6498: ASO_VALIDATE_PVT.Validate_Sales_Credit_Return(
6499: p_init_msg_list => FND_API.G_FALSE,
6500: p_sales_credit_tbl => p_sales_credit_tbl,
6501: p_qte_line_rec => l_Qte_Line_Rec,
6502: x_return_status => x_return_status,

Line 6518: ASO_VALIDATE_PVT.Validate_Agreement(

6514: end if;
6515:
6516: IF (l_Qte_Line_Rec.Agreement_Id IS NOT NULL AND l_Qte_Line_Rec.Agreement_Id <> FND_API.G_MISS_NUM) THEN
6517:
6518: ASO_VALIDATE_PVT.Validate_Agreement(
6519: p_init_msg_list => FND_API.G_FALSE,
6520: P_Agreement_Id => l_Qte_Line_Rec.Agreement_Id,
6521: x_return_status => x_return_status,
6522: x_msg_count => x_msg_count,

Line 6562: aso_validate_pvt.Validate_cc_info

6558: aso_debug_pub.add('Before calling Validate_cc_info ', 1, 'Y');
6559: END IF;
6560: l_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row (l_qte_line_rec.Quote_Header_Id );
6561:
6562: aso_validate_pvt.Validate_cc_info
6563: (
6564: p_init_msg_list => fnd_api.g_false,
6565: p_payment_rec => l_payment_rec,
6566: p_qte_header_rec => l_qte_header_rec,

Line 7212: ASO_VALIDATE_PVT.Validate_Quote_Percent(

7208: IF x_sales_credit_tbl(1).quote_line_id IS NULL OR x_sales_credit_tbl(1).quote_line_id = FND_API.G_MISS_NUM THEN
7209: x_sales_credit_tbl(1).quote_line_id := l_qte_line_rec.quote_line_id;
7210: END IF;
7211:
7212: ASO_VALIDATE_PVT.Validate_Quote_Percent(
7213: p_init_msg_list => FND_API.G_FALSE,
7214: p_sales_credit_tbl => x_sales_credit_tbl,
7215: x_return_status => x_return_status,
7216: x_msg_count => x_msg_count,

Line 7232: ASO_VALIDATE_PVT.Validate_Promotion (

7228: IF aso_debug_pub.g_debug_flag = 'Y' THEN
7229: aso_debug_pub.add('Before calling Validate_Promotion price_attr_tbl.count: '|| p_price_attributes_tbl.count, 1, 'Y');
7230: END IF;
7231:
7232: ASO_VALIDATE_PVT.Validate_Promotion (
7233: P_Api_Version_Number => 1.0,
7234: P_Init_Msg_List => FND_API.G_FALSE,
7235: P_Commit => FND_API.G_FALSE,
7236: p_price_attr_tbl => p_price_attributes_tbl,

Line 8599: aso_validate_pvt.Validate_po_line_number

8595:
8596: END LOOP; -- payment loop
8597:
8598: -- fix for bug 4483808 , moved validation after the row has been updated
8599: aso_validate_pvt.Validate_po_line_number
8600: (
8601: p_init_msg_list => fnd_api.g_false,
8602: p_qte_header_rec => l_qte_header_rec,
8603: P_Qte_Line_rec => l_Qte_Line_Rec,