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.CSD_RECEIVE_UTIL dependencies on FND_API

Line 321: /* fnd_api.g_ret_sts_success (success) */

317: /* validation steps must be done and which steps */
318: /* should be skipped. */
319: /* p_receive_rec CSD_RCV_UTIL.RCV_REC_TYPE Required */
320: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
321: /* fnd_api.g_ret_sts_success (success) */
322: /* fnd_api.g_ret_sts_error (error) */
323: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
324: /*-----------------------------------------------------------------------------------------------------------*/
325: PROCEDURE validate_rcv_input (

Line 322: /* fnd_api.g_ret_sts_error (error) */

318: /* should be skipped. */
319: /* p_receive_rec CSD_RCV_UTIL.RCV_REC_TYPE Required */
320: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
321: /* fnd_api.g_ret_sts_success (success) */
322: /* fnd_api.g_ret_sts_error (error) */
323: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
324: /*-----------------------------------------------------------------------------------------------------------*/
325: PROCEDURE validate_rcv_input (
326: p_validation_level IN NUMBER,

Line 323: /* fnd_api.g_ret_sts_unexp_error (unexpected) */

319: /* p_receive_rec CSD_RCV_UTIL.RCV_REC_TYPE Required */
320: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
321: /* fnd_api.g_ret_sts_success (success) */
322: /* fnd_api.g_ret_sts_error (error) */
323: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
324: /*-----------------------------------------------------------------------------------------------------------*/
325: PROCEDURE validate_rcv_input (
326: p_validation_level IN NUMBER,
327: x_return_status OUT NOCOPY VARCHAR2,

Line 374: x_return_status := fnd_api.g_ret_sts_success;

370: );
371: END IF;
372:
373: -- initialize return status
374: x_return_status := fnd_api.g_ret_sts_success;
375: -- Check for required parameters
376: csd_process_util.check_reqd_param
377: (p_param_value => p_receive_rec.quantity,
378: p_param_name => 'P_RECEIVE_REC.QUANTITY',

Line 388: RAISE fnd_api.g_exc_error;

384: IF (NOT csd_process_util.validate_inventory_item_id
385: (p_inventory_item_id => p_receive_rec.inventory_item_id)
386: )
387: THEN
388: RAISE fnd_api.g_exc_error;
389: END IF;
390:
391: -- Validate the sub inventory.....
392: OPEN cur_subinv (p_receive_rec.to_organization_id,

Line 405: RAISE fnd_api.g_exc_error;

401: fnd_msg_pub.ADD;
402:
403: CLOSE cur_subinv;
404:
405: RAISE fnd_api.g_exc_error;
406: END IF;
407:
408: CLOSE cur_subinv;
409:

Line 428: -- RAISE fnd_api.g_exc_error;

424: -- fnd_message.set_name ('CSD', 'CSD_INVALID_SRL_STATUS');
425: -- fnd_message.set_token ('STATUS', ' ');
426: -- fnd_msg_pub.ADD;
427: -- CLOSE cur_serial_status;
428: -- RAISE fnd_api.g_exc_error;
429: --
430: IF ( cur_serial_status %FOUND )
431: THEN
432: IF ( p_receive_rec.internal_order_flag <> 'Y' AND l_Srl_status <> l_c_srl_out_of_Stores) THEN

Line 437: RAISE fnd_api.g_exc_error;

433: fnd_message.set_name ('CSD', 'CSD_INVALID_SRL_STATUS');
434: fnd_message.set_token ('STATUS', l_Srl_status);
435: fnd_msg_pub.ADD;
436: CLOSE cur_serial_status;
437: RAISE fnd_api.g_exc_error;
438: ELSIF ( p_receive_rec.internal_order_flag = 'Y' AND l_Srl_status <> l_c_srl_in_Stores
439: AND l_srl_Status <> l_c_srl_in_transit ) THEN
440: fnd_message.set_name ('CSD', 'CSD_INVALID_SRL_STATUS');
441: fnd_message.set_token ('STATUS', l_Srl_status);

Line 444: RAISE fnd_api.g_exc_error;

440: fnd_message.set_name ('CSD', 'CSD_INVALID_SRL_STATUS');
441: fnd_message.set_token ('STATUS', l_Srl_status);
442: fnd_msg_pub.ADD;
443: CLOSE cur_serial_status;
444: RAISE fnd_api.g_exc_error;
445:
446: END IF;
447: END IF;
448:

Line 462: WHEN fnd_api.g_exc_error

458: );
459: END IF;
460:
461: EXCEPTION
462: WHEN fnd_api.g_exc_error
463: THEN
464: x_return_status := fnd_api.g_ret_sts_error;
465: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)
466: THEN

Line 464: x_return_status := fnd_api.g_ret_sts_error;

460:
461: EXCEPTION
462: WHEN fnd_api.g_exc_error
463: THEN
464: x_return_status := fnd_api.g_ret_sts_error;
465: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)
466: THEN
467: fnd_log.STRING (fnd_log.level_error,
468: 'CSD.PLSQL.CSD_RECEIVE_UTIL.VALIDATE_RCV_INPUT',

Line 474: x_return_status := fnd_api.g_ret_sts_unexp_error;

470: );
471: END IF;
472: WHEN OTHERS
473: THEN
474: x_return_status := fnd_api.g_ret_sts_unexp_error;
475:
476: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
477: THEN
478: fnd_msg_pub.add_exc_msg (g_pkg_name, l_c_api_name);

Line 497: /* fnd_api.g_ret_sts_success (success) */

493: /* receiving transaction processor.. */
494: /* Called from : CSD_RECEIVE_PVT.RECEIVE_ITEM */
495: /* Input Parm : p_request_group_id NUMBER Required */
496: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
497: /* fnd_api.g_ret_sts_success (success) */
498: /* fnd_api.g_ret_sts_error (error) */
499: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
500: /*-----------------------------------------------------------------------------------------------------------*/
501: PROCEDURE check_rcv_errors (

Line 498: /* fnd_api.g_ret_sts_error (error) */

494: /* Called from : CSD_RECEIVE_PVT.RECEIVE_ITEM */
495: /* Input Parm : p_request_group_id NUMBER Required */
496: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
497: /* fnd_api.g_ret_sts_success (success) */
498: /* fnd_api.g_ret_sts_error (error) */
499: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
500: /*-----------------------------------------------------------------------------------------------------------*/
501: PROCEDURE check_rcv_errors (
502: x_return_status OUT NOCOPY VARCHAR2,

Line 499: /* fnd_api.g_ret_sts_unexp_error (unexpected) */

495: /* Input Parm : p_request_group_id NUMBER Required */
496: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
497: /* fnd_api.g_ret_sts_success (success) */
498: /* fnd_api.g_ret_sts_error (error) */
499: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
500: /*-----------------------------------------------------------------------------------------------------------*/
501: PROCEDURE check_rcv_errors (
502: x_return_status OUT NOCOPY VARCHAR2,
503: x_rcv_error_msg_tbl OUT NOCOPY csd_receive_util.rcv_error_msg_tbl,

Line 566: x_return_status := fnd_api.g_ret_sts_success;

562: );
563: END IF;
564:
565: -- initialize return status
566: x_return_status := fnd_api.g_ret_sts_success;
567:
568: -- Open cursors to get header_interface id and trnasaction_interface_id
569: open cur_rcv_headers (p_request_group_id);
570: open cur_rcv_lines(p_request_group_id);

Line 631: x_return_status := fnd_api.g_ret_sts_error;

627: x_rcv_error_msg_tbl(i).order_line_id := l_order_line_id;
628: x_rcv_error_msg_tbl(i).column_name := rcv_error_rec.column_name;
629: x_rcv_error_msg_tbl(i).error_message := rcv_error_rec.error_message;
630:
631: x_return_status := fnd_api.g_ret_sts_error;
632:
633: END LOOP;
634: end if;
635: END LOOP;

Line 654: x_return_status := fnd_api.g_ret_sts_unexp_error;

650: END IF;
651: EXCEPTION
652: WHEN OTHERS
653: THEN
654: x_return_status := fnd_api.g_ret_sts_unexp_error;
655:
656: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
657: THEN
658: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

Line 677: /* fnd_api.g_ret_sts_success (success) */

673: /* */
674: /* Called from : CSD_RECEIVE_PVT.RECEIVE_ITEM */
675: /* Input Parm : p_request_group_id NUMBER Required */
676: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
677: /* fnd_api.g_ret_sts_success (success) */
678: /* fnd_api.g_ret_sts_error (error) */
679: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
680: /*-----------------------------------------------------------------------------------------------------------*/
681: PROCEDURE get_employee_id (

Line 678: /* fnd_api.g_ret_sts_error (error) */

674: /* Called from : CSD_RECEIVE_PVT.RECEIVE_ITEM */
675: /* Input Parm : p_request_group_id NUMBER Required */
676: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
677: /* fnd_api.g_ret_sts_success (success) */
678: /* fnd_api.g_ret_sts_error (error) */
679: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
680: /*-----------------------------------------------------------------------------------------------------------*/
681: PROCEDURE get_employee_id (
682: p_user_id IN NUMBER,

Line 679: /* fnd_api.g_ret_sts_unexp_error (unexpected) */

675: /* Input Parm : p_request_group_id NUMBER Required */
676: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
677: /* fnd_api.g_ret_sts_success (success) */
678: /* fnd_api.g_ret_sts_error (error) */
679: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
680: /*-----------------------------------------------------------------------------------------------------------*/
681: PROCEDURE get_employee_id (
682: p_user_id IN NUMBER,
683: x_employee_id OUT NOCOPY NUMBER

Line 722: RAISE fnd_api.g_exc_unexpected_error; */

718: per_employees_current_x.
719: In this case Depot should not raise any error.
720: */
721: /* CLOSE cur_get_employee_id;
722: RAISE fnd_api.g_exc_unexpected_error; */
723:
724: x_employee_id := NULL;
725: END IF;
726:

Line 737: WHEN fnd_api.g_exc_unexpected_error

733: 'Leaving get_employee_id'
734: );
735: END IF;
736: EXCEPTION
737: WHEN fnd_api.g_exc_unexpected_error
738: THEN
739: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
740: THEN
741: fnd_log.STRING (fnd_log.level_exception,

Line 769: /* fnd_api.g_ret_sts_success (success) */

765: /* */
766: /* Called from : CSD_RECEIVE_PVT.RECEIVE_ITEM */
767: /* Input Parm : p_receive_rec CSD_RCV_UTIL.RCV_REC_TYPE Required */
768: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
769: /* fnd_api.g_ret_sts_success (success) */
770: /* fnd_api.g_ret_sts_error (error) */
771: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
772: /*-----------------------------------------------------------------------------------------------------------*/
773: PROCEDURE get_rcv_item_params (

Line 770: /* fnd_api.g_ret_sts_error (error) */

766: /* Called from : CSD_RECEIVE_PVT.RECEIVE_ITEM */
767: /* Input Parm : p_receive_rec CSD_RCV_UTIL.RCV_REC_TYPE Required */
768: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
769: /* fnd_api.g_ret_sts_success (success) */
770: /* fnd_api.g_ret_sts_error (error) */
771: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
772: /*-----------------------------------------------------------------------------------------------------------*/
773: PROCEDURE get_rcv_item_params (
774: p_receive_rec IN OUT NOCOPY csd_receive_util.rcv_rec_type

Line 771: /* fnd_api.g_ret_sts_unexp_error (unexpected) */

767: /* Input Parm : p_receive_rec CSD_RCV_UTIL.RCV_REC_TYPE Required */
768: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
769: /* fnd_api.g_ret_sts_success (success) */
770: /* fnd_api.g_ret_sts_error (error) */
771: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
772: /*-----------------------------------------------------------------------------------------------------------*/
773: PROCEDURE get_rcv_item_params (
774: p_receive_rec IN OUT NOCOPY csd_receive_util.rcv_rec_type
775: )

Line 861: RAISE fnd_api.g_exc_unexpected_error;

857: IF (cur_get_to_org %NOTFOUND)
858: THEN
859: CLOSE cur_get_to_org ;
860:
861: RAISE fnd_api.g_exc_unexpected_error;
862: END IF;
863:
864: CLOSE cur_get_to_org ;
865: End IF;

Line 876: RAISE fnd_api.g_exc_unexpected_error;

872: IF (cur_get_category_set%NOTFOUND)
873: THEN
874: CLOSE cur_get_category;
875:
876: RAISE fnd_api.g_exc_unexpected_error;
877: END IF;
878:
879: CLOSE cur_get_category_set;
880:

Line 893: RAISE fnd_api.g_exc_unexpected_error;

889:
890: IF (cur_get_category%NOTFOUND)
891: THEN
892: CLOSE cur_get_category;
893: RAISE fnd_api.g_exc_unexpected_error;
894: END IF;
895: CLOSE cur_get_category;
896:
897: --Get the primary UOM

Line 907: RAISE fnd_api.g_exc_unexpected_error;

903:
904: IF (cur_get_primary_uom%NOTFOUND)
905: THEN
906: CLOSE cur_get_primary_uom;
907: RAISE fnd_api.g_exc_unexpected_error;
908: END IF;
909: CLOSE cur_get_primary_uom;
910:
911: --Get serial number control code and lot control code

Line 921: RAISE fnd_api.g_exc_unexpected_error;

917:
918: IF (cur_get_item_attribs%NOTFOUND)
919: THEN
920: CLOSE cur_get_item_attribs;
921: RAISE fnd_api.g_exc_unexpected_error;
922: END IF;
923: CLOSE cur_get_item_attribs;
924:
925: --Get serial number control code and lot control code

Line 934: RAISE fnd_api.g_exc_unexpected_error;

930:
931: IF (cur_get_unit_of_measure%NOTFOUND)
932: THEN
933: CLOSE cur_get_unit_of_measure;
934: RAISE fnd_api.g_exc_unexpected_error;
935: END IF;
936: CLOSE cur_get_unit_of_measure;
937:
938:

Line 949: WHEN fnd_api.g_exc_unexpected_error

945: );
946: END IF;
947:
948: EXCEPTION
949: WHEN fnd_api.g_exc_unexpected_error
950: THEN
951: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
952: THEN
953: fnd_log.STRING (fnd_log.level_exception,

Line 972: RAISE fnd_api.g_exc_unexpected_error;

968: || ']'
969: );
970: END IF;
971:
972: RAISE fnd_api.g_exc_unexpected_error;
973: END get_rcv_item_params;
974: END csd_receive_util;