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.INV_TXN_MANAGER_GRP dependencies on INV_SERIAL_NUMBER_PUB

Line 5874: inv_log_util.trace('About to call inv_serial_number_pub.validate_serials', 'INV_TXN_MANAGER_GRP', 9);

5870: -- Looping through every serials in the lot
5871: FOR rec_MSNI IN cur_MSNI(rec_MTLI.SERIAL_TRANSACTION_TEMP_ID)
5872: LOOP
5873: IF (l_debug=1) THEN
5874: inv_log_util.trace('About to call inv_serial_number_pub.validate_serials', 'INV_TXN_MANAGER_GRP', 9);
5875: END IF;
5876:
5877: l_qty := NULL;
5878: l_end_ser := NVL(rec_MSNI.TO_SERIAL_NUMBER,rec_MSNI.FM_SERIAL_NUMBER);

Line 5879: l_start_qty := inv_serial_number_pub.get_serial_diff(rec_MSNI.FM_SERIAL_NUMBER,l_end_ser);

5875: END IF;
5876:
5877: l_qty := NULL;
5878: l_end_ser := NVL(rec_MSNI.TO_SERIAL_NUMBER,rec_MSNI.FM_SERIAL_NUMBER);
5879: l_start_qty := inv_serial_number_pub.get_serial_diff(rec_MSNI.FM_SERIAL_NUMBER,l_end_ser);
5880: l_ret_number := inv_serial_number_pub.validate_serials(
5881: p_org_id => p_org_id
5882: , p_item_id => p_item_id
5883: , p_qty => l_qty

Line 5880: l_ret_number := inv_serial_number_pub.validate_serials(

5876:
5877: l_qty := NULL;
5878: l_end_ser := NVL(rec_MSNI.TO_SERIAL_NUMBER,rec_MSNI.FM_SERIAL_NUMBER);
5879: l_start_qty := inv_serial_number_pub.get_serial_diff(rec_MSNI.FM_SERIAL_NUMBER,l_end_ser);
5880: l_ret_number := inv_serial_number_pub.validate_serials(
5881: p_org_id => p_org_id
5882: , p_item_id => p_item_id
5883: , p_qty => l_qty
5884: , p_rev => p_rev

Line 5906: inv_log_util.trace('After call to inv_serial_number_pub.validate_serials', 'INV_TXN_MANAGER_GRP', 9);

5902: END IF;
5903: RETURN;
5904: END IF; -- End of group mark validations
5905: IF (l_debug=1) THEN
5906: inv_log_util.trace('After call to inv_serial_number_pub.validate_serials', 'INV_TXN_MANAGER_GRP', 9);
5907: inv_log_util.trace(' l_ret_number : ' || l_ret_number, 'INV_TXN_MANAGER_GRP', 9);
5908: END IF;
5909: IF (l_ret_number = 0) THEN -- Success from inv_serial_number_pub.validate_serials
5910: x_return_status := lg_ret_sts_success;

Line 5909: IF (l_ret_number = 0) THEN -- Success from inv_serial_number_pub.validate_serials

5905: IF (l_debug=1) THEN
5906: inv_log_util.trace('After call to inv_serial_number_pub.validate_serials', 'INV_TXN_MANAGER_GRP', 9);
5907: inv_log_util.trace(' l_ret_number : ' || l_ret_number, 'INV_TXN_MANAGER_GRP', 9);
5908: END IF;
5909: IF (l_ret_number = 0) THEN -- Success from inv_serial_number_pub.validate_serials
5910: x_return_status := lg_ret_sts_success;
5911: IF (l_debug = 1) THEN
5912: inv_log_util.trace('Call to inv_serial_number_pub.validate_serials was successful','INV_TXN_MANAGER_GRP', 9);
5913: END IF;

Line 5912: inv_log_util.trace('Call to inv_serial_number_pub.validate_serials was successful','INV_TXN_MANAGER_GRP', 9);

5908: END IF;
5909: IF (l_ret_number = 0) THEN -- Success from inv_serial_number_pub.validate_serials
5910: x_return_status := lg_ret_sts_success;
5911: IF (l_debug = 1) THEN
5912: inv_log_util.trace('Call to inv_serial_number_pub.validate_serials was successful','INV_TXN_MANAGER_GRP', 9);
5913: END IF;
5914: ELSIF (l_ret_number = 1) THEN
5915: x_return_status := lg_ret_sts_error;
5916: loaderrmsg('INV_INT_SERMISCODE','INV_LOT_SERIAL_VALIDATION_FAIL');

Line 5918: inv_log_util.trace('Error from inv_serial_number_pub.validate_serials'|| x_proc_msg || ':' || sqlerrm,'INV_TXN_MANAGER_GRP', 9);

5914: ELSIF (l_ret_number = 1) THEN
5915: x_return_status := lg_ret_sts_error;
5916: loaderrmsg('INV_INT_SERMISCODE','INV_LOT_SERIAL_VALIDATION_FAIL');
5917: IF (l_debug = 1) THEN
5918: inv_log_util.trace('Error from inv_serial_number_pub.validate_serials'|| x_proc_msg || ':' || sqlerrm,'INV_TXN_MANAGER_GRP', 9);
5919: END IF;
5920: RETURN;
5921: END IF;
5922: END LOOP; -- End of cur_MSNI cursor

Line 5944: l_start_qty := inv_serial_number_pub.get_serial_diff(rec_MSNI.FM_SERIAL_NUMBER,l_end_ser);

5940: LOOP
5941:
5942: l_qty := NULL;
5943: l_end_ser := NVL(rec_MSNI.TO_SERIAL_NUMBER,rec_MSNI.FM_SERIAL_NUMBER);
5944: l_start_qty := inv_serial_number_pub.get_serial_diff(rec_MSNI.FM_SERIAL_NUMBER,l_end_ser);
5945: IF (l_debug=1) THEN
5946: inv_log_util.trace('About to call inv_serial_number_pub.validate_serials', 'INV_TXN_MANAGER_GRP', 9);
5947: END IF;
5948: l_ret_number := inv_serial_number_pub.validate_serials(

Line 5946: inv_log_util.trace('About to call inv_serial_number_pub.validate_serials', 'INV_TXN_MANAGER_GRP', 9);

5942: l_qty := NULL;
5943: l_end_ser := NVL(rec_MSNI.TO_SERIAL_NUMBER,rec_MSNI.FM_SERIAL_NUMBER);
5944: l_start_qty := inv_serial_number_pub.get_serial_diff(rec_MSNI.FM_SERIAL_NUMBER,l_end_ser);
5945: IF (l_debug=1) THEN
5946: inv_log_util.trace('About to call inv_serial_number_pub.validate_serials', 'INV_TXN_MANAGER_GRP', 9);
5947: END IF;
5948: l_ret_number := inv_serial_number_pub.validate_serials(
5949: p_org_id => p_org_id
5950: , p_item_id => p_item_id

Line 5948: l_ret_number := inv_serial_number_pub.validate_serials(

5944: l_start_qty := inv_serial_number_pub.get_serial_diff(rec_MSNI.FM_SERIAL_NUMBER,l_end_ser);
5945: IF (l_debug=1) THEN
5946: inv_log_util.trace('About to call inv_serial_number_pub.validate_serials', 'INV_TXN_MANAGER_GRP', 9);
5947: END IF;
5948: l_ret_number := inv_serial_number_pub.validate_serials(
5949: p_org_id => p_org_id
5950: , p_item_id => p_item_id
5951: , p_qty => l_qty
5952: , p_rev => p_rev

Line 5974: inv_log_util.trace('After call to inv_serial_number_pub.validate_serials', 'INV_TXN_MANAGER_GRP', 9);

5970: END IF;
5971: RETURN;
5972: END IF; -- End of check for group mark validations
5973: IF (l_debug=1) THEN
5974: inv_log_util.trace('After call to inv_serial_number_pub.validate_serials', 'INV_TXN_MANAGER_GRP', 9);
5975: inv_log_util.trace(' l_ret_number : ' || l_ret_number, 'INV_TXN_MANAGER_GRP', 9);
5976: END IF;
5977:
5978: IF (l_ret_number = 0) THEN -- Success from inv_serial_number_pub.validate_serials

Line 5978: IF (l_ret_number = 0) THEN -- Success from inv_serial_number_pub.validate_serials

5974: inv_log_util.trace('After call to inv_serial_number_pub.validate_serials', 'INV_TXN_MANAGER_GRP', 9);
5975: inv_log_util.trace(' l_ret_number : ' || l_ret_number, 'INV_TXN_MANAGER_GRP', 9);
5976: END IF;
5977:
5978: IF (l_ret_number = 0) THEN -- Success from inv_serial_number_pub.validate_serials
5979: x_return_status := lg_ret_sts_success;
5980: IF (l_debug = 1) THEN
5981: inv_log_util.trace('Call to inv_serial_number_pub.validate_serials was successful','INV_TXN_MANAGER_GRP', 9);
5982: END IF;

Line 5981: inv_log_util.trace('Call to inv_serial_number_pub.validate_serials was successful','INV_TXN_MANAGER_GRP', 9);

5977:
5978: IF (l_ret_number = 0) THEN -- Success from inv_serial_number_pub.validate_serials
5979: x_return_status := lg_ret_sts_success;
5980: IF (l_debug = 1) THEN
5981: inv_log_util.trace('Call to inv_serial_number_pub.validate_serials was successful','INV_TXN_MANAGER_GRP', 9);
5982: END IF;
5983: ELSIF (l_ret_number = 1) THEN -- Failure from inv_serial_number_pub.validate_serials
5984: x_return_status := lg_ret_sts_error;
5985: loaderrmsg('INV_INT_SERMISCODE','INV_LOT_SERIAL_VALIDATION_FAIL');

Line 5983: ELSIF (l_ret_number = 1) THEN -- Failure from inv_serial_number_pub.validate_serials

5979: x_return_status := lg_ret_sts_success;
5980: IF (l_debug = 1) THEN
5981: inv_log_util.trace('Call to inv_serial_number_pub.validate_serials was successful','INV_TXN_MANAGER_GRP', 9);
5982: END IF;
5983: ELSIF (l_ret_number = 1) THEN -- Failure from inv_serial_number_pub.validate_serials
5984: x_return_status := lg_ret_sts_error;
5985: loaderrmsg('INV_INT_SERMISCODE','INV_LOT_SERIAL_VALIDATION_FAIL');
5986: IF (l_debug = 1) THEN
5987: inv_log_util.trace('Error from inv_serial_number_pub.validate_serials'|| x_proc_msg || ':' || sqlerrm,'INV_TXN_MANAGER_GRP', 9);

Line 5987: inv_log_util.trace('Error from inv_serial_number_pub.validate_serials'|| x_proc_msg || ':' || sqlerrm,'INV_TXN_MANAGER_GRP', 9);

5983: ELSIF (l_ret_number = 1) THEN -- Failure from inv_serial_number_pub.validate_serials
5984: x_return_status := lg_ret_sts_error;
5985: loaderrmsg('INV_INT_SERMISCODE','INV_LOT_SERIAL_VALIDATION_FAIL');
5986: IF (l_debug = 1) THEN
5987: inv_log_util.trace('Error from inv_serial_number_pub.validate_serials'|| x_proc_msg || ':' || sqlerrm,'INV_TXN_MANAGER_GRP', 9);
5988: END IF;
5989: RETURN;
5990: END IF;
5991:

Line 10766: || ' AND inv_serial_number_pub.get_serial_diff(msni.fm_serial_number,:b_serial_number) <> -1'

10762: || ' where mti.parent_id = :b_parent_id'
10763: || ' and mti.transaction_interface_id <> mti.parent_id'
10764: || ' and mtli.transaction_interface_id = mti.transaction_interface_id'
10765: || ' and msni.transaction_interface_id = mtli.serial_transaction_temp_id'
10766: || ' AND inv_serial_number_pub.get_serial_diff(msni.fm_serial_number,:b_serial_number) <> -1'
10767: || ' and inv_serial_number_pub.get_serial_diff(msni.fm_serial_number,nvl(msni.to_serial_number,msni.fm_serial_number)) >='
10768: || ' inv_serial_number_pub.get_serial_diff(msni.fm_serial_number,:b_serial_number)'
10769: || ' AND msn.serial_number = :b_serial_number'
10770: || ' AND msn.inventory_item_id = mti.inventory_item_id '

Line 10767: || ' and inv_serial_number_pub.get_serial_diff(msni.fm_serial_number,nvl(msni.to_serial_number,msni.fm_serial_number)) >='

10763: || ' and mti.transaction_interface_id <> mti.parent_id'
10764: || ' and mtli.transaction_interface_id = mti.transaction_interface_id'
10765: || ' and msni.transaction_interface_id = mtli.serial_transaction_temp_id'
10766: || ' AND inv_serial_number_pub.get_serial_diff(msni.fm_serial_number,:b_serial_number) <> -1'
10767: || ' and inv_serial_number_pub.get_serial_diff(msni.fm_serial_number,nvl(msni.to_serial_number,msni.fm_serial_number)) >='
10768: || ' inv_serial_number_pub.get_serial_diff(msni.fm_serial_number,:b_serial_number)'
10769: || ' AND msn.serial_number = :b_serial_number'
10770: || ' AND msn.inventory_item_id = mti.inventory_item_id '
10771: || ' AND msn.current_organization_id = mti.organization_id ';

Line 10768: || ' inv_serial_number_pub.get_serial_diff(msni.fm_serial_number,:b_serial_number)'

10764: || ' and mtli.transaction_interface_id = mti.transaction_interface_id'
10765: || ' and msni.transaction_interface_id = mtli.serial_transaction_temp_id'
10766: || ' AND inv_serial_number_pub.get_serial_diff(msni.fm_serial_number,:b_serial_number) <> -1'
10767: || ' and inv_serial_number_pub.get_serial_diff(msni.fm_serial_number,nvl(msni.to_serial_number,msni.fm_serial_number)) >='
10768: || ' inv_serial_number_pub.get_serial_diff(msni.fm_serial_number,:b_serial_number)'
10769: || ' AND msn.serial_number = :b_serial_number'
10770: || ' AND msn.inventory_item_id = mti.inventory_item_id '
10771: || ' AND msn.current_organization_id = mti.organization_id ';
10772: */

Line 12269: inv_serial_number_pub.get_serial_diff

12265: FOR l_ser_csr IN msni_csr (l_mtli_csr.serial_transaction_temp_id)
12266: LOOP
12267: l_next_serial := l_ser_csr.fm_serial_number;
12268: l_serial_diff :=
12269: inv_serial_number_pub.get_serial_diff
12270: (l_ser_csr.fm_serial_number
12271: , l_ser_csr.to_serial_number
12272: );
12273:

Line 12831: inv_serial_number_pub.increment_ser_num

12827: , l_ser_csr.number_of_repairs
12828: );
12829: END IF;
12830: l_next_serial :=
12831: inv_serial_number_pub.increment_ser_num
12832: (l_old_serial
12833: , 1
12834: );
12835:

Line 15681: l_qty := inv_serial_number_pub.get_serial_diff(p_fm_serial, p_to_serial);

15677: FUNCTION get_serial_diff_wrp(p_fm_serial IN VARCHAR2, p_to_serial IN VARCHAR2)
15678: RETURN NUMBER AS
15679: l_qty NUMBER := 0;
15680: BEGIN
15681: l_qty := inv_serial_number_pub.get_serial_diff(p_fm_serial, p_to_serial);
15682: IF (l_qty <= 0) THEN
15683: return 0;
15684: ELSE
15685: return l_qty;