eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.LNS_XLA_EVENTS dependencies on FND_LOG

Line 25: IF log_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

21: is
22:
23: begin
24:
25: IF log_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
26: FND_LOG.STRING(log_level, module, message);
27: if FND_GLOBAL.Conc_Request_Id is not null then
28: fnd_file.put_line(FND_FILE.LOG, message);
29: end if;

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

22:
23: begin
24:
25: IF log_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
26: FND_LOG.STRING(log_level, module, message);
27: if FND_GLOBAL.Conc_Request_Id is not null then
28: fnd_file.put_line(FND_FILE.LOG, message);
29: end if;
30: END IF;

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

151:
152: begin
153:
154: l_api_name := 'create_event';
155: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');
156:
157: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Input:');
158: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'loan_id = ' || p_loan_id);
159: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_disb_header_id = ' || p_disb_header_id);

Line 157: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Input:');

153:
154: l_api_name := 'create_event';
155: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');
156:
157: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Input:');
158: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'loan_id = ' || p_loan_id);
159: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_disb_header_id = ' || p_disb_header_id);
160: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_loan_amount_adj_id = ' || p_loan_amount_adj_id);
161: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_loan_line_id = ' || p_loan_line_id);

Line 158: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'loan_id = ' || p_loan_id);

154: l_api_name := 'create_event';
155: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');
156:
157: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Input:');
158: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'loan_id = ' || p_loan_id);
159: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_disb_header_id = ' || p_disb_header_id);
160: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_loan_amount_adj_id = ' || p_loan_amount_adj_id);
161: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_loan_line_id = ' || p_loan_line_id);
162: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_event_type_code = ' || p_event_type_code);

Line 159: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_disb_header_id = ' || p_disb_header_id);

155: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');
156:
157: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Input:');
158: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'loan_id = ' || p_loan_id);
159: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_disb_header_id = ' || p_disb_header_id);
160: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_loan_amount_adj_id = ' || p_loan_amount_adj_id);
161: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_loan_line_id = ' || p_loan_line_id);
162: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_event_type_code = ' || p_event_type_code);
163: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_event_date = ' || p_event_date);

Line 160: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_loan_amount_adj_id = ' || p_loan_amount_adj_id);

156:
157: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Input:');
158: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'loan_id = ' || p_loan_id);
159: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_disb_header_id = ' || p_disb_header_id);
160: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_loan_amount_adj_id = ' || p_loan_amount_adj_id);
161: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_loan_line_id = ' || p_loan_line_id);
162: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_event_type_code = ' || p_event_type_code);
163: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_event_date = ' || p_event_date);
164: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_event_status = ' || p_event_status);

Line 161: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_loan_line_id = ' || p_loan_line_id);

157: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Input:');
158: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'loan_id = ' || p_loan_id);
159: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_disb_header_id = ' || p_disb_header_id);
160: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_loan_amount_adj_id = ' || p_loan_amount_adj_id);
161: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_loan_line_id = ' || p_loan_line_id);
162: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_event_type_code = ' || p_event_type_code);
163: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_event_date = ' || p_event_date);
164: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_event_status = ' || p_event_status);
165: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_bc_flag = ' || p_bc_flag);

Line 162: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_event_type_code = ' || p_event_type_code);

158: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'loan_id = ' || p_loan_id);
159: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_disb_header_id = ' || p_disb_header_id);
160: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_loan_amount_adj_id = ' || p_loan_amount_adj_id);
161: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_loan_line_id = ' || p_loan_line_id);
162: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_event_type_code = ' || p_event_type_code);
163: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_event_date = ' || p_event_date);
164: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_event_status = ' || p_event_status);
165: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_bc_flag = ' || p_bc_flag);
166:

Line 163: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_event_date = ' || p_event_date);

159: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_disb_header_id = ' || p_disb_header_id);
160: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_loan_amount_adj_id = ' || p_loan_amount_adj_id);
161: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_loan_line_id = ' || p_loan_line_id);
162: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_event_type_code = ' || p_event_type_code);
163: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_event_date = ' || p_event_date);
164: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_event_status = ' || p_event_status);
165: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_bc_flag = ' || p_bc_flag);
166:
167: -- Standard Start of API savepoint

Line 164: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_event_status = ' || p_event_status);

160: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_loan_amount_adj_id = ' || p_loan_amount_adj_id);
161: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_loan_line_id = ' || p_loan_line_id);
162: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_event_type_code = ' || p_event_type_code);
163: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_event_date = ' || p_event_date);
164: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_event_status = ' || p_event_status);
165: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_bc_flag = ' || p_bc_flag);
166:
167: -- Standard Start of API savepoint
168: SAVEPOINT create_event;

Line 165: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_bc_flag = ' || p_bc_flag);

161: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_loan_line_id = ' || p_loan_line_id);
162: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_event_type_code = ' || p_event_type_code);
163: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_event_date = ' || p_event_date);
164: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_event_status = ' || p_event_status);
165: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_bc_flag = ' || p_bc_flag);
166:
167: -- Standard Start of API savepoint
168: SAVEPOINT create_event;
169:

Line 190: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_number = ' || l_loan_number);

186: open c_sob_id(p_loan_id);
187: fetch c_sob_id into l_sob_id;
188: close c_sob_id;
189:
190: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_number = ' || l_loan_number);
191: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_legal_entity_id = ' || l_legal_entity_id);
192: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_sob_id = ' || l_sob_id);
193:
194: -- force caller to pass disbursement_id/loan_amount_adj_id/loan_line_id

Line 191: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_legal_entity_id = ' || l_legal_entity_id);

187: fetch c_sob_id into l_sob_id;
188: close c_sob_id;
189:
190: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_number = ' || l_loan_number);
191: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_legal_entity_id = ' || l_legal_entity_id);
192: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_sob_id = ' || l_sob_id);
193:
194: -- force caller to pass disbursement_id/loan_amount_adj_id/loan_line_id
195: if (p_disb_header_id is null and p_loan_amount_adj_id is null and p_loan_line_id is null)then

Line 192: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_sob_id = ' || l_sob_id);

188: close c_sob_id;
189:
190: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_number = ' || l_loan_number);
191: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_legal_entity_id = ' || l_legal_entity_id);
192: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_sob_id = ' || l_sob_id);
193:
194: -- force caller to pass disbursement_id/loan_amount_adj_id/loan_line_id
195: if (p_disb_header_id is null and p_loan_amount_adj_id is null and p_loan_line_id is null)then
196: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');

Line 214: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.source_id_int_1 = ' || l_loan_details.source_id_int_1);

210: l_loan_details.source_id_int_3 := NVL(p_loan_amount_adj_id, -1); -- loan_amount_adj_id
211: l_loan_details.source_id_int_4 := NVL(p_loan_line_id, -1); -- loan_line_id
212: l_loan_details.source_application_id := 206; -- XLA registered application
213:
214: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.source_id_int_1 = ' || l_loan_details.source_id_int_1);
215: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.source_id_int_2 = ' || l_loan_details.source_id_int_2);
216: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.source_id_int_3 = ' || l_loan_details.source_id_int_3);
217: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.source_id_int_4 = ' || l_loan_details.source_id_int_4);
218: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.transaction_number = ' || l_loan_details.transaction_number);

Line 215: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.source_id_int_2 = ' || l_loan_details.source_id_int_2);

211: l_loan_details.source_id_int_4 := NVL(p_loan_line_id, -1); -- loan_line_id
212: l_loan_details.source_application_id := 206; -- XLA registered application
213:
214: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.source_id_int_1 = ' || l_loan_details.source_id_int_1);
215: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.source_id_int_2 = ' || l_loan_details.source_id_int_2);
216: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.source_id_int_3 = ' || l_loan_details.source_id_int_3);
217: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.source_id_int_4 = ' || l_loan_details.source_id_int_4);
218: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.transaction_number = ' || l_loan_details.transaction_number);
219: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.source_application_id = ' || l_loan_details.source_application_id);

Line 216: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.source_id_int_3 = ' || l_loan_details.source_id_int_3);

212: l_loan_details.source_application_id := 206; -- XLA registered application
213:
214: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.source_id_int_1 = ' || l_loan_details.source_id_int_1);
215: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.source_id_int_2 = ' || l_loan_details.source_id_int_2);
216: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.source_id_int_3 = ' || l_loan_details.source_id_int_3);
217: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.source_id_int_4 = ' || l_loan_details.source_id_int_4);
218: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.transaction_number = ' || l_loan_details.transaction_number);
219: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.source_application_id = ' || l_loan_details.source_application_id);
220: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.entity_type_code = ' || l_loan_details.entity_type_code);

Line 217: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.source_id_int_4 = ' || l_loan_details.source_id_int_4);

213:
214: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.source_id_int_1 = ' || l_loan_details.source_id_int_1);
215: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.source_id_int_2 = ' || l_loan_details.source_id_int_2);
216: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.source_id_int_3 = ' || l_loan_details.source_id_int_3);
217: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.source_id_int_4 = ' || l_loan_details.source_id_int_4);
218: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.transaction_number = ' || l_loan_details.transaction_number);
219: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.source_application_id = ' || l_loan_details.source_application_id);
220: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.entity_type_code = ' || l_loan_details.entity_type_code);
221:

Line 218: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.transaction_number = ' || l_loan_details.transaction_number);

214: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.source_id_int_1 = ' || l_loan_details.source_id_int_1);
215: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.source_id_int_2 = ' || l_loan_details.source_id_int_2);
216: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.source_id_int_3 = ' || l_loan_details.source_id_int_3);
217: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.source_id_int_4 = ' || l_loan_details.source_id_int_4);
218: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.transaction_number = ' || l_loan_details.transaction_number);
219: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.source_application_id = ' || l_loan_details.source_application_id);
220: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.entity_type_code = ' || l_loan_details.entity_type_code);
221:
222: BEGIN

Line 219: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.source_application_id = ' || l_loan_details.source_application_id);

215: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.source_id_int_2 = ' || l_loan_details.source_id_int_2);
216: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.source_id_int_3 = ' || l_loan_details.source_id_int_3);
217: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.source_id_int_4 = ' || l_loan_details.source_id_int_4);
218: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.transaction_number = ' || l_loan_details.transaction_number);
219: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.source_application_id = ' || l_loan_details.source_application_id);
220: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.entity_type_code = ' || l_loan_details.entity_type_code);
221:
222: BEGIN
223: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Checking if event already exists...');

Line 220: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.entity_type_code = ' || l_loan_details.entity_type_code);

216: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.source_id_int_3 = ' || l_loan_details.source_id_int_3);
217: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.source_id_int_4 = ' || l_loan_details.source_id_int_4);
218: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.transaction_number = ' || l_loan_details.transaction_number);
219: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.source_application_id = ' || l_loan_details.source_application_id);
220: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.entity_type_code = ' || l_loan_details.entity_type_code);
221:
222: BEGIN
223: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Checking if event already exists...');
224: IF NOT XLA_EVENTS_PUB_PKG.event_exists

Line 223: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Checking if event already exists...');

219: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.source_application_id = ' || l_loan_details.source_application_id);
220: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.entity_type_code = ' || l_loan_details.entity_type_code);
221:
222: BEGIN
223: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Checking if event already exists...');
224: IF NOT XLA_EVENTS_PUB_PKG.event_exists
225: (p_event_source_info => l_loan_details
226: ,p_event_type_code => p_event_type_code
227: ,p_valuation_method => null

Line 231: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Event doesnt exist');

227: ,p_valuation_method => null
228: ,p_security_context => l_security_context)
229: THEN
230: -- Call the XLA create_event API
231: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Event doesnt exist');
232:
233: x_event_id := XLA_EVENTS_PUB_PKG.create_event
234: (
235: p_event_source_info => l_loan_details

Line 246: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'x_event_id = ' || x_event_id);

242: ,p_security_context => l_security_context
243: ,p_budgetary_control_flag => p_bc_flag
244: );
245:
246: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'x_event_id = ' || x_event_id);
247: if x_event_id is null then
248: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
249: FND_MESSAGE.SET_TOKEN('ERROR' ,'Failed to create Loans XLA event ' || p_event_type_code);
250: FND_MSG_PUB.ADD;

Line 251: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));

247: if x_event_id is null then
248: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
249: FND_MESSAGE.SET_TOKEN('ERROR' ,'Failed to create Loans XLA event ' || p_event_type_code);
250: FND_MSG_PUB.ADD;
251: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
252: RAISE FND_API.G_EXC_ERROR;
253: end if;
254: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Successfully created Loans XLA event ' || p_event_type_code);
255:

Line 254: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Successfully created Loans XLA event ' || p_event_type_code);

250: FND_MSG_PUB.ADD;
251: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
252: RAISE FND_API.G_EXC_ERROR;
253: end if;
254: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Successfully created Loans XLA event ' || p_event_type_code);
255:
256: ELSE
257: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Event already exists');
258:

Line 257: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Event already exists');

253: end if;
254: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Successfully created Loans XLA event ' || p_event_type_code);
255:
256: ELSE
257: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Event already exists');
258:
259: IF (p_event_type_code <> 'LOAN_ACCRUAL') THEN
260:
261: l_array_event_info := xla_events_pub_pkg.get_array_event_info

Line 268: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_old_event_id is '||l_old_event_id);

264: p_valuation_method => null,
265: p_security_context => l_security_context
266: );
267: l_old_event_id := l_array_event_info(1).event_id;
268: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_old_event_id is '||l_old_event_id);
269:
270: OPEN c_entity_count(l_old_event_id);
271: FETCH c_entity_count INTO l_entity_count;
272: CLOSE c_entity_count;

Line 274: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Entity Count is '||l_entity_count);

270: OPEN c_entity_count(l_old_event_id);
271: FETCH c_entity_count INTO l_entity_count;
272: CLOSE c_entity_count;
273:
274: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Entity Count is '||l_entity_count);
275:
276:
277: -- Cleanup XLA tables for this event
278: xla_events_pub_pkg.DELETE_EVENT

Line 285: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Deleted l_old_event_id '||l_old_event_id);

281: p_event_id => l_old_event_id,
282: p_valuation_method => null,
283: p_security_context => l_security_context
284: );
285: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Deleted l_old_event_id '||l_old_event_id);
286:
287: -- Need to delete the entities from the XLA tables if the entity_id is matched to only one event
288:
289: IF (l_entity_count <= 1) THEN

Line 294: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Entity Id of the event is deleted '||l_delete_event);

290:
291: l_delete_event := xla_events_pub_pkg.DELETE_ENTITY( p_source_info => l_loan_details,
292: p_valuation_method => null,
293: p_security_context => l_security_context);
294: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Entity Id of the event is deleted '||l_delete_event);
295:
296: END IF;
297:
298: END IF;

Line 300: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'After deletion, create new event');

296: END IF;
297:
298: END IF;
299:
300: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'After deletion, create new event');
301: -- Call the XLA create_event API
302: x_event_id := XLA_EVENTS_PUB_PKG.create_event
303: (
304: p_event_source_info => l_loan_details

Line 315: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'x_event_id = ' || x_event_id);

311: ,p_security_context => l_security_context
312: ,p_budgetary_control_flag => p_bc_flag
313: );
314:
315: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'x_event_id = ' || x_event_id);
316: if x_event_id is null then
317: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
318: FND_MESSAGE.SET_TOKEN('ERROR' ,'Failed to create Loans XLA event ' || p_event_type_code);
319: FND_MSG_PUB.ADD;

Line 320: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));

316: if x_event_id is null then
317: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
318: FND_MESSAGE.SET_TOKEN('ERROR' ,'Failed to create Loans XLA event ' || p_event_type_code);
319: FND_MSG_PUB.ADD;
320: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
321: RAISE FND_API.G_EXC_ERROR;
322: end if;
323: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Successfully created Loans XLA event ' || p_event_type_code);
324: END IF; -- END of IF NOT XLA_EVENTS_PUB_PKG.event_exists

Line 323: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Successfully created Loans XLA event ' || p_event_type_code);

319: FND_MSG_PUB.ADD;
320: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
321: RAISE FND_API.G_EXC_ERROR;
322: end if;
323: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Successfully created Loans XLA event ' || p_event_type_code);
324: END IF; -- END of IF NOT XLA_EVENTS_PUB_PKG.event_exists
325: END; -- END of event Creation code
326:
327: -- ---------------------------------------------------------------------

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

328: -- End of API body
329: -- ---------------------------------------------------------------------
330: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
331:
332: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
333:
334: EXCEPTION
335: WHEN FND_API.G_EXC_ERROR THEN
336: x_return_status := FND_API.G_RET_STS_ERROR;

Line 340: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

336: x_return_status := FND_API.G_RET_STS_ERROR;
337: x_msg_count := l_msg_count;
338: x_msg_data := l_msg_data;
339: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
340: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
341: ROLLBACK TO create_event;
342:
343: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
344: x_return_status := FND_API.G_RET_STS_ERROR;

Line 348: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

344: x_return_status := FND_API.G_RET_STS_ERROR;
345: x_msg_count := l_msg_count;
346: x_msg_data := l_msg_data;
347: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
348: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
349: ROLLBACK TO create_event;
350:
351: WHEN OTHERS THEN
352: x_return_status := FND_API.G_RET_STS_ERROR;

Line 356: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

352: x_return_status := FND_API.G_RET_STS_ERROR;
353: x_msg_count := l_msg_count;
354: x_msg_data := l_msg_data;
355: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
356: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
357: ROLLBACK TO create_event;
358:
359: end create_event;
360:

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

426: and lhdr.org_id = sb.org_id;
427:
428: begin
429: l_api_name := 'update_event';
430: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');
431: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Input:');
432: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'event_id ' || p_event_id);
433: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'loan_id = ' || p_loan_id);
434: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_disb_header_id = ' || p_disb_header_id);

Line 431: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Input:');

427:
428: begin
429: l_api_name := 'update_event';
430: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');
431: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Input:');
432: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'event_id ' || p_event_id);
433: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'loan_id = ' || p_loan_id);
434: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_disb_header_id = ' || p_disb_header_id);
435: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_loan_amount_adj_id = ' || p_loan_amount_adj_id);

Line 432: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'event_id ' || p_event_id);

428: begin
429: l_api_name := 'update_event';
430: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');
431: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Input:');
432: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'event_id ' || p_event_id);
433: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'loan_id = ' || p_loan_id);
434: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_disb_header_id = ' || p_disb_header_id);
435: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_loan_amount_adj_id = ' || p_loan_amount_adj_id);
436: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_loan_line_id = ' || p_loan_line_id);

Line 433: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'loan_id = ' || p_loan_id);

429: l_api_name := 'update_event';
430: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');
431: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Input:');
432: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'event_id ' || p_event_id);
433: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'loan_id = ' || p_loan_id);
434: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_disb_header_id = ' || p_disb_header_id);
435: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_loan_amount_adj_id = ' || p_loan_amount_adj_id);
436: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_loan_line_id = ' || p_loan_line_id);
437: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_event_type_code ' || p_event_type_code);

Line 434: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_disb_header_id = ' || p_disb_header_id);

430: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');
431: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Input:');
432: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'event_id ' || p_event_id);
433: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'loan_id = ' || p_loan_id);
434: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_disb_header_id = ' || p_disb_header_id);
435: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_loan_amount_adj_id = ' || p_loan_amount_adj_id);
436: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_loan_line_id = ' || p_loan_line_id);
437: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_event_type_code ' || p_event_type_code);
438: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_event_date ' || p_event_date);

Line 435: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_loan_amount_adj_id = ' || p_loan_amount_adj_id);

431: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Input:');
432: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'event_id ' || p_event_id);
433: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'loan_id = ' || p_loan_id);
434: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_disb_header_id = ' || p_disb_header_id);
435: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_loan_amount_adj_id = ' || p_loan_amount_adj_id);
436: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_loan_line_id = ' || p_loan_line_id);
437: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_event_type_code ' || p_event_type_code);
438: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_event_date ' || p_event_date);
439: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_event_status ' || p_event_status);

Line 436: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_loan_line_id = ' || p_loan_line_id);

432: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'event_id ' || p_event_id);
433: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'loan_id = ' || p_loan_id);
434: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_disb_header_id = ' || p_disb_header_id);
435: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_loan_amount_adj_id = ' || p_loan_amount_adj_id);
436: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_loan_line_id = ' || p_loan_line_id);
437: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_event_type_code ' || p_event_type_code);
438: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_event_date ' || p_event_date);
439: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_event_status ' || p_event_status);
440:

Line 437: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_event_type_code ' || p_event_type_code);

433: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'loan_id = ' || p_loan_id);
434: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_disb_header_id = ' || p_disb_header_id);
435: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_loan_amount_adj_id = ' || p_loan_amount_adj_id);
436: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_loan_line_id = ' || p_loan_line_id);
437: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_event_type_code ' || p_event_type_code);
438: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_event_date ' || p_event_date);
439: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_event_status ' || p_event_status);
440:
441: -- Standard Start of API savepoint

Line 438: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_event_date ' || p_event_date);

434: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_disb_header_id = ' || p_disb_header_id);
435: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_loan_amount_adj_id = ' || p_loan_amount_adj_id);
436: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_loan_line_id = ' || p_loan_line_id);
437: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_event_type_code ' || p_event_type_code);
438: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_event_date ' || p_event_date);
439: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_event_status ' || p_event_status);
440:
441: -- Standard Start of API savepoint
442: SAVEPOINT update_event;

Line 439: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_event_status ' || p_event_status);

435: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_loan_amount_adj_id = ' || p_loan_amount_adj_id);
436: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_loan_line_id = ' || p_loan_line_id);
437: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_event_type_code ' || p_event_type_code);
438: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_event_date ' || p_event_date);
439: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_event_status ' || p_event_status);
440:
441: -- Standard Start of API savepoint
442: SAVEPOINT update_event;
443:

Line 463: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_legal_entity_id = ' || l_legal_entity_id);

459: open c_sob_id(p_loan_id);
460: fetch c_sob_id into l_sob_id;
461: close c_sob_id;
462:
463: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_legal_entity_id = ' || l_legal_entity_id);
464: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_sob_id = ' || l_sob_id);
465:
466: -- initialize any variables here
467: l_loan_details.application_id := 206; -- XLA registered application

Line 464: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_sob_id = ' || l_sob_id);

460: fetch c_sob_id into l_sob_id;
461: close c_sob_id;
462:
463: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_legal_entity_id = ' || l_legal_entity_id);
464: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_sob_id = ' || l_sob_id);
465:
466: -- initialize any variables here
467: l_loan_details.application_id := 206; -- XLA registered application
468: l_loan_details.legal_entity_id := l_legal_entity_id; --

Line 476: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.source_id_int_1 = ' || l_loan_details.source_id_int_1);

472: l_loan_details.source_id_int_2 := p_disb_header_id; -- disb_header_id
473: l_loan_details.source_id_int_3 := p_loan_amount_adj_id; -- loan_amount_adj_id
474: l_loan_details.source_id_int_4 := p_loan_line_id; -- loan_line_id
475:
476: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.source_id_int_1 = ' || l_loan_details.source_id_int_1);
477: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.source_id_int_2 = ' || l_loan_details.source_id_int_2);
478: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.source_id_int_3 = ' || l_loan_details.source_id_int_3);
479: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.source_id_int_4 = ' || l_loan_details.source_id_int_4);
480: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.entity_type_code = ' || l_loan_details.entity_type_code);

Line 477: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.source_id_int_2 = ' || l_loan_details.source_id_int_2);

473: l_loan_details.source_id_int_3 := p_loan_amount_adj_id; -- loan_amount_adj_id
474: l_loan_details.source_id_int_4 := p_loan_line_id; -- loan_line_id
475:
476: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.source_id_int_1 = ' || l_loan_details.source_id_int_1);
477: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.source_id_int_2 = ' || l_loan_details.source_id_int_2);
478: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.source_id_int_3 = ' || l_loan_details.source_id_int_3);
479: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.source_id_int_4 = ' || l_loan_details.source_id_int_4);
480: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.entity_type_code = ' || l_loan_details.entity_type_code);
481:

Line 478: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.source_id_int_3 = ' || l_loan_details.source_id_int_3);

474: l_loan_details.source_id_int_4 := p_loan_line_id; -- loan_line_id
475:
476: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.source_id_int_1 = ' || l_loan_details.source_id_int_1);
477: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.source_id_int_2 = ' || l_loan_details.source_id_int_2);
478: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.source_id_int_3 = ' || l_loan_details.source_id_int_3);
479: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.source_id_int_4 = ' || l_loan_details.source_id_int_4);
480: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.entity_type_code = ' || l_loan_details.entity_type_code);
481:
482: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling XLA_EVENTS_PUB_PKG.Update_event...');

Line 479: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.source_id_int_4 = ' || l_loan_details.source_id_int_4);

475:
476: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.source_id_int_1 = ' || l_loan_details.source_id_int_1);
477: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.source_id_int_2 = ' || l_loan_details.source_id_int_2);
478: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.source_id_int_3 = ' || l_loan_details.source_id_int_3);
479: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.source_id_int_4 = ' || l_loan_details.source_id_int_4);
480: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.entity_type_code = ' || l_loan_details.entity_type_code);
481:
482: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling XLA_EVENTS_PUB_PKG.Update_event...');
483: XLA_EVENTS_PUB_PKG.Update_event(p_event_source_info => l_loan_details

Line 480: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.entity_type_code = ' || l_loan_details.entity_type_code);

476: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.source_id_int_1 = ' || l_loan_details.source_id_int_1);
477: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.source_id_int_2 = ' || l_loan_details.source_id_int_2);
478: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.source_id_int_3 = ' || l_loan_details.source_id_int_3);
479: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.source_id_int_4 = ' || l_loan_details.source_id_int_4);
480: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.entity_type_code = ' || l_loan_details.entity_type_code);
481:
482: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling XLA_EVENTS_PUB_PKG.Update_event...');
483: XLA_EVENTS_PUB_PKG.Update_event(p_event_source_info => l_loan_details
484: ,p_event_id => p_event_id

Line 482: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling XLA_EVENTS_PUB_PKG.Update_event...');

478: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.source_id_int_3 = ' || l_loan_details.source_id_int_3);
479: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.source_id_int_4 = ' || l_loan_details.source_id_int_4);
480: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.entity_type_code = ' || l_loan_details.entity_type_code);
481:
482: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling XLA_EVENTS_PUB_PKG.Update_event...');
483: XLA_EVENTS_PUB_PKG.Update_event(p_event_source_info => l_loan_details
484: ,p_event_id => p_event_id
485: ,p_event_type_code => p_event_type_code
486: ,p_event_date => p_event_date

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

492: -- End of API body
493: -- ---------------------------------------------------------------------
494: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
495:
496: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
497:
498: EXCEPTION
499: WHEN FND_API.G_EXC_ERROR THEN
500: x_return_status := FND_API.G_RET_STS_ERROR;

Line 504: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

500: x_return_status := FND_API.G_RET_STS_ERROR;
501: x_msg_count := l_msg_count;
502: x_msg_data := l_msg_data;
503: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
504: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
505: ROLLBACK TO update_event;
506:
507: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
508: x_return_status := FND_API.G_RET_STS_ERROR;

Line 512: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

508: x_return_status := FND_API.G_RET_STS_ERROR;
509: x_msg_count := l_msg_count;
510: x_msg_data := l_msg_data;
511: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
512: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
513: ROLLBACK TO update_event;
514:
515: WHEN OTHERS THEN
516: x_return_status := FND_API.G_RET_STS_ERROR;

Line 520: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

516: x_return_status := FND_API.G_RET_STS_ERROR;
517: x_msg_count := l_msg_count;
518: x_msg_data := l_msg_data;
519: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
520: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
521: ROLLBACK TO update_event;
522:
523: end update_event;
524:

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

580: l_sob_id number;
581:
582: begin
583: l_api_name := 'delete_event';
584: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');
585: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - event_id ' || p_event_id);
586: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'loan_id = ' || p_loan_id);
587: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_disb_header_id = ' || p_disb_header_id);
588: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_loan_amount_adj_id = ' || p_loan_amount_adj_id);

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

581:
582: begin
583: l_api_name := 'delete_event';
584: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');
585: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - event_id ' || p_event_id);
586: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'loan_id = ' || p_loan_id);
587: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_disb_header_id = ' || p_disb_header_id);
588: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_loan_amount_adj_id = ' || p_loan_amount_adj_id);
589: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_loan_line_id = ' || p_loan_line_id);

Line 586: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'loan_id = ' || p_loan_id);

582: begin
583: l_api_name := 'delete_event';
584: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');
585: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - event_id ' || p_event_id);
586: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'loan_id = ' || p_loan_id);
587: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_disb_header_id = ' || p_disb_header_id);
588: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_loan_amount_adj_id = ' || p_loan_amount_adj_id);
589: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_loan_line_id = ' || p_loan_line_id);
590:

Line 587: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_disb_header_id = ' || p_disb_header_id);

583: l_api_name := 'delete_event';
584: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');
585: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - event_id ' || p_event_id);
586: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'loan_id = ' || p_loan_id);
587: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_disb_header_id = ' || p_disb_header_id);
588: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_loan_amount_adj_id = ' || p_loan_amount_adj_id);
589: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_loan_line_id = ' || p_loan_line_id);
590:
591:

Line 588: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_loan_amount_adj_id = ' || p_loan_amount_adj_id);

584: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');
585: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - event_id ' || p_event_id);
586: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'loan_id = ' || p_loan_id);
587: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_disb_header_id = ' || p_disb_header_id);
588: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_loan_amount_adj_id = ' || p_loan_amount_adj_id);
589: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_loan_line_id = ' || p_loan_line_id);
590:
591:
592: -- Standard Start of API savepoint

Line 589: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_loan_line_id = ' || p_loan_line_id);

585: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - event_id ' || p_event_id);
586: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'loan_id = ' || p_loan_id);
587: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_disb_header_id = ' || p_disb_header_id);
588: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_loan_amount_adj_id = ' || p_loan_amount_adj_id);
589: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_loan_line_id = ' || p_loan_line_id);
590:
591:
592: -- Standard Start of API savepoint
593: SAVEPOINT delete_event;

Line 615: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_legal_entity_id = ' || l_legal_entity_id);

611: open c_sob_id(p_loan_id);
612: fetch c_sob_id into l_sob_id;
613: close c_sob_id;
614:
615: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_legal_entity_id = ' || l_legal_entity_id);
616: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_sob_id = ' || l_sob_id);
617:
618: -- initialize any variables here
619: l_loan_details.application_id := 206; -- XLA registered application

Line 616: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_sob_id = ' || l_sob_id);

612: fetch c_sob_id into l_sob_id;
613: close c_sob_id;
614:
615: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_legal_entity_id = ' || l_legal_entity_id);
616: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_sob_id = ' || l_sob_id);
617:
618: -- initialize any variables here
619: l_loan_details.application_id := 206; -- XLA registered application
620: l_loan_details.legal_entity_id := l_legal_entity_id; --

Line 628: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.source_id_int_1 = ' || l_loan_details.source_id_int_1);

624: l_loan_details.source_id_int_2 := p_disb_header_id; -- disb_header_id
625: l_loan_details.source_id_int_3 := p_loan_amount_adj_id; -- loan_amount_adj_id
626: l_loan_details.source_id_int_4 := p_loan_line_id; -- loan_line_id
627:
628: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.source_id_int_1 = ' || l_loan_details.source_id_int_1);
629: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.source_id_int_2 = ' || l_loan_details.source_id_int_2);
630: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.source_id_int_3 = ' || l_loan_details.source_id_int_3);
631: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.source_id_int_4 = ' || l_loan_details.source_id_int_4);
632: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.entity_type_code = ' || l_loan_details.entity_type_code);

Line 629: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.source_id_int_2 = ' || l_loan_details.source_id_int_2);

625: l_loan_details.source_id_int_3 := p_loan_amount_adj_id; -- loan_amount_adj_id
626: l_loan_details.source_id_int_4 := p_loan_line_id; -- loan_line_id
627:
628: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.source_id_int_1 = ' || l_loan_details.source_id_int_1);
629: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.source_id_int_2 = ' || l_loan_details.source_id_int_2);
630: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.source_id_int_3 = ' || l_loan_details.source_id_int_3);
631: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.source_id_int_4 = ' || l_loan_details.source_id_int_4);
632: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.entity_type_code = ' || l_loan_details.entity_type_code);
633:

Line 630: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.source_id_int_3 = ' || l_loan_details.source_id_int_3);

626: l_loan_details.source_id_int_4 := p_loan_line_id; -- loan_line_id
627:
628: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.source_id_int_1 = ' || l_loan_details.source_id_int_1);
629: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.source_id_int_2 = ' || l_loan_details.source_id_int_2);
630: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.source_id_int_3 = ' || l_loan_details.source_id_int_3);
631: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.source_id_int_4 = ' || l_loan_details.source_id_int_4);
632: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.entity_type_code = ' || l_loan_details.entity_type_code);
633:
634:

Line 631: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.source_id_int_4 = ' || l_loan_details.source_id_int_4);

627:
628: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.source_id_int_1 = ' || l_loan_details.source_id_int_1);
629: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.source_id_int_2 = ' || l_loan_details.source_id_int_2);
630: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.source_id_int_3 = ' || l_loan_details.source_id_int_3);
631: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.source_id_int_4 = ' || l_loan_details.source_id_int_4);
632: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.entity_type_code = ' || l_loan_details.entity_type_code);
633:
634:
635: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling XLA_EVENTS_PUB_PKG.delete_event...');

Line 632: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.entity_type_code = ' || l_loan_details.entity_type_code);

628: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.source_id_int_1 = ' || l_loan_details.source_id_int_1);
629: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.source_id_int_2 = ' || l_loan_details.source_id_int_2);
630: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.source_id_int_3 = ' || l_loan_details.source_id_int_3);
631: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.source_id_int_4 = ' || l_loan_details.source_id_int_4);
632: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.entity_type_code = ' || l_loan_details.entity_type_code);
633:
634:
635: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling XLA_EVENTS_PUB_PKG.delete_event...');
636: XLA_EVENTS_PUB_PKG.delete_event

Line 635: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling XLA_EVENTS_PUB_PKG.delete_event...');

631: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.source_id_int_4 = ' || l_loan_details.source_id_int_4);
632: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.entity_type_code = ' || l_loan_details.entity_type_code);
633:
634:
635: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling XLA_EVENTS_PUB_PKG.delete_event...');
636: XLA_EVENTS_PUB_PKG.delete_event
637: (p_event_source_info => l_loan_details
638: ,p_event_id => p_event_id
639: ,p_valuation_method => null

Line 642: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Deleted event_id '||p_event_id||' successfully');

638: ,p_event_id => p_event_id
639: ,p_valuation_method => null
640: ,p_security_context => l_security_context);
641:
642: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Deleted event_id '||p_event_id||' successfully');
643:
644: -- ---------------------------------------------------------------------
645: -- End of API body
646: -- ---------------------------------------------------------------------

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

645: -- End of API body
646: -- ---------------------------------------------------------------------
647: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
648:
649: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
650:
651: EXCEPTION
652: WHEN FND_API.G_EXC_ERROR THEN
653: x_return_status := FND_API.G_RET_STS_ERROR;

Line 657: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

653: x_return_status := FND_API.G_RET_STS_ERROR;
654: x_msg_count := l_msg_count;
655: x_msg_data := l_msg_data;
656: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
657: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
658: ROLLBACK TO delete_event;
659:
660: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
661: x_return_status := FND_API.G_RET_STS_ERROR;

Line 665: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

661: x_return_status := FND_API.G_RET_STS_ERROR;
662: x_msg_count := l_msg_count;
663: x_msg_data := l_msg_data;
664: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
665: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
666: ROLLBACK TO delete_event;
667:
668: WHEN OTHERS THEN
669: x_return_status := FND_API.G_RET_STS_ERROR;

Line 673: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

669: x_return_status := FND_API.G_RET_STS_ERROR;
670: x_msg_count := l_msg_count;
671: x_msg_data := l_msg_data;
672: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
673: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
674: ROLLBACK TO delete_event;
675:
676: end delete_event;
677: