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: --Bug 15991171 - removing language_code parameter from url
274: l_url_parameters_tab(6).name := 'addBreadCrumb';
275: l_url_parameters_tab(6).value := 'Y';
276:
277:
278: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
279: FND_LOG.string(log_level => FND_LOG.level_statement,
280: module => g_module_prefix || 'get_dest_page_url',
281: message => 'fnd_global.current_language : ' || fnd_global.current_language);
282: END IF; --}
275: l_url_parameters_tab(6).value := 'Y';
276:
277:
278: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
279: FND_LOG.string(log_level => FND_LOG.level_statement,
280: module => g_module_prefix || 'get_dest_page_url',
281: message => 'fnd_global.current_language : ' || fnd_global.current_language);
282: END IF; --}
283:
820:
821: BEGIN
822:
823: IF (g_fnd_debug = 'Y') THEN
824: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
825: FND_LOG.string(log_level => FND_LOG.level_statement,
826: module => g_module_prefix || l_api_name,
827: message => 'BEGIN: Check WF preference for'
828: || p_wf_message_name || ' for auction '
821: BEGIN
822:
823: IF (g_fnd_debug = 'Y') THEN
824: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
825: FND_LOG.string(log_level => FND_LOG.level_statement,
826: module => g_module_prefix || l_api_name,
827: message => 'BEGIN: Check WF preference for'
828: || p_wf_message_name || ' for auction '
829: || p_auction_id);
848: -- this is an unnatural event
849: --
850: WHEN OTHERS THEN
851: IF (g_fnd_debug = 'Y') THEN
852: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN
853: FND_LOG.string(log_level => FND_LOG.level_exception,
854: module => g_module_prefix || l_api_name,
855: message => 'EXCEPTION: Check WF preference for'
856: || p_wf_message_name || ' for auction '
849: --
850: WHEN OTHERS THEN
851: IF (g_fnd_debug = 'Y') THEN
852: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN
853: FND_LOG.string(log_level => FND_LOG.level_exception,
854: module => g_module_prefix || l_api_name,
855: message => 'EXCEPTION: Check WF preference for'
856: || p_wf_message_name || ' for auction '
857: || p_auction_id);
891:
892: BEGIN
893:
894: IF (g_fnd_debug = 'Y') THEN
895: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
896:
897: FND_LOG.string(log_level => FND_LOG.level_statement,
898: module => g_module_prefix || l_api_name,
899: message => 'BEGIN: Check WF preference for'
893:
894: IF (g_fnd_debug = 'Y') THEN
895: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
896:
897: FND_LOG.string(log_level => FND_LOG.level_statement,
898: module => g_module_prefix || l_api_name,
899: message => 'BEGIN: Check WF preference for'
900: || p_wf_message_name || ' for doctype '
901: || p_doctype);
916: AND notifMessages.NOTIF_MESSAGE_NAME = P_WF_MESSAGE_NAME;
917:
918:
919: IF (g_fnd_debug = 'Y') THEN
920: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
921: FND_LOG.string(log_level => FND_LOG.level_statement,
922: module => g_module_prefix || l_api_name,
923: message => 'BEGIN: Check WF preference for'
924: || p_wf_message_name || ' for doctype '
917:
918:
919: IF (g_fnd_debug = 'Y') THEN
920: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
921: FND_LOG.string(log_level => FND_LOG.level_statement,
922: module => g_module_prefix || l_api_name,
923: message => 'BEGIN: Check WF preference for'
924: || p_wf_message_name || ' for doctype '
925: || p_doctype || ' with return value '
943: -- not to be subscribed message. Hence, return true i.e.
944: -- the older behavior
945: --
946: IF (g_fnd_debug = 'Y') THEN
947: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN
948: FND_LOG.string(log_level => FND_LOG.level_exception,
949: module => g_module_prefix || l_api_name,
950: message => 'EXCEPTION: NO DATA FOUND for message name:'
951: || p_wf_message_name || ' for doctype '
944: -- the older behavior
945: --
946: IF (g_fnd_debug = 'Y') THEN
947: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN
948: FND_LOG.string(log_level => FND_LOG.level_exception,
949: module => g_module_prefix || l_api_name,
950: message => 'EXCEPTION: NO DATA FOUND for message name:'
951: || p_wf_message_name || ' for doctype '
952: || p_doctype);
959: -- Chances are rare but if any such error happens then it will simply
960: -- raise the error to the upper level
961: --
962: IF (g_fnd_debug = 'Y') THEN
963: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN
964: FND_LOG.string(log_level => FND_LOG.level_exception,
965: module => g_module_prefix || l_api_name,
966: message => 'EXCEPTION:Check WF preference for '
967: || P_WF_MESSAGE_NAME
960: -- raise the error to the upper level
961: --
962: IF (g_fnd_debug = 'Y') THEN
963: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN
964: FND_LOG.string(log_level => FND_LOG.level_exception,
965: module => g_module_prefix || l_api_name,
966: message => 'EXCEPTION:Check WF preference for '
967: || P_WF_MESSAGE_NAME
968: || ' for doctype '
1092: -- 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.
1093: l_base_url := get_site_level_profile_value('APPS_FRAMEWORK_AGENT');
1094:
1095: IF (g_fnd_debug = 'Y') THEN
1096: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1097: FND_LOG.string(log_level => FND_LOG.level_statement,
1098: module => g_module_prefix || l_api_name,
1099: message => 'After calling get_site_level_profile_value. l_base_url='
1100: || l_base_url);
1093: l_base_url := get_site_level_profile_value('APPS_FRAMEWORK_AGENT');
1094:
1095: IF (g_fnd_debug = 'Y') THEN
1096: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1097: FND_LOG.string(log_level => FND_LOG.level_statement,
1098: module => g_module_prefix || l_api_name,
1099: message => 'After calling get_site_level_profile_value. l_base_url='
1100: || l_base_url);
1101: END IF;
1103:
1104: IF (l_base_url is null) then
1105: l_base_url := FND_PROFILE.value('APPS_FRAMEWORK_AGENT');
1106: IF (g_fnd_debug = 'Y') THEN
1107: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1108: FND_LOG.string(log_level => FND_LOG.level_statement,
1109: module => g_module_prefix || l_api_name,
1110: message => 'get_site_level_profile return NULL. After calling FND_PROFILE.value(); l_base_url='
1111: || l_base_url);
1104: IF (l_base_url is null) then
1105: l_base_url := FND_PROFILE.value('APPS_FRAMEWORK_AGENT');
1106: IF (g_fnd_debug = 'Y') THEN
1107: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1108: FND_LOG.string(log_level => FND_LOG.level_statement,
1109: module => g_module_prefix || l_api_name,
1110: message => 'get_site_level_profile return NULL. After calling FND_PROFILE.value(); l_base_url='
1111: || l_base_url);
1112: END IF;