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 167: RAISE FND_API.G_EXC_ERROR;

163: IF (l_debug=1) THEN
164: print_debug('NO MTLT record exists for Lot Control Item',l_module_name,1);
165: END IF;
166: /* Throwing exception for this condition as of now as Invalid document record*/
167: RAISE FND_API.G_EXC_ERROR;
168:
169: END IF;
170:
171: CLOSE c_mtlt_rec;

Line 238: ,p_subinventory_code => FND_API.G_MISS_CHAR

234: ,x_msg_count => l_msg_count
235: ,x_new_txn_temp_id => x_source_task_id
236: ,p_transaction_temp_id => p_source_task_id
237: ,p_organization_id => p_document_rec.organization_id
238: ,p_subinventory_code => FND_API.G_MISS_CHAR
239: ,p_locator_id => FND_API.G_MISS_NUM
240: ,p_parent_line_id => p_source_task_id
241: ,p_wms_task_type => l_wms_task_type
242: ,p_operation_plan_id => p_subsequent_op_plan_id

Line 239: ,p_locator_id => FND_API.G_MISS_NUM

235: ,x_new_txn_temp_id => x_source_task_id
236: ,p_transaction_temp_id => p_source_task_id
237: ,p_organization_id => p_document_rec.organization_id
238: ,p_subinventory_code => FND_API.G_MISS_CHAR
239: ,p_locator_id => FND_API.G_MISS_NUM
240: ,p_parent_line_id => p_source_task_id
241: ,p_wms_task_type => l_wms_task_type
242: ,p_operation_plan_id => p_subsequent_op_plan_id
243: );

Line 255: ,p_subinventory_code => FND_API.G_MISS_CHAR

251: ,x_msg_count => l_msg_count
252: ,x_new_txn_temp_id => x_source_task_id
253: ,p_transaction_temp_id => p_source_task_id
254: ,p_organization_id => p_document_rec.organization_id
255: ,p_subinventory_code => FND_API.G_MISS_CHAR
256: ,p_locator_id => FND_API.G_MISS_NUM
257: ,p_parent_line_id => p_source_task_id
258: ,p_wms_task_type => l_wms_task_type
259: );

Line 256: ,p_locator_id => FND_API.G_MISS_NUM

252: ,x_new_txn_temp_id => x_source_task_id
253: ,p_transaction_temp_id => p_source_task_id
254: ,p_organization_id => p_document_rec.organization_id
255: ,p_subinventory_code => FND_API.G_MISS_CHAR
256: ,p_locator_id => FND_API.G_MISS_NUM
257: ,p_parent_line_id => p_source_task_id
258: ,p_wms_task_type => l_wms_task_type
259: );
260:

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

264: IF (l_debug=1) THEN
265: print_debug('Return status is'||l_return_status,l_module_name,9);
266: END IF;
267:
268: IF (l_return_status=fnd_api.g_ret_sts_error) THEN
269: IF (l_debug=1) THEN
270: print_debug('Error obtained while creating child record',l_module_name,9);
271: END IF;
272: RAISE FND_API.G_EXC_ERROR;

Line 272: RAISE FND_API.G_EXC_ERROR;

268: IF (l_return_status=fnd_api.g_ret_sts_error) THEN
269: IF (l_debug=1) THEN
270: print_debug('Error obtained while creating child record',l_module_name,9);
271: END IF;
272: RAISE FND_API.G_EXC_ERROR;
273:
274: ELSIF (l_return_status<>fnd_api.g_ret_sts_success) THEN
275:
276: IF (l_debug=1) THEN

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

270: print_debug('Error obtained while creating child record',l_module_name,9);
271: END IF;
272: RAISE FND_API.G_EXC_ERROR;
273:
274: ELSIF (l_return_status<>fnd_api.g_ret_sts_success) THEN
275:
276: IF (l_debug=1) THEN
277: print_debug('unexpected error while creating child record',l_module_name,9);
278: END IF;

Line 279: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

275:
276: IF (l_debug=1) THEN
277: print_debug('unexpected error while creating child record',l_module_name,9);
278: END IF;
279: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
280:
281: END IF;
282:
283:

Line 289: RAISE FND_API.G_EXC_ERROR;

285: IF (l_debug=1) THEN
286: print_debug('Cheild record could not be created',l_module_name,1);
287:
288: END IF;
289: RAISE FND_API.G_EXC_ERROR;
290: END IF;
291: l_progress:=70;
292:
293: /* If Lot Controllled Item then

Line 410: RAISE FND_API.G_EXC_ERROR;

406: IF (l_insert_lot<>0) THEN
407: IF (l_debug=1) THEN
408: print_debug('Failed to insert lots',l_module_name,1);
409: END IF;
410: RAISE FND_API.G_EXC_ERROR;
411: END IF;
412: END IF;
413:
414: IF p_revert_loc_capacity THEN

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

439: IF (l_debug=1) THEN
440: print_debug('Return status is'||l_return_status,l_module_name,9);
441: END IF;
442:
443: IF (l_return_status<>fnd_api.g_ret_sts_success) THEN
444:
445: IF (l_debug=1) THEN
446: print_debug('Error obtained while reverting locator capacity',l_module_name,9);
447: print_debug('Error msg'||x_msg_data,l_module_name,9);

Line 457: WHEN fnd_api.g_exc_error THEN

453:
454: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
455:
456: EXCEPTION
457: WHEN fnd_api.g_exc_error THEN
458: IF (l_debug=1) THEN
459: print_debug('Error obatined at'||l_progress,l_module_name,1);
460: END IF;
461: x_return_status:=FND_API.G_RET_STS_ERROR;

Line 461: x_return_status:=FND_API.G_RET_STS_ERROR;

457: WHEN fnd_api.g_exc_error THEN
458: IF (l_debug=1) THEN
459: print_debug('Error obatined at'||l_progress,l_module_name,1);
460: END IF;
461: x_return_status:=FND_API.G_RET_STS_ERROR;
462: /*Message or error code to be populated for Operation PLan Instance Id Null*/
463:
464: WHEN OTHERS THEN
465:

Line 466: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

462: /*Message or error code to be populated for Operation PLan Instance Id Null*/
463:
464: WHEN OTHERS THEN
465:
466: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
467: IF (l_debug=1) THEN
468: print_debug('Unexpected Error'||SQLERRM||'at '||l_progress,l_module_name,3);
469: END IF;
470: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 530: x_return_status := FND_API.G_RET_STS_SUCCESS;

526: l_return_status VARCHAR2(1);
527: l_msg_count NUMBER;
528:
529: BEGIN
530: x_return_status := FND_API.G_RET_STS_SUCCESS;
531: l_progress := 10;
532:
533: /*Whenever we update transfer_to_location and transfer_subinventory, we need to aware that we are
534: * dealing with three types of MMTTS:

Line 571: RAISE FND_API.G_EXC_ERROR;

567: IF (l_debug=1) THEN
568: print_debug('Invalid Sub',l_module_name,1);
569: END IF;
570:
571: RAISE FND_API.G_EXC_ERROR;
572: END IF;
573:
574: l_progress:=27;
575:

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

654: IF (l_debug=1) THEN
655: print_debug('Return status is'||l_return_status,l_module_name,9);
656: END IF;
657:
658: IF (l_return_status<>fnd_api.g_ret_sts_success) THEN
659:
660: IF (l_debug=1) THEN
661: print_debug(' error while updating suggested locator capacity',l_module_name,9);
662: END IF;

Line 671: WHEN fnd_api.g_exc_error THEN

667:
668: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
669:
670: EXCEPTION
671: WHEN fnd_api.g_exc_error THEN
672: IF (l_debug=1) THEN
673: print_debug('Error obatined at'||l_progress,l_module_name,1);
674: END IF;
675: x_return_status:=FND_API.G_RET_STS_ERROR;

Line 675: x_return_status:=FND_API.G_RET_STS_ERROR;

671: WHEN fnd_api.g_exc_error THEN
672: IF (l_debug=1) THEN
673: print_debug('Error obatined at'||l_progress,l_module_name,1);
674: END IF;
675: x_return_status:=FND_API.G_RET_STS_ERROR;
676: /*Message or error code to be populated for Operation PLan Instance Id Null*/
677:
678: WHEN OTHERS THEN
679:

Line 680: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

676: /*Message or error code to be populated for Operation PLan Instance Id Null*/
677:
678: WHEN OTHERS THEN
679:
680: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
681: IF (l_debug=1) THEN
682: print_debug('Unexpected Error'||SQLERRM||'at '||l_progress,l_module_name,3);
683: END IF;
684: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 744: x_return_status := FND_API.g_ret_sts_success;

740: END IF;
741:
742: l_progress := 10;
743:
744: x_return_status := FND_API.g_ret_sts_success;
745: SAVEPOINT sp_revert_crossdock;
746:
747: l_progress := 20;
748:

Line 779: IF l_return_status <>FND_API.g_ret_sts_success THEN

775: );
776:
777: l_progress := 50;
778:
779: IF l_return_status <>FND_API.g_ret_sts_success THEN
780: IF (l_debug=1) THEN
781: print_debug('wms_wip_integration.unallocate_material returned with x_return_status = '||l_return_status, l_module_name,1);
782: END IF;
783:

Line 784: RAISE FND_API.G_EXC_ERROR;

780: IF (l_debug=1) THEN
781: print_debug('wms_wip_integration.unallocate_material returned with x_return_status = '||l_return_status, l_module_name,1);
782: END IF;
783:
784: RAISE FND_API.G_EXC_ERROR;
785:
786: END IF;
787:
788: ELSE

Line 820: l_return_status := fnd_api.g_ret_sts_success;

816:
817: l_in_rec.caller := 'WMS_XDOCK_WMSOPIBB';
818: l_in_rec.action_code := 'UPDATE';
819:
820: l_return_status := fnd_api.g_ret_sts_success;
821: WSH_INTERFACE_EXT_GRP.Create_Update_Delivery_Detail
822: ( p_api_version_number => 1.0
823: , p_init_msg_list => fnd_api.g_false
824: , p_commit => fnd_api.g_false

Line 823: , p_init_msg_list => fnd_api.g_false

819:
820: l_return_status := fnd_api.g_ret_sts_success;
821: WSH_INTERFACE_EXT_GRP.Create_Update_Delivery_Detail
822: ( p_api_version_number => 1.0
823: , p_init_msg_list => fnd_api.g_false
824: , p_commit => fnd_api.g_false
825: , x_return_status => l_return_status
826: , x_msg_count => l_msg_count
827: , x_msg_data => l_msg_data

Line 824: , p_commit => fnd_api.g_false

820: l_return_status := fnd_api.g_ret_sts_success;
821: WSH_INTERFACE_EXT_GRP.Create_Update_Delivery_Detail
822: ( p_api_version_number => 1.0
823: , p_init_msg_list => fnd_api.g_false
824: , p_commit => fnd_api.g_false
825: , x_return_status => l_return_status
826: , x_msg_count => l_msg_count
827: , x_msg_data => l_msg_data
828: , p_detail_info_tab => l_detail_info_tab

Line 833: IF l_return_status <> fnd_api.g_ret_sts_success

829: , p_in_rec => l_in_rec
830: , x_out_rec => l_out_rec
831: );
832:
833: IF l_return_status <> fnd_api.g_ret_sts_success
834: THEN
835: IF (l_debug = 1)
836: THEN
837: print_debug

Line 844: IF x_return_status = fnd_api.g_ret_sts_error

840: , l_module_name, 1
841: );
842: END IF;
843:
844: IF x_return_status = fnd_api.g_ret_sts_error
845: THEN
846: RAISE fnd_api.g_exc_error;
847: ELSE
848: RAISE fnd_api.g_exc_unexpected_error;

Line 846: RAISE fnd_api.g_exc_error;

842: END IF;
843:
844: IF x_return_status = fnd_api.g_ret_sts_error
845: THEN
846: RAISE fnd_api.g_exc_error;
847: ELSE
848: RAISE fnd_api.g_exc_unexpected_error;
849: END IF;
850: ELSE

Line 848: RAISE fnd_api.g_exc_unexpected_error;

844: IF x_return_status = fnd_api.g_ret_sts_error
845: THEN
846: RAISE fnd_api.g_exc_error;
847: ELSE
848: RAISE fnd_api.g_exc_unexpected_error;
849: END IF;
850: ELSE
851: IF (l_debug = 1) THEN
852: print_debug('Successfully updated the WDD record to status ''R'''

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

867:
868: IF (l_debug = 1) THEN
869: print_debug('Before calling inv_reservation_pvt.delete_reservation. ', l_module_name,1);
870: print_debug('p_api_version_number = '||l_api_version_number, l_module_name,1);
871: print_debug('p_init_msg_lst = '||FND_API.g_false, l_module_name,1);
872: print_debug('l_rsv_rec.organization_id = '||l_rsv_rec.organization_id, l_module_name,1);
873: print_debug('l_rsv_rec.inventory_item_id = '||l_rsv_rec.inventory_item_id, l_module_name,1);
874: print_debug('l_rsv_rec.demand_source_line_detail = '||l_rsv_rec.demand_source_line_detail, l_module_name,1);
875: print_debug('l_rsv_rec.supply_source_type_id = '||l_rsv_rec.supply_source_type_id, l_module_name,1);

Line 882: , p_init_msg_lst => FND_API.g_false

878: END IF;
879: inv_reservation_pvt.delete_reservation
880: (
881: p_api_version_number=> l_api_version_number
882: , p_init_msg_lst => FND_API.g_false
883: , x_return_status => l_return_status
884: , x_msg_count => l_msg_count
885: , x_msg_data => l_msg_data
886: , p_rsv_rec => l_rsv_rec

Line 897: IF l_return_status <>FND_API.g_ret_sts_success THEN

893: print_debug('x_msg_count = '||l_msg_count, l_module_name,1);
894: print_debug('x_msg_data = '||l_msg_data, l_module_name,1);
895: END IF;
896:
897: IF l_return_status <>FND_API.g_ret_sts_success THEN
898: IF (l_debug=1) THEN
899: print_debug('inv_reservation_pvt.delete_reservation. returned with x_return_status = '||l_return_status, l_module_name,1);
900: END IF;
901: RAISE FND_API.G_EXC_ERROR;

Line 901: RAISE FND_API.G_EXC_ERROR;

897: IF l_return_status <>FND_API.g_ret_sts_success THEN
898: IF (l_debug=1) THEN
899: print_debug('inv_reservation_pvt.delete_reservation. returned with x_return_status = '||l_return_status, l_module_name,1);
900: END IF;
901: RAISE FND_API.G_EXC_ERROR;
902: END IF;
903:
904: l_progress := 80;
905:

Line 916: WHEN fnd_api.g_exc_error THEN

912: print_debug(' x_msg_data = '||x_msg_data, l_module_name,1);
913: END IF;
914: EXCEPTION
915:
916: WHEN fnd_api.g_exc_error THEN
917: IF (l_debug=1) THEN
918: print_debug('fnd_api.g_exc_error. l_progress = '|| l_progress, l_module_name,1);
919: END IF;
920: x_return_status:=FND_API.G_RET_STS_ERROR;

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

914: EXCEPTION
915:
916: WHEN fnd_api.g_exc_error THEN
917: IF (l_debug=1) THEN
918: print_debug('fnd_api.g_exc_error. l_progress = '|| l_progress, l_module_name,1);
919: END IF;
920: x_return_status:=FND_API.G_RET_STS_ERROR;
921: ROLLBACK TO sp_revert_crossdock;
922:

Line 920: x_return_status:=FND_API.G_RET_STS_ERROR;

916: WHEN fnd_api.g_exc_error THEN
917: IF (l_debug=1) THEN
918: print_debug('fnd_api.g_exc_error. l_progress = '|| l_progress, l_module_name,1);
919: END IF;
920: x_return_status:=FND_API.G_RET_STS_ERROR;
921: ROLLBACK TO sp_revert_crossdock;
922:
923: WHEN fnd_api.g_exc_unexpected_error THEN
924:

Line 923: WHEN fnd_api.g_exc_unexpected_error THEN

919: END IF;
920: x_return_status:=FND_API.G_RET_STS_ERROR;
921: ROLLBACK TO sp_revert_crossdock;
922:
923: WHEN fnd_api.g_exc_unexpected_error THEN
924:
925: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
926: IF (l_debug=1) THEN
927: print_debug('fnd_api.g_exc_unexpected_error. l_progress = '|| l_progress, l_module_name,1);

Line 925: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

921: ROLLBACK TO sp_revert_crossdock;
922:
923: WHEN fnd_api.g_exc_unexpected_error THEN
924:
925: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
926: IF (l_debug=1) THEN
927: print_debug('fnd_api.g_exc_unexpected_error. l_progress = '|| l_progress, l_module_name,1);
928: END IF;
929:

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

923: WHEN fnd_api.g_exc_unexpected_error THEN
924:
925: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
926: IF (l_debug=1) THEN
927: print_debug('fnd_api.g_exc_unexpected_error. l_progress = '|| l_progress, l_module_name,1);
928: END IF;
929:
930: ROLLBACK TO sp_revert_crossdock;
931:

Line 933: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

929:
930: ROLLBACK TO sp_revert_crossdock;
931:
932: WHEN OTHERS THEN
933: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
934: IF (l_debug=1) THEN
935: print_debug('fnd_api.g_exc_unexpected_error. l_progress = '|| l_progress, l_module_name,1);
936: END IF;
937:

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

931:
932: WHEN OTHERS THEN
933: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
934: IF (l_debug=1) THEN
935: print_debug('fnd_api.g_exc_unexpected_error. l_progress = '|| l_progress, l_module_name,1);
936: END IF;
937:
938: ROLLBACK TO sp_revert_crossdock;
939:

Line 1055: x_return_status := FND_API.G_RET_STS_SUCCESS;

1051:
1052: BEGIN
1053:
1054:
1055: x_return_status := FND_API.G_RET_STS_SUCCESS;
1056: l_progress := 10;
1057:
1058: IF (l_debug=1) THEN
1059: print_debug('Entered. ',l_module_name,1);

Line 1075: RAISE FND_API.G_EXC_ERROR;

1071: IF p_source_task_id IS NULL THEN
1072: IF (l_debug=1) THEN
1073: print_debug('Invalid input param. p_source_task_id Cannot be NULL.',l_module_name,4);
1074: END IF;
1075: RAISE FND_API.G_EXC_ERROR;
1076: END IF;
1077:
1078: IF p_operation_type_id IS NULL THEN
1079: IF (l_debug=1) THEN

Line 1082: RAISE FND_API.G_EXC_ERROR;

1078: IF p_operation_type_id IS NULL THEN
1079: IF (l_debug=1) THEN
1080: print_debug('Invalid input param. p_operation_type_id Cannot be NULL.',l_module_name,4);
1081: END IF;
1082: RAISE FND_API.G_EXC_ERROR;
1083: END IF;
1084:
1085: IF p_document_rec.transaction_temp_id IS NULL THEN
1086: IF (l_debug=1) THEN

Line 1089: RAISE FND_API.G_EXC_ERROR;

1085: IF p_document_rec.transaction_temp_id IS NULL THEN
1086: IF (l_debug=1) THEN
1087: print_debug('Invalid input param. p_document_rec Cannot be NULL.',l_module_name,4);
1088: END IF;
1089: RAISE FND_API.G_EXC_ERROR;
1090: END IF;
1091:
1092: IF p_is_last_operation_flag NOT IN ('N', 'Y') THEN
1093: IF (l_debug=1) THEN

Line 1096: RAISE FND_API.G_EXC_ERROR;

1092: IF p_is_last_operation_flag NOT IN ('N', 'Y') THEN
1093: IF (l_debug=1) THEN
1094: print_debug('Invalid input param. p_is_last_operation_flag has to be either Y or N.',l_module_name,4);
1095: END IF;
1096: RAISE FND_API.G_EXC_ERROR;
1097: END IF;
1098:
1099: l_progress := 15;
1100:

Line 1107: RAISE fnd_api.G_EXC_ERROR;

1103: FETCH c_mmtt_data_rec INTO l_mmtt_data_rec;
1104: IF c_mmtt_data_rec%notfound THEN
1105: IF (l_debug=1) THEN
1106: print_debug('Invalid p_source_task_id : '||p_source_task_id,l_module_name,1);
1107: RAISE fnd_api.G_EXC_ERROR;
1108: END IF;
1109: END IF;
1110: CLOSE c_mmtt_data_rec;
1111:

Line 1160: IF l_return_status <>FND_API.g_ret_sts_success THEN

1156: print_debug('l_msg_data => '||l_msg_data,l_module_name,4);
1157: print_debug('l_msg_count => '||l_msg_count,l_module_name,4);
1158: END IF;
1159:
1160: IF l_return_status <>FND_API.g_ret_sts_success THEN
1161: IF (l_debug=1) THEN
1162: print_debug('inv_trx_util_pub.delete_transaction finished with error. l_return_status = ' || l_return_status,l_module_name,4);
1163: END IF;
1164:

Line 1165: RAISE FND_API.G_EXC_ERROR;

1161: IF (l_debug=1) THEN
1162: print_debug('inv_trx_util_pub.delete_transaction finished with error. l_return_status = ' || l_return_status,l_module_name,4);
1163: END IF;
1164:
1165: RAISE FND_API.G_EXC_ERROR;
1166: END IF;
1167:
1168: END IF; -- p_document_rec.parent_line_id IS NOT NULL
1169:

Line 1261: IF l_return_status <>FND_API.g_ret_sts_success THEN

1257: print_debug('l_msg_count => '|| l_msg_count, l_module_name,4);
1258: print_debug('l_msg_data => '|| l_msg_data, l_module_name,4);
1259: END IF;
1260:
1261: IF l_return_status <>FND_API.g_ret_sts_success THEN
1262: IF (l_debug=1) THEN
1263: print_debug('WMS_Cross_Dock_Pvt.complete_crossdock finished with error. l_return_status = ' || l_return_status,l_module_name,4);
1264: END IF;
1265:

Line 1266: RAISE FND_API.G_EXC_ERROR;

1262: IF (l_debug=1) THEN
1263: print_debug('WMS_Cross_Dock_Pvt.complete_crossdock finished with error. l_return_status = ' || l_return_status,l_module_name,4);
1264: END IF;
1265:
1266: RAISE FND_API.G_EXC_ERROR;
1267: END IF;
1268:
1269: -- END IF; -- IF l_mmtt_data_rec.operation_plan_id IS NULL
1270:

Line 1323: , p_init_msg_list => fnd_api.g_false

1319:
1320: -- Calling Workflow
1321: wms_workflow_wrappers.wf_wrapper(
1322: p_api_version => 1.0
1323: , p_init_msg_list => fnd_api.g_false
1324: , p_commit => fnd_api.g_false
1325: , x_return_status => x_return_status
1326: , x_msg_count => x_msg_count
1327: , x_msg_data => x_msg_data

Line 1324: , p_commit => fnd_api.g_false

1320: -- Calling Workflow
1321: wms_workflow_wrappers.wf_wrapper(
1322: p_api_version => 1.0
1323: , p_init_msg_list => fnd_api.g_false
1324: , p_commit => fnd_api.g_false
1325: , x_return_status => x_return_status
1326: , x_msg_count => x_msg_count
1327: , x_msg_data => x_msg_data
1328: , p_org_id => p_document_rec.organization_id

Line 1341: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

1337: IF (l_debug = 1) THEN
1338: print_debug('After Calling WF Wrapper',l_module_name,4);
1339: END IF;
1340:
1341: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1342: IF (l_debug = 1) THEN
1343: print_debug('Error callinf WF wrapper',l_module_name,4);
1344: END IF;
1345:

Line 1348: RAISE fnd_api.g_exc_unexpected_error;

1344: END IF;
1345:
1346: fnd_message.set_name('WMS', 'WMS_WORK_FLOW_FAIL');
1347: fnd_msg_pub.ADD;
1348: RAISE fnd_api.g_exc_unexpected_error;
1349: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
1350: IF (l_debug = 1) THEN
1351: print_debug('Error calling WF wrapper',l_module_name,4);
1352: END IF;

Line 1349: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN

1345:
1346: fnd_message.set_name('WMS', 'WMS_WORK_FLOW_FAIL');
1347: fnd_msg_pub.ADD;
1348: RAISE fnd_api.g_exc_unexpected_error;
1349: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
1350: IF (l_debug = 1) THEN
1351: print_debug('Error calling WF wrapper',l_module_name,4);
1352: END IF;
1353:

Line 1356: RAISE fnd_api.g_exc_error;

1352: END IF;
1353:
1354: fnd_message.set_name('WMS', 'WMS_WORK_FLOW_FAIL');
1355: fnd_msg_pub.ADD;
1356: RAISE fnd_api.g_exc_error;
1357: END IF;
1358: END IF; -- END IF (l_wf > 0)
1359: END IF; -- END IF reason id is not null
1360: END IF; -- END IF inventory sub

Line 1484: IF l_return_status <>FND_API.g_ret_sts_success THEN

1480: print_debug('l_msg_data => '||l_msg_data,l_module_name,4);
1481: print_debug('l_msg_count => '||l_msg_count,l_module_name,4);
1482: END IF;
1483:
1484: IF l_return_status <>FND_API.g_ret_sts_success THEN
1485: IF (l_debug=1) THEN
1486: print_debug('inv_trx_util_pub.delete_transaction finished with error. l_return_status = ' || l_return_status,l_module_name,4);
1487: END IF;
1488:

Line 1489: RAISE FND_API.G_EXC_ERROR;

1485: IF (l_debug=1) THEN
1486: print_debug('inv_trx_util_pub.delete_transaction finished with error. l_return_status = ' || l_return_status,l_module_name,4);
1487: END IF;
1488:
1489: RAISE FND_API.G_EXC_ERROR;
1490: END IF;
1491:
1492: END IF; -- p_document_rec.transaction_action_id = G_ACTION_RECEIPT
1493:

Line 1711: IF l_return_status <>FND_API.g_ret_sts_success THEN

1707: print_debug('l_msg_data => '||l_msg_data,l_module_name,4);
1708: print_debug('l_msg_count => '||l_msg_count,l_module_name,4);
1709: END IF;
1710:
1711: IF l_return_status <>FND_API.g_ret_sts_success THEN
1712: IF (l_debug=1) THEN
1713: print_debug('inv_trx_util_pub.delete_transaction finished with error. l_return_status = ' || l_return_status,l_module_name,4);
1714: END IF;
1715:

Line 1716: RAISE FND_API.G_EXC_ERROR;

1712: IF (l_debug=1) THEN
1713: print_debug('inv_trx_util_pub.delete_transaction finished with error. l_return_status = ' || l_return_status,l_module_name,4);
1714: END IF;
1715:
1716: RAISE FND_API.G_EXC_ERROR;
1717: END IF;
1718:
1719:
1720: ELSE -- p_operation_type_id is not DROP or INSPECT

Line 1725: RAISE FND_API.G_EXC_ERROR;

1721: IF (l_debug=1) THEN
1722: 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);
1723: END IF;
1724:
1725: RAISE FND_API.G_EXC_ERROR;
1726:
1727: END IF; -- p_operation_type_id = g_op_type_drop
1728:
1729:

Line 1826: l_new_subinventory_code := fnd_api.g_miss_char;

1822:
1823: l_new_txn_action_id := p_document_rec.transaction_action_id;
1824: l_new_txn_source_type_id := p_document_rec.transaction_source_type_ID;
1825: l_new_txn_type_id := p_document_rec.transaction_type_id;
1826: l_new_subinventory_code := fnd_api.g_miss_char;
1827: l_new_locator_id := fnd_api.g_miss_num;
1828: l_new_transfer_to_loc := fnd_api.g_miss_num;
1829: l_new_transfer_to_sub := fnd_api.g_miss_char;
1830:

Line 1827: l_new_locator_id := fnd_api.g_miss_num;

1823: l_new_txn_action_id := p_document_rec.transaction_action_id;
1824: l_new_txn_source_type_id := p_document_rec.transaction_source_type_ID;
1825: l_new_txn_type_id := p_document_rec.transaction_type_id;
1826: l_new_subinventory_code := fnd_api.g_miss_char;
1827: l_new_locator_id := fnd_api.g_miss_num;
1828: l_new_transfer_to_loc := fnd_api.g_miss_num;
1829: l_new_transfer_to_sub := fnd_api.g_miss_char;
1830:
1831: END IF; -- l_dest_subinventory_type IS NULL

Line 1828: l_new_transfer_to_loc := fnd_api.g_miss_num;

1824: l_new_txn_source_type_id := p_document_rec.transaction_source_type_ID;
1825: l_new_txn_type_id := p_document_rec.transaction_type_id;
1826: l_new_subinventory_code := fnd_api.g_miss_char;
1827: l_new_locator_id := fnd_api.g_miss_num;
1828: l_new_transfer_to_loc := fnd_api.g_miss_num;
1829: l_new_transfer_to_sub := fnd_api.g_miss_char;
1830:
1831: END IF; -- l_dest_subinventory_type IS NULL
1832:

Line 1829: l_new_transfer_to_sub := fnd_api.g_miss_char;

1825: l_new_txn_type_id := p_document_rec.transaction_type_id;
1826: l_new_subinventory_code := fnd_api.g_miss_char;
1827: l_new_locator_id := fnd_api.g_miss_num;
1828: l_new_transfer_to_loc := fnd_api.g_miss_num;
1829: l_new_transfer_to_sub := fnd_api.g_miss_char;
1830:
1831: END IF; -- l_dest_subinventory_type IS NULL
1832:
1833:

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

1867: print_debug('p_txn_action_id => '||l_new_txn_action_id,l_module_name,4);
1868: print_debug('p_txn_source_type_id => '||l_new_txn_source_type_id,l_module_name,4);
1869: print_debug('p_wms_task_type => '||l_new_wms_task_type_id,l_module_name,4);
1870: print_debug('p_lpn_id => '||l_new_lpn_id, l_module_name,4);
1871: print_debug('p_transfer_lpn_id => '|| fnd_api.g_miss_num, l_module_name,4);
1872: print_debug('p_content_lpn_id => '|| fnd_api.g_miss_num, l_module_name,4);
1873:
1874: END IF;
1875:

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

1868: print_debug('p_txn_source_type_id => '||l_new_txn_source_type_id,l_module_name,4);
1869: print_debug('p_wms_task_type => '||l_new_wms_task_type_id,l_module_name,4);
1870: print_debug('p_lpn_id => '||l_new_lpn_id, l_module_name,4);
1871: print_debug('p_transfer_lpn_id => '|| fnd_api.g_miss_num, l_module_name,4);
1872: print_debug('p_content_lpn_id => '|| fnd_api.g_miss_num, l_module_name,4);
1873:
1874: END IF;
1875:
1876: l_progress := 260;

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

1902: ,p_txn_action_id => l_new_txn_action_id
1903: ,p_txn_source_type_id => l_new_txn_source_type_id
1904: ,p_wms_task_type => l_new_wms_task_type_id
1905: ,p_lpn_id => l_new_lpn_id
1906: ,p_transfer_lpn_id => fnd_api.g_miss_num -- null out transfer_lpn_id
1907: ,p_content_lpn_id => fnd_api.g_miss_num -- null out content_lpn_id
1908: ,p_operation_plan_id => p_subsequent_op_plan_id
1909: ,p_transaction_status => 2 -- Bug 5156015
1910: );

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

1903: ,p_txn_source_type_id => l_new_txn_source_type_id
1904: ,p_wms_task_type => l_new_wms_task_type_id
1905: ,p_lpn_id => l_new_lpn_id
1906: ,p_transfer_lpn_id => fnd_api.g_miss_num -- null out transfer_lpn_id
1907: ,p_content_lpn_id => fnd_api.g_miss_num -- null out content_lpn_id
1908: ,p_operation_plan_id => p_subsequent_op_plan_id
1909: ,p_transaction_status => 2 -- Bug 5156015
1910: );
1911:

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

1929: ,p_txn_action_id => l_new_txn_action_id
1930: ,p_txn_source_type_id => l_new_txn_source_type_id
1931: ,p_wms_task_type => l_new_wms_task_type_id
1932: ,p_lpn_id => l_new_lpn_id
1933: ,p_transfer_lpn_id => fnd_api.g_miss_num -- null out transfer_lpn_id
1934: ,p_content_lpn_id => fnd_api.g_miss_num -- null out content_lpn_id
1935: ,p_transaction_status => 2 -- Bug 5156015
1936: );
1937: END IF;

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

1930: ,p_txn_source_type_id => l_new_txn_source_type_id
1931: ,p_wms_task_type => l_new_wms_task_type_id
1932: ,p_lpn_id => l_new_lpn_id
1933: ,p_transfer_lpn_id => fnd_api.g_miss_num -- null out transfer_lpn_id
1934: ,p_content_lpn_id => fnd_api.g_miss_num -- null out content_lpn_id
1935: ,p_transaction_status => 2 -- Bug 5156015
1936: );
1937: END IF;
1938:

Line 1951: IF l_return_status <>fnd_api.g_ret_sts_success THEN

1947: print_debug('x_source_task_id => '||x_source_task_id,l_module_name,4);
1948:
1949: END IF;
1950:
1951: IF l_return_status <>fnd_api.g_ret_sts_success THEN
1952: IF (l_debug=1) THEN
1953: print_debug('Error occured while calling inv_trx_util_pub.copy_insert_line_trx',l_module_name,4);
1954: END IF;
1955: RAISE FND_API.G_EXC_ERROR;

Line 1955: RAISE FND_API.G_EXC_ERROR;

1951: IF l_return_status <>fnd_api.g_ret_sts_success THEN
1952: IF (l_debug=1) THEN
1953: print_debug('Error occured while calling inv_trx_util_pub.copy_insert_line_trx',l_module_name,4);
1954: END IF;
1955: RAISE FND_API.G_EXC_ERROR;
1956: END IF;
1957:
1958: -- Get item lot serial control
1959: -- Need to link MTLT or MSNT to this new MMTT record

Line 2059: IF l_return_status <>FND_API.g_ret_sts_success THEN

2055: print_debug('l_msg_data => '||l_msg_data,l_module_name,4);
2056: print_debug('l_msg_count => '||l_msg_count,l_module_name,4);
2057: END IF;
2058:
2059: IF l_return_status <>FND_API.g_ret_sts_success THEN
2060: IF (l_debug=1) THEN
2061: 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);
2062: END IF;
2063:

Line 2064: RAISE FND_API.G_EXC_ERROR;

2060: IF (l_debug=1) THEN
2061: 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);
2062: END IF;
2063:
2064: RAISE FND_API.G_EXC_ERROR;
2065: END IF;
2066:
2067: END IF; -- IF (p_document_rec.transaction_action_id = G_ACTION_RECEIPT
2068:

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

2106: IF (l_debug=1) THEN
2107: print_debug('Return status is'||l_return_status,l_module_name,9);
2108: END IF;
2109:
2110: IF (l_return_status=fnd_api.g_ret_sts_error) THEN
2111: IF (l_debug=1) THEN
2112: print_debug('Error obtained while reverting suggested locator capacity',l_module_name,9);
2113: END IF;
2114: -- Bug 5369010: do not raise exception if locator capacity API fails

Line 2115: -- RAISE FND_API.G_EXC_ERROR;

2111: IF (l_debug=1) THEN
2112: print_debug('Error obtained while reverting suggested locator capacity',l_module_name,9);
2113: END IF;
2114: -- Bug 5369010: do not raise exception if locator capacity API fails
2115: -- RAISE FND_API.G_EXC_ERROR;
2116:
2117: ELSIF (l_return_status<>fnd_api.g_ret_sts_success) THEN
2118:
2119: IF (l_debug=1) THEN

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

2113: END IF;
2114: -- Bug 5369010: do not raise exception if locator capacity API fails
2115: -- RAISE FND_API.G_EXC_ERROR;
2116:
2117: ELSIF (l_return_status<>fnd_api.g_ret_sts_success) THEN
2118:
2119: IF (l_debug=1) THEN
2120: print_debug('unexpected error while reverting suggested locator capacity',l_module_name,9);
2121: END IF;

Line 2123: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2119: IF (l_debug=1) THEN
2120: print_debug('unexpected error while reverting suggested locator capacity',l_module_name,9);
2121: END IF;
2122: -- Bug 5369010: do not raise exception if locator capacity API fails
2123: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2124:
2125: END IF;
2126:
2127: END IF;

Line 2143: WHEN fnd_api.g_exc_error THEN

2139: END IF;
2140:
2141:
2142: EXCEPTION
2143: WHEN fnd_api.g_exc_error THEN
2144: IF (l_debug=1) THEN
2145: print_debug('Error (fnd_api.g_exc_error) occured at'||l_progress,l_module_name,1);
2146: END IF;
2147: x_return_status:=FND_API.G_RET_STS_ERROR;

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

2141:
2142: EXCEPTION
2143: WHEN fnd_api.g_exc_error THEN
2144: IF (l_debug=1) THEN
2145: print_debug('Error (fnd_api.g_exc_error) occured at'||l_progress,l_module_name,1);
2146: END IF;
2147: x_return_status:=FND_API.G_RET_STS_ERROR;
2148: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2149:

Line 2147: x_return_status:=FND_API.G_RET_STS_ERROR;

2143: WHEN fnd_api.g_exc_error THEN
2144: IF (l_debug=1) THEN
2145: print_debug('Error (fnd_api.g_exc_error) occured at'||l_progress,l_module_name,1);
2146: END IF;
2147: x_return_status:=FND_API.G_RET_STS_ERROR;
2148: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2149:
2150: IF c_mmtt_data_rec%isopen THEN
2151: CLOSE c_mmtt_data_rec;

Line 2155: WHEN fnd_api.g_exc_unexpected_error THEN

2151: CLOSE c_mmtt_data_rec;
2152: END IF;
2153:
2154:
2155: WHEN fnd_api.g_exc_unexpected_error THEN
2156:
2157: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
2158: IF (l_debug=1) THEN
2159: print_debug('Unexpected Error (fnd_api.g_exc_unexpected_error) occured at '||l_progress,l_module_name,3);

Line 2157: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

2153:
2154:
2155: WHEN fnd_api.g_exc_unexpected_error THEN
2156:
2157: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
2158: IF (l_debug=1) THEN
2159: print_debug('Unexpected Error (fnd_api.g_exc_unexpected_error) occured at '||l_progress,l_module_name,3);
2160: END IF;
2161: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

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

2155: WHEN fnd_api.g_exc_unexpected_error THEN
2156:
2157: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
2158: IF (l_debug=1) THEN
2159: print_debug('Unexpected Error (fnd_api.g_exc_unexpected_error) occured at '||l_progress,l_module_name,3);
2160: END IF;
2161: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2162: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);
2163: END IF;

Line 2172: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

2168: END IF;
2169:
2170: WHEN OTHERS THEN
2171:
2172: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
2173: IF (l_debug=1) THEN
2174: print_debug('Other Error occured at '||l_progress,l_module_name,1);
2175: IF SQLCODE IS NOT NULL THEN
2176: print_debug('With SQL error : ' || SQLERRM(SQLCODE), l_module_name,1);

Line 2248: x_return_status := FND_API.G_RET_STS_SUCCESS;

2244:
2245: l_mol_lpn_id NUMBER;
2246:
2247: BEGIN
2248: x_return_status := FND_API.G_RET_STS_SUCCESS;
2249: l_progress := 10;
2250:
2251: SAVEPOINT sp_op_inbound_cleanup;
2252:

Line 2266: RAISE fnd_api.G_EXC_ERROR;

2262: FETCH c_mmtt_data_rec INTO l_mmtt_data_rec;
2263: IF c_mmtt_data_rec%notfound THEN
2264: IF (l_debug=1) THEN
2265: print_debug('Invalid p_source_task_id : '||p_source_task_id,l_module_name,1);
2266: RAISE fnd_api.G_EXC_ERROR;
2267: END IF;
2268: END IF;
2269:
2270: CLOSE c_mmtt_data_rec;

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

2309: IF (l_debug=1) THEN
2310: print_debug('Return status is'||l_return_status,l_module_name,9);
2311: END IF;
2312:
2313: IF (l_return_status<>fnd_api.g_ret_sts_success) THEN
2314:
2315: IF (l_debug=1) THEN
2316: print_debug('Error obtained while reverting locator capacity',l_module_name,9);
2317: print_debug('Error msg'||x_msg_data,l_module_name,9);

Line 2404: IF l_return_status <>FND_API.g_ret_sts_success THEN

2400: print_debug('x_msg_count => '|| l_msg_count,l_module_name,4);
2401: print_debug('x_msg_data => '|| l_msg_data,l_module_name,4);
2402: END IF;
2403:
2404: IF l_return_status <>FND_API.g_ret_sts_success THEN
2405: IF (l_debug=1) THEN
2406: print_debug('wms_task_dispatch_put_away.putaway_cleanup finished with error. l_return_status = ' || l_return_status,l_module_name,4);
2407: END IF;
2408:

Line 2409: RAISE FND_API.G_EXC_ERROR;

2405: IF (l_debug=1) THEN
2406: print_debug('wms_task_dispatch_put_away.putaway_cleanup finished with error. l_return_status = ' || l_return_status,l_module_name,4);
2407: END IF;
2408:
2409: RAISE FND_API.G_EXC_ERROR;
2410: END IF;
2411:
2412:
2413: IF (l_debug=1) THEN

Line 2422: WHEN fnd_api.g_exc_error THEN

2418: print_debug('Exited. ',l_module_name,1);
2419: END IF;
2420:
2421: EXCEPTION
2422: WHEN fnd_api.g_exc_error THEN
2423: IF (l_debug=1) THEN
2424: print_debug('Error (fnd_api.g_exc_error) occured at'||l_progress,l_module_name,1);
2425: END IF;
2426: x_return_status:=FND_API.G_RET_STS_ERROR;

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

2420:
2421: EXCEPTION
2422: WHEN fnd_api.g_exc_error THEN
2423: IF (l_debug=1) THEN
2424: print_debug('Error (fnd_api.g_exc_error) occured at'||l_progress,l_module_name,1);
2425: END IF;
2426: x_return_status:=FND_API.G_RET_STS_ERROR;
2427: IF c_mmtt_data_rec%isopen THEN
2428: CLOSE c_mmtt_data_rec;

Line 2426: x_return_status:=FND_API.G_RET_STS_ERROR;

2422: WHEN fnd_api.g_exc_error THEN
2423: IF (l_debug=1) THEN
2424: print_debug('Error (fnd_api.g_exc_error) occured at'||l_progress,l_module_name,1);
2425: END IF;
2426: x_return_status:=FND_API.G_RET_STS_ERROR;
2427: IF c_mmtt_data_rec%isopen THEN
2428: CLOSE c_mmtt_data_rec;
2429: END IF;
2430:

Line 2434: WHEN fnd_api.g_exc_unexpected_error THEN

2430:
2431: ROLLBACK TO sp_op_inbound_cleanup;
2432:
2433:
2434: WHEN fnd_api.g_exc_unexpected_error THEN
2435:
2436: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
2437: IF (l_debug=1) THEN
2438: print_debug('Unexpected Error (fnd_api.g_exc_unexpected_error) occured at '||l_progress,l_module_name,3);

Line 2436: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

2432:
2433:
2434: WHEN fnd_api.g_exc_unexpected_error THEN
2435:
2436: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
2437: IF (l_debug=1) THEN
2438: print_debug('Unexpected Error (fnd_api.g_exc_unexpected_error) occured at '||l_progress,l_module_name,3);
2439: END IF;
2440: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

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

2434: WHEN fnd_api.g_exc_unexpected_error THEN
2435:
2436: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
2437: IF (l_debug=1) THEN
2438: print_debug('Unexpected Error (fnd_api.g_exc_unexpected_error) occured at '||l_progress,l_module_name,3);
2439: END IF;
2440: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2441: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);
2442: END IF;

Line 2451: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

2447: ROLLBACK TO sp_op_inbound_cleanup;
2448:
2449: WHEN OTHERS THEN
2450:
2451: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
2452: IF (l_debug=1) THEN
2453: print_debug('Other Error occured at '||l_progress,l_module_name,1);
2454: IF SQLCODE IS NOT NULL THEN
2455: print_debug('With SQL error : ' || SQLERRM(SQLCODE), l_module_name,1);

Line 2553: x_return_status := FND_API.G_RET_STS_SUCCESS;

2549: l_wdt_status NUMBER:=0;
2550:
2551: BEGIN
2552:
2553: x_return_status := FND_API.G_RET_STS_SUCCESS;
2554: l_progress := 10;
2555:
2556: SAVEPOINT sp_op_inbound_cancel;
2557:

Line 2575: RAISE fnd_api.G_EXC_ERROR;

2571: FETCH c_mmtt_data_rec INTO l_mmtt_data_rec;
2572: IF c_mmtt_data_rec%notfound THEN
2573: IF (l_debug=1) THEN
2574: print_debug('Invalid p_source_task_id : '||p_source_task_id,l_module_name,1);
2575: RAISE fnd_api.G_EXC_ERROR;
2576: END IF;
2577: END IF;
2578:
2579: CLOSE c_mmtt_data_rec;

Line 2593: RAISE fnd_api.G_EXC_ERROR;

2589: END IF;
2590:
2591: CLOSE c_parent_mmtt_rec;
2592:
2593: RAISE fnd_api.G_EXC_ERROR;
2594:
2595: END IF;
2596:
2597: CLOSE c_parent_mmtt_rec;

Line 2638: IF l_return_status <>FND_API.g_ret_sts_success THEN

2634: print_debug('x_msg_data => '|| l_msg_data,l_module_name,4);
2635: print_debug('x_msg_count => '|| l_msg_count,l_module_name,4);
2636: END IF;
2637:
2638: IF l_return_status <>FND_API.g_ret_sts_success THEN
2639: IF (l_debug=1) THEN
2640: print_debug('Delete parent - inv_trx_util_pub.delete_transaction finished with error. l_return_status = ' || l_return_status,l_module_name,4);
2641: END IF;
2642:

Line 2643: RAISE FND_API.G_EXC_ERROR;

2639: IF (l_debug=1) THEN
2640: print_debug('Delete parent - inv_trx_util_pub.delete_transaction finished with error. l_return_status = ' || l_return_status,l_module_name,4);
2641: END IF;
2642:
2643: RAISE FND_API.G_EXC_ERROR;
2644: END IF;
2645:
2646:
2647: -- Need to convert MMTT transaction quantity to the UOM of MOL if UOM

Line 2808: RAISE fnd_api.g_exc_error;

2804: print_debug('Sub/Loc cannot be null for loaded LPN:'||l_subinventory_code||':'||l_locator_id,l_module_name,4);
2805: END IF;
2806: fnd_message.set_name('WMS','WMS_UNLD_TASK_INFO_ERR');
2807: fnd_msg_pub.ADD;
2808: RAISE fnd_api.g_exc_error;
2809: END IF;
2810: ELSE
2811: IF (l_debug=1) THEN
2812: print_debug('Delete child - Before calling INV_TRX_UTIL_PUB.Delete_transaction with following parameters: ' ,l_module_name,4);

Line 2838: IF l_return_status <>FND_API.g_ret_sts_success THEN

2834: print_debug('x_msg_data => '|| l_msg_data,l_module_name,4);
2835: print_debug('x_msg_count => '|| l_msg_count,l_module_name,4);
2836: END IF;
2837:
2838: IF l_return_status <>FND_API.g_ret_sts_success THEN
2839: IF (l_debug=1) THEN
2840: print_debug('Delete child - inv_trx_util_pub.delete_transaction finished with error. l_return_status = ' || l_return_status,l_module_name,4);
2841: END IF;
2842:

Line 2843: RAISE FND_API.G_EXC_ERROR;

2839: IF (l_debug=1) THEN
2840: print_debug('Delete child - inv_trx_util_pub.delete_transaction finished with error. l_return_status = ' || l_return_status,l_module_name,4);
2841: END IF;
2842:
2843: RAISE FND_API.G_EXC_ERROR;
2844: END IF;
2845:
2846: END IF;
2847:

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

2869: IF (l_debug=1) THEN
2870: print_debug('Return status is'||l_return_status,l_module_name,9);
2871: END IF;
2872:
2873: IF (l_return_status<>fnd_api.g_ret_sts_success) THEN
2874:
2875: IF (l_debug=1) THEN
2876: print_debug('Error while reverting locator capacity',l_module_name,9);
2877: print_debug('Error message'||l_msg_data,l_module_name,9);

Line 2914: IF l_return_status <>FND_API.g_ret_sts_success THEN

2910: , p_inventory_item_id => l_mmtt_data_rec.inventory_item_id
2911: , p_primary_quantity => l_mmtt_data_rec.primary_quantity
2912: );
2913:
2914: IF l_return_status <>FND_API.g_ret_sts_success THEN
2915: IF (l_debug=1) THEN
2916: print_debug('revert_crossdock 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('revert_crossdock 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 2933: WHEN fnd_api.g_exc_error THEN

2929: print_debug('Exited. ',l_module_name,1);
2930: END IF;
2931:
2932: EXCEPTION
2933: WHEN fnd_api.g_exc_error THEN
2934: IF (l_debug=1) THEN
2935: print_debug('Error (fnd_api.g_exc_error) occured at'||l_progress,l_module_name,1);
2936: END IF;
2937: x_return_status:=FND_API.G_RET_STS_ERROR;

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

2931:
2932: EXCEPTION
2933: WHEN fnd_api.g_exc_error THEN
2934: IF (l_debug=1) THEN
2935: print_debug('Error (fnd_api.g_exc_error) occured at'||l_progress,l_module_name,1);
2936: END IF;
2937: x_return_status:=FND_API.G_RET_STS_ERROR;
2938: ROLLBACK TO sp_op_inbound_cancel;
2939: IF c_mmtt_data_rec%isopen THEN

Line 2937: x_return_status:=FND_API.G_RET_STS_ERROR;

2933: WHEN fnd_api.g_exc_error THEN
2934: IF (l_debug=1) THEN
2935: print_debug('Error (fnd_api.g_exc_error) occured at'||l_progress,l_module_name,1);
2936: END IF;
2937: x_return_status:=FND_API.G_RET_STS_ERROR;
2938: ROLLBACK TO sp_op_inbound_cancel;
2939: IF c_mmtt_data_rec%isopen THEN
2940: CLOSE c_mmtt_data_rec;
2941: END IF;

Line 2944: WHEN fnd_api.g_exc_unexpected_error THEN

2940: CLOSE c_mmtt_data_rec;
2941: END IF;
2942:
2943:
2944: WHEN fnd_api.g_exc_unexpected_error THEN
2945:
2946: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
2947: IF (l_debug=1) THEN
2948: print_debug('Unexpected Error (fnd_api.g_exc_unexpected_error) occured at '||l_progress,l_module_name,3);

Line 2946: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

2942:
2943:
2944: WHEN fnd_api.g_exc_unexpected_error THEN
2945:
2946: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
2947: IF (l_debug=1) THEN
2948: print_debug('Unexpected Error (fnd_api.g_exc_unexpected_error) occured at '||l_progress,l_module_name,3);
2949: END IF;
2950: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

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

2944: WHEN fnd_api.g_exc_unexpected_error THEN
2945:
2946: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
2947: IF (l_debug=1) THEN
2948: print_debug('Unexpected Error (fnd_api.g_exc_unexpected_error) occured at '||l_progress,l_module_name,3);
2949: END IF;
2950: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2951: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);
2952: END IF;

Line 2960: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

2956: END IF;
2957:
2958: WHEN OTHERS THEN
2959:
2960: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
2961: IF (l_debug=1) THEN
2962: print_debug('Other Error occured at '||l_progress,l_module_name,1);
2963: IF SQLCODE IS NOT NULL THEN
2964: print_debug('With SQL error : ' || SQLERRM(SQLCODE), l_module_name,1);

Line 3016: x_return_status := FND_API.G_RET_STS_SUCCESS;

3012: l_msg_data VARCHAR2(400);
3013:
3014: BEGIN
3015:
3016: x_return_status := FND_API.G_RET_STS_SUCCESS;
3017: l_progress := 10;
3018: IF (l_debug=1) THEN
3019: print_debug('Entered. ',l_module_name,1);
3020: print_debug('p_document_rec.transaction_temp_id => ' ||p_document_rec.transaction_temp_id ,l_module_name,1);

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

3050: print_debug('Return status from Delete Transaction'||x_return_status,l_module_name,9);
3051: END IF;
3052:
3053:
3054: IF (x_return_status<>FND_API.G_RET_STS_SUCCESS) THEN
3055:
3056: RAISE FND_API.G_EXC_ERROR;
3057: END IF;
3058:

Line 3056: RAISE FND_API.G_EXC_ERROR;

3052:
3053:
3054: IF (x_return_status<>FND_API.G_RET_STS_SUCCESS) THEN
3055:
3056: RAISE FND_API.G_EXC_ERROR;
3057: END IF;
3058:
3059: l_progress:=30;
3060:

Line 3117: IF l_return_status <>FND_API.g_ret_sts_success THEN

3113: print_debug('x_msg_data => '||l_msg_data,l_module_name,4);
3114: print_debug('x_msg_count => '||l_msg_count,l_module_name,4);
3115: END IF;
3116:
3117: IF l_return_status <>FND_API.g_ret_sts_success THEN
3118: IF (l_debug=1) THEN
3119: print_debug('inv_loc_wms_utils.revert_loc_suggested_cap_nauto finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3120: END IF;
3121:

Line 3123: -- RAISE FND_API.G_EXC_ERROR;

3119: print_debug('inv_loc_wms_utils.revert_loc_suggested_cap_nauto finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3120: END IF;
3121:
3122: -- Bug 5369010: do not raise exception if locator capacity API fails
3123: -- RAISE FND_API.G_EXC_ERROR;
3124: END IF;
3125:
3126: END IF;
3127:

Line 3165: WHEN fnd_api.g_exc_error THEN

3161: print_debug('Exited. ',l_module_name,1);
3162: END IF;
3163:
3164: EXCEPTION
3165: WHEN fnd_api.g_exc_error THEN
3166: IF (l_debug=1) THEN
3167: print_debug('Error (fnd_api.g_exc_error) occured at '||l_progress,l_module_name,1);
3168: END IF;
3169: x_return_status:=FND_API.G_RET_STS_ERROR;

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

3163:
3164: EXCEPTION
3165: WHEN fnd_api.g_exc_error THEN
3166: IF (l_debug=1) THEN
3167: print_debug('Error (fnd_api.g_exc_error) occured at '||l_progress,l_module_name,1);
3168: END IF;
3169: x_return_status:=FND_API.G_RET_STS_ERROR;
3170: ROLLBACK TO sp_op_inbound_abort;
3171:

Line 3169: x_return_status:=FND_API.G_RET_STS_ERROR;

3165: WHEN fnd_api.g_exc_error THEN
3166: IF (l_debug=1) THEN
3167: print_debug('Error (fnd_api.g_exc_error) occured at '||l_progress,l_module_name,1);
3168: END IF;
3169: x_return_status:=FND_API.G_RET_STS_ERROR;
3170: ROLLBACK TO sp_op_inbound_abort;
3171:
3172: WHEN fnd_api.g_exc_unexpected_error THEN
3173:

Line 3172: WHEN fnd_api.g_exc_unexpected_error THEN

3168: END IF;
3169: x_return_status:=FND_API.G_RET_STS_ERROR;
3170: ROLLBACK TO sp_op_inbound_abort;
3171:
3172: WHEN fnd_api.g_exc_unexpected_error THEN
3173:
3174: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
3175: IF (l_debug=1) THEN
3176: print_debug('Unexpected Error (fnd_api.g_exc_unexpected_error) occured at '||l_progress,l_module_name,3);

Line 3174: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

3170: ROLLBACK TO sp_op_inbound_abort;
3171:
3172: WHEN fnd_api.g_exc_unexpected_error THEN
3173:
3174: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
3175: IF (l_debug=1) THEN
3176: print_debug('Unexpected Error (fnd_api.g_exc_unexpected_error) occured at '||l_progress,l_module_name,3);
3177: END IF;
3178:

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

3172: WHEN fnd_api.g_exc_unexpected_error THEN
3173:
3174: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
3175: IF (l_debug=1) THEN
3176: print_debug('Unexpected Error (fnd_api.g_exc_unexpected_error) occured at '||l_progress,l_module_name,3);
3177: END IF;
3178:
3179: ROLLBACK TO sp_op_inbound_abort;
3180:

Line 3183: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

3179: ROLLBACK TO sp_op_inbound_abort;
3180:
3181: WHEN OTHERS THEN
3182:
3183: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
3184: IF (l_debug=1) THEN
3185: print_debug('Other Error occured at '||l_progress,l_module_name,1);
3186: IF SQLCODE IS NOT NULL THEN
3187: print_debug('With SQL error : ' || SQLERRM(SQLCODE), l_module_name,1);