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 543: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

539:
540:
541: ctr := ctr+1;
542: END LOOP;
543: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
544: FND_LOG.string(FND_LOG.level_statement
545: ,l_module_name
546: ,'After get_hdr_attr_csr LOOP'
547: ||'l_khrv_tbl.COUNT = '||l_khrv_tbl.COUNT

Line 544: FND_LOG.string(FND_LOG.level_statement

540:
541: ctr := ctr+1;
542: END LOOP;
543: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
544: FND_LOG.string(FND_LOG.level_statement
545: ,l_module_name
546: ,'After get_hdr_attr_csr LOOP'
547: ||'l_khrv_tbl.COUNT = '||l_khrv_tbl.COUNT
548: );

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

549: END IF;
550:
551: IF l_khrv_tbl.COUNT >0 THEN
552:
553: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
554: FND_LOG.string(FND_LOG.level_statement
555: ,l_module_name||'.OKS_CONTRACT_HDR_PUB.create_header'
556: ,'Before call to OKS_CONTRACT_HDR_PUB.create_header'
557: );

Line 554: FND_LOG.string(FND_LOG.level_statement

550:
551: IF l_khrv_tbl.COUNT >0 THEN
552:
553: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
554: FND_LOG.string(FND_LOG.level_statement
555: ,l_module_name||'.OKS_CONTRACT_HDR_PUB.create_header'
556: ,'Before call to OKS_CONTRACT_HDR_PUB.create_header'
557: );
558: END IF;

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

566: p_khrv_tbl => l_khrv_tbl,
567: x_khrv_tbl => x_khrv_tbl,
568: p_validate_yn => 'N');
569:
570: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
571: FND_LOG.string(FND_LOG.level_statement
572: ,l_module_name||'.OKS_CONTRACT_HDR_PUB.create_header'
573: ,'After call to OKS_CONTRACT_HDR_PUB.create_header'
574: ||', x_return_status='||l_return_status

Line 571: FND_LOG.string(FND_LOG.level_statement

567: x_khrv_tbl => x_khrv_tbl,
568: p_validate_yn => 'N');
569:
570: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
571: FND_LOG.string(FND_LOG.level_statement
572: ,l_module_name||'.OKS_CONTRACT_HDR_PUB.create_header'
573: ,'After call to OKS_CONTRACT_HDR_PUB.create_header'
574: ||', x_return_status='||l_return_status
575: );

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

4867: l_del_trxn BOOLEAN;
4868:
4869: BEGIN
4870: --log key input parameters
4871: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
4872: IF (FND_LOG.test(FND_LOG.level_procedure, l_mod_name)) THEN
4873: 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);
4874: END IF;
4875: END IF;

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

4868:
4869: BEGIN
4870: --log key input parameters
4871: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
4872: IF (FND_LOG.test(FND_LOG.level_procedure, l_mod_name)) THEN
4873: 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);
4874: END IF;
4875: END IF;
4876:

Line 4873: 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);

4869: BEGIN
4870: --log key input parameters
4871: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
4872: IF (FND_LOG.test(FND_LOG.level_procedure, l_mod_name)) THEN
4873: 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);
4874: END IF;
4875: END IF;
4876:
4877: --standard api initilization and checks

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

4888: FETCH c_get_line_type INTO l_lse_id, l_parent_id, l_cust_account_id, l_bill_to_site_use_id,
4889: l_lock_pl_line_id, l_trxn_extension_id;
4890: CLOSE c_get_line_type;
4891:
4892: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
4893: 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||
4894: ' ,l_lock_pl_line_id='||l_lock_pl_line_id||' ,l_trxn_extension_id='||l_trxn_extension_id);
4895: END IF;
4896:

Line 4893: 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||

4889: l_lock_pl_line_id, l_trxn_extension_id;
4890: CLOSE c_get_line_type;
4891:
4892: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
4893: 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||
4894: ' ,l_lock_pl_line_id='||l_lock_pl_line_id||' ,l_trxn_extension_id='||l_trxn_extension_id);
4895: END IF;
4896:
4897:

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

4912: CLOSE c_chk_transfer;
4913:
4914: IF (l_transfer_id IS NOT NULL) THEN
4915: FND_MESSAGE.set_NAME(G_OKS_APP_NAME, 'OKS_TRANSFER_LINE_NO_DELETE');
4916: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
4917: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.transfer_check', FALSE);
4918: END IF;
4919: FND_MSG_PUB.ADD;
4920: RAISE FND_API.g_exc_error;

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

4913:
4914: IF (l_transfer_id IS NOT NULL) THEN
4915: FND_MESSAGE.set_NAME(G_OKS_APP_NAME, 'OKS_TRANSFER_LINE_NO_DELETE');
4916: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
4917: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.transfer_check', FALSE);
4918: END IF;
4919: FND_MSG_PUB.ADD;
4920: RAISE FND_API.g_exc_error;
4921: END IF;

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

4945: l_payer.payment_function := IBY_FNDCPT_COMMON_PUB.G_PMT_FUNCTION_CUST_PMT; --CUSTOMER_PAYMENT
4946: l_payer.party_id := l_party_id;
4947: l_payer.cust_account_id := l_cust_account_id;
4948:
4949: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
4950: 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||
4951: ' ,p_entity_id='||l_trxn_extension_id);
4952: END IF;
4953:

Line 4950: 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||

4946: l_payer.party_id := l_party_id;
4947: l_payer.cust_account_id := l_cust_account_id;
4948:
4949: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
4950: 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||
4951: ' ,p_entity_id='||l_trxn_extension_id);
4952: END IF;
4953:
4954: IBY_FNDCPT_TRXN_PUB.delete_transaction_extension(

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

4963: p_payer_equivalency => IBY_FNDCPT_COMMON_PUB.G_PAYER_EQUIV_FULL, -- FULL, bug 5439978
4964: p_entity_id => l_trxn_extension_id,
4965: x_response => l_response);
4966:
4967: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
4968: 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||
4969: ' ,result_code='||l_response.result_code||' ,result_category='||l_response.result_category||' ,result_message='||l_response.result_message);
4970: END IF;
4971:

Line 4968: 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||

4964: p_entity_id => l_trxn_extension_id,
4965: x_response => l_response);
4966:
4967: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
4968: 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||
4969: ' ,result_code='||l_response.result_code||' ,result_category='||l_response.result_category||' ,result_message='||l_response.result_message);
4970: END IF;
4971:
4972: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN

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

4994: x_msg_count => x_msg_count,
4995: x_msg_data => x_msg_data,
4996: p_service_line_id => p_line_id);
4997:
4998: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
4999: 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);
5000: END IF;
5001:
5002: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN

Line 4999: 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);

4995: x_msg_data => x_msg_data,
4996: p_service_line_id => p_line_id);
4997:
4998: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
4999: 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);
5000: END IF;
5001:
5002: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
5003: RAISE FND_API.g_exc_unexpected_error;

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

5009: OPEN c_get_notes(p_line_id);
5010: LOOP
5011: FETCH c_get_notes BULK COLLECT INTO l_jtf_note_id_tbl LIMIT G_BULK_FETCH_LIMIT;
5012:
5013: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
5014: 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);
5015: END IF;
5016:
5017: EXIT WHEN (l_jtf_note_id_tbl.count = 0);

Line 5014: 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);

5010: LOOP
5011: FETCH c_get_notes BULK COLLECT INTO l_jtf_note_id_tbl LIMIT G_BULK_FETCH_LIMIT;
5012:
5013: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
5014: 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);
5015: END IF;
5016:
5017: EXIT WHEN (l_jtf_note_id_tbl.count = 0);
5018:

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

5018:
5019: -- Call API to delete coverage notes, if exists **/
5020: FOR i in l_jtf_note_id_tbl.first..l_jtf_note_id_tbl.last LOOP
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 || '.delete_cov_notes', 'calling JTF_NOTES_PUB.secure_delete_note, p_jtf_note_id='||l_jtf_note_id_tbl(i));
5024: END IF;
5025:
5026: JTF_NOTES_PUB.secure_delete_note(

Line 5023: 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));

5019: -- Call API to delete coverage notes, if exists **/
5020: FOR i in l_jtf_note_id_tbl.first..l_jtf_note_id_tbl.last LOOP
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 || '.delete_cov_notes', 'calling JTF_NOTES_PUB.secure_delete_note, p_jtf_note_id='||l_jtf_note_id_tbl(i));
5024: END IF;
5025:
5026: JTF_NOTES_PUB.secure_delete_note(
5027: p_api_version => 1.0,

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

5034: p_jtf_note_id => l_jtf_note_id_tbl(i),
5035: p_use_AOL_security => FND_API.G_FALSE);
5036:
5037:
5038: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
5039: 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);
5040: END IF;
5041:
5042: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN

Line 5039: 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);

5035: p_use_AOL_security => FND_API.G_FALSE);
5036:
5037:
5038: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
5039: 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);
5040: END IF;
5041:
5042: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
5043: RAISE FND_API.g_exc_unexpected_error;

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

5050: END LOOP; --c_get_notes bulk fetch loop
5051: CLOSE c_get_notes;
5052:
5053:
5054: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
5055: 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);
5056: END IF;
5057:
5058: --delete PM schedules

Line 5055: 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);

5051: CLOSE c_get_notes;
5052:
5053:
5054: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
5055: 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);
5056: END IF;
5057:
5058: --delete PM schedules
5059: OKS_PM_PROGRAMS_PVT.undo_pm_line(

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

5063: x_msg_count => x_msg_count,
5064: x_msg_data => x_msg_data,
5065: p_cle_id => p_line_id);
5066:
5067: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
5068: 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);
5069: END IF;
5070:
5071: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN

Line 5068: 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);

5064: x_msg_data => x_msg_data,
5065: p_cle_id => p_line_id);
5066:
5067: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
5068: 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);
5069: END IF;
5070:
5071: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
5072: RAISE FND_API.g_exc_unexpected_error;

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

5088: x_return_status => x_return_status,
5089: x_msg_count => x_msg_count,
5090: x_msg_data => x_msg_data);
5091:
5092: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
5093: 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);
5094: END IF;
5095:
5096: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN

Line 5093: 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);

5089: x_msg_count => x_msg_count,
5090: x_msg_data => x_msg_data);
5091:
5092: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
5093: 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);
5094: END IF;
5095:
5096: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
5097: RAISE FND_API.g_exc_unexpected_error;

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

5106: OPEN c_usage_sub_lines(p_line_id);
5107: LOOP
5108: FETCH c_usage_sub_lines BULK COLLECT INTO l_lock_pl_line_id_tbl LIMIT G_BULK_FETCH_LIMIT;
5109:
5110: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
5111: 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);
5112: END IF;
5113:
5114: EXIT WHEN (l_lock_pl_line_id_tbl.count = 0);

Line 5111: 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);

5107: LOOP
5108: FETCH c_usage_sub_lines BULK COLLECT INTO l_lock_pl_line_id_tbl LIMIT G_BULK_FETCH_LIMIT;
5109:
5110: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
5111: 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);
5112: END IF;
5113:
5114: EXIT WHEN (l_lock_pl_line_id_tbl.count = 0);
5115:

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

5123: x_return_status => x_return_status,
5124: x_msg_count => x_msg_count,
5125: x_msg_data => x_msg_data);
5126:
5127: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
5128: 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);
5129: END IF;
5130:
5131: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN

Line 5128: 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);

5124: x_msg_count => x_msg_count,
5125: x_msg_data => x_msg_data);
5126:
5127: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
5128: 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);
5129: END IF;
5130:
5131: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
5132: RAISE FND_API.g_exc_unexpected_error;

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

5154: x_msg_count => x_msg_count,
5155: x_msg_data => x_msg_data,
5156: p_cle_id => p_line_id);
5157:
5158: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
5159: 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);
5160: END IF;
5161:
5162: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN

Line 5159: 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);

5155: x_msg_data => x_msg_data,
5156: p_cle_id => p_line_id);
5157:
5158: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
5159: 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);
5160: END IF;
5161:
5162: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
5163: RAISE FND_API.g_exc_unexpected_error;

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

5178: x_return_status => x_return_status,
5179: x_msg_count => x_msg_count,
5180: x_msg_data => x_msg_data);
5181:
5182: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
5183: 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);
5184: END IF;
5185:
5186: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN

Line 5183: 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);

5179: x_msg_count => x_msg_count,
5180: x_msg_data => x_msg_data);
5181:
5182: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
5183: 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);
5184: END IF;
5185:
5186: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
5187: RAISE FND_API.g_exc_unexpected_error;

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

5197: x_return_status => x_return_status,
5198: x_msg_count => x_msg_count,
5199: x_msg_data => x_msg_data);
5200:
5201: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
5202: 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);
5203: END IF;
5204:
5205: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN

Line 5202: 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);

5198: x_msg_count => x_msg_count,
5199: x_msg_data => x_msg_data);
5200:
5201: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
5202: 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);
5203: END IF;
5204:
5205: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
5206: RAISE FND_API.g_exc_unexpected_error;

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

5217: --rev distributions, qaulifiers
5218: OPEN c_get_child_lines(p_line_id);
5219: LOOP
5220: FETCH c_get_child_lines BULK COLLECT INTO l_id_tbl LIMIT G_BULK_FETCH_LIMIT;
5221: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
5222: IF (FND_LOG.test(FND_LOG.level_statement, l_mod_name)) THEN
5223: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.c_get_child_lines_bulk_fetch', 'l_id_tbl.count='||l_id_tbl.count);
5224: END IF;
5225: END IF;

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

5218: OPEN c_get_child_lines(p_line_id);
5219: LOOP
5220: FETCH c_get_child_lines BULK COLLECT INTO l_id_tbl LIMIT G_BULK_FETCH_LIMIT;
5221: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
5222: IF (FND_LOG.test(FND_LOG.level_statement, l_mod_name)) THEN
5223: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.c_get_child_lines_bulk_fetch', 'l_id_tbl.count='||l_id_tbl.count);
5224: END IF;
5225: END IF;
5226: EXIT WHEN (l_id_tbl.count = 0);

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

5219: LOOP
5220: FETCH c_get_child_lines BULK COLLECT INTO l_id_tbl LIMIT G_BULK_FETCH_LIMIT;
5221: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
5222: IF (FND_LOG.test(FND_LOG.level_statement, l_mod_name)) THEN
5223: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.c_get_child_lines_bulk_fetch', 'l_id_tbl.count='||l_id_tbl.count);
5224: END IF;
5225: END IF;
5226: EXIT WHEN (l_id_tbl.count = 0);
5227:

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

5248:
5249: END LOOP;
5250: CLOSE c_get_child_lines;
5251:
5252: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
5253: IF (FND_LOG.test(FND_LOG.level_statement, l_mod_name)) THEN
5254: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.delete_oks_entities', 'done');
5255: END IF;
5256: END IF;

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

5249: END LOOP;
5250: CLOSE c_get_child_lines;
5251:
5252: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
5253: IF (FND_LOG.test(FND_LOG.level_statement, l_mod_name)) THEN
5254: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.delete_oks_entities', 'done');
5255: END IF;
5256: END IF;
5257:

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

5250: CLOSE c_get_child_lines;
5251:
5252: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
5253: IF (FND_LOG.test(FND_LOG.level_statement, l_mod_name)) THEN
5254: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.delete_oks_entities', 'done');
5255: END IF;
5256: END IF;
5257:
5258: --call OKC API to delete all OKC lines and entities. This deletes all OKC entities and

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

5256: END IF;
5257:
5258: --call OKC API to delete all OKC lines and entities. This deletes all OKC entities and
5259: --the OKC sublines
5260: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
5261: 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);
5262: END IF;
5263: OKC_CONTRACT_PVT.delete_contract_line(
5264: p_api_version => 1.0,

Line 5261: 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);

5257:
5258: --call OKC API to delete all OKC lines and entities. This deletes all OKC entities and
5259: --the OKC sublines
5260: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
5261: 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);
5262: END IF;
5263: OKC_CONTRACT_PVT.delete_contract_line(
5264: p_api_version => 1.0,
5265: p_init_msg_list => FND_API.G_FALSE,

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

5267: x_msg_count => x_msg_count,
5268: x_msg_data => x_msg_data,
5269: p_line_id => p_line_id);
5270:
5271: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
5272: 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);
5273: END IF;
5274:
5275: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN

Line 5272: 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);

5268: x_msg_data => x_msg_data,
5269: p_line_id => p_line_id);
5270:
5271: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
5272: 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);
5273: END IF;
5274:
5275: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
5276: RAISE FND_API.g_exc_unexpected_error;

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

5282: --standard check of p_commit
5283: IF FND_API.to_boolean( p_commit ) THEN
5284: COMMIT;
5285: END IF;
5286: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
5287: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.end', ' x_return_status='|| x_return_status);
5288: END IF;
5289: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
5290:

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

5283: IF FND_API.to_boolean( p_commit ) THEN
5284: COMMIT;
5285: END IF;
5286: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
5287: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.end', ' x_return_status='|| x_return_status);
5288: END IF;
5289: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
5290:
5291: EXCEPTION

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

5292: WHEN FND_API.g_exc_error THEN
5293: ROLLBACK TO delete_top_sub_line_PUB;
5294: x_return_status := FND_API.g_ret_sts_error ;
5295:
5296: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
5297: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_error', 'x_return_status=' || x_return_status);
5298: END IF;
5299: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
5300:

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

5293: ROLLBACK TO delete_top_sub_line_PUB;
5294: x_return_status := FND_API.g_ret_sts_error ;
5295:
5296: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
5297: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_error', 'x_return_status=' || x_return_status);
5298: END IF;
5299: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
5300:
5301: IF (c_get_line_type%isopen) THEN

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

5323: WHEN FND_API.g_exc_unexpected_error THEN
5324: ROLLBACK TO delete_top_sub_line_PUB;
5325: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5326:
5327: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
5328: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_unexpected_error', 'x_return_status=' || x_return_status);
5329: END IF;
5330: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
5331:

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

5324: ROLLBACK TO delete_top_sub_line_PUB;
5325: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5326:
5327: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
5328: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_unexpected_error', 'x_return_status=' || x_return_status);
5329: END IF;
5330: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
5331:
5332: IF (c_get_line_type%isopen) THEN

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

5354: WHEN OTHERS THEN
5355: ROLLBACK TO delete_top_sub_line_PUB;
5356: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5357:
5358: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
5359: --first log the sqlerrm
5360: l_error_text := substr (SQLERRM, 1, 240);
5361: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
5362: --then add it to the message api list

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

5357:
5358: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
5359: --first log the sqlerrm
5360: l_error_text := substr (SQLERRM, 1, 240);
5361: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
5362: --then add it to the message api list
5363: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
5364: END IF;
5365: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );