eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_VP_PARTY_PAYMENT_PVT dependencies on OKC_API

Line 9: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

5: x_return_status OUT NOCOPY VARCHAR2,
6: p_srfvv_rec IN srfvv_rec_type
7: ) IS
8: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_PARTY_PYMNT_RECORD';
9: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
10:
11: BEGIN
12:
13: x_return_status := l_return_status;

Line 47: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

43: END validate_party_pymnt_record;
44:
45: PROCEDURE create_party_pymnt_dtls(
46: p_api_version IN NUMBER,
47: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
48: x_return_status OUT NOCOPY VARCHAR2,
49: x_msg_count OUT NOCOPY NUMBER,
50: x_msg_data OUT NOCOPY VARCHAR2,
51: p_srfvv_rec IN srfvv_rec_type,

Line 55: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

51: p_srfvv_rec IN srfvv_rec_type,
52: x_srfvv_rec OUT NOCOPY srfvv_rec_type
53: ) IS
54: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_PARTY_PYMNT_DTLS';
55: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
56:
57: -- sjalasut, added cursor to derive the chr_id for flipping the agreement status to INCOMPLETE
58: CURSOR c_get_chr_csr(cp_cpl_id okc_k_party_roles_b.id%TYPE)IS
59: SELECT dnz_chr_id

Line 68: l_return_status := OKC_API.START_ACTIVITY (l_api_name

64: BEGIN
65: x_return_status := l_return_status;
66: -- Call start_activity to create savepoint, check compatibility
67: -- and initialize message list
68: l_return_status := OKC_API.START_ACTIVITY (l_api_name
69: ,p_init_msg_list
70: ,'_PVT'
71: ,x_return_status);
72: -- Check if activity started successfully

Line 73: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

69: ,p_init_msg_list
70: ,'_PVT'
71: ,x_return_status);
72: -- Check if activity started successfully
73: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
74: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
75: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
76: RAISE OKC_API.G_EXCEPTION_ERROR;
77: END IF;

Line 74: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

70: ,'_PVT'
71: ,x_return_status);
72: -- Check if activity started successfully
73: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
74: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
75: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
76: RAISE OKC_API.G_EXCEPTION_ERROR;
77: END IF;
78:

Line 75: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

71: ,x_return_status);
72: -- Check if activity started successfully
73: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
74: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
75: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
76: RAISE OKC_API.G_EXCEPTION_ERROR;
77: END IF;
78:
79: OKL_PYD_PVT.insert_row(p_api_version,

Line 76: RAISE OKC_API.G_EXCEPTION_ERROR;

72: -- Check if activity started successfully
73: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
74: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
75: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
76: RAISE OKC_API.G_EXCEPTION_ERROR;
77: END IF;
78:
79: OKL_PYD_PVT.insert_row(p_api_version,
80: p_init_msg_list,

Line 96: RAISE OKC_API.G_EXCEPTION_ERROR;

92:
93: validate_party_pymnt_record(x_return_status, x_srfvv_rec);
94: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
95: l_return_status := x_return_status;
96: RAISE OKC_API.G_EXCEPTION_ERROR;
97: END IF;
98:
99: -- sjalasut, added passed_to_incomplete. START
100: -- whenever party payment details are created or updated, if the context agreement is PASSED, then

Line 123: OKC_API.END_ACTIVITY (x_msg_count

119: END IF;
120: -- sjalasut, added passed_to_incomplete. END
121:
122: x_return_status := l_return_status;
123: OKC_API.END_ACTIVITY (x_msg_count
124: ,x_msg_data );
125:
126: EXCEPTION
127: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 127: WHEN OKC_API.G_EXCEPTION_ERROR THEN

123: OKC_API.END_ACTIVITY (x_msg_count
124: ,x_msg_data );
125:
126: EXCEPTION
127: WHEN OKC_API.G_EXCEPTION_ERROR THEN
128: x_return_status := OKC_API.HANDLE_EXCEPTIONS
129: (l_api_name,
130: G_PKG_NAME,
131: 'OKC_API.G_RET_STS_ERROR',

Line 128: x_return_status := OKC_API.HANDLE_EXCEPTIONS

124: ,x_msg_data );
125:
126: EXCEPTION
127: WHEN OKC_API.G_EXCEPTION_ERROR THEN
128: x_return_status := OKC_API.HANDLE_EXCEPTIONS
129: (l_api_name,
130: G_PKG_NAME,
131: 'OKC_API.G_RET_STS_ERROR',
132: x_msg_count,

Line 131: 'OKC_API.G_RET_STS_ERROR',

127: WHEN OKC_API.G_EXCEPTION_ERROR THEN
128: x_return_status := OKC_API.HANDLE_EXCEPTIONS
129: (l_api_name,
130: G_PKG_NAME,
131: 'OKC_API.G_RET_STS_ERROR',
132: x_msg_count,
133: x_msg_data,
134: '_PVT');
135: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 135: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

131: 'OKC_API.G_RET_STS_ERROR',
132: x_msg_count,
133: x_msg_data,
134: '_PVT');
135: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
136: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
137: (l_api_name,
138: G_PKG_NAME,
139: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 136: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

132: x_msg_count,
133: x_msg_data,
134: '_PVT');
135: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
136: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
137: (l_api_name,
138: G_PKG_NAME,
139: 'OKC_API.G_RET_STS_UNEXP_ERROR',
140: x_msg_count,

Line 139: 'OKC_API.G_RET_STS_UNEXP_ERROR',

135: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
136: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
137: (l_api_name,
138: G_PKG_NAME,
139: 'OKC_API.G_RET_STS_UNEXP_ERROR',
140: x_msg_count,
141: x_msg_data,
142: '_PVT');
143: WHEN OTHERS THEN

Line 144: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

140: x_msg_count,
141: x_msg_data,
142: '_PVT');
143: WHEN OTHERS THEN
144: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
145: (l_api_name,
146: G_PKG_NAME,
147: 'OTHERS',
148: x_msg_count,

Line 155: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

151: END create_party_pymnt_dtls;
152:
153: PROCEDURE create_party_pymnt_dtls(
154: p_api_version IN NUMBER,
155: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
156: x_return_status OUT NOCOPY VARCHAR2,
157: x_msg_count OUT NOCOPY NUMBER,
158: x_msg_data OUT NOCOPY VARCHAR2,
159: p_srfvv_tbl IN srfvv_tbl_type,

Line 163: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

159: p_srfvv_tbl IN srfvv_tbl_type,
160: x_srfvv_tbl OUT NOCOPY srfvv_tbl_type
161: ) IS
162: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_PARTY_PYMNT_DTLS';
163: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
164: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
165: i NUMBER;
166: BEGIN
167:

Line 200: WHEN OKC_API.G_EXCEPTION_ERROR THEN

196: raise OKL_API.G_EXCEPTION_ERROR;
197: End If;
198:
199: EXCEPTION
200: WHEN OKC_API.G_EXCEPTION_ERROR THEN
201: x_return_status := OKC_API.HANDLE_EXCEPTIONS
202: (l_api_name,
203: G_PKG_NAME,
204: 'OKC_API.G_RET_STS_ERROR',

Line 201: x_return_status := OKC_API.HANDLE_EXCEPTIONS

197: End If;
198:
199: EXCEPTION
200: WHEN OKC_API.G_EXCEPTION_ERROR THEN
201: x_return_status := OKC_API.HANDLE_EXCEPTIONS
202: (l_api_name,
203: G_PKG_NAME,
204: 'OKC_API.G_RET_STS_ERROR',
205: x_msg_count,

Line 204: 'OKC_API.G_RET_STS_ERROR',

200: WHEN OKC_API.G_EXCEPTION_ERROR THEN
201: x_return_status := OKC_API.HANDLE_EXCEPTIONS
202: (l_api_name,
203: G_PKG_NAME,
204: 'OKC_API.G_RET_STS_ERROR',
205: x_msg_count,
206: x_msg_data,
207: '_PVT');
208: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 208: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

204: 'OKC_API.G_RET_STS_ERROR',
205: x_msg_count,
206: x_msg_data,
207: '_PVT');
208: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
209: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
210: (l_api_name,
211: G_PKG_NAME,
212: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 209: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

205: x_msg_count,
206: x_msg_data,
207: '_PVT');
208: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
209: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
210: (l_api_name,
211: G_PKG_NAME,
212: 'OKC_API.G_RET_STS_UNEXP_ERROR',
213: x_msg_count,

Line 212: 'OKC_API.G_RET_STS_UNEXP_ERROR',

208: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
209: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
210: (l_api_name,
211: G_PKG_NAME,
212: 'OKC_API.G_RET_STS_UNEXP_ERROR',
213: x_msg_count,
214: x_msg_data,
215: '_PVT');
216: WHEN OTHERS THEN

Line 217: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

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

Line 228: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

224: END create_party_pymnt_dtls;
225:
226: PROCEDURE lock_party_pymnt_dtls(
227: p_api_version IN NUMBER,
228: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
229: x_return_status OUT NOCOPY VARCHAR2,
230: x_msg_count OUT NOCOPY NUMBER,
231: x_msg_data OUT NOCOPY VARCHAR2,
232: p_srfvv_rec IN srfvv_rec_type

Line 235: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

231: x_msg_data OUT NOCOPY VARCHAR2,
232: p_srfvv_rec IN srfvv_rec_type
233: ) IS
234: l_api_name CONSTANT VARCHAR2(30) := 'LOCK_PARTY_PYMNT_DTLS';
235: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
236: BEGIN
237: x_return_status := l_return_status;
238: -- Call start_activity to create savepoint, check compatibility
239: -- and initialize message list

Line 240: l_return_status := OKC_API.START_ACTIVITY (l_api_name

236: BEGIN
237: x_return_status := l_return_status;
238: -- Call start_activity to create savepoint, check compatibility
239: -- and initialize message list
240: l_return_status := OKC_API.START_ACTIVITY (l_api_name
241: ,p_init_msg_list
242: ,'_PVT'
243: ,x_return_status);
244: -- Check if activity started successfully

Line 245: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

241: ,p_init_msg_list
242: ,'_PVT'
243: ,x_return_status);
244: -- Check if activity started successfully
245: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
246: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
247: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
248: RAISE OKC_API.G_EXCEPTION_ERROR;
249: END IF;

Line 246: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

242: ,'_PVT'
243: ,x_return_status);
244: -- Check if activity started successfully
245: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
246: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
247: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
248: RAISE OKC_API.G_EXCEPTION_ERROR;
249: END IF;
250:

Line 247: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

243: ,x_return_status);
244: -- Check if activity started successfully
245: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
246: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
247: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
248: RAISE OKC_API.G_EXCEPTION_ERROR;
249: END IF;
250:
251: OKL_PYD_PVT.lock_row(p_api_version,

Line 248: RAISE OKC_API.G_EXCEPTION_ERROR;

244: -- Check if activity started successfully
245: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
246: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
247: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
248: RAISE OKC_API.G_EXCEPTION_ERROR;
249: END IF;
250:
251: OKL_PYD_PVT.lock_row(p_api_version,
252: p_init_msg_list,

Line 264: OKC_API.END_ACTIVITY (x_msg_count

260: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
261: raise OKL_API.G_EXCEPTION_ERROR;
262: End If;
263:
264: OKC_API.END_ACTIVITY (x_msg_count
265: ,x_msg_data );
266:
267: EXCEPTION
268: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 268: WHEN OKC_API.G_EXCEPTION_ERROR THEN

264: OKC_API.END_ACTIVITY (x_msg_count
265: ,x_msg_data );
266:
267: EXCEPTION
268: WHEN OKC_API.G_EXCEPTION_ERROR THEN
269: x_return_status := OKC_API.HANDLE_EXCEPTIONS
270: (l_api_name,
271: G_PKG_NAME,
272: 'OKC_API.G_RET_STS_ERROR',

Line 269: x_return_status := OKC_API.HANDLE_EXCEPTIONS

265: ,x_msg_data );
266:
267: EXCEPTION
268: WHEN OKC_API.G_EXCEPTION_ERROR THEN
269: x_return_status := OKC_API.HANDLE_EXCEPTIONS
270: (l_api_name,
271: G_PKG_NAME,
272: 'OKC_API.G_RET_STS_ERROR',
273: x_msg_count,

Line 272: 'OKC_API.G_RET_STS_ERROR',

268: WHEN OKC_API.G_EXCEPTION_ERROR THEN
269: x_return_status := OKC_API.HANDLE_EXCEPTIONS
270: (l_api_name,
271: G_PKG_NAME,
272: 'OKC_API.G_RET_STS_ERROR',
273: x_msg_count,
274: x_msg_data,
275: '_PVT');
276: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 276: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

272: 'OKC_API.G_RET_STS_ERROR',
273: x_msg_count,
274: x_msg_data,
275: '_PVT');
276: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
277: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
278: (l_api_name,
279: G_PKG_NAME,
280: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 277: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

273: x_msg_count,
274: x_msg_data,
275: '_PVT');
276: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
277: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
278: (l_api_name,
279: G_PKG_NAME,
280: 'OKC_API.G_RET_STS_UNEXP_ERROR',
281: x_msg_count,

Line 280: 'OKC_API.G_RET_STS_UNEXP_ERROR',

276: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
277: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
278: (l_api_name,
279: G_PKG_NAME,
280: 'OKC_API.G_RET_STS_UNEXP_ERROR',
281: x_msg_count,
282: x_msg_data,
283: '_PVT');
284: WHEN OTHERS THEN

Line 285: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

281: x_msg_count,
282: x_msg_data,
283: '_PVT');
284: WHEN OTHERS THEN
285: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
286: (l_api_name,
287: G_PKG_NAME,
288: 'OTHERS',
289: x_msg_count,

Line 296: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

292: END lock_party_pymnt_dtls;
293:
294: PROCEDURE lock_party_pymnt_dtls(
295: p_api_version IN NUMBER,
296: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
297: x_return_status OUT NOCOPY VARCHAR2,
298: x_msg_count OUT NOCOPY NUMBER,
299: x_msg_data OUT NOCOPY VARCHAR2,
300: p_srfvv_tbl IN srfvv_tbl_type

Line 303: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

299: x_msg_data OUT NOCOPY VARCHAR2,
300: p_srfvv_tbl IN srfvv_tbl_type
301: ) IS
302: l_api_name CONSTANT VARCHAR2(30) := 'LOCK_PARTY_PYMNT_DTLS';
303: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
304: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
305: i NUMBER;
306: BEGIN
307:

Line 339: WHEN OKC_API.G_EXCEPTION_ERROR THEN

335: raise OKL_API.G_EXCEPTION_ERROR;
336: End If;
337:
338: EXCEPTION
339: WHEN OKC_API.G_EXCEPTION_ERROR THEN
340: x_return_status := OKC_API.HANDLE_EXCEPTIONS
341: (l_api_name,
342: G_PKG_NAME,
343: 'OKC_API.G_RET_STS_ERROR',

Line 340: x_return_status := OKC_API.HANDLE_EXCEPTIONS

336: End If;
337:
338: EXCEPTION
339: WHEN OKC_API.G_EXCEPTION_ERROR THEN
340: x_return_status := OKC_API.HANDLE_EXCEPTIONS
341: (l_api_name,
342: G_PKG_NAME,
343: 'OKC_API.G_RET_STS_ERROR',
344: x_msg_count,

Line 343: 'OKC_API.G_RET_STS_ERROR',

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

Line 347: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

343: 'OKC_API.G_RET_STS_ERROR',
344: x_msg_count,
345: x_msg_data,
346: '_PVT');
347: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
348: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
349: (l_api_name,
350: G_PKG_NAME,
351: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 348: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

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

Line 351: 'OKC_API.G_RET_STS_UNEXP_ERROR',

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

Line 356: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

352: x_msg_count,
353: x_msg_data,
354: '_PVT');
355: WHEN OTHERS THEN
356: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
357: (l_api_name,
358: G_PKG_NAME,
359: 'OTHERS',
360: x_msg_count,

Line 367: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

363: END lock_party_pymnt_dtls;
364:
365: PROCEDURE delete_party_pymnt_dtls(
366: p_api_version IN NUMBER,
367: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
368: x_return_status OUT NOCOPY VARCHAR2,
369: x_msg_count OUT NOCOPY NUMBER,
370: x_msg_data OUT NOCOPY VARCHAR2,
371: p_srfvv_rec IN srfvv_rec_type

Line 374: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

370: x_msg_data OUT NOCOPY VARCHAR2,
371: p_srfvv_rec IN srfvv_rec_type
372: ) IS
373: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_PARTY_PYMNT_DTLS';
374: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
375: BEGIN
376: x_return_status := l_return_status;
377: -- Call start_activity to create savepoint, check compatibility
378: -- and initialize message list

Line 379: l_return_status := OKC_API.START_ACTIVITY (l_api_name

375: BEGIN
376: x_return_status := l_return_status;
377: -- Call start_activity to create savepoint, check compatibility
378: -- and initialize message list
379: l_return_status := OKC_API.START_ACTIVITY (l_api_name
380: ,p_init_msg_list
381: ,'_PVT'
382: ,x_return_status);
383: -- Check if activity started successfully

Line 384: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

380: ,p_init_msg_list
381: ,'_PVT'
382: ,x_return_status);
383: -- Check if activity started successfully
384: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
385: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
386: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
387: RAISE OKC_API.G_EXCEPTION_ERROR;
388: END IF;

Line 385: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

381: ,'_PVT'
382: ,x_return_status);
383: -- Check if activity started successfully
384: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
385: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
386: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
387: RAISE OKC_API.G_EXCEPTION_ERROR;
388: END IF;
389:

Line 386: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

382: ,x_return_status);
383: -- Check if activity started successfully
384: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
385: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
386: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
387: RAISE OKC_API.G_EXCEPTION_ERROR;
388: END IF;
389:
390: OKL_PYD_PVT.delete_row(p_api_version,

Line 387: RAISE OKC_API.G_EXCEPTION_ERROR;

383: -- Check if activity started successfully
384: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
385: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
386: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
387: RAISE OKC_API.G_EXCEPTION_ERROR;
388: END IF;
389:
390: OKL_PYD_PVT.delete_row(p_api_version,
391: p_init_msg_list,

Line 403: OKC_API.END_ACTIVITY (x_msg_count

399: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
400: raise OKL_API.G_EXCEPTION_ERROR;
401: End If;
402:
403: OKC_API.END_ACTIVITY (x_msg_count
404: ,x_msg_data );
405:
406: EXCEPTION
407: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 407: WHEN OKC_API.G_EXCEPTION_ERROR THEN

403: OKC_API.END_ACTIVITY (x_msg_count
404: ,x_msg_data );
405:
406: EXCEPTION
407: WHEN OKC_API.G_EXCEPTION_ERROR THEN
408: x_return_status := OKC_API.HANDLE_EXCEPTIONS
409: (l_api_name,
410: G_PKG_NAME,
411: 'OKC_API.G_RET_STS_ERROR',

Line 408: x_return_status := OKC_API.HANDLE_EXCEPTIONS

404: ,x_msg_data );
405:
406: EXCEPTION
407: WHEN OKC_API.G_EXCEPTION_ERROR THEN
408: x_return_status := OKC_API.HANDLE_EXCEPTIONS
409: (l_api_name,
410: G_PKG_NAME,
411: 'OKC_API.G_RET_STS_ERROR',
412: x_msg_count,

Line 411: 'OKC_API.G_RET_STS_ERROR',

407: WHEN OKC_API.G_EXCEPTION_ERROR THEN
408: x_return_status := OKC_API.HANDLE_EXCEPTIONS
409: (l_api_name,
410: G_PKG_NAME,
411: 'OKC_API.G_RET_STS_ERROR',
412: x_msg_count,
413: x_msg_data,
414: '_PVT');
415: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 415: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

411: 'OKC_API.G_RET_STS_ERROR',
412: x_msg_count,
413: x_msg_data,
414: '_PVT');
415: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
416: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
417: (l_api_name,
418: G_PKG_NAME,
419: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 416: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

412: x_msg_count,
413: x_msg_data,
414: '_PVT');
415: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
416: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
417: (l_api_name,
418: G_PKG_NAME,
419: 'OKC_API.G_RET_STS_UNEXP_ERROR',
420: x_msg_count,

Line 419: 'OKC_API.G_RET_STS_UNEXP_ERROR',

415: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
416: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
417: (l_api_name,
418: G_PKG_NAME,
419: 'OKC_API.G_RET_STS_UNEXP_ERROR',
420: x_msg_count,
421: x_msg_data,
422: '_PVT');
423: WHEN OTHERS THEN

Line 424: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

420: x_msg_count,
421: x_msg_data,
422: '_PVT');
423: WHEN OTHERS THEN
424: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
425: (l_api_name,
426: G_PKG_NAME,
427: 'OTHERS',
428: x_msg_count,

Line 435: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

431: END delete_party_pymnt_dtls;
432:
433: PROCEDURE delete_party_pymnt_dtls(
434: p_api_version IN NUMBER,
435: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
436: x_return_status OUT NOCOPY VARCHAR2,
437: x_msg_count OUT NOCOPY NUMBER,
438: x_msg_data OUT NOCOPY VARCHAR2,
439: p_srfvv_tbl IN srfvv_tbl_type

Line 442: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

438: x_msg_data OUT NOCOPY VARCHAR2,
439: p_srfvv_tbl IN srfvv_tbl_type
440: ) IS
441: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_PARTY_PYMNT_DTLS';
442: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
443: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
444: i NUMBER;
445: BEGIN
446:

Line 478: WHEN OKC_API.G_EXCEPTION_ERROR THEN

474: raise OKL_API.G_EXCEPTION_ERROR;
475: End If;
476:
477: EXCEPTION
478: WHEN OKC_API.G_EXCEPTION_ERROR THEN
479: x_return_status := OKC_API.HANDLE_EXCEPTIONS
480: (l_api_name,
481: G_PKG_NAME,
482: 'OKC_API.G_RET_STS_ERROR',

Line 479: x_return_status := OKC_API.HANDLE_EXCEPTIONS

475: End If;
476:
477: EXCEPTION
478: WHEN OKC_API.G_EXCEPTION_ERROR THEN
479: x_return_status := OKC_API.HANDLE_EXCEPTIONS
480: (l_api_name,
481: G_PKG_NAME,
482: 'OKC_API.G_RET_STS_ERROR',
483: x_msg_count,

Line 482: 'OKC_API.G_RET_STS_ERROR',

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

Line 486: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

482: 'OKC_API.G_RET_STS_ERROR',
483: x_msg_count,
484: x_msg_data,
485: '_PVT');
486: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
487: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
488: (l_api_name,
489: G_PKG_NAME,
490: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 487: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

483: x_msg_count,
484: x_msg_data,
485: '_PVT');
486: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
487: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
488: (l_api_name,
489: G_PKG_NAME,
490: 'OKC_API.G_RET_STS_UNEXP_ERROR',
491: x_msg_count,

Line 490: 'OKC_API.G_RET_STS_UNEXP_ERROR',

486: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
487: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
488: (l_api_name,
489: G_PKG_NAME,
490: 'OKC_API.G_RET_STS_UNEXP_ERROR',
491: x_msg_count,
492: x_msg_data,
493: '_PVT');
494: WHEN OTHERS THEN

Line 495: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

491: x_msg_count,
492: x_msg_data,
493: '_PVT');
494: WHEN OTHERS THEN
495: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
496: (l_api_name,
497: G_PKG_NAME,
498: 'OTHERS',
499: x_msg_count,

Line 506: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

502: END delete_party_pymnt_dtls;
503:
504: PROCEDURE update_party_pymnt_dtls(
505: p_api_version IN NUMBER,
506: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
507: x_return_status OUT NOCOPY VARCHAR2,
508: x_msg_count OUT NOCOPY NUMBER,
509: x_msg_data OUT NOCOPY VARCHAR2,
510: p_srfvv_rec IN srfvv_rec_type,

Line 522: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

518: WHERE id = cp_cpl_id;
519: lv_dnz_chr_id okc_k_headers_b.id%TYPE;
520:
521: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_PARTY_PYMNT_DTLS';
522: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
523: BEGIN
524: x_return_status := l_return_status;
525: -- Call start_activity to create savepoint, check compatibility
526: -- and initialize message list

Line 527: l_return_status := OKC_API.START_ACTIVITY (l_api_name

523: BEGIN
524: x_return_status := l_return_status;
525: -- Call start_activity to create savepoint, check compatibility
526: -- and initialize message list
527: l_return_status := OKC_API.START_ACTIVITY (l_api_name
528: ,p_init_msg_list
529: ,'_PVT'
530: ,x_return_status);
531: -- Check if activity started successfully

Line 532: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

528: ,p_init_msg_list
529: ,'_PVT'
530: ,x_return_status);
531: -- Check if activity started successfully
532: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
533: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
534: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
535: RAISE OKC_API.G_EXCEPTION_ERROR;
536: END IF;

Line 533: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

529: ,'_PVT'
530: ,x_return_status);
531: -- Check if activity started successfully
532: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
533: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
534: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
535: RAISE OKC_API.G_EXCEPTION_ERROR;
536: END IF;
537:

Line 534: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

530: ,x_return_status);
531: -- Check if activity started successfully
532: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
533: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
534: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
535: RAISE OKC_API.G_EXCEPTION_ERROR;
536: END IF;
537:
538: OKL_PYD_PVT.update_row(p_api_version,

Line 535: RAISE OKC_API.G_EXCEPTION_ERROR;

531: -- Check if activity started successfully
532: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
533: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
534: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
535: RAISE OKC_API.G_EXCEPTION_ERROR;
536: END IF;
537:
538: OKL_PYD_PVT.update_row(p_api_version,
539: p_init_msg_list,

Line 555: RAISE OKC_API.G_EXCEPTION_ERROR;

551:
552: validate_party_pymnt_record(x_return_status, x_srfvv_rec);
553: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
554: l_return_status := x_return_status;
555: RAISE OKC_API.G_EXCEPTION_ERROR;
556: END IF;
557:
558: -- sjalasut, added passed_to_incomplete. START
559: -- whenever party payment details are created or updated, if the context agreement is PASSED, then

Line 581: OKC_API.END_ACTIVITY (x_msg_count

577: END IF;
578: END IF;
579: -- sjalasut, added passed_to_incomplete. END
580:
581: OKC_API.END_ACTIVITY (x_msg_count
582: ,x_msg_data );
583:
584: EXCEPTION
585: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 585: WHEN OKC_API.G_EXCEPTION_ERROR THEN

581: OKC_API.END_ACTIVITY (x_msg_count
582: ,x_msg_data );
583:
584: EXCEPTION
585: WHEN OKC_API.G_EXCEPTION_ERROR THEN
586: x_return_status := OKC_API.HANDLE_EXCEPTIONS
587: (l_api_name,
588: G_PKG_NAME,
589: 'OKC_API.G_RET_STS_ERROR',

Line 586: x_return_status := OKC_API.HANDLE_EXCEPTIONS

582: ,x_msg_data );
583:
584: EXCEPTION
585: WHEN OKC_API.G_EXCEPTION_ERROR THEN
586: x_return_status := OKC_API.HANDLE_EXCEPTIONS
587: (l_api_name,
588: G_PKG_NAME,
589: 'OKC_API.G_RET_STS_ERROR',
590: x_msg_count,

Line 589: 'OKC_API.G_RET_STS_ERROR',

585: WHEN OKC_API.G_EXCEPTION_ERROR THEN
586: x_return_status := OKC_API.HANDLE_EXCEPTIONS
587: (l_api_name,
588: G_PKG_NAME,
589: 'OKC_API.G_RET_STS_ERROR',
590: x_msg_count,
591: x_msg_data,
592: '_PVT');
593: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 593: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

589: 'OKC_API.G_RET_STS_ERROR',
590: x_msg_count,
591: x_msg_data,
592: '_PVT');
593: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
594: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
595: (l_api_name,
596: G_PKG_NAME,
597: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 594: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

590: x_msg_count,
591: x_msg_data,
592: '_PVT');
593: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
594: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
595: (l_api_name,
596: G_PKG_NAME,
597: 'OKC_API.G_RET_STS_UNEXP_ERROR',
598: x_msg_count,

Line 597: 'OKC_API.G_RET_STS_UNEXP_ERROR',

593: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
594: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
595: (l_api_name,
596: G_PKG_NAME,
597: 'OKC_API.G_RET_STS_UNEXP_ERROR',
598: x_msg_count,
599: x_msg_data,
600: '_PVT');
601: WHEN OTHERS THEN

Line 602: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

598: x_msg_count,
599: x_msg_data,
600: '_PVT');
601: WHEN OTHERS THEN
602: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
603: (l_api_name,
604: G_PKG_NAME,
605: 'OTHERS',
606: x_msg_count,

Line 613: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

609: END update_party_pymnt_dtls;
610:
611: PROCEDURE update_party_pymnt_dtls(
612: p_api_version IN NUMBER,
613: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
614: x_return_status OUT NOCOPY VARCHAR2,
615: x_msg_count OUT NOCOPY NUMBER,
616: x_msg_data OUT NOCOPY VARCHAR2,
617: p_srfvv_tbl IN srfvv_tbl_type,

Line 621: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

617: p_srfvv_tbl IN srfvv_tbl_type,
618: x_srfvv_tbl OUT NOCOPY srfvv_tbl_type
619: ) IS
620: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_PARTY_PYMNT_DTLS';
621: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
622: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
623: i NUMBER;
624:
625: BEGIN

Line 659: WHEN OKC_API.G_EXCEPTION_ERROR THEN

655: raise OKL_API.G_EXCEPTION_ERROR;
656: End If;
657:
658: EXCEPTION
659: WHEN OKC_API.G_EXCEPTION_ERROR THEN
660: x_return_status := OKC_API.HANDLE_EXCEPTIONS
661: (l_api_name,
662: G_PKG_NAME,
663: 'OKC_API.G_RET_STS_ERROR',

Line 660: x_return_status := OKC_API.HANDLE_EXCEPTIONS

656: End If;
657:
658: EXCEPTION
659: WHEN OKC_API.G_EXCEPTION_ERROR THEN
660: x_return_status := OKC_API.HANDLE_EXCEPTIONS
661: (l_api_name,
662: G_PKG_NAME,
663: 'OKC_API.G_RET_STS_ERROR',
664: x_msg_count,

Line 663: 'OKC_API.G_RET_STS_ERROR',

659: WHEN OKC_API.G_EXCEPTION_ERROR THEN
660: x_return_status := OKC_API.HANDLE_EXCEPTIONS
661: (l_api_name,
662: G_PKG_NAME,
663: 'OKC_API.G_RET_STS_ERROR',
664: x_msg_count,
665: x_msg_data,
666: '_PVT');
667: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 667: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

663: 'OKC_API.G_RET_STS_ERROR',
664: x_msg_count,
665: x_msg_data,
666: '_PVT');
667: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
668: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
669: (l_api_name,
670: G_PKG_NAME,
671: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 668: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

664: x_msg_count,
665: x_msg_data,
666: '_PVT');
667: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
668: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
669: (l_api_name,
670: G_PKG_NAME,
671: 'OKC_API.G_RET_STS_UNEXP_ERROR',
672: x_msg_count,

Line 671: 'OKC_API.G_RET_STS_UNEXP_ERROR',

667: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
668: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
669: (l_api_name,
670: G_PKG_NAME,
671: 'OKC_API.G_RET_STS_UNEXP_ERROR',
672: x_msg_count,
673: x_msg_data,
674: '_PVT');
675: WHEN OTHERS THEN

Line 676: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

672: x_msg_count,
673: x_msg_data,
674: '_PVT');
675: WHEN OTHERS THEN
676: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
677: (l_api_name,
678: G_PKG_NAME,
679: 'OTHERS',
680: x_msg_count,

Line 687: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

683: END update_party_pymnt_dtls;
684:
685: PROCEDURE validate_party_pymnt_dtls(
686: p_api_version IN NUMBER,
687: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
688: x_return_status OUT NOCOPY VARCHAR2,
689: x_msg_count OUT NOCOPY NUMBER,
690: x_msg_data OUT NOCOPY VARCHAR2,
691: p_srfvv_rec IN srfvv_rec_type

Line 694: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

690: x_msg_data OUT NOCOPY VARCHAR2,
691: p_srfvv_rec IN srfvv_rec_type
692: ) IS
693: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_PARTY_PYMNT_DTLS';
694: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
695: BEGIN
696: x_return_status := l_return_status;
697: -- Call start_activity to create savepoint, check compatibility
698: -- and initialize message list

Line 699: l_return_status := OKC_API.START_ACTIVITY (l_api_name

695: BEGIN
696: x_return_status := l_return_status;
697: -- Call start_activity to create savepoint, check compatibility
698: -- and initialize message list
699: l_return_status := OKC_API.START_ACTIVITY (l_api_name
700: ,p_init_msg_list
701: ,'_PVT'
702: ,x_return_status);
703: -- Check if activity started successfully

Line 704: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

700: ,p_init_msg_list
701: ,'_PVT'
702: ,x_return_status);
703: -- Check if activity started successfully
704: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
705: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
706: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
707: RAISE OKC_API.G_EXCEPTION_ERROR;
708: END IF;

Line 705: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

701: ,'_PVT'
702: ,x_return_status);
703: -- Check if activity started successfully
704: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
705: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
706: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
707: RAISE OKC_API.G_EXCEPTION_ERROR;
708: END IF;
709:

Line 706: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

702: ,x_return_status);
703: -- Check if activity started successfully
704: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
705: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
706: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
707: RAISE OKC_API.G_EXCEPTION_ERROR;
708: END IF;
709:
710: OKL_PYD_PVT.validate_row(p_api_version,

Line 707: RAISE OKC_API.G_EXCEPTION_ERROR;

703: -- Check if activity started successfully
704: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
705: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
706: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
707: RAISE OKC_API.G_EXCEPTION_ERROR;
708: END IF;
709:
710: OKL_PYD_PVT.validate_row(p_api_version,
711: p_init_msg_list,

Line 723: OKC_API.END_ACTIVITY (x_msg_count

719: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
720: raise OKL_API.G_EXCEPTION_ERROR;
721: End If;
722:
723: OKC_API.END_ACTIVITY (x_msg_count
724: ,x_msg_data );
725:
726: EXCEPTION
727: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 727: WHEN OKC_API.G_EXCEPTION_ERROR THEN

723: OKC_API.END_ACTIVITY (x_msg_count
724: ,x_msg_data );
725:
726: EXCEPTION
727: WHEN OKC_API.G_EXCEPTION_ERROR THEN
728: x_return_status := OKC_API.HANDLE_EXCEPTIONS
729: (l_api_name,
730: G_PKG_NAME,
731: 'OKC_API.G_RET_STS_ERROR',

Line 728: x_return_status := OKC_API.HANDLE_EXCEPTIONS

724: ,x_msg_data );
725:
726: EXCEPTION
727: WHEN OKC_API.G_EXCEPTION_ERROR THEN
728: x_return_status := OKC_API.HANDLE_EXCEPTIONS
729: (l_api_name,
730: G_PKG_NAME,
731: 'OKC_API.G_RET_STS_ERROR',
732: x_msg_count,

Line 731: 'OKC_API.G_RET_STS_ERROR',

727: WHEN OKC_API.G_EXCEPTION_ERROR THEN
728: x_return_status := OKC_API.HANDLE_EXCEPTIONS
729: (l_api_name,
730: G_PKG_NAME,
731: 'OKC_API.G_RET_STS_ERROR',
732: x_msg_count,
733: x_msg_data,
734: '_PVT');
735: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 735: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

731: 'OKC_API.G_RET_STS_ERROR',
732: x_msg_count,
733: x_msg_data,
734: '_PVT');
735: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
736: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
737: (l_api_name,
738: G_PKG_NAME,
739: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 736: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

732: x_msg_count,
733: x_msg_data,
734: '_PVT');
735: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
736: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
737: (l_api_name,
738: G_PKG_NAME,
739: 'OKC_API.G_RET_STS_UNEXP_ERROR',
740: x_msg_count,

Line 739: 'OKC_API.G_RET_STS_UNEXP_ERROR',

735: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
736: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
737: (l_api_name,
738: G_PKG_NAME,
739: 'OKC_API.G_RET_STS_UNEXP_ERROR',
740: x_msg_count,
741: x_msg_data,
742: '_PVT');
743: WHEN OTHERS THEN

Line 744: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

740: x_msg_count,
741: x_msg_data,
742: '_PVT');
743: WHEN OTHERS THEN
744: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
745: (l_api_name,
746: G_PKG_NAME,
747: 'OTHERS',
748: x_msg_count,

Line 755: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

751: END validate_party_pymnt_dtls;
752:
753: PROCEDURE validate_party_pymnt_dtls(
754: p_api_version IN NUMBER,
755: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
756: x_return_status OUT NOCOPY VARCHAR2,
757: x_msg_count OUT NOCOPY NUMBER,
758: x_msg_data OUT NOCOPY VARCHAR2,
759: p_srfvv_tbl IN srfvv_tbl_type

Line 762: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

758: x_msg_data OUT NOCOPY VARCHAR2,
759: p_srfvv_tbl IN srfvv_tbl_type
760: ) IS
761: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_PARTY_PYMNT_DTLS';
762: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
763: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
764: i NUMBER;
765: BEGIN
766:

Line 798: WHEN OKC_API.G_EXCEPTION_ERROR THEN

794: raise OKL_API.G_EXCEPTION_ERROR;
795: End If;
796:
797: EXCEPTION
798: WHEN OKC_API.G_EXCEPTION_ERROR THEN
799: x_return_status := OKC_API.HANDLE_EXCEPTIONS
800: (l_api_name,
801: G_PKG_NAME,
802: 'OKC_API.G_RET_STS_ERROR',

Line 799: x_return_status := OKC_API.HANDLE_EXCEPTIONS

795: End If;
796:
797: EXCEPTION
798: WHEN OKC_API.G_EXCEPTION_ERROR THEN
799: x_return_status := OKC_API.HANDLE_EXCEPTIONS
800: (l_api_name,
801: G_PKG_NAME,
802: 'OKC_API.G_RET_STS_ERROR',
803: x_msg_count,

Line 802: 'OKC_API.G_RET_STS_ERROR',

798: WHEN OKC_API.G_EXCEPTION_ERROR THEN
799: x_return_status := OKC_API.HANDLE_EXCEPTIONS
800: (l_api_name,
801: G_PKG_NAME,
802: 'OKC_API.G_RET_STS_ERROR',
803: x_msg_count,
804: x_msg_data,
805: '_PVT');
806: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 806: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

802: 'OKC_API.G_RET_STS_ERROR',
803: x_msg_count,
804: x_msg_data,
805: '_PVT');
806: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
807: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
808: (l_api_name,
809: G_PKG_NAME,
810: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 807: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

803: x_msg_count,
804: x_msg_data,
805: '_PVT');
806: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
807: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
808: (l_api_name,
809: G_PKG_NAME,
810: 'OKC_API.G_RET_STS_UNEXP_ERROR',
811: x_msg_count,

Line 810: 'OKC_API.G_RET_STS_UNEXP_ERROR',

806: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
807: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
808: (l_api_name,
809: G_PKG_NAME,
810: 'OKC_API.G_RET_STS_UNEXP_ERROR',
811: x_msg_count,
812: x_msg_data,
813: '_PVT');
814: WHEN OTHERS THEN

Line 815: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

811: x_msg_count,
812: x_msg_data,
813: '_PVT');
814: WHEN OTHERS THEN
815: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
816: (l_api_name,
817: G_PKG_NAME,
818: 'OTHERS',
819: x_msg_count,