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 FND_LOG

Line 9: --===========================FND_LOG.START=====================================

5: -- declare global variables
6: g_cash_receipt_id ar_cash_receipts_all.cash_receipt_id%TYPE;
7: g_set_of_books_id gl_sets_of_books.set_of_books_id%TYPE;
8: g_run_id NUMBER(15);
9: --===========================FND_LOG.START=====================================
10: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;
11: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
12: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
13: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;

Line 10: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;

6: g_cash_receipt_id ar_cash_receipts_all.cash_receipt_id%TYPE;
7: g_set_of_books_id gl_sets_of_books.set_of_books_id%TYPE;
8: g_run_id NUMBER(15);
9: --===========================FND_LOG.START=====================================
10: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;
11: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
12: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
13: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
14: g_error_level NUMBER := FND_LOG.LEVEL_ERROR;

Line 11: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

7: g_set_of_books_id gl_sets_of_books.set_of_books_id%TYPE;
8: g_run_id NUMBER(15);
9: --===========================FND_LOG.START=====================================
10: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;
11: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
12: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
13: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
14: g_error_level NUMBER := FND_LOG.LEVEL_ERROR;
15: g_unexp_level NUMBER := FND_LOG.LEVEL_UNEXPECTED;

Line 12: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;

8: g_run_id NUMBER(15);
9: --===========================FND_LOG.START=====================================
10: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;
11: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
12: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
13: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
14: g_error_level NUMBER := FND_LOG.LEVEL_ERROR;
15: g_unexp_level NUMBER := FND_LOG.LEVEL_UNEXPECTED;
16: g_path VARCHAR2(50) := 'PSA.PLSQL.PSAMFMXB.psa_mf_misc_pkg.';

Line 13: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;

9: --===========================FND_LOG.START=====================================
10: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;
11: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
12: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
13: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
14: g_error_level NUMBER := FND_LOG.LEVEL_ERROR;
15: g_unexp_level NUMBER := FND_LOG.LEVEL_UNEXPECTED;
16: g_path VARCHAR2(50) := 'PSA.PLSQL.PSAMFMXB.psa_mf_misc_pkg.';
17: --===========================FND_LOG.END=======================================

Line 14: g_error_level NUMBER := FND_LOG.LEVEL_ERROR;

10: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;
11: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
12: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
13: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
14: g_error_level NUMBER := FND_LOG.LEVEL_ERROR;
15: g_unexp_level NUMBER := FND_LOG.LEVEL_UNEXPECTED;
16: g_path VARCHAR2(50) := 'PSA.PLSQL.PSAMFMXB.psa_mf_misc_pkg.';
17: --===========================FND_LOG.END=======================================
18:

Line 15: g_unexp_level NUMBER := FND_LOG.LEVEL_UNEXPECTED;

11: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
12: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
13: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
14: g_error_level NUMBER := FND_LOG.LEVEL_ERROR;
15: g_unexp_level NUMBER := FND_LOG.LEVEL_UNEXPECTED;
16: g_path VARCHAR2(50) := 'PSA.PLSQL.PSAMFMXB.psa_mf_misc_pkg.';
17: --===========================FND_LOG.END=======================================
18:
19:

Line 17: --===========================FND_LOG.END=======================================

13: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
14: g_error_level NUMBER := FND_LOG.LEVEL_ERROR;
15: g_unexp_level NUMBER := FND_LOG.LEVEL_UNEXPECTED;
16: g_path VARCHAR2(50) := 'PSA.PLSQL.PSAMFMXB.psa_mf_misc_pkg.';
17: --===========================FND_LOG.END=======================================
18:
19:
20: -- Local functions
21:

Line 67: -- ========================= FND LOG ===========================

63: AND ar.cash_receipt_id = g_cash_receipt_id ;
64:
65: match_ccid_rec c_match_ccid%ROWTYPE;
66: mf_dist_count NUMBER;
67: -- ========================= FND LOG ===========================
68: l_full_path VARCHAR2(100) := g_path || 'generate_distributions';
69: -- ========================= FND LOG ===========================
70:
71: BEGIN

Line 69: -- ========================= FND LOG ===========================

65: match_ccid_rec c_match_ccid%ROWTYPE;
66: mf_dist_count NUMBER;
67: -- ========================= FND LOG ===========================
68: l_full_path VARCHAR2(100) := g_path || 'generate_distributions';
69: -- ========================= FND LOG ===========================
70:
71: BEGIN
72:
73: -- All processing will be checked for the Receipt history status since it is possible to

Line 88: -- ========================= FND LOG ===========================

84: g_set_of_books_id := p_set_of_books_id;
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);

Line 96: -- ========================= FND LOG ===========================

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: /*
100: ## Check if Distribution lines already exist in MF Tables

Line 118: -- ========================= FND LOG ===========================

114: AND ar.cash_receipt_id = g_cash_receipt_id
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:

Line 121: -- ========================= FND LOG ===========================

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:
124: IF (mf_dist_count > 0) THEN -- 1 IF
125: -- ========================= FND LOG ===========================

Line 125: -- ========================= FND LOG ===========================

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

Line 128: -- ========================= FND LOG ===========================

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: /*
131: ## MF lines already created
132: ## check if they have been modified:

Line 151: -- ========================= FND LOG ===========================

147: x_status => i.status,
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 ===========================

Line 155: -- ========================= FND LOG ===========================

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

Line 158: -- ========================= FND LOG ===========================

154: || p_error_message);
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 ===========================

Line 162: -- ========================= FND LOG ===========================

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;
164: END IF; -- 5 END IF
165: END IF; -- 4 END IF
166: ELSE

Line 167: -- ========================= FND LOG ===========================

163: RETURN FALSE;
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

Line 170: -- ========================= FND LOG ===========================

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:
173: ELSE
174:

Line 187: -- ========================= FND LOG ===========================

183: FETCH c_match_ccid INTO match_ccid_rec;
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 ===========================

Line 191: -- ========================= FND LOG ===========================

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:
193: IF NOT (PSA_MF_MISC_PKG.create_distributions (
194: errbuf => errbuf,
195: retcode => retcode,

Line 201: -- ========================= FND LOG ===========================

197: p_error_message => p_error_message,
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 ===========================

Line 205: -- ========================= FND LOG ===========================

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:
207: IF NVL(p_report_only,'N') = 'N' THEN
208: -- ========================= FND LOG ===========================
209: psa_utils.debug_other_string(g_excep_level,l_full_path,

Line 208: -- ========================= FND LOG ===========================

204: || p_error_message);
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 ===========================

Line 212: -- ========================= FND LOG ===========================

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;
214: END IF;
215: END IF;
216:

Line 218: -- ========================= FND LOG ===========================

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

Line 221: -- ========================= FND LOG ===========================

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

Line 246: -- ========================= FND LOG ===========================

242: x_status => i.status,
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 ===========================

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

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:
252: IF NVL(p_report_only,'N') = 'N' THEN
253: -- ========================= FND LOG ===========================
254: psa_utils.debug_other_string(g_excep_level,l_full_path,

Line 253: -- ========================= FND LOG ===========================

249: || p_error_message);
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 ===========================

Line 257: -- ========================= FND LOG ===========================

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;
259: END IF;
260: END IF;
261:

Line 263: -- ========================= FND LOG ===========================

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

Line 266: -- ========================= FND LOG ===========================

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:
269: END IF; -- 1 END IF
270: END LOOP;

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

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

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

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';
278: RETURN TRUE;
279:

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

279:
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';

Line 286: -- ========================= FND LOG ===========================

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:
290: END Generate_distributions;

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

379: flex_build_error EXCEPTION;
380: ccid_rec c_cash_ccid%ROWTYPE;
381: l_mfar_dist_rec c_mfar_dist_rec%ROWTYPE;
382: l_primary_ccid NUMBER(15);
383: -- ========================= FND LOG ===========================
384: l_full_path VARCHAR2(100) := g_path || 'create_distributions';
385: -- ========================= FND LOG ===========================
386:
387: BEGIN

Line 385: -- ========================= FND LOG ===========================

381: l_mfar_dist_rec c_mfar_dist_rec%ROWTYPE;
382: l_primary_ccid NUMBER(15);
383: -- ========================= FND LOG ===========================
384: l_full_path VARCHAR2(100) := g_path || 'create_distributions';
385: -- ========================= FND LOG ===========================
386:
387: BEGIN
388:
389: retcode := 'F';

Line 391: -- ========================= FND LOG ===========================

387: BEGIN
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);

Line 397: -- ========================= FND LOG ===========================

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;
401: CLOSE c_cash_ccid;

Line 426: -- ========================= FND LOG ===========================

422: when they get posted to GL.
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 ===========================

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

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:
432: IF create_dist_flag = 'R' THEN
433:
434: SELECT status INTO cr_status

Line 438: -- ========================= FND LOG ===========================

434: SELECT status INTO cr_status
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:

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

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
444:
445: -- we delete records from psa_mf_misc_dist_all when the Dist records

Line 453: -- ========================= FND LOG ===========================

449: DELETE FROM psa_mf_misc_dist_all
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);

Line 458: -- ========================= 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);
461: LOOP
462:

Line 471: -- ========================= FND LOG ===========================

467: FROM psa_mf_misc_dist_all
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:

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

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
477: -- ========================= FND LOG ===========================
478: psa_utils.debug_other_string(g_state_level,l_full_path,

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

473: ' Create_distributions --> psa_count --> ' || psa_count);
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:

Line 480: -- ========================= FND LOG ===========================

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;
483: FETCH c_mfar_dist_rec INTO l_mfar_dist_rec;
484: EXIT WHEN c_mfar_dist_rec%NOTFOUND;

Line 498: -- ========================= FND LOG ===========================

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

Line 508: -- ========================= FND LOG ===========================

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,
511: p_override_ccid => misc_dist_new_rec.code_combination_id,
512: p_set_of_books_id => g_set_of_books_id,

Line 516: -- ========================= FND LOG ===========================

512: p_set_of_books_id => g_set_of_books_id,
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;

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

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
522: -- ========================= FND LOG ===========================
523: psa_utils.debug_other_string(g_state_level,l_full_path,

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

518: ' Create_distributions --> calling PSA_MFAR_UTILS.override_segments --> FALSE');
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:

Line 525: -- ========================= FND LOG ===========================

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

Line 529: -- ========================= FND LOG ===========================

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

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

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
535: (
536: X_ROWID => x_dummy,

Line 578: -- ========================= FND LOG ===========================

574: -- cr_status NOT IN ('NSF','STOP','REV')
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 ');

Line 583: -- ========================= 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
586: WHERE misc_cash_distribution_id IN
587: (SELECT misc_cash_distribution_id

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

587: (SELECT misc_cash_distribution_id
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:

Line 594: -- ========================= FND LOG ===========================

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';
597:
598: END IF;

Line 604: -- ========================= FND LOG ===========================

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

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

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
610: CLOSE c_misc_dist;
611: END IF;

Line 613: -- ========================= FND LOG ===========================

609: IF c_misc_dist%ISOPEN THEN
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:

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

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);
619: LOOP
620:

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

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

Line 627: -- ========================= FND LOG ===========================

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;
630: FETCH c_mfar_dist_rec INTO l_mfar_dist_rec;
631:

Line 644: -- ========================= FND LOG ===========================

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

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

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(
657: p_primary_ccid => l_primary_ccid,
658: p_override_ccid => l_misc_dist_rec.code_combination_id,

Line 663: -- ========================= FND LOG ===========================

659: p_set_of_books_id => g_set_of_books_id,
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;

Line 666: -- ========================= FND LOG ===========================

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
669: -- ========================= FND LOG ===========================
670: psa_utils.debug_other_string(g_state_level,l_full_path,

Line 669: -- ========================= FND LOG ===========================

665: ' Create_distributions --> Calling PSA_MFAR_UTILS.OVERRIDE_SEGMENTS -- FALSE');
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;

Line 672: -- ========================= FND LOG ===========================

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:
675: -- ========================= FND LOG ===========================
676: psa_utils.debug_other_string(g_state_level,l_full_path,

Line 675: -- ========================= FND LOG ===========================

671: ' Create_distributions --> Calling PSA_MFAR_UTILS.OVERRIDE_SEGMENTS -- TRUE');
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:

Line 678: -- ========================= FND LOG ===========================

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
681: FROM ar_cash_receipt_history
682: WHERE cash_receipt_history_id = x_cash_receipt_hist_id;

Line 728: -- ========================= FND LOG ===========================

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

Line 730: -- ========================= FND LOG ===========================

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

Line 738: -- ========================= FND LOG ===========================

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

Line 740: -- ========================= FND LOG ===========================

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

Line 746: -- ========================= FND LOG ===========================

742: RETURN FALSE;
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';

Line 749: -- ========================= FND LOG ===========================

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

Line 760: -- ========================= FND LOG ===========================

756:
757: FUNCTION misc_rct_changed(p_status IN VARCHAR2) RETURN BOOLEAN IS
758: ar_dist_count NUMBER := 0;
759: psa_dist_count NUMBER := 0;
760: -- ========================= FND LOG ===========================
761: l_full_path VARCHAR2(100) := g_path || 'misc_rct_changed';
762: -- ========================= FND LOG ===========================
763:
764: BEGIN

Line 762: -- ========================= FND LOG ===========================

758: ar_dist_count NUMBER := 0;
759: psa_dist_count NUMBER := 0;
760: -- ========================= FND LOG ===========================
761: l_full_path VARCHAR2(100) := g_path || 'misc_rct_changed';
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 ');

Line 765: -- ========================= FND LOG ===========================

761: l_full_path VARCHAR2(100) := g_path || 'misc_rct_changed';
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

Line 767: -- ========================= 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
771: FROM ar_misc_cash_distributions

Line 781: -- ========================= FND LOG ===========================

777: WHERE cash_receipt_id = g_cash_receipt_id
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:

Line 784: -- ========================= FND LOG ===========================

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:
787: SELECT COUNT(MISC_MF_CASH_DIST_ID) INTO psa_dist_count
788: FROM psa_mf_misc_dist_all psa,

Line 794: -- ========================= FND LOG ===========================

790: WHERE psa.reference1 = p_status
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:

Line 797: -- ========================= FND LOG ===========================

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

Line 801: -- ========================= FND LOG ===========================

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

Line 804: -- ========================= FND LOG ===========================

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
807: -- ========================= FND LOG ===========================
808: psa_utils.debug_other_string(g_state_level,l_full_path,

Line 807: -- ========================= FND LOG ===========================

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

Line 810: -- ========================= FND LOG ===========================

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:
813: ELSE
814: -- ========================= FND LOG ===========================

Line 814: -- ========================= FND LOG ===========================

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

Line 817: -- ========================= FND LOG ===========================

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;
820:
821: EXCEPTION

Line 823: -- ========================= FND LOG ===========================

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

Line 827: -- ========================= FND LOG ===========================

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