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

Line 14: -- Default = FND_API.G_FALSE

10: -- Pre-reqs : None.
11: -- Parameters :
12: -- IN : p_api_version IN NUMBER Required
13: -- p_init_msg_list IN VARCHAR2 Optional
14: -- Default = FND_API.G_FALSE
15: -- p_commit IN VARCHAR2 Optional
16: -- Default = FND_API.G_FALSE
17: -- p_validation_level IN NUMBER Optional
18: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 16: -- Default = FND_API.G_FALSE

12: -- IN : p_api_version IN NUMBER Required
13: -- p_init_msg_list IN VARCHAR2 Optional
14: -- Default = FND_API.G_FALSE
15: -- p_commit IN VARCHAR2 Optional
16: -- Default = FND_API.G_FALSE
17: -- p_validation_level IN NUMBER Optional
18: -- Default = FND_API.G_VALID_LEVEL_FULL
19: -- p_quota_assign IN quota_assign_rec_type
20: -- OUT : x_return_status OUT VARCHAR2(1)

Line 18: -- Default = FND_API.G_VALID_LEVEL_FULL

14: -- Default = FND_API.G_FALSE
15: -- p_commit IN VARCHAR2 Optional
16: -- Default = FND_API.G_FALSE
17: -- p_validation_level IN NUMBER Optional
18: -- Default = FND_API.G_VALID_LEVEL_FULL
19: -- p_quota_assign IN quota_assign_rec_type
20: -- OUT : x_return_status OUT VARCHAR2(1)
21: -- x_msg_count OUT NUMBER
22: -- x_msg_data OUT VARCHAR2(2000)

Line 29: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

25: --
26: -- End of comments
27: PROCEDURE create_quota_assign (
28: p_api_version IN NUMBER,
29: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
30: p_commit IN VARCHAR2 := fnd_api.g_false,
31: p_validation_level IN NUMBER
32: := fnd_api.g_valid_level_full,
33: p_quota_assign IN OUT NOCOPY quota_assign_rec_type,

Line 30: p_commit IN VARCHAR2 := fnd_api.g_false,

26: -- End of comments
27: PROCEDURE create_quota_assign (
28: p_api_version IN NUMBER,
29: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
30: p_commit IN VARCHAR2 := fnd_api.g_false,
31: p_validation_level IN NUMBER
32: := fnd_api.g_valid_level_full,
33: p_quota_assign IN OUT NOCOPY quota_assign_rec_type,
34: x_return_status OUT NOCOPY VARCHAR2,

Line 32: := fnd_api.g_valid_level_full,

28: p_api_version IN NUMBER,
29: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
30: p_commit IN VARCHAR2 := fnd_api.g_false,
31: p_validation_level IN NUMBER
32: := fnd_api.g_valid_level_full,
33: p_quota_assign IN OUT NOCOPY quota_assign_rec_type,
34: x_return_status OUT NOCOPY VARCHAR2,
35: x_msg_count OUT NOCOPY NUMBER,
36: x_msg_data OUT NOCOPY VARCHAR2

Line 64: IF NOT fnd_api.compatible_api_call (l_api_version,

60: -- Standard Start of API savepoint
61: SAVEPOINT create_quota_assign;
62:
63: -- Standard call to check for call compatibility.
64: IF NOT fnd_api.compatible_api_call (l_api_version,
65: p_api_version,
66: l_api_name,
67: g_pkg_name
68: )

Line 70: RAISE fnd_api.g_exc_unexpected_error;

66: l_api_name,
67: g_pkg_name
68: )
69: THEN
70: RAISE fnd_api.g_exc_unexpected_error;
71: END IF;
72:
73: -- Initialize message list if p_init_msg_list is set to TRUE.
74: IF fnd_api.to_boolean (p_init_msg_list)

Line 74: IF fnd_api.to_boolean (p_init_msg_list)

70: RAISE fnd_api.g_exc_unexpected_error;
71: END IF;
72:
73: -- Initialize message list if p_init_msg_list is set to TRUE.
74: IF fnd_api.to_boolean (p_init_msg_list)
75: THEN
76: fnd_msg_pub.initialize;
77: END IF;
78:

Line 80: x_return_status := fnd_api.g_ret_sts_success;

76: fnd_msg_pub.initialize;
77: END IF;
78:
79: -- Initialize API return status to success
80: x_return_status := fnd_api.g_ret_sts_success;
81:
82: -- API body
83:
84: -- Convert fnd_api.g_miss to NULL

Line 84: -- Convert fnd_api.g_miss to NULL

80: x_return_status := fnd_api.g_ret_sts_success;
81:
82: -- API body
83:
84: -- Convert fnd_api.g_miss to NULL
85:
86: -- 1. name can not be null
87: IF (p_quota_assign.comp_plan_id IS NULL)
88: OR (p_quota_assign.comp_plan_id = fnd_api.g_miss_num)

Line 88: OR (p_quota_assign.comp_plan_id = fnd_api.g_miss_num)

84: -- Convert fnd_api.g_miss to NULL
85:
86: -- 1. name can not be null
87: IF (p_quota_assign.comp_plan_id IS NULL)
88: OR (p_quota_assign.comp_plan_id = fnd_api.g_miss_num)
89: OR (p_quota_assign.quota_id IS NULL)
90: OR (p_quota_assign.quota_id = fnd_api.g_miss_num)
91: THEN
92: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

Line 90: OR (p_quota_assign.quota_id = fnd_api.g_miss_num)

86: -- 1. name can not be null
87: IF (p_quota_assign.comp_plan_id IS NULL)
88: OR (p_quota_assign.comp_plan_id = fnd_api.g_miss_num)
89: OR (p_quota_assign.quota_id IS NULL)
90: OR (p_quota_assign.quota_id = fnd_api.g_miss_num)
91: THEN
92: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
93: THEN
94: fnd_message.set_name ('CN', 'CN_REQ_PAR_MISSING');

Line 98: RAISE fnd_api.g_exc_error;

94: fnd_message.set_name ('CN', 'CN_REQ_PAR_MISSING');
95: fnd_msg_pub.ADD;
96: END IF;
97:
98: RAISE fnd_api.g_exc_error;
99: END IF;
100:
101: -- 2. quota assign name must be unique
102: SELECT COUNT (1)

Line 122: RAISE fnd_api.g_exc_error;

118: );
119: fnd_msg_pub.ADD;
120: END IF;
121:
122: RAISE fnd_api.g_exc_error;
123: END IF;
124:
125: -- 3. quota dates must overlap plan dates
126: SELECT COUNT (1)

Line 144: RAISE fnd_api.g_exc_error;

140: fnd_message.set_name ('CN', 'CN_PLAN_ELT_DISJOINT');
141: fnd_msg_pub.ADD;
142: END IF;
143:
144: RAISE fnd_api.g_exc_error;
145: END IF;
146:
147: -- 4. interdependent quotas must reference only quotas with lower
148: -- sequence number and must reference quotas in same plan

Line 180: RAISE fnd_api.g_exc_error;

176: fnd_message.set_name ('CN', 'CN_IDQ_REFERENCE_NOT_VALID');
177: fnd_msg_pub.ADD;
178: END IF;
179:
180: RAISE fnd_api.g_exc_error;
181: END IF;
182: END LOOP;
183:
184: END IF;

Line 188: fnd_api.g_miss_num, NULL,

184: END IF;
185:
186: -- do comp plan quota assignment
187: SELECT DECODE (p_quota_assign.quota_id,
188: fnd_api.g_miss_num, NULL,
189: p_quota_assign.quota_id
190: ),
191: DECODE (p_quota_assign.comp_plan_id,
192: fnd_api.g_miss_num, NULL,

Line 192: fnd_api.g_miss_num, NULL,

188: fnd_api.g_miss_num, NULL,
189: p_quota_assign.quota_id
190: ),
191: DECODE (p_quota_assign.comp_plan_id,
192: fnd_api.g_miss_num, NULL,
193: p_quota_assign.comp_plan_id
194: ),
195: DECODE (p_quota_assign.org_id,
196: fnd_api.g_miss_num, NULL,

Line 196: fnd_api.g_miss_num, NULL,

192: fnd_api.g_miss_num, NULL,
193: p_quota_assign.comp_plan_id
194: ),
195: DECODE (p_quota_assign.org_id,
196: fnd_api.g_miss_num, NULL,
197: p_quota_assign.org_id
198: )
199: INTO l_quota_id,
200: l_comp_plan_id,

Line 261: IF fnd_api.to_boolean (p_commit)

257: CLOSE objversion_cur;
258:
259: -- End of API body.
260: -- Standard check of p_commit.
261: IF fnd_api.to_boolean (p_commit)
262: THEN
263: COMMIT WORK;
264: END IF;
265:

Line 269: p_encoded => fnd_api.g_false

265:
266: -- Standard call to get message count and if count is 1, get message info.
267: fnd_msg_pub.count_and_get (p_count => x_msg_count,
268: p_data => x_msg_data,
269: p_encoded => fnd_api.g_false
270: );
271: EXCEPTION
272: WHEN fnd_api.g_exc_error
273: THEN

Line 272: WHEN fnd_api.g_exc_error

268: p_data => x_msg_data,
269: p_encoded => fnd_api.g_false
270: );
271: EXCEPTION
272: WHEN fnd_api.g_exc_error
273: THEN
274: ROLLBACK TO create_quota_assign;
275: x_return_status := fnd_api.g_ret_sts_error;
276: fnd_msg_pub.count_and_get (p_count => x_msg_count,

Line 275: x_return_status := fnd_api.g_ret_sts_error;

271: EXCEPTION
272: WHEN fnd_api.g_exc_error
273: THEN
274: ROLLBACK TO create_quota_assign;
275: x_return_status := fnd_api.g_ret_sts_error;
276: fnd_msg_pub.count_and_get (p_count => x_msg_count,
277: p_data => x_msg_data,
278: p_encoded => fnd_api.g_false
279: );

Line 278: p_encoded => fnd_api.g_false

274: ROLLBACK TO create_quota_assign;
275: x_return_status := fnd_api.g_ret_sts_error;
276: fnd_msg_pub.count_and_get (p_count => x_msg_count,
277: p_data => x_msg_data,
278: p_encoded => fnd_api.g_false
279: );
280: WHEN fnd_api.g_exc_unexpected_error
281: THEN
282: ROLLBACK TO create_quota_assign;

Line 280: WHEN fnd_api.g_exc_unexpected_error

276: fnd_msg_pub.count_and_get (p_count => x_msg_count,
277: p_data => x_msg_data,
278: p_encoded => fnd_api.g_false
279: );
280: WHEN fnd_api.g_exc_unexpected_error
281: THEN
282: ROLLBACK TO create_quota_assign;
283: x_return_status := fnd_api.g_ret_sts_unexp_error;
284: fnd_msg_pub.count_and_get (p_count => x_msg_count,

Line 283: x_return_status := fnd_api.g_ret_sts_unexp_error;

279: );
280: WHEN fnd_api.g_exc_unexpected_error
281: THEN
282: ROLLBACK TO create_quota_assign;
283: x_return_status := fnd_api.g_ret_sts_unexp_error;
284: fnd_msg_pub.count_and_get (p_count => x_msg_count,
285: p_data => x_msg_data,
286: p_encoded => fnd_api.g_false
287: );

Line 286: p_encoded => fnd_api.g_false

282: ROLLBACK TO create_quota_assign;
283: x_return_status := fnd_api.g_ret_sts_unexp_error;
284: fnd_msg_pub.count_and_get (p_count => x_msg_count,
285: p_data => x_msg_data,
286: p_encoded => fnd_api.g_false
287: );
288: WHEN OTHERS
289: THEN
290: ROLLBACK TO create_quota_assign;

Line 291: x_return_status := fnd_api.g_ret_sts_unexp_error;

287: );
288: WHEN OTHERS
289: THEN
290: ROLLBACK TO create_quota_assign;
291: x_return_status := fnd_api.g_ret_sts_unexp_error;
292:
293: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
294: THEN
295: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

Line 300: p_encoded => fnd_api.g_false

296: END IF;
297:
298: fnd_msg_pub.count_and_get (p_count => x_msg_count,
299: p_data => x_msg_data,
300: p_encoded => fnd_api.g_false
301: );
302: END create_quota_assign;
303:
304: -- Start of comments

Line 312: -- Default = FND_API.G_FALSE

308: -- Pre-reqs : None.
309: -- Parameters :
310: -- IN : p_api_version IN NUMBER Required
311: -- p_init_msg_list IN VARCHAR2 Optional
312: -- Default = FND_API.G_FALSE
313: -- p_commit IN VARCHAR2 Optional
314: -- Default = FND_API.G_FALSE
315: -- p_validation_level IN NUMBER Optional
316: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 314: -- Default = FND_API.G_FALSE

310: -- IN : p_api_version IN NUMBER Required
311: -- p_init_msg_list IN VARCHAR2 Optional
312: -- Default = FND_API.G_FALSE
313: -- p_commit IN VARCHAR2 Optional
314: -- Default = FND_API.G_FALSE
315: -- p_validation_level IN NUMBER Optional
316: -- Default = FND_API.G_VALID_LEVEL_FULL
317: -- p_quota_assign IN quota_assign_rec_type
318: -- OUT : x_return_status OUT VARCHAR2(1)

Line 316: -- Default = FND_API.G_VALID_LEVEL_FULL

312: -- Default = FND_API.G_FALSE
313: -- p_commit IN VARCHAR2 Optional
314: -- Default = FND_API.G_FALSE
315: -- p_validation_level IN NUMBER Optional
316: -- Default = FND_API.G_VALID_LEVEL_FULL
317: -- p_quota_assign IN quota_assign_rec_type
318: -- OUT : x_return_status OUT VARCHAR2(1)
319: -- x_msg_count OUT NUMBER
320: -- x_msg_data OUT VARCHAR2(2000)

Line 327: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

323: --
324: -- End of comments
325: PROCEDURE update_quota_assign (
326: p_api_version IN NUMBER,
327: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
328: p_commit IN VARCHAR2 := fnd_api.g_false,
329: p_validation_level IN NUMBER
330: := fnd_api.g_valid_level_full,
331: p_quota_assign IN OUT NOCOPY quota_assign_rec_type,

Line 328: p_commit IN VARCHAR2 := fnd_api.g_false,

324: -- End of comments
325: PROCEDURE update_quota_assign (
326: p_api_version IN NUMBER,
327: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
328: p_commit IN VARCHAR2 := fnd_api.g_false,
329: p_validation_level IN NUMBER
330: := fnd_api.g_valid_level_full,
331: p_quota_assign IN OUT NOCOPY quota_assign_rec_type,
332: x_return_status OUT NOCOPY VARCHAR2,

Line 330: := fnd_api.g_valid_level_full,

326: p_api_version IN NUMBER,
327: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
328: p_commit IN VARCHAR2 := fnd_api.g_false,
329: p_validation_level IN NUMBER
330: := fnd_api.g_valid_level_full,
331: p_quota_assign IN OUT NOCOPY quota_assign_rec_type,
332: x_return_status OUT NOCOPY VARCHAR2,
333: x_msg_count OUT NOCOPY NUMBER,
334: x_msg_data OUT NOCOPY VARCHAR2

Line 373: IF NOT fnd_api.compatible_api_call (l_api_version,

369: -- Standard Start of API savepoint
370: SAVEPOINT update_quota_assign;
371:
372: -- Standard call to check for call compatibility.
373: IF NOT fnd_api.compatible_api_call (l_api_version,
374: p_api_version,
375: l_api_name,
376: g_pkg_name
377: )

Line 379: RAISE fnd_api.g_exc_unexpected_error;

375: l_api_name,
376: g_pkg_name
377: )
378: THEN
379: RAISE fnd_api.g_exc_unexpected_error;
380: END IF;
381:
382: -- Initialize message list if p_init_msg_list is set to TRUE.
383: IF fnd_api.to_boolean (p_init_msg_list)

Line 383: IF fnd_api.to_boolean (p_init_msg_list)

379: RAISE fnd_api.g_exc_unexpected_error;
380: END IF;
381:
382: -- Initialize message list if p_init_msg_list is set to TRUE.
383: IF fnd_api.to_boolean (p_init_msg_list)
384: THEN
385: fnd_msg_pub.initialize;
386: END IF;
387:

Line 389: x_return_status := fnd_api.g_ret_sts_success;

385: fnd_msg_pub.initialize;
386: END IF;
387:
388: -- Initialize API return status to success
389: x_return_status := fnd_api.g_ret_sts_success;
390:
391: -- API body
392:
393: -- 1. name can not be null

Line 403: RAISE fnd_api.g_exc_error;

399: fnd_message.set_name ('CN', 'CN_REQ_PAR_MISSING');
400: fnd_msg_pub.ADD;
401: END IF;
402:
403: RAISE fnd_api.g_exc_error;
404: END IF;
405:
406: -- Getting Old Sequence
407: select count(1) into l_temp_count from cn_quota_assigns where quota_id = p_quota_assign.quota_id and comp_plan_id = p_quota_assign.comp_plan_id;

Line 439: RAISE fnd_api.g_exc_error;

435: );
436: fnd_msg_pub.ADD;
437: END IF;
438:
439: RAISE fnd_api.g_exc_error;
440: END IF;
441:
442: OPEN l_old_quota_assign_cr;
443:

Line 450: fnd_api.g_miss_num, l_old_quota_assign.comp_plan_id,

446:
447: CLOSE l_old_quota_assign_cr;
448:
449: SELECT DECODE (p_quota_assign.comp_plan_id,
450: fnd_api.g_miss_num, l_old_quota_assign.comp_plan_id,
451: p_quota_assign.comp_plan_id
452: ),
453: DECODE (p_quota_assign.quota_id,
454: fnd_api.g_miss_num, l_old_quota_assign.quota_id,

Line 454: fnd_api.g_miss_num, l_old_quota_assign.quota_id,

450: fnd_api.g_miss_num, l_old_quota_assign.comp_plan_id,
451: p_quota_assign.comp_plan_id
452: ),
453: DECODE (p_quota_assign.quota_id,
454: fnd_api.g_miss_num, l_old_quota_assign.quota_id,
455: p_quota_assign.quota_id
456: ),
457: p_quota_assign.quota_assign_id,
458: DECODE (p_quota_assign.org_id,

Line 459: fnd_api.g_miss_num, l_old_quota_assign.org_id,

455: p_quota_assign.quota_id
456: ),
457: p_quota_assign.quota_assign_id,
458: DECODE (p_quota_assign.org_id,
459: fnd_api.g_miss_num, l_old_quota_assign.org_id,
460: p_quota_assign.org_id
461: )
462: INTO l_comp_plan_id,
463: l_quota_id,

Line 487: RAISE fnd_api.g_exc_error;

483: fnd_message.set_name ('CN', 'CN_PLAN_ELT_DISJOINT');
484: fnd_msg_pub.ADD;
485: END IF;
486:
487: RAISE fnd_api.g_exc_error;
488: END IF;
489:
490: -- 4. interdependent quotas must reference only quotas with lower
491: -- sequence number and must reference quotas in same plan

Line 524: RAISE fnd_api.g_exc_error;

520: fnd_message.set_name ('CN', 'CN_IDQ_REFERENCE_NOT_VALID');
521: fnd_msg_pub.ADD;
522: END IF;
523:
524: RAISE fnd_api.g_exc_error;
525: END IF;
526: END LOOP;
527:
528: END IF;

Line 536: RAISE fnd_api.g_exc_error;

532: p_quota_assign.object_version_number
533: THEN
534: fnd_message.set_name ('CN', 'CN_RECORD_CHANGED');
535: fnd_msg_pub.ADD;
536: RAISE fnd_api.g_exc_error;
537: END IF;
538:
539: cn_quota_assigns_pkg.begin_record
540: (x_operation => 'UPDATE',

Line 657: IF fnd_api.to_boolean (p_commit)

653: OPEN objversion_cur;
654: FETCH objversion_cur into p_quota_assign.OBJECT_VERSION_NUMBER;
655: CLOSE objversion_cur;
656:
657: IF fnd_api.to_boolean (p_commit)
658: THEN
659: COMMIT WORK;
660: END IF;
661:

Line 665: p_encoded => fnd_api.g_false

661:
662: -- Standard call to get message count and if count is 1, get message info.
663: fnd_msg_pub.count_and_get (p_count => x_msg_count,
664: p_data => x_msg_data,
665: p_encoded => fnd_api.g_false
666: );
667: EXCEPTION
668: WHEN fnd_api.g_exc_error
669: THEN

Line 668: WHEN fnd_api.g_exc_error

664: p_data => x_msg_data,
665: p_encoded => fnd_api.g_false
666: );
667: EXCEPTION
668: WHEN fnd_api.g_exc_error
669: THEN
670: ROLLBACK TO update_quota_assign;
671: x_return_status := fnd_api.g_ret_sts_error;
672: fnd_msg_pub.count_and_get (p_count => x_msg_count,

Line 671: x_return_status := fnd_api.g_ret_sts_error;

667: EXCEPTION
668: WHEN fnd_api.g_exc_error
669: THEN
670: ROLLBACK TO update_quota_assign;
671: x_return_status := fnd_api.g_ret_sts_error;
672: fnd_msg_pub.count_and_get (p_count => x_msg_count,
673: p_data => x_msg_data,
674: p_encoded => fnd_api.g_false
675: );

Line 674: p_encoded => fnd_api.g_false

670: ROLLBACK TO update_quota_assign;
671: x_return_status := fnd_api.g_ret_sts_error;
672: fnd_msg_pub.count_and_get (p_count => x_msg_count,
673: p_data => x_msg_data,
674: p_encoded => fnd_api.g_false
675: );
676: WHEN fnd_api.g_exc_unexpected_error
677: THEN
678: ROLLBACK TO update_quota_assign;

Line 676: WHEN fnd_api.g_exc_unexpected_error

672: fnd_msg_pub.count_and_get (p_count => x_msg_count,
673: p_data => x_msg_data,
674: p_encoded => fnd_api.g_false
675: );
676: WHEN fnd_api.g_exc_unexpected_error
677: THEN
678: ROLLBACK TO update_quota_assign;
679: x_return_status := fnd_api.g_ret_sts_unexp_error;
680: fnd_msg_pub.count_and_get (p_count => x_msg_count,

Line 679: x_return_status := fnd_api.g_ret_sts_unexp_error;

675: );
676: WHEN fnd_api.g_exc_unexpected_error
677: THEN
678: ROLLBACK TO update_quota_assign;
679: x_return_status := fnd_api.g_ret_sts_unexp_error;
680: fnd_msg_pub.count_and_get (p_count => x_msg_count,
681: p_data => x_msg_data,
682: p_encoded => fnd_api.g_false
683: );

Line 682: p_encoded => fnd_api.g_false

678: ROLLBACK TO update_quota_assign;
679: x_return_status := fnd_api.g_ret_sts_unexp_error;
680: fnd_msg_pub.count_and_get (p_count => x_msg_count,
681: p_data => x_msg_data,
682: p_encoded => fnd_api.g_false
683: );
684: WHEN OTHERS
685: THEN
686: ROLLBACK TO update_quota_assign;

Line 687: x_return_status := fnd_api.g_ret_sts_unexp_error;

683: );
684: WHEN OTHERS
685: THEN
686: ROLLBACK TO update_quota_assign;
687: x_return_status := fnd_api.g_ret_sts_unexp_error;
688:
689: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
690: THEN
691: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

Line 696: p_encoded => fnd_api.g_false

692: END IF;
693:
694: fnd_msg_pub.count_and_get (p_count => x_msg_count,
695: p_data => x_msg_data,
696: p_encoded => fnd_api.g_false
697: );
698: END update_quota_assign;
699:
700: -- Start of comments

Line 708: -- Default = FND_API.G_FALSE

704: -- Pre-reqs : None.
705: -- Parameters :
706: -- IN : p_api_version IN NUMBER Required
707: -- p_init_msg_list IN VARCHAR2 Optional
708: -- Default = FND_API.G_FALSE
709: -- p_commit IN VARCHAR2 Optional
710: -- Default = FND_API.G_FALSE
711: -- p_validation_level IN NUMBER Optional
712: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 710: -- Default = FND_API.G_FALSE

706: -- IN : p_api_version IN NUMBER Required
707: -- p_init_msg_list IN VARCHAR2 Optional
708: -- Default = FND_API.G_FALSE
709: -- p_commit IN VARCHAR2 Optional
710: -- Default = FND_API.G_FALSE
711: -- p_validation_level IN NUMBER Optional
712: -- Default = FND_API.G_VALID_LEVEL_FULL
713: -- p_quota_assign IN quota_assign_rec_type
714: -- OUT : x_return_status OUT VARCHAR2(1)

Line 712: -- Default = FND_API.G_VALID_LEVEL_FULL

708: -- Default = FND_API.G_FALSE
709: -- p_commit IN VARCHAR2 Optional
710: -- Default = FND_API.G_FALSE
711: -- p_validation_level IN NUMBER Optional
712: -- Default = FND_API.G_VALID_LEVEL_FULL
713: -- p_quota_assign IN quota_assign_rec_type
714: -- OUT : x_return_status OUT VARCHAR2(1)
715: -- x_msg_count OUT NUMBER
716: -- x_msg_data OUT VARCHAR2(2000)

Line 723: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

719: --
720: -- End of comments
721: PROCEDURE delete_quota_assign (
722: p_api_version IN NUMBER,
723: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
724: p_commit IN VARCHAR2 := fnd_api.g_false,
725: p_validation_level IN NUMBER
726: := fnd_api.g_valid_level_full,
727: p_quota_assign IN quota_assign_rec_type,

Line 724: p_commit IN VARCHAR2 := fnd_api.g_false,

720: -- End of comments
721: PROCEDURE delete_quota_assign (
722: p_api_version IN NUMBER,
723: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
724: p_commit IN VARCHAR2 := fnd_api.g_false,
725: p_validation_level IN NUMBER
726: := fnd_api.g_valid_level_full,
727: p_quota_assign IN quota_assign_rec_type,
728: x_return_status OUT NOCOPY VARCHAR2,

Line 726: := fnd_api.g_valid_level_full,

722: p_api_version IN NUMBER,
723: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
724: p_commit IN VARCHAR2 := fnd_api.g_false,
725: p_validation_level IN NUMBER
726: := fnd_api.g_valid_level_full,
727: p_quota_assign IN quota_assign_rec_type,
728: x_return_status OUT NOCOPY VARCHAR2,
729: x_msg_count OUT NOCOPY NUMBER,
730: x_msg_data OUT NOCOPY VARCHAR2

Line 749: IF NOT fnd_api.compatible_api_call (l_api_version,

745: -- Standard Start of API savepoint
746: SAVEPOINT delete_quota_assign;
747:
748: -- Standard call to check for call compatibility.
749: IF NOT fnd_api.compatible_api_call (l_api_version,
750: p_api_version,
751: l_api_name,
752: g_pkg_name
753: )

Line 755: RAISE fnd_api.g_exc_unexpected_error;

751: l_api_name,
752: g_pkg_name
753: )
754: THEN
755: RAISE fnd_api.g_exc_unexpected_error;
756: END IF;
757:
758: -- Initialize message list if p_init_msg_list is set to TRUE.
759: IF fnd_api.to_boolean (p_init_msg_list)

Line 759: IF fnd_api.to_boolean (p_init_msg_list)

755: RAISE fnd_api.g_exc_unexpected_error;
756: END IF;
757:
758: -- Initialize message list if p_init_msg_list is set to TRUE.
759: IF fnd_api.to_boolean (p_init_msg_list)
760: THEN
761: fnd_msg_pub.initialize;
762: END IF;
763:

Line 765: x_return_status := fnd_api.g_ret_sts_success;

761: fnd_msg_pub.initialize;
762: END IF;
763:
764: -- Initialize API return status to success
765: x_return_status := fnd_api.g_ret_sts_success;
766:
767: -- API body
768:
769: -- do comp plan quota assignment

Line 780: RAISE fnd_api.g_exc_unexpected_error;

776: WHEN NO_DATA_FOUND
777: THEN
778: fnd_message.set_name ('CN', 'CN_RECORD_DELETED');
779: fnd_msg_pub.ADD;
780: RAISE fnd_api.g_exc_unexpected_error;
781: END;
782:
783: cn_quota_assigns_pkg.begin_record
784: (x_operation => 'DELETE',

Line 833: IF fnd_api.to_boolean (p_commit)

829: END IF;
830:
831: -- End of API body.
832: -- Standard check of p_commit.
833: IF fnd_api.to_boolean (p_commit)
834: THEN
835: COMMIT WORK;
836: END IF;
837:

Line 841: p_encoded => fnd_api.g_false

837:
838: -- Standard call to get message count and if count is 1, get message info.
839: fnd_msg_pub.count_and_get (p_count => x_msg_count,
840: p_data => x_msg_data,
841: p_encoded => fnd_api.g_false
842: );
843: EXCEPTION
844: WHEN fnd_api.g_exc_error
845: THEN

Line 844: WHEN fnd_api.g_exc_error

840: p_data => x_msg_data,
841: p_encoded => fnd_api.g_false
842: );
843: EXCEPTION
844: WHEN fnd_api.g_exc_error
845: THEN
846: ROLLBACK TO delete_quota_assign;
847: x_return_status := fnd_api.g_ret_sts_error;
848: fnd_msg_pub.count_and_get (p_count => x_msg_count,

Line 847: x_return_status := fnd_api.g_ret_sts_error;

843: EXCEPTION
844: WHEN fnd_api.g_exc_error
845: THEN
846: ROLLBACK TO delete_quota_assign;
847: x_return_status := fnd_api.g_ret_sts_error;
848: fnd_msg_pub.count_and_get (p_count => x_msg_count,
849: p_data => x_msg_data,
850: p_encoded => fnd_api.g_false
851: );

Line 850: p_encoded => fnd_api.g_false

846: ROLLBACK TO delete_quota_assign;
847: x_return_status := fnd_api.g_ret_sts_error;
848: fnd_msg_pub.count_and_get (p_count => x_msg_count,
849: p_data => x_msg_data,
850: p_encoded => fnd_api.g_false
851: );
852: WHEN fnd_api.g_exc_unexpected_error
853: THEN
854: ROLLBACK TO delete_quota_assign;

Line 852: WHEN fnd_api.g_exc_unexpected_error

848: fnd_msg_pub.count_and_get (p_count => x_msg_count,
849: p_data => x_msg_data,
850: p_encoded => fnd_api.g_false
851: );
852: WHEN fnd_api.g_exc_unexpected_error
853: THEN
854: ROLLBACK TO delete_quota_assign;
855: x_return_status := fnd_api.g_ret_sts_unexp_error;
856: fnd_msg_pub.count_and_get (p_count => x_msg_count,

Line 855: x_return_status := fnd_api.g_ret_sts_unexp_error;

851: );
852: WHEN fnd_api.g_exc_unexpected_error
853: THEN
854: ROLLBACK TO delete_quota_assign;
855: x_return_status := fnd_api.g_ret_sts_unexp_error;
856: fnd_msg_pub.count_and_get (p_count => x_msg_count,
857: p_data => x_msg_data,
858: p_encoded => fnd_api.g_false
859: );

Line 858: p_encoded => fnd_api.g_false

854: ROLLBACK TO delete_quota_assign;
855: x_return_status := fnd_api.g_ret_sts_unexp_error;
856: fnd_msg_pub.count_and_get (p_count => x_msg_count,
857: p_data => x_msg_data,
858: p_encoded => fnd_api.g_false
859: );
860: WHEN OTHERS
861: THEN
862: ROLLBACK TO delete_quota_assign;

Line 863: x_return_status := fnd_api.g_ret_sts_unexp_error;

859: );
860: WHEN OTHERS
861: THEN
862: ROLLBACK TO delete_quota_assign;
863: x_return_status := fnd_api.g_ret_sts_unexp_error;
864:
865: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
866: THEN
867: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

Line 872: p_encoded => fnd_api.g_false

868: END IF;
869:
870: fnd_msg_pub.count_and_get (p_count => x_msg_count,
871: p_data => x_msg_data,
872: p_encoded => fnd_api.g_false
873: );
874: END delete_quota_assign;
875:
876: -- Start of comments

Line 884: -- Default = FND_API.G_FALSE

880: -- Pre-reqs : None.
881: -- Parameters :
882: -- IN : p_api_version IN NUMBER Required
883: -- p_init_msg_list IN VARCHAR2 Optional
884: -- Default = FND_API.G_FALSE
885: -- p_commit IN VARCHAR2 Optional
886: -- Default = FND_API.G_FALSE
887: -- p_validation_level IN NUMBER Optional
888: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 886: -- Default = FND_API.G_FALSE

882: -- IN : p_api_version IN NUMBER Required
883: -- p_init_msg_list IN VARCHAR2 Optional
884: -- Default = FND_API.G_FALSE
885: -- p_commit IN VARCHAR2 Optional
886: -- Default = FND_API.G_FALSE
887: -- p_validation_level IN NUMBER Optional
888: -- Default = FND_API.G_VALID_LEVEL_FULL
889: -- p_comp_plan_id IN NUMBER
890: -- OUT : x_return_status OUT VARCHAR2(1)

Line 888: -- Default = FND_API.G_VALID_LEVEL_FULL

884: -- Default = FND_API.G_FALSE
885: -- p_commit IN VARCHAR2 Optional
886: -- Default = FND_API.G_FALSE
887: -- p_validation_level IN NUMBER Optional
888: -- Default = FND_API.G_VALID_LEVEL_FULL
889: -- p_comp_plan_id IN NUMBER
890: -- OUT : x_return_status OUT VARCHAR2(1)
891: -- x_msg_count OUT NUMBER
892: -- x_msg_data OUT VARCHAR2(2000)

Line 900: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

896: --
897: -- End of comments
898: PROCEDURE get_quota_assign (
899: p_api_version IN NUMBER,
900: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
901: p_commit IN VARCHAR2 := fnd_api.g_false,
902: p_validation_level IN NUMBER
903: := fnd_api.g_valid_level_full,
904: p_comp_plan_id IN NUMBER,

Line 901: p_commit IN VARCHAR2 := fnd_api.g_false,

897: -- End of comments
898: PROCEDURE get_quota_assign (
899: p_api_version IN NUMBER,
900: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
901: p_commit IN VARCHAR2 := fnd_api.g_false,
902: p_validation_level IN NUMBER
903: := fnd_api.g_valid_level_full,
904: p_comp_plan_id IN NUMBER,
905: x_quota_assign OUT NOCOPY quota_assign_tbl_type,

Line 903: := fnd_api.g_valid_level_full,

899: p_api_version IN NUMBER,
900: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
901: p_commit IN VARCHAR2 := fnd_api.g_false,
902: p_validation_level IN NUMBER
903: := fnd_api.g_valid_level_full,
904: p_comp_plan_id IN NUMBER,
905: x_quota_assign OUT NOCOPY quota_assign_tbl_type,
906: x_return_status OUT NOCOPY VARCHAR2,
907: x_msg_count OUT NOCOPY NUMBER,

Line 930: IF NOT fnd_api.compatible_api_call (l_api_version,

926: -- Standard Start of API savepoint
927: SAVEPOINT get_quota_assign;
928:
929: -- Standard call to check for call compatibility.
930: IF NOT fnd_api.compatible_api_call (l_api_version,
931: p_api_version,
932: l_api_name,
933: g_pkg_name
934: )

Line 936: RAISE fnd_api.g_exc_unexpected_error;

932: l_api_name,
933: g_pkg_name
934: )
935: THEN
936: RAISE fnd_api.g_exc_unexpected_error;
937: END IF;
938:
939: -- Initialize message list if p_init_msg_list is set to TRUE.
940: IF fnd_api.to_boolean (p_init_msg_list)

Line 940: IF fnd_api.to_boolean (p_init_msg_list)

936: RAISE fnd_api.g_exc_unexpected_error;
937: END IF;
938:
939: -- Initialize message list if p_init_msg_list is set to TRUE.
940: IF fnd_api.to_boolean (p_init_msg_list)
941: THEN
942: fnd_msg_pub.initialize;
943: END IF;
944:

Line 946: x_return_status := fnd_api.g_ret_sts_success;

942: fnd_msg_pub.initialize;
943: END IF;
944:
945: -- Initialize API return status to success
946: x_return_status := fnd_api.g_ret_sts_success;
947: -- API body
948: x_quota_assign := g_miss_quota_assign_rec_tb;
949: l_counter := 0;
950:

Line 972: IF fnd_api.to_boolean (p_commit)

968: END LOOP;
969:
970: -- End of API body.
971: -- Standard check of p_commit.
972: IF fnd_api.to_boolean (p_commit)
973: THEN
974: COMMIT WORK;
975: END IF;
976:

Line 980: p_encoded => fnd_api.g_false

976:
977: -- Standard call to get message count and if count is 1, get message info.
978: fnd_msg_pub.count_and_get (p_count => x_msg_count,
979: p_data => x_msg_data,
980: p_encoded => fnd_api.g_false
981: );
982: EXCEPTION
983: WHEN fnd_api.g_exc_error
984: THEN

Line 983: WHEN fnd_api.g_exc_error

979: p_data => x_msg_data,
980: p_encoded => fnd_api.g_false
981: );
982: EXCEPTION
983: WHEN fnd_api.g_exc_error
984: THEN
985: ROLLBACK TO get_quota_assign;
986: x_return_status := fnd_api.g_ret_sts_error;
987: fnd_msg_pub.count_and_get (p_count => x_msg_count,

Line 986: x_return_status := fnd_api.g_ret_sts_error;

982: EXCEPTION
983: WHEN fnd_api.g_exc_error
984: THEN
985: ROLLBACK TO get_quota_assign;
986: x_return_status := fnd_api.g_ret_sts_error;
987: fnd_msg_pub.count_and_get (p_count => x_msg_count,
988: p_data => x_msg_data,
989: p_encoded => fnd_api.g_false
990: );

Line 989: p_encoded => fnd_api.g_false

985: ROLLBACK TO get_quota_assign;
986: x_return_status := fnd_api.g_ret_sts_error;
987: fnd_msg_pub.count_and_get (p_count => x_msg_count,
988: p_data => x_msg_data,
989: p_encoded => fnd_api.g_false
990: );
991: WHEN fnd_api.g_exc_unexpected_error
992: THEN
993: ROLLBACK TO get_quota_assign;

Line 991: WHEN fnd_api.g_exc_unexpected_error

987: fnd_msg_pub.count_and_get (p_count => x_msg_count,
988: p_data => x_msg_data,
989: p_encoded => fnd_api.g_false
990: );
991: WHEN fnd_api.g_exc_unexpected_error
992: THEN
993: ROLLBACK TO get_quota_assign;
994: x_return_status := fnd_api.g_ret_sts_unexp_error;
995: fnd_msg_pub.count_and_get (p_count => x_msg_count,

Line 994: x_return_status := fnd_api.g_ret_sts_unexp_error;

990: );
991: WHEN fnd_api.g_exc_unexpected_error
992: THEN
993: ROLLBACK TO get_quota_assign;
994: x_return_status := fnd_api.g_ret_sts_unexp_error;
995: fnd_msg_pub.count_and_get (p_count => x_msg_count,
996: p_data => x_msg_data,
997: p_encoded => fnd_api.g_false
998: );

Line 997: p_encoded => fnd_api.g_false

993: ROLLBACK TO get_quota_assign;
994: x_return_status := fnd_api.g_ret_sts_unexp_error;
995: fnd_msg_pub.count_and_get (p_count => x_msg_count,
996: p_data => x_msg_data,
997: p_encoded => fnd_api.g_false
998: );
999: WHEN OTHERS
1000: THEN
1001: ROLLBACK TO get_quota_assign;

Line 1002: x_return_status := fnd_api.g_ret_sts_unexp_error;

998: );
999: WHEN OTHERS
1000: THEN
1001: ROLLBACK TO get_quota_assign;
1002: x_return_status := fnd_api.g_ret_sts_unexp_error;
1003:
1004: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1005: THEN
1006: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

Line 1011: p_encoded => fnd_api.g_false

1007: END IF;
1008:
1009: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1010: p_data => x_msg_data,
1011: p_encoded => fnd_api.g_false
1012: );
1013: END get_quota_assign;
1014: END cn_quota_assign_pvt;