DBA Data[Home] [Help]

APPS.GME_RESCHEDULE_BATCH_PVT dependencies on FND_API

Line 196: x_return_status := fnd_api.g_ret_sts_success;

192: || 'Entering');
193: END IF;
194:
195: /* Set the return status tosuccess initially */
196: x_return_status := fnd_api.g_ret_sts_success;
197:
198: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
199: gme_debug.put_line ( 'Trying to reschedule to '
200: || TO_CHAR (p_batch_header_rec.plan_start_date

Line 270: x_return_status := fnd_api.g_ret_sts_error;

266: (x_batch_header_rec.recipe_validity_rule_id
267: ,p_batch_header_rec.plan_start_date
268: ,p_batch_header_rec.plan_cmplt_date
269: ,x_batch_header_rec) THEN
270: x_return_status := fnd_api.g_ret_sts_error;
271: RAISE date_exceed_validity_rule;
272: END IF;
273:
274: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN

Line 534: IF p_use_workday_cal = fnd_api.g_true THEN

530: || TO_CHAR (x_batch_header_rec.plan_cmplt_date
531: ,'yyyy/mon/dd hh24:mi:ss') );
532: END IF;
533: ELSE /* l_no_prod_found*/
534: IF p_use_workday_cal = fnd_api.g_true THEN
535: gmd_recipe_fetch_pub.fetch_contiguous_ind
536: (p_recipe_id => NULL
537: ,p_orgn_id => NULL
538: ,p_recipe_validity_rule_id => l_batch_header_rec.recipe_validity_rule_id

Line 590: AND p_contiguity_override = fnd_api.g_false

586: || p_contiguity_override);
587: END IF;
588:
589: IF l_contiguous_ind = 1
590: AND p_contiguity_override = fnd_api.g_false
591: AND l_cal_count > 1 THEN
592: RAISE error_non_contiguious;
593: END IF;
594:

Line 639: AND p_contiguity_override = fnd_api.g_false

635: || p_contiguity_override);
636: END IF;
637:
638: IF l_contiguous_ind = 1
639: AND p_contiguity_override = fnd_api.g_false
640: AND l_cal_count > 1 THEN
641: RAISE error_non_contiguious;
642: END IF;
643:

Line 664: END IF; /* p_use_workday_cal = FND_API.G_TRUE */

660: AND p_batch_header_rec.plan_cmplt_date IS NOT NULL) THEN
661: x_batch_header_rec.plan_cmplt_date :=
662: p_batch_header_rec.plan_cmplt_date;
663: END IF;
664: END IF; /* p_use_workday_cal = FND_API.G_TRUE */
665: END IF; /* l_no_prod_found*/
666:
667: IF (NVL (g_debug, 0) IN
668: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN

Line 803: x_return_status := fnd_api.g_ret_sts_error;

799: (l_batch_header_rec.recipe_validity_rule_id
800: ,x_batch_header_rec.plan_start_date
801: ,x_batch_header_rec.plan_cmplt_date
802: ,l_batch_header_rec) THEN
803: x_return_status := fnd_api.g_ret_sts_error;
804: RAISE date_exceed_validity_rule;
805: END IF;
806: END IF; /* IF l_batch_header_rec.recipe_validity_rule_id IS NOT NULL */
807:

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

950: /*IF l_return_status <> x_return_status THEN
951: RAISE mtl_dt_chg_error;
952: END IF; */
953:
954: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
955: RAISE mtl_dt_chg_error;
956: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
957: RAISE fnd_api.g_exc_unexpected_error;
958: END IF;

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

952: END IF; */
953:
954: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
955: RAISE mtl_dt_chg_error;
956: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
957: RAISE fnd_api.g_exc_unexpected_error;
958: END IF;
959:
960: /*

Line 957: RAISE fnd_api.g_exc_unexpected_error;

953:
954: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
955: RAISE mtl_dt_chg_error;
956: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
957: RAISE fnd_api.g_exc_unexpected_error;
958: END IF;
959:
960: /*
961: The above material_date_change returns different status as described below

Line 988: x_return_status := fnd_api.g_ret_sts_success;

984: ELSIF l_M_count > 0 THEN
985: ----atleast for one material line MO allocations are deleted
986: gme_common_pvt.log_message('GME_EXPIRED_MO_DELETED');
987: END IF;
988: x_return_status := fnd_api.g_ret_sts_success;
989: --FPBug#4585491 End
990:
991:
992: --clearing the charge dates on batch reschedule;

Line 1036: x_return_status := fnd_api.g_ret_sts_error;

1032: || x_return_status);
1033: END IF;
1034: EXCEPTION
1035: WHEN invalid_batch THEN
1036: x_return_status := fnd_api.g_ret_sts_error;
1037: gme_common_pvt.log_message ('GME_API_INV_BATCH_RESCHED');
1038: WHEN null_dates THEN
1039: x_return_status := fnd_api.g_ret_sts_error;
1040: gme_common_pvt.log_message ('GME_API_RESCH_NO_DATES_PASSED');

Line 1039: x_return_status := fnd_api.g_ret_sts_error;

1035: WHEN invalid_batch THEN
1036: x_return_status := fnd_api.g_ret_sts_error;
1037: gme_common_pvt.log_message ('GME_API_INV_BATCH_RESCHED');
1038: WHEN null_dates THEN
1039: x_return_status := fnd_api.g_ret_sts_error;
1040: gme_common_pvt.log_message ('GME_API_RESCH_NO_DATES_PASSED');
1041: WHEN date_exceed_validity_rule THEN
1042: x_return_status := fnd_api.g_ret_sts_error;
1043: WHEN invalid_validity_rule THEN

Line 1042: x_return_status := fnd_api.g_ret_sts_error;

1038: WHEN null_dates THEN
1039: x_return_status := fnd_api.g_ret_sts_error;
1040: gme_common_pvt.log_message ('GME_API_RESCH_NO_DATES_PASSED');
1041: WHEN date_exceed_validity_rule THEN
1042: x_return_status := fnd_api.g_ret_sts_error;
1043: WHEN invalid_validity_rule THEN
1044: x_return_status := fnd_api.g_ret_sts_error;
1045: WHEN batch_header_fetch_error OR error_load_trans THEN
1046: x_return_status := fnd_api.g_ret_sts_error;

Line 1044: x_return_status := fnd_api.g_ret_sts_error;

1040: gme_common_pvt.log_message ('GME_API_RESCH_NO_DATES_PASSED');
1041: WHEN date_exceed_validity_rule THEN
1042: x_return_status := fnd_api.g_ret_sts_error;
1043: WHEN invalid_validity_rule THEN
1044: x_return_status := fnd_api.g_ret_sts_error;
1045: WHEN batch_header_fetch_error OR error_load_trans THEN
1046: x_return_status := fnd_api.g_ret_sts_error;
1047: WHEN resched_phant_fail OR mtl_dt_chg_error OR cal_dates_error THEN
1048: x_return_status := l_return_status;

Line 1046: x_return_status := fnd_api.g_ret_sts_error;

1042: x_return_status := fnd_api.g_ret_sts_error;
1043: WHEN invalid_validity_rule THEN
1044: x_return_status := fnd_api.g_ret_sts_error;
1045: WHEN batch_header_fetch_error OR error_load_trans THEN
1046: x_return_status := fnd_api.g_ret_sts_error;
1047: WHEN resched_phant_fail OR mtl_dt_chg_error OR cal_dates_error THEN
1048: x_return_status := l_return_status;
1049: WHEN cmplt_less_start OR cannot_reschedule_start OR date_is_less_than_actual THEN
1050: x_return_status := fnd_api.g_ret_sts_error;

Line 1050: x_return_status := fnd_api.g_ret_sts_error;

1046: x_return_status := fnd_api.g_ret_sts_error;
1047: WHEN resched_phant_fail OR mtl_dt_chg_error OR cal_dates_error THEN
1048: x_return_status := l_return_status;
1049: WHEN cmplt_less_start OR cannot_reschedule_start OR date_is_less_than_actual THEN
1050: x_return_status := fnd_api.g_ret_sts_error;
1051: WHEN error_cont_period THEN
1052: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1053: gme_debug.put_line ('Contiguity period ... _failed');
1054: END IF;

Line 1058: x_return_status := fnd_api.g_ret_sts_error;

1054: END IF;
1055:
1056: x_return_status := l_return_status;
1057: WHEN clear_chg_dates_error THEN
1058: x_return_status := fnd_api.g_ret_sts_error;
1059: WHEN error_non_contiguious THEN
1060: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1061: gme_debug.put_line ('Contiguity period ... not found');
1062: END IF;

Line 1076: x_return_status := fnd_api.g_ret_sts_error;

1072:
1073: CLOSE cur_item_no;
1074: END IF;
1075:
1076: x_return_status := fnd_api.g_ret_sts_error;
1077: fnd_message.set_name ('GMI', 'IC_API_UOM_CONVERSION_ERROR');
1078: fnd_message.set_token ('ITEM_NO', l_item_no);
1079: fnd_message.set_token ('FROM_UOM', l_from_uom);
1080: fnd_message.set_token ('TO_UOM', l_to_uom);

Line 1083: x_return_status := fnd_api.g_ret_sts_unexp_error;

1079: fnd_message.set_token ('FROM_UOM', l_from_uom);
1080: fnd_message.set_token ('TO_UOM', l_to_uom);
1081: fnd_msg_pub.ADD;
1082: WHEN OTHERS THEN
1083: x_return_status := fnd_api.g_ret_sts_unexp_error;
1084: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1085:
1086: IF (NVL (g_debug, 0) > 0) THEN
1087: gme_debug.put_line ( g_pkg_name

Line 1135: x_return_status := fnd_api.g_ret_sts_success;

1131: || 'Entering');
1132: END IF;
1133:
1134: /* Set the return status to success initially */
1135: x_return_status := fnd_api.g_ret_sts_success;
1136: l_batch_id := p_batch_header_rec.batch_id;
1137:
1138: IF (p_batch_header_rec.batch_type = 0) THEN
1139: l_doc_type := 'PROD';

Line 1410: x_return_status := fnd_api.g_ret_sts_unexp_error;

1406: AND trans_date > p_batch_header_rec.plan_cmplt_date;
1407: END IF;
1408: EXCEPTION
1409: WHEN OTHERS THEN
1410: x_return_status := fnd_api.g_ret_sts_unexp_error;
1411: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1412:
1413: IF (NVL (g_debug, 0) > 0) THEN
1414: gme_debug.put_line ( g_pkg_name