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.OKS_BILL_UTIL_PUB dependencies on FND_LOG

Line 4456: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN

4452: );
4453:
4454:
4455:
4456: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
4457: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.ADJUST_SPLIT_BILL_REC.create_bsl',
4458: 'oks_billsubline_pub.insert_bill_subline_pub(x_return_status = '||x_return_status
4459: ||', bsl id = '|| L_BSLV_REC_OUT.id ||')');
4460: END IF;

Line 4457: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.ADJUST_SPLIT_BILL_REC.create_bsl',

4453:
4454:
4455:
4456: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
4457: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.ADJUST_SPLIT_BILL_REC.create_bsl',
4458: 'oks_billsubline_pub.insert_bill_subline_pub(x_return_status = '||x_return_status
4459: ||', bsl id = '|| L_BSLV_REC_OUT.id ||')');
4460: END IF;
4461:

Line 4471: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN

4467: UPDATE oks_bill_sub_lines
4468: SET amount = nvl(amount,0) - nvl(p_new_cp_lvl_tbl(l_index).amount, 0)
4469: WHERE id = l_bsl_rec.id;
4470:
4471: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
4472: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.ADJUST_SPLIT_BILL_REC.update_bsl',
4473: 'update_old_bsl_amt id = ' || l_bsl_rec.id
4474: );
4475: END IF;

Line 4472: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.ADJUST_SPLIT_BILL_REC.update_bsl',

4468: SET amount = nvl(amount,0) - nvl(p_new_cp_lvl_tbl(l_index).amount, 0)
4469: WHERE id = l_bsl_rec.id;
4470:
4471: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
4472: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.ADJUST_SPLIT_BILL_REC.update_bsl',
4473: 'update_old_bsl_amt id = ' || l_bsl_rec.id
4474: );
4475: END IF;
4476:

Line 4531: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN

4527: p_bsdv_tbl => l_bsdv_tbl_in,
4528: x_bsdv_tbl => l_bsdv_tbl_out
4529: );
4530:
4531: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
4532: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.ADJUST_SPLIT_BILL_REC.create_bsd',
4533: 'OKS_BSL_det_PUB.insert_bsl_det_Pub(x_return_status = '||x_return_status
4534: ||', bsd id = '|| l_bsdv_tbl_out(1).id ||')');
4535: END IF;

Line 4532: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.ADJUST_SPLIT_BILL_REC.create_bsd',

4528: x_bsdv_tbl => l_bsdv_tbl_out
4529: );
4530:
4531: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
4532: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.ADJUST_SPLIT_BILL_REC.create_bsd',
4533: 'OKS_BSL_det_PUB.insert_bsl_det_Pub(x_return_status = '||x_return_status
4534: ||', bsd id = '|| l_bsdv_tbl_out(1).id ||')');
4535: END IF;
4536:

Line 4546: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN

4542: UPDATE oks_bill_sub_line_dtls
4543: set amount = nvl(amount,0) - p_new_cp_lvl_tbl(l_index).amount
4544: where id = l_bsd_rec.id;
4545:
4546: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
4547: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.ADJUST_SPLIT_BILL_REC.update_bsl',
4548: 'update_old_bsd_amt id = ' || l_bsd_rec.id
4549: );
4550: END IF;

Line 4547: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.ADJUST_SPLIT_BILL_REC.update_bsl',

4543: set amount = nvl(amount,0) - p_new_cp_lvl_tbl(l_index).amount
4544: where id = l_bsd_rec.id;
4545:
4546: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
4547: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.ADJUST_SPLIT_BILL_REC.update_bsl',
4548: 'update_old_bsd_amt id = ' || l_bsd_rec.id
4549: );
4550: END IF;
4551:

Line 4629: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN

4625: p_btlv_tbl => l_btlv_tbl_in,
4626: x_btlv_tbl => l_btlv_tbl_out
4627: );
4628:
4629: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
4630: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.ADJUST_SPLIT_BILL_REC.create_btl',
4631: 'OKS_BILLTRAN_LINE_PUB.insert_Bill_Tran_Line_Pub(x_return_status = '||x_return_status
4632: ||', btl id = '|| l_btlv_tbl_out(1).id ||')');
4633: END IF;

Line 4630: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.ADJUST_SPLIT_BILL_REC.create_btl',

4626: x_btlv_tbl => l_btlv_tbl_out
4627: );
4628:
4629: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
4630: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.ADJUST_SPLIT_BILL_REC.create_btl',
4631: 'OKS_BILLTRAN_LINE_PUB.insert_Bill_Tran_Line_Pub(x_return_status = '||x_return_status
4632: ||', btl id = '|| l_btlv_tbl_out(1).id ||')');
4633: END IF;
4634:

Line 4655: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN

4651: trx_line_amount = NVL(l_btl_rec.trx_amount,0) - NVL(l_btlv_tbl_in(1).trx_amount,0)
4652: WHERE id = l_btl_rec.id;
4653: END IF; ----chk for split_flag IS NULL
4654:
4655: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
4656: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.ADJUST_SPLIT_BILL_REC.update_btl',
4657: 'update_old_btl_amt id = ' || l_btl_rec.id
4658: );
4659: END IF;

Line 4656: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.ADJUST_SPLIT_BILL_REC.update_btl',

4652: WHERE id = l_btl_rec.id;
4653: END IF; ----chk for split_flag IS NULL
4654:
4655: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
4656: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.ADJUST_SPLIT_BILL_REC.update_btl',
4657: 'update_old_btl_amt id = ' || l_btl_rec.id
4658: );
4659: END IF;
4660:

Line 4675: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN

4671: SET date_completed = SYSDATE
4672: WHERE TRUNC(date_start) <= TRUNC(l_max_billed_dt)
4673: AND cle_id =p_new_cp_id ;
4674:
4675: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
4676: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.ADJUST_SPLIT_BILL_REC.update_lvl_new',
4677: 'update date_completed of new cp level elements up to date = ' || l_max_billed_dt
4678: );
4679: END IF;

Line 4676: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.ADJUST_SPLIT_BILL_REC.update_lvl_new',

4672: WHERE TRUNC(date_start) <= TRUNC(l_max_billed_dt)
4673: AND cle_id =p_new_cp_id ;
4674:
4675: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
4676: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.ADJUST_SPLIT_BILL_REC.update_lvl_new',
4677: 'update date_completed of new cp level elements up to date = ' || l_max_billed_dt
4678: );
4679: END IF;
4680:

Line 4688: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN

4684:
4685: EXCEPTION
4686:
4687: WHEN OTHERS THEN
4688: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN
4689: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.Adjust_billed_lvl_element.UNEXPECTED',
4690: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
4691: END IF;
4692:

Line 4689: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.Adjust_billed_lvl_element.UNEXPECTED',

4685: EXCEPTION
4686:
4687: WHEN OTHERS THEN
4688: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN
4689: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.Adjust_billed_lvl_element.UNEXPECTED',
4690: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
4691: END IF;
4692:
4693: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,