DBA Data[Home] [Help]

APPS.GME_INSERT_STEP_PVT dependencies on FND_API

Line 91: x_return_status := fnd_api.g_ret_sts_success;

87: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
88: gme_debug.put_line ('Begin Insert_Batch_Step');
89: END IF;
90:
91: x_return_status := fnd_api.g_ret_sts_success;
92: /* Bug 2397077 Use only one batch_id when batch IDs passed in both parameters. */
93: l_batch_id :=
94: NVL (p_gme_batch_step.batch_id, p_gme_batch_header.batch_id);
95:

Line 152: ,p_init_msg_list => fnd_api.g_false

148:
149: /* Punit Kumar */
150: gmd_fetch_oprn.fetch_oprn
151: (p_api_version => 1.0
152: ,p_init_msg_list => fnd_api.g_false
153: ,p_oprn_id => p_gme_batch_step.oprn_id
154: ,p_orgn_code => l_orgn_code
155: , /* p_gme_batch_header.plant_code, */
156: x_return_status => l_return_status

Line 274: ,p_use_workday_cal => fnd_api.g_true

270: ,p_resc_parameters_tbl => l_resc_parameters
271: ,p_recipe_rout_matl_tbl => l_recipe_rout_matl
272: ,p_routing_depd_tbl => l_routing_depd
273: ,p_gme_batch_header_rec => p_gme_batch_header
274: ,p_use_workday_cal => fnd_api.g_true
275: ,p_contiguity_override => fnd_api.g_true
276: ,x_return_status => l_return_status
277: ,p_ignore_qty_below_cap => fnd_api.g_true
278: ,p_step_start_date => p_gme_batch_step.plan_start_date

Line 275: ,p_contiguity_override => fnd_api.g_true

271: ,p_recipe_rout_matl_tbl => l_recipe_rout_matl
272: ,p_routing_depd_tbl => l_routing_depd
273: ,p_gme_batch_header_rec => p_gme_batch_header
274: ,p_use_workday_cal => fnd_api.g_true
275: ,p_contiguity_override => fnd_api.g_true
276: ,x_return_status => l_return_status
277: ,p_ignore_qty_below_cap => fnd_api.g_true
278: ,p_step_start_date => p_gme_batch_step.plan_start_date
279: ,p_step_cmplt_date => p_gme_batch_step.plan_cmplt_date

Line 277: ,p_ignore_qty_below_cap => fnd_api.g_true

273: ,p_gme_batch_header_rec => p_gme_batch_header
274: ,p_use_workday_cal => fnd_api.g_true
275: ,p_contiguity_override => fnd_api.g_true
276: ,x_return_status => l_return_status
277: ,p_ignore_qty_below_cap => fnd_api.g_true
278: ,p_step_start_date => p_gme_batch_step.plan_start_date
279: ,p_step_cmplt_date => p_gme_batch_step.plan_cmplt_date
280: ,p_step_due_date => p_gme_batch_step.due_date);
281:

Line 299: x_return_status := FND_API.G_RET_STS_ERROR;

295: against the operation effectivity start and end dates */
296: IF NOT gme_common_pvt.check_oprn_effectivity_dates(x_gme_batch_step.oprn_id,
297: x_gme_batch_step.plan_start_date,
298: x_gme_batch_step.plan_cmplt_date) THEN
299: x_return_status := FND_API.G_RET_STS_ERROR;
300: RAISE invalid_oprn_effectivity;
301: END IF;
302:
303: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN

Line 348: IF x_return_status <> fnd_api.g_ret_sts_success THEN

344: (p_batch_step => l_batch_step_row
345: ,x_batch_step => x_gme_batch_step
346: ,x_return_status => x_return_status);
347:
348: IF x_return_status <> fnd_api.g_ret_sts_success THEN
349: RAISE validation_failure;
350: END IF;
351:
352: --nsinghi bug#5202811 added the code to process edit text.

Line 382: x_return_status := fnd_api.g_ret_sts_error;

378: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
379: gme_debug.put_line ('insert_step --> invalid batch status');
380: END IF;
381:
382: x_return_status := fnd_api.g_ret_sts_error;
383: gme_common_pvt.log_message ('GME_INV_STATUS_INSERT_STEP');
384: WHEN error_no_oprn_defined THEN
385: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
386: gme_debug.put_line ('insert_step --> no oprn passed');

Line 389: x_return_status := fnd_api.g_ret_sts_error;

385: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
386: gme_debug.put_line ('insert_step --> no oprn passed');
387: END IF;
388:
389: x_return_status := fnd_api.g_ret_sts_error;
390: gme_common_pvt.log_message ('GME_NO_OPRN_DEFINED');
391: WHEN error_gmd_fetch_oprn THEN
392: x_return_status := l_return_status;
393: WHEN error_step_qty_lthan_zero THEN

Line 398: x_return_status := fnd_api.g_ret_sts_error;

394: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
395: gme_debug.put_line ('insert_step --> step qty < zero');
396: END IF;
397:
398: x_return_status := fnd_api.g_ret_sts_error;
399: gme_common_pvt.log_message ('GME_STEP_QTY_LTHAN_ZERO');
400: /* Punit Kumar */
401: WHEN error_no_organization_id THEN
402: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN

Line 406: x_return_status := fnd_api.g_ret_sts_error;

402: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
403: gme_debug.put_line ('insert_step --> no ORGANIZATION_ID supplied');
404: END IF;
405:
406: x_return_status := fnd_api.g_ret_sts_error;
407: WHEN error_create_batch_step THEN
408: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
409: gme_debug.put_line
410: (fnd_msg_pub.get (p_encoded => fnd_api.g_false) );

Line 410: (fnd_msg_pub.get (p_encoded => fnd_api.g_false) );

406: x_return_status := fnd_api.g_ret_sts_error;
407: WHEN error_create_batch_step THEN
408: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
409: gme_debug.put_line
410: (fnd_msg_pub.get (p_encoded => fnd_api.g_false) );
411: END IF;
412:
413: x_return_status := l_return_status;
414: WHEN error_calc_max_capacity THEN

Line 417: x_return_status := fnd_api.g_ret_sts_error;

413: x_return_status := l_return_status;
414: WHEN error_calc_max_capacity THEN
415: x_return_status := l_return_status;
416: WHEN invalid_text_code THEN -- nsinghi bug#5202911
417: x_return_status := fnd_api.g_ret_sts_error;
418: gme_common_pvt.log_message ('GME_INVALID_TEXT_CODE');
419: WHEN batch_step_fetch_error OR batch_step_update_error THEN
420: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
421: gme_debug.put_line

Line 422: (fnd_msg_pub.get (p_encoded => fnd_api.g_false) );

418: gme_common_pvt.log_message ('GME_INVALID_TEXT_CODE');
419: WHEN batch_step_fetch_error OR batch_step_update_error THEN
420: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
421: gme_debug.put_line
422: (fnd_msg_pub.get (p_encoded => fnd_api.g_false) );
423: END IF;
424:
425: x_return_status := fnd_api.g_ret_sts_error;
426: WHEN validation_failure THEN

Line 425: x_return_status := fnd_api.g_ret_sts_error;

421: gme_debug.put_line
422: (fnd_msg_pub.get (p_encoded => fnd_api.g_false) );
423: END IF;
424:
425: x_return_status := fnd_api.g_ret_sts_error;
426: WHEN validation_failure THEN
427: NULL;
428: WHEN expected_error OR invalid_oprn_effectivity THEN --Bug#6408612
429: x_return_status := fnd_api.g_ret_sts_error;

Line 429: x_return_status := fnd_api.g_ret_sts_error;

425: x_return_status := fnd_api.g_ret_sts_error;
426: WHEN validation_failure THEN
427: NULL;
428: WHEN expected_error OR invalid_oprn_effectivity THEN --Bug#6408612
429: x_return_status := fnd_api.g_ret_sts_error;
430: WHEN OTHERS THEN
431: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
432: gme_debug.put_line ( 'GME insert_step API -- when others '
433: || SQLERRM);

Line 436: x_return_status := fnd_api.g_ret_sts_unexp_error;

432: gme_debug.put_line ( 'GME insert_step API -- when others '
433: || SQLERRM);
434: END IF;
435:
436: x_return_status := fnd_api.g_ret_sts_unexp_error;
437: fnd_msg_pub.add_exc_msg ('GME_API_INSERT_STEP', 'INSERT_BATCH_STEP');
438: END insert_batch_step;
439:
440: PROCEDURE calc_max_capacity (

Line 494: x_return_status := fnd_api.g_ret_sts_success;

490: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
491: gme_debug.put_line ('Insert_batch_step... BEGIN calc max cap');
492: END IF;
493:
494: x_return_status := fnd_api.g_ret_sts_success;
495: l_first := TRUE;
496: l_assign := FALSE;
497: -- Initialize in case we don't find any rsrcs that are capacity constraining...
498: l_min_of_max_cap := NULL;

Line 593: x_return_status := fnd_api.g_ret_sts_error;

589: gme_debug.put_line ('Insert_batch_step... END calc max cap');
590: END IF;
591: EXCEPTION
592: WHEN error_rsrc_diff_um_type OR error_calc_charge_conv THEN
593: x_return_status := fnd_api.g_ret_sts_error;
594: WHEN OTHERS THEN
595: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
596: gme_debug.put_line
597: ( 'GME insert_step API calc_max_cap --> when others '

Line 601: x_return_status := fnd_api.g_ret_sts_unexp_error;

597: ( 'GME insert_step API calc_max_cap --> when others '
598: || SQLERRM);
599: END IF;
600:
601: x_return_status := fnd_api.g_ret_sts_unexp_error;
602: --Bug2804440
603: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
604: END calc_max_capacity;
605: