DBA Data[Home] [Help]

APPS.INV_KANBAN_PKG dependencies on FND_API

Line 700: x_return_status := fnd_api.g_ret_sts_success;

696: AND ml.lookup_type = 'MTL_KANBAN_SUPPLY_STATUS'
697: AND mkc.supply_status = ml.lookup_code
698: AND ROWNUM = 1;
699: BEGIN
700: x_return_status := fnd_api.g_ret_sts_success;
701: IF l_trace_on = 1 THEN
702: print_debug(
703: 'The input parameters are: '
704: || fnd_global.local_chr(10)

Line 719: x_return_status := fnd_api.g_ret_sts_error;

715: OPEN c_kb_details;
716: FETCH c_kb_details INTO x_card_type, x_card_status, x_supply_status, x_status_check, x_supply_status_meaning;
717:
718: IF (c_kb_details%NOTFOUND) THEN
719: x_return_status := fnd_api.g_ret_sts_error;
720: ELSE
721: x_return_status := fnd_api.g_ret_sts_success;
722: END IF;
723: CLOSE c_kb_details;

Line 721: x_return_status := fnd_api.g_ret_sts_success;

717:
718: IF (c_kb_details%NOTFOUND) THEN
719: x_return_status := fnd_api.g_ret_sts_error;
720: ELSE
721: x_return_status := fnd_api.g_ret_sts_success;
722: END IF;
723: CLOSE c_kb_details;
724:
725: END get_kanban_details;

Line 764: x_return_status := fnd_api.g_ret_sts_success;

760: AND k.kanban_card_number = p_kanban_number
761: ORDER BY m.line_id desc)
762: WHERE ROWNUM = 1;
763: BEGIN
764: x_return_status := fnd_api.g_ret_sts_success;
765: IF l_trace_on = 1 THEN
766: print_debug(
767: 'The input parameters are: '
768: || fnd_global.local_chr(10)

Line 783: x_return_status := fnd_api.g_ret_sts_error;

779: OPEN c_kb_mo_details;
780: FETCH c_kb_mo_details INTO x_mo_line_id, x_ref_type_code, x_mo_line_status_code, x_mo_line_qty_diff;
781:
782: IF (c_kb_mo_details%NOTFOUND) THEN
783: x_return_status := fnd_api.g_ret_sts_error;
784: ELSE
785: x_return_status := fnd_api.g_ret_sts_success;
786: END IF;
787: CLOSE c_kb_mo_details;

Line 785: x_return_status := fnd_api.g_ret_sts_success;

781:
782: IF (c_kb_mo_details%NOTFOUND) THEN
783: x_return_status := fnd_api.g_ret_sts_error;
784: ELSE
785: x_return_status := fnd_api.g_ret_sts_success;
786: END IF;
787: CLOSE c_kb_mo_details;
788:
789: END get_kanban_mo_details;