2938: l_lot_status_id NUMBER;
2939: l_txn_if_id NUMBER := p_txn_if_id;
2940: l_product_txn_id NUMBER := p_product_txn_id;
2941: l_expiration_date DATE;
2942: l_prod_code VARCHAR2(5) := inv_rcv_integration_apis.G_PROD_CODE;
2943: l_yes VARCHAR2(1) := inv_rcv_integration_apis.G_YES;
2944: l_no VARCHAR2(1) := inv_rcv_integration_apis.G_NO;
2945: l_false VARCHAR2(1) := inv_rcv_integration_apis.G_FALSE;
2946: l_return_status VARCHAR2(1);
2939: l_txn_if_id NUMBER := p_txn_if_id;
2940: l_product_txn_id NUMBER := p_product_txn_id;
2941: l_expiration_date DATE;
2942: l_prod_code VARCHAR2(5) := inv_rcv_integration_apis.G_PROD_CODE;
2943: l_yes VARCHAR2(1) := inv_rcv_integration_apis.G_YES;
2944: l_no VARCHAR2(1) := inv_rcv_integration_apis.G_NO;
2945: l_false VARCHAR2(1) := inv_rcv_integration_apis.G_FALSE;
2946: l_return_status VARCHAR2(1);
2947: l_msg_count NUMBER;
2940: l_product_txn_id NUMBER := p_product_txn_id;
2941: l_expiration_date DATE;
2942: l_prod_code VARCHAR2(5) := inv_rcv_integration_apis.G_PROD_CODE;
2943: l_yes VARCHAR2(1) := inv_rcv_integration_apis.G_YES;
2944: l_no VARCHAR2(1) := inv_rcv_integration_apis.G_NO;
2945: l_false VARCHAR2(1) := inv_rcv_integration_apis.G_FALSE;
2946: l_return_status VARCHAR2(1);
2947: l_msg_count NUMBER;
2948: l_msg_data VARCHAR2(10000);
2941: l_expiration_date DATE;
2942: l_prod_code VARCHAR2(5) := inv_rcv_integration_apis.G_PROD_CODE;
2943: l_yes VARCHAR2(1) := inv_rcv_integration_apis.G_YES;
2944: l_no VARCHAR2(1) := inv_rcv_integration_apis.G_NO;
2945: l_false VARCHAR2(1) := inv_rcv_integration_apis.G_FALSE;
2946: l_return_status VARCHAR2(1);
2947: l_msg_count NUMBER;
2948: l_msg_data VARCHAR2(10000);
2949: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2967: , p_parent_lot_number IN VARCHAR2 DEFAULT NULL--OPM Convergence
2968: , p_reasond_id IN NUMBER DEFAULT NULL--OPM convergence
2969: ); */
2970: --Call the insert_mtli API
2971: inv_rcv_integration_apis.insert_mtli(
2972: p_api_version => 1.0
2973: , p_init_msg_lst => l_false
2974: , x_return_status => l_return_status
2975: , x_msg_count => l_msg_count
3023: --Local variables
3024: l_serial_status_id NUMBER;
3025: l_txn_if_id NUMBER := p_txn_if_id;
3026: l_product_txn_id NUMBER := p_product_txn_id;
3027: l_prod_code VARCHAR2(5) := inv_rcv_integration_apis.G_PROD_CODE;
3028: l_yes VARCHAR2(1) := inv_rcv_integration_apis.G_YES;
3029: l_no VARCHAR2(1) := inv_rcv_integration_apis.G_NO;
3030: l_false VARCHAR2(1) := inv_rcv_integration_apis.G_FALSE;
3031: l_return_status VARCHAR2(1);
3024: l_serial_status_id NUMBER;
3025: l_txn_if_id NUMBER := p_txn_if_id;
3026: l_product_txn_id NUMBER := p_product_txn_id;
3027: l_prod_code VARCHAR2(5) := inv_rcv_integration_apis.G_PROD_CODE;
3028: l_yes VARCHAR2(1) := inv_rcv_integration_apis.G_YES;
3029: l_no VARCHAR2(1) := inv_rcv_integration_apis.G_NO;
3030: l_false VARCHAR2(1) := inv_rcv_integration_apis.G_FALSE;
3031: l_return_status VARCHAR2(1);
3032: l_msg_count NUMBER;
3025: l_txn_if_id NUMBER := p_txn_if_id;
3026: l_product_txn_id NUMBER := p_product_txn_id;
3027: l_prod_code VARCHAR2(5) := inv_rcv_integration_apis.G_PROD_CODE;
3028: l_yes VARCHAR2(1) := inv_rcv_integration_apis.G_YES;
3029: l_no VARCHAR2(1) := inv_rcv_integration_apis.G_NO;
3030: l_false VARCHAR2(1) := inv_rcv_integration_apis.G_FALSE;
3031: l_return_status VARCHAR2(1);
3032: l_msg_count NUMBER;
3033: l_msg_data VARCHAR2(10000);
3026: l_product_txn_id NUMBER := p_product_txn_id;
3027: l_prod_code VARCHAR2(5) := inv_rcv_integration_apis.G_PROD_CODE;
3028: l_yes VARCHAR2(1) := inv_rcv_integration_apis.G_YES;
3029: l_no VARCHAR2(1) := inv_rcv_integration_apis.G_NO;
3030: l_false VARCHAR2(1) := inv_rcv_integration_apis.G_FALSE;
3031: l_return_status VARCHAR2(1);
3032: l_msg_count NUMBER;
3033: l_msg_data VARCHAR2(10000);
3034: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
3041: WHERE serial_number = p_serial_number
3042: AND inventory_item_id = p_item_id;
3043:
3044: --Call the insert_msni API
3045: inv_rcv_integration_apis.insert_msni(
3046: p_api_version => 1.0
3047: , p_init_msg_lst => l_false
3048: , x_return_status => l_return_status
3049: , x_msg_count => l_msg_count