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

Line 34: l_init_msg_list VARCHAR2(10) := FND_API.G_FALSE;

30: l_api_name CONSTANT VARCHAR2(30) := 'invoke_object';
31: x_msg_count NUMBER;
32: x_msg_data VARCHAR2(240);
33: x_return_status VARCHAR2(1) ;
34: l_init_msg_list VARCHAR2(10) := FND_API.G_FALSE;
35: l_min_date DATE;
36: l_max_date DATE;
37: p_end_date DATE := FND_DATE.CANONICAL_TO_DATE(p_end_dt);
38:

Line 316: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

312: BEGIN
313:
314:
315: -- Standard call to check for call compatibility.
316: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
317: p_api_version_number,
318: l_api_name,
319: g_pkg_name)
320: THEN

Line 321: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

317: p_api_version_number,
318: l_api_name,
319: g_pkg_name)
320: THEN
321: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
322: END IF;
323:
324:
325: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 333: x_return_status := FND_API.G_RET_STS_SUCCESS;

329: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
330:
331:
332: -- Initialize API return status to SUCCESS
333: x_return_status := FND_API.G_RET_STS_SUCCESS;
334: OPEN min_log_date;
335: FETCH min_log_date into l_min_date;
336: CLOSE min_log_date;
337:

Line 354: RAISE FND_API.G_EXC_ERROR;

350: END;
351: ELSIF p_full_refresh = 'Y' AND l_min_date is NULL THEN
352: ams_utility_pvt.write_conc_log('First Time Load is not run. Please run the Initial Load.');
353: ams_utility_pvt.write_conc_log('Concurrent Program Exits Now');
354: RAISE FND_API.G_EXC_ERROR;
355: ELSE
356: BEGIN
357: OPEN max_log_date;
358: FETCH max_log_date into l_max_date;

Line 375: ,p_init_msg_list => FND_API.G_FALSE

371: IF p_object = 'CAMPAIGN' THEN
372:
373: bim_campaign_facts.populate
374: (p_api_version_number => 1.0
375: ,p_init_msg_list => FND_API.G_FALSE
376: ,x_msg_count => x_msg_count
377: ,x_msg_data => x_msg_data
378: ,x_return_status => x_return_status
379: ,p_object => p_object

Line 384: IF x_return_status = FND_API.g_ret_sts_error

380: ,p_start_date => NULL
381: ,p_end_date => p_end_date
382: ,p_para_num => p_proc_num
383: );
384: IF x_return_status = FND_API.g_ret_sts_error
385: THEN
386: RAISE FND_API.g_exc_error;
387: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
388: RAISE FND_API.g_exc_unexpected_error;

Line 386: RAISE FND_API.g_exc_error;

382: ,p_para_num => p_proc_num
383: );
384: IF x_return_status = FND_API.g_ret_sts_error
385: THEN
386: RAISE FND_API.g_exc_error;
387: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
388: RAISE FND_API.g_exc_unexpected_error;
389: END IF;
390:

Line 387: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN

383: );
384: IF x_return_status = FND_API.g_ret_sts_error
385: THEN
386: RAISE FND_API.g_exc_error;
387: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
388: RAISE FND_API.g_exc_unexpected_error;
389: END IF;
390:
391:

Line 388: RAISE FND_API.g_exc_unexpected_error;

384: IF x_return_status = FND_API.g_ret_sts_error
385: THEN
386: RAISE FND_API.g_exc_error;
387: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
388: RAISE FND_API.g_exc_unexpected_error;
389: END IF;
390:
391:
392: ELSIF

Line 398: p_init_msg_list => FND_API.G_FALSE,

394:
395:
396: bim_event_facts.POPULATE (
397: p_api_version_number => 1.0,
398: p_init_msg_list => FND_API.G_FALSE,
399: x_msg_count => x_msg_count ,
400: x_msg_data => x_msg_data ,
401: x_return_status => x_return_status ,
402: p_object => 'EVENT',

Line 407: IF x_return_status = FND_API.g_ret_sts_error

403: p_start_date => NULL,
404: p_end_date => p_end_date,
405: p_para_num => p_proc_num
406: );
407: IF x_return_status = FND_API.g_ret_sts_error
408: THEN
409: RAISE FND_API.g_exc_error;
410: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
411: RAISE FND_API.g_exc_unexpected_error;

Line 409: RAISE FND_API.g_exc_error;

405: p_para_num => p_proc_num
406: );
407: IF x_return_status = FND_API.g_ret_sts_error
408: THEN
409: RAISE FND_API.g_exc_error;
410: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
411: RAISE FND_API.g_exc_unexpected_error;
412: END IF;
413:

Line 410: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN

406: );
407: IF x_return_status = FND_API.g_ret_sts_error
408: THEN
409: RAISE FND_API.g_exc_error;
410: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
411: RAISE FND_API.g_exc_unexpected_error;
412: END IF;
413:
414: ELSIF

Line 411: RAISE FND_API.g_exc_unexpected_error;

407: IF x_return_status = FND_API.g_ret_sts_error
408: THEN
409: RAISE FND_API.g_exc_error;
410: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
411: RAISE FND_API.g_exc_unexpected_error;
412: END IF;
413:
414: ELSIF
415: p_object = 'RESPONSE' THEN

Line 419: p_init_msg_list => FND_API.G_FALSE,

415: p_object = 'RESPONSE' THEN
416:
417: bim_response_facts_pkg.populate (
418: p_api_version_number => 1.0,
419: p_init_msg_list => FND_API.G_FALSE,
420: x_msg_count => x_msg_count ,
421: x_msg_data => x_msg_data ,
422: x_return_status => x_return_status ,
423: p_start_date => NULL,

Line 427: IF x_return_status = FND_API.g_ret_sts_error

423: p_start_date => NULL,
424: p_end_date => p_end_date,
425: p_para_num => p_proc_num
426: );
427: IF x_return_status = FND_API.g_ret_sts_error
428: THEN
429: RAISE FND_API.g_exc_error;
430: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
431: RAISE FND_API.g_exc_unexpected_error;

Line 429: RAISE FND_API.g_exc_error;

425: p_para_num => p_proc_num
426: );
427: IF x_return_status = FND_API.g_ret_sts_error
428: THEN
429: RAISE FND_API.g_exc_error;
430: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
431: RAISE FND_API.g_exc_unexpected_error;
432: END IF;
433: ELSIF

Line 430: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN

426: );
427: IF x_return_status = FND_API.g_ret_sts_error
428: THEN
429: RAISE FND_API.g_exc_error;
430: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
431: RAISE FND_API.g_exc_unexpected_error;
432: END IF;
433: ELSIF
434: p_object = 'LEAD_IMPORT' THEN

Line 431: RAISE FND_API.g_exc_unexpected_error;

427: IF x_return_status = FND_API.g_ret_sts_error
428: THEN
429: RAISE FND_API.g_exc_error;
430: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
431: RAISE FND_API.g_exc_unexpected_error;
432: END IF;
433: ELSIF
434: p_object = 'LEAD_IMPORT' THEN
435:

Line 438: p_init_msg_list => FND_API.G_FALSE,

434: p_object = 'LEAD_IMPORT' THEN
435:
436: bim_lead_import_facts_pkg.POPULATE (
437: p_api_version_number => 1.0,
438: p_init_msg_list => FND_API.G_FALSE,
439: x_msg_count => x_msg_count ,
440: x_msg_data => x_msg_data ,
441: x_return_status => x_return_status ,
442: p_object => 'EVENT',

Line 447: IF x_return_status = FND_API.g_ret_sts_error

443: p_start_date => NULL,
444: p_end_date => p_end_date,
445: p_para_num => p_proc_num
446: );
447: IF x_return_status = FND_API.g_ret_sts_error
448: THEN
449: RAISE FND_API.g_exc_error;
450: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
451: RAISE FND_API.g_exc_unexpected_error;

Line 449: RAISE FND_API.g_exc_error;

445: p_para_num => p_proc_num
446: );
447: IF x_return_status = FND_API.g_ret_sts_error
448: THEN
449: RAISE FND_API.g_exc_error;
450: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
451: RAISE FND_API.g_exc_unexpected_error;
452: END IF;
453: ELSIF

Line 450: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN

446: );
447: IF x_return_status = FND_API.g_ret_sts_error
448: THEN
449: RAISE FND_API.g_exc_error;
450: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
451: RAISE FND_API.g_exc_unexpected_error;
452: END IF;
453: ELSIF
454: p_object = 'LEADS' THEN

Line 451: RAISE FND_API.g_exc_unexpected_error;

447: IF x_return_status = FND_API.g_ret_sts_error
448: THEN
449: RAISE FND_API.g_exc_error;
450: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
451: RAISE FND_API.g_exc_unexpected_error;
452: END IF;
453: ELSIF
454: p_object = 'LEADS' THEN
455:

Line 458: p_init_msg_list => FND_API.G_FALSE,

454: p_object = 'LEADS' THEN
455:
456: bim_lead_facts_pkg.POPULATE (
457: p_api_version_number => 1.0,
458: p_init_msg_list => FND_API.G_FALSE,
459: x_msg_count => x_msg_count ,
460: x_msg_data => x_msg_data ,
461: x_return_status => x_return_status ,
462: p_object => p_object,

Line 467: IF x_return_status = FND_API.g_ret_sts_error

463: p_start_date => NULL,
464: p_end_date => p_end_date,
465: p_para_num => p_proc_num
466: );
467: IF x_return_status = FND_API.g_ret_sts_error
468: THEN
469: RAISE FND_API.g_exc_error;
470: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
471: RAISE FND_API.g_exc_unexpected_error;

Line 469: RAISE FND_API.g_exc_error;

465: p_para_num => p_proc_num
466: );
467: IF x_return_status = FND_API.g_ret_sts_error
468: THEN
469: RAISE FND_API.g_exc_error;
470: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
471: RAISE FND_API.g_exc_unexpected_error;
472: END IF;
473:

Line 470: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN

466: );
467: IF x_return_status = FND_API.g_ret_sts_error
468: THEN
469: RAISE FND_API.g_exc_error;
470: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
471: RAISE FND_API.g_exc_unexpected_error;
472: END IF;
473:
474:

Line 471: RAISE FND_API.g_exc_unexpected_error;

467: IF x_return_status = FND_API.g_ret_sts_error
468: THEN
469: RAISE FND_API.g_exc_error;
470: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
471: RAISE FND_API.g_exc_unexpected_error;
472: END IF;
473:
474:
475: ELSIF

Line 480: p_init_msg_list => FND_API.G_FALSE,

476: p_object = 'BUDGET'THEN
477:
478: bim_fund_facts.populate (
479: p_api_version_number => 1.0,
480: p_init_msg_list => FND_API.G_FALSE,
481: x_msg_count => x_msg_count ,
482: x_msg_data => x_msg_data ,
483: x_return_status => x_return_status ,
484: P_OBJECT => 'FUND',

Line 489: IF x_return_status = FND_API.g_ret_sts_error

485: p_start_date => NULL,
486: P_END_DATE => p_end_date,
487: p_para_num => p_proc_num
488: );
489: IF x_return_status = FND_API.g_ret_sts_error
490: THEN
491: RAISE FND_API.g_exc_error;
492: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
493: RAISE FND_API.g_exc_unexpected_error;

Line 491: RAISE FND_API.g_exc_error;

487: p_para_num => p_proc_num
488: );
489: IF x_return_status = FND_API.g_ret_sts_error
490: THEN
491: RAISE FND_API.g_exc_error;
492: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
493: RAISE FND_API.g_exc_unexpected_error;
494: END IF;
495:

Line 492: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN

488: );
489: IF x_return_status = FND_API.g_ret_sts_error
490: THEN
491: RAISE FND_API.g_exc_error;
492: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
493: RAISE FND_API.g_exc_unexpected_error;
494: END IF;
495:
496: ELSIF

Line 493: RAISE FND_API.g_exc_unexpected_error;

489: IF x_return_status = FND_API.g_ret_sts_error
490: THEN
491: RAISE FND_API.g_exc_error;
492: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
493: RAISE FND_API.g_exc_unexpected_error;
494: END IF;
495:
496: ELSIF
497: p_object = 'ALL' THEN

Line 501: ,p_init_msg_list => FND_API.G_FALSE

497: p_object = 'ALL' THEN
498:
499: bim_campaign_facts.populate
500: (p_api_version_number => 1.0
501: ,p_init_msg_list => FND_API.G_FALSE
502: ,x_msg_count => x_msg_count
503: ,x_msg_data => x_msg_data
504: ,x_return_status => x_return_status
505: ,p_object => 'CAMPAIGN'

Line 511: IF x_return_status = FND_API.g_ret_sts_error

507: ,p_end_date => p_end_date
508: ,p_para_num => p_proc_num
509: );
510:
511: IF x_return_status = FND_API.g_ret_sts_error
512: THEN
513: RAISE FND_API.g_exc_error;
514: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
515: RAISE FND_API.g_exc_unexpected_error;

Line 513: RAISE FND_API.g_exc_error;

509: );
510:
511: IF x_return_status = FND_API.g_ret_sts_error
512: THEN
513: RAISE FND_API.g_exc_error;
514: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
515: RAISE FND_API.g_exc_unexpected_error;
516: END IF;
517:

Line 514: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN

510:
511: IF x_return_status = FND_API.g_ret_sts_error
512: THEN
513: RAISE FND_API.g_exc_error;
514: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
515: RAISE FND_API.g_exc_unexpected_error;
516: END IF;
517:
518: bim_event_facts.populate (

Line 515: RAISE FND_API.g_exc_unexpected_error;

511: IF x_return_status = FND_API.g_ret_sts_error
512: THEN
513: RAISE FND_API.g_exc_error;
514: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
515: RAISE FND_API.g_exc_unexpected_error;
516: END IF;
517:
518: bim_event_facts.populate (
519: p_api_version_number => 1.0,

Line 520: p_init_msg_list => FND_API.G_FALSE,

516: END IF;
517:
518: bim_event_facts.populate (
519: p_api_version_number => 1.0,
520: p_init_msg_list => FND_API.G_FALSE,
521: x_msg_count => x_msg_count ,
522: x_msg_data => x_msg_data ,
523: x_return_status => x_return_status ,
524: p_object => 'EVENT',

Line 529: IF x_return_status = FND_API.g_ret_sts_error

525: p_start_date => NULL,
526: p_end_date => p_end_date,
527: p_para_num => p_proc_num
528: );
529: IF x_return_status = FND_API.g_ret_sts_error
530: THEN
531: RAISE FND_API.g_exc_error;
532: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
533: RAISE FND_API.g_exc_unexpected_error;

Line 531: RAISE FND_API.g_exc_error;

527: p_para_num => p_proc_num
528: );
529: IF x_return_status = FND_API.g_ret_sts_error
530: THEN
531: RAISE FND_API.g_exc_error;
532: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
533: RAISE FND_API.g_exc_unexpected_error;
534: END IF;
535:

Line 532: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN

528: );
529: IF x_return_status = FND_API.g_ret_sts_error
530: THEN
531: RAISE FND_API.g_exc_error;
532: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
533: RAISE FND_API.g_exc_unexpected_error;
534: END IF;
535:
536: bim_response_facts_pkg.populate (

Line 533: RAISE FND_API.g_exc_unexpected_error;

529: IF x_return_status = FND_API.g_ret_sts_error
530: THEN
531: RAISE FND_API.g_exc_error;
532: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
533: RAISE FND_API.g_exc_unexpected_error;
534: END IF;
535:
536: bim_response_facts_pkg.populate (
537: p_api_version_number => 1.0,

Line 538: p_init_msg_list => FND_API.G_FALSE,

534: END IF;
535:
536: bim_response_facts_pkg.populate (
537: p_api_version_number => 1.0,
538: p_init_msg_list => FND_API.G_FALSE,
539: x_msg_count => x_msg_count ,
540: x_msg_data => x_msg_data ,
541: x_return_status => x_return_status ,
542: p_start_date => NULL,

Line 546: IF x_return_status = FND_API.g_ret_sts_error

542: p_start_date => NULL,
543: p_end_date => p_end_date,
544: p_para_num => p_proc_num
545: );
546: IF x_return_status = FND_API.g_ret_sts_error
547: THEN
548: RAISE FND_API.g_exc_error;
549: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
550: RAISE FND_API.g_exc_unexpected_error;

Line 548: RAISE FND_API.g_exc_error;

544: p_para_num => p_proc_num
545: );
546: IF x_return_status = FND_API.g_ret_sts_error
547: THEN
548: RAISE FND_API.g_exc_error;
549: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
550: RAISE FND_API.g_exc_unexpected_error;
551: END IF;
552:

Line 549: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN

545: );
546: IF x_return_status = FND_API.g_ret_sts_error
547: THEN
548: RAISE FND_API.g_exc_error;
549: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
550: RAISE FND_API.g_exc_unexpected_error;
551: END IF;
552:
553: bim_lead_facts_pkg.POPULATE (

Line 550: RAISE FND_API.g_exc_unexpected_error;

546: IF x_return_status = FND_API.g_ret_sts_error
547: THEN
548: RAISE FND_API.g_exc_error;
549: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
550: RAISE FND_API.g_exc_unexpected_error;
551: END IF;
552:
553: bim_lead_facts_pkg.POPULATE (
554: p_api_version_number => 1.0,

Line 555: p_init_msg_list => FND_API.G_FALSE,

551: END IF;
552:
553: bim_lead_facts_pkg.POPULATE (
554: p_api_version_number => 1.0,
555: p_init_msg_list => FND_API.G_FALSE,
556: x_msg_count => x_msg_count ,
557: x_msg_data => x_msg_data ,
558: x_return_status => x_return_status ,
559: p_object => p_object,

Line 564: IF x_return_status = FND_API.g_ret_sts_error

560: p_start_date => NULL,
561: p_end_date => p_end_date,
562: p_para_num => p_proc_num
563: );
564: IF x_return_status = FND_API.g_ret_sts_error
565: THEN
566: RAISE FND_API.g_exc_error;
567: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
568: RAISE FND_API.g_exc_unexpected_error;

Line 566: RAISE FND_API.g_exc_error;

562: p_para_num => p_proc_num
563: );
564: IF x_return_status = FND_API.g_ret_sts_error
565: THEN
566: RAISE FND_API.g_exc_error;
567: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
568: RAISE FND_API.g_exc_unexpected_error;
569: END IF;
570:

Line 567: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN

563: );
564: IF x_return_status = FND_API.g_ret_sts_error
565: THEN
566: RAISE FND_API.g_exc_error;
567: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
568: RAISE FND_API.g_exc_unexpected_error;
569: END IF;
570:
571: bim_lead_import_facts_pkg.POPULATE (

Line 568: RAISE FND_API.g_exc_unexpected_error;

564: IF x_return_status = FND_API.g_ret_sts_error
565: THEN
566: RAISE FND_API.g_exc_error;
567: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
568: RAISE FND_API.g_exc_unexpected_error;
569: END IF;
570:
571: bim_lead_import_facts_pkg.POPULATE (
572: p_api_version_number => 1.0,

Line 573: p_init_msg_list => FND_API.G_FALSE,

569: END IF;
570:
571: bim_lead_import_facts_pkg.POPULATE (
572: p_api_version_number => 1.0,
573: p_init_msg_list => FND_API.G_FALSE,
574: x_msg_count => x_msg_count ,
575: x_msg_data => x_msg_data ,
576: x_return_status => x_return_status ,
577: p_object => 'EVENT',

Line 582: IF x_return_status = FND_API.g_ret_sts_error

578: p_start_date => NULL,
579: p_end_date => p_end_date,
580: p_para_num => p_proc_num
581: );
582: IF x_return_status = FND_API.g_ret_sts_error
583: THEN
584: RAISE FND_API.g_exc_error;
585: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
586: RAISE FND_API.g_exc_unexpected_error;

Line 584: RAISE FND_API.g_exc_error;

580: p_para_num => p_proc_num
581: );
582: IF x_return_status = FND_API.g_ret_sts_error
583: THEN
584: RAISE FND_API.g_exc_error;
585: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
586: RAISE FND_API.g_exc_unexpected_error;
587: END IF;
588:

Line 585: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN

581: );
582: IF x_return_status = FND_API.g_ret_sts_error
583: THEN
584: RAISE FND_API.g_exc_error;
585: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
586: RAISE FND_API.g_exc_unexpected_error;
587: END IF;
588:
589: bim_fund_facts.populate (

Line 586: RAISE FND_API.g_exc_unexpected_error;

582: IF x_return_status = FND_API.g_ret_sts_error
583: THEN
584: RAISE FND_API.g_exc_error;
585: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
586: RAISE FND_API.g_exc_unexpected_error;
587: END IF;
588:
589: bim_fund_facts.populate (
590: p_api_version_number => 1.0,

Line 591: p_init_msg_list => FND_API.G_FALSE,

587: END IF;
588:
589: bim_fund_facts.populate (
590: p_api_version_number => 1.0,
591: p_init_msg_list => FND_API.G_FALSE,
592: x_msg_count => x_msg_count ,
593: x_msg_data => x_msg_data ,
594: x_return_status => x_return_status ,
595: p_object => 'FUND',

Line 601: IF x_return_status = FND_API.g_ret_sts_error

597: p_end_date => p_end_date,
598: p_para_num => p_proc_num
599: );
600:
601: IF x_return_status = FND_API.g_ret_sts_error
602: THEN
603: RAISE FND_API.g_exc_error;
604: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
605: RAISE FND_API.g_exc_unexpected_error;

Line 603: RAISE FND_API.g_exc_error;

599: );
600:
601: IF x_return_status = FND_API.g_ret_sts_error
602: THEN
603: RAISE FND_API.g_exc_error;
604: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
605: RAISE FND_API.g_exc_unexpected_error;
606: END IF;
607:

Line 604: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN

600:
601: IF x_return_status = FND_API.g_ret_sts_error
602: THEN
603: RAISE FND_API.g_exc_error;
604: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
605: RAISE FND_API.g_exc_unexpected_error;
606: END IF;
607:
608: END IF;

Line 605: RAISE FND_API.g_exc_unexpected_error;

601: IF x_return_status = FND_API.g_ret_sts_error
602: THEN
603: RAISE FND_API.g_exc_error;
604: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
605: RAISE FND_API.g_exc_unexpected_error;
606: END IF;
607:
608: END IF;
609:

Line 614: WHEN FND_API.G_EXC_ERROR THEN

610: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'End');
611:
612: EXCEPTION
613:
614: WHEN FND_API.G_EXC_ERROR THEN
615: x_return_status := FND_API.g_ret_sts_error ;
616: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
617: p_count => x_msg_count,
618: p_data => x_msg_data);

Line 615: x_return_status := FND_API.g_ret_sts_error ;

611:
612: EXCEPTION
613:
614: WHEN FND_API.G_EXC_ERROR THEN
615: x_return_status := FND_API.g_ret_sts_error ;
616: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
617: p_count => x_msg_count,
618: p_data => x_msg_data);
619: ERRBUF := x_msg_data;

Line 616: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,

612: EXCEPTION
613:
614: WHEN FND_API.G_EXC_ERROR THEN
615: x_return_status := FND_API.g_ret_sts_error ;
616: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
617: p_count => x_msg_count,
618: p_data => x_msg_data);
619: ERRBUF := x_msg_data;
620: RETCODE := 2;

Line 622: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

618: p_data => x_msg_data);
619: ERRBUF := x_msg_data;
620: RETCODE := 2;
621: ams_utility_pvt.write_conc_log(sqlerrm(sqlcode));
622: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
623: x_return_status := FND_API.g_ret_sts_unexp_error ;
624: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,
625: p_count => x_msg_count,
626: p_data => x_msg_data);

Line 623: x_return_status := FND_API.g_ret_sts_unexp_error ;

619: ERRBUF := x_msg_data;
620: RETCODE := 2;
621: ams_utility_pvt.write_conc_log(sqlerrm(sqlcode));
622: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
623: x_return_status := FND_API.g_ret_sts_unexp_error ;
624: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,
625: p_count => x_msg_count,
626: p_data => x_msg_data);
627: ERRBUF := x_msg_data;

Line 624: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,

620: RETCODE := 2;
621: ams_utility_pvt.write_conc_log(sqlerrm(sqlcode));
622: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
623: x_return_status := FND_API.g_ret_sts_unexp_error ;
624: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,
625: p_count => x_msg_count,
626: p_data => x_msg_data);
627: ERRBUF := x_msg_data;
628: RETCODE := 2;

Line 631: x_return_status := FND_API.g_ret_sts_unexp_error ;

627: ERRBUF := x_msg_data;
628: RETCODE := 2;
629: ams_utility_pvt.write_conc_log(sqlerrm(sqlcode));
630: WHEN OTHERS THEN
631: x_return_status := FND_API.g_ret_sts_unexp_error ;
632: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,
633: p_count => x_msg_count,
634: p_data => x_msg_data);
635: ERRBUF := sqlerrm(sqlcode);

Line 632: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,

628: RETCODE := 2;
629: ams_utility_pvt.write_conc_log(sqlerrm(sqlcode));
630: WHEN OTHERS THEN
631: x_return_status := FND_API.g_ret_sts_unexp_error ;
632: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,
633: p_count => x_msg_count,
634: p_data => x_msg_data);
635: ERRBUF := sqlerrm(sqlcode);
636: RETCODE := sqlcode;