[Home] [Help]
2519:
2520: -- Start of comments
2521: --API name : populate_import_errors
2522: --Type : Private.
2523: --Function : Populate the okc_rep_imp_errors_t table with error messages
2524: --Pre-reqs : None
2525: --Parameters :
2526: --IN : p_api_version IN NUMBER Required
2527: -- : p_init_msg_list IN VARCHAR2 Optional
2566:
2567: l_imp_error_id NUMBER;
2568:
2569: CURSOR ERROR_ID_CSR IS
2570: SELECT OKC_REP_IMP_ERRORS_T_S.NEXTVAL
2571: FROM DUAL;
2572:
2573: BEGIN
2574:
2620: fnd_log.string(FND_LOG.LEVEL_EXCEPTION, g_module || l_api_name,
2621: 'l_imp_error_id: '||l_imp_error_id);
2622: END IF;
2623:
2624: INSERT INTO OKC_REP_IMP_ERRORS_T(
2625: IMP_ERROR_ID,
2626: IMP_CONTRACT_ID,
2627: ERROR_OBJECT_TYPE,
2628: ERROR_OBJECT_ID,
5504: --Type : Private.
5505: --Function : (1) Delete the imported contract and its parties
5506: -- by calling okc_rep_contract_process_pvt.delete_contract
5507: -- (2) Set the contract's valid_flag to 'N' in okc_rep_imp_contracts_t
5508: -- (3) Insert an error message in okc_rep_imp_errors_t
5509: -- This procedure does the cleanup due to an error adding attachments
5510: -- in the Java layer during repository import
5511: --Pre-reqs : None
5512: --Parameters :
5633: x_msg_data => x_msg_data);
5634:
5635: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5636: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT,G_MODULE||l_api_name,
5637: 'Inserted error into okc_rep_imp_errors_t');
5638: END IF;
5639:
5640:
5641: IF(p_commit = FND_API.G_TRUE) THEN
5859:
5860: CURSOR IMP_ERRORS_CSR IS
5861: SELECT
5862: ERROR_MESSAGE
5863: FROM OKC_REP_IMP_ERRORS_T
5864: WHERE IMP_CONTRACT_ID = p_imp_contract_id;
5865:
5866: l_imp_errors_rec IMP_ERRORS_CSR%ROWTYPE;
5867: