334:
335: FUNCTION IS_FV_ENABLED RETURN VARCHAR2
336: IS
337: BEGIN
338: IF (fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
339: FND_LOG.string(
340: fnd_log.level_statement,
341: g_log_module_name,
342: ' starts IS_FV_ENABLED '
335: FUNCTION IS_FV_ENABLED RETURN VARCHAR2
336: IS
337: BEGIN
338: IF (fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
339: FND_LOG.string(
340: fnd_log.level_statement,
341: g_log_module_name,
342: ' starts IS_FV_ENABLED '
343: );
336: IS
337: BEGIN
338: IF (fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
339: FND_LOG.string(
340: fnd_log.level_statement,
341: g_log_module_name,
342: ' starts IS_FV_ENABLED '
343: );
344: END IF;
380: x_error_code OUT NOCOPY NUMBER
381: )
382: IS
383: BEGIN
384: IF (fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
385: FND_LOG.string(
386: fnd_log.level_statement,
387: g_log_module_name,
388: ' start FV_IS_CCR'
381: )
382: IS
383: BEGIN
384: IF (fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
385: FND_LOG.string(
386: fnd_log.level_statement,
387: g_log_module_name,
388: ' start FV_IS_CCR'
389: );
382: IS
383: BEGIN
384: IF (fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
385: FND_LOG.string(
386: fnd_log.level_statement,
387: g_log_module_name,
388: ' start FV_IS_CCR'
389: );
390: END IF;
388: ' start FV_IS_CCR'
389: );
390: END IF;
391:
392: IF (fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
393: FND_LOG.string(
394: fnd_log.level_statement,
395: g_log_module_name,
396: 'Calling FV_CCR_GRP.FV_IS_CCR with p_object_id = '||p_object_id||' p_object_type = '||p_object_type
389: );
390: END IF;
391:
392: IF (fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
393: FND_LOG.string(
394: fnd_log.level_statement,
395: g_log_module_name,
396: 'Calling FV_CCR_GRP.FV_IS_CCR with p_object_id = '||p_object_id||' p_object_type = '||p_object_type
397: );
390: END IF;
391:
392: IF (fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
393: FND_LOG.string(
394: fnd_log.level_statement,
395: g_log_module_name,
396: 'Calling FV_CCR_GRP.FV_IS_CCR with p_object_id = '||p_object_id||' p_object_type = '||p_object_type
397: );
398: END IF;
441: cursor l_addr_site_cur is
442: select vendor_site_id from ap_supplier_sites_all
443: WHERE party_site_id = p_object_id;
444: BEGIN
445: IF (fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
446: FND_LOG.string(
447: fnd_log.level_statement,
448: g_log_module_name,
449: 'Start IS_ADDR_CCR with p_object_id = '||p_object_id
442: select vendor_site_id from ap_supplier_sites_all
443: WHERE party_site_id = p_object_id;
444: BEGIN
445: IF (fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
446: FND_LOG.string(
447: fnd_log.level_statement,
448: g_log_module_name,
449: 'Start IS_ADDR_CCR with p_object_id = '||p_object_id
450: );
443: WHERE party_site_id = p_object_id;
444: BEGIN
445: IF (fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
446: FND_LOG.string(
447: fnd_log.level_statement,
448: g_log_module_name,
449: 'Start IS_ADDR_CCR with p_object_id = '||p_object_id
450: );
451: END IF;
449: 'Start IS_ADDR_CCR with p_object_id = '||p_object_id
450: );
451: END IF;
452: l_out_status := 'F';
453: IF (fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
454: FND_LOG.string(
455: fnd_log.level_statement,
456: g_log_module_name,
457: 'Calling pos_util_pkg.IS_FV_ENABLED'
450: );
451: END IF;
452: l_out_status := 'F';
453: IF (fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
454: FND_LOG.string(
455: fnd_log.level_statement,
456: g_log_module_name,
457: 'Calling pos_util_pkg.IS_FV_ENABLED'
458: );
451: END IF;
452: l_out_status := 'F';
453: IF (fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
454: FND_LOG.string(
455: fnd_log.level_statement,
456: g_log_module_name,
457: 'Calling pos_util_pkg.IS_FV_ENABLED'
458: );
459: END IF;
457: 'Calling pos_util_pkg.IS_FV_ENABLED'
458: );
459: END IF;
460: is_enabled := pos_util_pkg.IS_FV_ENABLED();
461: IF (fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
462: FND_LOG.string(
463: fnd_log.level_statement,
464: g_log_module_name,
465: 'After pos_util_pkg.IS_FV_ENABLED is_enabled = '||is_enabled
458: );
459: END IF;
460: is_enabled := pos_util_pkg.IS_FV_ENABLED();
461: IF (fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
462: FND_LOG.string(
463: fnd_log.level_statement,
464: g_log_module_name,
465: 'After pos_util_pkg.IS_FV_ENABLED is_enabled = '||is_enabled
466: );
459: END IF;
460: is_enabled := pos_util_pkg.IS_FV_ENABLED();
461: IF (fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
462: FND_LOG.string(
463: fnd_log.level_statement,
464: g_log_module_name,
465: 'After pos_util_pkg.IS_FV_ENABLED is_enabled = '||is_enabled
466: );
467: END IF;
468: if is_enabled <> 'T' then
469: return l_out_status;
470: else
471: for i in l_addr_site_cur loop
472: IF (fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
473: FND_LOG.string(
474: fnd_log.level_statement,
475: g_log_module_name,
476: 'Calling FV_CCR_GRP.FV_IS_CCR with i.vendor_site_id = '||i.vendor_site_id
469: return l_out_status;
470: else
471: for i in l_addr_site_cur loop
472: IF (fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
473: FND_LOG.string(
474: fnd_log.level_statement,
475: g_log_module_name,
476: 'Calling FV_CCR_GRP.FV_IS_CCR with i.vendor_site_id = '||i.vendor_site_id
477: );
470: else
471: for i in l_addr_site_cur loop
472: IF (fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
473: FND_LOG.string(
474: fnd_log.level_statement,
475: g_log_module_name,
476: 'Calling FV_CCR_GRP.FV_IS_CCR with i.vendor_site_id = '||i.vendor_site_id
477: );
478: END IF;
487: l_ccr_id,
488: l_out_status,
489: l_error_code
490: );
491: IF (fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
492: FND_LOG.string(
493: fnd_log.level_statement,
494: g_log_module_name,
495: 'After Calling FV_CCR_GRP.FV_IS_CCR with i.vendor_site_id = '||i.vendor_site_id||' l_return_status ='||l_return_status||'l_out_status = '||l_out_status
488: l_out_status,
489: l_error_code
490: );
491: IF (fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
492: FND_LOG.string(
493: fnd_log.level_statement,
494: g_log_module_name,
495: 'After Calling FV_CCR_GRP.FV_IS_CCR with i.vendor_site_id = '||i.vendor_site_id||' l_return_status ='||l_return_status||'l_out_status = '||l_out_status
496: );
489: l_error_code
490: );
491: IF (fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
492: FND_LOG.string(
493: fnd_log.level_statement,
494: g_log_module_name,
495: 'After Calling FV_CCR_GRP.FV_IS_CCR with i.vendor_site_id = '||i.vendor_site_id||' l_return_status ='||l_return_status||'l_out_status = '||l_out_status
496: );
497: END IF;
500: return l_out_status;
501: end if;
502: end loop;
503: end if;
504: IF (fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
505: FND_LOG.string(
506: fnd_log.level_statement,
507: g_log_module_name,
508: 'End IS_ADDR_CCR with p_object_id = '||p_object_id||'l_out_status = '||l_out_status
501: end if;
502: end loop;
503: end if;
504: IF (fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
505: FND_LOG.string(
506: fnd_log.level_statement,
507: g_log_module_name,
508: 'End IS_ADDR_CCR with p_object_id = '||p_object_id||'l_out_status = '||l_out_status
509: );
502: end loop;
503: end if;
504: IF (fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
505: FND_LOG.string(
506: fnd_log.level_statement,
507: g_log_module_name,
508: 'End IS_ADDR_CCR with p_object_id = '||p_object_id||'l_out_status = '||l_out_status
509: );
510: END IF;
538: l_msg_data VARCHAR2(3000);
539: l_error_code NUMBER;
540: l_ccr_id NUMBER;
541: BEGIN
542: IF (fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
543: FND_LOG.string(
544: fnd_log.level_statement,
545: g_log_module_name,
546: 'Start IS_SITE_CCR with p_object_id = '||p_object_id
539: l_error_code NUMBER;
540: l_ccr_id NUMBER;
541: BEGIN
542: IF (fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
543: FND_LOG.string(
544: fnd_log.level_statement,
545: g_log_module_name,
546: 'Start IS_SITE_CCR with p_object_id = '||p_object_id
547: );
540: l_ccr_id NUMBER;
541: BEGIN
542: IF (fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
543: FND_LOG.string(
544: fnd_log.level_statement,
545: g_log_module_name,
546: 'Start IS_SITE_CCR with p_object_id = '||p_object_id
547: );
548: END IF;
546: 'Start IS_SITE_CCR with p_object_id = '||p_object_id
547: );
548: END IF;
549: l_out_status := 'F';
550: IF (fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
551: FND_LOG.string(
552: fnd_log.level_statement,
553: g_log_module_name,
554: 'Calling pos_util_pkg.IS_FV_ENABLED'
547: );
548: END IF;
549: l_out_status := 'F';
550: IF (fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
551: FND_LOG.string(
552: fnd_log.level_statement,
553: g_log_module_name,
554: 'Calling pos_util_pkg.IS_FV_ENABLED'
555: );
548: END IF;
549: l_out_status := 'F';
550: IF (fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
551: FND_LOG.string(
552: fnd_log.level_statement,
553: g_log_module_name,
554: 'Calling pos_util_pkg.IS_FV_ENABLED'
555: );
556: END IF;
554: 'Calling pos_util_pkg.IS_FV_ENABLED'
555: );
556: END IF;
557: is_enabled := pos_util_pkg.IS_FV_ENABLED();
558: IF (fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
559: FND_LOG.string(
560: fnd_log.level_statement,
561: g_log_module_name,
562: 'After Calling pos_util_pkg.IS_FV_ENABLED is_enabled = '||is_enabled
555: );
556: END IF;
557: is_enabled := pos_util_pkg.IS_FV_ENABLED();
558: IF (fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
559: FND_LOG.string(
560: fnd_log.level_statement,
561: g_log_module_name,
562: 'After Calling pos_util_pkg.IS_FV_ENABLED is_enabled = '||is_enabled
563: );
556: END IF;
557: is_enabled := pos_util_pkg.IS_FV_ENABLED();
558: IF (fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
559: FND_LOG.string(
560: fnd_log.level_statement,
561: g_log_module_name,
562: 'After Calling pos_util_pkg.IS_FV_ENABLED is_enabled = '||is_enabled
563: );
564: END IF;
565:
566: if is_enabled <> 'T' then
567: return l_out_status;
568: else
569: IF (fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
570: THEN
571: FND_LOG.string(
572: fnd_log.level_statement,
573: g_log_module_name,
567: return l_out_status;
568: else
569: IF (fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
570: THEN
571: FND_LOG.string(
572: fnd_log.level_statement,
573: g_log_module_name,
574: 'Calling FV_CCR_GRP.FV_IS_CCR with p_object_id = '||p_object_id
575: );
568: else
569: IF (fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
570: THEN
571: FND_LOG.string(
572: fnd_log.level_statement,
573: g_log_module_name,
574: 'Calling FV_CCR_GRP.FV_IS_CCR with p_object_id = '||p_object_id
575: );
576: END IF;
585: l_ccr_id,
586: l_out_status,
587: l_error_code
588: );
589: IF (fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
590: THEN
591: FND_LOG.string(
592: fnd_log.level_statement,
593: g_log_module_name,
587: l_error_code
588: );
589: IF (fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
590: THEN
591: FND_LOG.string(
592: fnd_log.level_statement,
593: g_log_module_name,
594: 'After Calling FV_CCR_GRP.FV_IS_CCR l_out_status = '||l_out_status
595: );
588: );
589: IF (fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
590: THEN
591: FND_LOG.string(
592: fnd_log.level_statement,
593: g_log_module_name,
594: 'After Calling FV_CCR_GRP.FV_IS_CCR l_out_status = '||l_out_status
595: );
596: END IF;
627: l_error_code NUMBER;
628: l_ccr_id NUMBER;
629: BEGIN
630: l_out_status := 'F';
631: IF (fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
632: FND_LOG.string(
633: fnd_log.level_statement,
634: g_log_module_name,
635: 'Start IS_SUPP_CCR with p_object_id = '||p_object_id
628: l_ccr_id NUMBER;
629: BEGIN
630: l_out_status := 'F';
631: IF (fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
632: FND_LOG.string(
633: fnd_log.level_statement,
634: g_log_module_name,
635: 'Start IS_SUPP_CCR with p_object_id = '||p_object_id
636: );
629: BEGIN
630: l_out_status := 'F';
631: IF (fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
632: FND_LOG.string(
633: fnd_log.level_statement,
634: g_log_module_name,
635: 'Start IS_SUPP_CCR with p_object_id = '||p_object_id
636: );
637: END IF;
634: g_log_module_name,
635: 'Start IS_SUPP_CCR with p_object_id = '||p_object_id
636: );
637: END IF;
638: IF (fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
639: FND_LOG.string(
640: fnd_log.level_statement,
641: g_log_module_name,
642: 'Calling pos_util_pkg.IS_FV_ENABLED'
635: 'Start IS_SUPP_CCR with p_object_id = '||p_object_id
636: );
637: END IF;
638: IF (fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
639: FND_LOG.string(
640: fnd_log.level_statement,
641: g_log_module_name,
642: 'Calling pos_util_pkg.IS_FV_ENABLED'
643: );
636: );
637: END IF;
638: IF (fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
639: FND_LOG.string(
640: fnd_log.level_statement,
641: g_log_module_name,
642: 'Calling pos_util_pkg.IS_FV_ENABLED'
643: );
644: END IF;
642: 'Calling pos_util_pkg.IS_FV_ENABLED'
643: );
644: END IF;
645: is_enabled := pos_util_pkg.IS_FV_ENABLED();
646: IF (fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
647: FND_LOG.string(
648: fnd_log.level_statement,
649: g_log_module_name,
650: 'After Calling pos_util_pkg.IS_FV_ENABLED is_enabled ='||is_enabled
643: );
644: END IF;
645: is_enabled := pos_util_pkg.IS_FV_ENABLED();
646: IF (fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
647: FND_LOG.string(
648: fnd_log.level_statement,
649: g_log_module_name,
650: 'After Calling pos_util_pkg.IS_FV_ENABLED is_enabled ='||is_enabled
651: );
644: END IF;
645: is_enabled := pos_util_pkg.IS_FV_ENABLED();
646: IF (fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
647: FND_LOG.string(
648: fnd_log.level_statement,
649: g_log_module_name,
650: 'After Calling pos_util_pkg.IS_FV_ENABLED is_enabled ='||is_enabled
651: );
652: END IF;
652: END IF;
653: if is_enabled <> 'T' then
654: return l_out_status;
655: else
656: IF (fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
657: THEN
658: FND_LOG.string(
659: fnd_log.level_statement,
660: g_log_module_name,
654: return l_out_status;
655: else
656: IF (fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
657: THEN
658: FND_LOG.string(
659: fnd_log.level_statement,
660: g_log_module_name,
661: 'Calling FV_CCR_GRP.FV_IS_CCR with p_object_id = '||p_object_id
662: );
655: else
656: IF (fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
657: THEN
658: FND_LOG.string(
659: fnd_log.level_statement,
660: g_log_module_name,
661: 'Calling FV_CCR_GRP.FV_IS_CCR with p_object_id = '||p_object_id
662: );
663: END IF;
672: l_ccr_id,
673: l_out_status,
674: l_error_code
675: );
676: IF (fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
677: THEN
678: FND_LOG.string(
679: fnd_log.level_statement,
680: g_log_module_name,
674: l_error_code
675: );
676: IF (fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
677: THEN
678: FND_LOG.string(
679: fnd_log.level_statement,
680: g_log_module_name,
681: 'After Calling FV_CCR_GRP.FV_IS_CCR with l_out_status = '||l_out_status
682: );
675: );
676: IF (fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
677: THEN
678: FND_LOG.string(
679: fnd_log.level_statement,
680: g_log_module_name,
681: 'After Calling FV_CCR_GRP.FV_IS_CCR with l_out_status = '||l_out_status
682: );
683: END IF;
711: l_msg_data VARCHAR2(3000);
712: l_error_code NUMBER;
713: l_ccr_id NUMBER;
714: BEGIN
715: IF (fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
716: FND_LOG.string(
717: fnd_log.level_statement,
718: g_log_module_name,
719: 'Start IS_CCR_SITE_ACTIVE with p_object_id = '||p_object_id
712: l_error_code NUMBER;
713: l_ccr_id NUMBER;
714: BEGIN
715: IF (fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
716: FND_LOG.string(
717: fnd_log.level_statement,
718: g_log_module_name,
719: 'Start IS_CCR_SITE_ACTIVE with p_object_id = '||p_object_id
720: );
713: l_ccr_id NUMBER;
714: BEGIN
715: IF (fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
716: FND_LOG.string(
717: fnd_log.level_statement,
718: g_log_module_name,
719: 'Start IS_CCR_SITE_ACTIVE with p_object_id = '||p_object_id
720: );
721: END IF;
718: g_log_module_name,
719: 'Start IS_CCR_SITE_ACTIVE with p_object_id = '||p_object_id
720: );
721: END IF;
722: IF (fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
723: FND_LOG.string(
724: fnd_log.level_statement,
725: g_log_module_name,
726: 'Calling pos_util_pkg.IS_FV_ENABLED'
719: 'Start IS_CCR_SITE_ACTIVE with p_object_id = '||p_object_id
720: );
721: END IF;
722: IF (fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
723: FND_LOG.string(
724: fnd_log.level_statement,
725: g_log_module_name,
726: 'Calling pos_util_pkg.IS_FV_ENABLED'
727: );
720: );
721: END IF;
722: IF (fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
723: FND_LOG.string(
724: fnd_log.level_statement,
725: g_log_module_name,
726: 'Calling pos_util_pkg.IS_FV_ENABLED'
727: );
728: END IF;
731: is_enabled := pos_util_pkg.IS_FV_ENABLED();
732: if is_enabled <> 'T' then
733: return 'F';
734: else
735: IF (fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
736: THEN
737: FND_LOG.string(
738: fnd_log.level_statement,
739: g_log_module_name,
733: return 'F';
734: else
735: IF (fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
736: THEN
737: FND_LOG.string(
738: fnd_log.level_statement,
739: g_log_module_name,
740: 'Calling FV_CCR_GRP.FV_IS_CCR with p_object_id = '||p_object_id
741: );
734: else
735: IF (fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
736: THEN
737: FND_LOG.string(
738: fnd_log.level_statement,
739: g_log_module_name,
740: 'Calling FV_CCR_GRP.FV_IS_CCR with p_object_id = '||p_object_id
741: );
742: END IF;
752: l_ccr_id,
753: l_out_status,
754: l_error_code
755: );
756: IF (fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
757: THEN
758: FND_LOG.string(
759: fnd_log.level_statement,
760: g_log_module_name,
754: l_error_code
755: );
756: IF (fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
757: THEN
758: FND_LOG.string(
759: fnd_log.level_statement,
760: g_log_module_name,
761: 'After Calling FV_CCR_GRP.FV_IS_CCR with l_out_status = '||l_out_status
762: );
755: );
756: IF (fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
757: THEN
758: FND_LOG.string(
759: fnd_log.level_statement,
760: g_log_module_name,
761: 'After Calling FV_CCR_GRP.FV_IS_CCR with l_out_status = '||l_out_status
762: );
763: END IF;
764:
765: if l_out_status <> 'T' then
766: return 'F';
767: else
768: IF (fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
769: THEN
770: FND_LOG.string(
771: fnd_log.level_statement,
772: g_log_module_name,
766: return 'F';
767: else
768: IF (fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
769: THEN
770: FND_LOG.string(
771: fnd_log.level_statement,
772: g_log_module_name,
773: 'Calling FV_CCR_GRP.FV_CCR_REG_STATUS with p_object_id = '||p_object_id
774: );
767: else
768: IF (fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
769: THEN
770: FND_LOG.string(
771: fnd_log.level_statement,
772: g_log_module_name,
773: 'Calling FV_CCR_GRP.FV_CCR_REG_STATUS with p_object_id = '||p_object_id
774: );
775: END IF;
782: l_msg_data,
783: l_out_status,
784: l_error_code
785: );
786: IF (fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
787: THEN
788: FND_LOG.string(
789: fnd_log.level_statement,
790: g_log_module_name,
784: l_error_code
785: );
786: IF (fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
787: THEN
788: FND_LOG.string(
789: fnd_log.level_statement,
790: g_log_module_name,
791: 'After Calling FV_CCR_GRP.FV_CCR_REG_STATUS with l_out_status = '||l_out_status
792: );
785: );
786: IF (fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
787: THEN
788: FND_LOG.string(
789: fnd_log.level_statement,
790: g_log_module_name,
791: 'After Calling FV_CCR_GRP.FV_CCR_REG_STATUS with l_out_status = '||l_out_status
792: );
793: END IF;