DBA Data[Home] [Help]

APPS.OKL_VENDOR_AGREEMENT_PUB dependencies on OKC_API

Line 131: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

127: p_hdr_rec => p_hdr_rec,
128: p_parent_agreement_number => p_parent_agreement_number,
129: x_header_rec => lx_header_rec,
130: x_k_header_rec => lx_k_header_rec);
131: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
132: RAISE OKC_API.G_EXCEPTION_ERROR;
133: END IF;
134:
135: /* Party Role */

Line 132: RAISE OKC_API.G_EXCEPTION_ERROR;

128: p_parent_agreement_number => p_parent_agreement_number,
129: x_header_rec => lx_header_rec,
130: x_k_header_rec => lx_k_header_rec);
131: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
132: RAISE OKC_API.G_EXCEPTION_ERROR;
133: END IF;
134:
135: /* Party Role */
136: IF (p_party_role_contact_tbl.count > 0) THEN

Line 184: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

180: x_msg_count => x_msg_count,
181: x_msg_data => x_msg_data,
182: p_cplv_tbl => l_cplv_tbl,
183: x_cplv_tbl => lx_cplv_tbl);
184: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
185: RAISE OKC_API.G_EXCEPTION_ERROR;
186: END IF;
187: END IF;
188:

Line 185: RAISE OKC_API.G_EXCEPTION_ERROR;

181: x_msg_data => x_msg_data,
182: p_cplv_tbl => l_cplv_tbl,
183: x_cplv_tbl => lx_cplv_tbl);
184: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
185: RAISE OKC_API.G_EXCEPTION_ERROR;
186: END IF;
187: END IF;
188:
189: /* Party Contact */

Line 226: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

222: x_msg_count => x_msg_count,
223: x_msg_data => x_msg_data,
224: p_ctcv_tbl => l_ctcv_tbl,
225: x_ctcv_tbl => lx_ctcv_tbl);
226: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
227: RAISE OKC_API.G_EXCEPTION_ERROR;
228: END IF;
229: END IF;
230: /* Terms and Conditions */

Line 227: RAISE OKC_API.G_EXCEPTION_ERROR;

223: x_msg_data => x_msg_data,
224: p_ctcv_tbl => l_ctcv_tbl,
225: x_ctcv_tbl => lx_ctcv_tbl);
226: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
227: RAISE OKC_API.G_EXCEPTION_ERROR;
228: END IF;
229: END IF;
230: /* Terms and Conditions */
231: IF (p_terms_n_conditions_tbl.count > 0) THEN

Line 278: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

274: p_line_id => l_line_id,
275: p_cpl_id => l_cpl_id,
276: p_rrd_id => l_rrd_id,
277: p_rgr_tbl => l_rgr_tbl);
278: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
279: RAISE OKC_API.G_EXCEPTION_ERROR;
280: END IF;
281: END IF;
282:

Line 279: RAISE OKC_API.G_EXCEPTION_ERROR;

275: p_cpl_id => l_cpl_id,
276: p_rrd_id => l_rrd_id,
277: p_rgr_tbl => l_rgr_tbl);
278: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
279: RAISE OKC_API.G_EXCEPTION_ERROR;
280: END IF;
281: END IF;
282:
283: /* Vendor Billing */

Line 304: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

300: x_msg_count => x_msg_count,
301: x_msg_data => x_msg_data,
302: p_cplv_rec => l_cplv_rec,
303: x_cplv_rec => lx_cplv_rec);
304: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
305: RAISE OKC_API.G_EXCEPTION_ERROR;
306: END IF;
307: l_rgr_tbl.DELETE;
308: -- Process Customer ID

Line 305: RAISE OKC_API.G_EXCEPTION_ERROR;

301: x_msg_data => x_msg_data,
302: p_cplv_rec => l_cplv_rec,
303: x_cplv_rec => lx_cplv_rec);
304: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
305: RAISE OKC_API.G_EXCEPTION_ERROR;
306: END IF;
307: l_rgr_tbl.DELETE;
308: -- Process Customer ID
309: -- rabhupat bug#4520143 removed the redundent condition

Line 406: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

402: p_line_id => l_line_id,
403: p_cpl_id => l_cpl_id,
404: p_rrd_id => l_rrd_id,
405: p_rgr_tbl => l_rgr_tbl);
406: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
407: RAISE OKC_API.G_EXCEPTION_ERROR;
408: END IF;
409: END IF;
410: /* Article */

Line 407: RAISE OKC_API.G_EXCEPTION_ERROR;

403: p_cpl_id => l_cpl_id,
404: p_rrd_id => l_rrd_id,
405: p_rgr_tbl => l_rgr_tbl);
406: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
407: RAISE OKC_API.G_EXCEPTION_ERROR;
408: END IF;
409: END IF;
410: /* Article */
411: IF (p_article_tbl.count > 0) THEN

Line 433: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

429: x_msg_count => x_msg_count,
430: x_msg_data => x_msg_data,
431: p_catv_tbl => l_catv_tbl,
432: x_catv_tbl => lx_catv_tbl);
433: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
434: RAISE OKC_API.G_EXCEPTION_ERROR;
435: END IF;
436: END IF;
437:

Line 434: RAISE OKC_API.G_EXCEPTION_ERROR;

430: x_msg_data => x_msg_data,
431: p_catv_tbl => l_catv_tbl,
432: x_catv_tbl => lx_catv_tbl);
433: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
434: RAISE OKC_API.G_EXCEPTION_ERROR;
435: END IF;
436: END IF;
437:
438: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count

Line 442: WHEN OKC_API.G_EXCEPTION_ERROR THEN

438: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count
439: ,x_msg_data => x_msg_data );
440:
441: EXCEPTION
442: WHEN OKC_API.G_EXCEPTION_ERROR THEN
443: x_return_status := OKC_API.HANDLE_EXCEPTIONS
444: (substr(l_api_name,1,26),
445: G_PKG_NAME,
446: 'OKC_API.G_RET_STS_ERROR',

Line 443: x_return_status := OKC_API.HANDLE_EXCEPTIONS

439: ,x_msg_data => x_msg_data );
440:
441: EXCEPTION
442: WHEN OKC_API.G_EXCEPTION_ERROR THEN
443: x_return_status := OKC_API.HANDLE_EXCEPTIONS
444: (substr(l_api_name,1,26),
445: G_PKG_NAME,
446: 'OKC_API.G_RET_STS_ERROR',
447: x_msg_count,

Line 446: 'OKC_API.G_RET_STS_ERROR',

442: WHEN OKC_API.G_EXCEPTION_ERROR THEN
443: x_return_status := OKC_API.HANDLE_EXCEPTIONS
444: (substr(l_api_name,1,26),
445: G_PKG_NAME,
446: 'OKC_API.G_RET_STS_ERROR',
447: x_msg_count,
448: x_msg_data,
449: '_PUB');
450: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 450: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

446: 'OKC_API.G_RET_STS_ERROR',
447: x_msg_count,
448: x_msg_data,
449: '_PUB');
450: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
451: x_return_status := OKC_API.HANDLE_EXCEPTIONS
452: (substr(l_api_name,1,26),
453: G_PKG_NAME,
454: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 451: x_return_status := OKC_API.HANDLE_EXCEPTIONS

447: x_msg_count,
448: x_msg_data,
449: '_PUB');
450: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
451: x_return_status := OKC_API.HANDLE_EXCEPTIONS
452: (substr(l_api_name,1,26),
453: G_PKG_NAME,
454: 'OKC_API.G_RET_STS_UNEXP_ERROR',
455: x_msg_count,

Line 454: 'OKC_API.G_RET_STS_UNEXP_ERROR',

450: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
451: x_return_status := OKC_API.HANDLE_EXCEPTIONS
452: (substr(l_api_name,1,26),
453: G_PKG_NAME,
454: 'OKC_API.G_RET_STS_UNEXP_ERROR',
455: x_msg_count,
456: x_msg_data,
457: '_PUB');
458: WHEN OTHERS THEN

Line 459: x_return_status := OKC_API.HANDLE_EXCEPTIONS

455: x_msg_count,
456: x_msg_data,
457: '_PUB');
458: WHEN OTHERS THEN
459: x_return_status := OKC_API.HANDLE_EXCEPTIONS
460: (substr(l_api_name,1,26),
461: G_PKG_NAME,
462: 'OTHERS',
463: x_msg_count,