DBA Data[Home] [Help]

APPS.OKS_REPRICE_PVT dependencies on OKC_API

Line 27: := okc_api.g_ret_sts_success;

23: l_kln_rec_in oks_contract_line_pub.klnv_rec_type;
24: l_kln_rec_out oks_contract_line_pub.klnv_rec_type;
25: l_k_det_rec oks_qp_int_pvt.k_details_rec;
26: l_return_status VARCHAR2 (1)
27: := okc_api.g_ret_sts_success;
28: l_msg_count NUMBER;
29: l_msg_data VARCHAR2 (2000);
30: l_price_uom oks_k_headers_b.price_uom%TYPE;
31: invalid_uom_exception EXCEPTION;

Line 97: IF l_return_status <> okc_api.g_ret_sts_success THEN

93: x_klnv_rec => l_kln_rec_out,
94: p_validate_yn => 'N'
95: );
96:
97: IF l_return_status <> okc_api.g_ret_sts_success THEN
98: RAISE g_error;
99: END IF;
100: END LOOP;
101:

Line 130: OKC_API.SET_MESSAGE(p_app_name => 'OKS',

126: );
127: END IF;
128:
129: x_return_status := g_ret_sts_unexp_error;
130: OKC_API.SET_MESSAGE(p_app_name => 'OKS',
131: p_msg_name => 'OKS_INVD_UOM_CODE',
132: p_token1 => 'OKS_API_NAME',
133: p_token1_value => 'oks_reprice_pvt.update_price_uom',
134: p_token2 => 'UOM_CODE',

Line 151: okc_api.set_message (p_app_name => g_app_name_oks,

147: END IF;
148:
149: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
150: x_return_status := g_ret_sts_unexp_error;
151: okc_api.set_message (p_app_name => g_app_name_oks,
152: p_msg_name => g_unexpected_error,
153: p_token1 => g_sqlcode_token,
154: p_token1_value => SQLCODE,
155: p_token2 => g_sqlerrm_token,

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

615: l_chrv_rec okc_contract_pub.chrv_rec_type
616: := p_chrv_rec;
617: x_chrv_rec okc_contract_pub.chrv_rec_type;
618: l_api_version NUMBER := 1.0;
619: l_init_msg_list VARCHAR2 (1) := okc_api.g_false;
620: l_return_status VARCHAR2 (1)
621: := okc_api.g_ret_sts_success;
622: l_msg_count NUMBER;
623: l_msg_data VARCHAR2 (2000);

Line 621: := okc_api.g_ret_sts_success;

617: x_chrv_rec okc_contract_pub.chrv_rec_type;
618: l_api_version NUMBER := 1.0;
619: l_init_msg_list VARCHAR2 (1) := okc_api.g_false;
620: l_return_status VARCHAR2 (1)
621: := okc_api.g_ret_sts_success;
622: l_msg_count NUMBER;
623: l_msg_data VARCHAR2 (2000);
624: BEGIN
625: -- start debug log

Line 695: okc_api.set_message (p_app_name => g_app_name_oks,

691: END IF;
692:
693: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
694: x_return_status := g_ret_sts_unexp_error;
695: okc_api.set_message (p_app_name => g_app_name_oks,
696: p_msg_name => g_unexpected_error,
697: p_token1 => g_sqlcode_token,
698: p_token1_value => SQLCODE,
699: p_token2 => g_sqlerrm_token,

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

709: l_clev_rec okc_contract_pub.clev_rec_type
710: := p_clev_rec;
711: x_clev_rec okc_contract_pub.clev_rec_type;
712: l_api_version NUMBER := 1.0;
713: l_init_msg_list VARCHAR2 (1) := okc_api.g_false;
714: l_return_status VARCHAR2 (1)
715: := okc_api.g_ret_sts_success;
716: l_msg_count NUMBER;
717: l_msg_data VARCHAR2 (2000);

Line 715: := okc_api.g_ret_sts_success;

711: x_clev_rec okc_contract_pub.clev_rec_type;
712: l_api_version NUMBER := 1.0;
713: l_init_msg_list VARCHAR2 (1) := okc_api.g_false;
714: l_return_status VARCHAR2 (1)
715: := okc_api.g_ret_sts_success;
716: l_msg_count NUMBER;
717: l_msg_data VARCHAR2 (2000);
718: BEGIN
719: -- start debug log

Line 788: okc_api.set_message (p_app_name => g_app_name_oks,

784: END IF;
785:
786: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
787: x_return_status := g_ret_sts_unexp_error;
788: okc_api.set_message (p_app_name => g_app_name_oks,
789: p_msg_name => g_unexpected_error,
790: p_token1 => g_sqlcode_token,
791: p_token1_value => SQLCODE,
792: p_token2 => g_sqlerrm_token,

Line 1041: okc_api.set_message (p_app_name => g_app_name_oks,

1037: END IF;
1038:
1039: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1040: x_return_status := g_ret_sts_unexp_error;
1041: okc_api.set_message (p_app_name => g_app_name_oks,
1042: p_msg_name => g_unexpected_error,
1043: p_token1 => g_sqlcode_token,
1044: p_token1_value => SQLCODE,
1045: p_token2 => g_sqlerrm_token,

Line 1087: p_init_msg_list => okc_api.g_true,

1083: x_return_status := g_ret_sts_success;
1084:
1085: l_rail_rec.amount := p_amount;
1086: oks_tax_util_pvt.get_tax (p_api_version => 1.0,
1087: p_init_msg_list => okc_api.g_true,
1088: p_chr_id => p_chr_id,
1089: p_cle_id => p_cle_id,
1090: px_rail_rec => l_rail_rec,
1091: x_msg_count => l_msg_count,

Line 1233: okc_api.set_message (p_app_name => g_app_name_oks,

1229: END IF;
1230:
1231: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1232: x_return_status := g_ret_sts_unexp_error;
1233: okc_api.set_message (p_app_name => g_app_name_oks,
1234: p_msg_name => g_unexpected_error,
1235: p_token1 => g_sqlcode_token,
1236: p_token1_value => SQLCODE,
1237: p_token2 => g_sqlerrm_token,

Line 1397: okc_api.set_message (p_app_name => g_app_name_oks,

1393: END IF;
1394:
1395: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1396: x_return_status := g_ret_sts_unexp_error;
1397: okc_api.set_message (p_app_name => g_app_name_oks,
1398: p_msg_name => g_unexpected_error,
1399: p_token1 => g_sqlcode_token,
1400: p_token1_value => SQLCODE,
1401: p_token2 => g_sqlerrm_token,

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

1447: l_price_break_details oks_qp_pkg.g_price_break_tbl_type;
1448: l_scev_rec_in oks_subscr_elems_pub.scev_rec_type;
1449: l_scev_rec_out oks_subscr_elems_pub.scev_rec_type;
1450: l_api_version NUMBER := 1.0;
1451: l_init_msg_list VARCHAR2 (1) := okc_api.g_false;
1452: l_return_status VARCHAR2 (1) := g_ret_sts_success;
1453: l_msg_count NUMBER;
1454: l_msg_data VARCHAR2 (2000);
1455: BEGIN

Line 1795: okc_api.set_message (p_app_name => g_app_name_oks,

1791: END IF;
1792:
1793: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1794: x_return_status := g_ret_sts_unexp_error;
1795: okc_api.set_message (p_app_name => g_app_name_oks,
1796: p_msg_name => g_unexpected_error,
1797: p_token1 => g_sqlcode_token,
1798: p_token1_value => SQLCODE,
1799: p_token2 => g_sqlerrm_token,

Line 1836: okc_api.set_message (g_app_name_oks,

1832: );
1833: END IF;
1834:
1835: IF p_id_type IS NULL THEN
1836: okc_api.set_message (g_app_name_oks,
1837: g_required_value,
1838: g_col_name_token,
1839: 'P_Id_Type'
1840: );

Line 1911: okc_api.set_message (p_app_name => g_app_name_oks,

1907: );
1908: END IF;
1909:
1910: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1911: okc_api.set_message (p_app_name => g_app_name_oks,
1912: p_msg_name => g_unexpected_error,
1913: p_token1 => g_sqlcode_token,
1914: p_token1_value => SQLCODE,
1915: p_token2 => g_sqlerrm_token,

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

2022: l_price_details oks_qp_pkg.price_details := NULL;
2023: l_modifier_details qp_preq_grp.line_detail_tbl_type;
2024: l_price_break_details oks_qp_pkg.g_price_break_tbl_type;
2025: l_api_version NUMBER := 1.0;
2026: l_init_msg_list VARCHAR2 (1) := okc_api.g_false;
2027: l_return_status VARCHAR2 (1) := g_ret_sts_success;
2028: l_msg_count NUMBER;
2029: l_msg_data VARCHAR2 (2000);
2030: l_clev_rec okc_contract_pub.clev_rec_type;

Line 2203: IF l_return_status <> okc_api.g_ret_sts_success THEN

2199:
2200: END IF; -- l_period_type IS NOT NULL
2201:
2202:
2203: IF l_return_status <> okc_api.g_ret_sts_success THEN
2204: RAISE g_error;
2205: END IF;
2206:
2207: --End new logic for Partial Periods

Line 2902: okc_api.set_message (p_app_name => g_app_name_oks,

2898: END IF;
2899:
2900: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2901: DBMS_TRANSACTION.rollback_savepoint ('REPRICE_OKS');
2902: okc_api.set_message (p_app_name => g_app_name_oks,
2903: p_msg_name => g_unexpected_error,
2904: p_token1 => g_sqlcode_token,
2905: p_token1_value => SQLCODE,
2906: p_token2 => g_sqlerrm_token,

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

3002: l_msg_data VARCHAR2 (2000);
3003: l_usage_type VARCHAR2 (10);
3004: l_currency VARCHAR2 (15);
3005: l_intent VARCHAR2 (10);
3006: l_init_msg_list VARCHAR2 (1) := okc_api.g_false;
3007: l_return_status VARCHAR2 (1) := g_ret_sts_success;
3008: l_old_start_date DATE;
3009: l_old_end_date DATE;
3010: l_clev_rec okc_contract_pub.clev_rec_type;

Line 3774: okc_api.set_message (p_app_name => g_app_name_oks,

3770: );
3771: END IF;
3772:
3773: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3774: okc_api.set_message (p_app_name => g_app_name_oks,
3775: p_msg_name => g_unexpected_error,
3776: p_token1 => g_sqlcode_token,
3777: p_token1_value => SQLCODE,
3778: p_token2 => g_sqlerrm_token,