APPS.JA_CN_AB_EXP_PKG dependencies on JA_CN_ERROR_ACCOUNTS

Line 692: INSERT INTO JA_CN_ERROR_ACCOUNTS

688: AND FUNC_END_BALANCE <> 0;
689: --fnd_file.PUT_LINE(fnd_file.LOG,l_number_a);
690: IF l_number_a >= 1 THEN
691: --error balance
692: INSERT INTO JA_CN_ERROR_ACCOUNTS
693: (request_id
694: ,ACCOUNT_SEGMENT
695: ,CURRENCY_CODE
696: ,FUNC_BEGIN_BALANCE

Line 780: INSERT INTO JA_CN_ERROR_ACCOUNTS

776: --fnd_file.PUT_LINE(fnd_file.LOG,'is f: '||l_account_balances_gbl_tmp_row.is_foreign||' f c code: '||l_functional_currency_code);
777: IF l_ja_cn_subsidiary_gbl_tmp_row.is_foreign IS NOT NULL AND
778: l_ja_cn_subsidiary_gbl_tmp_row.is_foreign <>
779: l_functional_currency_code THEN
780: INSERT INTO JA_CN_ERROR_ACCOUNTS
781: (request_id
782: ,ACCOUNT_SEGMENT
783: ,CURRENCY_CODE
784: ,FUNC_BEGIN_BALANCE

Line 850: FROM JA_CN_ERROR_ACCOUNTS

846:
847: --output error accounts if any
848: SELECT COUNT(*)
849: INTO l_number_b
850: FROM JA_CN_ERROR_ACCOUNTS
851: WHERE request_id = l_na_curr_req_id;
852: IF l_number_b > 0 THEN
853: l_xml_layout := FND_REQUEST.ADD_LAYOUT(template_appl_name => 'JA',
854: template_code => 'JACNABER',

Line 883: --DELETE rows with l_na_curr_req_id in TABLE JA_CN_ERROR_ACCOUNTS;

879: NULL;
880: END IF; --l_na_req_phase = 'Completed'
881: END IF; -- FND_CONCURRENT.Wait_For_Request ...
882: END IF; --l_na_req_id<>0
883: --DELETE rows with l_na_curr_req_id in TABLE JA_CN_ERROR_ACCOUNTS;
884: DELETE FROM JA_CN_ERROR_ACCOUNTS WHERE REQUEST_ID = l_na_curr_req_id;
885: retcode := 1;
886: errbuf := FND_MESSAGE.get;
887: RETURN;

Line 884: DELETE FROM JA_CN_ERROR_ACCOUNTS WHERE REQUEST_ID = l_na_curr_req_id;

880: END IF; --l_na_req_phase = 'Completed'
881: END IF; -- FND_CONCURRENT.Wait_For_Request ...
882: END IF; --l_na_req_id<>0
883: --DELETE rows with l_na_curr_req_id in TABLE JA_CN_ERROR_ACCOUNTS;
884: DELETE FROM JA_CN_ERROR_ACCOUNTS WHERE REQUEST_ID = l_na_curr_req_id;
885: retcode := 1;
886: errbuf := FND_MESSAGE.get;
887: RETURN;
888: END IF;