DBA Data[Home] [Help]

APPS.INV_TXN_MANAGER_GRP dependencies on INV_LOT_ATTR_PUB

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

15124: dbms_output.put_line('***************************************' );
15125: */
15126:
15127: /* VALIDATE parent/child lot number */
15128: l_check := INV_LOT_ATTR_PUB.validate_child_lot( p_parent_lot_number => p_parent_lot_number
15129: ,p_lot_number => p_lot_number
15130: ,p_org_id => l_orgid
15131: ,p_inventory_item_id => l_itemid
15132: ,p_child_lot_flag => l_child_lot_flag

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

15146: END IF;
15147:
15148:
15149: /******************* START Grade Code validation logic ********************/
15150: l_check := INV_LOT_ATTR_PUB.validate_grade_code( p_grade_code => p_grade_code
15151: , p_org_id => l_orgid
15152: , p_inventory_item_id => l_itemid
15153: , p_grade_control_flag => l_grade_control_flag
15154: , x_return_status => l_return_status

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

15165: inv_log_util.trace('validate_grade_code pass', 'INV_TXN_MANAGER_GRP', 9);
15166: END IF;
15167:
15168: /******************* START Origination Type validation logic ********************/
15169: l_check := INV_LOT_ATTR_PUB.validate_origination_type( p_origination_type => p_origination_type
15170: , x_return_status => l_return_status
15171: , x_msg_count => l_msg_count
15172: , x_msg_data => l_msg_data);
15173: IF NOT(l_check)

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

15183:
15184: -- dbms_output.put_line('Validate_Additional_Attr: Origination type validation - PASS...');
15185:
15186: /******************* START Expiration Action Code validation logic ********************/
15187: l_check := INV_LOT_ATTR_PUB.validate_exp_action_code( p_expiration_action_code => p_expiration_action_code
15188: , p_org_id => l_orgid
15189: , p_inventory_item_id => l_itemid
15190: , p_shelf_life_code => l_shelf_life_code
15191: , x_return_status => l_return_status

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

15203:
15204: -- dbms_output.put_line('Validate_Additional_Attr: Expiration Action Code validation - PASS...');
15205:
15206: /******************* START Retest Date validation logic ********************/
15207: l_check := INV_LOT_ATTR_PUB.validate_retest_date(p_retest_date => p_retest_date
15208: ,p_origination_date => p_origination_date
15209: ,x_return_status => l_return_status
15210: ,x_msg_count => l_msg_count
15211: ,x_msg_data => l_msg_data);

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

15219: inv_log_util.trace('validate_retest_date pass', 'INV_TXN_MANAGER_GRP', 9);
15220: END IF;
15221:
15222: /******************* START Expiration Action Date validation logic ********************/
15223: l_check := INV_LOT_ATTR_PUB.validate_exp_action_date( p_expiration_action_date => p_expiration_action_date
15224: , p_expiration_date => p_expiration_date
15225: , x_return_status => l_return_status
15226: , x_msg_count => l_msg_count
15227: , x_msg_data => l_msg_data);

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

15237: END IF;
15238:
15239:
15240: /******************* START Maturity Date validation logic ********************/
15241: l_check := INV_LOT_ATTR_PUB.validate_maturity_date( p_maturity_date => p_maturity_date
15242: ,p_origination_date => p_origination_date
15243: ,x_return_status => l_return_status
15244: ,x_msg_count => l_msg_count
15245: ,x_msg_data => l_msg_data);

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

15253: inv_log_util.trace('validate_maturity_date pass', 'INV_TXN_MANAGER_GRP', 9);
15254: END IF;
15255:
15256: /******************* START Hold Date validation logic ********************/
15257: l_check := INV_LOT_ATTR_PUB.validate_hold_date( p_hold_date => p_hold_date
15258: ,p_origination_date => p_origination_date
15259: ,x_return_status => l_return_status
15260: ,x_msg_count => l_msg_count
15261: ,x_msg_data => l_msg_data);

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

15269: inv_log_util.trace('validate_hold_date pass', 'INV_TXN_MANAGER_GRP', 9);
15270: END IF;
15271:
15272: /******************* START Reason Code validation logic ********************/
15273: l_check := INV_LOT_ATTR_PUB.validate_reason_code( p_reason_code => null
15274: ,p_reason_id => p_reason_id
15275: ,x_return_status => l_return_status
15276: ,x_msg_count => l_msg_count
15277: ,x_msg_data => l_msg_count);