eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_LOT_TRX_VALIDATION_PUB dependencies on INV_LOT_SEL_ATTR

Line 2148: * call INV_LOT_SEL_ATTR.is_enabled to see if the lot attributes is enabled for this

2144: * Pseudo-codes: *
2145: * x_return_status := FND_API.G_RET_STS_SUCCESS;
2146: * FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
2147: *
2148: * call INV_LOT_SEL_ATTR.is_enabled to see if the lot attributes is enabled for this
2149: * item/org/category combination
2150: *
2151: * if no lot attributes is enabled then
2152: * return validation status 'Y', we don't need to validate any attributes.

Line 2194: * Call inv_lot_sel_attr.get_default to get the default lot attributes

2190: * end if;
2191: * -- parent lot does not have attributes and user does not supply attributes
2192: * -- for resulting lots.
2193: * -- use default lot attributes.
2194: * Call inv_lot_sel_attr.get_default to get the default lot attributes
2195: *
2196: * if( l_attributes_default_count > 0 ) then
2197: * for i in 1..l_attributes_default_count LOOP
2198: * for j in 1..g_lot_attributes_tbl.count LOOP

Line 2218: * inv_lot_sel_attr.get_context_code(l_context_value,

2214: * -- Get Contexts
2215: * fnd_dflex.get_contexts(v_flexfield, v_contexts);
2216: * -- Get Context Value.
2217: * if g_lot_attributes_tbl(9).column_value is null then
2218: * inv_lot_sel_attr.get_context_code(l_context_value,
2219: * p_organization_id,p_inventory_item_id,l_attributes_name);
2220: * g_lot_attributes_tbl(9).column_value := l_context_value;
2221: * else
2222: * l_context_value := g_lot_attributes_tbl(9).column_value;

Line 2279: , x_lot_attr_tbl OUT NOCOPY inv_lot_sel_attr.lot_sel_attributes_tbl_type

2275: x_return_status OUT NOCOPY VARCHAR2
2276: , x_msg_count OUT NOCOPY NUMBER
2277: , x_msg_data OUT NOCOPY VARCHAR2
2278: , x_validation_status OUT NOCOPY VARCHAR2
2279: , x_lot_attr_tbl OUT NOCOPY inv_lot_sel_attr.lot_sel_attributes_tbl_type
2280: , p_lot_number IN VARCHAR2 --parent lot
2281: , p_organization_id IN NUMBER
2282: , p_inventory_item_id IN NUMBER
2283: , p_parent_lot_attr_tbl IN inv_lot_sel_attr.lot_sel_attributes_tbl_type

Line 2283: , p_parent_lot_attr_tbl IN inv_lot_sel_attr.lot_sel_attributes_tbl_type

2279: , x_lot_attr_tbl OUT NOCOPY inv_lot_sel_attr.lot_sel_attributes_tbl_type
2280: , p_lot_number IN VARCHAR2 --parent lot
2281: , p_organization_id IN NUMBER
2282: , p_inventory_item_id IN NUMBER
2283: , p_parent_lot_attr_tbl IN inv_lot_sel_attr.lot_sel_attributes_tbl_type
2284: , p_result_lot_attr_tbl IN inv_lot_sel_attr.lot_sel_attributes_tbl_type
2285: , p_transaction_type_id IN NUMBER
2286: )
2287: IS

Line 2284: , p_result_lot_attr_tbl IN inv_lot_sel_attr.lot_sel_attributes_tbl_type

2280: , p_lot_number IN VARCHAR2 --parent lot
2281: , p_organization_id IN NUMBER
2282: , p_inventory_item_id IN NUMBER
2283: , p_parent_lot_attr_tbl IN inv_lot_sel_attr.lot_sel_attributes_tbl_type
2284: , p_result_lot_attr_tbl IN inv_lot_sel_attr.lot_sel_attributes_tbl_type
2285: , p_transaction_type_id IN NUMBER
2286: )
2287: IS
2288: l_attributes_name VARCHAR2 (50) := 'Lot Attributes';

Line 2295: l_attributes_default inv_lot_sel_attr.lot_sel_attributes_tbl_type;

2291: v_contexts fnd_dflex.contexts_dr;
2292: v_segments fnd_dflex.segments_dr;
2293: l_attributes_default_count NUMBER;
2294: l_enabled_attributes NUMBER;
2295: l_attributes_default inv_lot_sel_attr.lot_sel_attributes_tbl_type;
2296: v_context_value mtl_flex_context.descriptive_flex_context_code%TYPE;
2297: v_colname VARCHAR2 (50);
2298: l_context_value VARCHAR2 (150);
2299: l_return_status VARCHAR2 (1);

Line 2330: inv_lot_sel_attr.is_enabled (p_flex_name => l_attributes_name

2326: );
2327: END IF;
2328:
2329: l_enabled_attributes :=
2330: inv_lot_sel_attr.is_enabled (p_flex_name => l_attributes_name
2331: , p_organization_id => p_organization_id
2332: , p_inventory_item_id => p_inventory_item_id
2333: );
2334:

Line 2524: print_debug ('Calling inv_lot_sel_attr.get_default'

2520: -- parent lot does not have attributes.
2521: -- use default lot attributes.
2522: IF (l_debug = 1)
2523: THEN
2524: print_debug ('Calling inv_lot_sel_attr.get_default'
2525: , 'Validate_Attributes'
2526: );
2527: END IF;
2528:

Line 2529: inv_lot_sel_attr.get_default

2525: , 'Validate_Attributes'
2526: );
2527: END IF;
2528:
2529: inv_lot_sel_attr.get_default
2530: (x_attributes_default => l_attributes_default
2531: , x_attributes_default_count => l_attributes_default_count
2532: , x_return_status => l_return_status
2533: , x_msg_count => l_msg_count

Line 2638: inv_lot_sel_attr.get_context_code (l_context_value

2634: 'LOT_ATTRIBUTE_CATEGORY'
2635: AND g_lot_attributes_tbl (i).column_value IS NULL
2636: )
2637: THEN
2638: inv_lot_sel_attr.get_context_code (l_context_value
2639: , p_organization_id
2640: , p_inventory_item_id
2641: , l_attributes_name
2642: );

Line 3012: , x_ser_attr_tbl OUT NOCOPY inv_lot_sel_attr.lot_sel_attributes_tbl_type

3008: x_return_status OUT NOCOPY VARCHAR2
3009: , x_msg_count OUT NOCOPY NUMBER
3010: , x_msg_data OUT NOCOPY VARCHAR2
3011: , x_validation_status OUT NOCOPY VARCHAR2
3012: , x_ser_attr_tbl OUT NOCOPY inv_lot_sel_attr.lot_sel_attributes_tbl_type
3013: , p_ser_number IN VARCHAR2
3014: , p_organization_id IN NUMBER
3015: , p_inventory_item_id IN NUMBER
3016: , p_result_ser_attr_tbl IN inv_lot_sel_attr.lot_sel_attributes_tbl_type

Line 3016: , p_result_ser_attr_tbl IN inv_lot_sel_attr.lot_sel_attributes_tbl_type

3012: , x_ser_attr_tbl OUT NOCOPY inv_lot_sel_attr.lot_sel_attributes_tbl_type
3013: , p_ser_number IN VARCHAR2
3014: , p_organization_id IN NUMBER
3015: , p_inventory_item_id IN NUMBER
3016: , p_result_ser_attr_tbl IN inv_lot_sel_attr.lot_sel_attributes_tbl_type
3017: )
3018: IS
3019: l_attributes_name VARCHAR2 (50) := 'Serial Attributes';
3020: v_flexfield fnd_dflex.dflex_r;

Line 3026: l_attributes_default inv_lot_sel_attr.lot_sel_attributes_tbl_type;

3022: v_contexts fnd_dflex.contexts_dr;
3023: v_segments fnd_dflex.segments_dr;
3024: l_attributes_default_count NUMBER;
3025: l_enabled_attributes NUMBER;
3026: l_attributes_default inv_lot_sel_attr.lot_sel_attributes_tbl_type;
3027: v_context_value mtl_flex_context.descriptive_flex_context_code%TYPE;
3028: v_colname VARCHAR2 (50);
3029: l_context_value VARCHAR2 (150);
3030: l_return_status VARCHAR2 (1);

Line 3053: inv_lot_sel_attr.is_enabled (p_flex_name => l_attributes_name

3049: l_validation_status := 'Y';
3050: x_return_status := fnd_api.g_ret_sts_success;
3051: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
3052: l_enabled_attributes :=
3053: inv_lot_sel_attr.is_enabled (p_flex_name => l_attributes_name
3054: , p_organization_id => p_organization_id
3055: , p_inventory_item_id => p_inventory_item_id
3056: );
3057:

Line 3129: inv_lot_sel_attr.get_default

3125:
3126:
3127: -- use default serial attributes.
3128: BEGIN
3129: inv_lot_sel_attr.get_default
3130: (x_attributes_default => l_attributes_default
3131: , x_attributes_default_count => l_attributes_default_count
3132: , x_return_status => x_return_status
3133: , x_msg_count => x_msg_count

Line 3239: inv_lot_sel_attr.get_context_code (l_context_value

3235: 'SERIAL_ATTRIBUTE_CATEGORY'
3236: AND g_lot_ser_attributes_tbl (i).column_value IS NULL
3237: )
3238: THEN
3239: inv_lot_sel_attr.get_context_code (l_context_value
3240: , p_organization_id
3241: , p_inventory_item_id
3242: , l_attributes_name
3243: );