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_RENCON_PVT dependencies on FND_API

Line 1781: l_init_msg_list VARCHAR2(2000) := FND_API.G_TRUE;

1777: p_oie_id IN NUMBER) IS
1778: l_errbuf VARCHAR2(200);
1779: l_retcode NUMBER;
1780: l_api_version CONSTANT NUMBER := 1.0;
1781: l_init_msg_list VARCHAR2(2000) := FND_API.G_TRUE;
1782: l_return_status VARCHAR2(1);
1783: l_msg_count NUMBER;
1784: l_msg_data VARCHAR2(2000);
1785:

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

1975: END IF;
1976:
1977: --standard api initilization and checks
1978: SAVEPOINT submit_PVT;
1979: IF NOT FND_API.compatible_api_call (l_api_version, p_api_version, l_api_name, G_PKG_NAME)THEN
1980: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1981: END IF;
1982: IF FND_API.to_boolean(p_init_msg_list ) THEN
1983: FND_MSG_PUB.initialize;

Line 1980: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1976:
1977: --standard api initilization and checks
1978: SAVEPOINT submit_PVT;
1979: IF NOT FND_API.compatible_api_call (l_api_version, p_api_version, l_api_name, G_PKG_NAME)THEN
1980: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1981: END IF;
1982: IF FND_API.to_boolean(p_init_msg_list ) THEN
1983: FND_MSG_PUB.initialize;
1984: END IF;

Line 1982: IF FND_API.to_boolean(p_init_msg_list ) THEN

1978: SAVEPOINT submit_PVT;
1979: IF NOT FND_API.compatible_api_call (l_api_version, p_api_version, l_api_name, G_PKG_NAME)THEN
1980: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1981: END IF;
1982: IF FND_API.to_boolean(p_init_msg_list ) THEN
1983: FND_MSG_PUB.initialize;
1984: END IF;
1985:
1986: -- Added by MSENGUPT 11/07

Line 2048: x_return_status := FND_API.G_RET_STS_SUCCESS;

2044: LOG_MESSAGES(' ');
2045:
2046: -- End of Added by MSENGUPT 11/07
2047:
2048: x_return_status := FND_API.G_RET_STS_SUCCESS;
2049: l_return_status := FND_API.G_RET_STS_SUCCESS;
2050: retcode := 0; --0 for success, 1 for warning, 2 for error
2051: errbuf := NULL;
2052: l_conc_program := p_conc_program;

Line 2049: l_return_status := FND_API.G_RET_STS_SUCCESS;

2045:
2046: -- End of Added by MSENGUPT 11/07
2047:
2048: x_return_status := FND_API.G_RET_STS_SUCCESS;
2049: l_return_status := FND_API.G_RET_STS_SUCCESS;
2050: retcode := 0; --0 for success, 1 for warning, 2 for error
2051: errbuf := NULL;
2052: l_conc_program := p_conc_program;
2053:

Line 2144: p_init_msg_list => FND_API.G_FALSE,

2140: LOG_MESSAGES(' ');
2141:
2142: OKS_RENCPY_PVT.copy_contract_line(
2143: p_api_version => 1.0,
2144: p_init_msg_list => FND_API.G_FALSE,
2145: x_return_status => l_return_status,
2146: x_msg_count => l_msg_count,
2147: x_msg_data => l_msg_data,
2148: p_from_cle_id => cur_get_oper_top_lines.object_cle_id,

Line 2171: IF (l_return_status = FND_API.g_ret_sts_success) THEN

2167: END IF;
2168:
2169: --for U:unexpected error stop, for E:regular error, try next line
2170: --for W:warnings or S:Success continue
2171: IF (l_return_status = FND_API.g_ret_sts_success) THEN
2172: NULL; --continue
2173: ELSIF(l_return_status = OKC_API.g_ret_sts_warning) THEN
2174: l_warnings := TRUE;
2175: ELSIF (l_return_status = FND_API.g_ret_sts_error) THEN

Line 2175: ELSIF (l_return_status = FND_API.g_ret_sts_error) THEN

2171: IF (l_return_status = FND_API.g_ret_sts_success) THEN
2172: NULL; --continue
2173: ELSIF(l_return_status = OKC_API.g_ret_sts_warning) THEN
2174: l_warnings := TRUE;
2175: ELSIF (l_return_status = FND_API.g_ret_sts_error) THEN
2176: l_errors := TRUE;
2177: ELSE --all others treated as unexpected
2178: x_return_status := l_return_status;
2179: RAISE FND_API.g_exc_unexpected_error;

Line 2179: RAISE FND_API.g_exc_unexpected_error;

2175: ELSIF (l_return_status = FND_API.g_ret_sts_error) THEN
2176: l_errors := TRUE;
2177: ELSE --all others treated as unexpected
2178: x_return_status := l_return_status;
2179: RAISE FND_API.g_exc_unexpected_error;
2180: END IF;
2181:
2182: ------------------------------------------------------------------------------
2183: ----DEPENDING on the return status u update the operation lines process flag

Line 2187: IF (l_return_status = FND_API.g_ret_sts_error) THEN

2183: ----DEPENDING on the return status u update the operation lines process flag
2184: ------------------------------------------------------------------------------
2185: l_opl_id_tbl(l_opl_id_tbl.count +1) := cur_get_oper_top_lines.id;
2186:
2187: IF (l_return_status = FND_API.g_ret_sts_error) THEN
2188:
2189: log_messages('Topline id='|| cur_get_oper_top_lines.object_cle_id ||' did not get copied');
2190:
2191: l_opl_sub_cle_id_tbl(l_opl_id_tbl.count) := NULL;

Line 2211: p_init_msg_list => FND_API.G_FALSE,

2207: LOG_MESSAGES('Calling OKS_BILL_UTIL_PUB.delete_slh_rule');
2208:
2209: OKS_BILL_UTIL_PUB.delete_slh_rule(
2210: p_api_version => 1.0,
2211: p_init_msg_list => FND_API.G_FALSE,
2212: p_cle_id => l_cle_id,
2213: x_return_status => l_return_status,
2214: x_msg_count => l_msg_count,
2215: x_msg_data => l_msg_data);

Line 2224: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

2220: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
2221: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.top_line_billing','After call to OKS_BILL_UTIL_PUB.delete_slh_rule, l_return_status='|| l_return_status);
2222: END IF;
2223:
2224: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2225: RAISE FND_API.g_exc_unexpected_error;
2226: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
2227: RAISE FND_API.g_exc_error;
2228: END IF;

Line 2225: RAISE FND_API.g_exc_unexpected_error;

2221: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.top_line_billing','After call to OKS_BILL_UTIL_PUB.delete_slh_rule, l_return_status='|| l_return_status);
2222: END IF;
2223:
2224: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2225: RAISE FND_API.g_exc_unexpected_error;
2226: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
2227: RAISE FND_API.g_exc_error;
2228: END IF;
2229:

Line 2226: ELSIF l_return_status = FND_API.g_ret_sts_error THEN

2222: END IF;
2223:
2224: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2225: RAISE FND_API.g_exc_unexpected_error;
2226: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
2227: RAISE FND_API.g_exc_error;
2228: END IF;
2229:
2230: s_cle_id := NULL;

Line 2227: RAISE FND_API.g_exc_error;

2223:
2224: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2225: RAISE FND_API.g_exc_unexpected_error;
2226: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
2227: RAISE FND_API.g_exc_error;
2228: END IF;
2229:
2230: s_cle_id := NULL;
2231: l_subject_sub_line_tbl.delete;

Line 2253: p_init_msg_list => FND_API.G_FALSE,

2249: LOG_MESSAGES('p_from_cle_id : '||cur_get_oper_sub_lines.object_cle_id);
2250:
2251: OKS_RENCPY_PVT.copy_contract_line(
2252: p_api_version => 1.0,
2253: p_init_msg_list => FND_API.G_FALSE,
2254: x_return_status => l_return_status,
2255: x_msg_count => l_msg_count,
2256: x_msg_data => l_msg_data,
2257: p_from_cle_id => cur_get_oper_sub_lines.object_cle_id,

Line 2275: IF (l_return_status = FND_API.g_ret_sts_success) THEN

2271: END IF;
2272:
2273: LOG_MESSAGES('After Calling OKS_RENCPY_PVT.copy_contract_line, l_return_status : '||l_return_status);
2274: LOG_MESSAGES(' ');
2275: IF (l_return_status = FND_API.g_ret_sts_success) THEN
2276: NULL;
2277: ELSIF(l_return_status = OKC_API.g_ret_sts_warning) THEN
2278: l_warnings := TRUE;
2279: ELSIF (l_return_status = FND_API.g_ret_sts_error) THEN

Line 2279: ELSIF (l_return_status = FND_API.g_ret_sts_error) THEN

2275: IF (l_return_status = FND_API.g_ret_sts_success) THEN
2276: NULL;
2277: ELSIF(l_return_status = OKC_API.g_ret_sts_warning) THEN
2278: l_warnings := TRUE;
2279: ELSIF (l_return_status = FND_API.g_ret_sts_error) THEN
2280: l_errors := TRUE;
2281: ELSE
2282: x_return_status := l_return_status;
2283: RAISE FND_API.g_exc_unexpected_error;

Line 2283: RAISE FND_API.g_exc_unexpected_error;

2279: ELSIF (l_return_status = FND_API.g_ret_sts_error) THEN
2280: l_errors := TRUE;
2281: ELSE
2282: x_return_status := l_return_status;
2283: RAISE FND_API.g_exc_unexpected_error;
2284: END IF;
2285:
2286:
2287: l_opl_id_tbl(l_opl_id_tbl.count +1) := cur_get_oper_sub_lines.id;

Line 2291: IF (l_return_status = FND_API.g_ret_sts_error) THEN

2287: l_opl_id_tbl(l_opl_id_tbl.count +1) := cur_get_oper_sub_lines.id;
2288: --------------------------------------------------------------------------
2289: --DEPENDING on the return status u update the operation lines process flag
2290: --------------------------------------------------------------------------
2291: IF (l_return_status = FND_API.g_ret_sts_error) THEN
2292: log_messages(' Subline id='|| cur_get_oper_sub_lines.object_cle_id ||' did not get copied');
2293:
2294: l_opl_sub_cle_id_tbl(l_opl_id_tbl.count) := NULL;
2295: l_opl_status_tbl(l_opl_id_tbl.count) := 'E';

Line 2318: p_init_msg_list => FND_API.G_FALSE,

2314: LOG_MESSAGES('Calling OKS_BILL_UTIL_PUB.delete_slh_rule');
2315:
2316: OKS_BILL_UTIL_PUB.delete_slh_rule(
2317: p_api_version => 1.0,
2318: p_init_msg_list => FND_API.G_FALSE,
2319: p_cle_id => s_cle_id,
2320: x_return_status => l_return_status,
2321: x_msg_count => l_msg_count,
2322: x_msg_data => l_msg_data);

Line 2331: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

2327: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
2328: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.sub_line_billing','After call to OKS_BILL_UTIL_PUB.delete_slh_rule, l_return_status='|| l_return_status);
2329: END IF;
2330:
2331: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2332: RAISE FND_API.g_exc_unexpected_error;
2333: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
2334: RAISE FND_API.g_exc_error;
2335: END IF;

Line 2332: RAISE FND_API.g_exc_unexpected_error;

2328: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.sub_line_billing','After call to OKS_BILL_UTIL_PUB.delete_slh_rule, l_return_status='|| l_return_status);
2329: END IF;
2330:
2331: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2332: RAISE FND_API.g_exc_unexpected_error;
2333: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
2334: RAISE FND_API.g_exc_error;
2335: END IF;
2336:

Line 2333: ELSIF l_return_status = FND_API.g_ret_sts_error THEN

2329: END IF;
2330:
2331: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2332: RAISE FND_API.g_exc_unexpected_error;
2333: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
2334: RAISE FND_API.g_exc_error;
2335: END IF;
2336:
2337: --------------------------------------------------------------------------

Line 2334: RAISE FND_API.g_exc_error;

2330:
2331: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2332: RAISE FND_API.g_exc_unexpected_error;
2333: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
2334: RAISE FND_API.g_exc_error;
2335: END IF;
2336:
2337: --------------------------------------------------------------------------
2338: ---- Update the source subline with the renewal date

Line 2364: p_init_msg_list => FND_API.G_FALSE,

2360: /*
2361: * Bug 6114024 Call moved after update to operation lines
2362: OKS_REPRICE_PVT.call_pricing_api(
2363: p_api_version => 1.0,
2364: p_init_msg_list => FND_API.G_FALSE,
2365: x_return_status => l_return_status,
2366: x_msg_count => l_msg_count,
2367: x_msg_data => l_msg_data,
2368: p_subject_chr_id => l_target_header_id,

Line 2380: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

2376: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
2377: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.top_line_repricing','After call to OKS_REPRICE_PVT.call_pricing_api l_return_status='|| l_return_status);
2378: END IF;
2379:
2380: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2381: RAISE FND_API.g_exc_unexpected_error;
2382: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
2383: RAISE FND_API.g_exc_error;
2384: END IF;

Line 2381: RAISE FND_API.g_exc_unexpected_error;

2377: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.top_line_repricing','After call to OKS_REPRICE_PVT.call_pricing_api l_return_status='|| l_return_status);
2378: END IF;
2379:
2380: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2381: RAISE FND_API.g_exc_unexpected_error;
2382: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
2383: RAISE FND_API.g_exc_error;
2384: END IF;
2385:

Line 2382: ELSIF l_return_status = FND_API.g_ret_sts_error THEN

2378: END IF;
2379:
2380: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2381: RAISE FND_API.g_exc_unexpected_error;
2382: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
2383: RAISE FND_API.g_exc_error;
2384: END IF;
2385:
2386: log_messages('Top line id='||l_cle_id||' repriced');

Line 2383: RAISE FND_API.g_exc_error;

2379:
2380: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2381: RAISE FND_API.g_exc_unexpected_error;
2382: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
2383: RAISE FND_API.g_exc_error;
2384: END IF;
2385:
2386: log_messages('Top line id='||l_cle_id||' repriced');
2387: LOG_MESSAGES(' ');

Line 2420: p_init_msg_list => FND_API.G_FALSE,

2416: LOG_MESSAGES(' ');
2417:
2418: OKS_RENCPY_PVT.copy_contract_line(
2419: p_api_version => 1.0,
2420: p_init_msg_list => FND_API.G_FALSE,
2421: x_return_status => l_return_status,
2422: x_msg_count => l_msg_count,
2423: x_msg_data => l_msg_data,
2424: p_from_cle_id => cur_get_oper_sub_lines.object_cle_id,

Line 2443: IF (l_return_status = FND_API.g_ret_sts_success) THEN

2439: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
2440: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.sub_line_copy','After call to OKS_RENCPY_PVT.copy_contract_line, l_return_status=' || l_return_status ||' ,x_cle_id=' || s_cle_id);
2441: END IF;
2442:
2443: IF (l_return_status = FND_API.g_ret_sts_success) THEN
2444: NULL;
2445: ELSIF(l_return_status = OKC_API.g_ret_sts_warning) THEN
2446: l_warnings := TRUE;
2447: ELSIF (l_return_status = FND_API.g_ret_sts_error) THEN

Line 2447: ELSIF (l_return_status = FND_API.g_ret_sts_error) THEN

2443: IF (l_return_status = FND_API.g_ret_sts_success) THEN
2444: NULL;
2445: ELSIF(l_return_status = OKC_API.g_ret_sts_warning) THEN
2446: l_warnings := TRUE;
2447: ELSIF (l_return_status = FND_API.g_ret_sts_error) THEN
2448: l_errors := TRUE;
2449: ELSE
2450: x_return_status := l_return_status;
2451: RAISE FND_API.g_exc_unexpected_error;

Line 2451: RAISE FND_API.g_exc_unexpected_error;

2447: ELSIF (l_return_status = FND_API.g_ret_sts_error) THEN
2448: l_errors := TRUE;
2449: ELSE
2450: x_return_status := l_return_status;
2451: RAISE FND_API.g_exc_unexpected_error;
2452: END IF;
2453:
2454:
2455: l_opl_id_tbl(l_opl_id_tbl.count +1) := cur_get_oper_sub_lines.id;

Line 2459: IF (l_return_status = FND_API.g_ret_sts_error) THEN

2455: l_opl_id_tbl(l_opl_id_tbl.count +1) := cur_get_oper_sub_lines.id;
2456: ------------------------------------------------------------------------------
2457: ----DEPENDING on the return status u update the operation lines process flag
2458: ------------------------------------------------------------------------------
2459: IF (l_return_status = FND_API.g_ret_sts_error) THEN
2460: log_messages(' Subline id='|| cur_get_oper_sub_lines.object_cle_id ||' did not get copied');
2461:
2462: l_opl_sub_cle_id_tbl(l_opl_id_tbl.count) := NULL;
2463: l_opl_status_tbl(l_opl_id_tbl.count) := 'E';

Line 2484: p_init_msg_list => FND_API.G_FALSE,

2480: LOG_MESSAGES('Calling OKS_BILL_UTIL_PUB.delete_slh_rule');
2481:
2482: OKS_BILL_UTIL_PUB.delete_slh_rule(
2483: p_api_version => 1.0,
2484: p_init_msg_list => FND_API.G_FALSE,
2485: p_cle_id => s_cle_id,
2486: x_return_status => l_return_status,
2487: x_msg_count => l_msg_count,
2488: x_msg_data => l_msg_data);

Line 2497: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

2493: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
2494: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.sub_line_billing','After call to OKS_BILL_UTIL_PUB.delete_slh_rule, l_return_status='|| l_return_status);
2495: END IF;
2496:
2497: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2498: RAISE FND_API.g_exc_unexpected_error;
2499: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
2500: RAISE FND_API.g_exc_error;
2501: END IF;

Line 2498: RAISE FND_API.g_exc_unexpected_error;

2494: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.sub_line_billing','After call to OKS_BILL_UTIL_PUB.delete_slh_rule, l_return_status='|| l_return_status);
2495: END IF;
2496:
2497: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2498: RAISE FND_API.g_exc_unexpected_error;
2499: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
2500: RAISE FND_API.g_exc_error;
2501: END IF;
2502:

Line 2499: ELSIF l_return_status = FND_API.g_ret_sts_error THEN

2495: END IF;
2496:
2497: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2498: RAISE FND_API.g_exc_unexpected_error;
2499: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
2500: RAISE FND_API.g_exc_error;
2501: END IF;
2502:
2503: l_src_sub_line_id_tbl(l_src_sub_line_id_tbl.count +1) := cur_get_oper_sub_lines.object_cle_id;

Line 2500: RAISE FND_API.g_exc_error;

2496:
2497: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2498: RAISE FND_API.g_exc_unexpected_error;
2499: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
2500: RAISE FND_API.g_exc_error;
2501: END IF;
2502:
2503: l_src_sub_line_id_tbl(l_src_sub_line_id_tbl.count +1) := cur_get_oper_sub_lines.object_cle_id;
2504:

Line 2529: p_init_msg_list => FND_API.G_FALSE,

2525: /*
2526: * Bug 6114024 Call moved after update to operation lines
2527: OKS_REPRICE_PVT.call_pricing_api(
2528: p_api_version => 1.0,
2529: p_init_msg_list => FND_API.G_FALSE,
2530: x_return_status => l_return_status,
2531: x_msg_count => l_msg_count,
2532: x_msg_data => l_msg_data,
2533: p_subject_chr_id => l_target_header_id,

Line 2544: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

2540: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
2541: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.top_line_repricing','After call to OKS_REPRICE_PVT.call_pricing_api l_return_status='|| l_return_status);
2542: END IF;
2543:
2544: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2545: RAISE FND_API.g_exc_unexpected_error;
2546: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
2547: RAISE FND_API.g_exc_error;
2548: END IF;

Line 2545: RAISE FND_API.g_exc_unexpected_error;

2541: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.top_line_repricing','After call to OKS_REPRICE_PVT.call_pricing_api l_return_status='|| l_return_status);
2542: END IF;
2543:
2544: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2545: RAISE FND_API.g_exc_unexpected_error;
2546: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
2547: RAISE FND_API.g_exc_error;
2548: END IF;
2549:

Line 2546: ELSIF l_return_status = FND_API.g_ret_sts_error THEN

2542: END IF;
2543:
2544: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2545: RAISE FND_API.g_exc_unexpected_error;
2546: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
2547: RAISE FND_API.g_exc_error;
2548: END IF;
2549:
2550: log_messages('Top line id='||l_target_line_id||' repriced');

Line 2547: RAISE FND_API.g_exc_error;

2543:
2544: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2545: RAISE FND_API.g_exc_unexpected_error;
2546: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
2547: RAISE FND_API.g_exc_error;
2548: END IF;
2549:
2550: log_messages('Top line id='||l_target_line_id||' repriced');
2551:

Line 2603: p_init_msg_list => FND_API.G_FALSE,

2599: LOG_MESSAGES('p_subject_sub_line_tbl.count='||l_subject_sub_line_tbl.count);
2600:
2601: OKS_REPRICE_PVT.call_pricing_api(
2602: p_api_version => 1.0,
2603: p_init_msg_list => FND_API.G_FALSE,
2604: x_return_status => l_return_status,
2605: x_msg_count => l_msg_count,
2606: x_msg_data => l_msg_data,
2607: p_subject_chr_id => l_target_header_id,

Line 2622: p_init_msg_list => FND_API.G_FALSE,

2618: LOG_MESSAGES('p_subject_sub_line_tbl.count='||l_subject_sub_line_tbl.COUNT);
2619:
2620: OKS_REPRICE_PVT.call_pricing_api(
2621: p_api_version => 1.0,
2622: p_init_msg_list => FND_API.G_FALSE,
2623: x_return_status => l_return_status,
2624: x_msg_count => l_msg_count,
2625: x_msg_data => l_msg_data,
2626: p_subject_chr_id => l_target_header_id,

Line 2739: p_init_msg_list => FND_API.G_FALSE,

2735: LOG_MESSAGES('Calling OKS_RENEW_CONTRACT_PVT.update_invoice_text');
2736:
2737: OKS_RENEW_CONTRACT_PVT.update_invoice_text(
2738: p_api_version => 1.0,
2739: p_init_msg_list => FND_API.G_FALSE,
2740: p_commit => FND_API.G_FALSE,
2741: x_return_status => l_return_status,
2742: x_msg_count => l_msg_count,
2743: x_msg_data => l_msg_data,

Line 2740: p_commit => FND_API.G_FALSE,

2736:
2737: OKS_RENEW_CONTRACT_PVT.update_invoice_text(
2738: p_api_version => 1.0,
2739: p_init_msg_list => FND_API.G_FALSE,
2740: p_commit => FND_API.G_FALSE,
2741: x_return_status => l_return_status,
2742: x_msg_count => l_msg_count,
2743: x_msg_data => l_msg_data,
2744: p_chr_id => l_target_header_id);

Line 2753: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

2749: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
2750: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.update_invoice_text','After call to OKS_RENEW_CONTRACT_PVT.update_invoice_text l_return_status='||l_return_status);
2751: END IF;
2752:
2753: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2754: RAISE FND_API.g_exc_unexpected_error;
2755: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
2756: RAISE FND_API.g_exc_error;
2757: END IF;

Line 2754: RAISE FND_API.g_exc_unexpected_error;

2750: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.update_invoice_text','After call to OKS_RENEW_CONTRACT_PVT.update_invoice_text l_return_status='||l_return_status);
2751: END IF;
2752:
2753: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2754: RAISE FND_API.g_exc_unexpected_error;
2755: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
2756: RAISE FND_API.g_exc_error;
2757: END IF;
2758: log_messages('Updated invoice text');

Line 2755: ELSIF l_return_status = FND_API.g_ret_sts_error THEN

2751: END IF;
2752:
2753: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2754: RAISE FND_API.g_exc_unexpected_error;
2755: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
2756: RAISE FND_API.g_exc_error;
2757: END IF;
2758: log_messages('Updated invoice text');
2759: LOG_MESSAGES(' ');LOG_MESSAGES(' ');

Line 2756: RAISE FND_API.g_exc_error;

2752:
2753: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2754: RAISE FND_API.g_exc_unexpected_error;
2755: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
2756: RAISE FND_API.g_exc_error;
2757: END IF;
2758: log_messages('Updated invoice text');
2759: LOG_MESSAGES(' ');LOG_MESSAGES(' ');
2760:

Line 2776: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

2772: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
2773: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.update_contract_amount','after call to update_contract_amount l_return_status='||l_return_status);
2774: END IF;
2775:
2776: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2777: RAISE FND_API.g_exc_unexpected_error;
2778: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
2779: RAISE FND_API.g_exc_error;
2780: END IF;

Line 2777: RAISE FND_API.g_exc_unexpected_error;

2773: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.update_contract_amount','after call to update_contract_amount l_return_status='||l_return_status);
2774: END IF;
2775:
2776: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2777: RAISE FND_API.g_exc_unexpected_error;
2778: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
2779: RAISE FND_API.g_exc_error;
2780: END IF;
2781: log_messages('Updated contract header and line amounts');

Line 2778: ELSIF l_return_status = FND_API.g_ret_sts_error THEN

2774: END IF;
2775:
2776: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2777: RAISE FND_API.g_exc_unexpected_error;
2778: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
2779: RAISE FND_API.g_exc_error;
2780: END IF;
2781: log_messages('Updated contract header and line amounts');
2782: LOG_MESSAGES(' ');

Line 2779: RAISE FND_API.g_exc_error;

2775:
2776: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2777: RAISE FND_API.g_exc_unexpected_error;
2778: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
2779: RAISE FND_API.g_exc_error;
2780: END IF;
2781: log_messages('Updated contract header and line amounts');
2782: LOG_MESSAGES(' ');
2783:

Line 2795: x_return_status := FND_API.g_ret_sts_success;

2791: x_return_status := OKC_API.g_ret_sts_warning;
2792: l_dummy := FND_CONCURRENT.set_completion_status('WARNING', null);
2793: log_messages('Some lines where copied with warnings');
2794: ELSE
2795: x_return_status := FND_API.g_ret_sts_success;
2796: l_dummy := FND_CONCURRENT.set_completion_status('NORMAL', null);
2797: END IF;
2798:
2799: --log all the error and warning messages the CP log file

Line 2818: WHEN FND_API.g_exc_error THEN

2814: LOG_MESSAGES(' ');
2815:
2816: EXCEPTION
2817:
2818: WHEN FND_API.g_exc_error THEN
2819: ROLLBACK TO submit_PVT;
2820: x_return_status := FND_API.g_ret_sts_error ;
2821: retcode := 2;
2822: l_dummy := FND_CONCURRENT.set_completion_status('ERROR', null);

Line 2820: x_return_status := FND_API.g_ret_sts_error ;

2816: EXCEPTION
2817:
2818: WHEN FND_API.g_exc_error THEN
2819: ROLLBACK TO submit_PVT;
2820: x_return_status := FND_API.g_ret_sts_error ;
2821: retcode := 2;
2822: l_dummy := FND_CONCURRENT.set_completion_status('ERROR', null);
2823:
2824: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN

Line 2847: WHEN FND_API.g_exc_unexpected_error THEN

2843: END LOOP;
2844: END IF;
2845: log_messages('Renewal Consolidation conurrent program - Error');
2846:
2847: WHEN FND_API.g_exc_unexpected_error THEN
2848: ROLLBACK TO submit_PVT;
2849: x_return_status := FND_API.g_ret_sts_unexp_error ;
2850: retcode := 2;
2851: l_dummy := FND_CONCURRENT.set_completion_status('ERROR', null);

Line 2849: x_return_status := FND_API.g_ret_sts_unexp_error ;

2845: log_messages('Renewal Consolidation conurrent program - Error');
2846:
2847: WHEN FND_API.g_exc_unexpected_error THEN
2848: ROLLBACK TO submit_PVT;
2849: x_return_status := FND_API.g_ret_sts_unexp_error ;
2850: retcode := 2;
2851: l_dummy := FND_CONCURRENT.set_completion_status('ERROR', null);
2852:
2853: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN

Line 2878: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2874: log_messages('Renewal Consolidation conurrent program - Unexpected Error');
2875:
2876: WHEN OTHERS THEN
2877: ROLLBACK TO submit_PVT;
2878: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2879: retcode := 2;
2880: l_dummy := FND_CONCURRENT.set_completion_status('ERROR', null);
2881: errbuf := SQLCODE || SQLERRM;
2882:

Line 2950: x_return_status := FND_API.G_RET_STS_SUCCESS;

2946: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.begin','p_header_id='||p_header_id);
2947: END IF;
2948:
2949: SAVEPOINT update_contract_amount_PVT;
2950: x_return_status := FND_API.G_RET_STS_SUCCESS;
2951:
2952: IF p_header_id IS NOT NULL THEN
2953:
2954: l_update_date := sysdate;

Line 3053: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3049: EXCEPTION
3050:
3051: WHEN OTHERS THEN
3052: ROLLBACK TO update_contract_amount_PVT;
3053: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3054:
3055: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
3056: l_error_text := substr (SQLERRM, 1, 240);
3057: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);