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.30.12000000.2 2007/01/30 20:20:08 pkoka 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.30.12000000.2 2007/01/30 20:20:08 pkoka 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 2943: ASO_VALIDATE_PVT.Validate_Party_bsc(

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

Line 2956: ASO_VALIDATE_PVT.Validate_Party_bsc(

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

Line 2969: ASO_VALIDATE_PVT.Validate_Party_bsc(

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

Line 2982: ASO_VALIDATE_PVT.Validate_Party_bsc(

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

Line 2995: ASO_VALIDATE_PVT.Validate_Party_bsc(

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

Line 3009: ASO_VALIDATE_PVT.Validate_CustAccount_bsc(

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

Line 3026: ASO_VALIDATE_PVT.Validate_org_contact_bsc(

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

Line 3041: ASO_VALIDATE_PVT.Validate_Inv_Party_bsc(

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

Line 3055: ASO_VALIDATE_PVT.Validate_Inv_Party_bsc(

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

Line 3069: ASO_VALIDATE_PVT.Validate_Inv_Party_bsc(

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

Line 3085: ASO_VALIDATE_PVT.Validate_Inv_PartySite_bsc(

3081: 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');
3082: 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');
3083: END IF;
3084:
3085: ASO_VALIDATE_PVT.Validate_Inv_PartySite_bsc(
3086: p_init_msg_list => p_init_msg_list,
3087: p_party_id => lp_qte_header_rec.invoice_to_cust_party_id,
3088: p_party_site_id => lp_qte_header_rec.invoice_to_party_site_id,
3089: p_party_site_use => 'BILL_TO',

Line 3102: ASO_VALIDATE_PVT.Validate_Inv_PartySite_bsc(

3098: 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');
3099: 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');
3100: END IF;
3101:
3102: ASO_VALIDATE_PVT.Validate_Inv_PartySite_bsc(
3103: p_init_msg_list => p_init_msg_list,
3104: p_party_id => lp_qte_header_rec.End_Customer_cust_party_id,
3105: p_party_site_id => lp_qte_header_rec.End_Customer_party_site_id,
3106: p_party_site_use => 'END_USER',

Line 3119: ASO_VALIDATE_PVT.Validate_Inv_PartySite_bsc(

3115: 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');
3116: 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');
3117: END IF;
3118:
3119: ASO_VALIDATE_PVT.Validate_Inv_PartySite_bsc(
3120: p_init_msg_list => p_init_msg_list,
3121: p_party_id => lp_shipment_rec.ship_to_cust_party_id,
3122: p_party_site_id => lp_shipment_rec.ship_to_party_site_id,
3123: p_party_site_use => 'SHIP_TO',

Line 3149: ASO_VALIDATE_PVT.Validate_Inv_PartySite_bsc(

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

Line 3324: ASO_VALIDATE_PVT.Validate_Party_Crs(

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

Line 3339: ASO_VALIDATE_PVT.Validate_org_contact_crs(

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

Line 3354: ASO_VALIDATE_PVT.Validate_Inv_Party_Crs(

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

Line 3374: ASO_VALIDATE_PVT.Validate_Inv_Party_Crs(

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

Line 3394: ASO_VALIDATE_PVT.Validate_Inv_Party_Crs(

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

Line 3413: ASO_VALIDATE_PVT.Validate_inv_PartySite_crs(

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

Line 3434: ASO_VALIDATE_PVT.Validate_inv_PartySite_crs(

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

Line 3455: ASO_VALIDATE_PVT.Validate_inv_PartySite_crs(

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

Line 3486: ASO_VALIDATE_PVT.Validate_inv_PartySite_crs(

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

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

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

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

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

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

3921: BEGIN
3922: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
3923: aso_debug_pub.add('ASO_VALIDATE_PVT inventory_item_id: '||p_qte_line_rec.inventory_item_id, 1, 'N');
3924: aso_debug_pub.add('ASO_VALIDATE_PVT organization_id: '||p_qte_line_rec.organization_id, 1, 'N');
3925: aso_debug_pub.add('ASO_VALIDATE_PVT ship_from_org_id: '||p_shipment_rec.ship_from_org_id, 1, 'N');
3926: END IF;
3927:
3928: x_return_status := FND_API.G_RET_STS_SUCCESS;
3929: 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 5602: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ASO_VALIDATE_PVT';

5598: P_Api_Version_Number NUMBER;
5599: P_Init_Msg_List VARCHAR2(100) := FND_API.G_FALSE ;
5600: l_api_version_number CONSTANT NUMBER := 1.0;
5601: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_DEFAULTING_DATA';
5602: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ASO_VALIDATE_PVT';
5603: l_periodicity_profile varchar2(30);
5604: P_FLAG VARCHAR2(10);
5605: P_HEADER VARCHAR2(1);
5606:

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

7984:
7985: IF p_begin_flag = 'Y' THEN
7986:
7987: aso_debug_pub.add('***************************************************************', 1, 'Y');
7988: aso_debug_pub.add('ASO_VALIDATE_PVT: Begin PRINT_DEFAULTING_ATTRIBUTES Procedure..');
7989: aso_debug_pub.add('***************************************************************', 1, 'Y');
7990: IF p_def_object_name = 'ASO_AK_QUOTE_HEADER_V' THEN --Print header attributes only'
7991:
7992: aso_debug_pub.add('** Header Attributes Start **', 1, 'Y');

Line 9782: End ASO_VALIDATE_PVT;

9778: aso_debug_pub.add('End validate_ship_method_code', 1, 'Y');
9779: end if;
9780: END validate_ship_method_code;
9781:
9782: End ASO_VALIDATE_PVT;
9783: