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 48: l_material_detail_id_tbl gme_common_pvt.number_tab;

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

Line 194: l_calendar_code := gme_common_pvt.g_calendar_code;

190: RAISE invalid_step_status;
191: END IF;
192:
193: l_batch_header_rec.batch_id := x_batch_step_rec.batch_id;
194: l_calendar_code := gme_common_pvt.g_calendar_code;
195:
196: /* Initialize local batch header */
197: IF NOT (gme_batch_header_dbl.fetch_row (l_batch_header_rec
198: ,l_batch_header_rec) ) THEN

Line 302: ,last_updated_by = gme_common_pvt.g_user_ident

298: END IF;
299: --Bug#4543875 (port 4416699) Update the changed step due date in the procedure calc_dates with the original due date
300: UPDATE gme_batch_steps
301: SET due_date = p_batch_step_rec.due_date
302: ,last_updated_by = gme_common_pvt.g_user_ident
303: ,last_update_date = gme_common_pvt.g_timestamp
304: ,last_update_login = gme_common_pvt.g_login_id
305: WHERE batch_id = p_batch_step_rec.batch_id
306: AND batchstep_id = p_batch_step_rec.batchstep_id;

Line 303: ,last_update_date = gme_common_pvt.g_timestamp

299: --Bug#4543875 (port 4416699) Update the changed step due date in the procedure calc_dates with the original due date
300: UPDATE gme_batch_steps
301: SET due_date = p_batch_step_rec.due_date
302: ,last_updated_by = gme_common_pvt.g_user_ident
303: ,last_update_date = gme_common_pvt.g_timestamp
304: ,last_update_login = gme_common_pvt.g_login_id
305: WHERE batch_id = p_batch_step_rec.batch_id
306: AND batchstep_id = p_batch_step_rec.batchstep_id;
307: --Bug#4543875

Line 304: ,last_update_login = gme_common_pvt.g_login_id

300: UPDATE gme_batch_steps
301: SET due_date = p_batch_step_rec.due_date
302: ,last_updated_by = gme_common_pvt.g_user_ident
303: ,last_update_date = gme_common_pvt.g_timestamp
304: ,last_update_login = gme_common_pvt.g_login_id
305: WHERE batch_id = p_batch_step_rec.batch_id
306: AND batchstep_id = p_batch_step_rec.batchstep_id;
307: --Bug#4543875
308:

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

380: END LOOP;
381: END IF;
382:
383: IF l_found = FALSE
384: AND l_dep_step_rec.step_status <> gme_common_pvt.g_step_wip THEN
385: /* Continue only if the succeeding step is not the same as the step which initiated the reschedule and is not WIP */
386: l_batch_step_rec.batchstep_id :=
387: l_dep_step_rec.batchstep_id;
388: l_batch_step_rec.batch_id := p_batch_step_rec.batch_id;

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

479: END LOOP;
480: END IF;
481:
482: IF l_found = FALSE
483: AND l_dep_step_rec.step_status <> gme_common_pvt.g_step_wip THEN
484: /* Continue only if the preceeding step is not the same as the step which initiated the reschedule and is not WIP */
485: l_batch_step_rec.batchstep_id :=
486: l_dep_step_rec.batchstep_id;
487: l_batch_step_rec.batch_id := p_batch_step_rec.batch_id;

Line 740: IF NOT gme_common_pvt.check_validity_rule_dates

736:
737: --Bug#5365527 added the validity rule check for LCF Batches
738: IF l_batch_header2_rec.recipe_validity_rule_id IS NOT NULL THEN
739: -- Checking of batch dates with validity rules dates after teh reschedule
740: IF NOT gme_common_pvt.check_validity_rule_dates
741: (l_batch_header2_rec.recipe_validity_rule_id
742: ,l_batch_header2_rec.plan_start_date
743: ,l_batch_header2_rec.plan_cmplt_date) THEN
744: x_return_status := fnd_api.g_ret_sts_error;

Line 780: gme_common_pvt.is_material_auto_release

776:
777: FOR i IN 1 .. l_loop_count_get_material LOOP
778: -- stamp manual and incremental with step dates as well...
779: l_rel_type :=
780: gme_common_pvt.is_material_auto_release
781: (l_material_detail_id_tbl (i) );
782: --Bug#5606089 Start. Added the following code.
783: /* SELECT batchstep_id INTO l_batch_step2_rec.batchstep_id FROM GME_BATCH_STEP_ITEMS
784: WHERE material_detail_id = l_material_detail_id_tbl(i);

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

789: END IF;*/
790: --Bug#5606089 End.
791:
792: -- Modified the if condition.
793: IF ( gme_common_pvt.is_material_assoc_to_step (l_material_detail_id_tbl (i) ) = TRUE
794: AND
795: l_rel_type IN
796: (gme_common_pvt.g_mtl_manual_release
797: ,gme_common_pvt.g_mtl_incremental_release

Line 796: (gme_common_pvt.g_mtl_manual_release

792: -- Modified the if condition.
793: IF ( gme_common_pvt.is_material_assoc_to_step (l_material_detail_id_tbl (i) ) = TRUE
794: AND
795: l_rel_type IN
796: (gme_common_pvt.g_mtl_manual_release
797: ,gme_common_pvt.g_mtl_incremental_release
798: ,gme_common_pvt.g_mtl_autobystep_release)) THEN
799:
800: -- pawan kumar start bug 5929323 -- moved the fetch of batchstep_id only when step is assoc

Line 797: ,gme_common_pvt.g_mtl_incremental_release

793: IF ( gme_common_pvt.is_material_assoc_to_step (l_material_detail_id_tbl (i) ) = TRUE
794: AND
795: l_rel_type IN
796: (gme_common_pvt.g_mtl_manual_release
797: ,gme_common_pvt.g_mtl_incremental_release
798: ,gme_common_pvt.g_mtl_autobystep_release)) THEN
799:
800: -- pawan kumar start bug 5929323 -- moved the fetch of batchstep_id only when step is assoc
801:

Line 798: ,gme_common_pvt.g_mtl_autobystep_release)) THEN

794: AND
795: l_rel_type IN
796: (gme_common_pvt.g_mtl_manual_release
797: ,gme_common_pvt.g_mtl_incremental_release
798: ,gme_common_pvt.g_mtl_autobystep_release)) THEN
799:
800: -- pawan kumar start bug 5929323 -- moved the fetch of batchstep_id only when step is assoc
801:
802: SELECT batchstep_id INTO l_batch_step2_rec.batchstep_id FROM GME_BATCH_STEP_ITEMS

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

808: END IF;
809: -- pawan kumar end bug 5929323
810:
811:
812: IF l_line_type_tbl (i) = gme_common_pvt.g_line_type_ing THEN
813: -- Update the material_required_date with the associated plan_start_Date;
814: --Bug#5606089
815: l_material_date := x_batch_step2_rec.plan_start_date;
816: --l_material_date := x_batch_step_rec.plan_start_date;

Line 831: gme_common_pvt.material_date_change

827: || ' Material_detail_id : '
828: || l_material_detail_id_tbl (i)
829: || 'for date'||l_material_date );
830: END IF;
831: gme_common_pvt.material_date_change
832: (p_material_detail_id => l_material_detail_id_tbl
833: (i)
834: ,p_material_date => l_material_date
835: ,x_return_status => l_return_status);

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

853:
854: ELSE
855: gme_debug.put_line('3');
856: -- Navin Added as part of Reschedule Batch/Step Build.
857: IF l_line_type_tbl (i) = gme_common_pvt.g_line_type_ing THEN
858: -- Update the material_required_date with the associated plan_start_Date;
859: l_material_date := l_batch_header_rec.plan_start_date;
860: ELSE
861: -- Update the material required date with the associated plan cmplt Date;

Line 874: gme_common_pvt.material_date_change

870: || l_material_detail_id_tbl (i)
871: || 'for date'||l_material_date );
872: END IF;
873:
874: gme_common_pvt.material_date_change
875: (p_material_detail_id => l_material_detail_id_tbl
876: (i)
877: ,p_material_date => l_material_date
878: ,x_return_status => l_return_status);

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

911:
912: --FPBug#4585491 Begin
913: IF (l_B_count > 0) OR (l_R_count > 0 AND l_M_count > 0) THEN
914: --atleast for one material line MO allocations and reservations are deleted
915: gme_common_pvt.log_message('GME_EXPIRED_RESERV_MO_DELETED');
916: ELSIF l_R_count > 0 THEN
917: ----atleast for one material line reservations are deleted
918: gme_common_pvt.log_message('GME_EXPIRED_RESERV_DELETED');
919: ELSIF l_M_count > 0 THEN

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

914: --atleast for one material line MO allocations and reservations are deleted
915: gme_common_pvt.log_message('GME_EXPIRED_RESERV_MO_DELETED');
916: ELSIF l_R_count > 0 THEN
917: ----atleast for one material line reservations are deleted
918: gme_common_pvt.log_message('GME_EXPIRED_RESERV_DELETED');
919: ELSIF l_M_count > 0 THEN
920: ----atleast for one material line MO allocations are deleted
921: gme_common_pvt.log_message('GME_EXPIRED_MO_DELETED');
922: END IF;

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

917: ----atleast for one material line reservations are deleted
918: gme_common_pvt.log_message('GME_EXPIRED_RESERV_DELETED');
919: ELSIF l_M_count > 0 THEN
920: ----atleast for one material line MO allocations are deleted
921: gme_common_pvt.log_message('GME_EXPIRED_MO_DELETED');
922: END IF;
923: x_return_status := fnd_api.g_ret_sts_success;
924: --FPBug#4585491 End
925:

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

983: END IF;
984: EXCEPTION
985: WHEN batch_step_fetch_error THEN
986: x_return_status := fnd_api.g_ret_sts_error;
987: gme_common_pvt.log_message ('GME_API_BATCH_STEP_FETCH_ERR');
988: WHEN no_dates_passed THEN
989: x_return_status := fnd_api.g_ret_sts_error;
990: gme_common_pvt.log_message ('GME_API_RESCH_STEP_NO_DATES');
991: WHEN no_date_change THEN

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

986: x_return_status := fnd_api.g_ret_sts_error;
987: gme_common_pvt.log_message ('GME_API_BATCH_STEP_FETCH_ERR');
988: WHEN no_dates_passed THEN
989: x_return_status := fnd_api.g_ret_sts_error;
990: gme_common_pvt.log_message ('GME_API_RESCH_STEP_NO_DATES');
991: WHEN no_date_change THEN
992: x_return_status := fnd_api.g_ret_sts_error;
993: gme_common_pvt.log_message ('GME_API_RESCH_STEP_NO_DATE_CHG');
994: WHEN invalid_step_status THEN

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

989: x_return_status := fnd_api.g_ret_sts_error;
990: gme_common_pvt.log_message ('GME_API_RESCH_STEP_NO_DATES');
991: WHEN no_date_change THEN
992: x_return_status := fnd_api.g_ret_sts_error;
993: gme_common_pvt.log_message ('GME_API_RESCH_STEP_NO_DATE_CHG');
994: WHEN invalid_step_status THEN
995: x_return_status := fnd_api.g_ret_sts_error;
996: gme_common_pvt.log_message ('GME_API_INV_STEP_STAT_RESCH');
997: WHEN invalid_schedule_status THEN

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

992: x_return_status := fnd_api.g_ret_sts_error;
993: gme_common_pvt.log_message ('GME_API_RESCH_STEP_NO_DATE_CHG');
994: WHEN invalid_step_status THEN
995: x_return_status := fnd_api.g_ret_sts_error;
996: gme_common_pvt.log_message ('GME_API_INV_STEP_STAT_RESCH');
997: WHEN invalid_schedule_status THEN
998: x_return_status := fnd_api.g_ret_sts_error;
999: gme_common_pvt.log_message ('GME_API_INV_STEP_RESCH');
1000: WHEN date_overlap_error THEN

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

995: x_return_status := fnd_api.g_ret_sts_error;
996: gme_common_pvt.log_message ('GME_API_INV_STEP_STAT_RESCH');
997: WHEN invalid_schedule_status THEN
998: x_return_status := fnd_api.g_ret_sts_error;
999: gme_common_pvt.log_message ('GME_API_INV_STEP_RESCH');
1000: WHEN date_overlap_error THEN
1001: x_return_status := fnd_api.g_ret_sts_error;
1002: gme_common_pvt.log_message ('GME_STEP_OVERLAP_ERROR');
1003: WHEN batch_header_fetch_error THEN

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

998: x_return_status := fnd_api.g_ret_sts_error;
999: gme_common_pvt.log_message ('GME_API_INV_STEP_RESCH');
1000: WHEN date_overlap_error THEN
1001: x_return_status := fnd_api.g_ret_sts_error;
1002: gme_common_pvt.log_message ('GME_STEP_OVERLAP_ERROR');
1003: WHEN batch_header_fetch_error THEN
1004: x_return_status := fnd_api.g_ret_sts_error;
1005: gme_common_pvt.log_message ('GME_API_BATCH_FETCH_ERROR');
1006: WHEN date_exceed_validity_rule THEN

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

1001: x_return_status := fnd_api.g_ret_sts_error;
1002: gme_common_pvt.log_message ('GME_STEP_OVERLAP_ERROR');
1003: WHEN batch_header_fetch_error THEN
1004: x_return_status := fnd_api.g_ret_sts_error;
1005: gme_common_pvt.log_message ('GME_API_BATCH_FETCH_ERROR');
1006: WHEN date_exceed_validity_rule THEN
1007: x_return_status := fnd_api.g_ret_sts_error;
1008: WHEN step_start_date_low THEN
1009: x_return_status := fnd_api.g_ret_sts_error;

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

1006: WHEN date_exceed_validity_rule THEN
1007: x_return_status := fnd_api.g_ret_sts_error;
1008: WHEN step_start_date_low THEN
1009: x_return_status := fnd_api.g_ret_sts_error;
1010: gme_common_pvt.log_message ('GME_ESD_PLAN_DATE');
1011: WHEN error_cont_period THEN
1012: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1013: gme_debug.put_line ('Contiguity period ... _failed');
1014: END IF;

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

1018: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1019: gme_debug.put_line ('Contiguity period ... not found');
1020: END IF;
1021:
1022: gme_common_pvt.log_message ('GME_NON_CONTIGUOUS_TIME');
1023: x_return_status := 'C';
1024: WHEN save_data_error OR mtl_dt_chg_error THEN
1025: x_return_status := l_return_status;
1026: WHEN child_step_resch_error THEN

Line 1072: l_material_detail_id_tbl gme_common_pvt.number_tab;

1068: ,p_end_date IN DATE
1069: ,x_return_status OUT NOCOPY VARCHAR2)
1070: IS
1071: l_api_name CONSTANT VARCHAR2 (30) := 'SAVE_ALL_DATA';
1072: l_material_detail_id_tbl gme_common_pvt.number_tab;
1073: l_phantom_ids gme_common_pvt.number_tab;
1074: l_return_status VARCHAR2 (1);
1075: l_batch_header_rec gme_batch_header%ROWTYPE;
1076: l_in_batch_header_rec gme_batch_header%ROWTYPE;

Line 1073: l_phantom_ids gme_common_pvt.number_tab;

1069: ,x_return_status OUT NOCOPY VARCHAR2)
1070: IS
1071: l_api_name CONSTANT VARCHAR2 (30) := 'SAVE_ALL_DATA';
1072: l_material_detail_id_tbl gme_common_pvt.number_tab;
1073: l_phantom_ids gme_common_pvt.number_tab;
1074: l_return_status VARCHAR2 (1);
1075: l_batch_header_rec gme_batch_header%ROWTYPE;
1076: l_in_batch_header_rec gme_batch_header%ROWTYPE;
1077: x_batch_header_rec gme_batch_header%ROWTYPE;

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

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

Line 1152: gme_common_pvt.material_date_change

1148: || ' Material_detail_id : '
1149: || l_material_detail_id_tbl (i) );
1150: END IF;
1151:
1152: gme_common_pvt.material_date_change
1153: (p_material_detail_id => l_material_detail_id_tbl
1154: (i)
1155: ,p_material_date => l_material_date
1156: ,x_return_status => l_return_status);

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

1189:
1190: --FPBug#4585491 Begin
1191: IF (l_B_count > 0) OR (l_R_count > 0 AND l_M_count > 0) THEN
1192: --atleast for one material line MO allocations and reservations are deleted
1193: gme_common_pvt.log_message('GME_EXPIRED_RESERV_MO_DELETED');
1194: ELSIF l_R_count > 0 THEN
1195: ----atleast for one material line reservations are deleted
1196: gme_common_pvt.log_message('GME_EXPIRED_RESERV_DELETED');
1197: ELSIF l_M_count > 0 THEN

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

1192: --atleast for one material line MO allocations and reservations are deleted
1193: gme_common_pvt.log_message('GME_EXPIRED_RESERV_MO_DELETED');
1194: ELSIF l_R_count > 0 THEN
1195: ----atleast for one material line reservations are deleted
1196: gme_common_pvt.log_message('GME_EXPIRED_RESERV_DELETED');
1197: ELSIF l_M_count > 0 THEN
1198: ----atleast for one material line MO allocations are deleted
1199: gme_common_pvt.log_message('GME_EXPIRED_MO_DELETED');
1200: END IF;

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

1195: ----atleast for one material line reservations are deleted
1196: gme_common_pvt.log_message('GME_EXPIRED_RESERV_DELETED');
1197: ELSIF l_M_count > 0 THEN
1198: ----atleast for one material line MO allocations are deleted
1199: gme_common_pvt.log_message('GME_EXPIRED_MO_DELETED');
1200: END IF;
1201: x_return_status := fnd_api.g_ret_sts_success;
1202: --FPBug#4585491 End
1203: