DBA Data[Home] [Help]

APPS.INV_LOT_SEL_ATTR dependencies on INV_TRX_UTIL_PUB

Line 1023: inv_trx_util_pub.trace('inputs to get_attribute_values: ','INV_LOT_SEL_ATTR',9);

1019:
1020: BEGIN
1021:
1022: IF (l_debug = 1) THEN
1023: inv_trx_util_pub.trace('inputs to get_attribute_values: ','INV_LOT_SEL_ATTR',9);
1024: inv_trx_util_pub.trace('p_table_name ' || p_table_name,'INV_LOT_SEL_ATTR',9);
1025: inv_trx_util_pub.trace('p_attributes_name '|| p_attributes_name,'INV_LOT_SEL_ATTR',9);
1026: inv_trx_util_pub.trace('p_inventory_item_id '||p_inventory_item_id,'INV_LOT_SEL_ATTR',9);
1027: inv_trx_util_pub.trace('p_organization_id '||p_organization_id,'INV_LOT_SEL_ATTR',9);

Line 1024: inv_trx_util_pub.trace('p_table_name ' || p_table_name,'INV_LOT_SEL_ATTR',9);

1020: BEGIN
1021:
1022: IF (l_debug = 1) THEN
1023: inv_trx_util_pub.trace('inputs to get_attribute_values: ','INV_LOT_SEL_ATTR',9);
1024: inv_trx_util_pub.trace('p_table_name ' || p_table_name,'INV_LOT_SEL_ATTR',9);
1025: inv_trx_util_pub.trace('p_attributes_name '|| p_attributes_name,'INV_LOT_SEL_ATTR',9);
1026: inv_trx_util_pub.trace('p_inventory_item_id '||p_inventory_item_id,'INV_LOT_SEL_ATTR',9);
1027: inv_trx_util_pub.trace('p_organization_id '||p_organization_id,'INV_LOT_SEL_ATTR',9);
1028: inv_trx_util_pub.trace('p_lot_serial_number '||p_lot_serial_number,'INV_LOT_SEL_ATTR',9);

Line 1025: inv_trx_util_pub.trace('p_attributes_name '|| p_attributes_name,'INV_LOT_SEL_ATTR',9);

1021:
1022: IF (l_debug = 1) THEN
1023: inv_trx_util_pub.trace('inputs to get_attribute_values: ','INV_LOT_SEL_ATTR',9);
1024: inv_trx_util_pub.trace('p_table_name ' || p_table_name,'INV_LOT_SEL_ATTR',9);
1025: inv_trx_util_pub.trace('p_attributes_name '|| p_attributes_name,'INV_LOT_SEL_ATTR',9);
1026: inv_trx_util_pub.trace('p_inventory_item_id '||p_inventory_item_id,'INV_LOT_SEL_ATTR',9);
1027: inv_trx_util_pub.trace('p_organization_id '||p_organization_id,'INV_LOT_SEL_ATTR',9);
1028: inv_trx_util_pub.trace('p_lot_serial_number '||p_lot_serial_number,'INV_LOT_SEL_ATTR',9);
1029: inv_trx_util_pub.trace('p_issue_receipt '||p_issue_receipt,'INV_LOT_SEL_ATTR',9);

Line 1026: inv_trx_util_pub.trace('p_inventory_item_id '||p_inventory_item_id,'INV_LOT_SEL_ATTR',9);

1022: IF (l_debug = 1) THEN
1023: inv_trx_util_pub.trace('inputs to get_attribute_values: ','INV_LOT_SEL_ATTR',9);
1024: inv_trx_util_pub.trace('p_table_name ' || p_table_name,'INV_LOT_SEL_ATTR',9);
1025: inv_trx_util_pub.trace('p_attributes_name '|| p_attributes_name,'INV_LOT_SEL_ATTR',9);
1026: inv_trx_util_pub.trace('p_inventory_item_id '||p_inventory_item_id,'INV_LOT_SEL_ATTR',9);
1027: inv_trx_util_pub.trace('p_organization_id '||p_organization_id,'INV_LOT_SEL_ATTR',9);
1028: inv_trx_util_pub.trace('p_lot_serial_number '||p_lot_serial_number,'INV_LOT_SEL_ATTR',9);
1029: inv_trx_util_pub.trace('p_issue_receipt '||p_issue_receipt,'INV_LOT_SEL_ATTR',9);
1030: END IF;

Line 1027: inv_trx_util_pub.trace('p_organization_id '||p_organization_id,'INV_LOT_SEL_ATTR',9);

1023: inv_trx_util_pub.trace('inputs to get_attribute_values: ','INV_LOT_SEL_ATTR',9);
1024: inv_trx_util_pub.trace('p_table_name ' || p_table_name,'INV_LOT_SEL_ATTR',9);
1025: inv_trx_util_pub.trace('p_attributes_name '|| p_attributes_name,'INV_LOT_SEL_ATTR',9);
1026: inv_trx_util_pub.trace('p_inventory_item_id '||p_inventory_item_id,'INV_LOT_SEL_ATTR',9);
1027: inv_trx_util_pub.trace('p_organization_id '||p_organization_id,'INV_LOT_SEL_ATTR',9);
1028: inv_trx_util_pub.trace('p_lot_serial_number '||p_lot_serial_number,'INV_LOT_SEL_ATTR',9);
1029: inv_trx_util_pub.trace('p_issue_receipt '||p_issue_receipt,'INV_LOT_SEL_ATTR',9);
1030: END IF;
1031: fnd_dflex.get_flexfield('INV', p_attributes_name, l_flexfield, l_flexinfo);

Line 1028: inv_trx_util_pub.trace('p_lot_serial_number '||p_lot_serial_number,'INV_LOT_SEL_ATTR',9);

1024: inv_trx_util_pub.trace('p_table_name ' || p_table_name,'INV_LOT_SEL_ATTR',9);
1025: inv_trx_util_pub.trace('p_attributes_name '|| p_attributes_name,'INV_LOT_SEL_ATTR',9);
1026: inv_trx_util_pub.trace('p_inventory_item_id '||p_inventory_item_id,'INV_LOT_SEL_ATTR',9);
1027: inv_trx_util_pub.trace('p_organization_id '||p_organization_id,'INV_LOT_SEL_ATTR',9);
1028: inv_trx_util_pub.trace('p_lot_serial_number '||p_lot_serial_number,'INV_LOT_SEL_ATTR',9);
1029: inv_trx_util_pub.trace('p_issue_receipt '||p_issue_receipt,'INV_LOT_SEL_ATTR',9);
1030: END IF;
1031: fnd_dflex.get_flexfield('INV', p_attributes_name, l_flexfield, l_flexinfo);
1032: -- Get Contexts

Line 1029: inv_trx_util_pub.trace('p_issue_receipt '||p_issue_receipt,'INV_LOT_SEL_ATTR',9);

1025: inv_trx_util_pub.trace('p_attributes_name '|| p_attributes_name,'INV_LOT_SEL_ATTR',9);
1026: inv_trx_util_pub.trace('p_inventory_item_id '||p_inventory_item_id,'INV_LOT_SEL_ATTR',9);
1027: inv_trx_util_pub.trace('p_organization_id '||p_organization_id,'INV_LOT_SEL_ATTR',9);
1028: inv_trx_util_pub.trace('p_lot_serial_number '||p_lot_serial_number,'INV_LOT_SEL_ATTR',9);
1029: inv_trx_util_pub.trace('p_issue_receipt '||p_issue_receipt,'INV_LOT_SEL_ATTR',9);
1030: END IF;
1031: fnd_dflex.get_flexfield('INV', p_attributes_name, l_flexfield, l_flexinfo);
1032: -- Get Contexts
1033: fnd_dflex.get_contexts(l_flexfield, l_contexts_info);

Line 1071: inv_trx_util_pub.trace('is not Receipt. calling the code to fetch from MSN or MLN depending on flex types');

1067: IF( p_issue_receipt <> 'R'
1068: --AND p_attributes_name = 'Serial Attributes'
1069: ) THEN
1070: IF (l_debug = 1) THEN
1071: inv_trx_util_pub.trace('is not Receipt. calling the code to fetch from MSN or MLN depending on flex types');
1072: END IF;
1073: get_lot_serial_context(context_value => l_attributes_category
1074: , org_id => p_organization_id
1075: , item_id => p_inventory_item_id

Line 1079: inv_trx_util_pub.trace('got the context value ' || l_attributes_category);

1075: , item_id => p_inventory_item_id
1076: , p_lot_serial => p_lot_serial_number
1077: , flex_name => p_attributes_name);
1078: IF (l_debug = 1) THEN
1079: inv_trx_util_pub.trace('got the context value ' || l_attributes_category);
1080: END IF;
1081: ELSE
1082: get_context_code(
1083: context_value => l_attributes_category