DBA Data[Home] [Help]

APPS.LNS_UTILITY_PUB dependencies on FND_LOG

Line 18: IF log_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

14: is
15:
16: begin
17:
18: IF log_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
19: FND_LOG.STRING(log_level, module, message);
20: END IF;
21:
22: end;

Line 19: FND_LOG.STRING(log_level, module, message);

15:
16: begin
17:
18: IF log_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
19: FND_LOG.STRING(log_level, module, message);
20: END IF;
21:
22: end;
23:

Line 533: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_from_amount ' || p_from_amount);

529: WHERE fndc.currency_code = p_to_currency;
530: begin
531:
532: l_api_name := 'convertAmount';
533: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_from_amount ' || p_from_amount);
534: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_from_currency ' || p_from_currency);
535: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_to_currency ' || p_to_currency);
536: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_exchange_type ' || p_exchange_type);
537: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_exchange_date ' || p_exchange_date);

Line 534: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_from_currency ' || p_from_currency);

530: begin
531:
532: l_api_name := 'convertAmount';
533: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_from_amount ' || p_from_amount);
534: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_from_currency ' || p_from_currency);
535: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_to_currency ' || p_to_currency);
536: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_exchange_type ' || p_exchange_type);
537: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_exchange_date ' || p_exchange_date);
538: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_exchange_rate ' || p_exchange_rate);

Line 535: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_to_currency ' || p_to_currency);

531:
532: l_api_name := 'convertAmount';
533: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_from_amount ' || p_from_amount);
534: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_from_currency ' || p_from_currency);
535: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_to_currency ' || p_to_currency);
536: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_exchange_type ' || p_exchange_type);
537: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_exchange_date ' || p_exchange_date);
538: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_exchange_rate ' || p_exchange_rate);
539:

Line 536: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_exchange_type ' || p_exchange_type);

532: l_api_name := 'convertAmount';
533: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_from_amount ' || p_from_amount);
534: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_from_currency ' || p_from_currency);
535: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_to_currency ' || p_to_currency);
536: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_exchange_type ' || p_exchange_type);
537: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_exchange_date ' || p_exchange_date);
538: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_exchange_rate ' || p_exchange_rate);
539:
540: if p_to_currency is null then

Line 537: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_exchange_date ' || p_exchange_date);

533: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_from_amount ' || p_from_amount);
534: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_from_currency ' || p_from_currency);
535: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_to_currency ' || p_to_currency);
536: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_exchange_type ' || p_exchange_type);
537: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_exchange_date ' || p_exchange_date);
538: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_exchange_rate ' || p_exchange_rate);
539:
540: if p_to_currency is null then
541: SELECT sb.currency_code into l_to_currency

Line 538: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_exchange_rate ' || p_exchange_rate);

534: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_from_currency ' || p_from_currency);
535: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_to_currency ' || p_to_currency);
536: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_exchange_type ' || p_exchange_type);
537: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_exchange_date ' || p_exchange_date);
538: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_exchange_rate ' || p_exchange_rate);
539:
540: if p_to_currency is null then
541: SELECT sb.currency_code into l_to_currency
542: FROM lns_system_options so,

Line 580: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_from_amount ' || p_from_amount);

576: X_TO_CURRENCY => p_to_currency,
577: X_CONVERSION_DATE => p_exchange_date,
578: X_CONVERSION_TYPE => p_exchange_type);
579: */
580: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_from_amount ' || p_from_amount);
581: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_from_currency ' || p_from_currency);
582: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_to_currency ' || l_to_currency);
583: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_exchange_type ' || l_exchange_type);
584: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_exchange_date ' || p_exchange_date);

Line 581: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_from_currency ' || p_from_currency);

577: X_CONVERSION_DATE => p_exchange_date,
578: X_CONVERSION_TYPE => p_exchange_type);
579: */
580: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_from_amount ' || p_from_amount);
581: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_from_currency ' || p_from_currency);
582: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_to_currency ' || l_to_currency);
583: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_exchange_type ' || l_exchange_type);
584: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_exchange_date ' || p_exchange_date);
585: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_exchange_rate ' || p_exchange_rate);

Line 582: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_to_currency ' || l_to_currency);

578: X_CONVERSION_TYPE => p_exchange_type);
579: */
580: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_from_amount ' || p_from_amount);
581: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_from_currency ' || p_from_currency);
582: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_to_currency ' || l_to_currency);
583: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_exchange_type ' || l_exchange_type);
584: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_exchange_date ' || p_exchange_date);
585: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_exchange_rate ' || p_exchange_rate);
586:

Line 583: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_exchange_type ' || l_exchange_type);

579: */
580: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_from_amount ' || p_from_amount);
581: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_from_currency ' || p_from_currency);
582: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_to_currency ' || l_to_currency);
583: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_exchange_type ' || l_exchange_type);
584: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_exchange_date ' || p_exchange_date);
585: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_exchange_rate ' || p_exchange_rate);
586:
587: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - calling gl_currency API....');

Line 584: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_exchange_date ' || p_exchange_date);

580: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_from_amount ' || p_from_amount);
581: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_from_currency ' || p_from_currency);
582: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_to_currency ' || l_to_currency);
583: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_exchange_type ' || l_exchange_type);
584: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_exchange_date ' || p_exchange_date);
585: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_exchange_rate ' || p_exchange_rate);
586:
587: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - calling gl_currency API....');
588: l_convert_amount := gl_currency_api.convert_amount(X_FROM_CURRENCY => p_from_currency

Line 585: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_exchange_rate ' || p_exchange_rate);

581: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_from_currency ' || p_from_currency);
582: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_to_currency ' || l_to_currency);
583: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_exchange_type ' || l_exchange_type);
584: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_exchange_date ' || p_exchange_date);
585: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_exchange_rate ' || p_exchange_rate);
586:
587: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - calling gl_currency API....');
588: l_convert_amount := gl_currency_api.convert_amount(X_FROM_CURRENCY => p_from_currency
589: ,X_TO_CURRENCY => l_to_currency

Line 587: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - calling gl_currency API....');

583: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_exchange_type ' || l_exchange_type);
584: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_exchange_date ' || p_exchange_date);
585: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_exchange_rate ' || p_exchange_rate);
586:
587: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - calling gl_currency API....');
588: l_convert_amount := gl_currency_api.convert_amount(X_FROM_CURRENCY => p_from_currency
589: ,X_TO_CURRENCY => l_to_currency
590: ,X_CONVERSION_DATE => l_exchange_date
591: ,X_CONVERSION_TYPE => l_exchange_type

Line 1005: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' :BEGIN');

1001: l_compile_state VARCHAR2(200);
1002: l_return boolean;
1003: BEGIN
1004:
1005: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' :BEGIN');
1006:
1007: OPEN Check_MV_Exists(l_entity_name);
1008: FETCH Check_MV_Exists INTO l_mv_name,l_compile_state;
1009: CLOSE Check_MV_Exists;

Line 1029: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' : Materialized View '|| l_entity_name || 'NOT FOUND - nothing to refresh');

1025: end if; --if (l_compile_state <> 'VALID') then
1026:
1027: else
1028:
1029: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' : Materialized View '|| l_entity_name || 'NOT FOUND - nothing to refresh');
1030: fnd_file.put_line(FND_FILE.LOG,
1031: 'Materialized View '|| l_entity_name || 'NOT FOUND - nothing to refresh');
1032: fnd_file.put_line(FND_FILE.LOG,
1033: 'Exiting program without performing any action');

Line 1042: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' :END');

1038: message => 'Materialized View Refresh has failed. Please review log file.');
1039:
1040: end if; --if (l_mv_name is not null) then
1041:
1042: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' :END');
1043:
1044: EXCEPTION
1045: when others then
1046: fnd_file.put_line(FND_FILE.LOG,

Line 1083: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' :BEGIN');

1079:
1080: BEGIN
1081: l_is_pending := 'N';
1082:
1083: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' :BEGIN');
1084:
1085: open C_CHECK_CP_REQ;
1086: fetch C_CHECK_CP_REQ into l_request_id;
1087: close C_CHECK_CP_REQ;

Line 1093: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' :END');

1089: if (l_request_id IS NOT NULL) then
1090: l_is_pending := 'Y';
1091: end if;
1092:
1093: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' :END');
1094:
1095: return l_is_pending;
1096:
1097: END is_concurrent_request_pending;