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

Line 114: psa_utils.debug_other_string(g_state_level,l_full_path,

110:
111: BEGIN
112:
113: -- ========================= FND LOG ===========================
114: psa_utils.debug_other_string(g_state_level,l_full_path,
115: ' ########################## ');
116: psa_utils.debug_other_string(g_state_level,l_full_path,
117: ' ## Transfer to gl START ## ');
118: psa_utils.debug_other_string(g_state_level,l_full_path,

Line 116: psa_utils.debug_other_string(g_state_level,l_full_path,

112:
113: -- ========================= FND LOG ===========================
114: psa_utils.debug_other_string(g_state_level,l_full_path,
115: ' ########################## ');
116: psa_utils.debug_other_string(g_state_level,l_full_path,
117: ' ## Transfer to gl START ## ');
118: psa_utils.debug_other_string(g_state_level,l_full_path,
119: ' ########################## ');
120: psa_utils.debug_other_string(g_state_level,l_full_path, ' '

Line 118: psa_utils.debug_other_string(g_state_level,l_full_path,

114: psa_utils.debug_other_string(g_state_level,l_full_path,
115: ' ########################## ');
116: psa_utils.debug_other_string(g_state_level,l_full_path,
117: ' ## Transfer to gl START ## ');
118: psa_utils.debug_other_string(g_state_level,l_full_path,
119: ' ########################## ');
120: psa_utils.debug_other_string(g_state_level,l_full_path, ' '
121: || to_char (sysdate, 'DD/MM/YYYY HH:MI:SS'));
122: psa_utils.debug_other_string(g_state_level,l_full_path, ' ');

Line 120: psa_utils.debug_other_string(g_state_level,l_full_path, ' '

116: psa_utils.debug_other_string(g_state_level,l_full_path,
117: ' ## Transfer to gl START ## ');
118: psa_utils.debug_other_string(g_state_level,l_full_path,
119: ' ########################## ');
120: psa_utils.debug_other_string(g_state_level,l_full_path, ' '
121: || to_char (sysdate, 'DD/MM/YYYY HH:MI:SS'));
122: psa_utils.debug_other_string(g_state_level,l_full_path, ' ');
123: psa_utils.debug_other_string(g_state_level,l_full_path, ' PROCESS : ');
124: psa_utils.debug_other_string(g_state_level,l_full_path, ' ========= ');

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

118: psa_utils.debug_other_string(g_state_level,l_full_path,
119: ' ########################## ');
120: psa_utils.debug_other_string(g_state_level,l_full_path, ' '
121: || to_char (sysdate, 'DD/MM/YYYY HH:MI:SS'));
122: psa_utils.debug_other_string(g_state_level,l_full_path, ' ');
123: psa_utils.debug_other_string(g_state_level,l_full_path, ' PROCESS : ');
124: psa_utils.debug_other_string(g_state_level,l_full_path, ' ========= ');
125: -- ========================= FND LOG ===========================
126:

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

119: ' ########################## ');
120: psa_utils.debug_other_string(g_state_level,l_full_path, ' '
121: || to_char (sysdate, 'DD/MM/YYYY HH:MI:SS'));
122: psa_utils.debug_other_string(g_state_level,l_full_path, ' ');
123: psa_utils.debug_other_string(g_state_level,l_full_path, ' PROCESS : ');
124: psa_utils.debug_other_string(g_state_level,l_full_path, ' ========= ');
125: -- ========================= FND LOG ===========================
126:
127: /*

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

120: psa_utils.debug_other_string(g_state_level,l_full_path, ' '
121: || to_char (sysdate, 'DD/MM/YYYY HH:MI:SS'));
122: psa_utils.debug_other_string(g_state_level,l_full_path, ' ');
123: psa_utils.debug_other_string(g_state_level,l_full_path, ' PROCESS : ');
124: psa_utils.debug_other_string(g_state_level,l_full_path, ' ========= ');
125: -- ========================= FND LOG ===========================
126:
127: /*
128: ## This procedure will call the procedures in the following order

Line 146: psa_utils.debug_other_string(g_state_level,l_full_path,

142:
143: l_pst_ctrl_id := p_pst_ctrl_id;
144:
145: -- ========================= FND LOG ===========================
146: psa_utils.debug_other_string(g_state_level,l_full_path,
147: ' ##> value of l_pst_ctrl_id set to '||p_pst_ctrl_id);
148: psa_utils.debug_other_string(g_state_level,l_full_path,
149: ' ##> setting savepoint PSA_PSAMFG2B ');
150: -- ========================= FND LOG ===========================

Line 148: psa_utils.debug_other_string(g_state_level,l_full_path,

144:
145: -- ========================= FND LOG ===========================
146: psa_utils.debug_other_string(g_state_level,l_full_path,
147: ' ##> value of l_pst_ctrl_id set to '||p_pst_ctrl_id);
148: psa_utils.debug_other_string(g_state_level,l_full_path,
149: ' ##> setting savepoint PSA_PSAMFG2B ');
150: -- ========================= FND LOG ===========================
151: SAVEPOINT PSA_PSAMFG2B;
152:

Line 154: psa_utils.debug_other_string(g_state_level,l_full_path,

150: -- ========================= FND LOG ===========================
151: SAVEPOINT PSA_PSAMFG2B;
152:
153: -- ========================= FND LOG ===========================
154: psa_utils.debug_other_string(g_state_level,l_full_path,
155: ' ##> Now populating global variables ');
156: -- ========================= FND LOG ===========================
157: Populate_global_variables;
158:

Line 160: psa_utils.debug_other_string(g_state_level,l_full_path,

156: -- ========================= FND LOG ===========================
157: Populate_global_variables;
158:
159: -- ========================= FND LOG ===========================
160: psa_utils.debug_other_string(g_state_level,l_full_path,
161: ' ##> Trasferring data to GL interface ');
162: -- ========================= FND LOG ===========================
163:
164: IF arp_global.sysparam.accounting_method = 'ACCRUAL' THEN

Line 167: psa_utils.debug_other_string(g_state_level,l_full_path,

163:
164: IF arp_global.sysparam.accounting_method = 'ACCRUAL' THEN
165:
166: -- ========================= FND LOG ===========================
167: psa_utils.debug_other_string(g_state_level,l_full_path,
168: ' arp_global.sysparam.accounting_method ==> ACCRUAL ');
169: psa_utils.debug_other_string(g_state_level,l_full_path,
170: ' --> Calling Reverse_core_entries_if_any');
171: -- ========================= FND LOG ===========================

Line 169: psa_utils.debug_other_string(g_state_level,l_full_path,

165:
166: -- ========================= FND LOG ===========================
167: psa_utils.debug_other_string(g_state_level,l_full_path,
168: ' arp_global.sysparam.accounting_method ==> ACCRUAL ');
169: psa_utils.debug_other_string(g_state_level,l_full_path,
170: ' --> Calling Reverse_core_entries_if_any');
171: -- ========================= FND LOG ===========================
172:
173: -- Bug 3621280.

Line 181: psa_utils.debug_other_string(g_state_level,l_full_path,

177: p_set_of_books_id,
178: l_error_message);
179:
180: -- ========================= FND LOG ===========================
181: psa_utils.debug_other_string(g_state_level,l_full_path,
182: ' retcode ==> ' || retcode);
183: -- ========================= FND LOG ===========================
184:
185: IF retcode = 'F' THEN

Line 190: psa_utils.debug_other_string(g_state_level,l_full_path,

186: RAISE MFAR_PROC_EXCEPTION;
187: END IF;
188:
189: -- ========================= FND LOG ===========================
190: psa_utils.debug_other_string(g_state_level,l_full_path,
191: ' Calling MFAR_Trx_to_gl ');
192: -- ========================= FND LOG ===========================
193:
194: MFAR_Trx_to_gl ( errbuf,

Line 203: psa_utils.debug_other_string(g_state_level,l_full_path,

199: p_gl_posted_date,
200: p_summary_flag);
201:
202: -- ========================= FND LOG ===========================
203: psa_utils.debug_other_string(g_state_level,l_full_path,
204: ' retcode ==> ' || retcode);
205: -- ========================= FND LOG ===========================
206:
207: IF retcode = 'F' THEN

Line 212: psa_utils.debug_other_string(g_state_level,l_full_path,

208: RAISE MFAR_PROC_EXCEPTION;
209: END IF;
210:
211: -- ========================= FND LOG ===========================
212: psa_utils.debug_other_string(g_state_level,l_full_path,
213: ' Calling MFAR_Rcpt_to_gl ');
214: -- ========================= FND LOG ===========================
215:
216: MFAR_Rcpt_to_gl (errbuf,

Line 225: psa_utils.debug_other_string(g_state_level,l_full_path,

221: p_gl_posted_date,
222: p_summary_flag);
223:
224: -- ========================= FND LOG ===========================
225: psa_utils.debug_other_string(g_state_level,l_full_path,
226: ' retcode ==> ' || retcode);
227: -- ========================= FND LOG ===========================
228:
229: IF retcode = 'F' THEN

Line 234: psa_utils.debug_other_string(g_state_level,l_full_path,

230: RAISE MFAR_PROC_EXCEPTION;
231: END IF;
232:
233: -- ========================= FND LOG ===========================
234: psa_utils.debug_other_string(g_state_level,l_full_path,
235: ' Calling Misc_rct_to_gl ');
236: -- ========================= FND LOG ===========================
237:
238: Misc_rct_to_gl( errbuf,

Line 246: psa_utils.debug_other_string(g_state_level,l_full_path,

242: p_gl_date_to ,
243: p_gl_posted_date);
244:
245: -- ========================= FND LOG ===========================
246: psa_utils.debug_other_string(g_state_level,l_full_path,
247: ' retcode ==> ' || retcode);
248: -- ========================= FND LOG ===========================
249:
250: IF retcode = 'F' THEN

Line 255: psa_utils.debug_other_string(g_state_level,l_full_path,

251: RAISE MFAR_PROC_EXCEPTION;
252: END IF;
253:
254: -- ========================= FND LOG ===========================
255: psa_utils.debug_other_string(g_state_level,l_full_path,
256: ' Calling MFAR_Adj_to_gl ');
257: -- ========================= FND LOG ===========================
258:
259: MFAR_Adj_to_gl ( errbuf,

Line 268: psa_utils.debug_other_string(g_state_level,l_full_path,

264: p_gl_posted_date,
265: p_summary_flag);
266:
267: -- ========================= FND LOG ===========================
268: psa_utils.debug_other_string(g_state_level,l_full_path,
269: ' retcode ==> ' || retcode);
270: -- ========================= FND LOG ===========================
271:
272: IF retcode = 'F' THEN

Line 279: psa_utils.debug_other_string(g_state_level,l_full_path,

275:
276: ELSIF arp_global.sysparam.accounting_method = 'CASH' THEN
277:
278: -- ========================= FND LOG ===========================
279: psa_utils.debug_other_string(g_state_level,l_full_path,
280: ' arp_global.sysparam.accounting_method ==> CASH ');
281: psa_utils.debug_other_string(g_state_level,l_full_path,
282: ' Calling MFAR_Rcpt_to_gl_CB ');
283: -- ========================= FND LOG ===========================

Line 281: psa_utils.debug_other_string(g_state_level,l_full_path,

277:
278: -- ========================= FND LOG ===========================
279: psa_utils.debug_other_string(g_state_level,l_full_path,
280: ' arp_global.sysparam.accounting_method ==> CASH ');
281: psa_utils.debug_other_string(g_state_level,l_full_path,
282: ' Calling MFAR_Rcpt_to_gl_CB ');
283: -- ========================= FND LOG ===========================
284:
285: MFAR_Rcpt_to_gl_CB

Line 295: psa_utils.debug_other_string(g_state_level,l_full_path,

291: p_gl_posted_date,
292: p_summary_flag);
293:
294: -- ========================= FND LOG ===========================
295: psa_utils.debug_other_string(g_state_level,l_full_path,
296: ' retcode ==> ' || retcode);
297: -- ========================= FND LOG ===========================
298:
299: IF retcode = 'F' THEN

Line 304: psa_utils.debug_other_string(g_state_level,l_full_path,

300: RAISE MFAR_PROC_EXCEPTION;
301: END IF;
302:
303: -- ========================= FND LOG ===========================
304: psa_utils.debug_other_string(g_state_level,l_full_path,
305: ' Calling Misc_rct_to_gl_CB ');
306: -- ========================= FND LOG ===========================
307:
308: Misc_rct_to_gl_CB

Line 317: psa_utils.debug_other_string(g_state_level,l_full_path,

313: p_gl_date_to ,
314: p_gl_posted_date);
315:
316: -- ========================= FND LOG ===========================
317: psa_utils.debug_other_string(g_state_level,l_full_path,
318: ' retcode ==> ' || retcode);
319: -- ========================= FND LOG ===========================
320:
321: IF retcode = 'F' THEN

Line 329: psa_utils.debug_other_msg(p_level => g_error_level,

325: END IF;
326:
327: IF psa_mfar_utils.g_invalid_index > 0 THEN
328: FND_MESSAGE.SET_NAME ('PSA', 'PSA_INVALID_CODE_COMBINATION');
329: psa_utils.debug_other_msg(p_level => g_error_level,
330: p_full_path => l_full_path,
331: p_remove_from_stack => FALSE);
332: fnd_file.put_line(fnd_file.log, fnd_message.get);
333: fnd_file.put_line(fnd_file.log, ' ');

Line 344: psa_utils.debug_other_string(g_state_level,l_full_path,

340: RAISE MFAR_PROC_EXCEPTION;
341: END IF;
342:
343: -- ========================= FND LOG ===========================
344: psa_utils.debug_other_string(g_state_level,l_full_path,
345: ' ##> Updating GL interface with proper segments ');
346: -- ========================= FND LOG ===========================
347:
348: Upd_seg_in_gl_interface;

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

347:
348: Upd_seg_in_gl_interface;
349:
350: -- ========================= FND LOG ===========================
351: psa_utils.debug_other_string(g_state_level,l_full_path, ' ');
352: psa_utils.debug_other_string(g_state_level,l_full_path,
353: ' ############################## ');
354: psa_utils.debug_other_string(g_state_level,l_full_path,
355: ' #### Transfer to gl END #### ');

Line 352: psa_utils.debug_other_string(g_state_level,l_full_path,

348: Upd_seg_in_gl_interface;
349:
350: -- ========================= FND LOG ===========================
351: psa_utils.debug_other_string(g_state_level,l_full_path, ' ');
352: psa_utils.debug_other_string(g_state_level,l_full_path,
353: ' ############################## ');
354: psa_utils.debug_other_string(g_state_level,l_full_path,
355: ' #### Transfer to gl END #### ');
356: psa_utils.debug_other_string(g_state_level,l_full_path,

Line 354: psa_utils.debug_other_string(g_state_level,l_full_path,

350: -- ========================= FND LOG ===========================
351: psa_utils.debug_other_string(g_state_level,l_full_path, ' ');
352: psa_utils.debug_other_string(g_state_level,l_full_path,
353: ' ############################## ');
354: psa_utils.debug_other_string(g_state_level,l_full_path,
355: ' #### Transfer to gl END #### ');
356: psa_utils.debug_other_string(g_state_level,l_full_path,
357: ' ############################## ');
358: psa_utils.debug_other_string(g_state_level,l_full_path,

Line 356: psa_utils.debug_other_string(g_state_level,l_full_path,

352: psa_utils.debug_other_string(g_state_level,l_full_path,
353: ' ############################## ');
354: psa_utils.debug_other_string(g_state_level,l_full_path,
355: ' #### Transfer to gl END #### ');
356: psa_utils.debug_other_string(g_state_level,l_full_path,
357: ' ############################## ');
358: psa_utils.debug_other_string(g_state_level,l_full_path,
359: ' ' || to_char (sysdate, 'DD/MM/YYYY HH:MI:SS'));
360: -- ========================= FND LOG ===========================

Line 358: psa_utils.debug_other_string(g_state_level,l_full_path,

354: psa_utils.debug_other_string(g_state_level,l_full_path,
355: ' #### Transfer to gl END #### ');
356: psa_utils.debug_other_string(g_state_level,l_full_path,
357: ' ############################## ');
358: psa_utils.debug_other_string(g_state_level,l_full_path,
359: ' ' || to_char (sysdate, 'DD/MM/YYYY HH:MI:SS'));
360: -- ========================= FND LOG ===========================
361:
362: EXCEPTION

Line 365: psa_utils.debug_other_string(g_excep_level,l_full_path,

361:
362: EXCEPTION
363: WHEN MFAR_PROC_EXCEPTION THEN
364: -- ========================= FND LOG ===========================
365: psa_utils.debug_other_string(g_excep_level,l_full_path,
366: 'EXCEPTION - MFAR_PROC_EXCEPTION : ERROR IN PSA_TRANSFER_TO_GL_PKG.TRANSFER_TO_GL');
367: -- ========================= FND LOG ===========================
368:
369: BEGIN

Line 371: psa_utils.debug_other_string(g_excep_level,l_full_path,'Rolling back');

367: -- ========================= FND LOG ===========================
368:
369: BEGIN
370: -- ========================= FND LOG ===========================
371: psa_utils.debug_other_string(g_excep_level,l_full_path,'Rolling back');
372: -- ========================= FND LOG ===========================
373: ROLLBACK TO PSA_PSAMFG2B;
374: EXCEPTION
375: WHEN OTHERS THEN

Line 377: psa_utils.debug_other_string(g_excep_level,l_full_path,

373: ROLLBACK TO PSA_PSAMFG2B;
374: EXCEPTION
375: WHEN OTHERS THEN
376: -- ========================= FND LOG ===========================
377: psa_utils.debug_other_string(g_excep_level,l_full_path,
378: 'EXCEPTION - MFAR_PROC_EXCEPTION : SAVEPOINT ERASED.');
379: -- ========================= FND LOG ===========================
380: END;
381: retcode := 'F';

Line 385: psa_utils.debug_other_string(g_excep_level,l_full_path,'EXCEPTION - OTHERS : ERROR IN PSA_TRANSFER_TO_GL_PKG.TRANSFER_TO_GL');

381: retcode := 'F';
382:
383: WHEN OTHERS THEN
384: -- ========================= FND LOG ===========================
385: psa_utils.debug_other_string(g_excep_level,l_full_path,'EXCEPTION - OTHERS : ERROR IN PSA_TRANSFER_TO_GL_PKG.TRANSFER_TO_GL');
386: psa_utils.debug_other_string(g_excep_level,l_full_path, sqlcode || sqlerrm);
387: psa_utils.debug_unexpected_msg(l_full_path);
388: -- ========================= FND LOG ===========================
389:

Line 386: psa_utils.debug_other_string(g_excep_level,l_full_path, sqlcode || sqlerrm);

382:
383: WHEN OTHERS THEN
384: -- ========================= FND LOG ===========================
385: psa_utils.debug_other_string(g_excep_level,l_full_path,'EXCEPTION - OTHERS : ERROR IN PSA_TRANSFER_TO_GL_PKG.TRANSFER_TO_GL');
386: psa_utils.debug_other_string(g_excep_level,l_full_path, sqlcode || sqlerrm);
387: psa_utils.debug_unexpected_msg(l_full_path);
388: -- ========================= FND LOG ===========================
389:
390: BEGIN

Line 387: psa_utils.debug_unexpected_msg(l_full_path);

383: WHEN OTHERS THEN
384: -- ========================= FND LOG ===========================
385: psa_utils.debug_other_string(g_excep_level,l_full_path,'EXCEPTION - OTHERS : ERROR IN PSA_TRANSFER_TO_GL_PKG.TRANSFER_TO_GL');
386: psa_utils.debug_other_string(g_excep_level,l_full_path, sqlcode || sqlerrm);
387: psa_utils.debug_unexpected_msg(l_full_path);
388: -- ========================= FND LOG ===========================
389:
390: BEGIN
391: -- ========================= FND LOG ===========================

Line 392: psa_utils.debug_other_string(g_excep_level,l_full_path, 'Rolling back');

388: -- ========================= FND LOG ===========================
389:
390: BEGIN
391: -- ========================= FND LOG ===========================
392: psa_utils.debug_other_string(g_excep_level,l_full_path, 'Rolling back');
393: -- ========================= FND LOG ===========================
394: ROLLBACK TO PSA_PSAMFG2B;
395: EXCEPTION
396: WHEN OTHERS THEN

Line 398: psa_utils.debug_other_string(g_excep_level,l_full_path,

394: ROLLBACK TO PSA_PSAMFG2B;
395: EXCEPTION
396: WHEN OTHERS THEN
397: -- ========================= FND LOG ===========================
398: psa_utils.debug_other_string(g_excep_level,l_full_path,
399: 'EXCEPTION - OTHERS : SAVEPOINT ERASED.');
400: -- ========================= FND LOG ===========================
401: END;
402: retcode := 'F';

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

605:
606: BEGIN
607:
608: -- ========================= FND LOG ===========================
609: psa_utils.debug_other_string(g_state_level,l_full_path, ' ');
610: psa_utils.debug_other_string(g_state_level,l_full_path,
611: ' ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~');
612: psa_utils.debug_other_string(g_state_level,l_full_path,
613: ' (TRANSFERRING MISCELLANEOUS RECEIPTS) '

Line 610: psa_utils.debug_other_string(g_state_level,l_full_path,

606: BEGIN
607:
608: -- ========================= FND LOG ===========================
609: psa_utils.debug_other_string(g_state_level,l_full_path, ' ');
610: psa_utils.debug_other_string(g_state_level,l_full_path,
611: ' ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~');
612: psa_utils.debug_other_string(g_state_level,l_full_path,
613: ' (TRANSFERRING MISCELLANEOUS RECEIPTS) '
614: || to_char (sysdate, 'DD/MM/YYYY HH:MI:SS'));

Line 612: psa_utils.debug_other_string(g_state_level,l_full_path,

608: -- ========================= FND LOG ===========================
609: psa_utils.debug_other_string(g_state_level,l_full_path, ' ');
610: psa_utils.debug_other_string(g_state_level,l_full_path,
611: ' ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~');
612: psa_utils.debug_other_string(g_state_level,l_full_path,
613: ' (TRANSFERRING MISCELLANEOUS RECEIPTS) '
614: || to_char (sysdate, 'DD/MM/YYYY HH:MI:SS'));
615: psa_utils.debug_other_string(g_state_level,l_full_path,
616: ' ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~');

Line 615: psa_utils.debug_other_string(g_state_level,l_full_path,

611: ' ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~');
612: psa_utils.debug_other_string(g_state_level,l_full_path,
613: ' (TRANSFERRING MISCELLANEOUS RECEIPTS) '
614: || to_char (sysdate, 'DD/MM/YYYY HH:MI:SS'));
615: psa_utils.debug_other_string(g_state_level,l_full_path,
616: ' ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~');
617: psa_utils.debug_other_string(g_state_level,l_full_path, ' ');
618: -- ========================= FND LOG ===========================
619:

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

613: ' (TRANSFERRING MISCELLANEOUS RECEIPTS) '
614: || to_char (sysdate, 'DD/MM/YYYY HH:MI:SS'));
615: psa_utils.debug_other_string(g_state_level,l_full_path,
616: ' ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~');
617: psa_utils.debug_other_string(g_state_level,l_full_path, ' ');
618: -- ========================= FND LOG ===========================
619:
620: retcode := 'S';
621:

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

623: l_post_through_date := p_gl_date_to;
624: l_sob_id := p_set_of_books_id;
625:
626: -- ========================= FND LOG ===========================
627: psa_utils.debug_other_string(g_state_level,l_full_path, ' ');
628: psa_utils.debug_other_string(g_state_level,l_full_path, ' PARAMETERS :');
629: psa_utils.debug_other_string(g_state_level,l_full_path, ' ============');
630: psa_utils.debug_other_string(g_state_level,l_full_path,
631: ' p_gl_date_from -->' || p_gl_date_from );

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

624: l_sob_id := p_set_of_books_id;
625:
626: -- ========================= FND LOG ===========================
627: psa_utils.debug_other_string(g_state_level,l_full_path, ' ');
628: psa_utils.debug_other_string(g_state_level,l_full_path, ' PARAMETERS :');
629: psa_utils.debug_other_string(g_state_level,l_full_path, ' ============');
630: psa_utils.debug_other_string(g_state_level,l_full_path,
631: ' p_gl_date_from -->' || p_gl_date_from );
632: psa_utils.debug_other_string(g_state_level,l_full_path,

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

625:
626: -- ========================= FND LOG ===========================
627: psa_utils.debug_other_string(g_state_level,l_full_path, ' ');
628: psa_utils.debug_other_string(g_state_level,l_full_path, ' PARAMETERS :');
629: psa_utils.debug_other_string(g_state_level,l_full_path, ' ============');
630: psa_utils.debug_other_string(g_state_level,l_full_path,
631: ' p_gl_date_from -->' || p_gl_date_from );
632: psa_utils.debug_other_string(g_state_level,l_full_path,
633: ' p_gl_date_to -->' || p_gl_date_to );

Line 630: psa_utils.debug_other_string(g_state_level,l_full_path,

626: -- ========================= FND LOG ===========================
627: psa_utils.debug_other_string(g_state_level,l_full_path, ' ');
628: psa_utils.debug_other_string(g_state_level,l_full_path, ' PARAMETERS :');
629: psa_utils.debug_other_string(g_state_level,l_full_path, ' ============');
630: psa_utils.debug_other_string(g_state_level,l_full_path,
631: ' p_gl_date_from -->' || p_gl_date_from );
632: psa_utils.debug_other_string(g_state_level,l_full_path,
633: ' p_gl_date_to -->' || p_gl_date_to );
634: psa_utils.debug_other_string(g_state_level,l_full_path,

Line 632: psa_utils.debug_other_string(g_state_level,l_full_path,

628: psa_utils.debug_other_string(g_state_level,l_full_path, ' PARAMETERS :');
629: psa_utils.debug_other_string(g_state_level,l_full_path, ' ============');
630: psa_utils.debug_other_string(g_state_level,l_full_path,
631: ' p_gl_date_from -->' || p_gl_date_from );
632: psa_utils.debug_other_string(g_state_level,l_full_path,
633: ' p_gl_date_to -->' || p_gl_date_to );
634: psa_utils.debug_other_string(g_state_level,l_full_path,
635: ' p_set_of_books_id -->' || p_set_of_books_id);
636: psa_utils.debug_other_string(g_state_level,l_full_path, ' ');

Line 634: psa_utils.debug_other_string(g_state_level,l_full_path,

630: psa_utils.debug_other_string(g_state_level,l_full_path,
631: ' p_gl_date_from -->' || p_gl_date_from );
632: psa_utils.debug_other_string(g_state_level,l_full_path,
633: ' p_gl_date_to -->' || p_gl_date_to );
634: psa_utils.debug_other_string(g_state_level,l_full_path,
635: ' p_set_of_books_id -->' || p_set_of_books_id);
636: psa_utils.debug_other_string(g_state_level,l_full_path, ' ');
637: psa_utils.debug_other_string(g_state_level,l_full_path, ' OTHER VALUES :');
638: psa_utils.debug_other_string(g_state_level,l_full_path, ' ============= ');

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

632: psa_utils.debug_other_string(g_state_level,l_full_path,
633: ' p_gl_date_to -->' || p_gl_date_to );
634: psa_utils.debug_other_string(g_state_level,l_full_path,
635: ' p_set_of_books_id -->' || p_set_of_books_id);
636: psa_utils.debug_other_string(g_state_level,l_full_path, ' ');
637: psa_utils.debug_other_string(g_state_level,l_full_path, ' OTHER VALUES :');
638: psa_utils.debug_other_string(g_state_level,l_full_path, ' ============= ');
639: psa_utils.debug_other_string(g_state_level,l_full_path,
640: ' l_gl_start_date -->' || l_gl_start_date);

Line 637: psa_utils.debug_other_string(g_state_level,l_full_path, ' OTHER VALUES :');

633: ' p_gl_date_to -->' || p_gl_date_to );
634: psa_utils.debug_other_string(g_state_level,l_full_path,
635: ' p_set_of_books_id -->' || p_set_of_books_id);
636: psa_utils.debug_other_string(g_state_level,l_full_path, ' ');
637: psa_utils.debug_other_string(g_state_level,l_full_path, ' OTHER VALUES :');
638: psa_utils.debug_other_string(g_state_level,l_full_path, ' ============= ');
639: psa_utils.debug_other_string(g_state_level,l_full_path,
640: ' l_gl_start_date -->' || l_gl_start_date);
641: psa_utils.debug_other_string(g_state_level,l_full_path,

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

634: psa_utils.debug_other_string(g_state_level,l_full_path,
635: ' p_set_of_books_id -->' || p_set_of_books_id);
636: psa_utils.debug_other_string(g_state_level,l_full_path, ' ');
637: psa_utils.debug_other_string(g_state_level,l_full_path, ' OTHER VALUES :');
638: psa_utils.debug_other_string(g_state_level,l_full_path, ' ============= ');
639: psa_utils.debug_other_string(g_state_level,l_full_path,
640: ' l_gl_start_date -->' || l_gl_start_date);
641: psa_utils.debug_other_string(g_state_level,l_full_path,
642: ' l_post_through_date -->' || l_post_through_date);

Line 639: psa_utils.debug_other_string(g_state_level,l_full_path,

635: ' p_set_of_books_id -->' || p_set_of_books_id);
636: psa_utils.debug_other_string(g_state_level,l_full_path, ' ');
637: psa_utils.debug_other_string(g_state_level,l_full_path, ' OTHER VALUES :');
638: psa_utils.debug_other_string(g_state_level,l_full_path, ' ============= ');
639: psa_utils.debug_other_string(g_state_level,l_full_path,
640: ' l_gl_start_date -->' || l_gl_start_date);
641: psa_utils.debug_other_string(g_state_level,l_full_path,
642: ' l_post_through_date -->' || l_post_through_date);
643: psa_utils.debug_other_string(g_state_level,l_full_path,

Line 641: psa_utils.debug_other_string(g_state_level,l_full_path,

637: psa_utils.debug_other_string(g_state_level,l_full_path, ' OTHER VALUES :');
638: psa_utils.debug_other_string(g_state_level,l_full_path, ' ============= ');
639: psa_utils.debug_other_string(g_state_level,l_full_path,
640: ' l_gl_start_date -->' || l_gl_start_date);
641: psa_utils.debug_other_string(g_state_level,l_full_path,
642: ' l_post_through_date -->' || l_post_through_date);
643: psa_utils.debug_other_string(g_state_level,l_full_path,
644: ' l_sob_id -->' || l_sob_id);
645: psa_utils.debug_other_string(g_state_level,l_full_path, ' ');

Line 643: psa_utils.debug_other_string(g_state_level,l_full_path,

639: psa_utils.debug_other_string(g_state_level,l_full_path,
640: ' l_gl_start_date -->' || l_gl_start_date);
641: psa_utils.debug_other_string(g_state_level,l_full_path,
642: ' l_post_through_date -->' || l_post_through_date);
643: psa_utils.debug_other_string(g_state_level,l_full_path,
644: ' l_sob_id -->' || l_sob_id);
645: psa_utils.debug_other_string(g_state_level,l_full_path, ' ');
646: psa_utils.debug_other_string(g_state_level,l_full_path, ' PROCESS :');
647: psa_utils.debug_other_string(g_state_level,l_full_path, ' =========');

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

641: psa_utils.debug_other_string(g_state_level,l_full_path,
642: ' l_post_through_date -->' || l_post_through_date);
643: psa_utils.debug_other_string(g_state_level,l_full_path,
644: ' l_sob_id -->' || l_sob_id);
645: psa_utils.debug_other_string(g_state_level,l_full_path, ' ');
646: psa_utils.debug_other_string(g_state_level,l_full_path, ' PROCESS :');
647: psa_utils.debug_other_string(g_state_level,l_full_path, ' =========');
648: psa_utils.debug_other_string(g_state_level,l_full_path, ' ');
649: -- ========================= FND LOG ===========================

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

642: ' l_post_through_date -->' || l_post_through_date);
643: psa_utils.debug_other_string(g_state_level,l_full_path,
644: ' l_sob_id -->' || l_sob_id);
645: psa_utils.debug_other_string(g_state_level,l_full_path, ' ');
646: psa_utils.debug_other_string(g_state_level,l_full_path, ' PROCESS :');
647: psa_utils.debug_other_string(g_state_level,l_full_path, ' =========');
648: psa_utils.debug_other_string(g_state_level,l_full_path, ' ');
649: -- ========================= FND LOG ===========================
650:

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

643: psa_utils.debug_other_string(g_state_level,l_full_path,
644: ' l_sob_id -->' || l_sob_id);
645: psa_utils.debug_other_string(g_state_level,l_full_path, ' ');
646: psa_utils.debug_other_string(g_state_level,l_full_path, ' PROCESS :');
647: psa_utils.debug_other_string(g_state_level,l_full_path, ' =========');
648: psa_utils.debug_other_string(g_state_level,l_full_path, ' ');
649: -- ========================= FND LOG ===========================
650:
651: BEGIN

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

644: ' l_sob_id -->' || l_sob_id);
645: psa_utils.debug_other_string(g_state_level,l_full_path, ' ');
646: psa_utils.debug_other_string(g_state_level,l_full_path, ' PROCESS :');
647: psa_utils.debug_other_string(g_state_level,l_full_path, ' =========');
648: psa_utils.debug_other_string(g_state_level,l_full_path, ' ');
649: -- ========================= FND LOG ===========================
650:
651: BEGIN
652:

Line 659: psa_utils.debug_other_string(g_state_level,l_full_path,

655: ## for receipts that fall within the GL DATE parameters.
656: */
657:
658: -- ========================= FND LOG ===========================
659: psa_utils.debug_other_string(g_state_level,l_full_path,
660: ' --> Creating Distributions for Misc Receipts');
661: -- ========================= FND LOG ===========================
662:
663: FOR I IN c_create_dist

Line 678: psa_utils.debug_other_string(g_excep_level,l_full_path,

674: p_error_message => l_error_message,
675: p_report_only => 'N')) THEN
676:
677: -- ========================= FND LOG ===========================
678: psa_utils.debug_other_string(g_excep_level,l_full_path,
679: ' --> PSA_MF_CREATE_DISTRIBUTIONS.create_distributions -> FALSE');
680: -- ========================= FND LOG ===========================
681:
682: IF l_error_message IS NOT NULL OR l_retcode = 'F' THEN

Line 684: psa_utils.debug_other_string(g_excep_level,l_full_path,

680: -- ========================= FND LOG ===========================
681:
682: IF l_error_message IS NOT NULL OR l_retcode = 'F' THEN
683: -- ========================= FND LOG ===========================
684: psa_utils.debug_other_string(g_excep_level,l_full_path,
685: ' --> Raising invalid_distribution');
686: -- ========================= FND LOG ===========================
687: Raise INVALID_DISTRIBUTION;
688: END IF;

Line 691: psa_utils.debug_other_string(g_state_level,l_full_path,

687: Raise INVALID_DISTRIBUTION;
688: END IF;
689: ELSE
690: -- ========================= FND LOG ===========================
691: psa_utils.debug_other_string(g_state_level,l_full_path,
692: ' --> Cash receipt id --> ' || I.cash_receipt_id);
693: -- ========================= FND LOG ===========================
694: END IF;
695: END IF;

Line 701: psa_utils.debug_other_string(g_state_level,l_full_path,

697: END LOOP;
698: END;
699:
700: -- ========================= FND LOG ===========================
701: psa_utils.debug_other_string(g_state_level,l_full_path,
702: ' --> Inserting into GL INTERFACE foor - PSA_MF_MISC_DIST_ALL');
703: -- ========================= FND LOG ===========================
704:
705: FOR J IN Cur_MFAR_mrct_lines

Line 770: psa_utils.debug_other_string(g_state_level,l_full_path,

766: J.ref30);
767:
768: IF (SQL%FOUND) THEN
769: -- ========================= FND LOG ===========================
770: psa_utils.debug_other_string(g_state_level,l_full_path,
771: ' --> Receipt Number ==> ' || J.ref24 );
772: psa_utils.debug_other_string(g_state_level,l_full_path,
773: ' CCID => ' || J.ccid
774: || ' DEBIT => ' || J.entered_dr

Line 772: psa_utils.debug_other_string(g_state_level,l_full_path,

768: IF (SQL%FOUND) THEN
769: -- ========================= FND LOG ===========================
770: psa_utils.debug_other_string(g_state_level,l_full_path,
771: ' --> Receipt Number ==> ' || J.ref24 );
772: psa_utils.debug_other_string(g_state_level,l_full_path,
773: ' CCID => ' || J.ccid
774: || ' DEBIT => ' || J.entered_dr
775: || ' CREDIT => ' || J.entered_cr);
776: -- ========================= FND LOG ===========================

Line 782: psa_utils.debug_other_string(g_state_level,l_full_path,

778:
779: END LOOP;
780:
781: -- ========================= FND LOG ===========================
782: psa_utils.debug_other_string(g_state_level,l_full_path,
783: ' --> Inserting into GL INTERFACE for - PSA_MF_REVERSE_OF_AR_CRH');
784: -- ========================= FND LOG ===========================
785:
786: FOR J IN Cur_MFAR_crct_hist_lines

Line 855: psa_utils.debug_other_string(g_state_level,l_full_path,

851: J.ref30);
852:
853: IF (SQL%FOUND) THEN
854: -- ========================= FND LOG ===========================
855: psa_utils.debug_other_string(g_state_level,l_full_path,
856: ' --> Receipt Number ==> ' || J.ref24);
857: psa_utils.debug_other_string(g_state_level,l_full_path,
858: ' CCID => ' || J.ccid
859: ||' DEBIT => ' || J.entered_dr

Line 857: psa_utils.debug_other_string(g_state_level,l_full_path,

853: IF (SQL%FOUND) THEN
854: -- ========================= FND LOG ===========================
855: psa_utils.debug_other_string(g_state_level,l_full_path,
856: ' --> Receipt Number ==> ' || J.ref24);
857: psa_utils.debug_other_string(g_state_level,l_full_path,
858: ' CCID => ' || J.ccid
859: ||' DEBIT => ' || J.entered_dr
860: ||' CREDIT => ' || J.entered_cr );
861: -- ========================= FND LOG ===========================

Line 930: psa_utils.debug_other_string(g_state_level,l_full_path,

926: K.ref30);
927:
928: IF (SQL%FOUND) THEN
929: -- ========================= FND LOG ===========================
930: psa_utils.debug_other_string(g_state_level,l_full_path,
931: ' --> Receipt Number ==> ' || K.ref24);
932: psa_utils.debug_other_string(g_state_level,l_full_path,
933: ' CCID => ' || K.ccid
934: || ' DEBIT => ' || K.entered_dr

Line 932: psa_utils.debug_other_string(g_state_level,l_full_path,

928: IF (SQL%FOUND) THEN
929: -- ========================= FND LOG ===========================
930: psa_utils.debug_other_string(g_state_level,l_full_path,
931: ' --> Receipt Number ==> ' || K.ref24);
932: psa_utils.debug_other_string(g_state_level,l_full_path,
933: ' CCID => ' || K.ccid
934: || ' DEBIT => ' || K.entered_dr
935: || ' CREDIT => ' || K.entered_cr );
936: -- ========================= FND LOG ===========================

Line 947: psa_utils.debug_other_string(g_state_level,l_full_path,

943: ## each reversing record of AR_CASH_RECEIPT_HISTORY, that we insert into GL_INTERFACE
944: */
945:
946: -- ========================= FND LOG ===========================
947: psa_utils.debug_other_string(g_state_level,l_full_path,
948: ' --> Inserting into psa_misc_posting ');
949: -- ========================= FND LOG ===========================
950:
951: FOR J IN c_crh_post

Line 958: psa_utils.debug_other_string(g_state_level,l_full_path,

954: INSERT INTO psa_misc_posting (cash_receipt_history_id, posting_control_id)
955: VALUES (J.cash_receipt_history_id, l_pst_ctrl_id);
956:
957: -- ========================= FND LOG ===========================
958: psa_utils.debug_other_string(g_state_level,l_full_path,
959: ' --> Cash receipt hist id --> ' || J.cash_receipt_history_id);
960: -- ========================= FND LOG ===========================
961:
962: END LOOP;

Line 972: psa_utils.debug_other_string(g_state_level,l_full_path,

968: WHERE posting_control_id = l_pst_ctrl_id);
969:
970: IF (SQL%FOUND) THEN
971: -- ====================== FND LOG ==========================
972: psa_utils.debug_other_string(g_state_level,l_full_path,
973: ' --> (PSA_MF_MISC_DIST_ALL) Updated Posting control id for '
974: || (SQL%ROWCOUNT));
975: -- ====================== FND LOG ==========================
976: END IF;

Line 991: psa_utils.debug_other_string(g_state_level,l_full_path,

987: WHERE posting_control_id = l_pst_ctrl_id);
988:
989: IF (SQL%FOUND) THEN
990: -- ====================== FND LOG ==========================
991: psa_utils.debug_other_string(g_state_level,l_full_path,
992: ' --> (PSA_MF_MISC_DIST_ALL) Deleted --> '
993: || (SQL%ROWCOUNT));
994: -- ====================== FND LOG ==========================
995: END IF;

Line 998: psa_utils.debug_other_string(g_state_level,l_full_path,

994: -- ====================== FND LOG ==========================
995: END IF;
996:
997: -- ========================= FND LOG ===========================
998: psa_utils.debug_other_string(g_state_level,l_full_path,
999: ' --> END of MISC TRANSACTIONS '
1000: || to_char (sysdate, 'DD/MM/YYYY HH:MI:SS'));
1001: -- ========================= FND LOG ===========================
1002:

Line 1006: psa_utils.debug_other_string(g_excep_level,l_full_path,

1002:
1003: EXCEPTION
1004: WHEN INVALID_DISTRIBUTION THEN
1005: -- ========================= FND LOG ===========================
1006: psa_utils.debug_other_string(g_excep_level,l_full_path,
1007: ' --> EXCEPTION - INVALID_DISTRIBUTION raised during PSA_TRANSFER_TO_GL_PKG.Misc_rct_to_gl ');
1008: psa_utils.debug_other_string(g_excep_level,l_full_path,
1009: ' --> p_error_message --> ' || l_error_message);
1010: -- ========================= FND LOG ===========================

Line 1008: psa_utils.debug_other_string(g_excep_level,l_full_path,

1004: WHEN INVALID_DISTRIBUTION THEN
1005: -- ========================= FND LOG ===========================
1006: psa_utils.debug_other_string(g_excep_level,l_full_path,
1007: ' --> EXCEPTION - INVALID_DISTRIBUTION raised during PSA_TRANSFER_TO_GL_PKG.Misc_rct_to_gl ');
1008: psa_utils.debug_other_string(g_excep_level,l_full_path,
1009: ' --> p_error_message --> ' || l_error_message);
1010: -- ========================= FND LOG ===========================
1011: retcode := 'F';
1012:

Line 1015: psa_utils.debug_other_string(g_excep_level,l_full_path,

1011: retcode := 'F';
1012:
1013: WHEN OTHERS THEN
1014: -- ========================= FND LOG ===========================
1015: psa_utils.debug_other_string(g_excep_level,l_full_path,
1016: ' --> EXCEPTION - OTHERS raised during PSA_TRANSFER_TO_GL_PKG.Misc_rct_to_gl ');
1017: psa_utils.debug_other_string(g_excep_level,l_full_path, sqlcode || sqlerrm);
1018: psa_utils.debug_unexpected_msg(l_full_path);
1019: -- ========================= FND LOG ===========================

Line 1017: psa_utils.debug_other_string(g_excep_level,l_full_path, sqlcode || sqlerrm);

1013: WHEN OTHERS THEN
1014: -- ========================= FND LOG ===========================
1015: psa_utils.debug_other_string(g_excep_level,l_full_path,
1016: ' --> EXCEPTION - OTHERS raised during PSA_TRANSFER_TO_GL_PKG.Misc_rct_to_gl ');
1017: psa_utils.debug_other_string(g_excep_level,l_full_path, sqlcode || sqlerrm);
1018: psa_utils.debug_unexpected_msg(l_full_path);
1019: -- ========================= FND LOG ===========================
1020: errbuf := 2;
1021: retcode := 'F';

Line 1018: psa_utils.debug_unexpected_msg(l_full_path);

1014: -- ========================= FND LOG ===========================
1015: psa_utils.debug_other_string(g_excep_level,l_full_path,
1016: ' --> EXCEPTION - OTHERS raised during PSA_TRANSFER_TO_GL_PKG.Misc_rct_to_gl ');
1017: psa_utils.debug_other_string(g_excep_level,l_full_path, sqlcode || sqlerrm);
1018: psa_utils.debug_unexpected_msg(l_full_path);
1019: -- ========================= FND LOG ===========================
1020: errbuf := 2;
1021: retcode := 'F';
1022:

Line 1156: psa_utils.debug_other_string(g_state_level,l_full_path,

1152:
1153: BEGIN
1154:
1155: -- ========================= FND LOG ===========================
1156: psa_utils.debug_other_string(g_state_level,l_full_path,
1157: ' ');
1158: psa_utils.debug_other_string(g_state_level,l_full_path,
1159: ' ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~' );
1160: psa_utils.debug_other_string(g_state_level,l_full_path,

Line 1158: psa_utils.debug_other_string(g_state_level,l_full_path,

1154:
1155: -- ========================= FND LOG ===========================
1156: psa_utils.debug_other_string(g_state_level,l_full_path,
1157: ' ');
1158: psa_utils.debug_other_string(g_state_level,l_full_path,
1159: ' ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~' );
1160: psa_utils.debug_other_string(g_state_level,l_full_path,
1161: ' (TRANSFERRING TRANSACTIONS) '
1162: || to_char (sysdate, 'DD/MM/YYYY HH:MI:SS'));

Line 1160: psa_utils.debug_other_string(g_state_level,l_full_path,

1156: psa_utils.debug_other_string(g_state_level,l_full_path,
1157: ' ');
1158: psa_utils.debug_other_string(g_state_level,l_full_path,
1159: ' ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~' );
1160: psa_utils.debug_other_string(g_state_level,l_full_path,
1161: ' (TRANSFERRING TRANSACTIONS) '
1162: || to_char (sysdate, 'DD/MM/YYYY HH:MI:SS'));
1163: psa_utils.debug_other_string(g_state_level,l_full_path,
1164: ' ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~');

Line 1163: psa_utils.debug_other_string(g_state_level,l_full_path,

1159: ' ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~' );
1160: psa_utils.debug_other_string(g_state_level,l_full_path,
1161: ' (TRANSFERRING TRANSACTIONS) '
1162: || to_char (sysdate, 'DD/MM/YYYY HH:MI:SS'));
1163: psa_utils.debug_other_string(g_state_level,l_full_path,
1164: ' ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~');
1165: psa_utils.debug_other_string(g_state_level,l_full_path,
1166: ' ');
1167: -- ========================= FND LOG ===========================

Line 1165: psa_utils.debug_other_string(g_state_level,l_full_path,

1161: ' (TRANSFERRING TRANSACTIONS) '
1162: || to_char (sysdate, 'DD/MM/YYYY HH:MI:SS'));
1163: psa_utils.debug_other_string(g_state_level,l_full_path,
1164: ' ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~');
1165: psa_utils.debug_other_string(g_state_level,l_full_path,
1166: ' ');
1167: -- ========================= FND LOG ===========================
1168:
1169: retcode := 'S';

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

1172: l_post_through_date := p_gl_date_to;
1173: l_sob_id := p_set_of_books_id;
1174:
1175: -- ========================= FND LOG ===========================
1176: psa_utils.debug_other_string(g_state_level,l_full_path,' PARAMETERS :');
1177: psa_utils.debug_other_string(g_state_level,l_full_path,' ============');
1178: psa_utils.debug_other_string(g_state_level,l_full_path,' p_gl_date_from -->' || p_gl_date_from );
1179: psa_utils.debug_other_string(g_state_level,l_full_path,' p_gl_date_to -->' || p_gl_date_to );
1180: psa_utils.debug_other_string(g_state_level,l_full_path,' p_summary_flag -->' || p_summary_flag);

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

1173: l_sob_id := p_set_of_books_id;
1174:
1175: -- ========================= FND LOG ===========================
1176: psa_utils.debug_other_string(g_state_level,l_full_path,' PARAMETERS :');
1177: psa_utils.debug_other_string(g_state_level,l_full_path,' ============');
1178: psa_utils.debug_other_string(g_state_level,l_full_path,' p_gl_date_from -->' || p_gl_date_from );
1179: psa_utils.debug_other_string(g_state_level,l_full_path,' p_gl_date_to -->' || p_gl_date_to );
1180: psa_utils.debug_other_string(g_state_level,l_full_path,' p_summary_flag -->' || p_summary_flag);
1181: psa_utils.debug_other_string(g_state_level,l_full_path,' p_set_of_books_id -->' || p_set_of_books_id );

Line 1178: psa_utils.debug_other_string(g_state_level,l_full_path,' p_gl_date_from -->' || p_gl_date_from );

1174:
1175: -- ========================= FND LOG ===========================
1176: psa_utils.debug_other_string(g_state_level,l_full_path,' PARAMETERS :');
1177: psa_utils.debug_other_string(g_state_level,l_full_path,' ============');
1178: psa_utils.debug_other_string(g_state_level,l_full_path,' p_gl_date_from -->' || p_gl_date_from );
1179: psa_utils.debug_other_string(g_state_level,l_full_path,' p_gl_date_to -->' || p_gl_date_to );
1180: psa_utils.debug_other_string(g_state_level,l_full_path,' p_summary_flag -->' || p_summary_flag);
1181: psa_utils.debug_other_string(g_state_level,l_full_path,' p_set_of_books_id -->' || p_set_of_books_id );
1182: psa_utils.debug_other_string(g_state_level,l_full_path,' ');

Line 1179: psa_utils.debug_other_string(g_state_level,l_full_path,' p_gl_date_to -->' || p_gl_date_to );

1175: -- ========================= FND LOG ===========================
1176: psa_utils.debug_other_string(g_state_level,l_full_path,' PARAMETERS :');
1177: psa_utils.debug_other_string(g_state_level,l_full_path,' ============');
1178: psa_utils.debug_other_string(g_state_level,l_full_path,' p_gl_date_from -->' || p_gl_date_from );
1179: psa_utils.debug_other_string(g_state_level,l_full_path,' p_gl_date_to -->' || p_gl_date_to );
1180: psa_utils.debug_other_string(g_state_level,l_full_path,' p_summary_flag -->' || p_summary_flag);
1181: psa_utils.debug_other_string(g_state_level,l_full_path,' p_set_of_books_id -->' || p_set_of_books_id );
1182: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
1183: psa_utils.debug_other_string(g_state_level,l_full_path,' OTHER VALUES :');

Line 1180: psa_utils.debug_other_string(g_state_level,l_full_path,' p_summary_flag -->' || p_summary_flag);

1176: psa_utils.debug_other_string(g_state_level,l_full_path,' PARAMETERS :');
1177: psa_utils.debug_other_string(g_state_level,l_full_path,' ============');
1178: psa_utils.debug_other_string(g_state_level,l_full_path,' p_gl_date_from -->' || p_gl_date_from );
1179: psa_utils.debug_other_string(g_state_level,l_full_path,' p_gl_date_to -->' || p_gl_date_to );
1180: psa_utils.debug_other_string(g_state_level,l_full_path,' p_summary_flag -->' || p_summary_flag);
1181: psa_utils.debug_other_string(g_state_level,l_full_path,' p_set_of_books_id -->' || p_set_of_books_id );
1182: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
1183: psa_utils.debug_other_string(g_state_level,l_full_path,' OTHER VALUES :');
1184: psa_utils.debug_other_string(g_state_level,l_full_path,' ============= ');

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

1177: psa_utils.debug_other_string(g_state_level,l_full_path,' ============');
1178: psa_utils.debug_other_string(g_state_level,l_full_path,' p_gl_date_from -->' || p_gl_date_from );
1179: psa_utils.debug_other_string(g_state_level,l_full_path,' p_gl_date_to -->' || p_gl_date_to );
1180: psa_utils.debug_other_string(g_state_level,l_full_path,' p_summary_flag -->' || p_summary_flag);
1181: psa_utils.debug_other_string(g_state_level,l_full_path,' p_set_of_books_id -->' || p_set_of_books_id );
1182: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
1183: psa_utils.debug_other_string(g_state_level,l_full_path,' OTHER VALUES :');
1184: psa_utils.debug_other_string(g_state_level,l_full_path,' ============= ');
1185: psa_utils.debug_other_string(g_state_level,l_full_path,' GL start date -->' || l_gl_start_date);

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

1178: psa_utils.debug_other_string(g_state_level,l_full_path,' p_gl_date_from -->' || p_gl_date_from );
1179: psa_utils.debug_other_string(g_state_level,l_full_path,' p_gl_date_to -->' || p_gl_date_to );
1180: psa_utils.debug_other_string(g_state_level,l_full_path,' p_summary_flag -->' || p_summary_flag);
1181: psa_utils.debug_other_string(g_state_level,l_full_path,' p_set_of_books_id -->' || p_set_of_books_id );
1182: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
1183: psa_utils.debug_other_string(g_state_level,l_full_path,' OTHER VALUES :');
1184: psa_utils.debug_other_string(g_state_level,l_full_path,' ============= ');
1185: psa_utils.debug_other_string(g_state_level,l_full_path,' GL start date -->' || l_gl_start_date);
1186: psa_utils.debug_other_string(g_state_level,l_full_path,' Post through_date -->' || l_post_through_date);

Line 1183: psa_utils.debug_other_string(g_state_level,l_full_path,' OTHER VALUES :');

1179: psa_utils.debug_other_string(g_state_level,l_full_path,' p_gl_date_to -->' || p_gl_date_to );
1180: psa_utils.debug_other_string(g_state_level,l_full_path,' p_summary_flag -->' || p_summary_flag);
1181: psa_utils.debug_other_string(g_state_level,l_full_path,' p_set_of_books_id -->' || p_set_of_books_id );
1182: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
1183: psa_utils.debug_other_string(g_state_level,l_full_path,' OTHER VALUES :');
1184: psa_utils.debug_other_string(g_state_level,l_full_path,' ============= ');
1185: psa_utils.debug_other_string(g_state_level,l_full_path,' GL start date -->' || l_gl_start_date);
1186: psa_utils.debug_other_string(g_state_level,l_full_path,' Post through_date -->' || l_post_through_date);
1187: psa_utils.debug_other_string(g_state_level,l_full_path,' Set of Books ID -->' || l_sob_id);

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

1180: psa_utils.debug_other_string(g_state_level,l_full_path,' p_summary_flag -->' || p_summary_flag);
1181: psa_utils.debug_other_string(g_state_level,l_full_path,' p_set_of_books_id -->' || p_set_of_books_id );
1182: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
1183: psa_utils.debug_other_string(g_state_level,l_full_path,' OTHER VALUES :');
1184: psa_utils.debug_other_string(g_state_level,l_full_path,' ============= ');
1185: psa_utils.debug_other_string(g_state_level,l_full_path,' GL start date -->' || l_gl_start_date);
1186: psa_utils.debug_other_string(g_state_level,l_full_path,' Post through_date -->' || l_post_through_date);
1187: psa_utils.debug_other_string(g_state_level,l_full_path,' Set of Books ID -->' || l_sob_id);
1188: psa_utils.debug_other_string(g_state_level,l_full_path,' Posting Control ID -->' || l_pst_ctrl_id);

Line 1185: psa_utils.debug_other_string(g_state_level,l_full_path,' GL start date -->' || l_gl_start_date);

1181: psa_utils.debug_other_string(g_state_level,l_full_path,' p_set_of_books_id -->' || p_set_of_books_id );
1182: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
1183: psa_utils.debug_other_string(g_state_level,l_full_path,' OTHER VALUES :');
1184: psa_utils.debug_other_string(g_state_level,l_full_path,' ============= ');
1185: psa_utils.debug_other_string(g_state_level,l_full_path,' GL start date -->' || l_gl_start_date);
1186: psa_utils.debug_other_string(g_state_level,l_full_path,' Post through_date -->' || l_post_through_date);
1187: psa_utils.debug_other_string(g_state_level,l_full_path,' Set of Books ID -->' || l_sob_id);
1188: psa_utils.debug_other_string(g_state_level,l_full_path,' Posting Control ID -->' || l_pst_ctrl_id);
1189: psa_utils.debug_other_string(g_state_level,l_full_path,' ');

Line 1186: psa_utils.debug_other_string(g_state_level,l_full_path,' Post through_date -->' || l_post_through_date);

1182: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
1183: psa_utils.debug_other_string(g_state_level,l_full_path,' OTHER VALUES :');
1184: psa_utils.debug_other_string(g_state_level,l_full_path,' ============= ');
1185: psa_utils.debug_other_string(g_state_level,l_full_path,' GL start date -->' || l_gl_start_date);
1186: psa_utils.debug_other_string(g_state_level,l_full_path,' Post through_date -->' || l_post_through_date);
1187: psa_utils.debug_other_string(g_state_level,l_full_path,' Set of Books ID -->' || l_sob_id);
1188: psa_utils.debug_other_string(g_state_level,l_full_path,' Posting Control ID -->' || l_pst_ctrl_id);
1189: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
1190: psa_utils.debug_other_string(g_state_level,l_full_path,' PROCESS :');

Line 1187: psa_utils.debug_other_string(g_state_level,l_full_path,' Set of Books ID -->' || l_sob_id);

1183: psa_utils.debug_other_string(g_state_level,l_full_path,' OTHER VALUES :');
1184: psa_utils.debug_other_string(g_state_level,l_full_path,' ============= ');
1185: psa_utils.debug_other_string(g_state_level,l_full_path,' GL start date -->' || l_gl_start_date);
1186: psa_utils.debug_other_string(g_state_level,l_full_path,' Post through_date -->' || l_post_through_date);
1187: psa_utils.debug_other_string(g_state_level,l_full_path,' Set of Books ID -->' || l_sob_id);
1188: psa_utils.debug_other_string(g_state_level,l_full_path,' Posting Control ID -->' || l_pst_ctrl_id);
1189: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
1190: psa_utils.debug_other_string(g_state_level,l_full_path,' PROCESS :');
1191: psa_utils.debug_other_string(g_state_level,l_full_path,' =========');

Line 1188: psa_utils.debug_other_string(g_state_level,l_full_path,' Posting Control ID -->' || l_pst_ctrl_id);

1184: psa_utils.debug_other_string(g_state_level,l_full_path,' ============= ');
1185: psa_utils.debug_other_string(g_state_level,l_full_path,' GL start date -->' || l_gl_start_date);
1186: psa_utils.debug_other_string(g_state_level,l_full_path,' Post through_date -->' || l_post_through_date);
1187: psa_utils.debug_other_string(g_state_level,l_full_path,' Set of Books ID -->' || l_sob_id);
1188: psa_utils.debug_other_string(g_state_level,l_full_path,' Posting Control ID -->' || l_pst_ctrl_id);
1189: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
1190: psa_utils.debug_other_string(g_state_level,l_full_path,' PROCESS :');
1191: psa_utils.debug_other_string(g_state_level,l_full_path,' =========');
1192: psa_utils.debug_other_string(g_state_level,l_full_path,' ');

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

1185: psa_utils.debug_other_string(g_state_level,l_full_path,' GL start date -->' || l_gl_start_date);
1186: psa_utils.debug_other_string(g_state_level,l_full_path,' Post through_date -->' || l_post_through_date);
1187: psa_utils.debug_other_string(g_state_level,l_full_path,' Set of Books ID -->' || l_sob_id);
1188: psa_utils.debug_other_string(g_state_level,l_full_path,' Posting Control ID -->' || l_pst_ctrl_id);
1189: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
1190: psa_utils.debug_other_string(g_state_level,l_full_path,' PROCESS :');
1191: psa_utils.debug_other_string(g_state_level,l_full_path,' =========');
1192: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
1193: -- ========================= FND LOG ===========================

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

1186: psa_utils.debug_other_string(g_state_level,l_full_path,' Post through_date -->' || l_post_through_date);
1187: psa_utils.debug_other_string(g_state_level,l_full_path,' Set of Books ID -->' || l_sob_id);
1188: psa_utils.debug_other_string(g_state_level,l_full_path,' Posting Control ID -->' || l_pst_ctrl_id);
1189: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
1190: psa_utils.debug_other_string(g_state_level,l_full_path,' PROCESS :');
1191: psa_utils.debug_other_string(g_state_level,l_full_path,' =========');
1192: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
1193: -- ========================= FND LOG ===========================
1194:

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

1187: psa_utils.debug_other_string(g_state_level,l_full_path,' Set of Books ID -->' || l_sob_id);
1188: psa_utils.debug_other_string(g_state_level,l_full_path,' Posting Control ID -->' || l_pst_ctrl_id);
1189: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
1190: psa_utils.debug_other_string(g_state_level,l_full_path,' PROCESS :');
1191: psa_utils.debug_other_string(g_state_level,l_full_path,' =========');
1192: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
1193: -- ========================= FND LOG ===========================
1194:
1195: FOR I IN Cur_MFAR_cust_trx_id

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

1188: psa_utils.debug_other_string(g_state_level,l_full_path,' Posting Control ID -->' || l_pst_ctrl_id);
1189: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
1190: psa_utils.debug_other_string(g_state_level,l_full_path,' PROCESS :');
1191: psa_utils.debug_other_string(g_state_level,l_full_path,' =========');
1192: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
1193: -- ========================= FND LOG ===========================
1194:
1195: FOR I IN Cur_MFAR_cust_trx_id
1196: LOOP

Line 1200: psa_utils.debug_other_string(g_state_level,l_full_path,

1196: LOOP
1197:
1198: BEGIN
1199: -- ========================= FND LOG ===========================
1200: psa_utils.debug_other_string(g_state_level,l_full_path,
1201: ' --> Creating distribution for Cust trx id ==> '
1202: || l_run_num || ' -- ' || I.customer_trx_id );
1203: -- ========================= FND LOG ===========================
1204:

Line 1214: psa_utils.debug_other_string(g_excep_level,l_full_path,

1210: p_run_id => l_run_num,
1211: p_error_message => l_error_message)) THEN
1212:
1213: -- ========================= FND LOG ===========================
1214: psa_utils.debug_other_string(g_excep_level,l_full_path,
1215: ' --> PSA_MFAR_TRANSACTIONS.create_distributions --> FALSE');
1216: -- ========================= FND LOG ===========================
1217: IF l_error_message IS NOT NULL OR l_retcode = 'F' THEN
1218: -- ========================= FND LOG ===========================

Line 1219: psa_utils.debug_other_string(g_excep_level,l_full_path,

1215: ' --> PSA_MFAR_TRANSACTIONS.create_distributions --> FALSE');
1216: -- ========================= FND LOG ===========================
1217: IF l_error_message IS NOT NULL OR l_retcode = 'F' THEN
1218: -- ========================= FND LOG ===========================
1219: psa_utils.debug_other_string(g_excep_level,l_full_path,
1220: ' --> Raising invalid_distribution');
1221: -- ========================= FND LOG ===========================
1222: Raise invalid_distribution;
1223: END IF;

Line 1227: psa_utils.debug_other_string(g_state_level,l_full_path,

1223: END IF;
1224:
1225: ELSE
1226: -- ========================= FND LOG ===========================
1227: psa_utils.debug_other_string(g_state_level,l_full_path,
1228: ' --> Customer trx id --> ' || I.customer_trx_id);
1229: -- ========================= FND LOG ===========================
1230: END IF;
1231: END;

Line 1239: psa_utils.debug_other_string(g_state_level,l_full_path,

1235: -- when profile FV: Post Detailed Receipt Accounting = 'N'
1236: --
1237:
1238: -- ========================= FND LOG ===========================
1239: psa_utils.debug_other_string(g_state_level,l_full_path,
1240: ' --> l_post_det_acct_flag ==> ' || l_post_det_acct_flag );
1241: -- ========================= FND LOG ===========================
1242:
1243: IF l_post_det_acct_flag = 'N' THEN

Line 1254: psa_utils.debug_other_string(g_state_level,l_full_path,

1250: AND GI.reference30 = 'RA_CUST_TRX_LINE_GL_DIST'
1251: AND GI.reference22 = to_char(I.customer_trx_id);
1252:
1253: -- ========================= FND LOG ===========================
1254: psa_utils.debug_other_string(g_state_level,l_full_path,
1255: ' --> DELETE FROM GL_INTERFACE ' || SQL%ROWCOUNT);
1256: -- ========================= FND LOG ===========================
1257:
1258: END IF;

Line 1268: psa_utils.debug_other_string(g_state_level,l_full_path,

1264: ## For each Cutomer trax id the record will be inserted.
1265: */
1266:
1267: -- ========================= FND LOG ===========================
1268: psa_utils.debug_other_string(g_state_level,l_full_path,
1269: ' --> Customer trx id ==> ' || I.customer_trx_id );
1270: -- ========================= FND LOG ===========================
1271:
1272:

Line 1335: psa_utils.debug_other_string(g_state_level,l_full_path,

1331: J.ref30);
1332:
1333: IF (SQL%FOUND) THEN
1334: -- ========================= FND LOG ===========================
1335: psa_utils.debug_other_string(g_state_level,l_full_path,
1336: ' --> Inserting into GL INTERFACE for ==> '
1337: || I.customer_trx_id );
1338: psa_utils.debug_other_string(g_state_level,l_full_path,
1339: ' CCID => ' || J.ccid

Line 1338: psa_utils.debug_other_string(g_state_level,l_full_path,

1334: -- ========================= FND LOG ===========================
1335: psa_utils.debug_other_string(g_state_level,l_full_path,
1336: ' --> Inserting into GL INTERFACE for ==> '
1337: || I.customer_trx_id );
1338: psa_utils.debug_other_string(g_state_level,l_full_path,
1339: ' CCID => ' || J.ccid
1340: || ' DEBIT => ' || J.entered_dr
1341: || ' CREDIT => ' || J.entered_cr );
1342: -- ========================= FND LOG ===========================

Line 1351: psa_utils.debug_other_string(g_state_level,l_full_path,

1347: END LOOP;
1348:
1349:
1350: -- ========================= FND LOG ===========================
1351: psa_utils.debug_other_string(g_state_level,l_full_path,
1352: ' --> updating psa_mf_trx_dist_all with posting control id ');
1353: -- ========================= FND LOG ===========================
1354:
1355: UPDATE psa_mf_trx_dist_all ptda

Line 1363: psa_utils.debug_other_string(g_state_level,l_full_path,

1359: WHERE rct.posting_control_id = l_pst_ctrl_id);
1360:
1361: IF (SQL%FOUND) THEN
1362: -- ========================= FND LOG ===========================
1363: psa_utils.debug_other_string(g_state_level,l_full_path,
1364: ' --> (PSA_MF_TRX_DIST_ALL) Updated Posting control id for '
1365: || SQL%ROWCOUNT);
1366: -- ========================= FND LOG ===========================
1367: END IF;

Line 1378: psa_utils.debug_other_string(g_state_level,l_full_path,

1374: ( SELECT cust_trx_line_gl_dist_id FROM ra_cust_trx_line_gl_dist rct
1375: WHERE rct.posting_control_id = l_pst_ctrl_id);
1376:
1377: -- ========================= FND LOG ===========================
1378: psa_utils.debug_other_string(g_state_level,l_full_path,
1379: ' --> DELETE FROM psa_mf_trx_dist_all ==> ' || SQL%ROWCOUNT);
1380: psa_utils.debug_other_string(g_state_level,l_full_path,
1381: ' --> END of TRANSACTIONS '
1382: || to_char (sysdate, 'DD/MM/YYYY HH:MI:SS'));

Line 1380: psa_utils.debug_other_string(g_state_level,l_full_path,

1376:
1377: -- ========================= FND LOG ===========================
1378: psa_utils.debug_other_string(g_state_level,l_full_path,
1379: ' --> DELETE FROM psa_mf_trx_dist_all ==> ' || SQL%ROWCOUNT);
1380: psa_utils.debug_other_string(g_state_level,l_full_path,
1381: ' --> END of TRANSACTIONS '
1382: || to_char (sysdate, 'DD/MM/YYYY HH:MI:SS'));
1383: -- ========================= FND LOG ===========================
1384:

Line 1388: psa_utils.debug_other_string(g_excep_level,l_full_path,

1384:
1385: EXCEPTION
1386: WHEN INVALID_DISTRIBUTION THEN
1387: -- ========================= FND LOG ===========================
1388: psa_utils.debug_other_string(g_excep_level,l_full_path,
1389: ' --> EXCEPTION - INVALID_DISTRIBUTION raised during PSA_XFR_TO_GL_PKG.Mfar_trx_to_gl ');
1390: psa_utils.debug_other_string(g_excep_level,l_full_path,
1391: ' --> p_error_message --> ' || l_error_message);
1392: -- ========================= FND LOG ===========================

Line 1390: psa_utils.debug_other_string(g_excep_level,l_full_path,

1386: WHEN INVALID_DISTRIBUTION THEN
1387: -- ========================= FND LOG ===========================
1388: psa_utils.debug_other_string(g_excep_level,l_full_path,
1389: ' --> EXCEPTION - INVALID_DISTRIBUTION raised during PSA_XFR_TO_GL_PKG.Mfar_trx_to_gl ');
1390: psa_utils.debug_other_string(g_excep_level,l_full_path,
1391: ' --> p_error_message --> ' || l_error_message);
1392: -- ========================= FND LOG ===========================
1393: retcode := 'F';
1394:

Line 1397: psa_utils.debug_other_string(g_excep_level,l_full_path,

1393: retcode := 'F';
1394:
1395: WHEN OTHERS THEN
1396: -- ========================= FND LOG ===========================
1397: psa_utils.debug_other_string(g_excep_level,l_full_path,
1398: ' --> EXCEPTION - OTHERS raised during PSA_XFR_TO_GL_PKG.Mfar_trx_to_gl ');
1399: psa_utils.debug_other_string(g_excep_level,l_full_path, sqlcode || sqlerrm);
1400: psa_utils.debug_unexpected_msg(l_full_path);
1401: -- ========================= FND LOG ===========================

Line 1399: psa_utils.debug_other_string(g_excep_level,l_full_path, sqlcode || sqlerrm);

1395: WHEN OTHERS THEN
1396: -- ========================= FND LOG ===========================
1397: psa_utils.debug_other_string(g_excep_level,l_full_path,
1398: ' --> EXCEPTION - OTHERS raised during PSA_XFR_TO_GL_PKG.Mfar_trx_to_gl ');
1399: psa_utils.debug_other_string(g_excep_level,l_full_path, sqlcode || sqlerrm);
1400: psa_utils.debug_unexpected_msg(l_full_path);
1401: -- ========================= FND LOG ===========================
1402: errbuf := 2;
1403: retcode := 'F';

Line 1400: psa_utils.debug_unexpected_msg(l_full_path);

1396: -- ========================= FND LOG ===========================
1397: psa_utils.debug_other_string(g_excep_level,l_full_path,
1398: ' --> EXCEPTION - OTHERS raised during PSA_XFR_TO_GL_PKG.Mfar_trx_to_gl ');
1399: psa_utils.debug_other_string(g_excep_level,l_full_path, sqlcode || sqlerrm);
1400: psa_utils.debug_unexpected_msg(l_full_path);
1401: -- ========================= FND LOG ===========================
1402: errbuf := 2;
1403: retcode := 'F';
1404:

Line 1869: psa_utils.debug_other_string(g_state_level,l_full_path,

1865:
1866: retcode := 'S';
1867:
1868: -- ========================= FND LOG ===========================
1869: psa_utils.debug_other_string(g_state_level,l_full_path,
1870: ' ' );
1871: psa_utils.debug_other_string(g_state_level,l_full_path,
1872: ' ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~' );
1873: psa_utils.debug_other_string(g_state_level,l_full_path,

Line 1871: psa_utils.debug_other_string(g_state_level,l_full_path,

1867:
1868: -- ========================= FND LOG ===========================
1869: psa_utils.debug_other_string(g_state_level,l_full_path,
1870: ' ' );
1871: psa_utils.debug_other_string(g_state_level,l_full_path,
1872: ' ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~' );
1873: psa_utils.debug_other_string(g_state_level,l_full_path,
1874: ' (TRANSFERRING RECEIPTS) '
1875: || to_char (sysdate, 'DD/MM/YYYY HH:MI:SS'));

Line 1873: psa_utils.debug_other_string(g_state_level,l_full_path,

1869: psa_utils.debug_other_string(g_state_level,l_full_path,
1870: ' ' );
1871: psa_utils.debug_other_string(g_state_level,l_full_path,
1872: ' ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~' );
1873: psa_utils.debug_other_string(g_state_level,l_full_path,
1874: ' (TRANSFERRING RECEIPTS) '
1875: || to_char (sysdate, 'DD/MM/YYYY HH:MI:SS'));
1876: psa_utils.debug_other_string(g_state_level,l_full_path,
1877: ' ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~' );

Line 1876: psa_utils.debug_other_string(g_state_level,l_full_path,

1872: ' ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~' );
1873: psa_utils.debug_other_string(g_state_level,l_full_path,
1874: ' (TRANSFERRING RECEIPTS) '
1875: || to_char (sysdate, 'DD/MM/YYYY HH:MI:SS'));
1876: psa_utils.debug_other_string(g_state_level,l_full_path,
1877: ' ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~' );
1878: psa_utils.debug_other_string(g_state_level,l_full_path,
1879: ' ' );
1880: -- ========================= FND LOG ===========================

Line 1878: psa_utils.debug_other_string(g_state_level,l_full_path,

1874: ' (TRANSFERRING RECEIPTS) '
1875: || to_char (sysdate, 'DD/MM/YYYY HH:MI:SS'));
1876: psa_utils.debug_other_string(g_state_level,l_full_path,
1877: ' ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~' );
1878: psa_utils.debug_other_string(g_state_level,l_full_path,
1879: ' ' );
1880: -- ========================= FND LOG ===========================
1881:
1882: l_gl_start_date := p_gl_date_from;

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

1884: l_summary_flag := p_summary_flag;
1885: l_sob_id := p_set_of_books_id;
1886:
1887: -- ========================= FND LOG ===========================
1888: psa_utils.debug_other_string(g_state_level,l_full_path,' PARAMETERS :');
1889: psa_utils.debug_other_string(g_state_level,l_full_path,' ============');
1890: psa_utils.debug_other_string(g_state_level,l_full_path,' p_gl_date_from -->' || p_gl_date_from );
1891: psa_utils.debug_other_string(g_state_level,l_full_path,' p_gl_date_to -->' || p_gl_date_to );
1892: psa_utils.debug_other_string(g_state_level,l_full_path,' p_summary_flag -->' || p_summary_flag );

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

1885: l_sob_id := p_set_of_books_id;
1886:
1887: -- ========================= FND LOG ===========================
1888: psa_utils.debug_other_string(g_state_level,l_full_path,' PARAMETERS :');
1889: psa_utils.debug_other_string(g_state_level,l_full_path,' ============');
1890: psa_utils.debug_other_string(g_state_level,l_full_path,' p_gl_date_from -->' || p_gl_date_from );
1891: psa_utils.debug_other_string(g_state_level,l_full_path,' p_gl_date_to -->' || p_gl_date_to );
1892: psa_utils.debug_other_string(g_state_level,l_full_path,' p_summary_flag -->' || p_summary_flag );
1893: psa_utils.debug_other_string(g_state_level,l_full_path,' p_set_of_books_id -->' || p_set_of_books_id);

Line 1890: psa_utils.debug_other_string(g_state_level,l_full_path,' p_gl_date_from -->' || p_gl_date_from );

1886:
1887: -- ========================= FND LOG ===========================
1888: psa_utils.debug_other_string(g_state_level,l_full_path,' PARAMETERS :');
1889: psa_utils.debug_other_string(g_state_level,l_full_path,' ============');
1890: psa_utils.debug_other_string(g_state_level,l_full_path,' p_gl_date_from -->' || p_gl_date_from );
1891: psa_utils.debug_other_string(g_state_level,l_full_path,' p_gl_date_to -->' || p_gl_date_to );
1892: psa_utils.debug_other_string(g_state_level,l_full_path,' p_summary_flag -->' || p_summary_flag );
1893: psa_utils.debug_other_string(g_state_level,l_full_path,' p_set_of_books_id -->' || p_set_of_books_id);
1894: psa_utils.debug_other_string(g_state_level,l_full_path,' ');

Line 1891: psa_utils.debug_other_string(g_state_level,l_full_path,' p_gl_date_to -->' || p_gl_date_to );

1887: -- ========================= FND LOG ===========================
1888: psa_utils.debug_other_string(g_state_level,l_full_path,' PARAMETERS :');
1889: psa_utils.debug_other_string(g_state_level,l_full_path,' ============');
1890: psa_utils.debug_other_string(g_state_level,l_full_path,' p_gl_date_from -->' || p_gl_date_from );
1891: psa_utils.debug_other_string(g_state_level,l_full_path,' p_gl_date_to -->' || p_gl_date_to );
1892: psa_utils.debug_other_string(g_state_level,l_full_path,' p_summary_flag -->' || p_summary_flag );
1893: psa_utils.debug_other_string(g_state_level,l_full_path,' p_set_of_books_id -->' || p_set_of_books_id);
1894: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
1895: psa_utils.debug_other_string(g_state_level,l_full_path,' OTHER VALUES :');

Line 1892: psa_utils.debug_other_string(g_state_level,l_full_path,' p_summary_flag -->' || p_summary_flag );

1888: psa_utils.debug_other_string(g_state_level,l_full_path,' PARAMETERS :');
1889: psa_utils.debug_other_string(g_state_level,l_full_path,' ============');
1890: psa_utils.debug_other_string(g_state_level,l_full_path,' p_gl_date_from -->' || p_gl_date_from );
1891: psa_utils.debug_other_string(g_state_level,l_full_path,' p_gl_date_to -->' || p_gl_date_to );
1892: psa_utils.debug_other_string(g_state_level,l_full_path,' p_summary_flag -->' || p_summary_flag );
1893: psa_utils.debug_other_string(g_state_level,l_full_path,' p_set_of_books_id -->' || p_set_of_books_id);
1894: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
1895: psa_utils.debug_other_string(g_state_level,l_full_path,' OTHER VALUES :');
1896: psa_utils.debug_other_string(g_state_level,l_full_path,' ============= ');

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

1889: psa_utils.debug_other_string(g_state_level,l_full_path,' ============');
1890: psa_utils.debug_other_string(g_state_level,l_full_path,' p_gl_date_from -->' || p_gl_date_from );
1891: psa_utils.debug_other_string(g_state_level,l_full_path,' p_gl_date_to -->' || p_gl_date_to );
1892: psa_utils.debug_other_string(g_state_level,l_full_path,' p_summary_flag -->' || p_summary_flag );
1893: psa_utils.debug_other_string(g_state_level,l_full_path,' p_set_of_books_id -->' || p_set_of_books_id);
1894: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
1895: psa_utils.debug_other_string(g_state_level,l_full_path,' OTHER VALUES :');
1896: psa_utils.debug_other_string(g_state_level,l_full_path,' ============= ');
1897: psa_utils.debug_other_string(g_state_level,l_full_path,' l_gl_start_date -->' || l_gl_start_date);

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

1890: psa_utils.debug_other_string(g_state_level,l_full_path,' p_gl_date_from -->' || p_gl_date_from );
1891: psa_utils.debug_other_string(g_state_level,l_full_path,' p_gl_date_to -->' || p_gl_date_to );
1892: psa_utils.debug_other_string(g_state_level,l_full_path,' p_summary_flag -->' || p_summary_flag );
1893: psa_utils.debug_other_string(g_state_level,l_full_path,' p_set_of_books_id -->' || p_set_of_books_id);
1894: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
1895: psa_utils.debug_other_string(g_state_level,l_full_path,' OTHER VALUES :');
1896: psa_utils.debug_other_string(g_state_level,l_full_path,' ============= ');
1897: psa_utils.debug_other_string(g_state_level,l_full_path,' l_gl_start_date -->' || l_gl_start_date);
1898: psa_utils.debug_other_string(g_state_level,l_full_path,' l_post_through_date -->' || l_post_through_date);

Line 1895: psa_utils.debug_other_string(g_state_level,l_full_path,' OTHER VALUES :');

1891: psa_utils.debug_other_string(g_state_level,l_full_path,' p_gl_date_to -->' || p_gl_date_to );
1892: psa_utils.debug_other_string(g_state_level,l_full_path,' p_summary_flag -->' || p_summary_flag );
1893: psa_utils.debug_other_string(g_state_level,l_full_path,' p_set_of_books_id -->' || p_set_of_books_id);
1894: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
1895: psa_utils.debug_other_string(g_state_level,l_full_path,' OTHER VALUES :');
1896: psa_utils.debug_other_string(g_state_level,l_full_path,' ============= ');
1897: psa_utils.debug_other_string(g_state_level,l_full_path,' l_gl_start_date -->' || l_gl_start_date);
1898: psa_utils.debug_other_string(g_state_level,l_full_path,' l_post_through_date -->' || l_post_through_date);
1899: psa_utils.debug_other_string(g_state_level,l_full_path,' l_summary_flag -->' || l_summary_flag);

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

1892: psa_utils.debug_other_string(g_state_level,l_full_path,' p_summary_flag -->' || p_summary_flag );
1893: psa_utils.debug_other_string(g_state_level,l_full_path,' p_set_of_books_id -->' || p_set_of_books_id);
1894: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
1895: psa_utils.debug_other_string(g_state_level,l_full_path,' OTHER VALUES :');
1896: psa_utils.debug_other_string(g_state_level,l_full_path,' ============= ');
1897: psa_utils.debug_other_string(g_state_level,l_full_path,' l_gl_start_date -->' || l_gl_start_date);
1898: psa_utils.debug_other_string(g_state_level,l_full_path,' l_post_through_date -->' || l_post_through_date);
1899: psa_utils.debug_other_string(g_state_level,l_full_path,' l_summary_flag -->' || l_summary_flag);
1900: psa_utils.debug_other_string(g_state_level,l_full_path,' l_sob_id -->' || l_sob_id);

Line 1897: psa_utils.debug_other_string(g_state_level,l_full_path,' l_gl_start_date -->' || l_gl_start_date);

1893: psa_utils.debug_other_string(g_state_level,l_full_path,' p_set_of_books_id -->' || p_set_of_books_id);
1894: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
1895: psa_utils.debug_other_string(g_state_level,l_full_path,' OTHER VALUES :');
1896: psa_utils.debug_other_string(g_state_level,l_full_path,' ============= ');
1897: psa_utils.debug_other_string(g_state_level,l_full_path,' l_gl_start_date -->' || l_gl_start_date);
1898: psa_utils.debug_other_string(g_state_level,l_full_path,' l_post_through_date -->' || l_post_through_date);
1899: psa_utils.debug_other_string(g_state_level,l_full_path,' l_summary_flag -->' || l_summary_flag);
1900: psa_utils.debug_other_string(g_state_level,l_full_path,' l_sob_id -->' || l_sob_id);
1901: psa_utils.debug_other_string(g_state_level,l_full_path,' l_pst_ctrl_id -->' || l_pst_ctrl_id );

Line 1898: psa_utils.debug_other_string(g_state_level,l_full_path,' l_post_through_date -->' || l_post_through_date);

1894: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
1895: psa_utils.debug_other_string(g_state_level,l_full_path,' OTHER VALUES :');
1896: psa_utils.debug_other_string(g_state_level,l_full_path,' ============= ');
1897: psa_utils.debug_other_string(g_state_level,l_full_path,' l_gl_start_date -->' || l_gl_start_date);
1898: psa_utils.debug_other_string(g_state_level,l_full_path,' l_post_through_date -->' || l_post_through_date);
1899: psa_utils.debug_other_string(g_state_level,l_full_path,' l_summary_flag -->' || l_summary_flag);
1900: psa_utils.debug_other_string(g_state_level,l_full_path,' l_sob_id -->' || l_sob_id);
1901: psa_utils.debug_other_string(g_state_level,l_full_path,' l_pst_ctrl_id -->' || l_pst_ctrl_id );
1902: psa_utils.debug_other_string(g_state_level,l_full_path,' ');

Line 1899: psa_utils.debug_other_string(g_state_level,l_full_path,' l_summary_flag -->' || l_summary_flag);

1895: psa_utils.debug_other_string(g_state_level,l_full_path,' OTHER VALUES :');
1896: psa_utils.debug_other_string(g_state_level,l_full_path,' ============= ');
1897: psa_utils.debug_other_string(g_state_level,l_full_path,' l_gl_start_date -->' || l_gl_start_date);
1898: psa_utils.debug_other_string(g_state_level,l_full_path,' l_post_through_date -->' || l_post_through_date);
1899: psa_utils.debug_other_string(g_state_level,l_full_path,' l_summary_flag -->' || l_summary_flag);
1900: psa_utils.debug_other_string(g_state_level,l_full_path,' l_sob_id -->' || l_sob_id);
1901: psa_utils.debug_other_string(g_state_level,l_full_path,' l_pst_ctrl_id -->' || l_pst_ctrl_id );
1902: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
1903: psa_utils.debug_other_string(g_state_level,l_full_path,' PROCESS :');

Line 1900: psa_utils.debug_other_string(g_state_level,l_full_path,' l_sob_id -->' || l_sob_id);

1896: psa_utils.debug_other_string(g_state_level,l_full_path,' ============= ');
1897: psa_utils.debug_other_string(g_state_level,l_full_path,' l_gl_start_date -->' || l_gl_start_date);
1898: psa_utils.debug_other_string(g_state_level,l_full_path,' l_post_through_date -->' || l_post_through_date);
1899: psa_utils.debug_other_string(g_state_level,l_full_path,' l_summary_flag -->' || l_summary_flag);
1900: psa_utils.debug_other_string(g_state_level,l_full_path,' l_sob_id -->' || l_sob_id);
1901: psa_utils.debug_other_string(g_state_level,l_full_path,' l_pst_ctrl_id -->' || l_pst_ctrl_id );
1902: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
1903: psa_utils.debug_other_string(g_state_level,l_full_path,' PROCESS :');
1904: psa_utils.debug_other_string(g_state_level,l_full_path,' =========');

Line 1901: psa_utils.debug_other_string(g_state_level,l_full_path,' l_pst_ctrl_id -->' || l_pst_ctrl_id );

1897: psa_utils.debug_other_string(g_state_level,l_full_path,' l_gl_start_date -->' || l_gl_start_date);
1898: psa_utils.debug_other_string(g_state_level,l_full_path,' l_post_through_date -->' || l_post_through_date);
1899: psa_utils.debug_other_string(g_state_level,l_full_path,' l_summary_flag -->' || l_summary_flag);
1900: psa_utils.debug_other_string(g_state_level,l_full_path,' l_sob_id -->' || l_sob_id);
1901: psa_utils.debug_other_string(g_state_level,l_full_path,' l_pst_ctrl_id -->' || l_pst_ctrl_id );
1902: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
1903: psa_utils.debug_other_string(g_state_level,l_full_path,' PROCESS :');
1904: psa_utils.debug_other_string(g_state_level,l_full_path,' =========');
1905: psa_utils.debug_other_string(g_state_level,l_full_path,' ');

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

1898: psa_utils.debug_other_string(g_state_level,l_full_path,' l_post_through_date -->' || l_post_through_date);
1899: psa_utils.debug_other_string(g_state_level,l_full_path,' l_summary_flag -->' || l_summary_flag);
1900: psa_utils.debug_other_string(g_state_level,l_full_path,' l_sob_id -->' || l_sob_id);
1901: psa_utils.debug_other_string(g_state_level,l_full_path,' l_pst_ctrl_id -->' || l_pst_ctrl_id );
1902: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
1903: psa_utils.debug_other_string(g_state_level,l_full_path,' PROCESS :');
1904: psa_utils.debug_other_string(g_state_level,l_full_path,' =========');
1905: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
1906: -- ========================= FND LOG ===========================

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

1899: psa_utils.debug_other_string(g_state_level,l_full_path,' l_summary_flag -->' || l_summary_flag);
1900: psa_utils.debug_other_string(g_state_level,l_full_path,' l_sob_id -->' || l_sob_id);
1901: psa_utils.debug_other_string(g_state_level,l_full_path,' l_pst_ctrl_id -->' || l_pst_ctrl_id );
1902: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
1903: psa_utils.debug_other_string(g_state_level,l_full_path,' PROCESS :');
1904: psa_utils.debug_other_string(g_state_level,l_full_path,' =========');
1905: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
1906: -- ========================= FND LOG ===========================
1907:

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

1900: psa_utils.debug_other_string(g_state_level,l_full_path,' l_sob_id -->' || l_sob_id);
1901: psa_utils.debug_other_string(g_state_level,l_full_path,' l_pst_ctrl_id -->' || l_pst_ctrl_id );
1902: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
1903: psa_utils.debug_other_string(g_state_level,l_full_path,' PROCESS :');
1904: psa_utils.debug_other_string(g_state_level,l_full_path,' =========');
1905: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
1906: -- ========================= FND LOG ===========================
1907:
1908: -- Begin processing of Cleared Receipts - Cash Management

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

1901: psa_utils.debug_other_string(g_state_level,l_full_path,' l_pst_ctrl_id -->' || l_pst_ctrl_id );
1902: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
1903: psa_utils.debug_other_string(g_state_level,l_full_path,' PROCESS :');
1904: psa_utils.debug_other_string(g_state_level,l_full_path,' =========');
1905: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
1906: -- ========================= FND LOG ===========================
1907:
1908: -- Begin processing of Cleared Receipts - Cash Management
1909:

Line 1914: psa_utils.debug_other_string(g_state_level,l_full_path,

1910: FOR K IN c_crh_posted
1911: LOOP
1912:
1913: -- ========================= FND LOG ===========================
1914: psa_utils.debug_other_string(g_state_level,l_full_path,
1915: ' in to cursor c_crh_posted ');
1916: -- ========================= FND LOG ===========================
1917:
1918: FOR I IN Cur_Clr_MFAR_rct_app_id

Line 1930: psa_utils.debug_other_string(g_state_level,l_full_path,

1926: -- This is now set in the initialization routine
1927:
1928: BEGIN
1929: -- ========================= FND LOG ===========================
1930: psa_utils.debug_other_string(g_state_level,l_full_path,
1931: ' --> inside Cur_Clr_MFAR_rct_app_id ');
1932: psa_utils.debug_other_string(g_state_level,l_full_path,
1933: ' --> Creating distribution for receivable_application_id ==> '
1934: || l_run_num || ' -- ' || I.receivable_application_id );

Line 1932: psa_utils.debug_other_string(g_state_level,l_full_path,

1928: BEGIN
1929: -- ========================= FND LOG ===========================
1930: psa_utils.debug_other_string(g_state_level,l_full_path,
1931: ' --> inside Cur_Clr_MFAR_rct_app_id ');
1932: psa_utils.debug_other_string(g_state_level,l_full_path,
1933: ' --> Creating distribution for receivable_application_id ==> '
1934: || l_run_num || ' -- ' || I.receivable_application_id );
1935: -- ========================= FND LOG ===========================
1936:

Line 1946: psa_utils.debug_other_string(g_state_level,l_full_path,

1942: p_run_id => l_run_num,
1943: p_error_message => l_error_message)) THEN
1944:
1945: -- ========================= FND LOG ===========================
1946: psa_utils.debug_other_string(g_state_level,l_full_path,
1947: ' --> PSA_MFAR_RECEIPTS.create_distributions ==> FALSE ');
1948: -- ========================= FND LOG ===========================
1949:
1950: IF l_error_message IS NOT NULL OR l_retcode = 'F' THEN

Line 1952: psa_utils.debug_other_string(g_excep_level,l_full_path,

1948: -- ========================= FND LOG ===========================
1949:
1950: IF l_error_message IS NOT NULL OR l_retcode = 'F' THEN
1951: -- ========================= FND LOG ===========================
1952: psa_utils.debug_other_string(g_excep_level,l_full_path,
1953: ' --> Raising invalid_distribution');
1954: -- ========================= FND LOG ===========================
1955: Raise invalid_distribution;
1956: END IF;

Line 1960: psa_utils.debug_other_string(g_state_level,l_full_path,

1956: END IF;
1957:
1958: ELSE
1959: -- ========================= FND LOG ===========================
1960: psa_utils.debug_other_string(g_state_level,l_full_path,
1961: ' Receivable Application id --> '
1962: || I.receivable_application_id);
1963: -- ========================= FND LOG ===========================
1964: END IF;

Line 1968: psa_utils.debug_other_string(g_state_level,l_full_path,

1964: END IF;
1965: END;
1966:
1967: -- ========================= FND LOG ===========================
1968: psa_utils.debug_other_string(g_state_level,l_full_path,
1969: ' --> Before cursor cur_clr_mfar_rct_lines ');
1970: psa_utils.debug_other_string(g_state_level,l_full_path,
1971: ' --> Receivable Application id ==> ' || I.receivable_application_id );
1972: psa_utils.debug_other_string(g_state_level,l_full_path,

Line 1970: psa_utils.debug_other_string(g_state_level,l_full_path,

1966:
1967: -- ========================= FND LOG ===========================
1968: psa_utils.debug_other_string(g_state_level,l_full_path,
1969: ' --> Before cursor cur_clr_mfar_rct_lines ');
1970: psa_utils.debug_other_string(g_state_level,l_full_path,
1971: ' --> Receivable Application id ==> ' || I.receivable_application_id );
1972: psa_utils.debug_other_string(g_state_level,l_full_path,
1973: ' --> cash_receipt_history_id ==> ' || K.cash_receipt_history_id);
1974: -- ========================= FND LOG ===========================

Line 1972: psa_utils.debug_other_string(g_state_level,l_full_path,

1968: psa_utils.debug_other_string(g_state_level,l_full_path,
1969: ' --> Before cursor cur_clr_mfar_rct_lines ');
1970: psa_utils.debug_other_string(g_state_level,l_full_path,
1971: ' --> Receivable Application id ==> ' || I.receivable_application_id );
1972: psa_utils.debug_other_string(g_state_level,l_full_path,
1973: ' --> cash_receipt_history_id ==> ' || K.cash_receipt_history_id);
1974: -- ========================= FND LOG ===========================
1975:
1976: FOR J IN cur_clr_mfar_rct_lines (I.receivable_application_id, K.cash_receipt_history_id)

Line 1980: psa_utils.debug_other_string(g_state_level,l_full_path,

1976: FOR J IN cur_clr_mfar_rct_lines (I.receivable_application_id, K.cash_receipt_history_id)
1977: LOOP
1978:
1979: -- ========================= FND LOG ===========================
1980: psa_utils.debug_other_string(g_state_level,l_full_path,
1981: ' --> inside cur_clr_mfar_rct_lines ');
1982: psa_utils.debug_other_string(g_state_level,l_full_path,
1983: ' --> J.newstatus ' || J.newstatus || ' and ' ||
1984: ' --> J.oldstatus ' || J.oldstatus );

Line 1982: psa_utils.debug_other_string(g_state_level,l_full_path,

1978:
1979: -- ========================= FND LOG ===========================
1980: psa_utils.debug_other_string(g_state_level,l_full_path,
1981: ' --> inside cur_clr_mfar_rct_lines ');
1982: psa_utils.debug_other_string(g_state_level,l_full_path,
1983: ' --> J.newstatus ' || J.newstatus || ' and ' ||
1984: ' --> J.oldstatus ' || J.oldstatus );
1985: -- ========================= FND LOG ===========================
1986:

Line 1989: psa_utils.debug_other_string(g_state_level,l_full_path,' --> Exiting ');

1985: -- ========================= FND LOG ===========================
1986:
1987: IF (J.newstatus = 'REVERSED') AND (J.oldstatus = 'REMITTED') THEN
1988: -- ========================= FND LOG ===========================
1989: psa_utils.debug_other_string(g_state_level,l_full_path,' --> Exiting ');
1990: -- ========================= FND LOG ===========================
1991: EXIT;
1992: END IF;
1993:

Line 1995: psa_utils.debug_other_string(g_state_level,l_full_path,

1991: EXIT;
1992: END IF;
1993:
1994: -- ========================= FND LOG ===========================
1995: psa_utils.debug_other_string(g_state_level,l_full_path,
1996: ' --> Inserting into gl interface ');
1997: -- ========================= FND LOG ===========================
1998:
1999: INSERT INTO gl_interface

Line 2063: psa_utils.debug_other_string(g_state_level,l_full_path,

2059: NULL);
2060:
2061: IF (SQL%FOUND) THEN
2062: -- ========================= FND LOG ===========================
2063: psa_utils.debug_other_string(g_state_level,l_full_path,
2064: ' --> Inserting into GL INTERFACE for Receipts (Cash Cleared) '||
2065: ' - Receivable Application id ==> ' || I.receivable_application_id);
2066: psa_utils.debug_other_string(g_state_level,l_full_path,
2067: ' CCID => ' || J.ccid

Line 2066: psa_utils.debug_other_string(g_state_level,l_full_path,

2062: -- ========================= FND LOG ===========================
2063: psa_utils.debug_other_string(g_state_level,l_full_path,
2064: ' --> Inserting into GL INTERFACE for Receipts (Cash Cleared) '||
2065: ' - Receivable Application id ==> ' || I.receivable_application_id);
2066: psa_utils.debug_other_string(g_state_level,l_full_path,
2067: ' CCID => ' || J.ccid
2068: || ' DEBIT => ' || J.entered_dr
2069: || ' CREDIT => ' || J.entered_cr );
2070: -- ========================= FND LOG ===========================

Line 2079: psa_utils.debug_other_string(g_state_level,l_full_path,

2075: END LOOP;
2076: END LOOP;
2077:
2078: -- ========================= FND LOG ===========================
2079: psa_utils.debug_other_string(g_state_level,l_full_path,
2080: ' --> Calling PSA_MFAR_RECEIPTS.PURGE_ORPHAN_DISTRIBUTIONS ');
2081: -- ========================= FND LOG ===========================
2082:
2083: -- Bug 3671841, issuing a call to purge orphan distributions

Line 2095: psa_utils.debug_other_string(g_state_level,l_full_path,

2091: WHERE ara.cash_receipt_id = crh.cash_receipt_id AND crh.status = 'CLEARED'
2092: AND crh.posting_control_id = l_pst_ctrl_id) ;
2093:
2094: -- ========================= FND LOG ===========================
2095: psa_utils.debug_other_string(g_state_level,l_full_path,
2096: ' UPDATE psa_mf_rct_dist_all '|| SQL%ROWCOUNT);
2097: -- ========================= FND LOG ===========================
2098:
2099: FOR I IN Cur_MFAR_rct_app_id

Line 2112: psa_utils.debug_other_string(g_state_level,l_full_path,

2108: -- This is now set in the initialization routine.
2109:
2110: BEGIN
2111: -- ========================= FND LOG ===========================
2112: psa_utils.debug_other_string(g_state_level,l_full_path,
2113: ' --> inside cursor Cur_MFAR_rct_app_id ');
2114: psa_utils.debug_other_string(g_state_level,l_full_path,
2115: ' --> Creating distribution for receivable_application_id ==> '
2116: || l_run_num || ' -- ' || I.receivable_application_id );

Line 2114: psa_utils.debug_other_string(g_state_level,l_full_path,

2110: BEGIN
2111: -- ========================= FND LOG ===========================
2112: psa_utils.debug_other_string(g_state_level,l_full_path,
2113: ' --> inside cursor Cur_MFAR_rct_app_id ');
2114: psa_utils.debug_other_string(g_state_level,l_full_path,
2115: ' --> Creating distribution for receivable_application_id ==> '
2116: || l_run_num || ' -- ' || I.receivable_application_id );
2117: -- ========================= FND LOG ===========================
2118:

Line 2128: psa_utils.debug_other_string(g_state_level,l_full_path,

2124: p_run_id => l_run_num,
2125: p_error_message => l_error_message)) THEN
2126:
2127: -- ========================= FND LOG ===========================
2128: psa_utils.debug_other_string(g_state_level,l_full_path,
2129: ' --> PSA_MFAR_RECEIPTS.create_distributions ==> FALSE ');
2130: -- ========================= FND LOG ===========================
2131:
2132: IF l_error_message IS NOT NULL OR l_retcode = 'F' THEN

Line 2134: psa_utils.debug_other_string(g_excep_level,l_full_path,

2130: -- ========================= FND LOG ===========================
2131:
2132: IF l_error_message IS NOT NULL OR l_retcode = 'F' THEN
2133: -- ========================= FND LOG ===========================
2134: psa_utils.debug_other_string(g_excep_level,l_full_path,
2135: ' --> Raising invalid_distribution');
2136: -- ========================= FND LOG ===========================
2137: Raise invalid_distribution;
2138: END IF;

Line 2141: psa_utils.debug_other_string(g_state_level,l_full_path,

2137: Raise invalid_distribution;
2138: END IF;
2139: ELSE
2140: -- ========================= FND LOG ===========================
2141: psa_utils.debug_other_string(g_state_level,l_full_path,
2142: ' --> Receivable Application id --> '
2143: || I.receivable_application_id);
2144: -- ========================= FND LOG ===========================
2145: END IF;

Line 2149: psa_utils.debug_other_string(g_state_level,l_full_path,

2145: END IF;
2146: END;
2147:
2148: -- ========================= FND LOG ===========================
2149: psa_utils.debug_other_string(g_state_level,l_full_path,
2150: ' --> l_post_det_acct_flag ==> ' || l_post_det_acct_flag );
2151: -- ========================= FND LOG ===========================
2152: /* -- Bug 4178626
2153: IF l_post_det_acct_flag = 'N' THEN

Line 2163: psa_utils.debug_other_string(g_state_level,l_full_path,

2159: IF (l_fv_balance_check.sum_acctd_dr IS NOT NULL AND
2160: l_fv_balance_check.sum_acctd_cr IS NOT NULL ) THEN
2161:
2162: -- ========================= FND LOG ===========================
2163: psa_utils.debug_other_string(g_state_level,l_full_path,
2164: ' --> inside if ' );
2165: -- ========================= FND LOG ===========================
2166:
2167: l_rct_post_det_flag := 'N';

Line 2178: psa_utils.debug_other_string(g_state_level,l_full_path,

2174: AND gl.reference10 NOT LIKE 'MFAR%'
2175: AND to_number(substr(gl.reference22, 1, instr(gl.reference22, 'C')-1)) = l_fv_balance_check.cash_receipt_id;
2176:
2177: -- ========================= FND LOG ===========================
2178: psa_utils.debug_other_string(g_state_level,l_full_path,
2179: ' --> DELETE FROM gl_interface -> ' || SQL%ROWCOUNT);
2180: -- ========================= FND LOG ===========================
2181: ELSE
2182: l_rct_post_det_flag := 'Y';

Line 2186: psa_utils.debug_other_string(g_state_level,l_full_path,

2182: l_rct_post_det_flag := 'Y';
2183: END IF;
2184:
2185: -- ========================= FND LOG ===========================
2186: psa_utils.debug_other_string(g_state_level,l_full_path,
2187: ' --> l_rct_post_det_flag -> ' || l_rct_post_det_flag);
2188: -- ========================= FND LOG ===========================
2189: END IF;
2190: -- Bug 4178626 */

Line 2193: psa_utils.debug_other_string(g_state_level,l_full_path,

2189: END IF;
2190: -- Bug 4178626 */
2191:
2192: -- ========================= FND LOG ===========================
2193: psa_utils.debug_other_string(g_state_level,l_full_path,
2194: ' --> Before cursor Cur_mfar_rct_lines ');
2195: -- ========================= FND LOG ===========================
2196:
2197: FOR J IN Cur_mfar_rct_lines (I.receivable_application_id)

Line 2205: psa_utils.debug_other_string(g_state_level,l_full_path,

2201: ## For each receivable app id the record will be INserted.
2202: */
2203:
2204: -- ========================= FND LOG ===========================
2205: psa_utils.debug_other_string(g_state_level,l_full_path,
2206: ' --> inside cursor Cur_mfar_rct_lines ');
2207: psa_utils.debug_other_string(g_state_level,l_full_path,
2208: ' --> Receivable Application id ==> ' || I.receivable_application_id);
2209: psa_utils.debug_other_string(g_state_level,l_full_path,

Line 2207: psa_utils.debug_other_string(g_state_level,l_full_path,

2203:
2204: -- ========================= FND LOG ===========================
2205: psa_utils.debug_other_string(g_state_level,l_full_path,
2206: ' --> inside cursor Cur_mfar_rct_lines ');
2207: psa_utils.debug_other_string(g_state_level,l_full_path,
2208: ' --> Receivable Application id ==> ' || I.receivable_application_id);
2209: psa_utils.debug_other_string(g_state_level,l_full_path,
2210: ' --> inserting into gl_interface ');
2211: -- ========================= FND LOG ===========================

Line 2209: psa_utils.debug_other_string(g_state_level,l_full_path,

2205: psa_utils.debug_other_string(g_state_level,l_full_path,
2206: ' --> inside cursor Cur_mfar_rct_lines ');
2207: psa_utils.debug_other_string(g_state_level,l_full_path,
2208: ' --> Receivable Application id ==> ' || I.receivable_application_id);
2209: psa_utils.debug_other_string(g_state_level,l_full_path,
2210: ' --> inserting into gl_interface ');
2211: -- ========================= FND LOG ===========================
2212:
2213: INSERT INTO gl_interface

Line 2277: psa_utils.debug_other_string(g_state_level,l_full_path,

2273: J.ussgl);
2274:
2275: IF (SQL%FOUND) THEN
2276: -- ========================= FND LOG ===========================
2277: psa_utils.debug_other_string(g_state_level,l_full_path,
2278: ' --> Inserting into GL INTERFACE for Receipts ' ||
2279: ' - Receivable Application id ==> ' || I.receivable_application_id );
2280: psa_utils.debug_other_string(g_state_level,l_full_path,
2281: ' CCID => ' || J.ccid

Line 2280: psa_utils.debug_other_string(g_state_level,l_full_path,

2276: -- ========================= FND LOG ===========================
2277: psa_utils.debug_other_string(g_state_level,l_full_path,
2278: ' --> Inserting into GL INTERFACE for Receipts ' ||
2279: ' - Receivable Application id ==> ' || I.receivable_application_id );
2280: psa_utils.debug_other_string(g_state_level,l_full_path,
2281: ' CCID => ' || J.ccid
2282: || ' DEBIT => ' || J.entered_dr
2283: || ' CREDIT => ' || J.entered_cr );
2284: -- ========================= FND LOG ===========================

Line 2291: psa_utils.debug_other_string(g_state_level,l_full_path,

2287: END LOOP;
2288:
2289: -- Insert accounting lines into gl_interface for on account credit memo
2290: -- ========================= FND LOG ===========================
2291: psa_utils.debug_other_string(g_state_level,l_full_path,
2292: ' --> Before cursor Cur_mfar_rct_lines_cm ');
2293: -- ========================= FND LOG ===========================
2294:
2295:

Line 2304: psa_utils.debug_other_string(g_state_level,l_full_path,

2300: ## For each receivable app id the record will be INserted.
2301: */
2302:
2303: -- ========================= FND LOG ===========================
2304: psa_utils.debug_other_string(g_state_level,l_full_path,
2305: ' --> Inside cursor Cur_mfar_rct_lines_cm ');
2306: psa_utils.debug_other_string(g_state_level,l_full_path,
2307: ' --> Receivable Application id ==> ' || I.receivable_application_id );
2308: -- ========================= FND LOG ===========================

Line 2306: psa_utils.debug_other_string(g_state_level,l_full_path,

2302:
2303: -- ========================= FND LOG ===========================
2304: psa_utils.debug_other_string(g_state_level,l_full_path,
2305: ' --> Inside cursor Cur_mfar_rct_lines_cm ');
2306: psa_utils.debug_other_string(g_state_level,l_full_path,
2307: ' --> Receivable Application id ==> ' || I.receivable_application_id );
2308: -- ========================= FND LOG ===========================
2309:
2310: INSERT INTO gl_interface

Line 2374: psa_utils.debug_other_string(g_state_level,l_full_path,

2370: J.ussgl);
2371:
2372: IF (SQL%FOUND) THEN
2373: -- ========================= FND LOG ===========================
2374: psa_utils.debug_other_string(g_state_level,l_full_path,
2375: ' --> Inserting into GL INTERFACE for Receipts ' ||
2376: ' - Receivable Application id ==> ' || I.receivable_application_id );
2377: psa_utils.debug_other_string(g_state_level,l_full_path,
2378: ' CCID => ' || J.ccid

Line 2377: psa_utils.debug_other_string(g_state_level,l_full_path,

2373: -- ========================= FND LOG ===========================
2374: psa_utils.debug_other_string(g_state_level,l_full_path,
2375: ' --> Inserting into GL INTERFACE for Receipts ' ||
2376: ' - Receivable Application id ==> ' || I.receivable_application_id );
2377: psa_utils.debug_other_string(g_state_level,l_full_path,
2378: ' CCID => ' || J.ccid
2379: || ' DEBIT => ' || J.entered_dr
2380: || ' CREDIT => ' || J.entered_cr );
2381: -- ========================= FND LOG ===========================

Line 2389: psa_utils.debug_other_string(g_state_level,l_full_path,

2385:
2386: END LOOP;
2387:
2388: -- ========================= FND LOG ===========================
2389: psa_utils.debug_other_string(g_state_level,l_full_path,
2390: ' --> Calling PSA_MFAR_RECEIPTS.PURGE_ORPHAN_DISTRIBUTIONS ');
2391: -- ========================= FND LOG ===========================
2392:
2393: -- Bug 3671841, issuing a call to purge orphan distributions

Line 2404: psa_utils.debug_other_string(g_state_level,l_full_path,

2400: WHERE ara.posting_control_id = l_pst_ctrl_id);
2401:
2402: IF (SQL%FOUND) THEN
2403: -- ========================= FND LOG ===========================
2404: psa_utils.debug_other_string(g_state_level,l_full_path,
2405: ' --> (PSA_MF_RCT_DIST_ALL) Posting control id updated for '
2406: || (SQL%ROWCOUNT) );
2407: -- ========================= FND LOG ===========================
2408: END IF;

Line 2410: psa_utils.debug_other_string(g_event_level,l_full_path,

2406: || (SQL%ROWCOUNT) );
2407: -- ========================= FND LOG ===========================
2408: END IF;
2409: -- ========================= FND LOG ===========================
2410: psa_utils.debug_other_string(g_event_level,l_full_path,
2411: ' --> End of Receipts Transfer '|| to_char(sysdate, 'DD/MM/YYYY HH:MI:SS'));
2412: -- ========================= FND LOG ===========================
2413:
2414: EXCEPTION

Line 2417: psa_utils.debug_other_string(g_excep_level,l_full_path,

2413:
2414: EXCEPTION
2415: WHEN INVALID_DISTRIBUTION THEN
2416: -- ========================= FND LOG ===========================
2417: psa_utils.debug_other_string(g_excep_level,l_full_path,
2418: ' --> EXCEPTION - INVALID_DISTRIBUTION raised during PSA_XFR_TO_GL_PKG.Mfar_rct_to_gl ');
2419: psa_utils.debug_other_string(g_excep_level,l_full_path,
2420: ' --> p_error_message --> ' || l_error_message);
2421: -- ========================= FND LOG ===========================

Line 2419: psa_utils.debug_other_string(g_excep_level,l_full_path,

2415: WHEN INVALID_DISTRIBUTION THEN
2416: -- ========================= FND LOG ===========================
2417: psa_utils.debug_other_string(g_excep_level,l_full_path,
2418: ' --> EXCEPTION - INVALID_DISTRIBUTION raised during PSA_XFR_TO_GL_PKG.Mfar_rct_to_gl ');
2419: psa_utils.debug_other_string(g_excep_level,l_full_path,
2420: ' --> p_error_message --> ' || l_error_message);
2421: -- ========================= FND LOG ===========================
2422: retcode := 'F';
2423:

Line 2426: psa_utils.debug_other_string(g_excep_level,l_full_path,

2422: retcode := 'F';
2423:
2424: WHEN OTHERS THEN
2425: -- ========================= FND LOG ===========================
2426: psa_utils.debug_other_string(g_excep_level,l_full_path,
2427: ' --> EXCEPTION - OTHERS raised during PSA_XFR_TO_GL_PKG.Mfar_rct_to_gl ');
2428: psa_utils.debug_other_string(g_excep_level,l_full_path, sqlcode || sqlerrm);
2429: psa_utils.debug_unexpected_msg(l_full_path);
2430: -- ========================= FND LOG ===========================

Line 2428: psa_utils.debug_other_string(g_excep_level,l_full_path, sqlcode || sqlerrm);

2424: WHEN OTHERS THEN
2425: -- ========================= FND LOG ===========================
2426: psa_utils.debug_other_string(g_excep_level,l_full_path,
2427: ' --> EXCEPTION - OTHERS raised during PSA_XFR_TO_GL_PKG.Mfar_rct_to_gl ');
2428: psa_utils.debug_other_string(g_excep_level,l_full_path, sqlcode || sqlerrm);
2429: psa_utils.debug_unexpected_msg(l_full_path);
2430: -- ========================= FND LOG ===========================
2431: errbuf := 2;
2432: retcode := 'F';

Line 2429: psa_utils.debug_unexpected_msg(l_full_path);

2425: -- ========================= FND LOG ===========================
2426: psa_utils.debug_other_string(g_excep_level,l_full_path,
2427: ' --> EXCEPTION - OTHERS raised during PSA_XFR_TO_GL_PKG.Mfar_rct_to_gl ');
2428: psa_utils.debug_other_string(g_excep_level,l_full_path, sqlcode || sqlerrm);
2429: psa_utils.debug_unexpected_msg(l_full_path);
2430: -- ========================= FND LOG ===========================
2431: errbuf := 2;
2432: retcode := 'F';
2433:

Line 2582: psa_utils.debug_other_string(g_state_level,l_full_path,

2578:
2579: BEGIN
2580:
2581: -- ========================= FND LOG ===========================
2582: psa_utils.debug_other_string(g_state_level,l_full_path,
2583: ' ' );
2584: psa_utils.debug_other_string(g_state_level,l_full_path,
2585: ' ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~');
2586: psa_utils.debug_other_string(g_state_level,l_full_path,

Line 2584: psa_utils.debug_other_string(g_state_level,l_full_path,

2580:
2581: -- ========================= FND LOG ===========================
2582: psa_utils.debug_other_string(g_state_level,l_full_path,
2583: ' ' );
2584: psa_utils.debug_other_string(g_state_level,l_full_path,
2585: ' ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~');
2586: psa_utils.debug_other_string(g_state_level,l_full_path,
2587: ' (TRANSFERRING ADJUSTMENTS) '
2588: || to_char (sysdate, 'DD/MM/YYYY HH:MI:SS'));

Line 2586: psa_utils.debug_other_string(g_state_level,l_full_path,

2582: psa_utils.debug_other_string(g_state_level,l_full_path,
2583: ' ' );
2584: psa_utils.debug_other_string(g_state_level,l_full_path,
2585: ' ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~');
2586: psa_utils.debug_other_string(g_state_level,l_full_path,
2587: ' (TRANSFERRING ADJUSTMENTS) '
2588: || to_char (sysdate, 'DD/MM/YYYY HH:MI:SS'));
2589: psa_utils.debug_other_string(g_state_level,l_full_path,
2590: ' ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~');

Line 2589: psa_utils.debug_other_string(g_state_level,l_full_path,

2585: ' ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~');
2586: psa_utils.debug_other_string(g_state_level,l_full_path,
2587: ' (TRANSFERRING ADJUSTMENTS) '
2588: || to_char (sysdate, 'DD/MM/YYYY HH:MI:SS'));
2589: psa_utils.debug_other_string(g_state_level,l_full_path,
2590: ' ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~');
2591: psa_utils.debug_other_string(g_state_level,l_full_path,
2592: ' ');
2593: -- ========================= FND LOG ===========================

Line 2591: psa_utils.debug_other_string(g_state_level,l_full_path,

2587: ' (TRANSFERRING ADJUSTMENTS) '
2588: || to_char (sysdate, 'DD/MM/YYYY HH:MI:SS'));
2589: psa_utils.debug_other_string(g_state_level,l_full_path,
2590: ' ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~');
2591: psa_utils.debug_other_string(g_state_level,l_full_path,
2592: ' ');
2593: -- ========================= FND LOG ===========================
2594: retcode := 'S';
2595: l_gl_start_date := p_gl_date_from;

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

2597: l_summary_flag := p_summary_flag;
2598: l_sob_id := p_set_of_books_id;
2599:
2600: -- ========================= FND LOG ===========================
2601: psa_utils.debug_other_string(g_state_level,l_full_path,' PARAMETERS :');
2602: psa_utils.debug_other_string(g_state_level,l_full_path,' ============');
2603: psa_utils.debug_other_string(g_state_level,l_full_path,' p_gl_date_from -->' || p_gl_date_from);
2604: psa_utils.debug_other_string(g_state_level,l_full_path,' p_gl_date_to -->' || p_gl_date_to );
2605: psa_utils.debug_other_string(g_state_level,l_full_path,' p_summary_flag -->' || p_summary_flag );

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

2598: l_sob_id := p_set_of_books_id;
2599:
2600: -- ========================= FND LOG ===========================
2601: psa_utils.debug_other_string(g_state_level,l_full_path,' PARAMETERS :');
2602: psa_utils.debug_other_string(g_state_level,l_full_path,' ============');
2603: psa_utils.debug_other_string(g_state_level,l_full_path,' p_gl_date_from -->' || p_gl_date_from);
2604: psa_utils.debug_other_string(g_state_level,l_full_path,' p_gl_date_to -->' || p_gl_date_to );
2605: psa_utils.debug_other_string(g_state_level,l_full_path,' p_summary_flag -->' || p_summary_flag );
2606: psa_utils.debug_other_string(g_state_level,l_full_path,' p_set_of_books_id -->' || p_set_of_books_id );

Line 2603: psa_utils.debug_other_string(g_state_level,l_full_path,' p_gl_date_from -->' || p_gl_date_from);

2599:
2600: -- ========================= FND LOG ===========================
2601: psa_utils.debug_other_string(g_state_level,l_full_path,' PARAMETERS :');
2602: psa_utils.debug_other_string(g_state_level,l_full_path,' ============');
2603: psa_utils.debug_other_string(g_state_level,l_full_path,' p_gl_date_from -->' || p_gl_date_from);
2604: psa_utils.debug_other_string(g_state_level,l_full_path,' p_gl_date_to -->' || p_gl_date_to );
2605: psa_utils.debug_other_string(g_state_level,l_full_path,' p_summary_flag -->' || p_summary_flag );
2606: psa_utils.debug_other_string(g_state_level,l_full_path,' p_set_of_books_id -->' || p_set_of_books_id );
2607: psa_utils.debug_other_string(g_state_level,l_full_path,' ');

Line 2604: psa_utils.debug_other_string(g_state_level,l_full_path,' p_gl_date_to -->' || p_gl_date_to );

2600: -- ========================= FND LOG ===========================
2601: psa_utils.debug_other_string(g_state_level,l_full_path,' PARAMETERS :');
2602: psa_utils.debug_other_string(g_state_level,l_full_path,' ============');
2603: psa_utils.debug_other_string(g_state_level,l_full_path,' p_gl_date_from -->' || p_gl_date_from);
2604: psa_utils.debug_other_string(g_state_level,l_full_path,' p_gl_date_to -->' || p_gl_date_to );
2605: psa_utils.debug_other_string(g_state_level,l_full_path,' p_summary_flag -->' || p_summary_flag );
2606: psa_utils.debug_other_string(g_state_level,l_full_path,' p_set_of_books_id -->' || p_set_of_books_id );
2607: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
2608: psa_utils.debug_other_string(g_state_level,l_full_path,' OTHER VALUES :');

Line 2605: psa_utils.debug_other_string(g_state_level,l_full_path,' p_summary_flag -->' || p_summary_flag );

2601: psa_utils.debug_other_string(g_state_level,l_full_path,' PARAMETERS :');
2602: psa_utils.debug_other_string(g_state_level,l_full_path,' ============');
2603: psa_utils.debug_other_string(g_state_level,l_full_path,' p_gl_date_from -->' || p_gl_date_from);
2604: psa_utils.debug_other_string(g_state_level,l_full_path,' p_gl_date_to -->' || p_gl_date_to );
2605: psa_utils.debug_other_string(g_state_level,l_full_path,' p_summary_flag -->' || p_summary_flag );
2606: psa_utils.debug_other_string(g_state_level,l_full_path,' p_set_of_books_id -->' || p_set_of_books_id );
2607: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
2608: psa_utils.debug_other_string(g_state_level,l_full_path,' OTHER VALUES :');
2609: psa_utils.debug_other_string(g_state_level,l_full_path,' ============= ');

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

2602: psa_utils.debug_other_string(g_state_level,l_full_path,' ============');
2603: psa_utils.debug_other_string(g_state_level,l_full_path,' p_gl_date_from -->' || p_gl_date_from);
2604: psa_utils.debug_other_string(g_state_level,l_full_path,' p_gl_date_to -->' || p_gl_date_to );
2605: psa_utils.debug_other_string(g_state_level,l_full_path,' p_summary_flag -->' || p_summary_flag );
2606: psa_utils.debug_other_string(g_state_level,l_full_path,' p_set_of_books_id -->' || p_set_of_books_id );
2607: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
2608: psa_utils.debug_other_string(g_state_level,l_full_path,' OTHER VALUES :');
2609: psa_utils.debug_other_string(g_state_level,l_full_path,' ============= ');
2610: psa_utils.debug_other_string(g_state_level,l_full_path,' l_gl_start_date -->' || l_gl_start_date);

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

2603: psa_utils.debug_other_string(g_state_level,l_full_path,' p_gl_date_from -->' || p_gl_date_from);
2604: psa_utils.debug_other_string(g_state_level,l_full_path,' p_gl_date_to -->' || p_gl_date_to );
2605: psa_utils.debug_other_string(g_state_level,l_full_path,' p_summary_flag -->' || p_summary_flag );
2606: psa_utils.debug_other_string(g_state_level,l_full_path,' p_set_of_books_id -->' || p_set_of_books_id );
2607: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
2608: psa_utils.debug_other_string(g_state_level,l_full_path,' OTHER VALUES :');
2609: psa_utils.debug_other_string(g_state_level,l_full_path,' ============= ');
2610: psa_utils.debug_other_string(g_state_level,l_full_path,' l_gl_start_date -->' || l_gl_start_date);
2611: psa_utils.debug_other_string(g_state_level,l_full_path,' l_post_through_date -->' || l_post_through_date);

Line 2608: psa_utils.debug_other_string(g_state_level,l_full_path,' OTHER VALUES :');

2604: psa_utils.debug_other_string(g_state_level,l_full_path,' p_gl_date_to -->' || p_gl_date_to );
2605: psa_utils.debug_other_string(g_state_level,l_full_path,' p_summary_flag -->' || p_summary_flag );
2606: psa_utils.debug_other_string(g_state_level,l_full_path,' p_set_of_books_id -->' || p_set_of_books_id );
2607: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
2608: psa_utils.debug_other_string(g_state_level,l_full_path,' OTHER VALUES :');
2609: psa_utils.debug_other_string(g_state_level,l_full_path,' ============= ');
2610: psa_utils.debug_other_string(g_state_level,l_full_path,' l_gl_start_date -->' || l_gl_start_date);
2611: psa_utils.debug_other_string(g_state_level,l_full_path,' l_post_through_date -->' || l_post_through_date);
2612: psa_utils.debug_other_string(g_state_level,l_full_path,' l_summary_flag -->' || l_summary_flag);

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

2605: psa_utils.debug_other_string(g_state_level,l_full_path,' p_summary_flag -->' || p_summary_flag );
2606: psa_utils.debug_other_string(g_state_level,l_full_path,' p_set_of_books_id -->' || p_set_of_books_id );
2607: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
2608: psa_utils.debug_other_string(g_state_level,l_full_path,' OTHER VALUES :');
2609: psa_utils.debug_other_string(g_state_level,l_full_path,' ============= ');
2610: psa_utils.debug_other_string(g_state_level,l_full_path,' l_gl_start_date -->' || l_gl_start_date);
2611: psa_utils.debug_other_string(g_state_level,l_full_path,' l_post_through_date -->' || l_post_through_date);
2612: psa_utils.debug_other_string(g_state_level,l_full_path,' l_summary_flag -->' || l_summary_flag);
2613: psa_utils.debug_other_string(g_state_level,l_full_path,' l_sob_id -->' || l_sob_id);

Line 2610: psa_utils.debug_other_string(g_state_level,l_full_path,' l_gl_start_date -->' || l_gl_start_date);

2606: psa_utils.debug_other_string(g_state_level,l_full_path,' p_set_of_books_id -->' || p_set_of_books_id );
2607: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
2608: psa_utils.debug_other_string(g_state_level,l_full_path,' OTHER VALUES :');
2609: psa_utils.debug_other_string(g_state_level,l_full_path,' ============= ');
2610: psa_utils.debug_other_string(g_state_level,l_full_path,' l_gl_start_date -->' || l_gl_start_date);
2611: psa_utils.debug_other_string(g_state_level,l_full_path,' l_post_through_date -->' || l_post_through_date);
2612: psa_utils.debug_other_string(g_state_level,l_full_path,' l_summary_flag -->' || l_summary_flag);
2613: psa_utils.debug_other_string(g_state_level,l_full_path,' l_sob_id -->' || l_sob_id);
2614: psa_utils.debug_other_string(g_state_level,l_full_path,' ');

Line 2611: psa_utils.debug_other_string(g_state_level,l_full_path,' l_post_through_date -->' || l_post_through_date);

2607: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
2608: psa_utils.debug_other_string(g_state_level,l_full_path,' OTHER VALUES :');
2609: psa_utils.debug_other_string(g_state_level,l_full_path,' ============= ');
2610: psa_utils.debug_other_string(g_state_level,l_full_path,' l_gl_start_date -->' || l_gl_start_date);
2611: psa_utils.debug_other_string(g_state_level,l_full_path,' l_post_through_date -->' || l_post_through_date);
2612: psa_utils.debug_other_string(g_state_level,l_full_path,' l_summary_flag -->' || l_summary_flag);
2613: psa_utils.debug_other_string(g_state_level,l_full_path,' l_sob_id -->' || l_sob_id);
2614: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
2615: psa_utils.debug_other_string(g_state_level,l_full_path,' PROCESS :');

Line 2612: psa_utils.debug_other_string(g_state_level,l_full_path,' l_summary_flag -->' || l_summary_flag);

2608: psa_utils.debug_other_string(g_state_level,l_full_path,' OTHER VALUES :');
2609: psa_utils.debug_other_string(g_state_level,l_full_path,' ============= ');
2610: psa_utils.debug_other_string(g_state_level,l_full_path,' l_gl_start_date -->' || l_gl_start_date);
2611: psa_utils.debug_other_string(g_state_level,l_full_path,' l_post_through_date -->' || l_post_through_date);
2612: psa_utils.debug_other_string(g_state_level,l_full_path,' l_summary_flag -->' || l_summary_flag);
2613: psa_utils.debug_other_string(g_state_level,l_full_path,' l_sob_id -->' || l_sob_id);
2614: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
2615: psa_utils.debug_other_string(g_state_level,l_full_path,' PROCESS :');
2616: psa_utils.debug_other_string(g_state_level,l_full_path,' =========');

Line 2613: psa_utils.debug_other_string(g_state_level,l_full_path,' l_sob_id -->' || l_sob_id);

2609: psa_utils.debug_other_string(g_state_level,l_full_path,' ============= ');
2610: psa_utils.debug_other_string(g_state_level,l_full_path,' l_gl_start_date -->' || l_gl_start_date);
2611: psa_utils.debug_other_string(g_state_level,l_full_path,' l_post_through_date -->' || l_post_through_date);
2612: psa_utils.debug_other_string(g_state_level,l_full_path,' l_summary_flag -->' || l_summary_flag);
2613: psa_utils.debug_other_string(g_state_level,l_full_path,' l_sob_id -->' || l_sob_id);
2614: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
2615: psa_utils.debug_other_string(g_state_level,l_full_path,' PROCESS :');
2616: psa_utils.debug_other_string(g_state_level,l_full_path,' =========');
2617: psa_utils.debug_other_string(g_state_level,l_full_path,' ');

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

2610: psa_utils.debug_other_string(g_state_level,l_full_path,' l_gl_start_date -->' || l_gl_start_date);
2611: psa_utils.debug_other_string(g_state_level,l_full_path,' l_post_through_date -->' || l_post_through_date);
2612: psa_utils.debug_other_string(g_state_level,l_full_path,' l_summary_flag -->' || l_summary_flag);
2613: psa_utils.debug_other_string(g_state_level,l_full_path,' l_sob_id -->' || l_sob_id);
2614: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
2615: psa_utils.debug_other_string(g_state_level,l_full_path,' PROCESS :');
2616: psa_utils.debug_other_string(g_state_level,l_full_path,' =========');
2617: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
2618: -- ========================= FND LOG ===========================

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

2611: psa_utils.debug_other_string(g_state_level,l_full_path,' l_post_through_date -->' || l_post_through_date);
2612: psa_utils.debug_other_string(g_state_level,l_full_path,' l_summary_flag -->' || l_summary_flag);
2613: psa_utils.debug_other_string(g_state_level,l_full_path,' l_sob_id -->' || l_sob_id);
2614: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
2615: psa_utils.debug_other_string(g_state_level,l_full_path,' PROCESS :');
2616: psa_utils.debug_other_string(g_state_level,l_full_path,' =========');
2617: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
2618: -- ========================= FND LOG ===========================
2619:

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

2612: psa_utils.debug_other_string(g_state_level,l_full_path,' l_summary_flag -->' || l_summary_flag);
2613: psa_utils.debug_other_string(g_state_level,l_full_path,' l_sob_id -->' || l_sob_id);
2614: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
2615: psa_utils.debug_other_string(g_state_level,l_full_path,' PROCESS :');
2616: psa_utils.debug_other_string(g_state_level,l_full_path,' =========');
2617: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
2618: -- ========================= FND LOG ===========================
2619:
2620: FOR I IN Cur_lines_to_be_processed

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

2613: psa_utils.debug_other_string(g_state_level,l_full_path,' l_sob_id -->' || l_sob_id);
2614: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
2615: psa_utils.debug_other_string(g_state_level,l_full_path,' PROCESS :');
2616: psa_utils.debug_other_string(g_state_level,l_full_path,' =========');
2617: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
2618: -- ========================= FND LOG ===========================
2619:
2620: FOR I IN Cur_lines_to_be_processed
2621: LOOP

Line 2625: psa_utils.debug_other_string(g_state_level,l_full_path,

2621: LOOP
2622:
2623: BEGIN
2624: -- ========================= FND LOG ===========================
2625: psa_utils.debug_other_string(g_state_level,l_full_path,
2626: ' --> Creating distribution for adjustment id ==> ' || l_run_num
2627: || ' -- ' || I.adjustment_id);
2628: -- ========================= FND LOG ===========================
2629:

Line 2640: psa_utils.debug_other_string(g_state_level,l_full_path,

2636: p_error_message => l_error_message)) THEN
2637:
2638: IF l_error_message IS NOT NULL OR l_retcode = 'F' THEN
2639: -- ========================= FND LOG ===========================
2640: psa_utils.debug_other_string(g_state_level,l_full_path,
2641: 'Mfar_adj_to_gl: Raising invalid_distribution');
2642: -- ========================= FND LOG ===========================
2643: Raise invalid_distribution;
2644: END IF;

Line 2648: psa_utils.debug_other_string(g_state_level,l_full_path,

2644: END IF;
2645:
2646: ELSE
2647: -- ========================= FND LOG ===========================
2648: psa_utils.debug_other_string(g_state_level,l_full_path,
2649: 'Mfar_adj_to_gl: '
2650: || ' Adjustment id --> ' || I.adjustment_id);
2651: -- ========================= FND LOG ===========================
2652: END IF;

Line 2667: psa_utils.debug_other_string(g_state_level,l_full_path,

2663: AND GI.reference22 = to_char(I.adjustment_id);
2664: -- Bug 3817595 .. End
2665:
2666: -- ========================= FND LOG ===========================
2667: psa_utils.debug_other_string(g_state_level,l_full_path,
2668: ' Deleting rows from Gl interface ' || SQL%ROWCOUNT);
2669: -- ========================= FND LOG ===========================
2670:
2671: FOR J IN Cur_mfar_lines (I.adjustment_id)

Line 2679: psa_utils.debug_other_string(g_state_level,l_full_path,

2675: ## For each adjustments id the record will be inserted.
2676: */
2677:
2678: -- ========================= FND LOG ===========================
2679: psa_utils.debug_other_string(g_state_level,l_full_path,
2680: ' --> adjustment id ==> ' || I.adjustment_id );
2681: -- ========================= FND LOG ===========================
2682:
2683: INSERT INTO gl_interface

Line 2747: psa_utils.debug_other_string(g_state_level,l_full_path,

2743: J.ref30);
2744:
2745: IF (SQL%FOUND) THEN
2746: -- ========================= FND LOG ===========================
2747: psa_utils.debug_other_string(g_state_level,l_full_path,
2748: ' --> Inserting into GL INTERFACE for adjustment id ==> '
2749: || I.adjustment_id );
2750: psa_utils.debug_other_string(g_state_level,l_full_path,
2751: ' CCID => ' || J.ccid

Line 2750: psa_utils.debug_other_string(g_state_level,l_full_path,

2746: -- ========================= FND LOG ===========================
2747: psa_utils.debug_other_string(g_state_level,l_full_path,
2748: ' --> Inserting into GL INTERFACE for adjustment id ==> '
2749: || I.adjustment_id );
2750: psa_utils.debug_other_string(g_state_level,l_full_path,
2751: ' CCID => ' || J.ccid
2752: || ' DEBIT => ' || J.entered_dr
2753: || ' CREDIT => ' || J.entered_cr );
2754: psa_utils.debug_other_string(g_state_level,l_full_path,

Line 2754: psa_utils.debug_other_string(g_state_level,l_full_path,

2750: psa_utils.debug_other_string(g_state_level,l_full_path,
2751: ' CCID => ' || J.ccid
2752: || ' DEBIT => ' || J.entered_dr
2753: || ' CREDIT => ' || J.entered_cr );
2754: psa_utils.debug_other_string(g_state_level,l_full_path,
2755: ' USSGL_TRANSACTION_CODE => '|| J.ussgl_transaction_code);
2756: -- ========================= FND LOG ===========================
2757: END IF;
2758: END LOOP;

Line 2770: psa_utils.debug_other_string(g_state_level,l_full_path,

2766: WHERE aa.posting_control_id = l_pst_ctrl_id);
2767:
2768: IF (SQL%FOUND) THEN
2769: -- ========================= FND LOG ===========================
2770: psa_utils.debug_other_string(g_state_level,l_full_path,
2771: ' --> (PSA_MF_ADJ_DIST_ALL) Posting control id updated for '
2772: || (SQL%ROWCOUNT));
2773: -- ========================= FND LOG ===========================
2774: END IF;

Line 2777: psa_utils.debug_other_string(g_event_level,l_full_path,

2773: -- ========================= FND LOG ===========================
2774: END IF;
2775:
2776: -- ========================= FND LOG ===========================
2777: psa_utils.debug_other_string(g_event_level,l_full_path,
2778: ' --> End of Adjustments transfer '
2779: || to_char (sysdate, 'DD/MM/YYYY HH:MI:SS'));
2780: -- ========================= FND LOG ===========================
2781:

Line 2785: psa_utils.debug_other_string(g_excep_level,l_full_path,

2781:
2782: EXCEPTION
2783: WHEN INVALID_DISTRIBUTION THEN
2784: -- ========================= FND LOG ===========================
2785: psa_utils.debug_other_string(g_excep_level,l_full_path,
2786: ' --> EXCEPTION - INVALID_DISTRIBUTION raised during PPSA_XFR_TO_GL_PKG.Mfar_adj_to_gl ');
2787: psa_utils.debug_other_string(g_excep_level,l_full_path,
2788: ' --> p_error_message --> ' || l_error_message);
2789: -- ========================= FND LOG ===========================

Line 2787: psa_utils.debug_other_string(g_excep_level,l_full_path,

2783: WHEN INVALID_DISTRIBUTION THEN
2784: -- ========================= FND LOG ===========================
2785: psa_utils.debug_other_string(g_excep_level,l_full_path,
2786: ' --> EXCEPTION - INVALID_DISTRIBUTION raised during PPSA_XFR_TO_GL_PKG.Mfar_adj_to_gl ');
2787: psa_utils.debug_other_string(g_excep_level,l_full_path,
2788: ' --> p_error_message --> ' || l_error_message);
2789: -- ========================= FND LOG ===========================
2790: retcode := 'F';
2791:

Line 2794: psa_utils.debug_other_string(g_excep_level,l_full_path,

2790: retcode := 'F';
2791:
2792: WHEN OTHERS THEN
2793: -- ========================= FND LOG ===========================
2794: psa_utils.debug_other_string(g_excep_level,l_full_path,
2795: ' --> EXCEPTION - OTHERS raised during PSA_XFR_TO_GL_PKG.Mfar_adj_to_gl ');
2796: psa_utils.debug_other_string(g_excep_level,l_full_path, sqlcode || sqlerrm);
2797: psa_utils.debug_unexpected_msg(l_full_path);
2798: -- ========================= FND LOG ===========================

Line 2796: psa_utils.debug_other_string(g_excep_level,l_full_path, sqlcode || sqlerrm);

2792: WHEN OTHERS THEN
2793: -- ========================= FND LOG ===========================
2794: psa_utils.debug_other_string(g_excep_level,l_full_path,
2795: ' --> EXCEPTION - OTHERS raised during PSA_XFR_TO_GL_PKG.Mfar_adj_to_gl ');
2796: psa_utils.debug_other_string(g_excep_level,l_full_path, sqlcode || sqlerrm);
2797: psa_utils.debug_unexpected_msg(l_full_path);
2798: -- ========================= FND LOG ===========================
2799: errbuf := 2;
2800: retcode := 'F';

Line 2797: psa_utils.debug_unexpected_msg(l_full_path);

2793: -- ========================= FND LOG ===========================
2794: psa_utils.debug_other_string(g_excep_level,l_full_path,
2795: ' --> EXCEPTION - OTHERS raised during PSA_XFR_TO_GL_PKG.Mfar_adj_to_gl ');
2796: psa_utils.debug_other_string(g_excep_level,l_full_path, sqlcode || sqlerrm);
2797: psa_utils.debug_unexpected_msg(l_full_path);
2798: -- ========================= FND LOG ===========================
2799: errbuf := 2;
2800: retcode := 'F';
2801:

Line 2890: psa_utils.debug_other_string(g_state_level,l_full_path,' START Reverse_core_entries_if_any ');

2886:
2887: BEGIN
2888:
2889: -- ========================= FND LOG ===========================
2890: psa_utils.debug_other_string(g_state_level,l_full_path,' START Reverse_core_entries_if_any ');
2891: psa_utils.debug_other_string(g_state_level,l_full_path,' PARAMETERS :');
2892: psa_utils.debug_other_string(g_state_level,l_full_path,' ============');
2893: psa_utils.debug_other_string(g_state_level,l_full_path,' p_set_of_books_id -->' || p_set_of_books_id );
2894: psa_utils.debug_other_string(g_state_level,l_full_path,' ');

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

2887: BEGIN
2888:
2889: -- ========================= FND LOG ===========================
2890: psa_utils.debug_other_string(g_state_level,l_full_path,' START Reverse_core_entries_if_any ');
2891: psa_utils.debug_other_string(g_state_level,l_full_path,' PARAMETERS :');
2892: psa_utils.debug_other_string(g_state_level,l_full_path,' ============');
2893: psa_utils.debug_other_string(g_state_level,l_full_path,' p_set_of_books_id -->' || p_set_of_books_id );
2894: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
2895: psa_utils.debug_other_string(g_state_level,l_full_path,' PROCESS :');

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

2888:
2889: -- ========================= FND LOG ===========================
2890: psa_utils.debug_other_string(g_state_level,l_full_path,' START Reverse_core_entries_if_any ');
2891: psa_utils.debug_other_string(g_state_level,l_full_path,' PARAMETERS :');
2892: psa_utils.debug_other_string(g_state_level,l_full_path,' ============');
2893: psa_utils.debug_other_string(g_state_level,l_full_path,' p_set_of_books_id -->' || p_set_of_books_id );
2894: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
2895: psa_utils.debug_other_string(g_state_level,l_full_path,' PROCESS :');
2896: psa_utils.debug_other_string(g_state_level,l_full_path,' =========');

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

2889: -- ========================= FND LOG ===========================
2890: psa_utils.debug_other_string(g_state_level,l_full_path,' START Reverse_core_entries_if_any ');
2891: psa_utils.debug_other_string(g_state_level,l_full_path,' PARAMETERS :');
2892: psa_utils.debug_other_string(g_state_level,l_full_path,' ============');
2893: psa_utils.debug_other_string(g_state_level,l_full_path,' p_set_of_books_id -->' || p_set_of_books_id );
2894: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
2895: psa_utils.debug_other_string(g_state_level,l_full_path,' PROCESS :');
2896: psa_utils.debug_other_string(g_state_level,l_full_path,' =========');
2897: psa_utils.debug_other_string(g_state_level,l_full_path,' ');

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

2890: psa_utils.debug_other_string(g_state_level,l_full_path,' START Reverse_core_entries_if_any ');
2891: psa_utils.debug_other_string(g_state_level,l_full_path,' PARAMETERS :');
2892: psa_utils.debug_other_string(g_state_level,l_full_path,' ============');
2893: psa_utils.debug_other_string(g_state_level,l_full_path,' p_set_of_books_id -->' || p_set_of_books_id );
2894: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
2895: psa_utils.debug_other_string(g_state_level,l_full_path,' PROCESS :');
2896: psa_utils.debug_other_string(g_state_level,l_full_path,' =========');
2897: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
2898: -- ========================= FND LOG ===========================

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

2891: psa_utils.debug_other_string(g_state_level,l_full_path,' PARAMETERS :');
2892: psa_utils.debug_other_string(g_state_level,l_full_path,' ============');
2893: psa_utils.debug_other_string(g_state_level,l_full_path,' p_set_of_books_id -->' || p_set_of_books_id );
2894: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
2895: psa_utils.debug_other_string(g_state_level,l_full_path,' PROCESS :');
2896: psa_utils.debug_other_string(g_state_level,l_full_path,' =========');
2897: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
2898: -- ========================= FND LOG ===========================
2899:

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

2892: psa_utils.debug_other_string(g_state_level,l_full_path,' ============');
2893: psa_utils.debug_other_string(g_state_level,l_full_path,' p_set_of_books_id -->' || p_set_of_books_id );
2894: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
2895: psa_utils.debug_other_string(g_state_level,l_full_path,' PROCESS :');
2896: psa_utils.debug_other_string(g_state_level,l_full_path,' =========');
2897: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
2898: -- ========================= FND LOG ===========================
2899:
2900: retcode := 'S';

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

2893: psa_utils.debug_other_string(g_state_level,l_full_path,' p_set_of_books_id -->' || p_set_of_books_id );
2894: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
2895: psa_utils.debug_other_string(g_state_level,l_full_path,' PROCESS :');
2896: psa_utils.debug_other_string(g_state_level,l_full_path,' =========');
2897: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
2898: -- ========================= FND LOG ===========================
2899:
2900: retcode := 'S';
2901:

Line 2907: psa_utils.debug_other_string(g_state_level,l_full_path,' l_chart_of_accounts_id --> ' || l_chart_of_accounts_id);

2903: FETCH Cur_coa_id INTO l_chart_of_accounts_id;
2904: CLOSE Cur_coa_id;
2905:
2906: -- ========================= FND LOG ===========================
2907: psa_utils.debug_other_string(g_state_level,l_full_path,' l_chart_of_accounts_id --> ' || l_chart_of_accounts_id);
2908: psa_utils.debug_other_string(g_state_level,l_full_path,' Getting org details ');
2909: -- ========================= FND LOG ===========================
2910:
2911: PSA_MFAR_UTILS.PSA_MF_ORG_DETAILS (l_org_details);

Line 2908: psa_utils.debug_other_string(g_state_level,l_full_path,' Getting org details ');

2904: CLOSE Cur_coa_id;
2905:
2906: -- ========================= FND LOG ===========================
2907: psa_utils.debug_other_string(g_state_level,l_full_path,' l_chart_of_accounts_id --> ' || l_chart_of_accounts_id);
2908: psa_utils.debug_other_string(g_state_level,l_full_path,' Getting org details ');
2909: -- ========================= FND LOG ===========================
2910:
2911: PSA_MFAR_UTILS.PSA_MF_ORG_DETAILS (l_org_details);
2912:

Line 2914: psa_utils.debug_other_string(g_state_level,l_full_path,' l_org_details.allocation_method --> ' || l_org_details.allocation_method);

2910:
2911: PSA_MFAR_UTILS.PSA_MF_ORG_DETAILS (l_org_details);
2912:
2913: -- ========================= FND LOG ===========================
2914: psa_utils.debug_other_string(g_state_level,l_full_path,' l_org_details.allocation_method --> ' || l_org_details.allocation_method);
2915: -- ========================= FND LOG ===========================
2916:
2917: IF (l_org_details.allocation_method = 'BAL') THEN
2918: l_qual_name := 'GL_BALANCING';

Line 2924: psa_utils.debug_other_string(g_state_level,l_full_path,' l_qual_name --> ' || l_qual_name);

2920: l_qual_name := 'GL_ACCOUNT';
2921: END IF;
2922:
2923: -- ========================= FND LOG ===========================
2924: psa_utils.debug_other_string(g_state_level,l_full_path,' l_qual_name --> ' || l_qual_name);
2925: psa_utils.debug_other_string(g_state_level,l_full_path,' Calling FND_FLEX_APIS.GET_QUALIFIER_SEGNUM ' );
2926: -- ========================= FND LOG ===========================
2927:
2928: IF (NOT FND_FLEX_APIS.GET_QUALIFIER_SEGNUM(

Line 2925: psa_utils.debug_other_string(g_state_level,l_full_path,' Calling FND_FLEX_APIS.GET_QUALIFIER_SEGNUM ' );

2921: END IF;
2922:
2923: -- ========================= FND LOG ===========================
2924: psa_utils.debug_other_string(g_state_level,l_full_path,' l_qual_name --> ' || l_qual_name);
2925: psa_utils.debug_other_string(g_state_level,l_full_path,' Calling FND_FLEX_APIS.GET_QUALIFIER_SEGNUM ' );
2926: -- ========================= FND LOG ===========================
2927:
2928: IF (NOT FND_FLEX_APIS.GET_QUALIFIER_SEGNUM(
2929: APPL_ID => 101,

Line 2935: psa_utils.debug_other_string(g_state_level,l_full_path,' l_acct_seg_num --> ' || l_acct_seg_num );

2931: STRUCTURE_NUMBER => l_chart_of_accounts_id,
2932: FLEX_QUAL_NAME => l_qual_name,
2933: SEGMENT_NUMBER => l_acct_seg_num)) THEN -- OUT
2934: -- ========================= FND LOG ===========================
2935: psa_utils.debug_other_string(g_state_level,l_full_path,' l_acct_seg_num --> ' || l_acct_seg_num );
2936: psa_utils.debug_other_string(g_state_level,l_full_path,' Raising GET_QUALIFIER_SEGNUM_EXCEP ');
2937: -- ========================= FND LOG ===========================
2938: RAISE GET_QUALIFIER_SEGNUM_EXCEP;
2939: ELSE

Line 2936: psa_utils.debug_other_string(g_state_level,l_full_path,' Raising GET_QUALIFIER_SEGNUM_EXCEP ');

2932: FLEX_QUAL_NAME => l_qual_name,
2933: SEGMENT_NUMBER => l_acct_seg_num)) THEN -- OUT
2934: -- ========================= FND LOG ===========================
2935: psa_utils.debug_other_string(g_state_level,l_full_path,' l_acct_seg_num --> ' || l_acct_seg_num );
2936: psa_utils.debug_other_string(g_state_level,l_full_path,' Raising GET_QUALIFIER_SEGNUM_EXCEP ');
2937: -- ========================= FND LOG ===========================
2938: RAISE GET_QUALIFIER_SEGNUM_EXCEP;
2939: ELSE
2940: -- ========================= FND LOG ===========================

Line 2941: psa_utils.debug_other_string(g_state_level,l_full_path,' l_acct_seg_num --> ' || l_acct_seg_num );

2937: -- ========================= FND LOG ===========================
2938: RAISE GET_QUALIFIER_SEGNUM_EXCEP;
2939: ELSE
2940: -- ========================= FND LOG ===========================
2941: psa_utils.debug_other_string(g_state_level,l_full_path,' l_acct_seg_num --> ' || l_acct_seg_num );
2942: -- ========================= FND LOG ===========================
2943: END IF;
2944:
2945: -- Picking up details from gl_interface.

Line 2950: psa_utils.debug_other_string(g_state_level,l_full_path,' Inside Cur_cust_Trx_id');

2946: FOR C_cust_trx_dets IN Cur_cust_Trx_id
2947: LOOP
2948:
2949: -- ========================= FND LOG ===========================
2950: psa_utils.debug_other_string(g_state_level,l_full_path,' Inside Cur_cust_Trx_id');
2951: -- ========================= FND LOG ===========================
2952:
2953: gl_int_dets := gl_int_dets_null;
2954:

Line 2963: psa_utils.debug_other_string(g_state_level,l_full_path,' C_cust_trx_dets.reference22 --> ' || C_cust_trx_dets.reference22);

2959: ' GROUP BY segment' || l_acct_seg_num ||
2960: ' HAVING SUM(nvl(accounted_dr,0)) <> SUM(nvl(accounted_cr,0))' ;
2961:
2962: -- ========================= FND LOG ===========================
2963: psa_utils.debug_other_string(g_state_level,l_full_path,' C_cust_trx_dets.reference22 --> ' || C_cust_trx_dets.reference22);
2964: psa_utils.debug_other_string(g_state_level,l_full_path,' l_select --> ' || l_select);
2965: -- ========================= FND LOG ===========================
2966:
2967: EXECUTE IMMEDIATE l_select BULK COLLECT INTO gl_int_dets USING C_cust_trx_dets.reference22, 'AR_RECEIVABLE_APPLICATIONS';

Line 2964: psa_utils.debug_other_string(g_state_level,l_full_path,' l_select --> ' || l_select);

2960: ' HAVING SUM(nvl(accounted_dr,0)) <> SUM(nvl(accounted_cr,0))' ;
2961:
2962: -- ========================= FND LOG ===========================
2963: psa_utils.debug_other_string(g_state_level,l_full_path,' C_cust_trx_dets.reference22 --> ' || C_cust_trx_dets.reference22);
2964: psa_utils.debug_other_string(g_state_level,l_full_path,' l_select --> ' || l_select);
2965: -- ========================= FND LOG ===========================
2966:
2967: EXECUTE IMMEDIATE l_select BULK COLLECT INTO gl_int_dets USING C_cust_trx_dets.reference22, 'AR_RECEIVABLE_APPLICATIONS';
2968:

Line 2970: psa_utils.debug_other_string(g_state_level,l_full_path,' Execute immediate ');

2966:
2967: EXECUTE IMMEDIATE l_select BULK COLLECT INTO gl_int_dets USING C_cust_trx_dets.reference22, 'AR_RECEIVABLE_APPLICATIONS';
2968:
2969: -- ========================= FND LOG ===========================
2970: psa_utils.debug_other_string(g_state_level,l_full_path,' Execute immediate ');
2971: -- ========================= FND LOG ===========================
2972:
2973: l_count := gl_int_dets.count;
2974:

Line 2978: psa_utils.debug_other_string(g_state_level,l_full_path,' l_count --> ' || l_count);

2974:
2975: IF (l_count <> 0)
2976: THEN
2977: -- ========================= FND LOG ===========================
2978: psa_utils.debug_other_string(g_state_level,l_full_path,' l_count --> ' || l_count);
2979: -- ========================= FND LOG ===========================
2980:
2981: FOR C_int_dets IN Cur_CM_dets (C_cust_trx_dets.reference22)
2982: LOOP

Line 2985: psa_utils.debug_other_string(g_state_level,l_full_path,' Inserting into gl_interface');

2981: FOR C_int_dets IN Cur_CM_dets (C_cust_trx_dets.reference22)
2982: LOOP
2983:
2984: -- ========================= FND LOG ===========================
2985: psa_utils.debug_other_string(g_state_level,l_full_path,' Inserting into gl_interface');
2986: -- ========================= FND LOG ===========================
2987:
2988: INSERT INTO gl_interface
2989: (created_by,

Line 3049: psa_utils.debug_other_string(g_state_level,l_full_path,' Inserting into gl_interface --> ' || SQL%ROWCOUNT);

3045: C_int_dets.ref29,
3046: C_int_dets.ref30);
3047:
3048: -- ========================= FND LOG ===========================
3049: psa_utils.debug_other_string(g_state_level,l_full_path,' Inserting into gl_interface --> ' || SQL%ROWCOUNT);
3050: -- ========================= FND LOG ===========================
3051:
3052: END LOOP;
3053: ELSE

Line 3055: psa_utils.debug_other_string(g_state_level,l_full_path,' l_count --> ' || l_count);

3051:
3052: END LOOP;
3053: ELSE
3054: -- ========================= FND LOG ===========================
3055: psa_utils.debug_other_string(g_state_level,l_full_path,' l_count --> ' || l_count);
3056: psa_utils.debug_other_string(g_state_level,l_full_path,' BALANCED ');
3057: -- ========================= FND LOG ===========================
3058: END IF;
3059:

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

3052: END LOOP;
3053: ELSE
3054: -- ========================= FND LOG ===========================
3055: psa_utils.debug_other_string(g_state_level,l_full_path,' l_count --> ' || l_count);
3056: psa_utils.debug_other_string(g_state_level,l_full_path,' BALANCED ');
3057: -- ========================= FND LOG ===========================
3058: END IF;
3059:
3060: END LOOP;

Line 3063: psa_utils.debug_other_string(g_state_level,l_full_path,' END Reverse_core_entries_if_any ');

3059:
3060: END LOOP;
3061:
3062: -- ========================= FND LOG ===========================
3063: psa_utils.debug_other_string(g_state_level,l_full_path,' END Reverse_core_entries_if_any ');
3064: -- ========================= FND LOG ===========================
3065:
3066: EXCEPTION
3067:

Line 3071: psa_utils.debug_other_string(g_excep_level,l_full_path,

3067:
3068: WHEN GET_QUALIFIER_SEGNUM_EXCEP THEN
3069: p_error_message := fnd_message.get;
3070: -- ========================= FND LOG ===========================
3071: psa_utils.debug_other_string(g_excep_level,l_full_path,
3072: ' --> EXCEPTION - GET_QUALIFIER_SEGNUM_EXCEP - ' || p_error_message);
3073: -- ========================= FND LOG ===========================
3074: retcode := 'F';
3075:

Line 3079: psa_utils.debug_other_string(g_excep_level,l_full_path,

3075:
3076: WHEN OTHERS THEN
3077: p_error_message := sqlcode || sqlerrm;
3078: -- ========================= FND LOG ===========================
3079: psa_utils.debug_other_string(g_excep_level,l_full_path,
3080: ' --> EXCEPTION - OTHERS raised during PSA_XFR_TO_GL_PKG.Reverse_core_entries_if_any ');
3081: psa_utils.debug_other_string(g_excep_level,l_full_path, p_error_message);
3082: psa_utils.debug_unexpected_msg(l_full_path);
3083: -- ========================= FND LOG ===========================

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

3077: p_error_message := sqlcode || sqlerrm;
3078: -- ========================= FND LOG ===========================
3079: psa_utils.debug_other_string(g_excep_level,l_full_path,
3080: ' --> EXCEPTION - OTHERS raised during PSA_XFR_TO_GL_PKG.Reverse_core_entries_if_any ');
3081: psa_utils.debug_other_string(g_excep_level,l_full_path, p_error_message);
3082: psa_utils.debug_unexpected_msg(l_full_path);
3083: -- ========================= FND LOG ===========================
3084: errbuf := 2;
3085: retcode := 'F';

Line 3082: psa_utils.debug_unexpected_msg(l_full_path);

3078: -- ========================= FND LOG ===========================
3079: psa_utils.debug_other_string(g_excep_level,l_full_path,
3080: ' --> EXCEPTION - OTHERS raised during PSA_XFR_TO_GL_PKG.Reverse_core_entries_if_any ');
3081: psa_utils.debug_other_string(g_excep_level,l_full_path, p_error_message);
3082: psa_utils.debug_unexpected_msg(l_full_path);
3083: -- ========================= FND LOG ===========================
3084: errbuf := 2;
3085: retcode := 'F';
3086:

Line 3131: psa_utils.debug_other_string(g_state_level,l_full_path,

3127:
3128: BEGIN
3129:
3130: -- ========================= FND LOG ===========================
3131: psa_utils.debug_other_string(g_state_level,l_full_path,
3132: ' --> Populate_global_variables - START '
3133: || to_char(sysdate, 'DD/MM/YYYY HH:MI:SS'));
3134: -- ========================= FND LOG ===========================
3135:

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

3348:
3349: select psa_mf_error_log_s.nextval into l_run_num from dual;
3350:
3351: -- ========================= FND LOG ===========================
3352: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
3353: psa_utils.debug_other_string(g_state_level,l_full_path,' LISTING THE VARIABLES AND VALUES :');
3354: psa_utils.debug_other_string(g_state_level,l_full_path,' ==================================');
3355: psa_utils.debug_other_string(g_state_level,l_full_path,' l_batch_prefix -->' || l_batch_prefix);
3356: psa_utils.debug_other_string(g_state_level,l_full_path,' l_user_id -->' || l_user_id);

Line 3353: psa_utils.debug_other_string(g_state_level,l_full_path,' LISTING THE VARIABLES AND VALUES :');

3349: select psa_mf_error_log_s.nextval into l_run_num from dual;
3350:
3351: -- ========================= FND LOG ===========================
3352: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
3353: psa_utils.debug_other_string(g_state_level,l_full_path,' LISTING THE VARIABLES AND VALUES :');
3354: psa_utils.debug_other_string(g_state_level,l_full_path,' ==================================');
3355: psa_utils.debug_other_string(g_state_level,l_full_path,' l_batch_prefix -->' || l_batch_prefix);
3356: psa_utils.debug_other_string(g_state_level,l_full_path,' l_user_id -->' || l_user_id);
3357: psa_utils.debug_other_string(g_state_level,l_full_path,' l_actual_flag -->' || l_actual_flag);

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

3350:
3351: -- ========================= FND LOG ===========================
3352: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
3353: psa_utils.debug_other_string(g_state_level,l_full_path,' LISTING THE VARIABLES AND VALUES :');
3354: psa_utils.debug_other_string(g_state_level,l_full_path,' ==================================');
3355: psa_utils.debug_other_string(g_state_level,l_full_path,' l_batch_prefix -->' || l_batch_prefix);
3356: psa_utils.debug_other_string(g_state_level,l_full_path,' l_user_id -->' || l_user_id);
3357: psa_utils.debug_other_string(g_state_level,l_full_path,' l_actual_flag -->' || l_actual_flag);
3358: psa_utils.debug_other_string(g_state_level,l_full_path,' l_status -->' || l_status);

Line 3355: psa_utils.debug_other_string(g_state_level,l_full_path,' l_batch_prefix -->' || l_batch_prefix);

3351: -- ========================= FND LOG ===========================
3352: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
3353: psa_utils.debug_other_string(g_state_level,l_full_path,' LISTING THE VARIABLES AND VALUES :');
3354: psa_utils.debug_other_string(g_state_level,l_full_path,' ==================================');
3355: psa_utils.debug_other_string(g_state_level,l_full_path,' l_batch_prefix -->' || l_batch_prefix);
3356: psa_utils.debug_other_string(g_state_level,l_full_path,' l_user_id -->' || l_user_id);
3357: psa_utils.debug_other_string(g_state_level,l_full_path,' l_actual_flag -->' || l_actual_flag);
3358: psa_utils.debug_other_string(g_state_level,l_full_path,' l_status -->' || l_status);
3359: psa_utils.debug_other_string(g_state_level,l_full_path,' l_inv_cat_name -->' || l_inv_cat_name);

Line 3356: psa_utils.debug_other_string(g_state_level,l_full_path,' l_user_id -->' || l_user_id);

3352: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
3353: psa_utils.debug_other_string(g_state_level,l_full_path,' LISTING THE VARIABLES AND VALUES :');
3354: psa_utils.debug_other_string(g_state_level,l_full_path,' ==================================');
3355: psa_utils.debug_other_string(g_state_level,l_full_path,' l_batch_prefix -->' || l_batch_prefix);
3356: psa_utils.debug_other_string(g_state_level,l_full_path,' l_user_id -->' || l_user_id);
3357: psa_utils.debug_other_string(g_state_level,l_full_path,' l_actual_flag -->' || l_actual_flag);
3358: psa_utils.debug_other_string(g_state_level,l_full_path,' l_status -->' || l_status);
3359: psa_utils.debug_other_string(g_state_level,l_full_path,' l_inv_cat_name -->' || l_inv_cat_name);
3360: psa_utils.debug_other_string(g_state_level,l_full_path,' l_cm_cat_name -->' || l_cm_cat_name);

Line 3357: psa_utils.debug_other_string(g_state_level,l_full_path,' l_actual_flag -->' || l_actual_flag);

3353: psa_utils.debug_other_string(g_state_level,l_full_path,' LISTING THE VARIABLES AND VALUES :');
3354: psa_utils.debug_other_string(g_state_level,l_full_path,' ==================================');
3355: psa_utils.debug_other_string(g_state_level,l_full_path,' l_batch_prefix -->' || l_batch_prefix);
3356: psa_utils.debug_other_string(g_state_level,l_full_path,' l_user_id -->' || l_user_id);
3357: psa_utils.debug_other_string(g_state_level,l_full_path,' l_actual_flag -->' || l_actual_flag);
3358: psa_utils.debug_other_string(g_state_level,l_full_path,' l_status -->' || l_status);
3359: psa_utils.debug_other_string(g_state_level,l_full_path,' l_inv_cat_name -->' || l_inv_cat_name);
3360: psa_utils.debug_other_string(g_state_level,l_full_path,' l_cm_cat_name -->' || l_cm_cat_name);
3361: psa_utils.debug_other_string(g_state_level,l_full_path,' l_dm_cat_name -->' || l_dm_cat_name);

Line 3358: psa_utils.debug_other_string(g_state_level,l_full_path,' l_status -->' || l_status);

3354: psa_utils.debug_other_string(g_state_level,l_full_path,' ==================================');
3355: psa_utils.debug_other_string(g_state_level,l_full_path,' l_batch_prefix -->' || l_batch_prefix);
3356: psa_utils.debug_other_string(g_state_level,l_full_path,' l_user_id -->' || l_user_id);
3357: psa_utils.debug_other_string(g_state_level,l_full_path,' l_actual_flag -->' || l_actual_flag);
3358: psa_utils.debug_other_string(g_state_level,l_full_path,' l_status -->' || l_status);
3359: psa_utils.debug_other_string(g_state_level,l_full_path,' l_inv_cat_name -->' || l_inv_cat_name);
3360: psa_utils.debug_other_string(g_state_level,l_full_path,' l_cm_cat_name -->' || l_cm_cat_name);
3361: psa_utils.debug_other_string(g_state_level,l_full_path,' l_dm_cat_name -->' || l_dm_cat_name);
3362: psa_utils.debug_other_string(g_state_level,l_full_path,' l_cb_cat_name -->' || l_cb_cat_name);

Line 3359: psa_utils.debug_other_string(g_state_level,l_full_path,' l_inv_cat_name -->' || l_inv_cat_name);

3355: psa_utils.debug_other_string(g_state_level,l_full_path,' l_batch_prefix -->' || l_batch_prefix);
3356: psa_utils.debug_other_string(g_state_level,l_full_path,' l_user_id -->' || l_user_id);
3357: psa_utils.debug_other_string(g_state_level,l_full_path,' l_actual_flag -->' || l_actual_flag);
3358: psa_utils.debug_other_string(g_state_level,l_full_path,' l_status -->' || l_status);
3359: psa_utils.debug_other_string(g_state_level,l_full_path,' l_inv_cat_name -->' || l_inv_cat_name);
3360: psa_utils.debug_other_string(g_state_level,l_full_path,' l_cm_cat_name -->' || l_cm_cat_name);
3361: psa_utils.debug_other_string(g_state_level,l_full_path,' l_dm_cat_name -->' || l_dm_cat_name);
3362: psa_utils.debug_other_string(g_state_level,l_full_path,' l_cb_cat_name -->' || l_cb_cat_name);
3363: psa_utils.debug_other_string(g_state_level,l_full_path,' l_trade_cat_name -->' || l_trade_cat_name);

Line 3360: psa_utils.debug_other_string(g_state_level,l_full_path,' l_cm_cat_name -->' || l_cm_cat_name);

3356: psa_utils.debug_other_string(g_state_level,l_full_path,' l_user_id -->' || l_user_id);
3357: psa_utils.debug_other_string(g_state_level,l_full_path,' l_actual_flag -->' || l_actual_flag);
3358: psa_utils.debug_other_string(g_state_level,l_full_path,' l_status -->' || l_status);
3359: psa_utils.debug_other_string(g_state_level,l_full_path,' l_inv_cat_name -->' || l_inv_cat_name);
3360: psa_utils.debug_other_string(g_state_level,l_full_path,' l_cm_cat_name -->' || l_cm_cat_name);
3361: psa_utils.debug_other_string(g_state_level,l_full_path,' l_dm_cat_name -->' || l_dm_cat_name);
3362: psa_utils.debug_other_string(g_state_level,l_full_path,' l_cb_cat_name -->' || l_cb_cat_name);
3363: psa_utils.debug_other_string(g_state_level,l_full_path,' l_trade_cat_name -->' || l_trade_cat_name);
3364: psa_utils.debug_other_string(g_state_level,l_full_path,' l_ccurr_cat_name -->' || l_ccurr_cat_name);

Line 3361: psa_utils.debug_other_string(g_state_level,l_full_path,' l_dm_cat_name -->' || l_dm_cat_name);

3357: psa_utils.debug_other_string(g_state_level,l_full_path,' l_actual_flag -->' || l_actual_flag);
3358: psa_utils.debug_other_string(g_state_level,l_full_path,' l_status -->' || l_status);
3359: psa_utils.debug_other_string(g_state_level,l_full_path,' l_inv_cat_name -->' || l_inv_cat_name);
3360: psa_utils.debug_other_string(g_state_level,l_full_path,' l_cm_cat_name -->' || l_cm_cat_name);
3361: psa_utils.debug_other_string(g_state_level,l_full_path,' l_dm_cat_name -->' || l_dm_cat_name);
3362: psa_utils.debug_other_string(g_state_level,l_full_path,' l_cb_cat_name -->' || l_cb_cat_name);
3363: psa_utils.debug_other_string(g_state_level,l_full_path,' l_trade_cat_name -->' || l_trade_cat_name);
3364: psa_utils.debug_other_string(g_state_level,l_full_path,' l_ccurr_cat_name -->' || l_ccurr_cat_name);
3365: psa_utils.debug_other_string(g_state_level,l_full_path,' l_adj_cat_name -->' || l_adj_cat_name);

Line 3362: psa_utils.debug_other_string(g_state_level,l_full_path,' l_cb_cat_name -->' || l_cb_cat_name);

3358: psa_utils.debug_other_string(g_state_level,l_full_path,' l_status -->' || l_status);
3359: psa_utils.debug_other_string(g_state_level,l_full_path,' l_inv_cat_name -->' || l_inv_cat_name);
3360: psa_utils.debug_other_string(g_state_level,l_full_path,' l_cm_cat_name -->' || l_cm_cat_name);
3361: psa_utils.debug_other_string(g_state_level,l_full_path,' l_dm_cat_name -->' || l_dm_cat_name);
3362: psa_utils.debug_other_string(g_state_level,l_full_path,' l_cb_cat_name -->' || l_cb_cat_name);
3363: psa_utils.debug_other_string(g_state_level,l_full_path,' l_trade_cat_name -->' || l_trade_cat_name);
3364: psa_utils.debug_other_string(g_state_level,l_full_path,' l_ccurr_cat_name -->' || l_ccurr_cat_name);
3365: psa_utils.debug_other_string(g_state_level,l_full_path,' l_adj_cat_name -->' || l_adj_cat_name);
3366: psa_utils.debug_other_string(g_state_level,l_full_path,' l_misc_cat_name -->' || l_misc_cat_name);

Line 3363: psa_utils.debug_other_string(g_state_level,l_full_path,' l_trade_cat_name -->' || l_trade_cat_name);

3359: psa_utils.debug_other_string(g_state_level,l_full_path,' l_inv_cat_name -->' || l_inv_cat_name);
3360: psa_utils.debug_other_string(g_state_level,l_full_path,' l_cm_cat_name -->' || l_cm_cat_name);
3361: psa_utils.debug_other_string(g_state_level,l_full_path,' l_dm_cat_name -->' || l_dm_cat_name);
3362: psa_utils.debug_other_string(g_state_level,l_full_path,' l_cb_cat_name -->' || l_cb_cat_name);
3363: psa_utils.debug_other_string(g_state_level,l_full_path,' l_trade_cat_name -->' || l_trade_cat_name);
3364: psa_utils.debug_other_string(g_state_level,l_full_path,' l_ccurr_cat_name -->' || l_ccurr_cat_name);
3365: psa_utils.debug_other_string(g_state_level,l_full_path,' l_adj_cat_name -->' || l_adj_cat_name);
3366: psa_utils.debug_other_string(g_state_level,l_full_path,' l_misc_cat_name -->' || l_misc_cat_name);
3367: psa_utils.debug_other_string(g_state_level,l_full_path,' l_source -->' || l_source);

Line 3364: psa_utils.debug_other_string(g_state_level,l_full_path,' l_ccurr_cat_name -->' || l_ccurr_cat_name);

3360: psa_utils.debug_other_string(g_state_level,l_full_path,' l_cm_cat_name -->' || l_cm_cat_name);
3361: psa_utils.debug_other_string(g_state_level,l_full_path,' l_dm_cat_name -->' || l_dm_cat_name);
3362: psa_utils.debug_other_string(g_state_level,l_full_path,' l_cb_cat_name -->' || l_cb_cat_name);
3363: psa_utils.debug_other_string(g_state_level,l_full_path,' l_trade_cat_name -->' || l_trade_cat_name);
3364: psa_utils.debug_other_string(g_state_level,l_full_path,' l_ccurr_cat_name -->' || l_ccurr_cat_name);
3365: psa_utils.debug_other_string(g_state_level,l_full_path,' l_adj_cat_name -->' || l_adj_cat_name);
3366: psa_utils.debug_other_string(g_state_level,l_full_path,' l_misc_cat_name -->' || l_misc_cat_name);
3367: psa_utils.debug_other_string(g_state_level,l_full_path,' l_source -->' || l_source);
3368: psa_utils.debug_other_string(g_state_level,l_full_path,' l_func_curr -->' || l_func_curr);

Line 3365: psa_utils.debug_other_string(g_state_level,l_full_path,' l_adj_cat_name -->' || l_adj_cat_name);

3361: psa_utils.debug_other_string(g_state_level,l_full_path,' l_dm_cat_name -->' || l_dm_cat_name);
3362: psa_utils.debug_other_string(g_state_level,l_full_path,' l_cb_cat_name -->' || l_cb_cat_name);
3363: psa_utils.debug_other_string(g_state_level,l_full_path,' l_trade_cat_name -->' || l_trade_cat_name);
3364: psa_utils.debug_other_string(g_state_level,l_full_path,' l_ccurr_cat_name -->' || l_ccurr_cat_name);
3365: psa_utils.debug_other_string(g_state_level,l_full_path,' l_adj_cat_name -->' || l_adj_cat_name);
3366: psa_utils.debug_other_string(g_state_level,l_full_path,' l_misc_cat_name -->' || l_misc_cat_name);
3367: psa_utils.debug_other_string(g_state_level,l_full_path,' l_source -->' || l_source);
3368: psa_utils.debug_other_string(g_state_level,l_full_path,' l_func_curr -->' || l_func_curr);
3369: psa_utils.debug_other_string(g_state_level,l_full_path,' l_post_det_acct_flag -->' || l_post_det_acct_flag);

Line 3366: psa_utils.debug_other_string(g_state_level,l_full_path,' l_misc_cat_name -->' || l_misc_cat_name);

3362: psa_utils.debug_other_string(g_state_level,l_full_path,' l_cb_cat_name -->' || l_cb_cat_name);
3363: psa_utils.debug_other_string(g_state_level,l_full_path,' l_trade_cat_name -->' || l_trade_cat_name);
3364: psa_utils.debug_other_string(g_state_level,l_full_path,' l_ccurr_cat_name -->' || l_ccurr_cat_name);
3365: psa_utils.debug_other_string(g_state_level,l_full_path,' l_adj_cat_name -->' || l_adj_cat_name);
3366: psa_utils.debug_other_string(g_state_level,l_full_path,' l_misc_cat_name -->' || l_misc_cat_name);
3367: psa_utils.debug_other_string(g_state_level,l_full_path,' l_source -->' || l_source);
3368: psa_utils.debug_other_string(g_state_level,l_full_path,' l_func_curr -->' || l_func_curr);
3369: psa_utils.debug_other_string(g_state_level,l_full_path,' l_post_det_acct_flag -->' || l_post_det_acct_flag);
3370: psa_utils.debug_other_string(g_state_level,l_full_path,' l_user_resp_id -->' || l_user_resp_id);

Line 3367: psa_utils.debug_other_string(g_state_level,l_full_path,' l_source -->' || l_source);

3363: psa_utils.debug_other_string(g_state_level,l_full_path,' l_trade_cat_name -->' || l_trade_cat_name);
3364: psa_utils.debug_other_string(g_state_level,l_full_path,' l_ccurr_cat_name -->' || l_ccurr_cat_name);
3365: psa_utils.debug_other_string(g_state_level,l_full_path,' l_adj_cat_name -->' || l_adj_cat_name);
3366: psa_utils.debug_other_string(g_state_level,l_full_path,' l_misc_cat_name -->' || l_misc_cat_name);
3367: psa_utils.debug_other_string(g_state_level,l_full_path,' l_source -->' || l_source);
3368: psa_utils.debug_other_string(g_state_level,l_full_path,' l_func_curr -->' || l_func_curr);
3369: psa_utils.debug_other_string(g_state_level,l_full_path,' l_post_det_acct_flag -->' || l_post_det_acct_flag);
3370: psa_utils.debug_other_string(g_state_level,l_full_path,' l_user_resp_id -->' || l_user_resp_id);
3371: psa_utils.debug_other_string(g_state_level,l_full_path,' l_resp_appl_id -->' || l_resp_appl_id);

Line 3368: psa_utils.debug_other_string(g_state_level,l_full_path,' l_func_curr -->' || l_func_curr);

3364: psa_utils.debug_other_string(g_state_level,l_full_path,' l_ccurr_cat_name -->' || l_ccurr_cat_name);
3365: psa_utils.debug_other_string(g_state_level,l_full_path,' l_adj_cat_name -->' || l_adj_cat_name);
3366: psa_utils.debug_other_string(g_state_level,l_full_path,' l_misc_cat_name -->' || l_misc_cat_name);
3367: psa_utils.debug_other_string(g_state_level,l_full_path,' l_source -->' || l_source);
3368: psa_utils.debug_other_string(g_state_level,l_full_path,' l_func_curr -->' || l_func_curr);
3369: psa_utils.debug_other_string(g_state_level,l_full_path,' l_post_det_acct_flag -->' || l_post_det_acct_flag);
3370: psa_utils.debug_other_string(g_state_level,l_full_path,' l_user_resp_id -->' || l_user_resp_id);
3371: psa_utils.debug_other_string(g_state_level,l_full_path,' l_resp_appl_id -->' || l_resp_appl_id);
3372: psa_utils.debug_other_string(g_state_level,l_full_path,' l_pst_ctrl_id -->' || l_pst_ctrl_id);

Line 3369: psa_utils.debug_other_string(g_state_level,l_full_path,' l_post_det_acct_flag -->' || l_post_det_acct_flag);

3365: psa_utils.debug_other_string(g_state_level,l_full_path,' l_adj_cat_name -->' || l_adj_cat_name);
3366: psa_utils.debug_other_string(g_state_level,l_full_path,' l_misc_cat_name -->' || l_misc_cat_name);
3367: psa_utils.debug_other_string(g_state_level,l_full_path,' l_source -->' || l_source);
3368: psa_utils.debug_other_string(g_state_level,l_full_path,' l_func_curr -->' || l_func_curr);
3369: psa_utils.debug_other_string(g_state_level,l_full_path,' l_post_det_acct_flag -->' || l_post_det_acct_flag);
3370: psa_utils.debug_other_string(g_state_level,l_full_path,' l_user_resp_id -->' || l_user_resp_id);
3371: psa_utils.debug_other_string(g_state_level,l_full_path,' l_resp_appl_id -->' || l_resp_appl_id);
3372: psa_utils.debug_other_string(g_state_level,l_full_path,' l_pst_ctrl_id -->' || l_pst_ctrl_id);
3373: psa_utils.debug_other_string(g_state_level,l_full_path,' ');

Line 3370: psa_utils.debug_other_string(g_state_level,l_full_path,' l_user_resp_id -->' || l_user_resp_id);

3366: psa_utils.debug_other_string(g_state_level,l_full_path,' l_misc_cat_name -->' || l_misc_cat_name);
3367: psa_utils.debug_other_string(g_state_level,l_full_path,' l_source -->' || l_source);
3368: psa_utils.debug_other_string(g_state_level,l_full_path,' l_func_curr -->' || l_func_curr);
3369: psa_utils.debug_other_string(g_state_level,l_full_path,' l_post_det_acct_flag -->' || l_post_det_acct_flag);
3370: psa_utils.debug_other_string(g_state_level,l_full_path,' l_user_resp_id -->' || l_user_resp_id);
3371: psa_utils.debug_other_string(g_state_level,l_full_path,' l_resp_appl_id -->' || l_resp_appl_id);
3372: psa_utils.debug_other_string(g_state_level,l_full_path,' l_pst_ctrl_id -->' || l_pst_ctrl_id);
3373: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
3374: psa_utils.debug_other_string(g_state_level,l_full_path, ' ** REST ARE MESSAGES ** ');

Line 3371: psa_utils.debug_other_string(g_state_level,l_full_path,' l_resp_appl_id -->' || l_resp_appl_id);

3367: psa_utils.debug_other_string(g_state_level,l_full_path,' l_source -->' || l_source);
3368: psa_utils.debug_other_string(g_state_level,l_full_path,' l_func_curr -->' || l_func_curr);
3369: psa_utils.debug_other_string(g_state_level,l_full_path,' l_post_det_acct_flag -->' || l_post_det_acct_flag);
3370: psa_utils.debug_other_string(g_state_level,l_full_path,' l_user_resp_id -->' || l_user_resp_id);
3371: psa_utils.debug_other_string(g_state_level,l_full_path,' l_resp_appl_id -->' || l_resp_appl_id);
3372: psa_utils.debug_other_string(g_state_level,l_full_path,' l_pst_ctrl_id -->' || l_pst_ctrl_id);
3373: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
3374: psa_utils.debug_other_string(g_state_level,l_full_path, ' ** REST ARE MESSAGES ** ');
3375: psa_utils.debug_other_string(g_state_level,l_full_path,' ');

Line 3372: psa_utils.debug_other_string(g_state_level,l_full_path,' l_pst_ctrl_id -->' || l_pst_ctrl_id);

3368: psa_utils.debug_other_string(g_state_level,l_full_path,' l_func_curr -->' || l_func_curr);
3369: psa_utils.debug_other_string(g_state_level,l_full_path,' l_post_det_acct_flag -->' || l_post_det_acct_flag);
3370: psa_utils.debug_other_string(g_state_level,l_full_path,' l_user_resp_id -->' || l_user_resp_id);
3371: psa_utils.debug_other_string(g_state_level,l_full_path,' l_resp_appl_id -->' || l_resp_appl_id);
3372: psa_utils.debug_other_string(g_state_level,l_full_path,' l_pst_ctrl_id -->' || l_pst_ctrl_id);
3373: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
3374: psa_utils.debug_other_string(g_state_level,l_full_path, ' ** REST ARE MESSAGES ** ');
3375: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
3376: psa_utils.debug_other_string(g_state_level,l_full_path,' --> Populate_global_variables - END '

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

3369: psa_utils.debug_other_string(g_state_level,l_full_path,' l_post_det_acct_flag -->' || l_post_det_acct_flag);
3370: psa_utils.debug_other_string(g_state_level,l_full_path,' l_user_resp_id -->' || l_user_resp_id);
3371: psa_utils.debug_other_string(g_state_level,l_full_path,' l_resp_appl_id -->' || l_resp_appl_id);
3372: psa_utils.debug_other_string(g_state_level,l_full_path,' l_pst_ctrl_id -->' || l_pst_ctrl_id);
3373: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
3374: psa_utils.debug_other_string(g_state_level,l_full_path, ' ** REST ARE MESSAGES ** ');
3375: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
3376: psa_utils.debug_other_string(g_state_level,l_full_path,' --> Populate_global_variables - END '
3377: || to_char(sysdate, 'DD/MM/YYYY HH:MI:SS'));

Line 3374: psa_utils.debug_other_string(g_state_level,l_full_path, ' REST ARE MESSAGES ');

3370: psa_utils.debug_other_string(g_state_level,l_full_path,' l_user_resp_id -->' || l_user_resp_id);
3371: psa_utils.debug_other_string(g_state_level,l_full_path,' l_resp_appl_id -->' || l_resp_appl_id);
3372: psa_utils.debug_other_string(g_state_level,l_full_path,' l_pst_ctrl_id -->' || l_pst_ctrl_id);
3373: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
3374: psa_utils.debug_other_string(g_state_level,l_full_path, ' ** REST ARE MESSAGES ** ');
3375: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
3376: psa_utils.debug_other_string(g_state_level,l_full_path,' --> Populate_global_variables - END '
3377: || to_char(sysdate, 'DD/MM/YYYY HH:MI:SS'));
3378: -- ========================= FND LOG ===========================

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

3371: psa_utils.debug_other_string(g_state_level,l_full_path,' l_resp_appl_id -->' || l_resp_appl_id);
3372: psa_utils.debug_other_string(g_state_level,l_full_path,' l_pst_ctrl_id -->' || l_pst_ctrl_id);
3373: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
3374: psa_utils.debug_other_string(g_state_level,l_full_path, ' ** REST ARE MESSAGES ** ');
3375: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
3376: psa_utils.debug_other_string(g_state_level,l_full_path,' --> Populate_global_variables - END '
3377: || to_char(sysdate, 'DD/MM/YYYY HH:MI:SS'));
3378: -- ========================= FND LOG ===========================
3379:

Line 3376: psa_utils.debug_other_string(g_state_level,l_full_path,' --> Populate_global_variables - END '

3372: psa_utils.debug_other_string(g_state_level,l_full_path,' l_pst_ctrl_id -->' || l_pst_ctrl_id);
3373: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
3374: psa_utils.debug_other_string(g_state_level,l_full_path, ' ** REST ARE MESSAGES ** ');
3375: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
3376: psa_utils.debug_other_string(g_state_level,l_full_path,' --> Populate_global_variables - END '
3377: || to_char(sysdate, 'DD/MM/YYYY HH:MI:SS'));
3378: -- ========================= FND LOG ===========================
3379:
3380: EXCEPTION

Line 3384: psa_utils.debug_other_string(g_excep_level,l_full_path,

3380: EXCEPTION
3381:
3382: WHEN OTHERS THEN
3383: -- ========================= FND LOG ===========================
3384: psa_utils.debug_other_string(g_excep_level,l_full_path,
3385: ' --> EXCEPTION - OTHERS raised during PSA_TRANSFER_TO_GL_PKG.Populate_global_variables ');
3386: psa_utils.debug_other_string(g_excep_level,l_full_path, sqlcode || sqlerrm);
3387: psa_utils.debug_unexpected_msg(l_full_path);
3388: -- ========================= FND LOG ===========================

Line 3386: psa_utils.debug_other_string(g_excep_level,l_full_path, sqlcode || sqlerrm);

3382: WHEN OTHERS THEN
3383: -- ========================= FND LOG ===========================
3384: psa_utils.debug_other_string(g_excep_level,l_full_path,
3385: ' --> EXCEPTION - OTHERS raised during PSA_TRANSFER_TO_GL_PKG.Populate_global_variables ');
3386: psa_utils.debug_other_string(g_excep_level,l_full_path, sqlcode || sqlerrm);
3387: psa_utils.debug_unexpected_msg(l_full_path);
3388: -- ========================= FND LOG ===========================
3389: app_exception.raise_exception;
3390:

Line 3387: psa_utils.debug_unexpected_msg(l_full_path);

3383: -- ========================= FND LOG ===========================
3384: psa_utils.debug_other_string(g_excep_level,l_full_path,
3385: ' --> EXCEPTION - OTHERS raised during PSA_TRANSFER_TO_GL_PKG.Populate_global_variables ');
3386: psa_utils.debug_other_string(g_excep_level,l_full_path, sqlcode || sqlerrm);
3387: psa_utils.debug_unexpected_msg(l_full_path);
3388: -- ========================= FND LOG ===========================
3389: app_exception.raise_exception;
3390:
3391: END Populate_global_variables;

Line 3541: psa_utils.debug_other_string(g_state_level,l_full_path,

3537: l_full_path VARCHAR2(100) := g_path || 'Upd_seg_in_gl_interface';
3538: -- ========================= FND LOG ===========================
3539: BEGIN
3540: -- ========================= FND LOG ===========================
3541: psa_utils.debug_other_string(g_state_level,l_full_path,
3542: ' --> Upd_seg_in_gl_interface - START '
3543: || to_char (sysdate, 'DD/MM/YYYY HH:MI:SS'));
3544: -- ========================= FND LOG ===========================
3545:

Line 3565: psa_utils.debug_other_string(g_state_level,l_full_path,

3561: WHERE gi.group_id = l_pst_ctrl_id
3562: AND reference10 like '%MFAR%';
3563:
3564: -- ========================= FND LOG ===========================
3565: psa_utils.debug_other_string(g_state_level,l_full_path,
3566: ' --> Upd_seg_in_gl_interface - END '
3567: || to_char (sysdate, 'DD/MM/YYYY HH:MI:SS'));
3568: -- ========================= FND LOG ===========================
3569:

Line 3961: psa_utils.debug_other_string(g_excep_level,l_full_path,

3957:
3958: EXCEPTION
3959: WHEN INVALID_DISTRIBUTION THEN
3960: -- ========================= FND LOG ===========================
3961: psa_utils.debug_other_string(g_excep_level,l_full_path,
3962: ' PSA_XFR_TO_GL_PKG.Mfar_rct_to_gl: Unable to create Multi-Fund distributions for Receivable Application ID: ' || I.receivable_application_id);
3963: psa_utils.debug_other_string(g_excep_level,l_full_path,' Error Message : ' || l_error_message);
3964: -- ========================= FND LOG ===========================
3965: retcode := 'F';

Line 3963: psa_utils.debug_other_string(g_excep_level,l_full_path,' Error Message : ' || l_error_message);

3959: WHEN INVALID_DISTRIBUTION THEN
3960: -- ========================= FND LOG ===========================
3961: psa_utils.debug_other_string(g_excep_level,l_full_path,
3962: ' PSA_XFR_TO_GL_PKG.Mfar_rct_to_gl: Unable to create Multi-Fund distributions for Receivable Application ID: ' || I.receivable_application_id);
3963: psa_utils.debug_other_string(g_excep_level,l_full_path,' Error Message : ' || l_error_message);
3964: -- ========================= FND LOG ===========================
3965: retcode := 'F';
3966:
3967: WHEN OTHERS THEN

Line 3969: psa_utils.debug_other_string(g_excep_level,l_full_path,

3965: retcode := 'F';
3966:
3967: WHEN OTHERS THEN
3968: -- ========================= FND LOG ===========================
3969: psa_utils.debug_other_string(g_excep_level,l_full_path,
3970: ' PSA_XFR_TO_GL_PKG.Mfar_rct_to_gl: Unable to create Multi-Fund distributions for Receivable Application ID: ' || I.receivable_application_id);
3971: psa_utils.debug_other_string(g_excep_level,l_full_path,' Error Message : ' || sqlerrm);
3972: psa_utils.debug_unexpected_msg(l_full_path);
3973: -- ========================= FND LOG ===========================

Line 3971: psa_utils.debug_other_string(g_excep_level,l_full_path,' Error Message : ' || sqlerrm);

3967: WHEN OTHERS THEN
3968: -- ========================= FND LOG ===========================
3969: psa_utils.debug_other_string(g_excep_level,l_full_path,
3970: ' PSA_XFR_TO_GL_PKG.Mfar_rct_to_gl: Unable to create Multi-Fund distributions for Receivable Application ID: ' || I.receivable_application_id);
3971: psa_utils.debug_other_string(g_excep_level,l_full_path,' Error Message : ' || sqlerrm);
3972: psa_utils.debug_unexpected_msg(l_full_path);
3973: -- ========================= FND LOG ===========================
3974: retcode := 'F';
3975:

Line 3972: psa_utils.debug_unexpected_msg(l_full_path);

3968: -- ========================= FND LOG ===========================
3969: psa_utils.debug_other_string(g_excep_level,l_full_path,
3970: ' PSA_XFR_TO_GL_PKG.Mfar_rct_to_gl: Unable to create Multi-Fund distributions for Receivable Application ID: ' || I.receivable_application_id);
3971: psa_utils.debug_other_string(g_excep_level,l_full_path,' Error Message : ' || sqlerrm);
3972: psa_utils.debug_unexpected_msg(l_full_path);
3973: -- ========================= FND LOG ===========================
3974: retcode := 'F';
3975:
3976: END;

Line 4095: psa_utils.debug_other_string(g_excep_level,l_full_path,

4091:
4092: EXCEPTION
4093: WHEN OTHERS THEN
4094: -- ========================= FND LOG ===========================
4095: psa_utils.debug_other_string(g_excep_level,l_full_path,
4096: ' PSA_XFR_TO_GL_PKG.Mfar_rct_to_gl: Exception : OTHERS ');
4097: psa_utils.debug_other_string(g_excep_level,l_full_path,' Error Message : ' || sqlerrm);
4098: psa_utils.debug_unexpected_msg(l_full_path);
4099: -- ========================= FND LOG ===========================

Line 4097: psa_utils.debug_other_string(g_excep_level,l_full_path,' Error Message : ' || sqlerrm);

4093: WHEN OTHERS THEN
4094: -- ========================= FND LOG ===========================
4095: psa_utils.debug_other_string(g_excep_level,l_full_path,
4096: ' PSA_XFR_TO_GL_PKG.Mfar_rct_to_gl: Exception : OTHERS ');
4097: psa_utils.debug_other_string(g_excep_level,l_full_path,' Error Message : ' || sqlerrm);
4098: psa_utils.debug_unexpected_msg(l_full_path);
4099: -- ========================= FND LOG ===========================
4100: retcode := 'F';
4101:

Line 4098: psa_utils.debug_unexpected_msg(l_full_path);

4094: -- ========================= FND LOG ===========================
4095: psa_utils.debug_other_string(g_excep_level,l_full_path,
4096: ' PSA_XFR_TO_GL_PKG.Mfar_rct_to_gl: Exception : OTHERS ');
4097: psa_utils.debug_other_string(g_excep_level,l_full_path,' Error Message : ' || sqlerrm);
4098: psa_utils.debug_unexpected_msg(l_full_path);
4099: -- ========================= FND LOG ===========================
4100: retcode := 'F';
4101:
4102: END Mfar_rcpt_to_gl_CB;

Line 4216: psa_utils.debug_other_string(g_excep_level,l_full_path,

4212:
4213:
4214: IF l_error_message IS NOT NULL OR l_retcode = 'F' THEN
4215: -- ========================= FND LOG ===========================
4216: psa_utils.debug_other_string(g_excep_level,l_full_path,
4217: 'Misc_rct_to_gl: Raising invalid_distribution');
4218: -- ========================= FND LOG ===========================
4219: Raise invalid_distribution;
4220: END IF;

Line 4230: psa_utils.debug_other_string(g_excep_level,l_full_path,

4226:
4227: EXCEPTION
4228: WHEN INVALID_DISTRIBUTION THEN
4229: -- ========================= FND LOG ===========================
4230: psa_utils.debug_other_string(g_excep_level,l_full_path,
4231: ' p_error_message --> ' || l_error_message);
4232: -- ========================= FND LOG ===========================
4233: retcode := 'F';
4234:

Line 4237: psa_utils.debug_other_string(g_excep_level,l_full_path,

4233: retcode := 'F';
4234:
4235: WHEN OTHERS THEN
4236: -- ========================= FND LOG ===========================
4237: psa_utils.debug_other_string(g_excep_level,l_full_path,
4238: 'EXCEPTION - OTHERS raised during PSA_MF_CREATE_DISTRIBUTIONS.create_distributions ' || 'in PSA_TRANSFER_TO_GL_PKG.Misc_rct_to_gl ');
4239: psa_utils.debug_unexpected_msg(l_full_path);
4240: -- ========================= FND LOG ===========================
4241: errbuf := 2;

Line 4239: psa_utils.debug_unexpected_msg(l_full_path);

4235: WHEN OTHERS THEN
4236: -- ========================= FND LOG ===========================
4237: psa_utils.debug_other_string(g_excep_level,l_full_path,
4238: 'EXCEPTION - OTHERS raised during PSA_MF_CREATE_DISTRIBUTIONS.create_distributions ' || 'in PSA_TRANSFER_TO_GL_PKG.Misc_rct_to_gl ');
4239: psa_utils.debug_unexpected_msg(l_full_path);
4240: -- ========================= FND LOG ===========================
4241: errbuf := 2;
4242: retcode := 'F';
4243:

Line 4340: psa_utils.debug_other_string(g_excep_level,l_full_path,

4336:
4337: EXCEPTION
4338: WHEN OTHERS THEN
4339: -- ========================= FND LOG ===========================
4340: psa_utils.debug_other_string(g_excep_level,l_full_path,
4341: 'EXCEPTION - OTHERS raised during in PSA_TRANSFER_TO_GL_PKG.Misc_rct_to_gl - rolling back ');
4342: psa_utils.debug_other_string(g_excep_level,l_full_path, sqlcode || sqlerrm);
4343: psa_utils.debug_unexpected_msg(l_full_path);
4344: -- ========================= FND LOG ===========================

Line 4342: psa_utils.debug_other_string(g_excep_level,l_full_path, sqlcode || sqlerrm);

4338: WHEN OTHERS THEN
4339: -- ========================= FND LOG ===========================
4340: psa_utils.debug_other_string(g_excep_level,l_full_path,
4341: 'EXCEPTION - OTHERS raised during in PSA_TRANSFER_TO_GL_PKG.Misc_rct_to_gl - rolling back ');
4342: psa_utils.debug_other_string(g_excep_level,l_full_path, sqlcode || sqlerrm);
4343: psa_utils.debug_unexpected_msg(l_full_path);
4344: -- ========================= FND LOG ===========================
4345: errbuf := 2;
4346: retcode := 'F';

Line 4343: psa_utils.debug_unexpected_msg(l_full_path);

4339: -- ========================= FND LOG ===========================
4340: psa_utils.debug_other_string(g_excep_level,l_full_path,
4341: 'EXCEPTION - OTHERS raised during in PSA_TRANSFER_TO_GL_PKG.Misc_rct_to_gl - rolling back ');
4342: psa_utils.debug_other_string(g_excep_level,l_full_path, sqlcode || sqlerrm);
4343: psa_utils.debug_unexpected_msg(l_full_path);
4344: -- ========================= FND LOG ===========================
4345: errbuf := 2;
4346: retcode := 'F';
4347: