DBA Data[Home] [Help]

APPS.CSP_MO_MTLTXNS_UTIL dependencies on CSP_PL_SHIP_UTIL

Line 804: CSP_PL_SHIP_UTIL.Update_Packlist_Sts_Qty (

800: IF nvl(p_quantity_received, fnd_api.g_miss_num) = fnd_api.g_miss_num OR p_quantity_received < 0 THEN
801: /* IF p_quantity_received = 0 AND p_receiving_option = 1 THEN
802: -- close the move order and ship order because the receiving option is receiving short.
803: -- update quantity_received in the csp_packlist_lines table
804: CSP_PL_SHIP_UTIL.Update_Packlist_Sts_Qty (
805: P_Api_Version_Number => l_api_version_number,
806: P_Init_Msg_List => FND_API.G_true,
807: P_Commit => l_commit,
808: p_validation_level => l_validation_level,

Line 824: IF fnd_api.to_boolean(CSP_PL_SHIP_UTIL.validate_pl_line_status(l_packlist_header_id, '3', true)) THEN

820: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
821: RAISE FND_API.G_EXC_ERROR;
822: END IF;
823:
824: IF fnd_api.to_boolean(CSP_PL_SHIP_UTIL.validate_pl_line_status(l_packlist_header_id, '3', true)) THEN
825: -- update the packlist_header_status
826: CSP_PL_SHIP_UTIL.update_packlist_header_sts (
827: P_Api_Version_Number => l_api_version_number,
828: P_Init_Msg_List => FND_API.G_true,

Line 826: CSP_PL_SHIP_UTIL.update_packlist_header_sts (

822: END IF;
823:
824: IF fnd_api.to_boolean(CSP_PL_SHIP_UTIL.validate_pl_line_status(l_packlist_header_id, '3', true)) THEN
825: -- update the packlist_header_status
826: CSP_PL_SHIP_UTIL.update_packlist_header_sts (
827: P_Api_Version_Number => l_api_version_number,
828: P_Init_Msg_List => FND_API.G_true,
829: P_Commit => l_commit,
830: p_validation_level => l_validation_level,

Line 2028: CSP_PL_SHIP_UTIL.Update_Packlist_Sts_Qty (

2024: l_packlist_line_status := NULL;
2025: END IF;
2026:
2027: -- Update quantity_received in the csp_packlist_lines table
2028: CSP_PL_SHIP_UTIL.Update_Packlist_Sts_Qty (
2029: P_Api_Version_Number => l_api_version_number,
2030: P_Init_Msg_List => FND_API.G_true,
2031: P_Commit => l_commit,
2032: p_validation_level => l_validation_level,

Line 2061: IF fnd_api.to_boolean(CSP_PL_SHIP_UTIL.validate_pl_line_status(l_packlist_header_id, '3', true)) THEN

2057: WHEN no_data_found THEN
2058: null;
2059: END;
2060:
2061: IF fnd_api.to_boolean(CSP_PL_SHIP_UTIL.validate_pl_line_status(l_packlist_header_id, '3', true)) THEN
2062: IF (l_count > 0) THEN
2063: l_packlist_header_status := '4';
2064: ELSE
2065: l_packlist_header_status := '3';

Line 2071: IF fnd_api.to_boolean(CSP_PL_SHIP_UTIL.validate_pl_line_status(l_packlist_header_id, '3', true)) THEN

2067: ELSE
2068: l_packlist_header_status := fnd_api.g_miss_char; --fnd_api.g_miss_char = not to update the status
2069: END IF;
2070: ELSIF p_receiving_option = 1 THEN
2071: IF fnd_api.to_boolean(CSP_PL_SHIP_UTIL.validate_pl_line_status(l_packlist_header_id, '3', true)) THEN
2072: l_packlist_header_status := '4';
2073: ELSE
2074: l_packlist_header_status := fnd_api.g_miss_char; --fnd_api.g_miss_char = not to update the status
2075: END IF;