DBA Data[Home] [Help]

APPS.OKL_OPTIONS_PUB dependencies on OKL_OPTIONS_PUB

Line 1: PACKAGE BODY OKL_OPTIONS_PUB AS

1: PACKAGE BODY OKL_OPTIONS_PUB AS
2: /* $Header: OKLPOPTB.pls 115.7 2002/12/18 12:25:40 kjinger noship $ */
3:
4:
5:

Line 126: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPTIONS_PUB','create_options');

122: ,p_count => x_msg_count
123: ,p_data => x_msg_data);
124:
125: WHEN OTHERS THEN
126: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPTIONS_PUB','create_options');
127: -- store SQL error message on message stack for caller
128: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
129: ,p_count => x_msg_count
130: ,p_data => x_msg_data);

Line 246: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPTIONS_PUB','create_options');

242: ,p_count => x_msg_count
243: ,p_data => x_msg_data);
244:
245: WHEN OTHERS THEN
246: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPTIONS_PUB','create_options');
247: -- store SQL error message on message stack for caller
248: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
249: ,p_count => x_msg_count
250: ,p_data => x_msg_data);

Line 312: okl_options_pub.create_options(

308: i := l_optv_tbl.FIRST;
309:
310: LOOP
311:
312: okl_options_pub.create_options(
313:
314: p_api_version => p_api_version
315:
316: ,p_init_msg_list => p_init_msg_list

Line 387: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPTIONS_PUB','create_options');

383: ,p_count => x_msg_count
384: ,p_data => x_msg_data);
385:
386: WHEN OTHERS THEN
387: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPTIONS_PUB','create_options');
388: -- store SQL error message on message stack for caller
389: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
390: ,p_count => x_msg_count
391: ,p_data => x_msg_data);

Line 520: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPTIONS_PUB','update_options');

516: ,p_count => x_msg_count
517: ,p_data => x_msg_data);
518:
519: WHEN OTHERS THEN
520: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPTIONS_PUB','update_options');
521: -- store SQL error message on message stack for caller
522: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
523: ,p_count => x_msg_count
524: ,p_data => x_msg_data);

Line 643: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPTIONS_PUB','validate_options');

639: ,p_count => x_msg_count
640: ,p_data => x_msg_data);
641:
642: WHEN OTHERS THEN
643: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPTIONS_PUB','validate_options');
644: -- store SQL error message on message stack for caller
645: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
646: ,p_count => x_msg_count
647: ,p_data => x_msg_data);

Line 722: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPTIONS_PUB','lock_options');

718: ,p_count => x_msg_count
719: ,p_data => x_msg_data);
720:
721: WHEN OTHERS THEN
722: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPTIONS_PUB','lock_options');
723: -- store SQL error message on message stack for caller
724: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
725: ,p_count => x_msg_count
726: ,p_data => x_msg_data);

Line 771: okl_options_pub.lock_options(

767: i := p_optv_tbl.FIRST;
768:
769: LOOP
770:
771: okl_options_pub.lock_options(
772:
773: p_api_version => p_api_version
774:
775: ,p_init_msg_list => p_init_msg_list

Line 943: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPTIONS_PUB','update_options');

939: ,p_count => x_msg_count
940: ,p_data => x_msg_data);
941:
942: WHEN OTHERS THEN
943: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPTIONS_PUB','update_options');
944: -- store SQL error message on message stack for caller
945: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
946: ,p_count => x_msg_count
947: ,p_data => x_msg_data);

Line 1083: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPTIONS_PUB','update_options');

1079: ,p_count => x_msg_count
1080: ,p_data => x_msg_data);
1081:
1082: WHEN OTHERS THEN
1083: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPTIONS_PUB','update_options');
1084: -- store SQL error message on message stack for caller
1085: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1086: ,p_count => x_msg_count
1087: ,p_data => x_msg_data);

Line 1204: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPTIONS_PUB','delete_options');

1200: ,p_count => x_msg_count
1201: ,p_data => x_msg_data);
1202:
1203: WHEN OTHERS THEN
1204: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPTIONS_PUB','delete_options');
1205: -- store SQL error message on message stack for caller
1206: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1207: ,p_count => x_msg_count
1208: ,p_data => x_msg_data);

Line 1340: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPTIONS_PUB','delete_options');

1336: ,p_count => x_msg_count
1337: ,p_data => x_msg_data);
1338:
1339: WHEN OTHERS THEN
1340: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPTIONS_PUB','delete_options');
1341: -- store SQL error message on message stack for caller
1342: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1343: ,p_count => x_msg_count
1344: ,p_data => x_msg_data);

Line 1457: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPTIONS_PUB','validate_options');

1453: ,p_count => x_msg_count
1454: ,p_data => x_msg_data);
1455:
1456: WHEN OTHERS THEN
1457: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPTIONS_PUB','validate_options');
1458: -- store SQL error message on message stack for caller
1459: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1460: ,p_count => x_msg_count
1461: ,p_data => x_msg_data);

Line 1591: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPTIONS_PUB','validate_options');

1587: ,p_count => x_msg_count
1588: ,p_data => x_msg_data);
1589:
1590: WHEN OTHERS THEN
1591: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPTIONS_PUB','validate_options');
1592: -- store SQL error message on message stack for caller
1593: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1594: ,p_count => x_msg_count
1595: ,p_data => x_msg_data);

Line 1711: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPTIONS_PUB','create_option_values');

1707: ,p_count => x_msg_count
1708: ,p_data => x_msg_data);
1709:
1710: WHEN OTHERS THEN
1711: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPTIONS_PUB','create_option_values');
1712: -- store SQL error message on message stack for caller
1713: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1714: ,p_count => x_msg_count
1715: ,p_data => x_msg_data);

Line 1852: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPTIONS_PUB','create_option_values');

1848: ,p_count => x_msg_count
1849: ,p_data => x_msg_data);
1850:
1851: WHEN OTHERS THEN
1852: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPTIONS_PUB','create_option_values');
1853: -- store SQL error message on message stack for caller
1854: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1855: ,p_count => x_msg_count
1856: ,p_data => x_msg_data);

Line 1928: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPTIONS_PUB','lock_option_values');

1924: ,p_count => x_msg_count
1925: ,p_data => x_msg_data);
1926:
1927: WHEN OTHERS THEN
1928: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPTIONS_PUB','lock_option_values');
1929: -- store SQL error message on message stack for caller
1930: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1931: ,p_count => x_msg_count
1932: ,p_data => x_msg_data);

Line 2032: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPTIONS_PUB','lock_option_values');

2028: ,p_count => x_msg_count
2029: ,p_data => x_msg_data);
2030:
2031: WHEN OTHERS THEN
2032: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPTIONS_PUB','lock_option_values');
2033: -- store SQL error message on message stack for caller
2034: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2035: ,p_count => x_msg_count
2036: ,p_data => x_msg_data);

Line 2147: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPTIONS_PUB','update_option_values');

2143: ,p_count => x_msg_count
2144: ,p_data => x_msg_data);
2145:
2146: WHEN OTHERS THEN
2147: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPTIONS_PUB','update_option_values');
2148: -- store SQL error message on message stack for caller
2149: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2150: ,p_count => x_msg_count
2151: ,p_data => x_msg_data);

Line 2287: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPTIONS_PUB','update_option_values');

2283: ,p_count => x_msg_count
2284: ,p_data => x_msg_data);
2285:
2286: WHEN OTHERS THEN
2287: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPTIONS_PUB','update_option_values');
2288: -- store SQL error message on message stack for caller
2289: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2290: ,p_count => x_msg_count
2291: ,p_data => x_msg_data);

Line 2404: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPTIONS_PUB','delete_option_values');

2400: ,p_count => x_msg_count
2401: ,p_data => x_msg_data);
2402:
2403: WHEN OTHERS THEN
2404: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPTIONS_PUB','delete_option_values');
2405: -- store SQL error message on message stack for caller
2406: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2407: ,p_count => x_msg_count
2408: ,p_data => x_msg_data);

Line 2540: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPTIONS_PUB','delete_option_values');

2536: ,p_count => x_msg_count
2537: ,p_data => x_msg_data);
2538:
2539: WHEN OTHERS THEN
2540: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPTIONS_PUB','delete_option_values');
2541: -- store SQL error message on message stack for caller
2542: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2543: ,p_count => x_msg_count
2544: ,p_data => x_msg_data);

Line 2653: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPTIONS_PUB','validate_option_values');

2649: ,p_count => x_msg_count
2650: ,p_data => x_msg_data);
2651:
2652: WHEN OTHERS THEN
2653: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPTIONS_PUB','validate_option_values');
2654: -- store SQL error message on message stack for caller
2655: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2656: ,p_count => x_msg_count
2657: ,p_data => x_msg_data);

Line 2788: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPTIONS_PUB','validate_option_values');

2784: ,p_count => x_msg_count
2785: ,p_data => x_msg_data);
2786:
2787: WHEN OTHERS THEN
2788: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPTIONS_PUB','validate_option_values');
2789: -- store SQL error message on message stack for caller
2790: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2791: ,p_count => x_msg_count
2792: ,p_data => x_msg_data);

Line 2800: END OKL_OPTIONS_PUB;

2796: END validate_option_values;
2797:
2798:
2799:
2800: END OKL_OPTIONS_PUB;
2801: