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_SUBSIDY_POOL_AUTH_TRX_PVT dependencies on FND_LOG

Line 66: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_AUTH_TRX_PVT.POOL_TRX_KHR_RBK';

62: x_msg_count NUMBER;
63: l_api_version CONSTANT NUMBER DEFAULT '1.0';
64: x_msg_data VARCHAR2(100);
65:
66: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_AUTH_TRX_PVT.POOL_TRX_KHR_RBK';
67: l_debug_enabled VARCHAR2(10);
68: is_debug_statement_on BOOLEAN;
69:
70: BEGIN

Line 75: is_debug_statement_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);

71: x_return_status := OKL_API.G_RET_STS_SUCCESS;
72:
73: l_debug_enabled := okl_debug_pub.check_log_enabled;
74: -- check for logging on STATEMENT level
75: is_debug_statement_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);
76:
77: lv_six_tbl := p_six_tbl;
78: idx := 0;
79: total_num_recs := p_six_tbl.COUNT;

Line 100: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

96: -- assign the source trx date to the date of the rebook
97: lv_six_tbl(idx).source_trx_date := p_source_trx_date;
98: -- write to log
99: IF(NVL(l_debug_enabled,'N')='Y' AND is_debug_statement_on) THEN
100: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
101: l_module,
102: idx||' source trx date check passed for subsidy '||lv_six_tbl(idx).subsidy_id
103: );
104: END IF; -- end of NVL(l_debug_enabled,'N')='Y' AND is_debug_statement_on

Line 111: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

107: -- this validation ensures that we are not adding back to the pool balance without ever reducing from it
108: -- in ideal scenarios, this check never fails, but this check is essential to stop data corruption
109: IF(lv_six_tbl(idx).trx_type_code = 'ADDITION' AND x_return_status = OKL_API.G_RET_STS_SUCCESS)THEN
110: IF(NVL(l_debug_enabled,'N')='Y' AND is_debug_statement_on) THEN
111: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
112: l_module,
113: ' finding trx for pool '||lv_six_tbl(idx).subsidy_pool_id || ' lv_six_tbl(idx).source_object_id '||lv_six_tbl(idx).source_object_id
114: ||' lv_six_tbl(idx).vendor_id '||lv_six_tbl(idx).vendor_id||' lv_six_tbl(idx).dnz_asset_number '||lv_six_tbl(idx).dnz_asset_number
115: ||' lv_six_tbl(idx).subsidy_id '||lv_six_tbl(idx).subsidy_id ||' lv_six_tbl(idx).subsidy_pool_currency_code '||lv_six_tbl(idx).subsidy_pool_currency_code

Line 143: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

139: lv_six_tbl(idx).subsidy_pool_amount := cv_get_pool_trx_details.subsidy_pool_amount;
140: lv_six_tbl(idx).conversion_rate := cv_get_pool_trx_details.conversion_rate;
141: -- write to log
142: IF(NVL(l_debug_enabled,'N')='Y' AND is_debug_statement_on) THEN
143: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
144: l_module,
145: idx||' found trx for pool '||lv_six_tbl(idx).subsidy_pool_id || ' lv_six_tbl(idx).source_object_id '||lv_six_tbl(idx).source_object_id
146: ||' lv_six_tbl(idx).vendor_id '||lv_six_tbl(idx).vendor_id||' lv_six_tbl(idx).dnz_asset_number '||lv_six_tbl(idx).dnz_asset_number
147: ||' lv_six_tbl(idx).subsidy_id '||lv_six_tbl(idx).subsidy_id

Line 227: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_AUTH_TRX_PVT.REDUCE_POOL_BALANCE';

223: x_msg_count NUMBER;
224: l_api_version CONSTANT NUMBER DEFAULT 1.0;
225: x_msg_data VARCHAR2(1000);
226:
227: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_AUTH_TRX_PVT.REDUCE_POOL_BALANCE';
228: l_debug_enabled VARCHAR2(10);
229: is_debug_statement_on BOOLEAN;
230:
231: BEGIN

Line 234: is_debug_statement_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);

230:
231: BEGIN
232: l_debug_enabled := okl_debug_pub.check_log_enabled;
233: -- check for logging on STATEMENT level
234: is_debug_statement_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);
235:
236: IF(NVL(l_debug_enabled,'N')='Y' AND is_debug_statement_on) THEN
237: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
238: l_module,

Line 237: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

233: -- check for logging on STATEMENT level
234: is_debug_statement_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);
235:
236: IF(NVL(l_debug_enabled,'N')='Y' AND is_debug_statement_on) THEN
237: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
238: l_module,
239: 'inside local procedure reduce_pool_balance '||p_khr_id
240: );
241: END IF; -- end of NVL(l_debug_enabled,'N')='Y' AND is_debug_statement_on

Line 251: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

247: lv_six_tbl.DELETE; lx_six_tbl.DELETE;
248: idx := 0;
249:
250: IF(NVL(l_debug_enabled,'N')='Y' AND is_debug_statement_on) THEN
251: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
252: l_module,
253: 'before processing REDUCTION records '||p_khr_id
254: );
255: END IF; -- end of NVL(l_debug_enabled,'N')='Y' AND is_debug_statement_on

Line 287: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

283: END LOOP;
284: -- now check the length of the table lv_sixv_tbl and then call the okl_subsidy_pool_trx_pvt api to create ADDITION transactions
285: IF(lv_six_tbl.COUNT > 0)THEN
286: IF(NVL(l_debug_enabled,'N')='Y' AND is_debug_statement_on) THEN
287: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
288: l_module,
289: lv_six_tbl.COUNT||' records found for reversing from the contract '||p_khr_id || ' p_source_trx_date '|| p_source_trx_date
290: );
291: END IF; -- end of NVL(l_debug_enabled,'N')='Y' AND is_debug_statement_on

Line 302: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

298: ,p_sixv_tbl => lv_six_tbl
299: ,x_sixv_tbl => lx_six_tbl
300: );
301: IF(NVL(l_debug_enabled,'N')='Y' AND is_debug_statement_on) THEN
302: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
303: l_module,
304: 'okl_subsidy_pool_trx_pvt.create_pool_transaction from reduce_pool_balance returned with status '||x_return_status
305: ||' x_msg_data '||x_msg_data
306: );

Line 362: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_AUTH_TRX_PVT.CREATE_POOL_TRX_KHR_BOOK';

358: lv_sixv_rec sixv_rec_type;
359: lx_sixv_rec sixv_rec_type;
360: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'POOL_TRX_KHR_BOOK';
361:
362: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_AUTH_TRX_PVT.CREATE_POOL_TRX_KHR_BOOK';
363: l_debug_enabled VARCHAR2(10);
364: is_debug_procedure_on BOOLEAN;
365: is_debug_statement_on BOOLEAN;
366:

Line 372: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);

368:
369: x_return_status := OKL_API.G_RET_STS_SUCCESS;
370:
371: l_debug_enabled := okl_debug_pub.check_log_enabled;
372: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
373: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
374: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRSIUB.pls call create_pool_trx_khr_book');
375: END IF;
376:

Line 374: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRSIUB.pls call create_pool_trx_khr_book');

370:
371: l_debug_enabled := okl_debug_pub.check_log_enabled;
372: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
373: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
374: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRSIUB.pls call create_pool_trx_khr_book');
375: END IF;
376:
377: -- Call start_activity to create savepoint, check compatibility and initialize message list
378: x_return_status := OKL_API.START_ACTIVITY (

Line 391: is_debug_statement_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);

387: RAISE OKL_API.G_EXCEPTION_ERROR;
388: END IF;
389:
390: -- check for logging on STATEMENT level
391: is_debug_statement_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);
392:
393: -- populate all the attributes that are necessary for the subsidy pool transaction record
394: lv_sixv_rec.source_object_id := p_chr_id;
395: lv_sixv_rec.subsidy_id := p_subsidy_id;

Line 422: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

418: lv_sixv_rec.source_type_code := G_TRX_SOURCE_TYPE_CODE;
419:
420: -- write to log
421: IF(NVL(l_debug_enabled,'N')='Y' AND is_debug_statement_on) THEN
422: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
423: l_module,
424: 'lv_sixv_rec.source_object_id '||lv_sixv_rec.source_object_id || ' lv_sixv_rec.subsidy_id '||lv_sixv_rec.subsidy_id ||
425: ' lv_sixv_rec.subsidy_pool_id '||lv_sixv_rec.subsidy_pool_id ||' lv_sixv_rec.dnz_asset_number '||lv_sixv_rec.dnz_asset_number||
426: ' lv_sixv_rec.source_trx_date '||lv_sixv_rec.source_trx_date ||' lv_sixv_rec.trx_amount '||lv_sixv_rec.trx_amount||

Line 450: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

446: ,p_contract_id => p_chr_id
447: );
448: -- write to log
449: IF(NVL(l_debug_enabled,'N')='Y' AND is_debug_statement_on) THEN
450: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
451: l_module,
452: 'OKL_LEASE_QUOTE_SUBPOOL_PVT.process_active_contract with status '||x_return_status||' x_msg_data '||x_msg_data
453: );
454: END IF; -- end of NVL(l_debug_enabled,'N')='Y' AND is_debug_statement_on

Line 489: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

485: ,x_sixv_rec => lx_sixv_rec
486: );
487: -- write to log
488: IF(NVL(l_debug_enabled,'N')='Y' AND is_debug_statement_on) THEN
489: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
490: l_module,
491: 'OKL_SUBSIDY_POOL_TRX_PVT.create_pool_transaction with status '||x_return_status||' x_msg_data '||x_msg_data
492: );
493: END IF; -- end of NVL(l_debug_enabled,'N')='Y' AND is_debug_statement_on

Line 513: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRSIUB.pls call create_pool_trx_khr_book');

509:
510: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
511:
512: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
513: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRSIUB.pls call create_pool_trx_khr_book');
514: END IF;
515:
516: EXCEPTION
517: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 622: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_AUTH_TRX_PVT.CREATE_POOL_TRX_KHR_REVERSE';

618: idx PLS_INTEGER;
619: l_sub_pool_applicable VARCHAR2(10);
620: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'POOL_TRX_KHR_REVERSE';
621:
622: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_AUTH_TRX_PVT.CREATE_POOL_TRX_KHR_REVERSE';
623: l_debug_enabled VARCHAR2(10);
624: is_debug_procedure_on BOOLEAN;
625: is_debug_statement_on BOOLEAN;
626:

Line 631: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);

627: BEGIN
628: x_return_status := OKL_API.G_RET_STS_SUCCESS;
629:
630: l_debug_enabled := okl_debug_pub.check_log_enabled;
631: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
632: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
633: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRSIUB.pls call create_pool_trx_khr_reverse');
634: END IF;
635:

Line 633: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRSIUB.pls call create_pool_trx_khr_reverse');

629:
630: l_debug_enabled := okl_debug_pub.check_log_enabled;
631: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
632: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
633: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRSIUB.pls call create_pool_trx_khr_reverse');
634: END IF;
635:
636: -- Call start_activity to create savepoint, check compatibility and initialize message list
637: x_return_status := OKL_API.START_ACTIVITY (

Line 650: is_debug_statement_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);

646: RAISE OKL_API.G_EXCEPTION_ERROR;
647: END IF;
648:
649: -- check for logging on STATEMENT level
650: is_debug_statement_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);
651:
652: idx := 0; lv_sixv_tbl.DELETE; lx_sixv_tbl.DELETE;
653: -- loop for all subsidies and process for subsidy pool transaction reversal
654: FOR c_subsidy_csr_rec IN c_subsidy_csr(cp_chr_id => p_chr_id) LOOP

Line 712: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

708: lv_sixv_tbl(idx).conversion_rate := cv_sub_pool_trx_rec.conversion_rate;
709:
710: -- write to log
711: IF(NVL(l_debug_enabled,'N')='Y' AND is_debug_statement_on) THEN
712: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
713: l_module,
714: idx ||' record processed for '||lv_sixv_tbl(idx).trx_type_code||' lv_sixv_tbl(idx).trx_reason_code '||lv_sixv_tbl(idx).trx_reason_code
715: );
716: END IF; -- end of NVL(l_debug_enabled,'N')='Y' AND is_debug_statement_on

Line 723: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

719: ELSE
720: -- case of subsidy is a stand alone subsidy
721: -- write to log
722: IF(NVL(l_debug_enabled,'N')='Y' AND is_debug_statement_on) THEN
723: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
724: l_module,
725: 'c_subsidy_csr_rec.subsidy_id '||c_subsidy_csr_rec.subsidy_id||' l_sub_pool_applicable '||l_sub_pool_applicable
726: );
727: END IF; -- end of NVL(l_debug_enabled,'N')='Y' AND is_debug_statement_on

Line 742: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

738: ,p_sixv_tbl => lv_sixv_tbl
739: ,x_sixv_tbl => lx_sixv_tbl
740: );
741: IF(NVL(l_debug_enabled,'N')='Y' AND is_debug_statement_on) THEN
742: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
743: l_module,
744: 'okl_subsidy_pool_trx_pvt.create_pool_transaction with status '||x_return_status || ' x_msg_data '||x_msg_data
745: );
746: END IF; -- end of NVL(l_debug_enabled,'N')='Y' AND is_debug_statement_on

Line 755: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRSIUB.pls call create_pool_trx_khr_reverse');

751: END IF;
752: END IF;
753:
754: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
755: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRSIUB.pls call create_pool_trx_khr_reverse');
756: END IF;
757:
758: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
759:

Line 993: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_AUTH_TRX_PVT.CREATE_POOL_TRX_KHR_RBK';

989: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'POOL_TRX_KHR_RBK';
990: lv_six_tbl sixv_tbl_type;
991: lx_six_tbl sixv_tbl_type;
992:
993: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_AUTH_TRX_PVT.CREATE_POOL_TRX_KHR_RBK';
994: l_debug_enabled VARCHAR2(10);
995: is_debug_procedure_on BOOLEAN;
996: is_debug_statement_on BOOLEAN;
997:

Line 1002: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);

998: BEGIN
999: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1000:
1001: l_debug_enabled := okl_debug_pub.check_log_enabled;
1002: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
1003: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
1004: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRSIUB.pls call create_pool_trx_khr_rbk');
1005: END IF;
1006:

Line 1004: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRSIUB.pls call create_pool_trx_khr_rbk');

1000:
1001: l_debug_enabled := okl_debug_pub.check_log_enabled;
1002: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
1003: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
1004: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRSIUB.pls call create_pool_trx_khr_rbk');
1005: END IF;
1006:
1007: -- Call start_activity to create savepoint, check compatibility and initialize message list
1008: x_return_status := OKL_API.START_ACTIVITY(l_api_name,p_init_msg_list,'_PVT',x_return_status);

Line 1017: is_debug_statement_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);

1013: RAISE OKL_API.G_EXCEPTION_ERROR;
1014: END IF;
1015:
1016: -- check for logging on STATEMENT level
1017: is_debug_statement_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);
1018:
1019: -- initialize the counter. this is done only once for the complete pool transaction synchronization
1020: idx := 0;
1021: -- initialize the plsql table

Line 1062: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

1058: CLOSE c_get_asst_number;
1059: lv_six_tbl(idx).dnz_asset_number := lv_asset_number;
1060: -- write to log
1061: IF(NVL(l_debug_enabled,'N')='Y' AND is_debug_statement_on) THEN
1062: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
1063: l_module,
1064: 'synch ADD lv_six_tbl('||idx||').source_object_id'||lv_six_tbl(idx).source_object_id||
1065: ' subsidy_pool_id '||lx_subsidy_pool_id||' vendor_id '||lv_six_tbl(idx).vendor_id||
1066: ' subsidy_id '||l_subelm_orig_rec.subsidy_id||' trx_amount '||lv_six_tbl(idx).trx_amount||

Line 1098: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

1094: CLOSE c_get_asst_number;
1095: lv_six_tbl(idx).dnz_asset_number := lv_asset_number;
1096: -- write to log
1097: IF(NVL(l_debug_enabled,'N')='Y' AND is_debug_statement_on) THEN
1098: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
1099: l_module,
1100: 'synch REDUCE lv_six_tbl('||idx||').source_object_id'||lv_six_tbl(idx).source_object_id||
1101: ' subsidy_pool_id '||lx_subsidy_pool_id||' vendor_id '||lv_six_tbl(idx).vendor_id||
1102: ' subsidy_id '||lv_six_tbl(idx).subsidy_id||' trx_amount '||lv_six_tbl(idx).trx_amount||

Line 1138: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

1134: lv_six_tbl(idx).dnz_asset_number := lv_asset_number;
1135:
1136: -- write to log
1137: IF(NVL(l_debug_enabled,'N')='Y' AND is_debug_statement_on) THEN
1138: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
1139: l_module,
1140: 'synch ADD for deleted subsidy lv_six_tbl('||idx||').source_object_id'||lv_six_tbl(idx).source_object_id||
1141: ' subsidy_pool_id '||lx_subsidy_pool_id||' vendor_id '||lv_six_tbl(idx).vendor_id||
1142: ' subsidy_id '||lv_six_tbl(idx).subsidy_id||' trx_amount '||lv_six_tbl(idx).trx_amount||

Line 1177: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

1173: lv_six_tbl(idx).dnz_asset_number := lv_asset_number;
1174:
1175: -- write to log
1176: IF(NVL(l_debug_enabled,'N')='Y' AND is_debug_statement_on) THEN
1177: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
1178: l_module,
1179: 'synch REDUCE for new subsidy lv_six_tbl('||idx||').source_object_id'||lv_six_tbl(idx).source_object_id||
1180: ' subsidy_pool_id '||lx_subsidy_pool_id||' vendor_id '||lv_six_tbl(idx).vendor_id||
1181: ' subsidy_id '||lv_six_tbl(idx).subsidy_id||' trx_amount '||lv_six_tbl(idx).trx_amount||

Line 1197: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

1193: -- call local procedure that populates other parameters and then calls the okl_subsidy_pool_trx_pvt.create_pool_transaction
1194: pool_trx_khr_rbk(p_source_trx_date => lv_source_trx_date, p_six_tbl => lv_six_tbl, x_return_status => x_return_status);
1195: -- write to log
1196: IF(NVL(l_debug_enabled,'N')='Y' AND is_debug_statement_on) THEN
1197: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
1198: l_module,
1199: 'pool_trx_khr_rbk returned with status '||x_return_status || ' x_msg_data '||x_msg_data
1200: );
1201: END IF; -- end of NVL(l_debug_enabled,'N')='Y' AND is_debug_statement_on

Line 1211: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRSIUB.pls call create_pool_trx_khr_rbk');

1207: END IF;
1208: END IF;
1209:
1210: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
1211: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRSIUB.pls call create_pool_trx_khr_rbk');
1212: END IF;
1213:
1214: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
1215: EXCEPTION

Line 1276: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_AUTH_TRX_PVT.CREATE_POOL_TRX_KHR_SPLIT';

1272: cv_split_info_rec c_split_info_csr%ROWTYPE;
1273:
1274: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'POOL_TRX_KHR_SPLIT';
1275:
1276: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_AUTH_TRX_PVT.CREATE_POOL_TRX_KHR_SPLIT';
1277: l_debug_enabled VARCHAR2(10);
1278: is_debug_procedure_on BOOLEAN;
1279: is_debug_statement_on BOOLEAN;
1280:

Line 1285: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);

1281: BEGIN
1282: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1283:
1284: l_debug_enabled := okl_debug_pub.check_log_enabled;
1285: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
1286: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
1287: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRSIUB.pls call create_pool_trx_khr_split');
1288: END IF;
1289:

Line 1287: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRSIUB.pls call create_pool_trx_khr_split');

1283:
1284: l_debug_enabled := okl_debug_pub.check_log_enabled;
1285: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
1286: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
1287: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRSIUB.pls call create_pool_trx_khr_split');
1288: END IF;
1289:
1290: -- Call start_activity to create savepoint, check compatibility and initialize message list
1291: x_return_status := OKL_API.START_ACTIVITY(l_api_name,p_init_msg_list,'_PVT',x_return_status);

Line 1300: is_debug_statement_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);

1296: RAISE OKL_API.G_EXCEPTION_ERROR;
1297: END IF;
1298:
1299: -- check for logging on STATEMENT level
1300: is_debug_statement_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);
1301:
1302: -- derive the original contract information from the first split contract
1303: lv_orig_khr_id := NULL;
1304: OPEN c_get_orig_khr_csr(cp_chr_id => p_new1_chr_id); FETCH c_get_orig_khr_csr INTO lv_orig_khr_id;

Line 1313: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

1309: CLOSE c_split_info_csr;
1310:
1311: -- write to log
1312: IF(NVL(l_debug_enabled,'N')='Y' AND is_debug_statement_on) THEN
1313: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
1314: l_module,
1315: 'first split copy khr '||lv_orig_khr_id||' cv_split_info_rec.contract_number '||
1316: cv_split_info_rec.contract_number||' cv_split_info_rec.date_transaction_occurred '||
1317: cv_split_info_rec.date_transaction_occurred

Line 1337: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

1333: ,p_override_trx_reason => G_CONTRACT_SPLIT_CODE
1334: );
1335: -- write to log
1336: IF(NVL(l_debug_enabled,'N')='Y' AND is_debug_statement_on) THEN
1337: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
1338: l_module,
1339: 'create_pool_trx_khr_reverse called from create_pool_trx_khr_split return status '||x_return_status || ' x_msg_data '||x_msg_data
1340: );
1341: END IF; -- end of NVL(l_debug_enabled,'N')='Y' AND is_debug_statement_on

Line 1351: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

1347: END IF;
1348:
1349: -- write to log
1350: IF(NVL(l_debug_enabled,'N')='Y' AND is_debug_statement_on) THEN
1351: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
1352: l_module,
1353: 'now reducing pool balance from the first split copy contract '||p_new1_chr_id||' '||trunc(cv_split_info_rec.date_transaction_occurred)
1354: );
1355: END IF; -- end of NVL(l_debug_enabled,'N')='Y' AND is_debug_statement_on

Line 1364: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

1360: ,p_source_trx_date => trunc(cv_split_info_rec.date_transaction_occurred)
1361: ,x_return_status => x_return_status);
1362: -- write to log
1363: IF(NVL(l_debug_enabled,'N')='Y' AND is_debug_statement_on) THEN
1364: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
1365: l_module,
1366: 'reduce pool balance from first contract api return status '||x_return_status||' x_msg_data '||x_msg_data
1367: );
1368: END IF; -- end of NVL(l_debug_enabled,'N')='Y' AND is_debug_statement_on

Line 1383: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

1379: ,p_source_trx_date => trunc(cv_split_info_rec.date_transaction_occurred)
1380: ,x_return_status => x_return_status);
1381: -- write to log
1382: IF(NVL(l_debug_enabled,'N')='Y' AND is_debug_statement_on) THEN
1383: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
1384: l_module,
1385: 'reduce pool balance from second contract api return status '||x_return_status|| ' x_msg_data '||x_msg_data
1386: );
1387: END IF; -- end of NVL(l_debug_enabled,'N')='Y' AND is_debug_statement_on

Line 1396: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRSIUB.pls call create_pool_trx_khr_split');

1392: RAISE OKL_API.G_EXCEPTION_ERROR;
1393: END IF;
1394:
1395: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
1396: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRSIUB.pls call create_pool_trx_khr_split');
1397: END IF;
1398:
1399: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
1400: EXCEPTION