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

Line 43: x_return_status := fnd_api.g_ret_sts_success;

39: l_quota_type_code cn_quotas.quota_type_code%TYPE;
40: l_org_id NUMBER;
41: BEGIN
42: -- Initialize API return status to success
43: x_return_status := fnd_api.g_ret_sts_success;
44: x_loading_status := p_loading_status;
45:
46: -- API body
47: -- check for required data for Period_quotas

Line 54: ) = fnd_api.g_true

50: p_para_name => cn_chk_plan_element_pkg.g_pe_name,
51: p_loading_status => x_loading_status,
52: x_loading_status => l_loading_status
53: )
54: ) = fnd_api.g_true
55: )
56: THEN
57: RAISE fnd_api.g_exc_error;
58: ELSIF ((cn_api.chk_null_char_para (p_char_para => p_quota_name,

Line 57: RAISE fnd_api.g_exc_error;

53: )
54: ) = fnd_api.g_true
55: )
56: THEN
57: RAISE fnd_api.g_exc_error;
58: ELSIF ((cn_api.chk_null_char_para (p_char_para => p_quota_name,
59: p_obj_name => cn_chk_plan_element_pkg.g_pe_name,
60: p_loading_status => x_loading_status,
61: x_loading_status => l_loading_status

Line 63: ) = fnd_api.g_true

59: p_obj_name => cn_chk_plan_element_pkg.g_pe_name,
60: p_loading_status => x_loading_status,
61: x_loading_status => l_loading_status
62: )
63: ) = fnd_api.g_true
64: )
65: THEN
66: RAISE fnd_api.g_exc_error;
67: END IF;

Line 66: RAISE fnd_api.g_exc_error;

62: )
63: ) = fnd_api.g_true
64: )
65: THEN
66: RAISE fnd_api.g_exc_error;
67: END IF;
68:
69: --+
70: -- Check Period name is not miss, not null

Line 77: ) = fnd_api.g_true

73: p_para_name => 'Period Name',
74: p_loading_status => x_loading_status,
75: x_loading_status => l_loading_status
76: )
77: ) = fnd_api.g_true
78: )
79: THEN
80: RAISE fnd_api.g_exc_error;
81: ELSIF ((cn_api.chk_null_char_para (p_char_para => p_period_quotas_rec.period_name,

Line 80: RAISE fnd_api.g_exc_error;

76: )
77: ) = fnd_api.g_true
78: )
79: THEN
80: RAISE fnd_api.g_exc_error;
81: ELSIF ((cn_api.chk_null_char_para (p_char_para => p_period_quotas_rec.period_name,
82: p_obj_name => 'Period Name',
83: p_loading_status => x_loading_status,
84: x_loading_status => l_loading_status

Line 86: ) = fnd_api.g_true

82: p_obj_name => 'Period Name',
83: p_loading_status => x_loading_status,
84: x_loading_status => l_loading_status
85: )
86: ) = fnd_api.g_true
87: )
88: THEN
89: RAISE fnd_api.g_exc_error;
90: END IF;

Line 89: RAISE fnd_api.g_exc_error;

85: )
86: ) = fnd_api.g_true
87: )
88: THEN
89: RAISE fnd_api.g_exc_error;
90: END IF;
91:
92:
93: l_org_id := p_period_quotas_rec.org_id ;

Line 131: RAISE fnd_api.g_exc_error;

127: fnd_msg_pub.ADD;
128: END IF;
129:
130: x_loading_status := 'CN_PLN_NOT_EXIST';
131: RAISE fnd_api.g_exc_error;
132: END IF;
133:
134: --+
135: -- Check Formula is Assiged to the Quota

Line 149: RAISE fnd_api.g_exc_error;

145: fnd_msg_pub.ADD;
146: END IF;
147:
148: x_loading_status := 'QUOTA_FORMULA_NOT_EXIST';
149: RAISE fnd_api.g_exc_error;
150: END IF;
151:
152: -- Disable this checking since we can have period quotas for BOTH ITD
153: -- AND NON-ITD FORMULA, bug 2422752

Line 166: RAISE FND_API.G_EXC_ERROR ;

162: FND_MESSAGE.SET_TOKEN('PE_NAME',p_quota_name );
163: FND_MSG_PUB.Add;
164: END IF;
165: x_loading_status := 'QUOTA_CANNOT_HAVE_PERIODS';
166: RAISE FND_API.G_EXC_ERROR ;
167: END IF;*/
168:
169: --+
170: -- get period id

Line 187: RAISE fnd_api.g_exc_error;

183: fnd_msg_pub.ADD;
184: END IF;
185:
186: x_loading_status := 'CN_PERIOD_NOT_EXIST';
187: RAISE fnd_api.g_exc_error;
188: END IF;
189:
190: --+
191: -- Check period start date and end date is falling with the quota

Line 212: RAISE fnd_api.g_exc_error;

208: fnd_msg_pub.ADD;
209: END IF;
210:
211: x_loading_status := 'CN_PRD_DT_NOT_WIN_QUOTA_DT';
212: RAISE fnd_api.g_exc_error;
213: END IF;
214: EXCEPTION
215: WHEN NO_DATA_FOUND
216: THEN

Line 246: WHEN fnd_api.g_exc_error

242: x_loading_status := 'PERIOD_QUOTA_EXISTS';
243: END IF;
244: END IF;
245: EXCEPTION
246: WHEN fnd_api.g_exc_error
247: THEN
248: x_return_status := fnd_api.g_ret_sts_error;
249: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
250: WHEN fnd_api.g_exc_unexpected_error

Line 248: x_return_status := fnd_api.g_ret_sts_error;

244: END IF;
245: EXCEPTION
246: WHEN fnd_api.g_exc_error
247: THEN
248: x_return_status := fnd_api.g_ret_sts_error;
249: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
250: WHEN fnd_api.g_exc_unexpected_error
251: THEN
252: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 249: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

245: EXCEPTION
246: WHEN fnd_api.g_exc_error
247: THEN
248: x_return_status := fnd_api.g_ret_sts_error;
249: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
250: WHEN fnd_api.g_exc_unexpected_error
251: THEN
252: x_return_status := fnd_api.g_ret_sts_unexp_error;
253: x_loading_status := 'UNEXPECTED_ERR';

Line 250: WHEN fnd_api.g_exc_unexpected_error

246: WHEN fnd_api.g_exc_error
247: THEN
248: x_return_status := fnd_api.g_ret_sts_error;
249: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
250: WHEN fnd_api.g_exc_unexpected_error
251: THEN
252: x_return_status := fnd_api.g_ret_sts_unexp_error;
253: x_loading_status := 'UNEXPECTED_ERR';
254: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

Line 252: x_return_status := fnd_api.g_ret_sts_unexp_error;

248: x_return_status := fnd_api.g_ret_sts_error;
249: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
250: WHEN fnd_api.g_exc_unexpected_error
251: THEN
252: x_return_status := fnd_api.g_ret_sts_unexp_error;
253: x_loading_status := 'UNEXPECTED_ERR';
254: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
255: WHEN OTHERS
256: THEN

Line 254: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

250: WHEN fnd_api.g_exc_unexpected_error
251: THEN
252: x_return_status := fnd_api.g_ret_sts_unexp_error;
253: x_loading_status := 'UNEXPECTED_ERR';
254: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
255: WHEN OTHERS
256: THEN
257: x_return_status := fnd_api.g_ret_sts_unexp_error;
258: x_loading_status := 'UNEXPECTED_ERR';

Line 257: x_return_status := fnd_api.g_ret_sts_unexp_error;

253: x_loading_status := 'UNEXPECTED_ERR';
254: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
255: WHEN OTHERS
256: THEN
257: x_return_status := fnd_api.g_ret_sts_unexp_error;
258: x_loading_status := 'UNEXPECTED_ERR';
259:
260: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
261: THEN

Line 265: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

261: THEN
262: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
263: END IF;
264:
265: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
266: END valid_period_quotas;
267:
268: -- ----------------------------------------------------------------------------+
269: -- Procedure: Check Valid Update

Line 294: x_return_status := fnd_api.g_ret_sts_success;

290: l_meaning cn_lookups.meaning%TYPE;
291: l_loading_status VARCHAR2 (80);
292: BEGIN
293: -- Initialize API return status to success
294: x_return_status := fnd_api.g_ret_sts_success;
295: x_loading_status := p_loading_status;
296:
297: --+
298: -- Check quota name is not null

Line 305: ) = fnd_api.g_true

301: p_para_name => cn_chk_plan_element_pkg.g_pe_name,
302: p_loading_status => x_loading_status,
303: x_loading_status => l_loading_status
304: )
305: ) = fnd_api.g_true
306: )
307: THEN
308: RAISE fnd_api.g_exc_error;
309: ELSIF ((cn_api.chk_null_char_para (p_char_para => p_quota_name,

Line 308: RAISE fnd_api.g_exc_error;

304: )
305: ) = fnd_api.g_true
306: )
307: THEN
308: RAISE fnd_api.g_exc_error;
309: ELSIF ((cn_api.chk_null_char_para (p_char_para => p_quota_name,
310: p_obj_name => cn_chk_plan_element_pkg.g_pe_name,
311: p_loading_status => x_loading_status,
312: x_loading_status => l_loading_status

Line 314: ) = fnd_api.g_true

310: p_obj_name => cn_chk_plan_element_pkg.g_pe_name,
311: p_loading_status => x_loading_status,
312: x_loading_status => l_loading_status
313: )
314: ) = fnd_api.g_true
315: )
316: THEN
317: RAISE fnd_api.g_exc_error;
318: END IF;

Line 317: RAISE fnd_api.g_exc_error;

313: )
314: ) = fnd_api.g_true
315: )
316: THEN
317: RAISE fnd_api.g_exc_error;
318: END IF;
319:
320: --+
321: -- Get old Quota id

Line 338: RAISE fnd_api.g_exc_error;

334: fnd_msg_pub.ADD;
335: END IF;
336:
337: x_loading_status := 'CN_PLN_NOT_EXIST';
338: RAISE fnd_api.g_exc_error;
339: END IF;
340:
341: -- +
342: -- Check period name is not null or missing

Line 349: ) = fnd_api.g_true

345: p_para_name => 'Period Name',
346: p_loading_status => x_loading_status,
347: x_loading_status => l_loading_status
348: )
349: ) = fnd_api.g_true
350: )
351: THEN
352: RAISE fnd_api.g_exc_error;
353: ELSIF ((cn_api.chk_null_char_para (p_char_para => p_period_quotas_rec.period_name_old,

Line 352: RAISE fnd_api.g_exc_error;

348: )
349: ) = fnd_api.g_true
350: )
351: THEN
352: RAISE fnd_api.g_exc_error;
353: ELSIF ((cn_api.chk_null_char_para (p_char_para => p_period_quotas_rec.period_name_old,
354: p_obj_name => 'Period Name',
355: p_loading_status => x_loading_status,
356: x_loading_status => l_loading_status

Line 358: ) = fnd_api.g_true

354: p_obj_name => 'Period Name',
355: p_loading_status => x_loading_status,
356: x_loading_status => l_loading_status
357: )
358: ) = fnd_api.g_true
359: )
360: THEN
361: RAISE fnd_api.g_exc_error;
362: END IF;

Line 361: RAISE fnd_api.g_exc_error;

357: )
358: ) = fnd_api.g_true
359: )
360: THEN
361: RAISE fnd_api.g_exc_error;
362: END IF;
363:
364: --+
365: -- get period id

Line 382: RAISE fnd_api.g_exc_error;

378: fnd_msg_pub.ADD;
379: END IF;
380:
381: x_loading_status := 'CN_PERIOD_NOT_EXIST';
382: RAISE fnd_api.g_exc_error;
383: END IF;
384:
385: --+
386: -- Get quota period id to update the record

Line 413: RAISE fnd_api.g_exc_error;

409: fnd_msg_pub.ADD;
410: END IF;
411:
412: x_loading_status := 'CN_PERIOD_QUOTA_NOT_EXIST';
413: RAISE fnd_api.g_exc_error;
414: END IF;
415:
416: --+
417: -- Assign it to the out variable.

Line 440: RAISE fnd_api.g_exc_error;

436: fnd_msg_pub.ADD;
437: END IF;
438:
439: x_loading_status := 'CN_PERIOD_NOT_CONSISTENT';
440: RAISE fnd_api.g_exc_error;
441: END IF;
442:
443: --+
444: -- Validate the period quotas

Line 460: IF (x_return_status <> fnd_api.g_ret_sts_success)

456: ); -- Default Validations
457: x_loading_status := l_loading_status;
458:
459: -- Raise an error if the status is not success
460: IF (x_return_status <> fnd_api.g_ret_sts_success)
461: THEN
462: RAISE fnd_api.g_exc_error;
463: END IF;
464:

Line 462: RAISE fnd_api.g_exc_error;

458:
459: -- Raise an error if the status is not success
460: IF (x_return_status <> fnd_api.g_ret_sts_success)
461: THEN
462: RAISE fnd_api.g_exc_error;
463: END IF;
464:
465: -- End of API body.
466: -- Standard call to get message count and if count is 1, get message info.

Line 467: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

463: END IF;
464:
465: -- End of API body.
466: -- Standard call to get message count and if count is 1, get message info.
467: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
468: EXCEPTION
469: WHEN fnd_api.g_exc_error
470: THEN
471: x_return_status := fnd_api.g_ret_sts_error;

Line 469: WHEN fnd_api.g_exc_error

465: -- End of API body.
466: -- Standard call to get message count and if count is 1, get message info.
467: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
468: EXCEPTION
469: WHEN fnd_api.g_exc_error
470: THEN
471: x_return_status := fnd_api.g_ret_sts_error;
472: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
473: WHEN fnd_api.g_exc_unexpected_error

Line 471: x_return_status := fnd_api.g_ret_sts_error;

467: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
468: EXCEPTION
469: WHEN fnd_api.g_exc_error
470: THEN
471: x_return_status := fnd_api.g_ret_sts_error;
472: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
473: WHEN fnd_api.g_exc_unexpected_error
474: THEN
475: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 472: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

468: EXCEPTION
469: WHEN fnd_api.g_exc_error
470: THEN
471: x_return_status := fnd_api.g_ret_sts_error;
472: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
473: WHEN fnd_api.g_exc_unexpected_error
474: THEN
475: x_return_status := fnd_api.g_ret_sts_unexp_error;
476: x_loading_status := 'UNEXPECTED_ERR';

Line 473: WHEN fnd_api.g_exc_unexpected_error

469: WHEN fnd_api.g_exc_error
470: THEN
471: x_return_status := fnd_api.g_ret_sts_error;
472: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
473: WHEN fnd_api.g_exc_unexpected_error
474: THEN
475: x_return_status := fnd_api.g_ret_sts_unexp_error;
476: x_loading_status := 'UNEXPECTED_ERR';
477: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

Line 475: x_return_status := fnd_api.g_ret_sts_unexp_error;

471: x_return_status := fnd_api.g_ret_sts_error;
472: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
473: WHEN fnd_api.g_exc_unexpected_error
474: THEN
475: x_return_status := fnd_api.g_ret_sts_unexp_error;
476: x_loading_status := 'UNEXPECTED_ERR';
477: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
478: WHEN OTHERS
479: THEN

Line 477: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

473: WHEN fnd_api.g_exc_unexpected_error
474: THEN
475: x_return_status := fnd_api.g_ret_sts_unexp_error;
476: x_loading_status := 'UNEXPECTED_ERR';
477: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
478: WHEN OTHERS
479: THEN
480: x_return_status := fnd_api.g_ret_sts_unexp_error;
481: x_loading_status := 'UNEXPECTED_ERR';

Line 480: x_return_status := fnd_api.g_ret_sts_unexp_error;

476: x_loading_status := 'UNEXPECTED_ERR';
477: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
478: WHEN OTHERS
479: THEN
480: x_return_status := fnd_api.g_ret_sts_unexp_error;
481: x_loading_status := 'UNEXPECTED_ERR';
482:
483: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
484: THEN

Line 488: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

484: THEN
485: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
486: END IF;
487:
488: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
489: END check_valid_update;
490:
491: --|-----------------------------------------------------------------------+
492: --| Procedure Name: Create_Period_Quotas

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

493: --| Descr: Create a Period Quotas
494: --|-----------------------------------------------------------------------+
495: PROCEDURE create_period_quotas (
496: p_api_version IN NUMBER,
497: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
498: p_commit IN VARCHAR2 := fnd_api.g_false,
499: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
500: x_return_status OUT NOCOPY VARCHAR2,
501: x_msg_count OUT NOCOPY NUMBER,

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

494: --|-----------------------------------------------------------------------+
495: PROCEDURE create_period_quotas (
496: p_api_version IN NUMBER,
497: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
498: p_commit IN VARCHAR2 := fnd_api.g_false,
499: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
500: x_return_status OUT NOCOPY VARCHAR2,
501: x_msg_count OUT NOCOPY NUMBER,
502: x_msg_data OUT NOCOPY VARCHAR2,

Line 499: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

495: PROCEDURE create_period_quotas (
496: p_api_version IN NUMBER,
497: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
498: p_commit IN VARCHAR2 := fnd_api.g_false,
499: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
500: x_return_status OUT NOCOPY VARCHAR2,
501: x_msg_count OUT NOCOPY NUMBER,
502: x_msg_data OUT NOCOPY VARCHAR2,
503: p_quota_name IN VARCHAR2,

Line 525: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)

521:
522: --+
523: -- Standard call to check for call compatibility.
524: --+
525: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
526: THEN
527: RAISE fnd_api.g_exc_unexpected_error;
528: END IF;
529:

Line 527: RAISE fnd_api.g_exc_unexpected_error;

523: -- Standard call to check for call compatibility.
524: --+
525: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
526: THEN
527: RAISE fnd_api.g_exc_unexpected_error;
528: END IF;
529:
530: --+
531: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 533: IF fnd_api.to_boolean (p_init_msg_list)

529:
530: --+
531: -- Initialize message list if p_init_msg_list is set to TRUE.
532: -- +
533: IF fnd_api.to_boolean (p_init_msg_list)
534: THEN
535: fnd_msg_pub.initialize;
536: END IF;
537:

Line 541: x_return_status := fnd_api.g_ret_sts_success;

537:
538: -- +
539: -- Initialize API return status to success
540: --+
541: x_return_status := fnd_api.g_ret_sts_success;
542: x_loading_status := 'CN_INSERTED';
543:
544: -- +
545: -- API body

Line 572: IF (x_return_status <> fnd_api.g_ret_sts_success)

568:
569: --+
570: -- Raise an error if the return status is not success
571: --+
572: IF (x_return_status <> fnd_api.g_ret_sts_success)
573: THEN
574: RAISE fnd_api.g_exc_error;
575: ELSIF (x_return_status = fnd_api.g_ret_sts_success) AND (x_loading_status = 'CN_INSERTED')
576: THEN

Line 574: RAISE fnd_api.g_exc_error;

570: -- Raise an error if the return status is not success
571: --+
572: IF (x_return_status <> fnd_api.g_ret_sts_success)
573: THEN
574: RAISE fnd_api.g_exc_error;
575: ELSIF (x_return_status = fnd_api.g_ret_sts_success) AND (x_loading_status = 'CN_INSERTED')
576: THEN
577: cn_period_quotas_pkg.begin_record (x_operation => 'INSERT',
578: x_period_quota_id => l_period_quota_id,

Line 575: ELSIF (x_return_status = fnd_api.g_ret_sts_success) AND (x_loading_status = 'CN_INSERTED')

571: --+
572: IF (x_return_status <> fnd_api.g_ret_sts_success)
573: THEN
574: RAISE fnd_api.g_exc_error;
575: ELSIF (x_return_status = fnd_api.g_ret_sts_success) AND (x_loading_status = 'CN_INSERTED')
576: THEN
577: cn_period_quotas_pkg.begin_record (x_operation => 'INSERT',
578: x_period_quota_id => l_period_quota_id,
579: x_period_id => l_period_id,

Line 608: IF fnd_api.to_boolean (p_commit)

604: --+
605: -- End of API body.
606: -- Standard check of p_commit.
607: --+
608: IF fnd_api.to_boolean (p_commit)
609: THEN
610: COMMIT WORK;
611: END IF;
612:

Line 616: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

612:
613: --+
614: -- Standard call to get message count and if count is 1, get message info.
615: --+
616: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
617: EXCEPTION
618: WHEN fnd_api.g_exc_error
619: THEN
620: ROLLBACK TO create_period_quotas;

Line 618: WHEN fnd_api.g_exc_error

614: -- Standard call to get message count and if count is 1, get message info.
615: --+
616: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
617: EXCEPTION
618: WHEN fnd_api.g_exc_error
619: THEN
620: ROLLBACK TO create_period_quotas;
621: x_return_status := fnd_api.g_ret_sts_error;
622: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

Line 621: x_return_status := fnd_api.g_ret_sts_error;

617: EXCEPTION
618: WHEN fnd_api.g_exc_error
619: THEN
620: ROLLBACK TO create_period_quotas;
621: x_return_status := fnd_api.g_ret_sts_error;
622: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
623: WHEN fnd_api.g_exc_unexpected_error
624: THEN
625: ROLLBACK TO create_period_quotas;

Line 622: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

618: WHEN fnd_api.g_exc_error
619: THEN
620: ROLLBACK TO create_period_quotas;
621: x_return_status := fnd_api.g_ret_sts_error;
622: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
623: WHEN fnd_api.g_exc_unexpected_error
624: THEN
625: ROLLBACK TO create_period_quotas;
626: x_loading_status := 'UNEXPECTED_ERR';

Line 623: WHEN fnd_api.g_exc_unexpected_error

619: THEN
620: ROLLBACK TO create_period_quotas;
621: x_return_status := fnd_api.g_ret_sts_error;
622: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
623: WHEN fnd_api.g_exc_unexpected_error
624: THEN
625: ROLLBACK TO create_period_quotas;
626: x_loading_status := 'UNEXPECTED_ERR';
627: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 627: x_return_status := fnd_api.g_ret_sts_unexp_error;

623: WHEN fnd_api.g_exc_unexpected_error
624: THEN
625: ROLLBACK TO create_period_quotas;
626: x_loading_status := 'UNEXPECTED_ERR';
627: x_return_status := fnd_api.g_ret_sts_unexp_error;
628: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
629: WHEN OTHERS
630: THEN
631: ROLLBACK TO create_period_quotas;

Line 628: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

624: THEN
625: ROLLBACK TO create_period_quotas;
626: x_loading_status := 'UNEXPECTED_ERR';
627: x_return_status := fnd_api.g_ret_sts_unexp_error;
628: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
629: WHEN OTHERS
630: THEN
631: ROLLBACK TO create_period_quotas;
632: x_loading_status := 'UNEXPECTED_ERR';

Line 633: x_return_status := fnd_api.g_ret_sts_unexp_error;

629: WHEN OTHERS
630: THEN
631: ROLLBACK TO create_period_quotas;
632: x_loading_status := 'UNEXPECTED_ERR';
633: x_return_status := fnd_api.g_ret_sts_unexp_error;
634:
635: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
636: THEN
637: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

Line 640: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

636: THEN
637: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
638: END IF;
639:
640: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
641: END create_period_quotas;
642:
643: --|-----------------------------------------------------------------------+
644: --| Procedure Name: Update_Period_Quotas

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

645: --| Descr: Update a Period Quotas
646: --|----------------------------------------------------------------------- +
647: PROCEDURE update_period_quotas (
648: p_api_version IN NUMBER,
649: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
650: p_commit IN VARCHAR2 := fnd_api.g_false,
651: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
652: x_return_status OUT NOCOPY VARCHAR2,
653: x_msg_count OUT NOCOPY NUMBER,

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

646: --|----------------------------------------------------------------------- +
647: PROCEDURE update_period_quotas (
648: p_api_version IN NUMBER,
649: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
650: p_commit IN VARCHAR2 := fnd_api.g_false,
651: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
652: x_return_status OUT NOCOPY VARCHAR2,
653: x_msg_count OUT NOCOPY NUMBER,
654: x_msg_data OUT NOCOPY VARCHAR2,

Line 651: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

647: PROCEDURE update_period_quotas (
648: p_api_version IN NUMBER,
649: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
650: p_commit IN VARCHAR2 := fnd_api.g_false,
651: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
652: x_return_status OUT NOCOPY VARCHAR2,
653: x_msg_count OUT NOCOPY NUMBER,
654: x_msg_data OUT NOCOPY VARCHAR2,
655: p_quota_name IN VARCHAR2,

Line 676: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)

672:
673: --+
674: -- Standard call to check for call compatibility.
675: --+
676: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
677: THEN
678: RAISE fnd_api.g_exc_unexpected_error;
679: END IF;
680:

Line 678: RAISE fnd_api.g_exc_unexpected_error;

674: -- Standard call to check for call compatibility.
675: --+
676: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
677: THEN
678: RAISE fnd_api.g_exc_unexpected_error;
679: END IF;
680:
681: --+
682: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 684: IF fnd_api.to_boolean (p_init_msg_list)

680:
681: --+
682: -- Initialize message list if p_init_msg_list is set to TRUE.
683: -- +
684: IF fnd_api.to_boolean (p_init_msg_list)
685: THEN
686: fnd_msg_pub.initialize;
687: END IF;
688:

Line 692: x_return_status := fnd_api.g_ret_sts_success;

688:
689: -- +
690: -- Initialize API return status to success
691: --+
692: x_return_status := fnd_api.g_ret_sts_success;
693: x_loading_status := 'CN_UPDATED';
694:
695: -- +
696: -- API body

Line 717: IF (x_return_status <> fnd_api.g_ret_sts_success)

713: x_loading_status => l_loading_status
714: );
715: x_loading_status := l_loading_status;
716:
717: IF (x_return_status <> fnd_api.g_ret_sts_success)
718: THEN
719: RAISE fnd_api.g_exc_error;
720: ELSIF (x_return_status = fnd_api.g_ret_sts_success) AND (x_loading_status = 'CN_UPDATED')
721: THEN

Line 719: RAISE fnd_api.g_exc_error;

715: x_loading_status := l_loading_status;
716:
717: IF (x_return_status <> fnd_api.g_ret_sts_success)
718: THEN
719: RAISE fnd_api.g_exc_error;
720: ELSIF (x_return_status = fnd_api.g_ret_sts_success) AND (x_loading_status = 'CN_UPDATED')
721: THEN
722: cn_period_quotas_pkg.begin_record (x_operation => 'UPDATE',
723: x_period_quota_id => l_period_quota_id,

Line 720: ELSIF (x_return_status = fnd_api.g_ret_sts_success) AND (x_loading_status = 'CN_UPDATED')

716:
717: IF (x_return_status <> fnd_api.g_ret_sts_success)
718: THEN
719: RAISE fnd_api.g_exc_error;
720: ELSIF (x_return_status = fnd_api.g_ret_sts_success) AND (x_loading_status = 'CN_UPDATED')
721: THEN
722: cn_period_quotas_pkg.begin_record (x_operation => 'UPDATE',
723: x_period_quota_id => l_period_quota_id,
724: x_period_id => l_period_id,

Line 748: IF fnd_api.to_boolean (p_commit)

744: --+
745: -- End of API body.
746: -- Standard check of p_commit.
747: --+
748: IF fnd_api.to_boolean (p_commit)
749: THEN
750: COMMIT WORK;
751: END IF;
752:

Line 756: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

752:
753: --+
754: -- Standard call to get message count and if count is 1, get message info.
755: --+
756: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
757: EXCEPTION
758: WHEN fnd_api.g_exc_error
759: THEN
760: ROLLBACK TO update_plan_element;

Line 758: WHEN fnd_api.g_exc_error

754: -- Standard call to get message count and if count is 1, get message info.
755: --+
756: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
757: EXCEPTION
758: WHEN fnd_api.g_exc_error
759: THEN
760: ROLLBACK TO update_plan_element;
761: x_return_status := fnd_api.g_ret_sts_error;
762: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

Line 761: x_return_status := fnd_api.g_ret_sts_error;

757: EXCEPTION
758: WHEN fnd_api.g_exc_error
759: THEN
760: ROLLBACK TO update_plan_element;
761: x_return_status := fnd_api.g_ret_sts_error;
762: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
763: WHEN fnd_api.g_exc_unexpected_error
764: THEN
765: ROLLBACK TO update_plan_element;

Line 762: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

758: WHEN fnd_api.g_exc_error
759: THEN
760: ROLLBACK TO update_plan_element;
761: x_return_status := fnd_api.g_ret_sts_error;
762: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
763: WHEN fnd_api.g_exc_unexpected_error
764: THEN
765: ROLLBACK TO update_plan_element;
766: x_loading_status := 'UNEXPECTED_ERR';

Line 763: WHEN fnd_api.g_exc_unexpected_error

759: THEN
760: ROLLBACK TO update_plan_element;
761: x_return_status := fnd_api.g_ret_sts_error;
762: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
763: WHEN fnd_api.g_exc_unexpected_error
764: THEN
765: ROLLBACK TO update_plan_element;
766: x_loading_status := 'UNEXPECTED_ERR';
767: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 767: x_return_status := fnd_api.g_ret_sts_unexp_error;

763: WHEN fnd_api.g_exc_unexpected_error
764: THEN
765: ROLLBACK TO update_plan_element;
766: x_loading_status := 'UNEXPECTED_ERR';
767: x_return_status := fnd_api.g_ret_sts_unexp_error;
768: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
769: WHEN OTHERS
770: THEN
771: ROLLBACK TO update_plan_element;

Line 768: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

764: THEN
765: ROLLBACK TO update_plan_element;
766: x_loading_status := 'UNEXPECTED_ERR';
767: x_return_status := fnd_api.g_ret_sts_unexp_error;
768: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
769: WHEN OTHERS
770: THEN
771: ROLLBACK TO update_plan_element;
772: x_loading_status := 'UNEXPECTED_ERR';

Line 773: x_return_status := fnd_api.g_ret_sts_unexp_error;

769: WHEN OTHERS
770: THEN
771: ROLLBACK TO update_plan_element;
772: x_loading_status := 'UNEXPECTED_ERR';
773: x_return_status := fnd_api.g_ret_sts_unexp_error;
774:
775: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
776: THEN
777: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

Line 780: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

776: THEN
777: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
778: END IF;
779:
780: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
781: END update_period_quotas;
782: END cn_period_quotas_grp;