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.OKS_RENCON_PVT dependencies on DBMS_TRANSACTION

Line 727: DBMS_TRANSACTION.SAVEPOINT('BEFORE_TRANSACTION');

723: ---Create one record in OKC_OPERATION_INSTANCES_V if x_sources_tbl is not empty
724: ----------------------------------------------------------------------------
725: BEGIN
726: IF x_sources_tbl.COUNT > 0 THEN
727: DBMS_TRANSACTION.SAVEPOINT('BEFORE_TRANSACTION');
728: BEGIN
729: OPEN oper_inst(p_target_id);
730: FETCH oper_inst INTO x_oie_id;
731: IF oper_inst%NOTFOUND THEN

Line 742: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');

738: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
739: FND_LOG.string(FND_LOG.level_statement, l_mod_name,'OKS_RENCON_PVT.CREATE_OPERATION_INSTANCES NO_DATA_FOUND');
740: END IF;
741: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE, G_COL_NAME_TOKEN, 'CREATE_OPERATION_INSTANCES');
742: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
743: WHEN OTHERS THEN
744: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
745: FND_LOG.string(FND_LOG.level_statement, l_mod_name,'OKS_RENCON_PVT.CREATE_OPERATION_INSTANCES OTHERS ');
746: END IF;

Line 749: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');

745: FND_LOG.string(FND_LOG.level_statement, l_mod_name,'OKS_RENCON_PVT.CREATE_OPERATION_INSTANCES OTHERS ');
746: END IF;
747: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,
748: G_SQLCODE_TOKEN, SQLCODE, G_SQLERRM_TOKEN, SQLERRM);
749: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
750: END;
751: ----------------------------------------------------------------------------
752: ---Create OKC_OPERATIONS_LINES and update the PLSQL table with the oper_lines_id
753: ----------------------------------------------------------------------------

Line 765: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');

761: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
762: FND_LOG.string(FND_LOG.level_statement, l_mod_name,'OKS_RENCON_PVT.CREATE_OPERATION_LINES NO_DATA_FOUND');
763: END IF;
764: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE, G_COL_NAME_TOKEN, 'CREATE_OPERATION_LINES');
765: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
766: WHEN OTHERS THEN
767: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
768: FND_LOG.string(FND_LOG.level_statement, l_mod_name,'OKS_RENCON_PVT.CREATE_OPERATION_LINES OTHERS ');
769: END IF;

Line 772: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');

768: FND_LOG.string(FND_LOG.level_statement, l_mod_name,'OKS_RENCON_PVT.CREATE_OPERATION_LINES OTHERS ');
769: END IF;
770: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,
771: G_SQLCODE_TOKEN, SQLCODE, G_SQLERRM_TOKEN, SQLERRM);
772: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
773: END;
774: END IF;
775: END;
776:

Line 945: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');

941: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
942: FND_LOG.string(FND_LOG.level_statement, l_mod_name,'OKS_RENCON_PVT.IS_K_PRESENT NO_DATA_FOUND');
943: END IF;
944: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE, G_COL_NAME_TOKEN, 'IS_PRESENT');
945: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
946: WHEN OTHERS THEN
947: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
948: FND_LOG.string(FND_LOG.level_statement, l_mod_name,'OKS_RENCON_PVT.IS_K_PRESENT OTHERS ');
949: END IF;

Line 952: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');

948: FND_LOG.string(FND_LOG.level_statement, l_mod_name,'OKS_RENCON_PVT.IS_K_PRESENT OTHERS ');
949: END IF;
950: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,
951: G_SQLCODE_TOKEN, SQLCODE, G_SQLERRM_TOKEN, SQLERRM);
952: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
953: END IS_K_PRESENT;
954:
955:
956: FUNCTION IS_PRESENT(p_line_id IN NUMBER, p_operation_lines_id OUT NOCOPY NUMBER, p_id_list IN OKS_RENCON_PVT.sources_tbl_type) RETURN VARCHAR2 IS

Line 990: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');

986: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
987: FND_LOG.string(FND_LOG.level_statement, l_mod_name,'OKS_RENCON_PVT.IS_PRESENT NO_DATA_FOUND');
988: END IF;
989: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE, G_COL_NAME_TOKEN, 'IS_PRESENT');
990: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
991: WHEN OTHERS THEN
992: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
993: FND_LOG.string(FND_LOG.level_statement, l_mod_name,'OKS_RENCON_PVT.IS_PRESENT OTHERS ');
994: END IF;

Line 997: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');

993: FND_LOG.string(FND_LOG.level_statement, l_mod_name,'OKS_RENCON_PVT.IS_PRESENT OTHERS ');
994: END IF;
995: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,
996: G_SQLCODE_TOKEN, SQLCODE, G_SQLERRM_TOKEN, SQLERRM);
997: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
998: END IS_PRESENT;
999:
1000: FUNCTION GET_HDR_OLE_ID(p_header_id IN NUMBER) RETURN NUMBER IS
1001: CURSOR header_op_line IS