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.OKL_VR_DATA_HANDLER_PVT dependencies on OKL_VARIABLE_INTEREST_PVT

Line 17: OKL_VARIABLE_INTEREST_PVT.print_debug('Before updating Last Interest Calculation Date:' || p_last_interest_cal_date);

13: )
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

Line 26: OKL_VARIABLE_INTEREST_PVT.print_error_message ('Exception raised in procedure UPDATE_LAST_INT_CAL_DATE');

22: WHERE khr.id = p_contract_id;
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,

Line 45: p_vpb_tbl IN OKL_VARIABLE_INTEREST_PVT.vpb_tbl_type) IS

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
46:
47: l_index NUMBER := 0;
48:
49: BEGIN

Line 52: OKL_VARIABLE_INTEREST_PVT.print_debug('Executing procedure INSERT_PRINCIPAL_BAL_TXN using following parameters : ');

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);
55:
56: IF (p_vpb_tbl.COUNT > 0) THEN

Line 53: OKL_VARIABLE_INTEREST_PVT.print_debug(' p_vpb_tbl.count : '|| p_vpb_tbl.COUNT );

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);
55:
56: IF (p_vpb_tbl.COUNT > 0) THEN
57: FORALL l_index in p_vpb_tbl.FIRST .. p_vpb_tbl.LAST

Line 54: OKL_VARIABLE_INTEREST_PVT.print_vpb_tbl (p_vpb_tbl);

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);
55:
56: IF (p_vpb_tbl.COUNT > 0) THEN
57: FORALL l_index in p_vpb_tbl.FIRST .. p_vpb_tbl.LAST
58: save exceptions

Line 61: OKL_VARIABLE_INTEREST_PVT.print_debug ('Exception count : '|| sql%bulk_exceptions.count);

57: FORALL l_index in p_vpb_tbl.FIRST .. p_vpb_tbl.LAST
58: save exceptions
59: INSERT INTO OKL_VAR_PRINCIPAL_BAL_TXN VALUES p_vpb_tbl(l_index);
60:
61: OKL_VARIABLE_INTEREST_PVT.print_debug ('Exception count : '|| sql%bulk_exceptions.count);
62: IF sql%bulk_exceptions.count > 0 then
63: for i in 1..sql%bulk_exceptions.count loop
64: OKL_VARIABLE_INTEREST_PVT.print_debug('while fetching, error ' || i || ' occurred during '||
65: 'iteration ' || sql%bulk_exceptions(i).error_index);

Line 64: OKL_VARIABLE_INTEREST_PVT.print_debug('while fetching, error ' || i || ' occurred during '||

60:
61: OKL_VARIABLE_INTEREST_PVT.print_debug ('Exception count : '|| sql%bulk_exceptions.count);
62: IF sql%bulk_exceptions.count > 0 then
63: for i in 1..sql%bulk_exceptions.count loop
64: OKL_VARIABLE_INTEREST_PVT.print_debug('while fetching, error ' || i || ' occurred during '||
65: 'iteration ' || sql%bulk_exceptions(i).error_index);
66: OKL_VARIABLE_INTEREST_PVT.print_debug('oracle error is ' ||
67: sqlerrm(sql%bulk_exceptions(i).error_code));
68:

Line 66: OKL_VARIABLE_INTEREST_PVT.print_debug('oracle error is ' ||

62: IF sql%bulk_exceptions.count > 0 then
63: for i in 1..sql%bulk_exceptions.count loop
64: OKL_VARIABLE_INTEREST_PVT.print_debug('while fetching, error ' || i || ' occurred during '||
65: 'iteration ' || sql%bulk_exceptions(i).error_index);
66: OKL_VARIABLE_INTEREST_PVT.print_debug('oracle error is ' ||
67: sqlerrm(sql%bulk_exceptions(i).error_code));
68:
69: end loop;
70: end if;

Line 71: OKL_VARIABLE_INTEREST_PVT.print_debug ('No. of records inserted : '|| SQL%rowcount);

67: sqlerrm(sql%bulk_exceptions(i).error_code));
68:
69: end loop;
70: end if;
71: OKL_VARIABLE_INTEREST_PVT.print_debug ('No. of records inserted : '|| SQL%rowcount);
72: END IF;
73:
74: EXCEPTION
75: WHEN OTHERS THEN

Line 76: OKL_VARIABLE_INTEREST_PVT.print_error_message('Exception raised in procedure INSERT_PRINCIPAL_BAL_TXN');

72: END IF;
73:
74: EXCEPTION
75: WHEN OTHERS THEN
76: OKL_VARIABLE_INTEREST_PVT.print_error_message('Exception raised in procedure INSERT_PRINCIPAL_BAL_TXN');
77: OKL_VARIABLE_INTEREST_PVT.print_debug ('Exception during bulk insert');
78: OKL_VARIABLE_INTEREST_PVT.print_debug ('Exception count : '|| sql%bulk_exceptions.count);
79: IF sql%bulk_exceptions.count > 0 then
80: for i in 1..sql%bulk_exceptions.count loop

Line 77: OKL_VARIABLE_INTEREST_PVT.print_debug ('Exception during bulk insert');

73:
74: EXCEPTION
75: WHEN OTHERS THEN
76: OKL_VARIABLE_INTEREST_PVT.print_error_message('Exception raised in procedure INSERT_PRINCIPAL_BAL_TXN');
77: OKL_VARIABLE_INTEREST_PVT.print_debug ('Exception during bulk insert');
78: OKL_VARIABLE_INTEREST_PVT.print_debug ('Exception count : '|| sql%bulk_exceptions.count);
79: IF sql%bulk_exceptions.count > 0 then
80: for i in 1..sql%bulk_exceptions.count loop
81: OKL_VARIABLE_INTEREST_PVT.print_debug('while fetching, error ' || i || ' occurred during '||

Line 78: OKL_VARIABLE_INTEREST_PVT.print_debug ('Exception count : '|| sql%bulk_exceptions.count);

74: EXCEPTION
75: WHEN OTHERS THEN
76: OKL_VARIABLE_INTEREST_PVT.print_error_message('Exception raised in procedure INSERT_PRINCIPAL_BAL_TXN');
77: OKL_VARIABLE_INTEREST_PVT.print_debug ('Exception during bulk insert');
78: OKL_VARIABLE_INTEREST_PVT.print_debug ('Exception count : '|| sql%bulk_exceptions.count);
79: IF sql%bulk_exceptions.count > 0 then
80: for i in 1..sql%bulk_exceptions.count loop
81: OKL_VARIABLE_INTEREST_PVT.print_debug('while fetching, error ' || i || ' occurred during '||
82: 'iteration ' || sql%bulk_exceptions(i).error_index);

Line 81: OKL_VARIABLE_INTEREST_PVT.print_debug('while fetching, error ' || i || ' occurred during '||

77: OKL_VARIABLE_INTEREST_PVT.print_debug ('Exception during bulk insert');
78: OKL_VARIABLE_INTEREST_PVT.print_debug ('Exception count : '|| sql%bulk_exceptions.count);
79: IF sql%bulk_exceptions.count > 0 then
80: for i in 1..sql%bulk_exceptions.count loop
81: OKL_VARIABLE_INTEREST_PVT.print_debug('while fetching, error ' || i || ' occurred during '||
82: 'iteration ' || sql%bulk_exceptions(i).error_index);
83: OKL_VARIABLE_INTEREST_PVT.print_debug('oracle error is ' ||
84: sqlerrm(sql%bulk_exceptions(i).error_code));
85: end loop;

Line 83: OKL_VARIABLE_INTEREST_PVT.print_debug('oracle error is ' ||

79: IF sql%bulk_exceptions.count > 0 then
80: for i in 1..sql%bulk_exceptions.count loop
81: OKL_VARIABLE_INTEREST_PVT.print_debug('while fetching, error ' || i || ' occurred during '||
82: 'iteration ' || sql%bulk_exceptions(i).error_index);
83: OKL_VARIABLE_INTEREST_PVT.print_debug('oracle error is ' ||
84: sqlerrm(sql%bulk_exceptions(i).error_code));
85: end loop;
86: END IF;
87:

Line 106: p_vir_tbl IN OKL_VARIABLE_INTEREST_PVT.vir_tbl_type) IS

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
107:
108: l_index NUMBER := 0;
109:
110: BEGIN

Line 113: OKL_VARIABLE_INTEREST_PVT.print_debug('Executing procedure INSERT_VIR_PARAMS using following parameters : ');

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);
116:
117: IF (p_vir_tbl.COUNT > 0) THEN

Line 114: OKL_VARIABLE_INTEREST_PVT.print_debug(' p_vir_tbl.count : '|| p_vir_tbl.COUNT );

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);
116:
117: IF (p_vir_tbl.COUNT > 0) THEN
118: FORALL l_index in p_vir_tbl.FIRST .. p_vir_tbl.LAST

Line 115: OKL_VARIABLE_INTEREST_PVT.print_vir_tbl (p_vir_tbl);

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);
116:
117: IF (p_vir_tbl.COUNT > 0) THEN
118: FORALL l_index in p_vir_tbl.FIRST .. p_vir_tbl.LAST
119: save exceptions

Line 122: OKL_VARIABLE_INTEREST_PVT.print_debug ('Exception count : '|| sql%bulk_exceptions.count);

118: FORALL l_index in p_vir_tbl.FIRST .. p_vir_tbl.LAST
119: save exceptions
120: INSERT INTO okl_var_int_params VALUES p_vir_tbl(l_index);
121:
122: OKL_VARIABLE_INTEREST_PVT.print_debug ('Exception count : '|| sql%bulk_exceptions.count);
123: IF sql%bulk_exceptions.count > 0 then
124: for i in 1..sql%bulk_exceptions.count loop
125: OKL_VARIABLE_INTEREST_PVT.print_debug('while fetching, error ' || i || ' occurred during '||
126: 'iteration ' || sql%bulk_exceptions(i).error_index);

Line 125: OKL_VARIABLE_INTEREST_PVT.print_debug('while fetching, error ' || i || ' occurred during '||

121:
122: OKL_VARIABLE_INTEREST_PVT.print_debug ('Exception count : '|| sql%bulk_exceptions.count);
123: IF sql%bulk_exceptions.count > 0 then
124: for i in 1..sql%bulk_exceptions.count loop
125: OKL_VARIABLE_INTEREST_PVT.print_debug('while fetching, error ' || i || ' occurred during '||
126: 'iteration ' || sql%bulk_exceptions(i).error_index);
127: OKL_VARIABLE_INTEREST_PVT.print_debug('oracle error is ' ||
128: sqlerrm(sql%bulk_exceptions(i).error_code));
129: end loop;

Line 127: OKL_VARIABLE_INTEREST_PVT.print_debug('oracle error is ' ||

123: IF sql%bulk_exceptions.count > 0 then
124: for i in 1..sql%bulk_exceptions.count loop
125: OKL_VARIABLE_INTEREST_PVT.print_debug('while fetching, error ' || i || ' occurred during '||
126: 'iteration ' || sql%bulk_exceptions(i).error_index);
127: OKL_VARIABLE_INTEREST_PVT.print_debug('oracle error is ' ||
128: sqlerrm(sql%bulk_exceptions(i).error_code));
129: end loop;
130: end if;
131: OKL_VARIABLE_INTEREST_PVT.print_debug ('No. of records inserted : '|| SQL%rowcount);

Line 131: OKL_VARIABLE_INTEREST_PVT.print_debug ('No. of records inserted : '|| SQL%rowcount);

127: OKL_VARIABLE_INTEREST_PVT.print_debug('oracle error is ' ||
128: sqlerrm(sql%bulk_exceptions(i).error_code));
129: end loop;
130: end if;
131: OKL_VARIABLE_INTEREST_PVT.print_debug ('No. of records inserted : '|| SQL%rowcount);
132: END IF;
133:
134: EXCEPTION
135: WHEN OTHERS THEN

Line 136: OKL_VARIABLE_INTEREST_PVT.print_error_message('Exception raised in procedure POPULATE_VIR_PARAMS');

132: END IF;
133:
134: EXCEPTION
135: WHEN OTHERS THEN
136: OKL_VARIABLE_INTEREST_PVT.print_error_message('Exception raised in procedure POPULATE_VIR_PARAMS');
137: OKL_VARIABLE_INTEREST_PVT.print_debug ('Exception during bulk insert');
138: OKL_VARIABLE_INTEREST_PVT.print_debug ('Exception count : '|| sql%bulk_exceptions.count);
139: IF sql%bulk_exceptions.count > 0 then
140: for i in 1..sql%bulk_exceptions.count loop

Line 137: OKL_VARIABLE_INTEREST_PVT.print_debug ('Exception during bulk insert');

133:
134: EXCEPTION
135: WHEN OTHERS THEN
136: OKL_VARIABLE_INTEREST_PVT.print_error_message('Exception raised in procedure POPULATE_VIR_PARAMS');
137: OKL_VARIABLE_INTEREST_PVT.print_debug ('Exception during bulk insert');
138: OKL_VARIABLE_INTEREST_PVT.print_debug ('Exception count : '|| sql%bulk_exceptions.count);
139: IF sql%bulk_exceptions.count > 0 then
140: for i in 1..sql%bulk_exceptions.count loop
141: OKL_VARIABLE_INTEREST_PVT.print_debug('while fetching, error ' || i || ' occurred during '||

Line 138: OKL_VARIABLE_INTEREST_PVT.print_debug ('Exception count : '|| sql%bulk_exceptions.count);

134: EXCEPTION
135: WHEN OTHERS THEN
136: OKL_VARIABLE_INTEREST_PVT.print_error_message('Exception raised in procedure POPULATE_VIR_PARAMS');
137: OKL_VARIABLE_INTEREST_PVT.print_debug ('Exception during bulk insert');
138: OKL_VARIABLE_INTEREST_PVT.print_debug ('Exception count : '|| sql%bulk_exceptions.count);
139: IF sql%bulk_exceptions.count > 0 then
140: for i in 1..sql%bulk_exceptions.count loop
141: OKL_VARIABLE_INTEREST_PVT.print_debug('while fetching, error ' || i || ' occurred during '||
142: 'iteration ' || sql%bulk_exceptions(i).error_index);

Line 141: OKL_VARIABLE_INTEREST_PVT.print_debug('while fetching, error ' || i || ' occurred during '||

137: OKL_VARIABLE_INTEREST_PVT.print_debug ('Exception during bulk insert');
138: OKL_VARIABLE_INTEREST_PVT.print_debug ('Exception count : '|| sql%bulk_exceptions.count);
139: IF sql%bulk_exceptions.count > 0 then
140: for i in 1..sql%bulk_exceptions.count loop
141: OKL_VARIABLE_INTEREST_PVT.print_debug('while fetching, error ' || i || ' occurred during '||
142: 'iteration ' || sql%bulk_exceptions(i).error_index);
143: OKL_VARIABLE_INTEREST_PVT.print_debug('oracle error is ' ||
144: sqlerrm(sql%bulk_exceptions(i).error_code));
145: end loop;

Line 143: OKL_VARIABLE_INTEREST_PVT.print_debug('oracle error is ' ||

139: IF sql%bulk_exceptions.count > 0 then
140: for i in 1..sql%bulk_exceptions.count loop
141: OKL_VARIABLE_INTEREST_PVT.print_debug('while fetching, error ' || i || ' occurred during '||
142: 'iteration ' || sql%bulk_exceptions(i).error_index);
143: OKL_VARIABLE_INTEREST_PVT.print_debug('oracle error is ' ||
144: sqlerrm(sql%bulk_exceptions(i).error_code));
145: end loop;
146: END IF;
147: