eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKS_BILL_SCH dependencies on OKC_API

Line 662: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,

658: RETURN NULL;
659: WHEN OTHERS THEN
660: --set the error message and return with NULL to notify the
661: --caller of error
662: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
663: p_msg_name => G_UNEXPECTED_ERROR,
664: p_token1 => G_SQLCODE_TOKEN,
665: p_token1_value => sqlcode,
666: p_token2 => G_SQLERRM_TOKEN,

Line 772: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,

768: RETURN NULL;
769: WHEN OTHERS THEN
770: --set the error message and return with NULL to notify the
771: --caller of error
772: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
773: p_msg_name => G_UNEXPECTED_ERROR,
774: p_token1 => G_SQLCODE_TOKEN,
775: p_token1_value => sqlcode,
776: p_token2 => G_SQLERRM_TOKEN,

Line 821: l_init_msg_list VARCHAR2(2000) := OKC_API.G_FALSE;

817: l_sll_tbl OKS_BILL_SCH.StreamLvl_tbl;
818: l_line_inv_id NUMBER;
819: --
820:
821: l_init_msg_list VARCHAR2(2000) := OKC_API.G_FALSE;
822: l_return_status VARCHAR2(10);
823: l_msg_count NUMBER;
824: l_msg_data VARCHAR2(2000);
825: l_msg_index_out NUMBER;

Line 890: OKC_API.set_message(G_PKG_NAME,'BILLING SCHEDULE TYPE');

886: -------------------------------------------------------------------------
887:
888:
889: IF p_billing_type IS NULL THEN
890: OKC_API.set_message(G_PKG_NAME,'BILLING SCHEDULE TYPE');
891: x_return_status := 'E';
892: RAISE G_EXCEPTION_HALT_VALIDATION;
893: END IF;
894:

Line 898: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'INVOICE ID NULL.');

894:
895:
896:
897: IF p_invoice_rule_id IS NULL THEN
898: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'INVOICE ID NULL.');
899: x_return_status := 'E';
900: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
901: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.create_header_bill_sch.EXCEPTION',
902: 'p_invoice_rule_id null');

Line 945: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'CURRENCY CODE NOT FOUND.');

941: l_currency_code := Find_Currency_Code(
942: p_cle_id => NULL,
943: p_chr_id => p_sll_tbl(p_sll_tbl.FIRST).chr_id);
944: IF l_currency_code IS NULL THEN
945: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'CURRENCY CODE NOT FOUND.');
946: x_return_status := 'E';
947: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
948: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.create_header_bill_sch.EXCEPTION',
949: 'currency code not found.');

Line 1151: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,

1147: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
1148: END IF;
1149: l_currency_code := NULL;
1150: l_header_billing := NULL;
1151: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
1152: p_msg_name => G_UNEXPECTED_ERROR,
1153: p_token1 => G_SQLCODE_TOKEN,
1154: p_token1_value => sqlcode,
1155: p_token2 => G_SQLERRM_TOKEN,

Line 1250: l_init_msg_list VARCHAR2(2000) := OKC_API.G_FALSE;

1246: l_cp_term_dt DATE;
1247: l_line_term_dt DATE;
1248: --
1249: l_api_version CONSTANT NUMBER := 1.0;
1250: l_init_msg_list VARCHAR2(2000) := OKC_API.G_FALSE;
1251: l_msg_count NUMBER;
1252: l_msg_data VARCHAR2(2000);
1253: l_msg_index_out NUMBER;
1254: l_msg_index NUMBER;

Line 1295: -- OKC_API.set_message(G_PKG_NAME,'OKS_INVD_COV_RULE','RULE_NAME','IRE');

1291: END IF;
1292:
1293: IF p_invoice_rule_id IS NULL THEN
1294: -- nechatur 23-DEC-2005 for bug#4684706
1295: -- OKC_API.set_message(G_PKG_NAME,'OKS_INVD_COV_RULE','RULE_NAME','IRE');
1296: OKC_API.set_message(G_PKG_NAME,'OKS_INVOICING_RULE');
1297: -- end bug#4684706
1298: x_return_status := 'E';
1299: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 1296: OKC_API.set_message(G_PKG_NAME,'OKS_INVOICING_RULE');

1292:
1293: IF p_invoice_rule_id IS NULL THEN
1294: -- nechatur 23-DEC-2005 for bug#4684706
1295: -- OKC_API.set_message(G_PKG_NAME,'OKS_INVD_COV_RULE','RULE_NAME','IRE');
1296: OKC_API.set_message(G_PKG_NAME,'OKS_INVOICING_RULE');
1297: -- end bug#4684706
1298: x_return_status := 'E';
1299: RAISE G_EXCEPTION_HALT_VALIDATION;
1300: END IF;

Line 1303: OKC_API.set_message(G_PKG_NAME,'BILLING SCHEDULE TYPE');

1299: RAISE G_EXCEPTION_HALT_VALIDATION;
1300: END IF;
1301:
1302: IF p_billing_type IS NULL THEN
1303: OKC_API.set_message(G_PKG_NAME,'BILLING SCHEDULE TYPE');
1304: x_return_status := 'E';
1305: RAISE G_EXCEPTION_HALT_VALIDATION;
1306: END IF;
1307:

Line 1411: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'CURRENCY CODE NOT FOUND.');

1407: p_cle_id => p_sll_tbl(p_sll_tbl.first).cle_id,
1408: p_chr_id => NULL);
1409:
1410: IF l_currency_code IS NULL THEN
1411: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'CURRENCY CODE NOT FOUND.');
1412: x_return_status := 'E';
1413: RAISE G_EXCEPTION_HALT_VALIDATION;
1414: END IF;
1415: END IF;

Line 1711: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

1707: ||', cp id passed = '||l_subline_csr_rec.subline_id ||')');
1708: END IF;
1709:
1710:
1711: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
1712: RAISE G_EXCEPTION_HALT_VALIDATION;
1713: END IF;
1714: l_sll_count := 0;
1715: END IF; ---existing bill type <> 'P'

Line 1744: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

1740: 'Bill_Sch_Cp(x_return_status = '||x_return_status
1741: ||', cp id passed = '||l_subline_csr_rec.subline_id ||')');
1742: END IF;
1743:
1744: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
1745: RAISE G_EXCEPTION_HALT_VALIDATION;
1746: END IF;
1747:
1748: END IF; --sll count=0

Line 1775: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

1771: ||', cp id passed = '||l_subline_csr_rec.subline_id ||')');
1772: END IF;
1773:
1774:
1775: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
1776: RAISE G_EXCEPTION_HALT_VALIDATION;
1777: END IF;
1778:
1779: END IF; --- existing bill type <> P

Line 1890: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,

1886: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN
1887: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.create_bill_sch_rules.UNEXPECTED',
1888: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
1889: END IF;
1890: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
1891: p_msg_name => G_UNEXPECTED_ERROR,
1892: p_token1 => G_SQLCODE_TOKEN,
1893: p_token1_value => sqlcode,
1894: p_token2 => G_SQLERRM_TOKEN,

Line 1941: l_init_msg_list VARCHAR2(2000) := OKC_API.G_FALSE;

1937: l_subline_sll NUMBER;
1938: l_rul_status VARCHAR2(100);
1939: l_msg_count NUMBER;
1940: l_msg_data VARCHAR2(2000);
1941: l_init_msg_list VARCHAR2(2000) := OKC_API.G_FALSE;
1942: l_sll_amount VARCHAR2(450);
1943: l_amount NUMBER;
1944: l_tot_amt NUMBER;
1945: l_prior_index NUMBER;

Line 2181: l_strm_lvl_tbl_in(1).object_version_number := OKC_API.G_MISS_NUM;

2177: l_strm_lvl_tbl_in(1).invoice_offset_days := p_strm_lvl_tbl(l_tbl_count).invoice_offset_days;
2178: l_strm_lvl_tbl_in(1).interface_offset_days := p_strm_lvl_tbl(l_tbl_count).interface_offset_days;
2179:
2180:
2181: l_strm_lvl_tbl_in(1).object_version_number := OKC_API.G_MISS_NUM;
2182: l_strm_lvl_tbl_in(1).created_by := OKC_API.G_MISS_NUM;
2183: l_strm_lvl_tbl_in(1).creation_date := SYSDATE;
2184: l_strm_lvl_tbl_in(1).last_updated_by := OKC_API.G_MISS_NUM;
2185: l_strm_lvl_tbl_in(1).last_update_date := SYSDATE;

Line 2182: l_strm_lvl_tbl_in(1).created_by := OKC_API.G_MISS_NUM;

2178: l_strm_lvl_tbl_in(1).interface_offset_days := p_strm_lvl_tbl(l_tbl_count).interface_offset_days;
2179:
2180:
2181: l_strm_lvl_tbl_in(1).object_version_number := OKC_API.G_MISS_NUM;
2182: l_strm_lvl_tbl_in(1).created_by := OKC_API.G_MISS_NUM;
2183: l_strm_lvl_tbl_in(1).creation_date := SYSDATE;
2184: l_strm_lvl_tbl_in(1).last_updated_by := OKC_API.G_MISS_NUM;
2185: l_strm_lvl_tbl_in(1).last_update_date := SYSDATE;
2186:

Line 2184: l_strm_lvl_tbl_in(1).last_updated_by := OKC_API.G_MISS_NUM;

2180:
2181: l_strm_lvl_tbl_in(1).object_version_number := OKC_API.G_MISS_NUM;
2182: l_strm_lvl_tbl_in(1).created_by := OKC_API.G_MISS_NUM;
2183: l_strm_lvl_tbl_in(1).creation_date := SYSDATE;
2184: l_strm_lvl_tbl_in(1).last_updated_by := OKC_API.G_MISS_NUM;
2185: l_strm_lvl_tbl_in(1).last_update_date := SYSDATE;
2186:
2187:
2188:

Line 2233: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

2229: -----errorout_ad('SllCREATED : '|| x_return_status);
2230: -----errorout_ad('sll id = ' || l_strm_lvl_tbl_in(1));
2231:
2232:
2233: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2234: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2235: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2236: RAISE OKC_API.G_EXCEPTION_ERROR;
2237: END IF;

Line 2234: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2230: -----errorout_ad('sll id = ' || l_strm_lvl_tbl_in(1));
2231:
2232:
2233: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2234: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2235: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2236: RAISE OKC_API.G_EXCEPTION_ERROR;
2237: END IF;
2238:

Line 2235: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

2231:
2232:
2233: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2234: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2235: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2236: RAISE OKC_API.G_EXCEPTION_ERROR;
2237: END IF;
2238:
2239: ELSE --sll id not null

Line 2236: RAISE OKC_API.G_EXCEPTION_ERROR;

2232:
2233: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2234: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2235: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2236: RAISE OKC_API.G_EXCEPTION_ERROR;
2237: END IF;
2238:
2239: ELSE --sll id not null
2240: l_strm_lvl_tbl_in(1).id := l_sll_id;

Line 2261: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

2257:
2258: -----errorout_ad('STREAM LEVEL RULE updated : '|| x_return_status);
2259:
2260:
2261: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2262: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2263: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2264: RAISE OKC_API.G_EXCEPTION_ERROR;
2265: END IF;

Line 2262: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2258: -----errorout_ad('STREAM LEVEL RULE updated : '|| x_return_status);
2259:
2260:
2261: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2262: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2263: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2264: RAISE OKC_API.G_EXCEPTION_ERROR;
2265: END IF;
2266:

Line 2263: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

2259:
2260:
2261: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2262: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2263: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2264: RAISE OKC_API.G_EXCEPTION_ERROR;
2265: END IF;
2266:
2267: END IF;

Line 2264: RAISE OKC_API.G_EXCEPTION_ERROR;

2260:
2261: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2262: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2263: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2264: RAISE OKC_API.G_EXCEPTION_ERROR;
2265: END IF;
2266:
2267: END IF;
2268:

Line 2344: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

2340:
2341: -----errorout_ad ('Get_sll_amount STATUS = ' || x_return_status);
2342:
2343:
2344: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2345: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2346: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2347: RAISE OKC_API.G_EXCEPTION_ERROR;
2348: END IF;

Line 2345: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2341: -----errorout_ad ('Get_sll_amount STATUS = ' || x_return_status);
2342:
2343:
2344: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2345: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2346: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2347: RAISE OKC_API.G_EXCEPTION_ERROR;
2348: END IF;
2349:

Line 2346: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

2342:
2343:
2344: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2345: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2346: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2347: RAISE OKC_API.G_EXCEPTION_ERROR;
2348: END IF;
2349:
2350: FOR l_index IN l_sll_prorate_tbl.FIRST .. l_sll_prorate_tbl.LAST

Line 2347: RAISE OKC_API.G_EXCEPTION_ERROR;

2343:
2344: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2345: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2346: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2347: RAISE OKC_API.G_EXCEPTION_ERROR;
2348: END IF;
2349:
2350: FOR l_index IN l_sll_prorate_tbl.FIRST .. l_sll_prorate_tbl.LAST
2351: LOOP

Line 2377: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,

2373: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.Create_Stream_Level.UNEXPECTED',
2374: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
2375: END IF;
2376:
2377: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
2378: p_msg_name => G_UNEXPECTED_ERROR,
2379: p_token1 => G_SQLCODE_TOKEN,
2380: p_token1_value => sqlcode,
2381: p_token2 => G_SQLERRM_TOKEN,

Line 2521: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

2517: END IF;
2518:
2519: -------------errorout_ad('SLL Record FOR SUBLINE = ' || TO_CHAR(l_cp_sll_out_tbl.count));
2520: ----if l_cp_sll_out_tbl.count > 0 then insert lines into oks_level_elements_v
2521: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
2522: RAISE G_EXCEPTION_HALT_VALIDATION;
2523: END IF;
2524:
2525:

Line 2551: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

2547: 'Create_cp_lvl_elements(x_return_status = '||x_return_status
2548: ||', p_term_dt passed = '|| p_term_dt ||')');
2549: END IF;
2550:
2551: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
2552: RAISE G_EXCEPTION_HALT_VALIDATION;
2553: END IF;
2554:
2555: EXCEPTION

Line 2562: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

2558: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.bill_sch_cp.EXCEPTION',
2559: 'G_EXCEPTION_HALT_VALIDATION');
2560: END IF;
2561:
2562: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2563: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2564: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2565: RAISE OKC_API.G_EXCEPTION_ERROR;
2566: END IF;

Line 2563: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2559: 'G_EXCEPTION_HALT_VALIDATION');
2560: END IF;
2561:
2562: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2563: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2564: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2565: RAISE OKC_API.G_EXCEPTION_ERROR;
2566: END IF;
2567: WHEN OTHERS THEN

Line 2564: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

2560: END IF;
2561:
2562: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2563: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2564: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2565: RAISE OKC_API.G_EXCEPTION_ERROR;
2566: END IF;
2567: WHEN OTHERS THEN
2568:

Line 2565: RAISE OKC_API.G_EXCEPTION_ERROR;

2561:
2562: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2563: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2564: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2565: RAISE OKC_API.G_EXCEPTION_ERROR;
2566: END IF;
2567: WHEN OTHERS THEN
2568:
2569: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN

Line 2574: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,

2570: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.bill_sch_Cp.UNEXPECTED',
2571: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
2572: END IF;
2573:
2574: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
2575: p_msg_name => G_UNEXPECTED_ERROR,
2576: p_token1 => G_SQLCODE_TOKEN,
2577: p_token1_value => sqlcode,
2578: p_token2 => G_SQLERRM_TOKEN,

Line 3112: l_init_msg_list VARCHAR2(2000) := OKC_API.G_FALSE;

3108: l_last_cmp_date DATE;
3109: --------------------------------------------------------------------------
3110: --
3111: l_api_version CONSTANT NUMBER := 1.0;
3112: l_init_msg_list VARCHAR2(2000) := OKC_API.G_FALSE;
3113: l_return_status VARCHAR2(10);
3114: l_msg_count NUMBER;
3115: l_msg_data VARCHAR2(2000);
3116: l_msg_index_out NUMBER;

Line 3190: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

3186: END IF;
3187:
3188: -----errorout_ad('Delete_lvl_element status = ' || x_return_status);
3189:
3190: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3191: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3192: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3193: RAISE OKC_API.G_EXCEPTION_ERROR;
3194: END IF;

Line 3191: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

3187:
3188: -----errorout_ad('Delete_lvl_element status = ' || x_return_status);
3189:
3190: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3191: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3192: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3193: RAISE OKC_API.G_EXCEPTION_ERROR;
3194: END IF;
3195: END IF;

Line 3192: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

3188: -----errorout_ad('Delete_lvl_element status = ' || x_return_status);
3189:
3190: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3191: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3192: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3193: RAISE OKC_API.G_EXCEPTION_ERROR;
3194: END IF;
3195: END IF;
3196:

Line 3193: RAISE OKC_API.G_EXCEPTION_ERROR;

3189:
3190: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3191: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3192: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3193: RAISE OKC_API.G_EXCEPTION_ERROR;
3194: END IF;
3195: END IF;
3196:
3197: ---if (line terminated - 1) < line_start_dt

Line 3239: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

3235:
3236: -----errorout_ad('LEVEL ELEMENT COUNTER = ' || TO_CHAR(l_period_counter));
3237: -----errorout_ad('LEVEL ELEMENT START DATE = ' || to_char(l_next_cycle_dt));
3238:
3239: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3240: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3241: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3242: RAISE OKC_API.G_EXCEPTION_ERROR;
3243: END IF;

Line 3240: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

3236: -----errorout_ad('LEVEL ELEMENT COUNTER = ' || TO_CHAR(l_period_counter));
3237: -----errorout_ad('LEVEL ELEMENT START DATE = ' || to_char(l_next_cycle_dt));
3238:
3239: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3240: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3241: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3242: RAISE OKC_API.G_EXCEPTION_ERROR;
3243: END IF;
3244: l_lvl_loop_counter := l_period_counter;

Line 3241: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

3237: -----errorout_ad('LEVEL ELEMENT START DATE = ' || to_char(l_next_cycle_dt));
3238:
3239: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3240: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3241: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3242: RAISE OKC_API.G_EXCEPTION_ERROR;
3243: END IF;
3244: l_lvl_loop_counter := l_period_counter;
3245: END IF;

Line 3242: RAISE OKC_API.G_EXCEPTION_ERROR;

3238:
3239: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3240: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3241: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3242: RAISE OKC_API.G_EXCEPTION_ERROR;
3243: END IF;
3244: l_lvl_loop_counter := l_period_counter;
3245: END IF;
3246:

Line 3309: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

3305: ||', x_timeunit = ' || l_tce_code
3306: ||', x_quantity = '|| l_uom_quantity ||')');
3307: END IF;
3308:
3309: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
3310: RAISE G_EXCEPTION_HALT_VALIDATION;
3311: END IF;
3312:
3313: l_remaining_amt := nvl(l_line_amt,0) - nvl(l_bill_sch_amt,0);

Line 3334: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

3330: ||', sll amt = ' || l_constant_sll_amt
3331: ||', l_remaining_amt passed = '|| l_remaining_amt ||')');
3332: END IF;
3333:
3334: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
3335: RAISE G_EXCEPTION_HALT_VALIDATION;
3336: END IF;
3337: END IF; ---end of lse_id = 46
3338:

Line 3414: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

3410:
3411:
3412: -----errorout_ad('LEVEL ELEMENT NEXT CYCLE DATE passed from Get_next_bill_sch = ' || TO_CHAR(l_fnd_lvl_out_rec.next_cycle_date));
3413:
3414: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3415: -----errorout_ad(' OKS_BILL_UTIL_PUB.Get_next_bill_sch = ' || l_msg_data);
3416: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3417: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3418: -----errorout_ad(' OKS_BILL_UTIL_PUB.Get_next_bill_sch = ' || l_msg_data);

Line 3416: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

3412: -----errorout_ad('LEVEL ELEMENT NEXT CYCLE DATE passed from Get_next_bill_sch = ' || TO_CHAR(l_fnd_lvl_out_rec.next_cycle_date));
3413:
3414: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3415: -----errorout_ad(' OKS_BILL_UTIL_PUB.Get_next_bill_sch = ' || l_msg_data);
3416: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3417: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3418: -----errorout_ad(' OKS_BILL_UTIL_PUB.Get_next_bill_sch = ' || l_msg_data);
3419: RAISE OKC_API.G_EXCEPTION_ERROR;
3420: END IF;

Line 3417: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

3413:
3414: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3415: -----errorout_ad(' OKS_BILL_UTIL_PUB.Get_next_bill_sch = ' || l_msg_data);
3416: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3417: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3418: -----errorout_ad(' OKS_BILL_UTIL_PUB.Get_next_bill_sch = ' || l_msg_data);
3419: RAISE OKC_API.G_EXCEPTION_ERROR;
3420: END IF;
3421:

Line 3419: RAISE OKC_API.G_EXCEPTION_ERROR;

3415: -----errorout_ad(' OKS_BILL_UTIL_PUB.Get_next_bill_sch = ' || l_msg_data);
3416: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3417: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3418: -----errorout_ad(' OKS_BILL_UTIL_PUB.Get_next_bill_sch = ' || l_msg_data);
3419: RAISE OKC_API.G_EXCEPTION_ERROR;
3420: END IF;
3421:
3422:
3423: IF p_period_start is not null AND

Line 3568: l_lvl_ele_tbl_in(l_tbl_seq).object_version_number := OKC_API.G_MISS_NUM;

3564: end if;
3565:
3566: l_lvl_ele_tbl_in(l_tbl_seq).rul_id := p_sll_tbl(l_line_sll_counter).id;
3567:
3568: l_lvl_ele_tbl_in(l_tbl_seq).object_version_number := OKC_API.G_MISS_NUM;
3569: l_lvl_ele_tbl_in(l_tbl_seq).created_by := OKC_API.G_MISS_NUM;
3570: l_lvl_ele_tbl_in(l_tbl_seq).creation_date := SYSDATE;
3571: l_lvl_ele_tbl_in(l_tbl_seq).last_updated_by := OKC_API.G_MISS_NUM;
3572: l_lvl_ele_tbl_in(l_tbl_seq).last_update_date := SYSDATE;

Line 3569: l_lvl_ele_tbl_in(l_tbl_seq).created_by := OKC_API.G_MISS_NUM;

3565:
3566: l_lvl_ele_tbl_in(l_tbl_seq).rul_id := p_sll_tbl(l_line_sll_counter).id;
3567:
3568: l_lvl_ele_tbl_in(l_tbl_seq).object_version_number := OKC_API.G_MISS_NUM;
3569: l_lvl_ele_tbl_in(l_tbl_seq).created_by := OKC_API.G_MISS_NUM;
3570: l_lvl_ele_tbl_in(l_tbl_seq).creation_date := SYSDATE;
3571: l_lvl_ele_tbl_in(l_tbl_seq).last_updated_by := OKC_API.G_MISS_NUM;
3572: l_lvl_ele_tbl_in(l_tbl_seq).last_update_date := SYSDATE;
3573:

Line 3571: l_lvl_ele_tbl_in(l_tbl_seq).last_updated_by := OKC_API.G_MISS_NUM;

3567:
3568: l_lvl_ele_tbl_in(l_tbl_seq).object_version_number := OKC_API.G_MISS_NUM;
3569: l_lvl_ele_tbl_in(l_tbl_seq).created_by := OKC_API.G_MISS_NUM;
3570: l_lvl_ele_tbl_in(l_tbl_seq).creation_date := SYSDATE;
3571: l_lvl_ele_tbl_in(l_tbl_seq).last_updated_by := OKC_API.G_MISS_NUM;
3572: l_lvl_ele_tbl_in(l_tbl_seq).last_update_date := SYSDATE;
3573:
3574:
3575: -----errorout_ad ('Amount for line lvl element = ' || to_char(l_lvl_ele_tbl_in(l_tbl_seq).amount ));

Line 3679: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

3675:
3676: -----errorout_ad('LEVEL ELEMENT INSERT STATUS line = ' || x_return_status);
3677:
3678:
3679: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3680: -----errorout_ad('OKS_BILL_LEVEL_ELEMENTS_PVT.insert_row for line = ' || l_msg_data);
3681: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3682: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3683: -----errorout_ad('OKS_BILL_LEVEL_ELEMENTS_PVT.insert_row for line = ' || l_msg_data);

Line 3681: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

3677:
3678:
3679: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3680: -----errorout_ad('OKS_BILL_LEVEL_ELEMENTS_PVT.insert_row for line = ' || l_msg_data);
3681: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3682: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3683: -----errorout_ad('OKS_BILL_LEVEL_ELEMENTS_PVT.insert_row for line = ' || l_msg_data);
3684: RAISE OKC_API.G_EXCEPTION_ERROR;
3685: END IF;

Line 3682: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

3678:
3679: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3680: -----errorout_ad('OKS_BILL_LEVEL_ELEMENTS_PVT.insert_row for line = ' || l_msg_data);
3681: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3682: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3683: -----errorout_ad('OKS_BILL_LEVEL_ELEMENTS_PVT.insert_row for line = ' || l_msg_data);
3684: RAISE OKC_API.G_EXCEPTION_ERROR;
3685: END IF;
3686: END IF;

Line 3684: RAISE OKC_API.G_EXCEPTION_ERROR;

3680: -----errorout_ad('OKS_BILL_LEVEL_ELEMENTS_PVT.insert_row for line = ' || l_msg_data);
3681: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3682: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3683: -----errorout_ad('OKS_BILL_LEVEL_ELEMENTS_PVT.insert_row for line = ' || l_msg_data);
3684: RAISE OKC_API.G_EXCEPTION_ERROR;
3685: END IF;
3686: END IF;
3687:
3688:

Line 3698: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,

3694: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN
3695: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.Create_Level_elements.UNEXPECTED',
3696: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
3697: END IF;
3698: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
3699: p_msg_name => G_UNEXPECTED_ERROR,
3700: p_token1 => G_SQLCODE_TOKEN,
3701: p_token1_value => sqlcode,
3702: p_token2 => G_SQLERRM_TOKEN,

Line 3736: l_init_msg_list VARCHAR2(2000) := OKC_API.G_FALSE;

3732: l_bill_type VARCHAR2(10);
3733:
3734: --
3735: l_api_version CONSTANT NUMBER := 1.0;
3736: l_init_msg_list VARCHAR2(2000) := OKC_API.G_FALSE;
3737: l_return_status VARCHAR2(10);
3738: l_msg_count NUMBER;
3739: l_msg_data VARCHAR2(2000);
3740: l_msg_index_out NUMBER;

Line 3774: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

3770: ||', p_hdr_id passed = '||p_hdr_rec.id ||')');
3771: END IF;
3772:
3773: -----errorout_ad('Del_hdr_lvl_element status = ' || x_return_status);
3774: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3775: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3776: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3777: RAISE OKC_API.G_EXCEPTION_ERROR;
3778: END IF;

Line 3775: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

3771: END IF;
3772:
3773: -----errorout_ad('Del_hdr_lvl_element status = ' || x_return_status);
3774: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3775: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3776: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3777: RAISE OKC_API.G_EXCEPTION_ERROR;
3778: END IF;
3779: END IF;

Line 3776: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

3772:
3773: -----errorout_ad('Del_hdr_lvl_element status = ' || x_return_status);
3774: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3775: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3776: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3777: RAISE OKC_API.G_EXCEPTION_ERROR;
3778: END IF;
3779: END IF;
3780:

Line 3777: RAISE OKC_API.G_EXCEPTION_ERROR;

3773: -----errorout_ad('Del_hdr_lvl_element status = ' || x_return_status);
3774: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3775: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3776: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3777: RAISE OKC_API.G_EXCEPTION_ERROR;
3778: END IF;
3779: END IF;
3780:
3781:

Line 3841: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

3837: END IF;
3838:
3839: -----errorout_ad('hdr Get_next_bill_sch status = ' || x_return_status);
3840:
3841: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3842: -----errorout_ad(' OKS_BILL_UTIL_PUB.Get_next_bill_sch = ' || l_fnd_msg_data);
3843: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3844: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3845: -----errorout_ad(' OKS_BILL_UTIL_PUB.Get_next_bill_sch = ' || l_fnd_msg_data);

Line 3843: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

3839: -----errorout_ad('hdr Get_next_bill_sch status = ' || x_return_status);
3840:
3841: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3842: -----errorout_ad(' OKS_BILL_UTIL_PUB.Get_next_bill_sch = ' || l_fnd_msg_data);
3843: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3844: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3845: -----errorout_ad(' OKS_BILL_UTIL_PUB.Get_next_bill_sch = ' || l_fnd_msg_data);
3846: RAISE OKC_API.G_EXCEPTION_ERROR;
3847: END IF;

Line 3844: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

3840:
3841: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3842: -----errorout_ad(' OKS_BILL_UTIL_PUB.Get_next_bill_sch = ' || l_fnd_msg_data);
3843: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3844: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3845: -----errorout_ad(' OKS_BILL_UTIL_PUB.Get_next_bill_sch = ' || l_fnd_msg_data);
3846: RAISE OKC_API.G_EXCEPTION_ERROR;
3847: END IF;
3848:

Line 3846: RAISE OKC_API.G_EXCEPTION_ERROR;

3842: -----errorout_ad(' OKS_BILL_UTIL_PUB.Get_next_bill_sch = ' || l_fnd_msg_data);
3843: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3844: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3845: -----errorout_ad(' OKS_BILL_UTIL_PUB.Get_next_bill_sch = ' || l_fnd_msg_data);
3846: RAISE OKC_API.G_EXCEPTION_ERROR;
3847: END IF;
3848:
3849:
3850:

Line 3882: l_lvl_ele_tbl_in(l_tbl_seq).object_version_number := OKC_API.G_MISS_NUM;

3878: l_lvl_ele_tbl_in(l_tbl_seq).date_to_interface := TRUNC(l_fnd_lvl_out_rec.date_to_interface);
3879: l_lvl_ele_tbl_in(l_tbl_seq).date_completed := l_fnd_lvl_out_rec.date_completed;
3880: l_lvl_ele_tbl_in(l_tbl_seq).rul_id := p_sll_tbl(l_sll_counter).id;
3881:
3882: l_lvl_ele_tbl_in(l_tbl_seq).object_version_number := OKC_API.G_MISS_NUM;
3883: l_lvl_ele_tbl_in(l_tbl_seq).created_by := OKC_API.G_MISS_NUM;
3884: l_lvl_ele_tbl_in(l_tbl_seq).creation_date := SYSDATE;
3885: l_lvl_ele_tbl_in(l_tbl_seq).last_updated_by := OKC_API.G_MISS_NUM;
3886: l_lvl_ele_tbl_in(l_tbl_seq).last_update_date := SYSDATE;

Line 3883: l_lvl_ele_tbl_in(l_tbl_seq).created_by := OKC_API.G_MISS_NUM;

3879: l_lvl_ele_tbl_in(l_tbl_seq).date_completed := l_fnd_lvl_out_rec.date_completed;
3880: l_lvl_ele_tbl_in(l_tbl_seq).rul_id := p_sll_tbl(l_sll_counter).id;
3881:
3882: l_lvl_ele_tbl_in(l_tbl_seq).object_version_number := OKC_API.G_MISS_NUM;
3883: l_lvl_ele_tbl_in(l_tbl_seq).created_by := OKC_API.G_MISS_NUM;
3884: l_lvl_ele_tbl_in(l_tbl_seq).creation_date := SYSDATE;
3885: l_lvl_ele_tbl_in(l_tbl_seq).last_updated_by := OKC_API.G_MISS_NUM;
3886: l_lvl_ele_tbl_in(l_tbl_seq).last_update_date := SYSDATE;
3887:

Line 3885: l_lvl_ele_tbl_in(l_tbl_seq).last_updated_by := OKC_API.G_MISS_NUM;

3881:
3882: l_lvl_ele_tbl_in(l_tbl_seq).object_version_number := OKC_API.G_MISS_NUM;
3883: l_lvl_ele_tbl_in(l_tbl_seq).created_by := OKC_API.G_MISS_NUM;
3884: l_lvl_ele_tbl_in(l_tbl_seq).creation_date := SYSDATE;
3885: l_lvl_ele_tbl_in(l_tbl_seq).last_updated_by := OKC_API.G_MISS_NUM;
3886: l_lvl_ele_tbl_in(l_tbl_seq).last_update_date := SYSDATE;
3887:
3888: l_tbl_seq := l_tbl_seq + 1;
3889:

Line 3930: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

3926:
3927: -----errorout_ad('LEVEL ELEMENT INSERT STATUS = ' || x_return_status);
3928:
3929:
3930: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3931: -----errorout_ad('OKS_BILL_LEVEL_ELEMENTS_PVT.insert_row = ' || l__msg_data);
3932: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3933: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3934: -----errorout_ad('OKS_BILL_LEVEL_ELEMENTS_PVT.insert_row = ' || l_msg_data);

Line 3932: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

3928:
3929:
3930: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3931: -----errorout_ad('OKS_BILL_LEVEL_ELEMENTS_PVT.insert_row = ' || l__msg_data);
3932: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3933: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3934: -----errorout_ad('OKS_BILL_LEVEL_ELEMENTS_PVT.insert_row = ' || l_msg_data);
3935: RAISE OKC_API.G_EXCEPTION_ERROR;
3936: END IF;

Line 3933: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

3929:
3930: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3931: -----errorout_ad('OKS_BILL_LEVEL_ELEMENTS_PVT.insert_row = ' || l__msg_data);
3932: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3933: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3934: -----errorout_ad('OKS_BILL_LEVEL_ELEMENTS_PVT.insert_row = ' || l_msg_data);
3935: RAISE OKC_API.G_EXCEPTION_ERROR;
3936: END IF;
3937: END IF;

Line 3935: RAISE OKC_API.G_EXCEPTION_ERROR;

3931: -----errorout_ad('OKS_BILL_LEVEL_ELEMENTS_PVT.insert_row = ' || l__msg_data);
3932: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3933: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3934: -----errorout_ad('OKS_BILL_LEVEL_ELEMENTS_PVT.insert_row = ' || l_msg_data);
3935: RAISE OKC_API.G_EXCEPTION_ERROR;
3936: END IF;
3937: END IF;
3938:
3939:

Line 3947: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,

3943: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN
3944: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.create_hdr_level_elements.UNEXPECTED',
3945: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
3946: END IF;
3947: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
3948: p_msg_name => G_UNEXPECTED_ERROR,
3949: p_token1 => G_SQLCODE_TOKEN,
3950: p_token1_value => sqlcode,
3951: p_token2 => G_SQLERRM_TOKEN,

Line 4053: l_init_msg_list VARCHAR2(2000) := OKC_API.G_FALSE;

4049:
4050: l_return_status VARCHAR2(10);
4051: l_msg_count NUMBER;
4052: l_msg_data VARCHAR2(2000);
4053: l_init_msg_list VARCHAR2(2000) := OKC_API.G_FALSE;
4054:
4055: l_sll_prorate_tbl sll_prorated_tab_type;
4056: -------------------------------------------------------------------------
4057: -- Begin partial period computation logic

Line 4150: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'CURRENCY CODE NOT FOUND.');

4146: l_currency_code := Find_Currency_Code(
4147: p_cle_id => p_line_id,
4148: p_chr_id => NULL);
4149: IF l_currency_code IS NULL THEN
4150: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'CURRENCY CODE NOT FOUND.');
4151: x_return_status := 'E';
4152: RETURN;
4153: END IF;
4154: END IF; ---currency code null

Line 4203: l_strm_lvl_tbl_in(l_Sll_Counter).created_by := OKC_API.G_MISS_NUM;

4199: l_strm_lvl_tbl_in(l_Sll_Counter).invoice_offset_days := l_Line_Sll_Csr_Rec.invoice_offset_days;
4200: l_strm_lvl_tbl_in(l_Sll_Counter).interface_offset_days := l_Line_Sll_Csr_Rec.interface_offset_days;
4201: l_strm_lvl_tbl_in(l_Sll_Counter).object_version_number := l_Line_Sll_Csr_Rec.object_version_number;
4202:
4203: l_strm_lvl_tbl_in(l_Sll_Counter).created_by := OKC_API.G_MISS_NUM;
4204: l_strm_lvl_tbl_in(l_Sll_Counter).creation_date := SYSDATE;
4205: l_strm_lvl_tbl_in(l_Sll_Counter).last_updated_by := OKC_API.G_MISS_NUM;
4206: l_strm_lvl_tbl_in(l_Sll_Counter).last_update_date := SYSDATE;
4207:

Line 4205: l_strm_lvl_tbl_in(l_Sll_Counter).last_updated_by := OKC_API.G_MISS_NUM;

4201: l_strm_lvl_tbl_in(l_Sll_Counter).object_version_number := l_Line_Sll_Csr_Rec.object_version_number;
4202:
4203: l_strm_lvl_tbl_in(l_Sll_Counter).created_by := OKC_API.G_MISS_NUM;
4204: l_strm_lvl_tbl_in(l_Sll_Counter).creation_date := SYSDATE;
4205: l_strm_lvl_tbl_in(l_Sll_Counter).last_updated_by := OKC_API.G_MISS_NUM;
4206: l_strm_lvl_tbl_in(l_Sll_Counter).last_update_date := SYSDATE;
4207:
4208:
4209: l_Sll_Counter := l_Sll_Counter + 1;

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

4233:
4234: -----errorout_ad ('Get_sll_amount STATUS = ' || x_return_status);
4235:
4236:
4237: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4238: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4239: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4240: RAISE OKC_API.G_EXCEPTION_ERROR;
4241: END IF;

Line 4238: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

4234: -----errorout_ad ('Get_sll_amount STATUS = ' || x_return_status);
4235:
4236:
4237: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4238: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4239: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4240: RAISE OKC_API.G_EXCEPTION_ERROR;
4241: END IF;
4242:

Line 4239: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

4235:
4236:
4237: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4238: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4239: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4240: RAISE OKC_API.G_EXCEPTION_ERROR;
4241: END IF;
4242:
4243: ---- the output table has index number of sll table to be updated in sll_seq_num field,

Line 4240: RAISE OKC_API.G_EXCEPTION_ERROR;

4236:
4237: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4238: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4239: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4240: RAISE OKC_API.G_EXCEPTION_ERROR;
4241: END IF;
4242:
4243: ---- the output table has index number of sll table to be updated in sll_seq_num field,
4244: ----so just change the amount for the l_rulv_index .

Line 4295: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,

4291: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN
4292: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.update_sll_amount.UNEXPECTED',
4293: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
4294: END IF;
4295: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
4296: p_msg_name => G_UNEXPECTED_ERROR,
4297: p_token1 => G_SQLCODE_TOKEN,
4298: p_token1_value => sqlcode,
4299: p_token2 => G_SQLERRM_TOKEN,

Line 4302: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

4298: p_token1_value => sqlcode,
4299: p_token2 => G_SQLERRM_TOKEN,
4300: p_token2_value => sqlerrm);
4301:
4302: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
4303:
4304: END Update_Sll_Amount;
4305:
4306: PROCEDURE Calculate_sll_amount( p_api_version IN NUMBER,

Line 4580: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,

4576:
4577:
4578: EXCEPTION
4579: WHEN OTHERS THEN
4580: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
4581: p_msg_name => G_UNEXPECTED_ERROR,
4582: p_token1 => G_SQLCODE_TOKEN,
4583: p_token1_value => sqlcode,
4584: p_token2 => G_SQLERRM_TOKEN,

Line 4587: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

4583: p_token1_value => sqlcode,
4584: p_token2 => G_SQLERRM_TOKEN,
4585: p_token2_value => sqlerrm);
4586:
4587: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
4588:
4589: END Delete_lvl_element;
4590:
4591:

Line 4620: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,

4616: AND chr_id IS NULL;
4617:
4618: EXCEPTION
4619: WHEN OTHERS THEN
4620: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
4621: p_msg_name => G_UNEXPECTED_ERROR,
4622: p_token1 => G_SQLCODE_TOKEN,
4623: p_token1_value => sqlcode,
4624: p_token2 => G_SQLERRM_TOKEN,

Line 4627: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

4623: p_token1_value => sqlcode,
4624: p_token2 => G_SQLERRM_TOKEN,
4625: p_token2_value => sqlerrm);
4626:
4627: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
4628:
4629: END Del_hdr_lvl_element;
4630:
4631:

Line 4672: l_init_msg_list VARCHAR2(2000) := OKC_API.G_FALSE;

4668:
4669: l_return_status VARCHAR2(10);
4670: l_msg_count NUMBER;
4671: l_msg_data VARCHAR2(2000);
4672: l_init_msg_list VARCHAR2(2000) := OKC_API.G_FALSE;
4673:
4674: l_sll_prorate_tbl sll_prorated_tab_type;
4675: -------------------------------------------------------------------------
4676: -- Begin partial period computation logic

Line 4732: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'CURRENCY CODE NOT FOUND.');

4728: p_cle_id => NULL,
4729: p_chr_id => p_hdr_id);
4730:
4731: IF l_currency_code IS NULL THEN
4732: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'CURRENCY CODE NOT FOUND.');
4733: x_return_status := 'E';
4734: RETURN;
4735: END IF;
4736: END IF;

Line 4792: l_strm_lvl_tbl_in(l_Sll_Counter).created_by := OKC_API.G_MISS_NUM;

4788: l_strm_lvl_tbl_in(l_Sll_Counter).invoice_offset_days := l_Sll_Csr_Rec.invoice_offset_days;
4789: l_strm_lvl_tbl_in(l_Sll_Counter).interface_offset_days := l_Sll_Csr_Rec.interface_offset_days;
4790: l_strm_lvl_tbl_in(l_Sll_Counter).object_version_number := l_Sll_Csr_Rec.object_version_number;
4791:
4792: l_strm_lvl_tbl_in(l_Sll_Counter).created_by := OKC_API.G_MISS_NUM;
4793: l_strm_lvl_tbl_in(l_Sll_Counter).creation_date := SYSDATE;
4794: l_strm_lvl_tbl_in(l_Sll_Counter).last_updated_by := OKC_API.G_MISS_NUM;
4795: l_strm_lvl_tbl_in(l_Sll_Counter).last_update_date := SYSDATE;
4796:

Line 4794: l_strm_lvl_tbl_in(l_Sll_Counter).last_updated_by := OKC_API.G_MISS_NUM;

4790: l_strm_lvl_tbl_in(l_Sll_Counter).object_version_number := l_Sll_Csr_Rec.object_version_number;
4791:
4792: l_strm_lvl_tbl_in(l_Sll_Counter).created_by := OKC_API.G_MISS_NUM;
4793: l_strm_lvl_tbl_in(l_Sll_Counter).creation_date := SYSDATE;
4794: l_strm_lvl_tbl_in(l_Sll_Counter).last_updated_by := OKC_API.G_MISS_NUM;
4795: l_strm_lvl_tbl_in(l_Sll_Counter).last_update_date := SYSDATE;
4796:
4797: l_Sll_Counter := l_Sll_Counter + 1;
4798:

Line 4825: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

4821:
4822: -----errorout_ad ('Get_sll_amount STATUS = ' || x_return_status);
4823:
4824:
4825: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4826: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4827: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
4828: RAISE OKC_API.G_EXCEPTION_ERROR;
4829: END IF;

Line 4826: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

4822: -----errorout_ad ('Get_sll_amount STATUS = ' || x_return_status);
4823:
4824:
4825: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4826: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4827: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
4828: RAISE OKC_API.G_EXCEPTION_ERROR;
4829: END IF;
4830:

Line 4827: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

4823:
4824:
4825: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4826: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4827: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
4828: RAISE OKC_API.G_EXCEPTION_ERROR;
4829: END IF;
4830:
4831: ---- the output table has index number of sll rule table to be updated in sll_seq_num field,

Line 4828: RAISE OKC_API.G_EXCEPTION_ERROR;

4824:
4825: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4826: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4827: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
4828: RAISE OKC_API.G_EXCEPTION_ERROR;
4829: END IF;
4830:
4831: ---- the output table has index number of sll rule table to be updated in sll_seq_num field,
4832: ----so just change the amount for the l_rulv_index .

Line 4870: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,

4866:
4867:
4868: EXCEPTION
4869: WHEN OTHERS THEN
4870: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
4871: p_msg_name => G_UNEXPECTED_ERROR,
4872: p_token1 => G_SQLCODE_TOKEN,
4873: p_token1_value => sqlcode,
4874: p_token2 => G_SQLERRM_TOKEN,

Line 4877: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

4873: p_token1_value => sqlcode,
4874: p_token2 => G_SQLERRM_TOKEN,
4875: p_token2_value => sqlerrm);
4876:
4877: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
4878:
4879: END Cal_hdr_Sll_Amount;
4880:
4881: PROCEDURE Get_Constant_sll_Amount(p_line_start_date IN DATE,

Line 4894: x_return_status := OKC_API.G_RET_STS_SUCCESS;

4890:
4891: l_frequency NUMBER;
4892:
4893: BEGIN
4894: x_return_status := OKC_API.G_RET_STS_SUCCESS;
4895: -----errorout_ad('p_tce_code = ' || p_tce_code);
4896: -----errorout_ad('p_uom_quantity = ' || p_uom_quantity);
4897:
4898: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 4933: If x_return_status <> OKC_API.G_RET_STS_SUCCESS Then

4929: 'oks_bill_util_pub.get_frequency(x_return_status = '||x_return_status
4930: ||', l_frequency = '|| l_frequency ||')');
4931: END IF;
4932:
4933: If x_return_status <> OKC_API.G_RET_STS_SUCCESS Then
4934: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'GET_FREQUENCY FAILED.');
4935: x_return_status := OKC_API.G_RET_STS_ERROR;
4936: RETURN;
4937: End if;

Line 4934: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'GET_FREQUENCY FAILED.');

4930: ||', l_frequency = '|| l_frequency ||')');
4931: END IF;
4932:
4933: If x_return_status <> OKC_API.G_RET_STS_SUCCESS Then
4934: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'GET_FREQUENCY FAILED.');
4935: x_return_status := OKC_API.G_RET_STS_ERROR;
4936: RETURN;
4937: End if;
4938:

Line 4935: x_return_status := OKC_API.G_RET_STS_ERROR;

4931: END IF;
4932:
4933: If x_return_status <> OKC_API.G_RET_STS_SUCCESS Then
4934: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'GET_FREQUENCY FAILED.');
4935: x_return_status := OKC_API.G_RET_STS_ERROR;
4936: RETURN;
4937: End if;
4938:
4939: -----errorout_ad('p_remaining_amount = ' || p_remaining_amount);

Line 4952: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,

4948: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN
4949: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.get_constant_sll_amount.UNEXPECTED',
4950: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
4951: END IF;
4952: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
4953: p_msg_name => G_UNEXPECTED_ERROR,
4954: p_token1 => G_SQLCODE_TOKEN,
4955: p_token1_value => sqlcode,
4956: p_token2 => G_SQLERRM_TOKEN,

Line 4975: x_return_status := OKC_API.G_RET_STS_SUCCESS;

4971: x_return_status OUT NOCOPY VARCHAR2)
4972: IS
4973:
4974: BEGIN
4975: x_return_status := OKC_API.G_RET_STS_SUCCESS;
4976: If p_line_start_date > p_cycle_start_date and p_line_start_date < P_next_billing_date Then
4977: x_period_freq := OKS_BILL_UTIL_PUB.get_frequency
4978: (p_tce_code => p_tce_code,
4979: p_fr_start_date => p_line_start_date,

Line 5005: If x_return_status <> OKC_API.G_RET_STS_SUCCESS Then

5001: 'oks_bill_util_pub.get_frequency(x_return_status = '||x_return_status
5002: ||', x_period_freq = '|| x_period_freq ||')');
5003: END IF;
5004:
5005: If x_return_status <> OKC_API.G_RET_STS_SUCCESS Then
5006: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'GET_FREQUENCY FAILED.');
5007: x_return_status := OKC_API.G_RET_STS_ERROR;
5008: RETURN;
5009: End if;

Line 5006: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'GET_FREQUENCY FAILED.');

5002: ||', x_period_freq = '|| x_period_freq ||')');
5003: END IF;
5004:
5005: If x_return_status <> OKC_API.G_RET_STS_SUCCESS Then
5006: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'GET_FREQUENCY FAILED.');
5007: x_return_status := OKC_API.G_RET_STS_ERROR;
5008: RETURN;
5009: End if;
5010:

Line 5007: x_return_status := OKC_API.G_RET_STS_ERROR;

5003: END IF;
5004:
5005: If x_return_status <> OKC_API.G_RET_STS_SUCCESS Then
5006: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'GET_FREQUENCY FAILED.');
5007: x_return_status := OKC_API.G_RET_STS_ERROR;
5008: RETURN;
5009: End if;
5010:
5011: EXCEPTION

Line 5018: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,

5014: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN
5015: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.get_period_frequency.UNEXPECTED',
5016: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
5017: END IF;
5018: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
5019: p_msg_name => G_UNEXPECTED_ERROR,
5020: p_token1 => G_SQLCODE_TOKEN,
5021: p_token1_value => sqlcode,
5022: p_token2 => G_SQLERRM_TOKEN,

Line 5045: x_return_status := OKC_API.G_RET_STS_SUCCESS;

5041: l_sll_amt NUMBER := 0;
5042:
5043: BEGIN
5044:
5045: x_return_status := OKC_API.G_RET_STS_SUCCESS;
5046:
5047: SELECT NVL(SUM(AMOUNT),0) INTO l_sll_amt
5048: FROM OKS_LEVEL_ELEMENTS
5049: WHERE rul_id = p_Sll_id;

Line 5119: l_init_msg_list VARCHAR2(2000) := OKC_API.G_FALSE;

5115: where line.id = p_id;
5116:
5117:
5118: l_index NUMBER;
5119: l_init_msg_list VARCHAR2(2000) := OKC_API.G_FALSE;
5120:
5121: l_Line_Sll_rec l_Line_Sll_Csr%ROWTYPE;
5122: l_line_BS_rec l_line_BS_csr%ROWTYPE;
5123: l_Line_Csr_Rec l_Line_Csr%Rowtype;

Line 5157: x_return_status := OKC_API.G_RET_STS_SUCCESS;

5153:
5154: ---this is called for the new cp or existing cp which is updated and only for 'T'.
5155: --p_cp_new is 'Y' for new subline, 'N' for updating schedule for existing subline
5156:
5157: x_return_status := OKC_API.G_RET_STS_SUCCESS;
5158: l_update_required := 'N';
5159:
5160: ---get line details
5161: Open l_Line_Csr;

Line 5171: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'LINE NOT FOUND');

5167: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.create_bill_sch_cp.EXCEPTION',
5168: 'top line not found = ' || p_top_line_id );
5169: END IF;
5170: x_return_status := 'E';
5171: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'LINE NOT FOUND');
5172: RAISE G_EXCEPTION_HALT_VALIDATION;
5173: End If;
5174: Close l_Line_Csr;
5175:

Line 5334: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'CURRENCY CODE NOT FOUND.');

5330: p_cle_id => p_top_line_id,
5331: p_chr_id => NULL);
5332:
5333: IF l_currency_code IS NULL THEN
5334: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'CURRENCY CODE NOT FOUND.');
5335: x_return_status := 'E';
5336: RAISE G_EXCEPTION_HALT_VALIDATION;
5337: END IF;
5338:

Line 5345: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'SUB LINE NOT FOUND');

5341: FETCH l_SubLine_Csr Into l_SubLine_Rec;
5342: If l_SubLine_Csr%Notfound then
5343: Close l_SubLine_Csr;
5344: x_return_status := 'E';
5345: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'SUB LINE NOT FOUND');
5346: RAISE G_EXCEPTION_HALT_VALIDATION;
5347: End If;
5348: Close l_SubLine_Csr;
5349:

Line 5531: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

5527: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.create_bill_sch_cp.EXCEPTION',
5528: 'G_EXCEPTION_HALT_VALIDATION');
5529: END IF;
5530:
5531: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5532: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5533: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
5534: RAISE OKC_API.G_EXCEPTION_ERROR;
5535: END IF;

Line 5532: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

5528: 'G_EXCEPTION_HALT_VALIDATION');
5529: END IF;
5530:
5531: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5532: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5533: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
5534: RAISE OKC_API.G_EXCEPTION_ERROR;
5535: END IF;
5536: WHEN OTHERS THEN

Line 5533: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

5529: END IF;
5530:
5531: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5532: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5533: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
5534: RAISE OKC_API.G_EXCEPTION_ERROR;
5535: END IF;
5536: WHEN OTHERS THEN
5537: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN

Line 5534: RAISE OKC_API.G_EXCEPTION_ERROR;

5530:
5531: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5532: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5533: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
5534: RAISE OKC_API.G_EXCEPTION_ERROR;
5535: END IF;
5536: WHEN OTHERS THEN
5537: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN
5538: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.create_bill_sch_cp.UNEXPECTED',

Line 5541: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,

5537: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN
5538: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.create_bill_sch_cp.UNEXPECTED',
5539: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
5540: END IF;
5541: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
5542: p_msg_name => G_UNEXPECTED_ERROR,
5543: p_token1 => G_SQLCODE_TOKEN,
5544: p_token1_value => sqlcode,
5545: p_token2 => G_SQLERRM_TOKEN,

Line 5628: l_msg_list VARCHAR2(1) DEFAULT OKC_API.G_FALSE;

5624: l_sll_ind NUMBER;
5625: l_timeunit VARCHAR2(20);
5626: l_duration NUMBER;
5627: l_difference NUMBER;
5628: l_msg_list VARCHAR2(1) DEFAULT OKC_API.G_FALSE;
5629: L_UOM_QUANTITY number;
5630: l_tce_code VARCHAR2(100);
5631: l_update_end_date VARCHAR2(1);
5632: l_usage_type VARCHAR2(40);

Line 5651: x_return_status := OKC_API.G_RET_STS_SUCCESS;

5647: BEGIN
5648:
5649: --it adjusts the sll and lvl element according to new line start and end date.
5650:
5651: x_return_status := OKC_API.G_RET_STS_SUCCESS;
5652:
5653: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5654:
5655: fnd_log.STRING (fnd_log.level_statement,

Line 5671: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'LINE NOT FOUND');

5667:
5668: If l_Line_Csr%Notfound then
5669: Close l_Line_Csr;
5670: x_return_status := 'E';
5671: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'LINE NOT FOUND');
5672: RAISE G_EXCEPTION_HALT_VALIDATION;
5673: End If;
5674: Close l_Line_Csr;
5675:

Line 6034: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

6030: x_duration => l_duration,
6031: x_timeunit => l_timeunit,
6032: x_return_status => x_return_status);
6033:
6034: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
6035: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
6036: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
6037: RAISE OKC_API.G_EXCEPTION_ERROR;
6038: END IF;

Line 6035: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

6031: x_timeunit => l_timeunit,
6032: x_return_status => x_return_status);
6033:
6034: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
6035: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
6036: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
6037: RAISE OKC_API.G_EXCEPTION_ERROR;
6038: END IF;
6039:

Line 6036: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

6032: x_return_status => x_return_status);
6033:
6034: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
6035: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
6036: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
6037: RAISE OKC_API.G_EXCEPTION_ERROR;
6038: END IF;
6039:
6040: OKS_BILL_UTIL_PUB.get_seeded_timeunit(

Line 6037: RAISE OKC_API.G_EXCEPTION_ERROR;

6033:
6034: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
6035: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
6036: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
6037: RAISE OKC_API.G_EXCEPTION_ERROR;
6038: END IF;
6039:
6040: OKS_BILL_UTIL_PUB.get_seeded_timeunit(
6041: p_timeunit => l_timeunit,

Line 6200: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

6196: ||', sll passed for delete = '|| l_strm_lvl_tbl_in.count ||')');
6197: END IF;
6198:
6199:
6200: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
6201: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
6202: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
6203: RAISE OKC_API.G_EXCEPTION_ERROR;
6204: END IF;

Line 6201: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

6197: END IF;
6198:
6199:
6200: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
6201: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
6202: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
6203: RAISE OKC_API.G_EXCEPTION_ERROR;
6204: END IF;
6205: END IF;

Line 6202: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN

6198:
6199:
6200: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
6201: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
6202: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
6203: RAISE OKC_API.G_EXCEPTION_ERROR;
6204: END IF;
6205: END IF;
6206:

Line 6203: RAISE OKC_API.G_EXCEPTION_ERROR;

6199:
6200: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
6201: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
6202: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
6203: RAISE OKC_API.G_EXCEPTION_ERROR;
6204: END IF;
6205: END IF;
6206:
6207: IF l_sll_tbl.count > 0 then

Line 6291: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

6287: 'okc_time_util_pub.get_seeded_timeunit(x_return_status = '||x_return_status
6288: ||', returned timeunit and qty = ' ||l_tce_code || '-' || l_uom_quantity ||')');
6289: END IF;
6290:
6291: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
6292: RAISE G_EXCEPTION_HALT_VALIDATION;
6293: END IF;
6294: --mchoudha for bug#4860210
6295: -- IF l_tce_code = 'DAY' THEN

Line 6593: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

6589: END IF;
6590:
6591:
6592:
6593: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
6594: RAISE G_EXCEPTION_HALT_VALIDATION;
6595: END IF;
6596: --mchoudha for bug#4860210
6597: -- IF l_tce_code = 'DAY' AND nvl(l_uom_quantity,1) = 1 THEN

Line 6660: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

6656: x_duration => l_duration,
6657: x_timeunit => l_timeunit,
6658: x_return_status => x_return_status);
6659:
6660: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
6661: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
6662: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
6663: RAISE OKC_API.G_EXCEPTION_ERROR;
6664: END IF;

Line 6661: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

6657: x_timeunit => l_timeunit,
6658: x_return_status => x_return_status);
6659:
6660: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
6661: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
6662: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
6663: RAISE OKC_API.G_EXCEPTION_ERROR;
6664: END IF;
6665:

Line 6662: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

6658: x_return_status => x_return_status);
6659:
6660: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
6661: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
6662: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
6663: RAISE OKC_API.G_EXCEPTION_ERROR;
6664: END IF;
6665:
6666: OKS_BILL_UTIL_PUB.get_seeded_timeunit(

Line 6663: RAISE OKC_API.G_EXCEPTION_ERROR;

6659:
6660: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
6661: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
6662: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
6663: RAISE OKC_API.G_EXCEPTION_ERROR;
6664: END IF;
6665:
6666: OKS_BILL_UTIL_PUB.get_seeded_timeunit(
6667: p_timeunit => l_timeunit,

Line 6936: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

6932: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.create_dates_sll.EXCEPTION',
6933: 'G_EXCEPTION_HALT_VALIDATION');
6934: END IF;
6935:
6936: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
6937: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
6938: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
6939: RAISE OKC_API.G_EXCEPTION_ERROR;
6940: END IF;

Line 6937: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

6933: 'G_EXCEPTION_HALT_VALIDATION');
6934: END IF;
6935:
6936: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
6937: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
6938: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
6939: RAISE OKC_API.G_EXCEPTION_ERROR;
6940: END IF;
6941: WHEN OTHERS THEN

Line 6938: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

6934: END IF;
6935:
6936: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
6937: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
6938: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
6939: RAISE OKC_API.G_EXCEPTION_ERROR;
6940: END IF;
6941: WHEN OTHERS THEN
6942:

Line 6939: RAISE OKC_API.G_EXCEPTION_ERROR;

6935:
6936: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
6937: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
6938: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
6939: RAISE OKC_API.G_EXCEPTION_ERROR;
6940: END IF;
6941: WHEN OTHERS THEN
6942:
6943: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN

Line 6948: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,

6944: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.create_dates_sll.UNEXPECTED',
6945: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
6946: END IF;
6947:
6948: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
6949: p_msg_name => G_UNEXPECTED_ERROR,
6950: p_token1 => G_SQLCODE_TOKEN,
6951: p_token1_value => sqlcode,
6952: p_token2 => G_SQLERRM_TOKEN,

Line 7007: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,

7003: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN
7004: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.del_sll_lvlelement.UNEXPECTED',
7005: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
7006: END IF;
7007: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
7008: p_msg_name => G_UNEXPECTED_ERROR,
7009: p_token1 => G_SQLCODE_TOKEN,
7010: p_token1_value => sqlcode,
7011: p_token2 => G_SQLERRM_TOKEN,

Line 7014: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

7010: p_token1_value => sqlcode,
7011: p_token2 => G_SQLERRM_TOKEN,
7012: p_token2_value => sqlerrm);
7013:
7014: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
7015:
7016: END Del_sll_lvlelement;
7017:
7018:

Line 7041: x_return_status := OKC_API.G_RET_STS_SUCCESS;

7037: l_cp_bs_ind number;
7038:
7039:
7040: BEGIN
7041: x_return_status := OKC_API.G_RET_STS_SUCCESS;
7042:
7043: l_cp_bs_tbl.DELETE;
7044: l_index := 1;
7045:

Line 7113: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

7109: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.adjust_top_bs_amt.EXCEPTION',
7110: 'G_EXCEPTION_HALT_VALIDATION');
7111: END IF;
7112:
7113: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
7114: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
7115: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
7116: RAISE OKC_API.G_EXCEPTION_ERROR;
7117: END IF;

Line 7114: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

7110: 'G_EXCEPTION_HALT_VALIDATION');
7111: END IF;
7112:
7113: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
7114: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
7115: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
7116: RAISE OKC_API.G_EXCEPTION_ERROR;
7117: END IF;
7118: WHEN OTHERS THEN

Line 7115: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

7111: END IF;
7112:
7113: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
7114: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
7115: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
7116: RAISE OKC_API.G_EXCEPTION_ERROR;
7117: END IF;
7118: WHEN OTHERS THEN
7119:

Line 7116: RAISE OKC_API.G_EXCEPTION_ERROR;

7112:
7113: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
7114: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
7115: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
7116: RAISE OKC_API.G_EXCEPTION_ERROR;
7117: END IF;
7118: WHEN OTHERS THEN
7119:
7120: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN

Line 7125: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,

7121: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.adjust_top_bs_amt.UNEXPECTED',
7122: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
7123: END IF;
7124:
7125: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
7126: p_msg_name => G_UNEXPECTED_ERROR,
7127: p_token1 => G_SQLCODE_TOKEN,
7128: p_token1_value => sqlcode,
7129: p_token2 => G_SQLERRM_TOKEN,

Line 7183: l_msg_list VARCHAR2(1) DEFAULT OKC_API.G_FALSE;

7179: l_duration NUMBER;
7180: L_UOM_QUANTITY number;
7181: l_tce_code VARCHAR2(100);
7182:
7183: l_msg_list VARCHAR2(1) DEFAULT OKC_API.G_FALSE;
7184:
7185:
7186:
7187: BEGIN

Line 7189: x_return_status := OKC_API.G_RET_STS_SUCCESS;

7185:
7186:
7187: BEGIN
7188:
7189: x_return_status := OKC_API.G_RET_STS_SUCCESS;
7190:
7191: ---get line details
7192: Open l_Line_Csr;
7193: Fetch l_Line_Csr Into l_Line_Rec;

Line 7198: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'LINE NOT FOUND');

7194:
7195: If l_Line_Csr%Notfound then
7196: Close l_Line_Csr;
7197: x_return_status := 'E';
7198: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'LINE NOT FOUND');
7199: RAISE G_EXCEPTION_HALT_VALIDATION;
7200: End If;
7201: Close l_Line_Csr;
7202:

Line 7235: OKC_API.SET_MESSAGE (

7231:
7232:
7233: IF l_sll_tbl.COUNT = 0 THEN
7234: x_return_status := 'E';
7235: OKC_API.SET_MESSAGE (
7236: p_app_name => G_PKG_NAME,
7237: p_msg_name => 'OKS_SLL_NOT_EXISTS');
7238:
7239: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 7310: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

7306: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.update_om_sll_date.EXCEPTION',
7307: 'G_EXCEPTION_HALT_VALIDATION');
7308: END IF;
7309:
7310: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
7311: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
7312: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
7313: RAISE OKC_API.G_EXCEPTION_ERROR;
7314: END IF;

Line 7311: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

7307: 'G_EXCEPTION_HALT_VALIDATION');
7308: END IF;
7309:
7310: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
7311: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
7312: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
7313: RAISE OKC_API.G_EXCEPTION_ERROR;
7314: END IF;
7315: WHEN OTHERS THEN

Line 7312: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

7308: END IF;
7309:
7310: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
7311: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
7312: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
7313: RAISE OKC_API.G_EXCEPTION_ERROR;
7314: END IF;
7315: WHEN OTHERS THEN
7316: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN

Line 7313: RAISE OKC_API.G_EXCEPTION_ERROR;

7309:
7310: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
7311: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
7312: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
7313: RAISE OKC_API.G_EXCEPTION_ERROR;
7314: END IF;
7315: WHEN OTHERS THEN
7316: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN
7317: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.update_om_sll_date.UNEXPECTED',

Line 7321: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,

7317: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.update_om_sll_date.UNEXPECTED',
7318: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
7319: END IF;
7320:
7321: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
7322: p_msg_name => G_UNEXPECTED_ERROR,
7323: p_token1 => G_SQLCODE_TOKEN,
7324: p_token1_value => sqlcode,
7325: p_token2 => G_SQLERRM_TOKEN,

Line 7393: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,

7389: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.del_rul_elements.UNEXPECTED',
7390: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
7391: END IF;
7392:
7393: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
7394: p_msg_name => G_UNEXPECTED_ERROR,
7395: p_token1 => G_SQLCODE_TOKEN,
7396: p_token1_value => sqlcode,
7397: p_token2 => G_SQLERRM_TOKEN,

Line 7400: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

7396: p_token1_value => sqlcode,
7397: p_token2 => G_SQLERRM_TOKEN,
7398: p_token2_value => sqlerrm);
7399:
7400: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
7401:
7402:
7403: END Del_rul_elements;
7404:

Line 7460: l_init_msg_list VARCHAR2(2000) := OKC_API.G_FALSE;

7456: l_cp_bs_ind NUMBER;
7457: l_top_bs_ind NUMBER;
7458:
7459: l_api_Version Number := 1;
7460: l_init_msg_list VARCHAR2(2000) := OKC_API.G_FALSE;
7461: l_msg_list VARCHAR2(1) DEFAULT OKC_API.G_FALSE;
7462: l_msg_count Number;
7463: l_msg_data Varchar2(2000) := NULL;
7464:

Line 7461: l_msg_list VARCHAR2(1) DEFAULT OKC_API.G_FALSE;

7457: l_top_bs_ind NUMBER;
7458:
7459: l_api_Version Number := 1;
7460: l_init_msg_list VARCHAR2(2000) := OKC_API.G_FALSE;
7461: l_msg_list VARCHAR2(1) DEFAULT OKC_API.G_FALSE;
7462: l_msg_count Number;
7463: l_msg_data Varchar2(2000) := NULL;
7464:
7465: BEGIN

Line 7475: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'BILLING SCHEDULE TYPE NOT FOUND.');

7471:
7472: If l_bill_type_csr%Notfound then
7473: Close l_bill_type_Csr;
7474: x_return_status := 'E';
7475: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'BILLING SCHEDULE TYPE NOT FOUND.');
7476: RAISE G_EXCEPTION_HALT_VALIDATION;
7477: End If;
7478: Close l_bill_type_Csr;
7479:

Line 7561: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

7557: x_msg_data => l_msg_data,
7558: p_letv_tbl => l_top_bs_tbl,
7559: x_letv_tbl => l_lvl_ele_tbl_out);
7560:
7561: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
7562: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
7563: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
7564: RAISE OKC_API.G_EXCEPTION_ERROR;
7565: END IF;

Line 7562: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

7558: p_letv_tbl => l_top_bs_tbl,
7559: x_letv_tbl => l_lvl_ele_tbl_out);
7560:
7561: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
7562: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
7563: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
7564: RAISE OKC_API.G_EXCEPTION_ERROR;
7565: END IF;
7566:

Line 7563: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN

7559: x_letv_tbl => l_lvl_ele_tbl_out);
7560:
7561: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
7562: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
7563: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
7564: RAISE OKC_API.G_EXCEPTION_ERROR;
7565: END IF;
7566:
7567: END IF; ---l_cp_bs_tbl.COUNT > 0

Line 7564: RAISE OKC_API.G_EXCEPTION_ERROR;

7560:
7561: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
7562: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
7563: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
7564: RAISE OKC_API.G_EXCEPTION_ERROR;
7565: END IF;
7566:
7567: END IF; ---l_cp_bs_tbl.COUNT > 0
7568:

Line 7589: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,

7585:
7586:
7587: EXCEPTION
7588: WHEN OTHERS THEN
7589: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
7590: p_msg_name => G_UNEXPECTED_ERROR,
7591: p_token1 => G_SQLCODE_TOKEN,
7592: p_token1_value => sqlcode,
7593: p_token2 => G_SQLERRM_TOKEN,

Line 7596: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

7592: p_token1_value => sqlcode,
7593: p_token2 => G_SQLERRM_TOKEN,
7594: p_token2_value => sqlerrm);
7595:
7596: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
7597: END Del_subline_lvl_rule;
7598:
7599:
7600:

Line 7644: l_init_msg_list VARCHAR2(2000) := OKC_API.G_FALSE;

7640: l_line_tbl_in oks_bill_level_elements_pvt.letv_tbl_type;
7641: l_top_index NUMBER := 0;
7642:
7643:
7644: l_init_msg_list VARCHAR2(2000) := OKC_API.G_FALSE;
7645:
7646: BEGIN
7647:
7648: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 7648: x_return_status := OKC_API.G_RET_STS_SUCCESS;

7644: l_init_msg_list VARCHAR2(2000) := OKC_API.G_FALSE;
7645:
7646: BEGIN
7647:
7648: x_return_status := OKC_API.G_RET_STS_SUCCESS;
7649:
7650: IF p_invoice_rule_id IS NULL THEN
7651: -- nechatur 23-DEC-2005 for bug#4684706
7652: -- OKC_API.set_message(G_PKG_NAME,'OKS_INVD_COV_RULE','RULE_NAME','IRE');

Line 7652: -- OKC_API.set_message(G_PKG_NAME,'OKS_INVD_COV_RULE','RULE_NAME','IRE');

7648: x_return_status := OKC_API.G_RET_STS_SUCCESS;
7649:
7650: IF p_invoice_rule_id IS NULL THEN
7651: -- nechatur 23-DEC-2005 for bug#4684706
7652: -- OKC_API.set_message(G_PKG_NAME,'OKS_INVD_COV_RULE','RULE_NAME','IRE');
7653: OKC_API.set_message(G_PKG_NAME,'OKS_INVOICING_RULE');
7654: -- end bug#4684706
7655: x_return_status := 'E';
7656: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 7653: OKC_API.set_message(G_PKG_NAME,'OKS_INVOICING_RULE');

7649:
7650: IF p_invoice_rule_id IS NULL THEN
7651: -- nechatur 23-DEC-2005 for bug#4684706
7652: -- OKC_API.set_message(G_PKG_NAME,'OKS_INVD_COV_RULE','RULE_NAME','IRE');
7653: OKC_API.set_message(G_PKG_NAME,'OKS_INVOICING_RULE');
7654: -- end bug#4684706
7655: x_return_status := 'E';
7656: RAISE G_EXCEPTION_HALT_VALIDATION;
7657: END IF;

Line 7664: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'LINE NOT FOUND');

7660: FETCH l_line_csr Into l_line_rec;
7661:
7662: If l_line_csr%NOTFOUND THEN
7663: CLOSE l_line_csr;
7664: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'LINE NOT FOUND');
7665: x_return_status := G_RET_STS_UNEXP_ERROR;
7666: RETURN;
7667: ELSE
7668: Close l_line_csr;

Line 7686: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

7682: x_return_status => x_return_status,
7683: x_msg_count => x_msg_count,
7684: x_msg_data => x_msg_data);
7685:
7686: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
7687: RAISE G_EXCEPTION_HALT_VALIDATION;
7688: END IF;
7689:
7690: IF l_update_bs_tbl.COUNT <= 0 THEN

Line 7724: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

7720: x_return_status => x_return_status,
7721: x_msg_count => x_msg_count,
7722: x_msg_data => x_msg_data);
7723:
7724: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
7725: RAISE G_EXCEPTION_HALT_VALIDATION;
7726: END IF;
7727:
7728: IF l_update_bs_tbl.COUNT > 0 THEN

Line 7788: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

7784: p_SubLine_id => l_subLine_rec.id,
7785: x_cp_line_bs => l_cp_line_bs,
7786: x_return_status => x_return_status);
7787:
7788: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
7789: RAISE G_EXCEPTION_HALT_VALIDATION;
7790: END IF;
7791:
7792: IF l_cp_line_bs.COUNT > 0 THEN

Line 7826: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

7822: x_msg_data => x_msg_data,
7823: p_letv_tbl => l_lvl_ele_tbl_in,
7824: x_letv_tbl => l_lvl_ele_tbl_out);
7825:
7826: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
7827: RAISE G_EXCEPTION_HALT_VALIDATION;
7828: END IF;
7829: END IF;
7830:

Line 7837: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,

7833: WHEN G_EXCEPTION_HALT_VALIDATION THEN
7834: NULL;
7835:
7836: WHEN OTHERS THEN
7837: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
7838: p_msg_name => G_UNEXPECTED_ERROR,
7839: p_token1 => G_SQLCODE_TOKEN,
7840: p_token1_value => sqlcode,
7841: p_token2 => G_SQLERRM_TOKEN,

Line 7897: x_return_status := OKC_API.G_RET_STS_SUCCESS;

7893: l_date_transaction DATE;
7894:
7895: BEGIN
7896:
7897: x_return_status := OKC_API.G_RET_STS_SUCCESS;
7898:
7899:
7900: For l_Line_SLL_rec IN l_Line_SLL_csr(p_line_id)
7901: LOOP

Line 8048: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,

8044:
8045: EXCEPTION
8046:
8047: WHEN OTHERS THEN
8048: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
8049: p_msg_name => G_UNEXPECTED_ERROR,
8050: p_token1 => G_SQLCODE_TOKEN,
8051: p_token1_value => sqlcode,
8052: p_token2 => G_SQLERRM_TOKEN,

Line 8079: x_return_status := OKC_API.G_RET_STS_SUCCESS;

8075: l_msg_data VARCHAR2(2000);
8076:
8077: BEGIN
8078:
8079: x_return_status := OKC_API.G_RET_STS_SUCCESS;
8080:
8081:
8082: IF p_line_id IS NOT NULL THEN
8083: oks_bill_sch.Cascade_Dates_SLL

Line 8106: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

8102: END IF;
8103:
8104: EXCEPTION
8105: WHEN G_EXCEPTION_HALT_VALIDATION THEN
8106: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
8107: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
8108: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
8109: RAISE OKC_API.G_EXCEPTION_ERROR;
8110: END IF;

Line 8107: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

8103:
8104: EXCEPTION
8105: WHEN G_EXCEPTION_HALT_VALIDATION THEN
8106: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
8107: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
8108: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
8109: RAISE OKC_API.G_EXCEPTION_ERROR;
8110: END IF;
8111: WHEN OTHERS THEN

Line 8108: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

8104: EXCEPTION
8105: WHEN G_EXCEPTION_HALT_VALIDATION THEN
8106: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
8107: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
8108: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
8109: RAISE OKC_API.G_EXCEPTION_ERROR;
8110: END IF;
8111: WHEN OTHERS THEN
8112: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,

Line 8109: RAISE OKC_API.G_EXCEPTION_ERROR;

8105: WHEN G_EXCEPTION_HALT_VALIDATION THEN
8106: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
8107: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
8108: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
8109: RAISE OKC_API.G_EXCEPTION_ERROR;
8110: END IF;
8111: WHEN OTHERS THEN
8112: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
8113: p_msg_name => G_UNEXPECTED_ERROR,

Line 8112: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,

8108: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
8109: RAISE OKC_API.G_EXCEPTION_ERROR;
8110: END IF;
8111: WHEN OTHERS THEN
8112: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
8113: p_msg_name => G_UNEXPECTED_ERROR,
8114: p_token1 => G_SQLCODE_TOKEN,
8115: p_token1_value => sqlcode,
8116: p_token2 => G_SQLERRM_TOKEN,

Line 8177: l_init_msg_list VARCHAR2(2000) := OKC_API.G_FALSE;

8173: l_bill_type VARCHAR2(10);
8174:
8175: --
8176: l_api_version CONSTANT NUMBER := 1.0;
8177: l_init_msg_list VARCHAR2(2000) := OKC_API.G_FALSE;
8178: l_return_status VARCHAR2(10);
8179: l_msg_count NUMBER;
8180: l_msg_data VARCHAR2(2000);
8181: l_msg_index_out NUMBER;

Line 8197: x_return_status := OKC_API.G_RET_STS_SUCCESS;

8193: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;
8194: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;
8195: BEGIN
8196:
8197: x_return_status := OKC_API.G_RET_STS_SUCCESS;
8198:
8199: l_tangible := OKS_SUBSCRIPTION_PUB.is_subs_tangible (p_line_rec.id);
8200:
8201:

Line 8280: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

8276: x_return_status => x_return_status);
8277:
8278: -----errorout_ad('Delete_lvl_element status = ' || x_return_status);
8279:
8280: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
8281: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
8282: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
8283: RAISE OKC_API.G_EXCEPTION_ERROR;
8284: END IF;

Line 8281: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

8277:
8278: -----errorout_ad('Delete_lvl_element status = ' || x_return_status);
8279:
8280: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
8281: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
8282: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
8283: RAISE OKC_API.G_EXCEPTION_ERROR;
8284: END IF;
8285: END IF;

Line 8282: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

8278: -----errorout_ad('Delete_lvl_element status = ' || x_return_status);
8279:
8280: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
8281: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
8282: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
8283: RAISE OKC_API.G_EXCEPTION_ERROR;
8284: END IF;
8285: END IF;
8286:

Line 8283: RAISE OKC_API.G_EXCEPTION_ERROR;

8279:
8280: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
8281: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
8282: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
8283: RAISE OKC_API.G_EXCEPTION_ERROR;
8284: END IF;
8285: END IF;
8286:
8287: IF p_line_rec.line_start_dt >= nvl(p_term_dt,l_line_end_date) AND l_line_amt = 0 THEN ---if line terminated on the same dt.

Line 8322: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

8318:
8319: -----errorout_ad('LEVEL ELEMENT COUNTER = ' || TO_CHAR(l_period_counter));
8320: -----errorout_ad('LEVEL ELEMENT START DATE = ' || to_char(l_next_cycle_dt));
8321:
8322: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
8323: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
8324: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
8325: RAISE OKC_API.G_EXCEPTION_ERROR;
8326: END IF;

Line 8323: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

8319: -----errorout_ad('LEVEL ELEMENT COUNTER = ' || TO_CHAR(l_period_counter));
8320: -----errorout_ad('LEVEL ELEMENT START DATE = ' || to_char(l_next_cycle_dt));
8321:
8322: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
8323: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
8324: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
8325: RAISE OKC_API.G_EXCEPTION_ERROR;
8326: END IF;
8327: l_lvl_loop_counter := l_period_counter;

Line 8324: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

8320: -----errorout_ad('LEVEL ELEMENT START DATE = ' || to_char(l_next_cycle_dt));
8321:
8322: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
8323: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
8324: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
8325: RAISE OKC_API.G_EXCEPTION_ERROR;
8326: END IF;
8327: l_lvl_loop_counter := l_period_counter;
8328: END IF;

Line 8325: RAISE OKC_API.G_EXCEPTION_ERROR;

8321:
8322: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
8323: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
8324: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
8325: RAISE OKC_API.G_EXCEPTION_ERROR;
8326: END IF;
8327: l_lvl_loop_counter := l_period_counter;
8328: END IF;
8329:

Line 8372: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

8368: x_return_status => x_return_status,
8369: x_quantity => l_uom_quantity ,
8370: x_timeunit => l_tce_code);
8371:
8372: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
8373: RAISE G_EXCEPTION_HALT_VALIDATION;
8374: END IF;
8375:
8376: l_remaining_amt := l_line_amt - nvl(l_bill_sch_amt,0);

Line 8389: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

8385: x_return_status => x_return_status);
8386:
8387: -----errorout_ad('Get_Constant_sll_Amount = ' || x_return_status);
8388:
8389: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
8390: RAISE G_EXCEPTION_HALT_VALIDATION;
8391: END IF;
8392: END IF; ----end of bill type = 'T'
8393:

Line 8442: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

8438: -- End - Modified by PMALLARA - Bug #3992530
8439:
8440: -----errorout_ad('LEVEL ELEMENT NEXT CYCLE DATE passed from Get_next_bill_sch = ' || TO_CHAR(l_fnd_lvl_out_rec.next_cycle_date));
8441:
8442: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
8443: -----errorout_ad(' OKS_BILL_UTIL_PUB.Get_next_bill_sch = ' || l_msg_data);
8444: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
8445: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
8446: -----errorout_ad(' OKS_BILL_UTIL_PUB.Get_next_bill_sch = ' || l_msg_data);

Line 8444: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

8440: -----errorout_ad('LEVEL ELEMENT NEXT CYCLE DATE passed from Get_next_bill_sch = ' || TO_CHAR(l_fnd_lvl_out_rec.next_cycle_date));
8441:
8442: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
8443: -----errorout_ad(' OKS_BILL_UTIL_PUB.Get_next_bill_sch = ' || l_msg_data);
8444: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
8445: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
8446: -----errorout_ad(' OKS_BILL_UTIL_PUB.Get_next_bill_sch = ' || l_msg_data);
8447: RAISE OKC_API.G_EXCEPTION_ERROR;
8448: END IF;

Line 8445: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

8441:
8442: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
8443: -----errorout_ad(' OKS_BILL_UTIL_PUB.Get_next_bill_sch = ' || l_msg_data);
8444: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
8445: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
8446: -----errorout_ad(' OKS_BILL_UTIL_PUB.Get_next_bill_sch = ' || l_msg_data);
8447: RAISE OKC_API.G_EXCEPTION_ERROR;
8448: END IF;
8449:

Line 8447: RAISE OKC_API.G_EXCEPTION_ERROR;

8443: -----errorout_ad(' OKS_BILL_UTIL_PUB.Get_next_bill_sch = ' || l_msg_data);
8444: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
8445: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
8446: -----errorout_ad(' OKS_BILL_UTIL_PUB.Get_next_bill_sch = ' || l_msg_data);
8447: RAISE OKC_API.G_EXCEPTION_ERROR;
8448: END IF;
8449:
8450:
8451:

Line 8484: l_lvl_ele_tbl_in(l_tbl_seq).object_version_number := OKC_API.G_MISS_NUM;

8480: l_lvl_ele_tbl_in(l_tbl_seq).date_to_interface := TRUNC(l_fnd_lvl_out_rec.date_to_interface);
8481: l_lvl_ele_tbl_in(l_tbl_seq).date_completed := l_fnd_lvl_out_rec.date_completed;
8482: l_lvl_ele_tbl_in(l_tbl_seq).rul_id := p_sll_tbl(l_line_sll_counter).id;
8483:
8484: l_lvl_ele_tbl_in(l_tbl_seq).object_version_number := OKC_API.G_MISS_NUM;
8485: l_lvl_ele_tbl_in(l_tbl_seq).created_by := OKC_API.G_MISS_NUM;
8486: l_lvl_ele_tbl_in(l_tbl_seq).creation_date := SYSDATE;
8487: l_lvl_ele_tbl_in(l_tbl_seq).last_updated_by := OKC_API.G_MISS_NUM;
8488: l_lvl_ele_tbl_in(l_tbl_seq).last_update_date := SYSDATE;

Line 8485: l_lvl_ele_tbl_in(l_tbl_seq).created_by := OKC_API.G_MISS_NUM;

8481: l_lvl_ele_tbl_in(l_tbl_seq).date_completed := l_fnd_lvl_out_rec.date_completed;
8482: l_lvl_ele_tbl_in(l_tbl_seq).rul_id := p_sll_tbl(l_line_sll_counter).id;
8483:
8484: l_lvl_ele_tbl_in(l_tbl_seq).object_version_number := OKC_API.G_MISS_NUM;
8485: l_lvl_ele_tbl_in(l_tbl_seq).created_by := OKC_API.G_MISS_NUM;
8486: l_lvl_ele_tbl_in(l_tbl_seq).creation_date := SYSDATE;
8487: l_lvl_ele_tbl_in(l_tbl_seq).last_updated_by := OKC_API.G_MISS_NUM;
8488: l_lvl_ele_tbl_in(l_tbl_seq).last_update_date := SYSDATE;
8489:

Line 8487: l_lvl_ele_tbl_in(l_tbl_seq).last_updated_by := OKC_API.G_MISS_NUM;

8483:
8484: l_lvl_ele_tbl_in(l_tbl_seq).object_version_number := OKC_API.G_MISS_NUM;
8485: l_lvl_ele_tbl_in(l_tbl_seq).created_by := OKC_API.G_MISS_NUM;
8486: l_lvl_ele_tbl_in(l_tbl_seq).creation_date := SYSDATE;
8487: l_lvl_ele_tbl_in(l_tbl_seq).last_updated_by := OKC_API.G_MISS_NUM;
8488: l_lvl_ele_tbl_in(l_tbl_seq).last_update_date := SYSDATE;
8489:
8490:
8491: -----errorout_ad ('Amount for line lvl element = ' || to_char(l_lvl_ele_tbl_in(l_tbl_seq).amount ));

Line 8557: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

8553:
8554: -----errorout_ad('LEVEL ELEMENT INSERT STATUS FOR SUBLINE = ' || x_return_status);
8555:
8556:
8557: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
8558: -----errorout_ad('OKS_BILL_LEVEL_ELEMENTS_PVT.insert_row for sub line = ' || l_msg_data);
8559: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
8560: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
8561: -----errorout_ad('OKS_BILL_LEVEL_ELEMENTS_PVT.insert_row for sub line = ' || l_msg_data);

Line 8559: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

8555:
8556:
8557: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
8558: -----errorout_ad('OKS_BILL_LEVEL_ELEMENTS_PVT.insert_row for sub line = ' || l_msg_data);
8559: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
8560: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
8561: -----errorout_ad('OKS_BILL_LEVEL_ELEMENTS_PVT.insert_row for sub line = ' || l_msg_data);
8562: RAISE OKC_API.G_EXCEPTION_ERROR;
8563: END IF;

Line 8560: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

8556:
8557: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
8558: -----errorout_ad('OKS_BILL_LEVEL_ELEMENTS_PVT.insert_row for sub line = ' || l_msg_data);
8559: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
8560: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
8561: -----errorout_ad('OKS_BILL_LEVEL_ELEMENTS_PVT.insert_row for sub line = ' || l_msg_data);
8562: RAISE OKC_API.G_EXCEPTION_ERROR;
8563: END IF;
8564: END IF;

Line 8562: RAISE OKC_API.G_EXCEPTION_ERROR;

8558: -----errorout_ad('OKS_BILL_LEVEL_ELEMENTS_PVT.insert_row for sub line = ' || l_msg_data);
8559: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
8560: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
8561: -----errorout_ad('OKS_BILL_LEVEL_ELEMENTS_PVT.insert_row for sub line = ' || l_msg_data);
8562: RAISE OKC_API.G_EXCEPTION_ERROR;
8563: END IF;
8564: END IF;
8565:
8566:

Line 8569: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,

8565:
8566:
8567: EXCEPTION
8568: WHEN OTHERS THEN
8569: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
8570: p_msg_name => G_UNEXPECTED_ERROR,
8571: p_token1 => G_SQLCODE_TOKEN,
8572: p_token1_value => sqlcode,
8573: p_token2 => G_SQLERRM_TOKEN,

Line 8643: x_return_status := OKC_API.G_RET_STS_SUCCESS;

8639: -------------------------------------------------------------------------
8640:
8641: BEGIN
8642:
8643: x_return_status := OKC_API.G_RET_STS_SUCCESS;
8644: l_update_end_date := 'N';
8645:
8646: IF nvl(p_full_credit, 'N') = 'Y' Then
8647: DELETE FROM OKS_LEVEL_ELEMENTS

Line 8661: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'LINE NOT FOUND');

8657:
8658: If l_Line_Csr%Notfound then
8659: Close l_Line_Csr;
8660: x_return_status := 'E';
8661: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'LINE NOT FOUND');
8662: RAISE G_EXCEPTION_HALT_VALIDATION;
8663: End If;
8664: Close l_Line_Csr;
8665:

Line 8779: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

8775:
8776:
8777: EXCEPTION
8778: WHEN G_EXCEPTION_HALT_VALIDATION THEN
8779: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
8780: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
8781: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
8782: RAISE OKC_API.G_EXCEPTION_ERROR;
8783: END IF;

Line 8780: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

8776:
8777: EXCEPTION
8778: WHEN G_EXCEPTION_HALT_VALIDATION THEN
8779: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
8780: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
8781: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
8782: RAISE OKC_API.G_EXCEPTION_ERROR;
8783: END IF;
8784: WHEN OTHERS THEN

Line 8781: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

8777: EXCEPTION
8778: WHEN G_EXCEPTION_HALT_VALIDATION THEN
8779: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
8780: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
8781: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
8782: RAISE OKC_API.G_EXCEPTION_ERROR;
8783: END IF;
8784: WHEN OTHERS THEN
8785: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,

Line 8782: RAISE OKC_API.G_EXCEPTION_ERROR;

8778: WHEN G_EXCEPTION_HALT_VALIDATION THEN
8779: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
8780: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
8781: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
8782: RAISE OKC_API.G_EXCEPTION_ERROR;
8783: END IF;
8784: WHEN OTHERS THEN
8785: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
8786: p_msg_name => G_UNEXPECTED_ERROR,

Line 8785: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,

8781: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
8782: RAISE OKC_API.G_EXCEPTION_ERROR;
8783: END IF;
8784: WHEN OTHERS THEN
8785: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
8786: p_msg_name => G_UNEXPECTED_ERROR,
8787: p_token1 => G_SQLCODE_TOKEN,
8788: p_token1_value => sqlcode,
8789: p_token2 => G_SQLERRM_TOKEN,

Line 9029: l_init_msg_list VARCHAR2(2000) := OKC_API.G_FALSE;

9025: l_sll_in_tbl StrmLvl_Out_tbl;
9026: l_sll_db_tbl oks_bill_sch.StreamLvl_tbl;
9027: l_top_bs_tbl oks_bill_level_elements_pvt.letv_tbl_type;
9028:
9029: l_init_msg_list VARCHAR2(2000) := OKC_API.G_FALSE;
9030:
9031: -------------------------------------------------------------------------
9032: -- Begin partial period computation logic
9033: -- Developer Mani Choudhary

Line 9073: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'LINE NOT FOUND');

9069:
9070: If l_Line_Csr%Notfound then
9071: Close l_Line_Csr;
9072: x_return_status := 'E';
9073: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'LINE NOT FOUND');
9074: RAISE G_EXCEPTION_HALT_VALIDATION;
9075: End If;
9076: Close l_Line_Csr;
9077:

Line 9172: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'CURRENCY CODE NOT FOUND.');

9168: 'l_currency_code = ' || l_currency_code);
9169: END IF;
9170:
9171: IF l_currency_code IS NULL THEN
9172: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'CURRENCY CODE NOT FOUND.');
9173: x_return_status := 'E';
9174: RAISE G_EXCEPTION_HALT_VALIDATION;
9175: END IF;
9176:

Line 9311: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

9307: 'Rollup_lvl_amt(x_return_status = '||x_return_status
9308: ||')');
9309: END IF;
9310:
9311: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
9312: RAISE G_EXCEPTION_HALT_VALIDATION;
9313: END IF;
9314: END IF;
9315:

Line 9420: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'SUB LINE NOT FOUND');

9416: FETCH l_SubLine_Csr Into l_SubLine_Rec;
9417: If l_SubLine_Csr%Notfound then
9418: Close l_SubLine_Csr;
9419: x_return_status := 'E';
9420: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'SUB LINE NOT FOUND');
9421: RAISE G_EXCEPTION_HALT_VALIDATION;
9422: End If;
9423: Close l_SubLine_Csr;
9424:

Line 9565: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

9561:
9562:
9563: EXCEPTION
9564: WHEN G_EXCEPTION_HALT_VALIDATION THEN
9565: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
9566: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
9567: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
9568: RAISE OKC_API.G_EXCEPTION_ERROR;
9569: END IF;

Line 9566: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

9562:
9563: EXCEPTION
9564: WHEN G_EXCEPTION_HALT_VALIDATION THEN
9565: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
9566: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
9567: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
9568: RAISE OKC_API.G_EXCEPTION_ERROR;
9569: END IF;
9570: WHEN OTHERS THEN

Line 9567: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

9563: EXCEPTION
9564: WHEN G_EXCEPTION_HALT_VALIDATION THEN
9565: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
9566: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
9567: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
9568: RAISE OKC_API.G_EXCEPTION_ERROR;
9569: END IF;
9570: WHEN OTHERS THEN
9571: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,

Line 9568: RAISE OKC_API.G_EXCEPTION_ERROR;

9564: WHEN G_EXCEPTION_HALT_VALIDATION THEN
9565: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
9566: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
9567: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
9568: RAISE OKC_API.G_EXCEPTION_ERROR;
9569: END IF;
9570: WHEN OTHERS THEN
9571: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
9572: p_msg_name => G_UNEXPECTED_ERROR,

Line 9571: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,

9567: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
9568: RAISE OKC_API.G_EXCEPTION_ERROR;
9569: END IF;
9570: WHEN OTHERS THEN
9571: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
9572: p_msg_name => G_UNEXPECTED_ERROR,
9573: p_token1 => G_SQLCODE_TOKEN,
9574: p_token1_value => sqlcode,
9575: p_token2 => G_SQLERRM_TOKEN,

Line 9627: l_init_msg_list VARCHAR2(2000) := OKC_API.G_FALSE;

9623: i number;
9624: l_end_date DATE;
9625: l_billed_at_source OKC_K_HEADERS_ALL_B.BILLED_AT_SOURCE%TYPE;
9626: --
9627: l_init_msg_list VARCHAR2(2000) := OKC_API.G_FALSE;
9628: l_return_status VARCHAR2(1);
9629: l_msg_count NUMBER;
9630: l_msg_data VARCHAR2(2000);
9631: l_msg_index_out NUMBER;

Line 9690: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

9686: IF l_header_billing IS NULL THEN
9687: Delete_lvl_element(p_cle_id => p_SubLine_rec.cp_id,
9688: x_return_status => x_return_status);
9689:
9690: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
9691: RAISE G_EXCEPTION_HALT_VALIDATION;
9692: END IF;
9693: END IF;
9694:

Line 9719: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

9715: x_top_line_bs => p_top_line_bs,
9716: x_return_status => x_return_status);
9717:
9718: -----errorout_ad('Check_Existing_Lvlelement 1 = '|| x_return_status);
9719: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
9720: RAISE G_EXCEPTION_HALT_VALIDATION;
9721: END IF;
9722: END LOOP;
9723: END IF; ---END OF p_cp_sll_tbl.count

Line 9759: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

9755: x_return_status => x_return_status);
9756:
9757: -----errorout_ad('Check_Existing_Lvlelement 2= '|| x_return_status);
9758:
9759: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
9760: RAISE G_EXCEPTION_HALT_VALIDATION;
9761: END IF;
9762:
9763: l_lvl_loop_counter := l_period_counter;

Line 9828: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

9824: x_return_status => x_return_status);
9825:
9826: -----errorout_ad('Check_Existing_Lvlelement 3= '|| x_return_status);
9827:
9828: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
9829: RAISE G_EXCEPTION_HALT_VALIDATION;
9830: END IF;
9831: END LOOP;
9832: END IF; ----END OF l_cp_sll_counter < p_cp_sll_tbl.LAST

Line 9859: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

9855: x_return_status => x_return_status,
9856: x_quantity => l_uom_quantity ,
9857: x_timeunit => l_tce_code);
9858:
9859: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
9860: RAISE G_EXCEPTION_HALT_VALIDATION;
9861: END IF;
9862:
9863:

Line 9915: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

9911: x_return_status => x_return_status);
9912: END IF;
9913: -----errorout_ad('Get_Constant_sll_Amount = ' || l_constant_sll_amt);
9914:
9915: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
9916: RAISE G_EXCEPTION_HALT_VALIDATION;
9917: END IF;
9918: END IF;
9919:

Line 10057: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

10053: -----errorout_ad(' OKS_BILL_UTIL_PUB.Get_next_bill_sch l_fnd_next_cycle = ' || x_return_status);
10054: -----errorout_ad('l_fnd_lvl_out_rec.next_cycle_date = ' || l_fnd_lvl_out_rec.next_cycle_date );
10055:
10056:
10057: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
10058: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
10059: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
10060: RAISE OKC_API.G_EXCEPTION_ERROR;
10061: END IF;

Line 10058: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

10054: -----errorout_ad('l_fnd_lvl_out_rec.next_cycle_date = ' || l_fnd_lvl_out_rec.next_cycle_date );
10055:
10056:
10057: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
10058: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
10059: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
10060: RAISE OKC_API.G_EXCEPTION_ERROR;
10061: END IF;
10062:

Line 10059: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

10055:
10056:
10057: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
10058: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
10059: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
10060: RAISE OKC_API.G_EXCEPTION_ERROR;
10061: END IF;
10062:
10063:

Line 10060: RAISE OKC_API.G_EXCEPTION_ERROR;

10056:
10057: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
10058: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
10059: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
10060: RAISE OKC_API.G_EXCEPTION_ERROR;
10061: END IF;
10062:
10063:
10064: -------Next cycle date given by Get_next_bill_sch is <= cp start date then do not create

Line 10203: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

10199: x_return_status => x_return_status);
10200:
10201:
10202: -----errorout_ad('Get_Period_Frequency = ' || x_return_status);
10203: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
10204: RAISE G_EXCEPTION_HALT_VALIDATION;
10205: END IF;
10206:
10207: l_lvl_amt := (NVL(l_period_freq,0) * NVL(l_constant_sll_amt,0) );

Line 10362: l_lvl_ele_tbl_in(l_tbl_seq).object_version_number := OKC_API.G_MISS_NUM;

10358: l_lvl_ele_tbl_in(l_tbl_seq).date_completed := l_fnd_lvl_out_rec.date_completed;
10359: end if;
10360:
10361: l_lvl_ele_tbl_in(l_tbl_seq).rul_id := p_cp_sll_tbl(l_cp_sll_counter).id;
10362: l_lvl_ele_tbl_in(l_tbl_seq).object_version_number := OKC_API.G_MISS_NUM;
10363: l_lvl_ele_tbl_in(l_tbl_seq).created_by := OKC_API.G_MISS_NUM;
10364: l_lvl_ele_tbl_in(l_tbl_seq).creation_date := SYSDATE;
10365: l_lvl_ele_tbl_in(l_tbl_seq).last_updated_by := OKC_API.G_MISS_NUM;
10366: l_lvl_ele_tbl_in(l_tbl_seq).last_update_date := SYSDATE;

Line 10363: l_lvl_ele_tbl_in(l_tbl_seq).created_by := OKC_API.G_MISS_NUM;

10359: end if;
10360:
10361: l_lvl_ele_tbl_in(l_tbl_seq).rul_id := p_cp_sll_tbl(l_cp_sll_counter).id;
10362: l_lvl_ele_tbl_in(l_tbl_seq).object_version_number := OKC_API.G_MISS_NUM;
10363: l_lvl_ele_tbl_in(l_tbl_seq).created_by := OKC_API.G_MISS_NUM;
10364: l_lvl_ele_tbl_in(l_tbl_seq).creation_date := SYSDATE;
10365: l_lvl_ele_tbl_in(l_tbl_seq).last_updated_by := OKC_API.G_MISS_NUM;
10366: l_lvl_ele_tbl_in(l_tbl_seq).last_update_date := SYSDATE;
10367:

Line 10365: l_lvl_ele_tbl_in(l_tbl_seq).last_updated_by := OKC_API.G_MISS_NUM;

10361: l_lvl_ele_tbl_in(l_tbl_seq).rul_id := p_cp_sll_tbl(l_cp_sll_counter).id;
10362: l_lvl_ele_tbl_in(l_tbl_seq).object_version_number := OKC_API.G_MISS_NUM;
10363: l_lvl_ele_tbl_in(l_tbl_seq).created_by := OKC_API.G_MISS_NUM;
10364: l_lvl_ele_tbl_in(l_tbl_seq).creation_date := SYSDATE;
10365: l_lvl_ele_tbl_in(l_tbl_seq).last_updated_by := OKC_API.G_MISS_NUM;
10366: l_lvl_ele_tbl_in(l_tbl_seq).last_update_date := SYSDATE;
10367:
10368: -----errorout_ad ('Amount for subline lvl element = ' || to_char(l_lvl_ele_tbl_in(l_tbl_seq).amount ));
10369:

Line 10487: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

10483: x_return_status => x_return_status);
10484: END LOOP;
10485:
10486: -----errorout_ad('Check_Existing_Lvlelement5 = '|| x_return_status);
10487: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
10488: RAISE G_EXCEPTION_HALT_VALIDATION;
10489: END IF;
10490: END IF; ---END OF l_cp_sll_counter < p_cp_sll_tbl.LAST
10491:

Line 10512: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

10508:
10509: -----errorout_ad('LEVEL ELEMENT INSERT STATUS FOR SUBLINE = ' || x_return_status);
10510:
10511:
10512: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
10513: RAISE G_EXCEPTION_HALT_VALIDATION;
10514: END IF;
10515: END IF;
10516:

Line 10520: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

10516:
10517:
10518: EXCEPTION
10519: WHEN G_EXCEPTION_HALT_VALIDATION THEN
10520: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
10521: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
10522: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
10523: RAISE OKC_API.G_EXCEPTION_ERROR;
10524: END IF;

Line 10521: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

10517:
10518: EXCEPTION
10519: WHEN G_EXCEPTION_HALT_VALIDATION THEN
10520: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
10521: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
10522: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
10523: RAISE OKC_API.G_EXCEPTION_ERROR;
10524: END IF;
10525: WHEN OTHERS THEN

Line 10522: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

10518: EXCEPTION
10519: WHEN G_EXCEPTION_HALT_VALIDATION THEN
10520: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
10521: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
10522: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
10523: RAISE OKC_API.G_EXCEPTION_ERROR;
10524: END IF;
10525: WHEN OTHERS THEN
10526: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,

Line 10523: RAISE OKC_API.G_EXCEPTION_ERROR;

10519: WHEN G_EXCEPTION_HALT_VALIDATION THEN
10520: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
10521: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
10522: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
10523: RAISE OKC_API.G_EXCEPTION_ERROR;
10524: END IF;
10525: WHEN OTHERS THEN
10526: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
10527: p_msg_name => G_UNEXPECTED_ERROR,

Line 10526: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,

10522: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
10523: RAISE OKC_API.G_EXCEPTION_ERROR;
10524: END IF;
10525: WHEN OTHERS THEN
10526: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
10527: p_msg_name => G_UNEXPECTED_ERROR,
10528: p_token1 => G_SQLCODE_TOKEN,
10529: p_token1_value => sqlcode,
10530: p_token2 => G_SQLERRM_TOKEN,

Line 10578: l_init_msg_list VARCHAR2(2000) := OKC_API.G_FALSE;

10574:
10575:
10576: --
10577: l_api_version CONSTANT NUMBER := 1.0;
10578: l_init_msg_list VARCHAR2(2000) := OKC_API.G_FALSE;
10579: --
10580: -------------------------------------------------------------------------
10581: -- Begin partial period computation logic
10582: -- Developer Mani Choudhary

Line 10708: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'CURRENCY CODE NOT FOUND.');

10704: l_currency_code := Find_Currency_Code(
10705: p_cle_id => NULL,
10706: p_chr_id => p_contract_id);
10707: IF l_currency_code IS NULL THEN
10708: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'CURRENCY CODE NOT FOUND.');
10709: x_return_status := 'E';
10710: RETURN;
10711: END IF;
10712:

Line 10745: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,

10741:
10742: WHEN OTHERS THEN
10743: l_currency_code := NULL;
10744: l_header_billing := NULL;
10745: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
10746: p_msg_name => G_UNEXPECTED_ERROR,
10747: p_token1 => G_SQLCODE_TOKEN,
10748: p_token1_value => sqlcode,
10749: p_token2 => G_SQLERRM_TOKEN,

Line 10793: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,

10789:
10790:
10791: EXCEPTION
10792: WHEN OTHERS THEN
10793: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
10794: p_msg_name => G_UNEXPECTED_ERROR,
10795: p_token1 => G_SQLCODE_TOKEN,
10796: p_token1_value => sqlcode,
10797: p_token2 => G_SQLERRM_TOKEN,

Line 10800: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

10796: p_token1_value => sqlcode,
10797: p_token2 => G_SQLERRM_TOKEN,
10798: p_token2_value => sqlerrm);
10799:
10800: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
10801:
10802: END Del_line_sll_lvl;
10803:
10804:

Line 10829: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,

10825:
10826:
10827: EXCEPTION
10828: WHEN OTHERS THEN
10829: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
10830: p_msg_name => G_UNEXPECTED_ERROR,
10831: p_token1 => G_SQLCODE_TOKEN,
10832: p_token1_value => sqlcode,
10833: p_token2 => G_SQLERRM_TOKEN,

Line 10836: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

10832: p_token1_value => sqlcode,
10833: p_token2 => G_SQLERRM_TOKEN,
10834: p_token2_value => sqlerrm);
10835:
10836: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
10837:
10838: END Delete_contract_bs_sll;
10839:
10840: Procedure Populate_end_date(p_line_id IN NUMBER,

Line 11159: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,

11155: ROLLBACK;
11156: x_return_status := 'E';
11157:
11158: WHEN OTHERS THEN
11159: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
11160: p_msg_name => G_UNEXPECTED_ERROR,
11161: p_token1 => G_SQLCODE_TOKEN,
11162: p_token1_value => sqlcode,
11163: p_token2 => G_SQLERRM_TOKEN,

Line 11195: x_return_status := OKC_API.G_RET_STS_SUCCESS;

11191: l_cp_bs_ind number;
11192:
11193:
11194: BEGIN
11195: x_return_status := OKC_API.G_RET_STS_SUCCESS;
11196:
11197: l_cp_bs_tbl.DELETE;
11198: l_index := 1;
11199:

Line 11262: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

11258:
11259:
11260: EXCEPTION
11261: WHEN G_EXCEPTION_HALT_VALIDATION THEN
11262: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
11263: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
11264: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
11265: RAISE OKC_API.G_EXCEPTION_ERROR;
11266: END IF;

Line 11263: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

11259:
11260: EXCEPTION
11261: WHEN G_EXCEPTION_HALT_VALIDATION THEN
11262: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
11263: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
11264: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
11265: RAISE OKC_API.G_EXCEPTION_ERROR;
11266: END IF;
11267: WHEN OTHERS THEN

Line 11264: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

11260: EXCEPTION
11261: WHEN G_EXCEPTION_HALT_VALIDATION THEN
11262: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
11263: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
11264: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
11265: RAISE OKC_API.G_EXCEPTION_ERROR;
11266: END IF;
11267: WHEN OTHERS THEN
11268: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,

Line 11265: RAISE OKC_API.G_EXCEPTION_ERROR;

11261: WHEN G_EXCEPTION_HALT_VALIDATION THEN
11262: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
11263: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
11264: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
11265: RAISE OKC_API.G_EXCEPTION_ERROR;
11266: END IF;
11267: WHEN OTHERS THEN
11268: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
11269: p_msg_name => G_UNEXPECTED_ERROR,

Line 11268: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,

11264: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
11265: RAISE OKC_API.G_EXCEPTION_ERROR;
11266: END IF;
11267: WHEN OTHERS THEN
11268: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
11269: p_msg_name => G_UNEXPECTED_ERROR,
11270: p_token1 => G_SQLCODE_TOKEN,
11271: p_token1_value => sqlcode,
11272: p_token2 => G_SQLERRM_TOKEN,

Line 11322: x_return_status := OKC_API.G_RET_STS_SUCCESS;

11318: l_cp_bs_ind number;
11319:
11320:
11321: BEGIN
11322: x_return_status := OKC_API.G_RET_STS_SUCCESS;
11323:
11324: l_cp_bs_tbl.DELETE;
11325: l_index := 1;
11326:

Line 11386: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

11382:
11383:
11384: EXCEPTION
11385: WHEN G_EXCEPTION_HALT_VALIDATION THEN
11386: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
11387: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
11388: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
11389: RAISE OKC_API.G_EXCEPTION_ERROR;
11390: END IF;

Line 11387: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

11383:
11384: EXCEPTION
11385: WHEN G_EXCEPTION_HALT_VALIDATION THEN
11386: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
11387: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
11388: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
11389: RAISE OKC_API.G_EXCEPTION_ERROR;
11390: END IF;
11391: WHEN OTHERS THEN

Line 11388: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

11384: EXCEPTION
11385: WHEN G_EXCEPTION_HALT_VALIDATION THEN
11386: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
11387: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
11388: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
11389: RAISE OKC_API.G_EXCEPTION_ERROR;
11390: END IF;
11391: WHEN OTHERS THEN
11392: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,

Line 11389: RAISE OKC_API.G_EXCEPTION_ERROR;

11385: WHEN G_EXCEPTION_HALT_VALIDATION THEN
11386: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
11387: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
11388: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
11389: RAISE OKC_API.G_EXCEPTION_ERROR;
11390: END IF;
11391: WHEN OTHERS THEN
11392: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
11393: p_msg_name => G_UNEXPECTED_ERROR,

Line 11392: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,

11388: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
11389: RAISE OKC_API.G_EXCEPTION_ERROR;
11390: END IF;
11391: WHEN OTHERS THEN
11392: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
11393: p_msg_name => G_UNEXPECTED_ERROR,
11394: p_token1 => G_SQLCODE_TOKEN,
11395: p_token1_value => sqlcode,
11396: p_token2 => G_SQLERRM_TOKEN,

Line 11425: l_init_msg_list VARCHAR2(2000) := OKC_API.G_FALSE;

11421:
11422:
11423:
11424: l_api_version CONSTANT NUMBER := 1.0;
11425: l_init_msg_list VARCHAR2(2000) := OKC_API.G_FALSE;
11426: l_msg_count NUMBER;
11427: l_msg_data VARCHAR2(2000);
11428:
11429: -- Start - Added by PMALLARA - Bug #3992530

Line 11483: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

11479:
11480: -----errorout_ad ('Calculate_sll_amount STATUS = ' || x_return_status);
11481:
11482:
11483: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
11484: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
11485: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
11486: RAISE OKC_API.G_EXCEPTION_ERROR;
11487: END IF;

Line 11484: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

11480: -----errorout_ad ('Calculate_sll_amount STATUS = ' || x_return_status);
11481:
11482:
11483: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
11484: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
11485: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
11486: RAISE OKC_API.G_EXCEPTION_ERROR;
11487: END IF;
11488:

Line 11485: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

11481:
11482:
11483: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
11484: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
11485: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
11486: RAISE OKC_API.G_EXCEPTION_ERROR;
11487: END IF;
11488:
11489: FOR l_index IN l_sll_prorate_tbl.FIRST .. l_sll_prorate_tbl.LAST

Line 11486: RAISE OKC_API.G_EXCEPTION_ERROR;

11482:
11483: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
11484: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
11485: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
11486: RAISE OKC_API.G_EXCEPTION_ERROR;
11487: END IF;
11488:
11489: FOR l_index IN l_sll_prorate_tbl.FIRST .. l_sll_prorate_tbl.LAST
11490: LOOP

Line 11546: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

11542: Strm_Start_Date => Strm_Start_Date);
11543: -- End - Modified by PMALLARA - Bug #3992530
11544:
11545:
11546: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
11547: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
11548: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
11549: RAISE OKC_API.G_EXCEPTION_ERROR;
11550: END IF;

Line 11547: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

11543: -- End - Modified by PMALLARA - Bug #3992530
11544:
11545:
11546: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
11547: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
11548: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
11549: RAISE OKC_API.G_EXCEPTION_ERROR;
11550: END IF;
11551:

Line 11548: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

11544:
11545:
11546: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
11547: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
11548: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
11549: RAISE OKC_API.G_EXCEPTION_ERROR;
11550: END IF;
11551:
11552:

Line 11549: RAISE OKC_API.G_EXCEPTION_ERROR;

11545:
11546: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
11547: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
11548: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
11549: RAISE OKC_API.G_EXCEPTION_ERROR;
11550: END IF;
11551:
11552:
11553:

Line 11615: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,

11611:
11612: EXCEPTION
11613:
11614: WHEN OTHERS THEN
11615: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
11616: p_msg_name => G_UNEXPECTED_ERROR,
11617: p_token1 => G_SQLCODE_TOKEN,
11618: p_token1_value => sqlcode,
11619: p_token2 => G_SQLERRM_TOKEN,

Line 11667: l_init_msg_list VARCHAR2(2000) := OKC_API.G_FALSE;

11663: l_sll_index NUMBER;
11664: l_index NUMBER;
11665: l_sll_end_date DATE;
11666:
11667: l_init_msg_list VARCHAR2(2000) := OKC_API.G_FALSE;
11668:
11669: BEGIN
11670: x_return_status := 'S';
11671:

Line 11729: l_strm_lvl_tbl_in(l_sll_index).object_version_number := OKC_API.G_MISS_NUM;

11725: l_strm_lvl_tbl_in(l_sll_index).invoice_offset_days := l_old_sll_rec.invoice_offset_days;
11726: l_strm_lvl_tbl_in(l_sll_index).interface_offset_days := l_old_sll_rec.interface_offset_days;
11727:
11728:
11729: l_strm_lvl_tbl_in(l_sll_index).object_version_number := OKC_API.G_MISS_NUM;
11730: l_strm_lvl_tbl_in(l_sll_index).created_by := OKC_API.G_MISS_NUM;
11731: l_strm_lvl_tbl_in(l_sll_index).creation_date := SYSDATE;
11732: l_strm_lvl_tbl_in(l_sll_index).last_updated_by := OKC_API.G_MISS_NUM;
11733: l_strm_lvl_tbl_in(l_sll_index).last_update_date := SYSDATE;

Line 11730: l_strm_lvl_tbl_in(l_sll_index).created_by := OKC_API.G_MISS_NUM;

11726: l_strm_lvl_tbl_in(l_sll_index).interface_offset_days := l_old_sll_rec.interface_offset_days;
11727:
11728:
11729: l_strm_lvl_tbl_in(l_sll_index).object_version_number := OKC_API.G_MISS_NUM;
11730: l_strm_lvl_tbl_in(l_sll_index).created_by := OKC_API.G_MISS_NUM;
11731: l_strm_lvl_tbl_in(l_sll_index).creation_date := SYSDATE;
11732: l_strm_lvl_tbl_in(l_sll_index).last_updated_by := OKC_API.G_MISS_NUM;
11733: l_strm_lvl_tbl_in(l_sll_index).last_update_date := SYSDATE;
11734:

Line 11732: l_strm_lvl_tbl_in(l_sll_index).last_updated_by := OKC_API.G_MISS_NUM;

11728:
11729: l_strm_lvl_tbl_in(l_sll_index).object_version_number := OKC_API.G_MISS_NUM;
11730: l_strm_lvl_tbl_in(l_sll_index).created_by := OKC_API.G_MISS_NUM;
11731: l_strm_lvl_tbl_in(l_sll_index).creation_date := SYSDATE;
11732: l_strm_lvl_tbl_in(l_sll_index).last_updated_by := OKC_API.G_MISS_NUM;
11733: l_strm_lvl_tbl_in(l_sll_index).last_update_date := SYSDATE;
11734:
11735: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
11736:

Line 11769: IF NVL(x_return_status,'!') <> OKC_API.G_RET_STS_SUCCESS THEN

11765: 'OKS_SLL_PVT.insert_row(x_return_status = '||x_return_status
11766: ||', sll tbl out count = '||l_strm_lvl_tbl_out.count||')');
11767: END IF;
11768:
11769: IF NVL(x_return_status,'!') <> OKC_API.G_RET_STS_SUCCESS THEN
11770: RAISE G_EXCEPTION_HALT_VALIDATION;
11771: END IF;
11772:
11773: OPEN l_new_cp_csr;

Line 11877: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,

11873: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.adjust_replace_product_bs.UNEXPECTED',
11874: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
11875: END IF;
11876:
11877: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
11878: p_msg_name => G_UNEXPECTED_ERROR,
11879: p_token1 => G_SQLCODE_TOKEN,
11880: p_token1_value => sqlcode,
11881: p_token2 => G_SQLERRM_TOKEN,

Line 11972: l_init_msg_list VARCHAR2(2000) := OKC_API.G_FALSE;

11968: l_index NUMBER;
11969: l_cp_bs_ind NUMBER;
11970: l_top_bs_ind NUMBER;
11971: l_total_amt NUMBER;
11972: l_init_msg_list VARCHAR2(2000) := OKC_API.G_FALSE;
11973: L_EXCEPTION_END Exception;
11974:
11975:
11976: BEGIN

Line 12140: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'CURRENCY CODE NOT FOUND.');

12136: p_cle_id => null,
12137: p_chr_id => l_top_line_rec.dnz_chr_id);
12138:
12139: IF l_currency_code IS NULL THEN
12140: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'CURRENCY CODE NOT FOUND.');
12141: x_return_status := 'E';
12142: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
12143: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.adjust_split_bill_sch.EXCEPTION',
12144: 'currency not found for contract id = ' || l_top_line_rec.dnz_chr_id );

Line 12394: IF NVL(x_return_status,'!') <> OKC_API.G_RET_STS_SUCCESS THEN

12390: );
12391:
12392: END IF;
12393:
12394: IF NVL(x_return_status,'!') <> OKC_API.G_RET_STS_SUCCESS THEN
12395: RAISE G_EXCEPTION_HALT_VALIDATION;
12396: END IF;
12397: END IF;
12398:

Line 12421: l_strm_lvl_tbl_in(l_index).object_version_number := OKC_API.G_MISS_NUM;

12417: l_strm_lvl_tbl_in(l_index).id := NULL;
12418: l_strm_lvl_tbl_in(l_index).cle_id := p_new_cp_tbl(i).id;
12419:
12420:
12421: l_strm_lvl_tbl_in(l_index).object_version_number := OKC_API.G_MISS_NUM;
12422: l_strm_lvl_tbl_in(l_index).created_by := OKC_API.G_MISS_NUM;
12423: l_strm_lvl_tbl_in(l_index).creation_date := SYSDATE;
12424: l_strm_lvl_tbl_in(l_index).last_updated_by := OKC_API.G_MISS_NUM;
12425: l_strm_lvl_tbl_in(l_index).last_update_date := SYSDATE;

Line 12422: l_strm_lvl_tbl_in(l_index).created_by := OKC_API.G_MISS_NUM;

12418: l_strm_lvl_tbl_in(l_index).cle_id := p_new_cp_tbl(i).id;
12419:
12420:
12421: l_strm_lvl_tbl_in(l_index).object_version_number := OKC_API.G_MISS_NUM;
12422: l_strm_lvl_tbl_in(l_index).created_by := OKC_API.G_MISS_NUM;
12423: l_strm_lvl_tbl_in(l_index).creation_date := SYSDATE;
12424: l_strm_lvl_tbl_in(l_index).last_updated_by := OKC_API.G_MISS_NUM;
12425: l_strm_lvl_tbl_in(l_index).last_update_date := SYSDATE;
12426:

Line 12424: l_strm_lvl_tbl_in(l_index).last_updated_by := OKC_API.G_MISS_NUM;

12420:
12421: l_strm_lvl_tbl_in(l_index).object_version_number := OKC_API.G_MISS_NUM;
12422: l_strm_lvl_tbl_in(l_index).created_by := OKC_API.G_MISS_NUM;
12423: l_strm_lvl_tbl_in(l_index).creation_date := SYSDATE;
12424: l_strm_lvl_tbl_in(l_index).last_updated_by := OKC_API.G_MISS_NUM;
12425: l_strm_lvl_tbl_in(l_index).last_update_date := SYSDATE;
12426:
12427:
12428: END LOOP;

Line 12446: IF NVL(x_return_status,'!') <> OKC_API.G_RET_STS_SUCCESS THEN

12442: 'OKS_SLL_PVT.insert_row(x_return_status = '||x_return_status
12443: ||', sll tbl out count = '||l_strm_lvl_tbl_out.count||')');
12444: END IF;
12445:
12446: IF NVL(x_return_status,'!') <> OKC_API.G_RET_STS_SUCCESS THEN
12447: RAISE G_EXCEPTION_HALT_VALIDATION;
12448: END IF;
12449:
12450: l_cp_sll_out_tbl.DELETE;

Line 12504: IF NVL(x_return_status,'!') <> OKC_API.G_RET_STS_SUCCESS THEN

12500: 'Create_cp_lvl_elements(x_return_status = '||x_return_status
12501: ||', l_top_bs_tbl count = '||l_top_bs_tbl.count||')');
12502: END IF;
12503:
12504: IF NVL(x_return_status,'!') <> OKC_API.G_RET_STS_SUCCESS THEN
12505: RAISE G_EXCEPTION_HALT_VALIDATION;
12506: END IF;
12507:
12508: ----adjust lvl element amt for old cp and top bs

Line 12522: IF NVL(x_return_status,'!') <> OKC_API.G_RET_STS_SUCCESS THEN

12518: 'Adjust_billed_lvl_element(x_return_status = '||x_return_status
12519: ||', l_cp_old_bs_tbl count = '||l_cp_old_bs_tbl.count||')');
12520: END IF;
12521:
12522: IF NVL(x_return_status,'!') <> OKC_API.G_RET_STS_SUCCESS THEN
12523: RAISE G_EXCEPTION_HALT_VALIDATION;
12524: END IF;
12525:
12526:

Line 12546: IF NVL(x_return_status,'!') <> OKC_API.G_RET_STS_SUCCESS THEN

12542: 'oks_bill_util_pub.adjust_split_bill_rec(x_return_status = '||x_return_status
12543: ||'old line id = ' || l_old_cp_rec.cp_id || ')');
12544: END IF;
12545:
12546: IF NVL(x_return_status,'!') <> OKC_API.G_RET_STS_SUCCESS THEN
12547: ----errorout_aD('ADJUST_SPLIT_BILL_REC ststaus = ' || x_return_status);
12548: RAISE G_EXCEPTION_HALT_VALIDATION;
12549: END IF;
12550:

Line 12620: IF NVL(x_return_status,'!') <> OKC_API.G_RET_STS_SUCCESS THEN

12616: 'Create_cp_lvl_elements(x_return_status = '||x_return_status
12617: ||', l_top_bs_tbl count = '||l_top_bs_tbl.count||')');
12618: END IF;
12619:
12620: IF NVL(x_return_status,'!') <> OKC_API.G_RET_STS_SUCCESS THEN
12621: RAISE G_EXCEPTION_HALT_VALIDATION;
12622: END IF;
12623:
12624:

Line 12660: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,

12656: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.adjust_split_bill_sch.UNEXPECTED',
12657: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
12658: END IF;
12659:
12660: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
12661: p_msg_name => G_UNEXPECTED_ERROR,
12662: p_token1 => G_SQLCODE_TOKEN,
12663: p_token1_value => sqlcode,
12664: p_token2 => G_SQLERRM_TOKEN,

Line 12686: x_return_status := OKC_API.G_RET_STS_SUCCESS;

12682: l_amt NUMBER;
12683:
12684: BEGIN
12685:
12686: x_return_status := OKC_API.G_RET_STS_SUCCESS;
12687:
12688: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
12689:
12690: fnd_log.STRING (fnd_log.level_statement,

Line 12734: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,

12730: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.Prorate_sll_amt.UNEXPECTED',
12731: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
12732: END IF;
12733:
12734: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
12735: p_msg_name => G_UNEXPECTED_ERROR,
12736: p_token1 => G_SQLCODE_TOKEN,
12737: p_token1_value => sqlcode,
12738: p_token2 => G_SQLERRM_TOKEN,

Line 12766: x_return_status := OKC_API.G_RET_STS_SUCCESS;

12762: l_index NUMBER;
12763:
12764: BEGIN
12765:
12766: x_return_status := OKC_API.G_RET_STS_SUCCESS;
12767:
12768: l_index := 1;
12769: x_new_cp_bs_tbl.DELETE;
12770:

Line 12827: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,

12823: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.Adjust_billed_lvl_element.UNEXPECTED',
12824: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
12825: END IF;
12826:
12827: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
12828: p_msg_name => G_UNEXPECTED_ERROR,
12829: p_token1 => G_SQLCODE_TOKEN,
12830: p_token1_value => sqlcode,
12831: p_token2 => G_SQLERRM_TOKEN,

Line 12918: l_init_msg_list VARCHAR2(2000) := OKC_API.G_FALSE;

12914: l_cp_bs_ind NUMBER;
12915: l_top_bs_ind NUMBER;
12916:
12917: l_api_Version Number := 1;
12918: l_init_msg_list VARCHAR2(2000) := OKC_API.G_FALSE;
12919: l_msg_list VARCHAR2(1) DEFAULT OKC_API.G_FALSE;
12920: l_msg_count Number;
12921: l_msg_data Varchar2(2000) := NULL;
12922:

Line 12919: l_msg_list VARCHAR2(1) DEFAULT OKC_API.G_FALSE;

12915: l_top_bs_ind NUMBER;
12916:
12917: l_api_Version Number := 1;
12918: l_init_msg_list VARCHAR2(2000) := OKC_API.G_FALSE;
12919: l_msg_list VARCHAR2(1) DEFAULT OKC_API.G_FALSE;
12920: l_msg_count Number;
12921: l_msg_data Varchar2(2000) := NULL;
12922:
12923: l_top_line_id Number;

Line 12976: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'BILLING SCHEDULE TYPE NOT FOUND.');

12972:
12973: If l_bill_type_csr%Notfound then
12974: Close l_bill_type_Csr;
12975: x_return_status := 'E';
12976: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'BILLING SCHEDULE TYPE NOT FOUND.');
12977: RAISE G_EXCEPTION_HALT_VALIDATION;
12978: End If;
12979:
12980: Close l_bill_type_Csr;

Line 13068: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

13064: x_msg_data => l_msg_data,
13065: p_letv_tbl => l_top_bs_tbl,
13066: x_letv_tbl => l_lvl_ele_tbl_out);
13067:
13068: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
13069: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
13070: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
13071: RAISE OKC_API.G_EXCEPTION_ERROR;
13072: END IF;

Line 13069: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

13065: p_letv_tbl => l_top_bs_tbl,
13066: x_letv_tbl => l_lvl_ele_tbl_out);
13067:
13068: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
13069: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
13070: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
13071: RAISE OKC_API.G_EXCEPTION_ERROR;
13072: END IF;
13073:

Line 13070: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN

13066: x_letv_tbl => l_lvl_ele_tbl_out);
13067:
13068: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
13069: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
13070: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
13071: RAISE OKC_API.G_EXCEPTION_ERROR;
13072: END IF;
13073:
13074: END IF; ---l_cp_bs_tbl.COUNT > 0

Line 13071: RAISE OKC_API.G_EXCEPTION_ERROR;

13067:
13068: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
13069: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
13070: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
13071: RAISE OKC_API.G_EXCEPTION_ERROR;
13072: END IF;
13073:
13074: END IF; ---l_cp_bs_tbl.COUNT > 0
13075:

Line 13291: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

13287: x_return_status => l_return_status,
13288: x_quantity => l_uom_quantity ,
13289: x_timeunit => l_tce_code);
13290:
13291: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
13292: RAISE G_EXCEPTION_HALT_VALIDATION;
13293: END IF;
13294:
13295:

Line 13487: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

13483: x_return_status => l_return_status);
13484:
13485:
13486: -----errorout_ad('Get_Period_Frequency = ' || l_return_status);
13487: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
13488: RAISE G_EXCEPTION_HALT_VALIDATION;
13489: END IF;
13490:
13491: l_lvl_amt := (NVL(l_period_freq,0) * NVL(l_constant_sll_amt,0) );

Line 13530: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,

13526: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
13527: END IF;
13528: x_bill_amount := NULL;
13529: x_bill_enddate := NULL;
13530: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
13531: p_msg_name => G_UNEXPECTED_ERROR,
13532: p_token1 => G_SQLCODE_TOKEN,
13533: p_token1_value => sqlcode,
13534: p_token2 => G_SQLERRM_TOKEN,