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.OKC_LINE_STYLES_PVT dependencies on OKC_API

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

27: x_msg_count OUT NOCOPY NUMBER,
28: x_msg_data OUT NOCOPY VARCHAR2,
29: p_lsev_rec IN lsev_rec_type) IS
30:
31: l_return_status VARCHAR2(1):=OKC_API.G_RET_STS_SUCCESS;
32: l_lsev_rec OKC_LINE_STYLES_PUB.lsev_rec_type;
33: lx_lsev_rec OKC_LINE_STYLES_PUB.lsev_rec_type;
34:
35: CURSOR loc_bot_csr (p_id IN NUMBER) is

Line 41: x_return_status :=OKC_API.G_RET_STS_SUCCESS;

37: Connect by prior id = lse_parent_id
38: start with id = p_id;
39:
40: BEGIN
41: x_return_status :=OKC_API.G_RET_STS_SUCCESS;
42: for l_rec in loc_bot_csr(p_lsev_rec.id) loop
43: IF l_rec.priced_yn=G_Yes and l_rec.id<>p_lsev_rec.id then
44: l_lsev_rec.id:=l_rec.id;
45: l_lsev_rec.priced_yn:=G_NO;

Line 54: exit when x_return_status <> OKC_API.G_RET_STS_SUCCESS;

50: x_msg_count,
51: x_msg_data,
52: l_lsev_rec,
53: lx_lsev_rec);
54: exit when x_return_status <> OKC_API.G_RET_STS_SUCCESS;
55: END IF;
56: END LOOP;
57:
58: EXCEPTION

Line 61: OKC_API.set_message(p_app_name => g_app_name,

57:
58: EXCEPTION
59:
60: WHEN OTHERS THEN
61: OKC_API.set_message(p_app_name => g_app_name,
62: p_msg_name => g_unexpected_error,
63: p_token1 => g_sqlcode_token,
64: p_token1_value => sqlcode,
65: p_token2 => g_sqlerrm_token,

Line 67: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

63: p_token1 => g_sqlcode_token,
64: p_token1_value => sqlcode,
65: p_token2 => g_sqlerrm_token,
66: p_token2_value => sqlerrm);
67: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
68:
69: END CHANGE_PRICED_FOR_CHILDREN;
70:
71:

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

77: x_msg_count OUT NOCOPY NUMBER,
78: x_msg_data OUT NOCOPY VARCHAR2,
79: p_lsev_rec IN lsev_rec_type) IS
80:
81: l_return_status VARCHAR2(1):=OKC_API.G_RET_STS_SUCCESS;
82: l_lsev_rec OKC_LINE_STYLES_PUB.lsev_rec_type;
83: lx_lsev_rec OKC_LINE_STYLES_PUB.lsev_rec_type;
84: CURSOR loc_top_csr (p_id IN NUMBER) is
85: select id, priced_yn from okc_line_styles_b

Line 90: x_return_status :=OKC_API.G_RET_STS_SUCCESS;

86: connect by prior lse_parent_id = id
87: start with id = p_id;
88:
89: BEGIN
90: x_return_status :=OKC_API.G_RET_STS_SUCCESS;
91: for l_rec in loc_top_csr(p_lsev_rec.id) loop
92: IF l_rec.priced_yn=G_Yes and l_rec.id<>p_lsev_rec.id then
93: l_lsev_rec.id:=l_rec.id;
94: l_lsev_rec.priced_yn:=G_NO;

Line 103: exit when x_return_status <> OKC_API.G_RET_STS_SUCCESS;

99: x_msg_count,
100: x_msg_data,
101: l_lsev_rec,
102: lx_lsev_rec);
103: exit when x_return_status <> OKC_API.G_RET_STS_SUCCESS;
104: END IF;
105: END LOOP;
106:
107: EXCEPTION

Line 110: OKC_API.set_message(p_app_name => g_app_name,

106:
107: EXCEPTION
108:
109: WHEN OTHERS THEN
110: OKC_API.set_message(p_app_name => g_app_name,
111: p_msg_name => g_unexpected_error,
112: p_token1 => g_sqlcode_token,
113: p_token1_value => sqlcode,
114: p_token2 => g_sqlerrm_token,

Line 116: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

112: p_token1 => g_sqlcode_token,
113: p_token1_value => sqlcode,
114: p_token2 => g_sqlerrm_token,
115: p_token2_value => sqlerrm);
116: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
117:
118: END CHANGE_PRICED_FOR_PARENT;
119:
120:

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

127: x_msg_count OUT NOCOPY NUMBER,
128: x_msg_data OUT NOCOPY VARCHAR2,
129: p_lsev_rec IN lsev_rec_type) IS
130:
131: l_return_status VARCHAR2(1):=OKC_API.G_RET_STS_SUCCESS;
132: l_lsev_rec OKC_LINE_STYLES_PUB.lsev_rec_type;
133: lx_lsev_rec OKC_LINE_STYLES_PUB.lsev_rec_type;
134:
135: CURSOR loc_bot_ip_csr (p_id IN NUMBER) is

Line 141: x_return_status :=OKC_API.G_RET_STS_SUCCESS;

137: Connect by prior id = lse_parent_id
138: start with id = p_id;
139:
140: BEGIN
141: x_return_status :=OKC_API.G_RET_STS_SUCCESS;
142: for l_rec in loc_bot_ip_csr(p_lsev_rec.id) loop
143: IF l_rec.item_to_price_yn=G_Yes and l_rec.id<>p_lsev_rec.id then
144: l_lsev_rec.id:=l_rec.id;
145: l_lsev_rec.item_to_price_yn:=G_NO;

Line 154: exit when x_return_status <> OKC_API.G_RET_STS_SUCCESS;

150: x_msg_count,
151: x_msg_data,
152: l_lsev_rec,
153: lx_lsev_rec);
154: exit when x_return_status <> OKC_API.G_RET_STS_SUCCESS;
155: exit when x_return_status <> OKC_API.G_RET_STS_SUCCESS;
156: END IF;
157: END LOOP;
158:

Line 155: exit when x_return_status <> OKC_API.G_RET_STS_SUCCESS;

151: x_msg_data,
152: l_lsev_rec,
153: lx_lsev_rec);
154: exit when x_return_status <> OKC_API.G_RET_STS_SUCCESS;
155: exit when x_return_status <> OKC_API.G_RET_STS_SUCCESS;
156: END IF;
157: END LOOP;
158:
159: EXCEPTION

Line 162: OKC_API.set_message(p_app_name => g_app_name,

158:
159: EXCEPTION
160:
161: WHEN OTHERS THEN
162: OKC_API.set_message(p_app_name => g_app_name,
163: p_msg_name => g_unexpected_error,
164: p_token1 => g_sqlcode_token,
165: p_token1_value => sqlcode,
166: p_token2 => g_sqlerrm_token,

Line 168: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

164: p_token1 => g_sqlcode_token,
165: p_token1_value => sqlcode,
166: p_token2 => g_sqlerrm_token,
167: p_token2_value => sqlerrm);
168: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
169:
170: END CHANGE_ITEM_TO_PRICE_CHILDREN;
171:
172:

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

178: x_msg_count OUT NOCOPY NUMBER,
179: x_msg_data OUT NOCOPY VARCHAR2,
180: p_lsev_rec IN lsev_rec_type) IS
181:
182: l_return_status VARCHAR2(1):=OKC_API.G_RET_STS_SUCCESS;
183: l_lsev_rec OKC_LINE_STYLES_PUB.lsev_rec_type;
184: lx_lsev_rec OKC_LINE_STYLES_PUB.lsev_rec_type;
185: CURSOR loc_top_ip_csr (p_id IN NUMBER) is
186: select id, item_to_price_yn from okc_line_styles_b

Line 191: x_return_status :=OKC_API.G_RET_STS_SUCCESS;

187: connect by prior lse_parent_id = id
188: start with id = p_id;
189:
190: BEGIN
191: x_return_status :=OKC_API.G_RET_STS_SUCCESS;
192: for l_rec in loc_top_ip_csr(p_lsev_rec.id) loop
193: IF l_rec.item_to_price_yn=G_Yes and l_rec.id<>p_lsev_rec.id then
194: l_lsev_rec.id:=l_rec.id;
195: l_lsev_rec.item_to_price_yn:=G_NO;

Line 204: exit when x_return_status <> OKC_API.G_RET_STS_SUCCESS;

200: x_msg_count,
201: x_msg_data,
202: l_lsev_rec,
203: lx_lsev_rec);
204: exit when x_return_status <> OKC_API.G_RET_STS_SUCCESS;
205: END IF;
206: END LOOP;
207:
208: EXCEPTION

Line 211: OKC_API.set_message(p_app_name => g_app_name,

207:
208: EXCEPTION
209:
210: WHEN OTHERS THEN
211: OKC_API.set_message(p_app_name => g_app_name,
212: p_msg_name => g_unexpected_error,
213: p_token1 => g_sqlcode_token,
214: p_token1_value => sqlcode,
215: p_token2 => g_sqlerrm_token,

Line 217: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

213: p_token1 => g_sqlcode_token,
214: p_token1_value => sqlcode,
215: p_token2 => g_sqlerrm_token,
216: p_token2_value => sqlerrm);
217: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
218:
219: END CHANGE_ITEM_TO_PRICE_PARENT;
220:
221:

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

226: x_msg_count OUT NOCOPY NUMBER,
227: x_msg_data OUT NOCOPY VARCHAR2,
228: p_lsev_rec IN lsev_rec_type) IS
229:
230: l_return_status VARCHAR2(1):=OKC_API.G_RET_STS_SUCCESS;
231: l_lsev_rec OKC_LINE_STYLES_PUB.lsev_rec_type;
232: lx_lsev_rec OKC_LINE_STYLES_PUB.lsev_rec_type;
233:
234: CURSOR loc_bot_pb_csr (p_id IN NUMBER) is

Line 240: x_return_status :=OKC_API.G_RET_STS_SUCCESS;

236: Connect by prior id = lse_parent_id
237: start with id = p_id;
238:
239: BEGIN
240: x_return_status :=OKC_API.G_RET_STS_SUCCESS;
241: for l_rec in loc_bot_pb_csr(p_lsev_rec.id) loop
242: IF l_rec.price_basis_yn = G_Yes and l_rec.id<>p_lsev_rec.id then
243: l_lsev_rec.id:=l_rec.id;
244: l_lsev_rec.price_basis_yn:=G_NO;

Line 253: exit when x_return_status <> OKC_API.G_RET_STS_SUCCESS;

249: x_msg_count,
250: x_msg_data,
251: l_lsev_rec,
252: lx_lsev_rec);
253: exit when x_return_status <> OKC_API.G_RET_STS_SUCCESS;
254: exit when x_return_status <> OKC_API.G_RET_STS_SUCCESS;
255: END IF;
256: END LOOP;
257:

Line 254: exit when x_return_status <> OKC_API.G_RET_STS_SUCCESS;

250: x_msg_data,
251: l_lsev_rec,
252: lx_lsev_rec);
253: exit when x_return_status <> OKC_API.G_RET_STS_SUCCESS;
254: exit when x_return_status <> OKC_API.G_RET_STS_SUCCESS;
255: END IF;
256: END LOOP;
257:
258: EXCEPTION

Line 261: OKC_API.set_message(p_app_name => g_app_name,

257:
258: EXCEPTION
259:
260: WHEN OTHERS THEN
261: OKC_API.set_message(p_app_name => g_app_name,
262: p_msg_name => g_unexpected_error,
263: p_token1 => g_sqlcode_token,
264: p_token1_value => sqlcode,
265: p_token2 => g_sqlerrm_token,

Line 267: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

263: p_token1 => g_sqlcode_token,
264: p_token1_value => sqlcode,
265: p_token2 => g_sqlerrm_token,
266: p_token2_value => sqlerrm);
267: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
268:
269: END CHANGE_PRICE_BASIS_CHILDREN;
270:
271:

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

277: x_msg_count OUT NOCOPY NUMBER,
278: x_msg_data OUT NOCOPY VARCHAR2,
279: p_lsev_rec IN lsev_rec_type) IS
280:
281: l_return_status VARCHAR2(1):=OKC_API.G_RET_STS_SUCCESS;
282: l_lsev_rec OKC_LINE_STYLES_PUB.lsev_rec_type;
283: lx_lsev_rec OKC_LINE_STYLES_PUB.lsev_rec_type;
284: CURSOR loc_top_pb_csr (p_id IN NUMBER) is
285: select id, price_basis_yn from okc_line_styles_b

Line 290: x_return_status :=OKC_API.G_RET_STS_SUCCESS;

286: connect by prior lse_parent_id = id
287: start with id = p_id;
288:
289: BEGIN
290: x_return_status :=OKC_API.G_RET_STS_SUCCESS;
291: for l_rec in loc_top_pb_csr(p_lsev_rec.id) loop
292: IF l_rec.price_basis_yn = G_Yes and l_rec.id<>p_lsev_rec.id then
293: l_lsev_rec.id:=l_rec.id;
294: l_lsev_rec.price_basis_yn :=G_NO;

Line 303: exit when x_return_status <> OKC_API.G_RET_STS_SUCCESS;

299: x_msg_count,
300: x_msg_data,
301: l_lsev_rec,
302: lx_lsev_rec);
303: exit when x_return_status <> OKC_API.G_RET_STS_SUCCESS;
304: END IF;
305: END LOOP;
306:
307: EXCEPTION

Line 310: OKC_API.set_message(p_app_name => g_app_name,

306:
307: EXCEPTION
308:
309: WHEN OTHERS THEN
310: OKC_API.set_message(p_app_name => g_app_name,
311: p_msg_name => g_unexpected_error,
312: p_token1 => g_sqlcode_token,
313: p_token1_value => sqlcode,
314: p_token2 => g_sqlerrm_token,

Line 316: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

312: p_token1 => g_sqlcode_token,
313: p_token1_value => sqlcode,
314: p_token2 => g_sqlerrm_token,
315: p_token2_value => sqlerrm);
316: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
317:
318: END CHANGE_PRICE_BASIS_PARENT;
319:
320:

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

322:
323: FUNCTION USED_IN_K_LINES(p_id IN number)
324: RETURN VARCHAR2 IS
325:
326: l_return_status VARCHAR2(1):=OKC_API.G_RET_STS_SUCCESS;
327:
328: CURSOR c1 (p_id IN NUMBER) is
329: select OKC_API.G_RET_STS_ERROR from okc_k_lines_b where lse_id=p_id;
330:

Line 329: select OKC_API.G_RET_STS_ERROR from okc_k_lines_b where lse_id=p_id;

325:
326: l_return_status VARCHAR2(1):=OKC_API.G_RET_STS_SUCCESS;
327:
328: CURSOR c1 (p_id IN NUMBER) is
329: select OKC_API.G_RET_STS_ERROR from okc_k_lines_b where lse_id=p_id;
330:
331: BEGIN
332: Open c1(p_id);
333: fetch c1 into l_return_status;

Line 340: OKC_API.set_message(p_app_name => g_app_name,

336:
337: EXCEPTION
338:
339: WHEN OTHERS THEN
340: OKC_API.set_message(p_app_name => g_app_name,
341: p_msg_name => g_unexpected_error,
342: p_token1 => g_sqlcode_token,
343: p_token1_value => sqlcode,
344: p_token2 => g_sqlerrm_token,

Line 346: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

342: p_token1 => g_sqlcode_token,
343: p_token1_value => sqlcode,
344: p_token2 => g_sqlerrm_token,
345: p_token2_value => sqlerrm);
346: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
347:
348: END USED_IN_K_LINES;
349:
350: FUNCTION USED_IN_SETUPS(p_id IN number)

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

348: END USED_IN_K_LINES;
349:
350: FUNCTION USED_IN_SETUPS(p_id IN number)
351: RETURN VARCHAR2 IS
352: l_return_status VARCHAR2(1):=OKC_API.G_RET_STS_SUCCESS;
353: l_excp_error EXCEPTION;
354: CURSOR c3 (p_id IN NUMBER) is
355: select OKC_API.G_RET_STS_ERROR from okc_line_style_roles where lse_id=p_id;
356: CURSOR c4 (p_id IN NUMBER) is

Line 355: select OKC_API.G_RET_STS_ERROR from okc_line_style_roles where lse_id=p_id;

351: RETURN VARCHAR2 IS
352: l_return_status VARCHAR2(1):=OKC_API.G_RET_STS_SUCCESS;
353: l_excp_error EXCEPTION;
354: CURSOR c3 (p_id IN NUMBER) is
355: select OKC_API.G_RET_STS_ERROR from okc_line_style_roles where lse_id=p_id;
356: CURSOR c4 (p_id IN NUMBER) is
357: select OKC_API.G_RET_STS_ERROR from okc_lse_rule_groups where lse_id=p_id;
358: CURSOR c5 (p_id IN NUMBER) is
359: select OKC_API.G_RET_STS_ERROR from okc_subclass_top_line where lse_id=p_id;

Line 357: select OKC_API.G_RET_STS_ERROR from okc_lse_rule_groups where lse_id=p_id;

353: l_excp_error EXCEPTION;
354: CURSOR c3 (p_id IN NUMBER) is
355: select OKC_API.G_RET_STS_ERROR from okc_line_style_roles where lse_id=p_id;
356: CURSOR c4 (p_id IN NUMBER) is
357: select OKC_API.G_RET_STS_ERROR from okc_lse_rule_groups where lse_id=p_id;
358: CURSOR c5 (p_id IN NUMBER) is
359: select OKC_API.G_RET_STS_ERROR from okc_subclass_top_line where lse_id=p_id;
360:
361: BEGIN

Line 359: select OKC_API.G_RET_STS_ERROR from okc_subclass_top_line where lse_id=p_id;

355: select OKC_API.G_RET_STS_ERROR from okc_line_style_roles where lse_id=p_id;
356: CURSOR c4 (p_id IN NUMBER) is
357: select OKC_API.G_RET_STS_ERROR from okc_lse_rule_groups where lse_id=p_id;
358: CURSOR c5 (p_id IN NUMBER) is
359: select OKC_API.G_RET_STS_ERROR from okc_subclass_top_line where lse_id=p_id;
360:
361: BEGIN
362: Open c3(p_id);
363: fetch c3 into l_return_status;

Line 365: IF l_return_status=OKC_API.G_RET_STS_ERROR then

361: BEGIN
362: Open c3(p_id);
363: fetch c3 into l_return_status;
364: close c3;
365: IF l_return_status=OKC_API.G_RET_STS_ERROR then
366: raise l_excp_error;
367: END IF;
368: Open c4(p_id);
369: fetch c4 into l_return_status;

Line 371: IF l_return_status=OKC_API.G_RET_STS_ERROR then

367: END IF;
368: Open c4(p_id);
369: fetch c4 into l_return_status;
370: close c4;
371: IF l_return_status=OKC_API.G_RET_STS_ERROR then
372: raise l_excp_error;
373: END IF;
374: Open c5(p_id);
375: fetch c5 into l_return_status;

Line 377: IF l_return_status=OKC_API.G_RET_STS_ERROR then

373: END IF;
374: Open c5(p_id);
375: fetch c5 into l_return_status;
376: close c5;
377: IF l_return_status=OKC_API.G_RET_STS_ERROR then
378: raise l_excp_error;
379: END IF;
380: return l_return_status;
381:

Line 387: OKC_API.set_message(p_app_name => g_app_name,

383:
384: WHEN l_excp_error then
385: return l_return_status;
386: WHEN OTHERS THEN
387: OKC_API.set_message(p_app_name => g_app_name,
388: p_msg_name => g_unexpected_error,
389: p_token1 => g_sqlcode_token,
390: p_token1_value => sqlcode,
391: p_token2 => g_sqlerrm_token,

Line 393: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

389: p_token1 => g_sqlcode_token,
390: p_token1_value => sqlcode,
391: p_token2 => g_sqlerrm_token,
392: p_token2_value => sqlerrm);
393: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
394:
395: END USED_IN_SETUPS;
396:
397:

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

396:
397:
398: FUNCTION USED_IN_SRC_OPS(p_id IN number)
399: RETURN VARCHAR2 IS
400: l_return_status VARCHAR2(1):=OKC_API.G_RET_STS_SUCCESS;
401: l_excp_error EXCEPTION;
402: CURSOR c1 (p_id IN NUMBER) is
403: select OKC_API.G_RET_STS_ERROR from okc_line_style_sources where lse_id=p_id;
404: CURSOR c2 (p_id IN NUMBER) is

Line 403: select OKC_API.G_RET_STS_ERROR from okc_line_style_sources where lse_id=p_id;

399: RETURN VARCHAR2 IS
400: l_return_status VARCHAR2(1):=OKC_API.G_RET_STS_SUCCESS;
401: l_excp_error EXCEPTION;
402: CURSOR c1 (p_id IN NUMBER) is
403: select OKC_API.G_RET_STS_ERROR from okc_line_style_sources where lse_id=p_id;
404: CURSOR c2 (p_id IN NUMBER) is
405: select OKC_API.G_RET_STS_ERROR from okc_val_line_operations where lse_id=p_id;
406:
407: BEGIN

Line 405: select OKC_API.G_RET_STS_ERROR from okc_val_line_operations where lse_id=p_id;

401: l_excp_error EXCEPTION;
402: CURSOR c1 (p_id IN NUMBER) is
403: select OKC_API.G_RET_STS_ERROR from okc_line_style_sources where lse_id=p_id;
404: CURSOR c2 (p_id IN NUMBER) is
405: select OKC_API.G_RET_STS_ERROR from okc_val_line_operations where lse_id=p_id;
406:
407: BEGIN
408: Open c1(p_id);
409: fetch c1 into l_return_status;

Line 411: IF l_return_status=OKC_API.G_RET_STS_ERROR then

407: BEGIN
408: Open c1(p_id);
409: fetch c1 into l_return_status;
410: close c1;
411: IF l_return_status=OKC_API.G_RET_STS_ERROR then
412: raise l_excp_error;
413: END IF;
414: Open c2(p_id);
415: fetch c2 into l_return_status;

Line 417: IF l_return_status=OKC_API.G_RET_STS_ERROR then

413: END IF;
414: Open c2(p_id);
415: fetch c2 into l_return_status;
416: close c2;
417: IF l_return_status=OKC_API.G_RET_STS_ERROR then
418: raise l_excp_error;
419: END IF;
420: return l_return_status;
421:

Line 427: OKC_API.set_message(p_app_name => g_app_name,

423:
424: WHEN l_excp_error then
425: return l_return_status;
426: WHEN OTHERS THEN
427: OKC_API.set_message(p_app_name => g_app_name,
428: p_msg_name => g_unexpected_error,
429: p_token1 => g_sqlcode_token,
430: p_token1_value => sqlcode,
431: p_token2 => g_sqlerrm_token,

Line 433: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

429: p_token1 => g_sqlcode_token,
430: p_token1_value => sqlcode,
431: p_token2 => g_sqlerrm_token,
432: p_token2_value => sqlerrm);
433: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
434:
435: END USED_IN_SRC_OPS;
436:
437:

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

442: x_msg_count OUT NOCOPY NUMBER,
443: x_msg_data OUT NOCOPY VARCHAR2,
444: p_lsev_rec IN lsev_rec_type) IS
445:
446: l_return_status VARCHAR2(1):=OKC_API.G_RET_STS_SUCCESS;
447: l_lsev_rec OKC_LINE_STYLES_PUB.lsev_rec_type;
448: CURSOR c1(p_id IN NUMBER) is
449: select id from okc_line_styles_b where lse_parent_id=p_id;
450:

Line 461: exit when x_return_status <> OKC_API.G_RET_STS_SUCCESS;

457: x_return_status,
458: x_msg_count,
459: x_msg_data,
460: l_lsev_rec);
461: exit when x_return_status <> OKC_API.G_RET_STS_SUCCESS;
462: END LOOP;
463:
464: EXCEPTION
465:

Line 467: OKC_API.set_message(p_app_name => g_app_name,

463:
464: EXCEPTION
465:
466: WHEN OTHERS THEN
467: OKC_API.set_message(p_app_name => g_app_name,
468: p_msg_name => g_unexpected_error,
469: p_token1 => g_sqlcode_token,
470: p_token1_value => sqlcode,
471: p_token2 => g_sqlerrm_token,

Line 473: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

469: p_token1 => g_sqlcode_token,
470: p_token1_value => sqlcode,
471: p_token2 => g_sqlerrm_token,
472: p_token2_value => sqlerrm);
473: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
474:
475: END DELETE_SUB_LINES;
476:
477:

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

482: x_msg_count OUT NOCOPY NUMBER,
483: x_msg_data OUT NOCOPY VARCHAR2,
484: p_lsev_rec IN lsev_rec_type) IS
485:
486: l_return_status VARCHAR2(1):=OKC_API.G_RET_STS_SUCCESS;
487: l_lssv_rec OKC_LINE_STYLES_PUB.lssv_rec_type;
488: CURSOR c1(p_id IN NUMBER) is
489: select lse_id,jtot_object_code from okc_line_style_sources where lse_id=p_id;
490:

Line 502: exit when x_return_status <> OKC_API.G_RET_STS_SUCCESS;

498: x_return_status,
499: x_msg_count,
500: x_msg_data,
501: l_lssv_rec);
502: exit when x_return_status <> OKC_API.G_RET_STS_SUCCESS;
503: END LOOP;
504:
505: EXCEPTION
506:

Line 508: OKC_API.set_message(p_app_name => g_app_name,

504:
505: EXCEPTION
506:
507: WHEN OTHERS THEN
508: OKC_API.set_message(p_app_name => g_app_name,
509: p_msg_name => g_unexpected_error,
510: p_token1 => g_sqlcode_token,
511: p_token1_value => sqlcode,
512: p_token2 => g_sqlerrm_token,

Line 514: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

510: p_token1 => g_sqlcode_token,
511: p_token1_value => sqlcode,
512: p_token2 => g_sqlerrm_token,
513: p_token2_value => sqlerrm);
514: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
515:
516: END DELETE_SOURCES;
517:
518:

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

523: x_msg_count OUT NOCOPY NUMBER,
524: x_msg_data OUT NOCOPY VARCHAR2,
525: p_lsev_rec IN lsev_rec_type) IS
526:
527: l_return_status VARCHAR2(1):=OKC_API.G_RET_STS_SUCCESS;
528: l_vlov_rec OKC_LINE_STYLES_PUB.vlov_rec_type;
529: CURSOR c1(p_id IN NUMBER) is
530: select lse_id from okc_val_line_operations where lse_id=p_id;
531:

Line 542: exit when x_return_status <> OKC_API.G_RET_STS_SUCCESS;

538: x_return_status,
539: x_msg_count,
540: x_msg_data,
541: l_vlov_rec);
542: exit when x_return_status <> OKC_API.G_RET_STS_SUCCESS;
543: END LOOP;
544:
545: EXCEPTION
546:

Line 548: OKC_API.set_message(p_app_name => g_app_name,

544:
545: EXCEPTION
546:
547: WHEN OTHERS THEN
548: OKC_API.set_message(p_app_name => g_app_name,
549: p_msg_name => g_unexpected_error,
550: p_token1 => g_sqlcode_token,
551: p_token1_value => sqlcode,
552: p_token2 => g_sqlerrm_token,

Line 554: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

550: p_token1 => g_sqlcode_token,
551: p_token1_value => sqlcode,
552: p_token2 => g_sqlerrm_token,
553: p_token2_value => sqlerrm);
554: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
555:
556: END DELETE_VAL_OPS;
557:
558:

Line 577: IF x_return_status=OKC_API.G_RET_STS_SUCCESS and x_lsev_rec.priced_yn=G_YES then

573: x_msg_data,
574: p_lsev_rec,
575: x_lsev_rec);
576: --If the new line has priced_yn set to 'Y' then set its parent's to 'N'
577: IF x_return_status=OKC_API.G_RET_STS_SUCCESS and x_lsev_rec.priced_yn=G_YES then
578:
579: CHANGE_PRICED_FOR_PARENT(
580: p_api_version,
581: p_init_msg_list,

Line 588: IF x_return_status=OKC_API.G_RET_STS_SUCCESS and x_lsev_rec.item_to_price_yn=G_YES then

584: x_msg_data,
585: x_lsev_rec);
586: END IF;
587:
588: IF x_return_status=OKC_API.G_RET_STS_SUCCESS and x_lsev_rec.item_to_price_yn=G_YES then
589:
590: CHANGE_ITEM_TO_PRICE_PARENT(
591: p_api_version,
592: p_init_msg_list,

Line 599: IF x_return_status=OKC_API.G_RET_STS_SUCCESS and x_lsev_rec.price_basis_yn=G_YES then

595: x_msg_data,
596: x_lsev_rec);
597: END IF;
598:
599: IF x_return_status=OKC_API.G_RET_STS_SUCCESS and x_lsev_rec.price_basis_yn=G_YES then
600:
601: CHANGE_PRICE_BASIS_PARENT(
602: p_api_version,
603: p_init_msg_list,

Line 612: OKC_API.set_message(p_app_name => g_app_name,

608: END IF;
609: EXCEPTION
610:
611: WHEN OTHERS THEN
612: OKC_API.set_message(p_app_name => g_app_name,
613: p_msg_name => g_unexpected_error,
614: p_token1 => g_sqlcode_token,
615: p_token1_value => sqlcode,
616: p_token2 => g_sqlerrm_token,

Line 618: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

614: p_token1 => g_sqlcode_token,
615: p_token1_value => sqlcode,
616: p_token2 => g_sqlerrm_token,
617: p_token2_value => sqlerrm);
618: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
619:
620: END CREATE_LINE_STYLES;
621:
622: PROCEDURE UPDATE_LINE_STYLES(

Line 633: IF p_lsev_rec.lty_code<>OKC_API.G_MISS_CHAR then

629: x_lsev_rec OUT NOCOPY lsev_rec_type) IS
630: l_excp_error EXCEPTION;
631: l_lsev_rec lsev_rec_type;
632: BEGIN
633: IF p_lsev_rec.lty_code<>OKC_API.G_MISS_CHAR then
634: x_return_status:=USED_IN_K_LINES(p_lsev_rec.id);
635: IF x_return_status=OKC_API.G_RET_STS_ERROR then
636: OKC_API.set_message(p_app_name => g_app_name,
637: p_msg_name =>G_UPD_IN_K);

Line 635: IF x_return_status=OKC_API.G_RET_STS_ERROR then

631: l_lsev_rec lsev_rec_type;
632: BEGIN
633: IF p_lsev_rec.lty_code<>OKC_API.G_MISS_CHAR then
634: x_return_status:=USED_IN_K_LINES(p_lsev_rec.id);
635: IF x_return_status=OKC_API.G_RET_STS_ERROR then
636: OKC_API.set_message(p_app_name => g_app_name,
637: p_msg_name =>G_UPD_IN_K);
638: raise l_excp_error;
639: END IF;

Line 636: OKC_API.set_message(p_app_name => g_app_name,

632: BEGIN
633: IF p_lsev_rec.lty_code<>OKC_API.G_MISS_CHAR then
634: x_return_status:=USED_IN_K_LINES(p_lsev_rec.id);
635: IF x_return_status=OKC_API.G_RET_STS_ERROR then
636: OKC_API.set_message(p_app_name => g_app_name,
637: p_msg_name =>G_UPD_IN_K);
638: raise l_excp_error;
639: END IF;
640:

Line 650: IF x_return_status=OKC_API.G_RET_STS_ERROR then

646: x_msg_count,
647: x_msg_data,
648: p_lsev_rec);
649:
650: IF x_return_status=OKC_API.G_RET_STS_ERROR then
651: raise l_excp_error;
652: END IF;
653: END IF;
654:

Line 665: IF x_return_status=OKC_API.G_RET_STS_SUCCESS and x_lsev_rec.priced_yn=G_YES then

661: x_msg_data,
662: p_lsev_rec,
663: x_lsev_rec);
664: --If the updated line has priced_yn set to 'Y' then set its children's to 'N'
665: IF x_return_status=OKC_API.G_RET_STS_SUCCESS and x_lsev_rec.priced_yn=G_YES then
666: CHANGE_PRICED_FOR_CHILDREN(
667: p_api_version,
668: p_init_msg_list,
669: x_return_status,

Line 683: IF x_return_status=OKC_API.G_RET_STS_SUCCESS and x_lsev_rec.item_to_price_yn=G_YES then

679: x_msg_data,
680: x_lsev_rec);
681: END IF;
682:
683: IF x_return_status=OKC_API.G_RET_STS_SUCCESS and x_lsev_rec.item_to_price_yn=G_YES then
684: CHANGE_ITEM_TO_PRICE_CHILDREN(
685: p_api_version,
686: p_init_msg_list,
687: x_return_status,

Line 701: IF x_return_status=OKC_API.G_RET_STS_SUCCESS and x_lsev_rec.price_basis_yn=G_YES then

697: x_msg_data,
698: x_lsev_rec);
699: END IF;
700:
701: IF x_return_status=OKC_API.G_RET_STS_SUCCESS and x_lsev_rec.price_basis_yn=G_YES then
702: CHANGE_PRICE_BASIS_CHILDREN(
703: p_api_version,
704: p_init_msg_list,
705: x_return_status,

Line 722: x_return_status := OKC_API.G_RET_STS_ERROR;

718:
719:
720: EXCEPTION
721: WHEN l_excp_error then
722: x_return_status := OKC_API.G_RET_STS_ERROR;
723:
724: WHEN OTHERS THEN
725: OKC_API.set_message(p_app_name => g_app_name,
726: p_msg_name => g_unexpected_error,

Line 725: OKC_API.set_message(p_app_name => g_app_name,

721: WHEN l_excp_error then
722: x_return_status := OKC_API.G_RET_STS_ERROR;
723:
724: WHEN OTHERS THEN
725: OKC_API.set_message(p_app_name => g_app_name,
726: p_msg_name => g_unexpected_error,
727: p_token1 => g_sqlcode_token,
728: p_token1_value => sqlcode,
729: p_token2 => g_sqlerrm_token,

Line 731: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

727: p_token1 => g_sqlcode_token,
728: p_token1_value => sqlcode,
729: p_token2 => g_sqlerrm_token,
730: p_token2_value => sqlerrm);
731: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
732:
733: END UPDATE_LINE_STYLES;
734:
735: PROCEDURE DELETE_LINE_STYLES(

Line 746: IF x_return_status=OKC_API.G_RET_STS_ERROR then

742:
743: l_excp_error EXCEPTION;
744: BEGIN
745: x_return_status:=USED_IN_K_LINES(p_lsev_rec.id);
746: IF x_return_status=OKC_API.G_RET_STS_ERROR then
747: OKC_API.set_message(p_app_name => g_app_name,
748: p_msg_name => G_DEL_IN_K);
749: raise l_excp_error;
750: END IF;

Line 747: OKC_API.set_message(p_app_name => g_app_name,

743: l_excp_error EXCEPTION;
744: BEGIN
745: x_return_status:=USED_IN_K_LINES(p_lsev_rec.id);
746: IF x_return_status=OKC_API.G_RET_STS_ERROR then
747: OKC_API.set_message(p_app_name => g_app_name,
748: p_msg_name => G_DEL_IN_K);
749: raise l_excp_error;
750: END IF;
751: x_return_status:=USED_IN_SETUPS(p_lsev_rec.id);

Line 752: IF x_return_status=OKC_API.G_RET_STS_ERROR then

748: p_msg_name => G_DEL_IN_K);
749: raise l_excp_error;
750: END IF;
751: x_return_status:=USED_IN_SETUPS(p_lsev_rec.id);
752: IF x_return_status=OKC_API.G_RET_STS_ERROR then
753: OKC_API.set_message(p_app_name => g_app_name,
754: p_msg_name => G_DEL_IN_S);
755: raise l_excp_error;
756: END IF;

Line 753: OKC_API.set_message(p_app_name => g_app_name,

749: raise l_excp_error;
750: END IF;
751: x_return_status:=USED_IN_SETUPS(p_lsev_rec.id);
752: IF x_return_status=OKC_API.G_RET_STS_ERROR then
753: OKC_API.set_message(p_app_name => g_app_name,
754: p_msg_name => G_DEL_IN_S);
755: raise l_excp_error;
756: END IF;
757:

Line 765: IF x_return_status=OKC_API.G_RET_STS_ERROR then

761: x_return_status,
762: x_msg_count,
763: x_msg_data,
764: p_lsev_rec);
765: IF x_return_status=OKC_API.G_RET_STS_ERROR then
766: raise l_excp_error;
767: END IF;
768:
769: DELETE_VAL_OPS(

Line 777: IF x_return_status=OKC_API.G_RET_STS_ERROR then

773: x_msg_count,
774: x_msg_data,
775: p_lsev_rec);
776:
777: IF x_return_status=OKC_API.G_RET_STS_ERROR then
778: raise l_excp_error;
779: END IF;
780:
781: DELETE_SOURCES(

Line 789: IF x_return_status=OKC_API.G_RET_STS_ERROR then

785: x_msg_count,
786: x_msg_data,
787: p_lsev_rec);
788:
789: IF x_return_status=OKC_API.G_RET_STS_ERROR then
790: raise l_excp_error;
791: END IF;
792:
793: okc_lse_pvt.delete_row(

Line 802: x_return_status := OKC_API.G_RET_STS_ERROR;

798: x_msg_data,
799: p_lsev_rec);
800: EXCEPTION
801: WHEN l_excp_error then
802: x_return_status := OKC_API.G_RET_STS_ERROR;
803:
804: WHEN OTHERS THEN
805: OKC_API.set_message(p_app_name => g_app_name,
806: p_msg_name => g_unexpected_error,

Line 805: OKC_API.set_message(p_app_name => g_app_name,

801: WHEN l_excp_error then
802: x_return_status := OKC_API.G_RET_STS_ERROR;
803:
804: WHEN OTHERS THEN
805: OKC_API.set_message(p_app_name => g_app_name,
806: p_msg_name => g_unexpected_error,
807: p_token1 => g_sqlcode_token,
808: p_token1_value => sqlcode,
809: p_token2 => g_sqlerrm_token,

Line 811: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

807: p_token1 => g_sqlcode_token,
808: p_token1_value => sqlcode,
809: p_token2 => g_sqlerrm_token,
810: p_token2_value => sqlerrm);
811: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
812:
813: END DELETE_LINE_STYLES;
814:
815: PROCEDURE LOCK_LINE_STYLES(