APPS.OKS_COVERAGES_PVT dependencies on DBMS_TRANSACTION

Line 3508: DBMS_TRANSACTION.SAVEPOINT(l_api_name);

3504: l_bp_offset_period VARCHAR2(3) := NULL;
3505:
3506: BEGIN
3507:
3508: DBMS_TRANSACTION.SAVEPOINT(l_api_name);
3509:
3510: IF (G_DEBUG_ENABLED = 'Y') THEN
3511: okc_debug.Set_Indentation('Update Coverage Effectivity');
3512: okc_debug.log('Entered Update Coverage Effectivity', 2);

Line 3701: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name );

3697: okc_debug.Reset_Indentation;
3698: END IF;
3699:
3700:
3701: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name );
3702: --ROLLBACK ;
3703: OKC_API.SET_MESSAGE(g_app_name,'OKSMIS_REQUIRED_FIELD','FIELD_NAME','Coverage to run effectivity adjustment');
3704: x_return_status := 'E';
3705:

Line 3713: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name );

3709: okc_debug.log('Exp of Update_Coverage_Effectivity e_Error'||SQLERRM, 2);
3710: okc_debug.Reset_Indentation;
3711: END IF;
3712:
3713: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name );
3714: --ROLLBACK ;
3715: x_msg_count :=l_msg_count;
3716: x_msg_data:=l_msg_data;
3717: x_return_status := 'E';

Line 3725: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name );

3721: IF (G_DEBUG_ENABLED = 'Y') THEN
3722: okc_debug.log('Exp of Update_Coverage_Effectivity '||SQLERRM, 2);
3723: okc_debug.Reset_Indentation;
3724: END IF;
3725: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name );
3726: --ROLLBACK ;
3727: x_msg_count :=l_msg_count;
3728: x_msg_data:=l_msg_data;
3729: x_return_status := 'E';

Line 3738: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name );

3734: IF (G_DEBUG_ENABLED = 'Y') THEN
3735: okc_debug.log('Exp of Update_Coverage_Effectivity '||SQLERRM, 2);
3736: okc_debug.Reset_Indentation;
3737: END IF;
3738: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name );
3739: --ROLLBACK ;
3740: x_msg_count :=l_msg_count;
3741: x_msg_data:=l_msg_data;
3742: x_return_status := 'E';

Line 3751: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name );

3747: okc_debug.log('Exp of Update_Coverage_Effectivity '||SQLERRM, 2);
3748: okc_debug.Reset_Indentation;
3749: END IF;
3750:
3751: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name );
3752: --ROLLBACK ;
3753: OKC_API.SET_MESSAGE(
3754: p_app_name => g_app_name,
3755: p_msg_name => g_unexpected_error,