[Home] [Help]
PACKAGE BODY: APPS.MTH_UPDATE_ERR_PKG
Source
1 PACKAGE BODY MTH_UPDATE_ERR_PKG AS
2 /*$Header: mthuerrb.pls 120.0.12020000.4 2012/10/18 04:01:10 sasuren noship $*/
3
4 PROCEDURE UPD_ASSET_ERR (
5 p_err_code IN VARCHAR2,
6 p_reprocess_ready_yn IN VARCHAR2,
7 p_asset_pk IN VARCHAR2,
8 p_asset_number IN VARCHAR2,
9 p_asset_group IN VARCHAR2,
10 p_maintenance_org_code IN VARCHAR2,
11 p_asset_group_id IN NUMBER,
12 p_system_fk IN VARCHAR2,
13 p_asset_description IN VARCHAR2,
14 p_serial_number IN VARCHAR2,
15 p_asset_category IN VARCHAR2,
16 p_owning_department IN VARCHAR2,
17 p_asset_criticality IN VARCHAR2,
18 p_active_flag IN VARCHAR2,
19 p_maintainable_flag IN VARCHAR2,
20 p_mttr IN NUMBER,
21 p_mtbf IN NUMBER,
22 p_asset_location IN VARCHAR2,
23 p_user_attr1 IN VARCHAR2,
24 p_user_attr2 IN VARCHAR2,
25 p_user_attr3 IN VARCHAR2,
26 p_user_attr4 IN VARCHAR2,
27 p_user_attr5 IN VARCHAR2,
28 p_user_measure1 IN NUMBER,
29 p_user_measure2 IN NUMBER,
30 p_user_measure3 IN NUMBER,
31 p_user_measure4 IN NUMBER,
32 p_user_measure5 IN NUMBER,
33 p_rowid IN ROWID
34 ) IS
35 BEGIN
36
37 IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
38
39 FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
40 RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
41
42 ELSIF p_rowid IS NOT NULL THEN
43
44 UPDATE MTH_ASSET_ERR SET
45 REPROCESS_READY_YN = p_reprocess_ready_yn
46 ,ASSET_PK = p_asset_pk
47 ,ASSET_NUMBER = p_asset_number
48 ,ASSET_GROUP = p_asset_group
49 ,MAINTENANCE_ORG_CODE = p_maintenance_org_code
50 ,ASSET_GROUP_ID = p_asset_group_id
51 ,SYSTEM_FK = p_system_fk
52 ,ASSET_DESCRIPTION = p_asset_description
53 ,SERIAL_NUMBER = p_serial_number
54 ,ASSET_CATEGORY = p_asset_category
55 ,OWNING_DEPARTMENT = p_owning_department
56 ,ASSET_CRITICALITY = p_asset_criticality
57 ,ACTIVE_FLAG = p_active_flag
58 ,MAINTAINABLE_FLAG = p_maintainable_flag
59 ,MTTR = p_mttr
60 ,MTBF = p_mtbf
61 ,ASSET_LOCATION = p_asset_location
62 ,USER_ATTR1 = p_user_attr1
63 ,USER_ATTR2 = p_user_attr2
64 ,USER_ATTR3 = p_user_attr3
65 ,USER_ATTR4 = p_user_attr4
66 ,USER_ATTR5 = p_user_attr5
67 ,USER_MEASURE1 = p_user_measure1
68 ,USER_MEASURE2 = p_user_measure2
69 ,USER_MEASURE3 = p_user_measure3
70 ,USER_MEASURE4 = p_user_measure4
71 ,USER_MEASURE5 = p_user_measure5
72 WHERE ROWID = p_rowid;
73
74 ELSE
75
76 INSERT INTO MTH_ASSET_ERR (
77 REPROCESS_READY_YN
78 ,ASSET_PK
79 ,ASSET_NUMBER
80 ,ASSET_GROUP
81 ,MAINTENANCE_ORG_CODE
82 ,ASSET_GROUP_ID
83 ,SYSTEM_FK
84 ,ASSET_DESCRIPTION
85 ,SERIAL_NUMBER
86 ,ASSET_CATEGORY
87 ,OWNING_DEPARTMENT
88 ,ASSET_CRITICALITY
89 ,ACTIVE_FLAG
90 ,MAINTAINABLE_FLAG
91 ,MTTR
92 ,MTBF
93 ,ASSET_LOCATION
94 ,USER_ATTR1
95 ,USER_ATTR2
96 ,USER_ATTR3
97 ,USER_ATTR4
98 ,USER_ATTR5
99 ,USER_MEASURE1
100 ,USER_MEASURE2
101 ,USER_MEASURE3
102 ,USER_MEASURE4
103 ,USER_MEASURE5
104 ) VALUES (
105 p_reprocess_ready_yn
106 ,p_asset_pk
107 ,p_asset_number
108 ,p_asset_group
109 ,p_maintenance_org_code
110 ,p_asset_group_id
111 ,p_system_fk
112 ,p_asset_description
113 ,p_serial_number
114 ,p_asset_category
115 ,p_owning_department
116 ,p_asset_criticality
117 ,p_active_flag
118 ,p_maintainable_flag
119 ,p_mttr
120 ,p_mtbf
121 ,p_asset_location
122 ,p_user_attr1
123 ,p_user_attr2
124 ,p_user_attr3
125 ,p_user_attr4
126 ,p_user_attr5
127 ,p_user_measure1
128 ,p_user_measure2
129 ,p_user_measure3
130 ,p_user_measure4
131 ,p_user_measure5
132 );
133
134 END IF;
135
136 END UPD_ASSET_ERR;
137
138 PROCEDURE UPD_DAY_ERR (
139 p_err_code IN VARCHAR2,
140 p_reprocess_ready_yn IN VARCHAR2,
141 p_report_date IN VARCHAR2,
142 p_user_attr1 IN VARCHAR2,
143 p_user_attr2 IN VARCHAR2,
144 p_user_attr3 IN VARCHAR2,
145 p_user_attr4 IN VARCHAR2,
146 p_user_attr5 IN VARCHAR2,
147 p_user_measure1 IN NUMBER,
148 p_user_measure2 IN NUMBER,
149 p_user_measure3 IN NUMBER,
150 p_user_measure4 IN NUMBER,
151 p_user_measure5 IN NUMBER,
152 p_system_fk IN VARCHAR2,
153 p_rowid IN ROWID
154 ) IS
155 BEGIN
156
157 IF NVL(p_reprocess_ready_yn,'X') NOT IN ('D') THEN
158
159 FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
163
160 RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
161
162 ELSIF p_rowid IS NOT NULL THEN
164 UPDATE MTH_DAY_ERR SET
165 REPROCESS_READY_YN = p_reprocess_ready_yn
166 ,REPORT_DATE = fnd_date.canonical_to_date(p_report_date)
167 ,USER_ATTR1 = p_user_attr1
168 ,USER_ATTR2 = p_user_attr2
169 ,USER_ATTR3 = p_user_attr3
170 ,USER_ATTR4 = p_user_attr4
171 ,USER_ATTR5 = p_user_attr5
172 ,USER_MEASURE1 = p_user_measure1
173 ,USER_MEASURE2 = p_user_measure2
174 ,USER_MEASURE3 = p_user_measure3
175 ,USER_MEASURE4 = p_user_measure4
176 ,USER_MEASURE5 = p_user_measure5
177 ,SYSTEM_FK = p_system_fk
178 WHERE ROWID = p_rowid;
179
180 ELSE
181
182 RAISE_APPLICATION_ERROR(-20002, 'Reprocess not allowed.');
183
184 END IF;
185
186 END UPD_DAY_ERR;
187
188 PROCEDURE UPD_DIM_HIERARCHY_ERR (
189 p_err_code IN VARCHAR2,
190 p_reprocess_ready_yn IN VARCHAR2,
191 p_dimension_name IN VARCHAR2,
192 p_hierarchy_name IN VARCHAR2,
193 p_category_set_name IN VARCHAR2,
194 p_hierarchy_display_name IN VARCHAR2,
195 p_number_of_level IN NUMBER,
196 p_processing_flag IN NUMBER,
197 p_rowid IN ROWID
198 ) IS
199 BEGIN
200
201 IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
202
203 FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
204 RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
205
206 ELSIF p_rowid IS NOT NULL THEN
207
208 UPDATE MTH_DIM_HIERARCHY_ERR SET
209 REPROCESS_READY_YN = p_reprocess_ready_yn
210 ,DIMENSION_NAME = p_dimension_name
211 ,HIERARCHY_NAME = p_hierarchy_name
212 ,CATEGORY_SET_NAME = p_category_set_name
213 ,HIERARCHY_DISPLAY_NAME = p_hierarchy_display_name
214 ,NUMBER_OF_LEVEL = p_number_of_level
215 ,PROCESSING_FLAG = p_processing_flag
216 WHERE ROWID = p_rowid;
217
218 ELSE
219
220 INSERT INTO MTH_DIM_HIERARCHY_ERR (
221 REPROCESS_READY_YN
222 ,DIMENSION_NAME
223 ,HIERARCHY_NAME
224 ,CATEGORY_SET_NAME
225 ,HIERARCHY_DISPLAY_NAME
226 ,NUMBER_OF_LEVEL
227 ,PROCESSING_FLAG
228 ) VALUES (
229 p_reprocess_ready_yn
230 ,p_dimension_name
231 ,p_hierarchy_name
232 ,p_category_set_name
233 ,p_hierarchy_display_name
234 ,p_number_of_level
235 ,p_processing_flag
236 );
237
238 END IF;
239
240 END UPD_DIM_HIERARCHY_ERR;
241
242 PROCEDURE UPD_DIM_LEVEL_LOOKUP_ERR (
243 p_err_code IN VARCHAR2,
244 p_reprocess_ready_yn IN VARCHAR2,
245 p_hierarchy_name IN VARCHAR2,
246 p_dimension_name IN VARCHAR2,
247 p_level_num IN NUMBER,
248 p_level_type IN VARCHAR2,
249 p_level_name IN VARCHAR2,
250 p_rowid IN ROWID
251 ) IS
252 BEGIN
253
254 IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
255
256 FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
257 RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
258
259 ELSIF p_rowid IS NOT NULL THEN
260
261 UPDATE MTH_DIM_LEVEL_LOOKUP_ERR SET
262 REPROCESS_READY_YN = p_reprocess_ready_yn
263 ,HIERARCHY_NAME = p_hierarchy_name
264 ,DIMENSION_NAME = p_dimension_name
265 ,LEVEL_NUM = p_level_num
266 ,LEVEL_TYPE = p_level_type
267 ,LEVEL_NAME = p_level_name
268 WHERE ROWID = p_rowid;
269
270 ELSE
271
272 INSERT INTO MTH_DIM_LEVEL_LOOKUP_ERR (
273 REPROCESS_READY_YN
274 ,HIERARCHY_NAME
275 ,DIMENSION_NAME
276 ,LEVEL_NUM
277 ,LEVEL_TYPE
278 ,LEVEL_NAME
279 ) VALUES (
280 p_reprocess_ready_yn
281 ,p_hierarchy_name
282 ,p_dimension_name
283 ,p_level_num
284 ,p_level_type
285 ,p_level_name
286 );
287
291
288 END IF;
289
290 END UPD_DIM_LEVEL_LOOKUP_ERR;
292 PROCEDURE UPD_ENTITY_PLANNED_USAGE_ERR (
293 p_err_code IN VARCHAR2,
294 p_reprocess_ready_yn IN VARCHAR2,
295 p_entity_fk IN VARCHAR2,
296 p_sustain_aspect_fk IN VARCHAR2,
297 p_period_of_usage IN VARCHAR2,
298 p_entity_type IN VARCHAR2,
299 p_planned_usage IN NUMBER,
300 p_rowid IN ROWID
301 ) IS
302 BEGIN
303
304 IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
305
306 FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
307 RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
308
309 ELSIF p_rowid IS NOT NULL THEN
310
311 UPDATE MTH_ENTITY_PLANNED_USAGE_ERR SET
312 REPROCESS_READY_YN = p_reprocess_ready_yn
313 ,ENTITY_FK = p_entity_fk
314 ,SUSTAIN_ASPECT_FK = p_sustain_aspect_fk
315 ,PERIOD_OF_USAGE = p_period_of_usage
316 ,ENTITY_TYPE = p_entity_type
317 ,PLANNED_USAGE = p_planned_usage
318 WHERE ROWID = p_rowid;
319
320 ELSE
321
322 INSERT INTO MTH_ENTITY_PLANNED_USAGE_ERR (
323 REPROCESS_READY_YN
324 ,ENTITY_FK
325 ,SUSTAIN_ASPECT_FK
326 ,PERIOD_OF_USAGE
327 ,ENTITY_TYPE
328 ,PLANNED_USAGE
329 ) VALUES (
333 ,p_period_of_usage
330 p_reprocess_ready_yn
331 ,p_entity_fk
332 ,p_sustain_aspect_fk
334 ,p_entity_type
335 ,p_planned_usage
336 );
337
338 END IF;
339
340 END UPD_ENTITY_PLANNED_USAGE_ERR;
341
342 PROCEDURE UPD_EQUIPMENTS_ERR (
343 p_err_code IN VARCHAR2,
344 p_reprocess_ready_yn IN VARCHAR2,
345 p_equipment_pk IN VARCHAR2,
346 p_ebs_organization_id IN NUMBER,
347 p_ebs_equipment_id IN NUMBER,
348 p_system_fk IN VARCHAR2,
349 p_user_attr1 IN VARCHAR2,
350 p_user_attr2 IN VARCHAR2,
351 p_user_attr3 IN VARCHAR2,
352 p_user_attr4 IN VARCHAR2,
353 p_user_attr5 IN VARCHAR2,
354 p_user_measure1 IN NUMBER,
355 p_user_measure2 IN NUMBER,
356 p_user_measure3 IN NUMBER,
357 p_user_measure4 IN NUMBER,
358 p_user_measure5 IN NUMBER,
359 p_fixed_asset_value IN NUMBER,
360 p_equipment_name IN VARCHAR2,
361 p_equipment_description IN VARCHAR2,
362 p_source_org_code IN VARCHAR2,
363 p_std_utilization IN NUMBER,
364 p_std_efficiency IN NUMBER,
365 p_equipment_criticality IN VARCHAR2,
366 p_serial_number IN VARCHAR2,
367 p_production_equipment IN VARCHAR2,
368 p_equipment_manufacturer IN VARCHAR2,
369 p_model_number IN VARCHAR2,
370 p_installation_date IN VARCHAR2,
371 p_last_calibrated IN VARCHAR2,
372 p_power_rating IN NUMBER,
373 p_standard_capacity IN NUMBER,
374 p_std_cycle_time IN NUMBER,
375 p_status IN VARCHAR2,
376 p_location IN VARCHAR2,
377 p_rowid IN ROWID
378 ) IS
379 BEGIN
380
381 IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
382
383 FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
384 RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
385
386 ELSIF p_rowid IS NOT NULL THEN
387
388 UPDATE MTH_EQUIPMENTS_ERR SET
389 REPROCESS_READY_YN = p_reprocess_ready_yn
390 ,EQUIPMENT_PK = p_equipment_pk
391 ,EBS_ORGANIZATION_ID = p_ebs_organization_id
392 ,EBS_EQUIPMENT_ID = p_ebs_equipment_id
393 ,SYSTEM_FK = p_system_fk
394 ,USER_ATTR1 = p_user_attr1
395 ,USER_ATTR2 = p_user_attr2
396 ,USER_ATTR3 = p_user_attr3
397 ,USER_ATTR4 = p_user_attr4
398 ,USER_ATTR5 = p_user_attr5
399 ,USER_MEASURE1 = p_user_measure1
400 ,USER_MEASURE2 = p_user_measure2
401 ,USER_MEASURE3 = p_user_measure3
402 ,USER_MEASURE4 = p_user_measure4
403 ,USER_MEASURE5 = p_user_measure5
404 ,FIXED_ASSET_VALUE = p_fixed_asset_value
405 ,EQUIPMENT_NAME = p_equipment_name
406 ,EQUIPMENT_DESCRIPTION = p_equipment_description
407 ,SOURCE_ORG_CODE = p_source_org_code
408 ,STD_UTILIZATION = p_std_utilization
409 ,STD_EFFICIENCY = p_std_efficiency
410 ,EQUIPMENT_CRITICALITY = p_equipment_criticality
411 ,SERIAL_NUMBER = p_serial_number
412 ,PRODUCTION_EQUIPMENT = p_production_equipment
413 ,EQUIPMENT_MANUFACTURER = p_equipment_manufacturer
414 ,MODEL_NUMBER = p_model_number
415 ,INSTALLATION_DATE = fnd_date.canonical_to_date(p_installation_date)
416 ,LAST_CALIBRATED = fnd_date.canonical_to_date(p_last_calibrated)
420 ,STATUS = p_status
417 ,POWER_RATING = p_power_rating
418 ,STANDARD_CAPACITY = p_standard_capacity
419 ,STD_CYCLE_TIME = p_std_cycle_time
421 ,LOCATION = p_location
422 WHERE ROWID = p_rowid;
423
424 ELSE
425
426 INSERT INTO MTH_EQUIPMENTS_ERR (
427 REPROCESS_READY_YN
428 ,EQUIPMENT_PK
429 ,EBS_ORGANIZATION_ID
430 ,EBS_EQUIPMENT_ID
431 ,SYSTEM_FK
432 ,USER_ATTR1
433 ,USER_ATTR2
434 ,USER_ATTR3
435 ,USER_ATTR4
436 ,USER_ATTR5
437 ,USER_MEASURE1
438 ,USER_MEASURE2
439 ,USER_MEASURE3
440 ,USER_MEASURE4
441 ,USER_MEASURE5
442 ,FIXED_ASSET_VALUE
443 ,EQUIPMENT_NAME
444 ,EQUIPMENT_DESCRIPTION
445 ,SOURCE_ORG_CODE
446 ,STD_UTILIZATION
447 ,STD_EFFICIENCY
448 ,EQUIPMENT_CRITICALITY
449 ,SERIAL_NUMBER
450 ,PRODUCTION_EQUIPMENT
451 ,EQUIPMENT_MANUFACTURER
452 ,MODEL_NUMBER
453 ,INSTALLATION_DATE
454 ,LAST_CALIBRATED
455 ,POWER_RATING
456 ,STANDARD_CAPACITY
457 ,STD_CYCLE_TIME
458 ,STATUS
459 ,LOCATION
460 ) VALUES (
461 p_reprocess_ready_yn
462 ,p_equipment_pk
463 ,p_ebs_organization_id
464 ,p_ebs_equipment_id
465 ,p_system_fk
466 ,p_user_attr1
467 ,p_user_attr2
468 ,p_user_attr3
469 ,p_user_attr4
470 ,p_user_attr5
471 ,p_user_measure1
472 ,p_user_measure2
473 ,p_user_measure3
474 ,p_user_measure4
475 ,p_user_measure5
476 ,p_fixed_asset_value
477 ,p_equipment_name
478 ,p_equipment_description
479 ,p_source_org_code
480 ,p_std_utilization
481 ,p_std_efficiency
482 ,p_equipment_criticality
483 ,p_serial_number
484 ,p_production_equipment
485 ,p_equipment_manufacturer
486 ,p_model_number
487 ,fnd_date.canonical_to_date(p_installation_date)
488 ,fnd_date.canonical_to_date(p_last_calibrated)
489 ,p_power_rating
490 ,p_standard_capacity
491 ,p_std_cycle_time
492 ,p_status
493 ,p_location
494 );
495
496 END IF;
497
498 END UPD_EQUIPMENTS_ERR;
499
500 PROCEDURE UPD_EQUIPMENT_REASON_SETUP_ERR (
501 p_err_code IN VARCHAR2,
502 p_reprocess_ready_yn IN VARCHAR2,
503 p_equipment_fk IN VARCHAR2,
504 p_reason_type IN NUMBER,
505 p_reason_code IN VARCHAR2,
506 p_expected_up_time IN NUMBER,
507 p_rowid IN ROWID
508 ) IS
509 BEGIN
510
511 IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
512
513 FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
514 RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
515
516 ELSIF p_rowid IS NOT NULL THEN
517
518 UPDATE MTH_EQUIPMENT_REASON_SETUP_ERR SET
519 REPROCESS_READY_YN = p_reprocess_ready_yn
520 ,EQUIPMENT_FK = p_equipment_fk
521 ,REASON_TYPE = p_reason_type
522 ,REASON_CODE = p_reason_code
523 ,EXPECTED_UP_TIME = p_expected_up_time
524 WHERE ROWID = p_rowid;
525
526 ELSE
527
528 INSERT INTO MTH_EQUIPMENT_REASON_SETUP_ERR (
529 REPROCESS_READY_YN
530 ,EQUIPMENT_FK
531 ,REASON_TYPE
532 ,REASON_CODE
533 ,EXPECTED_UP_TIME
534 ) VALUES (
535 p_reprocess_ready_yn
536 ,p_equipment_fk
537 ,p_reason_type
538 ,p_reason_code
539 ,p_expected_up_time
540 );
541
542 END IF;
543
544 END UPD_EQUIPMENT_REASON_SETUP_ERR;
545
546 PROCEDURE UPD_EQUIPMENT_SHIFTS_ERR (
547 p_err_code IN VARCHAR2,
548 p_reprocess_ready_yn IN VARCHAR2,
552 p_from_date IN VARCHAR2,
549 p_entity_pk IN VARCHAR2,
550 p_entity_type IN VARCHAR2,
551 p_line_num IN NUMBER,
553 p_to_date IN VARCHAR2,
554 p_shift_workday_fk IN VARCHAR2,
555 p_availability_flag IN VARCHAR2,
556 p_reason IN VARCHAR2,
557 p_rowid IN ROWID
558 ) IS
559 BEGIN
560
561 IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
562
563 FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
564 RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
565
566 ELSIF p_rowid IS NOT NULL THEN
567
568 UPDATE MTH_EQUIPMENT_SHIFTS_ERR SET
569 REPROCESS_READY_YN = p_reprocess_ready_yn
570 ,ENTITY_PK = p_entity_pk
574 ,TO_DATE = fnd_date.canonical_to_date(p_to_date)
571 ,ENTITY_TYPE = p_entity_type
572 ,LINE_NUM = p_line_num
573 ,FROM_DATE = fnd_date.canonical_to_date(p_from_date)
575 ,SHIFT_WORKDAY_FK = p_shift_workday_fk
576 ,AVAILABILITY_FLAG = p_availability_flag
577 ,REASON = p_reason
578 WHERE ROWID = p_rowid;
579
580 ELSE
581
582 INSERT INTO MTH_EQUIPMENT_SHIFTS_ERR (
583 REPROCESS_READY_YN
584 ,ENTITY_PK
585 ,ENTITY_TYPE
586 ,LINE_NUM
587 ,FROM_DATE
588 ,TO_DATE
589 ,SHIFT_WORKDAY_FK
590 ,AVAILABILITY_FLAG
591 ,REASON
592 ) VALUES (
593 p_reprocess_ready_yn
594 ,p_entity_pk
595 ,p_entity_type
596 ,p_line_num
597 ,fnd_date.canonical_to_date(p_from_date)
598 ,fnd_date.canonical_to_date(p_to_date)
599 ,p_shift_workday_fk
600 ,p_availability_flag
601 ,p_reason
602 );
603
604 END IF;
605
606 END UPD_EQUIPMENT_SHIFTS_ERR;
607
608 PROCEDURE UPD_EQUIP_ENTITIES_ERR (
609 p_err_code IN VARCHAR2,
610 p_reprocess_ready_yn IN VARCHAR2,
611 p_entity_pk IN VARCHAR2,
612 p_entity_name IN VARCHAR2,
613 p_entity_type IN VARCHAR2,
614 p_system_fk IN VARCHAR2,
615 p_source_org_code IN VARCHAR2,
616 p_production_entity IN VARCHAR2,
617 p_business_function IN VARCHAR2,
618 p_description IN VARCHAR2,
619 p_status IN VARCHAR2,
620 p_area IN NUMBER,
621 p_head_count IN NUMBER,
622 p_effective_date IN VARCHAR2,
623 p_user_attr1 IN VARCHAR2,
624 p_user_attr2 IN VARCHAR2,
625 p_user_attr3 IN VARCHAR2,
626 p_user_attr4 IN VARCHAR2,
627 p_user_attr5 IN VARCHAR2,
628 p_user_measure1 IN NUMBER,
629 p_user_measure2 IN NUMBER,
630 p_user_measure3 IN NUMBER,
631 p_user_measure4 IN NUMBER,
632 p_user_measure5 IN NUMBER,
633 p_rowid IN ROWID
634 ) IS
635 BEGIN
636
637 IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
638
639 FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
640 RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
641
642 ELSIF p_rowid IS NOT NULL THEN
643
644 UPDATE MTH_EQUIP_ENTITIES_ERR SET
645 REPROCESS_READY_YN = p_reprocess_ready_yn
646 ,ENTITY_PK = p_entity_pk
647 ,ENTITY_NAME = p_entity_name
648 ,ENTITY_TYPE = p_entity_type
649 ,SYSTEM_FK = p_system_fk
650 ,SOURCE_ORG_CODE = p_source_org_code
651 ,PRODUCTION_ENTITY = p_production_entity
652 ,BUSINESS_FUNCTION = p_business_function
653 ,DESCRIPTION = p_description
657 ,EFFECTIVE_DATE = fnd_date.canonical_to_date(p_effective_date)
654 ,STATUS = p_status
655 ,AREA = p_area
656 ,HEAD_COUNT = p_head_count
658 ,USER_ATTR1 = p_user_attr1
659 ,USER_ATTR2 = p_user_attr2
660 ,USER_ATTR3 = p_user_attr3
661 ,USER_ATTR4 = p_user_attr4
662 ,USER_ATTR5 = p_user_attr5
663 ,USER_MEASURE1 = p_user_measure1
664 ,USER_MEASURE2 = p_user_measure2
665 ,USER_MEASURE3 = p_user_measure3
666 ,USER_MEASURE4 = p_user_measure4
667 ,USER_MEASURE5 = p_user_measure5
668 WHERE ROWID = p_rowid;
669
670 ELSE
671
672 INSERT INTO MTH_EQUIP_ENTITIES_ERR (
673 REPROCESS_READY_YN
674 ,ENTITY_PK
675 ,ENTITY_NAME
676 ,ENTITY_TYPE
677 ,SYSTEM_FK
678 ,SOURCE_ORG_CODE
679 ,PRODUCTION_ENTITY
680 ,BUSINESS_FUNCTION
681 ,DESCRIPTION
682 ,STATUS
683 ,AREA
684 ,HEAD_COUNT
685 ,EFFECTIVE_DATE
686 ,USER_ATTR1
687 ,USER_ATTR2
688 ,USER_ATTR3
689 ,USER_ATTR4
690 ,USER_ATTR5
691 ,USER_MEASURE1
692 ,USER_MEASURE2
693 ,USER_MEASURE3
694 ,USER_MEASURE4
695 ,USER_MEASURE5
696 ) VALUES (
697 p_reprocess_ready_yn
698 ,p_entity_pk
699 ,p_entity_name
700 ,p_entity_type
701 ,p_system_fk
702 ,p_source_org_code
703 ,p_production_entity
704 ,p_business_function
705 ,p_description
706 ,p_status
707 ,p_area
708 ,p_head_count
709 ,fnd_date.canonical_to_date(p_effective_date)
710 ,p_user_attr1
711 ,p_user_attr2
712 ,p_user_attr3
713 ,p_user_attr4
714 ,p_user_attr5
715 ,p_user_measure1
716 ,p_user_measure2
717 ,p_user_measure3
718 ,p_user_measure4
719 ,p_user_measure5
720 );
721
722 END IF;
723
724 END UPD_EQUIP_ENTITIES_ERR;
725
726 PROCEDURE UPD_EQUIP_HIERARCHY_ERR (
727 p_err_code IN VARCHAR2,
728 p_reprocess_ready_yn IN VARCHAR2,
729 p_hierarchy_name IN VARCHAR2,
730 p_level_num IN NUMBER,
731 p_level_fk IN VARCHAR2,
732 p_parent_fk IN VARCHAR2,
733 p_system_fk IN VARCHAR2,
734 p_effective_date IN VARCHAR2,
735 p_rowid IN ROWID
736 ) IS
737 BEGIN
738
739 IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
740
741 FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
742 RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
743
744 ELSIF p_rowid IS NOT NULL THEN
745
746 UPDATE MTH_EQUIP_HIERARCHY_ERR SET
747 REPROCESS_READY_YN = p_reprocess_ready_yn
748 ,HIERARCHY_NAME = p_hierarchy_name
749 ,LEVEL_NUM = p_level_num
750 ,LEVEL_FK = p_level_fk
751 ,PARENT_FK = p_parent_fk
752 ,SYSTEM_FK = p_system_fk
753 ,EFFECTIVE_DATE = fnd_date.canonical_to_date(p_effective_date)
754 WHERE ROWID = p_rowid;
755
756 ELSE
757
758 INSERT INTO MTH_EQUIP_HIERARCHY_ERR (
759 REPROCESS_READY_YN
760 ,HIERARCHY_NAME
761 ,LEVEL_NUM
762 ,LEVEL_FK
763 ,PARENT_FK
764 ,SYSTEM_FK
765 ,EFFECTIVE_DATE
766 ) VALUES (
767 p_reprocess_ready_yn
768 ,p_hierarchy_name
769 ,p_level_num
770 ,p_level_fk
771 ,p_parent_fk
772 ,p_system_fk
773 ,fnd_date.canonical_to_date(p_effective_date)
774 );
775
776 END IF;
777
778 END UPD_EQUIP_HIERARCHY_ERR;
779
780 PROCEDURE UPD_EQUIP_OUTPUT_ERR (
781 p_err_code IN VARCHAR2,
782 p_reprocess_ready_yn IN VARCHAR2,
786 p_workorder_fk IN VARCHAR2,
783 p_equipment_fk IN VARCHAR2,
784 p_item_fk IN VARCHAR2,
785 p_shift_workday_fk IN VARCHAR2,
787 p_reading_time IN VARCHAR2,
788 p_qty_completed IN NUMBER,
789 p_qty_scrap IN NUMBER,
790 p_qty_rejected IN NUMBER,
791 p_qty_rework IN NUMBER,
792 p_qty_uom IN VARCHAR2,
793 p_qty_good IN NUMBER,
794 p_qty_output IN NUMBER,
795 p_system_fk IN VARCHAR2,
796 p_user_dim1_fk IN VARCHAR2,
797 p_user_dim2_fk IN VARCHAR2,
798 p_user_dim3_fk IN VARCHAR2,
799 p_user_dim4_fk IN VARCHAR2,
800 p_user_dim5_fk IN VARCHAR2,
801 p_user_attr1 IN VARCHAR2,
802 p_user_attr2 IN VARCHAR2,
803 p_user_attr3 IN VARCHAR2,
804 p_user_attr4 IN VARCHAR2,
805 p_user_attr5 IN VARCHAR2,
806 p_user_measure1 IN NUMBER,
807 p_user_measure2 IN NUMBER,
808 p_user_measure3 IN NUMBER,
809 p_user_measure4 IN NUMBER,
810 p_user_measure5 IN NUMBER,
811 p_recipe_num IN VARCHAR2,
812 p_recipe_version IN VARCHAR2,
813 p_segment_fk IN VARCHAR2,
814 p_scrap_reason_code IN VARCHAR2,
815 p_rowid IN ROWID
816 ) IS
817 BEGIN
818
819 IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
820
821 FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
822 RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
823
824 ELSIF p_rowid IS NOT NULL THEN
825
826 UPDATE MTH_EQUIP_OUTPUT_ERR SET
827 REPROCESS_READY_YN = p_reprocess_ready_yn
828 ,EQUIPMENT_FK = p_equipment_fk
829 ,ITEM_FK = p_item_fk
830 ,SHIFT_WORKDAY_FK = p_shift_workday_fk
831 ,WORKORDER_FK = p_workorder_fk
832 ,READING_TIME = fnd_date.canonical_to_date(p_reading_time)
833 ,QTY_COMPLETED = p_qty_completed
834 ,QTY_SCRAP = p_qty_scrap
835 ,QTY_REJECTED = p_qty_rejected
836 ,QTY_REWORK = p_qty_rework
837 ,QTY_UOM = p_qty_uom
838 ,QTY_GOOD = p_qty_good
839 ,QTY_OUTPUT = p_qty_output
840 ,SYSTEM_FK = p_system_fk
841 ,USER_DIM1_FK = p_user_dim1_fk
842 ,USER_DIM2_FK = p_user_dim2_fk
843 ,USER_DIM3_FK = p_user_dim3_fk
844 ,USER_DIM4_FK = p_user_dim4_fk
845 ,USER_DIM5_FK = p_user_dim5_fk
846 ,USER_ATTR1 = p_user_attr1
847 ,USER_ATTR2 = p_user_attr2
848 ,USER_ATTR3 = p_user_attr3
849 ,USER_ATTR4 = p_user_attr4
850 ,USER_ATTR5 = p_user_attr5
851 ,USER_MEASURE1 = p_user_measure1
852 ,USER_MEASURE2 = p_user_measure2
853 ,USER_MEASURE3 = p_user_measure3
854 ,USER_MEASURE4 = p_user_measure4
855 ,USER_MEASURE5 = p_user_measure5
856 ,RECIPE_NUM = p_recipe_num
857 ,RECIPE_VERSION = p_recipe_version
858 ,SEGMENT_FK = p_segment_fk
859 ,SCRAP_REASON_CODE = p_scrap_reason_code
860 WHERE ROWID = p_rowid;
861
862 ELSE
863
864 INSERT INTO MTH_EQUIP_OUTPUT_ERR (
865 REPROCESS_READY_YN
866 ,EQUIPMENT_FK
867 ,ITEM_FK
868 ,SHIFT_WORKDAY_FK
869 ,WORKORDER_FK
870 ,READING_TIME
871 ,QTY_COMPLETED
872 ,QTY_SCRAP
873 ,QTY_REJECTED
874 ,QTY_REWORK
875 ,QTY_UOM
876 ,QTY_GOOD
877 ,QTY_OUTPUT
878 ,SYSTEM_FK
879 ,USER_DIM1_FK
880 ,USER_DIM2_FK
881 ,USER_DIM3_FK
882 ,USER_DIM4_FK
883 ,USER_DIM5_FK
884 ,USER_ATTR1
885 ,USER_ATTR2
886 ,USER_ATTR3
887 ,USER_ATTR4
888 ,USER_ATTR5
889 ,USER_MEASURE1
890 ,USER_MEASURE2
894 ,RECIPE_NUM
891 ,USER_MEASURE3
892 ,USER_MEASURE4
893 ,USER_MEASURE5
895 ,RECIPE_VERSION
896 ,SEGMENT_FK
897 ,SCRAP_REASON_CODE
898 ) VALUES (
899 p_reprocess_ready_yn
900 ,p_equipment_fk
901 ,p_item_fk
902 ,p_shift_workday_fk
903 ,p_workorder_fk
904 ,fnd_date.canonical_to_date(p_reading_time)
905 ,p_qty_completed
906 ,p_qty_scrap
907 ,p_qty_rejected
908 ,p_qty_rework
909 ,p_qty_uom
910 ,p_qty_good
911 ,p_qty_output
912 ,p_system_fk
913 ,p_user_dim1_fk
914 ,p_user_dim2_fk
915 ,p_user_dim3_fk
916 ,p_user_dim4_fk
917 ,p_user_dim5_fk
918 ,p_user_attr1
919 ,p_user_attr2
920 ,p_user_attr3
921 ,p_user_attr4
922 ,p_user_attr5
923 ,p_user_measure1
924 ,p_user_measure2
925 ,p_user_measure3
926 ,p_user_measure4
927 ,p_user_measure5
928 ,p_recipe_num
929 ,p_recipe_version
930 ,p_segment_fk
931 ,p_scrap_reason_code
932 );
933
934 END IF;
935
936 END UPD_EQUIP_OUTPUT_ERR;
937
938 PROCEDURE UPD_EQUIP_PROD_SCHEDULE_ERR (
939 p_err_code IN VARCHAR2,
940 p_reprocess_ready_yn IN VARCHAR2,
941 p_equip_schedule_pk IN VARCHAR2,
942 p_equipment_fk IN VARCHAR2,
943 p_workorder_fk IN VARCHAR2,
944 p_segment_fk IN VARCHAR2,
945 p_shift_workday_fk IN VARCHAR2,
946 p_item_fk IN VARCHAR2,
947 p_schedule_from_date IN VARCHAR2,
948 p_schedule_to_date IN VARCHAR2,
949 p_planned_qty_g IN NUMBER,
950 p_planned_qty_sg IN NUMBER,
951 p_primary_uom IN VARCHAR2,
952 p_secondary_uom IN VARCHAR2,
953 p_system_fk IN VARCHAR2,
954 p_user_dim1_fk IN VARCHAR2,
955 p_user_dim2_fk IN VARCHAR2,
956 p_user_dim3_fk IN VARCHAR2,
957 p_user_dim4_fk IN VARCHAR2,
958 p_user_dim5_fk IN VARCHAR2,
959 p_user_attr1 IN VARCHAR2,
960 p_user_attr2 IN VARCHAR2,
961 p_user_attr3 IN VARCHAR2,
962 p_user_attr4 IN VARCHAR2,
963 p_user_attr5 IN VARCHAR2,
964 p_user_measure1 IN NUMBER,
965 p_user_measure2 IN NUMBER,
966 p_user_measure3 IN NUMBER,
967 p_user_measure4 IN NUMBER,
968 p_user_measure5 IN NUMBER,
969 p_rowid IN ROWID
970 ) IS
971 BEGIN
972
973 IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
974
975 FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
976 RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
977
978 ELSIF p_rowid IS NOT NULL THEN
979
980 UPDATE MTH_EQUIP_PROD_SCHEDULE_ERR SET
981 REPROCESS_READY_YN = p_reprocess_ready_yn
982 ,EQUIP_SCHEDULE_PK = p_equip_schedule_pk
983 ,EQUIPMENT_FK = p_equipment_fk
984 ,WORKORDER_FK = p_workorder_fk
985 ,SEGMENT_FK = p_segment_fk
986 ,SHIFT_WORKDAY_FK = p_shift_workday_fk
987 ,ITEM_FK = p_item_fk
988 ,SCHEDULE_FROM_DATE = fnd_date.canonical_to_date(p_schedule_from_date)
989 ,SCHEDULE_TO_DATE = fnd_date.canonical_to_date(p_schedule_to_date)
990 ,PLANNED_QTY_G = p_planned_qty_g
991 ,PLANNED_QTY_SG = p_planned_qty_sg
992 ,PRIMARY_UOM = p_primary_uom
993 ,SECONDARY_UOM = p_secondary_uom
994 ,SYSTEM_FK = p_system_fk
995 ,USER_DIM1_FK = p_user_dim1_fk
996 ,USER_DIM2_FK = p_user_dim2_fk
997 ,USER_DIM3_FK = p_user_dim3_fk
998 ,USER_DIM4_FK = p_user_dim4_fk
999 ,USER_DIM5_FK = p_user_dim5_fk
1000 ,USER_ATTR1 = p_user_attr1
1001 ,USER_ATTR2 = p_user_attr2
1002 ,USER_ATTR3 = p_user_attr3
1003 ,USER_ATTR4 = p_user_attr4
1007 ,USER_MEASURE3 = p_user_measure3
1004 ,USER_ATTR5 = p_user_attr5
1005 ,USER_MEASURE1 = p_user_measure1
1006 ,USER_MEASURE2 = p_user_measure2
1008 ,USER_MEASURE4 = p_user_measure4
1009 ,USER_MEASURE5 = p_user_measure5
1010 WHERE ROWID = p_rowid;
1011
1012 ELSE
1013
1014 INSERT INTO MTH_EQUIP_PROD_SCHEDULE_ERR (
1015 REPROCESS_READY_YN
1016 ,EQUIP_SCHEDULE_PK
1017 ,EQUIPMENT_FK
1018 ,WORKORDER_FK
1019 ,SEGMENT_FK
1020 ,SHIFT_WORKDAY_FK
1021 ,ITEM_FK
1022 ,SCHEDULE_FROM_DATE
1023 ,SCHEDULE_TO_DATE
1024 ,PLANNED_QTY_G
1025 ,PLANNED_QTY_SG
1026 ,PRIMARY_UOM
1027 ,SECONDARY_UOM
1028 ,SYSTEM_FK
1029 ,USER_DIM1_FK
1030 ,USER_DIM2_FK
1031 ,USER_DIM3_FK
1032 ,USER_DIM4_FK
1033 ,USER_DIM5_FK
1034 ,USER_ATTR1
1035 ,USER_ATTR2
1036 ,USER_ATTR3
1037 ,USER_ATTR4
1038 ,USER_ATTR5
1039 ,USER_MEASURE1
1040 ,USER_MEASURE2
1041 ,USER_MEASURE3
1042 ,USER_MEASURE4
1043 ,USER_MEASURE5
1044 ) VALUES (
1045 p_reprocess_ready_yn
1046 ,p_equip_schedule_pk
1047 ,p_equipment_fk
1048 ,p_workorder_fk
1049 ,p_segment_fk
1050 ,p_shift_workday_fk
1051 ,p_item_fk
1052 ,fnd_date.canonical_to_date(p_schedule_from_date)
1053 ,fnd_date.canonical_to_date(p_schedule_to_date)
1054 ,p_planned_qty_g
1055 ,p_planned_qty_sg
1056 ,p_primary_uom
1057 ,p_secondary_uom
1058 ,p_system_fk
1059 ,p_user_dim1_fk
1060 ,p_user_dim2_fk
1061 ,p_user_dim3_fk
1062 ,p_user_dim4_fk
1063 ,p_user_dim5_fk
1064 ,p_user_attr1
1065 ,p_user_attr2
1066 ,p_user_attr3
1067 ,p_user_attr4
1068 ,p_user_attr5
1069 ,p_user_measure1
1070 ,p_user_measure2
1071 ,p_user_measure3
1072 ,p_user_measure4
1073 ,p_user_measure5
1074 );
1075
1076 END IF;
1077
1078 END UPD_EQUIP_PROD_SCHEDULE_ERR;
1079
1080 PROCEDURE UPD_EQUIP_STANDARD_RATES_ERR (
1081 p_err_code IN VARCHAR2,
1082 p_reprocess_ready_yn IN VARCHAR2,
1083 p_equipment_fk IN VARCHAR2,
1084 p_shift_workday_fk IN VARCHAR2,
1085 p_item_fk IN VARCHAR2,
1086 p_standard_rate_1 IN NUMBER,
1087 p_standard_rate_2 IN NUMBER,
1088 p_standard_rate_3 IN NUMBER,
1089 p_source_org_code IN VARCHAR2,
1090 p_system_fk IN VARCHAR2,
1091 p_user_dim1_fk IN VARCHAR2,
1092 p_user_dim2_fk IN VARCHAR2,
1093 p_user_dim3_fk IN VARCHAR2,
1094 p_user_dim4_fk IN VARCHAR2,
1095 p_user_dim5_fk IN VARCHAR2,
1096 p_user_attr1 IN VARCHAR2,
1097 p_user_attr2 IN VARCHAR2,
1098 p_user_attr3 IN VARCHAR2,
1099 p_user_attr4 IN VARCHAR2,
1100 p_user_attr5 IN VARCHAR2,
1101 p_user_measure1 IN NUMBER,
1102 p_user_measure2 IN NUMBER,
1103 p_user_measure3 IN NUMBER,
1104 p_user_measure4 IN NUMBER,
1105 p_user_measure5 IN NUMBER,
1106 p_recipe_num IN VARCHAR2,
1107 p_recipe_version IN VARCHAR2,
1108 p_rowid IN ROWID
1109 ) IS
1110 BEGIN
1111
1112 IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
1113
1114 FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
1115 RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
1116
1117 ELSIF p_rowid IS NOT NULL THEN
1118
1119 UPDATE MTH_EQUIP_STANDARD_RATES_ERR SET
1120 REPROCESS_READY_YN = p_reprocess_ready_yn
1121 ,EQUIPMENT_FK = p_equipment_fk
1122 ,SHIFT_WORKDAY_FK = p_shift_workday_fk
1123 ,ITEM_FK = p_item_fk
1124 ,STANDARD_RATE_1 = p_standard_rate_1
1125 ,STANDARD_RATE_2 = p_standard_rate_2
1126 ,STANDARD_RATE_3 = p_standard_rate_3
1130 ,USER_DIM2_FK = p_user_dim2_fk
1127 ,SOURCE_ORG_CODE = p_source_org_code
1128 ,SYSTEM_FK = p_system_fk
1129 ,USER_DIM1_FK = p_user_dim1_fk
1131 ,USER_DIM3_FK = p_user_dim3_fk
1132 ,USER_DIM4_FK = p_user_dim4_fk
1133 ,USER_DIM5_FK = p_user_dim5_fk
1134 ,USER_ATTR1 = p_user_attr1
1135 ,USER_ATTR2 = p_user_attr2
1136 ,USER_ATTR3 = p_user_attr3
1137 ,USER_ATTR4 = p_user_attr4
1138 ,USER_ATTR5 = p_user_attr5
1139 ,USER_MEASURE1 = p_user_measure1
1140 ,USER_MEASURE2 = p_user_measure2
1141 ,USER_MEASURE3 = p_user_measure3
1142 ,USER_MEASURE4 = p_user_measure4
1143 ,USER_MEASURE5 = p_user_measure5
1144 ,RECIPE_NUM = p_recipe_num
1145 ,RECIPE_VERSION = p_recipe_version
1146 WHERE ROWID = p_rowid;
1147
1148 ELSE
1149
1150 INSERT INTO MTH_EQUIP_STANDARD_RATES_ERR (
1151 REPROCESS_READY_YN
1152 ,EQUIPMENT_FK
1153 ,SHIFT_WORKDAY_FK
1154 ,ITEM_FK
1155 ,STANDARD_RATE_1
1156 ,STANDARD_RATE_2
1157 ,STANDARD_RATE_3
1158 ,SOURCE_ORG_CODE
1159 ,SYSTEM_FK
1160 ,USER_DIM1_FK
1161 ,USER_DIM2_FK
1162 ,USER_DIM3_FK
1163 ,USER_DIM4_FK
1164 ,USER_DIM5_FK
1165 ,USER_ATTR1
1166 ,USER_ATTR2
1167 ,USER_ATTR3
1168 ,USER_ATTR4
1169 ,USER_ATTR5
1170 ,USER_MEASURE1
1171 ,USER_MEASURE2
1172 ,USER_MEASURE3
1173 ,USER_MEASURE4
1174 ,USER_MEASURE5
1175 ,RECIPE_NUM
1176 ,RECIPE_VERSION
1177 ) VALUES (
1178 p_reprocess_ready_yn
1179 ,p_equipment_fk
1180 ,p_shift_workday_fk
1181 ,p_item_fk
1182 ,p_standard_rate_1
1183 ,p_standard_rate_2
1184 ,p_standard_rate_3
1185 ,p_source_org_code
1186 ,p_system_fk
1187 ,p_user_dim1_fk
1188 ,p_user_dim2_fk
1189 ,p_user_dim3_fk
1190 ,p_user_dim4_fk
1191 ,p_user_dim5_fk
1192 ,p_user_attr1
1193 ,p_user_attr2
1194 ,p_user_attr3
1195 ,p_user_attr4
1196 ,p_user_attr5
1197 ,p_user_measure1
1198 ,p_user_measure2
1199 ,p_user_measure3
1200 ,p_user_measure4
1201 ,p_user_measure5
1202 ,p_recipe_num
1203 ,p_recipe_version
1204 );
1205
1206 END IF;
1207
1208 END UPD_EQUIP_STANDARD_RATES_ERR;
1209
1210 PROCEDURE UPD_EQUIP_STATUSES_ERR (
1211 p_err_code IN VARCHAR2,
1212 p_reprocess_ready_yn IN VARCHAR2,
1213 p_equipment_fk IN VARCHAR2,
1214 p_shift_workday_fk IN VARCHAR2,
1215 p_from_date IN VARCHAR2,
1216 p_to_date IN VARCHAR2,
1217 p_status IN VARCHAR2,
1218 p_system_fk IN VARCHAR2,
1219 p_user_dim1_fk IN VARCHAR2,
1220 p_user_dim2_fk IN VARCHAR2,
1221 p_user_dim3_fk IN VARCHAR2,
1222 p_user_dim4_fk IN VARCHAR2,
1223 p_user_dim5_fk IN VARCHAR2,
1224 p_user_attr1 IN VARCHAR2,
1225 p_user_attr2 IN VARCHAR2,
1226 p_user_attr3 IN VARCHAR2,
1227 p_user_attr4 IN VARCHAR2,
1228 p_user_attr5 IN VARCHAR2,
1229 p_user_measure1 IN NUMBER,
1230 p_user_measure2 IN NUMBER,
1231 p_user_measure3 IN NUMBER,
1232 p_user_measure4 IN NUMBER,
1233 p_user_measure5 IN NUMBER,
1234 p_downtime_reason_code IN VARCHAR2,
1235 p_rowid IN ROWID
1236 ) IS
1237 BEGIN
1238
1239 IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
1240
1241 FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
1242 RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
1243
1244 ELSIF p_rowid IS NOT NULL THEN
1245
1246 UPDATE MTH_EQUIP_STATUSES_ERR SET
1247 REPROCESS_READY_YN = p_reprocess_ready_yn
1251 ,TO_DATE = fnd_date.canonical_to_date(p_to_date)
1248 ,EQUIPMENT_FK = p_equipment_fk
1249 ,SHIFT_WORKDAY_FK = p_shift_workday_fk
1250 ,FROM_DATE = fnd_date.canonical_to_date(p_from_date)
1252 ,STATUS = p_status
1253 ,SYSTEM_FK = p_system_fk
1254 ,USER_DIM1_FK = p_user_dim1_fk
1255 ,USER_DIM2_FK = p_user_dim2_fk
1256 ,USER_DIM3_FK = p_user_dim3_fk
1257 ,USER_DIM4_FK = p_user_dim4_fk
1258 ,USER_DIM5_FK = p_user_dim5_fk
1259 ,USER_ATTR1 = p_user_attr1
1260 ,USER_ATTR2 = p_user_attr2
1261 ,USER_ATTR3 = p_user_attr3
1262 ,USER_ATTR4 = p_user_attr4
1263 ,USER_ATTR5 = p_user_attr5
1264 ,USER_MEASURE1 = p_user_measure1
1265 ,USER_MEASURE2 = p_user_measure2
1266 ,USER_MEASURE3 = p_user_measure3
1267 ,USER_MEASURE4 = p_user_measure4
1268 ,USER_MEASURE5 = p_user_measure5
1269 ,DOWNTIME_REASON_CODE = p_downtime_reason_code
1270 WHERE ROWID = p_rowid;
1271
1272 ELSE
1273
1274 INSERT INTO MTH_EQUIP_STATUSES_ERR (
1275 REPROCESS_READY_YN
1276 ,EQUIPMENT_FK
1277 ,SHIFT_WORKDAY_FK
1278 ,FROM_DATE
1279 ,TO_DATE
1280 ,STATUS
1281 ,SYSTEM_FK
1282 ,USER_DIM1_FK
1283 ,USER_DIM2_FK
1284 ,USER_DIM3_FK
1285 ,USER_DIM4_FK
1286 ,USER_DIM5_FK
1287 ,USER_ATTR1
1288 ,USER_ATTR2
1289 ,USER_ATTR3
1290 ,USER_ATTR4
1291 ,USER_ATTR5
1292 ,USER_MEASURE1
1293 ,USER_MEASURE2
1294 ,USER_MEASURE3
1295 ,USER_MEASURE4
1296 ,USER_MEASURE5
1297 ,DOWNTIME_REASON_CODE
1298 ) VALUES (
1299 p_reprocess_ready_yn
1300 ,p_equipment_fk
1301 ,p_shift_workday_fk
1302 ,fnd_date.canonical_to_date(p_from_date)
1303 ,fnd_date.canonical_to_date(p_to_date)
1304 ,p_status
1305 ,p_system_fk
1306 ,p_user_dim1_fk
1307 ,p_user_dim2_fk
1308 ,p_user_dim3_fk
1309 ,p_user_dim4_fk
1310 ,p_user_dim5_fk
1311 ,p_user_attr1
1312 ,p_user_attr2
1313 ,p_user_attr3
1314 ,p_user_attr4
1315 ,p_user_attr5
1316 ,p_user_measure1
1317 ,p_user_measure2
1318 ,p_user_measure3
1319 ,p_user_measure4
1320 ,p_user_measure5
1321 ,p_downtime_reason_code
1322 );
1323
1324 END IF;
1325
1326 END UPD_EQUIP_STATUSES_ERR;
1327
1328 PROCEDURE UPD_EVENT_ACTION_SETUP_ERR (
1329 p_err_code IN VARCHAR2,
1330 p_reprocess_ready_yn IN VARCHAR2,
1331 p_equipment_fk IN VARCHAR2,
1332 p_event_type_code IN VARCHAR2,
1333 p_reason_code IN VARCHAR2,
1334 p_action_type_code IN VARCHAR2,
1335 p_personnel_fk IN VARCHAR2,
1336 p_action_handler_code IN VARCHAR2,
1337 p_email_notification IN VARCHAR2,
1338 p_mobile_notification IN VARCHAR2,
1339 p_domain_name IN VARCHAR2,
1340 p_rowid IN ROWID
1341 ) IS
1342 BEGIN
1343
1344 IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
1345
1346 FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
1347 RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
1348
1349 ELSIF p_rowid IS NOT NULL THEN
1350
1351 UPDATE MTH_EVENT_ACTION_SETUP_ERR SET
1352 REPROCESS_READY_YN = p_reprocess_ready_yn
1353 ,EQUIPMENT_FK = p_equipment_fk
1354 ,EVENT_TYPE_CODE = p_event_type_code
1355 ,REASON_CODE = p_reason_code
1356 ,ACTION_TYPE_CODE = p_action_type_code
1357 ,PERSONNEL_FK = p_personnel_fk
1358 ,ACTION_HANDLER_CODE = p_action_handler_code
1359 ,EMAIL_NOTIFICATION = p_email_notification
1360 ,MOBILE_NOTIFICATION = p_mobile_notification
1361 ,DOMAIN_NAME = p_domain_name
1362 WHERE ROWID = p_rowid;
1363
1364 ELSE
1368 ,EQUIPMENT_FK
1365
1366 INSERT INTO MTH_EVENT_ACTION_SETUP_ERR (
1367 REPROCESS_READY_YN
1369 ,EVENT_TYPE_CODE
1370 ,REASON_CODE
1371 ,ACTION_TYPE_CODE
1372 ,PERSONNEL_FK
1373 ,ACTION_HANDLER_CODE
1374 ,EMAIL_NOTIFICATION
1375 ,MOBILE_NOTIFICATION
1376 ,DOMAIN_NAME
1377 ) VALUES (
1378 p_reprocess_ready_yn
1379 ,p_equipment_fk
1380 ,p_event_type_code
1381 ,p_reason_code
1382 ,p_action_type_code
1383 ,p_personnel_fk
1384 ,p_action_handler_code
1385 ,p_email_notification
1386 ,p_mobile_notification
1387 ,p_domain_name
1388 );
1389
1390 END IF;
1391
1392 END UPD_EVENT_ACTION_SETUP_ERR;
1393
1394 PROCEDURE UPD_ITEMS_ERR (
1395 p_err_code IN VARCHAR2,
1396 p_reprocess_ready_yn IN VARCHAR2,
1397 p_item_pk IN VARCHAR2,
1398 p_system_fk IN VARCHAR2,
1399 p_source_org_code IN VARCHAR2,
1400 p_item_name IN VARCHAR2,
1401 p_primary_uom IN VARCHAR2,
1402 p_secondary_uom IN VARCHAR2,
1403 p_ebs_item_id IN NUMBER,
1404 p_ebs_org_id IN NUMBER,
1405 p_description IN VARCHAR2,
1406 p_unit_weight IN NUMBER,
1407 p_weight_uom IN VARCHAR2,
1408 p_unit_volume IN NUMBER,
1409 p_volume_uom IN VARCHAR2,
1410 p_base_item IN VARCHAR2,
1411 p_user_attr1 IN VARCHAR2,
1412 p_user_attr2 IN VARCHAR2,
1413 p_user_attr3 IN VARCHAR2,
1414 p_user_attr4 IN VARCHAR2,
1415 p_user_attr5 IN VARCHAR2,
1416 p_user_attr6 IN VARCHAR2,
1417 p_user_attr7 IN VARCHAR2,
1418 p_user_attr8 IN VARCHAR2,
1419 p_user_attr9 IN VARCHAR2,
1420 p_user_attr10 IN VARCHAR2,
1421 p_user_attr11 IN VARCHAR2,
1422 p_user_attr12 IN VARCHAR2,
1423 p_user_attr13 IN VARCHAR2,
1424 p_user_attr14 IN VARCHAR2,
1425 p_user_attr15 IN VARCHAR2,
1426 p_user_attr16 IN VARCHAR2,
1427 p_user_attr17 IN VARCHAR2,
1428 p_user_attr18 IN VARCHAR2,
1429 p_user_attr19 IN VARCHAR2,
1430 p_user_attr20 IN VARCHAR2,
1431 p_user_measure1 IN NUMBER,
1432 p_user_measure2 IN NUMBER,
1433 p_user_measure3 IN NUMBER,
1434 p_user_measure4 IN NUMBER,
1435 p_user_measure5 IN NUMBER,
1436 p_user_attr21 IN VARCHAR2,
1437 p_user_attr22 IN VARCHAR2,
1438 p_user_attr23 IN VARCHAR2,
1439 p_user_attr24 IN VARCHAR2,
1440 p_user_attr25 IN VARCHAR2,
1441 p_user_attr26 IN VARCHAR2,
1442 p_user_attr27 IN VARCHAR2,
1443 p_user_attr28 IN VARCHAR2,
1444 p_user_attr29 IN VARCHAR2,
1445 p_user_attr30 IN VARCHAR2,
1446 p_rowid IN ROWID
1447 ) IS
1448 BEGIN
1449
1450 IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
1451
1452 FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
1453 RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
1454
1455 ELSIF p_rowid IS NOT NULL THEN
1456
1457 UPDATE MTH_ITEMS_ERR SET
1458 REPROCESS_READY_YN = p_reprocess_ready_yn
1459 ,ITEM_PK = p_item_pk
1460 ,SYSTEM_FK = p_system_fk
1461 ,SOURCE_ORG_CODE = p_source_org_code
1462 ,ITEM_NAME = p_item_name
1463 ,PRIMARY_UOM = p_primary_uom
1464 ,SECONDARY_UOM = p_secondary_uom
1465 ,EBS_ITEM_ID = p_ebs_item_id
1466 ,EBS_ORG_ID = p_ebs_org_id
1467 ,DESCRIPTION = p_description
1468 ,UNIT_WEIGHT = p_unit_weight
1469 ,WEIGHT_UOM = p_weight_uom
1470 ,UNIT_VOLUME = p_unit_volume
1471 ,VOLUME_UOM = p_volume_uom
1472 ,BASE_ITEM = p_base_item
1473 ,USER_ATTR1 = p_user_attr1
1474 ,USER_ATTR2 = p_user_attr2
1475 ,USER_ATTR3 = p_user_attr3
1476 ,USER_ATTR4 = p_user_attr4
1480 ,USER_ATTR8 = p_user_attr8
1477 ,USER_ATTR5 = p_user_attr5
1478 ,USER_ATTR6 = p_user_attr6
1479 ,USER_ATTR7 = p_user_attr7
1481 ,USER_ATTR9 = p_user_attr9
1482 ,USER_ATTR10 = p_user_attr10
1483 ,USER_ATTR11 = p_user_attr11
1484 ,USER_ATTR12 = p_user_attr12
1485 ,USER_ATTR13 = p_user_attr13
1486 ,USER_ATTR14 = p_user_attr14
1487 ,USER_ATTR15 = p_user_attr15
1488 ,USER_ATTR16 = p_user_attr16
1489 ,USER_ATTR17 = p_user_attr17
1490 ,USER_ATTR18 = p_user_attr18
1491 ,USER_ATTR19 = p_user_attr19
1492 ,USER_ATTR20 = p_user_attr20
1493 ,USER_MEASURE1 = p_user_measure1
1494 ,USER_MEASURE2 = p_user_measure2
1495 ,USER_MEASURE3 = p_user_measure3
1496 ,USER_MEASURE4 = p_user_measure4
1497 ,USER_MEASURE5 = p_user_measure5
1498 ,USER_ATTR21 = p_user_attr21
1499 ,USER_ATTR22 = p_user_attr22
1500 ,USER_ATTR23 = p_user_attr23
1501 ,USER_ATTR24 = p_user_attr24
1502 ,USER_ATTR25 = p_user_attr25
1503 ,USER_ATTR26 = p_user_attr26
1504 ,USER_ATTR27 = p_user_attr27
1505 ,USER_ATTR28 = p_user_attr28
1506 ,USER_ATTR29 = p_user_attr29
1507 ,USER_ATTR30 = p_user_attr30
1508 WHERE ROWID = p_rowid;
1509
1510 ELSE
1511
1512 INSERT INTO MTH_ITEMS_ERR (
1513 REPROCESS_READY_YN
1514 ,ITEM_PK
1515 ,SYSTEM_FK
1516 ,SOURCE_ORG_CODE
1517 ,ITEM_NAME
1518 ,PRIMARY_UOM
1519 ,SECONDARY_UOM
1520 ,EBS_ITEM_ID
1521 ,EBS_ORG_ID
1522 ,DESCRIPTION
1523 ,UNIT_WEIGHT
1524 ,WEIGHT_UOM
1525 ,UNIT_VOLUME
1526 ,VOLUME_UOM
1527 ,BASE_ITEM
1528 ,USER_ATTR1
1529 ,USER_ATTR2
1530 ,USER_ATTR3
1531 ,USER_ATTR4
1532 ,USER_ATTR5
1533 ,USER_ATTR6
1534 ,USER_ATTR7
1535 ,USER_ATTR8
1536 ,USER_ATTR9
1537 ,USER_ATTR10
1538 ,USER_ATTR11
1539 ,USER_ATTR12
1540 ,USER_ATTR13
1541 ,USER_ATTR14
1542 ,USER_ATTR15
1543 ,USER_ATTR16
1544 ,USER_ATTR17
1545 ,USER_ATTR18
1546 ,USER_ATTR19
1547 ,USER_ATTR20
1548 ,USER_MEASURE1
1549 ,USER_MEASURE2
1550 ,USER_MEASURE3
1551 ,USER_MEASURE4
1552 ,USER_MEASURE5
1553 ,USER_ATTR21
1554 ,USER_ATTR22
1555 ,USER_ATTR23
1556 ,USER_ATTR24
1557 ,USER_ATTR25
1558 ,USER_ATTR26
1559 ,USER_ATTR27
1560 ,USER_ATTR28
1561 ,USER_ATTR29
1562 ,USER_ATTR30
1563 ) VALUES (
1564 p_reprocess_ready_yn
1565 ,p_item_pk
1566 ,p_system_fk
1567 ,p_source_org_code
1568 ,p_item_name
1569 ,p_primary_uom
1570 ,p_secondary_uom
1571 ,p_ebs_item_id
1572 ,p_ebs_org_id
1573 ,p_description
1574 ,p_unit_weight
1575 ,p_weight_uom
1576 ,p_unit_volume
1577 ,p_volume_uom
1578 ,p_base_item
1579 ,p_user_attr1
1580 ,p_user_attr2
1581 ,p_user_attr3
1582 ,p_user_attr4
1583 ,p_user_attr5
1584 ,p_user_attr6
1585 ,p_user_attr7
1586 ,p_user_attr8
1587 ,p_user_attr9
1588 ,p_user_attr10
1589 ,p_user_attr11
1590 ,p_user_attr12
1591 ,p_user_attr13
1592 ,p_user_attr14
1593 ,p_user_attr15
1594 ,p_user_attr16
1595 ,p_user_attr17
1596 ,p_user_attr18
1600 ,p_user_measure2
1597 ,p_user_attr19
1598 ,p_user_attr20
1599 ,p_user_measure1
1601 ,p_user_measure3
1602 ,p_user_measure4
1603 ,p_user_measure5
1604 ,p_user_attr21
1605 ,p_user_attr22
1606 ,p_user_attr23
1607 ,p_user_attr24
1608 ,p_user_attr25
1609 ,p_user_attr26
1610 ,p_user_attr27
1611 ,p_user_attr28
1612 ,p_user_attr29
1613 ,p_user_attr30
1614 );
1615
1616 END IF;
1617
1618 END UPD_ITEMS_ERR;
1619
1620 PROCEDURE UPD_ITEM_CATEGORIES_ERR (
1621 p_err_code IN VARCHAR2,
1622 p_reprocess_ready_yn IN VARCHAR2,
1623 p_category_pk IN VARCHAR2,
1624 p_system_fk IN VARCHAR2,
1625 p_category_name IN VARCHAR2,
1626 p_description IN VARCHAR2,
1627 p_ebs_category_id IN NUMBER,
1628 p_user_attr1 IN VARCHAR2,
1629 p_user_attr2 IN VARCHAR2,
1630 p_user_attr3 IN VARCHAR2,
1631 p_user_attr4 IN VARCHAR2,
1632 p_user_attr5 IN VARCHAR2,
1633 p_user_measure1 IN NUMBER,
1634 p_user_measure2 IN NUMBER,
1635 p_user_measure3 IN NUMBER,
1636 p_user_measure4 IN NUMBER,
1637 p_user_measure5 IN NUMBER,
1638 p_segment1 IN VARCHAR2,
1639 p_segment2 IN VARCHAR2,
1640 p_segment3 IN VARCHAR2,
1641 p_segment4 IN VARCHAR2,
1642 p_segment5 IN VARCHAR2,
1643 p_segment6 IN VARCHAR2,
1644 p_segment7 IN VARCHAR2,
1645 p_segment8 IN VARCHAR2,
1646 p_segment9 IN VARCHAR2,
1647 p_segment10 IN VARCHAR2,
1648 p_segment11 IN VARCHAR2,
1649 p_segment12 IN VARCHAR2,
1650 p_segment13 IN VARCHAR2,
1651 p_segment14 IN VARCHAR2,
1652 p_segment15 IN VARCHAR2,
1653 p_segment16 IN VARCHAR2,
1654 p_segment17 IN VARCHAR2,
1655 p_segment18 IN VARCHAR2,
1656 p_segment19 IN VARCHAR2,
1657 p_segment20 IN VARCHAR2,
1658 p_rowid IN ROWID
1659 ) IS
1660 BEGIN
1661
1662 IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
1663
1664 FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
1665 RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
1666
1667 ELSIF p_rowid IS NOT NULL THEN
1668
1669 UPDATE MTH_ITEM_CATEGORIES_ERR SET
1670 REPROCESS_READY_YN = p_reprocess_ready_yn
1671 ,CATEGORY_PK = p_category_pk
1672 ,SYSTEM_FK = p_system_fk
1673 ,CATEGORY_NAME = p_category_name
1674 ,DESCRIPTION = p_description
1675 ,EBS_CATEGORY_ID = p_ebs_category_id
1676 ,USER_ATTR1 = p_user_attr1
1677 ,USER_ATTR2 = p_user_attr2
1678 ,USER_ATTR3 = p_user_attr3
1679 ,USER_ATTR4 = p_user_attr4
1680 ,USER_ATTR5 = p_user_attr5
1681 ,USER_MEASURE1 = p_user_measure1
1682 ,USER_MEASURE2 = p_user_measure2
1683 ,USER_MEASURE3 = p_user_measure3
1684 ,USER_MEASURE4 = p_user_measure4
1685 ,USER_MEASURE5 = p_user_measure5
1686 ,SEGMENT1 = p_segment1
1687 ,SEGMENT2 = p_segment2
1688 ,SEGMENT3 = p_segment3
1689 ,SEGMENT4 = p_segment4
1690 ,SEGMENT5 = p_segment5
1691 ,SEGMENT6 = p_segment6
1692 ,SEGMENT7 = p_segment7
1693 ,SEGMENT8 = p_segment8
1694 ,SEGMENT9 = p_segment9
1695 ,SEGMENT10 = p_segment10
1696 ,SEGMENT11 = p_segment11
1697 ,SEGMENT12 = p_segment12
1698 ,SEGMENT13 = p_segment13
1699 ,SEGMENT14 = p_segment14
1700 ,SEGMENT15 = p_segment15
1701 ,SEGMENT16 = p_segment16
1702 ,SEGMENT17 = p_segment17
1703 ,SEGMENT18 = p_segment18
1707
1704 ,SEGMENT19 = p_segment19
1705 ,SEGMENT20 = p_segment20
1706 WHERE ROWID = p_rowid;
1708 ELSE
1709
1710 INSERT INTO MTH_ITEM_CATEGORIES_ERR (
1711 REPROCESS_READY_YN
1712 ,CATEGORY_PK
1713 ,SYSTEM_FK
1714 ,CATEGORY_NAME
1715 ,DESCRIPTION
1716 ,EBS_CATEGORY_ID
1717 ,USER_ATTR1
1718 ,USER_ATTR2
1719 ,USER_ATTR3
1720 ,USER_ATTR4
1721 ,USER_ATTR5
1722 ,USER_MEASURE1
1723 ,USER_MEASURE2
1724 ,USER_MEASURE3
1725 ,USER_MEASURE4
1726 ,USER_MEASURE5
1727 ,SEGMENT1
1728 ,SEGMENT2
1729 ,SEGMENT3
1730 ,SEGMENT4
1731 ,SEGMENT5
1732 ,SEGMENT6
1733 ,SEGMENT7
1734 ,SEGMENT8
1735 ,SEGMENT9
1736 ,SEGMENT10
1737 ,SEGMENT11
1738 ,SEGMENT12
1739 ,SEGMENT13
1740 ,SEGMENT14
1741 ,SEGMENT15
1742 ,SEGMENT16
1743 ,SEGMENT17
1744 ,SEGMENT18
1745 ,SEGMENT19
1746 ,SEGMENT20
1747 ) VALUES (
1748 p_reprocess_ready_yn
1749 ,p_category_pk
1750 ,p_system_fk
1751 ,p_category_name
1752 ,p_description
1753 ,p_ebs_category_id
1754 ,p_user_attr1
1755 ,p_user_attr2
1756 ,p_user_attr3
1757 ,p_user_attr4
1758 ,p_user_attr5
1759 ,p_user_measure1
1760 ,p_user_measure2
1761 ,p_user_measure3
1762 ,p_user_measure4
1763 ,p_user_measure5
1764 ,p_segment1
1765 ,p_segment2
1766 ,p_segment3
1767 ,p_segment4
1768 ,p_segment5
1769 ,p_segment6
1770 ,p_segment7
1771 ,p_segment8
1772 ,p_segment9
1773 ,p_segment10
1774 ,p_segment11
1775 ,p_segment12
1776 ,p_segment13
1777 ,p_segment14
1778 ,p_segment15
1779 ,p_segment16
1780 ,p_segment17
1781 ,p_segment18
1782 ,p_segment19
1783 ,p_segment20
1784 );
1785
1786 END IF;
1787
1788 END UPD_ITEM_CATEGORIES_ERR;
1789
1790 PROCEDURE UPD_ITEM_COST_ERR (
1791 p_err_code IN VARCHAR2,
1792 p_reprocess_ready_yn IN VARCHAR2,
1793 p_system_fk IN VARCHAR2,
1794 p_item_fk IN VARCHAR2,
1795 p_item_cost IN NUMBER,
1796 p_from_date IN VARCHAR2,
1797 p_to_date IN VARCHAR2,
1798 p_cost_element IN VARCHAR2,
1799 p_user_attr1 IN VARCHAR2,
1800 p_user_attr2 IN VARCHAR2,
1801 p_user_attr3 IN VARCHAR2,
1802 p_user_attr4 IN VARCHAR2,
1803 p_user_attr5 IN VARCHAR2,
1804 p_rowid IN ROWID
1805 ) IS
1806 BEGIN
1807
1808 IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
1809
1810 FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
1811 RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
1812
1813 ELSIF p_rowid IS NOT NULL THEN
1814
1815 UPDATE MTH_ITEM_COST_ERR SET
1816 REPROCESS_READY_YN = p_reprocess_ready_yn
1817 ,SYSTEM_FK = p_system_fk
1818 ,ITEM_FK = p_item_fk
1819 ,ITEM_COST = p_item_cost
1820 ,FROM_DATE = fnd_date.canonical_to_date(p_from_date)
1821 ,TO_DATE = fnd_date.canonical_to_date(p_to_date)
1822 ,COST_ELEMENT = p_cost_element
1823 ,USER_ATTR1 = p_user_attr1
1824 ,USER_ATTR2 = p_user_attr2
1825 ,USER_ATTR3 = p_user_attr3
1826 ,USER_ATTR4 = p_user_attr4
1827 ,USER_ATTR5 = p_user_attr5
1828 WHERE ROWID = p_rowid;
1829
1830 ELSE
1831
1832 INSERT INTO MTH_ITEM_COST_ERR (
1833 REPROCESS_READY_YN
1834 ,SYSTEM_FK
1835 ,ITEM_FK
1836 ,ITEM_COST
1840 ,USER_ATTR1
1837 ,FROM_DATE
1838 ,TO_DATE
1839 ,COST_ELEMENT
1841 ,USER_ATTR2
1842 ,USER_ATTR3
1843 ,USER_ATTR4
1844 ,USER_ATTR5
1845 ) VALUES (
1846 p_reprocess_ready_yn
1847 ,p_system_fk
1848 ,p_item_fk
1849 ,p_item_cost
1850 ,fnd_date.canonical_to_date(p_from_date)
1851 ,fnd_date.canonical_to_date(p_to_date)
1852 ,p_cost_element
1853 ,p_user_attr1
1854 ,p_user_attr2
1855 ,p_user_attr3
1856 ,p_user_attr4
1857 ,p_user_attr5
1858 );
1859
1860 END IF;
1861
1862 END UPD_ITEM_COST_ERR;
1863
1864 PROCEDURE UPD_ITEM_HIERARCHY_ERR (
1865 p_err_code IN VARCHAR2,
1866 p_reprocess_ready_yn IN VARCHAR2,
1867 p_level_fk IN VARCHAR2,
1868 p_parent_fk IN VARCHAR2,
1869 p_hierarchy_name IN VARCHAR2,
1870 p_level_num IN NUMBER,
1871 p_system_fk IN VARCHAR2,
1872 p_rowid IN ROWID
1873 ) IS
1874 BEGIN
1875
1876 IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
1877
1878 FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
1879 RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
1880
1881 ELSIF p_rowid IS NOT NULL THEN
1882
1883 UPDATE MTH_ITEM_HIERARCHY_ERR SET
1884 REPROCESS_READY_YN = p_reprocess_ready_yn
1885 ,LEVEL_FK = p_level_fk
1886 ,PARENT_FK = p_parent_fk
1887 ,HIERARCHY_NAME = p_hierarchy_name
1888 ,LEVEL_NUM = p_level_num
1889 ,SYSTEM_FK = p_system_fk
1890 WHERE ROWID = p_rowid;
1891
1892 ELSE
1893
1894 INSERT INTO MTH_ITEM_HIERARCHY_ERR (
1895 REPROCESS_READY_YN
1896 ,LEVEL_FK
1897 ,PARENT_FK
1898 ,HIERARCHY_NAME
1899 ,LEVEL_NUM
1900 ,SYSTEM_FK
1901 ) VALUES (
1902 p_reprocess_ready_yn
1903 ,p_level_fk
1904 ,p_parent_fk
1905 ,p_hierarchy_name
1906 ,p_level_num
1907 ,p_system_fk
1908 );
1909
1910 END IF;
1911
1912 END UPD_ITEM_HIERARCHY_ERR;
1913
1914 PROCEDURE UPD_METER_READINGS_ERR (
1915 p_err_code IN VARCHAR2,
1916 p_reprocess_ready_yn IN VARCHAR2,
1917 p_meter_readings_err_pk_key IN NUMBER,
1918 p_meter_code IN VARCHAR2,
1919 p_from_time IN VARCHAR2,
1920 p_to_time IN VARCHAR2,
1921 p_usage_value IN NUMBER,
1922 p_tag_code IN VARCHAR2,
1923 p_err_source IN NUMBER,
1924 p_creation_date IN VARCHAR2,
1925 p_last_update_date IN VARCHAR2,
1926 p_rowid IN ROWID
1927 ) IS
1928 BEGIN
1929
1930 IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
1931
1932 FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
1933 RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
1934
1935 ELSIF p_rowid IS NOT NULL THEN
1936
1937 UPDATE MTH_METER_READINGS_ERR SET
1938 REPROCESS_READY_YN = p_reprocess_ready_yn
1939 ,METER_READINGS_ERR_PK_KEY = p_meter_readings_err_pk_key
1940 ,METER_CODE = p_meter_code
1941 ,FROM_TIME = fnd_date.canonical_to_date(p_from_time)
1942 ,TO_TIME = fnd_date.canonical_to_date(p_to_time)
1943 ,USAGE_VALUE = p_usage_value
1944 ,TAG_CODE = p_tag_code
1945 ,ERR_SOURCE = p_err_source
1946 ,CREATION_DATE = fnd_date.canonical_to_date(p_creation_date)
1947 ,LAST_UPDATE_DATE = fnd_date.canonical_to_date(p_last_update_date)
1948 WHERE ROWID = p_rowid;
1949
1950 ELSE
1951
1952 INSERT INTO MTH_METER_READINGS_ERR (
1953 REPROCESS_READY_YN
1954 ,METER_READINGS_ERR_PK_KEY
1955 ,METER_CODE
1956 ,FROM_TIME
1957 ,TO_TIME
1958 ,USAGE_VALUE
1959 ,TAG_CODE
1960 ,ERR_SOURCE
1961 ,CREATION_DATE
1962 ,LAST_UPDATE_DATE
1963 ) VALUES (
1964 p_reprocess_ready_yn
1965 ,p_meter_readings_err_pk_key
1966 ,p_meter_code
1970 ,p_tag_code
1967 ,fnd_date.canonical_to_date(p_from_time)
1968 ,fnd_date.canonical_to_date(p_to_time)
1969 ,p_usage_value
1971 ,p_err_source
1972 ,fnd_date.canonical_to_date(p_creation_date)
1973 ,fnd_date.canonical_to_date(p_last_update_date)
1974 );
1975
1976 END IF;
1977
1978 END UPD_METER_READINGS_ERR;
1979
1980 PROCEDURE UPD_MTL_CONSUMED_TXN_LOT_ERR (
1981 p_err_code IN VARCHAR2,
1982 p_reprocess_ready_yn IN VARCHAR2,
1983 p_wo_mat_txn_fk IN VARCHAR2,
1984 p_product_lot IN VARCHAR2,
1985 p_product_sublot IN VARCHAR2,
1986 p_product_serial_no IN VARCHAR2,
1987 p_transaction_qty IN NUMBER,
1988 p_transaction_qty_g IN NUMBER,
1989 p_transaction_qty_sg IN NUMBER,
1990 p_transaction_uom IN VARCHAR2,
1991 p_primary_uom IN VARCHAR2,
1992 p_secondary_uom IN VARCHAR2,
1993 p_material_lot IN VARCHAR2,
1994 p_material_sublot IN VARCHAR2,
1995 p_material_serial_no IN VARCHAR2,
1996 p_system_fk IN VARCHAR2,
1997 p_user_dim1_fk IN VARCHAR2,
1998 p_user_dim2_fk IN VARCHAR2,
1999 p_user_dim3_fk IN VARCHAR2,
2000 p_user_dim4_fk IN VARCHAR2,
2001 p_user_dim5_fk IN VARCHAR2,
2002 p_user_attr1 IN VARCHAR2,
2003 p_user_attr2 IN VARCHAR2,
2004 p_user_attr3 IN VARCHAR2,
2005 p_user_attr4 IN VARCHAR2,
2006 p_user_attr5 IN VARCHAR2,
2007 p_user_measure1 IN NUMBER,
2008 p_user_measure2 IN NUMBER,
2009 p_user_measure3 IN NUMBER,
2010 p_user_measure4 IN NUMBER,
2011 p_user_measure5 IN NUMBER,
2012 p_grade IN VARCHAR2,
2013 p_rowid IN ROWID
2014 ) IS
2015 BEGIN
2016
2017 IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
2018
2019 FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
2020 RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
2021
2022 ELSIF p_rowid IS NOT NULL THEN
2023
2024 UPDATE MTH_MTL_CONSUMED_TXN_LOT_ERR SET
2025 REPROCESS_READY_YN = p_reprocess_ready_yn
2026 ,WO_MAT_TXN_FK = p_wo_mat_txn_fk
2027 ,PRODUCT_LOT = p_product_lot
2028 ,PRODUCT_SUBLOT = p_product_sublot
2029 ,PRODUCT_SERIAL_NO = p_product_serial_no
2030 ,TRANSACTION_QTY = p_transaction_qty
2031 ,TRANSACTION_QTY_G = p_transaction_qty_g
2032 ,TRANSACTION_QTY_SG = p_transaction_qty_sg
2033 ,TRANSACTION_UOM = p_transaction_uom
2034 ,PRIMARY_UOM = p_primary_uom
2035 ,SECONDARY_UOM = p_secondary_uom
2036 ,MATERIAL_LOT = p_material_lot
2037 ,MATERIAL_SUBLOT = p_material_sublot
2038 ,MATERIAL_SERIAL_NO = p_material_serial_no
2039 ,SYSTEM_FK = p_system_fk
2040 ,USER_DIM1_FK = p_user_dim1_fk
2041 ,USER_DIM2_FK = p_user_dim2_fk
2042 ,USER_DIM3_FK = p_user_dim3_fk
2043 ,USER_DIM4_FK = p_user_dim4_fk
2044 ,USER_DIM5_FK = p_user_dim5_fk
2045 ,USER_ATTR1 = p_user_attr1
2046 ,USER_ATTR2 = p_user_attr2
2047 ,USER_ATTR3 = p_user_attr3
2048 ,USER_ATTR4 = p_user_attr4
2049 ,USER_ATTR5 = p_user_attr5
2050 ,USER_MEASURE1 = p_user_measure1
2051 ,USER_MEASURE2 = p_user_measure2
2052 ,USER_MEASURE3 = p_user_measure3
2053 ,USER_MEASURE4 = p_user_measure4
2054 ,USER_MEASURE5 = p_user_measure5
2055 ,GRADE = p_grade
2056 WHERE ROWID = p_rowid;
2057
2058 ELSE
2059
2060 INSERT INTO MTH_MTL_CONSUMED_TXN_LOT_ERR (
2061 REPROCESS_READY_YN
2062 ,WO_MAT_TXN_FK
2063 ,PRODUCT_LOT
2064 ,PRODUCT_SUBLOT
2065 ,PRODUCT_SERIAL_NO
2066 ,TRANSACTION_QTY
2067 ,TRANSACTION_QTY_G
2068 ,TRANSACTION_QTY_SG
2069 ,TRANSACTION_UOM
2070 ,PRIMARY_UOM
2071 ,SECONDARY_UOM
2072 ,MATERIAL_LOT
2073 ,MATERIAL_SUBLOT
2074 ,MATERIAL_SERIAL_NO
2075 ,SYSTEM_FK
2079 ,USER_DIM4_FK
2076 ,USER_DIM1_FK
2077 ,USER_DIM2_FK
2078 ,USER_DIM3_FK
2080 ,USER_DIM5_FK
2081 ,USER_ATTR1
2082 ,USER_ATTR2
2083 ,USER_ATTR3
2084 ,USER_ATTR4
2085 ,USER_ATTR5
2086 ,USER_MEASURE1
2087 ,USER_MEASURE2
2088 ,USER_MEASURE3
2089 ,USER_MEASURE4
2090 ,USER_MEASURE5
2091 ,GRADE
2092 ) VALUES (
2093 p_reprocess_ready_yn
2094 ,p_wo_mat_txn_fk
2095 ,p_product_lot
2096 ,p_product_sublot
2097 ,p_product_serial_no
2098 ,p_transaction_qty
2099 ,p_transaction_qty_g
2100 ,p_transaction_qty_sg
2101 ,p_transaction_uom
2102 ,p_primary_uom
2103 ,p_secondary_uom
2104 ,p_material_lot
2105 ,p_material_sublot
2106 ,p_material_serial_no
2107 ,p_system_fk
2108 ,p_user_dim1_fk
2109 ,p_user_dim2_fk
2110 ,p_user_dim3_fk
2111 ,p_user_dim4_fk
2112 ,p_user_dim5_fk
2113 ,p_user_attr1
2114 ,p_user_attr2
2115 ,p_user_attr3
2116 ,p_user_attr4
2117 ,p_user_attr5
2118 ,p_user_measure1
2119 ,p_user_measure2
2120 ,p_user_measure3
2121 ,p_user_measure4
2122 ,p_user_measure5
2123 ,p_grade
2124 );
2125
2126 END IF;
2127
2128 END UPD_MTL_CONSUMED_TXN_LOT_ERR;
2129
2130 PROCEDURE UPD_MTL_PRODUCED_TXN_LOT_ERR (
2131 p_err_code IN VARCHAR2,
2132 p_reprocess_ready_yn IN VARCHAR2,
2133 p_wo_comp_fk IN VARCHAR2,
2134 p_transaction_qty IN NUMBER,
2135 p_transaction_qty_g IN NUMBER,
2136 p_transaction_qty_sg IN NUMBER,
2137 p_product_lot IN VARCHAR2,
2138 p_product_sublot IN VARCHAR2,
2139 p_product_serial_no IN VARCHAR2,
2140 p_transaction_uom IN VARCHAR2,
2141 p_primary_uom IN VARCHAR2,
2142 p_secondary_uom IN VARCHAR2,
2143 p_system_fk IN VARCHAR2,
2144 p_user_dim1_fk IN VARCHAR2,
2145 p_user_dim2_fk IN VARCHAR2,
2146 p_user_dim3_fk IN VARCHAR2,
2147 p_user_dim4_fk IN VARCHAR2,
2148 p_user_dim5_fk IN VARCHAR2,
2149 p_user_attr1 IN VARCHAR2,
2150 p_user_attr2 IN VARCHAR2,
2151 p_user_attr3 IN VARCHAR2,
2152 p_user_attr4 IN VARCHAR2,
2153 p_user_attr5 IN VARCHAR2,
2154 p_user_measure1 IN NUMBER,
2155 p_user_measure2 IN NUMBER,
2156 p_user_measure3 IN NUMBER,
2157 p_user_measure4 IN NUMBER,
2158 p_user_measure5 IN NUMBER,
2159 p_grade IN VARCHAR2,
2160 p_rowid IN ROWID
2161 ) IS
2162 BEGIN
2163
2164 IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
2165
2166 FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
2167 RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
2168
2169 ELSIF p_rowid IS NOT NULL THEN
2170
2171 UPDATE MTH_MTL_PRODUCED_TXN_LOT_ERR SET
2172 REPROCESS_READY_YN = p_reprocess_ready_yn
2173 ,WO_COMP_FK = p_wo_comp_fk
2174 ,TRANSACTION_QTY = p_transaction_qty
2175 ,TRANSACTION_QTY_G = p_transaction_qty_g
2176 ,TRANSACTION_QTY_SG = p_transaction_qty_sg
2177 ,PRODUCT_LOT = p_product_lot
2178 ,PRODUCT_SUBLOT = p_product_sublot
2179 ,PRODUCT_SERIAL_NO = p_product_serial_no
2180 ,TRANSACTION_UOM = p_transaction_uom
2181 ,PRIMARY_UOM = p_primary_uom
2182 ,SECONDARY_UOM = p_secondary_uom
2183 ,SYSTEM_FK = p_system_fk
2184 ,USER_DIM1_FK = p_user_dim1_fk
2185 ,USER_DIM2_FK = p_user_dim2_fk
2186 ,USER_DIM3_FK = p_user_dim3_fk
2187 ,USER_DIM4_FK = p_user_dim4_fk
2188 ,USER_DIM5_FK = p_user_dim5_fk
2189 ,USER_ATTR1 = p_user_attr1
2190 ,USER_ATTR2 = p_user_attr2
2191 ,USER_ATTR3 = p_user_attr3
2192 ,USER_ATTR4 = p_user_attr4
2196 ,USER_MEASURE3 = p_user_measure3
2193 ,USER_ATTR5 = p_user_attr5
2194 ,USER_MEASURE1 = p_user_measure1
2195 ,USER_MEASURE2 = p_user_measure2
2197 ,USER_MEASURE4 = p_user_measure4
2198 ,USER_MEASURE5 = p_user_measure5
2199 ,GRADE = p_grade
2200 WHERE ROWID = p_rowid;
2201
2202 ELSE
2203
2204 INSERT INTO MTH_MTL_PRODUCED_TXN_LOT_ERR (
2205 REPROCESS_READY_YN
2206 ,WO_COMP_FK
2207 ,TRANSACTION_QTY
2208 ,TRANSACTION_QTY_G
2209 ,TRANSACTION_QTY_SG
2210 ,PRODUCT_LOT
2211 ,PRODUCT_SUBLOT
2215 ,SECONDARY_UOM
2212 ,PRODUCT_SERIAL_NO
2213 ,TRANSACTION_UOM
2214 ,PRIMARY_UOM
2216 ,SYSTEM_FK
2217 ,USER_DIM1_FK
2218 ,USER_DIM2_FK
2219 ,USER_DIM3_FK
2220 ,USER_DIM4_FK
2221 ,USER_DIM5_FK
2222 ,USER_ATTR1
2223 ,USER_ATTR2
2224 ,USER_ATTR3
2225 ,USER_ATTR4
2226 ,USER_ATTR5
2227 ,USER_MEASURE1
2228 ,USER_MEASURE2
2229 ,USER_MEASURE3
2230 ,USER_MEASURE4
2231 ,USER_MEASURE5
2232 ,GRADE
2233 ) VALUES (
2234 p_reprocess_ready_yn
2235 ,p_wo_comp_fk
2236 ,p_transaction_qty
2237 ,p_transaction_qty_g
2238 ,p_transaction_qty_sg
2239 ,p_product_lot
2240 ,p_product_sublot
2241 ,p_product_serial_no
2242 ,p_transaction_uom
2243 ,p_primary_uom
2244 ,p_secondary_uom
2245 ,p_system_fk
2246 ,p_user_dim1_fk
2247 ,p_user_dim2_fk
2248 ,p_user_dim3_fk
2249 ,p_user_dim4_fk
2250 ,p_user_dim5_fk
2251 ,p_user_attr1
2252 ,p_user_attr2
2253 ,p_user_attr3
2254 ,p_user_attr4
2255 ,p_user_attr5
2256 ,p_user_measure1
2257 ,p_user_measure2
2258 ,p_user_measure3
2259 ,p_user_measure4
2260 ,p_user_measure5
2261 ,p_grade
2262 );
2263
2264 END IF;
2265
2266 END UPD_MTL_PRODUCED_TXN_LOT_ERR;
2267
2268 PROCEDURE UPD_PERIOD_ERR (
2269 p_err_code IN VARCHAR2,
2270 p_reprocess_ready_yn IN VARCHAR2,
2271 p_hierarchy_name IN VARCHAR2,
2272 p_name IN VARCHAR2,
2273 p_user_attr1 IN VARCHAR2,
2274 p_user_attr2 IN VARCHAR2,
2275 p_user_attr3 IN VARCHAR2,
2276 p_user_attr4 IN VARCHAR2,
2277 p_user_attr5 IN VARCHAR2,
2281 p_user_measure4 IN NUMBER,
2278 p_user_measure1 IN NUMBER,
2279 p_user_measure2 IN NUMBER,
2280 p_user_measure3 IN NUMBER,
2282 p_user_measure5 IN NUMBER,
2283 p_system_fk IN VARCHAR2,
2284 p_end_date IN VARCHAR2,
2285 p_start_date IN VARCHAR2,
2286 p_rowid IN ROWID
2287 ) IS
2288 BEGIN
2289
2290 IF NVL(p_reprocess_ready_yn,'X') NOT IN ('D') THEN
2291
2292 FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
2293 RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
2294
2295 ELSIF p_rowid IS NOT NULL THEN
2296
2297 UPDATE MTH_PERIOD_ERR SET
2298 REPROCESS_READY_YN = p_reprocess_ready_yn
2299 ,HIERARCHY_NAME = p_hierarchy_name
2300 ,NAME = p_name
2301 ,USER_ATTR1 = p_user_attr1
2302 ,USER_ATTR2 = p_user_attr2
2303 ,USER_ATTR3 = p_user_attr3
2304 ,USER_ATTR4 = p_user_attr4
2305 ,USER_ATTR5 = p_user_attr5
2306 ,USER_MEASURE1 = p_user_measure1
2307 ,USER_MEASURE2 = p_user_measure2
2308 ,USER_MEASURE3 = p_user_measure3
2309 ,USER_MEASURE4 = p_user_measure4
2310 ,USER_MEASURE5 = p_user_measure5
2311 ,SYSTEM_FK = p_system_fk
2312 ,END_DATE = fnd_date.canonical_to_date(p_end_date)
2313 ,START_DATE = fnd_date.canonical_to_date(p_start_date)
2314 WHERE ROWID = p_rowid;
2315
2316 ELSE
2317
2318 RAISE_APPLICATION_ERROR(-20002, 'Reprocess not allowed.');
2319
2320 END IF;
2321
2322 END UPD_PERIOD_ERR;
2323
2324 PROCEDURE UPD_PERSONNEL_ERR (
2325 p_err_code IN VARCHAR2,
2326 p_reprocess_ready_yn IN VARCHAR2,
2327 p_personnel_pk IN VARCHAR2,
2328 p_ebs_personnel_id IN NUMBER,
2329 p_ebs_organization_id IN NUMBER,
2330 p_first_name IN VARCHAR2,
2331 p_last_name IN VARCHAR2,
2332 p_system_fk IN VARCHAR2,
2333 p_resource_fk IN VARCHAR2,
2334 p_personnel_description IN VARCHAR2,
2335 p_user_attr1 IN VARCHAR2,
2336 p_user_attr2 IN VARCHAR2,
2337 p_user_attr3 IN VARCHAR2,
2338 p_user_attr4 IN VARCHAR2,
2339 p_user_attr5 IN VARCHAR2,
2340 p_user_measure1 IN NUMBER,
2341 p_user_measure2 IN NUMBER,
2342 p_user_measure3 IN NUMBER,
2343 p_user_measure4 IN NUMBER,
2344 p_user_measure5 IN NUMBER,
2345 p_source_org_code IN VARCHAR2,
2346 p_middle_name IN VARCHAR2,
2347 p_known_as IN VARCHAR2,
2348 p_full_name IN VARCHAR2,
2349 p_title IN VARCHAR2,
2350 p_sex IN VARCHAR2,
2351 p_email_address IN VARCHAR2,
2352 p_work_telephone IN VARCHAR2,
2353 p_mobile_phone_number IN VARCHAR2,
2354 p_effective_start_date IN VARCHAR2,
2355 p_effective_end_date IN VARCHAR2,
2356 p_rowid IN ROWID
2357 ) IS
2358 BEGIN
2359
2360 IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
2361
2362 FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
2363 RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
2364
2365 ELSIF p_rowid IS NOT NULL THEN
2366
2367 UPDATE MTH_PERSONNEL_ERR SET
2368 REPROCESS_READY_YN = p_reprocess_ready_yn
2369 ,PERSONNEL_PK = p_personnel_pk
2370 ,EBS_PERSONNEL_ID = p_ebs_personnel_id
2371 ,EBS_ORGANIZATION_ID = p_ebs_organization_id
2372 ,FIRST_NAME = p_first_name
2373 ,LAST_NAME = p_last_name
2374 ,SYSTEM_FK = p_system_fk
2375 ,RESOURCE_FK = p_resource_fk
2376 ,PERSONNEL_DESCRIPTION = p_personnel_description
2377 ,USER_ATTR1 = p_user_attr1
2378 ,USER_ATTR2 = p_user_attr2
2379 ,USER_ATTR3 = p_user_attr3
2380 ,USER_ATTR4 = p_user_attr4
2381 ,USER_ATTR5 = p_user_attr5
2382 ,USER_MEASURE1 = p_user_measure1
2383 ,USER_MEASURE2 = p_user_measure2
2384 ,USER_MEASURE3 = p_user_measure3
2385 ,USER_MEASURE4 = p_user_measure4
2389 ,KNOWN_AS = p_known_as
2386 ,USER_MEASURE5 = p_user_measure5
2387 ,SOURCE_ORG_CODE = p_source_org_code
2388 ,MIDDLE_NAME = p_middle_name
2390 ,FULL_NAME = p_full_name
2391 ,TITLE = p_title
2392 ,SEX = p_sex
2393 ,EMAIL_ADDRESS = p_email_address
2394 ,WORK_TELEPHONE = p_work_telephone
2395 ,MOBILE_PHONE_NUMBER = p_mobile_phone_number
2396 ,EFFECTIVE_START_DATE = fnd_date.canonical_to_date(p_effective_start_date)
2397 ,EFFECTIVE_END_DATE = fnd_date.canonical_to_date(p_effective_end_date)
2398 WHERE ROWID = p_rowid;
2399
2400 ELSE
2401
2402 INSERT INTO MTH_PERSONNEL_ERR (
2403 REPROCESS_READY_YN
2404 ,PERSONNEL_PK
2405 ,EBS_PERSONNEL_ID
2406 ,EBS_ORGANIZATION_ID
2407 ,FIRST_NAME
2408 ,LAST_NAME
2409 ,SYSTEM_FK
2410 ,RESOURCE_FK
2411 ,PERSONNEL_DESCRIPTION
2412 ,USER_ATTR1
2413 ,USER_ATTR2
2414 ,USER_ATTR3
2415 ,USER_ATTR4
2416 ,USER_ATTR5
2417 ,USER_MEASURE1
2418 ,USER_MEASURE2
2419 ,USER_MEASURE3
2420 ,USER_MEASURE4
2421 ,USER_MEASURE5
2422 ,SOURCE_ORG_CODE
2423 ,MIDDLE_NAME
2424 ,KNOWN_AS
2425 ,FULL_NAME
2426 ,TITLE
2427 ,SEX
2428 ,EMAIL_ADDRESS
2429 ,WORK_TELEPHONE
2430 ,MOBILE_PHONE_NUMBER
2431 ,EFFECTIVE_START_DATE
2432 ,EFFECTIVE_END_DATE
2433 ) VALUES (
2434 p_reprocess_ready_yn
2435 ,p_personnel_pk
2436 ,p_ebs_personnel_id
2437 ,p_ebs_organization_id
2438 ,p_first_name
2439 ,p_last_name
2440 ,p_system_fk
2441 ,p_resource_fk
2442 ,p_personnel_description
2443 ,p_user_attr1
2444 ,p_user_attr2
2445 ,p_user_attr3
2446 ,p_user_attr4
2447 ,p_user_attr5
2448 ,p_user_measure1
2449 ,p_user_measure2
2450 ,p_user_measure3
2451 ,p_user_measure4
2452 ,p_user_measure5
2453 ,p_source_org_code
2454 ,p_middle_name
2455 ,p_known_as
2456 ,p_full_name
2457 ,p_title
2458 ,p_sex
2459 ,p_email_address
2460 ,p_work_telephone
2461 ,p_mobile_phone_number
2462 ,fnd_date.canonical_to_date(p_effective_start_date)
2463 ,fnd_date.canonical_to_date(p_effective_end_date)
2464 );
2465
2466 END IF;
2467
2468 END UPD_PERSONNEL_ERR;
2469
2470 PROCEDURE UPD_PRODUCTION_SCHEDULES_ERR (
2471 p_err_code IN VARCHAR2,
2472 p_reprocess_ready_yn IN VARCHAR2,
2473 p_workorder_pk IN VARCHAR2,
2474 p_system_fk IN VARCHAR2,
2475 p_workorder_type IN NUMBER,
2476 p_status IN VARCHAR2,
2477 p_planned_start_date IN VARCHAR2,
2478 p_planned_completion_date IN VARCHAR2,
2479 p_actual_start_date IN VARCHAR2,
2480 p_actual_completion_date IN VARCHAR2,
2481 p_date_released IN VARCHAR2,
2482 p_erp_actual_start_date IN VARCHAR2,
2483 p_erp_actual_completion_date IN VARCHAR2,
2484 p_ebs_entity_id IN NUMBER,
2485 p_ebs_organization_id IN NUMBER,
2486 p_bom_revision IN VARCHAR2,
2487 p_routing_revision IN VARCHAR2,
2488 p_bom_revision_date IN VARCHAR2,
2489 p_routing_revision_date IN VARCHAR2,
2490 p_alternate_bom_designator IN VARCHAR2,
2491 p_alternate_routing_designator IN VARCHAR2,
2492 p_completion_subinventory IN VARCHAR2,
2493 p_completion_locator_id IN NUMBER,
2494 p_demand_class IN VARCHAR2,
2495 p_schedule_group_id IN NUMBER,
2496 p_build_sequence IN NUMBER,
2497 p_workorder_name IN VARCHAR2,
2498 p_demand_source_header_id IN NUMBER,
2499 p_demand_source_line IN VARCHAR2,
2500 p_demand_source_delivery IN VARCHAR2,
2501 p_demand_source_type IN NUMBER,
2502 p_kanban_card_id IN NUMBER,
2503 p_line_code IN VARCHAR2,
2504 p_parent_workorder_id IN VARCHAR2,
2508 p_user_dim2_fk IN VARCHAR2,
2505 p_parent_operation_seq_num IN NUMBER,
2506 p_source_org_code IN VARCHAR2,
2507 p_user_dim1_fk IN VARCHAR2,
2509 p_user_dim3_fk IN VARCHAR2,
2510 p_user_dim4_fk IN VARCHAR2,
2511 p_user_dim5_fk IN VARCHAR2,
2512 p_user_attr1 IN VARCHAR2,
2513 p_user_attr2 IN VARCHAR2,
2514 p_user_attr3 IN VARCHAR2,
2515 p_user_attr4 IN VARCHAR2,
2516 p_user_attr5 IN VARCHAR2,
2517 p_user_attr6 IN VARCHAR2,
2518 p_user_attr7 IN VARCHAR2,
2519 p_user_attr8 IN VARCHAR2,
2520 p_user_attr9 IN VARCHAR2,
2521 p_user_attr10 IN VARCHAR2,
2522 p_user_attr11 IN VARCHAR2,
2523 p_user_attr12 IN VARCHAR2,
2524 p_user_attr13 IN VARCHAR2,
2525 p_user_attr14 IN VARCHAR2,
2526 p_user_attr15 IN VARCHAR2,
2527 p_user_attr16 IN VARCHAR2,
2528 p_user_attr17 IN VARCHAR2,
2529 p_user_attr18 IN VARCHAR2,
2530 p_user_attr19 IN VARCHAR2,
2531 p_user_attr20 IN VARCHAR2,
2532 p_user_measure1 IN NUMBER,
2533 p_user_measure2 IN NUMBER,
2534 p_user_measure3 IN NUMBER,
2535 p_user_measure4 IN NUMBER,
2536 p_user_measure5 IN NUMBER,
2537 p_recipe_num IN VARCHAR2,
2538 p_recipe_version IN VARCHAR2,
2539 p_formula_num IN VARCHAR2,
2540 p_formula_version IN VARCHAR2,
2541 p_req_completion_date IN VARCHAR2,
2542 p_batch_type IN VARCHAR2,
2543 p_terminated_ind IN NUMBER,
2544 p_rowid IN ROWID
2545 ) IS
2546 BEGIN
2547
2548 IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
2549
2550 FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
2551 RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
2552
2553 ELSIF p_rowid IS NOT NULL THEN
2554
2555 UPDATE MTH_PRODUCTION_SCHEDULES_ERR SET
2556 REPROCESS_READY_YN = p_reprocess_ready_yn
2557 ,WORKORDER_PK = p_workorder_pk
2558 ,SYSTEM_FK = p_system_fk
2559 ,WORKORDER_TYPE = p_workorder_type
2560 ,STATUS = p_status
2561 ,PLANNED_START_DATE = fnd_date.canonical_to_date(p_planned_start_date)
2562 ,PLANNED_COMPLETION_DATE = fnd_date.canonical_to_date(p_planned_completion_date)
2563 ,ACTUAL_START_DATE = fnd_date.canonical_to_date(p_actual_start_date)
2564 ,ACTUAL_COMPLETION_DATE = fnd_date.canonical_to_date(p_actual_completion_date)
2565 ,DATE_RELEASED = fnd_date.canonical_to_date(p_date_released)
2566 ,ERP_ACTUAL_START_DATE = fnd_date.canonical_to_date(p_erp_actual_start_date)
2567 ,ERP_ACTUAL_COMPLETION_DATE = fnd_date.canonical_to_date(p_erp_actual_completion_date)
2568 ,EBS_ENTITY_ID = p_ebs_entity_id
2569 ,EBS_ORGANIZATION_ID = p_ebs_organization_id
2570 ,BOM_REVISION = p_bom_revision
2571 ,ROUTING_REVISION = p_routing_revision
2572 ,BOM_REVISION_DATE = fnd_date.canonical_to_date(p_bom_revision_date)
2573 ,ROUTING_REVISION_DATE = fnd_date.canonical_to_date(p_routing_revision_date)
2574 ,ALTERNATE_BOM_DESIGNATOR = p_alternate_bom_designator
2575 ,ALTERNATE_ROUTING_DESIGNATOR = p_alternate_routing_designator
2576 ,COMPLETION_SUBINVENTORY = p_completion_subinventory
2577 ,COMPLETION_LOCATOR_ID = p_completion_locator_id
2578 ,DEMAND_CLASS = p_demand_class
2579 ,SCHEDULE_GROUP_ID = p_schedule_group_id
2580 ,BUILD_SEQUENCE = p_build_sequence
2581 ,WORKORDER_NAME = p_workorder_name
2582 ,DEMAND_SOURCE_HEADER_ID = p_demand_source_header_id
2583 ,DEMAND_SOURCE_LINE = p_demand_source_line
2584 ,DEMAND_SOURCE_DELIVERY = p_demand_source_delivery
2585 ,DEMAND_SOURCE_TYPE = p_demand_source_type
2586 ,KANBAN_CARD_ID = p_kanban_card_id
2587 ,LINE_CODE = p_line_code
2588 ,PARENT_WORKORDER_ID = p_parent_workorder_id
2589 ,PARENT_OPERATION_SEQ_NUM = p_parent_operation_seq_num
2590 ,SOURCE_ORG_CODE = p_source_org_code
2591 ,USER_DIM1_FK = p_user_dim1_fk
2592 ,USER_DIM2_FK = p_user_dim2_fk
2593 ,USER_DIM3_FK = p_user_dim3_fk
2594 ,USER_DIM4_FK = p_user_dim4_fk
2598 ,USER_ATTR3 = p_user_attr3
2595 ,USER_DIM5_FK = p_user_dim5_fk
2596 ,USER_ATTR1 = p_user_attr1
2597 ,USER_ATTR2 = p_user_attr2
2599 ,USER_ATTR4 = p_user_attr4
2600 ,USER_ATTR5 = p_user_attr5
2601 ,USER_ATTR6 = p_user_attr6
2602 ,USER_ATTR7 = p_user_attr7
2603 ,USER_ATTR8 = p_user_attr8
2604 ,USER_ATTR9 = p_user_attr9
2605 ,USER_ATTR10 = p_user_attr10
2606 ,USER_ATTR11 = p_user_attr11
2607 ,USER_ATTR12 = p_user_attr12
2608 ,USER_ATTR13 = p_user_attr13
2609 ,USER_ATTR14 = p_user_attr14
2610 ,USER_ATTR15 = p_user_attr15
2611 ,USER_ATTR16 = p_user_attr16
2612 ,USER_ATTR17 = p_user_attr17
2613 ,USER_ATTR18 = p_user_attr18
2614 ,USER_ATTR19 = p_user_attr19
2615 ,USER_ATTR20 = p_user_attr20
2616 ,USER_MEASURE1 = p_user_measure1
2617 ,USER_MEASURE2 = p_user_measure2
2618 ,USER_MEASURE3 = p_user_measure3
2619 ,USER_MEASURE4 = p_user_measure4
2620 ,USER_MEASURE5 = p_user_measure5
2621 ,RECIPE_NUM = p_recipe_num
2622 ,RECIPE_VERSION = p_recipe_version
2623 ,FORMULA_NUM = p_formula_num
2624 ,FORMULA_VERSION = p_formula_version
2625 ,REQ_COMPLETION_DATE = fnd_date.canonical_to_date(p_req_completion_date)
2626 ,BATCH_TYPE = p_batch_type
2627 ,TERMINATED_IND = p_terminated_ind
2628 WHERE ROWID = p_rowid;
2629
2630 ELSE
2631
2632 INSERT INTO MTH_PRODUCTION_SCHEDULES_ERR (
2633 REPROCESS_READY_YN
2634 ,WORKORDER_PK
2635 ,SYSTEM_FK
2636 ,WORKORDER_TYPE
2637 ,STATUS
2638 ,PLANNED_START_DATE
2639 ,PLANNED_COMPLETION_DATE
2640 ,ACTUAL_START_DATE
2641 ,ACTUAL_COMPLETION_DATE
2642 ,DATE_RELEASED
2643 ,ERP_ACTUAL_START_DATE
2644 ,ERP_ACTUAL_COMPLETION_DATE
2645 ,EBS_ENTITY_ID
2646 ,EBS_ORGANIZATION_ID
2647 ,BOM_REVISION
2648 ,ROUTING_REVISION
2649 ,BOM_REVISION_DATE
2650 ,ROUTING_REVISION_DATE
2651 ,ALTERNATE_BOM_DESIGNATOR
2652 ,ALTERNATE_ROUTING_DESIGNATOR
2653 ,COMPLETION_SUBINVENTORY
2654 ,COMPLETION_LOCATOR_ID
2655 ,DEMAND_CLASS
2656 ,SCHEDULE_GROUP_ID
2657 ,BUILD_SEQUENCE
2658 ,WORKORDER_NAME
2659 ,DEMAND_SOURCE_HEADER_ID
2660 ,DEMAND_SOURCE_LINE
2661 ,DEMAND_SOURCE_DELIVERY
2662 ,DEMAND_SOURCE_TYPE
2666 ,PARENT_OPERATION_SEQ_NUM
2663 ,KANBAN_CARD_ID
2664 ,LINE_CODE
2665 ,PARENT_WORKORDER_ID
2667 ,SOURCE_ORG_CODE
2668 ,USER_DIM1_FK
2669 ,USER_DIM2_FK
2670 ,USER_DIM3_FK
2671 ,USER_DIM4_FK
2672 ,USER_DIM5_FK
2673 ,USER_ATTR1
2674 ,USER_ATTR2
2675 ,USER_ATTR3
2676 ,USER_ATTR4
2677 ,USER_ATTR5
2678 ,USER_ATTR6
2679 ,USER_ATTR7
2680 ,USER_ATTR8
2681 ,USER_ATTR9
2682 ,USER_ATTR10
2683 ,USER_ATTR11
2684 ,USER_ATTR12
2685 ,USER_ATTR13
2686 ,USER_ATTR14
2687 ,USER_ATTR15
2688 ,USER_ATTR16
2689 ,USER_ATTR17
2690 ,USER_ATTR18
2691 ,USER_ATTR19
2692 ,USER_ATTR20
2693 ,USER_MEASURE1
2694 ,USER_MEASURE2
2695 ,USER_MEASURE3
2696 ,USER_MEASURE4
2697 ,USER_MEASURE5
2698 ,RECIPE_NUM
2699 ,RECIPE_VERSION
2700 ,FORMULA_NUM
2701 ,FORMULA_VERSION
2702 ,REQ_COMPLETION_DATE
2703 ,BATCH_TYPE
2704 ,TERMINATED_IND
2705 ) VALUES (
2706 p_reprocess_ready_yn
2707 ,p_workorder_pk
2708 ,p_system_fk
2709 ,p_workorder_type
2710 ,p_status
2711 ,fnd_date.canonical_to_date(p_planned_start_date)
2712 ,fnd_date.canonical_to_date(p_planned_completion_date)
2713 ,fnd_date.canonical_to_date(p_actual_start_date)
2714 ,fnd_date.canonical_to_date(p_actual_completion_date)
2715 ,fnd_date.canonical_to_date(p_date_released)
2716 ,fnd_date.canonical_to_date(p_erp_actual_start_date)
2717 ,fnd_date.canonical_to_date(p_erp_actual_completion_date)
2718 ,p_ebs_entity_id
2719 ,p_ebs_organization_id
2720 ,p_bom_revision
2721 ,p_routing_revision
2722 ,fnd_date.canonical_to_date(p_bom_revision_date)
2723 ,fnd_date.canonical_to_date(p_routing_revision_date)
2724 ,p_alternate_bom_designator
2725 ,p_alternate_routing_designator
2726 ,p_completion_subinventory
2727 ,p_completion_locator_id
2728 ,p_demand_class
2729 ,p_schedule_group_id
2730 ,p_build_sequence
2731 ,p_workorder_name
2732 ,p_demand_source_header_id
2733 ,p_demand_source_line
2734 ,p_demand_source_delivery
2735 ,p_demand_source_type
2736 ,p_kanban_card_id
2737 ,p_line_code
2738 ,p_parent_workorder_id
2739 ,p_parent_operation_seq_num
2740 ,p_source_org_code
2741 ,p_user_dim1_fk
2742 ,p_user_dim2_fk
2743 ,p_user_dim3_fk
2744 ,p_user_dim4_fk
2745 ,p_user_dim5_fk
2746 ,p_user_attr1
2747 ,p_user_attr2
2748 ,p_user_attr3
2749 ,p_user_attr4
2750 ,p_user_attr5
2751 ,p_user_attr6
2752 ,p_user_attr7
2753 ,p_user_attr8
2754 ,p_user_attr9
2755 ,p_user_attr10
2756 ,p_user_attr11
2757 ,p_user_attr12
2758 ,p_user_attr13
2759 ,p_user_attr14
2760 ,p_user_attr15
2761 ,p_user_attr16
2762 ,p_user_attr17
2763 ,p_user_attr18
2764 ,p_user_attr19
2765 ,p_user_attr20
2766 ,p_user_measure1
2767 ,p_user_measure2
2768 ,p_user_measure3
2769 ,p_user_measure4
2770 ,p_user_measure5
2771 ,p_recipe_num
2772 ,p_recipe_version
2776 ,p_batch_type
2773 ,p_formula_num
2774 ,p_formula_version
2775 ,fnd_date.canonical_to_date(p_req_completion_date)
2777 ,p_terminated_ind
2778 );
2779
2780 END IF;
2781
2782 END UPD_PRODUCTION_SCHEDULES_ERR;
2783
2784 PROCEDURE UPD_PRODUCTION_SEGMENTS_ERR (
2785 p_err_code IN VARCHAR2,
2786 p_reprocess_ready_yn IN VARCHAR2,
2787 p_workorder_fk IN VARCHAR2,
2788 p_segment_pk IN VARCHAR2,
2789 p_item_fk IN VARCHAR2,
2790 p_start_quantity_g IN NUMBER,
2791 p_start_quantity_sg IN NUMBER,
2792 p_primary_uom IN VARCHAR2,
2793 p_secondary_uom IN VARCHAR2,
2794 p_actual_comp_qty_g IN NUMBER,
2795 p_actual_comp_qty_sg IN NUMBER,
2796 p_actual_rejected_qty_g IN NUMBER,
2797 p_actual_reworked_qty_g IN NUMBER,
2798 p_actual_scrap_qty_g IN NUMBER,
2799 p_actual_rejected_qty_sg IN NUMBER,
2800 p_actual_reworked_qty_sg IN NUMBER,
2801 p_actual_scrap_qty_sg IN NUMBER,
2802 p_actual_start_date IN VARCHAR2,
2803 p_actual_completion_date IN VARCHAR2,
2804 p_system_fk IN VARCHAR2,
2805 p_user_dim1_fk IN VARCHAR2,
2806 p_user_dim2_fk IN VARCHAR2,
2807 p_user_dim3_fk IN VARCHAR2,
2808 p_user_dim4_fk IN VARCHAR2,
2809 p_user_dim5_fk IN VARCHAR2,
2810 p_user_attr1 IN VARCHAR2,
2811 p_user_attr2 IN VARCHAR2,
2812 p_user_attr3 IN VARCHAR2,
2813 p_user_attr4 IN VARCHAR2,
2814 p_user_attr5 IN VARCHAR2,
2815 p_user_measure1 IN NUMBER,
2816 p_user_measure2 IN NUMBER,
2817 p_user_measure3 IN NUMBER,
2818 p_user_measure4 IN NUMBER,
2819 p_user_measure5 IN NUMBER,
2820 p_segment_status IN VARCHAR2,
2821 p_planned_start_date IN VARCHAR2,
2822 p_planned_completion_date IN VARCHAR2,
2823 p_req_completion_date IN VARCHAR2,
2824 p_rowid IN ROWID
2825 ) IS
2826 BEGIN
2827
2828 IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
2829
2830 FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
2831 RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
2832
2833 ELSIF p_rowid IS NOT NULL THEN
2834
2835 UPDATE MTH_PRODUCTION_SEGMENTS_ERR SET
2836 REPROCESS_READY_YN = p_reprocess_ready_yn
2837 ,WORKORDER_FK = p_workorder_fk
2838 ,SEGMENT_PK = p_segment_pk
2839 ,ITEM_FK = p_item_fk
2840 ,START_QUANTITY_G = p_start_quantity_g
2841 ,START_QUANTITY_SG = p_start_quantity_sg
2842 ,PRIMARY_UOM = p_primary_uom
2843 ,SECONDARY_UOM = p_secondary_uom
2844 ,ACTUAL_COMP_QTY_G = p_actual_comp_qty_g
2845 ,ACTUAL_COMP_QTY_SG = p_actual_comp_qty_sg
2846 ,ACTUAL_REJECTED_QTY_G = p_actual_rejected_qty_g
2847 ,ACTUAL_REWORKED_QTY_G = p_actual_reworked_qty_g
2848 ,ACTUAL_SCRAP_QTY_G = p_actual_scrap_qty_g
2849 ,ACTUAL_REJECTED_QTY_SG = p_actual_rejected_qty_sg
2850 ,ACTUAL_REWORKED_QTY_SG = p_actual_reworked_qty_sg
2851 ,ACTUAL_SCRAP_QTY_SG = p_actual_scrap_qty_sg
2852 ,ACTUAL_START_DATE = fnd_date.canonical_to_date(p_actual_start_date)
2853 ,ACTUAL_COMPLETION_DATE = fnd_date.canonical_to_date(p_actual_completion_date)
2854 ,SYSTEM_FK = p_system_fk
2855 ,USER_DIM1_FK = p_user_dim1_fk
2856 ,USER_DIM2_FK = p_user_dim2_fk
2857 ,USER_DIM3_FK = p_user_dim3_fk
2858 ,USER_DIM4_FK = p_user_dim4_fk
2859 ,USER_DIM5_FK = p_user_dim5_fk
2860 ,USER_ATTR1 = p_user_attr1
2861 ,USER_ATTR2 = p_user_attr2
2862 ,USER_ATTR3 = p_user_attr3
2863 ,USER_ATTR4 = p_user_attr4
2864 ,USER_ATTR5 = p_user_attr5
2865 ,USER_MEASURE1 = p_user_measure1
2866 ,USER_MEASURE2 = p_user_measure2
2867 ,USER_MEASURE3 = p_user_measure3
2868 ,USER_MEASURE4 = p_user_measure4
2869 ,USER_MEASURE5 = p_user_measure5
2870 ,SEGMENT_STATUS = p_segment_status
2871 ,PLANNED_START_DATE = fnd_date.canonical_to_date(p_planned_start_date)
2872 ,PLANNED_COMPLETION_DATE = fnd_date.canonical_to_date(p_planned_completion_date)
2876 ELSE
2873 ,REQ_COMPLETION_DATE = fnd_date.canonical_to_date(p_req_completion_date)
2874 WHERE ROWID = p_rowid;
2875
2877
2878 INSERT INTO MTH_PRODUCTION_SEGMENTS_ERR (
2879 REPROCESS_READY_YN
2880 ,WORKORDER_FK
2881 ,SEGMENT_PK
2882 ,ITEM_FK
2883 ,START_QUANTITY_G
2884 ,START_QUANTITY_SG
2885 ,PRIMARY_UOM
2886 ,SECONDARY_UOM
2887 ,ACTUAL_COMP_QTY_G
2888 ,ACTUAL_COMP_QTY_SG
2889 ,ACTUAL_REJECTED_QTY_G
2890 ,ACTUAL_REWORKED_QTY_G
2891 ,ACTUAL_SCRAP_QTY_G
2892 ,ACTUAL_REJECTED_QTY_SG
2893 ,ACTUAL_REWORKED_QTY_SG
2894 ,ACTUAL_SCRAP_QTY_SG
2895 ,ACTUAL_START_DATE
2896 ,ACTUAL_COMPLETION_DATE
2897 ,SYSTEM_FK
2898 ,USER_DIM1_FK
2899 ,USER_DIM2_FK
2900 ,USER_DIM3_FK
2901 ,USER_DIM4_FK
2902 ,USER_DIM5_FK
2903 ,USER_ATTR1
2904 ,USER_ATTR2
2905 ,USER_ATTR3
2906 ,USER_ATTR4
2907 ,USER_ATTR5
2908 ,USER_MEASURE1
2909 ,USER_MEASURE2
2910 ,USER_MEASURE3
2911 ,USER_MEASURE4
2912 ,USER_MEASURE5
2913 ,SEGMENT_STATUS
2914 ,PLANNED_START_DATE
2915 ,PLANNED_COMPLETION_DATE
2916 ,REQ_COMPLETION_DATE
2917 ) VALUES (
2918 p_reprocess_ready_yn
2919 ,p_workorder_fk
2920 ,p_segment_pk
2921 ,p_item_fk
2922 ,p_start_quantity_g
2923 ,p_start_quantity_sg
2924 ,p_primary_uom
2925 ,p_secondary_uom
2926 ,p_actual_comp_qty_g
2927 ,p_actual_comp_qty_sg
2928 ,p_actual_rejected_qty_g
2929 ,p_actual_reworked_qty_g
2930 ,p_actual_scrap_qty_g
2931 ,p_actual_rejected_qty_sg
2932 ,p_actual_reworked_qty_sg
2933 ,p_actual_scrap_qty_sg
2934 ,fnd_date.canonical_to_date(p_actual_start_date)
2935 ,fnd_date.canonical_to_date(p_actual_completion_date)
2936 ,p_system_fk
2937 ,p_user_dim1_fk
2938 ,p_user_dim2_fk
2939 ,p_user_dim3_fk
2940 ,p_user_dim4_fk
2941 ,p_user_dim5_fk
2942 ,p_user_attr1
2943 ,p_user_attr2
2944 ,p_user_attr3
2945 ,p_user_attr4
2946 ,p_user_attr5
2947 ,p_user_measure1
2948 ,p_user_measure2
2949 ,p_user_measure3
2950 ,p_user_measure4
2951 ,p_user_measure5
2952 ,p_segment_status
2953 ,fnd_date.canonical_to_date(p_planned_start_date)
2954 ,fnd_date.canonical_to_date(p_planned_completion_date)
2955 ,fnd_date.canonical_to_date(p_req_completion_date)
2956 );
2957
2958 END IF;
2959
2960 END UPD_PRODUCTION_SEGMENTS_ERR;
2961
2962 PROCEDURE UPD_PROD_MTL_CONSUMED_ERR (
2963 p_err_code IN VARCHAR2,
2964 p_reprocess_ready_yn IN VARCHAR2,
2965 p_wo_mat_req_pk IN VARCHAR2,
2966 p_product_fk IN VARCHAR2,
2967 p_material_fk IN VARCHAR2,
2968 p_segment_fk IN VARCHAR2,
2969 p_primary_uom IN VARCHAR2,
2970 p_secondary_uom IN VARCHAR2,
2971 p_required_qty_g IN NUMBER,
2972 p_required_qty_sg IN NUMBER,
2973 p_actual_qty_g IN NUMBER,
2974 p_actual_qty_sg IN NUMBER,
2975 p_unit_standard_qty_g IN NUMBER,
2976 p_unit_standard_qty_sg IN NUMBER,
2977 p_required_by_date IN VARCHAR2,
2978 p_source_org_code IN VARCHAR2,
2979 p_system_fk IN VARCHAR2,
2980 p_user_dim1_fk IN VARCHAR2,
2981 p_user_dim2_fk IN VARCHAR2,
2982 p_user_dim3_fk IN VARCHAR2,
2983 p_user_dim4_fk IN VARCHAR2,
2984 p_user_dim5_fk IN VARCHAR2,
2985 p_user_attr1 IN VARCHAR2,
2986 p_user_attr2 IN VARCHAR2,
2987 p_user_attr3 IN VARCHAR2,
2988 p_user_attr4 IN VARCHAR2,
2989 p_user_attr5 IN VARCHAR2,
2990 p_user_measure1 IN NUMBER,
2991 p_user_measure2 IN NUMBER,
2992 p_user_measure3 IN NUMBER,
2993 p_user_measure4 IN NUMBER,
2994 p_user_measure5 IN NUMBER,
2998 p_rowid IN ROWID
2995 p_workorder_fk IN VARCHAR2,
2996 p_mat_scrap_qty_g IN NUMBER,
2997 p_mat_scrap_qty_sg IN NUMBER,
2999 ) IS
3000 BEGIN
3001
3002 IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
3003
3004 FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
3005 RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
3006
3007 ELSIF p_rowid IS NOT NULL THEN
3008
3009 UPDATE MTH_PROD_MTL_CONSUMED_ERR SET
3010 REPROCESS_READY_YN = p_reprocess_ready_yn
3011 ,WO_MAT_REQ_PK = p_wo_mat_req_pk
3012 ,PRODUCT_FK = p_product_fk
3013 ,MATERIAL_FK = p_material_fk
3014 ,SEGMENT_FK = p_segment_fk
3015 ,PRIMARY_UOM = p_primary_uom
3016 ,SECONDARY_UOM = p_secondary_uom
3017 ,REQUIRED_QTY_G = p_required_qty_g
3018 ,REQUIRED_QTY_SG = p_required_qty_sg
3019 ,ACTUAL_QTY_G = p_actual_qty_g
3020 ,ACTUAL_QTY_SG = p_actual_qty_sg
3021 ,UNIT_STANDARD_QTY_G = p_unit_standard_qty_g
3022 ,UNIT_STANDARD_QTY_SG = p_unit_standard_qty_sg
3023 ,REQUIRED_BY_DATE = fnd_date.canonical_to_date(p_required_by_date)
3024 ,SOURCE_ORG_CODE = p_source_org_code
3025 ,SYSTEM_FK = p_system_fk
3026 ,USER_DIM1_FK = p_user_dim1_fk
3027 ,USER_DIM2_FK = p_user_dim2_fk
3028 ,USER_DIM3_FK = p_user_dim3_fk
3029 ,USER_DIM4_FK = p_user_dim4_fk
3030 ,USER_DIM5_FK = p_user_dim5_fk
3031 ,USER_ATTR1 = p_user_attr1
3032 ,USER_ATTR2 = p_user_attr2
3033 ,USER_ATTR3 = p_user_attr3
3034 ,USER_ATTR4 = p_user_attr4
3035 ,USER_ATTR5 = p_user_attr5
3036 ,USER_MEASURE1 = p_user_measure1
3037 ,USER_MEASURE2 = p_user_measure2
3038 ,USER_MEASURE3 = p_user_measure3
3039 ,USER_MEASURE4 = p_user_measure4
3040 ,USER_MEASURE5 = p_user_measure5
3041 ,WORKORDER_FK = p_workorder_fk
3042 ,MAT_SCRAP_QTY_G = p_mat_scrap_qty_g
3043 ,MAT_SCRAP_QTY_SG = p_mat_scrap_qty_sg
3044 WHERE ROWID = p_rowid;
3045
3046 ELSE
3047
3048 INSERT INTO MTH_PROD_MTL_CONSUMED_ERR (
3049 REPROCESS_READY_YN
3050 ,WO_MAT_REQ_PK
3051 ,PRODUCT_FK
3052 ,MATERIAL_FK
3053 ,SEGMENT_FK
3054 ,PRIMARY_UOM
3055 ,SECONDARY_UOM
3056 ,REQUIRED_QTY_G
3057 ,REQUIRED_QTY_SG
3058 ,ACTUAL_QTY_G
3059 ,ACTUAL_QTY_SG
3060 ,UNIT_STANDARD_QTY_G
3061 ,UNIT_STANDARD_QTY_SG
3062 ,REQUIRED_BY_DATE
3063 ,SOURCE_ORG_CODE
3064 ,SYSTEM_FK
3065 ,USER_DIM1_FK
3066 ,USER_DIM2_FK
3067 ,USER_DIM3_FK
3068 ,USER_DIM4_FK
3069 ,USER_DIM5_FK
3070 ,USER_ATTR1
3071 ,USER_ATTR2
3072 ,USER_ATTR3
3073 ,USER_ATTR4
3074 ,USER_ATTR5
3075 ,USER_MEASURE1
3076 ,USER_MEASURE2
3077 ,USER_MEASURE3
3078 ,USER_MEASURE4
3079 ,USER_MEASURE5
3080 ,WORKORDER_FK
3081 ,MAT_SCRAP_QTY_G
3082 ,MAT_SCRAP_QTY_SG
3083 ) VALUES (
3084 p_reprocess_ready_yn
3085 ,p_wo_mat_req_pk
3086 ,p_product_fk
3087 ,p_material_fk
3088 ,p_segment_fk
3089 ,p_primary_uom
3090 ,p_secondary_uom
3091 ,p_required_qty_g
3092 ,p_required_qty_sg
3093 ,p_actual_qty_g
3094 ,p_actual_qty_sg
3095 ,p_unit_standard_qty_g
3096 ,p_unit_standard_qty_sg
3097 ,fnd_date.canonical_to_date(p_required_by_date)
3098 ,p_source_org_code
3099 ,p_system_fk
3100 ,p_user_dim1_fk
3101 ,p_user_dim2_fk
3102 ,p_user_dim3_fk
3103 ,p_user_dim4_fk
3104 ,p_user_dim5_fk
3105 ,p_user_attr1
3106 ,p_user_attr2
3107 ,p_user_attr3
3108 ,p_user_attr4
3112 ,p_user_measure3
3109 ,p_user_attr5
3110 ,p_user_measure1
3111 ,p_user_measure2
3113 ,p_user_measure4
3114 ,p_user_measure5
3115 ,p_workorder_fk
3116 ,p_mat_scrap_qty_g
3117 ,p_mat_scrap_qty_sg
3118 );
3122 END UPD_PROD_MTL_CONSUMED_ERR;
3119
3120 END IF;
3121
3123
3124 PROCEDURE UPD_PROD_MTL_CONSUMED_TXN_ERR (
3125 p_err_code IN VARCHAR2,
3126 p_reprocess_ready_yn IN VARCHAR2,
3127 p_wo_mat_txn_pk IN VARCHAR2,
3128 p_workorder_fk IN VARCHAR2,
3129 p_product_fk IN VARCHAR2,
3130 p_material_fk IN VARCHAR2,
3131 p_segment_fk IN VARCHAR2,
3132 p_transaction_qty IN NUMBER,
3133 p_transaction_qty_g IN NUMBER,
3134 p_transaction_qty_sg IN NUMBER,
3135 p_transaction_uom IN VARCHAR2,
3136 p_primary_uom IN VARCHAR2,
3137 p_secondary_uom IN VARCHAR2,
3138 p_transaction_date IN VARCHAR2,
3139 p_system_fk IN VARCHAR2,
3140 p_source_org_code IN VARCHAR2,
3141 p_user_dim1_fk IN VARCHAR2,
3142 p_user_dim2_fk IN VARCHAR2,
3143 p_user_dim3_fk IN VARCHAR2,
3144 p_user_dim4_fk IN VARCHAR2,
3145 p_user_dim5_fk IN VARCHAR2,
3146 p_user_attr1 IN VARCHAR2,
3147 p_user_attr2 IN VARCHAR2,
3148 p_user_attr3 IN VARCHAR2,
3149 p_user_attr4 IN VARCHAR2,
3150 p_user_attr5 IN VARCHAR2,
3151 p_user_measure1 IN NUMBER,
3152 p_user_measure2 IN NUMBER,
3153 p_user_measure3 IN NUMBER,
3154 p_user_measure4 IN NUMBER,
3155 p_user_measure5 IN NUMBER,
3156 p_rowid IN ROWID
3157 ) IS
3158 BEGIN
3159
3160 IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
3161
3162 FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
3163 RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
3164
3165 ELSIF p_rowid IS NOT NULL THEN
3166
3167 UPDATE MTH_PROD_MTL_CONSUMED_TXN_ERR SET
3168 REPROCESS_READY_YN = p_reprocess_ready_yn
3169 ,WO_MAT_TXN_PK = p_wo_mat_txn_pk
3170 ,WORKORDER_FK = p_workorder_fk
3171 ,PRODUCT_FK = p_product_fk
3172 ,MATERIAL_FK = p_material_fk
3173 ,SEGMENT_FK = p_segment_fk
3174 ,TRANSACTION_QTY = p_transaction_qty
3175 ,TRANSACTION_QTY_G = p_transaction_qty_g
3176 ,TRANSACTION_QTY_SG = p_transaction_qty_sg
3177 ,TRANSACTION_UOM = p_transaction_uom
3178 ,PRIMARY_UOM = p_primary_uom
3179 ,SECONDARY_UOM = p_secondary_uom
3180 ,TRANSACTION_DATE = fnd_date.canonical_to_date(p_transaction_date)
3181 ,SYSTEM_FK = p_system_fk
3182 ,SOURCE_ORG_CODE = p_source_org_code
3183 ,USER_DIM1_FK = p_user_dim1_fk
3184 ,USER_DIM2_FK = p_user_dim2_fk
3185 ,USER_DIM3_FK = p_user_dim3_fk
3186 ,USER_DIM4_FK = p_user_dim4_fk
3190 ,USER_ATTR3 = p_user_attr3
3187 ,USER_DIM5_FK = p_user_dim5_fk
3188 ,USER_ATTR1 = p_user_attr1
3189 ,USER_ATTR2 = p_user_attr2
3191 ,USER_ATTR4 = p_user_attr4
3192 ,USER_ATTR5 = p_user_attr5
3193 ,USER_MEASURE1 = p_user_measure1
3194 ,USER_MEASURE2 = p_user_measure2
3195 ,USER_MEASURE3 = p_user_measure3
3196 ,USER_MEASURE4 = p_user_measure4
3197 ,USER_MEASURE5 = p_user_measure5
3198 WHERE ROWID = p_rowid;
3199
3200 ELSE
3201
3202 INSERT INTO MTH_PROD_MTL_CONSUMED_TXN_ERR (
3203 REPROCESS_READY_YN
3204 ,WO_MAT_TXN_PK
3205 ,WORKORDER_FK
3206 ,PRODUCT_FK
3207 ,MATERIAL_FK
3208 ,SEGMENT_FK
3209 ,TRANSACTION_QTY
3210 ,TRANSACTION_QTY_G
3211 ,TRANSACTION_QTY_SG
3212 ,TRANSACTION_UOM
3213 ,PRIMARY_UOM
3214 ,SECONDARY_UOM
3215 ,TRANSACTION_DATE
3216 ,SYSTEM_FK
3217 ,SOURCE_ORG_CODE
3218 ,USER_DIM1_FK
3219 ,USER_DIM2_FK
3220 ,USER_DIM3_FK
3221 ,USER_DIM4_FK
3222 ,USER_DIM5_FK
3223 ,USER_ATTR1
3224 ,USER_ATTR2
3225 ,USER_ATTR3
3226 ,USER_ATTR4
3227 ,USER_ATTR5
3228 ,USER_MEASURE1
3229 ,USER_MEASURE2
3230 ,USER_MEASURE3
3231 ,USER_MEASURE4
3232 ,USER_MEASURE5
3233 ) VALUES (
3234 p_reprocess_ready_yn
3235 ,p_wo_mat_txn_pk
3236 ,p_workorder_fk
3237 ,p_product_fk
3238 ,p_material_fk
3239 ,p_segment_fk
3240 ,p_transaction_qty
3241 ,p_transaction_qty_g
3242 ,p_transaction_qty_sg
3243 ,p_transaction_uom
3244 ,p_primary_uom
3245 ,p_secondary_uom
3246 ,fnd_date.canonical_to_date(p_transaction_date)
3247 ,p_system_fk
3248 ,p_source_org_code
3249 ,p_user_dim1_fk
3250 ,p_user_dim2_fk
3251 ,p_user_dim3_fk
3252 ,p_user_dim4_fk
3253 ,p_user_dim5_fk
3254 ,p_user_attr1
3255 ,p_user_attr2
3256 ,p_user_attr3
3257 ,p_user_attr4
3258 ,p_user_attr5
3259 ,p_user_measure1
3260 ,p_user_measure2
3261 ,p_user_measure3
3262 ,p_user_measure4
3263 ,p_user_measure5
3264 );
3265
3266 END IF;
3267
3268 END UPD_PROD_MTL_CONSUMED_TXN_ERR;
3269
3270 PROCEDURE UPD_PROD_MTL_PRODUCED_ERR (
3271 p_err_code IN VARCHAR2,
3272 p_reprocess_ready_yn IN VARCHAR2,
3273 p_workorder_fk IN VARCHAR2,
3274 p_item_fk IN VARCHAR2,
3275 p_start_quantity_g IN NUMBER,
3276 p_system_fk IN VARCHAR2,
3277 p_start_quantity_sg IN NUMBER,
3278 p_expected_yield IN NUMBER,
3279 p_primary_uom IN VARCHAR2,
3280 p_secondary_uom IN VARCHAR2,
3281 p_actual_comp_qty_g IN NUMBER,
3282 p_actual_comp_qty_sg IN NUMBER,
3283 p_actual_rejected_qty_g IN NUMBER,
3284 p_actual_rejected_qty_sg IN NUMBER,
3285 p_actual_reworked_qty_g IN NUMBER,
3286 p_actual_reworked_qty_sg IN NUMBER,
3287 p_actual_scrap_qty_g IN NUMBER,
3288 p_actual_scrap_qty_sg IN NUMBER,
3289 p_item_type_code IN VARCHAR2,
3290 p_user_dim1_fk IN VARCHAR2,
3291 p_user_dim2_fk IN VARCHAR2,
3292 p_user_dim3_fk IN VARCHAR2,
3293 p_user_dim4_fk IN VARCHAR2,
3294 p_user_dim5_fk IN VARCHAR2,
3295 p_user_attr1 IN VARCHAR2,
3296 p_user_attr2 IN VARCHAR2,
3297 p_user_attr3 IN VARCHAR2,
3298 p_user_attr4 IN VARCHAR2,
3299 p_user_attr5 IN VARCHAR2,
3300 p_user_measure1 IN NUMBER,
3301 p_user_measure2 IN NUMBER,
3302 p_user_measure3 IN NUMBER,
3303 p_user_measure4 IN NUMBER,
3304 p_user_measure5 IN NUMBER,
3305 p_wip_plan_qty_g IN NUMBER,
3306 p_wip_plan_qty_sg IN NUMBER,
3310 BEGIN
3307 p_contribute_yield_flag IN VARCHAR2,
3308 p_rowid IN ROWID
3309 ) IS
3311
3312 IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
3313
3314 FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
3315 RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
3316
3317 ELSIF p_rowid IS NOT NULL THEN
3318
3319 UPDATE MTH_PROD_MTL_PRODUCED_ERR SET
3320 REPROCESS_READY_YN = p_reprocess_ready_yn
3321 ,WORKORDER_FK = p_workorder_fk
3322 ,ITEM_FK = p_item_fk
3323 ,START_QUANTITY_G = p_start_quantity_g
3324 ,SYSTEM_FK = p_system_fk
3325 ,START_QUANTITY_SG = p_start_quantity_sg
3326 ,EXPECTED_YIELD = p_expected_yield
3327 ,PRIMARY_UOM = p_primary_uom
3328 ,SECONDARY_UOM = p_secondary_uom
3329 ,ACTUAL_COMP_QTY_G = p_actual_comp_qty_g
3330 ,ACTUAL_COMP_QTY_SG = p_actual_comp_qty_sg
3331 ,ACTUAL_REJECTED_QTY_G = p_actual_rejected_qty_g
3332 ,ACTUAL_REJECTED_QTY_SG = p_actual_rejected_qty_sg
3333 ,ACTUAL_REWORKED_QTY_G = p_actual_reworked_qty_g
3334 ,ACTUAL_REWORKED_QTY_SG = p_actual_reworked_qty_sg
3335 ,ACTUAL_SCRAP_QTY_G = p_actual_scrap_qty_g
3336 ,ACTUAL_SCRAP_QTY_SG = p_actual_scrap_qty_sg
3337 ,ITEM_TYPE_CODE = p_item_type_code
3338 ,USER_DIM1_FK = p_user_dim1_fk
3339 ,USER_DIM2_FK = p_user_dim2_fk
3340 ,USER_DIM3_FK = p_user_dim3_fk
3341 ,USER_DIM4_FK = p_user_dim4_fk
3342 ,USER_DIM5_FK = p_user_dim5_fk
3343 ,USER_ATTR1 = p_user_attr1
3344 ,USER_ATTR2 = p_user_attr2
3345 ,USER_ATTR3 = p_user_attr3
3346 ,USER_ATTR4 = p_user_attr4
3347 ,USER_ATTR5 = p_user_attr5
3348 ,USER_MEASURE1 = p_user_measure1
3349 ,USER_MEASURE2 = p_user_measure2
3350 ,USER_MEASURE3 = p_user_measure3
3351 ,USER_MEASURE4 = p_user_measure4
3352 ,USER_MEASURE5 = p_user_measure5
3353 ,WIP_PLAN_QTY_G = p_wip_plan_qty_g
3354 ,WIP_PLAN_QTY_SG = p_wip_plan_qty_sg
3355 ,CONTRIBUTE_YIELD_FLAG = p_contribute_yield_flag
3356 WHERE ROWID = p_rowid;
3357
3358 ELSE
3359
3360 INSERT INTO MTH_PROD_MTL_PRODUCED_ERR (
3361 REPROCESS_READY_YN
3362 ,WORKORDER_FK
3363 ,ITEM_FK
3364 ,START_QUANTITY_G
3365 ,SYSTEM_FK
3366 ,START_QUANTITY_SG
3367 ,EXPECTED_YIELD
3368 ,PRIMARY_UOM
3369 ,SECONDARY_UOM
3370 ,ACTUAL_COMP_QTY_G
3371 ,ACTUAL_COMP_QTY_SG
3372 ,ACTUAL_REJECTED_QTY_G
3373 ,ACTUAL_REJECTED_QTY_SG
3374 ,ACTUAL_REWORKED_QTY_G
3375 ,ACTUAL_REWORKED_QTY_SG
3376 ,ACTUAL_SCRAP_QTY_G
3377 ,ACTUAL_SCRAP_QTY_SG
3378 ,ITEM_TYPE_CODE
3379 ,USER_DIM1_FK
3380 ,USER_DIM2_FK
3381 ,USER_DIM3_FK
3382 ,USER_DIM4_FK
3383 ,USER_DIM5_FK
3384 ,USER_ATTR1
3385 ,USER_ATTR2
3386 ,USER_ATTR3
3387 ,USER_ATTR4
3388 ,USER_ATTR5
3389 ,USER_MEASURE1
3390 ,USER_MEASURE2
3391 ,USER_MEASURE3
3392 ,USER_MEASURE4
3393 ,USER_MEASURE5
3394 ,WIP_PLAN_QTY_G
3395 ,WIP_PLAN_QTY_SG
3396 ,CONTRIBUTE_YIELD_FLAG
3397 ) VALUES (
3398 p_reprocess_ready_yn
3399 ,p_workorder_fk
3400 ,p_item_fk
3401 ,p_start_quantity_g
3402 ,p_system_fk
3403 ,p_start_quantity_sg
3404 ,p_expected_yield
3405 ,p_primary_uom
3406 ,p_secondary_uom
3407 ,p_actual_comp_qty_g
3408 ,p_actual_comp_qty_sg
3409 ,p_actual_rejected_qty_g
3410 ,p_actual_rejected_qty_sg
3411 ,p_actual_reworked_qty_g
3412 ,p_actual_reworked_qty_sg
3413 ,p_actual_scrap_qty_g
3414 ,p_actual_scrap_qty_sg
3415 ,p_item_type_code
3416 ,p_user_dim1_fk
3417 ,p_user_dim2_fk
3421 ,p_user_attr1
3418 ,p_user_dim3_fk
3419 ,p_user_dim4_fk
3420 ,p_user_dim5_fk
3422 ,p_user_attr2
3423 ,p_user_attr3
3424 ,p_user_attr4
3425 ,p_user_attr5
3426 ,p_user_measure1
3427 ,p_user_measure2
3428 ,p_user_measure3
3429 ,p_user_measure4
3430 ,p_user_measure5
3431 ,p_wip_plan_qty_g
3432 ,p_wip_plan_qty_sg
3433 ,p_contribute_yield_flag
3434 );
3435
3436 END IF;
3437
3438 END UPD_PROD_MTL_PRODUCED_ERR;
3439
3440 PROCEDURE UPD_PROD_MTL_PRODUCED_TXN_ERR (
3441 p_err_code IN VARCHAR2,
3442 p_reprocess_ready_yn IN VARCHAR2,
3443 p_wo_comp_pk IN VARCHAR2,
3444 p_workorder_fk IN VARCHAR2,
3445 p_item_fk IN VARCHAR2,
3446 p_segment_fk IN VARCHAR2,
3447 p_transaction_type IN VARCHAR2,
3448 p_transaction_qty IN NUMBER,
3449 p_transaction_qty_g IN NUMBER,
3450 p_transaction_qty_sg IN NUMBER,
3451 p_transaction_uom IN VARCHAR2,
3452 p_primary_uom IN VARCHAR2,
3453 p_secondary_uom IN VARCHAR2,
3454 p_transaction_date IN VARCHAR2,
3455 p_source_org_code IN VARCHAR2,
3456 p_system_fk IN VARCHAR2,
3457 p_user_dim1_fk IN VARCHAR2,
3458 p_user_dim2_fk IN VARCHAR2,
3459 p_user_dim3_fk IN VARCHAR2,
3460 p_user_dim4_fk IN VARCHAR2,
3461 p_user_dim5_fk IN VARCHAR2,
3462 p_user_attr1 IN VARCHAR2,
3463 p_user_attr2 IN VARCHAR2,
3464 p_user_attr3 IN VARCHAR2,
3465 p_user_attr4 IN VARCHAR2,
3466 p_user_attr5 IN VARCHAR2,
3467 p_user_measure1 IN NUMBER,
3468 p_user_measure2 IN NUMBER,
3469 p_user_measure3 IN NUMBER,
3470 p_user_measure4 IN NUMBER,
3471 p_user_measure5 IN NUMBER,
3472 p_rowid IN ROWID
3473 ) IS
3474 BEGIN
3475
3476 IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
3477
3478 FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
3479 RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
3480
3481 ELSIF p_rowid IS NOT NULL THEN
3482
3483 UPDATE MTH_PROD_MTL_PRODUCED_TXN_ERR SET
3484 REPROCESS_READY_YN = p_reprocess_ready_yn
3485 ,WO_COMP_PK = p_wo_comp_pk
3486 ,WORKORDER_FK = p_workorder_fk
3487 ,ITEM_FK = p_item_fk
3488 ,SEGMENT_FK = p_segment_fk
3489 ,TRANSACTION_TYPE = p_transaction_type
3490 ,TRANSACTION_QTY = p_transaction_qty
3491 ,TRANSACTION_QTY_G = p_transaction_qty_g
3492 ,TRANSACTION_QTY_SG = p_transaction_qty_sg
3493 ,TRANSACTION_UOM = p_transaction_uom
3494 ,PRIMARY_UOM = p_primary_uom
3495 ,SECONDARY_UOM = p_secondary_uom
3496 ,TRANSACTION_DATE = fnd_date.canonical_to_date(p_transaction_date)
3497 ,SOURCE_ORG_CODE = p_source_org_code
3498 ,SYSTEM_FK = p_system_fk
3499 ,USER_DIM1_FK = p_user_dim1_fk
3500 ,USER_DIM2_FK = p_user_dim2_fk
3501 ,USER_DIM3_FK = p_user_dim3_fk
3502 ,USER_DIM4_FK = p_user_dim4_fk
3503 ,USER_DIM5_FK = p_user_dim5_fk
3504 ,USER_ATTR1 = p_user_attr1
3505 ,USER_ATTR2 = p_user_attr2
3506 ,USER_ATTR3 = p_user_attr3
3507 ,USER_ATTR4 = p_user_attr4
3508 ,USER_ATTR5 = p_user_attr5
3512 ,USER_MEASURE4 = p_user_measure4
3509 ,USER_MEASURE1 = p_user_measure1
3510 ,USER_MEASURE2 = p_user_measure2
3511 ,USER_MEASURE3 = p_user_measure3
3513 ,USER_MEASURE5 = p_user_measure5
3514 WHERE ROWID = p_rowid;
3515
3516 ELSE
3517
3518 INSERT INTO MTH_PROD_MTL_PRODUCED_TXN_ERR (
3519 REPROCESS_READY_YN
3520 ,WO_COMP_PK
3521 ,WORKORDER_FK
3522 ,ITEM_FK
3523 ,SEGMENT_FK
3524 ,TRANSACTION_TYPE
3525 ,TRANSACTION_QTY
3526 ,TRANSACTION_QTY_G
3527 ,TRANSACTION_QTY_SG
3528 ,TRANSACTION_UOM
3529 ,PRIMARY_UOM
3530 ,SECONDARY_UOM
3531 ,TRANSACTION_DATE
3532 ,SOURCE_ORG_CODE
3533 ,SYSTEM_FK
3534 ,USER_DIM1_FK
3535 ,USER_DIM2_FK
3536 ,USER_DIM3_FK
3537 ,USER_DIM4_FK
3538 ,USER_DIM5_FK
3539 ,USER_ATTR1
3540 ,USER_ATTR2
3541 ,USER_ATTR3
3542 ,USER_ATTR4
3543 ,USER_ATTR5
3544 ,USER_MEASURE1
3545 ,USER_MEASURE2
3546 ,USER_MEASURE3
3547 ,USER_MEASURE4
3548 ,USER_MEASURE5
3549 ) VALUES (
3550 p_reprocess_ready_yn
3551 ,p_wo_comp_pk
3552 ,p_workorder_fk
3553 ,p_item_fk
3554 ,p_segment_fk
3555 ,p_transaction_type
3556 ,p_transaction_qty
3557 ,p_transaction_qty_g
3558 ,p_transaction_qty_sg
3559 ,p_transaction_uom
3560 ,p_primary_uom
3561 ,p_secondary_uom
3562 ,fnd_date.canonical_to_date(p_transaction_date)
3563 ,p_source_org_code
3564 ,p_system_fk
3565 ,p_user_dim1_fk
3566 ,p_user_dim2_fk
3567 ,p_user_dim3_fk
3568 ,p_user_dim4_fk
3569 ,p_user_dim5_fk
3570 ,p_user_attr1
3571 ,p_user_attr2
3572 ,p_user_attr3
3576 ,p_user_measure2
3573 ,p_user_attr4
3574 ,p_user_attr5
3575 ,p_user_measure1
3577 ,p_user_measure3
3578 ,p_user_measure4
3579 ,p_user_measure5
3580 );
3581
3582 END IF;
3583
3584 END UPD_PROD_MTL_PRODUCED_TXN_ERR;
3585
3586 PROCEDURE UPD_PROD_SEGMENTS_TXN_ERR (
3587 p_err_code IN VARCHAR2,
3588 p_reprocess_ready_yn IN VARCHAR2,
3589 p_workorder_fk IN VARCHAR2,
3590 p_from_segment_fk IN VARCHAR2,
3591 p_to_segment_fk IN VARCHAR2,
3592 p_item_fk IN VARCHAR2,
3593 p_system_fk IN VARCHAR2,
3594 p_transaction_date IN VARCHAR2,
3595 p_transaction_qty IN NUMBER,
3596 p_transaction_qty_g IN NUMBER,
3597 p_transaction_qty_sg IN NUMBER,
3598 p_primary_uom IN VARCHAR2,
3599 p_secondary_uom IN VARCHAR2,
3600 p_transaction_uom IN VARCHAR2,
3601 p_from_step_type IN VARCHAR2,
3602 p_to_step_type IN VARCHAR2,
3603 p_user_dim1_fk IN VARCHAR2,
3604 p_user_dim2_fk IN VARCHAR2,
3605 p_user_dim3_fk IN VARCHAR2,
3606 p_user_dim4_fk IN VARCHAR2,
3607 p_user_dim5_fk IN VARCHAR2,
3608 p_user_attr1 IN VARCHAR2,
3609 p_user_attr2 IN VARCHAR2,
3610 p_user_attr3 IN VARCHAR2,
3611 p_user_attr4 IN VARCHAR2,
3612 p_user_attr5 IN VARCHAR2,
3613 p_user_measure1 IN NUMBER,
3614 p_user_measure2 IN NUMBER,
3615 p_user_measure3 IN NUMBER,
3616 p_user_measure4 IN NUMBER,
3617 p_user_measure5 IN NUMBER,
3618 p_sub_segment_fk IN VARCHAR2,
3619 p_rowid IN ROWID
3620 ) IS
3621 BEGIN
3622
3623 IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
3624
3625 FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
3626 RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
3627
3628 ELSIF p_rowid IS NOT NULL THEN
3629
3630 UPDATE MTH_PROD_SEGMENTS_TXN_ERR SET
3631 REPROCESS_READY_YN = p_reprocess_ready_yn
3632 ,WORKORDER_FK = p_workorder_fk
3633 ,FROM_SEGMENT_FK = p_from_segment_fk
3634 ,TO_SEGMENT_FK = p_to_segment_fk
3635 ,ITEM_FK = p_item_fk
3636 ,SYSTEM_FK = p_system_fk
3637 ,TRANSACTION_DATE = fnd_date.canonical_to_date(p_transaction_date)
3638 ,TRANSACTION_QTY = p_transaction_qty
3639 ,TRANSACTION_QTY_G = p_transaction_qty_g
3640 ,TRANSACTION_QTY_SG = p_transaction_qty_sg
3641 ,PRIMARY_UOM = p_primary_uom
3642 ,SECONDARY_UOM = p_secondary_uom
3643 ,TRANSACTION_UOM = p_transaction_uom
3644 ,FROM_STEP_TYPE = p_from_step_type
3645 ,TO_STEP_TYPE = p_to_step_type
3651 ,USER_ATTR1 = p_user_attr1
3646 ,USER_DIM1_FK = p_user_dim1_fk
3647 ,USER_DIM2_FK = p_user_dim2_fk
3648 ,USER_DIM3_FK = p_user_dim3_fk
3649 ,USER_DIM4_FK = p_user_dim4_fk
3650 ,USER_DIM5_FK = p_user_dim5_fk
3652 ,USER_ATTR2 = p_user_attr2
3653 ,USER_ATTR3 = p_user_attr3
3654 ,USER_ATTR4 = p_user_attr4
3655 ,USER_ATTR5 = p_user_attr5
3656 ,USER_MEASURE1 = p_user_measure1
3657 ,USER_MEASURE2 = p_user_measure2
3658 ,USER_MEASURE3 = p_user_measure3
3659 ,USER_MEASURE4 = p_user_measure4
3660 ,USER_MEASURE5 = p_user_measure5
3661 ,SUB_SEGMENT_FK = p_sub_segment_fk
3662 WHERE ROWID = p_rowid;
3663
3664 ELSE
3665
3666 INSERT INTO MTH_PROD_SEGMENTS_TXN_ERR (
3667 REPROCESS_READY_YN
3668 ,WORKORDER_FK
3669 ,FROM_SEGMENT_FK
3670 ,TO_SEGMENT_FK
3671 ,ITEM_FK
3672 ,SYSTEM_FK
3673 ,TRANSACTION_DATE
3674 ,TRANSACTION_QTY
3675 ,TRANSACTION_QTY_G
3676 ,TRANSACTION_QTY_SG
3677 ,PRIMARY_UOM
3678 ,SECONDARY_UOM
3679 ,TRANSACTION_UOM
3680 ,FROM_STEP_TYPE
3681 ,TO_STEP_TYPE
3682 ,USER_DIM1_FK
3683 ,USER_DIM2_FK
3684 ,USER_DIM3_FK
3685 ,USER_DIM4_FK
3686 ,USER_DIM5_FK
3687 ,USER_ATTR1
3688 ,USER_ATTR2
3689 ,USER_ATTR3
3690 ,USER_ATTR4
3691 ,USER_ATTR5
3692 ,USER_MEASURE1
3693 ,USER_MEASURE2
3694 ,USER_MEASURE3
3695 ,USER_MEASURE4
3696 ,USER_MEASURE5
3697 ,SUB_SEGMENT_FK
3698 ) VALUES (
3699 p_reprocess_ready_yn
3700 ,p_workorder_fk
3701 ,p_from_segment_fk
3702 ,p_to_segment_fk
3703 ,p_item_fk
3704 ,p_system_fk
3705 ,fnd_date.canonical_to_date(p_transaction_date)
3706 ,p_transaction_qty
3707 ,p_transaction_qty_g
3708 ,p_transaction_qty_sg
3709 ,p_primary_uom
3710 ,p_secondary_uom
3711 ,p_transaction_uom
3712 ,p_from_step_type
3713 ,p_to_step_type
3714 ,p_user_dim1_fk
3715 ,p_user_dim2_fk
3716 ,p_user_dim3_fk
3717 ,p_user_dim4_fk
3718 ,p_user_dim5_fk
3719 ,p_user_attr1
3720 ,p_user_attr2
3721 ,p_user_attr3
3722 ,p_user_attr4
3723 ,p_user_attr5
3724 ,p_user_measure1
3725 ,p_user_measure2
3726 ,p_user_measure3
3727 ,p_user_measure4
3728 ,p_user_measure5
3729 ,p_sub_segment_fk
3730 );
3731
3732 END IF;
3733
3734 END UPD_PROD_SEGMENTS_TXN_ERR;
3735
3736 PROCEDURE UPD_PROD_SUB_SEGMENTS_ERR (
3737 p_err_code IN VARCHAR2,
3738 p_reprocess_ready_yn IN VARCHAR2,
3739 p_sub_segment_pk IN VARCHAR2,
3740 p_segment_fk IN VARCHAR2,
3741 p_system_fk IN VARCHAR2,
3742 p_description IN VARCHAR2,
3743 p_actual_start_date IN VARCHAR2,
3744 p_actual_completion_date IN VARCHAR2,
3745 p_planned_start_date IN VARCHAR2,
3746 p_planned_completion_date IN VARCHAR2,
3747 p_user_attr1 IN VARCHAR2,
3748 p_user_attr2 IN VARCHAR2,
3749 p_user_attr3 IN VARCHAR2,
3750 p_user_attr4 IN VARCHAR2,
3751 p_user_attr5 IN VARCHAR2,
3752 p_user_measure1 IN NUMBER,
3753 p_user_measure2 IN NUMBER,
3754 p_user_measure3 IN NUMBER,
3755 p_user_measure4 IN NUMBER,
3756 p_user_measure5 IN NUMBER,
3757 p_rowid IN ROWID
3758 ) IS
3759 BEGIN
3760
3761 IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
3762
3763 FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
3764 RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
3765
3766 ELSIF p_rowid IS NOT NULL THEN
3767
3768 UPDATE MTH_PROD_SUB_SEGMENTS_ERR SET
3769 REPROCESS_READY_YN = p_reprocess_ready_yn
3770 ,SUB_SEGMENT_PK = p_sub_segment_pk
3774 ,ACTUAL_START_DATE = fnd_date.canonical_to_date(p_actual_start_date)
3771 ,SEGMENT_FK = p_segment_fk
3772 ,SYSTEM_FK = p_system_fk
3773 ,DESCRIPTION = p_description
3775 ,ACTUAL_COMPLETION_DATE = fnd_date.canonical_to_date(p_actual_completion_date)
3776 ,PLANNED_START_DATE = fnd_date.canonical_to_date(p_planned_start_date)
3777 ,PLANNED_COMPLETION_DATE = fnd_date.canonical_to_date(p_planned_completion_date)
3778 ,USER_ATTR1 = p_user_attr1
3779 ,USER_ATTR2 = p_user_attr2
3780 ,USER_ATTR3 = p_user_attr3
3781 ,USER_ATTR4 = p_user_attr4
3782 ,USER_ATTR5 = p_user_attr5
3783 ,USER_MEASURE1 = p_user_measure1
3784 ,USER_MEASURE2 = p_user_measure2
3785 ,USER_MEASURE3 = p_user_measure3
3786 ,USER_MEASURE4 = p_user_measure4
3787 ,USER_MEASURE5 = p_user_measure5
3788 WHERE ROWID = p_rowid;
3789
3790 ELSE
3791
3792 INSERT INTO MTH_PROD_SUB_SEGMENTS_ERR (
3793 REPROCESS_READY_YN
3794 ,SUB_SEGMENT_PK
3795 ,SEGMENT_FK
3796 ,SYSTEM_FK
3797 ,DESCRIPTION
3798 ,ACTUAL_START_DATE
3799 ,ACTUAL_COMPLETION_DATE
3800 ,PLANNED_START_DATE
3801 ,PLANNED_COMPLETION_DATE
3802 ,USER_ATTR1
3803 ,USER_ATTR2
3804 ,USER_ATTR3
3805 ,USER_ATTR4
3806 ,USER_ATTR5
3807 ,USER_MEASURE1
3808 ,USER_MEASURE2
3809 ,USER_MEASURE3
3810 ,USER_MEASURE4
3811 ,USER_MEASURE5
3812 ) VALUES (
3813 p_reprocess_ready_yn
3814 ,p_sub_segment_pk
3815 ,p_segment_fk
3816 ,p_system_fk
3817 ,p_description
3818 ,fnd_date.canonical_to_date(p_actual_start_date)
3819 ,fnd_date.canonical_to_date(p_actual_completion_date)
3820 ,fnd_date.canonical_to_date(p_planned_start_date)
3821 ,fnd_date.canonical_to_date(p_planned_completion_date)
3822 ,p_user_attr1
3823 ,p_user_attr2
3824 ,p_user_attr3
3825 ,p_user_attr4
3826 ,p_user_attr5
3827 ,p_user_measure1
3828 ,p_user_measure2
3829 ,p_user_measure3
3830 ,p_user_measure4
3831 ,p_user_measure5
3832 );
3833
3834 END IF;
3835
3836 END UPD_PROD_SUB_SEGMENTS_ERR;
3837
3838 PROCEDURE UPD_QUARTER_ERR (
3839 p_err_code IN VARCHAR2,
3840 p_reprocess_ready_yn IN VARCHAR2,
3841 p_hierarchy_name IN VARCHAR2,
3842 p_name IN VARCHAR2,
3843 p_user_attr1 IN VARCHAR2,
3844 p_user_attr2 IN VARCHAR2,
3845 p_user_attr3 IN VARCHAR2,
3846 p_user_attr4 IN VARCHAR2,
3847 p_user_attr5 IN VARCHAR2,
3848 p_user_measure1 IN NUMBER,
3849 p_user_measure2 IN NUMBER,
3850 p_user_measure3 IN NUMBER,
3851 p_user_measure4 IN NUMBER,
3852 p_user_measure5 IN NUMBER,
3853 p_system_fk IN VARCHAR2,
3854 p_end_date IN VARCHAR2,
3855 p_start_date IN VARCHAR2,
3856 p_rowid IN ROWID
3857 ) IS
3858 BEGIN
3859
3860 IF NVL(p_reprocess_ready_yn,'X') NOT IN ('D') THEN
3861
3862 FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
3863 RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
3864
3865 ELSIF p_rowid IS NOT NULL THEN
3866
3867 UPDATE MTH_QUARTER_ERR SET
3868 REPROCESS_READY_YN = p_reprocess_ready_yn
3869 ,HIERARCHY_NAME = p_hierarchy_name
3870 ,NAME = p_name
3871 ,USER_ATTR1 = p_user_attr1
3872 ,USER_ATTR2 = p_user_attr2
3873 ,USER_ATTR3 = p_user_attr3
3874 ,USER_ATTR4 = p_user_attr4
3875 ,USER_ATTR5 = p_user_attr5
3876 ,USER_MEASURE1 = p_user_measure1
3877 ,USER_MEASURE2 = p_user_measure2
3878 ,USER_MEASURE3 = p_user_measure3
3879 ,USER_MEASURE4 = p_user_measure4
3880 ,USER_MEASURE5 = p_user_measure5
3881 ,SYSTEM_FK = p_system_fk
3885
3882 ,END_DATE = fnd_date.canonical_to_date(p_end_date)
3883 ,START_DATE = fnd_date.canonical_to_date(p_start_date)
3884 WHERE ROWID = p_rowid;
3886 ELSE
3887
3888 RAISE_APPLICATION_ERROR(-20002, 'Reprocess not allowed.');
3889
3890 END IF;
3891
3892 END UPD_QUARTER_ERR;
3893
3894 PROCEDURE UPD_RESOURCES_ERR (
3895 p_err_code IN VARCHAR2,
3896 p_reprocess_ready_yn IN VARCHAR2,
3897 p_resource_pk IN VARCHAR2,
3898 p_resource_type IN VARCHAR2,
3899 p_ebs_resource_id IN NUMBER,
3900 p_ebs_department_id IN NUMBER,
3901 p_ebs_organization_id IN NUMBER,
3902 p_usage_uom IN VARCHAR2,
3903 p_capacity_units IN NUMBER,
3904 p_available_24_hour_flag IN VARCHAR2,
3905 p_system_fk IN VARCHAR2,
3906 p_disable_date IN VARCHAR2,
3907 p_resource_name IN VARCHAR2,
3908 p_user_attr1 IN VARCHAR2,
3909 p_user_attr2 IN VARCHAR2,
3910 p_user_attr3 IN VARCHAR2,
3911 p_user_attr4 IN VARCHAR2,
3912 p_user_attr5 IN VARCHAR2,
3913 p_user_attr6 IN VARCHAR2,
3914 p_user_attr7 IN VARCHAR2,
3915 p_user_attr8 IN VARCHAR2,
3916 p_user_attr9 IN VARCHAR2,
3917 p_user_attr10 IN VARCHAR2,
3918 p_user_attr11 IN VARCHAR2,
3922 p_user_attr15 IN VARCHAR2,
3919 p_user_attr12 IN VARCHAR2,
3920 p_user_attr13 IN VARCHAR2,
3921 p_user_attr14 IN VARCHAR2,
3923 p_user_attr16 IN VARCHAR2,
3924 p_user_attr17 IN VARCHAR2,
3925 p_user_attr18 IN VARCHAR2,
3926 p_user_attr19 IN VARCHAR2,
3927 p_user_attr20 IN VARCHAR2,
3928 p_user_measure1 IN NUMBER,
3929 p_user_measure2 IN NUMBER,
3930 p_user_measure3 IN NUMBER,
3931 p_user_measure4 IN NUMBER,
3932 p_user_measure5 IN NUMBER,
3933 p_source_org_code IN VARCHAR2,
3934 p_resource_description IN VARCHAR2,
3935 p_std_utilization IN NUMBER,
3936 p_std_efficiency IN NUMBER,
3937 p_production_resource IN VARCHAR2,
3938 p_status IN VARCHAR2,
3939 p_business_function IN VARCHAR2,
3940 p_rowid IN ROWID
3941 ) IS
3942 BEGIN
3943
3944 IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
3945
3946 FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
3947 RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
3948
3949 ELSIF p_rowid IS NOT NULL THEN
3950
3951 UPDATE MTH_RESOURCES_ERR SET
3952 REPROCESS_READY_YN = p_reprocess_ready_yn
3953 ,RESOURCE_PK = p_resource_pk
3954 ,RESOURCE_TYPE = p_resource_type
3955 ,EBS_RESOURCE_ID = p_ebs_resource_id
3956 ,EBS_DEPARTMENT_ID = p_ebs_department_id
3957 ,EBS_ORGANIZATION_ID = p_ebs_organization_id
3961 ,SYSTEM_FK = p_system_fk
3958 ,USAGE_UOM = p_usage_uom
3959 ,CAPACITY_UNITS = p_capacity_units
3960 ,AVAILABLE_24_HOUR_FLAG = p_available_24_hour_flag
3962 ,DISABLE_DATE = fnd_date.canonical_to_date(p_disable_date)
3963 ,RESOURCE_NAME = p_resource_name
3964 ,USER_ATTR1 = p_user_attr1
3965 ,USER_ATTR2 = p_user_attr2
3966 ,USER_ATTR3 = p_user_attr3
3967 ,USER_ATTR4 = p_user_attr4
3968 ,USER_ATTR5 = p_user_attr5
3969 ,USER_ATTR6 = p_user_attr6
3970 ,USER_ATTR7 = p_user_attr7
3971 ,USER_ATTR8 = p_user_attr8
3972 ,USER_ATTR9 = p_user_attr9
3973 ,USER_ATTR10 = p_user_attr10
3974 ,USER_ATTR11 = p_user_attr11
3975 ,USER_ATTR12 = p_user_attr12
3976 ,USER_ATTR13 = p_user_attr13
3977 ,USER_ATTR14 = p_user_attr14
3978 ,USER_ATTR15 = p_user_attr15
3979 ,USER_ATTR16 = p_user_attr16
3980 ,USER_ATTR17 = p_user_attr17
3981 ,USER_ATTR18 = p_user_attr18
3982 ,USER_ATTR19 = p_user_attr19
3983 ,USER_ATTR20 = p_user_attr20
3984 ,USER_MEASURE1 = p_user_measure1
3985 ,USER_MEASURE2 = p_user_measure2
3986 ,USER_MEASURE3 = p_user_measure3
3987 ,USER_MEASURE4 = p_user_measure4
3988 ,USER_MEASURE5 = p_user_measure5
3989 ,SOURCE_ORG_CODE = p_source_org_code
3990 ,RESOURCE_DESCRIPTION = p_resource_description
3991 ,STD_UTILIZATION = p_std_utilization
3992 ,STD_EFFICIENCY = p_std_efficiency
3993 ,PRODUCTION_RESOURCE = p_production_resource
3994 ,STATUS = p_status
3995 ,BUSINESS_FUNCTION = p_business_function
3996 WHERE ROWID = p_rowid;
3997
3998 ELSE
3999
4000 INSERT INTO MTH_RESOURCES_ERR (
4001 REPROCESS_READY_YN
4002 ,RESOURCE_PK
4003 ,RESOURCE_TYPE
4004 ,EBS_RESOURCE_ID
4005 ,EBS_DEPARTMENT_ID
4006 ,EBS_ORGANIZATION_ID
4007 ,USAGE_UOM
4008 ,CAPACITY_UNITS
4009 ,AVAILABLE_24_HOUR_FLAG
4010 ,SYSTEM_FK
4011 ,DISABLE_DATE
4012 ,RESOURCE_NAME
4013 ,USER_ATTR1
4014 ,USER_ATTR2
4015 ,USER_ATTR3
4016 ,USER_ATTR4
4017 ,USER_ATTR5
4018 ,USER_ATTR6
4019 ,USER_ATTR7
4020 ,USER_ATTR8
4021 ,USER_ATTR9
4022 ,USER_ATTR10
4023 ,USER_ATTR11
4024 ,USER_ATTR12
4025 ,USER_ATTR13
4026 ,USER_ATTR14
4027 ,USER_ATTR15
4028 ,USER_ATTR16
4029 ,USER_ATTR17
4030 ,USER_ATTR18
4031 ,USER_ATTR19
4032 ,USER_ATTR20
4033 ,USER_MEASURE1
4034 ,USER_MEASURE2
4035 ,USER_MEASURE3
4036 ,USER_MEASURE4
4037 ,USER_MEASURE5
4038 ,SOURCE_ORG_CODE
4039 ,RESOURCE_DESCRIPTION
4040 ,STD_UTILIZATION
4041 ,STD_EFFICIENCY
4042 ,PRODUCTION_RESOURCE
4043 ,STATUS
4044 ,BUSINESS_FUNCTION
4045 ) VALUES (
4046 p_reprocess_ready_yn
4047 ,p_resource_pk
4048 ,p_resource_type
4049 ,p_ebs_resource_id
4050 ,p_ebs_department_id
4051 ,p_ebs_organization_id
4052 ,p_usage_uom
4053 ,p_capacity_units
4054 ,p_available_24_hour_flag
4055 ,p_system_fk
4056 ,fnd_date.canonical_to_date(p_disable_date)
4057 ,p_resource_name
4058 ,p_user_attr1
4059 ,p_user_attr2
4060 ,p_user_attr3
4061 ,p_user_attr4
4062 ,p_user_attr5
4063 ,p_user_attr6
4064 ,p_user_attr7
4065 ,p_user_attr8
4066 ,p_user_attr9
4067 ,p_user_attr10
4068 ,p_user_attr11
4072 ,p_user_attr15
4069 ,p_user_attr12
4070 ,p_user_attr13
4071 ,p_user_attr14
4073 ,p_user_attr16
4074 ,p_user_attr17
4075 ,p_user_attr18
4076 ,p_user_attr19
4077 ,p_user_attr20
4078 ,p_user_measure1
4079 ,p_user_measure2
4080 ,p_user_measure3
4081 ,p_user_measure4
4082 ,p_user_measure5
4083 ,p_source_org_code
4084 ,p_resource_description
4085 ,p_std_utilization
4086 ,p_std_efficiency
4087 ,p_production_resource
4088 ,p_status
4089 ,p_business_function
4090 );
4091
4092 END IF;
4093
4094 END UPD_RESOURCES_ERR;
4095
4096 PROCEDURE UPD_RESOURCE_COST_ERR (
4097 p_err_code IN VARCHAR2,
4098 p_reprocess_ready_yn IN VARCHAR2,
4099 p_resource_fk IN VARCHAR2,
4100 p_from_date IN VARCHAR2,
4101 p_to_date IN VARCHAR2,
4102 p_cost_element IN VARCHAR2,
4103 p_cost IN NUMBER,
4104 p_system_fk IN VARCHAR2,
4105 p_user_attr1 IN VARCHAR2,
4106 p_user_attr2 IN VARCHAR2,
4107 p_user_attr3 IN VARCHAR2,
4108 p_user_attr4 IN VARCHAR2,
4109 p_user_attr5 IN VARCHAR2,
4110 p_rowid IN ROWID
4111 ) IS
4112 BEGIN
4113
4114 IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
4115
4116 FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
4117 RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
4118
4119 ELSIF p_rowid IS NOT NULL THEN
4120
4121 UPDATE MTH_RESOURCE_COST_ERR SET
4122 REPROCESS_READY_YN = p_reprocess_ready_yn
4123 ,RESOURCE_FK = p_resource_fk
4124 ,FROM_DATE = fnd_date.canonical_to_date(p_from_date)
4125 ,TO_DATE = fnd_date.canonical_to_date(p_to_date)
4126 ,COST_ELEMENT = p_cost_element
4127 ,COST = p_cost
4128 ,SYSTEM_FK = p_system_fk
4129 ,USER_ATTR1 = p_user_attr1
4130 ,USER_ATTR2 = p_user_attr2
4131 ,USER_ATTR3 = p_user_attr3
4132 ,USER_ATTR4 = p_user_attr4
4133 ,USER_ATTR5 = p_user_attr5
4134 WHERE ROWID = p_rowid;
4135
4136 ELSE
4137
4138 INSERT INTO MTH_RESOURCE_COST_ERR (
4139 REPROCESS_READY_YN
4140 ,RESOURCE_FK
4141 ,FROM_DATE
4142 ,TO_DATE
4143 ,COST_ELEMENT
4144 ,COST
4145 ,SYSTEM_FK
4146 ,USER_ATTR1
4147 ,USER_ATTR2
4148 ,USER_ATTR3
4149 ,USER_ATTR4
4150 ,USER_ATTR5
4151 ) VALUES (
4152 p_reprocess_ready_yn
4153 ,p_resource_fk
4154 ,fnd_date.canonical_to_date(p_from_date)
4155 ,fnd_date.canonical_to_date(p_to_date)
4156 ,p_cost_element
4157 ,p_cost
4158 ,p_system_fk
4159 ,p_user_attr1
4160 ,p_user_attr2
4161 ,p_user_attr3
4162 ,p_user_attr4
4163 ,p_user_attr5
4164 );
4165
4166 END IF;
4167
4168 END UPD_RESOURCE_COST_ERR;
4169
4170 PROCEDURE UPD_RESOURCE_REQUIREMENTS_ERR (
4171 p_err_code IN VARCHAR2,
4172 p_reprocess_ready_yn IN VARCHAR2,
4173 p_workorder_fk IN VARCHAR2,
4174 p_product_fk IN VARCHAR2,
4175 p_resource_fk IN VARCHAR2,
4176 p_segment_fk IN VARCHAR2,
4177 p_planned_usage_qty IN NUMBER,
4178 p_usage_uom IN VARCHAR2,
4179 p_unit_standard_qty IN NUMBER,
4180 p_source_org_code IN VARCHAR2,
4181 p_system_fk IN VARCHAR2,
4182 p_user_dim1_fk IN VARCHAR2,
4183 p_user_dim2_fk IN VARCHAR2,
4184 p_user_dim3_fk IN VARCHAR2,
4185 p_user_dim4_fk IN VARCHAR2,
4186 p_user_dim5_fk IN VARCHAR2,
4187 p_user_attr1 IN VARCHAR2,
4188 p_user_attr2 IN VARCHAR2,
4192 p_user_measure1 IN NUMBER,
4189 p_user_attr3 IN VARCHAR2,
4190 p_user_attr4 IN VARCHAR2,
4191 p_user_attr5 IN VARCHAR2,
4193 p_user_measure2 IN NUMBER,
4194 p_user_measure3 IN NUMBER,
4195 p_user_measure4 IN NUMBER,
4196 p_user_measure5 IN NUMBER,
4197 p_sub_segment_fk IN VARCHAR2,
4198 p_rowid IN ROWID
4199 ) IS
4200 BEGIN
4201
4202 IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
4203
4204 FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
4205 RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
4206
4207 ELSIF p_rowid IS NOT NULL THEN
4208
4209 UPDATE MTH_RESOURCE_REQUIREMENTS_ERR SET
4210 REPROCESS_READY_YN = p_reprocess_ready_yn
4211 ,WORKORDER_FK = p_workorder_fk
4212 ,PRODUCT_FK = p_product_fk
4213 ,RESOURCE_FK = p_resource_fk
4214 ,SEGMENT_FK = p_segment_fk
4215 ,PLANNED_USAGE_QTY = p_planned_usage_qty
4216 ,USAGE_UOM = p_usage_uom
4217 ,UNIT_STANDARD_QTY = p_unit_standard_qty
4218 ,SOURCE_ORG_CODE = p_source_org_code
4219 ,SYSTEM_FK = p_system_fk
4220 ,USER_DIM1_FK = p_user_dim1_fk
4221 ,USER_DIM2_FK = p_user_dim2_fk
4222 ,USER_DIM3_FK = p_user_dim3_fk
4223 ,USER_DIM4_FK = p_user_dim4_fk
4224 ,USER_DIM5_FK = p_user_dim5_fk
4225 ,USER_ATTR1 = p_user_attr1
4226 ,USER_ATTR2 = p_user_attr2
4227 ,USER_ATTR3 = p_user_attr3
4228 ,USER_ATTR4 = p_user_attr4
4229 ,USER_ATTR5 = p_user_attr5
4230 ,USER_MEASURE1 = p_user_measure1
4231 ,USER_MEASURE2 = p_user_measure2
4232 ,USER_MEASURE3 = p_user_measure3
4233 ,USER_MEASURE4 = p_user_measure4
4234 ,USER_MEASURE5 = p_user_measure5
4235 ,SUB_SEGMENT_FK = p_sub_segment_fk
4236 WHERE ROWID = p_rowid;
4237
4238 ELSE
4239
4240 INSERT INTO MTH_RESOURCE_REQUIREMENTS_ERR (
4241 REPROCESS_READY_YN
4242 ,WORKORDER_FK
4243 ,PRODUCT_FK
4244 ,RESOURCE_FK
4245 ,SEGMENT_FK
4246 ,PLANNED_USAGE_QTY
4247 ,USAGE_UOM
4248 ,UNIT_STANDARD_QTY
4249 ,SOURCE_ORG_CODE
4250 ,SYSTEM_FK
4251 ,USER_DIM1_FK
4252 ,USER_DIM2_FK
4253 ,USER_DIM3_FK
4254 ,USER_DIM4_FK
4255 ,USER_DIM5_FK
4256 ,USER_ATTR1
4257 ,USER_ATTR2
4258 ,USER_ATTR3
4259 ,USER_ATTR4
4260 ,USER_ATTR5
4261 ,USER_MEASURE1
4262 ,USER_MEASURE2
4263 ,USER_MEASURE3
4264 ,USER_MEASURE4
4265 ,USER_MEASURE5
4266 ,SUB_SEGMENT_FK
4267 ) VALUES (
4268 p_reprocess_ready_yn
4272 ,p_segment_fk
4269 ,p_workorder_fk
4270 ,p_product_fk
4271 ,p_resource_fk
4273 ,p_planned_usage_qty
4274 ,p_usage_uom
4275 ,p_unit_standard_qty
4276 ,p_source_org_code
4277 ,p_system_fk
4278 ,p_user_dim1_fk
4279 ,p_user_dim2_fk
4280 ,p_user_dim3_fk
4281 ,p_user_dim4_fk
4282 ,p_user_dim5_fk
4283 ,p_user_attr1
4284 ,p_user_attr2
4285 ,p_user_attr3
4286 ,p_user_attr4
4287 ,p_user_attr5
4288 ,p_user_measure1
4289 ,p_user_measure2
4290 ,p_user_measure3
4291 ,p_user_measure4
4292 ,p_user_measure5
4293 ,p_sub_segment_fk
4294 );
4295
4296 END IF;
4297
4298 END UPD_RESOURCE_REQUIREMENTS_ERR;
4299
4300 PROCEDURE UPD_RESOURCE_TXN_ERR (
4301 p_err_code IN VARCHAR2,
4302 p_reprocess_ready_yn IN VARCHAR2,
4303 p_workorder_fk IN VARCHAR2,
4304 p_resource_fk IN VARCHAR2,
4305 p_product_fk IN VARCHAR2,
4306 p_segment_fk IN VARCHAR2,
4307 p_usage_qty IN NUMBER,
4308 p_usage_uom IN VARCHAR2,
4309 p_transaction_date IN VARCHAR2,
4310 p_source_org_code IN VARCHAR2,
4311 p_system_fk IN VARCHAR2,
4312 p_user_dim1_fk IN VARCHAR2,
4313 p_user_dim2_fk IN VARCHAR2,
4314 p_user_dim3_fk IN VARCHAR2,
4315 p_user_dim4_fk IN VARCHAR2,
4316 p_user_dim5_fk IN VARCHAR2,
4317 p_user_attr1 IN VARCHAR2,
4318 p_user_attr2 IN VARCHAR2,
4319 p_user_attr3 IN VARCHAR2,
4320 p_user_attr4 IN VARCHAR2,
4321 p_user_attr5 IN VARCHAR2,
4322 p_user_measure1 IN NUMBER,
4323 p_user_measure2 IN NUMBER,
4324 p_user_measure3 IN NUMBER,
4328 p_rowid IN ROWID
4325 p_user_measure4 IN NUMBER,
4326 p_user_measure5 IN NUMBER,
4327 p_sub_segment_fk IN VARCHAR2,
4329 ) IS
4330 BEGIN
4331
4332 IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
4333
4334 FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
4335 RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
4336
4337 ELSIF p_rowid IS NOT NULL THEN
4338
4339 UPDATE MTH_RESOURCE_TXN_ERR SET
4340 REPROCESS_READY_YN = p_reprocess_ready_yn
4341 ,WORKORDER_FK = p_workorder_fk
4342 ,RESOURCE_FK = p_resource_fk
4343 ,PRODUCT_FK = p_product_fk
4344 ,SEGMENT_FK = p_segment_fk
4345 ,USAGE_QTY = p_usage_qty
4346 ,USAGE_UOM = p_usage_uom
4347 ,TRANSACTION_DATE = fnd_date.canonical_to_date(p_transaction_date)
4351 ,USER_DIM2_FK = p_user_dim2_fk
4348 ,SOURCE_ORG_CODE = p_source_org_code
4349 ,SYSTEM_FK = p_system_fk
4350 ,USER_DIM1_FK = p_user_dim1_fk
4352 ,USER_DIM3_FK = p_user_dim3_fk
4353 ,USER_DIM4_FK = p_user_dim4_fk
4354 ,USER_DIM5_FK = p_user_dim5_fk
4355 ,USER_ATTR1 = p_user_attr1
4356 ,USER_ATTR2 = p_user_attr2
4357 ,USER_ATTR3 = p_user_attr3
4358 ,USER_ATTR4 = p_user_attr4
4359 ,USER_ATTR5 = p_user_attr5
4360 ,USER_MEASURE1 = p_user_measure1
4361 ,USER_MEASURE2 = p_user_measure2
4362 ,USER_MEASURE3 = p_user_measure3
4363 ,USER_MEASURE4 = p_user_measure4
4364 ,USER_MEASURE5 = p_user_measure5
4365 ,SUB_SEGMENT_FK = p_sub_segment_fk
4366 WHERE ROWID = p_rowid;
4367
4368 ELSE
4369
4370 INSERT INTO MTH_RESOURCE_TXN_ERR (
4371 REPROCESS_READY_YN
4372 ,WORKORDER_FK
4373 ,RESOURCE_FK
4374 ,PRODUCT_FK
4375 ,SEGMENT_FK
4376 ,USAGE_QTY
4377 ,USAGE_UOM
4378 ,TRANSACTION_DATE
4379 ,SOURCE_ORG_CODE
4380 ,SYSTEM_FK
4381 ,USER_DIM1_FK
4382 ,USER_DIM2_FK
4383 ,USER_DIM3_FK
4384 ,USER_DIM4_FK
4385 ,USER_DIM5_FK
4386 ,USER_ATTR1
4387 ,USER_ATTR2
4388 ,USER_ATTR3
4389 ,USER_ATTR4
4390 ,USER_ATTR5
4391 ,USER_MEASURE1
4392 ,USER_MEASURE2
4393 ,USER_MEASURE3
4394 ,USER_MEASURE4
4395 ,USER_MEASURE5
4396 ,SUB_SEGMENT_FK
4397 ) VALUES (
4398 p_reprocess_ready_yn
4399 ,p_workorder_fk
4400 ,p_resource_fk
4401 ,p_product_fk
4402 ,p_segment_fk
4403 ,p_usage_qty
4404 ,p_usage_uom
4405 ,fnd_date.canonical_to_date(p_transaction_date)
4406 ,p_source_org_code
4407 ,p_system_fk
4408 ,p_user_dim1_fk
4409 ,p_user_dim2_fk
4410 ,p_user_dim3_fk
4411 ,p_user_dim4_fk
4412 ,p_user_dim5_fk
4413 ,p_user_attr1
4414 ,p_user_attr2
4415 ,p_user_attr3
4416 ,p_user_attr4
4417 ,p_user_attr5
4418 ,p_user_measure1
4419 ,p_user_measure2
4420 ,p_user_measure3
4421 ,p_user_measure4
4422 ,p_user_measure5
4423 ,p_sub_segment_fk
4424 );
4425
4426 END IF;
4427
4428 END UPD_RESOURCE_TXN_ERR;
4429
4430 PROCEDURE UPD_TAG_MASTER_ERR (
4431 p_err_code IN VARCHAR2,
4432 p_reprocess_ready_yn IN VARCHAR2,
4433 p_status IN VARCHAR2,
4434 p_data_type IN VARCHAR2,
4435 p_order_type IN VARCHAR2,
4436 p_reading_type IN VARCHAR2,
4437 p_initial_value IN NUMBER,
4438 p_tag_data_source_name IN VARCHAR2,
4439 p_tag_code IN VARCHAR2,
4440 p_tag_type IN NUMBER,
4441 p_plant_fk_key IN NUMBER,
4442 p_plc_identifier IN VARCHAR2,
4443 p_tag_alias IN VARCHAR2,
4444 p_equipment_fk_key IN NUMBER,
4445 p_description IN VARCHAR2,
4446 p_uom IN VARCHAR2,
4447 p_is_cumulative IN VARCHAR2,
4448 p_max_reset_value IN NUMBER,
4449 p_frequency_in_minutes IN NUMBER,
4450 p_user_attr1 IN VARCHAR2,
4451 p_user_attr2 IN VARCHAR2,
4452 p_user_attr3 IN VARCHAR2,
4453 p_user_attr4 IN VARCHAR2,
4454 p_user_attr5 IN VARCHAR2,
4455 p_reset_after_job IN VARCHAR2,
4456 p_rowid IN ROWID
4457 ) IS
4458 BEGIN
4459
4460 IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
4461
4462 FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
4466
4463 RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
4464
4465 ELSIF p_rowid IS NOT NULL THEN
4467 UPDATE MTH_TAG_MASTER_ERR SET
4468 REPROCESS_READY_YN = p_reprocess_ready_yn
4469 ,STATUS = p_status
4470 ,DATA_TYPE = p_data_type
4471 ,ORDER_TYPE = p_order_type
4472 ,READING_TYPE = p_reading_type
4473 ,INITIAL_VALUE = p_initial_value
4474 ,TAG_DATA_SOURCE_NAME = p_tag_data_source_name
4475 ,TAG_CODE = p_tag_code
4476 ,TAG_TYPE = p_tag_type
4477 ,PLANT_FK_KEY = p_plant_fk_key
4478 ,PLC_IDENTIFIER = p_plc_identifier
4479 ,TAG_ALIAS = p_tag_alias
4480 ,EQUIPMENT_FK_KEY = p_equipment_fk_key
4481 ,DESCRIPTION = p_description
4482 ,UOM = p_uom
4483 ,IS_CUMULATIVE = p_is_cumulative
4484 ,MAX_RESET_VALUE = p_max_reset_value
4485 ,FREQUENCY_IN_MINUTES = p_frequency_in_minutes
4486 ,USER_ATTR1 = p_user_attr1
4487 ,USER_ATTR2 = p_user_attr2
4488 ,USER_ATTR3 = p_user_attr3
4489 ,USER_ATTR4 = p_user_attr4
4490 ,USER_ATTR5 = p_user_attr5
4491 ,RESET_AFTER_JOB = p_reset_after_job
4492 WHERE ROWID = p_rowid;
4493
4494 ELSE
4495
4496 INSERT INTO MTH_TAG_MASTER_ERR (
4497 REPROCESS_READY_YN
4498 ,STATUS
4499 ,DATA_TYPE
4500 ,ORDER_TYPE
4501 ,READING_TYPE
4502 ,INITIAL_VALUE
4503 ,TAG_DATA_SOURCE_NAME
4504 ,TAG_CODE
4505 ,TAG_TYPE
4506 ,PLANT_FK_KEY
4507 ,PLC_IDENTIFIER
4508 ,TAG_ALIAS
4509 ,EQUIPMENT_FK_KEY
4510 ,DESCRIPTION
4511 ,UOM
4512 ,IS_CUMULATIVE
4513 ,MAX_RESET_VALUE
4514 ,FREQUENCY_IN_MINUTES
4515 ,USER_ATTR1
4516 ,USER_ATTR2
4517 ,USER_ATTR3
4518 ,USER_ATTR4
4519 ,USER_ATTR5
4520 ,RESET_AFTER_JOB
4521 ) VALUES (
4522 p_reprocess_ready_yn
4523 ,p_status
4524 ,p_data_type
4525 ,p_order_type
4526 ,p_reading_type
4527 ,p_initial_value
4528 ,p_tag_data_source_name
4529 ,p_tag_code
4530 ,p_tag_type
4531 ,p_plant_fk_key
4532 ,p_plc_identifier
4533 ,p_tag_alias
4534 ,p_equipment_fk_key
4535 ,p_description
4536 ,p_uom
4537 ,p_is_cumulative
4538 ,p_max_reset_value
4539 ,p_frequency_in_minutes
4540 ,p_user_attr1
4541 ,p_user_attr2
4542 ,p_user_attr3
4543 ,p_user_attr4
4544 ,p_user_attr5
4545 ,p_reset_after_job
4546 );
4547
4548 END IF;
4549
4550 END UPD_TAG_MASTER_ERR;
4551
4552 PROCEDURE UPD_TIME_HIERARCHY_ERR (
4553 p_err_code IN VARCHAR2,
4554 p_reprocess_ready_yn IN VARCHAR2,
4555 p_hierarchy_name IN VARCHAR2,
4556 p_child_fk IN VARCHAR2,
4557 p_parent_fk IN VARCHAR2,
4558 p_level_number_of_child IN NUMBER,
4559 p_system_fk IN VARCHAR2,
4560 p_rowid IN ROWID
4561 ) IS
4562 BEGIN
4563
4564 IF NVL(p_reprocess_ready_yn,'X') NOT IN ('D') THEN
4565
4566 FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
4567 RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
4568
4569 ELSIF p_rowid IS NOT NULL THEN
4570
4571 UPDATE MTH_TIME_HIERARCHY_ERR SET
4575 ,PARENT_FK = p_parent_fk
4572 REPROCESS_READY_YN = p_reprocess_ready_yn
4573 ,HIERARCHY_NAME = p_hierarchy_name
4574 ,CHILD_FK = p_child_fk
4576 ,LEVEL_NUMBER_OF_CHILD = p_level_number_of_child
4577 ,SYSTEM_FK = p_system_fk
4578 WHERE ROWID = p_rowid;
4579
4580 ELSE
4581
4582 RAISE_APPLICATION_ERROR(-20002, 'Reprocess not allowed.');
4583
4584 END IF;
4585
4586 END UPD_TIME_HIERARCHY_ERR;
4587
4588 PROCEDURE UPD_USER_DIM_ENTITIES_ERR (
4589 p_err_code IN VARCHAR2,
4590 p_reprocess_ready_yn IN VARCHAR2,
4591 p_dimension_name IN VARCHAR2,
4592 p_entity_pk IN VARCHAR2,
4593 p_entity_name IN VARCHAR2,
4594 p_entity_type IN VARCHAR2,
4595 p_user_attr1 IN VARCHAR2,
4596 p_user_attr2 IN VARCHAR2,
4597 p_user_attr3 IN VARCHAR2,
4598 p_user_attr4 IN VARCHAR2,
4599 p_user_attr5 IN VARCHAR2,
4600 p_user_measure1 IN NUMBER,
4601 p_user_measure2 IN NUMBER,
4602 p_user_measure3 IN NUMBER,
4603 p_user_measure4 IN NUMBER,
4604 p_user_measure5 IN NUMBER,
4608 BEGIN
4605 p_system_fk IN VARCHAR2,
4606 p_rowid IN ROWID
4607 ) IS
4609
4610 IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
4611
4612 FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
4613 RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
4614
4615 ELSIF p_rowid IS NOT NULL THEN
4616
4617 UPDATE MTH_USER_DIM_ENTITIES_ERR SET
4618 REPROCESS_READY_YN = p_reprocess_ready_yn
4619 ,DIMENSION_NAME = p_dimension_name
4620 ,ENTITY_PK = p_entity_pk
4621 ,ENTITY_NAME = p_entity_name
4622 ,ENTITY_TYPE = p_entity_type
4623 ,USER_ATTR1 = p_user_attr1
4624 ,USER_ATTR2 = p_user_attr2
4625 ,USER_ATTR3 = p_user_attr3
4626 ,USER_ATTR4 = p_user_attr4
4627 ,USER_ATTR5 = p_user_attr5
4628 ,USER_MEASURE1 = p_user_measure1
4629 ,USER_MEASURE2 = p_user_measure2
4630 ,USER_MEASURE3 = p_user_measure3
4631 ,USER_MEASURE4 = p_user_measure4
4632 ,USER_MEASURE5 = p_user_measure5
4633 ,SYSTEM_FK = p_system_fk
4634 WHERE ROWID = p_rowid;
4635
4636 ELSE
4637
4638 INSERT INTO MTH_USER_DIM_ENTITIES_ERR (
4639 REPROCESS_READY_YN
4640 ,DIMENSION_NAME
4641 ,ENTITY_PK
4642 ,ENTITY_NAME
4643 ,ENTITY_TYPE
4644 ,USER_ATTR1
4645 ,USER_ATTR2
4646 ,USER_ATTR3
4647 ,USER_ATTR4
4648 ,USER_ATTR5
4649 ,USER_MEASURE1
4650 ,USER_MEASURE2
4651 ,USER_MEASURE3
4652 ,USER_MEASURE4
4653 ,USER_MEASURE5
4654 ,SYSTEM_FK
4655 ) VALUES (
4656 p_reprocess_ready_yn
4657 ,p_dimension_name
4658 ,p_entity_pk
4659 ,p_entity_name
4660 ,p_entity_type
4661 ,p_user_attr1
4662 ,p_user_attr2
4663 ,p_user_attr3
4664 ,p_user_attr4
4665 ,p_user_attr5
4666 ,p_user_measure1
4667 ,p_user_measure2
4668 ,p_user_measure3
4669 ,p_user_measure4
4670 ,p_user_measure5
4671 ,p_system_fk
4675
4672 );
4673
4674 END IF;
4676 END UPD_USER_DIM_ENTITIES_ERR;
4677
4678 PROCEDURE UPD_USER_DIM_HIERARCHY_ERR (
4679 p_err_code IN VARCHAR2,
4680 p_reprocess_ready_yn IN VARCHAR2,
4681 p_dimension_name IN VARCHAR2,
4682 p_hierarchy_name IN VARCHAR2,
4683 p_level_num IN NUMBER,
4684 p_level_fk IN VARCHAR2,
4685 p_parent_fk IN VARCHAR2,
4686 p_system_fk IN VARCHAR2,
4687 p_rowid IN ROWID
4688 ) IS
4689 BEGIN
4690
4691 IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
4692
4693 FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
4694 RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
4695
4696 ELSIF p_rowid IS NOT NULL THEN
4697
4698 UPDATE MTH_USER_DIM_HIERARCHY_ERR SET
4699 REPROCESS_READY_YN = p_reprocess_ready_yn
4700 ,DIMENSION_NAME = p_dimension_name
4701 ,HIERARCHY_NAME = p_hierarchy_name
4702 ,LEVEL_NUM = p_level_num
4703 ,LEVEL_FK = p_level_fk
4704 ,PARENT_FK = p_parent_fk
4705 ,SYSTEM_FK = p_system_fk
4706 WHERE ROWID = p_rowid;
4707
4708 ELSE
4709
4710 INSERT INTO MTH_USER_DIM_HIERARCHY_ERR (
4711 REPROCESS_READY_YN
4712 ,DIMENSION_NAME
4713 ,HIERARCHY_NAME
4714 ,LEVEL_NUM
4715 ,LEVEL_FK
4716 ,PARENT_FK
4717 ,SYSTEM_FK
4718 ) VALUES (
4719 p_reprocess_ready_yn
4720 ,p_dimension_name
4721 ,p_hierarchy_name
4722 ,p_level_num
4723 ,p_level_fk
4724 ,p_parent_fk
4725 ,p_system_fk
4726 );
4727
4728 END IF;
4729
4730 END UPD_USER_DIM_HIERARCHY_ERR;
4731
4732 PROCEDURE UPD_WEEK_ERR (
4733 p_err_code IN VARCHAR2,
4734 p_reprocess_ready_yn IN VARCHAR2,
4735 p_hierarchy_name IN VARCHAR2,
4736 p_name IN VARCHAR2,
4737 p_user_attr1 IN VARCHAR2,
4738 p_user_attr2 IN VARCHAR2,
4739 p_user_attr3 IN VARCHAR2,
4740 p_user_attr4 IN VARCHAR2,
4741 p_user_attr5 IN VARCHAR2,
4742 p_user_measure1 IN NUMBER,
4743 p_user_measure2 IN NUMBER,
4744 p_user_measure3 IN NUMBER,
4745 p_user_measure4 IN NUMBER,
4746 p_user_measure5 IN NUMBER,
4747 p_system_fk IN VARCHAR2,
4748 p_end_date IN VARCHAR2,
4749 p_start_date IN VARCHAR2,
4750 p_rowid IN ROWID
4751 ) IS
4752 BEGIN
4753
4754 IF NVL(p_reprocess_ready_yn,'X') NOT IN ('D') THEN
4755
4756 FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
4757 RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
4758
4759 ELSIF p_rowid IS NOT NULL THEN
4760
4761 UPDATE MTH_WEEK_ERR SET
4762 REPROCESS_READY_YN = p_reprocess_ready_yn
4763 ,HIERARCHY_NAME = p_hierarchy_name
4764 ,NAME = p_name
4765 ,USER_ATTR1 = p_user_attr1
4766 ,USER_ATTR2 = p_user_attr2
4767 ,USER_ATTR3 = p_user_attr3
4768 ,USER_ATTR4 = p_user_attr4
4769 ,USER_ATTR5 = p_user_attr5
4770 ,USER_MEASURE1 = p_user_measure1
4771 ,USER_MEASURE2 = p_user_measure2
4772 ,USER_MEASURE3 = p_user_measure3
4773 ,USER_MEASURE4 = p_user_measure4
4774 ,USER_MEASURE5 = p_user_measure5
4775 ,SYSTEM_FK = p_system_fk
4776 ,END_DATE = fnd_date.canonical_to_date(p_end_date)
4777 ,START_DATE = fnd_date.canonical_to_date(p_start_date)
4778 WHERE ROWID = p_rowid;
4779
4780 ELSE
4781
4782 RAISE_APPLICATION_ERROR(-20002, 'Reprocess not allowed.');
4783
4784 END IF;
4785
4786 END UPD_WEEK_ERR;
4787
4788 PROCEDURE UPD_WORKDAY_SHIFTS_ERR (
4789 p_err_code IN VARCHAR2,
4790 p_reprocess_ready_yn IN VARCHAR2,
4791 p_shift_date IN VARCHAR2,
4792 p_source_org_code IN VARCHAR2,
4793 p_user_attr1 IN VARCHAR2,
4794 p_user_attr2 IN VARCHAR2,
4795 p_user_attr3 IN VARCHAR2,
4796 p_user_attr4 IN VARCHAR2,
4800 p_user_measure3 IN NUMBER,
4797 p_user_attr5 IN VARCHAR2,
4798 p_user_measure1 IN NUMBER,
4799 p_user_measure2 IN NUMBER,
4801 p_user_measure4 IN NUMBER,
4802 p_user_measure5 IN NUMBER,
4803 p_shift_workday_pk IN VARCHAR2,
4804 p_system_fk IN VARCHAR2,
4805 p_from_date IN VARCHAR2,
4806 p_to_date IN VARCHAR2,
4807 p_shift_num IN NUMBER,
4808 p_shift_name IN VARCHAR2,
4809 p_shift_type IN VARCHAR2,
4810 p_graveyard_shift IN VARCHAR2,
4811 p_rowid IN ROWID
4812 ) IS
4813 BEGIN
4814
4815 IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
4816
4817 FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
4818 RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
4819
4820 ELSIF p_rowid IS NOT NULL THEN
4821
4822 UPDATE MTH_WORKDAY_SHIFTS_ERR SET
4823 REPROCESS_READY_YN = p_reprocess_ready_yn
4824 ,SHIFT_DATE = fnd_date.canonical_to_date(p_shift_date)
4825 ,SOURCE_ORG_CODE = p_source_org_code
4826 ,USER_ATTR1 = p_user_attr1
4827 ,USER_ATTR2 = p_user_attr2
4828 ,USER_ATTR3 = p_user_attr3
4829 ,USER_ATTR4 = p_user_attr4
4830 ,USER_ATTR5 = p_user_attr5
4831 ,USER_MEASURE1 = p_user_measure1
4832 ,USER_MEASURE2 = p_user_measure2
4833 ,USER_MEASURE3 = p_user_measure3
4834 ,USER_MEASURE4 = p_user_measure4
4835 ,USER_MEASURE5 = p_user_measure5
4836 ,SHIFT_WORKDAY_PK = p_shift_workday_pk
4837 ,SYSTEM_FK = p_system_fk
4838 ,FROM_DATE = fnd_date.canonical_to_date(p_from_date)
4839 ,TO_DATE = fnd_date.canonical_to_date(p_to_date)
4840 ,SHIFT_NUM = p_shift_num
4841 ,SHIFT_NAME = p_shift_name
4842 ,SHIFT_TYPE = p_shift_type
4843 ,GRAVEYARD_SHIFT = p_graveyard_shift
4844 WHERE ROWID = p_rowid;
4845
4846 ELSE
4847
4848 INSERT INTO MTH_WORKDAY_SHIFTS_ERR (
4849 REPROCESS_READY_YN
4850 ,SHIFT_DATE
4851 ,SOURCE_ORG_CODE
4852 ,USER_ATTR1
4853 ,USER_ATTR2
4854 ,USER_ATTR3
4855 ,USER_ATTR4
4856 ,USER_ATTR5
4857 ,USER_MEASURE1
4858 ,USER_MEASURE2
4859 ,USER_MEASURE3
4860 ,USER_MEASURE4
4861 ,USER_MEASURE5
4862 ,SHIFT_WORKDAY_PK
4863 ,SYSTEM_FK
4864 ,FROM_DATE
4865 ,TO_DATE
4866 ,SHIFT_NUM
4867 ,SHIFT_NAME
4868 ,SHIFT_TYPE
4869 ,GRAVEYARD_SHIFT
4870 ) VALUES (
4871 p_reprocess_ready_yn
4872 ,fnd_date.canonical_to_date(p_shift_date)
4873 ,p_source_org_code
4874 ,p_user_attr1
4875 ,p_user_attr2
4876 ,p_user_attr3
4877 ,p_user_attr4
4878 ,p_user_attr5
4879 ,p_user_measure1
4880 ,p_user_measure2
4881 ,p_user_measure3
4882 ,p_user_measure4
4883 ,p_user_measure5
4884 ,p_shift_workday_pk
4885 ,p_system_fk
4886 ,fnd_date.canonical_to_date(p_from_date)
4887 ,fnd_date.canonical_to_date(p_to_date)
4888 ,p_shift_num
4889 ,p_shift_name
4890 ,p_shift_type
4891 ,p_graveyard_shift
4892 );
4893
4894 END IF;
4895
4896 END UPD_WORKDAY_SHIFTS_ERR;
4897
4898 PROCEDURE UPD_WO_SALES_ORDERS_ERR (
4899 p_err_code IN VARCHAR2,
4900 p_reprocess_ready_yn IN VARCHAR2,
4901 p_workorder_fk IN VARCHAR2,
4902 p_salesorder_number IN VARCHAR2,
4903 p_salesorder_lnumber IN VARCHAR2,
4904 p_customer IN VARCHAR2,
4905 p_requested_date IN VARCHAR2,
4906 p_promised_date IN VARCHAR2,
4907 p_scheduled_ship_date IN VARCHAR2,
4908 p_system_fk IN VARCHAR2,
4909 p_quantity_g IN NUMBER,
4910 p_primary_uom IN VARCHAR2,
4911 p_product_fk IN VARCHAR2,
4912 p_user_dim1_fk IN VARCHAR2,
4913 p_user_dim2_fk IN VARCHAR2,
4917 p_user_attr1 IN VARCHAR2,
4914 p_user_dim3_fk IN VARCHAR2,
4915 p_user_dim4_fk IN VARCHAR2,
4916 p_user_dim5_fk IN VARCHAR2,
4918 p_user_attr2 IN VARCHAR2,
4919 p_user_attr3 IN VARCHAR2,
4920 p_user_attr4 IN VARCHAR2,
4921 p_user_attr5 IN VARCHAR2,
4922 p_user_measure1 IN NUMBER,
4923 p_user_measure2 IN NUMBER,
4924 p_user_measure3 IN NUMBER,
4925 p_user_measure4 IN NUMBER,
4926 p_user_measure5 IN NUMBER,
4927 p_reservation_pk IN VARCHAR2,
4928 p_rowid IN ROWID
4929 ) IS
4930 BEGIN
4931
4932 IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
4933
4934 FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
4935 RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
4936
4937 ELSIF p_rowid IS NOT NULL THEN
4938
4939 UPDATE MTH_WO_SALES_ORDERS_ERR SET
4940 REPROCESS_READY_YN = p_reprocess_ready_yn
4941 ,WORKORDER_FK = p_workorder_fk
4942 ,SALESORDER_NUMBER = p_salesorder_number
4943 ,SALESORDER_LNUMBER = p_salesorder_lnumber
4944 ,CUSTOMER = p_customer
4945 ,REQUESTED_DATE = fnd_date.canonical_to_date(p_requested_date)
4946 ,PROMISED_DATE = fnd_date.canonical_to_date(p_promised_date)
4947 ,SCHEDULED_SHIP_DATE = fnd_date.canonical_to_date(p_scheduled_ship_date)
4948 ,SYSTEM_FK = p_system_fk
4949 ,QUANTITY_G = p_quantity_g
4950 ,PRIMARY_UOM = p_primary_uom
4951 ,PRODUCT_FK = p_product_fk
4952 ,USER_DIM1_FK = p_user_dim1_fk
4953 ,USER_DIM2_FK = p_user_dim2_fk
4954 ,USER_DIM3_FK = p_user_dim3_fk
4955 ,USER_DIM4_FK = p_user_dim4_fk
4956 ,USER_DIM5_FK = p_user_dim5_fk
4957 ,USER_ATTR1 = p_user_attr1
4958 ,USER_ATTR2 = p_user_attr2
4959 ,USER_ATTR3 = p_user_attr3
4960 ,USER_ATTR4 = p_user_attr4
4961 ,USER_ATTR5 = p_user_attr5
4962 ,USER_MEASURE1 = p_user_measure1
4963 ,USER_MEASURE2 = p_user_measure2
4964 ,USER_MEASURE3 = p_user_measure3
4965 ,USER_MEASURE4 = p_user_measure4
4966 ,USER_MEASURE5 = p_user_measure5
4967 ,RESERVATION_PK = p_reservation_pk
4968 WHERE ROWID = p_rowid;
4969
4970 ELSE
4971
4972 INSERT INTO MTH_WO_SALES_ORDERS_ERR (
4973 REPROCESS_READY_YN
4974 ,WORKORDER_FK
4975 ,SALESORDER_NUMBER
4976 ,SALESORDER_LNUMBER
4977 ,CUSTOMER
4978 ,REQUESTED_DATE
4979 ,PROMISED_DATE
4980 ,SCHEDULED_SHIP_DATE
4981 ,SYSTEM_FK
4982 ,QUANTITY_G
4983 ,PRIMARY_UOM
4984 ,PRODUCT_FK
4985 ,USER_DIM1_FK
4986 ,USER_DIM2_FK
4987 ,USER_DIM3_FK
4988 ,USER_DIM4_FK
4989 ,USER_DIM5_FK
4990 ,USER_ATTR1
4991 ,USER_ATTR2
4992 ,USER_ATTR3
4993 ,USER_ATTR4
4994 ,USER_ATTR5
4995 ,USER_MEASURE1
4996 ,USER_MEASURE2
4997 ,USER_MEASURE3
4998 ,USER_MEASURE4
4999 ,USER_MEASURE5
5000 ,RESERVATION_PK
5001 ) VALUES (
5002 p_reprocess_ready_yn
5003 ,p_workorder_fk
5004 ,p_salesorder_number
5005 ,p_salesorder_lnumber
5006 ,p_customer
5007 ,fnd_date.canonical_to_date(p_requested_date)
5008 ,fnd_date.canonical_to_date(p_promised_date)
5009 ,fnd_date.canonical_to_date(p_scheduled_ship_date)
5010 ,p_system_fk
5011 ,p_quantity_g
5012 ,p_primary_uom
5013 ,p_product_fk
5014 ,p_user_dim1_fk
5015 ,p_user_dim2_fk
5016 ,p_user_dim3_fk
5020 ,p_user_attr2
5017 ,p_user_dim4_fk
5018 ,p_user_dim5_fk
5019 ,p_user_attr1
5021 ,p_user_attr3
5022 ,p_user_attr4
5023 ,p_user_attr5
5024 ,p_user_measure1
5025 ,p_user_measure2
5026 ,p_user_measure3
5027 ,p_user_measure4
5028 ,p_user_measure5
5029 ,p_reservation_pk
5030 );
5031
5032 END IF;
5033
5034 END UPD_WO_SALES_ORDERS_ERR;
5035
5036 PROCEDURE UPD_YEAR_ERR (
5037 p_err_code IN VARCHAR2,
5038 p_reprocess_ready_yn IN VARCHAR2,
5039 p_hierarchy_name IN VARCHAR2,
5040 p_name IN VARCHAR2,
5041 p_user_attr1 IN VARCHAR2,
5042 p_user_attr2 IN VARCHAR2,
5043 p_user_attr3 IN VARCHAR2,
5044 p_user_attr4 IN VARCHAR2,
5045 p_user_attr5 IN VARCHAR2,
5046 p_user_measure1 IN NUMBER,
5047 p_user_measure2 IN NUMBER,
5048 p_user_measure3 IN NUMBER,
5049 p_user_measure4 IN NUMBER,
5050 p_user_measure5 IN NUMBER,
5051 p_system_fk IN VARCHAR2,
5052 p_end_date IN VARCHAR2,
5053 p_start_date IN VARCHAR2,
5054 p_rowid IN ROWID
5055 ) IS
5056 BEGIN
5057
5058 IF NVL(p_reprocess_ready_yn,'X') NOT IN ('D') THEN
5059
5060 FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
5061 RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
5062
5063 ELSIF p_rowid IS NOT NULL THEN
5064
5065 UPDATE MTH_YEAR_ERR SET
5066 REPROCESS_READY_YN = p_reprocess_ready_yn
5067 ,HIERARCHY_NAME = p_hierarchy_name
5068 ,NAME = p_name
5069 ,USER_ATTR1 = p_user_attr1
5070 ,USER_ATTR2 = p_user_attr2
5071 ,USER_ATTR3 = p_user_attr3
5072 ,USER_ATTR4 = p_user_attr4
5073 ,USER_ATTR5 = p_user_attr5
5074 ,USER_MEASURE1 = p_user_measure1
5075 ,USER_MEASURE2 = p_user_measure2
5076 ,USER_MEASURE3 = p_user_measure3
5077 ,USER_MEASURE4 = p_user_measure4
5078 ,USER_MEASURE5 = p_user_measure5
5079 ,SYSTEM_FK = p_system_fk
5080 ,END_DATE = fnd_date.canonical_to_date(p_end_date)
5081 ,START_DATE = fnd_date.canonical_to_date(p_start_date)
5082 WHERE ROWID = p_rowid;
5083
5084 ELSE
5085
5086 RAISE_APPLICATION_ERROR(-20002, 'Reprocess not allowed.');
5087
5088 END IF;
5089
5090 END UPD_YEAR_ERR;
5091
5092 END MTH_UPDATE_ERR_PKG;