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 1113: x_return_status := OKC_API.G_RET_STS_SUCCESS;

1109: ) RETURN pphv_rec_type IS
1110: l_pphv_rec pphv_rec_type;
1111: l_row_notfound BOOLEAN := TRUE;
1112: BEGIN
1113: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1114: l_pphv_rec := get_pphv_rec(p_pphv_rec, l_row_notfound);
1115: IF (l_row_notfound) THEN
1116: OKC_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');
1117: x_return_status := OKC_API.G_RET_STS_ERROR;

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

1112: BEGIN
1113: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1114: l_pphv_rec := get_pphv_rec(p_pphv_rec, l_row_notfound);
1115: IF (l_row_notfound) THEN
1116: OKC_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');
1117: x_return_status := OKC_API.G_RET_STS_ERROR;
1118: END IF;
1119: RETURN(l_pphv_rec);
1120: END get_pphv_rec;

Line 1117: x_return_status := OKC_API.G_RET_STS_ERROR;

1113: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1114: l_pphv_rec := get_pphv_rec(p_pphv_rec, l_row_notfound);
1115: IF (l_row_notfound) THEN
1116: OKC_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');
1117: x_return_status := OKC_API.G_RET_STS_ERROR;
1118: END IF;
1119: RETURN(l_pphv_rec);
1120: END get_pphv_rec;
1121:

Line 1306: x_return_status := OKC_API.G_RET_STS_SUCCESS;

1302: ) RETURN kplv_rec_type IS
1303: l_kplv_rec kplv_rec_type;
1304: l_row_notfound BOOLEAN := TRUE;
1305: BEGIN
1306: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1307: l_kplv_rec := get_kplv_rec(p_kplv_rec, l_row_notfound);
1308: IF (l_row_notfound) THEN
1309: OKC_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');
1310: x_return_status := OKC_API.G_RET_STS_ERROR;

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

1305: BEGIN
1306: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1307: l_kplv_rec := get_kplv_rec(p_kplv_rec, l_row_notfound);
1308: IF (l_row_notfound) THEN
1309: OKC_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');
1310: x_return_status := OKC_API.G_RET_STS_ERROR;
1311: END IF;
1312: RETURN(l_kplv_rec);
1313: END get_kplv_rec;

Line 1310: x_return_status := OKC_API.G_RET_STS_ERROR;

1306: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1307: l_kplv_rec := get_kplv_rec(p_kplv_rec, l_row_notfound);
1308: IF (l_row_notfound) THEN
1309: OKC_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');
1310: x_return_status := OKC_API.G_RET_STS_ERROR;
1311: END IF;
1312: RETURN(l_kplv_rec);
1313: END get_kplv_rec;
1314: --Bug# 4558486

Line 2210: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

2206: BEGIN
2207: IF (G_DEBUG_ENABLED = 'Y') THEN
2208: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
2209: END IF;
2210: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
2211: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2212: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
2213: END IF;
2214:

Line 2230: p_init_msg_list => Okc_Api.G_FALSE,

2226: END LOOP;
2227:
2228: Okl_Rule_Pub.delete_rule(
2229: p_api_version => 1.0,
2230: p_init_msg_list => Okc_Api.G_FALSE,
2231: x_return_status => x_return_status,
2232: x_msg_count => x_msg_count,
2233: x_msg_data => x_msg_data,
2234: p_rulv_tbl => l_rulv_tbl

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

2232: x_msg_count => x_msg_count,
2233: x_msg_data => x_msg_data,
2234: p_rulv_tbl => l_rulv_tbl
2235: );
2236: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
2237: RAISE sync_failed;
2238: END IF;
2239:
2240: l_old_rgpv_rec.id := p_old_rgp_id;

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

2253: x_msg_data => x_msg_data,
2254: x_rulv_tbl => x_slh_rulv_tbl,
2255: x_rule_count => x_slh_rule_count
2256: );
2257: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
2258: RAISE sync_failed;
2259: END IF;
2260:
2261: --x_slh_rulv_tbl_out := x_slh_rulv_tbl;

Line 2272: p_init_msg_list => Okc_Api.G_FALSE,

2268: l_slh_rulv_rec.dnz_chr_id := p_new_chr_id;
2269:
2270: Okl_Rule_Pub.create_rule(
2271: p_api_version => 1.0,
2272: p_init_msg_list => Okc_Api.G_FALSE,
2273: x_return_status => x_return_status,
2274: x_msg_count => x_msg_count,
2275: x_msg_data => x_msg_data,
2276: p_rulv_rec => l_slh_rulv_rec,

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

2275: x_msg_data => x_msg_data,
2276: p_rulv_rec => l_slh_rulv_rec,
2277: x_rulv_rec => x_new_slh_rulv_rec
2278: );
2279: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
2280: x_return_status := Okc_Api.G_RET_STS_ERROR;
2281: RAISE sync_failed;
2282: END IF;
2283:

Line 2280: x_return_status := Okc_Api.G_RET_STS_ERROR;

2276: p_rulv_rec => l_slh_rulv_rec,
2277: x_rulv_rec => x_new_slh_rulv_rec
2278: );
2279: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
2280: x_return_status := Okc_Api.G_RET_STS_ERROR;
2281: RAISE sync_failed;
2282: END IF;
2283:
2284: --

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

2295: p_slh_id => x_slh_rulv_tbl(i).id,
2296: x_rulv_tbl => x_sll_rulv_tbl,
2297: x_rule_count => x_sll_rule_count
2298: );
2299: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
2300: RAISE sync_failed;
2301: END IF;
2302:
2303: --x_sll_rulv_tbl_out := x_sll_rulv_tbl;

Line 2317: p_init_msg_list => Okc_Api.G_FALSE,

2313: l_sll_rulv_rec.dnz_chr_id := p_new_chr_id;
2314:
2315: Okl_Rule_Pub.create_rule(
2316: p_api_version => 1.0,
2317: p_init_msg_list => Okc_Api.G_FALSE,
2318: x_return_status => x_return_status,
2319: x_msg_count => x_msg_count,
2320: x_msg_data => x_msg_data,
2321: p_rulv_rec => l_sll_rulv_rec,

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

2320: x_msg_data => x_msg_data,
2321: p_rulv_rec => l_sll_rulv_rec,
2322: x_rulv_rec => x_rulv_rec
2323: );
2324: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
2325: x_return_status := Okc_Api.G_RET_STS_ERROR;
2326: RAISE sync_failed;
2327: END IF;
2328: END LOOP; -- SLL

Line 2325: x_return_status := Okc_Api.G_RET_STS_ERROR;

2321: p_rulv_rec => l_sll_rulv_rec,
2322: x_rulv_rec => x_rulv_rec
2323: );
2324: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
2325: x_return_status := Okc_Api.G_RET_STS_ERROR;
2326: RAISE sync_failed;
2327: END IF;
2328: END LOOP; -- SLL
2329:

Line 2334: x_return_status := Okc_Api.G_RET_STS_ERROR;

2330: END LOOP; -- SLH
2331:
2332: EXCEPTION
2333: WHEN sync_failed THEN
2334: x_return_status := Okc_Api.G_RET_STS_ERROR;
2335: END sync_slh_sll;
2336: -- Start Bug 2376998
2337: ------------------------------------------------------------------------------
2338: -- PROCEDURE link_slh_sll

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

2411: p_new_chr_id => p_new_chr_id,
2412: p_old_rgp_id => l_old_lalevl_id,
2413: p_new_rgp_id => l_new_lalevl_id
2414: );
2415: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
2416: RAISE Okl_Api.G_EXCEPTION_ERROR;
2417: END IF;
2418: END LOOP;
2419:

Line 2422: x_return_status := OKC_API.G_RET_STS_ERROR;

2418: END LOOP;
2419:
2420: EXCEPTION
2421: WHEN link_failed THEN
2422: x_return_status := OKC_API.G_RET_STS_ERROR;
2423: END link_slh_sll;
2424:
2425: -- End Bug 2376998
2426: ------------------------------------------------------------------------------

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

2497: p_new_chr_id => p_new_chr_id,
2498: p_old_rgp_id => l_old_lalevl_id,
2499: p_new_rgp_id => l_new_lalevl_id
2500: );
2501: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
2502: raise OKL_API.G_EXCEPTION_ERROR;
2503: END IF;
2504: END LOOP;
2505:

Line 2508: x_return_status := OKC_API.G_RET_STS_ERROR;

2504: END LOOP;
2505:
2506: EXCEPTION
2507: WHEN link_failed THEN
2508: x_return_status := OKC_API.G_RET_STS_ERROR;
2509: END link_slh_sll;
2510: --------------------------------------------------------------------------------
2511: -- Start of comments
2512: --Bug# 2522268

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

3138: p_new_chr_id => x_chr_id
3139: );
3140:
3141:
3142: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
3143: RAISE OKL_API.G_EXCEPTION_ERROR;
3144: END IF;
3145: --Call OKC_COPY_CONTRACT_PUB.Copy_Components
3146: -- do not do this again as this might already be done as part of OKC_COPY_CONTRACT

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

3509: --p_new_cle_id => x_cle_id, -- Bug 2376998
3510: p_new_cle_id => c_lines_rec.id, -- Bug 2376998
3511: p_new_chr_id => l_new_chr_id --Bug# 4899328
3512: );
3513: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
3514: RAISE OKL_API.G_EXCEPTION_ERROR;
3515: END IF;
3516: --------------------------------------------------------------------------------------
3517: --BUG# 3143522 : 11.5.10 Subsidies - copy party payment details

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

3645: --p_new_chr_id => p_to_chr_id
3646: --);
3647:
3648:
3649: --IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
3650: --RAISE OKL_API.G_EXCEPTION_ERROR;
3651: --END IF;
3652:
3653: ---------Commented as this code has been moved up to run for all sub-lines too-----*/

Line 4166: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

4162: -- governances are copied only if renew reference flag is set to 'Yes'
4163: --------------------------------------------------------------------------
4164: PROCEDURE copy_governances(
4165: p_api_version IN NUMBER,
4166: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
4167: x_return_status OUT NOCOPY VARCHAR2,
4168: x_msg_count OUT NOCOPY NUMBER,
4169: x_msg_data OUT NOCOPY VARCHAR2,
4170: p_from_chr_id IN NUMBER,

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

4171: p_to_chr_id IN NUMBER) IS
4172:
4173: l_gvev_rec OKC_CONTRACT_PUB.gvev_rec_type;
4174: x_gvev_rec OKC_CONTRACT_PUB.gvev_rec_type;
4175: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4176:
4177: CURSOR c_governances IS
4178: SELECT id
4179: FROM okc_governances_v

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

4185: ----------------------------------------------------------------------------
4186: FUNCTION get_gvev_rec(p_gve_id IN NUMBER,
4187: x_gvev_rec OUT NOCOPY OKC_CONTRACT_PUB.gvev_rec_type)
4188: RETURN VARCHAR2 IS
4189: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4190: l_no_data_found BOOLEAN := TRUE;
4191:
4192: CURSOR c_gvev_rec IS
4193: SELECT

Line 4217: l_return_status := OKC_API.G_RET_STS_ERROR;

4213:
4214: l_no_data_found := c_gvev_rec%NOTFOUND;
4215: CLOSE c_gvev_rec;
4216: IF l_no_data_found THEN
4217: l_return_status := OKC_API.G_RET_STS_ERROR;
4218: return(l_return_status);
4219: ELSE
4220: return(l_return_status);
4221: END IF;

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

4221: END IF;
4222: EXCEPTION
4223: WHEN OTHERS THEN
4224: -- store SQL error message on message stack for caller
4225: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
4226: -- notify caller of an UNEXPECTED error
4227: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
4228: return(l_return_status);
4229:

Line 4227: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

4223: WHEN OTHERS THEN
4224: -- store SQL error message on message stack for caller
4225: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
4226: -- notify caller of an UNEXPECTED error
4227: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
4228: return(l_return_status);
4229:
4230: END get_gvev_rec;
4231: BEGIN

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

4244: x_msg_data => x_msg_data,
4245: p_gvev_rec => l_gvev_rec,
4246: x_gvev_rec => x_gvev_rec);
4247:
4248: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
4249: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4250: x_return_status := l_return_status;
4251: RAISE G_EXCEPTION_HALT_VALIDATION;
4252: ELSE

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

4245: p_gvev_rec => l_gvev_rec,
4246: x_gvev_rec => x_gvev_rec);
4247:
4248: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
4249: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4250: x_return_status := l_return_status;
4251: RAISE G_EXCEPTION_HALT_VALIDATION;
4252: ELSE
4253: x_return_status := l_return_status;

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

4259: WHEN G_EXCEPTION_HALT_VALIDATION THEN
4260: NULL;
4261: WHEN OTHERS THEN
4262: -- store SQL error message on message stack for caller
4263: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
4264: -- notify caller of an UNEXPECTED error
4265: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
4266:
4267: END copy_governances;

Line 4265: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

4261: WHEN OTHERS THEN
4262: -- store SQL error message on message stack for caller
4263: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
4264: -- notify caller of an UNEXPECTED error
4265: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
4266:
4267: END copy_governances;
4268:
4269: --------------------------------------------------------------------------------

Line 5123: RAISE OKC_API.G_EXCEPTION_ERROR;

5119: END IF;
5120: END LOOP;
5121: END IF;
5122:
5123: RAISE OKC_API.G_EXCEPTION_ERROR;
5124: END copy_var_int_rate_params;
5125:
5126: --------------------------------------------------------------------------------
5127: -- Start of comments

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

5419: TYPE l_name_type IS TABLE OF okc_k_lines_tl.name%TYPE INDEX BY BINARY_INTEGER;
5420:
5421: -- For okl_k_lines whole record
5422: TYPE l_okl_k_lines_rec_type IS RECORD (
5423: --id okl_k_lines.id%type := OKC_API.G_MISS_NUM,
5424: id NUMBER := OKC_API.G_MISS_NUM,
5425: oec okl_k_lines.oec%TYPE,
5426: year_built okl_k_lines.year_built%TYPE,
5427: item_description okc_k_lines_tl.item_description%TYPE := OKC_API.G_MISS_CHAR

Line 5424: id NUMBER := OKC_API.G_MISS_NUM,

5420:
5421: -- For okl_k_lines whole record
5422: TYPE l_okl_k_lines_rec_type IS RECORD (
5423: --id okl_k_lines.id%type := OKC_API.G_MISS_NUM,
5424: id NUMBER := OKC_API.G_MISS_NUM,
5425: oec okl_k_lines.oec%TYPE,
5426: year_built okl_k_lines.year_built%TYPE,
5427: item_description okc_k_lines_tl.item_description%TYPE := OKC_API.G_MISS_CHAR
5428: );

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

5423: --id okl_k_lines.id%type := OKC_API.G_MISS_NUM,
5424: id NUMBER := OKC_API.G_MISS_NUM,
5425: oec okl_k_lines.oec%TYPE,
5426: year_built okl_k_lines.year_built%TYPE,
5427: item_description okc_k_lines_tl.item_description%TYPE := OKC_API.G_MISS_CHAR
5428: );
5429: /*
5430: TYPE lines_rec_type is record (
5431: id okl_k_lines.id%type := OKC_API.G_MISS_NUM,

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

5427: item_description okc_k_lines_tl.item_description%TYPE := OKC_API.G_MISS_CHAR
5428: );
5429: /*
5430: TYPE lines_rec_type is record (
5431: id okl_k_lines.id%type := OKC_API.G_MISS_NUM,
5432: oec okl_k_lines.oec%type
5433: );
5434: TYPE lines_tbl_type is TABLE OF lines_rec_type
5435: index by binary_integer; */

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

5439: -- For okl_k_lines whole record
5440:
5441: -- For okc_k_items whole record
5442: TYPE l_okc_k_items_rec_type IS RECORD (
5443: id okc_k_items.cle_id%TYPE := OKC_API.G_MISS_NUM,
5444: number_of_items okc_k_items.number_of_items%TYPE := OKC_API.G_MISS_NUM,
5445: object1_id1 okc_k_items.object1_id1%TYPE := OKC_API.G_MISS_CHAR,
5446: object1_id2 okc_k_items.object1_id2%TYPE := OKC_API.G_MISS_CHAR
5447: );

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

5440:
5441: -- For okc_k_items whole record
5442: TYPE l_okc_k_items_rec_type IS RECORD (
5443: id okc_k_items.cle_id%TYPE := OKC_API.G_MISS_NUM,
5444: number_of_items okc_k_items.number_of_items%TYPE := OKC_API.G_MISS_NUM,
5445: object1_id1 okc_k_items.object1_id1%TYPE := OKC_API.G_MISS_CHAR,
5446: object1_id2 okc_k_items.object1_id2%TYPE := OKC_API.G_MISS_CHAR
5447: );
5448: TYPE l_okc_k_items_rec_tab IS TABLE OF l_okc_k_items_rec_type INDEX BY BINARY_INTEGER;

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

5441: -- For okc_k_items whole record
5442: TYPE l_okc_k_items_rec_type IS RECORD (
5443: id okc_k_items.cle_id%TYPE := OKC_API.G_MISS_NUM,
5444: number_of_items okc_k_items.number_of_items%TYPE := OKC_API.G_MISS_NUM,
5445: object1_id1 okc_k_items.object1_id1%TYPE := OKC_API.G_MISS_CHAR,
5446: object1_id2 okc_k_items.object1_id2%TYPE := OKC_API.G_MISS_CHAR
5447: );
5448: TYPE l_okc_k_items_rec_tab IS TABLE OF l_okc_k_items_rec_type INDEX BY BINARY_INTEGER;
5449: -- For okc_k_items whole record

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

5442: TYPE l_okc_k_items_rec_type IS RECORD (
5443: id okc_k_items.cle_id%TYPE := OKC_API.G_MISS_NUM,
5444: number_of_items okc_k_items.number_of_items%TYPE := OKC_API.G_MISS_NUM,
5445: object1_id1 okc_k_items.object1_id1%TYPE := OKC_API.G_MISS_CHAR,
5446: object1_id2 okc_k_items.object1_id2%TYPE := OKC_API.G_MISS_CHAR
5447: );
5448: TYPE l_okc_k_items_rec_tab IS TABLE OF l_okc_k_items_rec_type INDEX BY BINARY_INTEGER;
5449: -- For okc_k_items whole record
5450:

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

5448: TYPE l_okc_k_items_rec_tab IS TABLE OF l_okc_k_items_rec_type INDEX BY BINARY_INTEGER;
5449: -- For okc_k_items whole record
5450:
5451:
5452: 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);
5453: 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);
5454: 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);
5455: 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);
5456: 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 5453: 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);

5449: -- For okc_k_items whole record
5450:
5451:
5452: 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);
5453: 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);
5454: 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);
5455: 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);
5456: 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);
5457: 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 5454: 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);

5450:
5451:
5452: 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);
5453: 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);
5454: 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);
5455: 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);
5456: 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);
5457: 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);
5458: 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 5455: 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);

5451:
5452: 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);
5453: 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);
5454: 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);
5455: 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);
5456: 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);
5457: 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);
5458: 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);
5459: 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 5456: 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);

5452: 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);
5453: 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);
5454: 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);
5455: 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);
5456: 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);
5457: 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);
5458: 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);
5459: 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);
5460: 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 5457: 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);

5453: 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);
5454: 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);
5455: 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);
5456: 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);
5457: 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);
5458: 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);
5459: 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);
5460: 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);
5461: 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 5458: 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);

5454: 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);
5455: 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);
5456: 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);
5457: 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);
5458: 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);
5459: 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);
5460: 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);
5461: 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);
5462: 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 5459: 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);

5455: 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);
5456: 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);
5457: 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);
5458: 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);
5459: 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);
5460: 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);
5461: 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);
5462: 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);
5463: 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 5460: 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);

5456: 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);
5457: 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);
5458: 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);
5459: 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);
5460: 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);
5461: 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);
5462: 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);
5463: 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);
5464: 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 5461: 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);

5457: 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);
5458: 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);
5459: 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);
5460: 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);
5461: 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);
5462: 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);
5463: 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);
5464: 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);
5465: 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 5462: 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);

5458: 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);
5459: 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);
5460: 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);
5461: 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);
5462: 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);
5463: 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);
5464: 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);
5465: 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);
5466: 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 5463: 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);

5459: 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);
5460: 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);
5461: 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);
5462: 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);
5463: 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);
5464: 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);
5465: 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);
5466: 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);
5467: 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 5464: 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);

5460: 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);
5461: 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);
5462: 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);
5463: 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);
5464: 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);
5465: 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);
5466: 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);
5467: 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);
5468: 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 5465: 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);

5461: 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);
5462: 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);
5463: 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);
5464: 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);
5465: 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);
5466: 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);
5467: 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);
5468: 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);
5469:

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

5462: 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);
5463: 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);
5464: 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);
5465: 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);
5466: 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);
5467: 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);
5468: 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);
5469:
5470: TYPE l_bid_mapping_tab_type IS TABLE OF l_bid_mapping_type INDEX BY BINARY_INTEGER;

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

5463: 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);
5464: 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);
5465: 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);
5466: 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);
5467: 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);
5468: 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);
5469:
5470: TYPE l_bid_mapping_tab_type IS TABLE OF l_bid_mapping_type INDEX BY BINARY_INTEGER;
5471: TYPE l_cle_lse_mapping_tab_type IS TABLE OF l_cle_lse_mapping_type INDEX BY BINARY_INTEGER;

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

5464: 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);
5465: 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);
5466: 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);
5467: 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);
5468: 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);
5469:
5470: TYPE l_bid_mapping_tab_type IS TABLE OF l_bid_mapping_type INDEX BY BINARY_INTEGER;
5471: TYPE l_cle_lse_mapping_tab_type IS TABLE OF l_cle_lse_mapping_type INDEX BY BINARY_INTEGER;
5472: TYPE l_ssid_mapping_tab_type IS TABLE OF l_ssid_mapping_type INDEX BY BINARY_INTEGER;

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

5484: TYPE l_oid_mapping_tab_type IS TABLE OF l_oid_mapping_type INDEX BY BINARY_INTEGER;
5485: TYPE l_cle_mapping_tab_type IS TABLE OF l_cle_mapping_type INDEX BY BINARY_INTEGER;
5486: TYPE l_cle_mapping_tab_type2 IS TABLE OF l_cle_mapping_type2 INDEX BY BINARY_INTEGER;
5487:
5488: 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);
5489: TYPE l_party_id_mapping_tab_type IS TABLE OF l_party_id_mapping_type INDEX BY BINARY_INTEGER;
5490:
5491: 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);
5492: TYPE l_trx_id_mapping_tab_type IS TABLE OF l_trx_id_mapping_type INDEX BY BINARY_INTEGER;

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

5487:
5488: 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);
5489: TYPE l_party_id_mapping_tab_type IS TABLE OF l_party_id_mapping_type INDEX BY BINARY_INTEGER;
5490:
5491: 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);
5492: TYPE l_trx_id_mapping_tab_type IS TABLE OF l_trx_id_mapping_type INDEX BY BINARY_INTEGER;
5493:
5494: 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);
5495: TYPE l_txl_id_mapping_tab_type IS TABLE OF l_txl_id_mapping_type INDEX BY BINARY_INTEGER;

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

5490:
5491: 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);
5492: TYPE l_trx_id_mapping_tab_type IS TABLE OF l_trx_id_mapping_type INDEX BY BINARY_INTEGER;
5493:
5494: 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);
5495: TYPE l_txl_id_mapping_tab_type IS TABLE OF l_txl_id_mapping_type INDEX BY BINARY_INTEGER;
5496:
5497: -- For okl_k_party_roles begin
5498: TYPE l_plid_type is table of okl_k_party_roles.id%TYPE index by binary_integer;

Line 7241: x_return_status := OKC_API.G_RET_STS_SUCCESS;

7237: AND NVL(end_date_active,SYSDATE);
7238: BEGIN
7239:
7240: -- initialize return status
7241: x_return_status := OKC_API.G_RET_STS_SUCCESS;
7242:
7243: -- check that data exists
7244: IF (p_ccy_code = OKC_API.G_MISS_CHAR OR
7245: p_ccy_code IS NULL)

Line 7244: IF (p_ccy_code = OKC_API.G_MISS_CHAR OR

7240: -- initialize return status
7241: x_return_status := OKC_API.G_RET_STS_SUCCESS;
7242:
7243: -- check that data exists
7244: IF (p_ccy_code = OKC_API.G_MISS_CHAR OR
7245: p_ccy_code IS NULL)
7246: THEN
7247: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
7248: p_msg_name => g_required_value,

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

7243: -- check that data exists
7244: IF (p_ccy_code = OKC_API.G_MISS_CHAR OR
7245: p_ccy_code IS NULL)
7246: THEN
7247: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
7248: p_msg_name => g_required_value,
7249: p_token1 => g_col_name_token,
7250: p_token1_value => 'Currency Code');
7251: -- notify caller of an error

Line 7252: x_return_status := OKC_API.G_RET_STS_ERROR;

7248: p_msg_name => g_required_value,
7249: p_token1 => g_col_name_token,
7250: p_token1_value => 'Currency Code');
7251: -- notify caller of an error
7252: x_return_status := OKC_API.G_RET_STS_ERROR;
7253:
7254: -- halt validation
7255: RAISE G_EXCEPTION_HALT_VALIDATION;
7256: END IF;

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

7261: CLOSE l_fndv_csr;
7262:
7263: -- if l_dummy_var still set to default, data was not found
7264: IF (l_dummy_var = '?') THEN
7265: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
7266: p_msg_name => 'OKL_NO_PARENT_RECORD',
7267: p_token1 => g_col_name_token,
7268: p_token1_value => 'currency_code',
7269: p_token2 => g_child_table_token,

Line 7274: x_return_status := OKC_API.G_RET_STS_ERROR;

7270: p_token2_value => 'OKL_TRX_AP_INVOICES_V',
7271: p_token3 => g_parent_table_token,
7272: p_token3_value => 'FND_CURRENCIES');
7273: -- notify caller of an error
7274: x_return_status := OKC_API.G_RET_STS_ERROR;
7275: END IF;
7276:
7277:
7278: EXCEPTION

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

7285: WHEN OTHERS THEN
7286:
7287:
7288: -- store SQL error message on message stack
7289: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
7290: p_msg_name => g_unexpected_error,
7291: p_token1 => g_sqlcode_token,
7292: p_token1_value => SQLCODE,
7293: p_token2 => g_sqlerrm_token,

Line 7296: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

7292: p_token1_value => SQLCODE,
7293: p_token2 => g_sqlerrm_token,
7294: p_token2_value => SQLERRM);
7295: -- notify caller of an error as UNEXPETED error
7296: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
7297:
7298: -- verify that cursor was closed
7299: IF l_fndv_csr%ISOPEN THEN
7300: CLOSE l_fndv_csr;

Line 7314: x_return_status := OKC_API.G_RET_STS_SUCCESS;

7310: BEGIN
7311:
7312:
7313: -- initialize return status
7314: x_return_status := OKC_API.G_RET_STS_SUCCESS;
7315:
7316: -- enforce foreign key if data exists
7317: IF (p_orig_system_source_code <> OKC_API.G_MISS_CHAR AND
7318: p_orig_system_source_code IS NOT NULL)

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

7313: -- initialize return status
7314: x_return_status := OKC_API.G_RET_STS_SUCCESS;
7315:
7316: -- enforce foreign key if data exists
7317: IF (p_orig_system_source_code <> OKC_API.G_MISS_CHAR AND
7318: p_orig_system_source_code IS NOT NULL)
7319: THEN
7320: -- Check if the value is a valid code from lookup table
7321: x_return_status := OKC_UTIL.check_lookup_code('OKC_CONTRACT_SOURCES',

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

7319: THEN
7320: -- Check if the value is a valid code from lookup table
7321: x_return_status := OKC_UTIL.check_lookup_code('OKC_CONTRACT_SOURCES',
7322: p_orig_system_source_code);
7323: IF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
7324: --set error message in message stack
7325: OKC_API.SET_MESSAGE(
7326: p_app_name => G_APP_NAME,
7327: p_msg_name => G_INVALID_VALUE,

Line 7325: OKC_API.SET_MESSAGE(

7321: x_return_status := OKC_UTIL.check_lookup_code('OKC_CONTRACT_SOURCES',
7322: p_orig_system_source_code);
7323: IF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
7324: --set error message in message stack
7325: OKC_API.SET_MESSAGE(
7326: p_app_name => G_APP_NAME,
7327: p_msg_name => G_INVALID_VALUE,
7328: p_token1 => G_COL_NAME_TOKEN,
7329: p_token1_value => 'ORIG_SYSTEM_SOURCE_CODE');

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

7327: p_msg_name => G_INVALID_VALUE,
7328: p_token1 => G_COL_NAME_TOKEN,
7329: p_token1_value => 'ORIG_SYSTEM_SOURCE_CODE');
7330: RAISE G_EXCEPTION_HALT_VALIDATION;
7331: ELSIF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
7332: RAISE G_EXCEPTION_HALT_VALIDATION;
7333: END IF;
7334: END IF;
7335:

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

7338: WHEN OTHERS THEN
7339:
7340:
7341: -- store SQL error message on message stack
7342: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
7343: p_msg_name => g_unexpected_error,
7344: p_token1 => g_sqlcode_token,
7345: p_token1_value=> SQLCODE,
7346: p_token2 => g_sqlerrm_token,

Line 7349: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

7345: p_token1_value=> SQLCODE,
7346: p_token2 => g_sqlerrm_token,
7347: p_token2_value=> SQLERRM);
7348: -- notify caller of an error as UNEXPETED error
7349: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
7350:
7351: END validate_orig_sys_code;
7352:
7353: PROCEDURE validate_currency_conv_type

Line 7366: x_return_status := OKC_API.G_RET_STS_SUCCESS;

7362:
7363: l_valid_convert_type VARCHAR2(1) DEFAULT '?';
7364: BEGIN
7365: -- initialize return status
7366: x_return_status := OKC_API.G_RET_STS_SUCCESS;
7367: IF (p_CURRENCY_CONVERSION_TYPE <> OKC_API.G_MISS_CHAR AND
7368: p_CURRENCY_CONVERSION_TYPE IS NOT NULL)
7369: THEN
7370: -- check allowed values

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

7363: l_valid_convert_type VARCHAR2(1) DEFAULT '?';
7364: BEGIN
7365: -- initialize return status
7366: x_return_status := OKC_API.G_RET_STS_SUCCESS;
7367: IF (p_CURRENCY_CONVERSION_TYPE <> OKC_API.G_MISS_CHAR AND
7368: p_CURRENCY_CONVERSION_TYPE IS NOT NULL)
7369: THEN
7370: -- check allowed values
7371: l_valid_convert_type := '?';

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

7376: END IF;
7377: CLOSE curr_conv_type_csr;
7378:
7379: IF (l_valid_convert_type = '?') THEN
7380: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
7381: p_msg_name => g_invalid_value,
7382: p_token1 => g_col_name_token,
7383: p_token1_value => 'CURRENCY_CONVERSION_TYPE');
7384: -- notify caller of an error

Line 7385: x_return_status := OKC_API.G_RET_STS_ERROR;

7381: p_msg_name => g_invalid_value,
7382: p_token1 => g_col_name_token,
7383: p_token1_value => 'CURRENCY_CONVERSION_TYPE');
7384: -- notify caller of an error
7385: x_return_status := OKC_API.G_RET_STS_ERROR;
7386: END IF;
7387: END IF;
7388: EXCEPTION
7389: WHEN OTHERS THEN

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

7387: END IF;
7388: EXCEPTION
7389: WHEN OTHERS THEN
7390: -- store SQL error message on message stack
7391: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
7392: p_msg_name => g_unexpected_error,
7393: p_token1 => g_sqlcode_token,
7394: p_token1_value => SQLCODE,
7395: p_token2 => g_sqlerrm_token,

Line 7398: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

7394: p_token1_value => SQLCODE,
7395: p_token2 => g_sqlerrm_token,
7396: p_token2_value => SQLERRM);
7397: -- notify caller of an error as UNEXPETED error
7398: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
7399: END validate_CURRENCY_CONV_TYPE;
7400:
7401: PROCEDURE validate_amd_code(x_return_status OUT NOCOPY VARCHAR2,
7402: p_amd_code IN okl_k_headers.amd_code%TYPE) IS

Line 7405: x_return_status := OKC_API.G_RET_STS_SUCCESS;

7401: PROCEDURE validate_amd_code(x_return_status OUT NOCOPY VARCHAR2,
7402: p_amd_code IN okl_k_headers.amd_code%TYPE) IS
7403: BEGIN
7404: -- initialize return status
7405: x_return_status := OKC_API.G_RET_STS_SUCCESS;
7406:
7407: -- enforce foreign key if data exists
7408: IF (p_AMD_CODE <> OKC_API.G_MISS_CHAR AND
7409: p_AMD_CODE IS NOT NULL)

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

7404: -- initialize return status
7405: x_return_status := OKC_API.G_RET_STS_SUCCESS;
7406:
7407: -- enforce foreign key if data exists
7408: IF (p_AMD_CODE <> OKC_API.G_MISS_CHAR AND
7409: p_AMD_CODE IS NOT NULL)
7410: THEN
7411: -- Check if the value is a valid code from lookup table
7412: x_return_status := OKC_UTIL.check_lookup_code('OKL_ACCEPTANCE_METHOD',

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

7410: THEN
7411: -- Check if the value is a valid code from lookup table
7412: x_return_status := OKC_UTIL.check_lookup_code('OKL_ACCEPTANCE_METHOD',
7413: p_AMD_CODE);
7414: IF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
7415: --set error message in message stack
7416: OKC_API.SET_MESSAGE(
7417: p_app_name => G_APP_NAME,
7418: p_msg_name => G_INVALID_VALUE,

Line 7416: OKC_API.SET_MESSAGE(

7412: x_return_status := OKC_UTIL.check_lookup_code('OKL_ACCEPTANCE_METHOD',
7413: p_AMD_CODE);
7414: IF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
7415: --set error message in message stack
7416: OKC_API.SET_MESSAGE(
7417: p_app_name => G_APP_NAME,
7418: p_msg_name => G_INVALID_VALUE,
7419: p_token1 => G_COL_NAME_TOKEN,
7420: p_token1_value => 'ACCEPTANCE_METHOD');

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

7418: p_msg_name => G_INVALID_VALUE,
7419: p_token1 => G_COL_NAME_TOKEN,
7420: p_token1_value => 'ACCEPTANCE_METHOD');
7421: RAISE G_EXCEPTION_HALT_VALIDATION;
7422: ELSIF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
7423: RAISE G_EXCEPTION_HALT_VALIDATION;
7424: END IF;
7425: END IF;
7426: EXCEPTION

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

7425: END IF;
7426: EXCEPTION
7427: WHEN OTHERS THEN
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: END validate_AMD_CODE;
7438: /*
7439: */
7440:

Line 7606: RAISE OKC_API.G_EXCEPTION_ERROR;

7602: 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);
7603: END IF;
7604: END LOOP;
7605:
7606: RAISE OKC_API.G_EXCEPTION_ERROR;
7607:
7608: END; /* sort_bid_mapping_tab */
7609:
7610: FUNCTION find_cle_lse_mapping_id(p_cle_id IN NUMBER, p_lse_id IN NUMBER) RETURN NUMBER IS

Line 7843: RAISE OKC_API.G_EXCEPTION_ERROR;

7839: 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);
7840: END IF;
7841: END LOOP;
7842:
7843: RAISE OKC_API.G_EXCEPTION_ERROR;
7844:
7845: END; /* sort_cle_lse_mapping_tab */
7846:
7847:

Line 8010: RAISE OKC_API.G_EXCEPTION_ERROR;

8006: 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);
8007: END IF;
8008: END LOOP;
8009:
8010: RAISE OKC_API.G_EXCEPTION_ERROR;
8011:
8012: END; /* sort_cid_mapping_tab */
8013:
8014: PROCEDURE do_sort IS

Line 8183: RAISE OKC_API.G_EXCEPTION_ERROR;

8179: 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);
8180: END IF;
8181: END LOOP;
8182:
8183: RAISE OKC_API.G_EXCEPTION_ERROR;
8184:
8185: END; /* do_sort */
8186:
8187: FUNCTION find_id(p_id IN NUMBER) RETURN NUMBER IS

Line 8254: x_return_status := OKC_API.G_RET_STS_ERROR;

8250: BEGIN
8251: OPEN c_asset_no;
8252: FETCH c_asset_no INTO x_asset_number;
8253: IF (c_asset_no%NOTFOUND) THEN
8254: x_return_status := OKC_API.G_RET_STS_ERROR;
8255: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
8256: p_msg_name => g_unexpected_error,
8257: p_token1 => g_sqlcode_token,
8258: p_token1_value => SQLCODE,

Line 8294: x_return_status := OKC_API.G_RET_STS_ERROR;

8290: ln_dummy3 = 1 THEN
8291: OPEN c_asset_no;
8292: FETCH c_asset_no INTO x_asset_number;
8293: IF (c_asset_no%NOTFOUND) THEN
8294: x_return_status := OKC_API.G_RET_STS_ERROR;
8295: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
8296: p_msg_name => g_unexpected_error,
8297: p_token1 => g_sqlcode_token,
8298: p_token1_value => SQLCODE,

Line 8323: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

8319: END IF;
8320: IF c_okx_assets_v%ISOPEN THEN
8321: CLOSE c_okx_assets_v;
8322: END IF;
8323: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
8324: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
8325: p_msg_name => g_unexpected_error,
8326: p_token1 => g_sqlcode_token,
8327: p_token1_value => SQLCODE,

Line 8545: RAISE OKC_API.G_EXCEPTION_ERROR;

8541: 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);
8542: END IF;
8543: END LOOP;
8544:
8545: RAISE OKC_API.G_EXCEPTION_ERROR;
8546:
8547: END; /* sort_cle_mapping_tab */
8548:
8549:

Line 8717: RAISE OKC_API.G_EXCEPTION_ERROR;

8713: 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);
8714: END IF;
8715: END LOOP;
8716:
8717: RAISE OKC_API.G_EXCEPTION_ERROR;
8718:
8719: END; /* sort_aid_mapping_tab */
8720:
8721: PROCEDURE do_id_mapping_sort IS

Line 8889: RAISE OKC_API.G_EXCEPTION_ERROR;

8885: 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);
8886: END IF;
8887: END LOOP;
8888:
8889: RAISE OKC_API.G_EXCEPTION_ERROR;
8890:
8891: END; /* do_id_mapping_sort */
8892:
8893: FUNCTION find_mapping_id(p_id IN NUMBER) RETURN NUMBER IS

Line 9175: RAISE OKC_API.G_EXCEPTION_ERROR;

9171: END LOOP;
9172: END IF;
9173:
9174:
9175: RAISE OKC_API.G_EXCEPTION_ERROR;
9176:
9177: END; /* insert okc_k_lines_tl */
9178:
9179: PROCEDURE insert_okc_k_lines_tl_old(p_old_id IN okc_k_lines_b.id%TYPE,

Line 9455: RAISE OKC_API.G_EXCEPTION_ERROR;

9451: END IF;
9452: END LOOP;
9453: END IF;
9454:
9455: RAISE OKC_API.G_EXCEPTION_ERROR;
9456:
9457: END; /* insert_okc_k_headers_tl */
9458:
9459: PROCEDURE insert_okl_k_headers(p_old_id IN okc_k_headers_tl.id%TYPE,

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

9707: FOR i IN l_id_tab.first..l_id_tab.last LOOP
9708: l_id_tab(i) := p_new_id;
9709:
9710: validate_amd_code(x_return_status, l_amd_code_tab(i));
9711: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
9712: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
9713: END IF;
9714:
9715: END LOOP;

Line 9879: RAISE OKC_API.G_EXCEPTION_ERROR;

9875: END LOOP;
9876: END IF;
9877:
9878:
9879: RAISE OKC_API.G_EXCEPTION_ERROR;
9880:
9881: END; /* insert_okl_k_headers */
9882:
9883: PROCEDURE insert_okl_slctd_optns(p_old_id IN okc_k_headers_tl.id%TYPE,

Line 10073: RAISE OKC_API.G_EXCEPTION_ERROR;

10069: END IF;
10070: END LOOP;
10071: END IF;
10072:
10073: RAISE OKC_API.G_EXCEPTION_ERROR;
10074:
10075: END; /* insert_okl_slctd_optns */
10076:
10077: FUNCTION find_osid_mapping_id(p_id IN NUMBER) RETURN NUMBER IS

Line 10239: RAISE OKC_API.G_EXCEPTION_ERROR;

10235: 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);
10236: END IF;
10237: END LOOP;
10238:
10239: RAISE OKC_API.G_EXCEPTION_ERROR;
10240:
10241: END; /* sort_osid_mapping_tab */
10242:
10243: FUNCTION find_okl_k_lines_rec(p_id IN NUMBER) RETURN l_okl_k_lines_rec_type IS

Line 10432: RAISE OKC_API.G_EXCEPTION_ERROR;

10428: 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 );
10429: END IF;
10430: END LOOP;
10431:
10432: RAISE OKC_API.G_EXCEPTION_ERROR;
10433:
10434: END; /* sort_okl_k_lines_rec */
10435:
10436:

Line 11372: RAISE OKC_API.G_EXCEPTION_ERROR;

11368: END IF;
11369: END LOOP;
11370: END IF;
11371:
11372: RAISE OKC_API.G_EXCEPTION_ERROR;
11373:
11374: END; /* insert_okl_k_lines */
11375:
11376: PROCEDURE do_sort_party_mapping_id IS

Line 11544: RAISE OKC_API.G_EXCEPTION_ERROR;

11540: 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);
11541: END IF;
11542: END LOOP;
11543:
11544: RAISE OKC_API.G_EXCEPTION_ERROR;
11545:
11546: END; /* do_sort_party_mapping_id */
11547:
11548: FUNCTION find_party_mapping_id(p_id IN NUMBER) RETURN NUMBER IS

Line 11716: RAISE OKC_API.G_EXCEPTION_ERROR;

11712: END LOOP;
11713:
11714: END IF;
11715:
11716: RAISE OKC_API.G_EXCEPTION_ERROR;
11717:
11718: END; /* prepare_okl_party_roles */
11719:
11720: PROCEDURE prepare_party_roles_tl (p_old_id IN okc_k_party_roles_b.id%TYPE,

Line 11832: RAISE OKC_API.G_EXCEPTION_ERROR;

11828: END IF;
11829: END LOOP;
11830: END IF;
11831:
11832: RAISE OKC_API.G_EXCEPTION_ERROR;
11833:
11834: END; /* prepare_party_roles_tl */
11835:
11836: PROCEDURE prepare_contacts (p_old_id IN okc_k_party_roles_b.id%TYPE,

Line 12055: RAISE OKC_API.G_EXCEPTION_ERROR;

12051: END IF;
12052: END LOOP;
12053: END IF;
12054:
12055: RAISE OKC_API.G_EXCEPTION_ERROR;
12056:
12057: END; /* prepare_contacts */
12058:
12059: FUNCTION find_phid_mapping_id(p_id IN NUMBER) RETURN NUMBER IS

Line 12216: RAISE OKC_API.G_EXCEPTION_ERROR;

12212: 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);
12213: END IF;
12214: END LOOP;
12215:
12216: RAISE OKC_API.G_EXCEPTION_ERROR;
12217:
12218: END; /* sort_phid_mapping_tab */
12219:
12220:

Line 12372: RAISE OKC_API.G_EXCEPTION_ERROR;

12368: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'PASSTHRU_STREAM_TYPE_ID('||i||')=' || l_phPASSTHRU_STRE_TYPE_ID_tab(i));
12369: END IF;
12370: end loop;
12371: END IF;
12372: RAISE OKC_API.G_EXCEPTION_ERROR;
12373:
12374: END;
12375:
12376: PROCEDURE prepare_party_payment_dtls (p_old_id IN okc_k_party_roles_b.id%TYPE,

Line 12620: RAISE OKC_API.G_EXCEPTION_ERROR;

12616: END IF;
12617: END LOOP;
12618: END IF;
12619:
12620: RAISE OKC_API.G_EXCEPTION_ERROR;
12621:
12622: END; /* prepare_party_payment_dtls */
12623:
12624: FUNCTION find_vid_mapping_id(p_id IN NUMBER) RETURN VARCHAR2 IS

Line 12786: RAISE OKC_API.G_EXCEPTION_ERROR;

12782: 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);
12783: END IF;
12784: END LOOP;
12785:
12786: RAISE OKC_API.G_EXCEPTION_ERROR;
12787:
12788: END; /* sort_vid_mapping_tab */
12789:
12790: PROCEDURE insert_okc_k_party_roles(p_old_id IN okc_k_headers_b.id%TYPE,

Line 13229: RAISE OKC_API.G_EXCEPTION_ERROR;

13225: END IF;
13226: END LOOP;
13227: END IF;
13228:
13229: RAISE OKC_API.G_EXCEPTION_ERROR;
13230:
13231: END; /* insert_okc_k_party_roles */
13232:
13233: FUNCTION find_rid_mapping_id(p_id IN NUMBER) RETURN NUMBER IS

Line 13395: RAISE OKC_API.G_EXCEPTION_ERROR;

13391: 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);
13392: END IF;
13393: END LOOP;
13394:
13395: RAISE OKC_API.G_EXCEPTION_ERROR;
13396:
13397: END; /* sort_rid_mapping_tab */
13398:
13399:

Line 13562: RAISE OKC_API.G_EXCEPTION_ERROR;

13558: 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);
13559: END IF;
13560: END LOOP;
13561:
13562: RAISE OKC_API.G_EXCEPTION_ERROR;
13563:
13564: END; /* sort_rrid_mapping_tab */
13565:
13566:

Line 13670: RAISE OKC_API.G_EXCEPTION_ERROR;

13666: END IF;
13667: END LOOP;
13668: END IF;
13669:
13670: RAISE OKC_API.G_EXCEPTION_ERROR;
13671:
13672: END; /* prepare_rule_groups_tl */
13673:
13674: PROCEDURE insert_okc_rules_tl(p_old_id IN okc_rules_b.id%TYPE,

Line 13780: RAISE OKC_API.G_EXCEPTION_ERROR;

13776: END IF;
13777: END LOOP;
13778: END IF;
13779:
13780: RAISE OKC_API.G_EXCEPTION_ERROR;
13781:
13782: END; /* insert_okc_rules_tl */
13783:
13784: PROCEDURE insert_okc_rules_b( p_old_id IN okc_rule_groups_b.id%TYPE,

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

13900: p_primary_sty_purpose => 'RENT',
13901: p_dependent_sty_purpose => 'UNSCHEDULED_PRINCIPAL_PAYMENT',
13902: x_return_status => l_return_status2,
13903: x_dependent_sty_id => l_unsched_prin_stream_id);
13904: IF (l_return_status2 <> OKC_API.G_RET_STS_SUCCESS) THEN
13905: l_unsched_prin_stream_id := NULL;
13906: END IF;
13907:
13908: okl_streams_util.get_dependent_stream_type (

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

13910: p_primary_sty_purpose => 'RENT',
13911: p_dependent_sty_purpose => 'UNSCHEDULED_LOAN_PAYMENT',
13912: x_return_status => l_return_status2,
13913: x_dependent_sty_id => l_unsched_loan_stream_id);
13914: IF (l_return_status2 <> OKC_API.G_RET_STS_SUCCESS) THEN
13915: l_unsched_loan_stream_id := NULL;
13916: END IF;
13917:
13918: --print('AKP:l_unsched_prin_stream_id=' || l_unsched_prin_stream_id);

Line 14246: RAISE OKC_API.G_EXCEPTION_ERROR;

14242: END IF;
14243: END LOOP;
14244: END IF;
14245:
14246: RAISE OKC_API.G_EXCEPTION_ERROR;
14247:
14248: END; /* insert_okc_rules_b */
14249:
14250: FUNCTION find_tid_mapping_id(p_id IN VARCHAR2) RETURN NUMBER IS

Line 14412: RAISE OKC_API.G_EXCEPTION_ERROR;

14408: 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);
14409: END IF;
14410: END LOOP;
14411:
14412: RAISE OKC_API.G_EXCEPTION_ERROR;
14413:
14414: END; /* sort_tid_mapping_tab */
14415:
14416: PROCEDURE insert_okc_rule_groups (p_old_id IN okc_k_headers_b.id%TYPE,

Line 14666: RAISE OKC_API.G_EXCEPTION_ERROR;

14662: END IF;
14663: END LOOP;
14664: END IF;
14665:
14666: RAISE OKC_API.G_EXCEPTION_ERROR;
14667:
14668: END; /* insert_okc_rule_groups */
14669:
14670: FUNCTION find_oid_mapping_id(p_id IN NUMBER) RETURN VARCHAR2 IS

Line 14834: RAISE OKC_API.G_EXCEPTION_ERROR;

14830: 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);
14831: END IF;
14832: END LOOP;
14833:
14834: RAISE OKC_API.G_EXCEPTION_ERROR;
14835:
14836: END; /* sort_oid_mapping_tab */
14837:
14838: FUNCTION find_okc_k_items_rec(p_id IN NUMBER) RETURN l_okc_k_items_rec_type IS

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

14852: ELSE
14853: lo := m + 1;
14854: END IF;
14855: END LOOP;
14856: l_dummy_rec.number_of_items := OKC_API.G_MISS_NUM;
14857: RETURN l_dummy_rec;
14858: END; /* find_okc_k_items_rec */
14859:
14860: PROCEDURE sort_okc_k_items_rec IS

Line 15036: RAISE OKC_API.G_EXCEPTION_ERROR;

15032: || l_okc_k_items_rec(i).object1_id1 || ':' || l_okc_k_items_rec(i).object1_id2 );
15033: END IF;
15034: END LOOP;
15035:
15036: RAISE OKC_API.G_EXCEPTION_ERROR;
15037:
15038: END; /* sort_okc_k_items_rec */
15039:
15040:

Line 15266: RAISE OKC_API.G_EXCEPTION_ERROR;

15262: END IF;
15263: END LOOP;
15264: END IF;
15265:
15266: RAISE OKC_API.G_EXCEPTION_ERROR;
15267:
15268: END; /* insert okc_k_items */
15269:
15270: PROCEDURE sort_trx_id_mapping_tab IS

Line 15412: RAISE OKC_API.G_EXCEPTION_ERROR;

15408: 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);
15409: END IF;
15410: END LOOP;
15411:
15412: RAISE OKC_API.G_EXCEPTION_ERROR;
15413:
15414: END; /* sort_trx_id_mapping_tab */
15415:
15416: FUNCTION find_trx_mapping_id(p_id IN NUMBER) RETURN NUMBER IS

Line 15579: RAISE OKC_API.G_EXCEPTION_ERROR;

15575: 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);
15576: END IF;
15577: END LOOP;
15578:
15579: RAISE OKC_API.G_EXCEPTION_ERROR;
15580:
15581: END; /* sort_trx_id_mapping_tab2 */
15582:
15583: FUNCTION find_trx_mapping_id2(p_id IN NUMBER) RETURN NUMBER IS

Line 15745: RAISE OKC_API.G_EXCEPTION_ERROR;

15741: 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);
15742: END IF;
15743: END LOOP;
15744:
15745: RAISE OKC_API.G_EXCEPTION_ERROR;
15746:
15747: END; /* sort_txl_id_mapping_tab */
15748:
15749: FUNCTION find_txl_mapping_id(p_id IN NUMBER) RETURN NUMBER IS

Line 15873: RAISE OKC_API.G_EXCEPTION_ERROR;

15869: END IF;
15870: END LOOP;
15871: END IF;
15872:
15873: RAISE OKC_API.G_EXCEPTION_ERROR;
15874:
15875: END; /* insert_okl_txl_assets_tl */
15876:
15877: PROCEDURE insert_okl_txd_assets_tl(p_old_id IN okc_k_headers_b.id%TYPE,

Line 15985: RAISE OKC_API.G_EXCEPTION_ERROR;

15981: END IF;
15982: END LOOP;
15983: END IF;
15984:
15985: RAISE OKC_API.G_EXCEPTION_ERROR;
15986:
15987: END; /* insert_okl_txd_assets_tl */
15988:
15989: PROCEDURE insert_okl_txd_assets_b(p_old_id IN okc_k_headers_b.id%TYPE,

Line 16256: RAISE OKC_API.G_EXCEPTION_ERROR;

16252: END IF;
16253: END LOOP;
16254: END IF;
16255:
16256: RAISE OKC_API.G_EXCEPTION_ERROR;
16257:
16258: END; /* insert_okl_txd_assets_b */
16259:
16260: FUNCTION find_dbid_mapping_id(p_id IN NUMBER) RETURN NUMBER IS

Line 16422: RAISE OKC_API.G_EXCEPTION_ERROR;

16418: 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);
16419: END IF;
16420: END LOOP;
16421:
16422: RAISE OKC_API.G_EXCEPTION_ERROR;
16423:
16424: END; /* sort_dbid_mapping_tab */
16425:
16426: PROCEDURE insert_okl_txl_assets_b(p_old_id IN okc_k_headers_b.id%TYPE,

Line 16892: RAISE OKC_API.G_EXCEPTION_ERROR;

16888: END IF;
16889: END LOOP;
16890: END IF;
16891:
16892: RAISE OKC_API.G_EXCEPTION_ERROR;
16893:
16894: END; /* insert_okl_txl_assets_b */
16895:
16896: PROCEDURE insert_okl_trx_assets(p_old_id IN okc_k_headers_b.id%TYPE,

Line 17114: RAISE OKC_API.G_EXCEPTION_ERROR;

17110: END IF;
17111: END LOOP;
17112: END IF;
17113:
17114: RAISE OKC_API.G_EXCEPTION_ERROR;
17115:
17116: END; /* insert_okl_trx_assets */
17117:
17118: PROCEDURE insert_okl_trx_assets_2(p_old_id IN okc_k_headers_b.id%TYPE,

Line 17333: RAISE OKC_API.G_EXCEPTION_ERROR;

17329: END IF;
17330: END LOOP;
17331: END IF;
17332:
17333: RAISE OKC_API.G_EXCEPTION_ERROR;
17334:
17335: END; /* insert_okl_trx_assets_2 */
17336:
17337: -- AKP: Delete this function from here. And use

Line 17355: x_return_status := OKC_API.G_RET_STS_ERROR;

17351: BEGIN
17352: OPEN c_instance_no_ib;
17353: FETCH c_instance_no_ib INTO x_instance_number_ib;
17354: IF (c_instance_no_ib%NOTFOUND) THEN
17355: x_return_status := OKC_API.G_RET_STS_ERROR;
17356: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
17357: p_msg_name => g_unexpected_error,
17358: p_token1 => g_sqlcode_token,
17359: p_token1_value => SQLCODE,

Line 17370: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

17366: WHEN OTHERS THEN
17367: IF c_instance_no_ib%ISOPEN THEN
17368: CLOSE c_instance_no_ib;
17369: END IF;
17370: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
17371: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
17372: p_msg_name => g_unexpected_error,
17373: p_token1 => g_sqlcode_token,
17374: p_token1_value => SQLCODE,

Line 17685: RAISE OKC_API.G_EXCEPTION_ERROR;

17681: END IF;
17682: END LOOP;
17683: END IF;
17684:
17685: RAISE OKC_API.G_EXCEPTION_ERROR;
17686:
17687: END; /* insert_okl_txl_itm_insts */
17688:
17689: PROCEDURE get_orig_depreciation_cost( p_fa_cost IN NUMBER,

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

17724: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_fa_cost='|| p_fa_cost || ' l_converted_cost='||l_converted_cost);
17725: END IF;
17726: IF (p_fa_cost >= 0) AND (l_converted_cost < 0) THEN
17727: --currency conversion rate was not found in Oracle GL
17728: OKC_API.set_message(p_app_name => 'OKL_COPY_CONTRACT_PVT',
17729: p_msg_name => 'OKL_LLA_CONV_RATE_NOT_FOUND',
17730: p_token1 => 'FROM_CURRENCY',
17731: p_token1_value => x_contract_currency,
17732: p_token2 => 'TO_CURRENCY',

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

17834: x_currency_conversion_date => x_currency_conversion_date,
17835: x_converted_amount => l_salvage_value);
17836: IF (p_salvage_value >= 0) AND (l_salvage_value < 0) THEN
17837: --currency conversion rate was not found in Oracle GL
17838: OKC_API.set_message(p_app_name => 'OKL_COPY_CONTRACT_PVT',
17839: p_msg_name => 'OKL_LLA_CONV_RATE_NOT_FOUND',
17840: p_token1 => 'FROM_CURRENCY',
17841: p_token1_value => x_contract_currency,
17842: p_token2 => 'TO_CURRENCY',

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

18352:
18353: l_tb2current_units_tab(l_trx_assets_counter4) := l_CURRENT_UNITS_tab(i);
18354: l_tb2manufacturer_name_tab(l_trx_assets_counter4) := l_MANUFACTURER_NAME_tab(i);
18355: l_tmp_okl_42_rec := find_okl_k_lines_rec(l_id_local_tab(i));
18356: IF (l_tmp_okl_42_rec.year_built = OKC_API.G_MISS_NUM ) THEN
18357: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
18358: 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));
18359: END IF;
18360: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 18936: RAISE OKC_API.G_EXCEPTION_ERROR;

18932: END IF;
18933: END LOOP;
18934: END IF;
18935:
18936: RAISE OKC_API.G_EXCEPTION_ERROR;
18937: END; /* insert okl_trx_assets_3 */
18938:
18939: PROCEDURE insert_okc_rg_party_roles(p_old_id IN okc_k_headers_b.id%TYPE,
18940: p_new_id IN okc_k_headers_b.id%TYPE) IS

Line 19075: RAISE OKC_API.G_EXCEPTION_ERROR;

19071: END IF;
19072: END LOOP;
19073: END IF;
19074:
19075: RAISE OKC_API.G_EXCEPTION_ERROR;
19076:
19077: END; /* insert_okc_rg_party_roles */
19078:
19079: PROCEDURE insert_okl_supp_invoice_dtls(p_old_id IN okc_k_headers_b.id%TYPE)

Line 19361: RAISE OKC_API.G_EXCEPTION_ERROR;

19357: END IF;
19358: END LOOP;
19359: END IF;
19360:
19361: RAISE OKC_API.G_EXCEPTION_ERROR;
19362:
19363: END;
19364:
19365: PROCEDURE get_object1_id1(p_install_location_type_code IN okx_install_items_v.location_type_code%TYPE,

Line 19794: RAISE OKC_API.G_EXCEPTION_ERROR;

19790: END IF;
19791: END LOOP;
19792: END IF;
19793:
19794: RAISE OKC_API.G_EXCEPTION_ERROR;
19795:
19796: END; /* insert_okl_txl_itm_insts2 */
19797:
19798: FUNCTION find_sid_mapping_id(p_id IN NUMBER) RETURN NUMBER IS

Line 19960: RAISE OKC_API.G_EXCEPTION_ERROR;

19956: 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);
19957: END IF;
19958: END LOOP;
19959:
19960: RAISE OKC_API.G_EXCEPTION_ERROR;
19961:
19962: END; /* sort_sid_mapping_tab */
19963:
19964: PROCEDURE raise_business_event_header(

Line 19973: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

19969: l_check VARCHAR2(1);
19970: l_parameter_list wf_parameter_list_t;
19971: BEGIN
19972:
19973: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
19974: -- Our contract is always new. So commented following check
19975: --IF (p_source_code = 'new') THEN
19976: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID,p_chr_id,l_parameter_list);
19977: OKL_WF_PVT.raise_event (p_api_version => p_api_version,

Line 20071: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

20067: END raise_business_event_subsidy;
20068:
20069: PROCEDURE raise_business_event_itm(
20070: p_api_version IN NUMBER
20071: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
20072: ,x_return_status OUT NOCOPY VARCHAR2
20073: ,x_msg_count OUT NOCOPY NUMBER
20074: ,x_msg_data OUT NOCOPY VARCHAR2
20075: ,p_event_name IN WF_EVENTS.NAME%TYPE

Line 20435: RAISE OKC_API.G_EXCEPTION_ERROR;

20431: 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);
20432: END IF;
20433: END LOOP;
20434:
20435: RAISE OKC_API.G_EXCEPTION_ERROR;
20436:
20437: END; /* sort_ssid_mapping_tab */
20438:
20439: BEGIN

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

20512: p_scs_code => c1rec.scs_code,
20513: p_modifier => p_contract_number_modifier,
20514: x_return_status => x_return_status,
20515: x_contract_number => l_contract_number);
20516: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
20517: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
20518: p_msg_name => g_unexpected_error,
20519: p_token1 => g_sqlcode_token,
20520: p_token1_value => SQLCODE,

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

20513: p_modifier => p_contract_number_modifier,
20514: x_return_status => x_return_status,
20515: x_contract_number => l_contract_number);
20516: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
20517: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
20518: p_msg_name => g_unexpected_error,
20519: p_token1 => g_sqlcode_token,
20520: p_token1_value => SQLCODE,
20521: p_token2 => g_sqlerrm_token,

Line 20553: --RAISE OKC_API.G_EXCEPTION_ERROR;

20549: x_msg_count,
20550: x_msg_data,
20551: '_PVT');
20552: RETURN;
20553: --RAISE OKC_API.G_EXCEPTION_ERROR;
20554: END IF;
20555:
20556: l_curr_pos := 'okl_copy_lease_contract:7';
20557: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

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

20559: END IF;
20560:
20561: -- AKP: need to do all validatations here
20562: validate_currency_code(x_return_status, l_contract_currency );
20563: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
20564: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
20565: END IF;
20566:
20567: l_curr_pos := 'okl_copy_lease_contract:8';

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

20565: END IF;
20566:
20567: l_curr_pos := 'okl_copy_lease_contract:8';
20568: validate_orig_sys_code(x_return_status, l_orig_system_source_code);
20569: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
20570: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
20571: END IF;
20572:
20573: l_curr_pos := 'okl_copy_lease_contract:9';

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

20571: END IF;
20572:
20573: l_curr_pos := 'okl_copy_lease_contract:9';
20574: validate_currency_conv_type(x_return_status, l_conversion_type);
20575: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
20576: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
20577: END IF;
20578:
20579: BEGIN

Line 20664: RAISE OKC_API.G_EXCEPTION_ERROR;

20660: OKL_API.set_message(p_app_name => 'OKL',
20661: p_msg_name => l_message,
20662: p_token1 => 'CONTRACT_NUMBER',
20663: p_token1_value => l_contract_number);
20664: RAISE OKC_API.G_EXCEPTION_ERROR;
20665: END;
20666: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
20667: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_copied_id=' || l_copied_id);
20668: END IF;

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

20685: x_msg_count => x_msg_count,
20686: x_msg_data => x_msg_data,
20687: p_hstv_rec => l_hstv_rec,
20688: x_hstv_rec => x_hstv_rec);
20689: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
20690: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
20691: END IF;
20692: EXCEPTION WHEN OTHERS THEN
20693: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 20697: RAISE OKC_API.G_EXCEPTION_ERROR;

20693: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
20694: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'sqlcode=' || SQLCODE || ':sqlerrm=' || SQLERRM);
20695: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'ERROR during insert into create_k_history...');
20696: END IF;
20697: RAISE OKC_API.G_EXCEPTION_ERROR;
20698: END;
20699:
20700: BEGIN
20701: l_curr_pos := 'okl_copy_lease_contract:13';

Line 20723: RAISE OKC_API.G_EXCEPTION_ERROR;

20719: OKL_API.set_message(p_app_name => 'OKL',
20720: p_msg_name => l_message,
20721: p_token1 => 'CONTRACT_NUMBER',
20722: p_token1_value => l_contract_number);
20723: RAISE OKC_API.G_EXCEPTION_ERROR;
20724: END;
20725:
20726: l_curr_pos := 'okl_copy_lease_contract:14';
20727: l_message := 'OKL_NEW_COPY_CHR_ERROR';

Line 20767: RAISE OKC_API.G_EXCEPTION_ERROR;

20763: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
20764: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'sqlcode=' || SQLCODE || ':sqlerrm=' || SQLERRM);
20765: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'ERROR during inser into okc_governances...');
20766: END IF;
20767: RAISE OKC_API.G_EXCEPTION_ERROR;
20768: END;
20769:
20770: l_curr_pos := 'okl_copy_lease_contract:19';
20771: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 21225: RAISE OKC_API.G_EXCEPTION_ERROR;

21221: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
21222: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'sqlcode=' || SQLCODE || ':sqlerrm=' || SQLERRM);
21223: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'ERROR during insert into okc_k_lines_b...');
21224: END IF;
21225: RAISE OKC_API.G_EXCEPTION_ERROR;
21226: END;
21227: END IF;
21228:
21229: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

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

21390: p_formula_name => 'LINE_CAP_AMNT',
21391: p_contract_id => l_copied_id,
21392: p_line_id => l_id2_tab(i),
21393: x_value => l_capital_amount);
21394: if (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
21395: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
21396: elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
21397: raise OKC_API.G_EXCEPTION_ERROR;
21398: end if;

Line 21395: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

21391: p_contract_id => l_copied_id,
21392: p_line_id => l_id2_tab(i),
21393: x_value => l_capital_amount);
21394: if (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
21395: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
21396: elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
21397: raise OKC_API.G_EXCEPTION_ERROR;
21398: end if;
21399: end if;

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

21392: p_line_id => l_id2_tab(i),
21393: x_value => l_capital_amount);
21394: if (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
21395: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
21396: elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
21397: raise OKC_API.G_EXCEPTION_ERROR;
21398: end if;
21399: end if;
21400: end loop;

Line 21397: raise OKC_API.G_EXCEPTION_ERROR;

21393: x_value => l_capital_amount);
21394: if (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
21395: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
21396: elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
21397: raise OKC_API.G_EXCEPTION_ERROR;
21398: end if;
21399: end if;
21400: end loop;
21401: end if;

Line 22264: p_restricted_update => OKC_API.G_FALSE,

22260: p_init_msg_list => p_init_msg_list,
22261: x_return_status => x_return_status,
22262: x_msg_count => x_msg_count,
22263: x_msg_data => x_msg_data,
22264: p_restricted_update => OKC_API.G_FALSE,
22265: p_chrv_rec => l_chrv_rec,
22266: x_chrv_rec => lx_chrv_rec);
22267:
22268: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN