DBA Data[Home] [Help]

APPS.LNS_LOAN_PUB dependencies on FND_LOG

Line 264: FND_LOG.STRING(p_msg_level, G_PKG_NAME, p_msg);

260: IS
261: BEGIN
262: if (p_msg_level >= G_MSG_LEVEL) then
263:
264: FND_LOG.STRING(p_msg_level, G_PKG_NAME, p_msg);
265:
266: end if;
267:
268: EXCEPTION

Line 270: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: ' || sqlerrm);

266: end if;
267:
268: EXCEPTION
269: WHEN OTHERS THEN
270: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: ' || sqlerrm);
271: END;
272: /*========================================================================
273: | PRIVATE PROCEDURE LogErrors
274: |

Line 328: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: ' || sqlerrm);

324: g_errors_rec(g_error_count).LINE_NUMBER := p_line_number;
325:
326: EXCEPTION
327: WHEN OTHERS THEN
328: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: ' || sqlerrm);
329: END;
330: /*========================================================================
331: | PRIVATE PROCEDURE InsertErrors
332: |

Line 367: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: ' || sqlerrm);

363: VALUES
364: g_errors_rec(i);
365: EXCEPTION
366: WHEN OTHERS THEN
367: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: ' || sqlerrm);
368: END;
369:
370: PROCEDURE CREATE_LOAN(
371: P_API_VERSION IN NUMBER,

Line 442: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');

438: /*-----------------------------------------------------------------------+
439: | Cursor Declarations |
440: +-----------------------------------------------------------------------*/
441: BEGIN
442: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
443: -- Initialize flags
444: l_borrower_valid := FALSE;
445: l_cust_acct_valid := FALSE;
446:

Line 1622: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: ' || sqlerrm);

1618: ,g_rate_term_rec.PHASE
1619: ,g_rate_term_rec.FLOATING_FLAG);
1620: EXCEPTION
1621: WHEN OTHERS THEN
1622: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: ' || sqlerrm);
1623: LogErrors(p_message_name=>'LNS_LCREATE_INS_ERR_TERMRATE'
1624: ,p_token1 => sqlerrm);
1625: rollback to SAVEPOINT before_insert;
1626: raise error_while_insert;

Line 1675: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: ' || sqlerrm);

1671: ,g_rate_open_rec.PHASE
1672: ,g_rate_open_rec.FLOATING_FLAG);
1673: EXCEPTION
1674: WHEN OTHERS THEN
1675: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: ' || sqlerrm);
1676: LogErrors(p_message_name=>'LNS_LCREATE_INS_ERR_OPENRATE'
1677: ,p_token1 => sqlerrm);
1678: rollback to SAVEPOINT before_insert;
1679: raise error_while_insert;

Line 1711: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');

1707: X_RETURN_STATUS := 'S';
1708: X_MSG_COUNT := 0;
1709: X_LOAN_ID := l_loan_id;
1710: END IF;
1711: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');
1712: EXCEPTION
1713: WHEN product_not_found THEN
1714: InsertErrors;
1715: X_RETURN_STATUS := 'E';

Line 1730: G_MSG_LEVEL := FND_LOG.LEVEL_UNEXPECTED;

1726: END CREATE_LOAN;
1727:
1728: BEGIN
1729: G_LOG_ENABLED := 'N';
1730: G_MSG_LEVEL := FND_LOG.LEVEL_UNEXPECTED;
1731:
1732: /* getting msg logging info */
1733: G_LOG_ENABLED := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'), 'N');
1734: if (G_LOG_ENABLED = 'N') then

Line 1735: G_MSG_LEVEL := FND_LOG.LEVEL_UNEXPECTED;

1731:
1732: /* getting msg logging info */
1733: G_LOG_ENABLED := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'), 'N');
1734: if (G_LOG_ENABLED = 'N') then
1735: G_MSG_LEVEL := FND_LOG.LEVEL_UNEXPECTED;
1736: else
1737: G_MSG_LEVEL := NVL(to_number(FND_PROFILE.VALUE('AFLOG_LEVEL')), FND_LOG.LEVEL_UNEXPECTED);
1738: end if;
1739:

Line 1737: G_MSG_LEVEL := NVL(to_number(FND_PROFILE.VALUE('AFLOG_LEVEL')), FND_LOG.LEVEL_UNEXPECTED);

1733: G_LOG_ENABLED := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'), 'N');
1734: if (G_LOG_ENABLED = 'N') then
1735: G_MSG_LEVEL := FND_LOG.LEVEL_UNEXPECTED;
1736: else
1737: G_MSG_LEVEL := NVL(to_number(FND_PROFILE.VALUE('AFLOG_LEVEL')), FND_LOG.LEVEL_UNEXPECTED);
1738: end if;
1739:
1740: LogMessage(FND_LOG.LEVEL_STATEMENT, 'G_LOG_ENABLED: ' || G_LOG_ENABLED);
1741: END LNS_LOAN_PUB;

Line 1740: LogMessage(FND_LOG.LEVEL_STATEMENT, 'G_LOG_ENABLED: ' || G_LOG_ENABLED);

1736: else
1737: G_MSG_LEVEL := NVL(to_number(FND_PROFILE.VALUE('AFLOG_LEVEL')), FND_LOG.LEVEL_UNEXPECTED);
1738: end if;
1739:
1740: LogMessage(FND_LOG.LEVEL_STATEMENT, 'G_LOG_ENABLED: ' || G_LOG_ENABLED);
1741: END LNS_LOAN_PUB;