APPS.WMS_RETURN_SV dependencies on INV_TRX_UTIL_PUB

Line 3268: print_debug('Before call to inv_trx_util_pub.insert_line_trx ' || p_lpn_id);

3264: FROM dual; */
3265:
3266: IF (l_debug = 1) THEN
3267: print_debug('Inside CallUnpack for for lpn_content_id ' || l_unpack_rec.lpn_content_id);
3268: print_debug('Before call to inv_trx_util_pub.insert_line_trx ' || p_lpn_id);
3269: END IF;
3270:
3271: l_return_status := inv_trx_util_pub.insert_line_trx( p_trx_hdr_id => p_trx_header_id
3272: , p_item_id => l_item_id

Line 3271: l_return_status := inv_trx_util_pub.insert_line_trx( p_trx_hdr_id => p_trx_header_id

3267: print_debug('Inside CallUnpack for for lpn_content_id ' || l_unpack_rec.lpn_content_id);
3268: print_debug('Before call to inv_trx_util_pub.insert_line_trx ' || p_lpn_id);
3269: END IF;
3270:
3271: l_return_status := inv_trx_util_pub.insert_line_trx( p_trx_hdr_id => p_trx_header_id
3272: , p_item_id => l_item_id
3273: , p_revision => l_revision
3274: , p_org_id => l_org_id
3275: , p_trx_action_id => l_trx_action_id

Line 3306: l_return_status := inv_trx_util_pub.insert_lot_trx( p_trx_tmp_id => l_trx_tmp_id,

3302: LOOP
3303: IF (l_debug = 1) THEN
3304: print_debug('Inside loop for Lot ' || l_unpack_rec.lot_number);
3305: END IF;
3306: l_return_status := inv_trx_util_pub.insert_lot_trx( p_trx_tmp_id => l_trx_tmp_id,
3307: p_user_id => l_user_id,
3308: p_lot_number => l_unpack_rec.lot_number,
3309: p_exp_date => l_mtlt_rec.expiration_date,
3310: p_origination_date => l_mtlt_rec.origination_date,

Line 3345: l_return_status := inv_trx_util_pub.insert_ser_trx( p_trx_tmp_id => l_trx_tmp_id,

3341: IF (l_debug = 1) THEN
3342: print_debug('Before calling insert Serial transaction ' || l_unpack_rec.lpn_id);
3343: END IF;
3344:
3345: l_return_status := inv_trx_util_pub.insert_ser_trx( p_trx_tmp_id => l_trx_tmp_id,
3346: p_user_id => l_user_id,
3347: p_fm_ser_num => l_msnt_rec.serial_number,
3348: p_to_ser_num => l_msnt_rec.serial_number,
3349: x_proc_msg => l_msg_data );