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 140: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'

136: /* Initially let us assign the return status to success */
137: x_return_status := fnd_api.g_ret_sts_success;
138:
139: IF p_org_code IS NULL THEN
140: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'
141: ,'FIELD_NAME'
142: ,'ORGANIZATION');
143: RAISE input_param_missing;
144: ELSIF p_batch_no IS NULL THEN

Line 145: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'

141: ,'FIELD_NAME'
142: ,'ORGANIZATION');
143: RAISE input_param_missing;
144: ELSIF p_batch_no IS NULL THEN
145: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'
146: ,'FIELD_NAME'
147: ,'BATCH NUMBER');
148: RAISE input_param_missing;
149: ELSIF p_batchstep_no IS NULL THEN

Line 150: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'

146: ,'FIELD_NAME'
147: ,'BATCH NUMBER');
148: RAISE input_param_missing;
149: ELSIF p_batchstep_no IS NULL THEN
150: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'
151: ,'FIELD_NAME'
152: ,'BATCH STEP NUMBER');
153: RAISE input_param_missing;
154: ELSIF p_activity IS NULL THEN

Line 155: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'

151: ,'FIELD_NAME'
152: ,'BATCH STEP NUMBER');
153: RAISE input_param_missing;
154: ELSIF p_activity IS NULL THEN
155: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'
156: ,'FIELD_NAME'
157: ,'ACTIVITY');
158: RAISE input_param_missing;
159: END IF;

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

166:
167: IF cur_get_batch_dtl%NOTFOUND THEN
168: CLOSE cur_get_batch_dtl;
169:
170: gme_common_pvt.log_message ('GME_BATCH_NOT_FOUND');
171: RAISE batch_not_found;
172: END IF;
173:
174: CLOSE cur_get_batch_dtl;

Line 188: gme_common_pvt.log_message ('GME_BATCH_STEP_NOT_FOUND'

184:
185: IF cur_get_batchstep_dtl%NOTFOUND THEN
186: CLOSE cur_get_batchstep_dtl;
187:
188: gme_common_pvt.log_message ('GME_BATCH_STEP_NOT_FOUND'
189: ,'STEP_ID'
190: ,p_batchstep_no);
191: RAISE batchstep_not_found;
192: END IF;

Line 228: gme_common_pvt.log_message ('GME_STEP_ACTIVITY_NOT_FOUND'

224: EXIT;
225: END IF;
226: END IF;
227: ELSE
228: gme_common_pvt.log_message ('GME_STEP_ACTIVITY_NOT_FOUND'
229: ,'ACTIVITY'
230: ,p_activity
231: ,'STEP_NO'
232: ,p_batchstep_no);

Line 239: gme_common_pvt.log_message ('GME_RSRC_NOT_FOUND'

235: END LOOP;
236:
237: -- If resource was not found in any activity then report error
238: IF l_rsrc_not_found THEN
239: gme_common_pvt.log_message ('GME_RSRC_NOT_FOUND'
240: ,'RESOURCE'
241: ,p_resource
242: ,'ACTIVITY'
243: ,p_activity);

Line 416: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'

412: || p_batchstep_resource_rec.cost_analysis_code);
413: END IF;
414:
415: IF p_batchstep_resource_rec.cost_analysis_code IS NULL THEN
416: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'
417: ,'FIELD_NAME'
418: ,'COST_ANALYSIS_CODE');
419: RAISE input_param_missing;
420: ELSE

Line 448: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'

444: || p_batchstep_resource_rec.cost_cmpntcls_id);
445: END IF;
446:
447: IF p_batchstep_resource_rec.cost_cmpntcls_id IS NULL THEN
448: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'
449: ,'FIELD_NAME'
450: ,'COST_COMPONENT_CLASS_ID');
451: RAISE input_param_missing;
452: ELSE

Line 481: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'

477: || p_batchstep_resource_rec.scale_type);
478: END IF;
479:
480: IF p_batchstep_resource_rec.scale_type IS NULL THEN
481: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'
482: ,'FIELD_NAME'
483: ,'SCALE_TYPE');
484: RAISE input_param_missing;
485: ELSIF (NOT (lookup_code_valid ('GMD_RESOURCE_SCALE_TYPE'

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

483: ,'SCALE_TYPE');
484: RAISE input_param_missing;
485: ELSIF (NOT (lookup_code_valid ('GMD_RESOURCE_SCALE_TYPE'
486: ,p_batchstep_resource_rec.scale_type) ) ) THEN
487: gme_common_pvt.log_message ('GME_INVALID_SCALE_TYPE');
488: RAISE invalid_scale_type;
489: END IF;
490:
491: -- prim rsrc ind

Line 501: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'

497: || p_batchstep_resource_rec.prim_rsrc_ind);
498: END IF;
499:
500: IF p_batchstep_resource_rec.prim_rsrc_ind IS NULL THEN
501: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'
502: ,'FIELD_NAME'
503: ,'Primary_Resource Indicator');
504: RAISE input_param_missing;
505: ELSIF (NOT (lookup_code_valid ('GMD_PRIM_RSRC_IND'

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

503: ,'Primary_Resource Indicator');
504: RAISE input_param_missing;
505: ELSIF (NOT (lookup_code_valid ('GMD_PRIM_RSRC_IND'
506: ,p_batchstep_resource_rec.prim_rsrc_ind) ) ) THEN
507: gme_common_pvt.log_message ('GME_INV_PRM_RSRC_IND');
508: RAISE invalid_prim_rsrc_ind;
509: END IF;
510:
511: l_batchstep_resource_rec := p_batchstep_resource_rec;

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

533: || l_step_status);
534: END IF;
535:
536: IF l_step_status IN (4, 5) THEN
537: gme_common_pvt.log_message ('PC_STEP_STATUS_ERR');
538: RAISE invalid_step_status;
539: END IF;
540:
541: -- check ASQC property

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

546:
547: CLOSE cur_get_batch_asqc;
548:
549: IF l_batch_asqc = 1 AND l_step_status = 2 THEN
550: gme_common_pvt.log_message ('GME_INVALID_ASQC_ACTION');
551: RAISE invalid_asqc;
552: END IF;
553:
554: x_step_status := l_step_status;

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

581: || l_activity_factor);
582: END IF;
583:
584: IF l_activity_factor <= 0 THEN
585: gme_common_pvt.log_message ('GME_INVALID_ACTIVITY_FACTOR');
586: RAISE invalid_activity_factor;
587: END IF;
588:
589: -- check for count and usage values

Line 608: gme_common_pvt.log_message ('GME_INVALID_FIELD'

604: END IF;
605:
606: IF p_batchstep_resource_rec.plan_rsrc_count <>
607: l_batchstep_resource_rec.plan_rsrc_count THEN
608: gme_common_pvt.log_message ('GME_INVALID_FIELD'
609: ,'FIELD'
610: ,'plan_rsrc_count');
611: RAISE error_condition;
612: END IF;

Line 630: gme_common_pvt.log_message ('GME_INVALID_FIELD'

626: END IF;
627:
628: IF p_batchstep_resource_rec.actual_rsrc_count <>
629: l_batchstep_resource_rec.actual_rsrc_count THEN
630: gme_common_pvt.log_message ('GME_INVALID_FIELD'
631: ,'FIELD'
632: ,'actual_rsrc_count');
633: RAISE error_condition;
634: END IF;

Line 658: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'

654: END IF;
655:
656: IF l_step_status = 1 THEN
657: IF l_batchstep_resource_rec.plan_rsrc_count IS NULL THEN
658: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'
659: ,'FIELD_NAME'
660: ,'plan_rsrc_count');
661: RAISE input_param_missing;
662: END IF;

Line 665: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'

661: RAISE input_param_missing;
662: END IF;
663:
664: IF p_batchstep_resource_rec.plan_rsrc_usage IS NULL THEN
665: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'
666: ,'FIELD_NAME'
667: ,'plan_rsrc_usage');
668: RAISE input_param_missing;
669: END IF;

Line 673: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'

669: END IF;
670:
671: IF (l_batch_asqc = 0) THEN
672: IF p_batchstep_resource_rec.plan_rsrc_qty IS NULL THEN
673: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'
674: ,'FIELD_NAME'
675: ,'plan_rsrc_qty');
676: RAISE input_param_missing;
677: END IF;

Line 680: gme_common_pvt.log_message ('GME_INPUT_PARAM_IGNORED'

676: RAISE input_param_missing;
677: END IF;
678: ELSE
679: IF p_batchstep_resource_rec.plan_rsrc_qty IS NOT NULL THEN
680: gme_common_pvt.log_message ('GME_INPUT_PARAM_IGNORED'
681: ,'FIELD'
682: ,'plan_rsrc_qty');
683: END IF;
684: END IF;

Line 687: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'

683: END IF;
684: END IF;
685: ELSIF l_step_status IN (2, 3) THEN
686: IF l_batchstep_resource_rec.actual_rsrc_count IS NULL THEN
687: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'
688: ,'FIELD_NAME'
689: ,'actual_rsrc_count');
690: RAISE input_param_missing;
691: END IF;

Line 694: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'

690: RAISE input_param_missing;
691: END IF;
692:
693: IF p_batchstep_resource_rec.actual_rsrc_usage IS NULL THEN
694: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'
695: ,'FIELD_NAME'
696: ,'actual_rsrc_usage');
697: RAISE input_param_missing;
698: END IF;

Line 702: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'

698: END IF;
699:
700: IF (l_batch_asqc = 0) THEN
701: IF (p_batchstep_resource_rec.actual_rsrc_qty IS NULL) THEN
702: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'
703: ,'FIELD_NAME'
704: ,'actual_rsrc_qty');
705: RAISE input_param_missing;
706: END IF;

Line 709: gme_common_pvt.log_message ('GME_INPUT_PARAM_IGNORED'

705: RAISE input_param_missing;
706: END IF;
707: ELSE
708: IF p_batchstep_resource_rec.actual_rsrc_qty IS NOT NULL THEN
709: gme_common_pvt.log_message ('GME_INPUT_PARAM_IGNORED'
710: ,'FIELD'
711: ,'actual_rsrc_qty');
712: END IF;
713: END IF;

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

727: AND p_batchstep_resource_rec.plan_cmplt_date IS NOT NULL
728: AND l_step_status = 1 THEN
729: IF p_batchstep_resource_rec.plan_start_date >
730: p_batchstep_resource_rec.plan_cmplt_date THEN
731: gme_common_pvt.log_message ('PM_BADSTARTDATE');
732: RAISE invalid_date;
733: END IF;
734:
735: IF NOT (date_within_activity_dates

Line 739: gme_common_pvt.log_message

735: IF NOT (date_within_activity_dates
736: (l_activity_id
737: ,1
738: ,p_batchstep_resource_rec.plan_start_date) ) THEN
739: gme_common_pvt.log_message
740: ('GME_RSRC_DATES_NOT_ALLOWED'
741: ,'RESOURCE'
742: ,p_batchstep_resource_rec.resources);
743: RAISE date_outside_range;

Line 753: gme_common_pvt.log_message

749: IF NOT (date_within_activity_dates
750: (l_activity_id
751: ,1
752: ,p_batchstep_resource_rec.plan_cmplt_date) ) THEN
753: gme_common_pvt.log_message
754: ('GME_RSRC_DATES_NOT_ALLOWED'
755: ,'RESOURCE'
756: ,p_batchstep_resource_rec.resources);
757: RAISE date_outside_range;

Line 772: gme_common_pvt.log_message

768: IF NOT (date_within_activity_dates
769: (l_activity_id
770: ,1
771: ,p_batchstep_resource_rec.plan_start_date) ) THEN
772: gme_common_pvt.log_message
773: ('GME_RSRC_DATES_NOT_ALLOWED'
774: ,'RESOURCE'
775: ,p_batchstep_resource_rec.resources);
776: RAISE date_outside_range;

Line 792: gme_common_pvt.log_message

788: IF NOT (date_within_activity_dates
789: (l_activity_id
790: ,1
791: ,p_batchstep_resource_rec.plan_cmplt_date) ) THEN
792: gme_common_pvt.log_message
793: ('GME_RSRC_DATES_NOT_ALLOWED'
794: ,'RESOURCE'
795: ,p_batchstep_resource_rec.resources);
796: RAISE date_outside_range;

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

806: AND p_batchstep_resource_rec.actual_cmplt_date IS NOT NULL
807: AND l_step_status = 3 THEN
808: IF p_batchstep_resource_rec.actual_start_date >
809: p_batchstep_resource_rec.actual_cmplt_date THEN
810: gme_common_pvt.log_message ('PM_BADSTARTDATE');
811: RAISE invalid_date;
812: END IF;
813:
814: IF NOT (date_within_activity_dates

Line 818: gme_common_pvt.log_message

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

Line 832: gme_common_pvt.log_message

828: IF NOT (date_within_activity_dates
829: (l_activity_id
830: ,3
831: ,p_batchstep_resource_rec.actual_cmplt_date) ) THEN
832: gme_common_pvt.log_message
833: ('GME_RSRC_DATES_NOT_ALLOWED'
834: ,'RESOURCE'
835: ,p_batchstep_resource_rec.resources);
836: RAISE date_outside_range;

Line 847: gme_common_pvt.g_timestamp THEN

843: l_batchstep_resource_rec.actual_start_date :=
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;

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_start_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 875: gme_common_pvt.g_timestamp THEN

871: l_act_actual_cmplt_date;
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;

Line 885: gme_common_pvt.log_message

881: IF NOT (date_within_activity_dates
882: (l_activity_id
883: ,3
884: ,p_batchstep_resource_rec.actual_cmplt_date) ) THEN
885: gme_common_pvt.log_message
886: ('GME_RSRC_DATES_NOT_ALLOWED'
887: ,'RESOURCE'
888: ,p_batchstep_resource_rec.resources);
889: RAISE date_outside_range;

Line 917: IF gme_common_pvt.is_qty_below_capacity

913: l_batchstep_resource_rec.plan_rsrc_usage := NULL;
914: l_batchstep_resource_rec.plan_rsrc_qty := NULL;
915: END IF;
916:
917: IF gme_common_pvt.is_qty_below_capacity
918: (p_batch_step_resources_rec => l_batchstep_resource_rec) THEN
919: gme_common_pvt.log_message ('GME_RESOURCE_PROCESS_QUANTITY'
920: ,'RESOURCE'
921: ,l_batchstep_resource_rec.resources);

Line 919: gme_common_pvt.log_message ('GME_RESOURCE_PROCESS_QUANTITY'

915: END IF;
916:
917: IF gme_common_pvt.is_qty_below_capacity
918: (p_batch_step_resources_rec => l_batchstep_resource_rec) THEN
919: gme_common_pvt.log_message ('GME_RESOURCE_PROCESS_QUANTITY'
920: ,'RESOURCE'
921: ,l_batchstep_resource_rec.resources);
922:
923: IF p_ignore_qty_below_cap = fnd_api.g_false THEN

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

951: RAISE error_condition;
952: END IF;
953:
954: IF l_step_status IN (4, 5) THEN
955: gme_common_pvt.log_message ('PC_STEP_STATUS_ERR');
956: RAISE invalid_step_status;
957: END IF;
958:
959: IF NOT (gme_batch_step_resources_dbl.fetch_row

Line 974: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'

970: CLOSE cur_get_batch_asqc;
971:
972: /* Bug 3620264 - compare analysis code to G_MISS_CHAR instead of G_MISS_NUM */
973: IF p_batchstep_resource_rec.cost_analysis_code = fnd_api.g_miss_char THEN
974: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'
975: ,'FIELD_NAME'
976: ,'COST_ANALYSIS_CODE');
977: RAISE input_param_missing;
978: ELSIF ( p_batchstep_resource_rec.cost_analysis_code IS NOT NULL

Line 1003: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'

999: p_batchstep_resource_rec.cost_analysis_code;
1000: END IF;
1001:
1002: IF p_batchstep_resource_rec.cost_cmpntcls_id = fnd_api.g_miss_num THEN
1003: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'
1004: ,'FIELD_NAME'
1005: ,'COST_COMPONENT_CLASS_ID');
1006: RAISE input_param_missing;
1007: ELSIF ( p_batchstep_resource_rec.cost_cmpntcls_id IS NOT NULL

Line 1033: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'

1029: p_batchstep_resource_rec.cost_cmpntcls_id;
1030: END IF;
1031:
1032: IF p_batchstep_resource_rec.scale_type = fnd_api.g_miss_num THEN
1033: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'
1034: ,'FIELD_NAME'
1035: ,'scale_type');
1036: RAISE input_param_missing;
1037: ELSIF ( p_batchstep_resource_rec.scale_type IS NOT NULL

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

1038: AND (l_batchstep_resource_rec.scale_type <>
1039: p_batchstep_resource_rec.scale_type) ) THEN
1040: IF (NOT (lookup_code_valid ('GMD_RESOURCE_SCALE_TYPE'
1041: ,p_batchstep_resource_rec.scale_type) ) ) THEN
1042: gme_common_pvt.log_message ('GME_INVALID_SCALE_TYPE');
1043: RAISE invalid_scale_type;
1044: END IF;
1045:
1046: l_field_updated := TRUE;

Line 1052: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'

1048: p_batchstep_resource_rec.scale_type;
1049: END IF;
1050:
1051: IF p_batchstep_resource_rec.prim_rsrc_ind = fnd_api.g_miss_num THEN
1052: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'
1053: ,'FIELD_NAME'
1054: ,'prim_rsrc_ind');
1055: RAISE input_param_missing;
1056: ELSIF ( p_batchstep_resource_rec.prim_rsrc_ind IS NOT NULL

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

1057: AND (l_batchstep_resource_rec.prim_rsrc_ind <>
1058: p_batchstep_resource_rec.prim_rsrc_ind) ) THEN
1059: IF (NOT (lookup_code_valid ('GMD_PRIM_RSRC_IND'
1060: ,p_batchstep_resource_rec.prim_rsrc_ind) ) ) THEN
1061: gme_common_pvt.log_message ('GME_INV_PRM_RSRC_IND');
1062: RAISE invalid_prim_rsrc_ind;
1063: END IF;
1064:
1065: l_field_updated := TRUE;

Line 1073: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'

1069:
1070: --Pawan Kumar added trunc to give only integer value to count
1071: IF p_batchstep_resource_rec.plan_rsrc_count = fnd_api.g_miss_num
1072: AND l_step_status = 1 THEN
1073: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'
1074: ,'FIELD_NAME'
1075: ,'plan_rsrc_cout');
1076: RAISE input_param_missing;
1077: ELSIF p_batchstep_resource_rec.plan_rsrc_count IS NOT NULL THEN

Line 1080: gme_common_pvt.log_message ('GME_INVALID_FIELD'

1076: RAISE input_param_missing;
1077: ELSIF p_batchstep_resource_rec.plan_rsrc_count IS NOT NULL THEN
1078: IF p_batchstep_resource_rec.plan_rsrc_count <>
1079: TRUNC (p_batchstep_resource_rec.plan_rsrc_count) THEN
1080: gme_common_pvt.log_message ('GME_INVALID_FIELD'
1081: ,'FIELD'
1082: ,'plan_rsrc_count');
1083: RAISE error_condition;
1084: END IF;

Line 1087: gme_common_pvt.log_message ('GME_INV_ACT_STEP_STATUS'

1083: RAISE error_condition;
1084: END IF;
1085:
1086: IF l_step_status = 3 THEN
1087: gme_common_pvt.log_message ('GME_INV_ACT_STEP_STATUS'
1088: ,'FIELD'
1089: ,'plan_rsrc_count');
1090: RAISE invalid_action;
1091: ELSIF l_step_status = 2 THEN

Line 1092: gme_common_pvt.log_message ('GME_UPD_NT_ALLOWED'

1088: ,'FIELD'
1089: ,'plan_rsrc_count');
1090: RAISE invalid_action;
1091: ELSIF l_step_status = 2 THEN
1092: gme_common_pvt.log_message ('GME_UPD_NT_ALLOWED'
1093: ,'FIELD'
1094: ,'plan_rsrc_count');
1095: RAISE invalid_action;
1096: ELSIF (TRUNC (p_batchstep_resource_rec.plan_rsrc_count) <>

Line 1112: gme_common_pvt.log_message ('GME_INVALID_FIELD'

1108: l_batchstep_resource_rec.plan_rsrc_count;
1109: ELSIF p_batchstep_resource_rec.actual_rsrc_count IS NOT NULL THEN
1110: IF p_batchstep_resource_rec.actual_rsrc_count <>
1111: TRUNC (p_batchstep_resource_rec.actual_rsrc_count) THEN
1112: gme_common_pvt.log_message ('GME_INVALID_FIELD'
1113: ,'FIELD'
1114: ,'actual_rsrc_count');
1115: RAISE error_condition;
1116: END IF;

Line 1119: gme_common_pvt.log_message ('GME_INV_ACT_STEP_STATUS'

1115: RAISE error_condition;
1116: END IF;
1117:
1118: IF l_step_status = 1 THEN
1119: gme_common_pvt.log_message ('GME_INV_ACT_STEP_STATUS'
1120: ,'FIELD'
1121: ,'actual_rsrc_count');
1122: RAISE invalid_action;
1123: --ELSIF (trunc(p_batchstep_resource_rec.actual_rsrc_count) <> l_batchstep_resource_rec.actual_rsrc_count) THEN

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

1132: /* When the actual resource count is null in the database and we are trying to update actual resource usage without the
1133: actual resource count, then user will be given error message that actual resource count is required.*/
1134: ELSE
1135: IF (l_batchstep_resource_rec.actual_rsrc_count IS NULL AND p_batchstep_resource_rec.actual_rsrc_usage IS NOT NULL) THEN
1136: gme_common_pvt.log_message('GME_FIELD_VALUE_REQUIRED','FIELD_NAME', 'actual_rsrc_count');
1137: RAISE input_param_missing;
1138: END IF;
1139: END IF;
1140:

Line 1143: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'

1139: END IF;
1140:
1141: IF p_batchstep_resource_rec.plan_rsrc_usage = fnd_api.g_miss_num
1142: AND l_step_status = 1 THEN
1143: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'
1144: ,'FIELD_NAME'
1145: ,'plan_rsrc_usage');
1146: RAISE input_param_missing;
1147: ELSIF p_batchstep_resource_rec.plan_rsrc_usage IS NOT NULL THEN

Line 1149: gme_common_pvt.log_message ('GME_INV_ACT_STEP_STATUS'

1145: ,'plan_rsrc_usage');
1146: RAISE input_param_missing;
1147: ELSIF p_batchstep_resource_rec.plan_rsrc_usage IS NOT NULL THEN
1148: IF l_step_status = 3 THEN
1149: gme_common_pvt.log_message ('GME_INV_ACT_STEP_STATUS'
1150: ,'FIELD'
1151: ,'plan_rsrc_usage');
1152: RAISE invalid_action;
1153: ELSIF (l_step_status = 2 OR l_batch_asqc = 1) THEN

Line 1154: gme_common_pvt.log_message ('GME_UPD_NT_ALLOWED'

1150: ,'FIELD'
1151: ,'plan_rsrc_usage');
1152: RAISE invalid_action;
1153: ELSIF (l_step_status = 2 OR l_batch_asqc = 1) THEN
1154: gme_common_pvt.log_message ('GME_UPD_NT_ALLOWED'
1155: ,'FIELD'
1156: ,'plan_rsrc_usage');
1157: RAISE invalid_action;
1158: ELSIF (p_batchstep_resource_rec.plan_rsrc_usage <>

Line 1169: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'

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

Line 1175: gme_common_pvt.log_message ('GME_INV_ACT_STEP_STATUS'

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

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

1177: ,'actual_rsrc_usage');
1178: RAISE invalid_action;
1179: ELSIF (l_batch_asqc = 1) THEN
1180: --Pawan Kumar changed the token
1181: gme_common_pvt.log_message ('GME_UPD_RSRC_NT_WRK_ASQCBTCH');
1182: RAISE invalid_action;
1183: --Pawan Kumar added nvl for proper update
1184: ELSIF (p_batchstep_resource_rec.actual_rsrc_usage <>
1185: NVL (l_batchstep_resource_rec.actual_rsrc_usage

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

1192: /* When the actual resource count is null in the database and we are trying to update actual resource usage without the
1193: actual resource count, then user will be given error message that actual resource count is required.*/
1194: ELSE
1195: IF (l_batchstep_resource_rec.actual_rsrc_count IS NULL AND p_batchstep_resource_rec.actual_rsrc_usage IS NOT NULL) THEN
1196: gme_common_pvt.log_message('GME_FIELD_VALUE_REQUIRED','FIELD_NAME', 'actual_rsrc_count');
1197: RAISE input_param_missing;
1198: END IF;
1199: END IF;
1200:

Line 1204: gme_common_pvt.log_message ('GME_UPD_NT_ALLOWED'

1200:
1201: IF ( p_batchstep_resource_rec.usage_um IS NOT NULL
1202: AND p_batchstep_resource_rec.usage_um <>
1203: l_batchstep_resource_rec.usage_um) THEN
1204: gme_common_pvt.log_message ('GME_UPD_NT_ALLOWED'
1205: ,'FIELD'
1206: ,'usage_uom');
1207: RAISE error_condition;
1208: END IF;

Line 1212: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'

1208: END IF;
1209:
1210: IF p_batchstep_resource_rec.plan_rsrc_qty = fnd_api.g_miss_num
1211: AND l_step_status = 1 THEN
1212: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'
1213: ,'FIELD_NAME'
1214: ,'plan_rsrc_qty');
1215: RAISE input_param_missing;
1216: ELSIF (p_batchstep_resource_rec.plan_rsrc_qty IS NOT NULL) THEN

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

1214: ,'plan_rsrc_qty');
1215: RAISE input_param_missing;
1216: ELSIF (p_batchstep_resource_rec.plan_rsrc_qty IS NOT NULL) THEN
1217: IF l_batch_asqc = 1 THEN
1218: gme_common_pvt.log_message ('GME_ASQC_NO_PLAN_RSRC_QTY');
1219: RAISE error_condition;
1220: ELSIF l_step_status = 3 THEN
1221: gme_common_pvt.log_message ('GME_INV_ACT_STEP_STATUS'
1222: ,'FIELD'

Line 1221: gme_common_pvt.log_message ('GME_INV_ACT_STEP_STATUS'

1217: IF l_batch_asqc = 1 THEN
1218: gme_common_pvt.log_message ('GME_ASQC_NO_PLAN_RSRC_QTY');
1219: RAISE error_condition;
1220: ELSIF l_step_status = 3 THEN
1221: gme_common_pvt.log_message ('GME_INV_ACT_STEP_STATUS'
1222: ,'FIELD'
1223: ,'plan_rsrc_qty');
1224: RAISE invalid_action;
1225: ELSIF (l_step_status = 2 OR l_batch_asqc = 1) THEN

Line 1226: gme_common_pvt.log_message ('GME_UPD_NT_ALLOWED'

1222: ,'FIELD'
1223: ,'plan_rsrc_qty');
1224: RAISE invalid_action;
1225: ELSIF (l_step_status = 2 OR l_batch_asqc = 1) THEN
1226: gme_common_pvt.log_message ('GME_UPD_NT_ALLOWED'
1227: ,'FIELD'
1228: ,'plan_rsrc_qty');
1229: RAISE invalid_action;
1230: ELSIF (p_batchstep_resource_rec.plan_rsrc_qty <>

Line 1240: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'

1236: END IF;
1237:
1238: IF p_batchstep_resource_rec.actual_rsrc_qty = fnd_api.g_miss_num
1239: AND l_step_status = 3 THEN
1240: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'
1241: ,'FIELD_NAME'
1242: ,'actual_rsrc_qty');
1243: RAISE input_param_missing;
1244: ELSIF p_batchstep_resource_rec.actual_rsrc_qty IS NOT NULL THEN

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

1242: ,'actual_rsrc_qty');
1243: RAISE input_param_missing;
1244: ELSIF p_batchstep_resource_rec.actual_rsrc_qty IS NOT NULL THEN
1245: IF l_batch_asqc = 1 THEN
1246: gme_common_pvt.log_message ('GME_ASQC_NO_ACT_RSRC_QTY');
1247: RAISE error_condition;
1248: ELSIF l_step_status = 1 THEN
1249: gme_common_pvt.log_message ('GME_INV_ACT_STEP_STATUS'
1250: ,'FIELD'

Line 1249: gme_common_pvt.log_message ('GME_INV_ACT_STEP_STATUS'

1245: IF l_batch_asqc = 1 THEN
1246: gme_common_pvt.log_message ('GME_ASQC_NO_ACT_RSRC_QTY');
1247: RAISE error_condition;
1248: ELSIF l_step_status = 1 THEN
1249: gme_common_pvt.log_message ('GME_INV_ACT_STEP_STATUS'
1250: ,'FIELD'
1251: ,'actual_rsrc_qty');
1252: RAISE invalid_action;
1253: --Pawan Kumar added nvl for proper update

Line 1266: gme_common_pvt.log_message ('GME_UPD_NT_ALLOWED'

1262:
1263: IF ( p_batchstep_resource_rec.resource_qty_um IS NOT NULL
1264: AND p_batchstep_resource_rec.resource_qty_um <>
1265: l_batchstep_resource_rec.resource_qty_um) THEN
1266: gme_common_pvt.log_message ('GME_UPD_NT_ALLOWED'
1267: ,'FIELD'
1268: ,'resource_qty_uom');
1269: RAISE error_condition;
1270: END IF;

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

1274: AND p_batchstep_resource_rec.plan_cmplt_date IS NOT NULL
1275: AND l_step_status = 1 THEN
1276: IF p_batchstep_resource_rec.plan_start_date >
1277: p_batchstep_resource_rec.plan_cmplt_date THEN
1278: gme_common_pvt.log_message ('PM_BADSTARTDATE');
1279: RAISE invalid_date;
1280: END IF;
1281:
1282: IF NOT (date_within_activity_dates

Line 1286: gme_common_pvt.log_message

1282: IF NOT (date_within_activity_dates
1283: (l_activity_id
1284: ,l_step_status
1285: ,p_batchstep_resource_rec.plan_start_date) ) THEN
1286: gme_common_pvt.log_message
1287: ('GME_RSRC_DATES_NOT_ALLOWED'
1288: ,'RESOURCE'
1289: ,p_batchstep_resource_rec.resources);
1290: RAISE date_outside_range;

Line 1301: gme_common_pvt.log_message

1297: IF NOT (date_within_activity_dates
1298: (l_activity_id
1299: ,l_step_status
1300: ,p_batchstep_resource_rec.plan_cmplt_date) ) THEN
1301: gme_common_pvt.log_message
1302: ('GME_RSRC_DATES_NOT_ALLOWED'
1303: ,'RESOURCE'
1304: ,p_batchstep_resource_rec.resources);
1305: RAISE date_outside_range;

Line 1317: gme_common_pvt.log_message

1313: IF NOT (date_within_activity_dates
1314: (l_activity_id
1315: ,1
1316: ,p_batchstep_resource_rec.plan_start_date) ) THEN
1317: gme_common_pvt.log_message
1318: ('GME_RSRC_DATES_NOT_ALLOWED'
1319: ,'RESOURCE'
1320: ,p_batchstep_resource_rec.resources);
1321: RAISE date_outside_range;

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

1323:
1324: IF l_batchstep_resource_rec.plan_cmplt_date IS NOT NULL
1325: AND p_batchstep_resource_rec.plan_start_date >
1326: l_batchstep_resource_rec.plan_cmplt_date THEN
1327: gme_common_pvt.log_message ('PM_BADSTARTDATE');
1328: RAISE invalid_date;
1329: END IF;
1330:
1331: l_field_updated := TRUE;

Line 1341: gme_common_pvt.log_message

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

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

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

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

1363: AND p_batchstep_resource_rec.actual_cmplt_date IS NOT NULL
1364: AND l_step_status = 3 THEN
1365: IF p_batchstep_resource_rec.actual_start_date >
1366: p_batchstep_resource_rec.actual_cmplt_date THEN
1367: gme_common_pvt.log_message ('PM_BADSTARTDATE');
1368: RAISE invalid_date;
1369: END IF;
1370:
1371: IF p_batchstep_resource_rec.actual_start_date =

Line 1373: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'

1369: END IF;
1370:
1371: IF p_batchstep_resource_rec.actual_start_date =
1372: fnd_api.g_miss_date THEN
1373: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'
1374: ,'FIELD_NAME'
1375: ,'actual_start_date');
1376: RAISE input_param_missing;
1377: END IF;

Line 1383: gme_common_pvt.log_message

1379: IF NOT (date_within_activity_dates
1380: (l_activity_id
1381: ,3
1382: ,p_batchstep_resource_rec.actual_start_date) ) THEN
1383: gme_common_pvt.log_message
1384: ('GME_RSRC_DATES_NOT_ALLOWED'
1385: ,'RESOURCE'
1386: ,p_batchstep_resource_rec.resources);
1387: RAISE date_outside_range;

Line 1396: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'

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

Line 1406: gme_common_pvt.log_message

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

Line 1420: gme_common_pvt.log_message

1416: ELSE
1417: IF p_batchstep_resource_rec.actual_start_date IS NOT NULL THEN
1418: IF p_batchstep_resource_rec.actual_start_date =
1419: fnd_api.g_miss_date THEN
1420: gme_common_pvt.log_message
1421: ('GME_FIELD_VALUE_REQUIRED'
1422: ,'FIELD_NAME'
1423: ,'actual_start_date');
1424: RAISE input_param_missing;

Line 1429: gme_common_pvt.g_timestamp THEN

1425: END IF;
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;

Line 1439: gme_common_pvt.log_message

1435: IF NOT (date_within_activity_dates
1436: (l_activity_id
1437: ,3
1438: ,p_batchstep_resource_rec.actual_start_date) ) THEN
1439: gme_common_pvt.log_message
1440: ('GME_RSRC_DATES_NOT_ALLOWED'
1441: ,'RESOURCE'
1442: ,p_batchstep_resource_rec.resources);
1443: RAISE date_outside_range;

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

1445:
1446: IF l_batchstep_resource_rec.actual_cmplt_date IS NOT NULL
1447: AND p_batchstep_resource_rec.actual_start_date >
1448: l_batchstep_resource_rec.actual_cmplt_date THEN
1449: gme_common_pvt.log_message ('PM_BADSTARTDATE');
1450: RAISE invalid_date;
1451: END IF;
1452:
1453: l_field_updated := TRUE;

Line 1462: gme_common_pvt.log_message

1458: IF ( p_batchstep_resource_rec.actual_cmplt_date IS NOT NULL
1459: AND l_step_status = 3) THEN
1460: IF p_batchstep_resource_rec.actual_cmplt_date =
1461: fnd_api.g_miss_date THEN
1462: gme_common_pvt.log_message
1463: ('GME_FIELD_VALUE_REQUIRED'
1464: ,'FIELD_NAME'
1465: ,'actual_cmplt_date');
1466: RAISE input_param_missing;

Line 1473: gme_common_pvt.log_message

1469: IF NOT (date_within_activity_dates
1470: (l_activity_id
1471: ,3
1472: ,p_batchstep_resource_rec.actual_cmplt_date) ) THEN
1473: gme_common_pvt.log_message
1474: ('GME_RSRC_DATES_NOT_ALLOWED'
1475: ,'RESOURCE'
1476: ,p_batchstep_resource_rec.resources);
1477: RAISE date_outside_range;

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

1479:
1480: IF l_batchstep_resource_rec.actual_start_date IS NOT NULL
1481: AND p_batchstep_resource_rec.actual_cmplt_date <
1482: l_batchstep_resource_rec.actual_start_date THEN
1483: gme_common_pvt.log_message ('PM_BADSTARTDATE');
1484: RAISE invalid_date;
1485: END IF;
1486:
1487: l_field_updated := TRUE;

Line 1518: IF gme_common_pvt.is_qty_below_capacity

1514: END IF;
1515: END IF; -- l_step_status IN 1,2
1516: END IF; -- l_step_status IN 1,2,3
1517:
1518: IF gme_common_pvt.is_qty_below_capacity
1519: (p_batch_step_resources_rec => l_batchstep_resource_rec) THEN
1520: gme_common_pvt.log_message ('GME_RESOURCE_PROCESS_QUANTITY'
1521: ,'RESOURCE'
1522: ,l_batchstep_resource_rec.resources);

Line 1520: gme_common_pvt.log_message ('GME_RESOURCE_PROCESS_QUANTITY'

1516: END IF; -- l_step_status IN 1,2,3
1517:
1518: IF gme_common_pvt.is_qty_below_capacity
1519: (p_batch_step_resources_rec => l_batchstep_resource_rec) THEN
1520: gme_common_pvt.log_message ('GME_RESOURCE_PROCESS_QUANTITY'
1521: ,'RESOURCE'
1522: ,l_batchstep_resource_rec.resources);
1523:
1524: IF p_ignore_qty_below_cap = fnd_api.g_false THEN

Line 1714: ,last_update_date = gme_common_pvt.g_timestamp

1710: AND l_batchstep_resource_rec.max_capacity < l_max_step_capacity) THEN
1711: -- CALL DBL with updated max_capacity
1712: UPDATE gme_batch_steps
1713: SET max_step_capacity = l_batchstep_resource_rec.max_capacity
1714: ,last_update_date = gme_common_pvt.g_timestamp
1715: ,last_updated_by = gme_common_pvt.g_user_ident
1716: ,last_update_login = gme_common_pvt.g_login_id
1717: WHERE batchstep_id = l_batchstep_resource_rec.batchstep_id
1718: AND batch_id = l_batchstep_resource_rec.batch_id;

Line 1715: ,last_updated_by = gme_common_pvt.g_user_ident

1711: -- CALL DBL with updated max_capacity
1712: UPDATE gme_batch_steps
1713: SET max_step_capacity = l_batchstep_resource_rec.max_capacity
1714: ,last_update_date = gme_common_pvt.g_timestamp
1715: ,last_updated_by = gme_common_pvt.g_user_ident
1716: ,last_update_login = gme_common_pvt.g_login_id
1717: WHERE batchstep_id = l_batchstep_resource_rec.batchstep_id
1718: AND batch_id = l_batchstep_resource_rec.batch_id;
1719: END IF;

Line 1716: ,last_update_login = gme_common_pvt.g_login_id

1712: UPDATE gme_batch_steps
1713: SET max_step_capacity = l_batchstep_resource_rec.max_capacity
1714: ,last_update_date = gme_common_pvt.g_timestamp
1715: ,last_updated_by = gme_common_pvt.g_user_ident
1716: ,last_update_login = gme_common_pvt.g_login_id
1717: WHERE batchstep_id = l_batchstep_resource_rec.batchstep_id
1718: AND batch_id = l_batchstep_resource_rec.batch_id;
1719: END IF;
1720: END IF;

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

1849:
1850: IF cur_get_step_dtl%NOTFOUND THEN
1851: CLOSE cur_get_step_dtl;
1852:
1853: gme_common_pvt.log_message ('GME_INVALID_RSRC_ID');
1854: RAISE rsrc_not_valid;
1855: END IF;
1856:
1857: CLOSE cur_get_step_dtl;

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

1864:
1865: IF cur_validate_batch_type%FOUND THEN
1866: CLOSE cur_validate_batch_type;
1867:
1868: gme_common_pvt.log_message ('GME_FPO_RSRC_NO_EDIT');
1869: RAISE rsrc_not_valid;
1870: END IF;
1871:
1872: CLOSE cur_validate_batch_type;

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

2006: l_batch_header.batch_id := p_batchstep_resource_rec.batch_id;
2007:
2008: IF NOT gme_batch_header_dbl.fetch_row (p_batch_header => l_batch_header
2009: ,x_batch_header => l_batch_header) THEN
2010: gme_common_pvt.log_message ('GME_BATCH_NOT_FOUND');
2011: RAISE error_condition;
2012: END IF;
2013:
2014: IF l_batch_header.update_inventory_ind = 'Y' THEN