APPS.OKL_REPORT_PVT dependencies on OKL_API

Line 11: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

7: END ;
8:
9: PROCEDURE create_report(
10: p_api_version IN NUMBER,
11: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
12: x_return_status OUT NOCOPY VARCHAR2,
13: x_msg_count OUT NOCOPY NUMBER,
14: x_msg_data OUT NOCOPY VARCHAR2,
15: p_repv_rec IN repv_rec_type,

Line 19: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

15: p_repv_rec IN repv_rec_type,
16: x_repv_rec OUT NOCOPY repv_rec_type
17: ) IS
18:
19: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
20: l_api_name VARCHAR2(30) := 'CREATE_REPORT';
21:
22: BEGIN
23: -- Call start_activity to create savepoint, check compatibility

Line 25: l_return_status := OKL_API.START_ACTIVITY (

21:
22: BEGIN
23: -- Call start_activity to create savepoint, check compatibility
24: -- and initialize message list
25: l_return_status := OKL_API.START_ACTIVITY (
26: l_api_name,
27: p_init_msg_list,
28: '_PVT',
29: l_return_status);

Line 32: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

28: '_PVT',
29: l_return_status);
30:
31: -- Check if activity started successfully
32: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
33: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
34: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
35: RAISE OKL_API.G_EXCEPTION_ERROR;
36: END IF;

Line 33: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

29: l_return_status);
30:
31: -- Check if activity started successfully
32: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
33: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
34: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
35: RAISE OKL_API.G_EXCEPTION_ERROR;
36: END IF;
37:

Line 34: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

30:
31: -- Check if activity started successfully
32: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
33: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
34: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
35: RAISE OKL_API.G_EXCEPTION_ERROR;
36: END IF;
37:
38: -- Tapi Call

Line 35: RAISE OKL_API.G_EXCEPTION_ERROR;

31: -- Check if activity started successfully
32: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
33: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
34: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
35: RAISE OKL_API.G_EXCEPTION_ERROR;
36: END IF;
37:
38: -- Tapi Call
39: Okl_Rep_Pvt.insert_row(

Line 48: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

44: x_msg_data,
45: p_repv_rec,
46: x_repv_rec);
47:
48: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
49: RAISE G_EXCEPTION_HALT_VALIDATION;
50: ELSE
51: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
52: l_return_status := x_return_status;

Line 51: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

47:
48: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
49: RAISE G_EXCEPTION_HALT_VALIDATION;
50: ELSE
51: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
52: l_return_status := x_return_status;
53: END IF;
54: END IF;
55:

Line 56: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );

52: l_return_status := x_return_status;
53: END IF;
54: END IF;
55:
56: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
57:
58: EXCEPTION
59: WHEN OKL_API.G_EXCEPTION_ERROR THEN
60: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 59: WHEN OKL_API.G_EXCEPTION_ERROR THEN

55:
56: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
57:
58: EXCEPTION
59: WHEN OKL_API.G_EXCEPTION_ERROR THEN
60: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
61: l_api_name,
62: G_PKG_NAME,
63: 'OKL_API.G_RET_STS_ERROR',

Line 60: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

56: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
57:
58: EXCEPTION
59: WHEN OKL_API.G_EXCEPTION_ERROR THEN
60: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
61: l_api_name,
62: G_PKG_NAME,
63: 'OKL_API.G_RET_STS_ERROR',
64: x_msg_count,

Line 63: 'OKL_API.G_RET_STS_ERROR',

59: WHEN OKL_API.G_EXCEPTION_ERROR THEN
60: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
61: l_api_name,
62: G_PKG_NAME,
63: 'OKL_API.G_RET_STS_ERROR',
64: x_msg_count,
65: x_msg_data,
66: '_PVT');
67:

Line 68: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

64: x_msg_count,
65: x_msg_data,
66: '_PVT');
67:
68: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
69: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
70: l_api_name,
71: G_PKG_NAME,
72: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 69: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

65: x_msg_data,
66: '_PVT');
67:
68: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
69: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
70: l_api_name,
71: G_PKG_NAME,
72: 'OKL_API.G_RET_STS_UNEXP_ERROR',
73: x_msg_count,

Line 72: 'OKL_API.G_RET_STS_UNEXP_ERROR',

68: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
69: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
70: l_api_name,
71: G_PKG_NAME,
72: 'OKL_API.G_RET_STS_UNEXP_ERROR',
73: x_msg_count,
74: x_msg_data,
75: '_PVT');
76:

Line 78: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

74: x_msg_data,
75: '_PVT');
76:
77: WHEN OTHERS THEN
78: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
79: l_api_name,
80: G_PKG_NAME,
81: 'OTHERS',
82: x_msg_count,

Line 90: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

86: END create_report;
87:
88: PROCEDURE update_report(
89: p_api_version IN NUMBER,
90: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
91: x_return_status OUT NOCOPY VARCHAR2,
92: x_msg_count OUT NOCOPY NUMBER,
93: x_msg_data OUT NOCOPY VARCHAR2,
94: p_repv_rec IN repv_rec_type,

Line 97: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

93: x_msg_data OUT NOCOPY VARCHAR2,
94: p_repv_rec IN repv_rec_type,
95: x_repv_rec OUT NOCOPY repv_rec_type
96: ) IS
97: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
98: l_api_name VARCHAR2(30) := 'UPDATE_REPORT';
99:
100: BEGIN
101: -- Call start_activity to create savepoint, check compatibility

Line 103: l_return_status := OKL_API.START_ACTIVITY (

99:
100: BEGIN
101: -- Call start_activity to create savepoint, check compatibility
102: -- and initialize message list
103: l_return_status := OKL_API.START_ACTIVITY (
104: l_api_name,
105: p_init_msg_list,
106: '_PVT',
107: l_return_status);

Line 110: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

106: '_PVT',
107: l_return_status);
108:
109: -- Check if activity started successfully
110: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
111: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
112: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
113: RAISE OKL_API.G_EXCEPTION_ERROR;
114: END IF;

Line 111: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

107: l_return_status);
108:
109: -- Check if activity started successfully
110: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
111: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
112: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
113: RAISE OKL_API.G_EXCEPTION_ERROR;
114: END IF;
115:

Line 112: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

108:
109: -- Check if activity started successfully
110: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
111: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
112: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
113: RAISE OKL_API.G_EXCEPTION_ERROR;
114: END IF;
115:
116: -- Tapi Call

Line 113: RAISE OKL_API.G_EXCEPTION_ERROR;

109: -- Check if activity started successfully
110: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
111: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
112: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
113: RAISE OKL_API.G_EXCEPTION_ERROR;
114: END IF;
115:
116: -- Tapi Call
117: Okl_Rep_Pvt.update_row(

Line 126: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

122: x_msg_data,
123: p_repv_rec,
124: x_repv_rec);
125:
126: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
127: RAISE G_EXCEPTION_HALT_VALIDATION;
128: ELSE
129: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
130: l_return_status := x_return_status;

Line 129: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

125:
126: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
127: RAISE G_EXCEPTION_HALT_VALIDATION;
128: ELSE
129: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
130: l_return_status := x_return_status;
131: END IF;
132: END IF;
133:

Line 134: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );

130: l_return_status := x_return_status;
131: END IF;
132: END IF;
133:
134: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
135:
136: EXCEPTION
137: WHEN OKL_API.G_EXCEPTION_ERROR THEN
138: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 137: WHEN OKL_API.G_EXCEPTION_ERROR THEN

133:
134: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
135:
136: EXCEPTION
137: WHEN OKL_API.G_EXCEPTION_ERROR THEN
138: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
139: l_api_name,
140: G_PKG_NAME,
141: 'OKL_API.G_RET_STS_ERROR',

Line 138: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

134: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
135:
136: EXCEPTION
137: WHEN OKL_API.G_EXCEPTION_ERROR THEN
138: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
139: l_api_name,
140: G_PKG_NAME,
141: 'OKL_API.G_RET_STS_ERROR',
142: x_msg_count,

Line 141: 'OKL_API.G_RET_STS_ERROR',

137: WHEN OKL_API.G_EXCEPTION_ERROR THEN
138: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
139: l_api_name,
140: G_PKG_NAME,
141: 'OKL_API.G_RET_STS_ERROR',
142: x_msg_count,
143: x_msg_data,
144: '_PVT');
145:

Line 146: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

142: x_msg_count,
143: x_msg_data,
144: '_PVT');
145:
146: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
147: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
148: l_api_name,
149: G_PKG_NAME,
150: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 147: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

143: x_msg_data,
144: '_PVT');
145:
146: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
147: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
148: l_api_name,
149: G_PKG_NAME,
150: 'OKL_API.G_RET_STS_UNEXP_ERROR',
151: x_msg_count,

Line 150: 'OKL_API.G_RET_STS_UNEXP_ERROR',

146: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
147: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
148: l_api_name,
149: G_PKG_NAME,
150: 'OKL_API.G_RET_STS_UNEXP_ERROR',
151: x_msg_count,
152: x_msg_data,
153: '_PVT');
154:

Line 156: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

152: x_msg_data,
153: '_PVT');
154:
155: WHEN OTHERS THEN
156: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
157: l_api_name,
158: G_PKG_NAME,
159: 'OTHERS',
160: x_msg_count,

Line 168: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

164: END update_report;
165:
166: PROCEDURE delete_report(
167: p_api_version IN NUMBER,
168: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
169: x_return_status OUT NOCOPY VARCHAR2,
170: x_msg_count OUT NOCOPY NUMBER,
171: x_msg_data OUT NOCOPY VARCHAR2,
172: p_repv_rec IN repv_rec_type

Line 174: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

170: x_msg_count OUT NOCOPY NUMBER,
171: x_msg_data OUT NOCOPY VARCHAR2,
172: p_repv_rec IN repv_rec_type
173: ) IS
174: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
175: l_api_name VARCHAR2(30) := 'DELETE_REPORT';
176:
177: BEGIN
178: -- Call start_activity to create savepoint, check compatibility

Line 180: l_return_status := OKL_API.START_ACTIVITY (

176:
177: BEGIN
178: -- Call start_activity to create savepoint, check compatibility
179: -- and initialize message list
180: l_return_status := OKL_API.START_ACTIVITY (
181: l_api_name,
182: p_init_msg_list,
183: '_PVT',
184: l_return_status);

Line 187: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

183: '_PVT',
184: l_return_status);
185:
186: -- Check if activity started successfully
187: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
188: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
189: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
190: RAISE OKL_API.G_EXCEPTION_ERROR;
191: END IF;

Line 188: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

184: l_return_status);
185:
186: -- Check if activity started successfully
187: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
188: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
189: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
190: RAISE OKL_API.G_EXCEPTION_ERROR;
191: END IF;
192:

Line 189: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

185:
186: -- Check if activity started successfully
187: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
188: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
189: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
190: RAISE OKL_API.G_EXCEPTION_ERROR;
191: END IF;
192:
193: -- Tapi Call

Line 190: RAISE OKL_API.G_EXCEPTION_ERROR;

186: -- Check if activity started successfully
187: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
188: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
189: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
190: RAISE OKL_API.G_EXCEPTION_ERROR;
191: END IF;
192:
193: -- Tapi Call
194: Okl_Rep_Pvt.delete_row(

Line 202: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

198: x_msg_count,
199: x_msg_data,
200: p_repv_rec);
201:
202: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
203: RAISE G_EXCEPTION_HALT_VALIDATION;
204: ELSE
205: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
206: l_return_status := x_return_status;

Line 205: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

201:
202: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
203: RAISE G_EXCEPTION_HALT_VALIDATION;
204: ELSE
205: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
206: l_return_status := x_return_status;
207: END IF;
208: END IF;
209:

Line 210: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );

206: l_return_status := x_return_status;
207: END IF;
208: END IF;
209:
210: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
211:
212: EXCEPTION
213: WHEN OKL_API.G_EXCEPTION_ERROR THEN
214: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 213: WHEN OKL_API.G_EXCEPTION_ERROR THEN

209:
210: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
211:
212: EXCEPTION
213: WHEN OKL_API.G_EXCEPTION_ERROR THEN
214: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
215: l_api_name,
216: G_PKG_NAME,
217: 'OKL_API.G_RET_STS_ERROR',

Line 214: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

210: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
211:
212: EXCEPTION
213: WHEN OKL_API.G_EXCEPTION_ERROR THEN
214: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
215: l_api_name,
216: G_PKG_NAME,
217: 'OKL_API.G_RET_STS_ERROR',
218: x_msg_count,

Line 217: 'OKL_API.G_RET_STS_ERROR',

213: WHEN OKL_API.G_EXCEPTION_ERROR THEN
214: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
215: l_api_name,
216: G_PKG_NAME,
217: 'OKL_API.G_RET_STS_ERROR',
218: x_msg_count,
219: x_msg_data,
220: '_PVT');
221:

Line 222: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

218: x_msg_count,
219: x_msg_data,
220: '_PVT');
221:
222: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
223: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
224: l_api_name,
225: G_PKG_NAME,
226: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 223: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

219: x_msg_data,
220: '_PVT');
221:
222: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
223: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
224: l_api_name,
225: G_PKG_NAME,
226: 'OKL_API.G_RET_STS_UNEXP_ERROR',
227: x_msg_count,

Line 226: 'OKL_API.G_RET_STS_UNEXP_ERROR',

222: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
223: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
224: l_api_name,
225: G_PKG_NAME,
226: 'OKL_API.G_RET_STS_UNEXP_ERROR',
227: x_msg_count,
228: x_msg_data,
229: '_PVT');
230:

Line 232: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

228: x_msg_data,
229: '_PVT');
230:
231: WHEN OTHERS THEN
232: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
233: l_api_name,
234: G_PKG_NAME,
235: 'OTHERS',
236: x_msg_count,

Line 244: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

240: END delete_report;
241:
242: PROCEDURE submit_report(
243: p_api_version IN NUMBER,
244: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
245: x_return_status OUT NOCOPY VARCHAR2,
246: x_msg_count OUT NOCOPY NUMBER,
247: x_msg_data OUT NOCOPY VARCHAR2,
248: p_rep_id IN NUMBER

Line 250: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

246: x_msg_count OUT NOCOPY NUMBER,
247: x_msg_data OUT NOCOPY VARCHAR2,
248: p_rep_id IN NUMBER
249: ) IS
250: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
251: l_api_name VARCHAR2(30) := 'SUBMIT_REPORT';
252: l_repv_rec repv_rec_type;
253: x_repv_rec repv_rec_type;
254:

Line 282: l_return_status := OKL_API.START_ACTIVITY (

278:
279: BEGIN
280: -- Call start_activity to create savepoint, check compatibility
281: -- and initialize message list
282: l_return_status := OKL_API.START_ACTIVITY (
283: l_api_name,
284: p_init_msg_list,
285: '_PVT',
286: l_return_status);

Line 289: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

285: '_PVT',
286: l_return_status);
287:
288: -- Check if activity started successfully
289: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
290: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
291: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
292: RAISE OKL_API.G_EXCEPTION_ERROR;
293: END IF;

Line 290: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

286: l_return_status);
287:
288: -- Check if activity started successfully
289: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
290: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
291: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
292: RAISE OKL_API.G_EXCEPTION_ERROR;
293: END IF;
294:

Line 291: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

287:
288: -- Check if activity started successfully
289: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
290: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
291: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
292: RAISE OKL_API.G_EXCEPTION_ERROR;
293: END IF;
294:
295: OPEN c_get_details(p_rep_id);

Line 292: RAISE OKL_API.G_EXCEPTION_ERROR;

288: -- Check if activity started successfully
289: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
290: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
291: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
292: RAISE OKL_API.G_EXCEPTION_ERROR;
293: END IF;
294:
295: OPEN c_get_details(p_rep_id);
296: FETCH c_get_details

Line 329: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

325: x_msg_data,
326: l_repv_rec,
327: x_repv_rec);
328:
329: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
330: RAISE G_EXCEPTION_HALT_VALIDATION;
331: ELSE
332: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
333: l_return_status := x_return_status;

Line 332: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

328:
329: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
330: RAISE G_EXCEPTION_HALT_VALIDATION;
331: ELSE
332: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
333: l_return_status := x_return_status;
334: END IF;
335: END IF;
336:

Line 337: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );

333: l_return_status := x_return_status;
334: END IF;
335: END IF;
336:
337: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
338:
339: EXCEPTION
340: WHEN OKL_API.G_EXCEPTION_ERROR THEN
341: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 340: WHEN OKL_API.G_EXCEPTION_ERROR THEN

336:
337: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
338:
339: EXCEPTION
340: WHEN OKL_API.G_EXCEPTION_ERROR THEN
341: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
342: l_api_name,
343: G_PKG_NAME,
344: 'OKL_API.G_RET_STS_ERROR',

Line 341: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

337: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
338:
339: EXCEPTION
340: WHEN OKL_API.G_EXCEPTION_ERROR THEN
341: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
342: l_api_name,
343: G_PKG_NAME,
344: 'OKL_API.G_RET_STS_ERROR',
345: x_msg_count,

Line 344: 'OKL_API.G_RET_STS_ERROR',

340: WHEN OKL_API.G_EXCEPTION_ERROR THEN
341: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
342: l_api_name,
343: G_PKG_NAME,
344: 'OKL_API.G_RET_STS_ERROR',
345: x_msg_count,
346: x_msg_data,
347: '_PVT');
348:

Line 349: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

345: x_msg_count,
346: x_msg_data,
347: '_PVT');
348:
349: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
350: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
351: l_api_name,
352: G_PKG_NAME,
353: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 350: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

346: x_msg_data,
347: '_PVT');
348:
349: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
350: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
351: l_api_name,
352: G_PKG_NAME,
353: 'OKL_API.G_RET_STS_UNEXP_ERROR',
354: x_msg_count,

Line 353: 'OKL_API.G_RET_STS_UNEXP_ERROR',

349: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
350: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
351: l_api_name,
352: G_PKG_NAME,
353: 'OKL_API.G_RET_STS_UNEXP_ERROR',
354: x_msg_count,
355: x_msg_data,
356: '_PVT');
357:

Line 359: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

355: x_msg_data,
356: '_PVT');
357:
358: WHEN OTHERS THEN
359: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
360: l_api_name,
361: G_PKG_NAME,
362: 'OTHERS',
363: x_msg_count,

Line 371: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

367: END submit_report;
368:
369: PROCEDURE activate_report(
370: p_api_version IN NUMBER,
371: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
372: x_return_status OUT NOCOPY VARCHAR2,
373: x_msg_count OUT NOCOPY NUMBER,
374: x_msg_data OUT NOCOPY VARCHAR2,
375: p_rep_id IN NUMBER

Line 377: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

373: x_msg_count OUT NOCOPY NUMBER,
374: x_msg_data OUT NOCOPY VARCHAR2,
375: p_rep_id IN NUMBER
376: ) IS
377: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
378: l_api_name VARCHAR2(30) := 'ACTIVATE_REPORT';
379: l_repv_rec repv_rec_type;
380: x_repv_rec repv_rec_type;
381:

Line 409: l_return_status := OKL_API.START_ACTIVITY (

405:
406: BEGIN
407: -- Call start_activity to create savepoint, check compatibility
408: -- and initialize message list
409: l_return_status := OKL_API.START_ACTIVITY (
410: l_api_name,
411: p_init_msg_list,
412: '_PVT',
413: l_return_status);

Line 416: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

412: '_PVT',
413: l_return_status);
414:
415: -- Check if activity started successfully
416: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
417: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
418: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
419: RAISE OKL_API.G_EXCEPTION_ERROR;
420: END IF;

Line 417: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

413: l_return_status);
414:
415: -- Check if activity started successfully
416: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
417: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
418: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
419: RAISE OKL_API.G_EXCEPTION_ERROR;
420: END IF;
421:

Line 418: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

414:
415: -- Check if activity started successfully
416: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
417: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
418: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
419: RAISE OKL_API.G_EXCEPTION_ERROR;
420: END IF;
421:
422: OPEN c_get_details(p_rep_id);

Line 419: RAISE OKL_API.G_EXCEPTION_ERROR;

415: -- Check if activity started successfully
416: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
417: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
418: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
419: RAISE OKL_API.G_EXCEPTION_ERROR;
420: END IF;
421:
422: OPEN c_get_details(p_rep_id);
423: FETCH c_get_details

Line 458: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

454: x_msg_data,
455: l_repv_rec,
456: x_repv_rec);
457:
458: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
459: RAISE G_EXCEPTION_HALT_VALIDATION;
460: ELSE
461: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
462: l_return_status := x_return_status;

Line 461: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

457:
458: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
459: RAISE G_EXCEPTION_HALT_VALIDATION;
460: ELSE
461: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
462: l_return_status := x_return_status;
463: END IF;
464: END IF;
465:

Line 466: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );

462: l_return_status := x_return_status;
463: END IF;
464: END IF;
465:
466: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
467:
468: EXCEPTION
469: WHEN OKL_API.G_EXCEPTION_ERROR THEN
470: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 469: WHEN OKL_API.G_EXCEPTION_ERROR THEN

465:
466: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
467:
468: EXCEPTION
469: WHEN OKL_API.G_EXCEPTION_ERROR THEN
470: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
471: l_api_name,
472: G_PKG_NAME,
473: 'OKL_API.G_RET_STS_ERROR',

Line 470: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

466: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
467:
468: EXCEPTION
469: WHEN OKL_API.G_EXCEPTION_ERROR THEN
470: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
471: l_api_name,
472: G_PKG_NAME,
473: 'OKL_API.G_RET_STS_ERROR',
474: x_msg_count,

Line 473: 'OKL_API.G_RET_STS_ERROR',

469: WHEN OKL_API.G_EXCEPTION_ERROR THEN
470: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
471: l_api_name,
472: G_PKG_NAME,
473: 'OKL_API.G_RET_STS_ERROR',
474: x_msg_count,
475: x_msg_data,
476: '_PVT');
477:

Line 478: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

474: x_msg_count,
475: x_msg_data,
476: '_PVT');
477:
478: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
479: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
480: l_api_name,
481: G_PKG_NAME,
482: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 479: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

475: x_msg_data,
476: '_PVT');
477:
478: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
479: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
480: l_api_name,
481: G_PKG_NAME,
482: 'OKL_API.G_RET_STS_UNEXP_ERROR',
483: x_msg_count,

Line 482: 'OKL_API.G_RET_STS_UNEXP_ERROR',

478: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
479: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
480: l_api_name,
481: G_PKG_NAME,
482: 'OKL_API.G_RET_STS_UNEXP_ERROR',
483: x_msg_count,
484: x_msg_data,
485: '_PVT');
486:

Line 488: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

484: x_msg_data,
485: '_PVT');
486:
487: WHEN OTHERS THEN
488: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
489: l_api_name,
490: G_PKG_NAME,
491: 'OTHERS',
492: x_msg_count,

Line 500: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

496: END activate_report;
497:
498: PROCEDURE lock_report(
499: p_api_version IN NUMBER,
500: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
501: x_return_status OUT NOCOPY VARCHAR2,
502: x_msg_count OUT NOCOPY NUMBER,
503: x_msg_data OUT NOCOPY VARCHAR2,
504: p_repv_rec IN repv_rec_type

Line 506: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

502: x_msg_count OUT NOCOPY NUMBER,
503: x_msg_data OUT NOCOPY VARCHAR2,
504: p_repv_rec IN repv_rec_type
505: ) IS
506: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
507: l_api_name VARCHAR2(30) := 'LOCK_REPORT';
508:
509: BEGIN
510: -- Call start_activity to create savepoint, check compatibility

Line 512: l_return_status := OKL_API.START_ACTIVITY (

508:
509: BEGIN
510: -- Call start_activity to create savepoint, check compatibility
511: -- and initialize message list
512: l_return_status := OKL_API.START_ACTIVITY (
513: l_api_name,
514: p_init_msg_list,
515: '_PVT',
516: l_return_status);

Line 519: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

515: '_PVT',
516: l_return_status);
517:
518: -- Check if activity started successfully
519: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
520: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
521: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
522: RAISE OKL_API.G_EXCEPTION_ERROR;
523: END IF;

Line 520: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

516: l_return_status);
517:
518: -- Check if activity started successfully
519: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
520: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
521: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
522: RAISE OKL_API.G_EXCEPTION_ERROR;
523: END IF;
524:

Line 521: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

517:
518: -- Check if activity started successfully
519: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
520: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
521: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
522: RAISE OKL_API.G_EXCEPTION_ERROR;
523: END IF;
524:
525: -- Tapi Call

Line 522: RAISE OKL_API.G_EXCEPTION_ERROR;

518: -- Check if activity started successfully
519: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
520: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
521: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
522: RAISE OKL_API.G_EXCEPTION_ERROR;
523: END IF;
524:
525: -- Tapi Call
526: Okl_Rep_Pvt.lock_row(

Line 534: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

530: x_msg_count,
531: x_msg_data,
532: p_repv_rec);
533:
534: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
535: RAISE G_EXCEPTION_HALT_VALIDATION;
536: ELSE
537: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
538: l_return_status := x_return_status;

Line 537: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

533:
534: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
535: RAISE G_EXCEPTION_HALT_VALIDATION;
536: ELSE
537: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
538: l_return_status := x_return_status;
539: END IF;
540: END IF;
541:

Line 542: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );

538: l_return_status := x_return_status;
539: END IF;
540: END IF;
541:
542: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
543:
544: EXCEPTION
545: WHEN OKL_API.G_EXCEPTION_ERROR THEN
546: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 545: WHEN OKL_API.G_EXCEPTION_ERROR THEN

541:
542: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
543:
544: EXCEPTION
545: WHEN OKL_API.G_EXCEPTION_ERROR THEN
546: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
547: l_api_name,
548: G_PKG_NAME,
549: 'OKL_API.G_RET_STS_ERROR',

Line 546: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

542: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
543:
544: EXCEPTION
545: WHEN OKL_API.G_EXCEPTION_ERROR THEN
546: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
547: l_api_name,
548: G_PKG_NAME,
549: 'OKL_API.G_RET_STS_ERROR',
550: x_msg_count,

Line 549: 'OKL_API.G_RET_STS_ERROR',

545: WHEN OKL_API.G_EXCEPTION_ERROR THEN
546: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
547: l_api_name,
548: G_PKG_NAME,
549: 'OKL_API.G_RET_STS_ERROR',
550: x_msg_count,
551: x_msg_data,
552: '_PVT');
553:

Line 554: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

550: x_msg_count,
551: x_msg_data,
552: '_PVT');
553:
554: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
555: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
556: l_api_name,
557: G_PKG_NAME,
558: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 555: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

551: x_msg_data,
552: '_PVT');
553:
554: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
555: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
556: l_api_name,
557: G_PKG_NAME,
558: 'OKL_API.G_RET_STS_UNEXP_ERROR',
559: x_msg_count,

Line 558: 'OKL_API.G_RET_STS_UNEXP_ERROR',

554: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
555: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
556: l_api_name,
557: G_PKG_NAME,
558: 'OKL_API.G_RET_STS_UNEXP_ERROR',
559: x_msg_count,
560: x_msg_data,
561: '_PVT');
562:

Line 564: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

560: x_msg_data,
561: '_PVT');
562:
563: WHEN OTHERS THEN
564: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
565: l_api_name,
566: G_PKG_NAME,
567: 'OTHERS',
568: x_msg_count,

Line 576: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

572: END lock_report;
573:
574: PROCEDURE create_report(
575: p_api_version IN NUMBER,
576: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
577: x_return_status OUT NOCOPY VARCHAR2,
578: x_msg_count OUT NOCOPY NUMBER,
579: x_msg_data OUT NOCOPY VARCHAR2,
580: p_repv_tbl IN repv_tbl_type,

Line 584: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

580: p_repv_tbl IN repv_tbl_type,
581: x_repv_tbl OUT NOCOPY repv_tbl_type
582: ) IS
583:
584: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
585: l_api_name VARCHAR2(30) := 'CREATE_REPORT';
586:
587: BEGIN
588: -- Call start_activity to create savepoint, check compatibility

Line 590: l_return_status := OKL_API.START_ACTIVITY (

586:
587: BEGIN
588: -- Call start_activity to create savepoint, check compatibility
589: -- and initialize message list
590: l_return_status := OKL_API.START_ACTIVITY (
591: l_api_name,
592: p_init_msg_list,
593: '_PVT',
594: l_return_status);

Line 597: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

593: '_PVT',
594: l_return_status);
595:
596: -- Check if activity started successfully
597: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
598: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
599: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
600: RAISE OKL_API.G_EXCEPTION_ERROR;
601: END IF;

Line 598: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

594: l_return_status);
595:
596: -- Check if activity started successfully
597: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
598: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
599: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
600: RAISE OKL_API.G_EXCEPTION_ERROR;
601: END IF;
602:

Line 599: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

595:
596: -- Check if activity started successfully
597: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
598: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
599: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
600: RAISE OKL_API.G_EXCEPTION_ERROR;
601: END IF;
602:
603: -- Tapi Call

Line 600: RAISE OKL_API.G_EXCEPTION_ERROR;

596: -- Check if activity started successfully
597: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
598: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
599: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
600: RAISE OKL_API.G_EXCEPTION_ERROR;
601: END IF;
602:
603: -- Tapi Call
604: Okl_Rep_Pvt.insert_row(

Line 613: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

609: x_msg_data,
610: p_repv_tbl,
611: x_repv_tbl);
612:
613: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
614: RAISE G_EXCEPTION_HALT_VALIDATION;
615: ELSE
616: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
617: l_return_status := x_return_status;

Line 616: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

612:
613: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
614: RAISE G_EXCEPTION_HALT_VALIDATION;
615: ELSE
616: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
617: l_return_status := x_return_status;
618: END IF;
619: END IF;
620:

Line 621: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );

617: l_return_status := x_return_status;
618: END IF;
619: END IF;
620:
621: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
622:
623: EXCEPTION
624: WHEN OKL_API.G_EXCEPTION_ERROR THEN
625: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 624: WHEN OKL_API.G_EXCEPTION_ERROR THEN

620:
621: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
622:
623: EXCEPTION
624: WHEN OKL_API.G_EXCEPTION_ERROR THEN
625: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
626: l_api_name,
627: G_PKG_NAME,
628: 'OKL_API.G_RET_STS_ERROR',

Line 625: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

621: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
622:
623: EXCEPTION
624: WHEN OKL_API.G_EXCEPTION_ERROR THEN
625: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
626: l_api_name,
627: G_PKG_NAME,
628: 'OKL_API.G_RET_STS_ERROR',
629: x_msg_count,

Line 628: 'OKL_API.G_RET_STS_ERROR',

624: WHEN OKL_API.G_EXCEPTION_ERROR THEN
625: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
626: l_api_name,
627: G_PKG_NAME,
628: 'OKL_API.G_RET_STS_ERROR',
629: x_msg_count,
630: x_msg_data,
631: '_PVT');
632:

Line 633: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

629: x_msg_count,
630: x_msg_data,
631: '_PVT');
632:
633: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
634: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
635: l_api_name,
636: G_PKG_NAME,
637: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 634: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

630: x_msg_data,
631: '_PVT');
632:
633: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
634: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
635: l_api_name,
636: G_PKG_NAME,
637: 'OKL_API.G_RET_STS_UNEXP_ERROR',
638: x_msg_count,

Line 637: 'OKL_API.G_RET_STS_UNEXP_ERROR',

633: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
634: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
635: l_api_name,
636: G_PKG_NAME,
637: 'OKL_API.G_RET_STS_UNEXP_ERROR',
638: x_msg_count,
639: x_msg_data,
640: '_PVT');
641:

Line 643: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

639: x_msg_data,
640: '_PVT');
641:
642: WHEN OTHERS THEN
643: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
644: l_api_name,
645: G_PKG_NAME,
646: 'OTHERS',
647: x_msg_count,

Line 655: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

651: END create_report;
652:
653: PROCEDURE update_report(
654: p_api_version IN NUMBER,
655: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
656: x_return_status OUT NOCOPY VARCHAR2,
657: x_msg_count OUT NOCOPY NUMBER,
658: x_msg_data OUT NOCOPY VARCHAR2,
659: p_repv_tbl IN repv_tbl_type,

Line 663: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

659: p_repv_tbl IN repv_tbl_type,
660: x_repv_tbl OUT NOCOPY repv_tbl_type
661: ) IS
662:
663: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
664: l_api_name VARCHAR2(30) := 'UPDATE_REPORT';
665:
666: BEGIN
667: -- Call start_activity to create savepoint, check compatibility

Line 669: l_return_status := OKL_API.START_ACTIVITY (

665:
666: BEGIN
667: -- Call start_activity to create savepoint, check compatibility
668: -- and initialize message list
669: l_return_status := OKL_API.START_ACTIVITY (
670: l_api_name,
671: p_init_msg_list,
672: '_PVT',
673: l_return_status);

Line 676: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

672: '_PVT',
673: l_return_status);
674:
675: -- Check if activity started successfully
676: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
677: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
678: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
679: RAISE OKL_API.G_EXCEPTION_ERROR;
680: END IF;

Line 677: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

673: l_return_status);
674:
675: -- Check if activity started successfully
676: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
677: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
678: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
679: RAISE OKL_API.G_EXCEPTION_ERROR;
680: END IF;
681:

Line 678: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

674:
675: -- Check if activity started successfully
676: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
677: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
678: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
679: RAISE OKL_API.G_EXCEPTION_ERROR;
680: END IF;
681:
682: -- Tapi Call

Line 679: RAISE OKL_API.G_EXCEPTION_ERROR;

675: -- Check if activity started successfully
676: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
677: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
678: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
679: RAISE OKL_API.G_EXCEPTION_ERROR;
680: END IF;
681:
682: -- Tapi Call
683: Okl_Rep_Pvt.update_row(

Line 692: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

688: x_msg_data,
689: p_repv_tbl,
690: x_repv_tbl);
691:
692: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
693: RAISE G_EXCEPTION_HALT_VALIDATION;
694: ELSE
695: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
696: l_return_status := x_return_status;

Line 695: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

691:
692: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
693: RAISE G_EXCEPTION_HALT_VALIDATION;
694: ELSE
695: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
696: l_return_status := x_return_status;
697: END IF;
698: END IF;
699:

Line 700: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );

696: l_return_status := x_return_status;
697: END IF;
698: END IF;
699:
700: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
701:
702: EXCEPTION
703: WHEN OKL_API.G_EXCEPTION_ERROR THEN
704: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 703: WHEN OKL_API.G_EXCEPTION_ERROR THEN

699:
700: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
701:
702: EXCEPTION
703: WHEN OKL_API.G_EXCEPTION_ERROR THEN
704: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
705: l_api_name,
706: G_PKG_NAME,
707: 'OKL_API.G_RET_STS_ERROR',

Line 704: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

700: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
701:
702: EXCEPTION
703: WHEN OKL_API.G_EXCEPTION_ERROR THEN
704: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
705: l_api_name,
706: G_PKG_NAME,
707: 'OKL_API.G_RET_STS_ERROR',
708: x_msg_count,

Line 707: 'OKL_API.G_RET_STS_ERROR',

703: WHEN OKL_API.G_EXCEPTION_ERROR THEN
704: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
705: l_api_name,
706: G_PKG_NAME,
707: 'OKL_API.G_RET_STS_ERROR',
708: x_msg_count,
709: x_msg_data,
710: '_PVT');
711:

Line 712: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

708: x_msg_count,
709: x_msg_data,
710: '_PVT');
711:
712: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
713: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
714: l_api_name,
715: G_PKG_NAME,
716: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 713: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

709: x_msg_data,
710: '_PVT');
711:
712: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
713: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
714: l_api_name,
715: G_PKG_NAME,
716: 'OKL_API.G_RET_STS_UNEXP_ERROR',
717: x_msg_count,

Line 716: 'OKL_API.G_RET_STS_UNEXP_ERROR',

712: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
713: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
714: l_api_name,
715: G_PKG_NAME,
716: 'OKL_API.G_RET_STS_UNEXP_ERROR',
717: x_msg_count,
718: x_msg_data,
719: '_PVT');
720:

Line 722: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

718: x_msg_data,
719: '_PVT');
720:
721: WHEN OTHERS THEN
722: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
723: l_api_name,
724: G_PKG_NAME,
725: 'OTHERS',
726: x_msg_count,

Line 734: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

730: END update_report;
731:
732: PROCEDURE delete_report(
733: p_api_version IN NUMBER,
734: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
735: x_return_status OUT NOCOPY VARCHAR2,
736: x_msg_count OUT NOCOPY NUMBER,
737: x_msg_data OUT NOCOPY VARCHAR2,
738: p_repv_tbl IN repv_tbl_type

Line 741: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

737: x_msg_data OUT NOCOPY VARCHAR2,
738: p_repv_tbl IN repv_tbl_type
739: ) IS
740:
741: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
742: l_api_name VARCHAR2(30) := 'DELETE_REPORT';
743:
744: BEGIN
745: -- Call start_activity to create savepoint, check compatibility

Line 747: l_return_status := OKL_API.START_ACTIVITY (

743:
744: BEGIN
745: -- Call start_activity to create savepoint, check compatibility
746: -- and initialize message list
747: l_return_status := OKL_API.START_ACTIVITY (
748: l_api_name,
749: p_init_msg_list,
750: '_PVT',
751: l_return_status);

Line 754: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

750: '_PVT',
751: l_return_status);
752:
753: -- Check if activity started successfully
754: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
755: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
756: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
757: RAISE OKL_API.G_EXCEPTION_ERROR;
758: END IF;

Line 755: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

751: l_return_status);
752:
753: -- Check if activity started successfully
754: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
755: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
756: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
757: RAISE OKL_API.G_EXCEPTION_ERROR;
758: END IF;
759:

Line 756: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

752:
753: -- Check if activity started successfully
754: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
755: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
756: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
757: RAISE OKL_API.G_EXCEPTION_ERROR;
758: END IF;
759:
760: -- Tapi Call

Line 757: RAISE OKL_API.G_EXCEPTION_ERROR;

753: -- Check if activity started successfully
754: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
755: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
756: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
757: RAISE OKL_API.G_EXCEPTION_ERROR;
758: END IF;
759:
760: -- Tapi Call
761: Okl_Rep_Pvt.delete_row(

Line 769: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

765: x_msg_count,
766: x_msg_data,
767: p_repv_tbl);
768:
769: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
770: RAISE G_EXCEPTION_HALT_VALIDATION;
771: ELSE
772: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
773: l_return_status := x_return_status;

Line 772: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

768:
769: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
770: RAISE G_EXCEPTION_HALT_VALIDATION;
771: ELSE
772: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
773: l_return_status := x_return_status;
774: END IF;
775: END IF;
776:

Line 777: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );

773: l_return_status := x_return_status;
774: END IF;
775: END IF;
776:
777: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
778:
779: EXCEPTION
780: WHEN OKL_API.G_EXCEPTION_ERROR THEN
781: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 780: WHEN OKL_API.G_EXCEPTION_ERROR THEN

776:
777: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
778:
779: EXCEPTION
780: WHEN OKL_API.G_EXCEPTION_ERROR THEN
781: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
782: l_api_name,
783: G_PKG_NAME,
784: 'OKL_API.G_RET_STS_ERROR',

Line 781: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

777: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
778:
779: EXCEPTION
780: WHEN OKL_API.G_EXCEPTION_ERROR THEN
781: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
782: l_api_name,
783: G_PKG_NAME,
784: 'OKL_API.G_RET_STS_ERROR',
785: x_msg_count,

Line 784: 'OKL_API.G_RET_STS_ERROR',

780: WHEN OKL_API.G_EXCEPTION_ERROR THEN
781: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
782: l_api_name,
783: G_PKG_NAME,
784: 'OKL_API.G_RET_STS_ERROR',
785: x_msg_count,
786: x_msg_data,
787: '_PVT');
788:

Line 789: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

785: x_msg_count,
786: x_msg_data,
787: '_PVT');
788:
789: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
790: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
791: l_api_name,
792: G_PKG_NAME,
793: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 790: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

786: x_msg_data,
787: '_PVT');
788:
789: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
790: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
791: l_api_name,
792: G_PKG_NAME,
793: 'OKL_API.G_RET_STS_UNEXP_ERROR',
794: x_msg_count,

Line 793: 'OKL_API.G_RET_STS_UNEXP_ERROR',

789: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
790: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
791: l_api_name,
792: G_PKG_NAME,
793: 'OKL_API.G_RET_STS_UNEXP_ERROR',
794: x_msg_count,
795: x_msg_data,
796: '_PVT');
797:

Line 799: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

795: x_msg_data,
796: '_PVT');
797:
798: WHEN OTHERS THEN
799: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
800: l_api_name,
801: G_PKG_NAME,
802: 'OTHERS',
803: x_msg_count,

Line 811: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

807: END delete_report;
808:
809: PROCEDURE lock_report(
810: p_api_version IN NUMBER,
811: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
812: x_return_status OUT NOCOPY VARCHAR2,
813: x_msg_count OUT NOCOPY NUMBER,
814: x_msg_data OUT NOCOPY VARCHAR2,
815: p_repv_tbl IN repv_tbl_type

Line 818: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

814: x_msg_data OUT NOCOPY VARCHAR2,
815: p_repv_tbl IN repv_tbl_type
816: ) IS
817:
818: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
819: l_api_name VARCHAR2(30) := 'LOCK_REPORT';
820:
821: BEGIN
822: -- Call start_activity to create savepoint, check compatibility

Line 824: l_return_status := OKL_API.START_ACTIVITY (

820:
821: BEGIN
822: -- Call start_activity to create savepoint, check compatibility
823: -- and initialize message list
824: l_return_status := OKL_API.START_ACTIVITY (
825: l_api_name,
826: p_init_msg_list,
827: '_PVT',
828: l_return_status);

Line 831: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

827: '_PVT',
828: l_return_status);
829:
830: -- Check if activity started successfully
831: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
832: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
833: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
834: RAISE OKL_API.G_EXCEPTION_ERROR;
835: END IF;

Line 832: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

828: l_return_status);
829:
830: -- Check if activity started successfully
831: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
832: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
833: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
834: RAISE OKL_API.G_EXCEPTION_ERROR;
835: END IF;
836:

Line 833: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

829:
830: -- Check if activity started successfully
831: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
832: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
833: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
834: RAISE OKL_API.G_EXCEPTION_ERROR;
835: END IF;
836:
837: -- Tapi Call

Line 834: RAISE OKL_API.G_EXCEPTION_ERROR;

830: -- Check if activity started successfully
831: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
832: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
833: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
834: RAISE OKL_API.G_EXCEPTION_ERROR;
835: END IF;
836:
837: -- Tapi Call
838: Okl_Rep_Pvt.lock_row(

Line 846: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

842: x_msg_count,
843: x_msg_data,
844: p_repv_tbl);
845:
846: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
847: RAISE G_EXCEPTION_HALT_VALIDATION;
848: ELSE
849: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
850: l_return_status := x_return_status;

Line 849: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

845:
846: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
847: RAISE G_EXCEPTION_HALT_VALIDATION;
848: ELSE
849: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
850: l_return_status := x_return_status;
851: END IF;
852: END IF;
853:

Line 854: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );

850: l_return_status := x_return_status;
851: END IF;
852: END IF;
853:
854: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
855:
856: EXCEPTION
857: WHEN OKL_API.G_EXCEPTION_ERROR THEN
858: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 857: WHEN OKL_API.G_EXCEPTION_ERROR THEN

853:
854: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
855:
856: EXCEPTION
857: WHEN OKL_API.G_EXCEPTION_ERROR THEN
858: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
859: l_api_name,
860: G_PKG_NAME,
861: 'OKL_API.G_RET_STS_ERROR',

Line 858: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

854: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
855:
856: EXCEPTION
857: WHEN OKL_API.G_EXCEPTION_ERROR THEN
858: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
859: l_api_name,
860: G_PKG_NAME,
861: 'OKL_API.G_RET_STS_ERROR',
862: x_msg_count,

Line 861: 'OKL_API.G_RET_STS_ERROR',

857: WHEN OKL_API.G_EXCEPTION_ERROR THEN
858: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
859: l_api_name,
860: G_PKG_NAME,
861: 'OKL_API.G_RET_STS_ERROR',
862: x_msg_count,
863: x_msg_data,
864: '_PVT');
865:

Line 866: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

862: x_msg_count,
863: x_msg_data,
864: '_PVT');
865:
866: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
867: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
868: l_api_name,
869: G_PKG_NAME,
870: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 867: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

863: x_msg_data,
864: '_PVT');
865:
866: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
867: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
868: l_api_name,
869: G_PKG_NAME,
870: 'OKL_API.G_RET_STS_UNEXP_ERROR',
871: x_msg_count,

Line 870: 'OKL_API.G_RET_STS_UNEXP_ERROR',

866: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
867: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
868: l_api_name,
869: G_PKG_NAME,
870: 'OKL_API.G_RET_STS_UNEXP_ERROR',
871: x_msg_count,
872: x_msg_data,
873: '_PVT');
874:

Line 876: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

872: x_msg_data,
873: '_PVT');
874:
875: WHEN OTHERS THEN
876: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
877: l_api_name,
878: G_PKG_NAME,
879: 'OTHERS',
880: x_msg_count,

Line 888: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

884: END lock_report;
885:
886: PROCEDURE create_report_parameters(
887: p_api_version IN NUMBER,
888: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
889: x_return_status OUT NOCOPY VARCHAR2,
890: x_msg_count OUT NOCOPY NUMBER,
891: x_msg_data OUT NOCOPY VARCHAR2,
892: p_rpp_rec IN rpp_rec_type,

Line 896: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

892: p_rpp_rec IN rpp_rec_type,
893: x_rpp_rec OUT NOCOPY rpp_rec_type
894: ) IS
895:
896: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
897: l_api_name VARCHAR2(30) := 'CREATE_REPORT_PARAMETERS';
898:
899: BEGIN
900: -- Call start_activity to create savepoint, check compatibility

Line 902: l_return_status := OKL_API.START_ACTIVITY (

898:
899: BEGIN
900: -- Call start_activity to create savepoint, check compatibility
901: -- and initialize message list
902: l_return_status := OKL_API.START_ACTIVITY (
903: l_api_name,
904: p_init_msg_list,
905: '_PVT',
906: l_return_status);

Line 909: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

905: '_PVT',
906: l_return_status);
907:
908: -- Check if activity started successfully
909: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
910: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
911: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
912: RAISE OKL_API.G_EXCEPTION_ERROR;
913: END IF;

Line 910: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

906: l_return_status);
907:
908: -- Check if activity started successfully
909: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
910: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
911: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
912: RAISE OKL_API.G_EXCEPTION_ERROR;
913: END IF;
914:

Line 911: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

907:
908: -- Check if activity started successfully
909: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
910: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
911: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
912: RAISE OKL_API.G_EXCEPTION_ERROR;
913: END IF;
914:
915: -- Tapi Call

Line 912: RAISE OKL_API.G_EXCEPTION_ERROR;

908: -- Check if activity started successfully
909: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
910: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
911: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
912: RAISE OKL_API.G_EXCEPTION_ERROR;
913: END IF;
914:
915: -- Tapi Call
916: Okl_Rpp_Pvt.insert_row(

Line 925: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

921: x_msg_data,
922: p_rpp_rec,
923: x_rpp_rec);
924:
925: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
926: RAISE G_EXCEPTION_HALT_VALIDATION;
927: ELSE
928: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
929: l_return_status := x_return_status;

Line 928: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

924:
925: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
926: RAISE G_EXCEPTION_HALT_VALIDATION;
927: ELSE
928: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
929: l_return_status := x_return_status;
930: END IF;
931: END IF;
932:

Line 933: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );

929: l_return_status := x_return_status;
930: END IF;
931: END IF;
932:
933: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
934:
935: EXCEPTION
936: WHEN OKL_API.G_EXCEPTION_ERROR THEN
937: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 936: WHEN OKL_API.G_EXCEPTION_ERROR THEN

932:
933: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
934:
935: EXCEPTION
936: WHEN OKL_API.G_EXCEPTION_ERROR THEN
937: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
938: l_api_name,
939: G_PKG_NAME,
940: 'OKL_API.G_RET_STS_ERROR',

Line 937: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

933: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
934:
935: EXCEPTION
936: WHEN OKL_API.G_EXCEPTION_ERROR THEN
937: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
938: l_api_name,
939: G_PKG_NAME,
940: 'OKL_API.G_RET_STS_ERROR',
941: x_msg_count,

Line 940: 'OKL_API.G_RET_STS_ERROR',

936: WHEN OKL_API.G_EXCEPTION_ERROR THEN
937: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
938: l_api_name,
939: G_PKG_NAME,
940: 'OKL_API.G_RET_STS_ERROR',
941: x_msg_count,
942: x_msg_data,
943: '_PVT');
944:

Line 945: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

941: x_msg_count,
942: x_msg_data,
943: '_PVT');
944:
945: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
946: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
947: l_api_name,
948: G_PKG_NAME,
949: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 946: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

942: x_msg_data,
943: '_PVT');
944:
945: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
946: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
947: l_api_name,
948: G_PKG_NAME,
949: 'OKL_API.G_RET_STS_UNEXP_ERROR',
950: x_msg_count,

Line 949: 'OKL_API.G_RET_STS_UNEXP_ERROR',

945: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
946: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
947: l_api_name,
948: G_PKG_NAME,
949: 'OKL_API.G_RET_STS_UNEXP_ERROR',
950: x_msg_count,
951: x_msg_data,
952: '_PVT');
953:

Line 955: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

951: x_msg_data,
952: '_PVT');
953:
954: WHEN OTHERS THEN
955: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
956: l_api_name,
957: G_PKG_NAME,
958: 'OTHERS',
959: x_msg_count,

Line 967: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

963: END create_report_parameters;
964:
965: PROCEDURE update_report_parameters(
966: p_api_version IN NUMBER,
967: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
968: x_return_status OUT NOCOPY VARCHAR2,
969: x_msg_count OUT NOCOPY NUMBER,
970: x_msg_data OUT NOCOPY VARCHAR2,
971: p_rpp_rec IN rpp_rec_type,

Line 975: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

971: p_rpp_rec IN rpp_rec_type,
972: x_rpp_rec OUT NOCOPY rpp_rec_type
973: ) IS
974:
975: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
976: l_api_name VARCHAR2(30) := 'UPDATE_REPORT_PARAMETERS';
977:
978: BEGIN
979: -- Call start_activity to create savepoint, check compatibility

Line 981: l_return_status := OKL_API.START_ACTIVITY (

977:
978: BEGIN
979: -- Call start_activity to create savepoint, check compatibility
980: -- and initialize message list
981: l_return_status := OKL_API.START_ACTIVITY (
982: l_api_name,
983: p_init_msg_list,
984: '_PVT',
985: l_return_status);

Line 988: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

984: '_PVT',
985: l_return_status);
986:
987: -- Check if activity started successfully
988: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
989: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
990: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
991: RAISE OKL_API.G_EXCEPTION_ERROR;
992: END IF;

Line 989: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

985: l_return_status);
986:
987: -- Check if activity started successfully
988: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
989: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
990: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
991: RAISE OKL_API.G_EXCEPTION_ERROR;
992: END IF;
993:

Line 990: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

986:
987: -- Check if activity started successfully
988: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
989: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
990: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
991: RAISE OKL_API.G_EXCEPTION_ERROR;
992: END IF;
993:
994: -- Tapi Call

Line 991: RAISE OKL_API.G_EXCEPTION_ERROR;

987: -- Check if activity started successfully
988: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
989: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
990: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
991: RAISE OKL_API.G_EXCEPTION_ERROR;
992: END IF;
993:
994: -- Tapi Call
995: Okl_Rpp_Pvt.update_row(

Line 1004: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

1000: x_msg_data,
1001: p_rpp_rec,
1002: x_rpp_rec);
1003:
1004: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1005: RAISE G_EXCEPTION_HALT_VALIDATION;
1006: ELSE
1007: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
1008: l_return_status := x_return_status;

Line 1007: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

1003:
1004: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1005: RAISE G_EXCEPTION_HALT_VALIDATION;
1006: ELSE
1007: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
1008: l_return_status := x_return_status;
1009: END IF;
1010: END IF;
1011:

Line 1012: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );

1008: l_return_status := x_return_status;
1009: END IF;
1010: END IF;
1011:
1012: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
1013:
1014: EXCEPTION
1015: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1016: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 1015: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1011:
1012: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
1013:
1014: EXCEPTION
1015: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1016: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1017: l_api_name,
1018: G_PKG_NAME,
1019: 'OKL_API.G_RET_STS_ERROR',

Line 1016: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1012: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
1013:
1014: EXCEPTION
1015: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1016: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1017: l_api_name,
1018: G_PKG_NAME,
1019: 'OKL_API.G_RET_STS_ERROR',
1020: x_msg_count,

Line 1019: 'OKL_API.G_RET_STS_ERROR',

1015: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1016: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1017: l_api_name,
1018: G_PKG_NAME,
1019: 'OKL_API.G_RET_STS_ERROR',
1020: x_msg_count,
1021: x_msg_data,
1022: '_PVT');
1023:

Line 1024: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1020: x_msg_count,
1021: x_msg_data,
1022: '_PVT');
1023:
1024: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1025: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
1026: l_api_name,
1027: G_PKG_NAME,
1028: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1025: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

1021: x_msg_data,
1022: '_PVT');
1023:
1024: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1025: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
1026: l_api_name,
1027: G_PKG_NAME,
1028: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1029: x_msg_count,

Line 1028: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1024: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1025: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
1026: l_api_name,
1027: G_PKG_NAME,
1028: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1029: x_msg_count,
1030: x_msg_data,
1031: '_PVT');
1032:

Line 1034: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

1030: x_msg_data,
1031: '_PVT');
1032:
1033: WHEN OTHERS THEN
1034: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
1035: l_api_name,
1036: G_PKG_NAME,
1037: 'OTHERS',
1038: x_msg_count,

Line 1046: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

1042: END update_report_parameters;
1043:
1044: PROCEDURE delete_report_parameters(
1045: p_api_version IN NUMBER,
1046: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
1047: x_return_status OUT NOCOPY VARCHAR2,
1048: x_msg_count OUT NOCOPY NUMBER,
1049: x_msg_data OUT NOCOPY VARCHAR2,
1050: p_rpp_rec IN rpp_rec_type

Line 1053: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

1049: x_msg_data OUT NOCOPY VARCHAR2,
1050: p_rpp_rec IN rpp_rec_type
1051: ) IS
1052:
1053: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1054: l_api_name VARCHAR2(30) := 'DELETE_REPORT_PARAMETERS';
1055:
1056: BEGIN
1057: -- Call start_activity to create savepoint, check compatibility

Line 1059: l_return_status := OKL_API.START_ACTIVITY (

1055:
1056: BEGIN
1057: -- Call start_activity to create savepoint, check compatibility
1058: -- and initialize message list
1059: l_return_status := OKL_API.START_ACTIVITY (
1060: l_api_name,
1061: p_init_msg_list,
1062: '_PVT',
1063: l_return_status);

Line 1066: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1062: '_PVT',
1063: l_return_status);
1064:
1065: -- Check if activity started successfully
1066: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1067: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1068: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1069: RAISE OKL_API.G_EXCEPTION_ERROR;
1070: END IF;

Line 1067: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1063: l_return_status);
1064:
1065: -- Check if activity started successfully
1066: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1067: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1068: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1069: RAISE OKL_API.G_EXCEPTION_ERROR;
1070: END IF;
1071:

Line 1068: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

1064:
1065: -- Check if activity started successfully
1066: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1067: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1068: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1069: RAISE OKL_API.G_EXCEPTION_ERROR;
1070: END IF;
1071:
1072: -- Tapi Call

Line 1069: RAISE OKL_API.G_EXCEPTION_ERROR;

1065: -- Check if activity started successfully
1066: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1067: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1068: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1069: RAISE OKL_API.G_EXCEPTION_ERROR;
1070: END IF;
1071:
1072: -- Tapi Call
1073: Okl_Rpp_Pvt.delete_row(

Line 1081: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

1077: x_msg_count,
1078: x_msg_data,
1079: p_rpp_rec);
1080:
1081: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1082: RAISE G_EXCEPTION_HALT_VALIDATION;
1083: ELSE
1084: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
1085: l_return_status := x_return_status;

Line 1084: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

1080:
1081: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1082: RAISE G_EXCEPTION_HALT_VALIDATION;
1083: ELSE
1084: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
1085: l_return_status := x_return_status;
1086: END IF;
1087: END IF;
1088:

Line 1089: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );

1085: l_return_status := x_return_status;
1086: END IF;
1087: END IF;
1088:
1089: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
1090:
1091: EXCEPTION
1092: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1093: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 1092: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1088:
1089: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
1090:
1091: EXCEPTION
1092: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1093: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1094: l_api_name,
1095: G_PKG_NAME,
1096: 'OKL_API.G_RET_STS_ERROR',

Line 1093: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1089: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
1090:
1091: EXCEPTION
1092: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1093: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1094: l_api_name,
1095: G_PKG_NAME,
1096: 'OKL_API.G_RET_STS_ERROR',
1097: x_msg_count,

Line 1096: 'OKL_API.G_RET_STS_ERROR',

1092: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1093: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1094: l_api_name,
1095: G_PKG_NAME,
1096: 'OKL_API.G_RET_STS_ERROR',
1097: x_msg_count,
1098: x_msg_data,
1099: '_PVT');
1100:

Line 1101: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1097: x_msg_count,
1098: x_msg_data,
1099: '_PVT');
1100:
1101: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1102: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
1103: l_api_name,
1104: G_PKG_NAME,
1105: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1102: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

1098: x_msg_data,
1099: '_PVT');
1100:
1101: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1102: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
1103: l_api_name,
1104: G_PKG_NAME,
1105: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1106: x_msg_count,

Line 1105: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1101: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1102: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
1103: l_api_name,
1104: G_PKG_NAME,
1105: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1106: x_msg_count,
1107: x_msg_data,
1108: '_PVT');
1109:

Line 1111: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

1107: x_msg_data,
1108: '_PVT');
1109:
1110: WHEN OTHERS THEN
1111: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
1112: l_api_name,
1113: G_PKG_NAME,
1114: 'OTHERS',
1115: x_msg_count,

Line 1123: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

1119: END delete_report_parameters;
1120:
1121: PROCEDURE lock_report_parameters(
1122: p_api_version IN NUMBER,
1123: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
1124: x_return_status OUT NOCOPY VARCHAR2,
1125: x_msg_count OUT NOCOPY NUMBER,
1126: x_msg_data OUT NOCOPY VARCHAR2,
1127: p_rpp_rec IN rpp_rec_type

Line 1130: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

1126: x_msg_data OUT NOCOPY VARCHAR2,
1127: p_rpp_rec IN rpp_rec_type
1128: ) IS
1129:
1130: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1131: l_api_name VARCHAR2(30) := 'LOCK_REPORT_PARAMETERS';
1132:
1133: BEGIN
1134: -- Call start_activity to create savepoint, check compatibility

Line 1136: l_return_status := OKL_API.START_ACTIVITY (

1132:
1133: BEGIN
1134: -- Call start_activity to create savepoint, check compatibility
1135: -- and initialize message list
1136: l_return_status := OKL_API.START_ACTIVITY (
1137: l_api_name,
1138: p_init_msg_list,
1139: '_PVT',
1140: l_return_status);

Line 1143: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1139: '_PVT',
1140: l_return_status);
1141:
1142: -- Check if activity started successfully
1143: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1144: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1145: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1146: RAISE OKL_API.G_EXCEPTION_ERROR;
1147: END IF;

Line 1144: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1140: l_return_status);
1141:
1142: -- Check if activity started successfully
1143: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1144: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1145: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1146: RAISE OKL_API.G_EXCEPTION_ERROR;
1147: END IF;
1148:

Line 1145: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

1141:
1142: -- Check if activity started successfully
1143: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1144: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1145: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1146: RAISE OKL_API.G_EXCEPTION_ERROR;
1147: END IF;
1148:
1149: -- Tapi Call

Line 1146: RAISE OKL_API.G_EXCEPTION_ERROR;

1142: -- Check if activity started successfully
1143: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1144: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1145: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1146: RAISE OKL_API.G_EXCEPTION_ERROR;
1147: END IF;
1148:
1149: -- Tapi Call
1150: Okl_Rpp_Pvt.lock_row(

Line 1158: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

1154: x_msg_count,
1155: x_msg_data,
1156: p_rpp_rec);
1157:
1158: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1159: RAISE G_EXCEPTION_HALT_VALIDATION;
1160: ELSE
1161: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
1162: l_return_status := x_return_status;

Line 1161: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

1157:
1158: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1159: RAISE G_EXCEPTION_HALT_VALIDATION;
1160: ELSE
1161: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
1162: l_return_status := x_return_status;
1163: END IF;
1164: END IF;
1165:

Line 1166: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );

1162: l_return_status := x_return_status;
1163: END IF;
1164: END IF;
1165:
1166: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
1167:
1168: EXCEPTION
1169: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1170: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 1169: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1165:
1166: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
1167:
1168: EXCEPTION
1169: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1170: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1171: l_api_name,
1172: G_PKG_NAME,
1173: 'OKL_API.G_RET_STS_ERROR',

Line 1170: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1166: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
1167:
1168: EXCEPTION
1169: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1170: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1171: l_api_name,
1172: G_PKG_NAME,
1173: 'OKL_API.G_RET_STS_ERROR',
1174: x_msg_count,

Line 1173: 'OKL_API.G_RET_STS_ERROR',

1169: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1170: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1171: l_api_name,
1172: G_PKG_NAME,
1173: 'OKL_API.G_RET_STS_ERROR',
1174: x_msg_count,
1175: x_msg_data,
1176: '_PVT');
1177:

Line 1178: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1174: x_msg_count,
1175: x_msg_data,
1176: '_PVT');
1177:
1178: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1179: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
1180: l_api_name,
1181: G_PKG_NAME,
1182: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1179: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

1175: x_msg_data,
1176: '_PVT');
1177:
1178: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1179: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
1180: l_api_name,
1181: G_PKG_NAME,
1182: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1183: x_msg_count,

Line 1182: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1178: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1179: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
1180: l_api_name,
1181: G_PKG_NAME,
1182: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1183: x_msg_count,
1184: x_msg_data,
1185: '_PVT');
1186:

Line 1188: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

1184: x_msg_data,
1185: '_PVT');
1186:
1187: WHEN OTHERS THEN
1188: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
1189: l_api_name,
1190: G_PKG_NAME,
1191: 'OTHERS',
1192: x_msg_count,

Line 1200: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

1196: END lock_report_parameters;
1197:
1198: PROCEDURE create_report_parameters(
1199: p_api_version IN NUMBER,
1200: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
1201: x_return_status OUT NOCOPY VARCHAR2,
1202: x_msg_count OUT NOCOPY NUMBER,
1203: x_msg_data OUT NOCOPY VARCHAR2,
1204: p_rpp_tbl IN rpp_tbl_type,

Line 1208: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

1204: p_rpp_tbl IN rpp_tbl_type,
1205: x_rpp_tbl OUT NOCOPY rpp_tbl_type
1206: ) IS
1207:
1208: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1209: l_api_name VARCHAR2(30) := 'CREATE_REPORT_PARAMETERS';
1210:
1211: BEGIN
1212: -- Call start_activity to create savepoint, check compatibility

Line 1214: l_return_status := OKL_API.START_ACTIVITY (

1210:
1211: BEGIN
1212: -- Call start_activity to create savepoint, check compatibility
1213: -- and initialize message list
1214: l_return_status := OKL_API.START_ACTIVITY (
1215: l_api_name,
1216: p_init_msg_list,
1217: '_PVT',
1218: l_return_status);

Line 1221: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1217: '_PVT',
1218: l_return_status);
1219:
1220: -- Check if activity started successfully
1221: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1222: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1223: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1224: RAISE OKL_API.G_EXCEPTION_ERROR;
1225: END IF;

Line 1222: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1218: l_return_status);
1219:
1220: -- Check if activity started successfully
1221: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1222: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1223: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1224: RAISE OKL_API.G_EXCEPTION_ERROR;
1225: END IF;
1226:

Line 1223: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

1219:
1220: -- Check if activity started successfully
1221: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1222: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1223: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1224: RAISE OKL_API.G_EXCEPTION_ERROR;
1225: END IF;
1226:
1227: -- Tapi Call

Line 1224: RAISE OKL_API.G_EXCEPTION_ERROR;

1220: -- Check if activity started successfully
1221: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1222: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1223: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1224: RAISE OKL_API.G_EXCEPTION_ERROR;
1225: END IF;
1226:
1227: -- Tapi Call
1228: Okl_Rpp_Pvt.insert_row(

Line 1237: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

1233: x_msg_data,
1234: p_rpp_tbl,
1235: x_rpp_tbl);
1236:
1237: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1238: RAISE G_EXCEPTION_HALT_VALIDATION;
1239: ELSE
1240: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
1241: l_return_status := x_return_status;

Line 1240: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

1236:
1237: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1238: RAISE G_EXCEPTION_HALT_VALIDATION;
1239: ELSE
1240: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
1241: l_return_status := x_return_status;
1242: END IF;
1243: END IF;
1244:

Line 1245: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );

1241: l_return_status := x_return_status;
1242: END IF;
1243: END IF;
1244:
1245: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
1246:
1247: EXCEPTION
1248: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1249: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 1248: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1244:
1245: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
1246:
1247: EXCEPTION
1248: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1249: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1250: l_api_name,
1251: G_PKG_NAME,
1252: 'OKL_API.G_RET_STS_ERROR',

Line 1249: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1245: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
1246:
1247: EXCEPTION
1248: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1249: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1250: l_api_name,
1251: G_PKG_NAME,
1252: 'OKL_API.G_RET_STS_ERROR',
1253: x_msg_count,

Line 1252: 'OKL_API.G_RET_STS_ERROR',

1248: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1249: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1250: l_api_name,
1251: G_PKG_NAME,
1252: 'OKL_API.G_RET_STS_ERROR',
1253: x_msg_count,
1254: x_msg_data,
1255: '_PVT');
1256:

Line 1257: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1253: x_msg_count,
1254: x_msg_data,
1255: '_PVT');
1256:
1257: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1258: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
1259: l_api_name,
1260: G_PKG_NAME,
1261: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1258: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

1254: x_msg_data,
1255: '_PVT');
1256:
1257: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1258: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
1259: l_api_name,
1260: G_PKG_NAME,
1261: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1262: x_msg_count,

Line 1261: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1257: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1258: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
1259: l_api_name,
1260: G_PKG_NAME,
1261: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1262: x_msg_count,
1263: x_msg_data,
1264: '_PVT');
1265:

Line 1267: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

1263: x_msg_data,
1264: '_PVT');
1265:
1266: WHEN OTHERS THEN
1267: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
1268: l_api_name,
1269: G_PKG_NAME,
1270: 'OTHERS',
1271: x_msg_count,

Line 1279: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

1275: END create_report_parameters;
1276:
1277: PROCEDURE update_report_parameters(
1278: p_api_version IN NUMBER,
1279: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
1280: x_return_status OUT NOCOPY VARCHAR2,
1281: x_msg_count OUT NOCOPY NUMBER,
1282: x_msg_data OUT NOCOPY VARCHAR2,
1283: p_rpp_tbl IN rpp_tbl_type,

Line 1287: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

1283: p_rpp_tbl IN rpp_tbl_type,
1284: x_rpp_tbl OUT NOCOPY rpp_tbl_type
1285: ) IS
1286:
1287: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1288: l_api_name VARCHAR2(30) := 'UPDATE_REPORT_PARAMETERS';
1289:
1290: BEGIN
1291: -- Call start_activity to create savepoint, check compatibility

Line 1293: l_return_status := OKL_API.START_ACTIVITY (

1289:
1290: BEGIN
1291: -- Call start_activity to create savepoint, check compatibility
1292: -- and initialize message list
1293: l_return_status := OKL_API.START_ACTIVITY (
1294: l_api_name,
1295: p_init_msg_list,
1296: '_PVT',
1297: l_return_status);

Line 1300: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1296: '_PVT',
1297: l_return_status);
1298:
1299: -- Check if activity started successfully
1300: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1301: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1302: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1303: RAISE OKL_API.G_EXCEPTION_ERROR;
1304: END IF;

Line 1301: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1297: l_return_status);
1298:
1299: -- Check if activity started successfully
1300: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1301: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1302: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1303: RAISE OKL_API.G_EXCEPTION_ERROR;
1304: END IF;
1305:

Line 1302: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

1298:
1299: -- Check if activity started successfully
1300: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1301: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1302: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1303: RAISE OKL_API.G_EXCEPTION_ERROR;
1304: END IF;
1305:
1306: -- Tapi Call

Line 1303: RAISE OKL_API.G_EXCEPTION_ERROR;

1299: -- Check if activity started successfully
1300: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1301: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1302: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1303: RAISE OKL_API.G_EXCEPTION_ERROR;
1304: END IF;
1305:
1306: -- Tapi Call
1307: Okl_Rpp_Pvt.update_row(

Line 1316: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

1312: x_msg_data,
1313: p_rpp_tbl,
1314: x_rpp_tbl);
1315:
1316: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1317: RAISE G_EXCEPTION_HALT_VALIDATION;
1318: ELSE
1319: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
1320: l_return_status := x_return_status;

Line 1319: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

1315:
1316: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1317: RAISE G_EXCEPTION_HALT_VALIDATION;
1318: ELSE
1319: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
1320: l_return_status := x_return_status;
1321: END IF;
1322: END IF;
1323:

Line 1324: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );

1320: l_return_status := x_return_status;
1321: END IF;
1322: END IF;
1323:
1324: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
1325:
1326: EXCEPTION
1327: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1328: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 1327: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1323:
1324: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
1325:
1326: EXCEPTION
1327: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1328: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1329: l_api_name,
1330: G_PKG_NAME,
1331: 'OKL_API.G_RET_STS_ERROR',

Line 1328: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1324: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
1325:
1326: EXCEPTION
1327: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1328: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1329: l_api_name,
1330: G_PKG_NAME,
1331: 'OKL_API.G_RET_STS_ERROR',
1332: x_msg_count,

Line 1331: 'OKL_API.G_RET_STS_ERROR',

1327: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1328: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1329: l_api_name,
1330: G_PKG_NAME,
1331: 'OKL_API.G_RET_STS_ERROR',
1332: x_msg_count,
1333: x_msg_data,
1334: '_PVT');
1335:

Line 1336: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1332: x_msg_count,
1333: x_msg_data,
1334: '_PVT');
1335:
1336: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1337: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
1338: l_api_name,
1339: G_PKG_NAME,
1340: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1337: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

1333: x_msg_data,
1334: '_PVT');
1335:
1336: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1337: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
1338: l_api_name,
1339: G_PKG_NAME,
1340: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1341: x_msg_count,

Line 1340: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1336: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1337: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
1338: l_api_name,
1339: G_PKG_NAME,
1340: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1341: x_msg_count,
1342: x_msg_data,
1343: '_PVT');
1344:

Line 1346: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

1342: x_msg_data,
1343: '_PVT');
1344:
1345: WHEN OTHERS THEN
1346: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
1347: l_api_name,
1348: G_PKG_NAME,
1349: 'OTHERS',
1350: x_msg_count,

Line 1358: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

1354: END update_report_parameters;
1355:
1356: PROCEDURE delete_report_parameters(
1357: p_api_version IN NUMBER,
1358: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
1359: x_return_status OUT NOCOPY VARCHAR2,
1360: x_msg_count OUT NOCOPY NUMBER,
1361: x_msg_data OUT NOCOPY VARCHAR2,
1362: p_rpp_tbl IN rpp_tbl_type

Line 1365: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

1361: x_msg_data OUT NOCOPY VARCHAR2,
1362: p_rpp_tbl IN rpp_tbl_type
1363: ) IS
1364:
1365: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1366: l_api_name VARCHAR2(30) := 'DELETE_REPORT_PARAMETERS';
1367:
1368: BEGIN
1369: -- Call start_activity to create savepoint, check compatibility

Line 1371: l_return_status := OKL_API.START_ACTIVITY (

1367:
1368: BEGIN
1369: -- Call start_activity to create savepoint, check compatibility
1370: -- and initialize message list
1371: l_return_status := OKL_API.START_ACTIVITY (
1372: l_api_name,
1373: p_init_msg_list,
1374: '_PVT',
1375: l_return_status);

Line 1378: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1374: '_PVT',
1375: l_return_status);
1376:
1377: -- Check if activity started successfully
1378: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1379: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1380: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1381: RAISE OKL_API.G_EXCEPTION_ERROR;
1382: END IF;

Line 1379: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1375: l_return_status);
1376:
1377: -- Check if activity started successfully
1378: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1379: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1380: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1381: RAISE OKL_API.G_EXCEPTION_ERROR;
1382: END IF;
1383:

Line 1380: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

1376:
1377: -- Check if activity started successfully
1378: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1379: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1380: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1381: RAISE OKL_API.G_EXCEPTION_ERROR;
1382: END IF;
1383:
1384: -- Tapi Call

Line 1381: RAISE OKL_API.G_EXCEPTION_ERROR;

1377: -- Check if activity started successfully
1378: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1379: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1380: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1381: RAISE OKL_API.G_EXCEPTION_ERROR;
1382: END IF;
1383:
1384: -- Tapi Call
1385: Okl_Rpp_Pvt.delete_row(

Line 1393: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

1389: x_msg_count,
1390: x_msg_data,
1391: p_rpp_tbl);
1392:
1393: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1394: RAISE G_EXCEPTION_HALT_VALIDATION;
1395: ELSE
1396: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
1397: l_return_status := x_return_status;

Line 1396: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

1392:
1393: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1394: RAISE G_EXCEPTION_HALT_VALIDATION;
1395: ELSE
1396: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
1397: l_return_status := x_return_status;
1398: END IF;
1399: END IF;
1400:

Line 1401: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );

1397: l_return_status := x_return_status;
1398: END IF;
1399: END IF;
1400:
1401: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
1402:
1403: EXCEPTION
1404: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1405: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 1404: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1400:
1401: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
1402:
1403: EXCEPTION
1404: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1405: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1406: l_api_name,
1407: G_PKG_NAME,
1408: 'OKL_API.G_RET_STS_ERROR',

Line 1405: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1401: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
1402:
1403: EXCEPTION
1404: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1405: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1406: l_api_name,
1407: G_PKG_NAME,
1408: 'OKL_API.G_RET_STS_ERROR',
1409: x_msg_count,

Line 1408: 'OKL_API.G_RET_STS_ERROR',

1404: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1405: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1406: l_api_name,
1407: G_PKG_NAME,
1408: 'OKL_API.G_RET_STS_ERROR',
1409: x_msg_count,
1410: x_msg_data,
1411: '_PVT');
1412:

Line 1413: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1409: x_msg_count,
1410: x_msg_data,
1411: '_PVT');
1412:
1413: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1414: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
1415: l_api_name,
1416: G_PKG_NAME,
1417: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1414: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

1410: x_msg_data,
1411: '_PVT');
1412:
1413: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1414: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
1415: l_api_name,
1416: G_PKG_NAME,
1417: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1418: x_msg_count,

Line 1417: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1413: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1414: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
1415: l_api_name,
1416: G_PKG_NAME,
1417: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1418: x_msg_count,
1419: x_msg_data,
1420: '_PVT');
1421:

Line 1423: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

1419: x_msg_data,
1420: '_PVT');
1421:
1422: WHEN OTHERS THEN
1423: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
1424: l_api_name,
1425: G_PKG_NAME,
1426: 'OTHERS',
1427: x_msg_count,

Line 1435: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

1431: END delete_report_parameters;
1432:
1433: PROCEDURE lock_report_parameters(
1434: p_api_version IN NUMBER,
1435: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
1436: x_return_status OUT NOCOPY VARCHAR2,
1437: x_msg_count OUT NOCOPY NUMBER,
1438: x_msg_data OUT NOCOPY VARCHAR2,
1439: p_rpp_tbl IN rpp_tbl_type

Line 1442: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

1438: x_msg_data OUT NOCOPY VARCHAR2,
1439: p_rpp_tbl IN rpp_tbl_type
1440: ) IS
1441:
1442: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1443: l_api_name VARCHAR2(30) := 'LOCK_REPORT_PARAMETERS';
1444:
1445: BEGIN
1446: -- Call start_activity to create savepoint, check compatibility

Line 1448: l_return_status := OKL_API.START_ACTIVITY (

1444:
1445: BEGIN
1446: -- Call start_activity to create savepoint, check compatibility
1447: -- and initialize message list
1448: l_return_status := OKL_API.START_ACTIVITY (
1449: l_api_name,
1450: p_init_msg_list,
1451: '_PVT',
1452: l_return_status);

Line 1455: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1451: '_PVT',
1452: l_return_status);
1453:
1454: -- Check if activity started successfully
1455: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1456: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1457: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1458: RAISE OKL_API.G_EXCEPTION_ERROR;
1459: END IF;

Line 1456: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1452: l_return_status);
1453:
1454: -- Check if activity started successfully
1455: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1456: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1457: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1458: RAISE OKL_API.G_EXCEPTION_ERROR;
1459: END IF;
1460:

Line 1457: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

1453:
1454: -- Check if activity started successfully
1455: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1456: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1457: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1458: RAISE OKL_API.G_EXCEPTION_ERROR;
1459: END IF;
1460:
1461: -- Tapi Call

Line 1458: RAISE OKL_API.G_EXCEPTION_ERROR;

1454: -- Check if activity started successfully
1455: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1456: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1457: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1458: RAISE OKL_API.G_EXCEPTION_ERROR;
1459: END IF;
1460:
1461: -- Tapi Call
1462: Okl_Rpp_Pvt.lock_row(

Line 1470: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

1466: x_msg_count,
1467: x_msg_data,
1468: p_rpp_tbl);
1469:
1470: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1471: RAISE G_EXCEPTION_HALT_VALIDATION;
1472: ELSE
1473: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
1474: l_return_status := x_return_status;

Line 1473: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

1469:
1470: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1471: RAISE G_EXCEPTION_HALT_VALIDATION;
1472: ELSE
1473: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
1474: l_return_status := x_return_status;
1475: END IF;
1476: END IF;
1477:

Line 1478: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );

1474: l_return_status := x_return_status;
1475: END IF;
1476: END IF;
1477:
1478: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
1479:
1480: EXCEPTION
1481: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1482: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 1481: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1477:
1478: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
1479:
1480: EXCEPTION
1481: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1482: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1483: l_api_name,
1484: G_PKG_NAME,
1485: 'OKL_API.G_RET_STS_ERROR',

Line 1482: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1478: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
1479:
1480: EXCEPTION
1481: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1482: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1483: l_api_name,
1484: G_PKG_NAME,
1485: 'OKL_API.G_RET_STS_ERROR',
1486: x_msg_count,

Line 1485: 'OKL_API.G_RET_STS_ERROR',

1481: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1482: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1483: l_api_name,
1484: G_PKG_NAME,
1485: 'OKL_API.G_RET_STS_ERROR',
1486: x_msg_count,
1487: x_msg_data,
1488: '_PVT');
1489:

Line 1490: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1486: x_msg_count,
1487: x_msg_data,
1488: '_PVT');
1489:
1490: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1491: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
1492: l_api_name,
1493: G_PKG_NAME,
1494: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1491: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

1487: x_msg_data,
1488: '_PVT');
1489:
1490: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1491: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
1492: l_api_name,
1493: G_PKG_NAME,
1494: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1495: x_msg_count,

Line 1494: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1490: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1491: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
1492: l_api_name,
1493: G_PKG_NAME,
1494: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1495: x_msg_count,
1496: x_msg_data,
1497: '_PVT');
1498:

Line 1500: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

1496: x_msg_data,
1497: '_PVT');
1498:
1499: WHEN OTHERS THEN
1500: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
1501: l_api_name,
1502: G_PKG_NAME,
1503: 'OTHERS',
1504: x_msg_count,

Line 1512: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

1508: END lock_report_parameters;
1509:
1510: PROCEDURE create_report_acc_parameters(
1511: p_api_version IN NUMBER,
1512: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
1513: x_return_status OUT NOCOPY VARCHAR2,
1514: x_msg_count OUT NOCOPY NUMBER,
1515: x_msg_data OUT NOCOPY VARCHAR2,
1516: p_rap_rec IN rap_rec_type,

Line 1520: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

1516: p_rap_rec IN rap_rec_type,
1517: x_rap_rec OUT NOCOPY rap_rec_type
1518: ) IS
1519:
1520: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1521: l_api_name VARCHAR2(30) := 'CREATE_REPORT_ACC_PARAMS';
1522:
1523: BEGIN
1524: -- Call start_activity to create savepoint, check compatibility

Line 1526: l_return_status := OKL_API.START_ACTIVITY (

1522:
1523: BEGIN
1524: -- Call start_activity to create savepoint, check compatibility
1525: -- and initialize message list
1526: l_return_status := OKL_API.START_ACTIVITY (
1527: l_api_name,
1528: p_init_msg_list,
1529: '_PVT',
1530: l_return_status);

Line 1533: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1529: '_PVT',
1530: l_return_status);
1531:
1532: -- Check if activity started successfully
1533: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1534: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1535: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1536: RAISE OKL_API.G_EXCEPTION_ERROR;
1537: END IF;

Line 1534: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1530: l_return_status);
1531:
1532: -- Check if activity started successfully
1533: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1534: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1535: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1536: RAISE OKL_API.G_EXCEPTION_ERROR;
1537: END IF;
1538:

Line 1535: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

1531:
1532: -- Check if activity started successfully
1533: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1534: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1535: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1536: RAISE OKL_API.G_EXCEPTION_ERROR;
1537: END IF;
1538:
1539: -- Tapi Call

Line 1536: RAISE OKL_API.G_EXCEPTION_ERROR;

1532: -- Check if activity started successfully
1533: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1534: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1535: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1536: RAISE OKL_API.G_EXCEPTION_ERROR;
1537: END IF;
1538:
1539: -- Tapi Call
1540: Okl_Rap_Pvt.insert_row(

Line 1549: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

1545: x_msg_data,
1546: p_rap_rec,
1547: x_rap_rec);
1548:
1549: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1550: RAISE G_EXCEPTION_HALT_VALIDATION;
1551: ELSE
1552: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
1553: l_return_status := x_return_status;

Line 1552: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

1548:
1549: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1550: RAISE G_EXCEPTION_HALT_VALIDATION;
1551: ELSE
1552: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
1553: l_return_status := x_return_status;
1554: END IF;
1555: END IF;
1556:

Line 1557: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );

1553: l_return_status := x_return_status;
1554: END IF;
1555: END IF;
1556:
1557: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
1558:
1559: EXCEPTION
1560: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1561: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 1560: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1556:
1557: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
1558:
1559: EXCEPTION
1560: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1561: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1562: l_api_name,
1563: G_PKG_NAME,
1564: 'OKL_API.G_RET_STS_ERROR',

Line 1561: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1557: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
1558:
1559: EXCEPTION
1560: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1561: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1562: l_api_name,
1563: G_PKG_NAME,
1564: 'OKL_API.G_RET_STS_ERROR',
1565: x_msg_count,

Line 1564: 'OKL_API.G_RET_STS_ERROR',

1560: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1561: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1562: l_api_name,
1563: G_PKG_NAME,
1564: 'OKL_API.G_RET_STS_ERROR',
1565: x_msg_count,
1566: x_msg_data,
1567: '_PVT');
1568:

Line 1569: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1565: x_msg_count,
1566: x_msg_data,
1567: '_PVT');
1568:
1569: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1570: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
1571: l_api_name,
1572: G_PKG_NAME,
1573: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1570: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

1566: x_msg_data,
1567: '_PVT');
1568:
1569: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1570: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
1571: l_api_name,
1572: G_PKG_NAME,
1573: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1574: x_msg_count,

Line 1573: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1569: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1570: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
1571: l_api_name,
1572: G_PKG_NAME,
1573: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1574: x_msg_count,
1575: x_msg_data,
1576: '_PVT');
1577:

Line 1579: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

1575: x_msg_data,
1576: '_PVT');
1577:
1578: WHEN OTHERS THEN
1579: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
1580: l_api_name,
1581: G_PKG_NAME,
1582: 'OTHERS',
1583: x_msg_count,

Line 1591: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

1587: END create_report_acc_parameters;
1588:
1589: PROCEDURE update_report_acc_parameters(
1590: p_api_version IN NUMBER,
1591: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
1592: x_return_status OUT NOCOPY VARCHAR2,
1593: x_msg_count OUT NOCOPY NUMBER,
1594: x_msg_data OUT NOCOPY VARCHAR2,
1595: p_rap_rec IN rap_rec_type,

Line 1599: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

1595: p_rap_rec IN rap_rec_type,
1596: x_rap_rec OUT NOCOPY rap_rec_type
1597: ) IS
1598:
1599: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1600: l_api_name VARCHAR2(30) := 'UPDATE_REPORT_ACC_PARAMS';
1601:
1602: BEGIN
1603: -- Call start_activity to create savepoint, check compatibility

Line 1605: l_return_status := OKL_API.START_ACTIVITY (

1601:
1602: BEGIN
1603: -- Call start_activity to create savepoint, check compatibility
1604: -- and initialize message list
1605: l_return_status := OKL_API.START_ACTIVITY (
1606: l_api_name,
1607: p_init_msg_list,
1608: '_PVT',
1609: l_return_status);

Line 1612: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1608: '_PVT',
1609: l_return_status);
1610:
1611: -- Check if activity started successfully
1612: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1613: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1614: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1615: RAISE OKL_API.G_EXCEPTION_ERROR;
1616: END IF;

Line 1613: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1609: l_return_status);
1610:
1611: -- Check if activity started successfully
1612: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1613: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1614: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1615: RAISE OKL_API.G_EXCEPTION_ERROR;
1616: END IF;
1617:

Line 1614: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

1610:
1611: -- Check if activity started successfully
1612: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1613: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1614: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1615: RAISE OKL_API.G_EXCEPTION_ERROR;
1616: END IF;
1617:
1618: -- Tapi Call

Line 1615: RAISE OKL_API.G_EXCEPTION_ERROR;

1611: -- Check if activity started successfully
1612: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1613: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1614: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1615: RAISE OKL_API.G_EXCEPTION_ERROR;
1616: END IF;
1617:
1618: -- Tapi Call
1619: Okl_Rap_Pvt.update_row(

Line 1628: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

1624: x_msg_data,
1625: p_rap_rec,
1626: x_rap_rec);
1627:
1628: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1629: RAISE G_EXCEPTION_HALT_VALIDATION;
1630: ELSE
1631: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
1632: l_return_status := x_return_status;

Line 1631: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

1627:
1628: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1629: RAISE G_EXCEPTION_HALT_VALIDATION;
1630: ELSE
1631: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
1632: l_return_status := x_return_status;
1633: END IF;
1634: END IF;
1635:

Line 1636: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );

1632: l_return_status := x_return_status;
1633: END IF;
1634: END IF;
1635:
1636: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
1637:
1638: EXCEPTION
1639: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1640: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 1639: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1635:
1636: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
1637:
1638: EXCEPTION
1639: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1640: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1641: l_api_name,
1642: G_PKG_NAME,
1643: 'OKL_API.G_RET_STS_ERROR',

Line 1640: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1636: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
1637:
1638: EXCEPTION
1639: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1640: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1641: l_api_name,
1642: G_PKG_NAME,
1643: 'OKL_API.G_RET_STS_ERROR',
1644: x_msg_count,

Line 1643: 'OKL_API.G_RET_STS_ERROR',

1639: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1640: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1641: l_api_name,
1642: G_PKG_NAME,
1643: 'OKL_API.G_RET_STS_ERROR',
1644: x_msg_count,
1645: x_msg_data,
1646: '_PVT');
1647:

Line 1648: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1644: x_msg_count,
1645: x_msg_data,
1646: '_PVT');
1647:
1648: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1649: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
1650: l_api_name,
1651: G_PKG_NAME,
1652: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1649: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

1645: x_msg_data,
1646: '_PVT');
1647:
1648: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1649: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
1650: l_api_name,
1651: G_PKG_NAME,
1652: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1653: x_msg_count,

Line 1652: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1648: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1649: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
1650: l_api_name,
1651: G_PKG_NAME,
1652: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1653: x_msg_count,
1654: x_msg_data,
1655: '_PVT');
1656:

Line 1658: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

1654: x_msg_data,
1655: '_PVT');
1656:
1657: WHEN OTHERS THEN
1658: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
1659: l_api_name,
1660: G_PKG_NAME,
1661: 'OTHERS',
1662: x_msg_count,

Line 1670: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

1666: END update_report_acc_parameters;
1667:
1668: PROCEDURE delete_report_acc_parameters(
1669: p_api_version IN NUMBER,
1670: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
1671: x_return_status OUT NOCOPY VARCHAR2,
1672: x_msg_count OUT NOCOPY NUMBER,
1673: x_msg_data OUT NOCOPY VARCHAR2,
1674: p_rap_rec IN rap_rec_type

Line 1677: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

1673: x_msg_data OUT NOCOPY VARCHAR2,
1674: p_rap_rec IN rap_rec_type
1675: ) IS
1676:
1677: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1678: l_api_name VARCHAR2(30) := 'DELETE_REPORT_ACC_PARAMS';
1679:
1680: BEGIN
1681: -- Call start_activity to create savepoint, check compatibility

Line 1683: l_return_status := OKL_API.START_ACTIVITY (

1679:
1680: BEGIN
1681: -- Call start_activity to create savepoint, check compatibility
1682: -- and initialize message list
1683: l_return_status := OKL_API.START_ACTIVITY (
1684: l_api_name,
1685: p_init_msg_list,
1686: '_PVT',
1687: l_return_status);

Line 1690: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1686: '_PVT',
1687: l_return_status);
1688:
1689: -- Check if activity started successfully
1690: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1691: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1692: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1693: RAISE OKL_API.G_EXCEPTION_ERROR;
1694: END IF;

Line 1691: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1687: l_return_status);
1688:
1689: -- Check if activity started successfully
1690: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1691: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1692: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1693: RAISE OKL_API.G_EXCEPTION_ERROR;
1694: END IF;
1695:

Line 1692: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

1688:
1689: -- Check if activity started successfully
1690: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1691: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1692: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1693: RAISE OKL_API.G_EXCEPTION_ERROR;
1694: END IF;
1695:
1696: -- Tapi Call

Line 1693: RAISE OKL_API.G_EXCEPTION_ERROR;

1689: -- Check if activity started successfully
1690: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1691: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1692: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1693: RAISE OKL_API.G_EXCEPTION_ERROR;
1694: END IF;
1695:
1696: -- Tapi Call
1697: Okl_Rap_Pvt.delete_row(

Line 1705: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

1701: x_msg_count,
1702: x_msg_data,
1703: p_rap_rec);
1704:
1705: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1706: RAISE G_EXCEPTION_HALT_VALIDATION;
1707: ELSE
1708: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
1709: l_return_status := x_return_status;

Line 1708: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

1704:
1705: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1706: RAISE G_EXCEPTION_HALT_VALIDATION;
1707: ELSE
1708: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
1709: l_return_status := x_return_status;
1710: END IF;
1711: END IF;
1712:

Line 1713: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );

1709: l_return_status := x_return_status;
1710: END IF;
1711: END IF;
1712:
1713: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
1714:
1715: EXCEPTION
1716: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1717: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 1716: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1712:
1713: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
1714:
1715: EXCEPTION
1716: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1717: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1718: l_api_name,
1719: G_PKG_NAME,
1720: 'OKL_API.G_RET_STS_ERROR',

Line 1717: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1713: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
1714:
1715: EXCEPTION
1716: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1717: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1718: l_api_name,
1719: G_PKG_NAME,
1720: 'OKL_API.G_RET_STS_ERROR',
1721: x_msg_count,

Line 1720: 'OKL_API.G_RET_STS_ERROR',

1716: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1717: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1718: l_api_name,
1719: G_PKG_NAME,
1720: 'OKL_API.G_RET_STS_ERROR',
1721: x_msg_count,
1722: x_msg_data,
1723: '_PVT');
1724:

Line 1725: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1721: x_msg_count,
1722: x_msg_data,
1723: '_PVT');
1724:
1725: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1726: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
1727: l_api_name,
1728: G_PKG_NAME,
1729: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1726: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

1722: x_msg_data,
1723: '_PVT');
1724:
1725: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1726: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
1727: l_api_name,
1728: G_PKG_NAME,
1729: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1730: x_msg_count,

Line 1729: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1725: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1726: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
1727: l_api_name,
1728: G_PKG_NAME,
1729: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1730: x_msg_count,
1731: x_msg_data,
1732: '_PVT');
1733:

Line 1735: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

1731: x_msg_data,
1732: '_PVT');
1733:
1734: WHEN OTHERS THEN
1735: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
1736: l_api_name,
1737: G_PKG_NAME,
1738: 'OTHERS',
1739: x_msg_count,

Line 1747: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

1743: END delete_report_acc_parameters;
1744:
1745: PROCEDURE lock_report_acc_parameters(
1746: p_api_version IN NUMBER,
1747: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
1748: x_return_status OUT NOCOPY VARCHAR2,
1749: x_msg_count OUT NOCOPY NUMBER,
1750: x_msg_data OUT NOCOPY VARCHAR2,
1751: p_rap_rec IN rap_rec_type

Line 1754: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

1750: x_msg_data OUT NOCOPY VARCHAR2,
1751: p_rap_rec IN rap_rec_type
1752: ) IS
1753:
1754: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1755: l_api_name VARCHAR2(30) := 'LOCK_REPORT_ACC_PARAMS';
1756:
1757: BEGIN
1758: -- Call start_activity to create savepoint, check compatibility

Line 1760: l_return_status := OKL_API.START_ACTIVITY (

1756:
1757: BEGIN
1758: -- Call start_activity to create savepoint, check compatibility
1759: -- and initialize message list
1760: l_return_status := OKL_API.START_ACTIVITY (
1761: l_api_name,
1762: p_init_msg_list,
1763: '_PVT',
1764: l_return_status);

Line 1767: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1763: '_PVT',
1764: l_return_status);
1765:
1766: -- Check if activity started successfully
1767: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1768: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1769: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1770: RAISE OKL_API.G_EXCEPTION_ERROR;
1771: END IF;

Line 1768: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1764: l_return_status);
1765:
1766: -- Check if activity started successfully
1767: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1768: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1769: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1770: RAISE OKL_API.G_EXCEPTION_ERROR;
1771: END IF;
1772:

Line 1769: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

1765:
1766: -- Check if activity started successfully
1767: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1768: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1769: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1770: RAISE OKL_API.G_EXCEPTION_ERROR;
1771: END IF;
1772:
1773: -- Tapi Call

Line 1770: RAISE OKL_API.G_EXCEPTION_ERROR;

1766: -- Check if activity started successfully
1767: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1768: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1769: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1770: RAISE OKL_API.G_EXCEPTION_ERROR;
1771: END IF;
1772:
1773: -- Tapi Call
1774: Okl_Rap_Pvt.lock_row(

Line 1782: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

1778: x_msg_count,
1779: x_msg_data,
1780: p_rap_rec);
1781:
1782: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1783: RAISE G_EXCEPTION_HALT_VALIDATION;
1784: ELSE
1785: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
1786: l_return_status := x_return_status;

Line 1785: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

1781:
1782: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1783: RAISE G_EXCEPTION_HALT_VALIDATION;
1784: ELSE
1785: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
1786: l_return_status := x_return_status;
1787: END IF;
1788: END IF;
1789:

Line 1790: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );

1786: l_return_status := x_return_status;
1787: END IF;
1788: END IF;
1789:
1790: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
1791:
1792: EXCEPTION
1793: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1794: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 1793: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1789:
1790: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
1791:
1792: EXCEPTION
1793: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1794: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1795: l_api_name,
1796: G_PKG_NAME,
1797: 'OKL_API.G_RET_STS_ERROR',

Line 1794: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1790: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
1791:
1792: EXCEPTION
1793: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1794: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1795: l_api_name,
1796: G_PKG_NAME,
1797: 'OKL_API.G_RET_STS_ERROR',
1798: x_msg_count,

Line 1797: 'OKL_API.G_RET_STS_ERROR',

1793: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1794: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1795: l_api_name,
1796: G_PKG_NAME,
1797: 'OKL_API.G_RET_STS_ERROR',
1798: x_msg_count,
1799: x_msg_data,
1800: '_PVT');
1801:

Line 1802: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1798: x_msg_count,
1799: x_msg_data,
1800: '_PVT');
1801:
1802: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1803: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
1804: l_api_name,
1805: G_PKG_NAME,
1806: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1803: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

1799: x_msg_data,
1800: '_PVT');
1801:
1802: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1803: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
1804: l_api_name,
1805: G_PKG_NAME,
1806: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1807: x_msg_count,

Line 1806: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1802: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1803: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
1804: l_api_name,
1805: G_PKG_NAME,
1806: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1807: x_msg_count,
1808: x_msg_data,
1809: '_PVT');
1810:

Line 1812: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

1808: x_msg_data,
1809: '_PVT');
1810:
1811: WHEN OTHERS THEN
1812: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
1813: l_api_name,
1814: G_PKG_NAME,
1815: 'OTHERS',
1816: x_msg_count,

Line 1824: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

1820: END lock_report_acc_parameters;
1821:
1822: PROCEDURE create_report_acc_parameters(
1823: p_api_version IN NUMBER,
1824: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
1825: x_return_status OUT NOCOPY VARCHAR2,
1826: x_msg_count OUT NOCOPY NUMBER,
1827: x_msg_data OUT NOCOPY VARCHAR2,
1828: p_rap_tbl IN rap_tbl_type,

Line 1832: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

1828: p_rap_tbl IN rap_tbl_type,
1829: x_rap_tbl OUT NOCOPY rap_tbl_type
1830: ) IS
1831:
1832: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1833: l_api_name VARCHAR2(30) := 'CREATE_REPORT_ACC_PARAMS';
1834:
1835: BEGIN
1836: -- Call start_activity to create savepoint, check compatibility

Line 1838: l_return_status := OKL_API.START_ACTIVITY (

1834:
1835: BEGIN
1836: -- Call start_activity to create savepoint, check compatibility
1837: -- and initialize message list
1838: l_return_status := OKL_API.START_ACTIVITY (
1839: l_api_name,
1840: p_init_msg_list,
1841: '_PVT',
1842: l_return_status);

Line 1845: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1841: '_PVT',
1842: l_return_status);
1843:
1844: -- Check if activity started successfully
1845: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1846: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1847: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1848: RAISE OKL_API.G_EXCEPTION_ERROR;
1849: END IF;

Line 1846: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1842: l_return_status);
1843:
1844: -- Check if activity started successfully
1845: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1846: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1847: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1848: RAISE OKL_API.G_EXCEPTION_ERROR;
1849: END IF;
1850:

Line 1847: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

1843:
1844: -- Check if activity started successfully
1845: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1846: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1847: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1848: RAISE OKL_API.G_EXCEPTION_ERROR;
1849: END IF;
1850:
1851: -- Tapi Call

Line 1848: RAISE OKL_API.G_EXCEPTION_ERROR;

1844: -- Check if activity started successfully
1845: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1846: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1847: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1848: RAISE OKL_API.G_EXCEPTION_ERROR;
1849: END IF;
1850:
1851: -- Tapi Call
1852: Okl_Rap_Pvt.insert_row(

Line 1861: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

1857: x_msg_data,
1858: p_rap_tbl,
1859: x_rap_tbl);
1860:
1861: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1862: RAISE G_EXCEPTION_HALT_VALIDATION;
1863: ELSE
1864: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
1865: l_return_status := x_return_status;

Line 1864: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

1860:
1861: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1862: RAISE G_EXCEPTION_HALT_VALIDATION;
1863: ELSE
1864: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
1865: l_return_status := x_return_status;
1866: END IF;
1867: END IF;
1868:

Line 1869: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );

1865: l_return_status := x_return_status;
1866: END IF;
1867: END IF;
1868:
1869: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
1870:
1871: EXCEPTION
1872: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1873: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 1872: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1868:
1869: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
1870:
1871: EXCEPTION
1872: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1873: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1874: l_api_name,
1875: G_PKG_NAME,
1876: 'OKL_API.G_RET_STS_ERROR',

Line 1873: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1869: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
1870:
1871: EXCEPTION
1872: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1873: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1874: l_api_name,
1875: G_PKG_NAME,
1876: 'OKL_API.G_RET_STS_ERROR',
1877: x_msg_count,

Line 1876: 'OKL_API.G_RET_STS_ERROR',

1872: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1873: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1874: l_api_name,
1875: G_PKG_NAME,
1876: 'OKL_API.G_RET_STS_ERROR',
1877: x_msg_count,
1878: x_msg_data,
1879: '_PVT');
1880:

Line 1881: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1877: x_msg_count,
1878: x_msg_data,
1879: '_PVT');
1880:
1881: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1882: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
1883: l_api_name,
1884: G_PKG_NAME,
1885: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1882: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

1878: x_msg_data,
1879: '_PVT');
1880:
1881: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1882: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
1883: l_api_name,
1884: G_PKG_NAME,
1885: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1886: x_msg_count,

Line 1885: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1881: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1882: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
1883: l_api_name,
1884: G_PKG_NAME,
1885: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1886: x_msg_count,
1887: x_msg_data,
1888: '_PVT');
1889:

Line 1891: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

1887: x_msg_data,
1888: '_PVT');
1889:
1890: WHEN OTHERS THEN
1891: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
1892: l_api_name,
1893: G_PKG_NAME,
1894: 'OTHERS',
1895: x_msg_count,

Line 1903: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

1899: END create_report_acc_parameters;
1900:
1901: PROCEDURE update_report_acc_parameters(
1902: p_api_version IN NUMBER,
1903: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
1904: x_return_status OUT NOCOPY VARCHAR2,
1905: x_msg_count OUT NOCOPY NUMBER,
1906: x_msg_data OUT NOCOPY VARCHAR2,
1907: p_rap_tbl IN rap_tbl_type,

Line 1911: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

1907: p_rap_tbl IN rap_tbl_type,
1908: x_rap_tbl OUT NOCOPY rap_tbl_type
1909: ) IS
1910:
1911: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1912: l_api_name VARCHAR2(30) := 'UPDATE_REPORT_ACC_PARAMS';
1913:
1914: BEGIN
1915: -- Call start_activity to create savepoint, check compatibility

Line 1917: l_return_status := OKL_API.START_ACTIVITY (

1913:
1914: BEGIN
1915: -- Call start_activity to create savepoint, check compatibility
1916: -- and initialize message list
1917: l_return_status := OKL_API.START_ACTIVITY (
1918: l_api_name,
1919: p_init_msg_list,
1920: '_PVT',
1921: l_return_status);

Line 1924: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1920: '_PVT',
1921: l_return_status);
1922:
1923: -- Check if activity started successfully
1924: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1925: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1926: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1927: RAISE OKL_API.G_EXCEPTION_ERROR;
1928: END IF;

Line 1925: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1921: l_return_status);
1922:
1923: -- Check if activity started successfully
1924: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1925: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1926: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1927: RAISE OKL_API.G_EXCEPTION_ERROR;
1928: END IF;
1929:

Line 1926: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

1922:
1923: -- Check if activity started successfully
1924: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1925: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1926: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1927: RAISE OKL_API.G_EXCEPTION_ERROR;
1928: END IF;
1929:
1930: -- Tapi Call

Line 1927: RAISE OKL_API.G_EXCEPTION_ERROR;

1923: -- Check if activity started successfully
1924: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1925: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1926: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1927: RAISE OKL_API.G_EXCEPTION_ERROR;
1928: END IF;
1929:
1930: -- Tapi Call
1931: Okl_Rap_Pvt.update_row(

Line 1940: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

1936: x_msg_data,
1937: p_rap_tbl,
1938: x_rap_tbl);
1939:
1940: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1941: RAISE G_EXCEPTION_HALT_VALIDATION;
1942: ELSE
1943: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
1944: l_return_status := x_return_status;

Line 1943: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

1939:
1940: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1941: RAISE G_EXCEPTION_HALT_VALIDATION;
1942: ELSE
1943: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
1944: l_return_status := x_return_status;
1945: END IF;
1946: END IF;
1947:

Line 1948: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );

1944: l_return_status := x_return_status;
1945: END IF;
1946: END IF;
1947:
1948: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
1949:
1950: EXCEPTION
1951: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1952: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 1951: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1947:
1948: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
1949:
1950: EXCEPTION
1951: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1952: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1953: l_api_name,
1954: G_PKG_NAME,
1955: 'OKL_API.G_RET_STS_ERROR',

Line 1952: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1948: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
1949:
1950: EXCEPTION
1951: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1952: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1953: l_api_name,
1954: G_PKG_NAME,
1955: 'OKL_API.G_RET_STS_ERROR',
1956: x_msg_count,

Line 1955: 'OKL_API.G_RET_STS_ERROR',

1951: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1952: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1953: l_api_name,
1954: G_PKG_NAME,
1955: 'OKL_API.G_RET_STS_ERROR',
1956: x_msg_count,
1957: x_msg_data,
1958: '_PVT');
1959:

Line 1960: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1956: x_msg_count,
1957: x_msg_data,
1958: '_PVT');
1959:
1960: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1961: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
1962: l_api_name,
1963: G_PKG_NAME,
1964: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1961: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

1957: x_msg_data,
1958: '_PVT');
1959:
1960: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1961: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
1962: l_api_name,
1963: G_PKG_NAME,
1964: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1965: x_msg_count,

Line 1964: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1960: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1961: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
1962: l_api_name,
1963: G_PKG_NAME,
1964: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1965: x_msg_count,
1966: x_msg_data,
1967: '_PVT');
1968:

Line 1970: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

1966: x_msg_data,
1967: '_PVT');
1968:
1969: WHEN OTHERS THEN
1970: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
1971: l_api_name,
1972: G_PKG_NAME,
1973: 'OTHERS',
1974: x_msg_count,

Line 1982: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

1978: END update_report_acc_parameters;
1979:
1980: PROCEDURE delete_report_acc_parameters(
1981: p_api_version IN NUMBER,
1982: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
1983: x_return_status OUT NOCOPY VARCHAR2,
1984: x_msg_count OUT NOCOPY NUMBER,
1985: x_msg_data OUT NOCOPY VARCHAR2,
1986: p_rap_tbl IN rap_tbl_type

Line 1989: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

1985: x_msg_data OUT NOCOPY VARCHAR2,
1986: p_rap_tbl IN rap_tbl_type
1987: ) IS
1988:
1989: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1990: l_api_name VARCHAR2(30) := 'DELETE_REPORT_ACC_PARAMS';
1991:
1992: BEGIN
1993: -- Call start_activity to create savepoint, check compatibility

Line 1995: l_return_status := OKL_API.START_ACTIVITY (

1991:
1992: BEGIN
1993: -- Call start_activity to create savepoint, check compatibility
1994: -- and initialize message list
1995: l_return_status := OKL_API.START_ACTIVITY (
1996: l_api_name,
1997: p_init_msg_list,
1998: '_PVT',
1999: l_return_status);

Line 2002: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1998: '_PVT',
1999: l_return_status);
2000:
2001: -- Check if activity started successfully
2002: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2003: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2004: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2005: RAISE OKL_API.G_EXCEPTION_ERROR;
2006: END IF;

Line 2003: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1999: l_return_status);
2000:
2001: -- Check if activity started successfully
2002: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2003: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2004: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2005: RAISE OKL_API.G_EXCEPTION_ERROR;
2006: END IF;
2007:

Line 2004: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

2000:
2001: -- Check if activity started successfully
2002: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2003: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2004: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2005: RAISE OKL_API.G_EXCEPTION_ERROR;
2006: END IF;
2007:
2008: -- Tapi Call

Line 2005: RAISE OKL_API.G_EXCEPTION_ERROR;

2001: -- Check if activity started successfully
2002: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2003: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2004: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2005: RAISE OKL_API.G_EXCEPTION_ERROR;
2006: END IF;
2007:
2008: -- Tapi Call
2009: Okl_Rap_Pvt.delete_row(

Line 2017: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

2013: x_msg_count,
2014: x_msg_data,
2015: p_rap_tbl);
2016:
2017: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
2018: RAISE G_EXCEPTION_HALT_VALIDATION;
2019: ELSE
2020: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
2021: l_return_status := x_return_status;

Line 2020: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

2016:
2017: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
2018: RAISE G_EXCEPTION_HALT_VALIDATION;
2019: ELSE
2020: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
2021: l_return_status := x_return_status;
2022: END IF;
2023: END IF;
2024:

Line 2025: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );

2021: l_return_status := x_return_status;
2022: END IF;
2023: END IF;
2024:
2025: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
2026:
2027: EXCEPTION
2028: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2029: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 2028: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2024:
2025: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
2026:
2027: EXCEPTION
2028: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2029: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2030: l_api_name,
2031: G_PKG_NAME,
2032: 'OKL_API.G_RET_STS_ERROR',

Line 2029: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

2025: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
2026:
2027: EXCEPTION
2028: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2029: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2030: l_api_name,
2031: G_PKG_NAME,
2032: 'OKL_API.G_RET_STS_ERROR',
2033: x_msg_count,

Line 2032: 'OKL_API.G_RET_STS_ERROR',

2028: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2029: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2030: l_api_name,
2031: G_PKG_NAME,
2032: 'OKL_API.G_RET_STS_ERROR',
2033: x_msg_count,
2034: x_msg_data,
2035: '_PVT');
2036:

Line 2037: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2033: x_msg_count,
2034: x_msg_data,
2035: '_PVT');
2036:
2037: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2038: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
2039: l_api_name,
2040: G_PKG_NAME,
2041: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 2038: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

2034: x_msg_data,
2035: '_PVT');
2036:
2037: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2038: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
2039: l_api_name,
2040: G_PKG_NAME,
2041: 'OKL_API.G_RET_STS_UNEXP_ERROR',
2042: x_msg_count,

Line 2041: 'OKL_API.G_RET_STS_UNEXP_ERROR',

2037: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2038: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
2039: l_api_name,
2040: G_PKG_NAME,
2041: 'OKL_API.G_RET_STS_UNEXP_ERROR',
2042: x_msg_count,
2043: x_msg_data,
2044: '_PVT');
2045:

Line 2047: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

2043: x_msg_data,
2044: '_PVT');
2045:
2046: WHEN OTHERS THEN
2047: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
2048: l_api_name,
2049: G_PKG_NAME,
2050: 'OTHERS',
2051: x_msg_count,

Line 2059: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

2055: END delete_report_acc_parameters;
2056:
2057: PROCEDURE lock_report_acc_parameters(
2058: p_api_version IN NUMBER,
2059: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
2060: x_return_status OUT NOCOPY VARCHAR2,
2061: x_msg_count OUT NOCOPY NUMBER,
2062: x_msg_data OUT NOCOPY VARCHAR2,
2063: p_rap_tbl IN rap_tbl_type

Line 2066: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

2062: x_msg_data OUT NOCOPY VARCHAR2,
2063: p_rap_tbl IN rap_tbl_type
2064: ) IS
2065:
2066: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2067: l_api_name VARCHAR2(30) := 'LOCK_REPORT_ACC_PARAMS';
2068:
2069: BEGIN
2070: -- Call start_activity to create savepoint, check compatibility

Line 2072: l_return_status := OKL_API.START_ACTIVITY (

2068:
2069: BEGIN
2070: -- Call start_activity to create savepoint, check compatibility
2071: -- and initialize message list
2072: l_return_status := OKL_API.START_ACTIVITY (
2073: l_api_name,
2074: p_init_msg_list,
2075: '_PVT',
2076: l_return_status);

Line 2079: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

2075: '_PVT',
2076: l_return_status);
2077:
2078: -- Check if activity started successfully
2079: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2080: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2081: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2082: RAISE OKL_API.G_EXCEPTION_ERROR;
2083: END IF;

Line 2080: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2076: l_return_status);
2077:
2078: -- Check if activity started successfully
2079: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2080: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2081: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2082: RAISE OKL_API.G_EXCEPTION_ERROR;
2083: END IF;
2084:

Line 2081: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

2077:
2078: -- Check if activity started successfully
2079: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2080: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2081: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2082: RAISE OKL_API.G_EXCEPTION_ERROR;
2083: END IF;
2084:
2085: -- Tapi Call

Line 2082: RAISE OKL_API.G_EXCEPTION_ERROR;

2078: -- Check if activity started successfully
2079: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2080: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2081: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2082: RAISE OKL_API.G_EXCEPTION_ERROR;
2083: END IF;
2084:
2085: -- Tapi Call
2086: Okl_Rap_Pvt.lock_row(

Line 2094: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

2090: x_msg_count,
2091: x_msg_data,
2092: p_rap_tbl);
2093:
2094: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
2095: RAISE G_EXCEPTION_HALT_VALIDATION;
2096: ELSE
2097: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
2098: l_return_status := x_return_status;

Line 2097: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

2093:
2094: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
2095: RAISE G_EXCEPTION_HALT_VALIDATION;
2096: ELSE
2097: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
2098: l_return_status := x_return_status;
2099: END IF;
2100: END IF;
2101:

Line 2102: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );

2098: l_return_status := x_return_status;
2099: END IF;
2100: END IF;
2101:
2102: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
2103:
2104: EXCEPTION
2105: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2106: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 2105: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2101:
2102: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
2103:
2104: EXCEPTION
2105: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2106: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2107: l_api_name,
2108: G_PKG_NAME,
2109: 'OKL_API.G_RET_STS_ERROR',

Line 2106: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

2102: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
2103:
2104: EXCEPTION
2105: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2106: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2107: l_api_name,
2108: G_PKG_NAME,
2109: 'OKL_API.G_RET_STS_ERROR',
2110: x_msg_count,

Line 2109: 'OKL_API.G_RET_STS_ERROR',

2105: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2106: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2107: l_api_name,
2108: G_PKG_NAME,
2109: 'OKL_API.G_RET_STS_ERROR',
2110: x_msg_count,
2111: x_msg_data,
2112: '_PVT');
2113:

Line 2114: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2110: x_msg_count,
2111: x_msg_data,
2112: '_PVT');
2113:
2114: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2115: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
2116: l_api_name,
2117: G_PKG_NAME,
2118: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 2115: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

2111: x_msg_data,
2112: '_PVT');
2113:
2114: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2115: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
2116: l_api_name,
2117: G_PKG_NAME,
2118: 'OKL_API.G_RET_STS_UNEXP_ERROR',
2119: x_msg_count,

Line 2118: 'OKL_API.G_RET_STS_UNEXP_ERROR',

2114: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2115: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
2116: l_api_name,
2117: G_PKG_NAME,
2118: 'OKL_API.G_RET_STS_UNEXP_ERROR',
2119: x_msg_count,
2120: x_msg_data,
2121: '_PVT');
2122:

Line 2124: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

2120: x_msg_data,
2121: '_PVT');
2122:
2123: WHEN OTHERS THEN
2124: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
2125: l_api_name,
2126: G_PKG_NAME,
2127: 'OTHERS',
2128: x_msg_count,

Line 2136: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

2132: END lock_report_acc_parameters;
2133:
2134: PROCEDURE create_report_strm_parameters(
2135: p_api_version IN NUMBER,
2136: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
2137: x_return_status OUT NOCOPY VARCHAR2,
2138: x_msg_count OUT NOCOPY NUMBER,
2139: x_msg_data OUT NOCOPY VARCHAR2,
2140: p_rps_rec IN rps_rec_type,

Line 2144: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

2140: p_rps_rec IN rps_rec_type,
2141: x_rps_rec OUT NOCOPY rps_rec_type
2142: ) IS
2143:
2144: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2145: l_api_name VARCHAR2(30) := 'CREATE_REPORT_STRM_PARAMS';
2146:
2147: BEGIN
2148: -- Call start_activity to create savepoint, check compatibility

Line 2150: l_return_status := OKL_API.START_ACTIVITY (

2146:
2147: BEGIN
2148: -- Call start_activity to create savepoint, check compatibility
2149: -- and initialize message list
2150: l_return_status := OKL_API.START_ACTIVITY (
2151: l_api_name,
2152: p_init_msg_list,
2153: '_PVT',
2154: l_return_status);

Line 2157: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

2153: '_PVT',
2154: l_return_status);
2155:
2156: -- Check if activity started successfully
2157: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2158: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2159: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2160: RAISE OKL_API.G_EXCEPTION_ERROR;
2161: END IF;

Line 2158: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2154: l_return_status);
2155:
2156: -- Check if activity started successfully
2157: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2158: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2159: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2160: RAISE OKL_API.G_EXCEPTION_ERROR;
2161: END IF;
2162:

Line 2159: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

2155:
2156: -- Check if activity started successfully
2157: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2158: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2159: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2160: RAISE OKL_API.G_EXCEPTION_ERROR;
2161: END IF;
2162:
2163: -- Tapi Call

Line 2160: RAISE OKL_API.G_EXCEPTION_ERROR;

2156: -- Check if activity started successfully
2157: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2158: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2159: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2160: RAISE OKL_API.G_EXCEPTION_ERROR;
2161: END IF;
2162:
2163: -- Tapi Call
2164: Okl_Rsp_Pvt.insert_row(

Line 2173: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

2169: x_msg_data,
2170: p_rps_rec,
2171: x_rps_rec);
2172:
2173: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
2174: RAISE G_EXCEPTION_HALT_VALIDATION;
2175: ELSE
2176: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
2177: l_return_status := x_return_status;

Line 2176: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

2172:
2173: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
2174: RAISE G_EXCEPTION_HALT_VALIDATION;
2175: ELSE
2176: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
2177: l_return_status := x_return_status;
2178: END IF;
2179: END IF;
2180:

Line 2181: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );

2177: l_return_status := x_return_status;
2178: END IF;
2179: END IF;
2180:
2181: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
2182:
2183: EXCEPTION
2184: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2185: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 2184: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2180:
2181: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
2182:
2183: EXCEPTION
2184: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2185: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2186: l_api_name,
2187: G_PKG_NAME,
2188: 'OKL_API.G_RET_STS_ERROR',

Line 2185: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

2181: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
2182:
2183: EXCEPTION
2184: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2185: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2186: l_api_name,
2187: G_PKG_NAME,
2188: 'OKL_API.G_RET_STS_ERROR',
2189: x_msg_count,

Line 2188: 'OKL_API.G_RET_STS_ERROR',

2184: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2185: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2186: l_api_name,
2187: G_PKG_NAME,
2188: 'OKL_API.G_RET_STS_ERROR',
2189: x_msg_count,
2190: x_msg_data,
2191: '_PVT');
2192:

Line 2193: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2189: x_msg_count,
2190: x_msg_data,
2191: '_PVT');
2192:
2193: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2194: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
2195: l_api_name,
2196: G_PKG_NAME,
2197: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 2194: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

2190: x_msg_data,
2191: '_PVT');
2192:
2193: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2194: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
2195: l_api_name,
2196: G_PKG_NAME,
2197: 'OKL_API.G_RET_STS_UNEXP_ERROR',
2198: x_msg_count,

Line 2197: 'OKL_API.G_RET_STS_UNEXP_ERROR',

2193: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2194: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
2195: l_api_name,
2196: G_PKG_NAME,
2197: 'OKL_API.G_RET_STS_UNEXP_ERROR',
2198: x_msg_count,
2199: x_msg_data,
2200: '_PVT');
2201:

Line 2203: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

2199: x_msg_data,
2200: '_PVT');
2201:
2202: WHEN OTHERS THEN
2203: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
2204: l_api_name,
2205: G_PKG_NAME,
2206: 'OTHERS',
2207: x_msg_count,

Line 2215: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

2211: END create_report_strm_parameters;
2212:
2213: PROCEDURE update_report_strm_parameters(
2214: p_api_version IN NUMBER,
2215: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
2216: x_return_status OUT NOCOPY VARCHAR2,
2217: x_msg_count OUT NOCOPY NUMBER,
2218: x_msg_data OUT NOCOPY VARCHAR2,
2219: p_rps_rec IN rps_rec_type,

Line 2223: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

2219: p_rps_rec IN rps_rec_type,
2220: x_rps_rec OUT NOCOPY rps_rec_type
2221: ) IS
2222:
2223: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2224: l_api_name VARCHAR2(30) := 'UPDATE_REPORT_STRM_PARAMS';
2225:
2226: BEGIN
2227: -- Call start_activity to create savepoint, check compatibility

Line 2229: l_return_status := OKL_API.START_ACTIVITY (

2225:
2226: BEGIN
2227: -- Call start_activity to create savepoint, check compatibility
2228: -- and initialize message list
2229: l_return_status := OKL_API.START_ACTIVITY (
2230: l_api_name,
2231: p_init_msg_list,
2232: '_PVT',
2233: l_return_status);

Line 2236: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

2232: '_PVT',
2233: l_return_status);
2234:
2235: -- Check if activity started successfully
2236: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2237: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2238: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2239: RAISE OKL_API.G_EXCEPTION_ERROR;
2240: END IF;

Line 2237: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2233: l_return_status);
2234:
2235: -- Check if activity started successfully
2236: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2237: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2238: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2239: RAISE OKL_API.G_EXCEPTION_ERROR;
2240: END IF;
2241:

Line 2238: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

2234:
2235: -- Check if activity started successfully
2236: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2237: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2238: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2239: RAISE OKL_API.G_EXCEPTION_ERROR;
2240: END IF;
2241:
2242: -- Tapi Call

Line 2239: RAISE OKL_API.G_EXCEPTION_ERROR;

2235: -- Check if activity started successfully
2236: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2237: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2238: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2239: RAISE OKL_API.G_EXCEPTION_ERROR;
2240: END IF;
2241:
2242: -- Tapi Call
2243: Okl_Rsp_Pvt.update_row(

Line 2252: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

2248: x_msg_data,
2249: p_rps_rec,
2250: x_rps_rec);
2251:
2252: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
2253: RAISE G_EXCEPTION_HALT_VALIDATION;
2254: ELSE
2255: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
2256: l_return_status := x_return_status;

Line 2255: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

2251:
2252: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
2253: RAISE G_EXCEPTION_HALT_VALIDATION;
2254: ELSE
2255: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
2256: l_return_status := x_return_status;
2257: END IF;
2258: END IF;
2259:

Line 2260: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );

2256: l_return_status := x_return_status;
2257: END IF;
2258: END IF;
2259:
2260: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
2261:
2262: EXCEPTION
2263: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2264: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 2263: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2259:
2260: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
2261:
2262: EXCEPTION
2263: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2264: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2265: l_api_name,
2266: G_PKG_NAME,
2267: 'OKL_API.G_RET_STS_ERROR',

Line 2264: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

2260: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
2261:
2262: EXCEPTION
2263: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2264: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2265: l_api_name,
2266: G_PKG_NAME,
2267: 'OKL_API.G_RET_STS_ERROR',
2268: x_msg_count,

Line 2267: 'OKL_API.G_RET_STS_ERROR',

2263: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2264: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2265: l_api_name,
2266: G_PKG_NAME,
2267: 'OKL_API.G_RET_STS_ERROR',
2268: x_msg_count,
2269: x_msg_data,
2270: '_PVT');
2271:

Line 2272: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2268: x_msg_count,
2269: x_msg_data,
2270: '_PVT');
2271:
2272: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2273: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
2274: l_api_name,
2275: G_PKG_NAME,
2276: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 2273: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

2269: x_msg_data,
2270: '_PVT');
2271:
2272: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2273: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
2274: l_api_name,
2275: G_PKG_NAME,
2276: 'OKL_API.G_RET_STS_UNEXP_ERROR',
2277: x_msg_count,

Line 2276: 'OKL_API.G_RET_STS_UNEXP_ERROR',

2272: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2273: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
2274: l_api_name,
2275: G_PKG_NAME,
2276: 'OKL_API.G_RET_STS_UNEXP_ERROR',
2277: x_msg_count,
2278: x_msg_data,
2279: '_PVT');
2280:

Line 2282: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

2278: x_msg_data,
2279: '_PVT');
2280:
2281: WHEN OTHERS THEN
2282: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
2283: l_api_name,
2284: G_PKG_NAME,
2285: 'OTHERS',
2286: x_msg_count,

Line 2294: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

2290: END update_report_strm_parameters;
2291:
2292: PROCEDURE delete_report_strm_parameters(
2293: p_api_version IN NUMBER,
2294: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
2295: x_return_status OUT NOCOPY VARCHAR2,
2296: x_msg_count OUT NOCOPY NUMBER,
2297: x_msg_data OUT NOCOPY VARCHAR2,
2298: p_rps_rec IN rps_rec_type

Line 2301: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

2297: x_msg_data OUT NOCOPY VARCHAR2,
2298: p_rps_rec IN rps_rec_type
2299: ) IS
2300:
2301: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2302: l_api_name VARCHAR2(30) := 'DELETE_REPORT_STRM_PARAMS';
2303:
2304: BEGIN
2305: -- Call start_activity to create savepoint, check compatibility

Line 2307: l_return_status := OKL_API.START_ACTIVITY (

2303:
2304: BEGIN
2305: -- Call start_activity to create savepoint, check compatibility
2306: -- and initialize message list
2307: l_return_status := OKL_API.START_ACTIVITY (
2308: l_api_name,
2309: p_init_msg_list,
2310: '_PVT',
2311: l_return_status);

Line 2314: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

2310: '_PVT',
2311: l_return_status);
2312:
2313: -- Check if activity started successfully
2314: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2315: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2316: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2317: RAISE OKL_API.G_EXCEPTION_ERROR;
2318: END IF;

Line 2315: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2311: l_return_status);
2312:
2313: -- Check if activity started successfully
2314: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2315: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2316: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2317: RAISE OKL_API.G_EXCEPTION_ERROR;
2318: END IF;
2319:

Line 2316: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

2312:
2313: -- Check if activity started successfully
2314: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2315: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2316: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2317: RAISE OKL_API.G_EXCEPTION_ERROR;
2318: END IF;
2319:
2320: -- Tapi Call

Line 2317: RAISE OKL_API.G_EXCEPTION_ERROR;

2313: -- Check if activity started successfully
2314: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2315: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2316: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2317: RAISE OKL_API.G_EXCEPTION_ERROR;
2318: END IF;
2319:
2320: -- Tapi Call
2321: Okl_Rsp_Pvt.delete_row(

Line 2329: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

2325: x_msg_count,
2326: x_msg_data,
2327: p_rps_rec);
2328:
2329: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
2330: RAISE G_EXCEPTION_HALT_VALIDATION;
2331: ELSE
2332: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
2333: l_return_status := x_return_status;

Line 2332: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

2328:
2329: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
2330: RAISE G_EXCEPTION_HALT_VALIDATION;
2331: ELSE
2332: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
2333: l_return_status := x_return_status;
2334: END IF;
2335: END IF;
2336:

Line 2337: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );

2333: l_return_status := x_return_status;
2334: END IF;
2335: END IF;
2336:
2337: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
2338:
2339: EXCEPTION
2340: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2341: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 2340: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2336:
2337: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
2338:
2339: EXCEPTION
2340: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2341: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2342: l_api_name,
2343: G_PKG_NAME,
2344: 'OKL_API.G_RET_STS_ERROR',

Line 2341: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

2337: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
2338:
2339: EXCEPTION
2340: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2341: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2342: l_api_name,
2343: G_PKG_NAME,
2344: 'OKL_API.G_RET_STS_ERROR',
2345: x_msg_count,

Line 2344: 'OKL_API.G_RET_STS_ERROR',

2340: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2341: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2342: l_api_name,
2343: G_PKG_NAME,
2344: 'OKL_API.G_RET_STS_ERROR',
2345: x_msg_count,
2346: x_msg_data,
2347: '_PVT');
2348:

Line 2349: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2345: x_msg_count,
2346: x_msg_data,
2347: '_PVT');
2348:
2349: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2350: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
2351: l_api_name,
2352: G_PKG_NAME,
2353: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 2350: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

2346: x_msg_data,
2347: '_PVT');
2348:
2349: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2350: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
2351: l_api_name,
2352: G_PKG_NAME,
2353: 'OKL_API.G_RET_STS_UNEXP_ERROR',
2354: x_msg_count,

Line 2353: 'OKL_API.G_RET_STS_UNEXP_ERROR',

2349: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2350: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
2351: l_api_name,
2352: G_PKG_NAME,
2353: 'OKL_API.G_RET_STS_UNEXP_ERROR',
2354: x_msg_count,
2355: x_msg_data,
2356: '_PVT');
2357:

Line 2359: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

2355: x_msg_data,
2356: '_PVT');
2357:
2358: WHEN OTHERS THEN
2359: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
2360: l_api_name,
2361: G_PKG_NAME,
2362: 'OTHERS',
2363: x_msg_count,

Line 2371: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

2367: END delete_report_strm_parameters;
2368:
2369: PROCEDURE lock_report_strm_parameters(
2370: p_api_version IN NUMBER,
2371: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
2372: x_return_status OUT NOCOPY VARCHAR2,
2373: x_msg_count OUT NOCOPY NUMBER,
2374: x_msg_data OUT NOCOPY VARCHAR2,
2375: p_rps_rec IN rps_rec_type

Line 2378: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

2374: x_msg_data OUT NOCOPY VARCHAR2,
2375: p_rps_rec IN rps_rec_type
2376: ) IS
2377:
2378: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2379: l_api_name VARCHAR2(30) := 'LOCK_REPORT_STRM_PARAMS';
2380:
2381: BEGIN
2382: -- Call start_activity to create savepoint, check compatibility

Line 2384: l_return_status := OKL_API.START_ACTIVITY (

2380:
2381: BEGIN
2382: -- Call start_activity to create savepoint, check compatibility
2383: -- and initialize message list
2384: l_return_status := OKL_API.START_ACTIVITY (
2385: l_api_name,
2386: p_init_msg_list,
2387: '_PVT',
2388: l_return_status);

Line 2391: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

2387: '_PVT',
2388: l_return_status);
2389:
2390: -- Check if activity started successfully
2391: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2392: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2393: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2394: RAISE OKL_API.G_EXCEPTION_ERROR;
2395: END IF;

Line 2392: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2388: l_return_status);
2389:
2390: -- Check if activity started successfully
2391: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2392: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2393: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2394: RAISE OKL_API.G_EXCEPTION_ERROR;
2395: END IF;
2396:

Line 2393: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

2389:
2390: -- Check if activity started successfully
2391: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2392: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2393: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2394: RAISE OKL_API.G_EXCEPTION_ERROR;
2395: END IF;
2396:
2397: -- Tapi Call

Line 2394: RAISE OKL_API.G_EXCEPTION_ERROR;

2390: -- Check if activity started successfully
2391: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2392: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2393: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2394: RAISE OKL_API.G_EXCEPTION_ERROR;
2395: END IF;
2396:
2397: -- Tapi Call
2398: Okl_Rsp_Pvt.lock_row(

Line 2406: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

2402: x_msg_count,
2403: x_msg_data,
2404: p_rps_rec);
2405:
2406: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
2407: RAISE G_EXCEPTION_HALT_VALIDATION;
2408: ELSE
2409: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
2410: l_return_status := x_return_status;

Line 2409: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

2405:
2406: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
2407: RAISE G_EXCEPTION_HALT_VALIDATION;
2408: ELSE
2409: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
2410: l_return_status := x_return_status;
2411: END IF;
2412: END IF;
2413:

Line 2414: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );

2410: l_return_status := x_return_status;
2411: END IF;
2412: END IF;
2413:
2414: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
2415:
2416: EXCEPTION
2417: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2418: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 2417: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2413:
2414: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
2415:
2416: EXCEPTION
2417: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2418: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2419: l_api_name,
2420: G_PKG_NAME,
2421: 'OKL_API.G_RET_STS_ERROR',

Line 2418: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

2414: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
2415:
2416: EXCEPTION
2417: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2418: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2419: l_api_name,
2420: G_PKG_NAME,
2421: 'OKL_API.G_RET_STS_ERROR',
2422: x_msg_count,

Line 2421: 'OKL_API.G_RET_STS_ERROR',

2417: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2418: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2419: l_api_name,
2420: G_PKG_NAME,
2421: 'OKL_API.G_RET_STS_ERROR',
2422: x_msg_count,
2423: x_msg_data,
2424: '_PVT');
2425:

Line 2426: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2422: x_msg_count,
2423: x_msg_data,
2424: '_PVT');
2425:
2426: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2427: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
2428: l_api_name,
2429: G_PKG_NAME,
2430: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 2427: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

2423: x_msg_data,
2424: '_PVT');
2425:
2426: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2427: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
2428: l_api_name,
2429: G_PKG_NAME,
2430: 'OKL_API.G_RET_STS_UNEXP_ERROR',
2431: x_msg_count,

Line 2430: 'OKL_API.G_RET_STS_UNEXP_ERROR',

2426: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2427: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
2428: l_api_name,
2429: G_PKG_NAME,
2430: 'OKL_API.G_RET_STS_UNEXP_ERROR',
2431: x_msg_count,
2432: x_msg_data,
2433: '_PVT');
2434:

Line 2436: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

2432: x_msg_data,
2433: '_PVT');
2434:
2435: WHEN OTHERS THEN
2436: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
2437: l_api_name,
2438: G_PKG_NAME,
2439: 'OTHERS',
2440: x_msg_count,

Line 2448: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

2444: END lock_report_strm_parameters;
2445:
2446: PROCEDURE create_report_strm_parameters(
2447: p_api_version IN NUMBER,
2448: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
2449: x_return_status OUT NOCOPY VARCHAR2,
2450: x_msg_count OUT NOCOPY NUMBER,
2451: x_msg_data OUT NOCOPY VARCHAR2,
2452: p_rps_tbl IN rps_tbl_type,

Line 2456: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

2452: p_rps_tbl IN rps_tbl_type,
2453: x_rps_tbl OUT NOCOPY rps_tbl_type
2454: ) IS
2455:
2456: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2457: l_api_name VARCHAR2(30) := 'CREATE_REPORT_STRM_PARAMS';
2458:
2459: BEGIN
2460: -- Call start_activity to create savepoint, check compatibility

Line 2462: l_return_status := OKL_API.START_ACTIVITY (

2458:
2459: BEGIN
2460: -- Call start_activity to create savepoint, check compatibility
2461: -- and initialize message list
2462: l_return_status := OKL_API.START_ACTIVITY (
2463: l_api_name,
2464: p_init_msg_list,
2465: '_PVT',
2466: l_return_status);

Line 2469: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

2465: '_PVT',
2466: l_return_status);
2467:
2468: -- Check if activity started successfully
2469: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2470: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2471: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2472: RAISE OKL_API.G_EXCEPTION_ERROR;
2473: END IF;

Line 2470: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2466: l_return_status);
2467:
2468: -- Check if activity started successfully
2469: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2470: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2471: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2472: RAISE OKL_API.G_EXCEPTION_ERROR;
2473: END IF;
2474:

Line 2471: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

2467:
2468: -- Check if activity started successfully
2469: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2470: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2471: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2472: RAISE OKL_API.G_EXCEPTION_ERROR;
2473: END IF;
2474:
2475: -- Tapi Call

Line 2472: RAISE OKL_API.G_EXCEPTION_ERROR;

2468: -- Check if activity started successfully
2469: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2470: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2471: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2472: RAISE OKL_API.G_EXCEPTION_ERROR;
2473: END IF;
2474:
2475: -- Tapi Call
2476: Okl_Rsp_Pvt.insert_row(

Line 2485: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

2481: x_msg_data,
2482: p_rps_tbl,
2483: x_rps_tbl);
2484:
2485: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
2486: RAISE G_EXCEPTION_HALT_VALIDATION;
2487: ELSE
2488: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
2489: l_return_status := x_return_status;

Line 2488: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

2484:
2485: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
2486: RAISE G_EXCEPTION_HALT_VALIDATION;
2487: ELSE
2488: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
2489: l_return_status := x_return_status;
2490: END IF;
2491: END IF;
2492:

Line 2493: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );

2489: l_return_status := x_return_status;
2490: END IF;
2491: END IF;
2492:
2493: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
2494:
2495: EXCEPTION
2496: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2497: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 2496: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2492:
2493: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
2494:
2495: EXCEPTION
2496: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2497: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2498: l_api_name,
2499: G_PKG_NAME,
2500: 'OKL_API.G_RET_STS_ERROR',

Line 2497: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

2493: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
2494:
2495: EXCEPTION
2496: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2497: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2498: l_api_name,
2499: G_PKG_NAME,
2500: 'OKL_API.G_RET_STS_ERROR',
2501: x_msg_count,

Line 2500: 'OKL_API.G_RET_STS_ERROR',

2496: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2497: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2498: l_api_name,
2499: G_PKG_NAME,
2500: 'OKL_API.G_RET_STS_ERROR',
2501: x_msg_count,
2502: x_msg_data,
2503: '_PVT');
2504:

Line 2505: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2501: x_msg_count,
2502: x_msg_data,
2503: '_PVT');
2504:
2505: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2506: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
2507: l_api_name,
2508: G_PKG_NAME,
2509: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 2506: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

2502: x_msg_data,
2503: '_PVT');
2504:
2505: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2506: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
2507: l_api_name,
2508: G_PKG_NAME,
2509: 'OKL_API.G_RET_STS_UNEXP_ERROR',
2510: x_msg_count,

Line 2509: 'OKL_API.G_RET_STS_UNEXP_ERROR',

2505: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2506: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
2507: l_api_name,
2508: G_PKG_NAME,
2509: 'OKL_API.G_RET_STS_UNEXP_ERROR',
2510: x_msg_count,
2511: x_msg_data,
2512: '_PVT');
2513:

Line 2515: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

2511: x_msg_data,
2512: '_PVT');
2513:
2514: WHEN OTHERS THEN
2515: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
2516: l_api_name,
2517: G_PKG_NAME,
2518: 'OTHERS',
2519: x_msg_count,

Line 2527: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

2523: END create_report_strm_parameters;
2524:
2525: PROCEDURE update_report_strm_parameters(
2526: p_api_version IN NUMBER,
2527: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
2528: x_return_status OUT NOCOPY VARCHAR2,
2529: x_msg_count OUT NOCOPY NUMBER,
2530: x_msg_data OUT NOCOPY VARCHAR2,
2531: p_rps_tbl IN rps_tbl_type,

Line 2535: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

2531: p_rps_tbl IN rps_tbl_type,
2532: x_rps_tbl OUT NOCOPY rps_tbl_type
2533: ) IS
2534:
2535: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2536: l_api_name VARCHAR2(30) := 'UPDATE_REPORT_STRM_PARAMS';
2537:
2538: BEGIN
2539: -- Call start_activity to create savepoint, check compatibility

Line 2541: l_return_status := OKL_API.START_ACTIVITY (

2537:
2538: BEGIN
2539: -- Call start_activity to create savepoint, check compatibility
2540: -- and initialize message list
2541: l_return_status := OKL_API.START_ACTIVITY (
2542: l_api_name,
2543: p_init_msg_list,
2544: '_PVT',
2545: l_return_status);

Line 2548: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

2544: '_PVT',
2545: l_return_status);
2546:
2547: -- Check if activity started successfully
2548: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2549: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2550: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2551: RAISE OKL_API.G_EXCEPTION_ERROR;
2552: END IF;

Line 2549: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2545: l_return_status);
2546:
2547: -- Check if activity started successfully
2548: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2549: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2550: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2551: RAISE OKL_API.G_EXCEPTION_ERROR;
2552: END IF;
2553:

Line 2550: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

2546:
2547: -- Check if activity started successfully
2548: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2549: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2550: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2551: RAISE OKL_API.G_EXCEPTION_ERROR;
2552: END IF;
2553:
2554: -- Tapi Call

Line 2551: RAISE OKL_API.G_EXCEPTION_ERROR;

2547: -- Check if activity started successfully
2548: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2549: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2550: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2551: RAISE OKL_API.G_EXCEPTION_ERROR;
2552: END IF;
2553:
2554: -- Tapi Call
2555: Okl_Rsp_Pvt.update_row(

Line 2564: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

2560: x_msg_data,
2561: p_rps_tbl,
2562: x_rps_tbl);
2563:
2564: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
2565: RAISE G_EXCEPTION_HALT_VALIDATION;
2566: ELSE
2567: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
2568: l_return_status := x_return_status;

Line 2567: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

2563:
2564: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
2565: RAISE G_EXCEPTION_HALT_VALIDATION;
2566: ELSE
2567: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
2568: l_return_status := x_return_status;
2569: END IF;
2570: END IF;
2571:

Line 2572: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );

2568: l_return_status := x_return_status;
2569: END IF;
2570: END IF;
2571:
2572: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
2573:
2574: EXCEPTION
2575: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2576: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 2575: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2571:
2572: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
2573:
2574: EXCEPTION
2575: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2576: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2577: l_api_name,
2578: G_PKG_NAME,
2579: 'OKL_API.G_RET_STS_ERROR',

Line 2576: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

2572: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
2573:
2574: EXCEPTION
2575: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2576: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2577: l_api_name,
2578: G_PKG_NAME,
2579: 'OKL_API.G_RET_STS_ERROR',
2580: x_msg_count,

Line 2579: 'OKL_API.G_RET_STS_ERROR',

2575: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2576: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2577: l_api_name,
2578: G_PKG_NAME,
2579: 'OKL_API.G_RET_STS_ERROR',
2580: x_msg_count,
2581: x_msg_data,
2582: '_PVT');
2583:

Line 2584: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2580: x_msg_count,
2581: x_msg_data,
2582: '_PVT');
2583:
2584: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2585: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
2586: l_api_name,
2587: G_PKG_NAME,
2588: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 2585: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

2581: x_msg_data,
2582: '_PVT');
2583:
2584: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2585: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
2586: l_api_name,
2587: G_PKG_NAME,
2588: 'OKL_API.G_RET_STS_UNEXP_ERROR',
2589: x_msg_count,

Line 2588: 'OKL_API.G_RET_STS_UNEXP_ERROR',

2584: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2585: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
2586: l_api_name,
2587: G_PKG_NAME,
2588: 'OKL_API.G_RET_STS_UNEXP_ERROR',
2589: x_msg_count,
2590: x_msg_data,
2591: '_PVT');
2592:

Line 2594: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

2590: x_msg_data,
2591: '_PVT');
2592:
2593: WHEN OTHERS THEN
2594: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
2595: l_api_name,
2596: G_PKG_NAME,
2597: 'OTHERS',
2598: x_msg_count,

Line 2606: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

2602: END update_report_strm_parameters;
2603:
2604: PROCEDURE delete_report_strm_parameters(
2605: p_api_version IN NUMBER,
2606: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
2607: x_return_status OUT NOCOPY VARCHAR2,
2608: x_msg_count OUT NOCOPY NUMBER,
2609: x_msg_data OUT NOCOPY VARCHAR2,
2610: p_rps_tbl IN rps_tbl_type

Line 2613: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

2609: x_msg_data OUT NOCOPY VARCHAR2,
2610: p_rps_tbl IN rps_tbl_type
2611: ) IS
2612:
2613: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2614: l_api_name VARCHAR2(30) := 'DELETE_REPORT_STRM_PARAMS';
2615:
2616: BEGIN
2617: -- Call start_activity to create savepoint, check compatibility

Line 2619: l_return_status := OKL_API.START_ACTIVITY (

2615:
2616: BEGIN
2617: -- Call start_activity to create savepoint, check compatibility
2618: -- and initialize message list
2619: l_return_status := OKL_API.START_ACTIVITY (
2620: l_api_name,
2621: p_init_msg_list,
2622: '_PVT',
2623: l_return_status);

Line 2626: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

2622: '_PVT',
2623: l_return_status);
2624:
2625: -- Check if activity started successfully
2626: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2627: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2628: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2629: RAISE OKL_API.G_EXCEPTION_ERROR;
2630: END IF;

Line 2627: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2623: l_return_status);
2624:
2625: -- Check if activity started successfully
2626: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2627: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2628: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2629: RAISE OKL_API.G_EXCEPTION_ERROR;
2630: END IF;
2631:

Line 2628: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

2624:
2625: -- Check if activity started successfully
2626: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2627: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2628: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2629: RAISE OKL_API.G_EXCEPTION_ERROR;
2630: END IF;
2631:
2632: -- Tapi Call

Line 2629: RAISE OKL_API.G_EXCEPTION_ERROR;

2625: -- Check if activity started successfully
2626: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2627: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2628: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2629: RAISE OKL_API.G_EXCEPTION_ERROR;
2630: END IF;
2631:
2632: -- Tapi Call
2633: Okl_Rsp_Pvt.delete_row(

Line 2641: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

2637: x_msg_count,
2638: x_msg_data,
2639: p_rps_tbl);
2640:
2641: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
2642: RAISE G_EXCEPTION_HALT_VALIDATION;
2643: ELSE
2644: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
2645: l_return_status := x_return_status;

Line 2644: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

2640:
2641: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
2642: RAISE G_EXCEPTION_HALT_VALIDATION;
2643: ELSE
2644: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
2645: l_return_status := x_return_status;
2646: END IF;
2647: END IF;
2648:

Line 2649: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );

2645: l_return_status := x_return_status;
2646: END IF;
2647: END IF;
2648:
2649: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
2650:
2651: EXCEPTION
2652: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2653: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 2652: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2648:
2649: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
2650:
2651: EXCEPTION
2652: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2653: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2654: l_api_name,
2655: G_PKG_NAME,
2656: 'OKL_API.G_RET_STS_ERROR',

Line 2653: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

2649: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
2650:
2651: EXCEPTION
2652: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2653: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2654: l_api_name,
2655: G_PKG_NAME,
2656: 'OKL_API.G_RET_STS_ERROR',
2657: x_msg_count,

Line 2656: 'OKL_API.G_RET_STS_ERROR',

2652: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2653: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2654: l_api_name,
2655: G_PKG_NAME,
2656: 'OKL_API.G_RET_STS_ERROR',
2657: x_msg_count,
2658: x_msg_data,
2659: '_PVT');
2660:

Line 2661: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2657: x_msg_count,
2658: x_msg_data,
2659: '_PVT');
2660:
2661: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2662: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
2663: l_api_name,
2664: G_PKG_NAME,
2665: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 2662: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

2658: x_msg_data,
2659: '_PVT');
2660:
2661: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2662: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
2663: l_api_name,
2664: G_PKG_NAME,
2665: 'OKL_API.G_RET_STS_UNEXP_ERROR',
2666: x_msg_count,

Line 2665: 'OKL_API.G_RET_STS_UNEXP_ERROR',

2661: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2662: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
2663: l_api_name,
2664: G_PKG_NAME,
2665: 'OKL_API.G_RET_STS_UNEXP_ERROR',
2666: x_msg_count,
2667: x_msg_data,
2668: '_PVT');
2669:

Line 2671: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

2667: x_msg_data,
2668: '_PVT');
2669:
2670: WHEN OTHERS THEN
2671: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
2672: l_api_name,
2673: G_PKG_NAME,
2674: 'OTHERS',
2675: x_msg_count,

Line 2683: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

2679: END delete_report_strm_parameters;
2680:
2681: PROCEDURE lock_report_strm_parameters(
2682: p_api_version IN NUMBER,
2683: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
2684: x_return_status OUT NOCOPY VARCHAR2,
2685: x_msg_count OUT NOCOPY NUMBER,
2686: x_msg_data OUT NOCOPY VARCHAR2,
2687: p_rps_tbl IN rps_tbl_type

Line 2690: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

2686: x_msg_data OUT NOCOPY VARCHAR2,
2687: p_rps_tbl IN rps_tbl_type
2688: ) IS
2689:
2690: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2691: l_api_name VARCHAR2(30) := 'LOCK_REPORT_STRM_PARAMS';
2692:
2693: BEGIN
2694: -- Call start_activity to create savepoint, check compatibility

Line 2696: l_return_status := OKL_API.START_ACTIVITY (

2692:
2693: BEGIN
2694: -- Call start_activity to create savepoint, check compatibility
2695: -- and initialize message list
2696: l_return_status := OKL_API.START_ACTIVITY (
2697: l_api_name,
2698: p_init_msg_list,
2699: '_PVT',
2700: l_return_status);

Line 2703: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

2699: '_PVT',
2700: l_return_status);
2701:
2702: -- Check if activity started successfully
2703: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2704: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2705: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2706: RAISE OKL_API.G_EXCEPTION_ERROR;
2707: END IF;

Line 2704: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2700: l_return_status);
2701:
2702: -- Check if activity started successfully
2703: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2704: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2705: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2706: RAISE OKL_API.G_EXCEPTION_ERROR;
2707: END IF;
2708:

Line 2705: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

2701:
2702: -- Check if activity started successfully
2703: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2704: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2705: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2706: RAISE OKL_API.G_EXCEPTION_ERROR;
2707: END IF;
2708:
2709: -- Tapi Call

Line 2706: RAISE OKL_API.G_EXCEPTION_ERROR;

2702: -- Check if activity started successfully
2703: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2704: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2705: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2706: RAISE OKL_API.G_EXCEPTION_ERROR;
2707: END IF;
2708:
2709: -- Tapi Call
2710: Okl_Rsp_Pvt.lock_row(

Line 2718: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

2714: x_msg_count,
2715: x_msg_data,
2716: p_rps_tbl);
2717:
2718: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
2719: RAISE G_EXCEPTION_HALT_VALIDATION;
2720: ELSE
2721: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
2722: l_return_status := x_return_status;

Line 2721: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

2717:
2718: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
2719: RAISE G_EXCEPTION_HALT_VALIDATION;
2720: ELSE
2721: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
2722: l_return_status := x_return_status;
2723: END IF;
2724: END IF;
2725:

Line 2726: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );

2722: l_return_status := x_return_status;
2723: END IF;
2724: END IF;
2725:
2726: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
2727:
2728: EXCEPTION
2729: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2730: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 2729: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2725:
2726: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
2727:
2728: EXCEPTION
2729: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2730: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2731: l_api_name,
2732: G_PKG_NAME,
2733: 'OKL_API.G_RET_STS_ERROR',

Line 2730: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

2726: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
2727:
2728: EXCEPTION
2729: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2730: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2731: l_api_name,
2732: G_PKG_NAME,
2733: 'OKL_API.G_RET_STS_ERROR',
2734: x_msg_count,

Line 2733: 'OKL_API.G_RET_STS_ERROR',

2729: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2730: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2731: l_api_name,
2732: G_PKG_NAME,
2733: 'OKL_API.G_RET_STS_ERROR',
2734: x_msg_count,
2735: x_msg_data,
2736: '_PVT');
2737:

Line 2738: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2734: x_msg_count,
2735: x_msg_data,
2736: '_PVT');
2737:
2738: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2739: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
2740: l_api_name,
2741: G_PKG_NAME,
2742: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 2739: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

2735: x_msg_data,
2736: '_PVT');
2737:
2738: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2739: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
2740: l_api_name,
2741: G_PKG_NAME,
2742: 'OKL_API.G_RET_STS_UNEXP_ERROR',
2743: x_msg_count,

Line 2742: 'OKL_API.G_RET_STS_UNEXP_ERROR',

2738: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2739: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
2740: l_api_name,
2741: G_PKG_NAME,
2742: 'OKL_API.G_RET_STS_UNEXP_ERROR',
2743: x_msg_count,
2744: x_msg_data,
2745: '_PVT');
2746:

Line 2748: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

2744: x_msg_data,
2745: '_PVT');
2746:
2747: WHEN OTHERS THEN
2748: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
2749: l_api_name,
2750: G_PKG_NAME,
2751: 'OTHERS',
2752: x_msg_count,

Line 2760: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

2756: END lock_report_strm_parameters;
2757:
2758: PROCEDURE create_report_trx_parameters(
2759: p_api_version IN NUMBER,
2760: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
2761: x_return_status OUT NOCOPY VARCHAR2,
2762: x_msg_count OUT NOCOPY NUMBER,
2763: x_msg_data OUT NOCOPY VARCHAR2,
2764: p_rtp_rec IN rtp_rec_type,

Line 2768: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

2764: p_rtp_rec IN rtp_rec_type,
2765: x_rtp_rec OUT NOCOPY rtp_rec_type
2766: ) IS
2767:
2768: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2769: l_api_name VARCHAR2(30) := 'CREATE_REPORT_TRX_PARAMS';
2770:
2771: BEGIN
2772: -- Call start_activity to create savepoint, check compatibility

Line 2774: l_return_status := OKL_API.START_ACTIVITY (

2770:
2771: BEGIN
2772: -- Call start_activity to create savepoint, check compatibility
2773: -- and initialize message list
2774: l_return_status := OKL_API.START_ACTIVITY (
2775: l_api_name,
2776: p_init_msg_list,
2777: '_PVT',
2778: l_return_status);

Line 2781: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

2777: '_PVT',
2778: l_return_status);
2779:
2780: -- Check if activity started successfully
2781: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2782: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2783: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2784: RAISE OKL_API.G_EXCEPTION_ERROR;
2785: END IF;

Line 2782: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2778: l_return_status);
2779:
2780: -- Check if activity started successfully
2781: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2782: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2783: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2784: RAISE OKL_API.G_EXCEPTION_ERROR;
2785: END IF;
2786:

Line 2783: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

2779:
2780: -- Check if activity started successfully
2781: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2782: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2783: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2784: RAISE OKL_API.G_EXCEPTION_ERROR;
2785: END IF;
2786:
2787: -- Tapi Call

Line 2784: RAISE OKL_API.G_EXCEPTION_ERROR;

2780: -- Check if activity started successfully
2781: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2782: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2783: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2784: RAISE OKL_API.G_EXCEPTION_ERROR;
2785: END IF;
2786:
2787: -- Tapi Call
2788: Okl_Rtp_Pvt.insert_row(

Line 2797: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

2793: x_msg_data,
2794: p_rtp_rec,
2795: x_rtp_rec);
2796:
2797: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
2798: RAISE G_EXCEPTION_HALT_VALIDATION;
2799: ELSE
2800: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
2801: l_return_status := x_return_status;

Line 2800: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

2796:
2797: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
2798: RAISE G_EXCEPTION_HALT_VALIDATION;
2799: ELSE
2800: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
2801: l_return_status := x_return_status;
2802: END IF;
2803: END IF;
2804:

Line 2805: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );

2801: l_return_status := x_return_status;
2802: END IF;
2803: END IF;
2804:
2805: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
2806:
2807: EXCEPTION
2808: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2809: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 2808: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2804:
2805: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
2806:
2807: EXCEPTION
2808: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2809: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2810: l_api_name,
2811: G_PKG_NAME,
2812: 'OKL_API.G_RET_STS_ERROR',

Line 2809: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

2805: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
2806:
2807: EXCEPTION
2808: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2809: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2810: l_api_name,
2811: G_PKG_NAME,
2812: 'OKL_API.G_RET_STS_ERROR',
2813: x_msg_count,

Line 2812: 'OKL_API.G_RET_STS_ERROR',

2808: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2809: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2810: l_api_name,
2811: G_PKG_NAME,
2812: 'OKL_API.G_RET_STS_ERROR',
2813: x_msg_count,
2814: x_msg_data,
2815: '_PVT');
2816:

Line 2817: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2813: x_msg_count,
2814: x_msg_data,
2815: '_PVT');
2816:
2817: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2818: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
2819: l_api_name,
2820: G_PKG_NAME,
2821: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 2818: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

2814: x_msg_data,
2815: '_PVT');
2816:
2817: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2818: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
2819: l_api_name,
2820: G_PKG_NAME,
2821: 'OKL_API.G_RET_STS_UNEXP_ERROR',
2822: x_msg_count,

Line 2821: 'OKL_API.G_RET_STS_UNEXP_ERROR',

2817: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2818: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
2819: l_api_name,
2820: G_PKG_NAME,
2821: 'OKL_API.G_RET_STS_UNEXP_ERROR',
2822: x_msg_count,
2823: x_msg_data,
2824: '_PVT');
2825:

Line 2827: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

2823: x_msg_data,
2824: '_PVT');
2825:
2826: WHEN OTHERS THEN
2827: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
2828: l_api_name,
2829: G_PKG_NAME,
2830: 'OTHERS',
2831: x_msg_count,

Line 2839: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

2835: END create_report_trx_parameters;
2836:
2837: PROCEDURE update_report_trx_parameters(
2838: p_api_version IN NUMBER,
2839: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
2840: x_return_status OUT NOCOPY VARCHAR2,
2841: x_msg_count OUT NOCOPY NUMBER,
2842: x_msg_data OUT NOCOPY VARCHAR2,
2843: p_rtp_rec IN rtp_rec_type,

Line 2847: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

2843: p_rtp_rec IN rtp_rec_type,
2844: x_rtp_rec OUT NOCOPY rtp_rec_type
2845: ) IS
2846:
2847: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2848: l_api_name VARCHAR2(30) := 'UPDATE_REPORT_TRX_PARAMS';
2849:
2850: BEGIN
2851: -- Call start_activity to create savepoint, check compatibility

Line 2853: l_return_status := OKL_API.START_ACTIVITY (

2849:
2850: BEGIN
2851: -- Call start_activity to create savepoint, check compatibility
2852: -- and initialize message list
2853: l_return_status := OKL_API.START_ACTIVITY (
2854: l_api_name,
2855: p_init_msg_list,
2856: '_PVT',
2857: l_return_status);

Line 2860: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

2856: '_PVT',
2857: l_return_status);
2858:
2859: -- Check if activity started successfully
2860: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2861: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2862: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2863: RAISE OKL_API.G_EXCEPTION_ERROR;
2864: END IF;

Line 2861: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2857: l_return_status);
2858:
2859: -- Check if activity started successfully
2860: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2861: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2862: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2863: RAISE OKL_API.G_EXCEPTION_ERROR;
2864: END IF;
2865:

Line 2862: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

2858:
2859: -- Check if activity started successfully
2860: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2861: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2862: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2863: RAISE OKL_API.G_EXCEPTION_ERROR;
2864: END IF;
2865:
2866: -- Tapi Call

Line 2863: RAISE OKL_API.G_EXCEPTION_ERROR;

2859: -- Check if activity started successfully
2860: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2861: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2862: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2863: RAISE OKL_API.G_EXCEPTION_ERROR;
2864: END IF;
2865:
2866: -- Tapi Call
2867: Okl_Rtp_Pvt.update_row(

Line 2876: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

2872: x_msg_data,
2873: p_rtp_rec,
2874: x_rtp_rec);
2875:
2876: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
2877: RAISE G_EXCEPTION_HALT_VALIDATION;
2878: ELSE
2879: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
2880: l_return_status := x_return_status;

Line 2879: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

2875:
2876: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
2877: RAISE G_EXCEPTION_HALT_VALIDATION;
2878: ELSE
2879: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
2880: l_return_status := x_return_status;
2881: END IF;
2882: END IF;
2883:

Line 2884: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );

2880: l_return_status := x_return_status;
2881: END IF;
2882: END IF;
2883:
2884: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
2885:
2886: EXCEPTION
2887: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2888: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 2887: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2883:
2884: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
2885:
2886: EXCEPTION
2887: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2888: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2889: l_api_name,
2890: G_PKG_NAME,
2891: 'OKL_API.G_RET_STS_ERROR',

Line 2888: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

2884: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
2885:
2886: EXCEPTION
2887: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2888: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2889: l_api_name,
2890: G_PKG_NAME,
2891: 'OKL_API.G_RET_STS_ERROR',
2892: x_msg_count,

Line 2891: 'OKL_API.G_RET_STS_ERROR',

2887: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2888: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2889: l_api_name,
2890: G_PKG_NAME,
2891: 'OKL_API.G_RET_STS_ERROR',
2892: x_msg_count,
2893: x_msg_data,
2894: '_PVT');
2895:

Line 2896: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2892: x_msg_count,
2893: x_msg_data,
2894: '_PVT');
2895:
2896: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2897: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
2898: l_api_name,
2899: G_PKG_NAME,
2900: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 2897: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

2893: x_msg_data,
2894: '_PVT');
2895:
2896: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2897: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
2898: l_api_name,
2899: G_PKG_NAME,
2900: 'OKL_API.G_RET_STS_UNEXP_ERROR',
2901: x_msg_count,

Line 2900: 'OKL_API.G_RET_STS_UNEXP_ERROR',

2896: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2897: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
2898: l_api_name,
2899: G_PKG_NAME,
2900: 'OKL_API.G_RET_STS_UNEXP_ERROR',
2901: x_msg_count,
2902: x_msg_data,
2903: '_PVT');
2904:

Line 2906: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

2902: x_msg_data,
2903: '_PVT');
2904:
2905: WHEN OTHERS THEN
2906: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
2907: l_api_name,
2908: G_PKG_NAME,
2909: 'OTHERS',
2910: x_msg_count,

Line 2918: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

2914: END update_report_trx_parameters;
2915:
2916: PROCEDURE delete_report_trx_parameters(
2917: p_api_version IN NUMBER,
2918: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
2919: x_return_status OUT NOCOPY VARCHAR2,
2920: x_msg_count OUT NOCOPY NUMBER,
2921: x_msg_data OUT NOCOPY VARCHAR2,
2922: p_rtp_rec IN rtp_rec_type

Line 2925: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

2921: x_msg_data OUT NOCOPY VARCHAR2,
2922: p_rtp_rec IN rtp_rec_type
2923: ) IS
2924:
2925: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2926: l_api_name VARCHAR2(30) := 'DELETE_REPORT_TRX_PARAMS';
2927:
2928: BEGIN
2929: -- Call start_activity to create savepoint, check compatibility

Line 2931: l_return_status := OKL_API.START_ACTIVITY (

2927:
2928: BEGIN
2929: -- Call start_activity to create savepoint, check compatibility
2930: -- and initialize message list
2931: l_return_status := OKL_API.START_ACTIVITY (
2932: l_api_name,
2933: p_init_msg_list,
2934: '_PVT',
2935: l_return_status);