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 2171: l_strm_lvl_tbl_in(1).object_version_number := OKC_API.G_MISS_NUM;

2167: l_strm_lvl_tbl_in(1).invoice_offset_days := p_strm_lvl_tbl(l_tbl_count).invoice_offset_days;
2168: l_strm_lvl_tbl_in(1).interface_offset_days := p_strm_lvl_tbl(l_tbl_count).interface_offset_days;
2169:
2170:
2171: l_strm_lvl_tbl_in(1).object_version_number := OKC_API.G_MISS_NUM;
2172: l_strm_lvl_tbl_in(1).created_by := OKC_API.G_MISS_NUM;
2173: l_strm_lvl_tbl_in(1).creation_date := SYSDATE;
2174: l_strm_lvl_tbl_in(1).last_updated_by := OKC_API.G_MISS_NUM;
2175: l_strm_lvl_tbl_in(1).last_update_date := SYSDATE;

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

2168: l_strm_lvl_tbl_in(1).interface_offset_days := p_strm_lvl_tbl(l_tbl_count).interface_offset_days;
2169:
2170:
2171: l_strm_lvl_tbl_in(1).object_version_number := OKC_API.G_MISS_NUM;
2172: l_strm_lvl_tbl_in(1).created_by := OKC_API.G_MISS_NUM;
2173: l_strm_lvl_tbl_in(1).creation_date := SYSDATE;
2174: l_strm_lvl_tbl_in(1).last_updated_by := OKC_API.G_MISS_NUM;
2175: l_strm_lvl_tbl_in(1).last_update_date := SYSDATE;
2176:

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

2170:
2171: l_strm_lvl_tbl_in(1).object_version_number := OKC_API.G_MISS_NUM;
2172: l_strm_lvl_tbl_in(1).created_by := OKC_API.G_MISS_NUM;
2173: l_strm_lvl_tbl_in(1).creation_date := SYSDATE;
2174: l_strm_lvl_tbl_in(1).last_updated_by := OKC_API.G_MISS_NUM;
2175: l_strm_lvl_tbl_in(1).last_update_date := SYSDATE;
2176:
2177: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2178:

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

2212: -----errorout_ad('SllCREATED : '|| x_return_status);
2213: -----errorout_ad('sll id = ' || l_strm_lvl_tbl_in(1));
2214:
2215:
2216: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2217: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2218: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2219: RAISE OKC_API.G_EXCEPTION_ERROR;
2220: END IF;

Line 2217: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2213: -----errorout_ad('sll id = ' || l_strm_lvl_tbl_in(1));
2214:
2215:
2216: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2217: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2218: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2219: RAISE OKC_API.G_EXCEPTION_ERROR;
2220: END IF;
2221:

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

2214:
2215:
2216: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2217: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2218: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2219: RAISE OKC_API.G_EXCEPTION_ERROR;
2220: END IF;
2221:
2222: ELSE --sll id not null

Line 2219: RAISE OKC_API.G_EXCEPTION_ERROR;

2215:
2216: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2217: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2218: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2219: RAISE OKC_API.G_EXCEPTION_ERROR;
2220: END IF;
2221:
2222: ELSE --sll id not null
2223: l_strm_lvl_tbl_in(1).id := l_sll_id;

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

2240:
2241: -----errorout_ad('STREAM LEVEL RULE updated : '|| x_return_status);
2242:
2243:
2244: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2245: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2246: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2247: RAISE OKC_API.G_EXCEPTION_ERROR;
2248: END IF;

Line 2245: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2241: -----errorout_ad('STREAM LEVEL RULE updated : '|| x_return_status);
2242:
2243:
2244: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2245: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2246: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2247: RAISE OKC_API.G_EXCEPTION_ERROR;
2248: END IF;
2249:

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

2242:
2243:
2244: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2245: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2246: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2247: RAISE OKC_API.G_EXCEPTION_ERROR;
2248: END IF;
2249:
2250: END IF;

Line 2247: RAISE OKC_API.G_EXCEPTION_ERROR;

2243:
2244: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2245: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2246: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2247: RAISE OKC_API.G_EXCEPTION_ERROR;
2248: END IF;
2249:
2250: END IF;
2251:

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

2323:
2324: -----errorout_ad ('Get_sll_amount STATUS = ' || x_return_status);
2325:
2326:
2327: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2328: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2329: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2330: RAISE OKC_API.G_EXCEPTION_ERROR;
2331: END IF;

Line 2328: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2324: -----errorout_ad ('Get_sll_amount STATUS = ' || x_return_status);
2325:
2326:
2327: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2328: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2329: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2330: RAISE OKC_API.G_EXCEPTION_ERROR;
2331: END IF;
2332:

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

2325:
2326:
2327: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2328: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2329: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2330: RAISE OKC_API.G_EXCEPTION_ERROR;
2331: END IF;
2332:
2333: FOR l_index IN l_sll_prorate_tbl.FIRST .. l_sll_prorate_tbl.LAST

Line 2330: RAISE OKC_API.G_EXCEPTION_ERROR;

2326:
2327: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2328: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2329: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2330: RAISE OKC_API.G_EXCEPTION_ERROR;
2331: END IF;
2332:
2333: FOR l_index IN l_sll_prorate_tbl.FIRST .. l_sll_prorate_tbl.LAST
2334: LOOP

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

2356: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.Create_Stream_Level.UNEXPECTED',
2357: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
2358: END IF;
2359:
2360: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
2361: p_msg_name => G_UNEXPECTED_ERROR,
2362: p_token1 => G_SQLCODE_TOKEN,
2363: p_token1_value => sqlcode,
2364: p_token2 => G_SQLERRM_TOKEN,

Line 2504: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

2500: END IF;
2501:
2502: -------------errorout_ad('SLL Record FOR SUBLINE = ' || TO_CHAR(l_cp_sll_out_tbl.count));
2503: ----if l_cp_sll_out_tbl.count > 0 then insert lines into oks_level_elements_v
2504: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
2505: RAISE G_EXCEPTION_HALT_VALIDATION;
2506: END IF;
2507:
2508:

Line 2534: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

2530: 'Create_cp_lvl_elements(x_return_status = '||x_return_status
2531: ||', p_term_dt passed = '|| p_term_dt ||')');
2532: END IF;
2533:
2534: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
2535: RAISE G_EXCEPTION_HALT_VALIDATION;
2536: END IF;
2537:
2538: EXCEPTION

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

2541: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.bill_sch_cp.EXCEPTION',
2542: 'G_EXCEPTION_HALT_VALIDATION');
2543: END IF;
2544:
2545: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2546: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2547: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2548: RAISE OKC_API.G_EXCEPTION_ERROR;
2549: END IF;

Line 2546: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2542: 'G_EXCEPTION_HALT_VALIDATION');
2543: END IF;
2544:
2545: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2546: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2547: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2548: RAISE OKC_API.G_EXCEPTION_ERROR;
2549: END IF;
2550: WHEN OTHERS THEN

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

2543: END IF;
2544:
2545: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2546: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2547: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2548: RAISE OKC_API.G_EXCEPTION_ERROR;
2549: END IF;
2550: WHEN OTHERS THEN
2551:

Line 2548: RAISE OKC_API.G_EXCEPTION_ERROR;

2544:
2545: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2546: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2547: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2548: RAISE OKC_API.G_EXCEPTION_ERROR;
2549: END IF;
2550: WHEN OTHERS THEN
2551:
2552: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN

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

2553: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.bill_sch_Cp.UNEXPECTED',
2554: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
2555: END IF;
2556:
2557: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
2558: p_msg_name => G_UNEXPECTED_ERROR,
2559: p_token1 => G_SQLCODE_TOKEN,
2560: p_token1_value => sqlcode,
2561: p_token2 => G_SQLERRM_TOKEN,

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

3091: l_last_cmp_date DATE;
3092: --------------------------------------------------------------------------
3093: --
3094: l_api_version CONSTANT NUMBER := 1.0;
3095: l_init_msg_list VARCHAR2(2000) := OKC_API.G_FALSE;
3096: l_return_status VARCHAR2(10);
3097: l_msg_count NUMBER;
3098: l_msg_data VARCHAR2(2000);
3099: l_msg_index_out NUMBER;

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

3169: END IF;
3170:
3171: -----errorout_ad('Delete_lvl_element status = ' || x_return_status);
3172:
3173: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3174: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3175: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3176: RAISE OKC_API.G_EXCEPTION_ERROR;
3177: END IF;

Line 3174: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

3170:
3171: -----errorout_ad('Delete_lvl_element status = ' || x_return_status);
3172:
3173: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3174: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3175: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3176: RAISE OKC_API.G_EXCEPTION_ERROR;
3177: END IF;
3178: END IF;

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

3171: -----errorout_ad('Delete_lvl_element status = ' || x_return_status);
3172:
3173: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3174: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3175: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3176: RAISE OKC_API.G_EXCEPTION_ERROR;
3177: END IF;
3178: END IF;
3179:

Line 3176: RAISE OKC_API.G_EXCEPTION_ERROR;

3172:
3173: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3174: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3175: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3176: RAISE OKC_API.G_EXCEPTION_ERROR;
3177: END IF;
3178: END IF;
3179:
3180: ---if (line terminated - 1) < line_start_dt

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

3218:
3219: -----errorout_ad('LEVEL ELEMENT COUNTER = ' || TO_CHAR(l_period_counter));
3220: -----errorout_ad('LEVEL ELEMENT START DATE = ' || to_char(l_next_cycle_dt));
3221:
3222: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3223: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3224: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3225: RAISE OKC_API.G_EXCEPTION_ERROR;
3226: END IF;

Line 3223: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

3219: -----errorout_ad('LEVEL ELEMENT COUNTER = ' || TO_CHAR(l_period_counter));
3220: -----errorout_ad('LEVEL ELEMENT START DATE = ' || to_char(l_next_cycle_dt));
3221:
3222: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3223: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3224: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3225: RAISE OKC_API.G_EXCEPTION_ERROR;
3226: END IF;
3227: l_lvl_loop_counter := l_period_counter;

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

3220: -----errorout_ad('LEVEL ELEMENT START DATE = ' || to_char(l_next_cycle_dt));
3221:
3222: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3223: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3224: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3225: RAISE OKC_API.G_EXCEPTION_ERROR;
3226: END IF;
3227: l_lvl_loop_counter := l_period_counter;
3228: END IF;

Line 3225: RAISE OKC_API.G_EXCEPTION_ERROR;

3221:
3222: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3223: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3224: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3225: RAISE OKC_API.G_EXCEPTION_ERROR;
3226: END IF;
3227: l_lvl_loop_counter := l_period_counter;
3228: END IF;
3229:

Line 3292: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

3288: ||', x_timeunit = ' || l_tce_code
3289: ||', x_quantity = '|| l_uom_quantity ||')');
3290: END IF;
3291:
3292: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
3293: RAISE G_EXCEPTION_HALT_VALIDATION;
3294: END IF;
3295:
3296: l_remaining_amt := nvl(l_line_amt,0) - nvl(l_bill_sch_amt,0);

Line 3317: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

3313: ||', sll amt = ' || l_constant_sll_amt
3314: ||', l_remaining_amt passed = '|| l_remaining_amt ||')');
3315: END IF;
3316:
3317: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
3318: RAISE G_EXCEPTION_HALT_VALIDATION;
3319: END IF;
3320: END IF; ---end of lse_id = 46
3321:

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

3393:
3394:
3395: -----errorout_ad('LEVEL ELEMENT NEXT CYCLE DATE passed from Get_next_bill_sch = ' || TO_CHAR(l_fnd_lvl_out_rec.next_cycle_date));
3396:
3397: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3398: -----errorout_ad(' OKS_BILL_UTIL_PUB.Get_next_bill_sch = ' || l_msg_data);
3399: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3400: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3401: -----errorout_ad(' OKS_BILL_UTIL_PUB.Get_next_bill_sch = ' || l_msg_data);

Line 3399: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

3395: -----errorout_ad('LEVEL ELEMENT NEXT CYCLE DATE passed from Get_next_bill_sch = ' || TO_CHAR(l_fnd_lvl_out_rec.next_cycle_date));
3396:
3397: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3398: -----errorout_ad(' OKS_BILL_UTIL_PUB.Get_next_bill_sch = ' || l_msg_data);
3399: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3400: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3401: -----errorout_ad(' OKS_BILL_UTIL_PUB.Get_next_bill_sch = ' || l_msg_data);
3402: RAISE OKC_API.G_EXCEPTION_ERROR;
3403: END IF;

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

3396:
3397: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3398: -----errorout_ad(' OKS_BILL_UTIL_PUB.Get_next_bill_sch = ' || l_msg_data);
3399: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3400: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3401: -----errorout_ad(' OKS_BILL_UTIL_PUB.Get_next_bill_sch = ' || l_msg_data);
3402: RAISE OKC_API.G_EXCEPTION_ERROR;
3403: END IF;
3404:

Line 3402: RAISE OKC_API.G_EXCEPTION_ERROR;

3398: -----errorout_ad(' OKS_BILL_UTIL_PUB.Get_next_bill_sch = ' || l_msg_data);
3399: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3400: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3401: -----errorout_ad(' OKS_BILL_UTIL_PUB.Get_next_bill_sch = ' || l_msg_data);
3402: RAISE OKC_API.G_EXCEPTION_ERROR;
3403: END IF;
3404:
3405:
3406: IF p_period_start is not null AND

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

3547: end if;
3548:
3549: l_lvl_ele_tbl_in(l_tbl_seq).rul_id := p_sll_tbl(l_line_sll_counter).id;
3550:
3551: l_lvl_ele_tbl_in(l_tbl_seq).object_version_number := OKC_API.G_MISS_NUM;
3552: l_lvl_ele_tbl_in(l_tbl_seq).created_by := OKC_API.G_MISS_NUM;
3553: l_lvl_ele_tbl_in(l_tbl_seq).creation_date := SYSDATE;
3554: l_lvl_ele_tbl_in(l_tbl_seq).last_updated_by := OKC_API.G_MISS_NUM;
3555: l_lvl_ele_tbl_in(l_tbl_seq).last_update_date := SYSDATE;

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

3548:
3549: l_lvl_ele_tbl_in(l_tbl_seq).rul_id := p_sll_tbl(l_line_sll_counter).id;
3550:
3551: l_lvl_ele_tbl_in(l_tbl_seq).object_version_number := OKC_API.G_MISS_NUM;
3552: l_lvl_ele_tbl_in(l_tbl_seq).created_by := OKC_API.G_MISS_NUM;
3553: l_lvl_ele_tbl_in(l_tbl_seq).creation_date := SYSDATE;
3554: l_lvl_ele_tbl_in(l_tbl_seq).last_updated_by := OKC_API.G_MISS_NUM;
3555: l_lvl_ele_tbl_in(l_tbl_seq).last_update_date := SYSDATE;
3556:

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

3550:
3551: l_lvl_ele_tbl_in(l_tbl_seq).object_version_number := OKC_API.G_MISS_NUM;
3552: l_lvl_ele_tbl_in(l_tbl_seq).created_by := OKC_API.G_MISS_NUM;
3553: l_lvl_ele_tbl_in(l_tbl_seq).creation_date := SYSDATE;
3554: l_lvl_ele_tbl_in(l_tbl_seq).last_updated_by := OKC_API.G_MISS_NUM;
3555: l_lvl_ele_tbl_in(l_tbl_seq).last_update_date := SYSDATE;
3556:
3557:
3558: -----errorout_ad ('Amount for line lvl element = ' || to_char(l_lvl_ele_tbl_in(l_tbl_seq).amount ));

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

3658:
3659: -----errorout_ad('LEVEL ELEMENT INSERT STATUS line = ' || x_return_status);
3660:
3661:
3662: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3663: -----errorout_ad('OKS_BILL_LEVEL_ELEMENTS_PVT.insert_row for line = ' || l_msg_data);
3664: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3665: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3666: -----errorout_ad('OKS_BILL_LEVEL_ELEMENTS_PVT.insert_row for line = ' || l_msg_data);

Line 3664: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

3660:
3661:
3662: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3663: -----errorout_ad('OKS_BILL_LEVEL_ELEMENTS_PVT.insert_row for line = ' || l_msg_data);
3664: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3665: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3666: -----errorout_ad('OKS_BILL_LEVEL_ELEMENTS_PVT.insert_row for line = ' || l_msg_data);
3667: RAISE OKC_API.G_EXCEPTION_ERROR;
3668: END IF;

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

3661:
3662: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3663: -----errorout_ad('OKS_BILL_LEVEL_ELEMENTS_PVT.insert_row for line = ' || l_msg_data);
3664: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3665: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3666: -----errorout_ad('OKS_BILL_LEVEL_ELEMENTS_PVT.insert_row for line = ' || l_msg_data);
3667: RAISE OKC_API.G_EXCEPTION_ERROR;
3668: END IF;
3669: END IF;

Line 3667: RAISE OKC_API.G_EXCEPTION_ERROR;

3663: -----errorout_ad('OKS_BILL_LEVEL_ELEMENTS_PVT.insert_row for line = ' || l_msg_data);
3664: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3665: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3666: -----errorout_ad('OKS_BILL_LEVEL_ELEMENTS_PVT.insert_row for line = ' || l_msg_data);
3667: RAISE OKC_API.G_EXCEPTION_ERROR;
3668: END IF;
3669: END IF;
3670:
3671:

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

3677: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN
3678: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.Create_Level_elements.UNEXPECTED',
3679: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
3680: END IF;
3681: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
3682: p_msg_name => G_UNEXPECTED_ERROR,
3683: p_token1 => G_SQLCODE_TOKEN,
3684: p_token1_value => sqlcode,
3685: p_token2 => G_SQLERRM_TOKEN,

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

3715: l_bill_type VARCHAR2(10);
3716:
3717: --
3718: l_api_version CONSTANT NUMBER := 1.0;
3719: l_init_msg_list VARCHAR2(2000) := OKC_API.G_FALSE;
3720: l_return_status VARCHAR2(10);
3721: l_msg_count NUMBER;
3722: l_msg_data VARCHAR2(2000);
3723: l_msg_index_out NUMBER;

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

3753: ||', p_hdr_id passed = '||p_hdr_rec.id ||')');
3754: END IF;
3755:
3756: -----errorout_ad('Del_hdr_lvl_element status = ' || x_return_status);
3757: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3758: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3759: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3760: RAISE OKC_API.G_EXCEPTION_ERROR;
3761: END IF;

Line 3758: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

3754: END IF;
3755:
3756: -----errorout_ad('Del_hdr_lvl_element status = ' || x_return_status);
3757: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3758: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3759: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3760: RAISE OKC_API.G_EXCEPTION_ERROR;
3761: END IF;
3762: END IF;

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

3755:
3756: -----errorout_ad('Del_hdr_lvl_element status = ' || x_return_status);
3757: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3758: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3759: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3760: RAISE OKC_API.G_EXCEPTION_ERROR;
3761: END IF;
3762: END IF;
3763:

Line 3760: RAISE OKC_API.G_EXCEPTION_ERROR;

3756: -----errorout_ad('Del_hdr_lvl_element status = ' || x_return_status);
3757: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3758: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3759: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3760: RAISE OKC_API.G_EXCEPTION_ERROR;
3761: END IF;
3762: END IF;
3763:
3764:

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

3820: END IF;
3821:
3822: -----errorout_ad('hdr Get_next_bill_sch status = ' || x_return_status);
3823:
3824: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3825: -----errorout_ad(' OKS_BILL_UTIL_PUB.Get_next_bill_sch = ' || l_fnd_msg_data);
3826: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3827: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3828: -----errorout_ad(' OKS_BILL_UTIL_PUB.Get_next_bill_sch = ' || l_fnd_msg_data);

Line 3826: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

3822: -----errorout_ad('hdr Get_next_bill_sch status = ' || x_return_status);
3823:
3824: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3825: -----errorout_ad(' OKS_BILL_UTIL_PUB.Get_next_bill_sch = ' || l_fnd_msg_data);
3826: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3827: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3828: -----errorout_ad(' OKS_BILL_UTIL_PUB.Get_next_bill_sch = ' || l_fnd_msg_data);
3829: RAISE OKC_API.G_EXCEPTION_ERROR;
3830: END IF;

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

3823:
3824: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3825: -----errorout_ad(' OKS_BILL_UTIL_PUB.Get_next_bill_sch = ' || l_fnd_msg_data);
3826: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3827: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3828: -----errorout_ad(' OKS_BILL_UTIL_PUB.Get_next_bill_sch = ' || l_fnd_msg_data);
3829: RAISE OKC_API.G_EXCEPTION_ERROR;
3830: END IF;
3831:

Line 3829: RAISE OKC_API.G_EXCEPTION_ERROR;

3825: -----errorout_ad(' OKS_BILL_UTIL_PUB.Get_next_bill_sch = ' || l_fnd_msg_data);
3826: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3827: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3828: -----errorout_ad(' OKS_BILL_UTIL_PUB.Get_next_bill_sch = ' || l_fnd_msg_data);
3829: RAISE OKC_API.G_EXCEPTION_ERROR;
3830: END IF;
3831:
3832:
3833:

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

3861: l_lvl_ele_tbl_in(l_tbl_seq).date_to_interface := TRUNC(l_fnd_lvl_out_rec.date_to_interface);
3862: l_lvl_ele_tbl_in(l_tbl_seq).date_completed := l_fnd_lvl_out_rec.date_completed;
3863: l_lvl_ele_tbl_in(l_tbl_seq).rul_id := p_sll_tbl(l_sll_counter).id;
3864:
3865: l_lvl_ele_tbl_in(l_tbl_seq).object_version_number := OKC_API.G_MISS_NUM;
3866: l_lvl_ele_tbl_in(l_tbl_seq).created_by := OKC_API.G_MISS_NUM;
3867: l_lvl_ele_tbl_in(l_tbl_seq).creation_date := SYSDATE;
3868: l_lvl_ele_tbl_in(l_tbl_seq).last_updated_by := OKC_API.G_MISS_NUM;
3869: l_lvl_ele_tbl_in(l_tbl_seq).last_update_date := SYSDATE;

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

3862: l_lvl_ele_tbl_in(l_tbl_seq).date_completed := l_fnd_lvl_out_rec.date_completed;
3863: l_lvl_ele_tbl_in(l_tbl_seq).rul_id := p_sll_tbl(l_sll_counter).id;
3864:
3865: l_lvl_ele_tbl_in(l_tbl_seq).object_version_number := OKC_API.G_MISS_NUM;
3866: l_lvl_ele_tbl_in(l_tbl_seq).created_by := OKC_API.G_MISS_NUM;
3867: l_lvl_ele_tbl_in(l_tbl_seq).creation_date := SYSDATE;
3868: l_lvl_ele_tbl_in(l_tbl_seq).last_updated_by := OKC_API.G_MISS_NUM;
3869: l_lvl_ele_tbl_in(l_tbl_seq).last_update_date := SYSDATE;
3870:

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

3864:
3865: l_lvl_ele_tbl_in(l_tbl_seq).object_version_number := OKC_API.G_MISS_NUM;
3866: l_lvl_ele_tbl_in(l_tbl_seq).created_by := OKC_API.G_MISS_NUM;
3867: l_lvl_ele_tbl_in(l_tbl_seq).creation_date := SYSDATE;
3868: l_lvl_ele_tbl_in(l_tbl_seq).last_updated_by := OKC_API.G_MISS_NUM;
3869: l_lvl_ele_tbl_in(l_tbl_seq).last_update_date := SYSDATE;
3870:
3871: l_tbl_seq := l_tbl_seq + 1;
3872:

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

3909:
3910: -----errorout_ad('LEVEL ELEMENT INSERT STATUS = ' || x_return_status);
3911:
3912:
3913: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3914: -----errorout_ad('OKS_BILL_LEVEL_ELEMENTS_PVT.insert_row = ' || l__msg_data);
3915: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3916: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3917: -----errorout_ad('OKS_BILL_LEVEL_ELEMENTS_PVT.insert_row = ' || l_msg_data);

Line 3915: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

3911:
3912:
3913: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3914: -----errorout_ad('OKS_BILL_LEVEL_ELEMENTS_PVT.insert_row = ' || l__msg_data);
3915: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3916: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3917: -----errorout_ad('OKS_BILL_LEVEL_ELEMENTS_PVT.insert_row = ' || l_msg_data);
3918: RAISE OKC_API.G_EXCEPTION_ERROR;
3919: END IF;

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

3912:
3913: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3914: -----errorout_ad('OKS_BILL_LEVEL_ELEMENTS_PVT.insert_row = ' || l__msg_data);
3915: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3916: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3917: -----errorout_ad('OKS_BILL_LEVEL_ELEMENTS_PVT.insert_row = ' || l_msg_data);
3918: RAISE OKC_API.G_EXCEPTION_ERROR;
3919: END IF;
3920: END IF;

Line 3918: RAISE OKC_API.G_EXCEPTION_ERROR;

3914: -----errorout_ad('OKS_BILL_LEVEL_ELEMENTS_PVT.insert_row = ' || l__msg_data);
3915: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3916: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3917: -----errorout_ad('OKS_BILL_LEVEL_ELEMENTS_PVT.insert_row = ' || l_msg_data);
3918: RAISE OKC_API.G_EXCEPTION_ERROR;
3919: END IF;
3920: END IF;
3921:
3922:

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

3926: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN
3927: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.create_hdr_level_elements.UNEXPECTED',
3928: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
3929: END IF;
3930: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
3931: p_msg_name => G_UNEXPECTED_ERROR,
3932: p_token1 => G_SQLCODE_TOKEN,
3933: p_token1_value => sqlcode,
3934: p_token2 => G_SQLERRM_TOKEN,

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

4032:
4033: l_return_status VARCHAR2(10);
4034: l_msg_count NUMBER;
4035: l_msg_data VARCHAR2(2000);
4036: l_init_msg_list VARCHAR2(2000) := OKC_API.G_FALSE;
4037:
4038: l_sll_prorate_tbl sll_prorated_tab_type;
4039: -------------------------------------------------------------------------
4040: -- Begin partial period computation logic

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

4129: l_currency_code := Find_Currency_Code(
4130: p_cle_id => p_line_id,
4131: p_chr_id => NULL);
4132: IF l_currency_code IS NULL THEN
4133: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'CURRENCY CODE NOT FOUND.');
4134: x_return_status := 'E';
4135: RETURN;
4136: END IF;
4137: END IF; ---currency code null

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

4182: l_strm_lvl_tbl_in(l_Sll_Counter).invoice_offset_days := l_Line_Sll_Csr_Rec.invoice_offset_days;
4183: l_strm_lvl_tbl_in(l_Sll_Counter).interface_offset_days := l_Line_Sll_Csr_Rec.interface_offset_days;
4184: l_strm_lvl_tbl_in(l_Sll_Counter).object_version_number := l_Line_Sll_Csr_Rec.object_version_number;
4185:
4186: l_strm_lvl_tbl_in(l_Sll_Counter).created_by := OKC_API.G_MISS_NUM;
4187: l_strm_lvl_tbl_in(l_Sll_Counter).creation_date := SYSDATE;
4188: l_strm_lvl_tbl_in(l_Sll_Counter).last_updated_by := OKC_API.G_MISS_NUM;
4189: l_strm_lvl_tbl_in(l_Sll_Counter).last_update_date := SYSDATE;
4190:

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

4184: l_strm_lvl_tbl_in(l_Sll_Counter).object_version_number := l_Line_Sll_Csr_Rec.object_version_number;
4185:
4186: l_strm_lvl_tbl_in(l_Sll_Counter).created_by := OKC_API.G_MISS_NUM;
4187: l_strm_lvl_tbl_in(l_Sll_Counter).creation_date := SYSDATE;
4188: l_strm_lvl_tbl_in(l_Sll_Counter).last_updated_by := OKC_API.G_MISS_NUM;
4189: l_strm_lvl_tbl_in(l_Sll_Counter).last_update_date := SYSDATE;
4190:
4191:
4192: l_Sll_Counter := l_Sll_Counter + 1;

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

4216:
4217: -----errorout_ad ('Get_sll_amount STATUS = ' || x_return_status);
4218:
4219:
4220: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4221: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4222: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4223: RAISE OKC_API.G_EXCEPTION_ERROR;
4224: END IF;

Line 4221: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

4217: -----errorout_ad ('Get_sll_amount STATUS = ' || x_return_status);
4218:
4219:
4220: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4221: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4222: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4223: RAISE OKC_API.G_EXCEPTION_ERROR;
4224: END IF;
4225:

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

4218:
4219:
4220: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4221: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4222: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4223: RAISE OKC_API.G_EXCEPTION_ERROR;
4224: END IF;
4225:
4226: ---- the output table has index number of sll table to be updated in sll_seq_num field,

Line 4223: RAISE OKC_API.G_EXCEPTION_ERROR;

4219:
4220: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4221: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4222: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4223: RAISE OKC_API.G_EXCEPTION_ERROR;
4224: END IF;
4225:
4226: ---- the output table has index number of sll table to be updated in sll_seq_num field,
4227: ----so just change the amount for the l_rulv_index .

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

4274: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN
4275: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.update_sll_amount.UNEXPECTED',
4276: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
4277: END IF;
4278: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
4279: p_msg_name => G_UNEXPECTED_ERROR,
4280: p_token1 => G_SQLCODE_TOKEN,
4281: p_token1_value => sqlcode,
4282: p_token2 => G_SQLERRM_TOKEN,

Line 4285: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

4281: p_token1_value => sqlcode,
4282: p_token2 => G_SQLERRM_TOKEN,
4283: p_token2_value => sqlerrm);
4284:
4285: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
4286:
4287: END Update_Sll_Amount;
4288:
4289: PROCEDURE Calculate_sll_amount( p_api_version IN NUMBER,

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

4559:
4560:
4561: EXCEPTION
4562: WHEN OTHERS THEN
4563: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
4564: p_msg_name => G_UNEXPECTED_ERROR,
4565: p_token1 => G_SQLCODE_TOKEN,
4566: p_token1_value => sqlcode,
4567: p_token2 => G_SQLERRM_TOKEN,

Line 4570: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

4566: p_token1_value => sqlcode,
4567: p_token2 => G_SQLERRM_TOKEN,
4568: p_token2_value => sqlerrm);
4569:
4570: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
4571:
4572: END Delete_lvl_element;
4573:
4574:

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

4599: AND chr_id IS NULL;
4600:
4601: EXCEPTION
4602: WHEN OTHERS THEN
4603: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
4604: p_msg_name => G_UNEXPECTED_ERROR,
4605: p_token1 => G_SQLCODE_TOKEN,
4606: p_token1_value => sqlcode,
4607: p_token2 => G_SQLERRM_TOKEN,

Line 4610: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

4606: p_token1_value => sqlcode,
4607: p_token2 => G_SQLERRM_TOKEN,
4608: p_token2_value => sqlerrm);
4609:
4610: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
4611:
4612: END Del_hdr_lvl_element;
4613:
4614:

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

4651:
4652: l_return_status VARCHAR2(10);
4653: l_msg_count NUMBER;
4654: l_msg_data VARCHAR2(2000);
4655: l_init_msg_list VARCHAR2(2000) := OKC_API.G_FALSE;
4656:
4657: l_sll_prorate_tbl sll_prorated_tab_type;
4658: -------------------------------------------------------------------------
4659: -- Begin partial period computation logic

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

4711: p_cle_id => NULL,
4712: p_chr_id => p_hdr_id);
4713:
4714: IF l_currency_code IS NULL THEN
4715: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'CURRENCY CODE NOT FOUND.');
4716: x_return_status := 'E';
4717: RETURN;
4718: END IF;
4719: END IF;

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

4771: l_strm_lvl_tbl_in(l_Sll_Counter).invoice_offset_days := l_Sll_Csr_Rec.invoice_offset_days;
4772: l_strm_lvl_tbl_in(l_Sll_Counter).interface_offset_days := l_Sll_Csr_Rec.interface_offset_days;
4773: l_strm_lvl_tbl_in(l_Sll_Counter).object_version_number := l_Sll_Csr_Rec.object_version_number;
4774:
4775: l_strm_lvl_tbl_in(l_Sll_Counter).created_by := OKC_API.G_MISS_NUM;
4776: l_strm_lvl_tbl_in(l_Sll_Counter).creation_date := SYSDATE;
4777: l_strm_lvl_tbl_in(l_Sll_Counter).last_updated_by := OKC_API.G_MISS_NUM;
4778: l_strm_lvl_tbl_in(l_Sll_Counter).last_update_date := SYSDATE;
4779:

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

4773: l_strm_lvl_tbl_in(l_Sll_Counter).object_version_number := l_Sll_Csr_Rec.object_version_number;
4774:
4775: l_strm_lvl_tbl_in(l_Sll_Counter).created_by := OKC_API.G_MISS_NUM;
4776: l_strm_lvl_tbl_in(l_Sll_Counter).creation_date := SYSDATE;
4777: l_strm_lvl_tbl_in(l_Sll_Counter).last_updated_by := OKC_API.G_MISS_NUM;
4778: l_strm_lvl_tbl_in(l_Sll_Counter).last_update_date := SYSDATE;
4779:
4780: l_Sll_Counter := l_Sll_Counter + 1;
4781:

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

4804:
4805: -----errorout_ad ('Get_sll_amount STATUS = ' || x_return_status);
4806:
4807:
4808: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4809: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4810: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
4811: RAISE OKC_API.G_EXCEPTION_ERROR;
4812: END IF;

Line 4809: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

4805: -----errorout_ad ('Get_sll_amount STATUS = ' || x_return_status);
4806:
4807:
4808: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4809: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4810: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
4811: RAISE OKC_API.G_EXCEPTION_ERROR;
4812: END IF;
4813:

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

4806:
4807:
4808: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4809: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4810: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
4811: RAISE OKC_API.G_EXCEPTION_ERROR;
4812: END IF;
4813:
4814: ---- the output table has index number of sll rule table to be updated in sll_seq_num field,

Line 4811: RAISE OKC_API.G_EXCEPTION_ERROR;

4807:
4808: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4809: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4810: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
4811: RAISE OKC_API.G_EXCEPTION_ERROR;
4812: END IF;
4813:
4814: ---- the output table has index number of sll rule table to be updated in sll_seq_num field,
4815: ----so just change the amount for the l_rulv_index .

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

4849:
4850:
4851: EXCEPTION
4852: WHEN OTHERS THEN
4853: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
4854: p_msg_name => G_UNEXPECTED_ERROR,
4855: p_token1 => G_SQLCODE_TOKEN,
4856: p_token1_value => sqlcode,
4857: p_token2 => G_SQLERRM_TOKEN,

Line 4860: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

4856: p_token1_value => sqlcode,
4857: p_token2 => G_SQLERRM_TOKEN,
4858: p_token2_value => sqlerrm);
4859:
4860: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
4861:
4862: END Cal_hdr_Sll_Amount;
4863:
4864: PROCEDURE Get_Constant_sll_Amount(p_line_start_date IN DATE,

Line 4877: x_return_status := OKC_API.G_RET_STS_SUCCESS;

4873:
4874: l_frequency NUMBER;
4875:
4876: BEGIN
4877: x_return_status := OKC_API.G_RET_STS_SUCCESS;
4878: -----errorout_ad('p_tce_code = ' || p_tce_code);
4879: -----errorout_ad('p_uom_quantity = ' || p_uom_quantity);
4880:
4881: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 4916: If x_return_status <> OKC_API.G_RET_STS_SUCCESS Then

4912: 'oks_bill_util_pub.get_frequency(x_return_status = '||x_return_status
4913: ||', l_frequency = '|| l_frequency ||')');
4914: END IF;
4915:
4916: If x_return_status <> OKC_API.G_RET_STS_SUCCESS Then
4917: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'GET_FREQUENCY FAILED.');
4918: x_return_status := OKC_API.G_RET_STS_ERROR;
4919: RETURN;
4920: End if;

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

4913: ||', l_frequency = '|| l_frequency ||')');
4914: END IF;
4915:
4916: If x_return_status <> OKC_API.G_RET_STS_SUCCESS Then
4917: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'GET_FREQUENCY FAILED.');
4918: x_return_status := OKC_API.G_RET_STS_ERROR;
4919: RETURN;
4920: End if;
4921:

Line 4918: x_return_status := OKC_API.G_RET_STS_ERROR;

4914: END IF;
4915:
4916: If x_return_status <> OKC_API.G_RET_STS_SUCCESS Then
4917: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'GET_FREQUENCY FAILED.');
4918: x_return_status := OKC_API.G_RET_STS_ERROR;
4919: RETURN;
4920: End if;
4921:
4922: -----errorout_ad('p_remaining_amount = ' || p_remaining_amount);

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

4931: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN
4932: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.get_constant_sll_amount.UNEXPECTED',
4933: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
4934: END IF;
4935: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
4936: p_msg_name => G_UNEXPECTED_ERROR,
4937: p_token1 => G_SQLCODE_TOKEN,
4938: p_token1_value => sqlcode,
4939: p_token2 => G_SQLERRM_TOKEN,

Line 4958: x_return_status := OKC_API.G_RET_STS_SUCCESS;

4954: x_return_status OUT NOCOPY VARCHAR2)
4955: IS
4956:
4957: BEGIN
4958: x_return_status := OKC_API.G_RET_STS_SUCCESS;
4959: If p_line_start_date > p_cycle_start_date and p_line_start_date < P_next_billing_date Then
4960: x_period_freq := OKS_BILL_UTIL_PUB.get_frequency
4961: (p_tce_code => p_tce_code,
4962: p_fr_start_date => p_line_start_date,

Line 4988: If x_return_status <> OKC_API.G_RET_STS_SUCCESS Then

4984: 'oks_bill_util_pub.get_frequency(x_return_status = '||x_return_status
4985: ||', x_period_freq = '|| x_period_freq ||')');
4986: END IF;
4987:
4988: If x_return_status <> OKC_API.G_RET_STS_SUCCESS Then
4989: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'GET_FREQUENCY FAILED.');
4990: x_return_status := OKC_API.G_RET_STS_ERROR;
4991: RETURN;
4992: End if;

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

4985: ||', x_period_freq = '|| x_period_freq ||')');
4986: END IF;
4987:
4988: If x_return_status <> OKC_API.G_RET_STS_SUCCESS Then
4989: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'GET_FREQUENCY FAILED.');
4990: x_return_status := OKC_API.G_RET_STS_ERROR;
4991: RETURN;
4992: End if;
4993:

Line 4990: x_return_status := OKC_API.G_RET_STS_ERROR;

4986: END IF;
4987:
4988: If x_return_status <> OKC_API.G_RET_STS_SUCCESS Then
4989: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'GET_FREQUENCY FAILED.');
4990: x_return_status := OKC_API.G_RET_STS_ERROR;
4991: RETURN;
4992: End if;
4993:
4994: EXCEPTION

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

4997: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN
4998: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.get_period_frequency.UNEXPECTED',
4999: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
5000: END IF;
5001: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
5002: p_msg_name => G_UNEXPECTED_ERROR,
5003: p_token1 => G_SQLCODE_TOKEN,
5004: p_token1_value => sqlcode,
5005: p_token2 => G_SQLERRM_TOKEN,

Line 5028: x_return_status := OKC_API.G_RET_STS_SUCCESS;

5024: l_sll_amt NUMBER := 0;
5025:
5026: BEGIN
5027:
5028: x_return_status := OKC_API.G_RET_STS_SUCCESS;
5029:
5030: SELECT NVL(SUM(AMOUNT),0) INTO l_sll_amt
5031: FROM OKS_LEVEL_ELEMENTS
5032: WHERE rul_id = p_Sll_id;

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

5098: where line.id = p_id;
5099:
5100:
5101: l_index NUMBER;
5102: l_init_msg_list VARCHAR2(2000) := OKC_API.G_FALSE;
5103:
5104: l_Line_Sll_rec l_Line_Sll_Csr%ROWTYPE;
5105: l_line_BS_rec l_line_BS_csr%ROWTYPE;
5106: l_Line_Csr_Rec l_Line_Csr%Rowtype;

Line 5140: x_return_status := OKC_API.G_RET_STS_SUCCESS;

5136:
5137: ---this is called for the new cp or existing cp which is updated and only for 'T'.
5138: --p_cp_new is 'Y' for new subline, 'N' for updating schedule for existing subline
5139:
5140: x_return_status := OKC_API.G_RET_STS_SUCCESS;
5141: l_update_required := 'N';
5142:
5143: ---get line details
5144: Open l_Line_Csr;

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

5150: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.create_bill_sch_cp.EXCEPTION',
5151: 'top line not found = ' || p_top_line_id );
5152: END IF;
5153: x_return_status := 'E';
5154: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'LINE NOT FOUND');
5155: RAISE G_EXCEPTION_HALT_VALIDATION;
5156: End If;
5157: Close l_Line_Csr;
5158:

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

5313: p_cle_id => p_top_line_id,
5314: p_chr_id => NULL);
5315:
5316: IF l_currency_code IS NULL THEN
5317: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'CURRENCY CODE NOT FOUND.');
5318: x_return_status := 'E';
5319: RAISE G_EXCEPTION_HALT_VALIDATION;
5320: END IF;
5321:

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

5324: FETCH l_SubLine_Csr Into l_SubLine_Rec;
5325: If l_SubLine_Csr%Notfound then
5326: Close l_SubLine_Csr;
5327: x_return_status := 'E';
5328: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'SUB LINE NOT FOUND');
5329: RAISE G_EXCEPTION_HALT_VALIDATION;
5330: End If;
5331: Close l_SubLine_Csr;
5332:

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

5510: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.create_bill_sch_cp.EXCEPTION',
5511: 'G_EXCEPTION_HALT_VALIDATION');
5512: END IF;
5513:
5514: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5515: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5516: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
5517: RAISE OKC_API.G_EXCEPTION_ERROR;
5518: END IF;

Line 5515: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

5511: 'G_EXCEPTION_HALT_VALIDATION');
5512: END IF;
5513:
5514: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5515: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5516: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
5517: RAISE OKC_API.G_EXCEPTION_ERROR;
5518: END IF;
5519: WHEN OTHERS THEN

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

5512: END IF;
5513:
5514: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5515: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5516: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
5517: RAISE OKC_API.G_EXCEPTION_ERROR;
5518: END IF;
5519: WHEN OTHERS THEN
5520: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN

Line 5517: RAISE OKC_API.G_EXCEPTION_ERROR;

5513:
5514: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5515: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5516: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
5517: RAISE OKC_API.G_EXCEPTION_ERROR;
5518: END IF;
5519: WHEN OTHERS THEN
5520: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN
5521: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.create_bill_sch_cp.UNEXPECTED',

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

5520: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN
5521: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.create_bill_sch_cp.UNEXPECTED',
5522: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
5523: END IF;
5524: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
5525: p_msg_name => G_UNEXPECTED_ERROR,
5526: p_token1 => G_SQLCODE_TOKEN,
5527: p_token1_value => sqlcode,
5528: p_token2 => G_SQLERRM_TOKEN,

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

5607: l_sll_ind NUMBER;
5608: l_timeunit VARCHAR2(20);
5609: l_duration NUMBER;
5610: l_difference NUMBER;
5611: l_msg_list VARCHAR2(1) DEFAULT OKC_API.G_FALSE;
5612: L_UOM_QUANTITY number;
5613: l_tce_code VARCHAR2(100);
5614: l_update_end_date VARCHAR2(1);
5615: l_usage_type VARCHAR2(40);

Line 5632: x_return_status := OKC_API.G_RET_STS_SUCCESS;

5628: BEGIN
5629:
5630: --it adjusts the sll and lvl element according to new line start and end date.
5631:
5632: x_return_status := OKC_API.G_RET_STS_SUCCESS;
5633:
5634: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5635:
5636: fnd_log.STRING (fnd_log.level_statement,

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

5648:
5649: If l_Line_Csr%Notfound then
5650: Close l_Line_Csr;
5651: x_return_status := 'E';
5652: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'LINE NOT FOUND');
5653: RAISE G_EXCEPTION_HALT_VALIDATION;
5654: End If;
5655: Close l_Line_Csr;
5656:

Line 6077: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

6073: ||', sll passed for delete = '|| l_strm_lvl_tbl_in.count ||')');
6074: END IF;
6075:
6076:
6077: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
6078: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
6079: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
6080: RAISE OKC_API.G_EXCEPTION_ERROR;
6081: END IF;

Line 6078: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

6074: END IF;
6075:
6076:
6077: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
6078: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
6079: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
6080: RAISE OKC_API.G_EXCEPTION_ERROR;
6081: END IF;
6082: END IF;

Line 6079: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN

6075:
6076:
6077: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
6078: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
6079: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
6080: RAISE OKC_API.G_EXCEPTION_ERROR;
6081: END IF;
6082: END IF;
6083:

Line 6080: RAISE OKC_API.G_EXCEPTION_ERROR;

6076:
6077: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
6078: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
6079: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
6080: RAISE OKC_API.G_EXCEPTION_ERROR;
6081: END IF;
6082: END IF;
6083:
6084: IF l_sll_tbl.count > 0 then

Line 6168: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

6164: 'okc_time_util_pub.get_seeded_timeunit(x_return_status = '||x_return_status
6165: ||', returned timeunit and qty = ' ||l_tce_code || '-' || l_uom_quantity ||')');
6166: END IF;
6167:
6168: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
6169: RAISE G_EXCEPTION_HALT_VALIDATION;
6170: END IF;
6171: --mchoudha for bug#4860210
6172: -- IF l_tce_code = 'DAY' THEN

Line 6451: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

6447: END IF;
6448:
6449:
6450:
6451: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
6452: RAISE G_EXCEPTION_HALT_VALIDATION;
6453: END IF;
6454: --mchoudha for bug#4860210
6455: -- IF l_tce_code = 'DAY' AND nvl(l_uom_quantity,1) = 1 THEN

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

6720: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.create_dates_sll.EXCEPTION',
6721: 'G_EXCEPTION_HALT_VALIDATION');
6722: END IF;
6723:
6724: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
6725: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
6726: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
6727: RAISE OKC_API.G_EXCEPTION_ERROR;
6728: END IF;

Line 6725: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

6721: 'G_EXCEPTION_HALT_VALIDATION');
6722: END IF;
6723:
6724: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
6725: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
6726: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
6727: RAISE OKC_API.G_EXCEPTION_ERROR;
6728: END IF;
6729: WHEN OTHERS THEN

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

6722: END IF;
6723:
6724: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
6725: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
6726: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
6727: RAISE OKC_API.G_EXCEPTION_ERROR;
6728: END IF;
6729: WHEN OTHERS THEN
6730:

Line 6727: RAISE OKC_API.G_EXCEPTION_ERROR;

6723:
6724: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
6725: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
6726: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
6727: RAISE OKC_API.G_EXCEPTION_ERROR;
6728: END IF;
6729: WHEN OTHERS THEN
6730:
6731: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN

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

6732: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.create_dates_sll.UNEXPECTED',
6733: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
6734: END IF;
6735:
6736: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
6737: p_msg_name => G_UNEXPECTED_ERROR,
6738: p_token1 => G_SQLCODE_TOKEN,
6739: p_token1_value => sqlcode,
6740: p_token2 => G_SQLERRM_TOKEN,

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

6791: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN
6792: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.del_sll_lvlelement.UNEXPECTED',
6793: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
6794: END IF;
6795: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
6796: p_msg_name => G_UNEXPECTED_ERROR,
6797: p_token1 => G_SQLCODE_TOKEN,
6798: p_token1_value => sqlcode,
6799: p_token2 => G_SQLERRM_TOKEN,

Line 6802: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

6798: p_token1_value => sqlcode,
6799: p_token2 => G_SQLERRM_TOKEN,
6800: p_token2_value => sqlerrm);
6801:
6802: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
6803:
6804: END Del_sll_lvlelement;
6805:
6806:

Line 6829: x_return_status := OKC_API.G_RET_STS_SUCCESS;

6825: l_cp_bs_ind number;
6826:
6827:
6828: BEGIN
6829: x_return_status := OKC_API.G_RET_STS_SUCCESS;
6830:
6831: l_cp_bs_tbl.DELETE;
6832: l_index := 1;
6833:

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

6897: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.adjust_top_bs_amt.EXCEPTION',
6898: 'G_EXCEPTION_HALT_VALIDATION');
6899: END IF;
6900:
6901: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
6902: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
6903: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
6904: RAISE OKC_API.G_EXCEPTION_ERROR;
6905: END IF;

Line 6902: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

6898: 'G_EXCEPTION_HALT_VALIDATION');
6899: END IF;
6900:
6901: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
6902: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
6903: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
6904: RAISE OKC_API.G_EXCEPTION_ERROR;
6905: END IF;
6906: WHEN OTHERS THEN

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

6899: END IF;
6900:
6901: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
6902: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
6903: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
6904: RAISE OKC_API.G_EXCEPTION_ERROR;
6905: END IF;
6906: WHEN OTHERS THEN
6907:

Line 6904: RAISE OKC_API.G_EXCEPTION_ERROR;

6900:
6901: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
6902: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
6903: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
6904: RAISE OKC_API.G_EXCEPTION_ERROR;
6905: END IF;
6906: WHEN OTHERS THEN
6907:
6908: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN

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

6909: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.adjust_top_bs_amt.UNEXPECTED',
6910: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
6911: END IF;
6912:
6913: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
6914: p_msg_name => G_UNEXPECTED_ERROR,
6915: p_token1 => G_SQLCODE_TOKEN,
6916: p_token1_value => sqlcode,
6917: p_token2 => G_SQLERRM_TOKEN,

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

6967: l_duration NUMBER;
6968: L_UOM_QUANTITY number;
6969: l_tce_code VARCHAR2(100);
6970:
6971: l_msg_list VARCHAR2(1) DEFAULT OKC_API.G_FALSE;
6972:
6973:
6974:
6975: BEGIN

Line 6977: x_return_status := OKC_API.G_RET_STS_SUCCESS;

6973:
6974:
6975: BEGIN
6976:
6977: x_return_status := OKC_API.G_RET_STS_SUCCESS;
6978:
6979: ---get line details
6980: Open l_Line_Csr;
6981: Fetch l_Line_Csr Into l_Line_Rec;

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

6982:
6983: If l_Line_Csr%Notfound then
6984: Close l_Line_Csr;
6985: x_return_status := 'E';
6986: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'LINE NOT FOUND');
6987: RAISE G_EXCEPTION_HALT_VALIDATION;
6988: End If;
6989: Close l_Line_Csr;
6990:

Line 7023: OKC_API.SET_MESSAGE (

7019:
7020:
7021: IF l_sll_tbl.COUNT = 0 THEN
7022: x_return_status := 'E';
7023: OKC_API.SET_MESSAGE (
7024: p_app_name => G_PKG_NAME,
7025: p_msg_name => 'OKS_SLL_NOT_EXISTS');
7026:
7027: RAISE G_EXCEPTION_HALT_VALIDATION;

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

7094: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.update_om_sll_date.EXCEPTION',
7095: 'G_EXCEPTION_HALT_VALIDATION');
7096: END IF;
7097:
7098: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
7099: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
7100: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
7101: RAISE OKC_API.G_EXCEPTION_ERROR;
7102: END IF;

Line 7099: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

7095: 'G_EXCEPTION_HALT_VALIDATION');
7096: END IF;
7097:
7098: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
7099: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
7100: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
7101: RAISE OKC_API.G_EXCEPTION_ERROR;
7102: END IF;
7103: WHEN OTHERS THEN

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

7096: END IF;
7097:
7098: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
7099: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
7100: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
7101: RAISE OKC_API.G_EXCEPTION_ERROR;
7102: END IF;
7103: WHEN OTHERS THEN
7104: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN

Line 7101: RAISE OKC_API.G_EXCEPTION_ERROR;

7097:
7098: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
7099: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
7100: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
7101: RAISE OKC_API.G_EXCEPTION_ERROR;
7102: END IF;
7103: WHEN OTHERS THEN
7104: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN
7105: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.update_om_sll_date.UNEXPECTED',

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

7105: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.update_om_sll_date.UNEXPECTED',
7106: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
7107: END IF;
7108:
7109: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
7110: p_msg_name => G_UNEXPECTED_ERROR,
7111: p_token1 => G_SQLCODE_TOKEN,
7112: p_token1_value => sqlcode,
7113: p_token2 => G_SQLERRM_TOKEN,

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

7177: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.del_rul_elements.UNEXPECTED',
7178: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
7179: END IF;
7180:
7181: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
7182: p_msg_name => G_UNEXPECTED_ERROR,
7183: p_token1 => G_SQLCODE_TOKEN,
7184: p_token1_value => sqlcode,
7185: p_token2 => G_SQLERRM_TOKEN,

Line 7188: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

7184: p_token1_value => sqlcode,
7185: p_token2 => G_SQLERRM_TOKEN,
7186: p_token2_value => sqlerrm);
7187:
7188: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
7189:
7190:
7191: END Del_rul_elements;
7192:

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

7244: l_cp_bs_ind NUMBER;
7245: l_top_bs_ind NUMBER;
7246:
7247: l_api_Version Number := 1;
7248: l_init_msg_list VARCHAR2(2000) := OKC_API.G_FALSE;
7249: l_msg_list VARCHAR2(1) DEFAULT OKC_API.G_FALSE;
7250: l_msg_count Number;
7251: l_msg_data Varchar2(2000) := NULL;
7252:

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

7245: l_top_bs_ind NUMBER;
7246:
7247: l_api_Version Number := 1;
7248: l_init_msg_list VARCHAR2(2000) := OKC_API.G_FALSE;
7249: l_msg_list VARCHAR2(1) DEFAULT OKC_API.G_FALSE;
7250: l_msg_count Number;
7251: l_msg_data Varchar2(2000) := NULL;
7252:
7253: BEGIN

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

7259:
7260: If l_bill_type_csr%Notfound then
7261: Close l_bill_type_Csr;
7262: x_return_status := 'E';
7263: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'BILLING SCHEDULE TYPE NOT FOUND.');
7264: RAISE G_EXCEPTION_HALT_VALIDATION;
7265: End If;
7266: Close l_bill_type_Csr;
7267:

Line 7348: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

7344: x_msg_data => l_msg_data,
7345: p_letv_tbl => l_top_bs_tbl,
7346: x_letv_tbl => l_lvl_ele_tbl_out);
7347:
7348: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
7349: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
7350: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
7351: RAISE OKC_API.G_EXCEPTION_ERROR;
7352: END IF;

Line 7349: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

7345: p_letv_tbl => l_top_bs_tbl,
7346: x_letv_tbl => l_lvl_ele_tbl_out);
7347:
7348: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
7349: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
7350: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
7351: RAISE OKC_API.G_EXCEPTION_ERROR;
7352: END IF;
7353:

Line 7350: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN

7346: x_letv_tbl => l_lvl_ele_tbl_out);
7347:
7348: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
7349: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
7350: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
7351: RAISE OKC_API.G_EXCEPTION_ERROR;
7352: END IF;
7353:
7354: END IF; ---l_cp_bs_tbl.COUNT > 0

Line 7351: RAISE OKC_API.G_EXCEPTION_ERROR;

7347:
7348: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
7349: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
7350: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
7351: RAISE OKC_API.G_EXCEPTION_ERROR;
7352: END IF;
7353:
7354: END IF; ---l_cp_bs_tbl.COUNT > 0
7355:

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

7372:
7373:
7374: EXCEPTION
7375: WHEN OTHERS THEN
7376: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
7377: p_msg_name => G_UNEXPECTED_ERROR,
7378: p_token1 => G_SQLCODE_TOKEN,
7379: p_token1_value => sqlcode,
7380: p_token2 => G_SQLERRM_TOKEN,

Line 7383: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

7379: p_token1_value => sqlcode,
7380: p_token2 => G_SQLERRM_TOKEN,
7381: p_token2_value => sqlerrm);
7382:
7383: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
7384: END Del_subline_lvl_rule;
7385:
7386:
7387:

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

7427: l_line_tbl_in oks_bill_level_elements_pvt.letv_tbl_type;
7428: l_top_index NUMBER := 0;
7429:
7430:
7431: l_init_msg_list VARCHAR2(2000) := OKC_API.G_FALSE;
7432:
7433: BEGIN
7434:
7435: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 7435: x_return_status := OKC_API.G_RET_STS_SUCCESS;

7431: l_init_msg_list VARCHAR2(2000) := OKC_API.G_FALSE;
7432:
7433: BEGIN
7434:
7435: x_return_status := OKC_API.G_RET_STS_SUCCESS;
7436:
7437: IF p_invoice_rule_id IS NULL THEN
7438: -- nechatur 23-DEC-2005 for bug#4684706
7439: -- OKC_API.set_message(G_PKG_NAME,'OKS_INVD_COV_RULE','RULE_NAME','IRE');

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

7435: x_return_status := OKC_API.G_RET_STS_SUCCESS;
7436:
7437: IF p_invoice_rule_id IS NULL THEN
7438: -- nechatur 23-DEC-2005 for bug#4684706
7439: -- OKC_API.set_message(G_PKG_NAME,'OKS_INVD_COV_RULE','RULE_NAME','IRE');
7440: OKC_API.set_message(G_PKG_NAME,'OKS_INVOICING_RULE');
7441: -- end bug#4684706
7442: x_return_status := 'E';
7443: RAISE G_EXCEPTION_HALT_VALIDATION;

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

7436:
7437: IF p_invoice_rule_id IS NULL THEN
7438: -- nechatur 23-DEC-2005 for bug#4684706
7439: -- OKC_API.set_message(G_PKG_NAME,'OKS_INVD_COV_RULE','RULE_NAME','IRE');
7440: OKC_API.set_message(G_PKG_NAME,'OKS_INVOICING_RULE');
7441: -- end bug#4684706
7442: x_return_status := 'E';
7443: RAISE G_EXCEPTION_HALT_VALIDATION;
7444: END IF;

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

7447: FETCH l_line_csr Into l_line_rec;
7448:
7449: If l_line_csr%NOTFOUND THEN
7450: CLOSE l_line_csr;
7451: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'LINE NOT FOUND');
7452: x_return_status := G_RET_STS_UNEXP_ERROR;
7453: RETURN;
7454: ELSE
7455: Close l_line_csr;

Line 7473: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

7469: x_return_status => x_return_status,
7470: x_msg_count => x_msg_count,
7471: x_msg_data => x_msg_data);
7472:
7473: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
7474: RAISE G_EXCEPTION_HALT_VALIDATION;
7475: END IF;
7476:
7477: IF l_update_bs_tbl.COUNT <= 0 THEN

Line 7511: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

7507: x_return_status => x_return_status,
7508: x_msg_count => x_msg_count,
7509: x_msg_data => x_msg_data);
7510:
7511: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
7512: RAISE G_EXCEPTION_HALT_VALIDATION;
7513: END IF;
7514:
7515: IF l_update_bs_tbl.COUNT > 0 THEN

Line 7575: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

7571: p_SubLine_id => l_subLine_rec.id,
7572: x_cp_line_bs => l_cp_line_bs,
7573: x_return_status => x_return_status);
7574:
7575: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
7576: RAISE G_EXCEPTION_HALT_VALIDATION;
7577: END IF;
7578:
7579: IF l_cp_line_bs.COUNT > 0 THEN

Line 7613: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

7609: x_msg_data => x_msg_data,
7610: p_letv_tbl => l_lvl_ele_tbl_in,
7611: x_letv_tbl => l_lvl_ele_tbl_out);
7612:
7613: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
7614: RAISE G_EXCEPTION_HALT_VALIDATION;
7615: END IF;
7616: END IF;
7617:

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

7620: WHEN G_EXCEPTION_HALT_VALIDATION THEN
7621: NULL;
7622:
7623: WHEN OTHERS THEN
7624: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
7625: p_msg_name => G_UNEXPECTED_ERROR,
7626: p_token1 => G_SQLCODE_TOKEN,
7627: p_token1_value => sqlcode,
7628: p_token2 => G_SQLERRM_TOKEN,

Line 7684: x_return_status := OKC_API.G_RET_STS_SUCCESS;

7680: l_date_transaction DATE;
7681:
7682: BEGIN
7683:
7684: x_return_status := OKC_API.G_RET_STS_SUCCESS;
7685:
7686:
7687: For l_Line_SLL_rec IN l_Line_SLL_csr(p_line_id)
7688: LOOP

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

7831:
7832: EXCEPTION
7833:
7834: WHEN OTHERS THEN
7835: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
7836: p_msg_name => G_UNEXPECTED_ERROR,
7837: p_token1 => G_SQLCODE_TOKEN,
7838: p_token1_value => sqlcode,
7839: p_token2 => G_SQLERRM_TOKEN,

Line 7866: x_return_status := OKC_API.G_RET_STS_SUCCESS;

7862: l_msg_data VARCHAR2(2000);
7863:
7864: BEGIN
7865:
7866: x_return_status := OKC_API.G_RET_STS_SUCCESS;
7867:
7868:
7869: IF p_line_id IS NOT NULL THEN
7870: oks_bill_sch.Cascade_Dates_SLL

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

7889: END IF;
7890:
7891: EXCEPTION
7892: WHEN G_EXCEPTION_HALT_VALIDATION THEN
7893: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
7894: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
7895: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
7896: RAISE OKC_API.G_EXCEPTION_ERROR;
7897: END IF;

Line 7894: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

7890:
7891: EXCEPTION
7892: WHEN G_EXCEPTION_HALT_VALIDATION THEN
7893: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
7894: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
7895: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
7896: RAISE OKC_API.G_EXCEPTION_ERROR;
7897: END IF;
7898: WHEN OTHERS THEN

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

7891: EXCEPTION
7892: WHEN G_EXCEPTION_HALT_VALIDATION THEN
7893: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
7894: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
7895: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
7896: RAISE OKC_API.G_EXCEPTION_ERROR;
7897: END IF;
7898: WHEN OTHERS THEN
7899: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,

Line 7896: RAISE OKC_API.G_EXCEPTION_ERROR;

7892: WHEN G_EXCEPTION_HALT_VALIDATION THEN
7893: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
7894: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
7895: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
7896: RAISE OKC_API.G_EXCEPTION_ERROR;
7897: END IF;
7898: WHEN OTHERS THEN
7899: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
7900: p_msg_name => G_UNEXPECTED_ERROR,

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

7895: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
7896: RAISE OKC_API.G_EXCEPTION_ERROR;
7897: END IF;
7898: WHEN OTHERS THEN
7899: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
7900: p_msg_name => G_UNEXPECTED_ERROR,
7901: p_token1 => G_SQLCODE_TOKEN,
7902: p_token1_value => sqlcode,
7903: p_token2 => G_SQLERRM_TOKEN,

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

7960: l_bill_type VARCHAR2(10);
7961:
7962: --
7963: l_api_version CONSTANT NUMBER := 1.0;
7964: l_init_msg_list VARCHAR2(2000) := OKC_API.G_FALSE;
7965: l_return_status VARCHAR2(10);
7966: l_msg_count NUMBER;
7967: l_msg_data VARCHAR2(2000);
7968: l_msg_index_out NUMBER;

Line 7984: x_return_status := OKC_API.G_RET_STS_SUCCESS;

7980: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;
7981: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;
7982: BEGIN
7983:
7984: x_return_status := OKC_API.G_RET_STS_SUCCESS;
7985:
7986: l_tangible := OKS_SUBSCRIPTION_PUB.is_subs_tangible (p_line_rec.id);
7987:
7988:

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

8063: x_return_status => x_return_status);
8064:
8065: -----errorout_ad('Delete_lvl_element status = ' || x_return_status);
8066:
8067: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
8068: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
8069: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
8070: RAISE OKC_API.G_EXCEPTION_ERROR;
8071: END IF;

Line 8068: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

8064:
8065: -----errorout_ad('Delete_lvl_element status = ' || x_return_status);
8066:
8067: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
8068: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
8069: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
8070: RAISE OKC_API.G_EXCEPTION_ERROR;
8071: END IF;
8072: END IF;

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

8065: -----errorout_ad('Delete_lvl_element status = ' || x_return_status);
8066:
8067: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
8068: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
8069: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
8070: RAISE OKC_API.G_EXCEPTION_ERROR;
8071: END IF;
8072: END IF;
8073:

Line 8070: RAISE OKC_API.G_EXCEPTION_ERROR;

8066:
8067: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
8068: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
8069: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
8070: RAISE OKC_API.G_EXCEPTION_ERROR;
8071: END IF;
8072: END IF;
8073:
8074: 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 8109: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

8105:
8106: -----errorout_ad('LEVEL ELEMENT COUNTER = ' || TO_CHAR(l_period_counter));
8107: -----errorout_ad('LEVEL ELEMENT START DATE = ' || to_char(l_next_cycle_dt));
8108:
8109: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
8110: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
8111: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
8112: RAISE OKC_API.G_EXCEPTION_ERROR;
8113: END IF;

Line 8110: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

8106: -----errorout_ad('LEVEL ELEMENT COUNTER = ' || TO_CHAR(l_period_counter));
8107: -----errorout_ad('LEVEL ELEMENT START DATE = ' || to_char(l_next_cycle_dt));
8108:
8109: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
8110: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
8111: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
8112: RAISE OKC_API.G_EXCEPTION_ERROR;
8113: END IF;
8114: l_lvl_loop_counter := l_period_counter;

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

8107: -----errorout_ad('LEVEL ELEMENT START DATE = ' || to_char(l_next_cycle_dt));
8108:
8109: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
8110: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
8111: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
8112: RAISE OKC_API.G_EXCEPTION_ERROR;
8113: END IF;
8114: l_lvl_loop_counter := l_period_counter;
8115: END IF;

Line 8112: RAISE OKC_API.G_EXCEPTION_ERROR;

8108:
8109: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
8110: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
8111: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
8112: RAISE OKC_API.G_EXCEPTION_ERROR;
8113: END IF;
8114: l_lvl_loop_counter := l_period_counter;
8115: END IF;
8116:

Line 8159: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

8155: x_return_status => x_return_status,
8156: x_quantity => l_uom_quantity ,
8157: x_timeunit => l_tce_code);
8158:
8159: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
8160: RAISE G_EXCEPTION_HALT_VALIDATION;
8161: END IF;
8162:
8163: l_remaining_amt := l_line_amt - nvl(l_bill_sch_amt,0);

Line 8176: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

8172: x_return_status => x_return_status);
8173:
8174: -----errorout_ad('Get_Constant_sll_Amount = ' || x_return_status);
8175:
8176: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
8177: RAISE G_EXCEPTION_HALT_VALIDATION;
8178: END IF;
8179: END IF; ----end of bill type = 'T'
8180:

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

8225: -- End - Modified by PMALLARA - Bug #3992530
8226:
8227: -----errorout_ad('LEVEL ELEMENT NEXT CYCLE DATE passed from Get_next_bill_sch = ' || TO_CHAR(l_fnd_lvl_out_rec.next_cycle_date));
8228:
8229: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
8230: -----errorout_ad(' OKS_BILL_UTIL_PUB.Get_next_bill_sch = ' || l_msg_data);
8231: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
8232: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
8233: -----errorout_ad(' OKS_BILL_UTIL_PUB.Get_next_bill_sch = ' || l_msg_data);

Line 8231: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

8227: -----errorout_ad('LEVEL ELEMENT NEXT CYCLE DATE passed from Get_next_bill_sch = ' || TO_CHAR(l_fnd_lvl_out_rec.next_cycle_date));
8228:
8229: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
8230: -----errorout_ad(' OKS_BILL_UTIL_PUB.Get_next_bill_sch = ' || l_msg_data);
8231: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
8232: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
8233: -----errorout_ad(' OKS_BILL_UTIL_PUB.Get_next_bill_sch = ' || l_msg_data);
8234: RAISE OKC_API.G_EXCEPTION_ERROR;
8235: END IF;

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

8228:
8229: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
8230: -----errorout_ad(' OKS_BILL_UTIL_PUB.Get_next_bill_sch = ' || l_msg_data);
8231: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
8232: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
8233: -----errorout_ad(' OKS_BILL_UTIL_PUB.Get_next_bill_sch = ' || l_msg_data);
8234: RAISE OKC_API.G_EXCEPTION_ERROR;
8235: END IF;
8236:

Line 8234: RAISE OKC_API.G_EXCEPTION_ERROR;

8230: -----errorout_ad(' OKS_BILL_UTIL_PUB.Get_next_bill_sch = ' || l_msg_data);
8231: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
8232: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
8233: -----errorout_ad(' OKS_BILL_UTIL_PUB.Get_next_bill_sch = ' || l_msg_data);
8234: RAISE OKC_API.G_EXCEPTION_ERROR;
8235: END IF;
8236:
8237:
8238:

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

8267: l_lvl_ele_tbl_in(l_tbl_seq).date_to_interface := TRUNC(l_fnd_lvl_out_rec.date_to_interface);
8268: l_lvl_ele_tbl_in(l_tbl_seq).date_completed := l_fnd_lvl_out_rec.date_completed;
8269: l_lvl_ele_tbl_in(l_tbl_seq).rul_id := p_sll_tbl(l_line_sll_counter).id;
8270:
8271: l_lvl_ele_tbl_in(l_tbl_seq).object_version_number := OKC_API.G_MISS_NUM;
8272: l_lvl_ele_tbl_in(l_tbl_seq).created_by := OKC_API.G_MISS_NUM;
8273: l_lvl_ele_tbl_in(l_tbl_seq).creation_date := SYSDATE;
8274: l_lvl_ele_tbl_in(l_tbl_seq).last_updated_by := OKC_API.G_MISS_NUM;
8275: l_lvl_ele_tbl_in(l_tbl_seq).last_update_date := SYSDATE;

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

8268: l_lvl_ele_tbl_in(l_tbl_seq).date_completed := l_fnd_lvl_out_rec.date_completed;
8269: l_lvl_ele_tbl_in(l_tbl_seq).rul_id := p_sll_tbl(l_line_sll_counter).id;
8270:
8271: l_lvl_ele_tbl_in(l_tbl_seq).object_version_number := OKC_API.G_MISS_NUM;
8272: l_lvl_ele_tbl_in(l_tbl_seq).created_by := OKC_API.G_MISS_NUM;
8273: l_lvl_ele_tbl_in(l_tbl_seq).creation_date := SYSDATE;
8274: l_lvl_ele_tbl_in(l_tbl_seq).last_updated_by := OKC_API.G_MISS_NUM;
8275: l_lvl_ele_tbl_in(l_tbl_seq).last_update_date := SYSDATE;
8276:

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

8270:
8271: l_lvl_ele_tbl_in(l_tbl_seq).object_version_number := OKC_API.G_MISS_NUM;
8272: l_lvl_ele_tbl_in(l_tbl_seq).created_by := OKC_API.G_MISS_NUM;
8273: l_lvl_ele_tbl_in(l_tbl_seq).creation_date := SYSDATE;
8274: l_lvl_ele_tbl_in(l_tbl_seq).last_updated_by := OKC_API.G_MISS_NUM;
8275: l_lvl_ele_tbl_in(l_tbl_seq).last_update_date := SYSDATE;
8276:
8277:
8278: -----errorout_ad ('Amount for line lvl element = ' || to_char(l_lvl_ele_tbl_in(l_tbl_seq).amount ));

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

8340:
8341: -----errorout_ad('LEVEL ELEMENT INSERT STATUS FOR SUBLINE = ' || x_return_status);
8342:
8343:
8344: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
8345: -----errorout_ad('OKS_BILL_LEVEL_ELEMENTS_PVT.insert_row for sub line = ' || l_msg_data);
8346: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
8347: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
8348: -----errorout_ad('OKS_BILL_LEVEL_ELEMENTS_PVT.insert_row for sub line = ' || l_msg_data);

Line 8346: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

8342:
8343:
8344: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
8345: -----errorout_ad('OKS_BILL_LEVEL_ELEMENTS_PVT.insert_row for sub line = ' || l_msg_data);
8346: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
8347: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
8348: -----errorout_ad('OKS_BILL_LEVEL_ELEMENTS_PVT.insert_row for sub line = ' || l_msg_data);
8349: RAISE OKC_API.G_EXCEPTION_ERROR;
8350: END IF;

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

8343:
8344: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
8345: -----errorout_ad('OKS_BILL_LEVEL_ELEMENTS_PVT.insert_row for sub line = ' || l_msg_data);
8346: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
8347: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
8348: -----errorout_ad('OKS_BILL_LEVEL_ELEMENTS_PVT.insert_row for sub line = ' || l_msg_data);
8349: RAISE OKC_API.G_EXCEPTION_ERROR;
8350: END IF;
8351: END IF;

Line 8349: RAISE OKC_API.G_EXCEPTION_ERROR;

8345: -----errorout_ad('OKS_BILL_LEVEL_ELEMENTS_PVT.insert_row for sub line = ' || l_msg_data);
8346: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
8347: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
8348: -----errorout_ad('OKS_BILL_LEVEL_ELEMENTS_PVT.insert_row for sub line = ' || l_msg_data);
8349: RAISE OKC_API.G_EXCEPTION_ERROR;
8350: END IF;
8351: END IF;
8352:
8353:

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

8352:
8353:
8354: EXCEPTION
8355: WHEN OTHERS THEN
8356: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
8357: p_msg_name => G_UNEXPECTED_ERROR,
8358: p_token1 => G_SQLCODE_TOKEN,
8359: p_token1_value => sqlcode,
8360: p_token2 => G_SQLERRM_TOKEN,

Line 8430: x_return_status := OKC_API.G_RET_STS_SUCCESS;

8426: -------------------------------------------------------------------------
8427:
8428: BEGIN
8429:
8430: x_return_status := OKC_API.G_RET_STS_SUCCESS;
8431: l_update_end_date := 'N';
8432:
8433: IF nvl(p_full_credit, 'N') = 'Y' Then
8434: DELETE FROM OKS_LEVEL_ELEMENTS

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

8444:
8445: If l_Line_Csr%Notfound then
8446: Close l_Line_Csr;
8447: x_return_status := 'E';
8448: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'LINE NOT FOUND');
8449: RAISE G_EXCEPTION_HALT_VALIDATION;
8450: End If;
8451: Close l_Line_Csr;
8452:

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

8562:
8563:
8564: EXCEPTION
8565: WHEN G_EXCEPTION_HALT_VALIDATION THEN
8566: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
8567: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
8568: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
8569: RAISE OKC_API.G_EXCEPTION_ERROR;
8570: END IF;

Line 8567: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

8563:
8564: EXCEPTION
8565: WHEN G_EXCEPTION_HALT_VALIDATION THEN
8566: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
8567: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
8568: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
8569: RAISE OKC_API.G_EXCEPTION_ERROR;
8570: END IF;
8571: WHEN OTHERS THEN

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

8564: EXCEPTION
8565: WHEN G_EXCEPTION_HALT_VALIDATION THEN
8566: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
8567: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
8568: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
8569: RAISE OKC_API.G_EXCEPTION_ERROR;
8570: END IF;
8571: WHEN OTHERS THEN
8572: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,

Line 8569: RAISE OKC_API.G_EXCEPTION_ERROR;

8565: WHEN G_EXCEPTION_HALT_VALIDATION THEN
8566: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
8567: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
8568: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
8569: RAISE OKC_API.G_EXCEPTION_ERROR;
8570: END IF;
8571: WHEN OTHERS THEN
8572: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
8573: p_msg_name => G_UNEXPECTED_ERROR,

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

8568: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
8569: RAISE OKC_API.G_EXCEPTION_ERROR;
8570: END IF;
8571: WHEN OTHERS THEN
8572: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
8573: p_msg_name => G_UNEXPECTED_ERROR,
8574: p_token1 => G_SQLCODE_TOKEN,
8575: p_token1_value => sqlcode,
8576: p_token2 => G_SQLERRM_TOKEN,

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

8812: l_sll_in_tbl StrmLvl_Out_tbl;
8813: l_sll_db_tbl oks_bill_sch.StreamLvl_tbl;
8814: l_top_bs_tbl oks_bill_level_elements_pvt.letv_tbl_type;
8815:
8816: l_init_msg_list VARCHAR2(2000) := OKC_API.G_FALSE;
8817:
8818: -------------------------------------------------------------------------
8819: -- Begin partial period computation logic
8820: -- Developer Mani Choudhary

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

8856:
8857: If l_Line_Csr%Notfound then
8858: Close l_Line_Csr;
8859: x_return_status := 'E';
8860: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'LINE NOT FOUND');
8861: RAISE G_EXCEPTION_HALT_VALIDATION;
8862: End If;
8863: Close l_Line_Csr;
8864:

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

8955: 'l_currency_code = ' || l_currency_code);
8956: END IF;
8957:
8958: IF l_currency_code IS NULL THEN
8959: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'CURRENCY CODE NOT FOUND.');
8960: x_return_status := 'E';
8961: RAISE G_EXCEPTION_HALT_VALIDATION;
8962: END IF;
8963:

Line 9098: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

9094: 'Rollup_lvl_amt(x_return_status = '||x_return_status
9095: ||')');
9096: END IF;
9097:
9098: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
9099: RAISE G_EXCEPTION_HALT_VALIDATION;
9100: END IF;
9101: END IF;
9102:

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

9203: FETCH l_SubLine_Csr Into l_SubLine_Rec;
9204: If l_SubLine_Csr%Notfound then
9205: Close l_SubLine_Csr;
9206: x_return_status := 'E';
9207: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'SUB LINE NOT FOUND');
9208: RAISE G_EXCEPTION_HALT_VALIDATION;
9209: End If;
9210: Close l_SubLine_Csr;
9211:

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

9348:
9349:
9350: EXCEPTION
9351: WHEN G_EXCEPTION_HALT_VALIDATION THEN
9352: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
9353: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
9354: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
9355: RAISE OKC_API.G_EXCEPTION_ERROR;
9356: END IF;

Line 9353: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

9349:
9350: EXCEPTION
9351: WHEN G_EXCEPTION_HALT_VALIDATION THEN
9352: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
9353: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
9354: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
9355: RAISE OKC_API.G_EXCEPTION_ERROR;
9356: END IF;
9357: WHEN OTHERS THEN

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

9350: EXCEPTION
9351: WHEN G_EXCEPTION_HALT_VALIDATION THEN
9352: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
9353: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
9354: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
9355: RAISE OKC_API.G_EXCEPTION_ERROR;
9356: END IF;
9357: WHEN OTHERS THEN
9358: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,

Line 9355: RAISE OKC_API.G_EXCEPTION_ERROR;

9351: WHEN G_EXCEPTION_HALT_VALIDATION THEN
9352: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
9353: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
9354: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
9355: RAISE OKC_API.G_EXCEPTION_ERROR;
9356: END IF;
9357: WHEN OTHERS THEN
9358: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
9359: p_msg_name => G_UNEXPECTED_ERROR,

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

9354: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
9355: RAISE OKC_API.G_EXCEPTION_ERROR;
9356: END IF;
9357: WHEN OTHERS THEN
9358: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
9359: p_msg_name => G_UNEXPECTED_ERROR,
9360: p_token1 => G_SQLCODE_TOKEN,
9361: p_token1_value => sqlcode,
9362: p_token2 => G_SQLERRM_TOKEN,

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

9410: i number;
9411: l_end_date DATE;
9412: l_billed_at_source OKC_K_HEADERS_ALL_B.BILLED_AT_SOURCE%TYPE;
9413: --
9414: l_init_msg_list VARCHAR2(2000) := OKC_API.G_FALSE;
9415: l_return_status VARCHAR2(1);
9416: l_msg_count NUMBER;
9417: l_msg_data VARCHAR2(2000);
9418: l_msg_index_out NUMBER;

Line 9473: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

9469: IF l_header_billing IS NULL THEN
9470: Delete_lvl_element(p_cle_id => p_SubLine_rec.cp_id,
9471: x_return_status => x_return_status);
9472:
9473: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
9474: RAISE G_EXCEPTION_HALT_VALIDATION;
9475: END IF;
9476: END IF;
9477:

Line 9502: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

9498: x_top_line_bs => p_top_line_bs,
9499: x_return_status => x_return_status);
9500:
9501: -----errorout_ad('Check_Existing_Lvlelement 1 = '|| x_return_status);
9502: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
9503: RAISE G_EXCEPTION_HALT_VALIDATION;
9504: END IF;
9505: END LOOP;
9506: END IF; ---END OF p_cp_sll_tbl.count

Line 9542: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

9538: x_return_status => x_return_status);
9539:
9540: -----errorout_ad('Check_Existing_Lvlelement 2= '|| x_return_status);
9541:
9542: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
9543: RAISE G_EXCEPTION_HALT_VALIDATION;
9544: END IF;
9545:
9546: l_lvl_loop_counter := l_period_counter;

Line 9611: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

9607: x_return_status => x_return_status);
9608:
9609: -----errorout_ad('Check_Existing_Lvlelement 3= '|| x_return_status);
9610:
9611: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
9612: RAISE G_EXCEPTION_HALT_VALIDATION;
9613: END IF;
9614: END LOOP;
9615: END IF; ----END OF l_cp_sll_counter < p_cp_sll_tbl.LAST

Line 9642: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

9638: x_return_status => x_return_status,
9639: x_quantity => l_uom_quantity ,
9640: x_timeunit => l_tce_code);
9641:
9642: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
9643: RAISE G_EXCEPTION_HALT_VALIDATION;
9644: END IF;
9645:
9646:

Line 9698: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

9694: x_return_status => x_return_status);
9695: END IF;
9696: -----errorout_ad('Get_Constant_sll_Amount = ' || l_constant_sll_amt);
9697:
9698: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
9699: RAISE G_EXCEPTION_HALT_VALIDATION;
9700: END IF;
9701: END IF;
9702:

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

9836: -----errorout_ad(' OKS_BILL_UTIL_PUB.Get_next_bill_sch l_fnd_next_cycle = ' || x_return_status);
9837: -----errorout_ad('l_fnd_lvl_out_rec.next_cycle_date = ' || l_fnd_lvl_out_rec.next_cycle_date );
9838:
9839:
9840: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
9841: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
9842: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
9843: RAISE OKC_API.G_EXCEPTION_ERROR;
9844: END IF;

Line 9841: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

9837: -----errorout_ad('l_fnd_lvl_out_rec.next_cycle_date = ' || l_fnd_lvl_out_rec.next_cycle_date );
9838:
9839:
9840: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
9841: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
9842: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
9843: RAISE OKC_API.G_EXCEPTION_ERROR;
9844: END IF;
9845:

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

9838:
9839:
9840: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
9841: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
9842: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
9843: RAISE OKC_API.G_EXCEPTION_ERROR;
9844: END IF;
9845:
9846:

Line 9843: RAISE OKC_API.G_EXCEPTION_ERROR;

9839:
9840: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
9841: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
9842: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
9843: RAISE OKC_API.G_EXCEPTION_ERROR;
9844: END IF;
9845:
9846:
9847: -------Next cycle date given by Get_next_bill_sch is <= cp start date then do not create

Line 9986: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

9982: x_return_status => x_return_status);
9983:
9984:
9985: -----errorout_ad('Get_Period_Frequency = ' || x_return_status);
9986: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
9987: RAISE G_EXCEPTION_HALT_VALIDATION;
9988: END IF;
9989:
9990: l_lvl_amt := (NVL(l_period_freq,0) * NVL(l_constant_sll_amt,0) );

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

10115: l_lvl_ele_tbl_in(l_tbl_seq).date_completed := l_fnd_lvl_out_rec.date_completed;
10116: end if;
10117:
10118: l_lvl_ele_tbl_in(l_tbl_seq).rul_id := p_cp_sll_tbl(l_cp_sll_counter).id;
10119: l_lvl_ele_tbl_in(l_tbl_seq).object_version_number := OKC_API.G_MISS_NUM;
10120: l_lvl_ele_tbl_in(l_tbl_seq).created_by := OKC_API.G_MISS_NUM;
10121: l_lvl_ele_tbl_in(l_tbl_seq).creation_date := SYSDATE;
10122: l_lvl_ele_tbl_in(l_tbl_seq).last_updated_by := OKC_API.G_MISS_NUM;
10123: l_lvl_ele_tbl_in(l_tbl_seq).last_update_date := SYSDATE;

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

10116: end if;
10117:
10118: l_lvl_ele_tbl_in(l_tbl_seq).rul_id := p_cp_sll_tbl(l_cp_sll_counter).id;
10119: l_lvl_ele_tbl_in(l_tbl_seq).object_version_number := OKC_API.G_MISS_NUM;
10120: l_lvl_ele_tbl_in(l_tbl_seq).created_by := OKC_API.G_MISS_NUM;
10121: l_lvl_ele_tbl_in(l_tbl_seq).creation_date := SYSDATE;
10122: l_lvl_ele_tbl_in(l_tbl_seq).last_updated_by := OKC_API.G_MISS_NUM;
10123: l_lvl_ele_tbl_in(l_tbl_seq).last_update_date := SYSDATE;
10124:

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

10118: l_lvl_ele_tbl_in(l_tbl_seq).rul_id := p_cp_sll_tbl(l_cp_sll_counter).id;
10119: l_lvl_ele_tbl_in(l_tbl_seq).object_version_number := OKC_API.G_MISS_NUM;
10120: l_lvl_ele_tbl_in(l_tbl_seq).created_by := OKC_API.G_MISS_NUM;
10121: l_lvl_ele_tbl_in(l_tbl_seq).creation_date := SYSDATE;
10122: l_lvl_ele_tbl_in(l_tbl_seq).last_updated_by := OKC_API.G_MISS_NUM;
10123: l_lvl_ele_tbl_in(l_tbl_seq).last_update_date := SYSDATE;
10124:
10125: -----errorout_ad ('Amount for subline lvl element = ' || to_char(l_lvl_ele_tbl_in(l_tbl_seq).amount ));
10126:

Line 10244: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

10240: x_return_status => x_return_status);
10241: END LOOP;
10242:
10243: -----errorout_ad('Check_Existing_Lvlelement5 = '|| x_return_status);
10244: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
10245: RAISE G_EXCEPTION_HALT_VALIDATION;
10246: END IF;
10247: END IF; ---END OF l_cp_sll_counter < p_cp_sll_tbl.LAST
10248:

Line 10269: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

10265:
10266: -----errorout_ad('LEVEL ELEMENT INSERT STATUS FOR SUBLINE = ' || x_return_status);
10267:
10268:
10269: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
10270: RAISE G_EXCEPTION_HALT_VALIDATION;
10271: END IF;
10272: END IF;
10273:

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

10273:
10274:
10275: EXCEPTION
10276: WHEN G_EXCEPTION_HALT_VALIDATION THEN
10277: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
10278: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
10279: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
10280: RAISE OKC_API.G_EXCEPTION_ERROR;
10281: END IF;

Line 10278: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

10274:
10275: EXCEPTION
10276: WHEN G_EXCEPTION_HALT_VALIDATION THEN
10277: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
10278: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
10279: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
10280: RAISE OKC_API.G_EXCEPTION_ERROR;
10281: END IF;
10282: WHEN OTHERS THEN

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

10275: EXCEPTION
10276: WHEN G_EXCEPTION_HALT_VALIDATION THEN
10277: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
10278: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
10279: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
10280: RAISE OKC_API.G_EXCEPTION_ERROR;
10281: END IF;
10282: WHEN OTHERS THEN
10283: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,

Line 10280: RAISE OKC_API.G_EXCEPTION_ERROR;

10276: WHEN G_EXCEPTION_HALT_VALIDATION THEN
10277: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
10278: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
10279: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
10280: RAISE OKC_API.G_EXCEPTION_ERROR;
10281: END IF;
10282: WHEN OTHERS THEN
10283: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
10284: p_msg_name => G_UNEXPECTED_ERROR,

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

10279: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
10280: RAISE OKC_API.G_EXCEPTION_ERROR;
10281: END IF;
10282: WHEN OTHERS THEN
10283: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
10284: p_msg_name => G_UNEXPECTED_ERROR,
10285: p_token1 => G_SQLCODE_TOKEN,
10286: p_token1_value => sqlcode,
10287: p_token2 => G_SQLERRM_TOKEN,

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

10331:
10332:
10333: --
10334: l_api_version CONSTANT NUMBER := 1.0;
10335: l_init_msg_list VARCHAR2(2000) := OKC_API.G_FALSE;
10336: --
10337: -------------------------------------------------------------------------
10338: -- Begin partial period computation logic
10339: -- Developer Mani Choudhary

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

10461: l_currency_code := Find_Currency_Code(
10462: p_cle_id => NULL,
10463: p_chr_id => p_contract_id);
10464: IF l_currency_code IS NULL THEN
10465: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'CURRENCY CODE NOT FOUND.');
10466: x_return_status := 'E';
10467: RETURN;
10468: END IF;
10469:

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

10498:
10499: WHEN OTHERS THEN
10500: l_currency_code := NULL;
10501: l_header_billing := NULL;
10502: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
10503: p_msg_name => G_UNEXPECTED_ERROR,
10504: p_token1 => G_SQLCODE_TOKEN,
10505: p_token1_value => sqlcode,
10506: p_token2 => G_SQLERRM_TOKEN,

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

10546:
10547:
10548: EXCEPTION
10549: WHEN OTHERS THEN
10550: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
10551: p_msg_name => G_UNEXPECTED_ERROR,
10552: p_token1 => G_SQLCODE_TOKEN,
10553: p_token1_value => sqlcode,
10554: p_token2 => G_SQLERRM_TOKEN,

Line 10557: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

10553: p_token1_value => sqlcode,
10554: p_token2 => G_SQLERRM_TOKEN,
10555: p_token2_value => sqlerrm);
10556:
10557: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
10558:
10559: END Del_line_sll_lvl;
10560:
10561:

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

10582:
10583:
10584: EXCEPTION
10585: WHEN OTHERS THEN
10586: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
10587: p_msg_name => G_UNEXPECTED_ERROR,
10588: p_token1 => G_SQLCODE_TOKEN,
10589: p_token1_value => sqlcode,
10590: p_token2 => G_SQLERRM_TOKEN,

Line 10593: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

10589: p_token1_value => sqlcode,
10590: p_token2 => G_SQLERRM_TOKEN,
10591: p_token2_value => sqlerrm);
10592:
10593: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
10594:
10595: END Delete_contract_bs_sll;
10596:
10597: Procedure Populate_end_date(p_line_id IN NUMBER,

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

10912: ROLLBACK;
10913: x_return_status := 'E';
10914:
10915: WHEN OTHERS THEN
10916: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
10917: p_msg_name => G_UNEXPECTED_ERROR,
10918: p_token1 => G_SQLCODE_TOKEN,
10919: p_token1_value => sqlcode,
10920: p_token2 => G_SQLERRM_TOKEN,

Line 10952: x_return_status := OKC_API.G_RET_STS_SUCCESS;

10948: l_cp_bs_ind number;
10949:
10950:
10951: BEGIN
10952: x_return_status := OKC_API.G_RET_STS_SUCCESS;
10953:
10954: l_cp_bs_tbl.DELETE;
10955: l_index := 1;
10956:

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

11015:
11016:
11017: EXCEPTION
11018: WHEN G_EXCEPTION_HALT_VALIDATION THEN
11019: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
11020: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
11021: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
11022: RAISE OKC_API.G_EXCEPTION_ERROR;
11023: END IF;

Line 11020: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

11016:
11017: EXCEPTION
11018: WHEN G_EXCEPTION_HALT_VALIDATION THEN
11019: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
11020: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
11021: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
11022: RAISE OKC_API.G_EXCEPTION_ERROR;
11023: END IF;
11024: WHEN OTHERS THEN

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

11017: EXCEPTION
11018: WHEN G_EXCEPTION_HALT_VALIDATION THEN
11019: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
11020: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
11021: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
11022: RAISE OKC_API.G_EXCEPTION_ERROR;
11023: END IF;
11024: WHEN OTHERS THEN
11025: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,

Line 11022: RAISE OKC_API.G_EXCEPTION_ERROR;

11018: WHEN G_EXCEPTION_HALT_VALIDATION THEN
11019: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
11020: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
11021: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
11022: RAISE OKC_API.G_EXCEPTION_ERROR;
11023: END IF;
11024: WHEN OTHERS THEN
11025: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
11026: p_msg_name => G_UNEXPECTED_ERROR,

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

11021: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
11022: RAISE OKC_API.G_EXCEPTION_ERROR;
11023: END IF;
11024: WHEN OTHERS THEN
11025: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
11026: p_msg_name => G_UNEXPECTED_ERROR,
11027: p_token1 => G_SQLCODE_TOKEN,
11028: p_token1_value => sqlcode,
11029: p_token2 => G_SQLERRM_TOKEN,

Line 11079: x_return_status := OKC_API.G_RET_STS_SUCCESS;

11075: l_cp_bs_ind number;
11076:
11077:
11078: BEGIN
11079: x_return_status := OKC_API.G_RET_STS_SUCCESS;
11080:
11081: l_cp_bs_tbl.DELETE;
11082: l_index := 1;
11083:

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

11139:
11140:
11141: EXCEPTION
11142: WHEN G_EXCEPTION_HALT_VALIDATION THEN
11143: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
11144: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
11145: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
11146: RAISE OKC_API.G_EXCEPTION_ERROR;
11147: END IF;

Line 11144: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

11140:
11141: EXCEPTION
11142: WHEN G_EXCEPTION_HALT_VALIDATION THEN
11143: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
11144: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
11145: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
11146: RAISE OKC_API.G_EXCEPTION_ERROR;
11147: END IF;
11148: WHEN OTHERS THEN

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

11141: EXCEPTION
11142: WHEN G_EXCEPTION_HALT_VALIDATION THEN
11143: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
11144: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
11145: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
11146: RAISE OKC_API.G_EXCEPTION_ERROR;
11147: END IF;
11148: WHEN OTHERS THEN
11149: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,

Line 11146: RAISE OKC_API.G_EXCEPTION_ERROR;

11142: WHEN G_EXCEPTION_HALT_VALIDATION THEN
11143: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
11144: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
11145: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
11146: RAISE OKC_API.G_EXCEPTION_ERROR;
11147: END IF;
11148: WHEN OTHERS THEN
11149: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
11150: p_msg_name => G_UNEXPECTED_ERROR,

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

11145: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
11146: RAISE OKC_API.G_EXCEPTION_ERROR;
11147: END IF;
11148: WHEN OTHERS THEN
11149: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
11150: p_msg_name => G_UNEXPECTED_ERROR,
11151: p_token1 => G_SQLCODE_TOKEN,
11152: p_token1_value => sqlcode,
11153: p_token2 => G_SQLERRM_TOKEN,

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

11178:
11179:
11180:
11181: l_api_version CONSTANT NUMBER := 1.0;
11182: l_init_msg_list VARCHAR2(2000) := OKC_API.G_FALSE;
11183: l_msg_count NUMBER;
11184: l_msg_data VARCHAR2(2000);
11185:
11186: -- Start - Added by PMALLARA - Bug #3992530

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

11236:
11237: -----errorout_ad ('Calculate_sll_amount STATUS = ' || x_return_status);
11238:
11239:
11240: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
11241: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
11242: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
11243: RAISE OKC_API.G_EXCEPTION_ERROR;
11244: END IF;

Line 11241: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

11237: -----errorout_ad ('Calculate_sll_amount STATUS = ' || x_return_status);
11238:
11239:
11240: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
11241: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
11242: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
11243: RAISE OKC_API.G_EXCEPTION_ERROR;
11244: END IF;
11245:

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

11238:
11239:
11240: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
11241: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
11242: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
11243: RAISE OKC_API.G_EXCEPTION_ERROR;
11244: END IF;
11245:
11246: FOR l_index IN l_sll_prorate_tbl.FIRST .. l_sll_prorate_tbl.LAST

Line 11243: RAISE OKC_API.G_EXCEPTION_ERROR;

11239:
11240: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
11241: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
11242: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
11243: RAISE OKC_API.G_EXCEPTION_ERROR;
11244: END IF;
11245:
11246: FOR l_index IN l_sll_prorate_tbl.FIRST .. l_sll_prorate_tbl.LAST
11247: LOOP

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

11299: Strm_Start_Date => Strm_Start_Date);
11300: -- End - Modified by PMALLARA - Bug #3992530
11301:
11302:
11303: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
11304: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
11305: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
11306: RAISE OKC_API.G_EXCEPTION_ERROR;
11307: END IF;

Line 11304: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

11300: -- End - Modified by PMALLARA - Bug #3992530
11301:
11302:
11303: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
11304: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
11305: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
11306: RAISE OKC_API.G_EXCEPTION_ERROR;
11307: END IF;
11308:

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

11301:
11302:
11303: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
11304: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
11305: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
11306: RAISE OKC_API.G_EXCEPTION_ERROR;
11307: END IF;
11308:
11309:

Line 11306: RAISE OKC_API.G_EXCEPTION_ERROR;

11302:
11303: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
11304: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
11305: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
11306: RAISE OKC_API.G_EXCEPTION_ERROR;
11307: END IF;
11308:
11309:
11310:

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

11368:
11369: EXCEPTION
11370:
11371: WHEN OTHERS THEN
11372: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
11373: p_msg_name => G_UNEXPECTED_ERROR,
11374: p_token1 => G_SQLCODE_TOKEN,
11375: p_token1_value => sqlcode,
11376: p_token2 => G_SQLERRM_TOKEN,

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

11420: l_sll_index NUMBER;
11421: l_index NUMBER;
11422: l_sll_end_date DATE;
11423:
11424: l_init_msg_list VARCHAR2(2000) := OKC_API.G_FALSE;
11425:
11426: BEGIN
11427: x_return_status := 'S';
11428:

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

11482: l_strm_lvl_tbl_in(l_sll_index).invoice_offset_days := l_old_sll_rec.invoice_offset_days;
11483: l_strm_lvl_tbl_in(l_sll_index).interface_offset_days := l_old_sll_rec.interface_offset_days;
11484:
11485:
11486: l_strm_lvl_tbl_in(l_sll_index).object_version_number := OKC_API.G_MISS_NUM;
11487: l_strm_lvl_tbl_in(l_sll_index).created_by := OKC_API.G_MISS_NUM;
11488: l_strm_lvl_tbl_in(l_sll_index).creation_date := SYSDATE;
11489: l_strm_lvl_tbl_in(l_sll_index).last_updated_by := OKC_API.G_MISS_NUM;
11490: l_strm_lvl_tbl_in(l_sll_index).last_update_date := SYSDATE;

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

11483: l_strm_lvl_tbl_in(l_sll_index).interface_offset_days := l_old_sll_rec.interface_offset_days;
11484:
11485:
11486: l_strm_lvl_tbl_in(l_sll_index).object_version_number := OKC_API.G_MISS_NUM;
11487: l_strm_lvl_tbl_in(l_sll_index).created_by := OKC_API.G_MISS_NUM;
11488: l_strm_lvl_tbl_in(l_sll_index).creation_date := SYSDATE;
11489: l_strm_lvl_tbl_in(l_sll_index).last_updated_by := OKC_API.G_MISS_NUM;
11490: l_strm_lvl_tbl_in(l_sll_index).last_update_date := SYSDATE;
11491:

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

11485:
11486: l_strm_lvl_tbl_in(l_sll_index).object_version_number := OKC_API.G_MISS_NUM;
11487: l_strm_lvl_tbl_in(l_sll_index).created_by := OKC_API.G_MISS_NUM;
11488: l_strm_lvl_tbl_in(l_sll_index).creation_date := SYSDATE;
11489: l_strm_lvl_tbl_in(l_sll_index).last_updated_by := OKC_API.G_MISS_NUM;
11490: l_strm_lvl_tbl_in(l_sll_index).last_update_date := SYSDATE;
11491:
11492: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
11493:

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

11522: 'OKS_SLL_PVT.insert_row(x_return_status = '||x_return_status
11523: ||', sll tbl out count = '||l_strm_lvl_tbl_out.count||')');
11524: END IF;
11525:
11526: IF NVL(x_return_status,'!') <> OKC_API.G_RET_STS_SUCCESS THEN
11527: RAISE G_EXCEPTION_HALT_VALIDATION;
11528: END IF;
11529:
11530: OPEN l_new_cp_csr;

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

11630: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.adjust_replace_product_bs.UNEXPECTED',
11631: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
11632: END IF;
11633:
11634: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
11635: p_msg_name => G_UNEXPECTED_ERROR,
11636: p_token1 => G_SQLCODE_TOKEN,
11637: p_token1_value => sqlcode,
11638: p_token2 => G_SQLERRM_TOKEN,

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

11725: l_index NUMBER;
11726: l_cp_bs_ind NUMBER;
11727: l_top_bs_ind NUMBER;
11728: l_total_amt NUMBER;
11729: l_init_msg_list VARCHAR2(2000) := OKC_API.G_FALSE;
11730: L_EXCEPTION_END Exception;
11731:
11732:
11733: BEGIN

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

11893: p_cle_id => null,
11894: p_chr_id => l_top_line_rec.dnz_chr_id);
11895:
11896: IF l_currency_code IS NULL THEN
11897: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'CURRENCY CODE NOT FOUND.');
11898: x_return_status := 'E';
11899: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
11900: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.adjust_split_bill_sch.EXCEPTION',
11901: 'currency not found for contract id = ' || l_top_line_rec.dnz_chr_id );

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

12124: );
12125:
12126: END IF;
12127:
12128: IF NVL(x_return_status,'!') <> OKC_API.G_RET_STS_SUCCESS THEN
12129: RAISE G_EXCEPTION_HALT_VALIDATION;
12130: END IF;
12131: END IF;
12132:

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

12151: l_strm_lvl_tbl_in(l_index).id := NULL;
12152: l_strm_lvl_tbl_in(l_index).cle_id := p_new_cp_tbl(i).id;
12153:
12154:
12155: l_strm_lvl_tbl_in(l_index).object_version_number := OKC_API.G_MISS_NUM;
12156: l_strm_lvl_tbl_in(l_index).created_by := OKC_API.G_MISS_NUM;
12157: l_strm_lvl_tbl_in(l_index).creation_date := SYSDATE;
12158: l_strm_lvl_tbl_in(l_index).last_updated_by := OKC_API.G_MISS_NUM;
12159: l_strm_lvl_tbl_in(l_index).last_update_date := SYSDATE;

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

12152: l_strm_lvl_tbl_in(l_index).cle_id := p_new_cp_tbl(i).id;
12153:
12154:
12155: l_strm_lvl_tbl_in(l_index).object_version_number := OKC_API.G_MISS_NUM;
12156: l_strm_lvl_tbl_in(l_index).created_by := OKC_API.G_MISS_NUM;
12157: l_strm_lvl_tbl_in(l_index).creation_date := SYSDATE;
12158: l_strm_lvl_tbl_in(l_index).last_updated_by := OKC_API.G_MISS_NUM;
12159: l_strm_lvl_tbl_in(l_index).last_update_date := SYSDATE;
12160:

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

12154:
12155: l_strm_lvl_tbl_in(l_index).object_version_number := OKC_API.G_MISS_NUM;
12156: l_strm_lvl_tbl_in(l_index).created_by := OKC_API.G_MISS_NUM;
12157: l_strm_lvl_tbl_in(l_index).creation_date := SYSDATE;
12158: l_strm_lvl_tbl_in(l_index).last_updated_by := OKC_API.G_MISS_NUM;
12159: l_strm_lvl_tbl_in(l_index).last_update_date := SYSDATE;
12160:
12161:
12162: END LOOP;

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

12176: 'OKS_SLL_PVT.insert_row(x_return_status = '||x_return_status
12177: ||', sll tbl out count = '||l_strm_lvl_tbl_out.count||')');
12178: END IF;
12179:
12180: IF NVL(x_return_status,'!') <> OKC_API.G_RET_STS_SUCCESS THEN
12181: RAISE G_EXCEPTION_HALT_VALIDATION;
12182: END IF;
12183:
12184: l_cp_sll_out_tbl.DELETE;

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

12234: 'Create_cp_lvl_elements(x_return_status = '||x_return_status
12235: ||', l_top_bs_tbl count = '||l_top_bs_tbl.count||')');
12236: END IF;
12237:
12238: IF NVL(x_return_status,'!') <> OKC_API.G_RET_STS_SUCCESS THEN
12239: RAISE G_EXCEPTION_HALT_VALIDATION;
12240: END IF;
12241:
12242: ----adjust lvl element amt for old cp and top bs

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

12252: 'Adjust_billed_lvl_element(x_return_status = '||x_return_status
12253: ||', l_cp_old_bs_tbl count = '||l_cp_old_bs_tbl.count||')');
12254: END IF;
12255:
12256: IF NVL(x_return_status,'!') <> OKC_API.G_RET_STS_SUCCESS THEN
12257: RAISE G_EXCEPTION_HALT_VALIDATION;
12258: END IF;
12259:
12260:

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

12276: 'oks_bill_util_pub.adjust_split_bill_rec(x_return_status = '||x_return_status
12277: ||'old line id = ' || l_old_cp_rec.cp_id || ')');
12278: END IF;
12279:
12280: IF NVL(x_return_status,'!') <> OKC_API.G_RET_STS_SUCCESS THEN
12281: ----errorout_aD('ADJUST_SPLIT_BILL_REC ststaus = ' || x_return_status);
12282: RAISE G_EXCEPTION_HALT_VALIDATION;
12283: END IF;
12284:

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

12350: 'Create_cp_lvl_elements(x_return_status = '||x_return_status
12351: ||', l_top_bs_tbl count = '||l_top_bs_tbl.count||')');
12352: END IF;
12353:
12354: IF NVL(x_return_status,'!') <> OKC_API.G_RET_STS_SUCCESS THEN
12355: RAISE G_EXCEPTION_HALT_VALIDATION;
12356: END IF;
12357:
12358:

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

12390: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.adjust_split_bill_sch.UNEXPECTED',
12391: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
12392: END IF;
12393:
12394: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
12395: p_msg_name => G_UNEXPECTED_ERROR,
12396: p_token1 => G_SQLCODE_TOKEN,
12397: p_token1_value => sqlcode,
12398: p_token2 => G_SQLERRM_TOKEN,

Line 12420: x_return_status := OKC_API.G_RET_STS_SUCCESS;

12416: l_amt NUMBER;
12417:
12418: BEGIN
12419:
12420: x_return_status := OKC_API.G_RET_STS_SUCCESS;
12421:
12422: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
12423:
12424: fnd_log.STRING (fnd_log.level_statement,

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

12464: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.Prorate_sll_amt.UNEXPECTED',
12465: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
12466: END IF;
12467:
12468: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
12469: p_msg_name => G_UNEXPECTED_ERROR,
12470: p_token1 => G_SQLCODE_TOKEN,
12471: p_token1_value => sqlcode,
12472: p_token2 => G_SQLERRM_TOKEN,

Line 12500: x_return_status := OKC_API.G_RET_STS_SUCCESS;

12496: l_index NUMBER;
12497:
12498: BEGIN
12499:
12500: x_return_status := OKC_API.G_RET_STS_SUCCESS;
12501:
12502: l_index := 1;
12503: x_new_cp_bs_tbl.DELETE;
12504:

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

12557: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.Adjust_billed_lvl_element.UNEXPECTED',
12558: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
12559: END IF;
12560:
12561: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
12562: p_msg_name => G_UNEXPECTED_ERROR,
12563: p_token1 => G_SQLCODE_TOKEN,
12564: p_token1_value => sqlcode,
12565: p_token2 => G_SQLERRM_TOKEN,

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

12648: l_cp_bs_ind NUMBER;
12649: l_top_bs_ind NUMBER;
12650:
12651: l_api_Version Number := 1;
12652: l_init_msg_list VARCHAR2(2000) := OKC_API.G_FALSE;
12653: l_msg_list VARCHAR2(1) DEFAULT OKC_API.G_FALSE;
12654: l_msg_count Number;
12655: l_msg_data Varchar2(2000) := NULL;
12656:

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

12649: l_top_bs_ind NUMBER;
12650:
12651: l_api_Version Number := 1;
12652: l_init_msg_list VARCHAR2(2000) := OKC_API.G_FALSE;
12653: l_msg_list VARCHAR2(1) DEFAULT OKC_API.G_FALSE;
12654: l_msg_count Number;
12655: l_msg_data Varchar2(2000) := NULL;
12656:
12657: l_top_line_id Number;

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

12706:
12707: If l_bill_type_csr%Notfound then
12708: Close l_bill_type_Csr;
12709: x_return_status := 'E';
12710: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'BILLING SCHEDULE TYPE NOT FOUND.');
12711: RAISE G_EXCEPTION_HALT_VALIDATION;
12712: End If;
12713:
12714: Close l_bill_type_Csr;

Line 12802: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

12798: x_msg_data => l_msg_data,
12799: p_letv_tbl => l_top_bs_tbl,
12800: x_letv_tbl => l_lvl_ele_tbl_out);
12801:
12802: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
12803: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
12804: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
12805: RAISE OKC_API.G_EXCEPTION_ERROR;
12806: END IF;

Line 12803: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

12799: p_letv_tbl => l_top_bs_tbl,
12800: x_letv_tbl => l_lvl_ele_tbl_out);
12801:
12802: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
12803: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
12804: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
12805: RAISE OKC_API.G_EXCEPTION_ERROR;
12806: END IF;
12807:

Line 12804: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN

12800: x_letv_tbl => l_lvl_ele_tbl_out);
12801:
12802: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
12803: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
12804: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
12805: RAISE OKC_API.G_EXCEPTION_ERROR;
12806: END IF;
12807:
12808: END IF; ---l_cp_bs_tbl.COUNT > 0

Line 12805: RAISE OKC_API.G_EXCEPTION_ERROR;

12801:
12802: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
12803: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
12804: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
12805: RAISE OKC_API.G_EXCEPTION_ERROR;
12806: END IF;
12807:
12808: END IF; ---l_cp_bs_tbl.COUNT > 0
12809: