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.

[Home] [Help]

APPS.GME_PICKING_PVT dependencies on FND_API

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

168: || ':Return from pick_material is '
169: || l_return_status);
170: END IF;
171:
172: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
173: RAISE pick_material_err;
174: END IF;
175:
176: IF g_debug <= gme_debug.g_log_procedure THEN

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

242: ,p_called_by => p_called_by
243: ,x_open_qty => l_open_qty
244: ,x_return_status => l_return_status);
245:
246: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
247: RETURN 0;
248: ELSE
249: RETURN l_open_qty;
250: END IF;

Line 373: x_return_status := fnd_api.g_ret_sts_success;

369: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
370: || l_api_name);
371: END IF;
372:
373: x_return_status := fnd_api.g_ret_sts_success;
374: l_count := p_mtl_req_tbl.COUNT;
375:
376: IF g_debug <= gme_debug.g_log_statement THEN
377: gme_debug.put_line ( g_pkg_name

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

407: ,p_grouping_rule_id => p_task_group_id -- Bug 9941121
408: ,x_move_order_header_id => l_move_order_header_id
409: ,x_return_status => l_return_status);
410:
411: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
412: RAISE create_move_order_err;
413: END IF;
414:
415: IF g_debug <= gme_debug.g_log_statement THEN

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

459: ,p_grouping_rule_id => p_task_group_id -- Bug 9941121
460: ,x_move_order_header_id => l_move_order_header_id
461: ,x_return_status => l_return_status);
462:
463: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
464: RAISE create_move_order_err;
465: END IF;
466:
467: IF g_debug <= gme_debug.g_log_statement THEN

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

522: ,x_material_details_tbl => l_out_mtl_dtl_tbl
523: ,x_trolin_tbl => l_trolin_tbl
524: ,x_return_status => l_return_status);
525:
526: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
527: RAISE create_move_order_err;
528: END IF;
529:
530: l_count := l_trolin_tbl.COUNT;

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

554: ,p_grouping_rule_id => p_task_group_id
555: ,p_plan_tasks => p_plan_tasks
556: ,x_return_status => l_return_status);
557:
558: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
559: RAISE process_line_err;
560: END IF;
561: END LOOP;
562:

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

597: || ':Print picklsip message '
598: || l_msg_data);
599: END IF;
600:
601: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
602: RAISE print_pickslip_err;
603: END IF;
604: END IF;
605:

Line 665: --x_return_status := fnd_api.g_ret_sts_error;

661: --Bug#5311713
662: FND_MESSAGE.SET_NAME('GME','GME_NO_MATERIALS_SELECTED');
663: FND_FILE.PUT_LINE(FND_FILE.log,FND_MESSAGE.GET);
664: --gme_common_pvt.log_message ('GME_NO_MATERIALS_SELECTED');
665: --x_return_status := fnd_api.g_ret_sts_error;
666: WHEN setup_failure THEN
667: x_return_status := fnd_api.g_ret_sts_error;
668: WHEN create_move_order_err OR process_line_err OR print_pickslip_err THEN
669: x_return_status := l_return_status;

Line 667: x_return_status := fnd_api.g_ret_sts_error;

663: FND_FILE.PUT_LINE(FND_FILE.log,FND_MESSAGE.GET);
664: --gme_common_pvt.log_message ('GME_NO_MATERIALS_SELECTED');
665: --x_return_status := fnd_api.g_ret_sts_error;
666: WHEN setup_failure THEN
667: x_return_status := fnd_api.g_ret_sts_error;
668: WHEN create_move_order_err OR process_line_err OR print_pickslip_err THEN
669: x_return_status := l_return_status;
670: WHEN OTHERS THEN
671: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

Line 682: x_return_status := fnd_api.g_ret_sts_unexp_error;

678: || ' Error is '
679: || SQLERRM);
680: END IF;
681:
682: x_return_status := fnd_api.g_ret_sts_unexp_error;
683: END pick_material;
684:
685: PROCEDURE process_line (
686: p_mo_line_rec IN inv_move_order_pub.trolin_rec_type

Line 762: x_return_status := fnd_api.g_ret_sts_success;

758: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
759: || l_api_name);
760: END IF;
761:
762: x_return_status := fnd_api.g_ret_sts_success;
763: gme_reservations_pvt.get_material_reservations
764: (p_organization_id => p_mo_line_rec.organization_id
765: ,p_batch_id => p_mo_line_rec.txn_source_id
766: ,p_material_detail_id => p_mo_line_rec.txn_source_line_id

Line 849: ,p_init_msg_list => fnd_api.g_false

845: END IF;
846:
847: wms_engine_pvt.create_suggestions
848: (p_api_version => 1.0
849: ,p_init_msg_list => fnd_api.g_false
850: ,p_commit => fnd_api.g_false
851: ,p_validation_level => fnd_api.g_valid_level_none
852: ,x_return_status => l_return_status
853: ,x_msg_count => l_msg_count

Line 850: ,p_commit => fnd_api.g_false

846:
847: wms_engine_pvt.create_suggestions
848: (p_api_version => 1.0
849: ,p_init_msg_list => fnd_api.g_false
850: ,p_commit => fnd_api.g_false
851: ,p_validation_level => fnd_api.g_valid_level_none
852: ,x_return_status => l_return_status
853: ,x_msg_count => l_msg_count
854: ,x_msg_data => l_msg_data

Line 851: ,p_validation_level => fnd_api.g_valid_level_none

847: wms_engine_pvt.create_suggestions
848: (p_api_version => 1.0
849: ,p_init_msg_list => fnd_api.g_false
850: ,p_commit => fnd_api.g_false
851: ,p_validation_level => fnd_api.g_valid_level_none
852: ,x_return_status => l_return_status
853: ,x_msg_count => l_msg_count
854: ,x_msg_data => l_msg_data
855: ,p_transaction_temp_id => p_mo_line_rec.line_id

Line 857: ,p_suggest_serial => fnd_api.g_false

853: ,x_msg_count => l_msg_count
854: ,x_msg_data => l_msg_data
855: ,p_transaction_temp_id => p_mo_line_rec.line_id
856: ,p_reservations => l_inv_resv_tbl
857: ,p_suggest_serial => fnd_api.g_false
858: ,p_simulation_mode => wms_engine_pvt.g_no_simulation
859: ,p_simulation_id => NULL
860: ,p_plan_tasks => l_plan_tasks
861: ,p_quick_pick_flag => 'N');

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

872: || 'create suggestions mesg '
873: || l_msg_data);
874: END IF;
875:
876: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
877: RAISE create_suggestions_err;
878: END IF;
879:
880: OPEN cur_detailed_qty (p_mo_line_rec.line_id);

Line 971: , p_init_msg_lst => fnd_api.g_false

967:
968: --update quantity tree
969: inv_quantity_tree_pub.update_quantities(
970: p_api_version_number => 1.0
971: , p_init_msg_lst => fnd_api.g_false
972: , x_return_status => l_api_return_status
973: , x_msg_count => l_msg_count
974: , x_msg_data => l_msg_data
975: , p_organization_id => p_mo_line_rec.organization_id

Line 1008: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN

1004: , x_sqs => l_sec_qty_sug
1005: , x_satt => l_sec_qty_att
1006: , x_satr => l_sec_qty_available_to_reserve
1007: );
1008: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN
1009: RAISE fnd_api.g_exc_unexpected_error;
1010: END IF;
1011:
1012: --handle conversion to reservation UOM

Line 1009: RAISE fnd_api.g_exc_unexpected_error;

1005: , x_satt => l_sec_qty_att
1006: , x_satr => l_sec_qty_available_to_reserve
1007: );
1008: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN
1009: RAISE fnd_api.g_exc_unexpected_error;
1010: END IF;
1011:
1012: --handle conversion to reservation UOM
1013: IF l_inv_resv_tbl(l_res_ordered_index).reservation_uom_code IS NULL THEN

Line 1035: RAISE fnd_api.g_exc_unexpected_error;

1031: fnd_message.set_name('INV', 'INV-CANNOT CONVERT');
1032: fnd_message.set_token('UOM', l_primary_uom);
1033: fnd_message.set_token('ROUTINE', 'Pick Release process');
1034: fnd_msg_pub.ADD;
1035: RAISE fnd_api.g_exc_unexpected_error;
1036: END IF;
1037: END IF;
1038:
1039: UPDATE mtl_reservations

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

1066: IF g_debug <= gme_debug.g_log_statement THEN
1067: gme_debug.put_line(g_pkg_name || '.' || l_api_name
1068: || ':Return from ASSIGNTT IS ' || l_return_status);
1069:
1070: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1071: gme_debug.put_line ( g_pkg_name
1072: || '.'
1073: || l_api_name
1074: || 'temp_id is '

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

1081: END IF;
1082: END IF;
1083:
1084: -- Bug 6778259 - Use existing exception to return error.
1085: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1086: RAISE get_pick_slip_err;
1087: END IF;
1088:
1089: IF get_mmtt.pick_slip_number IS NULL THEN

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

1134: || ':Message is '
1135: || l_msg_data);
1136: END IF;
1137:
1138: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1139: RAISE get_pick_slip_err;
1140: END IF;
1141:
1142: UPDATE mtl_material_transactions_temp

Line 1223: x_return_status := fnd_api.g_ret_sts_unexp_error;

1219: || ' Error is '
1220: || SQLERRM);
1221: END IF;
1222:
1223: x_return_status := fnd_api.g_ret_sts_unexp_error;
1224: END process_line;
1225: END gme_picking_pvt;