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_OCINT_PUB dependencies on OKC_API

Line 8: g_required_value CONSTANT VARCHAR2 (200) := okc_api.g_required_value;

4: g_unexpected_error CONSTANT VARCHAR2 (200)
5: := 'OKC_CONTRACTS_UNEXP_ERROR';
6: g_sqlcode_token CONSTANT VARCHAR2 (200) := 'SQLcode';
7: g_sqlerrm_token CONSTANT VARCHAR2 (200) := 'SQLerrm';
8: g_required_value CONSTANT VARCHAR2 (200) := okc_api.g_required_value;
9: g_col_name_token CONSTANT VARCHAR2 (200) := okc_api.g_col_name_token;
10: ----------------------------------------------------------------------------------------
11: -- Constants used for Message Logging
12: g_level_unexpected CONSTANT NUMBER := fnd_log.level_unexpected;

Line 9: g_col_name_token CONSTANT VARCHAR2 (200) := okc_api.g_col_name_token;

5: := 'OKC_CONTRACTS_UNEXP_ERROR';
6: g_sqlcode_token CONSTANT VARCHAR2 (200) := 'SQLcode';
7: g_sqlerrm_token CONSTANT VARCHAR2 (200) := 'SQLerrm';
8: g_required_value CONSTANT VARCHAR2 (200) := okc_api.g_required_value;
9: g_col_name_token CONSTANT VARCHAR2 (200) := okc_api.g_col_name_token;
10: ----------------------------------------------------------------------------------------
11: -- Constants used for Message Logging
12: g_level_unexpected CONSTANT NUMBER := fnd_log.level_unexpected;
13: g_level_error CONSTANT NUMBER := fnd_log.level_error;

Line 543: l_return_status VARCHAR2 (1) := okc_api.g_ret_sts_success;

539: --l_old_repv_rec l_old_repv_csr%ROWTYPE;
540: l_obj_vers_num NUMBER;
541: l_new_repv_rec oks_rep_pvt.repv_rec_type;
542: l_repv_rec oks_rep_pvt.repv_rec_type;
543: l_return_status VARCHAR2 (1) := okc_api.g_ret_sts_success;
544: l_msg_count NUMBER;
545: l_msg_data VARCHAR2 (2000);
546: l_index NUMBER;
547: BEGIN

Line 616: x_return_status := okc_api.g_ret_sts_unexp_error;

612: );
613: x_return_status := l_return_status;
614: WHEN OTHERS
615: THEN
616: x_return_status := okc_api.g_ret_sts_unexp_error;
617: fnd_file.put_line (fnd_file.LOG,
618: 'Oracle Error Code is -' || TO_CHAR (SQLCODE)
619: );
620: fnd_file.put_line (fnd_file.LOG,

Line 774: x_return_status VARCHAR2 (1) := okc_api.g_ret_sts_success;

770: l_sll_tbl oks_bill_sch.streamlvl_tbl;
771: l_bil_sch_out oks_bill_sch.itembillsch_tbl;
772: x_msg_count NUMBER;
773: x_msg_data VARCHAR2 (2000);
774: x_return_status VARCHAR2 (1) := okc_api.g_ret_sts_success;
775: l_repv_tbl oks_rep_pvt.repv_tbl_type;
776: l_reproc_line_rec oks_rep_pvt.repv_rec_type;
777: l_serv_ref_rec l_serv_ref_csr%ROWTYPE;
778: l_upd_tbl oks_rep_pvt.repv_tbl_type;

Line 1203: l_return_status := okc_api.g_ret_sts_error;

1199: CLOSE l_hdr_scs_csr;
1200:
1201: IF l_hdr_scs_code <> fnd_profile.VALUE ('OKS_CONTRACT_CATEGORY')
1202: THEN
1203: l_return_status := okc_api.g_ret_sts_error;
1204: --OKC_API.set_message(G_APP_NAME,'OKS_CONTRACT_CATEGORY','Cat',l_hdr_scs_code);
1205: fnd_message.set_name ('OKS', 'OKS_CONTRACT_CATEGORY');
1206: fnd_message.set_token (token => 'Cat',
1207: VALUE => l_hdr_scs_code);

Line 1204: --OKC_API.set_message(G_APP_NAME,'OKS_CONTRACT_CATEGORY','Cat',l_hdr_scs_code);

1200:
1201: IF l_hdr_scs_code <> fnd_profile.VALUE ('OKS_CONTRACT_CATEGORY')
1202: THEN
1203: l_return_status := okc_api.g_ret_sts_error;
1204: --OKC_API.set_message(G_APP_NAME,'OKS_CONTRACT_CATEGORY','Cat',l_hdr_scs_code);
1205: fnd_message.set_name ('OKS', 'OKS_CONTRACT_CATEGORY');
1206: fnd_message.set_token (token => 'Cat',
1207: VALUE => l_hdr_scs_code);
1208: l_order_error := '#' || fnd_message.get_encoded || '#';

Line 1280: l_hdr_rec.contract_number := okc_api.g_miss_char;

1276:
1277: --mmadhavi bug 4069827
1278:
1279: -- rty_code has been added, (Extwarranty consolidation) vigandhi
1280: l_hdr_rec.contract_number := okc_api.g_miss_char;
1281: l_hdr_rec.rty_code := 'CONTRACTSERVICESORDER';
1282: l_hdr_rec.start_date := l_k_line_rec.srv_sdt;
1283: l_hdr_rec.end_date := l_k_line_rec.srv_edt;
1284: -- l_hdr_rec.sts_code := 'ACTIVE';

Line 1433: p_commit => okc_api.g_false,

1429: THEN
1430: okc_oc_int_pub.create_k_relationships
1431: (p_api_version => l_api_version,
1432: p_init_msg_list => l_init_msg_list,
1433: p_commit => okc_api.g_false,
1434: p_sales_contract_id => okc_api.g_miss_num,
1435: p_service_contract_id => l_chrid,
1436: p_quote_id => okc_api.g_miss_num,
1437: p_quote_line_tab => okc_oc_int_pub.g_miss_ql_tab,

Line 1434: p_sales_contract_id => okc_api.g_miss_num,

1430: okc_oc_int_pub.create_k_relationships
1431: (p_api_version => l_api_version,
1432: p_init_msg_list => l_init_msg_list,
1433: p_commit => okc_api.g_false,
1434: p_sales_contract_id => okc_api.g_miss_num,
1435: p_service_contract_id => l_chrid,
1436: p_quote_id => okc_api.g_miss_num,
1437: p_quote_line_tab => okc_oc_int_pub.g_miss_ql_tab,
1438: p_order_id => l_hdr_rec.order_hdr_id,

Line 1436: p_quote_id => okc_api.g_miss_num,

1432: p_init_msg_list => l_init_msg_list,
1433: p_commit => okc_api.g_false,
1434: p_sales_contract_id => okc_api.g_miss_num,
1435: p_service_contract_id => l_chrid,
1436: p_quote_id => okc_api.g_miss_num,
1437: p_quote_line_tab => okc_oc_int_pub.g_miss_ql_tab,
1438: p_order_id => l_hdr_rec.order_hdr_id,
1439: p_order_line_tab => okc_oc_int_pub.g_miss_ol_tab,
1440: p_trace_mode => NULL,

Line 1547: l_line_rec.k_line_number := okc_api.g_miss_char;

1543: 'OC_INT ...... Cov Temp Id = '
1544: || NVL (l_k_line_rec.coverage_schd_id, -12345)
1545: );
1546: l_line_rec.k_id := l_chrid;
1547: l_line_rec.k_line_number := okc_api.g_miss_char;
1548: -- l_line_rec.line_sts_code := 'ACTIVE';
1549: l_line_rec.cust_account := l_k_line_rec.customer_acct_id;
1550: l_line_rec.org_id := l_k_header_rec.authoring_org_id;
1551: -- mmadhavi should change to org_id for MOAC

Line 1751: l_covd_rec.line_number := okc_api.g_miss_char;

1747:
1748: -- mmadhavi end of BOM explosion
1749: l_covd_rec.k_id := l_chrid;
1750: l_covd_rec.attach_2_line_id := l_lineid;
1751: l_covd_rec.line_number := okc_api.g_miss_char;
1752: --l_covd_rec.product_sts_code := 'ACTIVE';
1753: l_covd_rec.customer_product_id := l_cp_tbl (cp_ctr).cp_id;
1754: --l_covd_rec.Product_Segment1 := l_cp_name;
1755: --l_covd_rec.Product_Desc := l_cp_desc;

Line 1929: IF NOT l_return_status = okc_api.g_ret_sts_success

1925: || l_return_status
1926: );
1927: x_return_status := l_return_status;
1928:
1929: IF NOT l_return_status = okc_api.g_ret_sts_success
1930: THEN
1931: x_return_status := l_return_status;
1932: RAISE g_exception_halt_validation;
1933: END IF;

Line 1971: IF NOT l_return_status = okc_api.g_ret_sts_success

1967: || l_return_status
1968: );
1969: x_return_status := l_return_status;
1970:
1971: IF NOT l_return_status = okc_api.g_ret_sts_success
1972: THEN
1973: x_return_status := l_return_status;
1974: RAISE g_exception_halt_validation;
1975: END IF;

Line 2126: IF l_return_status <> okc_api.g_ret_sts_success

2122: );
2123: END IF;
2124:
2125: --OKS_RENEW_PVT.DEBUG_LOG( '(OKS_EXTWARPRGM_PVT).Create_Billing_Schd :: Create_Bill_Sch_Rules Status : '|| l_return_status );
2126: IF l_return_status <> okc_api.g_ret_sts_success
2127: THEN
2128: okc_api.set_message (g_app_name,
2129: g_required_value,
2130: g_col_name_token,

Line 2128: okc_api.set_message (g_app_name,

2124:
2125: --OKS_RENEW_PVT.DEBUG_LOG( '(OKS_EXTWARPRGM_PVT).Create_Billing_Schd :: Create_Bill_Sch_Rules Status : '|| l_return_status );
2126: IF l_return_status <> okc_api.g_ret_sts_success
2127: THEN
2128: okc_api.set_message (g_app_name,
2129: g_required_value,
2130: g_col_name_token,
2131: 'Sched Billing Rule (LINE)'
2132: );

Line 2296: okc_api.set_message (g_app_name,

2292: THEN
2293: RAISE g_exception_halt_validation;
2294: END IF;
2295: ELSE
2296: okc_api.set_message (g_app_name,
2297: g_required_value,
2298: g_col_name_token,
2299: 'level elements NOT EXIST'
2300: );

Line 2356: x_return_status := okc_api.g_ret_sts_unexp_error;

2352: CLOSE c_extwar_hdr_amount;
2353: END IF;
2354: WHEN OTHERS
2355: THEN
2356: x_return_status := okc_api.g_ret_sts_unexp_error;
2357: IF c_extwar_line_amount%ISOPEN THEN
2358: CLOSE c_extwar_line_amount;
2359: END IF;
2360: IF c_extwar_hdr_amount%ISOPEN THEN

Line 2408: l_return_status VARCHAR2 (1) := okc_api.g_ret_sts_success;

2404: AND rep.order_id = oh.header_id
2405: AND conc_request_id IS NULL;
2406:
2407: l_repv_tbl oks_rep_pvt.repv_tbl_type;
2408: l_return_status VARCHAR2 (1) := okc_api.g_ret_sts_success;
2409: l_ordline_rec oks_rep_pvt.repv_rec_type;
2410: l_ptr NUMBER;
2411: l_source VARCHAR2 (30);
2412:

Line 2457: l_init_msg_list VARCHAR2 (1) := okc_api.g_false;

2453: l_fulfilled_qty NUMBER;
2454: l_exists VARCHAR2 (1) := 'Y';
2455: l_ptr1 NUMBER;
2456: l_first_order_line NUMBER;
2457: l_init_msg_list VARCHAR2 (1) := okc_api.g_false;
2458: l_return_status VARCHAR2 (1) := okc_api.g_ret_sts_success;
2459: l_msg_count NUMBER := 0;
2460: l_msg_data VARCHAR2 (2000);
2461: l_repv_rec oks_rep_pvt.repv_rec_type;

Line 2458: l_return_status VARCHAR2 (1) := okc_api.g_ret_sts_success;

2454: l_exists VARCHAR2 (1) := 'Y';
2455: l_ptr1 NUMBER;
2456: l_first_order_line NUMBER;
2457: l_init_msg_list VARCHAR2 (1) := okc_api.g_false;
2458: l_return_status VARCHAR2 (1) := okc_api.g_ret_sts_success;
2459: l_msg_count NUMBER := 0;
2460: l_msg_data VARCHAR2 (2000);
2461: l_repv_rec oks_rep_pvt.repv_rec_type;
2462: l_out_repv_rec oks_rep_pvt.repv_rec_type;

Line 2651: okc_api.set_message (g_app_name,

2647: || SQLCODE
2648: || ':'
2649: || SQLERRM
2650: );
2651: okc_api.set_message (g_app_name,
2652: g_unexpected_error,
2653: g_sqlcode_token,
2654: SQLCODE,
2655: g_sqlerrm_token,

Line 2660: x_return_status := okc_api.g_ret_sts_unexp_error;

2656: SQLERRM
2657: );
2658: WHEN OTHERS
2659: THEN
2660: x_return_status := okc_api.g_ret_sts_unexp_error;
2661: fnd_file.put_line (fnd_file.LOG,
2662: ' Error in Get_Order_lines : '
2663: || SQLCODE
2664: || ':'

Line 2667: okc_api.set_message (g_app_name,

2663: || SQLCODE
2664: || ':'
2665: || SQLERRM
2666: );
2667: okc_api.set_message (g_app_name,
2668: g_unexpected_error,
2669: g_sqlcode_token,
2670: SQLCODE,
2671: g_sqlerrm_token,

Line 2863: okc_api.set_message (g_app_name,

2859: || SQLCODE
2860: || ':'
2861: || SQLERRM
2862: );
2863: okc_api.set_message (g_app_name,
2864: g_unexpected_error,
2865: g_sqlcode_token,
2866: SQLCODE,
2867: g_sqlerrm_token,

Line 2872: x_return_status := okc_api.g_ret_sts_unexp_error;

2868: SQLERRM
2869: );
2870: WHEN OTHERS
2871: THEN
2872: x_return_status := okc_api.g_ret_sts_unexp_error;
2873: fnd_file.put_line (fnd_file.LOG,
2874: ' Error in Get_Order_Details : '
2875: || SQLCODE
2876: || ':'

Line 2879: okc_api.set_message (g_app_name,

2875: || SQLCODE
2876: || ':'
2877: || SQLERRM
2878: );
2879: okc_api.set_message (g_app_name,
2880: g_unexpected_error,
2881: g_sqlcode_token,
2882: SQLCODE,
2883: g_sqlerrm_token,

Line 3299: IF (l_upd_tbl (1).ERROR_TEXT = okc_api.g_miss_char)

3295: );
3296: l_error_temp :=
3297: l_error_temp || fnd_message.get_encoded;
3298:
3299: IF (l_upd_tbl (1).ERROR_TEXT = okc_api.g_miss_char)
3300: THEN
3301: l_upd_tbl (1).ERROR_TEXT :=
3302: l_error_temp || l_error_msg;
3303: l_upd_tbl (1).success_flag := 'E';

Line 3634: x_return_status := okc_api.g_ret_sts_unexp_error;

3630: THEN
3631: fnd_file.put_line (fnd_file.LOG,
3632: 'In OTHERS Exception of Order_Reprocess'
3633: );
3634: x_return_status := okc_api.g_ret_sts_unexp_error;
3635: fnd_file.put_line (fnd_file.LOG,
3636: ' Error in Order Reprocess : '
3637: || SQLCODE
3638: || ':'

Line 3641: okc_api.set_message (g_app_name,

3637: || SQLCODE
3638: || ':'
3639: || SQLERRM
3640: );
3641: okc_api.set_message (g_app_name,
3642: g_unexpected_error,
3643: g_sqlcode_token,
3644: SQLCODE,
3645: g_sqlerrm_token,

Line 3655: l_return_status VARCHAR2 (1) := okc_api.g_ret_sts_success;

3651: errbuf OUT NOCOPY VARCHAR2,
3652: retcode OUT NOCOPY NUMBER
3653: )
3654: IS
3655: l_return_status VARCHAR2 (1) := okc_api.g_ret_sts_success;
3656: l_msg_count NUMBER;
3657: l_msg_data VARCHAR2 (2000);
3658: l_user_id NUMBER;
3659: l_del_rec oks_rep_pvt.repv_rec_type;

Line 3680: l_return_status VARCHAR2 (1) := okc_api.g_ret_sts_success;

3676: FROM oks_reprocessing_v
3677: WHERE success_flag = 'S';
3678:
3679: l_repv_tbl oks_rep_pvt.repv_tbl_type;
3680: l_return_status VARCHAR2 (1) := okc_api.g_ret_sts_success;
3681: l_ordline_rec oks_rep_pvt.repv_rec_type;
3682: l_ptr NUMBER;
3683: BEGIN
3684: fnd_file.put_line (fnd_file.LOG, 'Inside procedure Get Order lines');

Line 3699: x_return_status := okc_api.g_ret_sts_unexp_error;

3695: fnd_file.put_line (fnd_file.LOG, 'Exiting Get Order Details');
3696: EXCEPTION
3697: WHEN OTHERS
3698: THEN
3699: x_return_status := okc_api.g_ret_sts_unexp_error;
3700: fnd_file.put_line (fnd_file.LOG,
3701: ' Error in Get_Order_Details : '
3702: || SQLCODE
3703: || ':'

Line 3706: okc_api.set_message (g_app_name,

3702: || SQLCODE
3703: || ':'
3704: || SQLERRM
3705: );
3706: okc_api.set_message (g_app_name,
3707: g_unexpected_error,
3708: g_sqlcode_token,
3709: SQLCODE,
3710: g_sqlerrm_token,