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.

[Home] [Help]

APPS.OKS_RENCON_PVT dependencies on DBMS_TRANSACTION

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

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

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

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

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

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

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

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

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

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

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

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

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

947: FND_LOG.string(FND_LOG.level_statement, l_mod_name,'OKS_RENCON_PVT.IS_K_PRESENT OTHERS ');
948: END IF;
949: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,
950: G_SQLCODE_TOKEN, SQLCODE, G_SQLERRM_TOKEN, SQLERRM);
951: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
952: END IS_K_PRESENT;
953:
954:
955: 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 989: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');

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

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

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