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_SALES_ORG_MANAGER_PVT dependencies on FND_API

Line 42: If (p_sales_group_rec.sales_group_id <> FND_API.G_MISS_NUM) Then

38: l_where_cl Varchar2(1000);
39:
40: Begin
41:
42: If (p_sales_group_rec.sales_group_id <> FND_API.G_MISS_NUM) Then
43: l_where_cl := l_where_cl || 'And sales_group_id = :p_sales_group_id ';
44: End if;
45:
46: If (p_sales_group_rec.name <> FND_API.G_MISS_CHAR) Then

Line 46: If (p_sales_group_rec.name <> FND_API.G_MISS_CHAR) Then

42: If (p_sales_group_rec.sales_group_id <> FND_API.G_MISS_NUM) Then
43: l_where_cl := l_where_cl || 'And sales_group_id = :p_sales_group_id ';
44: End if;
45:
46: If (p_sales_group_rec.name <> FND_API.G_MISS_CHAR) Then
47: l_where_cl := l_where_cl || 'And name like :p_name ';
48: End if;
49:
50: If (p_sales_group_rec.parent_sales_group_id <> FND_API.G_MISS_NUM) Then

Line 50: If (p_sales_group_rec.parent_sales_group_id <> FND_API.G_MISS_NUM) Then

46: If (p_sales_group_rec.name <> FND_API.G_MISS_CHAR) Then
47: l_where_cl := l_where_cl || 'And name like :p_name ';
48: End if;
49:
50: If (p_sales_group_rec.parent_sales_group_id <> FND_API.G_MISS_NUM) Then
51: l_where_cl := l_where_cl || 'And parent_sales_group_id = :p_parent_sales_group_id ';
52: End if;
53:
54: If (p_sales_group_rec.manager_person_id <> FND_API.G_MISS_NUM) Then

Line 54: If (p_sales_group_rec.manager_person_id <> FND_API.G_MISS_NUM) Then

50: If (p_sales_group_rec.parent_sales_group_id <> FND_API.G_MISS_NUM) Then
51: l_where_cl := l_where_cl || 'And parent_sales_group_id = :p_parent_sales_group_id ';
52: End if;
53:
54: If (p_sales_group_rec.manager_person_id <> FND_API.G_MISS_NUM) Then
55: l_where_cl := l_where_cl || 'And manager_person_id = :p_manager_person_id ';
56: End if;
57:
58: If (p_sales_group_rec.manager_salesforce_id <> FND_API.G_MISS_NUM) Then

Line 58: If (p_sales_group_rec.manager_salesforce_id <> FND_API.G_MISS_NUM) Then

54: If (p_sales_group_rec.manager_person_id <> FND_API.G_MISS_NUM) Then
55: l_where_cl := l_where_cl || 'And manager_person_id = :p_manager_person_id ';
56: End if;
57:
58: If (p_sales_group_rec.manager_salesforce_id <> FND_API.G_MISS_NUM) Then
59: l_where_cl := l_where_cl || 'And manager_salesforce_id = :p_manager_salesforce_id ';
60: End if;
61:
62: return l_where_cl;

Line 88: If (p_sales_group_rec.sales_group_id <> FND_API.G_MISS_NUM) Then

84: Procedure get_sales_group_bind_variables(p_cur_get_salesgroup IN Number,
85: p_sales_group_rec IN AS_SALES_GROUP_PUB.Sales_Group_Rec_Type) IS
86:
87: Begin
88: If (p_sales_group_rec.sales_group_id <> FND_API.G_MISS_NUM) Then
89: dbms_sql.bind_variable(p_cur_get_salesgroup, 'p_sales_group_id',
90: p_sales_group_rec.sales_group_id);
91: End if;
92:

Line 93: If (p_sales_group_rec.name <> FND_API.G_MISS_CHAR) Then

89: dbms_sql.bind_variable(p_cur_get_salesgroup, 'p_sales_group_id',
90: p_sales_group_rec.sales_group_id);
91: End if;
92:
93: If (p_sales_group_rec.name <> FND_API.G_MISS_CHAR) Then
94: dbms_sql.bind_variable(p_cur_get_salesgroup, 'p_name',
95: p_sales_group_rec.name);
96: End if;
97:

Line 98: If (p_sales_group_rec.parent_sales_group_id <> FND_API.G_MISS_NUM) Then

94: dbms_sql.bind_variable(p_cur_get_salesgroup, 'p_name',
95: p_sales_group_rec.name);
96: End if;
97:
98: If (p_sales_group_rec.parent_sales_group_id <> FND_API.G_MISS_NUM) Then
99: dbms_sql.bind_variable(p_cur_get_salesgroup, 'p_parent_sales_group_id',
100: p_sales_group_rec.parent_sales_group_id);
101: End if;
102:

Line 103: If (p_sales_group_rec.manager_person_id <> FND_API.G_MISS_NUM) Then

99: dbms_sql.bind_variable(p_cur_get_salesgroup, 'p_parent_sales_group_id',
100: p_sales_group_rec.parent_sales_group_id);
101: End if;
102:
103: If (p_sales_group_rec.manager_person_id <> FND_API.G_MISS_NUM) Then
104: dbms_sql.bind_variable(p_cur_get_salesgroup, 'p_manager_person_id',
105: p_sales_group_rec.manager_person_id);
106: End if;
107:

Line 108: If (p_sales_group_rec.manager_salesforce_id <> FND_API.G_MISS_NUM) Then

104: dbms_sql.bind_variable(p_cur_get_salesgroup, 'p_manager_person_id',
105: p_sales_group_rec.manager_person_id);
106: End if;
107:
108: If (p_sales_group_rec.manager_salesforce_id <> FND_API.G_MISS_NUM) Then
109: dbms_sql.bind_variable(p_cur_get_salesgroup, 'p_manager_salesforce_id',
110: p_sales_group_rec.manager_salesforce_id);
111: End if;
112: End get_sales_group_bind_variables;

Line 180: If (p_sales_member_rec.user_id <> FND_API.G_MISS_NUM) Then

176: -- l_where_cl := 'From per_jobs job, per_assignments_f assign, PER_PEOPLE_F people, ' ||
177: l_where_cl := 'From PER_PEOPLE_F people, ' ||
178: 'as_sales_groups_v sales_group, AS_SALESFORCE_V force, as_sales_groups_v manage_group ';
179:
180: If (p_sales_member_rec.user_id <> FND_API.G_MISS_NUM) Then
181: l_where_cl := l_where_cl || ', FND_USER fnd_user ' ||
182: 'where fnd_user.employee_id = force.employee_person_id and ' ||
183: 'fnd_user.user_id = :p_user_id ';
184: Else

Line 196: If (p_sales_member_rec.salesforce_id <> FND_API.G_MISS_NUM) Then

192: -- ' and assign.assignment_type = ''E'' and assign.primary_flag = ''Y'' ' ||
193: ' and force.employee_person_id = manage_group.manager_person_id(+)' ||
194: ' and trunc(sysdate) >= nvl(people.effective_start_date,trunc(sysdate)) '||
195: ' and trunc(sysdate) <= nvl(people.effective_end_date,trunc(sysdate))';
196: If (p_sales_member_rec.salesforce_id <> FND_API.G_MISS_NUM) Then
197: l_where_cl := l_where_cl || 'And force.salesforce_id like :p_salesforce_id ';
198: End if;
199:
200: If (p_sales_member_rec.Employee_Person_Id <> FND_API.G_MISS_NUM) Then

Line 200: If (p_sales_member_rec.Employee_Person_Id <> FND_API.G_MISS_NUM) Then

196: If (p_sales_member_rec.salesforce_id <> FND_API.G_MISS_NUM) Then
197: l_where_cl := l_where_cl || 'And force.salesforce_id like :p_salesforce_id ';
198: End if;
199:
200: If (p_sales_member_rec.Employee_Person_Id <> FND_API.G_MISS_NUM) Then
201: l_where_cl := l_where_cl || 'And force.Employee_Person_Id = :p_Employee_Person_Id ';
202: End if;
203:
204: If (p_sales_member_rec.sales_group_id <> FND_API.G_MISS_NUM) Then

Line 204: If (p_sales_member_rec.sales_group_id <> FND_API.G_MISS_NUM) Then

200: If (p_sales_member_rec.Employee_Person_Id <> FND_API.G_MISS_NUM) Then
201: l_where_cl := l_where_cl || 'And force.Employee_Person_Id = :p_Employee_Person_Id ';
202: End if;
203:
204: If (p_sales_member_rec.sales_group_id <> FND_API.G_MISS_NUM) Then
205: l_where_cl := l_where_cl || 'And force.sales_group_id = :p_sales_group_id ';
206: End if;
207:
208: If (p_sales_member_rec.Partner_Address_Id <> FND_API.G_MISS_NUM) Then

Line 208: If (p_sales_member_rec.Partner_Address_Id <> FND_API.G_MISS_NUM) Then

204: If (p_sales_member_rec.sales_group_id <> FND_API.G_MISS_NUM) Then
205: l_where_cl := l_where_cl || 'And force.sales_group_id = :p_sales_group_id ';
206: End if;
207:
208: If (p_sales_member_rec.Partner_Address_Id <> FND_API.G_MISS_NUM) Then
209: l_where_cl := l_where_cl || 'And force.Partner_Address_Id = :p_Partner_Address_Id ';
210: End if;
211:
212: If (p_sales_member_rec.Partner_Customer_Id <> FND_API.G_MISS_NUM) Then

Line 212: If (p_sales_member_rec.Partner_Customer_Id <> FND_API.G_MISS_NUM) Then

208: If (p_sales_member_rec.Partner_Address_Id <> FND_API.G_MISS_NUM) Then
209: l_where_cl := l_where_cl || 'And force.Partner_Address_Id = :p_Partner_Address_Id ';
210: End if;
211:
212: If (p_sales_member_rec.Partner_Customer_Id <> FND_API.G_MISS_NUM) Then
213: l_where_cl := l_where_cl || 'And force.Partner_Customer_Id = :p_Partner_Customer_Id ';
214: End if;
215:
216: If (p_sales_member_rec.Last_name <> FND_API.G_MISS_CHAR) Then

Line 216: If (p_sales_member_rec.Last_name <> FND_API.G_MISS_CHAR) Then

212: If (p_sales_member_rec.Partner_Customer_Id <> FND_API.G_MISS_NUM) Then
213: l_where_cl := l_where_cl || 'And force.Partner_Customer_Id = :p_Partner_Customer_Id ';
214: End if;
215:
216: If (p_sales_member_rec.Last_name <> FND_API.G_MISS_CHAR) Then
217: l_where_cl := l_where_cl || 'And people.Last_name like :p_Last_name ';
218: End if;
219:
220: If (p_sales_member_rec.first_name <> FND_API.G_MISS_CHAR) Then

Line 220: If (p_sales_member_rec.first_name <> FND_API.G_MISS_CHAR) Then

216: If (p_sales_member_rec.Last_name <> FND_API.G_MISS_CHAR) Then
217: l_where_cl := l_where_cl || 'And people.Last_name like :p_Last_name ';
218: End if;
219:
220: If (p_sales_member_rec.first_name <> FND_API.G_MISS_CHAR) Then
221: l_where_cl := l_where_cl || 'And people.first_name like :p_first_name ';
222: End if;
223:
224: If (p_sales_member_rec.Email_address <> FND_API.G_MISS_CHAR) Then

Line 224: If (p_sales_member_rec.Email_address <> FND_API.G_MISS_CHAR) Then

220: If (p_sales_member_rec.first_name <> FND_API.G_MISS_CHAR) Then
221: l_where_cl := l_where_cl || 'And people.first_name like :p_first_name ';
222: End if;
223:
224: If (p_sales_member_rec.Email_address <> FND_API.G_MISS_CHAR) Then
225: l_where_cl := l_where_cl || 'And people.Email_address like :p_Email_address ';
226: End if;
227:
228: If (p_sales_member_rec.type <> FND_API.G_MISS_CHAR) Then

Line 228: If (p_sales_member_rec.type <> FND_API.G_MISS_CHAR) Then

224: If (p_sales_member_rec.Email_address <> FND_API.G_MISS_CHAR) Then
225: l_where_cl := l_where_cl || 'And people.Email_address like :p_Email_address ';
226: End if;
227:
228: If (p_sales_member_rec.type <> FND_API.G_MISS_CHAR) Then
229: l_where_cl := l_where_cl || 'And force.type = :p_type ';
230: End if;
231:
232: return l_where_cl;

Line 246: If (p_sales_member_rec.user_id <> FND_API.G_MISS_NUM) Then

242:
243: l_where_cl := 'From PER_PEOPLE_F people, ' ||
244: 'as_sales_groups_v sales_group, AS_FC_SALESFORCE_V force, as_sales_groups_v manage_group ';
245:
246: If (p_sales_member_rec.user_id <> FND_API.G_MISS_NUM) Then
247: l_where_cl := l_where_cl || ', FND_USER fnd_user ' ||
248: 'where fnd_user.employee_id = force.employee_person_id and ' ||
249: 'fnd_user.user_id = :p_user_id ';
250: Else

Line 258: If (p_sales_member_rec.salesforce_id <> FND_API.G_MISS_NUM) Then

254: ' and sales_group.sales_group_id (+) = force.sales_group_id ' ||
255: ' and force.employee_person_id = manage_group.manager_person_id(+)' ||
256: ' and trunc(sysdate) >= nvl(people.effective_start_date,trunc(sysdate)) '||
257: ' and trunc(sysdate) <= nvl(people.effective_end_date,trunc(sysdate))';
258: If (p_sales_member_rec.salesforce_id <> FND_API.G_MISS_NUM) Then
259: l_where_cl := l_where_cl || 'And force.salesforce_id like :p_salesforce_id ';
260: End if;
261:
262: If (p_sales_member_rec.Employee_Person_Id <> FND_API.G_MISS_NUM) Then

Line 262: If (p_sales_member_rec.Employee_Person_Id <> FND_API.G_MISS_NUM) Then

258: If (p_sales_member_rec.salesforce_id <> FND_API.G_MISS_NUM) Then
259: l_where_cl := l_where_cl || 'And force.salesforce_id like :p_salesforce_id ';
260: End if;
261:
262: If (p_sales_member_rec.Employee_Person_Id <> FND_API.G_MISS_NUM) Then
263: l_where_cl := l_where_cl || 'And force.Employee_Person_Id = :p_Employee_Person_Id ';
264: End if;
265:
266: If (p_sales_member_rec.sales_group_id <> FND_API.G_MISS_NUM) Then

Line 266: If (p_sales_member_rec.sales_group_id <> FND_API.G_MISS_NUM) Then

262: If (p_sales_member_rec.Employee_Person_Id <> FND_API.G_MISS_NUM) Then
263: l_where_cl := l_where_cl || 'And force.Employee_Person_Id = :p_Employee_Person_Id ';
264: End if;
265:
266: If (p_sales_member_rec.sales_group_id <> FND_API.G_MISS_NUM) Then
267: l_where_cl := l_where_cl || 'And force.sales_group_id = :p_sales_group_id ';
268: End if;
269:
270: If (p_sales_member_rec.Partner_Address_Id <> FND_API.G_MISS_NUM) Then

Line 270: If (p_sales_member_rec.Partner_Address_Id <> FND_API.G_MISS_NUM) Then

266: If (p_sales_member_rec.sales_group_id <> FND_API.G_MISS_NUM) Then
267: l_where_cl := l_where_cl || 'And force.sales_group_id = :p_sales_group_id ';
268: End if;
269:
270: If (p_sales_member_rec.Partner_Address_Id <> FND_API.G_MISS_NUM) Then
271: l_where_cl := l_where_cl || 'And force.Partner_Address_Id = :p_Partner_Address_Id ';
272: End if;
273:
274: If (p_sales_member_rec.Partner_Customer_Id <> FND_API.G_MISS_NUM) Then

Line 274: If (p_sales_member_rec.Partner_Customer_Id <> FND_API.G_MISS_NUM) Then

270: If (p_sales_member_rec.Partner_Address_Id <> FND_API.G_MISS_NUM) Then
271: l_where_cl := l_where_cl || 'And force.Partner_Address_Id = :p_Partner_Address_Id ';
272: End if;
273:
274: If (p_sales_member_rec.Partner_Customer_Id <> FND_API.G_MISS_NUM) Then
275: l_where_cl := l_where_cl || 'And force.Partner_Customer_Id = :p_Partner_Customer_Id ';
276: End if;
277:
278: If (p_sales_member_rec.Last_name <> FND_API.G_MISS_CHAR) Then

Line 278: If (p_sales_member_rec.Last_name <> FND_API.G_MISS_CHAR) Then

274: If (p_sales_member_rec.Partner_Customer_Id <> FND_API.G_MISS_NUM) Then
275: l_where_cl := l_where_cl || 'And force.Partner_Customer_Id = :p_Partner_Customer_Id ';
276: End if;
277:
278: If (p_sales_member_rec.Last_name <> FND_API.G_MISS_CHAR) Then
279: l_where_cl := l_where_cl || 'And people.Last_name like :p_Last_name ';
280: End if;
281:
282: If (p_sales_member_rec.first_name <> FND_API.G_MISS_CHAR) Then

Line 282: If (p_sales_member_rec.first_name <> FND_API.G_MISS_CHAR) Then

278: If (p_sales_member_rec.Last_name <> FND_API.G_MISS_CHAR) Then
279: l_where_cl := l_where_cl || 'And people.Last_name like :p_Last_name ';
280: End if;
281:
282: If (p_sales_member_rec.first_name <> FND_API.G_MISS_CHAR) Then
283: l_where_cl := l_where_cl || 'And people.first_name like :p_first_name ';
284: End if;
285:
286: If (p_sales_member_rec.Email_address <> FND_API.G_MISS_CHAR) Then

Line 286: If (p_sales_member_rec.Email_address <> FND_API.G_MISS_CHAR) Then

282: If (p_sales_member_rec.first_name <> FND_API.G_MISS_CHAR) Then
283: l_where_cl := l_where_cl || 'And people.first_name like :p_first_name ';
284: End if;
285:
286: If (p_sales_member_rec.Email_address <> FND_API.G_MISS_CHAR) Then
287: l_where_cl := l_where_cl || 'And people.Email_address like :p_Email_address ';
288: End if;
289:
290: If (p_sales_member_rec.type <> FND_API.G_MISS_CHAR) Then

Line 290: If (p_sales_member_rec.type <> FND_API.G_MISS_CHAR) Then

286: If (p_sales_member_rec.Email_address <> FND_API.G_MISS_CHAR) Then
287: l_where_cl := l_where_cl || 'And people.Email_address like :p_Email_address ';
288: End if;
289:
290: If (p_sales_member_rec.type <> FND_API.G_MISS_CHAR) Then
291: l_where_cl := l_where_cl || 'And force.type = :p_type ';
292: End if;
293:
294: return l_where_cl;

Line 327: If (p_sales_member_rec.user_id <> FND_API.G_MISS_NUM) Then

323: Procedure get_salesmem_bind_vars(p_cur_get_salesmember IN Number,
324: p_sales_member_rec IN AS_sales_member_PUB.sales_member_Rec_Type) IS
325:
326: Begin
327: If (p_sales_member_rec.user_id <> FND_API.G_MISS_NUM) Then
328: dbms_sql.bind_variable(p_cur_get_salesmember, 'p_user_id',
329: p_sales_member_rec.user_id);
330: End if;
331:

Line 332: If (p_sales_member_rec.salesforce_id <> FND_API.G_MISS_NUM) Then

328: dbms_sql.bind_variable(p_cur_get_salesmember, 'p_user_id',
329: p_sales_member_rec.user_id);
330: End if;
331:
332: If (p_sales_member_rec.salesforce_id <> FND_API.G_MISS_NUM) Then
333: dbms_sql.bind_variable(p_cur_get_salesmember, 'p_salesforce_id',
334: p_sales_member_rec.salesforce_id);
335: End if;
336:

Line 337: If (p_sales_member_rec.employee_person_id <> FND_API.G_MISS_NUM) Then

333: dbms_sql.bind_variable(p_cur_get_salesmember, 'p_salesforce_id',
334: p_sales_member_rec.salesforce_id);
335: End if;
336:
337: If (p_sales_member_rec.employee_person_id <> FND_API.G_MISS_NUM) Then
338: dbms_sql.bind_variable(p_cur_get_salesmember, 'p_employee_person_id',
339: p_sales_member_rec.employee_person_id);
340: End if;
341:

Line 342: If (p_sales_member_rec.sales_group_id <> FND_API.G_MISS_NUM) Then

338: dbms_sql.bind_variable(p_cur_get_salesmember, 'p_employee_person_id',
339: p_sales_member_rec.employee_person_id);
340: End if;
341:
342: If (p_sales_member_rec.sales_group_id <> FND_API.G_MISS_NUM) Then
343: dbms_sql.bind_variable(p_cur_get_salesmember, 'p_sales_group_id',
344: p_sales_member_rec.sales_group_id);
345: End if;
346:

Line 348: If (p_sales_member_rec.partner_address_id <> FND_API.G_MISS_NUM) Then

344: p_sales_member_rec.sales_group_id);
345: End if;
346:
347:
348: If (p_sales_member_rec.partner_address_id <> FND_API.G_MISS_NUM) Then
349: dbms_sql.bind_variable(p_cur_get_salesmember, 'p_partner_address_id',
350: p_sales_member_rec.partner_address_id);
351: End if;
352:

Line 353: If (p_sales_member_rec.partner_customer_id <> FND_API.G_MISS_NUM) Then

349: dbms_sql.bind_variable(p_cur_get_salesmember, 'p_partner_address_id',
350: p_sales_member_rec.partner_address_id);
351: End if;
352:
353: If (p_sales_member_rec.partner_customer_id <> FND_API.G_MISS_NUM) Then
354: dbms_sql.bind_variable(p_cur_get_salesmember, 'p_partner_customer_id',
355: p_sales_member_rec.partner_customer_id);
356: End if;
357:

Line 358: If (p_sales_member_rec.last_name <> FND_API.G_MISS_CHAR) Then

354: dbms_sql.bind_variable(p_cur_get_salesmember, 'p_partner_customer_id',
355: p_sales_member_rec.partner_customer_id);
356: End if;
357:
358: If (p_sales_member_rec.last_name <> FND_API.G_MISS_CHAR) Then
359: dbms_sql.bind_variable(p_cur_get_salesmember, 'p_last_name',
360: p_sales_member_rec.last_name);
361: End if;
362:

Line 363: If (p_sales_member_rec.first_name <> FND_API.G_MISS_CHAR) Then

359: dbms_sql.bind_variable(p_cur_get_salesmember, 'p_last_name',
360: p_sales_member_rec.last_name);
361: End if;
362:
363: If (p_sales_member_rec.first_name <> FND_API.G_MISS_CHAR) Then
364: dbms_sql.bind_variable(p_cur_get_salesmember, 'p_first_name',
365: p_sales_member_rec.first_name);
366: End if;
367:

Line 368: If (p_sales_member_rec.email_address <> FND_API.G_MISS_CHAR) Then

364: dbms_sql.bind_variable(p_cur_get_salesmember, 'p_first_name',
365: p_sales_member_rec.first_name);
366: End if;
367:
368: If (p_sales_member_rec.email_address <> FND_API.G_MISS_CHAR) Then
369: dbms_sql.bind_variable(p_cur_get_salesmember, 'p_email_address',
370: p_sales_member_rec.email_address);
371: End if;
372:

Line 373: If (p_sales_member_rec.type <> FND_API.G_MISS_CHAR) Then

369: dbms_sql.bind_variable(p_cur_get_salesmember, 'p_email_address',
370: p_sales_member_rec.email_address);
371: End if;
372:
373: If (p_sales_member_rec.type <> FND_API.G_MISS_CHAR) Then
374: dbms_sql.bind_variable(p_cur_get_salesmember, 'p_type',
375: p_sales_member_rec.type);
376: End if;
377:

Line 424: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

420: --
421: --
422: PROCEDURE Get_Sales_groups
423: ( p_api_version_number IN NUMBER,
424: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
425: p_SALES_GROUP_rec IN AS_SALES_GROUP_PUB.SALES_GROUP_rec_Type,
426: x_return_status OUT NOCOPY VARCHAR2,
427: x_msg_count OUT NOCOPY NUMBER,
428: x_msg_data OUT NOCOPY VARCHAR2,

Line 449: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

445: BEGIN
446:
447:
448: -- Standard call to check for call compatibility.
449: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
450: p_api_version_number,
451: l_api_name,
452: G_PKG_NAME)
453: THEN

Line 454: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

450: p_api_version_number,
451: l_api_name,
452: G_PKG_NAME)
453: THEN
454: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
455: END IF;
456:
457:
458: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 459: IF FND_API.to_Boolean( p_init_msg_list ) THEN

455: END IF;
456:
457:
458: -- Initialize message list if p_init_msg_list is set to TRUE.
459: IF FND_API.to_Boolean( p_init_msg_list ) THEN
460: FND_MSG_PUB.initialize;
461: END IF;
462:
463: -- Debug Message

Line 472: x_return_status := FND_API.G_RET_STS_SUCCESS;

468: END IF;
469: END IF;
470:
471: -- Initialize API return status to success
472: x_return_status := FND_API.G_RET_STS_SUCCESS;
473:
474: --
475: -- API body
476:

Line 574: x_return_status := FND_API.G_RET_STS_SUCCESS ;

570: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AS_SALES_ORG_MANAGER_PVT: Cannot find sales group');
571: END IF;
572: END IF;
573:
574: x_return_status := FND_API.G_RET_STS_SUCCESS ;
575:
576: FND_MSG_PUB.Count_And_Get
577: ( p_count => x_msg_count,
578: p_data => x_msg_data

Line 586: x_return_status := FND_API.G_RET_STS_SUCCESS;

582:
583: -- End of API body.
584: --
585:
586: x_return_status := FND_API.G_RET_STS_SUCCESS;
587:
588: -- Debug Message
589: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
590: THEN

Line 607: WHEN FND_API.G_EXC_ERROR THEN

603:
604:
605: EXCEPTION
606:
607: WHEN FND_API.G_EXC_ERROR THEN
608: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
609: P_MODULE => l_module
610: ,P_API_NAME => L_API_NAME
611: ,P_PKG_NAME => G_PKG_NAME

Line 619: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

615: ,X_MSG_COUNT => X_MSG_COUNT
616: ,X_MSG_DATA => X_MSG_DATA
617: ,X_RETURN_STATUS => X_RETURN_STATUS);
618:
619: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
620: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
621: P_MODULE => l_module
622: ,P_API_NAME => L_API_NAME
623: ,P_PKG_NAME => G_PKG_NAME

Line 664: := FND_API.G_FALSE,

660: --
661: PROCEDURE Get_CurrentUser
662: ( p_api_version_number IN NUMBER,
663: p_init_msg_list IN VARCHAR2
664: := FND_API.G_FALSE,
665: p_salesforce_id IN NUMBER,
666: p_admin_group_id IN NUMBER,
667: x_return_status OUT NOCOPY VARCHAR2,
668: x_msg_count OUT NOCOPY NUMBER,

Line 725: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

721:
722: BEGIN
723:
724: -- Standard call to check for call compatibility.
725: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
726: p_api_version_number,
727: l_api_name,
728: G_PKG_NAME)
729: THEN

Line 730: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

726: p_api_version_number,
727: l_api_name,
728: G_PKG_NAME)
729: THEN
730: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
731: END IF;
732:
733:
734: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 735: IF FND_API.to_Boolean( p_init_msg_list ) THEN

731: END IF;
732:
733:
734: -- Initialize message list if p_init_msg_list is set to TRUE.
735: IF FND_API.to_Boolean( p_init_msg_list ) THEN
736: FND_MSG_PUB.initialize;
737: END IF;
738:
739: -- Debug Message

Line 748: x_return_status := FND_API.G_RET_STS_SUCCESS;

744: END IF;
745: END IF;
746:
747: -- Initialize API return status to success
748: x_return_status := FND_API.G_RET_STS_SUCCESS;
749:
750: --
751: -- API body
752:

Line 774: -- RAISE FND_API.G_EXC_ERROR;

770: x_sales_member_rec.partner_address_id,
771: x_sales_member_rec.partner_customer_id,
772: x_sales_member_rec.partner_contact_id;
773: Close C_GetIdentity_SFID;
774: -- RAISE FND_API.G_EXC_ERROR;
775: Else
776: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
777: IF l_debug THEN
778: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AS_SALES_MEMBER_PVT - Using FndUser to find identity');

Line 806: If (x_sales_member_rec.salesforce_id is null OR x_sales_member_rec.salesforce_id = FND_API.G_MISS_NUM) Then

802: x_sales_member_rec.partner_contact_id;
803: Close C_GetIdentity_FndUser;
804:
805: -- raise error if salesforce_id is null
806: If (x_sales_member_rec.salesforce_id is null OR x_sales_member_rec.salesforce_id = FND_API.G_MISS_NUM) Then
807: FND_MESSAGE.Set_Name('AS', 'AS_INVALID_USER_ID');
808: FND_MESSAGE.Set_Token('VALUE', FND_GLOBAL.USER_ID, FALSE);
809: FND_MSG_PUB.ADD;
810: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

Line 815: x_return_status := FND_API.G_RET_STS_ERROR ;

811: IF l_debug THEN
812: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AS_SALES_MEMBER_PVT - Cannot identify user by checking user_id at JTF resource');
813: END IF;
814: END IF;
815: x_return_status := FND_API.G_RET_STS_ERROR ;
816: FND_MSG_PUB.Count_And_Get
817: ( p_count => x_msg_count,
818: p_data => x_msg_data
819: );

Line 827: IF (p_admin_group_id IS NOT NULL and p_admin_group_id <> FND_API.G_MISS_NUM) THEN

823: END IF;
824:
825: check_salesforce_id := x_sales_member_rec.salesforce_id;
826:
827: IF (p_admin_group_id IS NOT NULL and p_admin_group_id <> FND_API.G_MISS_NUM) THEN
828: open C_GetAdminGroup(check_salesforce_id, p_admin_group_id);
829: fetch C_GetAdminGroup into l_found;
830: IF(C_GetAdminGroup%NOTFOUND) THEN
831: close C_GetAdminGroup;

Line 832: RAISE FND_API.G_EXC_ERROR;

828: open C_GetAdminGroup(check_salesforce_id, p_admin_group_id);
829: fetch C_GetAdminGroup into l_found;
830: IF(C_GetAdminGroup%NOTFOUND) THEN
831: close C_GetAdminGroup;
832: RAISE FND_API.G_EXC_ERROR;
833: END IF;
834: close C_GetAdminGroup;
835: END IF;
836:

Line 852: x_return_status := FND_API.G_RET_STS_ERROR ;

848: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AS_SALES_MEMBER_PVT: Cannot identify user');
849: END IF;
850: END IF;
851:
852: x_return_status := FND_API.G_RET_STS_ERROR ;
853:
854: FND_MSG_PUB.Count_And_Get
855: ( p_count => x_msg_count,
856: p_data => x_msg_data

Line 865: x_return_status := FND_API.G_RET_STS_SUCCESS;

861:
862: -- End of API body.
863: --
864:
865: x_return_status := FND_API.G_RET_STS_SUCCESS;
866:
867: -- Debug Message
868: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
869: THEN

Line 886: WHEN FND_API.G_EXC_ERROR THEN

882:
883:
884: EXCEPTION
885:
886: WHEN FND_API.G_EXC_ERROR THEN
887: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
888: P_MODULE => l_module
889: ,P_API_NAME => L_API_NAME
890: ,P_PKG_NAME => G_PKG_NAME

Line 898: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

894: ,X_MSG_COUNT => X_MSG_COUNT
895: ,X_MSG_DATA => X_MSG_DATA
896: ,X_RETURN_STATUS => X_RETURN_STATUS);
897:
898: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
899: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
900: P_MODULE => l_module
901: ,P_API_NAME => L_API_NAME
902: ,P_PKG_NAME => G_PKG_NAME

Line 940: := FND_API.G_FALSE,

936: --
937: PROCEDURE Get_Sales_members
938: ( p_api_version_number IN NUMBER,
939: p_init_msg_list IN VARCHAR2
940: := FND_API.G_FALSE,
941: p_sales_member_rec IN AS_SALES_MEMBER_PUB.Sales_member_rec_Type,
942: x_return_status OUT NOCOPY VARCHAR2,
943: x_msg_count OUT NOCOPY NUMBER,
944: x_msg_data OUT NOCOPY VARCHAR2,

Line 974: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

970: BEGIN
971:
972:
973: -- Standard call to check for call compatibility.
974: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
975: p_api_version_number,
976: l_api_name,
977: G_PKG_NAME)
978: THEN

Line 979: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

975: p_api_version_number,
976: l_api_name,
977: G_PKG_NAME)
978: THEN
979: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
980: END IF;
981:
982:
983: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 984: IF FND_API.to_Boolean( p_init_msg_list ) THEN

980: END IF;
981:
982:
983: -- Initialize message list if p_init_msg_list is set to TRUE.
984: IF FND_API.to_Boolean( p_init_msg_list ) THEN
985: FND_MSG_PUB.initialize;
986: END IF;
987:
988: -- Debug Message

Line 997: x_return_status := FND_API.G_RET_STS_SUCCESS;

993: END IF;
994: END IF;
995:
996: -- Initialize API return status to success
997: x_return_status := FND_API.G_RET_STS_SUCCESS;
998:
999: --
1000: -- API body
1001:

Line 1085: x_return_status := FND_API.G_RET_STS_ERROR;

1081: END IF;
1082:
1083:
1084: -- initializing return status as this is always come up as 'S'
1085: x_return_status := FND_API.G_RET_STS_ERROR;
1086: Loop
1087: If (dbms_sql.fetch_rows(l_cur_get_salesmember) > 0) Then
1088: get_salesmem_column_values(l_cur_get_salesmember, l_sales_member_rec);
1089: l_curr_row := l_curr_row + 1;

Line 1091: x_return_status := FND_API.G_RET_STS_SUCCESS;

1087: If (dbms_sql.fetch_rows(l_cur_get_salesmember) > 0) Then
1088: get_salesmem_column_values(l_cur_get_salesmember, l_sales_member_rec);
1089: l_curr_row := l_curr_row + 1;
1090: x_sales_member_tbl(l_curr_row) := l_sales_member_rec;
1091: x_return_status := FND_API.G_RET_STS_SUCCESS;
1092: Else
1093: Exit;
1094: End if;
1095: End Loop;

Line 1118: x_return_status := FND_API.G_RET_STS_ERROR;

1114: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'AS_SALES_MEMBER_PVT: Cannot find user');
1115: END IF;
1116: END IF;
1117:
1118: x_return_status := FND_API.G_RET_STS_ERROR;
1119:
1120: FND_MSG_PUB.Count_And_Get
1121: ( p_count => x_msg_count,
1122: p_data => x_msg_data

Line 1151: WHEN FND_API.G_EXC_ERROR THEN

1147:
1148:
1149: EXCEPTION
1150:
1151: WHEN FND_API.G_EXC_ERROR THEN
1152: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1153: P_MODULE => l_module
1154: ,P_API_NAME => L_API_NAME
1155: ,P_PKG_NAME => G_PKG_NAME

Line 1163: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1159: ,X_MSG_COUNT => X_MSG_COUNT
1160: ,X_MSG_DATA => X_MSG_DATA
1161: ,X_RETURN_STATUS => X_RETURN_STATUS);
1162:
1163: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1164: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1165: P_MODULE => l_module
1166: ,P_API_NAME => L_API_NAME
1167: ,P_PKG_NAME => G_PKG_NAME

Line 1201: -- DEFAULT FND_API.G_MISS_NUM

1197: -- Pre-reqs : None
1198: -- Paramaeters :
1199: -- p_identity_salesforce_id IN NUMBER Required
1200: -- p_salesrep_salesforce_id IN NUMBER Optional
1201: -- DEFAULT FND_API.G_MISS_NUM
1202: -- Version :
1203: --
1204: --
1205: -- Note :

Line 1207: -- 1. If p_salesrep_salesforce_id is NULL or FND_API.G_MISS_NUM, this function will

1203: --
1204: --
1205: -- Note :
1206: -- Cases:
1207: -- 1. If p_salesrep_salesforce_id is NULL or FND_API.G_MISS_NUM, this function will
1208: -- take p_identity_salesforce_id as a root and check all relations under it and
1209: -- determine if p_identity_salesforce_id is the firstline manager or not.
1210: -- 2. If p_salesrep_salesforce_id is not NULL, the function will only check the
1211: -- relation between them.

Line 1228: p_salesrep_salesforce_id IN NUMBER DEFAULT FND_API.G_MISS_NUM

1224: -- Manager A will be firstline manager.
1225: /*
1226: FUNCTION Get_Sales_Relations
1227: ( p_identity_salesforce_id IN NUMBER,
1228: p_salesrep_salesforce_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
1229: ) RETURN NUMBER IS
1230:
1231: CURSOR l_manager_sales_rel_csr (c_manager_id NUMBER, c_sales_id NUMBER) IS
1232: SELECT rm.reports_to_flag reports_to_flag

Line 1250: IF (p_salesrep_salesforce_id IS NULL OR p_salesrep_salesforce_id = FND_API.G_MISS_NUM) THEN

1246: l_sales_relations NUMBER;
1247: l_flag VARCHAR2(1);
1248: l_counter NUMBER := 0;
1249: BEGIN
1250: IF (p_salesrep_salesforce_id IS NULL OR p_salesrep_salesforce_id = FND_API.G_MISS_NUM) THEN
1251: l_sales_relations := G_SALESREP;
1252: FOR l_reports_to_flag IN l_sales_org_csr(p_identity_salesforce_id) LOOP
1253: l_counter := l_counter + 1;
1254: IF l_reports_to_flag.reports_to_flag = 'N' THEN