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 FND_API

Line 184: x_return_status := fnd_api.g_ret_sts_success;

180: || 'Entering');
181: END IF;
182:
183: /* Set the return status to success initially */
184: x_return_status := fnd_api.g_ret_sts_success;
185:
186: /* Ensure that either a start_date or end_date has been passed. */
187: IF ( p_batch_step_rec.plan_start_date IS NULL
188: AND p_batch_step_rec.plan_cmplt_date IS NULL) THEN

Line 368: IF p_reschedule_succeeding = fnd_api.g_true OR

364: END LOOP;
365:
366: /* Call the reschedule step recursive routine for the children of the current step */
367: /* Reschedule succeding steps */
368: IF p_reschedule_succeeding = fnd_api.g_true OR
369: l_batch_header_rec.enforce_step_dependency = 1 THEN
370: OPEN cur_get_succ_steps (p_batch_step_rec.batch_id
371: ,p_batch_step_rec.batchstep_id);
372:

Line 464: END IF; /* p_reschedule_succeeding = FND_API.G_TRUE */

460: INTO l_dep_step_rec;
461: END LOOP; /* WHILE cur_get_succ_steps%FOUND */
462:
463: CLOSE cur_get_succ_steps;
464: END IF; /* p_reschedule_succeeding = FND_API.G_TRUE */
465:
466: /* Reschedule preceding steps */
467: IF p_reschedule_preceding = fnd_api.g_true OR
468: l_batch_header_rec.enforce_step_dependency = 1 THEN

Line 467: IF p_reschedule_preceding = fnd_api.g_true OR

463: CLOSE cur_get_succ_steps;
464: END IF; /* p_reschedule_succeeding = FND_API.G_TRUE */
465:
466: /* Reschedule preceding steps */
467: IF p_reschedule_preceding = fnd_api.g_true OR
468: l_batch_header_rec.enforce_step_dependency = 1 THEN
469: OPEN cur_get_prec_steps (p_batch_step_rec.batch_id
470: ,p_batch_step_rec.batchstep_id);
471:

Line 500: IF p_use_workday_cal = fnd_api.g_false THEN

496: ,l_batch_step_rec) ) THEN
497: RAISE batch_step_fetch_error;
498: END IF;
499: /* Standard Delay should always be divided by 24 if used in date calculations */
500: IF p_use_workday_cal = fnd_api.g_false THEN
501: IF l_dep_step_rec.dep_type = 0 THEN
502: l_batch_step_rec.plan_cmplt_date :=
503: l_batch_step_m_rec.plan_start_date
504: - l_dep_step_rec.standard_delay / 24;

Line 557: IF l_return_status <> fnd_api.g_ret_sts_success THEN

553: || ' Got back '
554: || TO_CHAR (l_date, 'DD-MON-YYYY HH24:MI:SS') );
555: END IF;
556:
557: IF l_return_status <> fnd_api.g_ret_sts_success THEN
558: NULL;
559: ELSE
560: IF l_dep_step_rec.dep_type = 0 THEN
561: l_batch_step_rec.plan_cmplt_date := l_date;

Line 568: /* l_return_status <> FND_API.G_RET_STS_SUCCESS */

564: l_batch_step_rec.plan_start_date := l_date;
565: l_batch_step_rec.plan_cmplt_date := NULL;
566: END IF;
567: END IF;
568: /* l_return_status <> FND_API.G_RET_STS_SUCCESS */
569: END IF; /* p_use_workday_cal = 0 */
570:
571: l_source_step_id_tbl (l_source_step_id_tbl.COUNT + 1) :=
572: p_batch_step_rec.batchstep_id;

Line 622: END IF; /* p_reschedule_preceding = FND_API.G_TRUE */

618: INTO l_dep_step_rec;
619: END LOOP; /* cur_get_prec_steps%FOUND */
620:
621: CLOSE cur_get_prec_steps;
622: END IF; /* p_reschedule_preceding = FND_API.G_TRUE */
623: -- END IF; /* l_batch_header_rec.enforce_step_dependency = 1 OR */
624:
625: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
626: gme_debug.put_line ( 'Done with succ as well as prec for '

Line 697: IF p_use_workday_cal = fnd_api.g_true

693: ,'DD-MON-YYYY HH24:MI:SS') );
694: END IF;
695:
696: /* This is to check the contiguity in case of step_start date is passed only*/
697: IF p_use_workday_cal = fnd_api.g_true
698: AND p_contiguity_override = fnd_api.g_false THEN
699: l_duration :=
700: ( l_batch_header_rec.plan_cmplt_date
701: - l_batch_header_rec.plan_start_date)

Line 698: AND p_contiguity_override = fnd_api.g_false THEN

694: END IF;
695:
696: /* This is to check the contiguity in case of step_start date is passed only*/
697: IF p_use_workday_cal = fnd_api.g_true
698: AND p_contiguity_override = fnd_api.g_false THEN
699: l_duration :=
700: ( l_batch_header_rec.plan_cmplt_date
701: - l_batch_header_rec.plan_start_date)
702: * 24;

Line 750: x_return_status := fnd_api.g_ret_sts_error;

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;
751: RAISE date_exceed_validity_rule;
752: END IF;
753: ELSE
754: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN

Line 854: IF (l_return_status = fnd_api.g_ret_sts_error) THEN

850: /*IF l_return_status <> x_return_status THEN
851: RAISE mtl_dt_chg_error;
852: END IF; */
853:
854: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
855: RAISE mtl_dt_chg_error;
856: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
857: RAISE fnd_api.g_exc_unexpected_error;
858: END IF;

Line 856: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN

852: END IF; */
853:
854: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
855: RAISE mtl_dt_chg_error;
856: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
857: RAISE fnd_api.g_exc_unexpected_error;
858: END IF;
859:
860: ELSE

Line 857: RAISE fnd_api.g_exc_unexpected_error;

853:
854: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
855: RAISE mtl_dt_chg_error;
856: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
857: RAISE fnd_api.g_exc_unexpected_error;
858: END IF;
859:
860: ELSE
861: gme_debug.put_line('3');

Line 895: IF (l_return_status = fnd_api.g_ret_sts_error) THEN

891: --FPBug#4585491 Begin
892: /*IF l_return_status <> x_return_status THEN
893: RAISE mtl_dt_chg_error;
894: END IF;*/
895: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
896: RAISE mtl_dt_chg_error;
897: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
898: RAISE fnd_api.g_exc_unexpected_error;
899: END IF;

Line 897: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN

893: RAISE mtl_dt_chg_error;
894: END IF;*/
895: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
896: RAISE mtl_dt_chg_error;
897: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
898: RAISE fnd_api.g_exc_unexpected_error;
899: END IF;
900: END IF; /* If material is not associted to steps */
901: /*

Line 898: RAISE fnd_api.g_exc_unexpected_error;

894: END IF;*/
895: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
896: RAISE mtl_dt_chg_error;
897: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
898: RAISE fnd_api.g_exc_unexpected_error;
899: END IF;
900: END IF; /* If material is not associted to steps */
901: /*
902: The above material_date_change returns different status as described below

Line 929: x_return_status := fnd_api.g_ret_sts_success;

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:
932: --Clearing the dates of the associated charges.
933: OPEN cur_is_charge_associated (l_batch_header_rec.batch_id

Line 992: x_return_status := fnd_api.g_ret_sts_error;

988: || x_return_status);
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');

Line 995: x_return_status := fnd_api.g_ret_sts_error;

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
998: x_return_status := fnd_api.g_ret_sts_error;
999: gme_common_pvt.log_message ('GME_API_RESCH_STEP_NO_DATE_CHG');

Line 998: x_return_status := fnd_api.g_ret_sts_error;

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
1001: x_return_status := fnd_api.g_ret_sts_error;
1002: gme_common_pvt.log_message ('GME_API_INV_STEP_STAT_RESCH');

Line 1001: x_return_status := fnd_api.g_ret_sts_error;

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
1004: x_return_status := fnd_api.g_ret_sts_error;
1005: gme_common_pvt.log_message ('GME_API_INV_STEP_RESCH');

Line 1004: x_return_status := fnd_api.g_ret_sts_error;

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
1007: x_return_status := fnd_api.g_ret_sts_error;
1008: gme_common_pvt.log_message ('GME_STEP_OVERLAP_ERROR');

Line 1007: x_return_status := fnd_api.g_ret_sts_error;

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
1010: x_return_status := fnd_api.g_ret_sts_error;
1011: gme_common_pvt.log_message ('GME_API_BATCH_FETCH_ERROR');

Line 1010: x_return_status := fnd_api.g_ret_sts_error;

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
1013: x_return_status := fnd_api.g_ret_sts_error;
1014: WHEN step_start_date_low THEN

Line 1013: x_return_status := fnd_api.g_ret_sts_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;
1016: gme_common_pvt.log_message ('GME_ESD_PLAN_DATE');
1017: WHEN error_cont_period THEN

Line 1015: 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;
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');

Line 1041: x_return_status := fnd_api.g_ret_sts_error;

1037: x_return_status := l_return_status;
1038: WHEN prev_step_err THEN
1039: x_return_status := l_return_status;
1040: WHEN clear_chg_dates_error THEN
1041: x_return_status := fnd_api.g_ret_sts_error;
1042: WHEN OTHERS THEN
1043: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1044: gme_debug.put_line (l_api_name || ':OTHERS ' || SQLERRM);
1045: END IF;

Line 1047: x_return_status := fnd_api.g_ret_sts_unexp_error;

1043: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1044: gme_debug.put_line (l_api_name || ':OTHERS ' || SQLERRM);
1045: END IF;
1046:
1047: x_return_status := fnd_api.g_ret_sts_unexp_error;
1048: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1049: END reschedule_step;
1050:
1051: /**************************************************************************************

Line 1122: x_return_status := fnd_api.g_ret_sts_success;

1118: || 'Entering');
1119: END IF;
1120:
1121: /* Initialize return status to success */
1122: x_return_status := fnd_api.g_ret_sts_success;
1123: l_batch_header_rec.batch_id := p_batch_step_rec.batch_id;
1124:
1125: IF NOT (gme_batch_header_dbl.fetch_row (l_batch_header_rec
1126: ,x_batch_header_rec) ) THEN

Line 1174: IF (l_return_status = fnd_api.g_ret_sts_error) THEN

1170: /*IF l_return_status <> x_return_status THEN
1171: RAISE mtl_dt_chg_error;
1172: END IF;*/
1173:
1174: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
1175: RAISE mtl_dt_chg_error;
1176: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
1177: RAISE fnd_api.g_exc_unexpected_error;
1178: END IF;

Line 1176: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN

1172: END IF;*/
1173:
1174: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
1175: RAISE mtl_dt_chg_error;
1176: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
1177: RAISE fnd_api.g_exc_unexpected_error;
1178: END IF;
1179:
1180: /*

Line 1177: RAISE fnd_api.g_exc_unexpected_error;

1173:
1174: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
1175: RAISE mtl_dt_chg_error;
1176: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
1177: RAISE fnd_api.g_exc_unexpected_error;
1178: END IF;
1179:
1180: /*
1181: The above material_date_change returns different status as described below

Line 1207: x_return_status := fnd_api.g_ret_sts_success;

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:
1210:
1211: /* Now we have to reschedule the batch associated with the step */

Line 1266: x_return_status := fnd_api.g_ret_sts_error;

1262: EXCEPTION
1263: WHEN resched_phant_error OR mtl_dt_chg_error OR invalid_batch THEN
1264: x_return_status := l_return_status;
1265: WHEN invalid_prior_dates THEN
1266: x_return_status := fnd_api.g_ret_sts_error;
1267: WHEN OTHERS THEN
1268: x_return_status := fnd_api.g_ret_sts_unexp_error;
1269: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1270:

Line 1268: x_return_status := fnd_api.g_ret_sts_unexp_error;

1264: x_return_status := l_return_status;
1265: WHEN invalid_prior_dates THEN
1266: x_return_status := fnd_api.g_ret_sts_error;
1267: WHEN OTHERS THEN
1268: x_return_status := fnd_api.g_ret_sts_unexp_error;
1269: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1270:
1271: IF (NVL (g_debug, 0) > 0) THEN
1272: gme_debug.put_line ( g_pkg_name