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

Line 31: FND_API.G_MISS_NUM

27:
28:
29: PROCEDURE Query_Rows
30: ( p_price_adj_attrib_id IN NUMBER :=
31: FND_API.G_MISS_NUM
32: , p_price_adjustment_id IN NUMBER :=
33: FND_API.G_MISS_NUM
34: , x_Line_Adj_Att_Tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Adj_Att_Tbl_Type
35: )

Line 33: FND_API.G_MISS_NUM

29: PROCEDURE Query_Rows
30: ( p_price_adj_attrib_id IN NUMBER :=
31: FND_API.G_MISS_NUM
32: , p_price_adjustment_id IN NUMBER :=
33: FND_API.G_MISS_NUM
34: , x_Line_Adj_Att_Tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Adj_Att_Tbl_Type
35: )
36: IS
37: l_count NUMBER;

Line 112: x_Line_Adj_Att_Tbl(l_count).db_flag := FND_API.G_TRUE;

108: x_Line_Adj_Att_Tbl(l_count).PRICE_ADJ_ATTRIB_ID := iml_rec.PRICE_ADJ_ATTRIB_ID;
109: x_Line_Adj_Att_Tbl(l_count).LOCK_CONTROL := iml_rec.LOCK_CONTROL;
110:
111: -- set values for non-DB fields
112: x_Line_Adj_Att_Tbl(l_count).db_flag := FND_API.G_TRUE;
113: x_Line_Adj_Att_Tbl(l_count).operation := FND_API.G_MISS_CHAR;
114: x_Line_Adj_Att_Tbl(l_count).return_status := FND_API.G_MISS_CHAR;
115:
116: l_count := l_count + 1;

Line 113: x_Line_Adj_Att_Tbl(l_count).operation := FND_API.G_MISS_CHAR;

109: x_Line_Adj_Att_Tbl(l_count).LOCK_CONTROL := iml_rec.LOCK_CONTROL;
110:
111: -- set values for non-DB fields
112: x_Line_Adj_Att_Tbl(l_count).db_flag := FND_API.G_TRUE;
113: x_Line_Adj_Att_Tbl(l_count).operation := FND_API.G_MISS_CHAR;
114: x_Line_Adj_Att_Tbl(l_count).return_status := FND_API.G_MISS_CHAR;
115:
116: l_count := l_count + 1;
117: END LOOP;

Line 114: x_Line_Adj_Att_Tbl(l_count).return_status := FND_API.G_MISS_CHAR;

110:
111: -- set values for non-DB fields
112: x_Line_Adj_Att_Tbl(l_count).db_flag := FND_API.G_TRUE;
113: x_Line_Adj_Att_Tbl(l_count).operation := FND_API.G_MISS_CHAR;
114: x_Line_Adj_Att_Tbl(l_count).return_status := FND_API.G_MISS_CHAR;
115:
116: l_count := l_count + 1;
117: END LOOP;
118:

Line 120: and p_price_Adj_attrib_id <> FND_API.G_MISS_NUM)

116: l_count := l_count + 1;
117: END LOOP;
118:
119: IF ( p_price_Adj_attrib_id IS NOT NULL
120: and p_price_Adj_attrib_id <> FND_API.G_MISS_NUM)
121: AND
122: (x_Line_Adj_Att_tbl.COUNT = 0 )
123: THEN
124: RAISE NO_DATA_FOUND;

Line 131: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

127: -- RETURN l_Line_Adj_Att_tbl;
128:
129: EXCEPTION
130:
131: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
132:
133: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
134:
135: WHEN OTHERS THEN

Line 133: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

129: EXCEPTION
130:
131: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
132:
133: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
134:
135: WHEN OTHERS THEN
136:
137: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 145: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

141: , 'Query_Rows'
142: );
143: END IF;
144:
145: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
146:
147: END Query_Rows;
148:
149: PROCEDURE Insert_Row

Line 226: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

222: IF l_debug_level > 0 THEN
223: oe_debug_pub.add('Exceptions in Oe_Line_Price_Aattr_util.insert_row:'||SQLERRM);
224: END IF;
225:
226: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
227:
228: END Insert_Row;
229:
230: PROCEDURE Update_Row

Line 283: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

279: ( G_PKG_NAME
280: , 'Update_Row'
281: );
282: END IF;
283: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
284:
285:
286:
287: END Update_Row ;

Line 290: ( p_price_adj_attrib_id NUMBER := FND_API.G_MISS_NUM

286:
287: END Update_Row ;
288:
289: PROCEDURE Delete_Row
290: ( p_price_adj_attrib_id NUMBER := FND_API.G_MISS_NUM
291: , p_price_adjustment_id NUMBER := FND_API.G_MISS_NUM
292: )
293: IS
294: --

Line 291: , p_price_adjustment_id NUMBER := FND_API.G_MISS_NUM

287: END Update_Row ;
288:
289: PROCEDURE Delete_Row
290: ( p_price_adj_attrib_id NUMBER := FND_API.G_MISS_NUM
291: , p_price_adjustment_id NUMBER := FND_API.G_MISS_NUM
292: )
293: IS
294: --
295: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 299: IF p_price_adjustment_id <> FND_API.G_MISS_NUM then

295: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
296: --
297: BEGIN
298:
299: IF p_price_adjustment_id <> FND_API.G_MISS_NUM then
300: --bug3528335 splitting the DELETE statement to delete attributes corresponding to child lines first (if the parent is PBH) and then the parent
301: --bug3405372 deleting the rows corresponding to the child lines of PBH modifiers as well.
302: DELETE FROM OE_PRICE_ADJ_ATTRIBS
303: WHERE PRICE_ADJUSTMENT_ID IN (SELECT RLTD_PRICE_ADJ_ID

Line 333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

329: ( G_PKG_NAME
330: , 'Delete_Row'
331: );
332: END IF;
333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
334:
335: END Delete_Row;
336:
337: PROCEDURE Complete_Record

Line 349: IF l_Line_Adj_Att_rec.PRICE_ADJUSTMENT_ID = FND_API.G_MISS_NUM THEN

345: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
346: --
347: BEGIN
348:
349: IF l_Line_Adj_Att_rec.PRICE_ADJUSTMENT_ID = FND_API.G_MISS_NUM THEN
350: l_Line_Adj_Att_rec.PRICE_ADJUSTMENT_ID := p_old_Line_Adj_Att_rec.PRICE_ADJUSTMENT_ID;
351: END IF;
352:
353: IF l_Line_Adj_Att_rec.PRICING_CONTEXT = FND_API.G_MISS_CHAR THEN

Line 353: IF l_Line_Adj_Att_rec.PRICING_CONTEXT = FND_API.G_MISS_CHAR THEN

349: IF l_Line_Adj_Att_rec.PRICE_ADJUSTMENT_ID = FND_API.G_MISS_NUM THEN
350: l_Line_Adj_Att_rec.PRICE_ADJUSTMENT_ID := p_old_Line_Adj_Att_rec.PRICE_ADJUSTMENT_ID;
351: END IF;
352:
353: IF l_Line_Adj_Att_rec.PRICING_CONTEXT = FND_API.G_MISS_CHAR THEN
354: l_Line_Adj_Att_rec.PRICING_CONTEXT := p_old_Line_Adj_Att_rec.PRICING_CONTEXT;
355: END IF;
356:
357: IF l_Line_Adj_Att_rec.PRICING_ATTRIBUTE = FND_API.G_MISS_CHAR THEN

Line 357: IF l_Line_Adj_Att_rec.PRICING_ATTRIBUTE = FND_API.G_MISS_CHAR THEN

353: IF l_Line_Adj_Att_rec.PRICING_CONTEXT = FND_API.G_MISS_CHAR THEN
354: l_Line_Adj_Att_rec.PRICING_CONTEXT := p_old_Line_Adj_Att_rec.PRICING_CONTEXT;
355: END IF;
356:
357: IF l_Line_Adj_Att_rec.PRICING_ATTRIBUTE = FND_API.G_MISS_CHAR THEN
358: l_Line_Adj_Att_rec.PRICING_ATTRIBUTE := p_old_Line_Adj_Att_rec.PRICING_ATTRIBUTE;
359: END IF;
360:
361: IF l_Line_Adj_Att_rec.CREATION_DATE = FND_API.G_MISS_DATE THEN

Line 361: IF l_Line_Adj_Att_rec.CREATION_DATE = FND_API.G_MISS_DATE THEN

357: IF l_Line_Adj_Att_rec.PRICING_ATTRIBUTE = FND_API.G_MISS_CHAR THEN
358: l_Line_Adj_Att_rec.PRICING_ATTRIBUTE := p_old_Line_Adj_Att_rec.PRICING_ATTRIBUTE;
359: END IF;
360:
361: IF l_Line_Adj_Att_rec.CREATION_DATE = FND_API.G_MISS_DATE THEN
362: l_Line_Adj_Att_rec.CREATION_DATE := p_old_Line_Adj_Att_rec.CREATION_DATE;
363: END IF;
364:
365: IF l_Line_Adj_Att_rec.CREATED_BY = FND_API.G_MISS_NUM THEN

Line 365: IF l_Line_Adj_Att_rec.CREATED_BY = FND_API.G_MISS_NUM THEN

361: IF l_Line_Adj_Att_rec.CREATION_DATE = FND_API.G_MISS_DATE THEN
362: l_Line_Adj_Att_rec.CREATION_DATE := p_old_Line_Adj_Att_rec.CREATION_DATE;
363: END IF;
364:
365: IF l_Line_Adj_Att_rec.CREATED_BY = FND_API.G_MISS_NUM THEN
366: l_Line_Adj_Att_rec.CREATED_BY := p_old_Line_Adj_Att_rec.CREATED_BY;
367: END IF;
368:
369: IF l_Line_Adj_Att_rec.LAST_UPDATE_DATE = FND_API.G_MISS_DATE THEN

Line 369: IF l_Line_Adj_Att_rec.LAST_UPDATE_DATE = FND_API.G_MISS_DATE THEN

365: IF l_Line_Adj_Att_rec.CREATED_BY = FND_API.G_MISS_NUM THEN
366: l_Line_Adj_Att_rec.CREATED_BY := p_old_Line_Adj_Att_rec.CREATED_BY;
367: END IF;
368:
369: IF l_Line_Adj_Att_rec.LAST_UPDATE_DATE = FND_API.G_MISS_DATE THEN
370: l_Line_Adj_Att_rec.LAST_UPDATE_DATE := p_old_Line_Adj_Att_rec.LAST_UPDATE_DATE;
371: END IF;
372:
373: IF l_Line_Adj_Att_rec.LAST_UPDATED_BY = FND_API.G_MISS_NUM THEN

Line 373: IF l_Line_Adj_Att_rec.LAST_UPDATED_BY = FND_API.G_MISS_NUM THEN

369: IF l_Line_Adj_Att_rec.LAST_UPDATE_DATE = FND_API.G_MISS_DATE THEN
370: l_Line_Adj_Att_rec.LAST_UPDATE_DATE := p_old_Line_Adj_Att_rec.LAST_UPDATE_DATE;
371: END IF;
372:
373: IF l_Line_Adj_Att_rec.LAST_UPDATED_BY = FND_API.G_MISS_NUM THEN
374: l_Line_Adj_Att_rec.LAST_UPDATED_BY := p_old_Line_Adj_Att_rec.LAST_UPDATED_BY;
375: END IF;
376:
377: IF l_Line_Adj_Att_rec.LAST_UPDATE_LOGIN = FND_API.G_MISS_NUM THEN

Line 377: IF l_Line_Adj_Att_rec.LAST_UPDATE_LOGIN = FND_API.G_MISS_NUM THEN

373: IF l_Line_Adj_Att_rec.LAST_UPDATED_BY = FND_API.G_MISS_NUM THEN
374: l_Line_Adj_Att_rec.LAST_UPDATED_BY := p_old_Line_Adj_Att_rec.LAST_UPDATED_BY;
375: END IF;
376:
377: IF l_Line_Adj_Att_rec.LAST_UPDATE_LOGIN = FND_API.G_MISS_NUM THEN
378: l_Line_Adj_Att_rec.LAST_UPDATE_LOGIN := p_old_Line_Adj_Att_rec.LAST_UPDATE_LOGIN;
379: END IF;
380:
381: IF l_Line_Adj_Att_rec.PROGRAM_APPLICATION_ID = FND_API.G_MISS_NUM THEN

Line 381: IF l_Line_Adj_Att_rec.PROGRAM_APPLICATION_ID = FND_API.G_MISS_NUM THEN

377: IF l_Line_Adj_Att_rec.LAST_UPDATE_LOGIN = FND_API.G_MISS_NUM THEN
378: l_Line_Adj_Att_rec.LAST_UPDATE_LOGIN := p_old_Line_Adj_Att_rec.LAST_UPDATE_LOGIN;
379: END IF;
380:
381: IF l_Line_Adj_Att_rec.PROGRAM_APPLICATION_ID = FND_API.G_MISS_NUM THEN
382: l_Line_Adj_Att_rec.PROGRAM_APPLICATION_ID := p_old_Line_Adj_Att_rec.PROGRAM_APPLICATION_ID;
383: END IF;
384:
385: IF l_Line_Adj_Att_rec.PROGRAM_ID = FND_API.G_MISS_NUM THEN

Line 385: IF l_Line_Adj_Att_rec.PROGRAM_ID = FND_API.G_MISS_NUM THEN

381: IF l_Line_Adj_Att_rec.PROGRAM_APPLICATION_ID = FND_API.G_MISS_NUM THEN
382: l_Line_Adj_Att_rec.PROGRAM_APPLICATION_ID := p_old_Line_Adj_Att_rec.PROGRAM_APPLICATION_ID;
383: END IF;
384:
385: IF l_Line_Adj_Att_rec.PROGRAM_ID = FND_API.G_MISS_NUM THEN
386: l_Line_Adj_Att_rec.PROGRAM_ID := p_old_Line_Adj_Att_rec.PROGRAM_ID;
387: END IF;
388:
389: IF l_Line_Adj_Att_rec.PROGRAM_UPDATE_DATE = FND_API.G_MISS_DATE THEN

Line 389: IF l_Line_Adj_Att_rec.PROGRAM_UPDATE_DATE = FND_API.G_MISS_DATE THEN

385: IF l_Line_Adj_Att_rec.PROGRAM_ID = FND_API.G_MISS_NUM THEN
386: l_Line_Adj_Att_rec.PROGRAM_ID := p_old_Line_Adj_Att_rec.PROGRAM_ID;
387: END IF;
388:
389: IF l_Line_Adj_Att_rec.PROGRAM_UPDATE_DATE = FND_API.G_MISS_DATE THEN
390: l_Line_Adj_Att_rec.PROGRAM_UPDATE_DATE := p_old_Line_Adj_Att_rec.PROGRAM_UPDATE_DATE;
391: END IF;
392:
393: IF l_Line_Adj_Att_rec.REQUEST_ID = FND_API.G_MISS_NUM THEN

Line 393: IF l_Line_Adj_Att_rec.REQUEST_ID = FND_API.G_MISS_NUM THEN

389: IF l_Line_Adj_Att_rec.PROGRAM_UPDATE_DATE = FND_API.G_MISS_DATE THEN
390: l_Line_Adj_Att_rec.PROGRAM_UPDATE_DATE := p_old_Line_Adj_Att_rec.PROGRAM_UPDATE_DATE;
391: END IF;
392:
393: IF l_Line_Adj_Att_rec.REQUEST_ID = FND_API.G_MISS_NUM THEN
394: l_Line_Adj_Att_rec.REQUEST_ID := p_old_Line_Adj_Att_rec.REQUEST_ID;
395: END IF;
396:
397: IF l_Line_Adj_Att_rec.PRICING_ATTR_VALUE_FROM = FND_API.G_MISS_CHAR THEN

Line 397: IF l_Line_Adj_Att_rec.PRICING_ATTR_VALUE_FROM = FND_API.G_MISS_CHAR THEN

393: IF l_Line_Adj_Att_rec.REQUEST_ID = FND_API.G_MISS_NUM THEN
394: l_Line_Adj_Att_rec.REQUEST_ID := p_old_Line_Adj_Att_rec.REQUEST_ID;
395: END IF;
396:
397: IF l_Line_Adj_Att_rec.PRICING_ATTR_VALUE_FROM = FND_API.G_MISS_CHAR THEN
398: l_Line_Adj_Att_rec.PRICING_ATTR_VALUE_FROM := p_old_Line_Adj_Att_rec.PRICING_ATTR_VALUE_FROM;
399: END IF;
400:
401: IF l_Line_Adj_Att_rec.PRICING_ATTR_VALUE_TO = FND_API.G_MISS_CHAR THEN

Line 401: IF l_Line_Adj_Att_rec.PRICING_ATTR_VALUE_TO = FND_API.G_MISS_CHAR THEN

397: IF l_Line_Adj_Att_rec.PRICING_ATTR_VALUE_FROM = FND_API.G_MISS_CHAR THEN
398: l_Line_Adj_Att_rec.PRICING_ATTR_VALUE_FROM := p_old_Line_Adj_Att_rec.PRICING_ATTR_VALUE_FROM;
399: END IF;
400:
401: IF l_Line_Adj_Att_rec.PRICING_ATTR_VALUE_TO = FND_API.G_MISS_CHAR THEN
402: l_Line_Adj_Att_rec.PRICING_ATTR_VALUE_TO := p_old_Line_Adj_Att_rec.PRICING_ATTR_VALUE_TO;
403: END IF;
404:
405: IF l_Line_Adj_Att_rec.COMPARISON_OPERATOR = FND_API.G_MISS_CHAR THEN

Line 405: IF l_Line_Adj_Att_rec.COMPARISON_OPERATOR = FND_API.G_MISS_CHAR THEN

401: IF l_Line_Adj_Att_rec.PRICING_ATTR_VALUE_TO = FND_API.G_MISS_CHAR THEN
402: l_Line_Adj_Att_rec.PRICING_ATTR_VALUE_TO := p_old_Line_Adj_Att_rec.PRICING_ATTR_VALUE_TO;
403: END IF;
404:
405: IF l_Line_Adj_Att_rec.COMPARISON_OPERATOR = FND_API.G_MISS_CHAR THEN
406: l_Line_Adj_Att_rec.COMPARISON_OPERATOR := p_old_Line_Adj_Att_rec.COMPARISON_OPERATOR;
407: END IF;
408:
409: IF l_Line_Adj_Att_rec.FLEX_TITLE = FND_API.G_MISS_CHAR THEN

Line 409: IF l_Line_Adj_Att_rec.FLEX_TITLE = FND_API.G_MISS_CHAR THEN

405: IF l_Line_Adj_Att_rec.COMPARISON_OPERATOR = FND_API.G_MISS_CHAR THEN
406: l_Line_Adj_Att_rec.COMPARISON_OPERATOR := p_old_Line_Adj_Att_rec.COMPARISON_OPERATOR;
407: END IF;
408:
409: IF l_Line_Adj_Att_rec.FLEX_TITLE = FND_API.G_MISS_CHAR THEN
410: l_Line_Adj_Att_rec.FLEX_TITLE := p_old_Line_Adj_Att_rec.FLEX_TITLE;
411: END IF;
412:
413: IF l_Line_Adj_Att_rec.PRICE_ADJ_ATTRIB_ID = FND_API.G_MISS_NUM THEN

Line 413: IF l_Line_Adj_Att_rec.PRICE_ADJ_ATTRIB_ID = FND_API.G_MISS_NUM THEN

409: IF l_Line_Adj_Att_rec.FLEX_TITLE = FND_API.G_MISS_CHAR THEN
410: l_Line_Adj_Att_rec.FLEX_TITLE := p_old_Line_Adj_Att_rec.FLEX_TITLE;
411: END IF;
412:
413: IF l_Line_Adj_Att_rec.PRICE_ADJ_ATTRIB_ID = FND_API.G_MISS_NUM THEN
414: l_Line_Adj_Att_rec.PRICE_ADJ_ATTRIB_ID := p_old_Line_Adj_Att_rec.PRICE_ADJ_ATTRIB_ID;
415: END IF;
416:
417: -- RETURN l_Line_Adj_Att_rec;

Line 432: IF l_Line_Adj_Att_rec.PRICE_ADJUSTMENT_ID = FND_API.G_MISS_NUM THEN

428: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
429: --
430: BEGIN
431:
432: IF l_Line_Adj_Att_rec.PRICE_ADJUSTMENT_ID = FND_API.G_MISS_NUM THEN
433: l_Line_Adj_Att_rec.PRICE_ADJUSTMENT_ID := Null;
434: END IF;
435:
436: IF l_Line_Adj_Att_rec.PRICING_CONTEXT = FND_API.G_MISS_CHAR THEN

Line 436: IF l_Line_Adj_Att_rec.PRICING_CONTEXT = FND_API.G_MISS_CHAR THEN

432: IF l_Line_Adj_Att_rec.PRICE_ADJUSTMENT_ID = FND_API.G_MISS_NUM THEN
433: l_Line_Adj_Att_rec.PRICE_ADJUSTMENT_ID := Null;
434: END IF;
435:
436: IF l_Line_Adj_Att_rec.PRICING_CONTEXT = FND_API.G_MISS_CHAR THEN
437: l_Line_Adj_Att_rec.PRICING_CONTEXT := Null;
438: END IF;
439:
440: IF l_Line_Adj_Att_rec.PRICING_ATTRIBUTE = FND_API.G_MISS_CHAR THEN

Line 440: IF l_Line_Adj_Att_rec.PRICING_ATTRIBUTE = FND_API.G_MISS_CHAR THEN

436: IF l_Line_Adj_Att_rec.PRICING_CONTEXT = FND_API.G_MISS_CHAR THEN
437: l_Line_Adj_Att_rec.PRICING_CONTEXT := Null;
438: END IF;
439:
440: IF l_Line_Adj_Att_rec.PRICING_ATTRIBUTE = FND_API.G_MISS_CHAR THEN
441: l_Line_Adj_Att_rec.PRICING_ATTRIBUTE := Null;
442: END IF;
443:
444: IF l_Line_Adj_Att_rec.CREATION_DATE = FND_API.G_MISS_DATE THEN

Line 444: IF l_Line_Adj_Att_rec.CREATION_DATE = FND_API.G_MISS_DATE THEN

440: IF l_Line_Adj_Att_rec.PRICING_ATTRIBUTE = FND_API.G_MISS_CHAR THEN
441: l_Line_Adj_Att_rec.PRICING_ATTRIBUTE := Null;
442: END IF;
443:
444: IF l_Line_Adj_Att_rec.CREATION_DATE = FND_API.G_MISS_DATE THEN
445: l_Line_Adj_Att_rec.CREATION_DATE := Null;
446: END IF;
447:
448: IF l_Line_Adj_Att_rec.CREATED_BY = FND_API.G_MISS_NUM THEN

Line 448: IF l_Line_Adj_Att_rec.CREATED_BY = FND_API.G_MISS_NUM THEN

444: IF l_Line_Adj_Att_rec.CREATION_DATE = FND_API.G_MISS_DATE THEN
445: l_Line_Adj_Att_rec.CREATION_DATE := Null;
446: END IF;
447:
448: IF l_Line_Adj_Att_rec.CREATED_BY = FND_API.G_MISS_NUM THEN
449: l_Line_Adj_Att_rec.CREATED_BY := Null;
450: END IF;
451:
452: IF l_Line_Adj_Att_rec.LAST_UPDATE_DATE = FND_API.G_MISS_DATE THEN

Line 452: IF l_Line_Adj_Att_rec.LAST_UPDATE_DATE = FND_API.G_MISS_DATE THEN

448: IF l_Line_Adj_Att_rec.CREATED_BY = FND_API.G_MISS_NUM THEN
449: l_Line_Adj_Att_rec.CREATED_BY := Null;
450: END IF;
451:
452: IF l_Line_Adj_Att_rec.LAST_UPDATE_DATE = FND_API.G_MISS_DATE THEN
453: l_Line_Adj_Att_rec.LAST_UPDATE_DATE := Null;
454: END IF;
455:
456: IF l_Line_Adj_Att_rec.LAST_UPDATED_BY = FND_API.G_MISS_NUM THEN

Line 456: IF l_Line_Adj_Att_rec.LAST_UPDATED_BY = FND_API.G_MISS_NUM THEN

452: IF l_Line_Adj_Att_rec.LAST_UPDATE_DATE = FND_API.G_MISS_DATE THEN
453: l_Line_Adj_Att_rec.LAST_UPDATE_DATE := Null;
454: END IF;
455:
456: IF l_Line_Adj_Att_rec.LAST_UPDATED_BY = FND_API.G_MISS_NUM THEN
457: l_Line_Adj_Att_rec.LAST_UPDATED_BY := Null;
458: END IF;
459:
460: IF l_Line_Adj_Att_rec.LAST_UPDATE_LOGIN = FND_API.G_MISS_NUM THEN

Line 460: IF l_Line_Adj_Att_rec.LAST_UPDATE_LOGIN = FND_API.G_MISS_NUM THEN

456: IF l_Line_Adj_Att_rec.LAST_UPDATED_BY = FND_API.G_MISS_NUM THEN
457: l_Line_Adj_Att_rec.LAST_UPDATED_BY := Null;
458: END IF;
459:
460: IF l_Line_Adj_Att_rec.LAST_UPDATE_LOGIN = FND_API.G_MISS_NUM THEN
461: l_Line_Adj_Att_rec.LAST_UPDATE_LOGIN := Null;
462: END IF;
463:
464: IF l_Line_Adj_Att_rec.PROGRAM_APPLICATION_ID = FND_API.G_MISS_NUM THEN

Line 464: IF l_Line_Adj_Att_rec.PROGRAM_APPLICATION_ID = FND_API.G_MISS_NUM THEN

460: IF l_Line_Adj_Att_rec.LAST_UPDATE_LOGIN = FND_API.G_MISS_NUM THEN
461: l_Line_Adj_Att_rec.LAST_UPDATE_LOGIN := Null;
462: END IF;
463:
464: IF l_Line_Adj_Att_rec.PROGRAM_APPLICATION_ID = FND_API.G_MISS_NUM THEN
465: l_Line_Adj_Att_rec.PROGRAM_APPLICATION_ID := Null;
466: END IF;
467:
468: IF l_Line_Adj_Att_rec.PROGRAM_ID = FND_API.G_MISS_NUM THEN

Line 468: IF l_Line_Adj_Att_rec.PROGRAM_ID = FND_API.G_MISS_NUM THEN

464: IF l_Line_Adj_Att_rec.PROGRAM_APPLICATION_ID = FND_API.G_MISS_NUM THEN
465: l_Line_Adj_Att_rec.PROGRAM_APPLICATION_ID := Null;
466: END IF;
467:
468: IF l_Line_Adj_Att_rec.PROGRAM_ID = FND_API.G_MISS_NUM THEN
469: l_Line_Adj_Att_rec.PROGRAM_ID := Null;
470: END IF;
471:
472: IF l_Line_Adj_Att_rec.PROGRAM_UPDATE_DATE = FND_API.G_MISS_DATE THEN

Line 472: IF l_Line_Adj_Att_rec.PROGRAM_UPDATE_DATE = FND_API.G_MISS_DATE THEN

468: IF l_Line_Adj_Att_rec.PROGRAM_ID = FND_API.G_MISS_NUM THEN
469: l_Line_Adj_Att_rec.PROGRAM_ID := Null;
470: END IF;
471:
472: IF l_Line_Adj_Att_rec.PROGRAM_UPDATE_DATE = FND_API.G_MISS_DATE THEN
473: l_Line_Adj_Att_rec.PROGRAM_UPDATE_DATE := Null;
474: END IF;
475:
476: IF l_Line_Adj_Att_rec.REQUEST_ID = FND_API.G_MISS_NUM THEN

Line 476: IF l_Line_Adj_Att_rec.REQUEST_ID = FND_API.G_MISS_NUM THEN

472: IF l_Line_Adj_Att_rec.PROGRAM_UPDATE_DATE = FND_API.G_MISS_DATE THEN
473: l_Line_Adj_Att_rec.PROGRAM_UPDATE_DATE := Null;
474: END IF;
475:
476: IF l_Line_Adj_Att_rec.REQUEST_ID = FND_API.G_MISS_NUM THEN
477: l_Line_Adj_Att_rec.REQUEST_ID := Null;
478: END IF;
479:
480: IF l_Line_Adj_Att_rec.PRICING_ATTR_VALUE_FROM = FND_API.G_MISS_CHAR THEN

Line 480: IF l_Line_Adj_Att_rec.PRICING_ATTR_VALUE_FROM = FND_API.G_MISS_CHAR THEN

476: IF l_Line_Adj_Att_rec.REQUEST_ID = FND_API.G_MISS_NUM THEN
477: l_Line_Adj_Att_rec.REQUEST_ID := Null;
478: END IF;
479:
480: IF l_Line_Adj_Att_rec.PRICING_ATTR_VALUE_FROM = FND_API.G_MISS_CHAR THEN
481: l_Line_Adj_Att_rec.PRICING_ATTR_VALUE_FROM := Null;
482: END IF;
483:
484: IF l_Line_Adj_Att_rec.PRICING_ATTR_VALUE_TO = FND_API.G_MISS_CHAR THEN

Line 484: IF l_Line_Adj_Att_rec.PRICING_ATTR_VALUE_TO = FND_API.G_MISS_CHAR THEN

480: IF l_Line_Adj_Att_rec.PRICING_ATTR_VALUE_FROM = FND_API.G_MISS_CHAR THEN
481: l_Line_Adj_Att_rec.PRICING_ATTR_VALUE_FROM := Null;
482: END IF;
483:
484: IF l_Line_Adj_Att_rec.PRICING_ATTR_VALUE_TO = FND_API.G_MISS_CHAR THEN
485: l_Line_Adj_Att_rec.PRICING_ATTR_VALUE_TO := Null;
486: END IF;
487:
488: IF l_Line_Adj_Att_rec.COMPARISON_OPERATOR = FND_API.G_MISS_CHAR THEN

Line 488: IF l_Line_Adj_Att_rec.COMPARISON_OPERATOR = FND_API.G_MISS_CHAR THEN

484: IF l_Line_Adj_Att_rec.PRICING_ATTR_VALUE_TO = FND_API.G_MISS_CHAR THEN
485: l_Line_Adj_Att_rec.PRICING_ATTR_VALUE_TO := Null;
486: END IF;
487:
488: IF l_Line_Adj_Att_rec.COMPARISON_OPERATOR = FND_API.G_MISS_CHAR THEN
489: l_Line_Adj_Att_rec.COMPARISON_OPERATOR := Null;
490: END IF;
491:
492: IF l_Line_Adj_Att_rec.FLEX_TITLE = FND_API.G_MISS_CHAR THEN

Line 492: IF l_Line_Adj_Att_rec.FLEX_TITLE = FND_API.G_MISS_CHAR THEN

488: IF l_Line_Adj_Att_rec.COMPARISON_OPERATOR = FND_API.G_MISS_CHAR THEN
489: l_Line_Adj_Att_rec.COMPARISON_OPERATOR := Null;
490: END IF;
491:
492: IF l_Line_Adj_Att_rec.FLEX_TITLE = FND_API.G_MISS_CHAR THEN
493: l_Line_Adj_Att_rec.FLEX_TITLE := Null;
494: END IF;
495:
496: IF l_Line_Adj_Att_rec.PRICE_ADJ_ATTRIB_ID = FND_API.G_MISS_NUM THEN

Line 496: IF l_Line_Adj_Att_rec.PRICE_ADJ_ATTRIB_ID = FND_API.G_MISS_NUM THEN

492: IF l_Line_Adj_Att_rec.FLEX_TITLE = FND_API.G_MISS_CHAR THEN
493: l_Line_Adj_Att_rec.FLEX_TITLE := Null;
494: END IF;
495:
496: IF l_Line_Adj_Att_rec.PRICE_ADJ_ATTRIB_ID = FND_API.G_MISS_NUM THEN
497: l_Line_Adj_Att_rec.PRICE_ADJ_ATTRIB_ID := Null;
498: END IF;
499:
500: -- RETURN l_Line_Adj_Att_rec;

Line 526: , p_price_adj_attrib_id IN NUMBER := FND_API.G_MISS_NUM

522: PROCEDURE Lock_Row
523: ( x_return_status OUT NOCOPY VARCHAR2
524:
525: , p_x_Line_Adj_Att_rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Att_Rec_Type
526: , p_price_adj_attrib_id IN NUMBER := FND_API.G_MISS_NUM
527: )
528: is
529: l_Line_Adj_Att_rec OE_Order_PUB.Line_Adj_Att_Rec_Type;
530: l_lock_control NUMBER;

Line 545: IF p_price_adj_attrib_id <> FND_API.G_MISS_NUM THEN

541: SAVEPOINT Lock_Row;
542:
543: l_lock_control := NULL;
544:
545: IF p_price_adj_attrib_id <> FND_API.G_MISS_NUM THEN
546: l_price_adj_attrib_id := p_price_adj_attrib_id;
547: ELSE
548: l_price_adj_attrib_id := p_x_Line_Adj_Att_rec.price_adj_attrib_id;
549: l_lock_control := p_x_Line_Adj_Att_rec.lock_control;

Line 571: l_lock_control = FND_API.G_MISS_NUM

567:
568: -- If lock_control is not passed(is null or missing), then return the locked record.
569:
570: IF l_lock_control is null OR
571: l_lock_control = FND_API.G_MISS_NUM
572: THEN
573:
574: -- Set return status
575: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 575: x_return_status := FND_API.G_RET_STS_SUCCESS;

571: l_lock_control = FND_API.G_MISS_NUM
572: THEN
573:
574: -- Set return status
575: x_return_status := FND_API.G_RET_STS_SUCCESS;
576: p_x_Line_Adj_Att_rec.return_status := FND_API.G_RET_STS_SUCCESS;
577:
578: -- return for lock by ID.
579: RETURN;

Line 576: p_x_Line_Adj_Att_rec.return_status := FND_API.G_RET_STS_SUCCESS;

572: THEN
573:
574: -- Set return status
575: x_return_status := FND_API.G_RET_STS_SUCCESS;
576: p_x_Line_Adj_Att_rec.return_status := FND_API.G_RET_STS_SUCCESS;
577:
578: -- return for lock by ID.
579: RETURN;
580:

Line 602: x_return_status := FND_API.G_RET_STS_SUCCESS;

598: END IF;
599:
600: -- Set return status
601:
602: x_return_status := FND_API.G_RET_STS_SUCCESS;
603: p_x_Line_Adj_Att_rec.return_status := FND_API.G_RET_STS_SUCCESS;
604:
605: ELSE
606:

Line 603: p_x_Line_Adj_Att_rec.return_status := FND_API.G_RET_STS_SUCCESS;

599:
600: -- Set return status
601:
602: x_return_status := FND_API.G_RET_STS_SUCCESS;
603: p_x_Line_Adj_Att_rec.return_status := FND_API.G_RET_STS_SUCCESS;
604:
605: ELSE
606:
607: -- Row has changed by another user.

Line 612: x_return_status := FND_API.G_RET_STS_ERROR;

608: IF l_debug_level > 0 THEN
609: oe_debug_pub.add( 'ROW CHANGED BY OTHER USER' , 1 ) ;
610: END IF;
611:
612: x_return_status := FND_API.G_RET_STS_ERROR;
613: p_x_Line_Adj_Att_rec.return_status := FND_API.G_RET_STS_ERROR;
614:
615: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
616: THEN

Line 613: p_x_Line_Adj_Att_rec.return_status := FND_API.G_RET_STS_ERROR;

609: oe_debug_pub.add( 'ROW CHANGED BY OTHER USER' , 1 ) ;
610: END IF;
611:
612: x_return_status := FND_API.G_RET_STS_ERROR;
613: p_x_Line_Adj_Att_rec.return_status := FND_API.G_RET_STS_ERROR;
614:
615: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
616: THEN
617:

Line 632: x_return_status := FND_API.G_RET_STS_ERROR;

628: EXCEPTION
629:
630: WHEN NO_DATA_FOUND THEN
631:
632: x_return_status := FND_API.G_RET_STS_ERROR;
633: p_x_Line_Adj_Att_rec.return_status := FND_API.G_RET_STS_ERROR;
634:
635: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
636: THEN

Line 633: p_x_Line_Adj_Att_rec.return_status := FND_API.G_RET_STS_ERROR;

629:
630: WHEN NO_DATA_FOUND THEN
631:
632: x_return_status := FND_API.G_RET_STS_ERROR;
633: p_x_Line_Adj_Att_rec.return_status := FND_API.G_RET_STS_ERROR;
634:
635: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
636: THEN
637:

Line 644: x_return_status := FND_API.G_RET_STS_ERROR;

640:
641: END IF;
642: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
643:
644: x_return_status := FND_API.G_RET_STS_ERROR;
645: p_x_Line_Adj_Att_rec.return_status := FND_API.G_RET_STS_ERROR;
646:
647: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
648: THEN

Line 645: p_x_Line_Adj_Att_rec.return_status := FND_API.G_RET_STS_ERROR;

641: END IF;
642: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
643:
644: x_return_status := FND_API.G_RET_STS_ERROR;
645: p_x_Line_Adj_Att_rec.return_status := FND_API.G_RET_STS_ERROR;
646:
647: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
648: THEN
649:

Line 656: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

652:
653: END IF;
654: WHEN OTHERS THEN
655:
656: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
657: p_x_Line_Adj_Att_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
658:
659: end lock_row;
660:

Line 657: p_x_Line_Adj_Att_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;

653: END IF;
654: WHEN OTHERS THEN
655:
656: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
657: p_x_Line_Adj_Att_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
658:
659: end lock_row;
660:
661: -- procedure lock_rows

Line 664: := FND_API.G_MISS_NUM

660:
661: -- procedure lock_rows
662: PROCEDURE Lock_Rows
663: ( p_price_adj_attrib_id IN NUMBER
664: := FND_API.G_MISS_NUM
665: , p_price_adjustment_id IN NUMBER
666: := FND_API.G_MISS_NUM
667: , x_Line_Adj_Att_tbl OUT NOCOPY OE_Order_PUB.Line_Adj_Att_Tbl_Type
668: , x_return_status OUT NOCOPY VARCHAR2

Line 666: := FND_API.G_MISS_NUM

662: PROCEDURE Lock_Rows
663: ( p_price_adj_attrib_id IN NUMBER
664: := FND_API.G_MISS_NUM
665: , p_price_adjustment_id IN NUMBER
666: := FND_API.G_MISS_NUM
667: , x_Line_Adj_Att_tbl OUT NOCOPY OE_Order_PUB.Line_Adj_Att_Tbl_Type
668: , x_return_status OUT NOCOPY VARCHAR2
669:
670: )

Line 693: p_price_adj_attrib_id <> FND_API.G_MISS_NUM) AND

689: oe_debug_pub.add( 'ENTERING OE_LINE_PRICE_AATTR_UTIL.LOCK_ROWS.' , 1 ) ;
690: END IF;
691:
692: IF (p_price_adj_attrib_id IS NOT NULL AND
693: p_price_adj_attrib_id <> FND_API.G_MISS_NUM) AND
694: (p_price_adjustment_id IS NOT NULL AND
695: p_price_adjustment_id <> FND_API.G_MISS_NUM)
696: THEN
697: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 695: p_price_adjustment_id <> FND_API.G_MISS_NUM)

691:
692: IF (p_price_adj_attrib_id IS NOT NULL AND
693: p_price_adj_attrib_id <> FND_API.G_MISS_NUM) AND
694: (p_price_adjustment_id IS NOT NULL AND
695: p_price_adjustment_id <> FND_API.G_MISS_NUM)
696: THEN
697: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
698: OE_MSG_PUB.Add_Exc_Msg
699: ( G_PKG_NAME

Line 705: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

701: , 'Keys are mutually exclusive: price_adj_attrib_id = ' ||
702: p_price_adj_attrib_id || ', price_adjustment_id = ' || p_price_adjustment_id );
703: END IF;
704:
705: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
706: END IF;
707:
708: IF p_price_adj_attrib_id <> FND_API.G_MISS_NUM THEN
709:

Line 708: IF p_price_adj_attrib_id <> FND_API.G_MISS_NUM THEN

704:
705: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
706: END IF;
707:
708: IF p_price_adj_attrib_id <> FND_API.G_MISS_NUM THEN
709:
710: SELECT price_adj_attrib_id
711: INTO l_price_adj_attrib_id
712: FROM oe_price_adj_attribs

Line 720: IF p_price_adjustment_id <> FND_API.G_MISS_NUM THEN

716:
717: -- null price_adjustment_id shouldn't be passed in unnecessarily if
718: -- price_adj_attrib_id is passed in already.
719: BEGIN
720: IF p_price_adjustment_id <> FND_API.G_MISS_NUM THEN
721: SAVEPOINT LOCK_ROWS;
722: OPEN lock_att_lines(p_price_adjustment_id);
723:
724: LOOP

Line 748: x_return_status := FND_API.G_RET_STS_SUCCESS;

744: , p_price_adjustment_id => p_price_adjustment_id
745: , x_Line_Adj_Att_tbl => x_Line_Adj_Att_tbl
746: );
747:
748: x_return_status := FND_API.G_RET_STS_SUCCESS;
749:
750: EXCEPTION
751: WHEN NO_DATA_FOUND THEN
752: x_return_status := FND_API.G_RET_STS_ERROR;

Line 752: x_return_status := FND_API.G_RET_STS_ERROR;

748: x_return_status := FND_API.G_RET_STS_SUCCESS;
749:
750: EXCEPTION
751: WHEN NO_DATA_FOUND THEN
752: x_return_status := FND_API.G_RET_STS_ERROR;
753: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
754: THEN
755: fnd_message.set_name('ONT','OE_LOCK_ROW_DELETED');
756: OE_MSG_PUB.Add;

Line 760: x_return_status := FND_API.G_RET_STS_ERROR;

756: OE_MSG_PUB.Add;
757: END IF;
758:
759: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
760: x_return_status := FND_API.G_RET_STS_ERROR;
761: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
762: THEN
763: fnd_message.set_name('ONT','OE_LOCK_ROW_ALREADY_LOCKED');
764: OE_MSG_PUB.Add;

Line 768: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

764: OE_MSG_PUB.Add;
765: END IF;
766:
767: WHEN OTHERS THEN
768: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
769: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
770: THEN
771: OE_MSG_PUB.Add_Exc_Msg
772: ( G_PKG_NAME