DBA Data[Home] [Help]

APPS.INV_LOT_TRX_VALIDATION_PUB dependencies on FND_FLEX_DESCVAL

Line 2226: * fnd_flex_descval.set_context_value(l_context_value);

2222: * l_context_value := g_lot_attributes_tbl(9).column_value;
2223: * end if;
2224: *
2225: * if l_context_value is not null then
2226: * fnd_flex_descval.set_context_value(l_context_value);
2227: * fnd_flex_descval.clear_column_values;
2228: * fnd_flex_descval.set_column_value('LOT_ATTRIBUTE_CATEGORY',
2229: * g_lot_attributes_tbl(9).column_value);
2230: * -- Setting the Values for Validating

Line 2227: * fnd_flex_descval.clear_column_values;

2223: * end if;
2224: *
2225: * if l_context_value is not null then
2226: * fnd_flex_descval.set_context_value(l_context_value);
2227: * fnd_flex_descval.clear_column_values;
2228: * fnd_flex_descval.set_column_value('LOT_ATTRIBUTE_CATEGORY',
2229: * g_lot_attributes_tbl(9).column_value);
2230: * -- Setting the Values for Validating
2231: * FOR i IN 1..v_contexts.ncontexts LOOP

Line 2228: * fnd_flex_descval.set_column_value('LOT_ATTRIBUTE_CATEGORY',

2224: *
2225: * if l_context_value is not null then
2226: * fnd_flex_descval.set_context_value(l_context_value);
2227: * fnd_flex_descval.clear_column_values;
2228: * fnd_flex_descval.set_column_value('LOT_ATTRIBUTE_CATEGORY',
2229: * g_lot_attributes_tbl(9).column_value);
2230: * -- Setting the Values for Validating
2231: * FOR i IN 1..v_contexts.ncontexts LOOP
2232: * IF(v_contexts.is_enabled(i) AND ((UPPER(v_contexts.context_code(i)) =

Line 2259: * l_status := fnd_flex_descval.validate_desccols(

2255: * END LOOP segmentLoop;
2256: * END IF;
2257: * END LOOP contextLoop;
2258: * -- Call the validating routine for Lot Attributes.
2259: * l_status := fnd_flex_descval.validate_desccols(
2260: * appl_short_name => 'INV',
2261: * desc_flex_name => l_attributes_name);
2262: * if l_status = TRUE then
2263: * return l_validation_status := 'Y';

Line 2683: print_debug ('calling fnd_flex_descval.set_context_value'

2679: IF l_context_value IS NOT NULL
2680: THEN
2681: IF (l_debug = 1)
2682: THEN
2683: print_debug ('calling fnd_flex_descval.set_context_value'
2684: , 'Validate_Attributes'
2685: );
2686: END IF;
2687:

Line 2688: fnd_flex_descval.set_context_value (l_context_value);

2684: , 'Validate_Attributes'
2685: );
2686: END IF;
2687:
2688: fnd_flex_descval.set_context_value (l_context_value);
2689:
2690: IF (l_debug = 1)
2691: THEN
2692: print_debug ('calling fnd_flex_descval.clear_column_values'

Line 2692: print_debug ('calling fnd_flex_descval.clear_column_values'

2688: fnd_flex_descval.set_context_value (l_context_value);
2689:
2690: IF (l_debug = 1)
2691: THEN
2692: print_debug ('calling fnd_flex_descval.clear_column_values'
2693: , 'Validate_Attributes'
2694: );
2695: END IF;
2696:

Line 2697: fnd_flex_descval.clear_column_values;

2693: , 'Validate_Attributes'
2694: );
2695: END IF;
2696:
2697: fnd_flex_descval.clear_column_values;
2698:
2699: IF (l_debug = 1)
2700: THEN
2701: print_debug

Line 2702: ( 'calling fnd_flex_descval.clear_column_values LOT_ATTRIBUTE_CATEGORY = '

2698:
2699: IF (l_debug = 1)
2700: THEN
2701: print_debug
2702: ( 'calling fnd_flex_descval.clear_column_values LOT_ATTRIBUTE_CATEGORY = '
2703: || l_context_value
2704: , 'Validate_Attributes'
2705: );
2706: END IF;

Line 2708: fnd_flex_descval.set_column_value ('LOT_ATTRIBUTE_CATEGORY'

2704: , 'Validate_Attributes'
2705: );
2706: END IF;
2707:
2708: fnd_flex_descval.set_column_value ('LOT_ATTRIBUTE_CATEGORY'
2709: , l_context_value
2710: );
2711:
2712: -- Setting the Values for Validating

Line 2786: fnd_flex_descval.set_column_value

2782: , 'Validate_Attributes'
2783: );
2784: END IF;
2785:
2786: fnd_flex_descval.set_column_value
2787: (g_lot_attributes_tbl (k).column_name
2788: , fnd_date.canonical_to_date
2789: (g_lot_attributes_tbl (k).column_value
2790: )

Line 2804: fnd_flex_descval.set_column_value

2800: , 'Validate_Attributes'
2801: );
2802: END IF;
2803:
2804: fnd_flex_descval.set_column_value
2805: (g_lot_attributes_tbl (k).column_name
2806: , TO_NUMBER (g_lot_attributes_tbl (k).column_value
2807: )
2808: );

Line 2821: fnd_flex_descval.set_column_value

2817: , 'Validate_Attributes'
2818: );
2819: END IF;
2820:
2821: fnd_flex_descval.set_column_value
2822: (g_lot_attributes_tbl (k).column_name
2823: , g_lot_attributes_tbl (k).column_value
2824: );
2825: END IF;

Line 2870: print_debug ('calling fnd_flex_descval.validate_desccols'

2866: --now all the values have been set for the global variables
2867: -- Call the validating routine for Lot Attributes.
2868: IF (l_debug = 1)
2869: THEN
2870: print_debug ('calling fnd_flex_descval.validate_desccols'
2871: , 'Validate_Attributes'
2872: );
2873: END IF;
2874:

Line 2876: fnd_flex_descval.validate_desccols

2872: );
2873: END IF;
2874:
2875: l_status :=
2876: fnd_flex_descval.validate_desccols
2877: (appl_short_name => 'INV'
2878: , desc_flex_name => l_attributes_name
2879: );
2880:

Line 2897: x_msg_data := fnd_flex_descval.error_message;

2893: END IF;
2894:
2895: l_validation_status := 'N';
2896: x_return_status := fnd_api.g_ret_sts_error;
2897: x_msg_data := fnd_flex_descval.error_message;
2898: fnd_message.set_name ('INV', 'GENERIC');
2899: fnd_message.set_token ('MSGBODY', x_msg_data);
2900: fnd_msg_pub.ADD;
2901: x_msg_count := NVL (x_msg_count, 0) + 1;

Line 3283: print_debug ('calling fnd_flex_descval.set_context_value'

3279: IF l_context_value IS NOT NULL
3280: THEN
3281: IF (l_debug = 1)
3282: THEN
3283: print_debug ('calling fnd_flex_descval.set_context_value'
3284: , 'validate_serial_attributes'
3285: );
3286: END IF;
3287:

Line 3288: fnd_flex_descval.set_context_value (l_context_value);

3284: , 'validate_serial_attributes'
3285: );
3286: END IF;
3287:
3288: fnd_flex_descval.set_context_value (l_context_value);
3289:
3290: IF (l_debug = 1)
3291: THEN
3292: print_debug ('calling fnd_flex_descval.clear_column_values'

Line 3292: print_debug ('calling fnd_flex_descval.clear_column_values'

3288: fnd_flex_descval.set_context_value (l_context_value);
3289:
3290: IF (l_debug = 1)
3291: THEN
3292: print_debug ('calling fnd_flex_descval.clear_column_values'
3293: , 'validate_serial_attributes'
3294: );
3295: END IF;
3296:

Line 3297: fnd_flex_descval.clear_column_values;

3293: , 'validate_serial_attributes'
3294: );
3295: END IF;
3296:
3297: fnd_flex_descval.clear_column_values;
3298:
3299: IF (l_debug = 1)
3300: THEN
3301: print_debug

Line 3302: ( 'calling fnd_flex_descval.clear_column_values SERIAL_ATTRIBUTE_CATEGORY = '

3298:
3299: IF (l_debug = 1)
3300: THEN
3301: print_debug
3302: ( 'calling fnd_flex_descval.clear_column_values SERIAL_ATTRIBUTE_CATEGORY = '
3303: || l_context_value
3304: , 'validate_serial_attributes'
3305: );
3306: END IF;

Line 3308: fnd_flex_descval.set_column_value ('SERIAL_ATTRIBUTE_CATEGORY'

3304: , 'validate_serial_attributes'
3305: );
3306: END IF;
3307:
3308: fnd_flex_descval.set_column_value ('SERIAL_ATTRIBUTE_CATEGORY'
3309: , l_context_value
3310: );
3311:
3312: -- Setting the Values for Validating

Line 3412: fnd_flex_descval.set_column_value

3408: , 'validate_serial_attributes'
3409: );
3410: END IF;
3411:
3412: fnd_flex_descval.set_column_value
3413: (g_lot_ser_attributes_tbl (k).column_name
3414: , fnd_date.canonical_to_date
3415: (g_lot_ser_attributes_tbl (k).column_value
3416: )

Line 3430: fnd_flex_descval.set_column_value

3426: , 'validate_serial_attributes'
3427: );
3428: END IF;
3429:
3430: fnd_flex_descval.set_column_value
3431: (g_lot_ser_attributes_tbl (k).column_name
3432: , TO_NUMBER (g_lot_ser_attributes_tbl (k).column_value
3433: )
3434: );

Line 3447: fnd_flex_descval.set_column_value

3443: , 'validate_serial_attributes'
3444: );
3445: END IF;
3446:
3447: fnd_flex_descval.set_column_value
3448: (g_lot_ser_attributes_tbl (k).column_name
3449: , g_lot_ser_attributes_tbl (k).column_value
3450: );
3451: END IF;

Line 3497: print_debug ('calling fnd_flex_descval.validate_desccols'

3493: --now all the values have been set for the global variables
3494: -- Call the validating routine for Lot Attributes.
3495: IF (l_debug = 1)
3496: THEN
3497: print_debug ('calling fnd_flex_descval.validate_desccols'
3498: , 'validate_serial_attributes'
3499: );
3500: END IF;
3501:

Line 3503: fnd_flex_descval.validate_desccols

3499: );
3500: END IF;
3501:
3502: l_status :=
3503: fnd_flex_descval.validate_desccols
3504: (appl_short_name => 'INV'
3505: , desc_flex_name => l_attributes_name
3506: );
3507:

Line 3524: x_msg_data := fnd_flex_descval.error_message;

3520: END IF;
3521:
3522: l_validation_status := 'N';
3523: x_return_status := fnd_api.g_ret_sts_error;
3524: x_msg_data := fnd_flex_descval.error_message;
3525: fnd_message.set_name ('INV', 'GENERIC');
3526: fnd_message.set_token ('MSGBODY', x_msg_data);
3527: fnd_msg_pub.ADD;
3528: x_msg_count := NVL (x_msg_count, 0) + 1;