DBA Data[Home] [Help]

APPS.AS_OPP_LINE_PVT dependencies on AS_UTILITY_PUB

Line 703: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,

699: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
700: P_Admin_Group_Id IN NUMBER,
701: P_Identity_Salesforce_Id IN NUMBER := NULL,
702: p_salesgroup_id IN NUMBER := NULL,
703: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
704: -- Suresh Mahalingam: Removed init to FND_API.G_MISS_NUM to fix GSCC warning
705: P_Partner_Cont_Party_id IN NUMBER,
706: P_Line_Tbl IN AS_OPPORTUNITY_PUB.Line_Tbl_Type :=
707: AS_OPPORTUNITY_PUB.G_MISS_Line_Tbl,

Line 1229: IF (p_validation_level >= AS_UTILITY_PUB.G_VALID_LEVEL_RECORD) THEN

1225: l_sales_credit_rec.credit_percent := 100;
1226:
1227: l_sales_credit_tbl(1) := l_sales_credit_rec;
1228:
1229: IF (p_validation_level >= AS_UTILITY_PUB.G_VALID_LEVEL_RECORD) THEN
1230: AS_OPP_sales_credit_PVT.Validate_SALES_CREDIT_Rec(
1231: p_init_msg_list => FND_API.G_FALSE,
1232: p_validation_mode => AS_UTILITY_PVT.G_CREATE,
1233: P_SALES_CREDIT_Rec => l_sales_credit_Rec,

Line 1463: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,

1459: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
1460: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
1461: P_Admin_Group_Id IN NUMBER,
1462: P_Identity_Salesforce_Id IN NUMBER := NULL,
1463: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
1464: -- Suresh Mahalingam: Removed init to FND_API.G_MISS_NUM to fix GSCC warning
1465: P_Partner_Cont_Party_id IN NUMBER,
1466: P_Line_Tbl IN AS_OPPORTUNITY_PUB.Line_Tbl_Type,
1467: P_Header_Rec IN AS_OPPORTUNITY_PUB.Header_Rec_Type,

Line 1983: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,

1979: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
1980: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
1981: P_Admin_Group_Id IN NUMBER,
1982: P_identity_salesforce_id IN NUMBER := NULL,
1983: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
1984: -- Suresh Mahalingam: Removed init to FND_API.G_MISS_NUM to fix GSCC warning
1985: P_Partner_Cont_Party_id IN NUMBER,
1986: P_Line_Tbl IN AS_OPPORTUNITY_PUB.Line_Tbl_Type,
1987: P_Header_Rec IN AS_OPPORTUNITY_PUB.Header_Rec_Type,

Line 2339: X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,

2335: PROCEDURE Validate_LEAD_LINE_ID (
2336: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2337: P_Validation_mode IN VARCHAR2,
2338: P_LEAD_LINE_ID IN NUMBER,
2339: X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
2340: X_Return_Status OUT NOCOPY VARCHAR2,
2341: X_Msg_Count OUT NOCOPY NUMBER,
2342: X_Msg_Data OUT NOCOPY VARCHAR2
2343: )

Line 2425: X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,

2421: PROCEDURE Validate_REQUEST_ID (
2422: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2423: P_Validation_mode IN VARCHAR2,
2424: P_REQUEST_ID IN NUMBER,
2425: X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
2426: X_Return_Status OUT NOCOPY VARCHAR2,
2427: X_Msg_Count OUT NOCOPY NUMBER,
2428: X_Msg_Data OUT NOCOPY VARCHAR2
2429: )

Line 2472: X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,

2468: PROCEDURE Validate_LEAD_ID (
2469: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2470: P_Validation_mode IN VARCHAR2,
2471: P_LEAD_ID IN NUMBER,
2472: X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
2473: X_Return_Status OUT NOCOPY VARCHAR2,
2474: X_Msg_Count OUT NOCOPY NUMBER,
2475: X_Msg_Data OUT NOCOPY VARCHAR2
2476: )

Line 2535: X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,

2531: PROCEDURE Validate_INTEREST_TYPE_ID (
2532: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2533: P_Validation_mode IN VARCHAR2,
2534: P_INTEREST_TYPE_ID IN NUMBER,
2535: X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
2536: X_Return_Status OUT NOCOPY VARCHAR2,
2537: X_Msg_Count OUT NOCOPY NUMBER,
2538: X_Msg_Data OUT NOCOPY VARCHAR2
2539: )

Line 2590: X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,

2586: PROCEDURE Validate_P_INTEREST_CODE_ID (
2587: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2588: P_Validation_mode IN VARCHAR2,
2589: P_PRIMARY_INTEREST_CODE_ID IN NUMBER,
2590: X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
2591: X_Return_Status OUT NOCOPY VARCHAR2,
2592: X_Msg_Count OUT NOCOPY NUMBER,
2593: X_Msg_Data OUT NOCOPY VARCHAR2
2594: )

Line 2645: X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,

2641: PROCEDURE Validate_S_INTEREST_CODE_ID (
2642: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2643: P_Validation_mode IN VARCHAR2,
2644: P_SECONDARY_INTEREST_CODE_ID IN NUMBER,
2645: X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
2646: X_Return_Status OUT NOCOPY VARCHAR2,
2647: X_Msg_Count OUT NOCOPY NUMBER,
2648: X_Msg_Data OUT NOCOPY VARCHAR2
2649: )

Line 2703: X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,

2699: P_Validation_mode IN VARCHAR2,
2700: P_CATEGORY_SET_ID IN NUMBER,
2701: P_CATEGORY_ID IN NUMBER,
2702: P_LEAD_LINE_ID IN NUMBER,
2703: X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
2704: X_Return_Status OUT NOCOPY VARCHAR2,
2705: X_Msg_Count OUT NOCOPY NUMBER,
2706: X_Msg_Data OUT NOCOPY VARCHAR2
2707: )

Line 2882: X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,

2878: PROCEDURE Validate_INVENTORY_ITEM_ID (
2879: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2880: P_Validation_mode IN VARCHAR2,
2881: P_INVENTORY_ITEM_ID IN NUMBER,
2882: X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
2883: X_Return_Status OUT NOCOPY VARCHAR2,
2884: X_Msg_Count OUT NOCOPY NUMBER,
2885: X_Msg_Data OUT NOCOPY VARCHAR2
2886: )

Line 2939: X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,

2935: PROCEDURE Validate_ORGANIZATION_ID (
2936: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2937: P_Validation_mode IN VARCHAR2,
2938: P_ORGANIZATION_ID IN NUMBER,
2939: X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
2940: X_Return_Status OUT NOCOPY VARCHAR2,
2941: X_Msg_Count OUT NOCOPY NUMBER,
2942: X_Msg_Data OUT NOCOPY VARCHAR2
2943: )

Line 2986: X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,

2982: PROCEDURE Validate_UOM_CODE (
2983: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2984: P_Validation_mode IN VARCHAR2,
2985: P_UOM_CODE IN VARCHAR2,
2986: X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
2987: X_Return_Status OUT NOCOPY VARCHAR2,
2988: X_Msg_Count OUT NOCOPY NUMBER,
2989: X_Msg_Data OUT NOCOPY VARCHAR2
2990: )

Line 3042: X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,

3038: PROCEDURE Validate_QUANTITY (
3039: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3040: P_Validation_mode IN VARCHAR2,
3041: P_QUANTITY IN NUMBER,
3042: X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
3043: X_Return_Status OUT NOCOPY VARCHAR2,
3044: X_Msg_Count OUT NOCOPY NUMBER,
3045: X_Msg_Data OUT NOCOPY VARCHAR2
3046: )

Line 3089: X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,

3085: PROCEDURE Validate_TOTAL_AMOUNT (
3086: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3087: P_Validation_mode IN VARCHAR2,
3088: P_TOTAL_AMOUNT IN NUMBER,
3089: X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
3090: X_Return_Status OUT NOCOPY VARCHAR2,
3091: X_Msg_Count OUT NOCOPY NUMBER,
3092: X_Msg_Data OUT NOCOPY VARCHAR2
3093: )

Line 3136: X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,

3132: PROCEDURE Validate_QUOTED_LINE_FLAG (
3133: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3134: P_Validation_mode IN VARCHAR2,
3135: P_QUOTED_LINE_FLAG IN VARCHAR2,
3136: X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
3137: X_Return_Status OUT NOCOPY VARCHAR2,
3138: X_Msg_Count OUT NOCOPY NUMBER,
3139: X_Msg_Data OUT NOCOPY VARCHAR2
3140: )

Line 3186: X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,

3182: PROCEDURE Validate_PRICE (
3183: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3184: P_Validation_mode IN VARCHAR2,
3185: P_PRICE IN NUMBER,
3186: X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
3187: X_Return_Status OUT NOCOPY VARCHAR2,
3188: X_Msg_Count OUT NOCOPY NUMBER,
3189: X_Msg_Data OUT NOCOPY VARCHAR2
3190: )

Line 3233: X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,

3229: PROCEDURE Validate_PRICE_VOLUME_MARGIN (
3230: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3231: P_Validation_mode IN VARCHAR2,
3232: P_PRICE_VOLUME_MARGIN IN NUMBER,
3233: X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
3234: X_Return_Status OUT NOCOPY VARCHAR2,
3235: X_Msg_Count OUT NOCOPY NUMBER,
3236: X_Msg_Data OUT NOCOPY VARCHAR2
3237: )

Line 3280: X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,

3276: PROCEDURE Validate_SHIP_DATE (
3277: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3278: P_Validation_mode IN VARCHAR2,
3279: P_SHIP_DATE IN DATE,
3280: X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
3281: X_Return_Status OUT NOCOPY VARCHAR2,
3282: X_Msg_Count OUT NOCOPY NUMBER,
3283: X_Msg_Data OUT NOCOPY VARCHAR2
3284: )

Line 3327: X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,

3323: PROCEDURE Validate_O_OPPORTUNITY_LINE_ID (
3324: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3325: P_Validation_mode IN VARCHAR2,
3326: P_O_OPPORTUNITY_LINE_ID IN NUMBER,
3327: X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
3328: X_Return_Status OUT NOCOPY VARCHAR2,
3329: X_Msg_Count OUT NOCOPY NUMBER,
3330: X_Msg_Data OUT NOCOPY VARCHAR2
3331: )

Line 3383: X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,

3379: PROCEDURE Validate_SOURCE_PROMOTION_ID (
3380: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3381: P_Validation_mode IN VARCHAR2,
3382: P_SOURCE_PROMOTION_ID IN NUMBER,
3383: X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
3384: X_Return_Status OUT NOCOPY VARCHAR2,
3385: X_Msg_Count OUT NOCOPY NUMBER,
3386: X_Msg_Data OUT NOCOPY VARCHAR2
3387: )

Line 3458: X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,

3454: PROCEDURE Validate_OFFER_ID (
3455: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3456: P_Validation_mode IN VARCHAR2,
3457: P_OFFER_ID IN NUMBER,
3458: X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
3459: X_Return_Status OUT NOCOPY VARCHAR2,
3460: X_Msg_Count OUT NOCOPY NUMBER,
3461: X_Msg_Data OUT NOCOPY VARCHAR2
3462: )

Line 3693: x_item_property_rec AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE;

3689: X_Msg_Data OUT NOCOPY VARCHAR2
3690: )
3691: IS
3692: l_api_name CONSTANT VARCHAR2(30) := 'Validate_opp_line';
3693: x_item_property_rec AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE;
3694: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
3695:
3696: l_module CONSTANT VARCHAR2(255) := 'as.plsql.ldlpv.Validate_opp_line';
3697: BEGIN

Line 3733: IF (p_validation_level >= AS_UTILITY_PUB.G_VALID_LEVEL_ITEM) THEN

3729: x_return_status := FND_API.G_RET_STS_ERROR;
3730: raise FND_API.G_EXC_ERROR;
3731: END IF;
3732:
3733: IF (p_validation_level >= AS_UTILITY_PUB.G_VALID_LEVEL_ITEM) THEN
3734: -- Hint: We provide validation procedure for every column. Developer
3735: -- should delete unnecessary validation procedures.
3736:
3737: IF l_debug THEN

Line 4022: -- IF (p_validation_level >= AS_UTILITY_PUB.G_VALID_LEVEL_RECORD) THEN

4018:
4019: END IF;
4020:
4021: -- Conditional Validation removed as part of MOAC bug 4747288
4022: -- IF (p_validation_level >= AS_UTILITY_PUB.G_VALID_LEVEL_RECORD) THEN
4023: -- Hint: Inter-field level validation can be added here
4024: -- invoke record level validation procedures
4025: Validate_Line_Rec(
4026: p_init_msg_list => FND_API.G_FALSE,

Line 4039: IF (p_validation_level >= AS_UTILITY_PUB.G_VALID_LEVEL_INTER_RECORD) THEN

4035: END IF;
4036:
4037: -- END IF;
4038:
4039: IF (p_validation_level >= AS_UTILITY_PUB.G_VALID_LEVEL_INTER_RECORD) THEN
4040: -- invoke inter-record level validation procedures
4041: NULL;
4042: END IF;
4043:

Line 4044: IF (p_validation_level >= AS_UTILITY_PUB.G_VALID_LEVEL_INTER_ENTITY) THEN

4040: -- invoke inter-record level validation procedures
4041: NULL;
4042: END IF;
4043:
4044: IF (p_validation_level >= AS_UTILITY_PUB.G_VALID_LEVEL_INTER_ENTITY) THEN
4045: -- invoke inter-entity level validation procedures
4046: NULL;
4047: END IF;
4048: