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 5374: ASO_VALIDATE_PVT.Validate_Item_Type_Code(

5370: end if;
5371:
5372: IF ( P_validation_level >= ASO_UTILITY_PVT.G_VALID_LEVEL_ITEM) THEN
5373:
5374: ASO_VALIDATE_PVT.Validate_Item_Type_Code(
5375: p_init_msg_list => FND_API.G_FALSE,
5376: p_item_type_code => lx_qte_line_rec.item_type_code,
5377: x_return_status => x_return_status,
5378: x_msg_count => x_msg_count,

Line 5387: ASO_VALIDATE_PVT.Validate_Party (

5383: END IF;
5384:
5385: -- invoice_to_party_id must exist and be active in HZ_PARTIES and have the usage INVOICE.
5386:
5387: ASO_VALIDATE_PVT.Validate_Party (
5388: p_init_msg_list => FND_API.G_FALSE,
5389: p_party_id => lx_qte_line_rec.invoice_to_party_id,
5390: p_party_usage => 'INVOICE',
5391: x_return_status => x_return_status,

Line 5403: ASO_VALIDATE_PVT.Validate_PartySite (

5399: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5400: RAISE FND_API.G_EXC_ERROR;
5401: END IF;
5402:
5403: ASO_VALIDATE_PVT.Validate_PartySite (
5404: p_init_msg_list => FND_API.G_FALSE,
5405: p_party_id => lx_qte_line_rec.invoice_to_party_id,
5406: p_party_site_id => lx_qte_line_rec.invoice_to_party_site_id,
5407: p_site_usage => 'INVOICE',

Line 5421: ASO_VALIDATE_PVT.Validate_PriceList (

5417: RAISE FND_API.G_EXC_ERROR;
5418: END IF;
5419:
5420: -- price list must exist and be active in OE_PRICE_LISTS
5421: ASO_VALIDATE_PVT.Validate_PriceList (
5422: p_init_msg_list => FND_API.G_FALSE,
5423: p_price_list_id => lx_qte_line_rec.price_list_id,
5424: x_return_status => x_return_status,
5425: x_msg_count => x_msg_count,

Line 5432: ASO_VALIDATE_PVT.Validate_Quote_Price_Exp(

5428: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5429: RAISE FND_API.G_EXC_ERROR;
5430: END IF;
5431:
5432: ASO_VALIDATE_PVT.Validate_Quote_Price_Exp(
5433: p_init_msg_list => FND_API.G_FALSE,
5434: p_price_list_id => lx_qte_line_rec.price_list_id,
5435: p_quote_expiration_date => l_quote_exp_date,
5436: x_return_status => x_return_status,

Line 5463: ASO_VALIDATE_PVT.Validate_Party (

5459: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5460: aso_debug_pub.add('before validating ship_to party: '||nvl(to_char(lx_ln_shipment_tbl(i).ship_to_party_id), 'null'),1,'N');
5461: end if;
5462:
5463: ASO_VALIDATE_PVT.Validate_Party (
5464: p_init_msg_list => FND_API.G_FALSE,
5465: p_party_id => lx_ln_shipment_tbl(i).ship_to_party_id,
5466: p_party_usage => 'SHIP',
5467: x_return_status => x_return_status,

Line 5483: ASO_VALIDATE_PVT.Validate_PartySite (

5479: if aso_debug_pub.g_debug_flag = 'Y' THEN
5480: 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');
5481: end if;
5482:
5483: ASO_VALIDATE_PVT.Validate_PartySite (
5484: p_init_msg_list => FND_API.G_FALSE,
5485: p_party_id => lx_ln_shipment_tbl(i).ship_to_party_id,
5486: p_party_site_id => lx_ln_shipment_tbl(i).ship_to_party_site_id,
5487: p_site_usage => 'SHIP',

Line 5503: ASO_VALIDATE_PVT.Validate_Marketing_Source_Code(

5499:
5500: End LOOP;
5501:
5502:
5503: ASO_VALIDATE_PVT.Validate_Marketing_Source_Code(
5504: p_init_msg_list => FND_API.G_FALSE,
5505: p_mkting_source_code_id => lx_qte_line_rec.marketing_source_code_id,
5506: x_return_status => x_return_status,
5507: x_msg_count => x_msg_count,

Line 5521: ASO_VALIDATE_PVT.Validate_Service_Duration(

5517:
5518:
5519: FOR i in 1..p_qte_line_dtl_tbl.count LOOP
5520:
5521: ASO_VALIDATE_PVT.Validate_Service_Duration(
5522: p_init_msg_list => FND_API.G_FALSE,
5523: p_service_duration => p_qte_line_dtl_tbl(i).service_duration,
5524: x_return_status => x_return_status,
5525: x_msg_count => x_msg_count,

Line 5547: ASO_VALIDATE_PVT.Validate_Resource_id(

5543: end if;
5544:
5545: if (p_sales_credit_tbl(i).operation_code = 'CREATE' or p_sales_credit_tbl(i).operation_code = 'UPDATE') then
5546:
5547: ASO_VALIDATE_PVT.Validate_Resource_id(
5548: p_init_msg_list => FND_API.G_FALSE,
5549: p_resource_id => p_sales_credit_tbl(i).resource_id ,
5550: x_return_status => x_return_status,
5551: x_msg_count => x_msg_count,

Line 5563: ASO_VALIDATE_PVT.Validate_Resource_group_id(

5559: END IF;
5560: RAISE FND_API.G_EXC_ERROR;
5561: END IF;
5562:
5563: ASO_VALIDATE_PVT.Validate_Resource_group_id(
5564: p_init_msg_list => FND_API.G_FALSE,
5565: p_resource_group_id => p_sales_credit_tbl(i).resource_group_id,
5566: x_return_status => x_return_status,
5567: x_msg_count => x_msg_count,

Line 5574: ASO_VALIDATE_PVT.Validate_Salescredit_Type(

5570: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
5571: RAISE FND_API.G_EXC_ERROR;
5572: END IF;
5573:
5574: ASO_VALIDATE_PVT.Validate_Salescredit_Type(
5575: p_init_msg_list => FND_API.G_FALSE,
5576: p_salescredit_type_id => p_sales_credit_tbl(i).sales_credit_type_id,
5577: x_return_status => x_return_status,
5578: x_msg_count => x_msg_count,

Line 5585: ASO_VALIDATE_PVT.Validate_EmployPerson(

5581: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
5582: RAISE FND_API.G_EXC_ERROR;
5583: END IF;
5584:
5585: ASO_VALIDATE_PVT.Validate_EmployPerson(
5586: p_init_msg_list => FND_API.G_FALSE,
5587: p_employee_id => p_sales_credit_tbl(i).employee_person_id,
5588: x_return_status => x_return_status,
5589: x_msg_count => x_msg_count,

Line 5604: ASO_VALIDATE_PVT.Validate_Party_Type(

5600:
5601: /* commented by bmishra on 12/15/2004 as we are not using quote_party_tbl
5602: FOR i in 1..p_quote_party_tbl.count LOOP
5603:
5604: ASO_VALIDATE_PVT.Validate_Party_Type(
5605: p_init_msg_list => FND_API.G_FALSE,
5606: p_party_type => p_quote_party_tbl(i).party_type,
5607: x_return_status => x_return_status,
5608: x_msg_count => x_msg_count,

Line 5615: ASO_VALIDATE_PVT.Validate_Party(

5611: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
5612: RAISE FND_API.G_EXC_ERROR;
5613: END IF;
5614:
5615: ASO_VALIDATE_PVT.Validate_Party(
5616: p_init_msg_list => FND_API.G_FALSE,
5617: p_party_id => p_quote_party_tbl(i).party_id,
5618: p_party_usage => null,
5619: x_return_status => x_return_status,

Line 5627: ASO_VALIDATE_PVT.Validate_Party_Object_Type(

5623: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
5624: RAISE FND_API.G_EXC_ERROR;
5625: END IF;
5626:
5627: ASO_VALIDATE_PVT.Validate_Party_Object_Type(
5628: p_init_msg_list => FND_API.G_FALSE,
5629: p_party_object_type => p_quote_party_tbl(i).party_object_type,
5630: x_return_status => x_return_status,
5631: x_msg_count => x_msg_count,

Line 5641: ASO_VALIDATE_PVT.Validate_MiniSite(

5637: END LOOP;
5638: */
5639:
5640:
5641: ASO_VALIDATE_PVT.Validate_MiniSite(
5642: p_init_msg_list => FND_API.G_FALSE,
5643: p_minisite_id => lx_qte_line_rec.minisite_id,
5644: x_return_status => x_return_status,
5645: x_msg_count => x_msg_count,

Line 5652: ASO_VALIDATE_PVT.Validate_Section(

5648: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
5649: RAISE FND_API.G_EXC_ERROR;
5650: END IF;
5651:
5652: ASO_VALIDATE_PVT.Validate_Section(
5653: p_init_msg_list => FND_API.G_FALSE,
5654: p_section_id => lx_qte_line_rec.section_id,
5655: x_return_status => x_return_status,
5656: x_msg_count => x_msg_count,

Line 5722: ASO_VALIDATE_PVT.Validate_UOM_code(

5718:
5719:
5720: -- UOM must exist and should be in ASO_I_UNITS_OF_MEASURE
5721:
5722: ASO_VALIDATE_PVT.Validate_UOM_code(
5723: p_init_msg_list => FND_API.G_FALSE,
5724: p_uom_code => lx_qte_line_rec.uom_code,
5725: p_organization_id => l_organization_id,
5726: p_inventory_item_id => l_inventory_item_id,

Line 5736: ASO_VALIDATE_PVT.Validate_For_GreaterEndDate (

5732: RAISE FND_API.G_EXC_ERROR;
5733: END IF;
5734:
5735:
5736: ASO_VALIDATE_PVT.Validate_For_GreaterEndDate (
5737: p_init_msg_list => FND_API.G_FALSE,
5738: p_start_date => lx_qte_line_rec.start_date_active,
5739: p_end_date => lx_qte_line_rec.end_date_active,
5740: x_return_status => x_return_status,

Line 5760: ASO_VALIDATE_PVT.Validate_Returns(

5756: end if;
5757:
5758: FOR i in 1..p_qte_line_dtl_tbl.count LOOP
5759:
5760: ASO_VALIDATE_PVT.Validate_Returns(
5761: p_init_msg_list => FND_API.G_FALSE,
5762: p_return_ref_type_code => p_qte_line_dtl_tbl(i).return_ref_type,
5763: p_return_ref_header_id => p_qte_line_dtl_tbl(i).return_ref_header_id,
5764: p_return_ref_line_id => p_qte_line_dtl_tbl(i).return_ref_line_id,

Line 5790: ASO_VALIDATE_PVT.Validate_Tax_Exemption (

5786: -- and tax_exempt_reason_code must exist if tax_exempt_flag is 'E'.
5787:
5788: FOR i in 1..p_tax_detail_tbl.count LOOP
5789:
5790: ASO_VALIDATE_PVT.Validate_Tax_Exemption (
5791: p_init_msg_list => FND_API.G_FALSE,
5792: p_tax_exempt_flag => p_tax_detail_tbl(i).tax_exempt_flag,
5793: p_tax_exempt_reason_code => p_tax_detail_tbl(i).tax_exempt_reason_code,
5794: x_return_status => x_return_status,

Line 5830: ASO_VALIDATE_PVT.Validate_Configuration(

5826: p_qte_line_dtl_tbl(i).config_revision_num <> FND_API.G_MISS_NUM) AND
5827: (p_qte_line_dtl_tbl(i).config_item_id IS NOT NULL AND
5828: p_qte_line_dtl_tbl(i).config_item_id <> FND_API.G_MISS_NUM)) THEN
5829:
5830: ASO_VALIDATE_PVT.Validate_Configuration(
5831: p_init_msg_list => FND_API.G_FALSE,
5832: p_config_header_id => p_qte_line_dtl_tbl(i).config_header_id,
5833: p_config_revision_num => p_qte_line_dtl_tbl(i).config_revision_num,
5834: p_config_item_id => p_qte_line_dtl_tbl(i).config_item_id,

Line 5863: ASO_VALIDATE_PVT.Validate_Delayed_Service(

5859: end if;
5860:
5861: FOR i in 1..p_qte_line_dtl_tbl.count LOOP
5862:
5863: ASO_VALIDATE_PVT.Validate_Delayed_Service(
5864: p_init_msg_list => FND_API.G_FALSE,
5865: p_service_ref_type_code => p_qte_line_dtl_tbl(i).service_ref_type_code,
5866: p_service_ref_line_id => p_qte_line_dtl_tbl(i).service_ref_line_id,
5867: p_service_ref_system_id => p_qte_line_dtl_tbl(i).service_ref_system_id,

Line 5892: ASO_VALIDATE_PVT.Validate_Party_Object_Id(

5888: /* commented by bmishra on 12/15/2004 as quote_party_tbl is obsoleted
5889:
5890: FOR i in 1..p_quote_party_tbl.count LOOP
5891:
5892: ASO_VALIDATE_PVT.Validate_Party_Object_Id(
5893: p_init_msg_list => FND_API.G_FALSE,
5894: p_party_id => p_quote_party_tbl(i).party_id,
5895: p_party_object_type => p_quote_party_tbl(i).party_object_type,
5896: p_party_object_id => p_quote_party_tbl(i).party_object_id,

Line 5944: ASO_VALIDATE_PVT.Validate_ship_from_org_ID(

5940: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5941: aso_debug_pub.add('ASO_QUOTE_LINES_PVT: Update_Quote_Line: before Validate_ship_from_org_ID', 1, 'Y');
5942: end if;
5943:
5944: ASO_VALIDATE_PVT.Validate_ship_from_org_ID(
5945: P_Qte_Line_rec => lx_qte_line_rec,
5946: P_Shipment_rec => lx_ln_shipment_tbl(1),
5947: x_return_status => x_return_status);
5948:

Line 5991: ASO_VALIDATE_PVT.Validate_ship_from_org_ID(

5987: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5988: aso_debug_pub.add('Update_Quote_Line: before Validate_ship_from_org_ID (no lx_ln_shipment_tbl)', 1, 'Y');
5989: end if;
5990:
5991: ASO_VALIDATE_PVT.Validate_ship_from_org_ID(
5992: P_Qte_Line_rec => lx_qte_line_rec,
5993: P_Shipment_rec => l_db_shipment_rec,
5994: x_return_status => x_return_status);
5995:

Line 6039: ASO_VALIDATE_PVT.Validate_ship_from_org_ID(

6035: IF aso_debug_pub.g_debug_flag = 'Y' THEN
6036: aso_debug_pub.add('Update_Quote_Line: before Validate_ship_from_org_ID (no db_shipment_tbl)', 1, 'Y');
6037: end if;
6038:
6039: ASO_VALIDATE_PVT.Validate_ship_from_org_ID(
6040: P_Qte_Line_rec => lx_qte_line_rec,
6041: P_Shipment_rec => l_hd_shipment_rec,
6042: x_return_status => x_return_status);
6043:

Line 6229: ASO_VALIDATE_PVT.Validate_Inventory_Item(

6225: END IF;
6226:
6227: IF l_Qte_Line_Rec.inventory_item_id <> FND_API.G_MISS_NUM THEN
6228:
6229: ASO_VALIDATE_PVT.Validate_Inventory_Item(
6230: p_init_msg_list => FND_API.G_FALSE,
6231: p_inventory_item_id => l_Qte_Line_Rec.inventory_item_id,
6232: p_organization_id => l_Qte_Line_Rec.organization_id,
6233: x_return_status => x_return_status,

Line 6255: ASO_VALIDATE_PVT.validate_ship_method_code

6251: IF aso_debug_pub.g_debug_flag = 'Y' THEN
6252: aso_debug_pub.add('Update_Quote_line - ship method codeof quote line is being updated ', 1, 'N');
6253: aso_debug_pub.add('Update_Quote_line - before validate ship_method_code ', 1, 'N');
6254: end if;
6255: ASO_VALIDATE_PVT.validate_ship_method_code
6256: (
6257: p_init_msg_list => fnd_api.g_false,
6258: p_qte_header_id => lx_qte_line_rec.quote_header_id,
6259: p_qte_line_id => lx_qte_line_rec.quote_line_id,

Line 6281: ASO_VALIDATE_PVT.validate_ship_method_code

6277: IF aso_debug_pub.g_debug_flag = 'Y' THEN
6278: aso_debug_pub.add('Update_Quote_line - Organization id of quote line is being updated ', 1, 'N');
6279: aso_debug_pub.add('Update_Quote_line - before validate ship_method_code ', 1, 'N');
6280: end if;
6281: ASO_VALIDATE_PVT.validate_ship_method_code
6282: (
6283: p_init_msg_list => fnd_api.g_false,
6284: p_qte_header_id => lx_qte_line_rec.quote_header_id,
6285: p_qte_line_id => lx_qte_line_rec.quote_line_id,

Line 6334: ASO_VALIDATE_PVT.Validate_Service(

6330: END IF;
6331:
6332: END IF;
6333:
6334: ASO_VALIDATE_PVT.Validate_Service(
6335: p_init_msg_list => FND_API.G_FALSE,
6336: p_inventory_item_id => l_Qte_Line_Rec.inventory_item_id,
6337: p_start_date_active => l_Qte_Line_Rec.start_date_active,
6338: p_end_date_active => l_Qte_Line_Rec.end_date_active,

Line 6365: ASO_VALIDATE_PVT.Validate_UOM_code(

6361: END IF;
6362:
6363: --validate service period
6364:
6365: ASO_VALIDATE_PVT.Validate_UOM_code(
6366: p_init_msg_list => FND_API.G_FALSE,
6367: p_uom_code => l_qte_line_dtl_tbl(i).service_period,
6368: p_organization_id => l_Qte_Line_Rec.organization_id,
6369: p_inventory_item_id => l_Qte_Line_Rec.inventory_item_id,

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

6452:
6453: if aso_debug_pub.g_debug_flag = 'Y' then
6454: aso_debug_pub.add('l_service_ref_type_code: ' || l_service_ref_type_code);
6455: aso_debug_pub.add('l_qte_line_dtl_tbl('||i||').service_ref_line_id: ' || l_qte_line_dtl_tbl(i).service_ref_line_id);
6456: aso_debug_pub.add('UPDATE_QUOTE_LINE: Before calling aso_validate_pvt.validate_service_ref_line_id');
6457: end if;
6458:
6459: aso_validate_pvt.validate_service_ref_line_id (
6460: p_init_msg_list => fnd_api.g_false,

Line 6459: aso_validate_pvt.validate_service_ref_line_id (

6455: aso_debug_pub.add('l_qte_line_dtl_tbl('||i||').service_ref_line_id: ' || l_qte_line_dtl_tbl(i).service_ref_line_id);
6456: aso_debug_pub.add('UPDATE_QUOTE_LINE: Before calling aso_validate_pvt.validate_service_ref_line_id');
6457: end if;
6458:
6459: aso_validate_pvt.validate_service_ref_line_id (
6460: p_init_msg_list => fnd_api.g_false,
6461: p_service_ref_type_code => l_service_ref_type_code,
6462: p_service_ref_line_id => l_qte_line_dtl_tbl(i).service_ref_line_id,
6463: p_qte_header_id => l_Qte_Line_Rec.quote_header_id,

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

6465: x_msg_count => x_msg_count,
6466: x_msg_data => x_msg_data);
6467:
6468: if aso_debug_pub.g_debug_flag = 'Y' then
6469: aso_debug_pub.add('UPDATE_QUOTE_LINE: After calling aso_validate_pvt.validate_service_ref_line_id');
6470: aso_debug_pub.add('UPDATE_QUOTE_LINE: x_return_status: '|| x_return_status);
6471: end if;
6472:
6473: if x_return_status <> fnd_api.g_ret_sts_success then

Line 6564: ASO_validate_PVT.Validate_ln_type_for_ord_type(

6560: end if;
6561:
6562: 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
6563:
6564: ASO_validate_PVT.Validate_ln_type_for_ord_type(
6565: p_init_msg_list => FND_API.G_FALSE,
6566: p_qte_header_rec => l_qte_header_rec,
6567: P_Qte_Line_rec => l_Qte_Line_Rec,
6568: x_return_status => x_return_status,

Line 6616: ASO_VALIDATE_PVT.Validate_Sales_Credit_Return(

6612: end if;
6613:
6614: IF ( P_validation_level >= ASO_UTILITY_PVT.G_VALID_LEVEL_ITEM) THEN
6615:
6616: ASO_VALIDATE_PVT.Validate_Sales_Credit_Return(
6617: p_init_msg_list => FND_API.G_FALSE,
6618: p_sales_credit_tbl => p_sales_credit_tbl,
6619: p_qte_line_rec => l_Qte_Line_Rec,
6620: x_return_status => x_return_status,

Line 6636: ASO_VALIDATE_PVT.Validate_Agreement(

6632: end if;
6633:
6634: IF (l_Qte_Line_Rec.Agreement_Id IS NOT NULL AND l_Qte_Line_Rec.Agreement_Id <> FND_API.G_MISS_NUM) THEN
6635:
6636: ASO_VALIDATE_PVT.Validate_Agreement(
6637: p_init_msg_list => FND_API.G_FALSE,
6638: P_Agreement_Id => l_Qte_Line_Rec.Agreement_Id,
6639: x_return_status => x_return_status,
6640: x_msg_count => x_msg_count,

Line 6680: aso_validate_pvt.Validate_cc_info

6676: aso_debug_pub.add('Before calling Validate_cc_info ', 1, 'Y');
6677: END IF;
6678: l_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row (l_qte_line_rec.Quote_Header_Id );
6679:
6680: aso_validate_pvt.Validate_cc_info
6681: (
6682: p_init_msg_list => fnd_api.g_false,
6683: p_payment_rec => l_payment_rec,
6684: p_qte_header_rec => l_qte_header_rec,

Line 7330: ASO_VALIDATE_PVT.Validate_Quote_Percent(

7326: 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
7327: x_sales_credit_tbl(1).quote_line_id := l_qte_line_rec.quote_line_id;
7328: END IF;
7329:
7330: ASO_VALIDATE_PVT.Validate_Quote_Percent(
7331: p_init_msg_list => FND_API.G_FALSE,
7332: p_sales_credit_tbl => x_sales_credit_tbl,
7333: x_return_status => x_return_status,
7334: x_msg_count => x_msg_count,

Line 7350: ASO_VALIDATE_PVT.Validate_Promotion (

7346: IF aso_debug_pub.g_debug_flag = 'Y' THEN
7347: aso_debug_pub.add('Before calling Validate_Promotion price_attr_tbl.count: '|| p_price_attributes_tbl.count, 1, 'Y');
7348: END IF;
7349:
7350: ASO_VALIDATE_PVT.Validate_Promotion (
7351: P_Api_Version_Number => 1.0,
7352: P_Init_Msg_List => FND_API.G_FALSE,
7353: P_Commit => FND_API.G_FALSE,
7354: p_price_attr_tbl => p_price_attributes_tbl,

Line 8717: aso_validate_pvt.Validate_po_line_number

8713:
8714: END LOOP; -- payment loop
8715:
8716: -- fix for bug 4483808 , moved validation after the row has been updated
8717: aso_validate_pvt.Validate_po_line_number
8718: (
8719: p_init_msg_list => fnd_api.g_false,
8720: p_qte_header_rec => l_qte_header_rec,
8721: P_Qte_Line_rec => l_Qte_Line_Rec,