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_FE_STD_RATE_TMPL_PUB dependencies on OKL_API

Line 23: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

19: -- procedure to give the details of the Standard Rate Template
20: --given the Standard Rate Template id and the version number
21:
22: PROCEDURE get_version(p_api_version IN NUMBER
23: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
24: ,x_return_status OUT NOCOPY VARCHAR2
25: ,x_msg_count OUT NOCOPY NUMBER
26: ,x_msg_data OUT NOCOPY VARCHAR2
27: ,p_srt_id IN NUMBER

Line 36: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;

32: ,x_ecl_tbl OUT NOCOPY okl_ecl_tbl
33: ,x_ecv_tbl OUT NOCOPY okl_ecv_tbl) AS
34: l_api_version NUMBER := 1.0;
35: l_api_name VARCHAR2(40) := 'get_version';
36: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
37:
38: BEGIN
39: l_return_status := okl_api.start_activity(l_api_name
40: ,g_pkg_name

Line 39: l_return_status := okl_api.start_activity(l_api_name

35: l_api_name VARCHAR2(40) := 'get_version';
36: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
37:
38: BEGIN
39: l_return_status := okl_api.start_activity(l_api_name
40: ,g_pkg_name
41: ,p_init_msg_list
42: ,l_api_version
43: ,p_api_version

Line 47: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

43: ,p_api_version
44: ,'_Pub'
45: ,x_return_status);
46:
47: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
48: RAISE okl_api.g_exception_unexpected_error;
49: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
50: RAISE okl_api.g_exception_error;
51: END IF;

Line 48: RAISE okl_api.g_exception_unexpected_error;

44: ,'_Pub'
45: ,x_return_status);
46:
47: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
48: RAISE okl_api.g_exception_unexpected_error;
49: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
50: RAISE okl_api.g_exception_error;
51: END IF;
52: okl_fe_std_rate_tmpl_pvt.get_version(l_api_version

Line 49: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

45: ,x_return_status);
46:
47: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
48: RAISE okl_api.g_exception_unexpected_error;
49: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
50: RAISE okl_api.g_exception_error;
51: END IF;
52: okl_fe_std_rate_tmpl_pvt.get_version(l_api_version
53: ,p_init_msg_list

Line 50: RAISE okl_api.g_exception_error;

46:
47: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
48: RAISE okl_api.g_exception_unexpected_error;
49: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
50: RAISE okl_api.g_exception_error;
51: END IF;
52: okl_fe_std_rate_tmpl_pvt.get_version(l_api_version
53: ,p_init_msg_list
54: ,l_return_status

Line 65: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

61: ,x_ech_rec
62: ,x_ecl_tbl
63: ,x_ecv_tbl);
64:
65: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
66: RAISE okl_api.g_exception_unexpected_error;
67: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
68: RAISE okl_api.g_exception_error;
69: END IF;

Line 66: RAISE okl_api.g_exception_unexpected_error;

62: ,x_ecl_tbl
63: ,x_ecv_tbl);
64:
65: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
66: RAISE okl_api.g_exception_unexpected_error;
67: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
68: RAISE okl_api.g_exception_error;
69: END IF;
70:

Line 67: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

63: ,x_ecv_tbl);
64:
65: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
66: RAISE okl_api.g_exception_unexpected_error;
67: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
68: RAISE okl_api.g_exception_error;
69: END IF;
70:
71: --end activity

Line 68: RAISE okl_api.g_exception_error;

64:
65: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
66: RAISE okl_api.g_exception_unexpected_error;
67: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
68: RAISE okl_api.g_exception_error;
69: END IF;
70:
71: --end activity
72:

Line 73: okl_api.end_activity(x_msg_count

69: END IF;
70:
71: --end activity
72:
73: okl_api.end_activity(x_msg_count
74: ,x_msg_data);
75: x_return_status := l_return_status;
76: EXCEPTION
77: WHEN okl_api.g_exception_error THEN

Line 77: WHEN okl_api.g_exception_error THEN

73: okl_api.end_activity(x_msg_count
74: ,x_msg_data);
75: x_return_status := l_return_status;
76: EXCEPTION
77: WHEN okl_api.g_exception_error THEN
78: x_return_status := okl_api.handle_exceptions(l_api_name
79: ,g_pkg_name
80: ,'OKL_API.G_RET_STS_ERROR'
81: ,x_msg_count

Line 78: x_return_status := okl_api.handle_exceptions(l_api_name

74: ,x_msg_data);
75: x_return_status := l_return_status;
76: EXCEPTION
77: WHEN okl_api.g_exception_error THEN
78: x_return_status := okl_api.handle_exceptions(l_api_name
79: ,g_pkg_name
80: ,'OKL_API.G_RET_STS_ERROR'
81: ,x_msg_count
82: ,x_msg_data

Line 80: ,'OKL_API.G_RET_STS_ERROR'

76: EXCEPTION
77: WHEN okl_api.g_exception_error THEN
78: x_return_status := okl_api.handle_exceptions(l_api_name
79: ,g_pkg_name
80: ,'OKL_API.G_RET_STS_ERROR'
81: ,x_msg_count
82: ,x_msg_data
83: ,'_Pub');
84: WHEN okl_api.g_exception_unexpected_error THEN

Line 84: WHEN okl_api.g_exception_unexpected_error THEN

80: ,'OKL_API.G_RET_STS_ERROR'
81: ,x_msg_count
82: ,x_msg_data
83: ,'_Pub');
84: WHEN okl_api.g_exception_unexpected_error THEN
85: x_return_status := okl_api.handle_exceptions(l_api_name
86: ,g_pkg_name
87: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
88: ,x_msg_count

Line 85: x_return_status := okl_api.handle_exceptions(l_api_name

81: ,x_msg_count
82: ,x_msg_data
83: ,'_Pub');
84: WHEN okl_api.g_exception_unexpected_error THEN
85: x_return_status := okl_api.handle_exceptions(l_api_name
86: ,g_pkg_name
87: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
88: ,x_msg_count
89: ,x_msg_data

Line 87: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

83: ,'_Pub');
84: WHEN okl_api.g_exception_unexpected_error THEN
85: x_return_status := okl_api.handle_exceptions(l_api_name
86: ,g_pkg_name
87: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
88: ,x_msg_count
89: ,x_msg_data
90: ,'_Pub');
91: WHEN OTHERS THEN

Line 92: x_return_status := okl_api.handle_exceptions(l_api_name

88: ,x_msg_count
89: ,x_msg_data
90: ,'_Pub');
91: WHEN OTHERS THEN
92: x_return_status := okl_api.handle_exceptions(l_api_name
93: ,g_pkg_name
94: ,'OTHERS'
95: ,x_msg_count
96: ,x_msg_data

Line 104: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

100: -- procedure to give the details of the latest version of Standard Rate Template
101: -- given the Standard Rate Template Id
102:
103: PROCEDURE get_version(p_api_version IN NUMBER
104: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
105: ,x_return_status OUT NOCOPY VARCHAR2
106: ,x_msg_count OUT NOCOPY NUMBER
107: ,x_msg_data OUT NOCOPY VARCHAR2
108: ,p_srt_id IN NUMBER

Line 116: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;

112: ,x_ecl_tbl OUT NOCOPY okl_ecl_tbl
113: ,x_ecv_tbl OUT NOCOPY okl_ecv_tbl) AS
114: l_api_version NUMBER := 1.0;
115: l_api_name VARCHAR2(40) := 'get_version';
116: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
117:
118: BEGIN
119: l_return_status := okl_api.start_activity(l_api_name
120: ,g_pkg_name

Line 119: l_return_status := okl_api.start_activity(l_api_name

115: l_api_name VARCHAR2(40) := 'get_version';
116: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
117:
118: BEGIN
119: l_return_status := okl_api.start_activity(l_api_name
120: ,g_pkg_name
121: ,p_init_msg_list
122: ,l_api_version
123: ,p_api_version

Line 127: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

123: ,p_api_version
124: ,'_Pub'
125: ,x_return_status);
126:
127: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
128: RAISE okl_api.g_exception_unexpected_error;
129: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
130: RAISE okl_api.g_exception_error;
131: END IF;

Line 128: RAISE okl_api.g_exception_unexpected_error;

124: ,'_Pub'
125: ,x_return_status);
126:
127: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
128: RAISE okl_api.g_exception_unexpected_error;
129: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
130: RAISE okl_api.g_exception_error;
131: END IF;
132: okl_fe_std_rate_tmpl_pvt.get_version(l_api_version

Line 129: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

125: ,x_return_status);
126:
127: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
128: RAISE okl_api.g_exception_unexpected_error;
129: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
130: RAISE okl_api.g_exception_error;
131: END IF;
132: okl_fe_std_rate_tmpl_pvt.get_version(l_api_version
133: ,p_init_msg_list

Line 130: RAISE okl_api.g_exception_error;

126:
127: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
128: RAISE okl_api.g_exception_unexpected_error;
129: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
130: RAISE okl_api.g_exception_error;
131: END IF;
132: okl_fe_std_rate_tmpl_pvt.get_version(l_api_version
133: ,p_init_msg_list
134: ,l_return_status

Line 144: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

140: ,x_ech_rec
141: ,x_ecl_tbl
142: ,x_ecv_tbl);
143:
144: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
145: RAISE okl_api.g_exception_unexpected_error;
146: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
147: RAISE okl_api.g_exception_error;
148: END IF;

Line 145: RAISE okl_api.g_exception_unexpected_error;

141: ,x_ecl_tbl
142: ,x_ecv_tbl);
143:
144: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
145: RAISE okl_api.g_exception_unexpected_error;
146: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
147: RAISE okl_api.g_exception_error;
148: END IF;
149:

Line 146: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

142: ,x_ecv_tbl);
143:
144: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
145: RAISE okl_api.g_exception_unexpected_error;
146: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
147: RAISE okl_api.g_exception_error;
148: END IF;
149:
150: --end activity

Line 147: RAISE okl_api.g_exception_error;

143:
144: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
145: RAISE okl_api.g_exception_unexpected_error;
146: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
147: RAISE okl_api.g_exception_error;
148: END IF;
149:
150: --end activity
151:

Line 152: okl_api.end_activity(x_msg_count

148: END IF;
149:
150: --end activity
151:
152: okl_api.end_activity(x_msg_count
153: ,x_msg_data);
154: x_return_status := l_return_status;
155: EXCEPTION
156: WHEN okl_api.g_exception_error THEN

Line 156: WHEN okl_api.g_exception_error THEN

152: okl_api.end_activity(x_msg_count
153: ,x_msg_data);
154: x_return_status := l_return_status;
155: EXCEPTION
156: WHEN okl_api.g_exception_error THEN
157: x_return_status := okl_api.handle_exceptions(l_api_name
158: ,g_pkg_name
159: ,'OKL_API.G_RET_STS_ERROR'
160: ,x_msg_count

Line 157: x_return_status := okl_api.handle_exceptions(l_api_name

153: ,x_msg_data);
154: x_return_status := l_return_status;
155: EXCEPTION
156: WHEN okl_api.g_exception_error THEN
157: x_return_status := okl_api.handle_exceptions(l_api_name
158: ,g_pkg_name
159: ,'OKL_API.G_RET_STS_ERROR'
160: ,x_msg_count
161: ,x_msg_data

Line 159: ,'OKL_API.G_RET_STS_ERROR'

155: EXCEPTION
156: WHEN okl_api.g_exception_error THEN
157: x_return_status := okl_api.handle_exceptions(l_api_name
158: ,g_pkg_name
159: ,'OKL_API.G_RET_STS_ERROR'
160: ,x_msg_count
161: ,x_msg_data
162: ,'_Pub');
163: WHEN okl_api.g_exception_unexpected_error THEN

Line 163: WHEN okl_api.g_exception_unexpected_error THEN

159: ,'OKL_API.G_RET_STS_ERROR'
160: ,x_msg_count
161: ,x_msg_data
162: ,'_Pub');
163: WHEN okl_api.g_exception_unexpected_error THEN
164: x_return_status := okl_api.handle_exceptions(l_api_name
165: ,g_pkg_name
166: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
167: ,x_msg_count

Line 164: x_return_status := okl_api.handle_exceptions(l_api_name

160: ,x_msg_count
161: ,x_msg_data
162: ,'_Pub');
163: WHEN okl_api.g_exception_unexpected_error THEN
164: x_return_status := okl_api.handle_exceptions(l_api_name
165: ,g_pkg_name
166: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
167: ,x_msg_count
168: ,x_msg_data

Line 166: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

162: ,'_Pub');
163: WHEN okl_api.g_exception_unexpected_error THEN
164: x_return_status := okl_api.handle_exceptions(l_api_name
165: ,g_pkg_name
166: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
167: ,x_msg_count
168: ,x_msg_data
169: ,'_Pub');
170: WHEN OTHERS THEN

Line 171: x_return_status := okl_api.handle_exceptions(l_api_name

167: ,x_msg_count
168: ,x_msg_data
169: ,'_Pub');
170: WHEN OTHERS THEN
171: x_return_status := okl_api.handle_exceptions(l_api_name
172: ,g_pkg_name
173: ,'OTHERS'
174: ,x_msg_count
175: ,x_msg_data

Line 182: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

178:
179: -- procedure to create a new version of the Standard Rate Template
180:
181: PROCEDURE create_version(p_api_version IN NUMBER
182: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
183: ,x_return_status OUT NOCOPY VARCHAR2
184: ,x_msg_count OUT NOCOPY NUMBER
185: ,x_msg_data OUT NOCOPY VARCHAR2
186: ,p_srv_rec IN okl_srv_rec

Line 190: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;

186: ,p_srv_rec IN okl_srv_rec
187: ,x_srv_rec OUT NOCOPY okl_srv_rec) AS
188: l_api_version NUMBER := 1.0;
189: l_api_name VARCHAR2(40) := 'create_version';
190: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
191:
192: BEGIN
193: l_return_status := okl_api.start_activity(l_api_name
194: ,g_pkg_name

Line 193: l_return_status := okl_api.start_activity(l_api_name

189: l_api_name VARCHAR2(40) := 'create_version';
190: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
191:
192: BEGIN
193: l_return_status := okl_api.start_activity(l_api_name
194: ,g_pkg_name
195: ,p_init_msg_list
196: ,l_api_version
197: ,p_api_version

Line 201: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

197: ,p_api_version
198: ,'_Pub'
199: ,x_return_status);
200:
201: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
202: RAISE okl_api.g_exception_unexpected_error;
203: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
204: RAISE okl_api.g_exception_error;
205: END IF;

Line 202: RAISE okl_api.g_exception_unexpected_error;

198: ,'_Pub'
199: ,x_return_status);
200:
201: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
202: RAISE okl_api.g_exception_unexpected_error;
203: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
204: RAISE okl_api.g_exception_error;
205: END IF;
206: okl_fe_std_rate_tmpl_pvt.create_version(l_api_version

Line 203: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

199: ,x_return_status);
200:
201: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
202: RAISE okl_api.g_exception_unexpected_error;
203: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
204: RAISE okl_api.g_exception_error;
205: END IF;
206: okl_fe_std_rate_tmpl_pvt.create_version(l_api_version
207: ,p_init_msg_list

Line 204: RAISE okl_api.g_exception_error;

200:
201: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
202: RAISE okl_api.g_exception_unexpected_error;
203: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
204: RAISE okl_api.g_exception_error;
205: END IF;
206: okl_fe_std_rate_tmpl_pvt.create_version(l_api_version
207: ,p_init_msg_list
208: ,l_return_status

Line 214: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

210: ,x_msg_data
211: ,p_srv_rec
212: ,x_srv_rec);
213:
214: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
215: RAISE okl_api.g_exception_unexpected_error;
216: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
217: RAISE okl_api.g_exception_error;
218: END IF;

Line 215: RAISE okl_api.g_exception_unexpected_error;

211: ,p_srv_rec
212: ,x_srv_rec);
213:
214: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
215: RAISE okl_api.g_exception_unexpected_error;
216: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
217: RAISE okl_api.g_exception_error;
218: END IF;
219:

Line 216: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

212: ,x_srv_rec);
213:
214: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
215: RAISE okl_api.g_exception_unexpected_error;
216: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
217: RAISE okl_api.g_exception_error;
218: END IF;
219:
220: --end activity

Line 217: RAISE okl_api.g_exception_error;

213:
214: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
215: RAISE okl_api.g_exception_unexpected_error;
216: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
217: RAISE okl_api.g_exception_error;
218: END IF;
219:
220: --end activity
221:

Line 222: okl_api.end_activity(x_msg_count

218: END IF;
219:
220: --end activity
221:
222: okl_api.end_activity(x_msg_count
223: ,x_msg_data);
224: x_return_status := l_return_status;
225: EXCEPTION
226: WHEN okl_api.g_exception_error THEN

Line 226: WHEN okl_api.g_exception_error THEN

222: okl_api.end_activity(x_msg_count
223: ,x_msg_data);
224: x_return_status := l_return_status;
225: EXCEPTION
226: WHEN okl_api.g_exception_error THEN
227: x_return_status := okl_api.handle_exceptions(l_api_name
228: ,g_pkg_name
229: ,'OKL_API.G_RET_STS_ERROR'
230: ,x_msg_count

Line 227: x_return_status := okl_api.handle_exceptions(l_api_name

223: ,x_msg_data);
224: x_return_status := l_return_status;
225: EXCEPTION
226: WHEN okl_api.g_exception_error THEN
227: x_return_status := okl_api.handle_exceptions(l_api_name
228: ,g_pkg_name
229: ,'OKL_API.G_RET_STS_ERROR'
230: ,x_msg_count
231: ,x_msg_data

Line 229: ,'OKL_API.G_RET_STS_ERROR'

225: EXCEPTION
226: WHEN okl_api.g_exception_error THEN
227: x_return_status := okl_api.handle_exceptions(l_api_name
228: ,g_pkg_name
229: ,'OKL_API.G_RET_STS_ERROR'
230: ,x_msg_count
231: ,x_msg_data
232: ,'_Pub');
233: WHEN okl_api.g_exception_unexpected_error THEN

Line 233: WHEN okl_api.g_exception_unexpected_error THEN

229: ,'OKL_API.G_RET_STS_ERROR'
230: ,x_msg_count
231: ,x_msg_data
232: ,'_Pub');
233: WHEN okl_api.g_exception_unexpected_error THEN
234: x_return_status := okl_api.handle_exceptions(l_api_name
235: ,g_pkg_name
236: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
237: ,x_msg_count

Line 234: x_return_status := okl_api.handle_exceptions(l_api_name

230: ,x_msg_count
231: ,x_msg_data
232: ,'_Pub');
233: WHEN okl_api.g_exception_unexpected_error THEN
234: x_return_status := okl_api.handle_exceptions(l_api_name
235: ,g_pkg_name
236: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
237: ,x_msg_count
238: ,x_msg_data

Line 236: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

232: ,'_Pub');
233: WHEN okl_api.g_exception_unexpected_error THEN
234: x_return_status := okl_api.handle_exceptions(l_api_name
235: ,g_pkg_name
236: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
237: ,x_msg_count
238: ,x_msg_data
239: ,'_Pub');
240: WHEN OTHERS THEN

Line 241: x_return_status := okl_api.handle_exceptions(l_api_name

237: ,x_msg_count
238: ,x_msg_data
239: ,'_Pub');
240: WHEN OTHERS THEN
241: x_return_status := okl_api.handle_exceptions(l_api_name
242: ,g_pkg_name
243: ,'OTHERS'
244: ,x_msg_count
245: ,x_msg_data

Line 252: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

248:
249: --procedure to create a Standard Rate Template with the associated Eligibility Criteria
250:
251: PROCEDURE insert_srt(p_api_version IN NUMBER
252: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
253: ,x_return_status OUT NOCOPY VARCHAR2
254: ,x_msg_count OUT NOCOPY NUMBER
255: ,x_msg_data OUT NOCOPY VARCHAR2
256: ,p_srtv_rec IN okl_srtv_rec

Line 262: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;

258: ,x_srtv_rec OUT NOCOPY okl_srtv_rec
259: ,x_srv_rec OUT NOCOPY okl_srv_rec) AS
260: l_api_version NUMBER := 1.0;
261: l_api_name VARCHAR2(40) := 'insert_srt';
262: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
263:
264: BEGIN
265: l_return_status := okl_api.start_activity(l_api_name
266: ,g_pkg_name

Line 265: l_return_status := okl_api.start_activity(l_api_name

261: l_api_name VARCHAR2(40) := 'insert_srt';
262: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
263:
264: BEGIN
265: l_return_status := okl_api.start_activity(l_api_name
266: ,g_pkg_name
267: ,p_init_msg_list
268: ,l_api_version
269: ,p_api_version

Line 273: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

269: ,p_api_version
270: ,'_PUB'
271: ,x_return_status);
272:
273: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
274: RAISE okl_api.g_exception_unexpected_error;
275: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
276: RAISE okl_api.g_exception_error;
277: END IF;

Line 274: RAISE okl_api.g_exception_unexpected_error;

270: ,'_PUB'
271: ,x_return_status);
272:
273: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
274: RAISE okl_api.g_exception_unexpected_error;
275: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
276: RAISE okl_api.g_exception_error;
277: END IF;
278: okl_fe_std_rate_tmpl_pvt.insert_srt(l_api_version

Line 275: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

271: ,x_return_status);
272:
273: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
274: RAISE okl_api.g_exception_unexpected_error;
275: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
276: RAISE okl_api.g_exception_error;
277: END IF;
278: okl_fe_std_rate_tmpl_pvt.insert_srt(l_api_version
279: ,p_init_msg_list

Line 276: RAISE okl_api.g_exception_error;

272:
273: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
274: RAISE okl_api.g_exception_unexpected_error;
275: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
276: RAISE okl_api.g_exception_error;
277: END IF;
278: okl_fe_std_rate_tmpl_pvt.insert_srt(l_api_version
279: ,p_init_msg_list
280: ,l_return_status

Line 288: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

284: ,p_srv_rec
285: ,x_srtv_rec
286: ,x_srv_rec);
287:
288: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
289: RAISE okl_api.g_exception_unexpected_error;
290: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
291: RAISE okl_api.g_exception_error;
292: END IF;

Line 289: RAISE okl_api.g_exception_unexpected_error;

285: ,x_srtv_rec
286: ,x_srv_rec);
287:
288: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
289: RAISE okl_api.g_exception_unexpected_error;
290: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
291: RAISE okl_api.g_exception_error;
292: END IF;
293:

Line 290: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

286: ,x_srv_rec);
287:
288: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
289: RAISE okl_api.g_exception_unexpected_error;
290: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
291: RAISE okl_api.g_exception_error;
292: END IF;
293:
294: --end activity

Line 291: RAISE okl_api.g_exception_error;

287:
288: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
289: RAISE okl_api.g_exception_unexpected_error;
290: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
291: RAISE okl_api.g_exception_error;
292: END IF;
293:
294: --end activity
295:

Line 296: okl_api.end_activity(x_msg_count

292: END IF;
293:
294: --end activity
295:
296: okl_api.end_activity(x_msg_count
297: ,x_msg_data);
298: x_return_status := l_return_status;
299: EXCEPTION
300: WHEN okl_api.g_exception_error THEN

Line 300: WHEN okl_api.g_exception_error THEN

296: okl_api.end_activity(x_msg_count
297: ,x_msg_data);
298: x_return_status := l_return_status;
299: EXCEPTION
300: WHEN okl_api.g_exception_error THEN
301: x_return_status := okl_api.handle_exceptions(l_api_name
302: ,g_pkg_name
303: ,'OKL_API.G_RET_STS_ERROR'
304: ,x_msg_count

Line 301: x_return_status := okl_api.handle_exceptions(l_api_name

297: ,x_msg_data);
298: x_return_status := l_return_status;
299: EXCEPTION
300: WHEN okl_api.g_exception_error THEN
301: x_return_status := okl_api.handle_exceptions(l_api_name
302: ,g_pkg_name
303: ,'OKL_API.G_RET_STS_ERROR'
304: ,x_msg_count
305: ,x_msg_data

Line 303: ,'OKL_API.G_RET_STS_ERROR'

299: EXCEPTION
300: WHEN okl_api.g_exception_error THEN
301: x_return_status := okl_api.handle_exceptions(l_api_name
302: ,g_pkg_name
303: ,'OKL_API.G_RET_STS_ERROR'
304: ,x_msg_count
305: ,x_msg_data
306: ,'_PUB');
307: WHEN okl_api.g_exception_unexpected_error THEN

Line 307: WHEN okl_api.g_exception_unexpected_error THEN

303: ,'OKL_API.G_RET_STS_ERROR'
304: ,x_msg_count
305: ,x_msg_data
306: ,'_PUB');
307: WHEN okl_api.g_exception_unexpected_error THEN
308: x_return_status := okl_api.handle_exceptions(l_api_name
309: ,g_pkg_name
310: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
311: ,x_msg_count

Line 308: x_return_status := okl_api.handle_exceptions(l_api_name

304: ,x_msg_count
305: ,x_msg_data
306: ,'_PUB');
307: WHEN okl_api.g_exception_unexpected_error THEN
308: x_return_status := okl_api.handle_exceptions(l_api_name
309: ,g_pkg_name
310: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
311: ,x_msg_count
312: ,x_msg_data

Line 310: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

306: ,'_PUB');
307: WHEN okl_api.g_exception_unexpected_error THEN
308: x_return_status := okl_api.handle_exceptions(l_api_name
309: ,g_pkg_name
310: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
311: ,x_msg_count
312: ,x_msg_data
313: ,'_PUB');
314: WHEN OTHERS THEN

Line 315: x_return_status := okl_api.handle_exceptions(l_api_name

311: ,x_msg_count
312: ,x_msg_data
313: ,'_PUB');
314: WHEN OTHERS THEN
315: x_return_status := okl_api.handle_exceptions(l_api_name
316: ,g_pkg_name
317: ,'OTHERS'
318: ,x_msg_count
319: ,x_msg_data

Line 326: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

322:
323: -- procedure to update a particular version of the Standard Rate Template
324:
325: PROCEDURE update_srt(p_api_version IN NUMBER
326: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
327: ,x_return_status OUT NOCOPY VARCHAR2
328: ,x_msg_count OUT NOCOPY NUMBER
329: ,x_msg_data OUT NOCOPY VARCHAR2
330: ,p_srv_rec IN okl_srv_rec

Line 334: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;

330: ,p_srv_rec IN okl_srv_rec
331: ,x_srv_rec OUT NOCOPY okl_srv_rec) AS
332: l_api_version NUMBER := 1.0;
333: l_api_name VARCHAR2(40) := 'update_srt';
334: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
335:
336: BEGIN
337: l_return_status := okl_api.start_activity(l_api_name
338: ,g_pkg_name

Line 337: l_return_status := okl_api.start_activity(l_api_name

333: l_api_name VARCHAR2(40) := 'update_srt';
334: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
335:
336: BEGIN
337: l_return_status := okl_api.start_activity(l_api_name
338: ,g_pkg_name
339: ,p_init_msg_list
340: ,l_api_version
341: ,p_api_version

Line 345: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

341: ,p_api_version
342: ,'_Pub'
343: ,l_return_status);
344:
345: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
346: RAISE okl_api.g_exception_unexpected_error;
347: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
348: RAISE okl_api.g_exception_error;
349: END IF;

Line 346: RAISE okl_api.g_exception_unexpected_error;

342: ,'_Pub'
343: ,l_return_status);
344:
345: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
346: RAISE okl_api.g_exception_unexpected_error;
347: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
348: RAISE okl_api.g_exception_error;
349: END IF;
350:

Line 347: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

343: ,l_return_status);
344:
345: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
346: RAISE okl_api.g_exception_unexpected_error;
347: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
348: RAISE okl_api.g_exception_error;
349: END IF;
350:
351: okl_fe_std_rate_tmpl_pvt.update_srt(l_api_version

Line 348: RAISE okl_api.g_exception_error;

344:
345: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
346: RAISE okl_api.g_exception_unexpected_error;
347: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
348: RAISE okl_api.g_exception_error;
349: END IF;
350:
351: okl_fe_std_rate_tmpl_pvt.update_srt(l_api_version
352: ,p_init_msg_list

Line 359: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

355: ,x_msg_data
356: ,p_srv_rec
357: ,x_srv_rec);
358:
359: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
360: RAISE okl_api.g_exception_unexpected_error;
361: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
362: RAISE okl_api.g_exception_error;
363: END IF;

Line 360: RAISE okl_api.g_exception_unexpected_error;

356: ,p_srv_rec
357: ,x_srv_rec);
358:
359: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
360: RAISE okl_api.g_exception_unexpected_error;
361: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
362: RAISE okl_api.g_exception_error;
363: END IF;
364:

Line 361: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

357: ,x_srv_rec);
358:
359: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
360: RAISE okl_api.g_exception_unexpected_error;
361: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
362: RAISE okl_api.g_exception_error;
363: END IF;
364:
365: --end activity

Line 362: RAISE okl_api.g_exception_error;

358:
359: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
360: RAISE okl_api.g_exception_unexpected_error;
361: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
362: RAISE okl_api.g_exception_error;
363: END IF;
364:
365: --end activity
366:

Line 367: okl_api.end_activity(x_msg_count

363: END IF;
364:
365: --end activity
366:
367: okl_api.end_activity(x_msg_count
368: ,x_msg_data);
369: x_return_status := l_return_status;
370: EXCEPTION
371: WHEN okl_api.g_exception_error THEN

Line 371: WHEN okl_api.g_exception_error THEN

367: okl_api.end_activity(x_msg_count
368: ,x_msg_data);
369: x_return_status := l_return_status;
370: EXCEPTION
371: WHEN okl_api.g_exception_error THEN
372: x_return_status := okl_api.handle_exceptions(l_api_name
373: ,g_pkg_name
374: ,'OKL_API.G_RET_STS_ERROR'
375: ,x_msg_count

Line 372: x_return_status := okl_api.handle_exceptions(l_api_name

368: ,x_msg_data);
369: x_return_status := l_return_status;
370: EXCEPTION
371: WHEN okl_api.g_exception_error THEN
372: x_return_status := okl_api.handle_exceptions(l_api_name
373: ,g_pkg_name
374: ,'OKL_API.G_RET_STS_ERROR'
375: ,x_msg_count
376: ,x_msg_data

Line 374: ,'OKL_API.G_RET_STS_ERROR'

370: EXCEPTION
371: WHEN okl_api.g_exception_error THEN
372: x_return_status := okl_api.handle_exceptions(l_api_name
373: ,g_pkg_name
374: ,'OKL_API.G_RET_STS_ERROR'
375: ,x_msg_count
376: ,x_msg_data
377: ,'_Pub');
378: WHEN okl_api.g_exception_unexpected_error THEN

Line 378: WHEN okl_api.g_exception_unexpected_error THEN

374: ,'OKL_API.G_RET_STS_ERROR'
375: ,x_msg_count
376: ,x_msg_data
377: ,'_Pub');
378: WHEN okl_api.g_exception_unexpected_error THEN
379: x_return_status := okl_api.handle_exceptions(l_api_name
380: ,g_pkg_name
381: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
382: ,x_msg_count

Line 379: x_return_status := okl_api.handle_exceptions(l_api_name

375: ,x_msg_count
376: ,x_msg_data
377: ,'_Pub');
378: WHEN okl_api.g_exception_unexpected_error THEN
379: x_return_status := okl_api.handle_exceptions(l_api_name
380: ,g_pkg_name
381: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
382: ,x_msg_count
383: ,x_msg_data

Line 381: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

377: ,'_Pub');
378: WHEN okl_api.g_exception_unexpected_error THEN
379: x_return_status := okl_api.handle_exceptions(l_api_name
380: ,g_pkg_name
381: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
382: ,x_msg_count
383: ,x_msg_data
384: ,'_Pub');
385: WHEN OTHERS THEN

Line 386: x_return_status := okl_api.handle_exceptions(l_api_name

382: ,x_msg_count
383: ,x_msg_data
384: ,'_Pub');
385: WHEN OTHERS THEN
386: x_return_status := okl_api.handle_exceptions(l_api_name
387: ,g_pkg_name
388: ,'OTHERS'
389: ,x_msg_count
390: ,x_msg_data

Line 397: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

393:
394: -- procedure to raise the workflow which submits the record and changes the status.
395:
396: PROCEDURE submit_srt(p_api_version IN NUMBER
397: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
398: ,x_return_status OUT NOCOPY VARCHAR2
399: ,x_msg_count OUT NOCOPY NUMBER
400: ,x_msg_data OUT NOCOPY VARCHAR2
401: ,p_version_id IN NUMBER) AS

Line 404: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;

400: ,x_msg_data OUT NOCOPY VARCHAR2
401: ,p_version_id IN NUMBER) AS
402: l_api_version NUMBER := 1.0;
403: l_api_name VARCHAR2(40) := 'submit_srt';
404: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
405:
406: BEGIN
407: l_return_status := okl_api.start_activity(l_api_name
408: ,g_pkg_name

Line 407: l_return_status := okl_api.start_activity(l_api_name

403: l_api_name VARCHAR2(40) := 'submit_srt';
404: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
405:
406: BEGIN
407: l_return_status := okl_api.start_activity(l_api_name
408: ,g_pkg_name
409: ,p_init_msg_list
410: ,l_api_version
411: ,p_api_version

Line 415: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

411: ,p_api_version
412: ,'_Pub'
413: ,x_return_status);
414:
415: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
416: RAISE okl_api.g_exception_unexpected_error;
417: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
418: RAISE okl_api.g_exception_error;
419: END IF;

Line 416: RAISE okl_api.g_exception_unexpected_error;

412: ,'_Pub'
413: ,x_return_status);
414:
415: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
416: RAISE okl_api.g_exception_unexpected_error;
417: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
418: RAISE okl_api.g_exception_error;
419: END IF;
420: okl_fe_std_rate_tmpl_pvt.submit_srt(l_api_version

Line 417: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

413: ,x_return_status);
414:
415: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
416: RAISE okl_api.g_exception_unexpected_error;
417: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
418: RAISE okl_api.g_exception_error;
419: END IF;
420: okl_fe_std_rate_tmpl_pvt.submit_srt(l_api_version
421: ,p_init_msg_list

Line 418: RAISE okl_api.g_exception_error;

414:
415: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
416: RAISE okl_api.g_exception_unexpected_error;
417: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
418: RAISE okl_api.g_exception_error;
419: END IF;
420: okl_fe_std_rate_tmpl_pvt.submit_srt(l_api_version
421: ,p_init_msg_list
422: ,l_return_status

Line 427: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

423: ,x_msg_count
424: ,x_msg_data
425: ,p_version_id);
426:
427: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
428: RAISE okl_api.g_exception_unexpected_error;
429: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
430: RAISE okl_api.g_exception_error;
431: END IF;

Line 428: RAISE okl_api.g_exception_unexpected_error;

424: ,x_msg_data
425: ,p_version_id);
426:
427: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
428: RAISE okl_api.g_exception_unexpected_error;
429: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
430: RAISE okl_api.g_exception_error;
431: END IF;
432:

Line 429: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

425: ,p_version_id);
426:
427: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
428: RAISE okl_api.g_exception_unexpected_error;
429: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
430: RAISE okl_api.g_exception_error;
431: END IF;
432:
433: --end activity

Line 430: RAISE okl_api.g_exception_error;

426:
427: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
428: RAISE okl_api.g_exception_unexpected_error;
429: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
430: RAISE okl_api.g_exception_error;
431: END IF;
432:
433: --end activity
434:

Line 435: okl_api.end_activity(x_msg_count

431: END IF;
432:
433: --end activity
434:
435: okl_api.end_activity(x_msg_count
436: ,x_msg_data);
437: x_return_status := l_return_status;
438: EXCEPTION
439: WHEN okl_api.g_exception_error THEN

Line 439: WHEN okl_api.g_exception_error THEN

435: okl_api.end_activity(x_msg_count
436: ,x_msg_data);
437: x_return_status := l_return_status;
438: EXCEPTION
439: WHEN okl_api.g_exception_error THEN
440: x_return_status := okl_api.handle_exceptions(l_api_name
441: ,g_pkg_name
442: ,'OKL_API.G_RET_STS_ERROR'
443: ,x_msg_count

Line 440: x_return_status := okl_api.handle_exceptions(l_api_name

436: ,x_msg_data);
437: x_return_status := l_return_status;
438: EXCEPTION
439: WHEN okl_api.g_exception_error THEN
440: x_return_status := okl_api.handle_exceptions(l_api_name
441: ,g_pkg_name
442: ,'OKL_API.G_RET_STS_ERROR'
443: ,x_msg_count
444: ,x_msg_data

Line 442: ,'OKL_API.G_RET_STS_ERROR'

438: EXCEPTION
439: WHEN okl_api.g_exception_error THEN
440: x_return_status := okl_api.handle_exceptions(l_api_name
441: ,g_pkg_name
442: ,'OKL_API.G_RET_STS_ERROR'
443: ,x_msg_count
444: ,x_msg_data
445: ,'_Pub');
446: WHEN okl_api.g_exception_unexpected_error THEN

Line 446: WHEN okl_api.g_exception_unexpected_error THEN

442: ,'OKL_API.G_RET_STS_ERROR'
443: ,x_msg_count
444: ,x_msg_data
445: ,'_Pub');
446: WHEN okl_api.g_exception_unexpected_error THEN
447: x_return_status := okl_api.handle_exceptions(l_api_name
448: ,g_pkg_name
449: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
450: ,x_msg_count

Line 447: x_return_status := okl_api.handle_exceptions(l_api_name

443: ,x_msg_count
444: ,x_msg_data
445: ,'_Pub');
446: WHEN okl_api.g_exception_unexpected_error THEN
447: x_return_status := okl_api.handle_exceptions(l_api_name
448: ,g_pkg_name
449: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
450: ,x_msg_count
451: ,x_msg_data

Line 449: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

445: ,'_Pub');
446: WHEN okl_api.g_exception_unexpected_error THEN
447: x_return_status := okl_api.handle_exceptions(l_api_name
448: ,g_pkg_name
449: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
450: ,x_msg_count
451: ,x_msg_data
452: ,'_Pub');
453: WHEN OTHERS THEN

Line 454: x_return_status := okl_api.handle_exceptions(l_api_name

450: ,x_msg_count
451: ,x_msg_data
452: ,'_Pub');
453: WHEN OTHERS THEN
454: x_return_status := okl_api.handle_exceptions(l_api_name
455: ,g_pkg_name
456: ,'OTHERS'
457: ,x_msg_count
458: ,x_msg_data

Line 465: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

461:
462: -- procedure to handle when the process is going through the process of approval
463:
464: PROCEDURE handle_approval(p_api_version IN NUMBER
465: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
466: ,x_return_status OUT NOCOPY VARCHAR2
467: ,x_msg_count OUT NOCOPY NUMBER
468: ,x_msg_data OUT NOCOPY VARCHAR2
469: ,p_version_id IN NUMBER) AS

Line 472: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;

468: ,x_msg_data OUT NOCOPY VARCHAR2
469: ,p_version_id IN NUMBER) AS
470: l_api_version NUMBER := 1.0;
471: l_api_name VARCHAR2(40) := 'handle_approval';
472: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
473:
474: BEGIN
475: l_return_status := okl_api.start_activity(l_api_name
476: ,g_pkg_name

Line 475: l_return_status := okl_api.start_activity(l_api_name

471: l_api_name VARCHAR2(40) := 'handle_approval';
472: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
473:
474: BEGIN
475: l_return_status := okl_api.start_activity(l_api_name
476: ,g_pkg_name
477: ,p_init_msg_list
478: ,l_api_version
479: ,p_api_version

Line 483: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

479: ,p_api_version
480: ,'_Pub'
481: ,x_return_status);
482:
483: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
484: RAISE okl_api.g_exception_unexpected_error;
485: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
486: RAISE okl_api.g_exception_error;
487: END IF;

Line 484: RAISE okl_api.g_exception_unexpected_error;

480: ,'_Pub'
481: ,x_return_status);
482:
483: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
484: RAISE okl_api.g_exception_unexpected_error;
485: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
486: RAISE okl_api.g_exception_error;
487: END IF;
488: okl_fe_std_rate_tmpl_pvt.handle_approval(p_api_version

Line 485: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

481: ,x_return_status);
482:
483: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
484: RAISE okl_api.g_exception_unexpected_error;
485: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
486: RAISE okl_api.g_exception_error;
487: END IF;
488: okl_fe_std_rate_tmpl_pvt.handle_approval(p_api_version
489: ,p_init_msg_list

Line 486: RAISE okl_api.g_exception_error;

482:
483: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
484: RAISE okl_api.g_exception_unexpected_error;
485: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
486: RAISE okl_api.g_exception_error;
487: END IF;
488: okl_fe_std_rate_tmpl_pvt.handle_approval(p_api_version
489: ,p_init_msg_list
490: ,l_return_status

Line 495: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

491: ,x_msg_count
492: ,x_msg_data
493: ,p_version_id);
494:
495: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
496: RAISE okl_api.g_exception_unexpected_error;
497: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
498: RAISE okl_api.g_exception_error;
499: END IF;

Line 496: RAISE okl_api.g_exception_unexpected_error;

492: ,x_msg_data
493: ,p_version_id);
494:
495: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
496: RAISE okl_api.g_exception_unexpected_error;
497: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
498: RAISE okl_api.g_exception_error;
499: END IF;
500:

Line 497: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

493: ,p_version_id);
494:
495: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
496: RAISE okl_api.g_exception_unexpected_error;
497: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
498: RAISE okl_api.g_exception_error;
499: END IF;
500:
501: --end activity

Line 498: RAISE okl_api.g_exception_error;

494:
495: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
496: RAISE okl_api.g_exception_unexpected_error;
497: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
498: RAISE okl_api.g_exception_error;
499: END IF;
500:
501: --end activity
502:

Line 503: okl_api.end_activity(x_msg_count

499: END IF;
500:
501: --end activity
502:
503: okl_api.end_activity(x_msg_count
504: ,x_msg_data);
505: x_return_status := l_return_status;
506: EXCEPTION
507: WHEN okl_api.g_exception_error THEN

Line 507: WHEN okl_api.g_exception_error THEN

503: okl_api.end_activity(x_msg_count
504: ,x_msg_data);
505: x_return_status := l_return_status;
506: EXCEPTION
507: WHEN okl_api.g_exception_error THEN
508: x_return_status := okl_api.handle_exceptions(l_api_name
509: ,g_pkg_name
510: ,'OKL_API.G_RET_STS_ERROR'
511: ,x_msg_count

Line 508: x_return_status := okl_api.handle_exceptions(l_api_name

504: ,x_msg_data);
505: x_return_status := l_return_status;
506: EXCEPTION
507: WHEN okl_api.g_exception_error THEN
508: x_return_status := okl_api.handle_exceptions(l_api_name
509: ,g_pkg_name
510: ,'OKL_API.G_RET_STS_ERROR'
511: ,x_msg_count
512: ,x_msg_data

Line 510: ,'OKL_API.G_RET_STS_ERROR'

506: EXCEPTION
507: WHEN okl_api.g_exception_error THEN
508: x_return_status := okl_api.handle_exceptions(l_api_name
509: ,g_pkg_name
510: ,'OKL_API.G_RET_STS_ERROR'
511: ,x_msg_count
512: ,x_msg_data
513: ,'_Pub');
514: WHEN okl_api.g_exception_unexpected_error THEN

Line 514: WHEN okl_api.g_exception_unexpected_error THEN

510: ,'OKL_API.G_RET_STS_ERROR'
511: ,x_msg_count
512: ,x_msg_data
513: ,'_Pub');
514: WHEN okl_api.g_exception_unexpected_error THEN
515: x_return_status := okl_api.handle_exceptions(l_api_name
516: ,g_pkg_name
517: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
518: ,x_msg_count

Line 515: x_return_status := okl_api.handle_exceptions(l_api_name

511: ,x_msg_count
512: ,x_msg_data
513: ,'_Pub');
514: WHEN okl_api.g_exception_unexpected_error THEN
515: x_return_status := okl_api.handle_exceptions(l_api_name
516: ,g_pkg_name
517: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
518: ,x_msg_count
519: ,x_msg_data

Line 517: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

513: ,'_Pub');
514: WHEN okl_api.g_exception_unexpected_error THEN
515: x_return_status := okl_api.handle_exceptions(l_api_name
516: ,g_pkg_name
517: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
518: ,x_msg_count
519: ,x_msg_data
520: ,'_Pub');
521: WHEN OTHERS THEN

Line 522: x_return_status := okl_api.handle_exceptions(l_api_name

518: ,x_msg_count
519: ,x_msg_data
520: ,'_Pub');
521: WHEN OTHERS THEN
522: x_return_status := okl_api.handle_exceptions(l_api_name
523: ,g_pkg_name
524: ,'OTHERS'
525: ,x_msg_count
526: ,x_msg_data

Line 533: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

529:
530: -- to find the list of all the invalid object refernces
531:
532: PROCEDURE invalid_objects(p_api_version IN NUMBER
533: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
534: ,x_return_status OUT NOCOPY VARCHAR2
535: ,x_msg_count OUT NOCOPY NUMBER
536: ,x_msg_data OUT NOCOPY VARCHAR2
537: ,p_version_id IN NUMBER

Line 541: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;

537: ,p_version_id IN NUMBER
538: ,x_obj_tbl OUT NOCOPY invalid_object_tbl) AS
539: l_api_version NUMBER := 1.0;
540: l_api_name VARCHAR2(40) := 'invalid_objects';
541: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
542:
543: BEGIN
544: l_return_status := okl_api.start_activity(l_api_name
545: ,g_pkg_name

Line 544: l_return_status := okl_api.start_activity(l_api_name

540: l_api_name VARCHAR2(40) := 'invalid_objects';
541: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
542:
543: BEGIN
544: l_return_status := okl_api.start_activity(l_api_name
545: ,g_pkg_name
546: ,p_init_msg_list
547: ,l_api_version
548: ,p_api_version

Line 552: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

548: ,p_api_version
549: ,'_Pub'
550: ,x_return_status);
551:
552: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
553: RAISE okl_api.g_exception_unexpected_error;
554: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
555: RAISE okl_api.g_exception_error;
556: END IF;

Line 553: RAISE okl_api.g_exception_unexpected_error;

549: ,'_Pub'
550: ,x_return_status);
551:
552: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
553: RAISE okl_api.g_exception_unexpected_error;
554: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
555: RAISE okl_api.g_exception_error;
556: END IF;
557: okl_fe_std_rate_tmpl_pvt.invalid_objects(l_api_version

Line 554: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

550: ,x_return_status);
551:
552: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
553: RAISE okl_api.g_exception_unexpected_error;
554: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
555: RAISE okl_api.g_exception_error;
556: END IF;
557: okl_fe_std_rate_tmpl_pvt.invalid_objects(l_api_version
558: ,p_init_msg_list

Line 555: RAISE okl_api.g_exception_error;

551:
552: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
553: RAISE okl_api.g_exception_unexpected_error;
554: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
555: RAISE okl_api.g_exception_error;
556: END IF;
557: okl_fe_std_rate_tmpl_pvt.invalid_objects(l_api_version
558: ,p_init_msg_list
559: ,l_return_status

Line 565: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

561: ,x_msg_data
562: ,p_version_id
563: ,x_obj_tbl);
564:
565: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
566: RAISE okl_api.g_exception_unexpected_error;
567: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
568: RAISE okl_api.g_exception_error;
569: END IF;

Line 566: RAISE okl_api.g_exception_unexpected_error;

562: ,p_version_id
563: ,x_obj_tbl);
564:
565: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
566: RAISE okl_api.g_exception_unexpected_error;
567: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
568: RAISE okl_api.g_exception_error;
569: END IF;
570:

Line 567: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

563: ,x_obj_tbl);
564:
565: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
566: RAISE okl_api.g_exception_unexpected_error;
567: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
568: RAISE okl_api.g_exception_error;
569: END IF;
570:
571: --end activity

Line 568: RAISE okl_api.g_exception_error;

564:
565: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
566: RAISE okl_api.g_exception_unexpected_error;
567: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
568: RAISE okl_api.g_exception_error;
569: END IF;
570:
571: --end activity
572:

Line 573: okl_api.end_activity(x_msg_count

569: END IF;
570:
571: --end activity
572:
573: okl_api.end_activity(x_msg_count
574: ,x_msg_data);
575: x_return_status := l_return_status;
576: EXCEPTION
577: WHEN okl_api.g_exception_error THEN

Line 577: WHEN okl_api.g_exception_error THEN

573: okl_api.end_activity(x_msg_count
574: ,x_msg_data);
575: x_return_status := l_return_status;
576: EXCEPTION
577: WHEN okl_api.g_exception_error THEN
578: x_return_status := okl_api.handle_exceptions(l_api_name
579: ,g_pkg_name
580: ,'OKL_API.G_RET_STS_ERROR'
581: ,x_msg_count

Line 578: x_return_status := okl_api.handle_exceptions(l_api_name

574: ,x_msg_data);
575: x_return_status := l_return_status;
576: EXCEPTION
577: WHEN okl_api.g_exception_error THEN
578: x_return_status := okl_api.handle_exceptions(l_api_name
579: ,g_pkg_name
580: ,'OKL_API.G_RET_STS_ERROR'
581: ,x_msg_count
582: ,x_msg_data

Line 580: ,'OKL_API.G_RET_STS_ERROR'

576: EXCEPTION
577: WHEN okl_api.g_exception_error THEN
578: x_return_status := okl_api.handle_exceptions(l_api_name
579: ,g_pkg_name
580: ,'OKL_API.G_RET_STS_ERROR'
581: ,x_msg_count
582: ,x_msg_data
583: ,'_Pub');
584: WHEN okl_api.g_exception_unexpected_error THEN

Line 584: WHEN okl_api.g_exception_unexpected_error THEN

580: ,'OKL_API.G_RET_STS_ERROR'
581: ,x_msg_count
582: ,x_msg_data
583: ,'_Pub');
584: WHEN okl_api.g_exception_unexpected_error THEN
585: x_return_status := okl_api.handle_exceptions(l_api_name
586: ,g_pkg_name
587: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
588: ,x_msg_count

Line 585: x_return_status := okl_api.handle_exceptions(l_api_name

581: ,x_msg_count
582: ,x_msg_data
583: ,'_Pub');
584: WHEN okl_api.g_exception_unexpected_error THEN
585: x_return_status := okl_api.handle_exceptions(l_api_name
586: ,g_pkg_name
587: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
588: ,x_msg_count
589: ,x_msg_data

Line 587: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

583: ,'_Pub');
584: WHEN okl_api.g_exception_unexpected_error THEN
585: x_return_status := okl_api.handle_exceptions(l_api_name
586: ,g_pkg_name
587: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
588: ,x_msg_count
589: ,x_msg_data
590: ,'_Pub');
591: WHEN OTHERS THEN

Line 592: x_return_status := okl_api.handle_exceptions(l_api_name

588: ,x_msg_count
589: ,x_msg_data
590: ,'_Pub');
591: WHEN OTHERS THEN
592: x_return_status := okl_api.handle_exceptions(l_api_name
593: ,g_pkg_name
594: ,'OTHERS'
595: ,x_msg_count
596: ,x_msg_data

Line 603: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

599:
600: -- to calculate the start date of the new version
601:
602: PROCEDURE calc_start_date(p_api_version IN NUMBER
603: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
604: ,x_return_status OUT NOCOPY VARCHAR2
605: ,x_msg_count OUT NOCOPY NUMBER
606: ,x_msg_data OUT NOCOPY VARCHAR2
607: ,p_srv_rec IN okl_srv_rec

Line 612: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;

608: ,x_cal_eff_from OUT NOCOPY DATE) AS
609:
610: l_api_version NUMBER := 1.0;
611: l_api_name VARCHAR2(40) := 'calc_start_date';
612: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
613: l_srv_rec okl_srv_rec := p_srv_rec;
614:
615: BEGIN
616: l_return_status := okl_api.start_activity(l_api_name

Line 616: l_return_status := okl_api.start_activity(l_api_name

612: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
613: l_srv_rec okl_srv_rec := p_srv_rec;
614:
615: BEGIN
616: l_return_status := okl_api.start_activity(l_api_name
617: ,g_pkg_name
618: ,p_init_msg_list
619: ,l_api_version
620: ,p_api_version

Line 624: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

620: ,p_api_version
621: ,'_Pub'
622: ,x_return_status);
623:
624: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
625: RAISE okl_api.g_exception_unexpected_error;
626: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
627: RAISE okl_api.g_exception_error;
628: END IF;

Line 625: RAISE okl_api.g_exception_unexpected_error;

621: ,'_Pub'
622: ,x_return_status);
623:
624: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
625: RAISE okl_api.g_exception_unexpected_error;
626: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
627: RAISE okl_api.g_exception_error;
628: END IF;
629: okl_fe_std_rate_tmpl_pvt.calc_start_date(l_api_version

Line 626: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

622: ,x_return_status);
623:
624: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
625: RAISE okl_api.g_exception_unexpected_error;
626: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
627: RAISE okl_api.g_exception_error;
628: END IF;
629: okl_fe_std_rate_tmpl_pvt.calc_start_date(l_api_version
630: ,p_init_msg_list

Line 627: RAISE okl_api.g_exception_error;

623:
624: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
625: RAISE okl_api.g_exception_unexpected_error;
626: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
627: RAISE okl_api.g_exception_error;
628: END IF;
629: okl_fe_std_rate_tmpl_pvt.calc_start_date(l_api_version
630: ,p_init_msg_list
631: ,l_return_status

Line 637: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

633: ,x_msg_data
634: ,l_srv_rec
635: ,x_cal_eff_from);
636:
637: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
638: RAISE okl_api.g_exception_unexpected_error;
639: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
640: RAISE okl_api.g_exception_error;
641: END IF;

Line 638: RAISE okl_api.g_exception_unexpected_error;

634: ,l_srv_rec
635: ,x_cal_eff_from);
636:
637: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
638: RAISE okl_api.g_exception_unexpected_error;
639: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
640: RAISE okl_api.g_exception_error;
641: END IF;
642:

Line 639: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

635: ,x_cal_eff_from);
636:
637: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
638: RAISE okl_api.g_exception_unexpected_error;
639: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
640: RAISE okl_api.g_exception_error;
641: END IF;
642:
643: --end activity

Line 640: RAISE okl_api.g_exception_error;

636:
637: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
638: RAISE okl_api.g_exception_unexpected_error;
639: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
640: RAISE okl_api.g_exception_error;
641: END IF;
642:
643: --end activity
644:

Line 645: okl_api.end_activity(x_msg_count

641: END IF;
642:
643: --end activity
644:
645: okl_api.end_activity(x_msg_count
646: ,x_msg_data);
647: x_return_status := l_return_status;
648: EXCEPTION
649: WHEN okl_api.g_exception_error THEN

Line 649: WHEN okl_api.g_exception_error THEN

645: okl_api.end_activity(x_msg_count
646: ,x_msg_data);
647: x_return_status := l_return_status;
648: EXCEPTION
649: WHEN okl_api.g_exception_error THEN
650: x_return_status := okl_api.handle_exceptions(l_api_name
651: ,g_pkg_name
652: ,'OKL_API.G_RET_STS_ERROR'
653: ,x_msg_count

Line 650: x_return_status := okl_api.handle_exceptions(l_api_name

646: ,x_msg_data);
647: x_return_status := l_return_status;
648: EXCEPTION
649: WHEN okl_api.g_exception_error THEN
650: x_return_status := okl_api.handle_exceptions(l_api_name
651: ,g_pkg_name
652: ,'OKL_API.G_RET_STS_ERROR'
653: ,x_msg_count
654: ,x_msg_data

Line 652: ,'OKL_API.G_RET_STS_ERROR'

648: EXCEPTION
649: WHEN okl_api.g_exception_error THEN
650: x_return_status := okl_api.handle_exceptions(l_api_name
651: ,g_pkg_name
652: ,'OKL_API.G_RET_STS_ERROR'
653: ,x_msg_count
654: ,x_msg_data
655: ,'_Pub');
656: WHEN okl_api.g_exception_unexpected_error THEN

Line 656: WHEN okl_api.g_exception_unexpected_error THEN

652: ,'OKL_API.G_RET_STS_ERROR'
653: ,x_msg_count
654: ,x_msg_data
655: ,'_Pub');
656: WHEN okl_api.g_exception_unexpected_error THEN
657: x_return_status := okl_api.handle_exceptions(l_api_name
658: ,g_pkg_name
659: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
660: ,x_msg_count

Line 657: x_return_status := okl_api.handle_exceptions(l_api_name

653: ,x_msg_count
654: ,x_msg_data
655: ,'_Pub');
656: WHEN okl_api.g_exception_unexpected_error THEN
657: x_return_status := okl_api.handle_exceptions(l_api_name
658: ,g_pkg_name
659: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
660: ,x_msg_count
661: ,x_msg_data

Line 659: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

655: ,'_Pub');
656: WHEN okl_api.g_exception_unexpected_error THEN
657: x_return_status := okl_api.handle_exceptions(l_api_name
658: ,g_pkg_name
659: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
660: ,x_msg_count
661: ,x_msg_data
662: ,'_Pub');
663: WHEN OTHERS THEN

Line 664: x_return_status := okl_api.handle_exceptions(l_api_name

660: ,x_msg_count
661: ,x_msg_data
662: ,'_Pub');
663: WHEN OTHERS THEN
664: x_return_status := okl_api.handle_exceptions(l_api_name
665: ,g_pkg_name
666: ,'OTHERS'
667: ,x_msg_count
668: ,x_msg_data

Line 675: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

671:
672: -- procedure to set the default Standard Rate Template
673:
674: PROCEDURE update_default(p_api_version IN NUMBER
675: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
676: ,x_return_status OUT NOCOPY VARCHAR2
677: ,x_msg_count OUT NOCOPY NUMBER
678: ,x_msg_data OUT NOCOPY VARCHAR2
679: ,p_srt_id IN NUMBER) AS

Line 683: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;

679: ,p_srt_id IN NUMBER) AS
680: l_api_version NUMBER := 1.0;
681: l_api_name VARCHAR2(40) := 'update_default';
682: l_init_msg_list VARCHAR2(1) := p_init_msg_list;
683: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
684:
685: BEGIN
686: l_return_status := okl_api.start_activity(l_api_name
687: ,g_pkg_name

Line 686: l_return_status := okl_api.start_activity(l_api_name

682: l_init_msg_list VARCHAR2(1) := p_init_msg_list;
683: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
684:
685: BEGIN
686: l_return_status := okl_api.start_activity(l_api_name
687: ,g_pkg_name
688: ,l_init_msg_list
689: ,l_api_version
690: ,p_api_version

Line 694: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

690: ,p_api_version
691: ,'_Pub'
692: ,x_return_status);
693:
694: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
695: RAISE okl_api.g_exception_unexpected_error;
696: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
697: RAISE okl_api.g_exception_error;
698: END IF;

Line 695: RAISE okl_api.g_exception_unexpected_error;

691: ,'_Pub'
692: ,x_return_status);
693:
694: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
695: RAISE okl_api.g_exception_unexpected_error;
696: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
697: RAISE okl_api.g_exception_error;
698: END IF;
699: okl_fe_std_rate_tmpl_pvt.update_default(l_api_version

Line 696: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

692: ,x_return_status);
693:
694: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
695: RAISE okl_api.g_exception_unexpected_error;
696: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
697: RAISE okl_api.g_exception_error;
698: END IF;
699: okl_fe_std_rate_tmpl_pvt.update_default(l_api_version
700: ,l_init_msg_list

Line 697: RAISE okl_api.g_exception_error;

693:
694: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
695: RAISE okl_api.g_exception_unexpected_error;
696: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
697: RAISE okl_api.g_exception_error;
698: END IF;
699: okl_fe_std_rate_tmpl_pvt.update_default(l_api_version
700: ,l_init_msg_list
701: ,l_return_status

Line 706: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

702: ,x_msg_count
703: ,x_msg_data
704: ,p_srt_id);
705:
706: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
707: RAISE okl_api.g_exception_unexpected_error;
708: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
709: RAISE okl_api.g_exception_error;
710: END IF;

Line 707: RAISE okl_api.g_exception_unexpected_error;

703: ,x_msg_data
704: ,p_srt_id);
705:
706: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
707: RAISE okl_api.g_exception_unexpected_error;
708: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
709: RAISE okl_api.g_exception_error;
710: END IF;
711:

Line 708: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

704: ,p_srt_id);
705:
706: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
707: RAISE okl_api.g_exception_unexpected_error;
708: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
709: RAISE okl_api.g_exception_error;
710: END IF;
711:
712: --end activity

Line 709: RAISE okl_api.g_exception_error;

705:
706: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
707: RAISE okl_api.g_exception_unexpected_error;
708: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
709: RAISE okl_api.g_exception_error;
710: END IF;
711:
712: --end activity
713:

Line 714: okl_api.end_activity(x_msg_count

710: END IF;
711:
712: --end activity
713:
714: okl_api.end_activity(x_msg_count
715: ,x_msg_data);
716: x_return_status := l_return_status;
717: EXCEPTION
718: WHEN okl_api.g_exception_error THEN

Line 718: WHEN okl_api.g_exception_error THEN

714: okl_api.end_activity(x_msg_count
715: ,x_msg_data);
716: x_return_status := l_return_status;
717: EXCEPTION
718: WHEN okl_api.g_exception_error THEN
719: x_return_status := okl_api.handle_exceptions(l_api_name
720: ,g_pkg_name
721: ,'OKL_API.G_RET_STS_ERROR'
722: ,x_msg_count

Line 719: x_return_status := okl_api.handle_exceptions(l_api_name

715: ,x_msg_data);
716: x_return_status := l_return_status;
717: EXCEPTION
718: WHEN okl_api.g_exception_error THEN
719: x_return_status := okl_api.handle_exceptions(l_api_name
720: ,g_pkg_name
721: ,'OKL_API.G_RET_STS_ERROR'
722: ,x_msg_count
723: ,x_msg_data

Line 721: ,'OKL_API.G_RET_STS_ERROR'

717: EXCEPTION
718: WHEN okl_api.g_exception_error THEN
719: x_return_status := okl_api.handle_exceptions(l_api_name
720: ,g_pkg_name
721: ,'OKL_API.G_RET_STS_ERROR'
722: ,x_msg_count
723: ,x_msg_data
724: ,'_Pub');
725: WHEN okl_api.g_exception_unexpected_error THEN

Line 725: WHEN okl_api.g_exception_unexpected_error THEN

721: ,'OKL_API.G_RET_STS_ERROR'
722: ,x_msg_count
723: ,x_msg_data
724: ,'_Pub');
725: WHEN okl_api.g_exception_unexpected_error THEN
726: x_return_status := okl_api.handle_exceptions(l_api_name
727: ,g_pkg_name
728: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
729: ,x_msg_count

Line 726: x_return_status := okl_api.handle_exceptions(l_api_name

722: ,x_msg_count
723: ,x_msg_data
724: ,'_Pub');
725: WHEN okl_api.g_exception_unexpected_error THEN
726: x_return_status := okl_api.handle_exceptions(l_api_name
727: ,g_pkg_name
728: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
729: ,x_msg_count
730: ,x_msg_data

Line 728: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

724: ,'_Pub');
725: WHEN okl_api.g_exception_unexpected_error THEN
726: x_return_status := okl_api.handle_exceptions(l_api_name
727: ,g_pkg_name
728: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
729: ,x_msg_count
730: ,x_msg_data
731: ,'_Pub');
732: WHEN OTHERS THEN

Line 733: x_return_status := okl_api.handle_exceptions(l_api_name

729: ,x_msg_count
730: ,x_msg_data
731: ,'_Pub');
732: WHEN OTHERS THEN
733: x_return_status := okl_api.handle_exceptions(l_api_name
734: ,g_pkg_name
735: ,'OTHERS'
736: ,x_msg_count
737: ,x_msg_data