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.JA_CN_COA_EXPORT_PKG dependencies on JA_CN_COA_NA_EXCEPTIONS

Line 471: -- table JA_CN_COA_NA_EXCEPTIONS

467: IF l_length <> l_expected_length
468: THEN
469: --Insert a row of account number, level, length, expected length,
470: -- account structure, and current request id into invalid account
471: -- table JA_CN_COA_NA_EXCEPTIONS
472: INSERT INTO JA_CN_COA_NA_EXCEPTIONS
473: ( ACCOUNT_SEGMENT
474: ,ACCOUNT_LEVEL
475: ,VALUE_LENGTH

Line 472: INSERT INTO JA_CN_COA_NA_EXCEPTIONS

468: THEN
469: --Insert a row of account number, level, length, expected length,
470: -- account structure, and current request id into invalid account
471: -- table JA_CN_COA_NA_EXCEPTIONS
472: INSERT INTO JA_CN_COA_NA_EXCEPTIONS
473: ( ACCOUNT_SEGMENT
474: ,ACCOUNT_LEVEL
475: ,VALUE_LENGTH
476: ,EXPECTED_LENGTH

Line 502: -- 3. Checks if the invalid account table JA_CN_COA_NA_EXCEPTIONS has any row.

498: END IF; --Account Level should not null and be a natural number and <16
499: END LOOP;
500: CLOSE c_na_info;
501:
502: -- 3. Checks if the invalid account table JA_CN_COA_NA_EXCEPTIONS has any row.
503: -- If YES then records error in output and submits a request to generate
504: -- exception report;
505: -- ELSE goes on to collect all natural accounts.
506: SELECT count(*)

Line 508: FROM JA_CN_COA_NA_EXCEPTIONS

504: -- exception report;
505: -- ELSE goes on to collect all natural accounts.
506: SELECT count(*)
507: INTO l_exceptions_count
508: FROM JA_CN_COA_NA_EXCEPTIONS
509: WHERE NA_REQUEST_ID = l_na_curr_req_id
510: ;
511:
512: IF l_exceptions_count > 0 --JA_CN_COA_NA_EXCEPTIONS has row

Line 512: IF l_exceptions_count > 0 --JA_CN_COA_NA_EXCEPTIONS has row

508: FROM JA_CN_COA_NA_EXCEPTIONS
509: WHERE NA_REQUEST_ID = l_na_curr_req_id
510: ;
511:
512: IF l_exceptions_count > 0 --JA_CN_COA_NA_EXCEPTIONS has row
513: THEN
514: l_xml_layout := FND_REQUEST.ADD_LAYOUT( template_appl_name => 'JA'
515: ,template_code => 'JACNNAER'
516: ,template_language => l_template_language --'zh' ('en')

Line 547: FROM JA_CN_COA_NA_EXCEPTIONS

543: END IF; -- FND_CONCURRENT.Wait_For_Request ...
544: END IF; --l_na_req_id<>0
545:
546: DELETE
547: FROM JA_CN_COA_NA_EXCEPTIONS
548: WHERE NA_REQUEST_ID = l_na_curr_req_id;
549: COMMIT;
550:
551: --Report that there have invalid accounts