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.IBE_MSITE_GRP dependencies on IBE_UTIL

Line 370: IBE_UTIL.Debug('Start IBE_MSITE_GRP.Save_Msite');

366: l_operation_type:= 'INSERT';
367: l_debug := NVL(FND_PROFILE.VALUE('IBE_DEBUG'),'N');
368:
369: IF (l_debug = 'Y') THEN
370: IBE_UTIL.Debug('Start IBE_MSITE_GRP.Save_Msite');
371: END IF;
372:
373: --------------------- initialize -----------------------+
374: SAVEPOINT save_msite;

Line 398: IBE_UTIL.Debug('[IBE_MSITE_GRP]Minisite id is passed');

394: IF p_msite_rec.msite_id IS NOT NULL AND
395: p_msite_rec.msite_id <> FND_API.g_miss_num
396: THEN
397: IF (l_debug = 'Y') THEN
398: IBE_UTIL.Debug('[IBE_MSITE_GRP]Minisite id is passed');
399: END IF;
400: if ibe_dspmgrvalidation_grp.check_msite_exists(
401: p_msite_rec.msite_id, p_msite_rec.Object_version_Number) = false
402: then

Line 404: IBE_UTIL.Debug('[IBE_MSITE_GRP]Raising Exception: MiniSite Exists');

400: if ibe_dspmgrvalidation_grp.check_msite_exists(
401: p_msite_rec.msite_id, p_msite_rec.Object_version_Number) = false
402: then
403: IF (l_debug = 'Y') THEN
404: IBE_UTIL.Debug('[IBE_MSITE_GRP]Raising Exception: MiniSite Exists');
405: END IF;
406: raise FND_API.g_exc_error;
407: end if;
408:

Line 412: IBE_UTIL.Debug('[IBE_MSITE_GRP]Operation is an Update');

408:
409: l_operation_type:='UPDATE';
410:
411: IF (l_debug = 'Y') THEN
412: IBE_UTIL.Debug('[IBE_MSITE_GRP]Operation is an Update');
413: END IF;
414:
415: END IF;
416: if p_msite_rec.msite_root_section_id <> FND_API.g_miss_num AND

Line 423: IBE_UTIL.Debug('Raising Exception:Root Section Does not exist');

419: if ibe_dspmgrvalidation_grp.check_root_section_exists(
420: p_msite_rec.msite_root_section_id) = false
421: then
422: IF (l_debug = 'Y') THEN
423: IBE_UTIL.Debug('Raising Exception:Root Section Does not exist');
424: END IF;
425: raise FND_API.g_exc_error;
426: end if;
427:

Line 460: IBE_UTIL.Debug('Exception:Access Name is not Unique');

456: If Ibe_Dspmgrvalidation_Grp.Check_Msite_Accessname(
457: p_access_name => p_msite_rec.access_name)= FALSE
458: Then
459: IF (l_debug = 'Y') THEN
460: IBE_UTIL.Debug('Exception:Access Name is not Unique');
461: END IF;
462: Raise FND_API.G_EXC_ERROR ;
463: End If;
464: End If;

Line 576: IBE_UTIL.Debug('Before insert into IBE_MSITES_B');

572:
573: IF l_operation_type = 'INSERT'
574: THEN
575: IF (l_debug = 'Y') THEN
576: IBE_UTIL.Debug('Before insert into IBE_MSITES_B');
577: END IF;
578: INSERT INTO IBE_MSITES_B (
579: MSITE_ID,
580: OBJECT_VERSION_NUMBER,

Line 633: IBE_UTIL.Debug('After insert into IBE_MSITES_B');

629: l_enable_traffic_filter,
630: l_reporting_status,
631: p_msite_rec.site_type);
632: IF (l_debug = 'Y') THEN
633: IBE_UTIL.Debug('After insert into IBE_MSITES_B');
634: END IF;
635: --- Insert into the TL table
636: IF (l_debug = 'Y') THEN
637: IBE_UTIL.Debug('Before insert into IBE_MSITES_TL');

Line 637: IBE_UTIL.Debug('Before insert into IBE_MSITES_TL');

633: IBE_UTIL.Debug('After insert into IBE_MSITES_B');
634: END IF;
635: --- Insert into the TL table
636: IF (l_debug = 'Y') THEN
637: IBE_UTIL.Debug('Before insert into IBE_MSITES_TL');
638: END IF;
639:
640: insert into IBE_MSITES_TL (
641: MSITE_ID,

Line 671: IBE_UTIL.Debug('After insert into IBE_MSITES_TL');

667: from IBE_MSITES_TL T
668: where T.MSITE_ID =l_msite_id
669: and T.LANGUAGE = L.LANGUAGE_CODE);
670: IF (l_debug = 'Y') THEN
671: IBE_UTIL.Debug('After insert into IBE_MSITES_TL');
672: END IF;
673:
674: p_msite_rec.msite_id := l_msite_id;
675: p_msite_rec.object_version_number := 1;

Line 739: IBE_UTIL.Debug('Before updating IBE_MSITES_B');

735: END IF;
736:
737:
738: IF (l_debug = 'Y') THEN
739: IBE_UTIL.Debug('Before updating IBE_MSITES_B');
740: END IF;
741:
742: UPDATE IBE_MSITES_B SET
743: LAST_UPDATE_DATE = SYSDATE,

Line 772: IBE_UTIL.Debug('After updating IBE_MSITES_B');

768: MSITE_ID = p_msite_rec.msite_id and
769: OBJECT_VERSION_NUMBER = p_msite_rec.object_version_number ;
770:
771: IF (l_debug = 'Y') THEN
772: IBE_UTIL.Debug('After updating IBE_MSITES_B');
773: IBE_UTIL.Debug('Before updating IBE_MSITES_TL');
774: END IF;
775:
776: UPDATE IBE_MSITES_TL SET

Line 773: IBE_UTIL.Debug('Before updating IBE_MSITES_TL');

769: OBJECT_VERSION_NUMBER = p_msite_rec.object_version_number ;
770:
771: IF (l_debug = 'Y') THEN
772: IBE_UTIL.Debug('After updating IBE_MSITES_B');
773: IBE_UTIL.Debug('Before updating IBE_MSITES_TL');
774: END IF;
775:
776: UPDATE IBE_MSITES_TL SET
777: MSITE_NAME = decode( p_msite_rec.Display_name, FND_API.G_MISS_CHAR,

Line 790: IBE_UTIL.Debug('After updating IBE_MSITES_TL');

786: where msite_id = p_msite_rec.msite_id
787: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
788:
789: IF (l_debug = 'Y') THEN
790: IBE_UTIL.Debug('After updating IBE_MSITES_TL');
791: END IF;
792:
793: p_msite_rec.object_version_number :=
794: p_msite_rec.object_version_number + 1;

Line 804: IBE_UTIL.Debug('Before calling IBE_DSP_HIERARCHY_SETUP_PVT.' || 'Associate_Root_Sct_To_MSite ');

800: ----if p_msite_rec.enable_for_store = FND_API.g_true and
801: if l_root_section_flag = FND_API.g_true
802: then
803: IF (l_debug = 'Y') THEN
804: IBE_UTIL.Debug('Before calling IBE_DSP_HIERARCHY_SETUP_PVT.' || 'Associate_Root_Sct_To_MSite ');
805: END IF;
806:
807: IBE_DSP_HIERARCHY_SETUP_PVT.Associate_Root_Sct_To_MSite
808: (

Line 821: IBE_UTIL.Debug('After calling IBE_DSP_HIERARCHY_SETUP_PVT.' || 'Associate_Root_Sct_To_MSite ');

817: x_msg_data => x_msg_data
818: );
819:
820: IF (l_debug = 'Y') THEN
821: IBE_UTIL.Debug('After calling IBE_DSP_HIERARCHY_SETUP_PVT.' || 'Associate_Root_Sct_To_MSite ');
822: END IF;
823:
824: if l_return_status = FND_API.G_RET_STS_SUCCESS then
825: update IBE_MSITES_B set msite_root_section_id = l_root_section_id ,

Line 1050: IBE_UTIL.debug('duplicate_msite Starts +');

1046: l_api_name:= 'duplicate_msite';
1047: l_debug := NVL(FND_PROFILE.VALUE('IBE_DEBUG'),'N');
1048:
1049: IF (l_debug = 'Y') THEN
1050: IBE_UTIL.debug('duplicate_msite Starts +');
1051: IBE_UTIL.debug('p_api_version = '||p_api_version);
1052: IBE_UTIL.debug('p_init_msg_list = '||p_init_msg_list);
1053: IBE_UTIL.debug('p_commit = '||p_commit);
1054: IBE_UTIL.debug('p_source_msite_id = '||p_msite_rec.msite_id);

Line 1051: IBE_UTIL.debug('p_api_version = '||p_api_version);

1047: l_debug := NVL(FND_PROFILE.VALUE('IBE_DEBUG'),'N');
1048:
1049: IF (l_debug = 'Y') THEN
1050: IBE_UTIL.debug('duplicate_msite Starts +');
1051: IBE_UTIL.debug('p_api_version = '||p_api_version);
1052: IBE_UTIL.debug('p_init_msg_list = '||p_init_msg_list);
1053: IBE_UTIL.debug('p_commit = '||p_commit);
1054: IBE_UTIL.debug('p_source_msite_id = '||p_msite_rec.msite_id);
1055: IBE_UTIL.debug('p_display_name = '||p_msite_rec.display_name);

Line 1052: IBE_UTIL.debug('p_init_msg_list = '||p_init_msg_list);

1048:
1049: IF (l_debug = 'Y') THEN
1050: IBE_UTIL.debug('duplicate_msite Starts +');
1051: IBE_UTIL.debug('p_api_version = '||p_api_version);
1052: IBE_UTIL.debug('p_init_msg_list = '||p_init_msg_list);
1053: IBE_UTIL.debug('p_commit = '||p_commit);
1054: IBE_UTIL.debug('p_source_msite_id = '||p_msite_rec.msite_id);
1055: IBE_UTIL.debug('p_display_name = '||p_msite_rec.display_name);
1056: IBE_UTIL.debug('p_access_name = '||p_msite_rec.access_name);

Line 1053: IBE_UTIL.debug('p_commit = '||p_commit);

1049: IF (l_debug = 'Y') THEN
1050: IBE_UTIL.debug('duplicate_msite Starts +');
1051: IBE_UTIL.debug('p_api_version = '||p_api_version);
1052: IBE_UTIL.debug('p_init_msg_list = '||p_init_msg_list);
1053: IBE_UTIL.debug('p_commit = '||p_commit);
1054: IBE_UTIL.debug('p_source_msite_id = '||p_msite_rec.msite_id);
1055: IBE_UTIL.debug('p_display_name = '||p_msite_rec.display_name);
1056: IBE_UTIL.debug('p_access_name = '||p_msite_rec.access_name);
1057: IBE_UTIL.debug('p_description = '||p_msite_rec.description);

Line 1054: IBE_UTIL.debug('p_source_msite_id = '||p_msite_rec.msite_id);

1050: IBE_UTIL.debug('duplicate_msite Starts +');
1051: IBE_UTIL.debug('p_api_version = '||p_api_version);
1052: IBE_UTIL.debug('p_init_msg_list = '||p_init_msg_list);
1053: IBE_UTIL.debug('p_commit = '||p_commit);
1054: IBE_UTIL.debug('p_source_msite_id = '||p_msite_rec.msite_id);
1055: IBE_UTIL.debug('p_display_name = '||p_msite_rec.display_name);
1056: IBE_UTIL.debug('p_access_name = '||p_msite_rec.access_name);
1057: IBE_UTIL.debug('p_description = '||p_msite_rec.description);
1058: IBE_UTIL.debug('p_default_language_code = '||p_default_language_code);

Line 1055: IBE_UTIL.debug('p_display_name = '||p_msite_rec.display_name);

1051: IBE_UTIL.debug('p_api_version = '||p_api_version);
1052: IBE_UTIL.debug('p_init_msg_list = '||p_init_msg_list);
1053: IBE_UTIL.debug('p_commit = '||p_commit);
1054: IBE_UTIL.debug('p_source_msite_id = '||p_msite_rec.msite_id);
1055: IBE_UTIL.debug('p_display_name = '||p_msite_rec.display_name);
1056: IBE_UTIL.debug('p_access_name = '||p_msite_rec.access_name);
1057: IBE_UTIL.debug('p_description = '||p_msite_rec.description);
1058: IBE_UTIL.debug('p_default_language_code = '||p_default_language_code);
1059: IBE_UTIL.debug('p_default_currency_code = '||p_default_currency_code);

Line 1056: IBE_UTIL.debug('p_access_name = '||p_msite_rec.access_name);

1052: IBE_UTIL.debug('p_init_msg_list = '||p_init_msg_list);
1053: IBE_UTIL.debug('p_commit = '||p_commit);
1054: IBE_UTIL.debug('p_source_msite_id = '||p_msite_rec.msite_id);
1055: IBE_UTIL.debug('p_display_name = '||p_msite_rec.display_name);
1056: IBE_UTIL.debug('p_access_name = '||p_msite_rec.access_name);
1057: IBE_UTIL.debug('p_description = '||p_msite_rec.description);
1058: IBE_UTIL.debug('p_default_language_code = '||p_default_language_code);
1059: IBE_UTIL.debug('p_default_currency_code = '||p_default_currency_code);
1060: IBE_UTIL.debug('p_walkin_pricing_id = '||p_walkin_pricing_id);

Line 1057: IBE_UTIL.debug('p_description = '||p_msite_rec.description);

1053: IBE_UTIL.debug('p_commit = '||p_commit);
1054: IBE_UTIL.debug('p_source_msite_id = '||p_msite_rec.msite_id);
1055: IBE_UTIL.debug('p_display_name = '||p_msite_rec.display_name);
1056: IBE_UTIL.debug('p_access_name = '||p_msite_rec.access_name);
1057: IBE_UTIL.debug('p_description = '||p_msite_rec.description);
1058: IBE_UTIL.debug('p_default_language_code = '||p_default_language_code);
1059: IBE_UTIL.debug('p_default_currency_code = '||p_default_currency_code);
1060: IBE_UTIL.debug('p_walkin_pricing_id = '||p_walkin_pricing_id);
1061: IBE_UTIL.debug('p_start_date_active = '||p_msite_rec.start_date_active);

Line 1058: IBE_UTIL.debug('p_default_language_code = '||p_default_language_code);

1054: IBE_UTIL.debug('p_source_msite_id = '||p_msite_rec.msite_id);
1055: IBE_UTIL.debug('p_display_name = '||p_msite_rec.display_name);
1056: IBE_UTIL.debug('p_access_name = '||p_msite_rec.access_name);
1057: IBE_UTIL.debug('p_description = '||p_msite_rec.description);
1058: IBE_UTIL.debug('p_default_language_code = '||p_default_language_code);
1059: IBE_UTIL.debug('p_default_currency_code = '||p_default_currency_code);
1060: IBE_UTIL.debug('p_walkin_pricing_id = '||p_walkin_pricing_id);
1061: IBE_UTIL.debug('p_start_date_active = '||p_msite_rec.start_date_active);
1062: IBE_UTIL.debug('p_end_date_active = '||p_msite_rec.end_date_active);

Line 1059: IBE_UTIL.debug('p_default_currency_code = '||p_default_currency_code);

1055: IBE_UTIL.debug('p_display_name = '||p_msite_rec.display_name);
1056: IBE_UTIL.debug('p_access_name = '||p_msite_rec.access_name);
1057: IBE_UTIL.debug('p_description = '||p_msite_rec.description);
1058: IBE_UTIL.debug('p_default_language_code = '||p_default_language_code);
1059: IBE_UTIL.debug('p_default_currency_code = '||p_default_currency_code);
1060: IBE_UTIL.debug('p_walkin_pricing_id = '||p_walkin_pricing_id);
1061: IBE_UTIL.debug('p_start_date_active = '||p_msite_rec.start_date_active);
1062: IBE_UTIL.debug('p_end_date_active = '||p_msite_rec.end_date_active);
1063: IBE_UTIL.debug('p_msite_root_section_id = '||p_msite_rec.msite_root_section_id);

Line 1060: IBE_UTIL.debug('p_walkin_pricing_id = '||p_walkin_pricing_id);

1056: IBE_UTIL.debug('p_access_name = '||p_msite_rec.access_name);
1057: IBE_UTIL.debug('p_description = '||p_msite_rec.description);
1058: IBE_UTIL.debug('p_default_language_code = '||p_default_language_code);
1059: IBE_UTIL.debug('p_default_currency_code = '||p_default_currency_code);
1060: IBE_UTIL.debug('p_walkin_pricing_id = '||p_walkin_pricing_id);
1061: IBE_UTIL.debug('p_start_date_active = '||p_msite_rec.start_date_active);
1062: IBE_UTIL.debug('p_end_date_active = '||p_msite_rec.end_date_active);
1063: IBE_UTIL.debug('p_msite_root_section_id = '||p_msite_rec.msite_root_section_id);
1064: IBE_UTIL.debug('p_walkin_allowed_code = '||p_msite_rec.walkin_allowed_code);

Line 1061: IBE_UTIL.debug('p_start_date_active = '||p_msite_rec.start_date_active);

1057: IBE_UTIL.debug('p_description = '||p_msite_rec.description);
1058: IBE_UTIL.debug('p_default_language_code = '||p_default_language_code);
1059: IBE_UTIL.debug('p_default_currency_code = '||p_default_currency_code);
1060: IBE_UTIL.debug('p_walkin_pricing_id = '||p_walkin_pricing_id);
1061: IBE_UTIL.debug('p_start_date_active = '||p_msite_rec.start_date_active);
1062: IBE_UTIL.debug('p_end_date_active = '||p_msite_rec.end_date_active);
1063: IBE_UTIL.debug('p_msite_root_section_id = '||p_msite_rec.msite_root_section_id);
1064: IBE_UTIL.debug('p_walkin_allowed_code = '||p_msite_rec.walkin_allowed_code);
1065: IBE_UTIL.debug('p_atp_check_flag = '||p_msite_rec.atp_check_flag);

Line 1062: IBE_UTIL.debug('p_end_date_active = '||p_msite_rec.end_date_active);

1058: IBE_UTIL.debug('p_default_language_code = '||p_default_language_code);
1059: IBE_UTIL.debug('p_default_currency_code = '||p_default_currency_code);
1060: IBE_UTIL.debug('p_walkin_pricing_id = '||p_walkin_pricing_id);
1061: IBE_UTIL.debug('p_start_date_active = '||p_msite_rec.start_date_active);
1062: IBE_UTIL.debug('p_end_date_active = '||p_msite_rec.end_date_active);
1063: IBE_UTIL.debug('p_msite_root_section_id = '||p_msite_rec.msite_root_section_id);
1064: IBE_UTIL.debug('p_walkin_allowed_code = '||p_msite_rec.walkin_allowed_code);
1065: IBE_UTIL.debug('p_atp_check_flag = '||p_msite_rec.atp_check_flag);
1066: IBE_UTIL.debug('p_resp_access_flag = '||p_msite_rec.resp_access_flag);

Line 1063: IBE_UTIL.debug('p_msite_root_section_id = '||p_msite_rec.msite_root_section_id);

1059: IBE_UTIL.debug('p_default_currency_code = '||p_default_currency_code);
1060: IBE_UTIL.debug('p_walkin_pricing_id = '||p_walkin_pricing_id);
1061: IBE_UTIL.debug('p_start_date_active = '||p_msite_rec.start_date_active);
1062: IBE_UTIL.debug('p_end_date_active = '||p_msite_rec.end_date_active);
1063: IBE_UTIL.debug('p_msite_root_section_id = '||p_msite_rec.msite_root_section_id);
1064: IBE_UTIL.debug('p_walkin_allowed_code = '||p_msite_rec.walkin_allowed_code);
1065: IBE_UTIL.debug('p_atp_check_flag = '||p_msite_rec.atp_check_flag);
1066: IBE_UTIL.debug('p_resp_access_flag = '||p_msite_rec.resp_access_flag);
1067: IBE_UTIL.debug('p_payment_thresh_enable_flag = '||p_msite_rec.payment_threshold_enable_flag);

Line 1064: IBE_UTIL.debug('p_walkin_allowed_code = '||p_msite_rec.walkin_allowed_code);

1060: IBE_UTIL.debug('p_walkin_pricing_id = '||p_walkin_pricing_id);
1061: IBE_UTIL.debug('p_start_date_active = '||p_msite_rec.start_date_active);
1062: IBE_UTIL.debug('p_end_date_active = '||p_msite_rec.end_date_active);
1063: IBE_UTIL.debug('p_msite_root_section_id = '||p_msite_rec.msite_root_section_id);
1064: IBE_UTIL.debug('p_walkin_allowed_code = '||p_msite_rec.walkin_allowed_code);
1065: IBE_UTIL.debug('p_atp_check_flag = '||p_msite_rec.atp_check_flag);
1066: IBE_UTIL.debug('p_resp_access_flag = '||p_msite_rec.resp_access_flag);
1067: IBE_UTIL.debug('p_payment_thresh_enable_flag = '||p_msite_rec.payment_threshold_enable_flag);
1068: IBE_UTIL.debug('p_domain_name = '||p_msite_rec.domain_name);

Line 1065: IBE_UTIL.debug('p_atp_check_flag = '||p_msite_rec.atp_check_flag);

1061: IBE_UTIL.debug('p_start_date_active = '||p_msite_rec.start_date_active);
1062: IBE_UTIL.debug('p_end_date_active = '||p_msite_rec.end_date_active);
1063: IBE_UTIL.debug('p_msite_root_section_id = '||p_msite_rec.msite_root_section_id);
1064: IBE_UTIL.debug('p_walkin_allowed_code = '||p_msite_rec.walkin_allowed_code);
1065: IBE_UTIL.debug('p_atp_check_flag = '||p_msite_rec.atp_check_flag);
1066: IBE_UTIL.debug('p_resp_access_flag = '||p_msite_rec.resp_access_flag);
1067: IBE_UTIL.debug('p_payment_thresh_enable_flag = '||p_msite_rec.payment_threshold_enable_flag);
1068: IBE_UTIL.debug('p_domain_name = '||p_msite_rec.domain_name);
1069: IBE_UTIL.debug('p_enable_traffic_filter = '||p_msite_rec.enable_traffic_filter);

Line 1066: IBE_UTIL.debug('p_resp_access_flag = '||p_msite_rec.resp_access_flag);

1062: IBE_UTIL.debug('p_end_date_active = '||p_msite_rec.end_date_active);
1063: IBE_UTIL.debug('p_msite_root_section_id = '||p_msite_rec.msite_root_section_id);
1064: IBE_UTIL.debug('p_walkin_allowed_code = '||p_msite_rec.walkin_allowed_code);
1065: IBE_UTIL.debug('p_atp_check_flag = '||p_msite_rec.atp_check_flag);
1066: IBE_UTIL.debug('p_resp_access_flag = '||p_msite_rec.resp_access_flag);
1067: IBE_UTIL.debug('p_payment_thresh_enable_flag = '||p_msite_rec.payment_threshold_enable_flag);
1068: IBE_UTIL.debug('p_domain_name = '||p_msite_rec.domain_name);
1069: IBE_UTIL.debug('p_enable_traffic_filter = '||p_msite_rec.enable_traffic_filter);
1070: IBE_UTIL.debug('p_reporting_status = '||p_msite_rec.reporting_status);

Line 1067: IBE_UTIL.debug('p_payment_thresh_enable_flag = '||p_msite_rec.payment_threshold_enable_flag);

1063: IBE_UTIL.debug('p_msite_root_section_id = '||p_msite_rec.msite_root_section_id);
1064: IBE_UTIL.debug('p_walkin_allowed_code = '||p_msite_rec.walkin_allowed_code);
1065: IBE_UTIL.debug('p_atp_check_flag = '||p_msite_rec.atp_check_flag);
1066: IBE_UTIL.debug('p_resp_access_flag = '||p_msite_rec.resp_access_flag);
1067: IBE_UTIL.debug('p_payment_thresh_enable_flag = '||p_msite_rec.payment_threshold_enable_flag);
1068: IBE_UTIL.debug('p_domain_name = '||p_msite_rec.domain_name);
1069: IBE_UTIL.debug('p_enable_traffic_filter = '||p_msite_rec.enable_traffic_filter);
1070: IBE_UTIL.debug('p_reporting_status = '||p_msite_rec.reporting_status);
1071: IBE_UTIL.debug('p_site_type = '||p_msite_rec.site_type);

Line 1068: IBE_UTIL.debug('p_domain_name = '||p_msite_rec.domain_name);

1064: IBE_UTIL.debug('p_walkin_allowed_code = '||p_msite_rec.walkin_allowed_code);
1065: IBE_UTIL.debug('p_atp_check_flag = '||p_msite_rec.atp_check_flag);
1066: IBE_UTIL.debug('p_resp_access_flag = '||p_msite_rec.resp_access_flag);
1067: IBE_UTIL.debug('p_payment_thresh_enable_flag = '||p_msite_rec.payment_threshold_enable_flag);
1068: IBE_UTIL.debug('p_domain_name = '||p_msite_rec.domain_name);
1069: IBE_UTIL.debug('p_enable_traffic_filter = '||p_msite_rec.enable_traffic_filter);
1070: IBE_UTIL.debug('p_reporting_status = '||p_msite_rec.reporting_status);
1071: IBE_UTIL.debug('p_site_type = '||p_msite_rec.site_type);
1072: END IF;

Line 1069: IBE_UTIL.debug('p_enable_traffic_filter = '||p_msite_rec.enable_traffic_filter);

1065: IBE_UTIL.debug('p_atp_check_flag = '||p_msite_rec.atp_check_flag);
1066: IBE_UTIL.debug('p_resp_access_flag = '||p_msite_rec.resp_access_flag);
1067: IBE_UTIL.debug('p_payment_thresh_enable_flag = '||p_msite_rec.payment_threshold_enable_flag);
1068: IBE_UTIL.debug('p_domain_name = '||p_msite_rec.domain_name);
1069: IBE_UTIL.debug('p_enable_traffic_filter = '||p_msite_rec.enable_traffic_filter);
1070: IBE_UTIL.debug('p_reporting_status = '||p_msite_rec.reporting_status);
1071: IBE_UTIL.debug('p_site_type = '||p_msite_rec.site_type);
1072: END IF;
1073: IF NOT FND_API.Compatible_API_Call(l_api_version,

Line 1070: IBE_UTIL.debug('p_reporting_status = '||p_msite_rec.reporting_status);

1066: IBE_UTIL.debug('p_resp_access_flag = '||p_msite_rec.resp_access_flag);
1067: IBE_UTIL.debug('p_payment_thresh_enable_flag = '||p_msite_rec.payment_threshold_enable_flag);
1068: IBE_UTIL.debug('p_domain_name = '||p_msite_rec.domain_name);
1069: IBE_UTIL.debug('p_enable_traffic_filter = '||p_msite_rec.enable_traffic_filter);
1070: IBE_UTIL.debug('p_reporting_status = '||p_msite_rec.reporting_status);
1071: IBE_UTIL.debug('p_site_type = '||p_msite_rec.site_type);
1072: END IF;
1073: IF NOT FND_API.Compatible_API_Call(l_api_version,
1074: p_api_version,

Line 1071: IBE_UTIL.debug('p_site_type = '||p_msite_rec.site_type);

1067: IBE_UTIL.debug('p_payment_thresh_enable_flag = '||p_msite_rec.payment_threshold_enable_flag);
1068: IBE_UTIL.debug('p_domain_name = '||p_msite_rec.domain_name);
1069: IBE_UTIL.debug('p_enable_traffic_filter = '||p_msite_rec.enable_traffic_filter);
1070: IBE_UTIL.debug('p_reporting_status = '||p_msite_rec.reporting_status);
1071: IBE_UTIL.debug('p_site_type = '||p_msite_rec.site_type);
1072: END IF;
1073: IF NOT FND_API.Compatible_API_Call(l_api_version,
1074: p_api_version,
1075: l_api_name,

Line 1123: IBE_UTIL.debug('Error in IBE_MSite_GRP.save_msite');

1119: x_msg_data => l_msg_data,
1120: p_msite_rec => l_msite_rec);
1121: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1122: IF (l_debug = 'Y') THEN
1123: IBE_UTIL.debug('Error in IBE_MSite_GRP.save_msite');
1124: for i in 1..l_msg_count loop
1125: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
1126: IBE_UTIL.debug(l_msg_data);
1127: end loop;

Line 1126: IBE_UTIL.debug(l_msg_data);

1122: IF (l_debug = 'Y') THEN
1123: IBE_UTIL.debug('Error in IBE_MSite_GRP.save_msite');
1124: for i in 1..l_msg_count loop
1125: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
1126: IBE_UTIL.debug(l_msg_data);
1127: end loop;
1128: END IF;
1129: RAISE FND_API.G_EXC_ERROR;
1130: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1132: IBE_UTIL.debug('Error in IBE_MSite_GRP.save_msite');

1128: END IF;
1129: RAISE FND_API.G_EXC_ERROR;
1130: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1131: IF (l_debug = 'Y') THEN
1132: IBE_UTIL.debug('Error in IBE_MSite_GRP.save_msite');
1133: for i in 1..l_msg_count loop
1134: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
1135: IBE_UTIL.debug(l_msg_data);
1136: end loop;

Line 1135: IBE_UTIL.debug(l_msg_data);

1131: IF (l_debug = 'Y') THEN
1132: IBE_UTIL.debug('Error in IBE_MSite_GRP.save_msite');
1133: for i in 1..l_msg_count loop
1134: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
1135: IBE_UTIL.debug(l_msg_data);
1136: end loop;
1137: END IF;
1138: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1139: END IF;

Line 1185: IBE_UTIL.debug('Error in IBE_MSite_GRP.save_msite_languages');

1181: p_msite_id => l_msite_id,
1182: p_msite_languages_tbl => l_msite_languages_tbl);
1183: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1184: IF (l_debug = 'Y') THEN
1185: IBE_UTIL.debug('Error in IBE_MSite_GRP.save_msite_languages');
1186: for i in 1..l_msg_count loop
1187: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
1188: IBE_UTIL.debug(l_msg_data);
1189: end loop;

Line 1188: IBE_UTIL.debug(l_msg_data);

1184: IF (l_debug = 'Y') THEN
1185: IBE_UTIL.debug('Error in IBE_MSite_GRP.save_msite_languages');
1186: for i in 1..l_msg_count loop
1187: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
1188: IBE_UTIL.debug(l_msg_data);
1189: end loop;
1190: END IF;
1191: RAISE FND_API.G_EXC_ERROR;
1192: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1194: IBE_UTIL.debug('Error in IBE_MSite_GRP.save_msite_languages');

1190: END IF;
1191: RAISE FND_API.G_EXC_ERROR;
1192: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1193: IF (l_debug = 'Y') THEN
1194: IBE_UTIL.debug('Error in IBE_MSite_GRP.save_msite_languages');
1195: for i in 1..l_msg_count loop
1196: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
1197: IBE_UTIL.debug(l_msg_data);
1198: end loop;

Line 1197: IBE_UTIL.debug(l_msg_data);

1193: IF (l_debug = 'Y') THEN
1194: IBE_UTIL.debug('Error in IBE_MSite_GRP.save_msite_languages');
1195: for i in 1..l_msg_count loop
1196: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
1197: IBE_UTIL.debug(l_msg_data);
1198: end loop;
1199: END IF;
1200: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1201: END IF;

Line 1285: IBE_UTIL.debug('Error in IBE_MSite_GRP.save_msite_currencies');

1281: p_msite_id => l_msite_id,
1282: p_msite_currencies_tbl => l_msite_currencies_tbl);
1283: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1284: IF (l_debug = 'Y') THEN
1285: IBE_UTIL.debug('Error in IBE_MSite_GRP.save_msite_currencies');
1286: for i in 1..l_msg_count loop
1287: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
1288: IBE_UTIL.debug(l_msg_data);
1289: end loop;

Line 1288: IBE_UTIL.debug(l_msg_data);

1284: IF (l_debug = 'Y') THEN
1285: IBE_UTIL.debug('Error in IBE_MSite_GRP.save_msite_currencies');
1286: for i in 1..l_msg_count loop
1287: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
1288: IBE_UTIL.debug(l_msg_data);
1289: end loop;
1290: END IF;
1291: RAISE FND_API.G_EXC_ERROR;
1292: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1294: IBE_UTIL.debug('Error in IBE_MSite_GRP.save_msite_currencies');

1290: END IF;
1291: RAISE FND_API.G_EXC_ERROR;
1292: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1293: IF (l_debug = 'Y') THEN
1294: IBE_UTIL.debug('Error in IBE_MSite_GRP.save_msite_currencies');
1295: for i in 1..l_msg_count loop
1296: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
1297: IBE_UTIL.debug(l_msg_data);
1298: end loop;

Line 1297: IBE_UTIL.debug(l_msg_data);

1293: IF (l_debug = 'Y') THEN
1294: IBE_UTIL.debug('Error in IBE_MSite_GRP.save_msite_currencies');
1295: for i in 1..l_msg_count loop
1296: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
1297: IBE_UTIL.debug(l_msg_data);
1298: end loop;
1299: END IF;
1300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1301: END IF;

Line 1317: IBE_UTIL.debug('Error in IBE_MSITE_INFORMATION_MGR_PVT.'||

1313: x_msg_data => l_msg_data
1314: );
1315: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1316: IF (l_debug = 'Y') THEN
1317: IBE_UTIL.debug('Error in IBE_MSITE_INFORMATION_MGR_PVT.'||
1318: 'Change_Msite_Info');
1319: for i in 1..l_msg_count loop
1320: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
1321: IBE_UTIL.debug(l_msg_data);

Line 1321: IBE_UTIL.debug(l_msg_data);

1317: IBE_UTIL.debug('Error in IBE_MSITE_INFORMATION_MGR_PVT.'||
1318: 'Change_Msite_Info');
1319: for i in 1..l_msg_count loop
1320: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
1321: IBE_UTIL.debug(l_msg_data);
1322: end loop;
1323: END IF;
1324: RAISE FND_API.G_EXC_ERROR;
1325: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1327: IBE_UTIL.debug('Error in IBE_MSITE_INFORMATION_MGR_PVT.'||

1323: END IF;
1324: RAISE FND_API.G_EXC_ERROR;
1325: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1326: IF (l_debug = 'Y') THEN
1327: IBE_UTIL.debug('Error in IBE_MSITE_INFORMATION_MGR_PVT.'||
1328: 'Change_Msite_Info');
1329: for i in 1..l_msg_count loop
1330: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
1331: IBE_UTIL.debug(l_msg_data);

Line 1331: IBE_UTIL.debug(l_msg_data);

1327: IBE_UTIL.debug('Error in IBE_MSITE_INFORMATION_MGR_PVT.'||
1328: 'Change_Msite_Info');
1329: for i in 1..l_msg_count loop
1330: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
1331: IBE_UTIL.debug(l_msg_data);
1332: end loop;
1333: END IF;
1334: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1335: END IF;

Line 1398: IBE_UTIL.debug('Error in IBE_Msite_Resp_Pvt.Create_Msite_Resp');

1394: x_msg_data => l_msg_data);
1395: END IF;
1396: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1397: IF (l_debug = 'Y') THEN
1398: IBE_UTIL.debug('Error in IBE_Msite_Resp_Pvt.Create_Msite_Resp');
1399: for i in 1..l_msg_count loop
1400: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
1401: IBE_UTIL.debug(l_msg_data);
1402: end loop;

Line 1401: IBE_UTIL.debug(l_msg_data);

1397: IF (l_debug = 'Y') THEN
1398: IBE_UTIL.debug('Error in IBE_Msite_Resp_Pvt.Create_Msite_Resp');
1399: for i in 1..l_msg_count loop
1400: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
1401: IBE_UTIL.debug(l_msg_data);
1402: end loop;
1403: END IF;
1404: RAISE FND_API.G_EXC_ERROR;
1405: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1407: IBE_UTIL.debug('Error in IBE_Msite_Resp_Pvt.Create_Msite_Resp');

1403: END IF;
1404: RAISE FND_API.G_EXC_ERROR;
1405: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1406: IF (l_debug = 'Y') THEN
1407: IBE_UTIL.debug('Error in IBE_Msite_Resp_Pvt.Create_Msite_Resp');
1408: for i in 1..l_msg_count loop
1409: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
1410: IBE_UTIL.debug(l_msg_data);
1411: end loop;

Line 1410: IBE_UTIL.debug(l_msg_data);

1406: IF (l_debug = 'Y') THEN
1407: IBE_UTIL.debug('Error in IBE_Msite_Resp_Pvt.Create_Msite_Resp');
1408: for i in 1..l_msg_count loop
1409: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
1410: IBE_UTIL.debug(l_msg_data);
1411: end loop;
1412: END IF;
1413: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1414: END IF;

Line 1455: IBE_UTIL.debug('Error in IBE_MSite_GRP.save_msite_currencies');

1451: x_msg_count => l_msg_count,
1452: x_msg_data => l_msg_data);
1453: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1454: IF (l_debug = 'Y') THEN
1455: IBE_UTIL.debug('Error in IBE_MSite_GRP.save_msite_currencies');
1456: for i in 1..l_msg_count loop
1457: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
1458: IBE_UTIL.debug(l_msg_data);
1459: end loop;

Line 1458: IBE_UTIL.debug(l_msg_data);

1454: IF (l_debug = 'Y') THEN
1455: IBE_UTIL.debug('Error in IBE_MSite_GRP.save_msite_currencies');
1456: for i in 1..l_msg_count loop
1457: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
1458: IBE_UTIL.debug(l_msg_data);
1459: end loop;
1460: END IF;
1461: RAISE FND_API.G_EXC_ERROR;
1462: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1464: IBE_UTIL.debug('Error in IBE_MSite_GRP.save_msite_currencies');

1460: END IF;
1461: RAISE FND_API.G_EXC_ERROR;
1462: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1463: IF (l_debug = 'Y') THEN
1464: IBE_UTIL.debug('Error in IBE_MSite_GRP.save_msite_currencies');
1465: for i in 1..l_msg_count loop
1466: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
1467: IBE_UTIL.debug(l_msg_data);
1468: end loop;

Line 1467: IBE_UTIL.debug(l_msg_data);

1463: IF (l_debug = 'Y') THEN
1464: IBE_UTIL.debug('Error in IBE_MSite_GRP.save_msite_currencies');
1465: for i in 1..l_msg_count loop
1466: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
1467: IBE_UTIL.debug(l_msg_data);
1468: end loop;
1469: END IF;
1470: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1471: END IF;

Line 1475: IBE_UTIL.debug('Before committing the work:'||p_commit);

1471: END IF;
1472: END IF;
1473:
1474: IF (l_debug = 'Y') THEN
1475: IBE_UTIL.debug('Before committing the work:'||p_commit);
1476: END IF;
1477: IF (FND_API.To_Boolean(p_commit)) THEN
1478: COMMIT WORK;
1479: END IF;

Line 1484: IBE_UTIL.debug('duplicate_msite Ends +');

1480: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1481: p_data => x_msg_data,
1482: p_encoded => 'F');
1483: IF (l_debug = 'Y') THEN
1484: IBE_UTIL.debug('duplicate_msite Ends +');
1485: END IF;
1486: EXCEPTION
1487: WHEN FND_API.G_EXC_ERROR THEN
1488: ROLLBACK TO DUPLICATE_MSITE_SAVE;

Line 1507: IBE_UTIL.debug('SQLCODE:'||SQLCODE);

1503: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1504: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1505: FND_MSG_PUB.Add;
1506: IF (l_debug = 'Y') THEN
1507: IBE_UTIL.debug('SQLCODE:'||SQLCODE);
1508: IBE_UTIL.debug('SQLERRM:'||SQLERRM);
1509: END IF;
1510: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1511: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 1508: IBE_UTIL.debug('SQLERRM:'||SQLERRM);

1504: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1505: FND_MSG_PUB.Add;
1506: IF (l_debug = 'Y') THEN
1507: IBE_UTIL.debug('SQLCODE:'||SQLCODE);
1508: IBE_UTIL.debug('SQLERRM:'||SQLERRM);
1509: END IF;
1510: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1511: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1512: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);