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 178: x_return_status := fnd_api.g_ret_sts_success;

174: || 'Entering');
175: END IF;
176:
177: /* Set the return status to success initially */
178: x_return_status := fnd_api.g_ret_sts_success;
179:
180: /* Ensure that either a start_date or end_date has been passed. */
181: IF ( p_batch_step_rec.plan_start_date IS NULL
182: AND p_batch_step_rec.plan_cmplt_date IS NULL) THEN

Line 362: IF p_reschedule_succeeding = fnd_api.g_true OR

358: END LOOP;
359:
360: /* Call the reschedule step recursive routine for the children of the current step */
361: /* Reschedule succeding steps */
362: IF p_reschedule_succeeding = fnd_api.g_true OR
363: l_batch_header_rec.enforce_step_dependency = 1 THEN
364: OPEN cur_get_succ_steps (p_batch_step_rec.batch_id
365: ,p_batch_step_rec.batchstep_id);
366:

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

454: INTO l_dep_step_rec;
455: END LOOP; /* WHILE cur_get_succ_steps%FOUND */
456:
457: CLOSE cur_get_succ_steps;
458: END IF; /* p_reschedule_succeeding = FND_API.G_TRUE */
459:
460: /* Reschedule preceding steps */
461: IF p_reschedule_preceding = fnd_api.g_true OR
462: l_batch_header_rec.enforce_step_dependency = 1 THEN

Line 461: IF p_reschedule_preceding = fnd_api.g_true OR

457: CLOSE cur_get_succ_steps;
458: END IF; /* p_reschedule_succeeding = FND_API.G_TRUE */
459:
460: /* Reschedule preceding steps */
461: IF p_reschedule_preceding = fnd_api.g_true OR
462: l_batch_header_rec.enforce_step_dependency = 1 THEN
463: OPEN cur_get_prec_steps (p_batch_step_rec.batch_id
464: ,p_batch_step_rec.batchstep_id);
465:

Line 494: IF p_use_workday_cal = fnd_api.g_false THEN

490: ,l_batch_step_rec) ) THEN
491: RAISE batch_step_fetch_error;
492: END IF;
493: /* Standard Delay should always be divided by 24 if used in date calculations */
494: IF p_use_workday_cal = fnd_api.g_false THEN
495: IF l_dep_step_rec.dep_type = 0 THEN
496: l_batch_step_rec.plan_cmplt_date :=
497: l_batch_step_m_rec.plan_start_date
498: - l_dep_step_rec.standard_delay / 24;

Line 551: IF l_return_status <> fnd_api.g_ret_sts_success THEN

547: || ' Got back '
548: || TO_CHAR (l_date, 'DD-MON-YYYY HH24:MI:SS') );
549: END IF;
550:
551: IF l_return_status <> fnd_api.g_ret_sts_success THEN
552: NULL;
553: ELSE
554: IF l_dep_step_rec.dep_type = 0 THEN
555: l_batch_step_rec.plan_cmplt_date := l_date;

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

558: l_batch_step_rec.plan_start_date := l_date;
559: l_batch_step_rec.plan_cmplt_date := NULL;
560: END IF;
561: END IF;
562: /* l_return_status <> FND_API.G_RET_STS_SUCCESS */
563: END IF; /* p_use_workday_cal = 0 */
564:
565: l_source_step_id_tbl (l_source_step_id_tbl.COUNT + 1) :=
566: p_batch_step_rec.batchstep_id;

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

612: INTO l_dep_step_rec;
613: END LOOP; /* cur_get_prec_steps%FOUND */
614:
615: CLOSE cur_get_prec_steps;
616: END IF; /* p_reschedule_preceding = FND_API.G_TRUE */
617: -- END IF; /* l_batch_header_rec.enforce_step_dependency = 1 OR */
618:
619: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
620: gme_debug.put_line ( 'Done with succ as well as prec for '

Line 691: IF p_use_workday_cal = fnd_api.g_true

687: ,'DD-MON-YYYY HH24:MI:SS') );
688: END IF;
689:
690: /* This is to check the contiguity in case of step_start date is passed only*/
691: IF p_use_workday_cal = fnd_api.g_true
692: AND p_contiguity_override = fnd_api.g_false THEN
693: l_duration :=
694: ( l_batch_header_rec.plan_cmplt_date
695: - l_batch_header_rec.plan_start_date)

Line 692: AND p_contiguity_override = fnd_api.g_false THEN

688: END IF;
689:
690: /* This is to check the contiguity in case of step_start date is passed only*/
691: IF p_use_workday_cal = fnd_api.g_true
692: AND p_contiguity_override = fnd_api.g_false THEN
693: l_duration :=
694: ( l_batch_header_rec.plan_cmplt_date
695: - l_batch_header_rec.plan_start_date)
696: * 24;

Line 744: x_return_status := fnd_api.g_ret_sts_error;

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;
745: RAISE date_exceed_validity_rule;
746: END IF;
747: ELSE
748: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN

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

844: /*IF l_return_status <> x_return_status THEN
845: RAISE mtl_dt_chg_error;
846: END IF; */
847:
848: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
849: RAISE mtl_dt_chg_error;
850: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
851: RAISE fnd_api.g_exc_unexpected_error;
852: END IF;

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

846: END IF; */
847:
848: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
849: RAISE mtl_dt_chg_error;
850: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
851: RAISE fnd_api.g_exc_unexpected_error;
852: END IF;
853:
854: ELSE

Line 851: RAISE fnd_api.g_exc_unexpected_error;

847:
848: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
849: RAISE mtl_dt_chg_error;
850: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
851: RAISE fnd_api.g_exc_unexpected_error;
852: END IF;
853:
854: ELSE
855: gme_debug.put_line('3');

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

885: --FPBug#4585491 Begin
886: /*IF l_return_status <> x_return_status THEN
887: RAISE mtl_dt_chg_error;
888: END IF;*/
889: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
890: RAISE mtl_dt_chg_error;
891: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
892: RAISE fnd_api.g_exc_unexpected_error;
893: END IF;

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

887: RAISE mtl_dt_chg_error;
888: END IF;*/
889: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
890: RAISE mtl_dt_chg_error;
891: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
892: RAISE fnd_api.g_exc_unexpected_error;
893: END IF;
894: END IF; /* If material is not associted to steps */
895: /*

Line 892: RAISE fnd_api.g_exc_unexpected_error;

888: END IF;*/
889: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
890: RAISE mtl_dt_chg_error;
891: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
892: RAISE fnd_api.g_exc_unexpected_error;
893: END IF;
894: END IF; /* If material is not associted to steps */
895: /*
896: The above material_date_change returns different status as described below

Line 923: x_return_status := fnd_api.g_ret_sts_success;

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

Line 986: x_return_status := fnd_api.g_ret_sts_error;

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

Line 989: x_return_status := fnd_api.g_ret_sts_error;

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

Line 992: x_return_status := fnd_api.g_ret_sts_error;

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

Line 995: x_return_status := fnd_api.g_ret_sts_error;

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

Line 998: x_return_status := fnd_api.g_ret_sts_error;

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

Line 1001: x_return_status := fnd_api.g_ret_sts_error;

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

Line 1004: x_return_status := fnd_api.g_ret_sts_error;

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

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

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

Line 1035: x_return_status := fnd_api.g_ret_sts_error;

1031: x_return_status := l_return_status;
1032: WHEN prev_step_err THEN
1033: x_return_status := l_return_status;
1034: WHEN clear_chg_dates_error THEN
1035: x_return_status := fnd_api.g_ret_sts_error;
1036: WHEN OTHERS THEN
1037: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1038: gme_debug.put_line (l_api_name || ':OTHERS ' || SQLERRM);
1039: END IF;

Line 1041: x_return_status := fnd_api.g_ret_sts_unexp_error;

1037: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1038: gme_debug.put_line (l_api_name || ':OTHERS ' || SQLERRM);
1039: END IF;
1040:
1041: x_return_status := fnd_api.g_ret_sts_unexp_error;
1042: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1043: END reschedule_step;
1044:
1045: /**************************************************************************************

Line 1116: x_return_status := fnd_api.g_ret_sts_success;

1112: || 'Entering');
1113: END IF;
1114:
1115: /* Initialize return status to success */
1116: x_return_status := fnd_api.g_ret_sts_success;
1117: l_batch_header_rec.batch_id := p_batch_step_rec.batch_id;
1118:
1119: IF NOT (gme_batch_header_dbl.fetch_row (l_batch_header_rec
1120: ,x_batch_header_rec) ) THEN

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

1164: /*IF l_return_status <> x_return_status THEN
1165: RAISE mtl_dt_chg_error;
1166: END IF;*/
1167:
1168: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
1169: RAISE mtl_dt_chg_error;
1170: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
1171: RAISE fnd_api.g_exc_unexpected_error;
1172: END IF;

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

1166: END IF;*/
1167:
1168: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
1169: RAISE mtl_dt_chg_error;
1170: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
1171: RAISE fnd_api.g_exc_unexpected_error;
1172: END IF;
1173:
1174: /*

Line 1171: RAISE fnd_api.g_exc_unexpected_error;

1167:
1168: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
1169: RAISE mtl_dt_chg_error;
1170: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
1171: RAISE fnd_api.g_exc_unexpected_error;
1172: END IF;
1173:
1174: /*
1175: The above material_date_change returns different status as described below

Line 1201: x_return_status := fnd_api.g_ret_sts_success;

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

Line 1260: x_return_status := fnd_api.g_ret_sts_error;

1256: EXCEPTION
1257: WHEN resched_phant_error OR mtl_dt_chg_error OR invalid_batch THEN
1258: x_return_status := l_return_status;
1259: WHEN invalid_prior_dates THEN
1260: x_return_status := fnd_api.g_ret_sts_error;
1261: WHEN OTHERS THEN
1262: x_return_status := fnd_api.g_ret_sts_unexp_error;
1263: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1264:

Line 1262: x_return_status := fnd_api.g_ret_sts_unexp_error;

1258: x_return_status := l_return_status;
1259: WHEN invalid_prior_dates THEN
1260: x_return_status := fnd_api.g_ret_sts_error;
1261: WHEN OTHERS THEN
1262: x_return_status := fnd_api.g_ret_sts_unexp_error;
1263: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1264:
1265: IF (NVL (g_debug, 0) > 0) THEN
1266: gme_debug.put_line ( g_pkg_name