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 PSA_UTILS

Line 190: psa_utils.debug_other_string(g_state_level,l_full_path,' ');

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 :');
194: psa_utils.debug_other_string(g_state_level,l_full_path,' ============');

Line 191: psa_utils.debug_other_string(g_state_level,l_full_path,' Starting create_distributions');

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 :');
194: psa_utils.debug_other_string(g_state_level,l_full_path,' ============');
195: psa_utils.debug_other_string(g_state_level,l_full_path,' p_receivable_app_id -->' || p_receivable_app_id);

Line 192: psa_utils.debug_other_string(g_state_level,l_full_path,' ');

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 :');
194: psa_utils.debug_other_string(g_state_level,l_full_path,' ============');
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);

Line 193: psa_utils.debug_other_string(g_state_level,l_full_path,' PARAMETERS :');

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 :');
194: psa_utils.debug_other_string(g_state_level,l_full_path,' ============');
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);

Line 194: psa_utils.debug_other_string(g_state_level,l_full_path,' ============');

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 :');
194: psa_utils.debug_other_string(g_state_level,l_full_path,' ============');
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 ');

Line 195: psa_utils.debug_other_string(g_state_level,l_full_path,' p_receivable_app_id -->' || p_receivable_app_id);

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 :');
194: psa_utils.debug_other_string(g_state_level,l_full_path,' ============');
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 ===========================

Line 196: psa_utils.debug_other_string(g_state_level,l_full_path,' p_set_of_books_id -->' || p_set_of_books_id);

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 :');
194: psa_utils.debug_other_string(g_state_level,l_full_path,' ============');
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:

Line 197: psa_utils.debug_other_string(g_state_level,l_full_path,' p_run_id -->' || p_run_id);

193: psa_utils.debug_other_string(g_state_level,l_full_path,' PARAMETERS :');
194: psa_utils.debug_other_string(g_state_level,l_full_path,' ============');
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: --

Line 198: psa_utils.debug_other_string(g_state_level,l_full_path,' Starting the process ');

194: psa_utils.debug_other_string(g_state_level,l_full_path,' ============');
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

Line 223: psa_utils.debug_other_string(g_state_level,l_full_path,' Setting retcode to --> ' || retcode);

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;
227: g_receivable_application_id := p_receivable_app_id;

Line 251: psa_utils.debug_other_string(g_state_level,l_full_path,' Calling distributions_exist_and_valid ');

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
255:

Line 257: psa_utils.debug_other_string(g_state_level,l_full_path,' Inside first if ' );

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:
261: -- Initialize global variable

Line 258: psa_utils.debug_other_string(g_state_level,l_full_path,' distributions_exist_and_valid -> TRUE ');

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:
261: -- Initialize global variable
262: g_cust_trx_id := l_rcpt_application_rec.cust_trx_id;

Line 265: psa_utils.debug_other_string(g_state_level,l_full_path,' g_cust_trx_id -> ' || g_cust_trx_id );

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:
269: IF l_rcpt_application_rec.cash_receipt_id IS NULL THEN -- CREDIT MEMO APPLICATION

Line 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 );

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:
269: IF l_rcpt_application_rec.cash_receipt_id IS NULL THEN -- CREDIT MEMO APPLICATION
270: -- ========================= FND LOG ===========================

Line 271: psa_utils.debug_other_string(g_state_level,l_full_path,' Inside Second if');

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;
275: -- ========================= FND LOG ===========================

Line 276: psa_utils.debug_other_string(g_state_level,l_full_path,' l_ccid --> ' || l_ccid);

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);
280: FETCH c_credit_memo_type INTO l_credit_memo_type;

Line 284: psa_utils.debug_other_string(g_state_level,l_full_path,' Credit memo type --> ' || l_credit_memo_type.previous_customer_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
288:

Line 290: psa_utils.debug_other_string(g_state_level,l_full_path,' Inside third if');

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:
294: OPEN c_direct_cm (l_rcpt_application_rec.cm_trx_id);

Line 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);

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:
294: OPEN c_direct_cm (l_rcpt_application_rec.cm_trx_id);
295: LOOP

Line 301: psa_utils.debug_other_string(g_state_level,l_full_path,' l_direct_cm.trx_line_id --> ' || l_direct_cm.trx_line_id);

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,
305: l_direct_cm.trx_line_id);

Line 310: psa_utils.debug_other_string(g_state_level,l_full_path,' l_direct_cm_line_amount --> ' ||l_direct_cm_line_amount.line_amount);

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:
314: IF NOT (GENERATE_RCT_DIST_CM

Line 311: psa_utils.debug_other_string(g_state_level,l_full_path,' Calling GENERATE_RCT_DIST ');

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:
314: IF NOT (GENERATE_RCT_DIST_CM
315: (errbuf => errbuf,

Line 333: psa_utils.debug_other_string(g_state_level,l_full_path,' Generate_rct_dist --> FALSE ');

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;
337: ELSE

Line 334: psa_utils.debug_other_string(g_state_level,l_full_path,' Raising generate_rct_dist_excep');

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;
337: ELSE
338: -- ========================= FND LOG ===========================

Line 339: psa_utils.debug_other_string(g_state_level,l_full_path,' Generate_rct_dist --> TRUE ');

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;
343:

Line 345: psa_utils.debug_other_string(g_state_level,l_full_path,' out of c_direct_cm loop');

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:
349: ELSE -- On Account Credit Memo

Line 352: psa_utils.debug_other_string(g_state_level,l_full_path,' Inside third else');

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 ===========================
356:

Line 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);

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 ===========================
356:
357: -- Bug 3107904 amount_applied*-1 for parameter : p_amount_applied of GENERATE_RCT_DIST

Line 354: psa_utils.debug_other_string(g_state_level,l_full_path,' Calling GENERATE_RCT_DIST ');

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 ===========================
356:
357: -- Bug 3107904 amount_applied*-1 for parameter : p_amount_applied of GENERATE_RCT_DIST
358:

Line 376: psa_utils.debug_other_string(g_state_level,l_full_path,' Generate_rct_dist --> FALSE ');

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;
380: ELSE

Line 377: psa_utils.debug_other_string(g_state_level,l_full_path,' Raising generate_rct_dist_excep');

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;
380: ELSE
381: -- ========================= FND LOG ===========================

Line 382: psa_utils.debug_other_string(g_state_level,l_full_path,' Generate_rct_dist --> TRUE ');

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:
386: END IF; -- Direct Credit Memo end if

Line 390: psa_utils.debug_other_string(g_state_level,l_full_path,' Inside second else ');

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
394:

Line 391: psa_utils.debug_other_string(g_state_level,l_full_path,' l_rcpt_application_rec.cash_receipt_id IS NULL');

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
394:
395: ELSE

Line 397: psa_utils.debug_other_string(g_state_level,l_full_path,' Inside first else ');

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
401:

Line 398: psa_utils.debug_other_string(g_state_level,l_full_path,' distributions_exist_and_valid -> FALSE ');

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
401:
402:

Line 404: psa_utils.debug_other_string(g_state_level,l_full_path,' Cash receipt - Cash Management ');

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 ##
408: IF (l_rcpt_application_rec.cash_receipt_id IS NOT NULL) THEN -- 2 if

Line 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);

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;
418: EXIT WHEN c_crh%NOTFOUND;

Line 421: psa_utils.debug_other_string(g_state_level,l_full_path,' Calling CASH_CLR_DIST_EXIST_VALID ');

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
425: IF (CASH_CLR_DIST_EXIST_VALID ( p_receivable_app_id,

Line 431: psa_utils.debug_other_string(g_state_level,l_full_path,' CASH_CLR_DIST_EXIST_VALID -> TRUE');

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);
435: FETCH c_cash_ccid INTO l_cash_ccid;

Line 440: psa_utils.debug_other_string(g_state_level,l_full_path,' cash_ccid - l_ccid -> ' || l_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
444:

Line 446: psa_utils.debug_other_string(g_state_level,l_full_path,' Inside if - l_ccid is not null');

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:
450: IF NOT (GENERATE_RCT_DIST

Line 447: psa_utils.debug_other_string(g_state_level,l_full_path,' Calling generate_rct_dist ');

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:
450: IF NOT (GENERATE_RCT_DIST
451: (errbuf => errbuf,

Line 467: psa_utils.debug_other_string(g_state_level,l_full_path,' Generate_rct_dist --> FALSE ');

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;
471: ELSE

Line 468: psa_utils.debug_other_string(g_state_level,l_full_path,' Raising generate_rct_dist_excep');

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;
471: ELSE
472: -- ========================= FND LOG ===========================

Line 473: psa_utils.debug_other_string(g_state_level,l_full_path,' Generate_rct_dist --> TRUE ');

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
477: -- ========================= FND LOG ===========================

Line 478: psa_utils.debug_other_string(g_state_level,l_full_path,' Inside else - l_ccid is NULL');

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:
482: ELSE

Line 484: psa_utils.debug_other_string(g_state_level,l_full_path,' CASH_CLR_DIST_EXIST_VALID -> FALSE ');

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;
488: CLOSE c_crh;

Line 492: psa_utils.debug_other_string(g_state_level,l_full_path,' Cash_receipt_id -> l_rcpt_application_rec.cash_receipt_id is null');

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:
496: -- ========================= FND LOG ===========================

Line 497: psa_utils.debug_other_string(g_state_level,l_full_path,' retcode --> ' || retcode);

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:
501: retcode := 'S';

Line 498: psa_utils.debug_other_string(g_state_level,l_full_path,' RETURN TRUE ');

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:
501: retcode := 'S';
502: RETURN TRUE;

Line 510: psa_utils.debug_other_string(g_excep_level,l_full_path,p_error_message);

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:
514: WHEN OTHERS THEN

Line 520: psa_utils.debug_other_string(g_excep_level,l_full_path,p_error_message);

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;
524:

Line 521: psa_utils.debug_unexpected_msg(l_full_path);

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;
524:
525: END create_distributions;

Line 538: psa_utils.debug_other_string(g_state_level,l_full_path,' Distributions_exist_and_valid --> START');

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)
542: INTO l_rct_dist_count

Line 547: psa_utils.debug_other_string(g_state_level,l_full_path,' Distributions_exist_and_valid -> l_rct_dist_count ' || 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
551: -- ========================= FND LOG ===========================

Line 552: psa_utils.debug_other_string(g_state_level,l_full_path,' Distributions_exist_and_valid --> RETURN TRUE');

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
556: -- ========================= FND LOG ===========================

Line 557: psa_utils.debug_other_string(g_state_level,l_full_path,' Distributions_exist_and_valid --> RETURN FALSE');

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;
561:

Line 565: psa_utils.debug_other_string(g_excep_level,l_full_path,' Distributions_exist_and_valid -> EXCEPTION WHEN OTHERS ' || SQLERRM );

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;
569:

Line 566: psa_utils.debug_unexpected_msg(l_full_path);

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;
569:
570: END distributions_exist_and_valid;

Line 590: psa_utils.debug_other_string(g_state_level,l_full_path,' Cash_clr_dist_exist_valid -> START');

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)
594: INTO l_rct_dist_count

Line 599: psa_utils.debug_other_string(g_state_level,l_full_path,' p_amount -> ' || p_amount );

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 ===========================
603:

Line 600: psa_utils.debug_other_string(g_state_level,l_full_path,' p_crh_status -> ' || p_crh_status );

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 ===========================
603:
604: IF (p_amount < 0) AND (p_crh_status IN ('REMITTED','CLEARED')) THEN

Line 601: psa_utils.debug_other_string(g_state_level,l_full_path,' l_rct_dist_count -> ' || l_rct_dist_count);

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 ===========================
603:
604: IF (p_amount < 0) AND (p_crh_status IN ('REMITTED','CLEARED')) THEN
605: -- ========================= FND LOG ===========================

Line 606: psa_utils.debug_other_string(g_state_level,l_full_path,' Inside first if ');

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 ===========================
610: psa_utils.debug_other_string(g_state_level,l_full_path,' RETURN FALSE ');

Line 610: psa_utils.debug_other_string(g_state_level,l_full_path,' RETURN FALSE ');

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
614: -- ========================= FND LOG ===========================

Line 615: psa_utils.debug_other_string(g_state_level,l_full_path,' RETURN TRUE ');

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;
619: END IF;

Line 623: psa_utils.debug_other_string(g_state_level,l_full_path,' Inside second 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 ===========================
627: psa_utils.debug_other_string(g_state_level,l_full_path,' RETURN FALSE ');

Line 627: psa_utils.debug_other_string(g_state_level,l_full_path,' RETURN FALSE ');

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
631: -- ========================= FND LOG ===========================

Line 632: psa_utils.debug_other_string(g_state_level,l_full_path,' RETURN TRUE ');

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;
636: END IF;

Line 640: psa_utils.debug_other_string(g_state_level,l_full_path,' Inside third 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;
644: ELSE

Line 641: psa_utils.debug_other_string(g_state_level,l_full_path,' RETURN FALSE');

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;
644: ELSE
645: -- ========================= FND LOG ===========================

Line 646: psa_utils.debug_other_string(g_state_level,l_full_path,' Inside third else ');

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;
650: END IF;

Line 647: psa_utils.debug_other_string(g_state_level,l_full_path,' RETURN TRUE');

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;
650: END IF;
651:

Line 655: psa_utils.debug_other_string(g_state_level,l_full_path,' Cash_clr_dist_exist_valid -> EXCEPTION WHEN OTHERS ' || SQLERRM);

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;
659:

Line 656: psa_utils.debug_unexpected_msg(l_full_path);

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;
659:
660: END cash_clr_dist_exist_valid;

Line 793: psa_utils.debug_other_string(g_state_level,l_full_path,' Start Generate_rct_dist ');

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);
797: psa_utils.debug_other_string(g_state_level,l_full_path,' p_cash_ccid -> ' || p_cash_ccid);

Line 794: psa_utils.debug_other_string(g_state_level,l_full_path,' PARAMETERS');

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);
797: psa_utils.debug_other_string(g_state_level,l_full_path,' p_cash_ccid -> ' || p_cash_ccid);
798: psa_utils.debug_other_string(g_state_level,l_full_path,' p_cust_trx_id -> ' || p_cust_trx_id);

Line 795: psa_utils.debug_other_string(g_state_level,l_full_path,' ==========');

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);
797: psa_utils.debug_other_string(g_state_level,l_full_path,' p_cash_ccid -> ' || p_cash_ccid);
798: psa_utils.debug_other_string(g_state_level,l_full_path,' p_cust_trx_id -> ' || p_cust_trx_id);
799: psa_utils.debug_other_string(g_state_level,l_full_path,' p_cust_trx_line_id -> ' || p_cust_trx_line_id);

Line 796: psa_utils.debug_other_string(g_state_level,l_full_path,' p_rcv_app_id -> ' || p_rcv_app_id);

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);
797: psa_utils.debug_other_string(g_state_level,l_full_path,' p_cash_ccid -> ' || p_cash_ccid);
798: psa_utils.debug_other_string(g_state_level,l_full_path,' p_cust_trx_id -> ' || p_cust_trx_id);
799: psa_utils.debug_other_string(g_state_level,l_full_path,' p_cust_trx_line_id -> ' || p_cust_trx_line_id);
800: psa_utils.debug_other_string(g_state_level,l_full_path,' p_amount_applied -> ' || p_amount_applied);

Line 797: psa_utils.debug_other_string(g_state_level,l_full_path,' p_cash_ccid -> ' || p_cash_ccid);

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);
797: psa_utils.debug_other_string(g_state_level,l_full_path,' p_cash_ccid -> ' || p_cash_ccid);
798: psa_utils.debug_other_string(g_state_level,l_full_path,' p_cust_trx_id -> ' || p_cust_trx_id);
799: psa_utils.debug_other_string(g_state_level,l_full_path,' p_cust_trx_line_id -> ' || p_cust_trx_line_id);
800: psa_utils.debug_other_string(g_state_level,l_full_path,' p_amount_applied -> ' || p_amount_applied);
801: psa_utils.debug_other_string(g_state_level,l_full_path,' p_earned_discount -> ' || p_earned_discount);

Line 798: psa_utils.debug_other_string(g_state_level,l_full_path,' p_cust_trx_id -> ' || p_cust_trx_id);

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);
797: psa_utils.debug_other_string(g_state_level,l_full_path,' p_cash_ccid -> ' || p_cash_ccid);
798: psa_utils.debug_other_string(g_state_level,l_full_path,' p_cust_trx_id -> ' || p_cust_trx_id);
799: psa_utils.debug_other_string(g_state_level,l_full_path,' p_cust_trx_line_id -> ' || p_cust_trx_line_id);
800: psa_utils.debug_other_string(g_state_level,l_full_path,' p_amount_applied -> ' || p_amount_applied);
801: psa_utils.debug_other_string(g_state_level,l_full_path,' p_earned_discount -> ' || p_earned_discount);
802: psa_utils.debug_other_string(g_state_level,l_full_path,' p_unearned_discount -> ' || p_unearned_discount);

Line 799: psa_utils.debug_other_string(g_state_level,l_full_path,' p_cust_trx_line_id -> ' || p_cust_trx_line_id);

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);
797: psa_utils.debug_other_string(g_state_level,l_full_path,' p_cash_ccid -> ' || p_cash_ccid);
798: psa_utils.debug_other_string(g_state_level,l_full_path,' p_cust_trx_id -> ' || p_cust_trx_id);
799: psa_utils.debug_other_string(g_state_level,l_full_path,' p_cust_trx_line_id -> ' || p_cust_trx_line_id);
800: psa_utils.debug_other_string(g_state_level,l_full_path,' p_amount_applied -> ' || p_amount_applied);
801: psa_utils.debug_other_string(g_state_level,l_full_path,' p_earned_discount -> ' || p_earned_discount);
802: psa_utils.debug_other_string(g_state_level,l_full_path,' p_unearned_discount -> ' || p_unearned_discount);
803: psa_utils.debug_other_string(g_state_level,l_full_path,' p_earned_discount_ccid -> ' || p_earned_discount_ccid);

Line 800: psa_utils.debug_other_string(g_state_level,l_full_path,' p_amount_applied -> ' || p_amount_applied);

796: psa_utils.debug_other_string(g_state_level,l_full_path,' p_rcv_app_id -> ' || p_rcv_app_id);
797: psa_utils.debug_other_string(g_state_level,l_full_path,' p_cash_ccid -> ' || p_cash_ccid);
798: psa_utils.debug_other_string(g_state_level,l_full_path,' p_cust_trx_id -> ' || p_cust_trx_id);
799: psa_utils.debug_other_string(g_state_level,l_full_path,' p_cust_trx_line_id -> ' || p_cust_trx_line_id);
800: psa_utils.debug_other_string(g_state_level,l_full_path,' p_amount_applied -> ' || p_amount_applied);
801: psa_utils.debug_other_string(g_state_level,l_full_path,' p_earned_discount -> ' || p_earned_discount);
802: psa_utils.debug_other_string(g_state_level,l_full_path,' p_unearned_discount -> ' || p_unearned_discount);
803: psa_utils.debug_other_string(g_state_level,l_full_path,' p_earned_discount_ccid -> ' || p_earned_discount_ccid);
804: psa_utils.debug_other_string(g_state_level,l_full_path,' p_unearned_discount_ccid -> ' || p_unearned_discount_ccid);

Line 801: psa_utils.debug_other_string(g_state_level,l_full_path,' p_earned_discount -> ' || p_earned_discount);

797: psa_utils.debug_other_string(g_state_level,l_full_path,' p_cash_ccid -> ' || p_cash_ccid);
798: psa_utils.debug_other_string(g_state_level,l_full_path,' p_cust_trx_id -> ' || p_cust_trx_id);
799: psa_utils.debug_other_string(g_state_level,l_full_path,' p_cust_trx_line_id -> ' || p_cust_trx_line_id);
800: psa_utils.debug_other_string(g_state_level,l_full_path,' p_amount_applied -> ' || p_amount_applied);
801: psa_utils.debug_other_string(g_state_level,l_full_path,' p_earned_discount -> ' || p_earned_discount);
802: psa_utils.debug_other_string(g_state_level,l_full_path,' p_unearned_discount -> ' || p_unearned_discount);
803: psa_utils.debug_other_string(g_state_level,l_full_path,' p_earned_discount_ccid -> ' || p_earned_discount_ccid);
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);

Line 802: psa_utils.debug_other_string(g_state_level,l_full_path,' p_unearned_discount -> ' || p_unearned_discount);

798: psa_utils.debug_other_string(g_state_level,l_full_path,' p_cust_trx_id -> ' || p_cust_trx_id);
799: psa_utils.debug_other_string(g_state_level,l_full_path,' p_cust_trx_line_id -> ' || p_cust_trx_line_id);
800: psa_utils.debug_other_string(g_state_level,l_full_path,' p_amount_applied -> ' || p_amount_applied);
801: psa_utils.debug_other_string(g_state_level,l_full_path,' p_earned_discount -> ' || p_earned_discount);
802: psa_utils.debug_other_string(g_state_level,l_full_path,' p_unearned_discount -> ' || p_unearned_discount);
803: psa_utils.debug_other_string(g_state_level,l_full_path,' p_earned_discount_ccid -> ' || p_earned_discount_ccid);
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);

Line 803: psa_utils.debug_other_string(g_state_level,l_full_path,' p_earned_discount_ccid -> ' || p_earned_discount_ccid);

799: psa_utils.debug_other_string(g_state_level,l_full_path,' p_cust_trx_line_id -> ' || p_cust_trx_line_id);
800: psa_utils.debug_other_string(g_state_level,l_full_path,' p_amount_applied -> ' || p_amount_applied);
801: psa_utils.debug_other_string(g_state_level,l_full_path,' p_earned_discount -> ' || p_earned_discount);
802: psa_utils.debug_other_string(g_state_level,l_full_path,' p_unearned_discount -> ' || p_unearned_discount);
803: psa_utils.debug_other_string(g_state_level,l_full_path,' p_earned_discount_ccid -> ' || p_earned_discount_ccid);
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 ');

Line 804: psa_utils.debug_other_string(g_state_level,l_full_path,' p_unearned_discount_ccid -> ' || p_unearned_discount_ccid);

800: psa_utils.debug_other_string(g_state_level,l_full_path,' p_amount_applied -> ' || p_amount_applied);
801: psa_utils.debug_other_string(g_state_level,l_full_path,' p_earned_discount -> ' || p_earned_discount);
802: psa_utils.debug_other_string(g_state_level,l_full_path,' p_unearned_discount -> ' || p_unearned_discount);
803: psa_utils.debug_other_string(g_state_level,l_full_path,' p_earned_discount_ccid -> ' || p_earned_discount_ccid);
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 ===========================

Line 805: psa_utils.debug_other_string(g_state_level,l_full_path,' p_document_type -> ' || p_document_type);

801: psa_utils.debug_other_string(g_state_level,l_full_path,' p_earned_discount -> ' || p_earned_discount);
802: psa_utils.debug_other_string(g_state_level,l_full_path,' p_unearned_discount -> ' || p_unearned_discount);
803: psa_utils.debug_other_string(g_state_level,l_full_path,' p_earned_discount_ccid -> ' || p_earned_discount_ccid);
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:

Line 806: psa_utils.debug_other_string(g_state_level,l_full_path,' p_crh_status -> ' || p_crh_status);

802: psa_utils.debug_other_string(g_state_level,l_full_path,' p_unearned_discount -> ' || p_unearned_discount);
803: psa_utils.debug_other_string(g_state_level,l_full_path,' p_earned_discount_ccid -> ' || p_earned_discount_ccid);
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

Line 807: psa_utils.debug_other_string(g_state_level,l_full_path,' Starting the process ');

803: psa_utils.debug_other_string(g_state_level,l_full_path,' p_earned_discount_ccid -> ' || p_earned_discount_ccid);
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

Line 823: psa_utils.debug_other_string(g_state_level,l_full_path,' Creating distribution for Cust trx id ==> ' || run_num || ' -- ' || p_cust_trx_id);

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 (
827: errbuf => l_errbuf,

Line 835: psa_utils.debug_other_string(g_state_level,l_full_path,' PSA_MFAR_TRANSACTIONS.create_distributions --> FALSE');

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 ===========================
839: psa_utils.debug_other_string(g_state_level,l_full_path,' Raising invalid_distribution');

Line 839: psa_utils.debug_other_string(g_state_level,l_full_path,' Raising invalid_distribution');

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;
843: ELSE

Line 845: psa_utils.debug_other_string(g_state_level,l_full_path,' cust_trx_id --> ' || p_cust_trx_id);

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:
849: -- ========================= FND LOG ===========================

Line 850: psa_utils.debug_other_string(g_state_level,l_full_path,' p_earned_discount --> ' || p_earned_discount );

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:
854: IF (p_earned_discount <> 0 OR p_unearned_discount <> 0) THEN

Line 851: psa_utils.debug_other_string(g_state_level,l_full_path,' p_unearned_discount --> ' || p_unearned_discount );

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:
854: IF (p_earned_discount <> 0 OR p_unearned_discount <> 0) THEN
855: -- ========================= FND LOG ===========================

Line 856: psa_utils.debug_other_string(g_state_level,l_full_path,' Calling populate_discount_cache --> ' || p_cust_trx_id);

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;
860:

Line 881: psa_utils.debug_other_string(g_state_level,l_full_path,

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 ===========================
885:

Line 907: psa_utils.debug_other_string(g_state_level,l_full_path,' l_total_amount_due --> ' || l_total_amount_due );

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:
911:

Line 908: psa_utils.debug_other_string(g_state_level,l_full_path,' sum_amt_due_rem --> ' || sum_amt_due_rem );

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:
911:
912: --

Line 927: psa_utils.debug_other_string(g_state_level,l_full_path,' l_running_total_amount_due --> ' || l_running_total_amount_due );

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 ===========================
931:

Line 928: psa_utils.debug_other_string(g_state_level,l_full_path,' l_running_total_amount_earn --> ' || l_running_total_amount_earn);

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 ===========================
931:
932: l_c_accrual_stmt :=

Line 929: psa_utils.debug_other_string(g_state_level,l_full_path,' l_running_total_amount_unearn --> ' || l_running_total_amount_unearn);

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 ===========================
931:
932: l_c_accrual_stmt :=
933: 'Select mf_trx_dist.mf_receivables_ccid rcv_ccid, ' ||

Line 982: psa_utils.debug_other_string(g_state_level,l_full_path,' arp_global.sysparam.accounting_method --> '

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:
986: IF arp_global.sysparam.accounting_method = 'ACCRUAL' THEN

Line 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 );

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: --
1002: -- If Remittance MFAR distributions have already been created

Line 1012: psa_utils.debug_other_string(g_state_level,l_full_path,' l_remit_reversal_ccid --> ' || l_remit_reversal_ccid);

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:
1016: -- ========================= FND LOG ===========================

Line 1017: psa_utils.debug_other_string(g_state_level,l_full_path,' p_document_type --> ' || p_document_type );

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
1021: p_ccid := l_accrual_rec.rcv_ccid;

Line 1023: psa_utils.debug_other_string(g_state_level,l_full_path,' if cond - document type is CM --> ' || p_ccid);

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 ===========================
1027: psa_utils.debug_other_string(g_state_level,l_full_path,' else cond - calling PSA_MFAR_UTILS.OVERRIDE_SEGMENTS ');

Line 1027: psa_utils.debug_other_string(g_state_level,l_full_path,' else cond - calling PSA_MFAR_UTILS.OVERRIDE_SEGMENTS ');

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,
1031: P_OVERRIDE_CCID => l_accrual_rec.rcv_ccid,

Line 1037: psa_utils.debug_other_string(g_state_level,l_full_path,' PSA_MFAR_UTILS.OVERRIDE_SEGMENTS -> FALSE ');

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
1041: -- ========================= FND LOG ===========================

Line 1042: psa_utils.debug_other_string(g_state_level,l_full_path,' p_ccid -> ' || p_ccid);

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;
1046:

Line 1053: psa_utils.debug_other_string(g_state_level,l_full_path,' p_cust_trx_line_id Is NOT NULL');

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)
1057: AND NOT (l_running_total_amount_due = 0) THEN -- to avoid divide by zero error

Line 1072: psa_utils.debug_other_string(g_state_level,l_full_path,' IF part ' ||

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 ||
1076: ' ##l_running_amount --> ' || l_running_amount ||

Line 1085: psa_utils.debug_other_string(g_state_level,l_full_path,' ##l_amount --> ' || l_amount || ' ##l_percent --> ' || l_percent);

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
1089: -- ========================= FND LOG ===========================

Line 1090: psa_utils.debug_other_string(g_state_level,l_full_path,' p_cust_trx_line_id Is NULL');

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
1094:

Line 1108: psa_utils.debug_other_string(g_state_level,l_full_path,' ELSE part ' ||

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 ||
1112: ' ##l_running_amount --> ' || l_running_amount ||

Line 1127: psa_utils.debug_other_string(g_state_level,l_full_path,' calling LINE_IN_DISCOUNT_CACHE --> ' || l_accrual_rec.trx_line_id);

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:
1131: --

Line 1128: psa_utils.debug_other_string(g_state_level,l_full_path,' prorate earned discount ');

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:
1131: --
1132: -- Prorate Earned Discount

Line 1144: psa_utils.debug_other_string(g_state_level,l_full_path,' IF part ' ||

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 ||
1148: ' ##l_running_total_amount_earn --> ' || l_running_total_amount_earn);

Line 1154: psa_utils.debug_other_string(g_state_level,l_full_path,

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;
1158:

Line 1164: psa_utils.debug_other_string(g_state_level,l_full_path,' prorate unearned discount ');

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
1168: AND NOT (l_running_total_amount_unearn = 0) THEN -- to avoid divide by zero error

Line 1176: psa_utils.debug_other_string(g_state_level,l_full_path,' IF part ' ||

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 ||
1180: ' ##l_running_total_amount_earn --> ' || l_running_total_amount_earn);

Line 1185: psa_utils.debug_other_string(g_state_level,l_full_path,' ELSE part ##l_unearned_discount --> ' || l_unearned_discount);

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;
1189:

Line 1192: psa_utils.debug_other_string(g_state_level,l_full_path,

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,
1196: ' ##p_unearned_discount_ccid --> ' || p_unearned_discount_ccid ||

Line 1194: psa_utils.debug_other_string(g_state_level,l_full_path,' p_earned_discount_ccid IS NOT NULL ');

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,
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 ||

Line 1195: psa_utils.debug_other_string(g_state_level,l_full_path,

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,
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);

Line 1208: psa_utils.debug_other_string(g_state_level,l_full_path,' PSA_MFAR_UTILS.OVERRIDE_SEGMENTS -> FALSE');

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;
1212: ELSE

Line 1214: psa_utils.debug_other_string(g_state_level,l_full_path,' p_earned_discount_ccid IS NULL ');

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:
1218: IF p_unearned_discount_ccid IS NOT NULL THEN

Line 1220: psa_utils.debug_other_string(g_state_level,l_full_path,

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 ');
1224: psa_utils.debug_other_string(g_state_level,l_full_path,

Line 1222: psa_utils.debug_other_string(g_state_level,l_full_path,

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 ');
1224: psa_utils.debug_other_string(g_state_level,l_full_path,
1225: ' ##p_unearned_discount_ccid --> ' || p_unearned_discount_ccid ||
1226: ' ##rcv_ccid --> ' || l_accrual_rec.rcv_ccid ||

Line 1224: psa_utils.debug_other_string(g_state_level,l_full_path,

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 ');
1224: psa_utils.debug_other_string(g_state_level,l_full_path,
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);

Line 1238: psa_utils.debug_other_string(g_state_level,l_full_path,' PSA_MFAR_UTILS.OVERRIDE_SEGMENTS -> FALSE ');

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;
1242: ELSE

Line 1239: psa_utils.debug_other_string(g_state_level,l_full_path,' Raising flex_build_error ');

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;
1242: ELSE
1243: -- ========================= FND LOG ===========================

Line 1244: psa_utils.debug_other_string(g_state_level,l_full_path,

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;
1248: END IF;

Line 1253: psa_utils.debug_other_string(g_state_level,l_full_path,' calling PSA_MFAR_RECEIPTS_COVER_PKG.INSERT_ROW');

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: --
1257: -- Insert into psa_mf_rct_dist_all

Line 1303: psa_utils.debug_other_string(g_state_level,l_full_path,' retcode --> ' || retcode );

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:
1307: retcode := 'S';

Line 1304: psa_utils.debug_other_string(g_state_level,l_full_path,' RETURN TRUE ');

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:
1307: retcode := 'S';
1308: RETURN TRUE;

Line 1315: psa_utils.debug_other_string(g_excep_level,l_full_path,

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);
1319: -- ========================= FND LOG ===========================

Line 1317: psa_utils.debug_other_string(g_excep_level,l_full_path,

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);
1319: -- ========================= FND LOG ===========================
1320: p_error_message := l_exception_message;
1321: retcode := 'F';

Line 1327: psa_utils.debug_other_string(g_excep_level,l_full_path,

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);
1331: -- ========================= FND LOG ===========================

Line 1329: psa_utils.debug_other_string(g_excep_level,l_full_path,

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);
1331: -- ========================= FND LOG ===========================
1332: p_error_message := l_exception_message;
1333: retcode := 'F';

Line 1339: psa_utils.debug_other_string(g_excep_level,l_full_path,

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);
1343: psa_utils.debug_unexpected_msg(l_full_path);

Line 1341: psa_utils.debug_other_string(g_excep_level,l_full_path,

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);
1343: psa_utils.debug_unexpected_msg(l_full_path);
1344: -- ========================= FND LOG ===========================
1345: p_error_message := l_exception_message;

Line 1343: psa_utils.debug_unexpected_msg(l_full_path);

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);
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;

Line 1447: psa_utils.debug_other_string(g_state_level,l_full_path,' Start Generate_rct_dist_cm ');

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);
1451: psa_utils.debug_other_string(g_state_level,l_full_path,' p_cash_ccid -> ' || p_cash_ccid);

Line 1448: psa_utils.debug_other_string(g_state_level,l_full_path,' PARAMETERS');

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);
1451: psa_utils.debug_other_string(g_state_level,l_full_path,' p_cash_ccid -> ' || p_cash_ccid);
1452: psa_utils.debug_other_string(g_state_level,l_full_path,' p_cust_trx_id -> ' || p_cust_trx_id);

Line 1449: psa_utils.debug_other_string(g_state_level,l_full_path,' ==========');

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);
1451: psa_utils.debug_other_string(g_state_level,l_full_path,' p_cash_ccid -> ' || p_cash_ccid);
1452: psa_utils.debug_other_string(g_state_level,l_full_path,' p_cust_trx_id -> ' || p_cust_trx_id);
1453: psa_utils.debug_other_string(g_state_level,l_full_path,' p_cust_trx_line_id -> ' || p_cust_trx_line_id);

Line 1450: psa_utils.debug_other_string(g_state_level,l_full_path,' p_rcv_app_id -> ' || p_rcv_app_id);

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);
1451: psa_utils.debug_other_string(g_state_level,l_full_path,' p_cash_ccid -> ' || p_cash_ccid);
1452: psa_utils.debug_other_string(g_state_level,l_full_path,' p_cust_trx_id -> ' || p_cust_trx_id);
1453: psa_utils.debug_other_string(g_state_level,l_full_path,' p_cust_trx_line_id -> ' || p_cust_trx_line_id);
1454: psa_utils.debug_other_string(g_state_level,l_full_path,' p_amount_applied -> ' || p_amount_applied);

Line 1451: psa_utils.debug_other_string(g_state_level,l_full_path,' p_cash_ccid -> ' || p_cash_ccid);

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);
1451: psa_utils.debug_other_string(g_state_level,l_full_path,' p_cash_ccid -> ' || p_cash_ccid);
1452: psa_utils.debug_other_string(g_state_level,l_full_path,' p_cust_trx_id -> ' || p_cust_trx_id);
1453: psa_utils.debug_other_string(g_state_level,l_full_path,' p_cust_trx_line_id -> ' || p_cust_trx_line_id);
1454: psa_utils.debug_other_string(g_state_level,l_full_path,' p_amount_applied -> ' || p_amount_applied);
1455: psa_utils.debug_other_string(g_state_level,l_full_path,' p_earned_discount -> ' || p_earned_discount);

Line 1452: psa_utils.debug_other_string(g_state_level,l_full_path,' p_cust_trx_id -> ' || p_cust_trx_id);

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);
1451: psa_utils.debug_other_string(g_state_level,l_full_path,' p_cash_ccid -> ' || p_cash_ccid);
1452: psa_utils.debug_other_string(g_state_level,l_full_path,' p_cust_trx_id -> ' || p_cust_trx_id);
1453: psa_utils.debug_other_string(g_state_level,l_full_path,' p_cust_trx_line_id -> ' || p_cust_trx_line_id);
1454: psa_utils.debug_other_string(g_state_level,l_full_path,' p_amount_applied -> ' || p_amount_applied);
1455: psa_utils.debug_other_string(g_state_level,l_full_path,' p_earned_discount -> ' || p_earned_discount);
1456: psa_utils.debug_other_string(g_state_level,l_full_path,' p_unearned_discount -> ' || p_unearned_discount);

Line 1453: psa_utils.debug_other_string(g_state_level,l_full_path,' p_cust_trx_line_id -> ' || p_cust_trx_line_id);

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);
1451: psa_utils.debug_other_string(g_state_level,l_full_path,' p_cash_ccid -> ' || p_cash_ccid);
1452: psa_utils.debug_other_string(g_state_level,l_full_path,' p_cust_trx_id -> ' || p_cust_trx_id);
1453: psa_utils.debug_other_string(g_state_level,l_full_path,' p_cust_trx_line_id -> ' || p_cust_trx_line_id);
1454: psa_utils.debug_other_string(g_state_level,l_full_path,' p_amount_applied -> ' || p_amount_applied);
1455: psa_utils.debug_other_string(g_state_level,l_full_path,' p_earned_discount -> ' || p_earned_discount);
1456: psa_utils.debug_other_string(g_state_level,l_full_path,' p_unearned_discount -> ' || p_unearned_discount);
1457: psa_utils.debug_other_string(g_state_level,l_full_path,' p_earned_discount_ccid -> ' || p_earned_discount_ccid);

Line 1454: psa_utils.debug_other_string(g_state_level,l_full_path,' p_amount_applied -> ' || p_amount_applied);

1450: psa_utils.debug_other_string(g_state_level,l_full_path,' p_rcv_app_id -> ' || p_rcv_app_id);
1451: psa_utils.debug_other_string(g_state_level,l_full_path,' p_cash_ccid -> ' || p_cash_ccid);
1452: psa_utils.debug_other_string(g_state_level,l_full_path,' p_cust_trx_id -> ' || p_cust_trx_id);
1453: psa_utils.debug_other_string(g_state_level,l_full_path,' p_cust_trx_line_id -> ' || p_cust_trx_line_id);
1454: psa_utils.debug_other_string(g_state_level,l_full_path,' p_amount_applied -> ' || p_amount_applied);
1455: psa_utils.debug_other_string(g_state_level,l_full_path,' p_earned_discount -> ' || p_earned_discount);
1456: psa_utils.debug_other_string(g_state_level,l_full_path,' p_unearned_discount -> ' || p_unearned_discount);
1457: psa_utils.debug_other_string(g_state_level,l_full_path,' p_earned_discount_ccid -> ' || p_earned_discount_ccid);
1458: psa_utils.debug_other_string(g_state_level,l_full_path,' p_unearned_discount_ccid -> ' || p_unearned_discount_ccid);

Line 1455: psa_utils.debug_other_string(g_state_level,l_full_path,' p_earned_discount -> ' || p_earned_discount);

1451: psa_utils.debug_other_string(g_state_level,l_full_path,' p_cash_ccid -> ' || p_cash_ccid);
1452: psa_utils.debug_other_string(g_state_level,l_full_path,' p_cust_trx_id -> ' || p_cust_trx_id);
1453: psa_utils.debug_other_string(g_state_level,l_full_path,' p_cust_trx_line_id -> ' || p_cust_trx_line_id);
1454: psa_utils.debug_other_string(g_state_level,l_full_path,' p_amount_applied -> ' || p_amount_applied);
1455: psa_utils.debug_other_string(g_state_level,l_full_path,' p_earned_discount -> ' || p_earned_discount);
1456: psa_utils.debug_other_string(g_state_level,l_full_path,' p_unearned_discount -> ' || p_unearned_discount);
1457: psa_utils.debug_other_string(g_state_level,l_full_path,' p_earned_discount_ccid -> ' || p_earned_discount_ccid);
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);

Line 1456: psa_utils.debug_other_string(g_state_level,l_full_path,' p_unearned_discount -> ' || p_unearned_discount);

1452: psa_utils.debug_other_string(g_state_level,l_full_path,' p_cust_trx_id -> ' || p_cust_trx_id);
1453: psa_utils.debug_other_string(g_state_level,l_full_path,' p_cust_trx_line_id -> ' || p_cust_trx_line_id);
1454: psa_utils.debug_other_string(g_state_level,l_full_path,' p_amount_applied -> ' || p_amount_applied);
1455: psa_utils.debug_other_string(g_state_level,l_full_path,' p_earned_discount -> ' || p_earned_discount);
1456: psa_utils.debug_other_string(g_state_level,l_full_path,' p_unearned_discount -> ' || p_unearned_discount);
1457: psa_utils.debug_other_string(g_state_level,l_full_path,' p_earned_discount_ccid -> ' || p_earned_discount_ccid);
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);

Line 1457: psa_utils.debug_other_string(g_state_level,l_full_path,' p_earned_discount_ccid -> ' || p_earned_discount_ccid);

1453: psa_utils.debug_other_string(g_state_level,l_full_path,' p_cust_trx_line_id -> ' || p_cust_trx_line_id);
1454: psa_utils.debug_other_string(g_state_level,l_full_path,' p_amount_applied -> ' || p_amount_applied);
1455: psa_utils.debug_other_string(g_state_level,l_full_path,' p_earned_discount -> ' || p_earned_discount);
1456: psa_utils.debug_other_string(g_state_level,l_full_path,' p_unearned_discount -> ' || p_unearned_discount);
1457: psa_utils.debug_other_string(g_state_level,l_full_path,' p_earned_discount_ccid -> ' || p_earned_discount_ccid);
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 ');

Line 1458: psa_utils.debug_other_string(g_state_level,l_full_path,' p_unearned_discount_ccid -> ' || p_unearned_discount_ccid);

1454: psa_utils.debug_other_string(g_state_level,l_full_path,' p_amount_applied -> ' || p_amount_applied);
1455: psa_utils.debug_other_string(g_state_level,l_full_path,' p_earned_discount -> ' || p_earned_discount);
1456: psa_utils.debug_other_string(g_state_level,l_full_path,' p_unearned_discount -> ' || p_unearned_discount);
1457: psa_utils.debug_other_string(g_state_level,l_full_path,' p_earned_discount_ccid -> ' || p_earned_discount_ccid);
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 ===========================

Line 1459: psa_utils.debug_other_string(g_state_level,l_full_path,' p_document_type -> ' || p_document_type);

1455: psa_utils.debug_other_string(g_state_level,l_full_path,' p_earned_discount -> ' || p_earned_discount);
1456: psa_utils.debug_other_string(g_state_level,l_full_path,' p_unearned_discount -> ' || p_unearned_discount);
1457: psa_utils.debug_other_string(g_state_level,l_full_path,' p_earned_discount_ccid -> ' || p_earned_discount_ccid);
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:

Line 1460: psa_utils.debug_other_string(g_state_level,l_full_path,' p_crh_status -> ' || p_crh_status);

1456: psa_utils.debug_other_string(g_state_level,l_full_path,' p_unearned_discount -> ' || p_unearned_discount);
1457: psa_utils.debug_other_string(g_state_level,l_full_path,' p_earned_discount_ccid -> ' || p_earned_discount_ccid);
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

Line 1461: psa_utils.debug_other_string(g_state_level,l_full_path,' Starting the process ');

1457: psa_utils.debug_other_string(g_state_level,l_full_path,' p_earned_discount_ccid -> ' || p_earned_discount_ccid);
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

Line 1477: psa_utils.debug_other_string(g_state_level,l_full_path,' Creating distribution for Cust trx id ==> ' || run_num || ' -- ' || p_cust_trx_id);

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 (
1481: errbuf => l_errbuf,

Line 1489: psa_utils.debug_other_string(g_state_level,l_full_path,' PSA_MFAR_TRANSACTIONS.create_distributions --> FALSE');

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 ===========================
1493: psa_utils.debug_other_string(g_state_level,l_full_path,' Raising invalid_distribution');

Line 1493: psa_utils.debug_other_string(g_state_level,l_full_path,' Raising invalid_distribution');

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;
1497: ELSE

Line 1499: psa_utils.debug_other_string(g_state_level,l_full_path,' cust_trx_id --> ' || p_cust_trx_id);

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:
1503: -- ========================= FND LOG ===========================

Line 1504: psa_utils.debug_other_string(g_state_level,l_full_path,' p_earned_discount --> ' || p_earned_discount );

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:
1508: IF (p_earned_discount <> 0 OR p_unearned_discount <> 0) THEN

Line 1505: psa_utils.debug_other_string(g_state_level,l_full_path,' p_unearned_discount --> ' || p_unearned_discount );

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:
1508: IF (p_earned_discount <> 0 OR p_unearned_discount <> 0) THEN
1509: -- ========================= FND LOG ===========================

Line 1510: psa_utils.debug_other_string(g_state_level,l_full_path,' Calling populate_discount_cache --> ' || p_cust_trx_id);

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;
1514:

Line 1532: psa_utils.debug_other_string(g_state_level,l_full_path,' l_total_amount_due --> ' || l_total_amount_due );

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:
1536: --

Line 1533: psa_utils.debug_other_string(g_state_level,l_full_path,' sum_amt_due_rem --> ' || sum_amt_due_rem );

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:
1536: --
1537: -- Initailize variables for running total

Line 1563: psa_utils.debug_other_string(g_state_level,l_full_path,' l_running_total_amount_due --> ' || l_running_total_amount_due );

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 ===========================
1567:

Line 1564: psa_utils.debug_other_string(g_state_level,l_full_path,' l_running_total_amount_earn --> ' || l_running_total_amount_earn);

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 ===========================
1567:
1568: l_c_accrual_stmt :=

Line 1565: psa_utils.debug_other_string(g_state_level,l_full_path,' l_running_total_amount_unearn --> ' || l_running_total_amount_unearn);

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 ===========================
1567:
1568: l_c_accrual_stmt :=
1569: 'Select mf_trx_dist.mf_receivables_ccid rcv_ccid, ' ||

Line 1616: psa_utils.debug_other_string(g_state_level,l_full_path,' arp_global.sysparam.accounting_method --> '

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:
1620: IF arp_global.sysparam.accounting_method = 'ACCRUAL' THEN

Line 1656: psa_utils.debug_other_string(g_state_level,l_full_path,

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:
1660: --

Line 1672: psa_utils.debug_other_string(g_state_level,l_full_path,

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;
1676:

Line 1678: psa_utils.debug_other_string(g_state_level,l_full_path,' p_document_type -->

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:
1682: p_ccid := l_accrual_rec.rcv_ccid;

Line 1684: psa_utils.debug_other_string(g_state_level,l_full_path,

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: --
1688: -- Prorate amount applied

Line 1693: psa_utils.debug_other_string(g_state_level,l_full_path,' p_cust_trx_line_id Is NOT NULL');

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)
1697: AND NOT (l_running_total_amount_due = 0) THEN -- to avoid divide by zero error

Line 1705: psa_utils.debug_other_string(g_state_level,l_full_path,' In IF ' ||

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 ||
1709: ' ##l_accrual_rec.amount_due --> ' || l_accrual_rec.amount_due ||

Line 1724: psa_utils.debug_other_string(g_state_level,l_full_path,' IF part ' ||

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 ||
1728: ' ##l_running_amount --> ' || l_running_amount ||

Line 1737: psa_utils.debug_other_string(g_state_level,l_full_path,' ##l_amount --> ' || l_amount || ' ##l_percent --> ' || l_percent);

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
1741: -- ========================= FND LOG ===========================

Line 1742: psa_utils.debug_other_string(g_state_level,l_full_path,' p_cust_trx_line_id Is NULL');

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
1746:

Line 1760: psa_utils.debug_other_string(g_state_level,l_full_path,' ELSE part ' ||

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 ||
1764: ' ##l_running_amount --> ' || l_running_amount ||

Line 1779: psa_utils.debug_other_string(g_state_level,l_full_path,' calling LINE_IN_DISCOUNT_CACHE --> ' || l_accrual_rec.trx_line_id);

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:
1783: --

Line 1780: psa_utils.debug_other_string(g_state_level,l_full_path,' prorate earned discount ');

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:
1783: --
1784: -- Prorate Earned Discount

Line 1797: psa_utils.debug_other_string(g_state_level,l_full_path,' IF part ' ||

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 ||
1801: ' ##l_running_total_amount_earn --> ' || l_running_total_amount_earn);

Line 1807: psa_utils.debug_other_string(g_state_level,l_full_path,

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;
1811:

Line 1817: psa_utils.debug_other_string(g_state_level,l_full_path,' prorate unearned discount ');

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
1821: AND NOT (l_running_total_amount_unearn = 0) THEN -- to avoid divide by zero error

Line 1830: psa_utils.debug_other_string(g_state_level,l_full_path,' IF part ' ||

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 ||
1834: ' ##l_running_total_amount_earn --> ' || l_running_total_amount_earn);

Line 1839: psa_utils.debug_other_string(g_state_level,l_full_path,' ELSE part ##l_unearned_discount --> ' || l_unearned_discount);

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;
1843:

Line 1846: psa_utils.debug_other_string(g_state_level,l_full_path,

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,
1850: ' ##p_unearned_discount_ccid --> ' || p_unearned_discount_ccid ||

Line 1848: psa_utils.debug_other_string(g_state_level,l_full_path,' p_earned_discount_ccid IS NOT NULL ');

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,
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 ||

Line 1849: psa_utils.debug_other_string(g_state_level,l_full_path,

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,
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);

Line 1862: psa_utils.debug_other_string(g_state_level,l_full_path,' PSA_MFAR_UTILS.OVERRIDE_SEGMENTS -> FALSE');

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;
1866: ELSE

Line 1868: psa_utils.debug_other_string(g_state_level,l_full_path,' p_earned_discount_ccid IS NULL ');

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:
1872: IF p_unearned_discount_ccid IS NOT NULL THEN

Line 1874: psa_utils.debug_other_string(g_state_level,l_full_path,

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 ');
1878: psa_utils.debug_other_string(g_state_level,l_full_path,

Line 1876: psa_utils.debug_other_string(g_state_level,l_full_path,

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 ');
1878: psa_utils.debug_other_string(g_state_level,l_full_path,
1879: ' ##p_unearned_discount_ccid --> ' || p_unearned_discount_ccid ||
1880: ' ##rcv_ccid --> ' || l_accrual_rec.rcv_ccid ||

Line 1878: psa_utils.debug_other_string(g_state_level,l_full_path,

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 ');
1878: psa_utils.debug_other_string(g_state_level,l_full_path,
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);

Line 1892: psa_utils.debug_other_string(g_state_level,l_full_path,' PSA_MFAR_UTILS.OVERRIDE_SEGMENTS -> FALSE ');

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;
1896: ELSE

Line 1893: psa_utils.debug_other_string(g_state_level,l_full_path,' Raising flex_build_error ');

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;
1896: ELSE
1897: -- ========================= FND LOG ===========================

Line 1898: psa_utils.debug_other_string(g_state_level,l_full_path,

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;
1902: END IF;

Line 1907: psa_utils.debug_other_string(g_state_level,l_full_path,' calling PSA_MFAR_RECEIPTS_COVER_PKG.INSERT_ROW');

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: --
1911: -- Insert into psa_mf_rct_dist_all

Line 1919: psa_utils.debug_other_string(g_state_level,l_full_path,

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;
1923:

Line 1972: psa_utils.debug_other_string(g_state_level,l_full_path,' retcode --> ' || retcode );

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:
1976: retcode := 'S';

Line 1973: psa_utils.debug_other_string(g_state_level,l_full_path,' RETURN TRUE ');

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:
1976: retcode := 'S';
1977: RETURN TRUE;

Line 1984: psa_utils.debug_other_string(g_excep_level,l_full_path,

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);
1988: -- ========================= FND LOG ===========================

Line 1986: psa_utils.debug_other_string(g_excep_level,l_full_path,

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);
1988: -- ========================= FND LOG ===========================
1989: p_error_message := l_exception_message;
1990: retcode := 'F';

Line 1996: psa_utils.debug_other_string(g_excep_level,l_full_path,

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);
2000: -- ========================= FND LOG ===========================

Line 1998: psa_utils.debug_other_string(g_excep_level,l_full_path,

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);
2000: -- ========================= FND LOG ===========================
2001: p_error_message := l_exception_message;
2002: retcode := 'F';

Line 2008: psa_utils.debug_other_string(g_excep_level,l_full_path,

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);
2012: psa_utils.debug_unexpected_msg(l_full_path);

Line 2010: psa_utils.debug_other_string(g_excep_level,l_full_path,

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);
2012: psa_utils.debug_unexpected_msg(l_full_path);
2013: -- ========================= FND LOG ===========================
2014: p_error_message := l_exception_message;

Line 2012: psa_utils.debug_unexpected_msg(l_full_path);

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);
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;

Line 2045: psa_utils.debug_other_string(g_state_level,l_full_path,' Purge_orphan_distributions : --> START');

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;
2049: LOOP

Line 2054: psa_utils.debug_other_string(g_state_level,l_full_path,' Purge_orphan_distributions : --> deleting ' || l_invalid_distributions_rec.rcv_app_id);

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
2058: WHERE receivable_application_id = l_invalid_distributions_rec.rcv_app_id;

Line 2061: psa_utils.debug_other_string(g_state_level,l_full_path,' Purge_orphan_distributions : --> rows ' || SQL%ROWCOUNT);

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;
2065: CLOSE c_invalid_distributions;

Line 2068: psa_utils.debug_other_string(g_state_level,l_full_path,' Purge_orphan_distributions : --> END');

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
2072: WHEN OTHERS THEN

Line 2077: psa_utils.debug_other_string(g_excep_level,l_full_path,l_exception_message);

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:
2081: END purge_orphan_distributions;

Line 2078: psa_utils.debug_unexpected_msg(l_full_path);

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:
2081: END purge_orphan_distributions;
2082:

Line 2106: psa_utils.debug_other_string(g_state_level,l_full_path,' Populate_discount_lines_cache : --> START');

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;
2110: FETCH c_variables INTO l_variables_rec;

Line 2114: psa_utils.debug_other_string(g_state_level,l_full_path,' Populate_discount_lines_cache : Created form --> ' || l_variables_rec.created_from);

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: --
2118: -- For a transaction created manually, "discount basis" is taken into

Line 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);

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
2142: MANUAL_TRANSACTION (p_customer_trx_id, l_variables_rec.discount_basis);

Line 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);

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:
2148: EXCEPTION

Line 2154: psa_utils.debug_other_string(g_excep_level,l_full_path,l_exception_message);

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:
2158: END populate_discount_lines_cache;

Line 2155: psa_utils.debug_unexpected_msg(l_full_path);

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:
2158: END populate_discount_lines_cache;
2159:

Line 2181: psa_utils.debug_other_string(g_state_level,l_full_path,' Manual_transaction : START ');

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:
2185: RESET_DISCOUNT_CACHE;

Line 2182: psa_utils.debug_other_string(g_state_level,l_full_path,' Manual_transaction : calling RESET_DISCOUNT_CACHE ');

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:
2185: RESET_DISCOUNT_CACHE;
2186:

Line 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);

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;
2198: l_index := l_index + 1;

Line 2204: psa_utils.debug_other_string(g_state_level,l_full_path,' Manual_transaction : END ');

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
2208: WHEN OTHERS THEN

Line 2213: psa_utils.debug_other_string(g_excep_level,l_full_path,l_exception_message);

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;
2217:

Line 2214: psa_utils.debug_unexpected_msg(l_full_path);

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;
2217:
2218:

Line 2239: psa_utils.debug_other_string(g_state_level,l_full_path,' Include_manual_line : START');

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
2243: RETURN 'Y';

Line 2279: psa_utils.debug_other_string(g_excep_level,l_full_path,l_exception_message);

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:
2283: END include_manual_line;

Line 2280: psa_utils.debug_unexpected_msg(l_full_path);

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:
2283: END include_manual_line;
2284:

Line 2309: psa_utils.debug_other_string(g_state_level,l_full_path,' Imported_transaction : START');

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: --
2313: -- Profile Option - TAX: Inventory Item for Freight

Line 2319: psa_utils.debug_other_string(g_state_level,l_full_path,' Imported_transaction : calling RESET_DISCOUNT_CACHE');

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;
2323:

Line 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);

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;
2334: END LOOP;

Line 2343: psa_utils.debug_other_string(g_excep_level,l_full_path,l_exception_message);

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:
2347: END imported_transaction;

Line 2344: psa_utils.debug_unexpected_msg(l_full_path);

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:
2347: END imported_transaction;
2348:

Line 2377: psa_utils.debug_other_string(g_state_level,l_full_path,' Include_imported_transaction : START');

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
2381: IF g_inventory_item_profile IS NOT NULL THEN

Line 2438: psa_utils.debug_other_string(g_excep_level,l_full_path,l_exception_message);

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:
2442: END include_imported_line;

Line 2439: psa_utils.debug_unexpected_msg(l_full_path);

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:
2442: END include_imported_line;
2443:

Line 2452: psa_utils.debug_other_string(g_state_level,l_full_path,' Line_in_discount_cache : START');

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
2456: RETURN TRUE;

Line 2466: psa_utils.debug_other_string(g_excep_level,l_full_path,l_exception_message);

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:
2470: END line_in_discount_cache;

Line 2467: psa_utils.debug_unexpected_msg(l_full_path);

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:
2470: END line_in_discount_cache;
2471:

Line 2480: psa_utils.debug_other_string(g_state_level,l_full_path,' Reset_discount_cache : START');

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
2484: TrxLinesTab.DELETE(i);

Line 2493: psa_utils.debug_other_string(g_excep_level,l_full_path,l_exception_message);

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:
2497: END reset_discount_cache;

Line 2494: psa_utils.debug_unexpected_msg(l_full_path);

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:
2497: END reset_discount_cache;
2498: