DBA Data[Home] [Help]

APPS.PO_VALIDATION_HELPER dependencies on FND_FLEX_DESCVAL

Line 3363: -- It used the FND API FND_FLEX_DESCVAL.validate_desccols to validate.

3359: --Modifies: x_results, x_result_type
3360: --Locks: None.
3361: --Function:
3362: -- Validates if the DFF's segment values passed are valid.
3363: -- It used the FND API FND_FLEX_DESCVAL.validate_desccols to validate.
3364: --Parameters:
3365: --IN:
3366: --p_calling_module
3367: -- The module base of the calling procedure, used for logging.

Line 3452: fnd_flex_descval.set_column_value('ATTRIBUTE_CATEGORY', p_attribute_category_tbl(i));

3448:
3449: -- Loop through all the ids
3450: FOR i IN 1 .. p_id_tbl.COUNT LOOP
3451: -- Set attribute category (context) and all attribute values
3452: fnd_flex_descval.set_column_value('ATTRIBUTE_CATEGORY', p_attribute_category_tbl(i));
3453: fnd_flex_descval.set_column_value('ATTRIBUTE1', p_attribute1_tbl(i));
3454: fnd_flex_descval.set_column_value('ATTRIBUTE2', p_attribute2_tbl(i));
3455: fnd_flex_descval.set_column_value('ATTRIBUTE3', p_attribute3_tbl(i));
3456: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_attribute4_tbl(i));

Line 3453: fnd_flex_descval.set_column_value('ATTRIBUTE1', p_attribute1_tbl(i));

3449: -- Loop through all the ids
3450: FOR i IN 1 .. p_id_tbl.COUNT LOOP
3451: -- Set attribute category (context) and all attribute values
3452: fnd_flex_descval.set_column_value('ATTRIBUTE_CATEGORY', p_attribute_category_tbl(i));
3453: fnd_flex_descval.set_column_value('ATTRIBUTE1', p_attribute1_tbl(i));
3454: fnd_flex_descval.set_column_value('ATTRIBUTE2', p_attribute2_tbl(i));
3455: fnd_flex_descval.set_column_value('ATTRIBUTE3', p_attribute3_tbl(i));
3456: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_attribute4_tbl(i));
3457: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_attribute5_tbl(i));

Line 3454: fnd_flex_descval.set_column_value('ATTRIBUTE2', p_attribute2_tbl(i));

3450: FOR i IN 1 .. p_id_tbl.COUNT LOOP
3451: -- Set attribute category (context) and all attribute values
3452: fnd_flex_descval.set_column_value('ATTRIBUTE_CATEGORY', p_attribute_category_tbl(i));
3453: fnd_flex_descval.set_column_value('ATTRIBUTE1', p_attribute1_tbl(i));
3454: fnd_flex_descval.set_column_value('ATTRIBUTE2', p_attribute2_tbl(i));
3455: fnd_flex_descval.set_column_value('ATTRIBUTE3', p_attribute3_tbl(i));
3456: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_attribute4_tbl(i));
3457: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_attribute5_tbl(i));
3458: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_attribute6_tbl(i));

Line 3455: fnd_flex_descval.set_column_value('ATTRIBUTE3', p_attribute3_tbl(i));

3451: -- Set attribute category (context) and all attribute values
3452: fnd_flex_descval.set_column_value('ATTRIBUTE_CATEGORY', p_attribute_category_tbl(i));
3453: fnd_flex_descval.set_column_value('ATTRIBUTE1', p_attribute1_tbl(i));
3454: fnd_flex_descval.set_column_value('ATTRIBUTE2', p_attribute2_tbl(i));
3455: fnd_flex_descval.set_column_value('ATTRIBUTE3', p_attribute3_tbl(i));
3456: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_attribute4_tbl(i));
3457: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_attribute5_tbl(i));
3458: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_attribute6_tbl(i));
3459: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_attribute7_tbl(i));

Line 3456: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_attribute4_tbl(i));

3452: fnd_flex_descval.set_column_value('ATTRIBUTE_CATEGORY', p_attribute_category_tbl(i));
3453: fnd_flex_descval.set_column_value('ATTRIBUTE1', p_attribute1_tbl(i));
3454: fnd_flex_descval.set_column_value('ATTRIBUTE2', p_attribute2_tbl(i));
3455: fnd_flex_descval.set_column_value('ATTRIBUTE3', p_attribute3_tbl(i));
3456: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_attribute4_tbl(i));
3457: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_attribute5_tbl(i));
3458: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_attribute6_tbl(i));
3459: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_attribute7_tbl(i));
3460: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_attribute8_tbl(i));

Line 3457: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_attribute5_tbl(i));

3453: fnd_flex_descval.set_column_value('ATTRIBUTE1', p_attribute1_tbl(i));
3454: fnd_flex_descval.set_column_value('ATTRIBUTE2', p_attribute2_tbl(i));
3455: fnd_flex_descval.set_column_value('ATTRIBUTE3', p_attribute3_tbl(i));
3456: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_attribute4_tbl(i));
3457: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_attribute5_tbl(i));
3458: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_attribute6_tbl(i));
3459: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_attribute7_tbl(i));
3460: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_attribute8_tbl(i));
3461: fnd_flex_descval.set_column_value('ATTRIBUTE9', p_attribute9_tbl(i));

Line 3458: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_attribute6_tbl(i));

3454: fnd_flex_descval.set_column_value('ATTRIBUTE2', p_attribute2_tbl(i));
3455: fnd_flex_descval.set_column_value('ATTRIBUTE3', p_attribute3_tbl(i));
3456: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_attribute4_tbl(i));
3457: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_attribute5_tbl(i));
3458: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_attribute6_tbl(i));
3459: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_attribute7_tbl(i));
3460: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_attribute8_tbl(i));
3461: fnd_flex_descval.set_column_value('ATTRIBUTE9', p_attribute9_tbl(i));
3462: fnd_flex_descval.set_column_value('ATTRIBUTE10', p_attribute10_tbl(i));

Line 3459: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_attribute7_tbl(i));

3455: fnd_flex_descval.set_column_value('ATTRIBUTE3', p_attribute3_tbl(i));
3456: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_attribute4_tbl(i));
3457: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_attribute5_tbl(i));
3458: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_attribute6_tbl(i));
3459: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_attribute7_tbl(i));
3460: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_attribute8_tbl(i));
3461: fnd_flex_descval.set_column_value('ATTRIBUTE9', p_attribute9_tbl(i));
3462: fnd_flex_descval.set_column_value('ATTRIBUTE10', p_attribute10_tbl(i));
3463: fnd_flex_descval.set_column_value('ATTRIBUTE11', p_attribute11_tbl(i));

Line 3460: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_attribute8_tbl(i));

3456: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_attribute4_tbl(i));
3457: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_attribute5_tbl(i));
3458: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_attribute6_tbl(i));
3459: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_attribute7_tbl(i));
3460: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_attribute8_tbl(i));
3461: fnd_flex_descval.set_column_value('ATTRIBUTE9', p_attribute9_tbl(i));
3462: fnd_flex_descval.set_column_value('ATTRIBUTE10', p_attribute10_tbl(i));
3463: fnd_flex_descval.set_column_value('ATTRIBUTE11', p_attribute11_tbl(i));
3464: fnd_flex_descval.set_column_value('ATTRIBUTE12', p_attribute12_tbl(i));

Line 3461: fnd_flex_descval.set_column_value('ATTRIBUTE9', p_attribute9_tbl(i));

3457: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_attribute5_tbl(i));
3458: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_attribute6_tbl(i));
3459: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_attribute7_tbl(i));
3460: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_attribute8_tbl(i));
3461: fnd_flex_descval.set_column_value('ATTRIBUTE9', p_attribute9_tbl(i));
3462: fnd_flex_descval.set_column_value('ATTRIBUTE10', p_attribute10_tbl(i));
3463: fnd_flex_descval.set_column_value('ATTRIBUTE11', p_attribute11_tbl(i));
3464: fnd_flex_descval.set_column_value('ATTRIBUTE12', p_attribute12_tbl(i));
3465: fnd_flex_descval.set_column_value('ATTRIBUTE13', p_attribute13_tbl(i));

Line 3462: fnd_flex_descval.set_column_value('ATTRIBUTE10', p_attribute10_tbl(i));

3458: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_attribute6_tbl(i));
3459: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_attribute7_tbl(i));
3460: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_attribute8_tbl(i));
3461: fnd_flex_descval.set_column_value('ATTRIBUTE9', p_attribute9_tbl(i));
3462: fnd_flex_descval.set_column_value('ATTRIBUTE10', p_attribute10_tbl(i));
3463: fnd_flex_descval.set_column_value('ATTRIBUTE11', p_attribute11_tbl(i));
3464: fnd_flex_descval.set_column_value('ATTRIBUTE12', p_attribute12_tbl(i));
3465: fnd_flex_descval.set_column_value('ATTRIBUTE13', p_attribute13_tbl(i));
3466: fnd_flex_descval.set_column_value('ATTRIBUTE14', p_attribute14_tbl(i));

Line 3463: fnd_flex_descval.set_column_value('ATTRIBUTE11', p_attribute11_tbl(i));

3459: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_attribute7_tbl(i));
3460: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_attribute8_tbl(i));
3461: fnd_flex_descval.set_column_value('ATTRIBUTE9', p_attribute9_tbl(i));
3462: fnd_flex_descval.set_column_value('ATTRIBUTE10', p_attribute10_tbl(i));
3463: fnd_flex_descval.set_column_value('ATTRIBUTE11', p_attribute11_tbl(i));
3464: fnd_flex_descval.set_column_value('ATTRIBUTE12', p_attribute12_tbl(i));
3465: fnd_flex_descval.set_column_value('ATTRIBUTE13', p_attribute13_tbl(i));
3466: fnd_flex_descval.set_column_value('ATTRIBUTE14', p_attribute14_tbl(i));
3467: fnd_flex_descval.set_column_value('ATTRIBUTE15', p_attribute15_tbl(i));

Line 3464: fnd_flex_descval.set_column_value('ATTRIBUTE12', p_attribute12_tbl(i));

3460: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_attribute8_tbl(i));
3461: fnd_flex_descval.set_column_value('ATTRIBUTE9', p_attribute9_tbl(i));
3462: fnd_flex_descval.set_column_value('ATTRIBUTE10', p_attribute10_tbl(i));
3463: fnd_flex_descval.set_column_value('ATTRIBUTE11', p_attribute11_tbl(i));
3464: fnd_flex_descval.set_column_value('ATTRIBUTE12', p_attribute12_tbl(i));
3465: fnd_flex_descval.set_column_value('ATTRIBUTE13', p_attribute13_tbl(i));
3466: fnd_flex_descval.set_column_value('ATTRIBUTE14', p_attribute14_tbl(i));
3467: fnd_flex_descval.set_column_value('ATTRIBUTE15', p_attribute15_tbl(i));
3468:

Line 3465: fnd_flex_descval.set_column_value('ATTRIBUTE13', p_attribute13_tbl(i));

3461: fnd_flex_descval.set_column_value('ATTRIBUTE9', p_attribute9_tbl(i));
3462: fnd_flex_descval.set_column_value('ATTRIBUTE10', p_attribute10_tbl(i));
3463: fnd_flex_descval.set_column_value('ATTRIBUTE11', p_attribute11_tbl(i));
3464: fnd_flex_descval.set_column_value('ATTRIBUTE12', p_attribute12_tbl(i));
3465: fnd_flex_descval.set_column_value('ATTRIBUTE13', p_attribute13_tbl(i));
3466: fnd_flex_descval.set_column_value('ATTRIBUTE14', p_attribute14_tbl(i));
3467: fnd_flex_descval.set_column_value('ATTRIBUTE15', p_attribute15_tbl(i));
3468:
3469: -- If DFF validation fails

Line 3466: fnd_flex_descval.set_column_value('ATTRIBUTE14', p_attribute14_tbl(i));

3462: fnd_flex_descval.set_column_value('ATTRIBUTE10', p_attribute10_tbl(i));
3463: fnd_flex_descval.set_column_value('ATTRIBUTE11', p_attribute11_tbl(i));
3464: fnd_flex_descval.set_column_value('ATTRIBUTE12', p_attribute12_tbl(i));
3465: fnd_flex_descval.set_column_value('ATTRIBUTE13', p_attribute13_tbl(i));
3466: fnd_flex_descval.set_column_value('ATTRIBUTE14', p_attribute14_tbl(i));
3467: fnd_flex_descval.set_column_value('ATTRIBUTE15', p_attribute15_tbl(i));
3468:
3469: -- If DFF validation fails
3470: IF NOT FND_FLEX_DESCVAL.validate_desccols(c_po_appl, p_desc_flex_name)

Line 3467: fnd_flex_descval.set_column_value('ATTRIBUTE15', p_attribute15_tbl(i));

3463: fnd_flex_descval.set_column_value('ATTRIBUTE11', p_attribute11_tbl(i));
3464: fnd_flex_descval.set_column_value('ATTRIBUTE12', p_attribute12_tbl(i));
3465: fnd_flex_descval.set_column_value('ATTRIBUTE13', p_attribute13_tbl(i));
3466: fnd_flex_descval.set_column_value('ATTRIBUTE14', p_attribute14_tbl(i));
3467: fnd_flex_descval.set_column_value('ATTRIBUTE15', p_attribute15_tbl(i));
3468:
3469: -- If DFF validation fails
3470: IF NOT FND_FLEX_DESCVAL.validate_desccols(c_po_appl, p_desc_flex_name)
3471: THEN

Line 3470: IF NOT FND_FLEX_DESCVAL.validate_desccols(c_po_appl, p_desc_flex_name)

3466: fnd_flex_descval.set_column_value('ATTRIBUTE14', p_attribute14_tbl(i));
3467: fnd_flex_descval.set_column_value('ATTRIBUTE15', p_attribute15_tbl(i));
3468:
3469: -- If DFF validation fails
3470: IF NOT FND_FLEX_DESCVAL.validate_desccols(c_po_appl, p_desc_flex_name)
3471: THEN
3472: x_results.add_result(p_entity_type => p_entity_type,
3473: p_entity_id => p_id_tbl(i),
3474: p_column_name => c_attribute || FND_FLEX_DESCVAL.error_segment,

Line 3474: p_column_name => c_attribute || FND_FLEX_DESCVAL.error_segment,

3470: IF NOT FND_FLEX_DESCVAL.validate_desccols(c_po_appl, p_desc_flex_name)
3471: THEN
3472: x_results.add_result(p_entity_type => p_entity_type,
3473: p_entity_id => p_id_tbl(i),
3474: p_column_name => c_attribute || FND_FLEX_DESCVAL.error_segment,
3475: p_column_val => NULL,
3476: p_message_name => c_message_name,
3477: p_token1_name => c_dff_name,
3478: p_token1_value => p_desc_flex_name,

Line 3480: p_token2_value => FND_FLEX_DESCVAL.error_segment);

3476: p_message_name => c_message_name,
3477: p_token1_name => c_dff_name,
3478: p_token1_value => p_desc_flex_name,
3479: p_token2_name => c_segment_num,
3480: p_token2_value => FND_FLEX_DESCVAL.error_segment);
3481: x_result_type := po_validations.c_result_type_failure;
3482: END IF;
3483:
3484: END LOOP;