DBA Data[Home] [Help]

APPS.OKL_SETUPPMVALUES_PVT dependencies on OKL_PMV_PVT

Line 235: --Okl_Api.set_message(Okl_Pmv_Pvt.G_APP_NAME,Okl_Pmv_Pvt.G_UNQS,Okl_Pmv_Pvt.G_TABLE_TOKEN, l_token_1); ---CHG001

231: FETCH c1 INTO l_pmv_status;
232: l_row_found := c1%FOUND;
233: CLOSE c1;
234: IF l_row_found THEN
235: --Okl_Api.set_message(Okl_Pmv_Pvt.G_APP_NAME,Okl_Pmv_Pvt.G_UNQS,Okl_Pmv_Pvt.G_TABLE_TOKEN, l_token_1); ---CHG001
236: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
237: p_msg_name => 'OKL_COLUMN_NOT_UNIQUE',
238: p_token1 => G_TABLE_TOKEN,
239: p_token1_value => l_token_1,

Line 357: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pmv_Pvt.g_app_name

353:
354: -- check for data before processing
355: IF (p_pmvv_rec.ptq_id IS NULL) OR
356: (p_pmvv_rec.ptq_id = Okl_Api.G_MISS_NUM) THEN
357: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pmv_Pvt.g_app_name
358: ,p_msg_name => Okl_Pmv_Pvt.g_required_value
359: ,p_token1 => Okl_Pmv_Pvt.g_col_name_token
360: ,p_token1_value => l_token_1);
361: x_return_status := Okl_Api.G_RET_STS_ERROR;

Line 358: ,p_msg_name => Okl_Pmv_Pvt.g_required_value

354: -- check for data before processing
355: IF (p_pmvv_rec.ptq_id IS NULL) OR
356: (p_pmvv_rec.ptq_id = Okl_Api.G_MISS_NUM) THEN
357: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pmv_Pvt.g_app_name
358: ,p_msg_name => Okl_Pmv_Pvt.g_required_value
359: ,p_token1 => Okl_Pmv_Pvt.g_col_name_token
360: ,p_token1_value => l_token_1);
361: x_return_status := Okl_Api.G_RET_STS_ERROR;
362: RAISE G_EXCEPTION_HALT_PROCESSING;

Line 359: ,p_token1 => Okl_Pmv_Pvt.g_col_name_token

355: IF (p_pmvv_rec.ptq_id IS NULL) OR
356: (p_pmvv_rec.ptq_id = Okl_Api.G_MISS_NUM) THEN
357: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pmv_Pvt.g_app_name
358: ,p_msg_name => Okl_Pmv_Pvt.g_required_value
359: ,p_token1 => Okl_Pmv_Pvt.g_col_name_token
360: ,p_token1_value => l_token_1);
361: x_return_status := Okl_Api.G_RET_STS_ERROR;
362: RAISE G_EXCEPTION_HALT_PROCESSING;
363: END IF;

Line 372: Okl_Api.set_message(Okl_Pmv_Pvt.G_APP_NAME, Okl_Pmv_Pvt.G_INVALID_VALUE,Okl_Pmv_Pvt.G_COL_NAME_TOKEN,l_token_1);

368: FETCH okl_ptqv_pk_csr INTO l_ptq_status;
369: l_row_notfound := okl_ptqv_pk_csr%NOTFOUND;
370: CLOSE okl_ptqv_pk_csr;
371: IF (l_row_notfound) THEN
372: Okl_Api.set_message(Okl_Pmv_Pvt.G_APP_NAME, Okl_Pmv_Pvt.G_INVALID_VALUE,Okl_Pmv_Pvt.G_COL_NAME_TOKEN,l_token_1);
373: RAISE G_ITEM_NOT_FOUND_ERROR;
374: END IF;
375: END IF;
376:

Line 388: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pmv_Pvt.g_app_name,

384: x_return_status := Okl_Api.G_RET_STS_ERROR;
385:
386: WHEN OTHERS THEN
387: -- store SQL error message on message stack for caller
388: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pmv_Pvt.g_app_name,
389: p_msg_name => Okl_Pmv_Pvt.g_unexpected_error,
390: p_token1 => Okl_Pmv_Pvt.g_sqlcode_token,
391: p_token1_value => SQLCODE,
392: p_token2 => Okl_Pmv_Pvt.g_sqlerrm_token,

Line 389: p_msg_name => Okl_Pmv_Pvt.g_unexpected_error,

385:
386: WHEN OTHERS THEN
387: -- store SQL error message on message stack for caller
388: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pmv_Pvt.g_app_name,
389: p_msg_name => Okl_Pmv_Pvt.g_unexpected_error,
390: p_token1 => Okl_Pmv_Pvt.g_sqlcode_token,
391: p_token1_value => SQLCODE,
392: p_token2 => Okl_Pmv_Pvt.g_sqlerrm_token,
393: p_token2_value => SQLERRM);

Line 390: p_token1 => Okl_Pmv_Pvt.g_sqlcode_token,

386: WHEN OTHERS THEN
387: -- store SQL error message on message stack for caller
388: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pmv_Pvt.g_app_name,
389: p_msg_name => Okl_Pmv_Pvt.g_unexpected_error,
390: p_token1 => Okl_Pmv_Pvt.g_sqlcode_token,
391: p_token1_value => SQLCODE,
392: p_token2 => Okl_Pmv_Pvt.g_sqlerrm_token,
393: p_token2_value => SQLERRM);
394:

Line 392: p_token2 => Okl_Pmv_Pvt.g_sqlerrm_token,

388: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pmv_Pvt.g_app_name,
389: p_msg_name => Okl_Pmv_Pvt.g_unexpected_error,
390: p_token1 => Okl_Pmv_Pvt.g_sqlcode_token,
391: p_token1_value => SQLCODE,
392: p_token2 => Okl_Pmv_Pvt.g_sqlerrm_token,
393: p_token2_value => SQLERRM);
394:
395: -- notify caller of an UNEXPECTED error
396: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

Line 441: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pmv_Pvt.g_app_name,

437: RETURN (l_return_status);
438:
439: WHEN OTHERS THEN
440: -- store SQL error message on message stack for caller
441: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pmv_Pvt.g_app_name,
442: p_msg_name => Okl_Pmv_Pvt.g_unexpected_error,
443: p_token1 => Okl_Pmv_Pvt.g_sqlcode_token,
444: p_token1_value => SQLCODE,
445: p_token2 => Okl_Pmv_Pvt.g_sqlerrm_token,

Line 442: p_msg_name => Okl_Pmv_Pvt.g_unexpected_error,

438:
439: WHEN OTHERS THEN
440: -- store SQL error message on message stack for caller
441: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pmv_Pvt.g_app_name,
442: p_msg_name => Okl_Pmv_Pvt.g_unexpected_error,
443: p_token1 => Okl_Pmv_Pvt.g_sqlcode_token,
444: p_token1_value => SQLCODE,
445: p_token2 => Okl_Pmv_Pvt.g_sqlerrm_token,
446: p_token2_value => SQLERRM);

Line 443: p_token1 => Okl_Pmv_Pvt.g_sqlcode_token,

439: WHEN OTHERS THEN
440: -- store SQL error message on message stack for caller
441: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pmv_Pvt.g_app_name,
442: p_msg_name => Okl_Pmv_Pvt.g_unexpected_error,
443: p_token1 => Okl_Pmv_Pvt.g_sqlcode_token,
444: p_token1_value => SQLCODE,
445: p_token2 => Okl_Pmv_Pvt.g_sqlerrm_token,
446: p_token2_value => SQLERRM);
447: -- notify caller of an UNEXPECTED error

Line 445: p_token2 => Okl_Pmv_Pvt.g_sqlerrm_token,

441: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pmv_Pvt.g_app_name,
442: p_msg_name => Okl_Pmv_Pvt.g_unexpected_error,
443: p_token1 => Okl_Pmv_Pvt.g_sqlcode_token,
444: p_token1_value => SQLCODE,
445: p_token2 => Okl_Pmv_Pvt.g_sqlerrm_token,
446: p_token2_value => SQLERRM);
447: -- notify caller of an UNEXPECTED error
448: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
449: RETURN(l_return_status);