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_MF_MISC_PKG dependencies on PSA_UTILS

Line 89: psa_utils.debug_other_string(g_state_level,l_full_path,' Inside Generate_distributions ');

85: g_run_id := p_run_id;
86: retcode := 'F';
87:
88: -- ========================= FND LOG ===========================
89: psa_utils.debug_other_string(g_state_level,l_full_path,' Inside Generate_distributions ');
90: psa_utils.debug_other_string(g_state_level,l_full_path,' PARAMETERS: ');
91: psa_utils.debug_other_string(g_state_level,l_full_path,' =========== ');
92: psa_utils.debug_other_string(g_state_level,l_full_path,' p_cash_receipt_id --> ' || p_cash_receipt_id);
93: psa_utils.debug_other_string(g_state_level,l_full_path,' p_set_of_books_id --> ' || p_set_of_books_id);

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

86: retcode := 'F';
87:
88: -- ========================= FND LOG ===========================
89: psa_utils.debug_other_string(g_state_level,l_full_path,' Inside Generate_distributions ');
90: psa_utils.debug_other_string(g_state_level,l_full_path,' PARAMETERS: ');
91: psa_utils.debug_other_string(g_state_level,l_full_path,' =========== ');
92: psa_utils.debug_other_string(g_state_level,l_full_path,' p_cash_receipt_id --> ' || p_cash_receipt_id);
93: psa_utils.debug_other_string(g_state_level,l_full_path,' p_set_of_books_id --> ' || p_set_of_books_id);
94: psa_utils.debug_other_string(g_state_level,l_full_path,' p_run_id --> ' || p_run_id);

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

87:
88: -- ========================= FND LOG ===========================
89: psa_utils.debug_other_string(g_state_level,l_full_path,' Inside Generate_distributions ');
90: psa_utils.debug_other_string(g_state_level,l_full_path,' PARAMETERS: ');
91: psa_utils.debug_other_string(g_state_level,l_full_path,' =========== ');
92: psa_utils.debug_other_string(g_state_level,l_full_path,' p_cash_receipt_id --> ' || p_cash_receipt_id);
93: psa_utils.debug_other_string(g_state_level,l_full_path,' p_set_of_books_id --> ' || p_set_of_books_id);
94: psa_utils.debug_other_string(g_state_level,l_full_path,' p_run_id --> ' || p_run_id);
95: psa_utils.debug_other_string(g_state_level,l_full_path,' ');

Line 92: psa_utils.debug_other_string(g_state_level,l_full_path,' p_cash_receipt_id --> ' || p_cash_receipt_id);

88: -- ========================= FND LOG ===========================
89: psa_utils.debug_other_string(g_state_level,l_full_path,' Inside Generate_distributions ');
90: psa_utils.debug_other_string(g_state_level,l_full_path,' PARAMETERS: ');
91: psa_utils.debug_other_string(g_state_level,l_full_path,' =========== ');
92: psa_utils.debug_other_string(g_state_level,l_full_path,' p_cash_receipt_id --> ' || p_cash_receipt_id);
93: psa_utils.debug_other_string(g_state_level,l_full_path,' p_set_of_books_id --> ' || p_set_of_books_id);
94: psa_utils.debug_other_string(g_state_level,l_full_path,' p_run_id --> ' || p_run_id);
95: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
96: -- ========================= FND LOG ===========================

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

89: psa_utils.debug_other_string(g_state_level,l_full_path,' Inside Generate_distributions ');
90: psa_utils.debug_other_string(g_state_level,l_full_path,' PARAMETERS: ');
91: psa_utils.debug_other_string(g_state_level,l_full_path,' =========== ');
92: psa_utils.debug_other_string(g_state_level,l_full_path,' p_cash_receipt_id --> ' || p_cash_receipt_id);
93: psa_utils.debug_other_string(g_state_level,l_full_path,' p_set_of_books_id --> ' || p_set_of_books_id);
94: psa_utils.debug_other_string(g_state_level,l_full_path,' p_run_id --> ' || p_run_id);
95: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
96: -- ========================= FND LOG ===========================
97:

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

90: psa_utils.debug_other_string(g_state_level,l_full_path,' PARAMETERS: ');
91: psa_utils.debug_other_string(g_state_level,l_full_path,' =========== ');
92: psa_utils.debug_other_string(g_state_level,l_full_path,' p_cash_receipt_id --> ' || p_cash_receipt_id);
93: psa_utils.debug_other_string(g_state_level,l_full_path,' p_set_of_books_id --> ' || p_set_of_books_id);
94: psa_utils.debug_other_string(g_state_level,l_full_path,' p_run_id --> ' || p_run_id);
95: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
96: -- ========================= FND LOG ===========================
97:
98:

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

91: psa_utils.debug_other_string(g_state_level,l_full_path,' =========== ');
92: psa_utils.debug_other_string(g_state_level,l_full_path,' p_cash_receipt_id --> ' || p_cash_receipt_id);
93: psa_utils.debug_other_string(g_state_level,l_full_path,' p_set_of_books_id --> ' || p_set_of_books_id);
94: psa_utils.debug_other_string(g_state_level,l_full_path,' p_run_id --> ' || p_run_id);
95: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
96: -- ========================= FND LOG ===========================
97:
98:
99: /*

Line 119: psa_utils.debug_other_string(g_state_level,l_full_path,

115: AND psa.reference1 = I.status;
116:
117:
118: -- ========================= FND LOG ===========================
119: psa_utils.debug_other_string(g_state_level,l_full_path,
120: ' Generate_distributions --> mf_dist_count ' || mf_dist_count);
121: -- ========================= FND LOG ===========================
122:
123:

Line 126: psa_utils.debug_other_string(g_state_level,l_full_path,

122:
123:
124: IF (mf_dist_count > 0) THEN -- 1 IF
125: -- ========================= FND LOG ===========================
126: psa_utils.debug_other_string(g_state_level,l_full_path,
127: ' Generate_distributions --> mf_dist_count > 0 ');
128: -- ========================= FND LOG ===========================
129:
130: /*

Line 152: psa_utils.debug_other_string(g_excep_level,l_full_path,

148: x_cash_receipt_hist_id => i.cash_receipt_history_id )) THEN -- 3 IF
149:
150: IF p_error_message IS NOT NULL OR retcode = 'F' THEN -- 4 IF
151: -- ========================= FND LOG ===========================
152: psa_utils.debug_other_string(g_excep_level,l_full_path,
153: ' Generate_distributions --> Error Message --> '
154: || p_error_message);
155: -- ========================= FND LOG ===========================
156:

Line 159: psa_utils.debug_other_string(g_excep_level,l_full_path,

155: -- ========================= FND LOG ===========================
156:
157: IF NVL(p_report_only,'N') = 'N' THEN -- 5 IF
158: -- ========================= FND LOG ===========================
159: psa_utils.debug_other_string(g_excep_level,l_full_path,
160: ' Generate_distributions --> p_report_only --> N'
161: ||' : This is not for reporting purpose so end processing. ');
162: -- ========================= FND LOG ===========================
163: RETURN FALSE;

Line 168: psa_utils.debug_other_string(g_state_level,l_full_path,

164: END IF; -- 5 END IF
165: END IF; -- 4 END IF
166: ELSE
167: -- ========================= FND LOG ===========================
168: psa_utils.debug_other_string(g_state_level,l_full_path,
169: ' Generate_distributions -> PSA_MF_MISC_PKG.create_distributions --> TRUE ');
170: -- ========================= FND LOG ===========================
171: END IF; -- 3 END IF
172:

Line 188: psa_utils.debug_other_string(g_state_level,l_full_path,

184: EXIT WHEN c_match_ccid%NOTFOUND;
185:
186: IF (match_ccid_rec.distribution_ccid <> match_ccid_rec.code_combination_id) THEN
187: -- ========================= FND LOG ===========================
188: psa_utils.debug_other_string(g_state_level,l_full_path,
189: ' Generate_distributions --> match_ccid_rec.distribution_ccid'
190: || ' <> match_ccid_rec.code_combination_id');
191: -- ========================= FND LOG ===========================
192:

Line 202: psa_utils.debug_other_string(g_excep_level,l_full_path,

198: x_status => i.status,
199: x_cash_receipt_hist_id => i.cash_receipt_history_id )) THEN
200: IF p_error_message IS NOT NULL OR retcode = 'F' THEN
201: -- ========================= FND LOG ===========================
202: psa_utils.debug_other_string(g_excep_level,l_full_path,
203: ' Generate_distributions --> Error Message --> '
204: || p_error_message);
205: -- ========================= FND LOG ===========================
206:

Line 209: psa_utils.debug_other_string(g_excep_level,l_full_path,

205: -- ========================= FND LOG ===========================
206:
207: IF NVL(p_report_only,'N') = 'N' THEN
208: -- ========================= FND LOG ===========================
209: psa_utils.debug_other_string(g_excep_level,l_full_path,
210: ' Generate_distributions --> p_report_only --> N :'
211: ||' This is not for reporting purpose so end processing. ');
212: -- ========================= FND LOG ===========================
213: RETURN FALSE;

Line 219: psa_utils.debug_other_string(g_state_level,l_full_path,

215: END IF;
216:
217: ELSE
218: -- ========================= FND LOG ===========================
219: psa_utils.debug_other_string(g_state_level,l_full_path,
220: ' Generate_distributions -> PSA_MF_MISC_PKG.create_distributions --> TRUE ');
221: -- ========================= FND LOG ===========================
222: END IF;
223: END IF;

Line 247: psa_utils.debug_other_string(g_excep_level,l_full_path,

243: x_cash_receipt_hist_id => i.cash_receipt_history_id )) THEN
244:
245: IF p_error_message IS NOT NULL OR retcode = 'F' THEN
246: -- ========================= FND LOG ===========================
247: psa_utils.debug_other_string(g_excep_level,l_full_path,
248: ' Generate_distributions --> Error Message --> '
249: || p_error_message);
250: -- ========================= FND LOG ===========================
251:

Line 254: psa_utils.debug_other_string(g_excep_level,l_full_path,

250: -- ========================= FND LOG ===========================
251:
252: IF NVL(p_report_only,'N') = 'N' THEN
253: -- ========================= FND LOG ===========================
254: psa_utils.debug_other_string(g_excep_level,l_full_path,
255: ' Generate_distributions --> p_report_only --> N:'
256: ||' This is not for reporting purpose so end processing. ');
257: -- ========================= FND LOG ===========================
258: RETURN FALSE;

Line 264: psa_utils.debug_other_string(g_state_level,l_full_path,

260: END IF;
261:
262: ELSE
263: -- ========================= FND LOG ===========================
264: psa_utils.debug_other_string(g_state_level,l_full_path,
265: ' Generate_distributions -> PSA_MF_MISC_PKG.create_distributions --> FALSE ');
266: -- ========================= FND LOG ===========================
267: END IF;
268:

Line 273: psa_utils.debug_other_string(g_state_level,l_full_path,

269: END IF; -- 1 END IF
270: END LOOP;
271:
272: -- ========================= FND LOG ===========================
273: psa_utils.debug_other_string(g_state_level,l_full_path,
274: ' Generate_distributions -> END ');
275: -- ========================= FND LOG ===========================
276:
277: retcode := 'S';

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

280: EXCEPTION
281: WHEN OTHERS THEN -- here
282: p_error_message:= 'EXCEPTION - OTHERS PACKAGE - PSA_MF_MISC_PKG.GENERATE_DISTRIBUTIONS - '||SQLERRM;
283: -- ========================= FND LOG ===========================
284: psa_utils.debug_other_string(g_excep_level,l_full_path,p_error_message);
285: psa_utils.debug_unexpected_msg(l_full_path);
286: -- ========================= FND LOG ===========================
287: retcode := 'F';
288: RETURN FALSE;

Line 285: psa_utils.debug_unexpected_msg(l_full_path);

281: WHEN OTHERS THEN -- here
282: p_error_message:= 'EXCEPTION - OTHERS PACKAGE - PSA_MF_MISC_PKG.GENERATE_DISTRIBUTIONS - '||SQLERRM;
283: -- ========================= FND LOG ===========================
284: psa_utils.debug_other_string(g_excep_level,l_full_path,p_error_message);
285: psa_utils.debug_unexpected_msg(l_full_path);
286: -- ========================= FND LOG ===========================
287: retcode := 'F';
288: RETURN FALSE;
289:

Line 392: psa_utils.debug_other_string(g_state_level,l_full_path,' Inside Create_distributions ');

388:
389: retcode := 'F';
390:
391: -- ========================= FND LOG ===========================
392: psa_utils.debug_other_string(g_state_level,l_full_path,' Inside Create_distributions ');
393: psa_utils.debug_other_string(g_state_level,l_full_path,' PARAMETERS: ');
394: psa_utils.debug_other_string(g_state_level,l_full_path,' =========== ');
395: psa_utils.debug_other_string(g_state_level,l_full_path,' p_mode --> ' || p_mode);
396: psa_utils.debug_other_string(g_state_level,l_full_path,' ');

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

389: retcode := 'F';
390:
391: -- ========================= FND LOG ===========================
392: psa_utils.debug_other_string(g_state_level,l_full_path,' Inside Create_distributions ');
393: psa_utils.debug_other_string(g_state_level,l_full_path,' PARAMETERS: ');
394: psa_utils.debug_other_string(g_state_level,l_full_path,' =========== ');
395: psa_utils.debug_other_string(g_state_level,l_full_path,' p_mode --> ' || p_mode);
396: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
397: -- ========================= FND LOG ===========================

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

390:
391: -- ========================= FND LOG ===========================
392: psa_utils.debug_other_string(g_state_level,l_full_path,' Inside Create_distributions ');
393: psa_utils.debug_other_string(g_state_level,l_full_path,' PARAMETERS: ');
394: psa_utils.debug_other_string(g_state_level,l_full_path,' =========== ');
395: psa_utils.debug_other_string(g_state_level,l_full_path,' p_mode --> ' || p_mode);
396: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
397: -- ========================= FND LOG ===========================
398:

Line 395: psa_utils.debug_other_string(g_state_level,l_full_path,' p_mode --> ' || p_mode);

391: -- ========================= FND LOG ===========================
392: psa_utils.debug_other_string(g_state_level,l_full_path,' Inside Create_distributions ');
393: psa_utils.debug_other_string(g_state_level,l_full_path,' PARAMETERS: ');
394: psa_utils.debug_other_string(g_state_level,l_full_path,' =========== ');
395: psa_utils.debug_other_string(g_state_level,l_full_path,' p_mode --> ' || p_mode);
396: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
397: -- ========================= FND LOG ===========================
398:
399: OPEN c_cash_ccid (g_cash_receipt_id);

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

392: psa_utils.debug_other_string(g_state_level,l_full_path,' Inside Create_distributions ');
393: psa_utils.debug_other_string(g_state_level,l_full_path,' PARAMETERS: ');
394: psa_utils.debug_other_string(g_state_level,l_full_path,' =========== ');
395: psa_utils.debug_other_string(g_state_level,l_full_path,' p_mode --> ' || p_mode);
396: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
397: -- ========================= FND LOG ===========================
398:
399: OPEN c_cash_ccid (g_cash_receipt_id);
400: FETCH c_cash_ccid INTO ccid_rec;

Line 427: psa_utils.debug_other_string(g_state_level,l_full_path,

423: The cursor identifies the Core distribution rows that are reversing lines.
424: =====================================================================================*/
425:
426: -- ========================= FND LOG ===========================
427: psa_utils.debug_other_string(g_state_level,l_full_path,
428: ' Create_distributions --> g_cash_receipt_id --> '
429: || g_cash_receipt_id);
430: -- ========================= FND LOG ===========================
431:

Line 439: psa_utils.debug_other_string(g_state_level,l_full_path,

435: FROM ar_cash_receipts
436: WHERE cash_receipt_id = g_cash_receipt_id;
437:
438: -- ========================= FND LOG ===========================
439: psa_utils.debug_other_string(g_state_level,l_full_path,
440: ' Create_distributions --> cr_status --> ' || cr_status);
441: -- ========================= FND LOG ===========================
442:
443: IF cr_status IN ('NSF','STOP','REV') THEN

Line 454: psa_utils.debug_other_string(g_state_level,l_full_path,

450: WHERE reference5 = g_cash_receipt_id
451: AND posting_control_id = -3;
452:
453: -- ========================= FND LOG ===========================
454: psa_utils.debug_other_string(g_state_level,l_full_path,
455: ' Create_distributions --> deleting from pas_mf_misc_dist_all for pstctrl -> -3 ');
456: psa_utils.debug_other_string(g_state_level,l_full_path,
457: ' Create_distributions --> records deleted --> ' || SQL%ROWCOUNT);
458: -- ========================= FND LOG ===========================

Line 456: psa_utils.debug_other_string(g_state_level,l_full_path,

452:
453: -- ========================= FND LOG ===========================
454: psa_utils.debug_other_string(g_state_level,l_full_path,
455: ' Create_distributions --> deleting from pas_mf_misc_dist_all for pstctrl -> -3 ');
456: psa_utils.debug_other_string(g_state_level,l_full_path,
457: ' Create_distributions --> records deleted --> ' || SQL%ROWCOUNT);
458: -- ========================= FND LOG ===========================
459:
460: OPEN c_misc_dist_new(g_cash_receipt_id);

Line 472: psa_utils.debug_other_string(g_state_level,l_full_path,

468: WHERE misc_cash_distribution_id = misc_dist_new_rec.misc_cash_distribution_id
469: AND posting_control_id >0;
470:
471: -- ========================= FND LOG ===========================
472: psa_utils.debug_other_string(g_state_level,l_full_path,
473: ' Create_distributions --> psa_count --> ' || psa_count);
474: -- ========================= FND LOG ===========================
475:
476: IF psa_count = 0 THEN

Line 478: psa_utils.debug_other_string(g_state_level,l_full_path,

474: -- ========================= FND LOG ===========================
475:
476: IF psa_count = 0 THEN
477: -- ========================= FND LOG ===========================
478: psa_utils.debug_other_string(g_state_level,l_full_path,
479: ' Create_distributions --> calling PSA_MFAR_UTILS.override_segments ');
480: -- ========================= FND LOG ===========================
481:
482: OPEN c_mfar_dist_rec;

Line 499: psa_utils.debug_other_string(g_state_level,l_full_path,

495:
496: CLOSE c_mfar_dist_rec;
497:
498: -- ========================= FND LOG ===========================
499: psa_utils.debug_other_string(g_state_level,l_full_path,
500: ' Create_distributions --> l_primary_ccid --> ' || l_primary_ccid);
501: psa_utils.debug_other_string(g_state_level,l_full_path,
502: ' Create_distributions --> l_misc_dist_rec.code_combination_id --> '
503: || l_misc_dist_rec.code_combination_id);

Line 501: psa_utils.debug_other_string(g_state_level,l_full_path,

497:
498: -- ========================= FND LOG ===========================
499: psa_utils.debug_other_string(g_state_level,l_full_path,
500: ' Create_distributions --> l_primary_ccid --> ' || l_primary_ccid);
501: psa_utils.debug_other_string(g_state_level,l_full_path,
502: ' Create_distributions --> l_misc_dist_rec.code_combination_id --> '
503: || l_misc_dist_rec.code_combination_id);
504: psa_utils.debug_other_string(g_state_level,l_full_path,
505: ' Create_distributions --> g_set_of_books_id --> ' || g_set_of_books_id);

Line 504: psa_utils.debug_other_string(g_state_level,l_full_path,

500: ' Create_distributions --> l_primary_ccid --> ' || l_primary_ccid);
501: psa_utils.debug_other_string(g_state_level,l_full_path,
502: ' Create_distributions --> l_misc_dist_rec.code_combination_id --> '
503: || l_misc_dist_rec.code_combination_id);
504: psa_utils.debug_other_string(g_state_level,l_full_path,
505: ' Create_distributions --> g_set_of_books_id --> ' || g_set_of_books_id);
506: psa_utils.debug_other_string(g_state_level,l_full_path,
507: ' Create_distributions --> l_mf_cash_ccid --> ' || l_mf_cash_ccid);
508: -- ========================= FND LOG ===========================

Line 506: psa_utils.debug_other_string(g_state_level,l_full_path,

502: ' Create_distributions --> l_misc_dist_rec.code_combination_id --> '
503: || l_misc_dist_rec.code_combination_id);
504: psa_utils.debug_other_string(g_state_level,l_full_path,
505: ' Create_distributions --> g_set_of_books_id --> ' || g_set_of_books_id);
506: psa_utils.debug_other_string(g_state_level,l_full_path,
507: ' Create_distributions --> l_mf_cash_ccid --> ' || l_mf_cash_ccid);
508: -- ========================= FND LOG ===========================
509:
510: IF NOT (PSA_MFAR_UTILS.override_segments ( p_primary_ccid => l_primary_ccid,

Line 517: psa_utils.debug_other_string(g_state_level,l_full_path,

513: p_trx_type => 'MISC',
514: p_ccid => l_mf_cash_ccid)) THEN
515:
516: -- ========================= FND LOG ===========================
517: psa_utils.debug_other_string(g_state_level,l_full_path,
518: ' Create_distributions --> calling PSA_MFAR_UTILS.override_segments --> FALSE');
519: -- ========================= FND LOG ===========================
520: RAISE FLEX_BUILD_ERROR;
521: ELSE

Line 523: psa_utils.debug_other_string(g_state_level,l_full_path,

519: -- ========================= FND LOG ===========================
520: RAISE FLEX_BUILD_ERROR;
521: ELSE
522: -- ========================= FND LOG ===========================
523: psa_utils.debug_other_string(g_state_level,l_full_path,
524: ' Create_distributions --> calling PSA_MFAR_UTILS.override_segments --> TRUE');
525: -- ========================= FND LOG ===========================
526:
527: END IF;

Line 530: psa_utils.debug_other_string(g_state_level,l_full_path,

526:
527: END IF;
528:
529: -- ========================= FND LOG ===========================
530: psa_utils.debug_other_string(g_state_level,l_full_path,
531: ' Create_distributions --> calling psa_mf_misc_dist_all_pkg.insert_row ');
532: -- ========================= FND LOG ===========================
533:
534: psa_mf_misc_dist_all_pkg.insert_row

Line 579: psa_utils.debug_other_string(g_state_level,l_full_path,

575: -- No reversal scenario
576: -- count mismatch
577:
578: -- ========================= FND LOG ===========================
579: psa_utils.debug_other_string(g_state_level,l_full_path,
580: ' Create_distributions --> cr_status NOT IN (NSF,STOP,REV)');
581: psa_utils.debug_other_string(g_state_level,l_full_path,
582: ' Create_distributions --> delete from psa_mf_misc_dist_all ');
583: -- ========================= FND LOG ===========================

Line 581: psa_utils.debug_other_string(g_state_level,l_full_path,

577:
578: -- ========================= FND LOG ===========================
579: psa_utils.debug_other_string(g_state_level,l_full_path,
580: ' Create_distributions --> cr_status NOT IN (NSF,STOP,REV)');
581: psa_utils.debug_other_string(g_state_level,l_full_path,
582: ' Create_distributions --> delete from psa_mf_misc_dist_all ');
583: -- ========================= FND LOG ===========================
584:
585: DELETE FROM psa_mf_misc_dist_all

Line 592: psa_utils.debug_other_string(g_state_level,l_full_path,

588: FROM ar_misc_cash_distributions
589: WHERE reference5 = g_cash_receipt_id);
590:
591: -- ========================= FND LOG ===========================
592: psa_utils.debug_other_string(g_state_level,l_full_path,
593: ' Create_distributions --> create_dist_flag - C');
594: -- ========================= FND LOG ===========================
595:
596: create_dist_flag := 'C';

Line 605: psa_utils.debug_other_string(g_state_level,l_full_path,

601:
602: IF create_dist_flag = 'C' THEN
603:
604: -- ========================= FND LOG ===========================
605: psa_utils.debug_other_string(g_state_level,l_full_path,
606: ' Create_distributions --> create_dist_flag is C then');
607: -- ========================= FND LOG ===========================
608:
609: IF c_misc_dist%ISOPEN THEN

Line 614: psa_utils.debug_other_string(g_state_level,l_full_path,

610: CLOSE c_misc_dist;
611: END IF;
612:
613: -- ========================= FND LOG ===========================
614: psa_utils.debug_other_string(g_state_level,l_full_path,
615: ' Create_distributions --> Opening c_misc_dist');
616: -- ========================= FND LOG ===========================
617:
618: OPEN c_misc_dist(g_cash_receipt_id);

Line 625: psa_utils.debug_other_string(g_state_level,l_full_path,

621: FETCH c_misc_dist INTO l_misc_dist_rec;
622: EXIT WHEN c_misc_dist%NOTFOUND;
623:
624: -- ========================= FND LOG ===========================
625: psa_utils.debug_other_string(g_state_level,l_full_path,
626: ' Create_distributions --> Calling PSA_MFAR_UTILS.OVERRIDE_SEGMENTS');
627: -- ========================= FND LOG ===========================
628:
629: OPEN c_mfar_dist_rec;

Line 645: psa_utils.debug_other_string(g_state_level,l_full_path,

641:
642: CLOSE c_mfar_dist_rec;
643:
644: -- ========================= FND LOG ===========================
645: psa_utils.debug_other_string(g_state_level,l_full_path,
646: ' Create_distributions --> l_primary_ccid --> ' || l_primary_ccid);
647: psa_utils.debug_other_string(g_state_level,l_full_path,
648: ' Create_distributions --> l_misc_dist_rec.code_combination_id --> '
649: || l_misc_dist_rec.code_combination_id);

Line 647: psa_utils.debug_other_string(g_state_level,l_full_path,

643:
644: -- ========================= FND LOG ===========================
645: psa_utils.debug_other_string(g_state_level,l_full_path,
646: ' Create_distributions --> l_primary_ccid --> ' || l_primary_ccid);
647: psa_utils.debug_other_string(g_state_level,l_full_path,
648: ' Create_distributions --> l_misc_dist_rec.code_combination_id --> '
649: || l_misc_dist_rec.code_combination_id);
650: psa_utils.debug_other_string(g_state_level,l_full_path,
651: ' Create_distributions --> g_set_of_books_id --> ' || g_set_of_books_id);

Line 650: psa_utils.debug_other_string(g_state_level,l_full_path,

646: ' Create_distributions --> l_primary_ccid --> ' || l_primary_ccid);
647: psa_utils.debug_other_string(g_state_level,l_full_path,
648: ' Create_distributions --> l_misc_dist_rec.code_combination_id --> '
649: || l_misc_dist_rec.code_combination_id);
650: psa_utils.debug_other_string(g_state_level,l_full_path,
651: ' Create_distributions --> g_set_of_books_id --> ' || g_set_of_books_id);
652: psa_utils.debug_other_string(g_state_level,l_full_path,
653: ' Create_distributions --> l_mf_cash_ccid --> ' || l_mf_cash_ccid);
654: -- ========================= FND LOG ===========================

Line 652: psa_utils.debug_other_string(g_state_level,l_full_path,

648: ' Create_distributions --> l_misc_dist_rec.code_combination_id --> '
649: || l_misc_dist_rec.code_combination_id);
650: psa_utils.debug_other_string(g_state_level,l_full_path,
651: ' Create_distributions --> g_set_of_books_id --> ' || g_set_of_books_id);
652: psa_utils.debug_other_string(g_state_level,l_full_path,
653: ' Create_distributions --> l_mf_cash_ccid --> ' || l_mf_cash_ccid);
654: -- ========================= FND LOG ===========================
655:
656: IF NOT (PSA_MFAR_UTILS.OVERRIDE_SEGMENTS(

Line 664: psa_utils.debug_other_string(g_state_level,l_full_path,

660: p_trx_type => 'MISC',
661: p_ccid => l_mf_cash_ccid)) THEN
662:
663: -- ========================= FND LOG ===========================
664: psa_utils.debug_other_string(g_state_level,l_full_path,
665: ' Create_distributions --> Calling PSA_MFAR_UTILS.OVERRIDE_SEGMENTS -- FALSE');
666: -- ========================= FND LOG ===========================
667: RAISE FLEX_BUILD_ERROR;
668: ELSE

Line 670: psa_utils.debug_other_string(g_state_level,l_full_path,

666: -- ========================= FND LOG ===========================
667: RAISE FLEX_BUILD_ERROR;
668: ELSE
669: -- ========================= FND LOG ===========================
670: psa_utils.debug_other_string(g_state_level,l_full_path,
671: ' Create_distributions --> Calling PSA_MFAR_UTILS.OVERRIDE_SEGMENTS -- TRUE');
672: -- ========================= FND LOG ===========================
673: END IF;
674:

Line 676: psa_utils.debug_other_string(g_state_level,l_full_path,

672: -- ========================= FND LOG ===========================
673: END IF;
674:
675: -- ========================= FND LOG ===========================
676: psa_utils.debug_other_string(g_state_level,l_full_path,
677: ' Create_distributions --> Calling psa_mf_misc_dist_all_pkg.insert_row ');
678: -- ========================= FND LOG ===========================
679:
680: SELECT first_posted_record_flag INTO first_rec_flag

Line 729: psa_utils.debug_other_string(g_state_level,l_full_path,' Create_distributions --> End ');

725: CLOSE c_misc_dist;
726: END IF;
727: END LOOP;
728: -- ========================= FND LOG ===========================
729: psa_utils.debug_other_string(g_state_level,l_full_path,' Create_distributions --> End ');
730: -- ========================= FND LOG ===========================
731:
732: retcode := 'S';
733: RETURN TRUE;

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

735: EXCEPTION
736: WHEN FLEX_BUILD_ERROR THEN
737: p_error_message:= 'EXCEPTION - FLEX_BUILD_ERROR PACKAGE - PSA_MF_MISC_PKG.CREATE_DISTRIBUTIONS - '||FND_MESSAGE.GET;
738: -- ========================= FND LOG ===========================
739: psa_utils.debug_other_string(g_excep_level,l_full_path,p_error_message);
740: -- ========================= FND LOG ===========================
741: retcode := 'F';
742: RETURN FALSE;
743:

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

743:
744: WHEN OTHERS THEN
745: p_error_message:= 'EXCEPTION - OTHERS PACKAGE - PSA_MF_MISC_PKG.CREATE_DISTRIBUTIONS - '||sqlerrm;
746: -- ========================= FND LOG ===========================
747: psa_utils.debug_other_string(g_excep_level,l_full_path,p_error_message);
748: psa_utils.debug_unexpected_msg(l_full_path);
749: -- ========================= FND LOG ===========================
750: retcode := 'F';
751: RETURN FALSE;

Line 748: psa_utils.debug_unexpected_msg(l_full_path);

744: WHEN OTHERS THEN
745: p_error_message:= 'EXCEPTION - OTHERS PACKAGE - PSA_MF_MISC_PKG.CREATE_DISTRIBUTIONS - '||sqlerrm;
746: -- ========================= FND LOG ===========================
747: psa_utils.debug_other_string(g_excep_level,l_full_path,p_error_message);
748: psa_utils.debug_unexpected_msg(l_full_path);
749: -- ========================= FND LOG ===========================
750: retcode := 'F';
751: RETURN FALSE;
752:

Line 766: psa_utils.debug_other_string(g_state_level,l_full_path,' Misc_rct_changed --> start ');

762: -- ========================= FND LOG ===========================
763:
764: BEGIN
765: -- ========================= FND LOG ===========================
766: psa_utils.debug_other_string(g_state_level,l_full_path,' Misc_rct_changed --> start ');
767: -- ========================= FND LOG ===========================
768:
769: IF p_status IN ('CLEARED','REMITTED') then
770: SELECT count(misc_cash_distribution_id) INTO ar_dist_count

Line 782: psa_utils.debug_other_string(g_state_level,l_full_path,

778: AND amount < 0;
779: END IF;
780:
781: -- ========================= FND LOG ===========================
782: psa_utils.debug_other_string(g_state_level,l_full_path,
783: ' Misc_rct_changed --> ar_dist_count -- ' || ar_dist_count);
784: -- ========================= FND LOG ===========================
785:
786:

Line 795: psa_utils.debug_other_string(g_state_level,l_full_path,

791: AND psa.misc_cash_distribution_id = ar.misc_cash_distribution_id
792: AND ar.cash_receipt_id = g_cash_receipt_id;
793:
794: -- ========================= FND LOG ===========================
795: psa_utils.debug_other_string(g_state_level,l_full_path,
796: ' Misc_rct_changed --> psa_dist_count ' || psa_dist_count);
797: -- ========================= FND LOG ===========================
798:
799:

Line 802: psa_utils.debug_other_string(g_state_level,l_full_path,

798:
799:
800:
801: -- ========================= FND LOG ===========================
802: psa_utils.debug_other_string(g_state_level,l_full_path,
803: ' Misc_rct_changed --> delete psa_mf_misc_dist_all ' || SQL%ROWCOUNT);
804: -- ========================= FND LOG ===========================
805:
806: IF ar_dist_count = psa_dist_count THEN

Line 808: psa_utils.debug_other_string(g_state_level,l_full_path,

804: -- ========================= FND LOG ===========================
805:
806: IF ar_dist_count = psa_dist_count THEN
807: -- ========================= FND LOG ===========================
808: psa_utils.debug_other_string(g_state_level,l_full_path,
809: ' Misc_rct_changed --> ar_dist_count = psa_dist_count RETURN FALSE');
810: -- ========================= FND LOG ===========================
811: RETURN FALSE;
812:

Line 815: psa_utils.debug_other_string(g_state_level,l_full_path,

811: RETURN FALSE;
812:
813: ELSE
814: -- ========================= FND LOG ===========================
815: psa_utils.debug_other_string(g_state_level,l_full_path,
816: ' Misc_rct_changed -->ar_dist_count != psa_dist_count RETURN TRUE');
817: -- ========================= FND LOG ===========================
818: RETURN TRUE;
819: END IF;

Line 824: psa_utils.debug_other_string(g_excep_level,l_full_path,

820:
821: EXCEPTION
822: WHEN OTHERS THEN
823: -- ========================= FND LOG ===========================
824: psa_utils.debug_other_string(g_excep_level,l_full_path,
825: 'EXCEPTION - OTHERS PACKAGE - PSA_MF_MISC_PKG.MISC_RCT_CHANGED - '||sqlerrm);
826: psa_utils.debug_unexpected_msg(l_full_path);
827: -- ========================= FND LOG ===========================
828: RETURN FALSE;

Line 826: psa_utils.debug_unexpected_msg(l_full_path);

822: WHEN OTHERS THEN
823: -- ========================= FND LOG ===========================
824: psa_utils.debug_other_string(g_excep_level,l_full_path,
825: 'EXCEPTION - OTHERS PACKAGE - PSA_MF_MISC_PKG.MISC_RCT_CHANGED - '||sqlerrm);
826: psa_utils.debug_unexpected_msg(l_full_path);
827: -- ========================= FND LOG ===========================
828: RETURN FALSE;
829:
830: END misc_rct_changed;