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.OKL_SETUPOVDTEMPLATES_PVT dependencies on OKL_API

Line 24: NVL(LAST_UPDATE_LOGIN, Okl_Api.G_MISS_NUM) LAST_UPDATE_LOGIN

20: CREATED_BY,
21: CREATION_DATE,
22: LAST_UPDATED_BY,
23: LAST_UPDATE_DATE,
24: NVL(LAST_UPDATE_LOGIN, Okl_Api.G_MISS_NUM) LAST_UPDATE_LOGIN
25: FROM Okl_Ovd_Rul_Tmls_V
26: WHERE Okl_Ovd_Rul_Tmls_V.id = p_id;
27: l_okl_ovtv_pk okl_ovtv_pk_csr%ROWTYPE;
28: l_ovtv_rec ovtv_rec_type;

Line 30: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

26: WHERE Okl_Ovd_Rul_Tmls_V.id = p_id;
27: l_okl_ovtv_pk okl_ovtv_pk_csr%ROWTYPE;
28: l_ovtv_rec ovtv_rec_type;
29: BEGIN
30: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
31: x_no_data_found := TRUE;
32:
33: -- Get current database values
34: OPEN okl_ovtv_pk_csr (p_ovtv_rec.id);

Line 52: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,

48: x_ovtv_rec := l_ovtv_rec;
49: EXCEPTION
50: WHEN OTHERS THEN
51: -- store SQL error message on message stack
52: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
53: p_msg_name => G_UNEXPECTED_ERROR,
54: p_token1 => G_SQLCODE_TOKEN,
55: p_token1_value => SQLCODE,
56: p_token2 => G_SQLERRM_TOKEN,

Line 59: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

55: p_token1_value => SQLCODE,
56: p_token2 => G_SQLERRM_TOKEN,
57: p_token2_value => SQLERRM);
58: -- notify UNEXPECTED error for calling API.
59: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
60:
61: IF (okl_ovtv_pk_csr%ISOPEN) THEN
62: CLOSE okl_ovtv_pk_csr;
63: END IF;

Line 80: IF p_context_org <> Okl_Api.G_MISS_NUM AND

76: p_context_asset_book IN VARCHAR2
77: ) RETURN VARCHAR2 IS
78: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
79: BEGIN
80: IF p_context_org <> Okl_Api.G_MISS_NUM AND
81: p_org_id <> p_context_org THEN
82: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
83: p_msg_name => G_CONTEXT_MISMATCH,
84: p_token1 => G_CONTEXT_TOKEN,

Line 82: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,

78: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
79: BEGIN
80: IF p_context_org <> Okl_Api.G_MISS_NUM AND
81: p_org_id <> p_context_org THEN
82: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
83: p_msg_name => G_CONTEXT_MISMATCH,
84: p_token1 => G_CONTEXT_TOKEN,
85: p_token1_value => 'Context_Org_Id');
86: l_return_status := Okl_Api.G_RET_STS_ERROR;

Line 86: l_return_status := Okl_Api.G_RET_STS_ERROR;

82: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
83: p_msg_name => G_CONTEXT_MISMATCH,
84: p_token1 => G_CONTEXT_TOKEN,
85: p_token1_value => 'Context_Org_Id');
86: l_return_status := Okl_Api.G_RET_STS_ERROR;
87: RETURN(l_return_status);
88: END IF;
89: IF p_context_inv_org <> Okl_Api.G_MISS_NUM AND
90: p_inv_org_id <> p_context_inv_org THEN

Line 89: IF p_context_inv_org <> Okl_Api.G_MISS_NUM AND

85: p_token1_value => 'Context_Org_Id');
86: l_return_status := Okl_Api.G_RET_STS_ERROR;
87: RETURN(l_return_status);
88: END IF;
89: IF p_context_inv_org <> Okl_Api.G_MISS_NUM AND
90: p_inv_org_id <> p_context_inv_org THEN
91: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
92: p_msg_name => G_CONTEXT_MISMATCH,
93: p_token1 => G_CONTEXT_TOKEN,

Line 91: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,

87: RETURN(l_return_status);
88: END IF;
89: IF p_context_inv_org <> Okl_Api.G_MISS_NUM AND
90: p_inv_org_id <> p_context_inv_org THEN
91: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
92: p_msg_name => G_CONTEXT_MISMATCH,
93: p_token1 => G_CONTEXT_TOKEN,
94: p_token1_value => 'Context_Inv_Org_Id');
95: l_return_status := Okl_Api.G_RET_STS_ERROR;

Line 95: l_return_status := Okl_Api.G_RET_STS_ERROR;

91: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
92: p_msg_name => G_CONTEXT_MISMATCH,
93: p_token1 => G_CONTEXT_TOKEN,
94: p_token1_value => 'Context_Inv_Org_Id');
95: l_return_status := Okl_Api.G_RET_STS_ERROR;
96: RETURN(l_return_status);
97: END IF;
98: IF p_context_asset_book <> Okl_Api.G_MISS_CHAR AND
99: p_book_type_code <> p_context_asset_book THEN

Line 98: IF p_context_asset_book <> Okl_Api.G_MISS_CHAR AND

94: p_token1_value => 'Context_Inv_Org_Id');
95: l_return_status := Okl_Api.G_RET_STS_ERROR;
96: RETURN(l_return_status);
97: END IF;
98: IF p_context_asset_book <> Okl_Api.G_MISS_CHAR AND
99: p_book_type_code <> p_context_asset_book THEN
100: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
101: p_msg_name => G_CONTEXT_MISMATCH,
102: p_token1 => G_CONTEXT_TOKEN,

Line 100: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,

96: RETURN(l_return_status);
97: END IF;
98: IF p_context_asset_book <> Okl_Api.G_MISS_CHAR AND
99: p_book_type_code <> p_context_asset_book THEN
100: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
101: p_msg_name => G_CONTEXT_MISMATCH,
102: p_token1 => G_CONTEXT_TOKEN,
103: p_token1_value => 'Context_Book_Type_Code');
104: l_return_status := Okl_Api.G_RET_STS_ERROR;

Line 104: l_return_status := Okl_Api.G_RET_STS_ERROR;

100: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
101: p_msg_name => G_CONTEXT_MISMATCH,
102: p_token1 => G_CONTEXT_TOKEN,
103: p_token1_value => 'Context_Book_Type_Code');
104: l_return_status := Okl_Api.G_RET_STS_ERROR;
105: RETURN(l_return_status);
106: END IF;
107: RETURN(l_return_status);
108: END verify_context;

Line 137: NVL(ovd.CONTEXT_INTENT, Okl_Api.G_MISS_CHAR) CONTEXT_INTENT,

133: CURSOR okl_ovt_lsr_fk_csr (p_ovd_id IN Okl_Opv_Rules_V.ID%TYPE
134: ) IS
135: SELECT orl.RGR_RGD_CODE RGR_RGD_CODE,
136: orl.RGR_RDF_CODE RGR_RDF_CODE,
137: NVL(ovd.CONTEXT_INTENT, Okl_Api.G_MISS_CHAR) CONTEXT_INTENT,
138: NVL(ovd.CONTEXT_ORG, Okl_Api.G_MISS_NUM) CONTEXT_ORG,
139: NVL(ovd.CONTEXT_INV_ORG, Okl_Api.G_MISS_NUM) CONTEXT_INV_ORG,
140: NVL(ovd.CONTEXT_ASSET_BOOK, Okl_Api.G_MISS_CHAR) CONTEXT_ASSET_BOOK,
141: ove.FROM_DATE FROM_DATE,

Line 138: NVL(ovd.CONTEXT_ORG, Okl_Api.G_MISS_NUM) CONTEXT_ORG,

134: ) IS
135: SELECT orl.RGR_RGD_CODE RGR_RGD_CODE,
136: orl.RGR_RDF_CODE RGR_RDF_CODE,
137: NVL(ovd.CONTEXT_INTENT, Okl_Api.G_MISS_CHAR) CONTEXT_INTENT,
138: NVL(ovd.CONTEXT_ORG, Okl_Api.G_MISS_NUM) CONTEXT_ORG,
139: NVL(ovd.CONTEXT_INV_ORG, Okl_Api.G_MISS_NUM) CONTEXT_INV_ORG,
140: NVL(ovd.CONTEXT_ASSET_BOOK, Okl_Api.G_MISS_CHAR) CONTEXT_ASSET_BOOK,
141: ove.FROM_DATE FROM_DATE,
142: NVL(ove.TO_DATE, Okl_Api.G_MISS_DATE) TO_DATE

Line 139: NVL(ovd.CONTEXT_INV_ORG, Okl_Api.G_MISS_NUM) CONTEXT_INV_ORG,

135: SELECT orl.RGR_RGD_CODE RGR_RGD_CODE,
136: orl.RGR_RDF_CODE RGR_RDF_CODE,
137: NVL(ovd.CONTEXT_INTENT, Okl_Api.G_MISS_CHAR) CONTEXT_INTENT,
138: NVL(ovd.CONTEXT_ORG, Okl_Api.G_MISS_NUM) CONTEXT_ORG,
139: NVL(ovd.CONTEXT_INV_ORG, Okl_Api.G_MISS_NUM) CONTEXT_INV_ORG,
140: NVL(ovd.CONTEXT_ASSET_BOOK, Okl_Api.G_MISS_CHAR) CONTEXT_ASSET_BOOK,
141: ove.FROM_DATE FROM_DATE,
142: NVL(ove.TO_DATE, Okl_Api.G_MISS_DATE) TO_DATE
143: FROM Okl_Opv_Rules_V ovd,

Line 140: NVL(ovd.CONTEXT_ASSET_BOOK, Okl_Api.G_MISS_CHAR) CONTEXT_ASSET_BOOK,

136: orl.RGR_RDF_CODE RGR_RDF_CODE,
137: NVL(ovd.CONTEXT_INTENT, Okl_Api.G_MISS_CHAR) CONTEXT_INTENT,
138: NVL(ovd.CONTEXT_ORG, Okl_Api.G_MISS_NUM) CONTEXT_ORG,
139: NVL(ovd.CONTEXT_INV_ORG, Okl_Api.G_MISS_NUM) CONTEXT_INV_ORG,
140: NVL(ovd.CONTEXT_ASSET_BOOK, Okl_Api.G_MISS_CHAR) CONTEXT_ASSET_BOOK,
141: ove.FROM_DATE FROM_DATE,
142: NVL(ove.TO_DATE, Okl_Api.G_MISS_DATE) TO_DATE
143: FROM Okl_Opv_Rules_V ovd,
144: Okl_Opt_Rules_V orl,

Line 142: NVL(ove.TO_DATE, Okl_Api.G_MISS_DATE) TO_DATE

138: NVL(ovd.CONTEXT_ORG, Okl_Api.G_MISS_NUM) CONTEXT_ORG,
139: NVL(ovd.CONTEXT_INV_ORG, Okl_Api.G_MISS_NUM) CONTEXT_INV_ORG,
140: NVL(ovd.CONTEXT_ASSET_BOOK, Okl_Api.G_MISS_CHAR) CONTEXT_ASSET_BOOK,
141: ove.FROM_DATE FROM_DATE,
142: NVL(ove.TO_DATE, Okl_Api.G_MISS_DATE) TO_DATE
143: FROM Okl_Opv_Rules_V ovd,
144: Okl_Opt_Rules_V orl,
145: Okl_Opt_Values_V ove
146: WHERE ovd.ID = p_ovd_id

Line 166: NVL(rds.END_DATE, Okl_Api.G_MISS_DATE) < p_to_date);

162: AND rds.OBJECT_ID_NUMBER = p_object_id_number
163: AND rds.JTOT_OBJECT_CODE = p_jtot_object_code
164: AND rds.BUY_OR_SELL = p_buy_or_sell
165: AND (rds.START_DATE > p_from_date OR
166: NVL(rds.END_DATE, Okl_Api.G_MISS_DATE) < p_to_date);
167:
168: l_check VARCHAR2(1) := '?';
169: l_sysdate DATE := to_date(to_char(SYSDATE, 'DD/MM/YYYY') , 'DD/MM/YYYY');
170: l_row_not_found BOOLEAN := FALSE;

Line 189: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

185: l_okx_end_date DATE;
186: l_rulv_disp_rec rulv_disp_rec_type;
187: BEGIN
188: x_valid := TRUE;
189: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
190:
191: -- Check if the option value is already in use with a contract
192: OPEN okl_ovt_csp_fk_csr (p_ovtv_rec.ovd_id);
193: FETCH okl_ovt_csp_fk_csr INTO l_check;

Line 198: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,

194: l_row_not_found := okl_ovt_csp_fk_csr%NOTFOUND;
195: CLOSE okl_ovt_csp_fk_csr;
196:
197: IF l_row_not_found = FALSE THEN
198: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
199: p_msg_name => G_IN_USE,
200: p_token1 => G_PARENT_TABLE_TOKEN,
201: p_token1_value => 'Okl_Ovd_Rul_Tmls_V',
202: p_token2 => G_CHILD_TABLE_TOKEN,

Line 205: x_return_status := Okl_Api.G_RET_STS_ERROR;

201: p_token1_value => 'Okl_Ovd_Rul_Tmls_V',
202: p_token2 => G_CHILD_TABLE_TOKEN,
203: p_token2_value => 'Okl_Slctd_Optns_V');
204: x_valid := FALSE;
205: x_return_status := Okl_Api.G_RET_STS_ERROR;
206: RAISE G_EXCEPTION_HALT_PROCESSING;
207: END IF;
208:
209: IF p_ovtv_rec.id = Okl_Api.G_MISS_NUM THEN

Line 209: IF p_ovtv_rec.id = Okl_Api.G_MISS_NUM THEN

205: x_return_status := Okl_Api.G_RET_STS_ERROR;
206: RAISE G_EXCEPTION_HALT_PROCESSING;
207: END IF;
208:
209: IF p_ovtv_rec.id = Okl_Api.G_MISS_NUM THEN
210: l_rulv_rec.id := p_ovtv_rec.rul_id;
211: Okl_Setupoptvalues_Pvt.get_rul_rec (p_rulv_rec => l_rulv_rec,
212: x_return_status => l_return_status,
213: x_no_data_found => l_no_data_found,

Line 215: IF l_return_status <> Okl_Api.G_RET_STS_SUCCESS OR

211: Okl_Setupoptvalues_Pvt.get_rul_rec (p_rulv_rec => l_rulv_rec,
212: x_return_status => l_return_status,
213: x_no_data_found => l_no_data_found,
214: x_rulv_rec => l_rulv_rec);
215: IF l_return_status <> Okl_Api.G_RET_STS_SUCCESS OR
216: l_no_data_found = TRUE THEN
217: x_valid := FALSE;
218: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
219: RAISE G_EXCEPTION_HALT_PROCESSING;

Line 218: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

214: x_rulv_rec => l_rulv_rec);
215: IF l_return_status <> Okl_Api.G_RET_STS_SUCCESS OR
216: l_no_data_found = TRUE THEN
217: x_valid := FALSE;
218: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
219: RAISE G_EXCEPTION_HALT_PROCESSING;
220: END IF;
221:
222: Okl_Rule_Apis_Pvt.get_rule_disp_value(p_api_version => p_api_version,

Line 229: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN

225: x_return_status => l_return_status,
226: x_msg_count => x_msg_count,
227: x_msg_data => x_msg_data,
228: x_rulv_disp_rec => l_rulv_disp_rec);
229: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
230: x_valid := FALSE;
231: x_return_status := Okl_Api.G_RET_STS_ERROR;
232: RAISE G_EXCEPTION_HALT_PROCESSING;
233: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

Line 231: x_return_status := Okl_Api.G_RET_STS_ERROR;

227: x_msg_data => x_msg_data,
228: x_rulv_disp_rec => l_rulv_disp_rec);
229: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
230: x_valid := FALSE;
231: x_return_status := Okl_Api.G_RET_STS_ERROR;
232: RAISE G_EXCEPTION_HALT_PROCESSING;
233: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
234: x_valid := FALSE;
235: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

Line 233: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

229: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
230: x_valid := FALSE;
231: x_return_status := Okl_Api.G_RET_STS_ERROR;
232: RAISE G_EXCEPTION_HALT_PROCESSING;
233: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
234: x_valid := FALSE;
235: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
236: RAISE G_EXCEPTION_HALT_PROCESSING;
237: END IF;

Line 235: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

231: x_return_status := Okl_Api.G_RET_STS_ERROR;
232: RAISE G_EXCEPTION_HALT_PROCESSING;
233: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
234: x_valid := FALSE;
235: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
236: RAISE G_EXCEPTION_HALT_PROCESSING;
237: END IF;
238:
239: -- Fetch all the details for the option value rule for which this

Line 255: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,

251: l_row_not_found := okl_ovt_lsr_fk_csr%NOTFOUND;
252: CLOSE okl_ovt_lsr_fk_csr;
253:
254: IF l_row_not_found = TRUE THEN
255: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
256: p_msg_name => G_MISS_DATA);
257: x_valid := FALSE;
258: x_return_status := Okl_Api.G_RET_STS_ERROR;
259: RAISE G_EXCEPTION_HALT_PROCESSING;

Line 258: x_return_status := Okl_Api.G_RET_STS_ERROR;

254: IF l_row_not_found = TRUE THEN
255: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
256: p_msg_name => G_MISS_DATA);
257: x_valid := FALSE;
258: x_return_status := Okl_Api.G_RET_STS_ERROR;
259: RAISE G_EXCEPTION_HALT_PROCESSING;
260: END IF;
261:
262: --IF l_rulv_rec.rule_information_category <> l_rule OR

Line 266: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,

262: --IF l_rulv_rec.rule_information_category <> l_rule OR
263: --l_rulv_rec.template_yn <> 'Y' THEN
264:
265: IF l_rulv_rec.rule_information_category <> l_rule THEN
266: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
267: p_msg_name => G_RULE_MISMATCH);
268: x_valid := FALSE;
269: x_return_status := Okl_Api.G_RET_STS_ERROR;
270: RAISE G_EXCEPTION_HALT_PROCESSING;

Line 269: x_return_status := Okl_Api.G_RET_STS_ERROR;

265: IF l_rulv_rec.rule_information_category <> l_rule THEN
266: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
267: p_msg_name => G_RULE_MISMATCH);
268: x_valid := FALSE;
269: x_return_status := Okl_Api.G_RET_STS_ERROR;
270: RAISE G_EXCEPTION_HALT_PROCESSING;
271: END IF;
272:
273: --END IF;

Line 277: l_jtot_object_code := Okl_Api.G_MISS_CHAR;

273: --END IF;
274:
275: FOR l_object_id_number IN 1..3
276: LOOP
277: l_jtot_object_code := Okl_Api.G_MISS_CHAR;
278: l_okx_start_date := Okl_Api.G_MISS_DATE;
279: l_okx_end_date := Okl_Api.G_MISS_DATE;
280: IF l_object_id_number = 1 AND l_rulv_rec.jtot_object1_code <> Okl_Api.G_MISS_CHAR THEN
281: l_jtot_object_code := l_rulv_rec.jtot_object1_code;

Line 278: l_okx_start_date := Okl_Api.G_MISS_DATE;

274:
275: FOR l_object_id_number IN 1..3
276: LOOP
277: l_jtot_object_code := Okl_Api.G_MISS_CHAR;
278: l_okx_start_date := Okl_Api.G_MISS_DATE;
279: l_okx_end_date := Okl_Api.G_MISS_DATE;
280: IF l_object_id_number = 1 AND l_rulv_rec.jtot_object1_code <> Okl_Api.G_MISS_CHAR THEN
281: l_jtot_object_code := l_rulv_rec.jtot_object1_code;
282: l_okx_start_date := l_rulv_disp_rec.obj1_start_date;

Line 279: l_okx_end_date := Okl_Api.G_MISS_DATE;

275: FOR l_object_id_number IN 1..3
276: LOOP
277: l_jtot_object_code := Okl_Api.G_MISS_CHAR;
278: l_okx_start_date := Okl_Api.G_MISS_DATE;
279: l_okx_end_date := Okl_Api.G_MISS_DATE;
280: IF l_object_id_number = 1 AND l_rulv_rec.jtot_object1_code <> Okl_Api.G_MISS_CHAR THEN
281: l_jtot_object_code := l_rulv_rec.jtot_object1_code;
282: l_okx_start_date := l_rulv_disp_rec.obj1_start_date;
283: l_okx_end_date := l_rulv_disp_rec.obj1_end_date;

Line 280: IF l_object_id_number = 1 AND l_rulv_rec.jtot_object1_code <> Okl_Api.G_MISS_CHAR THEN

276: LOOP
277: l_jtot_object_code := Okl_Api.G_MISS_CHAR;
278: l_okx_start_date := Okl_Api.G_MISS_DATE;
279: l_okx_end_date := Okl_Api.G_MISS_DATE;
280: IF l_object_id_number = 1 AND l_rulv_rec.jtot_object1_code <> Okl_Api.G_MISS_CHAR THEN
281: l_jtot_object_code := l_rulv_rec.jtot_object1_code;
282: l_okx_start_date := l_rulv_disp_rec.obj1_start_date;
283: l_okx_end_date := l_rulv_disp_rec.obj1_end_date;
284: l_return_status := verify_context(p_org_id => l_rulv_disp_rec.obj1_org_id,

Line 290: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN

286: p_book_type_code => l_rulv_disp_rec.obj1_book_type_code,
287: p_context_org => l_context_org,
288: p_context_inv_org => l_context_inv_org,
289: p_context_asset_book => l_context_asset_book);
290: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
291: x_valid := FALSE;
292: x_return_status := Okl_Api.G_RET_STS_ERROR;
293: RAISE G_EXCEPTION_HALT_PROCESSING;
294: END IF;

Line 292: x_return_status := Okl_Api.G_RET_STS_ERROR;

288: p_context_inv_org => l_context_inv_org,
289: p_context_asset_book => l_context_asset_book);
290: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
291: x_valid := FALSE;
292: x_return_status := Okl_Api.G_RET_STS_ERROR;
293: RAISE G_EXCEPTION_HALT_PROCESSING;
294: END IF;
295: ELSIF l_object_id_number = 2 AND l_rulv_rec.jtot_object2_code <> Okl_Api.G_MISS_CHAR THEN
296: l_jtot_object_code := l_rulv_rec.jtot_object2_code;

Line 295: ELSIF l_object_id_number = 2 AND l_rulv_rec.jtot_object2_code <> Okl_Api.G_MISS_CHAR THEN

291: x_valid := FALSE;
292: x_return_status := Okl_Api.G_RET_STS_ERROR;
293: RAISE G_EXCEPTION_HALT_PROCESSING;
294: END IF;
295: ELSIF l_object_id_number = 2 AND l_rulv_rec.jtot_object2_code <> Okl_Api.G_MISS_CHAR THEN
296: l_jtot_object_code := l_rulv_rec.jtot_object2_code;
297: l_okx_start_date := l_rulv_disp_rec.obj2_start_date;
298: l_okx_end_date := l_rulv_disp_rec.obj2_end_date;
299: l_return_status := verify_context(p_org_id => l_rulv_disp_rec.obj2_org_id,

Line 305: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN

301: p_book_type_code => l_rulv_disp_rec.obj2_book_type_code,
302: p_context_org => l_context_org,
303: p_context_inv_org => l_context_inv_org,
304: p_context_asset_book => l_context_asset_book);
305: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
306: x_valid := FALSE;
307: x_return_status := Okl_Api.G_RET_STS_ERROR;
308: RAISE G_EXCEPTION_HALT_PROCESSING;
309: END IF;

Line 307: x_return_status := Okl_Api.G_RET_STS_ERROR;

303: p_context_inv_org => l_context_inv_org,
304: p_context_asset_book => l_context_asset_book);
305: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
306: x_valid := FALSE;
307: x_return_status := Okl_Api.G_RET_STS_ERROR;
308: RAISE G_EXCEPTION_HALT_PROCESSING;
309: END IF;
310: ELSIF l_object_id_number = 3 AND l_rulv_rec.jtot_object3_code <> Okl_Api.G_MISS_CHAR THEN
311: l_jtot_object_code := l_rulv_rec.jtot_object3_code;

Line 310: ELSIF l_object_id_number = 3 AND l_rulv_rec.jtot_object3_code <> Okl_Api.G_MISS_CHAR THEN

306: x_valid := FALSE;
307: x_return_status := Okl_Api.G_RET_STS_ERROR;
308: RAISE G_EXCEPTION_HALT_PROCESSING;
309: END IF;
310: ELSIF l_object_id_number = 3 AND l_rulv_rec.jtot_object3_code <> Okl_Api.G_MISS_CHAR THEN
311: l_jtot_object_code := l_rulv_rec.jtot_object3_code;
312: l_okx_start_date := l_rulv_disp_rec.obj3_start_date;
313: l_okx_end_date := l_rulv_disp_rec.obj3_end_date;
314: l_return_status := verify_context(p_org_id => l_rulv_disp_rec.obj3_org_id,

Line 320: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN

316: p_book_type_code => l_rulv_disp_rec.obj3_book_type_code,
317: p_context_org => l_context_org,
318: p_context_inv_org => l_context_inv_org,
319: p_context_asset_book => l_context_asset_book);
320: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
321: x_valid := FALSE;
322: x_return_status := Okl_Api.G_RET_STS_ERROR;
323: RAISE G_EXCEPTION_HALT_PROCESSING;
324: END IF;

Line 322: x_return_status := Okl_Api.G_RET_STS_ERROR;

318: p_context_inv_org => l_context_inv_org,
319: p_context_asset_book => l_context_asset_book);
320: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
321: x_valid := FALSE;
322: x_return_status := Okl_Api.G_RET_STS_ERROR;
323: RAISE G_EXCEPTION_HALT_PROCESSING;
324: END IF;
325: END IF;
326:

Line 327: IF l_jtot_object_code <> Okl_Api.G_MISS_CHAR AND

323: RAISE G_EXCEPTION_HALT_PROCESSING;
324: END IF;
325: END IF;
326:
327: IF l_jtot_object_code <> Okl_Api.G_MISS_CHAR AND
328: (l_okx_start_date > l_from_date OR
329: NVL(l_okx_end_date, Okl_Api.G_MISS_DATE) < l_to_date OR
330: l_from_date > l_to_date) THEN
331: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,

Line 329: NVL(l_okx_end_date, Okl_Api.G_MISS_DATE) < l_to_date OR

325: END IF;
326:
327: IF l_jtot_object_code <> Okl_Api.G_MISS_CHAR AND
328: (l_okx_start_date > l_from_date OR
329: NVL(l_okx_end_date, Okl_Api.G_MISS_DATE) < l_to_date OR
330: l_from_date > l_to_date) THEN
331: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
332: p_msg_name => G_DATES_MISMATCH,
333: p_token1 => G_PARENT_TABLE_TOKEN,

Line 331: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,

327: IF l_jtot_object_code <> Okl_Api.G_MISS_CHAR AND
328: (l_okx_start_date > l_from_date OR
329: NVL(l_okx_end_date, Okl_Api.G_MISS_DATE) < l_to_date OR
330: l_from_date > l_to_date) THEN
331: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
332: p_msg_name => G_DATES_MISMATCH,
333: p_token1 => G_PARENT_TABLE_TOKEN,
334: p_token1_value => 'Okl_Opt_Values_V',
335: p_token2 => G_CHILD_TABLE_TOKEN,

Line 338: x_return_status := Okl_Api.G_RET_STS_ERROR;

334: p_token1_value => 'Okl_Opt_Values_V',
335: p_token2 => G_CHILD_TABLE_TOKEN,
336: p_token2_value => 'Okc_Rules_b');
337: x_valid := FALSE;
338: x_return_status := Okl_Api.G_RET_STS_ERROR;
339: RAISE G_EXCEPTION_HALT_PROCESSING;
340: END IF;
341:
342: IF l_jtot_object_code <> Okl_Api.G_MISS_CHAR THEN

Line 342: IF l_jtot_object_code <> Okl_Api.G_MISS_CHAR THEN

338: x_return_status := Okl_Api.G_RET_STS_ERROR;
339: RAISE G_EXCEPTION_HALT_PROCESSING;
340: END IF;
341:
342: IF l_jtot_object_code <> Okl_Api.G_MISS_CHAR THEN
343: -- Check for dates in source, okx and option value
344: OPEN okl_ovt_rds_fk_csr (p_rgd_code => l_rulegroup,
345: p_rdf_code => l_rule,
346: p_buy_or_sell => l_context_intent,

Line 356: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,

352: l_no_data_found := okl_ovt_rds_fk_csr%NOTFOUND;
353: CLOSE okl_ovt_rds_fk_csr;
354:
355: IF l_no_data_found = FALSE THEN
356: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
357: p_msg_name => G_DATES_MISMATCH,
358: p_token1 => G_PARENT_TABLE_TOKEN,
359: p_token1_value => 'Okl_Ovd_Rul_Tmls_V',
360: p_token2 => G_CHILD_TABLE_TOKEN,

Line 363: x_return_status := Okl_Api.G_RET_STS_ERROR;

359: p_token1_value => 'Okl_Ovd_Rul_Tmls_V',
360: p_token2 => G_CHILD_TABLE_TOKEN,
361: p_token2_value => 'Okc_Rule_Def_Sources_V');
362: x_valid := FALSE;
363: x_return_status := Okl_Api.G_RET_STS_ERROR;
364: RAISE G_EXCEPTION_HALT_PROCESSING;
365: END IF;
366: END IF;
367:

Line 379: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,

375: NULL;
376:
377: WHEN OTHERS THEN
378: -- store SQL error message on message stack
379: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
380: p_msg_name => G_UNEXPECTED_ERROR,
381: p_token1 => G_SQLCODE_TOKEN,
382: p_token1_value => SQLCODE,
383: p_token2 => G_SQLERRM_TOKEN,

Line 386: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

382: p_token1_value => SQLCODE,
383: p_token2 => G_SQLERRM_TOKEN,
384: p_token2_value => SQLERRM);
385: x_valid := FALSE;
386: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
387:
388: IF (okl_ovt_csp_fk_csr%ISOPEN) THEN
389: CLOSE okl_ovt_csp_fk_csr;
390: END IF;

Line 406: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

402: ---------------------------------------------------------------------------
403: -- PROCEDURE insert_ovdtemplates for: OKL_OVD_RUL_TMLS_V
404: ---------------------------------------------------------------------------
405: PROCEDURE insert_ovdtemplates(p_api_version IN NUMBER,
406: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
407: x_return_status OUT NOCOPY VARCHAR2,
408: x_msg_count OUT NOCOPY NUMBER,
409: x_msg_data OUT NOCOPY VARCHAR2,
410: p_optv_rec IN optv_rec_type,

Line 447: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

443: x_msg_count => x_msg_count,
444: x_msg_data => x_msg_data,
445: x_valid => l_valid);
446:
447: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
448: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
449: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) OR
450: (l_return_status = Okl_Api.G_RET_STS_SUCCESS AND
451: l_valid <> TRUE) THEN

Line 449: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) OR

445: x_valid => l_valid);
446:
447: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
448: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
449: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) OR
450: (l_return_status = Okl_Api.G_RET_STS_SUCCESS AND
451: l_valid <> TRUE) THEN
452: x_return_status := Okl_Api.G_RET_STS_ERROR;
453: RAISE Okc_Api.G_EXCEPTION_ERROR;

Line 450: (l_return_status = Okl_Api.G_RET_STS_SUCCESS AND

446:
447: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
448: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
449: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) OR
450: (l_return_status = Okl_Api.G_RET_STS_SUCCESS AND
451: l_valid <> TRUE) THEN
452: x_return_status := Okl_Api.G_RET_STS_ERROR;
453: RAISE Okc_Api.G_EXCEPTION_ERROR;
454: END IF;

Line 452: x_return_status := Okl_Api.G_RET_STS_ERROR;

448: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
449: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) OR
450: (l_return_status = Okl_Api.G_RET_STS_SUCCESS AND
451: l_valid <> TRUE) THEN
452: x_return_status := Okl_Api.G_RET_STS_ERROR;
453: RAISE Okc_Api.G_EXCEPTION_ERROR;
454: END IF;
455:
456: /* public api to insert option value rule templates */

Line 503: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

499: -- PROCEDURE delete_ovdtemplates for: OKL_OVD_RUL_TMLS_V
500: -- This allows the user to delete table of records
501: ---------------------------------------------------------------------------
502: PROCEDURE delete_ovdtemplates(p_api_version IN NUMBER,
503: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
504: x_return_status OUT NOCOPY VARCHAR2,
505: x_msg_count OUT NOCOPY NUMBER,
506: x_msg_data OUT NOCOPY VARCHAR2,
507: p_optv_rec IN optv_rec_type,

Line 551: IF l_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

547: x_msg_count => x_msg_count,
548: x_msg_data => x_msg_data,
549: x_valid => l_valid);
550: -- store the highest degree of error
551: IF l_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
552: IF l_overall_status <> Okl_Api.G_RET_STS_UNEXP_ERROR THEN
553: l_overall_status := l_return_status;
554: END IF;
555: END IF;

Line 552: IF l_overall_status <> Okl_Api.G_RET_STS_UNEXP_ERROR THEN

548: x_msg_data => x_msg_data,
549: x_valid => l_valid);
550: -- store the highest degree of error
551: IF l_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
552: IF l_overall_status <> Okl_Api.G_RET_STS_UNEXP_ERROR THEN
553: l_overall_status := l_return_status;
554: END IF;
555: END IF;
556:

Line 564: IF l_return_status <> Okl_Api.G_RET_STS_SUCCESS OR

560: x_return_status => l_return_status,
561: x_no_data_found => l_no_data_found,
562: x_ovtv_rec => l_db_ovtv_rec);
563:
564: IF l_return_status <> Okl_Api.G_RET_STS_SUCCESS OR
565: l_no_data_found = TRUE THEN
566: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
567: END IF;
568:

Line 566: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

562: x_ovtv_rec => l_db_ovtv_rec);
563:
564: IF l_return_status <> Okl_Api.G_RET_STS_SUCCESS OR
565: l_no_data_found = TRUE THEN
566: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
567: END IF;
568:
569: l_rulv_tbl(i).id := l_db_ovtv_rec.rul_id;
570:

Line 580: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

576: ,p_rulv_rec => l_rulv_tbl(i)
577: );
578:
579: -- TCHGS: Store the highest degree of error
580: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
581: IF l_overall_status <> Okl_Api.G_RET_STS_UNEXP_ERROR THEN
582: l_overall_status := x_return_status;
583: END IF;
584: END IF;

Line 581: IF l_overall_status <> Okl_Api.G_RET_STS_UNEXP_ERROR THEN

577: );
578:
579: -- TCHGS: Store the highest degree of error
580: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
581: IF l_overall_status <> Okl_Api.G_RET_STS_UNEXP_ERROR THEN
582: l_overall_status := x_return_status;
583: END IF;
584: END IF;
585:

Line 594: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

590: END LOOP;
591: -- return overall status
592: l_return_status := l_overall_status;
593: END IF;
594: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
595: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
596: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) OR
597: (l_return_status = Okl_Api.G_RET_STS_SUCCESS AND
598: l_valid <> TRUE) THEN

Line 596: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) OR

592: l_return_status := l_overall_status;
593: END IF;
594: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
595: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
596: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) OR
597: (l_return_status = Okl_Api.G_RET_STS_SUCCESS AND
598: l_valid <> TRUE) THEN
599: x_return_status := Okl_Api.G_RET_STS_ERROR;
600: RAISE Okc_Api.G_EXCEPTION_ERROR;

Line 597: (l_return_status = Okl_Api.G_RET_STS_SUCCESS AND

593: END IF;
594: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
595: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
596: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) OR
597: (l_return_status = Okl_Api.G_RET_STS_SUCCESS AND
598: l_valid <> TRUE) THEN
599: x_return_status := Okl_Api.G_RET_STS_ERROR;
600: RAISE Okc_Api.G_EXCEPTION_ERROR;
601: END IF;

Line 599: x_return_status := Okl_Api.G_RET_STS_ERROR;

595: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
596: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) OR
597: (l_return_status = Okl_Api.G_RET_STS_SUCCESS AND
598: l_valid <> TRUE) THEN
599: x_return_status := Okl_Api.G_RET_STS_ERROR;
600: RAISE Okc_Api.G_EXCEPTION_ERROR;
601: END IF;
602:
603: /* public api to delete option value rules */