426:
427: IF cur_get_analysis_code%NOTFOUND THEN
428: CLOSE cur_get_analysis_code;
429:
430: fnd_message.set_name ('GMD', 'GMD_INVALID_COST_ANLYS_CODE');
431: fnd_msg_pub.ADD;
432: RAISE analysis_code_not_found;
433: END IF;
434:
456: FETCH cur_get_cost_cmpnt
457: INTO l_dummy;
458:
459: IF cur_get_cost_cmpnt%NOTFOUND THEN
460: fnd_message.set_name ('GMD', 'GMD_INVALID_COST_CMPNTCLS_ID');
461: fnd_msg_pub.ADD;
462:
463: CLOSE cur_get_cost_cmpnt;
464:
647: OR p_batchstep_resource_rec.plan_rsrc_qty < 0
648: OR p_batchstep_resource_rec.actual_rsrc_qty < 0
649: OR p_batchstep_resource_rec.plan_rsrc_usage < 0
650: OR p_batchstep_resource_rec.actual_rsrc_usage < 0 THEN
651: fnd_message.set_name ('GMI', 'IC_INV_QTY');
652: fnd_msg_pub.ADD;
653: RAISE error_condition;
654: END IF;
655:
844: l_act_actual_start_date;
845: ELSE
846: IF p_batchstep_resource_rec.actual_start_date >
847: gme_common_pvt.g_timestamp THEN
848: fnd_message.set_name ('GMA', 'SY_NOFUTUREDATE');
849: fnd_msg_pub.ADD;
850: RAISE date_outside_range;
851: END IF;
852:
872: ELSIF l_step_status = 3
873: AND p_batchstep_resource_rec.actual_cmplt_date IS NOT NULL THEN
874: IF p_batchstep_resource_rec.actual_start_date >
875: gme_common_pvt.g_timestamp THEN
876: fnd_message.set_name ('GMA', 'SY_NOFUTUREDATE');
877: fnd_msg_pub.ADD;
878: RAISE date_outside_range;
879: END IF;
880:
945: OR p_batchstep_resource_rec.plan_rsrc_qty < 0
946: OR p_batchstep_resource_rec.actual_rsrc_qty < 0
947: OR p_batchstep_resource_rec.plan_rsrc_usage < 0
948: OR p_batchstep_resource_rec.actual_rsrc_usage < 0 THEN
949: fnd_message.set_name ('GMI', 'IC_INV_QTY');
950: fnd_msg_pub.ADD;
951: RAISE error_condition;
952: END IF;
953:
986:
987: IF cur_get_analysis_code%NOTFOUND THEN
988: CLOSE cur_get_analysis_code;
989:
990: fnd_message.set_name ('GMD', 'GMD_INVALID_COST_ANLYS_CODE');
991: fnd_msg_pub.ADD;
992: RAISE analysis_code_not_found;
993: END IF;
994:
1013: FETCH cur_get_cost_cmpnt
1014: INTO l_dummy;
1015:
1016: IF cur_get_cost_cmpnt%NOTFOUND THEN
1017: fnd_message.set_name ('GMD', 'GMD_INVALID_COST_CMPNTCLS_ID');
1018: fnd_msg_pub.ADD;
1019:
1020: CLOSE cur_get_cost_cmpnt;
1021:
1426:
1427: --Pawan Kumar added code for actual start date
1428: IF p_batchstep_resource_rec.actual_start_date >
1429: gme_common_pvt.g_timestamp THEN
1430: fnd_message.set_name ('GMA', 'SY_NOFUTUREDATE');
1431: fnd_msg_pub.ADD;
1432: RAISE date_outside_range;
1433: END IF;
1434:
1698:
1699: IF cur_get_rsrc_hdr%NOTFOUND THEN
1700: CLOSE cur_get_rsrc_hdr;
1701:
1702: fnd_message.set_name ('GMD', 'FM_BAD_RESOURCE');
1703: fnd_msg_pub.ADD;
1704: RAISE rsrc_not_found;
1705: END IF;
1706:
1932: CLOSE cur_get_rsrc_dtl;
1933:
1934: CLOSE cur_get_rsrc_hdr;
1935:
1936: fnd_message.set_name ('GMD', 'FM_BAD_RESOURCE');
1937: fnd_msg_pub.ADD;
1938: RAISE rsrc_not_found;
1939: END IF;
1940: