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 CE_ZBA_DEAL_INF_PKG

Line 553: CE_ZBA_DEAL_INF_PKG.delete_row(

549: END IF;
550: cep_standard.debug('Itertion Number = ' || i);
551:
552: -- Clean up error table
553: CE_ZBA_DEAL_INF_PKG.delete_row(
554: CE_ZBA_DEAL_GENERATION.csh_statement_header_id,
555: to_number(NULL));
556:
557: -- Validate existing of unreconciled sweep lines

Line 568: CE_ZBA_DEAL_INF_PKG.insert_row(

564: cep_standard.debug('sweep row_count = '||row_count);
565:
566: IF (row_count = 0)
567: THEN
568: CE_ZBA_DEAL_INF_PKG.insert_row(
569: CE_ZBA_DEAL_GENERATION.csh_statement_header_id,
570: to_number(NULL),
571: 'CE_NO_SWEEP_STMT_LINE');
572: -- Bug 11686554 CONTINUE is not supported in oracle 10g

Line 589: CE_ZBA_DEAL_INF_PKG.insert_row (

585:
586: cep_standard.debug('authorised l_count = '||row_count);
587: IF l_count = 0
588: THEN
589: CE_ZBA_DEAL_INF_PKG.insert_row (
590: CE_ZBA_DEAL_GENERATION.csh_statement_header_id,
591: to_number(NULL),
592: 'CE_XTR_INVALID_ACCT');
593: cep_standard.debug('Exiting For Invalid Account ...');

Line 656: CE_ZBA_DEAL_INF_PKG.delete_row(

652: statement_line_count := statement_line_count + 1;
653: --
654: -- Clear ce_zba_deal_inf table
655: --
656: CE_ZBA_DEAL_INF_PKG.delete_row(
657: CE_ZBA_DEAL_GENERATION.csh_statement_header_id,
658: CE_ZBA_DEAL_GENERATION.csl_statement_line_id);
659:
660: IF (lock_statement_line)

Line 666: CE_ZBA_DEAL_INF_PKG.insert_row (

662: cep_standard.debug('csl_amount = '||csl_amount);
663: --Validate zero amount line
664: IF (CE_ZBA_DEAL_GENERATION.csl_amount = 0)
665: THEN
666: CE_ZBA_DEAL_INF_PKG.insert_row (
667: CE_ZBA_DEAL_GENERATION.csh_statement_header_id,
668: CE_ZBA_DEAL_GENERATION.csl_statement_line_id,
669: 'CE_ZBA_ZERO_AMOUNT');
670: END IF;

Line 676: CE_ZBA_DEAL_INF_PKG.insert_row (

672: --Validate different currencies between statement header and line
673: IF (CE_ZBA_DEAL_GENERATION.cba_bank_currency <>
674: nvl(CE_ZBA_DEAL_GENERATION.csl_currency_code, CE_ZBA_DEAL_GENERATION.cba_bank_currency))
675: THEN
676: CE_ZBA_DEAL_INF_PKG.insert_row (
677: CE_ZBA_DEAL_GENERATION.csh_statement_header_id,
678: CE_ZBA_DEAL_GENERATION.csl_statement_line_id,
679: 'CE_ZBA_DIFF_CURRENCY');
680: END IF;

Line 761: CE_ZBA_DEAL_INF_PKG.insert_row (

757:
758: IF (L_ACCT_TYPE = 'FUND' AND CE_ZBA_DEAL_GENERATION.csl_trx_type = 'SWEEP_IN')
759: THEN
760: cep_standard.debug('Can not sweep in for Funding concentration account..');
761: CE_ZBA_DEAL_INF_PKG.insert_row (
762: CE_ZBA_DEAL_GENERATION.csh_statement_header_id,
763: CE_ZBA_DEAL_GENERATION.csl_statement_line_id,
764: 'CE_ZBA_NO_FUND_SWEEP_IN');
765:

Line 769: CE_ZBA_DEAL_INF_PKG.insert_row (

765:
766: ELSIF (L_ACCT_TYPE = 'INV' AND CE_ZBA_DEAL_GENERATION.csl_trx_type = 'SWEEP_OUT')
767: THEN
768: cep_standard.debug('Can not sweep out for Investment concentration account..');
769: CE_ZBA_DEAL_INF_PKG.insert_row (
770: CE_ZBA_DEAL_GENERATION.csh_statement_header_id,
771: CE_ZBA_DEAL_GENERATION.csl_statement_line_id,
772: 'CE_ZBA_NO_INV_SWEEP_OUT');
773:

Line 777: CE_ZBA_DEAL_INF_PKG.insert_row (

773:
774: ELSIF (L_OFFSET_ACCT_TYPE = 'FUND' AND CE_ZBA_DEAL_GENERATION.csl_trx_type = 'SWEEP_OUT' )
775: THEN
776: cep_standard.debug('Can not sweep in for Funding concentration account..');
777: CE_ZBA_DEAL_INF_PKG.insert_row (
778: CE_ZBA_DEAL_GENERATION.csh_statement_header_id,
779: CE_ZBA_DEAL_GENERATION.csl_statement_line_id,
780: 'CE_ZBA_NO_FUND_SWEEP_IN_SUB');
781:

Line 785: CE_ZBA_DEAL_INF_PKG.insert_row (

781:
782: ELSIF (L_OFFSET_ACCT_TYPE = 'INV' AND CE_ZBA_DEAL_GENERATION.csl_trx_type = 'SWEEP_IN')
783: THEN
784: cep_standard.debug('Can not sweep out for Investment concentration account..');
785: CE_ZBA_DEAL_INF_PKG.insert_row (
786: CE_ZBA_DEAL_GENERATION.csh_statement_header_id,
787: CE_ZBA_DEAL_GENERATION.csl_statement_line_id,
788: 'CE_ZBA_NO_INV_SWEEP_OUT_SUB');
789:

Line 882: CE_ZBA_DEAL_INF_PKG.insert_row(

878: END IF;
879: END IF; -- Bug 14512483 Validation for Cashpool with 2 Concntration Accounts.
880: ELSE -- cp_match_bool = false
881: cep_standard.debug('No matching cashpool found');
882: CE_ZBA_DEAL_INF_PKG.insert_row(
883: CE_ZBA_DEAL_GENERATION.csh_statement_header_id,
884: CE_ZBA_DEAL_GENERATION.csl_statement_line_id,
885: 'CE_NO_CASHPOOL_MATCH');
886: END IF;

Line 890: CE_ZBA_DEAL_INF_PKG.insert_row(

886: END IF;
887: /* Bug # 7829965 Start */
888: ELSE -- Source and Destination Accounts are the same
889: cep_standard.debug('Source and Destination Accounts are the same');
890: CE_ZBA_DEAL_INF_PKG.insert_row(
891: CE_ZBA_DEAL_GENERATION.csh_statement_header_id,
892: CE_ZBA_DEAL_GENERATION.csl_statement_line_id,
893: 'CE_BAT_INVALID_BACCNTS');
894: END IF;

Line 898: CE_ZBA_DEAL_INF_PKG.insert_row(

894: END IF;
895: /* Bug # 7829965 End */
896: ELSE -- statement line is locked
897: cep_standard.debug('statement line is locked');
898: CE_ZBA_DEAL_INF_PKG.insert_row(
899: CE_ZBA_DEAL_GENERATION.csh_statement_header_id,
900: CE_ZBA_DEAL_GENERATION.csl_statement_line_id,
901: 'CE_LINE_LOCKED');
902: END IF;

Line 917: CE_ZBA_DEAL_INF_PKG.delete_row(

913:
914: ELSE -- statement complete flag is Y
915:
916: error_statement_line_id := get_min_statement_line_id;
917: CE_ZBA_DEAL_INF_PKG.delete_row(
918: CE_ZBA_DEAL_GENERATION.csh_statement_header_id,
919: error_statement_line_id);
920: CE_ZBA_DEAL_INF_PKG.insert_row(
921: CE_ZBA_DEAL_GENERATION.csh_statement_header_id,

Line 920: CE_ZBA_DEAL_INF_PKG.insert_row(

916: error_statement_line_id := get_min_statement_line_id;
917: CE_ZBA_DEAL_INF_PKG.delete_row(
918: CE_ZBA_DEAL_GENERATION.csh_statement_header_id,
919: error_statement_line_id);
920: CE_ZBA_DEAL_INF_PKG.insert_row(
921: CE_ZBA_DEAL_GENERATION.csh_statement_header_id,
922: error_statement_line_id,
923: 'CE_STATEMENT_COMPLETED');
924: END IF; -- statement complete flag check

Line 927: CE_ZBA_DEAL_INF_PKG.delete_row(CE_ZBA_DEAL_GENERATION.csh_statement_header_id, to_number(NULL));

923: 'CE_STATEMENT_COMPLETED');
924: END IF; -- statement complete flag check
925:
926: ELSE -- statement is locked
927: CE_ZBA_DEAL_INF_PKG.delete_row(CE_ZBA_DEAL_GENERATION.csh_statement_header_id, to_number(NULL));
928: CE_ZBA_DEAL_INF_PKG.insert_row(
929: CE_ZBA_DEAL_GENERATION.csh_statement_header_id,
930: to_number(NULL),
931: 'CE_LOCK_STATEMENT_HEADER_ERR');

Line 928: CE_ZBA_DEAL_INF_PKG.insert_row(

924: END IF; -- statement complete flag check
925:
926: ELSE -- statement is locked
927: CE_ZBA_DEAL_INF_PKG.delete_row(CE_ZBA_DEAL_GENERATION.csh_statement_header_id, to_number(NULL));
928: CE_ZBA_DEAL_INF_PKG.insert_row(
929: CE_ZBA_DEAL_GENERATION.csh_statement_header_id,
930: to_number(NULL),
931: 'CE_LOCK_STATEMENT_HEADER_ERR');
932: END IF; -- statement lock check

Line 936: CE_ZBA_DEAL_INF_PKG.delete_row(

932: END IF; -- statement lock check
933: lock_status := dbms_lock.release(lockhandle);
934: ELSE -- check digits failed
935: cep_standard.debug('Account/Statement check digit mismatch');
936: CE_ZBA_DEAL_INF_PKG.delete_row(
937: CE_ZBA_DEAL_GENERATION.csh_statement_header_id, to_number(NULL));
938: CE_ZBA_DEAL_INF_PKG.insert_row(
939: CE_ZBA_DEAL_GENERATION.csh_statement_header_id,
940: to_number(NULL),

Line 938: CE_ZBA_DEAL_INF_PKG.insert_row(

934: ELSE -- check digits failed
935: cep_standard.debug('Account/Statement check digit mismatch');
936: CE_ZBA_DEAL_INF_PKG.delete_row(
937: CE_ZBA_DEAL_GENERATION.csh_statement_header_id, to_number(NULL));
938: CE_ZBA_DEAL_INF_PKG.insert_row(
939: CE_ZBA_DEAL_GENERATION.csh_statement_header_id,
940: to_number(NULL),
941: 'CE_CHECK_DIGITS');
942: END IF; -- check_digits