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

Line 326: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

322:
323:
324: BEGIN
325: l_return_status := OKC_API.G_RET_STS_SUCCESS;
326: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
327: FND_LOG.string(FND_LOG.level_procedure
328: ,'OKS.plsql.OKS_COPY_CONTRACT_PVT.'||l_module_name||'.Begin'
329: ,'Entered OKS_SETUP_UTIL_PUB.copy_hdr_attr'
330: ||', p_chr_id ='||p_chr_id

Line 327: FND_LOG.string(FND_LOG.level_procedure

323:
324: BEGIN
325: l_return_status := OKC_API.G_RET_STS_SUCCESS;
326: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
327: FND_LOG.string(FND_LOG.level_procedure
328: ,'OKS.plsql.OKS_COPY_CONTRACT_PVT.'||l_module_name||'.Begin'
329: ,'Entered OKS_SETUP_UTIL_PUB.copy_hdr_attr'
330: ||', p_chr_id ='||p_chr_id
331: ||', p_new_chr_id='||p_new_chr_id

Line 345: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

341: open get_org_id_csr(p_new_chr_id);
342: fetch get_org_id_csr into l_org_id;
343: close get_org_id_csr;
344:
345: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
346: FND_LOG.string(FND_LOG.level_statement
347: ,'OKS.plsql.OKS_COPY_CONTRACT_PVT.'||l_module_name
348: ,'Before call to OKS_RENEW_UTIL_PUB.get_period_defaults'
349: ||', l_org_id ='||l_org_id

Line 346: FND_LOG.string(FND_LOG.level_statement

342: fetch get_org_id_csr into l_org_id;
343: close get_org_id_csr;
344:
345: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
346: FND_LOG.string(FND_LOG.level_statement
347: ,'OKS.plsql.OKS_COPY_CONTRACT_PVT.'||l_module_name
348: ,'Before call to OKS_RENEW_UTIL_PUB.get_period_defaults'
349: ||', l_org_id ='||l_org_id
350: );

Line 366: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

362: G_GCD_PERIOD_START := l_period_start;
363: G_GCD_PERIOD_TYPE := l_period_type;
364: G_GCD_PRICE_UOM := l_price_uom;
365:
366: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
367: FND_LOG.string(FND_LOG.level_statement
368: ,'OKS.plsql.OKS_COPY_CONTRACT_PVT.'||l_module_name
369: ,'after call to OKS_RENEW_UTIL_PUB.get_period_defaults'
370: ||', l_period_type ='||l_period_type

Line 367: FND_LOG.string(FND_LOG.level_statement

363: G_GCD_PERIOD_TYPE := l_period_type;
364: G_GCD_PRICE_UOM := l_price_uom;
365:
366: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
367: FND_LOG.string(FND_LOG.level_statement
368: ,'OKS.plsql.OKS_COPY_CONTRACT_PVT.'||l_module_name
369: ,'after call to OKS_RENEW_UTIL_PUB.get_period_defaults'
370: ||', l_period_type ='||l_period_type
371: ||', l_period_start ='||l_period_start

Line 548: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

544: END IF;
545:
546: ctr := ctr+1;
547: END LOOP;
548: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
549: FND_LOG.string(FND_LOG.level_statement
550: ,l_module_name
551: ,'After get_hdr_attr_csr LOOP'
552: ||'l_khrv_tbl.COUNT = '||l_khrv_tbl.COUNT

Line 549: FND_LOG.string(FND_LOG.level_statement

545:
546: ctr := ctr+1;
547: END LOOP;
548: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
549: FND_LOG.string(FND_LOG.level_statement
550: ,l_module_name
551: ,'After get_hdr_attr_csr LOOP'
552: ||'l_khrv_tbl.COUNT = '||l_khrv_tbl.COUNT
553: );

Line 558: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

554: END IF;
555:
556: IF l_khrv_tbl.COUNT >0 THEN
557:
558: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
559: FND_LOG.string(FND_LOG.level_statement
560: ,l_module_name||'.OKS_CONTRACT_HDR_PUB.create_header'
561: ,'Before call to OKS_CONTRACT_HDR_PUB.create_header'
562: );

Line 559: FND_LOG.string(FND_LOG.level_statement

555:
556: IF l_khrv_tbl.COUNT >0 THEN
557:
558: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
559: FND_LOG.string(FND_LOG.level_statement
560: ,l_module_name||'.OKS_CONTRACT_HDR_PUB.create_header'
561: ,'Before call to OKS_CONTRACT_HDR_PUB.create_header'
562: );
563: END IF;

Line 575: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

571: p_khrv_tbl => l_khrv_tbl,
572: x_khrv_tbl => x_khrv_tbl,
573: p_validate_yn => 'N');
574:
575: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
576: FND_LOG.string(FND_LOG.level_statement
577: ,l_module_name||'.OKS_CONTRACT_HDR_PUB.create_header'
578: ,'After call to OKS_CONTRACT_HDR_PUB.create_header'
579: ||', x_return_status='||l_return_status

Line 576: FND_LOG.string(FND_LOG.level_statement

572: x_khrv_tbl => x_khrv_tbl,
573: p_validate_yn => 'N');
574:
575: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
576: FND_LOG.string(FND_LOG.level_statement
577: ,l_module_name||'.OKS_CONTRACT_HDR_PUB.create_header'
578: ,'After call to OKS_CONTRACT_HDR_PUB.create_header'
579: ||', x_return_status='||l_return_status
580: );

Line 4880: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

4876: l_del_trxn BOOLEAN;
4877:
4878: BEGIN
4879: --log key input parameters
4880: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
4881: IF (FND_LOG.test(FND_LOG.level_procedure, l_mod_name)) THEN
4882: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.begin', 'p_api_version=' || p_api_version ||' ,p_commit='|| p_commit ||' ,p_line_id='|| p_line_id);
4883: END IF;
4884: END IF;

Line 4881: IF (FND_LOG.test(FND_LOG.level_procedure, l_mod_name)) THEN

4877:
4878: BEGIN
4879: --log key input parameters
4880: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
4881: IF (FND_LOG.test(FND_LOG.level_procedure, l_mod_name)) THEN
4882: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.begin', 'p_api_version=' || p_api_version ||' ,p_commit='|| p_commit ||' ,p_line_id='|| p_line_id);
4883: END IF;
4884: END IF;
4885:

Line 4882: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.begin', 'p_api_version=' || p_api_version ||' ,p_commit='|| p_commit ||' ,p_line_id='|| p_line_id);

4878: BEGIN
4879: --log key input parameters
4880: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
4881: IF (FND_LOG.test(FND_LOG.level_procedure, l_mod_name)) THEN
4882: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.begin', 'p_api_version=' || p_api_version ||' ,p_commit='|| p_commit ||' ,p_line_id='|| p_line_id);
4883: END IF;
4884: END IF;
4885:
4886: --standard api initilization and checks

Line 4901: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

4897: FETCH c_get_line_type INTO l_lse_id, l_parent_id, l_cust_account_id, l_bill_to_site_use_id,
4898: l_lock_pl_line_id, l_trxn_extension_id;
4899: CLOSE c_get_line_type;
4900:
4901: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
4902: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.line_dtls', 'l_lse_id='||l_lse_id||' ,l_parent_id='||l_parent_id||' ,l_cust_account_id='||l_cust_account_id||' ,l_bill_to_site_use_id='||l_bill_to_site_use_id||
4903: ' ,l_lock_pl_line_id='||l_lock_pl_line_id||' ,l_trxn_extension_id='||l_trxn_extension_id);
4904: END IF;
4905:

Line 4902: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.line_dtls', 'l_lse_id='||l_lse_id||' ,l_parent_id='||l_parent_id||' ,l_cust_account_id='||l_cust_account_id||' ,l_bill_to_site_use_id='||l_bill_to_site_use_id||

4898: l_lock_pl_line_id, l_trxn_extension_id;
4899: CLOSE c_get_line_type;
4900:
4901: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
4902: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.line_dtls', 'l_lse_id='||l_lse_id||' ,l_parent_id='||l_parent_id||' ,l_cust_account_id='||l_cust_account_id||' ,l_bill_to_site_use_id='||l_bill_to_site_use_id||
4903: ' ,l_lock_pl_line_id='||l_lock_pl_line_id||' ,l_trxn_extension_id='||l_trxn_extension_id);
4904: END IF;
4905:
4906:

Line 4925: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN

4921: CLOSE c_chk_transfer;
4922:
4923: IF (l_transfer_id IS NOT NULL) THEN
4924: FND_MESSAGE.set_NAME(G_OKS_APP_NAME, 'OKS_TRANSFER_LINE_NO_DELETE');
4925: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
4926: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.transfer_check', FALSE);
4927: END IF;
4928: FND_MSG_PUB.ADD;
4929: RAISE FND_API.g_exc_error;

Line 4926: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.transfer_check', FALSE);

4922:
4923: IF (l_transfer_id IS NOT NULL) THEN
4924: FND_MESSAGE.set_NAME(G_OKS_APP_NAME, 'OKS_TRANSFER_LINE_NO_DELETE');
4925: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
4926: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.transfer_check', FALSE);
4927: END IF;
4928: FND_MSG_PUB.ADD;
4929: RAISE FND_API.g_exc_error;
4930: END IF;

Line 4958: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

4954: l_payer.payment_function := IBY_FNDCPT_COMMON_PUB.G_PMT_FUNCTION_CUST_PMT; --CUSTOMER_PAYMENT
4955: l_payer.party_id := l_party_id;
4956: l_payer.cust_account_id := l_cust_account_id;
4957:
4958: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
4959: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.del_trxn_extn', 'calling IBY_FNDCPT_TRXN_PUB.delete_transaction_extension, p_payer.party_id='||l_party_id||' ,p_payer.cust_account_id='||l_cust_account_id||
4960: ' ,p_entity_id='||l_trxn_extension_id);
4961: END IF;
4962:

Line 4959: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.del_trxn_extn', 'calling IBY_FNDCPT_TRXN_PUB.delete_transaction_extension, p_payer.party_id='||l_party_id||' ,p_payer.cust_account_id='||l_cust_account_id||

4955: l_payer.party_id := l_party_id;
4956: l_payer.cust_account_id := l_cust_account_id;
4957:
4958: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
4959: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.del_trxn_extn', 'calling IBY_FNDCPT_TRXN_PUB.delete_transaction_extension, p_payer.party_id='||l_party_id||' ,p_payer.cust_account_id='||l_cust_account_id||
4960: ' ,p_entity_id='||l_trxn_extension_id);
4961: END IF;
4962:
4963: IBY_FNDCPT_TRXN_PUB.delete_transaction_extension(

Line 4976: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

4972: p_payer_equivalency => IBY_FNDCPT_COMMON_PUB.G_PAYER_EQUIV_FULL, -- FULL, bug 5439978
4973: p_entity_id => l_trxn_extension_id,
4974: x_response => l_response);
4975:
4976: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
4977: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.del_trxn_extn', 'after call to IBY_FNDCPT_TRXN_PUB.delete_transaction_extension, x_return_status='||x_return_status||
4978: ' ,result_code='||l_response.result_code||' ,result_category='||l_response.result_category||' ,result_message='||l_response.result_message);
4979: END IF;
4980:

Line 4977: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.del_trxn_extn', 'after call to IBY_FNDCPT_TRXN_PUB.delete_transaction_extension, x_return_status='||x_return_status||

4973: p_entity_id => l_trxn_extension_id,
4974: x_response => l_response);
4975:
4976: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
4977: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.del_trxn_extn', 'after call to IBY_FNDCPT_TRXN_PUB.delete_transaction_extension, x_return_status='||x_return_status||
4978: ' ,result_code='||l_response.result_code||' ,result_category='||l_response.result_category||' ,result_message='||l_response.result_message);
4979: END IF;
4980:
4981: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN

Line 5007: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

5003: x_msg_count => x_msg_count,
5004: x_msg_data => x_msg_data,
5005: p_service_line_id => p_line_id);
5006:
5007: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
5008: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.delete_coverage', 'after call to OKS_COVERAGES_PUB.delete_coverage, x_return_status='||x_return_status);
5009: END IF;
5010:
5011: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN

Line 5008: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.delete_coverage', 'after call to OKS_COVERAGES_PUB.delete_coverage, x_return_status='||x_return_status);

5004: x_msg_data => x_msg_data,
5005: p_service_line_id => p_line_id);
5006:
5007: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
5008: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.delete_coverage', 'after call to OKS_COVERAGES_PUB.delete_coverage, x_return_status='||x_return_status);
5009: END IF;
5010:
5011: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
5012: RAISE FND_API.g_exc_unexpected_error;

Line 5022: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

5018: OPEN c_get_notes(p_line_id);
5019: LOOP
5020: FETCH c_get_notes BULK COLLECT INTO l_jtf_note_id_tbl LIMIT G_BULK_FETCH_LIMIT;
5021:
5022: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
5023: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.c_get_notes_bulk_fetch', 'l_jtf_note_id_tbl.count=,'||l_jtf_note_id_tbl.count);
5024: END IF;
5025:
5026: EXIT WHEN (l_jtf_note_id_tbl.count = 0);

Line 5023: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.c_get_notes_bulk_fetch', 'l_jtf_note_id_tbl.count=,'||l_jtf_note_id_tbl.count);

5019: LOOP
5020: FETCH c_get_notes BULK COLLECT INTO l_jtf_note_id_tbl LIMIT G_BULK_FETCH_LIMIT;
5021:
5022: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
5023: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.c_get_notes_bulk_fetch', 'l_jtf_note_id_tbl.count=,'||l_jtf_note_id_tbl.count);
5024: END IF;
5025:
5026: EXIT WHEN (l_jtf_note_id_tbl.count = 0);
5027:

Line 5031: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

5027:
5028: -- Call API to delete coverage notes, if exists **/
5029: FOR i in l_jtf_note_id_tbl.first..l_jtf_note_id_tbl.last LOOP
5030:
5031: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
5032: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.delete_cov_notes', 'calling JTF_NOTES_PUB.secure_delete_note, p_jtf_note_id='||l_jtf_note_id_tbl(i));
5033: END IF;
5034:
5035: JTF_NOTES_PUB.secure_delete_note(

Line 5032: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.delete_cov_notes', 'calling JTF_NOTES_PUB.secure_delete_note, p_jtf_note_id='||l_jtf_note_id_tbl(i));

5028: -- Call API to delete coverage notes, if exists **/
5029: FOR i in l_jtf_note_id_tbl.first..l_jtf_note_id_tbl.last LOOP
5030:
5031: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
5032: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.delete_cov_notes', 'calling JTF_NOTES_PUB.secure_delete_note, p_jtf_note_id='||l_jtf_note_id_tbl(i));
5033: END IF;
5034:
5035: JTF_NOTES_PUB.secure_delete_note(
5036: p_api_version => 1.0,

Line 5047: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

5043: p_jtf_note_id => l_jtf_note_id_tbl(i),
5044: p_use_AOL_security => FND_API.G_FALSE);
5045:
5046:
5047: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
5048: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.delete_cov_notes', 'after call to JTF_NOTES_PUB.secure_delete_note, x_return_status='||x_return_status);
5049: END IF;
5050:
5051: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN

Line 5048: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.delete_cov_notes', 'after call to JTF_NOTES_PUB.secure_delete_note, x_return_status='||x_return_status);

5044: p_use_AOL_security => FND_API.G_FALSE);
5045:
5046:
5047: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
5048: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.delete_cov_notes', 'after call to JTF_NOTES_PUB.secure_delete_note, x_return_status='||x_return_status);
5049: END IF;
5050:
5051: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
5052: RAISE FND_API.g_exc_unexpected_error;

Line 5063: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

5059: END LOOP; --c_get_notes bulk fetch loop
5060: CLOSE c_get_notes;
5061:
5062:
5063: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
5064: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.delete_cov_notes', 'calling OKS_PM_PROGRAMS_PVT.undo_pm_line, p_cle_id='||p_line_id);
5065: END IF;
5066:
5067: --delete PM schedules

Line 5064: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.delete_cov_notes', 'calling OKS_PM_PROGRAMS_PVT.undo_pm_line, p_cle_id='||p_line_id);

5060: CLOSE c_get_notes;
5061:
5062:
5063: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
5064: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.delete_cov_notes', 'calling OKS_PM_PROGRAMS_PVT.undo_pm_line, p_cle_id='||p_line_id);
5065: END IF;
5066:
5067: --delete PM schedules
5068: OKS_PM_PROGRAMS_PVT.undo_pm_line(

Line 5076: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

5072: x_msg_count => x_msg_count,
5073: x_msg_data => x_msg_data,
5074: p_cle_id => p_line_id);
5075:
5076: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
5077: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.delete_cov_notes', 'after call to OKS_PM_PROGRAMS_PVT.undo_pm_line, x_return_status='||x_return_status);
5078: END IF;
5079:
5080: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN

Line 5077: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.delete_cov_notes', 'after call to OKS_PM_PROGRAMS_PVT.undo_pm_line, x_return_status='||x_return_status);

5073: x_msg_data => x_msg_data,
5074: p_cle_id => p_line_id);
5075:
5076: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
5077: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.delete_cov_notes', 'after call to OKS_PM_PROGRAMS_PVT.undo_pm_line, x_return_status='||x_return_status);
5078: END IF;
5079:
5080: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
5081: RAISE FND_API.g_exc_unexpected_error;

Line 5101: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

5097: x_return_status => x_return_status,
5098: x_msg_count => x_msg_count,
5099: x_msg_data => x_msg_data);
5100:
5101: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
5102: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.delete_locked_pricebreaks', 'after call to OKS_QP_PKG.delete_locked_pricebreaks, x_return_status='||x_return_status);
5103: END IF;
5104:
5105: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN

Line 5102: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.delete_locked_pricebreaks', 'after call to OKS_QP_PKG.delete_locked_pricebreaks, x_return_status='||x_return_status);

5098: x_msg_count => x_msg_count,
5099: x_msg_data => x_msg_data);
5100:
5101: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
5102: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.delete_locked_pricebreaks', 'after call to OKS_QP_PKG.delete_locked_pricebreaks, x_return_status='||x_return_status);
5103: END IF;
5104:
5105: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
5106: RAISE FND_API.g_exc_unexpected_error;

Line 5119: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

5115: OPEN c_usage_sub_lines(p_line_id);
5116: LOOP
5117: FETCH c_usage_sub_lines BULK COLLECT INTO l_lock_pl_line_id_tbl LIMIT G_BULK_FETCH_LIMIT;
5118:
5119: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
5120: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.c_usage_sub_lines_bulk_fetch', 'l_lock_pl_line_id_tbl.count=,'||l_lock_pl_line_id_tbl.count);
5121: END IF;
5122:
5123: EXIT WHEN (l_lock_pl_line_id_tbl.count = 0);

Line 5120: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.c_usage_sub_lines_bulk_fetch', 'l_lock_pl_line_id_tbl.count=,'||l_lock_pl_line_id_tbl.count);

5116: LOOP
5117: FETCH c_usage_sub_lines BULK COLLECT INTO l_lock_pl_line_id_tbl LIMIT G_BULK_FETCH_LIMIT;
5118:
5119: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
5120: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.c_usage_sub_lines_bulk_fetch', 'l_lock_pl_line_id_tbl.count=,'||l_lock_pl_line_id_tbl.count);
5121: END IF;
5122:
5123: EXIT WHEN (l_lock_pl_line_id_tbl.count = 0);
5124:

Line 5136: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

5132: x_return_status => x_return_status,
5133: x_msg_count => x_msg_count,
5134: x_msg_data => x_msg_data);
5135:
5136: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
5137: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.delete_locked_pricebreaks_sub', 'after call to OKS_QP_PKG.delete_locked_pricebreaks, x_return_status='||x_return_status);
5138: END IF;
5139:
5140: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN

Line 5137: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.delete_locked_pricebreaks_sub', 'after call to OKS_QP_PKG.delete_locked_pricebreaks, x_return_status='||x_return_status);

5133: x_msg_count => x_msg_count,
5134: x_msg_data => x_msg_data);
5135:
5136: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
5137: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.delete_locked_pricebreaks_sub', 'after call to OKS_QP_PKG.delete_locked_pricebreaks, x_return_status='||x_return_status);
5138: END IF;
5139:
5140: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
5141: RAISE FND_API.g_exc_unexpected_error;

Line 5167: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

5163: x_msg_count => x_msg_count,
5164: x_msg_data => x_msg_data,
5165: p_cle_id => p_line_id);
5166:
5167: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
5168: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.Undo_Subscription', 'after call to OKS_SUBSCRIPTION_PUB.Undo_Subscription, x_return_status='||x_return_status);
5169: END IF;
5170:
5171: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN

Line 5168: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.Undo_Subscription', 'after call to OKS_SUBSCRIPTION_PUB.Undo_Subscription, x_return_status='||x_return_status);

5164: x_msg_data => x_msg_data,
5165: p_cle_id => p_line_id);
5166:
5167: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
5168: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.Undo_Subscription', 'after call to OKS_SUBSCRIPTION_PUB.Undo_Subscription, x_return_status='||x_return_status);
5169: END IF;
5170:
5171: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
5172: RAISE FND_API.g_exc_unexpected_error;

Line 5191: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

5187: x_return_status => x_return_status,
5188: x_msg_count => x_msg_count,
5189: x_msg_data => x_msg_data);
5190:
5191: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
5192: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.del_rul_elements', 'after call to OKS_BILL_SCH.del_rul_elements, x_return_status='||x_return_status);
5193: END IF;
5194:
5195: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN

Line 5192: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.del_rul_elements', 'after call to OKS_BILL_SCH.del_rul_elements, x_return_status='||x_return_status);

5188: x_msg_count => x_msg_count,
5189: x_msg_data => x_msg_data);
5190:
5191: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
5192: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.del_rul_elements', 'after call to OKS_BILL_SCH.del_rul_elements, x_return_status='||x_return_status);
5193: END IF;
5194:
5195: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
5196: RAISE FND_API.g_exc_unexpected_error;

Line 5210: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

5206: x_return_status => x_return_status,
5207: x_msg_count => x_msg_count,
5208: x_msg_data => x_msg_data);
5209:
5210: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
5211: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.del_subline_lvl_rule', 'after call to OKS_BILL_SCH.del_subline_lvl_rule, x_return_status='||x_return_status);
5212: END IF;
5213:
5214: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN

Line 5211: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.del_subline_lvl_rule', 'after call to OKS_BILL_SCH.del_subline_lvl_rule, x_return_status='||x_return_status);

5207: x_msg_count => x_msg_count,
5208: x_msg_data => x_msg_data);
5209:
5210: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
5211: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.del_subline_lvl_rule', 'after call to OKS_BILL_SCH.del_subline_lvl_rule, x_return_status='||x_return_status);
5212: END IF;
5213:
5214: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
5215: RAISE FND_API.g_exc_unexpected_error;

Line 5230: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

5226: --rev distributions, qaulifiers
5227: OPEN c_get_child_lines(p_line_id);
5228: LOOP
5229: FETCH c_get_child_lines BULK COLLECT INTO l_id_tbl LIMIT G_BULK_FETCH_LIMIT;
5230: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
5231: IF (FND_LOG.test(FND_LOG.level_statement, l_mod_name)) THEN
5232: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.c_get_child_lines_bulk_fetch', 'l_id_tbl.count='||l_id_tbl.count);
5233: END IF;
5234: END IF;

Line 5231: IF (FND_LOG.test(FND_LOG.level_statement, l_mod_name)) THEN

5227: OPEN c_get_child_lines(p_line_id);
5228: LOOP
5229: FETCH c_get_child_lines BULK COLLECT INTO l_id_tbl LIMIT G_BULK_FETCH_LIMIT;
5230: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
5231: IF (FND_LOG.test(FND_LOG.level_statement, l_mod_name)) THEN
5232: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.c_get_child_lines_bulk_fetch', 'l_id_tbl.count='||l_id_tbl.count);
5233: END IF;
5234: END IF;
5235: EXIT WHEN (l_id_tbl.count = 0);

Line 5232: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.c_get_child_lines_bulk_fetch', 'l_id_tbl.count='||l_id_tbl.count);

5228: LOOP
5229: FETCH c_get_child_lines BULK COLLECT INTO l_id_tbl LIMIT G_BULK_FETCH_LIMIT;
5230: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
5231: IF (FND_LOG.test(FND_LOG.level_statement, l_mod_name)) THEN
5232: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.c_get_child_lines_bulk_fetch', 'l_id_tbl.count='||l_id_tbl.count);
5233: END IF;
5234: END IF;
5235: EXIT WHEN (l_id_tbl.count = 0);
5236:

Line 5261: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

5257:
5258: END LOOP;
5259: CLOSE c_get_child_lines;
5260:
5261: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
5262: IF (FND_LOG.test(FND_LOG.level_statement, l_mod_name)) THEN
5263: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.delete_oks_entities', 'done');
5264: END IF;
5265: END IF;

Line 5262: IF (FND_LOG.test(FND_LOG.level_statement, l_mod_name)) THEN

5258: END LOOP;
5259: CLOSE c_get_child_lines;
5260:
5261: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
5262: IF (FND_LOG.test(FND_LOG.level_statement, l_mod_name)) THEN
5263: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.delete_oks_entities', 'done');
5264: END IF;
5265: END IF;
5266:

Line 5263: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.delete_oks_entities', 'done');

5259: CLOSE c_get_child_lines;
5260:
5261: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
5262: IF (FND_LOG.test(FND_LOG.level_statement, l_mod_name)) THEN
5263: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.delete_oks_entities', 'done');
5264: END IF;
5265: END IF;
5266:
5267: --call OKC API to delete all OKC lines and entities. This deletes all OKC entities and

Line 5269: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

5265: END IF;
5266:
5267: --call OKC API to delete all OKC lines and entities. This deletes all OKC entities and
5268: --the OKC sublines
5269: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
5270: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.delete_okc_entities', 'calling OKC_CONTRACT_PVT.delete_contract_line, p_line_id='||p_line_id);
5271: END IF;
5272: OKC_CONTRACT_PVT.delete_contract_line(
5273: p_api_version => 1.0,

Line 5270: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.delete_okc_entities', 'calling OKC_CONTRACT_PVT.delete_contract_line, p_line_id='||p_line_id);

5266:
5267: --call OKC API to delete all OKC lines and entities. This deletes all OKC entities and
5268: --the OKC sublines
5269: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
5270: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.delete_okc_entities', 'calling OKC_CONTRACT_PVT.delete_contract_line, p_line_id='||p_line_id);
5271: END IF;
5272: OKC_CONTRACT_PVT.delete_contract_line(
5273: p_api_version => 1.0,
5274: p_init_msg_list => FND_API.G_FALSE,

Line 5280: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

5276: x_msg_count => x_msg_count,
5277: x_msg_data => x_msg_data,
5278: p_line_id => p_line_id);
5279:
5280: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
5281: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.delete_okc_entities', 'after call to OKC_CONTRACT_PVT.delete_contract_line, x_return_status='||x_return_status);
5282: END IF;
5283:
5284: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN

Line 5281: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.delete_okc_entities', 'after call to OKC_CONTRACT_PVT.delete_contract_line, x_return_status='||x_return_status);

5277: x_msg_data => x_msg_data,
5278: p_line_id => p_line_id);
5279:
5280: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
5281: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.delete_okc_entities', 'after call to OKC_CONTRACT_PVT.delete_contract_line, x_return_status='||x_return_status);
5282: END IF;
5283:
5284: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
5285: RAISE FND_API.g_exc_unexpected_error;

Line 5295: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

5291: --standard check of p_commit
5292: IF FND_API.to_boolean( p_commit ) THEN
5293: COMMIT;
5294: END IF;
5295: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
5296: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.end', ' x_return_status='|| x_return_status);
5297: END IF;
5298: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
5299:

Line 5296: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.end', ' x_return_status='|| x_return_status);

5292: IF FND_API.to_boolean( p_commit ) THEN
5293: COMMIT;
5294: END IF;
5295: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
5296: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.end', ' x_return_status='|| x_return_status);
5297: END IF;
5298: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
5299:
5300: EXCEPTION

Line 5305: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN

5301: WHEN FND_API.g_exc_error THEN
5302: ROLLBACK TO delete_top_sub_line_PUB;
5303: x_return_status := FND_API.g_ret_sts_error ;
5304:
5305: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
5306: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_error', 'x_return_status=' || x_return_status);
5307: END IF;
5308: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
5309:

Line 5306: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_error', 'x_return_status=' || x_return_status);

5302: ROLLBACK TO delete_top_sub_line_PUB;
5303: x_return_status := FND_API.g_ret_sts_error ;
5304:
5305: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
5306: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_error', 'x_return_status=' || x_return_status);
5307: END IF;
5308: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
5309:
5310: IF (c_get_line_type%isopen) THEN

Line 5336: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN

5332: WHEN FND_API.g_exc_unexpected_error THEN
5333: ROLLBACK TO delete_top_sub_line_PUB;
5334: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5335:
5336: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
5337: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_unexpected_error', 'x_return_status=' || x_return_status);
5338: END IF;
5339: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
5340:

Line 5337: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_unexpected_error', 'x_return_status=' || x_return_status);

5333: ROLLBACK TO delete_top_sub_line_PUB;
5334: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5335:
5336: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
5337: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_unexpected_error', 'x_return_status=' || x_return_status);
5338: END IF;
5339: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
5340:
5341: IF (c_get_line_type%isopen) THEN

Line 5367: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN

5363: WHEN OTHERS THEN
5364: ROLLBACK TO delete_top_sub_line_PUB;
5365: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5366:
5367: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
5368: --first log the sqlerrm
5369: l_error_text := substr (SQLERRM, 1, 240);
5370: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
5371: --then add it to the message api list

Line 5370: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);

5366:
5367: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
5368: --first log the sqlerrm
5369: l_error_text := substr (SQLERRM, 1, 240);
5370: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
5371: --then add it to the message api list
5372: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
5373: END IF;
5374: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );