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 1185: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRPSRB.pls call Okl_Streams_Pub.create_streams ');

1181: ELSE
1182: -- call the insert API for STREAMS
1183: IF(IS_DEBUG_PROCEDURE_ON) THEN
1184: BEGIN
1185: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRPSRB.pls call Okl_Streams_Pub.create_streams ');
1186: END;
1187: END IF;
1188:
1189: --Modified by kthiruva for Streams Performance on 15-May-2005

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

1239: --Bug 4346646 - End of Changes
1240:
1241: IF(IS_DEBUG_PROCEDURE_ON) THEN
1242: BEGIN
1243: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRPSRB.pls call Okl_Streams_Pub.create_streams ');
1244: END;
1245: END IF;
1246:
1247: j := 1 ;

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

1279: p_line_number := p_first_line_number + 1;
1280: END IF;
1281: END LOOP;
1282: -- insert the last record from the CURSOR
1283: -- Start of wraper code generated automatically by Debug code generator for Okl_Streams_Pub.create_streams
1284: IF( l_khr_id IS NOT NULL )
1285: THEN
1286: IF(IS_DEBUG_PROCEDURE_ON) THEN
1287: BEGIN

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

1284: IF( l_khr_id IS NOT NULL )
1285: THEN
1286: IF(IS_DEBUG_PROCEDURE_ON) THEN
1287: BEGIN
1288: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRPSRB.pls call Okl_Streams_Pub.create_streams ');
1289: END;
1290: END IF;
1291:
1292: --Modified by kthiruva on 15-May-2005 for Streams Performance

Line 1343: Okl_Streams_Pub.create_streams_perf(p_api_version

1339: END IF;
1340:
1341: --Calling the new method that accepts a table of stream headers and a table of stream elements
1342: -- Bulk insert calls are made for both the stream headers and stream elements.
1343: Okl_Streams_Pub.create_streams_perf(p_api_version
1344: ,p_init_msg_list
1345: ,x_return_status
1346: ,x_msg_count
1347: ,x_msg_data

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

1351: ,x_selv_tbl);
1352: --Bug 4346646 - End of Changes
1353: --Added by kthiruva for Debug Logging
1354: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1355: 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);
1356: END IF;
1357:
1358:
1359: IF(IS_DEBUG_PROCEDURE_ON) THEN

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

1357:
1358:
1359: IF(IS_DEBUG_PROCEDURE_ON) THEN
1360: BEGIN
1361: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRPSRB.pls call Okl_Streams_Pub.create_streams ');
1362: END;
1363: END IF;
1364: -- End of wraper code generated automatically by Debug code generator for Okl_Streams_Pub.create_streams
1365: IF (x_return_status = G_RET_STS_UNEXP_ERROR)

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

1360: BEGIN
1361: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRPSRB.pls call Okl_Streams_Pub.create_streams ');
1362: END;
1363: END IF;
1364: -- End of wraper code generated automatically by Debug code generator for Okl_Streams_Pub.create_streams
1365: IF (x_return_status = G_RET_STS_UNEXP_ERROR)
1366: THEN
1367: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
1368: ELSIF (x_return_status = G_RET_STS_ERROR)

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

1843: stmv_tbl(i).say_code := G_STREAM_ACTIVITY_HIST ;
1844: stmv_tbl(i).date_history := SYSDATE;
1845: END LOOP;
1846: -- call the update for all the records
1847: -- Start of wraper code generated automatically by Debug code generator for Okl_Streams_Pub.update_streams
1848: IF(L_DEBUG_ENABLED='Y') THEN
1849: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
1850: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
1851: END IF;

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

1850: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
1851: END IF;
1852: IF(IS_DEBUG_PROCEDURE_ON) THEN
1853: BEGIN
1854: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRPSRB.pls call Okl_Streams_Pub.update_streams ');
1855: END;
1856: END IF;
1857: Okl_Streams_Pub.update_streams(l_api_version
1858: ,p_init_msg_list

Line 1857: Okl_Streams_Pub.update_streams(l_api_version

1853: BEGIN
1854: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRPSRB.pls call Okl_Streams_Pub.update_streams ');
1855: END;
1856: END IF;
1857: Okl_Streams_Pub.update_streams(l_api_version
1858: ,p_init_msg_list
1859: ,x_return_status
1860: ,x_msg_count
1861: ,x_msg_data

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

1862: ,stmv_tbl
1863: ,x_stmv_tbl);
1864: IF(IS_DEBUG_PROCEDURE_ON) THEN
1865: BEGIN
1866: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRPSRB.pls call Okl_Streams_Pub.update_streams ');
1867: END;
1868: END IF;
1869: -- End of wraper code generated automatically by Debug code generator for Okl_Streams_Pub.update_streams
1870: EXCEPTION

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

1865: BEGIN
1866: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRPSRB.pls call Okl_Streams_Pub.update_streams ');
1867: END;
1868: END IF;
1869: -- End of wraper code generated automatically by Debug code generator for Okl_Streams_Pub.update_streams
1870: EXCEPTION
1871: WHEN G_EXCEPTION_ERROR THEN
1872: x_return_status := G_RET_STS_ERROR;
1873: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN