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

Line 15: -- DEFAULT = FND_API.G_FALSE,

11: -- p_api_version IN NUMBER (required)
12: -- API Version of this procedure
13: --
14: -- p_init_msg_list IN VARCHAR2 (optional)
15: -- DEFAULT = FND_API.G_FALSE,
16: --
17: -- p_commit IN VARCHAR2 (optional)
18: -- DEFAULT = FND_API.G_FALSE
19: --

Line 18: -- DEFAULT = FND_API.G_FALSE

14: -- p_init_msg_list IN VARCHAR2 (optional)
15: -- DEFAULT = FND_API.G_FALSE,
16: --
17: -- p_commit IN VARCHAR2 (optional)
18: -- DEFAULT = FND_API.G_FALSE
19: --
20: --
21: -- OUT NOCOPY /* file.sql.39 change */ :
22: -- x_return_status OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 37: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

33: -- Notes :
34: -- END OF comments
35: PROCEDURE ExecCheck (
36: p_api_version IN NUMBER ,
37: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
38: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
39: x_return_status IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
40: x_msg_count IN OUT NOCOPY /* file.sql.39 change */ NUMBER,
41: x_msg_data IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 38: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

34: -- END OF comments
35: PROCEDURE ExecCheck (
36: p_api_version IN NUMBER ,
37: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
38: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
39: x_return_status IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
40: x_msg_count IN OUT NOCOPY /* file.sql.39 change */ NUMBER,
41: x_msg_data IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
42: p_sum_detail_flag IN NUMBER,

Line 160: , p_init_msg_lst => fnd_api.g_false

156: -- Call quantity tree to obtain the quantity available to transact
157: INV_Quantity_Tree_PUB.Query_Quantities
158: (
159: p_api_version_number => 1.0
160: , p_init_msg_lst => fnd_api.g_false
161: , x_return_status => L_api_return_status
162: , x_msg_count => x_msg_count
163: , x_msg_data => x_msg_data
164: , p_organization_id => p_organization_id

Line 181: IF L_api_return_status <> fnd_api.g_ret_sts_success THEN

177: , x_qs => L_qty_sug
178: , x_att => L_ATT_qty
179: , x_atr => L_qty_atr
180: );
181: IF L_api_return_status <> fnd_api.g_ret_sts_success THEN
182: RAISE fnd_api.g_exc_unexpected_error;
183: END IF;
184:
185: /* Old code which did not use the quantity tree

Line 182: RAISE fnd_api.g_exc_unexpected_error;

178: , x_att => L_ATT_qty
179: , x_atr => L_qty_atr
180: );
181: IF L_api_return_status <> fnd_api.g_ret_sts_success THEN
182: RAISE fnd_api.g_exc_unexpected_error;
183: END IF;
184:
185: /* Old code which did not use the quantity tree
186: SELECT NVL(SUM(transaction_quantity),0)

Line 211: return (FND_API.G_FALSE);

207: END IF;
208:
209: -- Compare the adjusted ATT quantity (supply) to the shortage quantity (demand)
210: IF L_adj_qty >= p_short_quantity THEN
211: return (FND_API.G_FALSE);
212: ELSE
213: return (FND_API.G_TRUE);
214: END IF;
215: END Compare;

Line 213: return (FND_API.G_TRUE);

209: -- Compare the adjusted ATT quantity (supply) to the shortage quantity (demand)
210: IF L_adj_qty >= p_short_quantity THEN
211: return (FND_API.G_FALSE);
212: ELSE
213: return (FND_API.G_TRUE);
214: END IF;
215: END Compare;
216: --
217: BEGIN

Line 219: IF NOT FND_API.Compatible_API_Call(l_api_version

215: END Compare;
216: --
217: BEGIN
218: -- Standard Call to check for call compatibility
219: IF NOT FND_API.Compatible_API_Call(l_api_version
220: , p_api_version
221: , l_api_name
222: , G_PKG_NAME) THEN
223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

219: IF NOT FND_API.Compatible_API_Call(l_api_version
220: , p_api_version
221: , l_api_name
222: , G_PKG_NAME) THEN
223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
224: END IF;
225: --
226: -- Initialize message list if p_init_msg_list is set to true
227: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 227: IF FND_API.to_Boolean(p_init_msg_list) THEN

223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
224: END IF;
225: --
226: -- Initialize message list if p_init_msg_list is set to true
227: IF FND_API.to_Boolean(p_init_msg_list) THEN
228: FND_MSG_PUB.initialize;
229: END IF;
230: --
231: -- Initialize API return status to access

Line 232: x_return_status := FND_API.G_RET_STS_SUCCESS;

228: FND_MSG_PUB.initialize;
229: END IF;
230: --
231: -- Initialize API return status to access
232: x_return_status := FND_API.G_RET_STS_SUCCESS;
233: --
234: -- Initialize x_check_result
235: x_check_result := FND_API.G_FALSE;
236: -- See what statement we have to execute

Line 235: x_check_result := FND_API.G_FALSE;

231: -- Initialize API return status to access
232: x_return_status := FND_API.G_RET_STS_SUCCESS;
233: --
234: -- Initialize x_check_result
235: x_check_result := FND_API.G_FALSE;
236: -- See what statement we have to execute
237:
238: -- Bug #4474266 Added the IF condition for p_sum_detail_flag = 0
239:

Line 252: IF x_check_result = FND_API.G_FALSE THEN

248: p_organization_id => p_organization_id,
249: p_inventory_item_id => L_Quantity_rec.inventory_item_id,
250: p_short_quantity => L_Quantity_rec.short_quantity);
251:
252: IF x_check_result = FND_API.G_FALSE THEN
253: delete from mtl_short_chk_temp
254: where inventory_item_id = L_Quantity_rec.inventory_item_id
255: and seq_num = x_seq_num -- Bug 5081665: filter on seq_num
256: and organization_id = p_organization_id;

Line 287: x_check_result = FND_API.G_TRUE) THEN

283: END IF;
284: -- Now execute the detail statement if shortage exists or
285: -- parameter p_comp_att_qty_flag has been set to No
286: IF p_sum_detail_flag = 1 AND (p_comp_att_qty_flag = 2 OR
287: x_check_result = FND_API.G_TRUE) THEN
288: -- Get statement and execute it
289: ExecStatement (
290: p_organization_id => p_organization_id,
291: p_inventory_item_id => p_inventory_item_id,

Line 299: SELECT FND_API.G_TRUE

295: x_oe_short_quantity => L_OE_short_quantity
296: );
297: -- Set x_check_result according to mtl_short_chk_temp table contents
298: BEGIN
299: SELECT FND_API.G_TRUE
300: INTO x_check_result
301: FROM mtl_short_chk_temp
302: WHERE seq_num = x_seq_num
303: AND rownum < 2;

Line 306: x_check_result := FND_API.G_FALSE;

302: WHERE seq_num = x_seq_num
303: AND rownum < 2;
304: EXCEPTION
305: WHEN NO_DATA_FOUND THEN
306: x_check_result := FND_API.G_FALSE;
307: END;
308: END IF;
309: ELSIF p_sum_detail_flag = 2 THEN
310: -- summary statement

Line 329: IF FND_API.to_Boolean(p_commit) THEN

325: L_WIP_short_quantity + L_OE_short_quantity);
326: END IF;
327: --
328: -- Standard check of p_commit
329: IF FND_API.to_Boolean(p_commit) THEN
330: COMMIT;
331: END IF;
332: -- Standard call to get message count and if count is 1, get message info
333: FND_MSG_PUB.Count_And_Get

Line 337: WHEN FND_API.G_EXC_ERROR THEN

333: FND_MSG_PUB.Count_And_Get
334: (p_count => x_msg_count
335: , p_data => x_msg_data);
336: EXCEPTION
337: WHEN FND_API.G_EXC_ERROR THEN
338: --
339: x_return_status := FND_API.G_RET_STS_ERROR;
340: --
341: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

Line 339: x_return_status := FND_API.G_RET_STS_ERROR;

335: , p_data => x_msg_data);
336: EXCEPTION
337: WHEN FND_API.G_EXC_ERROR THEN
338: --
339: x_return_status := FND_API.G_RET_STS_ERROR;
340: --
341: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
342: , p_data => x_msg_data);
343: --

Line 344: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

340: --
341: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
342: , p_data => x_msg_data);
343: --
344: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
345: --
346: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
347: --
348: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

Line 346: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

342: , p_data => x_msg_data);
343: --
344: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
345: --
346: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
347: --
348: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
349: , p_data => x_msg_data);
350: --

Line 353: x_return_status := FND_API.G_RET_STS_ERROR;

349: , p_data => x_msg_data);
350: --
351: WHEN L_Statement_not_found THEN
352: --
353: x_return_status := FND_API.G_RET_STS_ERROR;
354: --
355: FND_MESSAGE.SET_NAME('INV','INV_SHORT_STATEMENT_NOT_FOUND');
356: FND_MSG_PUB.Add;
357: --

Line 360: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

356: FND_MSG_PUB.Add;
357: --
358: WHEN OTHERS THEN
359: --
360: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
361: --
362: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
363: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
364: END IF;

Line 380: -- DEFAULT = FND_API.G_FALSE,

376: -- p_api_version IN NUMBER (required)
377: -- API Version of this procedure
378: --
379: -- p_init_msg_list IN VARCHAR2 (optional)
380: -- DEFAULT = FND_API.G_FALSE,
381: --
382: -- p_commit IN VARCHAR2 (optional)
383: -- DEFAULT = FND_API.G_FALSE
384: --

Line 383: -- DEFAULT = FND_API.G_FALSE

379: -- p_init_msg_list IN VARCHAR2 (optional)
380: -- DEFAULT = FND_API.G_FALSE,
381: --
382: -- p_commit IN VARCHAR2 (optional)
383: -- DEFAULT = FND_API.G_FALSE
384: --
385: --
386: -- OUT NOCOPY /* file.sql.39 change */ :
387: -- x_return_status OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 402: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

398: -- Notes :
399: -- END OF comments
400: PROCEDURE CheckPrerequisites (
401: p_api_version IN NUMBER ,
402: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
403: x_return_status IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
404: x_msg_count IN OUT NOCOPY /* file.sql.39 change */ NUMBER,
405: x_msg_data IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
406: p_sum_detail_flag IN NUMBER,

Line 434: IF NOT FND_API.Compatible_API_Call(l_api_version

430: AND organization_id = p_organization_id;
431: --
432: BEGIN
433: -- Standard Call to check for call compatibility
434: IF NOT FND_API.Compatible_API_Call(l_api_version
435: , p_api_version
436: , l_api_name
437: , G_PKG_NAME) THEN
438: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 438: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

434: IF NOT FND_API.Compatible_API_Call(l_api_version
435: , p_api_version
436: , l_api_name
437: , G_PKG_NAME) THEN
438: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
439: END IF;
440: --
441: -- Initialize message list if p_init_msg_list is set to true
442: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 442: IF FND_API.to_Boolean(p_init_msg_list) THEN

438: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
439: END IF;
440: --
441: -- Initialize message list if p_init_msg_list is set to true
442: IF FND_API.to_Boolean(p_init_msg_list) THEN
443: FND_MSG_PUB.initialize;
444: END IF;
445: --
446: -- Initialize API return status to access

Line 447: x_return_status := FND_API.G_RET_STS_SUCCESS;

443: FND_MSG_PUB.initialize;
444: END IF;
445: --
446: -- Initialize API return status to access
447: x_return_status := FND_API.G_RET_STS_SUCCESS;
448: --
449: -- Initialize x_check_result to FND_API.G_FALSE
450: x_check_result := FND_API.G_FALSE;
451: --

Line 449: -- Initialize x_check_result to FND_API.G_FALSE

445: --
446: -- Initialize API return status to access
447: x_return_status := FND_API.G_RET_STS_SUCCESS;
448: --
449: -- Initialize x_check_result to FND_API.G_FALSE
450: x_check_result := FND_API.G_FALSE;
451: --
452: -- Check if transaction type allows shortage message for given
453: -- message type (but only if p_transaction_type_id is not null)

Line 450: x_check_result := FND_API.G_FALSE;

446: -- Initialize API return status to access
447: x_return_status := FND_API.G_RET_STS_SUCCESS;
448: --
449: -- Initialize x_check_result to FND_API.G_FALSE
450: x_check_result := FND_API.G_FALSE;
451: --
452: -- Check if transaction type allows shortage message for given
453: -- message type (but only if p_transaction_type_id is not null)
454: IF p_transaction_type_id IS NOT NULL THEN

Line 464: -- If so, set x_check_result to FND_API.G_TRUE

460: L_TransTypeFlag := 1;
461: END IF;
462: IF L_TransTypeFlag = 1 THEN
463: -- Check if item allows shortage message for given message type
464: -- If so, set x_check_result to FND_API.G_TRUE
465: OPEN L_Item_crs ( p_organization_id,
466: p_inventory_item_id );
467: FETCH L_Item_crs INTO L_ItemFlag;
468: CLOSE L_Item_crs;

Line 470: x_check_result := FND_API.G_TRUE;

466: p_inventory_item_id );
467: FETCH L_Item_crs INTO L_ItemFlag;
468: CLOSE L_Item_crs;
469: IF L_ItemFlag = 1 THEN
470: x_check_result := FND_API.G_TRUE;
471: END IF;
472: END IF;
473: --
474: -- Standard call to get message count and if count is 1, get message info

Line 479: WHEN FND_API.G_EXC_ERROR THEN

475: FND_MSG_PUB.Count_And_Get
476: (p_count => x_msg_count
477: , p_data => x_msg_data);
478: EXCEPTION
479: WHEN FND_API.G_EXC_ERROR THEN
480: --
481: x_return_status := FND_API.G_RET_STS_ERROR;
482: --
483: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

Line 481: x_return_status := FND_API.G_RET_STS_ERROR;

477: , p_data => x_msg_data);
478: EXCEPTION
479: WHEN FND_API.G_EXC_ERROR THEN
480: --
481: x_return_status := FND_API.G_RET_STS_ERROR;
482: --
483: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
484: , p_data => x_msg_data);
485: --

Line 486: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

482: --
483: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
484: , p_data => x_msg_data);
485: --
486: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
487: --
488: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
489: --
490: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

Line 488: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

484: , p_data => x_msg_data);
485: --
486: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
487: --
488: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
489: --
490: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
491: , p_data => x_msg_data);
492: --

Line 495: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

491: , p_data => x_msg_data);
492: --
493: WHEN OTHERS THEN
494: --
495: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
496: --
497: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
498: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
499: END IF;

Line 515: -- DEFAULT = FND_API.G_FALSE,

511: -- p_api_version IN NUMBER (required)
512: -- API Version of this procedure
513: --
514: -- p_init_msg_list IN VARCHAR2 (optional)
515: -- DEFAULT = FND_API.G_FALSE,
516: --
517: -- p_commit IN VARCHAR2 (optional)
518: -- DEFAULT = FND_API.G_FALSE
519: --

Line 518: -- DEFAULT = FND_API.G_FALSE

514: -- p_init_msg_list IN VARCHAR2 (optional)
515: -- DEFAULT = FND_API.G_FALSE,
516: --
517: -- p_commit IN VARCHAR2 (optional)
518: -- DEFAULT = FND_API.G_FALSE
519: --
520: --
521: -- OUT NOCOPY /* file.sql.39 change */ :
522: -- x_return_status OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 537: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

533: -- Notes :
534: -- END OF comments
535: PROCEDURE SendNotifications (
536: p_api_version IN NUMBER ,
537: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
538: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
539: x_return_status IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
540: x_msg_count IN OUT NOCOPY /* file.sql.39 change */ NUMBER,
541: x_msg_data IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 538: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

534: -- END OF comments
535: PROCEDURE SendNotifications (
536: p_api_version IN NUMBER ,
537: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
538: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
539: x_return_status IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
540: x_msg_count IN OUT NOCOPY /* file.sql.39 change */ NUMBER,
541: x_msg_data IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
542: p_organization_id IN NUMBER,

Line 725: x_return_status := FND_API.G_RET_STS_ERROR;

721:
722: EXCEPTION
723: WHEN OTHERS THEN
724: inv_log_util.trace(sqlerrm,'INV_ShortStatement_PVT.sendnotifications',9);
725: x_return_status := FND_API.G_RET_STS_ERROR;
726: RAISE FND_API.G_EXC_ERROR;
727: END ;
728:
729: -- l_org_id := MO_GLOBAL.get_valid_org(p_organization_id);

Line 726: RAISE FND_API.G_EXC_ERROR;

722: EXCEPTION
723: WHEN OTHERS THEN
724: inv_log_util.trace(sqlerrm,'INV_ShortStatement_PVT.sendnotifications',9);
725: x_return_status := FND_API.G_RET_STS_ERROR;
726: RAISE FND_API.G_EXC_ERROR;
727: END ;
728:
729: -- l_org_id := MO_GLOBAL.get_valid_org(p_organization_id);
730: l_org_id := MO_GLOBAL.get_valid_org(l_ou_org_id); --Bug#6509349

Line 733: x_return_status := FND_API.G_RET_STS_ERROR;

729: -- l_org_id := MO_GLOBAL.get_valid_org(p_organization_id);
730: l_org_id := MO_GLOBAL.get_valid_org(l_ou_org_id); --Bug#6509349
731:
732: IF l_org_id is NULL THEN
733: x_return_status := FND_API.G_RET_STS_ERROR;
734: RAISE FND_API.G_EXC_ERROR;
735: END IF;
736:
737: -- MOAC : Sets the application context for the current org

Line 734: RAISE FND_API.G_EXC_ERROR;

730: l_org_id := MO_GLOBAL.get_valid_org(l_ou_org_id); --Bug#6509349
731:
732: IF l_org_id is NULL THEN
733: x_return_status := FND_API.G_RET_STS_ERROR;
734: RAISE FND_API.G_EXC_ERROR;
735: END IF;
736:
737: -- MOAC : Sets the application context for the current org
738: -- if the specified operating unit exists in

Line 744: IF NOT FND_API.Compatible_API_Call(l_api_version

740:
741: MO_GLOBAL.set_policy_context('S',l_org_id);
742:
743: -- Standard Call to check for call compatibility
744: IF NOT FND_API.Compatible_API_Call(l_api_version
745: , p_api_version
746: , l_api_name
747: , G_PKG_NAME) THEN
748: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 748: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

744: IF NOT FND_API.Compatible_API_Call(l_api_version
745: , p_api_version
746: , l_api_name
747: , G_PKG_NAME) THEN
748: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
749: END IF;
750: --
751: -- Initialize message list if p_init_msg_list is set to true
752: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 752: IF FND_API.to_Boolean(p_init_msg_list) THEN

748: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
749: END IF;
750: --
751: -- Initialize message list if p_init_msg_list is set to true
752: IF FND_API.to_Boolean(p_init_msg_list) THEN
753: FND_MSG_PUB.initialize;
754: END IF;
755: --
756: -- Initialize API return status to access

Line 757: x_return_status := FND_API.G_RET_STS_SUCCESS;

753: FND_MSG_PUB.initialize;
754: END IF;
755: --
756: -- Initialize API return status to access
757: x_return_status := FND_API.G_RET_STS_SUCCESS;
758: --
759: -- Get item concatenated segments
760: OPEN L_Item_crs;
761: FETCH L_Item_crs INTO L_item_conc_segments;

Line 775: RAISE FND_API.G_EXC_ERROR;

771: FETCH L_ShortParam_csr INTO L_ShortParam_rec;
772: IF L_ShortParam_csr%NOTFOUND THEN
773: FND_MESSAGE.SET_NAME('INV','INV_SHORT_PARAMETER_NOT_FOUND');
774: FND_MSG_PUB.Add;
775: RAISE FND_API.G_EXC_ERROR;
776: END IF;
777: CLOSE L_ShortParam_csr;
778: --
779: -- Set message name according to input parameter

Line 838: IF FND_API.to_Boolean(p_commit) THEN

834: --
835: END LOOP;
836: CLOSE L_ShortTemp_csr;
837: -- Standard check of p_commit
838: IF FND_API.to_Boolean(p_commit) THEN
839: COMMIT;
840: END IF;
841: -- Standard call to get message count and if count is 1, get message info
842: FND_MSG_PUB.Count_And_Get

Line 846: WHEN FND_API.G_EXC_ERROR THEN

842: FND_MSG_PUB.Count_And_Get
843: (p_count => x_msg_count
844: , p_data => x_msg_data);
845: EXCEPTION
846: WHEN FND_API.G_EXC_ERROR THEN
847: --
848: x_return_status := FND_API.G_RET_STS_ERROR;
849: --
850: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

Line 848: x_return_status := FND_API.G_RET_STS_ERROR;

844: , p_data => x_msg_data);
845: EXCEPTION
846: WHEN FND_API.G_EXC_ERROR THEN
847: --
848: x_return_status := FND_API.G_RET_STS_ERROR;
849: --
850: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
851: , p_data => x_msg_data);
852: --

Line 853: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

849: --
850: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
851: , p_data => x_msg_data);
852: --
853: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
854: --
855: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
856: --
857: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

Line 855: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

851: , p_data => x_msg_data);
852: --
853: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
854: --
855: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
856: --
857: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
858: , p_data => x_msg_data);
859: --

Line 862: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

858: , p_data => x_msg_data);
859: --
860: WHEN OTHERS THEN
861: --
862: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
863: --
864: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
865: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
866: END IF;

Line 882: -- DEFAULT = FND_API.G_FALSE,

878: -- p_api_version IN NUMBER (required)
879: -- API Version of this procedure
880: --
881: -- p_init_msg_list IN VARCHAR2 (optional)
882: -- DEFAULT = FND_API.G_FALSE,
883: --
884: -- p_commit IN VARCHAR2 (optional)
885: -- DEFAULT = FND_API.G_FALSE
886: --

Line 885: -- DEFAULT = FND_API.G_FALSE

881: -- p_init_msg_list IN VARCHAR2 (optional)
882: -- DEFAULT = FND_API.G_FALSE,
883: --
884: -- p_commit IN VARCHAR2 (optional)
885: -- DEFAULT = FND_API.G_FALSE
886: --
887: -- p_seq_num IN NUMBER
888: -- Sequence number of rows which have to be deleted
889: --

Line 908: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

904: -- Notes :
905: -- END OF comments
906: PROCEDURE PurgeTempTable (
907: p_api_version IN NUMBER ,
908: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
909: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
910: x_return_status IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
911: x_msg_count IN OUT NOCOPY /* file.sql.39 change */ NUMBER,
912: x_msg_data IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 909: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

905: -- END OF comments
906: PROCEDURE PurgeTempTable (
907: p_api_version IN NUMBER ,
908: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
909: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
910: x_return_status IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
911: x_msg_count IN OUT NOCOPY /* file.sql.39 change */ NUMBER,
912: x_msg_data IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
913: p_seq_num IN NUMBER

Line 920: IF NOT FND_API.Compatible_API_Call(l_api_version

916: L_api_version CONSTANT NUMBER := 1.0;
917: L_api_name CONSTANT VARCHAR2(30) := 'PurgeTempTable';
918: BEGIN
919: -- Standard Call to check for call compatibility
920: IF NOT FND_API.Compatible_API_Call(l_api_version
921: , p_api_version
922: , l_api_name
923: , G_PKG_NAME) THEN
924: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 924: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

920: IF NOT FND_API.Compatible_API_Call(l_api_version
921: , p_api_version
922: , l_api_name
923: , G_PKG_NAME) THEN
924: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
925: END IF;
926: --
927: -- Initialize message list if p_init_msg_list is set to true
928: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 928: IF FND_API.to_Boolean(p_init_msg_list) THEN

924: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
925: END IF;
926: --
927: -- Initialize message list if p_init_msg_list is set to true
928: IF FND_API.to_Boolean(p_init_msg_list) THEN
929: FND_MSG_PUB.initialize;
930: END IF;
931: --
932: -- Initialize API return status to success

Line 933: x_return_status := FND_API.G_RET_STS_SUCCESS;

929: FND_MSG_PUB.initialize;
930: END IF;
931: --
932: -- Initialize API return status to success
933: x_return_status := FND_API.G_RET_STS_SUCCESS;
934: --
935: -- Purge all rows with the given sequence number
936: DELETE FROM mtl_short_chk_temp
937: WHERE seq_num = p_seq_num;

Line 940: IF FND_API.to_Boolean(p_commit) THEN

936: DELETE FROM mtl_short_chk_temp
937: WHERE seq_num = p_seq_num;
938: --
939: -- Standard check of p_commit
940: IF FND_API.to_Boolean(p_commit) THEN
941: COMMIT;
942: END IF;
943: -- Standard call to get message count and if count is 1, get message info
944: FND_MSG_PUB.Count_And_Get

Line 948: WHEN FND_API.G_EXC_ERROR THEN

944: FND_MSG_PUB.Count_And_Get
945: (p_count => x_msg_count
946: , p_data => x_msg_data);
947: EXCEPTION
948: WHEN FND_API.G_EXC_ERROR THEN
949: --
950: x_return_status := FND_API.G_RET_STS_ERROR;
951: --
952: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

Line 950: x_return_status := FND_API.G_RET_STS_ERROR;

946: , p_data => x_msg_data);
947: EXCEPTION
948: WHEN FND_API.G_EXC_ERROR THEN
949: --
950: x_return_status := FND_API.G_RET_STS_ERROR;
951: --
952: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
953: , p_data => x_msg_data);
954: --

Line 955: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

951: --
952: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
953: , p_data => x_msg_data);
954: --
955: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
956: --
957: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
958: --
959: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

Line 957: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

953: , p_data => x_msg_data);
954: --
955: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
956: --
957: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
958: --
959: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
960: , p_data => x_msg_data);
961: --

Line 964: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

960: , p_data => x_msg_data);
961: --
962: WHEN OTHERS THEN
963: --
964: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
965: --
966: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
967: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
968: END IF;

Line 1004: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1000: WHERE organization_id = p_organization_id
1001: AND inventory_item_id = p_inventory_item_id;
1002: EXCEPTION
1003: WHEN OTHERS THEN
1004: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1005: END;
1006: fnd_message.set_name('INV','INV_SHORTAGE_EXISTS');
1007: fnd_message.set_token('ITEM',L_item_conc_segments);
1008: EXCEPTION

Line 1010: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1006: fnd_message.set_name('INV','INV_SHORTAGE_EXISTS');
1007: fnd_message.set_token('ITEM',L_item_conc_segments);
1008: EXCEPTION
1009: WHEN OTHERS THEN
1010: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1011: END PrepareMessage;
1012: -- Added for bug 5081655: calculate open qty for repetitive schedules
1013: FUNCTION get_rep_curr_open_qty
1014: ( p_organization_id IN NUMBER