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

APPS.OKS_BILL_MIGRATION dependencies on OKC_API

Line 233: l_init_msg_list CONSTANT VARCHAR2(1) := OKC_API.G_FALSE;

229: IS
230: l_lvl_element_tbl_in oks_bill_level_elements_pvt.letv_tbl_type;
231: l_lvl_element_tbl_out oks_bill_level_elements_pvt.letv_tbl_type;
232: l_api_version CONSTANT NUMBER := 1.0;
233: l_init_msg_list CONSTANT VARCHAR2(1) := OKC_API.G_FALSE;
234: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
235: l_index NUMBER;
236: l_module VARCHAR2(50) := 'TBL_RULE.CREATE_ROWS';
237: l_debug BOOLEAN := TRUE;

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

230: l_lvl_element_tbl_in oks_bill_level_elements_pvt.letv_tbl_type;
231: l_lvl_element_tbl_out oks_bill_level_elements_pvt.letv_tbl_type;
232: l_api_version CONSTANT NUMBER := 1.0;
233: l_init_msg_list CONSTANT VARCHAR2(1) := OKC_API.G_FALSE;
234: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
235: l_index NUMBER;
236: l_module VARCHAR2(50) := 'TBL_RULE.CREATE_ROWS';
237: l_debug BOOLEAN := TRUE;
238:

Line 473: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

469:
470: Procedure MIGRATE_CURRENCY
471: IS
472: --- Global Constants -- this will be moved to package header
473: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
474: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKC_API.G_RET_STS_ERROR;
475: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
476: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
477: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';

Line 474: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKC_API.G_RET_STS_ERROR;

470: Procedure MIGRATE_CURRENCY
471: IS
472: --- Global Constants -- this will be moved to package header
473: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
474: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKC_API.G_RET_STS_ERROR;
475: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
476: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
477: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
478: G_APP_NAME CONSTANT VARCHAR2(3) := 'OKS';

Line 559: -- Call OKC API to find the contract requires migration or not

555: Exception When Others then
556: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('CONTRACT_LINE');
557: End ;
558:
559: -- Call OKC API to find the contract requires migration or not
560: l_migration_req := OKC_CURRENCY_API.IS_EURO_CONVERSION_NEEDED(l_cont_rec.CURRENCY_CODE) ;
561:
562:
563:

Line 642: x_return_status := OKC_API.G_RET_STS_ERROR;

638: --dbms_output.put_line('Currency migration program has completed with NO errors ') ;
639: EXCEPTION
640: WHEN Others THEN
641: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('MAIN');
642: x_return_status := OKC_API.G_RET_STS_ERROR;
643: OKC_API.SET_MESSAGE
644: ( p_app_name => G_APP_NAME,
645: p_msg_name => G_UNEXPECTED_ERROR,
646: p_token1 => G_SQLCODE_TOKEN,

Line 643: OKC_API.SET_MESSAGE

639: EXCEPTION
640: WHEN Others THEN
641: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('MAIN');
642: x_return_status := OKC_API.G_RET_STS_ERROR;
643: OKC_API.SET_MESSAGE
644: ( p_app_name => G_APP_NAME,
645: p_msg_name => G_UNEXPECTED_ERROR,
646: p_token1 => G_SQLCODE_TOKEN,
647: p_token1_value => SQLCODE,

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

669: l_start_date DATE;
670: l_end_date DATE;
671: l_duration NUMBER := 0;
672: l_time VARCHAR2(450) ;
673: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
674: l_ctr NUMBER := 0;
675: l_tbl_ctr NUMBER := 0;
676: l_invoice_rule_id NUMBER :=0;
677: l_lvl_rec_ctr NUMBER := 0;

Line 1230: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1226: When G_EXCEPTION_HALT_VALIDATION Then
1227: x_return_status := l_return_status;
1228: Null;
1229: When Others Then
1230: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1231: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
1232:
1233: End Create_Billing_schd ;
1234:

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

1227: x_return_status := l_return_status;
1228: Null;
1229: When Others Then
1230: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1231: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
1232:
1233: End Create_Billing_schd ;
1234:
1235:

Line 1347: IF L_RETURN_STATUS = OKC_API.G_RET_STS_SUCCESS THEN

1343: , X_msg_count => l_msg_count
1344: , X_Return_status => l_return_status);
1345:
1346:
1347: IF L_RETURN_STATUS = OKC_API.G_RET_STS_SUCCESS THEN
1348:
1349: -- call to create billing records (Bcl / Bsl)
1350: CREATE_BILL_DTLS
1351: ( p_dnz_chr_id => l_dnz_chr_id(i),

Line 1387: l_return_status := OKC_API.G_RET_STS_ERROR;

1383:
1384:
1385: EXCEPTION WHEN OTHERS THEN
1386: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
1387: l_return_status := OKC_API.G_RET_STS_ERROR;
1388: OKC_API.SET_MESSAGE
1389: (
1390: p_app_name => G_APP_NAME,
1391: p_msg_name => G_UNEXPECTED_ERROR,

Line 1388: OKC_API.SET_MESSAGE

1384:
1385: EXCEPTION WHEN OTHERS THEN
1386: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
1387: l_return_status := OKC_API.G_RET_STS_ERROR;
1388: OKC_API.SET_MESSAGE
1389: (
1390: p_app_name => G_APP_NAME,
1391: p_msg_name => G_UNEXPECTED_ERROR,
1392: p_token1 => G_SQLCODE_TOKEN,

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

1520: l_start_date DATE;
1521: l_end_date DATE;
1522: l_duration NUMBER := 0;
1523: l_time VARCHAR2(450) ;
1524: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1525: l_ctr NUMBER := 0;
1526: l_tbl_ctr NUMBER := 0;
1527: l_invoice_rule_id NUMBER :=0;
1528: l_lvl_rec_ctr NUMBER := 0;

Line 1545: l_return_status := OKC_API.G_RET_STS_SUCCESS;

1541:
1542:
1543:
1544: BEGIN
1545: l_return_status := OKC_API.G_RET_STS_SUCCESS;
1546: DBMS_TRANSACTION.SAVEPOINT('BEFORE_TRANSACTION');
1547:
1548:
1549: OPEN top_line_grp_csr ;

Line 2024: l_return_status := OKC_API.G_RET_STS_ERROR;

2020:
2021:
2022: EXCEPTION WHEN OTHERS THEN
2023: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
2024: l_return_status := OKC_API.G_RET_STS_ERROR;
2025: OKC_API.SET_MESSAGE
2026: (
2027: p_app_name => G_APP_NAME,
2028: p_msg_name => G_UNEXPECTED_ERROR,

Line 2025: OKC_API.SET_MESSAGE

2021:
2022: EXCEPTION WHEN OTHERS THEN
2023: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
2024: l_return_status := OKC_API.G_RET_STS_ERROR;
2025: OKC_API.SET_MESSAGE
2026: (
2027: p_app_name => G_APP_NAME,
2028: p_msg_name => G_UNEXPECTED_ERROR,
2029: p_token1 => G_SQLCODE_TOKEN,

Line 2102: l_return_status Varchar2(1):= OKC_API.G_RET_STS_SUCCESS;

2098:
2099:
2100:
2101: lin_id number;
2102: l_return_status Varchar2(1):= OKC_API.G_RET_STS_SUCCESS;
2103: l_msg_cnt Number;
2104: l_msg_data Varchar2(2000);
2105: l_ar_inv_date Date;
2106: l_line_id number ;

Line 2227: IF L_CONTINUE_PROCESSING AND L_RETURN_STATUS = OKC_API.G_RET_STS_SUCCESS THEN

2223:
2224: L_CONTINUE_PROCESSING := TRUE ;
2225: END IF ;
2226:
2227: IF L_CONTINUE_PROCESSING AND L_RETURN_STATUS = OKC_API.G_RET_STS_SUCCESS THEN
2228: UPDATE_OKS_LEVEL_ELEMENTS( P_DNZ_CHR_ID ,
2229: X_RETURN_STATUS );
2230: IF (L_RETURN_STATUS <> 'S') THEN
2231: X_RETURN_STATUS := L_RETURN_STATUS;

Line 2243: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

2239: EXCEPTION
2240: WHEN G_EXCEPTION_HALT_VALIDATION THEN
2241: X_RETURN_STATUS := l_return_status ;
2242: WHEN OTHERS THEN
2243: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2244: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
2245:
2246:
2247:

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

2240: WHEN G_EXCEPTION_HALT_VALIDATION THEN
2241: X_RETURN_STATUS := l_return_status ;
2242: WHEN OTHERS THEN
2243: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2244: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
2245:
2246:
2247:
2248: END CREATE_BILL_DTLS ;

Line 2270: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

2266: X_RETURN_STATUS := 'S' ;
2267:
2268: EXCEPTION
2269: WHEN OTHERS THEN
2270: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2271: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
2272:
2273:
2274: END UPDATE_OKS_LEVEL_ELEMENTS ;

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

2267:
2268: EXCEPTION
2269: WHEN OTHERS THEN
2270: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2271: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
2272:
2273:
2274: END UPDATE_OKS_LEVEL_ELEMENTS ;
2275: