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

Line 240: okc_api.set_message (g_app_name,

236: END IF;
237: EXCEPTION
238: WHEN OTHERS
239: THEN
240: okc_api.set_message (g_app_name,
241: g_unexpected_error,
242: g_sqlcode_token,
243: SQLCODE,
244: g_sqlerrm_token,

Line 400: okc_api.set_message(g_app_name,

396: );
397: END IF;
398: END IF;
399: IF p_context_level = G_CONTEXT_ORDER_HEADER THEN
400: okc_api.set_message(g_app_name,
401: 'OKS_CC_INS_ASSG_NOT_FOUND',
402: 'ORDER_NUMBER',
403: l_order_number
404: );

Line 406: okc_api.set_message(g_app_name,

402: 'ORDER_NUMBER',
403: l_order_number
404: );
405: ELSE
406: okc_api.set_message(g_app_name,
407: 'OKS_LINE_CC_INS_ASSG_NOT_FOUND',
408: 'ORDER_LINE_ID',
409: p_order_line_id
410: );

Line 535: okc_api.set_message(g_app_name,

531: );
532: END IF;
533: END IF;
534: IF p_context_level = G_CONTEXT_ORDER_HEADER THEN
535: okc_api.set_message(g_app_name,
536: 'OKS_CC_EXTN_CREATN_FAILED',
537: 'ORDER_NUMBER',
538: l_order_number
539: );

Line 541: okc_api.set_message(g_app_name,

537: 'ORDER_NUMBER',
538: l_order_number
539: );
540: ELSE
541: okc_api.set_message(g_app_name,
542: 'OKS_LINE_CC_EXTN_CREATN_FAILED',
543: 'ORDER_LINE_ID',
544: p_order_line_id
545: );

Line 583: x_return_status := okc_api.g_ret_sts_unexp_error;

579: IF c_party%ISOPEN THEN
580: CLOSE c_party;
581: END IF;
582:
583: x_return_status := okc_api.g_ret_sts_unexp_error;
584: okc_api.set_message (g_app_name,
585: g_unexpected_error,
586: g_sqlcode_token,
587: SQLCODE,

Line 584: okc_api.set_message (g_app_name,

580: CLOSE c_party;
581: END IF;
582:
583: x_return_status := okc_api.g_ret_sts_unexp_error;
584: okc_api.set_message (g_app_name,
585: g_unexpected_error,
586: g_sqlcode_token,
587: SQLCODE,
588: g_sqlerrm_token,

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

622: )
623: IS
624: l_api_version CONSTANT NUMBER := 1.0;
625: l_init_msg_list CONSTANT VARCHAR2 (1) := 'F';
626: l_return_status VARCHAR2 (1) := okc_api.g_ret_sts_success;
627: l_index VARCHAR2 (240);
628: --Party Role
629: l_cplv_tbl_in okc_contract_party_pub.cplv_tbl_type;
630: l_cplv_tbl_out okc_contract_party_pub.cplv_tbl_type;

Line 652: l_return_status := okc_api.g_ret_sts_success;

648: AND rle_code = p_rle_code;
649:
650: l_roleid NUMBER;
651: BEGIN
652: l_return_status := okc_api.g_ret_sts_success;
653:
654: IF p_cleid IS NULL
655: THEN
656: l_roleid := NULL;

Line 732: okc_api.set_message (g_app_name,

728: IF l_return_status = 'S'
729: THEN
730: x_roleid := l_cplv_tbl_out (1).ID;
731: ELSE
732: okc_api.set_message (g_app_name,
733: g_required_value,
734: g_col_name_token,
735: p_rle_code || ' Party Role (HEADER)'
736: );

Line 746: x_return_status := okc_api.g_ret_sts_unexp_error;

742: x_return_status := l_return_status;
743: NULL;
744: WHEN OTHERS
745: THEN
746: x_return_status := okc_api.g_ret_sts_unexp_error;
747: okc_api.set_message (g_app_name,
748: g_unexpected_error,
749: g_sqlcode_token,
750: SQLCODE,

Line 747: okc_api.set_message (g_app_name,

743: NULL;
744: WHEN OTHERS
745: THEN
746: x_return_status := okc_api.g_ret_sts_unexp_error;
747: okc_api.set_message (g_app_name,
748: g_unexpected_error,
749: g_sqlcode_token,
750: SQLCODE,
751: g_sqlerrm_token,

Line 1054: x_return_status := okc_api.g_ret_sts_unexp_error;

1050: x_return_status := l_return_status;
1051: EXCEPTION
1052: WHEN OTHERS
1053: THEN
1054: x_return_status := okc_api.g_ret_sts_unexp_error;
1055: okc_api.set_message (g_app_name,
1056: g_unexpected_error,
1057: g_sqlcode_token,
1058: SQLCODE,

Line 1055: okc_api.set_message (g_app_name,

1051: EXCEPTION
1052: WHEN OTHERS
1053: THEN
1054: x_return_status := okc_api.g_ret_sts_unexp_error;
1055: okc_api.set_message (g_app_name,
1056: g_unexpected_error,
1057: g_sqlcode_token,
1058: SQLCODE,
1059: g_sqlerrm_token,

Line 1106: x_return_status := okc_api.g_ret_sts_unexp_error;

1102: x_return_status := l_return_status;
1103: EXCEPTION
1104: WHEN OTHERS
1105: THEN
1106: x_return_status := okc_api.g_ret_sts_unexp_error;
1107: okc_api.set_message (g_app_name,
1108: g_unexpected_error,
1109: g_sqlcode_token,
1110: SQLCODE,

Line 1107: okc_api.set_message (g_app_name,

1103: EXCEPTION
1104: WHEN OTHERS
1105: THEN
1106: x_return_status := okc_api.g_ret_sts_unexp_error;
1107: okc_api.set_message (g_app_name,
1108: g_unexpected_error,
1109: g_sqlcode_token,
1110: SQLCODE,
1111: g_sqlerrm_token,

Line 1238: x_return_status := okc_api.g_ret_sts_success;

1234:
1235: l_target_rec target_csr%ROWTYPE;
1236: l_source_rec source_csr%ROWTYPE;
1237: BEGIN
1238: x_return_status := okc_api.g_ret_sts_success;
1239:
1240: OPEN source_csr (p_source_chr_id);
1241:
1242: FETCH source_csr

Line 1285: x_return_status := okc_api.g_ret_sts_unexp_error;

1281: CLOSE target_csr;
1282: EXCEPTION
1283: WHEN OTHERS
1284: THEN
1285: x_return_status := okc_api.g_ret_sts_unexp_error;
1286: okc_api.set_message (g_app_name,
1287: g_unexpected_error,
1288: g_sqlcode_token,
1289: SQLCODE,

Line 1286: okc_api.set_message (g_app_name,

1282: EXCEPTION
1283: WHEN OTHERS
1284: THEN
1285: x_return_status := okc_api.g_ret_sts_unexp_error;
1286: okc_api.set_message (g_app_name,
1287: g_unexpected_error,
1288: g_sqlcode_token,
1289: SQLCODE,
1290: g_sqlerrm_token,

Line 1421: l_init_msg_list VARCHAR2 (2000) := okc_api.g_false;

1417: l_source_bill_completed DATE;
1418: l_source_service_item_id NUMBER;
1419: l_target_service_item_id NUMBER;
1420: l_api_version CONSTANT NUMBER := 1.0;
1421: l_init_msg_list VARCHAR2 (2000) := okc_api.g_false;
1422: l_return_status VARCHAR2 (1);
1423: BEGIN
1424: l_return_status := okc_api.g_ret_sts_success;
1425:

Line 1424: l_return_status := okc_api.g_ret_sts_success;

1420: l_api_version CONSTANT NUMBER := 1.0;
1421: l_init_msg_list VARCHAR2 (2000) := okc_api.g_false;
1422: l_return_status VARCHAR2 (1);
1423: BEGIN
1424: l_return_status := okc_api.g_ret_sts_success;
1425:
1426: OPEN source_line (p_source_line_id);
1427:
1428: FETCH source_line

Line 1491: IF l_return_status <> okc_api.g_ret_sts_success

1487: p_target_contract_line_id => p_target_line_id,
1488: x_coverage_match => x_eligible_yn
1489: );
1490:
1491: IF l_return_status <> okc_api.g_ret_sts_success
1492: THEN
1493: CLOSE target_line;
1494:
1495: RAISE g_exception_halt_validation;

Line 1582: x_return_status := okc_api.g_ret_sts_unexp_error;

1578: THEN
1579: x_return_status := l_return_status;
1580: WHEN OTHERS
1581: THEN
1582: x_return_status := okc_api.g_ret_sts_unexp_error;
1583: okc_api.set_message (g_app_name,
1584: g_unexpected_error,
1585: g_sqlcode_token,
1586: SQLCODE,

Line 1583: okc_api.set_message (g_app_name,

1579: x_return_status := l_return_status;
1580: WHEN OTHERS
1581: THEN
1582: x_return_status := okc_api.g_ret_sts_unexp_error;
1583: okc_api.set_message (g_app_name,
1584: g_unexpected_error,
1585: g_sqlcode_token,
1586: SQLCODE,
1587: g_sqlerrm_token,

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

1658: WHERE cle_id = p_cle_id AND dnz_chr_id = p_chr_id;
1659:
1660: --General
1661: l_api_version CONSTANT NUMBER := 1.0;
1662: l_init_msg_list CONSTANT VARCHAR2 (1) := okc_api.g_false;
1663: l_return_status VARCHAR2 (1) := 'S';
1664: l_index VARCHAR2 (2000);
1665: --Contract Line
1666: l_clev_tbl_in okc_contract_pub.clev_tbl_type;

Line 1675: x_status := okc_api.g_ret_sts_success;

1671: l_invoice_rule_id NUMBER;
1672: l_ste_code VARCHAR2 (30);
1673: l_sts_code VARCHAR2 (30);
1674: BEGIN
1675: x_status := okc_api.g_ret_sts_success;
1676:
1677: IF p_sts_flag = 'Y'
1678: THEN
1679: IF p_new_sdt > SYSDATE

Line 1701: p_restricted_update => okc_api.g_true,

1697: l_clev_tbl_in (1).end_date := p_new_edt;
1698: okc_contract_pub.update_contract_line
1699: (p_api_version => l_api_version,
1700: p_init_msg_list => l_init_msg_list,
1701: p_restricted_update => okc_api.g_true,
1702: x_return_status => l_return_status,
1703: x_msg_count => x_msg_count,
1704: x_msg_data => x_msg_data,
1705: p_clev_tbl => l_clev_tbl_in,

Line 1733: x_status := okc_api.g_ret_sts_unexp_error;

1729: THEN
1730: NULL;
1731: WHEN OTHERS
1732: THEN
1733: x_status := okc_api.g_ret_sts_unexp_error;
1734: okc_api.set_message (g_app_name,
1735: g_unexpected_error,
1736: g_sqlcode_token,
1737: SQLCODE,

Line 1734: okc_api.set_message (g_app_name,

1730: NULL;
1731: WHEN OTHERS
1732: THEN
1733: x_status := okc_api.g_ret_sts_unexp_error;
1734: okc_api.set_message (g_app_name,
1735: g_unexpected_error,
1736: g_sqlcode_token,
1737: SQLCODE,
1738: g_sqlerrm_token,

Line 1852: x_return_status := okc_api.g_ret_sts_unexp_error;

1848: END IF;
1849: EXCEPTION
1850: WHEN OTHERS
1851: THEN
1852: x_return_status := okc_api.g_ret_sts_unexp_error;
1853: okc_api.set_message (g_app_name,
1854: g_unexpected_error,
1855: g_sqlcode_token,
1856: SQLCODE,

Line 1853: okc_api.set_message (g_app_name,

1849: EXCEPTION
1850: WHEN OTHERS
1851: THEN
1852: x_return_status := okc_api.g_ret_sts_unexp_error;
1853: okc_api.set_message (g_app_name,
1854: g_unexpected_error,
1855: g_sqlcode_token,
1856: SQLCODE,
1857: g_sqlerrm_token,

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

1920: )
1921: IS
1922: --General
1923: l_api_version CONSTANT NUMBER := 1.0;
1924: l_init_msg_list CONSTANT VARCHAR2 (1) := okc_api.g_false;
1925: l_return_status VARCHAR2 (1) := 'S';
1926: l_index VARCHAR2 (2000);
1927: --Contract Header
1928: l_chrv_tbl_in okc_contract_pub.chrv_tbl_type;

Line 1943: x_status := okc_api.g_ret_sts_success;

1939: l_rule_id NUMBER;
1940: l_ste_code VARCHAR2 (30);
1941: l_sts_code VARCHAR2 (30);
1942: BEGIN
1943: x_status := okc_api.g_ret_sts_success;
1944:
1945: IF p_sts_flag = 'Y'
1946: THEN
1947: IF p_new_sdt > SYSDATE

Line 1969: p_restricted_update => okc_api.g_true,

1965: l_chrv_tbl_in (1).end_date := p_new_edt;
1966: okc_contract_pub.update_contract_header
1967: (p_api_version => l_api_version,
1968: p_init_msg_list => l_init_msg_list,
1969: p_restricted_update => okc_api.g_true,
1970: x_return_status => l_return_status,
1971: x_msg_count => x_msg_count,
1972: x_msg_data => x_msg_data,
1973: p_chrv_tbl => l_chrv_tbl_in,

Line 2002: x_status := okc_api.g_ret_sts_unexp_error;

1998: THEN
1999: NULL;
2000: WHEN OTHERS
2001: THEN
2002: x_status := okc_api.g_ret_sts_unexp_error;
2003: okc_api.set_message (g_app_name,
2004: g_unexpected_error,
2005: g_sqlcode_token,
2006: SQLCODE,

Line 2003: okc_api.set_message (g_app_name,

1999: NULL;
2000: WHEN OTHERS
2001: THEN
2002: x_status := okc_api.g_ret_sts_unexp_error;
2003: okc_api.set_message (g_app_name,
2004: g_unexpected_error,
2005: g_sqlcode_token,
2006: SQLCODE,
2007: g_sqlerrm_token,

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

2089: FROM okc_k_lines_b
2090: WHERE ID = p_covered_line_id;
2091:
2092: l_api_version CONSTANT NUMBER := 1.0;
2093: l_init_msg_list CONSTANT VARCHAR2 (1) := okc_api.g_false;
2094: l_return_status VARCHAR2 (1) := 'S';
2095: l_index VARCHAR2 (2000);
2096: --Contract Line Table
2097: l_clev_tbl_in okc_contract_pub.clev_tbl_type;

Line 2108: x_return_status := okc_api.g_ret_sts_success;

2104: l_line_item_id NUMBER;
2105: BEGIN
2106: IF p_new_end_date IS NOT NULL
2107: THEN
2108: x_return_status := okc_api.g_ret_sts_success;
2109: l_clev_tbl_in (1).ID := p_covered_line_id;
2110: l_clev_tbl_in (1).end_date := p_new_end_date;
2111: okc_contract_pub.update_contract_line
2112: (p_api_version => l_api_version,

Line 2114: p_restricted_update => okc_api.g_true,

2110: l_clev_tbl_in (1).end_date := p_new_end_date;
2111: okc_contract_pub.update_contract_line
2112: (p_api_version => l_api_version,
2113: p_init_msg_list => l_init_msg_list,
2114: p_restricted_update => okc_api.g_true,
2115: x_return_status => l_return_status,
2116: x_msg_count => x_msg_count,
2117: x_msg_data => x_msg_data,
2118: p_clev_tbl => l_clev_tbl_in,

Line 2136: okc_api.set_message (g_app_name,

2132: END IF;
2133:
2134: IF l_return_status <> 'S'
2135: THEN
2136: okc_api.set_message (g_app_name,
2137: g_required_value,
2138: g_col_name_token,
2139: 'Contract Line Update(UPDATE SUB LINE)'
2140: );

Line 2147: x_return_status := okc_api.g_ret_sts_success;

2143: END IF;
2144:
2145: IF p_new_negotiated_amt IS NOT NULL
2146: THEN
2147: x_return_status := okc_api.g_ret_sts_success;
2148: l_clev_tbl_in (1).ID := p_covered_line_id;
2149: l_clev_tbl_in (1).price_negotiated := p_new_negotiated_amt;
2150: l_clev_tbl_in (1).price_unit := p_list_price;
2151: okc_contract_pub.update_contract_line

Line 2154: p_restricted_update => okc_api.g_true,

2150: l_clev_tbl_in (1).price_unit := p_list_price;
2151: okc_contract_pub.update_contract_line
2152: (p_api_version => l_api_version,
2153: p_init_msg_list => l_init_msg_list,
2154: p_restricted_update => okc_api.g_true,
2155: x_return_status => l_return_status,
2156: x_msg_count => x_msg_count,
2157: x_msg_data => x_msg_data,
2158: p_clev_tbl => l_clev_tbl_in,

Line 2220: x_return_status := okc_api.g_ret_sts_unexp_error;

2216: x_return_status := l_return_status;
2217: NULL;
2218: WHEN OTHERS
2219: THEN
2220: x_return_status := okc_api.g_ret_sts_unexp_error;
2221: okc_api.set_message (g_app_name,
2222: g_unexpected_error,
2223: g_sqlcode_token,
2224: SQLCODE,

Line 2221: okc_api.set_message (g_app_name,

2217: NULL;
2218: WHEN OTHERS
2219: THEN
2220: x_return_status := okc_api.g_ret_sts_unexp_error;
2221: okc_api.set_message (g_app_name,
2222: g_unexpected_error,
2223: g_sqlcode_token,
2224: SQLCODE,
2225: g_sqlerrm_token,

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

2400: l_rah_hdr_object1_id1 NUMBER;
2401: l_thirdparty_id NUMBER;
2402: l_thirdparty_role VARCHAR2 (30);
2403: l_api_version CONSTANT NUMBER := 1.0;
2404: l_init_msg_list CONSTANT VARCHAR2 (1) := okc_api.g_false;
2405: l_return_status VARCHAR2 (1) := 'S';
2406: l_index VARCHAR2 (2000);
2407: i NUMBER;
2408: --Contract Header

Line 2482: x_return_status := okc_api.g_ret_sts_success;

2478: l_salesrep_id NUMBER;
2479: l_new_org_id NUMBER;
2480: l_entity_id NUMBER;
2481: BEGIN
2482: x_return_status := okc_api.g_ret_sts_success;
2483:
2484: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level
2485: THEN
2486: fnd_log.STRING (fnd_log.level_procedure,

Line 2549: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

2545: /* Updating the status in okc_contacts table.*/
2546: OKC_CTC_PVT.update_contact_stecode(p_chr_id => l_chrid,
2547: x_return_status=>l_return_status);
2548:
2549: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
2550: RAISE g_exception_halt_validation;
2551: END IF;
2552: END IF;
2553: /*bugfix for 6882512*/

Line 2555: l_return_status := okc_api.g_ret_sts_success;

2551: END IF;
2552: END IF;
2553: /*bugfix for 6882512*/
2554: x_chr_id := l_chrid;
2555: l_return_status := okc_api.g_ret_sts_success;
2556: RAISE g_exception_halt_validation;
2557: END IF;
2558: END IF;
2559:

Line 2636: l_chrv_tbl_in (1).chr_type := okc_api.g_miss_char;

2632: NVL (p_k_header_rec.short_description, 'Warranty/Extended Warranty');
2633: l_chrv_tbl_in (1).template_yn := 'N';
2634: l_chrv_tbl_in (1).start_date := p_k_header_rec.start_date;
2635: l_chrv_tbl_in (1).end_date := p_k_header_rec.end_date;
2636: l_chrv_tbl_in (1).chr_type := okc_api.g_miss_char;
2637: l_chrv_tbl_in (1).archived_yn := 'N';
2638: l_chrv_tbl_in (1).deleted_yn := 'N';
2639: l_chrv_tbl_in (1).created_by := okc_api.g_miss_num;
2640: l_chrv_tbl_in (1).creation_date := okc_api.g_miss_date;

Line 2639: l_chrv_tbl_in (1).created_by := okc_api.g_miss_num;

2635: l_chrv_tbl_in (1).end_date := p_k_header_rec.end_date;
2636: l_chrv_tbl_in (1).chr_type := okc_api.g_miss_char;
2637: l_chrv_tbl_in (1).archived_yn := 'N';
2638: l_chrv_tbl_in (1).deleted_yn := 'N';
2639: l_chrv_tbl_in (1).created_by := okc_api.g_miss_num;
2640: l_chrv_tbl_in (1).creation_date := okc_api.g_miss_date;
2641: l_chrv_tbl_in (1).currency_code := p_k_header_rec.currency;
2642: l_chrv_tbl_in (1).buy_or_sell := 'S';
2643: l_chrv_tbl_in (1).issue_or_receive := 'I';

Line 2640: l_chrv_tbl_in (1).creation_date := okc_api.g_miss_date;

2636: l_chrv_tbl_in (1).chr_type := okc_api.g_miss_char;
2637: l_chrv_tbl_in (1).archived_yn := 'N';
2638: l_chrv_tbl_in (1).deleted_yn := 'N';
2639: l_chrv_tbl_in (1).created_by := okc_api.g_miss_num;
2640: l_chrv_tbl_in (1).creation_date := okc_api.g_miss_date;
2641: l_chrv_tbl_in (1).currency_code := p_k_header_rec.currency;
2642: l_chrv_tbl_in (1).buy_or_sell := 'S';
2643: l_chrv_tbl_in (1).issue_or_receive := 'I';
2644: l_chrv_tbl_in (1).attribute1 := p_k_header_rec.attribute1;

Line 2719: okc_api.set_message (g_app_name,

2715:
2716: RAISE g_exception_halt_validation;
2717: ELSE
2718: --mmadhavi
2719: okc_api.set_message (g_app_name,
2720: g_required_value,
2721: g_col_name_token,
2722: 'HEADER (HEADER)'
2723: );

Line 2893: l_khrv_tbl_in (1).created_by := okc_api.g_miss_num;

2889: l_khrv_tbl_in (1).tax_status := p_k_header_rec.tax_status_flag; --TAX
2890: l_khrv_tbl_in (1).tax_code := NULL; --TAX
2891: l_khrv_tbl_in (1).tax_exemption_id := p_k_header_rec.tax_exemption_id;
2892: --TAX
2893: l_khrv_tbl_in (1).created_by := okc_api.g_miss_num;
2894: l_khrv_tbl_in (1).creation_date := okc_api.g_miss_date;
2895:
2896: IF p_k_header_rec.ccr_number IS NOT NULL
2897: THEN

Line 2894: l_khrv_tbl_in (1).creation_date := okc_api.g_miss_date;

2890: l_khrv_tbl_in (1).tax_code := NULL; --TAX
2891: l_khrv_tbl_in (1).tax_exemption_id := p_k_header_rec.tax_exemption_id;
2892: --TAX
2893: l_khrv_tbl_in (1).created_by := okc_api.g_miss_num;
2894: l_khrv_tbl_in (1).creation_date := okc_api.g_miss_date;
2895:
2896: IF p_k_header_rec.ccr_number IS NOT NULL
2897: THEN
2898: l_khrv_tbl_in (1).payment_type := 'CCR';

Line 2971: IF NOT l_return_status = okc_api.g_ret_sts_success

2967: || ')'
2968: );
2969: END IF;
2970:
2971: IF NOT l_return_status = okc_api.g_ret_sts_success
2972: THEN
2973: --mmadhavi
2974: IF (p_caller = 'OC')
2975: THEN

Line 3002: okc_api.set_message (g_app_name,

2998:
2999: RAISE g_exception_halt_validation;
3000: ELSE
3001: --mmadhavi
3002: okc_api.set_message (g_app_name,
3003: g_required_value,
3004: g_col_name_token,
3005: 'OKS (HEADER)'
3006: );

Line 3019: IF NOT l_return_status = okc_api.g_ret_sts_success

3015: p_k_header_rec.order_line_id,
3016: l_return_status
3017: );
3018:
3019: IF NOT l_return_status = okc_api.g_ret_sts_success
3020: THEN
3021: x_return_status := l_return_status;
3022: RAISE g_exception_halt_validation;
3023: END IF;

Line 3052: IF NOT l_return_status = okc_api.g_ret_sts_success

3048: || l_partyid_v
3049: );
3050: END IF;
3051:
3052: IF NOT l_return_status = okc_api.g_ret_sts_success
3053: THEN
3054: x_return_status := l_return_status;
3055: RAISE g_exception_halt_validation;
3056: END IF;

Line 3082: IF NOT l_return_status = okc_api.g_ret_sts_success

3078: || l_partyid
3079: );
3080: END IF;
3081:
3082: IF NOT l_return_status = okc_api.g_ret_sts_success
3083: THEN
3084: x_return_status := l_return_status;
3085: RAISE g_exception_halt_validation;
3086: END IF;

Line 3112: IF NOT l_return_status = okc_api.g_ret_sts_success

3108: || l_partyid_v
3109: );
3110: END IF;
3111:
3112: IF NOT l_return_status = okc_api.g_ret_sts_success
3113: THEN
3114: x_return_status := l_return_status;
3115: RAISE g_exception_halt_validation;
3116: END IF;

Line 3142: IF NOT l_return_status = okc_api.g_ret_sts_success

3138: || l_partyid
3139: );
3140: END IF;
3141:
3142: IF NOT l_return_status = okc_api.g_ret_sts_success
3143: THEN
3144: x_return_status := l_return_status;
3145: RAISE g_exception_halt_validation;
3146: END IF;

Line 3176: l_return_status := okc_api.g_ret_sts_error;

3172: fnd_message.set_name (g_app_name,
3173: 'OKS_INVD_THIRD_PARTY_ROLE'
3174: );
3175: x_order_error := '#' || fnd_message.get_encoded || '#';
3176: l_return_status := okc_api.g_ret_sts_error;
3177: RAISE g_exception_halt_validation;
3178: END IF;
3179: END IF;
3180:

Line 3206: IF NOT l_return_status = okc_api.g_ret_sts_success

3202: || l_partyid_t
3203: );
3204: END IF;
3205:
3206: IF NOT l_return_status = okc_api.g_ret_sts_success
3207: THEN
3208: x_return_status := l_return_status;
3209: RAISE g_exception_halt_validation;
3210: END IF;

Line 3242: IF (l_return_status <> okc_api.g_ret_sts_success)

3238: x_msg_data => l_msg_data,
3239: x_return_status => l_return_status
3240: );
3241:
3242: IF (l_return_status <> okc_api.g_ret_sts_success)
3243: THEN
3244: -- Setup error
3245: If p_caller = 'ST' Then
3246: send_notification (null, l_chrid, 'SER');

Line 3360: okc_api.set_message (g_app_name,

3356: IF object_code_csr%NOTFOUND
3357: THEN
3358: CLOSE object_code_csr;
3359:
3360: okc_api.set_message (g_app_name,
3361: g_unexpected_error,
3362: g_sqlcode_token,
3363: SQLCODE,
3364: g_sqlerrm_token,

Line 3367: l_return_status := okc_api.g_ret_sts_error;

3363: SQLCODE,
3364: g_sqlerrm_token,
3365: 'Wrong vendor contact role assigned'
3366: );
3367: l_return_status := okc_api.g_ret_sts_error;
3368: RAISE g_exception_halt_validation;
3369: END IF;
3370:
3371: CLOSE object_code_csr;

Line 3400: okc_api.set_message (g_app_name,

3396: IF l_return_status = 'S'
3397: THEN
3398: l_contact_id := l_ctcv_tbl_out (1).ID;
3399: ELSE
3400: okc_api.set_message (g_app_name,
3401: g_required_value,
3402: g_col_name_token,
3403: l_ctcv_tbl_in (1).cro_code
3404: || 'Vendor Contact (HEADER) '

Line 3428: p_init_msg_list => okc_api.g_false,

3424: l_scrv_tbl_in (1).sales_group_id :=
3425: p_salescredit_tbl_in (j).sales_group_id;
3426: oks_sales_credit_pub.insert_sales_credit
3427: (p_api_version => 1.0,
3428: p_init_msg_list => okc_api.g_false,
3429: x_return_status => l_return_status,
3430: x_msg_count => x_msg_count,
3431: x_msg_data => x_msg_data,
3432: p_scrv_tbl => l_scrv_tbl_in,

Line 3451: okc_api.set_message (g_app_name,

3447: IF l_return_status = 'S'
3448: THEN
3449: l_salescredit_id := l_scrv_tbl_out (1).ID;
3450: ELSE
3451: okc_api.set_message (g_app_name,
3452: g_required_value,
3453: g_col_name_token,
3454: 'Sales Credit Failure'
3455: );

Line 3529: okc_api.set_message (g_app_name,

3525: END IF;
3526:
3527: IF l_add2partyid IS NULL
3528: THEN
3529: okc_api.set_message (g_app_name,
3530: g_required_value,
3531: g_col_name_token,
3532: p_contact_tbl (i).contact_role
3533: || ' Contact (HEADER) Missing Role Id '

Line 3597: okc_api.set_message (g_app_name,

3593: IF l_return_status = 'S'
3594: THEN
3595: l_contact_id := l_ctcv_tbl_out (1).ID;
3596: ELSE
3597: okc_api.set_message (g_app_name,
3598: g_required_value,
3599: g_col_name_token,
3600: p_contact_tbl (i).contact_role
3601: || ' Contact (HEADER) '

Line 3619: l_cgcv_tbl_in (1).object_version_number := okc_api.g_miss_num;

3615: NVL (fnd_profile.VALUE ('OKS_WARR_CONTRACT_GROUP'), 2)
3616: );
3617: l_cgcv_tbl_in (1).cgp_parent_id := l_ctrgrp;
3618: l_cgcv_tbl_in (1).included_chr_id := l_chrid;
3619: l_cgcv_tbl_in (1).object_version_number := okc_api.g_miss_num;
3620: l_cgcv_tbl_in (1).created_by := okc_api.g_miss_num;
3621: l_cgcv_tbl_in (1).creation_date := okc_api.g_miss_date;
3622: l_cgcv_tbl_in (1).last_updated_by := okc_api.g_miss_num;
3623: l_cgcv_tbl_in (1).last_update_date := okc_api.g_miss_date;

Line 3620: l_cgcv_tbl_in (1).created_by := okc_api.g_miss_num;

3616: );
3617: l_cgcv_tbl_in (1).cgp_parent_id := l_ctrgrp;
3618: l_cgcv_tbl_in (1).included_chr_id := l_chrid;
3619: l_cgcv_tbl_in (1).object_version_number := okc_api.g_miss_num;
3620: l_cgcv_tbl_in (1).created_by := okc_api.g_miss_num;
3621: l_cgcv_tbl_in (1).creation_date := okc_api.g_miss_date;
3622: l_cgcv_tbl_in (1).last_updated_by := okc_api.g_miss_num;
3623: l_cgcv_tbl_in (1).last_update_date := okc_api.g_miss_date;
3624: l_cgcv_tbl_in (1).last_update_login := okc_api.g_miss_num;

Line 3621: l_cgcv_tbl_in (1).creation_date := okc_api.g_miss_date;

3617: l_cgcv_tbl_in (1).cgp_parent_id := l_ctrgrp;
3618: l_cgcv_tbl_in (1).included_chr_id := l_chrid;
3619: l_cgcv_tbl_in (1).object_version_number := okc_api.g_miss_num;
3620: l_cgcv_tbl_in (1).created_by := okc_api.g_miss_num;
3621: l_cgcv_tbl_in (1).creation_date := okc_api.g_miss_date;
3622: l_cgcv_tbl_in (1).last_updated_by := okc_api.g_miss_num;
3623: l_cgcv_tbl_in (1).last_update_date := okc_api.g_miss_date;
3624: l_cgcv_tbl_in (1).last_update_login := okc_api.g_miss_num;
3625: l_cgcv_tbl_in (1).included_cgp_id := NULL;

Line 3622: l_cgcv_tbl_in (1).last_updated_by := okc_api.g_miss_num;

3618: l_cgcv_tbl_in (1).included_chr_id := l_chrid;
3619: l_cgcv_tbl_in (1).object_version_number := okc_api.g_miss_num;
3620: l_cgcv_tbl_in (1).created_by := okc_api.g_miss_num;
3621: l_cgcv_tbl_in (1).creation_date := okc_api.g_miss_date;
3622: l_cgcv_tbl_in (1).last_updated_by := okc_api.g_miss_num;
3623: l_cgcv_tbl_in (1).last_update_date := okc_api.g_miss_date;
3624: l_cgcv_tbl_in (1).last_update_login := okc_api.g_miss_num;
3625: l_cgcv_tbl_in (1).included_cgp_id := NULL;
3626: okc_contract_group_pub.create_contract_grpngs

Line 3623: l_cgcv_tbl_in (1).last_update_date := okc_api.g_miss_date;

3619: l_cgcv_tbl_in (1).object_version_number := okc_api.g_miss_num;
3620: l_cgcv_tbl_in (1).created_by := okc_api.g_miss_num;
3621: l_cgcv_tbl_in (1).creation_date := okc_api.g_miss_date;
3622: l_cgcv_tbl_in (1).last_updated_by := okc_api.g_miss_num;
3623: l_cgcv_tbl_in (1).last_update_date := okc_api.g_miss_date;
3624: l_cgcv_tbl_in (1).last_update_login := okc_api.g_miss_num;
3625: l_cgcv_tbl_in (1).included_cgp_id := NULL;
3626: okc_contract_group_pub.create_contract_grpngs
3627: (p_api_version => l_api_version,

Line 3624: l_cgcv_tbl_in (1).last_update_login := okc_api.g_miss_num;

3620: l_cgcv_tbl_in (1).created_by := okc_api.g_miss_num;
3621: l_cgcv_tbl_in (1).creation_date := okc_api.g_miss_date;
3622: l_cgcv_tbl_in (1).last_updated_by := okc_api.g_miss_num;
3623: l_cgcv_tbl_in (1).last_update_date := okc_api.g_miss_date;
3624: l_cgcv_tbl_in (1).last_update_login := okc_api.g_miss_num;
3625: l_cgcv_tbl_in (1).included_cgp_id := NULL;
3626: okc_contract_group_pub.create_contract_grpngs
3627: (p_api_version => l_api_version,
3628: p_init_msg_list => l_init_msg_list,

Line 3651: okc_api.set_message (g_app_name,

3647: IF l_return_status = 'S'
3648: THEN
3649: l_grpid := l_cgcv_tbl_out (1).ID;
3650: ELSE
3651: okc_api.set_message (g_app_name,
3652: g_required_value,
3653: g_col_name_token,
3654: 'Contract Group (HEADER)'
3655: );

Line 3664: l_cpsv_tbl_in (1).in_process_yn := okc_api.g_miss_char;

3660: THEN
3661: l_cpsv_tbl_in (1).pdf_id := p_k_header_rec.pdf_id;
3662: l_cpsv_tbl_in (1).chr_id := l_chrid;
3663: l_cpsv_tbl_in (1).user_id := fnd_global.user_id;
3664: l_cpsv_tbl_in (1).in_process_yn := okc_api.g_miss_char;
3665: l_cpsv_tbl_in (1).object_version_number := okc_api.g_miss_num;
3666: l_cpsv_tbl_in (1).created_by := okc_api.g_miss_num;
3667: l_cpsv_tbl_in (1).creation_date := okc_api.g_miss_date;
3668: l_cpsv_tbl_in (1).last_updated_by := okc_api.g_miss_num;

Line 3665: l_cpsv_tbl_in (1).object_version_number := okc_api.g_miss_num;

3661: l_cpsv_tbl_in (1).pdf_id := p_k_header_rec.pdf_id;
3662: l_cpsv_tbl_in (1).chr_id := l_chrid;
3663: l_cpsv_tbl_in (1).user_id := fnd_global.user_id;
3664: l_cpsv_tbl_in (1).in_process_yn := okc_api.g_miss_char;
3665: l_cpsv_tbl_in (1).object_version_number := okc_api.g_miss_num;
3666: l_cpsv_tbl_in (1).created_by := okc_api.g_miss_num;
3667: l_cpsv_tbl_in (1).creation_date := okc_api.g_miss_date;
3668: l_cpsv_tbl_in (1).last_updated_by := okc_api.g_miss_num;
3669: l_cpsv_tbl_in (1).last_update_date := okc_api.g_miss_date;

Line 3666: l_cpsv_tbl_in (1).created_by := okc_api.g_miss_num;

3662: l_cpsv_tbl_in (1).chr_id := l_chrid;
3663: l_cpsv_tbl_in (1).user_id := fnd_global.user_id;
3664: l_cpsv_tbl_in (1).in_process_yn := okc_api.g_miss_char;
3665: l_cpsv_tbl_in (1).object_version_number := okc_api.g_miss_num;
3666: l_cpsv_tbl_in (1).created_by := okc_api.g_miss_num;
3667: l_cpsv_tbl_in (1).creation_date := okc_api.g_miss_date;
3668: l_cpsv_tbl_in (1).last_updated_by := okc_api.g_miss_num;
3669: l_cpsv_tbl_in (1).last_update_date := okc_api.g_miss_date;
3670: l_cpsv_tbl_in (1).last_update_login := okc_api.g_miss_num;

Line 3667: l_cpsv_tbl_in (1).creation_date := okc_api.g_miss_date;

3663: l_cpsv_tbl_in (1).user_id := fnd_global.user_id;
3664: l_cpsv_tbl_in (1).in_process_yn := okc_api.g_miss_char;
3665: l_cpsv_tbl_in (1).object_version_number := okc_api.g_miss_num;
3666: l_cpsv_tbl_in (1).created_by := okc_api.g_miss_num;
3667: l_cpsv_tbl_in (1).creation_date := okc_api.g_miss_date;
3668: l_cpsv_tbl_in (1).last_updated_by := okc_api.g_miss_num;
3669: l_cpsv_tbl_in (1).last_update_date := okc_api.g_miss_date;
3670: l_cpsv_tbl_in (1).last_update_login := okc_api.g_miss_num;
3671: okc_contract_pub.create_contract_process

Line 3668: l_cpsv_tbl_in (1).last_updated_by := okc_api.g_miss_num;

3664: l_cpsv_tbl_in (1).in_process_yn := okc_api.g_miss_char;
3665: l_cpsv_tbl_in (1).object_version_number := okc_api.g_miss_num;
3666: l_cpsv_tbl_in (1).created_by := okc_api.g_miss_num;
3667: l_cpsv_tbl_in (1).creation_date := okc_api.g_miss_date;
3668: l_cpsv_tbl_in (1).last_updated_by := okc_api.g_miss_num;
3669: l_cpsv_tbl_in (1).last_update_date := okc_api.g_miss_date;
3670: l_cpsv_tbl_in (1).last_update_login := okc_api.g_miss_num;
3671: okc_contract_pub.create_contract_process
3672: (p_api_version => l_api_version,

Line 3669: l_cpsv_tbl_in (1).last_update_date := okc_api.g_miss_date;

3665: l_cpsv_tbl_in (1).object_version_number := okc_api.g_miss_num;
3666: l_cpsv_tbl_in (1).created_by := okc_api.g_miss_num;
3667: l_cpsv_tbl_in (1).creation_date := okc_api.g_miss_date;
3668: l_cpsv_tbl_in (1).last_updated_by := okc_api.g_miss_num;
3669: l_cpsv_tbl_in (1).last_update_date := okc_api.g_miss_date;
3670: l_cpsv_tbl_in (1).last_update_login := okc_api.g_miss_num;
3671: okc_contract_pub.create_contract_process
3672: (p_api_version => l_api_version,
3673: p_init_msg_list => l_init_msg_list,

Line 3670: l_cpsv_tbl_in (1).last_update_login := okc_api.g_miss_num;

3666: l_cpsv_tbl_in (1).created_by := okc_api.g_miss_num;
3667: l_cpsv_tbl_in (1).creation_date := okc_api.g_miss_date;
3668: l_cpsv_tbl_in (1).last_updated_by := okc_api.g_miss_num;
3669: l_cpsv_tbl_in (1).last_update_date := okc_api.g_miss_date;
3670: l_cpsv_tbl_in (1).last_update_login := okc_api.g_miss_num;
3671: okc_contract_pub.create_contract_process
3672: (p_api_version => l_api_version,
3673: p_init_msg_list => l_init_msg_list,
3674: x_return_status => l_return_status,

Line 3696: okc_api.set_message (g_app_name,

3692: IF l_return_status = 'S'
3693: THEN
3694: l_pdfid := l_cpsv_tbl_out (1).ID;
3695: ELSE
3696: okc_api.set_message (g_app_name,
3697: g_required_value,
3698: g_col_name_token,
3699: 'Contract WorkFlow (HEADER)'
3700: );

Line 3737: okc_api.set_message (g_app_name,

3733: IF l_return_status = 'S'
3734: THEN
3735: l_govern_id := l_gvev_tbl_out (1).ID;
3736: ELSE
3737: okc_api.set_message (g_app_name,
3738: g_required_value,
3739: g_col_name_token,
3740: 'Agreement Id (HEADER)'
3741: );

Line 3768: IF NOT l_return_status = okc_api.g_ret_sts_success

3764: || ')'
3765: );
3766: END IF;
3767:
3768: IF NOT l_return_status = okc_api.g_ret_sts_success
3769: THEN
3770: okc_api.set_message (g_app_name,
3771: g_required_value,
3772: g_col_name_token,

Line 3770: okc_api.set_message (g_app_name,

3766: END IF;
3767:
3768: IF NOT l_return_status = okc_api.g_ret_sts_success
3769: THEN
3770: okc_api.set_message (g_app_name,
3771: g_required_value,
3772: g_col_name_token,
3773: 'Order Header Id (HEADER)'
3774: );

Line 3785: x_return_status := okc_api.g_ret_sts_unexp_error;

3781: THEN
3782: x_return_status := l_return_status;
3783: WHEN OTHERS
3784: THEN
3785: x_return_status := okc_api.g_ret_sts_unexp_error;
3786: okc_api.set_message (g_app_name,
3787: g_unexpected_error,
3788: g_sqlcode_token,
3789: SQLCODE,

Line 3786: okc_api.set_message (g_app_name,

3782: x_return_status := l_return_status;
3783: WHEN OTHERS
3784: THEN
3785: x_return_status := okc_api.g_ret_sts_unexp_error;
3786: okc_api.set_message (g_app_name,
3787: g_unexpected_error,
3788: g_sqlcode_token,
3789: SQLCODE,
3790: g_sqlerrm_token,

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

3848: x_msg_data OUT NOCOPY VARCHAR2
3849: )
3850: IS
3851: l_api_version CONSTANT NUMBER := 1.0;
3852: l_init_msg_list CONSTANT VARCHAR2 (1) := okc_api.g_false;
3853: l_return_status VARCHAR2 (1) := 'S';
3854: l_index VARCHAR2 (2000);
3855: l_ctcv_tbl_in okc_contract_party_pub.ctcv_tbl_type;
3856: l_ctcv_tbl_out okc_contract_party_pub.ctcv_tbl_type;

Line 3992: x_return_status := okc_api.g_ret_sts_success;

3988: l_ctr NUMBER;
3989: l_inp_rec okc_inst_cnd_pub.instcnd_inp_rec;
3990: l_entity_id NUMBER;
3991: BEGIN
3992: x_return_status := okc_api.g_ret_sts_success;
3993:
3994: IF p_k_line_rec.SOURCE = 'NEW'
3995: THEN
3996: get_k_cle_id (p_chrid => p_k_line_rec.k_id,

Line 4053: l_return_status := okc_api.g_ret_sts_success;

4049:
4050: IF l_line_id IS NOT NULL
4051: THEN
4052: x_service_line_id := l_line_id;
4053: l_return_status := okc_api.g_ret_sts_success;
4054: RAISE g_exception_halt_validation;
4055: END IF;
4056:
4057: IF p_k_line_rec.warranty_flag = 'W'

Line 4097: okc_api.set_message (g_app_name,

4093: END IF;
4094:
4095: IF l_hdrstatus = 'E'
4096: THEN
4097: okc_api.set_message (g_app_name,
4098: g_unexpected_error,
4099: g_sqlcode_token,
4100: SQLCODE,
4101: g_sqlerrm_token,

Line 4125: l_return_status := okc_api.g_ret_sts_error;

4121: x_order_error := '#' || fnd_message.get_encoded || '#';
4122: END IF;
4123:
4124: --mmadhavi
4125: l_return_status := okc_api.g_ret_sts_error;
4126: RAISE g_exception_halt_validation;
4127: ELSIF l_hdrstatus = 'Y'
4128: THEN
4129: IF p_k_line_rec.line_sts_code = 'ENTERED'

Line 4157: l_return_status := okc_api.g_ret_sts_error;

4153: END IF;
4154:
4155: IF NOT l_return_status = 'S'
4156: THEN
4157: l_return_status := okc_api.g_ret_sts_error;
4158: okc_api.set_message (g_app_name,
4159: g_required_value,
4160: g_col_name_token,
4161: 'Header Effectivity Update (LINE)'

Line 4158: okc_api.set_message (g_app_name,

4154:
4155: IF NOT l_return_status = 'S'
4156: THEN
4157: l_return_status := okc_api.g_ret_sts_error;
4158: okc_api.set_message (g_app_name,
4159: g_required_value,
4160: g_col_name_token,
4161: 'Header Effectivity Update (LINE)'
4162: );

Line 4238: p_restricted_update => okc_api.g_true,

4234: -- price list
4235: okc_contract_pub.create_contract_line
4236: (p_api_version => l_api_version,
4237: p_init_msg_list => l_init_msg_list,
4238: p_restricted_update => okc_api.g_true,
4239: x_return_status => l_return_status,
4240: x_msg_count => x_msg_count,
4241: x_msg_data => x_msg_data,
4242: p_clev_tbl => l_clev_tbl_in,

Line 4290: okc_api.set_message (g_app_name,

4286:
4287: RAISE g_exception_halt_validation;
4288: ELSE
4289: --mmadhavi
4290: okc_api.set_message (g_app_name,
4291: g_required_value,
4292: g_col_name_token,
4293: 'Line (LINE)'
4294: );

Line 4374: l_klnv_tbl_in (1).created_by := okc_api.g_miss_num;

4370: || ':'
4371: || to_char(p_k_line_rec.srv_sdt,'DD-MON-YYYY')
4372: || ':'
4373: || to_char(p_k_line_rec.srv_edt,'DD-MON-YYYY');
4374: l_klnv_tbl_in (1).created_by := okc_api.g_miss_num;
4375: l_klnv_tbl_in (1).creation_date := okc_api.g_miss_date;
4376: l_klnv_tbl_in (1).acct_rule_id := p_k_line_rec.accounting_rule_id; --ARL
4377:
4378: IF p_k_line_rec.commitment_id IS NOT NULL

Line 4375: l_klnv_tbl_in (1).creation_date := okc_api.g_miss_date;

4371: || to_char(p_k_line_rec.srv_sdt,'DD-MON-YYYY')
4372: || ':'
4373: || to_char(p_k_line_rec.srv_edt,'DD-MON-YYYY');
4374: l_klnv_tbl_in (1).created_by := okc_api.g_miss_num;
4375: l_klnv_tbl_in (1).creation_date := okc_api.g_miss_date;
4376: l_klnv_tbl_in (1).acct_rule_id := p_k_line_rec.accounting_rule_id; --ARL
4377:
4378: IF p_k_line_rec.commitment_id IS NOT NULL
4379: THEN

Line 4476: okc_api.set_message (g_app_name,

4472:
4473: RAISE g_exception_halt_validation;
4474: ELSE
4475: --mmadhavi
4476: okc_api.set_message (g_app_name,
4477: g_required_value,
4478: g_col_name_token,
4479: 'OKS Contract LINE'
4480: );

Line 4576: okc_api.set_message (g_app_name,

4572: IF l_return_status = 'S'
4573: THEN
4574: l_line_item_id := l_cimv_tbl_out (1).ID;
4575: ELSE
4576: okc_api.set_message (g_app_name,
4577: g_required_value,
4578: g_col_name_token,
4579: 'Service Inventory Item ID '
4580: || p_k_line_rec.srv_id

Line 4604: p_init_msg_list => okc_api.g_false,

4600: l_scrv_tbl_in (1).sales_group_id :=
4601: p_salescredit_tbl_in (i).sales_group_id;
4602: oks_sales_credit_pub.insert_sales_credit
4603: (p_api_version => 1.0,
4604: p_init_msg_list => okc_api.g_false,
4605: x_return_status => x_return_status,
4606: x_msg_count => x_msg_count,
4607: x_msg_data => x_msg_data,
4608: p_scrv_tbl => l_scrv_tbl_in,

Line 4628: okc_api.set_message (g_app_name,

4624: IF l_return_status = 'S'
4625: THEN
4626: l_salescredit_id := l_scrv_tbl_out (1).ID;
4627: ELSE
4628: okc_api.set_message (g_app_name,
4629: g_required_value,
4630: g_col_name_token,
4631: 'Sales Credit Failure'
4632: );

Line 4694: IF NOT l_return_status = okc_api.g_ret_sts_success

4690: || l_line_party_role_id
4691: );
4692: END IF;
4693:
4694: IF NOT l_return_status = okc_api.g_ret_sts_success
4695: THEN
4696: x_return_status := l_return_status;
4697: RAISE g_exception_halt_validation;
4698: END IF;

Line 4753: okc_api.set_message (g_app_name,

4749: IF l_return_status = 'S'
4750: THEN
4751: l_line_contact_id := l_ctcv_tbl_out (1).ID;
4752: ELSE
4753: okc_api.set_message (g_app_name,
4754: g_required_value,
4755: g_col_name_token,
4756: p_contact_tbl (i).contact_role
4757: || ' Contact (LINE) '

Line 4794: IF NOT l_return_status = okc_api.g_ret_sts_success

4790: || ')'
4791: );
4792: END IF;
4793:
4794: IF NOT l_return_status = okc_api.g_ret_sts_success
4795: THEN
4796: IF (p_caller = 'OC')
4797: THEN
4798: fnd_message.set_name (g_app_name, 'OKS_INVD_COV_TEMP');

Line 4804: okc_api.set_message (g_app_name,

4800: VALUE => p_k_line_rec.srv_id
4801: );
4802: x_order_error := '#' || fnd_message.get_encoded || '#';
4803: ELSE
4804: okc_api.set_message (g_app_name,
4805: g_required_value,
4806: g_col_name_token,
4807: 'Invalid Coverage Associated with '
4808: || p_k_line_rec.srv_id

Line 4826: l_return_status := okc_api.g_ret_sts_error;

4822: || p_k_line_rec.srv_id
4823: );
4824: END IF;
4825:
4826: l_return_status := okc_api.g_ret_sts_error;
4827: okc_api.set_message (g_app_name,
4828: g_required_value,
4829: g_col_name_token,
4830: 'Coverage Not Associated with '

Line 4827: okc_api.set_message (g_app_name,

4823: );
4824: END IF;
4825:
4826: l_return_status := okc_api.g_ret_sts_error;
4827: okc_api.set_message (g_app_name,
4828: g_required_value,
4829: g_col_name_token,
4830: 'Coverage Not Associated with '
4831: || p_k_line_rec.srv_id

Line 4850: IF NOT l_return_status = okc_api.g_ret_sts_success

4846: x_msg_data => l_msg_data,
4847: p_cle_id => l_line_id,
4848: p_template_id => l_subsc_template_id);
4849:
4850: IF NOT l_return_status = okc_api.g_ret_sts_success
4851: THEN
4852: IF (p_caller = 'OC')
4853: THEN
4854: fnd_message.set_name (g_app_name, 'OKS_INVD_COV_TEMP');

Line 4860: okc_api.set_message (g_app_name,

4856: VALUE => p_k_line_rec.srv_id
4857: );
4858: x_order_error := '#' || fnd_message.get_encoded || '#';
4859: ELSE
4860: okc_api.set_message (g_app_name,
4861: g_required_value,
4862: g_col_name_token,
4863: 'Invalid subscription template Associated with '
4864: || p_k_line_rec.srv_id

Line 4889: p_init_msg_list => okc_api.g_false,

4885: IF l_ctr_grpid IS NOT NULL AND l_lsl_id <> 46 ---Modified for ER 16036980
4886: THEN
4887: cs_counters_pub.autoinstantiate_counters
4888: (p_api_version => 1.0,
4889: p_init_msg_list => okc_api.g_false,
4890: p_commit => 'F',
4891: x_return_status => l_return_status,
4892: x_msg_count => x_msg_count,
4893: x_msg_data => x_msg_data,

Line 4912: IF NOT l_return_status = okc_api.g_ret_sts_success

4908: || ')'
4909: );
4910: END IF;
4911:
4912: IF NOT l_return_status = okc_api.g_ret_sts_success
4913: THEN
4914: okc_api.set_message (g_app_name,
4915: g_required_value,
4916: g_col_name_token,

Line 4914: okc_api.set_message (g_app_name,

4910: END IF;
4911:
4912: IF NOT l_return_status = okc_api.g_ret_sts_success
4913: THEN
4914: okc_api.set_message (g_app_name,
4915: g_required_value,
4916: g_col_name_token,
4917: 'Counter Instantiate (LINE)'
4918: );

Line 4945: x_return_status := okc_api.g_ret_sts_unexp_error;

4941: THEN
4942: x_return_status := l_return_status;
4943: WHEN OTHERS
4944: THEN
4945: x_return_status := okc_api.g_ret_sts_unexp_error;
4946: okc_api.set_message (g_app_name,
4947: g_unexpected_error,
4948: g_sqlcode_token,
4949: SQLCODE,

Line 4946: okc_api.set_message (g_app_name,

4942: x_return_status := l_return_status;
4943: WHEN OTHERS
4944: THEN
4945: x_return_status := okc_api.g_ret_sts_unexp_error;
4946: okc_api.set_message (g_app_name,
4947: g_unexpected_error,
4948: g_sqlcode_token,
4949: SQLCODE,
4950: g_sqlerrm_token,

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

4964: x_msg_data OUT NOCOPY VARCHAR2
4965: )
4966: IS
4967: l_api_version CONSTANT NUMBER := 1.0;
4968: l_init_msg_list CONSTANT VARCHAR2 (1) := okc_api.g_false;
4969: l_return_status VARCHAR2 (1) := 'S';
4970: l_index VARCHAR2 (2000);
4971: --Contract Line Table
4972: l_clev_tbl_in okc_contract_pub.clev_tbl_type;

Line 5026: x_return_status := okc_api.g_ret_sts_success;

5022: l_end_date DATE;
5023: l_invoice_rule_id VARCHAR2 (10);
5024: l_sts_flag VARCHAR2 (1);
5025: BEGIN
5026: x_return_status := okc_api.g_ret_sts_success;
5027: x_update_line := 'N';
5028: check_line_effectivity (p_cle_id => p_k_covd_rec.attach_2_line_id,
5029: p_srv_sdt => p_k_covd_rec.product_start_date,
5030: p_srv_edt => p_k_covd_rec.product_end_date,

Line 5055: okc_api.set_message (g_app_name,

5051: 'Covered level Dates are not within Line effectivity'
5052: );
5053: END IF;
5054:
5055: okc_api.set_message (g_app_name,
5056: g_unexpected_error,
5057: g_sqlcode_token,
5058: SQLCODE,
5059: g_sqlerrm_token,

Line 5062: l_return_status := okc_api.g_ret_sts_error;

5058: SQLCODE,
5059: g_sqlerrm_token,
5060: 'Covlvl Dates not within Line effectivity'
5061: );
5062: l_return_status := okc_api.g_ret_sts_error;
5063: RAISE g_exception_halt_validation;
5064: ELSIF l_line_status = 'Y'
5065: THEN
5066: check_hdr_effectivity (p_chr_id => p_k_covd_rec.k_id,

Line 5093: okc_api.set_message (g_app_name,

5089: 'Line Dates are not within Header effectivity'
5090: );
5091: END IF;
5092:
5093: okc_api.set_message (g_app_name,
5094: g_unexpected_error,
5095: g_sqlcode_token,
5096: SQLCODE,
5097: g_sqlerrm_token,

Line 5100: l_return_status := okc_api.g_ret_sts_error;

5096: SQLCODE,
5097: g_sqlerrm_token,
5098: 'line Dates not within Hdr effectivity'
5099: );
5100: l_return_status := okc_api.g_ret_sts_error;
5101: RAISE g_exception_halt_validation;
5102: ELSIF l_hdrstatus = 'Y'
5103: THEN
5104: get_sts_code (NULL,

Line 5140: l_return_status := okc_api.g_ret_sts_error;

5136: END IF;
5137:
5138: IF NOT l_return_status = 'S'
5139: THEN
5140: l_return_status := okc_api.g_ret_sts_error;
5141: okc_api.set_message (g_app_name,
5142: g_required_value,
5143: g_col_name_token,
5144: 'Header Effectivity Update (SUB LINE)'

Line 5141: okc_api.set_message (g_app_name,

5137:
5138: IF NOT l_return_status = 'S'
5139: THEN
5140: l_return_status := okc_api.g_ret_sts_error;
5141: okc_api.set_message (g_app_name,
5142: g_required_value,
5143: g_col_name_token,
5144: 'Header Effectivity Update (SUB LINE)'
5145: );

Line 5182: l_return_status := okc_api.g_ret_sts_error;

5178: END IF;
5179:
5180: IF NOT l_return_status = 'S'
5181: THEN
5182: l_return_status := okc_api.g_ret_sts_error;
5183: okc_api.set_message (g_app_name,
5184: g_required_value,
5185: g_col_name_token,
5186: 'LINE Effectivity Update (SUB LINE)'

Line 5183: okc_api.set_message (g_app_name,

5179:
5180: IF NOT l_return_status = 'S'
5181: THEN
5182: l_return_status := okc_api.g_ret_sts_error;
5183: okc_api.set_message (g_app_name,
5184: g_required_value,
5185: g_col_name_token,
5186: 'LINE Effectivity Update (SUB LINE)'
5187: );

Line 5206: l_return_status := okc_api.g_ret_sts_error;

5202: );
5203:
5204: IF NOT l_return_status = 'S'
5205: THEN
5206: l_return_status := okc_api.g_ret_sts_error;
5207: okc_api.set_message (g_app_name,
5208: g_required_value,
5209: g_col_name_token,
5210: 'Adjust PM Program Schedule(SUB LINE)'

Line 5207: okc_api.set_message (g_app_name,

5203:
5204: IF NOT l_return_status = 'S'
5205: THEN
5206: l_return_status := okc_api.g_ret_sts_error;
5207: okc_api.set_message (g_app_name,
5208: g_required_value,
5209: g_col_name_token,
5210: 'Adjust PM Program Schedule(SUB LINE)'
5211: );

Line 5230: l_return_status := okc_api.g_ret_sts_error;

5226: );
5227:
5228: IF NOT l_return_status = 'S'
5229: THEN
5230: l_return_status := okc_api.g_ret_sts_error;
5231: okc_api.set_message (g_app_name,
5232: g_required_value,
5233: g_col_name_token,
5234: 'Coverage Effectivity Update (SUB LINE)'

Line 5231: okc_api.set_message (g_app_name,

5227:
5228: IF NOT l_return_status = 'S'
5229: THEN
5230: l_return_status := okc_api.g_ret_sts_error;
5231: okc_api.set_message (g_app_name,
5232: g_required_value,
5233: g_col_name_token,
5234: 'Coverage Effectivity Update (SUB LINE)'
5235: );

Line 5304: p_restricted_update => okc_api.g_true,

5300: --LRT
5301: okc_contract_pub.create_contract_line
5302: (p_api_version => l_api_version,
5303: p_init_msg_list => l_init_msg_list,
5304: p_restricted_update => okc_api.g_true,
5305: x_return_status => l_return_status,
5306: x_msg_count => x_msg_count,
5307: x_msg_data => x_msg_data,
5308: p_clev_tbl => l_clev_tbl_in,

Line 5357: okc_api.set_message (g_app_name,

5353:
5354: RAISE g_exception_halt_validation;
5355: ELSE
5356: --mmadhavi
5357: okc_api.set_message (g_app_name,
5358: g_required_value,
5359: g_col_name_token,
5360: 'K LINE (SUB LINE)'
5361: );

Line 5375: p_init_msg_list => okc_api.g_true,

5371: -- 30-jan-2004 Vigandhi
5372: IF p_caller = 'ST' AND p_k_covd_rec.warranty_flag <> 'W'
5373: THEN
5374: oks_tax_util_pvt.get_tax (p_api_version => 1.0,
5375: p_init_msg_list => okc_api.g_true,
5376: p_chr_id => p_k_covd_rec.k_id,
5377: p_cle_id => l_line_id,
5378: px_rail_rec => g_rail_rec,
5379: x_msg_count => x_msg_count,

Line 5397: IF (l_return_status <> okc_api.g_ret_sts_success)

5393: END IF;
5394:
5395: -- Fixed Bug 5035571
5396: /*
5397: IF (l_return_status <> okc_api.g_ret_sts_success)
5398: THEN
5399: RAISE g_exception_halt_validation;
5400: END IF;
5401: */

Line 5423: l_klnv_tbl_in (1).created_by := okc_api.g_miss_num;

5419: );
5420: l_klnv_tbl_in (1).cle_id := l_line_id; --p_k_covd_rec.attach_2_line_id;
5421: l_klnv_tbl_in (1).dnz_chr_id := p_k_covd_rec.k_id;
5422: l_klnv_tbl_in (1).invoice_text := l_invoice_text; --IRT
5423: l_klnv_tbl_in (1).created_by := okc_api.g_miss_num;
5424: l_klnv_tbl_in (1).creation_date := okc_api.g_miss_date;
5425: l_klnv_tbl_in (1).status_text := 'Subline created from OM/IB';
5426: l_klnv_tbl_in (1).price_uom := p_k_covd_rec.price_uom;
5427: l_klnv_tbl_in (1).toplvl_uom_code := p_k_covd_rec.toplvl_uom_code;

Line 5424: l_klnv_tbl_in (1).creation_date := okc_api.g_miss_date;

5420: l_klnv_tbl_in (1).cle_id := l_line_id; --p_k_covd_rec.attach_2_line_id;
5421: l_klnv_tbl_in (1).dnz_chr_id := p_k_covd_rec.k_id;
5422: l_klnv_tbl_in (1).invoice_text := l_invoice_text; --IRT
5423: l_klnv_tbl_in (1).created_by := okc_api.g_miss_num;
5424: l_klnv_tbl_in (1).creation_date := okc_api.g_miss_date;
5425: l_klnv_tbl_in (1).status_text := 'Subline created from OM/IB';
5426: l_klnv_tbl_in (1).price_uom := p_k_covd_rec.price_uom;
5427: l_klnv_tbl_in (1).toplvl_uom_code := p_k_covd_rec.toplvl_uom_code;
5428: l_klnv_tbl_in (1).inv_print_flag := 'Y'; --Bug# 5655521

Line 5485: okc_api.set_message (g_app_name,

5481:
5482: RAISE g_exception_halt_validation;
5483: ELSE
5484: --mmadhavi
5485: okc_api.set_message (g_app_name,
5486: g_required_value,
5487: g_col_name_token,
5488: 'OKS Contract COV LINE'
5489: );

Line 5539: okc_api.set_message (g_app_name,

5535: IF l_return_status = 'S'
5536: THEN
5537: l_line_item_id := l_cimv_tbl (1).ID;
5538: ELSE
5539: okc_api.set_message (g_app_name,
5540: g_required_value,
5541: g_col_name_token,
5542: 'KItem (SUB LINE)'
5543: );

Line 5573: IF NOT l_return_status = okc_api.g_ret_sts_success

5569: || ')'
5570: );
5571: END IF;
5572:
5573: IF NOT l_return_status = okc_api.g_ret_sts_success
5574: THEN
5575: okc_api.set_message (g_app_name,
5576: g_required_value,
5577: g_col_name_token,

Line 5575: okc_api.set_message (g_app_name,

5571: END IF;
5572:
5573: IF NOT l_return_status = okc_api.g_ret_sts_success
5574: THEN
5575: okc_api.set_message (g_app_name,
5576: g_required_value,
5577: g_col_name_token,
5578: 'Order Line Id (SUB LINE)'
5579: );

Line 5816: okc_api.set_message (g_app_name,

5812: IF l_return_status = 'S'
5813: THEN
5814: l_priceattrib_id := l_pavv_tbl_out (1).ID;
5815: ELSE
5816: okc_api.set_message (g_app_name,
5817: g_required_value,
5818: g_col_name_token,
5819: 'PRICE ATTRIBUTES (SUB LINE)'
5820: );

Line 5831: x_return_status := okc_api.g_ret_sts_unexp_error;

5827: x_return_status := l_return_status;
5828: NULL;
5829: WHEN OTHERS
5830: THEN
5831: x_return_status := okc_api.g_ret_sts_unexp_error;
5832: okc_api.set_message (g_app_name,
5833: g_unexpected_error,
5834: g_sqlcode_token,
5835: SQLCODE,

Line 5832: okc_api.set_message (g_app_name,

5828: NULL;
5829: WHEN OTHERS
5830: THEN
5831: x_return_status := okc_api.g_ret_sts_unexp_error;
5832: okc_api.set_message (g_app_name,
5833: g_unexpected_error,
5834: g_sqlcode_token,
5835: SQLCODE,
5836: g_sqlerrm_token,

Line 5876: l_return_status VARCHAR2 (5) := okc_api.g_ret_sts_success;

5872:
5873: l_hdr_rec k_header_rec_type;
5874: l_line_rec k_line_service_rec_type;
5875: l_covd_rec k_line_covered_level_rec_type;
5876: l_return_status VARCHAR2 (5) := okc_api.g_ret_sts_success;
5877: l_chrid NUMBER := NULL;
5878: l_lineid NUMBER := NULL;
5879: l_covlvl_id NUMBER := NULL;
5880: l_party_name okx_parties_v.NAME%TYPE;

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

5886: l_contact_tbl_in oks_extwarprgm_pvt.contact_tbl;
5887: --SalesCredit
5888: l_salescredit_tbl oks_extwarprgm_pvt.salescredit_tbl;
5889: l_api_version CONSTANT NUMBER := 1.0;
5890: l_init_msg_list CONSTANT VARCHAR2 (1) := okc_api.g_false;
5891: l_index VARCHAR2 (2000);
5892: l_rule_group_id NUMBER;
5893: l_rule_id NUMBER;
5894: l_sts_code VARCHAR2 (30);

Line 5904: x_return_status := okc_api.g_ret_sts_success;

5900: l_strmlvl_id NUMBER := NULL;
5901: l_update_line VARCHAR2 (1);
5902: l_temp VARCHAR2 (2000);
5903: BEGIN
5904: x_return_status := okc_api.g_ret_sts_success;
5905:
5906: OPEN l_party_csr;
5907:
5908: FETCH l_party_csr

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

5920: || l_party_name
5921: || ' Warranty/Extended Warranty Contract';
5922: END IF;
5923:
5924: l_hdr_rec.contract_number := okc_api.g_miss_char;
5925: l_hdr_rec.rty_code := p_extwar_rec.rty_code;
5926: l_hdr_rec.start_date := p_extwar_rec.hdr_sdt;
5927: l_hdr_rec.end_date := p_extwar_rec.hdr_edt;
5928: --l_hdr_rec.sts_code := 'ACTIVE';

Line 6023: p_commit => okc_api.g_false,

6019: THEN
6020: okc_oc_int_pub.create_k_relationships
6021: (p_api_version => l_api_version,
6022: p_init_msg_list => l_init_msg_list,
6023: p_commit => okc_api.g_false,
6024: p_sales_contract_id => okc_api.g_miss_num,
6025: p_service_contract_id => x_chrid,
6026: p_quote_id => okc_api.g_miss_num,
6027: p_quote_line_tab => okc_oc_int_pub.g_miss_ql_tab,

Line 6024: p_sales_contract_id => okc_api.g_miss_num,

6020: okc_oc_int_pub.create_k_relationships
6021: (p_api_version => l_api_version,
6022: p_init_msg_list => l_init_msg_list,
6023: p_commit => okc_api.g_false,
6024: p_sales_contract_id => okc_api.g_miss_num,
6025: p_service_contract_id => x_chrid,
6026: p_quote_id => okc_api.g_miss_num,
6027: p_quote_line_tab => okc_oc_int_pub.g_miss_ql_tab,
6028: p_order_id => p_extwar_rec.hdr_order_hdr_id,

Line 6026: p_quote_id => okc_api.g_miss_num,

6022: p_init_msg_list => l_init_msg_list,
6023: p_commit => okc_api.g_false,
6024: p_sales_contract_id => okc_api.g_miss_num,
6025: p_service_contract_id => x_chrid,
6026: p_quote_id => okc_api.g_miss_num,
6027: p_quote_line_tab => okc_oc_int_pub.g_miss_ql_tab,
6028: p_order_id => p_extwar_rec.hdr_order_hdr_id,
6029: p_order_line_tab => okc_oc_int_pub.g_miss_ol_tab,
6030: p_trace_mode => NULL,

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

6051: END IF;
6052: END IF;
6053:
6054: l_line_rec.k_id := l_chrid;
6055: l_line_rec.k_line_number := okc_api.g_miss_char;
6056: l_line_rec.org_id := p_extwar_rec.hdr_org_id;
6057: l_line_rec.accounting_rule_id := p_extwar_rec.line_accounting_rule_id;
6058: l_line_rec.invoicing_rule_id := p_extwar_rec.line_invoicing_rule_id;
6059: l_line_rec.srv_id := p_extwar_rec.srv_id;

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

6118:
6119: l_covd_rec.k_id := l_chrid;
6120: l_covd_rec.rty_code := p_extwar_rec.rty_code;
6121: l_covd_rec.attach_2_line_id := l_lineid;
6122: l_covd_rec.line_number := okc_api.g_miss_char;
6123: l_covd_rec.customer_product_id := p_extwar_rec.lvl_cp_id;
6124: -- l_covd_rec.product_segment1 := p_extwar_rec.lvl_inventory_name;
6125: -- l_covd_rec.product_desc := p_extwar_rec.lvl_inventory_desc;
6126: l_covd_rec.product_start_date := p_extwar_rec.srv_sdt;

Line 6295: IF l_return_status <> okc_api.g_ret_sts_success

6291: || ')'
6292: );
6293: END IF;
6294:
6295: IF l_return_status <> okc_api.g_ret_sts_success
6296: THEN
6297: okc_api.set_message (g_app_name,
6298: g_required_value,
6299: g_col_name_token,

Line 6297: okc_api.set_message (g_app_name,

6293: END IF;
6294:
6295: IF l_return_status <> okc_api.g_ret_sts_success
6296: THEN
6297: okc_api.set_message (g_app_name,
6298: g_required_value,
6299: g_col_name_token,
6300: 'Sched Billing Rule (LINE)'
6301: );

Line 6405: okc_api.set_message (g_app_name,

6401: THEN
6402: RAISE g_exception_halt_validation;
6403: END IF;
6404: ELSE
6405: okc_api.set_message (g_app_name,
6406: g_required_value,
6407: g_col_name_token,
6408: 'level elements NOT EXIST'
6409: );

Line 6447: x_return_status := okc_api.g_ret_sts_unexp_error;

6443: x_return_status := l_return_status;
6444: NULL;
6445: WHEN OTHERS
6446: THEN
6447: x_return_status := okc_api.g_ret_sts_unexp_error;
6448: okc_api.set_message (g_app_name,
6449: g_unexpected_error,
6450: g_sqlcode_token,
6451: SQLCODE,

Line 6448: okc_api.set_message (g_app_name,

6444: NULL;
6445: WHEN OTHERS
6446: THEN
6447: x_return_status := okc_api.g_ret_sts_unexp_error;
6448: okc_api.set_message (g_app_name,
6449: g_unexpected_error,
6450: g_sqlcode_token,
6451: SQLCODE,
6452: g_sqlerrm_token,

Line 6574: x_return_status := okc_api.g_ret_sts_unexp_error;

6570: x_return_status := l_return_status;
6571: NULL;
6572: WHEN OTHERS
6573: THEN
6574: x_return_status := okc_api.g_ret_sts_unexp_error;
6575: okc_api.set_message (g_app_name,
6576: g_unexpected_error,
6577: g_sqlcode_token,
6578: SQLCODE,

Line 6575: okc_api.set_message (g_app_name,

6571: NULL;
6572: WHEN OTHERS
6573: THEN
6574: x_return_status := okc_api.g_ret_sts_unexp_error;
6575: okc_api.set_message (g_app_name,
6576: g_unexpected_error,
6577: g_sqlcode_token,
6578: SQLCODE,
6579: g_sqlerrm_token,

Line 6827: x_return_status := okc_api.g_ret_sts_unexp_error;

6823: x_return_status := l_return_status;
6824: NULL;
6825: WHEN OTHERS
6826: THEN
6827: x_return_status := okc_api.g_ret_sts_unexp_error;
6828: okc_api.set_message (g_app_name,
6829: g_unexpected_error,
6830: g_sqlcode_token,
6831: SQLCODE,

Line 6828: okc_api.set_message (g_app_name,

6824: NULL;
6825: WHEN OTHERS
6826: THEN
6827: x_return_status := okc_api.g_ret_sts_unexp_error;
6828: okc_api.set_message (g_app_name,
6829: g_unexpected_error,
6830: g_sqlcode_token,
6831: SQLCODE,
6832: g_sqlerrm_token,

Line 6924: l_return_status VARCHAR2 (5) := okc_api.g_ret_sts_success;

6920: l_renewal_id NUMBER;
6921: l_line_rec k_line_service_rec_type;
6922: l_covd_rec k_line_covered_level_rec_type;
6923: l_available_yn VARCHAR2 (1);
6924: l_return_status VARCHAR2 (5) := okc_api.g_ret_sts_success;
6925: l_chrid NUMBER := NULL;
6926: l_lineid NUMBER := NULL;
6927: l_ctr NUMBER := 0;
6928: l_ctr1 NUMBER := 0;

Line 6987: x_return_status := okc_api.g_ret_sts_success;

6983: l_create_oper_instance VARCHAR2 (1);
6984: l_new_sdate DATE;
6985: l_order_line_id Number;
6986: BEGIN
6987: x_return_status := okc_api.g_ret_sts_success;
6988: l_target_chr_id := 0;
6989: l_old_cp_id := 0;
6990:
6991: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

Line 7171: IF NOT l_return_status = okc_api.g_ret_sts_success

7167: || ')'
7168: );
7169: END IF;
7170:
7171: IF NOT l_return_status = okc_api.g_ret_sts_success
7172: THEN
7173: RAISE g_exception_halt_validation;
7174: END IF;
7175:

Line 7216: okc_api.set_message (g_app_name,

7212: END IF;
7213:
7214: IF NOT l_return_status = 'S'
7215: THEN
7216: okc_api.set_message (g_app_name,
7217: g_required_value,
7218: g_col_name_token,
7219: 'OKS Contract COV LINE'
7220: );

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

7293: END IF;
7294:
7295: l_covd_rec.k_id := p_kdtl_tbl (l_ctr).hdr_id;
7296: l_covd_rec.attach_2_line_id := p_kdtl_tbl (l_ctr).service_line_id;
7297: l_covd_rec.line_number := okc_api.g_miss_char;
7298: l_covd_rec.customer_product_id := p_kdtl_tbl (l_ctr).new_cp_id;
7299: l_covd_rec.product_segment1 := p_kdtl_tbl (l_ctr).prod_name;
7300: l_covd_rec.product_desc := p_kdtl_tbl (l_ctr).prod_description;
7301: l_covd_rec.product_start_date := l_new_sdate;

Line 7355: IF NOT l_return_status = okc_api.g_ret_sts_success

7351: || ')'
7352: );
7353: END IF;
7354:
7355: IF NOT l_return_status = okc_api.g_ret_sts_success
7356: THEN
7357: RAISE g_exception_halt_validation;
7358: END IF;
7359:

Line 7616: IF NOT l_return_status = okc_api.g_ret_sts_success

7612: END IF;
7613:
7614: x_return_status := l_return_status;
7615:
7616: IF NOT l_return_status = okc_api.g_ret_sts_success
7617: THEN
7618: x_return_status := l_return_status;
7619: RAISE g_exception_halt_validation;
7620: END IF;

Line 7653: IF NOT l_return_status = okc_api.g_ret_sts_success

7649: END IF;
7650:
7651: x_return_status := l_return_status;
7652:
7653: IF NOT l_return_status = okc_api.g_ret_sts_success
7654: THEN
7655: x_return_status := l_return_status;
7656: RAISE g_exception_halt_validation;
7657: END IF;

Line 7683: x_return_status := okc_api.g_ret_sts_unexp_error;

7679: x_return_status := l_return_status;
7680: NULL;
7681: WHEN OTHERS
7682: THEN
7683: x_return_status := okc_api.g_ret_sts_unexp_error;
7684: okc_api.set_message (g_app_name,
7685: g_unexpected_error,
7686: g_sqlcode_token,
7687: SQLCODE,

Line 7684: okc_api.set_message (g_app_name,

7680: NULL;
7681: WHEN OTHERS
7682: THEN
7683: x_return_status := okc_api.g_ret_sts_unexp_error;
7684: okc_api.set_message (g_app_name,
7685: g_unexpected_error,
7686: g_sqlcode_token,
7687: SQLCODE,
7688: g_sqlerrm_token,

Line 7815: l_return_status VARCHAR2 (5) := okc_api.g_ret_sts_success;

7811: -- l_salescredit_tbl_hdr oks_extwarprgm_pvt.salescredit_tbl;
7812: l_line_rec k_line_service_rec_type;
7813: l_covd_rec k_line_covered_level_rec_type;
7814: l_available_yn CHAR;
7815: l_return_status VARCHAR2 (5) := okc_api.g_ret_sts_success;
7816: l_chrid NUMBER := NULL;
7817: l_lineid NUMBER := NULL;
7818: l_days NUMBER := 0;
7819: l_day1price NUMBER := 0;

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

7833: l_clev_tbl_out okc_contract_pub.clev_tbl_type;
7834: l_price_attribs_in oks_extwarprgm_pvt.pricing_attributes_type;
7835: l_cov_rec l_cov_csr%ROWTYPE;
7836: l_api_version CONSTANT NUMBER := 1.0;
7837: l_init_msg_list CONSTANT VARCHAR2 (1) := okc_api.g_false;
7838: l_list_price NUMBER;
7839: l_no_of_days NUMBER;
7840: l_billed_amount NUMBER;
7841: l_billed_upto_dt DATE;

Line 7867: x_return_status := okc_api.g_ret_sts_success;

7863: l_create_oper_instance VARCHAR2 (1);
7864: l_termdt DATE;
7865: l_order_line_id Number;
7866: BEGIN
7867: x_return_status := okc_api.g_ret_sts_success;
7868: l_old_cp_id := 0;
7869: l_target_chr_id := 0;
7870:
7871: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

Line 8107: p_restricted_update => okc_api.g_true,

8103:
8104: okc_contract_pub.update_contract_line
8105: (p_api_version => l_api_version,
8106: p_init_msg_list => l_init_msg_list,
8107: p_restricted_update => okc_api.g_true,
8108: x_return_status => l_return_status,
8109: x_msg_count => x_msg_count,
8110: x_msg_data => x_msg_data,
8111: p_clev_tbl => l_clev_tbl_in,

Line 8129: IF NOT l_return_status = okc_api.g_ret_sts_success

8125: || ')'
8126: );
8127: END IF;
8128:
8129: IF NOT l_return_status = okc_api.g_ret_sts_success
8130: THEN
8131: RAISE g_exception_halt_validation;
8132: END IF;
8133:

Line 8173: okc_api.set_message (g_app_name,

8169: END IF;
8170:
8171: IF NOT l_return_status = 'S'
8172: THEN
8173: okc_api.set_message (g_app_name,
8174: g_required_value,
8175: g_col_name_token,
8176: 'OKS Contract COV LINE'
8177: );

Line 8218: IF NOT l_return_status = okc_api.g_ret_sts_success

8214: || ')'
8215: );
8216: END IF;
8217:
8218: IF NOT l_return_status = okc_api.g_ret_sts_success
8219: THEN
8220: RAISE g_exception_halt_validation;
8221: END IF;
8222:

Line 8634: IF NOT l_return_status = okc_api.g_ret_sts_success

8630: END IF;
8631:
8632: x_return_status := l_return_status;
8633:
8634: IF NOT l_return_status = okc_api.g_ret_sts_success
8635: THEN
8636: x_return_status := l_return_status;
8637: RAISE g_exception_halt_validation;
8638: END IF;

Line 8671: IF NOT l_return_status = okc_api.g_ret_sts_success

8667: END IF;
8668:
8669: x_return_status := l_return_status;
8670:
8671: IF NOT l_return_status = okc_api.g_ret_sts_success
8672: THEN
8673: x_return_status := l_return_status;
8674: RAISE g_exception_halt_validation;
8675: END IF;

Line 8702: x_return_status := okc_api.g_ret_sts_unexp_error;

8698: x_return_status := l_return_status;
8699: NULL;
8700: WHEN OTHERS
8701: THEN
8702: x_return_status := okc_api.g_ret_sts_unexp_error;
8703: okc_api.set_message (g_app_name,
8704: g_unexpected_error,
8705: g_sqlcode_token,
8706: SQLCODE,

Line 8703: okc_api.set_message (g_app_name,

8699: NULL;
8700: WHEN OTHERS
8701: THEN
8702: x_return_status := okc_api.g_ret_sts_unexp_error;
8703: okc_api.set_message (g_app_name,
8704: g_unexpected_error,
8705: g_sqlcode_token,
8706: SQLCODE,
8707: g_sqlerrm_token,

Line 8769: l_return_status VARCHAR2 (5) := okc_api.g_ret_sts_success;

8765: l_salescredit_tbl_hdr oks_extwarprgm_pvt.salescredit_tbl;
8766: l_line_rec k_line_service_rec_type;
8767: l_covd_rec k_line_covered_level_rec_type;
8768: l_available_yn CHAR;
8769: l_return_status VARCHAR2 (5) := okc_api.g_ret_sts_success;
8770: l_chrid NUMBER := NULL;
8771: l_lineid NUMBER := NULL;
8772: l_days NUMBER := 0;
8773: l_day1price NUMBER := 0;

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

8777: --Contract Line Table
8778: l_clev_tbl_in okc_contract_pub.clev_tbl_type;
8779: l_clev_tbl_out okc_contract_pub.clev_tbl_type;
8780: l_api_version CONSTANT NUMBER := 1.0;
8781: l_init_msg_list CONSTANT VARCHAR2 (1) := okc_api.g_false;
8782: l_retdt DATE;
8783: l_ste_code VARCHAR2 (30);
8784: l_sts_code VARCHAR2 (30);
8785: l_suppress_credit VARCHAR2 (2) := 'N';

Line 8798: x_return_status := okc_api.g_ret_sts_success;

8794: l_alllines_cancelled VARCHAR2 (1);
8795: l_term_date_flag VARCHAR2 (1);
8796: l_credit_amount VARCHAR2 (30);
8797: BEGIN
8798: x_return_status := okc_api.g_ret_sts_success;
8799: l_old_cp_id := 0;
8800:
8801: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
8802: THEN

Line 8834: l_return_status := okc_api.g_ret_sts_error;

8830: || ' in QA_HOLD status'
8831: );
8832: END IF;
8833:
8834: l_return_status := okc_api.g_ret_sts_error;
8835: okc_api.set_message (g_app_name,
8836: g_invalid_value,
8837: g_col_name_token,
8838: 'Return not allowed. Contract '

Line 8835: okc_api.set_message (g_app_name,

8831: );
8832: END IF;
8833:
8834: l_return_status := okc_api.g_ret_sts_error;
8835: okc_api.set_message (g_app_name,
8836: g_invalid_value,
8837: g_col_name_token,
8838: 'Return not allowed. Contract '
8839: || p_kdtl_tbl (l_ctr).contract_number

Line 8990: IF NOT l_return_status = okc_api.g_ret_sts_success

8986: || ')'
8987: );
8988: END IF;
8989:
8990: IF NOT l_return_status = okc_api.g_ret_sts_success
8991: THEN
8992: RAISE g_exception_halt_validation;
8993: END IF;
8994:

Line 9020: p_restricted_update => okc_api.g_true,

9016:
9017: okc_contract_pub.update_contract_line
9018: (p_api_version => l_api_version,
9019: p_init_msg_list => l_init_msg_list,
9020: p_restricted_update => okc_api.g_true,
9021: x_return_status => l_return_status,
9022: x_msg_count => x_msg_count,
9023: x_msg_data => x_msg_data,
9024: p_clev_tbl => l_clev_tbl_in,

Line 9028: IF NOT l_return_status = okc_api.g_ret_sts_success

9024: p_clev_tbl => l_clev_tbl_in,
9025: x_clev_tbl => l_clev_tbl_out
9026: );
9027:
9028: IF NOT l_return_status = okc_api.g_ret_sts_success
9029: THEN
9030: RAISE g_exception_halt_validation;
9031: END IF;
9032: END IF;

Line 9060: p_restricted_update => okc_api.g_true,

9056:
9057: okc_contract_pub.update_contract_header
9058: (p_api_version => l_api_version,
9059: p_init_msg_list => l_init_msg_list,
9060: p_restricted_update => okc_api.g_true,
9061: x_return_status => l_return_status,
9062: x_msg_count => x_msg_count,
9063: x_msg_data => x_msg_data,
9064: p_chrv_tbl => l_chrv_tbl_in,

Line 9082: IF NOT l_return_status = okc_api.g_ret_sts_success

9078: || ')'
9079: );
9080: END IF;
9081:
9082: IF NOT l_return_status = okc_api.g_ret_sts_success
9083: THEN
9084: RAISE g_exception_halt_validation;
9085: END IF;
9086: END IF;

Line 9130: IF NOT l_return_status = okc_api.g_ret_sts_success

9126: || ')'
9127: );
9128: END IF;
9129:
9130: IF NOT l_return_status = okc_api.g_ret_sts_success
9131: THEN
9132: RAISE g_exception_halt_validation;
9133: END IF;
9134:

Line 9180: IF NOT l_return_status = okc_api.g_ret_sts_success

9176: || ')'
9177: );
9178: END IF;
9179:
9180: IF NOT l_return_status = okc_api.g_ret_sts_success
9181: THEN
9182: RAISE g_exception_halt_validation;
9183: END IF;
9184: END IF;

Line 9228: IF NOT l_return_status = okc_api.g_ret_sts_success

9224: || ')'
9225: );
9226: END IF;
9227:
9228: IF NOT l_return_status = okc_api.g_ret_sts_success
9229: THEN
9230: RAISE g_exception_halt_validation;
9231: END IF;
9232: END IF;

Line 9354: IF NOT l_return_status = okc_api.g_ret_sts_success

9350: END IF;
9351:
9352: x_return_status := l_return_status;
9353:
9354: IF NOT l_return_status = okc_api.g_ret_sts_success
9355: THEN
9356: x_return_status := l_return_status;
9357: RAISE g_exception_halt_validation;
9358: END IF;

Line 9387: IF NOT l_return_status = okc_api.g_ret_sts_success

9383: END IF;
9384:
9385: x_return_status := l_return_status;
9386:
9387: IF NOT l_return_status = okc_api.g_ret_sts_success
9388: THEN
9389: x_return_status := l_return_status;
9390: RAISE g_exception_halt_validation;
9391: END IF;

Line 9430: x_return_status := okc_api.g_ret_sts_unexp_error;

9426: x_return_status := l_return_status;
9427: NULL;
9428: WHEN OTHERS
9429: THEN
9430: x_return_status := okc_api.g_ret_sts_unexp_error;
9431: okc_api.set_message (g_app_name,
9432: g_unexpected_error,
9433: g_sqlcode_token,
9434: SQLCODE,

Line 9431: okc_api.set_message (g_app_name,

9427: NULL;
9428: WHEN OTHERS
9429: THEN
9430: x_return_status := okc_api.g_ret_sts_unexp_error;
9431: okc_api.set_message (g_app_name,
9432: g_unexpected_error,
9433: g_sqlcode_token,
9434: SQLCODE,
9435: g_sqlerrm_token,

Line 9599: l_return_status VARCHAR2 (5) := okc_api.g_ret_sts_success;

9595: l_line_rec oks_extwarprgm_pvt.k_line_service_rec_type;
9596: l_covd_rec oks_extwarprgm_pvt.k_line_covered_level_rec_type;
9597: --l_kdtl_tbl oks_extwar_util_pvt.contract_tbl_type;
9598: l_available_yn CHAR;
9599: l_return_status VARCHAR2 (5) := okc_api.g_ret_sts_success;
9600: l_line_found VARCHAR2 (1);
9601: l_ste_code VARCHAR2 (40);
9602: l_sts_code VARCHAR2 (40);
9603: l_ctr NUMBER;

Line 9734: x_return_status := okc_api.g_ret_sts_unexp_error;

9730: CLOSE l_party_csr;
9731: EXCEPTION
9732: WHEN OTHERS
9733: THEN
9734: x_return_status := okc_api.g_ret_sts_unexp_error;
9735: okc_api.set_message (g_app_name,
9736: g_unexpected_error,
9737: g_sqlcode_token,
9738: SQLCODE,

Line 9735: okc_api.set_message (g_app_name,

9731: EXCEPTION
9732: WHEN OTHERS
9733: THEN
9734: x_return_status := okc_api.g_ret_sts_unexp_error;
9735: okc_api.set_message (g_app_name,
9736: g_unexpected_error,
9737: g_sqlcode_token,
9738: SQLCODE,
9739: g_sqlerrm_token,

Line 9859: x_return_status := okc_api.g_ret_sts_success;

9855: SELECT ctc_id, sales_credit_type_id1, PERCENT, sales_group_id
9856: FROM oks_k_sales_credits_v
9857: WHERE chr_id = p_chr_id AND cle_id IS NULL;
9858: BEGIN
9859: x_return_status := okc_api.g_ret_sts_success;
9860:
9861: OPEN l_get_agrid_csr (p_kdtl_rec.hdr_id); --07-May-2003
9862:
9863: FETCH l_get_agrid_csr

Line 9907: IF NOT l_return_status = okc_api.g_ret_sts_success

9903: || l_return_status
9904: );
9905: END IF;
9906:
9907: IF NOT l_return_status = okc_api.g_ret_sts_success
9908: THEN
9909: x_return_status := l_return_status;
9910: RAISE g_exception_halt_validation;
9911: END IF;

Line 10052: l_return_status := okc_api.g_ret_sts_error;

10048: || ') is not valid'
10049: );
10050: END IF;
10051:
10052: l_return_status := okc_api.g_ret_sts_error;
10053: okc_api.set_message (g_app_name,
10054: g_required_value,
10055: g_col_name_token,
10056: 'Bill to id is not Valid'

Line 10053: okc_api.set_message (g_app_name,

10049: );
10050: END IF;
10051:
10052: l_return_status := okc_api.g_ret_sts_error;
10053: okc_api.set_message (g_app_name,
10054: g_required_value,
10055: g_col_name_token,
10056: 'Bill to id is not Valid'
10057: );

Line 10089: l_return_status := okc_api.g_ret_sts_error;

10085: || ') is not valid'
10086: );
10087: END IF;
10088:
10089: l_return_status := okc_api.g_ret_sts_error;
10090: okc_api.set_message (g_app_name,
10091: g_required_value,
10092: g_col_name_token,
10093: 'Ship to id is not Valid'

Line 10090: okc_api.set_message (g_app_name,

10086: );
10087: END IF;
10088:
10089: l_return_status := okc_api.g_ret_sts_error;
10090: okc_api.set_message (g_app_name,
10091: g_required_value,
10092: g_col_name_token,
10093: 'Ship to id is not Valid'
10094: );

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

10115: )
10116: );
10117: -- Fix for bug 3588355 End
10118: l_hdr_rec.order_line_id := NULL;
10119: l_hdr_rec.contract_number := okc_api.g_miss_char;
10120: l_hdr_rec.rty_code := 'CONTRACTTRANSFERORDER';
10121: --l_hdr_rec.start_date := trunc(l_trfdt);
10122: l_hdr_rec.end_date := p_kdtl_rec.service_edt;
10123: l_hdr_rec.class_code := 'SVC';

Line 10254: x_return_status := okc_api.g_ret_sts_unexp_error;

10250: x_return_status := l_return_status;
10251: NULL;
10252: WHEN OTHERS
10253: THEN
10254: x_return_status := okc_api.g_ret_sts_unexp_error;
10255: okc_api.set_message (g_app_name,
10256: g_unexpected_error,
10257: g_sqlcode_token,
10258: SQLCODE,

Line 10255: okc_api.set_message (g_app_name,

10251: NULL;
10252: WHEN OTHERS
10253: THEN
10254: x_return_status := okc_api.g_ret_sts_unexp_error;
10255: okc_api.set_message (g_app_name,
10256: g_unexpected_error,
10257: g_sqlcode_token,
10258: SQLCODE,
10259: g_sqlerrm_token,

Line 10335: x_return_status := okc_api.g_ret_sts_success;

10331:
10332: l_sc_ctr NUMBER;
10333: l_salescredit_tbl oks_extwarprgm_pvt.salescredit_tbl;
10334: BEGIN
10335: x_return_status := okc_api.g_ret_sts_success;
10336:
10337: OPEN l_line_rule_csr (p_kdtl_rec.service_line_id);
10338:
10339: FETCH l_line_rule_csr

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

10350:
10351: CLOSE l_get_bill_ship_csr;
10352:
10353: l_line_rec.k_id := p_hdr_id;
10354: l_line_rec.k_line_number := okc_api.g_miss_char;
10355: l_line_rec.org_id := p_kdtl_rec.hdr_org_id;
10356: l_line_rec.accounting_rule_id := l_acct_id;
10357: l_line_rec.invoicing_rule_id := -2;
10358: --l_inv_id; -- fix for bug 3451440

Line 10522: x_return_status := okc_api.g_ret_sts_unexp_error;

10518: x_return_status := l_return_status;
10519: NULL;
10520: WHEN OTHERS
10521: THEN
10522: x_return_status := okc_api.g_ret_sts_unexp_error;
10523: okc_api.set_message (g_app_name,
10524: g_unexpected_error,
10525: g_sqlcode_token,
10526: SQLCODE,

Line 10523: okc_api.set_message (g_app_name,

10519: NULL;
10520: WHEN OTHERS
10521: THEN
10522: x_return_status := okc_api.g_ret_sts_unexp_error;
10523: okc_api.set_message (g_app_name,
10524: g_unexpected_error,
10525: g_sqlcode_token,
10526: SQLCODE,
10527: g_sqlerrm_token,

Line 10602: x_return_status := okc_api.g_ret_sts_success;

10598: l_duration NUMBER;
10599: l_timeunits VARCHAR2 (25);
10600: --l_xfer_timeunits VARCHAR2(25);
10601: BEGIN
10602: x_return_status := okc_api.g_ret_sts_success;
10603:
10604: /* Open l_Cust_csr;
10605: Fetch l_Cust_csr into l_Cust_rec;
10606: If l_Cust_csr%notfound Then

Line 10612: l_return_status := OKC_API.G_RET_STS_ERROR;

10608: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
10609: fnd_log.string(FND_LOG.LEVEL_ERROR,G_MODULE_CURRENT||'.CREATE_K_SYSTEM_TRF.ERROR',
10610: 'l_Cust_csr Not Found ' );
10611: END IF;
10612: l_return_status := OKC_API.G_RET_STS_ERROR;
10613: OKC_API.set_message(G_APP_NAME,'OKS_CUST_PROD_DTLS_NOT_FOUND','CUSTOMER_PRODUCT',p_kdtl_rec.old_cp_id);
10614: Raise G_EXCEPTION_HALT_VALIDATION;
10615: End if;
10616: Close l_Cust_csr;

Line 10613: OKC_API.set_message(G_APP_NAME,'OKS_CUST_PROD_DTLS_NOT_FOUND','CUSTOMER_PRODUCT',p_kdtl_rec.old_cp_id);

10609: fnd_log.string(FND_LOG.LEVEL_ERROR,G_MODULE_CURRENT||'.CREATE_K_SYSTEM_TRF.ERROR',
10610: 'l_Cust_csr Not Found ' );
10611: END IF;
10612: l_return_status := OKC_API.G_RET_STS_ERROR;
10613: OKC_API.set_message(G_APP_NAME,'OKS_CUST_PROD_DTLS_NOT_FOUND','CUSTOMER_PRODUCT',p_kdtl_rec.old_cp_id);
10614: Raise G_EXCEPTION_HALT_VALIDATION;
10615: End if;
10616: Close l_Cust_csr;
10617: */ -- Amount to be prorated

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

10705:
10706: l_covd_rec.k_id := p_hdr_id;
10707: l_covd_rec.rty_code := 'CONTRACTTRANSFERORDER';
10708: l_covd_rec.attach_2_line_id := p_line_id;
10709: l_covd_rec.line_number := okc_api.g_miss_char;
10710: l_covd_rec.customer_product_id := p_kdtl_rec.old_cp_id;
10711: l_covd_rec.product_segment1 := p_kdtl_rec.prod_name;
10712: l_covd_rec.product_desc := p_kdtl_rec.prod_description;
10713: l_covd_rec.product_start_date := TRUNC (l_trfdt);

Line 10829: x_return_status := okc_api.g_ret_sts_unexp_error;

10825: x_return_status := l_return_status;
10826: NULL;
10827: WHEN OTHERS
10828: THEN
10829: x_return_status := okc_api.g_ret_sts_unexp_error;
10830: okc_api.set_message (g_app_name,
10831: g_unexpected_error,
10832: g_sqlcode_token,
10833: SQLCODE,

Line 10830: okc_api.set_message (g_app_name,

10826: NULL;
10827: WHEN OTHERS
10828: THEN
10829: x_return_status := okc_api.g_ret_sts_unexp_error;
10830: okc_api.set_message (g_app_name,
10831: g_unexpected_error,
10832: g_sqlcode_token,
10833: SQLCODE,
10834: g_sqlerrm_token,

Line 10956: IF l_return_status <> okc_api.g_ret_sts_success

10952: || ')'
10953: );
10954: END IF;
10955:
10956: IF l_return_status <> okc_api.g_ret_sts_success
10957: THEN
10958: okc_api.set_message (g_app_name,
10959: g_required_value,
10960: g_col_name_token,

Line 10958: okc_api.set_message (g_app_name,

10954: END IF;
10955:
10956: IF l_return_status <> okc_api.g_ret_sts_success
10957: THEN
10958: okc_api.set_message (g_app_name,
10959: g_required_value,
10960: g_col_name_token,
10961: 'Sched Billing Rule (LINE)'
10962: );

Line 11051: okc_api.set_message (g_app_name,

11047: Raise G_EXCEPTION_HALT_VALIDATION;
11048: End if;
11049: */
11050: ELSE
11051: okc_api.set_message (g_app_name,
11052: g_required_value,
11053: g_col_name_token,
11054: 'level elements NOT EXIST'
11055: );

Line 11068: x_return_status := okc_api.g_ret_sts_unexp_error;

11064: x_return_status := l_return_status;
11065: NULL;
11066: WHEN OTHERS
11067: THEN
11068: x_return_status := okc_api.g_ret_sts_unexp_error;
11069: okc_api.set_message (g_app_name,
11070: g_unexpected_error,
11071: g_sqlcode_token,
11072: SQLCODE,

Line 11069: okc_api.set_message (g_app_name,

11065: NULL;
11066: WHEN OTHERS
11067: THEN
11068: x_return_status := okc_api.g_ret_sts_unexp_error;
11069: okc_api.set_message (g_app_name,
11070: g_unexpected_error,
11071: g_sqlcode_token,
11072: SQLCODE,
11073: g_sqlerrm_token,

Line 11078: x_return_status := okc_api.g_ret_sts_success;

11074: SQLERRM
11075: );
11076: END;
11077: BEGIN
11078: x_return_status := okc_api.g_ret_sts_success;
11079: l_old_cp_id := 0;
11080:
11081: IF p_kdtl_tbl.COUNT > 0
11082: THEN

Line 11096: l_return_status := okc_api.g_ret_sts_error;

11092: );
11093:
11094: IF l_ste_code = 'HOLD'
11095: THEN
11096: l_return_status := okc_api.g_ret_sts_error;
11097:
11098: IF fnd_log.level_error >= fnd_log.g_current_runtime_level
11099: THEN
11100: fnd_log.STRING (fnd_log.level_error,

Line 11107: okc_api.set_message (g_app_name,

11103: 'Contract in QA_HOLD status'
11104: );
11105: END IF;
11106:
11107: okc_api.set_message (g_app_name,
11108: g_invalid_value,
11109: g_col_name_token,
11110: 'Termination not allowed .Contract '
11111: || p_kdtl_tbl (l_ctr).contract_number

Line 11366: IF NOT l_return_status = okc_api.g_ret_sts_success

11362: || ')'
11363: );
11364: END IF;
11365:
11366: IF NOT l_return_status = okc_api.g_ret_sts_success
11367: THEN
11368: RAISE g_exception_halt_validation;
11369: END IF;
11370:

Line 11397: p_restricted_update => okc_api.g_true,

11393:
11394: okc_contract_pub.update_contract_line
11395: (p_api_version => l_api_version,
11396: p_init_msg_list => l_init_msg_list,
11397: p_restricted_update => okc_api.g_true,
11398: x_return_status => l_return_status,
11399: x_msg_count => x_msg_count,
11400: x_msg_data => x_msg_data,
11401: p_clev_tbl => l_clev_tbl_in,

Line 11418: IF NOT l_return_status = okc_api.g_ret_sts_success

11414: || ')'
11415: );
11416: END IF;
11417:
11418: IF NOT l_return_status = okc_api.g_ret_sts_success
11419: THEN
11420: RAISE g_exception_halt_validation;
11421: END IF;
11422: END IF;

Line 11447: p_restricted_update => okc_api.g_true,

11443:
11444: okc_contract_pub.update_contract_header
11445: (p_api_version => l_api_version,
11446: p_init_msg_list => l_init_msg_list,
11447: p_restricted_update => okc_api.g_true,
11448: x_return_status => l_return_status,
11449: x_msg_count => x_msg_count,
11450: x_msg_data => x_msg_data,
11451: p_chrv_tbl => l_chrv_tbl_in,

Line 11469: IF NOT l_return_status = okc_api.g_ret_sts_success

11465: || ')'
11466: );
11467: END IF;
11468:
11469: IF NOT l_return_status = okc_api.g_ret_sts_success
11470: THEN
11471: RAISE g_exception_halt_validation;
11472: END IF;
11473: END IF;

Line 11527: IF NOT l_return_status = okc_api.g_ret_sts_success

11523: || ')'
11524: );
11525: END IF;
11526:
11527: IF NOT l_return_status = okc_api.g_ret_sts_success
11528: THEN
11529: RAISE g_exception_halt_validation;
11530: END IF;
11531:

Line 11580: IF NOT l_return_status = okc_api.g_ret_sts_success

11576: || ')'
11577: );
11578: END IF;
11579:
11580: IF NOT l_return_status = okc_api.g_ret_sts_success
11581: THEN
11582: RAISE g_exception_halt_validation;
11583: END IF;
11584: END IF;

Line 11629: IF NOT l_return_status = okc_api.g_ret_sts_success

11625: || ')'
11626: );
11627: END IF;
11628:
11629: IF NOT l_return_status = okc_api.g_ret_sts_success
11630: THEN
11631: RAISE g_exception_halt_validation;
11632: END IF;
11633: END IF; --Date_Cancelled Is Not Null

Line 11874: IF NOT l_return_status = okc_api.g_ret_sts_success

11870: || ')'
11871: );
11872: END IF;
11873:
11874: IF NOT l_return_status = okc_api.g_ret_sts_success
11875: THEN
11876: RAISE g_exception_halt_validation;
11877: END IF;
11878:

Line 11907: p_restricted_update => okc_api.g_true,

11903:
11904: okc_contract_pub.update_contract_line
11905: (p_api_version => l_api_version,
11906: p_init_msg_list => l_init_msg_list,
11907: p_restricted_update => okc_api.g_true,
11908: x_return_status => l_return_status,
11909: x_msg_count => x_msg_count,
11910: x_msg_data => x_msg_data,
11911: p_clev_tbl => l_clev_tbl_in,

Line 11928: IF NOT l_return_status = okc_api.g_ret_sts_success

11924: || ')'
11925: );
11926: END IF;
11927:
11928: IF NOT l_return_status = okc_api.g_ret_sts_success
11929: THEN
11930: RAISE g_exception_halt_validation;
11931: END IF;
11932: END IF;

Line 11957: p_restricted_update => okc_api.g_true,

11953:
11954: okc_contract_pub.update_contract_header
11955: (p_api_version => l_api_version,
11956: p_init_msg_list => l_init_msg_list,
11957: p_restricted_update => okc_api.g_true,
11958: x_return_status => l_return_status,
11959: x_msg_count => x_msg_count,
11960: x_msg_data => x_msg_data,
11961: p_chrv_tbl => l_chrv_tbl_in,

Line 11979: IF NOT l_return_status = okc_api.g_ret_sts_success

11975: || ')'
11976: );
11977: END IF;
11978:
11979: IF NOT l_return_status = okc_api.g_ret_sts_success
11980: THEN
11981: RAISE g_exception_halt_validation;
11982: END IF;
11983: END IF;

Line 12029: IF NOT l_return_status = okc_api.g_ret_sts_success

12025: || ')'
12026: );
12027: END IF;
12028:
12029: IF NOT l_return_status = okc_api.g_ret_sts_success
12030: THEN
12031: RAISE g_exception_halt_validation;
12032: END IF;
12033:

Line 12082: IF NOT l_return_status = okc_api.g_ret_sts_success

12078: || ')'
12079: );
12080: END IF;
12081:
12082: IF NOT l_return_status = okc_api.g_ret_sts_success
12083: THEN
12084: RAISE g_exception_halt_validation;
12085: END IF;
12086: END IF;

Line 12131: IF NOT l_return_status = okc_api.g_ret_sts_success

12127: || ')'
12128: );
12129: END IF;
12130:
12131: IF NOT l_return_status = okc_api.g_ret_sts_success
12132: THEN
12133: RAISE g_exception_halt_validation;
12134: END IF;
12135: END IF;

Line 12436: okc_api.g_ret_sts_success

12432: );
12433: END IF;
12434:
12435: IF NOT l_return_status =
12436: okc_api.g_ret_sts_success
12437: THEN
12438: RAISE g_exception_halt_validation;
12439: END IF;
12440:

Line 12633: okc_api.g_ret_sts_success

12629: );
12630: END IF;
12631:
12632: IF NOT l_return_status =
12633: okc_api.g_ret_sts_success
12634: THEN
12635: RAISE g_exception_halt_validation;
12636: END IF;
12637:

Line 12706: p_init_msg_list => okc_api.g_false,

12702: CLOSE l_qa_csr;
12703:
12704: okc_qa_check_pub.execute_qa_check_list
12705: (p_api_version => l_api_version,
12706: p_init_msg_list => okc_api.g_false,
12707: x_return_status => x_return_status,
12708: x_msg_count => x_msg_count,
12709: x_msg_data => x_msg_data,
12710: p_qcl_id => l_qcl_id,

Line 12730: okc_api.g_ret_sts_success

12726: );
12727: END IF;
12728:
12729: IF x_return_status <>
12730: okc_api.g_ret_sts_success
12731: THEN
12732: RAISE g_exception_halt_validation;
12733: END IF;
12734:

Line 12804: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

12800: /*update status in okc_contacts table*/
12801: OKC_CTC_PVT.update_contact_stecode(p_chr_id => l_merge_chr_id,
12802: x_return_status=>l_return_status);
12803:
12804: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
12805: RAISE g_exception_halt_validation;
12806: END IF;
12807: /*bugfix for 6882512*/
12808: UPDATE okc_k_lines_b

Line 12877: okc_api.g_ret_sts_success

12873: );
12874: END IF;
12875:
12876: IF NOT l_return_status =
12877: okc_api.g_ret_sts_success
12878: THEN
12879: RAISE g_exception_halt_validation;
12880: END IF;
12881:

Line 12914: okc_api.g_ret_sts_success

12910: );
12911: END IF;
12912:
12913: IF NOT l_return_status =
12914: okc_api.g_ret_sts_success
12915: THEN
12916: RAISE g_exception_halt_validation;
12917: END IF;
12918:

Line 12952: okc_api.g_ret_sts_success

12948: );
12949: END IF;
12950:
12951: IF NOT l_return_status =
12952: okc_api.g_ret_sts_success
12953: THEN
12954: okc_api.set_message
12955: (g_app_name,
12956: g_required_value,

Line 12954: okc_api.set_message

12950:
12951: IF NOT l_return_status =
12952: okc_api.g_ret_sts_success
12953: THEN
12954: okc_api.set_message
12955: (g_app_name,
12956: g_required_value,
12957: g_col_name_token,
12958: 'Coverage Extn creation error '

Line 12990: okc_api.g_ret_sts_success

12986: );
12987: END IF;
12988:
12989: IF NOT l_return_status =
12990: okc_api.g_ret_sts_success
12991: THEN
12992: RAISE g_exception_halt_validation;
12993: END IF;
12994:

Line 13181: okc_api.g_ret_sts_success

13177: );
13178: END IF;
13179:
13180: IF NOT l_return_status =
13181: okc_api.g_ret_sts_success
13182: THEN
13183: RAISE g_exception_halt_validation;
13184: END IF;
13185:

Line 13252: p_init_msg_list => okc_api.g_false,

13248: CLOSE l_qa_csr;
13249:
13250: okc_qa_check_pub.execute_qa_check_list
13251: (p_api_version => l_api_version,
13252: p_init_msg_list => okc_api.g_false,
13253: x_return_status => x_return_status,
13254: x_msg_count => x_msg_count,
13255: x_msg_data => x_msg_data,
13256: p_qcl_id => l_qcl_id,

Line 13276: okc_api.g_ret_sts_success

13272: );
13273: END IF;
13274:
13275: IF x_return_status <>
13276: okc_api.g_ret_sts_success
13277: THEN
13278: RAISE g_exception_halt_validation;
13279: END IF;
13280:

Line 13347: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

13343: /*bugfix for 6882512*/
13344: /*update status in okc_contacts table*/
13345: OKC_CTC_PVT.update_contact_stecode(p_chr_id => l_merge_chr_id,
13346: x_return_status=>l_return_status);
13347: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
13348: RAISE g_exception_halt_validation;
13349: END IF;
13350: /*bugfix for 6882512*/
13351: UPDATE okc_k_lines_b

Line 13431: IF NOT l_return_status = okc_api.g_ret_sts_success

13427: || ')'
13428: );
13429: END IF;
13430:
13431: IF NOT l_return_status = okc_api.g_ret_sts_success
13432: THEN
13433: RAISE g_exception_halt_validation;
13434: END IF;
13435:

Line 13483: IF NOT l_return_status = okc_api.g_ret_sts_success

13479: || ')'
13480: );
13481: END IF;
13482:
13483: IF NOT l_return_status = okc_api.g_ret_sts_success
13484: THEN
13485: RAISE g_exception_halt_validation;
13486: END IF;
13487:

Line 13518: okc_api.g_ret_sts_success

13514: );
13515: END IF;
13516:
13517: IF NOT l_return_status =
13518: okc_api.g_ret_sts_success
13519: THEN
13520: RAISE g_exception_halt_validation;
13521: END IF;
13522:

Line 13555: okc_api.g_ret_sts_success

13551: );
13552: END IF;
13553:
13554: IF NOT l_return_status =
13555: okc_api.g_ret_sts_success
13556: THEN
13557: okc_api.set_message
13558: (g_app_name,
13559: g_required_value,

Line 13557: okc_api.set_message

13553:
13554: IF NOT l_return_status =
13555: okc_api.g_ret_sts_success
13556: THEN
13557: okc_api.set_message
13558: (g_app_name,
13559: g_required_value,
13560: g_col_name_token,
13561: 'Coverage Extn creation error '

Line 13591: IF NOT l_return_status = okc_api.g_ret_sts_success

13587: || ')'
13588: );
13589: END IF;
13590:
13591: IF NOT l_return_status = okc_api.g_ret_sts_success
13592: THEN
13593: RAISE g_exception_halt_validation;
13594: END IF;
13595:

Line 13772: okc_api.g_ret_sts_success

13768: );
13769: END IF;
13770:
13771: IF NOT l_return_status =
13772: okc_api.g_ret_sts_success
13773: THEN
13774: RAISE g_exception_halt_validation;
13775: END IF;
13776:

Line 13801: p_init_msg_list => okc_api.g_false,

13797: CLOSE l_qa_csr;
13798:
13799: okc_qa_check_pub.execute_qa_check_list
13800: (p_api_version => l_api_version,
13801: p_init_msg_list => okc_api.g_false,
13802: x_return_status => x_return_status,
13803: x_msg_count => x_msg_count,
13804: x_msg_data => x_msg_data,
13805: p_qcl_id => l_qcl_id,

Line 13824: IF x_return_status <> okc_api.g_ret_sts_success

13820: || ')'
13821: );
13822: END IF;
13823:
13824: IF x_return_status <> okc_api.g_ret_sts_success
13825: THEN
13826: RAISE g_exception_halt_validation;
13827: END IF;
13828:

Line 13895: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

13891: /*update status in okc_contacts table*/
13892: OKC_CTC_PVT.update_contact_stecode(p_chr_id => l_chr_id,
13893: x_return_status=>l_return_status);
13894:
13895: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
13896: RAISE g_exception_halt_validation;
13897: /*bugfix for 6882512*/ END IF;
13898:
13899: UPDATE okc_k_lines_b

Line 14050: IF NOT l_return_status = okc_api.g_ret_sts_success

14046: END IF;
14047:
14048: x_return_status := l_return_status;
14049:
14050: IF NOT l_return_status = okc_api.g_ret_sts_success
14051: THEN
14052: x_return_status := l_return_status;
14053: RAISE g_exception_halt_validation;
14054: END IF;

Line 14101: IF NOT l_return_status = okc_api.g_ret_sts_success

14097: END IF;
14098:
14099: x_return_status := l_return_status;
14100:
14101: IF NOT l_return_status = okc_api.g_ret_sts_success
14102: THEN
14103: x_return_status := l_return_status;
14104: RAISE g_exception_halt_validation;
14105: END IF;

Line 14141: x_return_status := okc_api.g_ret_sts_unexp_error;

14137: x_return_status := l_return_status;
14138: NULL;
14139: WHEN OTHERS
14140: THEN
14141: x_return_status := okc_api.g_ret_sts_unexp_error;
14142: okc_api.set_message (g_app_name,
14143: g_unexpected_error,
14144: g_sqlcode_token,
14145: SQLCODE,

Line 14142: okc_api.set_message (g_app_name,

14138: NULL;
14139: WHEN OTHERS
14140: THEN
14141: x_return_status := okc_api.g_ret_sts_unexp_error;
14142: okc_api.set_message (g_app_name,
14143: g_unexpected_error,
14144: g_sqlcode_token,
14145: SQLCODE,
14146: g_sqlerrm_token,

Line 14214: l_return_status VARCHAR2 (5) := okc_api.g_ret_sts_success;

14210: l_salescredit_tbl_hdr oks_extwarprgm_pvt.salescredit_tbl;
14211: l_line_rec k_line_service_rec_type;
14212: l_covd_rec k_line_covered_level_rec_type;
14213: l_available_yn CHAR;
14214: l_return_status VARCHAR2 (5) := okc_api.g_ret_sts_success;
14215: l_chrid NUMBER := NULL;
14216: l_lineid NUMBER := NULL;
14217: l_days NUMBER := 0;
14218: l_day1price NUMBER := 0;

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

14219: l_oldamt NUMBER := 0;
14220: l_ctr NUMBER := 0;
14221: l_terminate_rec okc_terminate_pvt.terminate_in_cle_rec;
14222: l_api_version CONSTANT NUMBER := 1.0;
14223: l_init_msg_list CONSTANT VARCHAR2 (1) := okc_api.g_false;
14224: l_index VARCHAR2 (2000);
14225: l_trmdt DATE;
14226: l_suppress_credit VARCHAR2 (2) := 'N';
14227: l_full_credit VARCHAR2 (2) := 'N';

Line 14240: x_return_status := okc_api.g_ret_sts_success;

14236: l_ptr NUMBER;
14237: l_term_date_flag VARCHAR2 (1);
14238: l_credit_amount VARCHAR2 (50);
14239: BEGIN
14240: x_return_status := okc_api.g_ret_sts_success;
14241:
14242: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
14243: THEN
14244: fnd_log.STRING (fnd_log.level_event,

Line 14266: l_return_status := okc_api.g_ret_sts_error;

14262: );
14263:
14264: IF l_ste_code = 'HOLD'
14265: THEN
14266: l_return_status := okc_api.g_ret_sts_error;
14267:
14268: IF fnd_log.level_error >= fnd_log.g_current_runtime_level
14269: THEN
14270: fnd_log.STRING (fnd_log.level_error,

Line 14277: okc_api.set_message (g_app_name,

14273: 'Contract in QA_HOLD status'
14274: );
14275: END IF;
14276:
14277: okc_api.set_message (g_app_name,
14278: g_invalid_value,
14279: g_col_name_token,
14280: 'Termination not allowed .Contract '
14281: || p_kdtl_tbl (l_ctr).contract_number

Line 14402: IF NOT l_return_status = okc_api.g_ret_sts_success

14398: || ')'
14399: );
14400: END IF;
14401:
14402: IF NOT l_return_status = okc_api.g_ret_sts_success
14403: THEN
14404: RAISE g_exception_halt_validation;
14405: END IF;
14406:

Line 14434: p_restricted_update => okc_api.g_true,

14430:
14431: okc_contract_pub.update_contract_line
14432: (p_api_version => l_api_version,
14433: p_init_msg_list => l_init_msg_list,
14434: p_restricted_update => okc_api.g_true,
14435: x_return_status => l_return_status,
14436: x_msg_count => x_msg_count,
14437: x_msg_data => x_msg_data,
14438: p_clev_tbl => l_clev_tbl_in,

Line 14454: IF NOT l_return_status = okc_api.g_ret_sts_success

14450: || ')'
14451: );
14452: END IF;
14453:
14454: IF NOT l_return_status = okc_api.g_ret_sts_success
14455: THEN
14456: RAISE g_exception_halt_validation;
14457: END IF;
14458: END IF;

Line 14484: p_restricted_update => okc_api.g_true,

14480:
14481: okc_contract_pub.update_contract_header
14482: (p_api_version => l_api_version,
14483: p_init_msg_list => l_init_msg_list,
14484: p_restricted_update => okc_api.g_true,
14485: x_return_status => l_return_status,
14486: x_msg_count => x_msg_count,
14487: x_msg_data => x_msg_data,
14488: p_chrv_tbl => l_chrv_tbl_in,

Line 14505: IF NOT l_return_status = okc_api.g_ret_sts_success

14501: || ')'
14502: );
14503: END IF;
14504:
14505: IF NOT l_return_status = okc_api.g_ret_sts_success
14506: THEN
14507: RAISE g_exception_halt_validation;
14508: END IF;
14509: END IF;

Line 14551: IF NOT l_return_status = okc_api.g_ret_sts_success

14547: || ')'
14548: );
14549: END IF;
14550:
14551: IF NOT l_return_status = okc_api.g_ret_sts_success
14552: THEN
14553: RAISE g_exception_halt_validation;
14554: END IF;
14555:

Line 14601: IF NOT l_return_status = okc_api.g_ret_sts_success

14597: || ')'
14598: );
14599: END IF;
14600:
14601: IF NOT l_return_status = okc_api.g_ret_sts_success
14602: THEN
14603: RAISE g_exception_halt_validation;
14604: END IF;
14605: END IF;

Line 14649: IF NOT l_return_status = okc_api.g_ret_sts_success

14645: || ')'
14646: );
14647: END IF;
14648:
14649: IF NOT l_return_status = okc_api.g_ret_sts_success
14650: THEN
14651: RAISE g_exception_halt_validation;
14652: END IF;
14653: END IF;

Line 14798: IF NOT l_return_status = okc_api.g_ret_sts_success

14794: END IF;
14795:
14796: x_return_status := l_return_status;
14797:
14798: IF NOT l_return_status = okc_api.g_ret_sts_success
14799: THEN
14800: x_return_status := l_return_status;
14801: RAISE g_exception_halt_validation;
14802: END IF;

Line 14831: IF NOT l_return_status = okc_api.g_ret_sts_success

14827: END IF;
14828:
14829: x_return_status := l_return_status;
14830:
14831: IF NOT l_return_status = okc_api.g_ret_sts_success
14832: THEN
14833: x_return_status := l_return_status;
14834: RAISE g_exception_halt_validation;
14835: END IF;

Line 14859: x_return_status := okc_api.g_ret_sts_unexp_error;

14855: x_return_status := l_return_status;
14856: NULL;
14857: WHEN OTHERS
14858: THEN
14859: x_return_status := okc_api.g_ret_sts_unexp_error;
14860: okc_api.set_message (g_app_name,
14861: g_unexpected_error,
14862: g_sqlcode_token,
14863: SQLCODE,

Line 14860: okc_api.set_message (g_app_name,

14856: NULL;
14857: WHEN OTHERS
14858: THEN
14859: x_return_status := okc_api.g_ret_sts_unexp_error;
14860: okc_api.set_message (g_app_name,
14861: g_unexpected_error,
14862: g_sqlcode_token,
14863: SQLCODE,
14864: g_sqlerrm_token,

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

14973: l_topline_rec l_topline_dates%ROWTYPE;
14974: l_duration NUMBER;
14975: l_timeunits VARCHAR2 (25);
14976: l_api_version CONSTANT NUMBER := 1.0;
14977: l_init_msg_list CONSTANT VARCHAR2 (1) := okc_api.g_false;
14978: l_available_yn VARCHAR2 (2);
14979: l_index VARCHAR2 (2000);
14980: l_return_status VARCHAR2 (1) := 'S';
14981: --l_kdtl_tbl oks_extwar_util_pvt.contract_tbl_type;

Line 15011: x_return_status := okc_api.g_ret_sts_success;

15007: l_invoice_text VARCHAR2 (2000);
15008: l_klnv_tbl_in oks_kln_pvt.klnv_tbl_type;
15009: l_klnv_tbl_out oks_kln_pvt.klnv_tbl_type;
15010: BEGIN
15011: x_return_status := okc_api.g_ret_sts_success;
15012:
15013: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
15014: THEN
15015: fnd_log.STRING (fnd_log.level_event,

Line 15035: l_return_status := okc_api.g_ret_sts_warning;

15031: );
15032:
15033: IF p_kdtl_tbl (l_ctr).installation_date IS NULL
15034: THEN
15035: l_return_status := okc_api.g_ret_sts_warning;
15036:
15037: IF fnd_log.level_error >= fnd_log.g_current_runtime_level
15038: THEN
15039: fnd_log.STRING (fnd_log.level_error,

Line 15045: okc_api.set_message (g_app_name, 'OKS_NULL_INSTALLATION_DATE');

15041: 'Installation date changed to null '
15042: );
15043: END IF;
15044:
15045: okc_api.set_message (g_app_name, 'OKS_NULL_INSTALLATION_DATE');
15046: RAISE g_exception_halt_validation;
15047: END IF;
15048:
15049: l_inst_dtls_tbl.DELETE;

Line 15165: l_return_status := okc_api.g_ret_sts_warning;

15161: IF l_checksr_csr%FOUND
15162: THEN
15163: CLOSE l_checksr_csr;
15164:
15165: l_return_status := okc_api.g_ret_sts_warning;
15166:
15167: IF fnd_log.level_error >= fnd_log.g_current_runtime_level
15168: THEN
15169: fnd_log.STRING (fnd_log.level_error,

Line 15178: okc_api.set_message (g_app_name, 'OKS_SR_EXISTS');

15174: || l_return_status
15175: );
15176: END IF;
15177:
15178: okc_api.set_message (g_app_name, 'OKS_SR_EXISTS');
15179: RAISE g_exception_halt_validation;
15180: ELSE
15181: CLOSE l_checksr_csr;
15182:

Line 15310: IF NOT l_return_status = okc_api.g_ret_sts_success

15306: || ')'
15307: );
15308: END IF;
15309:
15310: IF NOT l_return_status = okc_api.g_ret_sts_success
15311: THEN
15312: RAISE g_exception_halt_validation;
15313: END IF;
15314: END IF; --hdrflag

Line 15359: IF NOT l_return_status = okc_api.g_ret_sts_success

15355: || ')'
15356: );
15357: END IF;
15358:
15359: IF NOT l_return_status = okc_api.g_ret_sts_success
15360: THEN
15361: RAISE g_exception_halt_validation;
15362: END IF;
15363:

Line 15421: okc_api.set_message (g_app_name,

15417: END IF;
15418:
15419: IF NOT l_return_status = 'S'
15420: THEN
15421: okc_api.set_message (g_app_name,
15422: g_required_value,
15423: g_col_name_token,
15424: 'OKS Contract COV LINE'
15425: );

Line 15454: IF NOT l_return_status = okc_api.g_ret_sts_success

15450: || ')'
15451: );
15452: END IF;
15453:
15454: IF NOT l_return_status = okc_api.g_ret_sts_success
15455: THEN
15456: RAISE g_exception_halt_validation;
15457: END IF;
15458:

Line 15483: IF NOT l_return_status = okc_api.g_ret_sts_success

15479: || ')'
15480: );
15481: END IF;
15482:
15483: IF NOT l_return_status = okc_api.g_ret_sts_success
15484: THEN
15485: RAISE g_exception_halt_validation;
15486: END IF;
15487: END IF; --topflag

Line 15526: IF NOT l_return_status = okc_api.g_ret_sts_success

15522: || ')'
15523: );
15524: END IF;
15525:
15526: IF NOT l_return_status = okc_api.g_ret_sts_success
15527: THEN
15528: RAISE g_exception_halt_validation;
15529: END IF;
15530:

Line 15577: okc_api.set_message (g_app_name,

15573: END IF;
15574:
15575: IF NOT l_return_status = 'S'
15576: THEN
15577: okc_api.set_message (g_app_name,
15578: g_required_value,
15579: g_col_name_token,
15580: 'OKS Contract COV LINE'
15581: );

Line 15699: IF NOT l_return_status = okc_api.g_ret_sts_success

15695: END IF;
15696:
15697: x_return_status := l_return_status;
15698:
15699: IF NOT l_return_status = okc_api.g_ret_sts_success
15700: THEN
15701: x_return_status := l_return_status;
15702: RAISE g_exception_halt_validation;
15703: END IF;

Line 15732: IF NOT l_return_status = okc_api.g_ret_sts_success

15728: END IF;
15729:
15730: x_return_status := l_return_status;
15731:
15732: IF NOT l_return_status = okc_api.g_ret_sts_success
15733: THEN
15734: x_return_status := l_return_status;
15735: RAISE g_exception_halt_validation;
15736: END IF;

Line 15765: x_return_status := okc_api.g_ret_sts_unexp_error;

15761: x_return_status := l_return_status;
15762: NULL;
15763: WHEN OTHERS
15764: THEN
15765: x_return_status := okc_api.g_ret_sts_unexp_error;
15766: okc_api.set_message (g_app_name,
15767: g_unexpected_error,
15768: g_sqlcode_token,
15769: SQLCODE,

Line 15766: okc_api.set_message (g_app_name,

15762: NULL;
15763: WHEN OTHERS
15764: THEN
15765: x_return_status := okc_api.g_ret_sts_unexp_error;
15766: okc_api.set_message (g_app_name,
15767: g_unexpected_error,
15768: g_sqlcode_token,
15769: SQLCODE,
15770: g_sqlerrm_token,

Line 15833: l_return_status VARCHAR2 (5) := okc_api.g_ret_sts_success;

15829: l_line_rec k_line_service_rec_type;
15830: l_covd_rec k_line_covered_level_rec_type;
15831: -- l_kdtl_tbl OKS_EXTWAR_UTIL_PVT.Contract_tbl_type;
15832: l_available_yn VARCHAR2 (1);
15833: l_return_status VARCHAR2 (5) := okc_api.g_ret_sts_success;
15834: l_chrid NUMBER := NULL;
15835: l_lineid NUMBER := NULL;
15836: l_cust_rec l_cust_csr%ROWTYPE;
15837: l_terminate_rec okc_terminate_pvt.terminate_in_cle_rec;

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

15835: l_lineid NUMBER := NULL;
15836: l_cust_rec l_cust_csr%ROWTYPE;
15837: l_terminate_rec okc_terminate_pvt.terminate_in_cle_rec;
15838: l_api_version CONSTANT NUMBER := 1.0;
15839: l_init_msg_list CONSTANT VARCHAR2 (1) := okc_api.g_false;
15840: l_ste_code VARCHAR2 (40);
15841: l_sts_code VARCHAR2 (40);
15842: l_billed_amount NUMBER;
15843: l_update_top_line VARCHAR2 (1);

Line 15888: x_return_status := okc_api.g_ret_sts_success;

15884: l_update_id NUMBER;
15885: l_source_line_id NUMBER;
15886: l_create_oper_instance VARCHAR2 (1);
15887: BEGIN
15888: x_return_status := okc_api.g_ret_sts_success;
15889: l_old_cp_id := 0;
15890: l_target_chr_id := 0;
15891:
15892: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

Line 16071: IF l_return_status <> okc_api.g_ret_sts_success

16067: || ')'
16068: );
16069: END IF;
16070:
16071: IF l_return_status <> okc_api.g_ret_sts_success
16072: THEN
16073: RAISE g_exception_halt_validation;
16074: END IF;
16075:

Line 16099: IF l_return_status <> okc_api.g_ret_sts_success

16095: || ')'
16096: );
16097: END IF;
16098:
16099: IF l_return_status <> okc_api.g_ret_sts_success
16100: THEN
16101: okc_api.set_message (g_app_name,
16102: g_required_value,
16103: g_col_name_token,

Line 16101: okc_api.set_message (g_app_name,

16097: END IF;
16098:
16099: IF l_return_status <> okc_api.g_ret_sts_success
16100: THEN
16101: okc_api.set_message (g_app_name,
16102: g_required_value,
16103: g_col_name_token,
16104: 'Sched Billing Rule (LINE)'
16105: );

Line 16240: l_return_status := okc_api.g_ret_sts_error;

16236: );
16237:
16238: IF l_ste_code = 'HOLD'
16239: THEN
16240: l_return_status := okc_api.g_ret_sts_error;
16241:
16242: IF fnd_log.level_error >=
16243: fnd_log.g_current_runtime_level
16244: THEN

Line 16253: okc_api.set_message

16249: ' Contract in QA_HOLD status'
16250: );
16251: END IF;
16252:
16253: okc_api.set_message
16254: (g_app_name,
16255: g_invalid_value,
16256: g_col_name_token,
16257: 'Quantity Update not allowed. Contract '

Line 16298: IF NOT l_return_status = okc_api.g_ret_sts_success

16294: || ')'
16295: );
16296: END IF;
16297:
16298: IF NOT l_return_status = okc_api.g_ret_sts_success
16299: THEN
16300: RAISE g_exception_halt_validation;
16301: END IF;
16302:

Line 16567: IF l_return_status <> okc_api.g_ret_sts_success

16563: || ')'
16564: );
16565: END IF;
16566:
16567: IF l_return_status <> okc_api.g_ret_sts_success
16568: THEN
16569: RAISE g_exception_halt_validation;
16570: END IF;
16571:

Line 16724: IF l_return_status <> okc_api.g_ret_sts_success

16720: || ')'
16721: );
16722: END IF;
16723:
16724: IF l_return_status <> okc_api.g_ret_sts_success
16725: THEN
16726: okc_api.set_message
16727: (g_app_name,
16728: g_required_value,

Line 16726: okc_api.set_message

16722: END IF;
16723:
16724: IF l_return_status <> okc_api.g_ret_sts_success
16725: THEN
16726: okc_api.set_message
16727: (g_app_name,
16728: g_required_value,
16729: g_col_name_token,
16730: 'Sched Billing Rule (LINE)'

Line 16774: IF l_return_status <> okc_api.g_ret_sts_success

16770: || ')'
16771: );
16772: END IF;
16773:
16774: IF l_return_status <> okc_api.g_ret_sts_success
16775: THEN
16776: RAISE g_exception_halt_validation;
16777: END IF;
16778:

Line 16879: IF l_return_status <> okc_api.g_ret_sts_success

16875: || ')'
16876: );
16877: END IF;
16878:
16879: IF l_return_status <> okc_api.g_ret_sts_success
16880: THEN
16881: okc_api.set_message
16882: (g_app_name,
16883: g_required_value,

Line 16881: okc_api.set_message

16877: END IF;
16878:
16879: IF l_return_status <> okc_api.g_ret_sts_success
16880: THEN
16881: okc_api.set_message
16882: (g_app_name,
16883: g_required_value,
16884: g_col_name_token,
16885: 'Sched Billing Rule (LINE)'

Line 17018: IF NOT l_return_status = okc_api.g_ret_sts_success

17014: END IF;
17015:
17016: x_return_status := l_return_status;
17017:
17018: IF NOT l_return_status = okc_api.g_ret_sts_success
17019: THEN
17020: x_return_status := l_return_status;
17021: RAISE g_exception_halt_validation;
17022: END IF;

Line 17057: IF NOT l_return_status = okc_api.g_ret_sts_success

17053: END IF;
17054:
17055: x_return_status := l_return_status;
17056:
17057: IF NOT l_return_status = okc_api.g_ret_sts_success
17058: THEN
17059: x_return_status := l_return_status;
17060: RAISE g_exception_halt_validation;
17061: END IF;

Line 17078: x_return_status := okc_api.g_ret_sts_unexp_error;

17074: x_return_status := l_return_status;
17075: NULL;
17076: WHEN OTHERS
17077: THEN
17078: x_return_status := okc_api.g_ret_sts_unexp_error;
17079: okc_api.set_message (g_app_name,
17080: g_unexpected_error,
17081: g_sqlcode_token,
17082: SQLCODE,

Line 17079: okc_api.set_message (g_app_name,

17075: NULL;
17076: WHEN OTHERS
17077: THEN
17078: x_return_status := okc_api.g_ret_sts_unexp_error;
17079: okc_api.set_message (g_app_name,
17080: g_unexpected_error,
17081: g_sqlcode_token,
17082: SQLCODE,
17083: g_sqlerrm_token,

Line 17187: p_init_msg_list => okc_api.g_false,

17183: END IF;
17184:
17185: jtf_terr_assign_pub.get_winners
17186: (p_api_version_number => 1.0,
17187: p_init_msg_list => okc_api.g_false,
17188: p_use_type => l_use_type,
17189: p_source_id => -1500,
17190: p_trans_id => -1501,
17191: p_trans_rec => l_gen_bulk_rec,