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

Line 46: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

42:
43: --
44: -- Standard call to check for call compatibility.
45: --
46: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
47: p_api_version ,
48: l_api_name ,
49: G_PKG_NAME )
50: THEN

Line 51: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

47: p_api_version ,
48: l_api_name ,
49: G_PKG_NAME )
50: THEN
51: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
52: END IF;
53:
54: --
55: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 57: IF FND_API.to_Boolean( p_init_msg_list ) THEN

53:
54: --
55: -- Initialize message list if p_init_msg_list is set to TRUE.
56: --
57: IF FND_API.to_Boolean( p_init_msg_list ) THEN
58: FND_MSG_PUB.initialize;
59: END IF;
60:
61: --

Line 64: x_return_status := FND_API.G_RET_STS_SUCCESS;

60:
61: --
62: -- Initialize API return status to success
63: --
64: x_return_status := FND_API.G_RET_STS_SUCCESS;
65: x_loading_status := 'CN_UPDATED';
66:
67: select customized_flag
68: ,target

Line 123: IF FND_API.To_Boolean( p_commit ) THEN

119: ,fnd_global.user_id --g_last_updated_by
120: ,fnd_global.login_id); -- g_last_update_login);
121:
122: -- Standard check of p_commit.
123: IF FND_API.To_Boolean( p_commit ) THEN
124: COMMIT WORK;
125: END IF;
126: --
127: -- Standard call to get message count and if count is 1, get message info.

Line 134: p_encoded => FND_API.G_FALSE

130: FND_MSG_PUB.Count_And_Get
131: (
132: p_count => x_msg_count ,
133: p_data => x_msg_data ,
134: p_encoded => FND_API.G_FALSE
135: );
136:
137: EXCEPTION
138: WHEN FND_API.G_EXC_ERROR THEN

Line 138: WHEN FND_API.G_EXC_ERROR THEN

134: p_encoded => FND_API.G_FALSE
135: );
136:
137: EXCEPTION
138: WHEN FND_API.G_EXC_ERROR THEN
139: ROLLBACK TO update_srp_quota_assign;
140: x_return_status := FND_API.G_RET_STS_ERROR ;
141: FND_MSG_PUB.Count_And_Get
142: (

Line 140: x_return_status := FND_API.G_RET_STS_ERROR ;

136:
137: EXCEPTION
138: WHEN FND_API.G_EXC_ERROR THEN
139: ROLLBACK TO update_srp_quota_assign;
140: x_return_status := FND_API.G_RET_STS_ERROR ;
141: FND_MSG_PUB.Count_And_Get
142: (
143: p_count => x_msg_count ,
144: p_data => x_msg_data ,

Line 145: p_encoded => FND_API.G_FALSE

141: FND_MSG_PUB.Count_And_Get
142: (
143: p_count => x_msg_count ,
144: p_data => x_msg_data ,
145: p_encoded => FND_API.G_FALSE
146: );
147: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
148: ROLLBACK TO update_srp_quota_assign;
149: x_loading_status := 'UNEXPECTED_ERR';

Line 147: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

143: p_count => x_msg_count ,
144: p_data => x_msg_data ,
145: p_encoded => FND_API.G_FALSE
146: );
147: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
148: ROLLBACK TO update_srp_quota_assign;
149: x_loading_status := 'UNEXPECTED_ERR';
150: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
151: FND_MSG_PUB.Count_And_Get

Line 150: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

146: );
147: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
148: ROLLBACK TO update_srp_quota_assign;
149: x_loading_status := 'UNEXPECTED_ERR';
150: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
151: FND_MSG_PUB.Count_And_Get
152: (
153: p_count => x_msg_count ,
154: p_data => x_msg_data ,

Line 155: p_encoded => FND_API.G_FALSE

151: FND_MSG_PUB.Count_And_Get
152: (
153: p_count => x_msg_count ,
154: p_data => x_msg_data ,
155: p_encoded => FND_API.G_FALSE
156: );
157: WHEN OTHERS THEN
158: ROLLBACK TO update_srp_quota_assign;
159: x_loading_status := 'UNEXPECTED_ERR';

Line 160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

156: );
157: WHEN OTHERS THEN
158: ROLLBACK TO update_srp_quota_assign;
159: x_loading_status := 'UNEXPECTED_ERR';
160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
161: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
162: THEN
163: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
164: END IF;

Line 169: p_encoded => FND_API.G_FALSE

165: FND_MSG_PUB.Count_And_Get
166: (
167: p_count => x_msg_count ,
168: p_data => x_msg_data ,
169: p_encoded => FND_API.G_FALSE
170: );
171: END Update_srp_quota_assign;
172:
173: PROCEDURE Change_srp_quota_custom_flag(

Line 209: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

205:
206: --
207: -- Standard call to check for call compatibility.
208: --
209: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
210: p_api_version ,
211: l_api_name ,
212: G_PKG_NAME )
213: THEN

Line 214: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

210: p_api_version ,
211: l_api_name ,
212: G_PKG_NAME )
213: THEN
214: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
215: END IF;
216:
217: --
218: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 220: IF FND_API.to_Boolean( p_init_msg_list ) THEN

216:
217: --
218: -- Initialize message list if p_init_msg_list is set to TRUE.
219: --
220: IF FND_API.to_Boolean( p_init_msg_list ) THEN
221: FND_MSG_PUB.initialize;
222: END IF;
223:
224: --

Line 227: x_return_status := FND_API.G_RET_STS_SUCCESS;

223:
224: --
225: -- Initialize API return status to success
226: --
227: x_return_status := FND_API.G_RET_STS_SUCCESS;
228: x_loading_status := 'CN_UPDATED';
229:
230: --
231: -- modified By Kumar.

Line 287: IF FND_API.To_Boolean( p_commit ) THEN

283: ,fnd_global.user_id --g_last_updated_by
284: ,fnd_global.login_id); --g_last_update_login);
285:
286: -- Standard check of p_commit.
287: IF FND_API.To_Boolean( p_commit ) THEN
288: COMMIT WORK; END IF;
289: --
290: -- Standard call to get message count and if count is 1, get message info.
291: --

Line 297: p_encoded => FND_API.G_FALSE

293: FND_MSG_PUB.Count_And_Get
294: (
295: p_count => x_msg_count ,
296: p_data => x_msg_data ,
297: p_encoded => FND_API.G_FALSE
298: );
299: EXCEPTION
300: WHEN FND_API.G_EXC_ERROR THEN
301: ROLLBACK TO change_srp_quota_custom_flag;

Line 300: WHEN FND_API.G_EXC_ERROR THEN

296: p_data => x_msg_data ,
297: p_encoded => FND_API.G_FALSE
298: );
299: EXCEPTION
300: WHEN FND_API.G_EXC_ERROR THEN
301: ROLLBACK TO change_srp_quota_custom_flag;
302: x_return_status := FND_API.G_RET_STS_ERROR ;
303: FND_MSG_PUB.Count_And_Get
304: (

Line 302: x_return_status := FND_API.G_RET_STS_ERROR ;

298: );
299: EXCEPTION
300: WHEN FND_API.G_EXC_ERROR THEN
301: ROLLBACK TO change_srp_quota_custom_flag;
302: x_return_status := FND_API.G_RET_STS_ERROR ;
303: FND_MSG_PUB.Count_And_Get
304: (
305: p_count => x_msg_count ,
306: p_data => x_msg_data ,

Line 307: p_encoded => FND_API.G_FALSE

303: FND_MSG_PUB.Count_And_Get
304: (
305: p_count => x_msg_count ,
306: p_data => x_msg_data ,
307: p_encoded => FND_API.G_FALSE
308: );
309: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
310: ROLLBACK TO change_srp_quota_custom_flag;
311: x_loading_status := 'UNEXPECTED_ERR';

Line 309: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

305: p_count => x_msg_count ,
306: p_data => x_msg_data ,
307: p_encoded => FND_API.G_FALSE
308: );
309: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
310: ROLLBACK TO change_srp_quota_custom_flag;
311: x_loading_status := 'UNEXPECTED_ERR';
312: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
313: FND_MSG_PUB.Count_And_Get

Line 312: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

308: );
309: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
310: ROLLBACK TO change_srp_quota_custom_flag;
311: x_loading_status := 'UNEXPECTED_ERR';
312: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
313: FND_MSG_PUB.Count_And_Get
314: (
315: p_count => x_msg_count ,
316: p_data => x_msg_data ,

Line 317: p_encoded => FND_API.G_FALSE

313: FND_MSG_PUB.Count_And_Get
314: (
315: p_count => x_msg_count ,
316: p_data => x_msg_data ,
317: p_encoded => FND_API.G_FALSE
318: );
319: WHEN OTHERS THEN
320: ROLLBACK TO change_srp_quota_custom_flag;
321: x_loading_status := 'UNEXPECTED_ERR';

Line 322: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

318: );
319: WHEN OTHERS THEN
320: ROLLBACK TO change_srp_quota_custom_flag;
321: x_loading_status := 'UNEXPECTED_ERR';
322: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
323: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
324: THEN
325: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
326: END IF;

Line 331: p_encoded => FND_API.G_FALSE

327: FND_MSG_PUB.Count_And_Get
328: (
329: p_count => x_msg_count ,
330: p_data => x_msg_data ,
331: p_encoded => FND_API.G_FALSE
332: );
333:
334: END Change_srp_quota_custom_flag ;
335:

Line 368: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

364:
365: --
366: -- Standard call to check for call compatibility.
367: --
368: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
369: p_api_version ,
370: l_api_name ,
371: G_PKG_NAME )
372: THEN

Line 373: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

369: p_api_version ,
370: l_api_name ,
371: G_PKG_NAME )
372: THEN
373: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
374: END IF;
375:
376: --
377: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 379: IF FND_API.to_Boolean( p_init_msg_list ) THEN

375:
376: --
377: -- Initialize message list if p_init_msg_list is set to TRUE.
378: --
379: IF FND_API.to_Boolean( p_init_msg_list ) THEN
380: FND_MSG_PUB.initialize;
381: END IF;
382:
383: --

Line 386: x_return_status := FND_API.G_RET_STS_SUCCESS;

382:
383: --
384: -- Initialize API return status to success
385: --
386: x_return_status := FND_API.G_RET_STS_SUCCESS;
387: x_loading_status := 'CN_UPDATED';
388:
389: SELECT org_id INTO l_org_id
390: FROM cn_srp_quota_rules_all

Line 413: IF FND_API.To_Boolean( p_commit ) THEN

409: x_performance_goal => p_performance_goal);
410:
411:
412: -- Standard check of p_commit.
413: IF FND_API.To_Boolean( p_commit ) THEN
414: COMMIT WORK; END IF;
415: --
416: -- Standard call to get message count and if count is 1, get message info.
417: --

Line 423: p_encoded => FND_API.G_FALSE

419: FND_MSG_PUB.Count_And_Get
420: (
421: p_count => x_msg_count ,
422: p_data => x_msg_data ,
423: p_encoded => FND_API.G_FALSE
424: );
425:
426: EXCEPTION
427: WHEN FND_API.G_EXC_ERROR THEN

Line 427: WHEN FND_API.G_EXC_ERROR THEN

423: p_encoded => FND_API.G_FALSE
424: );
425:
426: EXCEPTION
427: WHEN FND_API.G_EXC_ERROR THEN
428: ROLLBACK TO Update_Srp_Quota_Rules;
429: x_return_status := FND_API.G_RET_STS_ERROR ;
430: FND_MSG_PUB.Count_And_Get
431: (

Line 429: x_return_status := FND_API.G_RET_STS_ERROR ;

425:
426: EXCEPTION
427: WHEN FND_API.G_EXC_ERROR THEN
428: ROLLBACK TO Update_Srp_Quota_Rules;
429: x_return_status := FND_API.G_RET_STS_ERROR ;
430: FND_MSG_PUB.Count_And_Get
431: (
432: p_count => x_msg_count ,
433: p_data => x_msg_data ,

Line 434: p_encoded => FND_API.G_FALSE

430: FND_MSG_PUB.Count_And_Get
431: (
432: p_count => x_msg_count ,
433: p_data => x_msg_data ,
434: p_encoded => FND_API.G_FALSE
435: );
436: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
437: ROLLBACK TO Update_Srp_Quota_Rules;
438: x_loading_status := 'UNEXPECTED_ERR';

Line 436: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

432: p_count => x_msg_count ,
433: p_data => x_msg_data ,
434: p_encoded => FND_API.G_FALSE
435: );
436: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
437: ROLLBACK TO Update_Srp_Quota_Rules;
438: x_loading_status := 'UNEXPECTED_ERR';
439: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
440: FND_MSG_PUB.Count_And_Get

Line 439: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

435: );
436: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
437: ROLLBACK TO Update_Srp_Quota_Rules;
438: x_loading_status := 'UNEXPECTED_ERR';
439: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
440: FND_MSG_PUB.Count_And_Get
441: (
442: p_count => x_msg_count ,
443: p_data => x_msg_data ,

Line 444: p_encoded => FND_API.G_FALSE

440: FND_MSG_PUB.Count_And_Get
441: (
442: p_count => x_msg_count ,
443: p_data => x_msg_data ,
444: p_encoded => FND_API.G_FALSE
445: );
446: WHEN OTHERS THEN
447: ROLLBACK TO Update_Srp_Quota_Rules;
448: x_loading_status := 'UNEXPECTED_ERR';

Line 449: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

445: );
446: WHEN OTHERS THEN
447: ROLLBACK TO Update_Srp_Quota_Rules;
448: x_loading_status := 'UNEXPECTED_ERR';
449: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
450: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
451: THEN
452: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
453: END IF;

Line 458: p_encoded => FND_API.G_FALSE

454: FND_MSG_PUB.Count_And_Get
455: (
456: p_count => x_msg_count ,
457: p_data => x_msg_data ,
458: p_encoded => FND_API.G_FALSE
459: );
460:
461: END Update_Srp_Quota_Rules;
462:

Line 495: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

491:
492: --
493: -- Standard call to check for call compatibility.
494: --
495: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
496: p_api_version ,
497: l_api_name ,
498: G_PKG_NAME )
499: THEN

Line 500: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

496: p_api_version ,
497: l_api_name ,
498: G_PKG_NAME )
499: THEN
500: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
501: END IF;
502:
503: --
504: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 506: IF FND_API.to_Boolean( p_init_msg_list ) THEN

502:
503: --
504: -- Initialize message list if p_init_msg_list is set to TRUE.
505: --
506: IF FND_API.to_Boolean( p_init_msg_list ) THEN
507: FND_MSG_PUB.initialize;
508: END IF;
509:
510: --

Line 513: x_return_status := FND_API.G_RET_STS_SUCCESS;

509:
510: --
511: -- Initialize API return status to success
512: --
513: x_return_status := FND_API.G_RET_STS_SUCCESS;
514: x_loading_status := 'CN_UPDATED';
515:
516: SELECT org_id INTO l_org_id
517: FROM cn_srp_rule_uplifts_all

Line 542: IF FND_API.To_Boolean( p_commit ) THEN

538: ,p_last_update_login => fnd_global.login_id);
539:
540:
541: -- Standard check of p_commit.
542: IF FND_API.To_Boolean( p_commit ) THEN
543: COMMIT WORK; END IF;
544:
545: --
546: -- Standard call to get message count and if count is 1, get message info.

Line 553: p_encoded => FND_API.G_FALSE

549: FND_MSG_PUB.Count_And_Get
550: (
551: p_count => x_msg_count ,
552: p_data => x_msg_data ,
553: p_encoded => FND_API.G_FALSE
554: );
555:
556: EXCEPTION
557: WHEN FND_API.G_EXC_ERROR THEN

Line 557: WHEN FND_API.G_EXC_ERROR THEN

553: p_encoded => FND_API.G_FALSE
554: );
555:
556: EXCEPTION
557: WHEN FND_API.G_EXC_ERROR THEN
558: ROLLBACK TO Update_Srp_Rule_Uplifts;
559: x_return_status := FND_API.G_RET_STS_ERROR ;
560: FND_MSG_PUB.Count_And_Get
561: (

Line 559: x_return_status := FND_API.G_RET_STS_ERROR ;

555:
556: EXCEPTION
557: WHEN FND_API.G_EXC_ERROR THEN
558: ROLLBACK TO Update_Srp_Rule_Uplifts;
559: x_return_status := FND_API.G_RET_STS_ERROR ;
560: FND_MSG_PUB.Count_And_Get
561: (
562: p_count => x_msg_count ,
563: p_data => x_msg_data ,

Line 564: p_encoded => FND_API.G_FALSE

560: FND_MSG_PUB.Count_And_Get
561: (
562: p_count => x_msg_count ,
563: p_data => x_msg_data ,
564: p_encoded => FND_API.G_FALSE
565: );
566: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
567: ROLLBACK TO Update_Srp_Rule_Uplifts;
568: x_loading_status := 'UNEXPECTED_ERR';

Line 566: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

562: p_count => x_msg_count ,
563: p_data => x_msg_data ,
564: p_encoded => FND_API.G_FALSE
565: );
566: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
567: ROLLBACK TO Update_Srp_Rule_Uplifts;
568: x_loading_status := 'UNEXPECTED_ERR';
569: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
570: FND_MSG_PUB.Count_And_Get

Line 569: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

565: );
566: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
567: ROLLBACK TO Update_Srp_Rule_Uplifts;
568: x_loading_status := 'UNEXPECTED_ERR';
569: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
570: FND_MSG_PUB.Count_And_Get
571: (
572: p_count => x_msg_count ,
573: p_data => x_msg_data ,

Line 574: p_encoded => FND_API.G_FALSE

570: FND_MSG_PUB.Count_And_Get
571: (
572: p_count => x_msg_count ,
573: p_data => x_msg_data ,
574: p_encoded => FND_API.G_FALSE
575: );
576: WHEN OTHERS THEN
577: ROLLBACK TO Update_Srp_Rule_Uplifts;
578: x_loading_status := 'UNEXPECTED_ERR';

Line 579: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

575: );
576: WHEN OTHERS THEN
577: ROLLBACK TO Update_Srp_Rule_Uplifts;
578: x_loading_status := 'UNEXPECTED_ERR';
579: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
580: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
581: THEN
582: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
583: END IF;

Line 588: p_encoded => FND_API.G_FALSE

584: FND_MSG_PUB.Count_And_Get
585: (
586: p_count => x_msg_count ,
587: p_data => x_msg_data ,
588: p_encoded => FND_API.G_FALSE
589: );
590:
591: END Update_Srp_Rule_Uplifts;
592: