[Home] [Help]
134: --sukhwsin::Marshling enhancement changes- starts
135: --Changed validation logic for supply_demand_code to include supply i.e. 2 also
136: --IF p_supply_demand_code <> 2 THEN
137: IF (p_supply_demand_code NOT IN (1, 2)) THEN
138: --FND_MESSAGE.set_name( 'AHL', 'AHL_RSV_AGAINST_DMND_ONLY' );
139: FND_MESSAGE.set_name( 'AHL', 'AHL_RSV_INVLD_SUP_DMD' );
140: -- Invalid value for supply demand code.
141: FND_MSG_PUB.add;
142: -- log the error
135: --Changed validation logic for supply_demand_code to include supply i.e. 2 also
136: --IF p_supply_demand_code <> 2 THEN
137: IF (p_supply_demand_code NOT IN (1, 2)) THEN
138: --FND_MESSAGE.set_name( 'AHL', 'AHL_RSV_AGAINST_DMND_ONLY' );
139: FND_MESSAGE.set_name( 'AHL', 'AHL_RSV_INVLD_SUP_DMD' );
140: -- Invalid value for supply demand code.
141: FND_MSG_PUB.add;
142: -- log the error
143: IF (l_log_statement >= l_log_current_level)THEN
155: IF (p_supply_demand_code = 2) THEN
156: --Check available quantity for demand
157: -- Validate the Supply Demand line Detail
158: IF p_supply_demand_line_detail IS NULL OR p_supply_demand_line_detail = fnd_api.g_miss_num THEN
159: FND_MESSAGE.set_name( 'AHL', 'AHL_RSV_DMND_LINE_DTL_MAND' );
160: FND_MSG_PUB.add;
161: -- Demand Line Detail is required for CMRO reservations
162: -- log the error
163: IF (l_log_statement >= l_log_current_level)THEN
205: ELSIF (p_supply_demand_code = 1) THEN
206: --Check available quantity for supply
207: -- p_supply_demand_header_id null check
208: IF p_supply_demand_header_id IS NULL OR p_supply_demand_header_id = fnd_api.g_miss_num THEN
209: FND_MESSAGE.set_name( 'AHL', 'AHL_RSV_DMND_HDR_MAND' );
210: FND_MSG_PUB.add;
211: -- Demand header is required for CMRO reservations
212: -- log the error
213: IF (l_log_statement >= l_log_current_level)THEN
229: FETCH get_workorder_quantity INTO l_wo_quantity;
230: CLOSE get_workorder_quantity;
231: ELSE
232: --If Supply demand type is not equal to WIP then raise error, as this supply check is only applicable on WIP supply.
233: FND_MESSAGE.set_name( 'AHL', 'AHL_RSV_SUP_DEM_TYPE_INVLD' );
234: FND_MSG_PUB.add;
235: IF (l_log_statement >= l_log_current_level)THEN
236: fnd_log.string
237: (
509: -- Validate the Supply Demand Code
510: -- 1 : 'SUPPLY' 2 : 'DEMAND'.
511: --IF p_supply_demand_code <> 2 THEN
512: IF (p_supply_demand_code NOT IN (1, 2)) THEN
513: FND_MESSAGE.set_name( 'AHL', 'AHL_RSV_INVLD_SUP_DMD' );
514: FND_MSG_PUB.add;
515: --Invalid value for supply demand code.
516: -- log the error
517: IF (l_log_statement >= l_log_current_level)THEN
529: --sukhwsin::Marshling enhancements - moved validations for common parameters on above and specific validations inside particular branch.
530: --common mandatory parameters for supply and demand are p_supply_demand_header_id, p_organization_id, p_item_id
531: -- p_supply_demand_header_id null check
532: IF p_supply_demand_header_id IS NULL OR p_supply_demand_header_id = fnd_api.g_miss_num THEN
533: FND_MESSAGE.set_name( 'AHL', 'AHL_RSV_DMND_HDR_MAND' );
534: FND_MSG_PUB.add;
535: -- Demand header is required for CMRO reservations
536: -- log the error
537: IF (l_log_statement >= l_log_current_level)THEN
546: END IF;
547:
548: -- p_organization_id null check
549: IF p_organization_id IS NULL OR p_organization_id = fnd_api.g_miss_num THEN
550: FND_MESSAGE.set_name( 'AHL', 'AHL_RSV_ORG_MAND_VLD_SUP_DMND' );
551: FND_MSG_PUB.add;
552: -- Organization is mandatory in validate_supply_demand.
553: -- log the error
554: IF (l_log_statement >= l_log_current_level)THEN
564:
565:
566: -- p_item_id null check
567: IF p_item_id IS NULL OR p_item_id = fnd_api.g_miss_num THEN
568: FND_MESSAGE.set_name( 'AHL', 'AHL_RSV_ITM_MAND_VLD_SUP_DMND' );
569: FND_MSG_PUB.add;
570: -- Item ID is mandatory in validate_supply_demand.
571: -- log the error
572: IF (l_log_statement >= l_log_current_level)THEN
583: IF (p_supply_demand_code = 2 ) THEN
584: --Validations for demand.
585: -- p_supply_demand_line_id null check
586: IF p_supply_demand_line_id IS NULL OR p_supply_demand_line_id = fnd_api.g_miss_num THEN
587: FND_MESSAGE.set_name( 'AHL', 'AHL_RSV_DMND_LINE_MAND' );
588: FND_MSG_PUB.add;
589: -- Demand Line is required for CMRO reservations
590: -- log the error
591: IF (l_log_statement >= l_log_current_level)THEN
600: END IF;
601:
602: -- p_supply_demand_line_detail null check
603: IF p_supply_demand_line_detail IS NULL OR p_supply_demand_line_detail = fnd_api.g_miss_num THEN
604: FND_MESSAGE.set_name( 'AHL', 'AHL_RSV_DMND_LINE_DTL_MAND' );
605: FND_MSG_PUB.add;
606: -- Demand Line Detail is required for CMRO reservations
607: -- log the error
608: IF (l_log_statement >= l_log_current_level)THEN
633: p_item_id);
634: FETCH get_mtl_dtls_wip_cur INTO l_scheduled_material_id;
635: CLOSE get_mtl_dtls_wip_cur;
636: ELSE
637: FND_MESSAGE.set_name( 'AHL', 'AHL_RSV_SUP_DEM_TYPE_INVLD' );
638: FND_MSG_PUB.add;
639: IF (l_log_statement >= l_log_current_level)THEN
640: fnd_log.string
641: (
665: FETCH validate_wip_supply INTO l_job_exists;
666: CLOSE validate_wip_supply;
667: ELSE
668: --If Supply demand type is not equal to WIP then raise error, as this supply check is only applicable on WIP supply.
669: FND_MESSAGE.set_name( 'AHL', 'AHL_RSV_SUP_DEM_TYPE_INVLD' );
670: FND_MSG_PUB.add;
671: IF (l_log_statement >= l_log_current_level)THEN
672: fnd_log.string
673: (