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.AS_LINK_LEAD_OPP_PUB dependencies on FND_API

Line 24: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

20:
21: -- API Name: Get_Potential_Opportunity
22: PROCEDURE Get_Potential_Opportunity(
23: P_Api_Version_Number IN NUMBER,
24: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
25: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
26: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
27: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
28: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 25: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

21: -- API Name: Get_Potential_Opportunity
22: PROCEDURE Get_Potential_Opportunity(
23: P_Api_Version_Number IN NUMBER,
24: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
25: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
26: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
27: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
28: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
29: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,

Line 26: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

22: PROCEDURE Get_Potential_Opportunity(
23: P_Api_Version_Number IN NUMBER,
24: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
25: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
26: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
27: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
28: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
29: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
30: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,

Line 27: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

23: P_Api_Version_Number IN NUMBER,
24: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
25: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
26: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
27: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
28: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
29: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
30: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
31: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type

Line 28: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

24: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
25: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
26: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
27: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
28: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
29: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
30: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
31: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
32: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,

Line 29: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,

25: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
26: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
27: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
28: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
29: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
30: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
31: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
32: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
33: P_SALES_LEAD_rec IN AS_SALES_LEADS_PUB.SALES_LEAD_rec_type,

Line 30: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,

26: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
27: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
28: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
29: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
30: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
31: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
32: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
33: P_SALES_LEAD_rec IN AS_SALES_LEADS_PUB.SALES_LEAD_rec_type,
34: X_Return_Status OUT NOCOPY VARCHAR2,

Line 51: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

47: -- Standard Start of API savepoint
48: SAVEPOINT GET_POTENTIAL_OPPORTUNITY_PUB;
49:
50: -- Standard call to check for call compatibility.
51: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
52: p_api_version_number,
53: l_api_name,
54: G_PKG_NAME)
55: THEN

Line 56: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

52: p_api_version_number,
53: l_api_name,
54: G_PKG_NAME)
55: THEN
56: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
57: END IF;
58: l_debug := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
59:
60: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 61: IF FND_API.to_Boolean( p_init_msg_list )

57: END IF;
58: l_debug := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
59:
60: -- Initialize message list if p_init_msg_list is set to TRUE.
61: IF FND_API.to_Boolean( p_init_msg_list )
62: THEN
63: FND_MSG_PUB.initialize;
64: END IF;
65:

Line 72: x_return_status := FND_API.G_RET_STS_SUCCESS;

68: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Pub: ' || l_api_name || ' Start');
69: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
70: END IF;
71: -- Initialize API return status to SUCCESS
72: x_return_status := FND_API.G_RET_STS_SUCCESS;
73:
74: --
75: -- API body
76: --

Line 85: P_Init_Msg_List => FND_API.G_FALSE,

81: END IF;
82:
83: AS_SALES_LEAD_OPP_PVT.Get_Potential_Opportunity(
84: P_Api_Version_Number => 2.0,
85: P_Init_Msg_List => FND_API.G_FALSE,
86: P_Commit => FND_API.G_FALSE,
87: P_Validation_Level => P_Validation_Level,
88: P_Check_Access_Flag => P_Check_Access_Flag,
89: P_Admin_Flag => P_Admin_Flag,

Line 86: P_Commit => FND_API.G_FALSE,

82:
83: AS_SALES_LEAD_OPP_PVT.Get_Potential_Opportunity(
84: P_Api_Version_Number => 2.0,
85: P_Init_Msg_List => FND_API.G_FALSE,
86: P_Commit => FND_API.G_FALSE,
87: P_Validation_Level => P_Validation_Level,
88: P_Check_Access_Flag => P_Check_Access_Flag,
89: P_Admin_Flag => P_Admin_Flag,
90: P_Admin_Group_Id => P_Admin_Group_Id,

Line 102: IF x_return_status = FND_API.G_RET_STS_ERROR then

98: X_OPP_LINES_tbl => X_OPP_LINES_tbl
99: );
100:
101: -- Check return status from the above procedure call
102: IF x_return_status = FND_API.G_RET_STS_ERROR then
103: raise FND_API.G_EXC_ERROR;
104: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
105: raise FND_API.G_EXC_UNEXPECTED_ERROR;
106: END IF;

Line 103: raise FND_API.G_EXC_ERROR;

99: );
100:
101: -- Check return status from the above procedure call
102: IF x_return_status = FND_API.G_RET_STS_ERROR then
103: raise FND_API.G_EXC_ERROR;
104: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
105: raise FND_API.G_EXC_UNEXPECTED_ERROR;
106: END IF;
107:

Line 104: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

100:
101: -- Check return status from the above procedure call
102: IF x_return_status = FND_API.G_RET_STS_ERROR then
103: raise FND_API.G_EXC_ERROR;
104: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
105: raise FND_API.G_EXC_UNEXPECTED_ERROR;
106: END IF;
107:
108: --

Line 105: raise FND_API.G_EXC_UNEXPECTED_ERROR;

101: -- Check return status from the above procedure call
102: IF x_return_status = FND_API.G_RET_STS_ERROR then
103: raise FND_API.G_EXC_ERROR;
104: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
105: raise FND_API.G_EXC_UNEXPECTED_ERROR;
106: END IF;
107:
108: --
109: -- End of API body

Line 111: IF FND_API.to_Boolean( p_commit )

107:
108: --
109: -- End of API body
110: --
111: IF FND_API.to_Boolean( p_commit )
112: THEN
113: COMMIT WORK;
114: END IF;
115:

Line 129: WHEN FND_API.G_EXC_ERROR THEN

125: p_data => x_msg_data
126: );
127:
128: EXCEPTION
129: WHEN FND_API.G_EXC_ERROR THEN
130: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
131: P_MODULE => l_module
132: ,P_API_NAME => L_API_NAME
133: ,P_PKG_NAME => G_PKG_NAME

Line 140: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

136: ,X_MSG_COUNT => X_MSG_COUNT
137: ,X_MSG_DATA => X_MSG_DATA
138: ,X_RETURN_STATUS => X_RETURN_STATUS);
139:
140: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
141: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
142: P_MODULE => l_module
143: ,P_API_NAME => L_API_NAME
144: ,P_PKG_NAME => G_PKG_NAME

Line 171: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

167: -- API Name: Copy_Lead_To_Opportunity
168:
169: PROCEDURE Copy_Lead_To_Opportunity(
170: P_Api_Version_Number IN NUMBER,
171: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
172: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
173: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
174: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
175: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 172: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

168:
169: PROCEDURE Copy_Lead_To_Opportunity(
170: P_Api_Version_Number IN NUMBER,
171: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
172: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
173: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
174: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
175: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
176: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,

Line 173: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

169: PROCEDURE Copy_Lead_To_Opportunity(
170: P_Api_Version_Number IN NUMBER,
171: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
172: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
173: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
174: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
175: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
176: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
177: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,

Line 174: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

170: P_Api_Version_Number IN NUMBER,
171: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
172: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
173: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
174: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
175: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
176: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
177: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
178: P_identity_salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,

Line 175: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

171: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
172: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
173: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
174: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
175: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
176: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
177: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
178: P_identity_salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
179: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type

Line 176: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,

172: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
173: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
174: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
175: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
176: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
177: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
178: P_identity_salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
179: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
180: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,

Line 177: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,

173: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
174: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
175: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
176: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
177: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
178: P_identity_salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
179: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
180: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
181: P_SALES_LEAD_ID IN NUMBER,

Line 178: P_identity_salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,

174: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
175: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
176: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
177: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
178: P_identity_salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
179: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
180: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
181: P_SALES_LEAD_ID IN NUMBER,
182: P_SALES_LEAD_LINE_TBL IN AS_SALES_LEADS_PUB.SALES_LEAD_LINE_TBL_TYPE

Line 203: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

199: -- Standard Start of API savepoint
200: SAVEPOINT COPY_LEAD_TO_OPPORTUNITY_PUB;
201:
202: -- Standard call to check for call compatibility.
203: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
204: p_api_version_number,
205: l_api_name,
206: G_PKG_NAME)
207: THEN

Line 208: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

204: p_api_version_number,
205: l_api_name,
206: G_PKG_NAME)
207: THEN
208: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
209: END IF;
210: l_debug := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
211:
212:

Line 214: IF FND_API.to_Boolean( p_init_msg_list )

210: l_debug := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
211:
212:
213: -- Initialize message list if p_init_msg_list is set to TRUE.
214: IF FND_API.to_Boolean( p_init_msg_list )
215: THEN
216: FND_MSG_PUB.initialize;
217: END IF;
218:

Line 225: x_return_status := FND_API.G_RET_STS_SUCCESS;

221: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Pub: ' || l_api_name || ' Start');
222: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
223: END IF;
224: -- Initialize API return status to SUCCESS
225: x_return_status := FND_API.G_RET_STS_SUCCESS;
226:
227: --
228: -- Pre User Hook
229: --

Line 240: p_init_msg_list => FND_API.G_FALSE,

236: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Call pre user hook is true');
237: END IF;
238: AS_LINK_LEAD_OPP_UHK.Copy_Lead_To_Opp_Pre (
239: p_api_version_number => 2.0,
240: p_init_msg_list => FND_API.G_FALSE,
241: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
242: p_commit => FND_API.G_FALSE,
243: p_sales_lead_id => p_sales_lead_id,
244: p_opportunity_id => p_opportunity_id,

Line 241: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

237: END IF;
238: AS_LINK_LEAD_OPP_UHK.Copy_Lead_To_Opp_Pre (
239: p_api_version_number => 2.0,
240: p_init_msg_list => FND_API.G_FALSE,
241: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
242: p_commit => FND_API.G_FALSE,
243: p_sales_lead_id => p_sales_lead_id,
244: p_opportunity_id => p_opportunity_id,
245: x_return_status => x_return_status,

Line 242: p_commit => FND_API.G_FALSE,

238: AS_LINK_LEAD_OPP_UHK.Copy_Lead_To_Opp_Pre (
239: p_api_version_number => 2.0,
240: p_init_msg_list => FND_API.G_FALSE,
241: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
242: p_commit => FND_API.G_FALSE,
243: p_sales_lead_id => p_sales_lead_id,
244: p_opportunity_id => p_opportunity_id,
245: x_return_status => x_return_status,
246: x_msg_count => x_msg_count,

Line 250: IF x_return_status = FND_API.G_RET_STS_ERROR then

246: x_msg_count => x_msg_count,
247: x_msg_data => x_msg_data);
248: END IF;
249:
250: IF x_return_status = FND_API.G_RET_STS_ERROR then
251: raise FND_API.G_EXC_ERROR;
252: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
253: raise FND_API.G_EXC_UNEXPECTED_ERROR;
254: END IF;

Line 251: raise FND_API.G_EXC_ERROR;

247: x_msg_data => x_msg_data);
248: END IF;
249:
250: IF x_return_status = FND_API.G_RET_STS_ERROR then
251: raise FND_API.G_EXC_ERROR;
252: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
253: raise FND_API.G_EXC_UNEXPECTED_ERROR;
254: END IF;
255:

Line 252: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

248: END IF;
249:
250: IF x_return_status = FND_API.G_RET_STS_ERROR then
251: raise FND_API.G_EXC_ERROR;
252: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
253: raise FND_API.G_EXC_UNEXPECTED_ERROR;
254: END IF;
255:
256: --

Line 253: raise FND_API.G_EXC_UNEXPECTED_ERROR;

249:
250: IF x_return_status = FND_API.G_RET_STS_ERROR then
251: raise FND_API.G_EXC_ERROR;
252: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
253: raise FND_API.G_EXC_UNEXPECTED_ERROR;
254: END IF;
255:
256: --
257: -- API body

Line 265: P_Init_Msg_List => FND_API.G_FALSE,

261: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'PUB: Call PVT.Copy_Lead_To_Opportunity');
262: END IF;
263: AS_SALES_LEAD_OPP_PVT.Copy_Lead_To_Opportunity(
264: P_Api_Version_Number => 2.0,
265: P_Init_Msg_List => FND_API.G_FALSE,
266: P_Commit => FND_API.G_FALSE,
267: P_Validation_Level => P_Validation_Level,
268: P_Check_Access_Flag => P_Check_Access_Flag,
269: P_Admin_Flag => P_Admin_Flag,

Line 266: P_Commit => FND_API.G_FALSE,

262: END IF;
263: AS_SALES_LEAD_OPP_PVT.Copy_Lead_To_Opportunity(
264: P_Api_Version_Number => 2.0,
265: P_Init_Msg_List => FND_API.G_FALSE,
266: P_Commit => FND_API.G_FALSE,
267: P_Validation_Level => P_Validation_Level,
268: P_Check_Access_Flag => P_Check_Access_Flag,
269: P_Admin_Flag => P_Admin_Flag,
270: P_Admin_Group_Id => P_Admin_Group_Id,

Line 282: IF x_return_status = FND_API.G_RET_STS_ERROR then

278: X_Msg_Count => x_msg_count,
279: X_Msg_Data => x_msg_data);
280:
281: -- Check return status from the above procedure call
282: IF x_return_status = FND_API.G_RET_STS_ERROR then
283: raise FND_API.G_EXC_ERROR;
284: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
285: raise FND_API.G_EXC_UNEXPECTED_ERROR;
286: END IF;

Line 283: raise FND_API.G_EXC_ERROR;

279: X_Msg_Data => x_msg_data);
280:
281: -- Check return status from the above procedure call
282: IF x_return_status = FND_API.G_RET_STS_ERROR then
283: raise FND_API.G_EXC_ERROR;
284: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
285: raise FND_API.G_EXC_UNEXPECTED_ERROR;
286: END IF;
287:

Line 284: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

280:
281: -- Check return status from the above procedure call
282: IF x_return_status = FND_API.G_RET_STS_ERROR then
283: raise FND_API.G_EXC_ERROR;
284: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
285: raise FND_API.G_EXC_UNEXPECTED_ERROR;
286: END IF;
287:
288: --

Line 285: raise FND_API.G_EXC_UNEXPECTED_ERROR;

281: -- Check return status from the above procedure call
282: IF x_return_status = FND_API.G_RET_STS_ERROR then
283: raise FND_API.G_EXC_ERROR;
284: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
285: raise FND_API.G_EXC_UNEXPECTED_ERROR;
286: END IF;
287:
288: --
289: -- End of API body

Line 305: p_init_msg_list => FND_API.G_FALSE,

301: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Call post user hook is true');
302: END IF;
303: AS_LINK_LEAD_OPP_UHK.Copy_Lead_To_Opp_Post (
304: p_api_version_number => 2.0,
305: p_init_msg_list => FND_API.G_FALSE,
306: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
307: p_commit => FND_API.G_FALSE,
308: p_sales_lead_id => p_sales_lead_id,
309: p_opportunity_id => p_opportunity_id,

Line 306: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

302: END IF;
303: AS_LINK_LEAD_OPP_UHK.Copy_Lead_To_Opp_Post (
304: p_api_version_number => 2.0,
305: p_init_msg_list => FND_API.G_FALSE,
306: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
307: p_commit => FND_API.G_FALSE,
308: p_sales_lead_id => p_sales_lead_id,
309: p_opportunity_id => p_opportunity_id,
310: x_return_status => x_return_status,

Line 307: p_commit => FND_API.G_FALSE,

303: AS_LINK_LEAD_OPP_UHK.Copy_Lead_To_Opp_Post (
304: p_api_version_number => 2.0,
305: p_init_msg_list => FND_API.G_FALSE,
306: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
307: p_commit => FND_API.G_FALSE,
308: p_sales_lead_id => p_sales_lead_id,
309: p_opportunity_id => p_opportunity_id,
310: x_return_status => x_return_status,
311: x_msg_count => x_msg_count,

Line 315: IF x_return_status = FND_API.G_RET_STS_ERROR then

311: x_msg_count => x_msg_count,
312: x_msg_data => x_msg_data);
313: END IF;
314:
315: IF x_return_status = FND_API.G_RET_STS_ERROR then
316: raise FND_API.G_EXC_ERROR;
317: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
318: raise FND_API.G_EXC_UNEXPECTED_ERROR;
319: END IF;

Line 316: raise FND_API.G_EXC_ERROR;

312: x_msg_data => x_msg_data);
313: END IF;
314:
315: IF x_return_status = FND_API.G_RET_STS_ERROR then
316: raise FND_API.G_EXC_ERROR;
317: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
318: raise FND_API.G_EXC_UNEXPECTED_ERROR;
319: END IF;
320:

Line 317: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

313: END IF;
314:
315: IF x_return_status = FND_API.G_RET_STS_ERROR then
316: raise FND_API.G_EXC_ERROR;
317: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
318: raise FND_API.G_EXC_UNEXPECTED_ERROR;
319: END IF;
320:
321: IF FND_API.to_Boolean( p_commit )

Line 318: raise FND_API.G_EXC_UNEXPECTED_ERROR;

314:
315: IF x_return_status = FND_API.G_RET_STS_ERROR then
316: raise FND_API.G_EXC_ERROR;
317: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
318: raise FND_API.G_EXC_UNEXPECTED_ERROR;
319: END IF;
320:
321: IF FND_API.to_Boolean( p_commit )
322: THEN

Line 321: IF FND_API.to_Boolean( p_commit )

317: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
318: raise FND_API.G_EXC_UNEXPECTED_ERROR;
319: END IF;
320:
321: IF FND_API.to_Boolean( p_commit )
322: THEN
323: COMMIT WORK;
324: END IF;
325:

Line 339: WHEN FND_API.G_EXC_ERROR THEN

335: p_data => x_msg_data
336: );
337:
338: EXCEPTION
339: WHEN FND_API.G_EXC_ERROR THEN
340: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
341: P_MODULE => l_module
342: ,P_API_NAME => L_API_NAME
343: ,P_PKG_NAME => G_PKG_NAME

Line 350: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

346: ,X_MSG_COUNT => X_MSG_COUNT
347: ,X_MSG_DATA => X_MSG_DATA
348: ,X_RETURN_STATUS => X_RETURN_STATUS);
349:
350: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
351: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
352: P_MODULE => l_module
353: ,P_API_NAME => L_API_NAME
354: ,P_PKG_NAME => G_PKG_NAME

Line 381: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

377: -- API Name: Link_Lead_To_Opportunity
378:
379: PROCEDURE Link_Lead_To_Opportunity(
380: P_Api_Version_Number IN NUMBER,
381: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
382: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
383: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
384: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
385: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 382: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

378:
379: PROCEDURE Link_Lead_To_Opportunity(
380: P_Api_Version_Number IN NUMBER,
381: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
382: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
383: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
384: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
385: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
386: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,

Line 383: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

379: PROCEDURE Link_Lead_To_Opportunity(
380: P_Api_Version_Number IN NUMBER,
381: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
382: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
383: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
384: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
385: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
386: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
387: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,

Line 384: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

380: P_Api_Version_Number IN NUMBER,
381: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
382: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
383: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
384: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
385: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
386: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
387: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
388: P_identity_salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,

Line 385: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

381: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
382: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
383: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
384: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
385: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
386: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
387: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
388: P_identity_salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
389: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type

Line 386: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,

382: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
383: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
384: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
385: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
386: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
387: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
388: P_identity_salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
389: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
390: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,

Line 387: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,

383: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
384: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
385: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
386: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
387: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
388: P_identity_salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
389: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
390: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
391: P_SALES_LEAD_ID IN NUMBER,

Line 388: P_identity_salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,

384: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
385: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
386: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
387: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
388: P_identity_salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
389: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
390: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
391: P_SALES_LEAD_ID IN NUMBER,
392: P_OPPORTUNITY_ID IN NUMBER,

Line 411: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

407: -- Standard Start of API savepoint
408: SAVEPOINT LINK_LEAD_TO_OPPORTUNITY_PUB;
409:
410: -- Standard call to check for call compatibility.
411: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
412: p_api_version_number,
413: l_api_name,
414: G_PKG_NAME)
415: THEN

Line 416: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

412: p_api_version_number,
413: l_api_name,
414: G_PKG_NAME)
415: THEN
416: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
417: END IF;
418: l_debug := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
419:
420:

Line 422: IF FND_API.to_Boolean( p_init_msg_list )

418: l_debug := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
419:
420:
421: -- Initialize message list if p_init_msg_list is set to TRUE.
422: IF FND_API.to_Boolean( p_init_msg_list )
423: THEN
424: FND_MSG_PUB.initialize;
425: END IF;
426:

Line 433: x_return_status := FND_API.G_RET_STS_SUCCESS;

429: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Pub: ' || l_api_name || ' Start');
430: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
431: END IF;
432: -- Initialize API return status to SUCCESS
433: x_return_status := FND_API.G_RET_STS_SUCCESS;
434:
435: --
436: -- Pre User Hook
437: --

Line 448: p_init_msg_list => FND_API.G_FALSE,

444: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Call pre user hook is true');
445: END IF;
446: AS_LINK_LEAD_OPP_UHK.Link_Lead_To_Opp_Pre (
447: p_api_version_number => 2.0,
448: p_init_msg_list => FND_API.G_FALSE,
449: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
450: p_commit => FND_API.G_FALSE,
451: p_sales_lead_id => p_sales_lead_id,
452: p_opportunity_id => p_opportunity_id,

Line 449: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

445: END IF;
446: AS_LINK_LEAD_OPP_UHK.Link_Lead_To_Opp_Pre (
447: p_api_version_number => 2.0,
448: p_init_msg_list => FND_API.G_FALSE,
449: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
450: p_commit => FND_API.G_FALSE,
451: p_sales_lead_id => p_sales_lead_id,
452: p_opportunity_id => p_opportunity_id,
453: x_return_status => x_return_status,

Line 450: p_commit => FND_API.G_FALSE,

446: AS_LINK_LEAD_OPP_UHK.Link_Lead_To_Opp_Pre (
447: p_api_version_number => 2.0,
448: p_init_msg_list => FND_API.G_FALSE,
449: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
450: p_commit => FND_API.G_FALSE,
451: p_sales_lead_id => p_sales_lead_id,
452: p_opportunity_id => p_opportunity_id,
453: x_return_status => x_return_status,
454: x_msg_count => x_msg_count,

Line 458: IF x_return_status = FND_API.G_RET_STS_ERROR then

454: x_msg_count => x_msg_count,
455: x_msg_data => x_msg_data);
456: END IF;
457:
458: IF x_return_status = FND_API.G_RET_STS_ERROR then
459: raise FND_API.G_EXC_ERROR;
460: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
461: raise FND_API.G_EXC_UNEXPECTED_ERROR;
462: END IF;

Line 459: raise FND_API.G_EXC_ERROR;

455: x_msg_data => x_msg_data);
456: END IF;
457:
458: IF x_return_status = FND_API.G_RET_STS_ERROR then
459: raise FND_API.G_EXC_ERROR;
460: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
461: raise FND_API.G_EXC_UNEXPECTED_ERROR;
462: END IF;
463:

Line 460: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

456: END IF;
457:
458: IF x_return_status = FND_API.G_RET_STS_ERROR then
459: raise FND_API.G_EXC_ERROR;
460: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
461: raise FND_API.G_EXC_UNEXPECTED_ERROR;
462: END IF;
463:
464: --

Line 461: raise FND_API.G_EXC_UNEXPECTED_ERROR;

457:
458: IF x_return_status = FND_API.G_RET_STS_ERROR then
459: raise FND_API.G_EXC_ERROR;
460: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
461: raise FND_API.G_EXC_UNEXPECTED_ERROR;
462: END IF;
463:
464: --
465: -- API body

Line 473: P_Init_Msg_List => FND_API.G_FALSE,

469: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'PUB: Call PVT.Link_Lead_To_Opportunity');
470: END IF;
471: AS_SALES_LEAD_OPP_PVT.Link_Lead_To_Opportunity(
472: P_Api_Version_Number => 2.0,
473: P_Init_Msg_List => FND_API.G_FALSE,
474: P_Commit => FND_API.G_FALSE,
475: P_Validation_Level => P_Validation_Level,
476: P_Check_Access_Flag => P_Check_Access_Flag,
477: P_Admin_Flag => P_Admin_Flag,

Line 474: P_Commit => FND_API.G_FALSE,

470: END IF;
471: AS_SALES_LEAD_OPP_PVT.Link_Lead_To_Opportunity(
472: P_Api_Version_Number => 2.0,
473: P_Init_Msg_List => FND_API.G_FALSE,
474: P_Commit => FND_API.G_FALSE,
475: P_Validation_Level => P_Validation_Level,
476: P_Check_Access_Flag => P_Check_Access_Flag,
477: P_Admin_Flag => P_Admin_Flag,
478: P_Admin_Group_Id => P_Admin_Group_Id,

Line 489: IF x_return_status = FND_API.G_RET_STS_ERROR then

485: X_Msg_Count => x_msg_count,
486: X_Msg_Data => x_msg_data);
487:
488: -- Check return status from the above procedure call
489: IF x_return_status = FND_API.G_RET_STS_ERROR then
490: raise FND_API.G_EXC_ERROR;
491: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
492: raise FND_API.G_EXC_UNEXPECTED_ERROR;
493: END IF;

Line 490: raise FND_API.G_EXC_ERROR;

486: X_Msg_Data => x_msg_data);
487:
488: -- Check return status from the above procedure call
489: IF x_return_status = FND_API.G_RET_STS_ERROR then
490: raise FND_API.G_EXC_ERROR;
491: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
492: raise FND_API.G_EXC_UNEXPECTED_ERROR;
493: END IF;
494:

Line 491: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

487:
488: -- Check return status from the above procedure call
489: IF x_return_status = FND_API.G_RET_STS_ERROR then
490: raise FND_API.G_EXC_ERROR;
491: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
492: raise FND_API.G_EXC_UNEXPECTED_ERROR;
493: END IF;
494:
495: --

Line 492: raise FND_API.G_EXC_UNEXPECTED_ERROR;

488: -- Check return status from the above procedure call
489: IF x_return_status = FND_API.G_RET_STS_ERROR then
490: raise FND_API.G_EXC_ERROR;
491: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
492: raise FND_API.G_EXC_UNEXPECTED_ERROR;
493: END IF;
494:
495: --
496: -- Post User Hook

Line 508: p_init_msg_list => FND_API.G_FALSE,

504: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Call post user hook is true');
505: END IF;
506: AS_LINK_LEAD_OPP_UHK.Link_Lead_To_Opp_Post (
507: p_api_version_number => 2.0,
508: p_init_msg_list => FND_API.G_FALSE,
509: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
510: p_commit => FND_API.G_FALSE,
511: p_sales_lead_id => p_sales_lead_id,
512: p_opportunity_id => p_opportunity_id,

Line 509: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

505: END IF;
506: AS_LINK_LEAD_OPP_UHK.Link_Lead_To_Opp_Post (
507: p_api_version_number => 2.0,
508: p_init_msg_list => FND_API.G_FALSE,
509: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
510: p_commit => FND_API.G_FALSE,
511: p_sales_lead_id => p_sales_lead_id,
512: p_opportunity_id => p_opportunity_id,
513: x_return_status => x_return_status,

Line 510: p_commit => FND_API.G_FALSE,

506: AS_LINK_LEAD_OPP_UHK.Link_Lead_To_Opp_Post (
507: p_api_version_number => 2.0,
508: p_init_msg_list => FND_API.G_FALSE,
509: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
510: p_commit => FND_API.G_FALSE,
511: p_sales_lead_id => p_sales_lead_id,
512: p_opportunity_id => p_opportunity_id,
513: x_return_status => x_return_status,
514: x_msg_count => x_msg_count,

Line 518: IF x_return_status = FND_API.G_RET_STS_ERROR then

514: x_msg_count => x_msg_count,
515: x_msg_data => x_msg_data);
516: END IF;
517:
518: IF x_return_status = FND_API.G_RET_STS_ERROR then
519: raise FND_API.G_EXC_ERROR;
520: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
521: raise FND_API.G_EXC_UNEXPECTED_ERROR;
522: END IF;

Line 519: raise FND_API.G_EXC_ERROR;

515: x_msg_data => x_msg_data);
516: END IF;
517:
518: IF x_return_status = FND_API.G_RET_STS_ERROR then
519: raise FND_API.G_EXC_ERROR;
520: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
521: raise FND_API.G_EXC_UNEXPECTED_ERROR;
522: END IF;
523:

Line 520: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

516: END IF;
517:
518: IF x_return_status = FND_API.G_RET_STS_ERROR then
519: raise FND_API.G_EXC_ERROR;
520: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
521: raise FND_API.G_EXC_UNEXPECTED_ERROR;
522: END IF;
523:
524: --

Line 521: raise FND_API.G_EXC_UNEXPECTED_ERROR;

517:
518: IF x_return_status = FND_API.G_RET_STS_ERROR then
519: raise FND_API.G_EXC_ERROR;
520: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
521: raise FND_API.G_EXC_UNEXPECTED_ERROR;
522: END IF;
523:
524: --
525: -- End of API body

Line 527: IF FND_API.to_Boolean( p_commit )

523:
524: --
525: -- End of API body
526: --
527: IF FND_API.to_Boolean( p_commit )
528: THEN
529: COMMIT WORK;
530: END IF;
531:

Line 545: WHEN FND_API.G_EXC_ERROR THEN

541: p_data => x_msg_data
542: );
543:
544: EXCEPTION
545: WHEN FND_API.G_EXC_ERROR THEN
546: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
547: P_MODULE => l_module
548: ,P_API_NAME => L_API_NAME
549: ,P_PKG_NAME => G_PKG_NAME

Line 556: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

552: ,X_MSG_COUNT => X_MSG_COUNT
553: ,X_MSG_DATA => X_MSG_DATA
554: ,X_RETURN_STATUS => X_RETURN_STATUS);
555:
556: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
557: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
558: P_MODULE => l_module
559: ,P_API_NAME => L_API_NAME
560: ,P_PKG_NAME => G_PKG_NAME

Line 585: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

581:
582: -- API Name: Create_Opportunity_For_Lead
583: PROCEDURE Create_Opportunity_For_Lead(
584: P_Api_Version_Number IN NUMBER,
585: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
586: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
587: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
588: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
589: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 586: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

582: -- API Name: Create_Opportunity_For_Lead
583: PROCEDURE Create_Opportunity_For_Lead(
584: P_Api_Version_Number IN NUMBER,
585: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
586: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
587: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
588: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
589: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
590: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,

Line 587: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

583: PROCEDURE Create_Opportunity_For_Lead(
584: P_Api_Version_Number IN NUMBER,
585: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
586: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
587: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
588: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
589: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
590: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
591: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,

Line 588: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

584: P_Api_Version_Number IN NUMBER,
585: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
586: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
587: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
588: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
589: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
590: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
591: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
592: P_identity_salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,

Line 589: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

585: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
586: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
587: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
588: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
589: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
590: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
591: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
592: P_identity_salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
593: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type

Line 590: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,

586: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
587: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
588: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
589: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
590: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
591: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
592: P_identity_salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
593: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
594: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,

Line 591: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,

587: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
588: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
589: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
590: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
591: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
592: P_identity_salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
593: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
594: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
595: P_SALES_LEAD_ID IN NUMBER,

Line 592: P_identity_salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,

588: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
589: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
590: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
591: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
592: P_identity_salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
593: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
594: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
595: P_SALES_LEAD_ID IN NUMBER,
596: P_OPP_STATUS IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 596: P_OPP_STATUS IN VARCHAR2 := FND_API.G_MISS_CHAR,

592: P_identity_salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
593: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
594: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
595: P_SALES_LEAD_ID IN NUMBER,
596: P_OPP_STATUS IN VARCHAR2 := FND_API.G_MISS_CHAR,
597: X_Return_Status OUT NOCOPY VARCHAR2,
598: X_Msg_Count OUT NOCOPY NUMBER,
599: X_Msg_Data OUT NOCOPY VARCHAR2,
600: X_OPPORTUNITY_ID OUT NOCOPY NUMBER

Line 628: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

624: -- Standard Start of API savepoint
625: SAVEPOINT CREATE_OPP_FOR_LEAD_PUB;
626:
627: -- Standard call to check for call compatibility.
628: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
629: p_api_version_number,
630: l_api_name,
631: G_PKG_NAME)
632: THEN

Line 633: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

629: p_api_version_number,
630: l_api_name,
631: G_PKG_NAME)
632: THEN
633: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
634: END IF;
635: l_debug := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
636:
637:

Line 639: IF FND_API.to_Boolean( p_init_msg_list )

635: l_debug := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
636:
637:
638: -- Initialize message list if p_init_msg_list is set to TRUE.
639: IF FND_API.to_Boolean( p_init_msg_list )
640: THEN
641: FND_MSG_PUB.initialize;
642: END IF;
643:

Line 651: x_return_status := FND_API.G_RET_STS_SUCCESS;

647: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
648: END IF;
649:
650: -- Initialize API return status to SUCCESS
651: x_return_status := FND_API.G_RET_STS_SUCCESS;
652:
653: --
654: -- Pre User Hook
655: --

Line 666: p_init_msg_list => FND_API.G_FALSE,

662: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Call pre user hook is true');
663: END IF;
664: AS_LINK_LEAD_OPP_UHK.Create_Opp_For_Lead_Pre (
665: p_api_version_number => 2.0,
666: p_init_msg_list => FND_API.G_FALSE,
667: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
668: p_commit => FND_API.G_FALSE,
669: p_sales_lead_id => p_sales_lead_id,
670: p_opportunity_id => null,

Line 667: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

663: END IF;
664: AS_LINK_LEAD_OPP_UHK.Create_Opp_For_Lead_Pre (
665: p_api_version_number => 2.0,
666: p_init_msg_list => FND_API.G_FALSE,
667: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
668: p_commit => FND_API.G_FALSE,
669: p_sales_lead_id => p_sales_lead_id,
670: p_opportunity_id => null,
671: x_return_status => x_return_status,

Line 668: p_commit => FND_API.G_FALSE,

664: AS_LINK_LEAD_OPP_UHK.Create_Opp_For_Lead_Pre (
665: p_api_version_number => 2.0,
666: p_init_msg_list => FND_API.G_FALSE,
667: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
668: p_commit => FND_API.G_FALSE,
669: p_sales_lead_id => p_sales_lead_id,
670: p_opportunity_id => null,
671: x_return_status => x_return_status,
672: x_msg_count => x_msg_count,

Line 676: IF x_return_status = FND_API.G_RET_STS_ERROR then

672: x_msg_count => x_msg_count,
673: x_msg_data => x_msg_data);
674: END IF;
675:
676: IF x_return_status = FND_API.G_RET_STS_ERROR then
677: raise FND_API.G_EXC_ERROR;
678: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
679: raise FND_API.G_EXC_UNEXPECTED_ERROR;
680: END IF;

Line 677: raise FND_API.G_EXC_ERROR;

673: x_msg_data => x_msg_data);
674: END IF;
675:
676: IF x_return_status = FND_API.G_RET_STS_ERROR then
677: raise FND_API.G_EXC_ERROR;
678: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
679: raise FND_API.G_EXC_UNEXPECTED_ERROR;
680: END IF;
681:

Line 678: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

674: END IF;
675:
676: IF x_return_status = FND_API.G_RET_STS_ERROR then
677: raise FND_API.G_EXC_ERROR;
678: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
679: raise FND_API.G_EXC_UNEXPECTED_ERROR;
680: END IF;
681:
682: --

Line 679: raise FND_API.G_EXC_UNEXPECTED_ERROR;

675:
676: IF x_return_status = FND_API.G_RET_STS_ERROR then
677: raise FND_API.G_EXC_ERROR;
678: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
679: raise FND_API.G_EXC_UNEXPECTED_ERROR;
680: END IF;
681:
682: --
683: -- API body

Line 692: P_Init_Msg_List => FND_API.G_FALSE,

688: END IF;
689:
690: AS_SALES_LEAD_OPP_PVT.Create_Opportunity_For_Lead(
691: P_Api_Version_Number => 2.0,
692: P_Init_Msg_List => FND_API.G_FALSE,
693: P_Commit => FND_API.G_FALSE,
694: P_Validation_Level => P_Validation_Level, -- 100,
695: P_Check_Access_Flag => P_Check_Access_Flag, -- 'N',
696: P_Admin_Flag => P_Admin_Flag,

Line 693: P_Commit => FND_API.G_FALSE,

689:
690: AS_SALES_LEAD_OPP_PVT.Create_Opportunity_For_Lead(
691: P_Api_Version_Number => 2.0,
692: P_Init_Msg_List => FND_API.G_FALSE,
693: P_Commit => FND_API.G_FALSE,
694: P_Validation_Level => P_Validation_Level, -- 100,
695: P_Check_Access_Flag => P_Check_Access_Flag, -- 'N',
696: P_Admin_Flag => P_Admin_Flag,
697: P_Admin_Group_Id => P_Admin_Group_Id,

Line 709: IF x_return_status = FND_API.G_RET_STS_ERROR then

705: X_Msg_Data => x_msg_data,
706: X_OPPORTUNITY_ID => X_OPPORTUNITY_ID);
707:
708: -- Check return status from the above procedure call
709: IF x_return_status = FND_API.G_RET_STS_ERROR then
710: raise FND_API.G_EXC_ERROR;
711: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
712: raise FND_API.G_EXC_UNEXPECTED_ERROR;
713: END IF;

Line 710: raise FND_API.G_EXC_ERROR;

706: X_OPPORTUNITY_ID => X_OPPORTUNITY_ID);
707:
708: -- Check return status from the above procedure call
709: IF x_return_status = FND_API.G_RET_STS_ERROR then
710: raise FND_API.G_EXC_ERROR;
711: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
712: raise FND_API.G_EXC_UNEXPECTED_ERROR;
713: END IF;
714:

Line 711: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

707:
708: -- Check return status from the above procedure call
709: IF x_return_status = FND_API.G_RET_STS_ERROR then
710: raise FND_API.G_EXC_ERROR;
711: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
712: raise FND_API.G_EXC_UNEXPECTED_ERROR;
713: END IF;
714:
715:

Line 712: raise FND_API.G_EXC_UNEXPECTED_ERROR;

708: -- Check return status from the above procedure call
709: IF x_return_status = FND_API.G_RET_STS_ERROR then
710: raise FND_API.G_EXC_ERROR;
711: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
712: raise FND_API.G_EXC_UNEXPECTED_ERROR;
713: END IF;
714:
715:
716: --

Line 729: p_init_msg_list => FND_API.G_FALSE,

725: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Call post user hook is true');
726: END IF;
727: AS_LINK_LEAD_OPP_UHK.Create_Opp_For_Lead_Post (
728: p_api_version_number => 2.0,
729: p_init_msg_list => FND_API.G_FALSE,
730: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
731: p_commit => FND_API.G_FALSE,
732: p_sales_lead_id => p_sales_lead_id,
733: p_opportunity_id => x_opportunity_id,

Line 730: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

726: END IF;
727: AS_LINK_LEAD_OPP_UHK.Create_Opp_For_Lead_Post (
728: p_api_version_number => 2.0,
729: p_init_msg_list => FND_API.G_FALSE,
730: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
731: p_commit => FND_API.G_FALSE,
732: p_sales_lead_id => p_sales_lead_id,
733: p_opportunity_id => x_opportunity_id,
734: x_return_status => x_return_status,

Line 731: p_commit => FND_API.G_FALSE,

727: AS_LINK_LEAD_OPP_UHK.Create_Opp_For_Lead_Post (
728: p_api_version_number => 2.0,
729: p_init_msg_list => FND_API.G_FALSE,
730: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
731: p_commit => FND_API.G_FALSE,
732: p_sales_lead_id => p_sales_lead_id,
733: p_opportunity_id => x_opportunity_id,
734: x_return_status => x_return_status,
735: x_msg_count => x_msg_count,

Line 739: IF x_return_status = FND_API.G_RET_STS_ERROR then

735: x_msg_count => x_msg_count,
736: x_msg_data => x_msg_data);
737: END IF;
738:
739: IF x_return_status = FND_API.G_RET_STS_ERROR then
740: raise FND_API.G_EXC_ERROR;
741: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
742: raise FND_API.G_EXC_UNEXPECTED_ERROR;
743: END IF;

Line 740: raise FND_API.G_EXC_ERROR;

736: x_msg_data => x_msg_data);
737: END IF;
738:
739: IF x_return_status = FND_API.G_RET_STS_ERROR then
740: raise FND_API.G_EXC_ERROR;
741: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
742: raise FND_API.G_EXC_UNEXPECTED_ERROR;
743: END IF;
744: --

Line 741: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

737: END IF;
738:
739: IF x_return_status = FND_API.G_RET_STS_ERROR then
740: raise FND_API.G_EXC_ERROR;
741: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
742: raise FND_API.G_EXC_UNEXPECTED_ERROR;
743: END IF;
744: --
745: -- End of API body

Line 742: raise FND_API.G_EXC_UNEXPECTED_ERROR;

738:
739: IF x_return_status = FND_API.G_RET_STS_ERROR then
740: raise FND_API.G_EXC_ERROR;
741: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
742: raise FND_API.G_EXC_UNEXPECTED_ERROR;
743: END IF;
744: --
745: -- End of API body
746: --

Line 747: IF FND_API.to_Boolean( p_commit )

743: END IF;
744: --
745: -- End of API body
746: --
747: IF FND_API.to_Boolean( p_commit )
748: THEN
749: COMMIT WORK;
750: END IF;
751:

Line 763: WHEN FND_API.G_EXC_ERROR THEN

759: ( p_count => x_msg_count,
760: p_data => x_msg_data
761: );
762: EXCEPTION
763: WHEN FND_API.G_EXC_ERROR THEN
764: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
765: P_MODULE => l_module
766: ,P_API_NAME => L_API_NAME
767: ,P_PKG_NAME => G_PKG_NAME

Line 774: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

770: ,X_MSG_COUNT => X_MSG_COUNT
771: ,X_MSG_DATA => X_MSG_DATA
772: ,X_RETURN_STATUS => X_RETURN_STATUS);
773:
774: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
775: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
776: P_MODULE => l_module
777: ,P_API_NAME => L_API_NAME
778: ,P_PKG_NAME => G_PKG_NAME