eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GME_BATCHSTEP_RSRC_PVT dependencies on GME_COMMON_PVT

Line 148: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'

144: /* Initially let us assign the return status to success */
145: x_return_status := fnd_api.g_ret_sts_success;
146:
147: IF p_org_code IS NULL THEN
148: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'
149: ,'FIELD_NAME'
150: ,'ORGANIZATION');
151: RAISE input_param_missing;
152: ELSIF p_batch_no IS NULL THEN

Line 153: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'

149: ,'FIELD_NAME'
150: ,'ORGANIZATION');
151: RAISE input_param_missing;
152: ELSIF p_batch_no IS NULL THEN
153: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'
154: ,'FIELD_NAME'
155: ,'BATCH NUMBER');
156: RAISE input_param_missing;
157: ELSIF p_batchstep_no IS NULL THEN

Line 158: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'

154: ,'FIELD_NAME'
155: ,'BATCH NUMBER');
156: RAISE input_param_missing;
157: ELSIF p_batchstep_no IS NULL THEN
158: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'
159: ,'FIELD_NAME'
160: ,'BATCH STEP NUMBER');
161: RAISE input_param_missing;
162: ELSIF p_activity IS NULL THEN

Line 163: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'

159: ,'FIELD_NAME'
160: ,'BATCH STEP NUMBER');
161: RAISE input_param_missing;
162: ELSIF p_activity IS NULL THEN
163: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'
164: ,'FIELD_NAME'
165: ,'ACTIVITY');
166: RAISE input_param_missing;
167: END IF;

Line 178: gme_common_pvt.log_message ('GME_BATCH_NOT_FOUND');

174:
175: IF cur_get_batch_dtl%NOTFOUND THEN
176: CLOSE cur_get_batch_dtl;
177:
178: gme_common_pvt.log_message ('GME_BATCH_NOT_FOUND');
179: RAISE batch_not_found;
180: END IF;
181:
182: CLOSE cur_get_batch_dtl;

Line 196: gme_common_pvt.log_message ('GME_BATCH_STEP_NOT_FOUND'

192:
193: IF cur_get_batchstep_dtl%NOTFOUND THEN
194: CLOSE cur_get_batchstep_dtl;
195:
196: gme_common_pvt.log_message ('GME_BATCH_STEP_NOT_FOUND'
197: ,'STEP_ID'
198: ,p_batchstep_no);
199: RAISE batchstep_not_found;
200: END IF;

Line 236: gme_common_pvt.log_message ('GME_STEP_ACTIVITY_NOT_FOUND'

232: EXIT;
233: END IF;
234: END IF;
235: ELSE
236: gme_common_pvt.log_message ('GME_STEP_ACTIVITY_NOT_FOUND'
237: ,'ACTIVITY'
238: ,p_activity
239: ,'STEP_NO'
240: ,p_batchstep_no);

Line 247: gme_common_pvt.log_message ('GME_RSRC_NOT_FOUND'

243: END LOOP;
244:
245: -- If resource was not found in any activity then report error
246: IF l_rsrc_not_found THEN
247: gme_common_pvt.log_message ('GME_RSRC_NOT_FOUND'
248: ,'RESOURCE'
249: ,p_resource
250: ,'ACTIVITY'
251: ,p_activity);

Line 437: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'

433: || p_batchstep_resource_rec.cost_analysis_code);
434: END IF;
435:
436: IF p_batchstep_resource_rec.cost_analysis_code IS NULL THEN
437: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'
438: ,'FIELD_NAME'
439: ,'COST_ANALYSIS_CODE');
440: RAISE input_param_missing;
441: ELSE

Line 469: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'

465: || p_batchstep_resource_rec.cost_cmpntcls_id);
466: END IF;
467:
468: IF p_batchstep_resource_rec.cost_cmpntcls_id IS NULL THEN
469: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'
470: ,'FIELD_NAME'
471: ,'COST_COMPONENT_CLASS_ID');
472: RAISE input_param_missing;
473: ELSE

Line 502: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'

498: || p_batchstep_resource_rec.scale_type);
499: END IF;
500:
501: IF p_batchstep_resource_rec.scale_type IS NULL THEN
502: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'
503: ,'FIELD_NAME'
504: ,'SCALE_TYPE');
505: RAISE input_param_missing;
506: ELSIF (NOT (lookup_code_valid ('GMD_RESOURCE_SCALE_TYPE'

Line 508: gme_common_pvt.log_message ('GME_INVALID_SCALE_TYPE');

504: ,'SCALE_TYPE');
505: RAISE input_param_missing;
506: ELSIF (NOT (lookup_code_valid ('GMD_RESOURCE_SCALE_TYPE'
507: ,p_batchstep_resource_rec.scale_type) ) ) THEN
508: gme_common_pvt.log_message ('GME_INVALID_SCALE_TYPE');
509: RAISE invalid_scale_type;
510: END IF;
511:
512: -- prim rsrc ind

Line 522: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'

518: || p_batchstep_resource_rec.prim_rsrc_ind);
519: END IF;
520:
521: IF p_batchstep_resource_rec.prim_rsrc_ind IS NULL THEN
522: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'
523: ,'FIELD_NAME'
524: ,'Primary_Resource Indicator');
525: RAISE input_param_missing;
526: ELSIF (NOT (lookup_code_valid ('GMD_PRIM_RSRC_IND'

Line 528: gme_common_pvt.log_message ('GME_INV_PRM_RSRC_IND');

524: ,'Primary_Resource Indicator');
525: RAISE input_param_missing;
526: ELSIF (NOT (lookup_code_valid ('GMD_PRIM_RSRC_IND'
527: ,p_batchstep_resource_rec.prim_rsrc_ind) ) ) THEN
528: gme_common_pvt.log_message ('GME_INV_PRM_RSRC_IND');
529: RAISE invalid_prim_rsrc_ind;
530: END IF;
531:
532: l_batchstep_resource_rec := p_batchstep_resource_rec;

Line 562: gme_common_pvt.log_message ('PC_STEP_STATUS_ERR');

558: || l_step_status);
559: END IF;
560:
561: IF l_step_status IN (4, 5) THEN
562: gme_common_pvt.log_message ('PC_STEP_STATUS_ERR');
563: RAISE invalid_step_status;
564: END IF;
565:
566: -- check ASQC property

Line 575: gme_common_pvt.log_message ('GME_INVALID_ASQC_ACTION');

571:
572: CLOSE cur_get_batch_asqc;
573:
574: IF l_batch_asqc = 1 AND l_step_status = 2 THEN
575: gme_common_pvt.log_message ('GME_INVALID_ASQC_ACTION');
576: RAISE invalid_asqc;
577: END IF;
578:
579: x_step_status := l_step_status;

Line 610: gme_common_pvt.log_message ('GME_INVALID_ACTIVITY_FACTOR');

606: || l_activity_factor);
607: END IF;
608:
609: IF l_activity_factor <= 0 THEN
610: gme_common_pvt.log_message ('GME_INVALID_ACTIVITY_FACTOR');
611: RAISE invalid_activity_factor;
612: END IF;
613:
614: -- check for count and usage values

Line 633: gme_common_pvt.log_message ('GME_INVALID_FIELD'

629: END IF;
630:
631: IF p_batchstep_resource_rec.plan_rsrc_count <>
632: l_batchstep_resource_rec.plan_rsrc_count THEN
633: gme_common_pvt.log_message ('GME_INVALID_FIELD'
634: ,'FIELD'
635: ,'plan_rsrc_count');
636: RAISE error_condition;
637: END IF;

Line 655: gme_common_pvt.log_message ('GME_INVALID_FIELD'

651: END IF;
652:
653: IF p_batchstep_resource_rec.actual_rsrc_count <>
654: l_batchstep_resource_rec.actual_rsrc_count THEN
655: gme_common_pvt.log_message ('GME_INVALID_FIELD'
656: ,'FIELD'
657: ,'actual_rsrc_count');
658: RAISE error_condition;
659: END IF;

Line 683: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'

679: END IF;
680:
681: IF l_step_status = 1 THEN
682: IF l_batchstep_resource_rec.plan_rsrc_count IS NULL THEN
683: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'
684: ,'FIELD_NAME'
685: ,'plan_rsrc_count');
686: RAISE input_param_missing;
687: END IF;

Line 690: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'

686: RAISE input_param_missing;
687: END IF;
688:
689: IF p_batchstep_resource_rec.plan_rsrc_usage IS NULL THEN
690: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'
691: ,'FIELD_NAME'
692: ,'plan_rsrc_usage');
693: RAISE input_param_missing;
694: END IF;

Line 698: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'

694: END IF;
695:
696: IF (l_batch_asqc = 0) THEN
697: IF p_batchstep_resource_rec.plan_rsrc_qty IS NULL THEN
698: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'
699: ,'FIELD_NAME'
700: ,'plan_rsrc_qty');
701: RAISE input_param_missing;
702: END IF;

Line 705: gme_common_pvt.log_message ('GME_INPUT_PARAM_IGNORED'

701: RAISE input_param_missing;
702: END IF;
703: ELSE
704: IF p_batchstep_resource_rec.plan_rsrc_qty IS NOT NULL THEN
705: gme_common_pvt.log_message ('GME_INPUT_PARAM_IGNORED'
706: ,'FIELD'
707: ,'plan_rsrc_qty');
708: END IF;
709: END IF;

Line 712: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'

708: END IF;
709: END IF;
710: ELSIF l_step_status IN (2, 3) THEN
711: IF l_batchstep_resource_rec.actual_rsrc_count IS NULL THEN
712: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'
713: ,'FIELD_NAME'
714: ,'actual_rsrc_count');
715: RAISE input_param_missing;
716: END IF;

Line 719: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'

715: RAISE input_param_missing;
716: END IF;
717:
718: IF p_batchstep_resource_rec.actual_rsrc_usage IS NULL THEN
719: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'
720: ,'FIELD_NAME'
721: ,'actual_rsrc_usage');
722: RAISE input_param_missing;
723: END IF;

Line 727: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'

723: END IF;
724:
725: IF (l_batch_asqc = 0) THEN
726: IF (p_batchstep_resource_rec.actual_rsrc_qty IS NULL) THEN
727: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'
728: ,'FIELD_NAME'
729: ,'actual_rsrc_qty');
730: RAISE input_param_missing;
731: END IF;

Line 734: gme_common_pvt.log_message ('GME_INPUT_PARAM_IGNORED'

730: RAISE input_param_missing;
731: END IF;
732: ELSE
733: IF p_batchstep_resource_rec.actual_rsrc_qty IS NOT NULL THEN
734: gme_common_pvt.log_message ('GME_INPUT_PARAM_IGNORED'
735: ,'FIELD'
736: ,'actual_rsrc_qty');
737: END IF;
738: END IF;

Line 756: gme_common_pvt.log_message ('PM_BADSTARTDATE');

752: AND p_batchstep_resource_rec.plan_cmplt_date IS NOT NULL
753: AND l_step_status = 1 THEN
754: IF p_batchstep_resource_rec.plan_start_date >
755: p_batchstep_resource_rec.plan_cmplt_date THEN
756: gme_common_pvt.log_message ('PM_BADSTARTDATE');
757: RAISE invalid_date;
758: END IF;
759:
760: IF NOT (date_within_activity_dates

Line 764: gme_common_pvt.log_message

760: IF NOT (date_within_activity_dates
761: (l_activity_id
762: ,1
763: ,p_batchstep_resource_rec.plan_start_date) ) THEN
764: gme_common_pvt.log_message
765: ('GME_RSRC_DATES_NOT_ALLOWED'
766: ,'RESOURCE'
767: ,p_batchstep_resource_rec.resources);
768: RAISE date_outside_range;

Line 778: gme_common_pvt.log_message

774: IF NOT (date_within_activity_dates
775: (l_activity_id
776: ,1
777: ,p_batchstep_resource_rec.plan_cmplt_date) ) THEN
778: gme_common_pvt.log_message
779: ('GME_RSRC_DATES_NOT_ALLOWED'
780: ,'RESOURCE'
781: ,p_batchstep_resource_rec.resources);
782: RAISE date_outside_range;

Line 797: gme_common_pvt.log_message

793: IF NOT (date_within_activity_dates
794: (l_activity_id
795: ,1
796: ,p_batchstep_resource_rec.plan_start_date) ) THEN
797: gme_common_pvt.log_message
798: ('GME_RSRC_DATES_NOT_ALLOWED'
799: ,'RESOURCE'
800: ,p_batchstep_resource_rec.resources);
801: RAISE date_outside_range;

Line 817: gme_common_pvt.log_message

813: IF NOT (date_within_activity_dates
814: (l_activity_id
815: ,1
816: ,p_batchstep_resource_rec.plan_cmplt_date) ) THEN
817: gme_common_pvt.log_message
818: ('GME_RSRC_DATES_NOT_ALLOWED'
819: ,'RESOURCE'
820: ,p_batchstep_resource_rec.resources);
821: RAISE date_outside_range;

Line 835: gme_common_pvt.log_message ('PM_BADSTARTDATE');

831: AND p_batchstep_resource_rec.actual_cmplt_date IS NOT NULL
832: AND l_step_status = 3 THEN
833: IF p_batchstep_resource_rec.actual_start_date >
834: p_batchstep_resource_rec.actual_cmplt_date THEN
835: gme_common_pvt.log_message ('PM_BADSTARTDATE');
836: RAISE invalid_date;
837: END IF;
838:
839: IF NOT (date_within_activity_dates

Line 843: gme_common_pvt.log_message

839: IF NOT (date_within_activity_dates
840: (l_activity_id
841: ,3
842: ,p_batchstep_resource_rec.actual_start_date) ) THEN
843: gme_common_pvt.log_message
844: ('GME_RSRC_DATES_NOT_ALLOWED'
845: ,'RESOURCE'
846: ,p_batchstep_resource_rec.resources);
847: RAISE date_outside_range;

Line 857: gme_common_pvt.log_message

853: IF NOT (date_within_activity_dates
854: (l_activity_id
855: ,3
856: ,p_batchstep_resource_rec.actual_cmplt_date) ) THEN
857: gme_common_pvt.log_message
858: ('GME_RSRC_DATES_NOT_ALLOWED'
859: ,'RESOURCE'
860: ,p_batchstep_resource_rec.resources);
861: RAISE date_outside_range;

Line 872: gme_common_pvt.g_timestamp THEN

868: l_batchstep_resource_rec.actual_start_date :=
869: l_act_actual_start_date;
870: ELSE
871: IF p_batchstep_resource_rec.actual_start_date >
872: gme_common_pvt.g_timestamp THEN
873: fnd_message.set_name ('GMA', 'SY_NOFUTUREDATE');
874: fnd_msg_pub.ADD;
875: RAISE date_outside_range;
876: END IF;

Line 882: gme_common_pvt.log_message

878: IF NOT (date_within_activity_dates
879: (l_activity_id
880: ,3
881: ,p_batchstep_resource_rec.actual_start_date) ) THEN
882: gme_common_pvt.log_message
883: ('GME_RSRC_DATES_NOT_ALLOWED'
884: ,'RESOURCE'
885: ,p_batchstep_resource_rec.resources);
886: RAISE date_outside_range;

Line 900: gme_common_pvt.g_timestamp THEN

896: l_act_actual_cmplt_date;
897: ELSIF l_step_status = 3
898: AND p_batchstep_resource_rec.actual_cmplt_date IS NOT NULL THEN
899: IF p_batchstep_resource_rec.actual_start_date >
900: gme_common_pvt.g_timestamp THEN
901: fnd_message.set_name ('GMA', 'SY_NOFUTUREDATE');
902: fnd_msg_pub.ADD;
903: RAISE date_outside_range;
904: END IF;

Line 910: gme_common_pvt.log_message

906: IF NOT (date_within_activity_dates
907: (l_activity_id
908: ,3
909: ,p_batchstep_resource_rec.actual_cmplt_date) ) THEN
910: gme_common_pvt.log_message
911: ('GME_RSRC_DATES_NOT_ALLOWED'
912: ,'RESOURCE'
913: ,p_batchstep_resource_rec.resources);
914: RAISE date_outside_range;

Line 942: IF gme_common_pvt.is_qty_below_capacity

938: l_batchstep_resource_rec.plan_rsrc_usage := NULL;
939: l_batchstep_resource_rec.plan_rsrc_qty := NULL;
940: END IF;
941:
942: IF gme_common_pvt.is_qty_below_capacity
943: (p_batch_step_resources_rec => l_batchstep_resource_rec) THEN
944: gme_common_pvt.log_message ('GME_RESOURCE_PROCESS_QUANTITY'
945: ,'RESOURCE'
946: ,l_batchstep_resource_rec.resources);

Line 944: gme_common_pvt.log_message ('GME_RESOURCE_PROCESS_QUANTITY'

940: END IF;
941:
942: IF gme_common_pvt.is_qty_below_capacity
943: (p_batch_step_resources_rec => l_batchstep_resource_rec) THEN
944: gme_common_pvt.log_message ('GME_RESOURCE_PROCESS_QUANTITY'
945: ,'RESOURCE'
946: ,l_batchstep_resource_rec.resources);
947:
948: IF p_ignore_qty_below_cap = fnd_api.g_false THEN

Line 980: gme_common_pvt.log_message ('PC_STEP_STATUS_ERR');

976: RAISE error_condition;
977: END IF;
978:
979: IF l_step_status IN (4, 5) THEN
980: gme_common_pvt.log_message ('PC_STEP_STATUS_ERR');
981: RAISE invalid_step_status;
982: END IF;
983:
984: IF NOT (gme_batch_step_resources_dbl.fetch_row

Line 999: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'

995: CLOSE cur_get_batch_asqc;
996:
997: /* Bug 3620264 - compare analysis code to G_MISS_CHAR instead of G_MISS_NUM */
998: IF p_batchstep_resource_rec.cost_analysis_code = fnd_api.g_miss_char THEN
999: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'
1000: ,'FIELD_NAME'
1001: ,'COST_ANALYSIS_CODE');
1002: RAISE input_param_missing;
1003: ELSIF ( p_batchstep_resource_rec.cost_analysis_code IS NOT NULL

Line 1028: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'

1024: p_batchstep_resource_rec.cost_analysis_code;
1025: END IF;
1026:
1027: IF p_batchstep_resource_rec.cost_cmpntcls_id = fnd_api.g_miss_num THEN
1028: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'
1029: ,'FIELD_NAME'
1030: ,'COST_COMPONENT_CLASS_ID');
1031: RAISE input_param_missing;
1032: ELSIF ( p_batchstep_resource_rec.cost_cmpntcls_id IS NOT NULL

Line 1058: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'

1054: p_batchstep_resource_rec.cost_cmpntcls_id;
1055: END IF;
1056:
1057: IF p_batchstep_resource_rec.scale_type = fnd_api.g_miss_num THEN
1058: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'
1059: ,'FIELD_NAME'
1060: ,'scale_type');
1061: RAISE input_param_missing;
1062: ELSIF ( p_batchstep_resource_rec.scale_type IS NOT NULL

Line 1067: gme_common_pvt.log_message ('GME_INVALID_SCALE_TYPE');

1063: AND (l_batchstep_resource_rec.scale_type <>
1064: p_batchstep_resource_rec.scale_type) ) THEN
1065: IF (NOT (lookup_code_valid ('GMD_RESOURCE_SCALE_TYPE'
1066: ,p_batchstep_resource_rec.scale_type) ) ) THEN
1067: gme_common_pvt.log_message ('GME_INVALID_SCALE_TYPE');
1068: RAISE invalid_scale_type;
1069: END IF;
1070:
1071: l_field_updated := TRUE;

Line 1077: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'

1073: p_batchstep_resource_rec.scale_type;
1074: END IF;
1075:
1076: IF p_batchstep_resource_rec.prim_rsrc_ind = fnd_api.g_miss_num THEN
1077: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'
1078: ,'FIELD_NAME'
1079: ,'prim_rsrc_ind');
1080: RAISE input_param_missing;
1081: ELSIF ( p_batchstep_resource_rec.prim_rsrc_ind IS NOT NULL

Line 1086: gme_common_pvt.log_message ('GME_INV_PRM_RSRC_IND');

1082: AND (l_batchstep_resource_rec.prim_rsrc_ind <>
1083: p_batchstep_resource_rec.prim_rsrc_ind) ) THEN
1084: IF (NOT (lookup_code_valid ('GMD_PRIM_RSRC_IND'
1085: ,p_batchstep_resource_rec.prim_rsrc_ind) ) ) THEN
1086: gme_common_pvt.log_message ('GME_INV_PRM_RSRC_IND');
1087: RAISE invalid_prim_rsrc_ind;
1088: END IF;
1089:
1090: l_field_updated := TRUE;

Line 1098: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'

1094:
1095: --Pawan Kumar added trunc to give only integer value to count
1096: IF p_batchstep_resource_rec.plan_rsrc_count = fnd_api.g_miss_num
1097: AND l_step_status = 1 THEN
1098: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'
1099: ,'FIELD_NAME'
1100: ,'plan_rsrc_cout');
1101: RAISE input_param_missing;
1102: ELSIF p_batchstep_resource_rec.plan_rsrc_count IS NOT NULL THEN

Line 1105: gme_common_pvt.log_message ('GME_INVALID_FIELD'

1101: RAISE input_param_missing;
1102: ELSIF p_batchstep_resource_rec.plan_rsrc_count IS NOT NULL THEN
1103: IF p_batchstep_resource_rec.plan_rsrc_count <>
1104: TRUNC (p_batchstep_resource_rec.plan_rsrc_count) THEN
1105: gme_common_pvt.log_message ('GME_INVALID_FIELD'
1106: ,'FIELD'
1107: ,'plan_rsrc_count');
1108: RAISE error_condition;
1109: END IF;

Line 1112: gme_common_pvt.log_message ('GME_INV_ACT_STEP_STATUS'

1108: RAISE error_condition;
1109: END IF;
1110:
1111: IF l_step_status = 3 THEN
1112: gme_common_pvt.log_message ('GME_INV_ACT_STEP_STATUS'
1113: ,'FIELD'
1114: ,'plan_rsrc_count');
1115: RAISE invalid_action;
1116: ELSIF l_step_status = 2 THEN

Line 1117: gme_common_pvt.log_message ('GME_UPD_NT_ALLOWED'

1113: ,'FIELD'
1114: ,'plan_rsrc_count');
1115: RAISE invalid_action;
1116: ELSIF l_step_status = 2 THEN
1117: gme_common_pvt.log_message ('GME_UPD_NT_ALLOWED'
1118: ,'FIELD'
1119: ,'plan_rsrc_count');
1120: RAISE invalid_action;
1121: ELSIF (TRUNC (p_batchstep_resource_rec.plan_rsrc_count) <>

Line 1137: gme_common_pvt.log_message ('GME_INVALID_FIELD'

1133: l_batchstep_resource_rec.plan_rsrc_count;
1134: ELSIF p_batchstep_resource_rec.actual_rsrc_count IS NOT NULL THEN
1135: IF p_batchstep_resource_rec.actual_rsrc_count <>
1136: TRUNC (p_batchstep_resource_rec.actual_rsrc_count) THEN
1137: gme_common_pvt.log_message ('GME_INVALID_FIELD'
1138: ,'FIELD'
1139: ,'actual_rsrc_count');
1140: RAISE error_condition;
1141: END IF;

Line 1144: gme_common_pvt.log_message ('GME_INV_ACT_STEP_STATUS'

1140: RAISE error_condition;
1141: END IF;
1142:
1143: IF l_step_status = 1 THEN
1144: gme_common_pvt.log_message ('GME_INV_ACT_STEP_STATUS'
1145: ,'FIELD'
1146: ,'actual_rsrc_count');
1147: RAISE invalid_action;
1148: --ELSIF (trunc(p_batchstep_resource_rec.actual_rsrc_count) <> l_batchstep_resource_rec.actual_rsrc_count) THEN

Line 1161: gme_common_pvt.log_message('GME_FIELD_VALUE_REQUIRED','FIELD_NAME', 'actual_rsrc_count');

1157: /* When the actual resource count is null in the database and we are trying to update actual resource usage without the
1158: actual resource count, then user will be given error message that actual resource count is required.*/
1159: ELSE
1160: IF (l_batchstep_resource_rec.actual_rsrc_count IS NULL AND p_batchstep_resource_rec.actual_rsrc_usage IS NOT NULL) THEN
1161: gme_common_pvt.log_message('GME_FIELD_VALUE_REQUIRED','FIELD_NAME', 'actual_rsrc_count');
1162: RAISE input_param_missing;
1163: END IF;
1164: END IF;
1165:

Line 1168: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'

1164: END IF;
1165:
1166: IF p_batchstep_resource_rec.plan_rsrc_usage = fnd_api.g_miss_num
1167: AND l_step_status = 1 THEN
1168: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'
1169: ,'FIELD_NAME'
1170: ,'plan_rsrc_usage');
1171: RAISE input_param_missing;
1172: ELSIF p_batchstep_resource_rec.plan_rsrc_usage IS NOT NULL THEN

Line 1174: gme_common_pvt.log_message ('GME_INV_ACT_STEP_STATUS'

1170: ,'plan_rsrc_usage');
1171: RAISE input_param_missing;
1172: ELSIF p_batchstep_resource_rec.plan_rsrc_usage IS NOT NULL THEN
1173: IF l_step_status = 3 THEN
1174: gme_common_pvt.log_message ('GME_INV_ACT_STEP_STATUS'
1175: ,'FIELD'
1176: ,'plan_rsrc_usage');
1177: RAISE invalid_action;
1178: ELSIF (l_step_status = 2 OR l_batch_asqc = 1) THEN

Line 1179: gme_common_pvt.log_message ('GME_UPD_NT_ALLOWED'

1175: ,'FIELD'
1176: ,'plan_rsrc_usage');
1177: RAISE invalid_action;
1178: ELSIF (l_step_status = 2 OR l_batch_asqc = 1) THEN
1179: gme_common_pvt.log_message ('GME_UPD_NT_ALLOWED'
1180: ,'FIELD'
1181: ,'plan_rsrc_usage');
1182: RAISE invalid_action;
1183: ELSIF (p_batchstep_resource_rec.plan_rsrc_usage <>

Line 1194: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'

1190:
1191: IF p_batchstep_resource_rec.actual_rsrc_usage =
1192: fnd_api.g_miss_num
1193: AND l_step_status = 3 THEN
1194: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'
1195: ,'FIELD_NAME'
1196: ,'actual_rsrc_usage');
1197: RAISE input_param_missing;
1198: ELSIF p_batchstep_resource_rec.actual_rsrc_usage IS NOT NULL THEN

Line 1200: gme_common_pvt.log_message ('GME_INV_ACT_STEP_STATUS'

1196: ,'actual_rsrc_usage');
1197: RAISE input_param_missing;
1198: ELSIF p_batchstep_resource_rec.actual_rsrc_usage IS NOT NULL THEN
1199: IF l_step_status = 1 THEN
1200: gme_common_pvt.log_message ('GME_INV_ACT_STEP_STATUS'
1201: ,'FIELD'
1202: ,'actual_rsrc_usage');
1203: RAISE invalid_action;
1204: ELSIF (l_batch_asqc = 1) THEN

Line 1206: gme_common_pvt.log_message ('GME_UPD_RSRC_NT_WRK_ASQCBTCH');

1202: ,'actual_rsrc_usage');
1203: RAISE invalid_action;
1204: ELSIF (l_batch_asqc = 1) THEN
1205: --Pawan Kumar changed the token
1206: gme_common_pvt.log_message ('GME_UPD_RSRC_NT_WRK_ASQCBTCH');
1207: RAISE invalid_action;
1208: --Pawan Kumar added nvl for proper update
1209: ELSIF (p_batchstep_resource_rec.actual_rsrc_usage <>
1210: NVL (l_batchstep_resource_rec.actual_rsrc_usage

Line 1221: gme_common_pvt.log_message('GME_FIELD_VALUE_REQUIRED','FIELD_NAME', 'actual_rsrc_count');

1217: /* When the actual resource count is null in the database and we are trying to update actual resource usage without the
1218: actual resource count, then user will be given error message that actual resource count is required.*/
1219: ELSE
1220: IF (l_batchstep_resource_rec.actual_rsrc_count IS NULL AND p_batchstep_resource_rec.actual_rsrc_usage IS NOT NULL) THEN
1221: gme_common_pvt.log_message('GME_FIELD_VALUE_REQUIRED','FIELD_NAME', 'actual_rsrc_count');
1222: RAISE input_param_missing;
1223: END IF;
1224: END IF;
1225:

Line 1229: gme_common_pvt.log_message ('GME_UPD_NT_ALLOWED'

1225:
1226: IF ( p_batchstep_resource_rec.usage_um IS NOT NULL
1227: AND p_batchstep_resource_rec.usage_um <>
1228: l_batchstep_resource_rec.usage_um) THEN
1229: gme_common_pvt.log_message ('GME_UPD_NT_ALLOWED'
1230: ,'FIELD'
1231: ,'usage_uom');
1232: RAISE error_condition;
1233: END IF;

Line 1237: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'

1233: END IF;
1234:
1235: IF p_batchstep_resource_rec.plan_rsrc_qty = fnd_api.g_miss_num
1236: AND l_step_status = 1 THEN
1237: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'
1238: ,'FIELD_NAME'
1239: ,'plan_rsrc_qty');
1240: RAISE input_param_missing;
1241: ELSIF (p_batchstep_resource_rec.plan_rsrc_qty IS NOT NULL) THEN

Line 1243: gme_common_pvt.log_message ('GME_ASQC_NO_PLAN_RSRC_QTY');

1239: ,'plan_rsrc_qty');
1240: RAISE input_param_missing;
1241: ELSIF (p_batchstep_resource_rec.plan_rsrc_qty IS NOT NULL) THEN
1242: IF l_batch_asqc = 1 THEN
1243: gme_common_pvt.log_message ('GME_ASQC_NO_PLAN_RSRC_QTY');
1244: RAISE error_condition;
1245: ELSIF l_step_status = 3 THEN
1246: gme_common_pvt.log_message ('GME_INV_ACT_STEP_STATUS'
1247: ,'FIELD'

Line 1246: gme_common_pvt.log_message ('GME_INV_ACT_STEP_STATUS'

1242: IF l_batch_asqc = 1 THEN
1243: gme_common_pvt.log_message ('GME_ASQC_NO_PLAN_RSRC_QTY');
1244: RAISE error_condition;
1245: ELSIF l_step_status = 3 THEN
1246: gme_common_pvt.log_message ('GME_INV_ACT_STEP_STATUS'
1247: ,'FIELD'
1248: ,'plan_rsrc_qty');
1249: RAISE invalid_action;
1250: ELSIF (l_step_status = 2 OR l_batch_asqc = 1) THEN

Line 1251: gme_common_pvt.log_message ('GME_UPD_NT_ALLOWED'

1247: ,'FIELD'
1248: ,'plan_rsrc_qty');
1249: RAISE invalid_action;
1250: ELSIF (l_step_status = 2 OR l_batch_asqc = 1) THEN
1251: gme_common_pvt.log_message ('GME_UPD_NT_ALLOWED'
1252: ,'FIELD'
1253: ,'plan_rsrc_qty');
1254: RAISE invalid_action;
1255: ELSIF (p_batchstep_resource_rec.plan_rsrc_qty <>

Line 1265: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'

1261: END IF;
1262:
1263: IF p_batchstep_resource_rec.actual_rsrc_qty = fnd_api.g_miss_num
1264: AND l_step_status = 3 THEN
1265: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'
1266: ,'FIELD_NAME'
1267: ,'actual_rsrc_qty');
1268: RAISE input_param_missing;
1269: ELSIF p_batchstep_resource_rec.actual_rsrc_qty IS NOT NULL THEN

Line 1271: gme_common_pvt.log_message ('GME_ASQC_NO_ACT_RSRC_QTY');

1267: ,'actual_rsrc_qty');
1268: RAISE input_param_missing;
1269: ELSIF p_batchstep_resource_rec.actual_rsrc_qty IS NOT NULL THEN
1270: IF l_batch_asqc = 1 THEN
1271: gme_common_pvt.log_message ('GME_ASQC_NO_ACT_RSRC_QTY');
1272: RAISE error_condition;
1273: ELSIF l_step_status = 1 THEN
1274: gme_common_pvt.log_message ('GME_INV_ACT_STEP_STATUS'
1275: ,'FIELD'

Line 1274: gme_common_pvt.log_message ('GME_INV_ACT_STEP_STATUS'

1270: IF l_batch_asqc = 1 THEN
1271: gme_common_pvt.log_message ('GME_ASQC_NO_ACT_RSRC_QTY');
1272: RAISE error_condition;
1273: ELSIF l_step_status = 1 THEN
1274: gme_common_pvt.log_message ('GME_INV_ACT_STEP_STATUS'
1275: ,'FIELD'
1276: ,'actual_rsrc_qty');
1277: RAISE invalid_action;
1278: --Pawan Kumar added nvl for proper update

Line 1291: gme_common_pvt.log_message ('GME_UPD_NT_ALLOWED'

1287:
1288: IF ( p_batchstep_resource_rec.resource_qty_um IS NOT NULL
1289: AND p_batchstep_resource_rec.resource_qty_um <>
1290: l_batchstep_resource_rec.resource_qty_um) THEN
1291: gme_common_pvt.log_message ('GME_UPD_NT_ALLOWED'
1292: ,'FIELD'
1293: ,'resource_qty_uom');
1294: RAISE error_condition;
1295: END IF;

Line 1303: gme_common_pvt.log_message ('PM_BADSTARTDATE');

1299: AND p_batchstep_resource_rec.plan_cmplt_date IS NOT NULL
1300: AND l_step_status = 1 THEN
1301: IF p_batchstep_resource_rec.plan_start_date >
1302: p_batchstep_resource_rec.plan_cmplt_date THEN
1303: gme_common_pvt.log_message ('PM_BADSTARTDATE');
1304: RAISE invalid_date;
1305: END IF;
1306:
1307: IF NOT (date_within_activity_dates

Line 1311: gme_common_pvt.log_message

1307: IF NOT (date_within_activity_dates
1308: (l_activity_id
1309: ,l_step_status
1310: ,p_batchstep_resource_rec.plan_start_date) ) THEN
1311: gme_common_pvt.log_message
1312: ('GME_RSRC_DATES_NOT_ALLOWED'
1313: ,'RESOURCE'
1314: ,p_batchstep_resource_rec.resources);
1315: RAISE date_outside_range;

Line 1326: gme_common_pvt.log_message

1322: IF NOT (date_within_activity_dates
1323: (l_activity_id
1324: ,l_step_status
1325: ,p_batchstep_resource_rec.plan_cmplt_date) ) THEN
1326: gme_common_pvt.log_message
1327: ('GME_RSRC_DATES_NOT_ALLOWED'
1328: ,'RESOURCE'
1329: ,p_batchstep_resource_rec.resources);
1330: RAISE date_outside_range;

Line 1342: gme_common_pvt.log_message

1338: IF NOT (date_within_activity_dates
1339: (l_activity_id
1340: ,1
1341: ,p_batchstep_resource_rec.plan_start_date) ) THEN
1342: gme_common_pvt.log_message
1343: ('GME_RSRC_DATES_NOT_ALLOWED'
1344: ,'RESOURCE'
1345: ,p_batchstep_resource_rec.resources);
1346: RAISE date_outside_range;

Line 1352: gme_common_pvt.log_message ('PM_BADSTARTDATE');

1348:
1349: IF l_batchstep_resource_rec.plan_cmplt_date IS NOT NULL
1350: AND p_batchstep_resource_rec.plan_start_date >
1351: l_batchstep_resource_rec.plan_cmplt_date THEN
1352: gme_common_pvt.log_message ('PM_BADSTARTDATE');
1353: RAISE invalid_date;
1354: END IF;
1355:
1356: l_field_updated := TRUE;

Line 1366: gme_common_pvt.log_message

1362: IF NOT (date_within_activity_dates
1363: (l_activity_id
1364: ,1
1365: ,p_batchstep_resource_rec.plan_cmplt_date) ) THEN
1366: gme_common_pvt.log_message
1367: ('GME_RSRC_DATES_NOT_ALLOWED'
1368: ,'RESOURCE'
1369: ,p_batchstep_resource_rec.resources);
1370: RAISE date_outside_range;

Line 1376: gme_common_pvt.log_message ('PM_BADSTARTDATE');

1372:
1373: IF l_batchstep_resource_rec.plan_start_date IS NOT NULL
1374: AND l_batchstep_resource_rec.plan_start_date >
1375: p_batchstep_resource_rec.plan_cmplt_date THEN
1376: gme_common_pvt.log_message ('PM_BADSTARTDATE');
1377: RAISE invalid_date;
1378: END IF;
1379:
1380: l_field_updated := TRUE;

Line 1392: gme_common_pvt.log_message ('PM_BADSTARTDATE');

1388: AND p_batchstep_resource_rec.actual_cmplt_date IS NOT NULL
1389: AND l_step_status = 3 THEN
1390: IF p_batchstep_resource_rec.actual_start_date >
1391: p_batchstep_resource_rec.actual_cmplt_date THEN
1392: gme_common_pvt.log_message ('PM_BADSTARTDATE');
1393: RAISE invalid_date;
1394: END IF;
1395:
1396: IF p_batchstep_resource_rec.actual_start_date =

Line 1398: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'

1394: END IF;
1395:
1396: IF p_batchstep_resource_rec.actual_start_date =
1397: fnd_api.g_miss_date THEN
1398: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'
1399: ,'FIELD_NAME'
1400: ,'actual_start_date');
1401: RAISE input_param_missing;
1402: END IF;

Line 1408: gme_common_pvt.log_message

1404: IF NOT (date_within_activity_dates
1405: (l_activity_id
1406: ,3
1407: ,p_batchstep_resource_rec.actual_start_date) ) THEN
1408: gme_common_pvt.log_message
1409: ('GME_RSRC_DATES_NOT_ALLOWED'
1410: ,'RESOURCE'
1411: ,p_batchstep_resource_rec.resources);
1412: RAISE date_outside_range;

Line 1421: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'

1417: p_batchstep_resource_rec.actual_start_date;
1418:
1419: IF p_batchstep_resource_rec.actual_cmplt_date =
1420: fnd_api.g_miss_date THEN
1421: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'
1422: ,'FIELD_NAME'
1423: ,'actual_cmplt_date');
1424: RAISE input_param_missing;
1425: END IF;

Line 1431: gme_common_pvt.log_message

1427: IF NOT (date_within_activity_dates
1428: (l_activity_id
1429: ,3
1430: ,p_batchstep_resource_rec.actual_cmplt_date) ) THEN
1431: gme_common_pvt.log_message
1432: ('GME_RSRC_DATES_NOT_ALLOWED'
1433: ,'RESOURCE'
1434: ,p_batchstep_resource_rec.resources);
1435: RAISE date_outside_range;

Line 1445: gme_common_pvt.log_message

1441: ELSE
1442: IF p_batchstep_resource_rec.actual_start_date IS NOT NULL THEN
1443: IF p_batchstep_resource_rec.actual_start_date =
1444: fnd_api.g_miss_date THEN
1445: gme_common_pvt.log_message
1446: ('GME_FIELD_VALUE_REQUIRED'
1447: ,'FIELD_NAME'
1448: ,'actual_start_date');
1449: RAISE input_param_missing;

Line 1454: gme_common_pvt.g_timestamp THEN

1450: END IF;
1451:
1452: --Pawan Kumar added code for actual start date
1453: IF p_batchstep_resource_rec.actual_start_date >
1454: gme_common_pvt.g_timestamp THEN
1455: fnd_message.set_name ('GMA', 'SY_NOFUTUREDATE');
1456: fnd_msg_pub.ADD;
1457: RAISE date_outside_range;
1458: END IF;

Line 1464: gme_common_pvt.log_message

1460: IF NOT (date_within_activity_dates
1461: (l_activity_id
1462: ,3
1463: ,p_batchstep_resource_rec.actual_start_date) ) THEN
1464: gme_common_pvt.log_message
1465: ('GME_RSRC_DATES_NOT_ALLOWED'
1466: ,'RESOURCE'
1467: ,p_batchstep_resource_rec.resources);
1468: RAISE date_outside_range;

Line 1474: gme_common_pvt.log_message ('PM_BADSTARTDATE');

1470:
1471: IF l_batchstep_resource_rec.actual_cmplt_date IS NOT NULL
1472: AND p_batchstep_resource_rec.actual_start_date >
1473: l_batchstep_resource_rec.actual_cmplt_date THEN
1474: gme_common_pvt.log_message ('PM_BADSTARTDATE');
1475: RAISE invalid_date;
1476: END IF;
1477:
1478: l_field_updated := TRUE;

Line 1487: gme_common_pvt.log_message

1483: IF ( p_batchstep_resource_rec.actual_cmplt_date IS NOT NULL
1484: AND l_step_status = 3) THEN
1485: IF p_batchstep_resource_rec.actual_cmplt_date =
1486: fnd_api.g_miss_date THEN
1487: gme_common_pvt.log_message
1488: ('GME_FIELD_VALUE_REQUIRED'
1489: ,'FIELD_NAME'
1490: ,'actual_cmplt_date');
1491: RAISE input_param_missing;

Line 1498: gme_common_pvt.log_message

1494: IF NOT (date_within_activity_dates
1495: (l_activity_id
1496: ,3
1497: ,p_batchstep_resource_rec.actual_cmplt_date) ) THEN
1498: gme_common_pvt.log_message
1499: ('GME_RSRC_DATES_NOT_ALLOWED'
1500: ,'RESOURCE'
1501: ,p_batchstep_resource_rec.resources);
1502: RAISE date_outside_range;

Line 1508: gme_common_pvt.log_message ('PM_BADSTARTDATE');

1504:
1505: IF l_batchstep_resource_rec.actual_start_date IS NOT NULL
1506: AND p_batchstep_resource_rec.actual_cmplt_date <
1507: l_batchstep_resource_rec.actual_start_date THEN
1508: gme_common_pvt.log_message ('PM_BADSTARTDATE');
1509: RAISE invalid_date;
1510: END IF;
1511:
1512: l_field_updated := TRUE;

Line 1543: IF gme_common_pvt.is_qty_below_capacity

1539: END IF;
1540: END IF; -- l_step_status IN 1,2
1541: END IF; -- l_step_status IN 1,2,3
1542:
1543: IF gme_common_pvt.is_qty_below_capacity
1544: (p_batch_step_resources_rec => l_batchstep_resource_rec) THEN
1545: gme_common_pvt.log_message ('GME_RESOURCE_PROCESS_QUANTITY'
1546: ,'RESOURCE'
1547: ,l_batchstep_resource_rec.resources);

Line 1545: gme_common_pvt.log_message ('GME_RESOURCE_PROCESS_QUANTITY'

1541: END IF; -- l_step_status IN 1,2,3
1542:
1543: IF gme_common_pvt.is_qty_below_capacity
1544: (p_batch_step_resources_rec => l_batchstep_resource_rec) THEN
1545: gme_common_pvt.log_message ('GME_RESOURCE_PROCESS_QUANTITY'
1546: ,'RESOURCE'
1547: ,l_batchstep_resource_rec.resources);
1548:
1549: IF p_ignore_qty_below_cap = fnd_api.g_false THEN

Line 1739: ,last_update_date = gme_common_pvt.g_timestamp

1735: AND l_batchstep_resource_rec.max_capacity < l_max_step_capacity) THEN
1736: -- CALL DBL with updated max_capacity
1737: UPDATE gme_batch_steps
1738: SET max_step_capacity = l_batchstep_resource_rec.max_capacity
1739: ,last_update_date = gme_common_pvt.g_timestamp
1740: ,last_updated_by = gme_common_pvt.g_user_ident
1741: ,last_update_login = gme_common_pvt.g_login_id
1742: WHERE batchstep_id = l_batchstep_resource_rec.batchstep_id
1743: AND batch_id = l_batchstep_resource_rec.batch_id;

Line 1740: ,last_updated_by = gme_common_pvt.g_user_ident

1736: -- CALL DBL with updated max_capacity
1737: UPDATE gme_batch_steps
1738: SET max_step_capacity = l_batchstep_resource_rec.max_capacity
1739: ,last_update_date = gme_common_pvt.g_timestamp
1740: ,last_updated_by = gme_common_pvt.g_user_ident
1741: ,last_update_login = gme_common_pvt.g_login_id
1742: WHERE batchstep_id = l_batchstep_resource_rec.batchstep_id
1743: AND batch_id = l_batchstep_resource_rec.batch_id;
1744: END IF;

Line 1741: ,last_update_login = gme_common_pvt.g_login_id

1737: UPDATE gme_batch_steps
1738: SET max_step_capacity = l_batchstep_resource_rec.max_capacity
1739: ,last_update_date = gme_common_pvt.g_timestamp
1740: ,last_updated_by = gme_common_pvt.g_user_ident
1741: ,last_update_login = gme_common_pvt.g_login_id
1742: WHERE batchstep_id = l_batchstep_resource_rec.batchstep_id
1743: AND batch_id = l_batchstep_resource_rec.batch_id;
1744: END IF;
1745: END IF;

Line 1884: gme_common_pvt.log_message ('GME_INVALID_RSRC_ID');

1880:
1881: IF cur_get_step_dtl%NOTFOUND THEN
1882: CLOSE cur_get_step_dtl;
1883:
1884: gme_common_pvt.log_message ('GME_INVALID_RSRC_ID');
1885: RAISE rsrc_not_valid;
1886: END IF;
1887:
1888: CLOSE cur_get_step_dtl;

Line 1899: gme_common_pvt.log_message ('GME_FPO_RSRC_NO_EDIT');

1895:
1896: IF cur_validate_batch_type%FOUND THEN
1897: CLOSE cur_validate_batch_type;
1898:
1899: gme_common_pvt.log_message ('GME_FPO_RSRC_NO_EDIT');
1900: RAISE rsrc_not_valid;
1901: END IF;
1902:
1903: CLOSE cur_validate_batch_type;

Line 2045: gme_common_pvt.log_message ('GME_BATCH_NOT_FOUND');

2041: l_batch_header.batch_id := p_batchstep_resource_rec.batch_id;
2042:
2043: IF NOT gme_batch_header_dbl.fetch_row (p_batch_header => l_batch_header
2044: ,x_batch_header => l_batch_header) THEN
2045: gme_common_pvt.log_message ('GME_BATCH_NOT_FOUND');
2046: RAISE error_condition;
2047: END IF;
2048:
2049: IF l_batch_header.update_inventory_ind = 'Y' THEN