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_PROCESS_PARAMETERS_PVT dependencies on FND_API

Line 60: l_return_status VARCHAR2 (1) := fnd_api.g_ret_sts_success;

56: invalid_step_status EXCEPTION;
57: wrong_actual_value EXCEPTION;
58: validation_failure EXCEPTION;
59: l_api_name CONSTANT VARCHAR2 (30) := 'INSERT_PROCESS_PARAMETER';
60: l_return_status VARCHAR2 (1) := fnd_api.g_ret_sts_success;
61: l_process_param_rec gme_process_parameters%ROWTYPE;
62: l_resource_id NUMBER;
63: l_activity_id NUMBER;
64: l_batchstep_id NUMBER;

Line 84: x_return_status := fnd_api.g_ret_sts_success;

80: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
81: gme_debug.put_line ('Calling public Insert process parameters Row');
82: END IF;
83:
84: x_return_status := fnd_api.g_ret_sts_success;
85:
86: IF p_parameter IS NULL THEN
87: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'
88: ,'FIELD_NAME'

Line 191: x_return_status := fnd_api.g_ret_sts_error;

187: BEGIN
188: v_temp := p_process_param_rec.target_value;
189: EXCEPTION
190: WHEN VALUE_ERROR THEN
191: x_return_status := fnd_api.g_ret_sts_error;
192: gme_common_pvt.log_message
193: ('GME_INVALID_FIELD'
194: ,'FIELD'
195: ,'p_process_param_rec.target_value');

Line 247: x_return_status := fnd_api.g_ret_sts_error;

243: gme_common_pvt.log_message
244: ('GME_INVALID_FIELD'
245: ,'FIELD'
246: ,'p_process_param_rec.actual_value');
247: x_return_status := fnd_api.g_ret_sts_error;
248: RETURN;
249: END;
250:
251: -- check for actual value with minimum value

Line 286: IF l_return_status <> fnd_api.g_ret_sts_success THEN

282: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
283: gme_debug.put_line ('validate flex return ' || l_return_status);
284: END IF;
285:
286: IF l_return_status <> fnd_api.g_ret_sts_success THEN
287: RAISE validation_failure;
288: END IF;
289:
290: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN

Line 324: RAISE fnd_api.g_exc_error;

320: */
321: IF NOT gme_process_parameters_dbl.insert_row
322: (p_process_parameters => l_process_param_rec
323: ,x_process_parameters => x_process_param_rec) THEN
324: RAISE fnd_api.g_exc_error;
325: END IF;
326:
327: IF g_debug <= gme_debug.g_log_procedure THEN
328: gme_debug.put_line ( g_pkg_name

Line 339: x_return_status := fnd_api.g_ret_sts_error;

335: || TO_CHAR (SYSDATE, 'MM/DD/YYYY HH24:MI:SS') );
336: END IF;
337: EXCEPTION
338: WHEN input_param_missing OR validate_param_failed OR invalid_step_status OR param_details_not_found OR wrong_target_value THEN
339: x_return_status := fnd_api.g_ret_sts_error;
340: WHEN resource_fetch_error THEN
341: x_return_status := fnd_api.g_ret_sts_error;
342: WHEN val_pro_param_failed THEN
343: x_return_status := l_return_status;

Line 341: x_return_status := fnd_api.g_ret_sts_error;

337: EXCEPTION
338: WHEN input_param_missing OR validate_param_failed OR invalid_step_status OR param_details_not_found OR wrong_target_value THEN
339: x_return_status := fnd_api.g_ret_sts_error;
340: WHEN resource_fetch_error THEN
341: x_return_status := fnd_api.g_ret_sts_error;
342: WHEN val_pro_param_failed THEN
343: x_return_status := l_return_status;
344: WHEN validation_failure THEN
345: x_return_status := fnd_api.g_ret_sts_error;

Line 345: x_return_status := fnd_api.g_ret_sts_error;

341: x_return_status := fnd_api.g_ret_sts_error;
342: WHEN val_pro_param_failed THEN
343: x_return_status := l_return_status;
344: WHEN validation_failure THEN
345: x_return_status := fnd_api.g_ret_sts_error;
346: WHEN OTHERS THEN
347: x_return_status := fnd_api.g_ret_sts_unexp_error;
348: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
349: END insert_process_parameter;

Line 347: x_return_status := fnd_api.g_ret_sts_unexp_error;

343: x_return_status := l_return_status;
344: WHEN validation_failure THEN
345: x_return_status := fnd_api.g_ret_sts_error;
346: WHEN OTHERS THEN
347: x_return_status := fnd_api.g_ret_sts_unexp_error;
348: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
349: END insert_process_parameter;
350:
351: /*===========================================================================================

Line 366: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false

362: =============================================================================================*/
363: PROCEDURE update_process_parameter (
364: p_batch_no IN VARCHAR2 := NULL
365: ,p_org_code IN VARCHAR2 := NULL
366: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false
367: ,p_batchstep_no IN NUMBER := NULL
368: ,p_activity IN VARCHAR2 := NULL
369: ,p_parameter IN VARCHAR2 := NULL
370: ,p_process_param_rec IN gme_process_parameters%ROWTYPE

Line 413: l_return_status VARCHAR2 (1) := fnd_api.g_ret_sts_success;

409: no_change EXCEPTION;
410: param_details_not_found EXCEPTION;
411: batch_steps_fetch_error EXCEPTION;
412: l_api_name CONSTANT VARCHAR2 (30) := 'UPDATE_PROCESS_PARAMETER';
413: l_return_status VARCHAR2 (1) := fnd_api.g_ret_sts_success;
414: l_process_param_rec gme_process_parameters%ROWTYPE;
415: l_batch_steps gme_batch_steps%ROWTYPE;
416: l_proc_param_id NUMBER;
417: l_resource_id NUMBER;

Line 438: x_return_status := fnd_api.g_ret_sts_success;

434: gme_debug.put_line ('Calling public update process parameters Row');
435: END IF;
436:
437: /* Initially let us assign the return status to success */
438: x_return_status := fnd_api.g_ret_sts_success;
439:
440: IF (p_parameter IS NULL AND p_process_param_rec.process_param_id IS NULL) THEN
441: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'
442: ,'FIELD_NAME'

Line 526: RAISE fnd_api.g_exc_error;

522: l_process_param_rec.process_param_id := l_proc_param_id;
523:
524: IF NOT gme_process_parameters_dbl.fetch_row (l_process_param_rec
525: ,l_process_param_rec) THEN
526: RAISE fnd_api.g_exc_error;
527: END IF;
528:
529: -- Get process parameters details from GMP tables
530: OPEN cur_process_parameter (l_process_param_rec.parameter_id);

Line 544: IF p_process_param_rec.actual_value = fnd_api.g_miss_char THEN

540:
541: CLOSE cur_process_parameter;
542:
543: IF l_step_status IN (2, 3) THEN
544: IF p_process_param_rec.actual_value = fnd_api.g_miss_char THEN
545: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'
546: ,'FIELD_NAME'
547: ,'ACTUAL_VALUE');
548: RAISE input_param_missing;

Line 562: x_return_status := fnd_api.g_ret_sts_error;

558: gme_common_pvt.log_message
559: ('GME_INVALID_FIELD'
560: ,'FIELD'
561: ,'p_process_param_rec.actual_value');
562: x_return_status := fnd_api.g_ret_sts_error;
563: RETURN;
564: END;
565: END IF;
566:

Line 573: IF p_validate_flexfields = fnd_api.g_true THEN

569: p_process_param_rec.actual_value;
570: END IF;
571: END IF; /*l_step_status*/
572:
573: IF p_validate_flexfields = fnd_api.g_true THEN
574: l_field_updated := TRUE;
575: END IF;
576:
577: /* Nsinha as part of GME_Process_Parameter_APIs_TD

Line 590: IF l_return_status <> fnd_api.g_ret_sts_success THEN

586: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
587: gme_debug.put_line ('validate flex return ' || l_return_status);
588: END IF;
589:
590: IF l_return_status <> fnd_api.g_ret_sts_success THEN
591: RAISE validation_failure;
592: END IF;
593:
594: IF NOT (l_field_updated) THEN

Line 604: RAISE fnd_api.g_exc_error;

600: with gme_process_parameters_dbl.update_row
601: */
602: IF NOT gme_process_parameters_dbl.update_row
603: (p_process_parameters => l_process_param_rec) THEN
604: RAISE fnd_api.g_exc_error;
605: END IF;
606:
607: x_process_param_rec := l_process_param_rec;
608:

Line 621: x_return_status := fnd_api.g_ret_sts_error;

617: || TO_CHAR (SYSDATE, 'MM/DD/YYYY HH24:MI:SS') );
618: END IF;
619: EXCEPTION
620: WHEN input_param_missing OR validate_param_failed OR param_not_found OR invalid_step_status OR param_details_not_found OR batch_steps_fetch_error OR wrong_target_value OR no_change THEN
621: x_return_status := fnd_api.g_ret_sts_error;
622: WHEN VALUE_ERROR THEN
623: x_return_status := fnd_api.g_ret_sts_error;
624: WHEN fnd_api.g_exc_error THEN
625: x_return_status := fnd_api.g_ret_sts_error;

Line 623: x_return_status := fnd_api.g_ret_sts_error;

619: EXCEPTION
620: WHEN input_param_missing OR validate_param_failed OR param_not_found OR invalid_step_status OR param_details_not_found OR batch_steps_fetch_error OR wrong_target_value OR no_change THEN
621: x_return_status := fnd_api.g_ret_sts_error;
622: WHEN VALUE_ERROR THEN
623: x_return_status := fnd_api.g_ret_sts_error;
624: WHEN fnd_api.g_exc_error THEN
625: x_return_status := fnd_api.g_ret_sts_error;
626: WHEN validation_failure THEN
627: x_return_status := fnd_api.g_ret_sts_error;

Line 624: WHEN fnd_api.g_exc_error THEN

620: WHEN input_param_missing OR validate_param_failed OR param_not_found OR invalid_step_status OR param_details_not_found OR batch_steps_fetch_error OR wrong_target_value OR no_change THEN
621: x_return_status := fnd_api.g_ret_sts_error;
622: WHEN VALUE_ERROR THEN
623: x_return_status := fnd_api.g_ret_sts_error;
624: WHEN fnd_api.g_exc_error THEN
625: x_return_status := fnd_api.g_ret_sts_error;
626: WHEN validation_failure THEN
627: x_return_status := fnd_api.g_ret_sts_error;
628: WHEN val_pro_param_failed OR update_param_failed THEN

Line 625: x_return_status := fnd_api.g_ret_sts_error;

621: x_return_status := fnd_api.g_ret_sts_error;
622: WHEN VALUE_ERROR THEN
623: x_return_status := fnd_api.g_ret_sts_error;
624: WHEN fnd_api.g_exc_error THEN
625: x_return_status := fnd_api.g_ret_sts_error;
626: WHEN validation_failure THEN
627: x_return_status := fnd_api.g_ret_sts_error;
628: WHEN val_pro_param_failed OR update_param_failed THEN
629: x_return_status := l_return_status;

Line 627: x_return_status := fnd_api.g_ret_sts_error;

623: x_return_status := fnd_api.g_ret_sts_error;
624: WHEN fnd_api.g_exc_error THEN
625: x_return_status := fnd_api.g_ret_sts_error;
626: WHEN validation_failure THEN
627: x_return_status := fnd_api.g_ret_sts_error;
628: WHEN val_pro_param_failed OR update_param_failed THEN
629: x_return_status := l_return_status;
630: WHEN OTHERS THEN
631: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 631: x_return_status := fnd_api.g_ret_sts_unexp_error;

627: x_return_status := fnd_api.g_ret_sts_error;
628: WHEN val_pro_param_failed OR update_param_failed THEN
629: x_return_status := l_return_status;
630: WHEN OTHERS THEN
631: x_return_status := fnd_api.g_ret_sts_unexp_error;
632: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
633: END update_process_parameter;
634:
635: /*===========================================================================================

Line 685: l_return_status VARCHAR2 (1) := fnd_api.g_ret_sts_success;

681: invalid_batch_status EXCEPTION;
682: param_not_found EXCEPTION;
683: delete_param_failed EXCEPTION;
684: l_api_name CONSTANT VARCHAR2 (30) := 'DELETE_PROCESS_PARAMETER';
685: l_return_status VARCHAR2 (1) := fnd_api.g_ret_sts_success;
686: l_process_param_rec gme_process_parameters%ROWTYPE;
687: l_proc_param_id NUMBER;
688: l_resource_id NUMBER;
689: l_activity_id NUMBER;

Line 794: RAISE fnd_api.g_exc_error;

790: with gme_process_parameters_dbl.delete_row
791: */
792: IF NOT gme_process_parameters_dbl.delete_row
793: (p_process_parameters => l_process_param_rec) THEN
794: RAISE fnd_api.g_exc_error;
795: END IF;
796: EXCEPTION
797: WHEN input_param_missing OR validate_param_failed OR param_not_found OR invalid_batch_status THEN
798: x_return_status := fnd_api.g_ret_sts_error;

Line 798: x_return_status := fnd_api.g_ret_sts_error;

794: RAISE fnd_api.g_exc_error;
795: END IF;
796: EXCEPTION
797: WHEN input_param_missing OR validate_param_failed OR param_not_found OR invalid_batch_status THEN
798: x_return_status := fnd_api.g_ret_sts_error;
799: WHEN val_pro_param_failed OR delete_param_failed THEN
800: x_return_status := l_return_status;
801: WHEN OTHERS THEN
802: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 802: x_return_status := fnd_api.g_ret_sts_unexp_error;

798: x_return_status := fnd_api.g_ret_sts_error;
799: WHEN val_pro_param_failed OR delete_param_failed THEN
800: x_return_status := l_return_status;
801: WHEN OTHERS THEN
802: x_return_status := fnd_api.g_ret_sts_unexp_error;
803: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
804: END delete_process_parameter;
805:
806: /*===========================================================================================

Line 908: x_return_status := fnd_api.g_ret_sts_success;

904: param_not_found EXCEPTION;
905: setup_failure EXCEPTION;
906: BEGIN
907: /* Initially let us assign the return status to success */
908: x_return_status := fnd_api.g_ret_sts_success;
909:
910: IF p_activity IS NULL THEN
911: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'
912: ,'FIELD_NAME'

Line 1097: x_return_status := fnd_api.g_ret_sts_error;

1093: gme_debug.put_line ('validation-x_step_status ' || x_step_status);
1094: END IF;
1095: EXCEPTION
1096: WHEN setup_failure THEN
1097: x_return_status := fnd_api.g_ret_sts_error;
1098: WHEN batch_header_fetch_error OR batch_steps_fetch_error OR input_param_missing THEN
1099: x_return_status := fnd_api.g_ret_sts_error;
1100: WHEN stepactivity_not_found OR resource_not_found OR dup_act_rsrc_found OR dup_param_found OR param_not_found THEN
1101: x_return_status := fnd_api.g_ret_sts_error;

Line 1099: x_return_status := fnd_api.g_ret_sts_error;

1095: EXCEPTION
1096: WHEN setup_failure THEN
1097: x_return_status := fnd_api.g_ret_sts_error;
1098: WHEN batch_header_fetch_error OR batch_steps_fetch_error OR input_param_missing THEN
1099: x_return_status := fnd_api.g_ret_sts_error;
1100: WHEN stepactivity_not_found OR resource_not_found OR dup_act_rsrc_found OR dup_param_found OR param_not_found THEN
1101: x_return_status := fnd_api.g_ret_sts_error;
1102: WHEN OTHERS THEN
1103: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1101: x_return_status := fnd_api.g_ret_sts_error;

1097: x_return_status := fnd_api.g_ret_sts_error;
1098: WHEN batch_header_fetch_error OR batch_steps_fetch_error OR input_param_missing THEN
1099: x_return_status := fnd_api.g_ret_sts_error;
1100: WHEN stepactivity_not_found OR resource_not_found OR dup_act_rsrc_found OR dup_param_found OR param_not_found THEN
1101: x_return_status := fnd_api.g_ret_sts_error;
1102: WHEN OTHERS THEN
1103: x_return_status := fnd_api.g_ret_sts_unexp_error;
1104: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1105: END validate_process_param;

Line 1103: x_return_status := fnd_api.g_ret_sts_unexp_error;

1099: x_return_status := fnd_api.g_ret_sts_error;
1100: WHEN stepactivity_not_found OR resource_not_found OR dup_act_rsrc_found OR dup_param_found OR param_not_found THEN
1101: x_return_status := fnd_api.g_ret_sts_error;
1102: WHEN OTHERS THEN
1103: x_return_status := fnd_api.g_ret_sts_unexp_error;
1104: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1105: END validate_process_param;
1106: END gme_process_parameters_pvt;