APPS.INV_CYC_LOVS dependencies on SERIAL_CHECK

Line 426: IF ( NOT MTL_Serial_Check.inv_serial_info ( p_from_serial_number => p_from_serial_number,

422: print_debug ( 'Single Serial controlled item' );
423: END IF;
424:
425: -- Call this API to parse the serial numbers into prefixes and numbers
426: IF ( NOT MTL_Serial_Check.inv_serial_info ( p_from_serial_number => p_from_serial_number,
427: p_to_serial_number => p_to_serial_number,
428: x_prefix => l_prefix,
429: x_quantity => l_quantity,
430: x_from_number => l_from_number,

Line 5526: -- mtl_serial_check.inv_qtybetwn approved our Serial_Number and

5522: END IF;
5523: END IF;
5524:
5525: IF ( l_success = FALSE ) THEN
5526: -- mtl_serial_check.inv_qtybetwn approved our Serial_Number and
5527: -- inserted into MTL_SERIAL_NUMBERS table (If needed).
5528: -- Now we need to perform necessary adjustment transactions.
5529:
5530: IF ( l_debug = 1 ) THEN

Line 6283: print_debug ( 'Calling the package mtl_serial_check.inv_qtybetwn' );

6279: u14 := l_msn_locator_id;
6280: END IF;
6281:
6282: IF ( l_debug = 1 ) THEN
6283: print_debug ( 'Calling the package mtl_serial_check.inv_qtybetwn' );
6284: print_debug ( 'Inputs to API are: ' );
6285: print_debug ( 'p_from_serial_number: =========> ' || u1 );
6286: print_debug ( 'p_to_serial_number: ===========> ' || u2 );
6287: print_debug ( 'p_item_id: ====================> ' || u5 );

Line 6301: mtl_serial_check.inv_qtybetwn ( p_api_version => 0.9,

6297: print_debug ( 'p_receipt_issue_flag: =========> ' || u15 );
6298: END IF;
6299:
6300: -- Call package in file INVSERLB.PLS instead of a USER_EXIT
6301: mtl_serial_check.inv_qtybetwn ( p_api_version => 0.9,
6302: x_return_status => l_return_status,
6303: x_msg_count => l_msg_count,
6304: x_msg_data => l_msg_data,
6305: x_errorcode => l_error_code,

Line 7128: print_debug ( 'Calling serial_check.inv_mark_serial with the following parameters: '

7124: IF ( ( l_serial_number_ctrl_code IN ( 2, 5 ) )
7125: AND ( l_serial_count_option = 2 )
7126: ) THEN
7127: IF ( l_debug = 1 ) THEN
7128: print_debug ( 'Calling serial_check.inv_mark_serial with the following parameters: '
7129: );
7130: print_debug ( 'from_serial_number: => ' || g1 );
7131: print_debug ( 'to_serial_number: ===> ' || g2 );
7132: print_debug ( 'item_id: ============> ' || g3 );

Line 7140: serial_check.inv_mark_serial ( from_serial_number => g1,

7136: print_debug ( 'lot_temp_id: ========> ' || g7 );
7137: print_debug ( ' ' );
7138: END IF;
7139:
7140: serial_check.inv_mark_serial ( from_serial_number => g1,
7141: to_serial_number => g2,
7142: item_id => g3,
7143: org_id => g4,
7144: hdr_id => g5,

Line 7211: -- Old call to serial_check.inv_unmark_serial

7207: l_current_item
7208: FROM mtl_cycle_count_entries
7209: WHERE cycle_count_entry_id = cycle_cnt_entry_id;
7210:
7211: -- Old call to serial_check.inv_unmark_serial
7212: --g1 := NULL;
7213: --g2 := NULL;
7214: --g3 := l_serial_number_ctrl_code;
7215: --g4 := g_cc_entry.cycle_count_header_id;

Line 7219: -- New call to serial_check.inv_unmark_serial

7215: --g4 := g_cc_entry.cycle_count_header_id;
7216: --g5 := cycle_cnt_entry_id;
7217: --g6 := NULL;
7218:
7219: -- New call to serial_check.inv_unmark_serial
7220: -- For performance reasons, pass the serial number and item id
7221: -- instead since these are the primary keys for MTL_SERIAL_NUMBERS
7222: IF ( l_serial_number_ctrl_code IN ( 2, 5 ) ) THEN
7223: IF ( l_serial_count_option = 2 ) THEN

Line 7251: print_debug ( 'Calling serial_check.inv_unmark_serial with the following parameters: '

7247: IF ( ( l_serial_number_ctrl_code IN ( 2, 5 ) )
7248: AND ( l_serial_count_option = 2 )
7249: ) THEN
7250: IF ( l_debug = 1 ) THEN
7251: print_debug ( 'Calling serial_check.inv_unmark_serial with the following parameters: '
7252: );
7253: print_debug ( 'from_serial_number: ==> ' || g1 );
7254: print_debug ( 'to_serial_number: ====> ' || g2 );
7255: print_debug ( 'serial_code: =========> ' || g3 );

Line 7263: serial_check.inv_unmark_serial ( from_serial_number => g1,

7259: print_debug ( 'p_inventory_item_id: => ' || g7 );
7260: print_debug ( ' ' );
7261: END IF;
7262:
7263: serial_check.inv_unmark_serial ( from_serial_number => g1,
7264: to_serial_number => g2,
7265: serial_code => g3,
7266: hdr_id => g4,
7267: temp_id => g5,

Line 8732: serial_check.inv_mark_serial ( from_serial_number => p_from_serial_number,

8728: END IF;
8729: END LOOP;
8730:
8731: l_progress := '90';
8732: serial_check.inv_mark_serial ( from_serial_number => p_from_serial_number,
8733: to_serial_number => p_to_serial_number,
8734: item_id => p_inventory_item_id,
8735: org_id => p_organization_id,
8736: hdr_id => NULL,

Line 8919: serial_check.inv_mark_serial ( from_serial_number => p_from_serial_number,

8915: RAISE FND_API.G_EXC_ERROR;
8916: END IF;
8917:
8918: l_progress := '50';
8919: serial_check.inv_mark_serial ( from_serial_number => p_from_serial_number,
8920: to_serial_number => p_to_serial_number,
8921: item_id => p_inventory_item_id,
8922: org_id => p_organization_id,
8923: hdr_id => NULL,