DBA Data[Home] [Help]

APPS.INV_TXN_MANAGER_GRP dependencies on INV_LOT_ATTR_PUB

Line 15734: l_check := INV_LOT_ATTR_PUB.validate_child_lot( p_parent_lot_number => p_parent_lot_number

15730: dbms_output.put_line('***************************************' );
15731: */
15732:
15733: /* VALIDATE parent/child lot number */
15734: l_check := INV_LOT_ATTR_PUB.validate_child_lot( p_parent_lot_number => p_parent_lot_number
15735: ,p_lot_number => p_lot_number
15736: ,p_org_id => l_orgid
15737: ,p_inventory_item_id => l_itemid
15738: ,p_child_lot_flag => l_child_lot_flag

Line 15756: l_check := INV_LOT_ATTR_PUB.validate_grade_code( p_grade_code => p_grade_code

15752: END IF;
15753:
15754:
15755: /******************* START Grade Code validation logic ********************/
15756: l_check := INV_LOT_ATTR_PUB.validate_grade_code( p_grade_code => p_grade_code
15757: , p_org_id => l_orgid
15758: , p_inventory_item_id => l_itemid
15759: , p_grade_control_flag => l_grade_control_flag
15760: , x_return_status => l_return_status

Line 15775: l_check := INV_LOT_ATTR_PUB.validate_origination_type( p_origination_type => p_origination_type

15771: inv_log_util.trace('validate_grade_code pass', 'INV_TXN_MANAGER_GRP', 9);
15772: END IF;
15773:
15774: /******************* START Origination Type validation logic ********************/
15775: l_check := INV_LOT_ATTR_PUB.validate_origination_type( p_origination_type => p_origination_type
15776: , x_return_status => l_return_status
15777: , x_msg_count => l_msg_count
15778: , x_msg_data => l_msg_data);
15779: IF NOT(l_check)

Line 15793: l_check := INV_LOT_ATTR_PUB.validate_exp_action_code( p_expiration_action_code => p_expiration_action_code

15789:
15790: -- dbms_output.put_line('Validate_Additional_Attr: Origination type validation - PASS...');
15791:
15792: /******************* START Expiration Action Code validation logic ********************/
15793: l_check := INV_LOT_ATTR_PUB.validate_exp_action_code( p_expiration_action_code => p_expiration_action_code
15794: , p_org_id => l_orgid
15795: , p_inventory_item_id => l_itemid
15796: , p_shelf_life_code => l_shelf_life_code
15797: , x_return_status => l_return_status

Line 15813: l_check := INV_LOT_ATTR_PUB.validate_retest_date(p_retest_date => p_retest_date

15809:
15810: -- dbms_output.put_line('Validate_Additional_Attr: Expiration Action Code validation - PASS...');
15811:
15812: /******************* START Retest Date validation logic ********************/
15813: l_check := INV_LOT_ATTR_PUB.validate_retest_date(p_retest_date => p_retest_date
15814: ,p_origination_date => p_origination_date
15815: ,x_return_status => l_return_status
15816: ,x_msg_count => l_msg_count
15817: ,x_msg_data => l_msg_data);

Line 15829: l_check := INV_LOT_ATTR_PUB.validate_exp_action_date( p_expiration_action_date => p_expiration_action_date

15825: inv_log_util.trace('validate_retest_date pass', 'INV_TXN_MANAGER_GRP', 9);
15826: END IF;
15827:
15828: /******************* START Expiration Action Date validation logic ********************/
15829: l_check := INV_LOT_ATTR_PUB.validate_exp_action_date( p_expiration_action_date => p_expiration_action_date
15830: , p_expiration_date => p_expiration_date
15831: , x_return_status => l_return_status
15832: , x_msg_count => l_msg_count
15833: , x_msg_data => l_msg_data);

Line 15847: l_check := INV_LOT_ATTR_PUB.validate_maturity_date( p_maturity_date => p_maturity_date

15843: END IF;
15844:
15845:
15846: /******************* START Maturity Date validation logic ********************/
15847: l_check := INV_LOT_ATTR_PUB.validate_maturity_date( p_maturity_date => p_maturity_date
15848: ,p_origination_date => p_origination_date
15849: ,x_return_status => l_return_status
15850: ,x_msg_count => l_msg_count
15851: ,x_msg_data => l_msg_data);

Line 15863: l_check := INV_LOT_ATTR_PUB.validate_hold_date( p_hold_date => p_hold_date

15859: inv_log_util.trace('validate_maturity_date pass', 'INV_TXN_MANAGER_GRP', 9);
15860: END IF;
15861:
15862: /******************* START Hold Date validation logic ********************/
15863: l_check := INV_LOT_ATTR_PUB.validate_hold_date( p_hold_date => p_hold_date
15864: ,p_origination_date => p_origination_date
15865: ,x_return_status => l_return_status
15866: ,x_msg_count => l_msg_count
15867: ,x_msg_data => l_msg_data);

Line 15879: l_check := INV_LOT_ATTR_PUB.validate_reason_code( p_reason_code => null

15875: inv_log_util.trace('validate_hold_date pass', 'INV_TXN_MANAGER_GRP', 9);
15876: END IF;
15877:
15878: /******************* START Reason Code validation logic ********************/
15879: l_check := INV_LOT_ATTR_PUB.validate_reason_code( p_reason_code => null
15880: ,p_reason_id => p_reason_id
15881: ,x_return_status => l_return_status
15882: ,x_msg_count => l_msg_count
15883: ,x_msg_data => l_msg_count);