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 896: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name,

892:
893: EXCEPTION
894: WHEN OTHERS THEN
895: -- store SQL error message on message stack for caller
896: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name,
897: p_msg_name => Okl_Pdt_Pvt.g_unexpected_error,
898: p_token1 => Okl_Pdt_Pvt.g_sqlcode_token,
899: p_token1_value => SQLCODE,
900: p_token2 => Okl_Pdt_Pvt.g_sqlerrm_token,

Line 897: p_msg_name => Okl_Pdt_Pvt.g_unexpected_error,

893: EXCEPTION
894: WHEN OTHERS THEN
895: -- store SQL error message on message stack for caller
896: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name,
897: p_msg_name => Okl_Pdt_Pvt.g_unexpected_error,
898: p_token1 => Okl_Pdt_Pvt.g_sqlcode_token,
899: p_token1_value => SQLCODE,
900: p_token2 => Okl_Pdt_Pvt.g_sqlerrm_token,
901: p_token2_value => SQLERRM);

Line 898: p_token1 => Okl_Pdt_Pvt.g_sqlcode_token,

894: WHEN OTHERS THEN
895: -- store SQL error message on message stack for caller
896: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name,
897: p_msg_name => Okl_Pdt_Pvt.g_unexpected_error,
898: p_token1 => Okl_Pdt_Pvt.g_sqlcode_token,
899: p_token1_value => SQLCODE,
900: p_token2 => Okl_Pdt_Pvt.g_sqlerrm_token,
901: p_token2_value => SQLERRM);
902:

Line 900: p_token2 => Okl_Pdt_Pvt.g_sqlerrm_token,

896: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name,
897: p_msg_name => Okl_Pdt_Pvt.g_unexpected_error,
898: p_token1 => Okl_Pdt_Pvt.g_sqlcode_token,
899: p_token1_value => SQLCODE,
900: p_token2 => Okl_Pdt_Pvt.g_sqlerrm_token,
901: p_token2_value => SQLERRM);
902:
903: -- notify caller of an UNEXPECTED error
904: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

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

1158: END IF;
1159: WHEN OTHERS THEN
1160: --ROLLBACK TO product_approval_process;
1161: -- store SQL error message on message stack for caller
1162: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name,
1163: p_msg_name => Okl_Pdt_Pvt.g_unexpected_error,
1164: p_token1 => Okl_Pdt_Pvt.g_sqlcode_token,
1165: p_token1_value => SQLCODE,
1166: p_token2 => Okl_Pdt_Pvt.g_sqlerrm_token,

Line 1163: p_msg_name => Okl_Pdt_Pvt.g_unexpected_error,

1159: WHEN OTHERS THEN
1160: --ROLLBACK TO product_approval_process;
1161: -- store SQL error message on message stack for caller
1162: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name,
1163: p_msg_name => Okl_Pdt_Pvt.g_unexpected_error,
1164: p_token1 => Okl_Pdt_Pvt.g_sqlcode_token,
1165: p_token1_value => SQLCODE,
1166: p_token2 => Okl_Pdt_Pvt.g_sqlerrm_token,
1167: p_token2_value => SQLERRM);

Line 1164: p_token1 => Okl_Pdt_Pvt.g_sqlcode_token,

1160: --ROLLBACK TO product_approval_process;
1161: -- store SQL error message on message stack for caller
1162: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name,
1163: p_msg_name => Okl_Pdt_Pvt.g_unexpected_error,
1164: p_token1 => Okl_Pdt_Pvt.g_sqlcode_token,
1165: p_token1_value => SQLCODE,
1166: p_token2 => Okl_Pdt_Pvt.g_sqlerrm_token,
1167: p_token2_value => SQLERRM);
1168:

Line 1166: p_token2 => Okl_Pdt_Pvt.g_sqlerrm_token,

1162: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name,
1163: p_msg_name => Okl_Pdt_Pvt.g_unexpected_error,
1164: p_token1 => Okl_Pdt_Pvt.g_sqlcode_token,
1165: p_token1_value => SQLCODE,
1166: p_token2 => Okl_Pdt_Pvt.g_sqlerrm_token,
1167: p_token2_value => SQLERRM);
1168:
1169: -- notify caller of an UNEXPECTED error
1170: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

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

1752:
1753:
1754: WHEN OTHERS THEN
1755: -- store SQL error message on message stack for caller
1756: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name,
1757: p_msg_name => Okl_Pdt_Pvt.g_unexpected_error,
1758:
1759: p_token1 => Okl_Pdt_Pvt.g_sqlcode_token,
1760: p_token1_value => SQLCODE,

Line 1757: p_msg_name => Okl_Pdt_Pvt.g_unexpected_error,

1753:
1754: WHEN OTHERS THEN
1755: -- store SQL error message on message stack for caller
1756: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name,
1757: p_msg_name => Okl_Pdt_Pvt.g_unexpected_error,
1758:
1759: p_token1 => Okl_Pdt_Pvt.g_sqlcode_token,
1760: p_token1_value => SQLCODE,
1761: p_token2 => Okl_Pdt_Pvt.g_sqlerrm_token,

Line 1759: p_token1 => Okl_Pdt_Pvt.g_sqlcode_token,

1755: -- store SQL error message on message stack for caller
1756: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name,
1757: p_msg_name => Okl_Pdt_Pvt.g_unexpected_error,
1758:
1759: p_token1 => Okl_Pdt_Pvt.g_sqlcode_token,
1760: p_token1_value => SQLCODE,
1761: p_token2 => Okl_Pdt_Pvt.g_sqlerrm_token,
1762: p_token2_value => SQLERRM);
1763:

Line 1761: p_token2 => Okl_Pdt_Pvt.g_sqlerrm_token,

1757: p_msg_name => Okl_Pdt_Pvt.g_unexpected_error,
1758:
1759: p_token1 => Okl_Pdt_Pvt.g_sqlcode_token,
1760: p_token1_value => SQLCODE,
1761: p_token2 => Okl_Pdt_Pvt.g_sqlerrm_token,
1762: p_token2_value => SQLERRM);
1763:
1764: -- notify caller of an UNEXPECTED error
1765: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

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

1807:
1808: OPEN c1(p_pdtv_rec.id);
1809: FETCH c1 INTO l_row_found;
1810: IF (c1%NOTFOUND) THEN
1811: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name
1812: ,p_msg_name => Okl_Pdt_Pvt.g_required_value
1813: ,p_token1 => Okl_Pdt_Pvt.g_col_name_token
1814: ,p_token1_value => l_token_1);
1815:

Line 1812: ,p_msg_name => Okl_Pdt_Pvt.g_required_value

1808: OPEN c1(p_pdtv_rec.id);
1809: FETCH c1 INTO l_row_found;
1810: IF (c1%NOTFOUND) THEN
1811: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name
1812: ,p_msg_name => Okl_Pdt_Pvt.g_required_value
1813: ,p_token1 => Okl_Pdt_Pvt.g_col_name_token
1814: ,p_token1_value => l_token_1);
1815:
1816: x_return_status := Okl_Api.G_RET_STS_ERROR;

Line 1813: ,p_token1 => Okl_Pdt_Pvt.g_col_name_token

1809: FETCH c1 INTO l_row_found;
1810: IF (c1%NOTFOUND) THEN
1811: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name
1812: ,p_msg_name => Okl_Pdt_Pvt.g_required_value
1813: ,p_token1 => Okl_Pdt_Pvt.g_col_name_token
1814: ,p_token1_value => l_token_1);
1815:
1816: x_return_status := Okl_Api.G_RET_STS_ERROR;
1817: RAISE G_EXCEPTION_HALT_PROCESSING;

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

1827: NULL;
1828:
1829: WHEN OTHERS THEN
1830: -- store SQL error message on message stack for caller
1831: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name,
1832: p_msg_name => Okl_Pdt_Pvt.g_unexpected_error,
1833:
1834: p_token1 => Okl_Pdt_Pvt.g_sqlcode_token,
1835: p_token1_value => SQLCODE,

Line 1832: p_msg_name => Okl_Pdt_Pvt.g_unexpected_error,

1828:
1829: WHEN OTHERS THEN
1830: -- store SQL error message on message stack for caller
1831: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name,
1832: p_msg_name => Okl_Pdt_Pvt.g_unexpected_error,
1833:
1834: p_token1 => Okl_Pdt_Pvt.g_sqlcode_token,
1835: p_token1_value => SQLCODE,
1836: p_token2 => Okl_Pdt_Pvt.g_sqlerrm_token,

Line 1834: p_token1 => Okl_Pdt_Pvt.g_sqlcode_token,

1830: -- store SQL error message on message stack for caller
1831: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name,
1832: p_msg_name => Okl_Pdt_Pvt.g_unexpected_error,
1833:
1834: p_token1 => Okl_Pdt_Pvt.g_sqlcode_token,
1835: p_token1_value => SQLCODE,
1836: p_token2 => Okl_Pdt_Pvt.g_sqlerrm_token,
1837: p_token2_value => SQLERRM);
1838:

Line 1836: p_token2 => Okl_Pdt_Pvt.g_sqlerrm_token,

1832: p_msg_name => Okl_Pdt_Pvt.g_unexpected_error,
1833:
1834: p_token1 => Okl_Pdt_Pvt.g_sqlcode_token,
1835: p_token1_value => SQLCODE,
1836: p_token2 => Okl_Pdt_Pvt.g_sqlerrm_token,
1837: p_token2_value => SQLERRM);
1838:
1839: -- notify caller of an UNEXPECTED error
1840: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

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

2439: BEGIN
2440: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Api.SET_MESSAGE ');
2441: END;
2442: END IF;
2443: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name
2444: ,p_msg_name => Okl_Pdt_Pvt.g_required_value
2445: ,p_token1 => Okl_Pdt_Pvt.g_col_name_token
2446: ,p_token1_value => l_token_1);
2447: IF(IS_DEBUG_PROCEDURE_ON) THEN

Line 2444: ,p_msg_name => Okl_Pdt_Pvt.g_required_value

2440: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Api.SET_MESSAGE ');
2441: END;
2442: END IF;
2443: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name
2444: ,p_msg_name => Okl_Pdt_Pvt.g_required_value
2445: ,p_token1 => Okl_Pdt_Pvt.g_col_name_token
2446: ,p_token1_value => l_token_1);
2447: IF(IS_DEBUG_PROCEDURE_ON) THEN
2448: BEGIN

Line 2445: ,p_token1 => Okl_Pdt_Pvt.g_col_name_token

2441: END;
2442: END IF;
2443: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name
2444: ,p_msg_name => Okl_Pdt_Pvt.g_required_value
2445: ,p_token1 => Okl_Pdt_Pvt.g_col_name_token
2446: ,p_token1_value => l_token_1);
2447: IF(IS_DEBUG_PROCEDURE_ON) THEN
2448: BEGIN
2449: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSPDB.pls call Okl_Api.SET_MESSAGE ');

Line 2469: 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);

2465: BEGIN
2466: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Api.set_message ');
2467: END;
2468: END IF;
2469: 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);
2470: IF(IS_DEBUG_PROCEDURE_ON) THEN
2471:
2472: BEGIN
2473: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSPDB.pls call Okl_Api.set_message ');

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

2484: -- with the next column
2485: NULL;
2486: WHEN OTHERS THEN
2487: -- store SQL error message on message stack for caller
2488: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name,
2489: p_msg_name => Okl_Pdt_Pvt.g_unexpected_error,
2490: p_token1 => Okl_Pdt_Pvt.g_sqlcode_token,
2491: p_token1_value => SQLCODE,
2492: p_token2 => Okl_Pdt_Pvt.g_sqlerrm_token,

Line 2489: p_msg_name => Okl_Pdt_Pvt.g_unexpected_error,

2485: NULL;
2486: WHEN OTHERS THEN
2487: -- store SQL error message on message stack for caller
2488: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name,
2489: p_msg_name => Okl_Pdt_Pvt.g_unexpected_error,
2490: p_token1 => Okl_Pdt_Pvt.g_sqlcode_token,
2491: p_token1_value => SQLCODE,
2492: p_token2 => Okl_Pdt_Pvt.g_sqlerrm_token,
2493: p_token2_value => SQLERRM);

Line 2490: p_token1 => Okl_Pdt_Pvt.g_sqlcode_token,

2486: WHEN OTHERS THEN
2487: -- store SQL error message on message stack for caller
2488: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name,
2489: p_msg_name => Okl_Pdt_Pvt.g_unexpected_error,
2490: p_token1 => Okl_Pdt_Pvt.g_sqlcode_token,
2491: p_token1_value => SQLCODE,
2492: p_token2 => Okl_Pdt_Pvt.g_sqlerrm_token,
2493: p_token2_value => SQLERRM);
2494:

Line 2492: p_token2 => Okl_Pdt_Pvt.g_sqlerrm_token,

2488: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name,
2489: p_msg_name => Okl_Pdt_Pvt.g_unexpected_error,
2490: p_token1 => Okl_Pdt_Pvt.g_sqlcode_token,
2491: p_token1_value => SQLCODE,
2492: p_token2 => Okl_Pdt_Pvt.g_sqlerrm_token,
2493: p_token2_value => SQLERRM);
2494:
2495:
2496: -- notify caller of an UNEXPECTED error

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

2543: BEGIN
2544: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Api.SET_MESSAGE ');
2545: END;
2546: END IF;
2547: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name
2548: ,p_msg_name => Okl_Pdt_Pvt.g_required_value
2549: ,p_token1 => Okl_Pdt_Pvt.g_col_name_token
2550: ,p_token1_value => l_token_1);
2551: IF(IS_DEBUG_PROCEDURE_ON) THEN

Line 2548: ,p_msg_name => Okl_Pdt_Pvt.g_required_value

2544: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Api.SET_MESSAGE ');
2545: END;
2546: END IF;
2547: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name
2548: ,p_msg_name => Okl_Pdt_Pvt.g_required_value
2549: ,p_token1 => Okl_Pdt_Pvt.g_col_name_token
2550: ,p_token1_value => l_token_1);
2551: IF(IS_DEBUG_PROCEDURE_ON) THEN
2552: BEGIN

Line 2549: ,p_token1 => Okl_Pdt_Pvt.g_col_name_token

2545: END;
2546: END IF;
2547: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name
2548: ,p_msg_name => Okl_Pdt_Pvt.g_required_value
2549: ,p_token1 => Okl_Pdt_Pvt.g_col_name_token
2550: ,p_token1_value => l_token_1);
2551: IF(IS_DEBUG_PROCEDURE_ON) THEN
2552: BEGIN
2553: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSPDB.pls call Okl_Api.SET_MESSAGE ');

Line 2574: 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);

2570: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Api.set_message ');
2571:
2572: END;
2573: END IF;
2574: 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);
2575: IF(IS_DEBUG_PROCEDURE_ON) THEN
2576: BEGIN
2577: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSPDB.pls call Okl_Api.set_message ');
2578: END;

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

2588: -- with the next column
2589: NULL;
2590: WHEN OTHERS THEN
2591: -- store SQL error message on message stack for caller
2592: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name,
2593: p_msg_name => Okl_Pdt_Pvt.g_unexpected_error,
2594: p_token1 => Okl_Pdt_Pvt.g_sqlcode_token,
2595: p_token1_value => SQLCODE,
2596:

Line 2593: p_msg_name => Okl_Pdt_Pvt.g_unexpected_error,

2589: NULL;
2590: WHEN OTHERS THEN
2591: -- store SQL error message on message stack for caller
2592: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name,
2593: p_msg_name => Okl_Pdt_Pvt.g_unexpected_error,
2594: p_token1 => Okl_Pdt_Pvt.g_sqlcode_token,
2595: p_token1_value => SQLCODE,
2596:
2597: p_token2 => Okl_Pdt_Pvt.g_sqlerrm_token,

Line 2594: p_token1 => Okl_Pdt_Pvt.g_sqlcode_token,

2590: WHEN OTHERS THEN
2591: -- store SQL error message on message stack for caller
2592: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name,
2593: p_msg_name => Okl_Pdt_Pvt.g_unexpected_error,
2594: p_token1 => Okl_Pdt_Pvt.g_sqlcode_token,
2595: p_token1_value => SQLCODE,
2596:
2597: p_token2 => Okl_Pdt_Pvt.g_sqlerrm_token,
2598: p_token2_value => SQLERRM);

Line 2597: p_token2 => Okl_Pdt_Pvt.g_sqlerrm_token,

2593: p_msg_name => Okl_Pdt_Pvt.g_unexpected_error,
2594: p_token1 => Okl_Pdt_Pvt.g_sqlcode_token,
2595: p_token1_value => SQLCODE,
2596:
2597: p_token2 => Okl_Pdt_Pvt.g_sqlerrm_token,
2598: p_token2_value => SQLERRM);
2599:
2600: -- notify caller of an UNEXPECTED error
2601: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

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

2641: BEGIN
2642: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Api.SET_MESSAGE ');
2643: END;
2644: END IF;
2645: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name
2646: ,p_msg_name => Okl_Pdt_Pvt.g_required_value
2647: ,p_token1 => Okl_Pdt_Pvt.g_col_name_token
2648: ,p_token1_value => l_token_1);
2649: IF(IS_DEBUG_PROCEDURE_ON) THEN

Line 2646: ,p_msg_name => Okl_Pdt_Pvt.g_required_value

2642: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Api.SET_MESSAGE ');
2643: END;
2644: END IF;
2645: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name
2646: ,p_msg_name => Okl_Pdt_Pvt.g_required_value
2647: ,p_token1 => Okl_Pdt_Pvt.g_col_name_token
2648: ,p_token1_value => l_token_1);
2649: IF(IS_DEBUG_PROCEDURE_ON) THEN
2650: BEGIN

Line 2647: ,p_token1 => Okl_Pdt_Pvt.g_col_name_token

2643: END;
2644: END IF;
2645: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name
2646: ,p_msg_name => Okl_Pdt_Pvt.g_required_value
2647: ,p_token1 => Okl_Pdt_Pvt.g_col_name_token
2648: ,p_token1_value => l_token_1);
2649: IF(IS_DEBUG_PROCEDURE_ON) THEN
2650: BEGIN
2651: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSPDB.pls call Okl_Api.SET_MESSAGE ');

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

2663: NULL;
2664:
2665: WHEN OTHERS THEN
2666: -- store SQL error message on message stack for caller
2667: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name,
2668: p_msg_name => Okl_Pdt_Pvt.g_unexpected_error,
2669: p_token1 => Okl_Pdt_Pvt.g_sqlcode_token,
2670: p_token1_value => SQLCODE,
2671:

Line 2668: p_msg_name => Okl_Pdt_Pvt.g_unexpected_error,

2664:
2665: WHEN OTHERS THEN
2666: -- store SQL error message on message stack for caller
2667: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name,
2668: p_msg_name => Okl_Pdt_Pvt.g_unexpected_error,
2669: p_token1 => Okl_Pdt_Pvt.g_sqlcode_token,
2670: p_token1_value => SQLCODE,
2671:
2672: p_token2 => Okl_Pdt_Pvt.g_sqlerrm_token,

Line 2669: p_token1 => Okl_Pdt_Pvt.g_sqlcode_token,

2665: WHEN OTHERS THEN
2666: -- store SQL error message on message stack for caller
2667: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name,
2668: p_msg_name => Okl_Pdt_Pvt.g_unexpected_error,
2669: p_token1 => Okl_Pdt_Pvt.g_sqlcode_token,
2670: p_token1_value => SQLCODE,
2671:
2672: p_token2 => Okl_Pdt_Pvt.g_sqlerrm_token,
2673: p_token2_value => SQLERRM);

Line 2672: p_token2 => Okl_Pdt_Pvt.g_sqlerrm_token,

2668: p_msg_name => Okl_Pdt_Pvt.g_unexpected_error,
2669: p_token1 => Okl_Pdt_Pvt.g_sqlcode_token,
2670: p_token1_value => SQLCODE,
2671:
2672: p_token2 => Okl_Pdt_Pvt.g_sqlerrm_token,
2673: p_token2_value => SQLERRM);
2674:
2675: -- notify caller of an UNEXPECTED error
2676: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

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

2714: BEGIN
2715: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Api.SET_MESSAGE ');
2716: END;
2717: END IF;
2718: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name
2719: ,p_msg_name => Okl_Pdt_Pvt.g_required_value
2720: ,p_token1 => Okl_Pdt_Pvt.g_col_name_token
2721: ,p_token1_value => l_token_1);
2722: IF(IS_DEBUG_PROCEDURE_ON) THEN

Line 2719: ,p_msg_name => Okl_Pdt_Pvt.g_required_value

2715: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Api.SET_MESSAGE ');
2716: END;
2717: END IF;
2718: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name
2719: ,p_msg_name => Okl_Pdt_Pvt.g_required_value
2720: ,p_token1 => Okl_Pdt_Pvt.g_col_name_token
2721: ,p_token1_value => l_token_1);
2722: IF(IS_DEBUG_PROCEDURE_ON) THEN
2723: BEGIN

Line 2720: ,p_token1 => Okl_Pdt_Pvt.g_col_name_token

2716: END;
2717: END IF;
2718: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name
2719: ,p_msg_name => Okl_Pdt_Pvt.g_required_value
2720: ,p_token1 => Okl_Pdt_Pvt.g_col_name_token
2721: ,p_token1_value => l_token_1);
2722: IF(IS_DEBUG_PROCEDURE_ON) THEN
2723: BEGIN
2724: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSPDB.pls call Okl_Api.SET_MESSAGE ');

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

2737: NULL;
2738:
2739: WHEN OTHERS THEN
2740: -- store SQL error message on message stack for caller
2741: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name,
2742: p_msg_name => Okl_Pdt_Pvt.g_unexpected_error,
2743:
2744: p_token1 => Okl_Pdt_Pvt.g_sqlcode_token,
2745: p_token1_value => SQLCODE,

Line 2742: p_msg_name => Okl_Pdt_Pvt.g_unexpected_error,

2738:
2739: WHEN OTHERS THEN
2740: -- store SQL error message on message stack for caller
2741: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name,
2742: p_msg_name => Okl_Pdt_Pvt.g_unexpected_error,
2743:
2744: p_token1 => Okl_Pdt_Pvt.g_sqlcode_token,
2745: p_token1_value => SQLCODE,
2746: p_token2 => Okl_Pdt_Pvt.g_sqlerrm_token,

Line 2744: p_token1 => Okl_Pdt_Pvt.g_sqlcode_token,

2740: -- store SQL error message on message stack for caller
2741: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name,
2742: p_msg_name => Okl_Pdt_Pvt.g_unexpected_error,
2743:
2744: p_token1 => Okl_Pdt_Pvt.g_sqlcode_token,
2745: p_token1_value => SQLCODE,
2746: p_token2 => Okl_Pdt_Pvt.g_sqlerrm_token,
2747: p_token2_value => SQLERRM);
2748:

Line 2746: p_token2 => Okl_Pdt_Pvt.g_sqlerrm_token,

2742: p_msg_name => Okl_Pdt_Pvt.g_unexpected_error,
2743:
2744: p_token1 => Okl_Pdt_Pvt.g_sqlcode_token,
2745: p_token1_value => SQLCODE,
2746: p_token2 => Okl_Pdt_Pvt.g_sqlerrm_token,
2747: p_token2_value => SQLERRM);
2748:
2749: -- notify caller of an UNEXPECTED error
2750: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

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

2838: RETURN (l_return_status);
2839:
2840: WHEN OTHERS THEN
2841: -- store SQL error message on message stack for caller
2842: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name,
2843: p_msg_name => Okl_Pdt_Pvt.g_unexpected_error,
2844: p_token1 => Okl_Pdt_Pvt.g_sqlcode_token,
2845: p_token1_value => SQLCODE,
2846:

Line 2843: p_msg_name => Okl_Pdt_Pvt.g_unexpected_error,

2839:
2840: WHEN OTHERS THEN
2841: -- store SQL error message on message stack for caller
2842: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name,
2843: p_msg_name => Okl_Pdt_Pvt.g_unexpected_error,
2844: p_token1 => Okl_Pdt_Pvt.g_sqlcode_token,
2845: p_token1_value => SQLCODE,
2846:
2847: p_token2 => Okl_Pdt_Pvt.g_sqlerrm_token,

Line 2844: p_token1 => Okl_Pdt_Pvt.g_sqlcode_token,

2840: WHEN OTHERS THEN
2841: -- store SQL error message on message stack for caller
2842: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name,
2843: p_msg_name => Okl_Pdt_Pvt.g_unexpected_error,
2844: p_token1 => Okl_Pdt_Pvt.g_sqlcode_token,
2845: p_token1_value => SQLCODE,
2846:
2847: p_token2 => Okl_Pdt_Pvt.g_sqlerrm_token,
2848: p_token2_value => SQLERRM);

Line 2847: p_token2 => Okl_Pdt_Pvt.g_sqlerrm_token,

2843: p_msg_name => Okl_Pdt_Pvt.g_unexpected_error,
2844: p_token1 => Okl_Pdt_Pvt.g_sqlcode_token,
2845: p_token1_value => SQLCODE,
2846:
2847: p_token2 => Okl_Pdt_Pvt.g_sqlerrm_token,
2848: p_token2_value => SQLERRM);
2849: -- notify caller of an UNEXPECTED error
2850: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
2851: RETURN(l_return_status);