76: -- Bug:6268452. Due to DMZ issue, we need to make sure that Buyer's URL come from internal website. Since Site level Profile always maintain the internal URL, so we get the site level profile first.
77: l_base_url := get_site_level_profile_value('APPS_FRAMEWORK_AGENT');
78:
79: IF (g_fnd_debug = 'Y') THEN
80: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
81: FND_LOG.string(log_level => FND_LOG.level_statement,
82: module => g_module_prefix || l_api_name,
83: message => 'After calling get_site_level_profile_value. l_base_url='
84: || l_base_url);
77: l_base_url := get_site_level_profile_value('APPS_FRAMEWORK_AGENT');
78:
79: IF (g_fnd_debug = 'Y') THEN
80: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
81: FND_LOG.string(log_level => FND_LOG.level_statement,
82: module => g_module_prefix || l_api_name,
83: message => 'After calling get_site_level_profile_value. l_base_url='
84: || l_base_url);
85: END IF;
87:
88: if (l_base_url is null) then
89: l_base_url := FND_PROFILE.value('APPS_FRAMEWORK_AGENT');
90: IF (g_fnd_debug = 'Y') THEN
91: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
92: FND_LOG.string(log_level => FND_LOG.level_statement,
93: module => g_module_prefix || l_api_name,
94: message => 'get_site_level_profile return NULL. After calling FND_PROFILE.value(); l_base_url='
95: || l_base_url);
88: if (l_base_url is null) then
89: l_base_url := FND_PROFILE.value('APPS_FRAMEWORK_AGENT');
90: IF (g_fnd_debug = 'Y') THEN
91: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
92: FND_LOG.string(log_level => FND_LOG.level_statement,
93: module => g_module_prefix || l_api_name,
94: message => 'get_site_level_profile return NULL. After calling FND_PROFILE.value(); l_base_url='
95: || l_base_url);
96: END IF;
232: l_menu_function_parameter_rec menu_function_parameter_rec;
233:
234: BEGIN
235:
236: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
237: FND_LOG.string(log_level => FND_LOG.level_statement,
238: module => g_module_prefix || 'get_dest_page_url',
239: message => 'Entered the procedure with p_dest_func : ' || p_dest_func || '; p_notif_performer : ' || p_notif_performer);
240: END IF; --}
233:
234: BEGIN
235:
236: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
237: FND_LOG.string(log_level => FND_LOG.level_statement,
238: module => g_module_prefix || 'get_dest_page_url',
239: message => 'Entered the procedure with p_dest_func : ' || p_dest_func || '; p_notif_performer : ' || p_notif_performer);
240: END IF; --}
241:
259: --Bug 6369383 : Add language Code
260: -- This fix assumes that the caller of this procedure sets the language appropriately
261: -- before making the call. The userenv language will be taken and set as the language code
262:
263: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
264: FND_LOG.string(log_level => FND_LOG.level_statement,
265: module => g_module_prefix || 'get_dest_page_url',
266: message => 'Adding language_code ; fnd_global.current_language : ' || fnd_global.current_language);
267: END IF; --}
260: -- This fix assumes that the caller of this procedure sets the language appropriately
261: -- before making the call. The userenv language will be taken and set as the language code
262:
263: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
264: FND_LOG.string(log_level => FND_LOG.level_statement,
265: module => g_module_prefix || 'get_dest_page_url',
266: message => 'Adding language_code ; fnd_global.current_language : ' || fnd_global.current_language);
267: END IF; --}
268:
269: l_url_parameters_tab(6).name := 'language_code';
270: l_url_parameters_tab(6).value := fnd_global.current_language; --userenv('LANG');
271:
272:
273: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
274: FND_LOG.string(log_level => FND_LOG.level_statement,
275: module => g_module_prefix || 'get_dest_page_url',
276: message => 'fnd_global.current_language : ' || fnd_global.current_language);
277: END IF; --}
270: l_url_parameters_tab(6).value := fnd_global.current_language; --userenv('LANG');
271:
272:
273: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
274: FND_LOG.string(log_level => FND_LOG.level_statement,
275: module => g_module_prefix || 'get_dest_page_url',
276: message => 'fnd_global.current_language : ' || fnd_global.current_language);
277: END IF; --}
278:
752:
753: BEGIN
754:
755: IF (g_fnd_debug = 'Y') THEN
756: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
757: FND_LOG.string(log_level => FND_LOG.level_statement,
758: module => g_module_prefix || l_api_name,
759: message => 'BEGIN: Check WF preference for'
760: || p_wf_message_name || ' for auction '
753: BEGIN
754:
755: IF (g_fnd_debug = 'Y') THEN
756: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
757: FND_LOG.string(log_level => FND_LOG.level_statement,
758: module => g_module_prefix || l_api_name,
759: message => 'BEGIN: Check WF preference for'
760: || p_wf_message_name || ' for auction '
761: || p_auction_id);
780: -- this is an unnatural event
781: --
782: WHEN OTHERS THEN
783: IF (g_fnd_debug = 'Y') THEN
784: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN
785: FND_LOG.string(log_level => FND_LOG.level_exception,
786: module => g_module_prefix || l_api_name,
787: message => 'EXCEPTION: Check WF preference for'
788: || p_wf_message_name || ' for auction '
781: --
782: WHEN OTHERS THEN
783: IF (g_fnd_debug = 'Y') THEN
784: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN
785: FND_LOG.string(log_level => FND_LOG.level_exception,
786: module => g_module_prefix || l_api_name,
787: message => 'EXCEPTION: Check WF preference for'
788: || p_wf_message_name || ' for auction '
789: || p_auction_id);
823:
824: BEGIN
825:
826: IF (g_fnd_debug = 'Y') THEN
827: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
828:
829: FND_LOG.string(log_level => FND_LOG.level_statement,
830: module => g_module_prefix || l_api_name,
831: message => 'BEGIN: Check WF preference for'
825:
826: IF (g_fnd_debug = 'Y') THEN
827: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
828:
829: FND_LOG.string(log_level => FND_LOG.level_statement,
830: module => g_module_prefix || l_api_name,
831: message => 'BEGIN: Check WF preference for'
832: || p_wf_message_name || ' for doctype '
833: || p_doctype);
847: AND notifMessages.NOTIF_MESSAGE_NAME = P_WF_MESSAGE_NAME;
848:
849:
850: IF (g_fnd_debug = 'Y') THEN
851: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
852: FND_LOG.string(log_level => FND_LOG.level_statement,
853: module => g_module_prefix || l_api_name,
854: message => 'BEGIN: Check WF preference for'
855: || p_wf_message_name || ' for doctype '
848:
849:
850: IF (g_fnd_debug = 'Y') THEN
851: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
852: FND_LOG.string(log_level => FND_LOG.level_statement,
853: module => g_module_prefix || l_api_name,
854: message => 'BEGIN: Check WF preference for'
855: || p_wf_message_name || ' for doctype '
856: || p_doctype || ' with return value '
874: -- not to be subscribed message. Hence, return true i.e.
875: -- the older behavior
876: --
877: IF (g_fnd_debug = 'Y') THEN
878: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN
879: FND_LOG.string(log_level => FND_LOG.level_exception,
880: module => g_module_prefix || l_api_name,
881: message => 'EXCEPTION: NO DATA FOUND for message name:'
882: || p_wf_message_name || ' for doctype '
875: -- the older behavior
876: --
877: IF (g_fnd_debug = 'Y') THEN
878: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN
879: FND_LOG.string(log_level => FND_LOG.level_exception,
880: module => g_module_prefix || l_api_name,
881: message => 'EXCEPTION: NO DATA FOUND for message name:'
882: || p_wf_message_name || ' for doctype '
883: || p_doctype);
890: -- Chances are rare but if any such error happens then it will simply
891: -- raise the error to the upper level
892: --
893: IF (g_fnd_debug = 'Y') THEN
894: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN
895: FND_LOG.string(log_level => FND_LOG.level_exception,
896: module => g_module_prefix || l_api_name,
897: message => 'EXCEPTION:Check WF preference for '
898: || P_WF_MESSAGE_NAME
891: -- raise the error to the upper level
892: --
893: IF (g_fnd_debug = 'Y') THEN
894: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN
895: FND_LOG.string(log_level => FND_LOG.level_exception,
896: module => g_module_prefix || l_api_name,
897: message => 'EXCEPTION:Check WF preference for '
898: || P_WF_MESSAGE_NAME
899: || ' for doctype '
1023: -- Bug:6261134. Due to DMZ issue, we need to make sure that Buyer's URL come from internal website. Since Site level Profile always maintain the internal URL, so we get the site level profile first.
1024: l_base_url := get_site_level_profile_value('APPS_FRAMEWORK_AGENT');
1025:
1026: IF (g_fnd_debug = 'Y') THEN
1027: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1028: FND_LOG.string(log_level => FND_LOG.level_statement,
1029: module => g_module_prefix || l_api_name,
1030: message => 'After calling get_site_level_profile_value. l_base_url='
1031: || l_base_url);
1024: l_base_url := get_site_level_profile_value('APPS_FRAMEWORK_AGENT');
1025:
1026: IF (g_fnd_debug = 'Y') THEN
1027: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1028: FND_LOG.string(log_level => FND_LOG.level_statement,
1029: module => g_module_prefix || l_api_name,
1030: message => 'After calling get_site_level_profile_value. l_base_url='
1031: || l_base_url);
1032: END IF;
1034:
1035: IF (l_base_url is null) then
1036: l_base_url := FND_PROFILE.value('APPS_FRAMEWORK_AGENT');
1037: IF (g_fnd_debug = 'Y') THEN
1038: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1039: FND_LOG.string(log_level => FND_LOG.level_statement,
1040: module => g_module_prefix || l_api_name,
1041: message => 'get_site_level_profile return NULL. After calling FND_PROFILE.value(); l_base_url='
1042: || l_base_url);
1035: IF (l_base_url is null) then
1036: l_base_url := FND_PROFILE.value('APPS_FRAMEWORK_AGENT');
1037: IF (g_fnd_debug = 'Y') THEN
1038: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1039: FND_LOG.string(log_level => FND_LOG.level_statement,
1040: module => g_module_prefix || l_api_name,
1041: message => 'get_site_level_profile return NULL. After calling FND_PROFILE.value(); l_base_url='
1042: || l_base_url);
1043: END IF;