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 562: CE_ZBA_DEAL_INF_PKG.delete_row(

558: end if;
559: -- EXIT WHEN r_bank_cursor%NOTFOUND OR r_bank_cursor%NOTFOUND IS NULL;
560:
561: -- Clean up error table
562: CE_ZBA_DEAL_INF_PKG.delete_row(
563: CE_ZBA_DEAL_GENERATION.csh_statement_header_id,
564: to_number(NULL));
565:
566: --Validate existing of unreconciled sweep lines

Line 576: CE_ZBA_DEAL_INF_PKG.insert_row(

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,
578: to_number(NULL), 'CE_NO_SWEEP_STMT_LINE');
579: EXIT;
580: cep_standard.debug('>>validate existing of unreconciled sweep lines');

Line 591: CE_ZBA_DEAL_INF_PKG.insert_row (

587: and ba.xtr_use_allowed_flag = 'Y'
588: and bau.authorized_flag = 'Y';
589:
590: if l_count = 0 then
591: CE_ZBA_DEAL_INF_PKG.insert_row (
592: CE_ZBA_DEAL_GENERATION.csh_statement_header_id,
593: to_number(NULL), 'CE_XTR_INVALID_ACCT');
594: EXIT;
595: end if;

Line 662: CE_ZBA_DEAL_INF_PKG.delete_row(

658: statement_line_count := statement_line_count + 1;
659: --
660: -- Clear ce_zba_deal_inf table
661: --
662: CE_ZBA_DEAL_INF_PKG.delete_row(
663: CE_ZBA_DEAL_GENERATION.csh_statement_header_id,
664: CE_ZBA_DEAL_GENERATION.csl_statement_line_id);
665: IF (lock_statement_line) THEN
666:

Line 669: CE_ZBA_DEAL_INF_PKG.insert_row (

665: IF (lock_statement_line) THEN
666:
667: --Validate zero amount line
668: IF (CE_ZBA_DEAL_GENERATION.csl_amount = 0)THEN
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);

Line 678: CE_ZBA_DEAL_INF_PKG.insert_row (

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

Line 785: CE_ZBA_DEAL_INF_PKG.insert_row(

781: FND_MSG_PUB.delete_msg(1);
782: END LOOP;
783: END IF;
784: ELSE
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_NO_CASHPOOL_MATCH');
789: END IF;

Line 791: CE_ZBA_DEAL_INF_PKG.insert_row(

787: CE_ZBA_DEAL_GENERATION.csl_statement_line_id,
788: 'CE_NO_CASHPOOL_MATCH');
789: END IF;
790: ELSE -- statement line is locked
791: CE_ZBA_DEAL_INF_PKG.insert_row(
792: CE_ZBA_DEAL_GENERATION.csh_statement_header_id,
793: CE_ZBA_DEAL_GENERATION.csl_statement_line_id,
794: 'CE_LINE_LOCKED');
795: END IF;

Line 809: CE_ZBA_DEAL_INF_PKG.delete_row(

805: CLOSE line_cursor;
806:
807: ELSE
808: error_statement_line_id := get_min_statement_line_id;
809: CE_ZBA_DEAL_INF_PKG.delete_row(
810: CE_ZBA_DEAL_GENERATION.csh_statement_header_id,
811: error_statement_line_id);
812: CE_ZBA_DEAL_INF_PKG.insert_row(
813: CE_ZBA_DEAL_GENERATION.csh_statement_header_id,

Line 812: CE_ZBA_DEAL_INF_PKG.insert_row(

808: error_statement_line_id := get_min_statement_line_id;
809: CE_ZBA_DEAL_INF_PKG.delete_row(
810: CE_ZBA_DEAL_GENERATION.csh_statement_header_id,
811: error_statement_line_id);
812: CE_ZBA_DEAL_INF_PKG.insert_row(
813: CE_ZBA_DEAL_GENERATION.csh_statement_header_id,
814: error_statement_line_id, 'CE_STATEMENT_COMPLETED');
815: END IF; -- statement completed
816:

Line 818: CE_ZBA_DEAL_INF_PKG.delete_row(

814: error_statement_line_id, 'CE_STATEMENT_COMPLETED');
815: END IF; -- statement completed
816:
817: ELSE -- statement is locked
818: CE_ZBA_DEAL_INF_PKG.delete_row(
819: CE_ZBA_DEAL_GENERATION.csh_statement_header_id, to_number(NULL));
820: CE_ZBA_DEAL_INF_PKG.insert_row(
821: CE_ZBA_DEAL_GENERATION.csh_statement_header_id,to_number(NULL),
822: 'CE_LOCK_STATEMENT_HEADER_ERR');

Line 820: CE_ZBA_DEAL_INF_PKG.insert_row(

816:
817: ELSE -- statement is locked
818: CE_ZBA_DEAL_INF_PKG.delete_row(
819: CE_ZBA_DEAL_GENERATION.csh_statement_header_id, to_number(NULL));
820: CE_ZBA_DEAL_INF_PKG.insert_row(
821: CE_ZBA_DEAL_GENERATION.csh_statement_header_id,to_number(NULL),
822: 'CE_LOCK_STATEMENT_HEADER_ERR');
823: END IF;
824: lock_status := dbms_lock.release(lockhandle);

Line 827: CE_ZBA_DEAL_INF_PKG.delete_row(

823: END IF;
824: lock_status := dbms_lock.release(lockhandle);
825:
826: ELSE -- check digits failed
827: CE_ZBA_DEAL_INF_PKG.delete_row(
828: CE_ZBA_DEAL_GENERATION.csh_statement_header_id, to_number(NULL));
829: CE_ZBA_DEAL_INF_PKG.insert_row(
830: CE_ZBA_DEAL_GENERATION.csh_statement_header_id,to_number(NULL),
831: 'CE_CHECK_DIGITS');

Line 829: CE_ZBA_DEAL_INF_PKG.insert_row(

825:
826: ELSE -- check digits failed
827: CE_ZBA_DEAL_INF_PKG.delete_row(
828: CE_ZBA_DEAL_GENERATION.csh_statement_header_id, to_number(NULL));
829: CE_ZBA_DEAL_INF_PKG.insert_row(
830: CE_ZBA_DEAL_GENERATION.csh_statement_header_id,to_number(NULL),
831: 'CE_CHECK_DIGITS');
832: END IF; -- check_digits
833: