DBA Data[Home] [Help]

APPS.OKL_PROCESS_STREAMS_PVT dependencies on OKL_STREAMS_PUB

Line 302: -- Start of wraper code generated automatically by Debug code generator for Okl_Streams_Pub.create_streams

298: END IF;
299: END IF;
300: END IF;
301: END LOOP;
302: -- Start of wraper code generated automatically by Debug code generator for Okl_Streams_Pub.create_streams
303: IF(L_DEBUG_ENABLED='Y') THEN
304: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
305: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
306: END IF;

Line 309: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRPSRB.pls call Okl_Streams_Pub.create_streams ');

305: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
306: END IF;
307: IF(IS_DEBUG_PROCEDURE_ON) THEN
308: BEGIN
309: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRPSRB.pls call Okl_Streams_Pub.create_streams ');
310: END;
311: END IF;
312: Okl_Streams_Pub.create_streams(p_api_version
313: ,p_init_msg_list

Line 312: Okl_Streams_Pub.create_streams(p_api_version

308: BEGIN
309: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRPSRB.pls call Okl_Streams_Pub.create_streams ');
310: END;
311: END IF;
312: Okl_Streams_Pub.create_streams(p_api_version
313: ,p_init_msg_list
314: ,x_return_status
315: ,x_msg_count
316: ,x_msg_data

Line 323: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRPSRB.pls call Okl_Streams_Pub.create_streams ');

319: ,x_stmv_rec
320: ,x_selv_tbl);
321: IF(IS_DEBUG_PROCEDURE_ON) THEN
322: BEGIN
323: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRPSRB.pls call Okl_Streams_Pub.create_streams ');
324: END;
325: END IF;
326: -- End of wraper code generated automatically by Debug code generator for Okl_Streams_Pub.create_streams
327: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN

Line 326: -- End of wraper code generated automatically by Debug code generator for Okl_Streams_Pub.create_streams

322: BEGIN
323: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRPSRB.pls call Okl_Streams_Pub.create_streams ');
324: END;
325: END IF;
326: -- End of wraper code generated automatically by Debug code generator for Okl_Streams_Pub.create_streams
327: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
328: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
329: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
330: RAISE G_EXCEPTION_ERROR;

Line 534: -- Start of wraper code generated automatically by Debug code generator for Okl_Streams_Pub.create_streams

530: END IF;
531: END IF;
532: END IF;
533: END LOOP;
534: -- Start of wraper code generated automatically by Debug code generator for Okl_Streams_Pub.create_streams
535: IF(L_DEBUG_ENABLED='Y') THEN
536: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
537: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
538: END IF;

Line 541: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRPSRB.pls call Okl_Streams_Pub.create_streams ');

537: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
538: END IF;
539: IF(IS_DEBUG_PROCEDURE_ON) THEN
540: BEGIN
541: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRPSRB.pls call Okl_Streams_Pub.create_streams ');
542: END;
543: END IF;
544: Okl_Streams_Pub.create_streams(p_api_version
545: ,p_init_msg_list

Line 544: Okl_Streams_Pub.create_streams(p_api_version

540: BEGIN
541: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRPSRB.pls call Okl_Streams_Pub.create_streams ');
542: END;
543: END IF;
544: Okl_Streams_Pub.create_streams(p_api_version
545: ,p_init_msg_list
546: ,x_return_status
547: ,x_msg_count
548: ,x_msg_data

Line 555: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRPSRB.pls call Okl_Streams_Pub.create_streams ');

551: ,x_stmv_rec
552: ,x_selv_tbl);
553: IF(IS_DEBUG_PROCEDURE_ON) THEN
554: BEGIN
555: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRPSRB.pls call Okl_Streams_Pub.create_streams ');
556: END;
557: END IF;
558: -- End of wraper code generated automatically by Debug code generator for Okl_Streams_Pub.create_streams
559: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN

Line 558: -- End of wraper code generated automatically by Debug code generator for Okl_Streams_Pub.create_streams

554: BEGIN
555: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRPSRB.pls call Okl_Streams_Pub.create_streams ');
556: END;
557: END IF;
558: -- End of wraper code generated automatically by Debug code generator for Okl_Streams_Pub.create_streams
559: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
560: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
561: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
562: RAISE G_EXCEPTION_ERROR;

Line 1238: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRPSRB.pls call Okl_Streams_Pub.create_streams ');

1234: ELSE
1235: -- call the insert API for STREAMS
1236: IF(IS_DEBUG_PROCEDURE_ON) THEN
1237: BEGIN
1238: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRPSRB.pls call Okl_Streams_Pub.create_streams ');
1239: END;
1240: END IF;
1241:
1242: --Modified by kthiruva for Streams Performance on 15-May-2005

Line 1296: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRPSRB.pls call Okl_Streams_Pub.create_streams ');

1292: --Bug 4346646 - End of Changes
1293:
1294: IF(IS_DEBUG_PROCEDURE_ON) THEN
1295: BEGIN
1296: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRPSRB.pls call Okl_Streams_Pub.create_streams ');
1297: END;
1298: END IF;
1299:
1300: j := 1 ;

Line 1336: -- Start of wraper code generated automatically by Debug code generator for Okl_Streams_Pub.create_streams

1332: p_line_number := p_first_line_number + 1;
1333: END IF;
1334: END LOOP;
1335: -- insert the last record from the CURSOR
1336: -- Start of wraper code generated automatically by Debug code generator for Okl_Streams_Pub.create_streams
1337: IF( l_khr_id IS NOT NULL )
1338: THEN
1339: IF(IS_DEBUG_PROCEDURE_ON) THEN
1340: BEGIN

Line 1341: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRPSRB.pls call Okl_Streams_Pub.create_streams ');

1337: IF( l_khr_id IS NOT NULL )
1338: THEN
1339: IF(IS_DEBUG_PROCEDURE_ON) THEN
1340: BEGIN
1341: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRPSRB.pls call Okl_Streams_Pub.create_streams ');
1342: END;
1343: END IF;
1344:
1345: --Modified by kthiruva on 15-May-2005 for Streams Performance

Line 1396: Okl_Streams_Pub.create_streams_perf(p_api_version

1392: END IF;
1393:
1394: --Calling the new method that accepts a table of stream headers and a table of stream elements
1395: -- Bulk insert calls are made for both the stream headers and stream elements.
1396: Okl_Streams_Pub.create_streams_perf(p_api_version
1397: ,p_init_msg_list
1398: ,x_return_status
1399: ,x_msg_count
1400: ,x_msg_data

Line 1408: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to Okl_Streams_Pub.create_streams_perf, return status is :'||x_return_status);

1404: ,x_selv_tbl);
1405: --Bug 4346646 - End of Changes
1406: --Added by kthiruva for Debug Logging
1407: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1408: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to Okl_Streams_Pub.create_streams_perf, return status is :'||x_return_status);
1409: END IF;
1410:
1411:
1412: IF(IS_DEBUG_PROCEDURE_ON) THEN

Line 1414: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRPSRB.pls call Okl_Streams_Pub.create_streams ');

1410:
1411:
1412: IF(IS_DEBUG_PROCEDURE_ON) THEN
1413: BEGIN
1414: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRPSRB.pls call Okl_Streams_Pub.create_streams ');
1415: END;
1416: END IF;
1417: -- End of wraper code generated automatically by Debug code generator for Okl_Streams_Pub.create_streams
1418: IF (x_return_status = G_RET_STS_UNEXP_ERROR)

Line 1417: -- End of wraper code generated automatically by Debug code generator for Okl_Streams_Pub.create_streams

1413: BEGIN
1414: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRPSRB.pls call Okl_Streams_Pub.create_streams ');
1415: END;
1416: END IF;
1417: -- End of wraper code generated automatically by Debug code generator for Okl_Streams_Pub.create_streams
1418: IF (x_return_status = G_RET_STS_UNEXP_ERROR)
1419: THEN
1420: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
1421: ELSIF (x_return_status = G_RET_STS_ERROR)

Line 1900: -- Start of wraper code generated automatically by Debug code generator for Okl_Streams_Pub.update_streams

1896: stmv_tbl(i).say_code := G_STREAM_ACTIVITY_HIST ;
1897: stmv_tbl(i).date_history := SYSDATE;
1898: END LOOP;
1899: -- call the update for all the records
1900: -- Start of wraper code generated automatically by Debug code generator for Okl_Streams_Pub.update_streams
1901: IF(L_DEBUG_ENABLED='Y') THEN
1902: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
1903: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
1904: END IF;

Line 1907: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRPSRB.pls call Okl_Streams_Pub.update_streams ');

1903: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
1904: END IF;
1905: IF(IS_DEBUG_PROCEDURE_ON) THEN
1906: BEGIN
1907: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRPSRB.pls call Okl_Streams_Pub.update_streams ');
1908: END;
1909: END IF;
1910: Okl_Streams_Pub.update_streams(l_api_version
1911: ,p_init_msg_list

Line 1910: Okl_Streams_Pub.update_streams(l_api_version

1906: BEGIN
1907: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRPSRB.pls call Okl_Streams_Pub.update_streams ');
1908: END;
1909: END IF;
1910: Okl_Streams_Pub.update_streams(l_api_version
1911: ,p_init_msg_list
1912: ,x_return_status
1913: ,x_msg_count
1914: ,x_msg_data

Line 1919: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRPSRB.pls call Okl_Streams_Pub.update_streams ');

1915: ,stmv_tbl
1916: ,x_stmv_tbl);
1917: IF(IS_DEBUG_PROCEDURE_ON) THEN
1918: BEGIN
1919: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRPSRB.pls call Okl_Streams_Pub.update_streams ');
1920: END;
1921: END IF;
1922: -- End of wraper code generated automatically by Debug code generator for Okl_Streams_Pub.update_streams
1923: EXCEPTION

Line 1922: -- End of wraper code generated automatically by Debug code generator for Okl_Streams_Pub.update_streams

1918: BEGIN
1919: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRPSRB.pls call Okl_Streams_Pub.update_streams ');
1920: END;
1921: END IF;
1922: -- End of wraper code generated automatically by Debug code generator for Okl_Streams_Pub.update_streams
1923: EXCEPTION
1924: WHEN G_EXCEPTION_ERROR THEN
1925: x_return_status := G_RET_STS_ERROR;
1926: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN