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.PSA_MFAR_RECEIPTS dependencies on FND_LOG

Line 15: --===========================FND_LOG.START=====================================

11: TYPE TrxLinesTyp IS TABLE OF ra_customer_trx_lines.customer_trx_line_id%TYPE
12: INDEX BY BINARY_INTEGER;
13:
14: TrxLinesTab TrxLinesTyp;
15: --===========================FND_LOG.START=====================================
16: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;
17: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
18: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
19: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;

Line 16: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;

12: INDEX BY BINARY_INTEGER;
13:
14: TrxLinesTab TrxLinesTyp;
15: --===========================FND_LOG.START=====================================
16: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;
17: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
18: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
19: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
20: g_error_level NUMBER := FND_LOG.LEVEL_ERROR;

Line 17: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

13:
14: TrxLinesTab TrxLinesTyp;
15: --===========================FND_LOG.START=====================================
16: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;
17: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
18: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
19: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
20: g_error_level NUMBER := FND_LOG.LEVEL_ERROR;
21: g_unexp_level NUMBER := FND_LOG.LEVEL_UNEXPECTED;

Line 18: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;

14: TrxLinesTab TrxLinesTyp;
15: --===========================FND_LOG.START=====================================
16: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;
17: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
18: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
19: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
20: g_error_level NUMBER := FND_LOG.LEVEL_ERROR;
21: g_unexp_level NUMBER := FND_LOG.LEVEL_UNEXPECTED;
22: g_path VARCHAR2(50) := 'PSA.PLSQL.PSAMFRTB.PSA_MFAR_RECEIPTS.';

Line 19: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;

15: --===========================FND_LOG.START=====================================
16: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;
17: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
18: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
19: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
20: g_error_level NUMBER := FND_LOG.LEVEL_ERROR;
21: g_unexp_level NUMBER := FND_LOG.LEVEL_UNEXPECTED;
22: g_path VARCHAR2(50) := 'PSA.PLSQL.PSAMFRTB.PSA_MFAR_RECEIPTS.';
23: --===========================FND_LOG.END=======================================

Line 20: g_error_level NUMBER := FND_LOG.LEVEL_ERROR;

16: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;
17: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
18: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
19: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
20: g_error_level NUMBER := FND_LOG.LEVEL_ERROR;
21: g_unexp_level NUMBER := FND_LOG.LEVEL_UNEXPECTED;
22: g_path VARCHAR2(50) := 'PSA.PLSQL.PSAMFRTB.PSA_MFAR_RECEIPTS.';
23: --===========================FND_LOG.END=======================================
24:

Line 21: g_unexp_level NUMBER := FND_LOG.LEVEL_UNEXPECTED;

17: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
18: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
19: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
20: g_error_level NUMBER := FND_LOG.LEVEL_ERROR;
21: g_unexp_level NUMBER := FND_LOG.LEVEL_UNEXPECTED;
22: g_path VARCHAR2(50) := 'PSA.PLSQL.PSAMFRTB.PSA_MFAR_RECEIPTS.';
23: --===========================FND_LOG.END=======================================
24:
25:

Line 23: --===========================FND_LOG.END=======================================

19: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
20: g_error_level NUMBER := FND_LOG.LEVEL_ERROR;
21: g_unexp_level NUMBER := FND_LOG.LEVEL_UNEXPECTED;
22: g_path VARCHAR2(50) := 'PSA.PLSQL.PSAMFRTB.PSA_MFAR_RECEIPTS.';
23: --===========================FND_LOG.END=======================================
24:
25:
26: -- Variables for currency code
27:

Line 183: -- ========================= FND LOG ===========================

179: l_currency_code VARCHAR2(15);
180:
181: generate_rct_dist_excep EXCEPTION;
182:
183: -- ========================= FND LOG ===========================
184: l_full_path VARCHAR2(100) := g_path || 'create_distributions';
185: -- ========================= FND LOG ===========================
186:
187: BEGIN

Line 185: -- ========================= FND LOG ===========================

181: generate_rct_dist_excep EXCEPTION;
182:
183: -- ========================= FND LOG ===========================
184: l_full_path VARCHAR2(100) := g_path || 'create_distributions';
185: -- ========================= FND LOG ===========================
186:
187: BEGIN
188:
189: -- ========================= FND LOG ===========================

Line 189: -- ========================= FND LOG ===========================

185: -- ========================= FND LOG ===========================
186:
187: BEGIN
188:
189: -- ========================= FND LOG ===========================
190: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
191: psa_utils.debug_other_string(g_state_level,l_full_path,' Starting create_distributions');
192: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
193: psa_utils.debug_other_string(g_state_level,l_full_path,' PARAMETERS :');

Line 199: -- ========================= FND LOG ===========================

195: psa_utils.debug_other_string(g_state_level,l_full_path,' p_receivable_app_id -->' || p_receivable_app_id);
196: psa_utils.debug_other_string(g_state_level,l_full_path,' p_set_of_books_id -->' || p_set_of_books_id);
197: psa_utils.debug_other_string(g_state_level,l_full_path,' p_run_id -->' || p_run_id);
198: psa_utils.debug_other_string(g_state_level,l_full_path,' Starting the process ');
199: -- ========================= FND LOG ===========================
200:
201: --
202: -- Initialize Global Variables
203: --

Line 222: -- ========================= FND LOG ===========================

218: g_precision ,
219: g_ext_precision,
220: g_min_acct_unit);
221:
222: -- ========================= FND LOG ===========================
223: psa_utils.debug_other_string(g_state_level,l_full_path,' Setting retcode to --> ' || retcode);
224: -- ========================= FND LOG ===========================
225:
226: g_set_of_books_id := p_set_of_books_id;

Line 224: -- ========================= FND LOG ===========================

220: g_min_acct_unit);
221:
222: -- ========================= FND LOG ===========================
223: psa_utils.debug_other_string(g_state_level,l_full_path,' Setting retcode to --> ' || retcode);
224: -- ========================= FND LOG ===========================
225:
226: g_set_of_books_id := p_set_of_books_id;
227: g_receivable_application_id := p_receivable_app_id;
228: g_run_id := p_run_id;

Line 250: -- ========================= FND LOG ===========================

246: -- Cash Mgt : the function should check for existence of Cash
247: -- and/or remittance MFAR distributions
248: --
249:
250: -- ========================= FND LOG ===========================
251: psa_utils.debug_other_string(g_state_level,l_full_path,' Calling distributions_exist_and_valid ');
252: -- ========================= FND LOG ===========================
253:
254: IF NOT (distributions_exist_and_valid (p_receivable_app_id)) THEN -- 1

Line 252: -- ========================= FND LOG ===========================

248: --
249:
250: -- ========================= FND LOG ===========================
251: psa_utils.debug_other_string(g_state_level,l_full_path,' Calling distributions_exist_and_valid ');
252: -- ========================= FND LOG ===========================
253:
254: IF NOT (distributions_exist_and_valid (p_receivable_app_id)) THEN -- 1
255:
256: -- ========================= FND LOG ===========================

Line 256: -- ========================= FND LOG ===========================

252: -- ========================= FND LOG ===========================
253:
254: IF NOT (distributions_exist_and_valid (p_receivable_app_id)) THEN -- 1
255:
256: -- ========================= FND LOG ===========================
257: psa_utils.debug_other_string(g_state_level,l_full_path,' Inside first if ' );
258: psa_utils.debug_other_string(g_state_level,l_full_path,' distributions_exist_and_valid -> TRUE ');
259: -- ========================= FND LOG ===========================
260:

Line 259: -- ========================= FND LOG ===========================

255:
256: -- ========================= FND LOG ===========================
257: psa_utils.debug_other_string(g_state_level,l_full_path,' Inside first if ' );
258: psa_utils.debug_other_string(g_state_level,l_full_path,' distributions_exist_and_valid -> TRUE ');
259: -- ========================= FND LOG ===========================
260:
261: -- Initialize global variable
262: g_cust_trx_id := l_rcpt_application_rec.cust_trx_id;
263:

Line 264: -- ========================= FND LOG ===========================

260:
261: -- Initialize global variable
262: g_cust_trx_id := l_rcpt_application_rec.cust_trx_id;
263:
264: -- ========================= FND LOG ===========================
265: psa_utils.debug_other_string(g_state_level,l_full_path,' g_cust_trx_id -> ' || g_cust_trx_id );
266: psa_utils.debug_other_string(g_state_level,l_full_path,' l_rcpt_application_rec.cash_receipt_id -> ' || l_rcpt_application_rec.cash_receipt_id );
267: -- ========================= FND LOG ===========================
268:

Line 267: -- ========================= FND LOG ===========================

263:
264: -- ========================= FND LOG ===========================
265: psa_utils.debug_other_string(g_state_level,l_full_path,' g_cust_trx_id -> ' || g_cust_trx_id );
266: psa_utils.debug_other_string(g_state_level,l_full_path,' l_rcpt_application_rec.cash_receipt_id -> ' || l_rcpt_application_rec.cash_receipt_id );
267: -- ========================= FND LOG ===========================
268:
269: IF l_rcpt_application_rec.cash_receipt_id IS NULL THEN -- CREDIT MEMO APPLICATION
270: -- ========================= FND LOG ===========================
271: psa_utils.debug_other_string(g_state_level,l_full_path,' Inside Second if');

Line 270: -- ========================= FND LOG ===========================

266: psa_utils.debug_other_string(g_state_level,l_full_path,' l_rcpt_application_rec.cash_receipt_id -> ' || l_rcpt_application_rec.cash_receipt_id );
267: -- ========================= FND LOG ===========================
268:
269: IF l_rcpt_application_rec.cash_receipt_id IS NULL THEN -- CREDIT MEMO APPLICATION
270: -- ========================= FND LOG ===========================
271: psa_utils.debug_other_string(g_state_level,l_full_path,' Inside Second if');
272: -- ========================= FND LOG ===========================
273:
274: l_ccid := l_rcpt_application_rec.rec_ccid;

Line 272: -- ========================= FND LOG ===========================

268:
269: IF l_rcpt_application_rec.cash_receipt_id IS NULL THEN -- CREDIT MEMO APPLICATION
270: -- ========================= FND LOG ===========================
271: psa_utils.debug_other_string(g_state_level,l_full_path,' Inside Second if');
272: -- ========================= FND LOG ===========================
273:
274: l_ccid := l_rcpt_application_rec.rec_ccid;
275: -- ========================= FND LOG ===========================
276: psa_utils.debug_other_string(g_state_level,l_full_path,' l_ccid --> ' || l_ccid);

Line 275: -- ========================= FND LOG ===========================

271: psa_utils.debug_other_string(g_state_level,l_full_path,' Inside Second if');
272: -- ========================= FND LOG ===========================
273:
274: l_ccid := l_rcpt_application_rec.rec_ccid;
275: -- ========================= FND LOG ===========================
276: psa_utils.debug_other_string(g_state_level,l_full_path,' l_ccid --> ' || l_ccid);
277: -- ========================= FND LOG ===========================
278:
279: OPEN c_credit_memo_type (l_rcpt_application_rec.cm_trx_id);

Line 277: -- ========================= FND LOG ===========================

273:
274: l_ccid := l_rcpt_application_rec.rec_ccid;
275: -- ========================= FND LOG ===========================
276: psa_utils.debug_other_string(g_state_level,l_full_path,' l_ccid --> ' || l_ccid);
277: -- ========================= FND LOG ===========================
278:
279: OPEN c_credit_memo_type (l_rcpt_application_rec.cm_trx_id);
280: FETCH c_credit_memo_type INTO l_credit_memo_type;
281: CLOSE c_credit_memo_type;

Line 283: -- ========================= FND LOG ===========================

279: OPEN c_credit_memo_type (l_rcpt_application_rec.cm_trx_id);
280: FETCH c_credit_memo_type INTO l_credit_memo_type;
281: CLOSE c_credit_memo_type;
282:
283: -- ========================= FND LOG ===========================
284: psa_utils.debug_other_string(g_state_level,l_full_path,' Credit memo type --> ' || l_credit_memo_type.previous_customer_trx_id);
285: -- ========================= FND LOG ===========================
286:
287: IF l_credit_memo_type.previous_customer_trx_id IS NOT NULL THEN -- Direct Credit Memo if

Line 285: -- ========================= FND LOG ===========================

281: CLOSE c_credit_memo_type;
282:
283: -- ========================= FND LOG ===========================
284: psa_utils.debug_other_string(g_state_level,l_full_path,' Credit memo type --> ' || l_credit_memo_type.previous_customer_trx_id);
285: -- ========================= FND LOG ===========================
286:
287: IF l_credit_memo_type.previous_customer_trx_id IS NOT NULL THEN -- Direct Credit Memo if
288:
289: -- ========================= FND LOG ===========================

Line 289: -- ========================= FND LOG ===========================

285: -- ========================= FND LOG ===========================
286:
287: IF l_credit_memo_type.previous_customer_trx_id IS NOT NULL THEN -- Direct Credit Memo if
288:
289: -- ========================= FND LOG ===========================
290: psa_utils.debug_other_string(g_state_level,l_full_path,' Inside third if');
291: psa_utils.debug_other_string(g_state_level,l_full_path,' l_rcpt_application_rec.cm_trx_id --> ' || l_rcpt_application_rec.cm_trx_id);
292: -- ========================= FND LOG ===========================
293:

Line 292: -- ========================= FND LOG ===========================

288:
289: -- ========================= FND LOG ===========================
290: psa_utils.debug_other_string(g_state_level,l_full_path,' Inside third if');
291: psa_utils.debug_other_string(g_state_level,l_full_path,' l_rcpt_application_rec.cm_trx_id --> ' || l_rcpt_application_rec.cm_trx_id);
292: -- ========================= FND LOG ===========================
293:
294: OPEN c_direct_cm (l_rcpt_application_rec.cm_trx_id);
295: LOOP
296:

Line 300: -- ========================= FND LOG ===========================

296:
297: FETCH c_direct_cm INTO l_direct_cm;
298: EXIT WHEN c_direct_cm%NOTFOUND;
299:
300: -- ========================= FND LOG ===========================
301: psa_utils.debug_other_string(g_state_level,l_full_path,' l_direct_cm.trx_line_id --> ' || l_direct_cm.trx_line_id);
302: -- ========================= FND LOG ===========================
303:
304: OPEN c_direct_cm_line_amount(l_rcpt_application_rec.cm_trx_id,

Line 302: -- ========================= FND LOG ===========================

298: EXIT WHEN c_direct_cm%NOTFOUND;
299:
300: -- ========================= FND LOG ===========================
301: psa_utils.debug_other_string(g_state_level,l_full_path,' l_direct_cm.trx_line_id --> ' || l_direct_cm.trx_line_id);
302: -- ========================= FND LOG ===========================
303:
304: OPEN c_direct_cm_line_amount(l_rcpt_application_rec.cm_trx_id,
305: l_direct_cm.trx_line_id);
306: FETCH c_direct_cm_line_amount INTO l_direct_cm_line_amount;

Line 309: -- ========================= FND LOG ===========================

305: l_direct_cm.trx_line_id);
306: FETCH c_direct_cm_line_amount INTO l_direct_cm_line_amount;
307: CLOSE c_direct_cm_line_amount;
308:
309: -- ========================= FND LOG ===========================
310: psa_utils.debug_other_string(g_state_level,l_full_path,' l_direct_cm_line_amount --> ' ||l_direct_cm_line_amount.line_amount);
311: psa_utils.debug_other_string(g_state_level,l_full_path,' Calling GENERATE_RCT_DIST ');
312: -- ========================= FND LOG ===========================
313:

Line 312: -- ========================= FND LOG ===========================

308:
309: -- ========================= FND LOG ===========================
310: psa_utils.debug_other_string(g_state_level,l_full_path,' l_direct_cm_line_amount --> ' ||l_direct_cm_line_amount.line_amount);
311: psa_utils.debug_other_string(g_state_level,l_full_path,' Calling GENERATE_RCT_DIST ');
312: -- ========================= FND LOG ===========================
313:
314: IF NOT (GENERATE_RCT_DIST_CM
315: (errbuf => errbuf,
316: retcode => retcode,

Line 332: -- ========================= FND LOG ===========================

328: p_document_type => 'CM',
329: p_crh_status => NULL,
330: p_error_message => l_exception_message)) THEN
331:
332: -- ========================= FND LOG ===========================
333: psa_utils.debug_other_string(g_state_level,l_full_path,' Generate_rct_dist --> FALSE ');
334: psa_utils.debug_other_string(g_state_level,l_full_path,' Raising generate_rct_dist_excep');
335: -- ========================= FND LOG ===========================
336: RAISE generate_rct_dist_excep;

Line 335: -- ========================= FND LOG ===========================

331:
332: -- ========================= FND LOG ===========================
333: psa_utils.debug_other_string(g_state_level,l_full_path,' Generate_rct_dist --> FALSE ');
334: psa_utils.debug_other_string(g_state_level,l_full_path,' Raising generate_rct_dist_excep');
335: -- ========================= FND LOG ===========================
336: RAISE generate_rct_dist_excep;
337: ELSE
338: -- ========================= FND LOG ===========================
339: psa_utils.debug_other_string(g_state_level,l_full_path,' Generate_rct_dist --> TRUE ');

Line 338: -- ========================= FND LOG ===========================

334: psa_utils.debug_other_string(g_state_level,l_full_path,' Raising generate_rct_dist_excep');
335: -- ========================= FND LOG ===========================
336: RAISE generate_rct_dist_excep;
337: ELSE
338: -- ========================= FND LOG ===========================
339: psa_utils.debug_other_string(g_state_level,l_full_path,' Generate_rct_dist --> TRUE ');
340: -- ========================= FND LOG ===========================
341: END IF;
342: END LOOP;

Line 340: -- ========================= FND LOG ===========================

336: RAISE generate_rct_dist_excep;
337: ELSE
338: -- ========================= FND LOG ===========================
339: psa_utils.debug_other_string(g_state_level,l_full_path,' Generate_rct_dist --> TRUE ');
340: -- ========================= FND LOG ===========================
341: END IF;
342: END LOOP;
343:
344: -- ========================= FND LOG ===========================

Line 344: -- ========================= FND LOG ===========================

340: -- ========================= FND LOG ===========================
341: END IF;
342: END LOOP;
343:
344: -- ========================= FND LOG ===========================
345: psa_utils.debug_other_string(g_state_level,l_full_path,' out of c_direct_cm loop');
346: -- ========================= FND LOG ===========================
347: CLOSE c_direct_cm;
348:

Line 346: -- ========================= FND LOG ===========================

342: END LOOP;
343:
344: -- ========================= FND LOG ===========================
345: psa_utils.debug_other_string(g_state_level,l_full_path,' out of c_direct_cm loop');
346: -- ========================= FND LOG ===========================
347: CLOSE c_direct_cm;
348:
349: ELSE -- On Account Credit Memo
350:

Line 351: -- ========================= FND LOG ===========================

347: CLOSE c_direct_cm;
348:
349: ELSE -- On Account Credit Memo
350:
351: -- ========================= FND LOG ===========================
352: psa_utils.debug_other_string(g_state_level,l_full_path,' Inside third else');
353: psa_utils.debug_other_string(g_state_level,l_full_path,' On Account Credit memo (cust_trx_line_id) --> ' || l_rcpt_application_rec.cust_trx_line_id);
354: psa_utils.debug_other_string(g_state_level,l_full_path,' Calling GENERATE_RCT_DIST ');
355: -- ========================= FND LOG ===========================

Line 355: -- ========================= FND LOG ===========================

351: -- ========================= FND LOG ===========================
352: psa_utils.debug_other_string(g_state_level,l_full_path,' Inside third else');
353: psa_utils.debug_other_string(g_state_level,l_full_path,' On Account Credit memo (cust_trx_line_id) --> ' || l_rcpt_application_rec.cust_trx_line_id);
354: psa_utils.debug_other_string(g_state_level,l_full_path,' Calling GENERATE_RCT_DIST ');
355: -- ========================= FND LOG ===========================
356:
357: -- Bug 3107904 amount_applied*-1 for parameter : p_amount_applied of GENERATE_RCT_DIST
358:
359: IF NOT (GENERATE_RCT_DIST

Line 375: -- ========================= FND LOG ===========================

371: p_document_type => 'CM',
372: p_crh_status => NULL,
373: p_error_message => l_exception_message)) THEN
374:
375: -- ========================= FND LOG ===========================
376: psa_utils.debug_other_string(g_state_level,l_full_path,' Generate_rct_dist --> FALSE ');
377: psa_utils.debug_other_string(g_state_level,l_full_path,' Raising generate_rct_dist_excep');
378: -- ========================= FND LOG ===========================
379: RAISE generate_rct_dist_excep;

Line 378: -- ========================= FND LOG ===========================

374:
375: -- ========================= FND LOG ===========================
376: psa_utils.debug_other_string(g_state_level,l_full_path,' Generate_rct_dist --> FALSE ');
377: psa_utils.debug_other_string(g_state_level,l_full_path,' Raising generate_rct_dist_excep');
378: -- ========================= FND LOG ===========================
379: RAISE generate_rct_dist_excep;
380: ELSE
381: -- ========================= FND LOG ===========================
382: psa_utils.debug_other_string(g_state_level,l_full_path,' Generate_rct_dist --> TRUE ');

Line 381: -- ========================= FND LOG ===========================

377: psa_utils.debug_other_string(g_state_level,l_full_path,' Raising generate_rct_dist_excep');
378: -- ========================= FND LOG ===========================
379: RAISE generate_rct_dist_excep;
380: ELSE
381: -- ========================= FND LOG ===========================
382: psa_utils.debug_other_string(g_state_level,l_full_path,' Generate_rct_dist --> TRUE ');
383: -- ========================= FND LOG ===========================
384: END IF;
385:

Line 383: -- ========================= FND LOG ===========================

379: RAISE generate_rct_dist_excep;
380: ELSE
381: -- ========================= FND LOG ===========================
382: psa_utils.debug_other_string(g_state_level,l_full_path,' Generate_rct_dist --> TRUE ');
383: -- ========================= FND LOG ===========================
384: END IF;
385:
386: END IF; -- Direct Credit Memo end if
387:

Line 389: -- ========================= FND LOG ===========================

385:
386: END IF; -- Direct Credit Memo end if
387:
388: ELSE
389: -- ========================= FND LOG ===========================
390: psa_utils.debug_other_string(g_state_level,l_full_path,' Inside second else ');
391: psa_utils.debug_other_string(g_state_level,l_full_path,' l_rcpt_application_rec.cash_receipt_id IS NULL');
392: -- ========================= FND LOG ===========================
393: END IF; -- Credit memo application end if

Line 392: -- ========================= FND LOG ===========================

388: ELSE
389: -- ========================= FND LOG ===========================
390: psa_utils.debug_other_string(g_state_level,l_full_path,' Inside second else ');
391: psa_utils.debug_other_string(g_state_level,l_full_path,' l_rcpt_application_rec.cash_receipt_id IS NULL');
392: -- ========================= FND LOG ===========================
393: END IF; -- Credit memo application end if
394:
395: ELSE
396: -- ========================= FND LOG ===========================

Line 396: -- ========================= FND LOG ===========================

392: -- ========================= FND LOG ===========================
393: END IF; -- Credit memo application end if
394:
395: ELSE
396: -- ========================= FND LOG ===========================
397: psa_utils.debug_other_string(g_state_level,l_full_path,' Inside first else ');
398: psa_utils.debug_other_string(g_state_level,l_full_path,' distributions_exist_and_valid -> FALSE ');
399: -- ========================= FND LOG ===========================
400: END IF; -- 1 end if

Line 399: -- ========================= FND LOG ===========================

395: ELSE
396: -- ========================= FND LOG ===========================
397: psa_utils.debug_other_string(g_state_level,l_full_path,' Inside first else ');
398: psa_utils.debug_other_string(g_state_level,l_full_path,' distributions_exist_and_valid -> FALSE ');
399: -- ========================= FND LOG ===========================
400: END IF; -- 1 end if
401:
402:
403: -- ========================= FND LOG ===========================

Line 403: -- ========================= FND LOG ===========================

399: -- ========================= FND LOG ===========================
400: END IF; -- 1 end if
401:
402:
403: -- ========================= FND LOG ===========================
404: psa_utils.debug_other_string(g_state_level,l_full_path,' Cash receipt - Cash Management ');
405: -- ========================= FND LOG ===========================
406:
407: -- ## Cash receipt - Cash Management ##

Line 405: -- ========================= FND LOG ===========================

401:
402:
403: -- ========================= FND LOG ===========================
404: psa_utils.debug_other_string(g_state_level,l_full_path,' Cash receipt - Cash Management ');
405: -- ========================= FND LOG ===========================
406:
407: -- ## Cash receipt - Cash Management ##
408: IF (l_rcpt_application_rec.cash_receipt_id IS NOT NULL) THEN -- 2 if
409:

Line 413: -- ========================= FND LOG ===========================

409:
410: OPEN c_crh;
411: LOOP
412:
413: -- ========================= FND LOG ===========================
414: psa_utils.debug_other_string(g_state_level,l_full_path,' l_rcpt_application_rec.cash_receipt_id -> ' || l_rcpt_application_rec.cash_receipt_id);
415: -- ========================= FND LOG ===========================
416:
417: FETCH c_crh INTO c_crh_rec;

Line 415: -- ========================= FND LOG ===========================

411: LOOP
412:
413: -- ========================= FND LOG ===========================
414: psa_utils.debug_other_string(g_state_level,l_full_path,' l_rcpt_application_rec.cash_receipt_id -> ' || l_rcpt_application_rec.cash_receipt_id);
415: -- ========================= FND LOG ===========================
416:
417: FETCH c_crh INTO c_crh_rec;
418: EXIT WHEN c_crh%NOTFOUND;
419:

Line 420: -- ========================= FND LOG ===========================

416:
417: FETCH c_crh INTO c_crh_rec;
418: EXIT WHEN c_crh%NOTFOUND;
419:
420: -- ========================= FND LOG ===========================
421: psa_utils.debug_other_string(g_state_level,l_full_path,' Calling CASH_CLR_DIST_EXIST_VALID ');
422: -- ========================= FND LOG ===========================
423:
424: -- CASH RECEIPT APPLICATION

Line 422: -- ========================= FND LOG ===========================

418: EXIT WHEN c_crh%NOTFOUND;
419:
420: -- ========================= FND LOG ===========================
421: psa_utils.debug_other_string(g_state_level,l_full_path,' Calling CASH_CLR_DIST_EXIST_VALID ');
422: -- ========================= FND LOG ===========================
423:
424: -- CASH RECEIPT APPLICATION
425: IF (CASH_CLR_DIST_EXIST_VALID ( p_receivable_app_id,
426: l_rcpt_application_rec.amount_applied,

Line 430: -- ========================= FND LOG ===========================

426: l_rcpt_application_rec.amount_applied,
427: c_crh_rec.status))
428: THEN
429:
430: -- ========================= FND LOG ===========================
431: psa_utils.debug_other_string(g_state_level,l_full_path,' CASH_CLR_DIST_EXIST_VALID -> TRUE');
432: -- ========================= FND LOG ===========================
433: OPEN c_cash_ccid (l_rcpt_application_rec.cash_receipt_id,
434: c_crh_rec.status);

Line 432: -- ========================= FND LOG ===========================

428: THEN
429:
430: -- ========================= FND LOG ===========================
431: psa_utils.debug_other_string(g_state_level,l_full_path,' CASH_CLR_DIST_EXIST_VALID -> TRUE');
432: -- ========================= FND LOG ===========================
433: OPEN c_cash_ccid (l_rcpt_application_rec.cash_receipt_id,
434: c_crh_rec.status);
435: FETCH c_cash_ccid INTO l_cash_ccid;
436: CLOSE c_cash_ccid;

Line 439: -- ========================= FND LOG ===========================

435: FETCH c_cash_ccid INTO l_cash_ccid;
436: CLOSE c_cash_ccid;
437:
438: l_ccid := l_cash_ccid.cash_ccid;
439: -- ========================= FND LOG ===========================
440: psa_utils.debug_other_string(g_state_level,l_full_path,' cash_ccid - l_ccid -> ' || l_ccid);
441: -- ========================= FND LOG ===========================
442:
443: IF l_ccid IS NOT NULL THEN

Line 441: -- ========================= FND LOG ===========================

437:
438: l_ccid := l_cash_ccid.cash_ccid;
439: -- ========================= FND LOG ===========================
440: psa_utils.debug_other_string(g_state_level,l_full_path,' cash_ccid - l_ccid -> ' || l_ccid);
441: -- ========================= FND LOG ===========================
442:
443: IF l_ccid IS NOT NULL THEN
444:
445: -- ========================= FND LOG ===========================

Line 445: -- ========================= FND LOG ===========================

441: -- ========================= FND LOG ===========================
442:
443: IF l_ccid IS NOT NULL THEN
444:
445: -- ========================= FND LOG ===========================
446: psa_utils.debug_other_string(g_state_level,l_full_path,' Inside if - l_ccid is not null');
447: psa_utils.debug_other_string(g_state_level,l_full_path,' Calling generate_rct_dist ');
448: -- ========================= FND LOG ===========================
449:

Line 448: -- ========================= FND LOG ===========================

444:
445: -- ========================= FND LOG ===========================
446: psa_utils.debug_other_string(g_state_level,l_full_path,' Inside if - l_ccid is not null');
447: psa_utils.debug_other_string(g_state_level,l_full_path,' Calling generate_rct_dist ');
448: -- ========================= FND LOG ===========================
449:
450: IF NOT (GENERATE_RCT_DIST
451: (errbuf => errbuf,
452: retcode => retcode,

Line 466: -- ========================= FND LOG ===========================

462: p_document_type => 'RCT',
463: p_crh_status => c_crh_rec.status,
464: p_error_message => l_exception_message)) THEN
465:
466: -- ========================= FND LOG ===========================
467: psa_utils.debug_other_string(g_state_level,l_full_path,' Generate_rct_dist --> FALSE ');
468: psa_utils.debug_other_string(g_state_level,l_full_path,' Raising generate_rct_dist_excep');
469: -- ========================= FND LOG ===========================
470: RAISE generate_rct_dist_excep;

Line 469: -- ========================= FND LOG ===========================

465:
466: -- ========================= FND LOG ===========================
467: psa_utils.debug_other_string(g_state_level,l_full_path,' Generate_rct_dist --> FALSE ');
468: psa_utils.debug_other_string(g_state_level,l_full_path,' Raising generate_rct_dist_excep');
469: -- ========================= FND LOG ===========================
470: RAISE generate_rct_dist_excep;
471: ELSE
472: -- ========================= FND LOG ===========================
473: psa_utils.debug_other_string(g_state_level,l_full_path,' Generate_rct_dist --> TRUE ');

Line 472: -- ========================= FND LOG ===========================

468: psa_utils.debug_other_string(g_state_level,l_full_path,' Raising generate_rct_dist_excep');
469: -- ========================= FND LOG ===========================
470: RAISE generate_rct_dist_excep;
471: ELSE
472: -- ========================= FND LOG ===========================
473: psa_utils.debug_other_string(g_state_level,l_full_path,' Generate_rct_dist --> TRUE ');
474: -- ========================= FND LOG ===========================
475: END IF;
476: ELSE

Line 474: -- ========================= FND LOG ===========================

470: RAISE generate_rct_dist_excep;
471: ELSE
472: -- ========================= FND LOG ===========================
473: psa_utils.debug_other_string(g_state_level,l_full_path,' Generate_rct_dist --> TRUE ');
474: -- ========================= FND LOG ===========================
475: END IF;
476: ELSE
477: -- ========================= FND LOG ===========================
478: psa_utils.debug_other_string(g_state_level,l_full_path,' Inside else - l_ccid is NULL');

Line 477: -- ========================= FND LOG ===========================

473: psa_utils.debug_other_string(g_state_level,l_full_path,' Generate_rct_dist --> TRUE ');
474: -- ========================= FND LOG ===========================
475: END IF;
476: ELSE
477: -- ========================= FND LOG ===========================
478: psa_utils.debug_other_string(g_state_level,l_full_path,' Inside else - l_ccid is NULL');
479: -- ========================= FND LOG ===========================
480: END IF;
481:

Line 479: -- ========================= FND LOG ===========================

475: END IF;
476: ELSE
477: -- ========================= FND LOG ===========================
478: psa_utils.debug_other_string(g_state_level,l_full_path,' Inside else - l_ccid is NULL');
479: -- ========================= FND LOG ===========================
480: END IF;
481:
482: ELSE
483: -- ========================= FND LOG ===========================

Line 483: -- ========================= FND LOG ===========================

479: -- ========================= FND LOG ===========================
480: END IF;
481:
482: ELSE
483: -- ========================= FND LOG ===========================
484: psa_utils.debug_other_string(g_state_level,l_full_path,' CASH_CLR_DIST_EXIST_VALID -> FALSE ');
485: -- ========================= FND LOG ===========================
486: END IF;
487: END LOOP;

Line 485: -- ========================= FND LOG ===========================

481:
482: ELSE
483: -- ========================= FND LOG ===========================
484: psa_utils.debug_other_string(g_state_level,l_full_path,' CASH_CLR_DIST_EXIST_VALID -> FALSE ');
485: -- ========================= FND LOG ===========================
486: END IF;
487: END LOOP;
488: CLOSE c_crh;
489:

Line 491: -- ========================= FND LOG ===========================

487: END LOOP;
488: CLOSE c_crh;
489:
490: ELSE
491: -- ========================= FND LOG ===========================
492: psa_utils.debug_other_string(g_state_level,l_full_path,' Cash_receipt_id -> l_rcpt_application_rec.cash_receipt_id is null');
493: -- ========================= FND LOG ===========================
494: END IF;
495:

Line 493: -- ========================= FND LOG ===========================

489:
490: ELSE
491: -- ========================= FND LOG ===========================
492: psa_utils.debug_other_string(g_state_level,l_full_path,' Cash_receipt_id -> l_rcpt_application_rec.cash_receipt_id is null');
493: -- ========================= FND LOG ===========================
494: END IF;
495:
496: -- ========================= FND LOG ===========================
497: psa_utils.debug_other_string(g_state_level,l_full_path,' retcode --> ' || retcode);

Line 496: -- ========================= FND LOG ===========================

492: psa_utils.debug_other_string(g_state_level,l_full_path,' Cash_receipt_id -> l_rcpt_application_rec.cash_receipt_id is null');
493: -- ========================= FND LOG ===========================
494: END IF;
495:
496: -- ========================= FND LOG ===========================
497: psa_utils.debug_other_string(g_state_level,l_full_path,' retcode --> ' || retcode);
498: psa_utils.debug_other_string(g_state_level,l_full_path,' RETURN TRUE ');
499: -- ========================= FND LOG ===========================
500:

Line 499: -- ========================= FND LOG ===========================

495:
496: -- ========================= FND LOG ===========================
497: psa_utils.debug_other_string(g_state_level,l_full_path,' retcode --> ' || retcode);
498: psa_utils.debug_other_string(g_state_level,l_full_path,' RETURN TRUE ');
499: -- ========================= FND LOG ===========================
500:
501: retcode := 'S';
502: RETURN TRUE;
503:

Line 509: -- ========================= FND LOG ===========================

505: WHEN generate_rct_dist_excep THEN
506: retcode := 'F';
507: PSA_MFAR_UTILS.INSERT_DISTRIBUTIONS_LOG (g_run_id, 'RECEIPT', g_cust_trx_id, g_receivable_application_id, l_exception_message);
508: p_error_message := l_exception_message;
509: -- ========================= FND LOG ===========================
510: psa_utils.debug_other_string(g_excep_level,l_full_path,p_error_message);
511: -- ========================= FND LOG ===========================
512: RETURN FALSE;
513:

Line 511: -- ========================= FND LOG ===========================

507: PSA_MFAR_UTILS.INSERT_DISTRIBUTIONS_LOG (g_run_id, 'RECEIPT', g_cust_trx_id, g_receivable_application_id, l_exception_message);
508: p_error_message := l_exception_message;
509: -- ========================= FND LOG ===========================
510: psa_utils.debug_other_string(g_excep_level,l_full_path,p_error_message);
511: -- ========================= FND LOG ===========================
512: RETURN FALSE;
513:
514: WHEN OTHERS THEN
515: retcode := 'F';

Line 519: -- ========================= FND LOG ===========================

515: retcode := 'F';
516: p_error_message := 'EXCEPTION - OTHERS PACKAGE - PSA_MFAR_TRANSACTIONS.CREATE_DISTRIBUTIONS - ' || SQLERRM;
517: PSA_MFAR_UTILS.INSERT_DISTRIBUTIONS_LOG (g_run_id, 'RECEIPT', g_cust_trx_id, g_receivable_application_id,
518: p_error_message);
519: -- ========================= FND LOG ===========================
520: psa_utils.debug_other_string(g_excep_level,l_full_path,p_error_message);
521: psa_utils.debug_unexpected_msg(l_full_path);
522: -- ========================= FND LOG ===========================
523: RETURN FALSE;

Line 522: -- ========================= FND LOG ===========================

518: p_error_message);
519: -- ========================= FND LOG ===========================
520: psa_utils.debug_other_string(g_excep_level,l_full_path,p_error_message);
521: psa_utils.debug_unexpected_msg(l_full_path);
522: -- ========================= FND LOG ===========================
523: RETURN FALSE;
524:
525: END create_distributions;
526:

Line 532: -- ========================= FND LOG ===========================

528:
529: FUNCTION distributions_exist_and_valid(p_receivable_app_id IN NUMBER) RETURN BOOLEAN
530: IS
531: l_rct_dist_count NUMBER;
532: -- ========================= FND LOG ===========================
533: l_full_path VARCHAR2(100) := g_path || 'distributions_exist_and_valid';
534: -- ========================= FND LOG ===========================
535: BEGIN
536:

Line 534: -- ========================= FND LOG ===========================

530: IS
531: l_rct_dist_count NUMBER;
532: -- ========================= FND LOG ===========================
533: l_full_path VARCHAR2(100) := g_path || 'distributions_exist_and_valid';
534: -- ========================= FND LOG ===========================
535: BEGIN
536:
537: -- ========================= FND LOG ===========================
538: psa_utils.debug_other_string(g_state_level,l_full_path,' Distributions_exist_and_valid --> START');

Line 537: -- ========================= FND LOG ===========================

533: l_full_path VARCHAR2(100) := g_path || 'distributions_exist_and_valid';
534: -- ========================= FND LOG ===========================
535: BEGIN
536:
537: -- ========================= FND LOG ===========================
538: psa_utils.debug_other_string(g_state_level,l_full_path,' Distributions_exist_and_valid --> START');
539: -- ========================= FND LOG ===========================
540:
541: SELECT count(rct.receivable_application_id)

Line 539: -- ========================= FND LOG ===========================

535: BEGIN
536:
537: -- ========================= FND LOG ===========================
538: psa_utils.debug_other_string(g_state_level,l_full_path,' Distributions_exist_and_valid --> START');
539: -- ========================= FND LOG ===========================
540:
541: SELECT count(rct.receivable_application_id)
542: INTO l_rct_dist_count
543: FROM psa_mf_rct_dist_all rct

Line 546: -- ========================= FND LOG ===========================

542: INTO l_rct_dist_count
543: FROM psa_mf_rct_dist_all rct
544: WHERE rct.receivable_application_id = p_receivable_app_id;
545:
546: -- ========================= FND LOG ===========================
547: psa_utils.debug_other_string(g_state_level,l_full_path,' Distributions_exist_and_valid -> l_rct_dist_count ' || l_rct_dist_count);
548: -- ========================= FND LOG ===========================
549:
550: IF l_rct_dist_count > 0 THEN

Line 548: -- ========================= FND LOG ===========================

544: WHERE rct.receivable_application_id = p_receivable_app_id;
545:
546: -- ========================= FND LOG ===========================
547: psa_utils.debug_other_string(g_state_level,l_full_path,' Distributions_exist_and_valid -> l_rct_dist_count ' || l_rct_dist_count);
548: -- ========================= FND LOG ===========================
549:
550: IF l_rct_dist_count > 0 THEN
551: -- ========================= FND LOG ===========================
552: psa_utils.debug_other_string(g_state_level,l_full_path,' Distributions_exist_and_valid --> RETURN TRUE');

Line 551: -- ========================= FND LOG ===========================

547: psa_utils.debug_other_string(g_state_level,l_full_path,' Distributions_exist_and_valid -> l_rct_dist_count ' || l_rct_dist_count);
548: -- ========================= FND LOG ===========================
549:
550: IF l_rct_dist_count > 0 THEN
551: -- ========================= FND LOG ===========================
552: psa_utils.debug_other_string(g_state_level,l_full_path,' Distributions_exist_and_valid --> RETURN TRUE');
553: -- ========================= FND LOG ===========================
554: RETURN TRUE;
555: ELSE

Line 553: -- ========================= FND LOG ===========================

549:
550: IF l_rct_dist_count > 0 THEN
551: -- ========================= FND LOG ===========================
552: psa_utils.debug_other_string(g_state_level,l_full_path,' Distributions_exist_and_valid --> RETURN TRUE');
553: -- ========================= FND LOG ===========================
554: RETURN TRUE;
555: ELSE
556: -- ========================= FND LOG ===========================
557: psa_utils.debug_other_string(g_state_level,l_full_path,' Distributions_exist_and_valid --> RETURN FALSE');

Line 556: -- ========================= FND LOG ===========================

552: psa_utils.debug_other_string(g_state_level,l_full_path,' Distributions_exist_and_valid --> RETURN TRUE');
553: -- ========================= FND LOG ===========================
554: RETURN TRUE;
555: ELSE
556: -- ========================= FND LOG ===========================
557: psa_utils.debug_other_string(g_state_level,l_full_path,' Distributions_exist_and_valid --> RETURN FALSE');
558: -- ========================= FND LOG ===========================
559: RETURN FALSE;
560: END IF;

Line 558: -- ========================= FND LOG ===========================

554: RETURN TRUE;
555: ELSE
556: -- ========================= FND LOG ===========================
557: psa_utils.debug_other_string(g_state_level,l_full_path,' Distributions_exist_and_valid --> RETURN FALSE');
558: -- ========================= FND LOG ===========================
559: RETURN FALSE;
560: END IF;
561:
562: EXCEPTION

Line 564: -- ========================= FND LOG ===========================

560: END IF;
561:
562: EXCEPTION
563: WHEN OTHERS THEN
564: -- ========================= FND LOG ===========================
565: psa_utils.debug_other_string(g_excep_level,l_full_path,' Distributions_exist_and_valid -> EXCEPTION WHEN OTHERS ' || SQLERRM );
566: psa_utils.debug_unexpected_msg(l_full_path);
567: -- ========================= FND LOG ===========================
568: RETURN FALSE;

Line 567: -- ========================= FND LOG ===========================

563: WHEN OTHERS THEN
564: -- ========================= FND LOG ===========================
565: psa_utils.debug_other_string(g_excep_level,l_full_path,' Distributions_exist_and_valid -> EXCEPTION WHEN OTHERS ' || SQLERRM );
566: psa_utils.debug_unexpected_msg(l_full_path);
567: -- ========================= FND LOG ===========================
568: RETURN FALSE;
569:
570: END distributions_exist_and_valid;
571:

Line 584: -- ========================= FND LOG ===========================

580: p_amount IN NUMBER,
581: p_crh_status IN VARCHAR2) RETURN BOOLEAN
582: IS
583: l_rct_dist_count NUMBER;
584: -- ========================= FND LOG ===========================
585: l_full_path VARCHAR2(100) := g_path || 'cash_clr_dist_exist_valid';
586: -- ========================= FND LOG ===========================
587: BEGIN
588:

Line 586: -- ========================= FND LOG ===========================

582: IS
583: l_rct_dist_count NUMBER;
584: -- ========================= FND LOG ===========================
585: l_full_path VARCHAR2(100) := g_path || 'cash_clr_dist_exist_valid';
586: -- ========================= FND LOG ===========================
587: BEGIN
588:
589: -- ========================= FND LOG ===========================
590: psa_utils.debug_other_string(g_state_level,l_full_path,' Cash_clr_dist_exist_valid -> START');

Line 589: -- ========================= FND LOG ===========================

585: l_full_path VARCHAR2(100) := g_path || 'cash_clr_dist_exist_valid';
586: -- ========================= FND LOG ===========================
587: BEGIN
588:
589: -- ========================= FND LOG ===========================
590: psa_utils.debug_other_string(g_state_level,l_full_path,' Cash_clr_dist_exist_valid -> START');
591: -- ========================= FND LOG ===========================
592:
593: SELECT count(rct.receivable_application_id)

Line 591: -- ========================= FND LOG ===========================

587: BEGIN
588:
589: -- ========================= FND LOG ===========================
590: psa_utils.debug_other_string(g_state_level,l_full_path,' Cash_clr_dist_exist_valid -> START');
591: -- ========================= FND LOG ===========================
592:
593: SELECT count(rct.receivable_application_id)
594: INTO l_rct_dist_count
595: FROM psa_mf_rct_dist_all rct

Line 598: -- ========================= FND LOG ===========================

594: INTO l_rct_dist_count
595: FROM psa_mf_rct_dist_all rct
596: WHERE rct.receivable_application_id = p_receivable_app_id;
597:
598: -- ========================= FND LOG ===========================
599: psa_utils.debug_other_string(g_state_level,l_full_path,' p_amount -> ' || p_amount );
600: psa_utils.debug_other_string(g_state_level,l_full_path,' p_crh_status -> ' || p_crh_status );
601: psa_utils.debug_other_string(g_state_level,l_full_path,' l_rct_dist_count -> ' || l_rct_dist_count);
602: -- ========================= FND LOG ===========================

Line 602: -- ========================= FND LOG ===========================

598: -- ========================= FND LOG ===========================
599: psa_utils.debug_other_string(g_state_level,l_full_path,' p_amount -> ' || p_amount );
600: psa_utils.debug_other_string(g_state_level,l_full_path,' p_crh_status -> ' || p_crh_status );
601: psa_utils.debug_other_string(g_state_level,l_full_path,' l_rct_dist_count -> ' || l_rct_dist_count);
602: -- ========================= FND LOG ===========================
603:
604: IF (p_amount < 0) AND (p_crh_status IN ('REMITTED','CLEARED')) THEN
605: -- ========================= FND LOG ===========================
606: psa_utils.debug_other_string(g_state_level,l_full_path,' Inside first if ');

Line 605: -- ========================= FND LOG ===========================

601: psa_utils.debug_other_string(g_state_level,l_full_path,' l_rct_dist_count -> ' || l_rct_dist_count);
602: -- ========================= FND LOG ===========================
603:
604: IF (p_amount < 0) AND (p_crh_status IN ('REMITTED','CLEARED')) THEN
605: -- ========================= FND LOG ===========================
606: psa_utils.debug_other_string(g_state_level,l_full_path,' Inside first if ');
607: -- ========================= FND LOG ===========================
608: IF (l_rct_dist_count > 0) THEN
609: -- ========================= FND LOG ===========================

Line 607: -- ========================= FND LOG ===========================

603:
604: IF (p_amount < 0) AND (p_crh_status IN ('REMITTED','CLEARED')) THEN
605: -- ========================= FND LOG ===========================
606: psa_utils.debug_other_string(g_state_level,l_full_path,' Inside first if ');
607: -- ========================= FND LOG ===========================
608: IF (l_rct_dist_count > 0) THEN
609: -- ========================= FND LOG ===========================
610: psa_utils.debug_other_string(g_state_level,l_full_path,' RETURN FALSE ');
611: -- ========================= FND LOG ===========================

Line 609: -- ========================= FND LOG ===========================

605: -- ========================= FND LOG ===========================
606: psa_utils.debug_other_string(g_state_level,l_full_path,' Inside first if ');
607: -- ========================= FND LOG ===========================
608: IF (l_rct_dist_count > 0) THEN
609: -- ========================= FND LOG ===========================
610: psa_utils.debug_other_string(g_state_level,l_full_path,' RETURN FALSE ');
611: -- ========================= FND LOG ===========================
612: RETURN FALSE;
613: ELSE

Line 611: -- ========================= FND LOG ===========================

607: -- ========================= FND LOG ===========================
608: IF (l_rct_dist_count > 0) THEN
609: -- ========================= FND LOG ===========================
610: psa_utils.debug_other_string(g_state_level,l_full_path,' RETURN FALSE ');
611: -- ========================= FND LOG ===========================
612: RETURN FALSE;
613: ELSE
614: -- ========================= FND LOG ===========================
615: psa_utils.debug_other_string(g_state_level,l_full_path,' RETURN TRUE ');

Line 614: -- ========================= FND LOG ===========================

610: psa_utils.debug_other_string(g_state_level,l_full_path,' RETURN FALSE ');
611: -- ========================= FND LOG ===========================
612: RETURN FALSE;
613: ELSE
614: -- ========================= FND LOG ===========================
615: psa_utils.debug_other_string(g_state_level,l_full_path,' RETURN TRUE ');
616: -- ========================= FND LOG ===========================
617: RETURN TRUE;
618: END IF;

Line 616: -- ========================= FND LOG ===========================

612: RETURN FALSE;
613: ELSE
614: -- ========================= FND LOG ===========================
615: psa_utils.debug_other_string(g_state_level,l_full_path,' RETURN TRUE ');
616: -- ========================= FND LOG ===========================
617: RETURN TRUE;
618: END IF;
619: END IF;
620:

Line 622: -- ========================= FND LOG ===========================

618: END IF;
619: END IF;
620:
621: IF (p_amount > 0) AND (p_crh_status = 'REVERSED') THEN
622: -- ========================= FND LOG ===========================
623: psa_utils.debug_other_string(g_state_level,l_full_path,' Inside second if ');
624: -- ========================= FND LOG ===========================
625: IF (l_rct_dist_count > 0) THEN
626: -- ========================= FND LOG ===========================

Line 624: -- ========================= FND LOG ===========================

620:
621: IF (p_amount > 0) AND (p_crh_status = 'REVERSED') THEN
622: -- ========================= FND LOG ===========================
623: psa_utils.debug_other_string(g_state_level,l_full_path,' Inside second if ');
624: -- ========================= FND LOG ===========================
625: IF (l_rct_dist_count > 0) THEN
626: -- ========================= FND LOG ===========================
627: psa_utils.debug_other_string(g_state_level,l_full_path,' RETURN FALSE ');
628: -- ========================= FND LOG ===========================

Line 626: -- ========================= FND LOG ===========================

622: -- ========================= FND LOG ===========================
623: psa_utils.debug_other_string(g_state_level,l_full_path,' Inside second if ');
624: -- ========================= FND LOG ===========================
625: IF (l_rct_dist_count > 0) THEN
626: -- ========================= FND LOG ===========================
627: psa_utils.debug_other_string(g_state_level,l_full_path,' RETURN FALSE ');
628: -- ========================= FND LOG ===========================
629: RETURN FALSE;
630: ELSE

Line 628: -- ========================= FND LOG ===========================

624: -- ========================= FND LOG ===========================
625: IF (l_rct_dist_count > 0) THEN
626: -- ========================= FND LOG ===========================
627: psa_utils.debug_other_string(g_state_level,l_full_path,' RETURN FALSE ');
628: -- ========================= FND LOG ===========================
629: RETURN FALSE;
630: ELSE
631: -- ========================= FND LOG ===========================
632: psa_utils.debug_other_string(g_state_level,l_full_path,' RETURN TRUE ');

Line 631: -- ========================= FND LOG ===========================

627: psa_utils.debug_other_string(g_state_level,l_full_path,' RETURN FALSE ');
628: -- ========================= FND LOG ===========================
629: RETURN FALSE;
630: ELSE
631: -- ========================= FND LOG ===========================
632: psa_utils.debug_other_string(g_state_level,l_full_path,' RETURN TRUE ');
633: -- ========================= FND LOG ===========================
634: RETURN TRUE;
635: END IF;

Line 633: -- ========================= FND LOG ===========================

629: RETURN FALSE;
630: ELSE
631: -- ========================= FND LOG ===========================
632: psa_utils.debug_other_string(g_state_level,l_full_path,' RETURN TRUE ');
633: -- ========================= FND LOG ===========================
634: RETURN TRUE;
635: END IF;
636: END IF;
637:

Line 639: -- ========================= FND LOG ===========================

635: END IF;
636: END IF;
637:
638: IF l_rct_dist_count > 0 THEN
639: -- ========================= FND LOG ===========================
640: psa_utils.debug_other_string(g_state_level,l_full_path,' Inside third if ');
641: psa_utils.debug_other_string(g_state_level,l_full_path,' RETURN FALSE');
642: -- ========================= FND LOG ===========================
643: RETURN FALSE;

Line 642: -- ========================= FND LOG ===========================

638: IF l_rct_dist_count > 0 THEN
639: -- ========================= FND LOG ===========================
640: psa_utils.debug_other_string(g_state_level,l_full_path,' Inside third if ');
641: psa_utils.debug_other_string(g_state_level,l_full_path,' RETURN FALSE');
642: -- ========================= FND LOG ===========================
643: RETURN FALSE;
644: ELSE
645: -- ========================= FND LOG ===========================
646: psa_utils.debug_other_string(g_state_level,l_full_path,' Inside third else ');

Line 645: -- ========================= FND LOG ===========================

641: psa_utils.debug_other_string(g_state_level,l_full_path,' RETURN FALSE');
642: -- ========================= FND LOG ===========================
643: RETURN FALSE;
644: ELSE
645: -- ========================= FND LOG ===========================
646: psa_utils.debug_other_string(g_state_level,l_full_path,' Inside third else ');
647: psa_utils.debug_other_string(g_state_level,l_full_path,' RETURN TRUE');
648: -- ========================= FND LOG ===========================
649: RETURN TRUE;

Line 648: -- ========================= FND LOG ===========================

644: ELSE
645: -- ========================= FND LOG ===========================
646: psa_utils.debug_other_string(g_state_level,l_full_path,' Inside third else ');
647: psa_utils.debug_other_string(g_state_level,l_full_path,' RETURN TRUE');
648: -- ========================= FND LOG ===========================
649: RETURN TRUE;
650: END IF;
651:
652: EXCEPTION

Line 654: -- ========================= FND LOG ===========================

650: END IF;
651:
652: EXCEPTION
653: WHEN OTHERS THEN
654: -- ========================= FND LOG ===========================
655: psa_utils.debug_other_string(g_state_level,l_full_path,' Cash_clr_dist_exist_valid -> EXCEPTION WHEN OTHERS ' || SQLERRM);
656: psa_utils.debug_unexpected_msg(l_full_path);
657: -- ========================= FND LOG ===========================
658: RETURN FALSE;

Line 657: -- ========================= FND LOG ===========================

653: WHEN OTHERS THEN
654: -- ========================= FND LOG ===========================
655: psa_utils.debug_other_string(g_state_level,l_full_path,' Cash_clr_dist_exist_valid -> EXCEPTION WHEN OTHERS ' || SQLERRM);
656: psa_utils.debug_unexpected_msg(l_full_path);
657: -- ========================= FND LOG ===========================
658: RETURN FALSE;
659:
660: END cash_clr_dist_exist_valid;
661:

Line 786: -- ========================= FND LOG ===========================

782:
783: FLEX_BUILD_ERROR EXCEPTION;
784: INVALID_DISTRIBUTION EXCEPTION;
785:
786: -- ========================= FND LOG ===========================
787: l_full_path VARCHAR2(100) := g_path || 'generate_rct_dist';
788: -- ========================= FND LOG ===========================
789:
790: BEGIN

Line 788: -- ========================= FND LOG ===========================

784: INVALID_DISTRIBUTION EXCEPTION;
785:
786: -- ========================= FND LOG ===========================
787: l_full_path VARCHAR2(100) := g_path || 'generate_rct_dist';
788: -- ========================= FND LOG ===========================
789:
790: BEGIN
791:
792: -- ========================= FND LOG ===========================

Line 792: -- ========================= FND LOG ===========================

788: -- ========================= FND LOG ===========================
789:
790: BEGIN
791:
792: -- ========================= FND LOG ===========================
793: psa_utils.debug_other_string(g_state_level,l_full_path,' Start Generate_rct_dist ');
794: psa_utils.debug_other_string(g_state_level,l_full_path,' PARAMETERS');
795: psa_utils.debug_other_string(g_state_level,l_full_path,' ==========');
796: psa_utils.debug_other_string(g_state_level,l_full_path,' p_rcv_app_id -> ' || p_rcv_app_id);

Line 808: -- ========================= FND LOG ===========================

804: psa_utils.debug_other_string(g_state_level,l_full_path,' p_unearned_discount_ccid -> ' || p_unearned_discount_ccid);
805: psa_utils.debug_other_string(g_state_level,l_full_path,' p_document_type -> ' || p_document_type);
806: psa_utils.debug_other_string(g_state_level,l_full_path,' p_crh_status -> ' || p_crh_status);
807: psa_utils.debug_other_string(g_state_level,l_full_path,' Starting the process ');
808: -- ========================= FND LOG ===========================
809:
810: -- Bug 2609367
811: -- call psa_mfar_transactions.create_distributions
812: -- When 'Create Distributions is run as a Conc. program OR invoked from the Action of opening MFAR Form,

Line 822: -- ========================= FND LOG ===========================

818: select psa_mF_error_log_s.currval
819: into run_num
820: from sys.dual;
821:
822: -- ========================= FND LOG ===========================
823: psa_utils.debug_other_string(g_state_level,l_full_path,' Creating distribution for Cust trx id ==> ' || run_num || ' -- ' || p_cust_trx_id);
824: -- ========================= FND LOG ===========================
825:
826: IF NOT (PSA_MFAR_TRANSACTIONS.create_distributions (

Line 824: -- ========================= FND LOG ===========================

820: from sys.dual;
821:
822: -- ========================= FND LOG ===========================
823: psa_utils.debug_other_string(g_state_level,l_full_path,' Creating distribution for Cust trx id ==> ' || run_num || ' -- ' || p_cust_trx_id);
824: -- ========================= FND LOG ===========================
825:
826: IF NOT (PSA_MFAR_TRANSACTIONS.create_distributions (
827: errbuf => l_errbuf,
828: retcode => l_retcode,

Line 834: -- ========================= FND LOG ===========================

830: p_set_of_books_id => g_set_of_books_id,
831: p_run_id => run_num,
832: p_error_message => l_exception_message)) THEN
833:
834: -- ========================= FND LOG ===========================
835: psa_utils.debug_other_string(g_state_level,l_full_path,' PSA_MFAR_TRANSACTIONS.create_distributions --> FALSE');
836: -- ========================= FND LOG ===========================
837: IF l_exception_message IS NOT NULL OR l_retcode = 'F' THEN
838: -- ========================= FND LOG ===========================

Line 836: -- ========================= FND LOG ===========================

832: p_error_message => l_exception_message)) THEN
833:
834: -- ========================= FND LOG ===========================
835: psa_utils.debug_other_string(g_state_level,l_full_path,' PSA_MFAR_TRANSACTIONS.create_distributions --> FALSE');
836: -- ========================= FND LOG ===========================
837: IF l_exception_message IS NOT NULL OR l_retcode = 'F' THEN
838: -- ========================= FND LOG ===========================
839: psa_utils.debug_other_string(g_state_level,l_full_path,' Raising invalid_distribution');
840: -- ========================= FND LOG ===========================

Line 838: -- ========================= FND LOG ===========================

834: -- ========================= FND LOG ===========================
835: psa_utils.debug_other_string(g_state_level,l_full_path,' PSA_MFAR_TRANSACTIONS.create_distributions --> FALSE');
836: -- ========================= FND LOG ===========================
837: IF l_exception_message IS NOT NULL OR l_retcode = 'F' THEN
838: -- ========================= FND LOG ===========================
839: psa_utils.debug_other_string(g_state_level,l_full_path,' Raising invalid_distribution');
840: -- ========================= FND LOG ===========================
841: Raise invalid_distribution;
842: END IF;

Line 840: -- ========================= FND LOG ===========================

836: -- ========================= FND LOG ===========================
837: IF l_exception_message IS NOT NULL OR l_retcode = 'F' THEN
838: -- ========================= FND LOG ===========================
839: psa_utils.debug_other_string(g_state_level,l_full_path,' Raising invalid_distribution');
840: -- ========================= FND LOG ===========================
841: Raise invalid_distribution;
842: END IF;
843: ELSE
844: -- ========================= FND LOG ===========================

Line 844: -- ========================= FND LOG ===========================

840: -- ========================= FND LOG ===========================
841: Raise invalid_distribution;
842: END IF;
843: ELSE
844: -- ========================= FND LOG ===========================
845: psa_utils.debug_other_string(g_state_level,l_full_path,' cust_trx_id --> ' || p_cust_trx_id);
846: -- ========================= FND LOG ===========================
847: END IF;
848:

Line 846: -- ========================= FND LOG ===========================

842: END IF;
843: ELSE
844: -- ========================= FND LOG ===========================
845: psa_utils.debug_other_string(g_state_level,l_full_path,' cust_trx_id --> ' || p_cust_trx_id);
846: -- ========================= FND LOG ===========================
847: END IF;
848:
849: -- ========================= FND LOG ===========================
850: psa_utils.debug_other_string(g_state_level,l_full_path,' p_earned_discount --> ' || p_earned_discount );

Line 849: -- ========================= FND LOG ===========================

845: psa_utils.debug_other_string(g_state_level,l_full_path,' cust_trx_id --> ' || p_cust_trx_id);
846: -- ========================= FND LOG ===========================
847: END IF;
848:
849: -- ========================= FND LOG ===========================
850: psa_utils.debug_other_string(g_state_level,l_full_path,' p_earned_discount --> ' || p_earned_discount );
851: psa_utils.debug_other_string(g_state_level,l_full_path,' p_unearned_discount --> ' || p_unearned_discount );
852: -- ========================= FND LOG ===========================
853:

Line 852: -- ========================= FND LOG ===========================

848:
849: -- ========================= FND LOG ===========================
850: psa_utils.debug_other_string(g_state_level,l_full_path,' p_earned_discount --> ' || p_earned_discount );
851: psa_utils.debug_other_string(g_state_level,l_full_path,' p_unearned_discount --> ' || p_unearned_discount );
852: -- ========================= FND LOG ===========================
853:
854: IF (p_earned_discount <> 0 OR p_unearned_discount <> 0) THEN
855: -- ========================= FND LOG ===========================
856: psa_utils.debug_other_string(g_state_level,l_full_path,' Calling populate_discount_cache --> ' || p_cust_trx_id);

Line 855: -- ========================= FND LOG ===========================

851: psa_utils.debug_other_string(g_state_level,l_full_path,' p_unearned_discount --> ' || p_unearned_discount );
852: -- ========================= FND LOG ===========================
853:
854: IF (p_earned_discount <> 0 OR p_unearned_discount <> 0) THEN
855: -- ========================= FND LOG ===========================
856: psa_utils.debug_other_string(g_state_level,l_full_path,' Calling populate_discount_cache --> ' || p_cust_trx_id);
857: -- ========================= FND LOG ===========================
858: POPULATE_DISCOUNT_LINES_CACHE (p_cust_trx_id);
859: END IF;

Line 857: -- ========================= FND LOG ===========================

853:
854: IF (p_earned_discount <> 0 OR p_unearned_discount <> 0) THEN
855: -- ========================= FND LOG ===========================
856: psa_utils.debug_other_string(g_state_level,l_full_path,' Calling populate_discount_cache --> ' || p_cust_trx_id);
857: -- ========================= FND LOG ===========================
858: POPULATE_DISCOUNT_LINES_CACHE (p_cust_trx_id);
859: END IF;
860:
861:

Line 880: -- ========================= FND LOG ===========================

876: WHEN NO_DATA_FOUND THEN
877: l_zero_amt_flag := 0;
878: END;
879:
880: -- ========================= FND LOG ===========================
881: psa_utils.debug_other_string(g_state_level,l_full_path,
882: ' l_zero_amt_flag --> ' || l_zero_amt_flag );
883:
884: -- ========================= FND LOG ===========================

Line 884: -- ========================= FND LOG ===========================

880: -- ========================= FND LOG ===========================
881: psa_utils.debug_other_string(g_state_level,l_full_path,
882: ' l_zero_amt_flag --> ' || l_zero_amt_flag );
883:
884: -- ========================= FND LOG ===========================
885:
886:
887:
888: SELECT

Line 906: -- ========================= FND LOG ===========================

902: AND trx_line.customer_trx_line_id = trx_dist.customer_trx_line_id
903: AND trx_dist.cust_trx_line_gl_dist_id = mf_balances.cust_trx_line_gl_dist_id
904: AND trx_line.customer_trx_line_id = nvl(p_cust_trx_line_id, trx_line.customer_trx_line_id);
905:
906: -- ========================= FND LOG ===========================
907: psa_utils.debug_other_string(g_state_level,l_full_path,' l_total_amount_due --> ' || l_total_amount_due );
908: psa_utils.debug_other_string(g_state_level,l_full_path,' sum_amt_due_rem --> ' || sum_amt_due_rem );
909: -- ========================= FND LOG ===========================
910:

Line 909: -- ========================= FND LOG ===========================

905:
906: -- ========================= FND LOG ===========================
907: psa_utils.debug_other_string(g_state_level,l_full_path,' l_total_amount_due --> ' || l_total_amount_due );
908: psa_utils.debug_other_string(g_state_level,l_full_path,' sum_amt_due_rem --> ' || sum_amt_due_rem );
909: -- ========================= FND LOG ===========================
910:
911:
912: --
913: -- Initailize variables for running total

Line 926: -- ========================= FND LOG ===========================

922: l_running_unearn_discount := 0;
923: l_running_total_amount_unearn := l_total_amount_due;
924:
925:
926: -- ========================= FND LOG ===========================
927: psa_utils.debug_other_string(g_state_level,l_full_path,' l_running_total_amount_due --> ' || l_running_total_amount_due );
928: psa_utils.debug_other_string(g_state_level,l_full_path,' l_running_total_amount_earn --> ' || l_running_total_amount_earn);
929: psa_utils.debug_other_string(g_state_level,l_full_path,' l_running_total_amount_unearn --> ' || l_running_total_amount_unearn);
930: -- ========================= FND LOG ===========================

Line 930: -- ========================= FND LOG ===========================

926: -- ========================= FND LOG ===========================
927: psa_utils.debug_other_string(g_state_level,l_full_path,' l_running_total_amount_due --> ' || l_running_total_amount_due );
928: psa_utils.debug_other_string(g_state_level,l_full_path,' l_running_total_amount_earn --> ' || l_running_total_amount_earn);
929: psa_utils.debug_other_string(g_state_level,l_full_path,' l_running_total_amount_unearn --> ' || l_running_total_amount_unearn);
930: -- ========================= FND LOG ===========================
931:
932: l_c_accrual_stmt :=
933: 'Select mf_trx_dist.mf_receivables_ccid rcv_ccid, ' ||
934: ' mf_trx_dist.cust_trx_line_gl_dist_id trx_line_dist_id, ' ||

Line 981: -- ========================= FND LOG ===========================

977: l_c_accrual_stmt := l_c_accrual_stmt || ' order by 5 asc ';
978: l_c_cash_stmt := l_c_cash_stmt || ' order by 5 asc ';
979: END IF;
980:
981: -- ========================= FND LOG ===========================
982: psa_utils.debug_other_string(g_state_level,l_full_path,' arp_global.sysparam.accounting_method --> '
983: || arp_global.sysparam.accounting_method);
984: -- ========================= FND LOG ===========================
985:

Line 984: -- ========================= FND LOG ===========================

980:
981: -- ========================= FND LOG ===========================
982: psa_utils.debug_other_string(g_state_level,l_full_path,' arp_global.sysparam.accounting_method --> '
983: || arp_global.sysparam.accounting_method);
984: -- ========================= FND LOG ===========================
985:
986: IF arp_global.sysparam.accounting_method = 'ACCRUAL' THEN
987: OPEN c_accrual_cur FOR l_c_accrual_stmt USING l_zero_amt_flag, p_cust_trx_id, p_cust_trx_id, p_cust_trx_line_id;
988: ELSIF arp_global.sysparam.accounting_method = 'CASH' THEN

Line 997: -- ========================= FND LOG ===========================

993: LOOP
994: FETCH c_accrual_cur INTO l_accrual_rec;
995: EXIT WHEN c_accrual_cur%NOTFOUND;
996:
997: -- ========================= FND LOG ===========================
998: psa_utils.debug_other_string(g_state_level,l_full_path,' l_accrual_rec.trx_line_dist_id --> ' || l_accrual_rec.trx_line_dist_id );
999: -- ========================= FND LOG ===========================
1000:
1001: --

Line 999: -- ========================= FND LOG ===========================

995: EXIT WHEN c_accrual_cur%NOTFOUND;
996:
997: -- ========================= FND LOG ===========================
998: psa_utils.debug_other_string(g_state_level,l_full_path,' l_accrual_rec.trx_line_dist_id --> ' || l_accrual_rec.trx_line_dist_id );
999: -- ========================= FND LOG ===========================
1000:
1001: --
1002: -- If Remittance MFAR distributions have already been created
1003: -- applicable only for Receipts cleared by CashMgt

Line 1011: -- ========================= FND LOG ===========================

1007:
1008: OPEN c_remit_reversal_account (l_accrual_rec.trx_line_dist_id);
1009: FETCH c_remit_reversal_account INTO l_remit_reversal_ccid;
1010: CLOSE c_remit_reversal_account;
1011: -- ========================= FND LOG ===========================
1012: psa_utils.debug_other_string(g_state_level,l_full_path,' l_remit_reversal_ccid --> ' || l_remit_reversal_ccid);
1013: -- ========================= FND LOG ===========================
1014: END IF;
1015:

Line 1013: -- ========================= FND LOG ===========================

1009: FETCH c_remit_reversal_account INTO l_remit_reversal_ccid;
1010: CLOSE c_remit_reversal_account;
1011: -- ========================= FND LOG ===========================
1012: psa_utils.debug_other_string(g_state_level,l_full_path,' l_remit_reversal_ccid --> ' || l_remit_reversal_ccid);
1013: -- ========================= FND LOG ===========================
1014: END IF;
1015:
1016: -- ========================= FND LOG ===========================
1017: psa_utils.debug_other_string(g_state_level,l_full_path,' p_document_type --> ' || p_document_type );

Line 1016: -- ========================= FND LOG ===========================

1012: psa_utils.debug_other_string(g_state_level,l_full_path,' l_remit_reversal_ccid --> ' || l_remit_reversal_ccid);
1013: -- ========================= FND LOG ===========================
1014: END IF;
1015:
1016: -- ========================= FND LOG ===========================
1017: psa_utils.debug_other_string(g_state_level,l_full_path,' p_document_type --> ' || p_document_type );
1018: -- ========================= FND LOG ===========================
1019:
1020: IF p_document_type = 'CM' THEN

Line 1018: -- ========================= FND LOG ===========================

1014: END IF;
1015:
1016: -- ========================= FND LOG ===========================
1017: psa_utils.debug_other_string(g_state_level,l_full_path,' p_document_type --> ' || p_document_type );
1018: -- ========================= FND LOG ===========================
1019:
1020: IF p_document_type = 'CM' THEN
1021: p_ccid := l_accrual_rec.rcv_ccid;
1022: -- ========================= FND LOG ===========================

Line 1022: -- ========================= FND LOG ===========================

1018: -- ========================= FND LOG ===========================
1019:
1020: IF p_document_type = 'CM' THEN
1021: p_ccid := l_accrual_rec.rcv_ccid;
1022: -- ========================= FND LOG ===========================
1023: psa_utils.debug_other_string(g_state_level,l_full_path,' if cond - document type is CM --> ' || p_ccid);
1024: -- ========================= FND LOG ===========================
1025: ELSE
1026: -- ========================= FND LOG ===========================

Line 1024: -- ========================= FND LOG ===========================

1020: IF p_document_type = 'CM' THEN
1021: p_ccid := l_accrual_rec.rcv_ccid;
1022: -- ========================= FND LOG ===========================
1023: psa_utils.debug_other_string(g_state_level,l_full_path,' if cond - document type is CM --> ' || p_ccid);
1024: -- ========================= FND LOG ===========================
1025: ELSE
1026: -- ========================= FND LOG ===========================
1027: psa_utils.debug_other_string(g_state_level,l_full_path,' else cond - calling PSA_MFAR_UTILS.OVERRIDE_SEGMENTS ');
1028: -- ========================= FND LOG ===========================

Line 1026: -- ========================= FND LOG ===========================

1022: -- ========================= FND LOG ===========================
1023: psa_utils.debug_other_string(g_state_level,l_full_path,' if cond - document type is CM --> ' || p_ccid);
1024: -- ========================= FND LOG ===========================
1025: ELSE
1026: -- ========================= FND LOG ===========================
1027: psa_utils.debug_other_string(g_state_level,l_full_path,' else cond - calling PSA_MFAR_UTILS.OVERRIDE_SEGMENTS ');
1028: -- ========================= FND LOG ===========================
1029:
1030: IF NOT ( PSA_MFAR_UTILS.OVERRIDE_SEGMENTS ( P_PRIMARY_CCID => p_cash_ccid,

Line 1028: -- ========================= FND LOG ===========================

1024: -- ========================= FND LOG ===========================
1025: ELSE
1026: -- ========================= FND LOG ===========================
1027: psa_utils.debug_other_string(g_state_level,l_full_path,' else cond - calling PSA_MFAR_UTILS.OVERRIDE_SEGMENTS ');
1028: -- ========================= FND LOG ===========================
1029:
1030: IF NOT ( PSA_MFAR_UTILS.OVERRIDE_SEGMENTS ( P_PRIMARY_CCID => p_cash_ccid,
1031: P_OVERRIDE_CCID => l_accrual_rec.rcv_ccid,
1032: P_SET_OF_BOOKS_ID => g_set_of_books_id,

Line 1036: -- ========================= FND LOG ===========================

1032: P_SET_OF_BOOKS_ID => g_set_of_books_id,
1033: P_TRX_TYPE => 'RCT',
1034: P_CCID => p_ccid)) -- OUT
1035: THEN
1036: -- ========================= FND LOG ===========================
1037: psa_utils.debug_other_string(g_state_level,l_full_path,' PSA_MFAR_UTILS.OVERRIDE_SEGMENTS -> FALSE ');
1038: -- ========================= FND LOG ===========================
1039: RAISE FLEX_BUILD_ERROR;
1040: ELSE

Line 1038: -- ========================= FND LOG ===========================

1034: P_CCID => p_ccid)) -- OUT
1035: THEN
1036: -- ========================= FND LOG ===========================
1037: psa_utils.debug_other_string(g_state_level,l_full_path,' PSA_MFAR_UTILS.OVERRIDE_SEGMENTS -> FALSE ');
1038: -- ========================= FND LOG ===========================
1039: RAISE FLEX_BUILD_ERROR;
1040: ELSE
1041: -- ========================= FND LOG ===========================
1042: psa_utils.debug_other_string(g_state_level,l_full_path,' p_ccid -> ' || p_ccid);

Line 1041: -- ========================= FND LOG ===========================

1037: psa_utils.debug_other_string(g_state_level,l_full_path,' PSA_MFAR_UTILS.OVERRIDE_SEGMENTS -> FALSE ');
1038: -- ========================= FND LOG ===========================
1039: RAISE FLEX_BUILD_ERROR;
1040: ELSE
1041: -- ========================= FND LOG ===========================
1042: psa_utils.debug_other_string(g_state_level,l_full_path,' p_ccid -> ' || p_ccid);
1043: -- ========================= FND LOG ===========================
1044: END IF;
1045: END IF;

Line 1043: -- ========================= FND LOG ===========================

1039: RAISE FLEX_BUILD_ERROR;
1040: ELSE
1041: -- ========================= FND LOG ===========================
1042: psa_utils.debug_other_string(g_state_level,l_full_path,' p_ccid -> ' || p_ccid);
1043: -- ========================= FND LOG ===========================
1044: END IF;
1045: END IF;
1046:
1047: --

Line 1052: -- ========================= FND LOG ===========================

1048: -- Prorate amount applied
1049: --
1050:
1051: IF p_cust_trx_line_id Is NOT NULL THEN
1052: -- ========================= FND LOG ===========================
1053: psa_utils.debug_other_string(g_state_level,l_full_path,' p_cust_trx_line_id Is NOT NULL');
1054: -- ========================= FND LOG ===========================
1055:
1056: IF (p_cust_trx_line_id = l_accrual_rec.trx_line_id)

Line 1054: -- ========================= FND LOG ===========================

1050:
1051: IF p_cust_trx_line_id Is NOT NULL THEN
1052: -- ========================= FND LOG ===========================
1053: psa_utils.debug_other_string(g_state_level,l_full_path,' p_cust_trx_line_id Is NOT NULL');
1054: -- ========================= FND LOG ===========================
1055:
1056: IF (p_cust_trx_line_id = l_accrual_rec.trx_line_id)
1057: AND NOT (l_running_total_amount_due = 0) THEN -- to avoid divide by zero error
1058:

Line 1071: -- ========================= FND LOG ===========================

1067:
1068: l_running_amount := l_running_amount + l_amount;
1069: l_running_total_amount_due := l_running_total_amount_due - l_accrual_rec.amount_due;
1070:
1071: -- ========================= FND LOG ===========================
1072: psa_utils.debug_other_string(g_state_level,l_full_path,' IF part ' ||
1073: ' ##l_amount_applied --> ' || l_amount_applied ||
1074: ' ##l_amount --> ' || l_amount ||
1075: ' ##l_percent --> ' || l_percent ||

Line 1078: -- ========================= FND LOG ===========================

1074: ' ##l_amount --> ' || l_amount ||
1075: ' ##l_percent --> ' || l_percent ||
1076: ' ##l_running_amount --> ' || l_running_amount ||
1077: ' ##l_running_total_amount_due --> ' || l_running_total_amount_due);
1078: -- ========================= FND LOG ===========================
1079:
1080: ELSE
1081:
1082: l_amount := 0;

Line 1084: -- ========================= FND LOG ===========================

1080: ELSE
1081:
1082: l_amount := 0;
1083: l_percent := 0;
1084: -- ========================= FND LOG ===========================
1085: psa_utils.debug_other_string(g_state_level,l_full_path,' ##l_amount --> ' || l_amount || ' ##l_percent --> ' || l_percent);
1086: -- ========================= FND LOG ===========================
1087: END IF;
1088: ELSE

Line 1086: -- ========================= FND LOG ===========================

1082: l_amount := 0;
1083: l_percent := 0;
1084: -- ========================= FND LOG ===========================
1085: psa_utils.debug_other_string(g_state_level,l_full_path,' ##l_amount --> ' || l_amount || ' ##l_percent --> ' || l_percent);
1086: -- ========================= FND LOG ===========================
1087: END IF;
1088: ELSE
1089: -- ========================= FND LOG ===========================
1090: psa_utils.debug_other_string(g_state_level,l_full_path,' p_cust_trx_line_id Is NULL');

Line 1089: -- ========================= FND LOG ===========================

1085: psa_utils.debug_other_string(g_state_level,l_full_path,' ##l_amount --> ' || l_amount || ' ##l_percent --> ' || l_percent);
1086: -- ========================= FND LOG ===========================
1087: END IF;
1088: ELSE
1089: -- ========================= FND LOG ===========================
1090: psa_utils.debug_other_string(g_state_level,l_full_path,' p_cust_trx_line_id Is NULL');
1091: -- ========================= FND LOG ===========================
1092:
1093: IF NOT (l_running_total_amount_due = 0) THEN -- to avoid divide by zero error

Line 1091: -- ========================= FND LOG ===========================

1087: END IF;
1088: ELSE
1089: -- ========================= FND LOG ===========================
1090: psa_utils.debug_other_string(g_state_level,l_full_path,' p_cust_trx_line_id Is NULL');
1091: -- ========================= FND LOG ===========================
1092:
1093: IF NOT (l_running_total_amount_due = 0) THEN -- to avoid divide by zero error
1094:
1095: l_amount_applied := p_amount_applied - l_running_amount;

Line 1107: -- ========================= FND LOG ===========================

1103:
1104: l_running_amount := l_running_amount + l_amount;
1105: l_running_total_amount_due := l_running_total_amount_due - l_accrual_rec.amount_due;
1106:
1107: -- ========================= FND LOG ===========================
1108: psa_utils.debug_other_string(g_state_level,l_full_path,' ELSE part ' ||
1109: ' ##l_amount_applied --> ' || l_amount_applied ||
1110: ' ##l_amount --> ' || l_amount ||
1111: ' ##l_percent --> ' || l_percent ||

Line 1114: -- ========================= FND LOG ===========================

1110: ' ##l_amount --> ' || l_amount ||
1111: ' ##l_percent --> ' || l_percent ||
1112: ' ##l_running_amount --> ' || l_running_amount ||
1113: ' ##l_running_total_amount_due --> ' || l_running_total_amount_due);
1114: -- ========================= FND LOG ===========================
1115: END IF;
1116: END IF;
1117:
1118: --

Line 1126: -- ========================= FND LOG ===========================

1122: IF (p_earned_discount <> 0 OR p_unearned_discount <> 0) THEN
1123:
1124: IF LINE_IN_DISCOUNT_CACHE (l_accrual_rec.trx_line_id) THEN
1125:
1126: -- ========================= FND LOG ===========================
1127: psa_utils.debug_other_string(g_state_level,l_full_path,' calling LINE_IN_DISCOUNT_CACHE --> ' || l_accrual_rec.trx_line_id);
1128: psa_utils.debug_other_string(g_state_level,l_full_path,' prorate earned discount ');
1129: -- ========================= FND LOG ===========================
1130:

Line 1129: -- ========================= FND LOG ===========================

1125:
1126: -- ========================= FND LOG ===========================
1127: psa_utils.debug_other_string(g_state_level,l_full_path,' calling LINE_IN_DISCOUNT_CACHE --> ' || l_accrual_rec.trx_line_id);
1128: psa_utils.debug_other_string(g_state_level,l_full_path,' prorate earned discount ');
1129: -- ========================= FND LOG ===========================
1130:
1131: --
1132: -- Prorate Earned Discount
1133: --

Line 1143: -- ========================= FND LOG ===========================

1139: l_earned_discount := ROUND((l_earn_discount_applied*l_accrual_rec.amount_due/l_running_total_amount_earn),g_precision);
1140: l_running_earned_discount := l_running_earned_discount + l_earned_discount;
1141: l_running_total_amount_earn := l_running_total_amount_earn - l_accrual_rec.amount_due;
1142:
1143: -- ========================= FND LOG ===========================
1144: psa_utils.debug_other_string(g_state_level,l_full_path,' IF part ' ||
1145: ' ##l_earn_discount_applied --> ' || l_earn_discount_applied ||
1146: ' ##l_earned_discount --> ' || l_earned_discount ||
1147: ' ##l_running_earned_discount --> ' || l_running_earned_discount ||

Line 1149: -- ========================= FND LOG ===========================

1145: ' ##l_earn_discount_applied --> ' || l_earn_discount_applied ||
1146: ' ##l_earned_discount --> ' || l_earned_discount ||
1147: ' ##l_running_earned_discount --> ' || l_running_earned_discount ||
1148: ' ##l_running_total_amount_earn --> ' || l_running_total_amount_earn);
1149: -- ========================= FND LOG ===========================
1150:
1151: ELSE
1152: l_earned_discount := 0;
1153: -- ========================= FND LOG ===========================

Line 1153: -- ========================= FND LOG ===========================

1149: -- ========================= FND LOG ===========================
1150:
1151: ELSE
1152: l_earned_discount := 0;
1153: -- ========================= FND LOG ===========================
1154: psa_utils.debug_other_string(g_state_level,l_full_path,
1155: ' ELSE part ##l_earned_discount --> ' || l_earned_discount);
1156: -- ========================= FND LOG ===========================
1157: END IF;

Line 1156: -- ========================= FND LOG ===========================

1152: l_earned_discount := 0;
1153: -- ========================= FND LOG ===========================
1154: psa_utils.debug_other_string(g_state_level,l_full_path,
1155: ' ELSE part ##l_earned_discount --> ' || l_earned_discount);
1156: -- ========================= FND LOG ===========================
1157: END IF;
1158:
1159: --
1160: -- Prorate Unearned Discount

Line 1163: -- ========================= FND LOG ===========================

1159: --
1160: -- Prorate Unearned Discount
1161: --
1162:
1163: -- ========================= FND LOG ===========================
1164: psa_utils.debug_other_string(g_state_level,l_full_path,' prorate unearned discount ');
1165: -- ========================= FND LOG ===========================
1166:
1167: IF p_unearned_discount <> 0

Line 1165: -- ========================= FND LOG ===========================

1161: --
1162:
1163: -- ========================= FND LOG ===========================
1164: psa_utils.debug_other_string(g_state_level,l_full_path,' prorate unearned discount ');
1165: -- ========================= FND LOG ===========================
1166:
1167: IF p_unearned_discount <> 0
1168: AND NOT (l_running_total_amount_unearn = 0) THEN -- to avoid divide by zero error
1169:

Line 1175: -- ========================= FND LOG ===========================

1171: l_unearned_discount := ROUND((l_unearn_discount_applied*l_accrual_rec.amount_due/l_running_total_amount_unearn),g_precision);
1172: l_running_unearn_discount := l_running_unearn_discount + l_unearned_discount;
1173: l_running_total_amount_unearn := l_running_total_amount_unearn - l_accrual_rec.amount_due;
1174:
1175: -- ========================= FND LOG ===========================
1176: psa_utils.debug_other_string(g_state_level,l_full_path,' IF part ' ||
1177: ' ##l_earn_discount_applied --> ' || l_earn_discount_applied ||
1178: ' ##l_earned_discount --> ' || l_earned_discount ||
1179: ' ##l_running_earned_discount --> ' || l_running_earned_discount ||

Line 1181: -- ========================= FND LOG ===========================

1177: ' ##l_earn_discount_applied --> ' || l_earn_discount_applied ||
1178: ' ##l_earned_discount --> ' || l_earned_discount ||
1179: ' ##l_running_earned_discount --> ' || l_running_earned_discount ||
1180: ' ##l_running_total_amount_earn --> ' || l_running_total_amount_earn);
1181: -- ========================= FND LOG ===========================
1182: ELSE
1183: l_unearned_discount := 0;
1184: -- ========================= FND LOG ===========================
1185: psa_utils.debug_other_string(g_state_level,l_full_path,' ELSE part ##l_unearned_discount --> ' || l_unearned_discount);

Line 1184: -- ========================= FND LOG ===========================

1180: ' ##l_running_total_amount_earn --> ' || l_running_total_amount_earn);
1181: -- ========================= FND LOG ===========================
1182: ELSE
1183: l_unearned_discount := 0;
1184: -- ========================= FND LOG ===========================
1185: psa_utils.debug_other_string(g_state_level,l_full_path,' ELSE part ##l_unearned_discount --> ' || l_unearned_discount);
1186: -- ========================= FND LOG ===========================
1187:
1188: END IF;

Line 1186: -- ========================= FND LOG ===========================

1182: ELSE
1183: l_unearned_discount := 0;
1184: -- ========================= FND LOG ===========================
1185: psa_utils.debug_other_string(g_state_level,l_full_path,' ELSE part ##l_unearned_discount --> ' || l_unearned_discount);
1186: -- ========================= FND LOG ===========================
1187:
1188: END IF;
1189:
1190: IF p_earned_discount_ccid IS NOT NULL THEN

Line 1191: -- ========================= FND LOG ===========================

1187:
1188: END IF;
1189:
1190: IF p_earned_discount_ccid IS NOT NULL THEN
1191: -- ========================= FND LOG ===========================
1192: psa_utils.debug_other_string(g_state_level,l_full_path,
1193: ' calling PSA_MFAR_UTILS.OVERRIDE_SEGMENTS for earned discount');
1194: psa_utils.debug_other_string(g_state_level,l_full_path,' p_earned_discount_ccid IS NOT NULL ');
1195: psa_utils.debug_other_string(g_state_level,l_full_path,

Line 1200: -- ========================= FND LOG ===========================

1196: ' ##p_unearned_discount_ccid --> ' || p_unearned_discount_ccid ||
1197: ' ##rcv_ccid --> ' || l_accrual_rec.rcv_ccid ||
1198: ' ##g_set_of_books_id --> ' || g_set_of_books_id ||
1199: ' ##p_mf_earned_discount_ccid --> ' || p_mf_earned_discount_ccid);
1200: -- ========================= FND LOG ===========================
1201:
1202: IF NOT ( PSA_MFAR_UTILS.OVERRIDE_SEGMENTS (p_earned_discount_ccid,
1203: l_accrual_rec.rcv_ccid,
1204: g_set_of_books_id,'RCT',

Line 1207: -- ========================= FND LOG ===========================

1203: l_accrual_rec.rcv_ccid,
1204: g_set_of_books_id,'RCT',
1205: p_mf_earned_discount_ccid) ) THEN
1206:
1207: -- ========================= FND LOG ===========================
1208: psa_utils.debug_other_string(g_state_level,l_full_path,' PSA_MFAR_UTILS.OVERRIDE_SEGMENTS -> FALSE');
1209: -- ========================= FND LOG ===========================
1210: RAISE FLEX_BUILD_ERROR;
1211: END IF;

Line 1209: -- ========================= FND LOG ===========================

1205: p_mf_earned_discount_ccid) ) THEN
1206:
1207: -- ========================= FND LOG ===========================
1208: psa_utils.debug_other_string(g_state_level,l_full_path,' PSA_MFAR_UTILS.OVERRIDE_SEGMENTS -> FALSE');
1209: -- ========================= FND LOG ===========================
1210: RAISE FLEX_BUILD_ERROR;
1211: END IF;
1212: ELSE
1213: -- ========================= FND LOG ===========================

Line 1213: -- ========================= FND LOG ===========================

1209: -- ========================= FND LOG ===========================
1210: RAISE FLEX_BUILD_ERROR;
1211: END IF;
1212: ELSE
1213: -- ========================= FND LOG ===========================
1214: psa_utils.debug_other_string(g_state_level,l_full_path,' p_earned_discount_ccid IS NULL ');
1215: -- ========================= FND LOG ===========================
1216: END IF;
1217:

Line 1215: -- ========================= FND LOG ===========================

1211: END IF;
1212: ELSE
1213: -- ========================= FND LOG ===========================
1214: psa_utils.debug_other_string(g_state_level,l_full_path,' p_earned_discount_ccid IS NULL ');
1215: -- ========================= FND LOG ===========================
1216: END IF;
1217:
1218: IF p_unearned_discount_ccid IS NOT NULL THEN
1219: -- ========================= FND LOG ===========================

Line 1219: -- ========================= FND LOG ===========================

1215: -- ========================= FND LOG ===========================
1216: END IF;
1217:
1218: IF p_unearned_discount_ccid IS NOT NULL THEN
1219: -- ========================= FND LOG ===========================
1220: psa_utils.debug_other_string(g_state_level,l_full_path,
1221: ' calling PSA_MFAR_UTILS.OVERRIDE_SEGMENTS for unearned discount');
1222: psa_utils.debug_other_string(g_state_level,l_full_path,
1223: ' p_earned_discount_ccid IS NOT NULL ');

Line 1229: -- ========================= FND LOG ===========================

1225: ' ##p_unearned_discount_ccid --> ' || p_unearned_discount_ccid ||
1226: ' ##rcv_ccid --> ' || l_accrual_rec.rcv_ccid ||
1227: ' ##g_set_of_books_id --> ' || g_set_of_books_id ||
1228: ' ##p_mf_unearned_discount_ccid --> ' || p_mf_unearned_discount_ccid);
1229: -- ========================= FND LOG ===========================
1230:
1231: IF NOT ( PSA_MFAR_UTILS.OVERRIDE_SEGMENTS ( P_PRIMARY_CCID => p_unearned_discount_ccid,
1232: P_OVERRIDE_CCID => l_accrual_rec.rcv_ccid,
1233: P_SET_OF_BOOKS_ID => g_set_of_books_id,

Line 1237: -- ========================= FND LOG ===========================

1233: P_SET_OF_BOOKS_ID => g_set_of_books_id,
1234: P_TRX_TYPE => 'RCT',
1235: P_CCID => p_mf_unearned_discount_ccid)) -- OUT
1236: THEN
1237: -- ========================= FND LOG ===========================
1238: psa_utils.debug_other_string(g_state_level,l_full_path,' PSA_MFAR_UTILS.OVERRIDE_SEGMENTS -> FALSE ');
1239: psa_utils.debug_other_string(g_state_level,l_full_path,' Raising flex_build_error ');
1240: -- ========================= FND LOG ===========================
1241: RAISE FLEX_BUILD_ERROR;

Line 1240: -- ========================= FND LOG ===========================

1236: THEN
1237: -- ========================= FND LOG ===========================
1238: psa_utils.debug_other_string(g_state_level,l_full_path,' PSA_MFAR_UTILS.OVERRIDE_SEGMENTS -> FALSE ');
1239: psa_utils.debug_other_string(g_state_level,l_full_path,' Raising flex_build_error ');
1240: -- ========================= FND LOG ===========================
1241: RAISE FLEX_BUILD_ERROR;
1242: ELSE
1243: -- ========================= FND LOG ===========================
1244: psa_utils.debug_other_string(g_state_level,l_full_path,

Line 1243: -- ========================= FND LOG ===========================

1239: psa_utils.debug_other_string(g_state_level,l_full_path,' Raising flex_build_error ');
1240: -- ========================= FND LOG ===========================
1241: RAISE FLEX_BUILD_ERROR;
1242: ELSE
1243: -- ========================= FND LOG ===========================
1244: psa_utils.debug_other_string(g_state_level,l_full_path,
1245: ' p_mf_unearned_discount_ccid -> ' || p_mf_unearned_discount_ccid);
1246: -- ========================= FND LOG ===========================
1247: END IF;

Line 1246: -- ========================= FND LOG ===========================

1242: ELSE
1243: -- ========================= FND LOG ===========================
1244: psa_utils.debug_other_string(g_state_level,l_full_path,
1245: ' p_mf_unearned_discount_ccid -> ' || p_mf_unearned_discount_ccid);
1246: -- ========================= FND LOG ===========================
1247: END IF;
1248: END IF;
1249: END IF;
1250: END IF;

Line 1252: -- ========================= FND LOG ===========================

1248: END IF;
1249: END IF;
1250: END IF;
1251:
1252: -- ========================= FND LOG ===========================
1253: psa_utils.debug_other_string(g_state_level,l_full_path,' calling PSA_MFAR_RECEIPTS_COVER_PKG.INSERT_ROW');
1254: -- ========================= FND LOG ===========================
1255:
1256: --

Line 1254: -- ========================= FND LOG ===========================

1250: END IF;
1251:
1252: -- ========================= FND LOG ===========================
1253: psa_utils.debug_other_string(g_state_level,l_full_path,' calling PSA_MFAR_RECEIPTS_COVER_PKG.INSERT_ROW');
1254: -- ========================= FND LOG ===========================
1255:
1256: --
1257: -- Insert into psa_mf_rct_dist_all
1258: --

Line 1302: -- ========================= FND LOG ===========================

1298:
1299: END LOOP;
1300: CLOSE c_accrual_cur;
1301:
1302: -- ========================= FND LOG ===========================
1303: psa_utils.debug_other_string(g_state_level,l_full_path,' retcode --> ' || retcode );
1304: psa_utils.debug_other_string(g_state_level,l_full_path,' RETURN TRUE ');
1305: -- ========================= FND LOG ===========================
1306:

Line 1305: -- ========================= FND LOG ===========================

1301:
1302: -- ========================= FND LOG ===========================
1303: psa_utils.debug_other_string(g_state_level,l_full_path,' retcode --> ' || retcode );
1304: psa_utils.debug_other_string(g_state_level,l_full_path,' RETURN TRUE ');
1305: -- ========================= FND LOG ===========================
1306:
1307: retcode := 'S';
1308: RETURN TRUE;
1309:

Line 1314: -- ========================= FND LOG ===========================

1310:
1311: EXCEPTION
1312: -- Bug 3672756
1313: WHEN INVALID_DISTRIBUTION THEN
1314: -- ========================= FND LOG ===========================
1315: psa_utils.debug_other_string(g_excep_level,l_full_path,
1316: ' --> EXCEPTION - INVALID_DISTRIBUTION raised during PSA_MFAR_RECEIPTS.generate_rct_dist ');
1317: psa_utils.debug_other_string(g_excep_level,l_full_path,
1318: ' --> p_error_message --> ' || l_exception_message);

Line 1319: -- ========================= FND LOG ===========================

1315: psa_utils.debug_other_string(g_excep_level,l_full_path,
1316: ' --> EXCEPTION - INVALID_DISTRIBUTION raised during PSA_MFAR_RECEIPTS.generate_rct_dist ');
1317: psa_utils.debug_other_string(g_excep_level,l_full_path,
1318: ' --> p_error_message --> ' || l_exception_message);
1319: -- ========================= FND LOG ===========================
1320: p_error_message := l_exception_message;
1321: retcode := 'F';
1322: RETURN FALSE;
1323:

Line 1326: -- ========================= FND LOG ===========================

1322: RETURN FALSE;
1323:
1324: WHEN FLEX_BUILD_ERROR THEN
1325: l_exception_message := fnd_message.get;
1326: -- ========================= FND LOG ===========================
1327: psa_utils.debug_other_string(g_excep_level,l_full_path,
1328: ' --> EXCEPTION - FLEX_BUILD_ERROR raised during PSA_MFAR_RECEIPTS.generate_rct_dist ');
1329: psa_utils.debug_other_string(g_excep_level,l_full_path,
1330: ' --> p_error_message --> ' || l_exception_message);

Line 1331: -- ========================= FND LOG ===========================

1327: psa_utils.debug_other_string(g_excep_level,l_full_path,
1328: ' --> EXCEPTION - FLEX_BUILD_ERROR raised during PSA_MFAR_RECEIPTS.generate_rct_dist ');
1329: psa_utils.debug_other_string(g_excep_level,l_full_path,
1330: ' --> p_error_message --> ' || l_exception_message);
1331: -- ========================= FND LOG ===========================
1332: p_error_message := l_exception_message;
1333: retcode := 'F';
1334: RETURN FALSE;
1335:

Line 1338: -- ========================= FND LOG ===========================

1334: RETURN FALSE;
1335:
1336: WHEN OTHERS THEN
1337: l_exception_message := l_exception_message || SQLCODE || ' - ' || SQLERRM;
1338: -- ========================= FND LOG ===========================
1339: psa_utils.debug_other_string(g_excep_level,l_full_path,
1340: ' --> EXCEPTION - OTHERS raised during PSA_MFAR_RECEIPTS.generate_rct_dist ');
1341: psa_utils.debug_other_string(g_excep_level,l_full_path,
1342: ' --> p_error_message --> ' || l_exception_message);

Line 1344: -- ========================= FND LOG ===========================

1340: ' --> EXCEPTION - OTHERS raised during PSA_MFAR_RECEIPTS.generate_rct_dist ');
1341: psa_utils.debug_other_string(g_excep_level,l_full_path,
1342: ' --> p_error_message --> ' || l_exception_message);
1343: psa_utils.debug_unexpected_msg(l_full_path);
1344: -- ========================= FND LOG ===========================
1345: p_error_message := l_exception_message;
1346: retcode := 'F';
1347: RETURN FALSE;
1348:

Line 1440: -- ========================= FND LOG ===========================

1436:
1437: FLEX_BUILD_ERROR EXCEPTION;
1438: INVALID_DISTRIBUTION EXCEPTION;
1439:
1440: -- ========================= FND LOG ===========================
1441: l_full_path VARCHAR2(100) := g_path || 'generate_rct_dist_cm';
1442: -- ========================= FND LOG ===========================
1443:
1444: BEGIN

Line 1442: -- ========================= FND LOG ===========================

1438: INVALID_DISTRIBUTION EXCEPTION;
1439:
1440: -- ========================= FND LOG ===========================
1441: l_full_path VARCHAR2(100) := g_path || 'generate_rct_dist_cm';
1442: -- ========================= FND LOG ===========================
1443:
1444: BEGIN
1445:
1446: -- ========================= FND LOG ===========================

Line 1446: -- ========================= FND LOG ===========================

1442: -- ========================= FND LOG ===========================
1443:
1444: BEGIN
1445:
1446: -- ========================= FND LOG ===========================
1447: psa_utils.debug_other_string(g_state_level,l_full_path,' Start Generate_rct_dist_cm ');
1448: psa_utils.debug_other_string(g_state_level,l_full_path,' PARAMETERS');
1449: psa_utils.debug_other_string(g_state_level,l_full_path,' ==========');
1450: psa_utils.debug_other_string(g_state_level,l_full_path,' p_rcv_app_id -> ' || p_rcv_app_id);

Line 1462: -- ========================= FND LOG ===========================

1458: psa_utils.debug_other_string(g_state_level,l_full_path,' p_unearned_discount_ccid -> ' || p_unearned_discount_ccid);
1459: psa_utils.debug_other_string(g_state_level,l_full_path,' p_document_type -> ' || p_document_type);
1460: psa_utils.debug_other_string(g_state_level,l_full_path,' p_crh_status -> ' || p_crh_status);
1461: psa_utils.debug_other_string(g_state_level,l_full_path,' Starting the process ');
1462: -- ========================= FND LOG ===========================
1463:
1464: -- Bug 2609367
1465: -- call psa_mfar_transactions.create_distributions
1466: -- When 'Create Distributions is run as a Conc. program OR invoked from the Action of opening MFAR Form,

Line 1476: -- ========================= FND LOG ===========================

1472: select psa_mF_error_log_s.currval
1473: into run_num
1474: from sys.dual;
1475:
1476: -- ========================= FND LOG ===========================
1477: psa_utils.debug_other_string(g_state_level,l_full_path,' Creating distribution for Cust trx id ==> ' || run_num || ' -- ' || p_cust_trx_id);
1478: -- ========================= FND LOG ===========================
1479:
1480: IF NOT (PSA_MFAR_TRANSACTIONS.create_distributions (

Line 1478: -- ========================= FND LOG ===========================

1474: from sys.dual;
1475:
1476: -- ========================= FND LOG ===========================
1477: psa_utils.debug_other_string(g_state_level,l_full_path,' Creating distribution for Cust trx id ==> ' || run_num || ' -- ' || p_cust_trx_id);
1478: -- ========================= FND LOG ===========================
1479:
1480: IF NOT (PSA_MFAR_TRANSACTIONS.create_distributions (
1481: errbuf => l_errbuf,
1482: retcode => l_retcode,

Line 1488: -- ========================= FND LOG ===========================

1484: p_set_of_books_id => g_set_of_books_id,
1485: p_run_id => run_num,
1486: p_error_message => l_exception_message)) THEN
1487:
1488: -- ========================= FND LOG ===========================
1489: psa_utils.debug_other_string(g_state_level,l_full_path,' PSA_MFAR_TRANSACTIONS.create_distributions --> FALSE');
1490: -- ========================= FND LOG ===========================
1491: IF l_exception_message IS NOT NULL OR l_retcode = 'F' THEN
1492: -- ========================= FND LOG ===========================

Line 1490: -- ========================= FND LOG ===========================

1486: p_error_message => l_exception_message)) THEN
1487:
1488: -- ========================= FND LOG ===========================
1489: psa_utils.debug_other_string(g_state_level,l_full_path,' PSA_MFAR_TRANSACTIONS.create_distributions --> FALSE');
1490: -- ========================= FND LOG ===========================
1491: IF l_exception_message IS NOT NULL OR l_retcode = 'F' THEN
1492: -- ========================= FND LOG ===========================
1493: psa_utils.debug_other_string(g_state_level,l_full_path,' Raising invalid_distribution');
1494: -- ========================= FND LOG ===========================

Line 1492: -- ========================= FND LOG ===========================

1488: -- ========================= FND LOG ===========================
1489: psa_utils.debug_other_string(g_state_level,l_full_path,' PSA_MFAR_TRANSACTIONS.create_distributions --> FALSE');
1490: -- ========================= FND LOG ===========================
1491: IF l_exception_message IS NOT NULL OR l_retcode = 'F' THEN
1492: -- ========================= FND LOG ===========================
1493: psa_utils.debug_other_string(g_state_level,l_full_path,' Raising invalid_distribution');
1494: -- ========================= FND LOG ===========================
1495: Raise invalid_distribution;
1496: END IF;

Line 1494: -- ========================= FND LOG ===========================

1490: -- ========================= FND LOG ===========================
1491: IF l_exception_message IS NOT NULL OR l_retcode = 'F' THEN
1492: -- ========================= FND LOG ===========================
1493: psa_utils.debug_other_string(g_state_level,l_full_path,' Raising invalid_distribution');
1494: -- ========================= FND LOG ===========================
1495: Raise invalid_distribution;
1496: END IF;
1497: ELSE
1498: -- ========================= FND LOG ===========================

Line 1498: -- ========================= FND LOG ===========================

1494: -- ========================= FND LOG ===========================
1495: Raise invalid_distribution;
1496: END IF;
1497: ELSE
1498: -- ========================= FND LOG ===========================
1499: psa_utils.debug_other_string(g_state_level,l_full_path,' cust_trx_id --> ' || p_cust_trx_id);
1500: -- ========================= FND LOG ===========================
1501: END IF;
1502:

Line 1500: -- ========================= FND LOG ===========================

1496: END IF;
1497: ELSE
1498: -- ========================= FND LOG ===========================
1499: psa_utils.debug_other_string(g_state_level,l_full_path,' cust_trx_id --> ' || p_cust_trx_id);
1500: -- ========================= FND LOG ===========================
1501: END IF;
1502:
1503: -- ========================= FND LOG ===========================
1504: psa_utils.debug_other_string(g_state_level,l_full_path,' p_earned_discount --> ' || p_earned_discount );

Line 1503: -- ========================= FND LOG ===========================

1499: psa_utils.debug_other_string(g_state_level,l_full_path,' cust_trx_id --> ' || p_cust_trx_id);
1500: -- ========================= FND LOG ===========================
1501: END IF;
1502:
1503: -- ========================= FND LOG ===========================
1504: psa_utils.debug_other_string(g_state_level,l_full_path,' p_earned_discount --> ' || p_earned_discount );
1505: psa_utils.debug_other_string(g_state_level,l_full_path,' p_unearned_discount --> ' || p_unearned_discount );
1506: -- ========================= FND LOG ===========================
1507:

Line 1506: -- ========================= FND LOG ===========================

1502:
1503: -- ========================= FND LOG ===========================
1504: psa_utils.debug_other_string(g_state_level,l_full_path,' p_earned_discount --> ' || p_earned_discount );
1505: psa_utils.debug_other_string(g_state_level,l_full_path,' p_unearned_discount --> ' || p_unearned_discount );
1506: -- ========================= FND LOG ===========================
1507:
1508: IF (p_earned_discount <> 0 OR p_unearned_discount <> 0) THEN
1509: -- ========================= FND LOG ===========================
1510: psa_utils.debug_other_string(g_state_level,l_full_path,' Calling populate_discount_cache --> ' || p_cust_trx_id);

Line 1509: -- ========================= FND LOG ===========================

1505: psa_utils.debug_other_string(g_state_level,l_full_path,' p_unearned_discount --> ' || p_unearned_discount );
1506: -- ========================= FND LOG ===========================
1507:
1508: IF (p_earned_discount <> 0 OR p_unearned_discount <> 0) THEN
1509: -- ========================= FND LOG ===========================
1510: psa_utils.debug_other_string(g_state_level,l_full_path,' Calling populate_discount_cache --> ' || p_cust_trx_id);
1511: -- ========================= FND LOG ===========================
1512: POPULATE_DISCOUNT_LINES_CACHE (p_cust_trx_id);
1513: END IF;

Line 1511: -- ========================= FND LOG ===========================

1507:
1508: IF (p_earned_discount <> 0 OR p_unearned_discount <> 0) THEN
1509: -- ========================= FND LOG ===========================
1510: psa_utils.debug_other_string(g_state_level,l_full_path,' Calling populate_discount_cache --> ' || p_cust_trx_id);
1511: -- ========================= FND LOG ===========================
1512: POPULATE_DISCOUNT_LINES_CACHE (p_cust_trx_id);
1513: END IF;
1514:
1515: SELECT

Line 1531: -- ========================= FND LOG ===========================

1527: AND trx_line.customer_trx_line_id = trx_dist.customer_trx_line_id
1528: AND trx_dist.cust_trx_line_gl_dist_id = mf_balances.cust_trx_line_gl_dist_id
1529: AND trx_line.customer_trx_line_id = nvl(p_cust_trx_line_id, trx_line.customer_trx_line_id);
1530:
1531: -- ========================= FND LOG ===========================
1532: psa_utils.debug_other_string(g_state_level,l_full_path,' l_total_amount_due --> ' || l_total_amount_due );
1533: psa_utils.debug_other_string(g_state_level,l_full_path,' sum_amt_due_rem --> ' || sum_amt_due_rem );
1534: -- ========================= FND LOG ===========================
1535:

Line 1534: -- ========================= FND LOG ===========================

1530:
1531: -- ========================= FND LOG ===========================
1532: psa_utils.debug_other_string(g_state_level,l_full_path,' l_total_amount_due --> ' || l_total_amount_due );
1533: psa_utils.debug_other_string(g_state_level,l_full_path,' sum_amt_due_rem --> ' || sum_amt_due_rem );
1534: -- ========================= FND LOG ===========================
1535:
1536: --
1537: -- Initailize variables for running total
1538: --

Line 1562: -- ========================= FND LOG ===========================

1558: WHERE app.receivable_application_id = p_rcv_app_id
1559: AND app.status = 'APP';
1560:
1561:
1562: -- ========================= FND LOG ===========================
1563: psa_utils.debug_other_string(g_state_level,l_full_path,' l_running_total_amount_due --> ' || l_running_total_amount_due );
1564: psa_utils.debug_other_string(g_state_level,l_full_path,' l_running_total_amount_earn --> ' || l_running_total_amount_earn);
1565: psa_utils.debug_other_string(g_state_level,l_full_path,' l_running_total_amount_unearn --> ' || l_running_total_amount_unearn);
1566: -- ========================= FND LOG ===========================

Line 1566: -- ========================= FND LOG ===========================

1562: -- ========================= FND LOG ===========================
1563: psa_utils.debug_other_string(g_state_level,l_full_path,' l_running_total_amount_due --> ' || l_running_total_amount_due );
1564: psa_utils.debug_other_string(g_state_level,l_full_path,' l_running_total_amount_earn --> ' || l_running_total_amount_earn);
1565: psa_utils.debug_other_string(g_state_level,l_full_path,' l_running_total_amount_unearn --> ' || l_running_total_amount_unearn);
1566: -- ========================= FND LOG ===========================
1567:
1568: l_c_accrual_stmt :=
1569: 'Select mf_trx_dist.mf_receivables_ccid rcv_ccid, ' ||
1570: ' mf_trx_dist.cust_trx_line_gl_dist_id trx_line_dist_id, ' ||

Line 1615: -- ========================= FND LOG ===========================

1611: l_c_accrual_stmt := l_c_accrual_stmt || ' order by 6,5 asc ';
1612: l_c_cash_stmt := l_c_cash_stmt || ' order by 6,5 asc ';
1613: END IF;
1614:
1615: -- ========================= FND LOG ===========================
1616: psa_utils.debug_other_string(g_state_level,l_full_path,' arp_global.sysparam.accounting_method --> '
1617: || arp_global.sysparam.accounting_method);
1618: -- ========================= FND LOG ===========================
1619:

Line 1618: -- ========================= FND LOG ===========================

1614:
1615: -- ========================= FND LOG ===========================
1616: psa_utils.debug_other_string(g_state_level,l_full_path,' arp_global.sysparam.accounting_method --> '
1617: || arp_global.sysparam.accounting_method);
1618: -- ========================= FND LOG ===========================
1619:
1620: IF arp_global.sysparam.accounting_method = 'ACCRUAL' THEN
1621: OPEN c_accrual_cur FOR l_c_accrual_stmt
1622: USING sum_amt_due_rem, p_cust_trx_id, p_cust_trx_id, p_cust_trx_line_id;

Line 1655: -- ========================= FND LOG ===========================

1651: ELSIF l_accrual_rec.ACCOUNT_CLASS = 'TAX' THEN
1652: p_amount_applied := l_tax_amount;
1653: END IF;
1654:
1655: -- ========================= FND LOG ===========================
1656: psa_utils.debug_other_string(g_state_level,l_full_path,
1657: ' l_accrual_rec.trx_line_dist_id --> ' || l_accrual_rec.trx_line_dist_id );
1658: -- ========================= FND LOG ===========================
1659:

Line 1658: -- ========================= FND LOG ===========================

1654:
1655: -- ========================= FND LOG ===========================
1656: psa_utils.debug_other_string(g_state_level,l_full_path,
1657: ' l_accrual_rec.trx_line_dist_id --> ' || l_accrual_rec.trx_line_dist_id );
1658: -- ========================= FND LOG ===========================
1659:
1660: --
1661: -- If Remittance MFAR distributions have already been created
1662: -- applicable only for Receipts cleared by CashMgt

Line 1671: -- ========================= FND LOG ===========================

1667:
1668: OPEN c_remit_reversal_account (l_accrual_rec.trx_line_dist_id);
1669: FETCH c_remit_reversal_account INTO l_remit_reversal_ccid;
1670: CLOSE c_remit_reversal_account;
1671: -- ========================= FND LOG ===========================
1672: psa_utils.debug_other_string(g_state_level,l_full_path,
1673: ' l_remit_reversal_ccid --> ' || l_remit_reversal_ccid);
1674: -- ========================= FND LOG ===========================
1675: END IF;

Line 1674: -- ========================= FND LOG ===========================

1670: CLOSE c_remit_reversal_account;
1671: -- ========================= FND LOG ===========================
1672: psa_utils.debug_other_string(g_state_level,l_full_path,
1673: ' l_remit_reversal_ccid --> ' || l_remit_reversal_ccid);
1674: -- ========================= FND LOG ===========================
1675: END IF;
1676:
1677: -- ========================= FND LOG ===========================
1678: psa_utils.debug_other_string(g_state_level,l_full_path,' p_document_type -->

Line 1677: -- ========================= FND LOG ===========================

1673: ' l_remit_reversal_ccid --> ' || l_remit_reversal_ccid);
1674: -- ========================= FND LOG ===========================
1675: END IF;
1676:
1677: -- ========================= FND LOG ===========================
1678: psa_utils.debug_other_string(g_state_level,l_full_path,' p_document_type -->
1679: ' || p_document_type );
1680: -- ========================= FND LOG ===========================
1681:

Line 1680: -- ========================= FND LOG ===========================

1676:
1677: -- ========================= FND LOG ===========================
1678: psa_utils.debug_other_string(g_state_level,l_full_path,' p_document_type -->
1679: ' || p_document_type );
1680: -- ========================= FND LOG ===========================
1681:
1682: p_ccid := l_accrual_rec.rcv_ccid;
1683: -- ========================= FND LOG ===========================
1684: psa_utils.debug_other_string(g_state_level,l_full_path,

Line 1683: -- ========================= FND LOG ===========================

1679: ' || p_document_type );
1680: -- ========================= FND LOG ===========================
1681:
1682: p_ccid := l_accrual_rec.rcv_ccid;
1683: -- ========================= FND LOG ===========================
1684: psa_utils.debug_other_string(g_state_level,l_full_path,
1685: ' if cond - document type is CM --> ' || p_ccid);
1686: -- ========================= FND LOG ===========================
1687: --

Line 1686: -- ========================= FND LOG ===========================

1682: p_ccid := l_accrual_rec.rcv_ccid;
1683: -- ========================= FND LOG ===========================
1684: psa_utils.debug_other_string(g_state_level,l_full_path,
1685: ' if cond - document type is CM --> ' || p_ccid);
1686: -- ========================= FND LOG ===========================
1687: --
1688: -- Prorate amount applied
1689: --
1690:

Line 1692: -- ========================= FND LOG ===========================

1688: -- Prorate amount applied
1689: --
1690:
1691: IF p_cust_trx_line_id Is NOT NULL THEN
1692: -- ========================= FND LOG ===========================
1693: psa_utils.debug_other_string(g_state_level,l_full_path,' p_cust_trx_line_id Is NOT NULL');
1694: -- ========================= FND LOG ===========================
1695:
1696: IF (p_cust_trx_line_id = l_accrual_rec.trx_line_id)

Line 1694: -- ========================= FND LOG ===========================

1690:
1691: IF p_cust_trx_line_id Is NOT NULL THEN
1692: -- ========================= FND LOG ===========================
1693: psa_utils.debug_other_string(g_state_level,l_full_path,' p_cust_trx_line_id Is NOT NULL');
1694: -- ========================= FND LOG ===========================
1695:
1696: IF (p_cust_trx_line_id = l_accrual_rec.trx_line_id)
1697: AND NOT (l_running_total_amount_due = 0) THEN -- to avoid divide by zero error
1698:

Line 1704: -- ========================= FND LOG ===========================

1700:
1701: -- l_amount_applied := p_amount_applied - l_running_amount;
1702: l_amount := ROUND((p_amount_applied*l_accrual_rec.amount_due/l_running_total_amount_due), g_precision);
1703:
1704: -- ========================= FND LOG ===========================
1705: psa_utils.debug_other_string(g_state_level,l_full_path,' In IF ' ||
1706: ' ##p_amount_applied --> ' || p_amount_applied ||
1707: ' ##l_amount_applied --> ' || l_amount_applied ||
1708: ' ##l_amount --> ' || l_amount ||

Line 1711: -- ========================= FND LOG ===========================

1707: ' ##l_amount_applied --> ' || l_amount_applied ||
1708: ' ##l_amount --> ' || l_amount ||
1709: ' ##l_accrual_rec.amount_due --> ' || l_accrual_rec.amount_due ||
1710: ' ##l_running_total_amount_due --> ' || l_running_total_amount_due);
1711: -- ========================= FND LOG ===========================
1712: IF NVL(p_amount_applied,0) <> 0 THEN -- Bug3884271
1713: l_percent := ROUND((l_amount/p_amount_applied*100), 4);
1714:
1715:

Line 1723: -- ========================= FND LOG ===========================

1719:
1720: l_running_amount := l_running_amount + l_amount;
1721: -- l_running_total_amount_due := l_running_total_amount_due - l_accrual_rec.amount_due;
1722:
1723: -- ========================= FND LOG ===========================
1724: psa_utils.debug_other_string(g_state_level,l_full_path,' IF part ' ||
1725: ' ##l_amount_applied --> ' || l_amount_applied ||
1726: ' ##l_amount --> ' || l_amount ||
1727: ' ##l_percent --> ' || l_percent ||

Line 1730: -- ========================= FND LOG ===========================

1726: ' ##l_amount --> ' || l_amount ||
1727: ' ##l_percent --> ' || l_percent ||
1728: ' ##l_running_amount --> ' || l_running_amount ||
1729: ' ##l_running_total_amount_due --> ' || l_running_total_amount_due);
1730: -- ========================= FND LOG ===========================
1731:
1732: ELSE
1733:
1734: l_amount := 0;

Line 1736: -- ========================= FND LOG ===========================

1732: ELSE
1733:
1734: l_amount := 0;
1735: l_percent := 0;
1736: -- ========================= FND LOG ===========================
1737: psa_utils.debug_other_string(g_state_level,l_full_path,' ##l_amount --> ' || l_amount || ' ##l_percent --> ' || l_percent);
1738: -- ========================= FND LOG ===========================
1739: END IF;
1740: ELSE

Line 1738: -- ========================= FND LOG ===========================

1734: l_amount := 0;
1735: l_percent := 0;
1736: -- ========================= FND LOG ===========================
1737: psa_utils.debug_other_string(g_state_level,l_full_path,' ##l_amount --> ' || l_amount || ' ##l_percent --> ' || l_percent);
1738: -- ========================= FND LOG ===========================
1739: END IF;
1740: ELSE
1741: -- ========================= FND LOG ===========================
1742: psa_utils.debug_other_string(g_state_level,l_full_path,' p_cust_trx_line_id Is NULL');

Line 1741: -- ========================= FND LOG ===========================

1737: psa_utils.debug_other_string(g_state_level,l_full_path,' ##l_amount --> ' || l_amount || ' ##l_percent --> ' || l_percent);
1738: -- ========================= FND LOG ===========================
1739: END IF;
1740: ELSE
1741: -- ========================= FND LOG ===========================
1742: psa_utils.debug_other_string(g_state_level,l_full_path,' p_cust_trx_line_id Is NULL');
1743: -- ========================= FND LOG ===========================
1744:
1745: IF NOT (l_running_total_amount_due = 0) THEN -- to avoid divide by zero error

Line 1743: -- ========================= FND LOG ===========================

1739: END IF;
1740: ELSE
1741: -- ========================= FND LOG ===========================
1742: psa_utils.debug_other_string(g_state_level,l_full_path,' p_cust_trx_line_id Is NULL');
1743: -- ========================= FND LOG ===========================
1744:
1745: IF NOT (l_running_total_amount_due = 0) THEN -- to avoid divide by zero error
1746:
1747: -- l_amount_applied := p_amount_applied - l_running_amount;

Line 1759: -- ========================= FND LOG ===========================

1755:
1756: l_running_amount := l_running_amount + l_amount;
1757: -- l_running_total_amount_due := l_running_total_amount_due - l_accrual_rec.amount_due;
1758:
1759: -- ========================= FND LOG ===========================
1760: psa_utils.debug_other_string(g_state_level,l_full_path,' ELSE part ' ||
1761: ' ##l_amount_applied --> ' || l_amount_applied ||
1762: ' ##l_amount --> ' || l_amount ||
1763: ' ##l_percent --> ' || l_percent ||

Line 1766: -- ========================= FND LOG ===========================

1762: ' ##l_amount --> ' || l_amount ||
1763: ' ##l_percent --> ' || l_percent ||
1764: ' ##l_running_amount --> ' || l_running_amount ||
1765: ' ##l_running_total_amount_due --> ' || l_running_total_amount_due);
1766: -- ========================= FND LOG ===========================
1767: END IF;
1768: END IF;
1769:
1770: --

Line 1778: -- ========================= FND LOG ===========================

1774: IF (p_earned_discount <> 0 OR p_unearned_discount <> 0) THEN
1775:
1776: IF LINE_IN_DISCOUNT_CACHE (l_accrual_rec.trx_line_id) THEN
1777:
1778: -- ========================= FND LOG ===========================
1779: psa_utils.debug_other_string(g_state_level,l_full_path,' calling LINE_IN_DISCOUNT_CACHE --> ' || l_accrual_rec.trx_line_id);
1780: psa_utils.debug_other_string(g_state_level,l_full_path,' prorate earned discount ');
1781: -- ========================= FND LOG ===========================
1782:

Line 1781: -- ========================= FND LOG ===========================

1777:
1778: -- ========================= FND LOG ===========================
1779: psa_utils.debug_other_string(g_state_level,l_full_path,' calling LINE_IN_DISCOUNT_CACHE --> ' || l_accrual_rec.trx_line_id);
1780: psa_utils.debug_other_string(g_state_level,l_full_path,' prorate earned discount ');
1781: -- ========================= FND LOG ===========================
1782:
1783: --
1784: -- Prorate Earned Discount
1785: --

Line 1796: -- ========================= FND LOG ===========================

1792: l_earned_discount := ROUND((p_earned_discount*l_accrual_rec.amount_due/l_running_total_amount_earn),g_precision);
1793: -- l_running_earned_discount := l_running_earned_discount + l_earned_discount;
1794: -- l_running_total_amount_earn := l_running_total_amount_earn - l_accrual_rec.amount_due;
1795:
1796: -- ========================= FND LOG ===========================
1797: psa_utils.debug_other_string(g_state_level,l_full_path,' IF part ' ||
1798: ' ##l_earn_discount_applied --> ' || l_earn_discount_applied ||
1799: ' ##l_earned_discount --> ' || l_earned_discount ||
1800: ' ##l_running_earned_discount --> ' || l_running_earned_discount ||

Line 1802: -- ========================= FND LOG ===========================

1798: ' ##l_earn_discount_applied --> ' || l_earn_discount_applied ||
1799: ' ##l_earned_discount --> ' || l_earned_discount ||
1800: ' ##l_running_earned_discount --> ' || l_running_earned_discount ||
1801: ' ##l_running_total_amount_earn --> ' || l_running_total_amount_earn);
1802: -- ========================= FND LOG ===========================
1803:
1804: ELSE
1805: l_earned_discount := 0;
1806: -- ========================= FND LOG ===========================

Line 1806: -- ========================= FND LOG ===========================

1802: -- ========================= FND LOG ===========================
1803:
1804: ELSE
1805: l_earned_discount := 0;
1806: -- ========================= FND LOG ===========================
1807: psa_utils.debug_other_string(g_state_level,l_full_path,
1808: ' ELSE part ##l_earned_discount --> ' || l_earned_discount);
1809: -- ========================= FND LOG ===========================
1810: END IF;

Line 1809: -- ========================= FND LOG ===========================

1805: l_earned_discount := 0;
1806: -- ========================= FND LOG ===========================
1807: psa_utils.debug_other_string(g_state_level,l_full_path,
1808: ' ELSE part ##l_earned_discount --> ' || l_earned_discount);
1809: -- ========================= FND LOG ===========================
1810: END IF;
1811:
1812: --
1813: -- Prorate Unearned Discount

Line 1816: -- ========================= FND LOG ===========================

1812: --
1813: -- Prorate Unearned Discount
1814: --
1815:
1816: -- ========================= FND LOG ===========================
1817: psa_utils.debug_other_string(g_state_level,l_full_path,' prorate unearned discount ');
1818: -- ========================= FND LOG ===========================
1819:
1820: IF p_unearned_discount <> 0

Line 1818: -- ========================= FND LOG ===========================

1814: --
1815:
1816: -- ========================= FND LOG ===========================
1817: psa_utils.debug_other_string(g_state_level,l_full_path,' prorate unearned discount ');
1818: -- ========================= FND LOG ===========================
1819:
1820: IF p_unearned_discount <> 0
1821: AND NOT (l_running_total_amount_unearn = 0) THEN -- to avoid divide by zero error
1822:

Line 1829: -- ========================= FND LOG ===========================

1825: l_unearned_discount := ROUND((p_unearned_discount*l_accrual_rec.amount_due/l_running_total_amount_unearn),g_precision);
1826: -- l_running_unearn_discount := l_running_unearn_discount + l_unearned_discount;
1827: -- l_running_total_amount_unearn := l_running_total_amount_unearn - l_accrual_rec.amount_due;
1828:
1829: -- ========================= FND LOG ===========================
1830: psa_utils.debug_other_string(g_state_level,l_full_path,' IF part ' ||
1831: ' ##l_earn_discount_applied --> ' || l_earn_discount_applied ||
1832: ' ##l_earned_discount --> ' || l_earned_discount ||
1833: ' ##l_running_earned_discount --> ' || l_running_earned_discount ||

Line 1835: -- ========================= FND LOG ===========================

1831: ' ##l_earn_discount_applied --> ' || l_earn_discount_applied ||
1832: ' ##l_earned_discount --> ' || l_earned_discount ||
1833: ' ##l_running_earned_discount --> ' || l_running_earned_discount ||
1834: ' ##l_running_total_amount_earn --> ' || l_running_total_amount_earn);
1835: -- ========================= FND LOG ===========================
1836: ELSE
1837: l_unearned_discount := 0;
1838: -- ========================= FND LOG ===========================
1839: psa_utils.debug_other_string(g_state_level,l_full_path,' ELSE part ##l_unearned_discount --> ' || l_unearned_discount);

Line 1838: -- ========================= FND LOG ===========================

1834: ' ##l_running_total_amount_earn --> ' || l_running_total_amount_earn);
1835: -- ========================= FND LOG ===========================
1836: ELSE
1837: l_unearned_discount := 0;
1838: -- ========================= FND LOG ===========================
1839: psa_utils.debug_other_string(g_state_level,l_full_path,' ELSE part ##l_unearned_discount --> ' || l_unearned_discount);
1840: -- ========================= FND LOG ===========================
1841:
1842: END IF;

Line 1840: -- ========================= FND LOG ===========================

1836: ELSE
1837: l_unearned_discount := 0;
1838: -- ========================= FND LOG ===========================
1839: psa_utils.debug_other_string(g_state_level,l_full_path,' ELSE part ##l_unearned_discount --> ' || l_unearned_discount);
1840: -- ========================= FND LOG ===========================
1841:
1842: END IF;
1843:
1844: IF p_earned_discount_ccid IS NOT NULL THEN

Line 1845: -- ========================= FND LOG ===========================

1841:
1842: END IF;
1843:
1844: IF p_earned_discount_ccid IS NOT NULL THEN
1845: -- ========================= FND LOG ===========================
1846: psa_utils.debug_other_string(g_state_level,l_full_path,
1847: ' calling PSA_MFAR_UTILS.OVERRIDE_SEGMENTS for earned discount');
1848: psa_utils.debug_other_string(g_state_level,l_full_path,' p_earned_discount_ccid IS NOT NULL ');
1849: psa_utils.debug_other_string(g_state_level,l_full_path,

Line 1854: -- ========================= FND LOG ===========================

1850: ' ##p_unearned_discount_ccid --> ' || p_unearned_discount_ccid ||
1851: ' ##rcv_ccid --> ' || l_accrual_rec.rcv_ccid ||
1852: ' ##g_set_of_books_id --> ' || g_set_of_books_id ||
1853: ' ##p_mf_earned_discount_ccid --> ' || p_mf_earned_discount_ccid);
1854: -- ========================= FND LOG ===========================
1855:
1856: IF NOT ( PSA_MFAR_UTILS.OVERRIDE_SEGMENTS (p_earned_discount_ccid,
1857: l_accrual_rec.rcv_ccid,
1858: g_set_of_books_id,'RCT',

Line 1861: -- ========================= FND LOG ===========================

1857: l_accrual_rec.rcv_ccid,
1858: g_set_of_books_id,'RCT',
1859: p_mf_earned_discount_ccid) ) THEN
1860:
1861: -- ========================= FND LOG ===========================
1862: psa_utils.debug_other_string(g_state_level,l_full_path,' PSA_MFAR_UTILS.OVERRIDE_SEGMENTS -> FALSE');
1863: -- ========================= FND LOG ===========================
1864: RAISE FLEX_BUILD_ERROR;
1865: END IF;

Line 1863: -- ========================= FND LOG ===========================

1859: p_mf_earned_discount_ccid) ) THEN
1860:
1861: -- ========================= FND LOG ===========================
1862: psa_utils.debug_other_string(g_state_level,l_full_path,' PSA_MFAR_UTILS.OVERRIDE_SEGMENTS -> FALSE');
1863: -- ========================= FND LOG ===========================
1864: RAISE FLEX_BUILD_ERROR;
1865: END IF;
1866: ELSE
1867: -- ========================= FND LOG ===========================

Line 1867: -- ========================= FND LOG ===========================

1863: -- ========================= FND LOG ===========================
1864: RAISE FLEX_BUILD_ERROR;
1865: END IF;
1866: ELSE
1867: -- ========================= FND LOG ===========================
1868: psa_utils.debug_other_string(g_state_level,l_full_path,' p_earned_discount_ccid IS NULL ');
1869: -- ========================= FND LOG ===========================
1870: END IF;
1871:

Line 1869: -- ========================= FND LOG ===========================

1865: END IF;
1866: ELSE
1867: -- ========================= FND LOG ===========================
1868: psa_utils.debug_other_string(g_state_level,l_full_path,' p_earned_discount_ccid IS NULL ');
1869: -- ========================= FND LOG ===========================
1870: END IF;
1871:
1872: IF p_unearned_discount_ccid IS NOT NULL THEN
1873: -- ========================= FND LOG ===========================

Line 1873: -- ========================= FND LOG ===========================

1869: -- ========================= FND LOG ===========================
1870: END IF;
1871:
1872: IF p_unearned_discount_ccid IS NOT NULL THEN
1873: -- ========================= FND LOG ===========================
1874: psa_utils.debug_other_string(g_state_level,l_full_path,
1875: ' calling PSA_MFAR_UTILS.OVERRIDE_SEGMENTS for unearned discount');
1876: psa_utils.debug_other_string(g_state_level,l_full_path,
1877: ' p_earned_discount_ccid IS NOT NULL ');

Line 1883: -- ========================= FND LOG ===========================

1879: ' ##p_unearned_discount_ccid --> ' || p_unearned_discount_ccid ||
1880: ' ##rcv_ccid --> ' || l_accrual_rec.rcv_ccid ||
1881: ' ##g_set_of_books_id --> ' || g_set_of_books_id ||
1882: ' ##p_mf_unearned_discount_ccid --> ' || p_mf_unearned_discount_ccid);
1883: -- ========================= FND LOG ===========================
1884:
1885: IF NOT ( PSA_MFAR_UTILS.OVERRIDE_SEGMENTS ( P_PRIMARY_CCID => p_unearned_discount_ccid,
1886: P_OVERRIDE_CCID => l_accrual_rec.rcv_ccid,
1887: P_SET_OF_BOOKS_ID => g_set_of_books_id,

Line 1891: -- ========================= FND LOG ===========================

1887: P_SET_OF_BOOKS_ID => g_set_of_books_id,
1888: P_TRX_TYPE => 'RCT',
1889: P_CCID => p_mf_unearned_discount_ccid)) -- OUT
1890: THEN
1891: -- ========================= FND LOG ===========================
1892: psa_utils.debug_other_string(g_state_level,l_full_path,' PSA_MFAR_UTILS.OVERRIDE_SEGMENTS -> FALSE ');
1893: psa_utils.debug_other_string(g_state_level,l_full_path,' Raising flex_build_error ');
1894: -- ========================= FND LOG ===========================
1895: RAISE FLEX_BUILD_ERROR;

Line 1894: -- ========================= FND LOG ===========================

1890: THEN
1891: -- ========================= FND LOG ===========================
1892: psa_utils.debug_other_string(g_state_level,l_full_path,' PSA_MFAR_UTILS.OVERRIDE_SEGMENTS -> FALSE ');
1893: psa_utils.debug_other_string(g_state_level,l_full_path,' Raising flex_build_error ');
1894: -- ========================= FND LOG ===========================
1895: RAISE FLEX_BUILD_ERROR;
1896: ELSE
1897: -- ========================= FND LOG ===========================
1898: psa_utils.debug_other_string(g_state_level,l_full_path,

Line 1897: -- ========================= FND LOG ===========================

1893: psa_utils.debug_other_string(g_state_level,l_full_path,' Raising flex_build_error ');
1894: -- ========================= FND LOG ===========================
1895: RAISE FLEX_BUILD_ERROR;
1896: ELSE
1897: -- ========================= FND LOG ===========================
1898: psa_utils.debug_other_string(g_state_level,l_full_path,
1899: ' p_mf_unearned_discount_ccid -> ' || p_mf_unearned_discount_ccid);
1900: -- ========================= FND LOG ===========================
1901: END IF;

Line 1900: -- ========================= FND LOG ===========================

1896: ELSE
1897: -- ========================= FND LOG ===========================
1898: psa_utils.debug_other_string(g_state_level,l_full_path,
1899: ' p_mf_unearned_discount_ccid -> ' || p_mf_unearned_discount_ccid);
1900: -- ========================= FND LOG ===========================
1901: END IF;
1902: END IF;
1903: END IF;
1904: END IF;

Line 1906: -- ========================= FND LOG ===========================

1902: END IF;
1903: END IF;
1904: END IF;
1905:
1906: -- ========================= FND LOG ===========================
1907: psa_utils.debug_other_string(g_state_level,l_full_path,' calling PSA_MFAR_RECEIPTS_COVER_PKG.INSERT_ROW');
1908: -- ========================= FND LOG ===========================
1909:
1910: --

Line 1908: -- ========================= FND LOG ===========================

1904: END IF;
1905:
1906: -- ========================= FND LOG ===========================
1907: psa_utils.debug_other_string(g_state_level,l_full_path,' calling PSA_MFAR_RECEIPTS_COVER_PKG.INSERT_ROW');
1908: -- ========================= FND LOG ===========================
1909:
1910: --
1911: -- Insert into psa_mf_rct_dist_all
1912: --

Line 1918: -- ========================= FND LOG ===========================

1914: IF l_count = 1 THEN
1915:
1916: l_amount := -1*(-1*p_amount_applied - (-1*l_running_amount - (-1*l_amount)));
1917:
1918: -- ========================= FND LOG ===========================
1919: psa_utils.debug_other_string(g_state_level,l_full_path,
1920: ' l_amount -> ' ||l_amount);
1921: -- ========================= FND LOG ===========================
1922: END IF;

Line 1921: -- ========================= FND LOG ===========================

1917:
1918: -- ========================= FND LOG ===========================
1919: psa_utils.debug_other_string(g_state_level,l_full_path,
1920: ' l_amount -> ' ||l_amount);
1921: -- ========================= FND LOG ===========================
1922: END IF;
1923:
1924: IF nvl(l_amount, 0) <> 0 THEN
1925: PSA_MFAR_RECEIPTS_COVER_PKG.INSERT_ROW

Line 1971: -- ========================= FND LOG ===========================

1967:
1968: END LOOP;
1969: CLOSE c_accrual_cur;
1970:
1971: -- ========================= FND LOG ===========================
1972: psa_utils.debug_other_string(g_state_level,l_full_path,' retcode --> ' || retcode );
1973: psa_utils.debug_other_string(g_state_level,l_full_path,' RETURN TRUE ');
1974: -- ========================= FND LOG ===========================
1975:

Line 1974: -- ========================= FND LOG ===========================

1970:
1971: -- ========================= FND LOG ===========================
1972: psa_utils.debug_other_string(g_state_level,l_full_path,' retcode --> ' || retcode );
1973: psa_utils.debug_other_string(g_state_level,l_full_path,' RETURN TRUE ');
1974: -- ========================= FND LOG ===========================
1975:
1976: retcode := 'S';
1977: RETURN TRUE;
1978:

Line 1983: -- ========================= FND LOG ===========================

1979:
1980: EXCEPTION
1981: -- Bug 3672756
1982: WHEN INVALID_DISTRIBUTION THEN
1983: -- ========================= FND LOG ===========================
1984: psa_utils.debug_other_string(g_excep_level,l_full_path,
1985: ' --> EXCEPTION - INVALID_DISTRIBUTION raised during PSA_MFAR_RECEIPTS.generate_rct_dist ');
1986: psa_utils.debug_other_string(g_excep_level,l_full_path,
1987: ' --> p_error_message --> ' || l_exception_message);

Line 1988: -- ========================= FND LOG ===========================

1984: psa_utils.debug_other_string(g_excep_level,l_full_path,
1985: ' --> EXCEPTION - INVALID_DISTRIBUTION raised during PSA_MFAR_RECEIPTS.generate_rct_dist ');
1986: psa_utils.debug_other_string(g_excep_level,l_full_path,
1987: ' --> p_error_message --> ' || l_exception_message);
1988: -- ========================= FND LOG ===========================
1989: p_error_message := l_exception_message;
1990: retcode := 'F';
1991: RETURN FALSE;
1992:

Line 1995: -- ========================= FND LOG ===========================

1991: RETURN FALSE;
1992:
1993: WHEN FLEX_BUILD_ERROR THEN
1994: l_exception_message := fnd_message.get;
1995: -- ========================= FND LOG ===========================
1996: psa_utils.debug_other_string(g_excep_level,l_full_path,
1997: ' --> EXCEPTION - FLEX_BUILD_ERROR raised during PSA_MFAR_RECEIPTS.generate_rct_dist ');
1998: psa_utils.debug_other_string(g_excep_level,l_full_path,
1999: ' --> p_error_message --> ' || l_exception_message);

Line 2000: -- ========================= FND LOG ===========================

1996: psa_utils.debug_other_string(g_excep_level,l_full_path,
1997: ' --> EXCEPTION - FLEX_BUILD_ERROR raised during PSA_MFAR_RECEIPTS.generate_rct_dist ');
1998: psa_utils.debug_other_string(g_excep_level,l_full_path,
1999: ' --> p_error_message --> ' || l_exception_message);
2000: -- ========================= FND LOG ===========================
2001: p_error_message := l_exception_message;
2002: retcode := 'F';
2003: RETURN FALSE;
2004:

Line 2007: -- ========================= FND LOG ===========================

2003: RETURN FALSE;
2004:
2005: WHEN OTHERS THEN
2006: l_exception_message := l_exception_message || SQLCODE || ' - ' || SQLERRM;
2007: -- ========================= FND LOG ===========================
2008: psa_utils.debug_other_string(g_excep_level,l_full_path,
2009: ' --> EXCEPTION - OTHERS raised during PSA_MFAR_RECEIPTS.generate_rct_dist ');
2010: psa_utils.debug_other_string(g_excep_level,l_full_path,
2011: ' --> p_error_message --> ' || l_exception_message);

Line 2013: -- ========================= FND LOG ===========================

2009: ' --> EXCEPTION - OTHERS raised during PSA_MFAR_RECEIPTS.generate_rct_dist ');
2010: psa_utils.debug_other_string(g_excep_level,l_full_path,
2011: ' --> p_error_message --> ' || l_exception_message);
2012: psa_utils.debug_unexpected_msg(l_full_path);
2013: -- ========================= FND LOG ===========================
2014: p_error_message := l_exception_message;
2015: retcode := 'F';
2016: RETURN FALSE;
2017:

Line 2038: -- ========================= FND LOG ===========================

2034: -- OR not(app.display = 'Y')
2035:
2036:
2037: l_invalid_distributions_rec c_invalid_distributions%rowtype;
2038: -- ========================= FND LOG ===========================
2039: l_full_path VARCHAR2(100) := g_path || 'purge_orphan_distributions';
2040: -- ========================= FND LOG ===========================
2041:
2042: BEGIN

Line 2040: -- ========================= FND LOG ===========================

2036:
2037: l_invalid_distributions_rec c_invalid_distributions%rowtype;
2038: -- ========================= FND LOG ===========================
2039: l_full_path VARCHAR2(100) := g_path || 'purge_orphan_distributions';
2040: -- ========================= FND LOG ===========================
2041:
2042: BEGIN
2043:
2044: -- ========================= FND LOG ===========================

Line 2044: -- ========================= FND LOG ===========================

2040: -- ========================= FND LOG ===========================
2041:
2042: BEGIN
2043:
2044: -- ========================= FND LOG ===========================
2045: psa_utils.debug_other_string(g_state_level,l_full_path,' Purge_orphan_distributions : --> START');
2046: -- ========================= FND LOG ===========================
2047:
2048: OPEN c_invalid_distributions;

Line 2046: -- ========================= FND LOG ===========================

2042: BEGIN
2043:
2044: -- ========================= FND LOG ===========================
2045: psa_utils.debug_other_string(g_state_level,l_full_path,' Purge_orphan_distributions : --> START');
2046: -- ========================= FND LOG ===========================
2047:
2048: OPEN c_invalid_distributions;
2049: LOOP
2050: FETCH c_invalid_distributions INTO l_invalid_distributions_rec;

Line 2053: -- ========================= FND LOG ===========================

2049: LOOP
2050: FETCH c_invalid_distributions INTO l_invalid_distributions_rec;
2051: EXIT WHEN c_invalid_distributions%NOTFOUND;
2052:
2053: -- ========================= FND LOG ===========================
2054: psa_utils.debug_other_string(g_state_level,l_full_path,' Purge_orphan_distributions : --> deleting ' || l_invalid_distributions_rec.rcv_app_id);
2055: -- ========================= FND LOG ===========================
2056:
2057: DELETE FROM psa_mf_rct_dist_all

Line 2055: -- ========================= FND LOG ===========================

2051: EXIT WHEN c_invalid_distributions%NOTFOUND;
2052:
2053: -- ========================= FND LOG ===========================
2054: psa_utils.debug_other_string(g_state_level,l_full_path,' Purge_orphan_distributions : --> deleting ' || l_invalid_distributions_rec.rcv_app_id);
2055: -- ========================= FND LOG ===========================
2056:
2057: DELETE FROM psa_mf_rct_dist_all
2058: WHERE receivable_application_id = l_invalid_distributions_rec.rcv_app_id;
2059:

Line 2060: -- ========================= FND LOG ===========================

2056:
2057: DELETE FROM psa_mf_rct_dist_all
2058: WHERE receivable_application_id = l_invalid_distributions_rec.rcv_app_id;
2059:
2060: -- ========================= FND LOG ===========================
2061: psa_utils.debug_other_string(g_state_level,l_full_path,' Purge_orphan_distributions : --> rows ' || SQL%ROWCOUNT);
2062: -- ========================= FND LOG ===========================
2063:
2064: END LOOP;

Line 2062: -- ========================= FND LOG ===========================

2058: WHERE receivable_application_id = l_invalid_distributions_rec.rcv_app_id;
2059:
2060: -- ========================= FND LOG ===========================
2061: psa_utils.debug_other_string(g_state_level,l_full_path,' Purge_orphan_distributions : --> rows ' || SQL%ROWCOUNT);
2062: -- ========================= FND LOG ===========================
2063:
2064: END LOOP;
2065: CLOSE c_invalid_distributions;
2066:

Line 2067: -- ========================= FND LOG ===========================

2063:
2064: END LOOP;
2065: CLOSE c_invalid_distributions;
2066:
2067: -- ========================= FND LOG ===========================
2068: psa_utils.debug_other_string(g_state_level,l_full_path,' Purge_orphan_distributions : --> END');
2069: -- ========================= FND LOG ===========================
2070:
2071: EXCEPTION

Line 2069: -- ========================= FND LOG ===========================

2065: CLOSE c_invalid_distributions;
2066:
2067: -- ========================= FND LOG ===========================
2068: psa_utils.debug_other_string(g_state_level,l_full_path,' Purge_orphan_distributions : --> END');
2069: -- ========================= FND LOG ===========================
2070:
2071: EXCEPTION
2072: WHEN OTHERS THEN
2073: l_exception_message := 'EXCEPTION - OTHERS PACKAGE - PSA_MFAR_RECEIPTS.PURGE_ORPHAN_DISTRIBUTIONS: '||sqlerrm;

Line 2076: -- ========================= FND LOG ===========================

2072: WHEN OTHERS THEN
2073: l_exception_message := 'EXCEPTION - OTHERS PACKAGE - PSA_MFAR_RECEIPTS.PURGE_ORPHAN_DISTRIBUTIONS: '||sqlerrm;
2074: PSA_MFAR_UTILS.INSERT_DISTRIBUTIONS_LOG (g_run_id, 'RECEIPT', g_cust_trx_id, g_receivable_application_id,
2075: l_exception_message);
2076: -- ========================= FND LOG ===========================
2077: psa_utils.debug_other_string(g_excep_level,l_full_path,l_exception_message);
2078: psa_utils.debug_unexpected_msg(l_full_path);
2079: -- ========================= FND LOG ===========================
2080:

Line 2079: -- ========================= FND LOG ===========================

2075: l_exception_message);
2076: -- ========================= FND LOG ===========================
2077: psa_utils.debug_other_string(g_excep_level,l_full_path,l_exception_message);
2078: psa_utils.debug_unexpected_msg(l_full_path);
2079: -- ========================= FND LOG ===========================
2080:
2081: END purge_orphan_distributions;
2082:
2083: /**************************** POPULATE_DISCOUNT_LINES_CACHE *******************************************/

Line 2098: -- ========================= FND LOG ===========================

2094: WHERE trx.customer_trx_id = p_customer_trx_id
2095: AND trx.term_id = terms.term_id;
2096:
2097: l_variables_rec c_variables%rowtype;
2098: -- ========================= FND LOG ===========================
2099: l_full_path VARCHAR2(100) := g_path || 'populate_discount_lines_cache';
2100: -- ========================= FND LOG ===========================
2101:
2102: BEGIN

Line 2100: -- ========================= FND LOG ===========================

2096:
2097: l_variables_rec c_variables%rowtype;
2098: -- ========================= FND LOG ===========================
2099: l_full_path VARCHAR2(100) := g_path || 'populate_discount_lines_cache';
2100: -- ========================= FND LOG ===========================
2101:
2102: BEGIN
2103:
2104:

Line 2105: -- ========================= FND LOG ===========================

2101:
2102: BEGIN
2103:
2104:
2105: -- ========================= FND LOG ===========================
2106: psa_utils.debug_other_string(g_state_level,l_full_path,' Populate_discount_lines_cache : --> START');
2107: -- ========================= FND LOG ===========================
2108:
2109: OPEN c_variables;

Line 2107: -- ========================= FND LOG ===========================

2103:
2104:
2105: -- ========================= FND LOG ===========================
2106: psa_utils.debug_other_string(g_state_level,l_full_path,' Populate_discount_lines_cache : --> START');
2107: -- ========================= FND LOG ===========================
2108:
2109: OPEN c_variables;
2110: FETCH c_variables INTO l_variables_rec;
2111: CLOSE c_variables;

Line 2113: -- ========================= FND LOG ===========================

2109: OPEN c_variables;
2110: FETCH c_variables INTO l_variables_rec;
2111: CLOSE c_variables;
2112:
2113: -- ========================= FND LOG ===========================
2114: psa_utils.debug_other_string(g_state_level,l_full_path,' Populate_discount_lines_cache : Created form --> ' || l_variables_rec.created_from);
2115: -- ========================= FND LOG ===========================
2116:
2117: --

Line 2115: -- ========================= FND LOG ===========================

2111: CLOSE c_variables;
2112:
2113: -- ========================= FND LOG ===========================
2114: psa_utils.debug_other_string(g_state_level,l_full_path,' Populate_discount_lines_cache : Created form --> ' || l_variables_rec.created_from);
2115: -- ========================= FND LOG ===========================
2116:
2117: --
2118: -- For a transaction created manually, "discount basis" is taken into
2119: -- account while prorating the discount amount among the distributions

Line 2137: -- ========================= FND LOG ===========================

2133: --
2134:
2135: IF l_variables_rec.created_from = 'RAXTRX' THEN -- IMPORTED THRU' AUTOINVOICE
2136: IMPORTED_TRANSACTION (p_customer_trx_id, l_variables_rec.discount_basis);
2137: -- ========================= FND LOG ===========================
2138: psa_utils.debug_other_string(g_state_level,l_full_path,' Populate_discount_lines_cache : imported trans --> ##p_customer_trx_id --> ' || p_customer_trx_id || ' ##discount_basis --> ' || l_variables_rec.discount_basis);
2139: -- ========================= FND LOG ===========================
2140:
2141: ELSE

Line 2139: -- ========================= FND LOG ===========================

2135: IF l_variables_rec.created_from = 'RAXTRX' THEN -- IMPORTED THRU' AUTOINVOICE
2136: IMPORTED_TRANSACTION (p_customer_trx_id, l_variables_rec.discount_basis);
2137: -- ========================= FND LOG ===========================
2138: psa_utils.debug_other_string(g_state_level,l_full_path,' Populate_discount_lines_cache : imported trans --> ##p_customer_trx_id --> ' || p_customer_trx_id || ' ##discount_basis --> ' || l_variables_rec.discount_basis);
2139: -- ========================= FND LOG ===========================
2140:
2141: ELSE
2142: MANUAL_TRANSACTION (p_customer_trx_id, l_variables_rec.discount_basis);
2143: -- ========================= FND LOG ===========================

Line 2143: -- ========================= FND LOG ===========================

2139: -- ========================= FND LOG ===========================
2140:
2141: ELSE
2142: MANUAL_TRANSACTION (p_customer_trx_id, l_variables_rec.discount_basis);
2143: -- ========================= FND LOG ===========================
2144: psa_utils.debug_other_string(g_state_level,l_full_path,' Populate_discount_lines_cache : manual trans --> ##p_customer_trx_id --> ' || p_customer_trx_id || ' ##discount_basis --> ' || l_variables_rec.discount_basis);
2145: -- ========================= FND LOG ===========================
2146: END IF;
2147:

Line 2145: -- ========================= FND LOG ===========================

2141: ELSE
2142: MANUAL_TRANSACTION (p_customer_trx_id, l_variables_rec.discount_basis);
2143: -- ========================= FND LOG ===========================
2144: psa_utils.debug_other_string(g_state_level,l_full_path,' Populate_discount_lines_cache : manual trans --> ##p_customer_trx_id --> ' || p_customer_trx_id || ' ##discount_basis --> ' || l_variables_rec.discount_basis);
2145: -- ========================= FND LOG ===========================
2146: END IF;
2147:
2148: EXCEPTION
2149: WHEN OTHERS THEN

Line 2153: -- ========================= FND LOG ===========================

2149: WHEN OTHERS THEN
2150: l_exception_message := 'EXCEPTION - OTHERS PACKAGE - PSA_MFAR_RECEIPTS.POPULATE_DISCOUNT_LINES_CACHE: '||sqlerrm;
2151: PSA_MFAR_UTILS.INSERT_DISTRIBUTIONS_LOG (g_run_id, 'RECEIPT', g_cust_trx_id, g_receivable_application_id,
2152: l_exception_message);
2153: -- ========================= FND LOG ===========================
2154: psa_utils.debug_other_string(g_excep_level,l_full_path,l_exception_message);
2155: psa_utils.debug_unexpected_msg(l_full_path);
2156: -- ========================= FND LOG ===========================
2157:

Line 2156: -- ========================= FND LOG ===========================

2152: l_exception_message);
2153: -- ========================= FND LOG ===========================
2154: psa_utils.debug_other_string(g_excep_level,l_full_path,l_exception_message);
2155: psa_utils.debug_unexpected_msg(l_full_path);
2156: -- ========================= FND LOG ===========================
2157:
2158: END populate_discount_lines_cache;
2159:
2160: /**************************** MANUAL_TRANSACTION *******************************************/

Line 2174: -- ========================= FND LOG ===========================

2170: AND include_manual_line (discount_basis, link_to_cust_trx_line_id, line_type) = 'Y';
2171:
2172: l_manual_trx_rec c_manual_trx%ROWTYPE;
2173: l_index NUMBER := 1;
2174: -- ========================= FND LOG ===========================
2175: l_full_path VARCHAR2(100) := g_path || 'manual_transaction';
2176: -- ========================= FND LOG ===========================
2177:
2178: BEGIN

Line 2176: -- ========================= FND LOG ===========================

2172: l_manual_trx_rec c_manual_trx%ROWTYPE;
2173: l_index NUMBER := 1;
2174: -- ========================= FND LOG ===========================
2175: l_full_path VARCHAR2(100) := g_path || 'manual_transaction';
2176: -- ========================= FND LOG ===========================
2177:
2178: BEGIN
2179:
2180: -- ========================= FND LOG ===========================

Line 2180: -- ========================= FND LOG ===========================

2176: -- ========================= FND LOG ===========================
2177:
2178: BEGIN
2179:
2180: -- ========================= FND LOG ===========================
2181: psa_utils.debug_other_string(g_state_level,l_full_path,' Manual_transaction : START ');
2182: psa_utils.debug_other_string(g_state_level,l_full_path,' Manual_transaction : calling RESET_DISCOUNT_CACHE ');
2183: -- ========================= FND LOG ===========================
2184:

Line 2183: -- ========================= FND LOG ===========================

2179:
2180: -- ========================= FND LOG ===========================
2181: psa_utils.debug_other_string(g_state_level,l_full_path,' Manual_transaction : START ');
2182: psa_utils.debug_other_string(g_state_level,l_full_path,' Manual_transaction : calling RESET_DISCOUNT_CACHE ');
2183: -- ========================= FND LOG ===========================
2184:
2185: RESET_DISCOUNT_CACHE;
2186:
2187: OPEN c_manual_trx;

Line 2193: -- ========================= FND LOG ===========================

2189:
2190: FETCH c_manual_trx INTO l_manual_trx_rec;
2191: EXIT WHEN c_manual_trx%NOTFOUND;
2192:
2193: -- ========================= FND LOG ===========================
2194: psa_utils.debug_other_string(g_state_level,l_full_path,' Manual_transaction : customer_trx_line_id --> ' || l_manual_trx_rec.customer_trx_line_id);
2195: -- ========================= FND LOG ===========================
2196:
2197: TrxLinesTab(l_index) := l_manual_trx_rec.customer_trx_line_id;

Line 2195: -- ========================= FND LOG ===========================

2191: EXIT WHEN c_manual_trx%NOTFOUND;
2192:
2193: -- ========================= FND LOG ===========================
2194: psa_utils.debug_other_string(g_state_level,l_full_path,' Manual_transaction : customer_trx_line_id --> ' || l_manual_trx_rec.customer_trx_line_id);
2195: -- ========================= FND LOG ===========================
2196:
2197: TrxLinesTab(l_index) := l_manual_trx_rec.customer_trx_line_id;
2198: l_index := l_index + 1;
2199:

Line 2203: -- ========================= FND LOG ===========================

2199:
2200: END LOOP;
2201: CLOSE c_manual_trx;
2202:
2203: -- ========================= FND LOG ===========================
2204: psa_utils.debug_other_string(g_state_level,l_full_path,' Manual_transaction : END ');
2205: -- ========================= FND LOG ===========================
2206:
2207: EXCEPTION

Line 2205: -- ========================= FND LOG ===========================

2201: CLOSE c_manual_trx;
2202:
2203: -- ========================= FND LOG ===========================
2204: psa_utils.debug_other_string(g_state_level,l_full_path,' Manual_transaction : END ');
2205: -- ========================= FND LOG ===========================
2206:
2207: EXCEPTION
2208: WHEN OTHERS THEN
2209: l_exception_message := 'EXCEPTION - OTHERS PACKAGE - PSA_MFAR_RECEIPTS.MANUAL_TRANSACTION: '||sqlerrm;

Line 2212: -- ========================= FND LOG ===========================

2208: WHEN OTHERS THEN
2209: l_exception_message := 'EXCEPTION - OTHERS PACKAGE - PSA_MFAR_RECEIPTS.MANUAL_TRANSACTION: '||sqlerrm;
2210: PSA_MFAR_UTILS.INSERT_DISTRIBUTIONS_LOG (g_run_id, 'RECEIPT', g_cust_trx_id, g_receivable_application_id,
2211: l_exception_message);
2212: -- ========================= FND LOG ===========================
2213: psa_utils.debug_other_string(g_excep_level,l_full_path,l_exception_message);
2214: psa_utils.debug_unexpected_msg(l_full_path);
2215: -- ========================= FND LOG ===========================
2216: END manual_transaction;

Line 2215: -- ========================= FND LOG ===========================

2211: l_exception_message);
2212: -- ========================= FND LOG ===========================
2213: psa_utils.debug_other_string(g_excep_level,l_full_path,l_exception_message);
2214: psa_utils.debug_unexpected_msg(l_full_path);
2215: -- ========================= FND LOG ===========================
2216: END manual_transaction;
2217:
2218:
2219: /**************************** INCLUDE_MANUAL_LINE *******************************************/

Line 2232: -- ========================= FND LOG ===========================

2228: FROM ra_customer_trx_lines
2229: WHERE customer_trx_line_id = p_link_to_cust_trx_line_id;
2230:
2231: l_tax_line c_tax_line%rowtype;
2232: -- ========================= FND LOG ===========================
2233: l_full_path VARCHAR2(100) := g_path || 'include_manual_line';
2234: -- ========================= FND LOG ===========================
2235:
2236: BEGIN

Line 2234: -- ========================= FND LOG ===========================

2230:
2231: l_tax_line c_tax_line%rowtype;
2232: -- ========================= FND LOG ===========================
2233: l_full_path VARCHAR2(100) := g_path || 'include_manual_line';
2234: -- ========================= FND LOG ===========================
2235:
2236: BEGIN
2237:
2238: -- ========================= FND LOG ===========================

Line 2238: -- ========================= FND LOG ===========================

2234: -- ========================= FND LOG ===========================
2235:
2236: BEGIN
2237:
2238: -- ========================= FND LOG ===========================
2239: psa_utils.debug_other_string(g_state_level,l_full_path,' Include_manual_line : START');
2240: -- ========================= FND LOG ===========================
2241:
2242: IF p_discount_basis = 'I' THEN

Line 2240: -- ========================= FND LOG ===========================

2236: BEGIN
2237:
2238: -- ========================= FND LOG ===========================
2239: psa_utils.debug_other_string(g_state_level,l_full_path,' Include_manual_line : START');
2240: -- ========================= FND LOG ===========================
2241:
2242: IF p_discount_basis = 'I' THEN
2243: RETURN 'Y';
2244:

Line 2278: -- ========================= FND LOG ===========================

2274: WHEN OTHERS THEN
2275: l_exception_message := 'EXCEPTION - OTHERS PACKAGE - PSA_MFAR_RECEIPTS.INCLUDE_MANUAL_LINE: '|| sqlerrm;
2276: PSA_MFAR_UTILS.INSERT_DISTRIBUTIONS_LOG (g_run_id, 'RECEIPT', g_cust_trx_id, g_receivable_application_id,
2277: l_exception_message);
2278: -- ========================= FND LOG ===========================
2279: psa_utils.debug_other_string(g_excep_level,l_full_path,l_exception_message);
2280: psa_utils.debug_unexpected_msg(l_full_path);
2281: -- ========================= FND LOG ===========================
2282:

Line 2281: -- ========================= FND LOG ===========================

2277: l_exception_message);
2278: -- ========================= FND LOG ===========================
2279: psa_utils.debug_other_string(g_excep_level,l_full_path,l_exception_message);
2280: psa_utils.debug_unexpected_msg(l_full_path);
2281: -- ========================= FND LOG ===========================
2282:
2283: END include_manual_line;
2284:
2285: /**************************** IMPORTED_TRANSACTION *******************************************/

Line 2302: -- ========================= FND LOG ===========================

2298:
2299: l_inventory_item_profile NUMBER;
2300: l_imported_trx_rec c_imported_trx%ROWTYPE;
2301: l_index NUMBER := 1;
2302: -- ========================= FND LOG ===========================
2303: l_full_path VARCHAR2(100) := g_path || 'imported_transaction';
2304: -- ========================= FND LOG ===========================
2305:
2306: BEGIN

Line 2304: -- ========================= FND LOG ===========================

2300: l_imported_trx_rec c_imported_trx%ROWTYPE;
2301: l_index NUMBER := 1;
2302: -- ========================= FND LOG ===========================
2303: l_full_path VARCHAR2(100) := g_path || 'imported_transaction';
2304: -- ========================= FND LOG ===========================
2305:
2306: BEGIN
2307:
2308: -- ========================= FND LOG ===========================

Line 2308: -- ========================= FND LOG ===========================

2304: -- ========================= FND LOG ===========================
2305:
2306: BEGIN
2307:
2308: -- ========================= FND LOG ===========================
2309: psa_utils.debug_other_string(g_state_level,l_full_path,' Imported_transaction : START');
2310: -- ========================= FND LOG ===========================
2311:
2312: --

Line 2310: -- ========================= FND LOG ===========================

2306: BEGIN
2307:
2308: -- ========================= FND LOG ===========================
2309: psa_utils.debug_other_string(g_state_level,l_full_path,' Imported_transaction : START');
2310: -- ========================= FND LOG ===========================
2311:
2312: --
2313: -- Profile Option - TAX: Inventory Item for Freight
2314: --

Line 2318: -- ========================= FND LOG ===========================

2314: --
2315:
2316: OE_PROFILE.GET ('SO_INVENTORY_ITEM_FOR_FREIGHT', g_inventory_item_profile);
2317:
2318: -- ========================= FND LOG ===========================
2319: psa_utils.debug_other_string(g_state_level,l_full_path,' Imported_transaction : calling RESET_DISCOUNT_CACHE');
2320: -- ========================= FND LOG ===========================
2321:
2322: RESET_DISCOUNT_CACHE;

Line 2320: -- ========================= FND LOG ===========================

2316: OE_PROFILE.GET ('SO_INVENTORY_ITEM_FOR_FREIGHT', g_inventory_item_profile);
2317:
2318: -- ========================= FND LOG ===========================
2319: psa_utils.debug_other_string(g_state_level,l_full_path,' Imported_transaction : calling RESET_DISCOUNT_CACHE');
2320: -- ========================= FND LOG ===========================
2321:
2322: RESET_DISCOUNT_CACHE;
2323:
2324: OPEN c_imported_trx;

Line 2329: -- ========================= FND LOG ===========================

2325: LOOP
2326: FETCH c_imported_trx INTO l_imported_trx_rec;
2327: EXIT WHEN c_imported_trx%NOTFOUND;
2328:
2329: -- ========================= FND LOG ===========================
2330: psa_utils.debug_other_string(g_state_level,l_full_path,' Manual_transaction : customer_trx_line_id --> ' || l_imported_trx_rec.customer_trx_line_id);
2331: -- ========================= FND LOG ===========================
2332:
2333: TrxLinesTab(l_index) := l_imported_trx_rec.customer_trx_line_id;

Line 2331: -- ========================= FND LOG ===========================

2327: EXIT WHEN c_imported_trx%NOTFOUND;
2328:
2329: -- ========================= FND LOG ===========================
2330: psa_utils.debug_other_string(g_state_level,l_full_path,' Manual_transaction : customer_trx_line_id --> ' || l_imported_trx_rec.customer_trx_line_id);
2331: -- ========================= FND LOG ===========================
2332:
2333: TrxLinesTab(l_index) := l_imported_trx_rec.customer_trx_line_id;
2334: END LOOP;
2335: CLOSE c_imported_trx;

Line 2342: -- ========================= FND LOG ===========================

2338: WHEN OTHERS THEN
2339: l_exception_message := 'EXCEPTION - OTHERS PACKAGE - PSA_MFAR_RECEIPTS.IMPORTED_TRANSACTION: '|| sqlerrm;
2340: PSA_MFAR_UTILS.INSERT_DISTRIBUTIONS_LOG (g_run_id, 'RECEIPT', g_cust_trx_id, g_receivable_application_id,
2341: l_exception_message);
2342: -- ========================= FND LOG ===========================
2343: psa_utils.debug_other_string(g_excep_level,l_full_path,l_exception_message);
2344: psa_utils.debug_unexpected_msg(l_full_path);
2345: -- ========================= FND LOG ===========================
2346:

Line 2345: -- ========================= FND LOG ===========================

2341: l_exception_message);
2342: -- ========================= FND LOG ===========================
2343: psa_utils.debug_other_string(g_excep_level,l_full_path,l_exception_message);
2344: psa_utils.debug_unexpected_msg(l_full_path);
2345: -- ========================= FND LOG ===========================
2346:
2347: END imported_transaction;
2348:
2349: /**************************** INCLUDE_IMPORTED_TRANSACTION *******************************************/

Line 2370: -- ========================= FND LOG ===========================

2366: Where customer_trx_line_id = p_link_to_cust_trx_line_id;
2367:
2368: l_inventory_item_rec c_inventory_item%rowtype;
2369: l_tax_line_rec c_tax_line%rowtype;
2370: -- ========================= FND LOG ===========================
2371: l_full_path VARCHAR2(100) := g_path || 'include_imported_line';
2372: -- ========================= FND LOG ===========================
2373:
2374: BEGIN

Line 2372: -- ========================= FND LOG ===========================

2368: l_inventory_item_rec c_inventory_item%rowtype;
2369: l_tax_line_rec c_tax_line%rowtype;
2370: -- ========================= FND LOG ===========================
2371: l_full_path VARCHAR2(100) := g_path || 'include_imported_line';
2372: -- ========================= FND LOG ===========================
2373:
2374: BEGIN
2375:
2376: -- ========================= FND LOG ===========================

Line 2376: -- ========================= FND LOG ===========================

2372: -- ========================= FND LOG ===========================
2373:
2374: BEGIN
2375:
2376: -- ========================= FND LOG ===========================
2377: psa_utils.debug_other_string(g_state_level,l_full_path,' Include_imported_transaction : START');
2378: -- ========================= FND LOG ===========================
2379:
2380: IF p_discount_basis = 'F' THEN

Line 2378: -- ========================= FND LOG ===========================

2374: BEGIN
2375:
2376: -- ========================= FND LOG ===========================
2377: psa_utils.debug_other_string(g_state_level,l_full_path,' Include_imported_transaction : START');
2378: -- ========================= FND LOG ===========================
2379:
2380: IF p_discount_basis = 'F' THEN
2381: IF g_inventory_item_profile IS NOT NULL THEN
2382: IF p_line_type = 'LINE' THEN

Line 2437: -- ========================= FND LOG ===========================

2433: WHEN OTHERS THEN
2434: l_exception_message := 'EXCEPTION - OTHERS PACKAGE - PSA_MFAR_RECEIPTS.INCLUDE_IMPORTED_LINE: '|| sqlerrm;
2435: PSA_MFAR_UTILS.INSERT_DISTRIBUTIONS_LOG (g_run_id, 'RECEIPT', g_cust_trx_id, g_receivable_application_id,
2436: l_exception_message);
2437: -- ========================= FND LOG ===========================
2438: psa_utils.debug_other_string(g_excep_level,l_full_path,l_exception_message);
2439: psa_utils.debug_unexpected_msg(l_full_path);
2440: -- ========================= FND LOG ===========================
2441:

Line 2440: -- ========================= FND LOG ===========================

2436: l_exception_message);
2437: -- ========================= FND LOG ===========================
2438: psa_utils.debug_other_string(g_excep_level,l_full_path,l_exception_message);
2439: psa_utils.debug_unexpected_msg(l_full_path);
2440: -- ========================= FND LOG ===========================
2441:
2442: END include_imported_line;
2443:
2444: /******************************* LINE_IN_DISCOUNT_CACHE **************************/

Line 2447: -- ========================= FND LOG ===========================

2443:
2444: /******************************* LINE_IN_DISCOUNT_CACHE **************************/
2445:
2446: FUNCTION line_in_discount_cache (p_customer_trx_line_id IN NUMBER) RETURN BOOLEAN IS
2447: -- ========================= FND LOG ===========================
2448: l_full_path VARCHAR2(100) := g_path || 'line_in_discount_cache';
2449: -- ========================= FND LOG ===========================
2450: BEGIN
2451: -- ========================= FND LOG ===========================

Line 2449: -- ========================= FND LOG ===========================

2445:
2446: FUNCTION line_in_discount_cache (p_customer_trx_line_id IN NUMBER) RETURN BOOLEAN IS
2447: -- ========================= FND LOG ===========================
2448: l_full_path VARCHAR2(100) := g_path || 'line_in_discount_cache';
2449: -- ========================= FND LOG ===========================
2450: BEGIN
2451: -- ========================= FND LOG ===========================
2452: psa_utils.debug_other_string(g_state_level,l_full_path,' Line_in_discount_cache : START');
2453: -- ========================= FND LOG ===========================

Line 2451: -- ========================= FND LOG ===========================

2447: -- ========================= FND LOG ===========================
2448: l_full_path VARCHAR2(100) := g_path || 'line_in_discount_cache';
2449: -- ========================= FND LOG ===========================
2450: BEGIN
2451: -- ========================= FND LOG ===========================
2452: psa_utils.debug_other_string(g_state_level,l_full_path,' Line_in_discount_cache : START');
2453: -- ========================= FND LOG ===========================
2454: FOR i IN 1..TrxLinesTab.COUNT LOOP
2455: IF TrxLinesTab(i) = p_customer_trx_line_id THEN

Line 2453: -- ========================= FND LOG ===========================

2449: -- ========================= FND LOG ===========================
2450: BEGIN
2451: -- ========================= FND LOG ===========================
2452: psa_utils.debug_other_string(g_state_level,l_full_path,' Line_in_discount_cache : START');
2453: -- ========================= FND LOG ===========================
2454: FOR i IN 1..TrxLinesTab.COUNT LOOP
2455: IF TrxLinesTab(i) = p_customer_trx_line_id THEN
2456: RETURN TRUE;
2457: END IF;

Line 2465: -- ========================= FND LOG ===========================

2461: WHEN OTHERS THEN
2462: l_exception_message := 'EXCEPTION - OTHERS PACKAGE - PSA_MFAR_RECEIPTS.LINE_IN_DISCOUNT_CACHE: '|| sqlerrm;
2463: PSA_MFAR_UTILS.INSERT_DISTRIBUTIONS_LOG (g_run_id, 'RECEIPT', g_cust_trx_id, g_receivable_application_id,
2464: l_exception_message);
2465: -- ========================= FND LOG ===========================
2466: psa_utils.debug_other_string(g_excep_level,l_full_path,l_exception_message);
2467: psa_utils.debug_unexpected_msg(l_full_path);
2468: -- ========================= FND LOG ===========================
2469:

Line 2468: -- ========================= FND LOG ===========================

2464: l_exception_message);
2465: -- ========================= FND LOG ===========================
2466: psa_utils.debug_other_string(g_excep_level,l_full_path,l_exception_message);
2467: psa_utils.debug_unexpected_msg(l_full_path);
2468: -- ========================= FND LOG ===========================
2469:
2470: END line_in_discount_cache;
2471:
2472: /******************************* RESET_DISCOUNT_CACHE **************************/

Line 2475: -- ========================= FND LOG ===========================

2471:
2472: /******************************* RESET_DISCOUNT_CACHE **************************/
2473:
2474: PROCEDURE reset_discount_cache IS
2475: -- ========================= FND LOG ===========================
2476: l_full_path VARCHAR2(100) := g_path || 'reset_discount_cache';
2477: -- ========================= FND LOG ===========================
2478: BEGIN
2479: -- ========================= FND LOG ===========================

Line 2477: -- ========================= FND LOG ===========================

2473:
2474: PROCEDURE reset_discount_cache IS
2475: -- ========================= FND LOG ===========================
2476: l_full_path VARCHAR2(100) := g_path || 'reset_discount_cache';
2477: -- ========================= FND LOG ===========================
2478: BEGIN
2479: -- ========================= FND LOG ===========================
2480: psa_utils.debug_other_string(g_state_level,l_full_path,' Reset_discount_cache : START');
2481: -- ========================= FND LOG ===========================

Line 2479: -- ========================= FND LOG ===========================

2475: -- ========================= FND LOG ===========================
2476: l_full_path VARCHAR2(100) := g_path || 'reset_discount_cache';
2477: -- ========================= FND LOG ===========================
2478: BEGIN
2479: -- ========================= FND LOG ===========================
2480: psa_utils.debug_other_string(g_state_level,l_full_path,' Reset_discount_cache : START');
2481: -- ========================= FND LOG ===========================
2482:
2483: FOR i IN 1..TrxLinesTab.COUNT LOOP

Line 2481: -- ========================= FND LOG ===========================

2477: -- ========================= FND LOG ===========================
2478: BEGIN
2479: -- ========================= FND LOG ===========================
2480: psa_utils.debug_other_string(g_state_level,l_full_path,' Reset_discount_cache : START');
2481: -- ========================= FND LOG ===========================
2482:
2483: FOR i IN 1..TrxLinesTab.COUNT LOOP
2484: TrxLinesTab.DELETE(i);
2485: END LOOP;

Line 2492: -- ========================= FND LOG ===========================

2488: WHEN OTHERS THEN
2489: l_exception_message := 'EXCEPTION - OTHERS PACKAGE - PSA_MFAR_RECEIPTS.RESET_DISCOUNT_CACHE: '|| sqlerrm;
2490: PSA_MFAR_UTILS.INSERT_DISTRIBUTIONS_LOG (g_run_id, 'RECEIPT', g_cust_trx_id, g_receivable_application_id,
2491: l_exception_message);
2492: -- ========================= FND LOG ===========================
2493: psa_utils.debug_other_string(g_excep_level,l_full_path,l_exception_message);
2494: psa_utils.debug_unexpected_msg(l_full_path);
2495: -- ========================= FND LOG ===========================
2496:

Line 2495: -- ========================= FND LOG ===========================

2491: l_exception_message);
2492: -- ========================= FND LOG ===========================
2493: psa_utils.debug_other_string(g_excep_level,l_full_path,l_exception_message);
2494: psa_utils.debug_unexpected_msg(l_full_path);
2495: -- ========================= FND LOG ===========================
2496:
2497: END reset_discount_cache;
2498:
2499: