DBA Data[Home] [Help]

APPS.PON_WF_UTL_PKG dependencies on FND_LOG

Line 80: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

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);

Line 81: FND_LOG.string(log_level => FND_LOG.level_statement,

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;

Line 91: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

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);

Line 92: FND_LOG.string(log_level => FND_LOG.level_statement,

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;

Line 236: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{

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; --}

Line 237: FND_LOG.string(log_level => FND_LOG.level_statement,

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:

Line 263: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{

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; --}

Line 264: FND_LOG.string(log_level => FND_LOG.level_statement,

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:

Line 273: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{

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; --}

Line 274: FND_LOG.string(log_level => FND_LOG.level_statement,

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:

Line 756: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

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 '

Line 757: FND_LOG.string(log_level => FND_LOG.level_statement,

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);

Line 784: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN

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 '

Line 785: FND_LOG.string(log_level => FND_LOG.level_exception,

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);

Line 827: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

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'

Line 829: FND_LOG.string(log_level => FND_LOG.level_statement,

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);

Line 851: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

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 '

Line 852: FND_LOG.string(log_level => FND_LOG.level_statement,

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 '

Line 878: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN

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 '

Line 879: FND_LOG.string(log_level => FND_LOG.level_exception,

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);

Line 894: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN

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

Line 895: FND_LOG.string(log_level => FND_LOG.level_exception,

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 '

Line 1027: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

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);

Line 1028: FND_LOG.string(log_level => FND_LOG.level_statement,

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;

Line 1038: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

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);

Line 1039: FND_LOG.string(log_level => FND_LOG.level_statement,

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;