DBA Data[Home] [Help]

APPS.INV_KANBAN_PKG dependencies on FND_API

Line 711: x_return_status := fnd_api.g_ret_sts_success;

707: AND ml.lookup_type = 'MTL_KANBAN_SUPPLY_STATUS'
708: AND mkc.supply_status = ml.lookup_code
709: AND ROWNUM = 1;
710: BEGIN
711: x_return_status := fnd_api.g_ret_sts_success;
712: IF l_trace_on = 1 THEN
713: print_debug(
714: 'The input parameters are: '
715: || fnd_global.local_chr(10)

Line 730: x_return_status := fnd_api.g_ret_sts_error;

726: OPEN c_kb_details;
727: FETCH c_kb_details INTO x_card_type, x_card_status, x_supply_status, x_status_check, x_supply_status_meaning;
728:
729: IF (c_kb_details%NOTFOUND) THEN
730: x_return_status := fnd_api.g_ret_sts_error;
731: ELSE
732: x_return_status := fnd_api.g_ret_sts_success;
733: END IF;
734: CLOSE c_kb_details;

Line 732: x_return_status := fnd_api.g_ret_sts_success;

728:
729: IF (c_kb_details%NOTFOUND) THEN
730: x_return_status := fnd_api.g_ret_sts_error;
731: ELSE
732: x_return_status := fnd_api.g_ret_sts_success;
733: END IF;
734: CLOSE c_kb_details;
735:
736: END get_kanban_details;

Line 775: x_return_status := fnd_api.g_ret_sts_success;

771: AND k.kanban_card_number = p_kanban_number
772: ORDER BY m.line_id desc)
773: WHERE ROWNUM = 1;
774: BEGIN
775: x_return_status := fnd_api.g_ret_sts_success;
776: IF l_trace_on = 1 THEN
777: print_debug(
778: 'The input parameters are: '
779: || fnd_global.local_chr(10)

Line 794: x_return_status := fnd_api.g_ret_sts_error;

790: OPEN c_kb_mo_details;
791: FETCH c_kb_mo_details INTO x_mo_line_id, x_ref_type_code, x_mo_line_status_code, x_mo_line_qty_diff;
792:
793: IF (c_kb_mo_details%NOTFOUND) THEN
794: x_return_status := fnd_api.g_ret_sts_error;
795: ELSE
796: x_return_status := fnd_api.g_ret_sts_success;
797: END IF;
798: CLOSE c_kb_mo_details;

Line 796: x_return_status := fnd_api.g_ret_sts_success;

792:
793: IF (c_kb_mo_details%NOTFOUND) THEN
794: x_return_status := fnd_api.g_ret_sts_error;
795: ELSE
796: x_return_status := fnd_api.g_ret_sts_success;
797: END IF;
798: CLOSE c_kb_mo_details;
799:
800: END get_kanban_mo_details;