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_VALIDATE_PVT dependencies on ASO_VALIDATE_PVT

Line 1: PACKAGE BODY ASO_VALIDATE_PVT as

1: PACKAGE BODY ASO_VALIDATE_PVT as
2: /* $Header: asovvldb.pls 120.36 2010/08/20 22:40:41 cazhou ship $ */
3:
4: -- Start of Comments
5: -- Package name : ASO_VALIDATE_PVT

Line 5: -- Package name : ASO_VALIDATE_PVT

1: PACKAGE BODY ASO_VALIDATE_PVT as
2: /* $Header: asovvldb.pls 120.36 2010/08/20 22:40:41 cazhou ship $ */
3:
4: -- Start of Comments
5: -- Package name : ASO_VALIDATE_PVT
6: -- Purpose :
7: --
8: -- History :
9: -- 08/01/2002 hyang - 2492841, performance change

Line 13: G_PKG_NAME CONSTANT VARCHAR2(30):= 'ASO_VALIDATE_PVT';

9: -- 08/01/2002 hyang - 2492841, performance change
10: -- 10/18/2002 hyang - 2633507, performance fix
11: -- NOTE :
12: -- End of Comments
13: G_PKG_NAME CONSTANT VARCHAR2(30):= 'ASO_VALIDATE_PVT';
14:
15:
16: PROCEDURE Validate_NotNULL_NUMBER (
17: p_init_msg_list IN VARCHAR2,

Line 890: aso_debug_pub.add('ASO_VALIDATE_PVT.validate_configuration: Inside C_configuration Not Found condition',1,'N');

886: FETCH C_configuration INTO l_component_code;
887: IF (C_configuration%NOTFOUND) THEN
888: CLOSE C_configuration;
889: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
890: aso_debug_pub.add('ASO_VALIDATE_PVT.validate_configuration: Inside C_configuration Not Found condition',1,'N');
891: END IF;
892: x_return_status := FND_API.G_RET_STS_ERROR;
893: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
894: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_CONFIGURATION');

Line 902: aso_debug_pub.add('ASO_VALIDATE_PVT.validate_configuration: Inside C_configuration Not Found ELSE condition', 1, 'N');

898: FND_MSG_PUB.ADD;
899: END IF;
900: ELSE
901: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
902: aso_debug_pub.add('ASO_VALIDATE_PVT.validate_configuration: Inside C_configuration Not Found ELSE condition', 1, 'N');
903: END IF;
904: CLOSE C_configuration;
905: END IF;
906: END Validate_Configuration;

Line 1000: aso_debug_pub.add('ASO_VALIDATE_PVT: Validate_Service: Begin validate_service procedure.');

996: --Initialize API return status to success
997: x_return_status := FND_API.G_RET_STS_SUCCESS;
998:
999: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1000: aso_debug_pub.add('ASO_VALIDATE_PVT: Validate_Service: Begin validate_service procedure.');
1001: aso_debug_pub.add('Validate_Service: p_inventory_item_id: '|| p_inventory_item_id);
1002: aso_debug_pub.add('Validate_Service: p_start_date_active: '|| p_start_date_active);
1003: aso_debug_pub.add('Validate_Service: p_end_date_active: '|| p_end_date_active);
1004: aso_debug_pub.add('Validate_Service: p_service_duration: '|| p_service_duration);

Line 2946: ASO_VALIDATE_PVT.Validate_Party_bsc(

2942:
2943: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2944: aso_debug_pub.add('Validate_ItemTcaBsc: Begin ',1,'N');
2945: END IF;
2946: ASO_VALIDATE_PVT.Validate_Party_bsc(
2947: p_init_msg_list => p_init_msg_list,
2948: p_party_id => lp_qte_header_rec.party_id,
2949: x_return_status => x_return_status,
2950: x_msg_count => x_msg_count,

Line 2959: ASO_VALIDATE_PVT.Validate_Party_bsc(

2955: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2956: aso_debug_pub.add('Validate_ItemTcaBsc: party_id: x_return_status: ' || x_return_status,1,'N');
2957: END IF;
2958:
2959: ASO_VALIDATE_PVT.Validate_Party_bsc(
2960: p_init_msg_list => p_init_msg_list,
2961: p_party_id => lp_qte_header_rec.cust_party_id,
2962: x_return_status => x_return_status,
2963: x_msg_count => x_msg_count,

Line 2972: ASO_VALIDATE_PVT.Validate_Party_bsc(

2968: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2969: aso_debug_pub.add('Validate_ItemTcaBsc: cust_party_id: x_return_status: ' || x_return_status,1,'N');
2970: END IF;
2971:
2972: ASO_VALIDATE_PVT.Validate_Party_bsc(
2973: p_init_msg_list => p_init_msg_list,
2974: p_party_id => lp_qte_header_rec.invoice_to_cust_party_id,
2975: x_return_status => x_return_status,
2976: x_msg_count => x_msg_count,

Line 2985: ASO_VALIDATE_PVT.Validate_Party_bsc(

2981: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2982: aso_debug_pub.add('Validate_ItemTcaBsc: inv_cust_party_id: x_return_status: ' || x_return_status,1,'N');
2983: END IF;
2984:
2985: ASO_VALIDATE_PVT.Validate_Party_bsc(
2986: p_init_msg_list => p_init_msg_list,
2987: p_party_id => lp_qte_header_rec.End_Customer_cust_party_id,
2988: x_return_status => x_return_status,
2989: x_msg_count => x_msg_count,

Line 2998: ASO_VALIDATE_PVT.Validate_Party_bsc(

2994: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2995: aso_debug_pub.add('Validate_ItemTcaBsc: end_cust_party_id: x_return_status: ' || x_return_status,1,'N');
2996: END IF;
2997:
2998: ASO_VALIDATE_PVT.Validate_Party_bsc(
2999: p_init_msg_list => p_init_msg_list,
3000: p_party_id => lp_shipment_rec.ship_to_cust_party_id,
3001: x_return_status => x_return_status,
3002: x_msg_count => x_msg_count,

Line 3012: ASO_VALIDATE_PVT.Validate_CustAccount_bsc(

3008: aso_debug_pub.add('Validate_ItemTcaBsc: shp_cust_party_id: x_return_status: ' || x_return_status,1,'N');
3009: END IF;
3010:
3011:
3012: ASO_VALIDATE_PVT.Validate_CustAccount_bsc(
3013: p_init_msg_list => p_init_msg_list,
3014: p_party_id => lp_qte_header_rec.party_id,
3015: p_cust_account_id => lp_qte_header_rec.cust_account_id,
3016: p_inv_cust_account_id => lp_qte_header_rec.invoice_to_cust_account_id,

Line 3029: ASO_VALIDATE_PVT.Validate_org_contact_bsc(

3025: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
3026: aso_debug_pub.add('Validate_ItemTcaBsc: custAcctBsc: x_return_status: ' || x_return_status,1,'N');
3027: END IF;
3028:
3029: ASO_VALIDATE_PVT.Validate_org_contact_bsc(
3030: p_init_msg_list => p_init_msg_list,
3031: p_contact_id => lp_qte_header_rec.org_contact_id,
3032: p_cust_account_id => lp_qte_header_rec.cust_account_id,
3033: x_return_status => x_return_status,

Line 3044: ASO_VALIDATE_PVT.Validate_Inv_Party_bsc(

3040: aso_debug_pub.add('Validate_ItemTcaBsc: OrgConBsc: x_return_status: ' || x_return_status,1,'N');
3041: END IF;
3042:
3043:
3044: ASO_VALIDATE_PVT.Validate_Inv_Party_bsc(
3045: p_init_msg_list => p_init_msg_list,
3046: p_party_id => lp_qte_header_rec.invoice_to_party_id,
3047: p_site_use => 'BILL_TO',
3048: x_return_status => x_return_status,

Line 3058: ASO_VALIDATE_PVT.Validate_Inv_Party_bsc(

3054: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
3055: aso_debug_pub.add('Validate_ItemTcaBsc: InvPty: BillTo: x_return_status: ' || x_return_status,1,'N');
3056: END IF;
3057:
3058: ASO_VALIDATE_PVT.Validate_Inv_Party_bsc(
3059: p_init_msg_list => p_init_msg_list,
3060: p_party_id => lp_qte_header_rec.End_Customer_party_id,
3061: p_site_use => 'END_USER',
3062: x_return_status => x_return_status,

Line 3072: ASO_VALIDATE_PVT.Validate_Inv_Party_bsc(

3068: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
3069: aso_debug_pub.add('Validate_ItemTcaBsc: InvPty: EndUser: x_return_status: ' || x_return_status,1,'N');
3070: END IF;
3071:
3072: ASO_VALIDATE_PVT.Validate_Inv_Party_bsc(
3073: p_init_msg_list => p_init_msg_list,
3074: p_party_id => lp_shipment_rec.ship_to_party_id,
3075: p_site_use => 'SHIP_TO',
3076: x_return_status => x_return_status,

Line 3088: ASO_VALIDATE_PVT.Validate_Inv_PartySite_bsc(

3084: aso_debug_pub.add('before Validate_Inv_PartySite_bsc:lp_qte_header_rec.invoice_to_cust_party_id: '||p_qte_header_rec.invoice_to_cust_party_id, 1, 'Y');
3085: aso_debug_pub.add('before Validate_Inv_PartySite_bsc:lp_qte_header_rec.invoice_to_party_site_id: '||p_qte_header_rec.invoice_to_party_site_id, 1, 'Y');
3086: END IF;
3087:
3088: ASO_VALIDATE_PVT.Validate_Inv_PartySite_bsc(
3089: p_init_msg_list => p_init_msg_list,
3090: p_party_id => lp_qte_header_rec.invoice_to_cust_party_id,
3091: p_party_site_id => lp_qte_header_rec.invoice_to_party_site_id,
3092: p_party_site_use => 'BILL_TO',

Line 3105: ASO_VALIDATE_PVT.Validate_Inv_PartySite_bsc(

3101: aso_debug_pub.add('before Validate_Inv_PartySite_bsc:lp_qte_header_rec.End_Customer_cust_party_id: '||p_qte_header_rec.End_Customer_cust_party_id, 1, 'Y');
3102: aso_debug_pub.add('before Validate_Inv_PartySite_bsc:lp_qte_header_rec.End_Customer_party_site_id: '||p_qte_header_rec.End_Customer_party_site_id, 1, 'Y');
3103: END IF;
3104:
3105: ASO_VALIDATE_PVT.Validate_Inv_PartySite_bsc(
3106: p_init_msg_list => p_init_msg_list,
3107: p_party_id => lp_qte_header_rec.End_Customer_cust_party_id,
3108: p_party_site_id => lp_qte_header_rec.End_Customer_party_site_id,
3109: p_party_site_use => 'END_USER',

Line 3122: ASO_VALIDATE_PVT.Validate_Inv_PartySite_bsc(

3118: aso_debug_pub.add('before Validate_Inv_PartySite_bsc:lp_shipment_rec.ship_to_cust_party_id: '||p_shipment_rec.ship_to_cust_party_id, 1, 'Y');
3119: aso_debug_pub.add('before Validate_Inv_PartySite_bsc:lp_shipment_rec.ship_to_party_site_id: '||p_shipment_rec.ship_to_party_site_id, 1, 'Y');
3120: END IF;
3121:
3122: ASO_VALIDATE_PVT.Validate_Inv_PartySite_bsc(
3123: p_init_msg_list => p_init_msg_list,
3124: p_party_id => lp_shipment_rec.ship_to_cust_party_id,
3125: p_party_site_id => lp_shipment_rec.ship_to_party_site_id,
3126: p_party_site_use => 'SHIP_TO',

Line 3152: ASO_VALIDATE_PVT.Validate_Inv_PartySite_bsc(

3148:
3149: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
3150: aso_debug_pub.add('before Validate_Inv_PartySite_bsc:l_party_id: '||l_party_id, 1, 'Y');
3151: END IF;
3152: ASO_VALIDATE_PVT.Validate_Inv_PartySite_bsc(
3153: p_init_msg_list => p_init_msg_list,
3154: p_party_id => l_party_id,
3155: p_party_site_id => lp_qte_header_rec.sold_to_party_site_id,
3156: p_party_site_use => 'SOLD_TO',

Line 3327: ASO_VALIDATE_PVT.Validate_Party_Crs(

3323: END IF; -- UPDATE
3324:
3325: -- Initialize API return status to success
3326: x_return_status := FND_API.G_RET_STS_SUCCESS;
3327: ASO_VALIDATE_PVT.Validate_Party_Crs(
3328: p_init_msg_list => p_init_msg_list,
3329: p_party_id => lp_qte_header_rec.party_id,
3330: p_cust_party_id => lp_qte_header_rec.cust_party_id,
3331: p_cust_account_id => lp_qte_header_rec.cust_account_id,

Line 3342: ASO_VALIDATE_PVT.Validate_org_contact_crs(

3338:
3339: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
3340: RAISE FND_API.G_EXC_ERROR;
3341: END IF;
3342: ASO_VALIDATE_PVT.Validate_org_contact_crs(
3343: p_init_msg_list => p_init_msg_list,
3344: p_contact_id => lp_qte_header_rec.org_contact_id,
3345: p_cust_account_id => lp_qte_header_rec.cust_account_id,
3346: p_party_id => lp_qte_header_rec.party_id,

Line 3357: ASO_VALIDATE_PVT.Validate_Inv_Party_Crs(

3353:
3354: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
3355: RAISE FND_API.G_EXC_ERROR;
3356: END IF;
3357: ASO_VALIDATE_PVT.Validate_Inv_Party_Crs(
3358: p_init_msg_list => p_init_msg_list,
3359: p_party_id => lp_qte_header_rec.party_id,
3360: p_cust_party_id => lp_qte_header_rec.cust_party_id,
3361: p_inv_party_id => lp_qte_header_rec.invoice_to_party_id,

Line 3377: ASO_VALIDATE_PVT.Validate_Inv_Party_Crs(

3373: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
3374: RAISE FND_API.G_EXC_ERROR;
3375: END IF;
3376:
3377: ASO_VALIDATE_PVT.Validate_Inv_Party_Crs(
3378: p_init_msg_list => p_init_msg_list,
3379: p_party_id => lp_qte_header_rec.party_id,
3380: p_cust_party_id => lp_qte_header_rec.cust_party_id,
3381: p_inv_party_id => lp_qte_header_rec.End_Customer_party_id,

Line 3397: ASO_VALIDATE_PVT.Validate_Inv_Party_Crs(

3393: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
3394: RAISE FND_API.G_EXC_ERROR;
3395: END IF;
3396:
3397: ASO_VALIDATE_PVT.Validate_Inv_Party_Crs(
3398: p_init_msg_list => p_init_msg_list,
3399: p_party_id => lp_qte_header_rec.party_id,
3400: p_cust_party_id => lp_qte_header_rec.cust_party_id,
3401: p_inv_party_id => lp_shipment_rec.ship_to_party_id,

Line 3416: ASO_VALIDATE_PVT.Validate_inv_PartySite_crs(

3412:
3413: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
3414: RAISE FND_API.G_EXC_ERROR;
3415: END IF;
3416: ASO_VALIDATE_PVT.Validate_inv_PartySite_crs(
3417: p_init_msg_list => p_init_msg_list,
3418: p_party_id => lp_qte_header_rec.party_id,
3419: p_cust_party_id => lp_qte_header_rec.cust_party_id,
3420: p_inv_party_id => lp_qte_header_rec.invoice_to_party_id,

Line 3437: ASO_VALIDATE_PVT.Validate_inv_PartySite_crs(

3433: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
3434: RAISE FND_API.G_EXC_ERROR;
3435: END IF;
3436:
3437: ASO_VALIDATE_PVT.Validate_inv_PartySite_crs(
3438: p_init_msg_list => p_init_msg_list,
3439: p_party_id => lp_qte_header_rec.party_id,
3440: p_cust_party_id => lp_qte_header_rec.cust_party_id,
3441: p_inv_party_id => lp_qte_header_rec.End_Customer_party_id,

Line 3458: ASO_VALIDATE_PVT.Validate_inv_PartySite_crs(

3454: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
3455: RAISE FND_API.G_EXC_ERROR;
3456: END IF;
3457:
3458: ASO_VALIDATE_PVT.Validate_inv_PartySite_crs(
3459: p_init_msg_list => p_init_msg_list,
3460: p_party_id => lp_qte_header_rec.party_id,
3461: p_party_site_id => lp_shipment_rec.ship_to_party_Site_id,
3462: p_cust_party_id => lp_qte_header_rec.cust_party_id,

Line 3489: ASO_VALIDATE_PVT.Validate_inv_PartySite_crs(

3485: ELSE
3486: l_party_id := lp_qte_header_rec.party_id;
3487: END IF;
3488:
3489: ASO_VALIDATE_PVT.Validate_inv_PartySite_crs(
3490: p_init_msg_list => p_init_msg_list,
3491: p_party_id => l_party_id,
3492: p_cust_party_id => lp_qte_header_rec.cust_party_id,
3493: p_inv_party_id => null,

Line 3926: aso_debug_pub.add('ASO_VALIDATE_PVT inventory_item_id: '||p_qte_line_rec.inventory_item_id, 1, 'N');

3922: AND rownum = 1 ;
3923:
3924: BEGIN
3925: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
3926: aso_debug_pub.add('ASO_VALIDATE_PVT inventory_item_id: '||p_qte_line_rec.inventory_item_id, 1, 'N');
3927: aso_debug_pub.add('ASO_VALIDATE_PVT organization_id: '||p_qte_line_rec.organization_id, 1, 'N');
3928: aso_debug_pub.add('ASO_VALIDATE_PVT ship_from_org_id: '||p_shipment_rec.ship_from_org_id, 1, 'N');
3929: END IF;
3930:

Line 3927: aso_debug_pub.add('ASO_VALIDATE_PVT organization_id: '||p_qte_line_rec.organization_id, 1, 'N');

3923:
3924: BEGIN
3925: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
3926: aso_debug_pub.add('ASO_VALIDATE_PVT inventory_item_id: '||p_qte_line_rec.inventory_item_id, 1, 'N');
3927: aso_debug_pub.add('ASO_VALIDATE_PVT organization_id: '||p_qte_line_rec.organization_id, 1, 'N');
3928: aso_debug_pub.add('ASO_VALIDATE_PVT ship_from_org_id: '||p_shipment_rec.ship_from_org_id, 1, 'N');
3929: END IF;
3930:
3931: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3928: aso_debug_pub.add('ASO_VALIDATE_PVT ship_from_org_id: '||p_shipment_rec.ship_from_org_id, 1, 'N');

3924: BEGIN
3925: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
3926: aso_debug_pub.add('ASO_VALIDATE_PVT inventory_item_id: '||p_qte_line_rec.inventory_item_id, 1, 'N');
3927: aso_debug_pub.add('ASO_VALIDATE_PVT organization_id: '||p_qte_line_rec.organization_id, 1, 'N');
3928: aso_debug_pub.add('ASO_VALIDATE_PVT ship_from_org_id: '||p_shipment_rec.ship_from_org_id, 1, 'N');
3929: END IF;
3930:
3931: x_return_status := FND_API.G_RET_STS_SUCCESS;
3932: IF (p_qte_line_rec.inventory_item_id is not null AND p_qte_line_rec.inventory_item_id <> FND_API.G_MISS_NUM) AND

Line 5618: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ASO_VALIDATE_PVT';

5614: P_Api_Version_Number NUMBER;
5615: P_Init_Msg_List VARCHAR2(100) := FND_API.G_FALSE ;
5616: l_api_version_number CONSTANT NUMBER := 1.0;
5617: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_DEFAULTING_DATA';
5618: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ASO_VALIDATE_PVT';
5619: l_periodicity_profile varchar2(30);
5620: P_FLAG VARCHAR2(10);
5621: P_HEADER VARCHAR2(1);
5622:

Line 8004: aso_debug_pub.add('ASO_VALIDATE_PVT: Begin PRINT_DEFAULTING_ATTRIBUTES Procedure..');

8000:
8001: IF p_begin_flag = 'Y' THEN
8002:
8003: aso_debug_pub.add('***************************************************************', 1, 'Y');
8004: aso_debug_pub.add('ASO_VALIDATE_PVT: Begin PRINT_DEFAULTING_ATTRIBUTES Procedure..');
8005: aso_debug_pub.add('***************************************************************', 1, 'Y');
8006: IF p_def_object_name = 'ASO_AK_QUOTE_HEADER_V' THEN --Print header attributes only'
8007:
8008: aso_debug_pub.add('** Header Attributes Start **', 1, 'Y');

Line 9830: End ASO_VALIDATE_PVT;

9826: aso_debug_pub.add('End validate_ship_method_code', 1, 'Y');
9827: end if;
9828: END validate_ship_method_code;
9829:
9830: End ASO_VALIDATE_PVT;
9831: