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_BLKT_RELEASE_UTIL dependencies on OE_DEBUG_PUB

Line 88: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

84: IS
85: l_amount NUMBER;
86: No_Conversion_Rate EXCEPTION;
87: --
88: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
89: --
90: BEGIN
91:
92: BEGIN

Line 94: OE_DEBUG_PUB.ADD('Convert from '||p_from_currency||

90: BEGIN
91:
92: BEGIN
93: if l_debug_level > 0 then
94: OE_DEBUG_PUB.ADD('Convert from '||p_from_currency||
95: ' to '||p_to_currency||' Amount :'||p_amount);
96: end if;
97: l_amount := gl_currency_api.convert_closest_amount_sql
98: (x_from_currency => p_from_currency

Line 107: OE_DEBUG_PUB.ADD('Converted amount 1 :'||l_amount);

103: ,x_amount => p_amount
104: ,x_max_roll_days => -1
105: );
106: if l_debug_level > 0 then
107: OE_DEBUG_PUB.ADD('Converted amount 1 :'||l_amount);
108: end if;
109:
110: IF l_amount < 0 THEN
111: RAISE No_Conversion_Rate;

Line 123: OE_DEBUG_PUB.ADD('SOB Currency :'||l_sob_rec.currency_code);

119:
120: l_sob_rec := OE_Order_Cache.Load_Set_Of_Books;
121:
122: if l_debug_level > 0 then
123: OE_DEBUG_PUB.ADD('SOB Currency :'||l_sob_rec.currency_code);
124: end if;
125:
126: IF l_sob_rec.currency_code <> p_to_currency THEN
127:

Line 138: OE_DEBUG_PUB.ADD('Converted amount 2 :'||l_amount);

134: ,x_amount => p_amount
135: ,x_max_roll_days => -1
136: );
137: if l_debug_level > 0 then
138: OE_DEBUG_PUB.ADD('Converted amount 2 :'||l_amount);
139: end if;
140:
141: IF l_amount < 0 THEN
142: RAISE No_Conversion_Rate;

Line 155: OE_DEBUG_PUB.ADD('Converted amount 3 :'||l_amount);

151: ,x_amount => l_amount
152: ,x_max_roll_days => -1
153: );
154: if l_debug_level > 0 then
155: OE_DEBUG_PUB.ADD('Converted amount 3 :'||l_amount);
156: end if;
157:
158: IF l_amount < 0 THEN
159: RAISE No_Conversion_Rate;

Line 176: oe_debug_pub.add('no rate found in either blanket or sob currency');

172:
173: EXCEPTION
174: WHEN No_Conversion_Rate THEN
175: if l_debug_level > 0 then
176: oe_debug_pub.add('no rate found in either blanket or sob currency');
177: end if;
178: FND_MESSAGE.SET_NAME('ONT','OE_BL_MISSING_CONV_RATE');
179: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',p_to_currency);
180: OE_MSG_PUB.ADD;

Line 242: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

238: WHERE H.HEADER_ID = x_blanket_header_id
239: AND H.ORDER_NUMBER = BH.ORDER_NUMBER
240: AND H.SALES_DOCUMENT_TYPE_CODE = 'B';
241: --
242: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
243: --
244: BEGIN
245:
246: if l_debug_level > 0 then

Line 247: oe_debug_pub.add('Enter cache blanket');

243: --
244: BEGIN
245:
246: if l_debug_level > 0 then
247: oe_debug_pub.add('Enter cache blanket');
248: oe_debug_pub.add('lock :'||p_lock);
249: oe_debug_pub.add('blanket number :'||p_blanket_number);
250: oe_debug_pub.add('blanket number :'||p_blanket_line_number);
251: end if;

Line 248: oe_debug_pub.add('lock :'||p_lock);

244: BEGIN
245:
246: if l_debug_level > 0 then
247: oe_debug_pub.add('Enter cache blanket');
248: oe_debug_pub.add('lock :'||p_lock);
249: oe_debug_pub.add('blanket number :'||p_blanket_number);
250: oe_debug_pub.add('blanket number :'||p_blanket_line_number);
251: end if;
252:

Line 249: oe_debug_pub.add('blanket number :'||p_blanket_number);

245:
246: if l_debug_level > 0 then
247: oe_debug_pub.add('Enter cache blanket');
248: oe_debug_pub.add('lock :'||p_lock);
249: oe_debug_pub.add('blanket number :'||p_blanket_number);
250: oe_debug_pub.add('blanket number :'||p_blanket_line_number);
251: end if;
252:
253: SELECT line_id

Line 250: oe_debug_pub.add('blanket number :'||p_blanket_line_number);

246: if l_debug_level > 0 then
247: oe_debug_pub.add('Enter cache blanket');
248: oe_debug_pub.add('lock :'||p_lock);
249: oe_debug_pub.add('blanket number :'||p_blanket_number);
250: oe_debug_pub.add('blanket number :'||p_blanket_line_number);
251: end if;
252:
253: SELECT line_id
254: INTO x_blanket_line_id

Line 260: oe_debug_pub.add('blanket line id :'||x_blanket_line_id);

256: WHERE BL.ORDER_NUMBER = p_blanket_number
257: AND BL.LINE_NUMBER = p_blanket_line_number;
258:
259: if l_debug_level > 0 then
260: oe_debug_pub.add('blanket line id :'||x_blanket_line_id);
261: if g_blkt_line_tbl.exists(x_blanket_line_id) then
262: oe_debug_pub.add('locked flag :'|| g_blkt_line_tbl(x_blanket_line_id).locked_flag);
263: end if;
264: end if;

Line 262: oe_debug_pub.add('locked flag :'|| g_blkt_line_tbl(x_blanket_line_id).locked_flag);

258:
259: if l_debug_level > 0 then
260: oe_debug_pub.add('blanket line id :'||x_blanket_line_id);
261: if g_blkt_line_tbl.exists(x_blanket_line_id) then
262: oe_debug_pub.add('locked flag :'|| g_blkt_line_tbl(x_blanket_line_id).locked_flag);
263: end if;
264: end if;
265:
266: --------------------------------------------------------------------

Line 278: oe_debug_pub.add('query blanket line');

274: )
275: THEN
276:
277: if l_debug_level > 0 then
278: oe_debug_pub.add('query blanket line');
279: end if;
280:
281: OPEN c_blanket_line;
282: FETCH c_blanket_line INTO

Line 309: oe_debug_pub.add('lock blanket line');

305: IF p_lock = 'Y'
306: AND g_blkt_line_tbl(x_blanket_line_id).locked_flag = 'N'
307: THEN
308: if l_debug_level > 0 then
309: oe_debug_pub.add('lock blanket line');
310: end if;
311: SELECT 'Y'
312: INTO g_blkt_line_tbl(x_blanket_line_id).locked_flag
313: FROM oe_blanket_lines_all

Line 332: oe_debug_pub.add('query blanket header');

328: )
329: THEN
330:
331: if l_debug_level > 0 then
332: oe_debug_pub.add('query blanket header');
333: end if;
334:
335: OPEN c_blanket_header;
336: FETCH c_blanket_header INTO

Line 354: oe_debug_pub.add('lock blanket header');

350: IF p_lock = 'Y'
351: AND g_blkt_hdr_tbl(x_blanket_header_id).locked_flag = 'N'
352: THEN
353: if l_debug_level > 0 then
354: oe_debug_pub.add('lock blanket header');
355: end if;
356: SELECT 'Y'
357: INTO g_blkt_hdr_tbl(x_blanket_header_id).locked_flag
358: FROM oe_blanket_headers_all

Line 364: oe_debug_pub.add('Exit cache blanket');

360: FOR UPDATE NOWAIT;
361: END IF;
362:
363: if l_debug_level > 0 then
364: oe_debug_pub.add('Exit cache blanket');
365: end if;
366:
367: EXCEPTION
368: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN

Line 419: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

415: l_hdr_released_amount NUMBER := 0;
416: l_released_quantity NUMBER := 0;
417:
418: --
419: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
420: --
421: BEGIN
422:
423: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 437: oe_debug_pub.add('Blanket UOM:'||g_blkt_line_tbl(l_blanket_line_id).uom);

433: -- COMPUTE RELEASE QUANTITY IF Blanket UOM Exists
434: --------------------------------------------------------------------
435:
436: if l_debug_level > 0 then
437: oe_debug_pub.add('Blanket UOM:'||g_blkt_line_tbl(l_blanket_line_id).uom);
438: oe_debug_pub.add('INITIAL blkt line released qty: '||
439: g_blkt_line_tbl(l_blanket_line_id).released_quantity);
440: oe_debug_pub.add('INITIAL blkt line released amt: '||
441: g_blkt_line_tbl(l_blanket_line_id).released_amount);

Line 438: oe_debug_pub.add('INITIAL blkt line released qty: '||

434: --------------------------------------------------------------------
435:
436: if l_debug_level > 0 then
437: oe_debug_pub.add('Blanket UOM:'||g_blkt_line_tbl(l_blanket_line_id).uom);
438: oe_debug_pub.add('INITIAL blkt line released qty: '||
439: g_blkt_line_tbl(l_blanket_line_id).released_quantity);
440: oe_debug_pub.add('INITIAL blkt line released amt: '||
441: g_blkt_line_tbl(l_blanket_line_id).released_amount);
442: oe_debug_pub.add('INITIAL blkt hdr released amt: '||

Line 440: oe_debug_pub.add('INITIAL blkt line released amt: '||

436: if l_debug_level > 0 then
437: oe_debug_pub.add('Blanket UOM:'||g_blkt_line_tbl(l_blanket_line_id).uom);
438: oe_debug_pub.add('INITIAL blkt line released qty: '||
439: g_blkt_line_tbl(l_blanket_line_id).released_quantity);
440: oe_debug_pub.add('INITIAL blkt line released amt: '||
441: g_blkt_line_tbl(l_blanket_line_id).released_amount);
442: oe_debug_pub.add('INITIAL blkt hdr released amt: '||
443: g_blkt_hdr_tbl(l_blanket_header_id).released_amount);
444: oe_debug_pub.add('new qty :'||p_quantity);

Line 442: oe_debug_pub.add('INITIAL blkt hdr released amt: '||

438: oe_debug_pub.add('INITIAL blkt line released qty: '||
439: g_blkt_line_tbl(l_blanket_line_id).released_quantity);
440: oe_debug_pub.add('INITIAL blkt line released amt: '||
441: g_blkt_line_tbl(l_blanket_line_id).released_amount);
442: oe_debug_pub.add('INITIAL blkt hdr released amt: '||
443: g_blkt_hdr_tbl(l_blanket_header_id).released_amount);
444: oe_debug_pub.add('new qty :'||p_quantity);
445: oe_debug_pub.add('old qty :'||p_old_quantity);
446: oe_debug_pub.add('new SP :'||p_unit_selling_price);

Line 444: oe_debug_pub.add('new qty :'||p_quantity);

440: oe_debug_pub.add('INITIAL blkt line released amt: '||
441: g_blkt_line_tbl(l_blanket_line_id).released_amount);
442: oe_debug_pub.add('INITIAL blkt hdr released amt: '||
443: g_blkt_hdr_tbl(l_blanket_header_id).released_amount);
444: oe_debug_pub.add('new qty :'||p_quantity);
445: oe_debug_pub.add('old qty :'||p_old_quantity);
446: oe_debug_pub.add('new SP :'||p_unit_selling_price);
447: oe_debug_pub.add('old SP :'||p_old_unit_selling_price);
448: oe_debug_pub.add('from uom :'||p_order_qty_uom);

Line 445: oe_debug_pub.add('old qty :'||p_old_quantity);

441: g_blkt_line_tbl(l_blanket_line_id).released_amount);
442: oe_debug_pub.add('INITIAL blkt hdr released amt: '||
443: g_blkt_hdr_tbl(l_blanket_header_id).released_amount);
444: oe_debug_pub.add('new qty :'||p_quantity);
445: oe_debug_pub.add('old qty :'||p_old_quantity);
446: oe_debug_pub.add('new SP :'||p_unit_selling_price);
447: oe_debug_pub.add('old SP :'||p_old_unit_selling_price);
448: oe_debug_pub.add('from uom :'||p_order_qty_uom);
449: oe_debug_pub.add('inv item :'||p_inv_item_id);

Line 446: oe_debug_pub.add('new SP :'||p_unit_selling_price);

442: oe_debug_pub.add('INITIAL blkt hdr released amt: '||
443: g_blkt_hdr_tbl(l_blanket_header_id).released_amount);
444: oe_debug_pub.add('new qty :'||p_quantity);
445: oe_debug_pub.add('old qty :'||p_old_quantity);
446: oe_debug_pub.add('new SP :'||p_unit_selling_price);
447: oe_debug_pub.add('old SP :'||p_old_unit_selling_price);
448: oe_debug_pub.add('from uom :'||p_order_qty_uom);
449: oe_debug_pub.add('inv item :'||p_inv_item_id);
450: end if;

Line 447: oe_debug_pub.add('old SP :'||p_old_unit_selling_price);

443: g_blkt_hdr_tbl(l_blanket_header_id).released_amount);
444: oe_debug_pub.add('new qty :'||p_quantity);
445: oe_debug_pub.add('old qty :'||p_old_quantity);
446: oe_debug_pub.add('new SP :'||p_unit_selling_price);
447: oe_debug_pub.add('old SP :'||p_old_unit_selling_price);
448: oe_debug_pub.add('from uom :'||p_order_qty_uom);
449: oe_debug_pub.add('inv item :'||p_inv_item_id);
450: end if;
451:

Line 448: oe_debug_pub.add('from uom :'||p_order_qty_uom);

444: oe_debug_pub.add('new qty :'||p_quantity);
445: oe_debug_pub.add('old qty :'||p_old_quantity);
446: oe_debug_pub.add('new SP :'||p_unit_selling_price);
447: oe_debug_pub.add('old SP :'||p_old_unit_selling_price);
448: oe_debug_pub.add('from uom :'||p_order_qty_uom);
449: oe_debug_pub.add('inv item :'||p_inv_item_id);
450: end if;
451:
452: IF p_order_qty_uom IS NULL THEN

Line 449: oe_debug_pub.add('inv item :'||p_inv_item_id);

445: oe_debug_pub.add('old qty :'||p_old_quantity);
446: oe_debug_pub.add('new SP :'||p_unit_selling_price);
447: oe_debug_pub.add('old SP :'||p_old_unit_selling_price);
448: oe_debug_pub.add('from uom :'||p_order_qty_uom);
449: oe_debug_pub.add('inv item :'||p_inv_item_id);
450: end if;
451:
452: IF p_order_qty_uom IS NULL THEN
453: l_quantity := 0;

Line 476: oe_debug_pub.add('conv new qty :'||l_quantity);

472: ,p_to_uom_code => g_blkt_line_tbl(l_blanket_line_id).uom
473: ,p_from_qty => l_quantity
474: );
475: if l_debug_level > 0 then
476: oe_debug_pub.add('conv new qty :'||l_quantity);
477: end if;
478: IF l_quantity < 0 THEN
479: FND_MESSAGE.SET_NAME('ONT','OE_BL_UOM_CONV_FAILED');
480: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Line_Number(p_line_id));

Line 498: oe_debug_pub.add('conv old qty :'||l_quantity);

494: ,p_to_uom_code => g_blkt_line_tbl(l_blanket_line_id).uom
495: ,p_from_qty => l_old_quantity
496: );
497: if l_debug_level > 0 then
498: oe_debug_pub.add('conv old qty :'||l_quantity);
499: end if;
500: IF l_old_quantity < 0 THEN
501: FND_MESSAGE.SET_NAME('ONT','OE_BL_UOM_CONV_FAILED');
502: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Line_Number(p_line_id));

Line 570: oe_debug_pub.add('curr line amt :'||l_amount);

566: l_hdr_released_amount := g_blkt_hdr_tbl(l_blanket_header_id).released_amount
567: + (l_amount - l_old_amount);
568:
569: if l_debug_level > 0 then
570: oe_debug_pub.add('curr line amt :'||l_amount);
571: oe_debug_pub.add('bl line released qty :'||l_released_quantity);
572: oe_debug_pub.add('bl line released amt :'||l_released_amount);
573: oe_debug_pub.add('hdr released amt :'||l_hdr_released_amount);
574: end if;

Line 571: oe_debug_pub.add('bl line released qty :'||l_released_quantity);

567: + (l_amount - l_old_amount);
568:
569: if l_debug_level > 0 then
570: oe_debug_pub.add('curr line amt :'||l_amount);
571: oe_debug_pub.add('bl line released qty :'||l_released_quantity);
572: oe_debug_pub.add('bl line released amt :'||l_released_amount);
573: oe_debug_pub.add('hdr released amt :'||l_hdr_released_amount);
574: end if;
575:

Line 572: oe_debug_pub.add('bl line released amt :'||l_released_amount);

568:
569: if l_debug_level > 0 then
570: oe_debug_pub.add('curr line amt :'||l_amount);
571: oe_debug_pub.add('bl line released qty :'||l_released_quantity);
572: oe_debug_pub.add('bl line released amt :'||l_released_amount);
573: oe_debug_pub.add('hdr released amt :'||l_hdr_released_amount);
574: end if;
575:
576: --------------------------------------------------------------------

Line 573: oe_debug_pub.add('hdr released amt :'||l_hdr_released_amount);

569: if l_debug_level > 0 then
570: oe_debug_pub.add('curr line amt :'||l_amount);
571: oe_debug_pub.add('bl line released qty :'||l_released_quantity);
572: oe_debug_pub.add('bl line released amt :'||l_released_amount);
573: oe_debug_pub.add('hdr released amt :'||l_hdr_released_amount);
574: end if;
575:
576: --------------------------------------------------------------------
577: -- VALIDATE MIN/MAX IF OVERRIDE NOT ALLOWED

Line 886: oe_debug_pub.add('Final blkt line released qty: '||

882:
883: END IF;
884:
885: if l_debug_level > 0 then
886: oe_debug_pub.add('Final blkt line released qty: '||
887: g_blkt_line_tbl(l_blanket_line_id).released_quantity);
888: oe_debug_pub.add('Final blkt line released amt: '||
889: g_blkt_line_tbl(l_blanket_line_id).released_amount);
890: oe_debug_pub.add('Final blkt hdr released amt: '||

Line 888: oe_debug_pub.add('Final blkt line released amt: '||

884:
885: if l_debug_level > 0 then
886: oe_debug_pub.add('Final blkt line released qty: '||
887: g_blkt_line_tbl(l_blanket_line_id).released_quantity);
888: oe_debug_pub.add('Final blkt line released amt: '||
889: g_blkt_line_tbl(l_blanket_line_id).released_amount);
890: oe_debug_pub.add('Final blkt hdr released amt: '||
891: g_blkt_hdr_tbl(l_blanket_header_id).released_amount);
892: end if;

Line 890: oe_debug_pub.add('Final blkt hdr released amt: '||

886: oe_debug_pub.add('Final blkt line released qty: '||
887: g_blkt_line_tbl(l_blanket_line_id).released_quantity);
888: oe_debug_pub.add('Final blkt line released amt: '||
889: g_blkt_line_tbl(l_blanket_line_id).released_amount);
890: oe_debug_pub.add('Final blkt hdr released amt: '||
891: g_blkt_hdr_tbl(l_blanket_header_id).released_amount);
892: end if;
893:
894: -- End of min-max checks

Line 996: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

992: l_uom VARCHAR2(3);
993: l_inv_item_id NUMBER;
994: l_set_line_number NUMBER;
995: --
996: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
997: --
998:
999: FUNCTION Get_Set_Line_Number RETURN NUMBER IS
1000: BEGIN

Line 1047: oe_debug_pub.add('Set Qty :'||l_set_quantity);

1043: AND blanket_number = p_blanket_number
1044: AND blanket_line_number = p_blanket_line_number;
1045:
1046: if l_debug_level > 0 then
1047: oe_debug_pub.add('Set Qty :'||l_set_quantity);
1048: oe_debug_pub.add('Set Amt :'||l_set_amount);
1049: end if;
1050:
1051: -- Min/Max Qty Validations only if UOM exists on blanket line

Line 1048: oe_debug_pub.add('Set Amt :'||l_set_amount);

1044: AND blanket_line_number = p_blanket_line_number;
1045:
1046: if l_debug_level > 0 then
1047: oe_debug_pub.add('Set Qty :'||l_set_quantity);
1048: oe_debug_pub.add('Set Amt :'||l_set_amount);
1049: end if;
1050:
1051: -- Min/Max Qty Validations only if UOM exists on blanket line
1052: IF g_blkt_line_tbl(l_blanket_line_id).uom IS NOT NULL

Line 1060: oe_debug_pub.add('convert uom');

1056: IF NOT OE_GLOBALS.EQUAL(l_uom,
1057: g_blkt_line_tbl(l_blanket_line_id).uom)
1058: THEN
1059:
1060: oe_debug_pub.add('convert uom');
1061: l_set_quantity := OE_Order_Misc_Util.Convert_UOM
1062: (p_item_id => l_inv_item_id
1063: ,p_from_uom_code => l_uom
1064: ,p_to_uom_code => g_blkt_line_tbl(l_blanket_line_id).uom

Line 1114: oe_debug_pub.add('Amt Checks');

1110: END IF;
1111:
1112: END IF;
1113:
1114: oe_debug_pub.add('Amt Checks');
1115: -- Min/Max Amount Validations
1116: IF l_set_amount <> 0 THEN
1117:
1118: IF p_currency_code

Line 1230: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

1226: l_qty NUMBER;
1227: l_currency_code VARCHAR2(15);
1228: l_hdr_id NUMBER;
1229: --
1230: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1231: --
1232: BEGIN
1233:
1234: if l_debug_level > 0 then

Line 1235: oe_debug_pub.add('ENTER OE_Blanket_Util.Process_Releases, Num Requests :'

1231: --
1232: BEGIN
1233:
1234: if l_debug_level > 0 then
1235: oe_debug_pub.add('ENTER OE_Blanket_Util.Process_Releases, Num Requests :'
1236: || p_request_tbl.COUNT);
1237: end if;
1238:
1239: g_blkt_line_tbl.delete;

Line 1254: oe_debug_pub.add('VALIDATE_RELEASE_SHIPMENTS, line set id: '

1250: GOTO end_of_loop;
1251: END IF;
1252:
1253: if l_debug_level > 0 then
1254: oe_debug_pub.add('VALIDATE_RELEASE_SHIPMENTS, line set id: '
1255: ||p_request_tbl(I).entity_id);
1256: end if;
1257:
1258: Validate_Release_Shipments

Line 1267: oe_debug_pub.add('ret sts of error');

1263: ,x_return_status => l_return_status
1264: );
1265:
1266: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1267: oe_debug_pub.add('ret sts of error');
1268: x_return_status := FND_API.G_RET_STS_ERROR;
1269: RETURN;
1270: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1271: oe_debug_pub.add('ret sts of unexp error');

Line 1271: oe_debug_pub.add('ret sts of unexp error');

1267: oe_debug_pub.add('ret sts of error');
1268: x_return_status := FND_API.G_RET_STS_ERROR;
1269: RETURN;
1270: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1271: oe_debug_pub.add('ret sts of unexp error');
1272: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1273: RETURN;
1274: END IF;
1275:

Line 1293: oe_debug_pub.add('PROCESS_RELEASE, line id: '||p_request_tbl(I).entity_id);

1289: OR p_request_tbl(I).request_type <> 'PROCESS_RELEASE' THEN
1290: GOTO end_of_loop;
1291: END IF;
1292:
1293: oe_debug_pub.add('PROCESS_RELEASE, line id: '||p_request_tbl(I).entity_id);
1294:
1295: begin
1296: select header_id
1297: into l_hdr_id

Line 1320: oe_debug_pub.add('header currency :'||l_currency_code);

1316:
1317: l_currency_code := p_request_tbl(I).request_unique_key1;
1318:
1319: if l_debug_level > 0 then
1320: oe_debug_pub.add('header currency :'||l_currency_code);
1321: oe_debug_pub.add('old blanket num :'||p_request_tbl(I).param1);
1322: oe_debug_pub.add('new blanket num:'||p_request_tbl(I).param11);
1323: oe_debug_pub.add('old blanket line num:'||p_request_tbl(I).param2);
1324: oe_debug_pub.add('new blanket line num:'||p_request_tbl(I).param12);

Line 1321: oe_debug_pub.add('old blanket num :'||p_request_tbl(I).param1);

1317: l_currency_code := p_request_tbl(I).request_unique_key1;
1318:
1319: if l_debug_level > 0 then
1320: oe_debug_pub.add('header currency :'||l_currency_code);
1321: oe_debug_pub.add('old blanket num :'||p_request_tbl(I).param1);
1322: oe_debug_pub.add('new blanket num:'||p_request_tbl(I).param11);
1323: oe_debug_pub.add('old blanket line num:'||p_request_tbl(I).param2);
1324: oe_debug_pub.add('new blanket line num:'||p_request_tbl(I).param12);
1325: end if;

Line 1322: oe_debug_pub.add('new blanket num:'||p_request_tbl(I).param11);

1318:
1319: if l_debug_level > 0 then
1320: oe_debug_pub.add('header currency :'||l_currency_code);
1321: oe_debug_pub.add('old blanket num :'||p_request_tbl(I).param1);
1322: oe_debug_pub.add('new blanket num:'||p_request_tbl(I).param11);
1323: oe_debug_pub.add('old blanket line num:'||p_request_tbl(I).param2);
1324: oe_debug_pub.add('new blanket line num:'||p_request_tbl(I).param12);
1325: end if;
1326:

Line 1323: oe_debug_pub.add('old blanket line num:'||p_request_tbl(I).param2);

1319: if l_debug_level > 0 then
1320: oe_debug_pub.add('header currency :'||l_currency_code);
1321: oe_debug_pub.add('old blanket num :'||p_request_tbl(I).param1);
1322: oe_debug_pub.add('new blanket num:'||p_request_tbl(I).param11);
1323: oe_debug_pub.add('old blanket line num:'||p_request_tbl(I).param2);
1324: oe_debug_pub.add('new blanket line num:'||p_request_tbl(I).param12);
1325: end if;
1326:
1327: -- Blanket line remained same but some other field affecting

Line 1324: oe_debug_pub.add('new blanket line num:'||p_request_tbl(I).param12);

1320: oe_debug_pub.add('header currency :'||l_currency_code);
1321: oe_debug_pub.add('old blanket num :'||p_request_tbl(I).param1);
1322: oe_debug_pub.add('new blanket num:'||p_request_tbl(I).param11);
1323: oe_debug_pub.add('old blanket line num:'||p_request_tbl(I).param2);
1324: oe_debug_pub.add('new blanket line num:'||p_request_tbl(I).param12);
1325: end if;
1326:
1327: -- Blanket line remained same but some other field affecting
1328: -- qty or price was updated

Line 1334: oe_debug_pub.add('Update qty/amt for existing blanket num :'

1330: AND p_request_tbl(I).param2 = p_request_tbl(I).param12
1331: THEN
1332:
1333: if l_debug_level > 0 then
1334: oe_debug_pub.add('Update qty/amt for existing blanket num :'
1335: ||p_request_tbl(I).param11);
1336: end if;
1337:
1338: Update_Released_Qty_Amount

Line 1357: oe_debug_pub.add('1. ret sts of error');

1353: ,x_return_status => l_return_status
1354: );
1355:
1356: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1357: oe_debug_pub.add('1. ret sts of error');
1358: x_return_status := FND_API.G_RET_STS_ERROR;
1359: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1360: oe_debug_pub.add('1. ret sts of unexp error');
1361: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1360: oe_debug_pub.add('1. ret sts of unexp error');

1356: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1357: oe_debug_pub.add('1. ret sts of error');
1358: x_return_status := FND_API.G_RET_STS_ERROR;
1359: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1360: oe_debug_pub.add('1. ret sts of unexp error');
1361: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1362: END IF;
1363:
1364: ELSE

Line 1370: oe_debug_pub.add('Increment qty/amt for new blanket num :'

1366: -- Increment qty/amount for new blanket line
1367: IF p_request_tbl(I).param11 IS NOT NULL THEN
1368:
1369: if l_debug_level > 0 then
1370: oe_debug_pub.add('Increment qty/amt for new blanket num :'
1371: ||p_request_tbl(I).param11);
1372: end if;
1373:
1374: Update_Released_Qty_Amount

Line 1395: oe_debug_pub.add('2. ret sts of error');

1391:
1392: END IF;
1393:
1394: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1395: oe_debug_pub.add('2. ret sts of error');
1396: x_return_status := FND_API.G_RET_STS_ERROR;
1397: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1398: oe_debug_pub.add('2. ret sts of unexp error');
1399: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1398: oe_debug_pub.add('2. ret sts of unexp error');

1394: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1395: oe_debug_pub.add('2. ret sts of error');
1396: x_return_status := FND_API.G_RET_STS_ERROR;
1397: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1398: oe_debug_pub.add('2. ret sts of unexp error');
1399: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1400: END IF;
1401:
1402: -- Decrement qty/amount for old blanket line

Line 1406: oe_debug_pub.add('Decrement qty/amt for old blanket num :'

1402: -- Decrement qty/amount for old blanket line
1403: IF p_request_tbl(I).param1 IS NOT NULL THEN
1404:
1405: if l_debug_level > 0 then
1406: oe_debug_pub.add('Decrement qty/amt for old blanket num :'
1407: ||p_request_tbl(I).param1);
1408: end if;
1409:
1410: Update_Released_Qty_Amount

Line 1431: oe_debug_pub.add('3. ret sts of error');

1427:
1428: END IF;
1429:
1430: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1431: oe_debug_pub.add('3. ret sts of error');
1432: x_return_status := FND_API.G_RET_STS_ERROR;
1433: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1434: oe_debug_pub.add('3. ret sts of unexp error');
1435: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1434: oe_debug_pub.add('3. ret sts of unexp error');

1430: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1431: oe_debug_pub.add('3. ret sts of error');
1432: x_return_status := FND_API.G_RET_STS_ERROR;
1433: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1434: oe_debug_pub.add('3. ret sts of unexp error');
1435: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1436: END IF;
1437:
1438: END IF;

Line 1454: oe_debug_pub.add('Overall Ret Sts :'||x_return_status);

1450: -- Error during updates, mark the requests as NOT processed
1451: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1452:
1453: if l_debug_level > 0 then
1454: oe_debug_pub.add('Overall Ret Sts :'||x_return_status);
1455: end if;
1456:
1457: I := p_request_tbl.FIRST;
1458: WHILE I IS NOT NULL LOOP

Line 1461: oe_debug_pub.add('Set req to NOT processed at index :'||I);

1457: I := p_request_tbl.FIRST;
1458: WHILE I IS NOT NULL LOOP
1459: IF p_request_tbl(I).request_type = 'PROCESS_RELEASE' THEN
1460: if l_debug_level > 0 then
1461: oe_debug_pub.add('Set req to NOT processed at index :'||I);
1462: end if;
1463: p_request_tbl(I).processed := 'N';
1464: END IF;
1465: I := p_request_tbl.NEXT(I);

Line 1478: oe_debug_pub.add('delete cache');

1474: -- Only if blankets update is successful,
1475: -- delete the old order released qty/amount also.
1476: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
1477:
1478: oe_debug_pub.add('delete cache');
1479: g_bl_order_val_tbl.delete;
1480: g_bh_order_val_tbl.delete;
1481:
1482: END IF;

Line 1487: oe_debug_pub.add('EXIT OE_Blanket_Util.Process_Releases');

1483:
1484: END IF;
1485:
1486: if l_debug_level > 0 then
1487: oe_debug_pub.add('EXIT OE_Blanket_Util.Process_Releases');
1488: end if;
1489:
1490: EXCEPTION
1491: WHEN FND_API.G_EXC_ERROR THEN

Line 1529: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

1525: l_rem_bl_line_amt NUMBER;
1526: l_rem_bl_hdr_amt NUMBER;
1527: l_currency_code VARCHAR2(15);
1528: --
1529: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1530: --
1531: BEGIN
1532:
1533: if l_debug_level > 0 then

Line 1534: oe_debug_pub.add('Enter Populate_Old_Values');

1530: --
1531: BEGIN
1532:
1533: if l_debug_level > 0 then
1534: oe_debug_pub.add('Enter Populate_Old_Values');
1535: oe_debug_pub.add('Blanket Num :'||p_blanket_number);
1536: oe_debug_pub.add('Blanket Line Num :'||p_blanket_line_number);
1537: oe_debug_pub.add('Line ID :'||p_line_id);
1538: oe_debug_pub.add('Header ID :'||p_header_id);

Line 1535: oe_debug_pub.add('Blanket Num :'||p_blanket_number);

1531: BEGIN
1532:
1533: if l_debug_level > 0 then
1534: oe_debug_pub.add('Enter Populate_Old_Values');
1535: oe_debug_pub.add('Blanket Num :'||p_blanket_number);
1536: oe_debug_pub.add('Blanket Line Num :'||p_blanket_line_number);
1537: oe_debug_pub.add('Line ID :'||p_line_id);
1538: oe_debug_pub.add('Header ID :'||p_header_id);
1539: oe_debug_pub.add('Old Qty :'||p_old_quantity);

Line 1536: oe_debug_pub.add('Blanket Line Num :'||p_blanket_line_number);

1532:
1533: if l_debug_level > 0 then
1534: oe_debug_pub.add('Enter Populate_Old_Values');
1535: oe_debug_pub.add('Blanket Num :'||p_blanket_number);
1536: oe_debug_pub.add('Blanket Line Num :'||p_blanket_line_number);
1537: oe_debug_pub.add('Line ID :'||p_line_id);
1538: oe_debug_pub.add('Header ID :'||p_header_id);
1539: oe_debug_pub.add('Old Qty :'||p_old_quantity);
1540: oe_debug_pub.add('Old Selling Price :'||p_old_unit_sp);

Line 1537: oe_debug_pub.add('Line ID :'||p_line_id);

1533: if l_debug_level > 0 then
1534: oe_debug_pub.add('Enter Populate_Old_Values');
1535: oe_debug_pub.add('Blanket Num :'||p_blanket_number);
1536: oe_debug_pub.add('Blanket Line Num :'||p_blanket_line_number);
1537: oe_debug_pub.add('Line ID :'||p_line_id);
1538: oe_debug_pub.add('Header ID :'||p_header_id);
1539: oe_debug_pub.add('Old Qty :'||p_old_quantity);
1540: oe_debug_pub.add('Old Selling Price :'||p_old_unit_sp);
1541: end if;

Line 1538: oe_debug_pub.add('Header ID :'||p_header_id);

1534: oe_debug_pub.add('Enter Populate_Old_Values');
1535: oe_debug_pub.add('Blanket Num :'||p_blanket_number);
1536: oe_debug_pub.add('Blanket Line Num :'||p_blanket_line_number);
1537: oe_debug_pub.add('Line ID :'||p_line_id);
1538: oe_debug_pub.add('Header ID :'||p_header_id);
1539: oe_debug_pub.add('Old Qty :'||p_old_quantity);
1540: oe_debug_pub.add('Old Selling Price :'||p_old_unit_sp);
1541: end if;
1542:

Line 1539: oe_debug_pub.add('Old Qty :'||p_old_quantity);

1535: oe_debug_pub.add('Blanket Num :'||p_blanket_number);
1536: oe_debug_pub.add('Blanket Line Num :'||p_blanket_line_number);
1537: oe_debug_pub.add('Line ID :'||p_line_id);
1538: oe_debug_pub.add('Header ID :'||p_header_id);
1539: oe_debug_pub.add('Old Qty :'||p_old_quantity);
1540: oe_debug_pub.add('Old Selling Price :'||p_old_unit_sp);
1541: end if;
1542:
1543: -- Do not lock when caching old values

Line 1540: oe_debug_pub.add('Old Selling Price :'||p_old_unit_sp);

1536: oe_debug_pub.add('Blanket Line Num :'||p_blanket_line_number);
1537: oe_debug_pub.add('Line ID :'||p_line_id);
1538: oe_debug_pub.add('Header ID :'||p_header_id);
1539: oe_debug_pub.add('Old Qty :'||p_old_quantity);
1540: oe_debug_pub.add('Old Selling Price :'||p_old_unit_sp);
1541: end if;
1542:
1543: -- Do not lock when caching old values
1544: Cache_Blanket

Line 1631: oe_debug_pub.add('order header id :'||l_header_id);

1627:
1628: END IF;
1629:
1630: if l_debug_level > 0 then
1631: oe_debug_pub.add('order header id :'||l_header_id);
1632: oe_debug_pub.add('rem bl line qty :'||nvl(l_rem_bl_line_qty,0));
1633: oe_debug_pub.add('rem bl line amt :'||nvl(l_rem_bl_line_amt,0));
1634: oe_debug_pub.add('rem bl hdr amt :'||nvl(l_rem_bl_hdr_amt,0));
1635: oe_debug_pub.add('old qty :'||l_old_quantity);

Line 1632: oe_debug_pub.add('rem bl line qty :'||nvl(l_rem_bl_line_qty,0));

1628: END IF;
1629:
1630: if l_debug_level > 0 then
1631: oe_debug_pub.add('order header id :'||l_header_id);
1632: oe_debug_pub.add('rem bl line qty :'||nvl(l_rem_bl_line_qty,0));
1633: oe_debug_pub.add('rem bl line amt :'||nvl(l_rem_bl_line_amt,0));
1634: oe_debug_pub.add('rem bl hdr amt :'||nvl(l_rem_bl_hdr_amt,0));
1635: oe_debug_pub.add('old qty :'||l_old_quantity);
1636: oe_debug_pub.add('old amt :'||l_old_amount);

Line 1633: oe_debug_pub.add('rem bl line amt :'||nvl(l_rem_bl_line_amt,0));

1629:
1630: if l_debug_level > 0 then
1631: oe_debug_pub.add('order header id :'||l_header_id);
1632: oe_debug_pub.add('rem bl line qty :'||nvl(l_rem_bl_line_qty,0));
1633: oe_debug_pub.add('rem bl line amt :'||nvl(l_rem_bl_line_amt,0));
1634: oe_debug_pub.add('rem bl hdr amt :'||nvl(l_rem_bl_hdr_amt,0));
1635: oe_debug_pub.add('old qty :'||l_old_quantity);
1636: oe_debug_pub.add('old amt :'||l_old_amount);
1637: end if;

Line 1634: oe_debug_pub.add('rem bl hdr amt :'||nvl(l_rem_bl_hdr_amt,0));

1630: if l_debug_level > 0 then
1631: oe_debug_pub.add('order header id :'||l_header_id);
1632: oe_debug_pub.add('rem bl line qty :'||nvl(l_rem_bl_line_qty,0));
1633: oe_debug_pub.add('rem bl line amt :'||nvl(l_rem_bl_line_amt,0));
1634: oe_debug_pub.add('rem bl hdr amt :'||nvl(l_rem_bl_hdr_amt,0));
1635: oe_debug_pub.add('old qty :'||l_old_quantity);
1636: oe_debug_pub.add('old amt :'||l_old_amount);
1637: end if;
1638:

Line 1635: oe_debug_pub.add('old qty :'||l_old_quantity);

1631: oe_debug_pub.add('order header id :'||l_header_id);
1632: oe_debug_pub.add('rem bl line qty :'||nvl(l_rem_bl_line_qty,0));
1633: oe_debug_pub.add('rem bl line amt :'||nvl(l_rem_bl_line_amt,0));
1634: oe_debug_pub.add('rem bl hdr amt :'||nvl(l_rem_bl_hdr_amt,0));
1635: oe_debug_pub.add('old qty :'||l_old_quantity);
1636: oe_debug_pub.add('old amt :'||l_old_amount);
1637: end if;
1638:
1639: END IF; -- if not cached

Line 1636: oe_debug_pub.add('old amt :'||l_old_amount);

1632: oe_debug_pub.add('rem bl line qty :'||nvl(l_rem_bl_line_qty,0));
1633: oe_debug_pub.add('rem bl line amt :'||nvl(l_rem_bl_line_amt,0));
1634: oe_debug_pub.add('rem bl hdr amt :'||nvl(l_rem_bl_hdr_amt,0));
1635: oe_debug_pub.add('old qty :'||l_old_quantity);
1636: oe_debug_pub.add('old amt :'||l_old_amount);
1637: end if;
1638:
1639: END IF; -- if not cached
1640:

Line 1672: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

1668: l_old_line_quantity NUMBER;
1669: l_rem_lines_quantity NUMBER;
1670: l_currency_code VARCHAR2(15);
1671: --
1672: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1673: --
1674:
1675: BEGIN
1676:

Line 1678: oe_debug_pub.add('ENTER OE_Blkt_Release_Util.Cache_Order_Qty_Amt');

1674:
1675: BEGIN
1676:
1677: if l_debug_level > 0 then
1678: oe_debug_pub.add('ENTER OE_Blkt_Release_Util.Cache_Order_Qty_Amt');
1679: end if;
1680:
1681: x_return_status := fnd_api.g_ret_sts_success;
1682:

Line 1728: oe_debug_pub.add('EXIT OE_Blkt_Release_Util.Cache_Order_Qty_Amt');

1724:
1725: END IF;
1726:
1727: if l_debug_level > 0 then
1728: oe_debug_pub.add('EXIT OE_Blkt_Release_Util.Cache_Order_Qty_Amt');
1729: end if;
1730:
1731: EXCEPTION
1732: WHEN FND_API.G_EXC_ERROR THEN