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_API_PUB dependencies on GME_PENDING_PRODUCT_LOTS

Line 8612: ,p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE

8608: ,p_generate_parent_lot IN VARCHAR2 := fnd_api.g_false
8609: ,p_material_detail_rec IN gme_material_details%ROWTYPE
8610: /* nsinghi bug#4486074 Added the p_expiration_dt parameter. */
8611: ,p_expiration_date IN mtl_lot_numbers.expiration_date%TYPE := NULL
8612: ,p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE
8613: ,x_pending_product_lots_rec OUT NOCOPY gme_pending_product_lots%ROWTYPE)
8614: IS
8615: l_api_name CONSTANT VARCHAR2 (30) := 'CREATE_PENDING_PRODUCT_LOT';
8616:

Line 8613: ,x_pending_product_lots_rec OUT NOCOPY gme_pending_product_lots%ROWTYPE)

8609: ,p_material_detail_rec IN gme_material_details%ROWTYPE
8610: /* nsinghi bug#4486074 Added the p_expiration_dt parameter. */
8611: ,p_expiration_date IN mtl_lot_numbers.expiration_date%TYPE := NULL
8612: ,p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE
8613: ,x_pending_product_lots_rec OUT NOCOPY gme_pending_product_lots%ROWTYPE)
8614: IS
8615: l_api_name CONSTANT VARCHAR2 (30) := 'CREATE_PENDING_PRODUCT_LOT';
8616:
8617: l_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;

Line 8617: l_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;

8613: ,x_pending_product_lots_rec OUT NOCOPY gme_pending_product_lots%ROWTYPE)
8614: IS
8615: l_api_name CONSTANT VARCHAR2 (30) := 'CREATE_PENDING_PRODUCT_LOT';
8616:
8617: l_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;
8618: l_material_detail_rec gme_material_details%ROWTYPE;
8619: l_in_material_detail_rec gme_material_details%ROWTYPE;
8620: l_batch_header_rec gme_batch_header%ROWTYPE;
8621: l_batch_id NUMBER;

Line 8681: gme_pending_product_lots_pvt.validate_material_for_create

8677: RAISE fnd_api.g_exc_error;
8678: END IF;
8679:
8680: -- Validations
8681: gme_pending_product_lots_pvt.validate_material_for_create
8682: (p_batch_header_rec => l_batch_header_rec
8683: ,p_material_detail_rec => l_material_detail_rec
8684: ,x_return_status => x_return_status);
8685:

Line 8690: gme_pending_product_lots_pvt.validate_record_for_create

8686: IF x_return_status <> fnd_api.g_ret_sts_success THEN
8687: RAISE fnd_api.g_exc_error;
8688: END IF;
8689:
8690: gme_pending_product_lots_pvt.validate_record_for_create
8691: (p_material_detail_rec => l_material_detail_rec
8692: ,p_pending_product_lots_rec => p_pending_product_lots_rec
8693: ,p_create_lot => p_create_lot
8694: ,p_generate_lot => p_generate_lot

Line 8810: ,p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE

8806: ,x_return_status OUT NOCOPY VARCHAR2
8807: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
8808: ,p_org_code IN VARCHAR2
8809: ,p_material_detail_rec IN gme_material_details%ROWTYPE
8810: ,p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE
8811: ,x_pending_product_lots_rec OUT NOCOPY gme_pending_product_lots%ROWTYPE)
8812: IS
8813: l_api_name CONSTANT VARCHAR2 (30) := 'UPDATE_PENDING_PRODUCT_LOT';
8814:

Line 8811: ,x_pending_product_lots_rec OUT NOCOPY gme_pending_product_lots%ROWTYPE)

8807: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
8808: ,p_org_code IN VARCHAR2
8809: ,p_material_detail_rec IN gme_material_details%ROWTYPE
8810: ,p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE
8811: ,x_pending_product_lots_rec OUT NOCOPY gme_pending_product_lots%ROWTYPE)
8812: IS
8813: l_api_name CONSTANT VARCHAR2 (30) := 'UPDATE_PENDING_PRODUCT_LOT';
8814:
8815: l_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;

Line 8815: l_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;

8811: ,x_pending_product_lots_rec OUT NOCOPY gme_pending_product_lots%ROWTYPE)
8812: IS
8813: l_api_name CONSTANT VARCHAR2 (30) := 'UPDATE_PENDING_PRODUCT_LOT';
8814:
8815: l_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;
8816: l_db_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;
8817: l_in_material_detail_rec gme_material_details%ROWTYPE;
8818: l_in_batch_header_rec gme_batch_header%ROWTYPE;
8819: l_material_detail_rec gme_material_details%ROWTYPE;

Line 8816: l_db_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;

8812: IS
8813: l_api_name CONSTANT VARCHAR2 (30) := 'UPDATE_PENDING_PRODUCT_LOT';
8814:
8815: l_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;
8816: l_db_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;
8817: l_in_material_detail_rec gme_material_details%ROWTYPE;
8818: l_in_batch_header_rec gme_batch_header%ROWTYPE;
8819: l_material_detail_rec gme_material_details%ROWTYPE;
8820: l_batch_header_rec gme_batch_header%ROWTYPE;

Line 8854: IF NOT gme_pending_product_lots_dbl.fetch_row

8850: RAISE fnd_api.g_exc_error;
8851: END IF;
8852:
8853: IF p_pending_product_lots_rec.pending_product_lot_id IS NOT NULL THEN
8854: IF NOT gme_pending_product_lots_dbl.fetch_row
8855: (p_pending_product_lots_rec => p_pending_product_lots_rec
8856: ,x_pending_product_lots_rec => l_db_pending_product_lots_rec) THEN
8857: x_return_status := fnd_api.g_ret_sts_error;
8858: RAISE fnd_api.g_exc_error;

Line 8911: gme_pending_product_lots_pvt.validate_material_for_update

8907: END IF;
8908: END IF;
8909:
8910: -- Validations
8911: gme_pending_product_lots_pvt.validate_material_for_update
8912: (p_batch_header_rec => l_batch_header_rec
8913: ,p_material_detail_rec => l_material_detail_rec
8914: ,x_return_status => x_return_status);
8915:

Line 8920: gme_pending_product_lots_pvt.validate_record_for_update

8916: IF x_return_status <> fnd_api.g_ret_sts_success THEN
8917: RAISE fnd_api.g_exc_error;
8918: END IF;
8919:
8920: gme_pending_product_lots_pvt.validate_record_for_update
8921: (p_material_detail_rec => l_material_detail_rec
8922: ,p_db_pending_product_lots_rec => l_db_pending_product_lots_rec
8923: ,p_pending_product_lots_rec => p_pending_product_lots_rec
8924: ,x_pending_product_lots_rec => l_pending_product_lots_rec

Line 9048: ,p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE)

9044: ,x_return_status OUT NOCOPY VARCHAR2
9045: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
9046: ,p_org_code IN VARCHAR2
9047: ,p_material_detail_rec IN gme_material_details%ROWTYPE
9048: ,p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE)
9049: IS
9050: l_api_name CONSTANT VARCHAR2 (30) := 'DELETE_PENDING_PRODUCT_LOT';
9051:
9052: l_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;

Line 9052: l_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;

9048: ,p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE)
9049: IS
9050: l_api_name CONSTANT VARCHAR2 (30) := 'DELETE_PENDING_PRODUCT_LOT';
9051:
9052: l_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;
9053: l_db_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;
9054: l_in_material_detail_rec gme_material_details%ROWTYPE;
9055: l_in_batch_header_rec gme_batch_header%ROWTYPE;
9056: l_material_detail_rec gme_material_details%ROWTYPE;

Line 9053: l_db_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;

9049: IS
9050: l_api_name CONSTANT VARCHAR2 (30) := 'DELETE_PENDING_PRODUCT_LOT';
9051:
9052: l_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;
9053: l_db_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;
9054: l_in_material_detail_rec gme_material_details%ROWTYPE;
9055: l_in_batch_header_rec gme_batch_header%ROWTYPE;
9056: l_material_detail_rec gme_material_details%ROWTYPE;
9057: l_batch_header_rec gme_batch_header%ROWTYPE;

Line 9097: IF NOT gme_pending_product_lots_dbl.fetch_row

9093: RAISE fnd_api.g_exc_error;
9094: END IF;
9095:
9096: IF p_pending_product_lots_rec.pending_product_lot_id IS NOT NULL THEN
9097: IF NOT gme_pending_product_lots_dbl.fetch_row
9098: (p_pending_product_lots_rec => p_pending_product_lots_rec
9099: ,x_pending_product_lots_rec => l_db_pending_product_lots_rec) THEN
9100: x_return_status := fnd_api.g_ret_sts_error;
9101: RAISE fnd_api.g_exc_error;

Line 9152: gme_pending_product_lots_pvt.validate_material_for_delete

9148: RAISE fnd_api.g_exc_error;
9149: END IF;
9150: END IF;
9151: -- Validations
9152: gme_pending_product_lots_pvt.validate_material_for_delete
9153: (p_batch_header_rec => l_batch_header_rec
9154: ,p_material_detail_rec => l_material_detail_rec
9155: ,x_return_status => x_return_status);
9156:

Line 9161: gme_pending_product_lots_pvt.validate_record_for_delete

9157: IF x_return_status <> fnd_api.g_ret_sts_success THEN
9158: RAISE fnd_api.g_exc_error;
9159: END IF;
9160:
9161: gme_pending_product_lots_pvt.validate_record_for_delete
9162: (p_material_detail_rec => l_material_detail_rec
9163: ,p_db_pending_product_lots_rec => l_db_pending_product_lots_rec
9164: ,p_pending_product_lots_rec => p_pending_product_lots_rec
9165: ,x_pending_product_lots_rec => l_pending_product_lots_rec