APPS.INV_CYC_LOVS dependencies on SERIAL_CHECK

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

366: print_debug ( 'Single Serial controlled item' );
367: END IF;
368:
369: -- Call this API to parse the serial numbers into prefixes and numbers
370: IF ( NOT MTL_Serial_Check.inv_serial_info ( p_from_serial_number => p_from_serial_number,
371: p_to_serial_number => p_to_serial_number,
372: x_prefix => l_prefix,
373: x_quantity => l_quantity,
374: x_from_number => l_from_number,

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

5423: END IF;
5424: END IF;
5425:
5426: IF ( l_success = FALSE ) THEN
5427: -- mtl_serial_check.inv_qtybetwn approved our Serial_Number and
5428: -- inserted into MTL_SERIAL_NUMBERS table (If needed).
5429: -- Now we need to perform necessary adjustment transactions.
5430:
5431: IF ( l_debug = 1 ) THEN

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

6173: u14 := l_msn_locator_id;
6174: END IF;
6175:
6176: IF ( l_debug = 1 ) THEN
6177: print_debug ( 'Calling the package mtl_serial_check.inv_qtybetwn' );
6178: print_debug ( 'Inputs to API are: ' );
6179: print_debug ( 'p_from_serial_number: =========> ' || u1 );
6180: print_debug ( 'p_to_serial_number: ===========> ' || u2 );
6181: print_debug ( 'p_item_id: ====================> ' || u5 );

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

6191: print_debug ( 'p_receipt_issue_flag: =========> ' || u15 );
6192: END IF;
6193:
6194: -- Call package in file INVSERLB.PLS instead of a USER_EXIT
6195: mtl_serial_check.inv_qtybetwn ( p_api_version => 0.9,
6196: x_return_status => l_return_status,
6197: x_msg_count => l_msg_count,
6198: x_msg_data => l_msg_data,
6199: x_errorcode => l_error_code,

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

7015: IF ( ( l_serial_number_ctrl_code IN ( 2, 5 ) )
7016: AND ( l_serial_count_option = 2 )
7017: ) THEN
7018: IF ( l_debug = 1 ) THEN
7019: print_debug ( 'Calling serial_check.inv_mark_serial with the following parameters: '
7020: );
7021: print_debug ( 'from_serial_number: => ' || g1 );
7022: print_debug ( 'to_serial_number: ===> ' || g2 );
7023: print_debug ( 'item_id: ============> ' || g3 );

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

7027: print_debug ( 'lot_temp_id: ========> ' || g7 );
7028: print_debug ( ' ' );
7029: END IF;
7030:
7031: serial_check.inv_mark_serial ( from_serial_number => g1,
7032: to_serial_number => g2,
7033: item_id => g3,
7034: org_id => g4,
7035: hdr_id => g5,

Line 7102: -- Old call to serial_check.inv_unmark_serial

7098: l_current_item
7099: FROM mtl_cycle_count_entries
7100: WHERE cycle_count_entry_id = cycle_cnt_entry_id;
7101:
7102: -- Old call to serial_check.inv_unmark_serial
7103: --g1 := NULL;
7104: --g2 := NULL;
7105: --g3 := l_serial_number_ctrl_code;
7106: --g4 := g_cc_entry.cycle_count_header_id;

Line 7110: -- New call to serial_check.inv_unmark_serial

7106: --g4 := g_cc_entry.cycle_count_header_id;
7107: --g5 := cycle_cnt_entry_id;
7108: --g6 := NULL;
7109:
7110: -- New call to serial_check.inv_unmark_serial
7111: -- For performance reasons, pass the serial number and item id
7112: -- instead since these are the primary keys for MTL_SERIAL_NUMBERS
7113: IF ( l_serial_number_ctrl_code IN ( 2, 5 ) ) THEN
7114: IF ( l_serial_count_option = 2 ) THEN

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

7138: IF ( ( l_serial_number_ctrl_code IN ( 2, 5 ) )
7139: AND ( l_serial_count_option = 2 )
7140: ) THEN
7141: IF ( l_debug = 1 ) THEN
7142: print_debug ( 'Calling serial_check.inv_unmark_serial with the following parameters: '
7143: );
7144: print_debug ( 'from_serial_number: ==> ' || g1 );
7145: print_debug ( 'to_serial_number: ====> ' || g2 );
7146: print_debug ( 'serial_code: =========> ' || g3 );

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

7150: print_debug ( 'p_inventory_item_id: => ' || g7 );
7151: print_debug ( ' ' );
7152: END IF;
7153:
7154: serial_check.inv_unmark_serial ( from_serial_number => g1,
7155: to_serial_number => g2,
7156: serial_code => g3,
7157: hdr_id => g4,
7158: temp_id => g5,

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

8509: END IF;
8510: END LOOP;
8511:
8512: l_progress := '90';
8513: serial_check.inv_mark_serial ( from_serial_number => p_from_serial_number,
8514: to_serial_number => p_to_serial_number,
8515: item_id => p_inventory_item_id,
8516: org_id => p_organization_id,
8517: hdr_id => NULL,

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

8696: RAISE FND_API.G_EXC_ERROR;
8697: END IF;
8698:
8699: l_progress := '50';
8700: serial_check.inv_mark_serial ( from_serial_number => p_from_serial_number,
8701: to_serial_number => p_to_serial_number,
8702: item_id => p_inventory_item_id,
8703: org_id => p_organization_id,
8704: hdr_id => NULL,