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_CREATE_STREAMS_PVT dependencies on OKL_STREAM_INTERFACES

Line 298: FROM okl_stream_interfaces

294: --smahapat 11/10/02 multi-gaap - addition
295: CURSOR l_sif_csr(l_contract_id NUMBER, l_trx_number NUMBER)
296: IS
297: SELECT id
298: FROM okl_stream_interfaces
299: WHERE khr_id = l_contract_id AND transaction_number = l_trx_number
300: AND sis_code IN (G_SIS_HDR_INSERTED, G_SIS_DATA_ENTERED, G_SIS_PROCESSING_REQUEST,G_SIS_RET_DATA_RECEIVED,G_SIS_PROCESS_COMPLETE);
301: --smahapat addition end
302:

Line 485: FROM okl_stream_interfaces

481: --smahapat 11/10/02 multi-gaap - addition
482: CURSOR l_sif_csr(l_contract_id NUMBER, l_trx_number NUMBER)
483: IS
484: SELECT id
485: FROM okl_stream_interfaces
486: WHERE khr_id = l_contract_id AND transaction_number = l_trx_number
487: AND sis_code IN (G_SIS_HDR_INSERTED, G_SIS_DATA_ENTERED, G_SIS_PROCESSING_REQUEST,G_SIS_RET_DATA_RECEIVED,G_SIS_PROCESS_COMPLETE);
488: --smahapat addition end
489: lp_sifv_rec sifv_rec_type;

Line 2118: FROM okl_stream_interfaces

2114:
2115: CURSOR update_sif_id_csr(p_trans_id NUMBER)
2116: IS
2117: SELECT id, khr_id
2118: FROM okl_stream_interfaces
2119: WHERE transaction_number = p_trans_id;
2120:
2121: l_sif_id NUMBER;
2122: l_khr_id NUMBER;

Line 2225: ,p_purpose_code IN OKL_STREAM_INTERFACES_V.PURPOSE_CODE%TYPE

2221: ---------------------------------------------------------------------------
2222: FUNCTION pending_request_exists(
2223: p_khr_id IN NUMBER
2224: --smahapat 11/10/02 multi-gaap - addition
2225: ,p_purpose_code IN OKL_STREAM_INTERFACES_V.PURPOSE_CODE%TYPE
2226: --smahapat addition end
2227: ,x_return_status OUT NOCOPY VARCHAR2
2228: ) RETURN BOOLEAN
2229: IS

Line 2230: CURSOR l_okl_sif_status_csr(p_khr_id IN OKL_STREAM_INTERFACES_V.KHR_ID%TYPE) IS

2226: --smahapat addition end
2227: ,x_return_status OUT NOCOPY VARCHAR2
2228: ) RETURN BOOLEAN
2229: IS
2230: CURSOR l_okl_sif_status_csr(p_khr_id IN OKL_STREAM_INTERFACES_V.KHR_ID%TYPE) IS
2231: SELECT '1' FROM dual
2232: WHERE EXISTS
2233: (SELECT '1'
2234: FROM OKL_STREAM_INTERFACES

Line 2234: FROM OKL_STREAM_INTERFACES

2230: CURSOR l_okl_sif_status_csr(p_khr_id IN OKL_STREAM_INTERFACES_V.KHR_ID%TYPE) IS
2231: SELECT '1' FROM dual
2232: WHERE EXISTS
2233: (SELECT '1'
2234: FROM OKL_STREAM_INTERFACES
2235: WHERE khr_id = p_khr_id
2236: AND SIS_CODE IN (G_SIS_HDR_INSERTED, G_SIS_DATA_ENTERED, G_SIS_PROCESSING_REQUEST,G_SIS_RET_DATA_RECEIVED)
2237: );
2238: --smahapat 11/10/02 multi-gaap - addition

Line 2239: CURSOR l_okl_sif_rpt_status_csr(p_khr_id IN OKL_STREAM_INTERFACES_V.KHR_ID%TYPE) IS

2235: WHERE khr_id = p_khr_id
2236: AND SIS_CODE IN (G_SIS_HDR_INSERTED, G_SIS_DATA_ENTERED, G_SIS_PROCESSING_REQUEST,G_SIS_RET_DATA_RECEIVED)
2237: );
2238: --smahapat 11/10/02 multi-gaap - addition
2239: CURSOR l_okl_sif_rpt_status_csr(p_khr_id IN OKL_STREAM_INTERFACES_V.KHR_ID%TYPE) IS
2240:
2241: SELECT '1' FROM dual
2242: WHERE EXISTS
2243: (SELECT '1'

Line 2244: FROM OKL_STREAM_INTERFACES

2240:
2241: SELECT '1' FROM dual
2242: WHERE EXISTS
2243: (SELECT '1'
2244: FROM OKL_STREAM_INTERFACES
2245: WHERE khr_id = p_khr_id AND purpose_code = G_PURPOSE_CODE_REPORT
2246: AND SIS_CODE IN (G_SIS_HDR_INSERTED, G_SIS_DATA_ENTERED, G_SIS_PROCESSING_REQUEST,G_SIS_RET_DATA_RECEIVED)
2247: );
2248: --smahapat addition end

Line 2333: -- Start of wraper code generated automatically by Debug code generator for Okl_Stream_Interfaces_Pub.insert_stream_interfaces

2329: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
2330: END IF;
2331: -- Insert Transaction Header Data
2332:
2333: -- Start of wraper code generated automatically by Debug code generator for Okl_Stream_Interfaces_Pub.insert_stream_interfaces
2334: IF(L_DEBUG_ENABLED='Y') THEN
2335: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
2336: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
2337: END IF;

Line 2340: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Stream_Interfaces_Pub.insert_stream_interfaces ');

2336: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
2337: END IF;
2338: IF(IS_DEBUG_PROCEDURE_ON) THEN
2339: BEGIN
2340: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Stream_Interfaces_Pub.insert_stream_interfaces ');
2341: END;
2342: END IF;
2343:
2344: Okl_Stream_Interfaces_Pub.insert_stream_interfaces(

Line 2344: Okl_Stream_Interfaces_Pub.insert_stream_interfaces(

2340: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Stream_Interfaces_Pub.insert_stream_interfaces ');
2341: END;
2342: END IF;
2343:
2344: Okl_Stream_Interfaces_Pub.insert_stream_interfaces(
2345: p_api_version => p_api_version
2346: ,p_init_msg_list => p_init_msg_list
2347: ,x_return_status => l_return_status
2348: ,x_msg_count => x_msg_count

Line 2354: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to Okl_Stream_Interfaces_Pub.insert_stream_interfaces, return status is:'||l_return_status);

2350: ,p_sifv_rec => lp_sifv_rec
2351: ,x_sifv_rec => lx_sifv_rec);
2352: --Added by kthiruva for Debugging
2353: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2354: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to Okl_Stream_Interfaces_Pub.insert_stream_interfaces, return status is:'||l_return_status);
2355: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'The transaction number of the request is :'||lx_sifv_rec.transaction_number);
2356: END IF;
2357:
2358: IF(IS_DEBUG_PROCEDURE_ON) THEN

Line 2360: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Stream_Interfaces_Pub.insert_stream_interfaces ');

2356: END IF;
2357:
2358: IF(IS_DEBUG_PROCEDURE_ON) THEN
2359: BEGIN
2360: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Stream_Interfaces_Pub.insert_stream_interfaces ');
2361: END;
2362: END IF;
2363:
2364: -- End of wraper code generated automatically by Debug code generator for Okl_Stream_Interfaces_Pub.insert_stream_interfaces

Line 2364: -- End of wraper code generated automatically by Debug code generator for Okl_Stream_Interfaces_Pub.insert_stream_interfaces

2360: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Stream_Interfaces_Pub.insert_stream_interfaces ');
2361: END;
2362: END IF;
2363:
2364: -- End of wraper code generated automatically by Debug code generator for Okl_Stream_Interfaces_Pub.insert_stream_interfaces
2365: IF l_return_status = G_RET_STS_ERROR THEN
2366: RAISE G_EXCEPTION_ERROR;
2367: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN
2368: RAISE G_EXCEPTION_UNEXPECTED_ERROR;

Line 2864: ,p_purpose_code IN OKL_STREAM_INTERFACES_V.PURPOSE_CODE%TYPE

2860: ---------------------------------------------------------------------------
2861: FUNCTION pending_request_exists(
2862: p_khr_id IN NUMBER
2863: --smahapat 11/10/02 multi-gaap - addition
2864: ,p_purpose_code IN OKL_STREAM_INTERFACES_V.PURPOSE_CODE%TYPE
2865: --smahapat addition end
2866: ,x_return_status OUT NOCOPY VARCHAR2
2867: ) RETURN BOOLEAN
2868: IS

Line 2869: CURSOR l_okl_sif_status_csr(p_khr_id IN OKL_STREAM_INTERFACES_V.KHR_ID%TYPE) IS

2865: --smahapat addition end
2866: ,x_return_status OUT NOCOPY VARCHAR2
2867: ) RETURN BOOLEAN
2868: IS
2869: CURSOR l_okl_sif_status_csr(p_khr_id IN OKL_STREAM_INTERFACES_V.KHR_ID%TYPE) IS
2870: SELECT '1' FROM dual
2871: WHERE EXISTS
2872: (SELECT '1'
2873: FROM OKL_STREAM_INTERFACES

Line 2873: FROM OKL_STREAM_INTERFACES

2869: CURSOR l_okl_sif_status_csr(p_khr_id IN OKL_STREAM_INTERFACES_V.KHR_ID%TYPE) IS
2870: SELECT '1' FROM dual
2871: WHERE EXISTS
2872: (SELECT '1'
2873: FROM OKL_STREAM_INTERFACES
2874: WHERE khr_id = p_khr_id
2875: AND SIS_CODE IN (G_SIS_HDR_INSERTED, G_SIS_DATA_ENTERED, G_SIS_PROCESSING_REQUEST,G_SIS_RET_DATA_RECEIVED)
2876: );
2877: --smahapat 11/10/02 multi-gaap - addition

Line 2880: CURSOR l_okl_sif_rpt_status_csr(p_khr_id IN OKL_STREAM_INTERFACES_V.KHR_ID%TYPE) IS

2876: );
2877: --smahapat 11/10/02 multi-gaap - addition
2878:
2879:
2880: CURSOR l_okl_sif_rpt_status_csr(p_khr_id IN OKL_STREAM_INTERFACES_V.KHR_ID%TYPE) IS
2881: SELECT '1' FROM dual
2882: WHERE EXISTS
2883: (SELECT '1'
2884: FROM OKL_STREAM_INTERFACES

Line 2884: FROM OKL_STREAM_INTERFACES

2880: CURSOR l_okl_sif_rpt_status_csr(p_khr_id IN OKL_STREAM_INTERFACES_V.KHR_ID%TYPE) IS
2881: SELECT '1' FROM dual
2882: WHERE EXISTS
2883: (SELECT '1'
2884: FROM OKL_STREAM_INTERFACES
2885: WHERE khr_id = p_khr_id AND purpose_code = G_PURPOSE_CODE_REPORT
2886: AND SIS_CODE IN (G_SIS_HDR_INSERTED, G_SIS_DATA_ENTERED, G_SIS_PROCESSING_REQUEST,G_SIS_RET_DATA_RECEIVED)
2887: );
2888: --smahapat addition end

Line 2969: -- Start of wraper code generated automatically by Debug code generator for Okl_Stream_Interfaces_Pub.insert_stream_interfaces

2965: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
2966:
2967: END IF;
2968: -- Insert Transaction Header Data
2969: -- Start of wraper code generated automatically by Debug code generator for Okl_Stream_Interfaces_Pub.insert_stream_interfaces
2970: IF(L_DEBUG_ENABLED='Y') THEN
2971: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
2972: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
2973: END IF;

Line 2976: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Stream_Interfaces_Pub.insert_stream_interfaces ');

2972: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
2973: END IF;
2974: IF(IS_DEBUG_PROCEDURE_ON) THEN
2975: BEGIN
2976: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Stream_Interfaces_Pub.insert_stream_interfaces ');
2977: END;
2978: END IF;
2979: Okl_Stream_Interfaces_Pub.insert_stream_interfaces(
2980: p_api_version => p_api_version

Line 2979: Okl_Stream_Interfaces_Pub.insert_stream_interfaces(

2975: BEGIN
2976: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Stream_Interfaces_Pub.insert_stream_interfaces ');
2977: END;
2978: END IF;
2979: Okl_Stream_Interfaces_Pub.insert_stream_interfaces(
2980: p_api_version => p_api_version
2981: ,p_init_msg_list => p_init_msg_list
2982: ,x_return_status => l_return_status
2983: ,x_msg_count => x_msg_count

Line 2989: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to Okl_Stream_Interfaces_Pub.insert_stream_interfaces,return status is :'||l_return_status);

2985: ,p_sifv_rec => lp_sifv_rec
2986: ,x_sifv_rec => lx_sifv_rec);
2987: --Added by kthiruva for Debug Logging
2988: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2989: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to Okl_Stream_Interfaces_Pub.insert_stream_interfaces,return status is :'||l_return_status);
2990: END IF;
2991:
2992: IF(IS_DEBUG_PROCEDURE_ON) THEN
2993: BEGIN

Line 2994: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Stream_Interfaces_Pub.insert_stream_interfaces ');

2990: END IF;
2991:
2992: IF(IS_DEBUG_PROCEDURE_ON) THEN
2993: BEGIN
2994: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Stream_Interfaces_Pub.insert_stream_interfaces ');
2995: END;
2996:
2997: END IF;
2998: -- End of wraper code generated automatically by Debug code generator for Okl_Stream_Interfaces_Pub.insert_stream_interfaces

Line 2998: -- End of wraper code generated automatically by Debug code generator for Okl_Stream_Interfaces_Pub.insert_stream_interfaces

2994: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Stream_Interfaces_Pub.insert_stream_interfaces ');
2995: END;
2996:
2997: END IF;
2998: -- End of wraper code generated automatically by Debug code generator for Okl_Stream_Interfaces_Pub.insert_stream_interfaces
2999: IF l_return_status = G_RET_STS_ERROR THEN
3000: RAISE G_EXCEPTION_ERROR;
3001: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN
3002:

Line 3459: -- Start of wraper code generated automatically by Debug code generator for Okl_Stream_Interfaces_Pub.update_stream_interfaces

3455: --srsreeni Bug5996152 start
3456: -- lp_sifv_rec.sis_code := G_SIS_DATA_ENTERED;
3457: lp_sifv_rec.sis_code := G_SIS_PROCESSING_REQUEST;
3458: --srsreeni Bug5996152 end
3459: -- Start of wraper code generated automatically by Debug code generator for Okl_Stream_Interfaces_Pub.update_stream_interfaces
3460: IF(L_DEBUG_ENABLED='Y') THEN
3461: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
3462: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
3463: END IF;

Line 3466: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Stream_Interfaces_Pub.update_stream_interfaces ');

3462: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
3463: END IF;
3464: IF(IS_DEBUG_PROCEDURE_ON) THEN
3465: BEGIN
3466: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Stream_Interfaces_Pub.update_stream_interfaces ');
3467: END;
3468: END IF;
3469:
3470: Okl_Stream_Interfaces_Pub.update_stream_interfaces(

Line 3470: Okl_Stream_Interfaces_Pub.update_stream_interfaces(

3466: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Stream_Interfaces_Pub.update_stream_interfaces ');
3467: END;
3468: END IF;
3469:
3470: Okl_Stream_Interfaces_Pub.update_stream_interfaces(
3471: p_api_version => p_api_version
3472: ,p_init_msg_list => p_init_msg_list
3473: ,x_return_status => l_return_status
3474: ,x_msg_count => x_msg_count

Line 3482: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Stream_Interfaces_Pub.update_stream_interfaces ');

3478: ,x_sifv_rec => lx_sifv_rec);
3479:
3480: IF(IS_DEBUG_PROCEDURE_ON) THEN
3481: BEGIN
3482: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Stream_Interfaces_Pub.update_stream_interfaces ');
3483: END;
3484: END IF;
3485: -- End of wraper code generated automatically by Debug code generator for Okl_Stream_Interfaces_Pub.update_stream_interfaces
3486: IF l_return_status = G_RET_STS_ERROR THEN

Line 3485: -- End of wraper code generated automatically by Debug code generator for Okl_Stream_Interfaces_Pub.update_stream_interfaces

3481: BEGIN
3482: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Stream_Interfaces_Pub.update_stream_interfaces ');
3483: END;
3484: END IF;
3485: -- End of wraper code generated automatically by Debug code generator for Okl_Stream_Interfaces_Pub.update_stream_interfaces
3486: IF l_return_status = G_RET_STS_ERROR THEN
3487: RAISE G_EXCEPTION_ERROR;
3488: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN
3489: RAISE G_EXCEPTION_UNEXPECTED_ERROR;

Line 3527: -- Start of wraper code generated automatically by Debug code generator for Okl_Stream_Interfaces_Pub.update_stream_interfaces

3523: --srsreeni Bug 5996152 start
3524: /* lp_sifv_rec.date_processed := TO_DATE(TO_CHAR(SYSDATE,'YYYYMMDD
3525: HH24MISS'), 'YYYYMMDD HH24MISS');
3526: lp_sifv_rec.sis_code := G_SIS_PROCESSING_REQUEST;
3527: -- Start of wraper code generated automatically by Debug code generator for Okl_Stream_Interfaces_Pub.update_stream_interfaces
3528: IF(IS_DEBUG_PROCEDURE_ON) THEN
3529: BEGIN
3530: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Stream_Interfaces_Pub.update_stream_interfaces ');
3531: END;

Line 3530: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Stream_Interfaces_Pub.update_stream_interfaces ');

3526: lp_sifv_rec.sis_code := G_SIS_PROCESSING_REQUEST;
3527: -- Start of wraper code generated automatically by Debug code generator for Okl_Stream_Interfaces_Pub.update_stream_interfaces
3528: IF(IS_DEBUG_PROCEDURE_ON) THEN
3529: BEGIN
3530: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Stream_Interfaces_Pub.update_stream_interfaces ');
3531: END;
3532: END IF;
3533:
3534: Okl_Stream_Interfaces_Pub.update_stream_interfaces(

Line 3534: Okl_Stream_Interfaces_Pub.update_stream_interfaces(

3530: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Stream_Interfaces_Pub.update_stream_interfaces ');
3531: END;
3532: END IF;
3533:
3534: Okl_Stream_Interfaces_Pub.update_stream_interfaces(
3535: p_api_version => p_api_version
3536: ,p_init_msg_list => p_init_msg_list
3537: ,x_return_status => l_return_status
3538: ,x_msg_count => x_msg_count

Line 3546: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Stream_Interfaces_Pub.update_stream_interfaces ');

3542: ,x_sifv_rec => lx_sifv_rec);
3543:
3544: IF(IS_DEBUG_PROCEDURE_ON) THEN
3545: BEGIN
3546: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Stream_Interfaces_Pub.update_stream_interfaces ');
3547: END;
3548: END IF;
3549: -- End of wraper code generated automatically by Debug code generator for Okl_Stream_Interfaces_Pub.update_stream_interfaces
3550: IF l_return_status = G_RET_STS_ERROR THEN

Line 3549: -- End of wraper code generated automatically by Debug code generator for Okl_Stream_Interfaces_Pub.update_stream_interfaces

3545: BEGIN
3546: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Stream_Interfaces_Pub.update_stream_interfaces ');
3547: END;
3548: END IF;
3549: -- End of wraper code generated automatically by Debug code generator for Okl_Stream_Interfaces_Pub.update_stream_interfaces
3550: IF l_return_status = G_RET_STS_ERROR THEN
3551:
3552: RAISE G_EXCEPTION_ERROR;
3553: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN

Line 3698: FROM OKL_STREAM_INTERFACES

3694: CURSOR l_okl_sif_status_csr(p_csm_lease_header csm_lease_rec_type) IS
3695: SELECT '1' FROM dual
3696: WHERE EXISTS
3697: (SELECT '1'
3698: FROM OKL_STREAM_INTERFACES
3699: WHERE jtot_object1_code = p_csm_lease_header.jtot_object1_code
3700: AND object1_id1 = p_csm_lease_header.object1_id1
3701: AND SIS_CODE IN (G_SIS_HDR_INSERTED, G_SIS_DATA_ENTERED, G_SIS_PROCESSING_REQUEST)
3702: );

Line 3780: -- Start of wraper code generated automatically by Debug code generator for Okl_Stream_Interfaces_Pub.insert_stream_interfaces

3776: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
3777: END IF;
3778:
3779: -- Insert Transaction Header Data
3780: -- Start of wraper code generated automatically by Debug code generator for Okl_Stream_Interfaces_Pub.insert_stream_interfaces
3781: IF(L_DEBUG_ENABLED='Y') THEN
3782: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
3783: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
3784: END IF;

Line 3787: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Stream_Interfaces_Pub.insert_stream_interfaces ');

3783: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
3784: END IF;
3785: IF(IS_DEBUG_PROCEDURE_ON) THEN
3786: BEGIN
3787: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Stream_Interfaces_Pub.insert_stream_interfaces ');
3788: END;
3789: END IF;
3790: Okl_Stream_Interfaces_Pub.insert_stream_interfaces(
3791: p_api_version => p_api_version

Line 3790: Okl_Stream_Interfaces_Pub.insert_stream_interfaces(

3786: BEGIN
3787: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Stream_Interfaces_Pub.insert_stream_interfaces ');
3788: END;
3789: END IF;
3790: Okl_Stream_Interfaces_Pub.insert_stream_interfaces(
3791: p_api_version => p_api_version
3792: ,p_init_msg_list => p_init_msg_list
3793: ,x_return_status => l_return_status
3794: ,x_msg_count => x_msg_count

Line 3801: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Stream_Interfaces_Pub.insert_stream_interfaces ');

3797:
3798: ,x_sifv_rec => lx_sifv_rec);
3799: IF(IS_DEBUG_PROCEDURE_ON) THEN
3800: BEGIN
3801: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Stream_Interfaces_Pub.insert_stream_interfaces ');
3802: END;
3803: END IF;
3804: -- End of wraper code generated automatically by Debug code generator for Okl_Stream_Interfaces_Pub.insert_stream_interfaces
3805: IF l_return_status = G_RET_STS_ERROR THEN

Line 3804: -- End of wraper code generated automatically by Debug code generator for Okl_Stream_Interfaces_Pub.insert_stream_interfaces

3800: BEGIN
3801: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Stream_Interfaces_Pub.insert_stream_interfaces ');
3802: END;
3803: END IF;
3804: -- End of wraper code generated automatically by Debug code generator for Okl_Stream_Interfaces_Pub.insert_stream_interfaces
3805: IF l_return_status = G_RET_STS_ERROR THEN
3806: RAISE G_EXCEPTION_ERROR;
3807: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN
3808: RAISE G_EXCEPTION_UNEXPECTED_ERROR;

Line 4167: FROM OKL_STREAM_INTERFACES

4163: CURSOR l_okl_sif_restr_status_csr(p_csm_loan_header csm_loan_rec_type) IS
4164: SELECT '1' FROM dual
4165: WHERE EXISTS
4166: (SELECT '1'
4167: FROM OKL_STREAM_INTERFACES
4168: WHERE jtot_object1_code = p_csm_loan_header.jtot_object1_code
4169: AND object1_id1 = p_csm_loan_header.object1_id1
4170: AND SIS_CODE IN (G_SIS_HDR_INSERTED, G_SIS_DATA_ENTERED, G_SIS_PROCESSING_REQUEST)
4171: );

Line 4176: FROM OKL_STREAM_INTERFACES

4172: CURSOR l_okl_sif_quote_status_csr(p_csm_loan_header csm_loan_rec_type) IS
4173: SELECT '1' FROM dual
4174: WHERE EXISTS
4175: (SELECT '1'
4176: FROM OKL_STREAM_INTERFACES
4177: WHERE khr_id = p_csm_loan_header.khr_id
4178:
4179:
4180: AND SIS_CODE IN (G_SIS_HDR_INSERTED, G_SIS_DATA_ENTERED, G_SIS_PROCESSING_REQUEST,G_SIS_RET_DATA_RECEIVED)

Line 4265: -- Start of wraper code generated automatically by Debug code generator for Okl_Stream_Interfaces_Pub.insert_stream_interfaces

4261: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN
4262: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
4263: END IF;
4264: -- Insert Transaction Header Data
4265: -- Start of wraper code generated automatically by Debug code generator for Okl_Stream_Interfaces_Pub.insert_stream_interfaces
4266: IF(L_DEBUG_ENABLED='Y') THEN
4267: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
4268: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
4269: END IF;

Line 4272: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Stream_Interfaces_Pub.insert_stream_interfaces ');

4268: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
4269: END IF;
4270: IF(IS_DEBUG_PROCEDURE_ON) THEN
4271: BEGIN
4272: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Stream_Interfaces_Pub.insert_stream_interfaces ');
4273: END;
4274: END IF;
4275:
4276: Okl_Stream_Interfaces_Pub.insert_stream_interfaces(

Line 4276: Okl_Stream_Interfaces_Pub.insert_stream_interfaces(

4272: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Stream_Interfaces_Pub.insert_stream_interfaces ');
4273: END;
4274: END IF;
4275:
4276: Okl_Stream_Interfaces_Pub.insert_stream_interfaces(
4277: p_api_version => p_api_version
4278: ,p_init_msg_list => p_init_msg_list
4279: ,x_return_status => l_return_status
4280: ,x_msg_count => x_msg_count

Line 4289: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Stream_Interfaces_Pub.insert_stream_interfaces ');

4285: ,x_sifv_rec => lx_sifv_rec);
4286:
4287: IF(IS_DEBUG_PROCEDURE_ON) THEN
4288: BEGIN
4289: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Stream_Interfaces_Pub.insert_stream_interfaces ');
4290: END;
4291: END IF;
4292: -- End of wraper code generated automatically by Debug code generator for Okl_Stream_Interfaces_Pub.insert_stream_interfaces
4293: IF l_return_status = G_RET_STS_ERROR THEN

Line 4292: -- End of wraper code generated automatically by Debug code generator for Okl_Stream_Interfaces_Pub.insert_stream_interfaces

4288: BEGIN
4289: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Stream_Interfaces_Pub.insert_stream_interfaces ');
4290: END;
4291: END IF;
4292: -- End of wraper code generated automatically by Debug code generator for Okl_Stream_Interfaces_Pub.insert_stream_interfaces
4293: IF l_return_status = G_RET_STS_ERROR THEN
4294: RAISE G_EXCEPTION_ERROR;
4295: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN
4296: RAISE G_EXCEPTION_UNEXPECTED_ERROR;

Line 4694: CURSOR l_okl_sif_status_csr(p_khr_id IN OKL_STREAM_INTERFACES_V.KHR_ID%TYPE) IS

4690:
4691: ,x_return_status OUT NOCOPY VARCHAR2
4692: ) RETURN BOOLEAN
4693: IS
4694: CURSOR l_okl_sif_status_csr(p_khr_id IN OKL_STREAM_INTERFACES_V.KHR_ID%TYPE) IS
4695: SELECT '1' FROM dual
4696: WHERE EXISTS
4697: (SELECT '1'
4698: FROM OKL_STREAM_INTERFACES

Line 4698: FROM OKL_STREAM_INTERFACES

4694: CURSOR l_okl_sif_status_csr(p_khr_id IN OKL_STREAM_INTERFACES_V.KHR_ID%TYPE) IS
4695: SELECT '1' FROM dual
4696: WHERE EXISTS
4697: (SELECT '1'
4698: FROM OKL_STREAM_INTERFACES
4699: WHERE khr_id = p_khr_id
4700: AND SIS_CODE IN (G_SIS_HDR_INSERTED, G_SIS_DATA_ENTERED, G_SIS_PROCESSING_REQUEST,G_SIS_RET_DATA_RECEIVED)
4701: );
4702: l_pending BOOLEAN DEFAULT FALSE;

Line 4756: -- Start of wraper code generated automatically by Debug code generator for Okl_Stream_Interfaces_Pub.insert_stream_interfaces

4752: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
4753: END IF;
4754: -- Insert Transaction Header Data
4755:
4756: -- Start of wraper code generated automatically by Debug code generator for Okl_Stream_Interfaces_Pub.insert_stream_interfaces
4757: IF(L_DEBUG_ENABLED='Y') THEN
4758: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
4759: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
4760: END IF;

Line 4764: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Stream_Interfaces_Pub.insert_stream_interfaces ');

4760: END IF;
4761: IF(IS_DEBUG_PROCEDURE_ON) THEN
4762: BEGIN
4763:
4764: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Stream_Interfaces_Pub.insert_stream_interfaces ');
4765: END;
4766: END IF;
4767:
4768: Okl_Stream_Interfaces_Pub.insert_stream_interfaces(

Line 4768: Okl_Stream_Interfaces_Pub.insert_stream_interfaces(

4764: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Stream_Interfaces_Pub.insert_stream_interfaces ');
4765: END;
4766: END IF;
4767:
4768: Okl_Stream_Interfaces_Pub.insert_stream_interfaces(
4769: p_api_version => p_api_version
4770: ,p_init_msg_list => p_init_msg_list
4771: ,x_return_status => l_return_status
4772: ,x_msg_count => x_msg_count

Line 4779: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Stream_Interfaces_Pub.insert_stream_interfaces ');

4775: ,p_sifv_rec => lp_sifv_rec
4776: ,x_sifv_rec => lx_sifv_rec);
4777: IF(IS_DEBUG_PROCEDURE_ON) THEN
4778: BEGIN
4779: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Stream_Interfaces_Pub.insert_stream_interfaces ');
4780: END;
4781: END IF;
4782: -- End of wraper code generated automatically by Debug code generator for Okl_Stream_Interfaces_Pub.insert_stream_interfaces
4783: IF l_return_status = G_RET_STS_ERROR THEN

Line 4782: -- End of wraper code generated automatically by Debug code generator for Okl_Stream_Interfaces_Pub.insert_stream_interfaces

4778: BEGIN
4779: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Stream_Interfaces_Pub.insert_stream_interfaces ');
4780: END;
4781: END IF;
4782: -- End of wraper code generated automatically by Debug code generator for Okl_Stream_Interfaces_Pub.insert_stream_interfaces
4783: IF l_return_status = G_RET_STS_ERROR THEN
4784: RAISE G_EXCEPTION_ERROR;
4785: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN
4786: