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

Line 47: x_return_status := FND_API.G_RET_STS_SUCCESS;

43: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
44: BEGIN
45:
46: -- Initialize API return status to success
47: x_return_status := FND_API.G_RET_STS_SUCCESS;
48: /* If the locator has a physical_location_id
49: then use the physical_location_id for further
50: processing.Else we have to use the inventory_location_id
51: for further processing

Line 139: WHEN fnd_api.g_exc_error THEN

135: END IF;
136:
137: EXCEPTION
138:
139: WHEN fnd_api.g_exc_error THEN
140: x_return_status := fnd_api.g_ret_sts_error;
141: fnd_msg_pub.count_and_get
142: ( p_count => x_msg_count,
143: p_data => x_msg_data

Line 140: x_return_status := fnd_api.g_ret_sts_error;

136:
137: EXCEPTION
138:
139: WHEN fnd_api.g_exc_error THEN
140: x_return_status := fnd_api.g_ret_sts_error;
141: fnd_msg_pub.count_and_get
142: ( p_count => x_msg_count,
143: p_data => x_msg_data
144: );

Line 146: WHEN fnd_api.g_exc_unexpected_error THEN

142: ( p_count => x_msg_count,
143: p_data => x_msg_data
144: );
145:
146: WHEN fnd_api.g_exc_unexpected_error THEN
147: x_return_status := fnd_api.g_ret_sts_unexp_error ;
148: fnd_msg_pub.count_and_get
149: ( p_count => x_msg_count,
150: p_data => x_msg_data

Line 147: x_return_status := fnd_api.g_ret_sts_unexp_error ;

143: p_data => x_msg_data
144: );
145:
146: WHEN fnd_api.g_exc_unexpected_error THEN
147: x_return_status := fnd_api.g_ret_sts_unexp_error ;
148: fnd_msg_pub.count_and_get
149: ( p_count => x_msg_count,
150: p_data => x_msg_data
151: );

Line 154: x_return_status := fnd_api.g_ret_sts_error;

150: p_data => x_msg_data
151: );
152:
153: WHEN NO_DATA_FOUND THEN
154: x_return_status := fnd_api.g_ret_sts_error;
155:
156: WHEN OTHERS THEN
157: x_return_status := fnd_api.g_ret_sts_unexp_error;
158: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)

Line 157: x_return_status := fnd_api.g_ret_sts_unexp_error;

153: WHEN NO_DATA_FOUND THEN
154: x_return_status := fnd_api.g_ret_sts_error;
155:
156: WHEN OTHERS THEN
157: x_return_status := fnd_api.g_ret_sts_unexp_error;
158: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
159: THEN
160: fnd_msg_pub.add_exc_msg
161: ( g_pkg_name,

Line 193: x_return_status := FND_API.G_RET_STS_SUCCESS;

189: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
190: BEGIN
191:
192: -- Initialize API return status to success
193: x_return_status := FND_API.G_RET_STS_SUCCESS;
194: /* If the locator has a physical_location_id
195: then use the physical_location_id for further
196: processing.Else we have to use the inventory_location_id
197: for further processing

Line 241: WHEN fnd_api.g_exc_error THEN

237: END IF;
238:
239: EXCEPTION
240:
241: WHEN fnd_api.g_exc_error THEN
242: x_return_status := fnd_api.g_ret_sts_error;
243: fnd_msg_pub.count_and_get
244: ( p_count => x_msg_count,
245: p_data => x_msg_data

Line 242: x_return_status := fnd_api.g_ret_sts_error;

238:
239: EXCEPTION
240:
241: WHEN fnd_api.g_exc_error THEN
242: x_return_status := fnd_api.g_ret_sts_error;
243: fnd_msg_pub.count_and_get
244: ( p_count => x_msg_count,
245: p_data => x_msg_data
246: );

Line 248: WHEN fnd_api.g_exc_unexpected_error THEN

244: ( p_count => x_msg_count,
245: p_data => x_msg_data
246: );
247:
248: WHEN fnd_api.g_exc_unexpected_error THEN
249: x_return_status := fnd_api.g_ret_sts_unexp_error ;
250: fnd_msg_pub.count_and_get
251: ( p_count => x_msg_count,
252: p_data => x_msg_data

Line 249: x_return_status := fnd_api.g_ret_sts_unexp_error ;

245: p_data => x_msg_data
246: );
247:
248: WHEN fnd_api.g_exc_unexpected_error THEN
249: x_return_status := fnd_api.g_ret_sts_unexp_error ;
250: fnd_msg_pub.count_and_get
251: ( p_count => x_msg_count,
252: p_data => x_msg_data
253: );

Line 256: x_return_status := fnd_api.g_ret_sts_error;

252: p_data => x_msg_data
253: );
254:
255: WHEN NO_DATA_FOUND THEN
256: x_return_status := fnd_api.g_ret_sts_error;
257:
258: WHEN OTHERS THEN
259: x_return_status := fnd_api.g_ret_sts_unexp_error;
260: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)

Line 259: x_return_status := fnd_api.g_ret_sts_unexp_error;

255: WHEN NO_DATA_FOUND THEN
256: x_return_status := fnd_api.g_ret_sts_error;
257:
258: WHEN OTHERS THEN
259: x_return_status := fnd_api.g_ret_sts_unexp_error;
260: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
261: THEN
262: fnd_msg_pub.add_exc_msg
263: ( g_pkg_name

Line 297: x_return_status := FND_API.G_RET_STS_SUCCESS;

293: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
294: BEGIN
295:
296: -- Initialize API return status to success
297: x_return_status := FND_API.G_RET_STS_SUCCESS;
298: /* If the locator has a physical_location_id
299: then use the physical_location_id for further
300: processing.Else we have to use the inventory_location_id
301: for further processing

Line 349: WHEN fnd_api.g_exc_error THEN

345: END IF;
346:
347: EXCEPTION
348:
349: WHEN fnd_api.g_exc_error THEN
350: x_return_status := fnd_api.g_ret_sts_error;
351: fnd_msg_pub.count_and_get
352: ( p_count => x_msg_count,
353: p_data => x_msg_data

Line 350: x_return_status := fnd_api.g_ret_sts_error;

346:
347: EXCEPTION
348:
349: WHEN fnd_api.g_exc_error THEN
350: x_return_status := fnd_api.g_ret_sts_error;
351: fnd_msg_pub.count_and_get
352: ( p_count => x_msg_count,
353: p_data => x_msg_data
354: );

Line 356: WHEN fnd_api.g_exc_unexpected_error THEN

352: ( p_count => x_msg_count,
353: p_data => x_msg_data
354: );
355:
356: WHEN fnd_api.g_exc_unexpected_error THEN
357: x_return_status := fnd_api.g_ret_sts_unexp_error ;
358: fnd_msg_pub.count_and_get
359: ( p_count => x_msg_count,
360: p_data => x_msg_data

Line 357: x_return_status := fnd_api.g_ret_sts_unexp_error ;

353: p_data => x_msg_data
354: );
355:
356: WHEN fnd_api.g_exc_unexpected_error THEN
357: x_return_status := fnd_api.g_ret_sts_unexp_error ;
358: fnd_msg_pub.count_and_get
359: ( p_count => x_msg_count,
360: p_data => x_msg_data
361: );

Line 364: x_return_status := fnd_api.g_ret_sts_error;

360: p_data => x_msg_data
361: );
362:
363: WHEN NO_DATA_FOUND THEN
364: x_return_status := fnd_api.g_ret_sts_error;
365:
366: WHEN OTHERS THEN
367: x_return_status := fnd_api.g_ret_sts_unexp_error;
368: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)

Line 367: x_return_status := fnd_api.g_ret_sts_unexp_error;

363: WHEN NO_DATA_FOUND THEN
364: x_return_status := fnd_api.g_ret_sts_error;
365:
366: WHEN OTHERS THEN
367: x_return_status := fnd_api.g_ret_sts_unexp_error;
368: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
369: THEN
370: fnd_msg_pub.add_exc_msg
371: ( g_pkg_name

Line 404: x_return_status := FND_API.G_RET_STS_SUCCESS;

400: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
401: BEGIN
402:
403: -- Initialize API return status to success
404: x_return_status := FND_API.G_RET_STS_SUCCESS;
405: /* If the locator has a physical_location_id
406: then use the physical_location_id for further
407: processing.Else we have to use the inventory_location_id
408: for further processing

Line 458: WHEN fnd_api.g_exc_error THEN

454:
455:
456: EXCEPTION
457:
458: WHEN fnd_api.g_exc_error THEN
459: x_return_status := fnd_api.g_ret_sts_error;
460: fnd_msg_pub.count_and_get
461: ( p_count => x_msg_count,
462: p_data => x_msg_data

Line 459: x_return_status := fnd_api.g_ret_sts_error;

455:
456: EXCEPTION
457:
458: WHEN fnd_api.g_exc_error THEN
459: x_return_status := fnd_api.g_ret_sts_error;
460: fnd_msg_pub.count_and_get
461: ( p_count => x_msg_count,
462: p_data => x_msg_data
463: );

Line 465: WHEN fnd_api.g_exc_unexpected_error THEN

461: ( p_count => x_msg_count,
462: p_data => x_msg_data
463: );
464:
465: WHEN fnd_api.g_exc_unexpected_error THEN
466: x_return_status := fnd_api.g_ret_sts_unexp_error ;
467: fnd_msg_pub.count_and_get
468: ( p_count => x_msg_count,
469: p_data => x_msg_data

Line 466: x_return_status := fnd_api.g_ret_sts_unexp_error ;

462: p_data => x_msg_data
463: );
464:
465: WHEN fnd_api.g_exc_unexpected_error THEN
466: x_return_status := fnd_api.g_ret_sts_unexp_error ;
467: fnd_msg_pub.count_and_get
468: ( p_count => x_msg_count,
469: p_data => x_msg_data
470: );

Line 473: x_return_status := fnd_api.g_ret_sts_error;

469: p_data => x_msg_data
470: );
471:
472: WHEN NO_DATA_FOUND THEN
473: x_return_status := fnd_api.g_ret_sts_error;
474:
475: WHEN OTHERS THEN
476: x_return_status := fnd_api.g_ret_sts_unexp_error;
477: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)

Line 476: x_return_status := fnd_api.g_ret_sts_unexp_error;

472: WHEN NO_DATA_FOUND THEN
473: x_return_status := fnd_api.g_ret_sts_error;
474:
475: WHEN OTHERS THEN
476: x_return_status := fnd_api.g_ret_sts_unexp_error;
477: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
478: THEN
479: fnd_msg_pub.add_exc_msg
480: ( g_pkg_name

Line 563: x_return_status := FND_API.G_RET_STS_SUCCESS;

559: IF (l_debug = 1) THEN
560: mdebug('In update_loc_curr_capacity_nauto');
561: END IF;
562: -- Initialize API return status to success
563: x_return_status := FND_API.G_RET_STS_SUCCESS;
564: /* If the locator has a physical_location_id
565: then use the physical_location_id for further
566: processing.Else we have to use the inventory_location_id
567: for further processing

Line 799: RAISE fnd_api.g_exc_error;

795: -- if p_issue_flag neither Y/N, raise error
796: ELSE
797: fnd_message.set_name('INV', 'INV_FIELD_INVALID');
798: fnd_msg_pub.ADD;
799: RAISE fnd_api.g_exc_error;
800: END IF;
801: -- if not updating weight, then just propagate current_weight to updated_weight.
802: ELSE
803: l_upd_loc_current_weight := l_current_weight;

Line 858: RAISE fnd_api.g_exc_error;

854: END IF;
855: ELSE
856: fnd_message.set_name('WMS', 'Invalid input to p_issue_flag (receipt/issue)');
857: fnd_msg_pub.ADD;
858: RAISE fnd_api.g_exc_error;
859:
860: END IF;
861: ELSE
862: l_upd_loc_current_volume := l_current_cubic_area;

Line 919: RAISE fnd_api.g_exc_error;

915: -- if p_issue_flag neither Y/N, raise error
916: ELSE
917: fnd_message.set_name('WMS', 'Invalid input to p_issue_flag (receipt/issue)');
918: fnd_msg_pub.ADD;
919: RAISE fnd_api.g_exc_error;
920: END IF;
921: ELSE
922: l_upd_loc_current_units := l_current_units;
923: l_upd_loc_available_units := l_available_units;

Line 944: WHEN fnd_api.g_exc_error THEN

940: END IF;
941:
942: EXCEPTION
943:
944: WHEN fnd_api.g_exc_error THEN
945: ROLLBACK;
946: x_return_status := fnd_api.g_ret_sts_error;
947: fnd_msg_pub.count_and_get
948: ( p_count => x_msg_count,

Line 946: x_return_status := fnd_api.g_ret_sts_error;

942: EXCEPTION
943:
944: WHEN fnd_api.g_exc_error THEN
945: ROLLBACK;
946: x_return_status := fnd_api.g_ret_sts_error;
947: fnd_msg_pub.count_and_get
948: ( p_count => x_msg_count,
949: p_data => x_msg_data
950: );

Line 952: WHEN fnd_api.g_exc_unexpected_error THEN

948: ( p_count => x_msg_count,
949: p_data => x_msg_data
950: );
951:
952: WHEN fnd_api.g_exc_unexpected_error THEN
953: ROLLBACK;
954: x_return_status := fnd_api.g_ret_sts_unexp_error ;
955: fnd_msg_pub.count_and_get
956: ( p_count => x_msg_count,

Line 954: x_return_status := fnd_api.g_ret_sts_unexp_error ;

950: );
951:
952: WHEN fnd_api.g_exc_unexpected_error THEN
953: ROLLBACK;
954: x_return_status := fnd_api.g_ret_sts_unexp_error ;
955: fnd_msg_pub.count_and_get
956: ( p_count => x_msg_count,
957: p_data => x_msg_data
958: );

Line 962: x_return_status := fnd_api.g_ret_sts_error;

958: );
959:
960: WHEN NO_DATA_FOUND THEN
961: ROLLBACK;
962: x_return_status := fnd_api.g_ret_sts_error;
963:
964: WHEN OTHERS THEN
965: ROLLBACK;
966: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 966: x_return_status := fnd_api.g_ret_sts_unexp_error;

962: x_return_status := fnd_api.g_ret_sts_error;
963:
964: WHEN OTHERS THEN
965: ROLLBACK;
966: x_return_status := fnd_api.g_ret_sts_unexp_error;
967: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
968: THEN
969: fnd_msg_pub.add_exc_msg
970: ( g_pkg_name

Line 1011: x_return_status := FND_API.G_RET_STS_SUCCESS;

1007: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1008: BEGIN
1009:
1010: -- Initialize API return status to success
1011: x_return_status := FND_API.G_RET_STS_SUCCESS;
1012:
1013: inv_loc_wms_utils.update_loc_curr_capacity_nauto
1014: ( x_return_status => l_return_status,
1015: x_msg_count => x_msg_count,

Line 1025: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

1021: p_transaction_uom_code => p_transaction_uom_code,
1022: p_quantity => p_quantity,
1023: p_issue_flag => p_issue_flag);
1024:
1025: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1026: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
1027: RAISE fnd_api.g_exc_error;
1028: ELSE
1029: RAISE fnd_api.g_exc_unexpected_error;

Line 1026: IF (l_return_status = fnd_api.g_ret_sts_error) THEN

1022: p_quantity => p_quantity,
1023: p_issue_flag => p_issue_flag);
1024:
1025: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1026: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
1027: RAISE fnd_api.g_exc_error;
1028: ELSE
1029: RAISE fnd_api.g_exc_unexpected_error;
1030: END IF;

Line 1027: RAISE fnd_api.g_exc_error;

1023: p_issue_flag => p_issue_flag);
1024:
1025: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1026: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
1027: RAISE fnd_api.g_exc_error;
1028: ELSE
1029: RAISE fnd_api.g_exc_unexpected_error;
1030: END IF;
1031: END IF;

Line 1029: RAISE fnd_api.g_exc_unexpected_error;

1025: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1026: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
1027: RAISE fnd_api.g_exc_error;
1028: ELSE
1029: RAISE fnd_api.g_exc_unexpected_error;
1030: END IF;
1031: END IF;
1032:
1033: -- end of autonomous commit

Line 1037: WHEN fnd_api.g_exc_error THEN

1033: -- end of autonomous commit
1034: COMMIT;
1035: EXCEPTION
1036:
1037: WHEN fnd_api.g_exc_error THEN
1038: ROLLBACK;
1039: x_return_status := fnd_api.g_ret_sts_error;
1040: fnd_msg_pub.count_and_get
1041: ( p_count => x_msg_count,

Line 1039: x_return_status := fnd_api.g_ret_sts_error;

1035: EXCEPTION
1036:
1037: WHEN fnd_api.g_exc_error THEN
1038: ROLLBACK;
1039: x_return_status := fnd_api.g_ret_sts_error;
1040: fnd_msg_pub.count_and_get
1041: ( p_count => x_msg_count,
1042: p_data => x_msg_data
1043: );

Line 1045: WHEN fnd_api.g_exc_unexpected_error THEN

1041: ( p_count => x_msg_count,
1042: p_data => x_msg_data
1043: );
1044:
1045: WHEN fnd_api.g_exc_unexpected_error THEN
1046: ROLLBACK;
1047: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1048: fnd_msg_pub.count_and_get
1049: ( p_count => x_msg_count,

Line 1047: x_return_status := fnd_api.g_ret_sts_unexp_error ;

1043: );
1044:
1045: WHEN fnd_api.g_exc_unexpected_error THEN
1046: ROLLBACK;
1047: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1048: fnd_msg_pub.count_and_get
1049: ( p_count => x_msg_count,
1050: p_data => x_msg_data
1051: );

Line 1055: x_return_status := fnd_api.g_ret_sts_error;

1051: );
1052:
1053: WHEN NO_DATA_FOUND THEN
1054: ROLLBACK;
1055: x_return_status := fnd_api.g_ret_sts_error;
1056:
1057: WHEN OTHERS THEN
1058: ROLLBACK;
1059: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1059: x_return_status := fnd_api.g_ret_sts_unexp_error;

1055: x_return_status := fnd_api.g_ret_sts_error;
1056:
1057: WHEN OTHERS THEN
1058: ROLLBACK;
1059: x_return_status := fnd_api.g_ret_sts_unexp_error;
1060: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
1061: THEN
1062: fnd_msg_pub.add_exc_msg
1063: ( g_pkg_name

Line 1104: x_return_status := FND_API.G_RET_STS_SUCCESS;

1100: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1101: BEGIN
1102:
1103: -- Initialize API return status to success
1104: x_return_status := FND_API.G_RET_STS_SUCCESS;
1105:
1106: inv_loc_wms_utils.update_loc_sugg_capacity_nauto
1107: ( x_return_status => l_return_status,
1108: x_msg_count => x_msg_count,

Line 1118: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

1114: p_transaction_uom_code => p_transaction_uom_code,
1115: p_quantity => p_quantity
1116: );
1117:
1118: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1119: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
1120: RAISE fnd_api.g_exc_error;
1121: ELSE
1122: RAISE fnd_api.g_exc_unexpected_error;

Line 1119: IF (l_return_status = fnd_api.g_ret_sts_error) THEN

1115: p_quantity => p_quantity
1116: );
1117:
1118: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1119: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
1120: RAISE fnd_api.g_exc_error;
1121: ELSE
1122: RAISE fnd_api.g_exc_unexpected_error;
1123: END IF;

Line 1120: RAISE fnd_api.g_exc_error;

1116: );
1117:
1118: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1119: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
1120: RAISE fnd_api.g_exc_error;
1121: ELSE
1122: RAISE fnd_api.g_exc_unexpected_error;
1123: END IF;
1124: END IF;

Line 1122: RAISE fnd_api.g_exc_unexpected_error;

1118: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1119: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
1120: RAISE fnd_api.g_exc_error;
1121: ELSE
1122: RAISE fnd_api.g_exc_unexpected_error;
1123: END IF;
1124: END IF;
1125:
1126: -- end of autonomous commit;

Line 1130: WHEN fnd_api.g_exc_error THEN

1126: -- end of autonomous commit;
1127: COMMIT;
1128: EXCEPTION
1129:
1130: WHEN fnd_api.g_exc_error THEN
1131: ROLLBACK;
1132: x_return_status := fnd_api.g_ret_sts_error;
1133: fnd_msg_pub.count_and_get
1134: ( p_count => x_msg_count,

Line 1132: x_return_status := fnd_api.g_ret_sts_error;

1128: EXCEPTION
1129:
1130: WHEN fnd_api.g_exc_error THEN
1131: ROLLBACK;
1132: x_return_status := fnd_api.g_ret_sts_error;
1133: fnd_msg_pub.count_and_get
1134: ( p_count => x_msg_count,
1135: p_data => x_msg_data
1136: );

Line 1138: WHEN fnd_api.g_exc_unexpected_error THEN

1134: ( p_count => x_msg_count,
1135: p_data => x_msg_data
1136: );
1137:
1138: WHEN fnd_api.g_exc_unexpected_error THEN
1139: ROLLBACK;
1140: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1141: fnd_msg_pub.count_and_get
1142: ( p_count => x_msg_count,

Line 1140: x_return_status := fnd_api.g_ret_sts_unexp_error ;

1136: );
1137:
1138: WHEN fnd_api.g_exc_unexpected_error THEN
1139: ROLLBACK;
1140: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1141: fnd_msg_pub.count_and_get
1142: ( p_count => x_msg_count,
1143: p_data => x_msg_data
1144: );

Line 1148: x_return_status := fnd_api.g_ret_sts_error;

1144: );
1145:
1146: WHEN NO_DATA_FOUND THEN
1147: ROLLBACK;
1148: x_return_status := fnd_api.g_ret_sts_error;
1149:
1150: WHEN OTHERS THEN
1151: ROLLBACK;
1152: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1152: x_return_status := fnd_api.g_ret_sts_unexp_error;

1148: x_return_status := fnd_api.g_ret_sts_error;
1149:
1150: WHEN OTHERS THEN
1151: ROLLBACK;
1152: x_return_status := fnd_api.g_ret_sts_unexp_error;
1153: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
1154: THEN
1155: fnd_msg_pub.add_exc_msg
1156: ( g_pkg_name

Line 1240: x_return_status := FND_API.G_RET_STS_SUCCESS;

1236: IF (l_debug = 1) THEN
1237: mdebug('In update_loc_sugg_capacity_nauto');
1238: END IF;
1239: -- Initialize API return status to success
1240: x_return_status := FND_API.G_RET_STS_SUCCESS;
1241: /* If the locator has a physical_location_id
1242: then use the physical_location_id for further
1243: processing.Else we have to use the inventory_location_id
1244: for further processing

Line 1540: WHEN fnd_api.g_exc_error THEN

1536: END IF;
1537:
1538: EXCEPTION
1539:
1540: WHEN fnd_api.g_exc_error THEN
1541: ROLLBACK;
1542: x_return_status := fnd_api.g_ret_sts_error;
1543: fnd_msg_pub.count_and_get
1544: ( p_count => x_msg_count,

Line 1542: x_return_status := fnd_api.g_ret_sts_error;

1538: EXCEPTION
1539:
1540: WHEN fnd_api.g_exc_error THEN
1541: ROLLBACK;
1542: x_return_status := fnd_api.g_ret_sts_error;
1543: fnd_msg_pub.count_and_get
1544: ( p_count => x_msg_count,
1545: p_data => x_msg_data
1546: );

Line 1548: WHEN fnd_api.g_exc_unexpected_error THEN

1544: ( p_count => x_msg_count,
1545: p_data => x_msg_data
1546: );
1547:
1548: WHEN fnd_api.g_exc_unexpected_error THEN
1549: ROLLBACK;
1550: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1551: fnd_msg_pub.count_and_get
1552: ( p_count => x_msg_count,

Line 1550: x_return_status := fnd_api.g_ret_sts_unexp_error ;

1546: );
1547:
1548: WHEN fnd_api.g_exc_unexpected_error THEN
1549: ROLLBACK;
1550: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1551: fnd_msg_pub.count_and_get
1552: ( p_count => x_msg_count,
1553: p_data => x_msg_data
1554: );

Line 1558: x_return_status := fnd_api.g_ret_sts_error;

1554: );
1555:
1556: WHEN NO_DATA_FOUND THEN
1557: ROLLBACK;
1558: x_return_status := fnd_api.g_ret_sts_error;
1559:
1560: WHEN OTHERS THEN
1561: ROLLBACK;
1562: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1562: x_return_status := fnd_api.g_ret_sts_unexp_error;

1558: x_return_status := fnd_api.g_ret_sts_error;
1559:
1560: WHEN OTHERS THEN
1561: ROLLBACK;
1562: x_return_status := fnd_api.g_ret_sts_unexp_error;
1563: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
1564: THEN
1565: fnd_msg_pub.add_exc_msg
1566: ( g_pkg_name

Line 1605: x_return_status := FND_API.G_RET_STS_SUCCESS;

1601: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1602: BEGIN
1603:
1604: -- Initialize API return status to success
1605: x_return_status := FND_API.G_RET_STS_SUCCESS;
1606:
1607: inv_loc_wms_utils.update_loc_sugg_capacity_nauto
1608: ( x_return_status => l_return_status,
1609: x_msg_count => x_msg_count,

Line 1619: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

1615: p_transaction_uom_code => p_transaction_uom_code,
1616: p_quantity => p_quantity
1617: );
1618:
1619: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1620: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
1621: RAISE fnd_api.g_exc_error;
1622: ELSE
1623: RAISE fnd_api.g_exc_unexpected_error;

Line 1620: IF (l_return_status = fnd_api.g_ret_sts_error) THEN

1616: p_quantity => p_quantity
1617: );
1618:
1619: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1620: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
1621: RAISE fnd_api.g_exc_error;
1622: ELSE
1623: RAISE fnd_api.g_exc_unexpected_error;
1624: END IF;

Line 1621: RAISE fnd_api.g_exc_error;

1617: );
1618:
1619: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1620: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
1621: RAISE fnd_api.g_exc_error;
1622: ELSE
1623: RAISE fnd_api.g_exc_unexpected_error;
1624: END IF;
1625: END IF;

Line 1623: RAISE fnd_api.g_exc_unexpected_error;

1619: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1620: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
1621: RAISE fnd_api.g_exc_error;
1622: ELSE
1623: RAISE fnd_api.g_exc_unexpected_error;
1624: END IF;
1625: END IF;
1626:
1627: -- Update empty_flag, mixed_item_flag. Pass transaction action of receipt

Line 1642: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

1638: , P_TRANSFER_ORGANIZATION => NULL
1639: , P_TRANSFER_LOCATION_ID => NULL
1640: , P_SOURCE => null);
1641:
1642: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1643: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
1644: RAISE fnd_api.g_exc_error;
1645: ELSE
1646: RAISE fnd_api.g_exc_unexpected_error;

Line 1643: IF (l_return_status = fnd_api.g_ret_sts_error) THEN

1639: , P_TRANSFER_LOCATION_ID => NULL
1640: , P_SOURCE => null);
1641:
1642: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1643: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
1644: RAISE fnd_api.g_exc_error;
1645: ELSE
1646: RAISE fnd_api.g_exc_unexpected_error;
1647: END IF;

Line 1644: RAISE fnd_api.g_exc_error;

1640: , P_SOURCE => null);
1641:
1642: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1643: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
1644: RAISE fnd_api.g_exc_error;
1645: ELSE
1646: RAISE fnd_api.g_exc_unexpected_error;
1647: END IF;
1648: END IF;

Line 1646: RAISE fnd_api.g_exc_unexpected_error;

1642: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1643: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
1644: RAISE fnd_api.g_exc_error;
1645: ELSE
1646: RAISE fnd_api.g_exc_unexpected_error;
1647: END IF;
1648: END IF;
1649:
1650: -- end of autonomous commit;

Line 1654: WHEN fnd_api.g_exc_error THEN

1650: -- end of autonomous commit;
1651: COMMIT;
1652: EXCEPTION
1653:
1654: WHEN fnd_api.g_exc_error THEN
1655: ROLLBACK;
1656: x_return_status := fnd_api.g_ret_sts_error;
1657: fnd_msg_pub.count_and_get
1658: ( p_count => x_msg_count,

Line 1656: x_return_status := fnd_api.g_ret_sts_error;

1652: EXCEPTION
1653:
1654: WHEN fnd_api.g_exc_error THEN
1655: ROLLBACK;
1656: x_return_status := fnd_api.g_ret_sts_error;
1657: fnd_msg_pub.count_and_get
1658: ( p_count => x_msg_count,
1659: p_data => x_msg_data
1660: );

Line 1662: WHEN fnd_api.g_exc_unexpected_error THEN

1658: ( p_count => x_msg_count,
1659: p_data => x_msg_data
1660: );
1661:
1662: WHEN fnd_api.g_exc_unexpected_error THEN
1663: ROLLBACK;
1664: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1665: fnd_msg_pub.count_and_get
1666: ( p_count => x_msg_count,

Line 1664: x_return_status := fnd_api.g_ret_sts_unexp_error ;

1660: );
1661:
1662: WHEN fnd_api.g_exc_unexpected_error THEN
1663: ROLLBACK;
1664: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1665: fnd_msg_pub.count_and_get
1666: ( p_count => x_msg_count,
1667: p_data => x_msg_data
1668: );

Line 1672: x_return_status := fnd_api.g_ret_sts_error;

1668: );
1669:
1670: WHEN NO_DATA_FOUND THEN
1671: ROLLBACK;
1672: x_return_status := fnd_api.g_ret_sts_error;
1673:
1674: WHEN OTHERS THEN
1675: ROLLBACK;
1676: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1676: x_return_status := fnd_api.g_ret_sts_unexp_error;

1672: x_return_status := fnd_api.g_ret_sts_error;
1673:
1674: WHEN OTHERS THEN
1675: ROLLBACK;
1676: x_return_status := fnd_api.g_ret_sts_unexp_error;
1677: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
1678: THEN
1679: fnd_msg_pub.add_exc_msg
1680: ( g_pkg_name

Line 1769: x_return_status := FND_API.G_RET_STS_SUCCESS;

1765:
1766: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1767: BEGIN
1768: -- Initialize API return status to success
1769: x_return_status := FND_API.G_RET_STS_SUCCESS;
1770:
1771: SAVEPOINT revert_loc_suggested_cap_sp;--BUG 4890372
1772:
1773: IF (l_debug=1) THEN

Line 1843: RAISE fnd_api.g_exc_unexpected_error;

1839: mdebug('locking locator - Attempt: ' || 10001-l_loc_counter || ' in revert_loc_suggested_capacity');
1840: END IF;
1841: END IF;
1842: WHEN OTHERS THEN
1843: RAISE fnd_api.g_exc_unexpected_error;
1844: END;
1845: END LOOP;
1846:
1847:

Line 2114: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

2110: , P_TRANSFER_ORGANIZATION => NULL
2111: , P_TRANSFER_LOCATION_ID => NULL
2112: , P_SOURCE => null);
2113:
2114: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
2115: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
2116: RAISE fnd_api.g_exc_error;
2117: ELSE
2118: RAISE fnd_api.g_exc_unexpected_error;

Line 2115: IF (l_return_status = fnd_api.g_ret_sts_error) THEN

2111: , P_TRANSFER_LOCATION_ID => NULL
2112: , P_SOURCE => null);
2113:
2114: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
2115: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
2116: RAISE fnd_api.g_exc_error;
2117: ELSE
2118: RAISE fnd_api.g_exc_unexpected_error;
2119: END IF;

Line 2116: RAISE fnd_api.g_exc_error;

2112: , P_SOURCE => null);
2113:
2114: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
2115: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
2116: RAISE fnd_api.g_exc_error;
2117: ELSE
2118: RAISE fnd_api.g_exc_unexpected_error;
2119: END IF;
2120: END IF;

Line 2118: RAISE fnd_api.g_exc_unexpected_error;

2114: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
2115: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
2116: RAISE fnd_api.g_exc_error;
2117: ELSE
2118: RAISE fnd_api.g_exc_unexpected_error;
2119: END IF;
2120: END IF;
2121:
2122:

Line 2125: WHEN fnd_api.g_exc_error THEN

2121:
2122:
2123: EXCEPTION
2124:
2125: WHEN fnd_api.g_exc_error THEN
2126: ROLLBACK TO revert_loc_suggested_cap_sp;--BUG 4890372
2127: x_return_status := fnd_api.g_ret_sts_error;
2128: fnd_msg_pub.count_and_get
2129: ( p_count => x_msg_count,

Line 2127: x_return_status := fnd_api.g_ret_sts_error;

2123: EXCEPTION
2124:
2125: WHEN fnd_api.g_exc_error THEN
2126: ROLLBACK TO revert_loc_suggested_cap_sp;--BUG 4890372
2127: x_return_status := fnd_api.g_ret_sts_error;
2128: fnd_msg_pub.count_and_get
2129: ( p_count => x_msg_count,
2130: p_data => x_msg_data
2131: );

Line 2133: WHEN fnd_api.g_exc_unexpected_error THEN

2129: ( p_count => x_msg_count,
2130: p_data => x_msg_data
2131: );
2132:
2133: WHEN fnd_api.g_exc_unexpected_error THEN
2134: ROLLBACK TO revert_loc_suggested_cap_sp;--BUG 4890372
2135: x_return_status := fnd_api.g_ret_sts_unexp_error ;
2136: fnd_msg_pub.count_and_get
2137: ( p_count => x_msg_count,

Line 2135: x_return_status := fnd_api.g_ret_sts_unexp_error ;

2131: );
2132:
2133: WHEN fnd_api.g_exc_unexpected_error THEN
2134: ROLLBACK TO revert_loc_suggested_cap_sp;--BUG 4890372
2135: x_return_status := fnd_api.g_ret_sts_unexp_error ;
2136: fnd_msg_pub.count_and_get
2137: ( p_count => x_msg_count,
2138: p_data => x_msg_data
2139: );

Line 2143: x_return_status := fnd_api.g_ret_sts_error;

2139: );
2140:
2141: WHEN NO_DATA_FOUND THEN
2142: ROLLBACK TO revert_loc_suggested_cap_sp;--BUG 4890372
2143: x_return_status := fnd_api.g_ret_sts_error;
2144:
2145: WHEN resource_busy_detected THEN
2146: ROLLBACK TO revert_loc_suggested_cap_sp;--BUG 4890372
2147: x_return_status := fnd_api.g_ret_sts_error;

Line 2147: x_return_status := fnd_api.g_ret_sts_error;

2143: x_return_status := fnd_api.g_ret_sts_error;
2144:
2145: WHEN resource_busy_detected THEN
2146: ROLLBACK TO revert_loc_suggested_cap_sp;--BUG 4890372
2147: x_return_status := fnd_api.g_ret_sts_error;
2148:
2149: WHEN OTHERS THEN
2150: ROLLBACK TO revert_loc_suggested_cap_sp;--BUG 4890372
2151: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2151: x_return_status := fnd_api.g_ret_sts_unexp_error;

2147: x_return_status := fnd_api.g_ret_sts_error;
2148:
2149: WHEN OTHERS THEN
2150: ROLLBACK TO revert_loc_suggested_cap_sp;--BUG 4890372
2151: x_return_status := fnd_api.g_ret_sts_unexp_error;
2152: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
2153: THEN
2154: fnd_msg_pub.add_exc_msg
2155: ( g_pkg_name

Line 2280: RAISE fnd_api.g_exc_error;

2276: to_name => null) ;
2277: end if;
2278:
2279: IF l_gross_weight = -99999 THEN
2280: RAISE fnd_api.g_exc_error;
2281: END IF;
2282: end if;
2283:
2284: -- Compute content Volume

Line 2303: RAISE fnd_api.g_exc_error;

2299: to_name => null) ;
2300: end if;
2301:
2302: IF l_content_volume = -99999 THEN
2303: RAISE fnd_api.g_exc_error;
2304: END IF;
2305: end if;
2306:
2307: -- Compute container Weight

Line 2326: RAISE fnd_api.g_exc_error;

2322: to_name => null) ;
2323: end if;
2324:
2325: IF l_lpn_weight = -99999 THEN
2326: RAISE fnd_api.g_exc_error;
2327: END IF;
2328: end if;
2329:
2330: -- Compute container Volume

Line 2349: RAISE fnd_api.g_exc_error;

2345: to_name => null) ;
2346: end if;
2347:
2348: IF l_lpn_volume = -99999 THEN
2349: RAISE fnd_api.g_exc_error;
2350: END IF;
2351: end if;
2352: x_container_item_wt := l_lpn_weight;
2353: x_container_item_vol := l_lpn_volume;

Line 2360: WHEN fnd_api.g_exc_error THEN

2356: mdebug(l_prog_name||'container wt :'||x_container_item_wt);
2357: mdebug(l_prog_name||'container vol :'||x_container_item_vol);
2358: EXCEPTION
2359:
2360: WHEN fnd_api.g_exc_error THEN
2361: x_return_status := fnd_api.g_ret_sts_error;
2362: fnd_msg_pub.count_and_get
2363: ( p_count => x_msg_count,
2364: p_data => x_msg_data

Line 2361: x_return_status := fnd_api.g_ret_sts_error;

2357: mdebug(l_prog_name||'container vol :'||x_container_item_vol);
2358: EXCEPTION
2359:
2360: WHEN fnd_api.g_exc_error THEN
2361: x_return_status := fnd_api.g_ret_sts_error;
2362: fnd_msg_pub.count_and_get
2363: ( p_count => x_msg_count,
2364: p_data => x_msg_data
2365: );

Line 2367: WHEN fnd_api.g_exc_unexpected_error THEN

2363: ( p_count => x_msg_count,
2364: p_data => x_msg_data
2365: );
2366:
2367: WHEN fnd_api.g_exc_unexpected_error THEN
2368: x_return_status := fnd_api.g_ret_sts_unexp_error ;
2369: fnd_msg_pub.count_and_get
2370: ( p_count => x_msg_count,
2371: p_data => x_msg_data

Line 2368: x_return_status := fnd_api.g_ret_sts_unexp_error ;

2364: p_data => x_msg_data
2365: );
2366:
2367: WHEN fnd_api.g_exc_unexpected_error THEN
2368: x_return_status := fnd_api.g_ret_sts_unexp_error ;
2369: fnd_msg_pub.count_and_get
2370: ( p_count => x_msg_count,
2371: p_data => x_msg_data
2372: );

Line 2375: x_return_status := fnd_api.g_ret_sts_error;

2371: p_data => x_msg_data
2372: );
2373:
2374: WHEN NO_DATA_FOUND THEN
2375: x_return_status := fnd_api.g_ret_sts_error;
2376:
2377: WHEN OTHERS THEN
2378: x_return_status := fnd_api.g_ret_sts_unexp_error;
2379: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)

Line 2378: x_return_status := fnd_api.g_ret_sts_unexp_error;

2374: WHEN NO_DATA_FOUND THEN
2375: x_return_status := fnd_api.g_ret_sts_error;
2376:
2377: WHEN OTHERS THEN
2378: x_return_status := fnd_api.g_ret_sts_unexp_error;
2379: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
2380: THEN
2381: fnd_msg_pub.add_exc_msg
2382: ( g_pkg_name,

Line 2629: x_return_status := FND_API.G_RET_STS_SUCCESS;

2625:
2626: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2627: BEGIN
2628: -- Initialize API return status to success
2629: x_return_status := FND_API.G_RET_STS_SUCCESS;
2630: SAVEPOINT locators_capacity_cleanup;
2631:
2632: IF (l_debug = 1) THEN
2633: mdebug(l_prog_name||'Start Locator_Capacity_Clean_Up');

Line 3375: WHEN fnd_api.g_exc_error THEN

3371: INV_TRX_UTIL_PUB.TRACE('End ','Locator_Capacity_Clean_Up',9);
3372: END IF;
3373:
3374: EXCEPTION
3375: WHEN fnd_api.g_exc_error THEN
3376: mdebug('Error:-'||SQLERRM);
3377: ROLLBACK TO locators_capacity_cleanup ;
3378: x_return_status := fnd_api.g_ret_sts_error;
3379: fnd_msg_pub.count_and_get

Line 3378: x_return_status := fnd_api.g_ret_sts_error;

3374: EXCEPTION
3375: WHEN fnd_api.g_exc_error THEN
3376: mdebug('Error:-'||SQLERRM);
3377: ROLLBACK TO locators_capacity_cleanup ;
3378: x_return_status := fnd_api.g_ret_sts_error;
3379: fnd_msg_pub.count_and_get
3380: ( p_count => x_msg_count,
3381: p_data => x_msg_data
3382: );

Line 3384: WHEN fnd_api.g_exc_unexpected_error THEN

3380: ( p_count => x_msg_count,
3381: p_data => x_msg_data
3382: );
3383:
3384: WHEN fnd_api.g_exc_unexpected_error THEN
3385: mdebug('Error:-'||SQLERRM);
3386: ROLLBACK TO locators_capacity_cleanup;
3387: x_return_status := fnd_api.g_ret_sts_unexp_error ;
3388: fnd_msg_pub.count_and_get

Line 3387: x_return_status := fnd_api.g_ret_sts_unexp_error ;

3383:
3384: WHEN fnd_api.g_exc_unexpected_error THEN
3385: mdebug('Error:-'||SQLERRM);
3386: ROLLBACK TO locators_capacity_cleanup;
3387: x_return_status := fnd_api.g_ret_sts_unexp_error ;
3388: fnd_msg_pub.count_and_get
3389: ( p_count => x_msg_count,
3390: p_data => x_msg_data
3391: );

Line 3396: x_return_status := fnd_api.g_ret_sts_unexp_error;

3392:
3393: WHEN OTHERS THEN
3394: mdebug('Error:-'||SQLERRM);
3395: ROLLBACK TO locators_capacity_cleanup;
3396: x_return_status := fnd_api.g_ret_sts_unexp_error;
3397: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
3398: THEN
3399: fnd_msg_pub.add_exc_msg
3400: ( 'inv_loc_wms_utils'

Line 3430: RAISE fnd_api.g_exc_error;

3426:
3427: IF (p_organization_id is null) THEN
3428: fnd_message.set_name('INV', 'INV_ORG_REQUIRED');
3429: fnd_msg_pub.add;
3430: RAISE fnd_api.g_exc_error;
3431: END IF;
3432:
3433: IF nvl(p_mixed_items_flag,2) = 1 then
3434: l_mixed_items_flag :='Y';

Line 3448: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

3444: , p_organization_id => p_organization_id
3445: , p_mixed_flag => l_mixed_items_flag
3446: , p_subinventory => p_subinventory);
3447:
3448: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
3449: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
3450: IF (l_debug = 1) THEN
3451: INV_TRX_UTIL_PUB.TRACE('Locator capacity calc prog completed with Errors ', 'launch Upgrade',9);
3452: END IF;

Line 3449: IF (l_return_status = fnd_api.g_ret_sts_error) THEN

3445: , p_mixed_flag => l_mixed_items_flag
3446: , p_subinventory => p_subinventory);
3447:
3448: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
3449: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
3450: IF (l_debug = 1) THEN
3451: INV_TRX_UTIL_PUB.TRACE('Locator capacity calc prog completed with Errors ', 'launch Upgrade',9);
3452: END IF;
3453: RAISE fnd_api.g_exc_error;

Line 3453: RAISE fnd_api.g_exc_error;

3449: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
3450: IF (l_debug = 1) THEN
3451: INV_TRX_UTIL_PUB.TRACE('Locator capacity calc prog completed with Errors ', 'launch Upgrade',9);
3452: END IF;
3453: RAISE fnd_api.g_exc_error;
3454: ELSE
3455: IF (l_debug = 1) THEN
3456: INV_TRX_UTIL_PUB.TRACE('Locator capacity calc prog completed with Unexp errors ', 'launch Upgrade',9);
3457: END IF;

Line 3458: RAISE fnd_api.g_exc_unexpected_error;

3454: ELSE
3455: IF (l_debug = 1) THEN
3456: INV_TRX_UTIL_PUB.TRACE('Locator capacity calc prog completed with Unexp errors ', 'launch Upgrade',9);
3457: END IF;
3458: RAISE fnd_api.g_exc_unexpected_error;
3459: END IF;
3460: ELSE
3461: IF (l_debug = 1) THEN
3462: INV_TRX_UTIL_PUB.TRACE('Locator capacity calc prog completed successfully ', 'launch Upgrade',9);

Line 3471: WHEN fnd_api.g_exc_error THEN

3467: x_errorbuf := NULL;
3468: END IF;
3469:
3470: EXCEPTION
3471: WHEN fnd_api.g_exc_error THEN
3472:
3473: print_message();
3474: l_conc_status := fnd_concurrent.set_completion_status('ERROR','ERROR');
3475: x_retcode := RETCODE_ERROR;

Line 3476: x_errorbuf := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

3472:
3473: print_message();
3474: l_conc_status := fnd_concurrent.set_completion_status('ERROR','ERROR');
3475: x_retcode := RETCODE_ERROR;
3476: x_errorbuf := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
3477:
3478: WHEN fnd_api.g_exc_unexpected_error THEN
3479:
3480: print_message();

Line 3478: WHEN fnd_api.g_exc_unexpected_error THEN

3474: l_conc_status := fnd_concurrent.set_completion_status('ERROR','ERROR');
3475: x_retcode := RETCODE_ERROR;
3476: x_errorbuf := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
3477:
3478: WHEN fnd_api.g_exc_unexpected_error THEN
3479:
3480: print_message();
3481: l_conc_status := fnd_concurrent.set_completion_status('ERROR','ERROR');
3482: x_retcode := RETCODE_ERROR;

Line 3483: x_errorbuf := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

3479:
3480: print_message();
3481: l_conc_status := fnd_concurrent.set_completion_status('ERROR','ERROR');
3482: x_retcode := RETCODE_ERROR;
3483: x_errorbuf := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
3484:
3485: WHEN OTHERS THEN
3486:
3487: print_message();

Line 3490: x_errorbuf := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

3486:
3487: print_message();
3488: l_conc_status := fnd_concurrent.set_completion_status('ERROR','ERROR');
3489: x_retcode := RETCODE_ERROR;
3490: x_errorbuf := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
3491:
3492: END launch_upgrade;
3493:
3494: PROCEDURE print_message(dummy IN VARCHAR2 )IS

Line 3734: x_return_status := FND_API.G_RET_STS_SUCCESS;

3730: IS
3731: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3732: l_proc_name VARCHAR2(50) := 'FETCH_ITEM_ATTRIBUTES: ';
3733: BEGIN
3734: x_return_status := FND_API.G_RET_STS_SUCCESS;
3735: item_attributes(
3736: x_return_status => x_return_status
3737: , x_msg_data => x_msg_data
3738: , x_msg_count => x_msg_count

Line 3754: IF x_return_status =fnd_api.g_ret_sts_error THEN

3750: , p_quantity => p_quantity
3751: , p_organization_id => p_organization_id
3752: , p_container_item => p_container_item
3753: );
3754: IF x_return_status =fnd_api.g_ret_sts_error THEN
3755: RAISE fnd_api.g_exc_error;
3756: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3757: RAISE fnd_api.g_exc_unexpected_error;
3758: END IF;

Line 3755: RAISE fnd_api.g_exc_error;

3751: , p_organization_id => p_organization_id
3752: , p_container_item => p_container_item
3753: );
3754: IF x_return_status =fnd_api.g_ret_sts_error THEN
3755: RAISE fnd_api.g_exc_error;
3756: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3757: RAISE fnd_api.g_exc_unexpected_error;
3758: END IF;
3759:

Line 3756: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

3752: , p_container_item => p_container_item
3753: );
3754: IF x_return_status =fnd_api.g_ret_sts_error THEN
3755: RAISE fnd_api.g_exc_error;
3756: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3757: RAISE fnd_api.g_exc_unexpected_error;
3758: END IF;
3759:
3760: IF (l_debug = 1) THEN

Line 3757: RAISE fnd_api.g_exc_unexpected_error;

3753: );
3754: IF x_return_status =fnd_api.g_ret_sts_error THEN
3755: RAISE fnd_api.g_exc_error;
3756: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3757: RAISE fnd_api.g_exc_unexpected_error;
3758: END IF;
3759:
3760: IF (l_debug = 1) THEN
3761: mdebug(l_proc_name||'The item weight UOM code : '||x_item_attr.l_item_weight_uom_code);

Line 3794: x_return_status := FND_API.G_RET_STS_SUCCESS;

3790: l_lpn_exists_in_locator VARCHAR2(1);
3791: l_proc_name VARCHAR2(50) := 'FETCH_LPN_ATTR: ';
3792: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3793: BEGIN
3794: x_return_status := FND_API.G_RET_STS_SUCCESS;
3795: IF (l_debug = 1) THEN
3796: mdebug(l_proc_name||'Fetching of LPN attibutes ');
3797: END IF;
3798: INV_LOC_WMS_UTILS.lpn_attributes(

Line 3813: IF x_return_status =fnd_api.g_ret_sts_error THEN

3809: , p_lpn_id => p_lpn_id
3810: , p_org_id => p_org_id
3811: );
3812:
3813: IF x_return_status =fnd_api.g_ret_sts_error THEN
3814: RAISE fnd_api.g_exc_error;
3815: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3816: RAISE fnd_api.g_exc_unexpected_error;
3817: END IF;

Line 3814: RAISE fnd_api.g_exc_error;

3810: , p_org_id => p_org_id
3811: );
3812:
3813: IF x_return_status =fnd_api.g_ret_sts_error THEN
3814: RAISE fnd_api.g_exc_error;
3815: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3816: RAISE fnd_api.g_exc_unexpected_error;
3817: END IF;
3818:

Line 3815: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

3811: );
3812:
3813: IF x_return_status =fnd_api.g_ret_sts_error THEN
3814: RAISE fnd_api.g_exc_error;
3815: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3816: RAISE fnd_api.g_exc_unexpected_error;
3817: END IF;
3818:
3819: /*--------------------------------------------------------------------------------------

Line 3816: RAISE fnd_api.g_exc_unexpected_error;

3812:
3813: IF x_return_status =fnd_api.g_ret_sts_error THEN
3814: RAISE fnd_api.g_exc_error;
3815: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3816: RAISE fnd_api.g_exc_unexpected_error;
3817: END IF;
3818:
3819: /*--------------------------------------------------------------------------------------
3820: Convert the Volume of the LPN into the Locator's Volume UOM code.

Line 3844: RAISE fnd_api.g_exc_error;

3840: /*--------------------------------------------------------------------------------------
3841: Conversion is not defined. Raise form trigger failure.
3842: --------------------------------------------------------------------------------------*/
3843: IF l_lpn_content_volume = -99999 THEN
3844: RAISE fnd_api.g_exc_error;
3845: END IF;
3846:
3847: IF (l_debug = 1) THEN
3848: mdebug(l_proc_name||'l_lpn_content_volume is '||to_char(l_lpn_content_volume));

Line 3880: RAISE fnd_api.g_exc_error;

3876: /*--------------------------------------------------------------------------------------
3877: Conversion is not defined. Raise form trigger failure.
3878: --------------------------------------------------------------------------------------*/
3879: IF l_lpn_container_item_vol = -99999 THEN
3880: RAISE fnd_api.g_exc_error;
3881: END IF;
3882:
3883: /*--------------------------------------------------------------------------------------
3884: Convert the Gross Weight of the LPN into the Locator's Volume UOM code.

Line 3908: RAISE fnd_api.g_exc_error;

3904: /*--------------------------------------------------------------------------------------
3905: Conversion is not defined. Raise form trigger failure.
3906: --------------------------------------------------------------------------------------*/
3907: IF l_lpn_gross_weight = -99999 THEN
3908: RAISE fnd_api.g_exc_error;
3909: END IF;
3910:
3911: /*--------------------------------------------------------------------------------------
3912: Convert the Container Item Weight of the LPN into the Locator's Volume UOM code.

Line 3936: RAISE fnd_api.g_exc_error;

3932: /*--------------------------------------------------------------------------------------
3933: Conversion is not defined. Raise form trigger failure.
3934: --------------------------------------------------------------------------------------*/
3935: IF l_lpn_container_item_weight = -99999 THEN
3936: RAISE fnd_api.g_exc_error;
3937: END IF;
3938:
3939: IF (l_debug = 1) THEN
3940: mdebug(l_proc_name||'End of Content LPN attibutes ');

Line 3975: x_return_status := FND_API.G_RET_STS_SUCCESS;

3971: l_trn_lpn_exists_in_locator VARCHAR2(1);
3972: l_proc_name VARCHAR2(50) := 'FETCH_TRANSFER_LPN_ATTR: ';
3973: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3974: BEGIN
3975: x_return_status := FND_API.G_RET_STS_SUCCESS;
3976: IF (l_debug = 1) THEN
3977: mdebug(l_proc_name||'Fetching of Transfer LPN attibutes ');
3978: END IF;
3979: INV_LOC_WMS_UTILS.lpn_attributes(

Line 3994: IF x_return_status =fnd_api.g_ret_sts_error THEN

3990: , p_lpn_id => p_lpn_id
3991: , p_org_id => p_org_id
3992: );
3993:
3994: IF x_return_status =fnd_api.g_ret_sts_error THEN
3995: RAISE fnd_api.g_exc_error;
3996: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3997: RAISE fnd_api.g_exc_unexpected_error;
3998: END IF;

Line 3995: RAISE fnd_api.g_exc_error;

3991: , p_org_id => p_org_id
3992: );
3993:
3994: IF x_return_status =fnd_api.g_ret_sts_error THEN
3995: RAISE fnd_api.g_exc_error;
3996: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3997: RAISE fnd_api.g_exc_unexpected_error;
3998: END IF;
3999:

Line 3996: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

3992: );
3993:
3994: IF x_return_status =fnd_api.g_ret_sts_error THEN
3995: RAISE fnd_api.g_exc_error;
3996: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3997: RAISE fnd_api.g_exc_unexpected_error;
3998: END IF;
3999:
4000: /*--------------------------------------------------------------------------------------

Line 3997: RAISE fnd_api.g_exc_unexpected_error;

3993:
3994: IF x_return_status =fnd_api.g_ret_sts_error THEN
3995: RAISE fnd_api.g_exc_error;
3996: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3997: RAISE fnd_api.g_exc_unexpected_error;
3998: END IF;
3999:
4000: /*--------------------------------------------------------------------------------------
4001: Convert the content Volume of Transfer LPN into the Locator's Volume UOM code.

Line 4025: RAISE fnd_api.g_exc_error;

4021: /*--------------------------------------------------------------------------------------
4022: Conversion is not defined. Raise form trigger failure.
4023: --------------------------------------------------------------------------------------*/
4024: IF l_trn_content_volume = -99999 THEN
4025: RAISE fnd_api.g_exc_error;
4026: END IF;
4027:
4028: IF (l_debug = 1) THEN
4029: mdebug(l_proc_name||'l_trn_content_volume is: '||to_char(l_trn_content_volume));

Line 4057: RAISE fnd_api.g_exc_error;

4053: /*--------------------------------------------------------------------------------------
4054: Conversion is not defined. Raise form trigger failure.
4055: --------------------------------------------------------------------------------------*/
4056: IF l_trn_gross_weight = -99999 THEN
4057: RAISE fnd_api.g_exc_error;
4058: END IF;
4059:
4060: IF (l_debug = 1) THEN
4061: mdebug(l_proc_name||'l_trn_gross_weight is: '||to_char(l_trn_gross_weight));

Line 4089: RAISE fnd_api.g_exc_error;

4085: /*--------------------------------------------------------------------------------------
4086: Conversion is not defined. Raise form trigger failure.
4087: --------------------------------------------------------------------------------------*/
4088: IF l_trn_container_item_weight = -99999 THEN
4089: RAISE fnd_api.g_exc_error;
4090: END IF;
4091:
4092: IF (l_debug = 1) THEN
4093: mdebug(l_proc_name||'l_trn_container_item_weight is: '||to_char(l_trn_container_item_weight));

Line 4121: RAISE fnd_api.g_exc_error;

4117: /*--------------------------------------------------------------------------------------
4118: Conversion is not defined. Raise form trigger failure.
4119: --------------------------------------------------------------------------------------*/
4120: IF l_trn_container_item_vol = -99999 THEN
4121: RAISE fnd_api.g_exc_error;
4122: END IF;
4123:
4124: IF (l_debug = 1) THEN
4125: mdebug(l_proc_name||'l_trn_container_item_vol is: '||to_char(l_trn_container_item_vol));

Line 4160: x_return_status := FND_API.G_RET_STS_SUCCESS;

4156: l_quantity NUMBER := 0;
4157: l_proc_name VARCHAR2(50) := 'FETCH_CONTENT_LPN_ATTR: ';
4158: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
4159: BEGIN
4160: x_return_status := FND_API.G_RET_STS_SUCCESS;
4161: IF (l_debug = 1) THEN
4162: mdebug(l_proc_name||'Fetching attributes of the Content lpn: '||to_char(p_lpn_id));
4163: END IF;
4164: INV_LOC_WMS_UTILS.lpn_attributes(

Line 4208: RAISE fnd_api.g_exc_error;

4204: /*--------------------------------------------------------------------------------------
4205: Conversion is not defined. Raise form trigger failure.
4206: --------------------------------------------------------------------------------------*/
4207: IF l_cnt_content_volume = -99999 THEN
4208: RAISE fnd_api.g_exc_error;
4209: END IF;
4210:
4211: /*--------------------------------------------------------------------------------------
4212: Convert the container Volume into the Locator's Volume UOM code.

Line 4240: RAISE fnd_api.g_exc_error;

4236: /*--------------------------------------------------------------------------------------
4237: Conversion is not defined. Raise form trigger failure.
4238: --------------------------------------------------------------------------------------*/
4239: IF l_cnt_container_item_vol = -99999 THEN
4240: RAISE fnd_api.g_exc_error;
4241: END IF;
4242:
4243: /*--------------------------------------------------------------------------------------
4244: Convert the Gross Weight of the LPN into the Locator's Volume UOM code.

Line 4268: RAISE fnd_api.g_exc_error;

4264: /*--------------------------------------------------------------------------------------
4265: Conversion is not defined. Raise form trigger failure.
4266: --------------------------------------------------------------------------------------*/
4267: IF l_cnt_gross_weight = -99999 THEN
4268: RAISE fnd_api.g_exc_error;
4269: END IF;
4270:
4271: /*--------------------------------------------------------------------------------------
4272: Convert the Container Item Weight of the LPN into the Locator's Volume UOM code.

Line 4296: RAISE fnd_api.g_exc_error;

4292: /*--------------------------------------------------------------------------------------
4293: Conversion is not defined. Raise form trigger failure.
4294: --------------------------------------------------------------------------------------*/
4295: IF l_cnt_container_item_weight = -99999 THEN
4296: RAISE fnd_api.g_exc_error;
4297: END IF;
4298:
4299: IF (l_debug = 1) THEN
4300: mdebug(l_proc_name||'End of Content LPN attibutes ');

Line 4341: x_return_status := FND_API.G_RET_STS_SUCCESS;

4337: l_locator_current_units NUMBER := 0;
4338: l_locator_available_units NUMBER;
4339: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
4340: BEGIN
4341: x_return_status := FND_API.G_RET_STS_SUCCESS;
4342:
4343: IF (l_debug = 1) THEN
4344: mdebug(l_proc_name||'transaction Type is issue ');
4345: END IF;

Line 4377: IF x_return_status =fnd_api.g_ret_sts_error THEN

4373: , p_content_lpn_id => p_content_lpn_id
4374: , p_lpn_id => null
4375: , p_trn_lpn_exists_in_loc => null
4376: );
4377: IF x_return_status =fnd_api.g_ret_sts_error THEN
4378: RAISE fnd_api.g_exc_error;
4379: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4380: RAISE fnd_api.g_exc_unexpected_error;
4381: END IF;

Line 4378: RAISE fnd_api.g_exc_error;

4374: , p_lpn_id => null
4375: , p_trn_lpn_exists_in_loc => null
4376: );
4377: IF x_return_status =fnd_api.g_ret_sts_error THEN
4378: RAISE fnd_api.g_exc_error;
4379: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4380: RAISE fnd_api.g_exc_unexpected_error;
4381: END IF;
4382:

Line 4379: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

4375: , p_trn_lpn_exists_in_loc => null
4376: );
4377: IF x_return_status =fnd_api.g_ret_sts_error THEN
4378: RAISE fnd_api.g_exc_error;
4379: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4380: RAISE fnd_api.g_exc_unexpected_error;
4381: END IF;
4382:
4383: l_locator_current_units := p_loc_attr.l_locator_current_units - p_quantity;

Line 4380: RAISE fnd_api.g_exc_unexpected_error;

4376: );
4377: IF x_return_status =fnd_api.g_ret_sts_error THEN
4378: RAISE fnd_api.g_exc_error;
4379: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4380: RAISE fnd_api.g_exc_unexpected_error;
4381: END IF;
4382:
4383: l_locator_current_units := p_loc_attr.l_locator_current_units - p_quantity;
4384:

Line 4452: x_return_status := FND_API.G_RET_STS_SUCCESS;

4448: l_locator_current_units NUMBER := 0;
4449: l_locator_available_units NUMBER;
4450: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
4451: BEGIN
4452: x_return_status := FND_API.G_RET_STS_SUCCESS;
4453:
4454: IF (l_debug = 1) THEN
4455: mdebug(l_proc_name||'transaction Type is receipt ');
4456: END IF;

Line 4591: x_return_status := FND_API.G_RET_STS_SUCCESS;

4587:
4588: l_proc_name VARCHAR2(50) := 'UPD_LPN_LOC_CPTY_FOR_XFR:';
4589: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
4590: BEGIN
4591: x_return_status := FND_API.G_RET_STS_SUCCESS;
4592:
4593: /*--------------------------------------------------------------------------------------------
4594: Fetch the actual Inventory Location ID for the source Locator.
4595: --------------------------------------------------------------------------------------------*/

Line 4671: IF x_return_status =fnd_api.g_ret_sts_error THEN

4667: , p_quantity => p_quantity
4668: , p_organization_id => l_old_organization_id
4669: , p_container_item => null
4670: );
4671: IF x_return_status =fnd_api.g_ret_sts_error THEN
4672: RAISE fnd_api.g_exc_error;
4673: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4674: RAISE fnd_api.g_exc_unexpected_error;
4675: END IF;

Line 4672: RAISE fnd_api.g_exc_error;

4668: , p_organization_id => l_old_organization_id
4669: , p_container_item => null
4670: );
4671: IF x_return_status =fnd_api.g_ret_sts_error THEN
4672: RAISE fnd_api.g_exc_error;
4673: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4674: RAISE fnd_api.g_exc_unexpected_error;
4675: END IF;
4676:

Line 4673: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

4669: , p_container_item => null
4670: );
4671: IF x_return_status =fnd_api.g_ret_sts_error THEN
4672: RAISE fnd_api.g_exc_error;
4673: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4674: RAISE fnd_api.g_exc_unexpected_error;
4675: END IF;
4676:
4677: IF (l_debug = 1) THEN

Line 4674: RAISE fnd_api.g_exc_unexpected_error;

4670: );
4671: IF x_return_status =fnd_api.g_ret_sts_error THEN
4672: RAISE fnd_api.g_exc_error;
4673: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4674: RAISE fnd_api.g_exc_unexpected_error;
4675: END IF;
4676:
4677: IF (l_debug = 1) THEN
4678: mdebug(l_proc_name||'The item weight UOM code : '||l_item_attr.l_item_weight_uom_code);

Line 4712: IF x_return_status =fnd_api.g_ret_sts_error THEN

4708: , p_org_id => p_organization_id
4709: , p_locator_volume_uom_code => l_old_loc_attr.l_locator_volume_uom_code
4710: , p_locator_weight_uom_code => l_old_loc_attr.l_locator_weight_uom_code
4711: );
4712: IF x_return_status =fnd_api.g_ret_sts_error THEN
4713: RAISE fnd_api.g_exc_error;
4714: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4715: RAISE fnd_api.g_exc_unexpected_error;
4716: END IF;

Line 4713: RAISE fnd_api.g_exc_error;

4709: , p_locator_volume_uom_code => l_old_loc_attr.l_locator_volume_uom_code
4710: , p_locator_weight_uom_code => l_old_loc_attr.l_locator_weight_uom_code
4711: );
4712: IF x_return_status =fnd_api.g_ret_sts_error THEN
4713: RAISE fnd_api.g_exc_error;
4714: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4715: RAISE fnd_api.g_exc_unexpected_error;
4716: END IF;
4717: IF p_inventory_item_id = -1 THEN

Line 4714: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

4710: , p_locator_weight_uom_code => l_old_loc_attr.l_locator_weight_uom_code
4711: );
4712: IF x_return_status =fnd_api.g_ret_sts_error THEN
4713: RAISE fnd_api.g_exc_error;
4714: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4715: RAISE fnd_api.g_exc_unexpected_error;
4716: END IF;
4717: IF p_inventory_item_id = -1 THEN
4718: l_quantity := l_content_lpn_quantity;

Line 4715: RAISE fnd_api.g_exc_unexpected_error;

4711: );
4712: IF x_return_status =fnd_api.g_ret_sts_error THEN
4713: RAISE fnd_api.g_exc_error;
4714: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4715: RAISE fnd_api.g_exc_unexpected_error;
4716: END IF;
4717: IF p_inventory_item_id = -1 THEN
4718: l_quantity := l_content_lpn_quantity;
4719: END IF;

Line 4751: IF x_return_status =fnd_api.g_ret_sts_error THEN

4747: , p_org_id => p_organization_id
4748: , p_locator_volume_uom_code => l_old_loc_attr.l_locator_volume_uom_code
4749: , p_locator_weight_uom_code => l_old_loc_attr.l_locator_weight_uom_code
4750: );
4751: IF x_return_status =fnd_api.g_ret_sts_error THEN
4752: RAISE fnd_api.g_exc_error;
4753: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4754: RAISE fnd_api.g_exc_unexpected_error;
4755: END IF;

Line 4752: RAISE fnd_api.g_exc_error;

4748: , p_locator_volume_uom_code => l_old_loc_attr.l_locator_volume_uom_code
4749: , p_locator_weight_uom_code => l_old_loc_attr.l_locator_weight_uom_code
4750: );
4751: IF x_return_status =fnd_api.g_ret_sts_error THEN
4752: RAISE fnd_api.g_exc_error;
4753: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4754: RAISE fnd_api.g_exc_unexpected_error;
4755: END IF;
4756: IF (l_debug = 1) THEN

Line 4753: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

4749: , p_locator_weight_uom_code => l_old_loc_attr.l_locator_weight_uom_code
4750: );
4751: IF x_return_status =fnd_api.g_ret_sts_error THEN
4752: RAISE fnd_api.g_exc_error;
4753: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4754: RAISE fnd_api.g_exc_unexpected_error;
4755: END IF;
4756: IF (l_debug = 1) THEN
4757: mdebug(l_proc_name||'l_lpn_gross_weight_uom_code : '||l_lpn_attr.l_gross_weight_uom_code);

Line 4754: RAISE fnd_api.g_exc_unexpected_error;

4750: );
4751: IF x_return_status =fnd_api.g_ret_sts_error THEN
4752: RAISE fnd_api.g_exc_error;
4753: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4754: RAISE fnd_api.g_exc_unexpected_error;
4755: END IF;
4756: IF (l_debug = 1) THEN
4757: mdebug(l_proc_name||'l_lpn_gross_weight_uom_code : '||l_lpn_attr.l_gross_weight_uom_code);
4758: mdebug(l_proc_name||'l_lpn_content_volume_uom_code : '||l_lpn_attr.l_content_volume_uom_code);

Line 4802: IF x_return_status =fnd_api.g_ret_sts_error THEN

4798: , p_quantity => l_quantity
4799: , p_inventory_location_id => l_old_inventory_location_id
4800: , p_organization_id => l_old_organization_id
4801: );
4802: IF x_return_status =fnd_api.g_ret_sts_error THEN
4803: RAISE fnd_api.g_exc_error;
4804: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4805: RAISE fnd_api.g_exc_unexpected_error;
4806: END IF;

Line 4803: RAISE fnd_api.g_exc_error;

4799: , p_inventory_location_id => l_old_inventory_location_id
4800: , p_organization_id => l_old_organization_id
4801: );
4802: IF x_return_status =fnd_api.g_ret_sts_error THEN
4803: RAISE fnd_api.g_exc_error;
4804: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4805: RAISE fnd_api.g_exc_unexpected_error;
4806: END IF;
4807: l_update_table := FALSE;

Line 4804: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

4800: , p_organization_id => l_old_organization_id
4801: );
4802: IF x_return_status =fnd_api.g_ret_sts_error THEN
4803: RAISE fnd_api.g_exc_error;
4804: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4805: RAISE fnd_api.g_exc_unexpected_error;
4806: END IF;
4807: l_update_table := FALSE;
4808: ELSIF p_lpn_id IS NOT NULL THEN

Line 4805: RAISE fnd_api.g_exc_unexpected_error;

4801: );
4802: IF x_return_status =fnd_api.g_ret_sts_error THEN
4803: RAISE fnd_api.g_exc_error;
4804: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4805: RAISE fnd_api.g_exc_unexpected_error;
4806: END IF;
4807: l_update_table := FALSE;
4808: ELSIF p_lpn_id IS NOT NULL THEN
4809: fetch_lpn_content_qty(

Line 4830: IF x_return_status =fnd_api.g_ret_sts_error THEN

4826: , p_quantity => l_quantity
4827: , p_inventory_location_id => l_old_inventory_location_id
4828: , p_organization_id => l_old_organization_id
4829: );
4830: IF x_return_status =fnd_api.g_ret_sts_error THEN
4831: RAISE fnd_api.g_exc_error;
4832: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4833: RAISE fnd_api.g_exc_unexpected_error;
4834: END IF;

Line 4831: RAISE fnd_api.g_exc_error;

4827: , p_inventory_location_id => l_old_inventory_location_id
4828: , p_organization_id => l_old_organization_id
4829: );
4830: IF x_return_status =fnd_api.g_ret_sts_error THEN
4831: RAISE fnd_api.g_exc_error;
4832: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4833: RAISE fnd_api.g_exc_unexpected_error;
4834: END IF;
4835: l_update_table := FALSE;

Line 4832: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

4828: , p_organization_id => l_old_organization_id
4829: );
4830: IF x_return_status =fnd_api.g_ret_sts_error THEN
4831: RAISE fnd_api.g_exc_error;
4832: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4833: RAISE fnd_api.g_exc_unexpected_error;
4834: END IF;
4835: l_update_table := FALSE;
4836: ELSE

Line 4833: RAISE fnd_api.g_exc_unexpected_error;

4829: );
4830: IF x_return_status =fnd_api.g_ret_sts_error THEN
4831: RAISE fnd_api.g_exc_error;
4832: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4833: RAISE fnd_api.g_exc_unexpected_error;
4834: END IF;
4835: l_update_table := FALSE;
4836: ELSE
4837: /*-----------------------------------------------------------------

Line 4959: IF x_return_status =fnd_api.g_ret_sts_error THEN

4955: , p_quantity => p_quantity
4956: , p_inventory_location_id => p_inventory_location_id
4957: , p_organization_id => p_organization_id
4958: );
4959: IF x_return_status =fnd_api.g_ret_sts_error THEN
4960: RAISE fnd_api.g_exc_error;
4961: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4962: RAISE fnd_api.g_exc_unexpected_error;
4963: END IF;

Line 4960: RAISE fnd_api.g_exc_error;

4956: , p_inventory_location_id => p_inventory_location_id
4957: , p_organization_id => p_organization_id
4958: );
4959: IF x_return_status =fnd_api.g_ret_sts_error THEN
4960: RAISE fnd_api.g_exc_error;
4961: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4962: RAISE fnd_api.g_exc_unexpected_error;
4963: END IF;
4964: ELSIF p_content_lpn_id IS NOT NULL THEN

Line 4961: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

4957: , p_organization_id => p_organization_id
4958: );
4959: IF x_return_status =fnd_api.g_ret_sts_error THEN
4960: RAISE fnd_api.g_exc_error;
4961: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4962: RAISE fnd_api.g_exc_unexpected_error;
4963: END IF;
4964: ELSIF p_content_lpn_id IS NOT NULL THEN
4965: /*-----------------------------------------------------------------

Line 4962: RAISE fnd_api.g_exc_unexpected_error;

4958: );
4959: IF x_return_status =fnd_api.g_ret_sts_error THEN
4960: RAISE fnd_api.g_exc_error;
4961: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4962: RAISE fnd_api.g_exc_unexpected_error;
4963: END IF;
4964: ELSIF p_content_lpn_id IS NOT NULL THEN
4965: /*-----------------------------------------------------------------
4966: Receive the Content LPN into the destination Locator.

Line 4981: IF x_return_status =fnd_api.g_ret_sts_error THEN

4977: , p_quantity => l_quantity
4978: , p_inventory_location_id => p_inventory_location_id
4979: , p_organization_id => p_organization_id
4980: );
4981: IF x_return_status =fnd_api.g_ret_sts_error THEN
4982: RAISE fnd_api.g_exc_error;
4983: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4984: RAISE fnd_api.g_exc_unexpected_error;
4985: END IF;

Line 4982: RAISE fnd_api.g_exc_error;

4978: , p_inventory_location_id => p_inventory_location_id
4979: , p_organization_id => p_organization_id
4980: );
4981: IF x_return_status =fnd_api.g_ret_sts_error THEN
4982: RAISE fnd_api.g_exc_error;
4983: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4984: RAISE fnd_api.g_exc_unexpected_error;
4985: END IF;
4986: ELSE

Line 4983: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

4979: , p_organization_id => p_organization_id
4980: );
4981: IF x_return_status =fnd_api.g_ret_sts_error THEN
4982: RAISE fnd_api.g_exc_error;
4983: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4984: RAISE fnd_api.g_exc_unexpected_error;
4985: END IF;
4986: ELSE
4987: /*-------------------------------------------------------------------

Line 4984: RAISE fnd_api.g_exc_unexpected_error;

4980: );
4981: IF x_return_status =fnd_api.g_ret_sts_error THEN
4982: RAISE fnd_api.g_exc_error;
4983: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4984: RAISE fnd_api.g_exc_unexpected_error;
4985: END IF;
4986: ELSE
4987: /*-------------------------------------------------------------------
4988: Receive transacted loose Item Capacity into the destination locator

Line 5064: x_return_status := FND_API.G_RET_STS_SUCCESS;

5060: l_content_qty NUMBER;
5061: l_lpn_qty NUMBER;
5062: l_content_lpn_vol NUMBER;
5063: BEGIN
5064: x_return_status := FND_API.G_RET_STS_SUCCESS;
5065: l_locator_current_weight := p_loc_attr.l_locator_current_weight;
5066: l_locator_available_weight := p_loc_attr.l_locator_available_weight;
5067: /*-------------------------------------------------------------------------------------------------
5068: Content LPN is null. UnPack material to loose.

Line 5192: x_return_status := FND_API.G_RET_STS_SUCCESS;

5188: l_content_volume NUMBER;
5189: l_lpn_exists_in_locator VARCHAR2(1);
5190: l_container_item_attr ItemRec;
5191: BEGIN
5192: x_return_status := FND_API.G_RET_STS_SUCCESS;
5193:
5194: --if it is a cartonization txn, the the lpn would not contain the container item weight and volume
5195: --yet.
5196: IF (l_debug = 1) THEN

Line 5217: IF x_return_status =fnd_api.g_ret_sts_error THEN

5213: , p_quantity => NULL
5214: , p_organization_id => p_organization_id
5215: , p_container_item => 'Y'
5216: );
5217: IF x_return_status =fnd_api.g_ret_sts_error THEN
5218: RAISE fnd_api.g_exc_error;
5219: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
5220: RAISE fnd_api.g_exc_unexpected_error;
5221: END IF;

Line 5218: RAISE fnd_api.g_exc_error;

5214: , p_organization_id => p_organization_id
5215: , p_container_item => 'Y'
5216: );
5217: IF x_return_status =fnd_api.g_ret_sts_error THEN
5218: RAISE fnd_api.g_exc_error;
5219: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
5220: RAISE fnd_api.g_exc_unexpected_error;
5221: END IF;
5222:

Line 5219: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

5215: , p_container_item => 'Y'
5216: );
5217: IF x_return_status =fnd_api.g_ret_sts_error THEN
5218: RAISE fnd_api.g_exc_error;
5219: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
5220: RAISE fnd_api.g_exc_unexpected_error;
5221: END IF;
5222:
5223: IF (l_debug = 1) THEN

Line 5220: RAISE fnd_api.g_exc_unexpected_error;

5216: );
5217: IF x_return_status =fnd_api.g_ret_sts_error THEN
5218: RAISE fnd_api.g_exc_error;
5219: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
5220: RAISE fnd_api.g_exc_unexpected_error;
5221: END IF;
5222:
5223: IF (l_debug = 1) THEN
5224: mdebug(l_proc_name||'The item weight UOM code : '||l_container_item_attr.l_item_weight_uom_code);

Line 5385: x_return_status := FND_API.G_RET_STS_SUCCESS;

5381: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
5382: l_proc_name VARCHAR2(50) := 'UPD_LPN_LOC_CURR_CPTY_NOAUTO:';
5383: BEGIN
5384:
5385: x_return_status := FND_API.G_RET_STS_SUCCESS;
5386:
5387: /*--------------------------------------------------------------------------------------------
5388: Fetch the actual Inventory Location ID
5389: --------------------------------------------------------------------------------------------*/

Line 5492: IF l_return_status =fnd_api.g_ret_sts_error THEN

5488: , p_quantity => l_quantity
5489: , p_organization_id => p_organization_id
5490: , p_container_item => null
5491: );
5492: IF l_return_status =fnd_api.g_ret_sts_error THEN
5493: RAISE fnd_api.g_exc_error;
5494: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
5495: RAISE fnd_api.g_exc_unexpected_error;
5496: END IF;

Line 5493: RAISE fnd_api.g_exc_error;

5489: , p_organization_id => p_organization_id
5490: , p_container_item => null
5491: );
5492: IF l_return_status =fnd_api.g_ret_sts_error THEN
5493: RAISE fnd_api.g_exc_error;
5494: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
5495: RAISE fnd_api.g_exc_unexpected_error;
5496: END IF;
5497:

Line 5494: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

5490: , p_container_item => null
5491: );
5492: IF l_return_status =fnd_api.g_ret_sts_error THEN
5493: RAISE fnd_api.g_exc_error;
5494: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
5495: RAISE fnd_api.g_exc_unexpected_error;
5496: END IF;
5497:
5498: IF (l_debug = 1) THEN

Line 5495: RAISE fnd_api.g_exc_unexpected_error;

5491: );
5492: IF l_return_status =fnd_api.g_ret_sts_error THEN
5493: RAISE fnd_api.g_exc_error;
5494: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
5495: RAISE fnd_api.g_exc_unexpected_error;
5496: END IF;
5497:
5498: IF (l_debug = 1) THEN
5499: mdebug(l_proc_name||'The item weight UOM code : '||l_item_attr.l_item_weight_uom_code);

Line 5533: IF l_return_status =fnd_api.g_ret_sts_error THEN

5529: , p_org_id => p_organization_id
5530: , p_locator_volume_uom_code => l_loc_attr.l_locator_volume_uom_code
5531: , p_locator_weight_uom_code => l_loc_attr.l_locator_weight_uom_code
5532: );
5533: IF l_return_status =fnd_api.g_ret_sts_error THEN
5534: RAISE fnd_api.g_exc_error;
5535: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
5536: RAISE fnd_api.g_exc_unexpected_error;
5537: END IF;

Line 5534: RAISE fnd_api.g_exc_error;

5530: , p_locator_volume_uom_code => l_loc_attr.l_locator_volume_uom_code
5531: , p_locator_weight_uom_code => l_loc_attr.l_locator_weight_uom_code
5532: );
5533: IF l_return_status =fnd_api.g_ret_sts_error THEN
5534: RAISE fnd_api.g_exc_error;
5535: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
5536: RAISE fnd_api.g_exc_unexpected_error;
5537: END IF;
5538:

Line 5535: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

5531: , p_locator_weight_uom_code => l_loc_attr.l_locator_weight_uom_code
5532: );
5533: IF l_return_status =fnd_api.g_ret_sts_error THEN
5534: RAISE fnd_api.g_exc_error;
5535: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
5536: RAISE fnd_api.g_exc_unexpected_error;
5537: END IF;
5538:
5539: IF p_inventory_item_id = -1 THEN

Line 5536: RAISE fnd_api.g_exc_unexpected_error;

5532: );
5533: IF l_return_status =fnd_api.g_ret_sts_error THEN
5534: RAISE fnd_api.g_exc_error;
5535: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
5536: RAISE fnd_api.g_exc_unexpected_error;
5537: END IF;
5538:
5539: IF p_inventory_item_id = -1 THEN
5540: l_quantity := l_content_lpn_quantity;

Line 5573: IF l_return_status =fnd_api.g_ret_sts_error THEN

5569: , p_org_id => p_organization_id
5570: , p_locator_volume_uom_code => l_loc_attr.l_locator_volume_uom_code
5571: , p_locator_weight_uom_code => l_loc_attr.l_locator_weight_uom_code
5572: );
5573: IF l_return_status =fnd_api.g_ret_sts_error THEN
5574: RAISE fnd_api.g_exc_error;
5575: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
5576: RAISE fnd_api.g_exc_unexpected_error;
5577: END IF;

Line 5574: RAISE fnd_api.g_exc_error;

5570: , p_locator_volume_uom_code => l_loc_attr.l_locator_volume_uom_code
5571: , p_locator_weight_uom_code => l_loc_attr.l_locator_weight_uom_code
5572: );
5573: IF l_return_status =fnd_api.g_ret_sts_error THEN
5574: RAISE fnd_api.g_exc_error;
5575: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
5576: RAISE fnd_api.g_exc_unexpected_error;
5577: END IF;
5578: IF (l_debug = 1) THEN

Line 5575: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

5571: , p_locator_weight_uom_code => l_loc_attr.l_locator_weight_uom_code
5572: );
5573: IF l_return_status =fnd_api.g_ret_sts_error THEN
5574: RAISE fnd_api.g_exc_error;
5575: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
5576: RAISE fnd_api.g_exc_unexpected_error;
5577: END IF;
5578: IF (l_debug = 1) THEN
5579: mdebug(l_proc_name||'l_trn_gross_weight_uom_code : '||l_trn_lpn_attr.l_gross_weight_uom_code);

Line 5576: RAISE fnd_api.g_exc_unexpected_error;

5572: );
5573: IF l_return_status =fnd_api.g_ret_sts_error THEN
5574: RAISE fnd_api.g_exc_error;
5575: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
5576: RAISE fnd_api.g_exc_unexpected_error;
5577: END IF;
5578: IF (l_debug = 1) THEN
5579: mdebug(l_proc_name||'l_trn_gross_weight_uom_code : '||l_trn_lpn_attr.l_gross_weight_uom_code);
5580: mdebug(l_proc_name||'l_trn_content_volume_uom_code : '||l_trn_lpn_attr.l_content_volume_uom_code);

Line 5609: IF l_return_status =fnd_api.g_ret_sts_error THEN

5605: , p_org_id => p_organization_id
5606: , p_locator_volume_uom_code => l_loc_attr.l_locator_volume_uom_code
5607: , p_locator_weight_uom_code => l_loc_attr.l_locator_weight_uom_code
5608: );
5609: IF l_return_status =fnd_api.g_ret_sts_error THEN
5610: RAISE fnd_api.g_exc_error;
5611: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
5612: RAISE fnd_api.g_exc_unexpected_error;
5613: END IF;

Line 5610: RAISE fnd_api.g_exc_error;

5606: , p_locator_volume_uom_code => l_loc_attr.l_locator_volume_uom_code
5607: , p_locator_weight_uom_code => l_loc_attr.l_locator_weight_uom_code
5608: );
5609: IF l_return_status =fnd_api.g_ret_sts_error THEN
5610: RAISE fnd_api.g_exc_error;
5611: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
5612: RAISE fnd_api.g_exc_unexpected_error;
5613: END IF;
5614: IF (l_debug = 1) THEN

Line 5611: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

5607: , p_locator_weight_uom_code => l_loc_attr.l_locator_weight_uom_code
5608: );
5609: IF l_return_status =fnd_api.g_ret_sts_error THEN
5610: RAISE fnd_api.g_exc_error;
5611: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
5612: RAISE fnd_api.g_exc_unexpected_error;
5613: END IF;
5614: IF (l_debug = 1) THEN
5615: mdebug(l_proc_name||'l_lpn_gross_weight_uom_code : '||l_lpn_attr.l_gross_weight_uom_code);

Line 5612: RAISE fnd_api.g_exc_unexpected_error;

5608: );
5609: IF l_return_status =fnd_api.g_ret_sts_error THEN
5610: RAISE fnd_api.g_exc_error;
5611: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
5612: RAISE fnd_api.g_exc_unexpected_error;
5613: END IF;
5614: IF (l_debug = 1) THEN
5615: mdebug(l_proc_name||'l_lpn_gross_weight_uom_code : '||l_lpn_attr.l_gross_weight_uom_code);
5616: mdebug(l_proc_name||'l_lpn_content_volume_uom_code : '||l_lpn_attr.l_content_volume_uom_code);

Line 5655: IF l_return_status =fnd_api.g_ret_sts_error THEN

5651: , p_item_attr => l_item_attr
5652: , p_container_item_id => p_container_item_id
5653: , p_cartonization_id => p_cartonization_id
5654: );
5655: IF l_return_status =fnd_api.g_ret_sts_error THEN
5656: RAISE fnd_api.g_exc_error;
5657: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
5658: RAISE fnd_api.g_exc_unexpected_error;
5659: END IF;

Line 5656: RAISE fnd_api.g_exc_error;

5652: , p_container_item_id => p_container_item_id
5653: , p_cartonization_id => p_cartonization_id
5654: );
5655: IF l_return_status =fnd_api.g_ret_sts_error THEN
5656: RAISE fnd_api.g_exc_error;
5657: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
5658: RAISE fnd_api.g_exc_unexpected_error;
5659: END IF;
5660: ELSIF p_transaction_action_id = 51 THEN

Line 5657: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

5653: , p_cartonization_id => p_cartonization_id
5654: );
5655: IF l_return_status =fnd_api.g_ret_sts_error THEN
5656: RAISE fnd_api.g_exc_error;
5657: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
5658: RAISE fnd_api.g_exc_unexpected_error;
5659: END IF;
5660: ELSIF p_transaction_action_id = 51 THEN
5661: /*-------------------------------------------------------------------------------------------

Line 5658: RAISE fnd_api.g_exc_unexpected_error;

5654: );
5655: IF l_return_status =fnd_api.g_ret_sts_error THEN
5656: RAISE fnd_api.g_exc_error;
5657: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
5658: RAISE fnd_api.g_exc_unexpected_error;
5659: END IF;
5660: ELSIF p_transaction_action_id = 51 THEN
5661: /*-------------------------------------------------------------------------------------------
5662: UnPack Transaction

Line 5682: IF l_return_status =fnd_api.g_ret_sts_error THEN

5678: , p_organization_id => p_organization_id
5679: , p_item_attr => l_item_attr
5680: , p_quantity => p_quantity
5681: );
5682: IF l_return_status =fnd_api.g_ret_sts_error THEN
5683: RAISE fnd_api.g_exc_error;
5684: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
5685: RAISE fnd_api.g_exc_unexpected_error;
5686: END IF;

Line 5683: RAISE fnd_api.g_exc_error;

5679: , p_item_attr => l_item_attr
5680: , p_quantity => p_quantity
5681: );
5682: IF l_return_status =fnd_api.g_ret_sts_error THEN
5683: RAISE fnd_api.g_exc_error;
5684: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
5685: RAISE fnd_api.g_exc_unexpected_error;
5686: END IF;
5687: ELSIF p_transaction_action_id IN (27,12, 31) OR

Line 5684: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

5680: , p_quantity => p_quantity
5681: );
5682: IF l_return_status =fnd_api.g_ret_sts_error THEN
5683: RAISE fnd_api.g_exc_error;
5684: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
5685: RAISE fnd_api.g_exc_unexpected_error;
5686: END IF;
5687: ELSIF p_transaction_action_id IN (27,12, 31) OR
5688: (p_transaction_action_id IN (40,41,42) AND p_transfer_lpn_id IS NOT NULL ) THEN --Bug#4750846

Line 5685: RAISE fnd_api.g_exc_unexpected_error;

5681: );
5682: IF l_return_status =fnd_api.g_ret_sts_error THEN
5683: RAISE fnd_api.g_exc_error;
5684: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
5685: RAISE fnd_api.g_exc_unexpected_error;
5686: END IF;
5687: ELSIF p_transaction_action_id IN (27,12, 31) OR
5688: (p_transaction_action_id IN (40,41,42) AND p_transfer_lpn_id IS NOT NULL ) THEN --Bug#4750846
5689: /*-------------------------------------------------------------------------------------------

Line 5708: IF l_return_status =fnd_api.g_ret_sts_error THEN

5704: , p_quantity => l_quantity
5705: , p_inventory_location_id => l_inventory_location_id
5706: , p_organization_id => p_organization_id
5707: );
5708: IF l_return_status =fnd_api.g_ret_sts_error THEN
5709: RAISE fnd_api.g_exc_error;
5710: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
5711: RAISE fnd_api.g_exc_unexpected_error;
5712: END IF;

Line 5709: RAISE fnd_api.g_exc_error;

5705: , p_inventory_location_id => l_inventory_location_id
5706: , p_organization_id => p_organization_id
5707: );
5708: IF l_return_status =fnd_api.g_ret_sts_error THEN
5709: RAISE fnd_api.g_exc_error;
5710: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
5711: RAISE fnd_api.g_exc_unexpected_error;
5712: END IF;
5713: ELSIF p_transaction_action_id IN (1,21,32,34) OR

Line 5710: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

5706: , p_organization_id => p_organization_id
5707: );
5708: IF l_return_status =fnd_api.g_ret_sts_error THEN
5709: RAISE fnd_api.g_exc_error;
5710: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
5711: RAISE fnd_api.g_exc_unexpected_error;
5712: END IF;
5713: ELSIF p_transaction_action_id IN (1,21,32,34) OR
5714: (p_transaction_action_id IN (40,41,42) AND p_lpn_id IS NOT NULL ) THEN --Bug#4750846

Line 5711: RAISE fnd_api.g_exc_unexpected_error;

5707: );
5708: IF l_return_status =fnd_api.g_ret_sts_error THEN
5709: RAISE fnd_api.g_exc_error;
5710: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
5711: RAISE fnd_api.g_exc_unexpected_error;
5712: END IF;
5713: ELSIF p_transaction_action_id IN (1,21,32,34) OR
5714: (p_transaction_action_id IN (40,41,42) AND p_lpn_id IS NOT NULL ) THEN --Bug#4750846
5715: /*-------------------------------------------------------------------------------------------

Line 5734: IF l_return_status =fnd_api.g_ret_sts_error THEN

5730: , p_quantity => l_quantity
5731: , p_inventory_location_id => l_inventory_location_id
5732: , p_organization_id => p_organization_id
5733: );
5734: IF l_return_status =fnd_api.g_ret_sts_error THEN
5735: RAISE fnd_api.g_exc_error;
5736: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
5737: RAISE fnd_api.g_exc_unexpected_error;
5738: END IF;

Line 5735: RAISE fnd_api.g_exc_error;

5731: , p_inventory_location_id => l_inventory_location_id
5732: , p_organization_id => p_organization_id
5733: );
5734: IF l_return_status =fnd_api.g_ret_sts_error THEN
5735: RAISE fnd_api.g_exc_error;
5736: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
5737: RAISE fnd_api.g_exc_unexpected_error;
5738: END IF;
5739: ELSIF p_transaction_action_id IN (2,3,28) THEN

Line 5736: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

5732: , p_organization_id => p_organization_id
5733: );
5734: IF l_return_status =fnd_api.g_ret_sts_error THEN
5735: RAISE fnd_api.g_exc_error;
5736: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
5737: RAISE fnd_api.g_exc_unexpected_error;
5738: END IF;
5739: ELSIF p_transaction_action_id IN (2,3,28) THEN
5740: /*-------------------------------------------------------------------------------------------

Line 5737: RAISE fnd_api.g_exc_unexpected_error;

5733: );
5734: IF l_return_status =fnd_api.g_ret_sts_error THEN
5735: RAISE fnd_api.g_exc_error;
5736: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
5737: RAISE fnd_api.g_exc_unexpected_error;
5738: END IF;
5739: ELSIF p_transaction_action_id IN (2,3,28) THEN
5740: /*-------------------------------------------------------------------------------------------
5741: Transfer Transaction

Line 5780: IF l_return_status =fnd_api.g_ret_sts_error THEN

5776: , p_primary_uom_flag => p_primary_uom_flag
5777: , p_from_org_id => p_from_org_id
5778: , p_from_loc_id => p_from_loc_id
5779: );
5780: IF l_return_status =fnd_api.g_ret_sts_error THEN
5781: RAISE fnd_api.g_exc_error;
5782: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
5783: RAISE fnd_api.g_exc_unexpected_error;
5784: END IF;

Line 5781: RAISE fnd_api.g_exc_error;

5777: , p_from_org_id => p_from_org_id
5778: , p_from_loc_id => p_from_loc_id
5779: );
5780: IF l_return_status =fnd_api.g_ret_sts_error THEN
5781: RAISE fnd_api.g_exc_error;
5782: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
5783: RAISE fnd_api.g_exc_unexpected_error;
5784: END IF;
5785: ELSIF p_transaction_action_id = (52) THEN

Line 5782: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

5778: , p_from_loc_id => p_from_loc_id
5779: );
5780: IF l_return_status =fnd_api.g_ret_sts_error THEN
5781: RAISE fnd_api.g_exc_error;
5782: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
5783: RAISE fnd_api.g_exc_unexpected_error;
5784: END IF;
5785: ELSIF p_transaction_action_id = (52) THEN
5786: /*-------------------------------------------------------------------------------------------

Line 5783: RAISE fnd_api.g_exc_unexpected_error;

5779: );
5780: IF l_return_status =fnd_api.g_ret_sts_error THEN
5781: RAISE fnd_api.g_exc_error;
5782: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
5783: RAISE fnd_api.g_exc_unexpected_error;
5784: END IF;
5785: ELSIF p_transaction_action_id = (52) THEN
5786: /*-------------------------------------------------------------------------------------------
5787: LPN Split Transaction

Line 5811: IF l_return_status =fnd_api.g_ret_sts_error THEN

5807: , p_organization_id => p_organization_id
5808: , p_item_attr => l_item_attr
5809: , p_quantity => p_quantity
5810: );
5811: IF l_return_status =fnd_api.g_ret_sts_error THEN
5812: RAISE fnd_api.g_exc_error;
5813: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
5814: RAISE fnd_api.g_exc_unexpected_error;
5815: END IF;

Line 5812: RAISE fnd_api.g_exc_error;

5808: , p_item_attr => l_item_attr
5809: , p_quantity => p_quantity
5810: );
5811: IF l_return_status =fnd_api.g_ret_sts_error THEN
5812: RAISE fnd_api.g_exc_error;
5813: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
5814: RAISE fnd_api.g_exc_unexpected_error;
5815: END IF;
5816:

Line 5813: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

5809: , p_quantity => p_quantity
5810: );
5811: IF l_return_status =fnd_api.g_ret_sts_error THEN
5812: RAISE fnd_api.g_exc_error;
5813: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
5814: RAISE fnd_api.g_exc_unexpected_error;
5815: END IF;
5816:
5817: -- Then Call pack to pack the items into to LPN (transfer_lpn_id)

Line 5814: RAISE fnd_api.g_exc_unexpected_error;

5810: );
5811: IF l_return_status =fnd_api.g_ret_sts_error THEN
5812: RAISE fnd_api.g_exc_error;
5813: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
5814: RAISE fnd_api.g_exc_unexpected_error;
5815: END IF;
5816:
5817: -- Then Call pack to pack the items into to LPN (transfer_lpn_id)
5818: IF (l_debug = 1) THEN

Line 5837: IF l_return_status =fnd_api.g_ret_sts_error THEN

5833: , p_item_attr => l_item_attr
5834: , p_container_item_id => p_container_item_id
5835: , p_cartonization_id => p_cartonization_id
5836: );
5837: IF l_return_status =fnd_api.g_ret_sts_error THEN
5838: RAISE fnd_api.g_exc_error;
5839: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
5840: RAISE fnd_api.g_exc_unexpected_error;
5841: END IF;

Line 5838: RAISE fnd_api.g_exc_error;

5834: , p_container_item_id => p_container_item_id
5835: , p_cartonization_id => p_cartonization_id
5836: );
5837: IF l_return_status =fnd_api.g_ret_sts_error THEN
5838: RAISE fnd_api.g_exc_error;
5839: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
5840: RAISE fnd_api.g_exc_unexpected_error;
5841: END IF;
5842: END IF;

Line 5839: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

5835: , p_cartonization_id => p_cartonization_id
5836: );
5837: IF l_return_status =fnd_api.g_ret_sts_error THEN
5838: RAISE fnd_api.g_exc_error;
5839: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
5840: RAISE fnd_api.g_exc_unexpected_error;
5841: END IF;
5842: END IF;
5843: END upd_lpn_loc_curr_cpty_nauto;

Line 5840: RAISE fnd_api.g_exc_unexpected_error;

5836: );
5837: IF l_return_status =fnd_api.g_ret_sts_error THEN
5838: RAISE fnd_api.g_exc_error;
5839: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
5840: RAISE fnd_api.g_exc_unexpected_error;
5841: END IF;
5842: END IF;
5843: END upd_lpn_loc_curr_cpty_nauto;
5844:

Line 5876: x_return_status := FND_API.G_RET_STS_SUCCESS;

5872: l_msg_count NUMBER;
5873: l_msg_data VARCHAR2(1000);
5874: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
5875: BEGIN
5876: x_return_status := FND_API.G_RET_STS_SUCCESS;
5877: INV_LOC_WMS_UTILS.upd_lpn_loc_curr_cpty_nauto
5878: ( x_return_status =>l_return_status,
5879: x_msg_count =>l_msg_count,
5880: x_msg_data =>l_msg_data,

Line 5897: if l_return_status <> fnd_api.g_ret_sts_success THEN

5893: p_from_org_id => p_from_org_id,
5894: p_from_loc_id => p_from_loc_id
5895: );
5896:
5897: if l_return_status <> fnd_api.g_ret_sts_success THEN
5898: IF l_return_status = fnd_api.g_ret_sts_error then
5899: raise fnd_api.g_exc_error;
5900: ELSE
5901: RAISE fnd_api.g_exc_unexpected_error;

Line 5898: IF l_return_status = fnd_api.g_ret_sts_error then

5894: p_from_loc_id => p_from_loc_id
5895: );
5896:
5897: if l_return_status <> fnd_api.g_ret_sts_success THEN
5898: IF l_return_status = fnd_api.g_ret_sts_error then
5899: raise fnd_api.g_exc_error;
5900: ELSE
5901: RAISE fnd_api.g_exc_unexpected_error;
5902: END IF;

Line 5899: raise fnd_api.g_exc_error;

5895: );
5896:
5897: if l_return_status <> fnd_api.g_ret_sts_success THEN
5898: IF l_return_status = fnd_api.g_ret_sts_error then
5899: raise fnd_api.g_exc_error;
5900: ELSE
5901: RAISE fnd_api.g_exc_unexpected_error;
5902: END IF;
5903: end if;

Line 5901: RAISE fnd_api.g_exc_unexpected_error;

5897: if l_return_status <> fnd_api.g_ret_sts_success THEN
5898: IF l_return_status = fnd_api.g_ret_sts_error then
5899: raise fnd_api.g_exc_error;
5900: ELSE
5901: RAISE fnd_api.g_exc_unexpected_error;
5902: END IF;
5903: end if;
5904:
5905: commit;

Line 5907: WHEN fnd_api.g_exc_error THEN

5903: end if;
5904:
5905: commit;
5906: EXCEPTION
5907: WHEN fnd_api.g_exc_error THEN
5908: rollback;
5909: x_return_status := fnd_api.g_ret_sts_error;
5910: fnd_msg_pub.count_and_get
5911: ( p_count => x_msg_count,

Line 5909: x_return_status := fnd_api.g_ret_sts_error;

5905: commit;
5906: EXCEPTION
5907: WHEN fnd_api.g_exc_error THEN
5908: rollback;
5909: x_return_status := fnd_api.g_ret_sts_error;
5910: fnd_msg_pub.count_and_get
5911: ( p_count => x_msg_count,
5912: p_data => x_msg_data
5913: );

Line 5915: WHEN fnd_api.g_exc_unexpected_error THEN

5911: ( p_count => x_msg_count,
5912: p_data => x_msg_data
5913: );
5914:
5915: WHEN fnd_api.g_exc_unexpected_error THEN
5916: rollback;
5917: x_return_status := fnd_api.g_ret_sts_unexp_error ;
5918: fnd_msg_pub.count_and_get
5919: ( p_count => x_msg_count,

Line 5917: x_return_status := fnd_api.g_ret_sts_unexp_error ;

5913: );
5914:
5915: WHEN fnd_api.g_exc_unexpected_error THEN
5916: rollback;
5917: x_return_status := fnd_api.g_ret_sts_unexp_error ;
5918: fnd_msg_pub.count_and_get
5919: ( p_count => x_msg_count,
5920: p_data => x_msg_data
5921: );

Line 5925: x_return_status := fnd_api.g_ret_sts_error;

5921: );
5922:
5923: WHEN NO_DATA_FOUND THEN
5924: rollback;
5925: x_return_status := fnd_api.g_ret_sts_error;
5926:
5927: WHEN OTHERS THEN
5928: rollback;
5929: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 5929: x_return_status := fnd_api.g_ret_sts_unexp_error;

5925: x_return_status := fnd_api.g_ret_sts_error;
5926:
5927: WHEN OTHERS THEN
5928: rollback;
5929: x_return_status := fnd_api.g_ret_sts_unexp_error;
5930: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
5931: THEN
5932: fnd_msg_pub.add_exc_msg
5933: ( 'inv_loc_wms_utils'

Line 5955: x_return_status := fnd_api.g_ret_sts_success;

5951: l_msg_data varchar2(1000);
5952: l_msg_count number;
5953: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
5954: BEGIN
5955: x_return_status := fnd_api.g_ret_sts_success;
5956:
5957: savepoint lpn_loc_cleanup;
5958: IF (l_debug = 1) THEN
5959: INV_TRX_UTIL_PUB.TRACE('In LPN_LOC_CAPACITY_clean_up Procedure ','lpn_loc_capacity_clean_up',9);

Line 5968: IF X_RETURN_STATUS =fnd_api.g_ret_sts_error THEN

5964: x_msg_data => x_msg_data,
5965: p_organization_id =>p_organization_id,
5966: p_mixed_flag => p_mixed_flag);
5967:
5968: IF X_RETURN_STATUS =fnd_api.g_ret_sts_error THEN
5969: IF (l_debug = 1) THEN
5970: INV_TRX_UTIL_PUB.TRACE('Call to LPN_LOC_current_CAPACITY failed with Status E ','lpn_loc_capacity_clean_up',9);
5971: END IF;
5972: RAISE fnd_api.g_exc_error;

Line 5972: RAISE fnd_api.g_exc_error;

5968: IF X_RETURN_STATUS =fnd_api.g_ret_sts_error THEN
5969: IF (l_debug = 1) THEN
5970: INV_TRX_UTIL_PUB.TRACE('Call to LPN_LOC_current_CAPACITY failed with Status E ','lpn_loc_capacity_clean_up',9);
5971: END IF;
5972: RAISE fnd_api.g_exc_error;
5973: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN
5974: IF (l_debug = 1) THEN
5975: INV_TRX_UTIL_PUB.TRACE('Call to LPN_LOC_current_CAPACITY failed with status U','lpn_loc_capacity_clean_up',9);
5976: END IF;

Line 5973: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN

5969: IF (l_debug = 1) THEN
5970: INV_TRX_UTIL_PUB.TRACE('Call to LPN_LOC_current_CAPACITY failed with Status E ','lpn_loc_capacity_clean_up',9);
5971: END IF;
5972: RAISE fnd_api.g_exc_error;
5973: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN
5974: IF (l_debug = 1) THEN
5975: INV_TRX_UTIL_PUB.TRACE('Call to LPN_LOC_current_CAPACITY failed with status U','lpn_loc_capacity_clean_up',9);
5976: END IF;
5977: RAISE fnd_api.g_exc_unexpected_error;

Line 5977: RAISE fnd_api.g_exc_unexpected_error;

5973: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN
5974: IF (l_debug = 1) THEN
5975: INV_TRX_UTIL_PUB.TRACE('Call to LPN_LOC_current_CAPACITY failed with status U','lpn_loc_capacity_clean_up',9);
5976: END IF;
5977: RAISE fnd_api.g_exc_unexpected_error;
5978: END IF;
5979:
5980: IF (l_debug = 1) THEN
5981: INV_TRX_UTIL_PUB.TRACE('Before call to lpn_loc_cleanup_mmtt','lpn_loc_capacity_clean_up',9);

Line 5990: IF X_RETURN_STATUS =fnd_api.g_ret_sts_error THEN

5986: x_msg_data =>l_msg_data,
5987: p_organization_id =>p_organization_id,
5988: p_mixed_flag =>p_mixed_flag);
5989:
5990: IF X_RETURN_STATUS =fnd_api.g_ret_sts_error THEN
5991: IF (l_debug = 1) THEN
5992: INV_TRX_UTIL_PUB.TRACE('Call to lpn_loc_cleanup_mmtt failed with status E','lpn_loc_capacity_clean_up',9);
5993: END IF;
5994: RAISE fnd_api.g_exc_error;

Line 5994: RAISE fnd_api.g_exc_error;

5990: IF X_RETURN_STATUS =fnd_api.g_ret_sts_error THEN
5991: IF (l_debug = 1) THEN
5992: INV_TRX_UTIL_PUB.TRACE('Call to lpn_loc_cleanup_mmtt failed with status E','lpn_loc_capacity_clean_up',9);
5993: END IF;
5994: RAISE fnd_api.g_exc_error;
5995: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN
5996: IF (l_debug = 1) THEN
5997: INV_TRX_UTIL_PUB.TRACE('Call to lpn_loc_cleanup_mmtt failed with status U','lpn_loc_capacity_clean_up',9);
5998: END IF;

Line 5995: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN

5991: IF (l_debug = 1) THEN
5992: INV_TRX_UTIL_PUB.TRACE('Call to lpn_loc_cleanup_mmtt failed with status E','lpn_loc_capacity_clean_up',9);
5993: END IF;
5994: RAISE fnd_api.g_exc_error;
5995: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN
5996: IF (l_debug = 1) THEN
5997: INV_TRX_UTIL_PUB.TRACE('Call to lpn_loc_cleanup_mmtt failed with status U','lpn_loc_capacity_clean_up',9);
5998: END IF;
5999: RAISE fnd_api.g_exc_unexpected_error;

Line 5999: RAISE fnd_api.g_exc_unexpected_error;

5995: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN
5996: IF (l_debug = 1) THEN
5997: INV_TRX_UTIL_PUB.TRACE('Call to lpn_loc_cleanup_mmtt failed with status U','lpn_loc_capacity_clean_up',9);
5998: END IF;
5999: RAISE fnd_api.g_exc_unexpected_error;
6000: END IF;
6001:
6002: EXCEPTION
6003: WHEN fnd_api.g_exc_error THEN

Line 6003: WHEN fnd_api.g_exc_error THEN

5999: RAISE fnd_api.g_exc_unexpected_error;
6000: END IF;
6001:
6002: EXCEPTION
6003: WHEN fnd_api.g_exc_error THEN
6004: --Fixed bug 2342723, do not rollback to savepoint
6005: -- Bug 3511690 rolling back to savepoint
6006: rollback to lpn_loc_cleanup;
6007: --rollback;

Line 6008: x_return_status := fnd_api.g_ret_sts_error;

6004: --Fixed bug 2342723, do not rollback to savepoint
6005: -- Bug 3511690 rolling back to savepoint
6006: rollback to lpn_loc_cleanup;
6007: --rollback;
6008: x_return_status := fnd_api.g_ret_sts_error;
6009: fnd_msg_pub.count_and_get
6010: ( p_count => x_msg_count,
6011: p_data => x_msg_data
6012: );

Line 6014: WHEN fnd_api.g_exc_unexpected_error THEN

6010: ( p_count => x_msg_count,
6011: p_data => x_msg_data
6012: );
6013:
6014: WHEN fnd_api.g_exc_unexpected_error THEN
6015: x_return_status := fnd_api.g_ret_sts_unexp_error ;
6016: rollback to lpn_loc_cleanup;
6017: --rollback;
6018: fnd_msg_pub.count_and_get

Line 6015: x_return_status := fnd_api.g_ret_sts_unexp_error ;

6011: p_data => x_msg_data
6012: );
6013:
6014: WHEN fnd_api.g_exc_unexpected_error THEN
6015: x_return_status := fnd_api.g_ret_sts_unexp_error ;
6016: rollback to lpn_loc_cleanup;
6017: --rollback;
6018: fnd_msg_pub.count_and_get
6019: ( p_count => x_msg_count,

Line 6024: x_return_status := fnd_api.g_ret_sts_error;

6020: p_data => x_msg_data
6021: );
6022:
6023: WHEN NO_DATA_FOUND THEN
6024: x_return_status := fnd_api.g_ret_sts_error;
6025: rollback to lpn_loc_cleanup;
6026: --rollback;
6027: fnd_msg_pub.count_and_get
6028: ( p_count => x_msg_count,

Line 6032: x_return_status := fnd_api.g_ret_sts_unexp_error;

6028: ( p_count => x_msg_count,
6029: p_data => x_msg_data
6030: );
6031: WHEN OTHERS THEN
6032: x_return_status := fnd_api.g_ret_sts_unexp_error;
6033: rollback to lpn_loc_cleanup;
6034: --rollback;
6035: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
6036: THEN

Line 6234: WHEN fnd_api.g_exc_error THEN

6230: x_locator_current_volume := l_locator_current_volume - l_cnt_lpn_container_item_vol;
6231: END IF;
6232: END IF;
6233: EXCEPTION
6234: WHEN fnd_api.g_exc_error THEN
6235: x_return_status := fnd_api.g_ret_sts_error;
6236: fnd_msg_pub.count_and_get
6237: ( p_count => x_msg_count,
6238: p_data => x_msg_data

Line 6235: x_return_status := fnd_api.g_ret_sts_error;

6231: END IF;
6232: END IF;
6233: EXCEPTION
6234: WHEN fnd_api.g_exc_error THEN
6235: x_return_status := fnd_api.g_ret_sts_error;
6236: fnd_msg_pub.count_and_get
6237: ( p_count => x_msg_count,
6238: p_data => x_msg_data
6239: );

Line 6240: WHEN fnd_api.g_exc_unexpected_error THEN

6236: fnd_msg_pub.count_and_get
6237: ( p_count => x_msg_count,
6238: p_data => x_msg_data
6239: );
6240: WHEN fnd_api.g_exc_unexpected_error THEN
6241: x_return_status := fnd_api.g_ret_sts_unexp_error ;
6242: fnd_msg_pub.count_and_get
6243: ( p_count => x_msg_count,
6244: p_data => x_msg_data

Line 6241: x_return_status := fnd_api.g_ret_sts_unexp_error ;

6237: ( p_count => x_msg_count,
6238: p_data => x_msg_data
6239: );
6240: WHEN fnd_api.g_exc_unexpected_error THEN
6241: x_return_status := fnd_api.g_ret_sts_unexp_error ;
6242: fnd_msg_pub.count_and_get
6243: ( p_count => x_msg_count,
6244: p_data => x_msg_data
6245: );

Line 6247: x_return_status := fnd_api.g_ret_sts_error;

6243: ( p_count => x_msg_count,
6244: p_data => x_msg_data
6245: );
6246: WHEN NO_DATA_FOUND THEN
6247: x_return_status := fnd_api.g_ret_sts_error;
6248: WHEN OTHERS THEN
6249: x_return_status := fnd_api.g_ret_sts_unexp_error;
6250: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
6251: THEN

Line 6249: x_return_status := fnd_api.g_ret_sts_unexp_error;

6245: );
6246: WHEN NO_DATA_FOUND THEN
6247: x_return_status := fnd_api.g_ret_sts_error;
6248: WHEN OTHERS THEN
6249: x_return_status := fnd_api.g_ret_sts_unexp_error;
6250: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
6251: THEN
6252: fnd_msg_pub.add_exc_msg
6253: ( 'inv_loc_wms_utils'

Line 6302: x_return_status := FND_API.G_RET_STS_SUCCESS;

6298: l_msg_data VARCHAR2(1000);
6299: l_msg_count NUMBER;
6300: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
6301: BEGIN
6302: x_return_status := FND_API.G_RET_STS_SUCCESS;
6303: BEGIN
6304:
6305: SELECT GROSS_WEIGHT_UOM_CODE,
6306: CONTENT_VOLUME_UOM_CODE,

Line 6359: IF l_return_status =fnd_api.g_ret_sts_error THEN

6355: null ,
6356: p_org_id,
6357: 'Y'
6358: );
6359: IF l_return_status =fnd_api.g_ret_sts_error THEN
6360: IF (l_debug = 1) THEN
6361: INV_TRX_UTIL_PUB.TRACE('Error fetching container item attributes - '||l_return_status , 'LPN-ATTRIBUTE-UPDATE_LPN_LOC',4);
6362: END IF;
6363: RAISE fnd_api.g_exc_error;

Line 6363: RAISE fnd_api.g_exc_error;

6359: IF l_return_status =fnd_api.g_ret_sts_error THEN
6360: IF (l_debug = 1) THEN
6361: INV_TRX_UTIL_PUB.TRACE('Error fetching container item attributes - '||l_return_status , 'LPN-ATTRIBUTE-UPDATE_LPN_LOC',4);
6362: END IF;
6363: RAISE fnd_api.g_exc_error;
6364: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
6365: IF (l_debug = 1) THEN
6366: INV_TRX_UTIL_PUB.TRACE('Error fetching container item attributes - '||l_return_status , 'LPN-ATTRIBUTE-UPDATE_LPN_LOC',4);
6367: END IF;

Line 6364: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

6360: IF (l_debug = 1) THEN
6361: INV_TRX_UTIL_PUB.TRACE('Error fetching container item attributes - '||l_return_status , 'LPN-ATTRIBUTE-UPDATE_LPN_LOC',4);
6362: END IF;
6363: RAISE fnd_api.g_exc_error;
6364: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
6365: IF (l_debug = 1) THEN
6366: INV_TRX_UTIL_PUB.TRACE('Error fetching container item attributes - '||l_return_status , 'LPN-ATTRIBUTE-UPDATE_LPN_LOC',4);
6367: END IF;
6368: RAISE fnd_api.g_exc_unexpected_error;

Line 6368: RAISE fnd_api.g_exc_unexpected_error;

6364: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
6365: IF (l_debug = 1) THEN
6366: INV_TRX_UTIL_PUB.TRACE('Error fetching container item attributes - '||l_return_status , 'LPN-ATTRIBUTE-UPDATE_LPN_LOC',4);
6367: END IF;
6368: RAISE fnd_api.g_exc_unexpected_error;
6369: END IF;
6370: END IF;
6371:
6372: IF l_gross_weight_uom_code is not null AND

Line 6394: RAISE fnd_api.g_exc_error;

6390: ELSE
6391: l_container_item_xacted_weight := l_container_item_unit_weight;
6392: END IF;
6393: IF l_container_item_xacted_weight = -99999 THEN
6394: RAISE fnd_api.g_exc_error;
6395: END IF;
6396: IF (l_debug = 1) THEN
6397: INV_TRX_UTIL_PUB.TRACE('l_container_item_xacted_weight is '||to_char(l_container_item_xacted_weight), 'LPN-ATTRIBUTE-UPDATE_LPN_LOC',4);
6398: END IF;

Line 6422: RAISE fnd_api.g_exc_error;

6418: IF (l_debug = 1) THEN
6419: INV_TRX_UTIL_PUB.TRACE('l_container_item_xacted_volume is '||to_char(l_container_item_xacted_volume), 'LPN-ATTRIBUTE-UPDATE_LPN_LOC',4);
6420: END IF;
6421: IF l_container_item_xacted_volume = -99999 THEN
6422: RAISE fnd_api.g_exc_error;
6423: END IF;
6424:
6425: END IF;
6426:

Line 6450: WHEN fnd_api.g_exc_error THEN

6446: x_container_item_weight :=nvl(l_container_item_xacted_weight,0);
6447: x_container_item_vol :=nvl(l_container_item_xacted_volume,0);
6448:
6449: EXCEPTION
6450: WHEN fnd_api.g_exc_error THEN
6451: x_return_status := fnd_api.g_ret_sts_error;
6452: fnd_msg_pub.count_and_get
6453: ( p_count => x_msg_count,
6454: p_data => x_msg_data

Line 6451: x_return_status := fnd_api.g_ret_sts_error;

6447: x_container_item_vol :=nvl(l_container_item_xacted_volume,0);
6448:
6449: EXCEPTION
6450: WHEN fnd_api.g_exc_error THEN
6451: x_return_status := fnd_api.g_ret_sts_error;
6452: fnd_msg_pub.count_and_get
6453: ( p_count => x_msg_count,
6454: p_data => x_msg_data
6455: );

Line 6457: WHEN fnd_api.g_exc_unexpected_error THEN

6453: ( p_count => x_msg_count,
6454: p_data => x_msg_data
6455: );
6456:
6457: WHEN fnd_api.g_exc_unexpected_error THEN
6458: x_return_status := fnd_api.g_ret_sts_unexp_error ;
6459: fnd_msg_pub.count_and_get
6460: ( p_count => x_msg_count,
6461: p_data => x_msg_data

Line 6458: x_return_status := fnd_api.g_ret_sts_unexp_error ;

6454: p_data => x_msg_data
6455: );
6456:
6457: WHEN fnd_api.g_exc_unexpected_error THEN
6458: x_return_status := fnd_api.g_ret_sts_unexp_error ;
6459: fnd_msg_pub.count_and_get
6460: ( p_count => x_msg_count,
6461: p_data => x_msg_data
6462: );

Line 6465: x_return_status := fnd_api.g_ret_sts_error;

6461: p_data => x_msg_data
6462: );
6463:
6464: WHEN NO_DATA_FOUND THEN
6465: x_return_status := fnd_api.g_ret_sts_error;
6466:
6467: WHEN OTHERS THEN
6468: x_return_status := fnd_api.g_ret_sts_unexp_error;
6469: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)

Line 6468: x_return_status := fnd_api.g_ret_sts_unexp_error;

6464: WHEN NO_DATA_FOUND THEN
6465: x_return_status := fnd_api.g_ret_sts_error;
6466:
6467: WHEN OTHERS THEN
6468: x_return_status := fnd_api.g_ret_sts_unexp_error;
6469: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
6470: THEN
6471: fnd_msg_pub.add_exc_msg
6472: ( 'inv_loc_wms_utils'

Line 6523: x_return_status := FND_API.G_RET_STS_SUCCESS;

6519: l_quantity NUMBER;
6520:
6521: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
6522: BEGIN
6523: x_return_status := FND_API.G_RET_STS_SUCCESS;
6524:
6525: SELECT primary_uom_code
6526: ,weight_uom_code
6527: ,unit_weight

Line 6586: RAISE fnd_api.g_exc_error;

6582: ELSE
6583: l_item_unit_weight := l_item_unit_weight;
6584: END IF;
6585: IF l_item_unit_weight = -99999 THEN
6586: RAISE fnd_api.g_exc_error;
6587: END IF;
6588: END IF;
6589:
6590: IF l_item_volume_uom_code is not null AND

Line 6607: RAISE fnd_api.g_exc_error;

6603: ELSE
6604: l_item_unit_volume := l_item_unit_volume;
6605: END IF;
6606: IF l_item_unit_volume = -99999 THEN
6607: RAISE fnd_api.g_exc_error;
6608: END IF;
6609: END IF;
6610: IF p_container_item ='Y' THEN
6611:

Line 6645: RAISE fnd_api.g_exc_error;

6641: l_quantity := p_quantity ;
6642: END IF;
6643:
6644: IF l_quantity = -99999 THEN
6645: RAISE fnd_api.g_exc_error;
6646: END IF;
6647: IF (l_debug = 1) THEN
6648: INV_TRX_UTIL_PUB.TRACE('The value of l_quantity is '||to_char(l_quantity),'UPD_LPN_LOC-ITEM_ATTRIBUTES',4);
6649: END IF;

Line 6681: RAISE fnd_api.g_exc_error;

6677: from_name => null,
6678: to_name => null
6679: );
6680: IF l_item_xacted_weight= -99999 THEN
6681: RAISE fnd_api.g_exc_error;
6682: END IF;
6683: END IF;
6684: END IF;
6685:

Line 6712: RAISE fnd_api.g_exc_error;

6708: to_name => null
6709: );
6710: END IF;
6711: IF l_item_xacted_volume= -99999 THEN
6712: RAISE fnd_api.g_exc_error;
6713: END IF;
6714: END IF;
6715:
6716: x_item_unit_weight := nvl(l_item_unit_weight,0);

Line 6729: WHEN fnd_api.g_exc_error THEN

6725: END IF;
6726:
6727: END IF; /* End of p_container_item =Y */
6728: EXCEPTION
6729: WHEN fnd_api.g_exc_error THEN
6730: x_return_status := fnd_api.g_ret_sts_error;
6731: fnd_msg_pub.count_and_get
6732: ( p_count => x_msg_count,
6733: p_data => x_msg_data

Line 6730: x_return_status := fnd_api.g_ret_sts_error;

6726:
6727: END IF; /* End of p_container_item =Y */
6728: EXCEPTION
6729: WHEN fnd_api.g_exc_error THEN
6730: x_return_status := fnd_api.g_ret_sts_error;
6731: fnd_msg_pub.count_and_get
6732: ( p_count => x_msg_count,
6733: p_data => x_msg_data
6734: );

Line 6736: WHEN fnd_api.g_exc_unexpected_error THEN

6732: ( p_count => x_msg_count,
6733: p_data => x_msg_data
6734: );
6735:
6736: WHEN fnd_api.g_exc_unexpected_error THEN
6737: x_return_status := fnd_api.g_ret_sts_unexp_error ;
6738: fnd_msg_pub.count_and_get
6739: ( p_count => x_msg_count,
6740: p_data => x_msg_data

Line 6737: x_return_status := fnd_api.g_ret_sts_unexp_error ;

6733: p_data => x_msg_data
6734: );
6735:
6736: WHEN fnd_api.g_exc_unexpected_error THEN
6737: x_return_status := fnd_api.g_ret_sts_unexp_error ;
6738: fnd_msg_pub.count_and_get
6739: ( p_count => x_msg_count,
6740: p_data => x_msg_data
6741: );

Line 6744: x_return_status := fnd_api.g_ret_sts_error;

6740: p_data => x_msg_data
6741: );
6742:
6743: WHEN NO_DATA_FOUND THEN
6744: x_return_status := fnd_api.g_ret_sts_error;
6745:
6746: WHEN OTHERS THEN
6747: x_return_status := fnd_api.g_ret_sts_unexp_error;
6748: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)

Line 6747: x_return_status := fnd_api.g_ret_sts_unexp_error;

6743: WHEN NO_DATA_FOUND THEN
6744: x_return_status := fnd_api.g_ret_sts_error;
6745:
6746: WHEN OTHERS THEN
6747: x_return_status := fnd_api.g_ret_sts_unexp_error;
6748: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
6749: THEN
6750: fnd_msg_pub.add_exc_msg
6751: ( 'inv_loc_wms_utils'

Line 6780: x_return_status := fnd_api.g_ret_sts_success ;

6776: l_msg_data varchar2(1000);
6777: l_msg_count number;
6778: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
6779: BEGIN
6780: x_return_status := fnd_api.g_ret_sts_success ;
6781:
6782: INV_LOC_WMS_UTILS.LOC_EMPTY_MIXED_FLAG (
6783: X_RETURN_STATUS => l_return_status
6784: , X_MSG_COUNT => l_MSG_COUNT

Line 6794: if l_return_status <> fnd_api.g_ret_sts_success THEN

6790: , P_TRANSFER_ORGANIZATION => p_transfer_organization
6791: , P_TRANSFER_LOCATION_ID => p_transfer_location_id
6792: , P_SOURCE => null);
6793:
6794: if l_return_status <> fnd_api.g_ret_sts_success THEN
6795: IF l_return_status = fnd_api.g_ret_sts_error then
6796: raise fnd_api.g_exc_error;
6797: ELSE
6798: RAISE fnd_api.g_exc_unexpected_error;

Line 6795: IF l_return_status = fnd_api.g_ret_sts_error then

6791: , P_TRANSFER_LOCATION_ID => p_transfer_location_id
6792: , P_SOURCE => null);
6793:
6794: if l_return_status <> fnd_api.g_ret_sts_success THEN
6795: IF l_return_status = fnd_api.g_ret_sts_error then
6796: raise fnd_api.g_exc_error;
6797: ELSE
6798: RAISE fnd_api.g_exc_unexpected_error;
6799: END IF;

Line 6796: raise fnd_api.g_exc_error;

6792: , P_SOURCE => null);
6793:
6794: if l_return_status <> fnd_api.g_ret_sts_success THEN
6795: IF l_return_status = fnd_api.g_ret_sts_error then
6796: raise fnd_api.g_exc_error;
6797: ELSE
6798: RAISE fnd_api.g_exc_unexpected_error;
6799: END IF;
6800: end if;

Line 6798: RAISE fnd_api.g_exc_unexpected_error;

6794: if l_return_status <> fnd_api.g_ret_sts_success THEN
6795: IF l_return_status = fnd_api.g_ret_sts_error then
6796: raise fnd_api.g_exc_error;
6797: ELSE
6798: RAISE fnd_api.g_exc_unexpected_error;
6799: END IF;
6800: end if;
6801:
6802: commit;

Line 6804: WHEN fnd_api.g_exc_error THEN

6800: end if;
6801:
6802: commit;
6803: EXCEPTION
6804: WHEN fnd_api.g_exc_error THEN
6805: x_return_status := fnd_api.g_ret_sts_error;
6806: fnd_msg_pub.count_and_get
6807: ( p_count => x_msg_count,
6808: p_data => x_msg_data

Line 6805: x_return_status := fnd_api.g_ret_sts_error;

6801:
6802: commit;
6803: EXCEPTION
6804: WHEN fnd_api.g_exc_error THEN
6805: x_return_status := fnd_api.g_ret_sts_error;
6806: fnd_msg_pub.count_and_get
6807: ( p_count => x_msg_count,
6808: p_data => x_msg_data
6809: );

Line 6811: WHEN fnd_api.g_exc_unexpected_error THEN

6807: ( p_count => x_msg_count,
6808: p_data => x_msg_data
6809: );
6810:
6811: WHEN fnd_api.g_exc_unexpected_error THEN
6812: x_return_status := fnd_api.g_ret_sts_unexp_error ;
6813: fnd_msg_pub.count_and_get
6814: ( p_count => x_msg_count,
6815: p_data => x_msg_data

Line 6812: x_return_status := fnd_api.g_ret_sts_unexp_error ;

6808: p_data => x_msg_data
6809: );
6810:
6811: WHEN fnd_api.g_exc_unexpected_error THEN
6812: x_return_status := fnd_api.g_ret_sts_unexp_error ;
6813: fnd_msg_pub.count_and_get
6814: ( p_count => x_msg_count,
6815: p_data => x_msg_data
6816: );

Line 6819: x_return_status := fnd_api.g_ret_sts_error;

6815: p_data => x_msg_data
6816: );
6817:
6818: WHEN NO_DATA_FOUND THEN
6819: x_return_status := fnd_api.g_ret_sts_error;
6820:
6821: WHEN OTHERS THEN
6822: x_return_status := fnd_api.g_ret_sts_unexp_error;
6823: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)

Line 6822: x_return_status := fnd_api.g_ret_sts_unexp_error;

6818: WHEN NO_DATA_FOUND THEN
6819: x_return_status := fnd_api.g_ret_sts_error;
6820:
6821: WHEN OTHERS THEN
6822: x_return_status := fnd_api.g_ret_sts_unexp_error;
6823: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
6824: THEN
6825: fnd_msg_pub.add_exc_msg
6826: ( 'inv_loc_wms_utils'

Line 6867: x_return_status := FND_API.G_RET_STS_SUCCESS;

6863:
6864: -- Fixed bug 2342723, remove the savepoint
6865: -- savepoint loc_empty;
6866:
6867: x_return_status := FND_API.G_RET_STS_SUCCESS;
6868:
6869: SELECT physical_location_id ,
6870: inventory_location_id
6871: INTO l_physical_locator_id,

Line 6922: IF X_RETURN_STATUS =fnd_api.g_ret_sts_error THEN

6918: ,P_ORG_ID => P_ORGANIZATION_ID
6919: ,P_INVENTORY_ITEM_ID => P_INVENTORY_ITEM_ID
6920: ) ;
6921:
6922: IF X_RETURN_STATUS =fnd_api.g_ret_sts_error THEN
6923: IF (l_debug = 1) THEN
6924: INV_TRX_UTIL_PUB.TRACE('Failed for Receipt transaction with status -E ', 'LOC_EMPTY_MIXED_FLAG',9);
6925: END IF;
6926: RAISE fnd_api.g_exc_error;

Line 6926: RAISE fnd_api.g_exc_error;

6922: IF X_RETURN_STATUS =fnd_api.g_ret_sts_error THEN
6923: IF (l_debug = 1) THEN
6924: INV_TRX_UTIL_PUB.TRACE('Failed for Receipt transaction with status -E ', 'LOC_EMPTY_MIXED_FLAG',9);
6925: END IF;
6926: RAISE fnd_api.g_exc_error;
6927: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN
6928: IF (l_debug = 1) THEN
6929: INV_TRX_UTIL_PUB.TRACE('Failed for Receipt transaction with status -U ', 'LOC_EMPTY_MIXED_FLAG',9);
6930: END IF;

Line 6927: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN

6923: IF (l_debug = 1) THEN
6924: INV_TRX_UTIL_PUB.TRACE('Failed for Receipt transaction with status -E ', 'LOC_EMPTY_MIXED_FLAG',9);
6925: END IF;
6926: RAISE fnd_api.g_exc_error;
6927: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN
6928: IF (l_debug = 1) THEN
6929: INV_TRX_UTIL_PUB.TRACE('Failed for Receipt transaction with status -U ', 'LOC_EMPTY_MIXED_FLAG',9);
6930: END IF;
6931: RAISE fnd_api.g_exc_unexpected_error;

Line 6931: RAISE fnd_api.g_exc_unexpected_error;

6927: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN
6928: IF (l_debug = 1) THEN
6929: INV_TRX_UTIL_PUB.TRACE('Failed for Receipt transaction with status -U ', 'LOC_EMPTY_MIXED_FLAG',9);
6930: END IF;
6931: RAISE fnd_api.g_exc_unexpected_error;
6932: END IF;
6933:
6934: ELSIF P_TRANSACTION_ACTION_ID in (1,21,32,34) /* Issue */ THEN
6935: IF (l_debug = 1) THEN

Line 6950: IF X_RETURN_STATUS =fnd_api.g_ret_sts_error THEN

6946: ,P_LOCATOR_ID => l_inventory_location_id
6947: ,P_INVENTORY_ITEM_ID=> P_INVENTORY_ITEM_ID
6948: ,P_SOURCE =>p_source
6949: ) ;
6950: IF X_RETURN_STATUS =fnd_api.g_ret_sts_error THEN
6951: IF (l_debug = 1) THEN
6952: INV_TRX_UTIL_PUB.TRACE('Failed for Issue transaction with status -E ', 'LOC_EMPTY_MIXED_FLAG',9);
6953: END IF;
6954: RAISE fnd_api.g_exc_error;

Line 6954: RAISE fnd_api.g_exc_error;

6950: IF X_RETURN_STATUS =fnd_api.g_ret_sts_error THEN
6951: IF (l_debug = 1) THEN
6952: INV_TRX_UTIL_PUB.TRACE('Failed for Issue transaction with status -E ', 'LOC_EMPTY_MIXED_FLAG',9);
6953: END IF;
6954: RAISE fnd_api.g_exc_error;
6955: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN
6956: IF (l_debug = 1) THEN
6957: INV_TRX_UTIL_PUB.TRACE('Failed for Issue transaction with status - U', 'LOC_EMPTY_MIXED_FLAG',9);
6958: END IF;

Line 6955: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN

6951: IF (l_debug = 1) THEN
6952: INV_TRX_UTIL_PUB.TRACE('Failed for Issue transaction with status -E ', 'LOC_EMPTY_MIXED_FLAG',9);
6953: END IF;
6954: RAISE fnd_api.g_exc_error;
6955: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN
6956: IF (l_debug = 1) THEN
6957: INV_TRX_UTIL_PUB.TRACE('Failed for Issue transaction with status - U', 'LOC_EMPTY_MIXED_FLAG',9);
6958: END IF;
6959: RAISE fnd_api.g_exc_unexpected_error;

Line 6959: RAISE fnd_api.g_exc_unexpected_error;

6955: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN
6956: IF (l_debug = 1) THEN
6957: INV_TRX_UTIL_PUB.TRACE('Failed for Issue transaction with status - U', 'LOC_EMPTY_MIXED_FLAG',9);
6958: END IF;
6959: RAISE fnd_api.g_exc_unexpected_error;
6960: END IF;
6961: ELSIF p_transaction_action_id in(2,3,28) /* TRANSFER */ THEN
6962:
6963: IF (l_debug = 1) THEN

Line 7014: IF X_RETURN_STATUS =fnd_api.g_ret_sts_error THEN

7010: ,P_LOCATOR_ID => l_des_inventory_location_id
7011: ,P_ORG_ID => P_TRANSFER_ORGANIZATION
7012: ,P_INVENTORY_ITEM_ID => P_INVENTORY_ITEM_ID
7013: ) ;
7014: IF X_RETURN_STATUS =fnd_api.g_ret_sts_error THEN
7015: IF (l_debug = 1) THEN
7016: INV_TRX_UTIL_PUB.TRACE('Failed for Receipt transaction with status -E ', 'LOC_EMPTY_MIXED_FLAG',9);
7017: END IF;
7018: RAISE fnd_api.g_exc_error;

Line 7018: RAISE fnd_api.g_exc_error;

7014: IF X_RETURN_STATUS =fnd_api.g_ret_sts_error THEN
7015: IF (l_debug = 1) THEN
7016: INV_TRX_UTIL_PUB.TRACE('Failed for Receipt transaction with status -E ', 'LOC_EMPTY_MIXED_FLAG',9);
7017: END IF;
7018: RAISE fnd_api.g_exc_error;
7019: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN
7020: IF (l_debug = 1) THEN
7021: INV_TRX_UTIL_PUB.TRACE('Failed for Receipt transaction with status -U ', 'LOC_EMPTY_MIXED_FLAG',9);
7022: END IF;

Line 7019: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN

7015: IF (l_debug = 1) THEN
7016: INV_TRX_UTIL_PUB.TRACE('Failed for Receipt transaction with status -E ', 'LOC_EMPTY_MIXED_FLAG',9);
7017: END IF;
7018: RAISE fnd_api.g_exc_error;
7019: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN
7020: IF (l_debug = 1) THEN
7021: INV_TRX_UTIL_PUB.TRACE('Failed for Receipt transaction with status -U ', 'LOC_EMPTY_MIXED_FLAG',9);
7022: END IF;
7023: RAISE fnd_api.g_exc_unexpected_error;

Line 7023: RAISE fnd_api.g_exc_unexpected_error;

7019: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN
7020: IF (l_debug = 1) THEN
7021: INV_TRX_UTIL_PUB.TRACE('Failed for Receipt transaction with status -U ', 'LOC_EMPTY_MIXED_FLAG',9);
7022: END IF;
7023: RAISE fnd_api.g_exc_unexpected_error;
7024: END IF;
7025:
7026: IF (l_debug = 1) THEN
7027: INV_TRX_UTIL_PUB.TRACE('Before Updating destination locator ', 'LOC_EMPTY_MIXED_FLAG',10);

Line 7060: IF X_RETURN_STATUS =fnd_api.g_ret_sts_error THEN

7056: ,P_LOCATOR_ID => l_inventory_location_id
7057: ,P_INVENTORY_ITEM_ID=> P_INVENTORY_ITEM_ID
7058: ,P_SOURCE =>p_source
7059: ) ;
7060: IF X_RETURN_STATUS =fnd_api.g_ret_sts_error THEN
7061: IF (l_debug = 1) THEN
7062: INV_TRX_UTIL_PUB.TRACE('Failed for Issue transaction with status -E ', 'LOC_EMPTY_MIXED_FLAG',9);
7063: END IF;
7064: RAISE fnd_api.g_exc_error;

Line 7064: RAISE fnd_api.g_exc_error;

7060: IF X_RETURN_STATUS =fnd_api.g_ret_sts_error THEN
7061: IF (l_debug = 1) THEN
7062: INV_TRX_UTIL_PUB.TRACE('Failed for Issue transaction with status -E ', 'LOC_EMPTY_MIXED_FLAG',9);
7063: END IF;
7064: RAISE fnd_api.g_exc_error;
7065: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN
7066: IF (l_debug = 1) THEN
7067: INV_TRX_UTIL_PUB.TRACE('Failed for Issue transaction with status - U', 'LOC_EMPTY_MIXED_FLAG',9);
7068: END IF;

Line 7065: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN

7061: IF (l_debug = 1) THEN
7062: INV_TRX_UTIL_PUB.TRACE('Failed for Issue transaction with status -E ', 'LOC_EMPTY_MIXED_FLAG',9);
7063: END IF;
7064: RAISE fnd_api.g_exc_error;
7065: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN
7066: IF (l_debug = 1) THEN
7067: INV_TRX_UTIL_PUB.TRACE('Failed for Issue transaction with status - U', 'LOC_EMPTY_MIXED_FLAG',9);
7068: END IF;
7069: RAISE fnd_api.g_exc_unexpected_error;

Line 7069: RAISE fnd_api.g_exc_unexpected_error;

7065: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN
7066: IF (l_debug = 1) THEN
7067: INV_TRX_UTIL_PUB.TRACE('Failed for Issue transaction with status - U', 'LOC_EMPTY_MIXED_FLAG',9);
7068: END IF;
7069: RAISE fnd_api.g_exc_unexpected_error;
7070: END IF;
7071: END IF; /* End if for the transaction_action_id */
7072:
7073: IF (l_debug = 1) THEN

Line 7094: WHEN fnd_api.g_exc_error THEN

7090: IF (l_debug = 1) THEN
7091: INV_TRX_UTIL_PUB.TRACE('End of Procedure LOC_EMPTY_MIXED_FLAG ', 'LOC_EMPTY_MIXED_FLAG',10);
7092: END IF;
7093: EXCEPTION
7094: WHEN fnd_api.g_exc_error THEN
7095: x_return_status := fnd_api.g_ret_sts_error;
7096: --Fixed bug 2342723, do not rollback to savepoint
7097: --ROLLBACK TO loc_empty;
7098: ROLLBACK;

Line 7095: x_return_status := fnd_api.g_ret_sts_error;

7091: INV_TRX_UTIL_PUB.TRACE('End of Procedure LOC_EMPTY_MIXED_FLAG ', 'LOC_EMPTY_MIXED_FLAG',10);
7092: END IF;
7093: EXCEPTION
7094: WHEN fnd_api.g_exc_error THEN
7095: x_return_status := fnd_api.g_ret_sts_error;
7096: --Fixed bug 2342723, do not rollback to savepoint
7097: --ROLLBACK TO loc_empty;
7098: ROLLBACK;
7099: fnd_msg_pub.count_and_get

Line 7103: WHEN fnd_api.g_exc_unexpected_error THEN

7099: fnd_msg_pub.count_and_get
7100: ( p_count => x_msg_count,
7101: p_data => x_msg_data
7102: );
7103: WHEN fnd_api.g_exc_unexpected_error THEN
7104: x_return_status := fnd_api.g_ret_sts_unexp_error ;
7105: --ROLLBACK TO loc_empty;
7106: ROLLBACK;
7107: fnd_msg_pub.count_and_get

Line 7104: x_return_status := fnd_api.g_ret_sts_unexp_error ;

7100: ( p_count => x_msg_count,
7101: p_data => x_msg_data
7102: );
7103: WHEN fnd_api.g_exc_unexpected_error THEN
7104: x_return_status := fnd_api.g_ret_sts_unexp_error ;
7105: --ROLLBACK TO loc_empty;
7106: ROLLBACK;
7107: fnd_msg_pub.count_and_get
7108: ( p_count => x_msg_count,

Line 7112: x_return_status := fnd_api.g_ret_sts_error;

7108: ( p_count => x_msg_count,
7109: p_data => x_msg_data
7110: );
7111: WHEN NO_DATA_FOUND THEN
7112: x_return_status := fnd_api.g_ret_sts_error;
7113: --ROLLBACK TO loc_empty;
7114: ROLLBACK;
7115: WHEN OTHERS THEN
7116: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 7116: x_return_status := fnd_api.g_ret_sts_unexp_error;

7112: x_return_status := fnd_api.g_ret_sts_error;
7113: --ROLLBACK TO loc_empty;
7114: ROLLBACK;
7115: WHEN OTHERS THEN
7116: x_return_status := fnd_api.g_ret_sts_unexp_error;
7117: --ROLLBACK TO loc_empty;
7118: ROLLBACK;
7119: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
7120: fnd_msg_pub.add_exc_msg

Line 7167: x_return_status := FND_API.G_RET_STS_SUCCESS;

7163: IF (l_debug = 1) THEN
7164: INV_TRX_UTIL_PUB.TRACE('In Procedure inv_loc_issues ','inv_loc_issues',10);
7165: END IF;
7166:
7167: x_return_status := FND_API.G_RET_STS_SUCCESS;
7168:
7169: IF P_SOURCE IS NULL THEN
7170:
7171: IF (l_debug = 1) THEN

Line 7283: x_return_status := fnd_api.g_ret_sts_unexp_error;

7279: END;
7280: END IF; /* FOR P_SOURCE IS NULL*/
7281: EXCEPTION
7282: WHEN OTHERS THEN
7283: x_return_status := fnd_api.g_ret_sts_unexp_error;
7284: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
7285: fnd_msg_pub.add_exc_msg
7286: ( 'inv_loc_wms_utils'
7287: , 'inv_loc_issues'

Line 7311: x_return_status := FND_API.G_RET_STS_SUCCESS;

7307: l_chk_flag number;
7308: l_subinventory_code varchar2(30); --Added variable for 3237709
7309: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
7310: BEGIN
7311: x_return_status := FND_API.G_RET_STS_SUCCESS;
7312:
7313: IF (l_debug = 1) THEN
7314: INV_TRX_UTIL_PUB.TRACE('In Procedure inv_loc_receipt ','receipts',10);
7315: END IF;

Line 7380: x_return_status := fnd_api.g_ret_sts_unexp_error;

7376: x_item_id := P_INVENTORY_ITEM_ID;
7377: END;
7378: EXCEPTION
7379: WHEN OTHERS THEN
7380: x_return_status := fnd_api.g_ret_sts_unexp_error;
7381:
7382: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
7383: fnd_msg_pub.add_exc_msg
7384: ( 'inv_loc_wms_utils'

Line 7453: x_return_status := fnd_api.g_ret_sts_success;

7449: l_msg_data varchar2(1000);
7450: l_msg_count number;
7451: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
7452: BEGIN
7453: x_return_status := fnd_api.g_ret_sts_success;
7454: --Fixed bug 2342723, removed savepoint
7455: -- bug 3511690 retained the savepoint
7456: savepoint lpn_loc_mmtt_upd;
7457: IF p_mixed_flag IS NOT NULL THEN

Line 7484: IF X_RETURN_STATUS =fnd_api.g_ret_sts_error THEN

7480: p_transfer_lpn_id => l_mmtt_cur_mixed_flg.transfer_lpn_id,
7481: p_content_lpn_id => l_mmtt_cur_mixed_flg.content_lpn_id,
7482: p_quantity => l_mmtt_cur_mixed_flg.primary_quantity
7483: );
7484: IF X_RETURN_STATUS =fnd_api.g_ret_sts_error THEN
7485: IF (l_debug = 1) THEN
7486: INV_TRX_UTIL_PUB.TRACE('Loc cpty calc -Transfer case- failed with status E','LPN_LOC_CLEANUP_MMTT',10);
7487: END IF;
7488: RAISE fnd_api.g_exc_error;

Line 7488: RAISE fnd_api.g_exc_error;

7484: IF X_RETURN_STATUS =fnd_api.g_ret_sts_error THEN
7485: IF (l_debug = 1) THEN
7486: INV_TRX_UTIL_PUB.TRACE('Loc cpty calc -Transfer case- failed with status E','LPN_LOC_CLEANUP_MMTT',10);
7487: END IF;
7488: RAISE fnd_api.g_exc_error;
7489: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN
7490: IF (l_debug = 1) THEN
7491: INV_TRX_UTIL_PUB.TRACE('Loc cpty calc-Transfer case- failed with status U','LPN_LOC_CLEANUP_MMTT',10);
7492: END IF;

Line 7489: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN

7485: IF (l_debug = 1) THEN
7486: INV_TRX_UTIL_PUB.TRACE('Loc cpty calc -Transfer case- failed with status E','LPN_LOC_CLEANUP_MMTT',10);
7487: END IF;
7488: RAISE fnd_api.g_exc_error;
7489: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN
7490: IF (l_debug = 1) THEN
7491: INV_TRX_UTIL_PUB.TRACE('Loc cpty calc-Transfer case- failed with status U','LPN_LOC_CLEANUP_MMTT',10);
7492: END IF;
7493: RAISE fnd_api.g_exc_unexpected_error;

Line 7493: RAISE fnd_api.g_exc_unexpected_error;

7489: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN
7490: IF (l_debug = 1) THEN
7491: INV_TRX_UTIL_PUB.TRACE('Loc cpty calc-Transfer case- failed with status U','LPN_LOC_CLEANUP_MMTT',10);
7492: END IF;
7493: RAISE fnd_api.g_exc_unexpected_error;
7494: END IF;
7495:
7496: INV_LOC_WMS_UTILS.LOC_EMPTY_MIXED_FLAG (
7497: X_RETURN_STATUS => l_return_status

Line 7508: IF X_RETURN_STATUS =fnd_api.g_ret_sts_error THEN

7504: ,P_TRANSFER_ORGANIZATION => l_mmtt_cur_mixed_flg.transfer_organization
7505: ,P_TRANSFER_LOCATION_ID => l_mmtt_cur_mixed_flg.transfer_to_location
7506: ,P_SOURCE => 'CONCURRENT'
7507: );
7508: IF X_RETURN_STATUS =fnd_api.g_ret_sts_error THEN
7509: IF (l_debug = 1) THEN
7510: INV_TRX_UTIL_PUB.TRACE('LOC_EMPTY_MIXED-Transfer Case failed with status E','LPN_LOC_CLEANUP_MMTT',10);
7511: END IF;
7512: RAISE fnd_api.g_exc_error;

Line 7512: RAISE fnd_api.g_exc_error;

7508: IF X_RETURN_STATUS =fnd_api.g_ret_sts_error THEN
7509: IF (l_debug = 1) THEN
7510: INV_TRX_UTIL_PUB.TRACE('LOC_EMPTY_MIXED-Transfer Case failed with status E','LPN_LOC_CLEANUP_MMTT',10);
7511: END IF;
7512: RAISE fnd_api.g_exc_error;
7513: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN
7514: IF (l_debug = 1) THEN
7515: INV_TRX_UTIL_PUB.TRACE('LOC_EMPTY_MIXED-Transfer case failed with status U','LPN_LOC_CLEANUP_MMTT',10);
7516: END IF;

Line 7513: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN

7509: IF (l_debug = 1) THEN
7510: INV_TRX_UTIL_PUB.TRACE('LOC_EMPTY_MIXED-Transfer Case failed with status E','LPN_LOC_CLEANUP_MMTT',10);
7511: END IF;
7512: RAISE fnd_api.g_exc_error;
7513: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN
7514: IF (l_debug = 1) THEN
7515: INV_TRX_UTIL_PUB.TRACE('LOC_EMPTY_MIXED-Transfer case failed with status U','LPN_LOC_CLEANUP_MMTT',10);
7516: END IF;
7517: RAISE fnd_api.g_exc_unexpected_error;

Line 7517: RAISE fnd_api.g_exc_unexpected_error;

7513: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN
7514: IF (l_debug = 1) THEN
7515: INV_TRX_UTIL_PUB.TRACE('LOC_EMPTY_MIXED-Transfer case failed with status U','LPN_LOC_CLEANUP_MMTT',10);
7516: END IF;
7517: RAISE fnd_api.g_exc_unexpected_error;
7518: END IF;
7519:
7520: ELSE /* For transaction_action_id not in (2,3,28) */
7521: INV_LOC_WMS_UTILS.upd_lpn_loc_curr_cpty_nauto(x_return_status => l_return_status,

Line 7535: IF X_RETURN_STATUS =fnd_api.g_ret_sts_error THEN

7531: p_transfer_lpn_id => l_mmtt_cur_mixed_flg.transfer_lpn_id,
7532: p_content_lpn_id => l_mmtt_cur_mixed_flg.content_lpn_id,
7533: p_quantity => l_mmtt_cur_mixed_flg.primary_quantity
7534: );
7535: IF X_RETURN_STATUS =fnd_api.g_ret_sts_error THEN
7536: IF (l_debug = 1) THEN
7537: INV_TRX_UTIL_PUB.TRACE('Loc cpty calc - failed with status E','LPN_LOC_CLEANUP_MMTT',10);
7538: END IF;
7539: RAISE fnd_api.g_exc_error;

Line 7539: RAISE fnd_api.g_exc_error;

7535: IF X_RETURN_STATUS =fnd_api.g_ret_sts_error THEN
7536: IF (l_debug = 1) THEN
7537: INV_TRX_UTIL_PUB.TRACE('Loc cpty calc - failed with status E','LPN_LOC_CLEANUP_MMTT',10);
7538: END IF;
7539: RAISE fnd_api.g_exc_error;
7540: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN
7541: IF (l_debug = 1) THEN
7542: INV_TRX_UTIL_PUB.TRACE('Loc cpty calc - failed with status U','LPN_LOC_CLEANUP_MMTT',10);
7543: END IF;

Line 7540: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN

7536: IF (l_debug = 1) THEN
7537: INV_TRX_UTIL_PUB.TRACE('Loc cpty calc - failed with status E','LPN_LOC_CLEANUP_MMTT',10);
7538: END IF;
7539: RAISE fnd_api.g_exc_error;
7540: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN
7541: IF (l_debug = 1) THEN
7542: INV_TRX_UTIL_PUB.TRACE('Loc cpty calc - failed with status U','LPN_LOC_CLEANUP_MMTT',10);
7543: END IF;
7544: RAISE fnd_api.g_exc_unexpected_error;

Line 7544: RAISE fnd_api.g_exc_unexpected_error;

7540: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN
7541: IF (l_debug = 1) THEN
7542: INV_TRX_UTIL_PUB.TRACE('Loc cpty calc - failed with status U','LPN_LOC_CLEANUP_MMTT',10);
7543: END IF;
7544: RAISE fnd_api.g_exc_unexpected_error;
7545: END IF;
7546:
7547: INV_LOC_WMS_UTILS.LOC_EMPTY_MIXED_FLAG (
7548: X_RETURN_STATUS => l_return_status

Line 7559: IF X_RETURN_STATUS =fnd_api.g_ret_sts_error THEN

7555: ,P_TRANSFER_ORGANIZATION => NULL
7556: ,P_TRANSFER_LOCATION_ID => NULL
7557: ,P_SOURCE => 'CONCURRENT'
7558: );
7559: IF X_RETURN_STATUS =fnd_api.g_ret_sts_error THEN
7560: IF (l_debug = 1) THEN
7561: INV_TRX_UTIL_PUB.TRACE('LOC_EMPTY_MIXED failed with status E','LPN_LOC_CLEANUP_MMTT',10);
7562: END IF;
7563: RAISE fnd_api.g_exc_error;

Line 7563: RAISE fnd_api.g_exc_error;

7559: IF X_RETURN_STATUS =fnd_api.g_ret_sts_error THEN
7560: IF (l_debug = 1) THEN
7561: INV_TRX_UTIL_PUB.TRACE('LOC_EMPTY_MIXED failed with status E','LPN_LOC_CLEANUP_MMTT',10);
7562: END IF;
7563: RAISE fnd_api.g_exc_error;
7564: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN
7565: IF (l_debug = 1) THEN
7566: INV_TRX_UTIL_PUB.TRACE('LOC_EMPTY_MIXED failed with status U','LPN_LOC_CLEANUP_MMTT',10);
7567: END IF;

Line 7564: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN

7560: IF (l_debug = 1) THEN
7561: INV_TRX_UTIL_PUB.TRACE('LOC_EMPTY_MIXED failed with status E','LPN_LOC_CLEANUP_MMTT',10);
7562: END IF;
7563: RAISE fnd_api.g_exc_error;
7564: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN
7565: IF (l_debug = 1) THEN
7566: INV_TRX_UTIL_PUB.TRACE('LOC_EMPTY_MIXED failed with status U','LPN_LOC_CLEANUP_MMTT',10);
7567: END IF;
7568: RAISE fnd_api.g_exc_unexpected_error;

Line 7568: RAISE fnd_api.g_exc_unexpected_error;

7564: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN
7565: IF (l_debug = 1) THEN
7566: INV_TRX_UTIL_PUB.TRACE('LOC_EMPTY_MIXED failed with status U','LPN_LOC_CLEANUP_MMTT',10);
7567: END IF;
7568: RAISE fnd_api.g_exc_unexpected_error;
7569: END IF;
7570:
7571: END IF;
7572: END LOOP;

Line 7601: IF X_RETURN_STATUS =fnd_api.g_ret_sts_error THEN

7597: p_transfer_lpn_id => l_mmtt_cur.transfer_lpn_id,
7598: p_content_lpn_id => l_mmtt_cur.content_lpn_id,
7599: p_quantity => l_mmtt_cur.primary_quantity
7600: );
7601: IF X_RETURN_STATUS =fnd_api.g_ret_sts_error THEN
7602: IF (l_debug = 1) THEN
7603: INV_TRX_UTIL_PUB.TRACE('Loc cpty calc -Transfer case- failed with status E','LPN_LOC_CLEANUP_MMTT',10);
7604: END IF;
7605: RAISE fnd_api.g_exc_error;

Line 7605: RAISE fnd_api.g_exc_error;

7601: IF X_RETURN_STATUS =fnd_api.g_ret_sts_error THEN
7602: IF (l_debug = 1) THEN
7603: INV_TRX_UTIL_PUB.TRACE('Loc cpty calc -Transfer case- failed with status E','LPN_LOC_CLEANUP_MMTT',10);
7604: END IF;
7605: RAISE fnd_api.g_exc_error;
7606: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN
7607: IF (l_debug = 1) THEN
7608: INV_TRX_UTIL_PUB.TRACE('Loc cpty calc -Transfer case- failed with status U','LPN_LOC_CLEANUP_MMTT',10);
7609: END IF;

Line 7606: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN

7602: IF (l_debug = 1) THEN
7603: INV_TRX_UTIL_PUB.TRACE('Loc cpty calc -Transfer case- failed with status E','LPN_LOC_CLEANUP_MMTT',10);
7604: END IF;
7605: RAISE fnd_api.g_exc_error;
7606: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN
7607: IF (l_debug = 1) THEN
7608: INV_TRX_UTIL_PUB.TRACE('Loc cpty calc -Transfer case- failed with status U','LPN_LOC_CLEANUP_MMTT',10);
7609: END IF;
7610: RAISE fnd_api.g_exc_unexpected_error;

Line 7610: RAISE fnd_api.g_exc_unexpected_error;

7606: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN
7607: IF (l_debug = 1) THEN
7608: INV_TRX_UTIL_PUB.TRACE('Loc cpty calc -Transfer case- failed with status U','LPN_LOC_CLEANUP_MMTT',10);
7609: END IF;
7610: RAISE fnd_api.g_exc_unexpected_error;
7611: END IF;
7612:
7613: INV_LOC_WMS_UTILS.LOC_EMPTY_MIXED_FLAG (
7614: X_RETURN_STATUS => l_return_status

Line 7625: IF X_RETURN_STATUS =fnd_api.g_ret_sts_error THEN

7621: ,P_TRANSFER_ORGANIZATION => l_mmtt_cur.transfer_organization
7622: ,P_TRANSFER_LOCATION_ID => l_mmtt_cur.transfer_to_location
7623: ,P_SOURCE => 'CONCURRENT'
7624: );
7625: IF X_RETURN_STATUS =fnd_api.g_ret_sts_error THEN
7626: IF (l_debug = 1) THEN
7627: INV_TRX_UTIL_PUB.TRACE('LOC_EMPTY_MIXED-Transfer Case failed with status E','LPN_LOC_CLEANUP_MMTT',10);
7628: END IF;
7629: RAISE fnd_api.g_exc_error;

Line 7629: RAISE fnd_api.g_exc_error;

7625: IF X_RETURN_STATUS =fnd_api.g_ret_sts_error THEN
7626: IF (l_debug = 1) THEN
7627: INV_TRX_UTIL_PUB.TRACE('LOC_EMPTY_MIXED-Transfer Case failed with status E','LPN_LOC_CLEANUP_MMTT',10);
7628: END IF;
7629: RAISE fnd_api.g_exc_error;
7630: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN
7631: IF (l_debug = 1) THEN
7632: INV_TRX_UTIL_PUB.TRACE('LOC_EMPTY_MIXED-Transfer Case failed with status U','LPN_LOC_CLEANUP_MMTT',10);
7633: END IF;

Line 7630: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN

7626: IF (l_debug = 1) THEN
7627: INV_TRX_UTIL_PUB.TRACE('LOC_EMPTY_MIXED-Transfer Case failed with status E','LPN_LOC_CLEANUP_MMTT',10);
7628: END IF;
7629: RAISE fnd_api.g_exc_error;
7630: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN
7631: IF (l_debug = 1) THEN
7632: INV_TRX_UTIL_PUB.TRACE('LOC_EMPTY_MIXED-Transfer Case failed with status U','LPN_LOC_CLEANUP_MMTT',10);
7633: END IF;
7634: RAISE fnd_api.g_exc_unexpected_error;

Line 7634: RAISE fnd_api.g_exc_unexpected_error;

7630: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN
7631: IF (l_debug = 1) THEN
7632: INV_TRX_UTIL_PUB.TRACE('LOC_EMPTY_MIXED-Transfer Case failed with status U','LPN_LOC_CLEANUP_MMTT',10);
7633: END IF;
7634: RAISE fnd_api.g_exc_unexpected_error;
7635: END IF;
7636:
7637: ELSE /* For transaction_action_id not in (2,3,28) */
7638: INV_LOC_WMS_UTILS.upd_lpn_loc_curr_cpty_nauto(x_return_status => l_return_status,

Line 7652: IF X_RETURN_STATUS =fnd_api.g_ret_sts_error THEN

7648: p_transfer_lpn_id => l_mmtt_cur.transfer_lpn_id,
7649: p_content_lpn_id => l_mmtt_cur.content_lpn_id,
7650: p_quantity => l_mmtt_cur.primary_quantity
7651: );
7652: IF X_RETURN_STATUS =fnd_api.g_ret_sts_error THEN
7653: IF (l_debug = 1) THEN
7654: INV_TRX_UTIL_PUB.TRACE('Loc cpty calc - failed with status E','LPN_LOC_CLEANUP_MMTT',10);
7655: END IF;
7656: RAISE fnd_api.g_exc_error;

Line 7656: RAISE fnd_api.g_exc_error;

7652: IF X_RETURN_STATUS =fnd_api.g_ret_sts_error THEN
7653: IF (l_debug = 1) THEN
7654: INV_TRX_UTIL_PUB.TRACE('Loc cpty calc - failed with status E','LPN_LOC_CLEANUP_MMTT',10);
7655: END IF;
7656: RAISE fnd_api.g_exc_error;
7657: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN
7658: IF (l_debug = 1) THEN
7659: INV_TRX_UTIL_PUB.TRACE('Loc cpty calc - failed with status U','LPN_LOC_CLEANUP_MMTT',10);
7660: END IF;

Line 7657: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN

7653: IF (l_debug = 1) THEN
7654: INV_TRX_UTIL_PUB.TRACE('Loc cpty calc - failed with status E','LPN_LOC_CLEANUP_MMTT',10);
7655: END IF;
7656: RAISE fnd_api.g_exc_error;
7657: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN
7658: IF (l_debug = 1) THEN
7659: INV_TRX_UTIL_PUB.TRACE('Loc cpty calc - failed with status U','LPN_LOC_CLEANUP_MMTT',10);
7660: END IF;
7661: RAISE fnd_api.g_exc_unexpected_error;

Line 7661: RAISE fnd_api.g_exc_unexpected_error;

7657: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN
7658: IF (l_debug = 1) THEN
7659: INV_TRX_UTIL_PUB.TRACE('Loc cpty calc - failed with status U','LPN_LOC_CLEANUP_MMTT',10);
7660: END IF;
7661: RAISE fnd_api.g_exc_unexpected_error;
7662: END IF;
7663:
7664: INV_LOC_WMS_UTILS.LOC_EMPTY_MIXED_FLAG (
7665: X_RETURN_STATUS => l_return_status

Line 7676: IF X_RETURN_STATUS =fnd_api.g_ret_sts_error THEN

7672: ,P_TRANSFER_ORGANIZATION => NULL
7673: ,P_TRANSFER_LOCATION_ID => NULL
7674: ,P_SOURCE => 'CONCURRENT'
7675: );
7676: IF X_RETURN_STATUS =fnd_api.g_ret_sts_error THEN
7677: IF (l_debug = 1) THEN
7678: INV_TRX_UTIL_PUB.TRACE('LOC_EMPTY_MIXED failed with Return status E','LPN_LOC_CLEANUP_MMTT',10);
7679: END IF;
7680: RAISE fnd_api.g_exc_error;

Line 7680: RAISE fnd_api.g_exc_error;

7676: IF X_RETURN_STATUS =fnd_api.g_ret_sts_error THEN
7677: IF (l_debug = 1) THEN
7678: INV_TRX_UTIL_PUB.TRACE('LOC_EMPTY_MIXED failed with Return status E','LPN_LOC_CLEANUP_MMTT',10);
7679: END IF;
7680: RAISE fnd_api.g_exc_error;
7681: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN
7682: RAISE fnd_api.g_exc_unexpected_error;
7683: IF (l_debug = 1) THEN
7684: INV_TRX_UTIL_PUB.TRACE('LOC_EMPTY_MIXED failed with Return status U','LPN_LOC_CLEANUP_MMTT',10);

Line 7681: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN

7677: IF (l_debug = 1) THEN
7678: INV_TRX_UTIL_PUB.TRACE('LOC_EMPTY_MIXED failed with Return status E','LPN_LOC_CLEANUP_MMTT',10);
7679: END IF;
7680: RAISE fnd_api.g_exc_error;
7681: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN
7682: RAISE fnd_api.g_exc_unexpected_error;
7683: IF (l_debug = 1) THEN
7684: INV_TRX_UTIL_PUB.TRACE('LOC_EMPTY_MIXED failed with Return status U','LPN_LOC_CLEANUP_MMTT',10);
7685: END IF;

Line 7682: RAISE fnd_api.g_exc_unexpected_error;

7678: INV_TRX_UTIL_PUB.TRACE('LOC_EMPTY_MIXED failed with Return status E','LPN_LOC_CLEANUP_MMTT',10);
7679: END IF;
7680: RAISE fnd_api.g_exc_error;
7681: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN
7682: RAISE fnd_api.g_exc_unexpected_error;
7683: IF (l_debug = 1) THEN
7684: INV_TRX_UTIL_PUB.TRACE('LOC_EMPTY_MIXED failed with Return status U','LPN_LOC_CLEANUP_MMTT',10);
7685: END IF;
7686: END IF;

Line 7696: WHEN fnd_api.g_exc_error THEN

7692: END IF;
7693: END IF;
7694: EXCEPTION
7695:
7696: WHEN fnd_api.g_exc_error THEN
7697: IF mmtt_cur_mixed_flg%ISOPEN then
7698: close mmtt_cur_mixed_flg;
7699: end if;
7700: IF mmtt_cur%isopen then

Line 7706: x_return_status := fnd_api.g_ret_sts_error;

7702: end if;
7703: --Fixed bug 2342723
7704: rollback to lpn_loc_mmtt_upd;
7705: --rollback;
7706: x_return_status := fnd_api.g_ret_sts_error;
7707: fnd_msg_pub.count_and_get
7708: ( p_count => x_msg_count,
7709: p_data => x_msg_data
7710: );

Line 7712: WHEN fnd_api.g_exc_unexpected_error THEN

7708: ( p_count => x_msg_count,
7709: p_data => x_msg_data
7710: );
7711:
7712: WHEN fnd_api.g_exc_unexpected_error THEN
7713: IF mmtt_cur_mixed_flg%ISOPEN then
7714: close mmtt_cur_mixed_flg;
7715: end if;
7716: IF mmtt_cur%isopen then

Line 7719: x_return_status := fnd_api.g_ret_sts_unexp_error ;

7715: end if;
7716: IF mmtt_cur%isopen then
7717: close mmtt_cur;
7718: end if;
7719: x_return_status := fnd_api.g_ret_sts_unexp_error ;
7720: rollback to lpn_loc_mmtt_upd;
7721: --rollback;
7722: fnd_msg_pub.count_and_get
7723: ( p_count => x_msg_count,

Line 7734: x_return_status := fnd_api.g_ret_sts_error;

7730: end if;
7731: IF mmtt_cur%isopen then
7732: close mmtt_cur;
7733: end if;
7734: x_return_status := fnd_api.g_ret_sts_error;
7735: rollback to lpn_loc_mmtt_upd;
7736: --rollback;
7737:
7738: WHEN OTHERS THEN

Line 7745: x_return_status := fnd_api.g_ret_sts_unexp_error;

7741: end if;
7742: IF mmtt_cur%isopen then
7743: close mmtt_cur;
7744: end if;
7745: x_return_status := fnd_api.g_ret_sts_unexp_error;
7746: rollback to lpn_loc_mmtt_upd;
7747: --rollback;
7748: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
7749: THEN

Line 7848: x_return_status := fnd_api.g_ret_sts_success;

7844: BEGIN
7845: IF (l_debug = 1) THEN
7846: INV_TRX_UTIL_PUB.TRACE('In LPN_LOC_CURRENT_CAPACITY Procedure ','LPN_LOC_CURRENT_CAPACITY',9);
7847: END IF;
7848: x_return_status := fnd_api.g_ret_sts_success;
7849: --Fixed bug 2342723, romoved the savepoint
7850: -- Bug 3511690 savepoint retained
7851: savepoint lpn_loc_cpty_upd;
7852: IF p_mixed_flag IS NOT NULL THEN

Line 7984: WHEN fnd_api.g_exc_error THEN

7980: end loop;
7981: close current_cpty;
7982: END IF;
7983: EXCEPTION
7984: WHEN fnd_api.g_exc_error THEN
7985: IF current_cpty%ISOPEN then
7986: close current_cpty;
7987: end if;
7988: IF curr_cpty_mixed_flg%isopen then

Line 7994: x_return_status := fnd_api.g_ret_sts_error;

7990: end if;
7991: -- Fixed bug 2342723, do not rollback to savepoint
7992: rollback to lpn_loc_cpty_upd;
7993: --rollback;
7994: x_return_status := fnd_api.g_ret_sts_error;
7995: fnd_msg_pub.count_and_get
7996: ( p_count => x_msg_count,
7997: p_data => x_msg_data
7998: );

Line 8000: WHEN fnd_api.g_exc_unexpected_error THEN

7996: ( p_count => x_msg_count,
7997: p_data => x_msg_data
7998: );
7999:
8000: WHEN fnd_api.g_exc_unexpected_error THEN
8001: IF current_cpty%ISOPEN then
8002: close current_cpty;
8003: end if;
8004: IF curr_cpty_mixed_flg%isopen then

Line 8007: x_return_status := fnd_api.g_ret_sts_unexp_error ;

8003: end if;
8004: IF curr_cpty_mixed_flg%isopen then
8005: close curr_cpty_mixed_flg;
8006: end if;
8007: x_return_status := fnd_api.g_ret_sts_unexp_error ;
8008: rollback to lpn_loc_cpty_upd;
8009: --rollback;
8010: fnd_msg_pub.count_and_get
8011: ( p_count => x_msg_count,

Line 8022: x_return_status := fnd_api.g_ret_sts_error;

8018: end if;
8019: IF curr_cpty_mixed_flg%isopen then
8020: close curr_cpty_mixed_flg;
8021: end if;
8022: x_return_status := fnd_api.g_ret_sts_error;
8023: rollback to lpn_loc_cpty_upd;
8024: --rollback;
8025:
8026: WHEN OTHERS THEN

Line 8033: x_return_status := fnd_api.g_ret_sts_unexp_error;

8029: end if;
8030: IF curr_cpty_mixed_flg%isopen then
8031: close curr_cpty_mixed_flg;
8032: end if;
8033: x_return_status := fnd_api.g_ret_sts_unexp_error;
8034: rollback to lpn_loc_cpty_upd;
8035: --rollback;
8036: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
8037: THEN

Line 8066: x_return_status := FND_API.G_RET_STS_SUCCESS;

8062: l_physical_locator_id NUMBER := NULL;
8063: l_locator_id NUMBER;
8064: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
8065: BEGIN
8066: x_return_status := FND_API.G_RET_STS_SUCCESS;
8067:
8068: l_locator_id := p_locator_id;
8069:
8070: IF (l_debug = 1) THEN

Line 8147: x_return_status := fnd_api.g_ret_sts_unexp_error;

8143: AND organization_id = p_org_id;
8144:
8145: EXCEPTION
8146: WHEN OTHERS THEN
8147: x_return_status := fnd_api.g_ret_sts_unexp_error;
8148:
8149: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
8150: fnd_msg_pub.add_exc_msg
8151: ( 'inv_loc_wms_utils'