eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WMS_OP_INBOUND_PVT dependencies on FND_API

Line 103: x_return_status := FND_API.G_RET_STS_SUCCESS;

99: l_msg_data fnd_new_messages.message_text%TYPE;
100:
101:
102: BEGIN
103: x_return_status := FND_API.G_RET_STS_SUCCESS;
104: l_progress := 10;
105:
106:
107: IF (l_debug=1) THEN

Line 124: RAISE FND_API.G_EXC_ERROR;

120: Public API*/
121: IF (l_debug=1) THEN
122: print_debug('Source task Id is null',l_module_name,1);
123: END IF;
124: RAISE FND_API.G_EXC_ERROR;
125: END IF;
126:
127: l_progress:=20;
128:

Line 144: RAISE FND_API.G_EXC_ERROR;

140:
141: IF (l_debug=1) THEN
142: print_debug('Item -Org combnation not found',l_module_name,1);
143: END IF;
144: RAISE FND_API.G_EXC_ERROR;
145:
146: END IF;
147:
148: CLOSE c_item_details;

Line 175: RAISE FND_API.G_EXC_ERROR;

171: fnd_msg_pub.ADD;
172: -- End of Bug 12861439 change
173:
174: /* Throwing exception for this condition as of now as Invalid document record*/
175: RAISE FND_API.G_EXC_ERROR;
176:
177: END IF;
178:
179: CLOSE c_mtlt_rec;

Line 246: ,p_subinventory_code => FND_API.G_MISS_CHAR

242: ,x_msg_count => l_msg_count
243: ,x_new_txn_temp_id => x_source_task_id
244: ,p_transaction_temp_id => p_source_task_id
245: ,p_organization_id => p_document_rec.organization_id
246: ,p_subinventory_code => FND_API.G_MISS_CHAR
247: ,p_locator_id => FND_API.G_MISS_NUM
248: ,p_parent_line_id => p_source_task_id
249: ,p_wms_task_type => l_wms_task_type
250: ,p_operation_plan_id => p_subsequent_op_plan_id

Line 247: ,p_locator_id => FND_API.G_MISS_NUM

243: ,x_new_txn_temp_id => x_source_task_id
244: ,p_transaction_temp_id => p_source_task_id
245: ,p_organization_id => p_document_rec.organization_id
246: ,p_subinventory_code => FND_API.G_MISS_CHAR
247: ,p_locator_id => FND_API.G_MISS_NUM
248: ,p_parent_line_id => p_source_task_id
249: ,p_wms_task_type => l_wms_task_type
250: ,p_operation_plan_id => p_subsequent_op_plan_id
251: );

Line 263: ,p_subinventory_code => FND_API.G_MISS_CHAR

259: ,x_msg_count => l_msg_count
260: ,x_new_txn_temp_id => x_source_task_id
261: ,p_transaction_temp_id => p_source_task_id
262: ,p_organization_id => p_document_rec.organization_id
263: ,p_subinventory_code => FND_API.G_MISS_CHAR
264: ,p_locator_id => FND_API.G_MISS_NUM
265: ,p_parent_line_id => p_source_task_id
266: ,p_wms_task_type => l_wms_task_type
267: );

Line 264: ,p_locator_id => FND_API.G_MISS_NUM

260: ,x_new_txn_temp_id => x_source_task_id
261: ,p_transaction_temp_id => p_source_task_id
262: ,p_organization_id => p_document_rec.organization_id
263: ,p_subinventory_code => FND_API.G_MISS_CHAR
264: ,p_locator_id => FND_API.G_MISS_NUM
265: ,p_parent_line_id => p_source_task_id
266: ,p_wms_task_type => l_wms_task_type
267: );
268:

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

272: IF (l_debug=1) THEN
273: print_debug('Return status is'||l_return_status,l_module_name,9);
274: END IF;
275:
276: IF (l_return_status=fnd_api.g_ret_sts_error) THEN
277: IF (l_debug=1) THEN
278: print_debug('Error obtained while creating child record',l_module_name,9);
279: END IF;
280: RAISE FND_API.G_EXC_ERROR;

Line 280: RAISE FND_API.G_EXC_ERROR;

276: IF (l_return_status=fnd_api.g_ret_sts_error) THEN
277: IF (l_debug=1) THEN
278: print_debug('Error obtained while creating child record',l_module_name,9);
279: END IF;
280: RAISE FND_API.G_EXC_ERROR;
281:
282: ELSIF (l_return_status<>fnd_api.g_ret_sts_success) THEN
283:
284: IF (l_debug=1) THEN

Line 282: ELSIF (l_return_status<>fnd_api.g_ret_sts_success) THEN

278: print_debug('Error obtained while creating child record',l_module_name,9);
279: END IF;
280: RAISE FND_API.G_EXC_ERROR;
281:
282: ELSIF (l_return_status<>fnd_api.g_ret_sts_success) THEN
283:
284: IF (l_debug=1) THEN
285: print_debug('unexpected error while creating child record',l_module_name,9);
286: END IF;

Line 287: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

283:
284: IF (l_debug=1) THEN
285: print_debug('unexpected error while creating child record',l_module_name,9);
286: END IF;
287: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
288:
289: END IF;
290:
291:

Line 297: RAISE FND_API.G_EXC_ERROR;

293: IF (l_debug=1) THEN
294: print_debug('Cheild record could not be created',l_module_name,1);
295:
296: END IF;
297: RAISE FND_API.G_EXC_ERROR;
298: END IF;
299: l_progress:=70;
300:
301: /* If Lot Controllled Item then

Line 420: RAISE FND_API.G_EXC_ERROR;

416: IF (l_insert_lot<>0) THEN
417: IF (l_debug=1) THEN
418: print_debug('Failed to insert lots',l_module_name,1);
419: END IF;
420: RAISE FND_API.G_EXC_ERROR;
421: END IF;
422: END IF;
423:
424: IF p_revert_loc_capacity THEN

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

449: IF (l_debug=1) THEN
450: print_debug('Return status is'||l_return_status,l_module_name,9);
451: END IF;
452:
453: IF (l_return_status<>fnd_api.g_ret_sts_success) THEN
454:
455: IF (l_debug=1) THEN
456: print_debug('Error obtained while reverting locator capacity',l_module_name,9);
457: print_debug('Error msg'||x_msg_data,l_module_name,9);

Line 467: WHEN fnd_api.g_exc_error THEN

463:
464: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
465:
466: EXCEPTION
467: WHEN fnd_api.g_exc_error THEN
468: IF (l_debug=1) THEN
469: print_debug('Error obatined at'||l_progress,l_module_name,1);
470: END IF;
471: x_return_status:=FND_API.G_RET_STS_ERROR;

Line 471: x_return_status:=FND_API.G_RET_STS_ERROR;

467: WHEN fnd_api.g_exc_error THEN
468: IF (l_debug=1) THEN
469: print_debug('Error obatined at'||l_progress,l_module_name,1);
470: END IF;
471: x_return_status:=FND_API.G_RET_STS_ERROR;
472: /*Message or error code to be populated for Operation PLan Instance Id Null*/
473:
474: WHEN OTHERS THEN
475:

Line 476: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

472: /*Message or error code to be populated for Operation PLan Instance Id Null*/
473:
474: WHEN OTHERS THEN
475:
476: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
477: IF (l_debug=1) THEN
478: print_debug('Unexpected Error'||SQLERRM||'at '||l_progress,l_module_name,3);
479: END IF;
480: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 540: x_return_status := FND_API.G_RET_STS_SUCCESS;

536: l_return_status VARCHAR2(1);
537: l_msg_count NUMBER;
538:
539: BEGIN
540: x_return_status := FND_API.G_RET_STS_SUCCESS;
541: l_progress := 10;
542:
543: /*Whenever we update transfer_to_location and transfer_subinventory, we need to aware that we are
544: * dealing with three types of MMTTS:

Line 581: RAISE FND_API.G_EXC_ERROR;

577: IF (l_debug=1) THEN
578: print_debug('Invalid Sub',l_module_name,1);
579: END IF;
580:
581: RAISE FND_API.G_EXC_ERROR;
582: END IF;
583:
584: l_progress:=27;
585:

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

665: IF (l_debug=1) THEN
666: print_debug('Return status is'||l_return_status,l_module_name,9);
667: END IF;
668:
669: IF (l_return_status<>fnd_api.g_ret_sts_success) THEN
670:
671: IF (l_debug=1) THEN
672: print_debug(' error while updating suggested locator capacity',l_module_name,9);
673: END IF;

Line 682: WHEN fnd_api.g_exc_error THEN

678:
679: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
680:
681: EXCEPTION
682: WHEN fnd_api.g_exc_error THEN
683: IF (l_debug=1) THEN
684: print_debug('Error obatined at'||l_progress,l_module_name,1);
685: END IF;
686: x_return_status:=FND_API.G_RET_STS_ERROR;

Line 686: x_return_status:=FND_API.G_RET_STS_ERROR;

682: WHEN fnd_api.g_exc_error THEN
683: IF (l_debug=1) THEN
684: print_debug('Error obatined at'||l_progress,l_module_name,1);
685: END IF;
686: x_return_status:=FND_API.G_RET_STS_ERROR;
687: /*Message or error code to be populated for Operation PLan Instance Id Null*/
688:
689: WHEN OTHERS THEN
690:

Line 691: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

687: /*Message or error code to be populated for Operation PLan Instance Id Null*/
688:
689: WHEN OTHERS THEN
690:
691: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
692: IF (l_debug=1) THEN
693: print_debug('Unexpected Error'||SQLERRM||'at '||l_progress,l_module_name,3);
694: END IF;
695: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 756: x_return_status := FND_API.g_ret_sts_success;

752: END IF;
753:
754: l_progress := 10;
755:
756: x_return_status := FND_API.g_ret_sts_success;
757: SAVEPOINT sp_revert_crossdock;
758:
759: l_progress := 20;
760:

Line 791: IF l_return_status <>FND_API.g_ret_sts_success THEN

787: );
788:
789: l_progress := 50;
790:
791: IF l_return_status <>FND_API.g_ret_sts_success THEN
792: IF (l_debug=1) THEN
793: print_debug('wms_wip_integration.unallocate_material returned with x_return_status = '||l_return_status, l_module_name,1);
794: END IF;
795:

Line 796: RAISE FND_API.G_EXC_ERROR;

792: IF (l_debug=1) THEN
793: print_debug('wms_wip_integration.unallocate_material returned with x_return_status = '||l_return_status, l_module_name,1);
794: END IF;
795:
796: RAISE FND_API.G_EXC_ERROR;
797:
798: END IF;
799:
800: ELSE

Line 835: l_return_status := fnd_api.g_ret_sts_success;

831:
832: l_in_rec.caller := 'WMS_XDOCK_WMSOPIBB';
833: l_in_rec.action_code := 'UPDATE';
834:
835: l_return_status := fnd_api.g_ret_sts_success;
836: WSH_INTERFACE_EXT_GRP.Create_Update_Delivery_Detail
837: ( p_api_version_number => 1.0
838: , p_init_msg_list => fnd_api.g_false
839: , p_commit => fnd_api.g_false

Line 838: , p_init_msg_list => fnd_api.g_false

834:
835: l_return_status := fnd_api.g_ret_sts_success;
836: WSH_INTERFACE_EXT_GRP.Create_Update_Delivery_Detail
837: ( p_api_version_number => 1.0
838: , p_init_msg_list => fnd_api.g_false
839: , p_commit => fnd_api.g_false
840: , x_return_status => l_return_status
841: , x_msg_count => l_msg_count
842: , x_msg_data => l_msg_data

Line 839: , p_commit => fnd_api.g_false

835: l_return_status := fnd_api.g_ret_sts_success;
836: WSH_INTERFACE_EXT_GRP.Create_Update_Delivery_Detail
837: ( p_api_version_number => 1.0
838: , p_init_msg_list => fnd_api.g_false
839: , p_commit => fnd_api.g_false
840: , x_return_status => l_return_status
841: , x_msg_count => l_msg_count
842: , x_msg_data => l_msg_data
843: , p_detail_info_tab => l_detail_info_tab

Line 852: l_return_status := fnd_api.g_ret_sts_success;

848: --Bug 12976135 End Commenting
849:
850: --Bug 12976135 START - Added below code - While reverting Cross dock, Delivery Detail
851: --Should go to 'Backordered'(B) from 'Released to Warehousse'(S). Not to 'Ready to Release'(R)
852: l_return_status := fnd_api.g_ret_sts_success;
853: l_shipping_attr(1).delivery_detail_id := p_backorder_delivery_detail_id;
854: l_shipping_attr(1).action_flag := 'B';--For Backordering
855:
856: print_debug('===Before calling WSH_INTERFACE.Update_Shipping_Attributes===', l_module_name,1);

Line 868: IF l_return_status <> fnd_api.g_ret_sts_success

864: print_debug('===After calling WSH_INTERFACE.Update_Shipping_Attributes. Return Status:'||l_return_status, l_module_name,1);
865:
866: --Bug 12976135 END - Added above code
867:
868: IF l_return_status <> fnd_api.g_ret_sts_success
869: THEN
870: IF (l_debug = 1)
871: THEN
872: print_debug

Line 879: IF x_return_status = fnd_api.g_ret_sts_error

875: , l_module_name, 1
876: );
877: END IF;
878:
879: IF x_return_status = fnd_api.g_ret_sts_error
880: THEN
881: RAISE fnd_api.g_exc_error;
882: ELSE
883: RAISE fnd_api.g_exc_unexpected_error;

Line 881: RAISE fnd_api.g_exc_error;

877: END IF;
878:
879: IF x_return_status = fnd_api.g_ret_sts_error
880: THEN
881: RAISE fnd_api.g_exc_error;
882: ELSE
883: RAISE fnd_api.g_exc_unexpected_error;
884: END IF;
885: ELSE

Line 883: RAISE fnd_api.g_exc_unexpected_error;

879: IF x_return_status = fnd_api.g_ret_sts_error
880: THEN
881: RAISE fnd_api.g_exc_error;
882: ELSE
883: RAISE fnd_api.g_exc_unexpected_error;
884: END IF;
885: ELSE
886: IF (l_debug = 1) THEN
887: print_debug('Successfully updated the WDD record to status ''B'''--Changed the print message 'R' to 'B' for Bug 12976135

Line 906: print_debug('p_init_msg_lst = '||FND_API.g_false, l_module_name,1);

902:
903: IF (l_debug = 1) THEN
904: print_debug('Before calling inv_reservation_pvt.delete_reservation. ', l_module_name,1);
905: print_debug('p_api_version_number = '||l_api_version_number, l_module_name,1);
906: print_debug('p_init_msg_lst = '||FND_API.g_false, l_module_name,1);
907: print_debug('l_rsv_rec.organization_id = '||l_rsv_rec.organization_id, l_module_name,1);
908: print_debug('l_rsv_rec.inventory_item_id = '||l_rsv_rec.inventory_item_id, l_module_name,1);
909: print_debug('l_rsv_rec.demand_source_line_detail = '||l_rsv_rec.demand_source_line_detail, l_module_name,1);
910: print_debug('l_rsv_rec.supply_source_type_id = '||l_rsv_rec.supply_source_type_id, l_module_name,1);

Line 917: , p_init_msg_lst => FND_API.g_false

913: END IF;
914: inv_reservation_pvt.delete_reservation
915: (
916: p_api_version_number=> l_api_version_number
917: , p_init_msg_lst => FND_API.g_false
918: , x_return_status => l_return_status
919: , x_msg_count => l_msg_count
920: , x_msg_data => l_msg_data
921: , p_rsv_rec => l_rsv_rec

Line 932: IF l_return_status <>FND_API.g_ret_sts_success THEN

928: print_debug('x_msg_count = '||l_msg_count, l_module_name,1);
929: print_debug('x_msg_data = '||l_msg_data, l_module_name,1);
930: END IF;
931:
932: IF l_return_status <>FND_API.g_ret_sts_success THEN
933: IF (l_debug=1) THEN
934: print_debug('inv_reservation_pvt.delete_reservation. returned with x_return_status = '||l_return_status, l_module_name,1);
935: END IF;
936: RAISE FND_API.G_EXC_ERROR;

Line 936: RAISE FND_API.G_EXC_ERROR;

932: IF l_return_status <>FND_API.g_ret_sts_success THEN
933: IF (l_debug=1) THEN
934: print_debug('inv_reservation_pvt.delete_reservation. returned with x_return_status = '||l_return_status, l_module_name,1);
935: END IF;
936: RAISE FND_API.G_EXC_ERROR;
937: END IF;
938:
939: l_progress := 80;
940:

Line 951: WHEN fnd_api.g_exc_error THEN

947: print_debug(' x_msg_data = '||x_msg_data, l_module_name,1);
948: END IF;
949: EXCEPTION
950:
951: WHEN fnd_api.g_exc_error THEN
952: IF (l_debug=1) THEN
953: print_debug('fnd_api.g_exc_error. l_progress = '|| l_progress, l_module_name,1);
954: END IF;
955: x_return_status:=FND_API.G_RET_STS_ERROR;

Line 953: print_debug('fnd_api.g_exc_error. l_progress = '|| l_progress, l_module_name,1);

949: EXCEPTION
950:
951: WHEN fnd_api.g_exc_error THEN
952: IF (l_debug=1) THEN
953: print_debug('fnd_api.g_exc_error. l_progress = '|| l_progress, l_module_name,1);
954: END IF;
955: x_return_status:=FND_API.G_RET_STS_ERROR;
956: ROLLBACK TO sp_revert_crossdock;
957:

Line 955: x_return_status:=FND_API.G_RET_STS_ERROR;

951: WHEN fnd_api.g_exc_error THEN
952: IF (l_debug=1) THEN
953: print_debug('fnd_api.g_exc_error. l_progress = '|| l_progress, l_module_name,1);
954: END IF;
955: x_return_status:=FND_API.G_RET_STS_ERROR;
956: ROLLBACK TO sp_revert_crossdock;
957:
958: WHEN fnd_api.g_exc_unexpected_error THEN
959:

Line 958: WHEN fnd_api.g_exc_unexpected_error THEN

954: END IF;
955: x_return_status:=FND_API.G_RET_STS_ERROR;
956: ROLLBACK TO sp_revert_crossdock;
957:
958: WHEN fnd_api.g_exc_unexpected_error THEN
959:
960: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
961: IF (l_debug=1) THEN
962: print_debug('fnd_api.g_exc_unexpected_error. l_progress = '|| l_progress, l_module_name,1);

Line 960: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

956: ROLLBACK TO sp_revert_crossdock;
957:
958: WHEN fnd_api.g_exc_unexpected_error THEN
959:
960: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
961: IF (l_debug=1) THEN
962: print_debug('fnd_api.g_exc_unexpected_error. l_progress = '|| l_progress, l_module_name,1);
963: END IF;
964:

Line 962: print_debug('fnd_api.g_exc_unexpected_error. l_progress = '|| l_progress, l_module_name,1);

958: WHEN fnd_api.g_exc_unexpected_error THEN
959:
960: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
961: IF (l_debug=1) THEN
962: print_debug('fnd_api.g_exc_unexpected_error. l_progress = '|| l_progress, l_module_name,1);
963: END IF;
964:
965: ROLLBACK TO sp_revert_crossdock;
966:

Line 968: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

964:
965: ROLLBACK TO sp_revert_crossdock;
966:
967: WHEN OTHERS THEN
968: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
969: IF (l_debug=1) THEN
970: print_debug('fnd_api.g_exc_unexpected_error. l_progress = '|| l_progress, l_module_name,1);
971: END IF;
972:

Line 970: print_debug('fnd_api.g_exc_unexpected_error. l_progress = '|| l_progress, l_module_name,1);

966:
967: WHEN OTHERS THEN
968: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
969: IF (l_debug=1) THEN
970: print_debug('fnd_api.g_exc_unexpected_error. l_progress = '|| l_progress, l_module_name,1);
971: END IF;
972:
973: ROLLBACK TO sp_revert_crossdock;
974:

Line 1094: x_return_status := FND_API.G_RET_STS_SUCCESS;

1090:
1091: BEGIN
1092:
1093:
1094: x_return_status := FND_API.G_RET_STS_SUCCESS;
1095: l_progress := 10;
1096:
1097: IF (l_debug=1) THEN
1098: print_debug('Entered. ',l_module_name,1);

Line 1114: RAISE FND_API.G_EXC_ERROR;

1110: IF p_source_task_id IS NULL THEN
1111: IF (l_debug=1) THEN
1112: print_debug('Invalid input param. p_source_task_id Cannot be NULL.',l_module_name,4);
1113: END IF;
1114: RAISE FND_API.G_EXC_ERROR;
1115: END IF;
1116:
1117: IF p_operation_type_id IS NULL THEN
1118: IF (l_debug=1) THEN

Line 1121: RAISE FND_API.G_EXC_ERROR;

1117: IF p_operation_type_id IS NULL THEN
1118: IF (l_debug=1) THEN
1119: print_debug('Invalid input param. p_operation_type_id Cannot be NULL.',l_module_name,4);
1120: END IF;
1121: RAISE FND_API.G_EXC_ERROR;
1122: END IF;
1123:
1124: IF p_document_rec.transaction_temp_id IS NULL THEN
1125: IF (l_debug=1) THEN

Line 1128: RAISE FND_API.G_EXC_ERROR;

1124: IF p_document_rec.transaction_temp_id IS NULL THEN
1125: IF (l_debug=1) THEN
1126: print_debug('Invalid input param. p_document_rec Cannot be NULL.',l_module_name,4);
1127: END IF;
1128: RAISE FND_API.G_EXC_ERROR;
1129: END IF;
1130:
1131: IF p_is_last_operation_flag NOT IN ('N', 'Y') THEN
1132: IF (l_debug=1) THEN

Line 1135: RAISE FND_API.G_EXC_ERROR;

1131: IF p_is_last_operation_flag NOT IN ('N', 'Y') THEN
1132: IF (l_debug=1) THEN
1133: print_debug('Invalid input param. p_is_last_operation_flag has to be either Y or N.',l_module_name,4);
1134: END IF;
1135: RAISE FND_API.G_EXC_ERROR;
1136: END IF;
1137:
1138: l_progress := 15;
1139:

Line 1146: RAISE fnd_api.G_EXC_ERROR;

1142: FETCH c_mmtt_data_rec INTO l_mmtt_data_rec;
1143: IF c_mmtt_data_rec%notfound THEN
1144: IF (l_debug=1) THEN
1145: print_debug('Invalid p_source_task_id : '||p_source_task_id,l_module_name,1);
1146: RAISE fnd_api.G_EXC_ERROR;
1147: END IF;
1148: END IF;
1149: CLOSE c_mmtt_data_rec;
1150:

Line 1199: IF l_return_status <>FND_API.g_ret_sts_success THEN

1195: print_debug('l_msg_data => '||l_msg_data,l_module_name,4);
1196: print_debug('l_msg_count => '||l_msg_count,l_module_name,4);
1197: END IF;
1198:
1199: IF l_return_status <>FND_API.g_ret_sts_success THEN
1200: IF (l_debug=1) THEN
1201: print_debug('inv_trx_util_pub.delete_transaction finished with error. l_return_status = ' || l_return_status,l_module_name,4);
1202: END IF;
1203:

Line 1204: RAISE FND_API.G_EXC_ERROR;

1200: IF (l_debug=1) THEN
1201: print_debug('inv_trx_util_pub.delete_transaction finished with error. l_return_status = ' || l_return_status,l_module_name,4);
1202: END IF;
1203:
1204: RAISE FND_API.G_EXC_ERROR;
1205: END IF;
1206:
1207: END IF; -- p_document_rec.parent_line_id IS NOT NULL
1208:

Line 1300: IF l_return_status <>FND_API.g_ret_sts_success THEN

1296: print_debug('l_msg_count => '|| l_msg_count, l_module_name,4);
1297: print_debug('l_msg_data => '|| l_msg_data, l_module_name,4);
1298: END IF;
1299:
1300: IF l_return_status <>FND_API.g_ret_sts_success THEN
1301: IF (l_debug=1) THEN
1302: print_debug('WMS_Cross_Dock_Pvt.complete_crossdock finished with error. l_return_status = ' || l_return_status,l_module_name,4);
1303: END IF;
1304:

Line 1305: RAISE FND_API.G_EXC_ERROR;

1301: IF (l_debug=1) THEN
1302: print_debug('WMS_Cross_Dock_Pvt.complete_crossdock finished with error. l_return_status = ' || l_return_status,l_module_name,4);
1303: END IF;
1304:
1305: RAISE FND_API.G_EXC_ERROR;
1306: END IF;
1307:
1308: -- END IF; -- IF l_mmtt_data_rec.operation_plan_id IS NULL
1309:

Line 1362: , p_init_msg_list => fnd_api.g_false

1358:
1359: -- Calling Workflow
1360: wms_workflow_wrappers.wf_wrapper(
1361: p_api_version => 1.0
1362: , p_init_msg_list => fnd_api.g_false
1363: , p_commit => fnd_api.g_false
1364: , x_return_status => x_return_status
1365: , x_msg_count => x_msg_count
1366: , x_msg_data => x_msg_data

Line 1363: , p_commit => fnd_api.g_false

1359: -- Calling Workflow
1360: wms_workflow_wrappers.wf_wrapper(
1361: p_api_version => 1.0
1362: , p_init_msg_list => fnd_api.g_false
1363: , p_commit => fnd_api.g_false
1364: , x_return_status => x_return_status
1365: , x_msg_count => x_msg_count
1366: , x_msg_data => x_msg_data
1367: , p_org_id => p_document_rec.organization_id

Line 1380: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

1376: IF (l_debug = 1) THEN
1377: print_debug('After Calling WF Wrapper',l_module_name,4);
1378: END IF;
1379:
1380: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1381: IF (l_debug = 1) THEN
1382: print_debug('Error callinf WF wrapper',l_module_name,4);
1383: END IF;
1384:

Line 1387: RAISE fnd_api.g_exc_unexpected_error;

1383: END IF;
1384:
1385: fnd_message.set_name('WMS', 'WMS_WORK_FLOW_FAIL');
1386: fnd_msg_pub.ADD;
1387: RAISE fnd_api.g_exc_unexpected_error;
1388: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
1389: IF (l_debug = 1) THEN
1390: print_debug('Error calling WF wrapper',l_module_name,4);
1391: END IF;

Line 1388: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN

1384:
1385: fnd_message.set_name('WMS', 'WMS_WORK_FLOW_FAIL');
1386: fnd_msg_pub.ADD;
1387: RAISE fnd_api.g_exc_unexpected_error;
1388: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
1389: IF (l_debug = 1) THEN
1390: print_debug('Error calling WF wrapper',l_module_name,4);
1391: END IF;
1392:

Line 1395: RAISE fnd_api.g_exc_error;

1391: END IF;
1392:
1393: fnd_message.set_name('WMS', 'WMS_WORK_FLOW_FAIL');
1394: fnd_msg_pub.ADD;
1395: RAISE fnd_api.g_exc_error;
1396: END IF;
1397: END IF; -- END IF (l_wf > 0)
1398: END IF; -- END IF reason id is not null
1399: END IF; -- END IF inventory sub

Line 1523: IF l_return_status <>FND_API.g_ret_sts_success THEN

1519: print_debug('l_msg_data => '||l_msg_data,l_module_name,4);
1520: print_debug('l_msg_count => '||l_msg_count,l_module_name,4);
1521: END IF;
1522:
1523: IF l_return_status <>FND_API.g_ret_sts_success THEN
1524: IF (l_debug=1) THEN
1525: print_debug('inv_trx_util_pub.delete_transaction finished with error. l_return_status = ' || l_return_status,l_module_name,4);
1526: END IF;
1527:

Line 1528: RAISE FND_API.G_EXC_ERROR;

1524: IF (l_debug=1) THEN
1525: print_debug('inv_trx_util_pub.delete_transaction finished with error. l_return_status = ' || l_return_status,l_module_name,4);
1526: END IF;
1527:
1528: RAISE FND_API.G_EXC_ERROR;
1529: END IF;
1530:
1531: END IF; -- p_document_rec.transaction_action_id = G_ACTION_RECEIPT
1532:

Line 1755: IF l_return_status <>FND_API.g_ret_sts_success THEN

1751: print_debug('l_msg_data => '||l_msg_data,l_module_name,4);
1752: print_debug('l_msg_count => '||l_msg_count,l_module_name,4);
1753: END IF;
1754:
1755: IF l_return_status <>FND_API.g_ret_sts_success THEN
1756: IF (l_debug=1) THEN
1757: print_debug('inv_trx_util_pub.delete_transaction finished with error. l_return_status = ' || l_return_status,l_module_name,4);
1758: END IF;
1759:

Line 1760: RAISE FND_API.G_EXC_ERROR;

1756: IF (l_debug=1) THEN
1757: print_debug('inv_trx_util_pub.delete_transaction finished with error. l_return_status = ' || l_return_status,l_module_name,4);
1758: END IF;
1759:
1760: RAISE FND_API.G_EXC_ERROR;
1761: END IF;
1762:
1763:
1764: ELSE -- p_operation_type_id is not DROP or INSPECT

Line 1769: RAISE FND_API.G_EXC_ERROR;

1765: IF (l_debug=1) THEN
1766: print_debug('Invalid operation type for last step, it can only be DROP or INSPECT. p_operation_type_id = '||p_operation_type_id,l_module_name,4);
1767: END IF;
1768:
1769: RAISE FND_API.G_EXC_ERROR;
1770:
1771: END IF; -- p_operation_type_id = g_op_type_drop
1772:
1773:

Line 1870: l_new_subinventory_code := fnd_api.g_miss_char;

1866:
1867: l_new_txn_action_id := p_document_rec.transaction_action_id;
1868: l_new_txn_source_type_id := p_document_rec.transaction_source_type_ID;
1869: l_new_txn_type_id := p_document_rec.transaction_type_id;
1870: l_new_subinventory_code := fnd_api.g_miss_char;
1871: l_new_locator_id := fnd_api.g_miss_num;
1872: l_new_transfer_to_loc := fnd_api.g_miss_num;
1873: l_new_transfer_to_sub := fnd_api.g_miss_char;
1874:

Line 1871: l_new_locator_id := fnd_api.g_miss_num;

1867: l_new_txn_action_id := p_document_rec.transaction_action_id;
1868: l_new_txn_source_type_id := p_document_rec.transaction_source_type_ID;
1869: l_new_txn_type_id := p_document_rec.transaction_type_id;
1870: l_new_subinventory_code := fnd_api.g_miss_char;
1871: l_new_locator_id := fnd_api.g_miss_num;
1872: l_new_transfer_to_loc := fnd_api.g_miss_num;
1873: l_new_transfer_to_sub := fnd_api.g_miss_char;
1874:
1875: END IF; -- l_dest_subinventory_type IS NULL

Line 1872: l_new_transfer_to_loc := fnd_api.g_miss_num;

1868: l_new_txn_source_type_id := p_document_rec.transaction_source_type_ID;
1869: l_new_txn_type_id := p_document_rec.transaction_type_id;
1870: l_new_subinventory_code := fnd_api.g_miss_char;
1871: l_new_locator_id := fnd_api.g_miss_num;
1872: l_new_transfer_to_loc := fnd_api.g_miss_num;
1873: l_new_transfer_to_sub := fnd_api.g_miss_char;
1874:
1875: END IF; -- l_dest_subinventory_type IS NULL
1876:

Line 1873: l_new_transfer_to_sub := fnd_api.g_miss_char;

1869: l_new_txn_type_id := p_document_rec.transaction_type_id;
1870: l_new_subinventory_code := fnd_api.g_miss_char;
1871: l_new_locator_id := fnd_api.g_miss_num;
1872: l_new_transfer_to_loc := fnd_api.g_miss_num;
1873: l_new_transfer_to_sub := fnd_api.g_miss_char;
1874:
1875: END IF; -- l_dest_subinventory_type IS NULL
1876:
1877:

Line 1915: print_debug('p_transfer_lpn_id => '|| fnd_api.g_miss_num, l_module_name,4);

1911: print_debug('p_txn_action_id => '||l_new_txn_action_id,l_module_name,4);
1912: print_debug('p_txn_source_type_id => '||l_new_txn_source_type_id,l_module_name,4);
1913: print_debug('p_wms_task_type => '||l_new_wms_task_type_id,l_module_name,4);
1914: print_debug('p_lpn_id => '||l_new_lpn_id, l_module_name,4);
1915: print_debug('p_transfer_lpn_id => '|| fnd_api.g_miss_num, l_module_name,4);
1916: print_debug('p_content_lpn_id => '|| fnd_api.g_miss_num, l_module_name,4);
1917:
1918: END IF;
1919:

Line 1916: print_debug('p_content_lpn_id => '|| fnd_api.g_miss_num, l_module_name,4);

1912: print_debug('p_txn_source_type_id => '||l_new_txn_source_type_id,l_module_name,4);
1913: print_debug('p_wms_task_type => '||l_new_wms_task_type_id,l_module_name,4);
1914: print_debug('p_lpn_id => '||l_new_lpn_id, l_module_name,4);
1915: print_debug('p_transfer_lpn_id => '|| fnd_api.g_miss_num, l_module_name,4);
1916: print_debug('p_content_lpn_id => '|| fnd_api.g_miss_num, l_module_name,4);
1917:
1918: END IF;
1919:
1920: l_progress := 260;

Line 1950: ,p_transfer_lpn_id => fnd_api.g_miss_num -- null out transfer_lpn_id

1946: ,p_txn_action_id => l_new_txn_action_id
1947: ,p_txn_source_type_id => l_new_txn_source_type_id
1948: ,p_wms_task_type => l_new_wms_task_type_id
1949: ,p_lpn_id => l_new_lpn_id
1950: ,p_transfer_lpn_id => fnd_api.g_miss_num -- null out transfer_lpn_id
1951: ,p_content_lpn_id => fnd_api.g_miss_num -- null out content_lpn_id
1952: ,p_operation_plan_id => p_subsequent_op_plan_id
1953: ,p_transaction_status => 2 -- Bug 5156015
1954: );

Line 1951: ,p_content_lpn_id => fnd_api.g_miss_num -- null out content_lpn_id

1947: ,p_txn_source_type_id => l_new_txn_source_type_id
1948: ,p_wms_task_type => l_new_wms_task_type_id
1949: ,p_lpn_id => l_new_lpn_id
1950: ,p_transfer_lpn_id => fnd_api.g_miss_num -- null out transfer_lpn_id
1951: ,p_content_lpn_id => fnd_api.g_miss_num -- null out content_lpn_id
1952: ,p_operation_plan_id => p_subsequent_op_plan_id
1953: ,p_transaction_status => 2 -- Bug 5156015
1954: );
1955:

Line 1977: ,p_transfer_lpn_id => fnd_api.g_miss_num -- null out transfer_lpn_id

1973: ,p_txn_action_id => l_new_txn_action_id
1974: ,p_txn_source_type_id => l_new_txn_source_type_id
1975: ,p_wms_task_type => l_new_wms_task_type_id
1976: ,p_lpn_id => l_new_lpn_id
1977: ,p_transfer_lpn_id => fnd_api.g_miss_num -- null out transfer_lpn_id
1978: ,p_content_lpn_id => fnd_api.g_miss_num -- null out content_lpn_id
1979: ,p_transaction_status => 2 -- Bug 5156015
1980: );
1981: END IF;

Line 1978: ,p_content_lpn_id => fnd_api.g_miss_num -- null out content_lpn_id

1974: ,p_txn_source_type_id => l_new_txn_source_type_id
1975: ,p_wms_task_type => l_new_wms_task_type_id
1976: ,p_lpn_id => l_new_lpn_id
1977: ,p_transfer_lpn_id => fnd_api.g_miss_num -- null out transfer_lpn_id
1978: ,p_content_lpn_id => fnd_api.g_miss_num -- null out content_lpn_id
1979: ,p_transaction_status => 2 -- Bug 5156015
1980: );
1981: END IF;
1982:

Line 2001: IF l_return_status <>fnd_api.g_ret_sts_success THEN

1997: set posting_flag = 'N'
1998: where transaction_temp_id = x_source_task_id;
1999: END IF;
2000: /* End 12541422 */
2001: IF l_return_status <>fnd_api.g_ret_sts_success THEN
2002: IF (l_debug=1) THEN
2003: print_debug('Error occured while calling inv_trx_util_pub.copy_insert_line_trx',l_module_name,4);
2004: END IF;
2005: RAISE FND_API.G_EXC_ERROR;

Line 2005: RAISE FND_API.G_EXC_ERROR;

2001: IF l_return_status <>fnd_api.g_ret_sts_success THEN
2002: IF (l_debug=1) THEN
2003: print_debug('Error occured while calling inv_trx_util_pub.copy_insert_line_trx',l_module_name,4);
2004: END IF;
2005: RAISE FND_API.G_EXC_ERROR;
2006: END IF;
2007:
2008: -- Get item lot serial control
2009: -- Need to link MTLT or MSNT to this new MMTT record

Line 2109: IF l_return_status <>FND_API.g_ret_sts_success THEN

2105: print_debug('l_msg_data => '||l_msg_data,l_module_name,4);
2106: print_debug('l_msg_count => '||l_msg_count,l_module_name,4);
2107: END IF;
2108:
2109: IF l_return_status <>FND_API.g_ret_sts_success THEN
2110: IF (l_debug=1) THEN
2111: print_debug('Not last operation - Drop - inv_trx_util_pub.delete_transaction finished with error. l_return_status = ' || l_return_status,l_module_name,4);
2112: END IF;
2113:

Line 2114: RAISE FND_API.G_EXC_ERROR;

2110: IF (l_debug=1) THEN
2111: print_debug('Not last operation - Drop - inv_trx_util_pub.delete_transaction finished with error. l_return_status = ' || l_return_status,l_module_name,4);
2112: END IF;
2113:
2114: RAISE FND_API.G_EXC_ERROR;
2115: END IF;
2116:
2117: END IF; -- IF (p_document_rec.transaction_action_id = G_ACTION_RECEIPT
2118:

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

2174: IF (l_debug=1) THEN
2175: print_debug('Return status is'||l_return_status,l_module_name,9);
2176: END IF;
2177:
2178: IF (l_return_status=fnd_api.g_ret_sts_error) THEN
2179: IF (l_debug=1) THEN
2180: print_debug('Error obtained while reverting suggested locator capacity',l_module_name,9);
2181: END IF;
2182: -- Bug 5369010: do not raise exception if locator capacity API fails

Line 2183: -- RAISE FND_API.G_EXC_ERROR;

2179: IF (l_debug=1) THEN
2180: print_debug('Error obtained while reverting suggested locator capacity',l_module_name,9);
2181: END IF;
2182: -- Bug 5369010: do not raise exception if locator capacity API fails
2183: -- RAISE FND_API.G_EXC_ERROR;
2184:
2185: ELSIF (l_return_status<>fnd_api.g_ret_sts_success) THEN
2186:
2187: IF (l_debug=1) THEN

Line 2185: ELSIF (l_return_status<>fnd_api.g_ret_sts_success) THEN

2181: END IF;
2182: -- Bug 5369010: do not raise exception if locator capacity API fails
2183: -- RAISE FND_API.G_EXC_ERROR;
2184:
2185: ELSIF (l_return_status<>fnd_api.g_ret_sts_success) THEN
2186:
2187: IF (l_debug=1) THEN
2188: print_debug('unexpected error while reverting suggested locator capacity',l_module_name,9);
2189: END IF;

Line 2191: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2187: IF (l_debug=1) THEN
2188: print_debug('unexpected error while reverting suggested locator capacity',l_module_name,9);
2189: END IF;
2190: -- Bug 5369010: do not raise exception if locator capacity API fails
2191: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2192:
2193: END IF;
2194:
2195: END IF;

Line 2211: WHEN fnd_api.g_exc_error THEN

2207: END IF;
2208:
2209:
2210: EXCEPTION
2211: WHEN fnd_api.g_exc_error THEN
2212: IF (l_debug=1) THEN
2213: print_debug('Error (fnd_api.g_exc_error) occured at'||l_progress,l_module_name,1);
2214: END IF;
2215: x_return_status:=FND_API.G_RET_STS_ERROR;

Line 2213: print_debug('Error (fnd_api.g_exc_error) occured at'||l_progress,l_module_name,1);

2209:
2210: EXCEPTION
2211: WHEN fnd_api.g_exc_error THEN
2212: IF (l_debug=1) THEN
2213: print_debug('Error (fnd_api.g_exc_error) occured at'||l_progress,l_module_name,1);
2214: END IF;
2215: x_return_status:=FND_API.G_RET_STS_ERROR;
2216: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2217:

Line 2215: x_return_status:=FND_API.G_RET_STS_ERROR;

2211: WHEN fnd_api.g_exc_error THEN
2212: IF (l_debug=1) THEN
2213: print_debug('Error (fnd_api.g_exc_error) occured at'||l_progress,l_module_name,1);
2214: END IF;
2215: x_return_status:=FND_API.G_RET_STS_ERROR;
2216: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2217:
2218: IF c_mmtt_data_rec%isopen THEN
2219: CLOSE c_mmtt_data_rec;

Line 2223: WHEN fnd_api.g_exc_unexpected_error THEN

2219: CLOSE c_mmtt_data_rec;
2220: END IF;
2221:
2222:
2223: WHEN fnd_api.g_exc_unexpected_error THEN
2224:
2225: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
2226: IF (l_debug=1) THEN
2227: print_debug('Unexpected Error (fnd_api.g_exc_unexpected_error) occured at '||l_progress,l_module_name,3);

Line 2225: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

2221:
2222:
2223: WHEN fnd_api.g_exc_unexpected_error THEN
2224:
2225: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
2226: IF (l_debug=1) THEN
2227: print_debug('Unexpected Error (fnd_api.g_exc_unexpected_error) occured at '||l_progress,l_module_name,3);
2228: END IF;
2229: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 2227: print_debug('Unexpected Error (fnd_api.g_exc_unexpected_error) occured at '||l_progress,l_module_name,3);

2223: WHEN fnd_api.g_exc_unexpected_error THEN
2224:
2225: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
2226: IF (l_debug=1) THEN
2227: print_debug('Unexpected Error (fnd_api.g_exc_unexpected_error) occured at '||l_progress,l_module_name,3);
2228: END IF;
2229: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2230: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);
2231: END IF;

Line 2240: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

2236: END IF;
2237:
2238: WHEN OTHERS THEN
2239:
2240: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
2241: IF (l_debug=1) THEN
2242: print_debug('Other Error occured at '||l_progress,l_module_name,1);
2243: IF SQLCODE IS NOT NULL THEN
2244: print_debug('With SQL error : ' || SQLERRM(SQLCODE), l_module_name,1);

Line 2316: x_return_status := FND_API.G_RET_STS_SUCCESS;

2312:
2313: l_mol_lpn_id NUMBER;
2314:
2315: BEGIN
2316: x_return_status := FND_API.G_RET_STS_SUCCESS;
2317: l_progress := 10;
2318:
2319: SAVEPOINT sp_op_inbound_cleanup;
2320:

Line 2334: RAISE fnd_api.G_EXC_ERROR;

2330: FETCH c_mmtt_data_rec INTO l_mmtt_data_rec;
2331: IF c_mmtt_data_rec%notfound THEN
2332: IF (l_debug=1) THEN
2333: print_debug('Invalid p_source_task_id : '||p_source_task_id,l_module_name,1);
2334: RAISE fnd_api.G_EXC_ERROR;
2335: END IF;
2336: END IF;
2337:
2338: CLOSE c_mmtt_data_rec;

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

2377: IF (l_debug=1) THEN
2378: print_debug('Return status is'||l_return_status,l_module_name,9);
2379: END IF;
2380:
2381: IF (l_return_status<>fnd_api.g_ret_sts_success) THEN
2382:
2383: IF (l_debug=1) THEN
2384: print_debug('Error obtained while reverting locator capacity',l_module_name,9);
2385: print_debug('Error msg'||x_msg_data,l_module_name,9);

Line 2473: IF l_return_status <>FND_API.g_ret_sts_success THEN

2469: print_debug('x_msg_count => '|| l_msg_count,l_module_name,4);
2470: print_debug('x_msg_data => '|| l_msg_data,l_module_name,4);
2471: END IF;
2472:
2473: IF l_return_status <>FND_API.g_ret_sts_success THEN
2474: IF (l_debug=1) THEN
2475: print_debug('wms_task_dispatch_put_away.putaway_cleanup finished with error. l_return_status = ' || l_return_status,l_module_name,4);
2476: END IF;
2477:

Line 2478: RAISE FND_API.G_EXC_ERROR;

2474: IF (l_debug=1) THEN
2475: print_debug('wms_task_dispatch_put_away.putaway_cleanup finished with error. l_return_status = ' || l_return_status,l_module_name,4);
2476: END IF;
2477:
2478: RAISE FND_API.G_EXC_ERROR;
2479: END IF;
2480:
2481:
2482: IF (l_debug=1) THEN

Line 2491: WHEN fnd_api.g_exc_error THEN

2487: print_debug('Exited. ',l_module_name,1);
2488: END IF;
2489:
2490: EXCEPTION
2491: WHEN fnd_api.g_exc_error THEN
2492: IF (l_debug=1) THEN
2493: print_debug('Error (fnd_api.g_exc_error) occured at'||l_progress,l_module_name,1);
2494: END IF;
2495: x_return_status:=FND_API.G_RET_STS_ERROR;

Line 2493: print_debug('Error (fnd_api.g_exc_error) occured at'||l_progress,l_module_name,1);

2489:
2490: EXCEPTION
2491: WHEN fnd_api.g_exc_error THEN
2492: IF (l_debug=1) THEN
2493: print_debug('Error (fnd_api.g_exc_error) occured at'||l_progress,l_module_name,1);
2494: END IF;
2495: x_return_status:=FND_API.G_RET_STS_ERROR;
2496: IF c_mmtt_data_rec%isopen THEN
2497: CLOSE c_mmtt_data_rec;

Line 2495: x_return_status:=FND_API.G_RET_STS_ERROR;

2491: WHEN fnd_api.g_exc_error THEN
2492: IF (l_debug=1) THEN
2493: print_debug('Error (fnd_api.g_exc_error) occured at'||l_progress,l_module_name,1);
2494: END IF;
2495: x_return_status:=FND_API.G_RET_STS_ERROR;
2496: IF c_mmtt_data_rec%isopen THEN
2497: CLOSE c_mmtt_data_rec;
2498: END IF;
2499:

Line 2503: WHEN fnd_api.g_exc_unexpected_error THEN

2499:
2500: ROLLBACK TO sp_op_inbound_cleanup;
2501:
2502:
2503: WHEN fnd_api.g_exc_unexpected_error THEN
2504:
2505: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
2506: IF (l_debug=1) THEN
2507: print_debug('Unexpected Error (fnd_api.g_exc_unexpected_error) occured at '||l_progress,l_module_name,3);

Line 2505: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

2501:
2502:
2503: WHEN fnd_api.g_exc_unexpected_error THEN
2504:
2505: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
2506: IF (l_debug=1) THEN
2507: print_debug('Unexpected Error (fnd_api.g_exc_unexpected_error) occured at '||l_progress,l_module_name,3);
2508: END IF;
2509: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 2507: print_debug('Unexpected Error (fnd_api.g_exc_unexpected_error) occured at '||l_progress,l_module_name,3);

2503: WHEN fnd_api.g_exc_unexpected_error THEN
2504:
2505: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
2506: IF (l_debug=1) THEN
2507: print_debug('Unexpected Error (fnd_api.g_exc_unexpected_error) occured at '||l_progress,l_module_name,3);
2508: END IF;
2509: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2510: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);
2511: END IF;

Line 2520: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

2516: ROLLBACK TO sp_op_inbound_cleanup;
2517:
2518: WHEN OTHERS THEN
2519:
2520: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
2521: IF (l_debug=1) THEN
2522: print_debug('Other Error occured at '||l_progress,l_module_name,1);
2523: IF SQLCODE IS NOT NULL THEN
2524: print_debug('With SQL error : ' || SQLERRM(SQLCODE), l_module_name,1);

Line 2624: x_return_status := FND_API.G_RET_STS_SUCCESS;

2620: l_wdt_status NUMBER:=0;
2621:
2622: BEGIN
2623:
2624: x_return_status := FND_API.G_RET_STS_SUCCESS;
2625: l_progress := 10;
2626:
2627: SAVEPOINT sp_op_inbound_cancel;
2628:

Line 2646: RAISE fnd_api.G_EXC_ERROR;

2642: FETCH c_mmtt_data_rec INTO l_mmtt_data_rec;
2643: IF c_mmtt_data_rec%notfound THEN
2644: IF (l_debug=1) THEN
2645: print_debug('Invalid p_source_task_id : '||p_source_task_id,l_module_name,1);
2646: RAISE fnd_api.G_EXC_ERROR;
2647: END IF;
2648: END IF;
2649:
2650: CLOSE c_mmtt_data_rec;

Line 2664: RAISE fnd_api.G_EXC_ERROR;

2660: END IF;
2661:
2662: CLOSE c_parent_mmtt_rec;
2663:
2664: RAISE fnd_api.G_EXC_ERROR;
2665:
2666: END IF;
2667:
2668: CLOSE c_parent_mmtt_rec;

Line 2711: IF l_return_status <>FND_API.g_ret_sts_success THEN

2707: print_debug('x_msg_data => '|| l_msg_data,l_module_name,4);
2708: print_debug('x_msg_count => '|| l_msg_count,l_module_name,4);
2709: END IF;
2710:
2711: IF l_return_status <>FND_API.g_ret_sts_success THEN
2712: IF (l_debug=1) THEN
2713: print_debug('Delete parent - inv_trx_util_pub.delete_transaction finished with error. l_return_status = ' || l_return_status,l_module_name,4);
2714: END IF;
2715:

Line 2716: RAISE FND_API.G_EXC_ERROR;

2712: IF (l_debug=1) THEN
2713: print_debug('Delete parent - inv_trx_util_pub.delete_transaction finished with error. l_return_status = ' || l_return_status,l_module_name,4);
2714: END IF;
2715:
2716: RAISE FND_API.G_EXC_ERROR;
2717: END IF;
2718:
2719:
2720: -- Need to convert MMTT transaction quantity to the UOM of MOL if UOM

Line 2884: RAISE fnd_api.g_exc_error;

2880: print_debug('Sub/Loc cannot be null for loaded LPN:'||l_subinventory_code||':'||l_locator_id,l_module_name,4);
2881: END IF;
2882: fnd_message.set_name('WMS','WMS_UNLD_TASK_INFO_ERR');
2883: fnd_msg_pub.ADD;
2884: RAISE fnd_api.g_exc_error;
2885: END IF;
2886: ELSE
2887: IF (l_debug=1) THEN
2888: print_debug('Delete child - Before calling INV_TRX_UTIL_PUB.Delete_transaction with following parameters: ' ,l_module_name,4);

Line 2914: IF l_return_status <>FND_API.g_ret_sts_success THEN

2910: print_debug('x_msg_data => '|| l_msg_data,l_module_name,4);
2911: print_debug('x_msg_count => '|| l_msg_count,l_module_name,4);
2912: END IF;
2913:
2914: IF l_return_status <>FND_API.g_ret_sts_success THEN
2915: IF (l_debug=1) THEN
2916: print_debug('Delete child - inv_trx_util_pub.delete_transaction finished with error. l_return_status = ' || l_return_status,l_module_name,4);
2917: END IF;
2918:

Line 2919: RAISE FND_API.G_EXC_ERROR;

2915: IF (l_debug=1) THEN
2916: print_debug('Delete child - inv_trx_util_pub.delete_transaction finished with error. l_return_status = ' || l_return_status,l_module_name,4);
2917: END IF;
2918:
2919: RAISE FND_API.G_EXC_ERROR;
2920: END IF;
2921:
2922: END IF;
2923:

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

2945: IF (l_debug=1) THEN
2946: print_debug('Return status is'||l_return_status,l_module_name,9);
2947: END IF;
2948:
2949: IF (l_return_status<>fnd_api.g_ret_sts_success) THEN
2950:
2951: IF (l_debug=1) THEN
2952: print_debug('Error while reverting locator capacity',l_module_name,9);
2953: print_debug('Error message'||l_msg_data,l_module_name,9);

Line 2990: IF l_return_status <>FND_API.g_ret_sts_success THEN

2986: , p_inventory_item_id => l_mmtt_data_rec.inventory_item_id
2987: , p_primary_quantity => l_mmtt_data_rec.primary_quantity
2988: );
2989:
2990: IF l_return_status <>FND_API.g_ret_sts_success THEN
2991: IF (l_debug=1) THEN
2992: print_debug('revert_crossdock finished with error. l_return_status = ' || l_return_status,l_module_name,4);
2993: END IF;
2994:

Line 2995: RAISE FND_API.G_EXC_ERROR;

2991: IF (l_debug=1) THEN
2992: print_debug('revert_crossdock finished with error. l_return_status = ' || l_return_status,l_module_name,4);
2993: END IF;
2994:
2995: RAISE FND_API.G_EXC_ERROR;
2996: END IF;
2997:
2998: END IF;
2999:

Line 3009: WHEN fnd_api.g_exc_error THEN

3005: print_debug('Exited. ',l_module_name,1);
3006: END IF;
3007:
3008: EXCEPTION
3009: WHEN fnd_api.g_exc_error THEN
3010: IF (l_debug=1) THEN
3011: print_debug('Error (fnd_api.g_exc_error) occured at'||l_progress,l_module_name,1);
3012: END IF;
3013: x_return_status:=FND_API.G_RET_STS_ERROR;

Line 3011: print_debug('Error (fnd_api.g_exc_error) occured at'||l_progress,l_module_name,1);

3007:
3008: EXCEPTION
3009: WHEN fnd_api.g_exc_error THEN
3010: IF (l_debug=1) THEN
3011: print_debug('Error (fnd_api.g_exc_error) occured at'||l_progress,l_module_name,1);
3012: END IF;
3013: x_return_status:=FND_API.G_RET_STS_ERROR;
3014: ROLLBACK TO sp_op_inbound_cancel;
3015: IF c_mmtt_data_rec%isopen THEN

Line 3013: x_return_status:=FND_API.G_RET_STS_ERROR;

3009: WHEN fnd_api.g_exc_error THEN
3010: IF (l_debug=1) THEN
3011: print_debug('Error (fnd_api.g_exc_error) occured at'||l_progress,l_module_name,1);
3012: END IF;
3013: x_return_status:=FND_API.G_RET_STS_ERROR;
3014: ROLLBACK TO sp_op_inbound_cancel;
3015: IF c_mmtt_data_rec%isopen THEN
3016: CLOSE c_mmtt_data_rec;
3017: END IF;

Line 3020: WHEN fnd_api.g_exc_unexpected_error THEN

3016: CLOSE c_mmtt_data_rec;
3017: END IF;
3018:
3019:
3020: WHEN fnd_api.g_exc_unexpected_error THEN
3021:
3022: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
3023: IF (l_debug=1) THEN
3024: print_debug('Unexpected Error (fnd_api.g_exc_unexpected_error) occured at '||l_progress,l_module_name,3);

Line 3022: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

3018:
3019:
3020: WHEN fnd_api.g_exc_unexpected_error THEN
3021:
3022: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
3023: IF (l_debug=1) THEN
3024: print_debug('Unexpected Error (fnd_api.g_exc_unexpected_error) occured at '||l_progress,l_module_name,3);
3025: END IF;
3026: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 3024: print_debug('Unexpected Error (fnd_api.g_exc_unexpected_error) occured at '||l_progress,l_module_name,3);

3020: WHEN fnd_api.g_exc_unexpected_error THEN
3021:
3022: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
3023: IF (l_debug=1) THEN
3024: print_debug('Unexpected Error (fnd_api.g_exc_unexpected_error) occured at '||l_progress,l_module_name,3);
3025: END IF;
3026: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3027: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);
3028: END IF;

Line 3036: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

3032: END IF;
3033:
3034: WHEN OTHERS THEN
3035:
3036: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
3037: IF (l_debug=1) THEN
3038: print_debug('Other Error occured at '||l_progress,l_module_name,1);
3039: IF SQLCODE IS NOT NULL THEN
3040: print_debug('With SQL error : ' || SQLERRM(SQLCODE), l_module_name,1);

Line 3092: x_return_status := FND_API.G_RET_STS_SUCCESS;

3088: l_msg_data VARCHAR2(400);
3089:
3090: BEGIN
3091:
3092: x_return_status := FND_API.G_RET_STS_SUCCESS;
3093: l_progress := 10;
3094: IF (l_debug=1) THEN
3095: print_debug('Entered. ',l_module_name,1);
3096: print_debug('p_document_rec.transaction_temp_id => ' ||p_document_rec.transaction_temp_id ,l_module_name,1);

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

3126: print_debug('Return status from Delete Transaction'||x_return_status,l_module_name,9);
3127: END IF;
3128:
3129:
3130: IF (x_return_status<>FND_API.G_RET_STS_SUCCESS) THEN
3131:
3132: RAISE FND_API.G_EXC_ERROR;
3133: END IF;
3134:

Line 3132: RAISE FND_API.G_EXC_ERROR;

3128:
3129:
3130: IF (x_return_status<>FND_API.G_RET_STS_SUCCESS) THEN
3131:
3132: RAISE FND_API.G_EXC_ERROR;
3133: END IF;
3134:
3135: l_progress:=30;
3136:

Line 3193: IF l_return_status <>FND_API.g_ret_sts_success THEN

3189: print_debug('x_msg_data => '||l_msg_data,l_module_name,4);
3190: print_debug('x_msg_count => '||l_msg_count,l_module_name,4);
3191: END IF;
3192:
3193: IF l_return_status <>FND_API.g_ret_sts_success THEN
3194: IF (l_debug=1) THEN
3195: print_debug('inv_loc_wms_utils.revert_loc_suggested_cap_nauto finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3196: END IF;
3197:

Line 3199: -- RAISE FND_API.G_EXC_ERROR;

3195: print_debug('inv_loc_wms_utils.revert_loc_suggested_cap_nauto finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3196: END IF;
3197:
3198: -- Bug 5369010: do not raise exception if locator capacity API fails
3199: -- RAISE FND_API.G_EXC_ERROR;
3200: END IF;
3201:
3202: END IF;
3203:

Line 3241: WHEN fnd_api.g_exc_error THEN

3237: print_debug('Exited. ',l_module_name,1);
3238: END IF;
3239:
3240: EXCEPTION
3241: WHEN fnd_api.g_exc_error THEN
3242: IF (l_debug=1) THEN
3243: print_debug('Error (fnd_api.g_exc_error) occured at '||l_progress,l_module_name,1);
3244: END IF;
3245: x_return_status:=FND_API.G_RET_STS_ERROR;

Line 3243: print_debug('Error (fnd_api.g_exc_error) occured at '||l_progress,l_module_name,1);

3239:
3240: EXCEPTION
3241: WHEN fnd_api.g_exc_error THEN
3242: IF (l_debug=1) THEN
3243: print_debug('Error (fnd_api.g_exc_error) occured at '||l_progress,l_module_name,1);
3244: END IF;
3245: x_return_status:=FND_API.G_RET_STS_ERROR;
3246: ROLLBACK TO sp_op_inbound_abort;
3247:

Line 3245: x_return_status:=FND_API.G_RET_STS_ERROR;

3241: WHEN fnd_api.g_exc_error THEN
3242: IF (l_debug=1) THEN
3243: print_debug('Error (fnd_api.g_exc_error) occured at '||l_progress,l_module_name,1);
3244: END IF;
3245: x_return_status:=FND_API.G_RET_STS_ERROR;
3246: ROLLBACK TO sp_op_inbound_abort;
3247:
3248: WHEN fnd_api.g_exc_unexpected_error THEN
3249:

Line 3248: WHEN fnd_api.g_exc_unexpected_error THEN

3244: END IF;
3245: x_return_status:=FND_API.G_RET_STS_ERROR;
3246: ROLLBACK TO sp_op_inbound_abort;
3247:
3248: WHEN fnd_api.g_exc_unexpected_error THEN
3249:
3250: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
3251: IF (l_debug=1) THEN
3252: print_debug('Unexpected Error (fnd_api.g_exc_unexpected_error) occured at '||l_progress,l_module_name,3);

Line 3250: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

3246: ROLLBACK TO sp_op_inbound_abort;
3247:
3248: WHEN fnd_api.g_exc_unexpected_error THEN
3249:
3250: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
3251: IF (l_debug=1) THEN
3252: print_debug('Unexpected Error (fnd_api.g_exc_unexpected_error) occured at '||l_progress,l_module_name,3);
3253: END IF;
3254:

Line 3252: print_debug('Unexpected Error (fnd_api.g_exc_unexpected_error) occured at '||l_progress,l_module_name,3);

3248: WHEN fnd_api.g_exc_unexpected_error THEN
3249:
3250: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
3251: IF (l_debug=1) THEN
3252: print_debug('Unexpected Error (fnd_api.g_exc_unexpected_error) occured at '||l_progress,l_module_name,3);
3253: END IF;
3254:
3255: ROLLBACK TO sp_op_inbound_abort;
3256:

Line 3259: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

3255: ROLLBACK TO sp_op_inbound_abort;
3256:
3257: WHEN OTHERS THEN
3258:
3259: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
3260: IF (l_debug=1) THEN
3261: print_debug('Other Error occured at '||l_progress,l_module_name,1);
3262: IF SQLCODE IS NOT NULL THEN
3263: print_debug('With SQL error : ' || SQLERRM(SQLCODE), l_module_name,1);