358: -----------------------
359: purpose:
360: --------
361: The iSP wrapper api to know if record is in CCR,
362: by calling the Federal Financial api FV_CCR_GRP.FV_IS_CCR
363:
364: p_object_type, p_object_id:
365: Here S-> Supplier --> Pass supplier_id
366: B=> Bank branch --> pass bank brnahc id
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;
399: FV_CCR_GRP.FV_IS_CCR(
400: p_api_version,
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;
399: FV_CCR_GRP.FV_IS_CCR(
400: p_api_version,
401: p_init_msg_list,
402: p_object_id,
403: p_object_type,
409: x_error_code
410: );
411: EXCEPTION
412: WHEN OTHERS THEN
413: raise_application_error(-20060, 'Failure in FV_CCR_GRP.FV_IS_CCR ', true);
414: END FV_IS_CCR;
415:
416:
417: /** function IS_ADDR_CCR
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;
479: FV_CCR_GRP.FV_IS_CCR(
480: p_api_version,
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;
479: FV_CCR_GRP.FV_IS_CCR(
480: p_api_version,
481: p_init_msg_list,
482: i.vendor_site_id,
483: 'T',
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;
498:
499: if l_out_status <> 'F' then
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;
577: FV_CCR_GRP.FV_IS_CCR(
578: p_api_version,
573: g_log_module_name,
574: 'Calling FV_CCR_GRP.FV_IS_CCR with p_object_id = '||p_object_id
575: );
576: END IF;
577: FV_CCR_GRP.FV_IS_CCR(
578: p_api_version,
579: p_init_msg_list,
580: p_object_id,
581: 'T',
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;
597: end if;
598: return l_out_status;
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;
664: FV_CCR_GRP.FV_IS_CCR(
665: p_api_version,
660: g_log_module_name,
661: 'Calling FV_CCR_GRP.FV_IS_CCR with p_object_id = '||p_object_id
662: );
663: END IF;
664: FV_CCR_GRP.FV_IS_CCR(
665: p_api_version,
666: p_init_msg_list,
667: p_object_id,
668: 'S',
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;
684: end if;
685: return l_out_status;
688: /** function IS_CCR_SITE_ACTIVE
689: -----------------------
690: purpose:
691: --------
692: The iSP wrapper api over FV_CCR_GRP.FV_CCR_REG_STATUS to know if site is CCR
693: site and if registration_status is active.
694: p_object_id: vendor_site_id.
695:
696: Returns 'T' if the site is CCR Site and registration_status is active otherwise
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;
743:
744: FV_CCR_GRP.FV_IS_CCR(
740: 'Calling FV_CCR_GRP.FV_IS_CCR with p_object_id = '||p_object_id
741: );
742: END IF;
743:
744: FV_CCR_GRP.FV_IS_CCR(
745: p_api_version,
746: p_init_msg_list,
747: p_object_id,
748: 'T',
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
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;
776: FV_CCR_GRP.FV_CCR_REG_STATUS(
777: p_api_version,
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;
776: FV_CCR_GRP.FV_CCR_REG_STATUS(
777: p_api_version,
778: p_init_msg_list,
779: p_object_id,
780: l_return_status,
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;
794:
795: end if;