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_API

Line 4792: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

4788:
4789: PROCEDURE DELETE_TOP_SUB_LINE
4790: (
4791: p_api_version IN NUMBER,
4792: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
4793: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
4794: p_line_id IN NUMBER,
4795: x_return_status OUT NOCOPY VARCHAR2,
4796: x_msg_count OUT NOCOPY NUMBER,

Line 4793: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

4789: PROCEDURE DELETE_TOP_SUB_LINE
4790: (
4791: p_api_version IN NUMBER,
4792: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
4793: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
4794: p_line_id IN NUMBER,
4795: x_return_status OUT NOCOPY VARCHAR2,
4796: x_msg_count OUT NOCOPY NUMBER,
4797: x_msg_data OUT NOCOPY VARCHAR2

Line 4879: IF NOT FND_API.compatible_api_call (l_api_version, p_api_version, l_api_name, G_PKG_NAME)THEN

4875: END IF;
4876:
4877: --standard api initilization and checks
4878: SAVEPOINT delete_top_sub_line_PUB;
4879: IF NOT FND_API.compatible_api_call (l_api_version, p_api_version, l_api_name, G_PKG_NAME)THEN
4880: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4881: END IF;
4882: IF FND_API.to_boolean(p_init_msg_list ) THEN
4883: FND_MSG_PUB.initialize;

Line 4880: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4876:
4877: --standard api initilization and checks
4878: SAVEPOINT delete_top_sub_line_PUB;
4879: IF NOT FND_API.compatible_api_call (l_api_version, p_api_version, l_api_name, G_PKG_NAME)THEN
4880: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4881: END IF;
4882: IF FND_API.to_boolean(p_init_msg_list ) THEN
4883: FND_MSG_PUB.initialize;
4884: END IF;

Line 4882: IF FND_API.to_boolean(p_init_msg_list ) THEN

4878: SAVEPOINT delete_top_sub_line_PUB;
4879: IF NOT FND_API.compatible_api_call (l_api_version, p_api_version, l_api_name, G_PKG_NAME)THEN
4880: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4881: END IF;
4882: IF FND_API.to_boolean(p_init_msg_list ) THEN
4883: FND_MSG_PUB.initialize;
4884: END IF;
4885: x_return_status := FND_API.G_RET_STS_SUCCESS;
4886:

Line 4885: x_return_status := FND_API.G_RET_STS_SUCCESS;

4881: END IF;
4882: IF FND_API.to_boolean(p_init_msg_list ) THEN
4883: FND_MSG_PUB.initialize;
4884: END IF;
4885: x_return_status := FND_API.G_RET_STS_SUCCESS;
4886:
4887: OPEN c_get_line_type(p_line_id);
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;

Line 4920: RAISE FND_API.g_exc_error;

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;
4922:
4923:
4924: --first delete the trxn_extension_id (credit card) if present

Line 4956: p_init_msg_list => FND_API.G_FALSE,

4952: END IF;
4953:
4954: IBY_FNDCPT_TRXN_PUB.delete_transaction_extension(
4955: p_api_version => 1.0,
4956: p_init_msg_list => FND_API.G_FALSE,
4957: p_commit => FND_API.G_FALSE,
4958: x_return_status => x_return_status,
4959: x_msg_count => x_msg_count,
4960: x_msg_data => x_msg_data,

Line 4957: p_commit => FND_API.G_FALSE,

4953:
4954: IBY_FNDCPT_TRXN_PUB.delete_transaction_extension(
4955: p_api_version => 1.0,
4956: p_init_msg_list => FND_API.G_FALSE,
4957: p_commit => FND_API.G_FALSE,
4958: x_return_status => x_return_status,
4959: x_msg_count => x_msg_count,
4960: x_msg_data => x_msg_data,
4961: p_payer => l_payer,

Line 4972: IF x_return_status = FND_API.g_ret_sts_unexp_error 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
4973: RAISE FND_API.g_exc_unexpected_error;
4974: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
4975: RAISE FND_API.g_exc_error;
4976: END IF;

Line 4973: RAISE FND_API.g_exc_unexpected_error;

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
4973: RAISE FND_API.g_exc_unexpected_error;
4974: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
4975: RAISE FND_API.g_exc_error;
4976: END IF;
4977:

Line 4974: ELSIF x_return_status = FND_API.g_ret_sts_error THEN

4970: END IF;
4971:
4972: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
4973: RAISE FND_API.g_exc_unexpected_error;
4974: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
4975: RAISE FND_API.g_exc_error;
4976: END IF;
4977:
4978: --also check the pmt api result code

Line 4975: RAISE FND_API.g_exc_error;

4971:
4972: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
4973: RAISE FND_API.g_exc_unexpected_error;
4974: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
4975: RAISE FND_API.g_exc_error;
4976: END IF;
4977:
4978: --also check the pmt api result code
4979: IF (l_response.result_code <> IBY_FNDCPT_COMMON_PUB.G_RC_SUCCESS) THEN

Line 4981: RAISE FND_API.g_exc_error;

4977:
4978: --also check the pmt api result code
4979: IF (l_response.result_code <> IBY_FNDCPT_COMMON_PUB.G_RC_SUCCESS) THEN
4980: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_response.result_message||'('||l_response.result_code||':'||l_response.result_category||')');
4981: RAISE FND_API.g_exc_error;
4982: END IF;
4983:
4984: END IF;
4985: END IF;

Line 4992: p_init_msg_list => FND_API.G_FALSE,

4988: IF l_lse_id IN (1, 14, 19) THEN
4989: -- Deletes coverages and coverage entities
4990: OKS_COVERAGES_PUB.delete_coverage(
4991: p_api_version => 1.0,
4992: p_init_msg_list => FND_API.G_FALSE,
4993: x_return_status => x_return_status,
4994: x_msg_count => x_msg_count,
4995: x_msg_data => x_msg_data,
4996: p_service_line_id => p_line_id);

Line 5002: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN

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;
5004: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
5005: RAISE FND_API.g_exc_error;
5006: END IF;

Line 5003: RAISE FND_API.g_exc_unexpected_error;

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;
5004: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
5005: RAISE FND_API.g_exc_error;
5006: END IF;
5007:

Line 5004: ELSIF x_return_status = FND_API.g_ret_sts_error THEN

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;
5004: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
5005: RAISE FND_API.g_exc_error;
5006: END IF;
5007:
5008: --delete coverage notes if any

Line 5005: RAISE FND_API.g_exc_error;

5001:
5002: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
5003: RAISE FND_API.g_exc_unexpected_error;
5004: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
5005: RAISE FND_API.g_exc_error;
5006: END IF;
5007:
5008: --delete coverage notes if any
5009: OPEN c_get_notes(p_line_id);

Line 5028: p_init_msg_list => FND_API.G_FALSE,

5024: END IF;
5025:
5026: JTF_NOTES_PUB.secure_delete_note(
5027: p_api_version => 1.0,
5028: p_init_msg_list => FND_API.G_FALSE,
5029: p_commit => FND_API.G_FALSE,
5030: p_validation_level => 100,
5031: x_return_status => x_return_status,
5032: x_msg_count => x_msg_count,

Line 5029: p_commit => FND_API.G_FALSE,

5025:
5026: JTF_NOTES_PUB.secure_delete_note(
5027: p_api_version => 1.0,
5028: p_init_msg_list => FND_API.G_FALSE,
5029: p_commit => FND_API.G_FALSE,
5030: p_validation_level => 100,
5031: x_return_status => x_return_status,
5032: x_msg_count => x_msg_count,
5033: x_msg_data => x_msg_data ,

Line 5035: p_use_AOL_security => FND_API.G_FALSE);

5031: x_return_status => x_return_status,
5032: x_msg_count => x_msg_count,
5033: x_msg_data => x_msg_data ,
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);

Line 5042: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN

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;
5044: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
5045: RAISE FND_API.g_exc_error;
5046: END IF;

Line 5043: RAISE FND_API.g_exc_unexpected_error;

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;
5044: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
5045: RAISE FND_API.g_exc_error;
5046: END IF;
5047:

Line 5044: ELSIF x_return_status = FND_API.g_ret_sts_error THEN

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;
5044: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
5045: RAISE FND_API.g_exc_error;
5046: END IF;
5047:
5048: END LOOP; --of FOR i in l_jtf_note_id_tbl.first..

Line 5045: RAISE FND_API.g_exc_error;

5041:
5042: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
5043: RAISE FND_API.g_exc_unexpected_error;
5044: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
5045: RAISE FND_API.g_exc_error;
5046: END IF;
5047:
5048: END LOOP; --of FOR i in l_jtf_note_id_tbl.first..
5049:

Line 5061: p_init_msg_list => FND_API.G_FALSE,

5057:
5058: --delete PM schedules
5059: OKS_PM_PROGRAMS_PVT.undo_pm_line(
5060: p_api_version => 1.0,
5061: p_init_msg_list => FND_API.G_FALSE,
5062: x_return_status => x_return_status,
5063: x_msg_count => x_msg_count,
5064: x_msg_data => x_msg_data,
5065: p_cle_id => p_line_id);

Line 5071: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN

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;
5073: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
5074: RAISE FND_API.g_exc_error;
5075: END IF;

Line 5072: RAISE FND_API.g_exc_unexpected_error;

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;
5073: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
5074: RAISE FND_API.g_exc_error;
5075: END IF;
5076:

Line 5073: ELSIF x_return_status = FND_API.g_ret_sts_error THEN

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;
5073: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
5074: RAISE FND_API.g_exc_error;
5075: END IF;
5076:
5077: END IF; --of IF l_lse_id IN (1, 14, 19) THEN

Line 5074: RAISE FND_API.g_exc_error;

5070:
5071: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
5072: RAISE FND_API.g_exc_unexpected_error;
5073: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
5074: RAISE FND_API.g_exc_error;
5075: END IF;
5076:
5077: END IF; --of IF l_lse_id IN (1, 14, 19) THEN
5078:

Line 5087: p_init_msg_list => FND_API.G_FALSE,

5083: IF l_lock_pl_line_id IS NOT NULL THEN
5084: OKS_QP_PKG.delete_locked_pricebreaks(
5085: p_api_version => 1.0,
5086: p_list_line_id => l_lock_pl_line_id,
5087: p_init_msg_list => FND_API.G_FALSE,
5088: x_return_status => x_return_status,
5089: x_msg_count => x_msg_count,
5090: x_msg_data => x_msg_data);
5091:

Line 5096: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN

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;
5098: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
5099: RAISE FND_API.g_exc_error;
5100: END IF;

Line 5097: RAISE FND_API.g_exc_unexpected_error;

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;
5098: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
5099: RAISE FND_API.g_exc_error;
5100: END IF;
5101: END IF;

Line 5098: ELSIF x_return_status = FND_API.g_ret_sts_error THEN

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;
5098: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
5099: RAISE FND_API.g_exc_error;
5100: END IF;
5101: END IF;
5102:

Line 5099: RAISE FND_API.g_exc_error;

5095:
5096: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
5097: RAISE FND_API.g_exc_unexpected_error;
5098: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
5099: RAISE FND_API.g_exc_error;
5100: END IF;
5101: END IF;
5102:
5103: --if usage top line, then delete price breaks for all usage sublines also

Line 5122: p_init_msg_list => FND_API.G_FALSE,

5118: IF (l_lock_pl_line_id_tbl(i) IS NOT NULL) THEN
5119: OKS_QP_PKG.delete_locked_pricebreaks(
5120: p_api_version => 1.0,
5121: p_list_line_id => l_lock_pl_line_id_tbl(i),
5122: p_init_msg_list => FND_API.G_FALSE,
5123: x_return_status => x_return_status,
5124: x_msg_count => x_msg_count,
5125: x_msg_data => x_msg_data);
5126:

Line 5131: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN

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;
5133: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
5134: RAISE FND_API.g_exc_error;
5135: END IF;

Line 5132: RAISE FND_API.g_exc_unexpected_error;

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;
5133: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
5134: RAISE FND_API.g_exc_error;
5135: END IF;
5136:

Line 5133: ELSIF x_return_status = FND_API.g_ret_sts_error THEN

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;
5133: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
5134: RAISE FND_API.g_exc_error;
5135: END IF;
5136:
5137: END IF; --of IF (l_lock_pl_line_id IS NOT NULL) THEN

Line 5134: RAISE FND_API.g_exc_error;

5130:
5131: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
5132: RAISE FND_API.g_exc_unexpected_error;
5133: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
5134: RAISE FND_API.g_exc_error;
5135: END IF;
5136:
5137: END IF; --of IF (l_lock_pl_line_id IS NOT NULL) THEN
5138:

Line 5152: p_init_msg_list => FND_API.G_FALSE,

5148: --delete subscription information
5149: IF (l_lse_id = 46) THEN
5150: OKS_SUBSCRIPTION_PUB.undo_subscription(
5151: p_api_version => 1.0,
5152: p_init_msg_list => FND_API.G_FALSE,
5153: x_return_status => x_return_status,
5154: x_msg_count => x_msg_count,
5155: x_msg_data => x_msg_data,
5156: p_cle_id => p_line_id);

Line 5162: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN

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;
5164: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
5165: RAISE FND_API.g_exc_error;
5166: END IF;

Line 5163: RAISE FND_API.g_exc_unexpected_error;

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;
5164: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
5165: RAISE FND_API.g_exc_error;
5166: END IF;
5167:

Line 5164: ELSIF x_return_status = FND_API.g_ret_sts_error THEN

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;
5164: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
5165: RAISE FND_API.g_exc_error;
5166: END IF;
5167:
5168: END IF;

Line 5165: RAISE FND_API.g_exc_error;

5161:
5162: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
5163: RAISE FND_API.g_exc_unexpected_error;
5164: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
5165: RAISE FND_API.g_exc_error;
5166: END IF;
5167:
5168: END IF;
5169:

Line 5186: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN

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;
5188: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
5189: RAISE FND_API.g_exc_error;
5190: END IF;

Line 5187: RAISE FND_API.g_exc_unexpected_error;

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;
5188: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
5189: RAISE FND_API.g_exc_error;
5190: END IF;
5191:

Line 5188: ELSIF x_return_status = FND_API.g_ret_sts_error THEN

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;
5188: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
5189: RAISE FND_API.g_exc_error;
5190: END IF;
5191:
5192: ELSE

Line 5189: RAISE FND_API.g_exc_error;

5185:
5186: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
5187: RAISE FND_API.g_exc_unexpected_error;
5188: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
5189: RAISE FND_API.g_exc_error;
5190: END IF;
5191:
5192: ELSE
5193:

Line 5205: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN

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;
5207: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
5208: RAISE FND_API.g_exc_error;
5209: END IF;

Line 5206: RAISE FND_API.g_exc_unexpected_error;

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;
5207: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
5208: RAISE FND_API.g_exc_error;
5209: END IF;
5210:

Line 5207: ELSIF x_return_status = FND_API.g_ret_sts_error THEN

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;
5207: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
5208: RAISE FND_API.g_exc_error;
5209: END IF;
5210:
5211: END IF; --of IF l_parent_id IS NULL THEN

Line 5208: RAISE FND_API.g_exc_error;

5204:
5205: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
5206: RAISE FND_API.g_exc_unexpected_error;
5207: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
5208: RAISE FND_API.g_exc_error;
5209: END IF;
5210:
5211: END IF; --of IF l_parent_id IS NULL THEN
5212: END IF; --of IF l_lse_id IN (1, 7, 8, 9, 10, 11, 12, 13, 14, 18, 19, 25, 35, 46) THEN

Line 5265: p_init_msg_list => FND_API.G_FALSE,

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,
5266: x_return_status => x_return_status,
5267: x_msg_count => x_msg_count,
5268: x_msg_data => x_msg_data,
5269: p_line_id => p_line_id);

Line 5275: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN

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;
5277: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
5278: RAISE FND_API.g_exc_error;
5279: END IF;

Line 5276: RAISE FND_API.g_exc_unexpected_error;

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;
5277: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
5278: RAISE FND_API.g_exc_error;
5279: END IF;
5280:

Line 5277: ELSIF x_return_status = FND_API.g_ret_sts_error THEN

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;
5277: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
5278: RAISE FND_API.g_exc_error;
5279: END IF;
5280:
5281:

Line 5278: RAISE FND_API.g_exc_error;

5274:
5275: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
5276: RAISE FND_API.g_exc_unexpected_error;
5277: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
5278: RAISE FND_API.g_exc_error;
5279: END IF;
5280:
5281:
5282: --standard check of p_commit

Line 5283: IF FND_API.to_boolean( p_commit ) THEN

5279: END IF;
5280:
5281:
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);

Line 5292: WHEN FND_API.g_exc_error THEN

5288: END IF;
5289: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
5290:
5291: EXCEPTION
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

Line 5294: x_return_status := FND_API.g_ret_sts_error ;

5290:
5291: EXCEPTION
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;

Line 5323: WHEN FND_API.g_exc_unexpected_error THEN

5319: IF (c_get_notes%isopen) THEN
5320: CLOSE c_get_notes;
5321: END IF;
5322:
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

Line 5325: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

5321: END IF;
5322:
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;

Line 5356: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

5352: END IF;
5353:
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);