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 6253: inv_log_util.trace('About to call inv_serial_number_pub.validate_serials', 'INV_TXN_MANAGER_GRP', 9);

6249: -- Looping through every serials in the lot
6250: FOR rec_MSNI IN cur_MSNI(rec_MTLI.SERIAL_TRANSACTION_TEMP_ID)
6251: LOOP
6252: IF (l_debug=1) THEN
6253: inv_log_util.trace('About to call inv_serial_number_pub.validate_serials', 'INV_TXN_MANAGER_GRP', 9);
6254: END IF;
6255:
6256: l_qty := NULL;
6257: l_end_ser := NVL(rec_MSNI.TO_SERIAL_NUMBER,rec_MSNI.FM_SERIAL_NUMBER);

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

6254: END IF;
6255:
6256: l_qty := NULL;
6257: l_end_ser := NVL(rec_MSNI.TO_SERIAL_NUMBER,rec_MSNI.FM_SERIAL_NUMBER);
6258: l_start_qty := inv_serial_number_pub.get_serial_diff(rec_MSNI.FM_SERIAL_NUMBER,l_end_ser);
6259: l_ret_number := inv_serial_number_pub.validate_serials(
6260: p_org_id => p_org_id
6261: , p_item_id => p_item_id
6262: , p_qty => l_qty

Line 6259: l_ret_number := inv_serial_number_pub.validate_serials(

6255:
6256: l_qty := NULL;
6257: l_end_ser := NVL(rec_MSNI.TO_SERIAL_NUMBER,rec_MSNI.FM_SERIAL_NUMBER);
6258: l_start_qty := inv_serial_number_pub.get_serial_diff(rec_MSNI.FM_SERIAL_NUMBER,l_end_ser);
6259: l_ret_number := inv_serial_number_pub.validate_serials(
6260: p_org_id => p_org_id
6261: , p_item_id => p_item_id
6262: , p_qty => l_qty
6263: , p_rev => p_rev

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

6281: END IF;
6282: RETURN;
6283: END IF; -- End of group mark validations
6284: IF (l_debug=1) THEN
6285: inv_log_util.trace('After call to inv_serial_number_pub.validate_serials', 'INV_TXN_MANAGER_GRP', 9);
6286: inv_log_util.trace(' l_ret_number : ' || l_ret_number, 'INV_TXN_MANAGER_GRP', 9);
6287: END IF;
6288: IF (l_ret_number = 0) THEN -- Success from inv_serial_number_pub.validate_serials
6289: x_return_status := lg_ret_sts_success;

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

6284: IF (l_debug=1) THEN
6285: inv_log_util.trace('After call to inv_serial_number_pub.validate_serials', 'INV_TXN_MANAGER_GRP', 9);
6286: inv_log_util.trace(' l_ret_number : ' || l_ret_number, 'INV_TXN_MANAGER_GRP', 9);
6287: END IF;
6288: IF (l_ret_number = 0) THEN -- Success from inv_serial_number_pub.validate_serials
6289: x_return_status := lg_ret_sts_success;
6290: IF (l_debug = 1) THEN
6291: inv_log_util.trace('Call to inv_serial_number_pub.validate_serials was successful','INV_TXN_MANAGER_GRP', 9);
6292: END IF;

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

6287: END IF;
6288: IF (l_ret_number = 0) THEN -- Success from inv_serial_number_pub.validate_serials
6289: x_return_status := lg_ret_sts_success;
6290: IF (l_debug = 1) THEN
6291: inv_log_util.trace('Call to inv_serial_number_pub.validate_serials was successful','INV_TXN_MANAGER_GRP', 9);
6292: END IF;
6293: ELSIF (l_ret_number = 1) THEN
6294: x_return_status := lg_ret_sts_error;
6295: loaderrmsg('INV_INT_SERMISCODE','INV_LOT_SERIAL_VALIDATION_FAIL');

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

6293: ELSIF (l_ret_number = 1) THEN
6294: x_return_status := lg_ret_sts_error;
6295: loaderrmsg('INV_INT_SERMISCODE','INV_LOT_SERIAL_VALIDATION_FAIL');
6296: IF (l_debug = 1) THEN
6297: inv_log_util.trace('Error from inv_serial_number_pub.validate_serials'|| x_proc_msg || ':' || sqlerrm,'INV_TXN_MANAGER_GRP', 9);
6298: END IF;
6299: RETURN;
6300: END IF;
6301: END LOOP; -- End of cur_MSNI cursor

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

6319: LOOP
6320:
6321: l_qty := NULL;
6322: l_end_ser := NVL(rec_MSNI.TO_SERIAL_NUMBER,rec_MSNI.FM_SERIAL_NUMBER);
6323: l_start_qty := inv_serial_number_pub.get_serial_diff(rec_MSNI.FM_SERIAL_NUMBER,l_end_ser);
6324: IF (l_debug=1) THEN
6325: inv_log_util.trace('About to call inv_serial_number_pub.validate_serials', 'INV_TXN_MANAGER_GRP', 9);
6326: END IF;
6327: l_ret_number := inv_serial_number_pub.validate_serials(

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

6321: l_qty := NULL;
6322: l_end_ser := NVL(rec_MSNI.TO_SERIAL_NUMBER,rec_MSNI.FM_SERIAL_NUMBER);
6323: l_start_qty := inv_serial_number_pub.get_serial_diff(rec_MSNI.FM_SERIAL_NUMBER,l_end_ser);
6324: IF (l_debug=1) THEN
6325: inv_log_util.trace('About to call inv_serial_number_pub.validate_serials', 'INV_TXN_MANAGER_GRP', 9);
6326: END IF;
6327: l_ret_number := inv_serial_number_pub.validate_serials(
6328: p_org_id => p_org_id
6329: , p_item_id => p_item_id

Line 6327: l_ret_number := inv_serial_number_pub.validate_serials(

6323: l_start_qty := inv_serial_number_pub.get_serial_diff(rec_MSNI.FM_SERIAL_NUMBER,l_end_ser);
6324: IF (l_debug=1) THEN
6325: inv_log_util.trace('About to call inv_serial_number_pub.validate_serials', 'INV_TXN_MANAGER_GRP', 9);
6326: END IF;
6327: l_ret_number := inv_serial_number_pub.validate_serials(
6328: p_org_id => p_org_id
6329: , p_item_id => p_item_id
6330: , p_qty => l_qty
6331: , p_rev => p_rev

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

6349: END IF;
6350: RETURN;
6351: END IF; -- End of check for group mark validations
6352: IF (l_debug=1) THEN
6353: inv_log_util.trace('After call to inv_serial_number_pub.validate_serials', 'INV_TXN_MANAGER_GRP', 9);
6354: inv_log_util.trace(' l_ret_number : ' || l_ret_number, 'INV_TXN_MANAGER_GRP', 9);
6355: END IF;
6356:
6357: IF (l_ret_number = 0) THEN -- Success from inv_serial_number_pub.validate_serials

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

6353: inv_log_util.trace('After call to inv_serial_number_pub.validate_serials', 'INV_TXN_MANAGER_GRP', 9);
6354: inv_log_util.trace(' l_ret_number : ' || l_ret_number, 'INV_TXN_MANAGER_GRP', 9);
6355: END IF;
6356:
6357: IF (l_ret_number = 0) THEN -- Success from inv_serial_number_pub.validate_serials
6358: x_return_status := lg_ret_sts_success;
6359: IF (l_debug = 1) THEN
6360: inv_log_util.trace('Call to inv_serial_number_pub.validate_serials was successful','INV_TXN_MANAGER_GRP', 9);
6361: END IF;

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

6356:
6357: IF (l_ret_number = 0) THEN -- Success from inv_serial_number_pub.validate_serials
6358: x_return_status := lg_ret_sts_success;
6359: IF (l_debug = 1) THEN
6360: inv_log_util.trace('Call to inv_serial_number_pub.validate_serials was successful','INV_TXN_MANAGER_GRP', 9);
6361: END IF;
6362: ELSIF (l_ret_number = 1) THEN -- Failure from inv_serial_number_pub.validate_serials
6363: x_return_status := lg_ret_sts_error;
6364: loaderrmsg('INV_INT_SERMISCODE','INV_LOT_SERIAL_VALIDATION_FAIL');

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

6358: x_return_status := lg_ret_sts_success;
6359: IF (l_debug = 1) THEN
6360: inv_log_util.trace('Call to inv_serial_number_pub.validate_serials was successful','INV_TXN_MANAGER_GRP', 9);
6361: END IF;
6362: ELSIF (l_ret_number = 1) THEN -- Failure from inv_serial_number_pub.validate_serials
6363: x_return_status := lg_ret_sts_error;
6364: loaderrmsg('INV_INT_SERMISCODE','INV_LOT_SERIAL_VALIDATION_FAIL');
6365: IF (l_debug = 1) THEN
6366: inv_log_util.trace('Error from inv_serial_number_pub.validate_serials'|| x_proc_msg || ':' || sqlerrm,'INV_TXN_MANAGER_GRP', 9);

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

6362: ELSIF (l_ret_number = 1) THEN -- Failure from inv_serial_number_pub.validate_serials
6363: x_return_status := lg_ret_sts_error;
6364: loaderrmsg('INV_INT_SERMISCODE','INV_LOT_SERIAL_VALIDATION_FAIL');
6365: IF (l_debug = 1) THEN
6366: inv_log_util.trace('Error from inv_serial_number_pub.validate_serials'|| x_proc_msg || ':' || sqlerrm,'INV_TXN_MANAGER_GRP', 9);
6367: END IF;
6368: RETURN;
6369: END IF;
6370:

Line 6783: inv_serial_number_pub.is_serial_controlled(

6779: END IF;
6780: END IF;--J-dev
6781:
6782: --serial tagging
6783: inv_serial_number_pub.is_serial_controlled(
6784: l_itemid,
6785: l_orgid,
6786: NULL,
6787: l_trxtype,

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

11333: || ' where mti.parent_id = :b_parent_id'
11334: || ' and mti.transaction_interface_id <> mti.parent_id'
11335: || ' and mtli.transaction_interface_id = mti.transaction_interface_id'
11336: || ' and msni.transaction_interface_id = mtli.serial_transaction_temp_id'
11337: || ' AND inv_serial_number_pub.get_serial_diff(msni.fm_serial_number,:b_serial_number) <> -1'
11338: || ' and inv_serial_number_pub.get_serial_diff(msni.fm_serial_number,nvl(msni.to_serial_number,msni.fm_serial_number)) >='
11339: || ' inv_serial_number_pub.get_serial_diff(msni.fm_serial_number,:b_serial_number)'
11340: || ' AND msn.serial_number = :b_serial_number'
11341: || ' AND msn.inventory_item_id = mti.inventory_item_id '

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

11334: || ' and mti.transaction_interface_id <> mti.parent_id'
11335: || ' and mtli.transaction_interface_id = mti.transaction_interface_id'
11336: || ' and msni.transaction_interface_id = mtli.serial_transaction_temp_id'
11337: || ' AND inv_serial_number_pub.get_serial_diff(msni.fm_serial_number,:b_serial_number) <> -1'
11338: || ' and inv_serial_number_pub.get_serial_diff(msni.fm_serial_number,nvl(msni.to_serial_number,msni.fm_serial_number)) >='
11339: || ' inv_serial_number_pub.get_serial_diff(msni.fm_serial_number,:b_serial_number)'
11340: || ' AND msn.serial_number = :b_serial_number'
11341: || ' AND msn.inventory_item_id = mti.inventory_item_id '
11342: || ' AND msn.current_organization_id = mti.organization_id ';

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

11335: || ' and mtli.transaction_interface_id = mti.transaction_interface_id'
11336: || ' and msni.transaction_interface_id = mtli.serial_transaction_temp_id'
11337: || ' AND inv_serial_number_pub.get_serial_diff(msni.fm_serial_number,:b_serial_number) <> -1'
11338: || ' and inv_serial_number_pub.get_serial_diff(msni.fm_serial_number,nvl(msni.to_serial_number,msni.fm_serial_number)) >='
11339: || ' inv_serial_number_pub.get_serial_diff(msni.fm_serial_number,:b_serial_number)'
11340: || ' AND msn.serial_number = :b_serial_number'
11341: || ' AND msn.inventory_item_id = mti.inventory_item_id '
11342: || ' AND msn.current_organization_id = mti.organization_id ';
11343: */

Line 12840: inv_serial_number_pub.get_serial_diff

12836: FOR l_ser_csr IN msni_csr (l_mtli_csr.serial_transaction_temp_id)
12837: LOOP
12838: l_next_serial := l_ser_csr.fm_serial_number;
12839: l_serial_diff :=
12840: inv_serial_number_pub.get_serial_diff
12841: (l_ser_csr.fm_serial_number
12842: , l_ser_csr.to_serial_number
12843: );
12844:

Line 13402: inv_serial_number_pub.increment_ser_num

13398: , l_ser_csr.number_of_repairs
13399: );
13400: END IF;
13401: l_next_serial :=
13402: inv_serial_number_pub.increment_ser_num
13403: (l_old_serial
13404: , 1
13405: );
13406:

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

16305: FUNCTION get_serial_diff_wrp(p_fm_serial IN VARCHAR2, p_to_serial IN VARCHAR2)
16306: RETURN NUMBER AS
16307: l_qty NUMBER := 0;
16308: BEGIN
16309: l_qty := inv_serial_number_pub.get_serial_diff(p_fm_serial, p_to_serial);
16310: IF (l_qty <= 0) THEN
16311: return 0;
16312: ELSE
16313: return l_qty;