DBA Data[Home] [Help]

APPS.GME_PICKING_PVT dependencies on FND_API

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

149: || ':Return from pick_material is '
150: || l_return_status);
151: END IF;
152:
153: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
154: RAISE pick_material_err;
155: END IF;
156:
157: IF g_debug <= gme_debug.g_log_procedure THEN

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

217: ,p_called_by => 'P'
218: ,x_open_qty => l_open_qty
219: ,x_return_status => l_return_status);
220:
221: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
222: RETURN 0;
223: ELSE
224: RETURN l_open_qty;
225: END IF;

Line 301: x_return_status := fnd_api.g_ret_sts_success;

297: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
298: || l_api_name);
299: END IF;
300:
301: x_return_status := fnd_api.g_ret_sts_success;
302: l_count := p_mtl_req_tbl.COUNT;
303:
304: IF g_debug <= gme_debug.g_log_statement THEN
305: gme_debug.put_line ( g_pkg_name

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

332: ,p_move_order_type => gme_common_pvt.g_move_order_type
333: ,x_move_order_header_id => l_move_order_header_id
334: ,x_return_status => l_return_status);
335:
336: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
337: RAISE create_move_order_err;
338: END IF;
339:
340: IF g_debug <= gme_debug.g_log_statement THEN

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

392: ,x_material_details_tbl => l_out_mtl_dtl_tbl
393: ,x_trolin_tbl => l_trolin_tbl
394: ,x_return_status => l_return_status);
395:
396: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
397: RAISE create_move_order_err;
398: END IF;
399:
400: l_count := l_trolin_tbl.COUNT;

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

424: ,p_grouping_rule_id => p_task_group_id
425: ,p_plan_tasks => p_plan_tasks
426: ,x_return_status => l_return_status);
427:
428: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
429: RAISE process_line_err;
430: END IF;
431: END LOOP;
432:

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

466: || ':Print picklsip message '
467: || l_msg_data);
468: END IF;
469:
470: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
471: RAISE print_pickslip_err;
472: END IF;
473: END IF;
474:

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

530: --Bug#5311713
531: FND_MESSAGE.SET_NAME('GME','GME_NO_MATERIALS_SELECTED');
532: FND_FILE.PUT_LINE(FND_FILE.log,FND_MESSAGE.GET);
533: --gme_common_pvt.log_message ('GME_NO_MATERIALS_SELECTED');
534: --x_return_status := fnd_api.g_ret_sts_error;
535: WHEN setup_failure THEN
536: x_return_status := fnd_api.g_ret_sts_error;
537: WHEN create_move_order_err OR process_line_err OR print_pickslip_err THEN
538: x_return_status := l_return_status;

Line 536: x_return_status := fnd_api.g_ret_sts_error;

532: FND_FILE.PUT_LINE(FND_FILE.log,FND_MESSAGE.GET);
533: --gme_common_pvt.log_message ('GME_NO_MATERIALS_SELECTED');
534: --x_return_status := fnd_api.g_ret_sts_error;
535: WHEN setup_failure THEN
536: x_return_status := fnd_api.g_ret_sts_error;
537: WHEN create_move_order_err OR process_line_err OR print_pickslip_err THEN
538: x_return_status := l_return_status;
539: WHEN OTHERS THEN
540: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

Line 551: x_return_status := fnd_api.g_ret_sts_unexp_error;

547: || ' Error is '
548: || SQLERRM);
549: END IF;
550:
551: x_return_status := fnd_api.g_ret_sts_unexp_error;
552: END pick_material;
553:
554: PROCEDURE process_line (
555: p_mo_line_rec IN inv_move_order_pub.trolin_rec_type

Line 596: x_return_status := fnd_api.g_ret_sts_success;

592: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
593: || l_api_name);
594: END IF;
595:
596: x_return_status := fnd_api.g_ret_sts_success;
597: gme_reservations_pvt.get_material_reservations
598: (p_organization_id => p_mo_line_rec.organization_id
599: ,p_batch_id => p_mo_line_rec.txn_source_id
600: ,p_material_detail_id => p_mo_line_rec.txn_source_line_id

Line 678: ,p_init_msg_list => fnd_api.g_false

674: END IF;
675:
676: wms_engine_pvt.create_suggestions
677: (p_api_version => 1.0
678: ,p_init_msg_list => fnd_api.g_false
679: ,p_commit => fnd_api.g_false
680: ,p_validation_level => fnd_api.g_valid_level_none
681: ,x_return_status => l_return_status
682: ,x_msg_count => l_msg_count

Line 679: ,p_commit => fnd_api.g_false

675:
676: wms_engine_pvt.create_suggestions
677: (p_api_version => 1.0
678: ,p_init_msg_list => fnd_api.g_false
679: ,p_commit => fnd_api.g_false
680: ,p_validation_level => fnd_api.g_valid_level_none
681: ,x_return_status => l_return_status
682: ,x_msg_count => l_msg_count
683: ,x_msg_data => l_msg_data

Line 680: ,p_validation_level => fnd_api.g_valid_level_none

676: wms_engine_pvt.create_suggestions
677: (p_api_version => 1.0
678: ,p_init_msg_list => fnd_api.g_false
679: ,p_commit => fnd_api.g_false
680: ,p_validation_level => fnd_api.g_valid_level_none
681: ,x_return_status => l_return_status
682: ,x_msg_count => l_msg_count
683: ,x_msg_data => l_msg_data
684: ,p_transaction_temp_id => p_mo_line_rec.line_id

Line 686: ,p_suggest_serial => fnd_api.g_false

682: ,x_msg_count => l_msg_count
683: ,x_msg_data => l_msg_data
684: ,p_transaction_temp_id => p_mo_line_rec.line_id
685: ,p_reservations => l_inv_resv_tbl
686: ,p_suggest_serial => fnd_api.g_false
687: ,p_simulation_mode => wms_engine_pvt.g_no_simulation
688: ,p_simulation_id => NULL
689: ,p_plan_tasks => l_plan_tasks
690: ,p_quick_pick_flag => 'N');

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

701: || 'create suggestions mesg '
702: || l_msg_data);
703: END IF;
704:
705: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
706: RAISE create_suggestions_err;
707: END IF;
708:
709: OPEN cur_detailed_qty (p_mo_line_rec.line_id);

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

764: IF g_debug <= gme_debug.g_log_statement THEN
765: gme_debug.put_line(g_pkg_name || '.' || l_api_name
766: || ':Return from ASSIGNTT IS ' || l_return_status);
767:
768: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
769: gme_debug.put_line ( g_pkg_name
770: || '.'
771: || l_api_name
772: || 'temp_id is '

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

779: END IF;
780: END IF;
781:
782: -- Bug 6778259 - Use existing exception to return error.
783: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
784: RAISE get_pick_slip_err;
785: END IF;
786:
787: IF get_mmtt.pick_slip_number IS NULL THEN

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

832: || ':Message is '
833: || l_msg_data);
834: END IF;
835:
836: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
837: RAISE get_pick_slip_err;
838: END IF;
839:
840: UPDATE mtl_material_transactions_temp

Line 920: x_return_status := fnd_api.g_ret_sts_unexp_error;

916: || ' Error is '
917: || SQLERRM);
918: END IF;
919:
920: x_return_status := fnd_api.g_ret_sts_unexp_error;
921: END process_line;
922: END gme_picking_pvt;