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_SETUPPRODUCTS_PVT dependencies on OKL_PDT_PVT

Line 913: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name,

909:
910: EXCEPTION
911: WHEN OTHERS THEN
912: -- store SQL error message on message stack for caller
913: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name,
914: p_msg_name => Okl_Pdt_Pvt.g_unexpected_error,
915: p_token1 => Okl_Pdt_Pvt.g_sqlcode_token,
916: p_token1_value => SQLCODE,
917: p_token2 => Okl_Pdt_Pvt.g_sqlerrm_token,

Line 914: p_msg_name => Okl_Pdt_Pvt.g_unexpected_error,

910: EXCEPTION
911: WHEN OTHERS THEN
912: -- store SQL error message on message stack for caller
913: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name,
914: p_msg_name => Okl_Pdt_Pvt.g_unexpected_error,
915: p_token1 => Okl_Pdt_Pvt.g_sqlcode_token,
916: p_token1_value => SQLCODE,
917: p_token2 => Okl_Pdt_Pvt.g_sqlerrm_token,
918: p_token2_value => SQLERRM);

Line 915: p_token1 => Okl_Pdt_Pvt.g_sqlcode_token,

911: WHEN OTHERS THEN
912: -- store SQL error message on message stack for caller
913: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name,
914: p_msg_name => Okl_Pdt_Pvt.g_unexpected_error,
915: p_token1 => Okl_Pdt_Pvt.g_sqlcode_token,
916: p_token1_value => SQLCODE,
917: p_token2 => Okl_Pdt_Pvt.g_sqlerrm_token,
918: p_token2_value => SQLERRM);
919:

Line 917: p_token2 => Okl_Pdt_Pvt.g_sqlerrm_token,

913: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name,
914: p_msg_name => Okl_Pdt_Pvt.g_unexpected_error,
915: p_token1 => Okl_Pdt_Pvt.g_sqlcode_token,
916: p_token1_value => SQLCODE,
917: p_token2 => Okl_Pdt_Pvt.g_sqlerrm_token,
918: p_token2_value => SQLERRM);
919:
920: -- notify caller of an UNEXPECTED error
921: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

Line 1179: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name,

1175: END IF;
1176: WHEN OTHERS THEN
1177: --ROLLBACK TO product_approval_process;
1178: -- store SQL error message on message stack for caller
1179: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name,
1180: p_msg_name => Okl_Pdt_Pvt.g_unexpected_error,
1181: p_token1 => Okl_Pdt_Pvt.g_sqlcode_token,
1182: p_token1_value => SQLCODE,
1183: p_token2 => Okl_Pdt_Pvt.g_sqlerrm_token,

Line 1180: p_msg_name => Okl_Pdt_Pvt.g_unexpected_error,

1176: WHEN OTHERS THEN
1177: --ROLLBACK TO product_approval_process;
1178: -- store SQL error message on message stack for caller
1179: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name,
1180: p_msg_name => Okl_Pdt_Pvt.g_unexpected_error,
1181: p_token1 => Okl_Pdt_Pvt.g_sqlcode_token,
1182: p_token1_value => SQLCODE,
1183: p_token2 => Okl_Pdt_Pvt.g_sqlerrm_token,
1184: p_token2_value => SQLERRM);

Line 1181: p_token1 => Okl_Pdt_Pvt.g_sqlcode_token,

1177: --ROLLBACK TO product_approval_process;
1178: -- store SQL error message on message stack for caller
1179: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name,
1180: p_msg_name => Okl_Pdt_Pvt.g_unexpected_error,
1181: p_token1 => Okl_Pdt_Pvt.g_sqlcode_token,
1182: p_token1_value => SQLCODE,
1183: p_token2 => Okl_Pdt_Pvt.g_sqlerrm_token,
1184: p_token2_value => SQLERRM);
1185:

Line 1183: p_token2 => Okl_Pdt_Pvt.g_sqlerrm_token,

1179: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name,
1180: p_msg_name => Okl_Pdt_Pvt.g_unexpected_error,
1181: p_token1 => Okl_Pdt_Pvt.g_sqlcode_token,
1182: p_token1_value => SQLCODE,
1183: p_token2 => Okl_Pdt_Pvt.g_sqlerrm_token,
1184: p_token2_value => SQLERRM);
1185:
1186: -- notify caller of an UNEXPECTED error
1187: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

Line 1773: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name,

1769:
1770:
1771: WHEN OTHERS THEN
1772: -- store SQL error message on message stack for caller
1773: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name,
1774: p_msg_name => Okl_Pdt_Pvt.g_unexpected_error,
1775:
1776: p_token1 => Okl_Pdt_Pvt.g_sqlcode_token,
1777: p_token1_value => SQLCODE,

Line 1774: p_msg_name => Okl_Pdt_Pvt.g_unexpected_error,

1770:
1771: WHEN OTHERS THEN
1772: -- store SQL error message on message stack for caller
1773: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name,
1774: p_msg_name => Okl_Pdt_Pvt.g_unexpected_error,
1775:
1776: p_token1 => Okl_Pdt_Pvt.g_sqlcode_token,
1777: p_token1_value => SQLCODE,
1778: p_token2 => Okl_Pdt_Pvt.g_sqlerrm_token,

Line 1776: p_token1 => Okl_Pdt_Pvt.g_sqlcode_token,

1772: -- store SQL error message on message stack for caller
1773: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name,
1774: p_msg_name => Okl_Pdt_Pvt.g_unexpected_error,
1775:
1776: p_token1 => Okl_Pdt_Pvt.g_sqlcode_token,
1777: p_token1_value => SQLCODE,
1778: p_token2 => Okl_Pdt_Pvt.g_sqlerrm_token,
1779: p_token2_value => SQLERRM);
1780:

Line 1778: p_token2 => Okl_Pdt_Pvt.g_sqlerrm_token,

1774: p_msg_name => Okl_Pdt_Pvt.g_unexpected_error,
1775:
1776: p_token1 => Okl_Pdt_Pvt.g_sqlcode_token,
1777: p_token1_value => SQLCODE,
1778: p_token2 => Okl_Pdt_Pvt.g_sqlerrm_token,
1779: p_token2_value => SQLERRM);
1780:
1781: -- notify caller of an UNEXPECTED error
1782: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

Line 1828: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name

1824:
1825: OPEN c1(p_pdtv_rec.id);
1826: FETCH c1 INTO l_row_found;
1827: IF (c1%NOTFOUND) THEN
1828: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name
1829: ,p_msg_name => Okl_Pdt_Pvt.g_required_value
1830: ,p_token1 => Okl_Pdt_Pvt.g_col_name_token
1831: ,p_token1_value => l_token_1);
1832:

Line 1829: ,p_msg_name => Okl_Pdt_Pvt.g_required_value

1825: OPEN c1(p_pdtv_rec.id);
1826: FETCH c1 INTO l_row_found;
1827: IF (c1%NOTFOUND) THEN
1828: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name
1829: ,p_msg_name => Okl_Pdt_Pvt.g_required_value
1830: ,p_token1 => Okl_Pdt_Pvt.g_col_name_token
1831: ,p_token1_value => l_token_1);
1832:
1833: x_return_status := Okl_Api.G_RET_STS_ERROR;

Line 1830: ,p_token1 => Okl_Pdt_Pvt.g_col_name_token

1826: FETCH c1 INTO l_row_found;
1827: IF (c1%NOTFOUND) THEN
1828: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name
1829: ,p_msg_name => Okl_Pdt_Pvt.g_required_value
1830: ,p_token1 => Okl_Pdt_Pvt.g_col_name_token
1831: ,p_token1_value => l_token_1);
1832:
1833: x_return_status := Okl_Api.G_RET_STS_ERROR;
1834: RAISE G_EXCEPTION_HALT_PROCESSING;

Line 1848: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name,

1844: NULL;
1845:
1846: WHEN OTHERS THEN
1847: -- store SQL error message on message stack for caller
1848: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name,
1849: p_msg_name => Okl_Pdt_Pvt.g_unexpected_error,
1850:
1851: p_token1 => Okl_Pdt_Pvt.g_sqlcode_token,
1852: p_token1_value => SQLCODE,

Line 1849: p_msg_name => Okl_Pdt_Pvt.g_unexpected_error,

1845:
1846: WHEN OTHERS THEN
1847: -- store SQL error message on message stack for caller
1848: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name,
1849: p_msg_name => Okl_Pdt_Pvt.g_unexpected_error,
1850:
1851: p_token1 => Okl_Pdt_Pvt.g_sqlcode_token,
1852: p_token1_value => SQLCODE,
1853: p_token2 => Okl_Pdt_Pvt.g_sqlerrm_token,

Line 1851: p_token1 => Okl_Pdt_Pvt.g_sqlcode_token,

1847: -- store SQL error message on message stack for caller
1848: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name,
1849: p_msg_name => Okl_Pdt_Pvt.g_unexpected_error,
1850:
1851: p_token1 => Okl_Pdt_Pvt.g_sqlcode_token,
1852: p_token1_value => SQLCODE,
1853: p_token2 => Okl_Pdt_Pvt.g_sqlerrm_token,
1854: p_token2_value => SQLERRM);
1855:

Line 1853: p_token2 => Okl_Pdt_Pvt.g_sqlerrm_token,

1849: p_msg_name => Okl_Pdt_Pvt.g_unexpected_error,
1850:
1851: p_token1 => Okl_Pdt_Pvt.g_sqlcode_token,
1852: p_token1_value => SQLCODE,
1853: p_token2 => Okl_Pdt_Pvt.g_sqlerrm_token,
1854: p_token2_value => SQLERRM);
1855:
1856: -- notify caller of an UNEXPECTED error
1857: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

Line 2472: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name

2468: BEGIN
2469: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Api.SET_MESSAGE ');
2470: END;
2471: END IF;
2472: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name
2473: ,p_msg_name => Okl_Pdt_Pvt.g_required_value
2474: ,p_token1 => Okl_Pdt_Pvt.g_col_name_token
2475: ,p_token1_value => l_token_1);
2476: IF(IS_DEBUG_PROCEDURE_ON) THEN

Line 2473: ,p_msg_name => Okl_Pdt_Pvt.g_required_value

2469: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Api.SET_MESSAGE ');
2470: END;
2471: END IF;
2472: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name
2473: ,p_msg_name => Okl_Pdt_Pvt.g_required_value
2474: ,p_token1 => Okl_Pdt_Pvt.g_col_name_token
2475: ,p_token1_value => l_token_1);
2476: IF(IS_DEBUG_PROCEDURE_ON) THEN
2477: BEGIN

Line 2474: ,p_token1 => Okl_Pdt_Pvt.g_col_name_token

2470: END;
2471: END IF;
2472: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name
2473: ,p_msg_name => Okl_Pdt_Pvt.g_required_value
2474: ,p_token1 => Okl_Pdt_Pvt.g_col_name_token
2475: ,p_token1_value => l_token_1);
2476: IF(IS_DEBUG_PROCEDURE_ON) THEN
2477: BEGIN
2478: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSPDB.pls call Okl_Api.SET_MESSAGE ');

Line 2498: Okl_Api.set_message(Okl_Pdt_Pvt.G_APP_NAME, Okl_Pdt_Pvt.G_INVALID_VALUE,Okl_Pdt_Pvt.G_COL_NAME_TOKEN,l_token_1);

2494: BEGIN
2495: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Api.set_message ');
2496: END;
2497: END IF;
2498: Okl_Api.set_message(Okl_Pdt_Pvt.G_APP_NAME, Okl_Pdt_Pvt.G_INVALID_VALUE,Okl_Pdt_Pvt.G_COL_NAME_TOKEN,l_token_1);
2499: IF(IS_DEBUG_PROCEDURE_ON) THEN
2500:
2501: BEGIN
2502: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSPDB.pls call Okl_Api.set_message ');

Line 2517: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name,

2513: -- with the next column
2514: NULL;
2515: WHEN OTHERS THEN
2516: -- store SQL error message on message stack for caller
2517: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name,
2518: p_msg_name => Okl_Pdt_Pvt.g_unexpected_error,
2519: p_token1 => Okl_Pdt_Pvt.g_sqlcode_token,
2520: p_token1_value => SQLCODE,
2521: p_token2 => Okl_Pdt_Pvt.g_sqlerrm_token,

Line 2518: p_msg_name => Okl_Pdt_Pvt.g_unexpected_error,

2514: NULL;
2515: WHEN OTHERS THEN
2516: -- store SQL error message on message stack for caller
2517: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name,
2518: p_msg_name => Okl_Pdt_Pvt.g_unexpected_error,
2519: p_token1 => Okl_Pdt_Pvt.g_sqlcode_token,
2520: p_token1_value => SQLCODE,
2521: p_token2 => Okl_Pdt_Pvt.g_sqlerrm_token,
2522: p_token2_value => SQLERRM);

Line 2519: p_token1 => Okl_Pdt_Pvt.g_sqlcode_token,

2515: WHEN OTHERS THEN
2516: -- store SQL error message on message stack for caller
2517: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name,
2518: p_msg_name => Okl_Pdt_Pvt.g_unexpected_error,
2519: p_token1 => Okl_Pdt_Pvt.g_sqlcode_token,
2520: p_token1_value => SQLCODE,
2521: p_token2 => Okl_Pdt_Pvt.g_sqlerrm_token,
2522: p_token2_value => SQLERRM);
2523:

Line 2521: p_token2 => Okl_Pdt_Pvt.g_sqlerrm_token,

2517: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name,
2518: p_msg_name => Okl_Pdt_Pvt.g_unexpected_error,
2519: p_token1 => Okl_Pdt_Pvt.g_sqlcode_token,
2520: p_token1_value => SQLCODE,
2521: p_token2 => Okl_Pdt_Pvt.g_sqlerrm_token,
2522: p_token2_value => SQLERRM);
2523:
2524:
2525: -- notify caller of an UNEXPECTED error

Line 2576: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name

2572: BEGIN
2573: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Api.SET_MESSAGE ');
2574: END;
2575: END IF;
2576: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name
2577: ,p_msg_name => Okl_Pdt_Pvt.g_required_value
2578: ,p_token1 => Okl_Pdt_Pvt.g_col_name_token
2579: ,p_token1_value => l_token_1);
2580: IF(IS_DEBUG_PROCEDURE_ON) THEN

Line 2577: ,p_msg_name => Okl_Pdt_Pvt.g_required_value

2573: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Api.SET_MESSAGE ');
2574: END;
2575: END IF;
2576: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name
2577: ,p_msg_name => Okl_Pdt_Pvt.g_required_value
2578: ,p_token1 => Okl_Pdt_Pvt.g_col_name_token
2579: ,p_token1_value => l_token_1);
2580: IF(IS_DEBUG_PROCEDURE_ON) THEN
2581: BEGIN

Line 2578: ,p_token1 => Okl_Pdt_Pvt.g_col_name_token

2574: END;
2575: END IF;
2576: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name
2577: ,p_msg_name => Okl_Pdt_Pvt.g_required_value
2578: ,p_token1 => Okl_Pdt_Pvt.g_col_name_token
2579: ,p_token1_value => l_token_1);
2580: IF(IS_DEBUG_PROCEDURE_ON) THEN
2581: BEGIN
2582: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSPDB.pls call Okl_Api.SET_MESSAGE ');

Line 2603: Okl_Api.set_message(Okl_Pdt_Pvt.G_APP_NAME, Okl_Pdt_Pvt.G_INVALID_VALUE,Okl_Pdt_Pvt.G_COL_NAME_TOKEN,l_token_1);

2599: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Api.set_message ');
2600:
2601: END;
2602: END IF;
2603: Okl_Api.set_message(Okl_Pdt_Pvt.G_APP_NAME, Okl_Pdt_Pvt.G_INVALID_VALUE,Okl_Pdt_Pvt.G_COL_NAME_TOKEN,l_token_1);
2604: IF(IS_DEBUG_PROCEDURE_ON) THEN
2605: BEGIN
2606: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSPDB.pls call Okl_Api.set_message ');
2607: END;

Line 2621: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name,

2617: -- with the next column
2618: NULL;
2619: WHEN OTHERS THEN
2620: -- store SQL error message on message stack for caller
2621: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name,
2622: p_msg_name => Okl_Pdt_Pvt.g_unexpected_error,
2623: p_token1 => Okl_Pdt_Pvt.g_sqlcode_token,
2624: p_token1_value => SQLCODE,
2625:

Line 2622: p_msg_name => Okl_Pdt_Pvt.g_unexpected_error,

2618: NULL;
2619: WHEN OTHERS THEN
2620: -- store SQL error message on message stack for caller
2621: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name,
2622: p_msg_name => Okl_Pdt_Pvt.g_unexpected_error,
2623: p_token1 => Okl_Pdt_Pvt.g_sqlcode_token,
2624: p_token1_value => SQLCODE,
2625:
2626: p_token2 => Okl_Pdt_Pvt.g_sqlerrm_token,

Line 2623: p_token1 => Okl_Pdt_Pvt.g_sqlcode_token,

2619: WHEN OTHERS THEN
2620: -- store SQL error message on message stack for caller
2621: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name,
2622: p_msg_name => Okl_Pdt_Pvt.g_unexpected_error,
2623: p_token1 => Okl_Pdt_Pvt.g_sqlcode_token,
2624: p_token1_value => SQLCODE,
2625:
2626: p_token2 => Okl_Pdt_Pvt.g_sqlerrm_token,
2627: p_token2_value => SQLERRM);

Line 2626: p_token2 => Okl_Pdt_Pvt.g_sqlerrm_token,

2622: p_msg_name => Okl_Pdt_Pvt.g_unexpected_error,
2623: p_token1 => Okl_Pdt_Pvt.g_sqlcode_token,
2624: p_token1_value => SQLCODE,
2625:
2626: p_token2 => Okl_Pdt_Pvt.g_sqlerrm_token,
2627: p_token2_value => SQLERRM);
2628:
2629: -- notify caller of an UNEXPECTED error
2630: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

Line 2674: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name

2670: BEGIN
2671: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Api.SET_MESSAGE ');
2672: END;
2673: END IF;
2674: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name
2675: ,p_msg_name => Okl_Pdt_Pvt.g_required_value
2676: ,p_token1 => Okl_Pdt_Pvt.g_col_name_token
2677: ,p_token1_value => l_token_1);
2678: IF(IS_DEBUG_PROCEDURE_ON) THEN

Line 2675: ,p_msg_name => Okl_Pdt_Pvt.g_required_value

2671: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Api.SET_MESSAGE ');
2672: END;
2673: END IF;
2674: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name
2675: ,p_msg_name => Okl_Pdt_Pvt.g_required_value
2676: ,p_token1 => Okl_Pdt_Pvt.g_col_name_token
2677: ,p_token1_value => l_token_1);
2678: IF(IS_DEBUG_PROCEDURE_ON) THEN
2679: BEGIN

Line 2676: ,p_token1 => Okl_Pdt_Pvt.g_col_name_token

2672: END;
2673: END IF;
2674: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name
2675: ,p_msg_name => Okl_Pdt_Pvt.g_required_value
2676: ,p_token1 => Okl_Pdt_Pvt.g_col_name_token
2677: ,p_token1_value => l_token_1);
2678: IF(IS_DEBUG_PROCEDURE_ON) THEN
2679: BEGIN
2680: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSPDB.pls call Okl_Api.SET_MESSAGE ');

Line 2696: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name,

2692: NULL;
2693:
2694: WHEN OTHERS THEN
2695: -- store SQL error message on message stack for caller
2696: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name,
2697: p_msg_name => Okl_Pdt_Pvt.g_unexpected_error,
2698: p_token1 => Okl_Pdt_Pvt.g_sqlcode_token,
2699: p_token1_value => SQLCODE,
2700:

Line 2697: p_msg_name => Okl_Pdt_Pvt.g_unexpected_error,

2693:
2694: WHEN OTHERS THEN
2695: -- store SQL error message on message stack for caller
2696: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name,
2697: p_msg_name => Okl_Pdt_Pvt.g_unexpected_error,
2698: p_token1 => Okl_Pdt_Pvt.g_sqlcode_token,
2699: p_token1_value => SQLCODE,
2700:
2701: p_token2 => Okl_Pdt_Pvt.g_sqlerrm_token,

Line 2698: p_token1 => Okl_Pdt_Pvt.g_sqlcode_token,

2694: WHEN OTHERS THEN
2695: -- store SQL error message on message stack for caller
2696: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name,
2697: p_msg_name => Okl_Pdt_Pvt.g_unexpected_error,
2698: p_token1 => Okl_Pdt_Pvt.g_sqlcode_token,
2699: p_token1_value => SQLCODE,
2700:
2701: p_token2 => Okl_Pdt_Pvt.g_sqlerrm_token,
2702: p_token2_value => SQLERRM);

Line 2701: p_token2 => Okl_Pdt_Pvt.g_sqlerrm_token,

2697: p_msg_name => Okl_Pdt_Pvt.g_unexpected_error,
2698: p_token1 => Okl_Pdt_Pvt.g_sqlcode_token,
2699: p_token1_value => SQLCODE,
2700:
2701: p_token2 => Okl_Pdt_Pvt.g_sqlerrm_token,
2702: p_token2_value => SQLERRM);
2703:
2704: -- notify caller of an UNEXPECTED error
2705: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

Line 2747: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name

2743: BEGIN
2744: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Api.SET_MESSAGE ');
2745: END;
2746: END IF;
2747: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name
2748: ,p_msg_name => Okl_Pdt_Pvt.g_required_value
2749: ,p_token1 => Okl_Pdt_Pvt.g_col_name_token
2750: ,p_token1_value => l_token_1);
2751: IF(IS_DEBUG_PROCEDURE_ON) THEN

Line 2748: ,p_msg_name => Okl_Pdt_Pvt.g_required_value

2744: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Api.SET_MESSAGE ');
2745: END;
2746: END IF;
2747: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name
2748: ,p_msg_name => Okl_Pdt_Pvt.g_required_value
2749: ,p_token1 => Okl_Pdt_Pvt.g_col_name_token
2750: ,p_token1_value => l_token_1);
2751: IF(IS_DEBUG_PROCEDURE_ON) THEN
2752: BEGIN

Line 2749: ,p_token1 => Okl_Pdt_Pvt.g_col_name_token

2745: END;
2746: END IF;
2747: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name
2748: ,p_msg_name => Okl_Pdt_Pvt.g_required_value
2749: ,p_token1 => Okl_Pdt_Pvt.g_col_name_token
2750: ,p_token1_value => l_token_1);
2751: IF(IS_DEBUG_PROCEDURE_ON) THEN
2752: BEGIN
2753: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSPDB.pls call Okl_Api.SET_MESSAGE ');

Line 2770: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name,

2766: NULL;
2767:
2768: WHEN OTHERS THEN
2769: -- store SQL error message on message stack for caller
2770: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name,
2771: p_msg_name => Okl_Pdt_Pvt.g_unexpected_error,
2772:
2773: p_token1 => Okl_Pdt_Pvt.g_sqlcode_token,
2774: p_token1_value => SQLCODE,

Line 2771: p_msg_name => Okl_Pdt_Pvt.g_unexpected_error,

2767:
2768: WHEN OTHERS THEN
2769: -- store SQL error message on message stack for caller
2770: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name,
2771: p_msg_name => Okl_Pdt_Pvt.g_unexpected_error,
2772:
2773: p_token1 => Okl_Pdt_Pvt.g_sqlcode_token,
2774: p_token1_value => SQLCODE,
2775: p_token2 => Okl_Pdt_Pvt.g_sqlerrm_token,

Line 2773: p_token1 => Okl_Pdt_Pvt.g_sqlcode_token,

2769: -- store SQL error message on message stack for caller
2770: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name,
2771: p_msg_name => Okl_Pdt_Pvt.g_unexpected_error,
2772:
2773: p_token1 => Okl_Pdt_Pvt.g_sqlcode_token,
2774: p_token1_value => SQLCODE,
2775: p_token2 => Okl_Pdt_Pvt.g_sqlerrm_token,
2776: p_token2_value => SQLERRM);
2777:

Line 2775: p_token2 => Okl_Pdt_Pvt.g_sqlerrm_token,

2771: p_msg_name => Okl_Pdt_Pvt.g_unexpected_error,
2772:
2773: p_token1 => Okl_Pdt_Pvt.g_sqlcode_token,
2774: p_token1_value => SQLCODE,
2775: p_token2 => Okl_Pdt_Pvt.g_sqlerrm_token,
2776: p_token2_value => SQLERRM);
2777:
2778: -- notify caller of an UNEXPECTED error
2779: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

Line 2871: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name,

2867: RETURN (l_return_status);
2868:
2869: WHEN OTHERS THEN
2870: -- store SQL error message on message stack for caller
2871: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name,
2872: p_msg_name => Okl_Pdt_Pvt.g_unexpected_error,
2873: p_token1 => Okl_Pdt_Pvt.g_sqlcode_token,
2874: p_token1_value => SQLCODE,
2875:

Line 2872: p_msg_name => Okl_Pdt_Pvt.g_unexpected_error,

2868:
2869: WHEN OTHERS THEN
2870: -- store SQL error message on message stack for caller
2871: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name,
2872: p_msg_name => Okl_Pdt_Pvt.g_unexpected_error,
2873: p_token1 => Okl_Pdt_Pvt.g_sqlcode_token,
2874: p_token1_value => SQLCODE,
2875:
2876: p_token2 => Okl_Pdt_Pvt.g_sqlerrm_token,

Line 2873: p_token1 => Okl_Pdt_Pvt.g_sqlcode_token,

2869: WHEN OTHERS THEN
2870: -- store SQL error message on message stack for caller
2871: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name,
2872: p_msg_name => Okl_Pdt_Pvt.g_unexpected_error,
2873: p_token1 => Okl_Pdt_Pvt.g_sqlcode_token,
2874: p_token1_value => SQLCODE,
2875:
2876: p_token2 => Okl_Pdt_Pvt.g_sqlerrm_token,
2877: p_token2_value => SQLERRM);

Line 2876: p_token2 => Okl_Pdt_Pvt.g_sqlerrm_token,

2872: p_msg_name => Okl_Pdt_Pvt.g_unexpected_error,
2873: p_token1 => Okl_Pdt_Pvt.g_sqlcode_token,
2874: p_token1_value => SQLCODE,
2875:
2876: p_token2 => Okl_Pdt_Pvt.g_sqlerrm_token,
2877: p_token2_value => SQLERRM);
2878: -- notify caller of an UNEXPECTED error
2879: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
2880: RETURN(l_return_status);