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.OKL_COPY_CONTRACT_PVT dependencies on OKC_API

Line 9: TYPE l_phid_mapping_type IS RECORD (old_id okl_party_payment_hdr.id%TYPE := OKC_API.G_MISS_NUM, new_id okl_party_payment_hdr.id%TYPE := OKC_API.G_MISS_NUM);

5: G_DEBUG_ENABLED CONSTANT VARCHAR2(10) := OKL_DEBUG_PUB.CHECK_LOG_ENABLED;
6: G_IS_DEBUG_STATEMENT_ON BOOLEAN;
7: --subtypes declared here to facilitate rosetta skip okc_rule_pub compilation
8: --which has a clob in it
9: TYPE l_phid_mapping_type IS RECORD (old_id okl_party_payment_hdr.id%TYPE := OKC_API.G_MISS_NUM, new_id okl_party_payment_hdr.id%TYPE := OKC_API.G_MISS_NUM);
10: TYPE l_phid_mapping_tab_type IS TABLE OF l_phid_mapping_type INDEX BY BINARY_INTEGER;
11:
12: SUBTYPE api_components_rec_okc is OKC_COPY_CONTRACT_PVT.api_components_rec;
13: SUBTYPE api_components_tbl_okc is OKC_COPY_CONTRACT_PVT.api_components_tbl;

Line 1127: x_return_status := OKC_API.G_RET_STS_SUCCESS;

1123: ) RETURN pphv_rec_type IS
1124: l_pphv_rec pphv_rec_type;
1125: l_row_notfound BOOLEAN := TRUE;
1126: BEGIN
1127: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1128: l_pphv_rec := get_pphv_rec(p_pphv_rec, l_row_notfound);
1129: IF (l_row_notfound) THEN
1130: OKC_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');
1131: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 1130: OKC_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');

1126: BEGIN
1127: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1128: l_pphv_rec := get_pphv_rec(p_pphv_rec, l_row_notfound);
1129: IF (l_row_notfound) THEN
1130: OKC_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');
1131: x_return_status := OKC_API.G_RET_STS_ERROR;
1132: END IF;
1133: RETURN(l_pphv_rec);
1134: END get_pphv_rec;

Line 1131: x_return_status := OKC_API.G_RET_STS_ERROR;

1127: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1128: l_pphv_rec := get_pphv_rec(p_pphv_rec, l_row_notfound);
1129: IF (l_row_notfound) THEN
1130: OKC_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');
1131: x_return_status := OKC_API.G_RET_STS_ERROR;
1132: END IF;
1133: RETURN(l_pphv_rec);
1134: END get_pphv_rec;
1135:

Line 1324: x_return_status := OKC_API.G_RET_STS_SUCCESS;

1320: ) RETURN kplv_rec_type IS
1321: l_kplv_rec kplv_rec_type;
1322: l_row_notfound BOOLEAN := TRUE;
1323: BEGIN
1324: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1325: l_kplv_rec := get_kplv_rec(p_kplv_rec, l_row_notfound);
1326: IF (l_row_notfound) THEN
1327: OKC_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');
1328: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 1327: OKC_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');

1323: BEGIN
1324: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1325: l_kplv_rec := get_kplv_rec(p_kplv_rec, l_row_notfound);
1326: IF (l_row_notfound) THEN
1327: OKC_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');
1328: x_return_status := OKC_API.G_RET_STS_ERROR;
1329: END IF;
1330: RETURN(l_kplv_rec);
1331: END get_kplv_rec;

Line 1328: x_return_status := OKC_API.G_RET_STS_ERROR;

1324: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1325: l_kplv_rec := get_kplv_rec(p_kplv_rec, l_row_notfound);
1326: IF (l_row_notfound) THEN
1327: OKC_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');
1328: x_return_status := OKC_API.G_RET_STS_ERROR;
1329: END IF;
1330: RETURN(l_kplv_rec);
1331: END get_kplv_rec;
1332: --Bug# 4558486

Line 2247: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

2243: BEGIN
2244: IF (G_DEBUG_ENABLED = 'Y') THEN
2245: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
2246: END IF;
2247: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
2248: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2249: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
2250: END IF;
2251:

Line 2267: p_init_msg_list => Okc_Api.G_FALSE,

2263: END LOOP;
2264:
2265: Okl_Rule_Pub.delete_rule(
2266: p_api_version => 1.0,
2267: p_init_msg_list => Okc_Api.G_FALSE,
2268: x_return_status => x_return_status,
2269: x_msg_count => x_msg_count,
2270: x_msg_data => x_msg_data,
2271: p_rulv_tbl => l_rulv_tbl

Line 2273: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN

2269: x_msg_count => x_msg_count,
2270: x_msg_data => x_msg_data,
2271: p_rulv_tbl => l_rulv_tbl
2272: );
2273: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
2274: RAISE sync_failed;
2275: END IF;
2276:
2277: l_old_rgpv_rec.id := p_old_rgp_id;

Line 2294: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN

2290: x_msg_data => x_msg_data,
2291: x_rulv_tbl => x_slh_rulv_tbl,
2292: x_rule_count => x_slh_rule_count
2293: );
2294: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
2295: RAISE sync_failed;
2296: END IF;
2297:
2298: --x_slh_rulv_tbl_out := x_slh_rulv_tbl;

Line 2309: p_init_msg_list => Okc_Api.G_FALSE,

2305: l_slh_rulv_rec.dnz_chr_id := p_new_chr_id;
2306:
2307: Okl_Rule_Pub.create_rule(
2308: p_api_version => 1.0,
2309: p_init_msg_list => Okc_Api.G_FALSE,
2310: x_return_status => x_return_status,
2311: x_msg_count => x_msg_count,
2312: x_msg_data => x_msg_data,
2313: p_rulv_rec => l_slh_rulv_rec,

Line 2316: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN

2312: x_msg_data => x_msg_data,
2313: p_rulv_rec => l_slh_rulv_rec,
2314: x_rulv_rec => x_new_slh_rulv_rec
2315: );
2316: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
2317: x_return_status := Okc_Api.G_RET_STS_ERROR;
2318: RAISE sync_failed;
2319: END IF;
2320:

Line 2317: x_return_status := Okc_Api.G_RET_STS_ERROR;

2313: p_rulv_rec => l_slh_rulv_rec,
2314: x_rulv_rec => x_new_slh_rulv_rec
2315: );
2316: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
2317: x_return_status := Okc_Api.G_RET_STS_ERROR;
2318: RAISE sync_failed;
2319: END IF;
2320:
2321: --

Line 2336: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN

2332: p_slh_id => x_slh_rulv_tbl(i).id,
2333: x_rulv_tbl => x_sll_rulv_tbl,
2334: x_rule_count => x_sll_rule_count
2335: );
2336: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
2337: RAISE sync_failed;
2338: END IF;
2339:
2340: --x_sll_rulv_tbl_out := x_sll_rulv_tbl;

Line 2354: p_init_msg_list => Okc_Api.G_FALSE,

2350: l_sll_rulv_rec.dnz_chr_id := p_new_chr_id;
2351:
2352: Okl_Rule_Pub.create_rule(
2353: p_api_version => 1.0,
2354: p_init_msg_list => Okc_Api.G_FALSE,
2355: x_return_status => x_return_status,
2356: x_msg_count => x_msg_count,
2357: x_msg_data => x_msg_data,
2358: p_rulv_rec => l_sll_rulv_rec,

Line 2361: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN

2357: x_msg_data => x_msg_data,
2358: p_rulv_rec => l_sll_rulv_rec,
2359: x_rulv_rec => x_rulv_rec
2360: );
2361: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
2362: x_return_status := Okc_Api.G_RET_STS_ERROR;
2363: RAISE sync_failed;
2364: END IF;
2365: END LOOP; -- SLL

Line 2362: x_return_status := Okc_Api.G_RET_STS_ERROR;

2358: p_rulv_rec => l_sll_rulv_rec,
2359: x_rulv_rec => x_rulv_rec
2360: );
2361: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
2362: x_return_status := Okc_Api.G_RET_STS_ERROR;
2363: RAISE sync_failed;
2364: END IF;
2365: END LOOP; -- SLL
2366:

Line 2371: x_return_status := Okc_Api.G_RET_STS_ERROR;

2367: END LOOP; -- SLH
2368:
2369: EXCEPTION
2370: WHEN sync_failed THEN
2371: x_return_status := Okc_Api.G_RET_STS_ERROR;
2372: END sync_slh_sll;
2373: -- Start Bug 2376998
2374: ------------------------------------------------------------------------------
2375: -- PROCEDURE link_slh_sll

Line 2452: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

2448: p_new_chr_id => p_new_chr_id,
2449: p_old_rgp_id => l_old_lalevl_id,
2450: p_new_rgp_id => l_new_lalevl_id
2451: );
2452: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
2453: RAISE Okl_Api.G_EXCEPTION_ERROR;
2454: END IF;
2455: END LOOP;
2456:

Line 2459: x_return_status := OKC_API.G_RET_STS_ERROR;

2455: END LOOP;
2456:
2457: EXCEPTION
2458: WHEN link_failed THEN
2459: x_return_status := OKC_API.G_RET_STS_ERROR;
2460: END link_slh_sll;
2461:
2462: -- End Bug 2376998
2463: ------------------------------------------------------------------------------

Line 2538: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

2534: p_new_chr_id => p_new_chr_id,
2535: p_old_rgp_id => l_old_lalevl_id,
2536: p_new_rgp_id => l_new_lalevl_id
2537: );
2538: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
2539: raise OKL_API.G_EXCEPTION_ERROR;
2540: END IF;
2541: END LOOP;
2542:

Line 2545: x_return_status := OKC_API.G_RET_STS_ERROR;

2541: END LOOP;
2542:
2543: EXCEPTION
2544: WHEN link_failed THEN
2545: x_return_status := OKC_API.G_RET_STS_ERROR;
2546: END link_slh_sll;
2547: --------------------------------------------------------------------------------
2548: -- Start of comments
2549: --Bug# 2522268

Line 3179: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

3175: p_new_chr_id => x_chr_id
3176: );
3177:
3178:
3179: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
3180: RAISE OKL_API.G_EXCEPTION_ERROR;
3181: END IF;
3182: --Call OKC_COPY_CONTRACT_PUB.Copy_Components
3183: -- do not do this again as this might already be done as part of OKC_COPY_CONTRACT

Line 3577: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

3573: --p_new_cle_id => x_cle_id, -- Bug 2376998
3574: p_new_cle_id => c_lines_rec.id, -- Bug 2376998
3575: p_new_chr_id => l_new_chr_id --Bug# 4899328
3576: );
3577: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
3578: RAISE OKL_API.G_EXCEPTION_ERROR;
3579: END IF;
3580: --------------------------------------------------------------------------------------
3581: --BUG# 3143522 : 11.5.10 Subsidies - copy party payment details

Line 3715: --IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

3711: --p_new_chr_id => p_to_chr_id
3712: --);
3713:
3714:
3715: --IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
3716: --RAISE OKL_API.G_EXCEPTION_ERROR;
3717: --END IF;
3718:
3719: ---------Commented as this code has been moved up to run for all sub-lines too-----*/

Line 4232: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

4228: -- governances are copied only if renew reference flag is set to 'Yes'
4229: --------------------------------------------------------------------------
4230: PROCEDURE copy_governances(
4231: p_api_version IN NUMBER,
4232: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
4233: x_return_status OUT NOCOPY VARCHAR2,
4234: x_msg_count OUT NOCOPY NUMBER,
4235: x_msg_data OUT NOCOPY VARCHAR2,
4236: p_from_chr_id IN NUMBER,

Line 4241: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

4237: p_to_chr_id IN NUMBER) IS
4238:
4239: l_gvev_rec OKC_CONTRACT_PUB.gvev_rec_type;
4240: x_gvev_rec OKC_CONTRACT_PUB.gvev_rec_type;
4241: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4242:
4243: CURSOR c_governances IS
4244: SELECT id
4245: FROM okc_governances_v

Line 4255: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

4251: ----------------------------------------------------------------------------
4252: FUNCTION get_gvev_rec(p_gve_id IN NUMBER,
4253: x_gvev_rec OUT NOCOPY OKC_CONTRACT_PUB.gvev_rec_type)
4254: RETURN VARCHAR2 IS
4255: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4256: l_no_data_found BOOLEAN := TRUE;
4257:
4258: CURSOR c_gvev_rec IS
4259: SELECT

Line 4283: l_return_status := OKC_API.G_RET_STS_ERROR;

4279:
4280: l_no_data_found := c_gvev_rec%NOTFOUND;
4281: CLOSE c_gvev_rec;
4282: IF l_no_data_found THEN
4283: l_return_status := OKC_API.G_RET_STS_ERROR;
4284: return(l_return_status);
4285: ELSE
4286: return(l_return_status);
4287: END IF;

Line 4291: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);

4287: END IF;
4288: EXCEPTION
4289: WHEN OTHERS THEN
4290: -- store SQL error message on message stack for caller
4291: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
4292: -- notify caller of an UNEXPECTED error
4293: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
4294: return(l_return_status);
4295:

Line 4293: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

4289: WHEN OTHERS THEN
4290: -- store SQL error message on message stack for caller
4291: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
4292: -- notify caller of an UNEXPECTED error
4293: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
4294: return(l_return_status);
4295:
4296: END get_gvev_rec;
4297: BEGIN

Line 4314: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

4310: x_msg_data => x_msg_data,
4311: p_gvev_rec => l_gvev_rec,
4312: x_gvev_rec => x_gvev_rec);
4313:
4314: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
4315: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4316: x_return_status := l_return_status;
4317: RAISE G_EXCEPTION_HALT_VALIDATION;
4318: ELSE

Line 4315: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

4311: p_gvev_rec => l_gvev_rec,
4312: x_gvev_rec => x_gvev_rec);
4313:
4314: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
4315: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4316: x_return_status := l_return_status;
4317: RAISE G_EXCEPTION_HALT_VALIDATION;
4318: ELSE
4319: x_return_status := l_return_status;

Line 4329: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);

4325: WHEN G_EXCEPTION_HALT_VALIDATION THEN
4326: NULL;
4327: WHEN OTHERS THEN
4328: -- store SQL error message on message stack for caller
4329: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
4330: -- notify caller of an UNEXPECTED error
4331: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
4332:
4333: END copy_governances;

Line 4331: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

4327: WHEN OTHERS THEN
4328: -- store SQL error message on message stack for caller
4329: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
4330: -- notify caller of an UNEXPECTED error
4331: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
4332:
4333: END copy_governances;
4334:
4335: --------------------------------------------------------------------------------

Line 5199: RAISE OKC_API.G_EXCEPTION_ERROR;

5195: END IF;
5196: END LOOP;
5197: END IF;
5198:
5199: RAISE OKC_API.G_EXCEPTION_ERROR;
5200: END copy_var_int_rate_params;
5201:
5202: --------------------------------------------------------------------------------
5203: -- Start of comments

Line 5499: --id okl_k_lines.id%type := OKC_API.G_MISS_NUM,

5495: TYPE l_name_type IS TABLE OF okc_k_lines_tl.name%TYPE INDEX BY BINARY_INTEGER;
5496:
5497: -- For okl_k_lines whole record
5498: TYPE l_okl_k_lines_rec_type IS RECORD (
5499: --id okl_k_lines.id%type := OKC_API.G_MISS_NUM,
5500: id NUMBER := OKC_API.G_MISS_NUM,
5501: oec okl_k_lines.oec%TYPE,
5502: year_built okl_k_lines.year_built%TYPE,
5503: item_description okc_k_lines_tl.item_description%TYPE := OKC_API.G_MISS_CHAR

Line 5500: id NUMBER := OKC_API.G_MISS_NUM,

5496:
5497: -- For okl_k_lines whole record
5498: TYPE l_okl_k_lines_rec_type IS RECORD (
5499: --id okl_k_lines.id%type := OKC_API.G_MISS_NUM,
5500: id NUMBER := OKC_API.G_MISS_NUM,
5501: oec okl_k_lines.oec%TYPE,
5502: year_built okl_k_lines.year_built%TYPE,
5503: item_description okc_k_lines_tl.item_description%TYPE := OKC_API.G_MISS_CHAR
5504: );

Line 5503: item_description okc_k_lines_tl.item_description%TYPE := OKC_API.G_MISS_CHAR

5499: --id okl_k_lines.id%type := OKC_API.G_MISS_NUM,
5500: id NUMBER := OKC_API.G_MISS_NUM,
5501: oec okl_k_lines.oec%TYPE,
5502: year_built okl_k_lines.year_built%TYPE,
5503: item_description okc_k_lines_tl.item_description%TYPE := OKC_API.G_MISS_CHAR
5504: );
5505: /*
5506: TYPE lines_rec_type is record (
5507: id okl_k_lines.id%type := OKC_API.G_MISS_NUM,

Line 5507: id okl_k_lines.id%type := OKC_API.G_MISS_NUM,

5503: item_description okc_k_lines_tl.item_description%TYPE := OKC_API.G_MISS_CHAR
5504: );
5505: /*
5506: TYPE lines_rec_type is record (
5507: id okl_k_lines.id%type := OKC_API.G_MISS_NUM,
5508: oec okl_k_lines.oec%type
5509: );
5510: TYPE lines_tbl_type is TABLE OF lines_rec_type
5511: index by binary_integer; */

Line 5519: id okc_k_items.cle_id%TYPE := OKC_API.G_MISS_NUM,

5515: -- For okl_k_lines whole record
5516:
5517: -- For okc_k_items whole record
5518: TYPE l_okc_k_items_rec_type IS RECORD (
5519: id okc_k_items.cle_id%TYPE := OKC_API.G_MISS_NUM,
5520: number_of_items okc_k_items.number_of_items%TYPE := OKC_API.G_MISS_NUM,
5521: object1_id1 okc_k_items.object1_id1%TYPE := OKC_API.G_MISS_CHAR,
5522: object1_id2 okc_k_items.object1_id2%TYPE := OKC_API.G_MISS_CHAR
5523: );

Line 5520: number_of_items okc_k_items.number_of_items%TYPE := OKC_API.G_MISS_NUM,

5516:
5517: -- For okc_k_items whole record
5518: TYPE l_okc_k_items_rec_type IS RECORD (
5519: id okc_k_items.cle_id%TYPE := OKC_API.G_MISS_NUM,
5520: number_of_items okc_k_items.number_of_items%TYPE := OKC_API.G_MISS_NUM,
5521: object1_id1 okc_k_items.object1_id1%TYPE := OKC_API.G_MISS_CHAR,
5522: object1_id2 okc_k_items.object1_id2%TYPE := OKC_API.G_MISS_CHAR
5523: );
5524: TYPE l_okc_k_items_rec_tab IS TABLE OF l_okc_k_items_rec_type INDEX BY BINARY_INTEGER;

Line 5521: object1_id1 okc_k_items.object1_id1%TYPE := OKC_API.G_MISS_CHAR,

5517: -- For okc_k_items whole record
5518: TYPE l_okc_k_items_rec_type IS RECORD (
5519: id okc_k_items.cle_id%TYPE := OKC_API.G_MISS_NUM,
5520: number_of_items okc_k_items.number_of_items%TYPE := OKC_API.G_MISS_NUM,
5521: object1_id1 okc_k_items.object1_id1%TYPE := OKC_API.G_MISS_CHAR,
5522: object1_id2 okc_k_items.object1_id2%TYPE := OKC_API.G_MISS_CHAR
5523: );
5524: TYPE l_okc_k_items_rec_tab IS TABLE OF l_okc_k_items_rec_type INDEX BY BINARY_INTEGER;
5525: -- For okc_k_items whole record

Line 5522: object1_id2 okc_k_items.object1_id2%TYPE := OKC_API.G_MISS_CHAR

5518: TYPE l_okc_k_items_rec_type IS RECORD (
5519: id okc_k_items.cle_id%TYPE := OKC_API.G_MISS_NUM,
5520: number_of_items okc_k_items.number_of_items%TYPE := OKC_API.G_MISS_NUM,
5521: object1_id1 okc_k_items.object1_id1%TYPE := OKC_API.G_MISS_CHAR,
5522: object1_id2 okc_k_items.object1_id2%TYPE := OKC_API.G_MISS_CHAR
5523: );
5524: TYPE l_okc_k_items_rec_tab IS TABLE OF l_okc_k_items_rec_type INDEX BY BINARY_INTEGER;
5525: -- For okc_k_items whole record
5526:

Line 5528: TYPE l_bid_mapping_type IS RECORD (old_id okc_k_lines_b.id%TYPE := OKC_API.G_MISS_NUM, new_id okc_k_lines_tl.name%TYPE := OKC_API.G_MISS_CHAR);

5524: TYPE l_okc_k_items_rec_tab IS TABLE OF l_okc_k_items_rec_type INDEX BY BINARY_INTEGER;
5525: -- For okc_k_items whole record
5526:
5527:
5528: TYPE l_bid_mapping_type IS RECORD (old_id okc_k_lines_b.id%TYPE := OKC_API.G_MISS_NUM, new_id okc_k_lines_tl.name%TYPE := OKC_API.G_MISS_CHAR);
5529: TYPE l_cle_lse_mapping_type IS RECORD (cle_id okc_k_lines_b.id%TYPE := OKC_API.G_MISS_NUM, lse_id NUMBER := OKC_API.G_MISS_NUM, id okc_k_lines_b.id%TYPE := OKC_API.G_MISS_NUM);
5530: TYPE l_ssid_mapping_type IS RECORD (cle_id okc_k_lines_b.id%TYPE := OKC_API.G_MISS_NUM, object1_id1 okc_k_rel_objs_v.object1_id1%TYPE := OKC_API.G_MISS_CHAR);
5531: TYPE l_sid_mapping_type IS RECORD (id okc_k_lines_b.id%TYPE := OKC_API.G_MISS_NUM, lse_id okc_k_lines_b.lse_id%TYPE := OKC_API.G_MISS_NUM);
5532: TYPE l_tid_mapping_type IS RECORD (rgd_code okc_rule_groups_b.rgd_code%TYPE := OKC_API.G_MISS_CHAR, id okc_rule_groups_b.id%TYPE := OKC_API.G_MISS_NUM);

Line 5529: TYPE l_cle_lse_mapping_type IS RECORD (cle_id okc_k_lines_b.id%TYPE := OKC_API.G_MISS_NUM, lse_id NUMBER := OKC_API.G_MISS_NUM, id okc_k_lines_b.id%TYPE := OKC_API.G_MISS_NUM);

5525: -- For okc_k_items whole record
5526:
5527:
5528: TYPE l_bid_mapping_type IS RECORD (old_id okc_k_lines_b.id%TYPE := OKC_API.G_MISS_NUM, new_id okc_k_lines_tl.name%TYPE := OKC_API.G_MISS_CHAR);
5529: TYPE l_cle_lse_mapping_type IS RECORD (cle_id okc_k_lines_b.id%TYPE := OKC_API.G_MISS_NUM, lse_id NUMBER := OKC_API.G_MISS_NUM, id okc_k_lines_b.id%TYPE := OKC_API.G_MISS_NUM);
5530: TYPE l_ssid_mapping_type IS RECORD (cle_id okc_k_lines_b.id%TYPE := OKC_API.G_MISS_NUM, object1_id1 okc_k_rel_objs_v.object1_id1%TYPE := OKC_API.G_MISS_CHAR);
5531: TYPE l_sid_mapping_type IS RECORD (id okc_k_lines_b.id%TYPE := OKC_API.G_MISS_NUM, lse_id okc_k_lines_b.lse_id%TYPE := OKC_API.G_MISS_NUM);
5532: TYPE l_tid_mapping_type IS RECORD (rgd_code okc_rule_groups_b.rgd_code%TYPE := OKC_API.G_MISS_CHAR, id okc_rule_groups_b.id%TYPE := OKC_API.G_MISS_NUM);
5533: TYPE l_vid_mapping_type IS RECORD (cle_id okc_k_party_roles_b.cle_id%TYPE := OKC_API.G_MISS_NUM, object1_id1 okc_k_party_roles_b.object1_id1%TYPE := OKC_API.G_MISS_CHAR);

Line 5530: TYPE l_ssid_mapping_type IS RECORD (cle_id okc_k_lines_b.id%TYPE := OKC_API.G_MISS_NUM, object1_id1 okc_k_rel_objs_v.object1_id1%TYPE := OKC_API.G_MISS_CHAR);

5526:
5527:
5528: TYPE l_bid_mapping_type IS RECORD (old_id okc_k_lines_b.id%TYPE := OKC_API.G_MISS_NUM, new_id okc_k_lines_tl.name%TYPE := OKC_API.G_MISS_CHAR);
5529: TYPE l_cle_lse_mapping_type IS RECORD (cle_id okc_k_lines_b.id%TYPE := OKC_API.G_MISS_NUM, lse_id NUMBER := OKC_API.G_MISS_NUM, id okc_k_lines_b.id%TYPE := OKC_API.G_MISS_NUM);
5530: TYPE l_ssid_mapping_type IS RECORD (cle_id okc_k_lines_b.id%TYPE := OKC_API.G_MISS_NUM, object1_id1 okc_k_rel_objs_v.object1_id1%TYPE := OKC_API.G_MISS_CHAR);
5531: TYPE l_sid_mapping_type IS RECORD (id okc_k_lines_b.id%TYPE := OKC_API.G_MISS_NUM, lse_id okc_k_lines_b.lse_id%TYPE := OKC_API.G_MISS_NUM);
5532: TYPE l_tid_mapping_type IS RECORD (rgd_code okc_rule_groups_b.rgd_code%TYPE := OKC_API.G_MISS_CHAR, id okc_rule_groups_b.id%TYPE := OKC_API.G_MISS_NUM);
5533: TYPE l_vid_mapping_type IS RECORD (cle_id okc_k_party_roles_b.cle_id%TYPE := OKC_API.G_MISS_NUM, object1_id1 okc_k_party_roles_b.object1_id1%TYPE := OKC_API.G_MISS_CHAR);
5534: TYPE l_dbid_mapping_type IS RECORD (tal_id okl_txl_assets_b.id%TYPE := OKC_API.G_MISS_NUM, kle_id okl_txl_assets_b.kle_id%TYPE := OKC_API.G_MISS_NUM);

Line 5531: TYPE l_sid_mapping_type IS RECORD (id okc_k_lines_b.id%TYPE := OKC_API.G_MISS_NUM, lse_id okc_k_lines_b.lse_id%TYPE := OKC_API.G_MISS_NUM);

5527:
5528: TYPE l_bid_mapping_type IS RECORD (old_id okc_k_lines_b.id%TYPE := OKC_API.G_MISS_NUM, new_id okc_k_lines_tl.name%TYPE := OKC_API.G_MISS_CHAR);
5529: TYPE l_cle_lse_mapping_type IS RECORD (cle_id okc_k_lines_b.id%TYPE := OKC_API.G_MISS_NUM, lse_id NUMBER := OKC_API.G_MISS_NUM, id okc_k_lines_b.id%TYPE := OKC_API.G_MISS_NUM);
5530: TYPE l_ssid_mapping_type IS RECORD (cle_id okc_k_lines_b.id%TYPE := OKC_API.G_MISS_NUM, object1_id1 okc_k_rel_objs_v.object1_id1%TYPE := OKC_API.G_MISS_CHAR);
5531: TYPE l_sid_mapping_type IS RECORD (id okc_k_lines_b.id%TYPE := OKC_API.G_MISS_NUM, lse_id okc_k_lines_b.lse_id%TYPE := OKC_API.G_MISS_NUM);
5532: TYPE l_tid_mapping_type IS RECORD (rgd_code okc_rule_groups_b.rgd_code%TYPE := OKC_API.G_MISS_CHAR, id okc_rule_groups_b.id%TYPE := OKC_API.G_MISS_NUM);
5533: TYPE l_vid_mapping_type IS RECORD (cle_id okc_k_party_roles_b.cle_id%TYPE := OKC_API.G_MISS_NUM, object1_id1 okc_k_party_roles_b.object1_id1%TYPE := OKC_API.G_MISS_CHAR);
5534: TYPE l_dbid_mapping_type IS RECORD (tal_id okl_txl_assets_b.id%TYPE := OKC_API.G_MISS_NUM, kle_id okl_txl_assets_b.kle_id%TYPE := OKC_API.G_MISS_NUM);
5535: TYPE l_osid_mapping_type IS RECORD (id okl_k_lines.id%TYPE := OKC_API.G_MISS_NUM, subsidy_id okl_k_lines.subsidy_id%TYPE := OKC_API.G_MISS_NUM);

Line 5532: TYPE l_tid_mapping_type IS RECORD (rgd_code okc_rule_groups_b.rgd_code%TYPE := OKC_API.G_MISS_CHAR, id okc_rule_groups_b.id%TYPE := OKC_API.G_MISS_NUM);

5528: TYPE l_bid_mapping_type IS RECORD (old_id okc_k_lines_b.id%TYPE := OKC_API.G_MISS_NUM, new_id okc_k_lines_tl.name%TYPE := OKC_API.G_MISS_CHAR);
5529: TYPE l_cle_lse_mapping_type IS RECORD (cle_id okc_k_lines_b.id%TYPE := OKC_API.G_MISS_NUM, lse_id NUMBER := OKC_API.G_MISS_NUM, id okc_k_lines_b.id%TYPE := OKC_API.G_MISS_NUM);
5530: TYPE l_ssid_mapping_type IS RECORD (cle_id okc_k_lines_b.id%TYPE := OKC_API.G_MISS_NUM, object1_id1 okc_k_rel_objs_v.object1_id1%TYPE := OKC_API.G_MISS_CHAR);
5531: TYPE l_sid_mapping_type IS RECORD (id okc_k_lines_b.id%TYPE := OKC_API.G_MISS_NUM, lse_id okc_k_lines_b.lse_id%TYPE := OKC_API.G_MISS_NUM);
5532: TYPE l_tid_mapping_type IS RECORD (rgd_code okc_rule_groups_b.rgd_code%TYPE := OKC_API.G_MISS_CHAR, id okc_rule_groups_b.id%TYPE := OKC_API.G_MISS_NUM);
5533: TYPE l_vid_mapping_type IS RECORD (cle_id okc_k_party_roles_b.cle_id%TYPE := OKC_API.G_MISS_NUM, object1_id1 okc_k_party_roles_b.object1_id1%TYPE := OKC_API.G_MISS_CHAR);
5534: TYPE l_dbid_mapping_type IS RECORD (tal_id okl_txl_assets_b.id%TYPE := OKC_API.G_MISS_NUM, kle_id okl_txl_assets_b.kle_id%TYPE := OKC_API.G_MISS_NUM);
5535: TYPE l_osid_mapping_type IS RECORD (id okl_k_lines.id%TYPE := OKC_API.G_MISS_NUM, subsidy_id okl_k_lines.subsidy_id%TYPE := OKC_API.G_MISS_NUM);
5536: TYPE l_cid_mapping_type IS RECORD (old_id okc_k_lines_b.id%TYPE := OKC_API.G_MISS_NUM, new_id okc_k_lines_b.cle_id%TYPE := OKC_API.G_MISS_NUM);

Line 5533: TYPE l_vid_mapping_type IS RECORD (cle_id okc_k_party_roles_b.cle_id%TYPE := OKC_API.G_MISS_NUM, object1_id1 okc_k_party_roles_b.object1_id1%TYPE := OKC_API.G_MISS_CHAR);

5529: TYPE l_cle_lse_mapping_type IS RECORD (cle_id okc_k_lines_b.id%TYPE := OKC_API.G_MISS_NUM, lse_id NUMBER := OKC_API.G_MISS_NUM, id okc_k_lines_b.id%TYPE := OKC_API.G_MISS_NUM);
5530: TYPE l_ssid_mapping_type IS RECORD (cle_id okc_k_lines_b.id%TYPE := OKC_API.G_MISS_NUM, object1_id1 okc_k_rel_objs_v.object1_id1%TYPE := OKC_API.G_MISS_CHAR);
5531: TYPE l_sid_mapping_type IS RECORD (id okc_k_lines_b.id%TYPE := OKC_API.G_MISS_NUM, lse_id okc_k_lines_b.lse_id%TYPE := OKC_API.G_MISS_NUM);
5532: TYPE l_tid_mapping_type IS RECORD (rgd_code okc_rule_groups_b.rgd_code%TYPE := OKC_API.G_MISS_CHAR, id okc_rule_groups_b.id%TYPE := OKC_API.G_MISS_NUM);
5533: TYPE l_vid_mapping_type IS RECORD (cle_id okc_k_party_roles_b.cle_id%TYPE := OKC_API.G_MISS_NUM, object1_id1 okc_k_party_roles_b.object1_id1%TYPE := OKC_API.G_MISS_CHAR);
5534: TYPE l_dbid_mapping_type IS RECORD (tal_id okl_txl_assets_b.id%TYPE := OKC_API.G_MISS_NUM, kle_id okl_txl_assets_b.kle_id%TYPE := OKC_API.G_MISS_NUM);
5535: TYPE l_osid_mapping_type IS RECORD (id okl_k_lines.id%TYPE := OKC_API.G_MISS_NUM, subsidy_id okl_k_lines.subsidy_id%TYPE := OKC_API.G_MISS_NUM);
5536: TYPE l_cid_mapping_type IS RECORD (old_id okc_k_lines_b.id%TYPE := OKC_API.G_MISS_NUM, new_id okc_k_lines_b.cle_id%TYPE := OKC_API.G_MISS_NUM);
5537: TYPE l_rid_mapping_type IS RECORD (old_id okc_rule_groups_b.id%TYPE := OKC_API.G_MISS_NUM, new_id okc_rule_groups_b.id%TYPE := OKC_API.G_MISS_NUM);

Line 5534: TYPE l_dbid_mapping_type IS RECORD (tal_id okl_txl_assets_b.id%TYPE := OKC_API.G_MISS_NUM, kle_id okl_txl_assets_b.kle_id%TYPE := OKC_API.G_MISS_NUM);

5530: TYPE l_ssid_mapping_type IS RECORD (cle_id okc_k_lines_b.id%TYPE := OKC_API.G_MISS_NUM, object1_id1 okc_k_rel_objs_v.object1_id1%TYPE := OKC_API.G_MISS_CHAR);
5531: TYPE l_sid_mapping_type IS RECORD (id okc_k_lines_b.id%TYPE := OKC_API.G_MISS_NUM, lse_id okc_k_lines_b.lse_id%TYPE := OKC_API.G_MISS_NUM);
5532: TYPE l_tid_mapping_type IS RECORD (rgd_code okc_rule_groups_b.rgd_code%TYPE := OKC_API.G_MISS_CHAR, id okc_rule_groups_b.id%TYPE := OKC_API.G_MISS_NUM);
5533: TYPE l_vid_mapping_type IS RECORD (cle_id okc_k_party_roles_b.cle_id%TYPE := OKC_API.G_MISS_NUM, object1_id1 okc_k_party_roles_b.object1_id1%TYPE := OKC_API.G_MISS_CHAR);
5534: TYPE l_dbid_mapping_type IS RECORD (tal_id okl_txl_assets_b.id%TYPE := OKC_API.G_MISS_NUM, kle_id okl_txl_assets_b.kle_id%TYPE := OKC_API.G_MISS_NUM);
5535: TYPE l_osid_mapping_type IS RECORD (id okl_k_lines.id%TYPE := OKC_API.G_MISS_NUM, subsidy_id okl_k_lines.subsidy_id%TYPE := OKC_API.G_MISS_NUM);
5536: TYPE l_cid_mapping_type IS RECORD (old_id okc_k_lines_b.id%TYPE := OKC_API.G_MISS_NUM, new_id okc_k_lines_b.cle_id%TYPE := OKC_API.G_MISS_NUM);
5537: TYPE l_rid_mapping_type IS RECORD (old_id okc_rule_groups_b.id%TYPE := OKC_API.G_MISS_NUM, new_id okc_rule_groups_b.id%TYPE := OKC_API.G_MISS_NUM);
5538: TYPE l_id_mapping_type IS RECORD (old_id okc_k_lines_b.id%TYPE := OKC_API.G_MISS_NUM, new_id okc_k_lines_b.id%TYPE := OKC_API.G_MISS_NUM);

Line 5535: TYPE l_osid_mapping_type IS RECORD (id okl_k_lines.id%TYPE := OKC_API.G_MISS_NUM, subsidy_id okl_k_lines.subsidy_id%TYPE := OKC_API.G_MISS_NUM);

5531: TYPE l_sid_mapping_type IS RECORD (id okc_k_lines_b.id%TYPE := OKC_API.G_MISS_NUM, lse_id okc_k_lines_b.lse_id%TYPE := OKC_API.G_MISS_NUM);
5532: TYPE l_tid_mapping_type IS RECORD (rgd_code okc_rule_groups_b.rgd_code%TYPE := OKC_API.G_MISS_CHAR, id okc_rule_groups_b.id%TYPE := OKC_API.G_MISS_NUM);
5533: TYPE l_vid_mapping_type IS RECORD (cle_id okc_k_party_roles_b.cle_id%TYPE := OKC_API.G_MISS_NUM, object1_id1 okc_k_party_roles_b.object1_id1%TYPE := OKC_API.G_MISS_CHAR);
5534: TYPE l_dbid_mapping_type IS RECORD (tal_id okl_txl_assets_b.id%TYPE := OKC_API.G_MISS_NUM, kle_id okl_txl_assets_b.kle_id%TYPE := OKC_API.G_MISS_NUM);
5535: TYPE l_osid_mapping_type IS RECORD (id okl_k_lines.id%TYPE := OKC_API.G_MISS_NUM, subsidy_id okl_k_lines.subsidy_id%TYPE := OKC_API.G_MISS_NUM);
5536: TYPE l_cid_mapping_type IS RECORD (old_id okc_k_lines_b.id%TYPE := OKC_API.G_MISS_NUM, new_id okc_k_lines_b.cle_id%TYPE := OKC_API.G_MISS_NUM);
5537: TYPE l_rid_mapping_type IS RECORD (old_id okc_rule_groups_b.id%TYPE := OKC_API.G_MISS_NUM, new_id okc_rule_groups_b.id%TYPE := OKC_API.G_MISS_NUM);
5538: TYPE l_id_mapping_type IS RECORD (old_id okc_k_lines_b.id%TYPE := OKC_API.G_MISS_NUM, new_id okc_k_lines_b.id%TYPE := OKC_API.G_MISS_NUM);
5539: TYPE l_orig_system_rec_type IS RECORD (orig_system_id1 okc_k_lines_b.orig_system_id1%TYPE := OKC_API.G_MISS_NUM, id okc_k_lines_b.id%TYPE := OKC_API.G_MISS_NUM);

Line 5536: TYPE l_cid_mapping_type IS RECORD (old_id okc_k_lines_b.id%TYPE := OKC_API.G_MISS_NUM, new_id okc_k_lines_b.cle_id%TYPE := OKC_API.G_MISS_NUM);

5532: TYPE l_tid_mapping_type IS RECORD (rgd_code okc_rule_groups_b.rgd_code%TYPE := OKC_API.G_MISS_CHAR, id okc_rule_groups_b.id%TYPE := OKC_API.G_MISS_NUM);
5533: TYPE l_vid_mapping_type IS RECORD (cle_id okc_k_party_roles_b.cle_id%TYPE := OKC_API.G_MISS_NUM, object1_id1 okc_k_party_roles_b.object1_id1%TYPE := OKC_API.G_MISS_CHAR);
5534: TYPE l_dbid_mapping_type IS RECORD (tal_id okl_txl_assets_b.id%TYPE := OKC_API.G_MISS_NUM, kle_id okl_txl_assets_b.kle_id%TYPE := OKC_API.G_MISS_NUM);
5535: TYPE l_osid_mapping_type IS RECORD (id okl_k_lines.id%TYPE := OKC_API.G_MISS_NUM, subsidy_id okl_k_lines.subsidy_id%TYPE := OKC_API.G_MISS_NUM);
5536: TYPE l_cid_mapping_type IS RECORD (old_id okc_k_lines_b.id%TYPE := OKC_API.G_MISS_NUM, new_id okc_k_lines_b.cle_id%TYPE := OKC_API.G_MISS_NUM);
5537: TYPE l_rid_mapping_type IS RECORD (old_id okc_rule_groups_b.id%TYPE := OKC_API.G_MISS_NUM, new_id okc_rule_groups_b.id%TYPE := OKC_API.G_MISS_NUM);
5538: TYPE l_id_mapping_type IS RECORD (old_id okc_k_lines_b.id%TYPE := OKC_API.G_MISS_NUM, new_id okc_k_lines_b.id%TYPE := OKC_API.G_MISS_NUM);
5539: TYPE l_orig_system_rec_type IS RECORD (orig_system_id1 okc_k_lines_b.orig_system_id1%TYPE := OKC_API.G_MISS_NUM, id okc_k_lines_b.id%TYPE := OKC_API.G_MISS_NUM);
5540: TYPE l_rrid_mapping_type IS RECORD (old_id okc_rules_b.id%TYPE := OKC_API.G_MISS_NUM, new_id okc_rules_b.id%TYPE := OKC_API.G_MISS_NUM);

Line 5537: TYPE l_rid_mapping_type IS RECORD (old_id okc_rule_groups_b.id%TYPE := OKC_API.G_MISS_NUM, new_id okc_rule_groups_b.id%TYPE := OKC_API.G_MISS_NUM);

5533: TYPE l_vid_mapping_type IS RECORD (cle_id okc_k_party_roles_b.cle_id%TYPE := OKC_API.G_MISS_NUM, object1_id1 okc_k_party_roles_b.object1_id1%TYPE := OKC_API.G_MISS_CHAR);
5534: TYPE l_dbid_mapping_type IS RECORD (tal_id okl_txl_assets_b.id%TYPE := OKC_API.G_MISS_NUM, kle_id okl_txl_assets_b.kle_id%TYPE := OKC_API.G_MISS_NUM);
5535: TYPE l_osid_mapping_type IS RECORD (id okl_k_lines.id%TYPE := OKC_API.G_MISS_NUM, subsidy_id okl_k_lines.subsidy_id%TYPE := OKC_API.G_MISS_NUM);
5536: TYPE l_cid_mapping_type IS RECORD (old_id okc_k_lines_b.id%TYPE := OKC_API.G_MISS_NUM, new_id okc_k_lines_b.cle_id%TYPE := OKC_API.G_MISS_NUM);
5537: TYPE l_rid_mapping_type IS RECORD (old_id okc_rule_groups_b.id%TYPE := OKC_API.G_MISS_NUM, new_id okc_rule_groups_b.id%TYPE := OKC_API.G_MISS_NUM);
5538: TYPE l_id_mapping_type IS RECORD (old_id okc_k_lines_b.id%TYPE := OKC_API.G_MISS_NUM, new_id okc_k_lines_b.id%TYPE := OKC_API.G_MISS_NUM);
5539: TYPE l_orig_system_rec_type IS RECORD (orig_system_id1 okc_k_lines_b.orig_system_id1%TYPE := OKC_API.G_MISS_NUM, id okc_k_lines_b.id%TYPE := OKC_API.G_MISS_NUM);
5540: TYPE l_rrid_mapping_type IS RECORD (old_id okc_rules_b.id%TYPE := OKC_API.G_MISS_NUM, new_id okc_rules_b.id%TYPE := OKC_API.G_MISS_NUM);
5541: TYPE l_aid_mapping_type IS RECORD (old_id okc_k_lines_tl.name%TYPE := OKC_API.G_MISS_CHAR, new_id okc_k_lines_tl.name%TYPE := OKC_API.G_MISS_CHAR);

Line 5538: TYPE l_id_mapping_type IS RECORD (old_id okc_k_lines_b.id%TYPE := OKC_API.G_MISS_NUM, new_id okc_k_lines_b.id%TYPE := OKC_API.G_MISS_NUM);

5534: TYPE l_dbid_mapping_type IS RECORD (tal_id okl_txl_assets_b.id%TYPE := OKC_API.G_MISS_NUM, kle_id okl_txl_assets_b.kle_id%TYPE := OKC_API.G_MISS_NUM);
5535: TYPE l_osid_mapping_type IS RECORD (id okl_k_lines.id%TYPE := OKC_API.G_MISS_NUM, subsidy_id okl_k_lines.subsidy_id%TYPE := OKC_API.G_MISS_NUM);
5536: TYPE l_cid_mapping_type IS RECORD (old_id okc_k_lines_b.id%TYPE := OKC_API.G_MISS_NUM, new_id okc_k_lines_b.cle_id%TYPE := OKC_API.G_MISS_NUM);
5537: TYPE l_rid_mapping_type IS RECORD (old_id okc_rule_groups_b.id%TYPE := OKC_API.G_MISS_NUM, new_id okc_rule_groups_b.id%TYPE := OKC_API.G_MISS_NUM);
5538: TYPE l_id_mapping_type IS RECORD (old_id okc_k_lines_b.id%TYPE := OKC_API.G_MISS_NUM, new_id okc_k_lines_b.id%TYPE := OKC_API.G_MISS_NUM);
5539: TYPE l_orig_system_rec_type IS RECORD (orig_system_id1 okc_k_lines_b.orig_system_id1%TYPE := OKC_API.G_MISS_NUM, id okc_k_lines_b.id%TYPE := OKC_API.G_MISS_NUM);
5540: TYPE l_rrid_mapping_type IS RECORD (old_id okc_rules_b.id%TYPE := OKC_API.G_MISS_NUM, new_id okc_rules_b.id%TYPE := OKC_API.G_MISS_NUM);
5541: TYPE l_aid_mapping_type IS RECORD (old_id okc_k_lines_tl.name%TYPE := OKC_API.G_MISS_CHAR, new_id okc_k_lines_tl.name%TYPE := OKC_API.G_MISS_CHAR);
5542: TYPE l_oid_mapping_type IS RECORD (cle_id okc_k_items.cle_id%TYPE := OKC_API.G_MISS_NUM, object1_id1 okc_k_items.object1_id1%TYPE := OKC_API.G_MISS_CHAR);

Line 5539: TYPE l_orig_system_rec_type IS RECORD (orig_system_id1 okc_k_lines_b.orig_system_id1%TYPE := OKC_API.G_MISS_NUM, id okc_k_lines_b.id%TYPE := OKC_API.G_MISS_NUM);

5535: TYPE l_osid_mapping_type IS RECORD (id okl_k_lines.id%TYPE := OKC_API.G_MISS_NUM, subsidy_id okl_k_lines.subsidy_id%TYPE := OKC_API.G_MISS_NUM);
5536: TYPE l_cid_mapping_type IS RECORD (old_id okc_k_lines_b.id%TYPE := OKC_API.G_MISS_NUM, new_id okc_k_lines_b.cle_id%TYPE := OKC_API.G_MISS_NUM);
5537: TYPE l_rid_mapping_type IS RECORD (old_id okc_rule_groups_b.id%TYPE := OKC_API.G_MISS_NUM, new_id okc_rule_groups_b.id%TYPE := OKC_API.G_MISS_NUM);
5538: TYPE l_id_mapping_type IS RECORD (old_id okc_k_lines_b.id%TYPE := OKC_API.G_MISS_NUM, new_id okc_k_lines_b.id%TYPE := OKC_API.G_MISS_NUM);
5539: TYPE l_orig_system_rec_type IS RECORD (orig_system_id1 okc_k_lines_b.orig_system_id1%TYPE := OKC_API.G_MISS_NUM, id okc_k_lines_b.id%TYPE := OKC_API.G_MISS_NUM);
5540: TYPE l_rrid_mapping_type IS RECORD (old_id okc_rules_b.id%TYPE := OKC_API.G_MISS_NUM, new_id okc_rules_b.id%TYPE := OKC_API.G_MISS_NUM);
5541: TYPE l_aid_mapping_type IS RECORD (old_id okc_k_lines_tl.name%TYPE := OKC_API.G_MISS_CHAR, new_id okc_k_lines_tl.name%TYPE := OKC_API.G_MISS_CHAR);
5542: TYPE l_oid_mapping_type IS RECORD (cle_id okc_k_items.cle_id%TYPE := OKC_API.G_MISS_NUM, object1_id1 okc_k_items.object1_id1%TYPE := OKC_API.G_MISS_CHAR);
5543: TYPE l_cle_mapping_type IS RECORD (old_id okc_k_lines_b.id%TYPE := OKC_API.G_MISS_NUM, new_id okl_trx_assets.id%TYPE := OKC_API.G_MISS_NUM, line_number NUMBER := OKC_API.G_MISS_NUM);

Line 5540: TYPE l_rrid_mapping_type IS RECORD (old_id okc_rules_b.id%TYPE := OKC_API.G_MISS_NUM, new_id okc_rules_b.id%TYPE := OKC_API.G_MISS_NUM);

5536: TYPE l_cid_mapping_type IS RECORD (old_id okc_k_lines_b.id%TYPE := OKC_API.G_MISS_NUM, new_id okc_k_lines_b.cle_id%TYPE := OKC_API.G_MISS_NUM);
5537: TYPE l_rid_mapping_type IS RECORD (old_id okc_rule_groups_b.id%TYPE := OKC_API.G_MISS_NUM, new_id okc_rule_groups_b.id%TYPE := OKC_API.G_MISS_NUM);
5538: TYPE l_id_mapping_type IS RECORD (old_id okc_k_lines_b.id%TYPE := OKC_API.G_MISS_NUM, new_id okc_k_lines_b.id%TYPE := OKC_API.G_MISS_NUM);
5539: TYPE l_orig_system_rec_type IS RECORD (orig_system_id1 okc_k_lines_b.orig_system_id1%TYPE := OKC_API.G_MISS_NUM, id okc_k_lines_b.id%TYPE := OKC_API.G_MISS_NUM);
5540: TYPE l_rrid_mapping_type IS RECORD (old_id okc_rules_b.id%TYPE := OKC_API.G_MISS_NUM, new_id okc_rules_b.id%TYPE := OKC_API.G_MISS_NUM);
5541: TYPE l_aid_mapping_type IS RECORD (old_id okc_k_lines_tl.name%TYPE := OKC_API.G_MISS_CHAR, new_id okc_k_lines_tl.name%TYPE := OKC_API.G_MISS_CHAR);
5542: TYPE l_oid_mapping_type IS RECORD (cle_id okc_k_items.cle_id%TYPE := OKC_API.G_MISS_NUM, object1_id1 okc_k_items.object1_id1%TYPE := OKC_API.G_MISS_CHAR);
5543: TYPE l_cle_mapping_type IS RECORD (old_id okc_k_lines_b.id%TYPE := OKC_API.G_MISS_NUM, new_id okl_trx_assets.id%TYPE := OKC_API.G_MISS_NUM, line_number NUMBER := OKC_API.G_MISS_NUM);
5544: TYPE l_cle_mapping_type2 IS RECORD (old_id okc_k_lines_b.id%TYPE := OKC_API.G_MISS_NUM, new_id okl_trx_assets.id%TYPE := OKC_API.G_MISS_NUM);

Line 5541: TYPE l_aid_mapping_type IS RECORD (old_id okc_k_lines_tl.name%TYPE := OKC_API.G_MISS_CHAR, new_id okc_k_lines_tl.name%TYPE := OKC_API.G_MISS_CHAR);

5537: TYPE l_rid_mapping_type IS RECORD (old_id okc_rule_groups_b.id%TYPE := OKC_API.G_MISS_NUM, new_id okc_rule_groups_b.id%TYPE := OKC_API.G_MISS_NUM);
5538: TYPE l_id_mapping_type IS RECORD (old_id okc_k_lines_b.id%TYPE := OKC_API.G_MISS_NUM, new_id okc_k_lines_b.id%TYPE := OKC_API.G_MISS_NUM);
5539: TYPE l_orig_system_rec_type IS RECORD (orig_system_id1 okc_k_lines_b.orig_system_id1%TYPE := OKC_API.G_MISS_NUM, id okc_k_lines_b.id%TYPE := OKC_API.G_MISS_NUM);
5540: TYPE l_rrid_mapping_type IS RECORD (old_id okc_rules_b.id%TYPE := OKC_API.G_MISS_NUM, new_id okc_rules_b.id%TYPE := OKC_API.G_MISS_NUM);
5541: TYPE l_aid_mapping_type IS RECORD (old_id okc_k_lines_tl.name%TYPE := OKC_API.G_MISS_CHAR, new_id okc_k_lines_tl.name%TYPE := OKC_API.G_MISS_CHAR);
5542: TYPE l_oid_mapping_type IS RECORD (cle_id okc_k_items.cle_id%TYPE := OKC_API.G_MISS_NUM, object1_id1 okc_k_items.object1_id1%TYPE := OKC_API.G_MISS_CHAR);
5543: TYPE l_cle_mapping_type IS RECORD (old_id okc_k_lines_b.id%TYPE := OKC_API.G_MISS_NUM, new_id okl_trx_assets.id%TYPE := OKC_API.G_MISS_NUM, line_number NUMBER := OKC_API.G_MISS_NUM);
5544: TYPE l_cle_mapping_type2 IS RECORD (old_id okc_k_lines_b.id%TYPE := OKC_API.G_MISS_NUM, new_id okl_trx_assets.id%TYPE := OKC_API.G_MISS_NUM);
5545:

Line 5542: TYPE l_oid_mapping_type IS RECORD (cle_id okc_k_items.cle_id%TYPE := OKC_API.G_MISS_NUM, object1_id1 okc_k_items.object1_id1%TYPE := OKC_API.G_MISS_CHAR);

5538: TYPE l_id_mapping_type IS RECORD (old_id okc_k_lines_b.id%TYPE := OKC_API.G_MISS_NUM, new_id okc_k_lines_b.id%TYPE := OKC_API.G_MISS_NUM);
5539: TYPE l_orig_system_rec_type IS RECORD (orig_system_id1 okc_k_lines_b.orig_system_id1%TYPE := OKC_API.G_MISS_NUM, id okc_k_lines_b.id%TYPE := OKC_API.G_MISS_NUM);
5540: TYPE l_rrid_mapping_type IS RECORD (old_id okc_rules_b.id%TYPE := OKC_API.G_MISS_NUM, new_id okc_rules_b.id%TYPE := OKC_API.G_MISS_NUM);
5541: TYPE l_aid_mapping_type IS RECORD (old_id okc_k_lines_tl.name%TYPE := OKC_API.G_MISS_CHAR, new_id okc_k_lines_tl.name%TYPE := OKC_API.G_MISS_CHAR);
5542: TYPE l_oid_mapping_type IS RECORD (cle_id okc_k_items.cle_id%TYPE := OKC_API.G_MISS_NUM, object1_id1 okc_k_items.object1_id1%TYPE := OKC_API.G_MISS_CHAR);
5543: TYPE l_cle_mapping_type IS RECORD (old_id okc_k_lines_b.id%TYPE := OKC_API.G_MISS_NUM, new_id okl_trx_assets.id%TYPE := OKC_API.G_MISS_NUM, line_number NUMBER := OKC_API.G_MISS_NUM);
5544: TYPE l_cle_mapping_type2 IS RECORD (old_id okc_k_lines_b.id%TYPE := OKC_API.G_MISS_NUM, new_id okl_trx_assets.id%TYPE := OKC_API.G_MISS_NUM);
5545:
5546: TYPE l_bid_mapping_tab_type IS TABLE OF l_bid_mapping_type INDEX BY BINARY_INTEGER;

Line 5543: TYPE l_cle_mapping_type IS RECORD (old_id okc_k_lines_b.id%TYPE := OKC_API.G_MISS_NUM, new_id okl_trx_assets.id%TYPE := OKC_API.G_MISS_NUM, line_number NUMBER := OKC_API.G_MISS_NUM);

5539: TYPE l_orig_system_rec_type IS RECORD (orig_system_id1 okc_k_lines_b.orig_system_id1%TYPE := OKC_API.G_MISS_NUM, id okc_k_lines_b.id%TYPE := OKC_API.G_MISS_NUM);
5540: TYPE l_rrid_mapping_type IS RECORD (old_id okc_rules_b.id%TYPE := OKC_API.G_MISS_NUM, new_id okc_rules_b.id%TYPE := OKC_API.G_MISS_NUM);
5541: TYPE l_aid_mapping_type IS RECORD (old_id okc_k_lines_tl.name%TYPE := OKC_API.G_MISS_CHAR, new_id okc_k_lines_tl.name%TYPE := OKC_API.G_MISS_CHAR);
5542: TYPE l_oid_mapping_type IS RECORD (cle_id okc_k_items.cle_id%TYPE := OKC_API.G_MISS_NUM, object1_id1 okc_k_items.object1_id1%TYPE := OKC_API.G_MISS_CHAR);
5543: TYPE l_cle_mapping_type IS RECORD (old_id okc_k_lines_b.id%TYPE := OKC_API.G_MISS_NUM, new_id okl_trx_assets.id%TYPE := OKC_API.G_MISS_NUM, line_number NUMBER := OKC_API.G_MISS_NUM);
5544: TYPE l_cle_mapping_type2 IS RECORD (old_id okc_k_lines_b.id%TYPE := OKC_API.G_MISS_NUM, new_id okl_trx_assets.id%TYPE := OKC_API.G_MISS_NUM);
5545:
5546: TYPE l_bid_mapping_tab_type IS TABLE OF l_bid_mapping_type INDEX BY BINARY_INTEGER;
5547: TYPE l_cle_lse_mapping_tab_type IS TABLE OF l_cle_lse_mapping_type INDEX BY BINARY_INTEGER;

Line 5544: TYPE l_cle_mapping_type2 IS RECORD (old_id okc_k_lines_b.id%TYPE := OKC_API.G_MISS_NUM, new_id okl_trx_assets.id%TYPE := OKC_API.G_MISS_NUM);

5540: TYPE l_rrid_mapping_type IS RECORD (old_id okc_rules_b.id%TYPE := OKC_API.G_MISS_NUM, new_id okc_rules_b.id%TYPE := OKC_API.G_MISS_NUM);
5541: TYPE l_aid_mapping_type IS RECORD (old_id okc_k_lines_tl.name%TYPE := OKC_API.G_MISS_CHAR, new_id okc_k_lines_tl.name%TYPE := OKC_API.G_MISS_CHAR);
5542: TYPE l_oid_mapping_type IS RECORD (cle_id okc_k_items.cle_id%TYPE := OKC_API.G_MISS_NUM, object1_id1 okc_k_items.object1_id1%TYPE := OKC_API.G_MISS_CHAR);
5543: TYPE l_cle_mapping_type IS RECORD (old_id okc_k_lines_b.id%TYPE := OKC_API.G_MISS_NUM, new_id okl_trx_assets.id%TYPE := OKC_API.G_MISS_NUM, line_number NUMBER := OKC_API.G_MISS_NUM);
5544: TYPE l_cle_mapping_type2 IS RECORD (old_id okc_k_lines_b.id%TYPE := OKC_API.G_MISS_NUM, new_id okl_trx_assets.id%TYPE := OKC_API.G_MISS_NUM);
5545:
5546: TYPE l_bid_mapping_tab_type IS TABLE OF l_bid_mapping_type INDEX BY BINARY_INTEGER;
5547: TYPE l_cle_lse_mapping_tab_type IS TABLE OF l_cle_lse_mapping_type INDEX BY BINARY_INTEGER;
5548: TYPE l_ssid_mapping_tab_type IS TABLE OF l_ssid_mapping_type INDEX BY BINARY_INTEGER;

Line 5564: TYPE l_party_id_mapping_type IS RECORD (old_id okc_k_party_roles_b.id%TYPE := OKC_API.G_MISS_NUM, new_id okc_k_party_roles_b.id%TYPE := OKC_API.G_MISS_NUM);

5560: TYPE l_oid_mapping_tab_type IS TABLE OF l_oid_mapping_type INDEX BY BINARY_INTEGER;
5561: TYPE l_cle_mapping_tab_type IS TABLE OF l_cle_mapping_type INDEX BY BINARY_INTEGER;
5562: TYPE l_cle_mapping_tab_type2 IS TABLE OF l_cle_mapping_type2 INDEX BY BINARY_INTEGER;
5563:
5564: TYPE l_party_id_mapping_type IS RECORD (old_id okc_k_party_roles_b.id%TYPE := OKC_API.G_MISS_NUM, new_id okc_k_party_roles_b.id%TYPE := OKC_API.G_MISS_NUM);
5565: TYPE l_party_id_mapping_tab_type IS TABLE OF l_party_id_mapping_type INDEX BY BINARY_INTEGER;
5566:
5567: TYPE l_trx_id_mapping_type IS RECORD (old_id okl_trx_assets.id%TYPE := OKC_API.G_MISS_NUM, new_id okl_trx_assets.id%TYPE := OKC_API.G_MISS_NUM);
5568: TYPE l_trx_id_mapping_tab_type IS TABLE OF l_trx_id_mapping_type INDEX BY BINARY_INTEGER;

Line 5567: TYPE l_trx_id_mapping_type IS RECORD (old_id okl_trx_assets.id%TYPE := OKC_API.G_MISS_NUM, new_id okl_trx_assets.id%TYPE := OKC_API.G_MISS_NUM);

5563:
5564: TYPE l_party_id_mapping_type IS RECORD (old_id okc_k_party_roles_b.id%TYPE := OKC_API.G_MISS_NUM, new_id okc_k_party_roles_b.id%TYPE := OKC_API.G_MISS_NUM);
5565: TYPE l_party_id_mapping_tab_type IS TABLE OF l_party_id_mapping_type INDEX BY BINARY_INTEGER;
5566:
5567: TYPE l_trx_id_mapping_type IS RECORD (old_id okl_trx_assets.id%TYPE := OKC_API.G_MISS_NUM, new_id okl_trx_assets.id%TYPE := OKC_API.G_MISS_NUM);
5568: TYPE l_trx_id_mapping_tab_type IS TABLE OF l_trx_id_mapping_type INDEX BY BINARY_INTEGER;
5569:
5570: TYPE l_txl_id_mapping_type IS RECORD (old_id okl_txl_assets_b.id%TYPE := OKC_API.G_MISS_NUM, new_id okl_txl_assets_b.id%TYPE := OKC_API.G_MISS_NUM);
5571: TYPE l_txl_id_mapping_tab_type IS TABLE OF l_txl_id_mapping_type INDEX BY BINARY_INTEGER;

Line 5570: TYPE l_txl_id_mapping_type IS RECORD (old_id okl_txl_assets_b.id%TYPE := OKC_API.G_MISS_NUM, new_id okl_txl_assets_b.id%TYPE := OKC_API.G_MISS_NUM);

5566:
5567: TYPE l_trx_id_mapping_type IS RECORD (old_id okl_trx_assets.id%TYPE := OKC_API.G_MISS_NUM, new_id okl_trx_assets.id%TYPE := OKC_API.G_MISS_NUM);
5568: TYPE l_trx_id_mapping_tab_type IS TABLE OF l_trx_id_mapping_type INDEX BY BINARY_INTEGER;
5569:
5570: TYPE l_txl_id_mapping_type IS RECORD (old_id okl_txl_assets_b.id%TYPE := OKC_API.G_MISS_NUM, new_id okl_txl_assets_b.id%TYPE := OKC_API.G_MISS_NUM);
5571: TYPE l_txl_id_mapping_tab_type IS TABLE OF l_txl_id_mapping_type INDEX BY BINARY_INTEGER;
5572:
5573: -- For okl_k_party_roles begin
5574: TYPE l_plid_type is table of okl_k_party_roles.id%TYPE index by binary_integer;

Line 7328: x_return_status := OKC_API.G_RET_STS_SUCCESS;

7324: AND NVL(end_date_active,SYSDATE);
7325: BEGIN
7326:
7327: -- initialize return status
7328: x_return_status := OKC_API.G_RET_STS_SUCCESS;
7329:
7330: -- check that data exists
7331: IF (p_ccy_code = OKC_API.G_MISS_CHAR OR
7332: p_ccy_code IS NULL)

Line 7331: IF (p_ccy_code = OKC_API.G_MISS_CHAR OR

7327: -- initialize return status
7328: x_return_status := OKC_API.G_RET_STS_SUCCESS;
7329:
7330: -- check that data exists
7331: IF (p_ccy_code = OKC_API.G_MISS_CHAR OR
7332: p_ccy_code IS NULL)
7333: THEN
7334: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
7335: p_msg_name => g_required_value,

Line 7334: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

7330: -- check that data exists
7331: IF (p_ccy_code = OKC_API.G_MISS_CHAR OR
7332: p_ccy_code IS NULL)
7333: THEN
7334: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
7335: p_msg_name => g_required_value,
7336: p_token1 => g_col_name_token,
7337: p_token1_value => 'Currency Code');
7338: -- notify caller of an error

Line 7339: x_return_status := OKC_API.G_RET_STS_ERROR;

7335: p_msg_name => g_required_value,
7336: p_token1 => g_col_name_token,
7337: p_token1_value => 'Currency Code');
7338: -- notify caller of an error
7339: x_return_status := OKC_API.G_RET_STS_ERROR;
7340:
7341: -- halt validation
7342: RAISE G_EXCEPTION_HALT_VALIDATION;
7343: END IF;

Line 7352: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

7348: CLOSE l_fndv_csr;
7349:
7350: -- if l_dummy_var still set to default, data was not found
7351: IF (l_dummy_var = '?') THEN
7352: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
7353: p_msg_name => 'OKL_NO_PARENT_RECORD',
7354: p_token1 => g_col_name_token,
7355: p_token1_value => 'currency_code',
7356: p_token2 => g_child_table_token,

Line 7361: x_return_status := OKC_API.G_RET_STS_ERROR;

7357: p_token2_value => 'OKL_TRX_AP_INVOICES_V',
7358: p_token3 => g_parent_table_token,
7359: p_token3_value => 'FND_CURRENCIES');
7360: -- notify caller of an error
7361: x_return_status := OKC_API.G_RET_STS_ERROR;
7362: END IF;
7363:
7364:
7365: EXCEPTION

Line 7376: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

7372: WHEN OTHERS THEN
7373:
7374:
7375: -- store SQL error message on message stack
7376: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
7377: p_msg_name => g_unexpected_error,
7378: p_token1 => g_sqlcode_token,
7379: p_token1_value => SQLCODE,
7380: p_token2 => g_sqlerrm_token,

Line 7383: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

7379: p_token1_value => SQLCODE,
7380: p_token2 => g_sqlerrm_token,
7381: p_token2_value => SQLERRM);
7382: -- notify caller of an error as UNEXPETED error
7383: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
7384:
7385: -- verify that cursor was closed
7386: IF l_fndv_csr%ISOPEN THEN
7387: CLOSE l_fndv_csr;

Line 7401: x_return_status := OKC_API.G_RET_STS_SUCCESS;

7397: BEGIN
7398:
7399:
7400: -- initialize return status
7401: x_return_status := OKC_API.G_RET_STS_SUCCESS;
7402:
7403: -- enforce foreign key if data exists
7404: IF (p_orig_system_source_code <> OKC_API.G_MISS_CHAR AND
7405: p_orig_system_source_code IS NOT NULL)

Line 7404: IF (p_orig_system_source_code <> OKC_API.G_MISS_CHAR AND

7400: -- initialize return status
7401: x_return_status := OKC_API.G_RET_STS_SUCCESS;
7402:
7403: -- enforce foreign key if data exists
7404: IF (p_orig_system_source_code <> OKC_API.G_MISS_CHAR AND
7405: p_orig_system_source_code IS NOT NULL)
7406: THEN
7407: -- Check if the value is a valid code from lookup table
7408: x_return_status := OKC_UTIL.check_lookup_code('OKC_CONTRACT_SOURCES',

Line 7410: IF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

7406: THEN
7407: -- Check if the value is a valid code from lookup table
7408: x_return_status := OKC_UTIL.check_lookup_code('OKC_CONTRACT_SOURCES',
7409: p_orig_system_source_code);
7410: IF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
7411: --set error message in message stack
7412: OKC_API.SET_MESSAGE(
7413: p_app_name => G_APP_NAME,
7414: p_msg_name => G_INVALID_VALUE,

Line 7412: OKC_API.SET_MESSAGE(

7408: x_return_status := OKC_UTIL.check_lookup_code('OKC_CONTRACT_SOURCES',
7409: p_orig_system_source_code);
7410: IF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
7411: --set error message in message stack
7412: OKC_API.SET_MESSAGE(
7413: p_app_name => G_APP_NAME,
7414: p_msg_name => G_INVALID_VALUE,
7415: p_token1 => G_COL_NAME_TOKEN,
7416: p_token1_value => 'ORIG_SYSTEM_SOURCE_CODE');

Line 7418: ELSIF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

7414: p_msg_name => G_INVALID_VALUE,
7415: p_token1 => G_COL_NAME_TOKEN,
7416: p_token1_value => 'ORIG_SYSTEM_SOURCE_CODE');
7417: RAISE G_EXCEPTION_HALT_VALIDATION;
7418: ELSIF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
7419: RAISE G_EXCEPTION_HALT_VALIDATION;
7420: END IF;
7421: END IF;
7422:

Line 7429: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

7425: WHEN OTHERS THEN
7426:
7427:
7428: -- store SQL error message on message stack
7429: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
7430: p_msg_name => g_unexpected_error,
7431: p_token1 => g_sqlcode_token,
7432: p_token1_value=> SQLCODE,
7433: p_token2 => g_sqlerrm_token,

Line 7436: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

7432: p_token1_value=> SQLCODE,
7433: p_token2 => g_sqlerrm_token,
7434: p_token2_value=> SQLERRM);
7435: -- notify caller of an error as UNEXPETED error
7436: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
7437:
7438: END validate_orig_sys_code;
7439:
7440: PROCEDURE validate_currency_conv_type

Line 7453: x_return_status := OKC_API.G_RET_STS_SUCCESS;

7449:
7450: l_valid_convert_type VARCHAR2(1) DEFAULT '?';
7451: BEGIN
7452: -- initialize return status
7453: x_return_status := OKC_API.G_RET_STS_SUCCESS;
7454: IF (p_CURRENCY_CONVERSION_TYPE <> OKC_API.G_MISS_CHAR AND
7455: p_CURRENCY_CONVERSION_TYPE IS NOT NULL)
7456: THEN
7457: -- check allowed values

Line 7454: IF (p_CURRENCY_CONVERSION_TYPE <> OKC_API.G_MISS_CHAR AND

7450: l_valid_convert_type VARCHAR2(1) DEFAULT '?';
7451: BEGIN
7452: -- initialize return status
7453: x_return_status := OKC_API.G_RET_STS_SUCCESS;
7454: IF (p_CURRENCY_CONVERSION_TYPE <> OKC_API.G_MISS_CHAR AND
7455: p_CURRENCY_CONVERSION_TYPE IS NOT NULL)
7456: THEN
7457: -- check allowed values
7458: l_valid_convert_type := '?';

Line 7467: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

7463: END IF;
7464: CLOSE curr_conv_type_csr;
7465:
7466: IF (l_valid_convert_type = '?') THEN
7467: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
7468: p_msg_name => g_invalid_value,
7469: p_token1 => g_col_name_token,
7470: p_token1_value => 'CURRENCY_CONVERSION_TYPE');
7471: -- notify caller of an error

Line 7472: x_return_status := OKC_API.G_RET_STS_ERROR;

7468: p_msg_name => g_invalid_value,
7469: p_token1 => g_col_name_token,
7470: p_token1_value => 'CURRENCY_CONVERSION_TYPE');
7471: -- notify caller of an error
7472: x_return_status := OKC_API.G_RET_STS_ERROR;
7473: END IF;
7474: END IF;
7475: EXCEPTION
7476: WHEN OTHERS THEN

Line 7478: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

7474: END IF;
7475: EXCEPTION
7476: WHEN OTHERS THEN
7477: -- store SQL error message on message stack
7478: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
7479: p_msg_name => g_unexpected_error,
7480: p_token1 => g_sqlcode_token,
7481: p_token1_value => SQLCODE,
7482: p_token2 => g_sqlerrm_token,

Line 7485: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

7481: p_token1_value => SQLCODE,
7482: p_token2 => g_sqlerrm_token,
7483: p_token2_value => SQLERRM);
7484: -- notify caller of an error as UNEXPETED error
7485: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
7486: END validate_CURRENCY_CONV_TYPE;
7487:
7488: PROCEDURE validate_amd_code(x_return_status OUT NOCOPY VARCHAR2,
7489: p_amd_code IN okl_k_headers.amd_code%TYPE) IS

Line 7492: x_return_status := OKC_API.G_RET_STS_SUCCESS;

7488: PROCEDURE validate_amd_code(x_return_status OUT NOCOPY VARCHAR2,
7489: p_amd_code IN okl_k_headers.amd_code%TYPE) IS
7490: BEGIN
7491: -- initialize return status
7492: x_return_status := OKC_API.G_RET_STS_SUCCESS;
7493:
7494: -- enforce foreign key if data exists
7495: IF (p_AMD_CODE <> OKC_API.G_MISS_CHAR AND
7496: p_AMD_CODE IS NOT NULL)

Line 7495: IF (p_AMD_CODE <> OKC_API.G_MISS_CHAR AND

7491: -- initialize return status
7492: x_return_status := OKC_API.G_RET_STS_SUCCESS;
7493:
7494: -- enforce foreign key if data exists
7495: IF (p_AMD_CODE <> OKC_API.G_MISS_CHAR AND
7496: p_AMD_CODE IS NOT NULL)
7497: THEN
7498: -- Check if the value is a valid code from lookup table
7499: x_return_status := OKC_UTIL.check_lookup_code('OKL_ACCEPTANCE_METHOD',

Line 7501: IF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

7497: THEN
7498: -- Check if the value is a valid code from lookup table
7499: x_return_status := OKC_UTIL.check_lookup_code('OKL_ACCEPTANCE_METHOD',
7500: p_AMD_CODE);
7501: IF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
7502: --set error message in message stack
7503: OKC_API.SET_MESSAGE(
7504: p_app_name => G_APP_NAME,
7505: p_msg_name => G_INVALID_VALUE,

Line 7503: OKC_API.SET_MESSAGE(

7499: x_return_status := OKC_UTIL.check_lookup_code('OKL_ACCEPTANCE_METHOD',
7500: p_AMD_CODE);
7501: IF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
7502: --set error message in message stack
7503: OKC_API.SET_MESSAGE(
7504: p_app_name => G_APP_NAME,
7505: p_msg_name => G_INVALID_VALUE,
7506: p_token1 => G_COL_NAME_TOKEN,
7507: p_token1_value => 'ACCEPTANCE_METHOD');

Line 7509: ELSIF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

7505: p_msg_name => G_INVALID_VALUE,
7506: p_token1 => G_COL_NAME_TOKEN,
7507: p_token1_value => 'ACCEPTANCE_METHOD');
7508: RAISE G_EXCEPTION_HALT_VALIDATION;
7509: ELSIF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
7510: RAISE G_EXCEPTION_HALT_VALIDATION;
7511: END IF;
7512: END IF;
7513: EXCEPTION

Line 7516: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

7512: END IF;
7513: EXCEPTION
7514: WHEN OTHERS THEN
7515: -- store SQL error message on message stack
7516: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
7517: p_msg_name => g_unexpected_error,
7518: p_token1 => g_sqlcode_token,
7519: p_token1_value => SQLCODE,
7520: p_token2 => g_sqlerrm_token,

Line 7523: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

7519: p_token1_value => SQLCODE,
7520: p_token2 => g_sqlerrm_token,
7521: p_token2_value => SQLERRM);
7522: -- notify caller of an error as UNEXPETED error
7523: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
7524: END validate_AMD_CODE;
7525: /*
7526: */
7527:

Line 7693: RAISE OKC_API.G_EXCEPTION_ERROR;

7689: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_bid_mapping_tab('||i||')=' || l_bid_mapping_tab(i).old_id || ':' || l_bid_mapping_tab(i).new_id);
7690: END IF;
7691: END LOOP;
7692:
7693: RAISE OKC_API.G_EXCEPTION_ERROR;
7694:
7695: END; /* sort_bid_mapping_tab */
7696:
7697: FUNCTION find_cle_lse_mapping_id(p_cle_id IN NUMBER, p_lse_id IN NUMBER) RETURN NUMBER IS

Line 7930: RAISE OKC_API.G_EXCEPTION_ERROR;

7926: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_cle_lse_mapping_tab('||i||')=' || l_cle_lse_mapping_tab(i).cle_id || ':' || l_cle_lse_mapping_tab(i).id);
7927: END IF;
7928: END LOOP;
7929:
7930: RAISE OKC_API.G_EXCEPTION_ERROR;
7931:
7932: END; /* sort_cle_lse_mapping_tab */
7933:
7934:

Line 8097: RAISE OKC_API.G_EXCEPTION_ERROR;

8093: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_cid_mapping_tab('||i||')=' || l_cid_mapping_tab(i).old_id || ':' || l_cid_mapping_tab(i).new_id);
8094: END IF;
8095: END LOOP;
8096:
8097: RAISE OKC_API.G_EXCEPTION_ERROR;
8098:
8099: END; /* sort_cid_mapping_tab */
8100:
8101: PROCEDURE do_sort IS

Line 8270: RAISE OKC_API.G_EXCEPTION_ERROR;

8266: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_orig_system_tab('||i||')=' || l_orig_system_tab(i).orig_system_id1 || ':' || l_orig_system_tab(i).id);
8267: END IF;
8268: END LOOP;
8269:
8270: RAISE OKC_API.G_EXCEPTION_ERROR;
8271:
8272: END; /* do_sort */
8273:
8274: FUNCTION find_id(p_id IN NUMBER) RETURN NUMBER IS

Line 8341: x_return_status := OKC_API.G_RET_STS_ERROR;

8337: BEGIN
8338: OPEN c_asset_no;
8339: FETCH c_asset_no INTO x_asset_number;
8340: IF (c_asset_no%NOTFOUND) THEN
8341: x_return_status := OKC_API.G_RET_STS_ERROR;
8342: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
8343: p_msg_name => g_unexpected_error,
8344: p_token1 => g_sqlcode_token,
8345: p_token1_value => SQLCODE,

Line 8381: x_return_status := OKC_API.G_RET_STS_ERROR;

8377: ln_dummy3 = 1 THEN
8378: OPEN c_asset_no;
8379: FETCH c_asset_no INTO x_asset_number;
8380: IF (c_asset_no%NOTFOUND) THEN
8381: x_return_status := OKC_API.G_RET_STS_ERROR;
8382: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
8383: p_msg_name => g_unexpected_error,
8384: p_token1 => g_sqlcode_token,
8385: p_token1_value => SQLCODE,

Line 8410: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

8406: END IF;
8407: IF c_okx_assets_v%ISOPEN THEN
8408: CLOSE c_okx_assets_v;
8409: END IF;
8410: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
8411: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
8412: p_msg_name => g_unexpected_error,
8413: p_token1 => g_sqlcode_token,
8414: p_token1_value => SQLCODE,

Line 8632: RAISE OKC_API.G_EXCEPTION_ERROR;

8628: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_cle_mapping_tab('||i||')=' || l_cle_mapping_tab(i).old_id || ':' || l_cle_mapping_tab(i).new_id);
8629: END IF;
8630: END LOOP;
8631:
8632: RAISE OKC_API.G_EXCEPTION_ERROR;
8633:
8634: END; /* sort_cle_mapping_tab */
8635:
8636:

Line 8804: RAISE OKC_API.G_EXCEPTION_ERROR;

8800: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_aid_mapping_tab('||i||')=' || l_aid_mapping_tab(i).old_id || ':' || l_aid_mapping_tab(i).new_id);
8801: END IF;
8802: END LOOP;
8803:
8804: RAISE OKC_API.G_EXCEPTION_ERROR;
8805:
8806: END; /* sort_aid_mapping_tab */
8807:
8808: PROCEDURE do_id_mapping_sort IS

Line 8976: RAISE OKC_API.G_EXCEPTION_ERROR;

8972: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_id_mapping_tab('||i||')=' || l_id_mapping_tab(i).old_id || ':' || l_id_mapping_tab(i).new_id);
8973: END IF;
8974: END LOOP;
8975:
8976: RAISE OKC_API.G_EXCEPTION_ERROR;
8977:
8978: END; /* do_id_mapping_sort */
8979:
8980: FUNCTION find_mapping_id(p_id IN NUMBER) RETURN NUMBER IS

Line 9262: RAISE OKC_API.G_EXCEPTION_ERROR;

9258: END LOOP;
9259: END IF;
9260:
9261:
9262: RAISE OKC_API.G_EXCEPTION_ERROR;
9263:
9264: END; /* insert okc_k_lines_tl */
9265:
9266: PROCEDURE insert_okc_k_lines_tl_old(p_old_id IN okc_k_lines_b.id%TYPE,

Line 9542: RAISE OKC_API.G_EXCEPTION_ERROR;

9538: END IF;
9539: END LOOP;
9540: END IF;
9541:
9542: RAISE OKC_API.G_EXCEPTION_ERROR;
9543:
9544: END; /* insert_okc_k_headers_tl */
9545:
9546: PROCEDURE insert_okl_k_headers(p_old_id IN okc_k_headers_tl.id%TYPE,

Line 9798: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

9794: FOR i IN l_id_tab.first..l_id_tab.last LOOP
9795: l_id_tab(i) := p_new_id;
9796:
9797: validate_amd_code(x_return_status, l_amd_code_tab(i));
9798: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
9799: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
9800: END IF;
9801:
9802: END LOOP;

Line 9966: RAISE OKC_API.G_EXCEPTION_ERROR;

9962: END LOOP;
9963: END IF;
9964:
9965:
9966: RAISE OKC_API.G_EXCEPTION_ERROR;
9967:
9968: END; /* insert_okl_k_headers */
9969:
9970: PROCEDURE insert_okl_slctd_optns(p_old_id IN okc_k_headers_tl.id%TYPE,

Line 10160: RAISE OKC_API.G_EXCEPTION_ERROR;

10156: END IF;
10157: END LOOP;
10158: END IF;
10159:
10160: RAISE OKC_API.G_EXCEPTION_ERROR;
10161:
10162: END; /* insert_okl_slctd_optns */
10163:
10164: FUNCTION find_osid_mapping_id(p_id IN NUMBER) RETURN NUMBER IS

Line 10326: RAISE OKC_API.G_EXCEPTION_ERROR;

10322: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_osid_mapping_tab('||i||')=' || l_osid_mapping_tab(i).id || ':' || l_osid_mapping_tab(i).subsidy_id);
10323: END IF;
10324: END LOOP;
10325:
10326: RAISE OKC_API.G_EXCEPTION_ERROR;
10327:
10328: END; /* sort_osid_mapping_tab */
10329:
10330: FUNCTION find_okl_k_lines_rec(p_id IN NUMBER) RETURN l_okl_k_lines_rec_type IS

Line 10519: RAISE OKC_API.G_EXCEPTION_ERROR;

10515: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_okl_k_lines_rec('||i||')=' || l_okl_k_lines_rec(i).id || ':' || l_okl_k_lines_rec(i).oec || ':' || l_okl_k_lines_rec(i).year_built || ':' || l_okl_k_lines_rec(i).item_description );
10516: END IF;
10517: END LOOP;
10518:
10519: RAISE OKC_API.G_EXCEPTION_ERROR;
10520:
10521: END; /* sort_okl_k_lines_rec */
10522:
10523:

Line 11524: RAISE OKC_API.G_EXCEPTION_ERROR;

11520: END IF;
11521: END LOOP;
11522: END IF;
11523:
11524: RAISE OKC_API.G_EXCEPTION_ERROR;
11525:
11526: END; /* insert_okl_k_lines */
11527:
11528: PROCEDURE do_sort_party_mapping_id IS

Line 11696: RAISE OKC_API.G_EXCEPTION_ERROR;

11692: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_party_id_mapping_tab('||i||')=' || l_party_id_mapping_tab(i).old_id || ':' || l_party_id_mapping_tab(i).new_id);
11693: END IF;
11694: END LOOP;
11695:
11696: RAISE OKC_API.G_EXCEPTION_ERROR;
11697:
11698: END; /* do_sort_party_mapping_id */
11699:
11700: FUNCTION find_party_mapping_id(p_id IN NUMBER) RETURN NUMBER IS

Line 11868: RAISE OKC_API.G_EXCEPTION_ERROR;

11864: END LOOP;
11865:
11866: END IF;
11867:
11868: RAISE OKC_API.G_EXCEPTION_ERROR;
11869:
11870: END; /* prepare_okl_party_roles */
11871:
11872: PROCEDURE prepare_party_roles_tl (p_old_id IN okc_k_party_roles_b.id%TYPE,

Line 11984: RAISE OKC_API.G_EXCEPTION_ERROR;

11980: END IF;
11981: END LOOP;
11982: END IF;
11983:
11984: RAISE OKC_API.G_EXCEPTION_ERROR;
11985:
11986: END; /* prepare_party_roles_tl */
11987:
11988: PROCEDURE prepare_contacts (p_old_id IN okc_k_party_roles_b.id%TYPE,

Line 12207: RAISE OKC_API.G_EXCEPTION_ERROR;

12203: END IF;
12204: END LOOP;
12205: END IF;
12206:
12207: RAISE OKC_API.G_EXCEPTION_ERROR;
12208:
12209: END; /* prepare_contacts */
12210:
12211: FUNCTION find_phid_mapping_id(p_id IN NUMBER) RETURN NUMBER IS

Line 12368: RAISE OKC_API.G_EXCEPTION_ERROR;

12364: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_phid_mapping_tab('||i||')=' || l_phid_mapping_tab(i).old_id || ':' || l_phid_mapping_tab(i).new_id);
12365: END IF;
12366: END LOOP;
12367:
12368: RAISE OKC_API.G_EXCEPTION_ERROR;
12369:
12370: END; /* sort_phid_mapping_tab */
12371:
12372:

Line 12524: RAISE OKC_API.G_EXCEPTION_ERROR;

12520: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'PASSTHRU_STREAM_TYPE_ID('||i||')=' || l_phPASSTHRU_STRE_TYPE_ID_tab(i));
12521: END IF;
12522: end loop;
12523: END IF;
12524: RAISE OKC_API.G_EXCEPTION_ERROR;
12525:
12526: END;
12527:
12528: PROCEDURE prepare_party_payment_dtls (p_old_id IN okc_k_party_roles_b.id%TYPE,

Line 12784: RAISE OKC_API.G_EXCEPTION_ERROR;

12780: END IF;
12781: END LOOP;
12782: END IF;
12783:
12784: RAISE OKC_API.G_EXCEPTION_ERROR;
12785:
12786: END; /* prepare_party_payment_dtls */
12787:
12788: FUNCTION find_vid_mapping_id(p_id IN NUMBER) RETURN VARCHAR2 IS

Line 12950: RAISE OKC_API.G_EXCEPTION_ERROR;

12946: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_vid_mapping_tab('||i||')=' || l_vid_mapping_tab(i).cle_id || ':' || l_vid_mapping_tab(i).object1_id1);
12947: END IF;
12948: END LOOP;
12949:
12950: RAISE OKC_API.G_EXCEPTION_ERROR;
12951:
12952: END; /* sort_vid_mapping_tab */
12953:
12954: PROCEDURE insert_okc_k_party_roles(p_old_id IN okc_k_headers_b.id%TYPE,

Line 13393: RAISE OKC_API.G_EXCEPTION_ERROR;

13389: END IF;
13390: END LOOP;
13391: END IF;
13392:
13393: RAISE OKC_API.G_EXCEPTION_ERROR;
13394:
13395: END; /* insert_okc_k_party_roles */
13396:
13397: FUNCTION find_rid_mapping_id(p_id IN NUMBER) RETURN NUMBER IS

Line 13559: RAISE OKC_API.G_EXCEPTION_ERROR;

13555: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_rid_mapping_tab('||i||')=' || l_rid_mapping_tab(i).old_id || ':' || l_rid_mapping_tab(i).new_id);
13556: END IF;
13557: END LOOP;
13558:
13559: RAISE OKC_API.G_EXCEPTION_ERROR;
13560:
13561: END; /* sort_rid_mapping_tab */
13562:
13563:

Line 13726: RAISE OKC_API.G_EXCEPTION_ERROR;

13722: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_rrid_mapping_tab('||i||')=' || l_rrid_mapping_tab(i).old_id || ':' || l_rrid_mapping_tab(i).new_id);
13723: END IF;
13724: END LOOP;
13725:
13726: RAISE OKC_API.G_EXCEPTION_ERROR;
13727:
13728: END; /* sort_rrid_mapping_tab */
13729:
13730:

Line 13834: RAISE OKC_API.G_EXCEPTION_ERROR;

13830: END IF;
13831: END LOOP;
13832: END IF;
13833:
13834: RAISE OKC_API.G_EXCEPTION_ERROR;
13835:
13836: END; /* prepare_rule_groups_tl */
13837:
13838: PROCEDURE insert_okc_rules_tl(p_old_id IN okc_rules_b.id%TYPE,

Line 13945: RAISE OKC_API.G_EXCEPTION_ERROR;

13941: END IF;
13942: END LOOP;
13943: END IF;
13944:
13945: RAISE OKC_API.G_EXCEPTION_ERROR;
13946:
13947: END; /* insert_okc_rules_tl */
13948:
13949: PROCEDURE insert_okc_rules_b( p_old_id IN okc_rule_groups_b.id%TYPE,

Line 14069: IF (l_return_status2 <> OKC_API.G_RET_STS_SUCCESS) THEN

14065: p_primary_sty_purpose => 'RENT',
14066: p_dependent_sty_purpose => 'UNSCHEDULED_PRINCIPAL_PAYMENT',
14067: x_return_status => l_return_status2,
14068: x_dependent_sty_id => l_unsched_prin_stream_id);
14069: IF (l_return_status2 <> OKC_API.G_RET_STS_SUCCESS) THEN
14070: l_unsched_prin_stream_id := NULL;
14071: END IF;
14072:
14073: okl_streams_util.get_dependent_stream_type (

Line 14079: IF (l_return_status2 <> OKC_API.G_RET_STS_SUCCESS) THEN

14075: p_primary_sty_purpose => 'RENT',
14076: p_dependent_sty_purpose => 'UNSCHEDULED_LOAN_PAYMENT',
14077: x_return_status => l_return_status2,
14078: x_dependent_sty_id => l_unsched_loan_stream_id);
14079: IF (l_return_status2 <> OKC_API.G_RET_STS_SUCCESS) THEN
14080: l_unsched_loan_stream_id := NULL;
14081: END IF;
14082:
14083: --print('AKP:l_unsched_prin_stream_id=' || l_unsched_prin_stream_id);

Line 14422: RAISE OKC_API.G_EXCEPTION_ERROR;

14418: END IF;
14419: END LOOP;
14420: END IF;
14421:
14422: RAISE OKC_API.G_EXCEPTION_ERROR;
14423:
14424: END; /* insert_okc_rules_b */
14425:
14426: FUNCTION find_tid_mapping_id(p_id IN VARCHAR2) RETURN NUMBER IS

Line 14588: RAISE OKC_API.G_EXCEPTION_ERROR;

14584: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tid_mapping_tab('||i||')=' || l_tid_mapping_tab(i).rgd_code || ':' || l_tid_mapping_tab(i).id);
14585: END IF;
14586: END LOOP;
14587:
14588: RAISE OKC_API.G_EXCEPTION_ERROR;
14589:
14590: END; /* sort_tid_mapping_tab */
14591:
14592: PROCEDURE insert_okc_rule_groups (p_old_id IN okc_k_headers_b.id%TYPE,

Line 14842: RAISE OKC_API.G_EXCEPTION_ERROR;

14838: END IF;
14839: END LOOP;
14840: END IF;
14841:
14842: RAISE OKC_API.G_EXCEPTION_ERROR;
14843:
14844: END; /* insert_okc_rule_groups */
14845:
14846: FUNCTION find_oid_mapping_id(p_id IN NUMBER) RETURN VARCHAR2 IS

Line 15010: RAISE OKC_API.G_EXCEPTION_ERROR;

15006: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_oid_mapping_tab('||i||')=' || l_oid_mapping_tab(i).cle_id || ':' || l_oid_mapping_tab(i).object1_id1);
15007: END IF;
15008: END LOOP;
15009:
15010: RAISE OKC_API.G_EXCEPTION_ERROR;
15011:
15012: END; /* sort_oid_mapping_tab */
15013:
15014: FUNCTION find_okc_k_items_rec(p_id IN NUMBER) RETURN l_okc_k_items_rec_type IS

Line 15032: l_dummy_rec.number_of_items := OKC_API.G_MISS_NUM;

15028: ELSE
15029: lo := m + 1;
15030: END IF;
15031: END LOOP;
15032: l_dummy_rec.number_of_items := OKC_API.G_MISS_NUM;
15033: RETURN l_dummy_rec;
15034: END; /* find_okc_k_items_rec */
15035:
15036: PROCEDURE sort_okc_k_items_rec IS

Line 15212: RAISE OKC_API.G_EXCEPTION_ERROR;

15208: || l_okc_k_items_rec(i).object1_id1 || ':' || l_okc_k_items_rec(i).object1_id2 );
15209: END IF;
15210: END LOOP;
15211:
15212: RAISE OKC_API.G_EXCEPTION_ERROR;
15213:
15214: END; /* sort_okc_k_items_rec */
15215:
15216:

Line 15443: RAISE OKC_API.G_EXCEPTION_ERROR;

15439: END IF;
15440: END LOOP;
15441: END IF;
15442:
15443: RAISE OKC_API.G_EXCEPTION_ERROR;
15444:
15445: END; /* insert okc_k_items */
15446:
15447: PROCEDURE sort_trx_id_mapping_tab IS

Line 15589: RAISE OKC_API.G_EXCEPTION_ERROR;

15585: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_trx_id_mapping_tab('||i||')=' || l_trx_id_mapping_tab(i).old_id || ':' || l_trx_id_mapping_tab(i).new_id);
15586: END IF;
15587: END LOOP;
15588:
15589: RAISE OKC_API.G_EXCEPTION_ERROR;
15590:
15591: END; /* sort_trx_id_mapping_tab */
15592:
15593: FUNCTION find_trx_mapping_id(p_id IN NUMBER) RETURN NUMBER IS

Line 15756: RAISE OKC_API.G_EXCEPTION_ERROR;

15752: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_trx_id_mapping_tab2('||i||')=' || l_trx_id_mapping_tab2(i).old_id || ':' || l_trx_id_mapping_tab2(i).new_id);
15753: END IF;
15754: END LOOP;
15755:
15756: RAISE OKC_API.G_EXCEPTION_ERROR;
15757:
15758: END; /* sort_trx_id_mapping_tab2 */
15759:
15760: FUNCTION find_trx_mapping_id2(p_id IN NUMBER) RETURN NUMBER IS

Line 15922: RAISE OKC_API.G_EXCEPTION_ERROR;

15918: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_txl_id_mapping_tab('||i||')=' || l_txl_id_mapping_tab(i).old_id || ':' || l_txl_id_mapping_tab(i).new_id);
15919: END IF;
15920: END LOOP;
15921:
15922: RAISE OKC_API.G_EXCEPTION_ERROR;
15923:
15924: END; /* sort_txl_id_mapping_tab */
15925:
15926: FUNCTION find_txl_mapping_id(p_id IN NUMBER) RETURN NUMBER IS

Line 16050: RAISE OKC_API.G_EXCEPTION_ERROR;

16046: END IF;
16047: END LOOP;
16048: END IF;
16049:
16050: RAISE OKC_API.G_EXCEPTION_ERROR;
16051:
16052: END; /* insert_okl_txl_assets_tl */
16053:
16054: PROCEDURE insert_okl_txd_assets_tl(p_old_id IN okc_k_headers_b.id%TYPE,

Line 16162: RAISE OKC_API.G_EXCEPTION_ERROR;

16158: END IF;
16159: END LOOP;
16160: END IF;
16161:
16162: RAISE OKC_API.G_EXCEPTION_ERROR;
16163:
16164: END; /* insert_okl_txd_assets_tl */
16165:
16166: PROCEDURE insert_okl_txd_assets_b(p_old_id IN okc_k_headers_b.id%TYPE,

Line 16433: RAISE OKC_API.G_EXCEPTION_ERROR;

16429: END IF;
16430: END LOOP;
16431: END IF;
16432:
16433: RAISE OKC_API.G_EXCEPTION_ERROR;
16434:
16435: END; /* insert_okl_txd_assets_b */
16436:
16437: FUNCTION find_dbid_mapping_id(p_id IN NUMBER) RETURN NUMBER IS

Line 16599: RAISE OKC_API.G_EXCEPTION_ERROR;

16595: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_dbid_mapping_tab('||i||')=' || l_dbid_mapping_tab(i).tal_id || ':' || l_dbid_mapping_tab(i).kle_id);
16596: END IF;
16597: END LOOP;
16598:
16599: RAISE OKC_API.G_EXCEPTION_ERROR;
16600:
16601: END; /* sort_dbid_mapping_tab */
16602:
16603: PROCEDURE insert_okl_txl_assets_b(p_old_id IN okc_k_headers_b.id%TYPE,

Line 17069: RAISE OKC_API.G_EXCEPTION_ERROR;

17065: END IF;
17066: END LOOP;
17067: END IF;
17068:
17069: RAISE OKC_API.G_EXCEPTION_ERROR;
17070:
17071: END; /* insert_okl_txl_assets_b */
17072:
17073: PROCEDURE insert_okl_trx_assets(p_old_id IN okc_k_headers_b.id%TYPE,

Line 17291: RAISE OKC_API.G_EXCEPTION_ERROR;

17287: END IF;
17288: END LOOP;
17289: END IF;
17290:
17291: RAISE OKC_API.G_EXCEPTION_ERROR;
17292:
17293: END; /* insert_okl_trx_assets */
17294:
17295: PROCEDURE insert_okl_trx_assets_2(p_old_id IN okc_k_headers_b.id%TYPE,

Line 17510: RAISE OKC_API.G_EXCEPTION_ERROR;

17506: END IF;
17507: END LOOP;
17508: END IF;
17509:
17510: RAISE OKC_API.G_EXCEPTION_ERROR;
17511:
17512: END; /* insert_okl_trx_assets_2 */
17513:
17514: -- AKP: Delete this function from here. And use

Line 17532: x_return_status := OKC_API.G_RET_STS_ERROR;

17528: BEGIN
17529: OPEN c_instance_no_ib;
17530: FETCH c_instance_no_ib INTO x_instance_number_ib;
17531: IF (c_instance_no_ib%NOTFOUND) THEN
17532: x_return_status := OKC_API.G_RET_STS_ERROR;
17533: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
17534: p_msg_name => g_unexpected_error,
17535: p_token1 => g_sqlcode_token,
17536: p_token1_value => SQLCODE,

Line 17547: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

17543: WHEN OTHERS THEN
17544: IF c_instance_no_ib%ISOPEN THEN
17545: CLOSE c_instance_no_ib;
17546: END IF;
17547: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
17548: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
17549: p_msg_name => g_unexpected_error,
17550: p_token1 => g_sqlcode_token,
17551: p_token1_value => SQLCODE,

Line 17862: RAISE OKC_API.G_EXCEPTION_ERROR;

17858: END IF;
17859: END LOOP;
17860: END IF;
17861:
17862: RAISE OKC_API.G_EXCEPTION_ERROR;
17863:
17864: END; /* insert_okl_txl_itm_insts */
17865:
17866: PROCEDURE get_orig_depreciation_cost( p_fa_cost IN NUMBER,

Line 17905: OKC_API.set_message(p_app_name => 'OKL_COPY_CONTRACT_PVT',

17901: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_fa_cost='|| p_fa_cost || ' l_converted_cost='||l_converted_cost);
17902: END IF;
17903: IF (p_fa_cost >= 0) AND (l_converted_cost < 0) THEN
17904: --currency conversion rate was not found in Oracle GL
17905: OKC_API.set_message(p_app_name => 'OKL_COPY_CONTRACT_PVT',
17906: p_msg_name => 'OKL_LLA_CONV_RATE_NOT_FOUND',
17907: p_token1 => 'FROM_CURRENCY',
17908: p_token1_value => x_contract_currency,
17909: p_token2 => 'TO_CURRENCY',

Line 18015: OKC_API.set_message(p_app_name => 'OKL_COPY_CONTRACT_PVT',

18011: x_currency_conversion_date => x_currency_conversion_date,
18012: x_converted_amount => l_salvage_value);
18013: IF (p_salvage_value >= 0) AND (l_salvage_value < 0) THEN
18014: --currency conversion rate was not found in Oracle GL
18015: OKC_API.set_message(p_app_name => 'OKL_COPY_CONTRACT_PVT',
18016: p_msg_name => 'OKL_LLA_CONV_RATE_NOT_FOUND',
18017: p_token1 => 'FROM_CURRENCY',
18018: p_token1_value => x_contract_currency,
18019: p_token2 => 'TO_CURRENCY',

Line 18533: IF (l_tmp_okl_42_rec.year_built = OKC_API.G_MISS_NUM ) THEN

18529:
18530: l_tb2current_units_tab(l_trx_assets_counter4) := l_CURRENT_UNITS_tab(i);
18531: l_tb2manufacturer_name_tab(l_trx_assets_counter4) := l_MANUFACTURER_NAME_tab(i);
18532: l_tmp_okl_42_rec := find_okl_k_lines_rec(l_id_local_tab(i));
18533: IF (l_tmp_okl_42_rec.year_built = OKC_API.G_MISS_NUM ) THEN
18534: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
18535: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'ERROR: Mapping okl_k_lines_rec not found for ' || l_id_local_tab(i));
18536: END IF;
18537: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 19113: RAISE OKC_API.G_EXCEPTION_ERROR;

19109: END IF;
19110: END LOOP;
19111: END IF;
19112:
19113: RAISE OKC_API.G_EXCEPTION_ERROR;
19114: END; /* insert okl_trx_assets_3 */
19115:
19116: PROCEDURE insert_okc_rg_party_roles(p_old_id IN okc_k_headers_b.id%TYPE,
19117: p_new_id IN okc_k_headers_b.id%TYPE) IS

Line 19252: RAISE OKC_API.G_EXCEPTION_ERROR;

19248: END IF;
19249: END LOOP;
19250: END IF;
19251:
19252: RAISE OKC_API.G_EXCEPTION_ERROR;
19253:
19254: END; /* insert_okc_rg_party_roles */
19255:
19256: PROCEDURE insert_okl_supp_invoice_dtls(p_old_id IN okc_k_headers_b.id%TYPE)

Line 19538: RAISE OKC_API.G_EXCEPTION_ERROR;

19534: END IF;
19535: END LOOP;
19536: END IF;
19537:
19538: RAISE OKC_API.G_EXCEPTION_ERROR;
19539:
19540: END;
19541:
19542: PROCEDURE get_object1_id1(p_install_location_type_code IN okx_install_items_v.location_type_code%TYPE,

Line 19971: RAISE OKC_API.G_EXCEPTION_ERROR;

19967: END IF;
19968: END LOOP;
19969: END IF;
19970:
19971: RAISE OKC_API.G_EXCEPTION_ERROR;
19972:
19973: END; /* insert_okl_txl_itm_insts2 */
19974:
19975: FUNCTION find_sid_mapping_id(p_id IN NUMBER) RETURN NUMBER IS

Line 20137: RAISE OKC_API.G_EXCEPTION_ERROR;

20133: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_sid_mapping_tab('||i||')=' || l_sid_mapping_tab(i).id || ':' || l_sid_mapping_tab(i).lse_id);
20134: END IF;
20135: END LOOP;
20136:
20137: RAISE OKC_API.G_EXCEPTION_ERROR;
20138:
20139: END; /* sort_sid_mapping_tab */
20140:
20141: PROCEDURE raise_business_event_header(

Line 20150: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

20146: l_check VARCHAR2(1);
20147: l_parameter_list wf_parameter_list_t;
20148: BEGIN
20149:
20150: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
20151: -- Our contract is always new. So commented following check
20152: --IF (p_source_code = 'new') THEN
20153: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID,p_chr_id,l_parameter_list);
20154: OKL_WF_PVT.raise_event (p_api_version => p_api_version,

Line 20248: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

20244: END raise_business_event_subsidy;
20245:
20246: PROCEDURE raise_business_event_itm(
20247: p_api_version IN NUMBER
20248: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
20249: ,x_return_status OUT NOCOPY VARCHAR2
20250: ,x_msg_count OUT NOCOPY NUMBER
20251: ,x_msg_data OUT NOCOPY VARCHAR2
20252: ,p_event_name IN WF_EVENTS.NAME%TYPE

Line 20612: RAISE OKC_API.G_EXCEPTION_ERROR;

20608: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_ssid_mapping_tab('||i||')=' || l_ssid_mapping_tab(i).cle_id || ':' || l_ssid_mapping_tab(i).object1_id1);
20609: END IF;
20610: END LOOP;
20611:
20612: RAISE OKC_API.G_EXCEPTION_ERROR;
20613:
20614: END; /* sort_ssid_mapping_tab */
20615:
20616: BEGIN

Line 20693: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

20689: p_scs_code => c1rec.scs_code,
20690: p_modifier => p_contract_number_modifier,
20691: x_return_status => x_return_status,
20692: x_contract_number => l_contract_number);
20693: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
20694: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
20695: p_msg_name => g_unexpected_error,
20696: p_token1 => g_sqlcode_token,
20697: p_token1_value => SQLCODE,

Line 20694: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

20690: p_modifier => p_contract_number_modifier,
20691: x_return_status => x_return_status,
20692: x_contract_number => l_contract_number);
20693: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
20694: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
20695: p_msg_name => g_unexpected_error,
20696: p_token1 => g_sqlcode_token,
20697: p_token1_value => SQLCODE,
20698: p_token2 => g_sqlerrm_token,

Line 20730: --RAISE OKC_API.G_EXCEPTION_ERROR;

20726: x_msg_count,
20727: x_msg_data,
20728: '_PVT');
20729: RETURN;
20730: --RAISE OKC_API.G_EXCEPTION_ERROR;
20731: END IF;
20732:
20733: l_curr_pos := 'okl_copy_lease_contract:7';
20734: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 20740: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

20736: END IF;
20737:
20738: -- AKP: need to do all validatations here
20739: validate_currency_code(x_return_status, l_contract_currency );
20740: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
20741: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
20742: END IF;
20743:
20744: l_curr_pos := 'okl_copy_lease_contract:8';

Line 20746: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

20742: END IF;
20743:
20744: l_curr_pos := 'okl_copy_lease_contract:8';
20745: validate_orig_sys_code(x_return_status, l_orig_system_source_code);
20746: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
20747: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
20748: END IF;
20749:
20750: l_curr_pos := 'okl_copy_lease_contract:9';

Line 20752: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

20748: END IF;
20749:
20750: l_curr_pos := 'okl_copy_lease_contract:9';
20751: validate_currency_conv_type(x_return_status, l_conversion_type);
20752: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
20753: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
20754: END IF;
20755:
20756: BEGIN

Line 20842: RAISE OKC_API.G_EXCEPTION_ERROR;

20838: OKL_API.set_message(p_app_name => 'OKL',
20839: p_msg_name => l_message,
20840: p_token1 => 'CONTRACT_NUMBER',
20841: p_token1_value => l_contract_number);
20842: RAISE OKC_API.G_EXCEPTION_ERROR;
20843: END;
20844: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
20845: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_copied_id=' || l_copied_id);
20846: END IF;

Line 20867: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

20863: x_msg_count => x_msg_count,
20864: x_msg_data => x_msg_data,
20865: p_hstv_rec => l_hstv_rec,
20866: x_hstv_rec => x_hstv_rec);
20867: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
20868: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
20869: END IF;
20870: EXCEPTION WHEN OTHERS THEN
20871: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 20875: RAISE OKC_API.G_EXCEPTION_ERROR;

20871: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
20872: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'sqlcode=' || SQLCODE || ':sqlerrm=' || SQLERRM);
20873: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'ERROR during insert into create_k_history...');
20874: END IF;
20875: RAISE OKC_API.G_EXCEPTION_ERROR;
20876: END;
20877:
20878: BEGIN
20879: l_curr_pos := 'okl_copy_lease_contract:13';

Line 20901: RAISE OKC_API.G_EXCEPTION_ERROR;

20897: OKL_API.set_message(p_app_name => 'OKL',
20898: p_msg_name => l_message,
20899: p_token1 => 'CONTRACT_NUMBER',
20900: p_token1_value => l_contract_number);
20901: RAISE OKC_API.G_EXCEPTION_ERROR;
20902: END;
20903:
20904: l_curr_pos := 'okl_copy_lease_contract:14';
20905: l_message := 'OKL_NEW_COPY_CHR_ERROR';

Line 20945: RAISE OKC_API.G_EXCEPTION_ERROR;

20941: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
20942: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'sqlcode=' || SQLCODE || ':sqlerrm=' || SQLERRM);
20943: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'ERROR during inser into okc_governances...');
20944: END IF;
20945: RAISE OKC_API.G_EXCEPTION_ERROR;
20946: END;
20947:
20948: l_curr_pos := 'okl_copy_lease_contract:19';
20949: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 21403: RAISE OKC_API.G_EXCEPTION_ERROR;

21399: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
21400: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'sqlcode=' || SQLCODE || ':sqlerrm=' || SQLERRM);
21401: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'ERROR during insert into okc_k_lines_b...');
21402: END IF;
21403: RAISE OKC_API.G_EXCEPTION_ERROR;
21404: END;
21405: END IF;
21406:
21407: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 21572: if (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

21568: p_formula_name => 'LINE_CAP_AMNT',
21569: p_contract_id => l_copied_id,
21570: p_line_id => l_id2_tab(i),
21571: x_value => l_capital_amount);
21572: if (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
21573: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
21574: elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
21575: raise OKC_API.G_EXCEPTION_ERROR;
21576: end if;

Line 21573: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

21569: p_contract_id => l_copied_id,
21570: p_line_id => l_id2_tab(i),
21571: x_value => l_capital_amount);
21572: if (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
21573: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
21574: elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
21575: raise OKC_API.G_EXCEPTION_ERROR;
21576: end if;
21577: end if;

Line 21574: elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then

21570: p_line_id => l_id2_tab(i),
21571: x_value => l_capital_amount);
21572: if (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
21573: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
21574: elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
21575: raise OKC_API.G_EXCEPTION_ERROR;
21576: end if;
21577: end if;
21578: end loop;

Line 21575: raise OKC_API.G_EXCEPTION_ERROR;

21571: x_value => l_capital_amount);
21572: if (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
21573: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
21574: elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
21575: raise OKC_API.G_EXCEPTION_ERROR;
21576: end if;
21577: end if;
21578: end loop;
21579: end if;

Line 22442: p_restricted_update => OKC_API.G_FALSE,

22438: p_init_msg_list => p_init_msg_list,
22439: x_return_status => x_return_status,
22440: x_msg_count => x_msg_count,
22441: x_msg_data => x_msg_data,
22442: p_restricted_update => OKC_API.G_FALSE,
22443: p_chrv_rec => l_chrv_rec,
22444: x_chrv_rec => lx_chrv_rec);
22445:
22446: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN