DBA Data[Home] [Help]

APPS.LNS_DISTRIBUTIONS_PUB dependencies on PSA_BC_XLA_EVENTS_GT

Line 193: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'inserting into PSA_BC_XLA_EVENTS_GT - event => ' || l_event_id);

189: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Updated event_id '||l_event_id||' succesfully for '||SQL%ROWCOUNT||' rows');
190:
191: if (l_funds_reserved_flag = 'Y') then
192:
193: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'inserting into PSA_BC_XLA_EVENTS_GT - event => ' || l_event_id);
194: insert into PSA_BC_XLA_EVENTS_GT (event_id, result_code)
195: values (l_event_id, 'FAIL');
196:
197: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling PSA_BC_XLA_PUB.Budgetary_Control ' || l_event_id);

Line 194: insert into PSA_BC_XLA_EVENTS_GT (event_id, result_code)

190:
191: if (l_funds_reserved_flag = 'Y') then
192:
193: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'inserting into PSA_BC_XLA_EVENTS_GT - event => ' || l_event_id);
194: insert into PSA_BC_XLA_EVENTS_GT (event_id, result_code)
195: values (l_event_id, 'FAIL');
196:
197: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling PSA_BC_XLA_PUB.Budgetary_Control ' || l_event_id);
198: -- always pass P_BC_MODE = reserve as per shaniqua williams

Line 676: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'inserting into PSA_BC_XLA_EVENTS_GT ');

672: and event_id IS NULL
673: and loan_id = p_loan_id;
674:
675: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Updated event_id succesfully for '||SQL%ROWCOUNT||' rows');
676: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'inserting into PSA_BC_XLA_EVENTS_GT ');
677: insert
678: into PSA_BC_XLA_EVENTS_GT (event_id, result_code)
679: values (l_event_id, 'FAIL');
680:

Line 678: into PSA_BC_XLA_EVENTS_GT (event_id, result_code)

674:
675: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Updated event_id succesfully for '||SQL%ROWCOUNT||' rows');
676: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'inserting into PSA_BC_XLA_EVENTS_GT ');
677: insert
678: into PSA_BC_XLA_EVENTS_GT (event_id, result_code)
679: values (l_event_id, 'FAIL');
680:
681: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling PSA_BC_XLA_PUB.Budgetary_Control ' || l_event_id);
682: PSA_BC_XLA_PUB.Budgetary_Control(p_api_version => 1.0

Line 6207: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'inserting into PSA_BC_XLA_EVENTS_GT ');

6203: IF l_event_id IS NOT NULL THEN
6204:
6205: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_event_id = ' || l_event_id);
6206:
6207: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'inserting into PSA_BC_XLA_EVENTS_GT ');
6208: INSERT INTO PSA_BC_XLA_EVENTS_GT (event_id, result_code)
6209: values (l_event_id, 'FAIL');
6210:
6211: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling PSA_BC_XLA_PUB.Budgetary_Control ' || l_event_id);

Line 6208: INSERT INTO PSA_BC_XLA_EVENTS_GT (event_id, result_code)

6204:
6205: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_event_id = ' || l_event_id);
6206:
6207: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'inserting into PSA_BC_XLA_EVENTS_GT ');
6208: INSERT INTO PSA_BC_XLA_EVENTS_GT (event_id, result_code)
6209: values (l_event_id, 'FAIL');
6210:
6211: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling PSA_BC_XLA_PUB.Budgetary_Control ' || l_event_id);
6212: PSA_BC_XLA_PUB.Budgetary_Control(p_api_version => 1.0

Line 7804: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'inserting into PSA_BC_XLA_EVENTS_GT - event => ' || l_event_id);

7800: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Updated event_id '||l_event_id||' succesfully for '||SQL%ROWCOUNT||' rows');
7801:
7802: if l_funds_reserved_flag = 'Y' then
7803:
7804: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'inserting into PSA_BC_XLA_EVENTS_GT - event => ' || l_event_id);
7805: insert into PSA_BC_XLA_EVENTS_GT (event_id, result_code)
7806: values (l_event_id, 'FAIL');
7807:
7808: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling PSA_BC_XLA_PUB.Budgetary_Control ' || l_event_id);

Line 7805: insert into PSA_BC_XLA_EVENTS_GT (event_id, result_code)

7801:
7802: if l_funds_reserved_flag = 'Y' then
7803:
7804: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'inserting into PSA_BC_XLA_EVENTS_GT - event => ' || l_event_id);
7805: insert into PSA_BC_XLA_EVENTS_GT (event_id, result_code)
7806: values (l_event_id, 'FAIL');
7807:
7808: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling PSA_BC_XLA_PUB.Budgetary_Control ' || l_event_id);
7809: -- always pass P_BC_MODE = reserve as per shaniqua williams