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

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

20:
21:
22: PROCEDURE Create_sales_lead (
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:
22: PROCEDURE Create_sales_lead (
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 Create_sales_lead (
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_Salesgroup_Id IN NUMBER := FND_API.G_MISS_NUM,

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_Salesgroup_Id IN NUMBER := FND_API.G_MISS_NUM,
32: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type

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_Salesgroup_Id IN NUMBER := FND_API.G_MISS_NUM,
32: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
33: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,

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_Salesgroup_Id IN NUMBER := FND_API.G_MISS_NUM,
32: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
33: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
34: P_SALES_LEAD_Rec IN AS_SALES_LEADS_PUB.SALES_LEAD_Rec_Type

Line 31: P_Salesgroup_Id IN NUMBER := FND_API.G_MISS_NUM,

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_Salesgroup_Id IN NUMBER := FND_API.G_MISS_NUM,
32: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
33: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
34: P_SALES_LEAD_Rec IN AS_SALES_LEADS_PUB.SALES_LEAD_Rec_Type
35: := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_REC,

Line 117: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

113: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
114: 'Pub: ' || l_api_name || ' Start');
115:
116: -- Standard call to check for call compatibility.
117: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
118: p_api_version_number,
119: l_api_name,
120: G_PKG_NAME)
121: THEN

Line 122: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

118: p_api_version_number,
119: l_api_name,
120: G_PKG_NAME)
121: THEN
122: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
123: END IF;
124:
125: -- Initialize message list if p_init_msg_list is set to TRUE.
126: IF FND_API.to_Boolean( p_init_msg_list )

Line 126: IF FND_API.to_Boolean( p_init_msg_list )

122: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
123: END IF;
124:
125: -- Initialize message list if p_init_msg_list is set to TRUE.
126: IF FND_API.to_Boolean( p_init_msg_list )
127: THEN
128: FND_MSG_PUB.initialize;
129: END IF;
130:

Line 132: x_return_status := FND_API.G_RET_STS_SUCCESS;

128: FND_MSG_PUB.initialize;
129: END IF;
130:
131: -- Initialize API return status to SUCCESS
132: x_return_status := FND_API.G_RET_STS_SUCCESS;
133:
134: l_salesforce_id := P_Identity_Salesforce_Id;
135:
136: IF l_salesforce_id IS NULL OR l_salesforce_id = FND_API.G_MISS_NUM

Line 136: IF l_salesforce_id IS NULL OR l_salesforce_id = FND_API.G_MISS_NUM

132: x_return_status := FND_API.G_RET_STS_SUCCESS;
133:
134: l_salesforce_id := P_Identity_Salesforce_Id;
135:
136: IF l_salesforce_id IS NULL OR l_salesforce_id = FND_API.G_MISS_NUM
137: THEN
138: OPEN C_Get_SLAESFORCE(fnd_global.user_id);
139: FETCH C_Get_SLAESFORCE
140: INTO l_salesforce_id;

Line 148: IF P_Salesgroup_Id = FND_API.G_MISS_NUM

144: l_salesforce_id := fnd_profile.value('AS_DEFAULT_RESOURCE_ID');
145: End if;
146: END IF;
147:
148: IF P_Salesgroup_Id = FND_API.G_MISS_NUM
149: THEN
150: OPEN c_get_group_id (l_salesforce_id);
151: FETCH c_get_group_id INTO l_group_id;
152: CLOSE c_get_group_id;

Line 180: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

176: x_sales_lead_line_out_tbl => x_sales_lead_line_out_tbl,
177: x_sales_lead_cnt_out_tbl => x_sales_lead_cnt_out_tbl);
178:
179:
180: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
181: raise FND_API.G_EXC_ERROR;
182: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
183: raise FND_API.G_EXC_UNEXPECTED_ERROR;
184: END IF;

Line 181: raise FND_API.G_EXC_ERROR;

177: x_sales_lead_cnt_out_tbl => x_sales_lead_cnt_out_tbl);
178:
179:
180: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
181: raise FND_API.G_EXC_ERROR;
182: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
183: raise FND_API.G_EXC_UNEXPECTED_ERROR;
184: END IF;
185:

Line 182: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

178:
179:
180: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
181: raise FND_API.G_EXC_ERROR;
182: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
183: raise FND_API.G_EXC_UNEXPECTED_ERROR;
184: END IF;
185:
186: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 183: raise FND_API.G_EXC_UNEXPECTED_ERROR;

179:
180: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
181: raise FND_API.G_EXC_ERROR;
182: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
183: raise FND_API.G_EXC_UNEXPECTED_ERROR;
184: END IF;
185:
186: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
187: 'Pub: ' || l_api_name || ' Sales lead id '

Line 223: p_init_msg_list => FND_API.G_FALSE,

219: END IF;
220:
221: AS_INTEREST_PUB.Create_Interest(
222: p_api_version_number => 2.0 ,
223: p_init_msg_list => FND_API.G_FALSE,
224: p_Commit => FND_API.G_FALSE,
225: p_interest_rec => l_classification_tbl(i),
226: p_customer_id => p_sales_lead_rec.customer_id,
227: p_address_id => p_sales_lead_rec.address_id,

Line 224: p_Commit => FND_API.G_FALSE,

220:
221: AS_INTEREST_PUB.Create_Interest(
222: p_api_version_number => 2.0 ,
223: p_init_msg_list => FND_API.G_FALSE,
224: p_Commit => FND_API.G_FALSE,
225: p_interest_rec => l_classification_tbl(i),
226: p_customer_id => p_sales_lead_rec.customer_id,
227: p_address_id => p_sales_lead_rec.address_id,
228: p_contact_id => l_org_contact_id,

Line 243: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

239: p_interest_out_id => l_interest_out_id) ;
240: End Loop;
241:
242:
243: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
244: RAISE FND_API.G_EXC_ERROR;
245: END IF;
246:
247: --dbms_output.put_line('Interest created');

Line 244: RAISE FND_API.G_EXC_ERROR;

240: End Loop;
241:
242:
243: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
244: RAISE FND_API.G_EXC_ERROR;
245: END IF;
246:
247: --dbms_output.put_line('Interest created');
248: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 257: AND ((p_lead_note is not null) OR (p_lead_note <> FND_API.G_MISS_CHAR))

253:
254:
255: If ((l_sales_lead_id is not null)
256: AND (p_sales_lead_rec.customer_id is not null)
257: AND ((p_lead_note is not null) OR (p_lead_note <> FND_API.G_MISS_CHAR))
258: )
259: THEN
260: --Assign values to context rec type
261: l_note_context_rec.NOTE_CONTEXT_TYPE := 'LEAD';

Line 328: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

324: , p_jtf_note_contexts_tab => l_note_context_rec_tbl
325: );
326:
327: --dbms_output.put_line (x_return_status);
328: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
329: raise FND_API.G_EXC_ERROR;
330: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
331: raise FND_API.G_EXC_UNEXPECTED_ERROR;
332: END IF;

Line 329: raise FND_API.G_EXC_ERROR;

325: );
326:
327: --dbms_output.put_line (x_return_status);
328: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
329: raise FND_API.G_EXC_ERROR;
330: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
331: raise FND_API.G_EXC_UNEXPECTED_ERROR;
332: END IF;
333:

Line 330: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

326:
327: --dbms_output.put_line (x_return_status);
328: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
329: raise FND_API.G_EXC_ERROR;
330: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
331: raise FND_API.G_EXC_UNEXPECTED_ERROR;
332: END IF;
333:
334:

Line 331: raise FND_API.G_EXC_UNEXPECTED_ERROR;

327: --dbms_output.put_line (x_return_status);
328: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
329: raise FND_API.G_EXC_ERROR;
330: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
331: raise FND_API.G_EXC_UNEXPECTED_ERROR;
332: END IF;
333:
334:
335: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 346: P_Init_Msg_List => FND_API.G_FALSE,

342:
343: -- Process Lead after creation
344: AS_SALES_LEAD_ENGINE_PVT.Lead_Process_After_Create(
345: P_Api_Version_Number => 2.0,
346: P_Init_Msg_List => FND_API.G_FALSE,
347: P_Commit => FND_API.G_FALSE,
348: P_Validation_Level => P_Validation_Level,
349: P_Check_Access_Flag => P_Check_Access_Flag,
350: p_Admin_Flag => p_Admin_Flag,

Line 347: P_Commit => FND_API.G_FALSE,

343: -- Process Lead after creation
344: AS_SALES_LEAD_ENGINE_PVT.Lead_Process_After_Create(
345: P_Api_Version_Number => 2.0,
346: P_Init_Msg_List => FND_API.G_FALSE,
347: P_Commit => FND_API.G_FALSE,
348: P_Validation_Level => P_Validation_Level,
349: P_Check_Access_Flag => P_Check_Access_Flag,
350: p_Admin_Flag => p_Admin_Flag,
351: P_Admin_Group_Id => P_Admin_Group_Id,

Line 360: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

356: X_Msg_Count => x_msg_count,
357: X_Msg_Data => x_msg_data);
358:
359:
360: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
361: raise FND_API.G_EXC_ERROR;
362: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
363: raise FND_API.G_EXC_UNEXPECTED_ERROR;
364: END IF;

Line 361: raise FND_API.G_EXC_ERROR;

357: X_Msg_Data => x_msg_data);
358:
359:
360: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
361: raise FND_API.G_EXC_ERROR;
362: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
363: raise FND_API.G_EXC_UNEXPECTED_ERROR;
364: END IF;
365:

Line 362: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

358:
359:
360: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
361: raise FND_API.G_EXC_ERROR;
362: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
363: raise FND_API.G_EXC_UNEXPECTED_ERROR;
364: END IF;
365:
366: --dbms_output.put_line('lead processed.');

Line 363: raise FND_API.G_EXC_UNEXPECTED_ERROR;

359:
360: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
361: raise FND_API.G_EXC_ERROR;
362: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
363: raise FND_API.G_EXC_UNEXPECTED_ERROR;
364: END IF;
365:
366: --dbms_output.put_line('lead processed.');
367: x_sales_lead_id := l_sales_lead_id;

Line 375: IF FND_API.to_Boolean( p_commit )

371: --
372: -- End of API body
373: --
374:
375: IF FND_API.to_Boolean( p_commit )
376: THEN
377: COMMIT WORK;
378: END IF;
379:

Line 395: WHEN FND_API.G_EXC_ERROR THEN

391: dbms_output.put_line(fnd_message.get);
392: END LOOP;
393: */
394:
395: WHEN FND_API.G_EXC_ERROR THEN
396: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
397: P_API_NAME => L_API_NAME
398: ,P_PKG_NAME => G_PKG_NAME
399: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 404: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

400: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
401: ,X_MSG_COUNT => X_MSG_COUNT
402: ,X_MSG_DATA => X_MSG_DATA
403: ,X_RETURN_STATUS => X_RETURN_STATUS);
404: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
405: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
406: P_API_NAME => L_API_NAME
407: ,P_PKG_NAME => G_PKG_NAME
408: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR