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 469: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN

465: EXCEPTION
466:
467: WHEN item_not_found_error THEN
468: /* Added for Bug#13078136*/
469: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
470: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.get_seeded_timeunit.item_not_found_error',
471: 'time_code_unit: '|| p_timeunit || ' is inactive or does not exist');
472: END IF;
473: /* End of Code added for Bug#13078136*/

Line 470: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.get_seeded_timeunit.item_not_found_error',

466:
467: WHEN item_not_found_error THEN
468: /* Added for Bug#13078136*/
469: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
470: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.get_seeded_timeunit.item_not_found_error',
471: 'time_code_unit: '|| p_timeunit || ' is inactive or does not exist');
472: END IF;
473: /* End of Code added for Bug#13078136*/
474: x_return_status := OKC_API.G_RET_STS_ERROR;

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

4946: );
4947:
4948:
4949:
4950: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
4951: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.ADJUST_SPLIT_BILL_REC.create_bsl',
4952: 'oks_billsubline_pub.insert_bill_subline_pub(x_return_status = '||x_return_status
4953: ||', bsl id = '|| L_BSLV_REC_OUT.id ||')');
4954: END IF;

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

4947:
4948:
4949:
4950: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
4951: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.ADJUST_SPLIT_BILL_REC.create_bsl',
4952: 'oks_billsubline_pub.insert_bill_subline_pub(x_return_status = '||x_return_status
4953: ||', bsl id = '|| L_BSLV_REC_OUT.id ||')');
4954: END IF;
4955:

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

4961: UPDATE oks_bill_sub_lines
4962: SET amount = nvl(amount,0) - nvl(p_new_cp_lvl_tbl(l_index).amount, 0)
4963: WHERE id = l_bsl_rec.id;
4964:
4965: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
4966: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.ADJUST_SPLIT_BILL_REC.update_bsl',
4967: 'update_old_bsl_amt id = ' || l_bsl_rec.id
4968: );
4969: END IF;

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

4962: SET amount = nvl(amount,0) - nvl(p_new_cp_lvl_tbl(l_index).amount, 0)
4963: WHERE id = l_bsl_rec.id;
4964:
4965: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
4966: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.ADJUST_SPLIT_BILL_REC.update_bsl',
4967: 'update_old_bsl_amt id = ' || l_bsl_rec.id
4968: );
4969: END IF;
4970:

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

5021: p_bsdv_tbl => l_bsdv_tbl_in,
5022: x_bsdv_tbl => l_bsdv_tbl_out
5023: );
5024:
5025: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
5026: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.ADJUST_SPLIT_BILL_REC.create_bsd',
5027: 'OKS_BSL_det_PUB.insert_bsl_det_Pub(x_return_status = '||x_return_status
5028: ||', bsd id = '|| l_bsdv_tbl_out(1).id ||')');
5029: END IF;

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

5022: x_bsdv_tbl => l_bsdv_tbl_out
5023: );
5024:
5025: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
5026: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.ADJUST_SPLIT_BILL_REC.create_bsd',
5027: 'OKS_BSL_det_PUB.insert_bsl_det_Pub(x_return_status = '||x_return_status
5028: ||', bsd id = '|| l_bsdv_tbl_out(1).id ||')');
5029: END IF;
5030:

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

5036: UPDATE oks_bill_sub_line_dtls
5037: set amount = nvl(amount,0) - p_new_cp_lvl_tbl(l_index).amount
5038: where id = l_bsd_rec.id;
5039:
5040: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
5041: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.ADJUST_SPLIT_BILL_REC.update_bsl',
5042: 'update_old_bsd_amt id = ' || l_bsd_rec.id
5043: );
5044: END IF;

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

5037: set amount = nvl(amount,0) - p_new_cp_lvl_tbl(l_index).amount
5038: where id = l_bsd_rec.id;
5039:
5040: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
5041: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.ADJUST_SPLIT_BILL_REC.update_bsl',
5042: 'update_old_bsd_amt id = ' || l_bsd_rec.id
5043: );
5044: END IF;
5045:

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

5119: p_btlv_tbl => l_btlv_tbl_in,
5120: x_btlv_tbl => l_btlv_tbl_out
5121: );
5122:
5123: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
5124: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.ADJUST_SPLIT_BILL_REC.create_btl',
5125: 'OKS_BILLTRAN_LINE_PUB.insert_Bill_Tran_Line_Pub(x_return_status = '||x_return_status
5126: ||', btl id = '|| l_btlv_tbl_out(1).id ||')');
5127: END IF;

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

5120: x_btlv_tbl => l_btlv_tbl_out
5121: );
5122:
5123: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
5124: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.ADJUST_SPLIT_BILL_REC.create_btl',
5125: 'OKS_BILLTRAN_LINE_PUB.insert_Bill_Tran_Line_Pub(x_return_status = '||x_return_status
5126: ||', btl id = '|| l_btlv_tbl_out(1).id ||')');
5127: END IF;
5128:

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

5145: trx_line_amount = NVL(l_btl_rec.trx_amount,0) - NVL(l_btlv_tbl_in(1).trx_amount,0)
5146: WHERE id = l_btl_rec.id;
5147: END IF; ----chk for split_flag IS NULL
5148:
5149: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
5150: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.ADJUST_SPLIT_BILL_REC.update_btl',
5151: 'update_old_btl_amt id = ' || l_btl_rec.id
5152: );
5153: END IF;

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

5146: WHERE id = l_btl_rec.id;
5147: END IF; ----chk for split_flag IS NULL
5148:
5149: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
5150: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.ADJUST_SPLIT_BILL_REC.update_btl',
5151: 'update_old_btl_amt id = ' || l_btl_rec.id
5152: );
5153: END IF;
5154:

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

5165: SET date_completed = SYSDATE
5166: WHERE TRUNC(date_start) <= TRUNC(l_max_billed_dt)
5167: AND cle_id =p_new_cp_id ;
5168:
5169: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
5170: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.ADJUST_SPLIT_BILL_REC.update_lvl_new',
5171: 'update date_completed of new cp level elements up to date = ' || l_max_billed_dt
5172: );
5173: END IF;

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

5166: WHERE TRUNC(date_start) <= TRUNC(l_max_billed_dt)
5167: AND cle_id =p_new_cp_id ;
5168:
5169: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
5170: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.ADJUST_SPLIT_BILL_REC.update_lvl_new',
5171: 'update date_completed of new cp level elements up to date = ' || l_max_billed_dt
5172: );
5173: END IF;
5174:

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

5178:
5179: EXCEPTION
5180:
5181: WHEN OTHERS THEN
5182: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN
5183: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.Adjust_billed_lvl_element.UNEXPECTED',
5184: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
5185: END IF;
5186:

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

5179: EXCEPTION
5180:
5181: WHEN OTHERS THEN
5182: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN
5183: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.Adjust_billed_lvl_element.UNEXPECTED',
5184: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
5185: END IF;
5186:
5187: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,