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 273: x_return_status := fnd_api.g_ret_sts_error;

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

Line 542: IF p_use_workday_cal = fnd_api.g_true THEN

538: || TO_CHAR (x_batch_header_rec.plan_cmplt_date
539: ,'yyyy/mon/dd hh24:mi:ss') );
540: END IF;
541: ELSE /* l_no_prod_found*/
542: IF p_use_workday_cal = fnd_api.g_true THEN
543: gmd_recipe_fetch_pub.fetch_contiguous_ind
544: (p_recipe_id => NULL
545: ,p_orgn_id => NULL
546: ,p_recipe_validity_rule_id => l_batch_header_rec.recipe_validity_rule_id

Line 598: AND p_contiguity_override = fnd_api.g_false

594: || p_contiguity_override);
595: END IF;
596:
597: IF l_contiguous_ind = 1
598: AND p_contiguity_override = fnd_api.g_false
599: AND l_cal_count > 1 THEN
600: RAISE error_non_contiguious;
601: END IF;
602:

Line 647: AND p_contiguity_override = fnd_api.g_false

643: || p_contiguity_override);
644: END IF;
645:
646: IF l_contiguous_ind = 1
647: AND p_contiguity_override = fnd_api.g_false
648: AND l_cal_count > 1 THEN
649: RAISE error_non_contiguious;
650: END IF;
651:

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

668: AND p_batch_header_rec.plan_cmplt_date IS NOT NULL) THEN
669: x_batch_header_rec.plan_cmplt_date :=
670: p_batch_header_rec.plan_cmplt_date;
671: END IF;
672: END IF; /* p_use_workday_cal = FND_API.G_TRUE */
673: END IF; /* l_no_prod_found*/
674:
675: IF (NVL (g_debug, 0) IN
676: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN

Line 815: x_return_status := fnd_api.g_ret_sts_error;

811: (l_batch_header_rec.recipe_validity_rule_id
812: ,x_batch_header_rec.plan_start_date
813: ,x_batch_header_rec.plan_cmplt_date
814: ,l_batch_header_rec) THEN
815: x_return_status := fnd_api.g_ret_sts_error;
816: RAISE date_exceed_validity_rule;
817: END IF;
818: END IF; /* IF l_batch_header_rec.recipe_validity_rule_id IS NOT NULL */
819:

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

969: /*IF l_return_status <> x_return_status THEN
970: RAISE mtl_dt_chg_error;
971: END IF; */
972:
973: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
974: RAISE mtl_dt_chg_error;
975: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
976: RAISE fnd_api.g_exc_unexpected_error;
977: END IF;

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

971: END IF; */
972:
973: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
974: RAISE mtl_dt_chg_error;
975: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
976: RAISE fnd_api.g_exc_unexpected_error;
977: END IF;
978:
979: /*

Line 976: RAISE fnd_api.g_exc_unexpected_error;

972:
973: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
974: RAISE mtl_dt_chg_error;
975: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
976: RAISE fnd_api.g_exc_unexpected_error;
977: END IF;
978:
979: /*
980: The above material_date_change returns different status as described below

Line 1007: x_return_status := fnd_api.g_ret_sts_success;

1003: ELSIF l_M_count > 0 THEN
1004: ----atleast for one material line MO allocations are deleted
1005: gme_common_pvt.log_message('GME_EXPIRED_MO_DELETED');
1006: END IF;
1007: x_return_status := fnd_api.g_ret_sts_success;
1008: --FPBug#4585491 End
1009:
1010:
1011: --clearing the charge dates on batch reschedule;

Line 1059: x_return_status := fnd_api.g_ret_sts_error;

1055: || x_return_status);
1056: END IF;
1057: EXCEPTION
1058: WHEN invalid_batch THEN
1059: x_return_status := fnd_api.g_ret_sts_error;
1060: gme_common_pvt.log_message ('GME_API_INV_BATCH_RESCHED');
1061: WHEN null_dates THEN
1062: x_return_status := fnd_api.g_ret_sts_error;
1063: gme_common_pvt.log_message ('GME_API_RESCH_NO_DATES_PASSED');

Line 1062: x_return_status := fnd_api.g_ret_sts_error;

1058: WHEN invalid_batch THEN
1059: x_return_status := fnd_api.g_ret_sts_error;
1060: gme_common_pvt.log_message ('GME_API_INV_BATCH_RESCHED');
1061: WHEN null_dates THEN
1062: x_return_status := fnd_api.g_ret_sts_error;
1063: gme_common_pvt.log_message ('GME_API_RESCH_NO_DATES_PASSED');
1064: WHEN date_exceed_validity_rule THEN
1065: x_return_status := fnd_api.g_ret_sts_error;
1066: WHEN invalid_validity_rule THEN

Line 1065: x_return_status := fnd_api.g_ret_sts_error;

1061: WHEN null_dates THEN
1062: x_return_status := fnd_api.g_ret_sts_error;
1063: gme_common_pvt.log_message ('GME_API_RESCH_NO_DATES_PASSED');
1064: WHEN date_exceed_validity_rule THEN
1065: x_return_status := fnd_api.g_ret_sts_error;
1066: WHEN invalid_validity_rule THEN
1067: x_return_status := fnd_api.g_ret_sts_error;
1068: WHEN batch_header_fetch_error OR error_load_trans THEN
1069: x_return_status := fnd_api.g_ret_sts_error;

Line 1067: x_return_status := fnd_api.g_ret_sts_error;

1063: gme_common_pvt.log_message ('GME_API_RESCH_NO_DATES_PASSED');
1064: WHEN date_exceed_validity_rule THEN
1065: x_return_status := fnd_api.g_ret_sts_error;
1066: WHEN invalid_validity_rule THEN
1067: x_return_status := fnd_api.g_ret_sts_error;
1068: WHEN batch_header_fetch_error OR error_load_trans THEN
1069: x_return_status := fnd_api.g_ret_sts_error;
1070: WHEN resched_phant_fail OR mtl_dt_chg_error OR cal_dates_error THEN
1071: x_return_status := l_return_status;

Line 1069: x_return_status := fnd_api.g_ret_sts_error;

1065: x_return_status := fnd_api.g_ret_sts_error;
1066: WHEN invalid_validity_rule THEN
1067: x_return_status := fnd_api.g_ret_sts_error;
1068: WHEN batch_header_fetch_error OR error_load_trans THEN
1069: x_return_status := fnd_api.g_ret_sts_error;
1070: WHEN resched_phant_fail OR mtl_dt_chg_error OR cal_dates_error THEN
1071: x_return_status := l_return_status;
1072: WHEN cmplt_less_start OR cannot_reschedule_start OR date_is_less_than_actual THEN
1073: x_return_status := fnd_api.g_ret_sts_error;

Line 1073: x_return_status := fnd_api.g_ret_sts_error;

1069: x_return_status := fnd_api.g_ret_sts_error;
1070: WHEN resched_phant_fail OR mtl_dt_chg_error OR cal_dates_error THEN
1071: x_return_status := l_return_status;
1072: WHEN cmplt_less_start OR cannot_reschedule_start OR date_is_less_than_actual THEN
1073: x_return_status := fnd_api.g_ret_sts_error;
1074: WHEN error_cont_period THEN
1075: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1076: gme_debug.put_line ('Contiguity period ... _failed');
1077: END IF;

Line 1081: x_return_status := fnd_api.g_ret_sts_error;

1077: END IF;
1078:
1079: x_return_status := l_return_status;
1080: WHEN clear_chg_dates_error THEN
1081: x_return_status := fnd_api.g_ret_sts_error;
1082: WHEN error_non_contiguious THEN
1083: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1084: gme_debug.put_line ('Contiguity period ... not found');
1085: END IF;

Line 1099: x_return_status := fnd_api.g_ret_sts_error;

1095:
1096: CLOSE cur_item_no;
1097: END IF;
1098:
1099: x_return_status := fnd_api.g_ret_sts_error;
1100: fnd_message.set_name ('GMI', 'IC_API_UOM_CONVERSION_ERROR');
1101: fnd_message.set_token ('ITEM_NO', l_item_no);
1102: fnd_message.set_token ('FROM_UOM', l_from_uom);
1103: fnd_message.set_token ('TO_UOM', l_to_uom);

Line 1106: x_return_status := fnd_api.g_ret_sts_unexp_error;

1102: fnd_message.set_token ('FROM_UOM', l_from_uom);
1103: fnd_message.set_token ('TO_UOM', l_to_uom);
1104: fnd_msg_pub.ADD;
1105: WHEN OTHERS THEN
1106: x_return_status := fnd_api.g_ret_sts_unexp_error;
1107: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1108:
1109: IF (NVL (g_debug, 0) > 0) THEN
1110: gme_debug.put_line ( g_pkg_name

Line 1158: x_return_status := fnd_api.g_ret_sts_success;

1154: || 'Entering');
1155: END IF;
1156:
1157: /* Set the return status to success initially */
1158: x_return_status := fnd_api.g_ret_sts_success;
1159: l_batch_id := p_batch_header_rec.batch_id;
1160:
1161: IF (p_batch_header_rec.batch_type = 0) THEN
1162: l_doc_type := 'PROD';

Line 1433: x_return_status := fnd_api.g_ret_sts_unexp_error;

1429: AND trans_date > p_batch_header_rec.plan_cmplt_date;
1430: END IF;
1431: EXCEPTION
1432: WHEN OTHERS THEN
1433: x_return_status := fnd_api.g_ret_sts_unexp_error;
1434: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1435:
1436: IF (NVL (g_debug, 0) > 0) THEN
1437: gme_debug.put_line ( g_pkg_name