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

APPS.GME_RESCHEDULE_STEP_PVT dependencies on GME_COMMON_PVT

Line 50: l_material_detail_id_tbl gme_common_pvt.number_tab;

46: l_batch_header_rec gme_batch_header%ROWTYPE;
47: l_batch_header2_rec gme_batch_header%ROWTYPE;
48: l_batch_step_rec gme_batch_steps%ROWTYPE;
49: l_batch_step_m_rec gme_batch_steps%ROWTYPE;
50: l_material_detail_id_tbl gme_common_pvt.number_tab;
51: l_rel_type NUMBER;
52: l_contig_period_tbl gmp_calendar_api.contig_period_tbl;
53: l_loop_count_get_material NUMBER;
54: --Bug#5606089

Line 200: l_calendar_code := gme_common_pvt.g_calendar_code;

196: RAISE invalid_step_status;
197: END IF;
198:
199: l_batch_header_rec.batch_id := x_batch_step_rec.batch_id;
200: l_calendar_code := gme_common_pvt.g_calendar_code;
201:
202: /* Initialize local batch header */
203: IF NOT (gme_batch_header_dbl.fetch_row (l_batch_header_rec
204: ,l_batch_header_rec) ) THEN

Line 308: ,last_updated_by = gme_common_pvt.g_user_ident

304: END IF;
305: --Bug#4543875 (port 4416699) Update the changed step due date in the procedure calc_dates with the original due date
306: UPDATE gme_batch_steps
307: SET due_date = p_batch_step_rec.due_date
308: ,last_updated_by = gme_common_pvt.g_user_ident
309: ,last_update_date = gme_common_pvt.g_timestamp
310: ,last_update_login = gme_common_pvt.g_login_id
311: WHERE batch_id = p_batch_step_rec.batch_id
312: AND batchstep_id = p_batch_step_rec.batchstep_id;

Line 309: ,last_update_date = gme_common_pvt.g_timestamp

305: --Bug#4543875 (port 4416699) Update the changed step due date in the procedure calc_dates with the original due date
306: UPDATE gme_batch_steps
307: SET due_date = p_batch_step_rec.due_date
308: ,last_updated_by = gme_common_pvt.g_user_ident
309: ,last_update_date = gme_common_pvt.g_timestamp
310: ,last_update_login = gme_common_pvt.g_login_id
311: WHERE batch_id = p_batch_step_rec.batch_id
312: AND batchstep_id = p_batch_step_rec.batchstep_id;
313: --Bug#4543875

Line 310: ,last_update_login = gme_common_pvt.g_login_id

306: UPDATE gme_batch_steps
307: SET due_date = p_batch_step_rec.due_date
308: ,last_updated_by = gme_common_pvt.g_user_ident
309: ,last_update_date = gme_common_pvt.g_timestamp
310: ,last_update_login = gme_common_pvt.g_login_id
311: WHERE batch_id = p_batch_step_rec.batch_id
312: AND batchstep_id = p_batch_step_rec.batchstep_id;
313: --Bug#4543875
314:

Line 390: AND l_dep_step_rec.step_status <> gme_common_pvt.g_step_wip THEN

386: END LOOP;
387: END IF;
388:
389: IF l_found = FALSE
390: AND l_dep_step_rec.step_status <> gme_common_pvt.g_step_wip THEN
391: /* Continue only if the succeeding step is not the same as the step which initiated the reschedule and is not WIP */
392: l_batch_step_rec.batchstep_id :=
393: l_dep_step_rec.batchstep_id;
394: l_batch_step_rec.batch_id := p_batch_step_rec.batch_id;

Line 489: AND l_dep_step_rec.step_status <> gme_common_pvt.g_step_wip THEN

485: END LOOP;
486: END IF;
487:
488: IF l_found = FALSE
489: AND l_dep_step_rec.step_status <> gme_common_pvt.g_step_wip THEN
490: /* Continue only if the preceeding step is not the same as the step which initiated the reschedule and is not WIP */
491: l_batch_step_rec.batchstep_id :=
492: l_dep_step_rec.batchstep_id;
493: l_batch_step_rec.batch_id := p_batch_step_rec.batch_id;

Line 746: IF NOT gme_common_pvt.check_validity_rule_dates

742:
743: --Bug#5365527 added the validity rule check for LCF Batches
744: IF l_batch_header2_rec.recipe_validity_rule_id IS NOT NULL THEN
745: -- Checking of batch dates with validity rules dates after teh reschedule
746: IF NOT gme_common_pvt.check_validity_rule_dates
747: (l_batch_header2_rec.recipe_validity_rule_id
748: ,l_batch_header2_rec.plan_start_date
749: ,l_batch_header2_rec.plan_cmplt_date) THEN
750: x_return_status := fnd_api.g_ret_sts_error;

Line 786: gme_common_pvt.is_material_auto_release

782:
783: FOR i IN 1 .. l_loop_count_get_material LOOP
784: -- stamp manual and incremental with step dates as well...
785: l_rel_type :=
786: gme_common_pvt.is_material_auto_release
787: (l_material_detail_id_tbl (i) );
788: --Bug#5606089 Start. Added the following code.
789: /* SELECT batchstep_id INTO l_batch_step2_rec.batchstep_id FROM GME_BATCH_STEP_ITEMS
790: WHERE material_detail_id = l_material_detail_id_tbl(i);

Line 799: IF ( gme_common_pvt.is_material_assoc_to_step (l_material_detail_id_tbl (i) ) = TRUE

795: END IF;*/
796: --Bug#5606089 End.
797:
798: -- Modified the if condition.
799: IF ( gme_common_pvt.is_material_assoc_to_step (l_material_detail_id_tbl (i) ) = TRUE
800: AND
801: l_rel_type IN
802: (gme_common_pvt.g_mtl_manual_release
803: ,gme_common_pvt.g_mtl_incremental_release

Line 802: (gme_common_pvt.g_mtl_manual_release

798: -- Modified the if condition.
799: IF ( gme_common_pvt.is_material_assoc_to_step (l_material_detail_id_tbl (i) ) = TRUE
800: AND
801: l_rel_type IN
802: (gme_common_pvt.g_mtl_manual_release
803: ,gme_common_pvt.g_mtl_incremental_release
804: ,gme_common_pvt.g_mtl_autobystep_release)) THEN
805:
806: -- pawan kumar start bug 5929323 -- moved the fetch of batchstep_id only when step is assoc

Line 803: ,gme_common_pvt.g_mtl_incremental_release

799: IF ( gme_common_pvt.is_material_assoc_to_step (l_material_detail_id_tbl (i) ) = TRUE
800: AND
801: l_rel_type IN
802: (gme_common_pvt.g_mtl_manual_release
803: ,gme_common_pvt.g_mtl_incremental_release
804: ,gme_common_pvt.g_mtl_autobystep_release)) THEN
805:
806: -- pawan kumar start bug 5929323 -- moved the fetch of batchstep_id only when step is assoc
807:

Line 804: ,gme_common_pvt.g_mtl_autobystep_release)) THEN

800: AND
801: l_rel_type IN
802: (gme_common_pvt.g_mtl_manual_release
803: ,gme_common_pvt.g_mtl_incremental_release
804: ,gme_common_pvt.g_mtl_autobystep_release)) THEN
805:
806: -- pawan kumar start bug 5929323 -- moved the fetch of batchstep_id only when step is assoc
807:
808: SELECT batchstep_id INTO l_batch_step2_rec.batchstep_id FROM GME_BATCH_STEP_ITEMS

Line 818: IF l_line_type_tbl (i) = gme_common_pvt.g_line_type_ing THEN

814: END IF;
815: -- pawan kumar end bug 5929323
816:
817:
818: IF l_line_type_tbl (i) = gme_common_pvt.g_line_type_ing THEN
819: -- Update the material_required_date with the associated plan_start_Date;
820: --Bug#5606089
821: l_material_date := x_batch_step2_rec.plan_start_date;
822: --l_material_date := x_batch_step_rec.plan_start_date;

Line 837: gme_common_pvt.material_date_change

833: || ' Material_detail_id : '
834: || l_material_detail_id_tbl (i)
835: || 'for date'||l_material_date );
836: END IF;
837: gme_common_pvt.material_date_change
838: (p_material_detail_id => l_material_detail_id_tbl
839: (i)
840: ,p_material_date => l_material_date
841: ,x_return_status => l_return_status);

Line 863: IF l_line_type_tbl (i) = gme_common_pvt.g_line_type_ing THEN

859:
860: ELSE
861: gme_debug.put_line('3');
862: -- Navin Added as part of Reschedule Batch/Step Build.
863: IF l_line_type_tbl (i) = gme_common_pvt.g_line_type_ing THEN
864: -- Update the material_required_date with the associated plan_start_Date;
865: l_material_date := l_batch_header_rec.plan_start_date;
866: ELSE
867: -- Update the material required date with the associated plan cmplt Date;

Line 880: gme_common_pvt.material_date_change

876: || l_material_detail_id_tbl (i)
877: || 'for date'||l_material_date );
878: END IF;
879:
880: gme_common_pvt.material_date_change
881: (p_material_detail_id => l_material_detail_id_tbl
882: (i)
883: ,p_material_date => l_material_date
884: ,x_return_status => l_return_status);

Line 921: gme_common_pvt.log_message('GME_EXPIRED_RESERV_MO_DELETED');

917:
918: --FPBug#4585491 Begin
919: IF (l_B_count > 0) OR (l_R_count > 0 AND l_M_count > 0) THEN
920: --atleast for one material line MO allocations and reservations are deleted
921: gme_common_pvt.log_message('GME_EXPIRED_RESERV_MO_DELETED');
922: ELSIF l_R_count > 0 THEN
923: ----atleast for one material line reservations are deleted
924: gme_common_pvt.log_message('GME_EXPIRED_RESERV_DELETED');
925: ELSIF l_M_count > 0 THEN

Line 924: gme_common_pvt.log_message('GME_EXPIRED_RESERV_DELETED');

920: --atleast for one material line MO allocations and reservations are deleted
921: gme_common_pvt.log_message('GME_EXPIRED_RESERV_MO_DELETED');
922: ELSIF l_R_count > 0 THEN
923: ----atleast for one material line reservations are deleted
924: gme_common_pvt.log_message('GME_EXPIRED_RESERV_DELETED');
925: ELSIF l_M_count > 0 THEN
926: ----atleast for one material line MO allocations are deleted
927: gme_common_pvt.log_message('GME_EXPIRED_MO_DELETED');
928: END IF;

Line 927: gme_common_pvt.log_message('GME_EXPIRED_MO_DELETED');

923: ----atleast for one material line reservations are deleted
924: gme_common_pvt.log_message('GME_EXPIRED_RESERV_DELETED');
925: ELSIF l_M_count > 0 THEN
926: ----atleast for one material line MO allocations are deleted
927: gme_common_pvt.log_message('GME_EXPIRED_MO_DELETED');
928: END IF;
929: x_return_status := fnd_api.g_ret_sts_success;
930: --FPBug#4585491 End
931:

Line 993: gme_common_pvt.log_message ('GME_API_BATCH_STEP_FETCH_ERR');

989: END IF;
990: EXCEPTION
991: WHEN batch_step_fetch_error THEN
992: x_return_status := fnd_api.g_ret_sts_error;
993: gme_common_pvt.log_message ('GME_API_BATCH_STEP_FETCH_ERR');
994: WHEN no_dates_passed THEN
995: x_return_status := fnd_api.g_ret_sts_error;
996: gme_common_pvt.log_message ('GME_API_RESCH_STEP_NO_DATES');
997: WHEN no_date_change THEN

Line 996: gme_common_pvt.log_message ('GME_API_RESCH_STEP_NO_DATES');

992: x_return_status := fnd_api.g_ret_sts_error;
993: gme_common_pvt.log_message ('GME_API_BATCH_STEP_FETCH_ERR');
994: WHEN no_dates_passed THEN
995: x_return_status := fnd_api.g_ret_sts_error;
996: gme_common_pvt.log_message ('GME_API_RESCH_STEP_NO_DATES');
997: WHEN no_date_change THEN
998: x_return_status := fnd_api.g_ret_sts_error;
999: gme_common_pvt.log_message ('GME_API_RESCH_STEP_NO_DATE_CHG');
1000: WHEN invalid_step_status THEN

Line 999: gme_common_pvt.log_message ('GME_API_RESCH_STEP_NO_DATE_CHG');

995: x_return_status := fnd_api.g_ret_sts_error;
996: gme_common_pvt.log_message ('GME_API_RESCH_STEP_NO_DATES');
997: WHEN no_date_change THEN
998: x_return_status := fnd_api.g_ret_sts_error;
999: gme_common_pvt.log_message ('GME_API_RESCH_STEP_NO_DATE_CHG');
1000: WHEN invalid_step_status THEN
1001: x_return_status := fnd_api.g_ret_sts_error;
1002: gme_common_pvt.log_message ('GME_API_INV_STEP_STAT_RESCH');
1003: WHEN invalid_schedule_status THEN

Line 1002: gme_common_pvt.log_message ('GME_API_INV_STEP_STAT_RESCH');

998: x_return_status := fnd_api.g_ret_sts_error;
999: gme_common_pvt.log_message ('GME_API_RESCH_STEP_NO_DATE_CHG');
1000: WHEN invalid_step_status THEN
1001: x_return_status := fnd_api.g_ret_sts_error;
1002: gme_common_pvt.log_message ('GME_API_INV_STEP_STAT_RESCH');
1003: WHEN invalid_schedule_status THEN
1004: x_return_status := fnd_api.g_ret_sts_error;
1005: gme_common_pvt.log_message ('GME_API_INV_STEP_RESCH');
1006: WHEN date_overlap_error THEN

Line 1005: gme_common_pvt.log_message ('GME_API_INV_STEP_RESCH');

1001: x_return_status := fnd_api.g_ret_sts_error;
1002: gme_common_pvt.log_message ('GME_API_INV_STEP_STAT_RESCH');
1003: WHEN invalid_schedule_status THEN
1004: x_return_status := fnd_api.g_ret_sts_error;
1005: gme_common_pvt.log_message ('GME_API_INV_STEP_RESCH');
1006: WHEN date_overlap_error THEN
1007: x_return_status := fnd_api.g_ret_sts_error;
1008: gme_common_pvt.log_message ('GME_STEP_OVERLAP_ERROR');
1009: WHEN batch_header_fetch_error THEN

Line 1008: gme_common_pvt.log_message ('GME_STEP_OVERLAP_ERROR');

1004: x_return_status := fnd_api.g_ret_sts_error;
1005: gme_common_pvt.log_message ('GME_API_INV_STEP_RESCH');
1006: WHEN date_overlap_error THEN
1007: x_return_status := fnd_api.g_ret_sts_error;
1008: gme_common_pvt.log_message ('GME_STEP_OVERLAP_ERROR');
1009: WHEN batch_header_fetch_error THEN
1010: x_return_status := fnd_api.g_ret_sts_error;
1011: gme_common_pvt.log_message ('GME_API_BATCH_FETCH_ERROR');
1012: WHEN date_exceed_validity_rule THEN

Line 1011: gme_common_pvt.log_message ('GME_API_BATCH_FETCH_ERROR');

1007: x_return_status := fnd_api.g_ret_sts_error;
1008: gme_common_pvt.log_message ('GME_STEP_OVERLAP_ERROR');
1009: WHEN batch_header_fetch_error THEN
1010: x_return_status := fnd_api.g_ret_sts_error;
1011: gme_common_pvt.log_message ('GME_API_BATCH_FETCH_ERROR');
1012: WHEN date_exceed_validity_rule THEN
1013: x_return_status := fnd_api.g_ret_sts_error;
1014: WHEN step_start_date_low THEN
1015: x_return_status := fnd_api.g_ret_sts_error;

Line 1016: gme_common_pvt.log_message ('GME_ESD_PLAN_DATE');

1012: WHEN date_exceed_validity_rule THEN
1013: x_return_status := fnd_api.g_ret_sts_error;
1014: WHEN step_start_date_low THEN
1015: x_return_status := fnd_api.g_ret_sts_error;
1016: gme_common_pvt.log_message ('GME_ESD_PLAN_DATE');
1017: WHEN error_cont_period THEN
1018: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1019: gme_debug.put_line ('Contiguity period ... _failed');
1020: END IF;

Line 1028: gme_common_pvt.log_message ('GME_NON_CONTIGUOUS_TIME');

1024: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1025: gme_debug.put_line ('Contiguity period ... not found');
1026: END IF;
1027:
1028: gme_common_pvt.log_message ('GME_NON_CONTIGUOUS_TIME');
1029: x_return_status := 'C';
1030: WHEN save_data_error OR mtl_dt_chg_error THEN
1031: x_return_status := l_return_status;
1032: WHEN child_step_resch_error THEN

Line 1078: l_material_detail_id_tbl gme_common_pvt.number_tab;

1074: ,p_end_date IN DATE
1075: ,x_return_status OUT NOCOPY VARCHAR2)
1076: IS
1077: l_api_name CONSTANT VARCHAR2 (30) := 'SAVE_ALL_DATA';
1078: l_material_detail_id_tbl gme_common_pvt.number_tab;
1079: l_phantom_ids gme_common_pvt.number_tab;
1080: l_return_status VARCHAR2 (1);
1081: l_batch_header_rec gme_batch_header%ROWTYPE;
1082: l_in_batch_header_rec gme_batch_header%ROWTYPE;

Line 1079: l_phantom_ids gme_common_pvt.number_tab;

1075: ,x_return_status OUT NOCOPY VARCHAR2)
1076: IS
1077: l_api_name CONSTANT VARCHAR2 (30) := 'SAVE_ALL_DATA';
1078: l_material_detail_id_tbl gme_common_pvt.number_tab;
1079: l_phantom_ids gme_common_pvt.number_tab;
1080: l_return_status VARCHAR2 (1);
1081: l_batch_header_rec gme_batch_header%ROWTYPE;
1082: l_in_batch_header_rec gme_batch_header%ROWTYPE;
1083: x_batch_header_rec gme_batch_header%ROWTYPE;

Line 1142: IF l_line_type_tbl (i) = gme_common_pvt.g_line_type_ing THEN

1138: CLOSE cur_get_material;
1139:
1140: FOR i IN 1 .. l_loop_count_get_material LOOP
1141: -- Navin Added as part of Reschedule Batch/Step Build.
1142: IF l_line_type_tbl (i) = gme_common_pvt.g_line_type_ing THEN
1143: -- Update the material_required_date with the associated plan_start_Date;
1144: l_material_date := p_start_date;
1145: ELSE
1146: -- Update the material required date with the associated plan cmplt Date;

Line 1158: gme_common_pvt.material_date_change

1154: || ' Material_detail_id : '
1155: || l_material_detail_id_tbl (i) );
1156: END IF;
1157:
1158: gme_common_pvt.material_date_change
1159: (p_material_detail_id => l_material_detail_id_tbl
1160: (i)
1161: ,p_material_date => l_material_date
1162: ,x_return_status => l_return_status);

Line 1199: gme_common_pvt.log_message('GME_EXPIRED_RESERV_MO_DELETED');

1195:
1196: --FPBug#4585491 Begin
1197: IF (l_B_count > 0) OR (l_R_count > 0 AND l_M_count > 0) THEN
1198: --atleast for one material line MO allocations and reservations are deleted
1199: gme_common_pvt.log_message('GME_EXPIRED_RESERV_MO_DELETED');
1200: ELSIF l_R_count > 0 THEN
1201: ----atleast for one material line reservations are deleted
1202: gme_common_pvt.log_message('GME_EXPIRED_RESERV_DELETED');
1203: ELSIF l_M_count > 0 THEN

Line 1202: gme_common_pvt.log_message('GME_EXPIRED_RESERV_DELETED');

1198: --atleast for one material line MO allocations and reservations are deleted
1199: gme_common_pvt.log_message('GME_EXPIRED_RESERV_MO_DELETED');
1200: ELSIF l_R_count > 0 THEN
1201: ----atleast for one material line reservations are deleted
1202: gme_common_pvt.log_message('GME_EXPIRED_RESERV_DELETED');
1203: ELSIF l_M_count > 0 THEN
1204: ----atleast for one material line MO allocations are deleted
1205: gme_common_pvt.log_message('GME_EXPIRED_MO_DELETED');
1206: END IF;

Line 1205: gme_common_pvt.log_message('GME_EXPIRED_MO_DELETED');

1201: ----atleast for one material line reservations are deleted
1202: gme_common_pvt.log_message('GME_EXPIRED_RESERV_DELETED');
1203: ELSIF l_M_count > 0 THEN
1204: ----atleast for one material line MO allocations are deleted
1205: gme_common_pvt.log_message('GME_EXPIRED_MO_DELETED');
1206: END IF;
1207: x_return_status := fnd_api.g_ret_sts_success;
1208: --FPBug#4585491 End
1209: