DBA Data[Home] [Help]

APPS.INV_LOT_TRX_VALIDATION_PUB dependencies on FND_FLEX_DESCVAL

Line 2175: * fnd_flex_descval.set_context_value(l_context_value);

2171: * l_context_value := g_lot_attributes_tbl(9).column_value;
2172: * end if;
2173: *
2174: * if l_context_value is not null then
2175: * fnd_flex_descval.set_context_value(l_context_value);
2176: * fnd_flex_descval.clear_column_values;
2177: * fnd_flex_descval.set_column_value('LOT_ATTRIBUTE_CATEGORY',
2178: * g_lot_attributes_tbl(9).column_value);
2179: * -- Setting the Values for Validating

Line 2176: * fnd_flex_descval.clear_column_values;

2172: * end if;
2173: *
2174: * if l_context_value is not null then
2175: * fnd_flex_descval.set_context_value(l_context_value);
2176: * fnd_flex_descval.clear_column_values;
2177: * fnd_flex_descval.set_column_value('LOT_ATTRIBUTE_CATEGORY',
2178: * g_lot_attributes_tbl(9).column_value);
2179: * -- Setting the Values for Validating
2180: * FOR i IN 1..v_contexts.ncontexts LOOP

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

2173: *
2174: * if l_context_value is not null then
2175: * fnd_flex_descval.set_context_value(l_context_value);
2176: * fnd_flex_descval.clear_column_values;
2177: * fnd_flex_descval.set_column_value('LOT_ATTRIBUTE_CATEGORY',
2178: * g_lot_attributes_tbl(9).column_value);
2179: * -- Setting the Values for Validating
2180: * FOR i IN 1..v_contexts.ncontexts LOOP
2181: * IF(v_contexts.is_enabled(i) AND ((UPPER(v_contexts.context_code(i)) =

Line 2208: * l_status := fnd_flex_descval.validate_desccols(

2204: * END LOOP segmentLoop;
2205: * END IF;
2206: * END LOOP contextLoop;
2207: * -- Call the validating routine for Lot Attributes.
2208: * l_status := fnd_flex_descval.validate_desccols(
2209: * appl_short_name => 'INV',
2210: * desc_flex_name => l_attributes_name);
2211: * if l_status = TRUE then
2212: * return l_validation_status := 'Y';

Line 2632: print_debug ('calling fnd_flex_descval.set_context_value'

2628: IF l_context_value IS NOT NULL
2629: THEN
2630: IF (l_debug = 1)
2631: THEN
2632: print_debug ('calling fnd_flex_descval.set_context_value'
2633: , 'Validate_Attributes'
2634: );
2635: END IF;
2636:

Line 2637: fnd_flex_descval.set_context_value (l_context_value);

2633: , 'Validate_Attributes'
2634: );
2635: END IF;
2636:
2637: fnd_flex_descval.set_context_value (l_context_value);
2638:
2639: IF (l_debug = 1)
2640: THEN
2641: print_debug ('calling fnd_flex_descval.clear_column_values'

Line 2641: print_debug ('calling fnd_flex_descval.clear_column_values'

2637: fnd_flex_descval.set_context_value (l_context_value);
2638:
2639: IF (l_debug = 1)
2640: THEN
2641: print_debug ('calling fnd_flex_descval.clear_column_values'
2642: , 'Validate_Attributes'
2643: );
2644: END IF;
2645:

Line 2646: fnd_flex_descval.clear_column_values;

2642: , 'Validate_Attributes'
2643: );
2644: END IF;
2645:
2646: fnd_flex_descval.clear_column_values;
2647:
2648: IF (l_debug = 1)
2649: THEN
2650: print_debug

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

2647:
2648: IF (l_debug = 1)
2649: THEN
2650: print_debug
2651: ( 'calling fnd_flex_descval.clear_column_values LOT_ATTRIBUTE_CATEGORY = '
2652: || l_context_value
2653: , 'Validate_Attributes'
2654: );
2655: END IF;

Line 2657: fnd_flex_descval.set_column_value ('LOT_ATTRIBUTE_CATEGORY'

2653: , 'Validate_Attributes'
2654: );
2655: END IF;
2656:
2657: fnd_flex_descval.set_column_value ('LOT_ATTRIBUTE_CATEGORY'
2658: , l_context_value
2659: );
2660:
2661: -- Setting the Values for Validating

Line 2735: fnd_flex_descval.set_column_value

2731: , 'Validate_Attributes'
2732: );
2733: END IF;
2734:
2735: fnd_flex_descval.set_column_value
2736: (g_lot_attributes_tbl (k).column_name
2737: , fnd_date.canonical_to_date
2738: (g_lot_attributes_tbl (k).column_value
2739: )

Line 2753: fnd_flex_descval.set_column_value

2749: , 'Validate_Attributes'
2750: );
2751: END IF;
2752:
2753: fnd_flex_descval.set_column_value
2754: (g_lot_attributes_tbl (k).column_name
2755: , TO_NUMBER (g_lot_attributes_tbl (k).column_value
2756: )
2757: );

Line 2770: fnd_flex_descval.set_column_value

2766: , 'Validate_Attributes'
2767: );
2768: END IF;
2769:
2770: fnd_flex_descval.set_column_value
2771: (g_lot_attributes_tbl (k).column_name
2772: , g_lot_attributes_tbl (k).column_value
2773: );
2774: END IF;

Line 2819: print_debug ('calling fnd_flex_descval.validate_desccols'

2815: --now all the values have been set for the global variables
2816: -- Call the validating routine for Lot Attributes.
2817: IF (l_debug = 1)
2818: THEN
2819: print_debug ('calling fnd_flex_descval.validate_desccols'
2820: , 'Validate_Attributes'
2821: );
2822: END IF;
2823:

Line 2825: fnd_flex_descval.validate_desccols

2821: );
2822: END IF;
2823:
2824: l_status :=
2825: fnd_flex_descval.validate_desccols
2826: (appl_short_name => 'INV'
2827: , desc_flex_name => l_attributes_name
2828: );
2829:

Line 2846: x_msg_data := fnd_flex_descval.error_message;

2842: END IF;
2843:
2844: l_validation_status := 'N';
2845: x_return_status := fnd_api.g_ret_sts_error;
2846: x_msg_data := fnd_flex_descval.error_message;
2847: fnd_message.set_name ('INV', 'GENERIC');
2848: fnd_message.set_token ('MSGBODY', x_msg_data);
2849: fnd_msg_pub.ADD;
2850: x_msg_count := NVL (x_msg_count, 0) + 1;

Line 3242: print_debug ('calling fnd_flex_descval.set_context_value'

3238: IF l_context_value IS NOT NULL
3239: THEN
3240: IF (l_debug = 1)
3241: THEN
3242: print_debug ('calling fnd_flex_descval.set_context_value'
3243: , 'validate_serial_attributes'
3244: );
3245: END IF;
3246:

Line 3247: fnd_flex_descval.set_context_value (l_context_value);

3243: , 'validate_serial_attributes'
3244: );
3245: END IF;
3246:
3247: fnd_flex_descval.set_context_value (l_context_value);
3248:
3249: IF (l_debug = 1)
3250: THEN
3251: print_debug ('calling fnd_flex_descval.clear_column_values'

Line 3251: print_debug ('calling fnd_flex_descval.clear_column_values'

3247: fnd_flex_descval.set_context_value (l_context_value);
3248:
3249: IF (l_debug = 1)
3250: THEN
3251: print_debug ('calling fnd_flex_descval.clear_column_values'
3252: , 'validate_serial_attributes'
3253: );
3254: END IF;
3255:

Line 3256: fnd_flex_descval.clear_column_values;

3252: , 'validate_serial_attributes'
3253: );
3254: END IF;
3255:
3256: fnd_flex_descval.clear_column_values;
3257:
3258: IF (l_debug = 1)
3259: THEN
3260: print_debug

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

3257:
3258: IF (l_debug = 1)
3259: THEN
3260: print_debug
3261: ( 'calling fnd_flex_descval.clear_column_values SERIAL_ATTRIBUTE_CATEGORY = '
3262: || l_context_value
3263: , 'validate_serial_attributes'
3264: );
3265: END IF;

Line 3267: fnd_flex_descval.set_column_value ('SERIAL_ATTRIBUTE_CATEGORY'

3263: , 'validate_serial_attributes'
3264: );
3265: END IF;
3266:
3267: fnd_flex_descval.set_column_value ('SERIAL_ATTRIBUTE_CATEGORY'
3268: , l_context_value
3269: );
3270:
3271: -- Setting the Values for Validating

Line 3371: fnd_flex_descval.set_column_value

3367: , 'validate_serial_attributes'
3368: );
3369: END IF;
3370:
3371: fnd_flex_descval.set_column_value
3372: (g_lot_ser_attributes_tbl (k).column_name
3373: , fnd_date.canonical_to_date
3374: (g_lot_ser_attributes_tbl (k).column_value
3375: )

Line 3389: fnd_flex_descval.set_column_value

3385: , 'validate_serial_attributes'
3386: );
3387: END IF;
3388:
3389: fnd_flex_descval.set_column_value
3390: (g_lot_ser_attributes_tbl (k).column_name
3391: , TO_NUMBER (g_lot_ser_attributes_tbl (k).column_value
3392: )
3393: );

Line 3406: fnd_flex_descval.set_column_value

3402: , 'validate_serial_attributes'
3403: );
3404: END IF;
3405:
3406: fnd_flex_descval.set_column_value
3407: (g_lot_ser_attributes_tbl (k).column_name
3408: , g_lot_ser_attributes_tbl (k).column_value
3409: );
3410: END IF;

Line 3456: print_debug ('calling fnd_flex_descval.validate_desccols'

3452: --now all the values have been set for the global variables
3453: -- Call the validating routine for Lot Attributes.
3454: IF (l_debug = 1)
3455: THEN
3456: print_debug ('calling fnd_flex_descval.validate_desccols'
3457: , 'validate_serial_attributes'
3458: );
3459: END IF;
3460:

Line 3462: fnd_flex_descval.validate_desccols

3458: );
3459: END IF;
3460:
3461: l_status :=
3462: fnd_flex_descval.validate_desccols
3463: (appl_short_name => 'INV'
3464: , desc_flex_name => l_attributes_name
3465: );
3466:

Line 3483: x_msg_data := fnd_flex_descval.error_message;

3479: END IF;
3480:
3481: l_validation_status := 'N';
3482: x_return_status := fnd_api.g_ret_sts_error;
3483: x_msg_data := fnd_flex_descval.error_message;
3484: fnd_message.set_name ('INV', 'GENERIC');
3485: fnd_message.set_token ('MSGBODY', x_msg_data);
3486: fnd_msg_pub.ADD;
3487: x_msg_count := NVL (x_msg_count, 0) + 1;