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

Line 7: l_g_ret_sts_error CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_error;

3:
4: -- Global constant holding the package name
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'wms_txnrsn_actions_pub';
7: l_g_ret_sts_error CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_error;
8: l_g_ret_sts_unexp_error CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_unexp_error;
9: l_g_ret_sts_success CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_success;
10: g_trace_on CONSTANT NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
11:

Line 8: l_g_ret_sts_unexp_error CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_unexp_error;

4: -- Global constant holding the package name
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'wms_txnrsn_actions_pub';
7: l_g_ret_sts_error CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_error;
8: l_g_ret_sts_unexp_error CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_unexp_error;
9: l_g_ret_sts_success CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_success;
10: g_trace_on CONSTANT NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
11:
12: g_debug NUMBER := 1;

Line 9: l_g_ret_sts_success CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_success;

5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'wms_txnrsn_actions_pub';
7: l_g_ret_sts_error CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_error;
8: l_g_ret_sts_unexp_error CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_unexp_error;
9: l_g_ret_sts_success CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_success;
10: g_trace_on CONSTANT NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
11:
12: g_debug NUMBER := 1;
13: g_module_name VARCHAR2(30) := NULL;

Line 46: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false

42:
43: PROCEDURE Inadequate_Qty
44: (
45: p_api_version_number IN NUMBER
46: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
47: , p_commit IN VARCHAR2 := FND_API.G_FALSE
48: , x_return_status OUT NOCOPY VARCHAR2
49: , x_msg_count OUT NOCOPY NUMBER
50: , x_msg_data OUT NOCOPY VARCHAR2

Line 47: , p_commit IN VARCHAR2 := FND_API.G_FALSE

43: PROCEDURE Inadequate_Qty
44: (
45: p_api_version_number IN NUMBER
46: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
47: , p_commit IN VARCHAR2 := FND_API.G_FALSE
48: , x_return_status OUT NOCOPY VARCHAR2
49: , x_msg_count OUT NOCOPY NUMBER
50: , x_msg_data OUT NOCOPY VARCHAR2
51: , p_organization_id IN NUMBER

Line 110: x_return_status := FND_API.G_RET_STS_SUCCESS;

106: l_reason_id:=p_reason_id;
107: l_discrepancy:=1;
108:
109: -- Initialize API return status to success
110: x_return_status := FND_API.G_RET_STS_SUCCESS;
111:
112:
113: IF (l_debug = 1) THEN
114: mdebug('Inside wms_txnrsn_actions_pub.Inadequate Quantity: Before update quantity ');

Line 211: RAISE fnd_api.g_exc_unexpected_error;

207:
208: IF l_mso_header_id IS NULL THEN
209: FND_MESSAGE.SET_NAME('INV','INV_COULD_NOT_GET_MSO_HEADER');
210: FND_MSG_PUB.Add;
211: RAISE fnd_api.g_exc_unexpected_error;
212: END IF;
213:
214: -- get data for p_missing_quantity
215: l_missing_quantity := l_transaction_quantity - p_qty_picked;

Line 229: ,p_init_msg_list => fnd_api.g_false

225: -- Calling Reserve Unconfirmed Quantity API (from INVPPCIB.pls)
226: inv_pick_release_pub.reserve_Unconfirmed_Quantity
227: (
228: p_api_version => 1.0
229: ,p_init_msg_list => fnd_api.g_false
230: ,p_commit => fnd_api.g_false
231: ,x_return_status => l_return_status
232: ,x_msg_count => l_msg_count
233: ,x_msg_data => l_msg_data

Line 230: ,p_commit => fnd_api.g_false

226: inv_pick_release_pub.reserve_Unconfirmed_Quantity
227: (
228: p_api_version => 1.0
229: ,p_init_msg_list => fnd_api.g_false
230: ,p_commit => fnd_api.g_false
231: ,x_return_status => l_return_status
232: ,x_msg_count => l_msg_count
233: ,x_msg_data => l_msg_data
234: ,p_missing_quantity => l_missing_quantity

Line 249: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

245: IF (l_debug = 1) THEN
246: mdebug ('x_return_status : '|| x_return_status );
247: END IF;
248:
249: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
250: IF (l_debug = 1) THEN
251: mdebug(' inv_pick_release_pub.reserve_Unconfirmed_Quantity failed');
252: END IF;
253: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 253: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

249: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
250: IF (l_debug = 1) THEN
251: mdebug(' inv_pick_release_pub.reserve_Unconfirmed_Quantity failed');
252: END IF;
253: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
254: END IF;
255:
256: -- for debugging
257: IF (l_debug = 1) THEN

Line 272: , fnd_api.g_false

268: -- Log Exception
269:
270: Log_exception
271: ( 1.0
272: , fnd_api.g_false
273: , FND_API.G_false
274: , l_return_status
275: , l_msg_count
276: , l_msg_data

Line 273: , FND_API.G_false

269:
270: Log_exception
271: ( 1.0
272: , fnd_api.g_false
273: , FND_API.G_false
274: , l_return_status
275: , l_msg_count
276: , l_msg_data
277: , l_organization_id

Line 316: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

312: END LOOP;
313: END IF;
314:
315:
316: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
317: -- mdebug('FE');
318: FND_MSG_PUB.Add_Exc_Msg
319: ( 'Inadequate Qty'
320: , 'Calling Log Exception'

Line 322: RAISE FND_API.G_EXC_ERROR;

318: FND_MSG_PUB.Add_Exc_Msg
319: ( 'Inadequate Qty'
320: , 'Calling Log Exception'
321: );
322: RAISE FND_API.G_EXC_ERROR;
323: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
324: IF (l_debug = 1) THEN
325: mdebug('SE');
326: END IF;

Line 323: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

319: ( 'Inadequate Qty'
320: , 'Calling Log Exception'
321: );
322: RAISE FND_API.G_EXC_ERROR;
323: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
324: IF (l_debug = 1) THEN
325: mdebug('SE');
326: END IF;
327: FND_MSG_PUB.Add_Exc_Msg

Line 331: RAISE FND_API.G_EXC_ERROR;

327: FND_MSG_PUB.Add_Exc_Msg
328: ( 'Inadequate Qty'
329: , 'Calling Log Exception'
330: );
331: RAISE FND_API.G_EXC_ERROR;
332: END IF;
333: IF (l_debug = 1) THEN
334: mdebug('end of amins api');
335: END IF;

Line 338: WHEN FND_API.G_EXC_ERROR THEN

334: mdebug('end of amins api');
335: END IF;
336:
337: EXCEPTION
338: WHEN FND_API.G_EXC_ERROR THEN
339: x_return_status:=FND_API.G_RET_STS_ERROR;
340: fnd_msg_pub.count_and_get
341: ( p_count => x_msg_count
342: , p_data => x_msg_data

Line 339: x_return_status:=FND_API.G_RET_STS_ERROR;

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

Line 348: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

344:
345:
346: WHEN OTHERS THEN
347:
348: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
349: fnd_msg_pub.count_and_get
350: ( p_count => x_msg_count
351: , p_data => x_msg_data
352: );

Line 362: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false

358:
359: PROCEDURE Suggest_alternate_location
360: (
361: p_api_version_number IN NUMBER
362: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
363: , p_commit IN VARCHAR2 := FND_API.G_FALSE
364: , x_return_status OUT NOCOPY VARCHAR2
365: , x_msg_count OUT NOCOPY NUMBER
366: , x_msg_data OUT NOCOPY VARCHAR2

Line 363: , p_commit IN VARCHAR2 := FND_API.G_FALSE

359: PROCEDURE Suggest_alternate_location
360: (
361: p_api_version_number IN NUMBER
362: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
363: , p_commit IN VARCHAR2 := FND_API.G_FALSE
364: , x_return_status OUT NOCOPY VARCHAR2
365: , x_msg_count OUT NOCOPY NUMBER
366: , x_msg_data OUT NOCOPY VARCHAR2
367: , p_organization_id IN NUMBER

Line 380: l_return_status VARCHAR2(10):= FND_API.G_RET_STS_SUCCESS;

376: ) IS
377:
378:
379: l_trolin_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;
380: l_return_status VARCHAR2(10):= FND_API.G_RET_STS_SUCCESS;
381: l_msg_count NUMBER;
382: l_msg_data VARCHAR2(230);
383: l_trohdr_val_rec INV_Move_Order_PUB.Trolin_Val_Tbl_Type;
384: l_commit VARCHAR2(1) := FND_API.G_FALSE;

Line 384: l_commit VARCHAR2(1) := FND_API.G_FALSE;

380: l_return_status VARCHAR2(10):= FND_API.G_RET_STS_SUCCESS;
381: l_msg_count NUMBER;
382: l_msg_data VARCHAR2(230);
383: l_trohdr_val_rec INV_Move_Order_PUB.Trolin_Val_Tbl_Type;
384: l_commit VARCHAR2(1) := FND_API.G_FALSE;
385: l_order_count NUMBER := 1; /* total number of lines */
386:
387: l_trolin_val_tbl INV_Move_Order_PUB.Trolin_Val_Tbl_Type;
388: l_trolin_rec INV_Move_Order_PUB.trolin_rec_type;

Line 716: ,p_init_msg_list => fnd_api.g_false

712:
713: inv_pick_release_pub.Reserve_Unconfqty_lpn
714: (
715: p_api_version => 1.0
716: ,p_init_msg_list => fnd_api.g_false
717: ,p_commit => fnd_api.g_false
718: ,x_return_status => l_return_status
719: ,x_msg_count => l_msg_count
720: ,x_msg_data => l_msg_data

Line 717: ,p_commit => fnd_api.g_false

713: inv_pick_release_pub.Reserve_Unconfqty_lpn
714: (
715: p_api_version => 1.0
716: ,p_init_msg_list => fnd_api.g_false
717: ,p_commit => fnd_api.g_false
718: ,x_return_status => l_return_status
719: ,x_msg_count => l_msg_count
720: ,x_msg_data => l_msg_data
721: ,x_new_rsv_id => l_new_rsv_id -- bug8557788

Line 736: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

732: ,p_lot_number => l_lot
733: ,p_lpn_id => l_allocated_lpn_id
734: );
735:
736: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
737: mdebug(' inv_pick_release_pub.Reserve_Unconfqty_lpn failed');
738: l_cc_transfer_flag := 'F';
739: l_lot_qty := l_lot_qty + l_missing_quantity;
740: l_sec_lot_qty := l_sec_lot_qty + l_sec_missing_qty; --bug 8197499

Line 750: , p_init_msg_lst => fnd_api.g_false

746: l_rsv_rec.reservation_id := l_new_rsv_id; --l_reservation_id;
747: INV_RESERVATION_PVT.delete_reservation
748: (
749: p_api_version_number => 1.0
750: , p_init_msg_lst => fnd_api.g_false
751: , x_return_status => l_return_status
752: , x_msg_count => l_msg_count
753: , x_msg_data => l_msg_data
754: , p_rsv_rec => l_rsv_rec

Line 756: , p_validation_flag => fnd_api.g_true

752: , x_msg_count => l_msg_count
753: , x_msg_data => l_msg_data
754: , p_rsv_rec => l_rsv_rec
755: , p_original_serial_number=> l_original_serial_number
756: , p_validation_flag => fnd_api.g_true
757: );
758: mdebug ('l_return_status : '|| l_return_status );
759:
760: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 760: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

756: , p_validation_flag => fnd_api.g_true
757: );
758: mdebug ('l_return_status : '|| l_return_status );
759:
760: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
761: mdebug(' INV_RESERVATION_PVT.delete_reservation failed !!!');
762: l_cc_transfer_flag := 'F';
763: l_lot_qty := l_missing_quantity;
764: l_sec_lot_qty := l_sec_missing_qty;

Line 790: ,p_init_msg_list => fnd_api.g_false

786: mdebug('Before calling: inv_pick_release_pub.reserve_Unconfirmed_lpn');
787:
788: inv_pick_release_pub.Reserve_Unconfqty_lpn (
789: p_api_version => 1.0
790: ,p_init_msg_list => fnd_api.g_false
791: ,p_commit => fnd_api.g_false
792: ,x_return_status => l_return_status
793: ,x_msg_count => l_msg_count
794: ,x_msg_data => l_msg_data

Line 791: ,p_commit => fnd_api.g_false

787:
788: inv_pick_release_pub.Reserve_Unconfqty_lpn (
789: p_api_version => 1.0
790: ,p_init_msg_list => fnd_api.g_false
791: ,p_commit => fnd_api.g_false
792: ,x_return_status => l_return_status
793: ,x_msg_count => l_msg_count
794: ,x_msg_data => l_msg_data
795: ,x_new_rsv_id => l_new_rsv_id --bug8557758

Line 812: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

808: );
809:
810: mdebug ('l_return_status : '|| l_return_status );
811:
812: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
813: mdebug(' INV_RESERVATION_PVT.Reserve_Unconfqty_lpn failed');
814: l_cc_transfer_flag := 'F';
815: l_lot_qty := l_missing_quantity;
816: END IF;

Line 824: ,p_init_msg_lst => fnd_api.g_false

820: l_rsv_rec.reservation_id := l_new_rsv_id; --l_reservation_id;
821:
822: INV_RESERVATION_PVT.delete_reservation (
823: p_api_version_number => 1.0
824: ,p_init_msg_lst => fnd_api.g_false
825: ,x_return_status => l_return_status
826: ,x_msg_count => l_msg_count
827: ,x_msg_data => l_msg_data
828: ,p_rsv_rec => l_rsv_rec

Line 830: ,p_validation_flag => fnd_api.g_true);

826: ,x_msg_count => l_msg_count
827: ,x_msg_data => l_msg_data
828: ,p_rsv_rec => l_rsv_rec
829: ,p_original_serial_number=> l_original_serial_number
830: ,p_validation_flag => fnd_api.g_true);
831:
832: mdebug ('l_return_status : '|| l_return_status );
833:
834: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 834: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

830: ,p_validation_flag => fnd_api.g_true);
831:
832: mdebug ('l_return_status : '|| l_return_status );
833:
834: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
835: mdebug(' INV_RESERVATION_PVT.delete_reservation failed');
836: l_cc_transfer_flag := 'F';
837: l_lot_qty := l_missing_quantity;
838: l_sec_lot_qty := l_sec_missing_qty; --bug 8197499

Line 992: l_return_status := FND_API.G_RET_STS_SUCCESS;

988: WHERE msnt.transaction_temp_id = l_mmtt_id;
989:
990: END IF; --}
991:
992: l_return_status := FND_API.G_RET_STS_SUCCESS;
993:
994: -- l_move_order_type <> 3 need to create a cycle count reservation
995: -- need to create cycle count reservation for remaining qty in the sub/loc
996: mdebug('before create cycle count reservation');

Line 1078: , p_init_msg_lst => fnd_api.g_false

1074: /* Bug 7504490- Passing allocated_lpn_id to query_quantities to fetch the quantity to reserve
1075: for the LPN when the MMTT is for an allocated lpn */
1076: inv_quantity_tree_pub.query_quantities
1077: ( p_api_version_number => 1.0
1078: , p_init_msg_lst => fnd_api.g_false
1079: , x_return_status => l_return_status
1080: , x_msg_count => l_msg_count
1081: , x_msg_data => l_msg_data
1082: , p_organization_id => l_organization_id

Line 1108: IF (l_return_status = fnd_api.g_ret_sts_success ) THEN

1104: , x_sqs => l_sqs
1105: , x_satt => l_satt
1106: , x_satr => l_satr
1107: );
1108: IF (l_return_status = fnd_api.g_ret_sts_success ) THEN
1109: mdebug('after calling qty tree l_atr:' || l_atr||' l_att: '||l_att);
1110: mdebug('after calling qty tree l_atr:' || l_satr);
1111: mdebug('after calling qty tree l_qoh:' || l_qoh ||' l_rqoh: '||l_rqoh||' l_qr:'||l_qr||' l_qs:'||l_qs);
1112: ELSE

Line 1134: l_return_status := FND_API.G_RET_STS_SUCCESS;

1130: IF l_atr <> 0 THEN
1131:
1132: mdebug('Before calling: inv_reservation_pvt.create_reservation');
1133:
1134: l_return_status := FND_API.G_RET_STS_SUCCESS;
1135:
1136: INV_Reservation_pvt.Create_Reservation(
1137: p_api_version_number => 1.0
1138: , p_init_msg_lst => fnd_api.g_false

Line 1138: , p_init_msg_lst => fnd_api.g_false

1134: l_return_status := FND_API.G_RET_STS_SUCCESS;
1135:
1136: INV_Reservation_pvt.Create_Reservation(
1137: p_api_version_number => 1.0
1138: , p_init_msg_lst => fnd_api.g_false
1139: , x_return_status => l_return_status
1140: , x_msg_count => l_msg_count
1141: , x_msg_data => l_msg_data
1142: , p_rsv_rec => l_rsv_rec

Line 1145: , p_partial_reservation_flag => fnd_api.g_false

1141: , x_msg_data => l_msg_data
1142: , p_rsv_rec => l_rsv_rec
1143: , p_serial_number => l_dummy_sn
1144: , x_serial_number => l_dummy_sn
1145: , p_partial_reservation_flag => fnd_api.g_false
1146: , p_force_reservation_flag => fnd_api.g_false
1147: , p_validation_flag => fnd_api.g_false
1148: , x_quantity_reserved => l_qty_succ_reserved
1149: , x_secondary_quantity_reserved => l_sec_qty_succ_reserved

Line 1146: , p_force_reservation_flag => fnd_api.g_false

1142: , p_rsv_rec => l_rsv_rec
1143: , p_serial_number => l_dummy_sn
1144: , x_serial_number => l_dummy_sn
1145: , p_partial_reservation_flag => fnd_api.g_false
1146: , p_force_reservation_flag => fnd_api.g_false
1147: , p_validation_flag => fnd_api.g_false
1148: , x_quantity_reserved => l_qty_succ_reserved
1149: , x_secondary_quantity_reserved => l_sec_qty_succ_reserved
1150: , x_reservation_id => l_cc_res_id

Line 1147: , p_validation_flag => fnd_api.g_false

1143: , p_serial_number => l_dummy_sn
1144: , x_serial_number => l_dummy_sn
1145: , p_partial_reservation_flag => fnd_api.g_false
1146: , p_force_reservation_flag => fnd_api.g_false
1147: , p_validation_flag => fnd_api.g_false
1148: , x_quantity_reserved => l_qty_succ_reserved
1149: , x_secondary_quantity_reserved => l_sec_qty_succ_reserved
1150: , x_reservation_id => l_cc_res_id
1151: );

Line 1153: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1149: , x_secondary_quantity_reserved => l_sec_qty_succ_reserved
1150: , x_reservation_id => l_cc_res_id
1151: );
1152: -- Return an error if the create reservation call failed
1153: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1154: mdebug('error in create reservation');
1155: l_cc_insert_flag := 'F';
1156: ELSE
1157: mdebug('l_qty_succ_reserved :'|| l_qty_succ_reserved);

Line 1178: , p_init_msg_lst => fnd_api.g_false

1174:
1175: mdebug('lpn_id :'||l_rsv_rec.lpn_id );
1176: inv_quantity_tree_pub.query_quantities
1177: ( p_api_version_number => 1.0
1178: , p_init_msg_lst => fnd_api.g_false
1179: , x_return_status => l_return_status
1180: , x_msg_count => l_msg_count
1181: , x_msg_data => l_msg_data
1182: , p_organization_id => l_organization_id

Line 1208: IF (l_return_status = fnd_api.g_ret_sts_success ) THEN

1204: , x_sqs => l_sqs
1205: , x_satt => l_satt
1206: , x_satr => l_satr
1207: );
1208: IF (l_return_status = fnd_api.g_ret_sts_success ) THEN
1209: mdebug('after calling qty tree l_atr:' || l_atr||' l_att: '||l_att);
1210: mdebug('after calling qty tree l_atr:' || l_satr);
1211: mdebug('after calling qty tree l_qoh:' || l_qoh ||' l_rqoh: '||l_rqoh||' l_qr:'||l_qr||' l_qs:'||l_qs);
1212: ELSE

Line 1233: l_return_status := FND_API.G_RET_STS_SUCCESS;

1229:
1230: IF l_atr <> 0 THEN
1231:
1232: mdebug('Before calling: inv_reservation_pvt.create_reservation');
1233: l_return_status := FND_API.G_RET_STS_SUCCESS;
1234:
1235: INV_Reservation_pvt.Create_Reservation(
1236: p_api_version_number => 1.0
1237: , p_init_msg_lst => fnd_api.g_false

Line 1237: , p_init_msg_lst => fnd_api.g_false

1233: l_return_status := FND_API.G_RET_STS_SUCCESS;
1234:
1235: INV_Reservation_pvt.Create_Reservation(
1236: p_api_version_number => 1.0
1237: , p_init_msg_lst => fnd_api.g_false
1238: , x_return_status => l_return_status
1239: , x_msg_count => l_msg_count
1240: , x_msg_data => l_msg_data
1241: , p_rsv_rec => l_rsv_rec

Line 1244: , p_partial_reservation_flag => fnd_api.g_false

1240: , x_msg_data => l_msg_data
1241: , p_rsv_rec => l_rsv_rec
1242: , p_serial_number => l_dummy_sn
1243: , x_serial_number => l_dummy_sn
1244: , p_partial_reservation_flag => fnd_api.g_false
1245: , p_force_reservation_flag => fnd_api.g_false
1246: , p_validation_flag => fnd_api.g_false
1247: , x_quantity_reserved => l_qty_succ_reserved
1248: , x_secondary_quantity_reserved => l_sec_qty_succ_reserved

Line 1245: , p_force_reservation_flag => fnd_api.g_false

1241: , p_rsv_rec => l_rsv_rec
1242: , p_serial_number => l_dummy_sn
1243: , x_serial_number => l_dummy_sn
1244: , p_partial_reservation_flag => fnd_api.g_false
1245: , p_force_reservation_flag => fnd_api.g_false
1246: , p_validation_flag => fnd_api.g_false
1247: , x_quantity_reserved => l_qty_succ_reserved
1248: , x_secondary_quantity_reserved => l_sec_qty_succ_reserved
1249: , x_reservation_id => l_cc_res_id

Line 1246: , p_validation_flag => fnd_api.g_false

1242: , p_serial_number => l_dummy_sn
1243: , x_serial_number => l_dummy_sn
1244: , p_partial_reservation_flag => fnd_api.g_false
1245: , p_force_reservation_flag => fnd_api.g_false
1246: , p_validation_flag => fnd_api.g_false
1247: , x_quantity_reserved => l_qty_succ_reserved
1248: , x_secondary_quantity_reserved => l_sec_qty_succ_reserved
1249: , x_reservation_id => l_cc_res_id
1250: );

Line 1252: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1248: , x_secondary_quantity_reserved => l_sec_qty_succ_reserved
1249: , x_reservation_id => l_cc_res_id
1250: );
1251: -- Return an error if the create reservation call failed
1252: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1253: mdebug('error in create reservation');
1254: l_cc_insert_flag := 'F';
1255: ELSE
1256: mdebug('l_qty_succ_reserved :'|| l_qty_succ_reserved);

Line 1283: , p_init_msg_lst => fnd_api.g_false

1279: for the LPN when the MMTT is for an allocated lpn */
1280:
1281: inv_quantity_tree_pub.query_quantities
1282: ( p_api_version_number => 1.0
1283: , p_init_msg_lst => fnd_api.g_false
1284: , x_return_status => l_return_status
1285: , x_msg_count => l_msg_count
1286: , x_msg_data => l_msg_data
1287: , p_organization_id => l_organization_id

Line 1313: IF (l_return_status = fnd_api.g_ret_sts_success ) THEN

1309: , x_sqs => l_sqs
1310: , x_satt => l_satt
1311: , x_satr => l_satr
1312: );
1313: IF (l_return_status = fnd_api.g_ret_sts_success ) THEN
1314: mdebug('after calling qty tree l_atr:' || l_atr||' l_att:'||l_att);
1315: mdebug('after calling qty tree l_qoh:' || l_qoh ||' l_rqoh: '||l_rqoh||' l_qr:'||l_qr||' l_qs:'||l_qs);
1316: ELSE
1317: mdebug('calling qty tree API failed ');

Line 1336: l_return_status := FND_API.G_RET_STS_SUCCESS;

1332: l_rsv_rec.secondary_reservation_quantity := l_satr;
1333:
1334: mdebug(' primary_reservation_quantity :'||l_rsv_rec.primary_reservation_quantity);
1335:
1336: l_return_status := FND_API.G_RET_STS_SUCCESS;
1337:
1338: mdebug('Before calling: inv_reservation_pvt.create_reservation');
1339:
1340: IF l_atr <> 0 THEN

Line 1343: , p_init_msg_lst => fnd_api.g_false

1339:
1340: IF l_atr <> 0 THEN
1341: INV_Reservation_pvt.Create_Reservation(
1342: p_api_version_number => 1.0
1343: , p_init_msg_lst => fnd_api.g_false
1344: , x_return_status => l_return_status
1345: , x_msg_count => l_msg_count
1346: , x_msg_data => l_msg_data
1347: , p_rsv_rec => l_rsv_rec

Line 1350: , p_partial_reservation_flag => fnd_api.g_false

1346: , x_msg_data => l_msg_data
1347: , p_rsv_rec => l_rsv_rec
1348: , p_serial_number => l_dummy_sn
1349: , x_serial_number => l_dummy_sn
1350: , p_partial_reservation_flag => fnd_api.g_false
1351: , p_force_reservation_flag => fnd_api.g_false
1352: , p_validation_flag => fnd_api.g_false
1353: , x_quantity_reserved => l_qty_succ_reserved
1354: , x_secondary_quantity_reserved => l_sec_qty_succ_reserved

Line 1351: , p_force_reservation_flag => fnd_api.g_false

1347: , p_rsv_rec => l_rsv_rec
1348: , p_serial_number => l_dummy_sn
1349: , x_serial_number => l_dummy_sn
1350: , p_partial_reservation_flag => fnd_api.g_false
1351: , p_force_reservation_flag => fnd_api.g_false
1352: , p_validation_flag => fnd_api.g_false
1353: , x_quantity_reserved => l_qty_succ_reserved
1354: , x_secondary_quantity_reserved => l_sec_qty_succ_reserved
1355: , x_reservation_id => l_cc_res_id

Line 1352: , p_validation_flag => fnd_api.g_false

1348: , p_serial_number => l_dummy_sn
1349: , x_serial_number => l_dummy_sn
1350: , p_partial_reservation_flag => fnd_api.g_false
1351: , p_force_reservation_flag => fnd_api.g_false
1352: , p_validation_flag => fnd_api.g_false
1353: , x_quantity_reserved => l_qty_succ_reserved
1354: , x_secondary_quantity_reserved => l_sec_qty_succ_reserved
1355: , x_reservation_id => l_cc_res_id
1356: );

Line 1358: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1354: , x_secondary_quantity_reserved => l_sec_qty_succ_reserved
1355: , x_reservation_id => l_cc_res_id
1356: );
1357: -- Return an error if the create reservation call failed
1358: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1359: mdebug('error in create reservation');
1360: l_cc_insert_flag := 'F';
1361: ELSE
1362: mdebug('l_qty_succ_reserved :'|| l_qty_succ_reserved);

Line 1387: , p_init_msg_lst => fnd_api.g_false

1383: inv_quantity_tree_pub.clear_quantity_cache;
1384:
1385: inv_quantity_tree_pub.query_quantities
1386: ( p_api_version_number => 1.0
1387: , p_init_msg_lst => fnd_api.g_false
1388: , x_return_status => l_return_status
1389: , x_msg_count => l_msg_count
1390: , x_msg_data => l_msg_data
1391: , p_organization_id => l_organization_id

Line 1417: IF (l_return_status = fnd_api.g_ret_sts_success ) THEN

1413: , x_sqs => l_sqs
1414: , x_satt => l_satt
1415: , x_satr => l_satr
1416: );
1417: IF (l_return_status = fnd_api.g_ret_sts_success ) THEN
1418: mdebug('after calling qty tree l_atr:' || l_atr||' l_att:'||l_att);
1419: mdebug('after calling qty tree l_qoh:' || l_qoh ||' l_rqoh: '||l_rqoh||' l_qr:'||l_qr||' l_qs:'||l_qs);
1420: ELSE
1421: mdebug('calling qty tree API failed ');

Line 1441: l_return_status := FND_API.G_RET_STS_SUCCESS;

1437: l_rsv_rec.secondary_reservation_quantity := l_satr;
1438:
1439: mdebug(' primary_reservation_quantity :'||l_rsv_rec.primary_reservation_quantity);
1440:
1441: l_return_status := FND_API.G_RET_STS_SUCCESS;
1442:
1443: mdebug('Before calling: inv_reservation_pvt.create_reservation');
1444:
1445: IF l_atr <> 0 THEN

Line 1449: , p_init_msg_lst => fnd_api.g_false

1445: IF l_atr <> 0 THEN
1446:
1447: INV_Reservation_pvt.Create_Reservation(
1448: p_api_version_number => 1.0
1449: , p_init_msg_lst => fnd_api.g_false
1450: , x_return_status => l_return_status
1451: , x_msg_count => l_msg_count
1452: , x_msg_data => l_msg_data
1453: , p_rsv_rec => l_rsv_rec

Line 1456: , p_partial_reservation_flag => fnd_api.g_false

1452: , x_msg_data => l_msg_data
1453: , p_rsv_rec => l_rsv_rec
1454: , p_serial_number => l_dummy_sn
1455: , x_serial_number => l_dummy_sn
1456: , p_partial_reservation_flag => fnd_api.g_false
1457: , p_force_reservation_flag => fnd_api.g_false
1458: , p_validation_flag => fnd_api.g_false
1459: , x_quantity_reserved => l_qty_succ_reserved
1460: , x_secondary_quantity_reserved => l_sec_qty_succ_reserved

Line 1457: , p_force_reservation_flag => fnd_api.g_false

1453: , p_rsv_rec => l_rsv_rec
1454: , p_serial_number => l_dummy_sn
1455: , x_serial_number => l_dummy_sn
1456: , p_partial_reservation_flag => fnd_api.g_false
1457: , p_force_reservation_flag => fnd_api.g_false
1458: , p_validation_flag => fnd_api.g_false
1459: , x_quantity_reserved => l_qty_succ_reserved
1460: , x_secondary_quantity_reserved => l_sec_qty_succ_reserved
1461: , x_reservation_id => l_cc_res_id

Line 1458: , p_validation_flag => fnd_api.g_false

1454: , p_serial_number => l_dummy_sn
1455: , x_serial_number => l_dummy_sn
1456: , p_partial_reservation_flag => fnd_api.g_false
1457: , p_force_reservation_flag => fnd_api.g_false
1458: , p_validation_flag => fnd_api.g_false
1459: , x_quantity_reserved => l_qty_succ_reserved
1460: , x_secondary_quantity_reserved => l_sec_qty_succ_reserved
1461: , x_reservation_id => l_cc_res_id
1462: );

Line 1464: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1460: , x_secondary_quantity_reserved => l_sec_qty_succ_reserved
1461: , x_reservation_id => l_cc_res_id
1462: );
1463: -- Return an error if the create reservation call failed
1464: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1465: mdebug('error in create reservation');
1466: l_cc_insert_flag := 'F';
1467: ELSE
1468: mdebug('l_qty_succ_reserved :'|| l_qty_succ_reserved);

Line 1487: l_return_status := FND_API.G_RET_STS_SUCCESS;

1483: -- DELETE FROM mtl_transaction_lots_temp mtlt
1484: -- WHERE mtlt.transaction_temp_id = l_mmtt_id;
1485: --end if;
1486:
1487: l_return_status := FND_API.G_RET_STS_SUCCESS;
1488:
1489: SELECT quantity_detailed
1490: , secondary_quantity_detailed
1491: , line_status

Line 1804: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1800:
1801: inv_wip_picking_pvt.g_pick_release_caller := NULL; -- added for bug 9895550
1802: inv_wip_picking_pvt.g_old_detailed_qty := -999; -- added for bug 9895550
1803:
1804: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1805: mdebug(' inv_replenish_detail_pub.line_details_pub failed');
1806: --ROLLBACK TO SAVEPOINT before_allocation;
1807: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1808: END IF;

Line 1807: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1803:
1804: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1805: mdebug(' inv_replenish_detail_pub.line_details_pub failed');
1806: --ROLLBACK TO SAVEPOINT before_allocation;
1807: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1808: END IF;
1809:
1810: --mdebug('After calling: INV_Replenish_Detail_PUB.Line_Details_PUB ');
1811:

Line 1891: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1887: END LOOP;
1888: END IF;
1889:
1890:
1891: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1892: FND_MSG_PUB.Add_Exc_Msg
1893: ( 'Suggest Alt Loc'
1894: , 'Call Pick Release'
1895: );

Line 1896: RAISE FND_API.G_EXC_ERROR;

1892: FND_MSG_PUB.Add_Exc_Msg
1893: ( 'Suggest Alt Loc'
1894: , 'Call Pick Release'
1895: );
1896: RAISE FND_API.G_EXC_ERROR;
1897: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1898: FND_MSG_PUB.Add_Exc_Msg
1899: ( 'Suggest Alt Loc'
1900: , 'Call Pick Release'

Line 1897: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1893: ( 'Suggest Alt Loc'
1894: , 'Call Pick Release'
1895: );
1896: RAISE FND_API.G_EXC_ERROR;
1897: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1898: FND_MSG_PUB.Add_Exc_Msg
1899: ( 'Suggest Alt Loc'
1900: , 'Call Pick Release'
1901: );

Line 1902: RAISE FND_API.G_EXC_ERROR;

1898: FND_MSG_PUB.Add_Exc_Msg
1899: ( 'Suggest Alt Loc'
1900: , 'Call Pick Release'
1901: );
1902: RAISE FND_API.G_EXC_ERROR;
1903: END IF;
1904:
1905: mdebug('before exception section');
1906:

Line 1909: WHEN FND_API.G_EXC_ERROR THEN

1905: mdebug('before exception section');
1906:
1907: EXCEPTION
1908:
1909: WHEN FND_API.G_EXC_ERROR THEN
1910:
1911: Raise FND_API.G_EXC_ERROR;
1912:
1913: WHEN OTHERS THEN

Line 1911: Raise FND_API.G_EXC_ERROR;

1907: EXCEPTION
1908:
1909: WHEN FND_API.G_EXC_ERROR THEN
1910:
1911: Raise FND_API.G_EXC_ERROR;
1912:
1913: WHEN OTHERS THEN
1914: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1915: THEN

Line 1921: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

1917: ( 'INV_Move_Order_PUB'
1918: , 'Create_Move_Orders'
1919: );
1920: END IF;
1921: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1922:
1923: END Suggest_alternate_location ;
1924:
1925:

Line 1932: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false

1928:
1929: PROCEDURE Log_exception
1930: (
1931: p_api_version_number IN NUMBER
1932: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
1933: , p_commit IN VARCHAR2 := FND_API.G_FALSE
1934: , x_return_status OUT NOCOPY VARCHAR2
1935: , x_msg_count OUT NOCOPY NUMBER
1936: , x_msg_data OUT NOCOPY VARCHAR2

Line 1933: , p_commit IN VARCHAR2 := FND_API.G_FALSE

1929: PROCEDURE Log_exception
1930: (
1931: p_api_version_number IN NUMBER
1932: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
1933: , p_commit IN VARCHAR2 := FND_API.G_FALSE
1934: , x_return_status OUT NOCOPY VARCHAR2
1935: , x_msg_count OUT NOCOPY NUMBER
1936: , x_msg_data OUT NOCOPY VARCHAR2
1937: , p_organization_id IN NUMBER

Line 2064: x_return_status := FND_API.G_RET_STS_SUCCESS;

2060: SET reason_id = p_reason_id
2061: WHERE transaction_header_id = p_mmtt_id;
2062: END IF;
2063:
2064: x_return_status := FND_API.G_RET_STS_SUCCESS;
2065:
2066: exception
2067: when others THEN
2068: x_return_status:=FND_API.G_RET_STS_ERROR;

Line 2068: x_return_status:=FND_API.G_RET_STS_ERROR;

2064: x_return_status := FND_API.G_RET_STS_SUCCESS;
2065:
2066: exception
2067: when others THEN
2068: x_return_status:=FND_API.G_RET_STS_ERROR;
2069:
2070: l_return_err := 'Insert into WMS_Exceptions failed'||
2071: substrb(sqlerrm,1,55);
2072: raise_application_error(-20000,l_return_err);

Line 2197: IF x_return_status <> fnd_api.g_ret_sts_success THEN

2193: IF (l_debug = 1) THEN
2194: mdebug('after calling cleanup_task for transaction:'||l_mmtt_temp_id);
2195: END IF;
2196:
2197: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2198:
2199: IF l_debug = 1 THEN
2200: mdebug('cleanup_task (W) :Error occurred while calling cleanup_task');
2201: END IF ;

Line 2202: RAISE fnd_api.g_exc_error;

2198:
2199: IF l_debug = 1 THEN
2200: mdebug('cleanup_task (W) :Error occurred while calling cleanup_task');
2201: END IF ;
2202: RAISE fnd_api.g_exc_error;
2203:
2204: END IF;
2205:
2206: END LOOP;

Line 2228: WHEN fnd_api.g_exc_error THEN

2224: , x_msg_count =>x_msg_count
2225: , x_msg_data =>x_msg_data );
2226: mdebug('END : ' || l_proc_name );
2227: EXCEPTION
2228: WHEN fnd_api.g_exc_error THEN
2229: x_return_status := l_g_ret_sts_error;
2230: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2231: mdebug('ROLLBACK ' );
2232: ROLLBACK ;

Line 2233: mdebug('RAISE fnd_api.g_exc_error: ' || SQLERRM);

2229: x_return_status := l_g_ret_sts_error;
2230: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2231: mdebug('ROLLBACK ' );
2232: ROLLBACK ;
2233: mdebug('RAISE fnd_api.g_exc_error: ' || SQLERRM);
2234: WHEN OTHERS THEN
2235: x_return_status := l_g_ret_sts_unexp_error;
2236: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2237: mdebug('ROLLBACK ' );

Line 2239: mdebug('RAISE fnd_api.g_exc_error: ' || SQLERRM);

2235: x_return_status := l_g_ret_sts_unexp_error;
2236: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2237: mdebug('ROLLBACK ' );
2238: ROLLBACK ;
2239: mdebug('RAISE fnd_api.g_exc_error: ' || SQLERRM);
2240:
2241:
2242: END;
2243:

Line 2380: x_return_status := fnd_api.g_ret_sts_success;

2376: FROM mtl_material_transactions_temp t1
2377: WHERE t1.parent_line_id = mmtt.transaction_temp_id);
2378:
2379: BEGIN
2380: x_return_status := fnd_api.g_ret_sts_success;
2381: g_debug := l_debug;
2382: g_module_name := l_proc_name;
2383: l_progress := '110';
2384: IF (l_debug = 1) THEN

Line 2473: p_init_msg_list => fnd_api.g_false,

2469: mdebug ('l_progress: ' || l_progress );
2470: END IF;
2471: wms_workflow_wrappers.wf_wrapper(
2472: p_api_version => 1.0,
2473: p_init_msg_list => fnd_api.g_false,
2474: p_commit => fnd_api.g_false,
2475: p_org_id => l_org_id ,
2476: p_rsn_id => p_qty_rsn_id,
2477: p_calling_program => l_calling_program,

Line 2474: p_commit => fnd_api.g_false,

2470: END IF;
2471: wms_workflow_wrappers.wf_wrapper(
2472: p_api_version => 1.0,
2473: p_init_msg_list => fnd_api.g_false,
2474: p_commit => fnd_api.g_false,
2475: p_org_id => l_org_id ,
2476: p_rsn_id => p_qty_rsn_id,
2477: p_calling_program => l_calling_program,
2478: p_tmp_id => l_txn_temp_id,

Line 2487: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

2483: x_msg_count => x_msg_count,
2484: x_msg_data => x_msg_data);
2485:
2486: IF (l_debug = 1) THEN mdebug('x_return_status = ' || x_return_status); END IF;
2487: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2488: fnd_message.set_name('WMS', 'WMS_MULT_LPN_ERROR');
2489: fnd_msg_pub.ADD;
2490: RAISE fnd_api.g_exc_unexpected_error;
2491: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN

Line 2490: RAISE fnd_api.g_exc_unexpected_error;

2486: IF (l_debug = 1) THEN mdebug('x_return_status = ' || x_return_status); END IF;
2487: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2488: fnd_message.set_name('WMS', 'WMS_MULT_LPN_ERROR');
2489: fnd_msg_pub.ADD;
2490: RAISE fnd_api.g_exc_unexpected_error;
2491: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
2492: fnd_message.set_name('WMS', 'WMS_MULT_LPN_ERROR');
2493: fnd_msg_pub.ADD;
2494: RAISE fnd_api.g_exc_error;

Line 2491: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN

2487: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2488: fnd_message.set_name('WMS', 'WMS_MULT_LPN_ERROR');
2489: fnd_msg_pub.ADD;
2490: RAISE fnd_api.g_exc_unexpected_error;
2491: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
2492: fnd_message.set_name('WMS', 'WMS_MULT_LPN_ERROR');
2493: fnd_msg_pub.ADD;
2494: RAISE fnd_api.g_exc_error;
2495: END IF;

Line 2494: RAISE fnd_api.g_exc_error;

2490: RAISE fnd_api.g_exc_unexpected_error;
2491: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
2492: fnd_message.set_name('WMS', 'WMS_MULT_LPN_ERROR');
2493: fnd_msg_pub.ADD;
2494: RAISE fnd_api.g_exc_error;
2495: END IF;
2496: -- MRANA : added the following 3392471 . : 26-feb-04
2497: -- Cascade delete the current MMTT and WDT That was just processed
2498:

Line 2515: IF x_return_status <> fnd_api.g_ret_sts_success THEN

2511: ,p_update_parent => l_update_parent
2512: );
2513: mdebug ('x_return_status ' || x_return_status);
2514:
2515: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2516: IF l_debug = 1 THEN
2517: mdebug('CLEANUP_TASK: Error occurred while deleting MMTT');
2518: END IF;
2519: RAISE fnd_api.g_exc_error;

Line 2519: RAISE fnd_api.g_exc_error;

2515: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2516: IF l_debug = 1 THEN
2517: mdebug('CLEANUP_TASK: Error occurred while deleting MMTT');
2518: END IF;
2519: RAISE fnd_api.g_exc_error;
2520: END IF;
2521: --}
2522: -- If WorkFlow does not exist only then the following shld be performed
2523: ELSE --{ wf <=0

Line 2696: , p_init_msg_lst => fnd_api.g_false

2692: END IF;
2693:
2694: inv_reservation_pub.update_reservation(
2695: p_api_version_number => 1.0
2696: , p_init_msg_lst => fnd_api.g_false
2697: , x_return_status => x_return_status
2698: , x_msg_count => x_msg_count
2699: , x_msg_data => x_msg_data
2700: , p_original_rsv_rec => l_old_upd_resv_rec

Line 2704: , p_validation_flag => fnd_api.g_true

2700: , p_original_rsv_rec => l_old_upd_resv_rec
2701: , p_to_rsv_rec => l_new_upd_resv_rec
2702: , p_original_serial_number => l_upd_dummy_sn
2703: , p_to_serial_number => l_upd_dummy_sn
2704: , p_validation_flag => fnd_api.g_true
2705: );
2706:
2707: IF (l_debug = 1) THEN
2708: mdebug('CLEANUP_TASK: return of update_reservation api : ' || x_return_status);

Line 2735: IF x_return_status <> fnd_api.g_ret_sts_success THEN

2731: , p_transaction_temp_id => l_txn_temp_id
2732: ,p_update_parent => l_update_parent
2733: );
2734:
2735: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2736: IF l_debug = 1 THEN
2737: mdebug('CLEANUP_TASK: Error occurred while deleting MMTT');
2738: END IF;
2739: RAISE fnd_api.g_exc_error;

Line 2739: RAISE fnd_api.g_exc_error;

2735: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2736: IF l_debug = 1 THEN
2737: mdebug('CLEANUP_TASK: Error occurred while deleting MMTT');
2738: END IF;
2739: RAISE fnd_api.g_exc_error;
2740: END IF;
2741:
2742: IF (l_wf <= 0) or (p_qty_rsn_id <= 0) then
2743: l_progress := '300';

Line 2788: RAISE fnd_api.g_exc_error;

2784: THEN
2785: IF (l_debug = 1) THEN
2786: mdebug('CLEANUP_TASK: Unexpected error occurrend while calling BackOrder API');
2787: END IF;
2788: RAISE fnd_api.g_exc_error;
2789: END IF;
2790:
2791:
2792: ELSIF l_mo_type IN (INV_GLOBALS.G_MOVE_ORDER_REQUISITION, INV_GLOBALS.G_MOVE_ORDER_REPLENISHMENT) THEN

Line 2811: IF x_return_status <> fnd_api.g_ret_sts_success THEN

2807: , p_transaction_temp_id => l_txn_temp_id
2808: ,p_update_parent => l_update_parent
2809: );
2810:
2811: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2812: IF l_debug = 1 THEN
2813: mdebug('CLEANUP_TASK: Error occurred while deleting MMTT');
2814: END IF;
2815: RAISE fnd_api.g_exc_error;

Line 2815: RAISE fnd_api.g_exc_error;

2811: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2812: IF l_debug = 1 THEN
2813: mdebug('CLEANUP_TASK: Error occurred while deleting MMTT');
2814: END IF;
2815: RAISE fnd_api.g_exc_error;
2816: END IF;
2817:
2818: --Bug 5162468 for Fill kill zero pick condition
2819: --close the MO line

Line 2834: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2830: mdebug('Replenishment Move Order... Closing the Move Order');
2831: END IF;
2832:
2833: INV_MO_ADMIN_PUB.close_line(1.0,'F','F','F',l_mo_line_id,x_msg_count,x_msg_data,l_return_status);
2834: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2835: RAISE FND_API.G_EXC_ERROR;
2836: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2837: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2838: END IF;

Line 2835: RAISE FND_API.G_EXC_ERROR;

2831: END IF;
2832:
2833: INV_MO_ADMIN_PUB.close_line(1.0,'F','F','F',l_mo_line_id,x_msg_count,x_msg_data,l_return_status);
2834: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2835: RAISE FND_API.G_EXC_ERROR;
2836: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2837: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2838: END IF;
2839: wms_task_dispatch_gen.process_remaining_wdds_repl(l_mo_line_id, l_org_id); --BUG14014540

Line 2836: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2832:
2833: INV_MO_ADMIN_PUB.close_line(1.0,'F','F','F',l_mo_line_id,x_msg_count,x_msg_data,l_return_status);
2834: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2835: RAISE FND_API.G_EXC_ERROR;
2836: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2837: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2838: END IF;
2839: wms_task_dispatch_gen.process_remaining_wdds_repl(l_mo_line_id, l_org_id); --BUG14014540
2840: END IF;

Line 2837: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2833: INV_MO_ADMIN_PUB.close_line(1.0,'F','F','F',l_mo_line_id,x_msg_count,x_msg_data,l_return_status);
2834: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2835: RAISE FND_API.G_EXC_ERROR;
2836: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2837: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2838: END IF;
2839: wms_task_dispatch_gen.process_remaining_wdds_repl(l_mo_line_id, l_org_id); --BUG14014540
2840: END IF;
2841:

Line 2861: , p_init_msg_lst => fnd_api.g_false

2857: END LOOP;
2858:
2859: wms_txnrsn_actions_pub.log_exception(
2860: p_api_version_number => 1.0
2861: , p_init_msg_lst => fnd_api.g_false
2862: , p_commit => fnd_api.g_false
2863: , x_return_status => x_return_status
2864: , x_msg_count => x_msg_count
2865: , x_msg_data => x_msg_data

Line 2862: , p_commit => fnd_api.g_false

2858:
2859: wms_txnrsn_actions_pub.log_exception(
2860: p_api_version_number => 1.0
2861: , p_init_msg_lst => fnd_api.g_false
2862: , p_commit => fnd_api.g_false
2863: , x_return_status => x_return_status
2864: , x_msg_count => x_msg_count
2865: , x_msg_data => x_msg_data
2866: , p_organization_id => l_org_id

Line 2878: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

2874: , p_reason_id => p_qty_rsn_id
2875: , p_discrepancy_type => 1
2876: , p_user_id => p_employee_id);
2877:
2878: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2879: fnd_message.set_name('WMS', 'WMS_LOG_EXCEPTION_FAIL');
2880: fnd_msg_pub.ADD;
2881: RAISE fnd_api.g_exc_unexpected_error;
2882: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN

Line 2881: RAISE fnd_api.g_exc_unexpected_error;

2877:
2878: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2879: fnd_message.set_name('WMS', 'WMS_LOG_EXCEPTION_FAIL');
2880: fnd_msg_pub.ADD;
2881: RAISE fnd_api.g_exc_unexpected_error;
2882: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
2883: fnd_message.set_name('WMS', 'WMS_LOG_EXCEPTION_FAIL');
2884: fnd_msg_pub.ADD;
2885: RAISE fnd_api.g_exc_error;

Line 2882: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN

2878: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2879: fnd_message.set_name('WMS', 'WMS_LOG_EXCEPTION_FAIL');
2880: fnd_msg_pub.ADD;
2881: RAISE fnd_api.g_exc_unexpected_error;
2882: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
2883: fnd_message.set_name('WMS', 'WMS_LOG_EXCEPTION_FAIL');
2884: fnd_msg_pub.ADD;
2885: RAISE fnd_api.g_exc_error;
2886: END IF;

Line 2885: RAISE fnd_api.g_exc_error;

2881: RAISE fnd_api.g_exc_unexpected_error;
2882: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
2883: fnd_message.set_name('WMS', 'WMS_LOG_EXCEPTION_FAIL');
2884: fnd_msg_pub.ADD;
2885: RAISE fnd_api.g_exc_error;
2886: END IF;
2887:
2888: l_progress := '390';
2889:

Line 2910: IF x_return_status <> fnd_api.g_ret_sts_success THEN

2906: , p_transaction_temp_id => l_parent_line_id
2907: ,p_update_parent => l_update_parent
2908: );
2909:
2910: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2911: mdebug ('Clean up task in loop for deleting parent line ');
2912: IF l_debug = 1 THEN
2913: mdebug('CLEANUP_TASK: Error occurred while deleting parent line inMMTT');
2914: END IF;

Line 2915: RAISE fnd_api.g_exc_error;

2911: mdebug ('Clean up task in loop for deleting parent line ');
2912: IF l_debug = 1 THEN
2913: mdebug('CLEANUP_TASK: Error occurred while deleting parent line inMMTT');
2914: END IF;
2915: RAISE fnd_api.g_exc_error;
2916: END IF;
2917: END IF; --for parent line IF
2918:
2919: CLOSE c_mmtt_info;

Line 2923: WHEN fnd_api.g_exc_error THEN

2919: CLOSE c_mmtt_info;
2920: --COMMIT; --???
2921: mdebug('END : ' || l_proc_name );
2922: EXCEPTION
2923: WHEN fnd_api.g_exc_error THEN
2924: x_return_status := l_g_ret_sts_error;
2925: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2926: mdebug('ROLLBACK ' );
2927: ROLLBACK ;

Line 2929: mdebug('RAISE fnd_api.g_exc_error: ' || SQLERRM);

2925: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2926: mdebug('ROLLBACK ' );
2927: ROLLBACK ;
2928: mdebug('l_progress = ' || l_proc_name || ':'|| l_progress);
2929: mdebug('RAISE fnd_api.g_exc_error: ' || SQLERRM);
2930: WHEN OTHERS THEN
2931: x_return_status := l_g_ret_sts_unexp_error;
2932: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2933: mdebug('ROLLBACK ' );

Line 2936: mdebug('RAISE fnd_api.g_exc_error: ' || SQLERRM);

2932: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2933: mdebug('ROLLBACK ' );
2934: ROLLBACK ;
2935: mdebug('l_progress = ' || l_proc_name || ':'|| l_progress);
2936: mdebug('RAISE fnd_api.g_exc_error: ' || SQLERRM);
2937:
2938: END cleanup_task;
2939:
2940:

Line 3146: , p_init_msg_lst => fnd_api.g_false

3142: END IF;
3143:
3144: Log_exception(
3145: p_api_version_number => 1.0
3146: , p_init_msg_lst => fnd_api.g_false
3147: , p_commit => fnd_api.g_false
3148: , x_return_status => x_return_status
3149: , x_msg_count => x_msg_count
3150: , x_msg_data => x_msg_data

Line 3147: , p_commit => fnd_api.g_false

3143:
3144: Log_exception(
3145: p_api_version_number => 1.0
3146: , p_init_msg_lst => fnd_api.g_false
3147: , p_commit => fnd_api.g_false
3148: , x_return_status => x_return_status
3149: , x_msg_count => x_msg_count
3150: , x_msg_data => x_msg_data
3151: , p_organization_id => p_organization_id

Line 3168: x_return_status:=FND_API.G_RET_STS_ERROR;

3164: );
3165:
3166: EXCEPTION
3167: WHEN OTHERS THEN
3168: x_return_status:=FND_API.G_RET_STS_ERROR;
3169: l_return_err := 'Insert into WMS_Exceptions failed'|| substrb(sqlerrm,1,55);
3170: raise_application_error(-20000,l_return_err);
3171:
3172: END Log_exception;