DBA Data[Home] [Help]

APPS.OKL_SETUP_TRXPARAMS_PVT dependencies on OKL_API

Line 76: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

72: CLOSE l_okl_sxp_index_csr;
73: end if;
74: WHEN OTHERS THEN
75: -- store SQL error message on message stack for caller
76: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
77: p_msg_name => G_UNEXPECTED_ERROR,
78: p_token1 => G_SQLCODE_TOKEN,
79: p_token1_value => sqlcode,
80: p_token2 => G_SQLERRM_TOKEN,

Line 133: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

129: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
130: x_return_status := G_RET_STS_UNEXP_ERROR;
131: WHEN OTHERS THEN
132: -- store SQL error message on message stack for caller
133: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
134: p_msg_name => G_UNEXPECTED_ERROR,
135: p_token1 => G_SQLCODE_TOKEN,
136: p_token1_value => sqlcode,
137: p_token2 => G_SQLERRM_TOKEN,

Line 186: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

182: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
183: x_return_status := G_RET_STS_UNEXP_ERROR;
184: WHEN OTHERS THEN
185: -- store SQL error message on message stack for caller
186: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
187: p_msg_name => G_UNEXPECTED_ERROR,
188: p_token1 => G_SQLCODE_TOKEN,
189: p_token1_value => sqlcode,
190: p_token2 => G_SQLERRM_TOKEN,

Line 237: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

233: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
234: x_return_status := G_RET_STS_UNEXP_ERROR;
235: WHEN OTHERS THEN
236: -- store SQL error message on message stack for caller
237: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
238: p_msg_name => G_UNEXPECTED_ERROR,
239: p_token1 => G_SQLCODE_TOKEN,
240: p_token1_value => sqlcode,
241: p_token2 => G_SQLERRM_TOKEN,

Line 281: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

277:
278: l_sxpv_rec := p_sxpv_rec;
279:
280: IF l_sxpv_rec.sif_id IS NULL THEN
281: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
282: p_msg_name => G_REQUIRED_VALUE,
283: p_token1 => G_COL_NAME_TOKEN,
284: p_token1_value => 'SIF_ID'
285: );

Line 290: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

286: RAISE G_EXCEPTION_ERROR;
287: END IF;
288:
289: IF l_sxpv_rec.spp_id IS NULL THEN
290: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
291: p_msg_name => G_REQUIRED_VALUE,
292: p_token1 => G_COL_NAME_TOKEN,
293: p_token1_value => 'SPP_ID'
294: );

Line 330: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

326: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
327: x_return_status := G_RET_STS_UNEXP_ERROR;
328: WHEN OTHERS THEN
329: -- store SQL error message on message stack for caller
330: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
331: p_msg_name => G_UNEXPECTED_ERROR,
332: p_token1 => G_SQLCODE_TOKEN,
333: p_token1_value => sqlcode,
334: p_token2 => G_SQLERRM_TOKEN,

Line 376: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

372: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
373: x_return_status := G_RET_STS_UNEXP_ERROR;
374: WHEN OTHERS THEN
375: -- store SQL error message on message stack for caller
376: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
377: p_msg_name => G_UNEXPECTED_ERROR,
378: p_token1 => G_SQLCODE_TOKEN,
379: p_token1_value => sqlcode,
380: p_token2 => G_SQLERRM_TOKEN,

Line 404: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

400: l_sxpv_rec sxpv_rec_type;
401: BEGIN
402:
403: IF p_sxpv_rec.kle_id IS NULL THEN
404: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
405: p_msg_name => G_OKL_LLA_ASSET_REQUIRED);
406: RAISE G_EXCEPTION_ERROR;
407: ELSE
408: create_trx_parm(

Line 431: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

427: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
428: x_return_status := G_RET_STS_UNEXP_ERROR;
429: WHEN OTHERS THEN
430: -- store SQL error message on message stack for caller
431: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
432: p_msg_name => G_UNEXPECTED_ERROR,
433: p_token1 => G_SQLCODE_TOKEN,
434: p_token1_value => sqlcode,
435: p_token2 => G_SQLERRM_TOKEN,

Line 459: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

455: l_sxpv_rec sxpv_rec_type;
456: BEGIN
457:
458: IF p_sxpv_rec.kle_id IS NULL THEN
459: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
460: p_msg_name => G_OKL_LLA_ASSET_REQUIRED);
461: RAISE G_EXCEPTION_ERROR;
462: ELSE
463: update_trx_parm(

Line 486: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

482: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
483: x_return_status := G_RET_STS_UNEXP_ERROR;
484: WHEN OTHERS THEN
485: -- store SQL error message on message stack for caller
486: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
487: p_msg_name => G_UNEXPECTED_ERROR,
488: p_token1 => G_SQLCODE_TOKEN,
489: p_token1_value => sqlcode,
490: p_token2 => G_SQLERRM_TOKEN,

Line 536: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

532: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
533: x_return_status := G_RET_STS_UNEXP_ERROR;
534: WHEN OTHERS THEN
535: -- store SQL error message on message stack for caller
536: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
537: p_msg_name => G_UNEXPECTED_ERROR,
538: p_token1 => G_SQLCODE_TOKEN,
539: p_token1_value => sqlcode,
540: p_token2 => G_SQLERRM_TOKEN,

Line 587: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

583: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
584: x_return_status := G_RET_STS_UNEXP_ERROR;
585: WHEN OTHERS THEN
586: -- store SQL error message on message stack for caller
587: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
588: p_msg_name => G_UNEXPECTED_ERROR,
589: p_token1 => G_SQLCODE_TOKEN,
590: p_token1_value => sqlcode,
591: p_token2 => G_SQLERRM_TOKEN,