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.CE_ZBA_DEAL_GENERATION dependencies on CEP_STANDARD

Line 127: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.xtr_shared_account'|| '----------' ||

123: X_ERROR_MSG VARCHAR2(1000);
124:
125: BEGIN
126: IF l_DEBUG in ('Y', 'C') THEN
127: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.xtr_shared_account'|| '----------' ||
128: 'xtr_shared_account ORG_ID = '|| CE_ZBA_DEAL_GENERATION.csh_org_id|| '----------' ||
129: 'xtr_shared_account BANK_ACCOUNT_ID = '|| CE_ZBA_DEAL_GENERATION.csh_bank_account_id|| '----------' ||
130: 'xtr_shared_account CURRENCY_CODE = '|| CE_ZBA_DEAL_GENERATION.cba_bank_currency);
131: END IF;

Line 141: cep_standard.debug('xtr_shared_account x_account_result = ' || x_account_result|| '----------' ||

137: P_RESULT => X_ACCOUNT_RESULT,
138: P_ERROR_MSG => X_ERROR_MSG);
139: */
140: IF l_DEBUG in ('Y', 'C') THEN
141: cep_standard.debug('xtr_shared_account x_account_result = ' || x_account_result|| '----------' ||
142: 'xtr_shared_account x_error_msg = ' || x_error_msg);
143: END IF;
144:
145: IF l_DEBUG in ('Y', 'C') THEN

Line 146: cep_standard.debug('<

142: 'xtr_shared_account x_error_msg = ' || x_error_msg);
143: END IF;
144:
145: IF l_DEBUG in ('Y', 'C') THEN
146: cep_standard.debug('< 147: END IF;
148:
149: EXCEPTION
150: WHEN OTHERS THEN

Line 152: cep_standard.debug('EXCEPTION: CE_ZBA_DEAL_GENERATION.xtr_shared_account');

148:
149: EXCEPTION
150: WHEN OTHERS THEN
151: IF l_DEBUG in ('Y', 'C') THEN
152: cep_standard.debug('EXCEPTION: CE_ZBA_DEAL_GENERATION.xtr_shared_account');
153: END IF;
154: RAISE;
155: END xtr_shared_account;
156:

Line 180: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.lock_statement');

176: lockmode NUMBER;
177: timeout NUMBER;
178: release_on_commit BOOLEAN;
179: BEGIN
180: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.lock_statement');
181:
182: SELECT statement_header_id
183: INTO x_statement_header_id
184: FROM ce_statement_headers

Line 188: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.Regular statement lock OK');

184: FROM ce_statement_headers
185: WHERE rowid = CE_ZBA_DEAL_GENERATION.csh_rowid
186: FOR UPDATE OF statement_header_id NOWAIT;
187:
188: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.Regular statement lock OK');
189: lockname := CE_ZBA_DEAL_GENERATION.csh_rowid;
190: timeout := 1;
191: lockmode := 6;
192: expiration_secs := 10;

Line 197: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.Allocating unique');

193: release_on_commit := FALSE;
194: --
195: -- dbms_lock of row to deal with other locking
196: --
197: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.Allocating unique');
198: dbms_lock.allocate_unique (lockname, lockhandle, expiration_secs);
199: lock_status := dbms_lock.request( lockhandle, lockmode, timeout,
200: release_on_commit );
201: IF (lock_status <> 0) THEN

Line 205: cep_standard.debug('<

201: IF (lock_status <> 0) THEN
202: lock_status := dbms_lock.release(lockhandle);
203: RAISE APP_EXCEPTIONS.record_lock_exception;
204: END IF;
205: cep_standard.debug('< 206: RETURN(TRUE);
207: EXCEPTION
208: WHEN APP_EXCEPTIONS.record_lock_exception THEN
209: return(FALSE);

Line 211: cep_standard.debug('EXCEPTION: CE_ZBA_DEAL_GENERATION.lock_statement' );

207: EXCEPTION
208: WHEN APP_EXCEPTIONS.record_lock_exception THEN
209: return(FALSE);
210: WHEN OTHERS THEN
211: cep_standard.debug('EXCEPTION: CE_ZBA_DEAL_GENERATION.lock_statement' );
212: RAISE;
213: return(FALSE);
214: END lock_statement;
215:

Line 228: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.lock_statement_line');

224: | zba_generation |
225: --------------------------------------------------------------------- */
226: FUNCTION lock_statement_line RETURN BOOLEAN IS
227: BEGIN
228: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.lock_statement_line');
229: SELECT statement_line_id,
230: trx_date,
231: trx_type,
232: trx_code_id,

Line 261: cep_standard.debug('<

257: FROM ce_statement_lines
258: WHERE rowid = CE_ZBA_DEAL_GENERATION.csl_rowid
259: FOR UPDATE OF status NOWAIT;
260:
261: cep_standard.debug('< 262: RETURN(TRUE);
263:
264: EXCEPTION
265: WHEN APP_EXCEPTIONS.record_lock_exception THEN

Line 268: cep_standard.debug('EXCEPTION: CE_ZBA_DEAL_GENERATION.lock_statement_line' );

264: EXCEPTION
265: WHEN APP_EXCEPTIONS.record_lock_exception THEN
266: return(FALSE);
267: WHEN OTHERS THEN
268: cep_standard.debug('EXCEPTION: CE_ZBA_DEAL_GENERATION.lock_statement_line' );
269: RAISE;
270: return(FALSE);
271: END lock_statement_line;
272:

Line 289: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.get_min_statement_line_id');

285: FUNCTION get_min_statement_line_id RETURN NUMBER IS
286: min_statement_line NUMBER;
287: min_statement_line_num NUMBER;
288: BEGIN
289: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.get_min_statement_line_id');
290: SELECT min(line_number)
291: INTO min_statement_line_num
292: FROM ce_statement_lines
293: WHERE statement_header_id = CE_ZBA_DEAL_GENERATION.csh_statement_header_id;

Line 300: cep_standard.debug('<

296: INTO min_statement_line
297: FROM ce_statement_lines
298: WHERE line_number = min_statement_line_num
299: AND statement_header_id = CE_ZBA_DEAL_GENERATION.csh_statement_header_id;
300: cep_standard.debug('< 301:
302: RETURN (min_statement_line);
303: EXCEPTION
304: WHEN OTHERS THEN

Line 305: cep_standard.debug('EXCEPTION: CE_ZBA_DEAL_GENERATION.get_min_statement_line_id');

301:
302: RETURN (min_statement_line);
303: EXCEPTION
304: WHEN OTHERS THEN
305: cep_standard.debug('EXCEPTION: CE_ZBA_DEAL_GENERATION.get_min_statement_line_id');
306: RAISE;
307: END get_min_statement_line_id;
308:
309: /* ---------------------------------------------------------------------

Line 343: cep_standard.debug('<

339: CE_ZBA_DEAL_GENERATION.G_debug_file := p_debug_file;
340:
341:
342: IF l_DEBUG in ('Y', 'C') THEN
343: cep_standard.debug('< 344: END IF;
345: END set_parameters;
346:
347: /* ---------------------------------------------------------------------

Line 398: cep_standard.debug('line_row_count = '||line_row_count);

394: FROM ce_statement_lines
395: WHERE statement_header_id = p_statement_header_id
396: AND trx_type in ('SWEEP_IN', 'SWEEP_OUT');
397:
398: cep_standard.debug('line_row_count = '||line_row_count);
399:
400: IF (line_row_count > 0) THEN
401: G_sweep_flag := TRUE;
402: RETURN (FALSE);

Line 484: cep_standard.enable_debug(p_debug_path, p_debug_file);

480: l_cashflows_created_flag VARCHAR2(1);
481: BEGIN
482:
483: IF l_DEBUG in ('Y', 'C') THEN
484: cep_standard.enable_debug(p_debug_path, p_debug_file);
485:
486: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.zba_generation '||sysdate);
487: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_bank_branch_id : '|| p_bank_branch_id);
488: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_bank_account_id : '|| p_bank_account_id);

Line 486: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.zba_generation '||sysdate);

482:
483: IF l_DEBUG in ('Y', 'C') THEN
484: cep_standard.enable_debug(p_debug_path, p_debug_file);
485:
486: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.zba_generation '||sysdate);
487: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_bank_branch_id : '|| p_bank_branch_id);
488: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_bank_account_id : '|| p_bank_account_id);
489: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_statement_number_from: '|| p_statement_number_from);
490: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_statement_number_to: '|| p_statement_number_to);

Line 487: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_bank_branch_id : '|| p_bank_branch_id);

483: IF l_DEBUG in ('Y', 'C') THEN
484: cep_standard.enable_debug(p_debug_path, p_debug_file);
485:
486: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.zba_generation '||sysdate);
487: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_bank_branch_id : '|| p_bank_branch_id);
488: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_bank_account_id : '|| p_bank_account_id);
489: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_statement_number_from: '|| p_statement_number_from);
490: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_statement_number_to: '|| p_statement_number_to);
491: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_statement_date_from: '|| p_statement_date_from);

Line 488: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_bank_account_id : '|| p_bank_account_id);

484: cep_standard.enable_debug(p_debug_path, p_debug_file);
485:
486: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.zba_generation '||sysdate);
487: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_bank_branch_id : '|| p_bank_branch_id);
488: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_bank_account_id : '|| p_bank_account_id);
489: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_statement_number_from: '|| p_statement_number_from);
490: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_statement_number_to: '|| p_statement_number_to);
491: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_statement_date_from: '|| p_statement_date_from);
492: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_statement_date_to: '|| p_statement_date_to);

Line 489: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_statement_number_from: '|| p_statement_number_from);

485:
486: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.zba_generation '||sysdate);
487: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_bank_branch_id : '|| p_bank_branch_id);
488: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_bank_account_id : '|| p_bank_account_id);
489: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_statement_number_from: '|| p_statement_number_from);
490: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_statement_number_to: '|| p_statement_number_to);
491: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_statement_date_from: '|| p_statement_date_from);
492: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_statement_date_to: '|| p_statement_date_to);
493: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_display_debug: '|| p_display_debug);

Line 490: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_statement_number_to: '|| p_statement_number_to);

486: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.zba_generation '||sysdate);
487: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_bank_branch_id : '|| p_bank_branch_id);
488: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_bank_account_id : '|| p_bank_account_id);
489: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_statement_number_from: '|| p_statement_number_from);
490: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_statement_number_to: '|| p_statement_number_to);
491: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_statement_date_from: '|| p_statement_date_from);
492: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_statement_date_to: '|| p_statement_date_to);
493: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_display_debug: '|| p_display_debug);
494: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_debug_path: '|| p_debug_path);

Line 491: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_statement_date_from: '|| p_statement_date_from);

487: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_bank_branch_id : '|| p_bank_branch_id);
488: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_bank_account_id : '|| p_bank_account_id);
489: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_statement_number_from: '|| p_statement_number_from);
490: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_statement_number_to: '|| p_statement_number_to);
491: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_statement_date_from: '|| p_statement_date_from);
492: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_statement_date_to: '|| p_statement_date_to);
493: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_display_debug: '|| p_display_debug);
494: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_debug_path: '|| p_debug_path);
495: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_debug_file: '|| p_debug_file);

Line 492: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_statement_date_to: '|| p_statement_date_to);

488: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_bank_account_id : '|| p_bank_account_id);
489: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_statement_number_from: '|| p_statement_number_from);
490: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_statement_number_to: '|| p_statement_number_to);
491: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_statement_date_from: '|| p_statement_date_from);
492: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_statement_date_to: '|| p_statement_date_to);
493: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_display_debug: '|| p_display_debug);
494: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_debug_path: '|| p_debug_path);
495: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_debug_file: '|| p_debug_file);
496:

Line 493: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_display_debug: '|| p_display_debug);

489: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_statement_number_from: '|| p_statement_number_from);
490: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_statement_number_to: '|| p_statement_number_to);
491: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_statement_date_from: '|| p_statement_date_from);
492: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_statement_date_to: '|| p_statement_date_to);
493: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_display_debug: '|| p_display_debug);
494: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_debug_path: '|| p_debug_path);
495: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_debug_file: '|| p_debug_file);
496:
497:

Line 494: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_debug_path: '|| p_debug_path);

490: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_statement_number_to: '|| p_statement_number_to);
491: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_statement_date_from: '|| p_statement_date_from);
492: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_statement_date_to: '|| p_statement_date_to);
493: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_display_debug: '|| p_display_debug);
494: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_debug_path: '|| p_debug_path);
495: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_debug_file: '|| p_debug_file);
496:
497:
498: END IF;

Line 495: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_debug_file: '|| p_debug_file);

491: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_statement_date_from: '|| p_statement_date_from);
492: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_statement_date_to: '|| p_statement_date_to);
493: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_display_debug: '|| p_display_debug);
494: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_debug_path: '|| p_debug_path);
495: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_debug_file: '|| p_debug_file);
496:
497:
498: END IF;
499: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.zba_generation');

Line 499: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.zba_generation');

495: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_debug_file: '|| p_debug_file);
496:
497:
498: END IF;
499: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.zba_generation');
500:
501: -- populate ce_security_profiles_gt table with ce_security_procfiles_v
502: CEP_STANDARD.init_security;
503:

Line 502: CEP_STANDARD.init_security;

498: END IF;
499: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.zba_generation');
500:
501: -- populate ce_security_profiles_gt table with ce_security_procfiles_v
502: CEP_STANDARD.init_security;
503:
504: set_parameters(p_bank_branch_id,
505: p_bank_account_id,
506: p_statement_number_from,

Line 514: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.Opening r_branch_cursor');

510: p_display_debug,
511: p_debug_path,
512: p_debug_file);
513:
514: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.Opening r_branch_cursor');
515: OPEN r_branch_cursor( CE_ZBA_DEAL_GENERATION.G_bank_branch_id,
516: CE_ZBA_DEAL_GENERATION.G_bank_account_id);
517: j := 0;
518: LOOP

Line 519: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.Fetching r_branch_cursor');

515: OPEN r_branch_cursor( CE_ZBA_DEAL_GENERATION.G_bank_branch_id,
516: CE_ZBA_DEAL_GENERATION.G_bank_account_id);
517: j := 0;
518: LOOP
519: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.Fetching r_branch_cursor');
520: FETCH r_branch_cursor INTO CE_ZBA_DEAL_GENERATION.csh_bank_account_id;
521:
522: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.csh_bank_account_id = '||CE_ZBA_DEAL_GENERATION.csh_bank_account_id);
523:

Line 522: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.csh_bank_account_id = '||CE_ZBA_DEAL_GENERATION.csh_bank_account_id);

518: LOOP
519: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.Fetching r_branch_cursor');
520: FETCH r_branch_cursor INTO CE_ZBA_DEAL_GENERATION.csh_bank_account_id;
521:
522: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.csh_bank_account_id = '||CE_ZBA_DEAL_GENERATION.csh_bank_account_id);
523:
524: IF (r_branch_cursor%ROWCOUNT = j) THEN
525: EXIT;
526: ELSE

Line 530: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.Opening r_bank_cursor');

526: ELSE
527: j := r_branch_cursor%ROWCOUNT;
528: END IF;
529:
530: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.Opening r_bank_cursor');
531: OPEN r_bank_cursor (CE_ZBA_DEAL_GENERATION.G_statement_number_from,
532: CE_ZBA_DEAL_GENERATION.G_statement_number_to,
533: CE_ZBA_DEAL_GENERATION.G_statement_date_from,
534: CE_ZBA_DEAL_GENERATION.G_statement_date_to,

Line 538: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.Fetching r_bank_cursor');

534: CE_ZBA_DEAL_GENERATION.G_statement_date_to,
535: CE_ZBA_DEAL_GENERATION.csh_bank_account_id);
536: i := 0;
537: LOOP
538: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.Fetching r_bank_cursor');
539: FETCH r_bank_cursor INTO CE_ZBA_DEAL_GENERATION.csh_statement_header_id,
540: CE_ZBA_DEAL_GENERATION.csh_statement_number,
541: CE_ZBA_DEAL_GENERATION.csh_statement_date,
542: CE_ZBA_DEAL_GENERATION.csh_check_digits,

Line 550: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.After fetch header');

546: CE_ZBA_DEAL_GENERATION.cba_check_digits,
547: CE_ZBA_DEAL_GENERATION.csh_rowid,
548: CE_ZBA_DEAL_GENERATION.csh_statement_complete_flag,
549: CE_ZBA_DEAL_GENERATION.csh_org_id;
550: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.After fetch header');
551: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.statement_header_id:' ||
552: CE_ZBA_DEAL_GENERATION.csh_statement_header_id );
553:
554: if (r_bank_cursor%ROWCOUNT = i) then

Line 551: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.statement_header_id:' ||

547: CE_ZBA_DEAL_GENERATION.csh_rowid,
548: CE_ZBA_DEAL_GENERATION.csh_statement_complete_flag,
549: CE_ZBA_DEAL_GENERATION.csh_org_id;
550: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.After fetch header');
551: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.statement_header_id:' ||
552: CE_ZBA_DEAL_GENERATION.csh_statement_header_id );
553:
554: if (r_bank_cursor%ROWCOUNT = i) then
555: EXIT;

Line 573: cep_standard.debug('row_count = '||row_count);

569: from ce_statement_lines
570: where statement_header_id = CE_ZBA_DEAL_GENERATION.csh_statement_header_id
571: and trx_type in ('SWEEP_IN', 'SWEEP_OUT');
572:
573: cep_standard.debug('row_count = '||row_count);
574:
575: if (row_count = 0 ) then
576: CE_ZBA_DEAL_INF_PKG.insert_row(
577: CE_ZBA_DEAL_GENERATION.csh_statement_header_id,

Line 580: cep_standard.debug('>>validate existing of unreconciled sweep lines');

576: CE_ZBA_DEAL_INF_PKG.insert_row(
577: CE_ZBA_DEAL_GENERATION.csh_statement_header_id,
578: to_number(NULL), 'CE_NO_SWEEP_STMT_LINE');
579: EXIT;
580: cep_standard.debug('>>validate existing of unreconciled sweep lines');
581: else --Validate the bank account is an authorized treasury account
582: if fnd_profile.value('CE_BANK_ACCOUNT_TRANSFERS') = 'XTR' then
583: select count(1) into l_count
584: from ce_bank_accounts ba, ce_bank_acct_uses_all bau

Line 599: cep_standard.debug('>>validate shared bank account is setup correctly');

595: end if;
596: end if;
597: end if;
598:
599: cep_standard.debug('>>validate shared bank account is setup correctly');
600:
601: IF (nvl(LTRIM(nvl(CE_ZBA_DEAL_GENERATION.csh_check_digits, 'NO DIGIT'),
602: '0'), '0') = nvl(LTRIM(nvl(CE_ZBA_DEAL_GENERATION.cba_check_digits,
603: 'NO DIGIT'), '0'), '0')) THEN

Line 605: cep_standard.debug('csh_check_digits = '||csh_check_digits);

601: IF (nvl(LTRIM(nvl(CE_ZBA_DEAL_GENERATION.csh_check_digits, 'NO DIGIT'),
602: '0'), '0') = nvl(LTRIM(nvl(CE_ZBA_DEAL_GENERATION.cba_check_digits,
603: 'NO DIGIT'), '0'), '0')) THEN
604:
605: cep_standard.debug('csh_check_digits = '||csh_check_digits);
606: cep_standard.debug('cba_check_digits = '||cba_check_digits);
607:
608: --
609: -- Lock the statement

Line 606: cep_standard.debug('cba_check_digits = '||cba_check_digits);

602: '0'), '0') = nvl(LTRIM(nvl(CE_ZBA_DEAL_GENERATION.cba_check_digits,
603: 'NO DIGIT'), '0'), '0')) THEN
604:
605: cep_standard.debug('csh_check_digits = '||csh_check_digits);
606: cep_standard.debug('cba_check_digits = '||cba_check_digits);
607:
608: --
609: -- Lock the statement
610: --

Line 620: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.Opening line_cursor');

616: --
617: -- Read in all the lines on the statement for the selected bank
618: -- account.
619: --
620: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.Opening line_cursor');
621: OPEN line_cursor (CE_ZBA_DEAL_GENERATION.csh_statement_header_id);
622: LOOP
623: FETCH line_cursor INTO CE_ZBA_DEAL_GENERATION.csl_rowid,
624: CE_ZBA_DEAL_GENERATION.csl_statement_line_id,

Line 643: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.csl_statement_line_id = '|| CE_ZBA_DEAL_GENERATION.csl_statement_line_id);

639: CE_ZBA_DEAL_GENERATION.csl_clearing_trx_type,
640: CE_ZBA_DEAL_GENERATION.csl_original_amount,
641: CE_ZBA_DEAL_GENERATION.csl_payroll_payment_format;
642: EXIT WHEN line_cursor%NOTFOUND OR line_cursor%NOTFOUND IS NULL;
643: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.csl_statement_line_id = '|| CE_ZBA_DEAL_GENERATION.csl_statement_line_id);
644:
645:
646: select count(*)
647: into rec_status

Line 673: cep_standard.debug('csl_amount = '||csl_amount);

669: CE_ZBA_DEAL_INF_PKG.insert_row (
670: CE_ZBA_DEAL_GENERATION.csh_statement_header_id,
671: CE_ZBA_DEAL_GENERATION.csl_statement_line_id, 'CE_ZBA_ZERO_AMOUNT');
672: END IF;
673: cep_standard.debug('csl_amount = '||csl_amount);
674:
675: --Validate different currencies between statement header and line
676: IF (CE_ZBA_DEAL_GENERATION.cba_bank_currency <>
677: nvl(CE_ZBA_DEAL_GENERATION.csl_currency_code, CE_ZBA_DEAL_GENERATION.cba_bank_currency)) THEN

Line 682: cep_standard.debug('csl_currency_code = '||csl_currency_code);

678: CE_ZBA_DEAL_INF_PKG.insert_row (
679: CE_ZBA_DEAL_GENERATION.csh_statement_header_id,
680: CE_ZBA_DEAL_GENERATION.csl_statement_line_id, 'CE_ZBA_DIFF_CURRENCY');
681: END IF;
682: cep_standard.debug('csl_currency_code = '||csl_currency_code);
683: cep_standard.debug('cba_bank_currency = '||cba_bank_currency);
684:
685: --
686: -- Deal Generation

Line 683: cep_standard.debug('cba_bank_currency = '||cba_bank_currency);

679: CE_ZBA_DEAL_GENERATION.csh_statement_header_id,
680: CE_ZBA_DEAL_GENERATION.csl_statement_line_id, 'CE_ZBA_DIFF_CURRENCY');
681: END IF;
682: cep_standard.debug('csl_currency_code = '||csl_currency_code);
683: cep_standard.debug('cba_bank_currency = '||cba_bank_currency);
684:
685: --
686: -- Deal Generation
687: --

Line 853: cep_standard.debug('zba_generation: ' || 'Message: get print options success');

849: print_style,
850: printer,
851: save_output_flag))THEN
852: IF l_DEBUG in ('Y', 'C') THEN
853: cep_standard.debug('zba_generation: ' || 'Message: get print options success');
854: END IF;
855: ELSE
856: IF (save_output_flag = 'Y') THEN
857: save_output_bool := TRUE;

Line 868: cep_standard.debug('zba_generation: ' || 'Message: get print options failed');

864: printer,
865: print_style,
866: save_output_flag)) THEN
867: IF l_DEBUG in ('Y', 'C') THEN
868: cep_standard.debug('zba_generation: ' || 'Message: get print options failed');
869: END IF;
870: END IF;
871:
872: END IF;

Line 881: cep_standard.debug('zba_generation: ' || 'Set print options failed');

877: print_style,
878: number_of_copies,
879: save_output_bool)) THEN
880: IF l_DEBUG in ('Y', 'C') THEN
881: cep_standard.debug('zba_generation: ' || 'Set print options failed');
882: END IF;
883: END IF;
884: req_id := FND_REQUEST.SUBMIT_REQUEST('CE',
885: 'CEZBAERR',

Line 900: cep_standard.debug('zba_generation: ' || 'ERROR submitting concurrent request');

896: p_display_debug);
897: COMMIT;
898: IF (req_id = 0) THEN
899: IF l_DEBUG in ('Y', 'C') THEN
900: cep_standard.debug('zba_generation: ' || 'ERROR submitting concurrent request');
901: END IF;
902: ELSE
903: IF l_DEBUG in ('Y', 'C') THEN
904: cep_standard.debug('zba_generation: ' || 'EXECUTION REPORT SUBMITTED');

Line 904: cep_standard.debug('zba_generation: ' || 'EXECUTION REPORT SUBMITTED');

900: cep_standard.debug('zba_generation: ' || 'ERROR submitting concurrent request');
901: END IF;
902: ELSE
903: IF l_DEBUG in ('Y', 'C') THEN
904: cep_standard.debug('zba_generation: ' || 'EXECUTION REPORT SUBMITTED');
905: END IF;
906: END IF;
907:
908: cep_standard.debug('<

Line 908: cep_standard.debug('<

904: cep_standard.debug('zba_generation: ' || 'EXECUTION REPORT SUBMITTED');
905: END IF;
906: END IF;
907:
908: cep_standard.debug('< 909: cep_standard.disable_debug(p_display_debug);
910:
911: EXCEPTION
912: WHEN OTHERS THEN

Line 909: cep_standard.disable_debug(p_display_debug);

905: END IF;
906: END IF;
907:
908: cep_standard.debug('< 909: cep_standard.disable_debug(p_display_debug);
910:
911: EXCEPTION
912: WHEN OTHERS THEN
913: cep_standard.debug(' EXCEPTION: CE_ZBA_DEAL_GENERATION.zba_generation - OTHERS');

Line 913: cep_standard.debug(' EXCEPTION: CE_ZBA_DEAL_GENERATION.zba_generation - OTHERS');

909: cep_standard.disable_debug(p_display_debug);
910:
911: EXCEPTION
912: WHEN OTHERS THEN
913: cep_standard.debug(' EXCEPTION: CE_ZBA_DEAL_GENERATION.zba_generation - OTHERS');
914: IF r_branch_cursor%ISOPEN THEN
915: CLOSE r_branch_cursor;
916: END IF;
917: IF r_bank_cursor%ISOPEN THEN

Line 924: cep_standard.debug('DEBUG: sqlcode:' || sqlcode );

920: IF line_cursor%ISOPEN THEN
921: CLOSE line_cursor;
922: END IF;
923: lock_status := dbms_lock.release(lockhandle);
924: cep_standard.debug('DEBUG: sqlcode:' || sqlcode );
925: cep_standard.debug('DEBUG: sqlerrm:' || sqlerrm);
926: RAISE;
927: END zba_generation;
928:

Line 925: cep_standard.debug('DEBUG: sqlerrm:' || sqlerrm);

921: CLOSE line_cursor;
922: END IF;
923: lock_status := dbms_lock.release(lockhandle);
924: cep_standard.debug('DEBUG: sqlcode:' || sqlcode );
925: cep_standard.debug('DEBUG: sqlerrm:' || sqlerrm);
926: RAISE;
927: END zba_generation;
928:
929: END CE_ZBA_DEAL_GENERATION;