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 4801: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

4797:
4798: PROCEDURE DELETE_TOP_SUB_LINE
4799: (
4800: p_api_version IN NUMBER,
4801: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
4802: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
4803: p_line_id IN NUMBER,
4804: x_return_status OUT NOCOPY VARCHAR2,
4805: x_msg_count OUT NOCOPY NUMBER,

Line 4802: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

4798: PROCEDURE DELETE_TOP_SUB_LINE
4799: (
4800: p_api_version IN NUMBER,
4801: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
4802: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
4803: p_line_id IN NUMBER,
4804: x_return_status OUT NOCOPY VARCHAR2,
4805: x_msg_count OUT NOCOPY NUMBER,
4806: x_msg_data OUT NOCOPY VARCHAR2

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

4884: END IF;
4885:
4886: --standard api initilization and checks
4887: SAVEPOINT delete_top_sub_line_PUB;
4888: IF NOT FND_API.compatible_api_call (l_api_version, p_api_version, l_api_name, G_PKG_NAME)THEN
4889: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4890: END IF;
4891: IF FND_API.to_boolean(p_init_msg_list ) THEN
4892: FND_MSG_PUB.initialize;

Line 4889: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4885:
4886: --standard api initilization and checks
4887: SAVEPOINT delete_top_sub_line_PUB;
4888: IF NOT FND_API.compatible_api_call (l_api_version, p_api_version, l_api_name, G_PKG_NAME)THEN
4889: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4890: END IF;
4891: IF FND_API.to_boolean(p_init_msg_list ) THEN
4892: FND_MSG_PUB.initialize;
4893: END IF;

Line 4891: IF FND_API.to_boolean(p_init_msg_list ) THEN

4887: SAVEPOINT delete_top_sub_line_PUB;
4888: IF NOT FND_API.compatible_api_call (l_api_version, p_api_version, l_api_name, G_PKG_NAME)THEN
4889: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4890: END IF;
4891: IF FND_API.to_boolean(p_init_msg_list ) THEN
4892: FND_MSG_PUB.initialize;
4893: END IF;
4894: x_return_status := FND_API.G_RET_STS_SUCCESS;
4895:

Line 4894: x_return_status := FND_API.G_RET_STS_SUCCESS;

4890: END IF;
4891: IF FND_API.to_boolean(p_init_msg_list ) THEN
4892: FND_MSG_PUB.initialize;
4893: END IF;
4894: x_return_status := FND_API.G_RET_STS_SUCCESS;
4895:
4896: OPEN c_get_line_type(p_line_id);
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;

Line 4929: RAISE FND_API.g_exc_error;

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;
4931:
4932:
4933: --first delete the trxn_extension_id (credit card) if present

Line 4965: p_init_msg_list => FND_API.G_FALSE,

4961: END IF;
4962:
4963: IBY_FNDCPT_TRXN_PUB.delete_transaction_extension(
4964: p_api_version => 1.0,
4965: p_init_msg_list => FND_API.G_FALSE,
4966: p_commit => FND_API.G_FALSE,
4967: x_return_status => x_return_status,
4968: x_msg_count => x_msg_count,
4969: x_msg_data => x_msg_data,

Line 4966: p_commit => FND_API.G_FALSE,

4962:
4963: IBY_FNDCPT_TRXN_PUB.delete_transaction_extension(
4964: p_api_version => 1.0,
4965: p_init_msg_list => FND_API.G_FALSE,
4966: p_commit => FND_API.G_FALSE,
4967: x_return_status => x_return_status,
4968: x_msg_count => x_msg_count,
4969: x_msg_data => x_msg_data,
4970: p_payer => l_payer,

Line 4981: IF x_return_status = FND_API.g_ret_sts_unexp_error 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
4982: RAISE FND_API.g_exc_unexpected_error;
4983: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
4984: RAISE FND_API.g_exc_error;
4985: END IF;

Line 4982: RAISE FND_API.g_exc_unexpected_error;

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
4982: RAISE FND_API.g_exc_unexpected_error;
4983: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
4984: RAISE FND_API.g_exc_error;
4985: END IF;
4986:

Line 4983: ELSIF x_return_status = FND_API.g_ret_sts_error THEN

4979: END IF;
4980:
4981: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
4982: RAISE FND_API.g_exc_unexpected_error;
4983: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
4984: RAISE FND_API.g_exc_error;
4985: END IF;
4986:
4987: --also check the pmt api result code

Line 4984: RAISE FND_API.g_exc_error;

4980:
4981: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
4982: RAISE FND_API.g_exc_unexpected_error;
4983: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
4984: RAISE FND_API.g_exc_error;
4985: END IF;
4986:
4987: --also check the pmt api result code
4988: IF (l_response.result_code <> IBY_FNDCPT_COMMON_PUB.G_RC_SUCCESS) THEN

Line 4990: RAISE FND_API.g_exc_error;

4986:
4987: --also check the pmt api result code
4988: IF (l_response.result_code <> IBY_FNDCPT_COMMON_PUB.G_RC_SUCCESS) THEN
4989: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_response.result_message||'('||l_response.result_code||':'||l_response.result_category||')');
4990: RAISE FND_API.g_exc_error;
4991: END IF;
4992:
4993: END IF;
4994: END IF;

Line 5001: p_init_msg_list => FND_API.G_FALSE,

4997: IF l_lse_id IN (1, 14, 19) THEN
4998: -- Deletes coverages and coverage entities
4999: OKS_COVERAGES_PUB.delete_coverage(
5000: p_api_version => 1.0,
5001: p_init_msg_list => FND_API.G_FALSE,
5002: x_return_status => x_return_status,
5003: x_msg_count => x_msg_count,
5004: x_msg_data => x_msg_data,
5005: p_service_line_id => p_line_id);

Line 5011: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN

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;
5013: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
5014: RAISE FND_API.g_exc_error;
5015: END IF;

Line 5012: RAISE FND_API.g_exc_unexpected_error;

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;
5013: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
5014: RAISE FND_API.g_exc_error;
5015: END IF;
5016:

Line 5013: ELSIF x_return_status = FND_API.g_ret_sts_error THEN

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;
5013: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
5014: RAISE FND_API.g_exc_error;
5015: END IF;
5016:
5017: --delete coverage notes if any

Line 5014: RAISE FND_API.g_exc_error;

5010:
5011: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
5012: RAISE FND_API.g_exc_unexpected_error;
5013: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
5014: RAISE FND_API.g_exc_error;
5015: END IF;
5016:
5017: --delete coverage notes if any
5018: OPEN c_get_notes(p_line_id);

Line 5037: p_init_msg_list => FND_API.G_FALSE,

5033: END IF;
5034:
5035: JTF_NOTES_PUB.secure_delete_note(
5036: p_api_version => 1.0,
5037: p_init_msg_list => FND_API.G_FALSE,
5038: p_commit => FND_API.G_FALSE,
5039: p_validation_level => 100,
5040: x_return_status => x_return_status,
5041: x_msg_count => x_msg_count,

Line 5038: p_commit => FND_API.G_FALSE,

5034:
5035: JTF_NOTES_PUB.secure_delete_note(
5036: p_api_version => 1.0,
5037: p_init_msg_list => FND_API.G_FALSE,
5038: p_commit => FND_API.G_FALSE,
5039: p_validation_level => 100,
5040: x_return_status => x_return_status,
5041: x_msg_count => x_msg_count,
5042: x_msg_data => x_msg_data ,

Line 5044: p_use_AOL_security => FND_API.G_FALSE);

5040: x_return_status => x_return_status,
5041: x_msg_count => x_msg_count,
5042: x_msg_data => x_msg_data ,
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);

Line 5051: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN

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;
5053: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
5054: RAISE FND_API.g_exc_error;
5055: END IF;

Line 5052: RAISE FND_API.g_exc_unexpected_error;

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;
5053: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
5054: RAISE FND_API.g_exc_error;
5055: END IF;
5056:

Line 5053: ELSIF x_return_status = FND_API.g_ret_sts_error THEN

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;
5053: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
5054: RAISE FND_API.g_exc_error;
5055: END IF;
5056:
5057: END LOOP; --of FOR i in l_jtf_note_id_tbl.first..

Line 5054: RAISE FND_API.g_exc_error;

5050:
5051: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
5052: RAISE FND_API.g_exc_unexpected_error;
5053: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
5054: RAISE FND_API.g_exc_error;
5055: END IF;
5056:
5057: END LOOP; --of FOR i in l_jtf_note_id_tbl.first..
5058:

Line 5070: p_init_msg_list => FND_API.G_FALSE,

5066:
5067: --delete PM schedules
5068: OKS_PM_PROGRAMS_PVT.undo_pm_line(
5069: p_api_version => 1.0,
5070: p_init_msg_list => FND_API.G_FALSE,
5071: x_return_status => x_return_status,
5072: x_msg_count => x_msg_count,
5073: x_msg_data => x_msg_data,
5074: p_cle_id => p_line_id);

Line 5080: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN

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;
5082: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
5083: RAISE FND_API.g_exc_error;
5084: END IF;

Line 5081: RAISE FND_API.g_exc_unexpected_error;

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;
5082: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
5083: RAISE FND_API.g_exc_error;
5084: END IF;
5085:

Line 5082: ELSIF x_return_status = FND_API.g_ret_sts_error THEN

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;
5082: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
5083: RAISE FND_API.g_exc_error;
5084: END IF;
5085:
5086: END IF; --of IF l_lse_id IN (1, 14, 19) THEN

Line 5083: RAISE FND_API.g_exc_error;

5079:
5080: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
5081: RAISE FND_API.g_exc_unexpected_error;
5082: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
5083: RAISE FND_API.g_exc_error;
5084: END IF;
5085:
5086: END IF; --of IF l_lse_id IN (1, 14, 19) THEN
5087:

Line 5096: p_init_msg_list => FND_API.G_FALSE,

5092: IF l_lock_pl_line_id IS NOT NULL THEN
5093: OKS_QP_PKG.delete_locked_pricebreaks(
5094: p_api_version => 1.0,
5095: p_list_line_id => l_lock_pl_line_id,
5096: p_init_msg_list => FND_API.G_FALSE,
5097: x_return_status => x_return_status,
5098: x_msg_count => x_msg_count,
5099: x_msg_data => x_msg_data);
5100:

Line 5105: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN

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;
5107: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
5108: RAISE FND_API.g_exc_error;
5109: END IF;

Line 5106: RAISE FND_API.g_exc_unexpected_error;

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;
5107: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
5108: RAISE FND_API.g_exc_error;
5109: END IF;
5110: END IF;

Line 5107: ELSIF x_return_status = FND_API.g_ret_sts_error THEN

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;
5107: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
5108: RAISE FND_API.g_exc_error;
5109: END IF;
5110: END IF;
5111:

Line 5108: RAISE FND_API.g_exc_error;

5104:
5105: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
5106: RAISE FND_API.g_exc_unexpected_error;
5107: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
5108: RAISE FND_API.g_exc_error;
5109: END IF;
5110: END IF;
5111:
5112: --if usage top line, then delete price breaks for all usage sublines also

Line 5131: p_init_msg_list => FND_API.G_FALSE,

5127: IF (l_lock_pl_line_id_tbl(i) IS NOT NULL) THEN
5128: OKS_QP_PKG.delete_locked_pricebreaks(
5129: p_api_version => 1.0,
5130: p_list_line_id => l_lock_pl_line_id_tbl(i),
5131: p_init_msg_list => FND_API.G_FALSE,
5132: x_return_status => x_return_status,
5133: x_msg_count => x_msg_count,
5134: x_msg_data => x_msg_data);
5135:

Line 5140: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN

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;
5142: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
5143: RAISE FND_API.g_exc_error;
5144: END IF;

Line 5141: RAISE FND_API.g_exc_unexpected_error;

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;
5142: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
5143: RAISE FND_API.g_exc_error;
5144: END IF;
5145:

Line 5142: ELSIF x_return_status = FND_API.g_ret_sts_error THEN

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;
5142: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
5143: RAISE FND_API.g_exc_error;
5144: END IF;
5145:
5146: END IF; --of IF (l_lock_pl_line_id IS NOT NULL) THEN

Line 5143: RAISE FND_API.g_exc_error;

5139:
5140: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
5141: RAISE FND_API.g_exc_unexpected_error;
5142: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
5143: RAISE FND_API.g_exc_error;
5144: END IF;
5145:
5146: END IF; --of IF (l_lock_pl_line_id IS NOT NULL) THEN
5147:

Line 5161: p_init_msg_list => FND_API.G_FALSE,

5157: --delete subscription information
5158: IF (l_lse_id = 46) THEN
5159: OKS_SUBSCRIPTION_PUB.undo_subscription(
5160: p_api_version => 1.0,
5161: p_init_msg_list => FND_API.G_FALSE,
5162: x_return_status => x_return_status,
5163: x_msg_count => x_msg_count,
5164: x_msg_data => x_msg_data,
5165: p_cle_id => p_line_id);

Line 5171: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN

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;
5173: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
5174: RAISE FND_API.g_exc_error;
5175: END IF;

Line 5172: RAISE FND_API.g_exc_unexpected_error;

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;
5173: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
5174: RAISE FND_API.g_exc_error;
5175: END IF;
5176:

Line 5173: ELSIF x_return_status = FND_API.g_ret_sts_error THEN

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;
5173: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
5174: RAISE FND_API.g_exc_error;
5175: END IF;
5176:
5177: END IF;

Line 5174: RAISE FND_API.g_exc_error;

5170:
5171: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
5172: RAISE FND_API.g_exc_unexpected_error;
5173: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
5174: RAISE FND_API.g_exc_error;
5175: END IF;
5176:
5177: END IF;
5178:

Line 5195: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN

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;
5197: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
5198: RAISE FND_API.g_exc_error;
5199: END IF;

Line 5196: RAISE FND_API.g_exc_unexpected_error;

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;
5197: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
5198: RAISE FND_API.g_exc_error;
5199: END IF;
5200:

Line 5197: ELSIF x_return_status = FND_API.g_ret_sts_error THEN

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;
5197: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
5198: RAISE FND_API.g_exc_error;
5199: END IF;
5200:
5201: ELSE

Line 5198: RAISE FND_API.g_exc_error;

5194:
5195: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
5196: RAISE FND_API.g_exc_unexpected_error;
5197: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
5198: RAISE FND_API.g_exc_error;
5199: END IF;
5200:
5201: ELSE
5202:

Line 5214: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN

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;
5216: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
5217: RAISE FND_API.g_exc_error;
5218: END IF;

Line 5215: RAISE FND_API.g_exc_unexpected_error;

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;
5216: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
5217: RAISE FND_API.g_exc_error;
5218: END IF;
5219:

Line 5216: ELSIF x_return_status = FND_API.g_ret_sts_error THEN

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;
5216: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
5217: RAISE FND_API.g_exc_error;
5218: END IF;
5219:
5220: END IF; --of IF l_parent_id IS NULL THEN

Line 5217: RAISE FND_API.g_exc_error;

5213:
5214: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
5215: RAISE FND_API.g_exc_unexpected_error;
5216: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
5217: RAISE FND_API.g_exc_error;
5218: END IF;
5219:
5220: END IF; --of IF l_parent_id IS NULL THEN
5221: END IF; --of IF l_lse_id IN (1, 7, 8, 9, 10, 11, 12, 13, 14, 18, 19, 25, 35, 46) THEN

Line 5274: p_init_msg_list => FND_API.G_FALSE,

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,
5275: x_return_status => x_return_status,
5276: x_msg_count => x_msg_count,
5277: x_msg_data => x_msg_data,
5278: p_line_id => p_line_id);

Line 5284: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN

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;
5286: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
5287: RAISE FND_API.g_exc_error;
5288: END IF;

Line 5285: RAISE FND_API.g_exc_unexpected_error;

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;
5286: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
5287: RAISE FND_API.g_exc_error;
5288: END IF;
5289:

Line 5286: ELSIF x_return_status = FND_API.g_ret_sts_error THEN

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;
5286: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
5287: RAISE FND_API.g_exc_error;
5288: END IF;
5289:
5290:

Line 5287: RAISE FND_API.g_exc_error;

5283:
5284: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
5285: RAISE FND_API.g_exc_unexpected_error;
5286: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
5287: RAISE FND_API.g_exc_error;
5288: END IF;
5289:
5290:
5291: --standard check of p_commit

Line 5292: IF FND_API.to_boolean( p_commit ) THEN

5288: END IF;
5289:
5290:
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);

Line 5301: WHEN FND_API.g_exc_error THEN

5297: END IF;
5298: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
5299:
5300: EXCEPTION
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

Line 5303: x_return_status := FND_API.g_ret_sts_error ;

5299:
5300: EXCEPTION
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;

Line 5332: WHEN FND_API.g_exc_unexpected_error THEN

5328: IF (c_get_notes%isopen) THEN
5329: CLOSE c_get_notes;
5330: END IF;
5331:
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

Line 5334: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

5330: END IF;
5331:
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;

Line 5365: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

5361: END IF;
5362:
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);