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 9116: gme_pending_product_lots_pvt.validate_record_for_create which already had a paramater

9112: Conditionalize call to save batch based on p_commit_parameter.
9113:
9114: 13-MAY-2010 G. Muratore Bug 9482460
9115: Introduced new p_parent_lot parameter. The function we call for validation is
9116: gme_pending_product_lots_pvt.validate_record_for_create which already had a paramater
9117: for p_parent_lot. So we are extending it to the api call.
9118: ================================================================================*/
9119: PROCEDURE create_pending_product_lot
9120: (p_api_version IN NUMBER

Line 9137: ,p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE

9133: ,p_parent_lot IN mtl_lot_numbers.lot_number%TYPE := NULL
9134: ,p_material_detail_rec IN gme_material_details%ROWTYPE
9135: /* nsinghi bug#4486074 Added the p_expiration_dt parameter. */
9136: ,p_expiration_date IN mtl_lot_numbers.expiration_date%TYPE := NULL
9137: ,p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE
9138: ,x_pending_product_lots_rec OUT NOCOPY gme_pending_product_lots%ROWTYPE)
9139: IS
9140: l_api_name CONSTANT VARCHAR2 (30) := 'CREATE_PENDING_PRODUCT_LOT';
9141:

Line 9138: ,x_pending_product_lots_rec OUT NOCOPY gme_pending_product_lots%ROWTYPE)

9134: ,p_material_detail_rec IN gme_material_details%ROWTYPE
9135: /* nsinghi bug#4486074 Added the p_expiration_dt parameter. */
9136: ,p_expiration_date IN mtl_lot_numbers.expiration_date%TYPE := NULL
9137: ,p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE
9138: ,x_pending_product_lots_rec OUT NOCOPY gme_pending_product_lots%ROWTYPE)
9139: IS
9140: l_api_name CONSTANT VARCHAR2 (30) := 'CREATE_PENDING_PRODUCT_LOT';
9141:
9142: l_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;

Line 9142: l_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;

9138: ,x_pending_product_lots_rec OUT NOCOPY gme_pending_product_lots%ROWTYPE)
9139: IS
9140: l_api_name CONSTANT VARCHAR2 (30) := 'CREATE_PENDING_PRODUCT_LOT';
9141:
9142: l_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;
9143: l_material_detail_rec gme_material_details%ROWTYPE;
9144: l_in_material_detail_rec gme_material_details%ROWTYPE;
9145: l_batch_header_rec gme_batch_header%ROWTYPE;
9146: l_batch_id NUMBER;

Line 9206: gme_pending_product_lots_pvt.validate_material_for_create

9202: RAISE fnd_api.g_exc_error;
9203: END IF;
9204:
9205: -- Validations
9206: gme_pending_product_lots_pvt.validate_material_for_create
9207: (p_batch_header_rec => l_batch_header_rec
9208: ,p_material_detail_rec => l_material_detail_rec
9209: ,x_return_status => x_return_status);
9210:

Line 9216: gme_pending_product_lots_pvt.validate_record_for_create

9212: RAISE fnd_api.g_exc_error;
9213: END IF;
9214:
9215: -- Bug 9482460 - Pass in the parent lot value.
9216: gme_pending_product_lots_pvt.validate_record_for_create
9217: (p_material_detail_rec => l_material_detail_rec
9218: ,p_pending_product_lots_rec => p_pending_product_lots_rec
9219: ,p_create_lot => p_create_lot
9220: ,p_generate_lot => p_generate_lot

Line 9340: ,p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE

9336: ,x_return_status OUT NOCOPY VARCHAR2
9337: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
9338: ,p_org_code IN VARCHAR2
9339: ,p_material_detail_rec IN gme_material_details%ROWTYPE
9340: ,p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE
9341: ,x_pending_product_lots_rec OUT NOCOPY gme_pending_product_lots%ROWTYPE)
9342: IS
9343: l_api_name CONSTANT VARCHAR2 (30) := 'UPDATE_PENDING_PRODUCT_LOT';
9344:

Line 9341: ,x_pending_product_lots_rec OUT NOCOPY gme_pending_product_lots%ROWTYPE)

9337: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
9338: ,p_org_code IN VARCHAR2
9339: ,p_material_detail_rec IN gme_material_details%ROWTYPE
9340: ,p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE
9341: ,x_pending_product_lots_rec OUT NOCOPY gme_pending_product_lots%ROWTYPE)
9342: IS
9343: l_api_name CONSTANT VARCHAR2 (30) := 'UPDATE_PENDING_PRODUCT_LOT';
9344:
9345: l_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;

Line 9345: l_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;

9341: ,x_pending_product_lots_rec OUT NOCOPY gme_pending_product_lots%ROWTYPE)
9342: IS
9343: l_api_name CONSTANT VARCHAR2 (30) := 'UPDATE_PENDING_PRODUCT_LOT';
9344:
9345: l_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;
9346: l_db_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;
9347: l_in_material_detail_rec gme_material_details%ROWTYPE;
9348: l_in_batch_header_rec gme_batch_header%ROWTYPE;
9349: l_material_detail_rec gme_material_details%ROWTYPE;

Line 9346: l_db_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;

9342: IS
9343: l_api_name CONSTANT VARCHAR2 (30) := 'UPDATE_PENDING_PRODUCT_LOT';
9344:
9345: l_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;
9346: l_db_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;
9347: l_in_material_detail_rec gme_material_details%ROWTYPE;
9348: l_in_batch_header_rec gme_batch_header%ROWTYPE;
9349: l_material_detail_rec gme_material_details%ROWTYPE;
9350: l_batch_header_rec gme_batch_header%ROWTYPE;

Line 9384: IF NOT gme_pending_product_lots_dbl.fetch_row

9380: RAISE fnd_api.g_exc_error;
9381: END IF;
9382:
9383: IF p_pending_product_lots_rec.pending_product_lot_id IS NOT NULL THEN
9384: IF NOT gme_pending_product_lots_dbl.fetch_row
9385: (p_pending_product_lots_rec => p_pending_product_lots_rec
9386: ,x_pending_product_lots_rec => l_db_pending_product_lots_rec) THEN
9387: x_return_status := fnd_api.g_ret_sts_error;
9388: RAISE fnd_api.g_exc_error;

Line 9441: gme_pending_product_lots_pvt.validate_material_for_update

9437: END IF;
9438: END IF;
9439:
9440: -- Validations
9441: gme_pending_product_lots_pvt.validate_material_for_update
9442: (p_batch_header_rec => l_batch_header_rec
9443: ,p_material_detail_rec => l_material_detail_rec
9444: ,x_return_status => x_return_status);
9445:

Line 9450: gme_pending_product_lots_pvt.validate_record_for_update

9446: IF x_return_status <> fnd_api.g_ret_sts_success THEN
9447: RAISE fnd_api.g_exc_error;
9448: END IF;
9449:
9450: gme_pending_product_lots_pvt.validate_record_for_update
9451: (p_material_detail_rec => l_material_detail_rec
9452: ,p_db_pending_product_lots_rec => l_db_pending_product_lots_rec
9453: ,p_pending_product_lots_rec => p_pending_product_lots_rec
9454: ,x_pending_product_lots_rec => l_pending_product_lots_rec

Line 9578: ,p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE)

9574: ,x_return_status OUT NOCOPY VARCHAR2
9575: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
9576: ,p_org_code IN VARCHAR2
9577: ,p_material_detail_rec IN gme_material_details%ROWTYPE
9578: ,p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE)
9579: IS
9580: l_api_name CONSTANT VARCHAR2 (30) := 'DELETE_PENDING_PRODUCT_LOT';
9581:
9582: l_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;

Line 9582: l_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;

9578: ,p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE)
9579: IS
9580: l_api_name CONSTANT VARCHAR2 (30) := 'DELETE_PENDING_PRODUCT_LOT';
9581:
9582: l_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;
9583: l_db_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;
9584: l_in_material_detail_rec gme_material_details%ROWTYPE;
9585: l_in_batch_header_rec gme_batch_header%ROWTYPE;
9586: l_material_detail_rec gme_material_details%ROWTYPE;

Line 9583: l_db_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;

9579: IS
9580: l_api_name CONSTANT VARCHAR2 (30) := 'DELETE_PENDING_PRODUCT_LOT';
9581:
9582: l_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;
9583: l_db_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;
9584: l_in_material_detail_rec gme_material_details%ROWTYPE;
9585: l_in_batch_header_rec gme_batch_header%ROWTYPE;
9586: l_material_detail_rec gme_material_details%ROWTYPE;
9587: l_batch_header_rec gme_batch_header%ROWTYPE;

Line 9627: IF NOT gme_pending_product_lots_dbl.fetch_row

9623: RAISE fnd_api.g_exc_error;
9624: END IF;
9625:
9626: IF p_pending_product_lots_rec.pending_product_lot_id IS NOT NULL THEN
9627: IF NOT gme_pending_product_lots_dbl.fetch_row
9628: (p_pending_product_lots_rec => p_pending_product_lots_rec
9629: ,x_pending_product_lots_rec => l_db_pending_product_lots_rec) THEN
9630: x_return_status := fnd_api.g_ret_sts_error;
9631: RAISE fnd_api.g_exc_error;

Line 9682: gme_pending_product_lots_pvt.validate_material_for_delete

9678: RAISE fnd_api.g_exc_error;
9679: END IF;
9680: END IF;
9681: -- Validations
9682: gme_pending_product_lots_pvt.validate_material_for_delete
9683: (p_batch_header_rec => l_batch_header_rec
9684: ,p_material_detail_rec => l_material_detail_rec
9685: ,x_return_status => x_return_status);
9686:

Line 9691: gme_pending_product_lots_pvt.validate_record_for_delete

9687: IF x_return_status <> fnd_api.g_ret_sts_success THEN
9688: RAISE fnd_api.g_exc_error;
9689: END IF;
9690:
9691: gme_pending_product_lots_pvt.validate_record_for_delete
9692: (p_material_detail_rec => l_material_detail_rec
9693: ,p_db_pending_product_lots_rec => l_db_pending_product_lots_rec
9694: ,p_pending_product_lots_rec => p_pending_product_lots_rec
9695: ,x_pending_product_lots_rec => l_pending_product_lots_rec