1199: -- Validate FlexFields
1200: -- ===============================
1201: IF g_award_rec.attribute_category is not NULL THEN
1202:
1203: fnd_flex_descval.set_context_value(g_award_rec.attribute_category) ;
1204:
1205: fnd_flex_descval.set_column_value('ATTRIBUTE1',g_award_rec.attribute1) ;
1206: fnd_flex_descval.set_column_value('ATTRIBUTE2',g_award_rec.attribute2) ;
1207: fnd_flex_descval.set_column_value('ATTRIBUTE3',g_award_rec.attribute3) ;
1201: IF g_award_rec.attribute_category is not NULL THEN
1202:
1203: fnd_flex_descval.set_context_value(g_award_rec.attribute_category) ;
1204:
1205: fnd_flex_descval.set_column_value('ATTRIBUTE1',g_award_rec.attribute1) ;
1206: fnd_flex_descval.set_column_value('ATTRIBUTE2',g_award_rec.attribute2) ;
1207: fnd_flex_descval.set_column_value('ATTRIBUTE3',g_award_rec.attribute3) ;
1208: fnd_flex_descval.set_column_value('ATTRIBUTE4',g_award_rec.attribute4) ;
1209: fnd_flex_descval.set_column_value('ATTRIBUTE5',g_award_rec.attribute5) ;
1202:
1203: fnd_flex_descval.set_context_value(g_award_rec.attribute_category) ;
1204:
1205: fnd_flex_descval.set_column_value('ATTRIBUTE1',g_award_rec.attribute1) ;
1206: fnd_flex_descval.set_column_value('ATTRIBUTE2',g_award_rec.attribute2) ;
1207: fnd_flex_descval.set_column_value('ATTRIBUTE3',g_award_rec.attribute3) ;
1208: fnd_flex_descval.set_column_value('ATTRIBUTE4',g_award_rec.attribute4) ;
1209: fnd_flex_descval.set_column_value('ATTRIBUTE5',g_award_rec.attribute5) ;
1210: fnd_flex_descval.set_column_value('ATTRIBUTE6',g_award_rec.attribute6) ;
1203: fnd_flex_descval.set_context_value(g_award_rec.attribute_category) ;
1204:
1205: fnd_flex_descval.set_column_value('ATTRIBUTE1',g_award_rec.attribute1) ;
1206: fnd_flex_descval.set_column_value('ATTRIBUTE2',g_award_rec.attribute2) ;
1207: fnd_flex_descval.set_column_value('ATTRIBUTE3',g_award_rec.attribute3) ;
1208: fnd_flex_descval.set_column_value('ATTRIBUTE4',g_award_rec.attribute4) ;
1209: fnd_flex_descval.set_column_value('ATTRIBUTE5',g_award_rec.attribute5) ;
1210: fnd_flex_descval.set_column_value('ATTRIBUTE6',g_award_rec.attribute6) ;
1211: fnd_flex_descval.set_column_value('ATTRIBUTE7',g_award_rec.attribute7) ;
1204:
1205: fnd_flex_descval.set_column_value('ATTRIBUTE1',g_award_rec.attribute1) ;
1206: fnd_flex_descval.set_column_value('ATTRIBUTE2',g_award_rec.attribute2) ;
1207: fnd_flex_descval.set_column_value('ATTRIBUTE3',g_award_rec.attribute3) ;
1208: fnd_flex_descval.set_column_value('ATTRIBUTE4',g_award_rec.attribute4) ;
1209: fnd_flex_descval.set_column_value('ATTRIBUTE5',g_award_rec.attribute5) ;
1210: fnd_flex_descval.set_column_value('ATTRIBUTE6',g_award_rec.attribute6) ;
1211: fnd_flex_descval.set_column_value('ATTRIBUTE7',g_award_rec.attribute7) ;
1212: fnd_flex_descval.set_column_value('ATTRIBUTE8',g_award_rec.attribute8) ;
1205: fnd_flex_descval.set_column_value('ATTRIBUTE1',g_award_rec.attribute1) ;
1206: fnd_flex_descval.set_column_value('ATTRIBUTE2',g_award_rec.attribute2) ;
1207: fnd_flex_descval.set_column_value('ATTRIBUTE3',g_award_rec.attribute3) ;
1208: fnd_flex_descval.set_column_value('ATTRIBUTE4',g_award_rec.attribute4) ;
1209: fnd_flex_descval.set_column_value('ATTRIBUTE5',g_award_rec.attribute5) ;
1210: fnd_flex_descval.set_column_value('ATTRIBUTE6',g_award_rec.attribute6) ;
1211: fnd_flex_descval.set_column_value('ATTRIBUTE7',g_award_rec.attribute7) ;
1212: fnd_flex_descval.set_column_value('ATTRIBUTE8',g_award_rec.attribute8) ;
1213: fnd_flex_descval.set_column_value('ATTRIBUTE9',g_award_rec.attribute9) ;
1206: fnd_flex_descval.set_column_value('ATTRIBUTE2',g_award_rec.attribute2) ;
1207: fnd_flex_descval.set_column_value('ATTRIBUTE3',g_award_rec.attribute3) ;
1208: fnd_flex_descval.set_column_value('ATTRIBUTE4',g_award_rec.attribute4) ;
1209: fnd_flex_descval.set_column_value('ATTRIBUTE5',g_award_rec.attribute5) ;
1210: fnd_flex_descval.set_column_value('ATTRIBUTE6',g_award_rec.attribute6) ;
1211: fnd_flex_descval.set_column_value('ATTRIBUTE7',g_award_rec.attribute7) ;
1212: fnd_flex_descval.set_column_value('ATTRIBUTE8',g_award_rec.attribute8) ;
1213: fnd_flex_descval.set_column_value('ATTRIBUTE9',g_award_rec.attribute9) ;
1214: fnd_flex_descval.set_column_value('ATTRIBUTE10',g_award_rec.attribute10) ;
1207: fnd_flex_descval.set_column_value('ATTRIBUTE3',g_award_rec.attribute3) ;
1208: fnd_flex_descval.set_column_value('ATTRIBUTE4',g_award_rec.attribute4) ;
1209: fnd_flex_descval.set_column_value('ATTRIBUTE5',g_award_rec.attribute5) ;
1210: fnd_flex_descval.set_column_value('ATTRIBUTE6',g_award_rec.attribute6) ;
1211: fnd_flex_descval.set_column_value('ATTRIBUTE7',g_award_rec.attribute7) ;
1212: fnd_flex_descval.set_column_value('ATTRIBUTE8',g_award_rec.attribute8) ;
1213: fnd_flex_descval.set_column_value('ATTRIBUTE9',g_award_rec.attribute9) ;
1214: fnd_flex_descval.set_column_value('ATTRIBUTE10',g_award_rec.attribute10) ;
1215: fnd_flex_descval.set_column_value('ATTRIBUTE11',g_award_rec.attribute11) ;
1208: fnd_flex_descval.set_column_value('ATTRIBUTE4',g_award_rec.attribute4) ;
1209: fnd_flex_descval.set_column_value('ATTRIBUTE5',g_award_rec.attribute5) ;
1210: fnd_flex_descval.set_column_value('ATTRIBUTE6',g_award_rec.attribute6) ;
1211: fnd_flex_descval.set_column_value('ATTRIBUTE7',g_award_rec.attribute7) ;
1212: fnd_flex_descval.set_column_value('ATTRIBUTE8',g_award_rec.attribute8) ;
1213: fnd_flex_descval.set_column_value('ATTRIBUTE9',g_award_rec.attribute9) ;
1214: fnd_flex_descval.set_column_value('ATTRIBUTE10',g_award_rec.attribute10) ;
1215: fnd_flex_descval.set_column_value('ATTRIBUTE11',g_award_rec.attribute11) ;
1216: fnd_flex_descval.set_column_value('ATTRIBUTE12',g_award_rec.attribute12) ;
1209: fnd_flex_descval.set_column_value('ATTRIBUTE5',g_award_rec.attribute5) ;
1210: fnd_flex_descval.set_column_value('ATTRIBUTE6',g_award_rec.attribute6) ;
1211: fnd_flex_descval.set_column_value('ATTRIBUTE7',g_award_rec.attribute7) ;
1212: fnd_flex_descval.set_column_value('ATTRIBUTE8',g_award_rec.attribute8) ;
1213: fnd_flex_descval.set_column_value('ATTRIBUTE9',g_award_rec.attribute9) ;
1214: fnd_flex_descval.set_column_value('ATTRIBUTE10',g_award_rec.attribute10) ;
1215: fnd_flex_descval.set_column_value('ATTRIBUTE11',g_award_rec.attribute11) ;
1216: fnd_flex_descval.set_column_value('ATTRIBUTE12',g_award_rec.attribute12) ;
1217: fnd_flex_descval.set_column_value('ATTRIBUTE13',g_award_rec.attribute13) ;
1210: fnd_flex_descval.set_column_value('ATTRIBUTE6',g_award_rec.attribute6) ;
1211: fnd_flex_descval.set_column_value('ATTRIBUTE7',g_award_rec.attribute7) ;
1212: fnd_flex_descval.set_column_value('ATTRIBUTE8',g_award_rec.attribute8) ;
1213: fnd_flex_descval.set_column_value('ATTRIBUTE9',g_award_rec.attribute9) ;
1214: fnd_flex_descval.set_column_value('ATTRIBUTE10',g_award_rec.attribute10) ;
1215: fnd_flex_descval.set_column_value('ATTRIBUTE11',g_award_rec.attribute11) ;
1216: fnd_flex_descval.set_column_value('ATTRIBUTE12',g_award_rec.attribute12) ;
1217: fnd_flex_descval.set_column_value('ATTRIBUTE13',g_award_rec.attribute13) ;
1218: fnd_flex_descval.set_column_value('ATTRIBUTE14',g_award_rec.attribute14) ;
1211: fnd_flex_descval.set_column_value('ATTRIBUTE7',g_award_rec.attribute7) ;
1212: fnd_flex_descval.set_column_value('ATTRIBUTE8',g_award_rec.attribute8) ;
1213: fnd_flex_descval.set_column_value('ATTRIBUTE9',g_award_rec.attribute9) ;
1214: fnd_flex_descval.set_column_value('ATTRIBUTE10',g_award_rec.attribute10) ;
1215: fnd_flex_descval.set_column_value('ATTRIBUTE11',g_award_rec.attribute11) ;
1216: fnd_flex_descval.set_column_value('ATTRIBUTE12',g_award_rec.attribute12) ;
1217: fnd_flex_descval.set_column_value('ATTRIBUTE13',g_award_rec.attribute13) ;
1218: fnd_flex_descval.set_column_value('ATTRIBUTE14',g_award_rec.attribute14) ;
1219: fnd_flex_descval.set_column_value('ATTRIBUTE15',g_award_rec.attribute15) ;
1212: fnd_flex_descval.set_column_value('ATTRIBUTE8',g_award_rec.attribute8) ;
1213: fnd_flex_descval.set_column_value('ATTRIBUTE9',g_award_rec.attribute9) ;
1214: fnd_flex_descval.set_column_value('ATTRIBUTE10',g_award_rec.attribute10) ;
1215: fnd_flex_descval.set_column_value('ATTRIBUTE11',g_award_rec.attribute11) ;
1216: fnd_flex_descval.set_column_value('ATTRIBUTE12',g_award_rec.attribute12) ;
1217: fnd_flex_descval.set_column_value('ATTRIBUTE13',g_award_rec.attribute13) ;
1218: fnd_flex_descval.set_column_value('ATTRIBUTE14',g_award_rec.attribute14) ;
1219: fnd_flex_descval.set_column_value('ATTRIBUTE15',g_award_rec.attribute15) ;
1220: fnd_flex_descval.set_column_value('ATTRIBUTE16',g_award_rec.attribute16) ;
1213: fnd_flex_descval.set_column_value('ATTRIBUTE9',g_award_rec.attribute9) ;
1214: fnd_flex_descval.set_column_value('ATTRIBUTE10',g_award_rec.attribute10) ;
1215: fnd_flex_descval.set_column_value('ATTRIBUTE11',g_award_rec.attribute11) ;
1216: fnd_flex_descval.set_column_value('ATTRIBUTE12',g_award_rec.attribute12) ;
1217: fnd_flex_descval.set_column_value('ATTRIBUTE13',g_award_rec.attribute13) ;
1218: fnd_flex_descval.set_column_value('ATTRIBUTE14',g_award_rec.attribute14) ;
1219: fnd_flex_descval.set_column_value('ATTRIBUTE15',g_award_rec.attribute15) ;
1220: fnd_flex_descval.set_column_value('ATTRIBUTE16',g_award_rec.attribute16) ;
1221: fnd_flex_descval.set_column_value('ATTRIBUTE17',g_award_rec.attribute17) ;
1214: fnd_flex_descval.set_column_value('ATTRIBUTE10',g_award_rec.attribute10) ;
1215: fnd_flex_descval.set_column_value('ATTRIBUTE11',g_award_rec.attribute11) ;
1216: fnd_flex_descval.set_column_value('ATTRIBUTE12',g_award_rec.attribute12) ;
1217: fnd_flex_descval.set_column_value('ATTRIBUTE13',g_award_rec.attribute13) ;
1218: fnd_flex_descval.set_column_value('ATTRIBUTE14',g_award_rec.attribute14) ;
1219: fnd_flex_descval.set_column_value('ATTRIBUTE15',g_award_rec.attribute15) ;
1220: fnd_flex_descval.set_column_value('ATTRIBUTE16',g_award_rec.attribute16) ;
1221: fnd_flex_descval.set_column_value('ATTRIBUTE17',g_award_rec.attribute17) ;
1222: fnd_flex_descval.set_column_value('ATTRIBUTE18',g_award_rec.attribute18) ;
1215: fnd_flex_descval.set_column_value('ATTRIBUTE11',g_award_rec.attribute11) ;
1216: fnd_flex_descval.set_column_value('ATTRIBUTE12',g_award_rec.attribute12) ;
1217: fnd_flex_descval.set_column_value('ATTRIBUTE13',g_award_rec.attribute13) ;
1218: fnd_flex_descval.set_column_value('ATTRIBUTE14',g_award_rec.attribute14) ;
1219: fnd_flex_descval.set_column_value('ATTRIBUTE15',g_award_rec.attribute15) ;
1220: fnd_flex_descval.set_column_value('ATTRIBUTE16',g_award_rec.attribute16) ;
1221: fnd_flex_descval.set_column_value('ATTRIBUTE17',g_award_rec.attribute17) ;
1222: fnd_flex_descval.set_column_value('ATTRIBUTE18',g_award_rec.attribute18) ;
1223: fnd_flex_descval.set_column_value('ATTRIBUTE19',g_award_rec.attribute19) ;
1216: fnd_flex_descval.set_column_value('ATTRIBUTE12',g_award_rec.attribute12) ;
1217: fnd_flex_descval.set_column_value('ATTRIBUTE13',g_award_rec.attribute13) ;
1218: fnd_flex_descval.set_column_value('ATTRIBUTE14',g_award_rec.attribute14) ;
1219: fnd_flex_descval.set_column_value('ATTRIBUTE15',g_award_rec.attribute15) ;
1220: fnd_flex_descval.set_column_value('ATTRIBUTE16',g_award_rec.attribute16) ;
1221: fnd_flex_descval.set_column_value('ATTRIBUTE17',g_award_rec.attribute17) ;
1222: fnd_flex_descval.set_column_value('ATTRIBUTE18',g_award_rec.attribute18) ;
1223: fnd_flex_descval.set_column_value('ATTRIBUTE19',g_award_rec.attribute19) ;
1224: fnd_flex_descval.set_column_value('ATTRIBUTE20',g_award_rec.attribute20) ;
1217: fnd_flex_descval.set_column_value('ATTRIBUTE13',g_award_rec.attribute13) ;
1218: fnd_flex_descval.set_column_value('ATTRIBUTE14',g_award_rec.attribute14) ;
1219: fnd_flex_descval.set_column_value('ATTRIBUTE15',g_award_rec.attribute15) ;
1220: fnd_flex_descval.set_column_value('ATTRIBUTE16',g_award_rec.attribute16) ;
1221: fnd_flex_descval.set_column_value('ATTRIBUTE17',g_award_rec.attribute17) ;
1222: fnd_flex_descval.set_column_value('ATTRIBUTE18',g_award_rec.attribute18) ;
1223: fnd_flex_descval.set_column_value('ATTRIBUTE19',g_award_rec.attribute19) ;
1224: fnd_flex_descval.set_column_value('ATTRIBUTE20',g_award_rec.attribute20) ;
1225: fnd_flex_descval.set_column_value('ATTRIBUTE21',g_award_rec.attribute21) ;
1218: fnd_flex_descval.set_column_value('ATTRIBUTE14',g_award_rec.attribute14) ;
1219: fnd_flex_descval.set_column_value('ATTRIBUTE15',g_award_rec.attribute15) ;
1220: fnd_flex_descval.set_column_value('ATTRIBUTE16',g_award_rec.attribute16) ;
1221: fnd_flex_descval.set_column_value('ATTRIBUTE17',g_award_rec.attribute17) ;
1222: fnd_flex_descval.set_column_value('ATTRIBUTE18',g_award_rec.attribute18) ;
1223: fnd_flex_descval.set_column_value('ATTRIBUTE19',g_award_rec.attribute19) ;
1224: fnd_flex_descval.set_column_value('ATTRIBUTE20',g_award_rec.attribute20) ;
1225: fnd_flex_descval.set_column_value('ATTRIBUTE21',g_award_rec.attribute21) ;
1226: fnd_flex_descval.set_column_value('ATTRIBUTE22',g_award_rec.attribute22) ;
1219: fnd_flex_descval.set_column_value('ATTRIBUTE15',g_award_rec.attribute15) ;
1220: fnd_flex_descval.set_column_value('ATTRIBUTE16',g_award_rec.attribute16) ;
1221: fnd_flex_descval.set_column_value('ATTRIBUTE17',g_award_rec.attribute17) ;
1222: fnd_flex_descval.set_column_value('ATTRIBUTE18',g_award_rec.attribute18) ;
1223: fnd_flex_descval.set_column_value('ATTRIBUTE19',g_award_rec.attribute19) ;
1224: fnd_flex_descval.set_column_value('ATTRIBUTE20',g_award_rec.attribute20) ;
1225: fnd_flex_descval.set_column_value('ATTRIBUTE21',g_award_rec.attribute21) ;
1226: fnd_flex_descval.set_column_value('ATTRIBUTE22',g_award_rec.attribute22) ;
1227: fnd_flex_descval.set_column_value('ATTRIBUTE23',g_award_rec.attribute23) ;
1220: fnd_flex_descval.set_column_value('ATTRIBUTE16',g_award_rec.attribute16) ;
1221: fnd_flex_descval.set_column_value('ATTRIBUTE17',g_award_rec.attribute17) ;
1222: fnd_flex_descval.set_column_value('ATTRIBUTE18',g_award_rec.attribute18) ;
1223: fnd_flex_descval.set_column_value('ATTRIBUTE19',g_award_rec.attribute19) ;
1224: fnd_flex_descval.set_column_value('ATTRIBUTE20',g_award_rec.attribute20) ;
1225: fnd_flex_descval.set_column_value('ATTRIBUTE21',g_award_rec.attribute21) ;
1226: fnd_flex_descval.set_column_value('ATTRIBUTE22',g_award_rec.attribute22) ;
1227: fnd_flex_descval.set_column_value('ATTRIBUTE23',g_award_rec.attribute23) ;
1228: fnd_flex_descval.set_column_value('ATTRIBUTE24',g_award_rec.attribute24) ;
1221: fnd_flex_descval.set_column_value('ATTRIBUTE17',g_award_rec.attribute17) ;
1222: fnd_flex_descval.set_column_value('ATTRIBUTE18',g_award_rec.attribute18) ;
1223: fnd_flex_descval.set_column_value('ATTRIBUTE19',g_award_rec.attribute19) ;
1224: fnd_flex_descval.set_column_value('ATTRIBUTE20',g_award_rec.attribute20) ;
1225: fnd_flex_descval.set_column_value('ATTRIBUTE21',g_award_rec.attribute21) ;
1226: fnd_flex_descval.set_column_value('ATTRIBUTE22',g_award_rec.attribute22) ;
1227: fnd_flex_descval.set_column_value('ATTRIBUTE23',g_award_rec.attribute23) ;
1228: fnd_flex_descval.set_column_value('ATTRIBUTE24',g_award_rec.attribute24) ;
1229: fnd_flex_descval.set_column_value('ATTRIBUTE25',g_award_rec.attribute25) ;
1222: fnd_flex_descval.set_column_value('ATTRIBUTE18',g_award_rec.attribute18) ;
1223: fnd_flex_descval.set_column_value('ATTRIBUTE19',g_award_rec.attribute19) ;
1224: fnd_flex_descval.set_column_value('ATTRIBUTE20',g_award_rec.attribute20) ;
1225: fnd_flex_descval.set_column_value('ATTRIBUTE21',g_award_rec.attribute21) ;
1226: fnd_flex_descval.set_column_value('ATTRIBUTE22',g_award_rec.attribute22) ;
1227: fnd_flex_descval.set_column_value('ATTRIBUTE23',g_award_rec.attribute23) ;
1228: fnd_flex_descval.set_column_value('ATTRIBUTE24',g_award_rec.attribute24) ;
1229: fnd_flex_descval.set_column_value('ATTRIBUTE25',g_award_rec.attribute25) ;
1230:
1223: fnd_flex_descval.set_column_value('ATTRIBUTE19',g_award_rec.attribute19) ;
1224: fnd_flex_descval.set_column_value('ATTRIBUTE20',g_award_rec.attribute20) ;
1225: fnd_flex_descval.set_column_value('ATTRIBUTE21',g_award_rec.attribute21) ;
1226: fnd_flex_descval.set_column_value('ATTRIBUTE22',g_award_rec.attribute22) ;
1227: fnd_flex_descval.set_column_value('ATTRIBUTE23',g_award_rec.attribute23) ;
1228: fnd_flex_descval.set_column_value('ATTRIBUTE24',g_award_rec.attribute24) ;
1229: fnd_flex_descval.set_column_value('ATTRIBUTE25',g_award_rec.attribute25) ;
1230:
1231: IF (FND_FLEX_DESCVAL.validate_desccols ('GMS' ,'GMS_AWARDS_DESC_FLEX')) then
1224: fnd_flex_descval.set_column_value('ATTRIBUTE20',g_award_rec.attribute20) ;
1225: fnd_flex_descval.set_column_value('ATTRIBUTE21',g_award_rec.attribute21) ;
1226: fnd_flex_descval.set_column_value('ATTRIBUTE22',g_award_rec.attribute22) ;
1227: fnd_flex_descval.set_column_value('ATTRIBUTE23',g_award_rec.attribute23) ;
1228: fnd_flex_descval.set_column_value('ATTRIBUTE24',g_award_rec.attribute24) ;
1229: fnd_flex_descval.set_column_value('ATTRIBUTE25',g_award_rec.attribute25) ;
1230:
1231: IF (FND_FLEX_DESCVAL.validate_desccols ('GMS' ,'GMS_AWARDS_DESC_FLEX')) then
1232: -- Validation Passed
1225: fnd_flex_descval.set_column_value('ATTRIBUTE21',g_award_rec.attribute21) ;
1226: fnd_flex_descval.set_column_value('ATTRIBUTE22',g_award_rec.attribute22) ;
1227: fnd_flex_descval.set_column_value('ATTRIBUTE23',g_award_rec.attribute23) ;
1228: fnd_flex_descval.set_column_value('ATTRIBUTE24',g_award_rec.attribute24) ;
1229: fnd_flex_descval.set_column_value('ATTRIBUTE25',g_award_rec.attribute25) ;
1230:
1231: IF (FND_FLEX_DESCVAL.validate_desccols ('GMS' ,'GMS_AWARDS_DESC_FLEX')) then
1232: -- Validation Passed
1233: NULL ;
1227: fnd_flex_descval.set_column_value('ATTRIBUTE23',g_award_rec.attribute23) ;
1228: fnd_flex_descval.set_column_value('ATTRIBUTE24',g_award_rec.attribute24) ;
1229: fnd_flex_descval.set_column_value('ATTRIBUTE25',g_award_rec.attribute25) ;
1230:
1231: IF (FND_FLEX_DESCVAL.validate_desccols ('GMS' ,'GMS_AWARDS_DESC_FLEX')) then
1232: -- Validation Passed
1233: NULL ;
1234: ELSE
1235: add_message_to_stack( P_label => 'GMS_AWD_FLEX_INVALID' ) ;
1234: ELSE
1235: add_message_to_stack( P_label => 'GMS_AWD_FLEX_INVALID' ) ;
1236: fnd_msg_pub.add_exc_msg(p_pkg_name => 'GMS_AWARD_PVT',
1237: p_procedure_name => 'CREATE_AWARD',
1238: p_error_text => substr(FND_FLEX_DESCVAL.error_message,1,240)) ;
1239: l_error := TRUE ;
1240:
1241: END IF ;
1242:
3200: -- Validate FlexFields
3201: -- ===============================
3202: IF g_installment_rec.attribute_category is not NULL THEN
3203:
3204: fnd_flex_descval.set_context_value(g_installment_rec.attribute_category) ;
3205:
3206: fnd_flex_descval.set_column_value('ATTRIBUTE1',g_installment_rec.attribute1) ;
3207: fnd_flex_descval.set_column_value('ATTRIBUTE2',g_installment_rec.attribute2) ;
3208: fnd_flex_descval.set_column_value('ATTRIBUTE3',g_installment_rec.attribute3) ;
3202: IF g_installment_rec.attribute_category is not NULL THEN
3203:
3204: fnd_flex_descval.set_context_value(g_installment_rec.attribute_category) ;
3205:
3206: fnd_flex_descval.set_column_value('ATTRIBUTE1',g_installment_rec.attribute1) ;
3207: fnd_flex_descval.set_column_value('ATTRIBUTE2',g_installment_rec.attribute2) ;
3208: fnd_flex_descval.set_column_value('ATTRIBUTE3',g_installment_rec.attribute3) ;
3209: fnd_flex_descval.set_column_value('ATTRIBUTE4',g_installment_rec.attribute4) ;
3210: fnd_flex_descval.set_column_value('ATTRIBUTE5',g_installment_rec.attribute5) ;
3203:
3204: fnd_flex_descval.set_context_value(g_installment_rec.attribute_category) ;
3205:
3206: fnd_flex_descval.set_column_value('ATTRIBUTE1',g_installment_rec.attribute1) ;
3207: fnd_flex_descval.set_column_value('ATTRIBUTE2',g_installment_rec.attribute2) ;
3208: fnd_flex_descval.set_column_value('ATTRIBUTE3',g_installment_rec.attribute3) ;
3209: fnd_flex_descval.set_column_value('ATTRIBUTE4',g_installment_rec.attribute4) ;
3210: fnd_flex_descval.set_column_value('ATTRIBUTE5',g_installment_rec.attribute5) ;
3211: fnd_flex_descval.set_column_value('ATTRIBUTE6',g_installment_rec.attribute6) ;
3204: fnd_flex_descval.set_context_value(g_installment_rec.attribute_category) ;
3205:
3206: fnd_flex_descval.set_column_value('ATTRIBUTE1',g_installment_rec.attribute1) ;
3207: fnd_flex_descval.set_column_value('ATTRIBUTE2',g_installment_rec.attribute2) ;
3208: fnd_flex_descval.set_column_value('ATTRIBUTE3',g_installment_rec.attribute3) ;
3209: fnd_flex_descval.set_column_value('ATTRIBUTE4',g_installment_rec.attribute4) ;
3210: fnd_flex_descval.set_column_value('ATTRIBUTE5',g_installment_rec.attribute5) ;
3211: fnd_flex_descval.set_column_value('ATTRIBUTE6',g_installment_rec.attribute6) ;
3212: fnd_flex_descval.set_column_value('ATTRIBUTE7',g_installment_rec.attribute7) ;
3205:
3206: fnd_flex_descval.set_column_value('ATTRIBUTE1',g_installment_rec.attribute1) ;
3207: fnd_flex_descval.set_column_value('ATTRIBUTE2',g_installment_rec.attribute2) ;
3208: fnd_flex_descval.set_column_value('ATTRIBUTE3',g_installment_rec.attribute3) ;
3209: fnd_flex_descval.set_column_value('ATTRIBUTE4',g_installment_rec.attribute4) ;
3210: fnd_flex_descval.set_column_value('ATTRIBUTE5',g_installment_rec.attribute5) ;
3211: fnd_flex_descval.set_column_value('ATTRIBUTE6',g_installment_rec.attribute6) ;
3212: fnd_flex_descval.set_column_value('ATTRIBUTE7',g_installment_rec.attribute7) ;
3213: fnd_flex_descval.set_column_value('ATTRIBUTE8',g_installment_rec.attribute8) ;
3206: fnd_flex_descval.set_column_value('ATTRIBUTE1',g_installment_rec.attribute1) ;
3207: fnd_flex_descval.set_column_value('ATTRIBUTE2',g_installment_rec.attribute2) ;
3208: fnd_flex_descval.set_column_value('ATTRIBUTE3',g_installment_rec.attribute3) ;
3209: fnd_flex_descval.set_column_value('ATTRIBUTE4',g_installment_rec.attribute4) ;
3210: fnd_flex_descval.set_column_value('ATTRIBUTE5',g_installment_rec.attribute5) ;
3211: fnd_flex_descval.set_column_value('ATTRIBUTE6',g_installment_rec.attribute6) ;
3212: fnd_flex_descval.set_column_value('ATTRIBUTE7',g_installment_rec.attribute7) ;
3213: fnd_flex_descval.set_column_value('ATTRIBUTE8',g_installment_rec.attribute8) ;
3214: fnd_flex_descval.set_column_value('ATTRIBUTE9',g_installment_rec.attribute9) ;
3207: fnd_flex_descval.set_column_value('ATTRIBUTE2',g_installment_rec.attribute2) ;
3208: fnd_flex_descval.set_column_value('ATTRIBUTE3',g_installment_rec.attribute3) ;
3209: fnd_flex_descval.set_column_value('ATTRIBUTE4',g_installment_rec.attribute4) ;
3210: fnd_flex_descval.set_column_value('ATTRIBUTE5',g_installment_rec.attribute5) ;
3211: fnd_flex_descval.set_column_value('ATTRIBUTE6',g_installment_rec.attribute6) ;
3212: fnd_flex_descval.set_column_value('ATTRIBUTE7',g_installment_rec.attribute7) ;
3213: fnd_flex_descval.set_column_value('ATTRIBUTE8',g_installment_rec.attribute8) ;
3214: fnd_flex_descval.set_column_value('ATTRIBUTE9',g_installment_rec.attribute9) ;
3215: fnd_flex_descval.set_column_value('ATTRIBUTE10',g_installment_rec.attribute10) ;
3208: fnd_flex_descval.set_column_value('ATTRIBUTE3',g_installment_rec.attribute3) ;
3209: fnd_flex_descval.set_column_value('ATTRIBUTE4',g_installment_rec.attribute4) ;
3210: fnd_flex_descval.set_column_value('ATTRIBUTE5',g_installment_rec.attribute5) ;
3211: fnd_flex_descval.set_column_value('ATTRIBUTE6',g_installment_rec.attribute6) ;
3212: fnd_flex_descval.set_column_value('ATTRIBUTE7',g_installment_rec.attribute7) ;
3213: fnd_flex_descval.set_column_value('ATTRIBUTE8',g_installment_rec.attribute8) ;
3214: fnd_flex_descval.set_column_value('ATTRIBUTE9',g_installment_rec.attribute9) ;
3215: fnd_flex_descval.set_column_value('ATTRIBUTE10',g_installment_rec.attribute10) ;
3216: fnd_flex_descval.set_column_value('ATTRIBUTE11',g_installment_rec.attribute11) ;
3209: fnd_flex_descval.set_column_value('ATTRIBUTE4',g_installment_rec.attribute4) ;
3210: fnd_flex_descval.set_column_value('ATTRIBUTE5',g_installment_rec.attribute5) ;
3211: fnd_flex_descval.set_column_value('ATTRIBUTE6',g_installment_rec.attribute6) ;
3212: fnd_flex_descval.set_column_value('ATTRIBUTE7',g_installment_rec.attribute7) ;
3213: fnd_flex_descval.set_column_value('ATTRIBUTE8',g_installment_rec.attribute8) ;
3214: fnd_flex_descval.set_column_value('ATTRIBUTE9',g_installment_rec.attribute9) ;
3215: fnd_flex_descval.set_column_value('ATTRIBUTE10',g_installment_rec.attribute10) ;
3216: fnd_flex_descval.set_column_value('ATTRIBUTE11',g_installment_rec.attribute11) ;
3217: fnd_flex_descval.set_column_value('ATTRIBUTE12',g_installment_rec.attribute12) ;
3210: fnd_flex_descval.set_column_value('ATTRIBUTE5',g_installment_rec.attribute5) ;
3211: fnd_flex_descval.set_column_value('ATTRIBUTE6',g_installment_rec.attribute6) ;
3212: fnd_flex_descval.set_column_value('ATTRIBUTE7',g_installment_rec.attribute7) ;
3213: fnd_flex_descval.set_column_value('ATTRIBUTE8',g_installment_rec.attribute8) ;
3214: fnd_flex_descval.set_column_value('ATTRIBUTE9',g_installment_rec.attribute9) ;
3215: fnd_flex_descval.set_column_value('ATTRIBUTE10',g_installment_rec.attribute10) ;
3216: fnd_flex_descval.set_column_value('ATTRIBUTE11',g_installment_rec.attribute11) ;
3217: fnd_flex_descval.set_column_value('ATTRIBUTE12',g_installment_rec.attribute12) ;
3218: fnd_flex_descval.set_column_value('ATTRIBUTE13',g_installment_rec.attribute13) ;
3211: fnd_flex_descval.set_column_value('ATTRIBUTE6',g_installment_rec.attribute6) ;
3212: fnd_flex_descval.set_column_value('ATTRIBUTE7',g_installment_rec.attribute7) ;
3213: fnd_flex_descval.set_column_value('ATTRIBUTE8',g_installment_rec.attribute8) ;
3214: fnd_flex_descval.set_column_value('ATTRIBUTE9',g_installment_rec.attribute9) ;
3215: fnd_flex_descval.set_column_value('ATTRIBUTE10',g_installment_rec.attribute10) ;
3216: fnd_flex_descval.set_column_value('ATTRIBUTE11',g_installment_rec.attribute11) ;
3217: fnd_flex_descval.set_column_value('ATTRIBUTE12',g_installment_rec.attribute12) ;
3218: fnd_flex_descval.set_column_value('ATTRIBUTE13',g_installment_rec.attribute13) ;
3219: fnd_flex_descval.set_column_value('ATTRIBUTE14',g_installment_rec.attribute14) ;
3212: fnd_flex_descval.set_column_value('ATTRIBUTE7',g_installment_rec.attribute7) ;
3213: fnd_flex_descval.set_column_value('ATTRIBUTE8',g_installment_rec.attribute8) ;
3214: fnd_flex_descval.set_column_value('ATTRIBUTE9',g_installment_rec.attribute9) ;
3215: fnd_flex_descval.set_column_value('ATTRIBUTE10',g_installment_rec.attribute10) ;
3216: fnd_flex_descval.set_column_value('ATTRIBUTE11',g_installment_rec.attribute11) ;
3217: fnd_flex_descval.set_column_value('ATTRIBUTE12',g_installment_rec.attribute12) ;
3218: fnd_flex_descval.set_column_value('ATTRIBUTE13',g_installment_rec.attribute13) ;
3219: fnd_flex_descval.set_column_value('ATTRIBUTE14',g_installment_rec.attribute14) ;
3220: fnd_flex_descval.set_column_value('ATTRIBUTE15',g_installment_rec.attribute15) ;
3213: fnd_flex_descval.set_column_value('ATTRIBUTE8',g_installment_rec.attribute8) ;
3214: fnd_flex_descval.set_column_value('ATTRIBUTE9',g_installment_rec.attribute9) ;
3215: fnd_flex_descval.set_column_value('ATTRIBUTE10',g_installment_rec.attribute10) ;
3216: fnd_flex_descval.set_column_value('ATTRIBUTE11',g_installment_rec.attribute11) ;
3217: fnd_flex_descval.set_column_value('ATTRIBUTE12',g_installment_rec.attribute12) ;
3218: fnd_flex_descval.set_column_value('ATTRIBUTE13',g_installment_rec.attribute13) ;
3219: fnd_flex_descval.set_column_value('ATTRIBUTE14',g_installment_rec.attribute14) ;
3220: fnd_flex_descval.set_column_value('ATTRIBUTE15',g_installment_rec.attribute15) ;
3221:
3214: fnd_flex_descval.set_column_value('ATTRIBUTE9',g_installment_rec.attribute9) ;
3215: fnd_flex_descval.set_column_value('ATTRIBUTE10',g_installment_rec.attribute10) ;
3216: fnd_flex_descval.set_column_value('ATTRIBUTE11',g_installment_rec.attribute11) ;
3217: fnd_flex_descval.set_column_value('ATTRIBUTE12',g_installment_rec.attribute12) ;
3218: fnd_flex_descval.set_column_value('ATTRIBUTE13',g_installment_rec.attribute13) ;
3219: fnd_flex_descval.set_column_value('ATTRIBUTE14',g_installment_rec.attribute14) ;
3220: fnd_flex_descval.set_column_value('ATTRIBUTE15',g_installment_rec.attribute15) ;
3221:
3222: IF (FND_FLEX_DESCVAL.validate_desccols ('GMS' ,'GMS_AWARDS_DESC_FLEX')) then
3215: fnd_flex_descval.set_column_value('ATTRIBUTE10',g_installment_rec.attribute10) ;
3216: fnd_flex_descval.set_column_value('ATTRIBUTE11',g_installment_rec.attribute11) ;
3217: fnd_flex_descval.set_column_value('ATTRIBUTE12',g_installment_rec.attribute12) ;
3218: fnd_flex_descval.set_column_value('ATTRIBUTE13',g_installment_rec.attribute13) ;
3219: fnd_flex_descval.set_column_value('ATTRIBUTE14',g_installment_rec.attribute14) ;
3220: fnd_flex_descval.set_column_value('ATTRIBUTE15',g_installment_rec.attribute15) ;
3221:
3222: IF (FND_FLEX_DESCVAL.validate_desccols ('GMS' ,'GMS_AWARDS_DESC_FLEX')) then
3223: -- Validation Passed
3216: fnd_flex_descval.set_column_value('ATTRIBUTE11',g_installment_rec.attribute11) ;
3217: fnd_flex_descval.set_column_value('ATTRIBUTE12',g_installment_rec.attribute12) ;
3218: fnd_flex_descval.set_column_value('ATTRIBUTE13',g_installment_rec.attribute13) ;
3219: fnd_flex_descval.set_column_value('ATTRIBUTE14',g_installment_rec.attribute14) ;
3220: fnd_flex_descval.set_column_value('ATTRIBUTE15',g_installment_rec.attribute15) ;
3221:
3222: IF (FND_FLEX_DESCVAL.validate_desccols ('GMS' ,'GMS_AWARDS_DESC_FLEX')) then
3223: -- Validation Passed
3224: NULL ;
3218: fnd_flex_descval.set_column_value('ATTRIBUTE13',g_installment_rec.attribute13) ;
3219: fnd_flex_descval.set_column_value('ATTRIBUTE14',g_installment_rec.attribute14) ;
3220: fnd_flex_descval.set_column_value('ATTRIBUTE15',g_installment_rec.attribute15) ;
3221:
3222: IF (FND_FLEX_DESCVAL.validate_desccols ('GMS' ,'GMS_AWARDS_DESC_FLEX')) then
3223: -- Validation Passed
3224: NULL ;
3225: ELSE
3226: add_message_to_stack( P_label => 'GMS_AWD_FLEX_INVALID' ) ;
3225: ELSE
3226: add_message_to_stack( P_label => 'GMS_AWD_FLEX_INVALID' ) ;
3227: fnd_msg_pub.add_exc_msg(p_pkg_name => 'GMS_AWARD_PVT',
3228: p_procedure_name => 'CREATE_INSTALLMENT',
3229: p_error_text => substr(FND_FLEX_DESCVAL.error_message,1,240)) ;
3230: l_error := TRUE ;
3231:
3232: END IF ;
3233: