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_ADJ_ASSOCS_UTIL dependencies on FND_API

Line 30: FND_API.G_MISS_NUM

26:
27:
28: PROCEDURE Query_Rows
29: ( p_price_adj_Assoc_id IN NUMBER :=
30: FND_API.G_MISS_NUM
31: , p_price_adjustment_id IN NUMBER :=
32: FND_API.G_MISS_NUM
33: , x_Line_Adj_Assoc_Tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
34: )

Line 32: FND_API.G_MISS_NUM

28: PROCEDURE Query_Rows
29: ( p_price_adj_Assoc_id IN NUMBER :=
30: FND_API.G_MISS_NUM
31: , p_price_adjustment_id IN NUMBER :=
32: FND_API.G_MISS_NUM
33: , x_Line_Adj_Assoc_Tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
34: )
35: IS
36: l_count NUMBER;

Line 82: x_Line_Adj_Assoc_Tbl(l_count).db_flag := FND_API.G_TRUE;

78: x_Line_Adj_Assoc_Tbl(l_count).RLTD_PRICE_ADJ_ID := iml_rec.RLTD_PRICE_ADJ_ID;
79: x_Line_Adj_Assoc_Tbl(l_count).LOCK_CONTROL := iml_rec.LOCK_CONTROL;
80:
81: -- set values for non-DB fields
82: x_Line_Adj_Assoc_Tbl(l_count).db_flag := FND_API.G_TRUE;
83: x_Line_Adj_Assoc_Tbl(l_count).operation := FND_API.G_MISS_CHAR;
84: x_Line_Adj_Assoc_Tbl(l_count).return_status := FND_API.G_MISS_CHAR;
85:
86: l_count := l_count + 1;

Line 83: x_Line_Adj_Assoc_Tbl(l_count).operation := FND_API.G_MISS_CHAR;

79: x_Line_Adj_Assoc_Tbl(l_count).LOCK_CONTROL := iml_rec.LOCK_CONTROL;
80:
81: -- set values for non-DB fields
82: x_Line_Adj_Assoc_Tbl(l_count).db_flag := FND_API.G_TRUE;
83: x_Line_Adj_Assoc_Tbl(l_count).operation := FND_API.G_MISS_CHAR;
84: x_Line_Adj_Assoc_Tbl(l_count).return_status := FND_API.G_MISS_CHAR;
85:
86: l_count := l_count + 1;
87:

Line 84: x_Line_Adj_Assoc_Tbl(l_count).return_status := FND_API.G_MISS_CHAR;

80:
81: -- set values for non-DB fields
82: x_Line_Adj_Assoc_Tbl(l_count).db_flag := FND_API.G_TRUE;
83: x_Line_Adj_Assoc_Tbl(l_count).operation := FND_API.G_MISS_CHAR;
84: x_Line_Adj_Assoc_Tbl(l_count).return_status := FND_API.G_MISS_CHAR;
85:
86: l_count := l_count + 1;
87:
88: END LOOP;

Line 91: and p_price_adj_Assoc_id <> FND_API.G_MISS_NUM)

87:
88: END LOOP;
89:
90: IF ( p_price_adj_Assoc_id IS NOT NULL
91: and p_price_adj_Assoc_id <> FND_API.G_MISS_NUM)
92: AND
93: (x_Line_Adj_Assoc_tbl.COUNT = 0 )
94: THEN
95: RAISE NO_DATA_FOUND;

Line 103: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

99: -- RETURN l_Line_Adj_Assoc_tbl;
100:
101: EXCEPTION
102:
103: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
104:
105: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
106:
107: WHEN OTHERS THEN

Line 105: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

101: EXCEPTION
102:
103: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
104:
105: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
106:
107: WHEN OTHERS THEN
108:
109: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 117: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

113: , 'Query_Rows'
114: );
115: END IF;
116:
117: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
118:
119: END Query_Rows;
120:
121: PROCEDURE Insert_Row

Line 178: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

174: ( G_PKG_NAME
175: , 'Insert_Row'
176: );
177: END IF;
178: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
179:
180: END Insert_Row;
181:
182: PROCEDURE Update_Row

Line 230: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

226: ( G_PKG_NAME
227: , 'Update_Row'
228: );
229: END IF;
230: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
231:
232:
233:
234: END Update_Row ;

Line 237: ( p_price_adj_Assoc_id NUMBER := FND_API.G_MISS_NUM

233:
234: END Update_Row ;
235:
236: PROCEDURE Delete_Row
237: ( p_price_adj_Assoc_id NUMBER := FND_API.G_MISS_NUM
238: , p_price_adjustment_id NUMBER := FND_API.G_MISS_NUM
239: )
240: IS
241: --

Line 238: , p_price_adjustment_id NUMBER := FND_API.G_MISS_NUM

234: END Update_Row ;
235:
236: PROCEDURE Delete_Row
237: ( p_price_adj_Assoc_id NUMBER := FND_API.G_MISS_NUM
238: , p_price_adjustment_id NUMBER := FND_API.G_MISS_NUM
239: )
240: IS
241: --
242: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 245: IF p_price_adjustment_id <> FND_API.G_MISS_NUM then

241: --
242: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
243: --
244: BEGIN
245: IF p_price_adjustment_id <> FND_API.G_MISS_NUM then
246: IF l_debug_level > 0 THEN
247: oe_debug_pub.add( 'PRICE ADJ: DELETE ROW OE_LINE_ADJ_ASSOCS_UTIL' , 5 ) ;
248: END IF;
249: --Modified the below delete statement to fix bug 2626303

Line 271: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

267: ( G_PKG_NAME
268: , 'Delete_Row- '||sqlerrm
269: );
270: END IF;
271: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
272: END Delete_Row;
273:
274: PROCEDURE Complete_Record
275: ( p_x_Line_Adj_Assoc_Rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Assoc_Rec_Type

Line 286: IF l_Line_Adj_Assoc_Rec.RLTD_PRICE_ADJ_ID = FND_API.G_MISS_NUM THEN

282: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
283: --
284: BEGIN
285:
286: IF l_Line_Adj_Assoc_Rec.RLTD_PRICE_ADJ_ID = FND_API.G_MISS_NUM THEN
287: l_Line_Adj_Assoc_Rec.RLTD_PRICE_ADJ_ID := p_old_Line_Adj_Assoc_Rec.RLTD_PRICE_ADJ_ID;
288: END IF;
289:
290:

Line 291: IF l_Line_Adj_Assoc_Rec.PRICE_ADJUSTMENT_ID = FND_API.G_MISS_NUM THEN

287: l_Line_Adj_Assoc_Rec.RLTD_PRICE_ADJ_ID := p_old_Line_Adj_Assoc_Rec.RLTD_PRICE_ADJ_ID;
288: END IF;
289:
290:
291: IF l_Line_Adj_Assoc_Rec.PRICE_ADJUSTMENT_ID = FND_API.G_MISS_NUM THEN
292: l_Line_Adj_Assoc_Rec.PRICE_ADJUSTMENT_ID := p_old_Line_Adj_Assoc_Rec.PRICE_ADJUSTMENT_ID;
293: END IF;
294:
295: IF l_Line_Adj_Assoc_Rec.CREATION_DATE = FND_API.G_MISS_DATE THEN

Line 295: IF l_Line_Adj_Assoc_Rec.CREATION_DATE = FND_API.G_MISS_DATE THEN

291: IF l_Line_Adj_Assoc_Rec.PRICE_ADJUSTMENT_ID = FND_API.G_MISS_NUM THEN
292: l_Line_Adj_Assoc_Rec.PRICE_ADJUSTMENT_ID := p_old_Line_Adj_Assoc_Rec.PRICE_ADJUSTMENT_ID;
293: END IF;
294:
295: IF l_Line_Adj_Assoc_Rec.CREATION_DATE = FND_API.G_MISS_DATE THEN
296: l_Line_Adj_Assoc_Rec.CREATION_DATE := p_old_Line_Adj_Assoc_Rec.CREATION_DATE;
297: END IF;
298:
299: IF l_Line_Adj_Assoc_Rec.CREATED_BY = FND_API.G_MISS_NUM THEN

Line 299: IF l_Line_Adj_Assoc_Rec.CREATED_BY = FND_API.G_MISS_NUM THEN

295: IF l_Line_Adj_Assoc_Rec.CREATION_DATE = FND_API.G_MISS_DATE THEN
296: l_Line_Adj_Assoc_Rec.CREATION_DATE := p_old_Line_Adj_Assoc_Rec.CREATION_DATE;
297: END IF;
298:
299: IF l_Line_Adj_Assoc_Rec.CREATED_BY = FND_API.G_MISS_NUM THEN
300: l_Line_Adj_Assoc_Rec.CREATED_BY := p_old_Line_Adj_Assoc_Rec.CREATED_BY;
301: END IF;
302:
303: IF l_Line_Adj_Assoc_Rec.LAST_UPDATE_DATE = FND_API.G_MISS_DATE THEN

Line 303: IF l_Line_Adj_Assoc_Rec.LAST_UPDATE_DATE = FND_API.G_MISS_DATE THEN

299: IF l_Line_Adj_Assoc_Rec.CREATED_BY = FND_API.G_MISS_NUM THEN
300: l_Line_Adj_Assoc_Rec.CREATED_BY := p_old_Line_Adj_Assoc_Rec.CREATED_BY;
301: END IF;
302:
303: IF l_Line_Adj_Assoc_Rec.LAST_UPDATE_DATE = FND_API.G_MISS_DATE THEN
304: l_Line_Adj_Assoc_Rec.LAST_UPDATE_DATE := p_old_Line_Adj_Assoc_Rec.LAST_UPDATE_DATE;
305: END IF;
306:
307: IF l_Line_Adj_Assoc_Rec.LAST_UPDATED_BY = FND_API.G_MISS_NUM THEN

Line 307: IF l_Line_Adj_Assoc_Rec.LAST_UPDATED_BY = FND_API.G_MISS_NUM THEN

303: IF l_Line_Adj_Assoc_Rec.LAST_UPDATE_DATE = FND_API.G_MISS_DATE THEN
304: l_Line_Adj_Assoc_Rec.LAST_UPDATE_DATE := p_old_Line_Adj_Assoc_Rec.LAST_UPDATE_DATE;
305: END IF;
306:
307: IF l_Line_Adj_Assoc_Rec.LAST_UPDATED_BY = FND_API.G_MISS_NUM THEN
308: l_Line_Adj_Assoc_Rec.LAST_UPDATED_BY := p_old_Line_Adj_Assoc_Rec.LAST_UPDATED_BY;
309: END IF;
310:
311: IF l_Line_Adj_Assoc_Rec.LAST_UPDATE_LOGIN = FND_API.G_MISS_NUM THEN

Line 311: IF l_Line_Adj_Assoc_Rec.LAST_UPDATE_LOGIN = FND_API.G_MISS_NUM THEN

307: IF l_Line_Adj_Assoc_Rec.LAST_UPDATED_BY = FND_API.G_MISS_NUM THEN
308: l_Line_Adj_Assoc_Rec.LAST_UPDATED_BY := p_old_Line_Adj_Assoc_Rec.LAST_UPDATED_BY;
309: END IF;
310:
311: IF l_Line_Adj_Assoc_Rec.LAST_UPDATE_LOGIN = FND_API.G_MISS_NUM THEN
312: l_Line_Adj_Assoc_Rec.LAST_UPDATE_LOGIN := p_old_Line_Adj_Assoc_Rec.LAST_UPDATE_LOGIN;
313: END IF;
314:
315: IF l_Line_Adj_Assoc_Rec.PROGRAM_APPLICATION_ID = FND_API.G_MISS_NUM THEN

Line 315: IF l_Line_Adj_Assoc_Rec.PROGRAM_APPLICATION_ID = FND_API.G_MISS_NUM THEN

311: IF l_Line_Adj_Assoc_Rec.LAST_UPDATE_LOGIN = FND_API.G_MISS_NUM THEN
312: l_Line_Adj_Assoc_Rec.LAST_UPDATE_LOGIN := p_old_Line_Adj_Assoc_Rec.LAST_UPDATE_LOGIN;
313: END IF;
314:
315: IF l_Line_Adj_Assoc_Rec.PROGRAM_APPLICATION_ID = FND_API.G_MISS_NUM THEN
316: l_Line_Adj_Assoc_Rec.PROGRAM_APPLICATION_ID := p_old_Line_Adj_Assoc_Rec.PROGRAM_APPLICATION_ID;
317: END IF;
318:
319: IF l_Line_Adj_Assoc_Rec.PROGRAM_ID = FND_API.G_MISS_NUM THEN

Line 319: IF l_Line_Adj_Assoc_Rec.PROGRAM_ID = FND_API.G_MISS_NUM THEN

315: IF l_Line_Adj_Assoc_Rec.PROGRAM_APPLICATION_ID = FND_API.G_MISS_NUM THEN
316: l_Line_Adj_Assoc_Rec.PROGRAM_APPLICATION_ID := p_old_Line_Adj_Assoc_Rec.PROGRAM_APPLICATION_ID;
317: END IF;
318:
319: IF l_Line_Adj_Assoc_Rec.PROGRAM_ID = FND_API.G_MISS_NUM THEN
320: l_Line_Adj_Assoc_Rec.PROGRAM_ID := p_old_Line_Adj_Assoc_Rec.PROGRAM_ID;
321: END IF;
322:
323: IF l_Line_Adj_Assoc_Rec.PROGRAM_UPDATE_DATE = FND_API.G_MISS_DATE THEN

Line 323: IF l_Line_Adj_Assoc_Rec.PROGRAM_UPDATE_DATE = FND_API.G_MISS_DATE THEN

319: IF l_Line_Adj_Assoc_Rec.PROGRAM_ID = FND_API.G_MISS_NUM THEN
320: l_Line_Adj_Assoc_Rec.PROGRAM_ID := p_old_Line_Adj_Assoc_Rec.PROGRAM_ID;
321: END IF;
322:
323: IF l_Line_Adj_Assoc_Rec.PROGRAM_UPDATE_DATE = FND_API.G_MISS_DATE THEN
324: l_Line_Adj_Assoc_Rec.PROGRAM_UPDATE_DATE := p_old_Line_Adj_Assoc_Rec.PROGRAM_UPDATE_DATE;
325: END IF;
326:
327: IF l_Line_Adj_Assoc_Rec.REQUEST_ID = FND_API.G_MISS_NUM THEN

Line 327: IF l_Line_Adj_Assoc_Rec.REQUEST_ID = FND_API.G_MISS_NUM THEN

323: IF l_Line_Adj_Assoc_Rec.PROGRAM_UPDATE_DATE = FND_API.G_MISS_DATE THEN
324: l_Line_Adj_Assoc_Rec.PROGRAM_UPDATE_DATE := p_old_Line_Adj_Assoc_Rec.PROGRAM_UPDATE_DATE;
325: END IF;
326:
327: IF l_Line_Adj_Assoc_Rec.REQUEST_ID = FND_API.G_MISS_NUM THEN
328: l_Line_Adj_Assoc_Rec.REQUEST_ID := p_old_Line_Adj_Assoc_Rec.REQUEST_ID;
329: END IF;
330:
331: IF l_Line_Adj_Assoc_Rec.PRICE_ADJ_ASSOC_ID = FND_API.G_MISS_NUM THEN

Line 331: IF l_Line_Adj_Assoc_Rec.PRICE_ADJ_ASSOC_ID = FND_API.G_MISS_NUM THEN

327: IF l_Line_Adj_Assoc_Rec.REQUEST_ID = FND_API.G_MISS_NUM THEN
328: l_Line_Adj_Assoc_Rec.REQUEST_ID := p_old_Line_Adj_Assoc_Rec.REQUEST_ID;
329: END IF;
330:
331: IF l_Line_Adj_Assoc_Rec.PRICE_ADJ_ASSOC_ID = FND_API.G_MISS_NUM THEN
332: l_Line_Adj_Assoc_Rec.PRICE_ADJ_ASSOC_ID := p_old_Line_Adj_Assoc_Rec.PRICE_ADJ_ASSOC_ID;
333: END IF;
334:
335: IF l_Line_Adj_Assoc_Rec.LINE_ID = FND_API.G_MISS_NUM THEN

Line 335: IF l_Line_Adj_Assoc_Rec.LINE_ID = FND_API.G_MISS_NUM THEN

331: IF l_Line_Adj_Assoc_Rec.PRICE_ADJ_ASSOC_ID = FND_API.G_MISS_NUM THEN
332: l_Line_Adj_Assoc_Rec.PRICE_ADJ_ASSOC_ID := p_old_Line_Adj_Assoc_Rec.PRICE_ADJ_ASSOC_ID;
333: END IF;
334:
335: IF l_Line_Adj_Assoc_Rec.LINE_ID = FND_API.G_MISS_NUM THEN
336: l_Line_Adj_Assoc_Rec.LINE_ID := p_old_Line_Adj_Assoc_Rec.LINE_ID;
337: END IF;
338:
339: -- RETURN l_Line_Adj_Assoc_Rec;

Line 354: IF l_Line_Adj_Assoc_Rec.RLTD_PRICE_ADJ_ID = FND_API.G_MISS_NUM THEN

350: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
351: --
352: BEGIN
353:
354: IF l_Line_Adj_Assoc_Rec.RLTD_PRICE_ADJ_ID = FND_API.G_MISS_NUM THEN
355: l_Line_Adj_Assoc_Rec.RLTD_PRICE_ADJ_ID := Null;
356: END IF;
357:
358: IF l_Line_Adj_Assoc_Rec.PRICE_ADJUSTMENT_ID = FND_API.G_MISS_NUM THEN

Line 358: IF l_Line_Adj_Assoc_Rec.PRICE_ADJUSTMENT_ID = FND_API.G_MISS_NUM THEN

354: IF l_Line_Adj_Assoc_Rec.RLTD_PRICE_ADJ_ID = FND_API.G_MISS_NUM THEN
355: l_Line_Adj_Assoc_Rec.RLTD_PRICE_ADJ_ID := Null;
356: END IF;
357:
358: IF l_Line_Adj_Assoc_Rec.PRICE_ADJUSTMENT_ID = FND_API.G_MISS_NUM THEN
359: l_Line_Adj_Assoc_Rec.PRICE_ADJUSTMENT_ID := Null;
360: END IF;
361:
362: IF l_Line_Adj_Assoc_Rec.CREATION_DATE = FND_API.G_MISS_DATE THEN

Line 362: IF l_Line_Adj_Assoc_Rec.CREATION_DATE = FND_API.G_MISS_DATE THEN

358: IF l_Line_Adj_Assoc_Rec.PRICE_ADJUSTMENT_ID = FND_API.G_MISS_NUM THEN
359: l_Line_Adj_Assoc_Rec.PRICE_ADJUSTMENT_ID := Null;
360: END IF;
361:
362: IF l_Line_Adj_Assoc_Rec.CREATION_DATE = FND_API.G_MISS_DATE THEN
363: l_Line_Adj_Assoc_Rec.CREATION_DATE := Null;
364: END IF;
365:
366: IF l_Line_Adj_Assoc_Rec.CREATED_BY = FND_API.G_MISS_NUM THEN

Line 366: IF l_Line_Adj_Assoc_Rec.CREATED_BY = FND_API.G_MISS_NUM THEN

362: IF l_Line_Adj_Assoc_Rec.CREATION_DATE = FND_API.G_MISS_DATE THEN
363: l_Line_Adj_Assoc_Rec.CREATION_DATE := Null;
364: END IF;
365:
366: IF l_Line_Adj_Assoc_Rec.CREATED_BY = FND_API.G_MISS_NUM THEN
367: l_Line_Adj_Assoc_Rec.CREATED_BY := Null;
368: END IF;
369:
370: IF l_Line_Adj_Assoc_Rec.LAST_UPDATE_DATE = FND_API.G_MISS_DATE THEN

Line 370: IF l_Line_Adj_Assoc_Rec.LAST_UPDATE_DATE = FND_API.G_MISS_DATE THEN

366: IF l_Line_Adj_Assoc_Rec.CREATED_BY = FND_API.G_MISS_NUM THEN
367: l_Line_Adj_Assoc_Rec.CREATED_BY := Null;
368: END IF;
369:
370: IF l_Line_Adj_Assoc_Rec.LAST_UPDATE_DATE = FND_API.G_MISS_DATE THEN
371: l_Line_Adj_Assoc_Rec.LAST_UPDATE_DATE := Null;
372: END IF;
373:
374: IF l_Line_Adj_Assoc_Rec.LAST_UPDATED_BY = FND_API.G_MISS_NUM THEN

Line 374: IF l_Line_Adj_Assoc_Rec.LAST_UPDATED_BY = FND_API.G_MISS_NUM THEN

370: IF l_Line_Adj_Assoc_Rec.LAST_UPDATE_DATE = FND_API.G_MISS_DATE THEN
371: l_Line_Adj_Assoc_Rec.LAST_UPDATE_DATE := Null;
372: END IF;
373:
374: IF l_Line_Adj_Assoc_Rec.LAST_UPDATED_BY = FND_API.G_MISS_NUM THEN
375: l_Line_Adj_Assoc_Rec.LAST_UPDATED_BY := Null;
376: END IF;
377:
378: IF l_Line_Adj_Assoc_Rec.LAST_UPDATE_LOGIN = FND_API.G_MISS_NUM THEN

Line 378: IF l_Line_Adj_Assoc_Rec.LAST_UPDATE_LOGIN = FND_API.G_MISS_NUM THEN

374: IF l_Line_Adj_Assoc_Rec.LAST_UPDATED_BY = FND_API.G_MISS_NUM THEN
375: l_Line_Adj_Assoc_Rec.LAST_UPDATED_BY := Null;
376: END IF;
377:
378: IF l_Line_Adj_Assoc_Rec.LAST_UPDATE_LOGIN = FND_API.G_MISS_NUM THEN
379: l_Line_Adj_Assoc_Rec.LAST_UPDATE_LOGIN := Null;
380: END IF;
381:
382: IF l_Line_Adj_Assoc_Rec.PROGRAM_APPLICATION_ID = FND_API.G_MISS_NUM THEN

Line 382: IF l_Line_Adj_Assoc_Rec.PROGRAM_APPLICATION_ID = FND_API.G_MISS_NUM THEN

378: IF l_Line_Adj_Assoc_Rec.LAST_UPDATE_LOGIN = FND_API.G_MISS_NUM THEN
379: l_Line_Adj_Assoc_Rec.LAST_UPDATE_LOGIN := Null;
380: END IF;
381:
382: IF l_Line_Adj_Assoc_Rec.PROGRAM_APPLICATION_ID = FND_API.G_MISS_NUM THEN
383: l_Line_Adj_Assoc_Rec.PROGRAM_APPLICATION_ID := Null;
384: END IF;
385:
386: IF l_Line_Adj_Assoc_Rec.PROGRAM_ID = FND_API.G_MISS_NUM THEN

Line 386: IF l_Line_Adj_Assoc_Rec.PROGRAM_ID = FND_API.G_MISS_NUM THEN

382: IF l_Line_Adj_Assoc_Rec.PROGRAM_APPLICATION_ID = FND_API.G_MISS_NUM THEN
383: l_Line_Adj_Assoc_Rec.PROGRAM_APPLICATION_ID := Null;
384: END IF;
385:
386: IF l_Line_Adj_Assoc_Rec.PROGRAM_ID = FND_API.G_MISS_NUM THEN
387: l_Line_Adj_Assoc_Rec.PROGRAM_ID := Null;
388: END IF;
389:
390: IF l_Line_Adj_Assoc_Rec.PROGRAM_UPDATE_DATE = FND_API.G_MISS_DATE THEN

Line 390: IF l_Line_Adj_Assoc_Rec.PROGRAM_UPDATE_DATE = FND_API.G_MISS_DATE THEN

386: IF l_Line_Adj_Assoc_Rec.PROGRAM_ID = FND_API.G_MISS_NUM THEN
387: l_Line_Adj_Assoc_Rec.PROGRAM_ID := Null;
388: END IF;
389:
390: IF l_Line_Adj_Assoc_Rec.PROGRAM_UPDATE_DATE = FND_API.G_MISS_DATE THEN
391: l_Line_Adj_Assoc_Rec.PROGRAM_UPDATE_DATE := Null;
392: END IF;
393:
394: IF l_Line_Adj_Assoc_Rec.REQUEST_ID = FND_API.G_MISS_NUM THEN

Line 394: IF l_Line_Adj_Assoc_Rec.REQUEST_ID = FND_API.G_MISS_NUM THEN

390: IF l_Line_Adj_Assoc_Rec.PROGRAM_UPDATE_DATE = FND_API.G_MISS_DATE THEN
391: l_Line_Adj_Assoc_Rec.PROGRAM_UPDATE_DATE := Null;
392: END IF;
393:
394: IF l_Line_Adj_Assoc_Rec.REQUEST_ID = FND_API.G_MISS_NUM THEN
395: l_Line_Adj_Assoc_Rec.REQUEST_ID := Null;
396: END IF;
397:
398: IF l_Line_Adj_Assoc_Rec.PRICE_ADJ_ASSOC_ID = FND_API.G_MISS_NUM THEN

Line 398: IF l_Line_Adj_Assoc_Rec.PRICE_ADJ_ASSOC_ID = FND_API.G_MISS_NUM THEN

394: IF l_Line_Adj_Assoc_Rec.REQUEST_ID = FND_API.G_MISS_NUM THEN
395: l_Line_Adj_Assoc_Rec.REQUEST_ID := Null;
396: END IF;
397:
398: IF l_Line_Adj_Assoc_Rec.PRICE_ADJ_ASSOC_ID = FND_API.G_MISS_NUM THEN
399: l_Line_Adj_Assoc_Rec.PRICE_ADJ_ASSOC_ID := Null;
400: END IF;
401:
402: IF l_Line_Adj_Assoc_Rec.LINE_ID = FND_API.G_MISS_NUM THEN

Line 402: IF l_Line_Adj_Assoc_Rec.LINE_ID = FND_API.G_MISS_NUM THEN

398: IF l_Line_Adj_Assoc_Rec.PRICE_ADJ_ASSOC_ID = FND_API.G_MISS_NUM THEN
399: l_Line_Adj_Assoc_Rec.PRICE_ADJ_ASSOC_ID := Null;
400: END IF;
401:
402: IF l_Line_Adj_Assoc_Rec.LINE_ID = FND_API.G_MISS_NUM THEN
403: l_Line_Adj_Assoc_Rec.LINE_ID := Null;
404: END IF;
405:
406: -- RETURN l_Line_Adj_Assoc_Rec;

Line 431: , p_price_adj_assoc_id IN NUMBER := FND_API.G_MISS_NUM

427: PROCEDURE Lock_Row
428: ( x_return_status OUT NOCOPY VARCHAR2
429:
430: , p_x_Line_Adj_Assoc_Rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Assoc_Rec_Type
431: , p_price_adj_assoc_id IN NUMBER := FND_API.G_MISS_NUM
432: -- , x_Line_Adj_Assoc_Rec OUT OE_Order_PUB.Line_Adj_Assoc_Rec_Type
433: )
434: is
435: l_Line_Adj_Assoc_Rec OE_Order_PUB.Line_Adj_Assoc_Rec_Type;

Line 451: IF p_price_adj_assoc_id <> FND_API.G_MISS_NUM THEN

447: SAVEPOINT Lock_Row;
448:
449: l_lock_control := NULL;
450:
451: IF p_price_adj_assoc_id <> FND_API.G_MISS_NUM THEN
452: l_price_adj_assoc_id := p_price_adj_assoc_id;
453: ELSE
454: l_price_adj_assoc_id := p_x_Line_Adj_Assoc_rec.price_adj_assoc_id;
455: l_lock_control := p_x_Line_Adj_Assoc_rec.lock_control;

Line 477: l_lock_control = FND_API.G_MISS_NUM

473:
474: -- If lock_control is not passed(is null or missing), then return the locked record.
475:
476: IF l_lock_control is null OR
477: l_lock_control = FND_API.G_MISS_NUM
478: THEN
479:
480: -- Set return status
481: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 481: x_return_status := FND_API.G_RET_STS_SUCCESS;

477: l_lock_control = FND_API.G_MISS_NUM
478: THEN
479:
480: -- Set return status
481: x_return_status := FND_API.G_RET_STS_SUCCESS;
482: p_x_Line_Adj_Assoc_rec.return_status := FND_API.G_RET_STS_SUCCESS;
483:
484: -- return for lock by ID.
485: RETURN;

Line 482: p_x_Line_Adj_Assoc_rec.return_status := FND_API.G_RET_STS_SUCCESS;

478: THEN
479:
480: -- Set return status
481: x_return_status := FND_API.G_RET_STS_SUCCESS;
482: p_x_Line_Adj_Assoc_rec.return_status := FND_API.G_RET_STS_SUCCESS;
483:
484: -- return for lock by ID.
485: RETURN;
486:

Line 508: x_return_status := FND_API.G_RET_STS_SUCCESS;

504: END IF;
505:
506: -- Set return status
507:
508: x_return_status := FND_API.G_RET_STS_SUCCESS;
509: p_x_Line_Adj_Assoc_rec.return_status := FND_API.G_RET_STS_SUCCESS;
510:
511: ELSE
512:

Line 509: p_x_Line_Adj_Assoc_rec.return_status := FND_API.G_RET_STS_SUCCESS;

505:
506: -- Set return status
507:
508: x_return_status := FND_API.G_RET_STS_SUCCESS;
509: p_x_Line_Adj_Assoc_rec.return_status := FND_API.G_RET_STS_SUCCESS;
510:
511: ELSE
512:
513: -- Row has changed by another user.

Line 518: x_return_status := FND_API.G_RET_STS_ERROR;

514: IF l_debug_level > 0 THEN
515: oe_debug_pub.add( 'ROW CHANGED BY OTHER USER' , 1 ) ;
516: END IF;
517:
518: x_return_status := FND_API.G_RET_STS_ERROR;
519: p_x_Line_Adj_Assoc_rec.return_status := FND_API.G_RET_STS_ERROR;
520:
521: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
522: THEN

Line 519: p_x_Line_Adj_Assoc_rec.return_status := FND_API.G_RET_STS_ERROR;

515: oe_debug_pub.add( 'ROW CHANGED BY OTHER USER' , 1 ) ;
516: END IF;
517:
518: x_return_status := FND_API.G_RET_STS_ERROR;
519: p_x_Line_Adj_Assoc_rec.return_status := FND_API.G_RET_STS_ERROR;
520:
521: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
522: THEN
523:

Line 539: x_return_status := FND_API.G_RET_STS_ERROR;

535: EXCEPTION
536:
537: WHEN NO_DATA_FOUND THEN
538:
539: x_return_status := FND_API.G_RET_STS_ERROR;
540: p_x_Line_Adj_Assoc_Rec.return_status := FND_API.G_RET_STS_ERROR;
541:
542: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
543: THEN

Line 540: p_x_Line_Adj_Assoc_Rec.return_status := FND_API.G_RET_STS_ERROR;

536:
537: WHEN NO_DATA_FOUND THEN
538:
539: x_return_status := FND_API.G_RET_STS_ERROR;
540: p_x_Line_Adj_Assoc_Rec.return_status := FND_API.G_RET_STS_ERROR;
541:
542: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
543: THEN
544:

Line 551: x_return_status := FND_API.G_RET_STS_ERROR;

547:
548: END IF;
549: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
550:
551: x_return_status := FND_API.G_RET_STS_ERROR;
552: p_x_Line_Adj_Assoc_Rec.return_status := FND_API.G_RET_STS_ERROR;
553:
554: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
555: THEN

Line 552: p_x_Line_Adj_Assoc_Rec.return_status := FND_API.G_RET_STS_ERROR;

548: END IF;
549: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
550:
551: x_return_status := FND_API.G_RET_STS_ERROR;
552: p_x_Line_Adj_Assoc_Rec.return_status := FND_API.G_RET_STS_ERROR;
553:
554: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
555: THEN
556:

Line 563: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

559:
560: END IF;
561: WHEN OTHERS THEN
562:
563: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
564: p_x_Line_Adj_Assoc_Rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
565:
566: end lock_row;
567:

Line 564: p_x_Line_Adj_Assoc_Rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;

560: END IF;
561: WHEN OTHERS THEN
562:
563: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
564: p_x_Line_Adj_Assoc_Rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
565:
566: end lock_row;
567:
568: -- procedure lock_rows

Line 571: := FND_API.G_MISS_NUM

567:
568: -- procedure lock_rows
569: PROCEDURE Lock_Rows
570: ( p_price_adj_assoc_id IN NUMBER
571: := FND_API.G_MISS_NUM
572: , p_price_adjustment_id IN NUMBER
573: := FND_API.G_MISS_NUM
574: , x_Line_Adj_Assoc_tbl OUT NOCOPY OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
575: , x_return_status OUT NOCOPY VARCHAR2

Line 573: := FND_API.G_MISS_NUM

569: PROCEDURE Lock_Rows
570: ( p_price_adj_assoc_id IN NUMBER
571: := FND_API.G_MISS_NUM
572: , p_price_adjustment_id IN NUMBER
573: := FND_API.G_MISS_NUM
574: , x_Line_Adj_Assoc_tbl OUT NOCOPY OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
575: , x_return_status OUT NOCOPY VARCHAR2
576:
577: )

Line 600: p_price_adj_assoc_id <> FND_API.G_MISS_NUM) AND

596: oe_debug_pub.add( 'ENTERING OE_LINE_ADJ_ASSOCS_UTIL.LOCK_ROWS.' , 1 ) ;
597: END IF;
598:
599: IF (p_price_adj_assoc_id IS NOT NULL AND
600: p_price_adj_assoc_id <> FND_API.G_MISS_NUM) AND
601: (p_price_adjustment_id IS NOT NULL AND
602: p_price_adjustment_id <> FND_API.G_MISS_NUM)
603: THEN
604: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 602: p_price_adjustment_id <> FND_API.G_MISS_NUM)

598:
599: IF (p_price_adj_assoc_id IS NOT NULL AND
600: p_price_adj_assoc_id <> FND_API.G_MISS_NUM) AND
601: (p_price_adjustment_id IS NOT NULL AND
602: p_price_adjustment_id <> FND_API.G_MISS_NUM)
603: THEN
604: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
605: OE_MSG_PUB.Add_Exc_Msg
606: ( G_PKG_NAME

Line 612: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

608: , 'Keys are mutually exclusive: price_adj_assoc_id = ' ||
609: p_price_adj_assoc_id || ', price_adjustment_id = ' || p_price_adjustment_id );
610: END IF;
611:
612: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
613: END IF;
614:
615: IF p_price_adj_assoc_id <> FND_API.G_MISS_NUM THEN
616:

Line 615: IF p_price_adj_assoc_id <> FND_API.G_MISS_NUM THEN

611:
612: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
613: END IF;
614:
615: IF p_price_adj_assoc_id <> FND_API.G_MISS_NUM THEN
616:
617: SELECT price_adj_assoc_id
618: INTO l_price_adj_assoc_id
619: FROM oe_price_adj_assocs

Line 627: IF p_price_adjustment_id <> FND_API.G_MISS_NUM THEN

623:
624: -- null price_adjustment_id shouldn't be passed in unnecessarily if
625: -- price_adj_assoc_id is passed in already.
626: BEGIN
627: IF p_price_adjustment_id <> FND_API.G_MISS_NUM THEN
628: SAVEPOINT LOCK_ROWS;
629: OPEN lock_assoc_lines(p_price_adjustment_id);
630:
631: LOOP

Line 655: x_return_status := FND_API.G_RET_STS_SUCCESS;

651: , p_price_adjustment_id => p_price_adjustment_id
652: , x_Line_Adj_Assoc_tbl => x_Line_Adj_Assoc_tbl
653: );
654:
655: x_return_status := FND_API.G_RET_STS_SUCCESS;
656:
657: EXCEPTION
658: WHEN NO_DATA_FOUND THEN
659: x_return_status := FND_API.G_RET_STS_ERROR;

Line 659: x_return_status := FND_API.G_RET_STS_ERROR;

655: x_return_status := FND_API.G_RET_STS_SUCCESS;
656:
657: EXCEPTION
658: WHEN NO_DATA_FOUND THEN
659: x_return_status := FND_API.G_RET_STS_ERROR;
660: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
661: THEN
662: fnd_message.set_name('ONT','OE_LOCK_ROW_DELETED');
663: OE_MSG_PUB.Add;

Line 667: x_return_status := FND_API.G_RET_STS_ERROR;

663: OE_MSG_PUB.Add;
664: END IF;
665:
666: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
667: x_return_status := FND_API.G_RET_STS_ERROR;
668: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
669: THEN
670: fnd_message.set_name('ONT','OE_LOCK_ROW_ALREADY_LOCKED');
671: OE_MSG_PUB.Add;

Line 675: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

671: OE_MSG_PUB.Add;
672: END IF;
673:
674: WHEN OTHERS THEN
675: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
676: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
677: THEN
678: OE_MSG_PUB.Add_Exc_Msg
679: ( G_PKG_NAME

Line 709: IF p_from_line_id IS NOT NULL AND p_from_line_id <> FND_API.G_MISS_NUM THEN

705: l_assoc_list_line_id NUMBER;
706: l_price_adjustment_id NUMBER;
707: l_rltd_price_adj_id NUMBER;
708: BEGIN
709: IF p_from_line_id IS NOT NULL AND p_from_line_id <> FND_API.G_MISS_NUM THEN
710:
711: oe_debug_pub.ADD('Getting data',1);
712:
713: BEGIN