DBA Data[Home] [Help]

APPS.OKL_STREAMS_PUB dependencies on OKL_STREAMS_PUB

Line 1: PACKAGE BODY Okl_Streams_Pub AS

1: PACKAGE BODY Okl_Streams_Pub AS
2: /* $Header: OKLPSTMB.pls 120.1 2005/05/30 12:27:21 kthiruva noship $ */
3:
4:
5:

Line 126: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','create_streams');

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_STREAMS_PUB','create_streams');
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 230: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','create_streams');

226: ,p_count => x_msg_count
227: ,p_data => x_msg_data);
228:
229: WHEN OTHERS THEN
230: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','create_streams');
231: -- store SQL error message on message stack for caller
232: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
233: ,p_count => x_msg_count
234: ,p_data => x_msg_data);

Line 372: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','create_streams');

368: ,p_count => x_msg_count
369: ,p_data => x_msg_data);
370:
371: WHEN OTHERS THEN
372: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','create_streams');
373: -- store SQL error message on message stack for caller
374: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
375: ,p_count => x_msg_count
376: ,p_data => x_msg_data);

Line 438: Okl_Streams_Pub.create_streams(

434: i := l_stmv_tbl.FIRST;
435:
436: LOOP
437:
438: Okl_Streams_Pub.create_streams(
439:
440: p_api_version => p_api_version
441:
442: ,p_init_msg_list => p_init_msg_list

Line 513: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','create_streams');

509: ,p_count => x_msg_count
510: ,p_data => x_msg_data);
511:
512: WHEN OTHERS THEN
513: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','create_streams');
514: -- store SQL error message on message stack for caller
515: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
516: ,p_count => x_msg_count
517: ,p_data => x_msg_data);

Line 594: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','create_streams_perf');

590: ,p_count => x_msg_count
591: ,p_data => x_msg_data);
592:
593: WHEN OTHERS THEN
594: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','create_streams_perf');
595: -- store SQL error message on message stack for caller
596: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
597: ,p_count => x_msg_count
598: ,p_data => x_msg_data);

Line 726: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','update_streams');

722: ,p_count => x_msg_count
723: ,p_data => x_msg_data);
724:
725: WHEN OTHERS THEN
726: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','update_streams');
727: -- store SQL error message on message stack for caller
728: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
729: ,p_count => x_msg_count
730: ,p_data => x_msg_data);

Line 849: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','validate_streams');

845: ,p_count => x_msg_count
846: ,p_data => x_msg_data);
847:
848: WHEN OTHERS THEN
849: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','validate_streams');
850: -- store SQL error message on message stack for caller
851: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
852: ,p_count => x_msg_count
853: ,p_data => x_msg_data);

Line 928: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','lock_streams');

924: ,p_count => x_msg_count
925: ,p_data => x_msg_data);
926:
927: WHEN OTHERS THEN
928: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','lock_streams');
929: -- store SQL error message on message stack for caller
930: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
931: ,p_count => x_msg_count
932: ,p_data => x_msg_data);

Line 977: Okl_Streams_Pub.lock_streams(

973: i := p_stmv_tbl.FIRST;
974:
975: LOOP
976:
977: Okl_Streams_Pub.lock_streams(
978:
979: p_api_version => p_api_version
980:
981: ,p_init_msg_list => p_init_msg_list

Line 1149: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','update_streams');

1145: ,p_count => x_msg_count
1146: ,p_data => x_msg_data);
1147:
1148: WHEN OTHERS THEN
1149: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','update_streams');
1150: -- store SQL error message on message stack for caller
1151: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1152: ,p_count => x_msg_count
1153: ,p_data => x_msg_data);

Line 1289: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','update_streams');

1285: ,p_count => x_msg_count
1286: ,p_data => x_msg_data);
1287:
1288: WHEN OTHERS THEN
1289: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','update_streams');
1290: -- store SQL error message on message stack for caller
1291: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1292: ,p_count => x_msg_count
1293: ,p_data => x_msg_data);

Line 1410: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','delete_streams');

1406: ,p_count => x_msg_count
1407: ,p_data => x_msg_data);
1408:
1409: WHEN OTHERS THEN
1410: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','delete_streams');
1411: -- store SQL error message on message stack for caller
1412: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1413: ,p_count => x_msg_count
1414: ,p_data => x_msg_data);

Line 1546: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','delete_streams');

1542: ,p_count => x_msg_count
1543: ,p_data => x_msg_data);
1544:
1545: WHEN OTHERS THEN
1546: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','delete_streams');
1547: -- store SQL error message on message stack for caller
1548: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1549: ,p_count => x_msg_count
1550: ,p_data => x_msg_data);

Line 1663: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','validate_streams');

1659: ,p_count => x_msg_count
1660: ,p_data => x_msg_data);
1661:
1662: WHEN OTHERS THEN
1663: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','validate_streams');
1664: -- store SQL error message on message stack for caller
1665: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1666: ,p_count => x_msg_count
1667: ,p_data => x_msg_data);

Line 1797: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','validate_streams');

1793: ,p_count => x_msg_count
1794: ,p_data => x_msg_data);
1795:
1796: WHEN OTHERS THEN
1797: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','validate_streams');
1798: -- store SQL error message on message stack for caller
1799: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1800: ,p_count => x_msg_count
1801: ,p_data => x_msg_data);

Line 1917: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','create_stream_elements');

1913: ,p_count => x_msg_count
1914: ,p_data => x_msg_data);
1915:
1916: WHEN OTHERS THEN
1917: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','create_stream_elements');
1918: -- store SQL error message on message stack for caller
1919: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1920: ,p_count => x_msg_count
1921: ,p_data => x_msg_data);

Line 2058: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','create_stream_elements');

2054: ,p_count => x_msg_count
2055: ,p_data => x_msg_data);
2056:
2057: WHEN OTHERS THEN
2058: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','create_stream_elements');
2059: -- store SQL error message on message stack for caller
2060: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2061: ,p_count => x_msg_count
2062: ,p_data => x_msg_data);

Line 2134: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','lock_stream_elements');

2130: ,p_count => x_msg_count
2131: ,p_data => x_msg_data);
2132:
2133: WHEN OTHERS THEN
2134: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','lock_stream_elements');
2135: -- store SQL error message on message stack for caller
2136: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2137: ,p_count => x_msg_count
2138: ,p_data => x_msg_data);

Line 2238: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','lock_stream_elements');

2234: ,p_count => x_msg_count
2235: ,p_data => x_msg_data);
2236:
2237: WHEN OTHERS THEN
2238: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','lock_stream_elements');
2239: -- store SQL error message on message stack for caller
2240: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2241: ,p_count => x_msg_count
2242: ,p_data => x_msg_data);

Line 2353: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','update_stream_elements');

2349: ,p_count => x_msg_count
2350: ,p_data => x_msg_data);
2351:
2352: WHEN OTHERS THEN
2353: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','update_stream_elements');
2354: -- store SQL error message on message stack for caller
2355: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2356: ,p_count => x_msg_count
2357: ,p_data => x_msg_data);

Line 2493: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','update_stream_elements');

2489: ,p_count => x_msg_count
2490: ,p_data => x_msg_data);
2491:
2492: WHEN OTHERS THEN
2493: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','update_stream_elements');
2494: -- store SQL error message on message stack for caller
2495: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2496: ,p_count => x_msg_count
2497: ,p_data => x_msg_data);

Line 2610: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','delete_stream_elements');

2606: ,p_count => x_msg_count
2607: ,p_data => x_msg_data);
2608:
2609: WHEN OTHERS THEN
2610: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','delete_stream_elements');
2611: -- store SQL error message on message stack for caller
2612: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2613: ,p_count => x_msg_count
2614: ,p_data => x_msg_data);

Line 2746: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','delete_stream_elements');

2742: ,p_count => x_msg_count
2743: ,p_data => x_msg_data);
2744:
2745: WHEN OTHERS THEN
2746: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','delete_stream_elements');
2747: -- store SQL error message on message stack for caller
2748: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2749: ,p_count => x_msg_count
2750: ,p_data => x_msg_data);

Line 2859: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','validate_stream_elements');

2855: ,p_count => x_msg_count
2856: ,p_data => x_msg_data);
2857:
2858: WHEN OTHERS THEN
2859: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','validate_stream_elements');
2860: -- store SQL error message on message stack for caller
2861: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2862: ,p_count => x_msg_count
2863: ,p_data => x_msg_data);

Line 2994: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','validate_stream_elements');

2990: ,p_count => x_msg_count
2991: ,p_data => x_msg_data);
2992:
2993: WHEN OTHERS THEN
2994: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','validate_stream_elements');
2995: -- store SQL error message on message stack for caller
2996: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2997: ,p_count => x_msg_count
2998: ,p_data => x_msg_data);

Line 3006: END Okl_Streams_Pub;

3002: END validate_stream_elements;
3003:
3004:
3005:
3006: END Okl_Streams_Pub;