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.QP_DELAYED_REQUESTS_UTIL dependencies on FND_API

Line 32: x_return_status := FND_API.G_RET_STS_SUCCESS;

28: oe_debug_pub.add('passed rule id is'||p_qualifier_rule_id);
29: --dbms_output.put_line('Entering QP_DELAYED_REQUESTS_UTIL.check dup');
30: --dbms_output.put_line('passed rule id is'||p_qualifier_rule_id);
31:
32: x_return_status := FND_API.G_RET_STS_SUCCESS;
33: open C_Qualifiers(p_qualifier_rule_id);
34: fetch C_Qualifiers into l_status;
35: close C_Qualifiers;
36:

Line 42: x_return_status := FND_API.G_RET_STS_ERROR;

38: If l_status = 'DUPLICATE' Then
39:
40: oe_debug_pub.add('status is duplicate');
41: --dbms_output.put_line('status is duplicate');
42: x_return_status := FND_API.G_RET_STS_ERROR;
43:
44: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
45: THEN
46:

Line 59: x_return_status := FND_API.G_RET_STS_ERROR;

55:
56: EXCEPTION
57: WHEN DUPLICATE_DISCOUNT
58: THEN
59: x_return_status := FND_API.G_RET_STS_ERROR;
60:
61: WHEN FND_API.G_EXC_ERROR THEN
62:
63: x_return_status := FND_API.G_RET_STS_ERROR;

Line 61: WHEN FND_API.G_EXC_ERROR THEN

57: WHEN DUPLICATE_DISCOUNT
58: THEN
59: x_return_status := FND_API.G_RET_STS_ERROR;
60:
61: WHEN FND_API.G_EXC_ERROR THEN
62:
63: x_return_status := FND_API.G_RET_STS_ERROR;
64:
65: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 63: x_return_status := FND_API.G_RET_STS_ERROR;

59: x_return_status := FND_API.G_RET_STS_ERROR;
60:
61: WHEN FND_API.G_EXC_ERROR THEN
62:
63: x_return_status := FND_API.G_RET_STS_ERROR;
64:
65: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
66:
67: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 65: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

61: WHEN FND_API.G_EXC_ERROR THEN
62:
63: x_return_status := FND_API.G_RET_STS_ERROR;
64:
65: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
66:
67: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
68:
69: WHEN OTHERS THEN

Line 67: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

63: x_return_status := FND_API.G_RET_STS_ERROR;
64:
65: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
66:
67: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
68:
69: WHEN OTHERS THEN
70:
71: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 71: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

67: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
68:
69: WHEN OTHERS THEN
70:
71: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
72:
73: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
74: THEN
75: OE_MSG_PUB.Add_Exc_Msg

Line 112: WHEN FND_API.G_EXC_ERROR THEN

108:
109:
110: EXCEPTION
111:
112: WHEN FND_API.G_EXC_ERROR THEN
113:
114: x_return_status := FND_API.G_RET_STS_ERROR;
115:
116: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 114: x_return_status := FND_API.G_RET_STS_ERROR;

110: EXCEPTION
111:
112: WHEN FND_API.G_EXC_ERROR THEN
113:
114: x_return_status := FND_API.G_RET_STS_ERROR;
115:
116: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
117:
118: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 116: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

112: WHEN FND_API.G_EXC_ERROR THEN
113:
114: x_return_status := FND_API.G_RET_STS_ERROR;
115:
116: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
117:
118: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
119:
120: WHEN OTHERS THEN

Line 118: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

114: x_return_status := FND_API.G_RET_STS_ERROR;
115:
116: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
117:
118: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
119:
120: WHEN OTHERS THEN
121:
122: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 122: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

118: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
119:
120: WHEN OTHERS THEN
121:
122: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
123:
124: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
125: THEN
126: OE_MSG_PUB.Add_Exc_Msg

Line 138: x_return_status := FND_API.G_RET_STS_SUCCESS;

134: p_active_flag in VARCHAR2,
135: x_return_status OUT NOCOPY VARCHAR2)
136: IS
137: BEGIN
138: x_return_status := FND_API.G_RET_STS_SUCCESS;
139:
140: UPDATE qp_qualifiers
141: SET active_flag = p_active_flag
142: WHERE list_header_id = p_list_header_id;

Line 183: x_return_status := FND_API.G_RET_STS_SUCCESS;

179: END IF;
180:
181: EXCEPTION
182: WHEN NO_DATA_FOUND THEN
183: x_return_status := FND_API.G_RET_STS_SUCCESS;
184: WHEN FND_API.G_EXC_ERROR THEN
185: x_return_status := FND_API.G_RET_STS_ERROR;
186: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
187: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 184: WHEN FND_API.G_EXC_ERROR THEN

180:
181: EXCEPTION
182: WHEN NO_DATA_FOUND THEN
183: x_return_status := FND_API.G_RET_STS_SUCCESS;
184: WHEN FND_API.G_EXC_ERROR THEN
185: x_return_status := FND_API.G_RET_STS_ERROR;
186: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
187: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
188: WHEN OTHERS THEN

Line 185: x_return_status := FND_API.G_RET_STS_ERROR;

181: EXCEPTION
182: WHEN NO_DATA_FOUND THEN
183: x_return_status := FND_API.G_RET_STS_SUCCESS;
184: WHEN FND_API.G_EXC_ERROR THEN
185: x_return_status := FND_API.G_RET_STS_ERROR;
186: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
187: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
188: WHEN OTHERS THEN
189: x_return_status := FND_API.G_RET_STS_ERROR;

Line 186: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

182: WHEN NO_DATA_FOUND THEN
183: x_return_status := FND_API.G_RET_STS_SUCCESS;
184: WHEN FND_API.G_EXC_ERROR THEN
185: x_return_status := FND_API.G_RET_STS_ERROR;
186: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
187: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
188: WHEN OTHERS THEN
189: x_return_status := FND_API.G_RET_STS_ERROR;
190: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 187: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

183: x_return_status := FND_API.G_RET_STS_SUCCESS;
184: WHEN FND_API.G_EXC_ERROR THEN
185: x_return_status := FND_API.G_RET_STS_ERROR;
186: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
187: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
188: WHEN OTHERS THEN
189: x_return_status := FND_API.G_RET_STS_ERROR;
190: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
191: OE_MSG_PUB.Add_Exc_Msg

Line 189: x_return_status := FND_API.G_RET_STS_ERROR;

185: x_return_status := FND_API.G_RET_STS_ERROR;
186: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
187: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
188: WHEN OTHERS THEN
189: x_return_status := FND_API.G_RET_STS_ERROR;
190: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
191: OE_MSG_PUB.Add_Exc_Msg
192: ( G_PKG_NAME
193: , 'QP_Delayed_Requests_Util');

Line 203: x_return_status := FND_API.G_RET_STS_SUCCESS;

199: x_return_status OUT NOCOPY VARCHAR2)
200: IS
201: x_result VARCHAR2(1);
202: BEGIN
203: x_return_status := FND_API.G_RET_STS_SUCCESS;
204:
205: IF p_list_type_code = 'AGR' THEN
206: QP_security.create_default_grants( p_instance_type => QP_security.G_AGREEMENT_OBJECT,
207: p_instance_pk1 => p_list_header_id,

Line 221: x_return_status := FND_API.G_RET_STS_SUCCESS;

217: END IF;
218:
219: EXCEPTION
220: WHEN NO_DATA_FOUND THEN
221: x_return_status := FND_API.G_RET_STS_SUCCESS;
222: WHEN FND_API.G_EXC_ERROR THEN
223: x_return_status := FND_API.G_RET_STS_ERROR;
224: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
225: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 222: WHEN FND_API.G_EXC_ERROR THEN

218:
219: EXCEPTION
220: WHEN NO_DATA_FOUND THEN
221: x_return_status := FND_API.G_RET_STS_SUCCESS;
222: WHEN FND_API.G_EXC_ERROR THEN
223: x_return_status := FND_API.G_RET_STS_ERROR;
224: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
225: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
226: WHEN OTHERS THEN

Line 223: x_return_status := FND_API.G_RET_STS_ERROR;

219: EXCEPTION
220: WHEN NO_DATA_FOUND THEN
221: x_return_status := FND_API.G_RET_STS_SUCCESS;
222: WHEN FND_API.G_EXC_ERROR THEN
223: x_return_status := FND_API.G_RET_STS_ERROR;
224: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
225: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
226: WHEN OTHERS THEN
227: x_return_status := FND_API.G_RET_STS_ERROR;

Line 224: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

220: WHEN NO_DATA_FOUND THEN
221: x_return_status := FND_API.G_RET_STS_SUCCESS;
222: WHEN FND_API.G_EXC_ERROR THEN
223: x_return_status := FND_API.G_RET_STS_ERROR;
224: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
225: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
226: WHEN OTHERS THEN
227: x_return_status := FND_API.G_RET_STS_ERROR;
228: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 225: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

221: x_return_status := FND_API.G_RET_STS_SUCCESS;
222: WHEN FND_API.G_EXC_ERROR THEN
223: x_return_status := FND_API.G_RET_STS_ERROR;
224: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
225: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
226: WHEN OTHERS THEN
227: x_return_status := FND_API.G_RET_STS_ERROR;
228: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
229: OE_MSG_PUB.Add_Exc_Msg

Line 227: x_return_status := FND_API.G_RET_STS_ERROR;

223: x_return_status := FND_API.G_RET_STS_ERROR;
224: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
225: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
226: WHEN OTHERS THEN
227: x_return_status := FND_API.G_RET_STS_ERROR;
228: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
229: OE_MSG_PUB.Add_Exc_Msg
230: ( G_PKG_NAME
231: , 'QP_Delayed_Requests_Util');

Line 245: x_return_status := FND_API.G_RET_STS_SUCCESS;

241: IS
242: l_check_active_flag VARCHAR2(1);
243: l_active_flag VARCHAR2(1);
244: BEGIN
245: x_return_status := FND_API.G_RET_STS_SUCCESS;
246: BEGIN
247: IF p_list_header_id IS NOT NULL THEN
248: SELECT ACTIVE_FLAG
249: INTO l_active_flag

Line 283: x_return_status := FND_API.G_RET_STS_SUCCESS;

279: END IF;
280:
281: EXCEPTION
282: WHEN NO_DATA_FOUND THEN
283: x_return_status := FND_API.G_RET_STS_SUCCESS;
284: WHEN FND_API.G_EXC_ERROR THEN
285: x_return_status := FND_API.G_RET_STS_ERROR;
286: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 284: WHEN FND_API.G_EXC_ERROR THEN

280:
281: EXCEPTION
282: WHEN NO_DATA_FOUND THEN
283: x_return_status := FND_API.G_RET_STS_SUCCESS;
284: WHEN FND_API.G_EXC_ERROR THEN
285: x_return_status := FND_API.G_RET_STS_ERROR;
286: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
288: WHEN OTHERS THEN

Line 285: x_return_status := FND_API.G_RET_STS_ERROR;

281: EXCEPTION
282: WHEN NO_DATA_FOUND THEN
283: x_return_status := FND_API.G_RET_STS_SUCCESS;
284: WHEN FND_API.G_EXC_ERROR THEN
285: x_return_status := FND_API.G_RET_STS_ERROR;
286: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
288: WHEN OTHERS THEN
289: x_return_status := FND_API.G_RET_STS_ERROR;

Line 286: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

282: WHEN NO_DATA_FOUND THEN
283: x_return_status := FND_API.G_RET_STS_SUCCESS;
284: WHEN FND_API.G_EXC_ERROR THEN
285: x_return_status := FND_API.G_RET_STS_ERROR;
286: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
288: WHEN OTHERS THEN
289: x_return_status := FND_API.G_RET_STS_ERROR;
290: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

283: x_return_status := FND_API.G_RET_STS_SUCCESS;
284: WHEN FND_API.G_EXC_ERROR THEN
285: x_return_status := FND_API.G_RET_STS_ERROR;
286: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
288: WHEN OTHERS THEN
289: x_return_status := FND_API.G_RET_STS_ERROR;
290: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
291: OE_MSG_PUB.Add_Exc_Msg

Line 289: x_return_status := FND_API.G_RET_STS_ERROR;

285: x_return_status := FND_API.G_RET_STS_ERROR;
286: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
288: WHEN OTHERS THEN
289: x_return_status := FND_API.G_RET_STS_ERROR;
290: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
291: OE_MSG_PUB.Add_Exc_Msg
292: ( G_PKG_NAME
293: , 'QP_Delayed_Requests_Util');

Line 316: x_return_status := FND_API.G_RET_STS_SUCCESS;

312: BEGIN
313:
314: oe_debug_pub.add('Entering QP_DELAYED_REQUESTS_UTIL.check_duplicate_modifier_lines');
315:
316: x_return_status := FND_API.G_RET_STS_SUCCESS;
317:
318: l_status := QP_VALIDATE_PRICING_ATTR.Mod_Dup(p_Start_Date_Active,
319: p_End_Date_Active,
320: p_List_Line_ID,

Line 336: RAISE FND_API.G_EXC_ERROR;

332:
333: FND_MESSAGE.SET_NAME('QP','QP_DUPLICATE_MODIFIER_LINES');
334: oe_msg_pub.Add;
335:
336: RAISE FND_API.G_EXC_ERROR;
337:
338: END IF;
339:
340:

Line 347: WHEN FND_API.G_EXC_ERROR THEN

343:
344:
345: EXCEPTION
346:
347: WHEN FND_API.G_EXC_ERROR THEN
348:
349: x_return_status := FND_API.G_RET_STS_ERROR;
350:
351: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 349: x_return_status := FND_API.G_RET_STS_ERROR;

345: EXCEPTION
346:
347: WHEN FND_API.G_EXC_ERROR THEN
348:
349: x_return_status := FND_API.G_RET_STS_ERROR;
350:
351: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
352:
353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 351: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

347: WHEN FND_API.G_EXC_ERROR THEN
348:
349: x_return_status := FND_API.G_RET_STS_ERROR;
350:
351: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
352:
353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
354:
355: WHEN OTHERS THEN

Line 353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

349: x_return_status := FND_API.G_RET_STS_ERROR;
350:
351: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
352:
353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
354:
355: WHEN OTHERS THEN
356:
357: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 357: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
354:
355: WHEN OTHERS THEN
356:
357: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
358:
359: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
360: THEN
361: OE_MSG_PUB.Add_Exc_Msg

Line 390: x_return_status := FND_API.G_RET_STS_SUCCESS;

386: BEGIN
387:
388: oe_debug_pub.add('Entering QP_DELAYED_REQUESTS_UTIL.check_duplicate_list_lines');
389:
390: x_return_status := FND_API.G_RET_STS_SUCCESS;
391:
392: l_status := QP_VALIDATE_PLL_PRICING_ATTR.Check_Dup_Pra(p_Start_Date_Active,
393: p_End_Date_Active,
394: p_Revision,

Line 413: RAISE FND_API.G_EXC_ERROR;

409:
410: FND_MESSAGE.SET_NAME('QP','QP_DUPLICATE_LIST_LINES');
411: oe_msg_pub.Add;
412:
413: RAISE FND_API.G_EXC_ERROR;
414:
415: ELSIF l_effdates = FALSE then
416:
417:

Line 439: RAISE FND_API.G_EXC_ERROR;

435: END IF;
436:
437: oe_msg_pub.Add;
438:
439: RAISE FND_API.G_EXC_ERROR;
440:
441: ELSE
442:
443: oe_debug_pub.add('Ren: check_duplicate_lines status is false ');

Line 448: RAISE FND_API.G_EXC_ERROR;

444:
445: FND_MESSAGE.SET_NAME('QP','QP_DUPLICATE_LIST_LINES');
446: oe_msg_pub.Add;
447:
448: RAISE FND_API.G_EXC_ERROR;
449:
450: END IF;
451:
452: END IF;

Line 459: WHEN FND_API.G_EXC_ERROR THEN

455:
456:
457: EXCEPTION
458:
459: WHEN FND_API.G_EXC_ERROR THEN
460:
461: x_return_status := FND_API.G_RET_STS_ERROR;
462:
463: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 461: x_return_status := FND_API.G_RET_STS_ERROR;

457: EXCEPTION
458:
459: WHEN FND_API.G_EXC_ERROR THEN
460:
461: x_return_status := FND_API.G_RET_STS_ERROR;
462:
463: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
464:
465: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 463: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

459: WHEN FND_API.G_EXC_ERROR THEN
460:
461: x_return_status := FND_API.G_RET_STS_ERROR;
462:
463: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
464:
465: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
466:
467: WHEN OTHERS THEN

Line 465: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

461: x_return_status := FND_API.G_RET_STS_ERROR;
462:
463: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
464:
465: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
466:
467: WHEN OTHERS THEN
468:
469: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 469: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

465: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
466:
467: WHEN OTHERS THEN
468:
469: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
470:
471: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
472: THEN
473: OE_MSG_PUB.Add_Exc_Msg

Line 529: x_return_status := FND_API.G_RET_STS_SUCCESS;

525: --dbms_output.put_line('Entering QP_DELAYED_REQUESTS_UTIL.validate_pbh_line');
526: --dbms_output.put_line('passed rule id is'||p_list_line_id);
527:
528:
529: x_return_status := FND_API.G_RET_STS_SUCCESS;
530:
531: open c_check_for_parent(p_list_line_id);
532: fetch c_check_for_parent into l_parent;
533: close c_check_for_parent;

Line 565: x_return_status := FND_API.G_RET_STS_ERROR;

561: --Raise MULTIPLE_BREAK_CHILD_EXCEPTION;
562:
563: oe_debug_pub.add('status is more than 1');
564: --dbms_output.put_line('status is more than 1');
565: x_return_status := FND_API.G_RET_STS_ERROR;
566:
567: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
568: THEN
569: IF p_list_line_type_code = 'PBH' THEN

Line 593: x_return_status := FND_API.G_RET_STS_ERROR;

589:
590: EXCEPTION
591: WHEN NO_CHILD_EXCEPTION
592: THEN
593: x_return_status := FND_API.G_RET_STS_ERROR;
594:
595: WHEN FND_API.G_EXC_ERROR THEN
596:
597: x_return_status := FND_API.G_RET_STS_ERROR;

Line 595: WHEN FND_API.G_EXC_ERROR THEN

591: WHEN NO_CHILD_EXCEPTION
592: THEN
593: x_return_status := FND_API.G_RET_STS_ERROR;
594:
595: WHEN FND_API.G_EXC_ERROR THEN
596:
597: x_return_status := FND_API.G_RET_STS_ERROR;
598:
599: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 597: x_return_status := FND_API.G_RET_STS_ERROR;

593: x_return_status := FND_API.G_RET_STS_ERROR;
594:
595: WHEN FND_API.G_EXC_ERROR THEN
596:
597: x_return_status := FND_API.G_RET_STS_ERROR;
598:
599: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
600:
601: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 599: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

595: WHEN FND_API.G_EXC_ERROR THEN
596:
597: x_return_status := FND_API.G_RET_STS_ERROR;
598:
599: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
600:
601: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
602:
603: WHEN NO_DATA_FOUND THEN

Line 601: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

597: x_return_status := FND_API.G_RET_STS_ERROR;
598:
599: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
600:
601: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
602:
603: WHEN NO_DATA_FOUND THEN
604: NULL;
605:

Line 608: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

604: NULL;
605:
606: WHEN OTHERS THEN
607:
608: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
609:
610: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
611: THEN
612: OE_MSG_PUB.Add_Exc_Msg

Line 657: x_return_status := FND_API.G_RET_STS_SUCCESS;

653: --End Bug No: 7321885
654:
655:
656: BEGIN
657: x_return_status := FND_API.G_RET_STS_SUCCESS;
658: --Begin Bug No: 7321885
659: l_count := 0;
660: l_to_number := 0;
661: --End Bug No: 7321885

Line 672: x_return_status := FND_API.G_RET_STS_ERROR;

668: LOOP
669: l_count := l_count + 1;
670: if l_break_lines_rec.pricing_attr_value_to_number < l_break_lines_rec.pricing_attr_value_from_number --changes for value from = value to bug#9210448
671: then
672: x_return_status := FND_API.G_RET_STS_ERROR;
673: end if;
674: if (l_count > 1) and ( l_break_lines_rec.pricing_attr_value_from_number <= l_to_number)
675: then
676: x_return_status := FND_API.G_RET_STS_ERROR;

Line 676: x_return_status := FND_API.G_RET_STS_ERROR;

672: x_return_status := FND_API.G_RET_STS_ERROR;
673: end if;
674: if (l_count > 1) and ( l_break_lines_rec.pricing_attr_value_from_number <= l_to_number)
675: then
676: x_return_status := FND_API.G_RET_STS_ERROR;
677: end if;
678: l_to_number := l_break_lines_rec.pricing_attr_value_to_number;
679: END LOOP;
680: --End Bug No: 7321885

Line 686: IF x_return_status = FND_API.G_RET_STS_ERROR then

682: oe_debug_pub.add('After overlapping breaks select stmt');
683: --dbms_output.put_line('status is '||l_status);
684:
685: --Begin Bug No: 7321885
686: IF x_return_status = FND_API.G_RET_STS_ERROR then
687: --End Bug No: 7321885
688:
689: --Raise OVERLAPPING_BREAKS_EXCEPTION;
690:

Line 691: /* x_return_status := FND_API.G_RET_STS_ERROR; */ --Bug No: 7321885

687: --End Bug No: 7321885
688:
689: --Raise OVERLAPPING_BREAKS_EXCEPTION;
690:
691: /* x_return_status := FND_API.G_RET_STS_ERROR; */ --Bug No: 7321885
692:
693: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
694: THEN
695:

Line 711: x_return_status := FND_API.G_RET_STS_ERROR;

707: NULL;
708:
709: WHEN OVERLAPPING_BREAKS_EXCEPTION
710: THEN
711: x_return_status := FND_API.G_RET_STS_ERROR;
712:
713: WHEN FND_API.G_EXC_ERROR THEN
714:
715: x_return_status := FND_API.G_RET_STS_ERROR;

Line 713: WHEN FND_API.G_EXC_ERROR THEN

709: WHEN OVERLAPPING_BREAKS_EXCEPTION
710: THEN
711: x_return_status := FND_API.G_RET_STS_ERROR;
712:
713: WHEN FND_API.G_EXC_ERROR THEN
714:
715: x_return_status := FND_API.G_RET_STS_ERROR;
716:
717: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 715: x_return_status := FND_API.G_RET_STS_ERROR;

711: x_return_status := FND_API.G_RET_STS_ERROR;
712:
713: WHEN FND_API.G_EXC_ERROR THEN
714:
715: x_return_status := FND_API.G_RET_STS_ERROR;
716:
717: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
718:
719: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 717: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

713: WHEN FND_API.G_EXC_ERROR THEN
714:
715: x_return_status := FND_API.G_RET_STS_ERROR;
716:
717: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
718:
719: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
720:
721: WHEN OTHERS THEN

Line 719: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

715: x_return_status := FND_API.G_RET_STS_ERROR;
716:
717: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
718:
719: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
720:
721: WHEN OTHERS THEN
722:
723: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 723: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

719: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
720:
721: WHEN OTHERS THEN
722:
723: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
724:
725: oe_debug_pub.add('overlapping breaks error '||substr(sqlerrm,1,100));
726: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
727: THEN

Line 760: x_return_status := FND_API.G_RET_STS_SUCCESS;

756: and qrm.from_rltd_modifier_id = p_list_line_id
757: order by qp_number.canonical_to_number(qpa.PRICING_ATTR_VALUE_FROM);
758:
759: BEGIN
760: x_return_status := FND_API.G_RET_STS_SUCCESS;
761:
762: oe_debug_pub.add('Before continuous breaks loop');
763:
764: FOR c_break_lines_attr_val_rec in c_break_lines_attr_values(p_list_line_id)

Line 801: x_return_status := FND_API.G_RET_STS_ERROR;

797: END LOOP;
798: oe_debug_pub.add('After continuous breaks loop');
799:
800: IF l_status IS NOT NULL THEN
801: x_return_status := FND_API.G_RET_STS_ERROR;
802:
803: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
804: THEN
805: IF l_status = 'FROM_NOT_LESS_THAN_TO' THEN

Line 828: x_return_status := FND_API.G_RET_STS_ERROR;

824: NULL;
825:
826: WHEN CONTINUOUS_BREAKS_EXCEPTION
827: THEN
828: x_return_status := FND_API.G_RET_STS_ERROR;
829:
830: WHEN FND_API.G_EXC_ERROR THEN
831:
832: x_return_status := FND_API.G_RET_STS_ERROR;

Line 830: WHEN FND_API.G_EXC_ERROR THEN

826: WHEN CONTINUOUS_BREAKS_EXCEPTION
827: THEN
828: x_return_status := FND_API.G_RET_STS_ERROR;
829:
830: WHEN FND_API.G_EXC_ERROR THEN
831:
832: x_return_status := FND_API.G_RET_STS_ERROR;
833:
834: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 832: x_return_status := FND_API.G_RET_STS_ERROR;

828: x_return_status := FND_API.G_RET_STS_ERROR;
829:
830: WHEN FND_API.G_EXC_ERROR THEN
831:
832: x_return_status := FND_API.G_RET_STS_ERROR;
833:
834: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
835:
836: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 834: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

830: WHEN FND_API.G_EXC_ERROR THEN
831:
832: x_return_status := FND_API.G_RET_STS_ERROR;
833:
834: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
835:
836: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
837:
838: WHEN OTHERS THEN

Line 836: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

832: x_return_status := FND_API.G_RET_STS_ERROR;
833:
834: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
835:
836: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
837:
838: WHEN OTHERS THEN
839:
840: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 840: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

836: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
837:
838: WHEN OTHERS THEN
839:
840: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
841:
842: oe_debug_pub.add('continuous breaks error '||substr(sqlerrm,1,100));
843: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
844: THEN

Line 887: x_return_status := FND_API.G_RET_STS_SUCCESS;

883: l_prod_attr_val_disp VARCHAR2(4000);
884: UPGRADE_PRICE_BREAKS_EXCEPTION EXCEPTION;
885:
886: BEGIN
887: x_return_status := FND_API.G_RET_STS_SUCCESS;
888:
889: l_prod_attr_val_disp := QP_PRICE_LIST_LINE_UTIL.Get_Product_Value('QP_ATTR_DEFNS_PRICING',
890: 'ITEM',
891: p_product_attribute,

Line 946: x_return_status := FND_API.G_RET_STS_ERROR;

942: EXCEPTION
943:
944: WHEN UPGRADE_PRICE_BREAKS_EXCEPTION
945: THEN
946: x_return_status := FND_API.G_RET_STS_ERROR;
947:
948: WHEN FND_API.G_EXC_ERROR THEN
949:
950: x_return_status := FND_API.G_RET_STS_ERROR;

Line 948: WHEN FND_API.G_EXC_ERROR THEN

944: WHEN UPGRADE_PRICE_BREAKS_EXCEPTION
945: THEN
946: x_return_status := FND_API.G_RET_STS_ERROR;
947:
948: WHEN FND_API.G_EXC_ERROR THEN
949:
950: x_return_status := FND_API.G_RET_STS_ERROR;
951:
952: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 950: x_return_status := FND_API.G_RET_STS_ERROR;

946: x_return_status := FND_API.G_RET_STS_ERROR;
947:
948: WHEN FND_API.G_EXC_ERROR THEN
949:
950: x_return_status := FND_API.G_RET_STS_ERROR;
951:
952: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
953:
954: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 952: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

948: WHEN FND_API.G_EXC_ERROR THEN
949:
950: x_return_status := FND_API.G_RET_STS_ERROR;
951:
952: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
953:
954: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
955:
956: WHEN OTHERS THEN

Line 954: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

950: x_return_status := FND_API.G_RET_STS_ERROR;
951:
952: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
953:
954: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
955:
956: WHEN OTHERS THEN
957:
958: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 958: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

954: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
955:
956: WHEN OTHERS THEN
957:
958: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
959:
960: oe_debug_pub.add('upgrade breaks error '||substr(sqlerrm,1,100));
961: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
962: THEN

Line 1000: x_return_status := FND_API.G_RET_STS_ERROR;

996: oe_debug_pub.add('In relevant exception ');
997: FND_MESSAGE.SET_NAME('QP','QP_MULT_PRICE_BREAK_ATTRS');
998: oe_msg_pub.Add;
999:
1000: x_return_status := FND_API.G_RET_STS_ERROR;
1001:
1002: WHEN FND_API.G_EXC_ERROR THEN
1003:
1004: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1002: WHEN FND_API.G_EXC_ERROR THEN

998: oe_msg_pub.Add;
999:
1000: x_return_status := FND_API.G_RET_STS_ERROR;
1001:
1002: WHEN FND_API.G_EXC_ERROR THEN
1003:
1004: x_return_status := FND_API.G_RET_STS_ERROR;
1005:
1006: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1004: x_return_status := FND_API.G_RET_STS_ERROR;

1000: x_return_status := FND_API.G_RET_STS_ERROR;
1001:
1002: WHEN FND_API.G_EXC_ERROR THEN
1003:
1004: x_return_status := FND_API.G_RET_STS_ERROR;
1005:
1006: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1007:
1008: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1006: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1002: WHEN FND_API.G_EXC_ERROR THEN
1003:
1004: x_return_status := FND_API.G_RET_STS_ERROR;
1005:
1006: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1007:
1008: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1009:
1010: WHEN OTHERS THEN

Line 1008: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1004: x_return_status := FND_API.G_RET_STS_ERROR;
1005:
1006: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1007:
1008: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1009:
1010: WHEN OTHERS THEN
1011:
1012: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1012: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1008: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1009:
1010: WHEN OTHERS THEN
1011:
1012: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1013:
1014: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1015: THEN
1016: OE_MSG_PUB.Add_Exc_Msg

Line 1096: x_return_status := FND_API.G_RET_STS_ERROR;

1092:
1093: FND_MESSAGE.SET_NAME('QP','QP_MIXED_QUAL_SEG_LEVELS');
1094: oe_msg_pub.Add;
1095:
1096: x_return_status := FND_API.G_RET_STS_ERROR;
1097:
1098: WHEN FND_API.G_EXC_ERROR THEN
1099:
1100: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1098: WHEN FND_API.G_EXC_ERROR THEN

1094: oe_msg_pub.Add;
1095:
1096: x_return_status := FND_API.G_RET_STS_ERROR;
1097:
1098: WHEN FND_API.G_EXC_ERROR THEN
1099:
1100: x_return_status := FND_API.G_RET_STS_ERROR;
1101:
1102: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1100: x_return_status := FND_API.G_RET_STS_ERROR;

1096: x_return_status := FND_API.G_RET_STS_ERROR;
1097:
1098: WHEN FND_API.G_EXC_ERROR THEN
1099:
1100: x_return_status := FND_API.G_RET_STS_ERROR;
1101:
1102: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1103:
1104: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1102: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1098: WHEN FND_API.G_EXC_ERROR THEN
1099:
1100: x_return_status := FND_API.G_RET_STS_ERROR;
1101:
1102: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1103:
1104: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1105:
1106: WHEN OTHERS THEN

Line 1104: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1100: x_return_status := FND_API.G_RET_STS_ERROR;
1101:
1102: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1103:
1104: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1105:
1106: WHEN OTHERS THEN
1107:
1108: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1108: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1104: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1105:
1106: WHEN OTHERS THEN
1107:
1108: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1109:
1110: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1111: THEN
1112:

Line 1141: x_return_status := FND_API.G_RET_STS_SUCCESS;

1137: AND qpq.qualifier_context = 'MODLIST'
1138: AND qpq.qualifier_attribute = 'QUALIFIER_ATTRIBUTE4';
1139: BEGIN
1140:
1141: x_return_status := FND_API.G_RET_STS_SUCCESS;
1142:
1143: open C_modifier(p_list_header_id);
1144: fetch C_modifier into l_status;
1145: close C_modifier;

Line 1152: x_return_status := FND_API.G_RET_STS_ERROR;

1148:
1149: --oe_debug_pub.add('status is duplicate');
1150: --dbms_output.put_line('status is duplicate');
1151:
1152: x_return_status := FND_API.G_RET_STS_ERROR;
1153:
1154: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1155: THEN
1156:

Line 1169: x_return_status := FND_API.G_RET_STS_ERROR;

1165:
1166: EXCEPTION
1167: WHEN MULTIPLE_PRICE_LIST_EXCEPTION
1168: THEN
1169: x_return_status := FND_API.G_RET_STS_ERROR;
1170:
1171: WHEN FND_API.G_EXC_ERROR THEN
1172:
1173: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1171: WHEN FND_API.G_EXC_ERROR THEN

1167: WHEN MULTIPLE_PRICE_LIST_EXCEPTION
1168: THEN
1169: x_return_status := FND_API.G_RET_STS_ERROR;
1170:
1171: WHEN FND_API.G_EXC_ERROR THEN
1172:
1173: x_return_status := FND_API.G_RET_STS_ERROR;
1174:
1175: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1173: x_return_status := FND_API.G_RET_STS_ERROR;

1169: x_return_status := FND_API.G_RET_STS_ERROR;
1170:
1171: WHEN FND_API.G_EXC_ERROR THEN
1172:
1173: x_return_status := FND_API.G_RET_STS_ERROR;
1174:
1175: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1176:
1177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1175: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1171: WHEN FND_API.G_EXC_ERROR THEN
1172:
1173: x_return_status := FND_API.G_RET_STS_ERROR;
1174:
1175: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1176:
1177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1178:
1179: WHEN OTHERS THEN

Line 1177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1173: x_return_status := FND_API.G_RET_STS_ERROR;
1174:
1175: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1176:
1177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1178:
1179: WHEN OTHERS THEN
1180:
1181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1178:
1179: WHEN OTHERS THEN
1180:
1181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1182:
1183: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1184: THEN
1185: OE_MSG_PUB.Add_Exc_Msg

Line 1203: x_return_status := FND_API.G_RET_STS_SUCCESS;

1199: l_ret_code number;
1200:
1201: BEGIN
1202:
1203: x_return_status := FND_API.G_RET_STS_SUCCESS;
1204:
1205: QP_Maintain_Denormalized_Data.Update_Qualifiers(err_buff => l_err_buf,
1206: retcode => l_ret_code,
1207: p_list_header_id => p_list_header_id,

Line 1212: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1208: p_update_type => 'DELAYED_REQ');
1209:
1210: IF l_ret_code <> 0 THEN
1211:
1212: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1213:
1214: END IF;
1215:
1216: EXCEPTION

Line 1218: WHEN FND_API.G_EXC_ERROR THEN

1214: END IF;
1215:
1216: EXCEPTION
1217:
1218: WHEN FND_API.G_EXC_ERROR THEN
1219:
1220: x_return_status := FND_API.G_RET_STS_ERROR;
1221:
1222: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1220: x_return_status := FND_API.G_RET_STS_ERROR;

1216: EXCEPTION
1217:
1218: WHEN FND_API.G_EXC_ERROR THEN
1219:
1220: x_return_status := FND_API.G_RET_STS_ERROR;
1221:
1222: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1223:
1224: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1222: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1218: WHEN FND_API.G_EXC_ERROR THEN
1219:
1220: x_return_status := FND_API.G_RET_STS_ERROR;
1221:
1222: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1223:
1224: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1225: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1226: THEN

Line 1224: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1220: x_return_status := FND_API.G_RET_STS_ERROR;
1221:
1222: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1223:
1224: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1225: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1226: THEN
1227: OE_MSG_PUB.Add_Exc_Msg
1228: ( G_PKG_NAME

Line 1234: x_return_status := FND_API.G_RET_STS_ERROR;

1230: END IF;
1231:
1232: WHEN OTHERS THEN
1233:
1234: x_return_status := FND_API.G_RET_STS_ERROR;
1235:
1236: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1237: THEN
1238: OE_MSG_PUB.Add_Exc_Msg

Line 1265: x_return_status := FND_API.G_RET_STS_SUCCESS;

1261: WHEN OTHERS THEN
1262: l_list_header_id := 0;
1263: END;
1264:
1265: x_return_status := FND_API.G_RET_STS_SUCCESS;
1266: QP_Denormalized_Pricing_Attrs.Update_Pricing_Attributes(
1267: p_list_header_id_low => l_list_header_id,
1268: p_list_header_id_high => l_list_header_id,
1269: p_update_type => 'FACTOR_DELAYED_REQ');

Line 1277: x_return_status := FND_API.G_RET_STS_ERROR;

1273: p_list_header_id_high => l_list_header_id);
1274:
1275: EXCEPTION
1276: WHEN OTHERS THEN
1277: x_return_status := FND_API.G_RET_STS_ERROR;
1278:
1279: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1280: THEN
1281: OE_MSG_PUB.Add_Exc_Msg

Line 1305: x_return_status := FND_API.G_RET_STS_SUCCESS;

1301: l_list_type_code varchar2(30);
1302:
1303: BEGIN
1304:
1305: x_return_status := FND_API.G_RET_STS_SUCCESS;
1306:
1307: oe_debug_pub.add('list_line_id is NULL');
1308:
1309: BEGIN

Line 1429: WHEN FND_API.G_EXC_ERROR THEN

1425: FROM QP_LIST_LINES WHERE LIST_HEADER_ID = p_list_header_id);
1426:
1427: EXCEPTION
1428:
1429: WHEN FND_API.G_EXC_ERROR THEN
1430:
1431: x_return_status := FND_API.G_RET_STS_ERROR;
1432:
1433: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1431: x_return_status := FND_API.G_RET_STS_ERROR;

1427: EXCEPTION
1428:
1429: WHEN FND_API.G_EXC_ERROR THEN
1430:
1431: x_return_status := FND_API.G_RET_STS_ERROR;
1432:
1433: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1434:
1435: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1433: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1429: WHEN FND_API.G_EXC_ERROR THEN
1430:
1431: x_return_status := FND_API.G_RET_STS_ERROR;
1432:
1433: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1434:
1435: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1436:
1437: WHEN OTHERS THEN

Line 1435: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1431: x_return_status := FND_API.G_RET_STS_ERROR;
1432:
1433: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1434:
1435: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1436:
1437: WHEN OTHERS THEN
1438:
1439: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1439: x_return_status := FND_API.G_RET_STS_ERROR;

1435: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1436:
1437: WHEN OTHERS THEN
1438:
1439: x_return_status := FND_API.G_RET_STS_ERROR;
1440:
1441: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1442: THEN
1443: OE_MSG_PUB.Add_Exc_Msg

Line 1538: IF x_return_status = FND_API.G_RET_STS_ERROR

1534: -- commenting out as suggested by SPGOPAL
1535: ,x_return_status => x_return_status
1536: ,x_return_status_text => l_return_status_text);
1537:
1538: IF x_return_status = FND_API.G_RET_STS_ERROR
1539: THEN
1540: oe_debug_pub.add('error update_pricing_phase begin'||l_return_status_text);
1541: raise Phase_exception;
1542: END IF;

Line 1549: x_return_status := FND_API.G_RET_STS_ERROR;

1545: oe_debug_pub.add('end update_pricing_phase begin');
1546:
1547: EXCEPTION
1548: WHEN Phase_Exception THEN
1549: x_return_status := FND_API.G_RET_STS_ERROR;
1550:
1551: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1552: OE_MSG_PUB.Add_Exc_Msg
1553: ( G_PKG_NAME

Line 1556: WHEN FND_API.G_EXC_ERROR THEN

1552: OE_MSG_PUB.Add_Exc_Msg
1553: ( G_PKG_NAME
1554: , 'Update_Pricing_Phase');
1555: END IF;
1556: WHEN FND_API.G_EXC_ERROR THEN
1557: x_return_status := FND_API.G_RET_STS_ERROR;
1558: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1559: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1560: WHEN OTHERS THEN

Line 1557: x_return_status := FND_API.G_RET_STS_ERROR;

1553: ( G_PKG_NAME
1554: , 'Update_Pricing_Phase');
1555: END IF;
1556: WHEN FND_API.G_EXC_ERROR THEN
1557: x_return_status := FND_API.G_RET_STS_ERROR;
1558: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1559: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1560: WHEN OTHERS THEN
1561: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1558: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1554: , 'Update_Pricing_Phase');
1555: END IF;
1556: WHEN FND_API.G_EXC_ERROR THEN
1557: x_return_status := FND_API.G_RET_STS_ERROR;
1558: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1559: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1560: WHEN OTHERS THEN
1561: x_return_status := FND_API.G_RET_STS_ERROR;
1562: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 1559: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1555: END IF;
1556: WHEN FND_API.G_EXC_ERROR THEN
1557: x_return_status := FND_API.G_RET_STS_ERROR;
1558: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1559: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1560: WHEN OTHERS THEN
1561: x_return_status := FND_API.G_RET_STS_ERROR;
1562: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1563: OE_MSG_PUB.Add_Exc_Msg

Line 1561: x_return_status := FND_API.G_RET_STS_ERROR;

1557: x_return_status := FND_API.G_RET_STS_ERROR;
1558: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1559: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1560: WHEN OTHERS THEN
1561: x_return_status := FND_API.G_RET_STS_ERROR;
1562: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1563: OE_MSG_PUB.Add_Exc_Msg
1564: ( G_PKG_NAME
1565: , 'Update_Pricing_Phase');

Line 1581: x_return_status := FND_API.G_RET_STS_SUCCESS;

1577: l_list_header_id number;
1578:
1579: BEGIN
1580:
1581: x_return_status := FND_API.G_RET_STS_SUCCESS;
1582:
1583: oe_debug_pub.add('list_line_id is '||p_list_line_id);
1584:
1585: BEGIN

Line 1695: WHEN FND_API.G_EXC_ERROR THEN

1691: where pra.list_line_id = p_list_line_id;
1692:
1693: EXCEPTION
1694:
1695: WHEN FND_API.G_EXC_ERROR THEN
1696:
1697: x_return_status := FND_API.G_RET_STS_ERROR;
1698:
1699: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1697: x_return_status := FND_API.G_RET_STS_ERROR;

1693: EXCEPTION
1694:
1695: WHEN FND_API.G_EXC_ERROR THEN
1696:
1697: x_return_status := FND_API.G_RET_STS_ERROR;
1698:
1699: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1700:
1701: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1699: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1695: WHEN FND_API.G_EXC_ERROR THEN
1696:
1697: x_return_status := FND_API.G_RET_STS_ERROR;
1698:
1699: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1700:
1701: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1702:
1703: WHEN OTHERS THEN

Line 1701: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1697: x_return_status := FND_API.G_RET_STS_ERROR;
1698:
1699: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1700:
1701: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1702:
1703: WHEN OTHERS THEN
1704:
1705: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1705: x_return_status := FND_API.G_RET_STS_ERROR;

1701: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1702:
1703: WHEN OTHERS THEN
1704:
1705: x_return_status := FND_API.G_RET_STS_ERROR;
1706:
1707: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1708: THEN
1709: OE_MSG_PUB.Add_Exc_Msg

Line 1752: x_return_status := FND_API.G_RET_STS_SUCCESS;

1748: BEGIN
1749:
1750: -- l_price_break_type := p_price_break_type;
1751:
1752: x_return_status := FND_API.G_RET_STS_SUCCESS;
1753:
1754: oe_debug_pub.add('list_line_id is '||p_list_line_id);
1755:
1756: select price_break_type_code,pricing_phase_id, arithmetic_operator -- 4936019

Line 1824: WHEN FND_API.G_EXC_ERROR THEN

1820:
1821:
1822: EXCEPTION
1823:
1824: WHEN FND_API.G_EXC_ERROR THEN
1825:
1826: x_return_status := FND_API.G_RET_STS_ERROR;
1827:
1828: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1826: x_return_status := FND_API.G_RET_STS_ERROR;

1822: EXCEPTION
1823:
1824: WHEN FND_API.G_EXC_ERROR THEN
1825:
1826: x_return_status := FND_API.G_RET_STS_ERROR;
1827:
1828: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1829:
1830: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1828: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1824: WHEN FND_API.G_EXC_ERROR THEN
1825:
1826: x_return_status := FND_API.G_RET_STS_ERROR;
1827:
1828: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1829:
1830: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1831:
1832: WHEN OTHERS THEN

Line 1830: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1826: x_return_status := FND_API.G_RET_STS_ERROR;
1827:
1828: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1829:
1830: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1831:
1832: WHEN OTHERS THEN
1833:
1834: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1834: x_return_status := FND_API.G_RET_STS_ERROR;

1830: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1831:
1832: WHEN OTHERS THEN
1833:
1834: x_return_status := FND_API.G_RET_STS_ERROR;
1835:
1836: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1837: THEN
1838: OE_MSG_PUB.Add_Exc_Msg

Line 1907: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1903: , 'Update_Child_Pricing_Attr'
1904: );
1905: END IF;
1906:
1907: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1908:
1909: END UPDATE_CHILD_PRICING_ATTR;
1910:
1911: /*added by spgopal for including list_header_id and pricing_phase_id in pricing_attributes table for modifiers*/

Line 1919: := FND_API.G_MISS_NUM;

1915: , p_List_Line_ID IN NUMBER
1916: ) IS
1917:
1918: l_Pricing_Phase_id QP_PRICING_PHASES.PRICING_PHASE_ID%TYPE
1919: := FND_API.G_MISS_NUM;
1920: l_List_Header_ID QP_LIST_HEADERS_B.LIST_HEADER_ID%TYPE
1921: := FND_API.G_MISS_NUM;
1922:
1923: /*

Line 1921: := FND_API.G_MISS_NUM;

1917:
1918: l_Pricing_Phase_id QP_PRICING_PHASES.PRICING_PHASE_ID%TYPE
1919: := FND_API.G_MISS_NUM;
1920: l_List_Header_ID QP_LIST_HEADERS_B.LIST_HEADER_ID%TYPE
1921: := FND_API.G_MISS_NUM;
1922:
1923: /*
1924: Cursor C_pricing_attr(p_list_line_id number) IS
1925: SELECT *

Line 1933: p_List_Line_ID <> FND_API.G_MISS_NUM) THEN

1929: BEGIN
1930:
1931:
1932: IF (p_List_Line_ID IS NOT NULL OR
1933: p_List_Line_ID <> FND_API.G_MISS_NUM) THEN
1934:
1935: SELECT LIST_HEADER_ID, PRICING_PHASE_ID INTO
1936: l_List_Header_ID, l_Pricing_Phase_ID FROM QP_LIST_LINES
1937: WHERE LIST_LINE_ID = p_List_Line_ID;

Line 1958: WHEN FND_API.G_EXC_ERROR THEN

1954: END IF;
1955:
1956: EXCEPTION
1957:
1958: WHEN FND_API.G_EXC_ERROR THEN
1959:
1960: x_return_status := FND_API.G_RET_STS_ERROR;
1961:
1962: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1960: x_return_status := FND_API.G_RET_STS_ERROR;

1956: EXCEPTION
1957:
1958: WHEN FND_API.G_EXC_ERROR THEN
1959:
1960: x_return_status := FND_API.G_RET_STS_ERROR;
1961:
1962: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1963:
1964: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1962: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1958: WHEN FND_API.G_EXC_ERROR THEN
1959:
1960: x_return_status := FND_API.G_RET_STS_ERROR;
1961:
1962: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1963:
1964: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1965:
1966: WHEN OTHERS THEN

Line 1964: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1960: x_return_status := FND_API.G_RET_STS_ERROR;
1961:
1962: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1963:
1964: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1965:
1966: WHEN OTHERS THEN
1967:
1968: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1968: x_return_status := FND_API.G_RET_STS_ERROR;

1964: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1965:
1966: WHEN OTHERS THEN
1967:
1968: x_return_status := FND_API.G_RET_STS_ERROR;
1969:
1970: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1971: THEN
1972: OE_MSG_PUB.Add_Exc_Msg

Line 2009: p_parent_line_id <> FND_API.G_MISS_NUM THEN

2005: IF p_list_line_type = 'OID' THEN
2006: l_line := 'Y';
2007: ELSIF p_list_line_type = 'RLTD' THEN
2008: IF p_parent_line_id IS NOT NULL OR
2009: p_parent_line_id <> FND_API.G_MISS_NUM THEN
2010:
2011: select decode(LL.list_line_type_code, 'PRG','Y','N')
2012: into l_rltd from qp_list_lines LL
2013: where LL.list_line_id = p_parent_line_id;

Line 2041: IF x_return_status = FND_API.G_RET_STS_ERROR

2037: ,p_call_from => p_call_from
2038: ,x_return_status => x_return_status
2039: ,x_return_status_text => l_return_status_text);
2040:
2041: IF x_return_status = FND_API.G_RET_STS_ERROR
2042: THEN
2043: oe_debug_pub.add('error update_pricing_phase begin'||l_return_status_text);
2044: raise Phase_exception;
2045: END IF;

Line 2051: x_return_status := FND_API.G_RET_STS_ERROR;

2047: oe_debug_pub.add('end update_pricing_phase begin');
2048: EXCEPTION
2049: WHEN Phase_Exception THEN
2050:
2051: x_return_status := FND_API.G_RET_STS_ERROR;
2052:
2053: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2054: OE_MSG_PUB.Add_Exc_Msg
2055: ( G_PKG_NAME

Line 2059: WHEN FND_API.G_EXC_ERROR THEN

2055: ( G_PKG_NAME
2056: , 'Update_Pricing_Phase');
2057: END IF;
2058:
2059: WHEN FND_API.G_EXC_ERROR THEN
2060:
2061: x_return_status := FND_API.G_RET_STS_ERROR;
2062:
2063: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2061: x_return_status := FND_API.G_RET_STS_ERROR;

2057: END IF;
2058:
2059: WHEN FND_API.G_EXC_ERROR THEN
2060:
2061: x_return_status := FND_API.G_RET_STS_ERROR;
2062:
2063: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2064:
2065: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2063: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2059: WHEN FND_API.G_EXC_ERROR THEN
2060:
2061: x_return_status := FND_API.G_RET_STS_ERROR;
2062:
2063: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2064:
2065: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2066:
2067: WHEN OTHERS THEN

Line 2065: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2061: x_return_status := FND_API.G_RET_STS_ERROR;
2062:
2063: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2064:
2065: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2066:
2067: WHEN OTHERS THEN
2068:
2069: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2069: x_return_status := FND_API.G_RET_STS_ERROR;

2065: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2066:
2067: WHEN OTHERS THEN
2068:
2069: x_return_status := FND_API.G_RET_STS_ERROR;
2070:
2071: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2072: OE_MSG_PUB.Add_Exc_Msg
2073: ( G_PKG_NAME

Line 2128: WHEN FND_API.G_EXC_ERROR THEN

2124: end if;
2125:
2126: oe_debug_pub.add('Update manual modifier flag End');
2127: EXCEPTION
2128: WHEN FND_API.G_EXC_ERROR THEN
2129:
2130: x_return_status := FND_API.G_RET_STS_ERROR;
2131:
2132: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2130: x_return_status := FND_API.G_RET_STS_ERROR;

2126: oe_debug_pub.add('Update manual modifier flag End');
2127: EXCEPTION
2128: WHEN FND_API.G_EXC_ERROR THEN
2129:
2130: x_return_status := FND_API.G_RET_STS_ERROR;
2131:
2132: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2133:
2134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2132: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2128: WHEN FND_API.G_EXC_ERROR THEN
2129:
2130: x_return_status := FND_API.G_RET_STS_ERROR;
2131:
2132: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2133:
2134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2135:
2136: WHEN OTHERS THEN

Line 2134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2130: x_return_status := FND_API.G_RET_STS_ERROR;
2131:
2132: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2133:
2134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2135:
2136: WHEN OTHERS THEN
2137:
2138: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2138: x_return_status := FND_API.G_RET_STS_ERROR;

2134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2135:
2136: WHEN OTHERS THEN
2137:
2138: x_return_status := FND_API.G_RET_STS_ERROR;
2139:
2140: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2141: OE_MSG_PUB.Add_Exc_Msg
2142: ( G_PKG_NAME

Line 2166: x_return_status := FND_API.G_RET_STS_SUCCESS;

2162: l_first_selling_rounding number;
2163: BEGIN
2164: oe_debug_pub.add('validate_selling_price begin '||p_currency_header_id||' '||p_to_currency_code);
2165:
2166: x_return_status := FND_API.G_RET_STS_SUCCESS;
2167: l_first_record := 'TRUE';
2168:
2169: for selling_rounding_rec in c_selling_rounding
2170: LOOP

Line 2187: raise FND_API.G_EXC_ERROR;

2183: fnd_message.set_token('CURRENCY_CODE', p_to_currency_code);
2184: OE_MSG_PUB.Add;
2185: END IF;
2186:
2187: raise FND_API.G_EXC_ERROR;
2188: end if;
2189:
2190: END LOOP;
2191:

Line 2195: WHEN FND_API.G_EXC_ERROR THEN

2191:
2192: oe_debug_pub.add('end validate_selling_rounding ');
2193:
2194: EXCEPTION
2195: WHEN FND_API.G_EXC_ERROR THEN
2196:
2197: x_return_status := FND_API.G_RET_STS_ERROR;
2198:
2199: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2197: x_return_status := FND_API.G_RET_STS_ERROR;

2193:
2194: EXCEPTION
2195: WHEN FND_API.G_EXC_ERROR THEN
2196:
2197: x_return_status := FND_API.G_RET_STS_ERROR;
2198:
2199: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2200:
2201: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2199: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2195: WHEN FND_API.G_EXC_ERROR THEN
2196:
2197: x_return_status := FND_API.G_RET_STS_ERROR;
2198:
2199: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2200:
2201: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2202:
2203: WHEN OTHERS THEN

Line 2201: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2197: x_return_status := FND_API.G_RET_STS_ERROR;
2198:
2199: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2200:
2201: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2202:
2203: WHEN OTHERS THEN
2204:
2205: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2205: x_return_status := FND_API.G_RET_STS_ERROR;

2201: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2202:
2203: WHEN OTHERS THEN
2204:
2205: x_return_status := FND_API.G_RET_STS_ERROR;
2206:
2207: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2208: OE_MSG_PUB.Add_Exc_Msg
2209: ( G_PKG_NAME

Line 2262: raise FND_API.G_EXC_ERROR;

2258: fnd_message.set_token('LIST_LINE_ID', p_list_line_id);
2259: fnd_message.set_token('QUALIFIER_GRP_NO', p_qualifier_grouping_no);
2260: OE_MSG_PUB.Add;
2261: END IF;
2262: raise FND_API.G_EXC_ERROR;
2263: end if;
2264:
2265: elsif l_final_segment_level = 'ORDER' then
2266: if l_current_segment_level = 'ORDER' then

Line 2280: raise FND_API.G_EXC_ERROR;

2276: fnd_message.set_token('LIST_LINE_ID', p_list_line_id);
2277: fnd_message.set_token('QUALIFIER_GRP_NO', p_qualifier_grouping_no);
2278: OE_MSG_PUB.Add;
2279: END IF;
2280: raise FND_API.G_EXC_ERROR;
2281: end if;
2282:
2283: elsif l_final_segment_level = 'BOTH' then
2284: if l_current_segment_level = 'LINE' then

Line 2305: raise FND_API.G_EXC_ERROR;

2301: fnd_message.set_token('LIST_LINE_ID', p_list_line_id);
2302: fnd_message.set_token('QUALIFIER_GRP_NO', p_qualifier_grouping_no);
2303: OE_MSG_PUB.Add;
2304: END IF;
2305: raise FND_API.G_EXC_ERROR;
2306: end if;
2307:
2308: elsif l_final_segment_level = 'ORDER_BOTH' then
2309: if l_current_segment_level in ('ORDER', 'BOTH') then

Line 2321: raise FND_API.G_EXC_ERROR;

2317: fnd_message.set_token('LIST_LINE_ID', p_list_line_id);
2318: fnd_message.set_token('QUALIFIER_GRP_NO', p_qualifier_grouping_no);
2319: OE_MSG_PUB.Add;
2320: END IF;
2321: raise FND_API.G_EXC_ERROR;
2322: end if;
2323:
2324: end if; -- l_final_segment_level = 'LINE'
2325: end if; -- l_final_segment_level is NULL

Line 2331: WHEN FND_API.G_EXC_ERROR THEN

2327: END LOOP;
2328:
2329: oe_debug_pub.add('End Check_Segment_Level_in_Group');
2330: EXCEPTION
2331: WHEN FND_API.G_EXC_ERROR THEN
2332:
2333: x_return_status := FND_API.G_RET_STS_ERROR;
2334:
2335: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2333: x_return_status := FND_API.G_RET_STS_ERROR;

2329: oe_debug_pub.add('End Check_Segment_Level_in_Group');
2330: EXCEPTION
2331: WHEN FND_API.G_EXC_ERROR THEN
2332:
2333: x_return_status := FND_API.G_RET_STS_ERROR;
2334:
2335: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2336:
2337: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2335: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2331: WHEN FND_API.G_EXC_ERROR THEN
2332:
2333: x_return_status := FND_API.G_RET_STS_ERROR;
2334:
2335: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2336:
2337: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2338:
2339: WHEN OTHERS THEN

Line 2337: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2333: x_return_status := FND_API.G_RET_STS_ERROR;
2334:
2335: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2336:
2337: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2338:
2339: WHEN OTHERS THEN
2340:
2341: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2341: x_return_status := FND_API.G_RET_STS_ERROR;

2337: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2338:
2339: WHEN OTHERS THEN
2340:
2341: x_return_status := FND_API.G_RET_STS_ERROR;
2342:
2343: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2344: OE_MSG_PUB.Add_Exc_Msg
2345: ( G_PKG_NAME

Line 2435: --raise FND_API.G_EXC_ERROR;

2431: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
2432: fnd_message.set_name('QP', 'QP_NO_HEADER_QUAL_FOR_LINE');
2433: OE_MSG_PUB.Add;
2434: END IF;
2435: --raise FND_API.G_EXC_ERROR;
2436: end if;
2437:
2438: if l_order_modifier_exists = 'Y' and l_qual_exist_for_ord_modifier = 'N' then
2439: oe_debug_pub.add('mkarya - Modifier Lines of level ''ORDER'' will not be applied

Line 2445: --raise FND_API.G_EXC_ERROR;

2441: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
2442: fnd_message.set_name('QP', 'QP_NO_HEADER_QUAL_FOR_ORD');
2443: OE_MSG_PUB.Add;
2444: END IF;
2445: --raise FND_API.G_EXC_ERROR;
2446: end if;
2447:
2448: end if; -- l_header_qual_exists = 'Y'
2449: end if; -- l_line_modifier_exists = 'Y' or l_order_modifier_exists = 'Y'

Line 2453: WHEN FND_API.G_EXC_ERROR THEN

2449: end if; -- l_line_modifier_exists = 'Y' or l_order_modifier_exists = 'Y'
2450:
2451: oe_debug_pub.add('End Check_Line_for_Header_Qual');
2452: EXCEPTION
2453: WHEN FND_API.G_EXC_ERROR THEN
2454:
2455: x_return_status := FND_API.G_RET_STS_ERROR;
2456:
2457: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2455: x_return_status := FND_API.G_RET_STS_ERROR;

2451: oe_debug_pub.add('End Check_Line_for_Header_Qual');
2452: EXCEPTION
2453: WHEN FND_API.G_EXC_ERROR THEN
2454:
2455: x_return_status := FND_API.G_RET_STS_ERROR;
2456:
2457: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2458:
2459: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2457: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2453: WHEN FND_API.G_EXC_ERROR THEN
2454:
2455: x_return_status := FND_API.G_RET_STS_ERROR;
2456:
2457: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2458:
2459: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2460:
2461: WHEN OTHERS THEN

Line 2459: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2455: x_return_status := FND_API.G_RET_STS_ERROR;
2456:
2457: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2458:
2459: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2460:
2461: WHEN OTHERS THEN
2462:
2463: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2463: x_return_status := FND_API.G_RET_STS_ERROR;

2459: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2460:
2461: WHEN OTHERS THEN
2462:
2463: x_return_status := FND_API.G_RET_STS_ERROR;
2464:
2465: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2466: OE_MSG_PUB.Add_Exc_Msg
2467: ( G_PKG_NAME

Line 2514: x_return_status := FND_API.G_RET_STS_ERROR;

2510: and product_attr_value = qpa.product_attr_value));
2511:
2512: exception
2513: when others then
2514: x_return_status := FND_API.G_RET_STS_ERROR;
2515: end;
2516:
2517: x_return_status := FND_API.G_RET_STS_SUCCESS;
2518:

Line 2517: x_return_status := FND_API.G_RET_STS_SUCCESS;

2513: when others then
2514: x_return_status := FND_API.G_RET_STS_ERROR;
2515: end;
2516:
2517: x_return_status := FND_API.G_RET_STS_SUCCESS;
2518:
2519: end update_changed_lines_add;
2520:
2521:

Line 2584: x_return_status := FND_API.G_RET_STS_ERROR;

2580: and rownum = 1);
2581:
2582: exception
2583: when others then
2584: x_return_status := FND_API.G_RET_STS_ERROR;
2585: end;
2586:
2587: x_return_status := FND_API.G_RET_STS_SUCCESS;
2588:

Line 2587: x_return_status := FND_API.G_RET_STS_SUCCESS;

2583: when others then
2584: x_return_status := FND_API.G_RET_STS_ERROR;
2585: end;
2586:
2587: x_return_status := FND_API.G_RET_STS_SUCCESS;
2588:
2589: end update_changed_lines_del;
2590:
2591: procedure update_changed_lines_ph (

Line 2691: x_return_status := FND_API.G_RET_STS_ERROR;

2687: and rownum = 1);
2688:
2689: exception
2690: when others then
2691: x_return_status := FND_API.G_RET_STS_ERROR;
2692: end;
2693:
2694: x_return_status := FND_API.G_RET_STS_SUCCESS;
2695:

Line 2694: x_return_status := FND_API.G_RET_STS_SUCCESS;

2690: when others then
2691: x_return_status := FND_API.G_RET_STS_ERROR;
2692: end;
2693:
2694: x_return_status := FND_API.G_RET_STS_SUCCESS;
2695:
2696: end update_changed_lines_ph;
2697:
2698: procedure update_changed_lines_act (

Line 2808: x_return_status := FND_API.G_RET_STS_ERROR;

2804: end if;
2805:
2806: exception
2807: when others then
2808: x_return_status := FND_API.G_RET_STS_ERROR;
2809: end;
2810:
2811: x_return_status := FND_API.G_RET_STS_SUCCESS;
2812:

Line 2811: x_return_status := FND_API.G_RET_STS_SUCCESS;

2807: when others then
2808: x_return_status := FND_API.G_RET_STS_ERROR;
2809: end;
2810:
2811: x_return_status := FND_API.G_RET_STS_SUCCESS;
2812:
2813: end update_changed_lines_act;
2814:
2815: Procedure HVOP_Pricing_Setup (x_return_status OUT NOCOPY VARCHAR2) IS

Line 2822: IF(x_return_status=FND_API.G_RET_STS_ERROR) THEN

2818: procedure_error Exception;
2819: BEGIN
2820:
2821: QP_Maintain_Denormalized_Data.Set_HVOP_Pricing (x_return_status, l_return_status_text);
2822: IF(x_return_status=FND_API.G_RET_STS_ERROR) THEN
2823: raise procedure_error;
2824: END IF;
2825:
2826: EXCEPTION

Line 2832: WHEN FND_API.G_EXC_ERROR THEN

2828: OE_MSG_PUB.Add_Exc_Msg
2829: ( G_PKG_NAME
2830: , 'Error while executing the process QP_Maintain_Denormalized_Data.Set_HVOP_Pricing : '|| l_return_status_text);
2831:
2832: WHEN FND_API.G_EXC_ERROR THEN
2833: x_return_status := FND_API.G_RET_STS_ERROR;
2834: OE_MSG_PUB.Add_Exc_Msg
2835: ( G_PKG_NAME
2836: , l_return_status_text);

Line 2833: x_return_status := FND_API.G_RET_STS_ERROR;

2829: ( G_PKG_NAME
2830: , 'Error while executing the process QP_Maintain_Denormalized_Data.Set_HVOP_Pricing : '|| l_return_status_text);
2831:
2832: WHEN FND_API.G_EXC_ERROR THEN
2833: x_return_status := FND_API.G_RET_STS_ERROR;
2834: OE_MSG_PUB.Add_Exc_Msg
2835: ( G_PKG_NAME
2836: , l_return_status_text);
2837:

Line 2838: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2834: OE_MSG_PUB.Add_Exc_Msg
2835: ( G_PKG_NAME
2836: , l_return_status_text);
2837:
2838: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2839: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2840: OE_MSG_PUB.Add_Exc_Msg
2841: ( G_PKG_NAME
2842: , l_return_status_text);

Line 2839: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2835: ( G_PKG_NAME
2836: , l_return_status_text);
2837:
2838: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2839: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2840: OE_MSG_PUB.Add_Exc_Msg
2841: ( G_PKG_NAME
2842: , l_return_status_text);
2843:

Line 2845: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2841: ( G_PKG_NAME
2842: , l_return_status_text);
2843:
2844: WHEN OTHERS THEN
2845: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2846: OE_MSG_PUB.Add_Exc_Msg
2847: ( G_PKG_NAME
2848: , l_return_status_text);
2849: END HVOP_Pricing_Setup;

Line 2872: WHEN FND_API.G_EXC_ERROR THEN

2868: p_setup_action => p_setup_action);
2869: oe_debug_pub.add('calling old jagan ' || p_list_header_id);
2870: END IF;
2871: EXCEPTION
2872: WHEN FND_API.G_EXC_ERROR THEN
2873: x_return_status := FND_API.G_RET_STS_ERROR;
2874:
2875: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2876: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2873: x_return_status := FND_API.G_RET_STS_ERROR;

2869: oe_debug_pub.add('calling old jagan ' || p_list_header_id);
2870: END IF;
2871: EXCEPTION
2872: WHEN FND_API.G_EXC_ERROR THEN
2873: x_return_status := FND_API.G_RET_STS_ERROR;
2874:
2875: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2876: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2877:

Line 2875: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2871: EXCEPTION
2872: WHEN FND_API.G_EXC_ERROR THEN
2873: x_return_status := FND_API.G_RET_STS_ERROR;
2874:
2875: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2876: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2877:
2878: WHEN OTHERS THEN
2879: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2876: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2872: WHEN FND_API.G_EXC_ERROR THEN
2873: x_return_status := FND_API.G_RET_STS_ERROR;
2874:
2875: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2876: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2877:
2878: WHEN OTHERS THEN
2879: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2880:

Line 2879: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2875: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2876: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2877:
2878: WHEN OTHERS THEN
2879: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2880:
2881: END Maintain_header_pattern;
2882:
2883: Procedure Maintain_line_pattern(p_list_header_id in number,

Line 2904: WHEN FND_API.G_EXC_ERROR THEN

2900: p_qualifier_group => p_qualifier_group,
2901: p_setup_action => p_setup_action);
2902: END IF;
2903: EXCEPTION
2904: WHEN FND_API.G_EXC_ERROR THEN
2905: x_return_status := FND_API.G_RET_STS_ERROR;
2906:
2907: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2908: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2905: x_return_status := FND_API.G_RET_STS_ERROR;

2901: p_setup_action => p_setup_action);
2902: END IF;
2903: EXCEPTION
2904: WHEN FND_API.G_EXC_ERROR THEN
2905: x_return_status := FND_API.G_RET_STS_ERROR;
2906:
2907: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2908: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2909:

Line 2907: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2903: EXCEPTION
2904: WHEN FND_API.G_EXC_ERROR THEN
2905: x_return_status := FND_API.G_RET_STS_ERROR;
2906:
2907: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2908: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2909:
2910: WHEN OTHERS THEN
2911: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2908: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2904: WHEN FND_API.G_EXC_ERROR THEN
2905: x_return_status := FND_API.G_RET_STS_ERROR;
2906:
2907: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2908: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2909:
2910: WHEN OTHERS THEN
2911: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2912:

Line 2911: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2907: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2908: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2909:
2910: WHEN OTHERS THEN
2911: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2912:
2913: END Maintain_line_pattern;
2914:
2915: Procedure Maintain_product_pattern(p_list_header_id in number,

Line 2933: WHEN FND_API.G_EXC_ERROR THEN

2929: p_list_line_id => p_list_line_id,
2930: p_setup_action => p_setup_action);
2931: END IF;
2932: EXCEPTION
2933: WHEN FND_API.G_EXC_ERROR THEN
2934: x_return_status := FND_API.G_RET_STS_ERROR;
2935:
2936: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2937: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2934: x_return_status := FND_API.G_RET_STS_ERROR;

2930: p_setup_action => p_setup_action);
2931: END IF;
2932: EXCEPTION
2933: WHEN FND_API.G_EXC_ERROR THEN
2934: x_return_status := FND_API.G_RET_STS_ERROR;
2935:
2936: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2937: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2938:

Line 2936: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2932: EXCEPTION
2933: WHEN FND_API.G_EXC_ERROR THEN
2934: x_return_status := FND_API.G_RET_STS_ERROR;
2935:
2936: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2937: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2938:
2939: WHEN OTHERS THEN
2940: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2937: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2933: WHEN FND_API.G_EXC_ERROR THEN
2934: x_return_status := FND_API.G_RET_STS_ERROR;
2935:
2936: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2937: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2938:
2939: WHEN OTHERS THEN
2940: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2941:

Line 2940: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2936: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2937: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2938:
2939: WHEN OTHERS THEN
2940: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2941:
2942: END Maintain_product_pattern;
2943:
2944: -- pattern

Line 2965: x_return_status := FND_API.G_RET_STS_SUCCESS;

2961: WHERE pte_source_system_id = p_pte_source_system_id
2962: AND enabled_flag = 'Y'
2963: AND rownum = 1;
2964:
2965: x_return_status := FND_API.G_RET_STS_SUCCESS;
2966:
2967: EXCEPTION
2968:
2969: WHEN NO_DATA_FOUND THEN

Line 2987: x_return_status := FND_API.G_RET_STS_SUCCESS;

2983: END IF;
2984:
2985:
2986: -- As this is a WARNING message, we still return success
2987: x_return_status := FND_API.G_RET_STS_SUCCESS;
2988:
2989: WHEN OTHERS THEN
2990: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2991: END Check_Enabled_Func_Areas;

Line 2990: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2986: -- As this is a WARNING message, we still return success
2987: x_return_status := FND_API.G_RET_STS_SUCCESS;
2988:
2989: WHEN OTHERS THEN
2990: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2991: END Check_Enabled_Func_Areas;
2992:
2993: END QP_Delayed_Requests_UTIL;