16:
17: -- Item level validation procedures
18:
19: PROCEDURE Validate_CONTACT_ID (
20: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
21: P_Validation_mode IN VARCHAR2,
22: P_CUSTOMER_ID IN NUMBER,
23: P_CONTACT_ID IN NUMBER,
24: X_Return_Status OUT NOCOPY VARCHAR2,
26: X_Msg_Data OUT NOCOPY VARCHAR2
27: );
28:
29: PROCEDURE Validate_CONTACT_PARTY_ID (
30: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
31: P_Validation_mode IN VARCHAR2,
32: P_CUSTOMER_ID IN NUMBER,
33: P_CONTACT_PARTY_ID IN NUMBER,
34: X_Return_Status OUT NOCOPY VARCHAR2,
36: X_Msg_Data OUT NOCOPY VARCHAR2
37: );
38:
39: PROCEDURE Validate_PHONE_ID (
40: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
41: P_Validation_mode IN VARCHAR2,
42: P_CONTACT_ID IN NUMBER,
43: P_CONTACT_PARTY_ID IN NUMBER,
44: P_PHONE_ID IN NUMBER,
47: X_Msg_Data OUT NOCOPY VARCHAR2
48: );
49:
50: PROCEDURE Validate_CONTACT_ROLE_CODE (
51: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
52: P_Validation_mode IN VARCHAR2,
53: P_CONTACT_ROLE_CODE IN VARCHAR2,
54: X_Return_Status OUT NOCOPY VARCHAR2,
55: X_Msg_Count OUT NOCOPY NUMBER,
64:
65: -- validation procedures
66:
67: PROCEDURE Validate_sales_lead_contact(
68: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
69: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
70: P_Validation_mode IN VARCHAR2,
71: P_SALES_LEAD_CONTACT_Rec IN AS_SALES_LEADS_PUB.SALES_LEAD_CONTACT_Rec_Type,
72: X_Return_Status OUT NOCOPY VARCHAR2,
65: -- validation procedures
66:
67: PROCEDURE Validate_sales_lead_contact(
68: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
69: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
70: P_Validation_mode IN VARCHAR2,
71: P_SALES_LEAD_CONTACT_Rec IN AS_SALES_LEADS_PUB.SALES_LEAD_CONTACT_Rec_Type,
72: X_Return_Status OUT NOCOPY VARCHAR2,
73: X_Msg_Count OUT NOCOPY NUMBER,
82: -- API Name: Create_sales_lead_contacts
83:
84: PROCEDURE Create_sales_lead_contacts(
85: P_Api_Version_Number IN NUMBER,
86: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
87: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
88: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
89: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
90: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
83:
84: PROCEDURE Create_sales_lead_contacts(
85: P_Api_Version_Number IN NUMBER,
86: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
87: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
88: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
89: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
90: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
91: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
84: PROCEDURE Create_sales_lead_contacts(
85: P_Api_Version_Number IN NUMBER,
86: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
87: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
88: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
89: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
90: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
91: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
92: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
85: P_Api_Version_Number IN NUMBER,
86: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
87: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
88: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
89: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
90: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
91: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
92: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
93: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
86: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
87: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
88: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
89: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
90: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
91: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
92: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
93: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
94: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
87: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
88: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
89: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
90: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
91: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
92: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
93: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
94: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
95: P_SALES_LEAD_CONTACT_Tbl IN
88: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
89: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
90: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
91: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
92: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
93: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
94: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
95: P_SALES_LEAD_CONTACT_Tbl IN
96: AS_SALES_LEADS_PUB.SALES_LEAD_CONTACT_Tbl_Type
107: -- API Name: Update_sales_lead_contacts
108:
109: PROCEDURE Update_sales_lead_contacts(
110: P_Api_Version_Number IN NUMBER,
111: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
112: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
113: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
114: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
115: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
108:
109: PROCEDURE Update_sales_lead_contacts(
110: P_Api_Version_Number IN NUMBER,
111: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
112: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
113: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
114: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
115: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
116: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
109: PROCEDURE Update_sales_lead_contacts(
110: P_Api_Version_Number IN NUMBER,
111: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
112: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
113: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
114: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
115: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
116: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
117: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
110: P_Api_Version_Number IN NUMBER,
111: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
112: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
113: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
114: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
115: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
116: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
117: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
118: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
111: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
112: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
113: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
114: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
115: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
116: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
117: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
118: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
119: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
112: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
113: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
114: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
115: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
116: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
117: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
118: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
119: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
120: P_SALES_LEAD_CONTACT_Tbl IN
113: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
114: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
115: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
116: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
117: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
118: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
119: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
120: P_SALES_LEAD_CONTACT_Tbl IN
121: AS_SALES_LEADS_PUB.SALES_LEAD_CONTACT_Tbl_Type,
130: -- API Name: Delete_sales_lead_contacts
131:
132: PROCEDURE Delete_sales_lead_contacts(
133: P_Api_Version_Number IN NUMBER,
134: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
135: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
136: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
137: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
138: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
131:
132: PROCEDURE Delete_sales_lead_contacts(
133: P_Api_Version_Number IN NUMBER,
134: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
135: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
136: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
137: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
138: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
139: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
132: PROCEDURE Delete_sales_lead_contacts(
133: P_Api_Version_Number IN NUMBER,
134: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
135: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
136: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
137: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
138: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
139: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
140: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
133: P_Api_Version_Number IN NUMBER,
134: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
135: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
136: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
137: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
138: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
139: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
140: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
141: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
134: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
135: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
136: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
137: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
138: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
139: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
140: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
141: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
142: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
135: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
136: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
137: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
138: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
139: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
140: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
141: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
142: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
143: P_SALES_LEAD_CONTACT_Tbl IN
136: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
137: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
138: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
139: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
140: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
141: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
142: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
143: P_SALES_LEAD_CONTACT_Tbl IN
144: AS_SALES_LEADS_PUB.SALES_LEAD_CONTACT_Tbl_Type,
153: -- API Name: Check_primary_contact
154:
155: PROCEDURE Check_primary_contact (
156: P_Api_Version_Number IN NUMBER,
157: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
158: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
159: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
160: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
161: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
154:
155: PROCEDURE Check_primary_contact (
156: P_Api_Version_Number IN NUMBER,
157: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
158: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
159: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
160: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
161: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
162: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
155: PROCEDURE Check_primary_contact (
156: P_Api_Version_Number IN NUMBER,
157: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
158: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
159: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
160: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
161: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
162: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
163: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
156: P_Api_Version_Number IN NUMBER,
157: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
158: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
159: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
160: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
161: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
162: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
163: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
164: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
157: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
158: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
159: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
160: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
161: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
162: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
163: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
164: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
165: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
158: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
159: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
160: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
161: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
162: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
163: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
164: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
165: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
166: P_SALES_LEAD_ID IN NUMBER,
159: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
160: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
161: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
162: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
163: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
164: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
165: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
166: P_SALES_LEAD_ID IN NUMBER,
167: X_Return_Status OUT NOCOPY VARCHAR2,