APPS.OKL_VR_DATA_HANDLER_PVT dependencies on OKL_API

Line 18: x_return_status := OKL_API.G_RET_STS_SUCCESS;

14: IS
15:
16: BEGIN
17: OKL_VARIABLE_INTEREST_PVT.print_debug('Before updating Last Interest Calculation Date:' || p_last_interest_cal_date);
18: x_return_status := OKL_API.G_RET_STS_SUCCESS;
19:
20: UPDATE okl_k_headers khr
21: SET khr.date_last_interim_interest_cal = p_last_interest_cal_date
22: WHERE khr.id = p_contract_id;

Line 27: Okl_Api.SET_MESSAGE(

23:
24: EXCEPTION
25: WHEN OTHERS THEN
26: OKL_VARIABLE_INTEREST_PVT.print_error_message ('Exception raised in procedure UPDATE_LAST_INT_CAL_DATE');
27: Okl_Api.SET_MESSAGE(
28: p_app_name => G_APP_NAME,
29: p_msg_name => G_UNEXPECTED_ERROR,
30: p_token1 => G_SQLCODE_TOKEN,
31: p_token1_value => SQLCODE,

Line 34: x_return_status := OKL_API.G_RET_STS_ERROR;

30: p_token1 => G_SQLCODE_TOKEN,
31: p_token1_value => SQLCODE,
32: p_token2 => G_SQLERRM_TOKEN,
33: p_token2_value => SQLERRM);
34: x_return_status := OKL_API.G_RET_STS_ERROR;
35: END UPDATE_LAST_INT_CAL_DATE;
36:
37:
38:

Line 41: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

37:
38:
39: PROCEDURE INSERT_PRINCIPAL_BAL_TXN(
40: p_api_version IN NUMBER,
41: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
42: x_return_status OUT NOCOPY VARCHAR2,
43: x_msg_count OUT NOCOPY NUMBER,
44: x_msg_data OUT NOCOPY VARCHAR2,
45: p_vpb_tbl IN OKL_VARIABLE_INTEREST_PVT.vpb_tbl_type) IS

Line 50: x_return_status := OKL_API.G_RET_STS_SUCCESS;

46:
47: l_index NUMBER := 0;
48:
49: BEGIN
50: x_return_status := OKL_API.G_RET_STS_SUCCESS;
51:
52: OKL_VARIABLE_INTEREST_PVT.print_debug('Executing procedure INSERT_PRINCIPAL_BAL_TXN using following parameters : ');
53: OKL_VARIABLE_INTEREST_PVT.print_debug(' p_vpb_tbl.count : '|| p_vpb_tbl.COUNT );
54: OKL_VARIABLE_INTEREST_PVT.print_vpb_tbl (p_vpb_tbl);

Line 88: x_return_status := OKL_API.G_RET_STS_ERROR;

84: sqlerrm(sql%bulk_exceptions(i).error_code));
85: end loop;
86: END IF;
87:
88: x_return_status := OKL_API.G_RET_STS_ERROR;
89: Okl_Api.SET_MESSAGE(
90: p_app_name => G_APP_NAME,
91: p_msg_name => G_UNEXPECTED_ERROR,
92: p_token1 => G_SQLCODE_TOKEN,

Line 89: Okl_Api.SET_MESSAGE(

85: end loop;
86: END IF;
87:
88: x_return_status := OKL_API.G_RET_STS_ERROR;
89: Okl_Api.SET_MESSAGE(
90: p_app_name => G_APP_NAME,
91: p_msg_name => G_UNEXPECTED_ERROR,
92: p_token1 => G_SQLCODE_TOKEN,
93: p_token1_value => SQLCODE,

Line 102: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

98:
99:
100: PROCEDURE INSERT_VIR_PARAMS(
101: p_api_version IN NUMBER,
102: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
103: x_return_status OUT NOCOPY VARCHAR2,
104: x_msg_count OUT NOCOPY NUMBER,
105: x_msg_data OUT NOCOPY VARCHAR2,
106: p_vir_tbl IN OKL_VARIABLE_INTEREST_PVT.vir_tbl_type) IS

Line 111: x_return_status := OKL_API.G_RET_STS_SUCCESS;

107:
108: l_index NUMBER := 0;
109:
110: BEGIN
111: x_return_status := OKL_API.G_RET_STS_SUCCESS;
112:
113: OKL_VARIABLE_INTEREST_PVT.print_debug('Executing procedure INSERT_VIR_PARAMS using following parameters : ');
114: OKL_VARIABLE_INTEREST_PVT.print_debug(' p_vir_tbl.count : '|| p_vir_tbl.COUNT );
115: OKL_VARIABLE_INTEREST_PVT.print_vir_tbl (p_vir_tbl);

Line 148: x_return_status := OKL_API.G_RET_STS_ERROR;

144: sqlerrm(sql%bulk_exceptions(i).error_code));
145: end loop;
146: END IF;
147:
148: x_return_status := OKL_API.G_RET_STS_ERROR;
149: Okl_Api.SET_MESSAGE(
150: p_app_name => G_APP_NAME,
151: p_msg_name => G_UNEXPECTED_ERROR,
152: p_token1 => G_SQLCODE_TOKEN,

Line 149: Okl_Api.SET_MESSAGE(

145: end loop;
146: END IF;
147:
148: x_return_status := OKL_API.G_RET_STS_ERROR;
149: Okl_Api.SET_MESSAGE(
150: p_app_name => G_APP_NAME,
151: p_msg_name => G_UNEXPECTED_ERROR,
152: p_token1 => G_SQLCODE_TOKEN,
153: p_token1_value => SQLCODE,